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_MERGE_DUP_PVT dependencies on FND_API

Line 56: -- be fnd_api.g_ret_sts_success (success),

52: -- p_batch_name Parameter for the Batch name
53: -- OUT:
54: -- x_merge_batch_id Phone country code.
55: -- x_return_status Return status after the call. The status can
56: -- be fnd_api.g_ret_sts_success (success),
57: -- fnd_api.g_ret_sts_error (error),
58: -- fnd_api.g_ret_sts_unexp_error
59: -- (unexpected error).
60: -- x_msg_count Number of messages in message stack.

Line 57: -- fnd_api.g_ret_sts_error (error),

53: -- OUT:
54: -- x_merge_batch_id Phone country code.
55: -- x_return_status Return status after the call. The status can
56: -- be fnd_api.g_ret_sts_success (success),
57: -- fnd_api.g_ret_sts_error (error),
58: -- fnd_api.g_ret_sts_unexp_error
59: -- (unexpected error).
60: -- x_msg_count Number of messages in message stack.
61: -- x_msg_data Message text if x_msg_count is 1.

Line 58: -- fnd_api.g_ret_sts_unexp_error

54: -- x_merge_batch_id Phone country code.
55: -- x_return_status Return status after the call. The status can
56: -- be fnd_api.g_ret_sts_success (success),
57: -- fnd_api.g_ret_sts_error (error),
58: -- fnd_api.g_ret_sts_unexp_error
59: -- (unexpected error).
60: -- x_msg_count Number of messages in message stack.
61: -- x_msg_data Message text if x_msg_count is 1.
62: --

Line 132: x_return_status := FND_API.G_RET_STS_SUCCESS;

128: l_created_by_module varchar2(30) := 'DL';
129:
130: BEGIN
131:
132: x_return_status := FND_API.G_RET_STS_SUCCESS;
133:
134: fnd_msg_pub.initialize;
135: l_batch_id := null;
136:

Line 146: RAISE FND_API.G_EXC_ERROR;

142: IF c_batch_name%NOTFOUND THEN
143: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
144: FND_MESSAGE.SET_TOKEN('PARAMETER','DUP_SET_ID' );
145: FND_MSG_PUB.ADD;
146: RAISE FND_API.G_EXC_ERROR;
147: END IF;
148: CLOSE c_batch_name;
149:
150: IF p_default_mapping = null THEN

Line 258: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

254: HZ_MERGE_ENTITY_ATTRI_PVT.create_merge_attributes(
255: l_batch_id, l_merge_to, l_party_type,
256: x_return_status, x_msg_count, x_msg_data);
257:
258: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
259: ROLLBACK to create_merge_batch;
260: RETURN;
261: END IF;
262: end if; -- if l_automerge_flag = 'N'

Line 290: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

286: -- call suggested default to populate suggested default mapping
287: -- to temp table HZ_MERGE_PARTIES_SUGG and HZ_MERGE_PARTYDTLS_SUGG
288: suggested_defaults(l_batch_id, x_return_status, x_msg_count, x_msg_data);
289:
290: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
291: ROLLBACK to create_merge_batch;
292: RETURN;
293: END IF;
294:

Line 314: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

310: or (l_automerge_flag = 'Y' and l_reln_match_rule <>0 and l_reln_match_rule is not null)) THEN
311: apply_suggested_default(l_batch_id, 'HZ_PARTY_RELATIONSHIPS', x_return_status, x_msg_count, x_msg_data);
312: END IF;
313:
314: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
315: ROLLBACK to create_merge_batch;
316: RETURN;
317: END IF;
318: end if; -- p_default_mapping = 'Y'

Line 350: RAISE FND_API.G_EXC_ERROR;

346: ELSE
347: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
348: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_dup_sets');
349: FND_MSG_PUB.ADD;
350: RAISE FND_API.G_EXC_ERROR;
351: END IF;
352:
353: ---Default mapping of the entities
354: IF p_default_mapping = 'Y' THEN

Line 363: p_encoded => FND_API.G_FALSE,

359: x_merge_batch_id := l_batch_id;
360:
361: -- standard call to get message count and if count is 1, get message info.
362: FND_MSG_PUB.Count_And_Get(
363: p_encoded => FND_API.G_FALSE,
364: p_count => x_msg_count,
365: p_data => x_msg_data);
366:
367: EXCEPTION

Line 368: WHEN FND_API.G_EXC_ERROR THEN

364: p_count => x_msg_count,
365: p_data => x_msg_data);
366:
367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN
369: ROLLBACK to create_merge_batch;
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: FND_MSG_PUB.Count_And_Get(
372: p_encoded => FND_API.G_FALSE,

Line 370: x_return_status := FND_API.G_RET_STS_ERROR;

366:
367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN
369: ROLLBACK to create_merge_batch;
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: FND_MSG_PUB.Count_And_Get(
372: p_encoded => FND_API.G_FALSE,
373: p_count => x_msg_count,
374: p_data => x_msg_data);

Line 372: p_encoded => FND_API.G_FALSE,

368: WHEN FND_API.G_EXC_ERROR THEN
369: ROLLBACK to create_merge_batch;
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: FND_MSG_PUB.Count_And_Get(
372: p_encoded => FND_API.G_FALSE,
373: p_count => x_msg_count,
374: p_data => x_msg_data);
375:
376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

372: p_encoded => FND_API.G_FALSE,
373: p_count => x_msg_count,
374: p_data => x_msg_data);
375:
376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
377: ROLLBACK to create_merge_batch;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: FND_MSG_PUB.Count_And_Get(
380: p_encoded => FND_API.G_FALSE,

Line 378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

374: p_data => x_msg_data);
375:
376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
377: ROLLBACK to create_merge_batch;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: FND_MSG_PUB.Count_And_Get(
380: p_encoded => FND_API.G_FALSE,
381: p_count => x_msg_count,
382: p_data => x_msg_data);

Line 380: p_encoded => FND_API.G_FALSE,

376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
377: ROLLBACK to create_merge_batch;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: FND_MSG_PUB.Count_And_Get(
380: p_encoded => FND_API.G_FALSE,
381: p_count => x_msg_count,
382: p_data => x_msg_data);
383:
384: WHEN OTHERS THEN

Line 386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

382: p_data => x_msg_data);
383:
384: WHEN OTHERS THEN
385: ROLLBACK to create_merge_batch;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387:
388: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
389: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
390: FND_MSG_PUB.ADD;

Line 393: p_encoded => FND_API.G_FALSE,

389: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
390: FND_MSG_PUB.ADD;
391:
392: FND_MSG_PUB.Count_And_Get(
393: p_encoded => FND_API.G_FALSE,
394: p_count => x_msg_count,
395: p_data => x_msg_data);
396:
397: END Create_Merge_Batch;

Line 461: -- be fnd_api.g_ret_sts_success (success),

457: -- p_to_entity_id ID of the to record
458:
459: -- OUT:
460: -- x_return_status Return status after the call. The status can
461: -- be fnd_api.g_ret_sts_success (success),
462: -- fnd_api.g_ret_sts_error (error),
463: -- fnd_api.g_ret_sts_unexp_error
464: -- (unexpected error).
465: -- x_msg_count Number of messages in message stack.

Line 462: -- fnd_api.g_ret_sts_error (error),

458:
459: -- OUT:
460: -- x_return_status Return status after the call. The status can
461: -- be fnd_api.g_ret_sts_success (success),
462: -- fnd_api.g_ret_sts_error (error),
463: -- fnd_api.g_ret_sts_unexp_error
464: -- (unexpected error).
465: -- x_msg_count Number of messages in message stack.
466: -- x_msg_data Message text if x_msg_count is 1.

Line 463: -- fnd_api.g_ret_sts_unexp_error

459: -- OUT:
460: -- x_return_status Return status after the call. The status can
461: -- be fnd_api.g_ret_sts_success (success),
462: -- fnd_api.g_ret_sts_error (error),
463: -- fnd_api.g_ret_sts_unexp_error
464: -- (unexpected error).
465: -- x_msg_count Number of messages in message stack.
466: -- x_msg_data Message text if x_msg_count is 1.
467: --

Line 559: x_return_status := FND_API.G_RET_STS_SUCCESS;

555:
556: BEGIN
557:
558: fnd_msg_pub.initialize;
559: x_return_status := FND_API.G_RET_STS_SUCCESS;
560:
561: SAVEPOINT map_detail_record;
562:
563: SELECT distinct(batch_id)

Line 573: RAISE FND_API.G_EXC_ERROR;

569: OR (p_entity is null) OR (p_from_entity_id IS NULL) THEN
570: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
571: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');
572: FND_MSG_PUB.ADD;
573: RAISE FND_API.G_EXC_ERROR;
574: END IF;
575:
576: BEGIN
577: SELECT mandatory_merge, merge_to_entity_id INTO l_mm, l_merge_to

Line 588: RAISE FND_API.G_EXC_ERROR;

584: FND_MESSAGE.set_name('AR','HZ_MAND_MERGE_ERROR');
585: FND_MESSAGE.set_token('ENTITY1',p_from_entity_id);
586: FND_MESSAGE.set_token('ENTITY2',p_to_entity_id);
587: FND_MSG_PUB.ADD;
588: RAISE FND_API.G_EXC_ERROR;
589: END IF;
590:
591: IF p_from_entity_id = l_merge_to THEN
592: /* Check if any entity is merged to p_from_entity_id */

Line 619: RAISE FND_API.G_EXC_ERROR;

615:
616: IF l_tmp>0 OR l_tmp2>0 THEN
617: FND_MESSAGE.set_name('AR','HZ_CANNOT_UNMAP_ERROR');
618: FND_MSG_PUB.ADD;
619: RAISE FND_API.G_EXC_ERROR;
620: END IF;
621: END IF;
622:
623: EXCEPTION

