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 1249: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3705: WHEN OTHERS THEN
3706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3707: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_persons');
3708: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3709: FND_MSG_PUB.ADD;
3710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3711: END find_persons;
3712:

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

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

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

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

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

3772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3773: WHEN OTHERS THEN
3774: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3775: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_party_details');
3776: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3777: FND_MSG_PUB.ADD;
3778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3779: END find_party_details;
3780:

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

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

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

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

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

3889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3890: WHEN OTHERS THEN
3891: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3892: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_parties');
3893: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3894: FND_MSG_PUB.ADD;
3895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3896: END find_duplicate_parties;
3897:

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

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

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

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

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

3974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3975: WHEN OTHERS THEN
3976: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3977: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_party_sites');
3978: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3979: FND_MSG_PUB.ADD;
3980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3981: END find_duplicate_party_sites;
3982:

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

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

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

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

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

4063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4064: WHEN OTHERS THEN
4065: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4066: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contacts');
4067: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4068: FND_MSG_PUB.ADD;
4069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4070: END find_duplicate_contacts;
4071:

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

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

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

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

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

4136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4137: WHEN OTHERS THEN
4138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4139: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contact_points');
4140: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4141: FND_MSG_PUB.ADD;
4142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4143: END find_duplicate_contact_points;
4144:

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

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

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

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

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

4410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4411: WHEN OTHERS THEN
4412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4413: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.call_api_dynamic');
4414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4415: FND_MSG_PUB.ADD;
4416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4417: END call_api_dynamic;
4418:

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

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

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

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

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

4644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4645: WHEN OTHERS THEN
4646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4647: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_party_sites');
4648: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4649: FND_MSG_PUB.ADD;
4650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4651: END get_matching_party_sites;
4652:

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

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

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

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

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

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

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

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

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

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

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

5008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5009: WHEN OTHERS THEN
5010: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5011: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contact_points');
5012: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5013: FND_MSG_PUB.ADD;
5014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5015: END get_matching_contact_points;
5016:

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

5209: RAISE FND_API.G_EXC_ERROR;
5210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5212: WHEN OTHERS THEN
5213: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5214: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_score_details');
5215: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5216: FND_MSG_PUB.ADD;
5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5212: WHEN OTHERS THEN
5213: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5214: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_score_details');
5215: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5216: FND_MSG_PUB.ADD;
5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5218: END get_score_details;

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

5211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5212: WHEN OTHERS THEN
5213: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5214: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_score_details');
5215: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5216: FND_MSG_PUB.ADD;
5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5218: END get_score_details;
5219:

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

5287: RAISE FND_API.G_EXC_ERROR;
5288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5290: WHEN OTHERS THEN
5291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5292: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5294: FND_MSG_PUB.ADD;
5295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5290: WHEN OTHERS THEN
5291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5292: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5294: FND_MSG_PUB.ADD;
5295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5296: END get_party_for_search;

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

5289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5290: WHEN OTHERS THEN
5291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5292: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5294: FND_MSG_PUB.ADD;
5295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5296: END get_party_for_search;
5297:

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

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

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

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

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

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

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

5393: END IF;
5394:
5395: EXCEPTION
5396: WHEN OTHERS THEN
5397: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5398: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5399: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5400: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5401: FND_MSG_PUB.ADD;

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

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

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

5395: EXCEPTION
5396: WHEN OTHERS THEN
5397: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5398: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5399: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5400: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5401: FND_MSG_PUB.ADD;
5402: RAISE FND_API.G_EXC_ERROR;
5403: END get_party_rec;

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

5396: WHEN OTHERS THEN
5397: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5398: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5399: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5400: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5401: FND_MSG_PUB.ADD;
5402: RAISE FND_API.G_EXC_ERROR;
5403: END get_party_rec;
5404:

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

5449: END LOOP;
5450:
5451: EXCEPTION
5452: WHEN OTHERS THEN
5453: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5454: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5455: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5456: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5457: FND_MSG_PUB.ADD;

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

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

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

5451: EXCEPTION
5452: WHEN OTHERS THEN
5453: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5454: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5455: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5456: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5457: FND_MSG_PUB.ADD;
5458: RAISE FND_API.G_EXC_ERROR;
5459: END get_party_site_rec;

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

5452: WHEN OTHERS THEN
5453: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5454: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5455: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5456: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5457: FND_MSG_PUB.ADD;
5458: RAISE FND_API.G_EXC_ERROR;
5459: END get_party_site_rec;
5460:

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

5505: END LOOP;
5506:
5507: EXCEPTION
5508: WHEN OTHERS THEN
5509: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5510: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5511: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5513: FND_MSG_PUB.ADD;

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

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

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

5507: EXCEPTION
5508: WHEN OTHERS THEN
5509: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5510: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5511: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5513: FND_MSG_PUB.ADD;
5514: RAISE FND_API.G_EXC_ERROR;
5515: END get_contact_rec;

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

5508: WHEN OTHERS THEN
5509: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5510: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5511: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5513: FND_MSG_PUB.ADD;
5514: RAISE FND_API.G_EXC_ERROR;
5515: END get_contact_rec;
5516:

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

5557: END LOOP;
5558:
5559: EXCEPTION
5560: WHEN OTHERS THEN
5561: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5562: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5563: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5564: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5565: FND_MSG_PUB.ADD;

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

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

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

5559: EXCEPTION
5560: WHEN OTHERS THEN
5561: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5562: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5563: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5564: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5565: FND_MSG_PUB.ADD;
5566: RAISE FND_API.G_EXC_ERROR;
5567: END get_contact_point_rec;

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

5560: WHEN OTHERS THEN
5561: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5562: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5563: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5564: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5565: FND_MSG_PUB.ADD;
5566: RAISE FND_API.G_EXC_ERROR;
5567: END get_contact_point_rec;
5568:

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

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

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

5706: END IF;
5707: EXCEPTION
5708: WHEN OTHERS THEN
5709: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5710: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5711: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5712: FND_MSG_PUB.ADD;
5713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5714: END;

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

5707: EXCEPTION
5708: WHEN OTHERS THEN
5709: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5710: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5711: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5712: FND_MSG_PUB.ADD;
5713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5714: END;
5715:

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

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

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

5821: END LOOP;
5822: EXCEPTION
5823: WHEN OTHERS THEN
5824: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5825: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5826: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5827: FND_MSG_PUB.ADD;
5828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5829: END;

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

5822: EXCEPTION
5823: WHEN OTHERS THEN
5824: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5825: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5826: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5827: FND_MSG_PUB.ADD;
5828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5829: END;
5830:

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

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

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

5863: NULL;
5864: EXCEPTION
5865: WHEN OTHERS THEN
5866: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5867: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5869: FND_MSG_PUB.ADD;
5870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5871: END;

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

5864: EXCEPTION
5865: WHEN OTHERS THEN
5866: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5867: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5869: FND_MSG_PUB.ADD;
5870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5871: END;
5872:

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

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

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

5906: NULL;
5907: EXCEPTION
5908: WHEN OTHERS THEN
5909: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5910: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5911: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5912: FND_MSG_PUB.ADD;
5913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5914: END;

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

5907: EXCEPTION
5908: WHEN OTHERS THEN
5909: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5910: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5911: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5912: FND_MSG_PUB.ADD;
5913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5914: END;
5915:

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

5940: EXCEPTION
5941: WHEN FND_API.G_EXC_ERROR THEN
5942: RAISE FND_API.G_EXC_ERROR;
5943: WHEN OTHERS THEN
5944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5945: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5947: FND_MSG_PUB.ADD;
5948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5941: WHEN FND_API.G_EXC_ERROR THEN
5942: RAISE FND_API.G_EXC_ERROR;
5943: WHEN OTHERS THEN
5944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5945: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5947: FND_MSG_PUB.ADD;
5948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5949: END check_prim_cond;

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

5942: RAISE FND_API.G_EXC_ERROR;
5943: WHEN OTHERS THEN
5944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5945: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5947: FND_MSG_PUB.ADD;
5948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5949: END check_prim_cond;
5950:

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

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

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

5985: END LOOP;
5986: EXCEPTION
5987: WHEN OTHERS THEN
5988: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5989: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5990: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5991: FND_MSG_PUB.ADD;
5992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5993: END check_party_site_cond;

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

5986: EXCEPTION
5987: WHEN OTHERS THEN
5988: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5989: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5990: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5991: FND_MSG_PUB.ADD;
5992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5993: END check_party_site_cond;
5994:

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

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

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

6023: END LOOP;
6024: EXCEPTION
6025: WHEN OTHERS THEN
6026: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6027: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6028: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6029: FND_MSG_PUB.ADD;
6030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6031: END check_contact_cond;

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

6024: EXCEPTION
6025: WHEN OTHERS THEN
6026: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6027: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6028: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6029: FND_MSG_PUB.ADD;
6030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6031: END check_contact_cond;
6032:

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

6045: x_secondary:= FALSE;
6046:
6047: FOR I IN 1..p_contact_point_list.COUNT LOOP
6048: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6049: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6050: FND_MSG_PUB.ADD;
6051: RAISE FND_API.G_EXC_ERROR;
6052: END IF;
6053: END LOOP;

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

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

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

6060: END LOOP;
6061: EXCEPTION
6062: WHEN OTHERS THEN
6063: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6064: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6065: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6066: FND_MSG_PUB.ADD;
6067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6068: END check_contact_point_cond;

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

6061: EXCEPTION
6062: WHEN OTHERS THEN
6063: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6064: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6065: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6066: FND_MSG_PUB.ADD;
6067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6068: END check_contact_point_cond;
6069: