DBA Data[Home] [Help]

APPS.GMPMRRP dependencies on FND_FILE

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

186: --END BUG#3125285
187:
188: IF X_conc_id = 0 THEN
189: G_log_text := FND_MESSAGE.GET;
190: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);
191: retcode:=2;
192: exit;
193: ELSE
194: COMMIT ;

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

202: -- Print into the log file the information about the Reports are submitted
203: IF G_no_of_reports = 0 THEN
204: FND_MESSAGE.SET_NAME('GMP','PS_NO_TRANS');
205: G_log_text := FND_MESSAGE.GET;
206: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);
207: /* Setting the Concurrent Status to Warning instead of giving Error */
208: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
209: NULL;
210: END IF;

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

211: retcode :=3;
212: ELSIF G_no_of_reports = 1 THEN
213: FND_MESSAGE.SET_NAME('GMP','GMP_REPORT_SUBMITTED');
214: G_log_text := FND_MESSAGE.GET;
215: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);
216:
217: ELSE
218: FND_MESSAGE.SET_NAME('GMP','GMP_MULTIPLE_REPORTS_SUBMITTED');
219: G_log_text := FND_MESSAGE.GET;

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

216:
217: ELSE
218: FND_MESSAGE.SET_NAME('GMP','GMP_MULTIPLE_REPORTS_SUBMITTED');
219: G_log_text := FND_MESSAGE.GET;
220: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);
221:
222: END IF;
223:
224: EXCEPTION /* B2861091 - Added Exception Handler */

Line 226: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in Print MRP Bucket '||sqlerrm);

222: END IF;
223:
224: EXCEPTION /* B2861091 - Added Exception Handler */
225: WHEN OTHERS THEN
226: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in Print MRP Bucket '||sqlerrm);
227:
228: END gmp_print_mrp; /***** END PROCEDURE ***************************/
229:
230:

Line 328: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Error in mr insert header'|| sqlerrm);

324: END IF;
325: dbms_sql.close_cursor (cur_planning);
326: EXCEPTION
327: WHEN OTHERS THEN
328: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Error in mr insert header'|| sqlerrm);
329:
330:
331: END mr_insert_header; /***** END PROCEDURE********************/
332:

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

363: END IF;
364:
365: EXCEPTION
366: WHEN OTHERS THEN
367: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm);
368:
369: END mr_bucket_report; /***** END PROCEDURE ********************/
370:
371: /*============================================================================+

Line 400: FND_FILE.PUT_LINE ( FND_FILE.LOG,'After Get Safety stock ');

396: -- to get safety_stock
397: mr_get_safety_stock(V_item_id) ;
398: --
399: /*
400: FND_FILE.PUT_LINE ( FND_FILE.LOG,'After Get Safety stock ');
401: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Schedule id '||G_schedule_id);
402: FND_FILE.PUT_LINE ( FND_FILE.LOG,'mrp id '||G_mrp_id);
403: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Item id '||V_item_id);
404: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Whse List '||G_whse_list);

Line 401: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Schedule id '||G_schedule_id);

397: mr_get_safety_stock(V_item_id) ;
398: --
399: /*
400: FND_FILE.PUT_LINE ( FND_FILE.LOG,'After Get Safety stock ');
401: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Schedule id '||G_schedule_id);
402: FND_FILE.PUT_LINE ( FND_FILE.LOG,'mrp id '||G_mrp_id);
403: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Item id '||V_item_id);
404: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Whse List '||G_whse_list);
405: FND_FILE.PUT_LINE ( FND_FILE.LOG,' On hand '||G_on_hand1);

Line 402: FND_FILE.PUT_LINE ( FND_FILE.LOG,'mrp id '||G_mrp_id);

398: --
399: /*
400: FND_FILE.PUT_LINE ( FND_FILE.LOG,'After Get Safety stock ');
401: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Schedule id '||G_schedule_id);
402: FND_FILE.PUT_LINE ( FND_FILE.LOG,'mrp id '||G_mrp_id);
403: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Item id '||V_item_id);
404: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Whse List '||G_whse_list);
405: FND_FILE.PUT_LINE ( FND_FILE.LOG,' On hand '||G_on_hand1);
406: FND_FILE.PUT_LINE ( FND_FILE.LOG,' total ss '||G_total_ss);

Line 403: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Item id '||V_item_id);

399: /*
400: FND_FILE.PUT_LINE ( FND_FILE.LOG,'After Get Safety stock ');
401: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Schedule id '||G_schedule_id);
402: FND_FILE.PUT_LINE ( FND_FILE.LOG,'mrp id '||G_mrp_id);
403: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Item id '||V_item_id);
404: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Whse List '||G_whse_list);
405: FND_FILE.PUT_LINE ( FND_FILE.LOG,' On hand '||G_on_hand1);
406: FND_FILE.PUT_LINE ( FND_FILE.LOG,' total ss '||G_total_ss);
407: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Matl rep id '||G_matl_rep_id);

Line 404: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Whse List '||G_whse_list);

400: FND_FILE.PUT_LINE ( FND_FILE.LOG,'After Get Safety stock ');
401: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Schedule id '||G_schedule_id);
402: FND_FILE.PUT_LINE ( FND_FILE.LOG,'mrp id '||G_mrp_id);
403: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Item id '||V_item_id);
404: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Whse List '||G_whse_list);
405: FND_FILE.PUT_LINE ( FND_FILE.LOG,' On hand '||G_on_hand1);
406: FND_FILE.PUT_LINE ( FND_FILE.LOG,' total ss '||G_total_ss);
407: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Matl rep id '||G_matl_rep_id);
408: */

Line 405: FND_FILE.PUT_LINE ( FND_FILE.LOG,' On hand '||G_on_hand1);

401: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Schedule id '||G_schedule_id);
402: FND_FILE.PUT_LINE ( FND_FILE.LOG,'mrp id '||G_mrp_id);
403: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Item id '||V_item_id);
404: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Whse List '||G_whse_list);
405: FND_FILE.PUT_LINE ( FND_FILE.LOG,' On hand '||G_on_hand1);
406: FND_FILE.PUT_LINE ( FND_FILE.LOG,' total ss '||G_total_ss);
407: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Matl rep id '||G_matl_rep_id);
408: */
409: --

Line 406: FND_FILE.PUT_LINE ( FND_FILE.LOG,' total ss '||G_total_ss);

402: FND_FILE.PUT_LINE ( FND_FILE.LOG,'mrp id '||G_mrp_id);
403: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Item id '||V_item_id);
404: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Whse List '||G_whse_list);
405: FND_FILE.PUT_LINE ( FND_FILE.LOG,' On hand '||G_on_hand1);
406: FND_FILE.PUT_LINE ( FND_FILE.LOG,' total ss '||G_total_ss);
407: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Matl rep id '||G_matl_rep_id);
408: */
409: --
410: X_row_count := pkg_gmp_bucket_data.mr_bucket_data(G_schedule_id,

Line 407: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Matl rep id '||G_matl_rep_id);

403: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Item id '||V_item_id);
404: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Whse List '||G_whse_list);
405: FND_FILE.PUT_LINE ( FND_FILE.LOG,' On hand '||G_on_hand1);
406: FND_FILE.PUT_LINE ( FND_FILE.LOG,' total ss '||G_total_ss);
407: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Matl rep id '||G_matl_rep_id);
408: */
409: --
410: X_row_count := pkg_gmp_bucket_data.mr_bucket_data(G_schedule_id,
411: G_mrp_id,

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

425: RETURN(0);
426: --
427: EXCEPTION
428: WHEN OTHERS THEN
429: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error in Bucket details '|| sqlerrm);
430: RETURN(0);
431: --
432: END mr_bucket_details; /***** END FUNCTION ********************/
433:

Line 570: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error in Whse List '|| sqlerrm);

566: END IF;
567: --
568: EXCEPTION
569: WHEN OTHERS THEN
570: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error in Whse List '|| sqlerrm);
571: --
572: END mr_whse_list; /******** END PROCEDURE*************/
573:
574: /*============================================================================+

Line 615: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Error in mr get balance '|| sqlerrm);

611: END IF;
612: dbms_sql.close_cursor (cur_balance);
613: EXCEPTION
614: WHEN OTHERS THEN
615: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Error in mr get balance '|| sqlerrm);
616: IF dbms_sql.is_open (cur_balance) then
617: dbms_sql.close_cursor (cur_balance);
618: END IF;
619:

Line 684: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Error in get Safety ctock'|| sqlerrm);

680: END IF;
681:
682: EXCEPTION
683: WHEN OTHERS THEN
684: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Error in get Safety ctock'|| sqlerrm);
685: IF dbms_sql.is_open (cur_sstock) then
686: dbms_sql.close_cursor (cur_sstock);
687: END IF;
688: