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

APPS.JMF_SHIKYU_RECONCILIAITON_PVT dependencies on FND_LOG

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

110: -- reduce allocations for the decreased qty
111:
112: IF (g_fnd_debug = 'Y')
113: THEN
114: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
115: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
116: , G_MODULE_PREFIX ||
117: 'Process_Quantity_Changes.Invoked'
118: , 'Entry');

Line 115: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

111:
112: IF (g_fnd_debug = 'Y')
113: THEN
114: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
115: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
116: , G_MODULE_PREFIX ||
117: 'Process_Quantity_Changes.Invoked'
118: , 'Entry');
119: END IF;

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

118: , 'Entry');
119: END IF;
120: END IF;
121:
122: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
123: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
124: , G_MODULE_PREFIX ||
125: 'p_SUBCONTRACT_PO_SHIPMENT_ID => '
126: , p_SUBCONTRACT_PO_SHIPMENT_ID);

Line 123: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

119: END IF;
120: END IF;
121:
122: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
123: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
124: , G_MODULE_PREFIX ||
125: 'p_SUBCONTRACT_PO_SHIPMENT_ID => '
126: , p_SUBCONTRACT_PO_SHIPMENT_ID);
127: END IF;

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

124: , G_MODULE_PREFIX ||
125: 'p_SUBCONTRACT_PO_SHIPMENT_ID => '
126: , p_SUBCONTRACT_PO_SHIPMENT_ID);
127: END IF;
128: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
129: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
130: , G_MODULE_PREFIX ||
131: 'p_old_ordered_quantity => '
132: , p_old_ordered_quantity );

Line 129: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

125: 'p_SUBCONTRACT_PO_SHIPMENT_ID => '
126: , p_SUBCONTRACT_PO_SHIPMENT_ID);
127: END IF;
128: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
129: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
130: , G_MODULE_PREFIX ||
131: 'p_old_ordered_quantity => '
132: , p_old_ordered_quantity );
133: END IF;

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

130: , G_MODULE_PREFIX ||
131: 'p_old_ordered_quantity => '
132: , p_old_ordered_quantity );
133: END IF;
134: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
135: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
136: , G_MODULE_PREFIX ||
137: 'p_new_ordered_quantity => '
138: , p_new_ordered_quantity);

Line 135: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

131: 'p_old_ordered_quantity => '
132: , p_old_ordered_quantity );
133: END IF;
134: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
135: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
136: , G_MODULE_PREFIX ||
137: 'p_new_ordered_quantity => '
138: , p_new_ordered_quantity);
139: END IF;

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

143: l_allocation_date := NULL;
144: l_allocation_date := JMF_SHIKYU_UTIL.GET_allocation_date
145: ( p_wip_entity_id => p_wip_entity_id );
146: --dbms_output.put_line(' l_allocation_date => '|| l_allocation_date );
147: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
148: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
149: , G_MODULE_PREFIX ||
150: 'l_allocation_date => '
151: , l_allocation_date);

Line 148: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

144: l_allocation_date := JMF_SHIKYU_UTIL.GET_allocation_date
145: ( p_wip_entity_id => p_wip_entity_id );
146: --dbms_output.put_line(' l_allocation_date => '|| l_allocation_date );
147: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
148: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
149: , G_MODULE_PREFIX ||
150: 'l_allocation_date => '
151: , l_allocation_date);
152: END IF;

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

153:
154: FOR C_shikyu_components_rec IN C_shikyu_components_CSR
155: LOOP
156:
157: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
159: , G_MODULE_PREFIX ||
160: 'rajesh Component ID => '
161: , C_shikyu_components_rec.shikyu_component_id);

Line 158: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

154: FOR C_shikyu_components_rec IN C_shikyu_components_CSR
155: LOOP
156:
157: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
159: , G_MODULE_PREFIX ||
160: 'rajesh Component ID => '
161: , C_shikyu_components_rec.shikyu_component_id);
162: END IF;

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

168: C_shikyu_components_rec.shikyu_component_id
169: , p_SUBCONTRACT_PO_SHIPMENT_ID => p_SUBCONTRACT_PO_SHIPMENT_ID );
170:
171: --dbms_output.put_line(' l_component_new_quantity => '|| l_component_new_quantity);
172: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
173: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
174: , G_MODULE_PREFIX ||
175: 'l_component_new_quantity => '
176: , l_component_new_quantity);

Line 173: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

169: , p_SUBCONTRACT_PO_SHIPMENT_ID => p_SUBCONTRACT_PO_SHIPMENT_ID );
170:
171: --dbms_output.put_line(' l_component_new_quantity => '|| l_component_new_quantity);
172: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
173: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
174: , G_MODULE_PREFIX ||
175: 'l_component_new_quantity => '
176: , l_component_new_quantity);
177: END IF;

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

185: /*dbms_output.put_line(' l_current_allocated_quantity => '||
186: l_current_allocated_quantity );
187: dbms_output.put_line(' l_component_new_quantity => '||
188: l_component_new_quantity);*/
189: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
190: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
191: , G_MODULE_PREFIX ||
192: 'l_current_allocated_quantity => '
193: , l_current_allocated_quantity);

Line 190: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

186: l_current_allocated_quantity );
187: dbms_output.put_line(' l_component_new_quantity => '||
188: l_component_new_quantity);*/
189: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
190: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
191: , G_MODULE_PREFIX ||
192: 'l_current_allocated_quantity => '
193: , l_current_allocated_quantity);
194: END IF;

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

196:
197: IF l_component_new_quantity > l_current_allocated_quantity
198: THEN
199: --dbms_output.put_line(' Cazll JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations');
200: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
201: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
202: , G_MODULE_PREFIX ||
203: 'Calling JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations SCO '
204: , p_SUBCONTRACT_PO_SHIPMENT_ID );

Line 201: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

197: IF l_component_new_quantity > l_current_allocated_quantity
198: THEN
199: --dbms_output.put_line(' Cazll JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations');
200: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
201: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
202: , G_MODULE_PREFIX ||
203: 'Calling JMF_SHIKYU_ALLOCATION_PVT.Create_New_Allocations SCO '
204: , p_SUBCONTRACT_PO_SHIPMENT_ID );
205: END IF;

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

224:
225: ELSIF l_component_new_quantity < l_current_allocated_quantity
226: THEN
227: --dbms_output.put_line(' Call JMF_SHIKYU_ALLOCATION_PVT.Reduce_Allocations ');
228: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
229: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
230: , G_MODULE_PREFIX ||
231: 'Calling JMF_SHIKYU_ALLOCATION_PVT.Reduce_Allocations '
232: , p_SUBCONTRACT_PO_SHIPMENT_ID );

Line 229: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

225: ELSIF l_component_new_quantity < l_current_allocated_quantity
226: THEN
227: --dbms_output.put_line(' Call JMF_SHIKYU_ALLOCATION_PVT.Reduce_Allocations ');
228: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
229: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
230: , G_MODULE_PREFIX ||
231: 'Calling JMF_SHIKYU_ALLOCATION_PVT.Reduce_Allocations '
232: , p_SUBCONTRACT_PO_SHIPMENT_ID );
233: END IF;

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

261: --dbms_output.put_line(' OUT OF Loop ');
262:
263: IF (g_fnd_debug = 'Y')
264: THEN
265: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
266: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
267: , G_MODULE_PREFIX ||
268: 'Process_Quantity_Changes. OUT'
269: , 'Entry');

Line 266: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

262:
263: IF (g_fnd_debug = 'Y')
264: THEN
265: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
266: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
267: , G_MODULE_PREFIX ||
268: 'Process_Quantity_Changes. OUT'
269: , 'Entry');
270: END IF;

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

383: AND pol.po_line_id = l_repl_po_line_id ;
384:
385: BEGIN
386:
387: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
389: , G_MODULE_PREFIX ||
390: 'INTO update_replenishment_date FOR SCO PO SHIPID: '
391: , p_subcontract_po_shipment_id);

Line 388: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

384:
385: BEGIN
386:
387: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
389: , G_MODULE_PREFIX ||
390: 'INTO update_replenishment_date FOR SCO PO SHIPID: '
391: , p_subcontract_po_shipment_id);
392: END IF;

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

