DBA Data[Home] [Help]

APPS.GML_POCR dependencies on FND_FILE

Line 25: --FND_FILE.PUT_NAMES('testx.log','testx.out','/tmp');

21: WHERE db_link='GEMMS_DB.WORLD';
22:
23: BEGIN
24:
25: --FND_FILE.PUT_NAMES('testx.log','testx.out','/tmp');
26: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Common Purchasing Error Log File');
27: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Common Purchasing Output File');
28: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Date : '|| to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));
29: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);

Line 26: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Common Purchasing Error Log File');

22:
23: BEGIN
24:
25: --FND_FILE.PUT_NAMES('testx.log','testx.out','/tmp');
26: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Common Purchasing Error Log File');
27: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Common Purchasing Output File');
28: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Date : '|| to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));
29: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
30:

Line 27: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Common Purchasing Output File');

23: BEGIN
24:
25: --FND_FILE.PUT_NAMES('testx.log','testx.out','/tmp');
26: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Common Purchasing Error Log File');
27: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Common Purchasing Output File');
28: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Date : '|| to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));
29: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
30:
31:

Line 28: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Date : '|| to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));

24:
25: --FND_FILE.PUT_NAMES('testx.log','testx.out','/tmp');
26: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Common Purchasing Error Log File');
27: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Common Purchasing Output File');
28: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Date : '|| to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));
29: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
30:
31:
32: /* Call the Blanket PO Synchronization Routine */

Line 29: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);

25: --FND_FILE.PUT_NAMES('testx.log','testx.out','/tmp');
26: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Common Purchasing Error Log File');
27: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Common Purchasing Output File');
28: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Date : '|| to_char(sysdate,'DD-MON-YYYY hh24:mi:ss'));
29: FND_FILE.NEW_LINE(FND_FILE.LOG, 2);
30:
31:
32: /* Call the Blanket PO Synchronization Routine */
33:

Line 101: FND_FILE.PUT_LINE(FND_FILE.LOG,'Validation Errors Detected...');

97: errbufx := 'Write error - '||to_char(SQLCODE) || ' ' || SQLERRM;
98:
99: when validation_error then
100: -- dbms_output.put_line('Validation Errors Detected....');
101: FND_FILE.PUT_LINE(FND_FILE.LOG,'Validation Errors Detected...');
102: errbufx := 'Validation error - '||to_char(SQLCODE) || ' ' || SQLERRM;
103: flag := 1;
104:
105: when others then

Line 111: FND_FILE.PUT_LINE(FND_FILE.LOG,'Validation Errors Detected...');

107: err_msg := SQLERRM(err_num);
108: -- dbms_output.put_line( ' In others');
109: -- dbms_output.put_line('Unhandled Exception....');
110: -- dbms_output.put_line(err_num || ' ' || err_msg);
111: FND_FILE.PUT_LINE(FND_FILE.LOG,'Validation Errors Detected...');
112: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
113: errbufx := to_char(SQLCODE) || ' ' || SQLERRM;
114:
115: raise;

Line 112: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);

108: -- dbms_output.put_line( ' In others');
109: -- dbms_output.put_line('Unhandled Exception....');
110: -- dbms_output.put_line(err_num || ' ' || err_msg);
111: FND_FILE.PUT_LINE(FND_FILE.LOG,'Validation Errors Detected...');
112: FND_FILE.PUT_LINE(FND_FILE.LOG, err_msg);
113: errbufx := to_char(SQLCODE) || ' ' || SQLERRM;
114:
115: raise;
116: /*