eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JMF_SHIKYU_UTIL dependencies on FND_LOG

Line 90: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

86:
87: BEGIN
88:
89: IF g_fnd_debug = 'Y' AND
90: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
91:
92: THEN
93: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
94: , G_MODULE_PREFIX || l_api_name || '.begin'

Line 93: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

89: IF g_fnd_debug = 'Y' AND
90: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
91:
92: THEN
93: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
94: , G_MODULE_PREFIX || l_api_name || '.begin'
95: , NULL);
96: END IF;
97:

Line 105: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

101: WHERE inventory_item_id = p_inventory_item_id
102: AND organization_id = p_organization_id;
103:
104: IF g_fnd_debug = 'Y' AND
105: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
106: THEN
107: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
108: , G_MODULE_PREFIX || l_api_name || '.end'
109: , NULL);

Line 107: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

103:
104: IF g_fnd_debug = 'Y' AND
105: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
106: THEN
107: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
108: , G_MODULE_PREFIX || l_api_name || '.end'
109: , NULL);
110: END IF;
111:

Line 135: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

131: --- The SCO records are updated to interlock status T of the
132: --- parent PO is cancelled and interlock has not yet processed it
133:
134: IF g_fnd_debug = 'Y' AND
135: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
136: THEN
137: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
138: , 'JMFUSHKB: clean_invalid_data INTO '
139: , 'IN');

Line 137: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

133:
134: IF g_fnd_debug = 'Y' AND
135: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
136: THEN
137: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
138: , 'JMFUSHKB: clean_invalid_data INTO '
139: , 'IN');
140: END IF;
141:

Line 169: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

165:
166:
167:
168: IF g_fnd_debug = 'Y' AND
169: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
170: THEN
171: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
172: , 'JMFUSHKB: clean_invalid_data OUT '
173: , 'OUT ');

Line 171: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

167:
168: IF g_fnd_debug = 'Y' AND
169: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
170: THEN
171: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
172: , 'JMFUSHKB: clean_invalid_data OUT '
173: , 'OUT ');
174: END IF;
175:

Line 183: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

179: null ;
180:
181: WHEN OTHERS THEN
182: IF g_fnd_debug = 'Y' AND
183: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
184: THEN
185: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
186: , 'JMFUSHKB: clean_invalid_data OUT '
187: , 'INTO OTHERS EXCEPTION' );

Line 185: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

181: WHEN OTHERS THEN
182: IF g_fnd_debug = 'Y' AND
183: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
184: THEN
185: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
186: , 'JMFUSHKB: clean_invalid_data OUT '
187: , 'INTO OTHERS EXCEPTION' );
188: END IF;
189:

Line 218: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

214:
215: BEGIN
216:
217: IF g_fnd_debug = 'Y' AND
218: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
219: THEN
220: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
221: , G_MODULE_PREFIX || l_api_name || '.begin'
222: , NULL);

Line 220: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

216:
217: IF g_fnd_debug = 'Y' AND
218: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
219: THEN
220: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
221: , G_MODULE_PREFIX || l_api_name || '.begin'
222: , NULL);
223: END IF;
224:

Line 232: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

228: WHERE inventory_item_id = p_inventory_item_id
229: AND organization_id = p_organization_id;
230:
231: IF g_fnd_debug = 'Y' AND
232: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
233: THEN
234: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
235: , G_MODULE_PREFIX || l_api_name || '.end'
236: , NULL);

Line 234: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

230:
231: IF g_fnd_debug = 'Y' AND
232: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
233: THEN
234: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
235: , G_MODULE_PREFIX || l_api_name || '.end'
236: , NULL);
237: END IF;
238:

Line 263: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

259:
260: BEGIN
261:
262: IF g_fnd_debug = 'Y' AND
263: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
264: THEN
265: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
266: , G_MODULE_PREFIX || l_api_name || '.begin'
267: , NULL);

Line 265: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

261:
262: IF g_fnd_debug = 'Y' AND
263: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
264: THEN
265: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
266: , G_MODULE_PREFIX || l_api_name || '.begin'
267: , NULL);
268: END IF;
269:

Line 276: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

272: FROM mtl_units_of_measure
273: WHERE unit_of_measure = p_unit_of_measure;
274:
275: IF g_fnd_debug = 'Y' AND
276: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
277: THEN
278: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
279: , G_MODULE_PREFIX || l_api_name || '.end'
280: , NULL);

Line 278: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

274:
275: IF g_fnd_debug = 'Y' AND
276: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
277: THEN
278: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
279: , G_MODULE_PREFIX || l_api_name || '.end'
280: , NULL);
281: END IF;
282:

Line 321: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

317: RETURN l_uom_rate;
318: EXCEPTION
319: WHEN OTHERS THEN
320: IF g_fnd_debug = 'Y' AND
321: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
322: THEN
323: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
324: , G_MODULE_PREFIX || 'Get_Uom_Conversion_Rate.others_exception'
325: , 'Exception - Item Id: '||p_item_id ||', From Unit: ' ||

Line 323: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

319: WHEN OTHERS THEN
320: IF g_fnd_debug = 'Y' AND
321: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
322: THEN
323: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
324: , G_MODULE_PREFIX || 'Get_Uom_Conversion_Rate.others_exception'
325: , 'Exception - Item Id: '||p_item_id ||', From Unit: ' ||
326: p_from_unit || ', To Unit: ' || p_to_unit);
327: END IF;

Line 362: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

358:
359: EXCEPTION
360: WHEN OTHERS THEN
361: IF g_fnd_debug = 'Y' AND
362: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
363: THEN
364: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
365: , G_MODULE_PREFIX || 'Get_Replenish_So_Returned_Qty.others_exception'
366: , 'Exception - Sales Order Line Id: ' || p_replenishment_so_line_id);

Line 364: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

360: WHEN OTHERS THEN
361: IF g_fnd_debug = 'Y' AND
362: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
363: THEN
364: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
365: , G_MODULE_PREFIX || 'Get_Replenish_So_Returned_Qty.others_exception'
366: , 'Exception - Sales Order Line Id: ' || p_replenishment_so_line_id);
367: END IF;
368: END Get_Replenish_So_Returned_Qty;

Line 405: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

401: WHEN NO_DATA_FOUND THEN
402: RETURN 0 ;
403: WHEN OTHERS THEN
404: IF g_fnd_debug = 'Y' AND
405: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
406: THEN
407: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
408: , G_MODULE_PREFIX || 'Get_Replenish_So_Received_Qty.others_exception'
409: , 'Exception - Sales Order Line Id: ' || p_replenishment_so_line_id);

Line 407: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

403: WHEN OTHERS THEN
404: IF g_fnd_debug = 'Y' AND
405: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
406: THEN
407: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
408: , G_MODULE_PREFIX || 'Get_Replenish_So_Received_Qty.others_exception'
409: , 'Exception - Sales Order Line Id: ' || p_replenishment_so_line_id);
410: END IF;
411: END Get_Replenish_So_Received_Qty;

Line 433: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

429:
430: BEGIN
431:
432: IF g_fnd_debug = 'Y' AND
433: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
434: THEN
435: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
436: , G_MODULE_PREFIX || l_api_name || 'GET_used_quantity'
437: , 'begin');

Line 435: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

431:
432: IF g_fnd_debug = 'Y' AND
433: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
434: THEN
435: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
436: , G_MODULE_PREFIX || l_api_name || 'GET_used_quantity'
437: , 'begin');
438: END IF;
439:

Line 455: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

451:
452: END;
453:
454: IF g_fnd_debug = 'Y' AND
455: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
456: THEN
457: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
458: , 'GET_used_quantity Return quantity: '
459: , l_quantity);

Line 457: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

453:
454: IF g_fnd_debug = 'Y' AND
455: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
456: THEN
457: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
458: , 'GET_used_quantity Return quantity: '
459: , l_quantity);
460: END IF;
461:

Line 487: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

483:
484: BEGIN
485:
486: IF g_fnd_debug = 'Y' AND
487: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
488: THEN
489: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
490: , G_MODULE_PREFIX || l_api_name ||
491: 'get_prImary_quantity. Invoked'

Line 489: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

485:
486: IF g_fnd_debug = 'Y' AND
487: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
488: THEN
489: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
490: , G_MODULE_PREFIX || l_api_name ||
491: 'get_prImary_quantity. Invoked'
492: , 'begin');
493: END IF;

Line 544: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

540:
541: l_date := NULL;
542:
543: IF g_fnd_debug = 'Y' AND
544: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
545: THEN
546: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
547: , G_MODULE_PREFIX || l_api_name ||
548: 'get_final_ship_date.Invoked'

Line 546: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

542:
543: IF g_fnd_debug = 'Y' AND
544: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
545: THEN
546: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
547: , G_MODULE_PREFIX || l_api_name ||
548: 'get_final_ship_date.Invoked'
549: , 'begin');
550: END IF;

Line 592: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

588:
589: BEGIN
590:
591: IF g_fnd_debug = 'Y' AND
592: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
593: THEN
594: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
595: , G_MODULE_PREFIX || l_api_name ||
596: 'GET_allocation_date.Invoked '

Line 594: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

590:
591: IF g_fnd_debug = 'Y' AND
592: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
593: THEN
594: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
595: , G_MODULE_PREFIX || l_api_name ||
596: 'GET_allocation_date.Invoked '
597: , 'begin');
598: END IF;

Line 650: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

646: RETURN NULL;
647: END IF;
648:
649: IF g_fnd_debug = 'Y' AND
650: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
651:
652: THEN
653: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
654: , G_MODULE_PREFIX

Line 653: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

649: IF g_fnd_debug = 'Y' AND
650: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
651:
652: THEN
653: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
654: , G_MODULE_PREFIX
655: , G_MODULE_PREFIX || l_api_name || '.begin');
656: END IF;
657:

Line 674: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

670:
671: END IF;
672:
673: IF g_fnd_debug = 'Y' AND
674: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
675: THEN
676: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
677: , G_MODULE_PREFIX
678: , G_MODULE_PREFIX || l_api_name

Line 676: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

672:
673: IF g_fnd_debug = 'Y' AND
674: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
675: THEN
676: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
677: , G_MODULE_PREFIX
678: , G_MODULE_PREFIX || l_api_name
679: || '.end: Returning XSD Date = '
680: || l_xsd_date_string);

Line 689: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

685: EXCEPTION
686:
687: WHEN OTHERS THEN
688: IF g_fnd_debug = 'Y' AND
689: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
690: THEN
691: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
692: , G_MODULE_PREFIX
693: , G_MODULE_PREFIX || l_api_name || ': ' || sqlerrm);

Line 691: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

687: WHEN OTHERS THEN
688: IF g_fnd_debug = 'Y' AND
689: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
690: THEN
691: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
692: , G_MODULE_PREFIX
693: , G_MODULE_PREFIX || l_api_name || ': ' || sqlerrm);
694: END IF;
695:

Line 1051: WHEN 'FND_LOG.STRING' THEN

1047: IS
1048: BEGIN
1049:
1050: CASE p_output_to
1051: WHEN 'FND_LOG.STRING' THEN
1052: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1053: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
1054: ,p_api_name || '.debug_output'
1055: ,p_message);

Line 1052: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1048: BEGIN
1049:
1050: CASE p_output_to
1051: WHEN 'FND_LOG.STRING' THEN
1052: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1053: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
1054: ,p_api_name || '.debug_output'
1055: ,p_message);
1056: END IF;

Line 1053: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

1049:
1050: CASE p_output_to
1051: WHEN 'FND_LOG.STRING' THEN
1052: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1053: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
1054: ,p_api_name || '.debug_output'
1055: ,p_message);
1056: END IF;
1057: WHEN 'FND_FILE.OUTPUT' THEN

Line 1113: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1109:
1110: EXCEPTION
1111: WHEN NO_DATA_FOUND THEN
1112: IF g_fnd_debug = 'Y' AND
1113: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1114: THEN
1115: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
1116: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
1117: , 'No relationship exists for the OEM Organization and Manufacturing Organization of the Subcontracting PO');

Line 1115: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

1111: WHEN NO_DATA_FOUND THEN
1112: IF g_fnd_debug = 'Y' AND
1113: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1114: THEN
1115: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
1116: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
1117: , 'No relationship exists for the OEM Organization and Manufacturing Organization of the Subcontracting PO');
1118: END IF;
1119:

Line 1155: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1151:
1152: BEGIN
1153:
1154: IF g_fnd_debug = 'Y' AND
1155: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1156: THEN
1157: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1158: , G_MODULE_PREFIX || l_api_name || '.begin'
1159: , p_cp_product_code || '.' ||p_cp_short_name || '(' || p_batch_id ||')');

Line 1157: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1153:
1154: IF g_fnd_debug = 'Y' AND
1155: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1156: THEN
1157: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1158: , G_MODULE_PREFIX || l_api_name || '.begin'
1159: , p_cp_product_code || '.' ||p_cp_short_name || '(' || p_batch_id ||')');
1160: END IF;
1161:

Line 1200: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1196:
1197: COMMIT;
1198:
1199: IF g_fnd_debug = 'Y' AND
1200: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1201: THEN
1202: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1203: , G_MODULE_PREFIX || l_api_name || '.end'
1204: , NULL);

Line 1202: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1198:
1199: IF g_fnd_debug = 'Y' AND
1200: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1201: THEN
1202: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1203: , G_MODULE_PREFIX || l_api_name || '.end'
1204: , NULL);
1205: END IF;
1206: EXCEPTION

Line 1212: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1208:
1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1210:
1211: IF g_fnd_debug = 'Y' AND
1212: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1213: THEN
1214: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
1215: , G_MODULE_PREFIX || l_api_name || '.Submit Request'
1216: , 'Exception - ' || p_cp_product_code || '.' ||p_cp_short_name || '(' || p_batch_id ||')');

Line 1214: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

1210:
1211: IF g_fnd_debug = 'Y' AND
1212: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1213: THEN
1214: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
1215: , G_MODULE_PREFIX || l_api_name || '.Submit Request'
1216: , 'Exception - ' || p_cp_product_code || '.' ||p_cp_short_name || '(' || p_batch_id ||')');
1217: END IF;
1218: WHEN OTHERS THEN

Line 1223: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1219:
1220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1221:
1222: IF g_fnd_debug = 'Y' AND
1223: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1224: THEN
1225: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1226: , G_MODULE_PREFIX || l_api_name || '.others_exception'
1227: , 'Exception - ' || p_cp_product_code || '.' ||p_cp_short_name || '(' || p_batch_id ||')');

Line 1225: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

1221:
1222: IF g_fnd_debug = 'Y' AND
1223: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1224: THEN
1225: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1226: , G_MODULE_PREFIX || l_api_name || '.others_exception'
1227: , 'Exception - ' || p_cp_product_code || '.' ||p_cp_short_name || '(' || p_batch_id ||')');
1228: END IF;
1229: END Submit_Worker;

Line 1253: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1249:
1250: BEGIN
1251:
1252: IF g_fnd_debug = 'Y' AND
1253: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1254: THEN
1255: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1256: , G_MODULE_PREFIX || l_api_name || '.begin'
1257: , 'Request Id: ' || p_request_id);

Line 1255: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1251:
1252: IF g_fnd_debug = 'Y' AND
1253: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1254: THEN
1255: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1256: , G_MODULE_PREFIX || l_api_name || '.begin'
1257: , 'Request Id: ' || p_request_id);
1258: END IF;
1259:

Line 1273: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1269: l_result := FALSE;
1270: END IF;
1271:
1272: IF g_fnd_debug = 'Y' AND
1273: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1274: THEN
1275: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1276: , G_MODULE_PREFIX || l_api_name || '.end'
1277: , NULL);

Line 1275: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1271:
1272: IF g_fnd_debug = 'Y' AND
1273: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1274: THEN
1275: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1276: , G_MODULE_PREFIX || l_api_name || '.end'
1277: , NULL);
1278: END IF;
1279:

Line 1285: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1281:
1282: EXCEPTION
1283: WHEN NO_DATA_FOUND THEN
1284: IF g_fnd_debug = 'Y' AND
1285: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1286: THEN
1287: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
1288: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
1289: , 'No data found for concurrent request Id:' || p_request_id);

Line 1287: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

1283: WHEN NO_DATA_FOUND THEN
1284: IF g_fnd_debug = 'Y' AND
1285: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1286: THEN
1287: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
1288: , G_MODULE_PREFIX || l_api_name || '.no_data_found'
1289: , 'No data found for concurrent request Id:' || p_request_id);
1290: END IF;
1291: WHEN OTHERS THEN

Line 1293: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1289: , 'No data found for concurrent request Id:' || p_request_id);
1290: END IF;
1291: WHEN OTHERS THEN
1292: IF g_fnd_debug = 'Y' AND
1293: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1294: THEN
1295: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1296: , G_MODULE_PREFIX || l_api_name || '.others_exception'
1297: , 'Exception - Request Id: ' || p_request_id);

Line 1295: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

1291: WHEN OTHERS THEN
1292: IF g_fnd_debug = 'Y' AND
1293: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1294: THEN
1295: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1296: , G_MODULE_PREFIX || l_api_name || '.others_exception'
1297: , 'Exception - Request Id: ' || p_request_id);
1298: END IF;
1299:

Line 1326: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1322:
1323: BEGIN
1324:
1325: IF g_fnd_debug = 'Y' AND
1326: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1327: THEN
1328: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1329: , G_MODULE_PREFIX || l_api_name || '.begin'
1330: , NULL);

Line 1328: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1324:
1325: IF g_fnd_debug = 'Y' AND
1326: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1327: THEN
1328: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1329: , G_MODULE_PREFIX || l_api_name || '.begin'
1330: , NULL);
1331: END IF;
1332:

Line 1355: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1351:
1352: END LOOP;
1353:
1354: IF g_fnd_debug = 'Y' AND
1355: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1356: THEN
1357: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1358: , G_MODULE_PREFIX || l_api_name || '.end'
1359: , NULL);

Line 1357: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1353:
1354: IF g_fnd_debug = 'Y' AND
1355: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1356: THEN
1357: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1358: , G_MODULE_PREFIX || l_api_name || '.end'
1359: , NULL);
1360: END IF;
1361: EXCEPTION

Line 1364: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1360: END IF;
1361: EXCEPTION
1362: WHEN OTHERS THEN
1363: IF g_fnd_debug = 'Y' AND
1364: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1365: THEN
1366: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1367: , G_MODULE_PREFIX || l_api_name || '.others_exception'
1368: , 'Exception');

Line 1366: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

1362: WHEN OTHERS THEN
1363: IF g_fnd_debug = 'Y' AND
1364: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1365: THEN
1366: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1367: , G_MODULE_PREFIX || l_api_name || '.others_exception'
1368: , 'Exception');
1369: END IF;
1370: END Wait_For_Worker;

Line 1391: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1387:
1388: BEGIN
1389:
1390: IF g_fnd_debug = 'Y' AND
1391: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1392: THEN
1393: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1394: , G_MODULE_PREFIX || l_api_name || '.begin'
1395: , NULL);

Line 1393: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1389:
1390: IF g_fnd_debug = 'Y' AND
1391: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1392: THEN
1393: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1394: , G_MODULE_PREFIX || l_api_name || '.begin'
1395: , NULL);
1396: END IF;
1397:

Line 1422: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1418:
1419: END LOOP;
1420:
1421: IF g_fnd_debug = 'Y' AND
1422: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1423: THEN
1424: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1425: , G_MODULE_PREFIX || l_api_name || '.end'
1426: , NULL);

Line 1424: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

1420:
1421: IF g_fnd_debug = 'Y' AND
1422: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1423: THEN
1424: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
1425: , G_MODULE_PREFIX || l_api_name || '.end'
1426: , NULL);
1427: END IF;
1428: EXCEPTION

Line 1431: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1427: END IF;
1428: EXCEPTION
1429: WHEN OTHERS THEN
1430: IF g_fnd_debug = 'Y' AND
1431: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1432: THEN
1433: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1434: , G_MODULE_PREFIX || l_api_name || '.others_exception'
1435: , 'Exception');

Line 1433: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

1429: WHEN OTHERS THEN
1430: IF g_fnd_debug = 'Y' AND
1431: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1432: THEN
1433: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1434: , G_MODULE_PREFIX || l_api_name || '.others_exception'
1435: , 'Exception');
1436: END IF;
1437: