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.PVX_PARTY_MERGE_PKG dependencies on FND_API

Line 69: x_return_status := FND_API.G_RET_STS_SUCCESS;

65: Debug(G_PKG_NAME || '.' || l_api_name || ' starts: ' ||
66: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
67:
68:
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70:
71: IF (p_from_fk_id = p_to_fk_id) THEN
72: p_to_id := p_from_id;
73: RETURN;

Line 133: x_return_status := FND_API.G_RET_STS_ERROR;

129:
130: EXCEPTION
131: WHEN OTHERS THEN
132: Debug(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: raise;
135: END;
136: END IF;
137:

Line 232: x_return_status := FND_API.G_RET_STS_SUCCESS;

228: BEGIN
229: Debug(G_PKG_NAME || '.' || l_api_name || ' starts: ' ||
230: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
231:
232: x_return_status := FND_API.G_RET_STS_SUCCESS;
233:
234: Debug(G_PKG_NAME || '.' || l_api_name || ' ends: ' ||
235: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
236:

Line 238: WHEN FND_API.G_EXC_ERROR THEN

234: Debug(G_PKG_NAME || '.' || l_api_name || ' ends: ' ||
235: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
236:
237: exception
238: WHEN FND_API.G_EXC_ERROR THEN
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
241: p_count => l_msg_count,
242: p_data => l_msg_data);

Line 239: x_return_status := FND_API.G_RET_STS_ERROR;

235: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
236:
237: exception
238: WHEN FND_API.G_EXC_ERROR THEN
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
241: p_count => l_msg_count,
242: p_data => l_msg_data);
243:

Line 240: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

236:
237: exception
238: WHEN FND_API.G_EXC_ERROR THEN
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
241: p_count => l_msg_count,
242: p_data => l_msg_data);
243:
244: when others then

Line 248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

244: when others then
245: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
246: fnd_message.set_token('ERROR',SQLERRM);
247: fnd_msg_pub.add;
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249: raise;
250:
251: END MERGE_PARTNER_PROFILES1;
252:

Line 310: x_return_status := FND_API.G_RET_STS_SUCCESS;

306:
307: Debug(G_PKG_NAME || '.' || l_api_name || ' starts: ' ||
308: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
309:
310: x_return_status := FND_API.G_RET_STS_SUCCESS;
311:
312: IF (p_from_fk_id = p_to_fk_id) THEN
313: p_to_id := p_from_id;
314: RETURN;

Line 376: WHEN FND_API.G_EXC_ERROR THEN

372: -- --------------------------------------------------------
373: -- Exception Handling
374: -- --------------------------------------------------------
375: exception
376: WHEN FND_API.G_EXC_ERROR THEN
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
379: p_count => l_msg_count,
380: p_data => l_msg_data);

Line 377: x_return_status := FND_API.G_RET_STS_ERROR;

373: -- Exception Handling
374: -- --------------------------------------------------------
375: exception
376: WHEN FND_API.G_EXC_ERROR THEN
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
379: p_count => l_msg_count,
380: p_data => l_msg_data);
381:

Line 378: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

374: -- --------------------------------------------------------
375: exception
376: WHEN FND_API.G_EXC_ERROR THEN
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
379: p_count => l_msg_count,
380: p_data => l_msg_data);
381:
382: when others then

Line 386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

382: when others then
383: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
384: fnd_message.set_token('ERROR',SQLERRM);
385: fnd_msg_pub.add;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: raise;
388:
389: END MERGE_PARTNER_PROFILES2;
390:

Line 418: x_return_status := FND_API.G_RET_STS_SUCCESS;

414: BEGIN
415: Debug(G_PKG_NAME || '.' || l_api_name || ' starts: ' ||
416: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
417:
418: x_return_status := FND_API.G_RET_STS_SUCCESS;
419:
420: Debug(G_PKG_NAME || '.' || l_api_name || ' ends: ' ||
421: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
422:

Line 428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

424: when others then
425: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
426: fnd_message.set_token('ERROR',SQLERRM);
427: fnd_msg_pub.add;
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: raise;
430:
431: END MERGE_PARTNER_ENTITY_ATTRS;
432:

Line 467: x_return_status := FND_API.G_RET_STS_SUCCESS;

463: BEGIN
464: Debug(G_PKG_NAME || '.' || l_api_name || ' starts: ' ||
465: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
466:
467: x_return_status := FND_API.G_RET_STS_SUCCESS;
468:
469: select merge_reason_code
470: into l_merge_reason_code
471: from hz_merge_batch

Line 531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

527: when others then
528: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
529: fnd_message.set_token('ERROR',SQLERRM);
530: fnd_msg_pub.add;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: raise;
533:
534: END MERGE_LEAD_ASSIGNMENTS;
535:

Line 567: x_return_status := FND_API.G_RET_STS_SUCCESS;

563: BEGIN
564: Debug(G_PKG_NAME || '.' || l_api_name || ' starts: ' ||
565: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
566:
567: x_return_status := FND_API.G_RET_STS_SUCCESS;
568:
569: select merge_reason_code
570: into l_merge_reason_code
571: from hz_merge_batch

Line 630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

626: when others then
627: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
628: fnd_message.set_token('ERROR',SQLERRM);
629: fnd_msg_pub.add;
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: raise;
632:
633: END MERGE_ASSIGNMENT_LOGS;
634:

Line 661: x_return_status := FND_API.G_RET_STS_SUCCESS;

657: BEGIN
658: Debug(G_PKG_NAME || '.' || l_api_name || ' starts: ' ||
659: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
660:
661: x_return_status := FND_API.G_RET_STS_SUCCESS;
662:
663: Debug(G_PKG_NAME || '.' || l_api_name || ' ends: ' ||
664: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
665:

Line 671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

667: when others then
668: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
669: fnd_message.set_token('ERROR',SQLERRM);
670: fnd_msg_pub.add;
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: raise;
673:
674: END MERGE_SEARCH_ATTR_VALUES;
675:

Line 707: x_return_status := FND_API.G_RET_STS_SUCCESS;

703: BEGIN
704: Debug(G_PKG_NAME || '.' || l_api_name || ' starts: ' ||
705: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
706:
707: x_return_status := FND_API.G_RET_STS_SUCCESS;
708:
709: select merge_reason_code
710: into l_merge_reason_code
711: from hz_merge_batch

Line 771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

767: when others then
768: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
769: fnd_message.set_token('ERROR',SQLERRM);
770: fnd_msg_pub.add;
771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: raise;
773:
774: END MERGE_LEAD_PSS_LINES;
775:

Line 807: x_return_status := FND_API.G_RET_STS_SUCCESS;

803: BEGIN
804: Debug(G_PKG_NAME || '.' || l_api_name || ' starts: ' ||
805: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
806:
807: x_return_status := FND_API.G_RET_STS_SUCCESS;
808:
809: select merge_reason_code
810: into l_merge_reason_code
811: from hz_merge_batch

Line 872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

868: when others then
869: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
870: fnd_message.set_token('ERROR',SQLERRM);
871: fnd_msg_pub.add;
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873: raise;
874:
875: END MERGE_GE_PARTY_NOTIFICATIONS;
876:

Line 908: x_return_status := FND_API.G_RET_STS_SUCCESS;

904: BEGIN
905: Debug(G_PKG_NAME || '.' || l_api_name || ' starts: ' ||
906: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
907:
908: x_return_status := FND_API.G_RET_STS_SUCCESS;
909:
910: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing
911: -- needs to be done. Set Merged To Id is same as Merged From Id and return
912:

Line 928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

924: when others then
925: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
926: fnd_message.set_token('ERROR',SQLERRM);
927: fnd_msg_pub.add;
928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
929: raise;
930:
931: END MERGE_PG_ENRL_REQUESTS;
932:

Line 969: x_return_status := FND_API.G_RET_STS_SUCCESS;

965: BEGIN
966: Debug(G_PKG_NAME || '.' || l_api_name || ' starts: ' ||
967: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
968:
969: x_return_status := FND_API.G_RET_STS_SUCCESS;
970:
971:
972: -- If the parent has NOT changed (ie. Parent getting transferred) then nothing
973: -- needs to be done. Set Merged To Id is same as Merged From Id and return

Line 1016: ,p_init_msg_list => FND_API.G_FALSE

1012:
1013: PV_PG_MEMBERSHIPS_PVT.Terminate_ptr_memberships
1014: (
1015: p_api_version_number => 1.0
1016: ,p_init_msg_list => FND_API.G_FALSE
1017: ,p_commit => FND_API.G_FALSE
1018: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1019: ,p_partner_id => p_from_fk_id
1020: ,p_memb_type => l_current_memb_type

Line 1017: ,p_commit => FND_API.G_FALSE

1013: PV_PG_MEMBERSHIPS_PVT.Terminate_ptr_memberships
1014: (
1015: p_api_version_number => 1.0
1016: ,p_init_msg_list => FND_API.G_FALSE
1017: ,p_commit => FND_API.G_FALSE
1018: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1019: ,p_partner_id => p_from_fk_id
1020: ,p_memb_type => l_current_memb_type
1021: ,p_status_reason_code => 'PARTY_MERGE' -- seed PARTY_MERGE it validates against PV_MEMB_STATUS_REASON_CODE

Line 1018: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1014: (
1015: p_api_version_number => 1.0
1016: ,p_init_msg_list => FND_API.G_FALSE
1017: ,p_commit => FND_API.G_FALSE
1018: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1019: ,p_partner_id => p_from_fk_id
1020: ,p_memb_type => l_current_memb_type
1021: ,p_status_reason_code => 'PARTY_MERGE' -- seed PARTY_MERGE it validates against PV_MEMB_STATUS_REASON_CODE
1022: ,p_comments => null

Line 1041: ,p_init_msg_list => FND_API.G_FALSE

1037: IF l_current_memb_type IN ( 'GLOBAL', 'SUBSIDIARY' ) THEN
1038: Pv_ptr_member_type_pvt.Register_term_ptr_memb_type
1039: (
1040: p_api_version_number => 1.0
1041: ,p_init_msg_list => FND_API.G_FALSE
1042: ,p_commit => FND_API.G_FALSE
1043: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1044: ,p_partner_id => p_from_fk_id
1045: ,p_current_memb_type => l_current_memb_type

Line 1042: ,p_commit => FND_API.G_FALSE

1038: Pv_ptr_member_type_pvt.Register_term_ptr_memb_type
1039: (
1040: p_api_version_number => 1.0
1041: ,p_init_msg_list => FND_API.G_FALSE
1042: ,p_commit => FND_API.G_FALSE
1043: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1044: ,p_partner_id => p_from_fk_id
1045: ,p_current_memb_type => l_current_memb_type
1046: ,p_new_memb_type => null

Line 1043: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1039: (
1040: p_api_version_number => 1.0
1041: ,p_init_msg_list => FND_API.G_FALSE
1042: ,p_commit => FND_API.G_FALSE
1043: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1044: ,p_partner_id => p_from_fk_id
1045: ,p_current_memb_type => l_current_memb_type
1046: ,p_new_memb_type => null
1047: ,p_global_ptr_id => null

Line 1068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1064: WHEN OTHERS THEN
1065: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1066: fnd_message.set_token('ERROR',SQLERRM);
1067: fnd_msg_pub.add;
1068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1069: RAISE;
1070:
1071: END MERGE_PG_MEMBERSHIPS;
1072:

Line 1152: x_return_status := FND_API.G_RET_STS_SUCCESS;

1148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity: '||p_parent_entity_name);
1149: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_fk: '||p_from_fk_id);
1150: FND_FILE.PUT_LINE(FND_FILE.LOG,'to_fk: '||p_to_fk_id);
1151:
1152: x_return_status := FND_API.G_RET_STS_SUCCESS;
1153:
1154: select merge_reason_code into l_merge_reason_code
1155: from HZ_MERGE_BATCH
1156: where batch_id = p_batch_id;

Line 1225: p_init_msg_list => FND_API.G_FALSE,

1221:
1222: -- Call Channel_Team_Organization_Update to re-assign the Channel team
1223: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1224: p_api_version_number => 1.0 ,
1225: p_init_msg_list => FND_API.G_FALSE,
1226: p_commit => FND_API.G_FALSE,
1227: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1228: x_return_status => l_return_status,
1229: x_msg_count => l_msg_count,

Line 1226: p_commit => FND_API.G_FALSE,

1222: -- Call Channel_Team_Organization_Update to re-assign the Channel team
1223: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1224: p_api_version_number => 1.0 ,
1225: p_init_msg_list => FND_API.G_FALSE,
1226: p_commit => FND_API.G_FALSE,
1227: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1228: x_return_status => l_return_status,
1229: x_msg_count => l_msg_count,
1230: x_msg_data => l_msg_data,

Line 1227: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1223: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1224: p_api_version_number => 1.0 ,
1225: p_init_msg_list => FND_API.G_FALSE,
1226: p_commit => FND_API.G_FALSE,
1227: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1228: x_return_status => l_return_status,
1229: x_msg_count => l_msg_count,
1230: x_msg_data => l_msg_data,
1231: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,

Line 1234: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1230: x_msg_data => l_msg_data,
1231: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,
1232: x_partner_id => l_partner_id );
1233:
1234: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1235: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1236: RAISE FND_API.G_EXC_ERROR;
1237: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1235: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1231: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,
1232: x_partner_id => l_partner_id );
1233:
1234: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1235: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1236: RAISE FND_API.G_EXC_ERROR;
1237: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1239: END IF;

Line 1236: RAISE FND_API.G_EXC_ERROR;

1232: x_partner_id => l_partner_id );
1233:
1234: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1235: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1236: RAISE FND_API.G_EXC_ERROR;
1237: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1239: END IF;
1240: END IF;

Line 1237: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1233:
1234: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1235: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1236: RAISE FND_API.G_EXC_ERROR;
1237: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1239: END IF;
1240: END IF;
1241: ELSE

Line 1238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1234: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1235: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1236: RAISE FND_API.G_EXC_ERROR;
1237: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1239: END IF;
1240: END IF;
1241: ELSE
1242: CLOSE l_chng_partner_exist_csr;

Line 1247: ,p_init_msg_list => FND_API.G_FALSE

1243: IF (l_processed_flag <> 'P') THEN
1244: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
1245: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1246: p_api_version_number => 1.0
1247: ,p_init_msg_list => FND_API.G_FALSE
1248: ,p_commit => FND_API.G_FALSE
1249: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1250: ,x_return_status => l_return_status
1251: ,x_msg_count => l_msg_count

Line 1248: ,p_commit => FND_API.G_FALSE

1244: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
1245: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1246: p_api_version_number => 1.0
1247: ,p_init_msg_list => FND_API.G_FALSE
1248: ,p_commit => FND_API.G_FALSE
1249: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1250: ,x_return_status => l_return_status
1251: ,x_msg_count => l_msg_count
1252: ,x_msg_data => l_msg_data

Line 1249: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1245: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1246: p_api_version_number => 1.0
1247: ,p_init_msg_list => FND_API.G_FALSE
1248: ,p_commit => FND_API.G_FALSE
1249: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1250: ,x_return_status => l_return_status
1251: ,x_msg_count => l_msg_count
1252: ,x_msg_data => l_msg_data
1253: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);

Line 1255: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1251: ,x_msg_count => l_msg_count
1252: ,x_msg_data => l_msg_data
1253: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
1254:
1255: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1256: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1257: RAISE FND_API.G_EXC_ERROR;
1258: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1259: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

Line 1256: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1252: ,x_msg_data => l_msg_data
1253: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
1254:
1255: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1256: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1257: RAISE FND_API.G_EXC_ERROR;
1258: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1259: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1260: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');

Line 1257: RAISE FND_API.G_EXC_ERROR;

1253: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
1254:
1255: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1256: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1257: RAISE FND_API.G_EXC_ERROR;
1258: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1259: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1260: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1261: FND_MSG_PUB.Add;

Line 1258: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1254:
1255: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1256: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1257: RAISE FND_API.G_EXC_ERROR;
1258: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1259: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1260: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1261: FND_MSG_PUB.Add;
1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1258: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1259: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1260: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1261: FND_MSG_PUB.Add;
1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1263: END IF;
1264: END IF;
1265: END IF; --l_processed_flag <> 'P'
1266: END IF; -- l_chng_partner_exist_csr%NOTFOUND

Line 1274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1270: WHEN OTHERS THEN
1271: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1272: fnd_message.set_token('ERROR',SQLERRM);
1273: fnd_msg_pub.add;
1274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1275: raise;
1276: END;
1277: END IF; -- p_from_fk_id <> p_to_fk_id
1278:

Line 1307: x_return_status := FND_API.G_RET_STS_SUCCESS;

1303: BEGIN
1304: Debug(G_PKG_NAME || '.' || l_api_name || ' starts: ' ||
1305: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
1306:
1307: x_return_status := FND_API.G_RET_STS_SUCCESS;
1308:
1309: if p_from_fk_id = p_to_fk_id then
1310: p_to_id := p_from_id;
1311: return;

Line 1316: ,p_init_msg_list => FND_API.G_FALSE

1312: end if;
1313:
1314: Pv_User_Resp_Pvt.manage_merged_party_memb_resp(
1315: p_api_version_number => 1.0
1316: ,p_init_msg_list => FND_API.G_FALSE
1317: ,p_commit => FND_API.G_FALSE
1318: ,x_return_status => x_return_status
1319: ,x_msg_count => l_msg_count
1320: ,x_msg_data => l_msg_data

Line 1317: ,p_commit => FND_API.G_FALSE

1313:
1314: Pv_User_Resp_Pvt.manage_merged_party_memb_resp(
1315: p_api_version_number => 1.0
1316: ,p_init_msg_list => FND_API.G_FALSE
1317: ,p_commit => FND_API.G_FALSE
1318: ,x_return_status => x_return_status
1319: ,x_msg_count => l_msg_count
1320: ,x_msg_data => l_msg_data
1321: ,p_from_partner_id => p_from_fk_id

Line 1324: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

1320: ,x_msg_data => l_msg_data
1321: ,p_from_partner_id => p_from_fk_id
1322: ,p_to_partner_id => p_to_fk_id
1323: );
1324: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1325: RAISE FND_API.G_EXC_ERROR;
1326: END IF;
1327:
1328: Debug(G_PKG_NAME || '.' || l_api_name || ' ends: ' ||

Line 1325: RAISE FND_API.G_EXC_ERROR;

1321: ,p_from_partner_id => p_from_fk_id
1322: ,p_to_partner_id => p_to_fk_id
1323: );
1324: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1325: RAISE FND_API.G_EXC_ERROR;
1326: END IF;
1327:
1328: Debug(G_PKG_NAME || '.' || l_api_name || ' ends: ' ||
1329: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));

Line 1335: WHEN FND_API.G_EXC_ERROR THEN

1331: -- --------------------------------------------------------
1332: -- Exception Handling
1333: -- --------------------------------------------------------
1334: exception
1335: WHEN FND_API.G_EXC_ERROR THEN
1336: x_return_status := FND_API.G_RET_STS_ERROR;
1337: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1338: p_count => l_msg_count,
1339: p_data => l_msg_data);

Line 1336: x_return_status := FND_API.G_RET_STS_ERROR;

1332: -- Exception Handling
1333: -- --------------------------------------------------------
1334: exception
1335: WHEN FND_API.G_EXC_ERROR THEN
1336: x_return_status := FND_API.G_RET_STS_ERROR;
1337: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1338: p_count => l_msg_count,
1339: p_data => l_msg_data);
1340:

Line 1337: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

1333: -- --------------------------------------------------------
1334: exception
1335: WHEN FND_API.G_EXC_ERROR THEN
1336: x_return_status := FND_API.G_RET_STS_ERROR;
1337: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1338: p_count => l_msg_count,
1339: p_data => l_msg_data);
1340:
1341: when others then

Line 1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1341: when others then
1342: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1343: fnd_message.set_token('ERROR',SQLERRM);
1344: fnd_msg_pub.add;
1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1346: raise;
1347: END MERGE_PV_GE_PTNR_RESPS;
1348:
1349: PROCEDURE MERGE_CONTRACT_BINDING_CONTACT (

Line 1380: x_return_status := FND_API.G_RET_STS_SUCCESS;

1376: BEGIN
1377: Debug(G_PKG_NAME || '.' || l_api_name || ' starts: ' ||
1378: TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
1379:
1380: x_return_status := FND_API.G_RET_STS_SUCCESS;
1381:
1382: select merge_reason_code
1383: into l_merge_reason_code
1384: from hz_merge_batch

Line 1445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1441: when others then
1442: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1443: fnd_message.set_token('ERROR',SQLERRM);
1444: fnd_msg_pub.add;
1445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1446: raise;
1447:
1448: END MERGE_CONTRACT_BINDING_CONTACT;
1449:

Line 1480: l_msg := FND_MSG_PUB.get(l_cnt, FND_API.g_false);

1476:
1477: l_count := FND_MSG_PUB.count_msg;
1478:
1479: FOR l_cnt IN 1 .. l_count LOOP
1480: l_msg := FND_MSG_PUB.get(l_cnt, FND_API.g_false);
1481: FND_FILE.PUT_LINE(FND_FILE.LOG, '(' || l_cnt || ') ' || l_msg);
1482: END LOOP;
1483: END Debug;
1484:

Line 1532: l_msg := FND_MSG_PUB.get(l_cnt, FND_API.g_false);

1528:
1529: l_count := FND_MSG_PUB.count_msg;
1530:
1531: FOR l_cnt IN 1 .. l_count LOOP
1532: l_msg := FND_MSG_PUB.get(l_cnt, FND_API.g_false);
1533: FND_FILE.PUT_LINE(FND_FILE.LOG, '(' || l_cnt || ') ' || l_msg);
1534: END LOOP;
1535: END Set_Message;
1536: -- ==============================End of Set_Message==============================