390: 'INTO update_replenishment_date FOR SCO PO SHIPID: '
391: , p_subcontract_po_shipment_id);
392: END IF;
393:
394: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
395: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
396: , G_MODULE_PREFIX ||
397: 'p_new_ship_date => '
398: , p_new_ship_date);

Line 395: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

391: , p_subcontract_po_shipment_id);
392: END IF;
393:
394: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
395: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
396: , G_MODULE_PREFIX ||
397: 'p_new_ship_date => '
398: , p_new_ship_date);
399: END IF;

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

396: , G_MODULE_PREFIX ||
397: 'p_new_ship_date => '
398: , p_new_ship_date);
399: END IF;
400: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
401: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
402: , G_MODULE_PREFIX ||
403: 'p_allocation_date => '
404: , p_allocation_date );

Line 401: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

397: 'p_new_ship_date => '
398: , p_new_ship_date);
399: END IF;
400: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
401: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
402: , G_MODULE_PREFIX ||
403: 'p_allocation_date => '
404: , p_allocation_date );
405: END IF;

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

407:
408:
409: FOR C_select_replenishments_REC IN C_select_replenishments_CSR
410: LOOP
411: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
412: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
413: , G_MODULE_PREFIX ||
414: 'Start OM rescheduling : REPLENISHMENT_SO_LINE_ID '
415: , C_select_replenishments_REC.REPLENISHMENT_SO_LINE_ID);

Line 412: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

408:
409: FOR C_select_replenishments_REC IN C_select_replenishments_CSR
410: LOOP
411: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
412: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
413: , G_MODULE_PREFIX ||
414: 'Start OM rescheduling : REPLENISHMENT_SO_LINE_ID '
415: , C_select_replenishments_REC.REPLENISHMENT_SO_LINE_ID);
416: END IF;

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

428:
429: l_line_tbl(1) := l_line_rec;
430:
431: oe_debug_pub.add('Before Process_Order',1);
432: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
433: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
434: , G_MODULE_PREFIX ||
435: 'OE_Order_PVT.Process_order re-scheduling '
436: , 'calling ');

Line 433: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

429: l_line_tbl(1) := l_line_rec;
430:
431: oe_debug_pub.add('Before Process_Order',1);
432: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
433: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
434: , G_MODULE_PREFIX ||
435: 'OE_Order_PVT.Process_order re-scheduling '
436: , 'calling ');
437: END IF;

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

465: );
466:
467:
468:
469: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
470: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
471: , G_MODULE_PREFIX ||
472: 'OE_Order_PVT.Process_order re-scheduling '
473: , 'out ');

Line 470: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

466:
467:
468:
469: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
470: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
471: , G_MODULE_PREFIX ||
472: 'OE_Order_PVT.Process_order re-scheduling '
473: , 'out ');
474: END IF;

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

472: 'OE_Order_PVT.Process_order re-scheduling '
473: , 'out ');
474: END IF;
475:
476: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
477: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
478: , G_MODULE_PREFIX ||
479: 'l_return_status => '|| l_return_status
480: , l_return_status);

Line 477: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

473: , 'out ');
474: END IF;
475:
476: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
477: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
478: , G_MODULE_PREFIX ||
479: 'l_return_status => '|| l_return_status
480: , l_return_status);
481: END IF;

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

480: , l_return_status);
481: END IF;
482:
483: ------ end OM -----------
484: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
485: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
486: , G_MODULE_PREFIX ||
487: 'END OM rescheduling : REPLENISHMENT_SO_LINE_ID '
488: , C_select_replenishments_REC.REPLENISHMENT_SO_LINE_ID);

Line 485: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

481: END IF;
482:
483: ------ end OM -----------
484: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
485: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
486: , G_MODULE_PREFIX ||
487: 'END OM rescheduling : REPLENISHMENT_SO_LINE_ID '
488: , C_select_replenishments_REC.REPLENISHMENT_SO_LINE_ID);
489: END IF;

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

490:
491: --------------------------------------------------------
492: ------------------- PO RESCHEDULING --------------------
493:
494: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
495: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
496: , G_MODULE_PREFIX ||
497: 'rajesh START PO RESCHEDULING '
498: , C_select_replenishments_REC.REPLENISHMENT_PO_SHIPMENT_ID);

Line 495: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

491: --------------------------------------------------------
492: ------------------- PO RESCHEDULING --------------------
493:
494: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
495: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
496: , G_MODULE_PREFIX ||
497: 'rajesh START PO RESCHEDULING '
498: , C_select_replenishments_REC.REPLENISHMENT_PO_SHIPMENT_ID);
499: END IF;

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

508: C_select_replenishments_REC.replenishment_po_header_id ;
509: l_repl_po_shipment_id :=
510: C_select_replenishments_REC.replenishment_po_shipment_id ;
511:
512: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
513: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
514: , G_MODULE_PREFIX ||
515: 'l_repl_po_header_id => '
516: , l_repl_po_header_id);

Line 513: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

509: l_repl_po_shipment_id :=
510: C_select_replenishments_REC.replenishment_po_shipment_id ;
511:
512: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
513: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
514: , G_MODULE_PREFIX ||
515: 'l_repl_po_header_id => '
516: , l_repl_po_header_id);
517:

Line 518: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

514: , G_MODULE_PREFIX ||
515: 'l_repl_po_header_id => '
516: , l_repl_po_header_id);
517:
518: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
519: , G_MODULE_PREFIX ||
520: 'l_repl_po_line_id => '
521: , l_repl_po_line_id);
522:

Line 523: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

519: , G_MODULE_PREFIX ||
520: 'l_repl_po_line_id => '
521: , l_repl_po_line_id);
522:
523: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
524: , G_MODULE_PREFIX ||
525: 'l_repl_po_shipment_id => '
526: , l_repl_po_shipment_id);
527: END IF;

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

527: END IF;
528:
529: FOR C_PO_details_REC IN C_PO_details_CSR
530: LOOP
531: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
532: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
533: , G_MODULE_PREFIX ||
534: 'rajesh Into PO Loop for segment1 => '
535: , C_PO_details_REC.segment1);

Line 532: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

528:
529: FOR C_PO_details_REC IN C_PO_details_CSR
530: LOOP
531: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
532: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
533: , G_MODULE_PREFIX ||
534: 'rajesh Into PO Loop for segment1 => '
535: , C_PO_details_REC.segment1);
536:

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

536:
537: END IF;
538: BEGIN
539:
540: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
541: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
542: , G_MODULE_PREFIX ||
543: 'Calling PO_CHANGE_API1_S for : '
544: , C_PO_details_REC.segment1 );

Line 541: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

537: END IF;
538: BEGIN
539:
540: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
541: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
542: , G_MODULE_PREFIX ||
543: 'Calling PO_CHANGE_API1_S for : '
544: , C_PO_details_REC.segment1 );
545: END IF;

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

573: , p_preferred_grade => null
574: --
575: ) ;
576:
577: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
578: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
579: , G_MODULE_PREFIX ||
580: 'After PO reschedule l_return_number => ' || l_return_number
581: , l_return_number);

Line 578: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

574: --
575: ) ;
576:
577: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
578: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
579: , G_MODULE_PREFIX ||
580: 'After PO reschedule l_return_number => ' || l_return_number
581: , l_return_number);
582: END IF;

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

584:
585:
586: END LOOP ; --PO loop
587:
588: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
589: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
590: , G_MODULE_PREFIX ||
591: 'Out of PO loop '
592: , 'rajesh ');

Line 589: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

585:
586: END LOOP ; --PO loop
587:
588: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
589: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
590: , G_MODULE_PREFIX ||
591: 'Out of PO loop '
592: , 'rajesh ');
593: END IF;

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

594:
595:
596: END LOOP ; -- main repl loop
597:
598: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
599: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
600: , G_MODULE_PREFIX ||
601: 'OUT OF main loop '
602: , 'rajesh');

Line 599: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

595:
596: END LOOP ; -- main repl loop
597:
598: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
599: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
600: , G_MODULE_PREFIX ||
601: 'OUT OF main loop '
602: , 'rajesh');
603: END IF;

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

602: , 'rajesh');
603: END IF;
604:
605:
606: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
607: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
608: , G_MODULE_PREFIX ||
609: 'completed update_replenishment_date'
610: , 'EXit');

Line 607: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

603: END IF;
604:
605:
606: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
607: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
608: , G_MODULE_PREFIX ||
609: 'completed update_replenishment_date'
610: , 'EXit');
611: END IF;

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

628: l_release_status VARCHAR2(3) ;
629:
630: BEGIN
631:
632: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
633: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
634: , G_MODULE_PREFIX ||
635: 'check_pick_released '
636: , 'ENTRY');

Line 633: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

629:
630: BEGIN
631:
632: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
633: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
634: , G_MODULE_PREFIX ||
635: 'check_pick_released '
636: , 'ENTRY');
637: END IF;

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

651: AND NVL(released_status,'R') = 'Y' ;
652:
653: l_released := 'Y' ;
654:
655: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
656: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
657: , 'JMFVSKRB: l_id : l_release_status : l_released = '
658: , l_id || l_release_status || l_released );
659: END IF;

Line 656: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

652:
653: l_released := 'Y' ;
654:
655: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
656: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
657: , 'JMFVSKRB: l_id : l_release_status : l_released = '
658: , l_id || l_release_status || l_released );
659: END IF;
660:

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

673:
674: RETURN l_released ;
675:
676:
677: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
678: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
679: , G_MODULE_PREFIX ||
680: 'check_pick_released '
681: , 'OUT ');

Line 678: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

674: RETURN l_released ;
675:
676:
677: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
678: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
679: , G_MODULE_PREFIX ||
680: 'check_pick_released '
681: , 'OUT ');
682: END IF;

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

709: l_pick_release VARCHAR2(1) := 'N' ;
710:
711: BEGIN
712:
713: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
714: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
715: , G_MODULE_PREFIX ||
716: 'into check_repl_retain'
717: , 'Entry');

Line 714: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

710:
711: BEGIN
712:
713: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
714: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
715: , G_MODULE_PREFIX ||
716: 'into check_repl_retain'
717: , 'Entry');
718: END IF;

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

716: 'into check_repl_retain'
717: , 'Entry');
718: END IF;
719:
720: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
721: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
722: , 'JMFVSKRB : p_replen_so_line_id => '
723: , p_replen_so_line_id);
724: END IF;

Line 721: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

717: , 'Entry');
718: END IF;
719:
720: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
721: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
722: , 'JMFVSKRB : p_replen_so_line_id => '
723: , p_replen_so_line_id);
724: END IF;
725: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

721: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
722: , 'JMFVSKRB : p_replen_so_line_id => '
723: , p_replen_so_line_id);
724: END IF;
725: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
726: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
727: , 'JMFVSKRB: p_replen_so_header_id => '
728: , p_replen_so_header_id );
729: END IF;

Line 726: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

722: , 'JMFVSKRB : p_replen_so_line_id => '
723: , p_replen_so_line_id);
724: END IF;
725: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
726: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
727: , 'JMFVSKRB: p_replen_so_header_id => '
728: , p_replen_so_header_id );
729: END IF;
730:

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

729: END IF;
730:
731: l_check := NULL ;
732:
733: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
734: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
735: , G_MODULE_PREFIX ||
736: 'shipped : invcd: ship_intf:cncl : '||
737: p_shipped_quantity || p_invoiced_quantity || p_shipping_interfaced_flag || p_cancelled_flag

Line 734: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

730:
731: l_check := NULL ;
732:
733: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
734: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
735: , G_MODULE_PREFIX ||
736: 'shipped : invcd: ship_intf:cncl : '||
737: p_shipped_quantity || p_invoiced_quantity || p_shipping_interfaced_flag || p_cancelled_flag
738: , 'rajesh');

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

742: NVL( p_shipped_quantity,0) <> 0 OR
743: NVL( p_invoiced_quantity,0) <> 0 OR
744: NVL( p_cancelled_flag,'N') = 'Y'
745: THEN
746: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
747: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
748: , G_MODULE_PREFIX ||
749: 'One of the flag issue '
750: , 'INTO IF ');

Line 747: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

743: NVL( p_invoiced_quantity,0) <> 0 OR
744: NVL( p_cancelled_flag,'N') = 'Y'
745: THEN
746: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
747: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
748: , G_MODULE_PREFIX ||
749: 'One of the flag issue '
750: , 'INTO IF ');
751: END IF;

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

758: ( p_header_id => p_replen_so_header_id
759: , p_line_id => p_replen_so_line_id
760: ) ;
761:
762: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
763: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
764: , 'JMFVSKRB: AFter check_pick_released => '
765: , l_pick_release );
766: END IF;

Line 763: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

759: , p_line_id => p_replen_so_line_id
760: ) ;
761:
762: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
763: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
764: , 'JMFVSKRB: AFter check_pick_released => '
765: , l_pick_release );
766: END IF;
767:

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

771: END IF;
772:
773: ELSE
774: l_check := NULL ;
775: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
776: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
777: , G_MODULE_PREFIX ||
778: 'Into other check as REPL SO is open '
779: , l_check);

Line 776: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

772:
773: ELSE
774: l_check := NULL ;
775: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
776: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
777: , G_MODULE_PREFIX ||
778: 'Into other check as REPL SO is open '
779: , l_check);
780: END IF;

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

786: FROM jmf_shikyu_replenishments
787: WHERE REPLENISHMENT_SO_LINE_ID = p_replen_so_line_id
788: AND REPLENISHMENT_SO_HEADER_ID = p_replen_so_header_id ;
789:
790: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
791: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
792: , G_MODULE_PREFIX ||
793: 'l_REPLENISHMENT_PO_LINE_ID => '
794: , l_REPLENISHMENT_PO_LINE_ID);

Line 791: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

787: WHERE REPLENISHMENT_SO_LINE_ID = p_replen_so_line_id
788: AND REPLENISHMENT_SO_HEADER_ID = p_replen_so_header_id ;
789:
790: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
791: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
792: , G_MODULE_PREFIX ||
793: 'l_REPLENISHMENT_PO_LINE_ID => '
794: , l_REPLENISHMENT_PO_LINE_ID);
795: END IF;

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

804: WHEN TOO_MANY_ROWS THEN
805: l_REPLENISHMENT_PO_LINE_ID := NULL ;
806: l_check := 'N' ;
807:
808: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
809: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
810: , G_MODULE_PREFIX ||
811: 'Too many repl PO attached '
812: , l_check);

Line 809: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

805: l_REPLENISHMENT_PO_LINE_ID := NULL ;
806: l_check := 'N' ;
807:
808: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
809: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
810: , G_MODULE_PREFIX ||
811: 'Too many repl PO attached '
812: , l_check);
813: END IF;

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

813: END IF;
814:
815: END ;
816:
817: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
818: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
819: , G_MODULE_PREFIX ||
820: 'before sco check l_check => '|| l_check
821: , l_check);

Line 818: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

814:
815: END ;
816:
817: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
818: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
819: , G_MODULE_PREFIX ||
820: 'before sco check l_check => '|| l_check
821: , l_check);
822: END IF;

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

837: WHEN NO_DATA_FOUND THEN
838: L_SUBCONTRACT_PO_SHIPMENT_ID := NULL ;
839: l_check := 'Y' ;
840:
841: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
842: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
843: , G_MODULE_PREFIX ||
844: 'only one SCO attached l_check => '
845: , l_check);

Line 842: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

838: L_SUBCONTRACT_PO_SHIPMENT_ID := NULL ;
839: l_check := 'Y' ;
840:
841: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
842: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
843: , G_MODULE_PREFIX ||
844: 'only one SCO attached l_check => '
845: , l_check);
846: END IF;

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

854:
855: END IF ;
856:
857:
858: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
859: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
860: , G_MODULE_PREFIX ||
861: 'check_repl_retain l_check => '|| l_check
862: , 'About to return ');

Line 859: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

855: END IF ;
856:
857:
858: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
859: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
860: , G_MODULE_PREFIX ||
861: 'check_repl_retain l_check => '|| l_check
862: , 'About to return ');
863: END IF;

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

992: p_puchasing_UOM ); */
993:
994: IF (g_fnd_debug = 'Y')
995: THEN
996: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
997: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
998: , G_MODULE_PREFIX || l_api_name
999: , 'Entry');
1000: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 997: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

