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 133: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 147: RAISE FND_API.G_EXC_ERROR;

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

Line 259: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

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

Line 291: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

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

Line 315: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

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

Line 351: RAISE FND_API.G_EXC_ERROR;

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

Line 364: p_encoded => FND_API.G_FALSE,

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

Line 369: WHEN FND_API.G_EXC_ERROR THEN

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

Line 371: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 373: p_encoded => FND_API.G_FALSE,

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

Line 377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 381: p_encoded => FND_API.G_FALSE,

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

Line 387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 394: p_encoded => FND_API.G_FALSE,

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

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

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

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

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

Line 464: -- fnd_api.g_ret_sts_unexp_error

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

Line 560: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 574: RAISE FND_API.G_EXC_ERROR;

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

Line 589: RAISE FND_API.G_EXC_ERROR;

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

Line 620: RAISE FND_API.G_EXC_ERROR;

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

Line 629: RAISE FND_API.G_EXC_ERROR;

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

Line 654: RAISE FND_API.G_EXC_ERROR;

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

Line 661: FND_API.G_FALSE,

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

Line 669: RAISE FND_API.G_EXC_ERROR;

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

Line 672: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 673: RAISE FND_API.G_EXC_ERROR;

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

Line 674: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 724: RAISE FND_API.G_EXC_ERROR;

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

Line 836: RAISE FND_API.G_EXC_ERROR;

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

Line 842: p_encoded => FND_API.G_FALSE,

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

Line 847: WHEN FND_API.G_EXC_ERROR THEN

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

Line 849: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 851: p_encoded => FND_API.G_FALSE,

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

Line 855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 859: p_encoded => FND_API.G_FALSE,

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

Line 865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 873: p_encoded => FND_API.G_FALSE,

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

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

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

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

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

Line 900: -- fnd_api.g_ret_sts_unexp_error

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

Line 1011: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1027: RAISE FND_API.G_EXC_ERROR;

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

Line 1035: RAISE FND_API.G_EXC_ERROR;

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

Line 1043: RAISE FND_API.G_EXC_ERROR;

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

Line 1055: RAISE FND_API.G_EXC_ERROR;

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

Line 1071: RAISE FND_API.G_EXC_ERROR;

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

Line 1093: RAISE FND_API.G_EXC_ERROR;

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

Line 1101: FND_API.G_FALSE,

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

Line 1109: RAISE FND_API.G_EXC_ERROR;

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

Line 1113: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1114: RAISE FND_API.G_EXC_ERROR;

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

Line 1115: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1136: RAISE FND_API.G_EXC_ERROR;

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

Line 1179: RAISE FND_API.G_EXC_ERROR;

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

Line 1294: p_encoded => FND_API.G_FALSE,

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

Line 1299: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1301: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1303: p_encoded => FND_API.G_FALSE,

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

Line 1307: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1311: p_encoded => FND_API.G_FALSE,

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

Line 1317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1325: p_encoded => FND_API.G_FALSE,

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

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

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

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

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

Line 1349: -- fnd_api.g_ret_sts_unexp_error

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

Line 1386: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1421: RAISE FND_API.G_EXC_ERROR;

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

Line 1435: RAISE FND_API.G_EXC_ERROR;

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

Line 1452: RAISE FND_API.G_EXC_ERROR;

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

Line 1459: RAISE FND_API.G_EXC_ERROR;

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

Line 1476: RAISE FND_API.G_EXC_ERROR;

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

Line 1506: p_encoded => FND_API.G_FALSE,

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

Line 1511: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1513: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1515: p_encoded => FND_API.G_FALSE,

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

Line 1519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1523: p_encoded => FND_API.G_FALSE,

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

Line 1529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1536: p_encoded => FND_API.G_FALSE,

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

Line 2166: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2169: p_batch_id = FND_API.G_MISS_NUM) THEN

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

Line 2173: RAISE FND_API.G_EXC_ERROR;

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

Line 2269: RAISE FND_API.G_EXC_ERROR;

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

Line 2278: WHEN FND_API.G_EXC_ERROR THEN

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

Line 2280: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2282: p_encoded => FND_API.G_FALSE,

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

Line 2286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2290: p_encoded => FND_API.G_FALSE,

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

Line 2296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2301: p_encoded => FND_API.G_FALSE,

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

Line 2475: p_init_msg_list => FND_API.G_TRUE

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

Line 2519: FND_API.G_FALSE,

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

Line 2532: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 2533: RAISE FND_API.G_EXC_ERROR;

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

Line 2620: p_init_msg_list => FND_API.G_TRUE

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

Line 2658: FND_API.G_FALSE,

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

Line 2665: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 2666: RAISE FND_API.G_EXC_ERROR;

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

Line 2900: p_init_msg_list => FND_API.G_TRUE

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

Line 3039: p_init_msg_list => FND_API.G_TRUE

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

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

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

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

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

Line 3381: -- fnd_api.g_ret_sts_unexp_error

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

Line 3404: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 3491: WHEN FND_API.G_EXC_ERROR THEN

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

Line 3493: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3495: p_encoded => FND_API.G_FALSE,

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

Line 3499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 3501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3503: p_encoded => FND_API.G_FALSE,

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

Line 3509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3514: p_encoded => FND_API.G_FALSE,

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

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

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

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

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

Line 3538: -- fnd_api.g_ret_sts_unexp_error

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

Line 3578: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 3707: WHEN FND_API.G_EXC_ERROR THEN

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

Line 3709: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3711: p_encoded => FND_API.G_FALSE,

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

Line 3715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 3717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3719: p_encoded => FND_API.G_FALSE,

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

Line 3725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3730: p_encoded => FND_API.G_FALSE,

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

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

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

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

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

Line 3757: -- fnd_api.g_ret_sts_unexp_error

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

Line 3906: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 3987: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

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

Line 4056: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

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

Line 4075: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4077: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 4079: p_encoded => FND_API.G_FALSE,

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

Line 4083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 4087: p_encoded => FND_API.G_FALSE,

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

Line 4093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 4098: p_encoded => FND_API.G_FALSE,

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

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

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

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

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

Line 4121: -- fnd_api.g_ret_sts_unexp_error

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

Line 4148: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 4175: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

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

Line 4190: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

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

Line 4204: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

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

Line 4211: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4213: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 4215: p_encoded => FND_API.G_FALSE,

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

Line 4219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 4223: p_encoded => FND_API.G_FALSE,

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

Line 4229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 4234: p_encoded => FND_API.G_FALSE,

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

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

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

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

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

Line 4260: -- fnd_api.g_ret_sts_unexp_error

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

Line 4299: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 4308: RAISE FND_API.G_EXC_ERROR;

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

Line 4349: p_encoded => FND_API.G_FALSE,

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

Line 4354: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4356: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 4358: p_encoded => FND_API.G_FALSE,

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

Line 4362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 4366: p_encoded => FND_API.G_FALSE,

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

Line 4372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 4380: p_encoded => FND_API.G_FALSE,

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

Line 4499: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 4502: IF FND_API.to_Boolean( p_init_msg_list )

4498: begin
4499: x_return_status := FND_API.G_RET_STS_SUCCESS;
4500:
4501: -- Initialize message list if p_init_msg_list is set to TRUE.
4502: IF FND_API.to_Boolean( p_init_msg_list )
4503: THEN
4504: FND_MSG_PUB.initialize;
4505: END IF;
4506: if HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE <> 'BO_API' -- BO API handled overlapping logic already. Skip it here.

Line 4518: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 4533: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 4557: ,p_init_msg_list => FND_API.G_FALSE

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

Line 4572: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 4576: p_encoded => FND_API.G_FALSE,

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

Line 4608: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 4622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4618: end if;
4619: end if; --HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE <> 'BO_API'
4620: EXCEPTION
4621: WHEN OTHERS THEN
4622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4623: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4624: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4625: FND_MSG_PUB.ADD;
4626: FND_MSG_PUB.Count_And_Get(

Line 4627: p_encoded => FND_API.G_FALSE,

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

Line 4778: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

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

4803:
4804: l_note_text := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
4805:
4806: str := 'BEGIN '||
4807: 'JTF_NOTES_PUB.Create_note(null,null,1,FND_API.g_false,FND_API.g_true,100,'
4808: ||':x_return_status,:x_msg_count,:x_msg_data,'||'null,'||':p_merge_batch_id,'
4809: ||'''MERGE_DUP_SET'''||','||':l_note_text,'
4810: ||'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;';
4811: --fnd_file.put_line(fnd_file.log, str);

Line 4824: p_encoded => FND_API.G_FALSE,

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

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

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

Line 4835: p_encoded => FND_API.G_FALSE);

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

Line 4846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 4851: p_encoded => FND_API.G_FALSE,

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