61:
62: -- Initialize message list if p_init_msg_list is set to TRUE.
63: IF FND_API.to_Boolean( p_init_msg_list )
64: THEN
65: FND_MSG_PUB.initialize;
66: END IF;
67:
68: -- Initialize API return status to SUCCESS
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
75: -- Validate Environment
76: -- ******************************************************************
77: IF FND_GLOBAL.User_Id IS NULL
78: THEN
79: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
80: THEN
81: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
82: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
83: FND_MSG_PUB.ADD;
79: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
80: THEN
81: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
82: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
83: FND_MSG_PUB.ADD;
84: END IF;
85: RAISE FND_API.G_EXC_ERROR;
86: END IF;
87: -- IF PG_DEBUG < 10 THEN
111: (p_writeoffs_rec.writeoff_type= FND_API.G_MISS_CHAR) THEN
112: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
113: fnd_message.set_token('API_NAME', l_api_name);
114: fnd_message.set_token('MISSING_PARAM', 'writeoff_type');
115: fnd_msg_pub.add;
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:
119: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
124: (p_writeoffs_rec.writeoff_reason= FND_API.G_MISS_CHAR) THEN
125: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
126: fnd_message.set_token('API_NAME', l_api_name);
127: fnd_message.set_token('MISSING_PARAM', 'writeoff_reason');
128: fnd_msg_pub.add;
129: RAISE FND_API.G_EXC_ERROR;
130: END IF;
131:
132: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
137: (p_writeoffs_rec.party_id = FND_API.G_MISS_NUM) THEN
138: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
139: fnd_message.set_token('API_NAME', l_api_name);
140: fnd_message.set_token('MISSING_PARAM', 'party_id');
141: fnd_msg_pub.add;
142: RAISE FND_API.G_EXC_ERROR;
143: END IF;
144: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
145: IEX_DEBUG_PUB.LogMessage('Create_writeoffs: ' || 'After party_id Check ');
235:
236:
237:
238: -- Standard call to get message count and if count is 1, get message info.
239: FND_MSG_PUB.Count_And_Get
240: ( p_count => x_msg_count,
241: p_data => x_msg_data
242: );
243: -- IF PG_DEBUG < 10 THEN
250: WHEN FND_API.G_EXC_ERROR THEN
251: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
252: P_API_NAME => L_API_NAME
253: ,P_PKG_NAME => G_PKG_NAME
254: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
255: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
256: ,X_MSG_COUNT => X_MSG_COUNT
257: ,X_MSG_DATA => X_MSG_DATA
258: ,X_RETURN_STATUS => X_RETURN_STATUS);
260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
261: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
262: P_API_NAME => L_API_NAME
263: ,P_PKG_NAME => G_PKG_NAME
264: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
265: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
266: ,X_MSG_COUNT => X_MSG_COUNT
267: ,X_MSG_DATA => X_MSG_DATA
268: ,X_RETURN_STATUS => X_RETURN_STATUS);
321:
322: -- Initialize message list if p_init_msg_list is set to TRUE.
323: IF FND_API.to_Boolean( p_init_msg_list )
324: THEN
325: FND_MSG_PUB.initialize;
326: END IF;
327:
328:
329:
421: COMMIT WORK;
422: END IF;
423:
424: -- Standard call to get message count and if count is 1, get message info.
425: FND_MSG_PUB.Count_And_Get
426: ( p_count => x_msg_count,
427: p_data => x_msg_data
428: );
429:
438: WHEN FND_API.G_EXC_ERROR THEN
439: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
440: P_API_NAME => L_API_NAME
441: ,P_PKG_NAME => G_PKG_NAME
442: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
443: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
444: ,X_MSG_COUNT => X_MSG_COUNT
445: ,X_MSG_DATA => X_MSG_DATA
446: ,X_RETURN_STATUS => X_RETURN_STATUS);
448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
449: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
450: P_API_NAME => L_API_NAME
451: ,P_PKG_NAME => G_PKG_NAME
452: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
453: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
454: ,X_MSG_COUNT => X_MSG_COUNT
455: ,X_MSG_DATA => X_MSG_DATA
456: ,X_RETURN_STATUS => X_RETURN_STATUS);
507:
508: -- Initialize message list if p_init_msg_list is set to TRUE.
509: IF FND_API.to_Boolean( p_init_msg_list )
510: THEN
511: FND_MSG_PUB.initialize;
512: END IF;
513:
514:
515:
541: END IF;
542:
543:
544: -- Standard call to get message count and if count is 1, get message info.
545: FND_MSG_PUB.Count_And_Get
546: ( p_count => x_msg_count,
547: p_data => x_msg_data
548: );
549:
551: WHEN FND_API.G_EXC_ERROR THEN
552: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
553: P_API_NAME => L_API_NAME
554: ,P_PKG_NAME => G_PKG_NAME
555: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
556: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
557: ,X_MSG_COUNT => X_MSG_COUNT
558: ,X_MSG_DATA => X_MSG_DATA
559: ,X_RETURN_STATUS => X_RETURN_STATUS);
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
563: P_API_NAME => L_API_NAME
564: ,P_PKG_NAME => G_PKG_NAME
565: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
566: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
567: ,X_MSG_COUNT => X_MSG_COUNT
568: ,X_MSG_DATA => X_MSG_DATA
569: ,X_RETURN_STATUS => X_RETURN_STATUS);