DBA Data[Home] [Help]

APPS.OZF_RELATED_LINES_PVT dependencies on FND_MSG_PUB

Line 86: FND_MSG_PUB.initialize;

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

Line 183: FND_MSG_PUB.Count_And_Get

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

Line 197: FND_MSG_PUB.Count_And_Get (

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

Line 207: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 221: FND_MSG_PUB.Count_And_Get (

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

Line 281: FND_MSG_PUB.initialize;

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

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

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

Line 384: FND_MSG_PUB.Count_And_Get

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

Line 398: FND_MSG_PUB.Count_And_Get (

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

Line 408: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 422: FND_MSG_PUB.Count_And_Get (

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

Line 463: FND_MSG_PUB.initialize;

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

Line 497: FND_MSG_PUB.Count_And_Get

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

Line 511: FND_MSG_PUB.Count_And_Get (

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

Line 521: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 535: FND_MSG_PUB.Count_And_Get (

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

Line 578: FND_MSG_PUB.initialize;

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

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

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

Line 606: FND_MSG_PUB.add;

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

Line 614: FND_MSG_PUB.count_and_get(

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

Line 629: FND_MSG_PUB.Count_And_Get (

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

Line 639: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 653: FND_MSG_PUB.Count_And_Get (

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

Line 1120: FND_MSG_PUB.initialize;

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

Line 1174: FND_MSG_PUB.Count_And_Get

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

Line 1189: FND_MSG_PUB.Count_And_Get (

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

Line 1199: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 1213: FND_MSG_PUB.Count_And_Get (

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

Line 1234: FND_MSG_PUB.initialize;

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

Line 1248: FND_MSG_PUB.Count_And_Get

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