DBA Data[Home] [Help]

APPS.JMF_SHIKYU_GRP dependencies on FND_MSG_PUB

Line 125: FND_MSG_PUB.initialize;

121: END IF;
122:
123: -- Start API initialization
124: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
125: FND_MSG_PUB.initialize;
126: END IF;
127:
128: IF NOT FND_API.Compatible_API_Call( l_api_version
129: , p_api_version

Line 191: FND_MSG_PUB.Count_And_Get

187: END IF;
188:
189: EXCEPTION
190: WHEN NO_DATA_FOUND THEN
191: FND_MSG_PUB.Count_And_Get
192: ( p_count => x_msg_count
193: , p_data => x_msg_data
194: );
195: x_return_status := FND_API.G_RET_STS_ERROR;

Line 205: FND_MSG_PUB.Count_And_Get

201: , 'No relationship exists for the OEM Organization and Manufacturing Organization of the Subcontracting PO');
202: END IF;
203:
204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
205: FND_MSG_PUB.Count_And_Get
206: ( p_count => x_msg_count
207: , p_data => x_msg_data
208: );
209:

Line 220: FND_MSG_PUB.Count_And_Get

216: , 'Exception');
217: END IF;
218:
219: WHEN OTHERS THEN
220: FND_MSG_PUB.Count_And_Get
221: ( p_count => x_msg_count
222: , p_data => x_msg_data
223: );
224:

Line 278: FND_MSG_PUB.initialize;

