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

Line 526: x_return_status := FND_API.G_RET_STS_SUCCESS;

522:
523: BEGIN
524:
525: --Initialize API return status to success.
526: x_return_status := FND_API.G_RET_STS_SUCCESS;
527:
528: -- Initialize the compiled package name
529: l_rule_id := TO_NUMBER(p_rule_id);
530: l_package_name := 'HZ_MATCH_RULE_'||p_rule_id;

Line 545: RAISE FND_API.G_EXC_ERROR;

541: EXCEPTION
542: WHEN NO_DATA_FOUND THEN
543: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_NO_RULE');
544: FND_MSG_PUB.ADD;
545: RAISE FND_API.G_EXC_ERROR;
546: END;
547:
548:
549: SELECT RULE_PURPOSE,NVL(MATCH_RULE_TYPE,'SINGLE') into l_purpose,l_match_rule_type FROM HZ_MATCH_RULES_VL --Code Change for Match Rule Set

Line 557: RAISE FND_API.G_EXC_ERROR;

553: IF (l_match_rule_type = 'SET') THEN
554: IF (has_uncompiled_childern(l_rule_id)) THEN
555: FND_MESSAGE.SET_NAME('AR', 'HZ_RULE_SET_UNCOMP_RULE_EXISTS');
556: FND_MSG_PUB.ADD;
557: RAISE FND_API.G_EXC_ERROR;
558: END IF;
559: --Populate the match rule set primary and secondary attributes
560: HZ_POP_MRULE_SET_ATTR_V2PUB.pop_mrule_set_attributes(l_rule_id);
561: END IF;

Line 591: RAISE FND_API.G_EXC_ERROR;

587: NULL;
588: END;
589: fnd_message.set_name('AR','HZ_SCORING_NO_ACQUISITION');
590: FND_MSG_PUB.ADD;
591: RAISE FND_API.G_EXC_ERROR;
592: END IF;
593: CLOSE check_null_set;
594:
595: /* Check if match rule has any inactive transformations */

Line 609: RAISE FND_API.G_EXC_ERROR;

605: END;
606:
607: fnd_message.set_name('AR','HZ_MR_HAS_INACTIVE_TX');
608: FND_MSG_PUB.ADD;
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611: CLOSE check_inactive;
612:
613: -- Generate and compile match rule package spec

Line 651: p_encoded => FND_API.G_FALSE,

647: EXECUTE IMMEDIATE 'ALTER PACKAGE ' || l_package_name || ' COMPILE SPECIFICATION'; --bug 5622345
648:
649: --Standard call to get message count and if count is 1, get message info.
650: FND_MSG_PUB.Count_And_Get(
651: p_encoded => FND_API.G_FALSE,
652: p_count => x_msg_count,
653: p_data => x_msg_data);
654:
655: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'C' WHERE MATCH_RULE_ID = l_rule_id;

Line 673: WHEN FND_API.G_EXC_ERROR THEN

669: HZ_DQM_DUP_ID_PKG.compile_match_rule(l_rule_id,x_return_status,x_msg_count,x_msg_data);
670: END IF;
671:
672: EXCEPTION
673: WHEN FND_API.G_EXC_ERROR THEN
674: FND_MSG_PUB.Count_And_Get(
675: p_encoded => FND_API.G_FALSE,
676: p_count => x_msg_count,
677: p_data => x_msg_data);

Line 675: p_encoded => FND_API.G_FALSE,

671:
672: EXCEPTION
673: WHEN FND_API.G_EXC_ERROR THEN
674: FND_MSG_PUB.Count_And_Get(
675: p_encoded => FND_API.G_FALSE,
676: p_count => x_msg_count,
677: p_data => x_msg_data);
678: x_return_status := FND_API.G_RET_STS_ERROR;
679: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = l_rule_id;

Line 678: x_return_status := FND_API.G_RET_STS_ERROR;

674: FND_MSG_PUB.Count_And_Get(
675: p_encoded => FND_API.G_FALSE,
676: p_count => x_msg_count,
677: p_data => x_msg_data);
678: x_return_status := FND_API.G_RET_STS_ERROR;
679: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = l_rule_id;
680: COMMIT;
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682: FND_MSG_PUB.Count_And_Get(

Line 681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

677: p_data => x_msg_data);
678: x_return_status := FND_API.G_RET_STS_ERROR;
679: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = l_rule_id;
680: COMMIT;
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682: FND_MSG_PUB.Count_And_Get(
683: p_encoded => FND_API.G_FALSE,
684: p_count => x_msg_count,
685: p_data => x_msg_data);

Line 683: p_encoded => FND_API.G_FALSE,

679: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = l_rule_id;
680: COMMIT;
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682: FND_MSG_PUB.Count_And_Get(
683: p_encoded => FND_API.G_FALSE,
684: p_count => x_msg_count,
685: p_data => x_msg_data);
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = l_rule_id;

Line 686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

682: FND_MSG_PUB.Count_And_Get(
683: p_encoded => FND_API.G_FALSE,
684: p_count => x_msg_count,
685: p_data => x_msg_data);
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = l_rule_id;
688: COMMIT;
689: WHEN OTHERS THEN
690:

Line 697: p_encoded => FND_API.G_FALSE,

693: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
694: FND_MSG_PUB.ADD;
695:
696: FND_MSG_PUB.Count_And_Get(
697: p_encoded => FND_API.G_FALSE,
698: p_count => x_msg_count,
699: p_data => x_msg_data);
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
701: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = l_rule_id;

Line 700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

696: FND_MSG_PUB.Count_And_Get(
697: p_encoded => FND_API.G_FALSE,
698: p_count => x_msg_count,
699: p_data => x_msg_data);
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
701: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = l_rule_id;
702: COMMIT;
703: END;
704:

Line 778: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

774: --l(' PROCEDURE disable_debug;');
775:
776: -- Generate find_parties code. Backward compatible signature.
777: l(' PROCEDURE find_parties (');
778: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
779: l(' x_rule_id IN OUT NUMBER,');
780: l(' p_party_search_rec IN party_search_rec_type,');
781: l(' p_party_site_list IN party_site_list,');
782: l(' p_contact_list IN contact_list,');

Line 805: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

801: l(' END;');
802: l('');
803: -- Generate find_parties code. Public signature.
804: l(' PROCEDURE find_parties (');
805: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
806: l(' p_rule_id IN NUMBER,');
807: l(' p_party_search_rec IN party_search_rec_type,');
808: l(' p_party_site_list IN party_site_list,');
809: l(' p_contact_list IN contact_list,');

Line 830: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');

826: l('');
827: d(fnd_log.level_procedure,'find_parties(+)');
828: d(fnd_log.level_statement,'Rule ID','p_rule_id');
829: l(' -- Initialize return status and message stack');
830: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
831: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
832: l(' FND_MSG_PUB.initialize;');
833: l(' END IF;');
834: l('');

Line 831: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');

827: d(fnd_log.level_procedure,'find_parties(+)');
828: d(fnd_log.level_statement,'Rule ID','p_rule_id');
829: l(' -- Initialize return status and message stack');
830: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
831: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
832: l(' FND_MSG_PUB.initialize;');
833: l(' END IF;');
834: l('');
835: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');

Line 842: l(' RAISE FND_API.G_EXC_ERROR;');

838: l('');
839: l(' -- No MATCH RULE FOUND');
840: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
841: l(' FND_MSG_PUB.ADD;');
842: l(' RAISE FND_API.G_EXC_ERROR;');
843: l(' END IF;');
844:
845: l(' OPEN c_match_rule;');
846: l(' FETCH c_match_rule INTO l_cmp_flag;');

Line 850: l(' RAISE FND_API.G_EXC_ERROR;');

846: l(' FETCH c_match_rule INTO l_cmp_flag;');
847: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
848: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
849: l(' FND_MSG_PUB.ADD;');
850: l(' RAISE FND_API.G_EXC_ERROR;');
851: l(' END IF;');
852:
853: FIRST := TRUE;
854: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME

Line 869: l(' RAISE FND_API.G_EXC_ERROR;');

865: END IF;
866: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
867: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
868: l(' FND_MSG_PUB.ADD;');
869: l(' RAISE FND_API.G_EXC_ERROR;');
870: l(' END IF;');
871:
872: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_parties(');
873: l(' p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,');

Line 891: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

887:
888:
889: -- Generate find_persons code. Public signature.
890: l(' PROCEDURE find_persons (');
891: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
892: l(' p_rule_id IN NUMBER,');
893: l(' p_party_search_rec IN party_search_rec_type,');
894: l(' p_party_site_list IN party_site_list,');
895: l(' p_contact_list IN contact_list,');

Line 916: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');

912: l('');
913: d(fnd_log.level_procedure,'find_persons(+)');
914: d(fnd_log.level_statement,'Rule ID','p_rule_id');
915: l(' -- Initialize return status and message stack');
916: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
917: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
918: l(' FND_MSG_PUB.initialize;');
919: l(' END IF;');
920: l('');

Line 917: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');

913: d(fnd_log.level_procedure,'find_persons(+)');
914: d(fnd_log.level_statement,'Rule ID','p_rule_id');
915: l(' -- Initialize return status and message stack');
916: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
917: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
918: l(' FND_MSG_PUB.initialize;');
919: l(' END IF;');
920: l('');
921: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');

Line 928: l(' RAISE FND_API.G_EXC_ERROR;');

924: l('');
925: l(' -- No MATCH RULE FOUND');
926: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
927: l(' FND_MSG_PUB.ADD;');
928: l(' RAISE FND_API.G_EXC_ERROR;');
929: l(' END IF;');
930:
931: l(' OPEN c_match_rule;');
932: l(' FETCH c_match_rule INTO l_cmp_flag;');

Line 936: l(' RAISE FND_API.G_EXC_ERROR;');

932: l(' FETCH c_match_rule INTO l_cmp_flag;');
933: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
934: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
935: l(' FND_MSG_PUB.ADD;');
936: l(' RAISE FND_API.G_EXC_ERROR;');
937: l(' END IF;');
938: ---Bug:5261867, additional parameter null in place of p_search_merged
939: l_sql := 'declare x number; y number; begin HZ_MATCH_RULE_RULEID.find_persons(-1,'||
940: 'HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,'||

Line 961: l(' RAISE FND_API.G_EXC_ERROR;');

957: IF check_proc(RULE.MATCH_RULE_ID) THEN
958: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
959: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
960: l(' FND_MSG_PUB.ADD;');
961: l(' RAISE FND_API.G_EXC_ERROR;');
962: l(' END IF;');
963: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_persons(');
964: l(' p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,');
965: l(' p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,''N'',x_search_ctx_id,x_num_matches);');

Line 969: l(' RAISE FND_API.G_EXC_ERROR;');

965: l(' p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,''N'',x_search_ctx_id,x_num_matches);');
966: ELSE
967: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
968: l(' FND_MSG_PUB.ADD;');
969: l(' RAISE FND_API.G_EXC_ERROR;');
970: END IF;
971:
972: END LOOP;
973: l(' END IF;');

Line 982: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

978:
979:
980: -- Generate find_persons code. Public signature.
981: l(' PROCEDURE find_persons (');
982: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
983: l(' p_rule_id IN NUMBER,');
984: l(' p_party_search_rec IN party_search_rec_type,');
985: l(' p_party_site_list IN party_site_list,');
986: l(' p_contact_list IN contact_list,');

Line 1006: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

1002: l('');
1003:
1004: -- Generate find_party_details code. Public signature.
1005: l(' PROCEDURE find_party_details (');
1006: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
1007: l(' p_rule_id IN NUMBER,');
1008: l(' p_party_search_rec IN party_search_rec_type,');
1009: l(' p_party_site_list IN party_site_list,');
1010: l(' p_contact_list IN contact_list,');

Line 1036: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');

1032: dc(fnd_log.level_statement,'Rule ID','p_rule_id');
1033: de(' ');
1034: l('');
1035: l(' -- Initialize return status and message stack');
1036: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1037: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1038: l(' FND_MSG_PUB.initialize;');
1039: l(' END IF;');
1040: l('');

Line 1037: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');

1033: de(' ');
1034: l('');
1035: l(' -- Initialize return status and message stack');
1036: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1037: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1038: l(' FND_MSG_PUB.initialize;');
1039: l(' END IF;');
1040: l('');
1041: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');

Line 1048: l(' RAISE FND_API.G_EXC_ERROR;');

1044: l('');
1045: l(' -- No MATCH RULE FOUND');
1046: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1047: l(' FND_MSG_PUB.ADD;');
1048: l(' RAISE FND_API.G_EXC_ERROR;');
1049: l(' END IF;');
1050:
1051: l(' OPEN c_match_rule;');
1052: l(' FETCH c_match_rule INTO l_cmp_flag;');

Line 1056: l(' RAISE FND_API.G_EXC_ERROR;');

1052: l(' FETCH c_match_rule INTO l_cmp_flag;');
1053: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1054: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1055: l(' FND_MSG_PUB.ADD;');
1056: l(' RAISE FND_API.G_EXC_ERROR;');
1057: l(' END IF;');
1058:
1059: FIRST := TRUE;
1060: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME

Line 1075: l(' RAISE FND_API.G_EXC_ERROR;');

1071: END IF;
1072: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1073: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1074: l(' FND_MSG_PUB.ADD;');
1075: l(' RAISE FND_API.G_EXC_ERROR;');
1076: l(' END IF;');
1077:
1078: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_party_details(');
1079: l(' p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,');

Line 1088: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

1084: gen_exception_block;
1085: l(' END;');
1086: l('');
1087: l(' PROCEDURE find_duplicate_parties (');
1088: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
1089: l(' p_rule_id IN NUMBER,');
1090: l(' p_party_id IN NUMBER,');
1091: l(' p_restrict_sql IN VARCHAR2,');
1092: l(' p_match_type IN VARCHAR2,');

Line 1115: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');

1111: d(fnd_log.level_statement,'Rule ID','p_rule_id');
1112:
1113: l('');
1114: l(' -- Initialize return status and message stack');
1115: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1116: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1117: l(' FND_MSG_PUB.initialize;');
1118: l(' END IF;');
1119: l('');

Line 1116: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');

1112:
1113: l('');
1114: l(' -- Initialize return status and message stack');
1115: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1116: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1117: l(' FND_MSG_PUB.initialize;');
1118: l(' END IF;');
1119: l('');
1120: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');

Line 1127: l(' RAISE FND_API.G_EXC_ERROR;');

1123: l('');
1124: l(' -- No MATCH RULE FOUND');
1125: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1126: l(' FND_MSG_PUB.ADD;');
1127: l(' RAISE FND_API.G_EXC_ERROR;');
1128: l(' END IF;');
1129:
1130: l(' IF g_last_rule<>p_rule_id OR NOT g_last_rule_valid THEN');
1131: l(' OPEN c_match_rule;');

Line 1136: l(' RAISE FND_API.G_EXC_ERROR;');

1132: l(' FETCH c_match_rule INTO l_cmp_flag;');
1133: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1134: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1135: l(' FND_MSG_PUB.ADD;');
1136: l(' RAISE FND_API.G_EXC_ERROR;');
1137: l(' END IF;');
1138: l(' g_last_rule := p_rule_id;');
1139: l(' g_last_rule_valid := TRUE;');
1140: l(' END IF;');

Line 1158: l(' RAISE FND_API.G_EXC_ERROR;');

1154: END IF;
1155: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1156: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1157: l(' FND_MSG_PUB.ADD;');
1158: l(' RAISE FND_API.G_EXC_ERROR;');
1159: l(' END IF;');
1160:
1161: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_duplicate_parties(');
1162: l(' p_rule_id,p_party_id,');

Line 1174: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

1170: l('');
1171:
1172: l('');
1173: l(' PROCEDURE find_duplicate_party_sites (');
1174: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
1175: l(' p_rule_id IN NUMBER,');
1176: l(' p_party_site_id IN NUMBER,');
1177: l(' p_party_id IN NUMBER,');
1178: l(' p_restrict_sql IN VARCHAR2,');

Line 1199: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');

1195: d(fnd_log.level_statement,'Rule ID','p_rule_id');
1196:
1197: l('');
1198: l(' -- Initialize return status and message stack');
1199: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1200: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1201: l(' FND_MSG_PUB.initialize;');
1202: l(' END IF;');
1203: l('');

Line 1200: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');

1196:
1197: l('');
1198: l(' -- Initialize return status and message stack');
1199: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1200: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1201: l(' FND_MSG_PUB.initialize;');
1202: l(' END IF;');
1203: l('');
1204: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');

Line 1211: l(' RAISE FND_API.G_EXC_ERROR;');

1207: l('');
1208: l(' -- No MATCH RULE FOUND');
1209: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1210: l(' FND_MSG_PUB.ADD;');
1211: l(' RAISE FND_API.G_EXC_ERROR;');
1212: l(' END IF;');
1213:
1214: l(' OPEN c_match_rule;');
1215: l(' FETCH c_match_rule INTO l_cmp_flag;');

Line 1219: l(' RAISE FND_API.G_EXC_ERROR;');

1215: l(' FETCH c_match_rule INTO l_cmp_flag;');
1216: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1217: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1218: l(' FND_MSG_PUB.ADD;');
1219: l(' RAISE FND_API.G_EXC_ERROR;');
1220: l(' END IF;');
1221:
1222: FIRST := TRUE;
1223: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME

Line 1238: l(' RAISE FND_API.G_EXC_ERROR;');

1234: END IF;
1235: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1236: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1237: l(' FND_MSG_PUB.ADD;');
1238: l(' RAISE FND_API.G_EXC_ERROR;');
1239: l(' END IF;');
1240:
1241: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_duplicate_party_sites(');
1242: l(' p_rule_id,p_party_site_id,p_party_id,');

Line 1253: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

1249: l(' END;');
1250:
1251: l('');
1252: l(' PROCEDURE find_duplicate_contacts (');
1253: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
1254: l(' p_rule_id IN NUMBER,');
1255: l(' p_org_contact_id IN NUMBER,');
1256: l(' p_party_id IN NUMBER,');
1257: l(' p_restrict_sql IN VARCHAR2,');

Line 1278: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');

1274: d(fnd_log.level_statement,'Rule ID','p_rule_id');
1275:
1276: l('');
1277: l(' -- Initialize return status and message stack');
1278: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1279: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1280: l(' FND_MSG_PUB.initialize;');
1281: l(' END IF;');
1282: l('');

Line 1279: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');

1275:
1276: l('');
1277: l(' -- Initialize return status and message stack');
1278: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1279: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1280: l(' FND_MSG_PUB.initialize;');
1281: l(' END IF;');
1282: l('');
1283: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');

Line 1290: l(' RAISE FND_API.G_EXC_ERROR;');

1286: l('');
1287: l(' -- No MATCH RULE FOUND');
1288: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1289: l(' FND_MSG_PUB.ADD;');
1290: l(' RAISE FND_API.G_EXC_ERROR;');
1291: l(' END IF;');
1292:
1293: l(' OPEN c_match_rule;');
1294: l(' FETCH c_match_rule INTO l_cmp_flag;');

Line 1298: l(' RAISE FND_API.G_EXC_ERROR;');

1294: l(' FETCH c_match_rule INTO l_cmp_flag;');
1295: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1296: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1297: l(' FND_MSG_PUB.ADD;');
1298: l(' RAISE FND_API.G_EXC_ERROR;');
1299: l(' END IF;');
1300:
1301: FIRST := TRUE;
1302: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME

Line 1317: l(' RAISE FND_API.G_EXC_ERROR;');

1313: END IF;
1314: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1315: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1316: l(' FND_MSG_PUB.ADD;');
1317: l(' RAISE FND_API.G_EXC_ERROR;');
1318: l(' END IF;');
1319:
1320: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_duplicate_contacts(');
1321: l(' p_rule_id,p_org_contact_id,p_party_id,');

Line 1332: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

1328: l(' END;');
1329:
1330: l('');
1331: l(' PROCEDURE find_duplicate_contact_points (');
1332: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
1333: l(' p_rule_id IN NUMBER,');
1334: l(' p_contact_point_id IN NUMBER,');
1335: l(' p_party_id IN NUMBER,');
1336: l(' p_restrict_sql IN VARCHAR2,');

Line 1357: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');

1353: d(fnd_log.level_statement,'Rule ID','p_rule_id');
1354:
1355: l('');
1356: l(' -- Initialize return status and message stack');
1357: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1358: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1359: l(' FND_MSG_PUB.initialize;');
1360: l(' END IF;');
1361: l('');

Line 1358: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');

1354:
1355: l('');
1356: l(' -- Initialize return status and message stack');
1357: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1358: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1359: l(' FND_MSG_PUB.initialize;');
1360: l(' END IF;');
1361: l('');
1362: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');

Line 1369: l(' RAISE FND_API.G_EXC_ERROR;');

1365: l('');
1366: l(' -- No MATCH RULE FOUND');
1367: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1368: l(' FND_MSG_PUB.ADD;');
1369: l(' RAISE FND_API.G_EXC_ERROR;');
1370: l(' END IF;');
1371:
1372: l(' OPEN c_match_rule;');
1373: l(' FETCH c_match_rule INTO l_cmp_flag;');

Line 1377: l(' RAISE FND_API.G_EXC_ERROR;');

1373: l(' FETCH c_match_rule INTO l_cmp_flag;');
1374: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1375: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1376: l(' FND_MSG_PUB.ADD;');
1377: l(' RAISE FND_API.G_EXC_ERROR;');
1378: l(' END IF;');
1379:
1380: FIRST := TRUE;
1381: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME

Line 1396: l(' RAISE FND_API.G_EXC_ERROR;');

1392: END IF;
1393: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1394: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1395: l(' FND_MSG_PUB.ADD;');
1396: l(' RAISE FND_API.G_EXC_ERROR;');
1397: l(' END IF;');
1398:
1399: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_duplicate_contact_points(');
1400: l(' p_rule_id,p_contact_point_id,p_party_id,');

Line 1411: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

1407: l(' END;');
1408: l('');
1409: l('');
1410: l(' PROCEDURE find_parties_dynamic (');
1411: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
1412: l(' p_rule_id IN NUMBER,');
1413: l(' p_attrib_id1 IN NUMBER,');
1414: l(' p_attrib_id2 IN NUMBER,');
1415: l(' p_attrib_id3 IN NUMBER,');

Line 1475: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');

1471: d(fnd_log.level_statement,'Rule ID','p_rule_id');
1472:
1473: l('');
1474: l(' -- Initialize return status and message stack');
1475: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1476: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1477: l(' FND_MSG_PUB.initialize;');
1478: l(' END IF;');
1479: l('');

Line 1476: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');

1472:
1473: l('');
1474: l(' -- Initialize return status and message stack');
1475: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1476: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1477: l(' FND_MSG_PUB.initialize;');
1478: l(' END IF;');
1479: l('');
1480: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');

Line 1487: l(' RAISE FND_API.G_EXC_ERROR;');

1483: l('');
1484: l(' -- No MATCH RULE FOUND');
1485: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1486: l(' FND_MSG_PUB.ADD;');
1487: l(' RAISE FND_API.G_EXC_ERROR;');
1488: l(' END IF;');
1489:
1490: l(' OPEN c_match_rule;');
1491: l(' FETCH c_match_rule INTO l_cmp_flag;');

Line 1495: l(' RAISE FND_API.G_EXC_ERROR;');

1491: l(' FETCH c_match_rule INTO l_cmp_flag;');
1492: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1493: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1494: l(' FND_MSG_PUB.ADD;');
1495: l(' RAISE FND_API.G_EXC_ERROR;');
1496: l(' END IF;');
1497:
1498: FIRST := TRUE;
1499: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME

Line 1514: l(' RAISE FND_API.G_EXC_ERROR;');

1510: END IF;
1511: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1512: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1513: l(' FND_MSG_PUB.ADD;');
1514: l(' RAISE FND_API.G_EXC_ERROR;');
1515: l(' END IF;');
1516:
1517: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_parties_dynamic(');
1518: l(' p_rule_id,');

Line 1536: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

1532: gen_exception_block;
1533: l(' END;');
1534: l('');
1535: l(' PROCEDURE call_api_dynamic (');
1536: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
1537: l(' p_rule_id IN NUMBER,');
1538: l(' p_attrib_id1 IN NUMBER,');
1539: l(' p_attrib_id2 IN NUMBER,');
1540: l(' p_attrib_id3 IN NUMBER,');

Line 1602: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');

1598: d(fnd_log.level_statement,'Rule ID','p_rule_id');
1599:
1600: l('');
1601: l(' -- Initialize return status and message stack');
1602: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1603: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1604: l(' FND_MSG_PUB.initialize;');
1605: l(' END IF;');
1606: l('');

Line 1603: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');

1599:
1600: l('');
1601: l(' -- Initialize return status and message stack');
1602: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1603: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1604: l(' FND_MSG_PUB.initialize;');
1605: l(' END IF;');
1606: l('');
1607: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');

Line 1614: l(' RAISE FND_API.G_EXC_ERROR;');

1610: l('');
1611: l(' -- No MATCH RULE FOUND');
1612: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1613: l(' FND_MSG_PUB.ADD;');
1614: l(' RAISE FND_API.G_EXC_ERROR;');
1615: l(' END IF;');
1616:
1617: l(' OPEN c_match_rule;');
1618: l(' FETCH c_match_rule INTO l_cmp_flag;');

Line 1622: l(' RAISE FND_API.G_EXC_ERROR;');

1618: l(' FETCH c_match_rule INTO l_cmp_flag;');
1619: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1620: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1621: l(' FND_MSG_PUB.ADD;');
1622: l(' RAISE FND_API.G_EXC_ERROR;');
1623: l(' END IF;');
1624:
1625: l_sql := 'declare x number; y number; begin HZ_MATCH_RULE_RULEID.call_api_dynamic(null,null,'||
1626: 'null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'||

Line 1649: l(' RAISE FND_API.G_EXC_ERROR;');

1645:
1646: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1647: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1648: l(' FND_MSG_PUB.ADD;');
1649: l(' RAISE FND_API.G_EXC_ERROR;');
1650: l(' END IF;');
1651:
1652: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.call_api_dynamic(');
1653: l(' p_rule_id,');

Line 1666: l(' RAISE FND_API.G_EXC_ERROR;');

1662: l(' p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);');
1663: ELSE
1664: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1665: l(' FND_MSG_PUB.ADD;');
1666: l(' RAISE FND_API.G_EXC_ERROR;');
1667: END IF;
1668:
1669: END LOOP;
1670: l(' END IF;');

Line 1680: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

1676: gen_call_api_dynamic_names;
1677:
1678: -- Generate get_matching_party_sites code
1679: l('PROCEDURE get_matching_party_sites (');
1680: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
1681: l(' p_rule_id IN NUMBER,');
1682: l(' p_party_id IN NUMBER,');
1683: l(' p_party_site_list IN PARTY_SITE_LIST,');
1684: l(' p_contact_point_list IN CONTACT_POINT_LIST,');

Line 1706: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

1702:
1703: l(' END;');
1704:
1705: l('PROCEDURE get_matching_party_sites (');
1706: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
1707: l(' p_rule_id IN NUMBER,');
1708: l(' p_party_id IN NUMBER,');
1709: l(' p_party_site_list IN PARTY_SITE_LIST,');
1710: l(' p_contact_point_list IN CONTACT_POINT_LIST,');

Line 1733: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');

1729:
1730:
1731: l('');
1732: l(' -- Initialize return status and message stack');
1733: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1734: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1735: l(' FND_MSG_PUB.initialize;');
1736: l(' END IF;');
1737: l('');

Line 1734: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');

1730:
1731: l('');
1732: l(' -- Initialize return status and message stack');
1733: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1734: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1735: l(' FND_MSG_PUB.initialize;');
1736: l(' END IF;');
1737: l('');
1738: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');

Line 1742: l(' RAISE FND_API.G_EXC_ERROR;');

1738: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1739: l(' -- No MATCH RULE FOUND');
1740: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1741: l(' FND_MSG_PUB.ADD;');
1742: l(' RAISE FND_API.G_EXC_ERROR;');
1743: l(' END IF;');
1744:
1745: l(' OPEN c_match_rule;');
1746: l(' FETCH c_match_rule INTO l_cmp_flag;');

Line 1750: l(' RAISE FND_API.G_EXC_ERROR;');

1746: l(' FETCH c_match_rule INTO l_cmp_flag;');
1747: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1748: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1749: l(' FND_MSG_PUB.ADD;');
1750: l(' RAISE FND_API.G_EXC_ERROR;');
1751: l(' END IF;');
1752:
1753: FIRST := TRUE;
1754: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME

Line 1769: l(' RAISE FND_API.G_EXC_ERROR;');

1765: END IF;
1766: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1767: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1768: l(' FND_MSG_PUB.ADD;');
1769: l(' RAISE FND_API.G_EXC_ERROR;');
1770: l(' END IF;');
1771: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.get_matching_party_sites(');
1772: l(' p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,');
1773: l(' p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);');

Line 1783: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

1779: l(' END;');
1780: l('');
1781: -- Generate get_matching_contacts code
1782: l('PROCEDURE get_matching_contacts (');
1783: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
1784: l(' p_rule_id IN NUMBER,');
1785: l(' p_party_id IN NUMBER,');
1786: l(' p_contact_list IN CONTACT_LIST,');
1787: l(' p_contact_point_list IN CONTACT_POINT_LIST,');

Line 1809: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

1805:
1806: l(' END;');
1807:
1808: l('PROCEDURE get_matching_contacts (');
1809: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
1810: l(' p_rule_id IN NUMBER,');
1811: l(' p_party_id IN NUMBER,');
1812: l(' p_contact_list IN CONTACT_LIST,');
1813: l(' p_contact_point_list IN CONTACT_POINT_LIST,');

Line 1836: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');

1832:
1833:
1834: l('');
1835: l(' -- Initialize return status and message stack');
1836: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1837: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1838: l(' FND_MSG_PUB.initialize;');
1839: l(' END IF;');
1840: l('');

Line 1837: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');

1833:
1834: l('');
1835: l(' -- Initialize return status and message stack');
1836: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1837: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1838: l(' FND_MSG_PUB.initialize;');
1839: l(' END IF;');
1840: l('');
1841: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');

Line 1845: l(' RAISE FND_API.G_EXC_ERROR;');

1841: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1842: l(' -- No MATCH RULE FOUND');
1843: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1844: l(' FND_MSG_PUB.ADD;');
1845: l(' RAISE FND_API.G_EXC_ERROR;');
1846: l(' END IF;');
1847:
1848: l(' OPEN c_match_rule;');
1849: l(' FETCH c_match_rule INTO l_cmp_flag;');

Line 1853: l(' RAISE FND_API.G_EXC_ERROR;');

1849: l(' FETCH c_match_rule INTO l_cmp_flag;');
1850: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1851: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1852: l(' FND_MSG_PUB.ADD;');
1853: l(' RAISE FND_API.G_EXC_ERROR;');
1854: l(' END IF;');
1855:
1856: FIRST := TRUE;
1857: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME

Line 1872: l(' RAISE FND_API.G_EXC_ERROR;');

1868: END IF;
1869: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1870: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1871: l(' FND_MSG_PUB.ADD;');
1872: l(' RAISE FND_API.G_EXC_ERROR;');
1873: l(' END IF;');
1874: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.get_matching_contacts(');
1875: l(' p_rule_id, p_party_id,p_contact_list, p_contact_point_list,');
1876: l(' p_restrict_sql, p_match_type,null,x_search_ctx_id,x_num_matches);');

Line 1886: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

1882: l(' END;');
1883: l('');
1884: -- Generate get_matching_contact_points code
1885: l('PROCEDURE get_matching_contact_points (');
1886: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
1887: l(' p_rule_id IN NUMBER,');
1888: l(' p_party_id IN NUMBER,');
1889: l(' p_contact_point_list IN CONTACT_POINT_LIST,');
1890: l(' x_search_ctx_id OUT NUMBER,');

Line 1910: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

1906: d(fnd_log.level_procedure,'get_matching_contact_points-1(-)');
1907:
1908: l(' END;');
1909: l('PROCEDURE get_matching_contact_points (');
1910: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
1911: l(' p_rule_id IN NUMBER,');
1912: l(' p_party_id IN NUMBER,');
1913: l(' p_contact_point_list IN CONTACT_POINT_LIST,');
1914: l(' p_restrict_sql IN VARCHAR2,');

Line 1935: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');

1931: d(fnd_log.level_statement,'Rule ID','p_rule_id');
1932:
1933: l('');
1934: l(' -- Initialize return status and message stack');
1935: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1936: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1937: l(' FND_MSG_PUB.initialize;');
1938: l(' END IF;');
1939: l('');

Line 1936: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');

1932:
1933: l('');
1934: l(' -- Initialize return status and message stack');
1935: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1936: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1937: l(' FND_MSG_PUB.initialize;');
1938: l(' END IF;');
1939: l('');
1940: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');

Line 1944: l(' RAISE FND_API.G_EXC_ERROR;');

1940: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1941: l(' -- No MATCH RULE FOUND');
1942: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1943: l(' FND_MSG_PUB.ADD;');
1944: l(' RAISE FND_API.G_EXC_ERROR;');
1945: l(' END IF;');
1946:
1947: l(' OPEN c_match_rule;');
1948: l(' FETCH c_match_rule INTO l_cmp_flag;');

Line 1952: l(' RAISE FND_API.G_EXC_ERROR;');

1948: l(' FETCH c_match_rule INTO l_cmp_flag;');
1949: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1950: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1951: l(' FND_MSG_PUB.ADD;');
1952: l(' RAISE FND_API.G_EXC_ERROR;');
1953: l(' END IF;');
1954:
1955: FIRST := TRUE;
1956: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME

Line 1971: l(' RAISE FND_API.G_EXC_ERROR;');

1967: END IF;
1968: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1969: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1970: l(' FND_MSG_PUB.ADD;');
1971: l(' RAISE FND_API.G_EXC_ERROR;');
1972: l(' END IF;');
1973:
1974: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.get_matching_contact_points(');
1975: l(' p_rule_id, p_party_id, p_contact_point_list,');

Line 1986: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

1982: l(' END;');
1983: l('');
1984: -- Generate get_party_score_details code
1985: l('PROCEDURE get_party_score_details (');
1986: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
1987: l(' p_rule_id IN NUMBER,');
1988: l(' p_party_id IN NUMBER,');
1989: l(' p_search_ctx_id IN NUMBER,');
1990: l(' p_party_search_rec IN party_search_rec_type,');

Line 2014: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

2010:
2011: l(' END;');
2012:
2013: l('PROCEDURE get_score_details (');
2014: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
2015: l(' p_rule_id IN NUMBER,');
2016: l(' p_party_id IN NUMBER,');
2017: l(' p_party_search_rec IN party_search_rec_type,');
2018: l(' p_party_site_list IN party_site_list,');

Line 2040: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');

2036:
2037:
2038: l('');
2039: l(' -- Initialize return status and message stack');
2040: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
2041: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
2042: l(' FND_MSG_PUB.initialize;');
2043: l(' END IF;');
2044: l('');

Line 2041: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');

2037:
2038: l('');
2039: l(' -- Initialize return status and message stack');
2040: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
2041: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
2042: l(' FND_MSG_PUB.initialize;');
2043: l(' END IF;');
2044: l('');
2045: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');

Line 2049: l(' RAISE FND_API.G_EXC_ERROR;');

2045: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
2046: l(' -- No MATCH RULE FOUND');
2047: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
2048: l(' FND_MSG_PUB.ADD;');
2049: l(' RAISE FND_API.G_EXC_ERROR;');
2050: l(' END IF;');
2051:
2052: l(' OPEN c_match_rule;');
2053: l(' FETCH c_match_rule INTO l_cmp_flag;');

Line 2057: l(' RAISE FND_API.G_EXC_ERROR;');

2053: l(' FETCH c_match_rule INTO l_cmp_flag;');
2054: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
2055: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
2056: l(' FND_MSG_PUB.ADD;');
2057: l(' RAISE FND_API.G_EXC_ERROR;');
2058: l(' END IF;');
2059:
2060: FIRST := TRUE;
2061: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME

Line 2076: l(' RAISE FND_API.G_EXC_ERROR;');

2072: END IF;
2073: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
2074: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
2075: l(' FND_MSG_PUB.ADD;');
2076: l(' RAISE FND_API.G_EXC_ERROR;');
2077: l(' END IF;');
2078: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.get_score_details(');
2079: l(' p_rule_id,');
2080: l(' p_party_id, p_party_search_rec,p_party_site_list,');

Line 2089: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

2085:
2086: gen_exception_block;
2087: l(' END;');
2088: l('PROCEDURE get_party_for_search (');
2089: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
2090: l(' p_rule_id IN NUMBER,');
2091: l(' p_party_id IN NUMBER,');
2092: l(' x_party_search_rec OUT NOCOPY party_search_rec_type,');
2093: l(' x_party_site_list OUT NOCOPY party_site_list,');

Line 2113: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');

2109: d(fnd_log.level_statement,'Rule ID','p_rule_id');
2110:
2111: l('');
2112: l(' -- Initialize return status and message stack');
2113: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
2114: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
2115: l(' FND_MSG_PUB.initialize;');
2116: l(' END IF;');
2117: l('');

Line 2114: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');

2110:
2111: l('');
2112: l(' -- Initialize return status and message stack');
2113: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
2114: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
2115: l(' FND_MSG_PUB.initialize;');
2116: l(' END IF;');
2117: l('');
2118: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');

Line 2122: l(' RAISE FND_API.G_EXC_ERROR;');

2118: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
2119: l(' -- No MATCH RULE FOUND');
2120: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
2121: l(' FND_MSG_PUB.ADD;');
2122: l(' RAISE FND_API.G_EXC_ERROR;');
2123: l(' END IF;');
2124:
2125: l(' OPEN c_match_rule;');
2126: l(' FETCH c_match_rule INTO l_cmp_flag;');

Line 2130: l(' RAISE FND_API.G_EXC_ERROR;');

2126: l(' FETCH c_match_rule INTO l_cmp_flag;');
2127: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
2128: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
2129: l(' FND_MSG_PUB.ADD;');
2130: l(' RAISE FND_API.G_EXC_ERROR;');
2131: l(' END IF;');
2132:
2133: FIRST := TRUE;
2134: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME

Line 2149: l(' RAISE FND_API.G_EXC_ERROR;');

2145: END IF;
2146: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
2147: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
2148: l(' FND_MSG_PUB.ADD;');
2149: l(' RAISE FND_API.G_EXC_ERROR;');
2150: l(' END IF;');
2151: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.get_party_for_search(');
2152: l(' p_party_id, x_party_search_rec,x_party_site_list,');
2153: l(' x_contact_list, x_contact_point_list);');

Line 2162: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

2158: gen_exception_block;
2159: l(' END;');
2160:
2161: l('PROCEDURE get_search_criteria (');
2162: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
2163: l(' p_rule_id IN NUMBER,');
2164: l(' p_party_id IN NUMBER,');
2165: l(' p_party_site_ids IN IDList,');
2166: l(' p_contact_ids IN IDList,');

Line 2188: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');

2184: d(fnd_log.level_statement,'Rule ID','p_rule_id');
2185:
2186: l('');
2187: l(' -- Initialize return status and message stack');
2188: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
2189: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
2190: l(' FND_MSG_PUB.initialize;');
2191: l(' END IF;');
2192: l('');

Line 2189: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');

2185:
2186: l('');
2187: l(' -- Initialize return status and message stack');
2188: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
2189: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
2190: l(' FND_MSG_PUB.initialize;');
2191: l(' END IF;');
2192: l('');
2193: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');

Line 2197: l(' RAISE FND_API.G_EXC_ERROR;');

2193: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
2194: l(' -- No MATCH RULE FOUND');
2195: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
2196: l(' FND_MSG_PUB.ADD;');
2197: l(' RAISE FND_API.G_EXC_ERROR;');
2198: l(' END IF;');
2199:
2200: l(' OPEN c_match_rule;');
2201: l(' FETCH c_match_rule INTO l_cmp_flag;');

Line 2205: l(' RAISE FND_API.G_EXC_ERROR;');

2201: l(' FETCH c_match_rule INTO l_cmp_flag;');
2202: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
2203: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
2204: l(' FND_MSG_PUB.ADD;');
2205: l(' RAISE FND_API.G_EXC_ERROR;');
2206: l(' END IF;');
2207:
2208: FIRST := TRUE;
2209: FOR RULE IN (SELECT MATCH_RULE_ID,RULE_NAME

Line 2224: l(' RAISE FND_API.G_EXC_ERROR;');

2220: END IF;
2221: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
2222: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
2223: l(' FND_MSG_PUB.ADD;');
2224: l(' RAISE FND_API.G_EXC_ERROR;');
2225: l(' END IF;');
2226: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.get_search_criteria(');
2227: l(' p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,');
2228: l(' x_contact_list, x_contact_point_list);');

Line 2820: l(' RAISE FND_API.G_EXC_ERROR;');

2816: l(' IF lengthb(l_contains_str) > 4000 THEN');
2817: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_SEARCH_CRIT_LARGE_ERROR'');');
2818: l(' FND_MESSAGE.SET_TOKEN(''ENTITY'','''||p_entity||''');');
2819: l(' FND_MSG_PUB.ADD;');
2820: l(' RAISE FND_API.G_EXC_ERROR;');
2821: l(' END IF;');
2822: l(' x_denorm_str := l_den_contains_str;');
2823: l(' RETURN l_contains_str;');
2824: l(' END;');

Line 3056: l(' RAISE FND_API.G_EXC_ERROR;');

3052: l(' when others then');
3053: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
3054: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
3055: l(' FND_MSG_PUB.ADD;');
3056: l(' RAISE FND_API.G_EXC_ERROR;');
3057: --Start Bug No: 3032742.
3058: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
3059: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
3060: l(' FND_MSG_PUB.ADD;');

Line 3061: l(' RAISE FND_API.G_EXC_ERROR;');

3057: --Start Bug No: 3032742.
3058: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
3059: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
3060: l(' FND_MSG_PUB.ADD;');
3061: l(' RAISE FND_API.G_EXC_ERROR;');
3062: --End Bug No : 3032742.
3063: l(' else ');
3064: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
3065: l(' end if;');

Line 3064: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

3060: l(' FND_MSG_PUB.ADD;');
3061: l(' RAISE FND_API.G_EXC_ERROR;');
3062: --End Bug No : 3032742.
3063: l(' else ');
3064: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
3065: l(' end if;');
3066: --bug 4959719 end
3067: l('END;');
3068:

Line 3306: l(' RAISE FND_API.G_EXC_ERROR;');

3302: l(' p_contact_list,');
3303: l(' p_contact_point_list) THEN');
3304: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_PRIMARY_COND'');');
3305: l(' FND_MSG_PUB.ADD;');
3306: l(' RAISE FND_API.G_EXC_ERROR;');
3307: l(' END IF;');
3308: IF l_max_score=1 THEN
3309: ldbg_s('In init_search calling util package set_no_score');
3310: l(' HZ_DQM_SEARCH_UTIL.set_no_score;');

Line 3555: l(' RAISE FND_API.G_EXC_ERROR;');

3551: l(' IF lengthb(l_party_contains_str) > 4000 THEN');
3552: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_SEARCH_CRIT_LARGE_ERROR'');');
3553: l(' FND_MESSAGE.SET_TOKEN(''ENTITY'',''PARTY'');');
3554: l(' FND_MSG_PUB.ADD;');
3555: l(' RAISE FND_API.G_EXC_ERROR;');
3556: l(' END IF;');
3557: l(' IF (p_match_str = '' AND '' OR p_party_max_score 3558: ldbg_s('party contains string returned by init_search is an AND between these strings ');
3559: ldbg_sv('l_party_contains_str = ', 'l_party_contains_str');

Line 3966: l(' RAISE FND_API.G_EXC_ERROR;');

3962: l(' when others then');
3963: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
3964: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
3965: l(' FND_MSG_PUB.ADD;');
3966: l(' RAISE FND_API.G_EXC_ERROR;');
3967: --Start Bug No: 3032742.
3968: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
3969: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
3970: l(' FND_MSG_PUB.ADD;');

Line 3971: l(' RAISE FND_API.G_EXC_ERROR;');

3967: --Start Bug No: 3032742.
3968: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
3969: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
3970: l(' FND_MSG_PUB.ADD;');
3971: l(' RAISE FND_API.G_EXC_ERROR;');
3972: --Bug: 3392837
3973: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
3974: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
3975: l(' FND_MSG_PUB.ADD;');

Line 3976: l(' RAISE FND_API.G_EXC_ERROR;');

3972: --Bug: 3392837
3973: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
3974: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
3975: l(' FND_MSG_PUB.ADD;');
3976: l(' RAISE FND_API.G_EXC_ERROR;');
3977: --End Bug No : 3032742.
3978: l(' else ');
3979: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
3980: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');

Line 3982: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

3978: l(' else ');
3979: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
3980: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
3981: l(' FND_MSG_PUB.ADD;');
3982: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
3983: l(' end if;');
3984: l(' END;');
3985: l('');
3986:

Line 4246: l(' RAISE FND_API.G_EXC_ERROR;');

4242: l(' when others then');
4243: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
4244: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
4245: l(' FND_MSG_PUB.ADD;');
4246: l(' RAISE FND_API.G_EXC_ERROR;');
4247: --Start Bug No: 3032742.
4248: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4249: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4250: l(' FND_MSG_PUB.ADD;');

Line 4251: l(' RAISE FND_API.G_EXC_ERROR;');

4247: --Start Bug No: 3032742.
4248: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4249: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4250: l(' FND_MSG_PUB.ADD;');
4251: l(' RAISE FND_API.G_EXC_ERROR;');
4252: --Bug: 3392837
4253: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4254: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4255: l(' FND_MSG_PUB.ADD;');

Line 4256: l(' RAISE FND_API.G_EXC_ERROR;');

4252: --Bug: 3392837
4253: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4254: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4255: l(' FND_MSG_PUB.ADD;');
4256: l(' RAISE FND_API.G_EXC_ERROR;');
4257: --End Bug No : 3032742.
4258: l(' else ');
4259: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4260: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');

Line 4262: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

4258: l(' else ');
4259: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4260: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4261: l(' FND_MSG_PUB.ADD;');
4262: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4263: l(' end if;');
4264: l(' END;');
4265: l('');
4266: l(' PROCEDURE open_contact_cursor(');

Line 4414: l(' RAISE FND_API.G_EXC_ERROR;');

4410: l(' when others then');
4411: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
4412: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
4413: l(' FND_MSG_PUB.ADD;');
4414: l(' RAISE FND_API.G_EXC_ERROR;');
4415: --Start Bug No: 3032742.
4416: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4417: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4418: l(' FND_MSG_PUB.ADD;');

Line 4419: l(' RAISE FND_API.G_EXC_ERROR;');

4415: --Start Bug No: 3032742.
4416: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4417: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4418: l(' FND_MSG_PUB.ADD;');
4419: l(' RAISE FND_API.G_EXC_ERROR;');
4420: --Bug: 3392837
4421: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4422: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4423: l(' FND_MSG_PUB.ADD;');

Line 4424: l(' RAISE FND_API.G_EXC_ERROR;');

4420: --Bug: 3392837
4421: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4422: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4423: l(' FND_MSG_PUB.ADD;');
4424: l(' RAISE FND_API.G_EXC_ERROR;');
4425: --End Bug No : 3032742.
4426: l(' else ');
4427: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4428: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');

Line 4430: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

4426: l(' else ');
4427: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4428: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4429: l(' FND_MSG_PUB.ADD;');
4430: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4431: l(' end if;');
4432: l(' END;');
4433: l('');
4434: l(' PROCEDURE open_contact_pt_cursor(');

Line 4726: l(' RAISE FND_API.G_EXC_ERROR;');

4722: l(' when others then');
4723: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
4724: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
4725: l(' FND_MSG_PUB.ADD;');
4726: l(' RAISE FND_API.G_EXC_ERROR;');
4727: --Start Bug No: 3032742.
4728: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4729: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4730: l(' FND_MSG_PUB.ADD;');

Line 4731: l(' RAISE FND_API.G_EXC_ERROR;');

4727: --Start Bug No: 3032742.
4728: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4729: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4730: l(' FND_MSG_PUB.ADD;');
4731: l(' RAISE FND_API.G_EXC_ERROR;');
4732: --Bug: 3392837
4733: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4734: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4735: l(' FND_MSG_PUB.ADD;');

Line 4736: l(' RAISE FND_API.G_EXC_ERROR;');

4732: --Bug: 3392837
4733: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4734: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4735: l(' FND_MSG_PUB.ADD;');
4736: l(' RAISE FND_API.G_EXC_ERROR;');
4737: --End Bug No : 3032742.
4738: l(' else ');
4739: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4740: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');

Line 4742: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

4738: l(' else ');
4739: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4740: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4741: l(' FND_MSG_PUB.ADD;');
4742: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4743: l(' end if;');
4744: l(' END;');
4745: l('');
4746:

Line 4989: l(' RAISE FND_API.G_EXC_ERROR;');

4985: l(' IF p_index>1 THEN');
4986: ldbg_s('In eval party level number of matches found exceeded threshold');
4987: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
4988: l(' FND_MSG_PUB.ADD;');
4989: l(' RAISE FND_API.G_EXC_ERROR;');
4990: l(' ELSE');
4991: l(' push_eval;');
4992: l(' RETURN;');
4993: l(' END IF;');

Line 5034: l(' RAISE FND_API.G_EXC_ERROR;');

5030: l(' IF p_index>1 THEN');
5031: ldbg_s('In eval party level estimated hits exceed threshold');
5032: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5033: l(' FND_MSG_PUB.ADD;');
5034: l(' RAISE FND_API.G_EXC_ERROR;');
5035: l(' ELSE');
5036: l(' push_eval;');
5037: l(' RETURN;');
5038: l(' END IF;');

Line 5096: l(' RAISE FND_API.G_EXC_ERROR;');

5092: l(' IF p_index>1 THEN');
5093: ldbg_s('In eval party site level number of matches found exceeded threshold');
5094: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5095: l(' FND_MSG_PUB.ADD;');
5096: l(' RAISE FND_API.G_EXC_ERROR;');
5097: l(' ELSE');
5098: l(' push_eval;');
5099: l(' RETURN;');
5100: l(' END IF;');

Line 5193: l(' RAISE FND_API.G_EXC_ERROR;');

5189: l(' IF p_index>1 THEN');
5190: ldbg_s('In eval contact level number of matches found exceeded threshold');
5191: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5192: l(' FND_MSG_PUB.ADD;');
5193: l(' RAISE FND_API.G_EXC_ERROR;');
5194: l(' ELSE');
5195: l(' push_eval;');
5196: l(' RETURN;');
5197: l(' END IF;');

Line 5290: l(' RAISE FND_API.G_EXC_ERROR;');

5286: l(' IF p_index>1 THEN');
5287: ldbg_s('In eval contact point level number of matches found exceeded threshold');
5288: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5289: l(' FND_MSG_PUB.ADD;');
5290: l(' RAISE FND_API.G_EXC_ERROR;');
5291: l(' ELSE');
5292: l(' push_eval;');
5293: l(' RETURN;');
5294: l(' END IF;');

Line 5495: l(' RAISE FND_API.G_EXC_ERROR; ');

5491: l(' ELSE ');
5492: ldbg_s('In do eval number of matches found exceeded threshold');
5493: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED''); ');
5494: l(' FND_MSG_PUB.ADD; ');
5495: l(' RAISE FND_API.G_EXC_ERROR; ');
5496: l(' END IF; ');
5497: --end of Bug No:5218095
5498: l(' ELSE');
5499: ldbg_s('In do eval number of matches found exceeded threshold');

Line 5502: l(' RAISE FND_API.G_EXC_ERROR;');

5498: l(' ELSE');
5499: ldbg_s('In do eval number of matches found exceeded threshold');
5500: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5501: l(' FND_MSG_PUB.ADD;');
5502: l(' RAISE FND_API.G_EXC_ERROR;');
5503: l(' END IF; ');
5504: l(' END IF;');
5505: --End of Bug No: 4407425
5506: /*l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');

Line 5509: l(' RAISE FND_API.G_EXC_ERROR;');

5505: --End of Bug No: 4407425
5506: /*l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
5507: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5508: l(' FND_MSG_PUB.ADD;');
5509: l(' RAISE FND_API.G_EXC_ERROR;');
5510: l(' END IF;');
5511: */
5512: l(' IF call_order(p_index) = ''PARTY'' AND l_party_contains_str IS NOT NULL THEN');
5513: l(' eval_party_level(l_party_contains_str,call_type(p_index), p_index);');

Line 5786: l(' WHEN FND_API.G_EXC_ERROR THEN');

5782: l('EXCEPTION');
5783:
5784: END IF; ---End of Code Change for Match Rule Set
5785:
5786: l(' WHEN FND_API.G_EXC_ERROR THEN');
5787: l(' RAISE FND_API.G_EXC_ERROR;');
5788: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
5789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
5790: l(' WHEN OTHERS THEN');

Line 5787: l(' RAISE FND_API.G_EXC_ERROR;');

5783:
5784: END IF; ---End of Code Change for Match Rule Set
5785:
5786: l(' WHEN FND_API.G_EXC_ERROR THEN');
5787: l(' RAISE FND_API.G_EXC_ERROR;');
5788: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
5789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
5790: l(' WHEN OTHERS THEN');
5791: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 5788: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

5784: END IF; ---End of Code Change for Match Rule Set
5785:
5786: l(' WHEN FND_API.G_EXC_ERROR THEN');
5787: l(' RAISE FND_API.G_EXC_ERROR;');
5788: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
5789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
5790: l(' WHEN OTHERS THEN');
5791: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
5792: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');

Line 5789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

5785:
5786: l(' WHEN FND_API.G_EXC_ERROR THEN');
5787: l(' RAISE FND_API.G_EXC_ERROR;');
5788: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
5789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
5790: l(' WHEN OTHERS THEN');
5791: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
5792: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
5793: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 5795: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

5791: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
5792: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
5793: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
5794: l(' FND_MSG_PUB.ADD;');
5795: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
5796: l('END find_parties;');
5797: l('');
5798:
5799: l('PROCEDURE find_persons (');

Line 5999: l(' RAISE FND_API.G_EXC_ERROR;');

5995: l(' IF p_index>1 THEN');
5996: ldbg_s('In eval party level number of matches found exceeded threshold');
5997: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5998: l(' FND_MSG_PUB.ADD;');
5999: l(' RAISE FND_API.G_EXC_ERROR;');
6000: l(' ELSE');
6001: l(' push_eval;');
6002: l(' RETURN;');
6003: l(' END IF;');

Line 6047: l(' RAISE FND_API.G_EXC_ERROR;');

6043: l(' IF p_index>1 THEN');
6044: ldbg_s('In eval party level number of matches found exceeded threshold');
6045: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6046: l(' FND_MSG_PUB.ADD;');
6047: l(' RAISE FND_API.G_EXC_ERROR;');
6048: l(' ELSE');
6049: l(' push_eval;');
6050: l(' RETURN;');
6051: l(' END IF;');

Line 6084: l(' RAISE FND_API.G_EXC_ERROR;');

6080: l(' when others then');
6081: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
6082: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
6083: l(' FND_MSG_PUB.ADD;');
6084: l(' RAISE FND_API.G_EXC_ERROR;');
6085: --Start Bug No: 3032742.
6086: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
6087: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
6088: l(' FND_MSG_PUB.ADD;');

Line 6089: l(' RAISE FND_API.G_EXC_ERROR;');

6085: --Start Bug No: 3032742.
6086: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
6087: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
6088: l(' FND_MSG_PUB.ADD;');
6089: l(' RAISE FND_API.G_EXC_ERROR;');
6090: --End Bug No : 3032742.
6091: l(' else ');
6092: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6093: l(' end if;');

Line 6092: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

6088: l(' FND_MSG_PUB.ADD;');
6089: l(' RAISE FND_API.G_EXC_ERROR;');
6090: --End Bug No : 3032742.
6091: l(' else ');
6092: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6093: l(' end if;');
6094: --bug 4959719 end
6095: l(' END;');
6096:

Line 6166: l(' RAISE FND_API.G_EXC_ERROR;');

6162: l(' IF p_index>1 THEN');
6163: ldbg_s('In eval party site level number of matches found exceeded threshold');
6164: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6165: l(' FND_MSG_PUB.ADD;');
6166: l(' RAISE FND_API.G_EXC_ERROR;');
6167: l(' ELSE');
6168: l(' push_eval;');
6169: l(' RETURN;');
6170: l(' END IF;');

Line 6388: l(' RAISE FND_API.G_EXC_ERROR;');

6384: l(' IF p_index>1 THEN');
6385: ldbg_s('In eval contact point level number of matches found exceeded threshold');
6386: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6387: l(' FND_MSG_PUB.ADD;');
6388: l(' RAISE FND_API.G_EXC_ERROR;');
6389: l(' ELSE');
6390: l(' push_eval;');
6391: l(' RETURN;');
6392: l(' END IF;');

Line 6504: l(' RAISE FND_API.G_EXC_ERROR; ');

6500: l(' ELSE ');
6501: ldbg_s('In do eval number of matches found exceeded threshold');
6502: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED''); ');
6503: l(' FND_MSG_PUB.ADD; ');
6504: l(' RAISE FND_API.G_EXC_ERROR; ');
6505: l(' END IF; ');
6506: --end of Bug No:5218095
6507: l(' ELSE');
6508: ldbg_s('In do eval number of matches found exceeded threshold');

Line 6511: l(' RAISE FND_API.G_EXC_ERROR;');

6507: l(' ELSE');
6508: ldbg_s('In do eval number of matches found exceeded threshold');
6509: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6510: l(' FND_MSG_PUB.ADD;');
6511: l(' RAISE FND_API.G_EXC_ERROR;');
6512: l(' END IF; ');
6513: l(' END IF;');
6514: --End of Bug No: 4407425
6515: /*l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');

Line 6518: l(' RAISE FND_API.G_EXC_ERROR;');

6514: --End of Bug No: 4407425
6515: /*l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
6516: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6517: l(' FND_MSG_PUB.ADD;');
6518: l(' RAISE FND_API.G_EXC_ERROR;');
6519: l(' END IF;');
6520: */
6521: l(' IF call_order(p_index) = ''PARTY'' AND l_party_contains_str IS NOT NULL THEN');
6522: l(' eval_party_level(l_party_contains_str,call_type(p_index), p_index);');

Line 6680: l(' WHEN FND_API.G_EXC_ERROR THEN');

6676:
6677: l('EXCEPTION');
6678: l(' WHEN L_RETURN_IMM_EXC THEN');
6679: l(' RETURN;');
6680: l(' WHEN FND_API.G_EXC_ERROR THEN');
6681: l(' RAISE FND_API.G_EXC_ERROR;');
6682: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6683: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6684: l(' WHEN OTHERS THEN');

Line 6681: l(' RAISE FND_API.G_EXC_ERROR;');

6677: l('EXCEPTION');
6678: l(' WHEN L_RETURN_IMM_EXC THEN');
6679: l(' RETURN;');
6680: l(' WHEN FND_API.G_EXC_ERROR THEN');
6681: l(' RAISE FND_API.G_EXC_ERROR;');
6682: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6683: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6684: l(' WHEN OTHERS THEN');
6685: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 6682: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

6678: l(' WHEN L_RETURN_IMM_EXC THEN');
6679: l(' RETURN;');
6680: l(' WHEN FND_API.G_EXC_ERROR THEN');
6681: l(' RAISE FND_API.G_EXC_ERROR;');
6682: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6683: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6684: l(' WHEN OTHERS THEN');
6685: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6686: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');

Line 6683: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

6679: l(' RETURN;');
6680: l(' WHEN FND_API.G_EXC_ERROR THEN');
6681: l(' RAISE FND_API.G_EXC_ERROR;');
6682: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6683: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6684: l(' WHEN OTHERS THEN');
6685: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6686: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6687: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 6689: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

6685: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6686: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6687: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6688: l(' FND_MSG_PUB.ADD;');
6689: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6690: l('END find_persons;');
6691: l('');
6692: ELSE ---Start of Code Change for Match Rule Set
6693: l('BEGIN');

Line 6703: l(' WHEN FND_API.G_EXC_ERROR THEN');

6699: de;
6700: pop_conditions(p_rule_id,'find_persons','p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,p_ins_details,x_search_ctx_id,x_num_matches','PARTY');
6701: d(fnd_log.level_procedure,'find_persons(-)');
6702: l('EXCEPTION');
6703: l(' WHEN FND_API.G_EXC_ERROR THEN');
6704: l(' RAISE FND_API.G_EXC_ERROR;');
6705: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6706: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6707: l(' WHEN OTHERS THEN');

Line 6704: l(' RAISE FND_API.G_EXC_ERROR;');

6700: pop_conditions(p_rule_id,'find_persons','p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,p_ins_details,x_search_ctx_id,x_num_matches','PARTY');
6701: d(fnd_log.level_procedure,'find_persons(-)');
6702: l('EXCEPTION');
6703: l(' WHEN FND_API.G_EXC_ERROR THEN');
6704: l(' RAISE FND_API.G_EXC_ERROR;');
6705: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6706: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6707: l(' WHEN OTHERS THEN');
6708: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 6705: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

6701: d(fnd_log.level_procedure,'find_persons(-)');
6702: l('EXCEPTION');
6703: l(' WHEN FND_API.G_EXC_ERROR THEN');
6704: l(' RAISE FND_API.G_EXC_ERROR;');
6705: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6706: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6707: l(' WHEN OTHERS THEN');
6708: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6709: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');

Line 6706: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

6702: l('EXCEPTION');
6703: l(' WHEN FND_API.G_EXC_ERROR THEN');
6704: l(' RAISE FND_API.G_EXC_ERROR;');
6705: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6706: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6707: l(' WHEN OTHERS THEN');
6708: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6709: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6710: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 6712: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

6708: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6709: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6710: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6711: l(' FND_MSG_PUB.ADD;');
6712: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6713: l('END find_persons;');
6714: END IF; ---End of Code Change for Match Rule Set
6715:
6716: l('PROCEDURE find_persons (');

Line 6777: l(' WHEN FND_API.G_EXC_ERROR THEN');

6773: d(fnd_log.level_procedure,'find_party_details(-)');
6774:
6775:
6776: l('EXCEPTION');
6777: l(' WHEN FND_API.G_EXC_ERROR THEN');
6778: l(' RAISE FND_API.G_EXC_ERROR;');
6779: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6780: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6781: l(' WHEN OTHERS THEN');

Line 6778: l(' RAISE FND_API.G_EXC_ERROR;');

6774:
6775:
6776: l('EXCEPTION');
6777: l(' WHEN FND_API.G_EXC_ERROR THEN');
6778: l(' RAISE FND_API.G_EXC_ERROR;');
6779: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6780: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6781: l(' WHEN OTHERS THEN');
6782: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 6779: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

6775:
6776: l('EXCEPTION');
6777: l(' WHEN FND_API.G_EXC_ERROR THEN');
6778: l(' RAISE FND_API.G_EXC_ERROR;');
6779: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6780: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6781: l(' WHEN OTHERS THEN');
6782: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6783: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');

Line 6780: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

6776: l('EXCEPTION');
6777: l(' WHEN FND_API.G_EXC_ERROR THEN');
6778: l(' RAISE FND_API.G_EXC_ERROR;');
6779: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6780: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6781: l(' WHEN OTHERS THEN');
6782: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6783: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
6784: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 6786: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

6782: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6783: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
6784: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6785: l(' FND_MSG_PUB.ADD;');
6786: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6787: l('END find_party_details;');
6788: l('');
6789: /************** find_duplicate_parties API ***************/
6790: l('PROCEDURE find_duplicate_parties (');

Line 6895: l(' WHEN FND_API.G_EXC_ERROR THEN');

6891: d(fnd_log.level_procedure,'find_duplicate_parties(-)');
6892:
6893:
6894: l('EXCEPTION');
6895: l(' WHEN FND_API.G_EXC_ERROR THEN');
6896: l(' RAISE FND_API.G_EXC_ERROR;');
6897: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6898: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6899: l(' WHEN OTHERS THEN');

Line 6896: l(' RAISE FND_API.G_EXC_ERROR;');

6892:
6893:
6894: l('EXCEPTION');
6895: l(' WHEN FND_API.G_EXC_ERROR THEN');
6896: l(' RAISE FND_API.G_EXC_ERROR;');
6897: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6898: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6899: l(' WHEN OTHERS THEN');
6900: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 6897: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

6893:
6894: l('EXCEPTION');
6895: l(' WHEN FND_API.G_EXC_ERROR THEN');
6896: l(' RAISE FND_API.G_EXC_ERROR;');
6897: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6898: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6899: l(' WHEN OTHERS THEN');
6900: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6901: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');

Line 6898: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

6894: l('EXCEPTION');
6895: l(' WHEN FND_API.G_EXC_ERROR THEN');
6896: l(' RAISE FND_API.G_EXC_ERROR;');
6897: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6898: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6899: l(' WHEN OTHERS THEN');
6900: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6901: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
6902: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 6904: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

6900: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6901: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
6902: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6903: l(' FND_MSG_PUB.ADD;');
6904: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6905: l('END find_duplicate_parties;');
6906:
6907:
6908: l('');

Line 6988: l(' WHEN FND_API.G_EXC_ERROR THEN');

6984: d(fnd_log.level_procedure,'find_duplicate_party_sites(-)');
6985:
6986:
6987: l('EXCEPTION');
6988: l(' WHEN FND_API.G_EXC_ERROR THEN');
6989: l(' RAISE FND_API.G_EXC_ERROR;');
6990: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6991: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6992: l(' WHEN OTHERS THEN');

Line 6989: l(' RAISE FND_API.G_EXC_ERROR;');

6985:
6986:
6987: l('EXCEPTION');
6988: l(' WHEN FND_API.G_EXC_ERROR THEN');
6989: l(' RAISE FND_API.G_EXC_ERROR;');
6990: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6991: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6992: l(' WHEN OTHERS THEN');
6993: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 6990: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

6986:
6987: l('EXCEPTION');
6988: l(' WHEN FND_API.G_EXC_ERROR THEN');
6989: l(' RAISE FND_API.G_EXC_ERROR;');
6990: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6991: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6992: l(' WHEN OTHERS THEN');
6993: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6994: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');

Line 6991: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

6987: l('EXCEPTION');
6988: l(' WHEN FND_API.G_EXC_ERROR THEN');
6989: l(' RAISE FND_API.G_EXC_ERROR;');
6990: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6991: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6992: l(' WHEN OTHERS THEN');
6993: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6994: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
6995: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 6997: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

6993: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6994: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
6995: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6996: l(' FND_MSG_PUB.ADD;');
6997: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6998: l('END find_duplicate_party_sites; ');
6999: l(' ');
7000:
7001: /************** find_duplicate_contacts API ***************/

Line 7084: l(' WHEN FND_API.G_EXC_ERROR THEN');

7080: d(fnd_log.level_procedure,'find_duplicate_contacts(-)');
7081:
7082:
7083: l('EXCEPTION');
7084: l(' WHEN FND_API.G_EXC_ERROR THEN');
7085: l(' RAISE FND_API.G_EXC_ERROR;');
7086: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7087: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7088: l(' WHEN OTHERS THEN');

Line 7085: l(' RAISE FND_API.G_EXC_ERROR;');

7081:
7082:
7083: l('EXCEPTION');
7084: l(' WHEN FND_API.G_EXC_ERROR THEN');
7085: l(' RAISE FND_API.G_EXC_ERROR;');
7086: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7087: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7088: l(' WHEN OTHERS THEN');
7089: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 7086: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

7082:
7083: l('EXCEPTION');
7084: l(' WHEN FND_API.G_EXC_ERROR THEN');
7085: l(' RAISE FND_API.G_EXC_ERROR;');
7086: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7087: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7088: l(' WHEN OTHERS THEN');
7089: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7090: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');

Line 7087: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

7083: l('EXCEPTION');
7084: l(' WHEN FND_API.G_EXC_ERROR THEN');
7085: l(' RAISE FND_API.G_EXC_ERROR;');
7086: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7087: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7088: l(' WHEN OTHERS THEN');
7089: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7090: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
7091: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 7093: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

7089: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7090: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
7091: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7092: l(' FND_MSG_PUB.ADD;');
7093: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7094: l('END find_duplicate_contacts; ');
7095: l('');
7096: /************** find_duplicate_contact_points API ***************/
7097: l('PROCEDURE find_duplicate_contact_points (');

Line 7160: l(' WHEN FND_API.G_EXC_ERROR THEN');

7156: d(fnd_log.level_procedure,'find_duplicate_contact_points(-)');
7157:
7158:
7159: l('EXCEPTION');
7160: l(' WHEN FND_API.G_EXC_ERROR THEN');
7161: l(' RAISE FND_API.G_EXC_ERROR;');
7162: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7163: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7164: l(' WHEN OTHERS THEN');

Line 7161: l(' RAISE FND_API.G_EXC_ERROR;');

7157:
7158:
7159: l('EXCEPTION');
7160: l(' WHEN FND_API.G_EXC_ERROR THEN');
7161: l(' RAISE FND_API.G_EXC_ERROR;');
7162: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7163: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7164: l(' WHEN OTHERS THEN');
7165: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 7162: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

7158:
7159: l('EXCEPTION');
7160: l(' WHEN FND_API.G_EXC_ERROR THEN');
7161: l(' RAISE FND_API.G_EXC_ERROR;');
7162: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7163: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7164: l(' WHEN OTHERS THEN');
7165: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7166: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');

Line 7163: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

7159: l('EXCEPTION');
7160: l(' WHEN FND_API.G_EXC_ERROR THEN');
7161: l(' RAISE FND_API.G_EXC_ERROR;');
7162: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7163: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7164: l(' WHEN OTHERS THEN');
7165: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7166: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
7167: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 7169: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

7165: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7166: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
7167: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7168: l(' FND_MSG_PUB.ADD;');
7169: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7170: l('END find_duplicate_contact_points;');
7171: l('');
7172: l('PROCEDURE find_parties_dynamic (');
7173: l(' p_rule_id IN NUMBER,');

Line 7402: l(' WHEN FND_API.G_EXC_ERROR THEN');

7398: d(fnd_log.level_procedure,'call_api_dynamic(-)');
7399:
7400:
7401: l('EXCEPTION');
7402: l(' WHEN FND_API.G_EXC_ERROR THEN');
7403: l(' RAISE FND_API.G_EXC_ERROR;');
7404: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7405: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7406: l(' WHEN OTHERS THEN');

Line 7403: l(' RAISE FND_API.G_EXC_ERROR;');

7399:
7400:
7401: l('EXCEPTION');
7402: l(' WHEN FND_API.G_EXC_ERROR THEN');
7403: l(' RAISE FND_API.G_EXC_ERROR;');
7404: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7405: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7406: l(' WHEN OTHERS THEN');
7407: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 7404: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

7400:
7401: l('EXCEPTION');
7402: l(' WHEN FND_API.G_EXC_ERROR THEN');
7403: l(' RAISE FND_API.G_EXC_ERROR;');
7404: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7405: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7406: l(' WHEN OTHERS THEN');
7407: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7408: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');

Line 7405: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

7401: l('EXCEPTION');
7402: l(' WHEN FND_API.G_EXC_ERROR THEN');
7403: l(' RAISE FND_API.G_EXC_ERROR;');
7404: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7405: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7406: l(' WHEN OTHERS THEN');
7407: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7408: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
7409: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 7411: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

7407: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7408: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
7409: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7410: l(' FND_MSG_PUB.ADD;');
7411: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7412:
7413:
7414: l('END call_api_dynamic; ');
7415: l('');

Line 7675: l(' WHEN FND_API.G_EXC_ERROR THEN');

7671: END IF; ---End of Code Change for Match Rule Set
7672: d(fnd_log.level_procedure,'get_matching_party_sites(-)');
7673:
7674: l('EXCEPTION');
7675: l(' WHEN FND_API.G_EXC_ERROR THEN');
7676: l(' RAISE FND_API.G_EXC_ERROR;');
7677: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7678: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7679: l(' WHEN OTHERS THEN');

Line 7676: l(' RAISE FND_API.G_EXC_ERROR;');

7672: d(fnd_log.level_procedure,'get_matching_party_sites(-)');
7673:
7674: l('EXCEPTION');
7675: l(' WHEN FND_API.G_EXC_ERROR THEN');
7676: l(' RAISE FND_API.G_EXC_ERROR;');
7677: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7678: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7679: l(' WHEN OTHERS THEN');
7680: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 7677: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

7673:
7674: l('EXCEPTION');
7675: l(' WHEN FND_API.G_EXC_ERROR THEN');
7676: l(' RAISE FND_API.G_EXC_ERROR;');
7677: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7678: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7679: l(' WHEN OTHERS THEN');
7680: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7681: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');

Line 7678: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

7674: l('EXCEPTION');
7675: l(' WHEN FND_API.G_EXC_ERROR THEN');
7676: l(' RAISE FND_API.G_EXC_ERROR;');
7677: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7678: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7679: l(' WHEN OTHERS THEN');
7680: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7681: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
7682: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 7684: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

7680: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7681: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
7682: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7683: l(' FND_MSG_PUB.ADD;');
7684: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7685: l('END get_matching_party_sites;');
7686: l('');
7687:
7688: -- l(' NULL;');

Line 7951: l(' WHEN FND_API.G_EXC_ERROR THEN');

7947:
7948: d(fnd_log.level_procedure,'get_matching_contacts(-)');
7949:
7950: l('EXCEPTION');
7951: l(' WHEN FND_API.G_EXC_ERROR THEN');
7952: l(' RAISE FND_API.G_EXC_ERROR;');
7953: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7954: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7955: l(' WHEN OTHERS THEN');

Line 7952: l(' RAISE FND_API.G_EXC_ERROR;');

7948: d(fnd_log.level_procedure,'get_matching_contacts(-)');
7949:
7950: l('EXCEPTION');
7951: l(' WHEN FND_API.G_EXC_ERROR THEN');
7952: l(' RAISE FND_API.G_EXC_ERROR;');
7953: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7954: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7955: l(' WHEN OTHERS THEN');
7956: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 7953: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

7949:
7950: l('EXCEPTION');
7951: l(' WHEN FND_API.G_EXC_ERROR THEN');
7952: l(' RAISE FND_API.G_EXC_ERROR;');
7953: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7954: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7955: l(' WHEN OTHERS THEN');
7956: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7957: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');

Line 7954: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

7950: l('EXCEPTION');
7951: l(' WHEN FND_API.G_EXC_ERROR THEN');
7952: l(' RAISE FND_API.G_EXC_ERROR;');
7953: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7954: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7955: l(' WHEN OTHERS THEN');
7956: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7957: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
7958: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 7960: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

7956: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7957: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
7958: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7959: l(' FND_MSG_PUB.ADD;');
7960: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7961: l('END get_matching_contacts;');
7962: l('');
7963:
7964:

Line 8133: l(' WHEN FND_API.G_EXC_ERROR THEN');

8129: END IF; ---End of Code Change for Match Rule Set
8130: d(fnd_log.level_procedure,'get_matching_contact_points(-)');
8131:
8132: l('EXCEPTION');
8133: l(' WHEN FND_API.G_EXC_ERROR THEN');
8134: l(' RAISE FND_API.G_EXC_ERROR;');
8135: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
8136: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8137: l(' WHEN OTHERS THEN');

Line 8134: l(' RAISE FND_API.G_EXC_ERROR;');

8130: d(fnd_log.level_procedure,'get_matching_contact_points(-)');
8131:
8132: l('EXCEPTION');
8133: l(' WHEN FND_API.G_EXC_ERROR THEN');
8134: l(' RAISE FND_API.G_EXC_ERROR;');
8135: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
8136: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8137: l(' WHEN OTHERS THEN');
8138: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 8135: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

8131:
8132: l('EXCEPTION');
8133: l(' WHEN FND_API.G_EXC_ERROR THEN');
8134: l(' RAISE FND_API.G_EXC_ERROR;');
8135: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
8136: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8137: l(' WHEN OTHERS THEN');
8138: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8139: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');

Line 8136: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

8132: l('EXCEPTION');
8133: l(' WHEN FND_API.G_EXC_ERROR THEN');
8134: l(' RAISE FND_API.G_EXC_ERROR;');
8135: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
8136: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8137: l(' WHEN OTHERS THEN');
8138: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8139: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');
8140: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 8142: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

8138: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8139: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');
8140: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8141: l(' FND_MSG_PUB.ADD;');
8142: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8143: l('END get_matching_contact_points;');
8144:
8145: l('');
8146: l(' /**********************************************************');

Line 8376: l(' WHEN FND_API.G_EXC_ERROR THEN');

8372: d(fnd_log.level_procedure,'get_score_details(-)');
8373: END IF; ---End of Code Change for Match Rule Set
8374:
8375: l('EXCEPTION');
8376: l(' WHEN FND_API.G_EXC_ERROR THEN');
8377: l(' RAISE FND_API.G_EXC_ERROR;');
8378: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
8379: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8380: l(' WHEN OTHERS THEN');

Line 8377: l(' RAISE FND_API.G_EXC_ERROR;');

8373: END IF; ---End of Code Change for Match Rule Set
8374:
8375: l('EXCEPTION');
8376: l(' WHEN FND_API.G_EXC_ERROR THEN');
8377: l(' RAISE FND_API.G_EXC_ERROR;');
8378: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
8379: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8380: l(' WHEN OTHERS THEN');
8381: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 8378: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

8374:
8375: l('EXCEPTION');
8376: l(' WHEN FND_API.G_EXC_ERROR THEN');
8377: l(' RAISE FND_API.G_EXC_ERROR;');
8378: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
8379: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8380: l(' WHEN OTHERS THEN');
8381: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8382: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');

Line 8379: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

8375: l('EXCEPTION');
8376: l(' WHEN FND_API.G_EXC_ERROR THEN');
8377: l(' RAISE FND_API.G_EXC_ERROR;');
8378: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
8379: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8380: l(' WHEN OTHERS THEN');
8381: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8382: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
8383: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 8385: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

8381: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8382: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
8383: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8384: l(' FND_MSG_PUB.ADD;');
8385: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8386: l('END get_score_details;');
8387: l('');
8388:
8389: generate_acquire_proc(p_rule_id, NULL);

Line 8483: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

8479: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8480: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_parties_bulk'');');
8481: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8482: l(' FND_MSG_PUB.ADD;');
8483: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8484: l(' END check_parties_bulk ;');
8485: l('');
8486: END generate_check_parties_bulk ;
8487:

Line 8545: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

8541: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8542: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_sites_bulk'');');
8543: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8544: l(' FND_MSG_PUB.ADD;');
8545: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8546: l(' END check_party_sites_bulk ;');
8547: l('');
8548:
8549: END generate_check_partysites_bulk ;

Line 8609: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

8605: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8606: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contacts_bulk'');');
8607: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8608: l(' FND_MSG_PUB.ADD;');
8609: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8610: l(' END check_contacts_bulk ;');
8611: l('');
8612:
8613: END generate_check_contacts_bulk ;

Line 8671: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

8667: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8668: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_cpts_bulk'');');
8669: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8670: l(' FND_MSG_PUB.ADD;');
8671: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8672: l(' END check_cpts_bulk ;');
8673: l('');
8674:
8675: END generate_check_cpts_bulk ;

Line 8972: l(' RAISE FND_API.G_EXC_ERROR;');

8968: l(' p_contact_list,');
8969: l(' p_contact_point_list) THEN');
8970: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_PRIMARY_COND'');');
8971: l(' FND_MSG_PUB.ADD;');
8972: l(' RAISE FND_API.G_EXC_ERROR;');
8973: l(' END IF;');
8974: IF l_max_score=1 THEN
8975: l(' HZ_DQM_SEARCH_UTIL.set_no_score;');
8976: ELSE

Line 9295: l(' RAISE FND_API.G_EXC_ERROR;');

9291: l(' when others then');
9292: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9293: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9294: l(' FND_MSG_PUB.ADD;');
9295: l(' RAISE FND_API.G_EXC_ERROR;');
9296: l(' else ');
9297: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
9298: l(' end if;');
9299: ELSE

Line 9297: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

9293: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9294: l(' FND_MSG_PUB.ADD;');
9295: l(' RAISE FND_API.G_EXC_ERROR;');
9296: l(' else ');
9297: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
9298: l(' end if;');
9299: ELSE
9300: l('NULL ;');
9301: END IF;

Line 9408: l(' RAISE FND_API.G_EXC_ERROR;');

9404: l(' when others then');
9405: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9406: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9407: l(' FND_MSG_PUB.ADD;');
9408: l(' RAISE FND_API.G_EXC_ERROR;');
9409: l(' else ');
9410: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
9411: l(' end if;');
9412: ELSE

Line 9410: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

9406: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9407: l(' FND_MSG_PUB.ADD;');
9408: l(' RAISE FND_API.G_EXC_ERROR;');
9409: l(' else ');
9410: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
9411: l(' end if;');
9412: ELSE
9413: l('NULL ;');
9414: END IF;

Line 9509: l(' RAISE FND_API.G_EXC_ERROR;');

9505: l(' when others then');
9506: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9507: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9508: l(' FND_MSG_PUB.ADD;');
9509: l(' RAISE FND_API.G_EXC_ERROR;');
9510: l(' else ');
9511: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
9512: l(' end if;');
9513: ELSE

Line 9511: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

9507: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9508: l(' FND_MSG_PUB.ADD;');
9509: l(' RAISE FND_API.G_EXC_ERROR;');
9510: l(' else ');
9511: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
9512: l(' end if;');
9513: ELSE
9514: l('NULL ;');
9515: END IF;

Line 9616: l(' RAISE FND_API.G_EXC_ERROR;');

9612: l(' when others then');
9613: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9614: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9615: l(' FND_MSG_PUB.ADD;');
9616: l(' RAISE FND_API.G_EXC_ERROR;');
9617: l(' else ');
9618: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
9619: l(' end if;');
9620: ELSE

Line 9618: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

9614: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9615: l(' FND_MSG_PUB.ADD;');
9616: l(' RAISE FND_API.G_EXC_ERROR;');
9617: l(' else ');
9618: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
9619: l(' end if;');
9620: ELSE
9621: l('NULL ;');
9622: END IF;

Line 9835: l(' RAISE FND_API.G_EXC_ERROR;');

9831: l(' IF p_index>1 THEN');
9832: ldbg_s('In eval party level number of matches found exceeded threshold');
9833: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
9834: l(' FND_MSG_PUB.ADD;');
9835: l(' RAISE FND_API.G_EXC_ERROR;');
9836: l(' ELSE');
9837: l(' push_eval;');
9838: l(' RETURN;');
9839: l(' END IF;');

Line 9907: l(' RAISE FND_API.G_EXC_ERROR;');

9903: l(' IF p_index>1 THEN');
9904: ldbg_s('In eval party site level number of matches found exceeded threshold');
9905: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
9906: l(' FND_MSG_PUB.ADD;');
9907: l(' RAISE FND_API.G_EXC_ERROR;');
9908: l(' ELSE');
9909: l(' push_eval;');
9910: l(' RETURN;');
9911: l(' END IF;');

Line 9991: l(' RAISE FND_API.G_EXC_ERROR;');

9987: l(' IF p_index>1 THEN');
9988: ldbg_s('In eval contact level number of matches found exceeded threshold');
9989: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
9990: l(' FND_MSG_PUB.ADD;');
9991: l(' RAISE FND_API.G_EXC_ERROR;');
9992: l(' ELSE');
9993: l(' push_eval;');
9994: l(' RETURN;');
9995: l(' END IF;');

Line 10075: l(' RAISE FND_API.G_EXC_ERROR;');

10071: l(' IF p_index>1 THEN');
10072: ldbg_s('In eval contact point level number of matches found exceeded threshold');
10073: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10074: l(' FND_MSG_PUB.ADD;');
10075: l(' RAISE FND_API.G_EXC_ERROR;');
10076: l(' ELSE');
10077: l(' push_eval;');
10078: l(' RETURN;');
10079: l(' END IF;');

Line 10123: l(' RAISE FND_API.G_EXC_ERROR;');

10119: l(' ELSE');
10120: ldbg_s('In do eval number of matches found exceeded threshold');
10121: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10122: l(' FND_MSG_PUB.ADD;');
10123: l(' RAISE FND_API.G_EXC_ERROR;');
10124: l(' END IF; ');
10125: l(' END IF;');
10126: --End of Bug No: 4407425
10127: /*l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');

Line 10130: l(' RAISE FND_API.G_EXC_ERROR;');

10126: --End of Bug No: 4407425
10127: /*l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
10128: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10129: l(' FND_MSG_PUB.ADD;');
10130: l(' RAISE FND_API.G_EXC_ERROR;');
10131: l(' END IF;');
10132: */
10133: l(' IF call_order(p_index) = ''PARTY'' AND l_party_contains_str IS NOT NULL THEN');
10134: l(' eval_party_level(l_party_contains_str,call_type(p_index), p_index);');

Line 10384: l(' WHEN FND_API.G_EXC_ERROR THEN');

10380: d(fnd_log.level_procedure,'find_parties(-)');
10381:
10382:
10383: l('EXCEPTION');
10384: l(' WHEN FND_API.G_EXC_ERROR THEN');
10385: l(' ROLLBACK to find_parties;');
10386: l(' RAISE FND_API.G_EXC_ERROR;');
10387: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
10388: l(' ROLLBACK to find_parties;');

Line 10386: l(' RAISE FND_API.G_EXC_ERROR;');

10382:
10383: l('EXCEPTION');
10384: l(' WHEN FND_API.G_EXC_ERROR THEN');
10385: l(' ROLLBACK to find_parties;');
10386: l(' RAISE FND_API.G_EXC_ERROR;');
10387: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
10388: l(' ROLLBACK to find_parties;');
10389: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
10390: l(' WHEN OTHERS THEN');

Line 10387: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

10383: l('EXCEPTION');
10384: l(' WHEN FND_API.G_EXC_ERROR THEN');
10385: l(' ROLLBACK to find_parties;');
10386: l(' RAISE FND_API.G_EXC_ERROR;');
10387: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
10388: l(' ROLLBACK to find_parties;');
10389: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
10390: l(' WHEN OTHERS THEN');
10391: l(' ROLLBACK to find_parties;');

Line 10389: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

10385: l(' ROLLBACK to find_parties;');
10386: l(' RAISE FND_API.G_EXC_ERROR;');
10387: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
10388: l(' ROLLBACK to find_parties;');
10389: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
10390: l(' WHEN OTHERS THEN');
10391: l(' ROLLBACK to find_parties;');
10392: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
10393: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');

Line 10396: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

10392: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
10393: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
10394: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
10395: l(' FND_MSG_PUB.ADD;');
10396: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
10397: l('END find_parties;');
10398: l('');
10399:
10400: l('-------------------------------------------------------------------------------------');

Line 10620: l(' RAISE FND_API.G_EXC_ERROR;');

10616: l(' IF p_index>1 THEN');
10617: ldbg_s('In eval party level number of matches found exceeded threshold');
10618: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10619: l(' FND_MSG_PUB.ADD;');
10620: l(' RAISE FND_API.G_EXC_ERROR;');
10621: l(' ELSE');
10622: l(' push_eval;');
10623: l(' RETURN;');
10624: l(' END IF;');

Line 10657: l(' RAISE FND_API.G_EXC_ERROR;');

10653: l(' when others then');
10654: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
10655: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
10656: l(' FND_MSG_PUB.ADD;');
10657: l(' RAISE FND_API.G_EXC_ERROR;');
10658: --Start Bug No: 3032742.
10659: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
10660: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
10661: l(' FND_MSG_PUB.ADD;');

Line 10662: l(' RAISE FND_API.G_EXC_ERROR;');

10658: --Start Bug No: 3032742.
10659: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
10660: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
10661: l(' FND_MSG_PUB.ADD;');
10662: l(' RAISE FND_API.G_EXC_ERROR;');
10663: --End Bug No : 3032742.
10664: l(' else ');
10665: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
10666: l(' end if;');

Line 10665: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

10661: l(' FND_MSG_PUB.ADD;');
10662: l(' RAISE FND_API.G_EXC_ERROR;');
10663: --End Bug No : 3032742.
10664: l(' else ');
10665: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
10666: l(' end if;');
10667: --bug 4959719 end
10668: l(' END;');
10669:

Line 10744: l(' RAISE FND_API.G_EXC_ERROR;');

10740: l(' IF p_index>1 THEN');
10741: ldbg_s('In eval party site level number of matches found exceeded threshold');
10742: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10743: l(' FND_MSG_PUB.ADD;');
10744: l(' RAISE FND_API.G_EXC_ERROR;');
10745: l(' ELSE');
10746: l(' push_eval;');
10747: l(' RETURN;');
10748: l(' END IF;');

Line 10900: l(' RAISE FND_API.G_EXC_ERROR;');

10896: l(' IF p_index>1 THEN');
10897: ldbg_s('In eval contact point level number of matches found exceeded threshold');
10898: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10899: l(' FND_MSG_PUB.ADD;');
10900: l(' RAISE FND_API.G_EXC_ERROR;');
10901: l(' ELSE');
10902: l(' push_eval;');
10903: l(' RETURN;');
10904: l(' END IF;');

Line 10948: l(' RAISE FND_API.G_EXC_ERROR;');

10944: l(' ELSE');
10945: ldbg_s('In do eval number of matches found exceeded threshold');
10946: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10947: l(' FND_MSG_PUB.ADD;');
10948: l(' RAISE FND_API.G_EXC_ERROR;');
10949: l(' END IF; ');
10950: l(' END IF;');
10951: --End of Bug No: 4407425
10952: /*

Line 10956: l(' RAISE FND_API.G_EXC_ERROR;');

10952: /*
10953: l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
10954: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10955: l(' FND_MSG_PUB.ADD;');
10956: l(' RAISE FND_API.G_EXC_ERROR;');
10957: l(' END IF;');
10958: */
10959: l(' IF call_order(p_index) = ''PARTY'' AND l_party_contains_str IS NOT NULL THEN');
10960: l(' eval_party_level(l_party_contains_str,call_type(p_index), p_index);');

Line 11097: l(' WHEN FND_API.G_EXC_ERROR THEN');

11093: d(fnd_log.level_procedure,'find_persons(-)');
11094:
11095:
11096: l('EXCEPTION');
11097: l(' WHEN FND_API.G_EXC_ERROR THEN');
11098: l(' ROLLBACK to find_persons;');
11099: l(' RAISE FND_API.G_EXC_ERROR;');
11100: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11101: l(' ROLLBACK to find_persons;');

Line 11099: l(' RAISE FND_API.G_EXC_ERROR;');

11095:
11096: l('EXCEPTION');
11097: l(' WHEN FND_API.G_EXC_ERROR THEN');
11098: l(' ROLLBACK to find_persons;');
11099: l(' RAISE FND_API.G_EXC_ERROR;');
11100: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11101: l(' ROLLBACK to find_persons;');
11102: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11103: l(' WHEN OTHERS THEN');

Line 11100: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

11096: l('EXCEPTION');
11097: l(' WHEN FND_API.G_EXC_ERROR THEN');
11098: l(' ROLLBACK to find_persons;');
11099: l(' RAISE FND_API.G_EXC_ERROR;');
11100: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11101: l(' ROLLBACK to find_persons;');
11102: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11103: l(' WHEN OTHERS THEN');
11104: l(' ROLLBACK to find_persons;');

Line 11102: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

11098: l(' ROLLBACK to find_persons;');
11099: l(' RAISE FND_API.G_EXC_ERROR;');
11100: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11101: l(' ROLLBACK to find_persons;');
11102: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11103: l(' WHEN OTHERS THEN');
11104: l(' ROLLBACK to find_persons;');
11105: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11106: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');

Line 11109: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

11105: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11106: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
11107: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11108: l(' FND_MSG_PUB.ADD;');
11109: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11110: l('END find_persons;');
11111: ELSE
11112: l('BEGIN');
11113: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

Line 11115: l(' RAISE FND_API.G_EXC_ERROR;');

11111: ELSE
11112: l('BEGIN');
11113: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
11114: l(' FND_MSG_PUB.ADD;');
11115: l(' RAISE FND_API.G_EXC_ERROR;');
11116: l('END find_persons;');
11117: l('');
11118: END IF;
11119: l('PROCEDURE find_persons (');

Line 11180: l(' WHEN FND_API.G_EXC_ERROR THEN');

11176: d(fnd_log.level_procedure,'find_party_details(-)');
11177:
11178:
11179: l('EXCEPTION');
11180: l(' WHEN FND_API.G_EXC_ERROR THEN');
11181: l(' RAISE FND_API.G_EXC_ERROR;');
11182: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11183: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11184: l(' WHEN OTHERS THEN');

Line 11181: l(' RAISE FND_API.G_EXC_ERROR;');

11177:
11178:
11179: l('EXCEPTION');
11180: l(' WHEN FND_API.G_EXC_ERROR THEN');
11181: l(' RAISE FND_API.G_EXC_ERROR;');
11182: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11183: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11184: l(' WHEN OTHERS THEN');
11185: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 11182: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

11178:
11179: l('EXCEPTION');
11180: l(' WHEN FND_API.G_EXC_ERROR THEN');
11181: l(' RAISE FND_API.G_EXC_ERROR;');
11182: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11183: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11184: l(' WHEN OTHERS THEN');
11185: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11186: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');

Line 11183: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

11179: l('EXCEPTION');
11180: l(' WHEN FND_API.G_EXC_ERROR THEN');
11181: l(' RAISE FND_API.G_EXC_ERROR;');
11182: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11183: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11184: l(' WHEN OTHERS THEN');
11185: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11186: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
11187: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 11189: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

11185: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11186: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
11187: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11188: l(' FND_MSG_PUB.ADD;');
11189: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11190: l('END find_party_details;');
11191: l('');
11192: l('-------------------------------------------------------------------------------------');
11193: l('-------------------- BULK MATCH RULE ::: find_duplicate_parties -------------------');

Line 11272: l(' WHEN FND_API.G_EXC_ERROR THEN');

11268: d(fnd_log.level_procedure,'find_duplicate_parties(-)');
11269:
11270:
11271: l('EXCEPTION');
11272: l(' WHEN FND_API.G_EXC_ERROR THEN');
11273: l(' RAISE FND_API.G_EXC_ERROR;');
11274: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11275: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11276: l(' WHEN OTHERS THEN');

Line 11273: l(' RAISE FND_API.G_EXC_ERROR;');

11269:
11270:
11271: l('EXCEPTION');
11272: l(' WHEN FND_API.G_EXC_ERROR THEN');
11273: l(' RAISE FND_API.G_EXC_ERROR;');
11274: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11275: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11276: l(' WHEN OTHERS THEN');
11277: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 11274: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

11270:
11271: l('EXCEPTION');
11272: l(' WHEN FND_API.G_EXC_ERROR THEN');
11273: l(' RAISE FND_API.G_EXC_ERROR;');
11274: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11275: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11276: l(' WHEN OTHERS THEN');
11277: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11278: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');

Line 11275: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

11271: l('EXCEPTION');
11272: l(' WHEN FND_API.G_EXC_ERROR THEN');
11273: l(' RAISE FND_API.G_EXC_ERROR;');
11274: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11275: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11276: l(' WHEN OTHERS THEN');
11277: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11278: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
11279: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 11281: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

11277: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11278: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
11279: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11280: l(' FND_MSG_PUB.ADD;');
11281: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11282: l('END find_duplicate_parties;');
11283:
11284:
11285: l('');

Line 11367: l(' WHEN FND_API.G_EXC_ERROR THEN');

11363: d(fnd_log.level_procedure,'find_duplicate_party_sites(-)');
11364:
11365:
11366: l('EXCEPTION');
11367: l(' WHEN FND_API.G_EXC_ERROR THEN');
11368: l(' RAISE FND_API.G_EXC_ERROR;');
11369: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11370: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11371: l(' WHEN OTHERS THEN');

Line 11368: l(' RAISE FND_API.G_EXC_ERROR;');

11364:
11365:
11366: l('EXCEPTION');
11367: l(' WHEN FND_API.G_EXC_ERROR THEN');
11368: l(' RAISE FND_API.G_EXC_ERROR;');
11369: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11370: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11371: l(' WHEN OTHERS THEN');
11372: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 11369: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

11365:
11366: l('EXCEPTION');
11367: l(' WHEN FND_API.G_EXC_ERROR THEN');
11368: l(' RAISE FND_API.G_EXC_ERROR;');
11369: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11370: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11371: l(' WHEN OTHERS THEN');
11372: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11373: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');

Line 11370: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

11366: l('EXCEPTION');
11367: l(' WHEN FND_API.G_EXC_ERROR THEN');
11368: l(' RAISE FND_API.G_EXC_ERROR;');
11369: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11370: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11371: l(' WHEN OTHERS THEN');
11372: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11373: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
11374: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 11376: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

11372: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11373: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
11374: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11375: l(' FND_MSG_PUB.ADD;');
11376: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11377: l('END find_duplicate_party_sites; ');
11378: l(' ');
11379:
11380: l('-------------------------------------------------------------------------------------');

Line 11465: l(' WHEN FND_API.G_EXC_ERROR THEN');

11461: d(fnd_log.level_procedure,'find_duplicate_contacts(-)');
11462:
11463:
11464: l('EXCEPTION');
11465: l(' WHEN FND_API.G_EXC_ERROR THEN');
11466: l(' RAISE FND_API.G_EXC_ERROR;');
11467: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11468: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11469: l(' WHEN OTHERS THEN');

Line 11466: l(' RAISE FND_API.G_EXC_ERROR;');

11462:
11463:
11464: l('EXCEPTION');
11465: l(' WHEN FND_API.G_EXC_ERROR THEN');
11466: l(' RAISE FND_API.G_EXC_ERROR;');
11467: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11468: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11469: l(' WHEN OTHERS THEN');
11470: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 11467: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

11463:
11464: l('EXCEPTION');
11465: l(' WHEN FND_API.G_EXC_ERROR THEN');
11466: l(' RAISE FND_API.G_EXC_ERROR;');
11467: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11468: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11469: l(' WHEN OTHERS THEN');
11470: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11471: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');

Line 11468: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

11464: l('EXCEPTION');
11465: l(' WHEN FND_API.G_EXC_ERROR THEN');
11466: l(' RAISE FND_API.G_EXC_ERROR;');
11467: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11468: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11469: l(' WHEN OTHERS THEN');
11470: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11471: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
11472: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 11474: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

11470: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11471: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
11472: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11473: l(' FND_MSG_PUB.ADD;');
11474: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11475: l('END find_duplicate_contacts; ');
11476: l('');
11477: l('-------------------------------------------------------------------------------------');
11478: l('-------------------- BULK MATCH RULE ::: find_duplicate_contact_points -------------');

Line 11543: l(' WHEN FND_API.G_EXC_ERROR THEN');

11539: d(fnd_log.level_procedure,'find_duplicate_contact_points(-)');
11540:
11541:
11542: l('EXCEPTION');
11543: l(' WHEN FND_API.G_EXC_ERROR THEN');
11544: l(' RAISE FND_API.G_EXC_ERROR;');
11545: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11546: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11547: l(' WHEN OTHERS THEN');

Line 11544: l(' RAISE FND_API.G_EXC_ERROR;');

11540:
11541:
11542: l('EXCEPTION');
11543: l(' WHEN FND_API.G_EXC_ERROR THEN');
11544: l(' RAISE FND_API.G_EXC_ERROR;');
11545: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11546: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11547: l(' WHEN OTHERS THEN');
11548: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 11545: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

11541:
11542: l('EXCEPTION');
11543: l(' WHEN FND_API.G_EXC_ERROR THEN');
11544: l(' RAISE FND_API.G_EXC_ERROR;');
11545: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11546: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11547: l(' WHEN OTHERS THEN');
11548: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11549: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');

Line 11546: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

11542: l('EXCEPTION');
11543: l(' WHEN FND_API.G_EXC_ERROR THEN');
11544: l(' RAISE FND_API.G_EXC_ERROR;');
11545: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11546: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11547: l(' WHEN OTHERS THEN');
11548: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11549: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
11550: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 11552: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

11548: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11549: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
11550: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11551: l(' FND_MSG_PUB.ADD;');
11552: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11553: l('END find_duplicate_contact_points;');
11554: l('');
11555:
11556: l('-------------------------------------------------------------------------------------');

Line 11786: l(' WHEN FND_API.G_EXC_ERROR THEN');

11782: d(fnd_log.level_procedure,'call_api_dynamic(-)');
11783:
11784:
11785: l('EXCEPTION');
11786: l(' WHEN FND_API.G_EXC_ERROR THEN');
11787: l(' RAISE FND_API.G_EXC_ERROR;');
11788: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11790: l(' WHEN OTHERS THEN');

Line 11787: l(' RAISE FND_API.G_EXC_ERROR;');

11783:
11784:
11785: l('EXCEPTION');
11786: l(' WHEN FND_API.G_EXC_ERROR THEN');
11787: l(' RAISE FND_API.G_EXC_ERROR;');
11788: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11790: l(' WHEN OTHERS THEN');
11791: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 11788: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

11784:
11785: l('EXCEPTION');
11786: l(' WHEN FND_API.G_EXC_ERROR THEN');
11787: l(' RAISE FND_API.G_EXC_ERROR;');
11788: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11790: l(' WHEN OTHERS THEN');
11791: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11792: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');

Line 11789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

11785: l('EXCEPTION');
11786: l(' WHEN FND_API.G_EXC_ERROR THEN');
11787: l(' RAISE FND_API.G_EXC_ERROR;');
11788: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11790: l(' WHEN OTHERS THEN');
11791: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11792: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
11793: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 11795: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

11791: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11792: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
11793: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11794: l(' FND_MSG_PUB.ADD;');
11795: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11796:
11797:
11798: l('END call_api_dynamic;');
11799: l('');

Line 12024: l(' WHEN FND_API.G_EXC_ERROR THEN');

12020:
12021: d(fnd_log.level_procedure,'get_matching_party_sites(-)');
12022:
12023: l('EXCEPTION');
12024: l(' WHEN FND_API.G_EXC_ERROR THEN');
12025: l(' ROLLBACK to get_matching_party_sites ;');
12026: l(' RAISE FND_API.G_EXC_ERROR;');
12027: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
12028: l(' ROLLBACK to get_matching_party_sites ;');

Line 12026: l(' RAISE FND_API.G_EXC_ERROR;');

12022:
12023: l('EXCEPTION');
12024: l(' WHEN FND_API.G_EXC_ERROR THEN');
12025: l(' ROLLBACK to get_matching_party_sites ;');
12026: l(' RAISE FND_API.G_EXC_ERROR;');
12027: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
12028: l(' ROLLBACK to get_matching_party_sites ;');
12029: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12030: l(' WHEN OTHERS THEN');

Line 12027: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

12023: l('EXCEPTION');
12024: l(' WHEN FND_API.G_EXC_ERROR THEN');
12025: l(' ROLLBACK to get_matching_party_sites ;');
12026: l(' RAISE FND_API.G_EXC_ERROR;');
12027: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
12028: l(' ROLLBACK to get_matching_party_sites ;');
12029: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12030: l(' WHEN OTHERS THEN');
12031: l(' ROLLBACK to get_matching_party_sites ;');

Line 12029: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

12025: l(' ROLLBACK to get_matching_party_sites ;');
12026: l(' RAISE FND_API.G_EXC_ERROR;');
12027: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
12028: l(' ROLLBACK to get_matching_party_sites ;');
12029: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12030: l(' WHEN OTHERS THEN');
12031: l(' ROLLBACK to get_matching_party_sites ;');
12032: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12033: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');

Line 12036: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

12032: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12033: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
12034: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12035: l(' FND_MSG_PUB.ADD;');
12036: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12037: l('END get_matching_party_sites;');
12038: l('');
12039:
12040: -- l(' NULL;');

Line 12266: l(' WHEN FND_API.G_EXC_ERROR THEN');

12262:
12263: d(fnd_log.level_procedure,'get_matching_contacts(-)');
12264:
12265: l('EXCEPTION');
12266: l(' WHEN FND_API.G_EXC_ERROR THEN');
12267: l(' ROLLBACK to get_matching_contacts ;');
12268: l(' RAISE FND_API.G_EXC_ERROR;');
12269: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
12270: l(' ROLLBACK to get_matching_contacts ;');

Line 12268: l(' RAISE FND_API.G_EXC_ERROR;');

12264:
12265: l('EXCEPTION');
12266: l(' WHEN FND_API.G_EXC_ERROR THEN');
12267: l(' ROLLBACK to get_matching_contacts ;');
12268: l(' RAISE FND_API.G_EXC_ERROR;');
12269: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
12270: l(' ROLLBACK to get_matching_contacts ;');
12271: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12272: l(' WHEN OTHERS THEN');

Line 12269: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

12265: l('EXCEPTION');
12266: l(' WHEN FND_API.G_EXC_ERROR THEN');
12267: l(' ROLLBACK to get_matching_contacts ;');
12268: l(' RAISE FND_API.G_EXC_ERROR;');
12269: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
12270: l(' ROLLBACK to get_matching_contacts ;');
12271: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12272: l(' WHEN OTHERS THEN');
12273: l(' ROLLBACK to get_matching_contacts ;');

Line 12271: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

12267: l(' ROLLBACK to get_matching_contacts ;');
12268: l(' RAISE FND_API.G_EXC_ERROR;');
12269: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
12270: l(' ROLLBACK to get_matching_contacts ;');
12271: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12272: l(' WHEN OTHERS THEN');
12273: l(' ROLLBACK to get_matching_contacts ;');
12274: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12275: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');

Line 12278: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

12274: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12275: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
12276: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12277: l(' FND_MSG_PUB.ADD;');
12278: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12279: l('END get_matching_contacts;');
12280: l('');
12281: l('-------------------------------------------------------------------------------------');
12282: l('-------------------- BULK MATCH RULE ::: get_matching_contact_points ---------------');

Line 12427: l(' WHEN FND_API.G_EXC_ERROR THEN');

12423:
12424: d(fnd_log.level_procedure,'get_matching_contact_points(-)');
12425:
12426: l('EXCEPTION');
12427: l(' WHEN FND_API.G_EXC_ERROR THEN');
12428: l(' ROLLBACK to get_matching_contact_points ;');
12429: l(' RAISE FND_API.G_EXC_ERROR;');
12430: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
12431: l(' ROLLBACK to get_matching_contact_points ;');

Line 12429: l(' RAISE FND_API.G_EXC_ERROR;');

12425:
12426: l('EXCEPTION');
12427: l(' WHEN FND_API.G_EXC_ERROR THEN');
12428: l(' ROLLBACK to get_matching_contact_points ;');
12429: l(' RAISE FND_API.G_EXC_ERROR;');
12430: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
12431: l(' ROLLBACK to get_matching_contact_points ;');
12432: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12433: l(' WHEN OTHERS THEN');

Line 12430: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

12426: l('EXCEPTION');
12427: l(' WHEN FND_API.G_EXC_ERROR THEN');
12428: l(' ROLLBACK to get_matching_contact_points ;');
12429: l(' RAISE FND_API.G_EXC_ERROR;');
12430: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
12431: l(' ROLLBACK to get_matching_contact_points ;');
12432: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12433: l(' WHEN OTHERS THEN');
12434: l(' ROLLBACK to get_matching_contact_points ;');

Line 12432: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

12428: l(' ROLLBACK to get_matching_contact_points ;');
12429: l(' RAISE FND_API.G_EXC_ERROR;');
12430: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
12431: l(' ROLLBACK to get_matching_contact_points ;');
12432: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12433: l(' WHEN OTHERS THEN');
12434: l(' ROLLBACK to get_matching_contact_points ;');
12435: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12436: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');

Line 12439: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

12435: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12436: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');
12437: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12438: l(' FND_MSG_PUB.ADD;');
12439: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12440: l('END get_matching_contact_points;');
12441:
12442: l('');
12443: l(' /**********************************************************');

Line 12657: l(' WHEN FND_API.G_EXC_ERROR THEN');

12653: d(fnd_log.level_procedure,'get_score_details(-)');
12654:
12655:
12656: l('EXCEPTION');
12657: l(' WHEN FND_API.G_EXC_ERROR THEN');
12658: l(' --------------- DELETE FROM ALL SRCH TABLES ---------------------');
12659: l(' DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;');
12660: l(' DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;');
12661: l(' DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;');

Line 12663: l(' RAISE FND_API.G_EXC_ERROR;');

12659: l(' DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;');
12660: l(' DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;');
12661: l(' DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;');
12662: l(' DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;');
12663: l(' RAISE FND_API.G_EXC_ERROR;');
12664: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
12665: l(' --------------- DELETE FROM ALL SRCH TABLES ---------------------');
12666: l(' DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;');
12667: l(' DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;');

Line 12664: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

12660: l(' DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;');
12661: l(' DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;');
12662: l(' DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;');
12663: l(' RAISE FND_API.G_EXC_ERROR;');
12664: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
12665: l(' --------------- DELETE FROM ALL SRCH TABLES ---------------------');
12666: l(' DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;');
12667: l(' DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;');
12668: l(' DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;');

Line 12670: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

12666: l(' DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;');
12667: l(' DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;');
12668: l(' DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;');
12669: l(' DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;');
12670: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12671: l(' WHEN OTHERS THEN');
12672: l(' --------------- DELETE FROM ALL SRCH TABLES ---------------------');
12673: l(' DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;');
12674: l(' DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;');

Line 12681: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

12677: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12678: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
12679: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12680: l(' FND_MSG_PUB.ADD;');
12681: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12682: l('END get_score_details;');
12683: l('');
12684:
12685: generate_acquire_proc(p_rule_id, 'Q');

Line 12914: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

12910: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
12911: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
12912: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
12913: l(' FND_MSG_PUB.ADD;');
12914: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12915: l('END;');
12916:
12917: END generate_party_map_proc_bulk ;
12918:

Line 13106: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

13102: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13103: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13104: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13105: l(' FND_MSG_PUB.ADD;');
13106: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13107: l('END;');
13108:
13109: END generate_map_proc;
13110:

Line 13206: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

13202: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13203: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13204: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13205: l(' FND_MSG_PUB.ADD;');
13206: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13207: l('END;');
13208:
13209: END ;
13210:

Line 13424: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

13420: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13421: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13422: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13423: l(' FND_MSG_PUB.ADD;');
13424: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13425: l('END;');
13426:
13427: END generate_map_proc_bulk ;
13428:

Line 13630: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

13626: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13627: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13628: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13629: l(' FND_MSG_PUB.ADD;');
13630: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13631: l('END;');
13632:
13633: END generate_party_map_proc;
13634:

Line 13680: l(' RAISE FND_API.G_EXC_ERROR;');

13676: IF NOT FIRST THEN
13677: l(' ) THEN');
13678: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_CONTACT_POINT_TYPE'');');
13679: l(' FND_MSG_PUB.ADD;');
13680: l(' RAISE FND_API.G_EXC_ERROR;');
13681: l(' END IF;');
13682: l(' END LOOP;');
13683: l('');
13684: END IF;

Line 13726: l(' WHEN FND_API.G_EXC_ERROR THEN');

13722: l(' END LOOP;');
13723: END LOOP;
13724: l(' RETURN FALSE;');
13725: l('EXCEPTION');
13726: l(' WHEN FND_API.G_EXC_ERROR THEN');
13727: l(' RAISE FND_API.G_EXC_ERROR;');
13728: l(' WHEN OTHERS THEN');
13729: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13730: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_prim_cond'');');

Line 13727: l(' RAISE FND_API.G_EXC_ERROR;');

13723: END LOOP;
13724: l(' RETURN FALSE;');
13725: l('EXCEPTION');
13726: l(' WHEN FND_API.G_EXC_ERROR THEN');
13727: l(' RAISE FND_API.G_EXC_ERROR;');
13728: l(' WHEN OTHERS THEN');
13729: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13730: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_prim_cond'');');
13731: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 13733: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

13729: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13730: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_prim_cond'');');
13731: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
13732: l(' FND_MSG_PUB.ADD;');
13733: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13734: l(' END check_prim_cond;');
13735: l('');
13736:
13737: l('/************************************************');

Line 13869: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

13865: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13866: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_site_cond'');');
13867: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
13868: l(' FND_MSG_PUB.ADD;');
13869: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13870: l(' END check_party_site_cond;');
13871: l('');
13872:
13873: l('/************************************************');

Line 14007: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

14003: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14004: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contact_cond'');');
14005: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14006: l(' FND_MSG_PUB.ADD;');
14007: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14008: l(' END check_contact_cond;');
14009: l('');
14010:
14011: l('/************************************************');

Line 14030: l(' RAISE FND_API.G_EXC_ERROR;');

14026: l(' FOR I IN 1..p_contact_point_list.COUNT LOOP');
14027: l(' IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN ');
14028: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_CONTACT_POINT_TYPE'');');
14029: l(' FND_MSG_PUB.ADD;');
14030: l(' RAISE FND_API.G_EXC_ERROR;');
14031: l(' END IF;');
14032: l(' END LOOP;');
14033: l('');
14034: l(' FOR I IN 1..p_contact_point_list.COUNT LOOP');

Line 14094: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

14090: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14091: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contact_point_cond'');');
14092: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14093: l(' FND_MSG_PUB.ADD;');
14094: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14095: l(' END check_contact_point_cond;');
14096: l('');
14097:
14098:

Line 14367: l(' WHEN FND_API.G_EXC_ERROR THEN');

14363: l(' get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,');
14364: l(' x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);');
14365:
14366: l('EXCEPTION');
14367: l(' WHEN FND_API.G_EXC_ERROR THEN');
14368: l(' RAISE FND_API.G_EXC_ERROR;');
14369: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
14370: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14371: l(' WHEN OTHERS THEN');

Line 14368: l(' RAISE FND_API.G_EXC_ERROR;');

14364: l(' x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);');
14365:
14366: l('EXCEPTION');
14367: l(' WHEN FND_API.G_EXC_ERROR THEN');
14368: l(' RAISE FND_API.G_EXC_ERROR;');
14369: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
14370: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14371: l(' WHEN OTHERS THEN');
14372: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 14369: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

14365:
14366: l('EXCEPTION');
14367: l(' WHEN FND_API.G_EXC_ERROR THEN');
14368: l(' RAISE FND_API.G_EXC_ERROR;');
14369: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
14370: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14371: l(' WHEN OTHERS THEN');
14372: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14373: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_for_search'');');

Line 14370: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

14366: l('EXCEPTION');
14367: l(' WHEN FND_API.G_EXC_ERROR THEN');
14368: l(' RAISE FND_API.G_EXC_ERROR;');
14369: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
14370: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14371: l(' WHEN OTHERS THEN');
14372: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14373: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_for_search'');');
14374: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 14376: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

14372: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14373: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_for_search'');');
14374: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14375: l(' FND_MSG_PUB.ADD;');
14376: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14377: l('END get_party_for_search;');
14378: l('');
14379:
14380: l('PROCEDURE get_search_criteria (');

Line 14502: l(' WHEN FND_API.G_EXC_ERROR THEN');

14498: l(' get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);');
14499: l(' END IF;');
14500: END IF;
14501: l('EXCEPTION');
14502: l(' WHEN FND_API.G_EXC_ERROR THEN');
14503: l(' RAISE FND_API.G_EXC_ERROR;');
14504: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
14505: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14506: l(' WHEN OTHERS THEN');

Line 14503: l(' RAISE FND_API.G_EXC_ERROR;');

14499: l(' END IF;');
14500: END IF;
14501: l('EXCEPTION');
14502: l(' WHEN FND_API.G_EXC_ERROR THEN');
14503: l(' RAISE FND_API.G_EXC_ERROR;');
14504: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
14505: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14506: l(' WHEN OTHERS THEN');
14507: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');

Line 14504: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

14500: END IF;
14501: l('EXCEPTION');
14502: l(' WHEN FND_API.G_EXC_ERROR THEN');
14503: l(' RAISE FND_API.G_EXC_ERROR;');
14504: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
14505: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14506: l(' WHEN OTHERS THEN');
14507: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14508: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_search_criteria'');');

Line 14505: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

14501: l('EXCEPTION');
14502: l(' WHEN FND_API.G_EXC_ERROR THEN');
14503: l(' RAISE FND_API.G_EXC_ERROR;');
14504: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
14505: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14506: l(' WHEN OTHERS THEN');
14507: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14508: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_search_criteria'');');
14509: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');

Line 14511: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

14507: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14508: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_search_criteria'');');
14509: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14510: l(' FND_MSG_PUB.ADD;');
14511: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14512: l('END get_search_criteria;');
14513: l('');
14514:
14515: l('');

Line 14760: l(' RAISE FND_API.G_EXC_ERROR;');

14756: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_rec'');');
14757: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',p_party_id);');
14758: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14759: l(' FND_MSG_PUB.ADD;');
14760: l(' RAISE FND_API.G_EXC_ERROR;');
14761: l('END get_party_rec;');
14762: l('');
14763: l('/************************************************');
14764: l(' This procedure retrieves the match rule party site attributes into ');

Line 14849: l(' RAISE FND_API.G_EXC_ERROR;');

14845: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_site_rec'');');
14846: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_party_site_id);');
14847: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14848: l(' FND_MSG_PUB.ADD;');
14849: l(' RAISE FND_API.G_EXC_ERROR;');
14850: l('END get_party_site_rec;');
14851: l('');
14852:
14853: l('/************************************************');

Line 14943: l(' RAISE FND_API.G_EXC_ERROR;');

14939: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_rec'');');
14940: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_org_contact_id);');
14941: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14942: l(' FND_MSG_PUB.ADD;');
14943: l(' RAISE FND_API.G_EXC_ERROR;');
14944: l('END get_contact_rec;');
14945: l('');
14946: l('/************************************************');
14947: l(' This procedure retrieves the match rule contact point attributes into ');

Line 15038: l(' RAISE FND_API.G_EXC_ERROR;');

15034: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_point_rec'');');
15035: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_contact_point_id);');
15036: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
15037: l(' FND_MSG_PUB.ADD;');
15038: l(' RAISE FND_API.G_EXC_ERROR;');
15039: l('END get_contact_point_rec;');
15040:
15041: END;
15042:

Line 15529: l(' p_encoded => FND_API.G_FALSE,');

15525:
15526: BEGIN
15527: l(' --Standard call to get message count and if count is 1, get message info');
15528: l(' FND_MSG_PUB.Count_And_Get(');
15529: l(' p_encoded => FND_API.G_FALSE,');
15530: l(' p_count => x_msg_count,');
15531: l(' p_data => x_msg_data);');
15532: l(' EXCEPTION');
15533: l(' WHEN FND_API.G_EXC_ERROR THEN');

Line 15533: l(' WHEN FND_API.G_EXC_ERROR THEN');

15529: l(' p_encoded => FND_API.G_FALSE,');
15530: l(' p_count => x_msg_count,');
15531: l(' p_data => x_msg_data);');
15532: l(' EXCEPTION');
15533: l(' WHEN FND_API.G_EXC_ERROR THEN');
15534: l(' x_return_status := FND_API.G_RET_STS_ERROR;');
15535: l(' FND_MSG_PUB.Count_And_Get(');
15536: l(' p_encoded => FND_API.G_FALSE,');
15537: l(' p_count => x_msg_count,');

Line 15534: l(' x_return_status := FND_API.G_RET_STS_ERROR;');

15530: l(' p_count => x_msg_count,');
15531: l(' p_data => x_msg_data);');
15532: l(' EXCEPTION');
15533: l(' WHEN FND_API.G_EXC_ERROR THEN');
15534: l(' x_return_status := FND_API.G_RET_STS_ERROR;');
15535: l(' FND_MSG_PUB.Count_And_Get(');
15536: l(' p_encoded => FND_API.G_FALSE,');
15537: l(' p_count => x_msg_count,');
15538: l(' p_data => x_msg_data);');

Line 15536: l(' p_encoded => FND_API.G_FALSE,');

15532: l(' EXCEPTION');
15533: l(' WHEN FND_API.G_EXC_ERROR THEN');
15534: l(' x_return_status := FND_API.G_RET_STS_ERROR;');
15535: l(' FND_MSG_PUB.Count_And_Get(');
15536: l(' p_encoded => FND_API.G_FALSE,');
15537: l(' p_count => x_msg_count,');
15538: l(' p_data => x_msg_data);');
15539: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
15540: l(' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');

Line 15539: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

15535: l(' FND_MSG_PUB.Count_And_Get(');
15536: l(' p_encoded => FND_API.G_FALSE,');
15537: l(' p_count => x_msg_count,');
15538: l(' p_data => x_msg_data);');
15539: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
15540: l(' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
15541: l(' FND_MSG_PUB.Count_And_Get(');
15542: l(' p_encoded => FND_API.G_FALSE,');
15543: l(' p_count => x_msg_count,');

Line 15540: l(' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');

15536: l(' p_encoded => FND_API.G_FALSE,');
15537: l(' p_count => x_msg_count,');
15538: l(' p_data => x_msg_data);');
15539: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
15540: l(' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
15541: l(' FND_MSG_PUB.Count_And_Get(');
15542: l(' p_encoded => FND_API.G_FALSE,');
15543: l(' p_count => x_msg_count,');
15544: l(' p_data => x_msg_data);');

Line 15542: l(' p_encoded => FND_API.G_FALSE,');

15538: l(' p_data => x_msg_data);');
15539: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
15540: l(' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
15541: l(' FND_MSG_PUB.Count_And_Get(');
15542: l(' p_encoded => FND_API.G_FALSE,');
15543: l(' p_count => x_msg_count,');
15544: l(' p_data => x_msg_data);');
15545: l('');
15546: l(' WHEN OTHERS THEN');

Line 15547: l(' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');

15543: l(' p_count => x_msg_count,');
15544: l(' p_data => x_msg_data);');
15545: l('');
15546: l(' WHEN OTHERS THEN');
15547: l(' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
15548: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
15549: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''HZ_PARTY_SEARCH'');');
15550: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
15551: l(' FND_MSG_PUB.ADD;');

Line 15554: l(' p_encoded => FND_API.G_FALSE,');

15550: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
15551: l(' FND_MSG_PUB.ADD;');
15552: l('');
15553: l(' FND_MSG_PUB.Count_And_Get(');
15554: l(' p_encoded => FND_API.G_FALSE,');
15555: l(' p_count => x_msg_count,');
15556: l(' p_data => x_msg_data);');
15557: END;
15558:

Line 15769: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

15765: BEGIN
15766: FND_MSG_PUB.Reset;
15767:
15768: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
15769: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
15770: END LOOP;
15771: IF (SQLERRM IS NOT NULL) THEN
15772: l_msg_data := l_msg_data || SQLERRM;
15773: END IF;

Line 15799: l(' RAISE FND_API.G_EXC_ERROR; ');

15795: l(' EXCEPTION WHEN NO_DATA_FOUND THEN ');
15796: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_NOATTRIB_ERROR'' ); ');
15797: l(' FND_MESSAGE.SET_TOKEN(''ENTITY_ATTRIBUTE'' ,p_str); ');
15798: l(' FND_MSG_PUB.ADD; ');
15799: l(' RAISE FND_API.G_EXC_ERROR; ');
15800: l(' END get_attrib_id; ');
15801:
15802: l(' PROCEDURE call_api_dynamic_names (');
15803: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

Line 15803: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');

15799: l(' RAISE FND_API.G_EXC_ERROR; ');
15800: l(' END get_attrib_id; ');
15801:
15802: l(' PROCEDURE call_api_dynamic_names (');
15803: l(' p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,');
15804: l(' p_rule_id IN NUMBER,');
15805: l(' p_attrib_name1 IN VARCHAR2,');
15806: l(' p_attrib_name2 IN VARCHAR2,');
15807: l(' p_attrib_name3 IN VARCHAR2,');