eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MATCH_RULE_35 dependencies on FND_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 784: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

780: BEGIN
781: NULL ;
782: EXCEPTION
783: WHEN OTHERS THEN
784: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
785: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
786: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
787: FND_MSG_PUB.ADD;
788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

781: NULL ;
782: EXCEPTION
783: WHEN OTHERS THEN
784: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
785: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
786: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
787: FND_MSG_PUB.ADD;
788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
789: END;

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

782: EXCEPTION
783: WHEN OTHERS THEN
784: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
785: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
786: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
787: FND_MSG_PUB.ADD;
788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
789: END;
790:

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

805: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,p_search_list(1).COUNTRY);
806: END IF ;
807: EXCEPTION
808: WHEN OTHERS THEN
809: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
810: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
811: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
812: FND_MSG_PUB.ADD;
813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

806: END IF ;
807: EXCEPTION
808: WHEN OTHERS THEN
809: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
810: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
811: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
812: FND_MSG_PUB.ADD;
813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
814: END;

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

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

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

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

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

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

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

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

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

845: BEGIN
846: NULL ;
847: EXCEPTION
848: WHEN OTHERS THEN
849: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
850: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
852: FND_MSG_PUB.ADD;
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

846: NULL ;
847: EXCEPTION
848: WHEN OTHERS THEN
849: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
850: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
852: FND_MSG_PUB.ADD;
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
854: END;

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

847: EXCEPTION
848: WHEN OTHERS THEN
849: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
850: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
852: FND_MSG_PUB.ADD;
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
854: END;
855:

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

914: IF NOT check_prim_cond (p_party_search_rec,
915: p_party_site_list,
916: p_contact_list,
917: p_contact_point_list) THEN
918: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
919: FND_MSG_PUB.ADD;
920: RAISE FND_API.G_EXC_ERROR;
921: END IF;
922: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1184: ELSE
1185: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1186: END IF;
1187: IF lengthb(l_party_contains_str) > 4000 THEN
1188: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1189: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1190: FND_MSG_PUB.ADD;
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;

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

1185: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1186: END IF;
1187: IF lengthb(l_party_contains_str) > 4000 THEN
1188: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1189: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1190: FND_MSG_PUB.ADD;
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;
1193: IF (p_match_str = ' AND ' OR p_party_max_score

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

1273: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1274: END LOOP;
1275: -- Add the search criteria to query string
1276: IF lengthb(l_contains_str) > 4000 THEN
1277: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1278: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1279: FND_MSG_PUB.ADD;
1280: RAISE FND_API.G_EXC_ERROR;
1281: END IF;

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

1274: END LOOP;
1275: -- Add the search criteria to query string
1276: IF lengthb(l_contains_str) > 4000 THEN
1277: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1278: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1279: FND_MSG_PUB.ADD;
1280: RAISE FND_API.G_EXC_ERROR;
1281: END IF;
1282: x_denorm_str := l_den_contains_str;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2504: IF p_index>1 THEN
2505: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2506: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2507: END IF;
2508: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2509: FND_MSG_PUB.ADD;
2510: RAISE FND_API.G_EXC_ERROR;
2511: ELSE
2512: push_eval;

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

2552: IF p_index>1 THEN
2553: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2554: hz_utility_v2pub.debug(p_message=>'In eval party level estimated hits exceed threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2555: END IF;
2556: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2557: FND_MSG_PUB.ADD;
2558: RAISE FND_API.G_EXC_ERROR;
2559: ELSE
2560: push_eval;

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

2625: IF p_index>1 THEN
2626: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2627: hz_utility_v2pub.debug(p_message=>'In eval party site level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2628: END IF;
2629: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2630: FND_MSG_PUB.ADD;
2631: RAISE FND_API.G_EXC_ERROR;
2632: ELSE
2633: push_eval;

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

2737: IF p_index>1 THEN
2738: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2739: hz_utility_v2pub.debug(p_message=>'In eval contact level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2740: END IF;
2741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2742: FND_MSG_PUB.ADD;
2743: RAISE FND_API.G_EXC_ERROR;
2744: ELSE
2745: push_eval;

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

2848: IF p_index>1 THEN
2849: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2850: hz_utility_v2pub.debug(p_message=>'In eval contact point level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2851: END IF;
2852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2853: FND_MSG_PUB.ADD;
2854: RAISE FND_API.G_EXC_ERROR;
2855: ELSE
2856: push_eval;

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

3073: ELSE
3074: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3075: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3076: END IF;
3077: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3078: FND_MSG_PUB.ADD;
3079: RAISE FND_API.G_EXC_ERROR;
3080: END IF;
3081: ELSE

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

3081: ELSE
3082: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3083: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3084: END IF;
3085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3086: FND_MSG_PUB.ADD;
3087: RAISE FND_API.G_EXC_ERROR;
3088: END IF;
3089: END IF;

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

3287: RAISE FND_API.G_EXC_ERROR;
3288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3290: WHEN OTHERS THEN
3291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3292: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_parties');
3293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3294: FND_MSG_PUB.ADD;
3295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3292: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_parties');

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

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

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

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

3485: IF p_index>1 THEN
3486: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3487: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3488: END IF;
3489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3490: FND_MSG_PUB.ADD;
3491: RAISE FND_API.G_EXC_ERROR;
3492: ELSE
3493: push_eval;

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

3533: IF p_index>1 THEN
3534: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3535: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3536: END IF;
3537: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3538: FND_MSG_PUB.ADD;
3539: RAISE FND_API.G_EXC_ERROR;
3540: ELSE
3541: push_eval;

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

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

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

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

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

3645: IF p_index>1 THEN
3646: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3647: hz_utility_v2pub.debug(p_message=>'In eval party site level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3648: END IF;
3649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3650: FND_MSG_PUB.ADD;
3651: RAISE FND_API.G_EXC_ERROR;
3652: ELSE
3653: push_eval;

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

3904: IF p_index>1 THEN
3905: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3906: hz_utility_v2pub.debug(p_message=>'In eval contact point level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3907: END IF;
3908: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3909: FND_MSG_PUB.ADD;
3910: RAISE FND_API.G_EXC_ERROR;
3911: ELSE
3912: push_eval;

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

4017: ELSE
4018: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4019: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4020: END IF;
4021: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4022: FND_MSG_PUB.ADD;
4023: RAISE FND_API.G_EXC_ERROR;
4024: END IF;
4025: ELSE

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

4025: ELSE
4026: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4027: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4028: END IF;
4029: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4030: FND_MSG_PUB.ADD;
4031: RAISE FND_API.G_EXC_ERROR;
4032: END IF;
4033: END IF;

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

4146: RAISE FND_API.G_EXC_ERROR;
4147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4149: WHEN OTHERS THEN
4150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4151: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_persons');
4152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4153: FND_MSG_PUB.ADD;
4154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4151: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_persons');

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

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

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

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

4214: RAISE FND_API.G_EXC_ERROR;
4215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4217: WHEN OTHERS THEN
4218: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4219: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_party_details');
4220: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4221: FND_MSG_PUB.ADD;
4222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4219: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_party_details');

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

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

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

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

4331: RAISE FND_API.G_EXC_ERROR;
4332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4334: WHEN OTHERS THEN
4335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_parties');
4337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4338: FND_MSG_PUB.ADD;
4339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_parties');

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

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

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

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

4416: RAISE FND_API.G_EXC_ERROR;
4417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4419: WHEN OTHERS THEN
4420: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4421: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_party_sites');
4422: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4423: FND_MSG_PUB.ADD;
4424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4421: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_party_sites');

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

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

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

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

4505: RAISE FND_API.G_EXC_ERROR;
4506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4508: WHEN OTHERS THEN
4509: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4510: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contacts');
4511: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4512: FND_MSG_PUB.ADD;
4513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4510: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contacts');

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

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

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

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

4578: RAISE FND_API.G_EXC_ERROR;
4579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4581: WHEN OTHERS THEN
4582: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4583: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contact_points');
4584: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4585: FND_MSG_PUB.ADD;
4586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4583: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contact_points');

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

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

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

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

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

Line 4871: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.call_api_dynamic');

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

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

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

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

5104: RAISE FND_API.G_EXC_ERROR;
5105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5107: WHEN OTHERS THEN
5108: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5109: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_party_sites');
5110: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5111: FND_MSG_PUB.ADD;
5112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5109: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_party_sites');

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

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

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

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

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

Line 5334: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contacts');

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

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

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

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

5468: RAISE FND_API.G_EXC_ERROR;
5469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5471: WHEN OTHERS THEN
5472: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5473: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contact_points');
5474: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5475: FND_MSG_PUB.ADD;
5476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5473: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contact_points');

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

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

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

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

5687: RAISE FND_API.G_EXC_ERROR;
5688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5690: WHEN OTHERS THEN
5691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5692: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_score_details');
5693: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5694: FND_MSG_PUB.ADD;
5695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5692: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_score_details');

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

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

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

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

5765: RAISE FND_API.G_EXC_ERROR;
5766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5768: WHEN OTHERS THEN
5769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5770: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5771: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5772: FND_MSG_PUB.ADD;
5773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

5805: RAISE FND_API.G_EXC_ERROR;
5806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5808: WHEN OTHERS THEN
5809: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5810: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5811: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5812: FND_MSG_PUB.ADD;
5813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

5869: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
5870:
5871: EXCEPTION
5872: WHEN OTHERS THEN
5873: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5874: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5875: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5876: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5877: FND_MSG_PUB.ADD;

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

5870:
5871: EXCEPTION
5872: WHEN OTHERS THEN
5873: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5874: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5875: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5876: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5877: FND_MSG_PUB.ADD;
5878: RAISE FND_API.G_EXC_ERROR;

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

5871: EXCEPTION
5872: WHEN OTHERS THEN
5873: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5874: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5875: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5876: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5877: FND_MSG_PUB.ADD;
5878: RAISE FND_API.G_EXC_ERROR;
5879: END get_party_rec;

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

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

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

5929: END LOOP;
5930:
5931: EXCEPTION
5932: WHEN OTHERS THEN
5933: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5934: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5935: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5936: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5937: FND_MSG_PUB.ADD;

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

5930:
5931: EXCEPTION
5932: WHEN OTHERS THEN
5933: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5934: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5935: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5936: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5937: FND_MSG_PUB.ADD;
5938: RAISE FND_API.G_EXC_ERROR;

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

5931: EXCEPTION
5932: WHEN OTHERS THEN
5933: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5934: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5935: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5936: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5937: FND_MSG_PUB.ADD;
5938: RAISE FND_API.G_EXC_ERROR;
5939: END get_party_site_rec;

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

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

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

5985: END LOOP;
5986:
5987: EXCEPTION
5988: WHEN OTHERS THEN
5989: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5990: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5991: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5992: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5993: FND_MSG_PUB.ADD;

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

5986:
5987: EXCEPTION
5988: WHEN OTHERS THEN
5989: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5990: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5991: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5992: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5993: FND_MSG_PUB.ADD;
5994: RAISE FND_API.G_EXC_ERROR;

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

5987: EXCEPTION
5988: WHEN OTHERS THEN
5989: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5990: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5991: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5992: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5993: FND_MSG_PUB.ADD;
5994: RAISE FND_API.G_EXC_ERROR;
5995: END get_contact_rec;

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

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

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

6037: END LOOP;
6038:
6039: EXCEPTION
6040: WHEN OTHERS THEN
6041: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6042: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6043: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6045: FND_MSG_PUB.ADD;

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

6038:
6039: EXCEPTION
6040: WHEN OTHERS THEN
6041: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6042: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6043: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6045: FND_MSG_PUB.ADD;
6046: RAISE FND_API.G_EXC_ERROR;

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

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

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

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

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

6191: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6192: END IF;
6193: EXCEPTION
6194: WHEN OTHERS THEN
6195: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6196: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6198: FND_MSG_PUB.ADD;
6199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

6463: END IF;
6464: NULL;
6465: EXCEPTION
6466: WHEN OTHERS THEN
6467: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6468: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6469: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6470: FND_MSG_PUB.ADD;
6471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

6522: EXCEPTION
6523: WHEN FND_API.G_EXC_ERROR THEN
6524: RAISE FND_API.G_EXC_ERROR;
6525: WHEN OTHERS THEN
6526: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6527: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6528: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6529: FND_MSG_PUB.ADD;
6530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

6572: NULL;
6573: END LOOP;
6574: EXCEPTION
6575: WHEN OTHERS THEN
6576: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6577: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6578: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6579: FND_MSG_PUB.ADD;
6580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

6610: NULL;
6611: END LOOP;
6612: EXCEPTION
6613: WHEN OTHERS THEN
6614: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6615: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6616: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6617: FND_MSG_PUB.ADD;
6618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

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

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

6647: NULL;
6648: END LOOP;
6649: EXCEPTION
6650: WHEN OTHERS THEN
6651: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6652: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6654: FND_MSG_PUB.ADD;
6655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6648: END LOOP;
6649: EXCEPTION
6650: WHEN OTHERS THEN
6651: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6652: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6654: FND_MSG_PUB.ADD;
6655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6656: END check_contact_point_cond;

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

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