DBA Data[Home] [Help]

APPS.PA_FA_TIEBACK_PVT dependencies on FND_FILE

Line 114: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,TO_CHAR(sysdate,'DD-MON-YYYY')||

110:
111:
112:
113: --Print report heading
114: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,TO_CHAR(sysdate,'DD-MON-YYYY')||
115: ' '||
116: 'PACFATBP - Tieback Asset Lines from Oracle Assets');
117: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
118:

Line 117: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));

113: --Print report heading
114: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,TO_CHAR(sysdate,'DD-MON-YYYY')||
115: ' '||
116: 'PACFATBP - Tieback Asset Lines from Oracle Assets');
117: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
118:
119:
120: IF PG_DEBUG = 'Y' THEN
121: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||': '||'Opening project_assets_cur');

Line 295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Tieback completed successfully.');

291: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||': '||'l_commit_count = '||l_commit_count);
292: END IF;
293: Commit;
294:
295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Tieback completed successfully.');
296: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
297:
298:
299: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,v_asset_count||' project assets were tied back.');

Line 296: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));

292: END IF;
293: Commit;
294:
295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Tieback completed successfully.');
296: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
297:
298:
299: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,v_asset_count||' project assets were tied back.');
300: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,v_asset_line_count||' project asset lines were tied back.');

Line 299: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,v_asset_count||' project assets were tied back.');

295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Tieback completed successfully.');
296: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
297:
298:
299: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,v_asset_count||' project assets were tied back.');
300: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,v_asset_line_count||' project asset lines were tied back.');
301: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
302:
303:

Line 300: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,v_asset_line_count||' project asset lines were tied back.');

296: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
297:
298:
299: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,v_asset_count||' project assets were tied back.');
300: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,v_asset_line_count||' project asset lines were tied back.');
301: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
302:
303:
304: EXCEPTION

Line 301: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));

297:
298:
299: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,v_asset_count||' project assets were tied back.');
300: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,v_asset_line_count||' project asset lines were tied back.');
301: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
302:
303:
304: EXCEPTION
305:

Line 308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Unexpected error: '||SQLCODE||' '||SQLERRM);

304: EXCEPTION
305:
306: WHEN OTHERS THEN
307: Rollback;
308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Unexpected error: '||SQLCODE||' '||SQLERRM);
309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
310:
311: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error: '||SQLCODE||' '||SQLERRM);
312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));

Line 309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));

305:
306: WHEN OTHERS THEN
307: Rollback;
308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Unexpected error: '||SQLCODE||' '||SQLERRM);
309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
310:
311: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error: '||SQLCODE||' '||SQLERRM);
312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
313:

Line 311: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error: '||SQLCODE||' '||SQLERRM);

307: Rollback;
308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Unexpected error: '||SQLCODE||' '||SQLERRM);
309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
310:
311: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error: '||SQLCODE||' '||SQLERRM);
312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
313:
314: retcode := SQLCODE;
315: errbuf := SQLERRM;

Line 312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));

308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Unexpected error: '||SQLCODE||' '||SQLERRM);
309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
310:
311: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error: '||SQLCODE||' '||SQLERRM);
312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
313:
314: retcode := SQLCODE;
315: errbuf := SQLERRM;
316: RAISE;