Line 628: RAISE FND_API.G_EXC_ERROR;

624: WHEN NO_DATA_FOUND THEN
625: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
626: FND_MESSAGE.SET_TOKEN('PARAMETER', 'MERGE_FROM_ENTITY_ID');
627: FND_MSG_PUB.ADD;
628: RAISE FND_API.G_EXC_ERROR;
629: END;
630:
631: ---Validation for locations/Party sites
632: IF p_entity = 'HZ_PARTY_SITES' THEN

Line 653: RAISE FND_API.G_EXC_ERROR;

649: if l_from_ps_status = 'A' and l_to_ps_status = 'I'
650: then
651: FND_MESSAGE.set_name('AR','HZ_DL_ADDR_MASTER_ERR');
652: FND_MSG_PUB.ADD;
653: RAISE FND_API.G_EXC_ERROR;
654: end if;
655: --bug 4569674
656: l_merge_yn := null;
657:

Line 660: FND_API.G_FALSE,

656: l_merge_yn := null;
657:
658: ZX_MERGE_LOC_CHECK_PKG.CHECK_GNR(l_from_location_id,
659: l_to_location_id,
660: FND_API.G_FALSE,
661: l_merge_yn,
662: x_return_status,
663: x_msg_count,
664: x_msg_data);

Line 668: RAISE FND_API.G_EXC_ERROR;

664: x_msg_data);
665: IF l_merge_yn = 'N' THEN
666: FND_MESSAGE.set_name('AR','HZ_PS_LOC_ASSIGN_ERROR');
667: FND_MSG_PUB.ADD;
668: RAISE FND_API.G_EXC_ERROR;
669: END IF;
670:
671: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
672: RAISE FND_API.G_EXC_ERROR;

Line 671: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

667: FND_MSG_PUB.ADD;
668: RAISE FND_API.G_EXC_ERROR;
669: END IF;
670:
671: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;

Line 672: RAISE FND_API.G_EXC_ERROR;

668: RAISE FND_API.G_EXC_ERROR;
669: END IF;
670:
671: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676: --bug 4569674

Line 673: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

669: END IF;
670:
671: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676: --bug 4569674
677: END IF;

Line 674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

670:
671: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676: --bug 4569674
677: END IF;
678: END IF;

Line 723: RAISE FND_API.G_EXC_ERROR;

719:
720: IF(NOT isContactGroupRelType(p_from_entity_id,p_to_entity_id)) THEN
721: FND_MESSAGE.set_name('AR','HZ_REL_NOT_SIMILAR');
722: FND_MSG_PUB.ADD;
723: RAISE FND_API.G_EXC_ERROR;
724: END IF;
725:
726: END IF;
727:

Line 835: RAISE FND_API.G_EXC_ERROR;

831: ELSE
832: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
833: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_merge_party_details');
834: FND_MSG_PUB.ADD;
835: RAISE FND_API.G_EXC_ERROR;
836: END IF;
837:
838:
839: -- standard call to get message count and if count is 1, get message info.

Line 841: p_encoded => FND_API.G_FALSE,

837:
838:
839: -- standard call to get message count and if count is 1, get message info.
840: FND_MSG_PUB.Count_And_Get(
841: p_encoded => FND_API.G_FALSE,
842: p_count => x_msg_count,
843: p_data => x_msg_data);
844:
845: EXCEPTION

Line 846: WHEN FND_API.G_EXC_ERROR THEN

842: p_count => x_msg_count,
843: p_data => x_msg_data);
844:
845: EXCEPTION
846: WHEN FND_API.G_EXC_ERROR THEN
847: ROLLBACK to map_detail_record ;
848: x_return_status := FND_API.G_RET_STS_ERROR;
849: FND_MSG_PUB.Count_And_Get(
850: p_encoded => FND_API.G_FALSE,

Line 848: x_return_status := FND_API.G_RET_STS_ERROR;

844:
845: EXCEPTION
846: WHEN FND_API.G_EXC_ERROR THEN
847: ROLLBACK to map_detail_record ;
848: x_return_status := FND_API.G_RET_STS_ERROR;
849: FND_MSG_PUB.Count_And_Get(
850: p_encoded => FND_API.G_FALSE,
851: p_count => x_msg_count,
852: p_data => x_msg_data);

Line 850: p_encoded => FND_API.G_FALSE,

846: WHEN FND_API.G_EXC_ERROR THEN
847: ROLLBACK to map_detail_record ;
848: x_return_status := FND_API.G_RET_STS_ERROR;
849: FND_MSG_PUB.Count_And_Get(
850: p_encoded => FND_API.G_FALSE,
851: p_count => x_msg_count,
852: p_data => x_msg_data);
853:
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

850: p_encoded => FND_API.G_FALSE,
851: p_count => x_msg_count,
852: p_data => x_msg_data);
853:
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855: ROLLBACK to map_detail_record ;
856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
857: FND_MSG_PUB.Count_And_Get(
858: p_encoded => FND_API.G_FALSE,

Line 856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

852: p_data => x_msg_data);
853:
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855: ROLLBACK to map_detail_record ;
856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
857: FND_MSG_PUB.Count_And_Get(
858: p_encoded => FND_API.G_FALSE,
859: p_count => x_msg_count,
860: p_data => x_msg_data);

Line 858: p_encoded => FND_API.G_FALSE,

854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855: ROLLBACK to map_detail_record ;
856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
857: FND_MSG_PUB.Count_And_Get(
858: p_encoded => FND_API.G_FALSE,
859: p_count => x_msg_count,
860: p_data => x_msg_data);
861:
862: WHEN OTHERS THEN

Line 864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

860: p_data => x_msg_data);
861:
862: WHEN OTHERS THEN
863: ROLLBACK to map_detail_record;
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
865:
866: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
867: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
868: FND_MSG_PUB.ADD;

Line 872: p_encoded => FND_API.G_FALSE,

868: FND_MSG_PUB.ADD;
869:
870:
871: FND_MSG_PUB.Count_And_Get(
872: p_encoded => FND_API.G_FALSE,
873: p_count => x_msg_count,
874: p_data => x_msg_data);
875:
876: END map_detail_record;

Line 897: -- be fnd_api.g_ret_sts_success (success),

893: -- p_to_entity_id ID of the to record
894:
895: -- OUT:
896: -- x_return_status Return status after the call. The status can
897: -- be fnd_api.g_ret_sts_success (success),
898: -- fnd_api.g_ret_sts_error (error),
899: -- fnd_api.g_ret_sts_unexp_error
900: -- (unexpected error).
901: -- x_msg_count Number of messages in message stack.

Line 898: -- fnd_api.g_ret_sts_error (error),

894:
895: -- OUT:
896: -- x_return_status Return status after the call. The status can
897: -- be fnd_api.g_ret_sts_success (success),
898: -- fnd_api.g_ret_sts_error (error),
899: -- fnd_api.g_ret_sts_unexp_error
900: -- (unexpected error).
901: -- x_msg_count Number of messages in message stack.
902: -- x_msg_data Message text if x_msg_count is 1.

Line 899: -- fnd_api.g_ret_sts_unexp_error

895: -- OUT:
896: -- x_return_status Return status after the call. The status can
897: -- be fnd_api.g_ret_sts_success (success),
898: -- fnd_api.g_ret_sts_error (error),
899: -- fnd_api.g_ret_sts_unexp_error
900: -- (unexpected error).
901: -- x_msg_count Number of messages in message stack.
902: -- x_msg_data Message text if x_msg_count is 1.
903: --

Line 1010: x_return_status := FND_API.G_RET_STS_SUCCESS;

1006:
1007:
1008: BEGIN
1009:
1010: x_return_status := FND_API.G_RET_STS_SUCCESS;
1011: fnd_msg_pub.initialize;
1012: SAVEPOINT map_within_party;
1013:
1014: --Get the batch_id and party_id for the same party merge

Line 1026: RAISE FND_API.G_EXC_ERROR;

1022: OR (p_entity is null) or (p_from_entity_id is null) THEN
1023: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
1024: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');
1025: FND_MSG_PUB.ADD;
1026: RAISE FND_API.G_EXC_ERROR;
1027: end if;
1028:
1029: --check if the from and to_party are the same
1030: IF l_from_party_id <> l_to_party_id then

Line 1034: RAISE FND_API.G_EXC_ERROR;

1030: IF l_from_party_id <> l_to_party_id then
1031: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
1032: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');
1033: FND_MSG_PUB.ADD;
1034: RAISE FND_API.G_EXC_ERROR;
1035: END IF;
1036:
1037:
1038: IF l_merge_type <> 'SAME_PARTY_MERGE' THEN

Line 1042: RAISE FND_API.G_EXC_ERROR;

1038: IF l_merge_type <> 'SAME_PARTY_MERGE' THEN
1039: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
1040: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');
1041: FND_MSG_PUB.ADD;
1042: RAISE FND_API.G_EXC_ERROR;
1043: END IF;
1044:
1045: --check if the record already exists
1046: OPEN c_map_detail_record_exist(p_batch_party_id,p_entity,p_from_entity_id);

Line 1054: RAISE FND_API.G_EXC_ERROR;

1050: IF l_map_dtl_count > 0 AND p_to_entity_id IS NOT NULL THEN
1051: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_REC_PRESENT');
1052: FND_MESSAGE.SET_TOKEN('ID', p_from_entity_id);
1053: FND_MSG_PUB.ADD;
1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;
1056:
1057:
1058:

Line 1070: RAISE FND_API.G_EXC_ERROR;

1066: IF c_loc_assignments%FOUND THEN
1067: CLOSE c_loc_assignments;
1068: FND_MESSAGE.set_name('AR','HZ_PS_LOC_ASSIGN_ERROR');
1069: FND_MSG_PUB.ADD;
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;
1072: */
1073: OPEN c_cust_site_check;
1074: Fetch c_cust_site_check into l_cust_sites;

Line 1092: RAISE FND_API.G_EXC_ERROR;

1088: if l_from_ps_status = 'A' and l_to_ps_status = 'I'
1089: then
1090: FND_MESSAGE.set_name('AR','HZ_DL_ADDR_MASTER_ERR');
1091: FND_MSG_PUB.ADD;
1092: RAISE FND_API.G_EXC_ERROR;
1093: end if;
1094:
1095: --bug 4569674
1096: l_merge_yn := null;

Line 1100: FND_API.G_FALSE,

1096: l_merge_yn := null;
1097:
1098: ZX_MERGE_LOC_CHECK_PKG.CHECK_GNR(l_from_location_id,
1099: l_to_location_id,
1100: FND_API.G_FALSE,
1101: l_merge_yn,
1102: x_return_status,
1103: x_msg_count,
1104: x_msg_data);

Line 1108: RAISE FND_API.G_EXC_ERROR;

1104: x_msg_data);
1105: IF l_merge_yn = 'N' THEN
1106: FND_MESSAGE.set_name('AR','HZ_PS_LOC_ASSIGN_ERROR');
1107: FND_MSG_PUB.ADD;
1108: RAISE FND_API.G_EXC_ERROR;
1109: END IF;
1110:
1111:
1112: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1112: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1108: RAISE FND_API.G_EXC_ERROR;
1109: END IF;
1110:
1111:
1112: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1113: RAISE FND_API.G_EXC_ERROR;
1114: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: END IF;

Line 1113: RAISE FND_API.G_EXC_ERROR;

1109: END IF;
1110:
1111:
1112: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1113: RAISE FND_API.G_EXC_ERROR;
1114: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: END IF;
1117: --4569674

Line 1114: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1110:
1111:
1112: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1113: RAISE FND_API.G_EXC_ERROR;
1114: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: END IF;
1117: --4569674
1118: -----------Bug No: 3738622---------------------------------

Line 1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1111:
1112: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1113: RAISE FND_API.G_EXC_ERROR;
1114: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: END IF;
1117: --4569674
1118: -----------Bug No: 3738622---------------------------------
1119:

Line 1135: RAISE FND_API.G_EXC_ERROR;

1131: (l_from_site_party_id <> l_from_party_id) ) THEN
1132: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
1133: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');
1134: FND_MSG_PUB.ADD;
1135: RAISE FND_API.G_EXC_ERROR;
1136: END IF;
1137: END IF;
1138: CLOSE c_cust_site_check;
1139: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

Line 1178: RAISE FND_API.G_EXC_ERROR;

1174: IF l_from_rel_type <> l_to_rel_type OR l_from_dflag <> l_to_dflag THEN
1175: IF(NOT isContactGroupRelType(p_from_entity_id,p_to_entity_id)) THEN
1176: FND_MESSAGE.set_name('AR','HZ_REL_NOT_SIMILAR');
1177: FND_MSG_PUB.ADD;
1178: RAISE FND_API.G_EXC_ERROR;
1179: END IF;
1180: END IF;
1181:
1182: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

Line 1293: p_encoded => FND_API.G_FALSE,

1289: AND ROWNUM = 1);
1290:
1291: -- standard call to get message count and if count is 1, get message info.
1292: FND_MSG_PUB.Count_And_Get(
1293: p_encoded => FND_API.G_FALSE,
1294: p_count => x_msg_count,
1295: p_data => x_msg_data);
1296:
1297: EXCEPTION

Line 1298: WHEN FND_API.G_EXC_ERROR THEN

1294: p_count => x_msg_count,
1295: p_data => x_msg_data);
1296:
1297: EXCEPTION
1298: WHEN FND_API.G_EXC_ERROR THEN
1299: ROLLBACK to map_within_party;
1300: x_return_status := FND_API.G_RET_STS_ERROR;
1301: FND_MSG_PUB.Count_And_Get(
1302: p_encoded => FND_API.G_FALSE,

Line 1300: x_return_status := FND_API.G_RET_STS_ERROR;

1296:
1297: EXCEPTION
1298: WHEN FND_API.G_EXC_ERROR THEN
1299: ROLLBACK to map_within_party;
1300: x_return_status := FND_API.G_RET_STS_ERROR;
1301: FND_MSG_PUB.Count_And_Get(
1302: p_encoded => FND_API.G_FALSE,
1303: p_count => x_msg_count,
1304: p_data => x_msg_data);

Line 1302: p_encoded => FND_API.G_FALSE,

1298: WHEN FND_API.G_EXC_ERROR THEN
1299: ROLLBACK to map_within_party;
1300: x_return_status := FND_API.G_RET_STS_ERROR;
1301: FND_MSG_PUB.Count_And_Get(
1302: p_encoded => FND_API.G_FALSE,
1303: p_count => x_msg_count,
1304: p_data => x_msg_data);
1305:
1306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1302: p_encoded => FND_API.G_FALSE,
1303: p_count => x_msg_count,
1304: p_data => x_msg_data);
1305:
1306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1307: ROLLBACK to map_within_party;
1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1309: FND_MSG_PUB.Count_And_Get(
1310: p_encoded => FND_API.G_FALSE,

Line 1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1304: p_data => x_msg_data);
1305:
1306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1307: ROLLBACK to map_within_party;
1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1309: FND_MSG_PUB.Count_And_Get(
1310: p_encoded => FND_API.G_FALSE,
1311: p_count => x_msg_count,
1312: p_data => x_msg_data);

Line 1310: p_encoded => FND_API.G_FALSE,

1306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1307: ROLLBACK to map_within_party;
1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1309: FND_MSG_PUB.Count_And_Get(
1310: p_encoded => FND_API.G_FALSE,
1311: p_count => x_msg_count,
1312: p_data => x_msg_data);
1313:
1314: WHEN OTHERS THEN

Line 1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1312: p_data => x_msg_data);
1313:
1314: WHEN OTHERS THEN
1315: ROLLBACK to map_within_party;
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1317:
1318: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1319: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1320: FND_MSG_PUB.ADD;

Line 1324: p_encoded => FND_API.G_FALSE,

1320: FND_MSG_PUB.ADD;
1321:
1322:
1323: FND_MSG_PUB.Count_And_Get(
1324: p_encoded => FND_API.G_FALSE,
1325: p_count => x_msg_count,
1326: p_data => x_msg_data);
1327:
1328: END map_within_party;

Line 1346: -- be fnd_api.g_ret_sts_success (success),

1342:
1343: -- OUT:
1344: -- x_request_id Request ID of the concurrent program
1345: -- x_return_status Return status after the call. The status can
1346: -- be fnd_api.g_ret_sts_success (success),
1347: -- fnd_api.g_ret_sts_error (error),
1348: -- fnd_api.g_ret_sts_unexp_error
1349: -- (unexpected error).
1350: -- x_msg_count Number of messages in message stack.

Line 1347: -- fnd_api.g_ret_sts_error (error),

1343: -- OUT:
1344: -- x_request_id Request ID of the concurrent program
1345: -- x_return_status Return status after the call. The status can
1346: -- be fnd_api.g_ret_sts_success (success),
1347: -- fnd_api.g_ret_sts_error (error),
1348: -- fnd_api.g_ret_sts_unexp_error
1349: -- (unexpected error).
1350: -- x_msg_count Number of messages in message stack.
1351: -- x_msg_data Message text if x_msg_count is 1.

Line 1348: -- fnd_api.g_ret_sts_unexp_error

1344: -- x_request_id Request ID of the concurrent program
1345: -- x_return_status Return status after the call. The status can
1346: -- be fnd_api.g_ret_sts_success (success),
1347: -- fnd_api.g_ret_sts_error (error),
1348: -- fnd_api.g_ret_sts_unexp_error
1349: -- (unexpected error).
1350: -- x_msg_count Number of messages in message stack.
1351: -- x_msg_data Message text if x_msg_count is 1.
1352: --

Line 1385: x_return_status := FND_API.G_RET_STS_SUCCESS;

1381: retcode number;
1382:
1383: BEGIN
1384:
1385: x_return_status := FND_API.G_RET_STS_SUCCESS;
1386: fnd_msg_pub.initialize;
1387:
1388: SAVEPOINT submit_batch;
1389:

Line 1420: RAISE FND_API.G_EXC_ERROR;

1416:
1417: IF l_conc_dev_phase <> 'COMPLETE' THEN
1418: FND_MESSAGE.set_name('AR', 'HZ_CANNOT_SUBMIT_PROCESSING');
1419: FND_MSG_PUB.ADD;
1420: RAISE FND_API.G_EXC_ERROR;
1421: ELSE
1422: IF l_conc_dev_status <>'NORMAL' THEN
1423: l_request_id := fnd_request.submit_request('AR',
1424: 'ARHPMERGE',

Line 1434: RAISE FND_API.G_EXC_ERROR;

1430: IF l_request_id = 0 THEN
1431: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1432: -- FND_MESSAGE.RETRIEVE(l_message);
1433: FND_MSG_PUB.ADD;
1434: RAISE FND_API.G_EXC_ERROR;
1435: retcode := 2;
1436: RETURN;
1437: END IF;
1438:

Line 1451: RAISE FND_API.G_EXC_ERROR;

1447: p_batch_id, l_preview );
1448: IF l_request_id = 0 THEN
1449: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1450: FND_MSG_PUB.ADD;
1451: RAISE FND_API.G_EXC_ERROR;
1452: retcode := 2;
1453: RETURN;
1454: END IF;
1455: ELSE

Line 1458: RAISE FND_API.G_EXC_ERROR;

1454: END IF;
1455: ELSE
1456: FND_MESSAGE.set_name('AR', 'HZ_CANNOT_SUBMIT_REQUEST');
1457: FND_MSG_PUB.ADD;
1458: RAISE FND_API.G_EXC_ERROR;
1459: END IF;
1460: END IF; --l_conc_status
1461: END IF; --l_conc_dev_phase
1462:

Line 1475: RAISE FND_API.G_EXC_ERROR;

1471: IF l_request_id = 0 THEN
1472: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1473: -- FND_MESSAGE.RETRIEVE(l_message);
1474: FND_MSG_PUB.ADD;
1475: RAISE FND_API.G_EXC_ERROR;
1476: -- retcode := 2;
1477: -- RETURN;
1478: END IF;
1479:

Line 1505: p_encoded => FND_API.G_FALSE,

1501: x_request_id := l_request_id;
1502:
1503: -- standard call to get message count and if count is 1, get message info.
1504: FND_MSG_PUB.Count_And_Get(
1505: p_encoded => FND_API.G_FALSE,
1506: p_count => x_msg_count,
1507: p_data => x_msg_data);
1508:
1509: EXCEPTION

Line 1510: WHEN FND_API.G_EXC_ERROR THEN

1506: p_count => x_msg_count,
1507: p_data => x_msg_data);
1508:
1509: EXCEPTION
1510: WHEN FND_API.G_EXC_ERROR THEN
1511: ROLLBACK to submit_batch;
1512: x_return_status := FND_API.G_RET_STS_ERROR;
1513: FND_MSG_PUB.Count_And_Get(
1514: p_encoded => FND_API.G_FALSE,

Line 1512: x_return_status := FND_API.G_RET_STS_ERROR;

1508:
1509: EXCEPTION
1510: WHEN FND_API.G_EXC_ERROR THEN
1511: ROLLBACK to submit_batch;
1512: x_return_status := FND_API.G_RET_STS_ERROR;
1513: FND_MSG_PUB.Count_And_Get(
1514: p_encoded => FND_API.G_FALSE,
1515: p_count => x_msg_count,
1516: p_data => x_msg_data);

Line 1514: p_encoded => FND_API.G_FALSE,

1510: WHEN FND_API.G_EXC_ERROR THEN
1511: ROLLBACK to submit_batch;
1512: x_return_status := FND_API.G_RET_STS_ERROR;
1513: FND_MSG_PUB.Count_And_Get(
1514: p_encoded => FND_API.G_FALSE,
1515: p_count => x_msg_count,
1516: p_data => x_msg_data);
1517:
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1514: p_encoded => FND_API.G_FALSE,
1515: p_count => x_msg_count,
1516: p_data => x_msg_data);
1517:
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: ROLLBACK to submit_batch;
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: FND_MSG_PUB.Count_And_Get(
1522: p_encoded => FND_API.G_FALSE,

Line 1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1516: p_data => x_msg_data);
1517:
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: ROLLBACK to submit_batch;
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: FND_MSG_PUB.Count_And_Get(
1522: p_encoded => FND_API.G_FALSE,
1523: p_count => x_msg_count,
1524: p_data => x_msg_data);

Line 1522: p_encoded => FND_API.G_FALSE,

1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: ROLLBACK to submit_batch;
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: FND_MSG_PUB.Count_And_Get(
1522: p_encoded => FND_API.G_FALSE,
1523: p_count => x_msg_count,
1524: p_data => x_msg_data);
1525:
1526: WHEN OTHERS THEN

Line 1528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1524: p_data => x_msg_data);
1525:
1526: WHEN OTHERS THEN
1527: ROLLBACK to submit_batch;
1528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1529:
1530: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1532: FND_MSG_PUB.ADD;

Line 1535: p_encoded => FND_API.G_FALSE,

1531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1532: FND_MSG_PUB.ADD;
1533:
1534: FND_MSG_PUB.Count_And_Get(
1535: p_encoded => FND_API.G_FALSE,
1536: p_count => x_msg_count,
1537: p_data => x_msg_data);
1538: END submit_batch;
1539:

Line 2165: x_return_status := FND_API.G_RET_STS_SUCCESS;

2161: savepoint suggested_defaults;
2162:
2163: fnd_msg_pub.initialize;
2164: --Initialize API return status to success.
2165: x_return_status := FND_API.G_RET_STS_SUCCESS;
2166:
2167: IF(p_batch_id IS NULL OR
2168: p_batch_id = FND_API.G_MISS_NUM) THEN
2169: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

Line 2168: p_batch_id = FND_API.G_MISS_NUM) THEN

2164: --Initialize API return status to success.
2165: x_return_status := FND_API.G_RET_STS_SUCCESS;
2166:
2167: IF(p_batch_id IS NULL OR
2168: p_batch_id = FND_API.G_MISS_NUM) THEN
2169: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2170: FND_MESSAGE.SET_TOKEN('COLUMN' ,'DUP_SET_ID');
2171: FND_MSG_PUB.ADD;
2172: RAISE FND_API.G_EXC_ERROR;

Line 2172: RAISE FND_API.G_EXC_ERROR;

2168: p_batch_id = FND_API.G_MISS_NUM) THEN
2169: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2170: FND_MESSAGE.SET_TOKEN('COLUMN' ,'DUP_SET_ID');
2171: FND_MSG_PUB.ADD;
2172: RAISE FND_API.G_EXC_ERROR;
2173: END IF;
2174:
2175: open get_dup_sets_info(p_batch_id);
2176: fetch get_dup_sets_info into l_merge_type;

Line 2268: RAISE FND_API.G_EXC_ERROR;

2264:
2265: if((l_addr_match_rule = 0) OR (l_reln_match_rule = 0)) then
2266: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MATCH_RULE');
2267: FND_MSG_PUB.ADD;
2268: RAISE FND_API.G_EXC_ERROR;
2269: end if;
2270:
2271: -- call suggested defaults for address and relationship
2272: suggested_party_sites(p_batch_id, l_merge_type, l_addr_match_rule);

Line 2277: WHEN FND_API.G_EXC_ERROR THEN

2273: suggested_party_reln(p_batch_id, l_merge_type, l_reln_match_rule);
2274:
2275: EXCEPTION
2276:
2277: WHEN FND_API.G_EXC_ERROR THEN
2278: ROLLBACK TO suggested_defaults;
2279: x_return_status := FND_API.G_RET_STS_ERROR;
2280: FND_MSG_PUB.Count_And_Get(
2281: p_encoded => FND_API.G_FALSE,

Line 2279: x_return_status := FND_API.G_RET_STS_ERROR;

2275: EXCEPTION
2276:
2277: WHEN FND_API.G_EXC_ERROR THEN
2278: ROLLBACK TO suggested_defaults;
2279: x_return_status := FND_API.G_RET_STS_ERROR;
2280: FND_MSG_PUB.Count_And_Get(
2281: p_encoded => FND_API.G_FALSE,
2282: p_count => x_msg_count,
2283: p_data => x_msg_data);

Line 2281: p_encoded => FND_API.G_FALSE,

2277: WHEN FND_API.G_EXC_ERROR THEN
2278: ROLLBACK TO suggested_defaults;
2279: x_return_status := FND_API.G_RET_STS_ERROR;
2280: FND_MSG_PUB.Count_And_Get(
2281: p_encoded => FND_API.G_FALSE,
2282: p_count => x_msg_count,
2283: p_data => x_msg_data);
2284:
2285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2281: p_encoded => FND_API.G_FALSE,
2282: p_count => x_msg_count,
2283: p_data => x_msg_data);
2284:
2285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2286: ROLLBACK TO suggested_defaults;
2287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2288: FND_MSG_PUB.Count_And_Get(
2289: p_encoded => FND_API.G_FALSE,

Line 2287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2283: p_data => x_msg_data);
2284:
2285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2286: ROLLBACK TO suggested_defaults;
2287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2288: FND_MSG_PUB.Count_And_Get(
2289: p_encoded => FND_API.G_FALSE,
2290: p_count => x_msg_count,
2291: p_data => x_msg_data);

Line 2289: p_encoded => FND_API.G_FALSE,

2285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2286: ROLLBACK TO suggested_defaults;
2287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2288: FND_MSG_PUB.Count_And_Get(
2289: p_encoded => FND_API.G_FALSE,
2290: p_count => x_msg_count,
2291: p_data => x_msg_data);
2292:
2293: WHEN OTHERS THEN

Line 2295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2291: p_data => x_msg_data);
2292:
2293: WHEN OTHERS THEN
2294: ROLLBACK TO suggested_defaults;
2295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2296: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2297: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2298: FND_MSG_PUB.ADD;
2299: FND_MSG_PUB.Count_And_Get(

Line 2300: p_encoded => FND_API.G_FALSE,

2296: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2297: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2298: FND_MSG_PUB.ADD;
2299: FND_MSG_PUB.Count_And_Get(
2300: p_encoded => FND_API.G_FALSE,
2301: p_count => x_msg_count,
2302: p_data => x_msg_data);
2303:
2304: END suggested_defaults;

Line 2474: p_init_msg_list => FND_API.G_TRUE

2470: IF (check_mapped_sites_mp%NOTFOUND) THEN
2471:
2472: HZ_PARTY_SEARCH.find_duplicate_party_sites
2473: (
2474: p_init_msg_list => FND_API.G_TRUE
2475: ,p_rule_id => p_rule_id
2476: ,p_party_site_id => l_master_site
2477: ,p_party_id => NULL
2478: ,p_restrict_sql => ' PARTY_SITE_ID IN (SELECT /*+ SELECTIVE_PS */ MERGE_FROM_ENTITY_ID' ||

Line 2518: FND_API.G_FALSE,

2514:
2515:
2516: ZX_MERGE_LOC_CHECK_PKG.CHECK_GNR(l_from_location_id,
2517: l_to_location_id,
2518: FND_API.G_FALSE,
2519: l_merge_yn,
2520: l_return_status,
2521: l_msg_count,
2522: l_msg_data);

Line 2531: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2527: l_num_matches := l_num_matches - 1;
2528: END IF;
2529:
2530:
2531: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2532: RAISE FND_API.G_EXC_ERROR;
2533: END IF;
2534:
2535: --4569674

Line 2532: RAISE FND_API.G_EXC_ERROR;

2528: END IF;
2529:
2530:
2531: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2532: RAISE FND_API.G_EXC_ERROR;
2533: END IF;
2534:
2535: --4569674
2536: END IF;

Line 2619: p_init_msg_list => FND_API.G_TRUE

2615: EXIT WHEN not_mandatory_sites_sp%NOTFOUND;
2616:
2617: HZ_PARTY_SEARCH.find_duplicate_party_sites
2618: (
2619: p_init_msg_list => FND_API.G_TRUE
2620: ,p_rule_id => p_rule_id
2621: ,p_party_site_id => l_master_site
2622: ,p_party_id => l_master_party
2623: ,p_restrict_sql => NULL

Line 2657: FND_API.G_FALSE,

2653: WHERE party_site_id = l_master_site;
2654:
2655: ZX_MERGE_LOC_CHECK_PKG.CHECK_GNR(l_from_location_id,
2656: l_to_location_id,
2657: FND_API.G_FALSE,
2658: l_merge_yn,
2659: l_return_status,
2660: l_msg_count,
2661: l_msg_data);

Line 2664: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2660: l_msg_count,
2661: l_msg_data);
2662:
2663:
2664: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2665: RAISE FND_API.G_EXC_ERROR;
2666: END IF;
2667:
2668: IF NVL(l_merge_yn,'Y') = 'Y' THEN

Line 2665: RAISE FND_API.G_EXC_ERROR;

2661: l_msg_data);
2662:
2663:
2664: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2665: RAISE FND_API.G_EXC_ERROR;
2666: END IF;
2667:
2668: IF NVL(l_merge_yn,'Y') = 'Y' THEN
2669:

Line 2898: p_init_msg_list => FND_API.G_TRUE

2894:
2895: -- call DQM search to find out matched parties
2896: HZ_PARTY_SEARCH.find_duplicate_parties
2897: (
2898: p_init_msg_list => FND_API.G_TRUE
2899: ,p_rule_id => p_rule_id
2900: ,p_party_id => l_reln_obj_id
2901: ,p_restrict_sql => 'stage.PARTY_ID IN (SELECT /*+ SELECTIVE */ OBJECT_ID' ||
2902: ' FROM HZ_RELATIONSHIPS rel' ||

Line 3037: p_init_msg_list => FND_API.G_TRUE

3033: EXIT WHEN not_mandatory_reln_sp%NOTFOUND;
3034:
3035: HZ_PARTY_SEARCH.find_duplicate_parties
3036: (
3037: p_init_msg_list => FND_API.G_TRUE
3038: ,p_rule_id => p_rule_id
3039: ,p_party_id => l_reln_obj_id
3040: ,p_restrict_sql => 'stage.PARTY_ID IN (SELECT /*+ SELECTIVE */ OBJECT_ID' ||
3041: ' FROM HZ_RELATIONSHIPS rel' ||

Line 3377: -- be fnd_api.g_ret_sts_success (success),

3373: -- p_merge_type Merge type of the dup set
3374: --
3375: -- OUT:
3376: -- x_return_status Return status after the call. The status can
3377: -- be fnd_api.g_ret_sts_success (success),
3378: -- fnd_api.g_ret_sts_error (error),
3379: -- fnd_api.g_ret_sts_unexp_error
3380: -- (unexpected error).
3381: -- x_msg_count Number of messages in message stack.

Line 3378: -- fnd_api.g_ret_sts_error (error),

3374: --
3375: -- OUT:
3376: -- x_return_status Return status after the call. The status can
3377: -- be fnd_api.g_ret_sts_success (success),
3378: -- fnd_api.g_ret_sts_error (error),
3379: -- fnd_api.g_ret_sts_unexp_error
3380: -- (unexpected error).
3381: -- x_msg_count Number of messages in message stack.
3382: -- x_msg_data Message text if x_msg_count is 1.

Line 3379: -- fnd_api.g_ret_sts_unexp_error

3375: -- OUT:
3376: -- x_return_status Return status after the call. The status can
3377: -- be fnd_api.g_ret_sts_success (success),
3378: -- fnd_api.g_ret_sts_error (error),
3379: -- fnd_api.g_ret_sts_unexp_error
3380: -- (unexpected error).
3381: -- x_msg_count Number of messages in message stack.
3382: -- x_msg_data Message text if x_msg_count is 1.
3383: --

Line 3402: x_return_status := FND_API.G_RET_STS_SUCCESS;

3398: BEGIN
3399:
3400: savepoint apply_suggested_default;
3401:
3402: x_return_status := FND_API.G_RET_STS_SUCCESS;
3403:
3404: DELETE FROM HZ_MERGE_PARTY_DETAILS
3405: WHERE BATCH_PARTY_ID IN
3406: ( SELECT BATCH_PARTY_ID

Line 3489: WHEN FND_API.G_EXC_ERROR THEN

3485: END IF;
3486:
3487: EXCEPTION
3488:
3489: WHEN FND_API.G_EXC_ERROR THEN
3490: ROLLBACK TO apply_suggested_default;
3491: x_return_status := FND_API.G_RET_STS_ERROR;
3492: FND_MSG_PUB.Count_And_Get(
3493: p_encoded => FND_API.G_FALSE,

Line 3491: x_return_status := FND_API.G_RET_STS_ERROR;

3487: EXCEPTION
3488:
3489: WHEN FND_API.G_EXC_ERROR THEN
3490: ROLLBACK TO apply_suggested_default;
3491: x_return_status := FND_API.G_RET_STS_ERROR;
3492: FND_MSG_PUB.Count_And_Get(
3493: p_encoded => FND_API.G_FALSE,
3494: p_count => x_msg_count,
3495: p_data => x_msg_data);

Line 3493: p_encoded => FND_API.G_FALSE,

3489: WHEN FND_API.G_EXC_ERROR THEN
3490: ROLLBACK TO apply_suggested_default;
3491: x_return_status := FND_API.G_RET_STS_ERROR;
3492: FND_MSG_PUB.Count_And_Get(
3493: p_encoded => FND_API.G_FALSE,
3494: p_count => x_msg_count,
3495: p_data => x_msg_data);
3496:
3497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3493: p_encoded => FND_API.G_FALSE,
3494: p_count => x_msg_count,
3495: p_data => x_msg_data);
3496:
3497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3498: ROLLBACK TO apply_suggested_default;
3499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3500: FND_MSG_PUB.Count_And_Get(
3501: p_encoded => FND_API.G_FALSE,

Line 3499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3495: p_data => x_msg_data);
3496:
3497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3498: ROLLBACK TO apply_suggested_default;
3499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3500: FND_MSG_PUB.Count_And_Get(
3501: p_encoded => FND_API.G_FALSE,
3502: p_count => x_msg_count,
3503: p_data => x_msg_data);

Line 3501: p_encoded => FND_API.G_FALSE,

3497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3498: ROLLBACK TO apply_suggested_default;
3499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3500: FND_MSG_PUB.Count_And_Get(
3501: p_encoded => FND_API.G_FALSE,
3502: p_count => x_msg_count,
3503: p_data => x_msg_data);
3504:
3505: WHEN OTHERS THEN

Line 3507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3503: p_data => x_msg_data);
3504:
3505: WHEN OTHERS THEN
3506: ROLLBACK TO apply_suggested_default;
3507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3508: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3509: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3510: FND_MSG_PUB.ADD;
3511: FND_MSG_PUB.Count_And_Get(

Line 3512: p_encoded => FND_API.G_FALSE,

3508: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3509: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3510: FND_MSG_PUB.ADD;
3511: FND_MSG_PUB.Count_And_Get(
3512: p_encoded => FND_API.G_FALSE,
3513: p_count => x_msg_count,
3514: p_data => x_msg_data);
3515:
3516: END apply_suggested_default;

Line 3534: -- be fnd_api.g_ret_sts_success (success),

3530: -- p_merge_type Merge type of the dup set
3531: --
3532: -- OUT:
3533: -- x_return_status Return status after the call. The status can
3534: -- be fnd_api.g_ret_sts_success (success),
3535: -- fnd_api.g_ret_sts_error (error),
3536: -- fnd_api.g_ret_sts_unexp_error
3537: -- (unexpected error).
3538: -- x_msg_count Number of messages in message stack.

Line 3535: -- fnd_api.g_ret_sts_error (error),

3531: --
3532: -- OUT:
3533: -- x_return_status Return status after the call. The status can
3534: -- be fnd_api.g_ret_sts_success (success),
3535: -- fnd_api.g_ret_sts_error (error),
3536: -- fnd_api.g_ret_sts_unexp_error
3537: -- (unexpected error).
3538: -- x_msg_count Number of messages in message stack.
3539: -- x_msg_data Message text if x_msg_count is 1.

Line 3536: -- fnd_api.g_ret_sts_unexp_error

3532: -- OUT:
3533: -- x_return_status Return status after the call. The status can
3534: -- be fnd_api.g_ret_sts_success (success),
3535: -- fnd_api.g_ret_sts_error (error),
3536: -- fnd_api.g_ret_sts_unexp_error
3537: -- (unexpected error).
3538: -- x_msg_count Number of messages in message stack.
3539: -- x_msg_data Message text if x_msg_count is 1.
3540: --

Line 3576: x_return_status := FND_API.G_RET_STS_SUCCESS;

3572:
3573:
3574: savepoint clear_suggested_default;
3575:
3576: x_return_status := FND_API.G_RET_STS_SUCCESS;
3577:
3578: IF(p_merge_type = 'PARTY_MERGE') THEN
3579:
3580:

Line 3705: WHEN FND_API.G_EXC_ERROR THEN

3701: END IF;
3702:
3703: EXCEPTION
3704:
3705: WHEN FND_API.G_EXC_ERROR THEN
3706: ROLLBACK TO clear_suggested_default;
3707: x_return_status := FND_API.G_RET_STS_ERROR;
3708: FND_MSG_PUB.Count_And_Get(
3709: p_encoded => FND_API.G_FALSE,

Line 3707: x_return_status := FND_API.G_RET_STS_ERROR;

3703: EXCEPTION
3704:
3705: WHEN FND_API.G_EXC_ERROR THEN
3706: ROLLBACK TO clear_suggested_default;
3707: x_return_status := FND_API.G_RET_STS_ERROR;
3708: FND_MSG_PUB.Count_And_Get(
3709: p_encoded => FND_API.G_FALSE,
3710: p_count => x_msg_count,
3711: p_data => x_msg_data);

Line 3709: p_encoded => FND_API.G_FALSE,

3705: WHEN FND_API.G_EXC_ERROR THEN
3706: ROLLBACK TO clear_suggested_default;
3707: x_return_status := FND_API.G_RET_STS_ERROR;
3708: FND_MSG_PUB.Count_And_Get(
3709: p_encoded => FND_API.G_FALSE,
3710: p_count => x_msg_count,
3711: p_data => x_msg_data);
3712:
3713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3709: p_encoded => FND_API.G_FALSE,
3710: p_count => x_msg_count,
3711: p_data => x_msg_data);
3712:
3713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3714: ROLLBACK TO clear_suggested_default;
3715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3716: FND_MSG_PUB.Count_And_Get(
3717: p_encoded => FND_API.G_FALSE,

Line 3715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3711: p_data => x_msg_data);
3712:
3713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3714: ROLLBACK TO clear_suggested_default;
3715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3716: FND_MSG_PUB.Count_And_Get(
3717: p_encoded => FND_API.G_FALSE,
3718: p_count => x_msg_count,
3719: p_data => x_msg_data);

Line 3717: p_encoded => FND_API.G_FALSE,

3713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3714: ROLLBACK TO clear_suggested_default;
3715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3716: FND_MSG_PUB.Count_And_Get(
3717: p_encoded => FND_API.G_FALSE,
3718: p_count => x_msg_count,
3719: p_data => x_msg_data);
3720:
3721: WHEN OTHERS THEN

Line 3723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3719: p_data => x_msg_data);
3720:
3721: WHEN OTHERS THEN
3722: ROLLBACK TO clear_suggested_default;
3723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3724: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3726: FND_MSG_PUB.ADD;
3727: FND_MSG_PUB.Count_And_Get(

Line 3728: p_encoded => FND_API.G_FALSE,

3724: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3726: FND_MSG_PUB.ADD;
3727: FND_MSG_PUB.Count_And_Get(
3728: p_encoded => FND_API.G_FALSE,
3729: p_count => x_msg_count,
3730: p_data => x_msg_data);
3731:
3732: END clear_suggested_default;

Line 3753: -- be fnd_api.g_ret_sts_success (success),

3749: -- p_merge_type Merge type of the dup set
3750: --
3751: -- OUT:
3752: -- x_return_status Return status after the call. The status can
3753: -- be fnd_api.g_ret_sts_success (success),
3754: -- fnd_api.g_ret_sts_error (error),
3755: -- fnd_api.g_ret_sts_unexp_error
3756: -- (unexpected error).
3757: -- x_msg_count Number of messages in message stack.

Line 3754: -- fnd_api.g_ret_sts_error (error),

3750: --
3751: -- OUT:
3752: -- x_return_status Return status after the call. The status can
3753: -- be fnd_api.g_ret_sts_success (success),
3754: -- fnd_api.g_ret_sts_error (error),
3755: -- fnd_api.g_ret_sts_unexp_error
3756: -- (unexpected error).
3757: -- x_msg_count Number of messages in message stack.
3758: -- x_msg_data Message text if x_msg_count is 1.

Line 3755: -- fnd_api.g_ret_sts_unexp_error

3751: -- OUT:
3752: -- x_return_status Return status after the call. The status can
3753: -- be fnd_api.g_ret_sts_success (success),
3754: -- fnd_api.g_ret_sts_error (error),
3755: -- fnd_api.g_ret_sts_unexp_error
3756: -- (unexpected error).
3757: -- x_msg_count Number of messages in message stack.
3758: -- x_msg_data Message text if x_msg_count is 1.
3759: --

Line 3904: x_return_status := FND_API.G_RET_STS_SUCCESS;

3900: l_merge_batch_id NUMBER;
3901: l_request_id number;
3902: BEGIN
3903:
3904: x_return_status := FND_API.G_RET_STS_SUCCESS;
3905:
3906: IF (NVL(FND_PROFILE.VALUE('HZ_DL_CREATE_SUGG_MERGE_REQ'), 'Y') = 'Y') THEN
3907:
3908: open is_sugg_request_done_csr;

Line 3985: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

3981: ,x_return_status => l_return_status
3982: ,x_msg_count => l_msg_count
3983: ,x_msg_data => l_msg_data );
3984: end if;
3985: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3986: ROLLBACK to create_reln_sysbatch;
3987: RETURN;
3988: END IF;
3989:

Line 4054: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

4050: ,x_return_status => x_return_status
4051: ,x_msg_count => x_msg_count
4052: ,x_msg_data => x_msg_data );
4053: end if;
4054: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4055: ROLLBACK to create_reln_sysbatch;
4056: RETURN;
4057: end if;
4058:

Line 4073: WHEN FND_API.G_EXC_ERROR THEN

4069: end if; -- (NVL(FND_PROFILE.VALUE('HZ_DL_CREATE_SUGG_MERGE_REQ')
4070:
4071: EXCEPTION
4072:
4073: WHEN FND_API.G_EXC_ERROR THEN
4074: ROLLBACK TO create_reln_sysbatch;
4075: x_return_status := FND_API.G_RET_STS_ERROR;
4076: FND_MSG_PUB.Count_And_Get(
4077: p_encoded => FND_API.G_FALSE,

Line 4075: x_return_status := FND_API.G_RET_STS_ERROR;

4071: EXCEPTION
4072:
4073: WHEN FND_API.G_EXC_ERROR THEN
4074: ROLLBACK TO create_reln_sysbatch;
4075: x_return_status := FND_API.G_RET_STS_ERROR;
4076: FND_MSG_PUB.Count_And_Get(
4077: p_encoded => FND_API.G_FALSE,
4078: p_count => x_msg_count,
4079: p_data => x_msg_data);

Line 4077: p_encoded => FND_API.G_FALSE,

4073: WHEN FND_API.G_EXC_ERROR THEN
4074: ROLLBACK TO create_reln_sysbatch;
4075: x_return_status := FND_API.G_RET_STS_ERROR;
4076: FND_MSG_PUB.Count_And_Get(
4077: p_encoded => FND_API.G_FALSE,
4078: p_count => x_msg_count,
4079: p_data => x_msg_data);
4080:
4081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4077: p_encoded => FND_API.G_FALSE,
4078: p_count => x_msg_count,
4079: p_data => x_msg_data);
4080:
4081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4082: ROLLBACK TO create_reln_sysbatch;
4083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4084: FND_MSG_PUB.Count_And_Get(
4085: p_encoded => FND_API.G_FALSE,

Line 4083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4079: p_data => x_msg_data);
4080:
4081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4082: ROLLBACK TO create_reln_sysbatch;
4083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4084: FND_MSG_PUB.Count_And_Get(
4085: p_encoded => FND_API.G_FALSE,
4086: p_count => x_msg_count,
4087: p_data => x_msg_data);

Line 4085: p_encoded => FND_API.G_FALSE,

4081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4082: ROLLBACK TO create_reln_sysbatch;
4083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4084: FND_MSG_PUB.Count_And_Get(
4085: p_encoded => FND_API.G_FALSE,
4086: p_count => x_msg_count,
4087: p_data => x_msg_data);
4088:
4089: WHEN OTHERS THEN

Line 4091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4087: p_data => x_msg_data);
4088:
4089: WHEN OTHERS THEN
4090: ROLLBACK TO create_reln_sysbatch;
4091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4092: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4093: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4094: FND_MSG_PUB.ADD;
4095: FND_MSG_PUB.Count_And_Get(

Line 4096: p_encoded => FND_API.G_FALSE,

4092: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4093: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4094: FND_MSG_PUB.ADD;
4095: FND_MSG_PUB.Count_And_Get(
4096: p_encoded => FND_API.G_FALSE,
4097: p_count => x_msg_count,
4098: p_data => x_msg_data);
4099:
4100: END create_reln_sysbatch;

Line 4117: -- be fnd_api.g_ret_sts_success (success),

4113: -- p_merge_type Merge type of the dup set
4114: --
4115: -- OUT:
4116: -- x_return_status Return status after the call. The status can
4117: -- be fnd_api.g_ret_sts_success (success),
4118: -- fnd_api.g_ret_sts_error (error),
4119: -- fnd_api.g_ret_sts_unexp_error
4120: -- (unexpected error).
4121: -- x_msg_count Number of messages in message stack.

Line 4118: -- fnd_api.g_ret_sts_error (error),

4114: --
4115: -- OUT:
4116: -- x_return_status Return status after the call. The status can
4117: -- be fnd_api.g_ret_sts_success (success),
4118: -- fnd_api.g_ret_sts_error (error),
4119: -- fnd_api.g_ret_sts_unexp_error
4120: -- (unexpected error).
4121: -- x_msg_count Number of messages in message stack.
4122: -- x_msg_data Message text if x_msg_count is 1.

Line 4119: -- fnd_api.g_ret_sts_unexp_error

4115: -- OUT:
4116: -- x_return_status Return status after the call. The status can
4117: -- be fnd_api.g_ret_sts_success (success),
4118: -- fnd_api.g_ret_sts_error (error),
4119: -- fnd_api.g_ret_sts_unexp_error
4120: -- (unexpected error).
4121: -- x_msg_count Number of messages in message stack.
4122: -- x_msg_data Message text if x_msg_count is 1.
4123: --

Line 4146: x_return_status := FND_API.G_RET_STS_SUCCESS;

4142: l_merge_to NUMBER;
4143:
4144: BEGIN
4145:
4146: x_return_status := FND_API.G_RET_STS_SUCCESS;
4147: fnd_msg_pub.initialize;
4148:
4149: savepoint delete_mapping;
4150:

Line 4173: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

4169: HZ_MERGE_ENTITY_ATTRI_PVT.create_merge_attributes(
4170: p_batch_id, l_merge_to, l_party_type,
4171: x_return_status, x_msg_count, x_msg_data);
4172:
4173: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4174: ROLLBACK to delete_mapping;
4175: RETURN;
4176: END IF;
4177: END IF;

Line 4188: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

4184: ,x_return_status => x_return_status
4185: ,x_msg_count => x_msg_count
4186: ,x_msg_data => x_msg_data );
4187:
4188: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4189: ROLLBACK to delete_mapping;
4190: RETURN;
4191: END IF;
4192:

Line 4202: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

4198: ,x_return_status => x_return_status
4199: ,x_msg_count => x_msg_count
4200: ,x_msg_data => x_msg_data );
4201:
4202: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4203: ROLLBACK to delete_mapping;
4204: RETURN;
4205: END IF;
4206:

Line 4209: WHEN FND_API.G_EXC_ERROR THEN

4205: END IF;
4206:
4207: EXCEPTION
4208:
4209: WHEN FND_API.G_EXC_ERROR THEN
4210: ROLLBACK TO delete_mapping;
4211: x_return_status := FND_API.G_RET_STS_ERROR;
4212: FND_MSG_PUB.Count_And_Get(
4213: p_encoded => FND_API.G_FALSE,

Line 4211: x_return_status := FND_API.G_RET_STS_ERROR;

4207: EXCEPTION
4208:
4209: WHEN FND_API.G_EXC_ERROR THEN
4210: ROLLBACK TO delete_mapping;
4211: x_return_status := FND_API.G_RET_STS_ERROR;
4212: FND_MSG_PUB.Count_And_Get(
4213: p_encoded => FND_API.G_FALSE,
4214: p_count => x_msg_count,
4215: p_data => x_msg_data);

Line 4213: p_encoded => FND_API.G_FALSE,

4209: WHEN FND_API.G_EXC_ERROR THEN
4210: ROLLBACK TO delete_mapping;
4211: x_return_status := FND_API.G_RET_STS_ERROR;
4212: FND_MSG_PUB.Count_And_Get(
4213: p_encoded => FND_API.G_FALSE,
4214: p_count => x_msg_count,
4215: p_data => x_msg_data);
4216:
4217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4213: p_encoded => FND_API.G_FALSE,
4214: p_count => x_msg_count,
4215: p_data => x_msg_data);
4216:
4217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4218: ROLLBACK TO delete_mapping;
4219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4220: FND_MSG_PUB.Count_And_Get(
4221: p_encoded => FND_API.G_FALSE,

Line 4219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4215: p_data => x_msg_data);
4216:
4217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4218: ROLLBACK TO delete_mapping;
4219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4220: FND_MSG_PUB.Count_And_Get(
4221: p_encoded => FND_API.G_FALSE,
4222: p_count => x_msg_count,
4223: p_data => x_msg_data);

Line 4221: p_encoded => FND_API.G_FALSE,

4217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4218: ROLLBACK TO delete_mapping;
4219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4220: FND_MSG_PUB.Count_And_Get(
4221: p_encoded => FND_API.G_FALSE,
4222: p_count => x_msg_count,
4223: p_data => x_msg_data);
4224:
4225: WHEN OTHERS THEN

Line 4227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4223: p_data => x_msg_data);
4224:
4225: WHEN OTHERS THEN
4226: ROLLBACK TO delete_mapping;
4227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4228: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4229: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4230: FND_MSG_PUB.ADD;
4231: FND_MSG_PUB.Count_And_Get(

Line 4232: p_encoded => FND_API.G_FALSE,

4228: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4229: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4230: FND_MSG_PUB.ADD;
4231: FND_MSG_PUB.Count_And_Get(
4232: p_encoded => FND_API.G_FALSE,
4233: p_count => x_msg_count,
4234: p_data => x_msg_data);
4235:
4236: END delete_mapping;

Line 4256: -- be fnd_api.g_ret_sts_success (success),

4252: -- p_merge_type Merge type of the dup set
4253: --
4254: -- OUT:
4255: -- x_return_status Return status after the call. The status can
4256: -- be fnd_api.g_ret_sts_success (success),
4257: -- fnd_api.g_ret_sts_error (error),
4258: -- fnd_api.g_ret_sts_unexp_error
4259: -- (unexpected error).
4260: -- x_msg_count Number of messages in message stack.

Line 4257: -- fnd_api.g_ret_sts_error (error),

4253: --
4254: -- OUT:
4255: -- x_return_status Return status after the call. The status can
4256: -- be fnd_api.g_ret_sts_success (success),
4257: -- fnd_api.g_ret_sts_error (error),
4258: -- fnd_api.g_ret_sts_unexp_error
4259: -- (unexpected error).
4260: -- x_msg_count Number of messages in message stack.
4261: -- x_msg_data Message text if x_msg_count is 1.

Line 4258: -- fnd_api.g_ret_sts_unexp_error

4254: -- OUT:
4255: -- x_return_status Return status after the call. The status can
4256: -- be fnd_api.g_ret_sts_success (success),
4257: -- fnd_api.g_ret_sts_error (error),
4258: -- fnd_api.g_ret_sts_unexp_error
4259: -- (unexpected error).
4260: -- x_msg_count Number of messages in message stack.
4261: -- x_msg_data Message text if x_msg_count is 1.
4262: --

Line 4297: x_return_status := FND_API.G_RET_STS_SUCCESS;

4293:
4294: BEGIN
4295:
4296: fnd_msg_pub.initialize;
4297: x_return_status := FND_API.G_RET_STS_SUCCESS;
4298:
4299: SAVEPOINT unmap_child_records;
4300:
4301: IF (p_merge_batch_id is null) OR (p_merge_type IS NULL )

Line 4306: RAISE FND_API.G_EXC_ERROR;

4302: OR (p_entity is null) OR (p_entity_id IS NULL) THEN
4303: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
4304: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');
4305: FND_MSG_PUB.ADD;
4306: RAISE FND_API.G_EXC_ERROR;
4307: END IF;
4308:
4309: OPEN c_children(p_merge_batch_id, p_entity, p_entity_id);
4310: FETCH c_children INTO l_child_entity_id, l_batch_party_id, l_obj_ver_number;

Line 4347: p_encoded => FND_API.G_FALSE,

4343: END IF;
4344:
4345: -- standard call to get message count and if count is 1, get message info.
4346: FND_MSG_PUB.Count_And_Get(
4347: p_encoded => FND_API.G_FALSE,
4348: p_count => x_msg_count,
4349: p_data => x_msg_data);
4350:
4351: EXCEPTION

Line 4352: WHEN FND_API.G_EXC_ERROR THEN

4348: p_count => x_msg_count,
4349: p_data => x_msg_data);
4350:
4351: EXCEPTION
4352: WHEN FND_API.G_EXC_ERROR THEN
4353: ROLLBACK to unmap_child_records ;
4354: x_return_status := FND_API.G_RET_STS_ERROR;
4355: FND_MSG_PUB.Count_And_Get(
4356: p_encoded => FND_API.G_FALSE,

Line 4354: x_return_status := FND_API.G_RET_STS_ERROR;

4350:
4351: EXCEPTION
4352: WHEN FND_API.G_EXC_ERROR THEN
4353: ROLLBACK to unmap_child_records ;
4354: x_return_status := FND_API.G_RET_STS_ERROR;
4355: FND_MSG_PUB.Count_And_Get(
4356: p_encoded => FND_API.G_FALSE,
4357: p_count => x_msg_count,
4358: p_data => x_msg_data);

Line 4356: p_encoded => FND_API.G_FALSE,

4352: WHEN FND_API.G_EXC_ERROR THEN
4353: ROLLBACK to unmap_child_records ;
4354: x_return_status := FND_API.G_RET_STS_ERROR;
4355: FND_MSG_PUB.Count_And_Get(
4356: p_encoded => FND_API.G_FALSE,
4357: p_count => x_msg_count,
4358: p_data => x_msg_data);
4359:
4360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4356: p_encoded => FND_API.G_FALSE,
4357: p_count => x_msg_count,
4358: p_data => x_msg_data);
4359:
4360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4361: ROLLBACK to unmap_child_records ;
4362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4363: FND_MSG_PUB.Count_And_Get(
4364: p_encoded => FND_API.G_FALSE,

Line 4362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4358: p_data => x_msg_data);
4359:
4360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4361: ROLLBACK to unmap_child_records ;
4362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4363: FND_MSG_PUB.Count_And_Get(
4364: p_encoded => FND_API.G_FALSE,
4365: p_count => x_msg_count,
4366: p_data => x_msg_data);

Line 4364: p_encoded => FND_API.G_FALSE,

4360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4361: ROLLBACK to unmap_child_records ;
4362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4363: FND_MSG_PUB.Count_And_Get(
4364: p_encoded => FND_API.G_FALSE,
4365: p_count => x_msg_count,
4366: p_data => x_msg_data);
4367:
4368: WHEN OTHERS THEN

Line 4370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4366: p_data => x_msg_data);
4367:
4368: WHEN OTHERS THEN
4369: ROLLBACK to unmap_child_records;
4370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4371:
4372: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4373: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4374: FND_MSG_PUB.ADD;

Line 4378: p_encoded => FND_API.G_FALSE,

4374: FND_MSG_PUB.ADD;
4375:
4376:
4377: FND_MSG_PUB.Count_And_Get(
4378: p_encoded => FND_API.G_FALSE,
4379: p_count => x_msg_count,
4380: p_data => x_msg_data);
4381:
4382: END unmap_child_records;

Line 4497: x_return_status := FND_API.G_RET_STS_SUCCESS;

4493: l_err_reported number := 0;
4494: l_batch_party_id number;
4495:
4496: begin
4497: x_return_status := FND_API.G_RET_STS_SUCCESS;
4498:
4499: -- Initialize message list if p_init_msg_list is set to TRUE.
4500: IF FND_API.to_Boolean( p_init_msg_list )
4501: THEN

Line 4500: IF FND_API.to_Boolean( p_init_msg_list )

4496: begin
4497: x_return_status := FND_API.G_RET_STS_SUCCESS;
4498:
4499: -- Initialize message list if p_init_msg_list is set to TRUE.
4500: IF FND_API.to_Boolean( p_init_msg_list )
4501: THEN
4502: FND_MSG_PUB.initialize;
4503: END IF;
4504:

Line 4515: x_return_status := FND_API.G_RET_STS_ERROR;

4511: l_object_version_number;
4512: exit when dset_overlap_merged_party_csr%NOTFOUND;
4513: if l_party_number is not null
4514: then
4515: x_return_status := FND_API.G_RET_STS_ERROR;
4516: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_PARTY_ALREADY_MERGED');
4517: FND_MESSAGE.SET_TOKEN('ID', l_party_number );
4518: FND_MSG_PUB.ADD;
4519: end if;

Line 4530: x_return_status := FND_API.G_RET_STS_ERROR;

4526: exit when dset_overlap_req_party_csr%NOTFOUND;
4527: if l_batch_id is not null
4528: then
4529: l_party_number := get_party_number(l_party_id);
4530: x_return_status := FND_API.G_RET_STS_ERROR;
4531: if get_merge_batch_data_source(l_batch_id) = 'D' -- from DL UI
4532: then
4533: FND_MESSAGE.SET_NAME('AR', 'HZ_PM_MR_EXIST_DL');
4534: FND_MESSAGE.SET_TOKEN('ID', l_party_number );

Line 4547: IF (p_reject_req_flag = 'Y' and x_return_status<>FND_API.G_RET_STS_SUCCESS)

4543: end if;
4544: end loop;
4545: close dset_overlap_req_party_csr;
4546:
4547: IF (p_reject_req_flag = 'Y' and x_return_status<>FND_API.G_RET_STS_SUCCESS)
4548: THEN
4549:
4550: /*
4551: HZ_DUP_PVT.reject_merge (

Line 4554: ,p_init_msg_list => FND_API.G_FALSE

4550: /*
4551: HZ_DUP_PVT.reject_merge (
4552: p_dup_set_id => p_dup_set_id
4553: ,px_set_obj_version_number => l_object_version_number
4554: ,p_init_msg_list => FND_API.G_FALSE
4555: ,x_return_status => x_return_status
4556: ,x_msg_count => x_msg_count
4557: ,x_msg_data => x_msg_data);
4558: */

Line 4569: x_return_status := FND_API.G_RET_STS_ERROR;

4565: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
4566: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
4567: WHERE DUP_SET_ID = p_dup_set_id;
4568:
4569: x_return_status := FND_API.G_RET_STS_ERROR;
4570: end if;
4571:
4572: FND_MSG_PUB.Count_And_Get(
4573: p_encoded => FND_API.G_FALSE,

Line 4573: p_encoded => FND_API.G_FALSE,

4569: x_return_status := FND_API.G_RET_STS_ERROR;
4570: end if;
4571:
4572: FND_MSG_PUB.Count_And_Get(
4573: p_encoded => FND_API.G_FALSE,
4574: p_count => x_msg_count,
4575: p_data => x_msg_data);
4576:
4577: elsif p_merge_batch_id is not null -- data passed in from party merge

Line 4605: x_return_status := FND_API.G_RET_STS_ERROR;

4601: then
4602: FND_FILE.put_line(fnd_file.log,'The Party with Registry ID ' || l_party_number || ' has already been merged.');
4603:
4604: if l_err_reported = 0 then
4605: x_return_status := FND_API.G_RET_STS_ERROR;
4606: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_PARTY_ALREADY_MERGED');
4607: FND_MESSAGE.SET_TOKEN('ID', l_party_number );
4608: FND_MSG_PUB.ADD;
4609: l_err_reported := 1;

Line 4619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4615: end if;
4616:
4617: EXCEPTION
4618: WHEN OTHERS THEN
4619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4620: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4621: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4622: FND_MSG_PUB.ADD;
4623: FND_MSG_PUB.Count_And_Get(

Line 4624: p_encoded => FND_API.G_FALSE,

4620: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4621: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4622: FND_MSG_PUB.ADD;
4623: FND_MSG_PUB.Count_And_Get(
4624: p_encoded => FND_API.G_FALSE,
4625: p_count => x_msg_count,
4626: p_data => x_msg_data);
4627:
4628: end validate_overlapping_merge_req;

Line 4775: x_return_status := FND_API.G_RET_STS_SUCCESS;

4771: l_messages varchar2(2000) :='';
4772:
4773: begin
4774: FND_MSG_PUB.initialize; -- make sure only show warning messages
4775: x_return_status := FND_API.G_RET_STS_SUCCESS;
4776: open check_site_merge_csr;
4777: loop
4778: fetch check_site_merge_csr into l_account_number, l_to_entity_id;
4779: exit when check_site_merge_csr%NOTFOUND;

Line 4801: l_note_text := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);

4797: FND_MESSAGE.SET_TOKEN('ACCTNUM', l_account_number);
4798: FND_MESSAGE.SET_TOKEN('MERGETO_ADDR', l_to_addr);
4799: FND_MSG_PUB.ADD;
4800:
4801: l_note_text := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
4802:
4803: str := 'BEGIN '||
4804: 'JTF_NOTES_PUB.Create_note(null,null,1,FND_API.g_false,FND_API.g_true,100,'
4805: ||':x_return_status,:x_msg_count,:x_msg_data,'||'null,'||':p_merge_batch_id,'

Line 4804: 'JTF_NOTES_PUB.Create_note(null,null,1,FND_API.g_false,FND_API.g_true,100,'

4800:
4801: l_note_text := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
4802:
4803: str := 'BEGIN '||
4804: 'JTF_NOTES_PUB.Create_note(null,null,1,FND_API.g_false,FND_API.g_true,100,'
4805: ||':x_return_status,:x_msg_count,:x_msg_data,'||'null,'||':p_merge_batch_id,'
4806: ||'''MERGE_DUP_SET'''||','||':l_note_text,'
4807: ||'null,''I'',0,SYSDATE,'||':l_jtf_note_id'||',SYSDATE,0,SYSDATE,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'||'''GENERAL'''||');'||'END;';
4808: --fnd_file.put_line(fnd_file.log, str);

Line 4821: p_encoded => FND_API.G_FALSE,

4817:
4818: if p_generate_note_flag = 'N'
4819: then
4820: FND_MSG_PUB.Count_And_Get(
4821: p_encoded => FND_API.G_FALSE,
4822: p_count => x_msg_count,
4823: p_data => x_msg_data);
4824:
4825: if x_msg_count = 1

Line 4827: l_messages := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);

4823: p_data => x_msg_data);
4824:
4825: if x_msg_count = 1
4826: then
4827: l_messages := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
4828: else
4829: FOR l_index IN 1..x_msg_count LOOP
4830: l_msg := FND_MSG_PUB.Get(
4831: p_msg_index => l_index,

Line 4832: p_encoded => FND_API.G_FALSE);

4828: else
4829: FOR l_index IN 1..x_msg_count LOOP
4830: l_msg := FND_MSG_PUB.Get(
4831: p_msg_index => l_index,
4832: p_encoded => FND_API.G_FALSE);
4833: --l_messages:=l_messages||fnd_global.local_chr(10)||l_msg||fnd_global.local_chr(10);
4834: l_messages:=l_messages||'
'||l_msg||'
';
4835: END LOOP;
4836: end if;

Line 4843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4839: end if;
4840:
4841: EXCEPTION
4842: WHEN OTHERS THEN
4843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4844: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4845: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4846: FND_MSG_PUB.ADD;
4847: FND_MSG_PUB.Count_And_Get(

Line 4848: p_encoded => FND_API.G_FALSE,

4844: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4845: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4846: FND_MSG_PUB.ADD;
4847: FND_MSG_PUB.Count_And_Get(
4848: p_encoded => FND_API.G_FALSE,
4849: p_count => x_msg_count,
4850: p_data => x_msg_data);
4851:
4852: end site_merge_warning;