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_48 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 767: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

763: BEGIN
764: NULL ;
765: EXCEPTION
766: WHEN OTHERS THEN
767: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
768: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
769: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
770: FND_MSG_PUB.ADD;
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

764: NULL ;
765: EXCEPTION
766: WHEN OTHERS THEN
767: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
768: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
769: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
770: FND_MSG_PUB.ADD;
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: END;

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

765: EXCEPTION
766: WHEN OTHERS THEN
767: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
768: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
769: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
770: FND_MSG_PUB.ADD;
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: END;
773:

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

788: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,p_search_list(1).COUNTRY);
789: END IF ;
790: EXCEPTION
791: WHEN OTHERS THEN
792: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
793: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
794: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
795: FND_MSG_PUB.ADD;
796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

789: END IF ;
790: EXCEPTION
791: WHEN OTHERS THEN
792: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
793: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
794: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
795: FND_MSG_PUB.ADD;
796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
797: END;

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

790: EXCEPTION
791: WHEN OTHERS THEN
792: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
793: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
794: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
795: FND_MSG_PUB.ADD;
796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
797: END;
798:

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

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

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

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

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

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

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

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

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

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

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

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

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

897: IF NOT check_prim_cond (p_party_search_rec,
898: p_party_site_list,
899: p_contact_list,
900: p_contact_point_list) THEN
901: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
902: FND_MSG_PUB.ADD;
903: RAISE FND_API.G_EXC_ERROR;
904: END IF;
905: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1167: ELSE
1168: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1169: END IF;
1170: IF lengthb(l_party_contains_str) > 4000 THEN
1171: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1172: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1173: FND_MSG_PUB.ADD;
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;

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

