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_4 dependencies on FND_MESSAGE

Line 100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

96:
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');

Line 104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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;
106: RAISE FND_API.G_EXC_ERROR;
107: else
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 589: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

585: BEGIN
586: NULL ;
587: EXCEPTION
588: WHEN OTHERS THEN
589: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
590: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
592: FND_MSG_PUB.ADD;
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 590: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');

586: NULL ;
587: EXCEPTION
588: WHEN OTHERS THEN
589: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
590: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
592: FND_MSG_PUB.ADD;
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END;

Line 591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

587: EXCEPTION
588: WHEN OTHERS THEN
589: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
590: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
592: FND_MSG_PUB.ADD;
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END;
595:

Line 609: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

605: BEGIN
606: NULL ;
607: EXCEPTION
608: WHEN OTHERS THEN
609: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
610: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
611: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
612: FND_MSG_PUB.ADD;
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 610: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');

606: NULL ;
607: EXCEPTION
608: WHEN OTHERS THEN
609: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
610: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
611: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
612: FND_MSG_PUB.ADD;
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: END;

Line 611: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

607: EXCEPTION
608: WHEN OTHERS THEN
609: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
610: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
611: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
612: FND_MSG_PUB.ADD;
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: END;
615:

Line 629: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

625: BEGIN
626: NULL ;
627: EXCEPTION
628: WHEN OTHERS THEN
629: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
630: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
631: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
632: FND_MSG_PUB.ADD;
633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 630: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');

626: NULL ;
627: EXCEPTION
628: WHEN OTHERS THEN
629: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
630: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
631: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
632: FND_MSG_PUB.ADD;
633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
634: END;

Line 631: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

627: EXCEPTION
628: WHEN OTHERS THEN
629: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
630: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
631: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
632: FND_MSG_PUB.ADD;
633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
634: END;
635:

Line 649: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

645: BEGIN
646: NULL ;
647: EXCEPTION
648: WHEN OTHERS THEN
649: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
650: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
652: FND_MSG_PUB.ADD;
653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 650: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');

646: NULL ;
647: EXCEPTION
648: WHEN OTHERS THEN
649: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
650: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
652: FND_MSG_PUB.ADD;
653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
654: END;

Line 651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

647: EXCEPTION
648: WHEN OTHERS THEN
649: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
650: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
652: FND_MSG_PUB.ADD;
653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
654: END;
655:

Line 718: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');

714: IF NOT check_prim_cond (p_party_search_rec,
715: p_party_site_list,
716: p_contact_list,
717: p_contact_point_list) THEN
718: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
719: FND_MSG_PUB.ADD;
720: RAISE FND_API.G_EXC_ERROR;
721: END IF;
722: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 935: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

931: ELSE
932: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
933: END IF;
934: IF lengthb(l_party_contains_str) > 4000 THEN
935: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
936: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
937: FND_MSG_PUB.ADD;
938: RAISE FND_API.G_EXC_ERROR;
939: END IF;

Line 936: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

932: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
933: END IF;
934: IF lengthb(l_party_contains_str) > 4000 THEN
935: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
936: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
937: FND_MSG_PUB.ADD;
938: RAISE FND_API.G_EXC_ERROR;
939: END IF;
940: IF (p_match_str = ' AND ' OR p_party_max_score

Line 997: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

993: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
994: END LOOP;
995: -- Add the search criteria to query string
996: IF lengthb(l_contains_str) > 4000 THEN
997: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
998: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
999: FND_MSG_PUB.ADD;
1000: RAISE FND_API.G_EXC_ERROR;
1001: END IF;

Line 998: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');

994: END LOOP;
995: -- Add the search criteria to query string
996: IF lengthb(l_contains_str) > 4000 THEN
997: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
998: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
999: FND_MSG_PUB.ADD;
1000: RAISE FND_API.G_EXC_ERROR;
1001: END IF;
1002: x_denorm_str := l_den_contains_str;

Line 1247: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

1243: END IF;
1244: exception
1245: when others then
1246: if (instrb(SQLERRM,'DRG-51030')>0) then
1247: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1248: FND_MSG_PUB.ADD;
1249: RAISE FND_API.G_EXC_ERROR;
1250: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1251: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1251: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1247: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1248: FND_MSG_PUB.ADD;
1249: RAISE FND_API.G_EXC_ERROR;
1250: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1251: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1252: FND_MSG_PUB.ADD;
1253: RAISE FND_API.G_EXC_ERROR;
1254: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1255: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1255: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1251: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1252: FND_MSG_PUB.ADD;
1253: RAISE FND_API.G_EXC_ERROR;
1254: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1255: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1256: FND_MSG_PUB.ADD;
1257: RAISE FND_API.G_EXC_ERROR;
1258: else
1259: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 1259: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1255: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1256: FND_MSG_PUB.ADD;
1257: RAISE FND_API.G_EXC_ERROR;
1258: else
1259: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1261: FND_MSG_PUB.ADD;
1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1263: end if;

Line 1260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1256: FND_MSG_PUB.ADD;
1257: RAISE FND_API.G_EXC_ERROR;
1258: else
1259: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1261: FND_MSG_PUB.ADD;
1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1263: end if;
1264: END;

Line 1492: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

1488: output_long_strings('Restrict Sql = '||p_restrict_sql);
1489: exception
1490: when others then
1491: if (instrb(SQLERRM,'DRG-51030')>0) then
1492: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1493: FND_MSG_PUB.ADD;
1494: RAISE FND_API.G_EXC_ERROR;
1495: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1492: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1493: FND_MSG_PUB.ADD;
1494: RAISE FND_API.G_EXC_ERROR;
1495: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1497: FND_MSG_PUB.ADD;
1498: RAISE FND_API.G_EXC_ERROR;
1499: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1497: FND_MSG_PUB.ADD;
1498: RAISE FND_API.G_EXC_ERROR;
1499: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1501: FND_MSG_PUB.ADD;
1502: RAISE FND_API.G_EXC_ERROR;
1503: else
1504: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 1504: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1501: FND_MSG_PUB.ADD;
1502: RAISE FND_API.G_EXC_ERROR;
1503: else
1504: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1505: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1506: FND_MSG_PUB.ADD;
1507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1508: end if;

Line 1505: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1501: FND_MSG_PUB.ADD;
1502: RAISE FND_API.G_EXC_ERROR;
1503: else
1504: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1505: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1506: FND_MSG_PUB.ADD;
1507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1508: end if;
1509: END;

Line 1639: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

1635: output_long_strings('Restrict Sql = '||p_restrict_sql);
1636: exception
1637: when others then
1638: if (instrb(SQLERRM,'DRG-51030')>0) then
1639: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1640: FND_MSG_PUB.ADD;
1641: RAISE FND_API.G_EXC_ERROR;
1642: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1643: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1643: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1639: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1640: FND_MSG_PUB.ADD;
1641: RAISE FND_API.G_EXC_ERROR;
1642: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1643: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1644: FND_MSG_PUB.ADD;
1645: RAISE FND_API.G_EXC_ERROR;
1646: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1647: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1647: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1643: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1644: FND_MSG_PUB.ADD;
1645: RAISE FND_API.G_EXC_ERROR;
1646: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1647: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1648: FND_MSG_PUB.ADD;
1649: RAISE FND_API.G_EXC_ERROR;
1650: else
1651: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 1651: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1647: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1648: FND_MSG_PUB.ADD;
1649: RAISE FND_API.G_EXC_ERROR;
1650: else
1651: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1652: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1653: FND_MSG_PUB.ADD;
1654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1655: end if;

Line 1652: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1648: FND_MSG_PUB.ADD;
1649: RAISE FND_API.G_EXC_ERROR;
1650: else
1651: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1652: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1653: FND_MSG_PUB.ADD;
1654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1655: end if;
1656: END;

Line 1912: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

1908: output_long_strings('Restrict Sql = '||p_restrict_sql);
1909: exception
1910: when others then
1911: if (instrb(SQLERRM,'DRG-51030')>0) then
1912: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1913: FND_MSG_PUB.ADD;
1914: RAISE FND_API.G_EXC_ERROR;
1915: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1916: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1916: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1912: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1913: FND_MSG_PUB.ADD;
1914: RAISE FND_API.G_EXC_ERROR;
1915: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1916: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1917: FND_MSG_PUB.ADD;
1918: RAISE FND_API.G_EXC_ERROR;
1919: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1920: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1920: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1916: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1917: FND_MSG_PUB.ADD;
1918: RAISE FND_API.G_EXC_ERROR;
1919: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1920: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1921: FND_MSG_PUB.ADD;
1922: RAISE FND_API.G_EXC_ERROR;
1923: else
1924: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 1924: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1920: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1921: FND_MSG_PUB.ADD;
1922: RAISE FND_API.G_EXC_ERROR;
1923: else
1924: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1925: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1926: FND_MSG_PUB.ADD;
1927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1928: end if;

Line 1925: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1921: FND_MSG_PUB.ADD;
1922: RAISE FND_API.G_EXC_ERROR;
1923: else
1924: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1925: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1926: FND_MSG_PUB.ADD;
1927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1928: end if;
1929: END;

Line 2174: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2170: IF p_index>1 THEN
2171: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2172: 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);
2173: END IF;
2174: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2175: FND_MSG_PUB.ADD;
2176: RAISE FND_API.G_EXC_ERROR;
2177: ELSE
2178: push_eval;

Line 2222: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2218: IF p_index>1 THEN
2219: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2220: 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);
2221: END IF;
2222: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2223: FND_MSG_PUB.ADD;
2224: RAISE FND_API.G_EXC_ERROR;
2225: ELSE
2226: push_eval;

Line 2295: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2291: IF p_index>1 THEN
2292: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2293: 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);
2294: END IF;
2295: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2296: FND_MSG_PUB.ADD;
2297: RAISE FND_API.G_EXC_ERROR;
2298: ELSE
2299: push_eval;

Line 2407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2403: IF p_index>1 THEN
2404: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2405: 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);
2406: END IF;
2407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2408: FND_MSG_PUB.ADD;
2409: RAISE FND_API.G_EXC_ERROR;
2410: ELSE
2411: push_eval;

Line 2518: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2514: IF p_index>1 THEN
2515: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2516: 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);
2517: END IF;
2518: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2519: FND_MSG_PUB.ADD;
2520: RAISE FND_API.G_EXC_ERROR;
2521: ELSE
2522: push_eval;

Line 2662: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2658: ELSE
2659: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2660: 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);
2661: END IF;
2662: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2663: FND_MSG_PUB.ADD;
2664: RAISE FND_API.G_EXC_ERROR;
2665: END IF;
2666: ELSE

Line 2670: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2666: ELSE
2667: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2668: 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);
2669: END IF;
2670: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2671: FND_MSG_PUB.ADD;
2672: RAISE FND_API.G_EXC_ERROR;
2673: END IF;
2674: END IF;

Line 2919: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

2915: RAISE FND_API.G_EXC_ERROR;
2916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: WHEN OTHERS THEN
2919: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2920: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_parties');
2921: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2922: FND_MSG_PUB.ADD;
2923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2920: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_parties');

2916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: WHEN OTHERS THEN
2919: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2920: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_parties');
2921: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2922: FND_MSG_PUB.ADD;
2923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2924: END find_parties;

Line 2921: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: WHEN OTHERS THEN
2919: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2920: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_parties');
2921: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2922: FND_MSG_PUB.ADD;
2923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2924: END find_parties;
2925:

Line 3110: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3106: IF p_index>1 THEN
3107: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3108: 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);
3109: END IF;
3110: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3111: FND_MSG_PUB.ADD;
3112: RAISE FND_API.G_EXC_ERROR;
3113: ELSE
3114: push_eval;

Line 3158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3154: IF p_index>1 THEN
3155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3156: 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);
3157: END IF;
3158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3159: FND_MSG_PUB.ADD;
3160: RAISE FND_API.G_EXC_ERROR;
3161: ELSE
3162: push_eval;

Line 3194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

3190: and d.search_context_id = p_search_ctx_id);
3191: exception
3192: when others then
3193: if (instrb(SQLERRM,'DRG-51030')>0) then
3194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3195: FND_MSG_PUB.ADD;
3196: RAISE FND_API.G_EXC_ERROR;
3197: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 3198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

3194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3195: FND_MSG_PUB.ADD;
3196: RAISE FND_API.G_EXC_ERROR;
3197: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3199: FND_MSG_PUB.ADD;
3200: RAISE FND_API.G_EXC_ERROR;
3201: else
3202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3270: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3266: IF p_index>1 THEN
3267: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3268: 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);
3269: END IF;
3270: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3271: FND_MSG_PUB.ADD;
3272: RAISE FND_API.G_EXC_ERROR;
3273: ELSE
3274: push_eval;

Line 3459: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3455: IF p_index>1 THEN
3456: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3457: 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);
3458: END IF;
3459: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3460: FND_MSG_PUB.ADD;
3461: RAISE FND_API.G_EXC_ERROR;
3462: ELSE
3463: push_eval;

Line 3547: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3543: ELSE
3544: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3545: 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);
3546: END IF;
3547: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3548: FND_MSG_PUB.ADD;
3549: RAISE FND_API.G_EXC_ERROR;
3550: END IF;
3551: ELSE

Line 3555: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3551: ELSE
3552: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3553: 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);
3554: END IF;
3555: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3556: FND_MSG_PUB.ADD;
3557: RAISE FND_API.G_EXC_ERROR;
3558: END IF;
3559: END IF;

Line 3702: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

3698: RAISE FND_API.G_EXC_ERROR;
3699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3701: WHEN OTHERS THEN
3702: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3703: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_persons');
3704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3705: FND_MSG_PUB.ADD;
3706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3703: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_persons');

3699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3701: WHEN OTHERS THEN
3702: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3703: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_persons');
3704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3705: FND_MSG_PUB.ADD;
3706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3707: END find_persons;

Line 3704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

3700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3701: WHEN OTHERS THEN
3702: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3703: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_persons');
3704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3705: FND_MSG_PUB.ADD;
3706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3707: END find_persons;
3708:

Line 3770: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

3766: RAISE FND_API.G_EXC_ERROR;
3767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3769: WHEN OTHERS THEN
3770: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3771: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_party_details');
3772: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3773: FND_MSG_PUB.ADD;
3774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3771: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_party_details');

3767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3769: WHEN OTHERS THEN
3770: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3771: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_party_details');
3772: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3773: FND_MSG_PUB.ADD;
3774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3775: END find_party_details;

Line 3772: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

3768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3769: WHEN OTHERS THEN
3770: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3771: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_party_details');
3772: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3773: FND_MSG_PUB.ADD;
3774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3775: END find_party_details;
3776:

Line 3887: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

3883: RAISE FND_API.G_EXC_ERROR;
3884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3886: WHEN OTHERS THEN
3887: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3888: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_parties');
3889: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3890: FND_MSG_PUB.ADD;
3891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3888: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_parties');

3884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3886: WHEN OTHERS THEN
3887: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3888: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_parties');
3889: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3890: FND_MSG_PUB.ADD;
3891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3892: END find_duplicate_parties;

Line 3889: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

3885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3886: WHEN OTHERS THEN
3887: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3888: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_parties');
3889: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3890: FND_MSG_PUB.ADD;
3891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3892: END find_duplicate_parties;
3893:

Line 3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

3968: RAISE FND_API.G_EXC_ERROR;
3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN
3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_party_sites');
3974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3975: FND_MSG_PUB.ADD;
3976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_party_sites');

3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN
3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_party_sites');
3974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3975: FND_MSG_PUB.ADD;
3976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3977: END find_duplicate_party_sites;

Line 3974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN
3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_party_sites');
3974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3975: FND_MSG_PUB.ADD;
3976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3977: END find_duplicate_party_sites;
3978:

Line 4061: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4057: RAISE FND_API.G_EXC_ERROR;
4058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4060: WHEN OTHERS THEN
4061: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4062: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contacts');
4063: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4064: FND_MSG_PUB.ADD;
4065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4062: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contacts');

4058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4060: WHEN OTHERS THEN
4061: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4062: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contacts');
4063: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4064: FND_MSG_PUB.ADD;
4065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4066: END find_duplicate_contacts;

Line 4063: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

4059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4060: WHEN OTHERS THEN
4061: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4062: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contacts');
4063: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4064: FND_MSG_PUB.ADD;
4065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4066: END find_duplicate_contacts;
4067:

Line 4134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4130: RAISE FND_API.G_EXC_ERROR;
4131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4133: WHEN OTHERS THEN
4134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4135: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contact_points');
4136: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4137: FND_MSG_PUB.ADD;
4138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4135: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contact_points');

4131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4133: WHEN OTHERS THEN
4134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4135: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contact_points');
4136: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4137: FND_MSG_PUB.ADD;
4138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4139: END find_duplicate_contact_points;

Line 4136: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

4132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4133: WHEN OTHERS THEN
4134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4135: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contact_points');
4136: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4137: FND_MSG_PUB.ADD;
4138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4139: END find_duplicate_contact_points;
4140:

Line 4408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4404: RAISE FND_API.G_EXC_ERROR;
4405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4407: WHEN OTHERS THEN
4408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4409: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.call_api_dynamic');
4410: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4411: FND_MSG_PUB.ADD;
4412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4409: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.call_api_dynamic');

4405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4407: WHEN OTHERS THEN
4408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4409: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.call_api_dynamic');
4410: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4411: FND_MSG_PUB.ADD;
4412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4413: END call_api_dynamic;

Line 4410: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

4406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4407: WHEN OTHERS THEN
4408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4409: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.call_api_dynamic');
4410: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4411: FND_MSG_PUB.ADD;
4412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4413: END call_api_dynamic;
4414:

Line 4642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4638: RAISE FND_API.G_EXC_ERROR;
4639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4641: WHEN OTHERS THEN
4642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4643: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_party_sites');
4644: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4645: FND_MSG_PUB.ADD;
4646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4643: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_party_sites');

4639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4641: WHEN OTHERS THEN
4642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4643: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_party_sites');
4644: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4645: FND_MSG_PUB.ADD;
4646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4647: END get_matching_party_sites;

Line 4644: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

4640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4641: WHEN OTHERS THEN
4642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4643: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_party_sites');
4644: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4645: FND_MSG_PUB.ADD;
4646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4647: END get_matching_party_sites;
4648:

Line 4867: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4863: RAISE FND_API.G_EXC_ERROR;
4864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4866: WHEN OTHERS THEN
4867: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4868: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contacts');
4869: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4870: FND_MSG_PUB.ADD;
4871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4868: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contacts');

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

Line 4869: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

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

Line 5006: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5002: RAISE FND_API.G_EXC_ERROR;
5003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5005: WHEN OTHERS THEN
5006: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5007: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contact_points');
5008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5009: FND_MSG_PUB.ADD;
5010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5007: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contact_points');

5003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5005: WHEN OTHERS THEN
5006: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5007: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contact_points');
5008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5009: FND_MSG_PUB.ADD;
5010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5011: END get_matching_contact_points;

Line 5008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5005: WHEN OTHERS THEN
5006: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5007: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contact_points');
5008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5009: FND_MSG_PUB.ADD;
5010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5011: END get_matching_contact_points;
5012:

Line 5208: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5204: RAISE FND_API.G_EXC_ERROR;
5205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5207: WHEN OTHERS THEN
5208: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5209: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_score_details');
5210: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5211: FND_MSG_PUB.ADD;
5212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5209: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_score_details');

5205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5207: WHEN OTHERS THEN
5208: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5209: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_score_details');
5210: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5211: FND_MSG_PUB.ADD;
5212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5213: END get_score_details;

Line 5210: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5207: WHEN OTHERS THEN
5208: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5209: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_score_details');
5210: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5211: FND_MSG_PUB.ADD;
5212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5213: END get_score_details;
5214:

Line 5286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5282: RAISE FND_API.G_EXC_ERROR;
5283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5285: WHEN OTHERS THEN
5286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5287: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5288: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5289: FND_MSG_PUB.ADD;
5290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5287: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

5283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5285: WHEN OTHERS THEN
5286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5287: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5288: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5289: FND_MSG_PUB.ADD;
5290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5291: END get_party_for_search;

Line 5288: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5285: WHEN OTHERS THEN
5286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5287: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5288: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5289: FND_MSG_PUB.ADD;
5290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5291: END get_party_for_search;
5292:

Line 5326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5322: RAISE FND_API.G_EXC_ERROR;
5323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5325: WHEN OTHERS THEN
5326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5328: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5329: FND_MSG_PUB.ADD;
5330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

5323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5325: WHEN OTHERS THEN
5326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5328: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5329: FND_MSG_PUB.ADD;
5330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5331: END get_search_criteria;

Line 5328: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5325: WHEN OTHERS THEN
5326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5328: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5329: FND_MSG_PUB.ADD;
5330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5331: END get_search_criteria;
5332:

Line 5392: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

5388: END IF;
5389:
5390: EXCEPTION
5391: WHEN OTHERS THEN
5392: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5393: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5394: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5396: FND_MSG_PUB.ADD;

Line 5393: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');

5389:
5390: EXCEPTION
5391: WHEN OTHERS THEN
5392: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5393: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5394: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5396: FND_MSG_PUB.ADD;
5397: RAISE FND_API.G_EXC_ERROR;

Line 5394: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);

5390: EXCEPTION
5391: WHEN OTHERS THEN
5392: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5393: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5394: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5396: FND_MSG_PUB.ADD;
5397: RAISE FND_API.G_EXC_ERROR;
5398: END get_party_rec;

Line 5395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5391: WHEN OTHERS THEN
5392: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5393: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5394: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5396: FND_MSG_PUB.ADD;
5397: RAISE FND_API.G_EXC_ERROR;
5398: END get_party_rec;
5399:

Line 5448: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

5444: END LOOP;
5445:
5446: EXCEPTION
5447: WHEN OTHERS THEN
5448: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5449: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5450: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5451: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5452: FND_MSG_PUB.ADD;

Line 5449: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');

5445:
5446: EXCEPTION
5447: WHEN OTHERS THEN
5448: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5449: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5450: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5451: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5452: FND_MSG_PUB.ADD;
5453: RAISE FND_API.G_EXC_ERROR;

Line 5450: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);

5446: EXCEPTION
5447: WHEN OTHERS THEN
5448: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5449: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5450: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5451: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5452: FND_MSG_PUB.ADD;
5453: RAISE FND_API.G_EXC_ERROR;
5454: END get_party_site_rec;

Line 5451: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5447: WHEN OTHERS THEN
5448: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5449: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5450: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5451: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5452: FND_MSG_PUB.ADD;
5453: RAISE FND_API.G_EXC_ERROR;
5454: END get_party_site_rec;
5455:

Line 5504: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

5500: END LOOP;
5501:
5502: EXCEPTION
5503: WHEN OTHERS THEN
5504: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5505: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5506: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5508: FND_MSG_PUB.ADD;

Line 5505: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');

5501:
5502: EXCEPTION
5503: WHEN OTHERS THEN
5504: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5505: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5506: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5508: FND_MSG_PUB.ADD;
5509: RAISE FND_API.G_EXC_ERROR;

Line 5506: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);

5502: EXCEPTION
5503: WHEN OTHERS THEN
5504: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5505: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5506: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5508: FND_MSG_PUB.ADD;
5509: RAISE FND_API.G_EXC_ERROR;
5510: END get_contact_rec;

Line 5507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5503: WHEN OTHERS THEN
5504: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5505: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5506: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5508: FND_MSG_PUB.ADD;
5509: RAISE FND_API.G_EXC_ERROR;
5510: END get_contact_rec;
5511:

Line 5556: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

5552: END LOOP;
5553:
5554: EXCEPTION
5555: WHEN OTHERS THEN
5556: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5557: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5558: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5559: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5560: FND_MSG_PUB.ADD;

Line 5557: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');

5553:
5554: EXCEPTION
5555: WHEN OTHERS THEN
5556: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5557: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5558: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5559: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5560: FND_MSG_PUB.ADD;
5561: RAISE FND_API.G_EXC_ERROR;

Line 5558: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);

5554: EXCEPTION
5555: WHEN OTHERS THEN
5556: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5557: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5558: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5559: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5560: FND_MSG_PUB.ADD;
5561: RAISE FND_API.G_EXC_ERROR;
5562: END get_contact_point_rec;

Line 5559: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5555: WHEN OTHERS THEN
5556: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5557: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5558: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5559: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5560: FND_MSG_PUB.ADD;
5561: RAISE FND_API.G_EXC_ERROR;
5562: END get_contact_point_rec;
5563:

Line 5704: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

5700: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
5701: END IF;
5702: EXCEPTION
5703: WHEN OTHERS THEN
5704: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5705: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5706: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5707: FND_MSG_PUB.ADD;
5708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5705: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');

5701: END IF;
5702: EXCEPTION
5703: WHEN OTHERS THEN
5704: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5705: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5706: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5707: FND_MSG_PUB.ADD;
5708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5709: END;

Line 5706: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

5702: EXCEPTION
5703: WHEN OTHERS THEN
5704: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5705: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5706: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5707: FND_MSG_PUB.ADD;
5708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5709: END;
5710:

Line 5819: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

5815: END IF;
5816: END LOOP;
5817: EXCEPTION
5818: WHEN OTHERS THEN
5819: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5820: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5821: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5822: FND_MSG_PUB.ADD;
5823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5820: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');

5816: END LOOP;
5817: EXCEPTION
5818: WHEN OTHERS THEN
5819: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5820: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5821: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5822: FND_MSG_PUB.ADD;
5823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5824: END;

Line 5821: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

5817: EXCEPTION
5818: WHEN OTHERS THEN
5819: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5820: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5821: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5822: FND_MSG_PUB.ADD;
5823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5824: END;
5825:

Line 5861: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

5857: END IF;
5858: NULL;
5859: EXCEPTION
5860: WHEN OTHERS THEN
5861: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5862: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5864: FND_MSG_PUB.ADD;
5865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5862: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');

5858: NULL;
5859: EXCEPTION
5860: WHEN OTHERS THEN
5861: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5862: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5864: FND_MSG_PUB.ADD;
5865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5866: END;

Line 5863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

5859: EXCEPTION
5860: WHEN OTHERS THEN
5861: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5862: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5864: FND_MSG_PUB.ADD;
5865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5866: END;
5867:

Line 5904: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

5900: END IF;
5901: NULL;
5902: EXCEPTION
5903: WHEN OTHERS THEN
5904: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5905: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5906: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5907: FND_MSG_PUB.ADD;
5908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5905: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');

5901: NULL;
5902: EXCEPTION
5903: WHEN OTHERS THEN
5904: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5905: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5906: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5907: FND_MSG_PUB.ADD;
5908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5909: END;

Line 5906: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

5902: EXCEPTION
5903: WHEN OTHERS THEN
5904: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5905: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5906: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5907: FND_MSG_PUB.ADD;
5908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5909: END;
5910:

Line 5939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5935: EXCEPTION
5936: WHEN FND_API.G_EXC_ERROR THEN
5937: RAISE FND_API.G_EXC_ERROR;
5938: WHEN OTHERS THEN
5939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5940: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5942: FND_MSG_PUB.ADD;
5943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5940: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

5936: WHEN FND_API.G_EXC_ERROR THEN
5937: RAISE FND_API.G_EXC_ERROR;
5938: WHEN OTHERS THEN
5939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5940: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5942: FND_MSG_PUB.ADD;
5943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5944: END check_prim_cond;

Line 5941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5937: RAISE FND_API.G_EXC_ERROR;
5938: WHEN OTHERS THEN
5939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5940: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5942: FND_MSG_PUB.ADD;
5943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5944: END check_prim_cond;
5945:

Line 5983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5979: NULL;
5980: END LOOP;
5981: EXCEPTION
5982: WHEN OTHERS THEN
5983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5984: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5986: FND_MSG_PUB.ADD;
5987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5984: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');

5980: END LOOP;
5981: EXCEPTION
5982: WHEN OTHERS THEN
5983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5984: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5986: FND_MSG_PUB.ADD;
5987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5988: END check_party_site_cond;

Line 5985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5981: EXCEPTION
5982: WHEN OTHERS THEN
5983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5984: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5986: FND_MSG_PUB.ADD;
5987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5988: END check_party_site_cond;
5989:

Line 6021: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

6017: NULL;
6018: END LOOP;
6019: EXCEPTION
6020: WHEN OTHERS THEN
6021: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6022: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6023: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6024: FND_MSG_PUB.ADD;
6025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6022: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');

6018: END LOOP;
6019: EXCEPTION
6020: WHEN OTHERS THEN
6021: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6022: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6023: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6024: FND_MSG_PUB.ADD;
6025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6026: END check_contact_cond;

Line 6023: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

6019: EXCEPTION
6020: WHEN OTHERS THEN
6021: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6022: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6023: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6024: FND_MSG_PUB.ADD;
6025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6026: END check_contact_cond;
6027:

Line 6044: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');

6040: x_secondary:= FALSE;
6041:
6042: FOR I IN 1..p_contact_point_list.COUNT LOOP
6043: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6044: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6045: FND_MSG_PUB.ADD;
6046: RAISE FND_API.G_EXC_ERROR;
6047: END IF;
6048: END LOOP;

Line 6058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

6054: NULL;
6055: END LOOP;
6056: EXCEPTION
6057: WHEN OTHERS THEN
6058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6059: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6061: FND_MSG_PUB.ADD;
6062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6059: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');

6055: END LOOP;
6056: EXCEPTION
6057: WHEN OTHERS THEN
6058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6059: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6061: FND_MSG_PUB.ADD;
6062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6063: END check_contact_point_cond;

Line 6060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

6056: EXCEPTION
6057: WHEN OTHERS THEN
6058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6059: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6061: FND_MSG_PUB.ADD;
6062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6063: END check_contact_point_cond;
6064: