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_API

Line 122: x_return_status := fnd_api.g_ret_sts_success;

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:
124: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')
125: or (p_parent_entity_name <> 'HZ_PARTIES')
126: then

Line 131: RAISE fnd_api.g_exc_error;

127: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');
128: fnd_message.set_token('P_ENTITY',p_entity_name);
129: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
130: FND_MSG_PUB.add;
131: RAISE fnd_api.g_exc_error;
132: end if;
133:
134: FOR cat_rec IN cat_cur(p_from_fk_id) LOOP
135: l_address_id := cat_rec.address_id;

Line 155: ,p_init_msg_list => fnd_api.g_false

151: /* Calling publish API to raise merge resource event. Fix for Enhancement: 3295476 */
152: begin
153: jtf_rs_wf_events_pub.merge_resource
154: (p_api_version => 1.0
155: ,p_init_msg_list => fnd_api.g_false
156: ,p_commit => fnd_api.g_false
157: ,p_resource_id => cat_rec.resource_id
158: ,p_repl_resource_id => to_party_rec.resource_id
159: ,p_end_date_active => trunc(sysdate-1)

Line 156: ,p_commit => fnd_api.g_false

152: begin
153: jtf_rs_wf_events_pub.merge_resource
154: (p_api_version => 1.0
155: ,p_init_msg_list => fnd_api.g_false
156: ,p_commit => fnd_api.g_false
157: ,p_resource_id => cat_rec.resource_id
158: ,p_repl_resource_id => to_party_rec.resource_id
159: ,p_end_date_active => trunc(sysdate-1)
160: ,x_return_status => l_return_status

Line 172: P_INIT_MSG_LIST => FND_API.G_FALSE,

168: /* End of publish API call */
169:
170: JTF_RS_RESOURCE_UTL_PUB.END_DATE_EMPLOYEE
171: (P_API_VERSION => 1.0,
172: P_INIT_MSG_LIST => FND_API.G_FALSE,
173: P_COMMIT => FND_API.G_FALSE,
174: P_RESOURCE_ID => cat_rec.resource_id,
175: P_END_DATE_ACTIVE => trunc(sysdate-1) ,
176: X_OBJECT_VER_NUMBER => l_object_ver_number,

Line 173: P_COMMIT => FND_API.G_FALSE,

169:
170: JTF_RS_RESOURCE_UTL_PUB.END_DATE_EMPLOYEE
171: (P_API_VERSION => 1.0,
172: P_INIT_MSG_LIST => FND_API.G_FALSE,
173: P_COMMIT => FND_API.G_FALSE,
174: P_RESOURCE_ID => cat_rec.resource_id,
175: P_END_DATE_ACTIVE => trunc(sysdate-1) ,
176: X_OBJECT_VER_NUMBER => l_object_ver_number,
177: X_RETURN_STATUS => l_return_status,

Line 181: IF (nvl(l_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) then

177: X_RETURN_STATUS => l_return_status,
178: X_MSG_COUNT => l_msg_count,
179: X_MSG_DATA => l_msg_data ) ;
180:
181: IF (nvl(l_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) then
182: x_return_status := l_return_status ;
183: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');
184: FND_MSG_PUB.add;
185: RAISE fnd_api.g_exc_error;

Line 185: RAISE fnd_api.g_exc_error;

181: IF (nvl(l_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) then
182: x_return_status := l_return_status ;
183: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');
184: FND_MSG_PUB.add;
185: RAISE fnd_api.g_exc_error;
186: END IF;
187:
188: ELSIF (l_error_handle = 'ERROR') THEN
189: ----------------------------------------------------

Line 193: x_return_status := fnd_api.g_ret_sts_error;

189: ----------------------------------------------------
190: -- reject merge
191: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');
192: FND_MSG_PUB.add;
193: x_return_status := fnd_api.g_ret_sts_error;
194: RAISE fnd_api.g_exc_error;
195: ----------------------------------------------------
196: END IF;
197: ----------------------------------------------------

Line 194: RAISE fnd_api.g_exc_error;

190: -- reject merge
191: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');
192: FND_MSG_PUB.add;
193: x_return_status := fnd_api.g_ret_sts_error;
194: RAISE fnd_api.g_exc_error;
195: ----------------------------------------------------
196: END IF;
197: ----------------------------------------------------
198: else

Line 213: if(nvl(l_address_id, fnd_api.g_miss_num) <> nvl(cat_rec.address_id, fnd_api.g_miss_num))

209: where resource_id = cat_rec.resource_id;
210:
211: -- x_to_id := p_from_id;
212:
213: if(nvl(l_address_id, fnd_api.g_miss_num) <> nvl(cat_rec.address_id, fnd_api.g_miss_num))
214: then
215: insert into JTF_RS_RESOURCE_EXTN_AUD (
216: RESOURCE_AUDIT_ID,
217: RESOURCE_ID,

Line 279: if(x_return_status <> fnd_api.g_ret_sts_success)

275: p_address_id => l_address_id,
276: p_source_id => p_to_fk_id,
277: x_ret_status => x_return_status);
278:
279: if(x_return_status <> fnd_api.g_ret_sts_success)
280: then
281: RAISE fnd_api.g_exc_error;
282: end if;
283: end if;

Line 281: RAISE fnd_api.g_exc_error;

277: x_ret_status => x_return_status);
278:
279: if(x_return_status <> fnd_api.g_ret_sts_success)
280: then
281: RAISE fnd_api.g_exc_error;
282: end if;
283: end if;
284: close to_party_cur;
285: end if; -- party

Line 307: ,p_init_msg_list => fnd_api.g_false

303:
304: begin
305: jtf_rs_wf_events_pub.merge_resource
306: (p_api_version => 1.0
307: ,p_init_msg_list => fnd_api.g_false
308: ,p_commit => fnd_api.g_false
309: ,p_resource_id => cat_rec.resource_id
310: ,p_repl_resource_id => to_partner_rec.resource_id
311: ,p_end_date_active => trunc(sysdate-1)

Line 308: ,p_commit => fnd_api.g_false

304: begin
305: jtf_rs_wf_events_pub.merge_resource
306: (p_api_version => 1.0
307: ,p_init_msg_list => fnd_api.g_false
308: ,p_commit => fnd_api.g_false
309: ,p_resource_id => cat_rec.resource_id
310: ,p_repl_resource_id => to_partner_rec.resource_id
311: ,p_end_date_active => trunc(sysdate-1)
312: ,x_return_status => l_return_status

Line 324: P_INIT_MSG_LIST => FND_API.G_FALSE,

320: /* End of publish API call */
321:
322: JTF_RS_RESOURCE_UTL_PUB.END_DATE_EMPLOYEE
323: (P_API_VERSION => 1.0,
324: P_INIT_MSG_LIST => FND_API.G_FALSE,
325: P_COMMIT => FND_API.G_FALSE,
326: P_RESOURCE_ID => cat_rec.resource_id,
327: P_END_DATE_ACTIVE => trunc(sysdate-1) ,
328: X_OBJECT_VER_NUMBER => l_object_ver_number,

Line 325: P_COMMIT => FND_API.G_FALSE,

321:
322: JTF_RS_RESOURCE_UTL_PUB.END_DATE_EMPLOYEE
323: (P_API_VERSION => 1.0,
324: P_INIT_MSG_LIST => FND_API.G_FALSE,
325: P_COMMIT => FND_API.G_FALSE,
326: P_RESOURCE_ID => cat_rec.resource_id,
327: P_END_DATE_ACTIVE => trunc(sysdate-1) ,
328: X_OBJECT_VER_NUMBER => l_object_ver_number,
329: X_RETURN_STATUS => l_return_status,

Line 333: IF (nvl(l_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) then

329: X_RETURN_STATUS => l_return_status,
330: X_MSG_COUNT => l_msg_count,
331: X_MSG_DATA => l_msg_data ) ;
332:
333: IF (nvl(l_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) then
334: x_return_status := l_return_status ;
335: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');
336: FND_MSG_PUB.add;
337: RAISE fnd_api.g_exc_error;

Line 337: RAISE fnd_api.g_exc_error;

333: IF (nvl(l_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) then
334: x_return_status := l_return_status ;
335: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');
336: FND_MSG_PUB.add;
337: RAISE fnd_api.g_exc_error;
338: END IF;
339:
340: ELSIF (l_error_handle = 'ERROR') THEN
341: ----------------------------------------------------

Line 345: x_return_status := fnd_api.g_ret_sts_error;

341: ----------------------------------------------------
342: -- reject merge
343: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');
344: FND_MSG_PUB.add;
345: x_return_status := fnd_api.g_ret_sts_error;
346: RAISE fnd_api.g_exc_error;
347: ----------------------------------------------------
348: END IF;
349: ----------------------------------------------------

Line 346: RAISE fnd_api.g_exc_error;

342: -- reject merge
343: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');
344: FND_MSG_PUB.add;
345: x_return_status := fnd_api.g_ret_sts_error;
346: RAISE fnd_api.g_exc_error;
347: ----------------------------------------------------
348: END IF;
349: ----------------------------------------------------
350: else

Line 372: if(nvl(l_address_id, fnd_api.g_miss_num) <> nvl(cat_rec.address_id, fnd_api.g_miss_num))

368: object_version_number = object_version_number + 1
369: where resource_id = cat_rec.resource_id;
370: -- x_to_id := p_from_id;
371:
372: if(nvl(l_address_id, fnd_api.g_miss_num) <> nvl(cat_rec.address_id, fnd_api.g_miss_num))
373: then
374: insert into JTF_RS_RESOURCE_EXTN_AUD (
375: RESOURCE_AUDIT_ID,
376: RESOURCE_ID,

Line 436: if(x_return_status <> fnd_api.g_ret_sts_success)

432: p_category => cat_rec.category,
433: p_address_id => l_address_id,
434: p_source_id => p_to_fk_id,
435: x_ret_status => x_return_status);
436: if(x_return_status <> fnd_api.g_ret_sts_success)
437: then
438: RAISE fnd_api.g_exc_error;
439: end if;
440:

Line 438: RAISE fnd_api.g_exc_error;

434: p_source_id => p_to_fk_id,
435: x_ret_status => x_return_status);
436: if(x_return_status <> fnd_api.g_ret_sts_success)
437: then
438: RAISE fnd_api.g_exc_error;
439: end if;
440:
441: end if;
442: close to_partner_cur;

Line 450: WHEN fnd_api.g_exc_unexpected_error

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
452: x_return_status := fnd_api.g_ret_sts_unexp_error;
453: ROLLBACK TO PARTY_MERGE_SP;
454: WHEN fnd_api.g_exc_error

Line 452: x_return_status := fnd_api.g_ret_sts_unexp_error;

448:
449: EXCEPTION
450: WHEN fnd_api.g_exc_unexpected_error
451: THEN
452: x_return_status := fnd_api.g_ret_sts_unexp_error;
453: ROLLBACK TO PARTY_MERGE_SP;
454: WHEN fnd_api.g_exc_error
455: THEN
456: ROLLBACK TO PARTY_MERGE_SP;

Line 454: WHEN fnd_api.g_exc_error

450: WHEN fnd_api.g_exc_unexpected_error
451: THEN
452: x_return_status := fnd_api.g_ret_sts_unexp_error;
453: ROLLBACK TO PARTY_MERGE_SP;
454: WHEN fnd_api.g_exc_error
455: THEN
456: ROLLBACK TO PARTY_MERGE_SP;
457: x_return_status := fnd_api.g_ret_sts_error;
458: WHEN OTHERS

Line 457: x_return_status := fnd_api.g_ret_sts_error;

453: ROLLBACK TO PARTY_MERGE_SP;
454: WHEN fnd_api.g_exc_error
455: THEN
456: ROLLBACK TO PARTY_MERGE_SP;
457: x_return_status := fnd_api.g_ret_sts_error;
458: WHEN OTHERS
459: THEN
460: ROLLBACK TO PARTY_MERGE_SP;
461: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 466: x_return_status := fnd_api.g_ret_sts_unexp_error;

462: fnd_message.set_token('P_SQLCODE',SQLCODE);
463: fnd_message.set_token('P_SQLERRM',SQLERRM);
464: fnd_message.set_token('P_API_NAME', l_api_name);
465: FND_MSG_PUB.add;
466: x_return_status := fnd_api.g_ret_sts_unexp_error;
467: END resource_party_merge;
468:
469:
470: PROCEDURE resource_party_site_merge(

Line 545: x_return_status := fnd_api.g_ret_sts_success;

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:
547: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')
548: or (p_parent_entity_name <> 'HZ_PARTY_SITES')
549: then

Line 554: RAISE fnd_api.g_exc_error;

550: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');
551: fnd_message.set_token('P_ENTITY',p_entity_name);
552: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
553: FND_MSG_PUB.add;
554: RAISE fnd_api.g_exc_error;
555: end if;
556:
557: -- get the values of the from record
558: FOR from_rec IN from_cur(p_from_fk_id) LOOP

Line 579: ,p_init_msg_list => fnd_api.g_false

575:
576: begin
577: jtf_rs_wf_events_pub.merge_resource
578: (p_api_version => 1.0
579: ,p_init_msg_list => fnd_api.g_false
580: ,p_commit => fnd_api.g_false
581: ,p_resource_id => from_rec.resource_id
582: ,p_repl_resource_id => to_rec.resource_id
583: ,p_end_date_active => trunc(sysdate-1)

Line 580: ,p_commit => fnd_api.g_false

576: begin
577: jtf_rs_wf_events_pub.merge_resource
578: (p_api_version => 1.0
579: ,p_init_msg_list => fnd_api.g_false
580: ,p_commit => fnd_api.g_false
581: ,p_resource_id => from_rec.resource_id
582: ,p_repl_resource_id => to_rec.resource_id
583: ,p_end_date_active => trunc(sysdate-1)
584: ,x_return_status => l_return_status

Line 596: P_INIT_MSG_LIST => FND_API.G_FALSE,

592: /* End of publish API call */
593:
594: JTF_RS_RESOURCE_UTL_PUB.END_DATE_EMPLOYEE
595: (P_API_VERSION => 1.0,
596: P_INIT_MSG_LIST => FND_API.G_FALSE,
597: P_COMMIT => FND_API.G_FALSE,
598: P_RESOURCE_ID => from_rec.resource_id,
599: P_END_DATE_ACTIVE => trunc(sysdate-1) ,
600: X_OBJECT_VER_NUMBER => l_object_ver_number,

Line 597: P_COMMIT => FND_API.G_FALSE,

593:
594: JTF_RS_RESOURCE_UTL_PUB.END_DATE_EMPLOYEE
595: (P_API_VERSION => 1.0,
596: P_INIT_MSG_LIST => FND_API.G_FALSE,
597: P_COMMIT => FND_API.G_FALSE,
598: P_RESOURCE_ID => from_rec.resource_id,
599: P_END_DATE_ACTIVE => trunc(sysdate-1) ,
600: X_OBJECT_VER_NUMBER => l_object_ver_number,
601: X_RETURN_STATUS => l_return_status,

Line 605: IF (nvl(l_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) then

601: X_RETURN_STATUS => l_return_status,
602: X_MSG_COUNT => l_msg_count,
603: X_MSG_DATA => l_msg_data ) ;
604:
605: IF (nvl(l_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) then
606: x_return_status := l_return_status ;
607: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');
608: FND_MSG_PUB.add;
609: RAISE fnd_api.g_exc_error;

Line 609: RAISE fnd_api.g_exc_error;

605: IF (nvl(l_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) then
606: x_return_status := l_return_status ;
607: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');
608: FND_MSG_PUB.add;
609: RAISE fnd_api.g_exc_error;
610: END IF;
611:
612: ELSIF (l_error_handle = 'ERROR') THEN
613: ----------------------------------------------------

Line 617: x_return_status := fnd_api.g_ret_sts_error;

613: ----------------------------------------------------
614: --reject merge
615: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');
616: FND_MSG_PUB.add;
617: x_return_status := fnd_api.g_ret_sts_error;
618: RAISE fnd_api.g_exc_error;
619: ----------------------------------------------------
620: END IF;
621: ----------------------------------------------------

Line 618: RAISE fnd_api.g_exc_error;

614: --reject merge
615: fnd_message.set_name ('JTF', 'JTF_RS_REJECT_MERGE');
616: FND_MSG_PUB.add;
617: x_return_status := fnd_api.g_ret_sts_error;
618: RAISE fnd_api.g_exc_error;
619: ----------------------------------------------------
620: END IF;
621: ----------------------------------------------------
622: else

Line 664: if(x_return_status <> fnd_api.g_ret_sts_success)

660: p_address_id => p_to_fk_id,
661: p_source_id => from_rec.source_id,
662: x_ret_status => x_return_status);
663:
664: if(x_return_status <> fnd_api.g_ret_sts_success)
665: then
666: RAISE fnd_api.g_exc_error;
667: end if;
668: */

Line 666: RAISE fnd_api.g_exc_error;

662: x_ret_status => x_return_status);
663:
664: if(x_return_status <> fnd_api.g_ret_sts_success)
665: then
666: RAISE fnd_api.g_exc_error;
667: end if;
668: */
669: end if;
670: close to_cur;

Line 678: WHEN fnd_api.g_exc_unexpected_error

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
680: x_return_status := fnd_api.g_ret_sts_unexp_error;
681: ROLLBACK TO site_merge_sp;
682: WHEN fnd_api.g_exc_error

Line 680: x_return_status := fnd_api.g_ret_sts_unexp_error;

676:
677: EXCEPTION
678: WHEN fnd_api.g_exc_unexpected_error
679: THEN
680: x_return_status := fnd_api.g_ret_sts_unexp_error;
681: ROLLBACK TO site_merge_sp;
682: WHEN fnd_api.g_exc_error
683: THEN
684: ROLLBACK TO site_merge_sp;

Line 682: WHEN fnd_api.g_exc_error

678: WHEN fnd_api.g_exc_unexpected_error
679: THEN
680: x_return_status := fnd_api.g_ret_sts_unexp_error;
681: ROLLBACK TO site_merge_sp;
682: WHEN fnd_api.g_exc_error
683: THEN
684: ROLLBACK TO site_merge_sp;
685: x_return_status := fnd_api.g_ret_sts_error;
686: WHEN OTHERS

Line 685: x_return_status := fnd_api.g_ret_sts_error;

681: ROLLBACK TO site_merge_sp;
682: WHEN fnd_api.g_exc_error
683: THEN
684: ROLLBACK TO site_merge_sp;
685: x_return_status := fnd_api.g_ret_sts_error;
686: WHEN OTHERS
687: THEN
688: ROLLBACK TO site_merge_sp;
689: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 694: x_return_status := fnd_api.g_ret_sts_unexp_error;

690: fnd_message.set_token('P_SQLCODE',SQLCODE);
691: fnd_message.set_token('P_SQLERRM',SQLERRM);
692: fnd_message.set_token('P_API_NAME', l_api_name);
693: FND_MSG_PUB.add;
694: x_return_status := fnd_api.g_ret_sts_unexp_error;
695: end resource_party_site_merge;
696:
697: PROCEDURE resource_party_cont_merge(
698: p_entity_name IN VARCHAR2,

Line 736: x_return_status := fnd_api.g_ret_sts_success;

732: l_login_id Number;
733: dummy varchar2(1) ;
734: begin
735: savepoint cont_merge_sp;
736: x_return_status := fnd_api.g_ret_sts_success;
737:
738: --GET USER ID AND SYSDATE
739: l_date := sysdate;
740: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

Line 762: RAISE fnd_api.g_exc_error;

758: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');
759: fnd_message.set_token('P_ENTITY',p_entity_name);
760: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
761: FND_MSG_PUB.add;
762: RAISE fnd_api.g_exc_error;
763: end if;
764:
765: FOR res_rec IN res_cur(p_from_fk_id) LOOP
766:

Line 776: x_return_status := fnd_api.g_ret_sts_error;

772: fetch cont_cur into dummy ;
773: if cont_cur%NOTFOUND then
774: fnd_message.set_name ('JTF', 'JTF_RS_VALID_TO_ID_ERR');
775: FND_MSG_PUB.add;
776: x_return_status := fnd_api.g_ret_sts_error;
777: RAISE fnd_api.g_exc_error;
778: else
779: */
780: update jtf_rs_resource_extns

Line 777: RAISE fnd_api.g_exc_error;

773: if cont_cur%NOTFOUND then
774: fnd_message.set_name ('JTF', 'JTF_RS_VALID_TO_ID_ERR');
775: FND_MSG_PUB.add;
776: x_return_status := fnd_api.g_ret_sts_error;
777: RAISE fnd_api.g_exc_error;
778: else
779: */
780: update jtf_rs_resource_extns
781: set contact_id = p_to_fk_id,

Line 821: WHEN fnd_api.g_exc_unexpected_error

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
823: x_return_status := fnd_api.g_ret_sts_unexp_error;
824: ROLLBACK TO cont_merge_sp;
825: WHEN fnd_api.g_exc_error

Line 823: x_return_status := fnd_api.g_ret_sts_unexp_error;

819:
820: EXCEPTION
821: WHEN fnd_api.g_exc_unexpected_error
822: THEN
823: x_return_status := fnd_api.g_ret_sts_unexp_error;
824: ROLLBACK TO cont_merge_sp;
825: WHEN fnd_api.g_exc_error
826: THEN
827: ROLLBACK TO cont_merge_sp;

Line 825: WHEN fnd_api.g_exc_error

821: WHEN fnd_api.g_exc_unexpected_error
822: THEN
823: x_return_status := fnd_api.g_ret_sts_unexp_error;
824: ROLLBACK TO cont_merge_sp;
825: WHEN fnd_api.g_exc_error
826: THEN
827: ROLLBACK TO cont_merge_sp;
828: x_return_status := fnd_api.g_ret_sts_error;
829: WHEN OTHERS

Line 828: x_return_status := fnd_api.g_ret_sts_error;

824: ROLLBACK TO cont_merge_sp;
825: WHEN fnd_api.g_exc_error
826: THEN
827: ROLLBACK TO cont_merge_sp;
828: x_return_status := fnd_api.g_ret_sts_error;
829: WHEN OTHERS
830: THEN
831: ROLLBACK TO cont_merge_sp;
832: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 837: x_return_status := fnd_api.g_ret_sts_unexp_error;

833: fnd_message.set_token('P_SQLCODE',SQLCODE);
834: fnd_message.set_token('P_SQLERRM',SQLERRM);
835: fnd_message.set_token('P_API_NAME', l_api_name);
836: FND_MSG_PUB.add;
837: x_return_status := fnd_api.g_ret_sts_unexp_error;
838: end resource_party_cont_merge;
839:
840: PROCEDURE synchronize_resource(p_resource_id IN NUMBER,
841: p_category IN VARCHAR2,

Line 1021: x_ret_status := fnd_api.g_ret_sts_success;

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:
1023: if(p_category = 'PARTY')
1024: THEN
1025: open party_cur;

Line 1143: WHEN fnd_api.g_exc_unexpected_error

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
1145: ROLLBACK TO synchronize_resource_sp;
1146: x_ret_status := fnd_api.g_ret_sts_error;
1147: WHEN fnd_api.g_exc_error

Line 1146: x_ret_status := fnd_api.g_ret_sts_error;

1142: EXCEPTION
1143: WHEN fnd_api.g_exc_unexpected_error
1144: THEN
1145: ROLLBACK TO synchronize_resource_sp;
1146: x_ret_status := fnd_api.g_ret_sts_error;
1147: WHEN fnd_api.g_exc_error
1148: THEN
1149: ROLLBACK TO synchronize_resource_sp;
1150: x_ret_status := fnd_api.g_ret_sts_error;

Line 1147: WHEN fnd_api.g_exc_error

1143: WHEN fnd_api.g_exc_unexpected_error
1144: THEN
1145: ROLLBACK TO synchronize_resource_sp;
1146: x_ret_status := fnd_api.g_ret_sts_error;
1147: WHEN fnd_api.g_exc_error
1148: THEN
1149: ROLLBACK TO synchronize_resource_sp;
1150: x_ret_status := fnd_api.g_ret_sts_error;
1151: WHEN OTHERS

Line 1150: x_ret_status := fnd_api.g_ret_sts_error;

1146: x_ret_status := fnd_api.g_ret_sts_error;
1147: WHEN fnd_api.g_exc_error
1148: THEN
1149: ROLLBACK TO synchronize_resource_sp;
1150: x_ret_status := fnd_api.g_ret_sts_error;
1151: WHEN OTHERS
1152: THEN
1153: ROLLBACK TO synchronize_resource_sp;
1154: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 1159: x_ret_status := fnd_api.g_ret_sts_error;

1155: fnd_message.set_token('P_SQLCODE',SQLCODE);
1156: fnd_message.set_token('P_SQLERRM',SQLERRM);
1157: fnd_message.set_token('P_API_NAME', l_api_name);
1158: FND_MSG_PUB.add;
1159: x_ret_status := fnd_api.g_ret_sts_error;
1160:
1161: end synchronize_resource;
1162:
1163: PROCEDURE resource_support_site_merge(

Line 1199: x_return_status := fnd_api.g_ret_sts_success;

1195: l_login_id Number;
1196: dummy varchar2(1) ;
1197: begin
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(+) ');

Line 1225: RAISE fnd_api.g_exc_error;

1221: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');
1222: fnd_message.set_token('P_ENTITY',p_entity_name);
1223: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
1224: FND_MSG_PUB.add;
1225: RAISE fnd_api.g_exc_error;
1226: end if;
1227:
1228: FOR res_rec IN res_cur(p_from_fk_id) LOOP
1229: -- open support_site_cur(p_to_fk_id) ;

Line 1234: -- x_return_status := fnd_api.g_ret_sts_error;

1230: -- fetch support_site_cur into dummy ;
1231: -- if support_site_cur%NOTFOUND then
1232: -- fnd_message.set_name ('JTF', 'JTF_RS_VALID_TO_ID_ERR');
1233: -- FND_MSG_PUB.add;
1234: -- x_return_status := fnd_api.g_ret_sts_error;
1235: -- RAISE fnd_api.g_exc_error;
1236: -- else
1237: update jtf_rs_resource_extns
1238: set support_site_id = p_to_fk_id,

Line 1235: -- RAISE fnd_api.g_exc_error;

1231: -- if support_site_cur%NOTFOUND then
1232: -- fnd_message.set_name ('JTF', 'JTF_RS_VALID_TO_ID_ERR');
1233: -- FND_MSG_PUB.add;
1234: -- x_return_status := fnd_api.g_ret_sts_error;
1235: -- RAISE fnd_api.g_exc_error;
1236: -- else
1237: update jtf_rs_resource_extns
1238: set support_site_id = p_to_fk_id,
1239: object_version_number = object_version_number + 1

Line 1277: WHEN fnd_api.g_exc_unexpected_error

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
1279: x_return_status := fnd_api.g_ret_sts_unexp_error;
1280: ROLLBACK TO support_site_merge_sp;
1281: WHEN fnd_api.g_exc_error

Line 1279: x_return_status := fnd_api.g_ret_sts_unexp_error;

1275:
1276: EXCEPTION
1277: WHEN fnd_api.g_exc_unexpected_error
1278: THEN
1279: x_return_status := fnd_api.g_ret_sts_unexp_error;
1280: ROLLBACK TO support_site_merge_sp;
1281: WHEN fnd_api.g_exc_error
1282: THEN
1283: ROLLBACK TO support_site_merge_sp;

Line 1281: WHEN fnd_api.g_exc_error

1277: WHEN fnd_api.g_exc_unexpected_error
1278: THEN
1279: x_return_status := fnd_api.g_ret_sts_unexp_error;
1280: ROLLBACK TO support_site_merge_sp;
1281: WHEN fnd_api.g_exc_error
1282: THEN
1283: ROLLBACK TO support_site_merge_sp;
1284: x_return_status := fnd_api.g_ret_sts_error;
1285: WHEN OTHERS

Line 1284: x_return_status := fnd_api.g_ret_sts_error;

1280: ROLLBACK TO support_site_merge_sp;
1281: WHEN fnd_api.g_exc_error
1282: THEN
1283: ROLLBACK TO support_site_merge_sp;
1284: x_return_status := fnd_api.g_ret_sts_error;
1285: WHEN OTHERS
1286: THEN
1287: ROLLBACK TO support_site_merge_sp;
1288: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 1293: x_return_status := fnd_api.g_ret_sts_unexp_error;

1289: fnd_message.set_token('P_SQLCODE',SQLCODE);
1290: fnd_message.set_token('P_SQLERRM',SQLERRM);
1291: fnd_message.set_token('P_API_NAME', l_api_name);
1292: FND_MSG_PUB.add;
1293: x_return_status := fnd_api.g_ret_sts_unexp_error;
1294: end resource_support_site_merge;
1295:
1296: end;