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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3996: RAISE FND_API.G_EXC_ERROR;
3997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3999: WHEN OTHERS THEN
4000: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4001: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_persons');
4002: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4003: FND_MSG_PUB.ADD;
4004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3999: WHEN OTHERS THEN
4000: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4001: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_persons');
4002: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4003: FND_MSG_PUB.ADD;
4004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4005: END find_persons;

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

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

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

4064: RAISE FND_API.G_EXC_ERROR;
4065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4067: WHEN OTHERS THEN
4068: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4069: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_party_details');
4070: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4071: FND_MSG_PUB.ADD;
4072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4067: WHEN OTHERS THEN
4068: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4069: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_party_details');
4070: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4071: FND_MSG_PUB.ADD;
4072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4073: END find_party_details;

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

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

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

4181: RAISE FND_API.G_EXC_ERROR;
4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4184: WHEN OTHERS THEN
4185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_parties');
4187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4188: FND_MSG_PUB.ADD;
4189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4184: WHEN OTHERS THEN
4185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_parties');
4187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4188: FND_MSG_PUB.ADD;
4189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4190: END find_duplicate_parties;

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

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

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

4266: RAISE FND_API.G_EXC_ERROR;
4267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4269: WHEN OTHERS THEN
4270: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4271: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_party_sites');
4272: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4273: FND_MSG_PUB.ADD;
4274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4269: WHEN OTHERS THEN
4270: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4271: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_party_sites');
4272: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4273: FND_MSG_PUB.ADD;
4274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4275: END find_duplicate_party_sites;

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

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

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

4355: RAISE FND_API.G_EXC_ERROR;
4356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4358: WHEN OTHERS THEN
4359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4360: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contacts');
4361: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4362: FND_MSG_PUB.ADD;
4363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4358: WHEN OTHERS THEN
4359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4360: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contacts');
4361: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4362: FND_MSG_PUB.ADD;
4363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4364: END find_duplicate_contacts;

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

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

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

4428: RAISE FND_API.G_EXC_ERROR;
4429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4431: WHEN OTHERS THEN
4432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4433: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contact_points');
4434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4435: FND_MSG_PUB.ADD;
4436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4431: WHEN OTHERS THEN
4432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4433: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contact_points');
4434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4435: FND_MSG_PUB.ADD;
4436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4437: END find_duplicate_contact_points;

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

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

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

4716: RAISE FND_API.G_EXC_ERROR;
4717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4719: WHEN OTHERS THEN
4720: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4721: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.call_api_dynamic');
4722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4723: FND_MSG_PUB.ADD;
4724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4719: WHEN OTHERS THEN
4720: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4721: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.call_api_dynamic');
4722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4723: FND_MSG_PUB.ADD;
4724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4725: END call_api_dynamic;

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

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

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

4952: RAISE FND_API.G_EXC_ERROR;
4953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4955: WHEN OTHERS THEN
4956: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4957: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_party_sites');
4958: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4959: FND_MSG_PUB.ADD;
4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4955: WHEN OTHERS THEN
4956: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4957: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_party_sites');
4958: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4959: FND_MSG_PUB.ADD;
4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4961: END get_matching_party_sites;

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

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

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

5177: RAISE FND_API.G_EXC_ERROR;
5178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5180: WHEN OTHERS THEN
5181: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5182: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contacts');
5183: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5184: FND_MSG_PUB.ADD;
5185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5180: WHEN OTHERS THEN
5181: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5182: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contacts');
5183: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5184: FND_MSG_PUB.ADD;
5185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5186: END get_matching_contacts;

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

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

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

5316: RAISE FND_API.G_EXC_ERROR;
5317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5319: WHEN OTHERS THEN
5320: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5321: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contact_points');
5322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5323: FND_MSG_PUB.ADD;
5324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5319: WHEN OTHERS THEN
5320: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5321: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contact_points');
5322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5323: FND_MSG_PUB.ADD;
5324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5325: END get_matching_contact_points;

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

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

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

5526: RAISE FND_API.G_EXC_ERROR;
5527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5529: WHEN OTHERS THEN
5530: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5531: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_score_details');
5532: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5533: FND_MSG_PUB.ADD;
5534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5529: WHEN OTHERS THEN
5530: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5531: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_score_details');
5532: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5533: FND_MSG_PUB.ADD;
5534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5535: END get_score_details;

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

5528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5529: WHEN OTHERS THEN
5530: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5531: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_score_details');
5532: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5533: FND_MSG_PUB.ADD;
5534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5535: END get_score_details;
5536:

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

5604: RAISE FND_API.G_EXC_ERROR;
5605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5607: WHEN OTHERS THEN
5608: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5609: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5610: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5611: FND_MSG_PUB.ADD;
5612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5607: WHEN OTHERS THEN
5608: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5609: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5610: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5611: FND_MSG_PUB.ADD;
5612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5613: END get_party_for_search;

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

5606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5607: WHEN OTHERS THEN
5608: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5609: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5610: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5611: FND_MSG_PUB.ADD;
5612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5613: END get_party_for_search;
5614:

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

5644: RAISE FND_API.G_EXC_ERROR;
5645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5647: WHEN OTHERS THEN
5648: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5649: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5650: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5651: FND_MSG_PUB.ADD;
5652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5647: WHEN OTHERS THEN
5648: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5649: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5650: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5651: FND_MSG_PUB.ADD;
5652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5653: END get_search_criteria;

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

5646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5647: WHEN OTHERS THEN
5648: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5649: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5650: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5651: FND_MSG_PUB.ADD;
5652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5653: END get_search_criteria;
5654:

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

5710: END IF;
5711:
5712: EXCEPTION
5713: WHEN OTHERS THEN
5714: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5715: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5716: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5717: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5718: FND_MSG_PUB.ADD;

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

5711:
5712: EXCEPTION
5713: WHEN OTHERS THEN
5714: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5715: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5716: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5717: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5718: FND_MSG_PUB.ADD;
5719: RAISE FND_API.G_EXC_ERROR;

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

5712: EXCEPTION
5713: WHEN OTHERS THEN
5714: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5715: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5716: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5717: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5718: FND_MSG_PUB.ADD;
5719: RAISE FND_API.G_EXC_ERROR;
5720: END get_party_rec;

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

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

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

5770: END LOOP;
5771:
5772: EXCEPTION
5773: WHEN OTHERS THEN
5774: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5775: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5776: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5777: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5778: FND_MSG_PUB.ADD;

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

5771:
5772: EXCEPTION
5773: WHEN OTHERS THEN
5774: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5775: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5776: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5777: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5778: FND_MSG_PUB.ADD;
5779: RAISE FND_API.G_EXC_ERROR;

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

5772: EXCEPTION
5773: WHEN OTHERS THEN
5774: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5775: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5776: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5777: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5778: FND_MSG_PUB.ADD;
5779: RAISE FND_API.G_EXC_ERROR;
5780: END get_party_site_rec;

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

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

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

5826: END LOOP;
5827:
5828: EXCEPTION
5829: WHEN OTHERS THEN
5830: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5831: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5832: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5834: FND_MSG_PUB.ADD;

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

5827:
5828: EXCEPTION
5829: WHEN OTHERS THEN
5830: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5831: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5832: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5834: FND_MSG_PUB.ADD;
5835: RAISE FND_API.G_EXC_ERROR;

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

5828: EXCEPTION
5829: WHEN OTHERS THEN
5830: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5831: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5832: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5834: FND_MSG_PUB.ADD;
5835: RAISE FND_API.G_EXC_ERROR;
5836: END get_contact_rec;

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

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

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

5878: END LOOP;
5879:
5880: EXCEPTION
5881: WHEN OTHERS THEN
5882: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5883: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5884: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5885: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5886: FND_MSG_PUB.ADD;

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

5879:
5880: EXCEPTION
5881: WHEN OTHERS THEN
5882: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5883: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5884: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5885: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5886: FND_MSG_PUB.ADD;
5887: RAISE FND_API.G_EXC_ERROR;

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

5880: EXCEPTION
5881: WHEN OTHERS THEN
5882: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5883: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5884: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5885: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5886: FND_MSG_PUB.ADD;
5887: RAISE FND_API.G_EXC_ERROR;
5888: END get_contact_point_rec;

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

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

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

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

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

6033: END IF;
6034: EXCEPTION
6035: WHEN OTHERS THEN
6036: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6037: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6038: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6039: FND_MSG_PUB.ADD;
6040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6041: END;

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

6034: EXCEPTION
6035: WHEN OTHERS THEN
6036: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6037: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6038: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6039: FND_MSG_PUB.ADD;
6040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6041: END;
6042:

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

6159: END IF;
6160: END LOOP;
6161: EXCEPTION
6162: WHEN OTHERS THEN
6163: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6164: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6165: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6166: FND_MSG_PUB.ADD;
6167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6160: END LOOP;
6161: EXCEPTION
6162: WHEN OTHERS THEN
6163: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6164: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6165: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6166: FND_MSG_PUB.ADD;
6167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6168: END;

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

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

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

6201: END IF;
6202: NULL;
6203: EXCEPTION
6204: WHEN OTHERS THEN
6205: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6206: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6208: FND_MSG_PUB.ADD;
6209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6202: NULL;
6203: EXCEPTION
6204: WHEN OTHERS THEN
6205: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6206: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6208: FND_MSG_PUB.ADD;
6209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6210: END;

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

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

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

6244: END IF;
6245: NULL;
6246: EXCEPTION
6247: WHEN OTHERS THEN
6248: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6249: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6251: FND_MSG_PUB.ADD;
6252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6245: NULL;
6246: EXCEPTION
6247: WHEN OTHERS THEN
6248: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6249: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6251: FND_MSG_PUB.ADD;
6252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6253: END;

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

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

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

6303: EXCEPTION
6304: WHEN FND_API.G_EXC_ERROR THEN
6305: RAISE FND_API.G_EXC_ERROR;
6306: WHEN OTHERS THEN
6307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6308: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6310: FND_MSG_PUB.ADD;
6311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6304: WHEN FND_API.G_EXC_ERROR THEN
6305: RAISE FND_API.G_EXC_ERROR;
6306: WHEN OTHERS THEN
6307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6308: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6310: FND_MSG_PUB.ADD;
6311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6312: END check_prim_cond;

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

6305: RAISE FND_API.G_EXC_ERROR;
6306: WHEN OTHERS THEN
6307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6308: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6310: FND_MSG_PUB.ADD;
6311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6312: END check_prim_cond;
6313:

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

6353: NULL;
6354: END LOOP;
6355: EXCEPTION
6356: WHEN OTHERS THEN
6357: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6358: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6359: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6360: FND_MSG_PUB.ADD;
6361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6354: END LOOP;
6355: EXCEPTION
6356: WHEN OTHERS THEN
6357: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6358: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6359: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6360: FND_MSG_PUB.ADD;
6361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6362: END check_party_site_cond;

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

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

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

6391: NULL;
6392: END LOOP;
6393: EXCEPTION
6394: WHEN OTHERS THEN
6395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6396: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6398: FND_MSG_PUB.ADD;
6399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6392: END LOOP;
6393: EXCEPTION
6394: WHEN OTHERS THEN
6395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6396: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6398: FND_MSG_PUB.ADD;
6399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6400: END check_contact_cond;

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

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

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

6414: x_secondary:= FALSE;
6415:
6416: FOR I IN 1..p_contact_point_list.COUNT LOOP
6417: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6418: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6419: FND_MSG_PUB.ADD;
6420: RAISE FND_API.G_EXC_ERROR;
6421: END IF;
6422: END LOOP;

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

6428: NULL;
6429: END LOOP;
6430: EXCEPTION
6431: WHEN OTHERS THEN
6432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6433: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6435: FND_MSG_PUB.ADD;
6436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6429: END LOOP;
6430: EXCEPTION
6431: WHEN OTHERS THEN
6432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6433: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6435: FND_MSG_PUB.ADD;
6436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6437: END check_contact_point_cond;

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

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