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 1575: FND_MSG_PUB.ADD;

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

Line 1579: FND_MSG_PUB.ADD;

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

Line 1583: FND_MSG_PUB.ADD;

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

Line 1588: FND_MSG_PUB.ADD;

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

Line 1820: FND_MSG_PUB.ADD;

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

Line 1824: FND_MSG_PUB.ADD;

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

Line 1828: FND_MSG_PUB.ADD;

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

Line 1833: FND_MSG_PUB.ADD;

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

Line 1967: FND_MSG_PUB.ADD;

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

Line 1971: FND_MSG_PUB.ADD;

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

Line 1975: FND_MSG_PUB.ADD;

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

Line 1980: FND_MSG_PUB.ADD;

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

Line 2240: FND_MSG_PUB.ADD;

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

Line 2244: FND_MSG_PUB.ADD;

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

Line 2248: FND_MSG_PUB.ADD;

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

Line 2253: FND_MSG_PUB.ADD;

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

Line 2509: FND_MSG_PUB.ADD;

2505: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2506: 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);
2507: END IF;
2508: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2509: FND_MSG_PUB.ADD;
2510: RAISE FND_API.G_EXC_ERROR;
2511: ELSE
2512: push_eval;
2513: RETURN;

Line 2557: FND_MSG_PUB.ADD;

2553: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2554: 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);
2555: END IF;
2556: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2557: FND_MSG_PUB.ADD;
2558: RAISE FND_API.G_EXC_ERROR;
2559: ELSE
2560: push_eval;
2561: RETURN;

Line 2630: FND_MSG_PUB.ADD;

2626: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2627: 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);
2628: END IF;
2629: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2630: FND_MSG_PUB.ADD;
2631: RAISE FND_API.G_EXC_ERROR;
2632: ELSE
2633: push_eval;
2634: RETURN;

Line 2742: FND_MSG_PUB.ADD;

2738: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2739: 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);
2740: END IF;
2741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2742: FND_MSG_PUB.ADD;
2743: RAISE FND_API.G_EXC_ERROR;
2744: ELSE
2745: push_eval;
2746: RETURN;

Line 2853: FND_MSG_PUB.ADD;

2849: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2850: 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);
2851: END IF;
2852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2853: FND_MSG_PUB.ADD;
2854: RAISE FND_API.G_EXC_ERROR;
2855: ELSE
2856: push_eval;
2857: RETURN;

Line 3078: FND_MSG_PUB.ADD;

3074: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3075: 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);
3076: END IF;
3077: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3078: FND_MSG_PUB.ADD;
3079: RAISE FND_API.G_EXC_ERROR;
3080: END IF;
3081: ELSE
3082: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3086: FND_MSG_PUB.ADD;

3082: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3083: 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);
3084: END IF;
3085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3086: FND_MSG_PUB.ADD;
3087: RAISE FND_API.G_EXC_ERROR;
3088: END IF;
3089: END IF;
3090: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3294: FND_MSG_PUB.ADD;

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

Line 3490: FND_MSG_PUB.ADD;

3486: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3487: 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);
3488: END IF;
3489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3490: FND_MSG_PUB.ADD;
3491: RAISE FND_API.G_EXC_ERROR;
3492: ELSE
3493: push_eval;
3494: RETURN;

Line 3538: FND_MSG_PUB.ADD;

3534: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3535: 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);
3536: END IF;
3537: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3538: FND_MSG_PUB.ADD;
3539: RAISE FND_API.G_EXC_ERROR;
3540: ELSE
3541: push_eval;
3542: RETURN;

Line 3574: FND_MSG_PUB.ADD;

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

Line 3578: FND_MSG_PUB.ADD;

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

Line 3650: FND_MSG_PUB.ADD;

3646: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3647: 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);
3648: END IF;
3649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3650: FND_MSG_PUB.ADD;
3651: RAISE FND_API.G_EXC_ERROR;
3652: ELSE
3653: push_eval;
3654: RETURN;

Line 3909: FND_MSG_PUB.ADD;

3905: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3906: 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);
3907: END IF;
3908: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3909: FND_MSG_PUB.ADD;
3910: RAISE FND_API.G_EXC_ERROR;
3911: ELSE
3912: push_eval;
3913: RETURN;

Line 4022: FND_MSG_PUB.ADD;

4018: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4019: 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);
4020: END IF;
4021: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4022: FND_MSG_PUB.ADD;
4023: RAISE FND_API.G_EXC_ERROR;
4024: END IF;
4025: ELSE
4026: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4030: FND_MSG_PUB.ADD;

4026: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4027: 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);
4028: END IF;
4029: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4030: FND_MSG_PUB.ADD;
4031: RAISE FND_API.G_EXC_ERROR;
4032: END IF;
4033: END IF;
4034: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4153: FND_MSG_PUB.ADD;

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

Line 4221: FND_MSG_PUB.ADD;

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

Line 4338: FND_MSG_PUB.ADD;

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

Line 4423: FND_MSG_PUB.ADD;

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

Line 4512: FND_MSG_PUB.ADD;

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

Line 4585: FND_MSG_PUB.ADD;

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

Line 4873: FND_MSG_PUB.ADD;

4869: WHEN OTHERS THEN
4870: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4871: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.call_api_dynamic');
4872: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4873: FND_MSG_PUB.ADD;
4874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4875: END call_api_dynamic;
4876:
4877:

Line 5111: FND_MSG_PUB.ADD;

5107: WHEN OTHERS THEN
5108: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5109: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_party_sites');
5110: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5111: FND_MSG_PUB.ADD;
5112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5113: END get_matching_party_sites;
5114:
5115:

Line 5336: FND_MSG_PUB.ADD;

5332: WHEN OTHERS THEN
5333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5334: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contacts');
5335: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5336: FND_MSG_PUB.ADD;
5337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5338: END get_matching_contacts;
5339:
5340:

Line 5475: FND_MSG_PUB.ADD;

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

Line 5694: FND_MSG_PUB.ADD;

5690: WHEN OTHERS THEN
5691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5692: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_score_details');
5693: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5694: FND_MSG_PUB.ADD;
5695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5696: END get_score_details;
5697:
5698:

Line 5772: FND_MSG_PUB.ADD;

5768: WHEN OTHERS THEN
5769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5770: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5771: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5772: FND_MSG_PUB.ADD;
5773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5774: END get_party_for_search;
5775:
5776: PROCEDURE get_search_criteria (

Line 5812: FND_MSG_PUB.ADD;

5808: WHEN OTHERS THEN
5809: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5810: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5811: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5812: FND_MSG_PUB.ADD;
5813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5814: END get_search_criteria;
5815:
5816:

Line 5877: FND_MSG_PUB.ADD;

5873: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5874: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5875: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5876: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5877: FND_MSG_PUB.ADD;
5878: RAISE FND_API.G_EXC_ERROR;
5879: END get_party_rec;
5880:
5881: /************************************************

Line 5937: FND_MSG_PUB.ADD;

5933: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5934: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5935: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5936: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5937: FND_MSG_PUB.ADD;
5938: RAISE FND_API.G_EXC_ERROR;
5939: END get_party_site_rec;
5940:
5941: /************************************************

Line 5993: FND_MSG_PUB.ADD;

5989: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5990: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5991: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5992: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5993: FND_MSG_PUB.ADD;
5994: RAISE FND_API.G_EXC_ERROR;
5995: END get_contact_rec;
5996:
5997: /************************************************

Line 6045: FND_MSG_PUB.ADD;

6041: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6042: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6043: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6045: FND_MSG_PUB.ADD;
6046: RAISE FND_API.G_EXC_ERROR;
6047: END get_contact_point_rec;
6048:
6049: /************************************************

Line 6198: FND_MSG_PUB.ADD;

6194: WHEN OTHERS THEN
6195: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6196: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6198: FND_MSG_PUB.ADD;
6199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6200: END;
6201:
6202:

Line 6361: FND_MSG_PUB.ADD;

6357: WHEN OTHERS THEN
6358: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6359: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6360: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6361: FND_MSG_PUB.ADD;
6362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6363: END;
6364:
6365:

Line 6403: FND_MSG_PUB.ADD;

6399: WHEN OTHERS THEN
6400: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6401: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6402: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6403: FND_MSG_PUB.ADD;
6404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6405: END;
6406:
6407:

Line 6470: FND_MSG_PUB.ADD;

6466: WHEN OTHERS THEN
6467: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6468: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6469: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6470: FND_MSG_PUB.ADD;
6471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6472: END;
6473:
6474:

Line 6529: FND_MSG_PUB.ADD;

6525: WHEN OTHERS THEN
6526: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6527: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6528: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6529: FND_MSG_PUB.ADD;
6530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6531: END check_prim_cond;
6532:
6533: /************************************************

Line 6579: FND_MSG_PUB.ADD;

6575: WHEN OTHERS THEN
6576: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6577: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6578: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6579: FND_MSG_PUB.ADD;
6580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6581: END check_party_site_cond;
6582:
6583: /************************************************

Line 6617: FND_MSG_PUB.ADD;

6613: WHEN OTHERS THEN
6614: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6615: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6616: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6617: FND_MSG_PUB.ADD;
6618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6619: END check_contact_cond;
6620:
6621: /************************************************

Line 6638: FND_MSG_PUB.ADD;

6634:
6635: FOR I IN 1..p_contact_point_list.COUNT LOOP
6636: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6637: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6638: FND_MSG_PUB.ADD;
6639: RAISE FND_API.G_EXC_ERROR;
6640: END IF;
6641: END LOOP;
6642:

Line 6654: FND_MSG_PUB.ADD;

6650: WHEN OTHERS THEN
6651: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6652: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6654: FND_MSG_PUB.ADD;
6655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6656: END check_contact_point_cond;
6657:
6658: FUNCTION check_staged RETURN BOOLEAN IS