274: END IF;
275:
276: -- Start API initialization
277: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
278: FND_MSG_PUB.initialize;
279: END IF;
280:
281: /*
282: IF NOT FND_API.Compatible_API_Call( l_api_version

Line 353: FND_MSG_PUB.Count_And_Get

349: END IF;
350:
351: EXCEPTION
352: WHEN NO_DATA_FOUND THEN
353: FND_MSG_PUB.Count_And_Get
354: ( p_count => x_msg_count
355: , p_data => x_msg_data
356: );
357: x_msg_data := 'NO_DATA_FOUND: p_po_shipment_id = ' || p_po_shipment_id;

Line 368: FND_MSG_PUB.Count_And_Get

364: , 'The PO Line does not exist.');
365: END IF;
366:
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368: FND_MSG_PUB.Count_And_Get
369: ( p_count => x_msg_count
370: , p_data => x_msg_data
371: );
372: x_msg_data := 'FND_API.G_EXC_UNEXPECTED_ERROR: p_po_shipment_id = ' || p_po_shipment_id;

Line 383: FND_MSG_PUB.Count_And_Get

379: , 'Exception');
380: END IF;
381:
382: WHEN OTHERS THEN
383: FND_MSG_PUB.Count_And_Get
384: ( p_count => x_msg_count
385: , p_data => x_msg_data
386: );
387: x_msg_data := 'OTHER EXCEPTIONS: p_po_shipment_id = ' || p_po_shipment_id;

Line 437: FND_MSG_PUB.initialize;

433: END IF;
434:
435: -- Start API initialization
436: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
437: FND_MSG_PUB.initialize;
438: END IF;
439:
440: IF NOT FND_API.Compatible_API_Call( l_api_version
441: , p_api_version

Line 459: FND_MSG_PUB.Count_And_Get

455: WHERE organization_id = p_organization_id;
456:
457: EXCEPTION
458: WHEN NO_DATA_FOUND THEN
459: FND_MSG_PUB.Count_And_Get
460: ( p_count => x_msg_count
461: , p_data => x_msg_data
462: );
463: x_return_status := FND_API.G_RET_STS_ERROR;

Line 473: FND_MSG_PUB.Count_And_Get

469: , 'The Inventory Organization does not exist.');
470: END IF;
471:
472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
473: FND_MSG_PUB.Count_And_Get
474: ( p_count => x_msg_count
475: , p_data => x_msg_data
476: );
477:

Line 488: FND_MSG_PUB.Count_And_Get

484: , 'Exception');
485: END IF;
486:
487: WHEN OTHERS THEN
488: FND_MSG_PUB.Count_And_Get
489: ( p_count => x_msg_count
490: , p_data => x_msg_data
491: );
492:

Line 553: FND_MSG_PUB.initialize;

549: END IF;
550:
551: -- Start API initialization
552: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
553: FND_MSG_PUB.initialize;
554: END IF;
555:
556: IF NOT FND_API.Compatible_API_Call( l_api_version
557: , p_api_version

Line 608: FND_MSG_PUB.Count_And_Get

604: END IF;
605:
606: EXCEPTION
607: WHEN NO_DATA_FOUND THEN
608: FND_MSG_PUB.Count_And_Get
609: ( p_count => x_msg_count
610: , p_data => x_msg_data
611: );
612: x_return_status := FND_API.G_RET_STS_ERROR;

Line 622: FND_MSG_PUB.Count_And_Get

618: , 'The AP Invoice does not exist.');
619: END IF;
620:
621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
622: FND_MSG_PUB.Count_And_Get
623: ( p_count => x_msg_count
624: , p_data => x_msg_data
625: );
626:

Line 637: FND_MSG_PUB.Count_And_Get

633: , 'Exception');
634: END IF;
635:
636: WHEN OTHERS THEN
637: FND_MSG_PUB.Count_And_Get
638: ( p_count => x_msg_count
639: , p_data => x_msg_data
640: );
641:

Line 732: FND_MSG_PUB.initialize;

728: END IF;
729:
730: -- Start API initialization
731: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
732: FND_MSG_PUB.initialize;
733: END IF;
734:
735: IF NOT FND_API.Compatible_API_Call( l_api_version
736: , p_api_version

Line 779: FND_MSG_PUB.Count_And_Get

775:
776: EXCEPTION
777:
778: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
779: FND_MSG_PUB.Count_And_Get
780: ( p_count => x_msg_count
781: , p_data => x_msg_data
782: );
783:

Line 794: FND_MSG_PUB.Count_And_Get

790: , 'Exception');
791: END IF;
792:
793: WHEN OTHERS THEN
794: FND_MSG_PUB.Count_And_Get
795: ( p_count => x_msg_count
796: , p_data => x_msg_data
797: );
798:

Line 870: FND_MSG_PUB.initialize;

866: END IF;
867:
868: -- Start API initialization
869: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
870: FND_MSG_PUB.initialize;
871: END IF;
872:
873: IF NOT FND_API.Compatible_API_Call( l_api_version
874: , p_api_version

Line 968: FND_MSG_PUB.Count_And_Get

964: END IF;
965:
966: EXCEPTION
967: WHEN NO_DATA_FOUND THEN
968: FND_MSG_PUB.Count_And_Get
969: ( p_count => x_msg_count
970: , p_data => x_msg_data
971: );
972: x_return_status := FND_API.G_RET_STS_ERROR;

Line 982: FND_MSG_PUB.Count_And_Get

978: , 'No Data Found ');
979: END IF;
980:
981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
982: FND_MSG_PUB.Count_And_Get
983: ( p_count => x_msg_count
984: , p_data => x_msg_data
985: );
986:

Line 997: FND_MSG_PUB.Count_And_Get

993: , 'Exception');
994: END IF;
995:
996: WHEN OTHERS THEN
997: FND_MSG_PUB.Count_And_Get
998: ( p_count => x_msg_count
999: , p_data => x_msg_data
1000: );
1001:

Line 1055: FND_MSG_PUB.initialize;

1051: END IF;
1052:
1053: -- Start API initialization
1054: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
1055: FND_MSG_PUB.initialize;
1056: END IF;
1057:
1058: IF NOT FND_API.Compatible_API_Call( l_api_version
1059: , p_api_version

Line 1079: FND_MSG_PUB.Count_And_Get

1075: AND inventory_item_id = p_item_id;
1076:
1077: EXCEPTION
1078: WHEN NO_DATA_FOUND THEN
1079: FND_MSG_PUB.Count_And_Get
1080: ( p_count => x_msg_count
1081: , p_data => x_msg_data
1082: );
1083: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1093: FND_MSG_PUB.Count_And_Get

1089: , 'No Data Found ');
1090: END IF;
1091:
1092: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1093: FND_MSG_PUB.Count_And_Get
1094: ( p_count => x_msg_count
1095: , p_data => x_msg_data
1096: );
1097:

Line 1108: FND_MSG_PUB.Count_And_Get

1104: , 'Exception');
1105: END IF;
1106:
1107: WHEN OTHERS THEN
1108: FND_MSG_PUB.Count_And_Get
1109: ( p_count => x_msg_count
1110: , p_data => x_msg_data
1111: );
1112:

Line 1172: FND_MSG_PUB.initialize;

1168: , 'Before the query: subcontracting_type = "' || l_subcontracting_type || '"');
1169: END IF;
1170:
1171: -- Start API initialization
1172: FND_MSG_PUB.initialize;
1173:
1174:
1175: SELECT mip.subcontracting_type
1176: INTO l_subcontracting_type

Line 1203: FND_MSG_PUB.Count_And_Get

1199: , 'No subcontracting relationship exists between the OEM and the MP');
1200: END IF;
1201: RETURN NULL;
1202: WHEN OTHERS THEN
1203: FND_MSG_PUB.Count_And_Get
1204: ( p_encoded => FND_API.G_FALSE
1205: , p_count => l_msg_count
1206: , p_data => l_msg_data
1207: );