APPS.WSH_OPM_CONV_MIG_PKG dependencies on GMI_RESERVATION_UTIL

Line 84: GMI_RESERVATION_UTIL.println('NNNNn In transaction loop');

80: l_opm_table_name := 'IC_TRAN_PND';
81:
82: /* Get all the transaction record related to OM lines to be processed */
83: FOR opm_trans_rec IN get_opm_trans LOOP
84: GMI_RESERVATION_UTIL.println('NNNNn In transaction loop');
85:
86: BEGIN
87: l_so_line_id := opm_trans_rec.line_id;
88: l_wdd_id := opm_trans_rec.line_detail_id;

Line 89: GMI_RESERVATION_UTIL.println('ic_tran_pnd wdd id , so_line_id'||'l_wdd_id:'||l_so_line_id);

85:
86: BEGIN
87: l_so_line_id := opm_trans_rec.line_id;
88: l_wdd_id := opm_trans_rec.line_detail_id;
89: GMI_RESERVATION_UTIL.println('ic_tran_pnd wdd id , so_line_id'||'l_wdd_id:'||l_so_line_id);
90: /* get the new convention for lot_Number in R12 */
91: INV_OPM_LOT_MIGRATION.get_ODM_lot
92: ( p_migration_run_id => p_migration_run_id
93: , p_item_id => opm_trans_rec.item_id

Line 104: GMI_RESERVATION_UTIL.println('ODM lot_number'||l_odm_lot_number);

100: , x_parent_lot_number => l_parent_lot_number
101: , x_failure_count => x_failure_count
102: );
103:
104: GMI_RESERVATION_UTIL.println('ODM lot_number'||l_odm_lot_number);
105: GMI_RESERVATION_UTIL.println('ODM parent lot number '||l_parent_lot_number);
106: /* update wdd with the new lot_number */
107: /* if the API get_odm_lot can not get the odm lot number, these wdds would not be updated */
108: if (l_odm_lot_number is not null) and nvl(l_wdd_id, 0) <> 0 then

Line 105: GMI_RESERVATION_UTIL.println('ODM parent lot number '||l_parent_lot_number);

101: , x_failure_count => x_failure_count
102: );
103:
104: GMI_RESERVATION_UTIL.println('ODM lot_number'||l_odm_lot_number);
105: GMI_RESERVATION_UTIL.println('ODM parent lot number '||l_parent_lot_number);
106: /* update wdd with the new lot_number */
107: /* if the API get_odm_lot can not get the odm lot number, these wdds would not be updated */
108: if (l_odm_lot_number is not null) and nvl(l_wdd_id, 0) <> 0 then
109: Update wsh_delivery_details

Line 115: GMI_RESERVATION_UTIL.println('update wdd successful id '||l_wdd_id);

111: where delivery_detail_id = l_wdd_id
112: and lot_number is not null
113: ;
114: l_success_count := l_success_count + 1;
115: GMI_RESERVATION_UTIL.println('update wdd successful id '||l_wdd_id);
116: end if;
117:
118: EXCEPTION
119: WHEN OTHERS THEN