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.GMPRELAP dependencies on FND_FILE

Line 226: FND_FILE.PUT_LINE ( FND_FILE.LOG,'===== Input Parameters ===== ');

222: /* B7530107 Reset everything for GME so that
223: for every record it will go and set the org, calendar information */
224: gme_common_pvt.g_setup_done := FALSE ;
225:
226: FND_FILE.PUT_LINE ( FND_FILE.LOG,'===== Input Parameters ===== ');
227: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_process_id = ' || p_process_id);
228: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_organization_id = ' || p_organization_id);
229: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fitem_no = ' || p_fitem_no);
230: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_titem_no = ' || p_titem_no);

Line 227: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_process_id = ' || p_process_id);

223: for every record it will go and set the org, calendar information */
224: gme_common_pvt.g_setup_done := FALSE ;
225:
226: FND_FILE.PUT_LINE ( FND_FILE.LOG,'===== Input Parameters ===== ');
227: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_process_id = ' || p_process_id);
228: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_organization_id = ' || p_organization_id);
229: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fitem_no = ' || p_fitem_no);
230: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_titem_no = ' || p_titem_no);
231: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fdate = ' || p_fdate);

Line 228: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_organization_id = ' || p_organization_id);

224: gme_common_pvt.g_setup_done := FALSE ;
225:
226: FND_FILE.PUT_LINE ( FND_FILE.LOG,'===== Input Parameters ===== ');
227: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_process_id = ' || p_process_id);
228: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_organization_id = ' || p_organization_id);
229: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fitem_no = ' || p_fitem_no);
230: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_titem_no = ' || p_titem_no);
231: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fdate = ' || p_fdate);
232: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_tdate = ' || p_tdate);

Line 229: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fitem_no = ' || p_fitem_no);

225:
226: FND_FILE.PUT_LINE ( FND_FILE.LOG,'===== Input Parameters ===== ');
227: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_process_id = ' || p_process_id);
228: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_organization_id = ' || p_organization_id);
229: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fitem_no = ' || p_fitem_no);
230: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_titem_no = ' || p_titem_no);
231: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fdate = ' || p_fdate);
232: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_tdate = ' || p_tdate);
233:

Line 230: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_titem_no = ' || p_titem_no);

226: FND_FILE.PUT_LINE ( FND_FILE.LOG,'===== Input Parameters ===== ');
227: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_process_id = ' || p_process_id);
228: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_organization_id = ' || p_organization_id);
229: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fitem_no = ' || p_fitem_no);
230: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_titem_no = ' || p_titem_no);
231: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fdate = ' || p_fdate);
232: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_tdate = ' || p_tdate);
233:
234: /* { */

Line 231: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fdate = ' || p_fdate);

227: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_process_id = ' || p_process_id);
228: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_organization_id = ' || p_organization_id);
229: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fitem_no = ' || p_fitem_no);
230: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_titem_no = ' || p_titem_no);
231: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fdate = ' || p_fdate);
232: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_tdate = ' || p_tdate);
233:
234: /* { */
235: IF p_tdate IS NOT NULL AND p_fdate IS NOT NULL THEN

Line 232: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_tdate = ' || p_tdate);

228: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_organization_id = ' || p_organization_id);
229: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fitem_no = ' || p_fitem_no);
230: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_titem_no = ' || p_titem_no);
231: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fdate = ' || p_fdate);
232: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_tdate = ' || p_tdate);
233:
234: /* { */
235: IF p_tdate IS NOT NULL AND p_fdate IS NOT NULL THEN
236:

Line 245: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_from_date = ' || l_from_date);

241:
242: -- l_from_date := fnd_date.charDT_to_date(p_fdate);
243: -- l_to_date := fnd_date.charDT_to_date(p_tdate);
244:
245: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_from_date = ' || l_from_date);
246: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_to_date = ' || l_to_date);
247:
248: IF l_updt_offsets = 1 THEN
249: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Profile Update activity offset is set');

Line 246: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_to_date = ' || l_to_date);

242: -- l_from_date := fnd_date.charDT_to_date(p_fdate);
243: -- l_to_date := fnd_date.charDT_to_date(p_tdate);
244:
245: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_from_date = ' || l_from_date);
246: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_to_date = ' || l_to_date);
247:
248: IF l_updt_offsets = 1 THEN
249: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Profile Update activity offset is set');
250: ELSE

Line 249: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Profile Update activity offset is set');

245: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_from_date = ' || l_from_date);
246: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_to_date = ' || l_to_date);
247:
248: IF l_updt_offsets = 1 THEN
249: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Profile Update activity offset is set');
250: ELSE
251: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Profile Update activity offset is not set');
252: END IF;
253:

Line 251: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Profile Update activity offset is not set');

247:
248: IF l_updt_offsets = 1 THEN
249: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Profile Update activity offset is set');
250: ELSE
251: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Profile Update activity offset is not set');
252: END IF;
253:
254: IF (l_to_date < l_from_date) THEN
255: RAISE CHECK_DATE;

Line 278: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Implementing FPOs ');

274: FROM gme_parameters
275: WHERE organization_id = get_data_rec.organization_id ;
276:
277: v_batch_type := 10 ;
278: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Implementing FPOs ');
279: ELSE
280: -- Batch
281: SELECT BATCH_DOC_NUMBERING
282: INTO X_assignment_type

Line 287: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Implementing Batches ');

283: FROM gme_parameters
284: WHERE organization_id = get_data_rec.organization_id ;
285:
286: v_batch_type := 0 ;
287: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Implementing Batches ');
288: END IF;
289:
290: IF (X_assignment_type = 1) THEN -- Manual Numbering
291: RAISE MANUAL_DOC_TYPE;

Line 325: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Implementing Reschedule Batches ');

321: gmp_aps_writer.update_activity_offsets (get_data_rec.batch_id);
322: END IF;
323:
324: ELSIF get_data_rec.action_type = 3 THEN /* Reschedule */
325: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Implementing Reschedule Batches ');
326:
327: reschedule_batch(
328: get_data_rec.process_id,
329: get_data_rec.organization_id,

Line 342: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Batch Id - '|| get_data_rec.batch_id);

338: get_data_rec.processed_ind,
339: get_data_rec.rowid
340: );
341:
342: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Batch Id - '|| get_data_rec.batch_id);
343:
344: /* B5897392 Rajesh Patangya firm Flag */
345: IF get_data_rec.firmed_ind = 1 THEN
346: UPDATE GME_BATCH_HEADER

Line 359: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Implementing Cancel Batches ');

355: END IF;
356:
357: ELSIF get_data_rec.action_type = -1 THEN /* Cancel */
358:
359: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Implementing Cancel Batches ');
360:
361: cancel_batch(
362: get_data_rec.process_id,
363: get_data_rec.organization_id,

Line 391: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);

387: EXCEPTION
388: WHEN MANUAL_DOC_TYPE THEN
389: errbuf := sqlerrm;
390: FND_MESSAGE.SET_NAME('GMP','SY_INVALID_MANUAL_DOC');
391: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
392: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cannot convert to Batch/FPO, Manual Doc Type '||sqlerrm);
393: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
394: NULL;
395: END IF;

Line 392: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cannot convert to Batch/FPO, Manual Doc Type '||sqlerrm);

388: WHEN MANUAL_DOC_TYPE THEN
389: errbuf := sqlerrm;
390: FND_MESSAGE.SET_NAME('GMP','SY_INVALID_MANUAL_DOC');
391: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
392: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cannot convert to Batch/FPO, Manual Doc Type '||sqlerrm);
393: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
394: NULL;
395: END IF;
396: retcode := '3';

Line 401: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);

397:
398: WHEN CHECK_DATE THEN
399: errbuf := sqlerrm;
400: FND_MESSAGE.SET_NAME('GMP','MR_INV_CALENDAR_RANGE');
401: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
402: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
403: NULL;
404: END IF;
405: retcode := '3';

Line 410: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);

406:
407: WHEN NO_ROWS THEN
408: errbuf := sqlerrm;
409: FND_MESSAGE.SET_NAME('GMA','SY_NO_ROWS_SELECTED');
410: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
411: --IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
412: /*Bug:6408133 GMPRELAP COMPLETES WITH WARNING WHEN THERE ARE NO ORDERS TO BE CONVERTED */
413:
414: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',NULL)) THEN

Line 421: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Implementing APS Plng Suggestions '||sqlerrm);

417: END IF;
418: retcode := '3';
419: WHEN OTHERS THEN
420: errbuf := sqlerrm;
421: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Implementing APS Plng Suggestions '||sqlerrm);
422: retcode := '2';
423:
424: END Implement_Aps_Plng_Sugg;
425:

Line 561: FND_FILE.PUT_LINE(FND_FILE.LOG,'New btach Processing for Group ID = ' || p_process_id || ' Header ID = ' || p_header_id);

557: then GME should be using the quantity passed as total quantity to create the batch
558: */
559: l_sum_all_prod_lines := 'S' ;
560:
561: FND_FILE.PUT_LINE(FND_FILE.LOG,'New btach Processing for Group ID = ' || p_process_id || ' Header ID = ' || p_header_id);
562:
563: OPEN calendar_associated(p_organization_id);
564: FETCH calendar_associated INTO l_cal_code,l_org_code;
565: CLOSE calendar_associated;

Line 616: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before validate Effectivity ');

612: /* Assuming the fmeff_id is coming from APS Engine */
613: l_recipe_id := 0 ;
614: l_return := -1;
615:
616: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before validate Effectivity ');
617: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_organization_id '||p_organization_id);
618: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inventory_item_id '||p_inventory_item_id);
619: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_effectivity_id '||p_effectivity_id);
620: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_plan_quantity '||p_plan_quantity);

Line 617: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_organization_id '||p_organization_id);

613: l_recipe_id := 0 ;
614: l_return := -1;
615:
616: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before validate Effectivity ');
617: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_organization_id '||p_organization_id);
618: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inventory_item_id '||p_inventory_item_id);
619: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_effectivity_id '||p_effectivity_id);
620: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_plan_quantity '||p_plan_quantity);
621: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch type '||p_batch_type);

Line 618: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inventory_item_id '||p_inventory_item_id);

614: l_return := -1;
615:
616: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before validate Effectivity ');
617: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_organization_id '||p_organization_id);
618: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inventory_item_id '||p_inventory_item_id);
619: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_effectivity_id '||p_effectivity_id);
620: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_plan_quantity '||p_plan_quantity);
621: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch type '||p_batch_type);
622: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_start_date '||p_start_date);

Line 619: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_effectivity_id '||p_effectivity_id);

615:
616: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before validate Effectivity ');
617: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_organization_id '||p_organization_id);
618: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inventory_item_id '||p_inventory_item_id);
619: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_effectivity_id '||p_effectivity_id);
620: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_plan_quantity '||p_plan_quantity);
621: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch type '||p_batch_type);
622: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_start_date '||p_start_date);
623: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date '||p_end_date);

Line 620: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_plan_quantity '||p_plan_quantity);

616: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before validate Effectivity ');
617: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_organization_id '||p_organization_id);
618: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inventory_item_id '||p_inventory_item_id);
619: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_effectivity_id '||p_effectivity_id);
620: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_plan_quantity '||p_plan_quantity);
621: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch type '||p_batch_type);
622: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_start_date '||p_start_date);
623: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date '||p_end_date);
624:

Line 621: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch type '||p_batch_type);

617: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_organization_id '||p_organization_id);
618: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inventory_item_id '||p_inventory_item_id);
619: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_effectivity_id '||p_effectivity_id);
620: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_plan_quantity '||p_plan_quantity);
621: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch type '||p_batch_type);
622: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_start_date '||p_start_date);
623: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date '||p_end_date);
624:
625: -- Bug: 8625112 Vpedarla

Line 622: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_start_date '||p_start_date);

618: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inventory_item_id '||p_inventory_item_id);
619: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_effectivity_id '||p_effectivity_id);
620: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_plan_quantity '||p_plan_quantity);
621: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch type '||p_batch_type);
622: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_start_date '||p_start_date);
623: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date '||p_end_date);
624:
625: -- Bug: 8625112 Vpedarla
626: IF p_effectivity_id is not null then

Line 623: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date '||p_end_date);

619: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_effectivity_id '||p_effectivity_id);
620: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_plan_quantity '||p_plan_quantity);
621: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch type '||p_batch_type);
622: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_start_date '||p_start_date);
623: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date '||p_end_date);
624:
625: -- Bug: 8625112 Vpedarla
626: IF p_effectivity_id is not null then
627: OPEN Cur_get_item_uoms;

Line 633: FND_FILE.PUT_LINE(FND_FILE.LOG,' Item UOM '||l_prim_uom||' different from validity rule uom '||l_rec_uom);

629: CLOSE Cur_get_item_uoms;
630:
631:
632: IF (l_prim_uom <> l_rec_uom ) THEN
633: FND_FILE.PUT_LINE(FND_FILE.LOG,' Item UOM '||l_prim_uom||' different from validity rule uom '||l_rec_uom);
634: l_new_plan_qty := inv_convert.inv_um_convert(
635: p_inventory_item_id ,
636: NULL,
637: p_organization_id,

Line 644: FND_FILE.PUT_LINE(FND_FILE.LOG,'New plan quantity in validity rule uom -'||l_new_plan_qty );

640: l_prim_uom,
641: l_rec_uom,
642: NULL,
643: NULL);
644: FND_FILE.PUT_LINE(FND_FILE.LOG,'New plan quantity in validity rule uom -'||l_new_plan_qty );
645: ELSE
646: FND_FILE.PUT_LINE(FND_FILE.LOG,' No effectivity id ');
647: l_new_plan_qty := p_plan_quantity ;
648: END IF;

Line 646: FND_FILE.PUT_LINE(FND_FILE.LOG,' No effectivity id ');

642: NULL,
643: NULL);
644: FND_FILE.PUT_LINE(FND_FILE.LOG,'New plan quantity in validity rule uom -'||l_new_plan_qty );
645: ELSE
646: FND_FILE.PUT_LINE(FND_FILE.LOG,' No effectivity id ');
647: l_new_plan_qty := p_plan_quantity ;
648: END IF;
649: END IF;
650:

Line 659: FND_FILE.PUT_LINE(FND_FILE.LOG,'After validate Effectivity ');

655: p_start_date,p_end_date,
656: l_recipe_id,l_return
657: );
658:
659: FND_FILE.PUT_LINE(FND_FILE.LOG,'After validate Effectivity ');
660: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_recipe_id '||l_recipe_id);
661: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_return '||l_return);
662:
663: IF l_return <> 0 THEN

Line 660: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_recipe_id '||l_recipe_id);

656: l_recipe_id,l_return
657: );
658:
659: FND_FILE.PUT_LINE(FND_FILE.LOG,'After validate Effectivity ');
660: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_recipe_id '||l_recipe_id);
661: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_return '||l_return);
662:
663: IF l_return <> 0 THEN
664: l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := p_effectivity_id;

Line 661: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_return '||l_return);

657: );
658:
659: FND_FILE.PUT_LINE(FND_FILE.LOG,'After validate Effectivity ');
660: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_recipe_id '||l_recipe_id);
661: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_return '||l_return);
662:
663: IF l_return <> 0 THEN
664: l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := p_effectivity_id;
665: ELSE

Line 683: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Code '||l_cal_code);

679: ELSE
680: x_contiguity_override := 'F' ;
681: END IF;
682:
683: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Code '||l_cal_code);
684: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||to_char(p_start_date,'MM/DD/YYYY HH24:MI:SS'));
685: /*
686: IF p_start_date IS NOT NULL THEN
687: IF l_profile = 'Y' THEN

Line 684: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||to_char(p_start_date,'MM/DD/YYYY HH24:MI:SS'));

680: x_contiguity_override := 'F' ;
681: END IF;
682:
683: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Code '||l_cal_code);
684: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||to_char(p_start_date,'MM/DD/YYYY HH24:MI:SS'));
685: /*
686: IF p_start_date IS NOT NULL THEN
687: IF l_profile = 'Y' THEN
688: IF NOT gmp_calendar_api.is_working_daytime (

Line 702: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||to_char(p_end_date,'MM/DD/YYYY HH24:MI:SS'));

698:
699: END IF;
700: */
701:
702: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||to_char(p_end_date,'MM/DD/YYYY HH24:MI:SS'));
703: IF p_end_date IS NOT NULL THEN
704: IF l_profile = 'Y' THEN
705: IF NOT gmp_calendar_api.is_working_daytime (
706: 1,

Line 730: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Nearest End Date = '||to_char(l_end_date,'MM/DD/YYYY HH24:MI:SS'));

726: ) ;
727:
728: IF x_return_status = 'S' THEN
729: l_gme_batch_header.plan_cmplt_date := l_end_date;
730: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Nearest End Date = '||to_char(l_end_date,'MM/DD/YYYY HH24:MI:SS'));
731: ELSE
732: RAISE GMP_SHOP_NON_WKG_END ;
733: END IF;
734: END IF;

Line 774: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);

770: x_message_list := NULL;
771: x_return_status := NULL ;
772:
773: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NOT_ONE_CONT');
774: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
775:
776: gme_api_pub.create_batch(
777: p_api_version => 2.0
778: ,p_validation_level => 100

Line 808: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item Number '||l_item_no||' - '||FND_MESSAGE.GET);

804: ELSE
805: FND_MESSAGE.SET_NAME('GME','GME_BATCH_CREATED');
806: FND_MESSAGE.SET_TOKEN('BATCH_NO',x_gme_batch_header2.batch_no);
807: END IF;
808: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item Number '||l_item_no||' - '||FND_MESSAGE.GET);
809: v_batch_no := x_gme_batch_header2.batch_no;
810: v_start_date := x_GME_BATCH_HEADER2.plan_start_date;
811: v_end_date := x_GME_BATCH_HEADER2.PLAN_CMPLT_DATE;
812: v_due_date := x_GME_BATCH_HEADER2.due_date;

Line 833: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);

829:
830: FND_MESSAGE.SET_NAME('GME','GME_BATCH_CREATED');
831: FND_MESSAGE.SET_TOKEN('BATCH_NO',x_gme_batch_header2.batch_no);
832: END IF;
833: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
834:
835: ELSIF (x_return_status = 'V') THEN
836: -- Inventory shortage, Production Batch was sucessfully inserte.
837:

Line 840: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET||'-'||v_batch_no);

836: -- Inventory shortage, Production Batch was sucessfully inserte.
837:
838: v_batch_no := x_gme_batch_header2.batch_no;
839: FND_MESSAGE.SET_NAME('GME','GME_INV_SHORTAGES');
840: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET||'-'||v_batch_no);
841: END IF;
842:
843: UPDATE gmp_aps_output_tbl
844: SET processed_ind = 0 ,

Line 872: FND_FILE.PUT_LINE ( FND_FILE.LOG,'GMP Item Effectivity for Group Id = '

868:
869: EXCEPTION
870: WHEN GMP_CHECK_EFFECTIVITY THEN
871: -- B4610275 changed the message to include Group ID
872: FND_FILE.PUT_LINE ( FND_FILE.LOG,'GMP Item Effectivity for Group Id = '
873: || p_process_id || ' is Invalid for Item_no(id) = '||l_item_no ||
874: '(' ||p_inventory_item_id ||')' );
875: FND_MESSAGE.SET_NAME('GME','GME_INVALID_VALIDITY_RULE_PROD');
876: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);

Line 876: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);

872: FND_FILE.PUT_LINE ( FND_FILE.LOG,'GMP Item Effectivity for Group Id = '
873: || p_process_id || ' is Invalid for Item_no(id) = '||l_item_no ||
874: '(' ||p_inventory_item_id ||')' );
875: FND_MESSAGE.SET_NAME('GME','GME_INVALID_VALIDITY_RULE_PROD');
876: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
877:
878:
879: --Bug#6414610 KBANDDYO uncommented following code
880: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN

Line 889: FND_FILE.PUT_LINE(FND_FILE.LOG,'Message from GMP ');

885: '(' ||P_Inventory_Item_Id ||')';
886: retcode := 1; /* Warning */
887: -- vkinduri bug # 15863070 End
888: WHEN GMP_SHOP_NON_WKG_START THEN
889: FND_FILE.PUT_LINE(FND_FILE.LOG,'Message from GMP ');
890: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NON_WKG');
891: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_start_date,'MM/DD/YYYY HH24:MI:SS'));
892: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
893:

Line 892: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);

888: WHEN GMP_SHOP_NON_WKG_START THEN
889: FND_FILE.PUT_LINE(FND_FILE.LOG,'Message from GMP ');
890: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NON_WKG');
891: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_start_date,'MM/DD/YYYY HH24:MI:SS'));
892: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
893:
894: WHEN GMP_SHOP_NON_WKG_END THEN
895: FND_FILE.PUT_LINE(FND_FILE.LOG,'Message from GMP 2 ');
896: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NON_WKG');

Line 895: FND_FILE.PUT_LINE(FND_FILE.LOG,'Message from GMP 2 ');

891: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_start_date,'MM/DD/YYYY HH24:MI:SS'));
892: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
893:
894: WHEN GMP_SHOP_NON_WKG_END THEN
895: FND_FILE.PUT_LINE(FND_FILE.LOG,'Message from GMP 2 ');
896: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NON_WKG');
897: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_end_date,'MM/DD/YYYY HH24:MI:SS'));
898: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
899:

Line 898: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);

894: WHEN GMP_SHOP_NON_WKG_END THEN
895: FND_FILE.PUT_LINE(FND_FILE.LOG,'Message from GMP 2 ');
896: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NON_WKG');
897: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_end_date,'MM/DD/YYYY HH24:MI:SS'));
898: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
899:
900: WHEN ERROR_MESSAGE THEN
901: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error - Status is E or U '||sqlerrm);
902: FOR i in 1..fnd_msg_pub.count_msg LOOP

Line 901: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error - Status is E or U '||sqlerrm);

897: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_end_date,'MM/DD/YYYY HH24:MI:SS'));
898: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
899:
900: WHEN ERROR_MESSAGE THEN
901: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error - Status is E or U '||sqlerrm);
902: FOR i in 1..fnd_msg_pub.count_msg LOOP
903: FND_MSG_PUB.Get(
904: p_msg_index => i,
905: p_data => x_data,

Line 909: FND_FILE.PUT_LINE(FND_FILE.LOG,':'|| i || ':' || x_data );

905: p_data => x_data,
906: p_encoded => FND_API.G_FALSE,
907: p_msg_index_out => l_dummy_cnt);
908:
909: FND_FILE.PUT_LINE(FND_FILE.LOG,':'|| i || ':' || x_data );
910: END LOOP ;
911:
912: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
913: NULL;

Line 916: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Create New Batch '||sqlerrm);

912: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
913: NULL;
914: END IF;
915: WHEN OTHERS THEN
916: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Create New Batch '||sqlerrm);
917:
918: END create_new_batch;
919:
920: /*

Line 984: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error Validate Effectivities '||sqlerrm);

980:
981:
982: EXCEPTION
983: WHEN OTHERS THEN
984: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error Validate Effectivities '||sqlerrm);
985: END validate_effectivities;
986:
987: /*
988: REM+========================================================================+

Line 1017: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling GMP APS Writer program ');

1013: BEGIN
1014: err_msg := '' ;
1015: ret_code := -1;
1016:
1017: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling GMP APS Writer program ');
1018: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch Id '||p_batch_id);
1019: FND_FILE.PUT_LINE(FND_FILE.LOG,'process Id '||p_process_id);
1020: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id '||p_header_id);
1021: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);

Line 1018: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch Id '||p_batch_id);

1014: err_msg := '' ;
1015: ret_code := -1;
1016:
1017: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling GMP APS Writer program ');
1018: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch Id '||p_batch_id);
1019: FND_FILE.PUT_LINE(FND_FILE.LOG,'process Id '||p_process_id);
1020: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id '||p_header_id);
1021: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);
1022: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);

Line 1019: FND_FILE.PUT_LINE(FND_FILE.LOG,'process Id '||p_process_id);

1015: ret_code := -1;
1016:
1017: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling GMP APS Writer program ');
1018: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch Id '||p_batch_id);
1019: FND_FILE.PUT_LINE(FND_FILE.LOG,'process Id '||p_process_id);
1020: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id '||p_header_id);
1021: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);
1022: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);
1023: FND_FILE.PUT_LINE(FND_FILE.LOG,'Req completion = '||p_required_completion);

Line 1020: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id '||p_header_id);

1016:
1017: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling GMP APS Writer program ');
1018: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch Id '||p_batch_id);
1019: FND_FILE.PUT_LINE(FND_FILE.LOG,'process Id '||p_process_id);
1020: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id '||p_header_id);
1021: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);
1022: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);
1023: FND_FILE.PUT_LINE(FND_FILE.LOG,'Req completion = '||p_required_completion);
1024: FND_FILE.PUT_LINE(FND_FILE.LOG,'Priority = '||p_order_priority);

Line 1021: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);

1017: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling GMP APS Writer program ');
1018: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch Id '||p_batch_id);
1019: FND_FILE.PUT_LINE(FND_FILE.LOG,'process Id '||p_process_id);
1020: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id '||p_header_id);
1021: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);
1022: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);
1023: FND_FILE.PUT_LINE(FND_FILE.LOG,'Req completion = '||p_required_completion);
1024: FND_FILE.PUT_LINE(FND_FILE.LOG,'Priority = '||p_order_priority);
1025: FND_FILE.PUT_LINE(FND_FILE.LOG,'Orgn Id = '||p_organization_id);

Line 1022: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);

1018: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch Id '||p_batch_id);
1019: FND_FILE.PUT_LINE(FND_FILE.LOG,'process Id '||p_process_id);
1020: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id '||p_header_id);
1021: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);
1022: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);
1023: FND_FILE.PUT_LINE(FND_FILE.LOG,'Req completion = '||p_required_completion);
1024: FND_FILE.PUT_LINE(FND_FILE.LOG,'Priority = '||p_order_priority);
1025: FND_FILE.PUT_LINE(FND_FILE.LOG,'Orgn Id = '||p_organization_id);
1026: FND_FILE.PUT_LINE(FND_FILE.LOG,'Eff Id = '||p_eff_id);

Line 1023: FND_FILE.PUT_LINE(FND_FILE.LOG,'Req completion = '||p_required_completion);

1019: FND_FILE.PUT_LINE(FND_FILE.LOG,'process Id '||p_process_id);
1020: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id '||p_header_id);
1021: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);
1022: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);
1023: FND_FILE.PUT_LINE(FND_FILE.LOG,'Req completion = '||p_required_completion);
1024: FND_FILE.PUT_LINE(FND_FILE.LOG,'Priority = '||p_order_priority);
1025: FND_FILE.PUT_LINE(FND_FILE.LOG,'Orgn Id = '||p_organization_id);
1026: FND_FILE.PUT_LINE(FND_FILE.LOG,'Eff Id = '||p_eff_id);
1027:

Line 1024: FND_FILE.PUT_LINE(FND_FILE.LOG,'Priority = '||p_order_priority);

1020: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id '||p_header_id);
1021: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);
1022: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);
1023: FND_FILE.PUT_LINE(FND_FILE.LOG,'Req completion = '||p_required_completion);
1024: FND_FILE.PUT_LINE(FND_FILE.LOG,'Priority = '||p_order_priority);
1025: FND_FILE.PUT_LINE(FND_FILE.LOG,'Orgn Id = '||p_organization_id);
1026: FND_FILE.PUT_LINE(FND_FILE.LOG,'Eff Id = '||p_eff_id);
1027:
1028: GMP_APS_WRITER.main_process(p_batch_id,

Line 1025: FND_FILE.PUT_LINE(FND_FILE.LOG,'Orgn Id = '||p_organization_id);

1021: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);
1022: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);
1023: FND_FILE.PUT_LINE(FND_FILE.LOG,'Req completion = '||p_required_completion);
1024: FND_FILE.PUT_LINE(FND_FILE.LOG,'Priority = '||p_order_priority);
1025: FND_FILE.PUT_LINE(FND_FILE.LOG,'Orgn Id = '||p_organization_id);
1026: FND_FILE.PUT_LINE(FND_FILE.LOG,'Eff Id = '||p_eff_id);
1027:
1028: GMP_APS_WRITER.main_process(p_batch_id,
1029: p_process_id,

Line 1026: FND_FILE.PUT_LINE(FND_FILE.LOG,'Eff Id = '||p_eff_id);

1022: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);
1023: FND_FILE.PUT_LINE(FND_FILE.LOG,'Req completion = '||p_required_completion);
1024: FND_FILE.PUT_LINE(FND_FILE.LOG,'Priority = '||p_order_priority);
1025: FND_FILE.PUT_LINE(FND_FILE.LOG,'Orgn Id = '||p_organization_id);
1026: FND_FILE.PUT_LINE(FND_FILE.LOG,'Eff Id = '||p_eff_id);
1027:
1028: GMP_APS_WRITER.main_process(p_batch_id,
1029: p_process_id,
1030: p_header_id,

Line 1053: FND_FILE.PUT_LINE(FND_FILE.LOG,'Return from the main process is '||l_msg_data);

1049: p_msg_index =>FND_MSG_PUB.Count_msg,
1050: p_encoded => 'F') ;
1051:
1052: IF l_msg_data is NOT NULL THEN
1053: FND_FILE.PUT_LINE(FND_FILE.LOG,'Return from the main process is '||l_msg_data);
1054: END IF ;
1055: END IF ;
1056:
1057: EXCEPTION

Line 1059: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in process scheduling details create '||p_batch_id||'-'||sqlerrm);

1055: END IF ;
1056:
1057: EXCEPTION
1058: WHEN OTHERS THEN
1059: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in process scheduling details create '||p_batch_id||'-'||sqlerrm);
1060: END scheduling_details_create ;
1061:
1062: /*
1063: REM+=========================================================================+

Line 1183: FND_FILE.PUT_LINE(FND_FILE.LOG,'Now Rescheduling Batch = ' || l_batch_no);

1179: l_old_pst, expct_cmplt_date,
1180: l_recipe_validity_rule_id, l_recipe_id ;
1181: CLOSE Cur_get_batch_data;
1182:
1183: FND_FILE.PUT_LINE(FND_FILE.LOG,'Now Rescheduling Batch = ' || l_batch_no);
1184:
1185: /* Calculate plan_start_date, as APS is not sending in
1186: wip_job_schedule_interface */
1187: l_plan_start_Date := p_start_date ;

Line 1213: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);

1209: IF ((l_batch_status = 2) AND (l_old_pst > l_plan_start_date))
1210: THEN
1211: -- Do not reschedule via APS or GME way
1212: FND_MESSAGE.SET_NAME('GMP','GMP_WIP_RESCHEDULE_IN_NA');
1213: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1214: v_scheduling_method := -1 ;
1215: END IF;
1216:
1217: -- Bug: 8663941 Vpedarla

Line 1223: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before validate Effectivity ');

1219: OPEN Cur_get_item_uoms(l_recipe_validity_rule_id);
1220: FETCH Cur_get_item_uoms INTO l_item_no, l_item_id ;
1221: CLOSE Cur_get_item_uoms;
1222:
1223: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before validate Effectivity ');
1224: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_organization_id '||p_organization_id);
1225: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_effectivity_id '||l_recipe_validity_rule_id);
1226: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inventory_item_id '||l_item_id);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_start_date '||p_start_date);

Line 1224: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_organization_id '||p_organization_id);

1220: FETCH Cur_get_item_uoms INTO l_item_no, l_item_id ;
1221: CLOSE Cur_get_item_uoms;
1222:
1223: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before validate Effectivity ');
1224: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_organization_id '||p_organization_id);
1225: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_effectivity_id '||l_recipe_validity_rule_id);
1226: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inventory_item_id '||l_item_id);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_start_date '||p_start_date);
1228: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date '||p_end_date);

Line 1225: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_effectivity_id '||l_recipe_validity_rule_id);

1221: CLOSE Cur_get_item_uoms;
1222:
1223: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before validate Effectivity ');
1224: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_organization_id '||p_organization_id);
1225: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_effectivity_id '||l_recipe_validity_rule_id);
1226: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inventory_item_id '||l_item_id);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_start_date '||p_start_date);
1228: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date '||p_end_date);
1229:

Line 1226: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inventory_item_id '||l_item_id);

1222:
1223: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before validate Effectivity ');
1224: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_organization_id '||p_organization_id);
1225: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_effectivity_id '||l_recipe_validity_rule_id);
1226: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inventory_item_id '||l_item_id);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_start_date '||p_start_date);
1228: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date '||p_end_date);
1229:
1230: validate_effectivities(p_organization_id,

Line 1227: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_start_date '||p_start_date);

1223: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before validate Effectivity ');
1224: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_organization_id '||p_organization_id);
1225: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_effectivity_id '||l_recipe_validity_rule_id);
1226: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inventory_item_id '||l_item_id);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_start_date '||p_start_date);
1228: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date '||p_end_date);
1229:
1230: validate_effectivities(p_organization_id,
1231: l_item_id,

Line 1228: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date '||p_end_date);

1224: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_organization_id '||p_organization_id);
1225: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_effectivity_id '||l_recipe_validity_rule_id);
1226: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inventory_item_id '||l_item_id);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_start_date '||p_start_date);
1228: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date '||p_end_date);
1229:
1230: validate_effectivities(p_organization_id,
1231: l_item_id,
1232: l_recipe_validity_rule_id, to_number(NULL) , -- bug: 8625112

Line 1238: FND_FILE.PUT_LINE(FND_FILE.LOG,'After validate Effectivity ');

1234: p_start_date,p_end_date,
1235: l_val_recipe_id,l_val_return
1236: );
1237:
1238: FND_FILE.PUT_LINE(FND_FILE.LOG,'After validate Effectivity ');
1239: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_val_recipe_id '||l_val_recipe_id);
1240: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_val_return '||l_val_return);
1241:
1242: IF l_val_return <> 0 THEN

Line 1239: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_val_recipe_id '||l_val_recipe_id);

1235: l_val_recipe_id,l_val_return
1236: );
1237:
1238: FND_FILE.PUT_LINE(FND_FILE.LOG,'After validate Effectivity ');
1239: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_val_recipe_id '||l_val_recipe_id);
1240: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_val_return '||l_val_return);
1241:
1242: IF l_val_return <> 0 THEN
1243: l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := l_recipe_validity_rule_id;

Line 1240: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_val_return '||l_val_return);

1236: );
1237:
1238: FND_FILE.PUT_LINE(FND_FILE.LOG,'After validate Effectivity ');
1239: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_val_recipe_id '||l_val_recipe_id);
1240: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_val_return '||l_val_return);
1241:
1242: IF l_val_return <> 0 THEN
1243: l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := l_recipe_validity_rule_id;
1244: ELSE

Line 1321: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);

1317: 0,
1318: x_return_status ) THEN
1319: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NON_WKG');
1320: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_start_date,'MM/DD/YYYY HH24:MI:SS'));
1321: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1322: END IF;
1323: END IF;
1324: END IF; */
1325:

Line 1352: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);

1348: ) ;
1349:
1350: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NON_WKG');
1351: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_end_date,'MM/DD/YYYY HH24:MI:SS'));
1352: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1353:
1354: IF x_return_status = 'S' THEN
1355: l_gme_batch_header.plan_cmplt_date := l_end_date;
1356: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Nearest End Date = '||to_char(l_end_date,'MM/DD/YYYY HH24:MI:SS'));

Line 1356: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Nearest End Date = '||to_char(l_end_date,'MM/DD/YYYY HH24:MI:SS'));

1352: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1353:
1354: IF x_return_status = 'S' THEN
1355: l_gme_batch_header.plan_cmplt_date := l_end_date;
1356: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Nearest End Date = '||to_char(l_end_date,'MM/DD/YYYY HH24:MI:SS'));
1357: ELSE
1358: RAISE GMP_SHOP_NON_WKG_END ;
1359: END IF;
1360: ----Bug: 6265867 Teva changes Ends

Line 1364: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);

1360: ----Bug: 6265867 Teva changes Ends
1361:
1362: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NON_WKG');
1363: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_end_date,'MM/DD/YYYY HH24:MI:SS'));
1364: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1365: END IF;
1366: END IF;
1367: END IF;
1368:

Line 1398: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);

1394:
1395: IF x_return_status = 'C' THEN
1396:
1397: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NOT_ONE_CONT');
1398: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1399:
1400: gme_api_pub.reschedule_batch(
1401: p_api_version => 2
1402: ,p_validation_level => 100

Line 1420: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET||' Return Success');

1416: IF X_return_status <> 'S' THEN
1417: RAISE ERROR_MESSAGE;
1418: ELSE
1419: FND_MESSAGE.SET_NAME('GME','GME_RESCHEDULE');
1420: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET||' Return Success');
1421:
1422: -- Vpedarla Bug: 8348883 start
1423: IF l_update_due_date = 1 THEN
1424: FND_FILE.PUT_LINE ( FND_FILE.LOG,'due date update');

Line 1424: FND_FILE.PUT_LINE ( FND_FILE.LOG,'due date update');

1420: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET||' Return Success');
1421:
1422: -- Vpedarla Bug: 8348883 start
1423: IF l_update_due_date = 1 THEN
1424: FND_FILE.PUT_LINE ( FND_FILE.LOG,'due date update');
1425: UPDATE gme_batch_header
1426: SET due_date = p_required_completion
1427: WHERE BATCH_ID = l_gme_batch_header.batch_id;
1428: END IF;

Line 1445: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);

1441:
1442: ELSE
1443: FND_MESSAGE.SET_NAME('GMP','MR_USE_PM_RESP_TO_RESCHEDULE');
1444: FND_MESSAGE.SET_TOKEN('BATCH_NO',l_batch_no);
1445: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1446: END IF; /* } */
1447:
1448: EXCEPTION
1449: WHEN GMP_CHECK_EFFECTIVITY THEN

Line 1451: FND_FILE.PUT_LINE ( FND_FILE.LOG,'GMP Item Effectivity for Group Id = '

1447:
1448: EXCEPTION
1449: WHEN GMP_CHECK_EFFECTIVITY THEN
1450: -- B4610275 changed the message to include Group ID
1451: FND_FILE.PUT_LINE ( FND_FILE.LOG,'GMP Item Effectivity for Group Id = '
1452: || p_process_id || ' is Invalid for Item_no(id) = '||l_item_no ||
1453: '(' ||l_item_id ||')' );
1454: FND_MESSAGE.SET_NAME('GME','GME_INVALID_VALIDITY_RULE_PROD');
1455: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);

Line 1455: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);

1451: FND_FILE.PUT_LINE ( FND_FILE.LOG,'GMP Item Effectivity for Group Id = '
1452: || p_process_id || ' is Invalid for Item_no(id) = '||l_item_no ||
1453: '(' ||l_item_id ||')' );
1454: FND_MESSAGE.SET_NAME('GME','GME_INVALID_VALIDITY_RULE_PROD');
1455: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1456:
1457:
1458: --Bug#6414610 KBANDDYO uncommented following code
1459: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN

Line 1463: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Reschedule Batch - Status Not in S '||p_batch_id||'-'||sqlerrm);

1459: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
1460: NULL;
1461: END IF;
1462: WHEN ERROR_MESSAGE THEN
1463: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Reschedule Batch - Status Not in S '||p_batch_id||'-'||sqlerrm);
1464:
1465: FOR i in 1..fnd_msg_pub.count_msg LOOP
1466: FND_MSG_PUB.Get(
1467: p_msg_index => i,

Line 1472: FND_FILE.PUT_LINE(FND_FILE.LOG,':'|| i || ':' || x_data );

1468: p_data => x_data,
1469: p_encoded => FND_API.G_FALSE,
1470: p_msg_index_out => l_dummy_cnt);
1471:
1472: FND_FILE.PUT_LINE(FND_FILE.LOG,':'|| i || ':' || x_data );
1473: END LOOP ;
1474:
1475: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
1476: NULL;

Line 1479: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Reschedule Batch '||sqlerrm);

1475: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
1476: NULL;
1477: END IF;
1478: WHEN OTHERS THEN
1479: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Reschedule Batch '||sqlerrm);
1480: END reschedule_batch;
1481:
1482: /*
1483: REM+=======================================================================+

Line 1537: FND_FILE.PUT_LINE(FND_FILE.LOG,'::'||to_char(ret_code) ||'::'||l_msg_data);

1533: l_msg_data := FND_MSG_PUB.GET(
1534: p_msg_index =>FND_MSG_PUB.Count_msg,
1535: p_encoded => 'F') ;
1536: IF l_msg_data is NOT NULL THEN
1537: FND_FILE.PUT_LINE(FND_FILE.LOG,'::'||to_char(ret_code) ||'::'||l_msg_data);
1538: END IF ;
1539:
1540: END IF ;
1541: return_status := ret_code ;

Line 1545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in process scheduling details Reschedule '||p_batch_id||'-'||sqlerrm);

1541: return_status := ret_code ;
1542:
1543: EXCEPTION
1544: WHEN OTHERS THEN
1545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in process scheduling details Reschedule '||p_batch_id||'-'||sqlerrm);
1546: END scheduling_details_resc;
1547:
1548: /*
1549: REM+========================================================================+

Line 1600: FND_FILE.PUT_LINE ( FND_FILE.LOG,'From cancel batch: ');

1596: OPEN get_batch_status;
1597: FETCH get_batch_status INTO l_batch_no,l_batch_status,
1598: l_effectivity_id, l_org_code, l_batch_type;
1599: CLOSE get_batch_status;
1600: FND_FILE.PUT_LINE ( FND_FILE.LOG,'From cancel batch: ');
1601: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_no = ' || l_batch_no);
1602: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_status = ' || l_batch_status);
1603: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_effectivity_id = ' || l_effectivity_id);
1604: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_org_code = ' || l_org_code);

Line 1601: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_no = ' || l_batch_no);

1597: FETCH get_batch_status INTO l_batch_no,l_batch_status,
1598: l_effectivity_id, l_org_code, l_batch_type;
1599: CLOSE get_batch_status;
1600: FND_FILE.PUT_LINE ( FND_FILE.LOG,'From cancel batch: ');
1601: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_no = ' || l_batch_no);
1602: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_status = ' || l_batch_status);
1603: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_effectivity_id = ' || l_effectivity_id);
1604: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_org_code = ' || l_org_code);
1605: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_type = ' || l_batch_type);

Line 1602: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_status = ' || l_batch_status);

1598: l_effectivity_id, l_org_code, l_batch_type;
1599: CLOSE get_batch_status;
1600: FND_FILE.PUT_LINE ( FND_FILE.LOG,'From cancel batch: ');
1601: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_no = ' || l_batch_no);
1602: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_status = ' || l_batch_status);
1603: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_effectivity_id = ' || l_effectivity_id);
1604: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_org_code = ' || l_org_code);
1605: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_type = ' || l_batch_type);
1606:

Line 1603: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_effectivity_id = ' || l_effectivity_id);

1599: CLOSE get_batch_status;
1600: FND_FILE.PUT_LINE ( FND_FILE.LOG,'From cancel batch: ');
1601: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_no = ' || l_batch_no);
1602: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_status = ' || l_batch_status);
1603: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_effectivity_id = ' || l_effectivity_id);
1604: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_org_code = ' || l_org_code);
1605: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_type = ' || l_batch_type);
1606:
1607: IF l_batch_status <> 1 THEN

Line 1604: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_org_code = ' || l_org_code);

1600: FND_FILE.PUT_LINE ( FND_FILE.LOG,'From cancel batch: ');
1601: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_no = ' || l_batch_no);
1602: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_status = ' || l_batch_status);
1603: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_effectivity_id = ' || l_effectivity_id);
1604: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_org_code = ' || l_org_code);
1605: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_type = ' || l_batch_type);
1606:
1607: IF l_batch_status <> 1 THEN
1608: FND_MESSAGE.SET_NAME('GMP','MR_INVALID_BATCH_STATUS_USE_GM');

Line 1605: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_type = ' || l_batch_type);

1601: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_no = ' || l_batch_no);
1602: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_status = ' || l_batch_status);
1603: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_effectivity_id = ' || l_effectivity_id);
1604: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_org_code = ' || l_org_code);
1605: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_batch_type = ' || l_batch_type);
1606:
1607: IF l_batch_status <> 1 THEN
1608: FND_MESSAGE.SET_NAME('GMP','MR_INVALID_BATCH_STATUS_USE_GM');
1609: FND_MESSAGE.SET_TOKEN('BATCH_NO',l_batch_no);

Line 1610: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);

1606:
1607: IF l_batch_status <> 1 THEN
1608: FND_MESSAGE.SET_NAME('GMP','MR_INVALID_BATCH_STATUS_USE_GM');
1609: FND_MESSAGE.SET_TOKEN('BATCH_NO',l_batch_no);
1610: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1611: ELSE
1612: -- Batch will be rescheduled via GME mechanism
1613: l_gme_batch_header.batch_id := p_batch_id ;
1614: l_gme_batch_header.organization_id := p_organization_id;

Line 1634: FND_FILE.PUT_LINE(FND_FILE.LOG,'- '||FND_MESSAGE.GET||l_batch_no);

1630: IF X_return_status <> 'S' THEN
1631: RAISE ERROR_MESSAGE;
1632: ELSE
1633: FND_MESSAGE.SET_NAME('GME','GME_API_BATCH_CANCELLED');
1634: FND_FILE.PUT_LINE(FND_FILE.LOG,'- '||FND_MESSAGE.GET||l_batch_no);
1635:
1636: UPDATE gmp_aps_output_tbl
1637: SET processed_ind = 0
1638: WHERE rowid = p_rowid

Line 1647: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Cancel Batch - Status Not in S '||p_batch_id||'-'||sqlerrm);

1643: END IF; /* } */
1644:
1645: EXCEPTION
1646: WHEN ERROR_MESSAGE THEN
1647: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Cancel Batch - Status Not in S '||p_batch_id||'-'||sqlerrm);
1648:
1649: FOR i in 1..fnd_msg_pub.count_msg LOOP
1650: FND_MSG_PUB.Get(
1651: p_msg_index => i,

Line 1656: FND_FILE.PUT_LINE(FND_FILE.LOG,':'|| i || ':' || x_data );

1652: p_data => x_data,
1653: p_encoded => FND_API.G_FALSE,
1654: p_msg_index_out => l_dummy_cnt);
1655:
1656: FND_FILE.PUT_LINE(FND_FILE.LOG,':'|| i || ':' || x_data );
1657: END LOOP ;
1658:
1659: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
1660: NULL;

Line 1663: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Cancel Batch '||sqlerrm);

1659: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
1660: NULL;
1661: END IF;
1662: WHEN OTHERS THEN
1663: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Cancel Batch '||sqlerrm);
1664: END cancel_batch;
1665:
1666: END GMPRELAP;
1667: