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.JTF_RS_PARTY_MERGE_PUB dependencies on FND_FILE

Line 110: FND_FILE.put_line(fnd_file.log, ' ------------------Resource Party Merge-----------------');

106: -------------------------------------
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);

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 112: FND_FILE.put_line(fnd_file.log, ' p_entity_name :'||p_entity_name);

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);
116: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);

Line 113: FND_FILE.put_line(fnd_file.log, ' p_from_id :'||p_from_id);

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);
116: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
117: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);

Line 114: FND_FILE.put_line(fnd_file.log, ' p_from_fk_id :'||p_from_fk_id);

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);
116: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
117: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
118: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);

Line 115: FND_FILE.put_line(fnd_file.log, ' p_to_fk_id :'||p_to_fk_id);

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);
116: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
117: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
118: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
119: FND_FILE.put_line(fnd_file.log, ' Error Handling Mode :'||l_error_handle);

Line 116: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);

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);
116: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
117: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
118: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
119: FND_FILE.put_line(fnd_file.log, ' Error Handling Mode :'||l_error_handle);
120: -----End Debug Messages----------------

Line 117: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);

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);
116: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
117: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
118: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
119: FND_FILE.put_line(fnd_file.log, ' Error Handling Mode :'||l_error_handle);
120: -----End Debug Messages----------------
121:

Line 118: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_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);
116: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
117: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
118: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
119: FND_FILE.put_line(fnd_file.log, ' Error Handling Mode :'||l_error_handle);
120: -----End Debug Messages----------------
121:
122: x_return_status := fnd_api.g_ret_sts_success;

Line 119: FND_FILE.put_line(fnd_file.log, ' Error Handling Mode :'||l_error_handle);

115: FND_FILE.put_line(fnd_file.log, ' p_to_fk_id :'||p_to_fk_id);
116: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
117: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
118: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
119: FND_FILE.put_line(fnd_file.log, ' Error Handling Mode :'||l_error_handle);
120: -----End Debug Messages----------------
121:
122: x_return_status := fnd_api.g_ret_sts_success;
123:

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 447: FND_FILE.put_line(fnd_file.log, ' ------------------Resource Party Merge-----------------');

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
451: THEN

Line 533: FND_FILE.put_line(fnd_file.log, ' ------------------Resource Party Site Merge-----------------');

529:
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);

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 535: FND_FILE.put_line(fnd_file.log, ' p_entity_name :'||p_entity_name);

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);
539: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);

Line 536: FND_FILE.put_line(fnd_file.log, ' p_from_id :'||p_from_id);

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);
539: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
540: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);

Line 537: FND_FILE.put_line(fnd_file.log, ' p_from_fk_id :'||p_from_fk_id);

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);
539: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
540: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
541: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);

Line 538: FND_FILE.put_line(fnd_file.log, ' p_to_fk_id :'||p_to_fk_id);

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);
539: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
540: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
541: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
542: FND_FILE.put_line(fnd_file.log, ' Error Handling Mode :'||l_error_handle);

Line 539: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);

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);
539: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
540: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
541: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
542: FND_FILE.put_line(fnd_file.log, ' Error Handling Mode :'||l_error_handle);
543: -----End Debug Messages----------------

Line 540: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);

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);
539: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
540: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
541: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
542: FND_FILE.put_line(fnd_file.log, ' Error Handling Mode :'||l_error_handle);
543: -----End Debug Messages----------------
544:

Line 541: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_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);
539: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
540: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
541: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
542: FND_FILE.put_line(fnd_file.log, ' Error Handling Mode :'||l_error_handle);
543: -----End Debug Messages----------------
544:
545: x_return_status := fnd_api.g_ret_sts_success;

Line 542: FND_FILE.put_line(fnd_file.log, ' Error Handling Mode :'||l_error_handle);

538: FND_FILE.put_line(fnd_file.log, ' p_to_fk_id :'||p_to_fk_id);
539: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
540: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
541: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
542: FND_FILE.put_line(fnd_file.log, ' Error Handling Mode :'||l_error_handle);
543: -----End Debug Messages----------------
544:
545: x_return_status := fnd_api.g_ret_sts_success;
546:

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 675: FND_FILE.put_line(fnd_file.log, ' ------------------Resource Party Site Merge-----------------');

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
679: THEN

Line 744: FND_FILE.put_line(fnd_file.log, ' ------------------Resource Contact Merge-----------------');

740: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
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);

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 746: FND_FILE.put_line(fnd_file.log, ' p_entity_name :'||p_entity_name);

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);
750: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);

Line 747: FND_FILE.put_line(fnd_file.log, ' p_from_id :'||p_from_id);

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);
750: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
751: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);

Line 748: FND_FILE.put_line(fnd_file.log, ' p_from_fk_id :'||p_from_fk_id);

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);
750: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
751: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
752: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);

Line 749: FND_FILE.put_line(fnd_file.log, ' p_to_fk_id :'||p_to_fk_id);

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);
750: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
751: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
752: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
753: -----End Debug Messages----------------

Line 750: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);

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);
750: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
751: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
752: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
753: -----End Debug Messages----------------
754:

Line 751: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);

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);
750: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
751: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
752: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
753: -----End Debug Messages----------------
754:
755: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')

Line 752: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_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);
750: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
751: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
752: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
753: -----End Debug Messages----------------
754:
755: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')
756: or (p_parent_entity_name <> 'HZ_ORG_CONTACTS')

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 818: FND_FILE.put_line(fnd_file.log, ' ------------------Resource Contact Merge-----------------');

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
822: THEN

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 1202: FND_FILE.put_line(fnd_file.log, ' ------------------Resource Support Site Merge-----------------');

1198: savepoint support_site_merge_sp;
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);

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 1204: FND_FILE.put_line(fnd_file.log, ' p_entity_name :'||p_entity_name);

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);
1208: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);

Line 1205: FND_FILE.put_line(fnd_file.log, ' p_from_id :'||p_from_id);

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);
1208: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
1209: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);

Line 1206: FND_FILE.put_line(fnd_file.log, ' p_from_fk_id :'||p_from_fk_id);

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);
1208: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
1209: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
1210: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);

Line 1207: FND_FILE.put_line(fnd_file.log, ' p_to_fk_id :'||p_to_fk_id);

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);
1208: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
1209: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
1210: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
1211: -----End Debug Messages----------------

Line 1208: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);

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);
1208: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
1209: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
1210: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
1211: -----End Debug Messages----------------
1212:

Line 1209: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);

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);
1208: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
1209: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
1210: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
1211: -----End Debug Messages----------------
1212:
1213: --GET USER ID AND SYSDATE

Line 1210: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_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);
1208: FND_FILE.put_line(fnd_file.log, ' p_parent_entity_name:'||p_parent_entity_name);
1209: FND_FILE.put_line(fnd_file.log, ' p_batch_id :'||p_batch_id);
1210: FND_FILE.put_line(fnd_file.log, ' p_batch_party_id :'||p_batch_party_id);
1211: -----End Debug Messages----------------
1212:
1213: --GET USER ID AND SYSDATE
1214: l_date := sysdate;

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

Line 1274: FND_FILE.put_line(fnd_file.log, ' ------------------Resource Support Site Merge-----------------');

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
1278: THEN