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_35 dependencies on FND_MSG_PUB

Line 101: FND_MSG_PUB.ADD;

97: exception
98: when others then
99: if (instrb(SQLERRM,'DRG-51030')>0) then
100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_ERROR;
103: elsif (instrb(SQLERRM,'DRG-50943')>0) then
104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
105: FND_MSG_PUB.ADD;

Line 105: FND_MSG_PUB.ADD;

101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_ERROR;
103: elsif (instrb(SQLERRM,'DRG-50943')>0) then
104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
105: FND_MSG_PUB.ADD;
106: RAISE FND_API.G_EXC_ERROR;
107: else
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: end if;

Line 787: FND_MSG_PUB.ADD;

783: WHEN OTHERS THEN
784: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
785: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
786: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
787: FND_MSG_PUB.ADD;
788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
789: END;
790:
791:

Line 812: FND_MSG_PUB.ADD;

808: WHEN OTHERS THEN
809: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
810: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
811: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
812: FND_MSG_PUB.ADD;
813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
814: END;
815:
816:

Line 832: FND_MSG_PUB.ADD;

828: WHEN OTHERS THEN
829: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
830: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
831: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
832: FND_MSG_PUB.ADD;
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: END;
835:
836:

Line 852: FND_MSG_PUB.ADD;

848: WHEN OTHERS THEN
849: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
850: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
852: FND_MSG_PUB.ADD;
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
854: END;
855:
856: PROCEDURE init_score_context (

Line 919: FND_MSG_PUB.ADD;

915: p_party_site_list,
916: p_contact_list,
917: p_contact_point_list) THEN
918: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
919: FND_MSG_PUB.ADD;
920: RAISE FND_API.G_EXC_ERROR;
921: END IF;
922: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
923: hz_utility_v2pub.debug(p_message=>'In init_search calling util package set_score',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 1190: FND_MSG_PUB.ADD;

1186: END IF;
1187: IF lengthb(l_party_contains_str) > 4000 THEN
1188: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1189: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1190: FND_MSG_PUB.ADD;
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;
1193: IF (p_match_str = ' AND ' OR p_party_max_score 1194: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1279: FND_MSG_PUB.ADD;

1275: -- Add the search criteria to query string
1276: IF lengthb(l_contains_str) > 4000 THEN
1277: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1278: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1279: FND_MSG_PUB.ADD;
1280: RAISE FND_API.G_EXC_ERROR;
1281: END IF;
1282: x_denorm_str := l_den_contains_str;
1283: RETURN l_contains_str;

Line 1573: FND_MSG_PUB.ADD;

1569: exception
1570: when others then
1571: if (instrb(SQLERRM,'DRG-51030')>0) then
1572: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1573: FND_MSG_PUB.ADD;
1574: RAISE FND_API.G_EXC_ERROR;
1575: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1576: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1577: FND_MSG_PUB.ADD;

Line 1577: FND_MSG_PUB.ADD;

1573: FND_MSG_PUB.ADD;
1574: RAISE FND_API.G_EXC_ERROR;
1575: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1576: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1577: FND_MSG_PUB.ADD;
1578: RAISE FND_API.G_EXC_ERROR;
1579: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1580: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1581: FND_MSG_PUB.ADD;

Line 1581: FND_MSG_PUB.ADD;

1577: FND_MSG_PUB.ADD;
1578: RAISE FND_API.G_EXC_ERROR;
1579: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1580: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1581: FND_MSG_PUB.ADD;
1582: RAISE FND_API.G_EXC_ERROR;
1583: else
1584: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1585: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1586: FND_MSG_PUB.ADD;

1582: RAISE FND_API.G_EXC_ERROR;
1583: else
1584: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1585: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1586: FND_MSG_PUB.ADD;
1587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1588: end if;
1589: END;
1590:

Line 1818: FND_MSG_PUB.ADD;

1814: exception
1815: when others then
1816: if (instrb(SQLERRM,'DRG-51030')>0) then
1817: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1818: FND_MSG_PUB.ADD;
1819: RAISE FND_API.G_EXC_ERROR;
1820: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1821: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1822: FND_MSG_PUB.ADD;

Line 1822: FND_MSG_PUB.ADD;

1818: FND_MSG_PUB.ADD;
1819: RAISE FND_API.G_EXC_ERROR;
1820: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1821: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1822: FND_MSG_PUB.ADD;
1823: RAISE FND_API.G_EXC_ERROR;
1824: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1825: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1826: FND_MSG_PUB.ADD;

Line 1826: FND_MSG_PUB.ADD;

1822: FND_MSG_PUB.ADD;
1823: RAISE FND_API.G_EXC_ERROR;
1824: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1825: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1826: FND_MSG_PUB.ADD;
1827: RAISE FND_API.G_EXC_ERROR;
1828: else
1829: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1830: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1831: FND_MSG_PUB.ADD;

1827: RAISE FND_API.G_EXC_ERROR;
1828: else
1829: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1830: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1831: FND_MSG_PUB.ADD;
1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1833: end if;
1834: END;
1835:

Line 1965: FND_MSG_PUB.ADD;

1961: exception
1962: when others then
1963: if (instrb(SQLERRM,'DRG-51030')>0) then
1964: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1965: FND_MSG_PUB.ADD;
1966: RAISE FND_API.G_EXC_ERROR;
1967: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1969: FND_MSG_PUB.ADD;

Line 1969: FND_MSG_PUB.ADD;

1965: FND_MSG_PUB.ADD;
1966: RAISE FND_API.G_EXC_ERROR;
1967: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1969: FND_MSG_PUB.ADD;
1970: RAISE FND_API.G_EXC_ERROR;
1971: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1973: FND_MSG_PUB.ADD;

Line 1973: FND_MSG_PUB.ADD;

1969: FND_MSG_PUB.ADD;
1970: RAISE FND_API.G_EXC_ERROR;
1971: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1973: FND_MSG_PUB.ADD;
1974: RAISE FND_API.G_EXC_ERROR;
1975: else
1976: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1977: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1978: FND_MSG_PUB.ADD;

1974: RAISE FND_API.G_EXC_ERROR;
1975: else
1976: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1977: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1978: FND_MSG_PUB.ADD;
1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1980: end if;
1981: END;
1982:

Line 2238: FND_MSG_PUB.ADD;

2234: exception
2235: when others then
2236: if (instrb(SQLERRM,'DRG-51030')>0) then
2237: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2238: FND_MSG_PUB.ADD;
2239: RAISE FND_API.G_EXC_ERROR;
2240: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2241: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2242: FND_MSG_PUB.ADD;

Line 2242: FND_MSG_PUB.ADD;

2238: FND_MSG_PUB.ADD;
2239: RAISE FND_API.G_EXC_ERROR;
2240: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2241: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2242: FND_MSG_PUB.ADD;
2243: RAISE FND_API.G_EXC_ERROR;
2244: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2245: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2246: FND_MSG_PUB.ADD;

Line 2246: FND_MSG_PUB.ADD;

2242: FND_MSG_PUB.ADD;
2243: RAISE FND_API.G_EXC_ERROR;
2244: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2245: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2246: FND_MSG_PUB.ADD;
2247: RAISE FND_API.G_EXC_ERROR;
2248: else
2249: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2251: FND_MSG_PUB.ADD;

2247: RAISE FND_API.G_EXC_ERROR;
2248: else
2249: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2251: FND_MSG_PUB.ADD;
2252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2253: end if;
2254: END;
2255:

Line 2506: FND_MSG_PUB.ADD;

2502: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2503: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2504: END IF;
2505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2506: FND_MSG_PUB.ADD;
2507: RAISE FND_API.G_EXC_ERROR;
2508: ELSE
2509: push_eval;
2510: RETURN;

Line 2554: FND_MSG_PUB.ADD;

2550: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2551: hz_utility_v2pub.debug(p_message=>'In eval party level estimated hits exceed threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2552: END IF;
2553: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2554: FND_MSG_PUB.ADD;
2555: RAISE FND_API.G_EXC_ERROR;
2556: ELSE
2557: push_eval;
2558: RETURN;

Line 2627: FND_MSG_PUB.ADD;

2623: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2624: hz_utility_v2pub.debug(p_message=>'In eval party site level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2625: END IF;
2626: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2627: FND_MSG_PUB.ADD;
2628: RAISE FND_API.G_EXC_ERROR;
2629: ELSE
2630: push_eval;
2631: RETURN;

Line 2739: FND_MSG_PUB.ADD;

2735: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2736: hz_utility_v2pub.debug(p_message=>'In eval contact level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2737: END IF;
2738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2739: FND_MSG_PUB.ADD;
2740: RAISE FND_API.G_EXC_ERROR;
2741: ELSE
2742: push_eval;
2743: RETURN;

Line 2850: FND_MSG_PUB.ADD;

2846: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2847: hz_utility_v2pub.debug(p_message=>'In eval contact point level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2848: END IF;
2849: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2850: FND_MSG_PUB.ADD;
2851: RAISE FND_API.G_EXC_ERROR;
2852: ELSE
2853: push_eval;
2854: RETURN;

Line 3075: FND_MSG_PUB.ADD;

3071: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3072: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3073: END IF;
3074: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3075: FND_MSG_PUB.ADD;
3076: RAISE FND_API.G_EXC_ERROR;
3077: END IF;
3078: ELSE
3079: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3083: FND_MSG_PUB.ADD;

3079: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3080: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3081: END IF;
3082: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3083: FND_MSG_PUB.ADD;
3084: RAISE FND_API.G_EXC_ERROR;
3085: END IF;
3086: END IF;
3087: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3291: FND_MSG_PUB.ADD;

3287: WHEN OTHERS THEN
3288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_parties');
3290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3291: FND_MSG_PUB.ADD;
3292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3293: END find_parties;
3294:
3295: PROCEDURE find_persons (

Line 3486: FND_MSG_PUB.ADD;

3482: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3483: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3484: END IF;
3485: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3486: FND_MSG_PUB.ADD;
3487: RAISE FND_API.G_EXC_ERROR;
3488: ELSE
3489: push_eval;
3490: RETURN;

Line 3534: FND_MSG_PUB.ADD;

3530: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3531: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3532: END IF;
3533: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3534: FND_MSG_PUB.ADD;
3535: RAISE FND_API.G_EXC_ERROR;
3536: ELSE
3537: push_eval;
3538: RETURN;

Line 3570: FND_MSG_PUB.ADD;

3566: exception
3567: when others then
3568: if (instrb(SQLERRM,'DRG-51030')>0) then
3569: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3570: FND_MSG_PUB.ADD;
3571: RAISE FND_API.G_EXC_ERROR;
3572: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3573: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3574: FND_MSG_PUB.ADD;

Line 3574: FND_MSG_PUB.ADD;

3570: FND_MSG_PUB.ADD;
3571: RAISE FND_API.G_EXC_ERROR;
3572: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3573: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3574: FND_MSG_PUB.ADD;
3575: RAISE FND_API.G_EXC_ERROR;
3576: else
3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3578: end if;

Line 3646: FND_MSG_PUB.ADD;

3642: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3643: hz_utility_v2pub.debug(p_message=>'In eval party site level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3644: END IF;
3645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3646: FND_MSG_PUB.ADD;
3647: RAISE FND_API.G_EXC_ERROR;
3648: ELSE
3649: push_eval;
3650: RETURN;

Line 3905: FND_MSG_PUB.ADD;

3901: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3902: hz_utility_v2pub.debug(p_message=>'In eval contact point level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3903: END IF;
3904: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3905: FND_MSG_PUB.ADD;
3906: RAISE FND_API.G_EXC_ERROR;
3907: ELSE
3908: push_eval;
3909: RETURN;

Line 4018: FND_MSG_PUB.ADD;

4014: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4015: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4016: END IF;
4017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4018: FND_MSG_PUB.ADD;
4019: RAISE FND_API.G_EXC_ERROR;
4020: END IF;
4021: ELSE
4022: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4026: FND_MSG_PUB.ADD;

4022: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4023: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4024: END IF;
4025: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4026: FND_MSG_PUB.ADD;
4027: RAISE FND_API.G_EXC_ERROR;
4028: END IF;
4029: END IF;
4030: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4149: FND_MSG_PUB.ADD;

4145: WHEN OTHERS THEN
4146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4147: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_persons');
4148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4149: FND_MSG_PUB.ADD;
4150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4151: END find_persons;
4152:
4153: PROCEDURE find_persons (

Line 4217: FND_MSG_PUB.ADD;

4213: WHEN OTHERS THEN
4214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4215: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_party_details');
4216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4217: FND_MSG_PUB.ADD;
4218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4219: END find_party_details;
4220:
4221: PROCEDURE find_duplicate_parties (

Line 4334: FND_MSG_PUB.ADD;

4330: WHEN OTHERS THEN
4331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4332: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_parties');
4333: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4334: FND_MSG_PUB.ADD;
4335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4336: END find_duplicate_parties;
4337:
4338: PROCEDURE find_duplicate_party_sites (

Line 4419: FND_MSG_PUB.ADD;

4415: WHEN OTHERS THEN
4416: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4417: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_party_sites');
4418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4419: FND_MSG_PUB.ADD;
4420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4421: END find_duplicate_party_sites;
4422:
4423: PROCEDURE find_duplicate_contacts (

Line 4508: FND_MSG_PUB.ADD;

4504: WHEN OTHERS THEN
4505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4506: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contacts');
4507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4508: FND_MSG_PUB.ADD;
4509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4510: END find_duplicate_contacts;
4511:
4512: PROCEDURE find_duplicate_contact_points (

Line 4581: FND_MSG_PUB.ADD;

4577: WHEN OTHERS THEN
4578: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4579: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contact_points');
4580: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4581: FND_MSG_PUB.ADD;
4582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4583: END find_duplicate_contact_points;
4584:
4585: PROCEDURE find_parties_dynamic (

Line 4869: FND_MSG_PUB.ADD;

4865: WHEN OTHERS THEN
4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.call_api_dynamic');
4868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4869: FND_MSG_PUB.ADD;
4870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4871: END call_api_dynamic;
4872:
4873:

Line 5107: FND_MSG_PUB.ADD;

5103: WHEN OTHERS THEN
5104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5105: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_party_sites');
5106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5107: FND_MSG_PUB.ADD;
5108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5109: END get_matching_party_sites;
5110:
5111:

Line 5332: FND_MSG_PUB.ADD;

5328: WHEN OTHERS THEN
5329: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5330: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contacts');
5331: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5332: FND_MSG_PUB.ADD;
5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5334: END get_matching_contacts;
5335:
5336:

Line 5471: FND_MSG_PUB.ADD;

5467: WHEN OTHERS THEN
5468: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5469: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contact_points');
5470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5471: FND_MSG_PUB.ADD;
5472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5473: END get_matching_contact_points;
5474:
5475: /**********************************************************

Line 5689: FND_MSG_PUB.ADD;

5685: WHEN OTHERS THEN
5686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5687: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_score_details');
5688: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5689: FND_MSG_PUB.ADD;
5690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5691: END get_score_details;
5692:
5693:

Line 5767: FND_MSG_PUB.ADD;

5763: WHEN OTHERS THEN
5764: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5765: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5766: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5767: FND_MSG_PUB.ADD;
5768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5769: END get_party_for_search;
5770:
5771: PROCEDURE get_search_criteria (

Line 5807: FND_MSG_PUB.ADD;

5803: WHEN OTHERS THEN
5804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5805: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5807: FND_MSG_PUB.ADD;
5808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5809: END get_search_criteria;
5810:
5811:

Line 5872: FND_MSG_PUB.ADD;

5868: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5869: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5870: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5871: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5872: FND_MSG_PUB.ADD;
5873: RAISE FND_API.G_EXC_ERROR;
5874: END get_party_rec;
5875:
5876: /************************************************

Line 5932: FND_MSG_PUB.ADD;

5928: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5929: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5930: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5931: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5932: FND_MSG_PUB.ADD;
5933: RAISE FND_API.G_EXC_ERROR;
5934: END get_party_site_rec;
5935:
5936: /************************************************

Line 5988: FND_MSG_PUB.ADD;

5984: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5985: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5986: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5987: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5988: FND_MSG_PUB.ADD;
5989: RAISE FND_API.G_EXC_ERROR;
5990: END get_contact_rec;
5991:
5992: /************************************************

Line 6040: FND_MSG_PUB.ADD;

6036: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6037: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6038: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6040: FND_MSG_PUB.ADD;
6041: RAISE FND_API.G_EXC_ERROR;
6042: END get_contact_point_rec;
6043:
6044: /************************************************

Line 6193: FND_MSG_PUB.ADD;

6189: WHEN OTHERS THEN
6190: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6191: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6192: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6193: FND_MSG_PUB.ADD;
6194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6195: END;
6196:
6197:

Line 6356: FND_MSG_PUB.ADD;

6352: WHEN OTHERS THEN
6353: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6354: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6355: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6356: FND_MSG_PUB.ADD;
6357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6358: END;
6359:
6360:

Line 6398: FND_MSG_PUB.ADD;

6394: WHEN OTHERS THEN
6395: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6396: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6398: FND_MSG_PUB.ADD;
6399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6400: END;
6401:
6402:

Line 6465: FND_MSG_PUB.ADD;

6461: WHEN OTHERS THEN
6462: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6463: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6464: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6465: FND_MSG_PUB.ADD;
6466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6467: END;
6468:
6469:

Line 6524: FND_MSG_PUB.ADD;

6520: WHEN OTHERS THEN
6521: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6522: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6523: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6524: FND_MSG_PUB.ADD;
6525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6526: END check_prim_cond;
6527:
6528: /************************************************

Line 6574: FND_MSG_PUB.ADD;

6570: WHEN OTHERS THEN
6571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6572: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6573: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6574: FND_MSG_PUB.ADD;
6575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6576: END check_party_site_cond;
6577:
6578: /************************************************

Line 6612: FND_MSG_PUB.ADD;

6608: WHEN OTHERS THEN
6609: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6610: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6611: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6612: FND_MSG_PUB.ADD;
6613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6614: END check_contact_cond;
6615:
6616: /************************************************

Line 6633: FND_MSG_PUB.ADD;

6629:
6630: FOR I IN 1..p_contact_point_list.COUNT LOOP
6631: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6632: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6633: FND_MSG_PUB.ADD;
6634: RAISE FND_API.G_EXC_ERROR;
6635: END IF;
6636: END LOOP;
6637:

Line 6649: FND_MSG_PUB.ADD;

6645: WHEN OTHERS THEN
6646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6647: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6648: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6649: FND_MSG_PUB.ADD;
6650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6651: END check_contact_point_cond;
6652:
6653: FUNCTION check_staged RETURN BOOLEAN IS