112:
113: BEGIN
114:
115: IF g_fnd_debug = 'Y' AND
116: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
117: THEN
118: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
119: , G_MODULE_PREFIX || l_api_name || '.invoked'
120: , 'Entry');
114:
115: IF g_fnd_debug = 'Y' AND
116: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
117: THEN
118: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
119: , G_MODULE_PREFIX || l_api_name || '.invoked'
120: , 'Entry');
121: END IF;
122:
193: , p_data => x_msg_data
194: );
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: IF g_fnd_debug = 'Y' AND
197: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
198: THEN
199: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
200: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
201: , 'No relationship exists for the OEM Organization and Manufacturing Organization of the Subcontracting PO');
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: IF g_fnd_debug = 'Y' AND
197: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
198: THEN
199: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
200: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
201: , 'No relationship exists for the OEM Organization and Manufacturing Organization of the Subcontracting PO');
202: END IF;
203:
208: );
209:
210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
211: IF g_fnd_debug = 'Y' AND
212: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
213: THEN
214: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
215: , G_MODULE_PREFIX || l_api_name || '.unexpected_exception'
216: , 'Exception');
210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
211: IF g_fnd_debug = 'Y' AND
212: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
213: THEN
214: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
215: , G_MODULE_PREFIX || l_api_name || '.unexpected_exception'
216: , 'Exception');
217: END IF;
218:
223: );
224:
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: IF g_fnd_debug = 'Y' AND
227: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
228: THEN
229: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
230: , G_MODULE_PREFIX || l_api_name || '.others_exception'
231: , 'Exception');
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: IF g_fnd_debug = 'Y' AND
227: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
228: THEN
229: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
230: , G_MODULE_PREFIX || l_api_name || '.others_exception'
231: , 'Exception');
232: END IF;
233: END Get_Shikyu_Variance_Account;
263:
264: BEGIN
265:
266: IF g_fnd_debug = 'Y' AND
267: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
268: THEN
269: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
270: , G_MODULE_PREFIX || l_api_name || '.invoked'
271: , 'Entry');
265:
266: IF g_fnd_debug = 'Y' AND
267: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
268: THEN
269: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
270: , G_MODULE_PREFIX || l_api_name || '.invoked'
271: , 'Entry');
272: END IF;
273:
292:
293: x_osa_flag := 'N';
294:
295: IF g_fnd_debug = 'Y' AND
296: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
297: THEN
298: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
299: , G_MODULE_PREFIX || l_api_name || '.invoked'
300: , 'Before the query: p_po_shipment_id = "' || p_po_shipment_id || '"');
294:
295: IF g_fnd_debug = 'Y' AND
296: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
297: THEN
298: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
299: , G_MODULE_PREFIX || l_api_name || '.invoked'
300: , 'Before the query: p_po_shipment_id = "' || p_po_shipment_id || '"');
301: END IF;
302:
307: FROM po_line_locations_all poll
308: WHERE poll.line_location_id = p_po_shipment_id;
309:
310: IF g_fnd_debug = 'Y' AND
311: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
312: THEN
313: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
314: , G_MODULE_PREFIX || l_api_name || '.invoked'
315: , 'After the query: l_outsourced_assembly = ' || l_outsourced_assembly);
309:
310: IF g_fnd_debug = 'Y' AND
311: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
312: THEN
313: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
314: , G_MODULE_PREFIX || l_api_name || '.invoked'
315: , 'After the query: l_outsourced_assembly = ' || l_outsourced_assembly);
316: END IF;
317:
322: x_osa_flag := 'N';
323: END IF;
324:
325: IF g_fnd_debug = 'Y' AND
326: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
327: THEN
328: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
329: , G_MODULE_PREFIX || l_api_name || '.invoked'
330: , 'Exit: Returning x_osa_flag = "' || x_osa_flag || '", x_return_status = "' || x_return_status || '"');
324:
325: IF g_fnd_debug = 'Y' AND
326: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
327: THEN
328: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
329: , G_MODULE_PREFIX || l_api_name || '.invoked'
330: , 'Exit: Returning x_osa_flag = "' || x_osa_flag || '", x_return_status = "' || x_return_status || '"');
331: END IF;
332:
338: );
339: x_msg_data := 'NO_DATA_FOUND: p_po_shipment_id = ' || p_po_shipment_id;
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: IF g_fnd_debug = 'Y' AND
342: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
343: THEN
344: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
345: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
346: , 'The PO Line does not exist.');
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: IF g_fnd_debug = 'Y' AND
342: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
343: THEN
344: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
345: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
346: , 'The PO Line does not exist.');
347: END IF;
348:
353: );
354: x_msg_data := 'FND_API.G_EXC_UNEXPECTED_ERROR: p_po_shipment_id = ' || p_po_shipment_id;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: IF g_fnd_debug = 'Y' AND
357: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
358: THEN
359: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
360: , G_MODULE_PREFIX || l_api_name || '.unexpected_exception'
361: , 'Exception');
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: IF g_fnd_debug = 'Y' AND
357: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
358: THEN
359: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
360: , G_MODULE_PREFIX || l_api_name || '.unexpected_exception'
361: , 'Exception');
362: END IF;
363:
368: );
369: x_msg_data := 'OTHER EXCEPTIONS: p_po_shipment_id = ' || p_po_shipment_id;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: IF g_fnd_debug = 'Y' AND
372: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
373: THEN
374: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
375: , G_MODULE_PREFIX || l_api_name || '.others_exception'
376: , 'Exception');
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: IF g_fnd_debug = 'Y' AND
372: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
373: THEN
374: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
375: , G_MODULE_PREFIX || l_api_name || '.others_exception'
376: , 'Exception');
377: END IF;
378: END Get_Po_Shipment_Osa_Flag;
406:
407: BEGIN
408:
409: IF g_fnd_debug = 'Y' AND
410: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
411: THEN
412: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
413: , G_MODULE_PREFIX || l_api_name || '.invoked'
414: , 'Entry');
408:
409: IF g_fnd_debug = 'Y' AND
410: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
411: THEN
412: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
413: , G_MODULE_PREFIX || l_api_name || '.invoked'
414: , 'Entry');
415: END IF;
416:
443: , p_data => x_msg_data
444: );
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: IF g_fnd_debug = 'Y' AND
447: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
448: THEN
449: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
450: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
451: , 'The Inventory Organization does not exist.');
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: IF g_fnd_debug = 'Y' AND
447: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
448: THEN
449: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
450: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
451: , 'The Inventory Organization does not exist.');
452: END IF;
453:
458: );
459:
460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
461: IF g_fnd_debug = 'Y' AND
462: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
463: THEN
464: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
465: , G_MODULE_PREFIX || l_api_name || '.unexpected_exception'
466: , 'Exception');
460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
461: IF g_fnd_debug = 'Y' AND
462: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
463: THEN
464: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
465: , G_MODULE_PREFIX || l_api_name || '.unexpected_exception'
466: , 'Exception');
467: END IF;
468:
473: );
474:
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: IF g_fnd_debug = 'Y' AND
477: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
478: THEN
479: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
480: , G_MODULE_PREFIX || l_api_name || '.others_exception'
481: , 'Exception');
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: IF g_fnd_debug = 'Y' AND
477: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
478: THEN
479: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
480: , G_MODULE_PREFIX || l_api_name || '.others_exception'
481: , 'Exception');
482: END IF;
483: END Is_Tp_Organization;
522:
523: BEGIN
524:
525: IF g_fnd_debug = 'Y' AND
526: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
527: THEN
528: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
529: , G_MODULE_PREFIX || l_api_name || '.invoked'
530: , 'Entry');
524:
525: IF g_fnd_debug = 'Y' AND
526: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
527: THEN
528: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
529: , G_MODULE_PREFIX || l_api_name || '.invoked'
530: , 'Entry');
531: END IF;
532:
592: , p_data => x_msg_data
593: );
594: x_return_status := FND_API.G_RET_STS_ERROR;
595: IF g_fnd_debug = 'Y' AND
596: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
597: THEN
598: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
599: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
600: , 'The AP Invoice does not exist.');
594: x_return_status := FND_API.G_RET_STS_ERROR;
595: IF g_fnd_debug = 'Y' AND
596: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
597: THEN
598: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
599: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
600: , 'The AP Invoice does not exist.');
601: END IF;
602:
607: );
608:
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
610: IF g_fnd_debug = 'Y' AND
611: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
612: THEN
613: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
614: , G_MODULE_PREFIX || l_api_name || '.unexpected_exception'
615: , 'Exception');
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
610: IF g_fnd_debug = 'Y' AND
611: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
612: THEN
613: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
614: , G_MODULE_PREFIX || l_api_name || '.unexpected_exception'
615: , 'Exception');
616: END IF;
617:
622: );
623:
624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
625: IF g_fnd_debug = 'Y' AND
626: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
627: THEN
628: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
629: , G_MODULE_PREFIX || l_api_name || '.others_exception'
630: , 'Exception');
624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
625: IF g_fnd_debug = 'Y' AND
626: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
627: THEN
628: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
629: , G_MODULE_PREFIX || l_api_name || '.others_exception'
630: , 'Exception');
631: END IF;
632: END Is_AP_Invoice_Shikyu_Nettable;
701:
702: BEGIN
703:
704: IF g_fnd_debug = 'Y' AND
705: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
706: THEN
707: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
708: , G_MODULE_PREFIX || l_api_name || '.invoked'
709: , 'Entry');
703:
704: IF g_fnd_debug = 'Y' AND
705: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
706: THEN
707: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
708: , G_MODULE_PREFIX || l_api_name || '.invoked'
709: , 'Entry');
710: END IF;
711:
764: );
765:
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: IF g_fnd_debug = 'Y' AND
768: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
769: THEN
770: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
771: , G_MODULE_PREFIX || l_api_name || '.unexpected_exception'
772: , 'Exception');
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: IF g_fnd_debug = 'Y' AND
768: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
769: THEN
770: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
771: , G_MODULE_PREFIX || l_api_name || '.unexpected_exception'
772: , 'Exception');
773: END IF;
774:
779: );
780:
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: IF g_fnd_debug = 'Y' AND
783: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
784: THEN
785: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
786: , G_MODULE_PREFIX || l_api_name || '.others_exception'
787: , 'Exception');
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: IF g_fnd_debug = 'Y' AND
783: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
784: THEN
785: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
786: , G_MODULE_PREFIX || l_api_name || '.others_exception'
787: , 'Exception');
788: END IF;
789: END Is_So_Line_Shikyu_Enabled;
839:
840: BEGIN
841:
842: IF g_fnd_debug = 'Y' AND
843: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
844: THEN
845: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
846: , G_MODULE_PREFIX || l_api_name || '.begin'
847: , NULL);
841:
842: IF g_fnd_debug = 'Y' AND
843: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
844: THEN
845: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
846: , G_MODULE_PREFIX || l_api_name || '.begin'
847: , NULL);
848: END IF;
849:
937:
938: END IF;
939:
940: IF g_fnd_debug = 'Y' AND
941: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
942: THEN
943: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
944: , G_MODULE_PREFIX || l_api_name || '.end'
945: , NULL);
939:
940: IF g_fnd_debug = 'Y' AND
941: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
942: THEN
943: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
944: , G_MODULE_PREFIX || l_api_name || '.end'
945: , NULL);
946: END IF;
947:
952: , p_data => x_msg_data
953: );
954: x_return_status := FND_API.G_RET_STS_ERROR;
955: IF g_fnd_debug = 'Y' AND
956: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
957: THEN
958: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
959: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
960: , 'No Data Found ');
954: x_return_status := FND_API.G_RET_STS_ERROR;
955: IF g_fnd_debug = 'Y' AND
956: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
957: THEN
958: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
959: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
960: , 'No Data Found ');
961: END IF;
962:
967: );
968:
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
970: IF g_fnd_debug = 'Y' AND
971: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
972: THEN
973: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
974: , G_MODULE_PREFIX || l_api_name || '.unexpected_exception'
975: , 'Exception');
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
970: IF g_fnd_debug = 'Y' AND
971: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
972: THEN
973: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
974: , G_MODULE_PREFIX || l_api_name || '.unexpected_exception'
975: , 'Exception');
976: END IF;
977:
982: );
983:
984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
985: IF g_fnd_debug = 'Y' AND
986: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
987: THEN
988: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
989: , G_MODULE_PREFIX || l_api_name || '.others_exception'
990: , 'Exception');
984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
985: IF g_fnd_debug = 'Y' AND
986: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
987: THEN
988: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
989: , G_MODULE_PREFIX || l_api_name || '.others_exception'
990: , 'Exception');
991: END IF;
992: END Validate_Osa_Flag;
1024:
1025: BEGIN
1026:
1027: IF g_fnd_debug = 'Y' AND
1028: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1029: THEN
1030: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1031: , G_MODULE_PREFIX || l_api_name || '.invoked'
1032: , 'Entry');
1026:
1027: IF g_fnd_debug = 'Y' AND
1028: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1029: THEN
1030: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1031: , G_MODULE_PREFIX || l_api_name || '.invoked'
1032: , 'Entry');
1033: END IF;
1034:
1063: , p_data => x_msg_data
1064: );
1065: x_return_status := FND_API.G_RET_STS_ERROR;
1066: IF g_fnd_debug = 'Y' AND
1067: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1068: THEN
1069: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
1070: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
1071: , 'No Data Found ');
1065: x_return_status := FND_API.G_RET_STS_ERROR;
1066: IF g_fnd_debug = 'Y' AND
1067: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1068: THEN
1069: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
1070: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
1071: , 'No Data Found ');
1072: END IF;
1073:
1078: );
1079:
1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1081: IF g_fnd_debug = 'Y' AND
1082: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1083: THEN
1084: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1085: , G_MODULE_PREFIX || l_api_name || '.unexpected_exception'
1086: , 'Exception');
1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1081: IF g_fnd_debug = 'Y' AND
1082: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1083: THEN
1084: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1085: , G_MODULE_PREFIX || l_api_name || '.unexpected_exception'
1086: , 'Exception');
1087: END IF;
1088:
1093: );
1094:
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1096: IF g_fnd_debug = 'Y' AND
1097: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1098: THEN
1099: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1100: , G_MODULE_PREFIX || l_api_name || '.others_exception'
1101: , 'Exception');
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1096: IF g_fnd_debug = 'Y' AND
1097: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1098: THEN
1099: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1100: , G_MODULE_PREFIX || l_api_name || '.others_exception'
1101: , 'Exception');
1102: END IF;
1103: END Get_Shikyu_Attributes;
1132:
1133: BEGIN
1134:
1135: IF g_fnd_debug = 'Y' AND
1136: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1137: THEN
1138: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1139: , G_MODULE_PREFIX || l_api_name || '.invoked'
1140: , 'Entry');
1134:
1135: IF g_fnd_debug = 'Y' AND
1136: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1137: THEN
1138: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1139: , G_MODULE_PREFIX || l_api_name || '.invoked'
1140: , 'Entry');
1141: END IF;
1142:
1142:
1143: l_subcontracting_type := NULL;
1144:
1145: IF g_fnd_debug = 'Y' AND
1146: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1147: THEN
1148: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1149: , G_MODULE_PREFIX || l_api_name || '.invoked'
1150: , 'Before the query: subcontracting_type = "' || l_subcontracting_type || '"');
1144:
1145: IF g_fnd_debug = 'Y' AND
1146: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1147: THEN
1148: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1149: , G_MODULE_PREFIX || l_api_name || '.invoked'
1150: , 'Before the query: subcontracting_type = "' || l_subcontracting_type || '"');
1151: END IF;
1152:
1160: WHERE mip.from_organization_id = p_oem_org_id
1161: AND mip.to_organization_id = p_mp_org_id;
1162:
1163: IF g_fnd_debug = 'Y' AND
1164: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1165: THEN
1166: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1167: , G_MODULE_PREFIX || l_api_name || '.invoked'
1168: , 'After the query: subcontracting_type = "' || l_subcontracting_type || '"');
1162:
1163: IF g_fnd_debug = 'Y' AND
1164: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1165: THEN
1166: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1167: , G_MODULE_PREFIX || l_api_name || '.invoked'
1168: , 'After the query: subcontracting_type = "' || l_subcontracting_type || '"');
1169: END IF;
1170:
1173:
1174: EXCEPTION
1175: WHEN NO_DATA_FOUND THEN
1176: IF g_fnd_debug = 'Y' AND
1177: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1178: THEN
1179: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
1180: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
1181: , 'No subcontracting relationship exists between the OEM and the MP');
1175: WHEN NO_DATA_FOUND THEN
1176: IF g_fnd_debug = 'Y' AND
1177: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1178: THEN
1179: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
1180: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
1181: , 'No subcontracting relationship exists between the OEM and the MP');
1182: END IF;
1183: RETURN NULL;
1187: , p_count => l_msg_count
1188: , p_data => l_msg_data
1189: );
1190: IF g_fnd_debug = 'Y' AND
1191: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1192: THEN
1193: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
1194: , G_MODULE_PREFIX || l_api_name || '.others_exception'
1195: , l_msg_data);
1189: );
1190: IF g_fnd_debug = 'Y' AND
1191: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1192: THEN
1193: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
1194: , G_MODULE_PREFIX || l_api_name || '.others_exception'
1195: , l_msg_data);
1196: END IF;
1197: RETURN NULL;