993:
994: IF (g_fnd_debug = 'Y')
995: THEN
996: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
997: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
998: , G_MODULE_PREFIX || l_api_name
999: , 'Entry');
1000: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1001: , G_MODULE_PREFIX || l_api_name

Line 1000: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

996: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
997: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
998: , G_MODULE_PREFIX || l_api_name
999: , 'Entry');
1000: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1001: , G_MODULE_PREFIX || l_api_name
1002: , 'p_old_need_by_date SCO => '|| p_old_need_by_date);
1003: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1004: , G_MODULE_PREFIX || l_api_name

Line 1003: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

999: , 'Entry');
1000: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1001: , G_MODULE_PREFIX || l_api_name
1002: , 'p_old_need_by_date SCO => '|| p_old_need_by_date);
1003: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1004: , G_MODULE_PREFIX || l_api_name
1005: , 'p_new_need_by_date SCO => '|| p_new_need_by_date);
1006: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1007: , G_MODULE_PREFIX || l_api_name

Line 1006: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1002: , 'p_old_need_by_date SCO => '|| p_old_need_by_date);
1003: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1004: , G_MODULE_PREFIX || l_api_name
1005: , 'p_new_need_by_date SCO => '|| p_new_need_by_date);
1006: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1007: , G_MODULE_PREFIX || l_api_name
1008: , 'p_SUBCONTRACT_PO_SHIPMENT_ID => '|| p_SUBCONTRACT_PO_SHIPMENT_ID);
1009: END IF;
1010: END IF;

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

1032:
1033:
1034: --dbms_output.put_line(' l_allocation_date => '|| l_allocation_date );
1035: -- rajesh main loop
1036: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1037: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1038: , G_MODULE_PREFIX || l_api_name
1039: , 'l_allocation_date => ' || l_allocation_date);
1040: END IF;

Line 1037: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1033:
1034: --dbms_output.put_line(' l_allocation_date => '|| l_allocation_date );
1035: -- rajesh main loop
1036: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1037: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1038: , G_MODULE_PREFIX || l_api_name
1039: , 'l_allocation_date => ' || l_allocation_date);
1040: END IF;
1041:

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

1042: FOR C_SHIKYU_components_rec IN C_SHIKYU_components_CSR
1043: LOOP
1044: l_shikyu_component_id := C_SHIKYU_components_rec.SHIKYU_component_id ;
1045:
1046: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1047: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1048: , G_MODULE_PREFIX || l_api_name
1049: , 'l_shikyu_component_id => '|| l_shikyu_component_id);
1050: END IF;

Line 1047: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1043: LOOP
1044: l_shikyu_component_id := C_SHIKYU_components_rec.SHIKYU_component_id ;
1045:
1046: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1047: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1048: , G_MODULE_PREFIX || l_api_name
1049: , 'l_shikyu_component_id => '|| l_shikyu_component_id);
1050: END IF;
1051:

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

1053:
1054: FOR C_NEED_BY_DATE_rec IN C_NEED_BY_DATE_CSR
1055: LOOP
1056:
1057: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1058: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1059: , G_MODULE_PREFIX || l_api_name
1060: , 'RSO_line_id:' || C_NEED_BY_DATE_REC.replenishment_so_line_id ||
1061: ':RSO_sched_ship_date:' || C_NEED_BY_DATE_REC.schedule_ship_date ||

Line 1058: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1054: FOR C_NEED_BY_DATE_rec IN C_NEED_BY_DATE_CSR
1055: LOOP
1056:
1057: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1058: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1059: , G_MODULE_PREFIX || l_api_name
1060: , 'RSO_line_id:' || C_NEED_BY_DATE_REC.replenishment_so_line_id ||
1061: ':RSO_sched_ship_date:' || C_NEED_BY_DATE_REC.schedule_ship_date ||
1062: ':RSO_actual_ship_date:' || C_NEED_BY_DATE_REC.actual_shipment_date);

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

1073: , p_scheduled_ship_date => nvl(C_NEED_BY_DATE_rec.actual_shipment_date,
1074: C_NEED_BY_DATE_rec.schedule_ship_date)
1075: );
1076:
1077: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1078: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1079: , G_MODULE_PREFIX || l_api_name
1080: , 'l_final_ship_date => '|| l_final_ship_date);
1081: END IF;

Line 1078: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1074: C_NEED_BY_DATE_rec.schedule_ship_date)
1075: );
1076:
1077: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1078: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1079: , G_MODULE_PREFIX || l_api_name
1080: , 'l_final_ship_date => '|| l_final_ship_date);
1081: END IF;
1082:

Line 1094: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1090: -- Rajesh: reschedule
1091:
1092: l_retain := NULL ;
1093:
1094: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1095: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1096: , G_MODULE_PREFIX || l_api_name
1097: , 'Existing repl will not arrive on time:: SO LINE ID:' ||
1098: C_NEED_BY_DATE_rec.REPLENISHMENT_SO_LINE_ID );

Line 1095: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1091:
1092: l_retain := NULL ;
1093:
1094: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1095: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1096: , G_MODULE_PREFIX || l_api_name
1097: , 'Existing repl will not arrive on time:: SO LINE ID:' ||
1098: C_NEED_BY_DATE_rec.REPLENISHMENT_SO_LINE_ID );
1099: END IF;

Line 1115: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1111: , p_shipping_interfaced_flag => C_NEED_BY_DATE_rec.shipping_interfaced_flag
1112: , p_cancelled_flag => C_NEED_BY_DATE_rec.cancelled_flag
1113: );
1114:
1115: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1116: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1117: , G_MODULE_PREFIX || l_api_name
1118: , 'l_retain => ' || l_retain );
1119: END IF;

Line 1116: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1112: , p_cancelled_flag => C_NEED_BY_DATE_rec.cancelled_flag
1113: );
1114:
1115: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1116: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1117: , G_MODULE_PREFIX || l_api_name
1118: , 'l_retain => ' || l_retain );
1119: END IF;
1120:

Line 1123: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1119: END IF;
1120:
1121: IF NVL(l_retain,'Y') = 'N'
1122: THEN
1123: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1124: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1125: , G_MODULE_PREFIX || l_api_name
1126: , 'Call Delete_Allocations for repl SO LINE ID '||
1127: C_NEED_BY_DATE_rec.REPLENISHMENT_SO_LINE_ID);

Line 1124: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1120:
1121: IF NVL(l_retain,'Y') = 'N'
1122: THEN
1123: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1124: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1125: , G_MODULE_PREFIX || l_api_name
1126: , 'Call Delete_Allocations for repl SO LINE ID '||
1127: C_NEED_BY_DATE_rec.REPLENISHMENT_SO_LINE_ID);
1128: END IF;

Line 1144: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1140: );
1141:
1142: l_component_removed_qty := NVL(l_component_removed_qty,0) + C_NEED_BY_DATE_rec.allocated_quantity ;
1143:
1144: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1145: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1146: , G_MODULE_PREFIX || l_api_name
1147: , 'C_NEED_BY_DATE_rec.allocated_quantity =>' || C_NEED_BY_DATE_rec.allocated_quantity );
1148: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

Line 1145: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1141:
1142: l_component_removed_qty := NVL(l_component_removed_qty,0) + C_NEED_BY_DATE_rec.allocated_quantity ;
1143:
1144: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1145: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1146: , G_MODULE_PREFIX || l_api_name
1147: , 'C_NEED_BY_DATE_rec.allocated_quantity =>' || C_NEED_BY_DATE_rec.allocated_quantity );
1148: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1149: , G_MODULE_PREFIX || l_api_name

Line 1148: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1144: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1145: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1146: , G_MODULE_PREFIX || l_api_name
1147: , 'C_NEED_BY_DATE_rec.allocated_quantity =>' || C_NEED_BY_DATE_rec.allocated_quantity );
1148: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1149: , G_MODULE_PREFIX || l_api_name
1150: , 'l_component_removed_qty => ' || l_component_removed_qty );
1151: END IF;
1152:

Line 1157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1153: -- END IF; ---l_final_ship_date
1154:
1155: ELSE
1156: -- Update the existing repl
1157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1158: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1159: , G_MODULE_PREFIX || l_api_name
1160: , 'Retain Replen = Y. Reschedule RSO line_id:' || C_NEED_BY_DATE_rec.REPLENISHMENT_SO_LINE_ID);
1161: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

Line 1158: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1154:
1155: ELSE
1156: -- Update the existing repl
1157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1158: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1159: , G_MODULE_PREFIX || l_api_name
1160: , 'Retain Replen = Y. Reschedule RSO line_id:' || C_NEED_BY_DATE_rec.REPLENISHMENT_SO_LINE_ID);
1161: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1162: , G_MODULE_PREFIX || l_api_name

Line 1161: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1158: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1159: , G_MODULE_PREFIX || l_api_name
1160: , 'Retain Replen = Y. Reschedule RSO line_id:' || C_NEED_BY_DATE_rec.REPLENISHMENT_SO_LINE_ID);
1161: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1162: , G_MODULE_PREFIX || l_api_name
1163: , 'Calling JMF_SHIKYU_ONT_PVT.Calculate_Ship_Date for:' || l_allocation_date);
1164: END IF;
1165:

Line 1177: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1173: , p_quantity => C_NEED_BY_DATE_rec.allocated_quantity
1174: , p_need_by_date => l_allocation_date
1175: , x_ship_date => l_reschedule_date );
1176:
1177: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1178: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1179: , G_MODULE_PREFIX || l_api_name
1180: , 'l_reschedule_date => '|| l_reschedule_date);
1181: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

Line 1178: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1174: , p_need_by_date => l_allocation_date
1175: , x_ship_date => l_reschedule_date );
1176:
1177: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1178: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1179: , G_MODULE_PREFIX || l_api_name
1180: , 'l_reschedule_date => '|| l_reschedule_date);
1181: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1182: , G_MODULE_PREFIX || l_api_name

Line 1181: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1177: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1178: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1179: , G_MODULE_PREFIX || l_api_name
1180: , 'l_reschedule_date => '|| l_reschedule_date);
1181: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1182: , G_MODULE_PREFIX || l_api_name
1183: , 'Call update_replenishment_date for SO LINE ID:' || C_NEED_BY_DATE_rec.REPLENISHMENT_SO_LINE_ID);
1184: END IF;
1185:

Line 1197: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1193: , p_new_ship_date => l_reschedule_date
1194: , p_allocation_date => l_allocation_date
1195: );
1196:
1197: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1198: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1199: , G_MODULE_PREFIX || l_api_name
1200: , 'After update_replenishment_date');
1201: END IF;

Line 1198: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1194: , p_allocation_date => l_allocation_date
1195: );
1196:
1197: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1198: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1199: , G_MODULE_PREFIX || l_api_name
1200: , 'After update_replenishment_date');
1201: END IF;
1202:

Line 1208: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1204: --dbms_output.put_line(' Next in loop ');
1205: END IF ; -- l_final_ship_date
1206: END LOOP ;
1207:
1208: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1209: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1210: , G_MODULE_PREFIX || l_api_name
1211: , 'Out of components loop rem qty: '|| l_component_removed_qty);
1212: END IF;

Line 1209: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1205: END IF ; -- l_final_ship_date
1206: END LOOP ;
1207:
1208: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1209: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1210: , G_MODULE_PREFIX || l_api_name
1211: , 'Out of components loop rem qty: '|| l_component_removed_qty);
1212: END IF;
1213:

Line 1216: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1212: END IF;
1213:
1214: IF NVL(l_component_removed_qty,0) > 0
1215: THEN
1216: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1217: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1218: , G_MODULE_PREFIX || l_api_name
1219: , 'Going to call Create new allocations for comp' || l_SHIKYU_component_id );
1220: END IF;

Line 1217: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1213:
1214: IF NVL(l_component_removed_qty,0) > 0
1215: THEN
1216: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1217: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1218: , G_MODULE_PREFIX || l_api_name
1219: , 'Going to call Create new allocations for comp' || l_SHIKYU_component_id );
1220: END IF;
1221:

Line 1234: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1230: , p_qty => l_component_removed_qty
1231: , p_skip_po_replen_creation => 'N'
1232: );
1233:
1234: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1235: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1236: , G_MODULE_PREFIX || l_api_name
1237: , 'After Create new allocations for comp:' || l_return_status );
1238: END IF;

Line 1235: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1231: , p_skip_po_replen_creation => 'N'
1232: );
1233:
1234: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1235: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1236: , G_MODULE_PREFIX || l_api_name
1237: , 'After Create new allocations for comp:' || l_return_status );
1238: END IF;
1239: END IF ; -- l_component_removed_qty IF

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

1249:
1250:
1251: IF (g_fnd_debug = 'Y')
1252: THEN
1253: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1254: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1255: , G_MODULE_PREFIX || l_api_name
1256: , 'Exit');
1257: END IF;

Line 1254: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1250:
1251: IF (g_fnd_debug = 'Y')
1252: THEN
1253: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1254: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1255: , G_MODULE_PREFIX || l_api_name
1256: , 'Exit');
1257: END IF;
1258: END IF;

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

1401:
1402: -- update the JMF subcontract table with the new values
1403: -- COMMIT
1404:
1405: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1406: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1407: , G_MODULE_PREFIX || l_api_name
1408: , 'Begin');
1409: END IF;

Line 1406: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1402: -- update the JMF subcontract table with the new values
1403: -- COMMIT
1404:
1405: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1406: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1407: , G_MODULE_PREFIX || l_api_name
1408: , 'Begin');
1409: END IF;
1410:

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

1419: -- Process the changes due to PO subcontract order NEED BY DATE Only
1420: -- Process the change due to the PO subcontract QTY changes Only
1421: -- Process changes due to both PO subcontract need by date and qty changes
1422:
1423: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1424: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1425: , G_MODULE_PREFIX || l_api_name
1426: , 'Calling JMF_SHIKYU_UTIL.clean_invalid_data');
1427: END IF;

Line 1424: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1420: -- Process the change due to the PO subcontract QTY changes Only
1421: -- Process changes due to both PO subcontract need by date and qty changes
1422:
1423: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1424: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1425: , G_MODULE_PREFIX || l_api_name
1426: , 'Calling JMF_SHIKYU_UTIL.clean_invalid_data');
1427: END IF;
1428:

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

1432:
1433: -- dbms_output.put_line(' Calling Reconcile_Partial_Shipments ');
1434: IF (g_fnd_debug = 'Y')
1435: THEN
1436: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1437: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1438: , G_MODULE_PREFIX || l_api_name
1439: , 'Calling Reconcile_Partial_Shipments');
1440: END IF;

Line 1437: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1433: -- dbms_output.put_line(' Calling Reconcile_Partial_Shipments ');
1434: IF (g_fnd_debug = 'Y')
1435: THEN
1436: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1437: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1438: , G_MODULE_PREFIX || l_api_name
1439: , 'Calling Reconcile_Partial_Shipments');
1440: END IF;
1441: END IF;

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

1452: );
1453:
1454: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1455: THEN
1456: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1457: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1458: , G_MODULE_PREFIX || l_api_name
1459: , 'Reconcile_Partial_Shipments returned error. Status:' || l_return_status);
1460: END IF;

Line 1457: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1453:
1454: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1455: THEN
1456: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1457: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1458: , G_MODULE_PREFIX || l_api_name
1459: , 'Reconcile_Partial_Shipments returned error. Status:' || l_return_status);
1460: END IF;
1461:

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

1460: END IF;
1461:
1462: rollback;
1463: ELSE
1464: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1465: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1466: , G_MODULE_PREFIX || l_api_name
1467: , 'Reconcile_Partial_Shipments returned success. Status:' || l_return_status);
1468: END IF;

Line 1465: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1461:
1462: rollback;
1463: ELSE
1464: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1465: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1466: , G_MODULE_PREFIX || l_api_name
1467: , 'Reconcile_Partial_Shipments returned success. Status:' || l_return_status);
1468: END IF;
1469:

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

1472:
1473: EXCEPTION
1474: WHEN OTHERS THEN
1475: ROLLBACK;
1476: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1477: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1478: , G_MODULE_PREFIX || l_api_name
1479: , 'JMFVSKRB: OUT OF Reconcile_Partial_Shipments -- EXCEPTION => ' || l_return_status);
1480: END IF;

Line 1477: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1473: EXCEPTION
1474: WHEN OTHERS THEN
1475: ROLLBACK;
1476: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1477: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1478: , G_MODULE_PREFIX || l_api_name
1479: , 'JMFVSKRB: OUT OF Reconcile_Partial_Shipments -- EXCEPTION => ' || l_return_status);
1480: END IF;
1481:

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

1482: END ;
1483:
1484: IF (g_fnd_debug = 'Y')
1485: THEN
1486: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1487: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1488: , G_MODULE_PREFIX || l_api_name
1489: , 'Calling Reconcile_Closed_Shipments');
1490: END IF;

Line 1487: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1483:
1484: IF (g_fnd_debug = 'Y')
1485: THEN
1486: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1487: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1488: , G_MODULE_PREFIX || l_api_name
1489: , 'Calling Reconcile_Closed_Shipments');
1490: END IF;
1491: END IF;

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

1499: );
1500:
1501: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1502: THEN
1503: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1504: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1505: , G_MODULE_PREFIX || l_api_name
1506: , 'Reconcile_Partial_Shipments returned error. Status:' || l_return_status);
1507: END IF;

Line 1504: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1500:
1501: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1502: THEN
1503: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1504: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1505: , G_MODULE_PREFIX || l_api_name
1506: , 'Reconcile_Partial_Shipments returned error. Status:' || l_return_status);
1507: END IF;
1508: ELSE

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

1505: , G_MODULE_PREFIX || l_api_name
1506: , 'Reconcile_Partial_Shipments returned error. Status:' || l_return_status);
1507: END IF;
1508: ELSE
1509: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1510: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1511: , G_MODULE_PREFIX || l_api_name
1512: , 'Reconcile_Partial_Shipments returned success. Status:' || l_return_status);
1513: END IF;

Line 1510: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1506: , 'Reconcile_Partial_Shipments returned error. Status:' || l_return_status);
1507: END IF;
1508: ELSE
1509: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1510: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1511: , G_MODULE_PREFIX || l_api_name
1512: , 'Reconcile_Partial_Shipments returned success. Status:' || l_return_status);
1513: END IF;
1514: END IF;

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

1513: END IF;
1514: END IF;
1515: --End bugfix 14078692.
1516:
1517: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1518: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1519: , G_MODULE_PREFIX || l_api_name
1520: , 'Continuing after Reconciling RSOs.');
1521: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 1518: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1514: END IF;
1515: --End bugfix 14078692.
1516:
1517: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1518: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1519: , G_MODULE_PREFIX || l_api_name
1520: , 'Continuing after Reconciling RSOs.');
1521: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1522: , G_MODULE_PREFIX || l_api_name

Line 1521: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1517: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1518: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1519: , G_MODULE_PREFIX || l_api_name
1520: , 'Continuing after Reconciling RSOs.');
1521: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1522: , G_MODULE_PREFIX || l_api_name
1523: , 'x_msg_data:' || x_msg_data);
1524: END IF;
1525:

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

1526:
1527: l_return_status := NULL;
1528:
1529: -- dbms_output.put_line(' About to open cursor SHIKYU_reconcile_CSR');
1530: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1531: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1532: , G_MODULE_PREFIX || l_api_name
1533: , 'About to open cursor SHIKYU_reconcile_CSR.');
1534: END IF;

Line 1531: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1527: l_return_status := NULL;
1528:
1529: -- dbms_output.put_line(' About to open cursor SHIKYU_reconcile_CSR');
1530: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1531: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1532: , G_MODULE_PREFIX || l_api_name
1533: , 'About to open cursor SHIKYU_reconcile_CSR.');
1534: END IF;
1535:

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

1538: BEGIN
1539:
1540: l_subcontract_po_shipment_id := SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID;
1541:
1542: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1543: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1544: , G_MODULE_PREFIX || l_api_name
1545: , '========================================'
1546: );

Line 1543: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1539:
1540: l_subcontract_po_shipment_id := SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID;
1541:
1542: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1543: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1544: , G_MODULE_PREFIX || l_api_name
1545: , '========================================'
1546: );
1547:

Line 1548: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1544: , G_MODULE_PREFIX || l_api_name
1545: , '========================================'
1546: );
1547:
1548: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1549: , G_MODULE_PREFIX || l_api_name
1550: , 'SPO_SHIPMENT_ID:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID ||
1551: ':SPO_HEADER_ID:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_HEADER_ID ||
1552: ':SPO_LINE_ID:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_LINE_ID

Line 1555: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1551: ':SPO_HEADER_ID:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_HEADER_ID ||
1552: ':SPO_LINE_ID:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_LINE_ID
1553: );
1554:
1555: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1556: , G_MODULE_PREFIX || l_api_name
1557: , 'SCO_NEED_BY_DATE:' || SHIKYU_reconcile_rec.sco_NEED_BY_DATE ||
1558: ':POL_NEED_BY_DATE:' || SHIKYU_reconcile_rec.pol_need_by_date
1559: );

Line 1561: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1557: , 'SCO_NEED_BY_DATE:' || SHIKYU_reconcile_rec.sco_NEED_BY_DATE ||
1558: ':POL_NEED_BY_DATE:' || SHIKYU_reconcile_rec.pol_need_by_date
1559: );
1560:
1561: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1562: , G_MODULE_PREFIX || l_api_name
1563: , 'Cancel Flags:: POH:' || SHIKYU_reconcile_rec.poh_cancel_flag ||
1564: ':POL:' || SHIKYU_reconcile_rec.pol_cancel_flag ||
1565: ':POLL:' || SHIKYU_reconcile_rec.poll_cancel_flag);

Line 1567: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1563: , 'Cancel Flags:: POH:' || SHIKYU_reconcile_rec.poh_cancel_flag ||
1564: ':POL:' || SHIKYU_reconcile_rec.pol_cancel_flag ||
1565: ':POLL:' || SHIKYU_reconcile_rec.poll_cancel_flag);
1566:
1567: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1568: , G_MODULE_PREFIX || l_api_name
1569: , 'OEM:' || SHIKYU_reconcile_rec.OEM_ORGANIZATION_ID ||
1570: ':MP:' || SHIKYU_reconcile_rec.TP_ORGANIZATION_ID ||
1571: ':WE_Id:' || SHIKYU_reconcile_rec.WIP_ENTITY_ID ||

Line 1578: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1574: ':OSA:' || SHIKYU_reconcile_rec.OSA_ITEM_ID ||
1575: ':Currency:' || SHIKYU_reconcile_rec.CURRENCY
1576: );
1577:
1578: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1579: , G_MODULE_PREFIX || l_api_name
1580: , 'SPO_Qty:' || SHIKYU_reconcile_rec.old_ordered_quantity ||
1581: ':SPO_UOM:' || SHIKYU_reconcile_rec.UOM ||
1582: ':POLL_Qty:' || SHIKYU_reconcile_rec.quantity ||

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

1590: THEN
1591: BEGIN
1592: -- Cancel WIP Jobs
1593: -- Remove all the allocations
1594: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1595: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1596: , G_MODULE_PREFIX || l_api_name
1597: , 'CANCEL for SPO_SHIPMENT_ID:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1598: END IF;

Line 1595: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1591: BEGIN
1592: -- Cancel WIP Jobs
1593: -- Remove all the allocations
1594: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1595: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1596: , G_MODULE_PREFIX || l_api_name
1597: , 'CANCEL for SPO_SHIPMENT_ID:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1598: END IF;
1599:

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

1604: , p_quantity => NULL
1605: , x_return_status => l_return_status
1606: );
1607:
1608: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1609: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1610: , G_MODULE_PREFIX || l_api_name
1611: , 'Status from Process_WIP_Job:' || l_return_status );
1612: END IF;

Line 1609: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1605: , x_return_status => l_return_status
1606: );
1607:
1608: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1609: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1610: , G_MODULE_PREFIX || l_api_name
1611: , 'Status from Process_WIP_Job:' || l_return_status );
1612: END IF;
1613:

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

1614: --COMMIT;
1615:
1616: IF SHIKYU_reconcile_rec.scheduled_start_date > SYSDATE
1617: THEN
1618: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1619: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1620: , G_MODULE_PREFIX || l_api_name
1621: , 'Calling JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations.');
1622: END IF;

Line 1619: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1615:
1616: IF SHIKYU_reconcile_rec.scheduled_start_date > SYSDATE
1617: THEN
1618: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1619: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1620: , G_MODULE_PREFIX || l_api_name
1621: , 'Calling JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations.');
1622: END IF;
1623:

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

1632: , p_replen_so_line_id => NULL
1633: , x_deleted_allocations_tbl => l_deleted_allocations_tbl
1634: );
1635:
1636: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1637: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1638: , G_MODULE_PREFIX || l_api_name
1639: , 'Delete_Allocations:: Status => '|| l_return_status );
1640: END IF;

Line 1637: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1633: , x_deleted_allocations_tbl => l_deleted_allocations_tbl
1634: );
1635:
1636: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1637: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1638: , G_MODULE_PREFIX || l_api_name
1639: , 'Delete_Allocations:: Status => '|| l_return_status );
1640: END IF;
1641:

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

1640: END IF;
1641:
1642: ELSE
1643: -- dbms_output.put_line(' Cancel components ');
1644: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1645: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1646: , G_MODULE_PREFIX || l_api_name
1647: , 'INTO Cancel components SCO SHIPMENT:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1648: END IF;

Line 1645: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1641:
1642: ELSE
1643: -- dbms_output.put_line(' Cancel components ');
1644: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1645: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1646: , G_MODULE_PREFIX || l_api_name
1647: , 'INTO Cancel components SCO SHIPMENT:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1648: END IF;
1649:

Line 1654: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1650: l_used_quantity := NULL;
1651:
1652: FOR C_shikyu_cancel_comp_rec IN C_shikyu_cancel_comp_CSR
1653: LOOP
1654: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1655: THEN
1656: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1657: , G_MODULE_PREFIX || l_api_name
1658: , 'CURSOR shikyu_cancel_comp_rec.shikyu_component_id => ' || c_shikyu_cancel_comp_rec.shikyu_component_id );

Line 1656: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1652: FOR C_shikyu_cancel_comp_rec IN C_shikyu_cancel_comp_CSR
1653: LOOP
1654: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1655: THEN
1656: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1657: , G_MODULE_PREFIX || l_api_name
1658: , 'CURSOR shikyu_cancel_comp_rec.shikyu_component_id => ' || c_shikyu_cancel_comp_rec.shikyu_component_id );
1659: END IF;
1660:

Line 1663: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1659: END IF;
1660:
1661: l_used_quantity := 0 ;
1662:
1663: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1664: THEN
1665: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1666: , G_MODULE_PREFIX || l_api_name
1667: , 'JMF_SHIKYU_UTIL.GET_used_quantity for:' || C_shikyu_cancel_comp_rec.shikyu_component_id );

Line 1665: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1661: l_used_quantity := 0 ;
1662:
1663: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1664: THEN
1665: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1666: , G_MODULE_PREFIX || l_api_name
1667: , 'JMF_SHIKYU_UTIL.GET_used_quantity for:' || C_shikyu_cancel_comp_rec.shikyu_component_id );
1668: END IF;
1669:

Line 1676: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1672: , p_shikyu_component_id => C_shikyu_cancel_comp_rec.shikyu_component_id
1673: , p_organization_id => SHIKYU_reconcile_rec.oem_organization_id
1674: );
1675:
1676: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1677: THEN
1678: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1679: , G_MODULE_PREFIX || l_api_name
1680: , 'l_used_quantity => ' || l_used_quantity );

Line 1678: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1674: );
1675:
1676: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1677: THEN
1678: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1679: , G_MODULE_PREFIX || l_api_name
1680: , 'l_used_quantity => ' || l_used_quantity );
1681: END IF;
1682:

Line 1686: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1682:
1683:
1684: IF NVL(l_used_quantity,0) <= 0
1685: THEN
1686: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1687: THEN
1688: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1689: , G_MODULE_PREFIX || l_api_name
1690: , 'Calling JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations:' || C_shikyu_cancel_comp_rec.shikyu_component_id );

Line 1688: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1684: IF NVL(l_used_quantity,0) <= 0
1685: THEN
1686: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1687: THEN
1688: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1689: , G_MODULE_PREFIX || l_api_name
1690: , 'Calling JMF_SHIKYU_ALLOCATION_PVT.Delete_Allocations:' || C_shikyu_cancel_comp_rec.shikyu_component_id );
1691: END IF;
1692:

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

1704: END IF;
1705: END LOOP;
1706: END IF ; -- Greater than start date
1707:
1708: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1709: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1710: , G_MODULE_PREFIX || l_api_name
1711: , 'JMFVSKRB: UPDATE and COMMIT for SCO PO CANCEL flow ' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1712: END IF;

Line 1709: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1705: END LOOP;
1706: END IF ; -- Greater than start date
1707:
1708: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1709: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1710: , G_MODULE_PREFIX || l_api_name
1711: , 'JMFVSKRB: UPDATE and COMMIT for SCO PO CANCEL flow ' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1712: END IF;
1713:

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

1726: WHEN OTHERS THEN
1727: BEGIN
1728: ROLLBACK ;
1729:
1730: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1731: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1732: , G_MODULE_PREFIX || l_api_name
1733: , 'JMFVSKRB: EXCEPTION 1 in CANCEL FLOW ' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1734: END IF;

Line 1731: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1727: BEGIN
1728: ROLLBACK ;
1729:
1730: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1731: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1732: , G_MODULE_PREFIX || l_api_name
1733: , 'JMFVSKRB: EXCEPTION 1 in CANCEL FLOW ' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1734: END IF;
1735: END ;

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

1736: END ;
1737:
1738: ELSE -- NOT cancel logic
1739: l_return_status := NULL ;
1740: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1741: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1742: , G_MODULE_PREFIX || l_api_name
1743: , 'INto NON cancel logic::l_return_status => '|| l_return_status );
1744: END IF;

Line 1741: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1737:
1738: ELSE -- NOT cancel logic
1739: l_return_status := NULL ;
1740: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1741: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1742: , G_MODULE_PREFIX || l_api_name
1743: , 'INto NON cancel logic::l_return_status => '|| l_return_status );
1744: END IF;
1745: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1741: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1742: , G_MODULE_PREFIX || l_api_name
1743: , 'INto NON cancel logic::l_return_status => '|| l_return_status );
1744: END IF;
1745: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1746: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1747: , G_MODULE_PREFIX || l_api_name
1748: , 'SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID => ' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID);
1749: END IF;

Line 1746: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1742: , G_MODULE_PREFIX || l_api_name
1743: , 'INto NON cancel logic::l_return_status => '|| l_return_status );
1744: END IF;
1745: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1746: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1747: , G_MODULE_PREFIX || l_api_name
1748: , 'SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID => ' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID);
1749: END IF;
1750:

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

1754: , p_quantity => SHIKYU_reconcile_rec.quantity
1755: , P_inventory_org_id => SHIKYU_reconcile_rec.oem_organization_id
1756: , p_inventory_item_id => SHIKYU_reconcile_rec.OSA_ITEM_ID ) ;
1757:
1758: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1759: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1760: , G_MODULE_PREFIX || l_api_name
1761: , 'Calling JMF_SHIKYU_WIP_PVT.Process_WIP_Job U for SCO:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1762: END IF;

Line 1759: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1755: , P_inventory_org_id => SHIKYU_reconcile_rec.oem_organization_id
1756: , p_inventory_item_id => SHIKYU_reconcile_rec.OSA_ITEM_ID ) ;
1757:
1758: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1759: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1760: , G_MODULE_PREFIX || l_api_name
1761: , 'Calling JMF_SHIKYU_WIP_PVT.Process_WIP_Job U for SCO:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1762: END IF;
1763:

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

1768: , p_quantity => l_primary_quantity
1769: , x_return_status => l_return_status
1770: ) ;
1771:
1772: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1773: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1774: , G_MODULE_PREFIX || l_api_name
1775: , 'out JMF_SHIKYU_WIP_PVT.Process_WIP_Job with ' || l_return_status );
1776: END IF;

Line 1773: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1769: , x_return_status => l_return_status
1770: ) ;
1771:
1772: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1773: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1774: , G_MODULE_PREFIX || l_api_name
1775: , 'out JMF_SHIKYU_WIP_PVT.Process_WIP_Job with ' || l_return_status );
1776: END IF;
1777:

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

1781: IF ( TRUNC( SHIKYU_reconcile_rec.pol_need_by_date ) <> TRUNC(SHIKYU_reconcile_rec.sco_need_by_date) )
1782: AND ( SHIKYU_reconcile_rec.old_ordered_quantity ) = ( SHIKYU_reconcile_rec.quantity )
1783: THEN
1784:
1785: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1786: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1787: , G_MODULE_PREFIX || l_api_name
1788: , 'Calling Process_Date_Changes:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1789: END IF;

Line 1786: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1782: AND ( SHIKYU_reconcile_rec.old_ordered_quantity ) = ( SHIKYU_reconcile_rec.quantity )
1783: THEN
1784:
1785: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1786: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1787: , G_MODULE_PREFIX || l_api_name
1788: , 'Calling Process_Date_Changes:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1789: END IF;
1790:

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

1811: AND ( SHIKYU_reconcile_rec.old_ordered_quantity ) <> ( SHIKYU_reconcile_rec.quantity )
1812: THEN
1813: -- Process Qty changes
1814:
1815: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1816: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1817: , G_MODULE_PREFIX || l_api_name
1818: , 'Calling Process_Quantity_Changes:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1819: END IF;

Line 1816: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1812: THEN
1813: -- Process Qty changes
1814:
1815: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1816: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1817: , G_MODULE_PREFIX || l_api_name
1818: , 'Calling Process_Quantity_Changes:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1819: END IF;
1820:

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

1840: ELSIF ( TRUNC( SHIKYU_reconcile_rec.pol_need_by_date ) <> TRUNC(SHIKYU_reconcile_rec.sco_need_by_date) )
1841: AND ( SHIKYU_reconcile_rec.old_ordered_quantity ) <> ( SHIKYU_reconcile_rec.quantity )
1842: THEN
1843:
1844: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1845: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1846: , G_MODULE_PREFIX || l_api_name
1847: , 'Calling Process_Date_Changes:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1848: END IF;

Line 1845: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1841: AND ( SHIKYU_reconcile_rec.old_ordered_quantity ) <> ( SHIKYU_reconcile_rec.quantity )
1842: THEN
1843:
1844: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1845: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1846: , G_MODULE_PREFIX || l_api_name
1847: , 'Calling Process_Date_Changes:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1848: END IF;
1849:

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

1897: and SUBCONTRACT_PO_SHIPMENT_ID = SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID ;
1898:
1899: COMMIT;
1900:
1901: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1902: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1903: , G_MODULE_PREFIX || l_api_name
1904: , 'AFTER UPDATE JMF_SUBCONTRACT_ORDERS:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1905: END IF;

Line 1902: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1898:
1899: COMMIT;
1900:
1901: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1902: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1903: , G_MODULE_PREFIX || l_api_name
1904: , 'AFTER UPDATE JMF_SUBCONTRACT_ORDERS:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1905: END IF;
1906:

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

1911:
1912: EXCEPTION
1913: WHEN OTHERS THEN
1914: ROLLBACK ;
1915: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1916: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1917: ,G_MODULE_PREFIX || l_api_name
1918: ,'MAIN LOOP exception for SCO shipment:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1919: END IF;

Line 1916: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1912: EXCEPTION
1913: WHEN OTHERS THEN
1914: ROLLBACK ;
1915: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1916: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1917: ,G_MODULE_PREFIX || l_api_name
1918: ,'MAIN LOOP exception for SCO shipment:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1919: END IF;
1920: END ;

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

1918: ,'MAIN LOOP exception for SCO shipment:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1919: END IF;
1920: END ;
1921:
1922: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1923: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1924: , G_MODULE_PREFIX || l_api_name
1925: , 'Done processing SPO_shipment_Id:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1926: END IF;

Line 1923: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1919: END IF;
1920: END ;
1921:
1922: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1923: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1924: , G_MODULE_PREFIX || l_api_name
1925: , 'Done processing SPO_shipment_Id:' || SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID );
1926: END IF;
1927:

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

1929:
1930: -- dbms_output.put_line(' Out of Main loop ');
1931:
1932: -- Fix 14246759: Reconciling SO schedule ship date changes.
1933: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1934: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1935: , G_MODULE_PREFIX || l_api_name
1936: , '====Reconciling RSO date changes=======');
1937: END IF;

Line 1934: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1930: -- dbms_output.put_line(' Out of Main loop ');
1931:
1932: -- Fix 14246759: Reconciling SO schedule ship date changes.
1933: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1934: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1935: , G_MODULE_PREFIX || l_api_name
1936: , '====Reconciling RSO date changes=======');
1937: END IF;
1938:

Line 1943: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1939: JMF_SHIKYU_ALLOCATION_PVT.reconcile_rso_date_changes(x_return_status => l_return_status);
1940:
1941: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1942: THEN
1943: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1944: THEN
1945: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1946: , G_MODULE_PREFIX || l_api_name
1947: , 'reconcile_rso_date_changes returned error. Status:' || l_return_status);

Line 1945: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1941: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1942: THEN
1943: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1944: THEN
1945: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1946: , G_MODULE_PREFIX || l_api_name
1947: , 'reconcile_rso_date_changes returned error. Status:' || l_return_status);
1948: END IF;
1949:

Line 1953: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1949:
1950: x_return_status := l_return_status;
1951:
1952: ELSE
1953: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1954: THEN
1955: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1956: , G_MODULE_PREFIX || l_api_name
1957: , 'reconcile_rso_date_changes returned success. Status:' || l_return_status);

Line 1955: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1951:
1952: ELSE
1953: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1954: THEN
1955: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1956: , G_MODULE_PREFIX || l_api_name
1957: , 'reconcile_rso_date_changes returned success. Status:' || l_return_status);
1958: END IF;
1959:

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

1960: commit;
1961:
1962: END IF;
1963:
1964: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1965: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1966: , G_MODULE_PREFIX || l_api_name
1967: , 'End');
1968: END IF;

Line 1965: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1961:
1962: END IF;
1963:
1964: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1965: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1966: , G_MODULE_PREFIX || l_api_name
1967: , 'End');
1968: END IF;
1969: --dbms_output.put_line(' OUT of Process_SHIKYU_Reconciliation. ');

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

1971: WHEN FND_API.G_EXC_ERROR THEN
1972: -- dbms_output.put_line(' EXCEPTION: FND_API.G_EXC_ERROR ');
1973: -- dbms_output.put_line(' SQLERRM : '|| SQLERRM );
1974:
1975: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1976: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1977: , G_MODULE_PREFIX || l_api_name
1978: , 'Expected Error:' || sqlerrm);
1979: END IF;

Line 1976: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1972: -- dbms_output.put_line(' EXCEPTION: FND_API.G_EXC_ERROR ');
1973: -- dbms_output.put_line(' SQLERRM : '|| SQLERRM );
1974:
1975: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1976: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1977: , G_MODULE_PREFIX || l_api_name
1978: , 'Expected Error:' || sqlerrm);
1979: END IF;
1980:

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

1988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1989: -- dbms_output.put_line(' EXCEPTION: FND_API.G_EXC_UNEXPECTED_ERROR ');
1990: -- dbms_output.put_line(' SQLERRM : '|| SQLERRM );
1991:
1992: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1993: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1994: , G_MODULE_PREFIX || l_api_name
1995: , 'UnExpected Error:' || sqlerrm);
1996: END IF;

Line 1993: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1989: -- dbms_output.put_line(' EXCEPTION: FND_API.G_EXC_UNEXPECTED_ERROR ');
1990: -- dbms_output.put_line(' SQLERRM : '|| SQLERRM );
1991:
1992: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1993: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1994: , G_MODULE_PREFIX || l_api_name
1995: , 'UnExpected Error:' || sqlerrm);
1996: END IF;
1997:

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

2004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2005:
2006: WHEN OTHERS THEN
2007:
2008: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2009: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2010: , G_MODULE_PREFIX || l_api_name
2011: , 'Others:' || sqlerrm);
2012: END IF;

Line 2009: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2005:
2006: WHEN OTHERS THEN
2007:
2008: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2009: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2010: , G_MODULE_PREFIX || l_api_name
2011: , 'Others:' || sqlerrm);
2012: END IF;
2013: