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.GME_COMMON_PVT dependencies on GME_DEBUG

Line 187: IF g_debug <= gme_debug.g_log_procedure THEN

183: ,p_product_code IN VARCHAR2 := 'GME')
184: IS
185: l_api_name CONSTANT VARCHAR2 (30) := 'log_message';
186: BEGIN
187: IF g_debug <= gme_debug.g_log_procedure THEN
188: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
189: || l_api_name);
190: END IF;
191:

Line 188: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

184: IS
185: l_api_name CONSTANT VARCHAR2 (30) := 'log_message';
186: BEGIN
187: IF g_debug <= gme_debug.g_log_procedure THEN
188: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
189: || l_api_name);
190: END IF;
191:
192: fnd_message.set_name (p_product_code, p_message_code);

Line 220: IF g_debug <= gme_debug.g_log_procedure THEN

216: END IF;
217:
218: fnd_msg_pub.ADD;
219:
220: IF g_debug <= gme_debug.g_log_procedure THEN
221: --FPBug#4351032 modified to include new token and value
222: gme_debug.put_line ( 'FROM LOG_MESSAGE '
223: || p_message_code
224: || '/'

Line 222: gme_debug.put_line ( 'FROM LOG_MESSAGE '

218: fnd_msg_pub.ADD;
219:
220: IF g_debug <= gme_debug.g_log_procedure THEN
221: --FPBug#4351032 modified to include new token and value
222: gme_debug.put_line ( 'FROM LOG_MESSAGE '
223: || p_message_code
224: || '/'
225: || p_token1_name
226: || '/'

Line 252: IF g_debug <= gme_debug.g_log_procedure THEN

248: END IF;
249:
250: gme_common_pvt.g_error_count := gme_common_pvt.g_error_count + 1;
251:
252: IF g_debug <= gme_debug.g_log_procedure THEN
253: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
254: END IF;
255: EXCEPTION
256: WHEN OTHERS THEN

Line 253: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

249:
250: gme_common_pvt.g_error_count := gme_common_pvt.g_error_count + 1;
251:
252: IF g_debug <= gme_debug.g_log_procedure THEN
253: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
254: END IF;
255: EXCEPTION
256: WHEN OTHERS THEN
257: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 259: IF g_debug <= gme_debug.g_log_unexpected THEN

255: EXCEPTION
256: WHEN OTHERS THEN
257: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
258:
259: IF g_debug <= gme_debug.g_log_unexpected THEN
260: gme_debug.put_line ( 'When others exception in '
261: || g_pkg_name
262: || '.'
263: || l_api_name

Line 260: gme_debug.put_line ( 'When others exception in '

256: WHEN OTHERS THEN
257: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
258:
259: IF g_debug <= gme_debug.g_log_unexpected THEN
260: gme_debug.put_line ( 'When others exception in '
261: || g_pkg_name
262: || '.'
263: || l_api_name
264: || ' Error is '

Line 305: IF g_debug <= gme_debug.g_log_procedure THEN

301: gmd_params_not_defined EXCEPTION;
302: inv_params_not_found EXCEPTION;
303: missing_profile_option EXCEPTION;
304: BEGIN
305: IF g_debug <= gme_debug.g_log_procedure THEN
306: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
307: || l_api_name);
308: END IF;
309:

Line 306: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

302: inv_params_not_found EXCEPTION;
303: missing_profile_option EXCEPTION;
304: BEGIN
305: IF g_debug <= gme_debug.g_log_procedure THEN
306: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
307: || l_api_name);
308: END IF;
309:
310: -- Bug 15847423

Line 454: IF g_debug <= gme_debug.g_log_procedure THEN

450: l_cur_get_org_params.rule_based_resv_horizon;
451: gme_common_pvt.g_hour_uom_code :=
452: fnd_profile.VALUE ('BOM:HOUR_UOM_CODE');
453:
454: IF g_debug <= gme_debug.g_log_procedure THEN
455: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
456: END IF;
457:
458: RETURN TRUE;

Line 455: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

451: gme_common_pvt.g_hour_uom_code :=
452: fnd_profile.VALUE ('BOM:HOUR_UOM_CODE');
453:
454: IF g_debug <= gme_debug.g_log_procedure THEN
455: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
456: END IF;
457:
458: RETURN TRUE;
459: EXCEPTION

Line 476: IF g_debug <= gme_debug.g_log_unexpected THEN

472: WHEN gme_params_not_defined THEN
473: gme_common_pvt.log_message ('GME_DEFINE_GME_PARAMETERS');
474: RETURN FALSE;
475: WHEN OTHERS THEN
476: IF g_debug <= gme_debug.g_log_unexpected THEN
477: gme_debug.put_line ( 'When others exception in '
478: || g_pkg_name
479: || '.'
480: || l_api_name

Line 477: gme_debug.put_line ( 'When others exception in '

473: gme_common_pvt.log_message ('GME_DEFINE_GME_PARAMETERS');
474: RETURN FALSE;
475: WHEN OTHERS THEN
476: IF g_debug <= gme_debug.g_log_unexpected THEN
477: gme_debug.put_line ( 'When others exception in '
478: || g_pkg_name
479: || '.'
480: || l_api_name
481: || ' Error is '

Line 498: IF g_debug <= gme_debug.g_log_unexpected THEN

494: EXCEPTION
495: WHEN OTHERS THEN
496: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
497:
498: IF g_debug <= gme_debug.g_log_unexpected THEN
499: gme_debug.put_line ( 'When others exception in '
500: || g_pkg_name
501: || '.'
502: || l_api_name

Line 499: gme_debug.put_line ( 'When others exception in '

495: WHEN OTHERS THEN
496: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
497:
498: IF g_debug <= gme_debug.g_log_unexpected THEN
499: gme_debug.put_line ( 'When others exception in '
500: || g_pkg_name
501: || '.'
502: || l_api_name
503: || ' Error is '

Line 519: IF g_debug <= gme_debug.g_log_unexpected THEN

515: EXCEPTION
516: WHEN OTHERS THEN
517: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
518:
519: IF g_debug <= gme_debug.g_log_unexpected THEN
520: gme_debug.put_line ( 'When others exception in '
521: || g_pkg_name
522: || '.'
523: || l_api_name

Line 520: gme_debug.put_line ( 'When others exception in '

516: WHEN OTHERS THEN
517: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
518:
519: IF g_debug <= gme_debug.g_log_unexpected THEN
520: gme_debug.put_line ( 'When others exception in '
521: || g_pkg_name
522: || '.'
523: || l_api_name
524: || ' Error is '

Line 546: IF g_debug <= gme_debug.g_log_unexpected THEN

542: EXCEPTION
543: WHEN OTHERS THEN
544: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
545:
546: IF g_debug <= gme_debug.g_log_unexpected THEN
547: gme_debug.put_line ( 'When others exception in '
548: || g_pkg_name
549: || '.'
550: || l_api_name

Line 547: gme_debug.put_line ( 'When others exception in '

543: WHEN OTHERS THEN
544: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
545:
546: IF g_debug <= gme_debug.g_log_unexpected THEN
547: gme_debug.put_line ( 'When others exception in '
548: || g_pkg_name
549: || '.'
550: || l_api_name
551: || ' Error is '

Line 583: IF g_debug <= gme_debug.g_log_unexpected THEN

579: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
580: fnd_msg_pub.count_and_get (p_count => l_message_count
581: ,p_data => l_message_list);
582:
583: IF g_debug <= gme_debug.g_log_unexpected THEN
584: gme_debug.put_line ( 'When others exception in '
585: || g_pkg_name
586: || '.'
587: || l_api_name

Line 584: gme_debug.put_line ( 'When others exception in '

580: fnd_msg_pub.count_and_get (p_count => l_message_count
581: ,p_data => l_message_list);
582:
583: IF g_debug <= gme_debug.g_log_unexpected THEN
584: gme_debug.put_line ( 'When others exception in '
585: || g_pkg_name
586: || '.'
587: || l_api_name
588: || ' Error is '

Line 627: IF g_debug <= gme_debug.g_log_procedure THEN

623: FROM mtl_secondary_inventories
624: WHERE organization_id = v_org_id
625: AND secondary_inventory_name = v_subinventory;
626: BEGIN
627: IF g_debug <= gme_debug.g_log_procedure THEN
628: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
629: || l_api_name);
630: END IF;
631:

Line 628: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

624: WHERE organization_id = v_org_id
625: AND secondary_inventory_name = v_subinventory;
626: BEGIN
627: IF g_debug <= gme_debug.g_log_procedure THEN
628: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
629: || l_api_name);
630: END IF;
631:
632: x_return_status := fnd_api.g_ret_sts_success;

Line 699: IF g_debug <= gme_debug.g_log_procedure THEN

695: x_locator_id := NULL;
696: END IF;
697: END IF;
698:
699: IF g_debug <= gme_debug.g_log_procedure THEN
700: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
701: END IF;
702: EXCEPTION
703: WHEN OTHERS THEN

Line 700: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

696: END IF;
697: END IF;
698:
699: IF g_debug <= gme_debug.g_log_procedure THEN
700: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
701: END IF;
702: EXCEPTION
703: WHEN OTHERS THEN
704: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 706: IF g_debug <= gme_debug.g_log_unexpected THEN

702: EXCEPTION
703: WHEN OTHERS THEN
704: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
705:
706: IF g_debug <= gme_debug.g_log_unexpected THEN
707: gme_debug.put_line ( 'When others exception in '
708: || g_pkg_name
709: || '.'
710: || l_api_name

Line 707: gme_debug.put_line ( 'When others exception in '

703: WHEN OTHERS THEN
704: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
705:
706: IF g_debug <= gme_debug.g_log_unexpected THEN
707: gme_debug.put_line ( 'When others exception in '
708: || g_pkg_name
709: || '.'
710: || l_api_name
711: || ' Error is '

Line 754: IF g_debug <= gme_debug.g_log_procedure THEN

750: FROM mtl_secondary_inventories
751: WHERE organization_id = v_org_id
752: AND secondary_inventory_name = v_subinventory;
753: BEGIN
754: IF g_debug <= gme_debug.g_log_procedure THEN
755: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
756: || l_api_name);
757: END IF;
758:

Line 755: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

751: WHERE organization_id = v_org_id
752: AND secondary_inventory_name = v_subinventory;
753: BEGIN
754: IF g_debug <= gme_debug.g_log_procedure THEN
755: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
756: || l_api_name);
757: END IF;
758:
759: x_return_status := fnd_api.g_ret_sts_success;

Line 825: IF g_debug <= gme_debug.g_log_procedure THEN

821: x_locator_id := NULL;
822: END IF;
823: END IF;
824:
825: IF g_debug <= gme_debug.g_log_procedure THEN
826: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
827: END IF;
828: EXCEPTION
829: WHEN OTHERS THEN

Line 826: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

822: END IF;
823: END IF;
824:
825: IF g_debug <= gme_debug.g_log_procedure THEN
826: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
827: END IF;
828: EXCEPTION
829: WHEN OTHERS THEN
830: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 832: IF g_debug <= gme_debug.g_log_unexpected THEN

828: EXCEPTION
829: WHEN OTHERS THEN
830: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
831:
832: IF g_debug <= gme_debug.g_log_unexpected THEN
833: gme_debug.put_line ( 'When others exception in '
834: || g_pkg_name
835: || '.'
836: || l_api_name

Line 833: gme_debug.put_line ( 'When others exception in '

829: WHEN OTHERS THEN
830: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
831:
832: IF g_debug <= gme_debug.g_log_unexpected THEN
833: gme_debug.put_line ( 'When others exception in '
834: || g_pkg_name
835: || '.'
836: || l_api_name
837: || ' Error is '

Line 855: IF g_debug <= gme_debug.g_log_procedure THEN

851: l_api_name CONSTANT VARCHAR2 (30) := 'construct_material_detail';
852: l_return_status VARCHAR2 (1);
853: get_defaults_err EXCEPTION;
854: BEGIN
855: IF g_debug <= gme_debug.g_log_procedure THEN
856: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
857: || l_api_name);
858: END IF;
859:

Line 856: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

852: l_return_status VARCHAR2 (1);
853: get_defaults_err EXCEPTION;
854: BEGIN
855: IF g_debug <= gme_debug.g_log_procedure THEN
856: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
857: || l_api_name);
858: END IF;
859:
860: x_material_detail_rec.formulaline_id :=

Line 916: IF g_debug <= gme_debug.g_log_procedure THEN

912: END IF;
913:
914: x_return_status := fnd_api.g_ret_sts_success;
915:
916: IF g_debug <= gme_debug.g_log_procedure THEN
917: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
918: END IF;
919: EXCEPTION
920: WHEN get_defaults_err THEN

Line 917: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

913:
914: x_return_status := fnd_api.g_ret_sts_success;
915:
916: IF g_debug <= gme_debug.g_log_procedure THEN
917: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
918: END IF;
919: EXCEPTION
920: WHEN get_defaults_err THEN
921: x_return_status := l_return_status;

Line 925: IF g_debug <= gme_debug.g_log_unexpected THEN

921: x_return_status := l_return_status;
922: WHEN OTHERS THEN
923: gme_common_pvt.log_message ('GME_API_MATL_DTL_SETUP_FAILURE');
924:
925: IF g_debug <= gme_debug.g_log_unexpected THEN
926: gme_debug.put_line ( 'When others exception in '
927: || g_pkg_name
928: || '.'
929: || l_api_name

Line 926: gme_debug.put_line ( 'When others exception in '

922: WHEN OTHERS THEN
923: gme_common_pvt.log_message ('GME_API_MATL_DTL_SETUP_FAILURE');
924:
925: IF g_debug <= gme_debug.g_log_unexpected THEN
926: gme_debug.put_line ( 'When others exception in '
927: || g_pkg_name
928: || '.'
929: || l_api_name
930: || ' Error is '

Line 1031: IF g_debug <= gme_debug.g_log_procedure THEN

1027: SELECT planned_process_loss, std_qty, detail_uom, inventory_item_id
1028: FROM gmd_recipe_validity_rules
1029: WHERE recipe_validity_rule_id = NVL (v_recipe_validity_rule_id, -1);
1030: BEGIN
1031: IF g_debug <= gme_debug.g_log_procedure THEN
1032: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1033: || l_api_name);
1034: END IF;
1035:

Line 1032: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

1028: FROM gmd_recipe_validity_rules
1029: WHERE recipe_validity_rule_id = NVL (v_recipe_validity_rule_id, -1);
1030: BEGIN
1031: IF g_debug <= gme_debug.g_log_procedure THEN
1032: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1033: || l_api_name);
1034: END IF;
1035:
1036: l_total_output_qty_pre_scale := p_total_output_qty_pre_scale;

Line 1039: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

1035:
1036: l_total_output_qty_pre_scale := p_total_output_qty_pre_scale;
1037: l_total_output_qty_scaled := p_total_output_qty_scaled;
1038:
1039: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1040: gme_debug.put_line (l_api_name || ': Parameters');
1041: gme_debug.put_line ('p_batch_id:' || p_batch_id);
1042: gme_debug.put_line ('p_validity_rule_id:' || p_validity_rule_id);
1043: gme_debug.put_line ('p_organization_id:' || p_organization_id);

Line 1040: gme_debug.put_line (l_api_name || ': Parameters');

1036: l_total_output_qty_pre_scale := p_total_output_qty_pre_scale;
1037: l_total_output_qty_scaled := p_total_output_qty_scaled;
1038:
1039: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1040: gme_debug.put_line (l_api_name || ': Parameters');
1041: gme_debug.put_line ('p_batch_id:' || p_batch_id);
1042: gme_debug.put_line ('p_validity_rule_id:' || p_validity_rule_id);
1043: gme_debug.put_line ('p_organization_id:' || p_organization_id);
1044: gme_debug.put_line ( 'p__total_output_qty_scaled:'

Line 1041: gme_debug.put_line ('p_batch_id:' || p_batch_id);

1037: l_total_output_qty_scaled := p_total_output_qty_scaled;
1038:
1039: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1040: gme_debug.put_line (l_api_name || ': Parameters');
1041: gme_debug.put_line ('p_batch_id:' || p_batch_id);
1042: gme_debug.put_line ('p_validity_rule_id:' || p_validity_rule_id);
1043: gme_debug.put_line ('p_organization_id:' || p_organization_id);
1044: gme_debug.put_line ( 'p__total_output_qty_scaled:'
1045: || p_total_output_qty_scaled);

Line 1042: gme_debug.put_line ('p_validity_rule_id:' || p_validity_rule_id);

1038:
1039: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1040: gme_debug.put_line (l_api_name || ': Parameters');
1041: gme_debug.put_line ('p_batch_id:' || p_batch_id);
1042: gme_debug.put_line ('p_validity_rule_id:' || p_validity_rule_id);
1043: gme_debug.put_line ('p_organization_id:' || p_organization_id);
1044: gme_debug.put_line ( 'p__total_output_qty_scaled:'
1045: || p_total_output_qty_scaled);
1046: gme_debug.put_line ( 'p__total_output_qty_pre_scale:'

Line 1043: gme_debug.put_line ('p_organization_id:' || p_organization_id);

1039: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1040: gme_debug.put_line (l_api_name || ': Parameters');
1041: gme_debug.put_line ('p_batch_id:' || p_batch_id);
1042: gme_debug.put_line ('p_validity_rule_id:' || p_validity_rule_id);
1043: gme_debug.put_line ('p_organization_id:' || p_organization_id);
1044: gme_debug.put_line ( 'p__total_output_qty_scaled:'
1045: || p_total_output_qty_scaled);
1046: gme_debug.put_line ( 'p__total_output_qty_pre_scale:'
1047: || p_total_output_qty_pre_scale);

Line 1044: gme_debug.put_line ( 'p__total_output_qty_scaled:'

1040: gme_debug.put_line (l_api_name || ': Parameters');
1041: gme_debug.put_line ('p_batch_id:' || p_batch_id);
1042: gme_debug.put_line ('p_validity_rule_id:' || p_validity_rule_id);
1043: gme_debug.put_line ('p_organization_id:' || p_organization_id);
1044: gme_debug.put_line ( 'p__total_output_qty_scaled:'
1045: || p_total_output_qty_scaled);
1046: gme_debug.put_line ( 'p__total_output_qty_pre_scale:'
1047: || p_total_output_qty_pre_scale);
1048: END IF;

Line 1046: gme_debug.put_line ( 'p__total_output_qty_pre_scale:'

1042: gme_debug.put_line ('p_validity_rule_id:' || p_validity_rule_id);
1043: gme_debug.put_line ('p_organization_id:' || p_organization_id);
1044: gme_debug.put_line ( 'p__total_output_qty_scaled:'
1045: || p_total_output_qty_scaled);
1046: gme_debug.put_line ( 'p__total_output_qty_pre_scale:'
1047: || p_total_output_qty_pre_scale);
1048: END IF;
1049:
1050: /* Use and validate the batch id if it is passed in. */

Line 1090: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

1086: INTO l_routing_class, l_routing_uom, l_routing_class_uom, l_routing_process_loss, l_routing_qty;
1087:
1088: CLOSE cur_get_rtclass;
1089: ELSE
1090: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1091: gme_debug.put_line (l_api_name || ': No routing defined');
1092: END IF;
1093: END IF;
1094:

Line 1091: gme_debug.put_line (l_api_name || ': No routing defined');

1087:
1088: CLOSE cur_get_rtclass;
1089: ELSE
1090: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1091: gme_debug.put_line (l_api_name || ': No routing defined');
1092: END IF;
1093: END IF;
1094:
1095: -- Determine the process loss.

Line 1107: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

1103:
1104: CLOSE validity_process_loss_cursor;
1105:
1106: IF l_process_loss_a IS NULL THEN
1107: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1108: gme_debug.put_line ( l_api_name
1109: || ': No process_loss at validity level');
1110: END IF;
1111:

Line 1108: gme_debug.put_line ( l_api_name

1104: CLOSE validity_process_loss_cursor;
1105:
1106: IF l_process_loss_a IS NULL THEN
1107: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1108: gme_debug.put_line ( l_api_name
1109: || ': No process_loss at validity level');
1110: END IF;
1111:
1112: --Bug#5618961 initializing the variables if we did not find process loss VR level

Line 1125: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

1121:
1122: CLOSE orgn_process_loss_cursor;
1123:
1124: IF l_process_loss_a IS NULL THEN
1125: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1126: gme_debug.put_line ( l_api_name
1127: || ': No process_loss at orgn level');
1128: END IF;
1129:

Line 1126: gme_debug.put_line ( l_api_name

1122: CLOSE orgn_process_loss_cursor;
1123:
1124: IF l_process_loss_a IS NULL THEN
1125: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1126: gme_debug.put_line ( l_api_name
1127: || ': No process_loss at orgn level');
1128: END IF;
1129:
1130: OPEN recipe_process_loss_cursor (l_recipe_id);

Line 1138: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

1134:
1135: CLOSE recipe_process_loss_cursor;
1136:
1137: IF l_process_loss_a IS NULL THEN
1138: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1139: gme_debug.put_line ( l_api_name
1140: || 'No process_loss at recipe level');
1141: END IF;
1142:

Line 1139: gme_debug.put_line ( l_api_name

1135: CLOSE recipe_process_loss_cursor;
1136:
1137: IF l_process_loss_a IS NULL THEN
1138: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1139: gme_debug.put_line ( l_api_name
1140: || 'No process_loss at recipe level');
1141: END IF;
1142:
1143: --Bug#5618961 Begin commented the following cursor code as we already fetch the values

Line 1164: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

1160: l_process_loss := l_process_loss_a;
1161:
1162: --Bug#5618961 Begin assigning the actual qty tht has to be considered
1163: IF l_qty IS NOT NULL THEN
1164: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1165: gme_debug.put_line(l_api_name|| 'Qty to be considered for theoretical process loss'|| l_qty);
1166: END IF;
1167: l_total_output_qty_pre_scale := l_qty;
1168: END IF;

Line 1165: gme_debug.put_line(l_api_name|| 'Qty to be considered for theoretical process loss'|| l_qty);

1161:
1162: --Bug#5618961 Begin assigning the actual qty tht has to be considered
1163: IF l_qty IS NOT NULL THEN
1164: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1165: gme_debug.put_line(l_api_name|| 'Qty to be considered for theoretical process loss'|| l_qty);
1166: END IF;
1167: l_total_output_qty_pre_scale := l_qty;
1168: END IF;
1169:

Line 1183: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

1179: ,to_unit => l_routing_class_uom
1180: ,from_name => NULL
1181: ,to_name => NULL);
1182: IF l_qty < 0 THEN
1183: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1184: gme_debug.put_line( l_api_name
1185: || 'No process_loss at routing class level for output B'
1186: || l_total_output_qty_pre_scale);
1187: END IF;

Line 1184: gme_debug.put_line( l_api_name

1180: ,from_name => NULL
1181: ,to_name => NULL);
1182: IF l_qty < 0 THEN
1183: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1184: gme_debug.put_line( l_api_name
1185: || 'No process_loss at routing class level for output B'
1186: || l_total_output_qty_pre_scale);
1187: END IF;
1188: ELSE

Line 1191: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

1187: END IF;
1188: ELSE
1189: --assign the qty to pre scale i.e in routing class uom
1190: l_total_output_qty_pre_scale := l_qty;
1191: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1192: gme_debug.put_line(l_api_name|| 'Before scaled qty after converting to routing calss uom'|| l_qty);
1193: END IF;
1194: END IF; /*l_qty < 0 */
1195: END IF; /*l_uom <> l_routing_class_uom*/

Line 1192: gme_debug.put_line(l_api_name|| 'Before scaled qty after converting to routing calss uom'|| l_qty);

1188: ELSE
1189: --assign the qty to pre scale i.e in routing class uom
1190: l_total_output_qty_pre_scale := l_qty;
1191: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1192: gme_debug.put_line(l_api_name|| 'Before scaled qty after converting to routing calss uom'|| l_qty);
1193: END IF;
1194: END IF; /*l_qty < 0 */
1195: END IF; /*l_uom <> l_routing_class_uom*/
1196:

Line 1207: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

1203: ,to_unit => l_routing_class_uom
1204: ,from_name => NULL
1205: ,to_name => NULL);
1206: IF l_qty < 0 THEN
1207: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1208: gme_debug.put_line( l_api_name
1209: || 'No process_loss at routing class level for output B'
1210: || p_total_output_qty_scaled);
1211: END IF;

Line 1208: gme_debug.put_line( l_api_name

1204: ,from_name => NULL
1205: ,to_name => NULL);
1206: IF l_qty < 0 THEN
1207: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1208: gme_debug.put_line( l_api_name
1209: || 'No process_loss at routing class level for output B'
1210: || p_total_output_qty_scaled);
1211: END IF;
1212: ELSE

Line 1215: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

1211: END IF;
1212: ELSE
1213: --assign the qty to pre scale i.e in routing class uom
1214: l_total_output_qty_scaled := l_qty;
1215: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1216: gme_debug.put_line(l_api_name|| 'after scaled Qty after converting to routing calss uom'|| l_qty);
1217: END IF;
1218: END IF; /*l_qty < 0 */
1219: END IF; /*l_uom <> l_routing_class_uom*/

Line 1216: gme_debug.put_line(l_api_name|| 'after scaled Qty after converting to routing calss uom'|| l_qty);

1212: ELSE
1213: --assign the qty to pre scale i.e in routing class uom
1214: l_total_output_qty_scaled := l_qty;
1215: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1216: gme_debug.put_line(l_api_name|| 'after scaled Qty after converting to routing calss uom'|| l_qty);
1217: END IF;
1218: END IF; /*l_qty < 0 */
1219: END IF; /*l_uom <> l_routing_class_uom*/
1220:

Line 1241: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

1237:
1238: CLOSE class_process_loss_cursor;
1239:
1240: IF NVL (l_process_loss_b, 0) = 0 THEN
1241: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1242: gme_debug.put_line
1243: ( l_api_name
1244: || 'No process_loss at routing class level for output B'
1245: || p_total_output_qty_scaled);

Line 1242: gme_debug.put_line

1238: CLOSE class_process_loss_cursor;
1239:
1240: IF NVL (l_process_loss_b, 0) = 0 THEN
1241: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1242: gme_debug.put_line
1243: ( l_api_name
1244: || 'No process_loss at routing class level for output B'
1245: || p_total_output_qty_scaled);
1246: END IF;

Line 1259: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

1255:
1256: CLOSE class_process_loss_cursor;
1257:
1258: IF NVL (l_process_loss_c, 0) = 0 THEN
1259: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1260: gme_debug.put_line
1261: ( l_api_name
1262: || 'No process_loss at routing class level for output C'
1263: || p_total_output_qty_pre_scale);

Line 1260: gme_debug.put_line

1256: CLOSE class_process_loss_cursor;
1257:
1258: IF NVL (l_process_loss_c, 0) = 0 THEN
1259: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1260: gme_debug.put_line
1261: ( l_api_name
1262: || 'No process_loss at routing class level for output C'
1263: || p_total_output_qty_pre_scale);
1264: END IF;

Line 1270: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

1266: /* If it makes it here then it found a loss for both the pre and post scale quantities. */
1267: l_process_loss :=
1268: l_process_loss * l_process_loss_b / l_process_loss_c;
1269:
1270: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1271: gme_debug.put_line ( l_api_name
1272: || 'Process_loss a'
1273: || l_process_loss_a
1274: || 'Process_loss b'

Line 1271: gme_debug.put_line ( l_api_name

1267: l_process_loss :=
1268: l_process_loss * l_process_loss_b / l_process_loss_c;
1269:
1270: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1271: gme_debug.put_line ( l_api_name
1272: || 'Process_loss a'
1273: || l_process_loss_a
1274: || 'Process_loss b'
1275: || l_process_loss_b

Line 1284: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

1280: END IF; /* NVL (l_process_loss_b, 0) = 0 */
1281: END IF; /* l_routing_class IS NOT NULL */
1282: END IF; /* (l_routing_id IS NOT NULL AND l_process_loss > 0) */
1283:
1284: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1285: gme_debug.put_line ('Process Loss is ' || l_process_loss);
1286: END IF;
1287:
1288: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1285: gme_debug.put_line ('Process Loss is ' || l_process_loss);

1281: END IF; /* l_routing_class IS NOT NULL */
1282: END IF; /* (l_routing_id IS NOT NULL AND l_process_loss > 0) */
1283:
1284: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1285: gme_debug.put_line ('Process Loss is ' || l_process_loss);
1286: END IF;
1287:
1288: IF g_debug <= gme_debug.g_log_procedure THEN
1289: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

Line 1288: IF g_debug <= gme_debug.g_log_procedure THEN

1284: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1285: gme_debug.put_line ('Process Loss is ' || l_process_loss);
1286: END IF;
1287:
1288: IF g_debug <= gme_debug.g_log_procedure THEN
1289: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1290: END IF;
1291:
1292: RETURN (l_process_loss);

Line 1289: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

1285: gme_debug.put_line ('Process Loss is ' || l_process_loss);
1286: END IF;
1287:
1288: IF g_debug <= gme_debug.g_log_procedure THEN
1289: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1290: END IF;
1291:
1292: RETURN (l_process_loss);
1293: EXCEPTION

Line 1299: IF g_debug <= gme_debug.g_log_unexpected THEN

1295: RETURN (NULL);
1296: WHEN OTHERS THEN
1297: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1298:
1299: IF g_debug <= gme_debug.g_log_unexpected THEN
1300: gme_debug.put_line ( 'When others exception in '
1301: || g_pkg_name
1302: || '.'
1303: || l_api_name

Line 1300: gme_debug.put_line ( 'When others exception in '

1296: WHEN OTHERS THEN
1297: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1298:
1299: IF g_debug <= gme_debug.g_log_unexpected THEN
1300: gme_debug.put_line ( 'When others exception in '
1301: || g_pkg_name
1302: || '.'
1303: || l_api_name
1304: || ' Error is '

Line 1321: IF g_debug <= gme_debug.g_log_procedure THEN

1317: invalid_doc_no EXCEPTION;
1318: l_api_name CONSTANT VARCHAR2 (30) := 'create_document_no';
1319: PRAGMA AUTONOMOUS_TRANSACTION;
1320: BEGIN
1321: IF g_debug <= gme_debug.g_log_procedure THEN
1322: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1323: || l_api_name);
1324: END IF;
1325:

Line 1322: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

1318: l_api_name CONSTANT VARCHAR2 (30) := 'create_document_no';
1319: PRAGMA AUTONOMOUS_TRANSACTION;
1320: BEGIN
1321: IF g_debug <= gme_debug.g_log_procedure THEN
1322: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1323: || l_api_name);
1324: END IF;
1325:
1326: x_batch_header_rec := p_batch_header_rec;

Line 1363: IF g_debug <= gme_debug.g_log_procedure THEN

1359: ELSE
1360: ROLLBACK;
1361: END IF;
1362:
1363: IF g_debug <= gme_debug.g_log_procedure THEN
1364: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1365: END IF;
1366: EXCEPTION
1367: WHEN invalid_doc_no THEN

Line 1364: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

1360: ROLLBACK;
1361: END IF;
1362:
1363: IF g_debug <= gme_debug.g_log_procedure THEN
1364: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1365: END IF;
1366: EXCEPTION
1367: WHEN invalid_doc_no THEN
1368: x_batch_header_rec.batch_no := NULL;

Line 1383: IF g_debug <= gme_debug.g_log_unexpected THEN

1379: fnd_message.set_name ('GMA', 'SY_NODOCSEQREC');
1380: fnd_msg_pub.ADD;
1381: ROLLBACK;
1382: WHEN OTHERS THEN
1383: IF g_debug <= gme_debug.g_log_unexpected THEN
1384: gme_debug.put_line ( 'When others exception in '
1385: || g_pkg_name
1386: || '.'
1387: || l_api_name

Line 1384: gme_debug.put_line ( 'When others exception in '

1380: fnd_msg_pub.ADD;
1381: ROLLBACK;
1382: WHEN OTHERS THEN
1383: IF g_debug <= gme_debug.g_log_unexpected THEN
1384: gme_debug.put_line ( 'When others exception in '
1385: || g_pkg_name
1386: || '.'
1387: || l_api_name
1388: || ' Error is '

Line 1419: IF g_debug <= gme_debug.g_log_procedure THEN

1415: l_rule_rec cur_common_rules%ROWTYPE;
1416: l_total_leadtime NUMBER;
1417: l_api_name CONSTANT VARCHAR2 (30) := 'calc_date_from_prod_rule';
1418: BEGIN
1419: IF g_debug <= gme_debug.g_log_procedure THEN
1420: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1421: || l_api_name);
1422: END IF;
1423:

Line 1420: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

1416: l_total_leadtime NUMBER;
1417: l_api_name CONSTANT VARCHAR2 (30) := 'calc_date_from_prod_rule';
1418: BEGIN
1419: IF g_debug <= gme_debug.g_log_procedure THEN
1420: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1421: || l_api_name);
1422: END IF;
1423:
1424: OPEN cur_common_rules (p_organization_id, p_inventory_item_id);

Line 1461: IF g_debug <= gme_debug.g_log_procedure THEN

1457: x_start_date := gme_common_pvt.g_timestamp;
1458: x_cmplt_date := x_start_date + l_total_leadtime;
1459: END IF;
1460:
1461: IF g_debug <= gme_debug.g_log_procedure THEN
1462: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1463: END IF;
1464:
1465: RETURN TRUE;

Line 1462: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

1458: x_cmplt_date := x_start_date + l_total_leadtime;
1459: END IF;
1460:
1461: IF g_debug <= gme_debug.g_log_procedure THEN
1462: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1463: END IF;
1464:
1465: RETURN TRUE;
1466: EXCEPTION

Line 1468: IF g_debug <= gme_debug.g_log_unexpected THEN

1464:
1465: RETURN TRUE;
1466: EXCEPTION
1467: WHEN OTHERS THEN
1468: IF g_debug <= gme_debug.g_log_unexpected THEN
1469: gme_debug.put_line ( 'When others exception in '
1470: || g_pkg_name
1471: || '.'
1472: || l_api_name

Line 1469: gme_debug.put_line ( 'When others exception in '

1465: RETURN TRUE;
1466: EXCEPTION
1467: WHEN OTHERS THEN
1468: IF g_debug <= gme_debug.g_log_unexpected THEN
1469: gme_debug.put_line ( 'When others exception in '
1470: || g_pkg_name
1471: || '.'
1472: || l_api_name
1473: || ' Error is '

Line 1515: IF g_debug <= gme_debug.g_log_procedure THEN

1511: SELECT plan_start_date, plan_cmplt_date
1512: FROM gme_batch_header
1513: WHERE batch_id = v_batch_id;
1514: BEGIN
1515: IF g_debug <= gme_debug.g_log_procedure THEN
1516: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1517: || l_api_name);
1518: END IF;
1519:

Line 1516: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

1512: FROM gme_batch_header
1513: WHERE batch_id = v_batch_id;
1514: BEGIN
1515: IF g_debug <= gme_debug.g_log_procedure THEN
1516: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1517: || l_api_name);
1518: END IF;
1519:
1520: x_return_status := fnd_api.g_ret_sts_success;

Line 1578: IF g_debug <= gme_debug.g_log_procedure THEN

1574: x_mtl_req_date := l_batch_cmplt_date;
1575: END IF;
1576: END IF;
1577:
1578: IF g_debug <= gme_debug.g_log_procedure THEN
1579: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1580: END IF;
1581: EXCEPTION
1582: WHEN OTHERS THEN

Line 1579: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

1575: END IF;
1576: END IF;
1577:
1578: IF g_debug <= gme_debug.g_log_procedure THEN
1579: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1580: END IF;
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 1583: IF g_debug <= gme_debug.g_log_unexpected THEN

1579: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1580: END IF;
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: IF g_debug <= gme_debug.g_log_unexpected THEN
1584: gme_debug.put_line ( 'When others exception in '
1585: || g_pkg_name
1586: || '.'
1587: || l_api_name

Line 1584: gme_debug.put_line ( 'When others exception in '

1580: END IF;
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: IF g_debug <= gme_debug.g_log_unexpected THEN
1584: gme_debug.put_line ( 'When others exception in '
1585: || g_pkg_name
1586: || '.'
1587: || l_api_name
1588: || ' Error is '

Line 1624: IF g_debug <= gme_debug.g_log_procedure THEN

1620: l_plan_activity_factor NUMBER;
1621: l_actual_activity_factor NUMBER;
1622: l_api_name CONSTANT VARCHAR2 (30) := 'is_qty_below_capacity';
1623: BEGIN
1624: IF g_debug <= gme_debug.g_log_procedure THEN
1625: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1626: || l_api_name);
1627: END IF;
1628:

Line 1625: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

1621: l_actual_activity_factor NUMBER;
1622: l_api_name CONSTANT VARCHAR2 (30) := 'is_qty_below_capacity';
1623: BEGIN
1624: IF g_debug <= gme_debug.g_log_procedure THEN
1625: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1626: || l_api_name);
1627: END IF;
1628:
1629: /* If capacities are not defined for the resource then we have nothing to check against so return true */

Line 1632: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

1628:
1629: /* If capacities are not defined for the resource then we have nothing to check against so return true */
1630: IF (p_batch_step_resources_rec.min_capacity IS NULL)
1631: OR (p_batch_step_resources_rec.capacity_um IS NULL) THEN
1632: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1633: gme_debug.put_line
1634: (' Resource min capacity or capacity um is null');
1635: RETURN FALSE;
1636: END IF;

Line 1633: gme_debug.put_line

1629: /* If capacities are not defined for the resource then we have nothing to check against so return true */
1630: IF (p_batch_step_resources_rec.min_capacity IS NULL)
1631: OR (p_batch_step_resources_rec.capacity_um IS NULL) THEN
1632: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1633: gme_debug.put_line
1634: (' Resource min capacity or capacity um is null');
1635: RETURN FALSE;
1636: END IF;
1637: END IF;

Line 1639: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

1635: RETURN FALSE;
1636: END IF;
1637: END IF;
1638:
1639: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1640: gme_debug.put_line ( ' Resource min capacity:'
1641: || p_batch_step_resources_rec.min_capacity
1642: || ' Capacity UM:'
1643: || p_batch_step_resources_rec.capacity_um

Line 1640: gme_debug.put_line ( ' Resource min capacity:'

1636: END IF;
1637: END IF;
1638:
1639: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1640: gme_debug.put_line ( ' Resource min capacity:'
1641: || p_batch_step_resources_rec.min_capacity
1642: || ' Capacity UM:'
1643: || p_batch_step_resources_rec.capacity_um
1644: || ' Resource UOM:'

Line 1669: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

1665: l_resource_qty :=
1666: p_batch_step_resources_rec.actual_rsrc_qty
1667: / l_actual_activity_factor;
1668:
1669: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1670: gme_debug.put_line ( ' Resource Qty by Actual:'
1671: || l_resource_qty
1672: || ' Activity Factor:'
1673: || l_actual_activity_factor);

Line 1670: gme_debug.put_line ( ' Resource Qty by Actual:'

1666: p_batch_step_resources_rec.actual_rsrc_qty
1667: / l_actual_activity_factor;
1668:
1669: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1670: gme_debug.put_line ( ' Resource Qty by Actual:'
1671: || l_resource_qty
1672: || ' Activity Factor:'
1673: || l_actual_activity_factor);
1674: END IF;

Line 1685: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

1681: l_resource_qty :=
1682: p_batch_step_resources_rec.plan_rsrc_qty
1683: / l_plan_activity_factor;
1684:
1685: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1686: gme_debug.put_line ( ' Resource Qty by Plan:'
1687: || l_resource_qty
1688: || ' Activity Factor:'
1689: || l_plan_activity_factor);

Line 1686: gme_debug.put_line ( ' Resource Qty by Plan:'

1682: p_batch_step_resources_rec.plan_rsrc_qty
1683: / l_plan_activity_factor;
1684:
1685: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1686: gme_debug.put_line ( ' Resource Qty by Plan:'
1687: || l_resource_qty
1688: || ' Activity Factor:'
1689: || l_plan_activity_factor);
1690: END IF;

Line 1725: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

1721: INTO l_qty_um_type, l_qty_std_factor;
1722:
1723: CLOSE cur_get_um_type;
1724:
1725: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1726: gme_debug.put_line ( ' Capacity uom type:'
1727: || l_cap_um_type
1728: || ' Std Factor:'
1729: || l_cap_std_factor

Line 1726: gme_debug.put_line ( ' Capacity uom type:'

1722:
1723: CLOSE cur_get_um_type;
1724:
1725: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1726: gme_debug.put_line ( ' Capacity uom type:'
1727: || l_cap_um_type
1728: || ' Std Factor:'
1729: || l_cap_std_factor
1730: || ' Qty uom type:'

Line 1753: IF g_debug <= gme_debug.g_log_procedure THEN

1749: END IF; /* IF l_cap_um_type <> l_qty_um_type */
1750: END IF;
1751: /* IF p_batch_step_resources_rec.capacity_uom = p_batch_step_resources_rec.process_qty_um */
1752:
1753: IF g_debug <= gme_debug.g_log_procedure THEN
1754: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1755: END IF;
1756: EXCEPTION
1757: WHEN OTHERS THEN

Line 1754: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

1750: END IF;
1751: /* IF p_batch_step_resources_rec.capacity_uom = p_batch_step_resources_rec.process_qty_um */
1752:
1753: IF g_debug <= gme_debug.g_log_procedure THEN
1754: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1755: END IF;
1756: EXCEPTION
1757: WHEN OTHERS THEN
1758: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 1758: IF g_debug <= gme_debug.g_log_unexpected THEN

1754: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1755: END IF;
1756: EXCEPTION
1757: WHEN OTHERS THEN
1758: IF g_debug <= gme_debug.g_log_unexpected THEN
1759: gme_debug.put_line ( 'When others exception in '
1760: || g_pkg_name
1761: || '.'
1762: || l_api_name

Line 1759: gme_debug.put_line ( 'When others exception in '

1755: END IF;
1756: EXCEPTION
1757: WHEN OTHERS THEN
1758: IF g_debug <= gme_debug.g_log_unexpected THEN
1759: gme_debug.put_line ( 'When others exception in '
1760: || g_pkg_name
1761: || '.'
1762: || l_api_name
1763: || ' Error is '

Line 1795: IF g_debug <= gme_debug.g_log_procedure THEN

1791: l_found NUMBER (5) DEFAULT 0;
1792: l_resources VARCHAR2 (2000);
1793: l_api_name CONSTANT VARCHAR2 (30) := 'resource_qty_below_capacity';
1794: BEGIN
1795: IF g_debug <= gme_debug.g_log_procedure THEN
1796: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1797: || l_api_name);
1798: END IF;
1799:

Line 1796: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

1792: l_resources VARCHAR2 (2000);
1793: l_api_name CONSTANT VARCHAR2 (30) := 'resource_qty_below_capacity';
1794: BEGIN
1795: IF g_debug <= gme_debug.g_log_procedure THEN
1796: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1797: || l_api_name);
1798: END IF;
1799:
1800: OPEN cur_get_resources;

Line 1831: IF g_debug <= gme_debug.g_log_procedure THEN

1827: END LOOP;
1828: /* FOR i IN 1..l_resource_ids.COUNT */
1829: /* If we have found atleast one resource falling below capacity then return true */
1830:
1831: IF g_debug <= gme_debug.g_log_procedure THEN
1832: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1833: END IF;
1834:
1835: IF l_found = 1 THEN

Line 1832: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

1828: /* FOR i IN 1..l_resource_ids.COUNT */
1829: /* If we have found atleast one resource falling below capacity then return true */
1830:
1831: IF g_debug <= gme_debug.g_log_procedure THEN
1832: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1833: END IF;
1834:
1835: IF l_found = 1 THEN
1836: gme_common_pvt.log_message ('GME_API_RSRC_QTY_BELOW_CAP'

Line 1845: IF g_debug <= gme_debug.g_log_unexpected THEN

1841: RETURN FALSE;
1842: END IF;
1843: EXCEPTION
1844: WHEN OTHERS THEN
1845: IF g_debug <= gme_debug.g_log_unexpected THEN
1846: gme_debug.put_line ( 'When others exception in '
1847: || g_pkg_name
1848: || '.'
1849: || l_api_name

Line 1846: gme_debug.put_line ( 'When others exception in '

1842: END IF;
1843: EXCEPTION
1844: WHEN OTHERS THEN
1845: IF g_debug <= gme_debug.g_log_unexpected THEN
1846: gme_debug.put_line ( 'When others exception in '
1847: || g_pkg_name
1848: || '.'
1849: || l_api_name
1850: || ' Error is '

Line 1907: IF g_debug <= gme_debug.g_log_procedure THEN

1903: org_info_not_provided EXCEPTION;
1904: subinventory_info_not_provided EXCEPTION;
1905: item_info_not_provided EXCEPTION;
1906: BEGIN
1907: IF g_debug <= gme_debug.g_log_procedure THEN
1908: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1909: || l_api_name);
1910: END IF;
1911:

Line 1908: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

1904: subinventory_info_not_provided EXCEPTION;
1905: item_info_not_provided EXCEPTION;
1906: BEGIN
1907: IF g_debug <= gme_debug.g_log_procedure THEN
1908: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1909: || l_api_name);
1910: END IF;
1911:
1912: IF (p_org_control IS NULL OR p_org_neg_allowed IS NULL) THEN

Line 1971: IF g_debug <= gme_debug.g_log_procedure THEN

1967: ,p_item_loc_restrict => l_item_loc_restrict
1968: ,p_org_neg_allowed => l_org_neg_allowed
1969: ,p_action => p_action);
1970:
1971: IF g_debug <= gme_debug.g_log_procedure THEN
1972: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1973: END IF;
1974:
1975: RETURN l_eff_control;

Line 1972: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

1968: ,p_org_neg_allowed => l_org_neg_allowed
1969: ,p_action => p_action);
1970:
1971: IF g_debug <= gme_debug.g_log_procedure THEN
1972: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1973: END IF;
1974:
1975: RETURN l_eff_control;
1976: EXCEPTION

Line 1984: IF g_debug <= gme_debug.g_log_unexpected THEN

1980: RETURN -1;
1981: WHEN item_info_not_provided THEN
1982: RETURN -1;
1983: WHEN OTHERS THEN
1984: IF g_debug <= gme_debug.g_log_unexpected THEN
1985: gme_debug.put_line ( 'When others exception in '
1986: || g_pkg_name
1987: || '.'
1988: || l_api_name

Line 1985: gme_debug.put_line ( 'When others exception in '

1981: WHEN item_info_not_provided THEN
1982: RETURN -1;
1983: WHEN OTHERS THEN
1984: IF g_debug <= gme_debug.g_log_unexpected THEN
1985: gme_debug.put_line ( 'When others exception in '
1986: || g_pkg_name
1987: || '.'
1988: || l_api_name
1989: || ' Error is '

Line 2016: IF g_debug <= gme_debug.g_log_procedure THEN

2012: l_org inv_validate.org;
2013: l_item inv_validate.item;
2014: l_sub inv_validate.sub;
2015: BEGIN
2016: IF g_debug <= gme_debug.g_log_procedure THEN
2017: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2018: || l_api_name);
2019: END IF;
2020:

Line 2017: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

2013: l_item inv_validate.item;
2014: l_sub inv_validate.sub;
2015: BEGIN
2016: IF g_debug <= gme_debug.g_log_procedure THEN
2017: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2018: || l_api_name);
2019: END IF;
2020:
2021: IF g_debug <= gme_debug.g_log_statement THEN

Line 2021: IF g_debug <= gme_debug.g_log_statement THEN

2017: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2018: || l_api_name);
2019: END IF;
2020:
2021: IF g_debug <= gme_debug.g_log_statement THEN
2022: gme_debug.put_line ( g_pkg_name
2023: || '.'
2024: || l_api_name
2025: || 'p_organization_id '

Line 2022: gme_debug.put_line ( g_pkg_name

2018: || l_api_name);
2019: END IF;
2020:
2021: IF g_debug <= gme_debug.g_log_statement THEN
2022: gme_debug.put_line ( g_pkg_name
2023: || '.'
2024: || l_api_name
2025: || 'p_organization_id '
2026: || p_organization_id);

Line 2027: gme_debug.put_line ( g_pkg_name

2023: || '.'
2024: || l_api_name
2025: || 'p_organization_id '
2026: || p_organization_id);
2027: gme_debug.put_line ( g_pkg_name
2028: || '.'
2029: || l_api_name
2030: || 'p_locator_id '
2031: || p_locator_id);

Line 2032: gme_debug.put_line ( g_pkg_name

2028: || '.'
2029: || l_api_name
2030: || 'p_locator_id '
2031: || p_locator_id);
2032: gme_debug.put_line ( g_pkg_name
2033: || '.'
2034: || l_api_name
2035: || 'p_subinventory '
2036: || p_subinventory);

Line 2037: gme_debug.put_line ( g_pkg_name

2033: || '.'
2034: || l_api_name
2035: || 'p_subinventory '
2036: || p_subinventory);
2037: gme_debug.put_line ( g_pkg_name
2038: || '.'
2039: || l_api_name
2040: || 'p_inventory_item_id '
2041: || p_inventory_item_id);

Line 2042: gme_debug.put_line ( g_pkg_name

2038: || '.'
2039: || l_api_name
2040: || 'p_inventory_item_id '
2041: || p_inventory_item_id);
2042: gme_debug.put_line ( g_pkg_name
2043: || '.'
2044: || l_api_name
2045: || 'p_txn_action_id '
2046: || p_txn_action_id);

Line 2073: IF g_debug <= gme_debug.g_log_statement THEN

2069: inv_validate.f) THEN
2070: fnd_message.set_name ('INV', 'INV_INVALID_LOCATION');
2071: fnd_msg_pub.ADD;
2072:
2073: IF g_debug <= gme_debug.g_log_statement THEN
2074: gme_debug.put_line ( g_pkg_name
2075: || '.'
2076: || l_api_name
2077: || ' Locator IS invalid');

Line 2074: gme_debug.put_line ( g_pkg_name

2070: fnd_message.set_name ('INV', 'INV_INVALID_LOCATION');
2071: fnd_msg_pub.ADD;
2072:
2073: IF g_debug <= gme_debug.g_log_statement THEN
2074: gme_debug.put_line ( g_pkg_name
2075: || '.'
2076: || l_api_name
2077: || ' Locator IS invalid');
2078: END IF;

Line 2083: IF g_debug <= gme_debug.g_log_procedure THEN

2079:
2080: RETURN FALSE;
2081: END IF;
2082:
2083: IF g_debug <= gme_debug.g_log_procedure THEN
2084: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2085: END IF;
2086:
2087: RETURN TRUE;

Line 2084: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

2080: RETURN FALSE;
2081: END IF;
2082:
2083: IF g_debug <= gme_debug.g_log_procedure THEN
2084: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2085: END IF;
2086:
2087: RETURN TRUE;
2088: EXCEPTION

Line 2090: IF g_debug <= gme_debug.g_log_unexpected THEN

2086:
2087: RETURN TRUE;
2088: EXCEPTION
2089: WHEN OTHERS THEN
2090: IF g_debug <= gme_debug.g_log_unexpected THEN
2091: gme_debug.put_line ( 'WHEN OTHERS EXCEPTION IN '
2092: || g_pkg_name
2093: || '.'
2094: || l_api_name

Line 2091: gme_debug.put_line ( 'WHEN OTHERS EXCEPTION IN '

2087: RETURN TRUE;
2088: EXCEPTION
2089: WHEN OTHERS THEN
2090: IF g_debug <= gme_debug.g_log_unexpected THEN
2091: gme_debug.put_line ( 'WHEN OTHERS EXCEPTION IN '
2092: || g_pkg_name
2093: || '.'
2094: || l_api_name
2095: || ' Error IS '

Line 2124: IF g_debug <= gme_debug.g_log_procedure THEN

2120: AND inventory_item_id = p_inventory_item_id;
2121:
2122: l_item_restict_subinv NUMBER;
2123: BEGIN
2124: IF g_debug <= gme_debug.g_log_procedure THEN
2125: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2126: || l_api_name);
2127: END IF;
2128:

Line 2125: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

2121:
2122: l_item_restict_subinv NUMBER;
2123: BEGIN
2124: IF g_debug <= gme_debug.g_log_procedure THEN
2125: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2126: || l_api_name);
2127: END IF;
2128:
2129: IF g_debug <= gme_debug.g_log_statement THEN

Line 2129: IF g_debug <= gme_debug.g_log_statement THEN

2125: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2126: || l_api_name);
2127: END IF;
2128:
2129: IF g_debug <= gme_debug.g_log_statement THEN
2130: gme_debug.put_line ( g_pkg_name
2131: || '.'
2132: || l_api_name
2133: || 'p_organization_id '

Line 2130: gme_debug.put_line ( g_pkg_name

2126: || l_api_name);
2127: END IF;
2128:
2129: IF g_debug <= gme_debug.g_log_statement THEN
2130: gme_debug.put_line ( g_pkg_name
2131: || '.'
2132: || l_api_name
2133: || 'p_organization_id '
2134: || p_organization_id);

Line 2135: gme_debug.put_line ( g_pkg_name

2131: || '.'
2132: || l_api_name
2133: || 'p_organization_id '
2134: || p_organization_id);
2135: gme_debug.put_line ( g_pkg_name
2136: || '.'
2137: || l_api_name
2138: || 'p_subinventory '
2139: || p_subinventory);

Line 2140: gme_debug.put_line ( g_pkg_name

2136: || '.'
2137: || l_api_name
2138: || 'p_subinventory '
2139: || p_subinventory);
2140: gme_debug.put_line ( g_pkg_name
2141: || '.'
2142: || l_api_name
2143: || 'p_inventory_item_id '
2144: || p_inventory_item_id);

Line 2166: IF g_debug <= gme_debug.g_log_statement THEN

2162: IF (l_item_restict_subinv = 1) THEN
2163: IF (inv_validate.subinventory (p_org => l_org
2164: ,p_item => l_item
2165: ,p_sub => l_sub) = inv_validate.f) THEN
2166: IF g_debug <= gme_debug.g_log_statement THEN
2167: gme_debug.put_line ( g_pkg_name
2168: || '.'
2169: || l_api_name
2170: || ' Subinventory is invalid');

Line 2167: gme_debug.put_line ( g_pkg_name

2163: IF (inv_validate.subinventory (p_org => l_org
2164: ,p_item => l_item
2165: ,p_sub => l_sub) = inv_validate.f) THEN
2166: IF g_debug <= gme_debug.g_log_statement THEN
2167: gme_debug.put_line ( g_pkg_name
2168: || '.'
2169: || l_api_name
2170: || ' Subinventory is invalid');
2171: END IF;

Line 2178: IF g_debug <= gme_debug.g_log_statement THEN

2174: END IF;
2175: ELSE
2176: IF (inv_validate.subinventory (p_org => l_org, p_sub => l_sub) =
2177: inv_validate.f) THEN
2178: IF g_debug <= gme_debug.g_log_statement THEN
2179: gme_debug.put_line ( g_pkg_name
2180: || '.'
2181: || l_api_name
2182: || ' Subinventory is invalid');

Line 2179: gme_debug.put_line ( g_pkg_name

2175: ELSE
2176: IF (inv_validate.subinventory (p_org => l_org, p_sub => l_sub) =
2177: inv_validate.f) THEN
2178: IF g_debug <= gme_debug.g_log_statement THEN
2179: gme_debug.put_line ( g_pkg_name
2180: || '.'
2181: || l_api_name
2182: || ' Subinventory is invalid');
2183: END IF;

Line 2189: IF g_debug <= gme_debug.g_log_procedure THEN

2185: RETURN FALSE;
2186: END IF;
2187: END IF;
2188:
2189: IF g_debug <= gme_debug.g_log_procedure THEN
2190: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2191: END IF;
2192:
2193: RETURN TRUE;

Line 2190: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

2186: END IF;
2187: END IF;
2188:
2189: IF g_debug <= gme_debug.g_log_procedure THEN
2190: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2191: END IF;
2192:
2193: RETURN TRUE;
2194: EXCEPTION

Line 2196: IF g_debug <= gme_debug.g_log_unexpected THEN

2192:
2193: RETURN TRUE;
2194: EXCEPTION
2195: WHEN OTHERS THEN
2196: IF g_debug <= gme_debug.g_log_unexpected THEN
2197: gme_debug.put_line ( 'When others exception in '
2198: || g_pkg_name
2199: || '.'
2200: || l_api_name

Line 2197: gme_debug.put_line ( 'When others exception in '

2193: RETURN TRUE;
2194: EXCEPTION
2195: WHEN OTHERS THEN
2196: IF g_debug <= gme_debug.g_log_unexpected THEN
2197: gme_debug.put_line ( 'When others exception in '
2198: || g_pkg_name
2199: || '.'
2200: || l_api_name
2201: || ' Error is '

Line 2259: IF g_debug <= gme_debug.g_log_procedure THEN

2255: /* EXCEPTION Definitions */
2256: uom_conversion_failure EXCEPTION;
2257: validation_failure EXCEPTION;
2258: BEGIN
2259: IF g_debug <= gme_debug.g_log_procedure THEN
2260: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2261: || l_api_name);
2262: END IF;
2263:

Line 2260: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

2256: uom_conversion_failure EXCEPTION;
2257: validation_failure EXCEPTION;
2258: BEGIN
2259: IF g_debug <= gme_debug.g_log_procedure THEN
2260: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2261: || l_api_name);
2262: END IF;
2263:
2264: OPEN get_validity_rule (p_validity_rule_id);

Line 2429: IF g_debug <= gme_debug.g_log_procedure THEN

2425: OR l_recipe_validity_tbl.COUNT <= 0 THEN
2426: RAISE validation_failure;
2427: END IF;
2428:
2429: IF g_debug <= gme_debug.g_log_procedure THEN
2430: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2431: END IF;
2432:
2433: RETURN TRUE;

Line 2430: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

2426: RAISE validation_failure;
2427: END IF;
2428:
2429: IF g_debug <= gme_debug.g_log_procedure THEN
2430: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2431: END IF;
2432:
2433: RETURN TRUE;
2434: EXCEPTION

Line 2445: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

2441:
2442: CLOSE cur_item_no;
2443: END IF;
2444:
2445: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2446: gme_debug.put_line
2447: ('UOM conversion failed in validate_validity_rule');
2448: END IF;
2449:

Line 2446: gme_debug.put_line

2442: CLOSE cur_item_no;
2443: END IF;
2444:
2445: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2446: gme_debug.put_line
2447: ('UOM conversion failed in validate_validity_rule');
2448: END IF;
2449:
2450: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');

Line 2460: IF g_debug <= gme_debug.g_log_unexpected THEN

2456: WHEN validation_failure THEN
2457: gme_common_pvt.log_message ('GME_INVALID_VALIDITY_RULE_QTY');
2458: RETURN FALSE;
2459: WHEN OTHERS THEN
2460: IF g_debug <= gme_debug.g_log_unexpected THEN
2461: gme_debug.put_line ( 'When others exception in '
2462: || g_pkg_name
2463: || '.'
2464: || l_api_name

Line 2461: gme_debug.put_line ( 'When others exception in '

2457: gme_common_pvt.log_message ('GME_INVALID_VALIDITY_RULE_QTY');
2458: RETURN FALSE;
2459: WHEN OTHERS THEN
2460: IF g_debug <= gme_debug.g_log_unexpected THEN
2461: gme_debug.put_line ( 'When others exception in '
2462: || g_pkg_name
2463: || '.'
2464: || l_api_name
2465: || ' Error is '

Line 2594: gme_debug.log_initialize ('BatchShortages');

2590: l_count NUMBER := 0;
2591: l_allocated_qty NUMBER := 0;
2592: BEGIN
2593: IF (g_debug IS NOT NULL) THEN
2594: gme_debug.log_initialize ('BatchShortages');
2595: END IF;
2596: IF g_debug <= gme_debug.g_log_procedure THEN
2597: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
2598: gme_debug.put_line ('p_tree_mode '||p_tree_mode);

Line 2596: IF g_debug <= gme_debug.g_log_procedure THEN

2592: BEGIN
2593: IF (g_debug IS NOT NULL) THEN
2594: gme_debug.log_initialize ('BatchShortages');
2595: END IF;
2596: IF g_debug <= gme_debug.g_log_procedure THEN
2597: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
2598: gme_debug.put_line ('p_tree_mode '||p_tree_mode);
2599: END IF;
2600: x_return_status := fnd_api.g_ret_sts_success;

Line 2597: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);

2593: IF (g_debug IS NOT NULL) THEN
2594: gme_debug.log_initialize ('BatchShortages');
2595: END IF;
2596: IF g_debug <= gme_debug.g_log_procedure THEN
2597: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
2598: gme_debug.put_line ('p_tree_mode '||p_tree_mode);
2599: END IF;
2600: x_return_status := fnd_api.g_ret_sts_success;
2601: IF NOT (gme_common_pvt.g_setup_done) THEN

Line 2598: gme_debug.put_line ('p_tree_mode '||p_tree_mode);

2594: gme_debug.log_initialize ('BatchShortages');
2595: END IF;
2596: IF g_debug <= gme_debug.g_log_procedure THEN
2597: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
2598: gme_debug.put_line ('p_tree_mode '||p_tree_mode);
2599: END IF;
2600: x_return_status := fnd_api.g_ret_sts_success;
2601: IF NOT (gme_common_pvt.g_setup_done) THEN
2602: IF NOT (gme_common_pvt.setup (p_org_id => p_organization_id) ) THEN

Line 2669: IF g_debug <= gme_debug.g_log_statement THEN

2665: l_open_qty_prim := l_temp_qty;
2666: END IF;
2667: END IF;
2668: END IF;
2669: IF g_debug <= gme_debug.g_log_statement THEN
2670: gme_debug.put_line ('item = ' || l_item_rec.concatenated_segments);
2671: gme_debug.put_line ('l_open_qty_prim = ' || l_open_qty_prim);
2672: END IF;
2673: IF (l_open_qty_prim > 0) THEN

Line 2670: gme_debug.put_line ('item = ' || l_item_rec.concatenated_segments);

2666: END IF;
2667: END IF;
2668: END IF;
2669: IF g_debug <= gme_debug.g_log_statement THEN
2670: gme_debug.put_line ('item = ' || l_item_rec.concatenated_segments);
2671: gme_debug.put_line ('l_open_qty_prim = ' || l_open_qty_prim);
2672: END IF;
2673: IF (l_open_qty_prim > 0) THEN
2674: IF (p_invoke_mode = 'S') THEN

Line 2671: gme_debug.put_line ('l_open_qty_prim = ' || l_open_qty_prim);

2667: END IF;
2668: END IF;
2669: IF g_debug <= gme_debug.g_log_statement THEN
2670: gme_debug.put_line ('item = ' || l_item_rec.concatenated_segments);
2671: gme_debug.put_line ('l_open_qty_prim = ' || l_open_qty_prim);
2672: END IF;
2673: IF (l_open_qty_prim > 0) THEN
2674: IF (p_invoke_mode = 'S') THEN
2675: l_subinventory := l_mtl_dtl_rec.subinventory;

Line 2681: IF g_debug <= gme_debug.g_log_statement THEN

2677: l_subinventory := NULL;
2678: END IF;
2679: l_item_hash := RPAD(l_mtl_dtl_rec.inventory_item_id, 12, 'X')||'***'||NVL(l_subinventory, '##########');
2680: l_mtl_hash := RPAD(l_mtl_dtl_rec.inventory_item_id, 12, 'X')||NVL(RPAD(l_mtl_dtl_rec.revision, 3, '*'), '***')||NVL(RPAD(l_subinventory, 10, '#'), '##########');
2681: IF g_debug <= gme_debug.g_log_statement THEN
2682: gme_debug.put_line ('l_item_hash = ' || l_item_hash);
2683: gme_debug.put_line ('l_mtl_hash = ' || l_mtl_hash);
2684: END IF;
2685: BEGIN

Line 2682: gme_debug.put_line ('l_item_hash = ' || l_item_hash);

2678: END IF;
2679: l_item_hash := RPAD(l_mtl_dtl_rec.inventory_item_id, 12, 'X')||'***'||NVL(l_subinventory, '##########');
2680: l_mtl_hash := RPAD(l_mtl_dtl_rec.inventory_item_id, 12, 'X')||NVL(RPAD(l_mtl_dtl_rec.revision, 3, '*'), '***')||NVL(RPAD(l_subinventory, 10, '#'), '##########');
2681: IF g_debug <= gme_debug.g_log_statement THEN
2682: gme_debug.put_line ('l_item_hash = ' || l_item_hash);
2683: gme_debug.put_line ('l_mtl_hash = ' || l_mtl_hash);
2684: END IF;
2685: BEGIN
2686: l_item_onhand := l_qty_tbl(l_item_hash).onhand;

Line 2683: gme_debug.put_line ('l_mtl_hash = ' || l_mtl_hash);

2679: l_item_hash := RPAD(l_mtl_dtl_rec.inventory_item_id, 12, 'X')||'***'||NVL(l_subinventory, '##########');
2680: l_mtl_hash := RPAD(l_mtl_dtl_rec.inventory_item_id, 12, 'X')||NVL(RPAD(l_mtl_dtl_rec.revision, 3, '*'), '***')||NVL(RPAD(l_subinventory, 10, '#'), '##########');
2681: IF g_debug <= gme_debug.g_log_statement THEN
2682: gme_debug.put_line ('l_item_hash = ' || l_item_hash);
2683: gme_debug.put_line ('l_mtl_hash = ' || l_mtl_hash);
2684: END IF;
2685: BEGIN
2686: l_item_onhand := l_qty_tbl(l_item_hash).onhand;
2687: l_item_available := l_qty_tbl(l_item_hash).available;

Line 2688: IF g_debug <= gme_debug.g_log_statement THEN

2684: END IF;
2685: BEGIN
2686: l_item_onhand := l_qty_tbl(l_item_hash).onhand;
2687: l_item_available := l_qty_tbl(l_item_hash).available;
2688: IF g_debug <= gme_debug.g_log_statement THEN
2689: gme_debug.put_line ('found l_item_onhand = ' || l_item_onhand);
2690: gme_debug.put_line ('found l_item_available = ' || l_item_available);
2691: END IF;
2692: EXCEPTION

Line 2689: gme_debug.put_line ('found l_item_onhand = ' || l_item_onhand);

2685: BEGIN
2686: l_item_onhand := l_qty_tbl(l_item_hash).onhand;
2687: l_item_available := l_qty_tbl(l_item_hash).available;
2688: IF g_debug <= gme_debug.g_log_statement THEN
2689: gme_debug.put_line ('found l_item_onhand = ' || l_item_onhand);
2690: gme_debug.put_line ('found l_item_available = ' || l_item_available);
2691: END IF;
2692: EXCEPTION
2693: WHEN NO_DATA_FOUND THEN

Line 2690: gme_debug.put_line ('found l_item_available = ' || l_item_available);

2686: l_item_onhand := l_qty_tbl(l_item_hash).onhand;
2687: l_item_available := l_qty_tbl(l_item_hash).available;
2688: IF g_debug <= gme_debug.g_log_statement THEN
2689: gme_debug.put_line ('found l_item_onhand = ' || l_item_onhand);
2690: gme_debug.put_line ('found l_item_available = ' || l_item_available);
2691: END IF;
2692: EXCEPTION
2693: WHEN NO_DATA_FOUND THEN
2694: IF p_tree_mode = g_tree_transaction_mode OR l_item_rec.reservable_type = 2 THEN

Line 2727: IF g_debug <= gme_debug.g_log_statement THEN

2723: ,x_sqs => l_sqs
2724: ,x_satt => l_satt
2725: ,x_satr => l_satr);
2726: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
2727: IF g_debug <= gme_debug.g_log_statement THEN
2728: gme_debug.put_line('Item level qtys');
2729: gme_debug.put_line('l_qoh = ' || l_qoh);
2730: gme_debug.put_line('l_att = ' || l_att);
2731: gme_debug.put_line('l_atr = ' || l_atr);

Line 2728: gme_debug.put_line('Item level qtys');

2724: ,x_satt => l_satt
2725: ,x_satr => l_satr);
2726: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
2727: IF g_debug <= gme_debug.g_log_statement THEN
2728: gme_debug.put_line('Item level qtys');
2729: gme_debug.put_line('l_qoh = ' || l_qoh);
2730: gme_debug.put_line('l_att = ' || l_att);
2731: gme_debug.put_line('l_atr = ' || l_atr);
2732: END IF;

Line 2729: gme_debug.put_line('l_qoh = ' || l_qoh);

2725: ,x_satr => l_satr);
2726: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
2727: IF g_debug <= gme_debug.g_log_statement THEN
2728: gme_debug.put_line('Item level qtys');
2729: gme_debug.put_line('l_qoh = ' || l_qoh);
2730: gme_debug.put_line('l_att = ' || l_att);
2731: gme_debug.put_line('l_atr = ' || l_atr);
2732: END IF;
2733: l_qty_tbl(l_item_hash).onhand := l_qoh;

Line 2730: gme_debug.put_line('l_att = ' || l_att);

2726: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
2727: IF g_debug <= gme_debug.g_log_statement THEN
2728: gme_debug.put_line('Item level qtys');
2729: gme_debug.put_line('l_qoh = ' || l_qoh);
2730: gme_debug.put_line('l_att = ' || l_att);
2731: gme_debug.put_line('l_atr = ' || l_atr);
2732: END IF;
2733: l_qty_tbl(l_item_hash).onhand := l_qoh;
2734:

Line 2731: gme_debug.put_line('l_atr = ' || l_atr);

2727: IF g_debug <= gme_debug.g_log_statement THEN
2728: gme_debug.put_line('Item level qtys');
2729: gme_debug.put_line('l_qoh = ' || l_qoh);
2730: gme_debug.put_line('l_att = ' || l_att);
2731: gme_debug.put_line('l_atr = ' || l_atr);
2732: END IF;
2733: l_qty_tbl(l_item_hash).onhand := l_qoh;
2734:
2735: -- Bug 13611486 - This backs out fix done in 8582412. INV team must provide a way of

Line 2762: IF g_debug <= gme_debug.g_log_statement THEN

2758: l_item_onhand := l_qty_tbl(l_item_hash).onhand;
2759: l_item_available := l_qty_tbl(l_item_hash).available;
2760: END;
2761: IF (l_item_hash <> l_mtl_hash) THEN
2762: IF g_debug <= gme_debug.g_log_statement THEN
2763: gme_debug.put_line('Item level and mtl level hashes are diff');
2764: END IF;
2765: BEGIN
2766: l_mtl_onhand := l_qty_tbl(l_mtl_hash).onhand;

Line 2763: gme_debug.put_line('Item level and mtl level hashes are diff');

2759: l_item_available := l_qty_tbl(l_item_hash).available;
2760: END;
2761: IF (l_item_hash <> l_mtl_hash) THEN
2762: IF g_debug <= gme_debug.g_log_statement THEN
2763: gme_debug.put_line('Item level and mtl level hashes are diff');
2764: END IF;
2765: BEGIN
2766: l_mtl_onhand := l_qty_tbl(l_mtl_hash).onhand;
2767: l_mtl_available := l_qty_tbl(l_mtl_hash).available;

Line 2768: IF g_debug <= gme_debug.g_log_statement THEN

2764: END IF;
2765: BEGIN
2766: l_mtl_onhand := l_qty_tbl(l_mtl_hash).onhand;
2767: l_mtl_available := l_qty_tbl(l_mtl_hash).available;
2768: IF g_debug <= gme_debug.g_log_statement THEN
2769: gme_debug.put_line ('found l_mtl_onhand = ' || l_mtl_onhand);
2770: gme_debug.put_line ('found l_mtl_available = ' || l_mtl_available);
2771: END IF;
2772: EXCEPTION

Line 2769: gme_debug.put_line ('found l_mtl_onhand = ' || l_mtl_onhand);

2765: BEGIN
2766: l_mtl_onhand := l_qty_tbl(l_mtl_hash).onhand;
2767: l_mtl_available := l_qty_tbl(l_mtl_hash).available;
2768: IF g_debug <= gme_debug.g_log_statement THEN
2769: gme_debug.put_line ('found l_mtl_onhand = ' || l_mtl_onhand);
2770: gme_debug.put_line ('found l_mtl_available = ' || l_mtl_available);
2771: END IF;
2772: EXCEPTION
2773: WHEN NO_DATA_FOUND THEN

Line 2770: gme_debug.put_line ('found l_mtl_available = ' || l_mtl_available);

2766: l_mtl_onhand := l_qty_tbl(l_mtl_hash).onhand;
2767: l_mtl_available := l_qty_tbl(l_mtl_hash).available;
2768: IF g_debug <= gme_debug.g_log_statement THEN
2769: gme_debug.put_line ('found l_mtl_onhand = ' || l_mtl_onhand);
2770: gme_debug.put_line ('found l_mtl_available = ' || l_mtl_available);
2771: END IF;
2772: EXCEPTION
2773: WHEN NO_DATA_FOUND THEN
2774: IF p_tree_mode = g_tree_transaction_mode OR l_item_rec.reservable_type = 2 THEN

Line 2807: IF g_debug <= gme_debug.g_log_statement THEN

2803: ,x_sqs => l_sqs
2804: ,x_satt => l_satt
2805: ,x_satr => l_satr);
2806: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
2807: IF g_debug <= gme_debug.g_log_statement THEN
2808: gme_debug.put_line('Item/Revision/Sub level qtys');
2809: gme_debug.put_line('l_qoh = ' || l_qoh);
2810: gme_debug.put_line('l_att = ' || l_att);
2811: gme_debug.put_line('l_atr = ' || l_atr);

Line 2808: gme_debug.put_line('Item/Revision/Sub level qtys');

2804: ,x_satt => l_satt
2805: ,x_satr => l_satr);
2806: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
2807: IF g_debug <= gme_debug.g_log_statement THEN
2808: gme_debug.put_line('Item/Revision/Sub level qtys');
2809: gme_debug.put_line('l_qoh = ' || l_qoh);
2810: gme_debug.put_line('l_att = ' || l_att);
2811: gme_debug.put_line('l_atr = ' || l_atr);
2812: END IF;

Line 2809: gme_debug.put_line('l_qoh = ' || l_qoh);

2805: ,x_satr => l_satr);
2806: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
2807: IF g_debug <= gme_debug.g_log_statement THEN
2808: gme_debug.put_line('Item/Revision/Sub level qtys');
2809: gme_debug.put_line('l_qoh = ' || l_qoh);
2810: gme_debug.put_line('l_att = ' || l_att);
2811: gme_debug.put_line('l_atr = ' || l_atr);
2812: END IF;
2813: l_qty_tbl(l_mtl_hash).onhand := l_qoh;

Line 2810: gme_debug.put_line('l_att = ' || l_att);

2806: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
2807: IF g_debug <= gme_debug.g_log_statement THEN
2808: gme_debug.put_line('Item/Revision/Sub level qtys');
2809: gme_debug.put_line('l_qoh = ' || l_qoh);
2810: gme_debug.put_line('l_att = ' || l_att);
2811: gme_debug.put_line('l_atr = ' || l_atr);
2812: END IF;
2813: l_qty_tbl(l_mtl_hash).onhand := l_qoh;
2814: IF (l_tree_mode = g_tree_transaction_mode) THEN

Line 2811: gme_debug.put_line('l_atr = ' || l_atr);

2807: IF g_debug <= gme_debug.g_log_statement THEN
2808: gme_debug.put_line('Item/Revision/Sub level qtys');
2809: gme_debug.put_line('l_qoh = ' || l_qoh);
2810: gme_debug.put_line('l_att = ' || l_att);
2811: gme_debug.put_line('l_atr = ' || l_atr);
2812: END IF;
2813: l_qty_tbl(l_mtl_hash).onhand := l_qoh;
2814: IF (l_tree_mode = g_tree_transaction_mode) THEN
2815: l_qty_tbl(l_mtl_hash).available := l_att;

Line 2839: IF g_debug <= gme_debug.g_log_statement THEN

2835: l_mtl_onhand := l_qty_tbl(l_mtl_hash).onhand;
2836: l_mtl_available := l_qty_tbl(l_mtl_hash).available;
2837: END;
2838: ELSE
2839: IF g_debug <= gme_debug.g_log_statement THEN
2840: gme_debug.put_line('Item level and mtl level hashes are same');
2841: gme_debug.put_line('Invoke mode is '||p_invoke_mode);
2842: gme_debug.put_line('onhand is '||l_item_onhand);
2843: gme_debug.put_line('avail is '||l_item_available);

Line 2840: gme_debug.put_line('Item level and mtl level hashes are same');

2836: l_mtl_available := l_qty_tbl(l_mtl_hash).available;
2837: END;
2838: ELSE
2839: IF g_debug <= gme_debug.g_log_statement THEN
2840: gme_debug.put_line('Item level and mtl level hashes are same');
2841: gme_debug.put_line('Invoke mode is '||p_invoke_mode);
2842: gme_debug.put_line('onhand is '||l_item_onhand);
2843: gme_debug.put_line('avail is '||l_item_available);
2844: END IF;

Line 2841: gme_debug.put_line('Invoke mode is '||p_invoke_mode);

2837: END;
2838: ELSE
2839: IF g_debug <= gme_debug.g_log_statement THEN
2840: gme_debug.put_line('Item level and mtl level hashes are same');
2841: gme_debug.put_line('Invoke mode is '||p_invoke_mode);
2842: gme_debug.put_line('onhand is '||l_item_onhand);
2843: gme_debug.put_line('avail is '||l_item_available);
2844: END IF;
2845: l_mtl_onhand := l_item_onhand;

Line 2842: gme_debug.put_line('onhand is '||l_item_onhand);

2838: ELSE
2839: IF g_debug <= gme_debug.g_log_statement THEN
2840: gme_debug.put_line('Item level and mtl level hashes are same');
2841: gme_debug.put_line('Invoke mode is '||p_invoke_mode);
2842: gme_debug.put_line('onhand is '||l_item_onhand);
2843: gme_debug.put_line('avail is '||l_item_available);
2844: END IF;
2845: l_mtl_onhand := l_item_onhand;
2846: l_mtl_available := l_item_available;

Line 2843: gme_debug.put_line('avail is '||l_item_available);

2839: IF g_debug <= gme_debug.g_log_statement THEN
2840: gme_debug.put_line('Item level and mtl level hashes are same');
2841: gme_debug.put_line('Invoke mode is '||p_invoke_mode);
2842: gme_debug.put_line('onhand is '||l_item_onhand);
2843: gme_debug.put_line('avail is '||l_item_available);
2844: END IF;
2845: l_mtl_onhand := l_item_onhand;
2846: l_mtl_available := l_item_available;
2847: END IF; /* IF (l_item_hash <> l_mtl_hash) THEN */

Line 2892: IF g_debug <= gme_debug.g_log_statement THEN

2888: AND h.move_order_type NOT IN
2889: (gme_common_pvt.g_invis_move_order_type
2890: ,inv_globals.g_move_order_put_away);
2891:
2892: IF g_debug <= gme_debug.g_log_statement THEN
2893: gme_debug.put_line('Additional Material Allocated to Move Order:'||l_allocated_qty);
2894: END IF;
2895:
2896: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2893: gme_debug.put_line('Additional Material Allocated to Move Order:'||l_allocated_qty);

2889: (gme_common_pvt.g_invis_move_order_type
2890: ,inv_globals.g_move_order_put_away);
2891:
2892: IF g_debug <= gme_debug.g_log_statement THEN
2893: gme_debug.put_line('Additional Material Allocated to Move Order:'||l_allocated_qty);
2894: END IF;
2895:
2896: EXCEPTION WHEN NO_DATA_FOUND THEN
2897: l_allocated_qty := 0;

Line 2900: IF g_debug <= gme_debug.g_log_statement THEN

2896: EXCEPTION WHEN NO_DATA_FOUND THEN
2897: l_allocated_qty := 0;
2898: END;
2899: l_mtl_available := l_mtl_available - nvl(l_allocated_qty,0);
2900: IF g_debug <= gme_debug.g_log_statement THEN
2901: gme_debug.put_line('Material Available before deducting additional Move Order Allocation:'||(l_mtl_available + nvl(l_allocated_qty,0)));
2902: gme_debug.put_line('Material Available after deducting additional Move Order Allocation:'||l_mtl_available );
2903: END IF;
2904:

Line 2901: gme_debug.put_line('Material Available before deducting additional Move Order Allocation:'||(l_mtl_available + nvl(l_allocated_qty,0)));

2897: l_allocated_qty := 0;
2898: END;
2899: l_mtl_available := l_mtl_available - nvl(l_allocated_qty,0);
2900: IF g_debug <= gme_debug.g_log_statement THEN
2901: gme_debug.put_line('Material Available before deducting additional Move Order Allocation:'||(l_mtl_available + nvl(l_allocated_qty,0)));
2902: gme_debug.put_line('Material Available after deducting additional Move Order Allocation:'||l_mtl_available );
2903: END IF;
2904:
2905: END IF;

Line 2902: gme_debug.put_line('Material Available after deducting additional Move Order Allocation:'||l_mtl_available );

2898: END;
2899: l_mtl_available := l_mtl_available - nvl(l_allocated_qty,0);
2900: IF g_debug <= gme_debug.g_log_statement THEN
2901: gme_debug.put_line('Material Available before deducting additional Move Order Allocation:'||(l_mtl_available + nvl(l_allocated_qty,0)));
2902: gme_debug.put_line('Material Available after deducting additional Move Order Allocation:'||l_mtl_available );
2903: END IF;
2904:
2905: END IF;
2906:

Line 2930: IF g_debug <= gme_debug.g_log_procedure THEN

2926: END IF;
2927: END IF; /* IF (l_open_qty_prim > 0) THEN */
2928: END LOOP;
2929: CLOSE cur_get_materials;
2930: IF g_debug <= gme_debug.g_log_procedure THEN
2931: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2932: END IF;
2933: EXCEPTION
2934: WHEN setup_failure THEN

Line 2931: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

2927: END IF; /* IF (l_open_qty_prim > 0) THEN */
2928: END LOOP;
2929: CLOSE cur_get_materials;
2930: IF g_debug <= gme_debug.g_log_procedure THEN
2931: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2932: END IF;
2933: EXCEPTION
2934: WHEN setup_failure THEN
2935: x_return_status := fnd_api.g_ret_sts_error;

Line 2957: IF g_debug <= gme_debug.g_log_unexpected THEN

2953: IF (cur_get_materials%ISOPEN) THEN
2954: CLOSE cur_get_materials;
2955: END IF;
2956: WHEN OTHERS THEN
2957: IF g_debug <= gme_debug.g_log_unexpected THEN
2958: gme_debug.put_line ( 'When others exception in '
2959: || g_pkg_name
2960: || '.'
2961: || l_api_name

Line 2958: gme_debug.put_line ( 'When others exception in '

2954: CLOSE cur_get_materials;
2955: END IF;
2956: WHEN OTHERS THEN
2957: IF g_debug <= gme_debug.g_log_unexpected THEN
2958: gme_debug.put_line ( 'When others exception in '
2959: || g_pkg_name
2960: || '.'
2961: || l_api_name
2962: || ' Error is '

Line 3001: IF g_debug <= gme_debug.g_log_procedure THEN

2997: get_reserved_qty_err EXCEPTION;
2998: get_reservations_err EXCEPTION;
2999: get_pending_qty_err EXCEPTION;
3000: BEGIN
3001: IF g_debug <= gme_debug.g_log_procedure THEN
3002: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3003: || l_api_name);
3004: gme_debug.put_line ('Being called by ' || p_called_by);
3005: END IF;

Line 3002: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

2998: get_reservations_err EXCEPTION;
2999: get_pending_qty_err EXCEPTION;
3000: BEGIN
3001: IF g_debug <= gme_debug.g_log_procedure THEN
3002: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3003: || l_api_name);
3004: gme_debug.put_line ('Being called by ' || p_called_by);
3005: END IF;
3006:

Line 3004: gme_debug.put_line ('Being called by ' || p_called_by);

3000: BEGIN
3001: IF g_debug <= gme_debug.g_log_procedure THEN
3002: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3003: || l_api_name);
3004: gme_debug.put_line ('Being called by ' || p_called_by);
3005: END IF;
3006:
3007: x_return_status := fnd_api.g_ret_sts_success;
3008:

Line 3025: IF g_debug <= gme_debug.g_log_statement THEN

3021: x_open_qty :=
3022: NVL (p_mtl_dtl_rec.wip_plan_qty, p_mtl_dtl_rec.plan_qty)
3023: - (p_mtl_dtl_rec.actual_qty + NVL (l_reserved_qty, 0) );
3024:
3025: IF g_debug <= gme_debug.g_log_statement THEN
3026: gme_debug.put_line ( g_pkg_name
3027: || '.'
3028: || l_api_name
3029: || ' Calculated open qty for shortages is '

Line 3026: gme_debug.put_line ( g_pkg_name

3022: NVL (p_mtl_dtl_rec.wip_plan_qty, p_mtl_dtl_rec.plan_qty)
3023: - (p_mtl_dtl_rec.actual_qty + NVL (l_reserved_qty, 0) );
3024:
3025: IF g_debug <= gme_debug.g_log_statement THEN
3026: gme_debug.put_line ( g_pkg_name
3027: || '.'
3028: || l_api_name
3029: || ' Calculated open qty for shortages is '
3030: || x_open_qty);

Line 3054: IF g_debug <= gme_debug.g_log_statement THEN

3050: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3051: RAISE get_pending_qty_err;
3052: END IF;
3053:
3054: IF g_debug <= gme_debug.g_log_statement THEN
3055: gme_debug.put_line ( g_pkg_name
3056: || '.'
3057: || l_api_name
3058: || ' p_mtl_dtl_rec.plan_qty = '

Line 3055: gme_debug.put_line ( g_pkg_name

3051: RAISE get_pending_qty_err;
3052: END IF;
3053:
3054: IF g_debug <= gme_debug.g_log_statement THEN
3055: gme_debug.put_line ( g_pkg_name
3056: || '.'
3057: || l_api_name
3058: || ' p_mtl_dtl_rec.plan_qty = '
3059: || p_mtl_dtl_rec.plan_qty);

Line 3060: gme_debug.put_line ( g_pkg_name

3056: || '.'
3057: || l_api_name
3058: || ' p_mtl_dtl_rec.plan_qty = '
3059: || p_mtl_dtl_rec.plan_qty);
3060: gme_debug.put_line ( g_pkg_name
3061: || '.'
3062: || l_api_name
3063: || ' p_mtl_dtl_rec.wip_plan_qty = '
3064: || p_mtl_dtl_rec.wip_plan_qty);

Line 3065: gme_debug.put_line ( g_pkg_name

3061: || '.'
3062: || l_api_name
3063: || ' p_mtl_dtl_rec.wip_plan_qty = '
3064: || p_mtl_dtl_rec.wip_plan_qty);
3065: gme_debug.put_line ( g_pkg_name
3066: || '.'
3067: || l_api_name
3068: || ' p_mtl_dtl_rec.actual_qty = '
3069: || p_mtl_dtl_rec.actual_qty);

Line 3070: gme_debug.put_line ( g_pkg_name

3066: || '.'
3067: || l_api_name
3068: || ' p_mtl_dtl_rec.actual_qty = '
3069: || p_mtl_dtl_rec.actual_qty);
3070: gme_debug.put_line ( g_pkg_name
3071: || '.'
3072: || l_api_name
3073: || ' l_reserved_qty = '
3074: || NVL (l_reserved_qty, 0) );

Line 3075: gme_debug.put_line ( g_pkg_name

3071: || '.'
3072: || l_api_name
3073: || ' l_reserved_qty = '
3074: || NVL (l_reserved_qty, 0) );
3075: gme_debug.put_line ( g_pkg_name
3076: || '.'
3077: || l_api_name
3078: || ' p_mtl_dtl_rec.backordered_qty = '
3079: || NVL (p_mtl_dtl_rec.backordered_qty, 0) );

Line 3080: gme_debug.put_line ( g_pkg_name

3076: || '.'
3077: || l_api_name
3078: || ' p_mtl_dtl_rec.backordered_qty = '
3079: || NVL (p_mtl_dtl_rec.backordered_qty, 0) );
3080: gme_debug.put_line ( g_pkg_name
3081: || '.'
3082: || l_api_name
3083: || ' l_mo_line_qty = '
3084: || NVL (l_mo_line_qty, 0) );

Line 3096: IF g_debug <= gme_debug.g_log_statement THEN

3092: - ( p_mtl_dtl_rec.actual_qty
3093: + NVL (l_reserved_qty, 0)
3094: + NVL (l_mo_line_qty, 0) );
3095:
3096: IF g_debug <= gme_debug.g_log_statement THEN
3097: gme_debug.put_line ( g_pkg_name
3098: || '.'
3099: || l_api_name
3100: || ' Calculated open qty for picking is '

Line 3097: gme_debug.put_line ( g_pkg_name

3093: + NVL (l_reserved_qty, 0)
3094: + NVL (l_mo_line_qty, 0) );
3095:
3096: IF g_debug <= gme_debug.g_log_statement THEN
3097: gme_debug.put_line ( g_pkg_name
3098: || '.'
3099: || l_api_name
3100: || ' Calculated open qty for picking is '
3101: || x_open_qty);

Line 3149: IF g_debug <= gme_debug.g_log_statement THEN

3145:
3146: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3147: RAISE get_reserved_qty_err;
3148: END IF;
3149: IF g_debug <= gme_debug.g_log_statement THEN
3150: gme_debug.put_line ( g_pkg_name
3151: || '.'
3152: || l_api_name
3153: || ' get_reservation_dtl_qty returns qty of '

Line 3150: gme_debug.put_line ( g_pkg_name

3146: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3147: RAISE get_reserved_qty_err;
3148: END IF;
3149: IF g_debug <= gme_debug.g_log_statement THEN
3150: gme_debug.put_line ( g_pkg_name
3151: || '.'
3152: || l_api_name
3153: || ' get_reservation_dtl_qty returns qty of '
3154: || l_temp_qty);

Line 3158: IF g_debug <= gme_debug.g_log_statement THEN

3154: || l_temp_qty);
3155: END IF;
3156:
3157: l_reserved_qty := NVL (l_reserved_qty, 0) + NVL (l_temp_qty, 0);
3158: IF g_debug <= gme_debug.g_log_statement THEN
3159: gme_debug.put_line ( g_pkg_name
3160: || '.'
3161: || l_api_name
3162: || ' so total reserved qty computes to '

Line 3159: gme_debug.put_line ( g_pkg_name

3155: END IF;
3156:
3157: l_reserved_qty := NVL (l_reserved_qty, 0) + NVL (l_temp_qty, 0);
3158: IF g_debug <= gme_debug.g_log_statement THEN
3159: gme_debug.put_line ( g_pkg_name
3160: || '.'
3161: || l_api_name
3162: || ' so total reserved qty computes to '
3163: || l_reserved_qty);

Line 3169: IF g_debug <= gme_debug.g_log_statement THEN

3165:
3166:
3167: -- END IF;
3168: END LOOP;
3169: IF g_debug <= gme_debug.g_log_statement THEN
3170: gme_debug.put_line ( g_pkg_name
3171: || '.'
3172: || l_api_name
3173: || ' wip_plan_qty => '

Line 3170: gme_debug.put_line ( g_pkg_name

3166:
3167: -- END IF;
3168: END LOOP;
3169: IF g_debug <= gme_debug.g_log_statement THEN
3170: gme_debug.put_line ( g_pkg_name
3171: || '.'
3172: || l_api_name
3173: || ' wip_plan_qty => '
3174: || p_mtl_dtl_rec.wip_plan_qty);

Line 3175: gme_debug.put_line ( g_pkg_name

3171: || '.'
3172: || l_api_name
3173: || ' wip_plan_qty => '
3174: || p_mtl_dtl_rec.wip_plan_qty);
3175: gme_debug.put_line ( g_pkg_name
3176: || '.'
3177: || l_api_name
3178: || ' plan_qty => '
3179: || p_mtl_dtl_rec.plan_qty);

Line 3180: gme_debug.put_line ( g_pkg_name

3176: || '.'
3177: || l_api_name
3178: || ' plan_qty => '
3179: || p_mtl_dtl_rec.plan_qty);
3180: gme_debug.put_line ( g_pkg_name
3181: || '.'
3182: || l_api_name
3183: || ' actual_qty => '
3184: || p_mtl_dtl_rec.actual_qty);

Line 3185: gme_debug.put_line ( g_pkg_name

3181: || '.'
3182: || l_api_name
3183: || ' actual_qty => '
3184: || p_mtl_dtl_rec.actual_qty);
3185: gme_debug.put_line ( g_pkg_name
3186: || '.'
3187: || l_api_name
3188: || ' reserved_qty => '
3189: || l_reserved_qty);

Line 3196: IF g_debug <= gme_debug.g_log_statement THEN

3192: x_open_qty :=
3193: NVL (p_mtl_dtl_rec.wip_plan_qty, p_mtl_dtl_rec.plan_qty)
3194: - (p_mtl_dtl_rec.actual_qty + l_reserved_qty);
3195:
3196: IF g_debug <= gme_debug.g_log_statement THEN
3197: gme_debug.put_line
3198: ( g_pkg_name
3199: || '.'
3200: || l_api_name

Line 3197: gme_debug.put_line

3193: NVL (p_mtl_dtl_rec.wip_plan_qty, p_mtl_dtl_rec.plan_qty)
3194: - (p_mtl_dtl_rec.actual_qty + l_reserved_qty);
3195:
3196: IF g_debug <= gme_debug.g_log_statement THEN
3197: gme_debug.put_line
3198: ( g_pkg_name
3199: || '.'
3200: || l_api_name
3201: || ' Calculated open qty for reservations is '

Line 3242: IF g_debug <= gme_debug.g_log_statement THEN

3238:
3239: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3240: RAISE get_reserved_qty_err;
3241: END IF;
3242: IF g_debug <= gme_debug.g_log_statement THEN
3243: gme_debug.put_line ( g_pkg_name
3244: || '.'
3245: || l_api_name
3246: || ' get_reservation_dtl_qty returns qty of '

Line 3243: gme_debug.put_line ( g_pkg_name

3239: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3240: RAISE get_reserved_qty_err;
3241: END IF;
3242: IF g_debug <= gme_debug.g_log_statement THEN
3243: gme_debug.put_line ( g_pkg_name
3244: || '.'
3245: || l_api_name
3246: || ' get_reservation_dtl_qty returns qty of '
3247: || l_temp_qty);

Line 3251: IF g_debug <= gme_debug.g_log_statement THEN

3247: || l_temp_qty);
3248: END IF;
3249:
3250: l_reserved_qty := NVL (l_reserved_qty, 0) + NVL (l_temp_qty, 0);
3251: IF g_debug <= gme_debug.g_log_statement THEN
3252: gme_debug.put_line ( g_pkg_name
3253: || '.'
3254: || l_api_name
3255: || ' so total reserved qty computes to '

Line 3252: gme_debug.put_line ( g_pkg_name

3248: END IF;
3249:
3250: l_reserved_qty := NVL (l_reserved_qty, 0) + NVL (l_temp_qty, 0);
3251: IF g_debug <= gme_debug.g_log_statement THEN
3252: gme_debug.put_line ( g_pkg_name
3253: || '.'
3254: || l_api_name
3255: || ' so total reserved qty computes to '
3256: || l_reserved_qty);

Line 3260: IF g_debug <= gme_debug.g_log_statement THEN

3256: || l_reserved_qty);
3257: END IF;
3258:
3259: END LOOP;
3260: IF g_debug <= gme_debug.g_log_statement THEN
3261: gme_debug.put_line ( g_pkg_name
3262: || '.'
3263: || l_api_name
3264: || ' wip_plan_qty => '

Line 3261: gme_debug.put_line ( g_pkg_name

3257: END IF;
3258:
3259: END LOOP;
3260: IF g_debug <= gme_debug.g_log_statement THEN
3261: gme_debug.put_line ( g_pkg_name
3262: || '.'
3263: || l_api_name
3264: || ' wip_plan_qty => '
3265: || p_mtl_dtl_rec.wip_plan_qty);

Line 3266: gme_debug.put_line ( g_pkg_name

3262: || '.'
3263: || l_api_name
3264: || ' wip_plan_qty => '
3265: || p_mtl_dtl_rec.wip_plan_qty);
3266: gme_debug.put_line ( g_pkg_name
3267: || '.'
3268: || l_api_name
3269: || ' plan_qty => '
3270: || p_mtl_dtl_rec.plan_qty);

Line 3271: gme_debug.put_line ( g_pkg_name

3267: || '.'
3268: || l_api_name
3269: || ' plan_qty => '
3270: || p_mtl_dtl_rec.plan_qty);
3271: gme_debug.put_line ( g_pkg_name
3272: || '.'
3273: || l_api_name
3274: || ' actual_qty => '
3275: || p_mtl_dtl_rec.actual_qty);

Line 3276: gme_debug.put_line ( g_pkg_name

3272: || '.'
3273: || l_api_name
3274: || ' actual_qty => '
3275: || p_mtl_dtl_rec.actual_qty);
3276: gme_debug.put_line ( g_pkg_name
3277: || '.'
3278: || l_api_name
3279: || ' reserved_qty => '
3280: || l_reserved_qty);

Line 3287: IF g_debug <= gme_debug.g_log_statement THEN

3283: x_open_qty :=
3284: NVL (p_mtl_dtl_rec.wip_plan_qty, p_mtl_dtl_rec.plan_qty)
3285: - (p_mtl_dtl_rec.actual_qty + l_reserved_qty);
3286:
3287: IF g_debug <= gme_debug.g_log_statement THEN
3288: gme_debug.put_line
3289: ( g_pkg_name
3290: || '.'
3291: || l_api_name

Line 3288: gme_debug.put_line

3284: NVL (p_mtl_dtl_rec.wip_plan_qty, p_mtl_dtl_rec.plan_qty)
3285: - (p_mtl_dtl_rec.actual_qty + l_reserved_qty);
3286:
3287: IF g_debug <= gme_debug.g_log_statement THEN
3288: gme_debug.put_line
3289: ( g_pkg_name
3290: || '.'
3291: || l_api_name
3292: || ' Calculated open qty for reservations is '

Line 3300: IF g_debug <= gme_debug.g_log_procedure THEN

3296: ELSE
3297: x_open_qty := 0;
3298: END IF;
3299:
3300: IF g_debug <= gme_debug.g_log_procedure THEN
3301: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3302: END IF;
3303: EXCEPTION
3304: WHEN get_reserved_qty_err OR get_pending_qty_err THEN

Line 3301: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

3297: x_open_qty := 0;
3298: END IF;
3299:
3300: IF g_debug <= gme_debug.g_log_procedure THEN
3301: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3302: END IF;
3303: EXCEPTION
3304: WHEN get_reserved_qty_err OR get_pending_qty_err THEN
3305: x_return_status := l_return_status;

Line 3307: IF g_debug <= gme_debug.g_log_unexpected THEN

3303: EXCEPTION
3304: WHEN get_reserved_qty_err OR get_pending_qty_err THEN
3305: x_return_status := l_return_status;
3306: WHEN OTHERS THEN
3307: IF g_debug <= gme_debug.g_log_unexpected THEN
3308: gme_debug.put_line ( 'When others exception in '
3309: || g_pkg_name
3310: || '.'
3311: || l_api_name

Line 3308: gme_debug.put_line ( 'When others exception in '

3304: WHEN get_reserved_qty_err OR get_pending_qty_err THEN
3305: x_return_status := l_return_status;
3306: WHEN OTHERS THEN
3307: IF g_debug <= gme_debug.g_log_unexpected THEN
3308: gme_debug.put_line ( 'When others exception in '
3309: || g_pkg_name
3310: || '.'
3311: || l_api_name
3312: || ' Error is '

Line 3325: IF g_debug <= gme_debug.g_log_procedure THEN

3321: RETURN BOOLEAN
3322: IS
3323: l_api_name CONSTANT VARCHAR2 (30) := 'insert_exceptions';
3324: BEGIN
3325: IF g_debug <= gme_debug.g_log_procedure THEN
3326: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3327: || l_api_name);
3328: END IF;
3329:

Line 3326: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

3322: IS
3323: l_api_name CONSTANT VARCHAR2 (30) := 'insert_exceptions';
3324: BEGIN
3325: IF g_debug <= gme_debug.g_log_procedure THEN
3326: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3327: || l_api_name);
3328: END IF;
3329:
3330: -- Bug 9666304 - NVL on att variable.

Line 3347: IF g_debug <= gme_debug.g_log_procedure THEN

3343: ,p_exception_rec.atr, p_exception_rec.material_detail_id
3344: ,p_exception_rec.transacted_qty
3345: ,p_exception_rec.exception_qty, p_exception_rec.batch_id);
3346:
3347: IF g_debug <= gme_debug.g_log_procedure THEN
3348: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3349: END IF;
3350:
3351: RETURN TRUE;

Line 3348: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

3344: ,p_exception_rec.transacted_qty
3345: ,p_exception_rec.exception_qty, p_exception_rec.batch_id);
3346:
3347: IF g_debug <= gme_debug.g_log_procedure THEN
3348: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3349: END IF;
3350:
3351: RETURN TRUE;
3352: EXCEPTION

Line 3354: IF g_debug <= gme_debug.g_log_unexpected THEN

3350:
3351: RETURN TRUE;
3352: EXCEPTION
3353: WHEN OTHERS THEN
3354: IF g_debug <= gme_debug.g_log_unexpected THEN
3355: gme_debug.put_line ( 'When others exception in '
3356: || g_pkg_name
3357: || '.'
3358: || l_api_name

Line 3355: gme_debug.put_line ( 'When others exception in '

3351: RETURN TRUE;
3352: EXCEPTION
3353: WHEN OTHERS THEN
3354: IF g_debug <= gme_debug.g_log_unexpected THEN
3355: gme_debug.put_line ( 'When others exception in '
3356: || g_pkg_name
3357: || '.'
3358: || l_api_name
3359: || ' Error is '

Line 3373: IF g_debug <= gme_debug.g_log_procedure THEN

3369: RETURN BOOLEAN
3370: IS
3371: l_api_name CONSTANT VARCHAR2 (30) := 'populate_temp_from_struct';
3372: BEGIN
3373: IF g_debug <= gme_debug.g_log_procedure THEN
3374: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3375: || l_api_name);
3376: END IF;
3377:

Line 3374: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

3370: IS
3371: l_api_name CONSTANT VARCHAR2 (30) := 'populate_temp_from_struct';
3372: BEGIN
3373: IF g_debug <= gme_debug.g_log_procedure THEN
3374: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3375: || l_api_name);
3376: END IF;
3377:
3378: FOR i IN 1 .. p_exception_tbl.COUNT LOOP

Line 3384: IF g_debug <= gme_debug.g_log_procedure THEN

3380: RETURN FALSE;
3381: END IF;
3382: END LOOP;
3383:
3384: IF g_debug <= gme_debug.g_log_procedure THEN
3385: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3386: END IF;
3387:
3388: RETURN TRUE;

Line 3385: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

3381: END IF;
3382: END LOOP;
3383:
3384: IF g_debug <= gme_debug.g_log_procedure THEN
3385: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3386: END IF;
3387:
3388: RETURN TRUE;
3389: EXCEPTION

Line 3391: IF g_debug <= gme_debug.g_log_unexpected THEN

3387:
3388: RETURN TRUE;
3389: EXCEPTION
3390: WHEN OTHERS THEN
3391: IF g_debug <= gme_debug.g_log_unexpected THEN
3392: gme_debug.put_line ( 'When others exception in '
3393: || g_pkg_name
3394: || '.'
3395: || l_api_name

Line 3392: gme_debug.put_line ( 'When others exception in '

3388: RETURN TRUE;
3389: EXCEPTION
3390: WHEN OTHERS THEN
3391: IF g_debug <= gme_debug.g_log_unexpected THEN
3392: gme_debug.put_line ( 'When others exception in '
3393: || g_pkg_name
3394: || '.'
3395: || l_api_name
3396: || ' Error is '

Line 3412: IF g_debug <= gme_debug.g_log_procedure THEN

3408: l_assoc_count NUMBER;
3409: l_is_assoc BOOLEAN;
3410: l_api_name CONSTANT VARCHAR2 (30) := 'is_material_assoc_to_step';
3411: BEGIN
3412: IF g_debug <= gme_debug.g_log_procedure THEN
3413: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3414: || l_api_name);
3415: END IF;
3416:

Line 3413: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

3409: l_is_assoc BOOLEAN;
3410: l_api_name CONSTANT VARCHAR2 (30) := 'is_material_assoc_to_step';
3411: BEGIN
3412: IF g_debug <= gme_debug.g_log_procedure THEN
3413: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3414: || l_api_name);
3415: END IF;
3416:
3417: SELECT COUNT (1)

Line 3433: IF g_debug <= gme_debug.g_log_unexpected THEN

3429:
3430: RETURN l_is_assoc;
3431: EXCEPTION
3432: WHEN OTHERS THEN
3433: IF g_debug <= gme_debug.g_log_unexpected THEN
3434: gme_debug.put_line ( 'When others exception in '
3435: || g_pkg_name
3436: || '.'
3437: || l_api_name

Line 3434: gme_debug.put_line ( 'When others exception in '

3430: RETURN l_is_assoc;
3431: EXCEPTION
3432: WHEN OTHERS THEN
3433: IF g_debug <= gme_debug.g_log_unexpected THEN
3434: gme_debug.put_line ( 'When others exception in '
3435: || g_pkg_name
3436: || '.'
3437: || l_api_name
3438: || ' Error is '

Line 3464: IF g_debug <= gme_debug.g_log_procedure THEN

3460: WHERE a.material_detail_id = v_material_detail_id
3461: AND a.batchstep_id = s.batchstep_id
3462: AND a.batch_id = s.batch_id;
3463: BEGIN
3464: IF g_debug <= gme_debug.g_log_procedure THEN
3465: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3466: || l_api_name);
3467: END IF;
3468:

Line 3465: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

3461: AND a.batchstep_id = s.batchstep_id
3462: AND a.batch_id = s.batch_id;
3463: BEGIN
3464: IF g_debug <= gme_debug.g_log_procedure THEN
3465: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3466: || l_api_name);
3467: END IF;
3468:
3469: OPEN get_assoc_step (p_material_detail_id);

Line 3485: IF g_debug <= gme_debug.g_log_unexpected THEN

3481:
3482: RETURN TRUE;
3483: EXCEPTION
3484: WHEN no_assoc_step THEN
3485: IF g_debug <= gme_debug.g_log_unexpected THEN
3486: gme_debug.put_line ( 'no associate steps '
3487: || g_pkg_name
3488: || '.'
3489: || l_api_name

Line 3486: gme_debug.put_line ( 'no associate steps '

3482: RETURN TRUE;
3483: EXCEPTION
3484: WHEN no_assoc_step THEN
3485: IF g_debug <= gme_debug.g_log_unexpected THEN
3486: gme_debug.put_line ( 'no associate steps '
3487: || g_pkg_name
3488: || '.'
3489: || l_api_name
3490: || ' Error is '

Line 3497: IF g_debug <= gme_debug.g_log_unexpected THEN

3493: --FPBug#4585491 commented out the following line
3494: --fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3495: RETURN FALSE;
3496: WHEN OTHERS THEN
3497: IF g_debug <= gme_debug.g_log_unexpected THEN
3498: gme_debug.put_line ( 'When others exception in '
3499: || g_pkg_name
3500: || '.'
3501: || l_api_name

Line 3498: gme_debug.put_line ( 'When others exception in '

3494: --fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3495: RETURN FALSE;
3496: WHEN OTHERS THEN
3497: IF g_debug <= gme_debug.g_log_unexpected THEN
3498: gme_debug.put_line ( 'When others exception in '
3499: || g_pkg_name
3500: || '.'
3501: || l_api_name
3502: || ' Error is '

Line 3526: IF g_debug <= gme_debug.g_log_procedure THEN

3522:
3523: l_batch_header_rec gme_batch_header%ROWTYPE;
3524: l_api_name VARCHAR2 (30) := 'GET_BATCH_HEADER';
3525: BEGIN
3526: IF g_debug <= gme_debug.g_log_procedure THEN
3527: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3528: || l_api_name);
3529: END IF;
3530:

Line 3527: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

3523: l_batch_header_rec gme_batch_header%ROWTYPE;
3524: l_api_name VARCHAR2 (30) := 'GET_BATCH_HEADER';
3525: BEGIN
3526: IF g_debug <= gme_debug.g_log_procedure THEN
3527: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3528: || l_api_name);
3529: END IF;
3530:
3531: l_batch_header_rec := p_batch_header_rec;

Line 3576: IF g_debug <= gme_debug.g_log_error THEN

3572:
3573: RETURN TRUE;
3574: EXCEPTION
3575: WHEN fnd_api.g_exc_error THEN
3576: IF g_debug <= gme_debug.g_log_error THEN
3577: gme_debug.put_line ( 'Expected error '
3578: || g_pkg_name
3579: || '.'
3580: || l_api_name);

Line 3577: gme_debug.put_line ( 'Expected error '

3573: RETURN TRUE;
3574: EXCEPTION
3575: WHEN fnd_api.g_exc_error THEN
3576: IF g_debug <= gme_debug.g_log_error THEN
3577: gme_debug.put_line ( 'Expected error '
3578: || g_pkg_name
3579: || '.'
3580: || l_api_name);
3581: END IF;

Line 3585: IF g_debug <= gme_debug.g_log_unexpected THEN

3581: END IF;
3582:
3583: RETURN FALSE;
3584: WHEN OTHERS THEN
3585: IF g_debug <= gme_debug.g_log_unexpected THEN
3586: gme_debug.put_line ( 'When others exception in '
3587: || g_pkg_name
3588: || '.'
3589: || l_api_name

Line 3586: gme_debug.put_line ( 'When others exception in '

3582:
3583: RETURN FALSE;
3584: WHEN OTHERS THEN
3585: IF g_debug <= gme_debug.g_log_unexpected THEN
3586: gme_debug.put_line ( 'When others exception in '
3587: || g_pkg_name
3588: || '.'
3589: || l_api_name
3590: || ' Error is '

Line 3613: IF g_debug <= gme_debug.g_log_procedure THEN

3609: l_batch_step_rec gme_batch_steps%ROWTYPE;
3610: l_api_name VARCHAR2 (30) := 'GET_BATCH_STEP';
3611:
3612: BEGIN
3613: IF g_debug <= gme_debug.g_log_procedure THEN
3614: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3615: || l_api_name);
3616: END IF;
3617: l_batch_step_rec := p_batch_step_rec;

Line 3614: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

3610: l_api_name VARCHAR2 (30) := 'GET_BATCH_STEP';
3611:
3612: BEGIN
3613: IF g_debug <= gme_debug.g_log_procedure THEN
3614: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3615: || l_api_name);
3616: END IF;
3617: l_batch_step_rec := p_batch_step_rec;
3618: IF p_batch_step_rec.batchstep_id IS NULL THEN

Line 3649: IF g_debug <= gme_debug.g_log_error THEN

3645: x_batch_step_rec := l_batch_step_rec;
3646: RETURN TRUE;
3647: EXCEPTION
3648: WHEN fnd_api.g_exc_error THEN
3649: IF g_debug <= gme_debug.g_log_error THEN
3650: gme_debug.put_line ( 'Expected error '
3651: || g_pkg_name
3652: || '.'
3653: || l_api_name);

Line 3650: gme_debug.put_line ( 'Expected error '

3646: RETURN TRUE;
3647: EXCEPTION
3648: WHEN fnd_api.g_exc_error THEN
3649: IF g_debug <= gme_debug.g_log_error THEN
3650: gme_debug.put_line ( 'Expected error '
3651: || g_pkg_name
3652: || '.'
3653: || l_api_name);
3654: END IF;

Line 3658: IF g_debug <= gme_debug.g_log_unexpected THEN

3654: END IF;
3655:
3656: RETURN FALSE;
3657: WHEN OTHERS THEN
3658: IF g_debug <= gme_debug.g_log_unexpected THEN
3659: gme_debug.put_line ( 'When others exception in '
3660: || g_pkg_name
3661: || '.'
3662: || l_api_name

Line 3659: gme_debug.put_line ( 'When others exception in '

3655:
3656: RETURN FALSE;
3657: WHEN OTHERS THEN
3658: IF g_debug <= gme_debug.g_log_unexpected THEN
3659: gme_debug.put_line ( 'When others exception in '
3660: || g_pkg_name
3661: || '.'
3662: || l_api_name
3663: || ' Error is '

Line 3680: IF g_debug <= gme_debug.g_log_procedure THEN

3676: IS
3677: l_ins_history gme_batch_history%ROWTYPE;
3678: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_HISTORY';
3679: BEGIN
3680: IF g_debug <= gme_debug.g_log_procedure THEN
3681: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3682: || l_api_name);
3683: END IF;
3684:

Line 3681: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

3677: l_ins_history gme_batch_history%ROWTYPE;
3678: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_HISTORY';
3679: BEGIN
3680: IF g_debug <= gme_debug.g_log_procedure THEN
3681: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3682: || l_api_name);
3683: END IF;
3684:
3685: l_ins_history.batch_id := p_batch_header_rec.batch_id;

Line 3698: IF g_debug <= gme_debug.g_log_unexpected THEN

3694: RETURN TRUE;
3695: END IF;
3696: EXCEPTION
3697: WHEN OTHERS THEN
3698: IF g_debug <= gme_debug.g_log_unexpected THEN
3699: gme_debug.put_line ( 'When others exception in '
3700: || g_pkg_name
3701: || '.'
3702: || l_api_name

Line 3699: gme_debug.put_line ( 'When others exception in '

3695: END IF;
3696: EXCEPTION
3697: WHEN OTHERS THEN
3698: IF g_debug <= gme_debug.g_log_unexpected THEN
3699: gme_debug.put_line ( 'When others exception in '
3700: || g_pkg_name
3701: || '.'
3702: || l_api_name
3703: || ' Error is '

Line 3722: IF g_debug <= gme_debug.g_log_procedure THEN

3718: l_period_id INTEGER;
3719: l_open_past_period BOOLEAN;
3720: l_api_name VARCHAR2 (100) := 'close_period_check_flexible';
3721: BEGIN
3722: IF g_debug <= gme_debug.g_log_procedure THEN
3723: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3724: || l_api_name);
3725: END IF;
3726:

Line 3723: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

3719: l_open_past_period BOOLEAN;
3720: l_api_name VARCHAR2 (100) := 'close_period_check_flexible';
3721: BEGIN
3722: IF g_debug <= gme_debug.g_log_procedure THEN
3723: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3724: || l_api_name);
3725: END IF;
3726:
3727: invttmtx.tdatechk (org_id => p_org_id

Line 3752: IF g_debug <= gme_debug.g_log_unexpected THEN

3748:
3749: RETURN TRUE;
3750: EXCEPTION
3751: WHEN OTHERS THEN
3752: IF g_debug <= gme_debug.g_log_unexpected THEN
3753: gme_debug.put_line ( 'When others exception in '
3754: || g_pkg_name
3755: || '.'
3756: || l_api_name

Line 3753: gme_debug.put_line ( 'When others exception in '

3749: RETURN TRUE;
3750: EXCEPTION
3751: WHEN OTHERS THEN
3752: IF g_debug <= gme_debug.g_log_unexpected THEN
3753: gme_debug.put_line ( 'When others exception in '
3754: || g_pkg_name
3755: || '.'
3756: || l_api_name
3757: || ' Error is '

Line 3834: IF g_debug <= gme_debug.g_log_procedure THEN

3830: invalid_batchstep_activity EXCEPTION;
3831: invalid_batchstep_resource EXCEPTION;
3832: invalid_record EXCEPTION;
3833: BEGIN
3834: IF g_debug <= gme_debug.g_log_procedure THEN
3835: gme_debug.put_line ( 'Entering FUNCTION '
3836: || g_pkg_name
3837: || '.'
3838: || l_api_name);

Line 3835: gme_debug.put_line ( 'Entering FUNCTION '

3831: invalid_batchstep_resource EXCEPTION;
3832: invalid_record EXCEPTION;
3833: BEGIN
3834: IF g_debug <= gme_debug.g_log_procedure THEN
3835: gme_debug.put_line ( 'Entering FUNCTION '
3836: || g_pkg_name
3837: || '.'
3838: || l_api_name);
3839: gme_debug.put_line ( g_pkg_name

Line 3839: gme_debug.put_line ( g_pkg_name

3835: gme_debug.put_line ( 'Entering FUNCTION '
3836: || g_pkg_name
3837: || '.'
3838: || l_api_name);
3839: gme_debug.put_line ( g_pkg_name
3840: || '.'
3841: || l_api_name
3842: || ' input organization_id => '
3843: || p_batchstep_rsrc_rec.organization_id);

Line 3844: gme_debug.put_line ( g_pkg_name

3840: || '.'
3841: || l_api_name
3842: || ' input organization_id => '
3843: || p_batchstep_rsrc_rec.organization_id);
3844: gme_debug.put_line ( g_pkg_name
3845: || '.'
3846: || l_api_name
3847: || ' input batchstep rsrc id => '
3848: || p_batchstep_rsrc_rec.organization_id);

Line 3849: gme_debug.put_line ( g_pkg_name

3845: || '.'
3846: || l_api_name
3847: || ' input batchstep rsrc id => '
3848: || p_batchstep_rsrc_rec.organization_id);
3849: gme_debug.put_line ( g_pkg_name
3850: || '.'
3851: || l_api_name
3852: || ' input org_code => '
3853: || p_org_code);

Line 3854: gme_debug.put_line ( g_pkg_name

3850: || '.'
3851: || l_api_name
3852: || ' input org_code => '
3853: || p_org_code);
3854: gme_debug.put_line ( g_pkg_name
3855: || '.'
3856: || l_api_name
3857: || ' input batch_no => '
3858: || p_batch_no);

Line 3859: gme_debug.put_line ( g_pkg_name

3855: || '.'
3856: || l_api_name
3857: || ' input batch_no => '
3858: || p_batch_no);
3859: gme_debug.put_line ( g_pkg_name
3860: || '.'
3861: || l_api_name
3862: || ' input batchstep_no => '
3863: || p_batchstep_no);

Line 3864: gme_debug.put_line ( g_pkg_name

3860: || '.'
3861: || l_api_name
3862: || ' input batchstep_no => '
3863: || p_batchstep_no);
3864: gme_debug.put_line ( g_pkg_name
3865: || '.'
3866: || l_api_name
3867: || ' input activity => '
3868: || p_activity);

Line 3869: gme_debug.put_line ( g_pkg_name

3865: || '.'
3866: || l_api_name
3867: || ' input activity => '
3868: || p_activity);
3869: gme_debug.put_line ( g_pkg_name
3870: || '.'
3871: || l_api_name
3872: || ' input resource => '
3873: || p_batchstep_rsrc_rec.resources);

Line 3903: IF g_debug <= gme_debug.g_log_statement THEN

3899: RAISE btchstep_rsrc_fetch_err;
3900: END IF;
3901:
3902: IF p_batchstep_rsrc_rec.organization_id IS NULL THEN
3903: IF g_debug <= gme_debug.g_log_statement THEN
3904: gme_debug.put_line ( g_pkg_name
3905: || '.'
3906: || l_api_name
3907: || ' retrieve org_id using '

Line 3904: gme_debug.put_line ( g_pkg_name

3900: END IF;
3901:
3902: IF p_batchstep_rsrc_rec.organization_id IS NULL THEN
3903: IF g_debug <= gme_debug.g_log_statement THEN
3904: gme_debug.put_line ( g_pkg_name
3905: || '.'
3906: || l_api_name
3907: || ' retrieve org_id using '
3908: || p_org_code);

Line 3927: IF g_debug <= gme_debug.g_log_statement THEN

3923: l_organization_id := p_batchstep_rsrc_rec.organization_id;
3924: END IF;
3925:
3926: IF p_batchstep_rsrc_rec.batch_id IS NULL THEN
3927: IF g_debug <= gme_debug.g_log_statement THEN
3928: gme_debug.put_line ( g_pkg_name
3929: || '.'
3930: || l_api_name
3931: || ' retrieve batch_id using '

Line 3928: gme_debug.put_line ( g_pkg_name

3924: END IF;
3925:
3926: IF p_batchstep_rsrc_rec.batch_id IS NULL THEN
3927: IF g_debug <= gme_debug.g_log_statement THEN
3928: gme_debug.put_line ( g_pkg_name
3929: || '.'
3930: || l_api_name
3931: || ' retrieve batch_id using '
3932: || p_batch_no);

Line 3951: IF g_debug <= gme_debug.g_log_statement THEN

3947: l_batch_id := p_batchstep_rsrc_rec.batch_id;
3948: END IF;
3949:
3950: IF p_batchstep_rsrc_rec.batchstep_id IS NULL THEN
3951: IF g_debug <= gme_debug.g_log_statement THEN
3952: gme_debug.put_line ( g_pkg_name
3953: || '.'
3954: || l_api_name
3955: || ' retrieve batchstep_id using '

Line 3952: gme_debug.put_line ( g_pkg_name

3948: END IF;
3949:
3950: IF p_batchstep_rsrc_rec.batchstep_id IS NULL THEN
3951: IF g_debug <= gme_debug.g_log_statement THEN
3952: gme_debug.put_line ( g_pkg_name
3953: || '.'
3954: || l_api_name
3955: || ' retrieve batchstep_id using '
3956: || p_batchstep_no);

Line 3975: IF g_debug <= gme_debug.g_log_statement THEN

3971: l_batchstep_id := p_batchstep_rsrc_rec.batchstep_id;
3972: END IF;
3973:
3974: IF p_batchstep_rsrc_rec.batchstep_resource_id IS NULL THEN
3975: IF g_debug <= gme_debug.g_log_statement THEN
3976: gme_debug.put_line ( g_pkg_name
3977: || '.'
3978: || l_api_name
3979: || ' retrieve resource_id using org_id '

Line 3976: gme_debug.put_line ( g_pkg_name

3972: END IF;
3973:
3974: IF p_batchstep_rsrc_rec.batchstep_resource_id IS NULL THEN
3975: IF g_debug <= gme_debug.g_log_statement THEN
3976: gme_debug.put_line ( g_pkg_name
3977: || '.'
3978: || l_api_name
3979: || ' retrieve resource_id using org_id '
3980: || l_organization_id

Line 4025: IF g_debug <= gme_debug.g_log_unexpected THEN

4021:
4022: RETURN TRUE;
4023: EXCEPTION
4024: WHEN invalid_record OR btchstep_rsrc_fetch_err OR invalid_organization OR invalid_batch OR invalid_batchstep OR invalid_batchstep_activity OR invalid_batchstep_resource THEN
4025: IF g_debug <= gme_debug.g_log_unexpected THEN
4026: gme_debug.put_line
4027: ( ' user defined exception in gme_common_pvt.get_resource function'
4028: || SQLERRM);
4029: END IF;

Line 4026: gme_debug.put_line

4022: RETURN TRUE;
4023: EXCEPTION
4024: WHEN invalid_record OR btchstep_rsrc_fetch_err OR invalid_organization OR invalid_batch OR invalid_batchstep OR invalid_batchstep_activity OR invalid_batchstep_resource THEN
4025: IF g_debug <= gme_debug.g_log_unexpected THEN
4026: gme_debug.put_line
4027: ( ' user defined exception in gme_common_pvt.get_resource function'
4028: || SQLERRM);
4029: END IF;
4030:

Line 4033: IF g_debug <= gme_debug.g_log_unexpected THEN

4029: END IF;
4030:
4031: RETURN FALSE;
4032: WHEN OTHERS THEN
4033: IF g_debug <= gme_debug.g_log_unexpected THEN
4034: gme_debug.put_line
4035: ( ' when others: exception in gme_common_pvt.get_resource function'
4036: || SQLERRM);
4037: END IF;

Line 4034: gme_debug.put_line

4030:
4031: RETURN FALSE;
4032: WHEN OTHERS THEN
4033: IF g_debug <= gme_debug.g_log_unexpected THEN
4034: gme_debug.put_line
4035: ( ' when others: exception in gme_common_pvt.get_resource function'
4036: || SQLERRM);
4037: END IF;
4038:

Line 4091: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4087: /* EXCEPTION Definitions */
4088: invalid_validity_rule EXCEPTION;
4089: BEGIN
4090: IF (NVL (g_debug, 0) IN
4091: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4092: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4093: || 'Entering');
4094: END IF;
4095:

Line 4092: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

4088: invalid_validity_rule EXCEPTION;
4089: BEGIN
4090: IF (NVL (g_debug, 0) IN
4091: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4092: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4093: || 'Entering');
4094: END IF;
4095:
4096: OPEN get_validity_rule (p_validity_rule_id);

Line 4184: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4180: END IF; /* l_status_type IN ('1000', '800') */
4181: END IF; /* p_batch_header_rec.batch_id IS NOT NULL */
4182:
4183: IF (NVL (g_debug, 0) IN
4184: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4185: gme_debug.put_line ( g_pkg_name
4186: || '.'
4187: || l_api_name
4188: || ':'

Line 4185: gme_debug.put_line ( g_pkg_name

4181: END IF; /* p_batch_header_rec.batch_id IS NOT NULL */
4182:
4183: IF (NVL (g_debug, 0) IN
4184: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4185: gme_debug.put_line ( g_pkg_name
4186: || '.'
4187: || l_api_name
4188: || ':'
4189: || 'Exiting with TRUE');

Line 4199: gme_debug.put_line ( g_pkg_name

4195: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4196: RETURN FALSE;
4197: WHEN OTHERS THEN
4198: IF (NVL (g_debug, 0) > 0) THEN
4199: gme_debug.put_line ( g_pkg_name
4200: || '.'
4201: || l_api_name
4202: || ':'
4203: || ' OTHERS:'

Line 4326: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4322: /* Punit Kumar */
4323: l_batchstep_rec gme_batch_steps%ROWTYPE;
4324: BEGIN
4325: IF (NVL (g_debug, 0) IN
4326: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4327: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4328: || 'Entering');
4329: gme_debug.put_line ( 'Value of p_material_detail_id : '
4330: || p_material_detail_id

Line 4327: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

4323: l_batchstep_rec gme_batch_steps%ROWTYPE;
4324: BEGIN
4325: IF (NVL (g_debug, 0) IN
4326: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4327: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4328: || 'Entering');
4329: gme_debug.put_line ( 'Value of p_material_detail_id : '
4330: || p_material_detail_id
4331: || ', p_material_date: '

Line 4329: gme_debug.put_line ( 'Value of p_material_detail_id : '

4325: IF (NVL (g_debug, 0) IN
4326: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4327: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4328: || 'Entering');
4329: gme_debug.put_line ( 'Value of p_material_detail_id : '
4330: || p_material_detail_id
4331: || ', p_material_date: '
4332: || TO_CHAR (p_material_date
4333: ,'MM/DD/YYYY HH24:MI:SS') );

Line 4357: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4353: IF p_material_date IS NOT NULL THEN
4354: l_material_date := p_material_date;
4355:
4356: IF (NVL (g_debug, 0) IN
4357: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4358: gme_debug.put_line
4359: ( 'Update existing Material Required Date : '
4360: || TO_CHAR (l_material_detail_rec.material_requirement_date
4361: ,'MM/DD/YYYY HH24:MI:SS')

Line 4358: gme_debug.put_line

4354: l_material_date := p_material_date;
4355:
4356: IF (NVL (g_debug, 0) IN
4357: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4358: gme_debug.put_line
4359: ( 'Update existing Material Required Date : '
4360: || TO_CHAR (l_material_detail_rec.material_requirement_date
4361: ,'MM/DD/YYYY HH24:MI:SS')
4362: || ' in Gme_material_details with new Material Required Date : '

Line 4367: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4363: || TO_CHAR (p_material_date, 'MM/DD/YYYY HH24:MI:SS') );
4364: END IF;
4365: ELSE /* p_material_date IS NULL */
4366: IF (NVL (g_debug, 0) IN
4367: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4368: gme_debug.put_line
4369: ('p_material_date is null calling gme_common_pvt.calc_mtl_req_date');
4370: END IF;
4371:

Line 4368: gme_debug.put_line

4364: END IF;
4365: ELSE /* p_material_date IS NULL */
4366: IF (NVL (g_debug, 0) IN
4367: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4368: gme_debug.put_line
4369: ('p_material_date is null calling gme_common_pvt.calc_mtl_req_date');
4370: END IF;
4371:
4372: IF get_assoc_step (p_material_detail_id

Line 4389: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4385: ,x_mtl_req_date => l_material_date
4386: ,x_return_status => l_return_status);
4387:
4388: IF (NVL (g_debug, 0) IN
4389: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4390: gme_debug.put_line
4391: ( 'Came back from gme_common_pvt.calc_mtl_req_date with status '
4392: || l_return_status);
4393: END IF;

Line 4390: gme_debug.put_line

4386: ,x_return_status => l_return_status);
4387:
4388: IF (NVL (g_debug, 0) IN
4389: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4390: gme_debug.put_line
4391: ( 'Came back from gme_common_pvt.calc_mtl_req_date with status '
4392: || l_return_status);
4393: END IF;
4394:

Line 4410: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4406: RAISE fnd_api.g_exc_error;
4407: END IF;
4408:
4409: IF (NVL (g_debug, 0) IN
4410: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4411: gme_debug.put_line ('Came back from update of gme_material_details');
4412: END IF;
4413:
4414: IF (NVL (g_debug, 0) IN

Line 4411: gme_debug.put_line ('Came back from update of gme_material_details');

4407: END IF;
4408:
4409: IF (NVL (g_debug, 0) IN
4410: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4411: gme_debug.put_line ('Came back from update of gme_material_details');
4412: END IF;
4413:
4414: IF (NVL (g_debug, 0) IN
4415: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

Line 4415: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4411: gme_debug.put_line ('Came back from update of gme_material_details');
4412: END IF;
4413:
4414: IF (NVL (g_debug, 0) IN
4415: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4416: gme_debug.put_line ( g_pkg_name
4417: || '.'
4418: || l_api_name
4419: || ':'

Line 4416: gme_debug.put_line ( g_pkg_name

4412: END IF;
4413:
4414: IF (NVL (g_debug, 0) IN
4415: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4416: gme_debug.put_line ( g_pkg_name
4417: || '.'
4418: || l_api_name
4419: || ':'
4420: || 'Exiting with '

Line 4429: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4425: /* Change of date a supply line could influence associated sales reservations so */
4426: /* we need to notify the sales representatve accordingly */
4427: /* ==============================================================================*/
4428: IF (NVL (g_debug, 0) IN
4429: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4430: gme_debug.put_line (' Assessing line type which is '||l_material_detail_rec.line_type);
4431: END IF;
4432: IF l_material_detail_rec.line_type <> gme_common_pvt.g_line_type_ing THEN /* -1 */
4433: IF (NVL (g_debug, 0) IN

Line 4430: gme_debug.put_line (' Assessing line type which is '||l_material_detail_rec.line_type);

4426: /* we need to notify the sales representatve accordingly */
4427: /* ==============================================================================*/
4428: IF (NVL (g_debug, 0) IN
4429: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4430: gme_debug.put_line (' Assessing line type which is '||l_material_detail_rec.line_type);
4431: END IF;
4432: IF l_material_detail_rec.line_type <> gme_common_pvt.g_line_type_ing THEN /* -1 */
4433: IF (NVL (g_debug, 0) IN
4434: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

Line 4434: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4430: gme_debug.put_line (' Assessing line type which is '||l_material_detail_rec.line_type);
4431: END IF;
4432: IF l_material_detail_rec.line_type <> gme_common_pvt.g_line_type_ing THEN /* -1 */
4433: IF (NVL (g_debug, 0) IN
4434: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4435: gme_debug.put_line (' Line is a source of supply so invoke Query_Prod_Supply_Reservations');
4436: END IF;
4437: GME_SUPPLY_RES_PVT.query_prod_supply_reservations
4438: (p_matl_dtl_rec => l_material_detail_rec

Line 4435: gme_debug.put_line (' Line is a source of supply so invoke Query_Prod_Supply_Reservations');

4431: END IF;
4432: IF l_material_detail_rec.line_type <> gme_common_pvt.g_line_type_ing THEN /* -1 */
4433: IF (NVL (g_debug, 0) IN
4434: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4435: gme_debug.put_line (' Line is a source of supply so invoke Query_Prod_Supply_Reservations');
4436: END IF;
4437: GME_SUPPLY_RES_PVT.query_prod_supply_reservations
4438: (p_matl_dtl_rec => l_material_detail_rec
4439: ,x_mtl_reservation_tbl => l_rsv_tbl

Line 4445: IF g_debug <= gme_debug.g_log_procedure THEN

4441: ,x_msg_count => l_msg_count
4442: ,x_msg_data => l_msg_data
4443: ,x_return_status => l_return_status);
4444:
4445: IF g_debug <= gme_debug.g_log_procedure THEN
4446: gme_debug.put_line
4447: ( g_pkg_name
4448: || '.'
4449: || l_api_name

Line 4446: gme_debug.put_line

4442: ,x_msg_data => l_msg_data
4443: ,x_return_status => l_return_status);
4444:
4445: IF g_debug <= gme_debug.g_log_procedure THEN
4446: gme_debug.put_line
4447: ( g_pkg_name
4448: || '.'
4449: || l_api_name
4450: || 'Return status from query_prod_supply_reservations is '

Line 4452: gme_debug.put_line

4448: || '.'
4449: || l_api_name
4450: || 'Return status from query_prod_supply_reservations is '
4451: || l_return_status);
4452: gme_debug.put_line
4453: ( g_pkg_name
4454: || '.'
4455: || l_api_name
4456: || ' number of reservations is '

Line 4464: gme_debug.put_line ('source line id is => '|| l_rsv_tbl(k).demand_source_line_id);

4460: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
4461: RAISE query_reservations_error;
4462: END IF;
4463: FOR k IN 1 .. l_rsv_count LOOP
4464: gme_debug.put_line ('source line id is => '|| l_rsv_tbl(k).demand_source_line_id);
4465: -- Issue notifications for any impacted sales order lines
4466: IF l_rsv_tbl(k).demand_source_type_id = 2 THEN -- sales
4467: IF g_debug <= gme_debug.g_log_procedure THEN
4468: gme_debug.put_line ('Demand is from Sales ');

Line 4467: IF g_debug <= gme_debug.g_log_procedure THEN

4463: FOR k IN 1 .. l_rsv_count LOOP
4464: gme_debug.put_line ('source line id is => '|| l_rsv_tbl(k).demand_source_line_id);
4465: -- Issue notifications for any impacted sales order lines
4466: IF l_rsv_tbl(k).demand_source_type_id = 2 THEN -- sales
4467: IF g_debug <= gme_debug.g_log_procedure THEN
4468: gme_debug.put_line ('Demand is from Sales ');
4469: END IF;
4470: GME_SUPPLY_RES_PVT.notify_CSR
4471: ( P_Batch_id => l_rsv_tbl(k).supply_source_header_id

Line 4468: gme_debug.put_line ('Demand is from Sales ');

4464: gme_debug.put_line ('source line id is => '|| l_rsv_tbl(k).demand_source_line_id);
4465: -- Issue notifications for any impacted sales order lines
4466: IF l_rsv_tbl(k).demand_source_type_id = 2 THEN -- sales
4467: IF g_debug <= gme_debug.g_log_procedure THEN
4468: gme_debug.put_line ('Demand is from Sales ');
4469: END IF;
4470: GME_SUPPLY_RES_PVT.notify_CSR
4471: ( P_Batch_id => l_rsv_tbl(k).supply_source_header_id
4472: , P_Batch_line_id => l_rsv_tbl(k).supply_source_line_id

Line 4481: IF g_debug <= gme_debug.g_log_procedure THEN

4477: , X_return_status => x_return_status
4478: , X_msg_cont => l_msg_count
4479: , X_msg_data => l_msg_data );
4480:
4481: IF g_debug <= gme_debug.g_log_procedure THEN
4482: gme_debug.put_line ( g_pkg_name || '.'
4483: || l_api_name
4484: || ' after calling notify_CSR for date change status is '
4485: || x_return_status );

Line 4482: gme_debug.put_line ( g_pkg_name || '.'

4478: , X_msg_cont => l_msg_count
4479: , X_msg_data => l_msg_data );
4480:
4481: IF g_debug <= gme_debug.g_log_procedure THEN
4482: gme_debug.put_line ( g_pkg_name || '.'
4483: || l_api_name
4484: || ' after calling notify_CSR for date change status is '
4485: || x_return_status );
4486: END IF;

Line 4505: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4501: IF l_batch_header_rec.update_inventory_ind <> 'Y'
4502: OR l_material_detail_rec.line_type <>
4503: gme_common_pvt.g_line_type_ing /* -1 */ THEN
4504: IF (NVL (g_debug, 0) IN
4505: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4506: gme_debug.put_line
4507: ( 'Returning no further processing of reservations and Move Orders are required. '
4508: || 'Because update_inventory_ind : '
4509: || l_batch_header_rec.update_inventory_ind

Line 4506: gme_debug.put_line

4502: OR l_material_detail_rec.line_type <>
4503: gme_common_pvt.g_line_type_ing /* -1 */ THEN
4504: IF (NVL (g_debug, 0) IN
4505: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4506: gme_debug.put_line
4507: ( 'Returning no further processing of reservations and Move Orders are required. '
4508: || 'Because update_inventory_ind : '
4509: || l_batch_header_rec.update_inventory_ind
4510: || ' line_type : '

Line 4521: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4517: /* Query reservations for the material_detail_id by calling Query_reservation. */
4518: l_rsv.demand_source_type_id := gme_common_pvt.g_txn_source_type;
4519:
4520: IF (NVL (g_debug, 0) IN
4521: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4522: gme_debug.put_line ('Calling Query Reservation.');
4523: END IF;
4524:
4525: /* start ,Punit Kumar */

Line 4522: gme_debug.put_line ('Calling Query Reservation.');

4518: l_rsv.demand_source_type_id := gme_common_pvt.g_txn_source_type;
4519:
4520: IF (NVL (g_debug, 0) IN
4521: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4522: gme_debug.put_line ('Calling Query Reservation.');
4523: END IF;
4524:
4525: /* start ,Punit Kumar */
4526: gme_reservations_pvt.get_material_reservations

Line 4536: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4532: l_size := l_rsv_array.COUNT;
4533:
4534: /* end */
4535: IF (NVL (g_debug, 0) IN
4536: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4537: gme_debug.put_line
4538: ( 'Came back from Query Reservation with status '
4539: || l_return_status);
4540: END IF;

Line 4537: gme_debug.put_line

4533:
4534: /* end */
4535: IF (NVL (g_debug, 0) IN
4536: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4537: gme_debug.put_line
4538: ( 'Came back from Query Reservation with status '
4539: || l_return_status);
4540: END IF;
4541:

Line 4561: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4557: /* Delete the reservation by calling
4558: * The parameters that will be assigned to identity the reservations
4559: * to be deleted are the same as used for querying the reservations*/
4560: IF (NVL (g_debug, 0) IN
4561: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4562: gme_debug.put_line ('Calling Delete Reservation.');
4563: END IF;
4564:
4565: gme_reservations_pvt.delete_reservation

Line 4562: gme_debug.put_line ('Calling Delete Reservation.');

4558: * The parameters that will be assigned to identity the reservations
4559: * to be deleted are the same as used for querying the reservations*/
4560: IF (NVL (g_debug, 0) IN
4561: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4562: gme_debug.put_line ('Calling Delete Reservation.');
4563: END IF;
4564:
4565: gme_reservations_pvt.delete_reservation
4566: (p_reservation_id => l_rsv_array (j).reservation_id

Line 4570: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4566: (p_reservation_id => l_rsv_array (j).reservation_id
4567: ,x_return_status => l_return_status);
4568:
4569: IF (NVL (g_debug, 0) IN
4570: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4571: gme_debug.put_line
4572: ( 'Came back from Delete Reservation with status '
4573: || l_return_status);
4574: END IF;

Line 4571: gme_debug.put_line

4567: ,x_return_status => l_return_status);
4568:
4569: IF (NVL (g_debug, 0) IN
4570: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4571: gme_debug.put_line
4572: ( 'Came back from Delete Reservation with status '
4573: || l_return_status);
4574: END IF;
4575:

Line 4583: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4579: END IF;
4580: ELSE
4581: /* l_lot_expiration_date <= l_material_date */
4582: IF (NVL (g_debug, 0) IN
4583: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4584: gme_debug.put_line
4585: ('Lot expiration date > material date + l_shelf_life_days');
4586: END IF;
4587:

Line 4584: gme_debug.put_line

4580: ELSE
4581: /* l_lot_expiration_date <= l_material_date */
4582: IF (NVL (g_debug, 0) IN
4583: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4584: gme_debug.put_line
4585: ('Lot expiration date > material date + l_shelf_life_days');
4586: END IF;
4587:
4588: /* For remaining reserved lots, update the material required

Line 4592: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4588: /* For remaining reserved lots, update the material required
4589: date with the l_material_date. Assign the new required date to
4590: the corresponding parameter of p_to_rsv_rec */
4591: IF (NVL (g_debug, 0) IN
4592: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4593: gme_debug.put_line
4594: ( 'Calling Update Reservation for reservation_id: '
4595: || l_rsv_array (j).reservation_id
4596: || ' requirement_date: '

Line 4593: gme_debug.put_line

4589: date with the l_material_date. Assign the new required date to
4590: the corresponding parameter of p_to_rsv_rec */
4591: IF (NVL (g_debug, 0) IN
4592: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4593: gme_debug.put_line
4594: ( 'Calling Update Reservation for reservation_id: '
4595: || l_rsv_array (j).reservation_id
4596: || ' requirement_date: '
4597: || TO_CHAR (l_material_date, 'MM/DD/YYYY HH24:MI:SS') );

Line 4612: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4608: ,p_new_date => l_material_date
4609: ,x_return_status => l_return_status);
4610:
4611: IF (NVL (g_debug, 0) IN
4612: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4613: gme_debug.put_line
4614: ( 'Came back from Update Reservation with status '
4615: || l_return_status);
4616: END IF;

Line 4613: gme_debug.put_line

4609: ,x_return_status => l_return_status);
4610:
4611: IF (NVL (g_debug, 0) IN
4612: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4613: gme_debug.put_line
4614: ( 'Came back from Update Reservation with status '
4615: || l_return_status);
4616: END IF;
4617:

Line 4642: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4638:
4639: FOR k IN 1 .. l_loop_count_mo_lines LOOP
4640: -- Update MO lines
4641: IF (NVL (g_debug, 0) IN
4642: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4643: gme_debug.put_line
4644: ( 'Calling Process move order line for txn_source_line_id : '
4645: || l_material_detail_rec.material_detail_id
4646: || ' Date_required : '

Line 4643: gme_debug.put_line

4639: FOR k IN 1 .. l_loop_count_mo_lines LOOP
4640: -- Update MO lines
4641: IF (NVL (g_debug, 0) IN
4642: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4643: gme_debug.put_line
4644: ( 'Calling Process move order line for txn_source_line_id : '
4645: || l_material_detail_rec.material_detail_id
4646: || ' Date_required : '
4647: || TO_CHAR (l_material_date, 'MM/DD/YYYY HH24:MI:SS') );

Line 4659: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4655: ,p_invis_move_line_id => NULL
4656: ,x_return_status => l_return_status);
4657:
4658: IF (NVL (g_debug, 0) IN
4659: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4660: gme_debug.put_line
4661: ( 'Came back from Process move order line with status '
4662: || l_return_status);
4663: END IF;

Line 4660: gme_debug.put_line

4656: ,x_return_status => l_return_status);
4657:
4658: IF (NVL (g_debug, 0) IN
4659: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4660: gme_debug.put_line
4661: ( 'Came back from Process move order line with status '
4662: || l_return_status);
4663: END IF;
4664:

Line 4695: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4691: l_mo_deleted := 1;
4692:
4693: -- Delete mo alloacations
4694: IF (NVL (g_debug, 0) IN
4695: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4696: gme_debug.put_line
4697: ( 'Delete mo alloacations for mo_line_id: '
4698: || l_mo_line_allocations_tbl (j).transaction_temp_id);
4699: END IF;

Line 4696: gme_debug.put_line

4692:
4693: -- Delete mo alloacations
4694: IF (NVL (g_debug, 0) IN
4695: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4696: gme_debug.put_line
4697: ( 'Delete mo alloacations for mo_line_id: '
4698: || l_mo_line_allocations_tbl (j).transaction_temp_id);
4699: END IF;
4700:

Line 4709: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4705: ,p_mo_line_id => l_mo_lines_tbl (k).line_id
4706: ,p_transaction_temp_id => l_mo_line_allocations_tbl (j).transaction_temp_id);
4707:
4708: IF (NVL (g_debug, 0) IN
4709: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4710: gme_debug.put_line
4711: ( 'Came back from Delete Allocations with status '
4712: || l_return_status);
4713: END IF;

Line 4710: gme_debug.put_line

4706: ,p_transaction_temp_id => l_mo_line_allocations_tbl (j).transaction_temp_id);
4707:
4708: IF (NVL (g_debug, 0) IN
4709: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4710: gme_debug.put_line
4711: ( 'Came back from Delete Allocations with status '
4712: || l_return_status);
4713: END IF;
4714:

Line 4733: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4729: RAISE mo_err;
4730: END IF;
4731:
4732: IF (NVL (g_debug, 0) IN
4733: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4734: gme_debug.put_line ( g_pkg_name
4735: || '.'
4736: || l_api_name
4737: || ':'

Line 4734: gme_debug.put_line ( g_pkg_name

4730: END IF;
4731:
4732: IF (NVL (g_debug, 0) IN
4733: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4734: gme_debug.put_line ( g_pkg_name
4735: || '.'
4736: || l_api_name
4737: || ':'
4738: || 'Exiting with '

Line 4764: IF g_debug <= gme_debug.g_log_statement THEN

4760: x_return_status := 'M';
4761: WHEN reservation_api_failed OR process_move_order_failed OR delete_allocations_failed THEN
4762: x_return_status := l_return_status;
4763: WHEN query_reservations_error OR notify_CSR_err THEN -- 4944024 BEGIN
4764: IF g_debug <= gme_debug.g_log_statement THEN
4765: gme_debug.put_line
4766: ( g_pkg_name
4767: || '.'
4768: || l_api_name

Line 4765: gme_debug.put_line

4761: WHEN reservation_api_failed OR process_move_order_failed OR delete_allocations_failed THEN
4762: x_return_status := l_return_status;
4763: WHEN query_reservations_error OR notify_CSR_err THEN -- 4944024 BEGIN
4764: IF g_debug <= gme_debug.g_log_statement THEN
4765: gme_debug.put_line
4766: ( g_pkg_name
4767: || '.'
4768: || l_api_name
4769: || 'Error is :'

Line 4777: gme_debug.put_line ( g_pkg_name

4773: x_return_status := fnd_api.g_ret_sts_unexp_error;
4774: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4775:
4776: IF (NVL (g_debug, 0) > 0) THEN
4777: gme_debug.put_line ( g_pkg_name
4778: || '.'
4779: || l_api_name
4780: || ':'
4781: || ' OTHERS:'

Line 4811: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4807: l_is_auto NUMBER;
4808: l_api_name CONSTANT VARCHAR2 (30) := 'IS_MATERIAL_AUTO_RELEASE';
4809: BEGIN
4810: IF (NVL (g_debug, 0) IN
4811: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4812: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4813: || 'Entering');
4814: END IF;
4815:

Line 4812: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

4808: l_api_name CONSTANT VARCHAR2 (30) := 'IS_MATERIAL_AUTO_RELEASE';
4809: BEGIN
4810: IF (NVL (g_debug, 0) IN
4811: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4812: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4813: || 'Entering');
4814: END IF;
4815:
4816: SELECT release_type

Line 4841: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4837: END IF;
4838: END IF; /* l_release_type = 0 */
4839:
4840: IF (NVL (g_debug, 0) IN
4841: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4842: gme_debug.put_line ( g_pkg_name
4843: || '.'
4844: || l_api_name
4845: || ':'

Line 4842: gme_debug.put_line ( g_pkg_name

4838: END IF; /* l_release_type = 0 */
4839:
4840: IF (NVL (g_debug, 0) IN
4841: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4842: gme_debug.put_line ( g_pkg_name
4843: || '.'
4844: || l_api_name
4845: || ':'
4846: || 'Exiting with l_is_auto: '

Line 4856: gme_debug.put_line ( g_pkg_name

4852: WHEN OTHERS THEN
4853: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4854:
4855: IF (NVL (g_debug, 0) > 0) THEN
4856: gme_debug.put_line ( g_pkg_name
4857: || '.'
4858: || l_api_name
4859: || ':'
4860: || ' OTHERS:'

Line 4886: IF g_debug <= gme_debug.g_log_procedure THEN

4882: l_api_name VARCHAR2 (30) := 'GET_MATERIAL_DETAIL';
4883: material_detail_fetch_error EXCEPTION;
4884: batch_header_fetch_error EXCEPTION;
4885: BEGIN
4886: IF g_debug <= gme_debug.g_log_procedure THEN
4887: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
4888: || l_api_name);
4889: END IF;
4890:

Line 4887: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

4883: material_detail_fetch_error EXCEPTION;
4884: batch_header_fetch_error EXCEPTION;
4885: BEGIN
4886: IF g_debug <= gme_debug.g_log_procedure THEN
4887: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
4888: || l_api_name);
4889: END IF;
4890:
4891: IF p_org_code IS NOT NULL

Line 4924: IF g_debug <= gme_debug.g_log_unexpected THEN

4920:
4921: RETURN TRUE;
4922: EXCEPTION
4923: WHEN OTHERS THEN
4924: IF g_debug <= gme_debug.g_log_unexpected THEN
4925: gme_debug.put_line ( 'When others exception in '
4926: || g_pkg_name
4927: || '.'
4928: || l_api_name

Line 4925: gme_debug.put_line ( 'When others exception in '

4921: RETURN TRUE;
4922: EXCEPTION
4923: WHEN OTHERS THEN
4924: IF g_debug <= gme_debug.g_log_unexpected THEN
4925: gme_debug.put_line ( 'When others exception in '
4926: || g_pkg_name
4927: || '.'
4928: || l_api_name
4929: || ' Error is '

Line 4946: IF g_debug <= gme_debug.g_log_procedure THEN

4942: l_period_id INTEGER;
4943: l_open_past_period BOOLEAN;
4944: l_api_name VARCHAR2 (100) := 'check_close_period';
4945: BEGIN
4946: IF g_debug <= gme_debug.g_log_procedure THEN
4947: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
4948: || l_api_name);
4949: END IF;
4950:

Line 4947: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

4943: l_open_past_period BOOLEAN;
4944: l_api_name VARCHAR2 (100) := 'check_close_period';
4945: BEGIN
4946: IF g_debug <= gme_debug.g_log_procedure THEN
4947: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
4948: || l_api_name);
4949: END IF;
4950:
4951: invttmtx.tdatechk (org_id => p_org_id

Line 4969: IF g_debug <= gme_debug.g_log_unexpected THEN

4965: END IF;
4966: RETURN TRUE;
4967: EXCEPTION
4968: WHEN OTHERS THEN
4969: IF g_debug <= gme_debug.g_log_unexpected THEN
4970: gme_debug.put_line ( 'When others exception in '
4971: || g_pkg_name
4972: || '.'
4973: || l_api_name

Line 4970: gme_debug.put_line ( 'When others exception in '

4966: RETURN TRUE;
4967: EXCEPTION
4968: WHEN OTHERS THEN
4969: IF g_debug <= gme_debug.g_log_unexpected THEN
4970: gme_debug.put_line ( 'When others exception in '
4971: || g_pkg_name
4972: || '.'
4973: || l_api_name
4974: || ' Error is '

Line 5014: IF g_debug <= gme_debug.g_log_procedure THEN

5010: l_batch_header_rec gme_batch_header%ROWTYPE;
5011:
5012: batch_header_fetch_error EXCEPTION;
5013: BEGIN
5014: IF g_debug <= gme_debug.g_log_procedure THEN
5015: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
5016: || l_api_name);
5017: END IF;
5018: /* Set the return status to success initially */

Line 5015: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

5011:
5012: batch_header_fetch_error EXCEPTION;
5013: BEGIN
5014: IF g_debug <= gme_debug.g_log_procedure THEN
5015: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
5016: || l_api_name);
5017: END IF;
5018: /* Set the return status to success initially */
5019: x_return_status := fnd_api.g_ret_sts_success;

Line 5036: IF (g_debug = gme_debug.g_log_statement) THEN

5032: (p_batch_header_rec => p_batch_header_rec
5033: ,p_org_code => p_org_code
5034: ,p_batch_type => p_batch_type
5035: ,x_batch_header_rec => l_batch_header_rec) THEN
5036: IF (g_debug = gme_debug.g_log_statement) THEN
5037: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ': batch not found ');
5038: END IF;
5039: gme_common_pvt.log_message ('GME_BATCH_NOT_FOUND');
5040: RAISE batch_header_fetch_error;

Line 5037: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ': batch not found ');

5033: ,p_org_code => p_org_code
5034: ,p_batch_type => p_batch_type
5035: ,x_batch_header_rec => l_batch_header_rec) THEN
5036: IF (g_debug = gme_debug.g_log_statement) THEN
5037: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ': batch not found ');
5038: END IF;
5039: gme_common_pvt.log_message ('GME_BATCH_NOT_FOUND');
5040: RAISE batch_header_fetch_error;
5041: END IF;

Line 5061: IF (g_debug = gme_debug.g_log_statement) THEN

5057: gme_common_pvt.setup (p_org_id => l_batch_header_rec.organization_id
5058: ,p_org_code => p_org_code);
5059:
5060: IF NOT gme_common_pvt.g_setup_done THEN
5061: IF (g_debug = gme_debug.g_log_statement) THEN
5062: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ':set up problem ');
5063: END IF;
5064: RAISE fnd_api.g_exc_error;
5065: ELSE

Line 5062: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ':set up problem ');

5058: ,p_org_code => p_org_code);
5059:
5060: IF NOT gme_common_pvt.g_setup_done THEN
5061: IF (g_debug = gme_debug.g_log_statement) THEN
5062: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ':set up problem ');
5063: END IF;
5064: RAISE fnd_api.g_exc_error;
5065: ELSE
5066: l_batch_header_rec.organization_id :=

Line 5071: IF g_debug <= gme_debug.g_log_statement THEN

5067: gme_common_pvt.g_organization_id;
5068: END IF;
5069: x_batch_header_rec := l_batch_header_rec ;
5070:
5071: IF g_debug <= gme_debug.g_log_statement THEN
5072: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5073: 'exiting batch_header_id = ' || x_batch_header_rec.batch_id);
5074: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5075: 'exiting organization_id = ' || x_batch_header_rec.organization_id);

Line 5072: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||

5068: END IF;
5069: x_batch_header_rec := l_batch_header_rec ;
5070:
5071: IF g_debug <= gme_debug.g_log_statement THEN
5072: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5073: 'exiting batch_header_id = ' || x_batch_header_rec.batch_id);
5074: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5075: 'exiting organization_id = ' || x_batch_header_rec.organization_id);
5076: END IF;

Line 5074: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||

5070:
5071: IF g_debug <= gme_debug.g_log_statement THEN
5072: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5073: 'exiting batch_header_id = ' || x_batch_header_rec.batch_id);
5074: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5075: 'exiting organization_id = ' || x_batch_header_rec.organization_id);
5076: END IF;
5077: EXCEPTION
5078: WHEN fnd_api.g_exc_error THEN

Line 5083: IF g_debug <= gme_debug.g_log_unexpected THEN

5079: x_return_status := fnd_api.g_ret_sts_error;
5080: WHEN batch_header_fetch_error THEN
5081: x_return_status := fnd_api.g_ret_sts_error;
5082: WHEN OTHERS THEN
5083: IF g_debug <= gme_debug.g_log_unexpected THEN
5084: gme_debug.put_line ( 'When others exception in '
5085: || g_pkg_name|| '.'||l_api_name||'Error is '
5086: || SQLERRM);
5087: END IF;

Line 5084: gme_debug.put_line ( 'When others exception in '

5080: WHEN batch_header_fetch_error THEN
5081: x_return_status := fnd_api.g_ret_sts_error;
5082: WHEN OTHERS THEN
5083: IF g_debug <= gme_debug.g_log_unexpected THEN
5084: gme_debug.put_line ( 'When others exception in '
5085: || g_pkg_name|| '.'||l_api_name||'Error is '
5086: || SQLERRM);
5087: END IF;
5088: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5123: IF g_debug <= gme_debug.g_log_procedure THEN

5119: l_batch_header_rec gme_batch_header%ROWTYPE;
5120: l_material_detail_rec gme_material_details%ROWTYPE;
5121: material_fetch_error EXCEPTION;
5122: BEGIN
5123: IF g_debug <= gme_debug.g_log_procedure THEN
5124: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
5125: || l_api_name);
5126: END IF;
5127:

Line 5124: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

5120: l_material_detail_rec gme_material_details%ROWTYPE;
5121: material_fetch_error EXCEPTION;
5122: BEGIN
5123: IF g_debug <= gme_debug.g_log_procedure THEN
5124: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
5125: || l_api_name);
5126: END IF;
5127:
5128: /* Set the return status to success initially */

Line 5146: IF (g_debug = gme_debug.g_log_statement) THEN

5142: ,p_batch_type => p_batch_type
5143: ,x_batch_header_rec => l_batch_header_rec
5144: ,x_material_detail_rec => l_material_detail_rec) THEN
5145:
5146: IF (g_debug = gme_debug.g_log_statement) THEN
5147: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ': batch not found ');
5148: END IF;
5149:
5150: RAISE material_fetch_error;

Line 5147: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ': batch not found ');

5143: ,x_batch_header_rec => l_batch_header_rec
5144: ,x_material_detail_rec => l_material_detail_rec) THEN
5145:
5146: IF (g_debug = gme_debug.g_log_statement) THEN
5147: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ': batch not found ');
5148: END IF;
5149:
5150: RAISE material_fetch_error;
5151:

Line 5172: IF (g_debug = gme_debug.g_log_statement) THEN

5168: gme_common_pvt.setup (p_org_id => l_batch_header_rec.organization_id
5169: ,p_org_code => p_org_code);
5170:
5171: IF NOT gme_common_pvt.g_setup_done THEN
5172: IF (g_debug = gme_debug.g_log_statement) THEN
5173: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ':set up problem ');
5174: END IF;
5175: RAISE fnd_api.g_exc_error;
5176: ELSE

Line 5173: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ':set up problem ');

5169: ,p_org_code => p_org_code);
5170:
5171: IF NOT gme_common_pvt.g_setup_done THEN
5172: IF (g_debug = gme_debug.g_log_statement) THEN
5173: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ':set up problem ');
5174: END IF;
5175: RAISE fnd_api.g_exc_error;
5176: ELSE
5177: l_batch_header_rec.organization_id :=

Line 5182: IF g_debug <= gme_debug.g_log_statement THEN

5178: gme_common_pvt.g_organization_id;
5179: END IF;
5180: x_batch_header_rec := l_batch_header_rec ;
5181: x_material_detail_rec := l_material_detail_rec ;
5182: IF g_debug <= gme_debug.g_log_statement THEN
5183: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5184: 'exiting batch_header_id = ' || x_batch_header_rec.batch_id);
5185: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5186: 'exiting organization_id = ' || x_batch_header_rec.organization_id);

Line 5183: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||

5179: END IF;
5180: x_batch_header_rec := l_batch_header_rec ;
5181: x_material_detail_rec := l_material_detail_rec ;
5182: IF g_debug <= gme_debug.g_log_statement THEN
5183: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5184: 'exiting batch_header_id = ' || x_batch_header_rec.batch_id);
5185: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5186: 'exiting organization_id = ' || x_batch_header_rec.organization_id);
5187: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||

Line 5185: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||

5181: x_material_detail_rec := l_material_detail_rec ;
5182: IF g_debug <= gme_debug.g_log_statement THEN
5183: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5184: 'exiting batch_header_id = ' || x_batch_header_rec.batch_id);
5185: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5186: 'exiting organization_id = ' || x_batch_header_rec.organization_id);
5187: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5188: 'exiting mat det_id = ' || x_material_detail_rec.material_detail_id);
5189: END IF;

Line 5187: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||

5183: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5184: 'exiting batch_header_id = ' || x_batch_header_rec.batch_id);
5185: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5186: 'exiting organization_id = ' || x_batch_header_rec.organization_id);
5187: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5188: 'exiting mat det_id = ' || x_material_detail_rec.material_detail_id);
5189: END IF;
5190:
5191: EXCEPTION

Line 5197: IF g_debug <= gme_debug.g_log_unexpected THEN

5193: x_return_status := fnd_api.g_ret_sts_error;
5194: WHEN material_fetch_error THEN
5195: x_return_status := fnd_api.g_ret_sts_error;
5196: WHEN OTHERS THEN
5197: IF g_debug <= gme_debug.g_log_unexpected THEN
5198: gme_debug.put_line ( 'When others exception in '
5199: || g_pkg_name
5200: || '.'
5201: || l_api_name

Line 5198: gme_debug.put_line ( 'When others exception in '

5194: WHEN material_fetch_error THEN
5195: x_return_status := fnd_api.g_ret_sts_error;
5196: WHEN OTHERS THEN
5197: IF g_debug <= gme_debug.g_log_unexpected THEN
5198: gme_debug.put_line ( 'When others exception in '
5199: || g_pkg_name
5200: || '.'
5201: || l_api_name
5202: || ' Error is '

Line 5243: IF g_debug <= gme_debug.g_log_procedure THEN

5239: l_batch_header_rec gme_batch_header%ROWTYPE;
5240: l_batch_step_rec gme_batch_steps%ROWTYPE;
5241: step_header_fetch_error EXCEPTION;
5242: BEGIN
5243: IF g_debug <= gme_debug.g_log_procedure THEN
5244: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
5245: || l_api_name);
5246: END IF;
5247: x_return_status := fnd_api.g_ret_sts_success;

Line 5244: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

5240: l_batch_step_rec gme_batch_steps%ROWTYPE;
5241: step_header_fetch_error EXCEPTION;
5242: BEGIN
5243: IF g_debug <= gme_debug.g_log_procedure THEN
5244: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
5245: || l_api_name);
5246: END IF;
5247: x_return_status := fnd_api.g_ret_sts_success;
5248:

Line 5278: IF (g_debug = gme_debug.g_log_statement) THEN

5274: gme_common_pvt.setup (p_org_id => l_batch_header_rec.organization_id
5275: ,p_org_code => p_org_code);
5276:
5277: IF NOT gme_common_pvt.g_setup_done THEN
5278: IF (g_debug = gme_debug.g_log_statement) THEN
5279: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ':set up problem ');
5280: END IF;
5281: RAISE fnd_api.g_exc_error;
5282: ELSE

Line 5279: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ':set up problem ');

5275: ,p_org_code => p_org_code);
5276:
5277: IF NOT gme_common_pvt.g_setup_done THEN
5278: IF (g_debug = gme_debug.g_log_statement) THEN
5279: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ':set up problem ');
5280: END IF;
5281: RAISE fnd_api.g_exc_error;
5282: ELSE
5283: l_batch_header_rec.organization_id :=

Line 5288: IF g_debug <= gme_debug.g_log_statement THEN

5284: gme_common_pvt.g_organization_id;
5285: END IF;
5286: x_batch_header_rec := l_batch_header_rec ;
5287: x_batch_step_rec := l_batch_step_rec;
5288: IF g_debug <= gme_debug.g_log_statement THEN
5289: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5290: 'exiting batch_header_id = ' || x_batch_header_rec.batch_id);
5291: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5292: 'exiting organization_id = ' || x_batch_header_rec.organization_id);

Line 5289: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||

5285: END IF;
5286: x_batch_header_rec := l_batch_header_rec ;
5287: x_batch_step_rec := l_batch_step_rec;
5288: IF g_debug <= gme_debug.g_log_statement THEN
5289: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5290: 'exiting batch_header_id = ' || x_batch_header_rec.batch_id);
5291: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5292: 'exiting organization_id = ' || x_batch_header_rec.organization_id);
5293:

Line 5291: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||

5287: x_batch_step_rec := l_batch_step_rec;
5288: IF g_debug <= gme_debug.g_log_statement THEN
5289: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5290: 'exiting batch_header_id = ' || x_batch_header_rec.batch_id);
5291: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5292: 'exiting organization_id = ' || x_batch_header_rec.organization_id);
5293:
5294: END IF;
5295: IF g_debug <= gme_debug.g_log_statement THEN

Line 5295: IF g_debug <= gme_debug.g_log_statement THEN

5291: gme_debug.put_line ( g_pkg_name || '.' || l_api_name || ':' ||
5292: 'exiting organization_id = ' || x_batch_header_rec.organization_id);
5293:
5294: END IF;
5295: IF g_debug <= gme_debug.g_log_statement THEN
5296: gme_debug.put_line ( g_pkg_name
5297: || '.'
5298: || l_api_name
5299: || ' BatchStep ID: '

Line 5296: gme_debug.put_line ( g_pkg_name

5292: 'exiting organization_id = ' || x_batch_header_rec.organization_id);
5293:
5294: END IF;
5295: IF g_debug <= gme_debug.g_log_statement THEN
5296: gme_debug.put_line ( g_pkg_name
5297: || '.'
5298: || l_api_name
5299: || ' BatchStep ID: '
5300: || x_batch_step_rec.batchstep_id);

Line 5308: IF g_debug <= gme_debug.g_log_unexpected THEN

5304: x_return_status := fnd_api.g_ret_sts_error;
5305: WHEN Step_header_fetch_error THEN
5306: x_return_status := fnd_api.g_ret_sts_error;
5307: WHEN OTHERS THEN
5308: IF g_debug <= gme_debug.g_log_unexpected THEN
5309: gme_debug.put_line ( 'When others exception in '
5310: || g_pkg_name
5311: || '.'
5312: || l_api_name

Line 5309: gme_debug.put_line ( 'When others exception in '

5305: WHEN Step_header_fetch_error THEN
5306: x_return_status := fnd_api.g_ret_sts_error;
5307: WHEN OTHERS THEN
5308: IF g_debug <= gme_debug.g_log_unexpected THEN
5309: gme_debug.put_line ( 'When others exception in '
5310: || g_pkg_name
5311: || '.'
5312: || l_api_name
5313: || ' Error is '

Line 5364: IF g_debug <= gme_debug.g_log_procedure THEN

5360: SELECT actual_start_date, actual_cmplt_date
5361: FROM gme_batch_steps
5362: WHERE batchstep_id = v_batchstep_id;
5363: BEGIN
5364: IF g_debug <= gme_debug.g_log_procedure THEN
5365: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
5366: END IF;
5367:
5368: /* initializing the return status*/

Line 5365: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);

5361: FROM gme_batch_steps
5362: WHERE batchstep_id = v_batchstep_id;
5363: BEGIN
5364: IF g_debug <= gme_debug.g_log_procedure THEN
5365: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
5366: END IF;
5367:
5368: /* initializing the return status*/
5369: x_return_status := fnd_api.g_ret_sts_success;

Line 5375: IF g_debug <= gme_debug.g_log_statement THEN

5371: /* fetch the material detail record */
5372: l_material_detail_rec.material_detail_id := p_material_detail_id;
5373:
5374: IF NOT (gme_material_details_dbl.fetch_row(l_material_detail_rec, l_material_detail_rec)) THEN
5375: IF g_debug <= gme_debug.g_log_statement THEN
5376: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'||'Error in Fetching the material detail record');
5377: END IF;
5378: RAISE error_fetch_material;
5379: END IF;

Line 5376: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'||'Error in Fetching the material detail record');

5372: l_material_detail_rec.material_detail_id := p_material_detail_id;
5373:
5374: IF NOT (gme_material_details_dbl.fetch_row(l_material_detail_rec, l_material_detail_rec)) THEN
5375: IF g_debug <= gme_debug.g_log_statement THEN
5376: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'||'Error in Fetching the material detail record');
5377: END IF;
5378: RAISE error_fetch_material;
5379: END IF;
5380:

Line 5384: IF g_debug <= gme_debug.g_log_statement THEN

5380:
5381: /*fetch the batch details*/
5382: l_batch_header_rec.batch_id := l_material_detail_rec.batch_id;
5383: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_header_rec, l_batch_header_rec)) THEN
5384: IF g_debug <= gme_debug.g_log_statement THEN
5385: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'||'Error in Fetching the Batch Details');
5386: END IF;
5387: RAISE error_fetch_batch_details;
5388: END IF;

Line 5385: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'||'Error in Fetching the Batch Details');

5381: /*fetch the batch details*/
5382: l_batch_header_rec.batch_id := l_material_detail_rec.batch_id;
5383: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_header_rec, l_batch_header_rec)) THEN
5384: IF g_debug <= gme_debug.g_log_statement THEN
5385: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'||'Error in Fetching the Batch Details');
5386: END IF;
5387: RAISE error_fetch_batch_details;
5388: END IF;
5389:

Line 5439: IF g_debug <= gme_debug.g_log_procedure THEN

5435: END IF;
5436:
5437: x_trans_date := NVL(l_trans_date,SYSDATE);
5438:
5439: IF g_debug <= gme_debug.g_log_procedure THEN
5440: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
5441: END IF;
5442: EXCEPTION
5443: WHEN error_fetch_material OR error_fetch_batch_details THEN

Line 5440: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

5436:
5437: x_trans_date := NVL(l_trans_date,SYSDATE);
5438:
5439: IF g_debug <= gme_debug.g_log_procedure THEN
5440: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
5441: END IF;
5442: EXCEPTION
5443: WHEN error_fetch_material OR error_fetch_batch_details THEN
5444: x_return_status := fnd_api.g_ret_sts_error;

Line 5446: IF g_debug <= gme_debug.g_log_unexpected THEN

5442: EXCEPTION
5443: WHEN error_fetch_material OR error_fetch_batch_details THEN
5444: x_return_status := fnd_api.g_ret_sts_error;
5445: WHEN OTHERS THEN
5446: IF g_debug <= gme_debug.g_log_unexpected THEN
5447: gme_debug.put_line ( 'When others exception in '
5448: || g_pkg_name
5449: || '.'
5450: || l_api_name

Line 5447: gme_debug.put_line ( 'When others exception in '

5443: WHEN error_fetch_material OR error_fetch_batch_details THEN
5444: x_return_status := fnd_api.g_ret_sts_error;
5445: WHEN OTHERS THEN
5446: IF g_debug <= gme_debug.g_log_unexpected THEN
5447: gme_debug.put_line ( 'When others exception in '
5448: || g_pkg_name
5449: || '.'
5450: || l_api_name
5451: || ' Error is '