1168: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1169: END IF;
1170: IF lengthb(l_party_contains_str) > 4000 THEN
1171: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1172: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1173: FND_MSG_PUB.ADD;
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;
1176: IF (p_match_str = ' AND ' OR p_party_max_score

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

1256: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1257: END LOOP;
1258: -- Add the search criteria to query string
1259: IF lengthb(l_contains_str) > 4000 THEN
1260: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1261: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1262: FND_MSG_PUB.ADD;
1263: RAISE FND_API.G_EXC_ERROR;
1264: END IF;

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

1257: END LOOP;
1258: -- Add the search criteria to query string
1259: IF lengthb(l_contains_str) > 4000 THEN
1260: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1261: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1262: FND_MSG_PUB.ADD;
1263: RAISE FND_API.G_EXC_ERROR;
1264: END IF;
1265: x_denorm_str := l_den_contains_str;

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

1537: END IF;
1538: exception
1539: when others then
1540: if (instrb(SQLERRM,'DRG-51030')>0) then
1541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1542: FND_MSG_PUB.ADD;
1543: RAISE FND_API.G_EXC_ERROR;
1544: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1545: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1542: FND_MSG_PUB.ADD;
1543: RAISE FND_API.G_EXC_ERROR;
1544: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1545: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1546: FND_MSG_PUB.ADD;
1547: RAISE FND_API.G_EXC_ERROR;
1548: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1545: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1546: FND_MSG_PUB.ADD;
1547: RAISE FND_API.G_EXC_ERROR;
1548: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1550: FND_MSG_PUB.ADD;
1551: RAISE FND_API.G_EXC_ERROR;
1552: else
1553: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1550: FND_MSG_PUB.ADD;
1551: RAISE FND_API.G_EXC_ERROR;
1552: else
1553: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1554: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1555: FND_MSG_PUB.ADD;
1556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1557: end if;

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

1550: FND_MSG_PUB.ADD;
1551: RAISE FND_API.G_EXC_ERROR;
1552: else
1553: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1554: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1555: FND_MSG_PUB.ADD;
1556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1557: end if;
1558: END;

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

1782: output_long_strings('Restrict Sql = '||p_restrict_sql);
1783: exception
1784: when others then
1785: if (instrb(SQLERRM,'DRG-51030')>0) then
1786: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1787: FND_MSG_PUB.ADD;
1788: RAISE FND_API.G_EXC_ERROR;
1789: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1790: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1786: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1787: FND_MSG_PUB.ADD;
1788: RAISE FND_API.G_EXC_ERROR;
1789: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1790: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1791: FND_MSG_PUB.ADD;
1792: RAISE FND_API.G_EXC_ERROR;
1793: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1790: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1791: FND_MSG_PUB.ADD;
1792: RAISE FND_API.G_EXC_ERROR;
1793: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1795: FND_MSG_PUB.ADD;
1796: RAISE FND_API.G_EXC_ERROR;
1797: else
1798: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1795: FND_MSG_PUB.ADD;
1796: RAISE FND_API.G_EXC_ERROR;
1797: else
1798: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1800: FND_MSG_PUB.ADD;
1801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1802: end if;

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

1795: FND_MSG_PUB.ADD;
1796: RAISE FND_API.G_EXC_ERROR;
1797: else
1798: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1800: FND_MSG_PUB.ADD;
1801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1802: end if;
1803: END;

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

1929: output_long_strings('Restrict Sql = '||p_restrict_sql);
1930: exception
1931: when others then
1932: if (instrb(SQLERRM,'DRG-51030')>0) then
1933: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1934: FND_MSG_PUB.ADD;
1935: RAISE FND_API.G_EXC_ERROR;
1936: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1937: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1933: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1934: FND_MSG_PUB.ADD;
1935: RAISE FND_API.G_EXC_ERROR;
1936: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1937: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1938: FND_MSG_PUB.ADD;
1939: RAISE FND_API.G_EXC_ERROR;
1940: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1937: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1938: FND_MSG_PUB.ADD;
1939: RAISE FND_API.G_EXC_ERROR;
1940: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1942: FND_MSG_PUB.ADD;
1943: RAISE FND_API.G_EXC_ERROR;
1944: else
1945: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1942: FND_MSG_PUB.ADD;
1943: RAISE FND_API.G_EXC_ERROR;
1944: else
1945: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1947: FND_MSG_PUB.ADD;
1948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1949: end if;

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

1942: FND_MSG_PUB.ADD;
1943: RAISE FND_API.G_EXC_ERROR;
1944: else
1945: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1947: FND_MSG_PUB.ADD;
1948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1949: end if;
1950: END;

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

2202: output_long_strings('Restrict Sql = '||p_restrict_sql);
2203: exception
2204: when others then
2205: if (instrb(SQLERRM,'DRG-51030')>0) then
2206: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2207: FND_MSG_PUB.ADD;
2208: RAISE FND_API.G_EXC_ERROR;
2209: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2210: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2206: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2207: FND_MSG_PUB.ADD;
2208: RAISE FND_API.G_EXC_ERROR;
2209: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2210: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2211: FND_MSG_PUB.ADD;
2212: RAISE FND_API.G_EXC_ERROR;
2213: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2210: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2211: FND_MSG_PUB.ADD;
2212: RAISE FND_API.G_EXC_ERROR;
2213: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2215: FND_MSG_PUB.ADD;
2216: RAISE FND_API.G_EXC_ERROR;
2217: else
2218: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2215: FND_MSG_PUB.ADD;
2216: RAISE FND_API.G_EXC_ERROR;
2217: else
2218: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2219: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2220: FND_MSG_PUB.ADD;
2221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2222: end if;

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

2215: FND_MSG_PUB.ADD;
2216: RAISE FND_API.G_EXC_ERROR;
2217: else
2218: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2219: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2220: FND_MSG_PUB.ADD;
2221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2222: end if;
2223: END;

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

2468: IF p_index>1 THEN
2469: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2470: 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);
2471: END IF;
2472: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2473: FND_MSG_PUB.ADD;
2474: RAISE FND_API.G_EXC_ERROR;
2475: ELSE
2476: push_eval;

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

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

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

2589: IF p_index>1 THEN
2590: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2591: 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);
2592: END IF;
2593: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2594: FND_MSG_PUB.ADD;
2595: RAISE FND_API.G_EXC_ERROR;
2596: ELSE
2597: push_eval;

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

2701: IF p_index>1 THEN
2702: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2703: 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);
2704: END IF;
2705: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2706: FND_MSG_PUB.ADD;
2707: RAISE FND_API.G_EXC_ERROR;
2708: ELSE
2709: push_eval;

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

2812: IF p_index>1 THEN
2813: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2814: 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);
2815: END IF;
2816: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2817: FND_MSG_PUB.ADD;
2818: RAISE FND_API.G_EXC_ERROR;
2819: ELSE
2820: push_eval;

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

2956: ELSE
2957: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2958: 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);
2959: END IF;
2960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2961: FND_MSG_PUB.ADD;
2962: RAISE FND_API.G_EXC_ERROR;
2963: END IF;
2964: ELSE

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

2964: ELSE
2965: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2966: 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);
2967: END IF;
2968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2969: FND_MSG_PUB.ADD;
2970: RAISE FND_API.G_EXC_ERROR;
2971: END IF;
2972: END IF;

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

3213: RAISE FND_API.G_EXC_ERROR;
3214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3216: WHEN OTHERS THEN
3217: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3218: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_parties');
3219: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3220: FND_MSG_PUB.ADD;
3221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3218: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_parties');

3214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3216: WHEN OTHERS THEN
3217: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3218: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_parties');
3219: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3220: FND_MSG_PUB.ADD;
3221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3222: END find_parties;

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

3215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3216: WHEN OTHERS THEN
3217: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3218: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_parties');
3219: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3220: FND_MSG_PUB.ADD;
3221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3222: END find_parties;
3223:

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

3408: IF p_index>1 THEN
3409: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3410: 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);
3411: END IF;
3412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3413: FND_MSG_PUB.ADD;
3414: RAISE FND_API.G_EXC_ERROR;
3415: ELSE
3416: push_eval;

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

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

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

3492: and d.search_context_id = p_search_ctx_id);
3493: exception
3494: when others then
3495: if (instrb(SQLERRM,'DRG-51030')>0) then
3496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3497: FND_MSG_PUB.ADD;
3498: RAISE FND_API.G_EXC_ERROR;
3499: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3497: FND_MSG_PUB.ADD;
3498: RAISE FND_API.G_EXC_ERROR;
3499: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3501: FND_MSG_PUB.ADD;
3502: RAISE FND_API.G_EXC_ERROR;
3503: else
3504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3568: IF p_index>1 THEN
3569: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3570: 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);
3571: END IF;
3572: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3573: FND_MSG_PUB.ADD;
3574: RAISE FND_API.G_EXC_ERROR;
3575: ELSE
3576: push_eval;

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

3757: IF p_index>1 THEN
3758: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3759: 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);
3760: END IF;
3761: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3762: FND_MSG_PUB.ADD;
3763: RAISE FND_API.G_EXC_ERROR;
3764: ELSE
3765: push_eval;

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

3845: ELSE
3846: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3847: 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);
3848: END IF;
3849: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3850: FND_MSG_PUB.ADD;
3851: RAISE FND_API.G_EXC_ERROR;
3852: END IF;
3853: ELSE

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

3853: ELSE
3854: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3855: 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);
3856: END IF;
3857: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3858: FND_MSG_PUB.ADD;
3859: RAISE FND_API.G_EXC_ERROR;
3860: END IF;
3861: END IF;

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

4000: RAISE FND_API.G_EXC_ERROR;
4001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4003: WHEN OTHERS THEN
4004: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4005: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_persons');
4006: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4007: FND_MSG_PUB.ADD;
4008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4005: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_persons');

4001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4003: WHEN OTHERS THEN
4004: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4005: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_persons');
4006: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4007: FND_MSG_PUB.ADD;
4008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4009: END find_persons;

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

4002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4003: WHEN OTHERS THEN
4004: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4005: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_persons');
4006: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4007: FND_MSG_PUB.ADD;
4008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4009: END find_persons;
4010:

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

4068: RAISE FND_API.G_EXC_ERROR;
4069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4071: WHEN OTHERS THEN
4072: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4073: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_party_details');
4074: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4075: FND_MSG_PUB.ADD;
4076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4073: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_party_details');

4069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4071: WHEN OTHERS THEN
4072: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4073: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_party_details');
4074: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4075: FND_MSG_PUB.ADD;
4076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4077: END find_party_details;

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

4070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4071: WHEN OTHERS THEN
4072: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4073: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_party_details');
4074: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4075: FND_MSG_PUB.ADD;
4076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4077: END find_party_details;
4078:

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

4185: RAISE FND_API.G_EXC_ERROR;
4186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4188: WHEN OTHERS THEN
4189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_parties');
4191: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4192: FND_MSG_PUB.ADD;
4193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_parties');

4186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4188: WHEN OTHERS THEN
4189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_parties');
4191: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4192: FND_MSG_PUB.ADD;
4193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4194: END find_duplicate_parties;

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

4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4188: WHEN OTHERS THEN
4189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_parties');
4191: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4192: FND_MSG_PUB.ADD;
4193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4194: END find_duplicate_parties;
4195:

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

4270: RAISE FND_API.G_EXC_ERROR;
4271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4273: WHEN OTHERS THEN
4274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4275: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_party_sites');
4276: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4277: FND_MSG_PUB.ADD;
4278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4275: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_party_sites');

4271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4273: WHEN OTHERS THEN
4274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4275: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_party_sites');
4276: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4277: FND_MSG_PUB.ADD;
4278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4279: END find_duplicate_party_sites;

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

4272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4273: WHEN OTHERS THEN
4274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4275: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_party_sites');
4276: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4277: FND_MSG_PUB.ADD;
4278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4279: END find_duplicate_party_sites;
4280:

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

4359: RAISE FND_API.G_EXC_ERROR;
4360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4362: WHEN OTHERS THEN
4363: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4364: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contacts');
4365: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4366: FND_MSG_PUB.ADD;
4367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4364: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contacts');

4360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4362: WHEN OTHERS THEN
4363: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4364: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contacts');
4365: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4366: FND_MSG_PUB.ADD;
4367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4368: END find_duplicate_contacts;

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

4361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4362: WHEN OTHERS THEN
4363: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4364: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contacts');
4365: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4366: FND_MSG_PUB.ADD;
4367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4368: END find_duplicate_contacts;
4369:

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

4432: RAISE FND_API.G_EXC_ERROR;
4433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4435: WHEN OTHERS THEN
4436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4437: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contact_points');
4438: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4439: FND_MSG_PUB.ADD;
4440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4437: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contact_points');

4433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4435: WHEN OTHERS THEN
4436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4437: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contact_points');
4438: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4439: FND_MSG_PUB.ADD;
4440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4441: END find_duplicate_contact_points;

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

4434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4435: WHEN OTHERS THEN
4436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4437: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contact_points');
4438: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4439: FND_MSG_PUB.ADD;
4440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4441: END find_duplicate_contact_points;
4442:

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

4720: RAISE FND_API.G_EXC_ERROR;
4721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4723: WHEN OTHERS THEN
4724: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4725: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.call_api_dynamic');
4726: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4727: FND_MSG_PUB.ADD;
4728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4725: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.call_api_dynamic');

4721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4723: WHEN OTHERS THEN
4724: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4725: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.call_api_dynamic');
4726: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4727: FND_MSG_PUB.ADD;
4728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4729: END call_api_dynamic;

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

4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4723: WHEN OTHERS THEN
4724: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4725: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.call_api_dynamic');
4726: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4727: FND_MSG_PUB.ADD;
4728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4729: END call_api_dynamic;
4730:

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

4956: RAISE FND_API.G_EXC_ERROR;
4957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4959: WHEN OTHERS THEN
4960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4961: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_party_sites');
4962: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4963: FND_MSG_PUB.ADD;
4964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4961: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_party_sites');

4957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4959: WHEN OTHERS THEN
4960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4961: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_party_sites');
4962: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4963: FND_MSG_PUB.ADD;
4964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4965: END get_matching_party_sites;

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

4958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4959: WHEN OTHERS THEN
4960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4961: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_party_sites');
4962: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4963: FND_MSG_PUB.ADD;
4964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4965: END get_matching_party_sites;
4966:

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

5181: RAISE FND_API.G_EXC_ERROR;
5182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5184: WHEN OTHERS THEN
5185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contacts');
5187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5188: FND_MSG_PUB.ADD;
5189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contacts');

5182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5184: WHEN OTHERS THEN
5185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contacts');
5187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5188: FND_MSG_PUB.ADD;
5189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5190: END get_matching_contacts;

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

5183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5184: WHEN OTHERS THEN
5185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contacts');
5187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5188: FND_MSG_PUB.ADD;
5189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5190: END get_matching_contacts;
5191:

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

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

Line 5325: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contact_points');

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

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

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

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

5531: RAISE FND_API.G_EXC_ERROR;
5532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5534: WHEN OTHERS THEN
5535: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5536: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_score_details');
5537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5538: FND_MSG_PUB.ADD;
5539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5536: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_score_details');

5532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5534: WHEN OTHERS THEN
5535: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5536: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_score_details');
5537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5538: FND_MSG_PUB.ADD;
5539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5540: END get_score_details;

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

5533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5534: WHEN OTHERS THEN
5535: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5536: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_score_details');
5537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5538: FND_MSG_PUB.ADD;
5539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5540: END get_score_details;
5541:

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

5609: RAISE FND_API.G_EXC_ERROR;
5610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5612: WHEN OTHERS THEN
5613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5614: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5615: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5616: FND_MSG_PUB.ADD;
5617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5612: WHEN OTHERS THEN
5613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5614: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5615: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5616: FND_MSG_PUB.ADD;
5617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5618: END get_party_for_search;

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

5611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5612: WHEN OTHERS THEN
5613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5614: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5615: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5616: FND_MSG_PUB.ADD;
5617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5618: END get_party_for_search;
5619:

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

5649: RAISE FND_API.G_EXC_ERROR;
5650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5652: WHEN OTHERS THEN
5653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5654: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5655: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5656: FND_MSG_PUB.ADD;
5657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5652: WHEN OTHERS THEN
5653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5654: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5655: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5656: FND_MSG_PUB.ADD;
5657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5658: END get_search_criteria;

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

5651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5652: WHEN OTHERS THEN
5653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5654: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5655: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5656: FND_MSG_PUB.ADD;
5657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5658: END get_search_criteria;
5659:

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

5715: END IF;
5716:
5717: EXCEPTION
5718: WHEN OTHERS THEN
5719: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5720: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5721: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5723: FND_MSG_PUB.ADD;

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

5716:
5717: EXCEPTION
5718: WHEN OTHERS THEN
5719: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5720: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5721: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5723: FND_MSG_PUB.ADD;
5724: RAISE FND_API.G_EXC_ERROR;

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

5717: EXCEPTION
5718: WHEN OTHERS THEN
5719: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5720: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5721: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5723: FND_MSG_PUB.ADD;
5724: RAISE FND_API.G_EXC_ERROR;
5725: END get_party_rec;

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

5718: WHEN OTHERS THEN
5719: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5720: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5721: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5723: FND_MSG_PUB.ADD;
5724: RAISE FND_API.G_EXC_ERROR;
5725: END get_party_rec;
5726:

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

5775: END LOOP;
5776:
5777: EXCEPTION
5778: WHEN OTHERS THEN
5779: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5780: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5781: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5782: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5783: FND_MSG_PUB.ADD;

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

5776:
5777: EXCEPTION
5778: WHEN OTHERS THEN
5779: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5780: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5781: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5782: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5783: FND_MSG_PUB.ADD;
5784: RAISE FND_API.G_EXC_ERROR;

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

5777: EXCEPTION
5778: WHEN OTHERS THEN
5779: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5780: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5781: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5782: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5783: FND_MSG_PUB.ADD;
5784: RAISE FND_API.G_EXC_ERROR;
5785: END get_party_site_rec;

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

5778: WHEN OTHERS THEN
5779: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5780: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5781: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5782: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5783: FND_MSG_PUB.ADD;
5784: RAISE FND_API.G_EXC_ERROR;
5785: END get_party_site_rec;
5786:

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

5831: END LOOP;
5832:
5833: EXCEPTION
5834: WHEN OTHERS THEN
5835: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5836: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5837: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5838: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5839: FND_MSG_PUB.ADD;

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

5832:
5833: EXCEPTION
5834: WHEN OTHERS THEN
5835: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5836: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5837: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5838: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5839: FND_MSG_PUB.ADD;
5840: RAISE FND_API.G_EXC_ERROR;

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

5833: EXCEPTION
5834: WHEN OTHERS THEN
5835: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5836: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5837: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5838: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5839: FND_MSG_PUB.ADD;
5840: RAISE FND_API.G_EXC_ERROR;
5841: END get_contact_rec;

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

5834: WHEN OTHERS THEN
5835: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5836: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5837: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5838: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5839: FND_MSG_PUB.ADD;
5840: RAISE FND_API.G_EXC_ERROR;
5841: END get_contact_rec;
5842:

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

5883: END LOOP;
5884:
5885: EXCEPTION
5886: WHEN OTHERS THEN
5887: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5888: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5889: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5890: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5891: FND_MSG_PUB.ADD;

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

5884:
5885: EXCEPTION
5886: WHEN OTHERS THEN
5887: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5888: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5889: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5890: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5891: FND_MSG_PUB.ADD;
5892: RAISE FND_API.G_EXC_ERROR;

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

5885: EXCEPTION
5886: WHEN OTHERS THEN
5887: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5888: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5889: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5890: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5891: FND_MSG_PUB.ADD;
5892: RAISE FND_API.G_EXC_ERROR;
5893: END get_contact_point_rec;

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

5886: WHEN OTHERS THEN
5887: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5888: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5889: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5890: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5891: FND_MSG_PUB.ADD;
5892: RAISE FND_API.G_EXC_ERROR;
5893: END get_contact_point_rec;
5894:

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

6037: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
6038: END IF;
6039: EXCEPTION
6040: WHEN OTHERS THEN
6041: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6042: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6044: FND_MSG_PUB.ADD;
6045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6038: END IF;
6039: EXCEPTION
6040: WHEN OTHERS THEN
6041: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6042: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6044: FND_MSG_PUB.ADD;
6045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6046: END;

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

6039: EXCEPTION
6040: WHEN OTHERS THEN
6041: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6042: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6044: FND_MSG_PUB.ADD;
6045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6046: END;
6047:

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

6164: END IF;
6165: END LOOP;
6166: EXCEPTION
6167: WHEN OTHERS THEN
6168: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6169: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6170: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6171: FND_MSG_PUB.ADD;
6172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6165: END LOOP;
6166: EXCEPTION
6167: WHEN OTHERS THEN
6168: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6169: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6170: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6171: FND_MSG_PUB.ADD;
6172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6173: END;

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

6166: EXCEPTION
6167: WHEN OTHERS THEN
6168: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6169: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6170: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6171: FND_MSG_PUB.ADD;
6172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6173: END;
6174:

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

6206: END IF;
6207: NULL;
6208: EXCEPTION
6209: WHEN OTHERS THEN
6210: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6211: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6212: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6213: FND_MSG_PUB.ADD;
6214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6207: NULL;
6208: EXCEPTION
6209: WHEN OTHERS THEN
6210: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6211: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6212: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6213: FND_MSG_PUB.ADD;
6214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6215: END;

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

6208: EXCEPTION
6209: WHEN OTHERS THEN
6210: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6211: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6212: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6213: FND_MSG_PUB.ADD;
6214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6215: END;
6216:

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

6249: END IF;
6250: NULL;
6251: EXCEPTION
6252: WHEN OTHERS THEN
6253: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6254: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6256: FND_MSG_PUB.ADD;
6257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6250: NULL;
6251: EXCEPTION
6252: WHEN OTHERS THEN
6253: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6254: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6256: FND_MSG_PUB.ADD;
6257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6258: END;

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

6251: EXCEPTION
6252: WHEN OTHERS THEN
6253: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6254: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6256: FND_MSG_PUB.ADD;
6257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6258: END;
6259:

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

6308: EXCEPTION
6309: WHEN FND_API.G_EXC_ERROR THEN
6310: RAISE FND_API.G_EXC_ERROR;
6311: WHEN OTHERS THEN
6312: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6313: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6314: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6315: FND_MSG_PUB.ADD;
6316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6309: WHEN FND_API.G_EXC_ERROR THEN
6310: RAISE FND_API.G_EXC_ERROR;
6311: WHEN OTHERS THEN
6312: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6313: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6314: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6315: FND_MSG_PUB.ADD;
6316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6317: END check_prim_cond;

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

6310: RAISE FND_API.G_EXC_ERROR;
6311: WHEN OTHERS THEN
6312: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6313: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6314: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6315: FND_MSG_PUB.ADD;
6316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6317: END check_prim_cond;
6318:

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

6358: NULL;
6359: END LOOP;
6360: EXCEPTION
6361: WHEN OTHERS THEN
6362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6363: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6364: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6365: FND_MSG_PUB.ADD;
6366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6359: END LOOP;
6360: EXCEPTION
6361: WHEN OTHERS THEN
6362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6363: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6364: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6365: FND_MSG_PUB.ADD;
6366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6367: END check_party_site_cond;

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

6360: EXCEPTION
6361: WHEN OTHERS THEN
6362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6363: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6364: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6365: FND_MSG_PUB.ADD;
6366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6367: END check_party_site_cond;
6368:

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

6396: NULL;
6397: END LOOP;
6398: EXCEPTION
6399: WHEN OTHERS THEN
6400: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6401: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6402: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6403: FND_MSG_PUB.ADD;
6404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6397: END LOOP;
6398: EXCEPTION
6399: WHEN OTHERS THEN
6400: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6401: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6402: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6403: FND_MSG_PUB.ADD;
6404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6405: END check_contact_cond;

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

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

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

6419: x_secondary:= FALSE;
6420:
6421: FOR I IN 1..p_contact_point_list.COUNT LOOP
6422: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6423: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6424: FND_MSG_PUB.ADD;
6425: RAISE FND_API.G_EXC_ERROR;
6426: END IF;
6427: END LOOP;

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

6433: NULL;
6434: END LOOP;
6435: EXCEPTION
6436: WHEN OTHERS THEN
6437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6438: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6439: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6440: FND_MSG_PUB.ADD;
6441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6434: END LOOP;
6435: EXCEPTION
6436: WHEN OTHERS THEN
6437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6438: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6439: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6440: FND_MSG_PUB.ADD;
6441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6442: END check_contact_point_cond;

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

6435: EXCEPTION
6436: WHEN OTHERS THEN
6437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6438: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6439: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6440: FND_MSG_PUB.ADD;
6441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6442: END check_contact_point_cond;
6443: