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 221: FND_FILE.PUT_LINE ( FND_FILE.LOG,'===== Input Parameters ===== ');

217:
218: -- l_from_date := fnd_date.charDT_to_date(p_fdate);
219: -- l_to_date := fnd_date.charDT_to_date(p_tdate);
220:
221: FND_FILE.PUT_LINE ( FND_FILE.LOG,'===== Input Parameters ===== ');
222: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fitem_no = ' || p_fitem_no);
223: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_titem_no = ' || p_titem_no);
224: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fdate = ' || p_fdate);
225: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_tdate = ' || p_tdate);

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

218: -- l_from_date := fnd_date.charDT_to_date(p_fdate);
219: -- l_to_date := fnd_date.charDT_to_date(p_tdate);
220:
221: FND_FILE.PUT_LINE ( FND_FILE.LOG,'===== Input Parameters ===== ');
222: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fitem_no = ' || p_fitem_no);
223: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_titem_no = ' || p_titem_no);
224: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fdate = ' || p_fdate);
225: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_tdate = ' || p_tdate);
226: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_from_date = ' || l_from_date);

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

219: -- l_to_date := fnd_date.charDT_to_date(p_tdate);
220:
221: FND_FILE.PUT_LINE ( FND_FILE.LOG,'===== Input Parameters ===== ');
222: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fitem_no = ' || p_fitem_no);
223: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_titem_no = ' || p_titem_no);
224: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fdate = ' || p_fdate);
225: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_tdate = ' || p_tdate);
226: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_from_date = ' || l_from_date);
227: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_to_date = ' || l_to_date);

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

220:
221: FND_FILE.PUT_LINE ( FND_FILE.LOG,'===== Input Parameters ===== ');
222: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fitem_no = ' || p_fitem_no);
223: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_titem_no = ' || p_titem_no);
224: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fdate = ' || p_fdate);
225: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_tdate = ' || p_tdate);
226: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_from_date = ' || l_from_date);
227: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_to_date = ' || l_to_date);
228:

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

221: FND_FILE.PUT_LINE ( FND_FILE.LOG,'===== Input Parameters ===== ');
222: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fitem_no = ' || p_fitem_no);
223: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_titem_no = ' || p_titem_no);
224: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fdate = ' || p_fdate);
225: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_tdate = ' || p_tdate);
226: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_from_date = ' || l_from_date);
227: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_to_date = ' || l_to_date);
228:
229: IF l_updt_offsets = 1 THEN

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

222: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fitem_no = ' || p_fitem_no);
223: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_titem_no = ' || p_titem_no);
224: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fdate = ' || p_fdate);
225: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_tdate = ' || p_tdate);
226: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_from_date = ' || l_from_date);
227: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_to_date = ' || l_to_date);
228:
229: IF l_updt_offsets = 1 THEN
230: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Profile Update activity offset is set');

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

223: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_titem_no = ' || p_titem_no);
224: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_fdate = ' || p_fdate);
225: FND_FILE.PUT_LINE ( FND_FILE.LOG,'p_tdate = ' || p_tdate);
226: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_from_date = ' || l_from_date);
227: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_to_date = ' || l_to_date);
228:
229: IF l_updt_offsets = 1 THEN
230: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Profile Update activity offset is set');
231: ELSE

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

226: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_from_date = ' || l_from_date);
227: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_to_date = ' || l_to_date);
228:
229: IF l_updt_offsets = 1 THEN
230: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Profile Update activity offset is set');
231: ELSE
232: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Profile Update activity offset is not set');
233: END IF;
234:

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

228:
229: IF l_updt_offsets = 1 THEN
230: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Profile Update activity offset is set');
231: ELSE
232: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Profile Update activity offset is not set');
233: END IF;
234:
235: IF (l_to_date < l_from_date) THEN
236: RAISE CHECK_DATE;

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

255: FROM gme_parameters
256: WHERE organization_id = get_data_rec.organization_id ;
257:
258: v_batch_type := 10 ;
259: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Implementing FPOs ');
260: ELSE
261: -- Batch
262: SELECT BATCH_DOC_NUMBERING
263: INTO X_assignment_type

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

264: FROM gme_parameters
265: WHERE organization_id = get_data_rec.organization_id ;
266:
267: v_batch_type := 0 ;
268: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Implementing Batches ');
269: END IF;
270:
271: IF (X_assignment_type = 1) THEN -- Manual Numbering
272: RAISE MANUAL_DOC_TYPE;

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

300: gmp_aps_writer.update_activity_offsets (get_data_rec.batch_id);
301: END IF;
302:
303: ELSIF get_data_rec.action_type = 3 THEN /* Reschedule */
304: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Implementing Reschedule Batches ');
305:
306: reschedule_batch(
307: get_data_rec.process_id,
308: get_data_rec.organization_id,

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

317: get_data_rec.processed_ind,
318: get_data_rec.rowid
319: );
320:
321: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Batch Id - '|| get_data_rec.batch_id);
322:
323: /* B5897392 Rajesh Patangya firm Flag */
324: IF get_data_rec.firmed_ind = 1 THEN
325: UPDATE GME_BATCH_HEADER

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

334: END IF;
335:
336: ELSIF get_data_rec.action_type = -1 THEN /* Cancel */
337:
338: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Implementing Cancel Batches ');
339:
340: cancel_batch(
341: get_data_rec.process_id,
342: get_data_rec.organization_id,

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

364: EXCEPTION
365: WHEN MANUAL_DOC_TYPE THEN
366: errbuf := sqlerrm;
367: FND_MESSAGE.SET_NAME('GMP','SY_INVALID_MANUAL_DOC');
368: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
369: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cannot convert to Batch/FPO, Manual Doc Type '||sqlerrm);
370: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
371: NULL;
372: END IF;

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

365: WHEN MANUAL_DOC_TYPE THEN
366: errbuf := sqlerrm;
367: FND_MESSAGE.SET_NAME('GMP','SY_INVALID_MANUAL_DOC');
368: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
369: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cannot convert to Batch/FPO, Manual Doc Type '||sqlerrm);
370: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
371: NULL;
372: END IF;
373: retcode := '3';

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

374:
375: WHEN CHECK_DATE THEN
376: errbuf := sqlerrm;
377: FND_MESSAGE.SET_NAME('GMP','MR_INV_CALENDAR_RANGE');
378: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
379: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
380: NULL;
381: END IF;
382: retcode := '3';

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

383:
384: WHEN NO_ROWS THEN
385: errbuf := sqlerrm;
386: FND_MESSAGE.SET_NAME('GMA','SY_NO_ROWS_SELECTED');
387: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
388: --IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
389: /*Bug:6408133 GMPRELAP COMPLETES WITH WARNING WHEN THERE ARE NO ORDERS TO BE CONVERTED */
390:
391: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',NULL)) THEN

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

394: END IF;
395: retcode := '3';
396: WHEN OTHERS THEN
397: errbuf := sqlerrm;
398: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Implementing APS Plng Suggestions '||sqlerrm);
399: retcode := '2';
400:
401: END Implement_Aps_Plng_Sugg;
402:

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

495: resp_appl_id => NULL
496: );
497: fnd_profile.put ('AFLOG_LEVEL', '1');
498:
499: FND_FILE.PUT_LINE(FND_FILE.LOG,'New btach Processing for Group ID = ' || p_process_id || ' Header ID = ' || p_header_id);
500:
501: OPEN calendar_associated(p_organization_id);
502: FETCH calendar_associated INTO l_cal_code,l_org_code;
503: CLOSE calendar_associated;

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

561: ELSE
562: x_contiguity_override := 'F' ;
563: END IF;
564:
565: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Code '||l_cal_code);
566: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||to_char(p_start_date,'MM/DD/YYYY HH24:MI:SS'));
567: /*
568: IF p_start_date IS NOT NULL THEN
569: IF l_profile = 'Y' THEN

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

562: x_contiguity_override := 'F' ;
563: END IF;
564:
565: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calendar Code '||l_cal_code);
566: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||to_char(p_start_date,'MM/DD/YYYY HH24:MI:SS'));
567: /*
568: IF p_start_date IS NOT NULL THEN
569: IF l_profile = 'Y' THEN
570: IF NOT gmp_calendar_api.is_working_daytime (

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

580:
581: END IF;
582: */
583:
584: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||to_char(p_end_date,'MM/DD/YYYY HH24:MI:SS'));
585: IF p_end_date IS NOT NULL THEN
586: IF l_profile = 'Y' THEN
587: IF NOT gmp_calendar_api.is_working_daytime (
588: 1,

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

608: ) ;
609:
610: IF x_return_status = 'S' THEN
611: l_gme_batch_header.plan_cmplt_date := l_end_date;
612: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Nearest End Date = '||to_char(l_end_date,'MM/DD/YYYY HH24:MI:SS'));
613: ELSE
614: RAISE GMP_SHOP_NON_WKG_END ;
615: END IF;
616: END IF;

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

651: x_message_list := NULL;
652: x_return_status := NULL ;
653:
654: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NOT_ONE_CONT');
655: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
656:
657: gme_api_pub.create_batch(
658: p_api_version => 2.0
659: ,p_validation_level => 100

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

684: ELSE
685: FND_MESSAGE.SET_NAME('GME','GME_BATCH_CREATED');
686: FND_MESSAGE.SET_TOKEN('BATCH_NO',x_gme_batch_header2.batch_no);
687: END IF;
688: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item Number '||l_item_no||' - '||FND_MESSAGE.GET);
689: v_batch_no := x_gme_batch_header2.batch_no;
690: v_start_date := x_GME_BATCH_HEADER2.plan_start_date;
691: v_end_date := x_GME_BATCH_HEADER2.PLAN_CMPLT_DATE;
692: v_due_date := x_GME_BATCH_HEADER2.due_date;

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

709:
710: FND_MESSAGE.SET_NAME('GME','GME_BATCH_CREATED');
711: FND_MESSAGE.SET_TOKEN('BATCH_NO',x_gme_batch_header2.batch_no);
712: END IF;
713: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
714:
715: ELSIF (x_return_status = 'V') THEN
716: -- Inventory shortage, Production Batch was sucessfully inserte.
717:

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

716: -- Inventory shortage, Production Batch was sucessfully inserte.
717:
718: v_batch_no := x_gme_batch_header2.batch_no;
719: FND_MESSAGE.SET_NAME('GME','GME_INV_SHORTAGES');
720: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET||'-'||v_batch_no);
721: END IF;
722:
723: UPDATE gmp_aps_output_tbl
724: SET processed_ind = 0 ,

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

748:
749: EXCEPTION
750: WHEN GMP_CHECK_EFFECTIVITY THEN
751: -- B4610275 changed the message to include Group ID
752: FND_FILE.PUT_LINE ( FND_FILE.LOG,'GMP Item Effectivity for Group Id = '
753: || p_process_id || ' is Invalid for Item = '||l_item_no);
754: FND_MESSAGE.SET_NAME('GME','GME_INVALID_VALIDITY_RULE_PROD');
755: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
756:

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

751: -- B4610275 changed the message to include Group ID
752: FND_FILE.PUT_LINE ( FND_FILE.LOG,'GMP Item Effectivity for Group Id = '
753: || p_process_id || ' is Invalid for Item = '||l_item_no);
754: FND_MESSAGE.SET_NAME('GME','GME_INVALID_VALIDITY_RULE_PROD');
755: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
756:
757:
758: --Bug#6414610 KBANDDYO uncommented following code
759: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN

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

760: NULL;
761: END IF;
762:
763: WHEN GMP_SHOP_NON_WKG_START THEN
764: FND_FILE.PUT_LINE(FND_FILE.LOG,'Message from GMP ');
765: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NON_WKG');
766: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_start_date,'MM/DD/YYYY HH24:MI:SS'));
767: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
768:

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

763: WHEN GMP_SHOP_NON_WKG_START THEN
764: FND_FILE.PUT_LINE(FND_FILE.LOG,'Message from GMP ');
765: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NON_WKG');
766: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_start_date,'MM/DD/YYYY HH24:MI:SS'));
767: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
768:
769: WHEN GMP_SHOP_NON_WKG_END THEN
770: FND_FILE.PUT_LINE(FND_FILE.LOG,'Message from GMP 2 ');
771: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NON_WKG');

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

766: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_start_date,'MM/DD/YYYY HH24:MI:SS'));
767: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
768:
769: WHEN GMP_SHOP_NON_WKG_END THEN
770: FND_FILE.PUT_LINE(FND_FILE.LOG,'Message from GMP 2 ');
771: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NON_WKG');
772: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_end_date,'MM/DD/YYYY HH24:MI:SS'));
773: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
774:

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

769: WHEN GMP_SHOP_NON_WKG_END THEN
770: FND_FILE.PUT_LINE(FND_FILE.LOG,'Message from GMP 2 ');
771: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NON_WKG');
772: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_end_date,'MM/DD/YYYY HH24:MI:SS'));
773: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
774:
775: WHEN ERROR_MESSAGE THEN
776: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error - Status is E or U '||sqlerrm);
777: FOR i in 1..fnd_msg_pub.count_msg LOOP

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

772: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_end_date,'MM/DD/YYYY HH24:MI:SS'));
773: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
774:
775: WHEN ERROR_MESSAGE THEN
776: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error - Status is E or U '||sqlerrm);
777: FOR i in 1..fnd_msg_pub.count_msg LOOP
778: FND_MSG_PUB.Get(
779: p_msg_index => i,
780: p_data => x_data,

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

780: p_data => x_data,
781: p_encoded => FND_API.G_FALSE,
782: p_msg_index_out => l_dummy_cnt);
783:
784: FND_FILE.PUT_LINE(FND_FILE.LOG,':'|| i || ':' || x_data );
785: END LOOP ;
786:
787: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
788: NULL;

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

787: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
788: NULL;
789: END IF;
790: WHEN OTHERS THEN
791: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Create New Batch '||sqlerrm);
792:
793: END create_new_batch;
794:
795: /*

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

853: p_return := l_count ;
854:
855: EXCEPTION
856: WHEN OTHERS THEN
857: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error Validate Effectivities '||sqlerrm);
858: END validate_effectivities;
859:
860: /*
861: REM+========================================================================+

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

886: BEGIN
887: err_msg := '' ;
888: ret_code := -1;
889:
890: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling GMP APS Writer program ');
891: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch Id '||p_batch_id);
892: FND_FILE.PUT_LINE(FND_FILE.LOG,'process Id '||p_process_id);
893: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id '||p_header_id);
894: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);

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

887: err_msg := '' ;
888: ret_code := -1;
889:
890: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling GMP APS Writer program ');
891: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch Id '||p_batch_id);
892: FND_FILE.PUT_LINE(FND_FILE.LOG,'process Id '||p_process_id);
893: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id '||p_header_id);
894: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);
895: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);

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

888: ret_code := -1;
889:
890: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling GMP APS Writer program ');
891: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch Id '||p_batch_id);
892: FND_FILE.PUT_LINE(FND_FILE.LOG,'process Id '||p_process_id);
893: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id '||p_header_id);
894: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);
895: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);
896: FND_FILE.PUT_LINE(FND_FILE.LOG,'Req completion = '||p_required_completion);

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

889:
890: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling GMP APS Writer program ');
891: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch Id '||p_batch_id);
892: FND_FILE.PUT_LINE(FND_FILE.LOG,'process Id '||p_process_id);
893: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id '||p_header_id);
894: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);
895: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);
896: FND_FILE.PUT_LINE(FND_FILE.LOG,'Req completion = '||p_required_completion);
897: FND_FILE.PUT_LINE(FND_FILE.LOG,'Priority = '||p_order_priority);

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

890: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling GMP APS Writer program ');
891: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch Id '||p_batch_id);
892: FND_FILE.PUT_LINE(FND_FILE.LOG,'process Id '||p_process_id);
893: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id '||p_header_id);
894: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);
895: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);
896: FND_FILE.PUT_LINE(FND_FILE.LOG,'Req completion = '||p_required_completion);
897: FND_FILE.PUT_LINE(FND_FILE.LOG,'Priority = '||p_order_priority);
898: FND_FILE.PUT_LINE(FND_FILE.LOG,'Orgn Id = '||p_organization_id);

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

891: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch Id '||p_batch_id);
892: FND_FILE.PUT_LINE(FND_FILE.LOG,'process Id '||p_process_id);
893: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id '||p_header_id);
894: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);
895: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);
896: FND_FILE.PUT_LINE(FND_FILE.LOG,'Req completion = '||p_required_completion);
897: FND_FILE.PUT_LINE(FND_FILE.LOG,'Priority = '||p_order_priority);
898: FND_FILE.PUT_LINE(FND_FILE.LOG,'Orgn Id = '||p_organization_id);
899: FND_FILE.PUT_LINE(FND_FILE.LOG,'Eff Id = '||p_eff_id);

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

892: FND_FILE.PUT_LINE(FND_FILE.LOG,'process Id '||p_process_id);
893: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id '||p_header_id);
894: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);
895: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);
896: FND_FILE.PUT_LINE(FND_FILE.LOG,'Req completion = '||p_required_completion);
897: FND_FILE.PUT_LINE(FND_FILE.LOG,'Priority = '||p_order_priority);
898: FND_FILE.PUT_LINE(FND_FILE.LOG,'Orgn Id = '||p_organization_id);
899: FND_FILE.PUT_LINE(FND_FILE.LOG,'Eff Id = '||p_eff_id);
900:

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

893: FND_FILE.PUT_LINE(FND_FILE.LOG,'Header Id '||p_header_id);
894: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);
895: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);
896: FND_FILE.PUT_LINE(FND_FILE.LOG,'Req completion = '||p_required_completion);
897: FND_FILE.PUT_LINE(FND_FILE.LOG,'Priority = '||p_order_priority);
898: FND_FILE.PUT_LINE(FND_FILE.LOG,'Orgn Id = '||p_organization_id);
899: FND_FILE.PUT_LINE(FND_FILE.LOG,'Eff Id = '||p_eff_id);
900:
901: GMP_APS_WRITER.main_process(p_batch_id,

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

894: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start Date '||p_plan_start_date);
895: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);
896: FND_FILE.PUT_LINE(FND_FILE.LOG,'Req completion = '||p_required_completion);
897: FND_FILE.PUT_LINE(FND_FILE.LOG,'Priority = '||p_order_priority);
898: FND_FILE.PUT_LINE(FND_FILE.LOG,'Orgn Id = '||p_organization_id);
899: FND_FILE.PUT_LINE(FND_FILE.LOG,'Eff Id = '||p_eff_id);
900:
901: GMP_APS_WRITER.main_process(p_batch_id,
902: p_process_id,

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

895: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Date '||p_plan_end_date);
896: FND_FILE.PUT_LINE(FND_FILE.LOG,'Req completion = '||p_required_completion);
897: FND_FILE.PUT_LINE(FND_FILE.LOG,'Priority = '||p_order_priority);
898: FND_FILE.PUT_LINE(FND_FILE.LOG,'Orgn Id = '||p_organization_id);
899: FND_FILE.PUT_LINE(FND_FILE.LOG,'Eff Id = '||p_eff_id);
900:
901: GMP_APS_WRITER.main_process(p_batch_id,
902: p_process_id,
903: p_header_id,

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

922: p_msg_index =>FND_MSG_PUB.Count_msg,
923: p_encoded => 'F') ;
924:
925: IF l_msg_data is NOT NULL THEN
926: FND_FILE.PUT_LINE(FND_FILE.LOG,'Return from the main process is '||l_msg_data);
927: END IF ;
928: END IF ;
929:
930: EXCEPTION

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

928: END IF ;
929:
930: EXCEPTION
931: WHEN OTHERS THEN
932: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in process scheduling details create '||p_batch_id||'-'||sqlerrm);
933: END scheduling_details_create ;
934:
935: /*
936: REM+=========================================================================+

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

1023: l_old_pst, expct_cmplt_date,
1024: l_recipe_validity_rule_id, l_recipe_id ;
1025: CLOSE Cur_get_batch_data;
1026:
1027: FND_FILE.PUT_LINE(FND_FILE.LOG,'Now Rescheduling Batch = ' || l_batch_no);
1028:
1029: /* Calculate plan_start_date, as APS is not sending in
1030: wip_job_schedule_interface */
1031: l_plan_start_Date := p_start_date ;

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

1053: IF ((l_batch_status = 2) AND (l_old_pst > l_plan_start_date))
1054: THEN
1055: -- Do not reschedule via APS or GME way
1056: FND_MESSAGE.SET_NAME('GMP','GMP_WIP_RESCHEDULE_IN_NA');
1057: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1058: v_scheduling_method := -1 ;
1059: END IF;
1060:
1061: IF nvl(p_scheduling_method,2) = 1 THEN

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

1112: 0,
1113: x_return_status ) THEN
1114: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NON_WKG');
1115: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_start_date,'MM/DD/YYYY HH24:MI:SS'));
1116: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1117: END IF;
1118: END IF;
1119: END IF;
1120:

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

1143: ) ;
1144:
1145: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NON_WKG');
1146: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_end_date,'MM/DD/YYYY HH24:MI:SS'));
1147: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1148:
1149: IF x_return_status = 'S' THEN
1150: l_gme_batch_header.plan_cmplt_date := l_end_date;
1151: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Nearest End Date = '||to_char(l_end_date,'MM/DD/YYYY HH24:MI:SS'));

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

1147: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1148:
1149: IF x_return_status = 'S' THEN
1150: l_gme_batch_header.plan_cmplt_date := l_end_date;
1151: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Nearest End Date = '||to_char(l_end_date,'MM/DD/YYYY HH24:MI:SS'));
1152: ELSE
1153: RAISE GMP_SHOP_NON_WKG_END ;
1154: END IF;
1155: ----Bug: 6265867 Teva changes Ends

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

1155: ----Bug: 6265867 Teva changes Ends
1156:
1157: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NON_WKG');
1158: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_end_date,'MM/DD/YYYY HH24:MI:SS'));
1159: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1160: END IF;
1161: END IF;
1162: END IF;
1163:

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

1187:
1188: IF x_return_status = 'C' THEN
1189:
1190: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NOT_ONE_CONT');
1191: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1192:
1193: gme_api_pub.reschedule_batch(
1194: p_api_version => 2
1195: ,p_validation_level => 100

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

1209: IF X_return_status <> 'S' THEN
1210: RAISE ERROR_MESSAGE;
1211: ELSE
1212: FND_MESSAGE.SET_NAME('GME','GME_RESCHEDULE');
1213: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET||' Return Success');
1214: UPDATE gmp_aps_output_tbl
1215: SET processed_ind = 0
1216: WHERE rowid = p_rowid
1217: AND header_id = p_header_id

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

1224:
1225: ELSE
1226: FND_MESSAGE.SET_NAME('GMP','MR_USE_PM_RESP_TO_RESCHEDULE');
1227: FND_MESSAGE.SET_TOKEN('BATCH_NO',l_batch_no);
1228: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1229: END IF; /* } */
1230:
1231: EXCEPTION
1232: WHEN ERROR_MESSAGE THEN

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

1229: END IF; /* } */
1230:
1231: EXCEPTION
1232: WHEN ERROR_MESSAGE THEN
1233: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Reschedule Batch - Status Not in S '||p_batch_id||'-'||sqlerrm);
1234:
1235: FOR i in 1..fnd_msg_pub.count_msg LOOP
1236: FND_MSG_PUB.Get(
1237: p_msg_index => i,

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

1238: p_data => x_data,
1239: p_encoded => FND_API.G_FALSE,
1240: p_msg_index_out => l_dummy_cnt);
1241:
1242: FND_FILE.PUT_LINE(FND_FILE.LOG,':'|| i || ':' || x_data );
1243: END LOOP ;
1244:
1245: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
1246: NULL;

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

1245: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
1246: NULL;
1247: END IF;
1248: WHEN OTHERS THEN
1249: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Reschedule Batch '||sqlerrm);
1250: END reschedule_batch;
1251:
1252: /*
1253: REM+=======================================================================+

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

1303: l_msg_data := FND_MSG_PUB.GET(
1304: p_msg_index =>FND_MSG_PUB.Count_msg,
1305: p_encoded => 'F') ;
1306: IF l_msg_data is NOT NULL THEN
1307: FND_FILE.PUT_LINE(FND_FILE.LOG,'::'||to_char(ret_code) ||'::'||l_msg_data);
1308: END IF ;
1309:
1310: END IF ;
1311: return_status := ret_code ;

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

1311: return_status := ret_code ;
1312:
1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in process scheduling details Reschedule '||p_batch_id||'-'||sqlerrm);
1316: END scheduling_details_resc;
1317:
1318: /*
1319: REM+========================================================================+

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

1368:
1369: IF l_batch_status <> 1 THEN
1370: FND_MESSAGE.SET_NAME('GMP','MR_INVALID_BATCH_STATUS_USE_GM');
1371: FND_MESSAGE.SET_TOKEN('BATCH_NO',l_batch_no);
1372: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1373: ELSE
1374: -- Batch will be rescheduled via GME mechanism
1375: l_gme_batch_header.batch_id := p_batch_id ;
1376: l_gme_batch_header.organization_id := p_organization_id;

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

1391: IF X_return_status <> 'S' THEN
1392: RAISE ERROR_MESSAGE;
1393: ELSE
1394: FND_MESSAGE.SET_NAME('GME','GME_API_BATCH_CANCELLED');
1395: FND_FILE.PUT_LINE(FND_FILE.LOG,'- '||FND_MESSAGE.GET||l_batch_no);
1396:
1397: UPDATE gmp_aps_output_tbl
1398: SET processed_ind = 0
1399: WHERE rowid = p_rowid

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

1404: END IF; /* } */
1405:
1406: EXCEPTION
1407: WHEN ERROR_MESSAGE THEN
1408: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Cancel Batch - Status Not in S '||p_batch_id||'-'||sqlerrm);
1409:
1410: FOR i in 1..fnd_msg_pub.count_msg LOOP
1411: FND_MSG_PUB.Get(
1412: p_msg_index => i,

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

1413: p_data => x_data,
1414: p_encoded => FND_API.G_FALSE,
1415: p_msg_index_out => l_dummy_cnt);
1416:
1417: FND_FILE.PUT_LINE(FND_FILE.LOG,':'|| i || ':' || x_data );
1418: END LOOP ;
1419:
1420: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
1421: NULL;

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

1420: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
1421: NULL;
1422: END IF;
1423: WHEN OTHERS THEN
1424: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in Cancel Batch '||sqlerrm);
1425: END cancel_batch;
1426:
1427: END GMPRELAP;
1428: