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

875: BEGIN
876: NULL ;
877: EXCEPTION
878: WHEN OTHERS THEN
879: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
880: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
881: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
882: FND_MSG_PUB.ADD;
883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

876: NULL ;
877: EXCEPTION
878: WHEN OTHERS THEN
879: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
880: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
881: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
882: FND_MSG_PUB.ADD;
883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
884: END;

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

877: EXCEPTION
878: WHEN OTHERS THEN
879: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
880: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
881: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
882: FND_MSG_PUB.ADD;
883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
884: END;
885:

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

900: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,p_search_list(1).COUNTRY);
901: END IF ;
902: EXCEPTION
903: WHEN OTHERS THEN
904: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
905: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
906: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
907: FND_MSG_PUB.ADD;
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

901: END IF ;
902: EXCEPTION
903: WHEN OTHERS THEN
904: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
905: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
906: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
907: FND_MSG_PUB.ADD;
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END;

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

902: EXCEPTION
903: WHEN OTHERS THEN
904: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
905: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
906: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
907: FND_MSG_PUB.ADD;
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END;
910:

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

920: BEGIN
921: NULL ;
922: EXCEPTION
923: WHEN OTHERS THEN
924: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
925: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
927: FND_MSG_PUB.ADD;
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

921: NULL ;
922: EXCEPTION
923: WHEN OTHERS THEN
924: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
925: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
927: FND_MSG_PUB.ADD;
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: END;

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

922: EXCEPTION
923: WHEN OTHERS THEN
924: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
925: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
927: FND_MSG_PUB.ADD;
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: END;
930:

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

940: BEGIN
941: NULL ;
942: EXCEPTION
943: WHEN OTHERS THEN
944: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
945: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
947: FND_MSG_PUB.ADD;
948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

941: NULL ;
942: EXCEPTION
943: WHEN OTHERS THEN
944: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
945: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
947: FND_MSG_PUB.ADD;
948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
949: END;

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

942: EXCEPTION
943: WHEN OTHERS THEN
944: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
945: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
947: FND_MSG_PUB.ADD;
948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
949: END;
950:

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

1009: IF NOT check_prim_cond (p_party_search_rec,
1010: p_party_site_list,
1011: p_contact_list,
1012: p_contact_point_list) THEN
1013: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1014: FND_MSG_PUB.ADD;
1015: RAISE FND_API.G_EXC_ERROR;
1016: END IF;
1017: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1226: ELSE
1227: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1228: END IF;
1229: IF lengthb(l_party_contains_str) > 4000 THEN
1230: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1231: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1232: FND_MSG_PUB.ADD;
1233: RAISE FND_API.G_EXC_ERROR;
1234: END IF;

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

