DBA Data[Home] [Help]

APPS.PA_FA_TIEBACK_PVT dependencies on FND_GLOBAL

Line 83: v_user NUMBER := FND_GLOBAL.user_id;

79: GROUP BY fa.asset_id, fa.asset_number;
80:
81: fa_assets_rec fa_assets_cur%ROWTYPE;
82:
83: v_user NUMBER := FND_GLOBAL.user_id;
84: v_login NUMBER := FND_GLOBAL.login_id;
85: v_request_id NUMBER := FND_GLOBAL.conc_request_id;
86: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
87: v_program_id NUMBER := FND_GLOBAL.conc_program_id;

Line 84: v_login NUMBER := FND_GLOBAL.login_id;

80:
81: fa_assets_rec fa_assets_cur%ROWTYPE;
82:
83: v_user NUMBER := FND_GLOBAL.user_id;
84: v_login NUMBER := FND_GLOBAL.login_id;
85: v_request_id NUMBER := FND_GLOBAL.conc_request_id;
86: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
87: v_program_id NUMBER := FND_GLOBAL.conc_program_id;
88:

Line 85: v_request_id NUMBER := FND_GLOBAL.conc_request_id;

81: fa_assets_rec fa_assets_cur%ROWTYPE;
82:
83: v_user NUMBER := FND_GLOBAL.user_id;
84: v_login NUMBER := FND_GLOBAL.login_id;
85: v_request_id NUMBER := FND_GLOBAL.conc_request_id;
86: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
87: v_program_id NUMBER := FND_GLOBAL.conc_program_id;
88:
89: v_asset_count NUMBER := 0;

Line 86: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;

82:
83: v_user NUMBER := FND_GLOBAL.user_id;
84: v_login NUMBER := FND_GLOBAL.login_id;
85: v_request_id NUMBER := FND_GLOBAL.conc_request_id;
86: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
87: v_program_id NUMBER := FND_GLOBAL.conc_program_id;
88:
89: v_asset_count NUMBER := 0;
90: v_asset_number_count NUMBER := 0;

Line 87: v_program_id NUMBER := FND_GLOBAL.conc_program_id;

83: v_user NUMBER := FND_GLOBAL.user_id;
84: v_login NUMBER := FND_GLOBAL.login_id;
85: v_request_id NUMBER := FND_GLOBAL.conc_request_id;
86: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
87: v_program_id NUMBER := FND_GLOBAL.conc_program_id;
88:
89: v_asset_count NUMBER := 0;
90: v_asset_number_count NUMBER := 0;
91: v_asset_number fa_additions.asset_number%TYPE;

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 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 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 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 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;