DBA Data[Home] [Help]

APPS.GMP_APS_OUTPUT_PKG dependencies on FND_FILE

Line 502: FND_FILE.PUT_LINE ( FND_FILE.LOG,'DO NOT DELETE DATA FROM WIP INTERFACE (Debug Mode)');

498: /* Following Lines delete the rows wip_job_schedule_interface after the rows are
499: inserted in gmp_aps_output_tbl */
500: BEGIN
501: IF mrp_debug_profile = 'Y' THEN
502: FND_FILE.PUT_LINE ( FND_FILE.LOG,'DO NOT DELETE DATA FROM WIP INTERFACE (Debug Mode)');
503: ELSE
504: FND_FILE.PUT_LINE ( FND_FILE.LOG,'DELETE DATA FROM WIP INTERFACE ');
505: IF delete_new_flag = 1 THEN
506: DELETE wip_job_schedule_interface

Line 504: FND_FILE.PUT_LINE ( FND_FILE.LOG,'DELETE DATA FROM WIP INTERFACE ');

500: BEGIN
501: IF mrp_debug_profile = 'Y' THEN
502: FND_FILE.PUT_LINE ( FND_FILE.LOG,'DO NOT DELETE DATA FROM WIP INTERFACE (Debug Mode)');
503: ELSE
504: FND_FILE.PUT_LINE ( FND_FILE.LOG,'DELETE DATA FROM WIP INTERFACE ');
505: IF delete_new_flag = 1 THEN
506: DELETE wip_job_schedule_interface
507: WHERE group_id = p_group_id
508: AND process_status = 1

Line 564: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Submitting the Req ');

560: /* B6167305 Start */
561: batch_fpo_profile := NVL(FND_PROFILE.VALUE('GMP_IMPLEMENT_SUGG_FPO_BATCH'),0);
562: /* B6167305 End */
563: lv_result := FND_REQUEST.SET_MODE(TRUE);
564: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Submitting the Req ');
565:
566: -- RDP B5454215 - Added 0 when calling the reqauest.
567: -- Make Batch as defult value since there is no user input
568: -- Vpedarla bug: 7902184 Modified fnd submit request for GMPRELAP

Line 584: FND_FILE.PUT_LINE(FND_FILE.LOG,' Submitted the Req X_conc_id -> '||X_conc_id);

580: NULL, -- To Date
581: batch_fpo_profile -- Order Type Batch/FPO /* B6167305 */
582: );
583:
584: FND_FILE.PUT_LINE(FND_FILE.LOG,' Submitted the Req X_conc_id -> '||X_conc_id);
585: --
586: IF X_conc_id = 0 THEN
587: RAISE ERROR_SUBMITTING_REQUEST;
588: ELSE

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

587: RAISE ERROR_SUBMITTING_REQUEST;
588: ELSE
589: FND_MESSAGE.SET_NAME('GMP','MR_REQ_SUBMITTED');
590: FND_MESSAGE.SET_TOKEN('CONC_ID', X_conc_id);
591: FND_FILE.PUT_LINE ( FND_FILE.LOG,'-'||FND_MESSAGE.GET);
592: COMMIT ;
593: END IF;
594: ELSE
595: FND_FILE.PUT_LINE(FND_FILE.LOG,'Profile implement APS Suggestions is NOT turned ON, Use concurrent program or Use the GMP forms to implement APS suggestions ');

Line 595: FND_FILE.PUT_LINE(FND_FILE.LOG,'Profile implement APS Suggestions is NOT turned ON, Use concurrent program or Use the GMP forms to implement APS suggestions ');

591: FND_FILE.PUT_LINE ( FND_FILE.LOG,'-'||FND_MESSAGE.GET);
592: COMMIT ;
593: END IF;
594: ELSE
595: FND_FILE.PUT_LINE(FND_FILE.LOG,'Profile implement APS Suggestions is NOT turned ON, Use concurrent program or Use the GMP forms to implement APS suggestions ');
596: END IF;
597:
598: EXCEPTION
599: WHEN ERROR_SUBMITTING_REQUEST THEN

Line 601: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Error submitting concurrent Request '||G_log_text);

597:
598: EXCEPTION
599: WHEN ERROR_SUBMITTING_REQUEST THEN
600: G_log_text := FND_MESSAGE.GET;
601: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Error submitting concurrent Request '||G_log_text);
602: retcode:=2; /* Error */
603: WHEN others THEN
604: errbuf := 'Call to Perform Auto release failed: ' ||sqlerrm;
605: retcode := 1; /* Warning */