eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PARTY_STAGE dependencies on FND_FILE

Line 2447: FND_FILE.close;

2443: WHEN FND_API.G_EXC_ERROR THEN
2444: outandlog('Error: Aborting staging');
2445: retcode := 2;
2446: errbuf := errbuf || logerror || SQLERRM;
2447: FND_FILE.close;
2448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2449: outandlog('Error: Aborting staging');
2450: retcode := 2;
2451: errbuf := errbuf || logerror || SQLERRM;

Line 2452: FND_FILE.close;

2448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2449: outandlog('Error: Aborting staging');
2450: retcode := 2;
2451: errbuf := errbuf || logerror || SQLERRM;
2452: FND_FILE.close;
2453: WHEN OTHERS THEN
2454: log(fnd_message.get);
2455: outandlog('Error: Aborting staging');
2456: retcode := 2;

Line 2458: FND_FILE.close;

2454: log(fnd_message.get);
2455: outandlog('Error: Aborting staging');
2456: retcode := 2;
2457: errbuf := errbuf || logerror || SQLERRM;
2458: FND_FILE.close;
2459: END;
2460:
2461:
2462: PROCEDURE gather_stats(

Line 2874: FND_FILE.close;

2870: WHEN FND_API.G_EXC_ERROR THEN
2871: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);
2872: retcode := 2;
2873: errbuf := errbuf || logerror;
2874: FND_FILE.close;
2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2876: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);
2877: retcode := 2;
2878: errbuf := errbuf || logerror;

Line 2879: FND_FILE.close;

2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2876: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);
2877: retcode := 2;
2878: errbuf := errbuf || logerror;
2879: FND_FILE.close;
2880: WHEN OTHERS THEN
2881: outandlog('Error: Aborting staging '|| SQLERRM);
2882: retcode := 2;
2883: errbuf := errbuf || logerror;

Line 2884: FND_FILE.close;

2880: WHEN OTHERS THEN
2881: outandlog('Error: Aborting staging '|| SQLERRM);
2882: retcode := 2;
2883: errbuf := errbuf || logerror;
2884: FND_FILE.close;
2885: END;
2886:
2887: FUNCTION new_primary_trans(p_entity VARCHAR2
2888: ) RETURN BOOLEAN IS

Line 3315: FND_FILE.put_line(FND_FILE.log, 'Error during DENORM PARTY Index Synchronization SQLEERM=' ||SQLERRM);

3311: where party_id between l_min_id and l_max_id ;
3312: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_parties_t1');
3313: FND_Concurrent.af_commit;
3314: WHEN OTHERS THEN
3315: FND_FILE.put_line(FND_FILE.log, 'Error during DENORM PARTY Index Synchronization SQLEERM=' ||SQLERRM);
3316: retcode := 2;
3317: errbuf := SQLERRM;
3318: END;
3319:

Line 3341: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_parties_t1 index');

3337: and rownum<1001 ) a )
3338: where rnum = 1000;
3339: update hz_staged_parties set concat_col = concat_col
3340: where party_id between l_min_id and tmp;
3341: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_parties_t1 index');
3342: AD_CTX_DDL.sync_index(l_index_owner|| '.hz_stage_parties_t1');
3343: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_parties_t1 index successful');
3344: FND_Concurrent.af_commit;
3345: l_min_id:=tmp+1;

Line 3343: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_parties_t1 index successful');

3339: update hz_staged_parties set concat_col = concat_col
3340: where party_id between l_min_id and tmp;
3341: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_parties_t1 index');
3342: AD_CTX_DDL.sync_index(l_index_owner|| '.hz_stage_parties_t1');
3343: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_parties_t1 index successful');
3344: FND_Concurrent.af_commit;
3345: l_min_id:=tmp+1;
3346: END LOOP;
3347: EXCEPTION

Line 3351: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_parties_t1 index');

3347: EXCEPTION
3348: WHEN NO_DATA_FOUND THEN
3349: update hz_staged_parties set concat_col = concat_col
3350: where party_id between l_min_id and l_max_id ;
3351: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_parties_t1 index');
3352: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_parties_t1');
3353: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_parties_t1 index successful');
3354: FND_Concurrent.af_commit;
3355: WHEN OTHERS THEN

Line 3353: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_parties_t1 index successful');

3349: update hz_staged_parties set concat_col = concat_col
3350: where party_id between l_min_id and l_max_id ;
3351: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_parties_t1 index');
3352: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_parties_t1');
3353: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_parties_t1 index successful');
3354: FND_Concurrent.af_commit;
3355: WHEN OTHERS THEN
3356: FND_FILE.put_line(FND_FILE.log, 'Error during PARTY Index Synchronization SQLEERM=' ||SQLERRM);
3357: retcode := 2;

Line 3356: FND_FILE.put_line(FND_FILE.log, 'Error during PARTY Index Synchronization SQLEERM=' ||SQLERRM);

3352: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_parties_t1');
3353: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_parties_t1 index successful');
3354: FND_Concurrent.af_commit;
3355: WHEN OTHERS THEN
3356: FND_FILE.put_line(FND_FILE.log, 'Error during PARTY Index Synchronization SQLEERM=' ||SQLERRM);
3357: retcode := 2;
3358: errbuf := SQLERRM;
3359: END;
3360:

Line 3388: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_party_sites_t1 index');

3384: and rownum<1001 ) a )
3385: where rnum = 1000;
3386: update hz_staged_party_sites set concat_col = concat_col
3387: where party_id between l_min_id and tmp;
3388: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_party_sites_t1 index');
3389: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_party_sites_t1');
3390: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_party_sites_t1 index successful');
3391: FND_Concurrent.af_commit;
3392: l_min_id:=tmp+1;

Line 3390: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_party_sites_t1 index successful');

3386: update hz_staged_party_sites set concat_col = concat_col
3387: where party_id between l_min_id and tmp;
3388: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_party_sites_t1 index');
3389: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_party_sites_t1');
3390: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_party_sites_t1 index successful');
3391: FND_Concurrent.af_commit;
3392: l_min_id:=tmp+1;
3393: END LOOP;
3394: EXCEPTION

Line 3398: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_party_sites_t1 index');

3394: EXCEPTION
3395: WHEN NO_DATA_FOUND THEN
3396: update hz_staged_party_sites set concat_col = concat_col
3397: where party_site_id between l_min_id and l_max_id ;
3398: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_party_sites_t1 index');
3399: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_party_sites_t1');
3400: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_party_sites_t1 index successful');
3401: FND_Concurrent.af_commit;
3402: WHEN OTHERS THEN

Line 3400: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_party_sites_t1 index successful');

3396: update hz_staged_party_sites set concat_col = concat_col
3397: where party_site_id between l_min_id and l_max_id ;
3398: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_party_sites_t1 index');
3399: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_party_sites_t1');
3400: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_party_sites_t1 index successful');
3401: FND_Concurrent.af_commit;
3402: WHEN OTHERS THEN
3403: FND_FILE.put_line(FND_FILE.log, 'Error during PARTY SITES Index Synchronization SQLEERM=' ||SQLERRM);
3404: retcode := 2;

Line 3403: FND_FILE.put_line(FND_FILE.log, 'Error during PARTY SITES Index Synchronization SQLEERM=' ||SQLERRM);

3399: AD_CTX_DDL.sync_index(l_index_owner ||'.hz_stage_party_sites_t1');
3400: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_party_sites_t1 index successful');
3401: FND_Concurrent.af_commit;
3402: WHEN OTHERS THEN
3403: FND_FILE.put_line(FND_FILE.log, 'Error during PARTY SITES Index Synchronization SQLEERM=' ||SQLERRM);
3404: retcode := 2;
3405: errbuf := SQLERRM;
3406: END;
3407: END IF;

Line 3436: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_contact_t1 index');

3432: and rownum<1001 ) a )
3433: where rnum = 1000;
3434: update hz_staged_contacts set concat_col = concat_col
3435: where org_contact_id between l_min_id and tmp;
3436: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_contact_t1 index');
3437: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_contact_t1');
3438: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_contact_t1 index successful');
3439: FND_Concurrent.af_commit;
3440: l_min_id:=tmp+1;

Line 3438: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_contact_t1 index successful');

3434: update hz_staged_contacts set concat_col = concat_col
3435: where org_contact_id between l_min_id and tmp;
3436: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_contact_t1 index');
3437: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_contact_t1');
3438: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_contact_t1 index successful');
3439: FND_Concurrent.af_commit;
3440: l_min_id:=tmp+1;
3441: END LOOP;
3442: EXCEPTION

Line 3446: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_contact_t1 index');

3442: EXCEPTION
3443: WHEN NO_DATA_FOUND THEN
3444: update hz_staged_contacts set concat_col = concat_col
3445: where org_contact_id between l_min_id and l_max_id ;
3446: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_contact_t1 index');
3447: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_contact_t1');
3448: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_contact_t1 index successful');
3449: FND_Concurrent.af_commit;
3450: WHEN OTHERS THEN

Line 3448: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_contact_t1 index successful');

3444: update hz_staged_contacts set concat_col = concat_col
3445: where org_contact_id between l_min_id and l_max_id ;
3446: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_contact_t1 index');
3447: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_contact_t1');
3448: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_contact_t1 index successful');
3449: FND_Concurrent.af_commit;
3450: WHEN OTHERS THEN
3451: FND_FILE.put_line(FND_FILE.log, 'Error during CONTACTS Index Synchronization SQLEERM=' ||SQLERRM);
3452: retcode := 2;

Line 3451: FND_FILE.put_line(FND_FILE.log, 'Error during CONTACTS Index Synchronization SQLEERM=' ||SQLERRM);

3447: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_contact_t1');
3448: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_contact_t1 index successful');
3449: FND_Concurrent.af_commit;
3450: WHEN OTHERS THEN
3451: FND_FILE.put_line(FND_FILE.log, 'Error during CONTACTS Index Synchronization SQLEERM=' ||SQLERRM);
3452: retcode := 2;
3453: errbuf := SQLERRM;
3454: END;
3455:

Line 3484: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_cpt_t1 index');

3480: and rownum<1001 ) a )
3481: where rnum = 1000;
3482: update hz_staged_contact_points set concat_col = concat_col
3483: where contact_point_id between l_min_id and tmp;
3484: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_cpt_t1 index');
3485: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_cpt_t1');
3486: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_cpt_t1 index successful');
3487: FND_Concurrent.af_commit;
3488: l_min_id:=tmp+1;

Line 3486: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_cpt_t1 index successful');

3482: update hz_staged_contact_points set concat_col = concat_col
3483: where contact_point_id between l_min_id and tmp;
3484: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_cpt_t1 index');
3485: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_cpt_t1');
3486: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_cpt_t1 index successful');
3487: FND_Concurrent.af_commit;
3488: l_min_id:=tmp+1;
3489: END LOOP;
3490: EXCEPTION

Line 3494: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_cpt_t1 index');

3490: EXCEPTION
3491: WHEN NO_DATA_FOUND THEN
3492: update hz_staged_contact_points set concat_col = concat_col
3493: where contact_point_id between l_min_id and l_max_id ;
3494: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_cpt_t1 index');
3495: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_cpt_t1');
3496: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_cpt_t1 index successful');
3497: FND_Concurrent.af_commit;
3498: WHEN OTHERS THEN

Line 3496: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_cpt_t1 index successful');

3492: update hz_staged_contact_points set concat_col = concat_col
3493: where contact_point_id between l_min_id and l_max_id ;
3494: FND_FILE.put_line(FND_FILE.log, 'Attempting to SYNC the hz_stage_cpt_t1 index');
3495: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_cpt_t1');
3496: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_cpt_t1 index successful');
3497: FND_Concurrent.af_commit;
3498: WHEN OTHERS THEN
3499: FND_FILE.put_line(FND_FILE.log, 'Error during CONTACT POINTS Index Synchronization SQLEERM=' ||SQLERRM);
3500: retcode := 2;

Line 3499: FND_FILE.put_line(FND_FILE.log, 'Error during CONTACT POINTS Index Synchronization SQLEERM=' ||SQLERRM);

3495: AD_CTX_DDL.sync_index(l_index_owner||'.hz_stage_cpt_t1');
3496: FND_FILE.put_line(FND_FILE.log, 'SYNC of the hz_stage_cpt_t1 index successful');
3497: FND_Concurrent.af_commit;
3498: WHEN OTHERS THEN
3499: FND_FILE.put_line(FND_FILE.log, 'Error during CONTACT POINTS Index Synchronization SQLEERM=' ||SQLERRM);
3500: retcode := 2;
3501: errbuf := SQLERRM;
3502: END;
3503:

Line 3956: FND_FILE.close;

3952: log('Error ' || SQLERRM);
3953: retcode := 2;
3954: errbuf := errbuf || logerror;
3955: outandlog('Aborting concurrent program execution');
3956: FND_FILE.close;
3957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3958: outandlog('Error: ' || FND_MESSAGE.GET);
3959: log('Error ' || SQLERRM);
3960: retcode := 2;

Line 3963: FND_FILE.close;

3959: log('Error ' || SQLERRM);
3960: retcode := 2;
3961: errbuf := errbuf || logerror;
3962: outandlog('Aborting concurrent program execution');
3963: FND_FILE.close;
3964: WHEN OTHERS THEN
3965: outandlog('Error: ' || FND_MESSAGE.GET);
3966: log('SQL Error ' || SQLERRM);
3967: retcode := 2;

Line 3970: FND_FILE.close;

3966: log('SQL Error ' || SQLERRM);
3967: retcode := 2;
3968: errbuf := errbuf || logerror || SQLERRM;
3969: outandlog('Aborting concurrent program execution');
3970: FND_FILE.close;
3971: END;
3972:
3973: PROCEDURE generate_map_proc (
3974: p_entity IN VARCHAR2,

Line 4603: l(' FND_FILE.NEW_LINE(FND_FILE.LOG, 1); ');

4599: l(' message IN VARCHAR2, ');
4600: l(' newline IN BOOLEAN DEFAULT TRUE) IS ');
4601: l(' BEGIN ');
4602: l(' IF message = ''NEWLINE'' THEN ');
4603: l(' FND_FILE.NEW_LINE(FND_FILE.LOG, 1); ');
4604: l(' ELSIF (newline) THEN ');
4605: l(' FND_FILE.put_line(fnd_file.log,message); ');
4606: l(' ELSE ');
4607: l(' FND_FILE.put(fnd_file.log,message); ');

Line 4605: l(' FND_FILE.put_line(fnd_file.log,message); ');

4601: l(' BEGIN ');
4602: l(' IF message = ''NEWLINE'' THEN ');
4603: l(' FND_FILE.NEW_LINE(FND_FILE.LOG, 1); ');
4604: l(' ELSIF (newline) THEN ');
4605: l(' FND_FILE.put_line(fnd_file.log,message); ');
4606: l(' ELSE ');
4607: l(' FND_FILE.put(fnd_file.log,message); ');
4608: l(' END IF; ');
4609: l(' END log; ');

Line 4607: l(' FND_FILE.put(fnd_file.log,message); ');

4603: l(' FND_FILE.NEW_LINE(FND_FILE.LOG, 1); ');
4604: l(' ELSIF (newline) THEN ');
4605: l(' FND_FILE.put_line(fnd_file.log,message); ');
4606: l(' ELSE ');
4607: l(' FND_FILE.put(fnd_file.log,message); ');
4608: l(' END IF; ');
4609: l(' END log; ');
4610: l('');
4611:

Line 5660: l(' FND_FILE.put_line(FND_FILE.log,''Aborted by User'');');

5656: l(' LOOP');
5657: l(' call_status := FND_CONCURRENT.GET_REQUEST_STATUS(');
5658: l(' req_id, null,null,rphase,rstatus,dphase,dstatus,message);');
5659: l(' IF dstatus = ''TERMINATING'' THEN');
5660: l(' FND_FILE.put_line(FND_FILE.log,''Aborted by User'');');
5661: l(' RAISE USER_TERMINATE;');
5662: l(' END IF;');
5663: l(' FETCH p_party_cur BULK COLLECT INTO');
5664: l(' H_P_PARTY_ID');

Line 11521: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

11517: message IN VARCHAR2,
11518: newline IN BOOLEAN DEFAULT TRUE) IS
11519: BEGIN
11520: IF message = 'NEWLINE' THEN
11521: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
11522: ELSIF (newline) THEN
11523: FND_FILE.put_line(fnd_file.output,message);
11524: ELSE
11525: FND_FILE.put(fnd_file.output,message);

Line 11523: FND_FILE.put_line(fnd_file.output,message);

11519: BEGIN
11520: IF message = 'NEWLINE' THEN
11521: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
11522: ELSIF (newline) THEN
11523: FND_FILE.put_line(fnd_file.output,message);
11524: ELSE
11525: FND_FILE.put(fnd_file.output,message);
11526: END IF;
11527: END out;

Line 11525: FND_FILE.put(fnd_file.output,message);

11521: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
11522: ELSIF (newline) THEN
11523: FND_FILE.put_line(fnd_file.output,message);
11524: ELSE
11525: FND_FILE.put(fnd_file.output,message);
11526: END IF;
11527: END out;
11528:
11529: /**

Line 11538: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

11534: newline IN BOOLEAN DEFAULT TRUE) IS
11535: BEGIN
11536:
11537: IF message = 'NEWLINE' THEN
11538: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
11539: ELSIF (newline) THEN
11540: FND_FILE.put_line(fnd_file.log,message);
11541: ELSE
11542: FND_FILE.put(fnd_file.log,message);

Line 11540: FND_FILE.put_line(fnd_file.log,message);

11536:
11537: IF message = 'NEWLINE' THEN
11538: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
11539: ELSIF (newline) THEN
11540: FND_FILE.put_line(fnd_file.log,message);
11541: ELSE
11542: FND_FILE.put(fnd_file.log,message);
11543: END IF;
11544: END log;

Line 11542: FND_FILE.put(fnd_file.log,message);

11538: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
11539: ELSIF (newline) THEN
11540: FND_FILE.put_line(fnd_file.log,message);
11541: ELSE
11542: FND_FILE.put(fnd_file.log,message);
11543: END IF;
11544: END log;
11545:
11546: /**