1227: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1228: END IF;
1229: IF lengthb(l_party_contains_str) > 4000 THEN
1230: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1231: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1232: FND_MSG_PUB.ADD;
1233: RAISE FND_API.G_EXC_ERROR;
1234: END IF;
1235: IF (p_match_str = ' AND ' OR p_party_max_score

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

1335: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1336: END LOOP;
1337: -- Add the search criteria to query string
1338: IF lengthb(l_contains_str) > 4000 THEN
1339: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1340: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1341: FND_MSG_PUB.ADD;
1342: RAISE FND_API.G_EXC_ERROR;
1343: END IF;

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

1336: END LOOP;
1337: -- Add the search criteria to query string
1338: IF lengthb(l_contains_str) > 4000 THEN
1339: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1340: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1341: FND_MSG_PUB.ADD;
1342: RAISE FND_API.G_EXC_ERROR;
1343: END IF;
1344: x_denorm_str := l_den_contains_str;

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

1382: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1383: END LOOP;
1384: -- Add the search criteria to query string
1385: IF lengthb(l_contains_str) > 4000 THEN
1386: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1387: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1388: FND_MSG_PUB.ADD;
1389: RAISE FND_API.G_EXC_ERROR;
1390: END IF;

Line 1387: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');

1383: END LOOP;
1384: -- Add the search criteria to query string
1385: IF lengthb(l_contains_str) > 4000 THEN
1386: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1387: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1388: FND_MSG_PUB.ADD;
1389: RAISE FND_API.G_EXC_ERROR;
1390: END IF;
1391: x_denorm_str := l_den_contains_str;

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

1463: END IF;
1464: END LOOP;
1465: -- Add the search criteria to query string
1466: IF lengthb(l_contains_str) > 4000 THEN
1467: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1468: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1469: FND_MSG_PUB.ADD;
1470: RAISE FND_API.G_EXC_ERROR;
1471: END IF;

Line 1468: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');

1464: END LOOP;
1465: -- Add the search criteria to query string
1466: IF lengthb(l_contains_str) > 4000 THEN
1467: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1468: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1469: FND_MSG_PUB.ADD;
1470: RAISE FND_API.G_EXC_ERROR;
1471: END IF;
1472: x_denorm_str := l_den_contains_str;

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

1710: END IF;
1711: exception
1712: when others then
1713: if (instrb(SQLERRM,'DRG-51030')>0) then
1714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1715: FND_MSG_PUB.ADD;
1716: RAISE FND_API.G_EXC_ERROR;
1717: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1718: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1715: FND_MSG_PUB.ADD;
1716: RAISE FND_API.G_EXC_ERROR;
1717: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1718: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1719: FND_MSG_PUB.ADD;
1720: RAISE FND_API.G_EXC_ERROR;
1721: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1722: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1718: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1719: FND_MSG_PUB.ADD;
1720: RAISE FND_API.G_EXC_ERROR;
1721: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1722: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1723: FND_MSG_PUB.ADD;
1724: RAISE FND_API.G_EXC_ERROR;
1725: else
1726: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1722: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1723: FND_MSG_PUB.ADD;
1724: RAISE FND_API.G_EXC_ERROR;
1725: else
1726: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1727: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1728: FND_MSG_PUB.ADD;
1729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1730: end if;

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

1723: FND_MSG_PUB.ADD;
1724: RAISE FND_API.G_EXC_ERROR;
1725: else
1726: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1727: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1728: FND_MSG_PUB.ADD;
1729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1730: end if;
1731: END;

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

1955: output_long_strings('Restrict Sql = '||p_restrict_sql);
1956: exception
1957: when others then
1958: if (instrb(SQLERRM,'DRG-51030')>0) then
1959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1960: FND_MSG_PUB.ADD;
1961: RAISE FND_API.G_EXC_ERROR;
1962: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1960: FND_MSG_PUB.ADD;
1961: RAISE FND_API.G_EXC_ERROR;
1962: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1964: FND_MSG_PUB.ADD;
1965: RAISE FND_API.G_EXC_ERROR;
1966: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1964: FND_MSG_PUB.ADD;
1965: RAISE FND_API.G_EXC_ERROR;
1966: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1968: FND_MSG_PUB.ADD;
1969: RAISE FND_API.G_EXC_ERROR;
1970: else
1971: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1968: FND_MSG_PUB.ADD;
1969: RAISE FND_API.G_EXC_ERROR;
1970: else
1971: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1973: FND_MSG_PUB.ADD;
1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1975: end if;

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

1968: FND_MSG_PUB.ADD;
1969: RAISE FND_API.G_EXC_ERROR;
1970: else
1971: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1973: FND_MSG_PUB.ADD;
1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1975: end if;
1976: END;

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

2102: output_long_strings('Restrict Sql = '||p_restrict_sql);
2103: exception
2104: when others then
2105: if (instrb(SQLERRM,'DRG-51030')>0) then
2106: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2107: FND_MSG_PUB.ADD;
2108: RAISE FND_API.G_EXC_ERROR;
2109: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2110: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2106: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2107: FND_MSG_PUB.ADD;
2108: RAISE FND_API.G_EXC_ERROR;
2109: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2110: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2111: FND_MSG_PUB.ADD;
2112: RAISE FND_API.G_EXC_ERROR;
2113: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2114: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2110: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2111: FND_MSG_PUB.ADD;
2112: RAISE FND_API.G_EXC_ERROR;
2113: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2114: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2115: FND_MSG_PUB.ADD;
2116: RAISE FND_API.G_EXC_ERROR;
2117: else
2118: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2114: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2115: FND_MSG_PUB.ADD;
2116: RAISE FND_API.G_EXC_ERROR;
2117: else
2118: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2120: FND_MSG_PUB.ADD;
2121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2122: end if;

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

2115: FND_MSG_PUB.ADD;
2116: RAISE FND_API.G_EXC_ERROR;
2117: else
2118: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2120: FND_MSG_PUB.ADD;
2121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2122: end if;
2123: END;

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

2375: output_long_strings('Restrict Sql = '||p_restrict_sql);
2376: exception
2377: when others then
2378: if (instrb(SQLERRM,'DRG-51030')>0) then
2379: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2380: FND_MSG_PUB.ADD;
2381: RAISE FND_API.G_EXC_ERROR;
2382: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2379: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2380: FND_MSG_PUB.ADD;
2381: RAISE FND_API.G_EXC_ERROR;
2382: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2384: FND_MSG_PUB.ADD;
2385: RAISE FND_API.G_EXC_ERROR;
2386: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2387: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2384: FND_MSG_PUB.ADD;
2385: RAISE FND_API.G_EXC_ERROR;
2386: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2387: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2388: FND_MSG_PUB.ADD;
2389: RAISE FND_API.G_EXC_ERROR;
2390: else
2391: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2387: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2388: FND_MSG_PUB.ADD;
2389: RAISE FND_API.G_EXC_ERROR;
2390: else
2391: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2392: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2393: FND_MSG_PUB.ADD;
2394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2395: end if;

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

2388: FND_MSG_PUB.ADD;
2389: RAISE FND_API.G_EXC_ERROR;
2390: else
2391: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2392: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2393: FND_MSG_PUB.ADD;
2394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2395: end if;
2396: END;

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

2646: IF p_index>1 THEN
2647: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2648: 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);
2649: END IF;
2650: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2651: FND_MSG_PUB.ADD;
2652: RAISE FND_API.G_EXC_ERROR;
2653: ELSE
2654: push_eval;

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

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

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

2767: IF p_index>1 THEN
2768: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2769: 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);
2770: END IF;
2771: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2772: FND_MSG_PUB.ADD;
2773: RAISE FND_API.G_EXC_ERROR;
2774: ELSE
2775: push_eval;

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

2879: IF p_index>1 THEN
2880: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2881: 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);
2882: END IF;
2883: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2884: FND_MSG_PUB.ADD;
2885: RAISE FND_API.G_EXC_ERROR;
2886: ELSE
2887: push_eval;

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

2990: IF p_index>1 THEN
2991: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2992: 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);
2993: END IF;
2994: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2995: FND_MSG_PUB.ADD;
2996: RAISE FND_API.G_EXC_ERROR;
2997: ELSE
2998: push_eval;

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

3215: ELSE
3216: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3217: 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);
3218: END IF;
3219: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3220: FND_MSG_PUB.ADD;
3221: RAISE FND_API.G_EXC_ERROR;
3222: END IF;
3223: ELSE

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

3223: ELSE
3224: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3225: 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);
3226: END IF;
3227: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3228: FND_MSG_PUB.ADD;
3229: RAISE FND_API.G_EXC_ERROR;
3230: END IF;
3231: END IF;

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

3429: RAISE FND_API.G_EXC_ERROR;
3430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3432: WHEN OTHERS THEN
3433: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3434: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_parties');
3435: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3436: FND_MSG_PUB.ADD;
3437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3434: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_parties');

3430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3432: WHEN OTHERS THEN
3433: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3434: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_parties');
3435: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3436: FND_MSG_PUB.ADD;
3437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3438: END find_parties;

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

3431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3432: WHEN OTHERS THEN
3433: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3434: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_parties');
3435: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3436: FND_MSG_PUB.ADD;
3437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3438: END find_parties;
3439:

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

3629: IF p_index>1 THEN
3630: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3631: 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);
3632: END IF;
3633: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3634: FND_MSG_PUB.ADD;
3635: RAISE FND_API.G_EXC_ERROR;
3636: ELSE
3637: push_eval;

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

3677: IF p_index>1 THEN
3678: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3679: 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);
3680: END IF;
3681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3682: FND_MSG_PUB.ADD;
3683: RAISE FND_API.G_EXC_ERROR;
3684: ELSE
3685: push_eval;

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

3713: and d.search_context_id = p_search_ctx_id);
3714: exception
3715: when others then
3716: if (instrb(SQLERRM,'DRG-51030')>0) then
3717: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3718: FND_MSG_PUB.ADD;
3719: RAISE FND_API.G_EXC_ERROR;
3720: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3721: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3717: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3718: FND_MSG_PUB.ADD;
3719: RAISE FND_API.G_EXC_ERROR;
3720: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3721: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3722: FND_MSG_PUB.ADD;
3723: RAISE FND_API.G_EXC_ERROR;
3724: else
3725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3789: IF p_index>1 THEN
3790: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3791: 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);
3792: END IF;
3793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3794: FND_MSG_PUB.ADD;
3795: RAISE FND_API.G_EXC_ERROR;
3796: ELSE
3797: push_eval;

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

4048: IF p_index>1 THEN
4049: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4050: 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);
4051: END IF;
4052: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4053: FND_MSG_PUB.ADD;
4054: RAISE FND_API.G_EXC_ERROR;
4055: ELSE
4056: push_eval;

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

4161: ELSE
4162: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4163: 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);
4164: END IF;
4165: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4166: FND_MSG_PUB.ADD;
4167: RAISE FND_API.G_EXC_ERROR;
4168: END IF;
4169: ELSE

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

4169: ELSE
4170: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4171: 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);
4172: END IF;
4173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4174: FND_MSG_PUB.ADD;
4175: RAISE FND_API.G_EXC_ERROR;
4176: END IF;
4177: END IF;

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

4290: RAISE FND_API.G_EXC_ERROR;
4291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4293: WHEN OTHERS THEN
4294: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4295: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_persons');
4296: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4297: FND_MSG_PUB.ADD;
4298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4295: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_persons');

4291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4293: WHEN OTHERS THEN
4294: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4295: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_persons');
4296: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4297: FND_MSG_PUB.ADD;
4298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4299: END find_persons;

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

4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4293: WHEN OTHERS THEN
4294: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4295: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_persons');
4296: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4297: FND_MSG_PUB.ADD;
4298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4299: END find_persons;
4300:

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

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

Line 4363: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_party_details');

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

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

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

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

4475: RAISE FND_API.G_EXC_ERROR;
4476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4478: WHEN OTHERS THEN
4479: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4480: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_parties');
4481: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4482: FND_MSG_PUB.ADD;
4483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4480: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_parties');

4476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4478: WHEN OTHERS THEN
4479: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4480: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_parties');
4481: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4482: FND_MSG_PUB.ADD;
4483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4484: END find_duplicate_parties;

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

4477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4478: WHEN OTHERS THEN
4479: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4480: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_parties');
4481: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4482: FND_MSG_PUB.ADD;
4483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4484: END find_duplicate_parties;
4485:

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

4560: RAISE FND_API.G_EXC_ERROR;
4561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4563: WHEN OTHERS THEN
4564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4565: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_party_sites');
4566: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4567: FND_MSG_PUB.ADD;
4568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4565: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_party_sites');

4561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4563: WHEN OTHERS THEN
4564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4565: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_party_sites');
4566: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4567: FND_MSG_PUB.ADD;
4568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4569: END find_duplicate_party_sites;

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

4562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4563: WHEN OTHERS THEN
4564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4565: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_party_sites');
4566: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4567: FND_MSG_PUB.ADD;
4568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4569: END find_duplicate_party_sites;
4570:

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

4649: RAISE FND_API.G_EXC_ERROR;
4650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4652: WHEN OTHERS THEN
4653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4654: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contacts');
4655: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4656: FND_MSG_PUB.ADD;
4657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4654: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contacts');

4650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4652: WHEN OTHERS THEN
4653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4654: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contacts');
4655: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4656: FND_MSG_PUB.ADD;
4657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4658: END find_duplicate_contacts;

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

4651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4652: WHEN OTHERS THEN
4653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4654: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contacts');
4655: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4656: FND_MSG_PUB.ADD;
4657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4658: END find_duplicate_contacts;
4659:

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

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

Line 4727: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contact_points');

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

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

4724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4725: WHEN OTHERS THEN
4726: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4727: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contact_points');
4728: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4729: FND_MSG_PUB.ADD;
4730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4731: END find_duplicate_contact_points;
4732:

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

5058: RAISE FND_API.G_EXC_ERROR;
5059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5061: WHEN OTHERS THEN
5062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5063: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.call_api_dynamic');
5064: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5065: FND_MSG_PUB.ADD;
5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5063: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.call_api_dynamic');

5059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5061: WHEN OTHERS THEN
5062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5063: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.call_api_dynamic');
5064: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5065: FND_MSG_PUB.ADD;
5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5067: END call_api_dynamic;

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

5060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5061: WHEN OTHERS THEN
5062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5063: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.call_api_dynamic');
5064: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5065: FND_MSG_PUB.ADD;
5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5067: END call_api_dynamic;
5068:

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

5303: RAISE FND_API.G_EXC_ERROR;
5304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5306: WHEN OTHERS THEN
5307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5308: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_party_sites');
5309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5310: FND_MSG_PUB.ADD;
5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5308: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_party_sites');

5304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5306: WHEN OTHERS THEN
5307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5308: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_party_sites');
5309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5310: FND_MSG_PUB.ADD;
5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5312: END get_matching_party_sites;

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

5305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5306: WHEN OTHERS THEN
5307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5308: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_party_sites');
5309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5310: FND_MSG_PUB.ADD;
5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5312: END get_matching_party_sites;
5313:

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

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

Line 5537: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contacts');

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

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

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

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

5674: RAISE FND_API.G_EXC_ERROR;
5675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5677: WHEN OTHERS THEN
5678: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5679: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contact_points');
5680: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5681: FND_MSG_PUB.ADD;
5682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5679: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contact_points');

5675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5677: WHEN OTHERS THEN
5678: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5679: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contact_points');
5680: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5681: FND_MSG_PUB.ADD;
5682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5683: END get_matching_contact_points;

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

5676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5677: WHEN OTHERS THEN
5678: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5679: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contact_points');
5680: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5681: FND_MSG_PUB.ADD;
5682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5683: END get_matching_contact_points;
5684:

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

5906: RAISE FND_API.G_EXC_ERROR;
5907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5909: WHEN OTHERS THEN
5910: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5911: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_score_details');
5912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5913: FND_MSG_PUB.ADD;
5914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5911: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_score_details');

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

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

5908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5909: WHEN OTHERS THEN
5910: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5911: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_score_details');
5912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5913: FND_MSG_PUB.ADD;
5914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5915: END get_score_details;
5916:

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

6029: RAISE FND_API.G_EXC_ERROR;
6030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6032: WHEN OTHERS THEN
6033: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6034: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6035: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6036: FND_MSG_PUB.ADD;
6037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6032: WHEN OTHERS THEN
6033: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6034: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6035: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6036: FND_MSG_PUB.ADD;
6037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6038: END get_party_for_search;

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

6031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6032: WHEN OTHERS THEN
6033: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6034: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6035: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6036: FND_MSG_PUB.ADD;
6037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6038: END get_party_for_search;
6039:

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

6081: RAISE FND_API.G_EXC_ERROR;
6082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6084: WHEN OTHERS THEN
6085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6086: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6087: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6088: FND_MSG_PUB.ADD;
6089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6084: WHEN OTHERS THEN
6085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6086: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6087: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6088: FND_MSG_PUB.ADD;
6089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6090: END get_search_criteria;

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

6083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6084: WHEN OTHERS THEN
6085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6086: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6087: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6088: FND_MSG_PUB.ADD;
6089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6090: END get_search_criteria;
6091:

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

6125: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6126:
6127: EXCEPTION
6128: WHEN OTHERS THEN
6129: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6130: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6131: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6132: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6133: FND_MSG_PUB.ADD;

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

6126:
6127: EXCEPTION
6128: WHEN OTHERS THEN
6129: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6130: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6131: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6132: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6133: FND_MSG_PUB.ADD;
6134: RAISE FND_API.G_EXC_ERROR;

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

6127: EXCEPTION
6128: WHEN OTHERS THEN
6129: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6130: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6131: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6132: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6133: FND_MSG_PUB.ADD;
6134: RAISE FND_API.G_EXC_ERROR;
6135: END get_party_rec;

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

6128: WHEN OTHERS THEN
6129: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6130: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6131: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6132: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6133: FND_MSG_PUB.ADD;
6134: RAISE FND_API.G_EXC_ERROR;
6135: END get_party_rec;
6136:

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

6189: END LOOP;
6190:
6191: EXCEPTION
6192: WHEN OTHERS THEN
6193: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6194: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6195: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6197: FND_MSG_PUB.ADD;

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

6190:
6191: EXCEPTION
6192: WHEN OTHERS THEN
6193: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6194: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6195: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6197: FND_MSG_PUB.ADD;
6198: RAISE FND_API.G_EXC_ERROR;

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

6191: EXCEPTION
6192: WHEN OTHERS THEN
6193: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6194: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6195: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6197: FND_MSG_PUB.ADD;
6198: RAISE FND_API.G_EXC_ERROR;
6199: END get_party_site_rec;

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

6192: WHEN OTHERS THEN
6193: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6194: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6195: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6197: FND_MSG_PUB.ADD;
6198: RAISE FND_API.G_EXC_ERROR;
6199: END get_party_site_rec;
6200:

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

6247: END LOOP;
6248:
6249: EXCEPTION
6250: WHEN OTHERS THEN
6251: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6252: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6253: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6254: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6255: FND_MSG_PUB.ADD;

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

6248:
6249: EXCEPTION
6250: WHEN OTHERS THEN
6251: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6252: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6253: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6254: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6255: FND_MSG_PUB.ADD;
6256: RAISE FND_API.G_EXC_ERROR;

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

6249: EXCEPTION
6250: WHEN OTHERS THEN
6251: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6252: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6253: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6254: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6255: FND_MSG_PUB.ADD;
6256: RAISE FND_API.G_EXC_ERROR;
6257: END get_contact_rec;

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

6250: WHEN OTHERS THEN
6251: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6252: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6253: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6254: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6255: FND_MSG_PUB.ADD;
6256: RAISE FND_API.G_EXC_ERROR;
6257: END get_contact_rec;
6258:

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

6303: END LOOP;
6304:
6305: EXCEPTION
6306: WHEN OTHERS THEN
6307: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6308: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6309: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6310: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6311: FND_MSG_PUB.ADD;

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

6304:
6305: EXCEPTION
6306: WHEN OTHERS THEN
6307: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6308: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6309: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6310: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6311: FND_MSG_PUB.ADD;
6312: RAISE FND_API.G_EXC_ERROR;

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

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

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

6306: WHEN OTHERS THEN
6307: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6308: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6309: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6310: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6311: FND_MSG_PUB.ADD;
6312: RAISE FND_API.G_EXC_ERROR;
6313: END get_contact_point_rec;
6314:

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

6400: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6401: END IF;
6402: EXCEPTION
6403: WHEN OTHERS THEN
6404: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6405: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6407: FND_MSG_PUB.ADD;
6408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6401: END IF;
6402: EXCEPTION
6403: WHEN OTHERS THEN
6404: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6405: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6407: FND_MSG_PUB.ADD;
6408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6409: END;

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

6402: EXCEPTION
6403: WHEN OTHERS THEN
6404: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6405: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6407: FND_MSG_PUB.ADD;
6408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6409: END;
6410:

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

6641: END IF;
6642: END LOOP;
6643: EXCEPTION
6644: WHEN OTHERS THEN
6645: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6646: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6648: FND_MSG_PUB.ADD;
6649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6642: END LOOP;
6643: EXCEPTION
6644: WHEN OTHERS THEN
6645: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6646: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6648: FND_MSG_PUB.ADD;
6649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6650: END;

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

6643: EXCEPTION
6644: WHEN OTHERS THEN
6645: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6646: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6648: FND_MSG_PUB.ADD;
6649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6650: END;
6651:

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

6698: END IF;
6699: END LOOP;
6700: EXCEPTION
6701: WHEN OTHERS THEN
6702: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6703: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6705: FND_MSG_PUB.ADD;
6706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6699: END LOOP;
6700: EXCEPTION
6701: WHEN OTHERS THEN
6702: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6703: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6705: FND_MSG_PUB.ADD;
6706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6707: END;

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

6700: EXCEPTION
6701: WHEN OTHERS THEN
6702: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6703: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6705: FND_MSG_PUB.ADD;
6706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6707: END;
6708:

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

6829: END IF;
6830: END LOOP;
6831: EXCEPTION
6832: WHEN OTHERS THEN
6833: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6834: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6835: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6836: FND_MSG_PUB.ADD;
6837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6830: END LOOP;
6831: EXCEPTION
6832: WHEN OTHERS THEN
6833: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6834: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6835: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6836: FND_MSG_PUB.ADD;
6837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6838: END;

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

6831: EXCEPTION
6832: WHEN OTHERS THEN
6833: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6834: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6835: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6836: FND_MSG_PUB.ADD;
6837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6838: END;
6839:

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

6856: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6857: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6858: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6859: ) THEN
6860: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6861: FND_MSG_PUB.ADD;
6862: RAISE FND_API.G_EXC_ERROR;
6863: END IF;
6864: END LOOP;

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

6915: EXCEPTION
6916: WHEN FND_API.G_EXC_ERROR THEN
6917: RAISE FND_API.G_EXC_ERROR;
6918: WHEN OTHERS THEN
6919: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6920: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6921: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6922: FND_MSG_PUB.ADD;
6923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6916: WHEN FND_API.G_EXC_ERROR THEN
6917: RAISE FND_API.G_EXC_ERROR;
6918: WHEN OTHERS THEN
6919: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6920: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6921: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6922: FND_MSG_PUB.ADD;
6923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6924: END check_prim_cond;

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

6917: RAISE FND_API.G_EXC_ERROR;
6918: WHEN OTHERS THEN
6919: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6920: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6921: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6922: FND_MSG_PUB.ADD;
6923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6924: END check_prim_cond;
6925:

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

6979: EXIT WHEN x_secondary;
6980: END LOOP;
6981: EXCEPTION
6982: WHEN OTHERS THEN
6983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6984: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6986: FND_MSG_PUB.ADD;
6987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6980: END LOOP;
6981: EXCEPTION
6982: WHEN OTHERS THEN
6983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6984: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6986: FND_MSG_PUB.ADD;
6987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6988: END check_party_site_cond;

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

6981: EXCEPTION
6982: WHEN OTHERS THEN
6983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6984: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6986: FND_MSG_PUB.ADD;
6987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6988: END check_party_site_cond;
6989:

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

7035: EXIT WHEN x_secondary;
7036: END LOOP;
7037: EXCEPTION
7038: WHEN OTHERS THEN
7039: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7040: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7041: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7042: FND_MSG_PUB.ADD;
7043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7036: END LOOP;
7037: EXCEPTION
7038: WHEN OTHERS THEN
7039: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7040: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7041: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7042: FND_MSG_PUB.ADD;
7043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7044: END check_contact_cond;

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

7037: EXCEPTION
7038: WHEN OTHERS THEN
7039: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7040: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7041: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7042: FND_MSG_PUB.ADD;
7043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7044: END check_contact_cond;
7045:

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

7058: x_secondary:= FALSE;
7059:
7060: FOR I IN 1..p_contact_point_list.COUNT LOOP
7061: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7062: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7063: FND_MSG_PUB.ADD;
7064: RAISE FND_API.G_EXC_ERROR;
7065: END IF;
7066: END LOOP;

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

7082: EXIT WHEN x_secondary;
7083: END LOOP;
7084: EXCEPTION
7085: WHEN OTHERS THEN
7086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7087: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7088: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7089: FND_MSG_PUB.ADD;
7090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7083: END LOOP;
7084: EXCEPTION
7085: WHEN OTHERS THEN
7086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7087: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7088: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7089: FND_MSG_PUB.ADD;
7090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7091: END check_contact_point_cond;

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

7084: EXCEPTION
7085: WHEN OTHERS THEN
7086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7087: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7088: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7089: FND_MSG_PUB.ADD;
7090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7091: END check_contact_point_cond;
7092: