1577: PA_DEBUG.WRITE_FILE('LOG', TO_CHAR(SYSDATE,'HH:MI:SS')||
1578: ': PA_DEBUG_MODE: '||PG_DEBUG);
1579:
1580: --Print report heading
1581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,TO_CHAR(sysdate,'DD-MON-YYYY')||
1582: ' '||
1583: 'PARRCSUB - Refresh RBS Element Names');
1584: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
1585:
1580: --Print report heading
1581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,TO_CHAR(sysdate,'DD-MON-YYYY')||
1582: ' '||
1583: 'PARRCSUB - Refresh RBS Element Names');
1584: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
1585:
1586:
1587: IF PG_DEBUG = 'Y' THEN
1588: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||': '||
2383: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||'Leaving Refresh_Resource_Names procedure');
2384: END IF;
2385: Commit;
2386:
2387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Refresh_Resource_Names completed successfully.');
2388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
2389:
2390: EXCEPTION
2391:
2384: END IF;
2385: Commit;
2386:
2387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Refresh_Resource_Names completed successfully.');
2388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
2389:
2390: EXCEPTION
2391:
2392: WHEN OTHERS THEN
2390: EXCEPTION
2391:
2392: WHEN OTHERS THEN
2393: Rollback;
2394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Unexpected error: '||SQLCODE||' '||SQLERRM);
2395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
2396:
2397: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error: '||SQLCODE||' '||SQLERRM);
2398: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
2391:
2392: WHEN OTHERS THEN
2393: Rollback;
2394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Unexpected error: '||SQLCODE||' '||SQLERRM);
2395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
2396:
2397: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error: '||SQLCODE||' '||SQLERRM);
2398: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
2399:
2393: Rollback;
2394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Unexpected error: '||SQLCODE||' '||SQLERRM);
2395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
2396:
2397: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error: '||SQLCODE||' '||SQLERRM);
2398: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
2399:
2400: retcode := SQLCODE;
2401: errbuf := SQLERRM;
2394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Unexpected error: '||SQLCODE||' '||SQLERRM);
2395: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
2396:
2397: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error: '||SQLCODE||' '||SQLERRM);
2398: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_global.local_chr(10));
2399:
2400: retcode := SQLCODE;
2401: errbuf := SQLERRM;
2402: RAISE;