DBA Data[Home] [Help]

APPS.AP_WEB_CC_UPGRADE_PKG dependencies on FND_FILE

Line 92: fnd_file.put_line(fnd_file.log,'Begin Upgrade_Cards');

88: p_card_instrument.Info_Only_Flag := 'Y';
89: p_card_instrument.Register_Invalid_Card := 'Y';
90: l_user_id := nvl(fnd_global.user_id, -1);
91:
92: fnd_file.put_line(fnd_file.log,'Begin Upgrade_Cards');
93:
94: ad_parallel_updates_pkg.initialize_rowid_range(
95: ad_parallel_updates_pkg.ROWID_RANGE,
96: l_table_owner,

Line 179: fnd_file.put_line(fnd_file.log,'End Upgrade_Cards');

175: end loop;
176:
177: COMMIT;
178: x_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
179: fnd_file.put_line(fnd_file.log,'End Upgrade_Cards');
180:
181: EXCEPTION
182: WHEN OTHERS THEN
183: ROLLBACK;

Line 184: fnd_file.put_line(fnd_file.log,'Error in Upgrade_Cards');

180:
181: EXCEPTION
182: WHEN OTHERS THEN
183: ROLLBACK;
184: fnd_file.put_line(fnd_file.log,'Error in Upgrade_Cards');
185: fnd_file.put_line(fnd_file.log,'ERROR CODE:='||sqlcode);
186: fnd_file.put_line(fnd_file.log,'ERROR MESSAGE:='||SUBSTR(sqlerrm,1,150));
187: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
188: x_errbuf := SQLERRM;

Line 185: fnd_file.put_line(fnd_file.log,'ERROR CODE:='||sqlcode);

181: EXCEPTION
182: WHEN OTHERS THEN
183: ROLLBACK;
184: fnd_file.put_line(fnd_file.log,'Error in Upgrade_Cards');
185: fnd_file.put_line(fnd_file.log,'ERROR CODE:='||sqlcode);
186: fnd_file.put_line(fnd_file.log,'ERROR MESSAGE:='||SUBSTR(sqlerrm,1,150));
187: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
188: x_errbuf := SQLERRM;
189:

Line 186: fnd_file.put_line(fnd_file.log,'ERROR MESSAGE:='||SUBSTR(sqlerrm,1,150));

182: WHEN OTHERS THEN
183: ROLLBACK;
184: fnd_file.put_line(fnd_file.log,'Error in Upgrade_Cards');
185: fnd_file.put_line(fnd_file.log,'ERROR CODE:='||sqlcode);
186: fnd_file.put_line(fnd_file.log,'ERROR MESSAGE:='||SUBSTR(sqlerrm,1,150));
187: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
188: x_errbuf := SQLERRM;
189:
190: END Upgrade_Cards;

Line 234: fnd_file.put_line(fnd_file.log,'Begin Upgrade_Trxns');

230: l_table_owner := l_oracle_schema;
231: l_rows_processed := 0;
232:
233: l_user_id := nvl(fnd_global.user_id, -1);
234: fnd_file.put_line(fnd_file.log,'Begin Upgrade_Trxns');
235:
236: ad_parallel_updates_pkg.initialize_rowid_range(
237: ad_parallel_updates_pkg.ROWID_RANGE,
238: l_table_owner,

Line 281: fnd_file.put_line(fnd_file.log,'End Upgrade_Trxns');

277: end loop;
278:
279: COMMIT;
280: x_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
281: fnd_file.put_line(fnd_file.log,'End Upgrade_Trxns');
282:
283: EXCEPTION
284: WHEN OTHERS THEN
285: ROLLBACK;

Line 286: fnd_file.put_line(fnd_file.log,'Error in Upgrade_Trxns');

282:
283: EXCEPTION
284: WHEN OTHERS THEN
285: ROLLBACK;
286: fnd_file.put_line(fnd_file.log,'Error in Upgrade_Trxns');
287: fnd_file.put_line(fnd_file.log,'ERROR CODE:='||sqlcode);
288: fnd_file.put_line(fnd_file.log,'ERROR MESSAGE:='||SUBSTR(sqlerrm,1,150));
289: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
290: x_errbuf := SQLERRM;

Line 287: fnd_file.put_line(fnd_file.log,'ERROR CODE:='||sqlcode);

283: EXCEPTION
284: WHEN OTHERS THEN
285: ROLLBACK;
286: fnd_file.put_line(fnd_file.log,'Error in Upgrade_Trxns');
287: fnd_file.put_line(fnd_file.log,'ERROR CODE:='||sqlcode);
288: fnd_file.put_line(fnd_file.log,'ERROR MESSAGE:='||SUBSTR(sqlerrm,1,150));
289: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
290: x_errbuf := SQLERRM;
291:

Line 288: fnd_file.put_line(fnd_file.log,'ERROR MESSAGE:='||SUBSTR(sqlerrm,1,150));

284: WHEN OTHERS THEN
285: ROLLBACK;
286: fnd_file.put_line(fnd_file.log,'Error in Upgrade_Trxns');
287: fnd_file.put_line(fnd_file.log,'ERROR CODE:='||sqlcode);
288: fnd_file.put_line(fnd_file.log,'ERROR MESSAGE:='||SUBSTR(sqlerrm,1,150));
289: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
290: x_errbuf := SQLERRM;
291:
292: END Upgrade_Trxns;

Line 307: fnd_file.put_line(fnd_file.log,'Begin Upgrade_Trxns_Manager');

303: x_script_name IN VARCHAR2
304: )
305: IS
306: BEGIN
307: fnd_file.put_line(fnd_file.log,'Begin Upgrade_Trxns_Manager');
308: AD_CONC_UTILS_PKG.submit_subrequests
309: (X_errbuf => x_errbuf,
310: X_retcode => x_retcode,
311: X_WorkerConc_app_shortname => 'SQLAP',

Line 317: fnd_file.put_line(fnd_file.log,'End Upgrade_Trxns_Manager');

313: X_batch_size => x_batch_size,
314: X_Num_Workers => x_num_workers,
315: X_Argument4 => x_script_name
316: );
317: fnd_file.put_line(fnd_file.log,'End Upgrade_Trxns_Manager');
318: EXCEPTION
319: WHEN OTHERS THEN
320: ROLLBACK;
321: fnd_file.put_line(fnd_file.log,'Error in Upgrade_Trxns_Manager');

Line 321: fnd_file.put_line(fnd_file.log,'Error in Upgrade_Trxns_Manager');

317: fnd_file.put_line(fnd_file.log,'End Upgrade_Trxns_Manager');
318: EXCEPTION
319: WHEN OTHERS THEN
320: ROLLBACK;
321: fnd_file.put_line(fnd_file.log,'Error in Upgrade_Trxns_Manager');
322: fnd_file.put_line(fnd_file.log,'ERROR CODE:='||sqlcode);
323: fnd_file.put_line(fnd_file.log,'ERROR MESSAGE:='||SUBSTR(sqlerrm,1,150));
324: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
325: x_errbuf := SQLERRM;

Line 322: fnd_file.put_line(fnd_file.log,'ERROR CODE:='||sqlcode);

318: EXCEPTION
319: WHEN OTHERS THEN
320: ROLLBACK;
321: fnd_file.put_line(fnd_file.log,'Error in Upgrade_Trxns_Manager');
322: fnd_file.put_line(fnd_file.log,'ERROR CODE:='||sqlcode);
323: fnd_file.put_line(fnd_file.log,'ERROR MESSAGE:='||SUBSTR(sqlerrm,1,150));
324: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
325: x_errbuf := SQLERRM;
326:

Line 323: fnd_file.put_line(fnd_file.log,'ERROR MESSAGE:='||SUBSTR(sqlerrm,1,150));

319: WHEN OTHERS THEN
320: ROLLBACK;
321: fnd_file.put_line(fnd_file.log,'Error in Upgrade_Trxns_Manager');
322: fnd_file.put_line(fnd_file.log,'ERROR CODE:='||sqlcode);
323: fnd_file.put_line(fnd_file.log,'ERROR MESSAGE:='||SUBSTR(sqlerrm,1,150));
324: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
325: x_errbuf := SQLERRM;
326:
327: END Upgrade_Trxns_Manager;

Line 343: fnd_file.put_line(fnd_file.log,'Begin Upgrade_Cards_Manager');

339: x_script_name IN VARCHAR2
340: )
341: IS
342: BEGIN
343: fnd_file.put_line(fnd_file.log,'Begin Upgrade_Cards_Manager');
344: AD_CONC_UTILS_PKG.submit_subrequests
345: (X_errbuf => x_errbuf,
346: X_retcode => x_retcode,
347: X_WorkerConc_app_shortname => 'SQLAP',

Line 353: fnd_file.put_line(fnd_file.log,'End Upgrade_Cards_Manager');

349: X_batch_size => x_batch_size,
350: X_Num_Workers => x_num_workers,
351: X_Argument4 => x_script_name
352: );
353: fnd_file.put_line(fnd_file.log,'End Upgrade_Cards_Manager');
354: EXCEPTION
355: WHEN OTHERS THEN
356: ROLLBACK;
357: fnd_file.put_line(fnd_file.log,'Error in Upgrade_Cards_Manager');

Line 357: fnd_file.put_line(fnd_file.log,'Error in Upgrade_Cards_Manager');

353: fnd_file.put_line(fnd_file.log,'End Upgrade_Cards_Manager');
354: EXCEPTION
355: WHEN OTHERS THEN
356: ROLLBACK;
357: fnd_file.put_line(fnd_file.log,'Error in Upgrade_Cards_Manager');
358: fnd_file.put_line(fnd_file.log,'ERROR CODE:='||sqlcode);
359: fnd_file.put_line(fnd_file.log,'ERROR MESSAGE:='||SUBSTR(sqlerrm,1,150));
360: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
361: x_errbuf := SQLERRM;

Line 358: fnd_file.put_line(fnd_file.log,'ERROR CODE:='||sqlcode);

354: EXCEPTION
355: WHEN OTHERS THEN
356: ROLLBACK;
357: fnd_file.put_line(fnd_file.log,'Error in Upgrade_Cards_Manager');
358: fnd_file.put_line(fnd_file.log,'ERROR CODE:='||sqlcode);
359: fnd_file.put_line(fnd_file.log,'ERROR MESSAGE:='||SUBSTR(sqlerrm,1,150));
360: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
361: x_errbuf := SQLERRM;
362: END Upgrade_Cards_Manager;

Line 359: fnd_file.put_line(fnd_file.log,'ERROR MESSAGE:='||SUBSTR(sqlerrm,1,150));

355: WHEN OTHERS THEN
356: ROLLBACK;
357: fnd_file.put_line(fnd_file.log,'Error in Upgrade_Cards_Manager');
358: fnd_file.put_line(fnd_file.log,'ERROR CODE:='||sqlcode);
359: fnd_file.put_line(fnd_file.log,'ERROR MESSAGE:='||SUBSTR(sqlerrm,1,150));
360: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
361: x_errbuf := SQLERRM;
362: END Upgrade_Cards_Manager;
363: