DBA Data[Home] [Help]

APPS.JTF_RS_PARTY_MERGE_PUB dependencies on JTF_RS_PARTY_MERGE_PUB

Line 1: PACKAGE BODY JTF_RS_PARTY_MERGE_PUB AS

1: PACKAGE BODY JTF_RS_PARTY_MERGE_PUB AS
2: /* $Header: jtfrsbmb.pls 120.0.12000000.2 2007/04/02 23:28:09 nsinghai ship $ */
3:
4: /************************************************************
5:

Line 111: FND_FILE.put_line(fnd_file.log, ' Begin JTF_RS_PARTY_MERGE_PUB.resource_party_merge(+) ');

107: savepoint party_merge_sp;
108:
109: -----Debug Messages--------------------
110: FND_FILE.put_line(fnd_file.log, ' ------------------Resource Party Merge-----------------');
111: FND_FILE.put_line(fnd_file.log, ' Begin JTF_RS_PARTY_MERGE_PUB.resource_party_merge(+) ');
112: FND_FILE.put_line(fnd_file.log, ' p_entity_name :'||p_entity_name);
113: FND_FILE.put_line(fnd_file.log, ' p_from_id :'||p_from_id);
114: FND_FILE.put_line(fnd_file.log, ' p_from_fk_id :'||p_from_fk_id);
115: FND_FILE.put_line(fnd_file.log, ' p_to_fk_id :'||p_to_fk_id);

Line 446: FND_FILE.put_line(fnd_file.log, ' End JTF_RS_PARTY_MERGE_PUB.resource_party_merge(-) ');

442: close to_partner_cur;
443: end if; -- end of partner
444: END LOOP;-- end of cat_cur loop
445:
446: FND_FILE.put_line(fnd_file.log, ' End JTF_RS_PARTY_MERGE_PUB.resource_party_merge(-) ');
447: FND_FILE.put_line(fnd_file.log, ' ------------------Resource Party Merge-----------------');
448:
449: EXCEPTION
450: WHEN fnd_api.g_exc_unexpected_error

Line 534: FND_FILE.put_line(fnd_file.log, ' Begin JTF_RS_PARTY_MERGE_PUB.resource_party_site_merge(+) ');

530: savepoint site_merge_sp;
531:
532: -----Debug Messages--------------------
533: FND_FILE.put_line(fnd_file.log, ' ------------------Resource Party Site Merge-----------------');
534: FND_FILE.put_line(fnd_file.log, ' Begin JTF_RS_PARTY_MERGE_PUB.resource_party_site_merge(+) ');
535: FND_FILE.put_line(fnd_file.log, ' p_entity_name :'||p_entity_name);
536: FND_FILE.put_line(fnd_file.log, ' p_from_id :'||p_from_id);
537: FND_FILE.put_line(fnd_file.log, ' p_from_fk_id :'||p_from_fk_id);
538: FND_FILE.put_line(fnd_file.log, ' p_to_fk_id :'||p_to_fk_id);

Line 674: FND_FILE.put_line(fnd_file.log, ' End JTF_RS_PARTY_MERGE_PUB.resource_party_site_merge(-) ');

670: close to_cur;
671:
672: END LOOP; -- end of from_cur loop
673:
674: FND_FILE.put_line(fnd_file.log, ' End JTF_RS_PARTY_MERGE_PUB.resource_party_site_merge(-) ');
675: FND_FILE.put_line(fnd_file.log, ' ------------------Resource Party Site Merge-----------------');
676:
677: EXCEPTION
678: WHEN fnd_api.g_exc_unexpected_error

Line 745: FND_FILE.put_line(fnd_file.log, ' Begin JTF_RS_PARTY_MERGE_PUB.resource_party_cont_merge(+) ');

741: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
742:
743: -----Debug Messages--------------------
744: FND_FILE.put_line(fnd_file.log, ' ------------------Resource Contact Merge-----------------');
745: FND_FILE.put_line(fnd_file.log, ' Begin JTF_RS_PARTY_MERGE_PUB.resource_party_cont_merge(+) ');
746: FND_FILE.put_line(fnd_file.log, ' p_entity_name :'||p_entity_name);
747: FND_FILE.put_line(fnd_file.log, ' p_from_id :'||p_from_id);
748: FND_FILE.put_line(fnd_file.log, ' p_from_fk_id :'||p_from_fk_id);
749: FND_FILE.put_line(fnd_file.log, ' p_to_fk_id :'||p_to_fk_id);

Line 817: FND_FILE.put_line(fnd_file.log, ' End JTF_RS_PARTY_MERGE_PUB.resource_party_cont_merge(-) ');

813: -- end if ;
814: -- close cont_cur ;
815: END LOOP ;
816:
817: FND_FILE.put_line(fnd_file.log, ' End JTF_RS_PARTY_MERGE_PUB.resource_party_cont_merge(-) ');
818: FND_FILE.put_line(fnd_file.log, ' ------------------Resource Contact Merge-----------------');
819:
820: EXCEPTION
821: WHEN fnd_api.g_exc_unexpected_error

Line 1018: FND_FILE.put_line(fnd_file.log, ' Begin JTF_RS_PARTY_MERGE_PUB.synchronize_resource(+) ');

1014: par_address_rec par_address_cur%rowtype;
1015:
1016: begin
1017:
1018: FND_FILE.put_line(fnd_file.log, ' Begin JTF_RS_PARTY_MERGE_PUB.synchronize_resource(+) ');
1019:
1020: SAVEPOINT synchronize_resource_sp;
1021: x_ret_status := fnd_api.g_ret_sts_success;
1022:

Line 1140: FND_FILE.put_line(fnd_file.log, ' End JTF_RS_PARTY_MERGE_PUB.synchronize_resource(-) ');

1136: = (select party_name
1137: from hz_parties
1138: where party_id = p_source_id)
1139: where res.resource_id = p_resource_id;
1140: FND_FILE.put_line(fnd_file.log, ' End JTF_RS_PARTY_MERGE_PUB.synchronize_resource(-) ');
1141:
1142: EXCEPTION
1143: WHEN fnd_api.g_exc_unexpected_error
1144: THEN

Line 1203: FND_FILE.put_line(fnd_file.log, ' Begin JTF_RS_PARTY_MERGE_PUB.resource_support_site_merge(+) ');

1199: x_return_status := fnd_api.g_ret_sts_success;
1200:
1201: -----Debug Messages--------------------
1202: FND_FILE.put_line(fnd_file.log, ' ------------------Resource Support Site Merge-----------------');
1203: FND_FILE.put_line(fnd_file.log, ' Begin JTF_RS_PARTY_MERGE_PUB.resource_support_site_merge(+) ');
1204: FND_FILE.put_line(fnd_file.log, ' p_entity_name :'||p_entity_name);
1205: FND_FILE.put_line(fnd_file.log, ' p_from_id :'||p_from_id);
1206: FND_FILE.put_line(fnd_file.log, ' p_from_fk_id :'||p_from_fk_id);
1207: FND_FILE.put_line(fnd_file.log, ' p_to_fk_id :'||p_to_fk_id);

Line 1273: FND_FILE.put_line(fnd_file.log, ' End JTF_RS_PARTY_MERGE_PUB.resource_support_site_merge(-) ');

1269: -- end if ;
1270: -- close support_site_cur ;
1271: END LOOP ;
1272:
1273: FND_FILE.put_line(fnd_file.log, ' End JTF_RS_PARTY_MERGE_PUB.resource_support_site_merge(-) ');
1274: FND_FILE.put_line(fnd_file.log, ' ------------------Resource Support Site Merge-----------------');
1275:
1276: EXCEPTION
1277: WHEN fnd_api.g_exc_unexpected_error