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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4297: WHEN OTHERS THEN
4298: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4299: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_persons');
4300: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4301: FND_MSG_PUB.ADD;
4302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4303: END find_persons;
4304:

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

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

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

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

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

4364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4365: WHEN OTHERS THEN
4366: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4367: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_party_details');
4368: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4369: FND_MSG_PUB.ADD;
4370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4371: END find_party_details;
4372:

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

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

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

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

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

4481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4482: WHEN OTHERS THEN
4483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4484: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_parties');
4485: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4486: FND_MSG_PUB.ADD;
4487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4488: END find_duplicate_parties;
4489:

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

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

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

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

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

4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4567: WHEN OTHERS THEN
4568: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4569: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_party_sites');
4570: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4571: FND_MSG_PUB.ADD;
4572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4573: END find_duplicate_party_sites;
4574:

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

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

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

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

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

4655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4656: WHEN OTHERS THEN
4657: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4658: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contacts');
4659: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4660: FND_MSG_PUB.ADD;
4661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4662: END find_duplicate_contacts;
4663:

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

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

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

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

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

4728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4729: WHEN OTHERS THEN
4730: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4731: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contact_points');
4732: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4733: FND_MSG_PUB.ADD;
4734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4735: END find_duplicate_contact_points;
4736:

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

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

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

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

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

5064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5065: WHEN OTHERS THEN
5066: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5067: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.call_api_dynamic');
5068: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5069: FND_MSG_PUB.ADD;
5070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5071: END call_api_dynamic;
5072:

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

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

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

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

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

5309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5310: WHEN OTHERS THEN
5311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5312: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_party_sites');
5313: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5314: FND_MSG_PUB.ADD;
5315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5316: END get_matching_party_sites;
5317:

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

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

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

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

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

5538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5539: WHEN OTHERS THEN
5540: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5541: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contacts');
5542: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5543: FND_MSG_PUB.ADD;
5544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5545: END get_matching_contacts;
5546:

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

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

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

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

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

5680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5681: WHEN OTHERS THEN
5682: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5683: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contact_points');
5684: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5685: FND_MSG_PUB.ADD;
5686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5687: END get_matching_contact_points;
5688:

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

5911: RAISE FND_API.G_EXC_ERROR;
5912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5914: WHEN OTHERS THEN
5915: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5916: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_score_details');
5917: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5918: FND_MSG_PUB.ADD;
5919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5914: WHEN OTHERS THEN
5915: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5916: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_score_details');
5917: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5918: FND_MSG_PUB.ADD;
5919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5920: END get_score_details;

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

5913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5914: WHEN OTHERS THEN
5915: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5916: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_score_details');
5917: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5918: FND_MSG_PUB.ADD;
5919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5920: END get_score_details;
5921:

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

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

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

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

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

6036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6037: WHEN OTHERS THEN
6038: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6039: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6040: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6041: FND_MSG_PUB.ADD;
6042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6043: END get_party_for_search;
6044:

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

6086: RAISE FND_API.G_EXC_ERROR;
6087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6089: WHEN OTHERS THEN
6090: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6091: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6092: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6093: FND_MSG_PUB.ADD;
6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6089: WHEN OTHERS THEN
6090: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6091: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6092: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6093: FND_MSG_PUB.ADD;
6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6095: END get_search_criteria;

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

6088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6089: WHEN OTHERS THEN
6090: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6091: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6092: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6093: FND_MSG_PUB.ADD;
6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6095: END get_search_criteria;
6096:

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

6130: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6131:
6132: EXCEPTION
6133: WHEN OTHERS THEN
6134: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6135: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6136: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6137: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6138: FND_MSG_PUB.ADD;

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

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

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

6132: EXCEPTION
6133: WHEN OTHERS THEN
6134: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6135: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6136: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6137: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6138: FND_MSG_PUB.ADD;
6139: RAISE FND_API.G_EXC_ERROR;
6140: END get_party_rec;

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

6133: WHEN OTHERS THEN
6134: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6135: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6136: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6137: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6138: FND_MSG_PUB.ADD;
6139: RAISE FND_API.G_EXC_ERROR;
6140: END get_party_rec;
6141:

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

6194: END LOOP;
6195:
6196: EXCEPTION
6197: WHEN OTHERS THEN
6198: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6199: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6200: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6201: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6202: FND_MSG_PUB.ADD;

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

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

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

6196: EXCEPTION
6197: WHEN OTHERS THEN
6198: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6199: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6200: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6201: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6202: FND_MSG_PUB.ADD;
6203: RAISE FND_API.G_EXC_ERROR;
6204: END get_party_site_rec;

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

6197: WHEN OTHERS THEN
6198: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6199: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6200: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6201: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6202: FND_MSG_PUB.ADD;
6203: RAISE FND_API.G_EXC_ERROR;
6204: END get_party_site_rec;
6205:

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

6252: END LOOP;
6253:
6254: EXCEPTION
6255: WHEN OTHERS THEN
6256: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6257: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6258: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6260: FND_MSG_PUB.ADD;

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

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

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

6254: EXCEPTION
6255: WHEN OTHERS THEN
6256: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6257: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6258: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6260: FND_MSG_PUB.ADD;
6261: RAISE FND_API.G_EXC_ERROR;
6262: END get_contact_rec;

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

6255: WHEN OTHERS THEN
6256: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6257: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6258: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6260: FND_MSG_PUB.ADD;
6261: RAISE FND_API.G_EXC_ERROR;
6262: END get_contact_rec;
6263:

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

6308: END LOOP;
6309:
6310: EXCEPTION
6311: WHEN OTHERS THEN
6312: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6313: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6314: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6315: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6316: FND_MSG_PUB.ADD;

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

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

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

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

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

6311: WHEN OTHERS THEN
6312: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6313: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6314: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6315: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6316: FND_MSG_PUB.ADD;
6317: RAISE FND_API.G_EXC_ERROR;
6318: END get_contact_point_rec;
6319:

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

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

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

6406: END IF;
6407: EXCEPTION
6408: WHEN OTHERS THEN
6409: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6410: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6411: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6412: FND_MSG_PUB.ADD;
6413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6414: END;

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

6407: EXCEPTION
6408: WHEN OTHERS THEN
6409: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6410: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6411: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6412: FND_MSG_PUB.ADD;
6413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6414: END;
6415:

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

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

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

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

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

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

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

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

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

6704: END LOOP;
6705: EXCEPTION
6706: WHEN OTHERS THEN
6707: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6708: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6709: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6710: FND_MSG_PUB.ADD;
6711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6712: END;

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

6705: EXCEPTION
6706: WHEN OTHERS THEN
6707: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6708: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6709: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6710: FND_MSG_PUB.ADD;
6711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6712: END;
6713:

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

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

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

6835: END LOOP;
6836: EXCEPTION
6837: WHEN OTHERS THEN
6838: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6839: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6840: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6841: FND_MSG_PUB.ADD;
6842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6843: END;

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

6836: EXCEPTION
6837: WHEN OTHERS THEN
6838: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6839: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6840: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6841: FND_MSG_PUB.ADD;
6842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6843: END;
6844:

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

6861: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6862: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6863: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6864: ) THEN
6865: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6866: FND_MSG_PUB.ADD;
6867: RAISE FND_API.G_EXC_ERROR;
6868: END IF;
6869: END LOOP;

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

6920: EXCEPTION
6921: WHEN FND_API.G_EXC_ERROR THEN
6922: RAISE FND_API.G_EXC_ERROR;
6923: WHEN OTHERS THEN
6924: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6925: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6927: FND_MSG_PUB.ADD;
6928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6921: WHEN FND_API.G_EXC_ERROR THEN
6922: RAISE FND_API.G_EXC_ERROR;
6923: WHEN OTHERS THEN
6924: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6925: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6927: FND_MSG_PUB.ADD;
6928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6929: END check_prim_cond;

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

6922: RAISE FND_API.G_EXC_ERROR;
6923: WHEN OTHERS THEN
6924: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6925: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6927: FND_MSG_PUB.ADD;
6928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6929: END check_prim_cond;
6930:

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

6984: EXIT WHEN x_secondary;
6985: END LOOP;
6986: EXCEPTION
6987: WHEN OTHERS THEN
6988: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6989: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6990: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6991: FND_MSG_PUB.ADD;
6992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6985: END LOOP;
6986: EXCEPTION
6987: WHEN OTHERS THEN
6988: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6989: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6990: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6991: FND_MSG_PUB.ADD;
6992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6993: END check_party_site_cond;

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

6986: EXCEPTION
6987: WHEN OTHERS THEN
6988: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6989: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6990: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6991: FND_MSG_PUB.ADD;
6992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6993: END check_party_site_cond;
6994:

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

7040: EXIT WHEN x_secondary;
7041: END LOOP;
7042: EXCEPTION
7043: WHEN OTHERS THEN
7044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7045: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7047: FND_MSG_PUB.ADD;
7048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7041: END LOOP;
7042: EXCEPTION
7043: WHEN OTHERS THEN
7044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7045: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7047: FND_MSG_PUB.ADD;
7048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7049: END check_contact_cond;

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

7042: EXCEPTION
7043: WHEN OTHERS THEN
7044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7045: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7047: FND_MSG_PUB.ADD;
7048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7049: END check_contact_cond;
7050:

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

7063: x_secondary:= FALSE;
7064:
7065: FOR I IN 1..p_contact_point_list.COUNT LOOP
7066: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7067: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7068: FND_MSG_PUB.ADD;
7069: RAISE FND_API.G_EXC_ERROR;
7070: END IF;
7071: END LOOP;

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

7087: EXIT WHEN x_secondary;
7088: END LOOP;
7089: EXCEPTION
7090: WHEN OTHERS THEN
7091: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7092: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7093: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7094: FND_MSG_PUB.ADD;
7095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7088: END LOOP;
7089: EXCEPTION
7090: WHEN OTHERS THEN
7091: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7092: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7093: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7094: FND_MSG_PUB.ADD;
7095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7096: END check_contact_point_cond;

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

7089: EXCEPTION
7090: WHEN OTHERS THEN
7091: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7092: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7093: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7094: FND_MSG_PUB.ADD;
7095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7096: END check_contact_point_cond;
7097: