DBA Data[Home] [Help]

APPS.GMPMRACT dependencies on FND_FILE

Line 180: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Bad User Code '||G_Buyer_plnr_id);

176:
177: OPEN Cur_Buyer_plnr_id(G_Buyer_Plnr);
178: FETCH Cur_Buyer_plnr_id INTO G_Buyer_plnr_id;
179: IF Cur_Buyer_plnr_id%NOTFOUND THEN
180: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Bad User Code '||G_Buyer_plnr_id);
181: G_Buyer_plnr_id := -1;
182: END IF;
183: CLOSE Cur_Buyer_plnr_id;
184:

Line 205: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Submitting the Req '||sqlerrm);

201: UPPER(V_user_print_style),
202: V_number_of_copies, TRUE, 'N');
203: END IF;
204: -- request is submitted to the concurrent manager
205: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Submitting the Req '||sqlerrm);
206:
207: X_conc_id := FND_REQUEST.SUBMIT_REQUEST('GMP','RIMR1USR','',
208: TO_CHAR(V_run_date1,'YYYY/MM/DD HH24:MI:SS'),
209: FALSE, TO_CHAR(G_matl_rep_id),

Line 223: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Submitted the Req '||sqlerrm);

219: '','','','','','','','','','',
220: '','','','','','','','','','',
221: '','','','','','','','','','');
222:
223: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Submitted the Req '||sqlerrm);
224: --
225: IF X_conc_id = 0 THEN
226: G_log_text := FND_MESSAGE.GET;
227: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);

Line 227: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);

223: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Submitted the Req '||sqlerrm);
224: --
225: IF X_conc_id = 0 THEN
226: G_log_text := FND_MESSAGE.GET;
227: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);
228: retcode:=2;
229: exit;
230: ELSE
231: COMMIT ;

Line 244: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);

240: -- Print into the log file the information about the Reports are submitted
241: IF G_no_of_reports = 0 THEN
242: FND_MESSAGE.SET_NAME('GMP','PS_NO_TRANS');
243: G_log_text := FND_MESSAGE.GET;
244: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);
245: /* Setting the Concurrent Status to Warning instead of giving Error */
246: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
247: NULL;
248: END IF;

Line 253: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);

249: retcode :=3;
250: ELSIF G_no_of_reports = 1 THEN
251: FND_MESSAGE.SET_NAME('GMP','GMP_REPORT_SUBMITTED');
252: G_log_text := FND_MESSAGE.GET;
253: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);
254:
255: ELSE
256: FND_MESSAGE.SET_NAME('GMP','GMP_MULTIPLE_REPORTS_SUBMITTED');
257: G_log_text := FND_MESSAGE.GET;

Line 258: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);

254:
255: ELSE
256: FND_MESSAGE.SET_NAME('GMP','GMP_MULTIPLE_REPORTS_SUBMITTED');
257: G_log_text := FND_MESSAGE.GET;
258: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);
259:
260: END IF;
261: EXCEPTION
262: WHEN OTHERS THEN

Line 263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in Print mrp Activity'||sqlerrm);

259:
260: END IF;
261: EXCEPTION
262: WHEN OTHERS THEN
263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in Print mrp Activity'||sqlerrm);
264:
265:
266:
267: END print_mrp_activity; /***** END PROCEDURE ***************************/

Line 378: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm);

374: END IF;
375: dbms_sql.close_cursor (cur_planning);
376: EXCEPTION
377: WHEN OTHERS THEN
378: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm);
379: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to Header'||sqlerrm);
380:
381: END mr_insert_header; /***** END PROCEDURE********************/
382:

Line 379: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to Header'||sqlerrm);

375: dbms_sql.close_cursor (cur_planning);
376: EXCEPTION
377: WHEN OTHERS THEN
378: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm);
379: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to Header'||sqlerrm);
380:
381: END mr_insert_header; /***** END PROCEDURE********************/
382:
383: /*============================================================================+

Line 452: FND_FILE.PUT_LINE (FND_FILE.LOG, sqlerrm);

448: END IF;
449:
450: EXCEPTION
451: WHEN OTHERS THEN
452: FND_FILE.PUT_LINE (FND_FILE.LOG, sqlerrm);
453: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to Unbucket'||sqlerrm);
454:
455: END mr_unbucket_report; /***** END PROCEDURE ********************/
456:

Line 453: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to Unbucket'||sqlerrm);

449:
450: EXCEPTION
451: WHEN OTHERS THEN
452: FND_FILE.PUT_LINE (FND_FILE.LOG, sqlerrm);
453: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to Unbucket'||sqlerrm);
454:
455: END mr_unbucket_report; /***** END PROCEDURE ********************/
456:
457: /*============================================================================+

Line 726: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to mr_ubkt_dtl'||sqlerrm);

722: END IF; /* End if for G_whse_list NOT NULL */
723:
724: EXCEPTION
725: WHEN OTHERS THEN
726: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to mr_ubkt_dtl'||sqlerrm);
727: END mr_data_retrieval; /***** END FUNCTION ********************/
728:
729: /*============================================================================+
730: | |

Line 868: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm||'mr_whse_list');

864:
865: END IF;
866: EXCEPTION
867: WHEN OTHERS THEN
868: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm||'mr_whse_list');
869: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to Whse List'||sqlerrm);
870: END mr_whse_list; /******** END PROCEDURE*************/
871:
872: /*============================================================================+

Line 869: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to Whse List'||sqlerrm);

865: END IF;
866: EXCEPTION
867: WHEN OTHERS THEN
868: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm||'mr_whse_list');
869: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to Whse List'||sqlerrm);
870: END mr_whse_list; /******** END PROCEDURE*************/
871:
872: /*============================================================================+
873: | |

Line 917: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm);

913: G_start_balance := G_balance1;
914:
915: EXCEPTION
916: WHEN OTHERS THEN
917: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm);
918: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error Get Balance '||sqlerrm);
919: IF dbms_sql.is_open (cur_balance) then
920: dbms_sql.close_cursor (cur_balance);
921: END IF;

Line 918: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error Get Balance '||sqlerrm);

914:
915: EXCEPTION
916: WHEN OTHERS THEN
917: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm);
918: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error Get Balance '||sqlerrm);
919: IF dbms_sql.is_open (cur_balance) then
920: dbms_sql.close_cursor (cur_balance);
921: END IF;
922:

Line 993: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm);

989: END IF;
990:
991: EXCEPTION
992: WHEN OTHERS THEN
993: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm);
994: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error Get Safety Stock '||sqlerrm);
995: IF dbms_sql.is_open (cur_sstock) then
996: dbms_sql.close_cursor (cur_sstock);
997: END IF;

Line 994: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error Get Safety Stock '||sqlerrm);

990:
991: EXCEPTION
992: WHEN OTHERS THEN
993: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm);
994: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error Get Safety Stock '||sqlerrm);
995: IF dbms_sql.is_open (cur_sstock) then
996: dbms_sql.close_cursor (cur_sstock);
997: END IF;
998:

Line 1214: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in Cleanup details '||sqlerrm);

1210: EXCEPTION
1211: WHEN NO_MATCH_DOC THEN
1212: Null;
1213: WHEN OTHERS THEN
1214: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in Cleanup details '||sqlerrm);
1215: END mr_cleanup_details;
1216:
1217:
1218: END GMPMRACT; /***** END PACKAGE BODY ***************************/