DBA Data[Home] [Help]

APPS.OZF_RELATED_LINES_PVT dependencies on FND_MSG_PUB

Line 87: FND_MSG_PUB.initialize;

83:
84: -- Initialize message list if p_init_msg_list is set to TRUE.
85: IF FND_API.to_Boolean( p_init_msg_list )
86: THEN
87: FND_MSG_PUB.initialize;
88: END IF;
89:
90: -- Debug Message
91: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 184: FND_MSG_PUB.Count_And_Get

180: -- Debug Message
181: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
182:
183: -- Standard call to get message count and if count is 1, get message info.
184: FND_MSG_PUB.Count_And_Get
185: (p_count => x_msg_count,
186: p_data => x_msg_data
187: );
188: EXCEPTION

Line 198: FND_MSG_PUB.Count_And_Get (

194: WHEN FND_API.G_EXC_ERROR THEN
195: ROLLBACK TO CREATE_Related_Lines_PVT;
196: x_return_status := FND_API.G_RET_STS_ERROR;
197: -- Standard call to get message count and if count=1, get the message
198: FND_MSG_PUB.Count_And_Get (
199: p_encoded => FND_API.G_FALSE,
200: p_count => x_msg_count,
201: p_data => x_msg_data
202: );

Line 208: FND_MSG_PUB.Count_And_Get (

204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
205: ROLLBACK TO CREATE_Related_Lines_PVT;
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: -- Standard call to get message count and if count=1, get the message
208: FND_MSG_PUB.Count_And_Get (
209: p_encoded => FND_API.G_FALSE,
210: p_count => x_msg_count,
211: p_data => x_msg_data
212: );

Line 217: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

213:
214: WHEN OTHERS THEN
215: ROLLBACK TO CREATE_Related_Lines_PVT;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
218: THEN
219: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
220: END IF;
221: -- Standard call to get message count and if count=1, get the message

Line 219: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

215: ROLLBACK TO CREATE_Related_Lines_PVT;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
218: THEN
219: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
220: END IF;
221: -- Standard call to get message count and if count=1, get the message
222: FND_MSG_PUB.Count_And_Get (
223: p_encoded => FND_API.G_FALSE,

Line 222: FND_MSG_PUB.Count_And_Get (

218: THEN
219: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
220: END IF;
221: -- Standard call to get message count and if count=1, get the message
222: FND_MSG_PUB.Count_And_Get (
223: p_encoded => FND_API.G_FALSE,
224: p_count => x_msg_count,
225: p_data => x_msg_data
226: );

Line 282: FND_MSG_PUB.initialize;

278:
279: -- Initialize message list if p_init_msg_list is set to TRUE.
280: IF FND_API.to_Boolean( p_init_msg_list )
281: THEN
282: FND_MSG_PUB.initialize;
283: END IF;
284:
285: -- Debug Message
286: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 351: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

347: END IF;
348: OZF_UTILITY_PVT.debug_message('Private API: Validate_Related_Lines ended successfully');
349:
350: -- Debug Message
351: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
352:
353: -- Invoke table handler(OZF_RELATED_DEAL_LINES_PKG.Update_Row)
354: OZF_UTILITY_PVT.debug_message('callin update row');
355: OZF_RELATED_DEAL_LINES_PKG.Update_Row(

Line 385: FND_MSG_PUB.Count_And_Get

381: -- Debug Message
382: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
383:
384: -- Standard call to get message count and if count is 1, get message info.
385: FND_MSG_PUB.Count_And_Get
386: (p_count => x_msg_count,
387: p_data => x_msg_data
388: );
389: EXCEPTION

Line 399: FND_MSG_PUB.Count_And_Get (

395: WHEN FND_API.G_EXC_ERROR THEN
396: ROLLBACK TO UPDATE_Related_Lines_PVT;
397: x_return_status := FND_API.G_RET_STS_ERROR;
398: -- Standard call to get message count and if count=1, get the message
399: FND_MSG_PUB.Count_And_Get (
400: p_encoded => FND_API.G_FALSE,
401: p_count => x_msg_count,
402: p_data => x_msg_data
403: );

Line 409: FND_MSG_PUB.Count_And_Get (

405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406: ROLLBACK TO UPDATE_Related_Lines_PVT;
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: -- Standard call to get message count and if count=1, get the message
409: FND_MSG_PUB.Count_And_Get (
410: p_encoded => FND_API.G_FALSE,
411: p_count => x_msg_count,
412: p_data => x_msg_data
413: );

Line 418: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

414:
415: WHEN OTHERS THEN
416: ROLLBACK TO UPDATE_Related_Lines_PVT;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
419: THEN
420: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
421: END IF;
422: -- Standard call to get message count and if count=1, get the message

Line 420: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

416: ROLLBACK TO UPDATE_Related_Lines_PVT;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
419: THEN
420: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
421: END IF;
422: -- Standard call to get message count and if count=1, get the message
423: FND_MSG_PUB.Count_And_Get (
424: p_encoded => FND_API.G_FALSE,

Line 423: FND_MSG_PUB.Count_And_Get (

419: THEN
420: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
421: END IF;
422: -- Standard call to get message count and if count=1, get the message
423: FND_MSG_PUB.Count_And_Get (
424: p_encoded => FND_API.G_FALSE,
425: p_count => x_msg_count,
426: p_data => x_msg_data
427: );

Line 464: FND_MSG_PUB.initialize;

460:
461: -- Initialize message list if p_init_msg_list is set to TRUE.
462: IF FND_API.to_Boolean( p_init_msg_list )
463: THEN
464: FND_MSG_PUB.initialize;
465: END IF;
466:
467: -- Debug Message
468: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 498: FND_MSG_PUB.Count_And_Get

494: -- Debug Message
495: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
496:
497: -- Standard call to get message count and if count is 1, get message info.
498: FND_MSG_PUB.Count_And_Get
499: (p_count => x_msg_count,
500: p_data => x_msg_data
501: );
502: EXCEPTION

Line 512: FND_MSG_PUB.Count_And_Get (

508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO DELETE_Related_Lines_PVT;
510: x_return_status := FND_API.G_RET_STS_ERROR;
511: -- Standard call to get message count and if count=1, get the message
512: FND_MSG_PUB.Count_And_Get (
513: p_encoded => FND_API.G_FALSE,
514: p_count => x_msg_count,
515: p_data => x_msg_data
516: );

Line 522: FND_MSG_PUB.Count_And_Get (

518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519: ROLLBACK TO DELETE_Related_Lines_PVT;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521: -- Standard call to get message count and if count=1, get the message
522: FND_MSG_PUB.Count_And_Get (
523: p_encoded => FND_API.G_FALSE,
524: p_count => x_msg_count,
525: p_data => x_msg_data
526: );

Line 531: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

527:
528: WHEN OTHERS THEN
529: ROLLBACK TO DELETE_Related_Lines_PVT;
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
532: THEN
533: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
534: END IF;
535: -- Standard call to get message count and if count=1, get the message

Line 533: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

529: ROLLBACK TO DELETE_Related_Lines_PVT;
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
532: THEN
533: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
534: END IF;
535: -- Standard call to get message count and if count=1, get the message
536: FND_MSG_PUB.Count_And_Get (
537: p_encoded => FND_API.G_FALSE,

Line 536: FND_MSG_PUB.Count_And_Get (

532: THEN
533: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
534: END IF;
535: -- Standard call to get message count and if count=1, get the message
536: FND_MSG_PUB.Count_And_Get (
537: p_encoded => FND_API.G_FALSE,
538: p_count => x_msg_count,
539: p_data => x_msg_data
540: );

Line 579: FND_MSG_PUB.initialize;

575:
576: -- Initialize message list if p_init_msg_list is set to TRUE.
577: IF FND_API.to_Boolean( p_init_msg_list )
578: THEN
579: FND_MSG_PUB.initialize;
580: END IF;
581:
582: -- Standard call to check for call compatibility.
583: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 605: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

601: FETCH c_Related_Lines INTO l_RELATED_DEAL_LINES_ID;
602:
603: IF (c_Related_Lines%NOTFOUND) THEN
604: CLOSE c_Related_Lines;
605: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
606: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
607: FND_MSG_PUB.add;
608: END IF;
609: RAISE FND_API.g_exc_error;

Line 607: FND_MSG_PUB.add;

603: IF (c_Related_Lines%NOTFOUND) THEN
604: CLOSE c_Related_Lines;
605: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
606: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
607: FND_MSG_PUB.add;
608: END IF;
609: RAISE FND_API.g_exc_error;
610: END IF;
611:

Line 615: FND_MSG_PUB.count_and_get(

611:
612: CLOSE c_Related_Lines;
613:
614: -------------------- finish --------------------------
615: FND_MSG_PUB.count_and_get(
616: p_encoded => FND_API.g_false,
617: p_count => x_msg_count,
618: p_data => x_msg_data);
619: OZF_Utility_PVT.debug_message(l_full_name ||': end');

Line 630: FND_MSG_PUB.Count_And_Get (

626: WHEN FND_API.G_EXC_ERROR THEN
627: ROLLBACK TO LOCK_Related_Lines_PVT;
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: -- Standard call to get message count and if count=1, get the message
630: FND_MSG_PUB.Count_And_Get (
631: p_encoded => FND_API.G_FALSE,
632: p_count => x_msg_count,
633: p_data => x_msg_data
634: );

Line 640: FND_MSG_PUB.Count_And_Get (

636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
637: ROLLBACK TO LOCK_Related_Lines_PVT;
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: -- Standard call to get message count and if count=1, get the message
640: FND_MSG_PUB.Count_And_Get (
641: p_encoded => FND_API.G_FALSE,
642: p_count => x_msg_count,
643: p_data => x_msg_data
644: );

Line 649: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

645:
646: WHEN OTHERS THEN
647: ROLLBACK TO LOCK_Related_Lines_PVT;
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
652: END IF;
653: -- Standard call to get message count and if count=1, get the message

Line 651: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

647: ROLLBACK TO LOCK_Related_Lines_PVT;
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
652: END IF;
653: -- Standard call to get message count and if count=1, get the message
654: FND_MSG_PUB.Count_And_Get (
655: p_encoded => FND_API.G_FALSE,

Line 654: FND_MSG_PUB.Count_And_Get (

650: THEN
651: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
652: END IF;
653: -- Standard call to get message count and if count=1, get the message
654: FND_MSG_PUB.Count_And_Get (
655: p_encoded => FND_API.G_FALSE,
656: p_count => x_msg_count,
657: p_data => x_msg_data
658: );

Line 1121: FND_MSG_PUB.initialize;

1117:
1118: -- Initialize message list if p_init_msg_list is set to TRUE.
1119: IF FND_API.to_Boolean( p_init_msg_list )
1120: THEN
1121: FND_MSG_PUB.initialize;
1122: END IF;
1123:
1124:
1125:

Line 1175: FND_MSG_PUB.Count_And_Get

1171: -- Debug Message
1172: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1173:
1174: -- Standard call to get message count and if count is 1, get message info.
1175: FND_MSG_PUB.Count_And_Get
1176: (p_count => x_msg_count,
1177: p_data => x_msg_data
1178: );
1179: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');

Line 1190: FND_MSG_PUB.Count_And_Get (

1186: WHEN FND_API.G_EXC_ERROR THEN
1187: ROLLBACK TO VALIDATE_Related_Lines_;
1188: x_return_status := FND_API.G_RET_STS_ERROR;
1189: -- Standard call to get message count and if count=1, get the message
1190: FND_MSG_PUB.Count_And_Get (
1191: p_encoded => FND_API.G_FALSE,
1192: p_count => x_msg_count,
1193: p_data => x_msg_data
1194: );

Line 1200: FND_MSG_PUB.Count_And_Get (

1196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1197: ROLLBACK TO VALIDATE_Related_Lines_;
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1199: -- Standard call to get message count and if count=1, get the message
1200: FND_MSG_PUB.Count_And_Get (
1201: p_encoded => FND_API.G_FALSE,
1202: p_count => x_msg_count,
1203: p_data => x_msg_data
1204: );

Line 1209: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1205:
1206: WHEN OTHERS THEN
1207: ROLLBACK TO VALIDATE_Related_Lines_;
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1209: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1210: THEN
1211: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1212: END IF;
1213: -- Standard call to get message count and if count=1, get the message

Line 1211: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1207: ROLLBACK TO VALIDATE_Related_Lines_;
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1209: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1210: THEN
1211: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1212: END IF;
1213: -- Standard call to get message count and if count=1, get the message
1214: FND_MSG_PUB.Count_And_Get (
1215: p_encoded => FND_API.G_FALSE,

Line 1214: FND_MSG_PUB.Count_And_Get (

1210: THEN
1211: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1212: END IF;
1213: -- Standard call to get message count and if count=1, get the message
1214: FND_MSG_PUB.Count_And_Get (
1215: p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data
1218: );

Line 1235: FND_MSG_PUB.initialize;

1231: BEGIN
1232: -- Initialize message list if p_init_msg_list is set to TRUE.
1233: IF FND_API.to_Boolean( p_init_msg_list )
1234: THEN
1235: FND_MSG_PUB.initialize;
1236: END IF;
1237:
1238: -- Initialize API return status to SUCCESS
1239: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1249: FND_MSG_PUB.Count_And_Get

1245:
1246: -- Debug Message
1247: OZF_UTILITY_PVT.debug_message('Private API: Validate_related_lines_rec');
1248: -- Standard call to get message count and if count is 1, get message info.
1249: FND_MSG_PUB.Count_And_Get
1250: (p_count => x_msg_count,
1251: p_data => x_msg_data
1252: );
1253: END Validate_related_lines_Rec;