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

1013: BEGIN
1014: NULL ;
1015: EXCEPTION
1016: WHEN OTHERS THEN
1017: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1018: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1020: FND_MSG_PUB.ADD;
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1014: NULL ;
1015: EXCEPTION
1016: WHEN OTHERS THEN
1017: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1018: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1020: FND_MSG_PUB.ADD;
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: END;

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

1015: EXCEPTION
1016: WHEN OTHERS THEN
1017: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1018: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1020: FND_MSG_PUB.ADD;
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: END;
1023:

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

1038: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,p_search_list(1).COUNTRY);
1039: END IF ;
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1043: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1045: FND_MSG_PUB.ADD;
1046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1039: END IF ;
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1043: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1045: FND_MSG_PUB.ADD;
1046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1047: END;

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

1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1043: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1045: FND_MSG_PUB.ADD;
1046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1047: END;
1048:

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

1058: BEGIN
1059: NULL ;
1060: EXCEPTION
1061: WHEN OTHERS THEN
1062: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1063: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1064: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1065: FND_MSG_PUB.ADD;
1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1059: NULL ;
1060: EXCEPTION
1061: WHEN OTHERS THEN
1062: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1063: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1064: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1065: FND_MSG_PUB.ADD;
1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1067: END;

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

1060: EXCEPTION
1061: WHEN OTHERS THEN
1062: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1063: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1064: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1065: FND_MSG_PUB.ADD;
1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1067: END;
1068:

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

1078: BEGIN
1079: NULL ;
1080: EXCEPTION
1081: WHEN OTHERS THEN
1082: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1083: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1084: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1085: FND_MSG_PUB.ADD;
1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1079: NULL ;
1080: EXCEPTION
1081: WHEN OTHERS THEN
1082: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1083: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1084: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1085: FND_MSG_PUB.ADD;
1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1087: END;

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

1080: EXCEPTION
1081: WHEN OTHERS THEN
1082: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1083: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1084: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1085: FND_MSG_PUB.ADD;
1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1087: END;
1088:

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

1147: IF NOT check_prim_cond (p_party_search_rec,
1148: p_party_site_list,
1149: p_contact_list,
1150: p_contact_point_list) THEN
1151: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1152: FND_MSG_PUB.ADD;
1153: RAISE FND_API.G_EXC_ERROR;
1154: END IF;
1155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1415: ELSE
1416: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1417: END IF;
1418: IF lengthb(l_party_contains_str) > 4000 THEN
1419: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1420: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1421: FND_MSG_PUB.ADD;
1422: RAISE FND_API.G_EXC_ERROR;
1423: END IF;

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

1416: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1417: END IF;
1418: IF lengthb(l_party_contains_str) > 4000 THEN
1419: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1420: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1421: FND_MSG_PUB.ADD;
1422: RAISE FND_API.G_EXC_ERROR;
1423: END IF;
1424: IF (p_match_str = ' AND ' OR p_party_max_score

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

1521: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1522: END LOOP;
1523: -- Add the search criteria to query string
1524: IF lengthb(l_contains_str) > 4000 THEN
1525: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1526: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1527: FND_MSG_PUB.ADD;
1528: RAISE FND_API.G_EXC_ERROR;
1529: END IF;

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

1522: END LOOP;
1523: -- Add the search criteria to query string
1524: IF lengthb(l_contains_str) > 4000 THEN
1525: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1526: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1527: FND_MSG_PUB.ADD;
1528: RAISE FND_API.G_EXC_ERROR;
1529: END IF;
1530: x_denorm_str := l_den_contains_str;

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

1567: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1568: END LOOP;
1569: -- Add the search criteria to query string
1570: IF lengthb(l_contains_str) > 4000 THEN
1571: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1572: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1573: FND_MSG_PUB.ADD;
1574: RAISE FND_API.G_EXC_ERROR;
1575: END IF;

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

1568: END LOOP;
1569: -- Add the search criteria to query string
1570: IF lengthb(l_contains_str) > 4000 THEN
1571: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1572: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1573: FND_MSG_PUB.ADD;
1574: RAISE FND_API.G_EXC_ERROR;
1575: END IF;
1576: x_denorm_str := l_den_contains_str;

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

1648: END IF;
1649: END LOOP;
1650: -- Add the search criteria to query string
1651: IF lengthb(l_contains_str) > 4000 THEN
1652: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1653: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1654: FND_MSG_PUB.ADD;
1655: RAISE FND_API.G_EXC_ERROR;
1656: END IF;

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

1649: END LOOP;
1650: -- Add the search criteria to query string
1651: IF lengthb(l_contains_str) > 4000 THEN
1652: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1653: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1654: FND_MSG_PUB.ADD;
1655: RAISE FND_API.G_EXC_ERROR;
1656: END IF;
1657: x_denorm_str := l_den_contains_str;

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

1911: END IF;
1912: exception
1913: when others then
1914: if (instrb(SQLERRM,'DRG-51030')>0) then
1915: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1916: FND_MSG_PUB.ADD;
1917: RAISE FND_API.G_EXC_ERROR;
1918: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1919: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1915: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1916: FND_MSG_PUB.ADD;
1917: RAISE FND_API.G_EXC_ERROR;
1918: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1919: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1920: FND_MSG_PUB.ADD;
1921: RAISE FND_API.G_EXC_ERROR;
1922: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1923: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1919: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1920: FND_MSG_PUB.ADD;
1921: RAISE FND_API.G_EXC_ERROR;
1922: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1923: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1924: FND_MSG_PUB.ADD;
1925: RAISE FND_API.G_EXC_ERROR;
1926: else
1927: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1923: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1924: FND_MSG_PUB.ADD;
1925: RAISE FND_API.G_EXC_ERROR;
1926: else
1927: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1928: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1929: FND_MSG_PUB.ADD;
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: end if;

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

1924: FND_MSG_PUB.ADD;
1925: RAISE FND_API.G_EXC_ERROR;
1926: else
1927: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1928: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1929: FND_MSG_PUB.ADD;
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: end if;
1932: END;

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

2156: output_long_strings('Restrict Sql = '||p_restrict_sql);
2157: exception
2158: when others then
2159: if (instrb(SQLERRM,'DRG-51030')>0) then
2160: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2161: FND_MSG_PUB.ADD;
2162: RAISE FND_API.G_EXC_ERROR;
2163: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2160: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2161: FND_MSG_PUB.ADD;
2162: RAISE FND_API.G_EXC_ERROR;
2163: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2165: FND_MSG_PUB.ADD;
2166: RAISE FND_API.G_EXC_ERROR;
2167: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2168: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2165: FND_MSG_PUB.ADD;
2166: RAISE FND_API.G_EXC_ERROR;
2167: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2168: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2169: FND_MSG_PUB.ADD;
2170: RAISE FND_API.G_EXC_ERROR;
2171: else
2172: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2168: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2169: FND_MSG_PUB.ADD;
2170: RAISE FND_API.G_EXC_ERROR;
2171: else
2172: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2173: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2174: FND_MSG_PUB.ADD;
2175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2176: end if;

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

2169: FND_MSG_PUB.ADD;
2170: RAISE FND_API.G_EXC_ERROR;
2171: else
2172: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2173: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2174: FND_MSG_PUB.ADD;
2175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2176: end if;
2177: END;

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

2303: output_long_strings('Restrict Sql = '||p_restrict_sql);
2304: exception
2305: when others then
2306: if (instrb(SQLERRM,'DRG-51030')>0) then
2307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2308: FND_MSG_PUB.ADD;
2309: RAISE FND_API.G_EXC_ERROR;
2310: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2308: FND_MSG_PUB.ADD;
2309: RAISE FND_API.G_EXC_ERROR;
2310: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2312: FND_MSG_PUB.ADD;
2313: RAISE FND_API.G_EXC_ERROR;
2314: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2315: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2312: FND_MSG_PUB.ADD;
2313: RAISE FND_API.G_EXC_ERROR;
2314: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2315: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2316: FND_MSG_PUB.ADD;
2317: RAISE FND_API.G_EXC_ERROR;
2318: else
2319: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2315: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2316: FND_MSG_PUB.ADD;
2317: RAISE FND_API.G_EXC_ERROR;
2318: else
2319: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2320: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2321: FND_MSG_PUB.ADD;
2322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2323: end if;

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

2316: FND_MSG_PUB.ADD;
2317: RAISE FND_API.G_EXC_ERROR;
2318: else
2319: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2320: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2321: FND_MSG_PUB.ADD;
2322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2323: end if;
2324: END;

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

2576: output_long_strings('Restrict Sql = '||p_restrict_sql);
2577: exception
2578: when others then
2579: if (instrb(SQLERRM,'DRG-51030')>0) then
2580: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2581: FND_MSG_PUB.ADD;
2582: RAISE FND_API.G_EXC_ERROR;
2583: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2584: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2580: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2581: FND_MSG_PUB.ADD;
2582: RAISE FND_API.G_EXC_ERROR;
2583: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2584: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2585: FND_MSG_PUB.ADD;
2586: RAISE FND_API.G_EXC_ERROR;
2587: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2588: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2584: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2585: FND_MSG_PUB.ADD;
2586: RAISE FND_API.G_EXC_ERROR;
2587: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2588: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2589: FND_MSG_PUB.ADD;
2590: RAISE FND_API.G_EXC_ERROR;
2591: else
2592: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2588: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2589: FND_MSG_PUB.ADD;
2590: RAISE FND_API.G_EXC_ERROR;
2591: else
2592: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2594: FND_MSG_PUB.ADD;
2595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2596: end if;

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

2589: FND_MSG_PUB.ADD;
2590: RAISE FND_API.G_EXC_ERROR;
2591: else
2592: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2594: FND_MSG_PUB.ADD;
2595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2596: end if;
2597: END;

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

2851: IF p_index>1 THEN
2852: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2853: 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);
2854: END IF;
2855: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2856: FND_MSG_PUB.ADD;
2857: RAISE FND_API.G_EXC_ERROR;
2858: ELSE
2859: push_eval;

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

2901: IF p_index>1 THEN
2902: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2903: 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);
2904: END IF;
2905: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2906: FND_MSG_PUB.ADD;
2907: RAISE FND_API.G_EXC_ERROR;
2908: ELSE
2909: push_eval;

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

2974: IF p_index>1 THEN
2975: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2976: 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);
2977: END IF;
2978: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2979: FND_MSG_PUB.ADD;
2980: RAISE FND_API.G_EXC_ERROR;
2981: ELSE
2982: push_eval;

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

3086: IF p_index>1 THEN
3087: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3088: 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);
3089: END IF;
3090: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3091: FND_MSG_PUB.ADD;
3092: RAISE FND_API.G_EXC_ERROR;
3093: ELSE
3094: push_eval;

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

3197: IF p_index>1 THEN
3198: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3199: 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);
3200: END IF;
3201: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3202: FND_MSG_PUB.ADD;
3203: RAISE FND_API.G_EXC_ERROR;
3204: ELSE
3205: push_eval;

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

3422: ELSE
3423: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3424: 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);
3425: END IF;
3426: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3427: FND_MSG_PUB.ADD;
3428: RAISE FND_API.G_EXC_ERROR;
3429: END IF;
3430: ELSE

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

3430: ELSE
3431: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3432: 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);
3433: END IF;
3434: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3435: FND_MSG_PUB.ADD;
3436: RAISE FND_API.G_EXC_ERROR;
3437: END IF;
3438: END IF;

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

3636: RAISE FND_API.G_EXC_ERROR;
3637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: WHEN OTHERS THEN
3640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3641: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_parties');
3642: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3643: FND_MSG_PUB.ADD;
3644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3641: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_parties');

3637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: WHEN OTHERS THEN
3640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3641: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_parties');
3642: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3643: FND_MSG_PUB.ADD;
3644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3645: END find_parties;

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

3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: WHEN OTHERS THEN
3640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3641: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_parties');
3642: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3643: FND_MSG_PUB.ADD;
3644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3645: END find_parties;
3646:

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

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

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

3890: IF p_index>1 THEN
3891: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3892: 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);
3893: END IF;
3894: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3895: FND_MSG_PUB.ADD;
3896: RAISE FND_API.G_EXC_ERROR;
3897: ELSE
3898: push_eval;

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

3926: and d.search_context_id = p_search_ctx_id);
3927: exception
3928: when others then
3929: if (instrb(SQLERRM,'DRG-51030')>0) then
3930: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3931: FND_MSG_PUB.ADD;
3932: RAISE FND_API.G_EXC_ERROR;
3933: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3934: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3930: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3931: FND_MSG_PUB.ADD;
3932: RAISE FND_API.G_EXC_ERROR;
3933: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3934: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3935: FND_MSG_PUB.ADD;
3936: RAISE FND_API.G_EXC_ERROR;
3937: else
3938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4002: IF p_index>1 THEN
4003: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4004: 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);
4005: END IF;
4006: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4007: FND_MSG_PUB.ADD;
4008: RAISE FND_API.G_EXC_ERROR;
4009: ELSE
4010: push_eval;

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

4261: IF p_index>1 THEN
4262: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4263: 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);
4264: END IF;
4265: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4266: FND_MSG_PUB.ADD;
4267: RAISE FND_API.G_EXC_ERROR;
4268: ELSE
4269: push_eval;

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

4374: ELSE
4375: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4376: 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);
4377: END IF;
4378: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4379: FND_MSG_PUB.ADD;
4380: RAISE FND_API.G_EXC_ERROR;
4381: END IF;
4382: ELSE

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

4382: ELSE
4383: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4384: 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);
4385: END IF;
4386: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4387: FND_MSG_PUB.ADD;
4388: RAISE FND_API.G_EXC_ERROR;
4389: END IF;
4390: END IF;

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

4503: RAISE FND_API.G_EXC_ERROR;
4504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4506: WHEN OTHERS THEN
4507: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4508: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_persons');
4509: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4510: FND_MSG_PUB.ADD;
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4508: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_persons');

4504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4506: WHEN OTHERS THEN
4507: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4508: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_persons');
4509: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4510: FND_MSG_PUB.ADD;
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: END find_persons;

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

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

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

4571: RAISE FND_API.G_EXC_ERROR;
4572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4574: WHEN OTHERS THEN
4575: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4576: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_party_details');
4577: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4578: FND_MSG_PUB.ADD;
4579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4576: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_party_details');

4572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4574: WHEN OTHERS THEN
4575: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4576: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_party_details');
4577: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4578: FND_MSG_PUB.ADD;
4579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4580: END find_party_details;

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

4573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4574: WHEN OTHERS THEN
4575: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4576: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_party_details');
4577: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4578: FND_MSG_PUB.ADD;
4579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4580: END find_party_details;
4581:

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

4688: RAISE FND_API.G_EXC_ERROR;
4689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4691: WHEN OTHERS THEN
4692: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4693: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_parties');
4694: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4695: FND_MSG_PUB.ADD;
4696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4693: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_parties');

4689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4691: WHEN OTHERS THEN
4692: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4693: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_parties');
4694: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4695: FND_MSG_PUB.ADD;
4696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4697: END find_duplicate_parties;

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

4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4691: WHEN OTHERS THEN
4692: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4693: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_parties');
4694: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4695: FND_MSG_PUB.ADD;
4696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4697: END find_duplicate_parties;
4698:

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

4773: RAISE FND_API.G_EXC_ERROR;
4774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4776: WHEN OTHERS THEN
4777: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4778: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_party_sites');
4779: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4780: FND_MSG_PUB.ADD;
4781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4778: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_party_sites');

4774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4776: WHEN OTHERS THEN
4777: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4778: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_party_sites');
4779: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4780: FND_MSG_PUB.ADD;
4781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4782: END find_duplicate_party_sites;

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

4775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4776: WHEN OTHERS THEN
4777: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4778: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_party_sites');
4779: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4780: FND_MSG_PUB.ADD;
4781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4782: END find_duplicate_party_sites;
4783:

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

4862: RAISE FND_API.G_EXC_ERROR;
4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4865: WHEN OTHERS THEN
4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contacts');
4868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4869: FND_MSG_PUB.ADD;
4870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contacts');

4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4865: WHEN OTHERS THEN
4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contacts');
4868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4869: FND_MSG_PUB.ADD;
4870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4871: END find_duplicate_contacts;

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

4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4865: WHEN OTHERS THEN
4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contacts');
4868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4869: FND_MSG_PUB.ADD;
4870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4871: END find_duplicate_contacts;
4872:

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

4935: RAISE FND_API.G_EXC_ERROR;
4936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4938: WHEN OTHERS THEN
4939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4940: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contact_points');
4941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4942: FND_MSG_PUB.ADD;
4943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4940: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contact_points');

4936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4938: WHEN OTHERS THEN
4939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4940: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contact_points');
4941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4942: FND_MSG_PUB.ADD;
4943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4944: END find_duplicate_contact_points;

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

4937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4938: WHEN OTHERS THEN
4939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4940: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contact_points');
4941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4942: FND_MSG_PUB.ADD;
4943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4944: END find_duplicate_contact_points;
4945:

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

5292: RAISE FND_API.G_EXC_ERROR;
5293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5295: WHEN OTHERS THEN
5296: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5297: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.call_api_dynamic');
5298: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5299: FND_MSG_PUB.ADD;
5300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5297: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.call_api_dynamic');

5293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5295: WHEN OTHERS THEN
5296: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5297: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.call_api_dynamic');
5298: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5299: FND_MSG_PUB.ADD;
5300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5301: END call_api_dynamic;

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

5294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5295: WHEN OTHERS THEN
5296: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5297: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.call_api_dynamic');
5298: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5299: FND_MSG_PUB.ADD;
5300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5301: END call_api_dynamic;
5302:

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_33.get_matching_party_sites');
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_33.get_matching_party_sites');

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_33.get_matching_party_sites');
5542: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5543: FND_MSG_PUB.ADD;
5544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5545: END get_matching_party_sites;

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_33.get_matching_party_sites');
5542: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5543: FND_MSG_PUB.ADD;
5544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5545: END get_matching_party_sites;
5546:

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

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

Line 5769: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contacts');

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

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

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

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_33.get_matching_contact_points');
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_33.get_matching_contact_points');

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_33.get_matching_contact_points');
5912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5913: FND_MSG_PUB.ADD;
5914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5915: END get_matching_contact_points;

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_33.get_matching_contact_points');
5912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5913: FND_MSG_PUB.ADD;
5914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5915: END get_matching_contact_points;
5916:

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

6147: RAISE FND_API.G_EXC_ERROR;
6148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6150: WHEN OTHERS THEN
6151: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6152: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_score_details');
6153: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6154: FND_MSG_PUB.ADD;
6155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6152: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_score_details');

6148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6150: WHEN OTHERS THEN
6151: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6152: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_score_details');
6153: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6154: FND_MSG_PUB.ADD;
6155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6156: END get_score_details;

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

6149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6150: WHEN OTHERS THEN
6151: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6152: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_score_details');
6153: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6154: FND_MSG_PUB.ADD;
6155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6156: END get_score_details;
6157:

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

6270: RAISE FND_API.G_EXC_ERROR;
6271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6273: WHEN OTHERS THEN
6274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6275: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6276: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6277: FND_MSG_PUB.ADD;
6278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6273: WHEN OTHERS THEN
6274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6275: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6276: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6277: FND_MSG_PUB.ADD;
6278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6279: END get_party_for_search;

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

6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6273: WHEN OTHERS THEN
6274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6275: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6276: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6277: FND_MSG_PUB.ADD;
6278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6279: END get_party_for_search;
6280:

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

6322: RAISE FND_API.G_EXC_ERROR;
6323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6325: WHEN OTHERS THEN
6326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6328: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6329: FND_MSG_PUB.ADD;
6330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6325: WHEN OTHERS THEN
6326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6328: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6329: FND_MSG_PUB.ADD;
6330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6331: END get_search_criteria;

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

6324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6325: WHEN OTHERS THEN
6326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6328: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6329: FND_MSG_PUB.ADD;
6330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6331: END get_search_criteria;
6332:

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

6384: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6385:
6386: EXCEPTION
6387: WHEN OTHERS THEN
6388: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6389: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6390: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6391: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6392: FND_MSG_PUB.ADD;

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

6385:
6386: EXCEPTION
6387: WHEN OTHERS THEN
6388: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6389: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6390: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6391: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6392: FND_MSG_PUB.ADD;
6393: RAISE FND_API.G_EXC_ERROR;

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

6386: EXCEPTION
6387: WHEN OTHERS THEN
6388: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6389: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6390: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6391: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6392: FND_MSG_PUB.ADD;
6393: RAISE FND_API.G_EXC_ERROR;
6394: END get_party_rec;

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

6387: WHEN OTHERS THEN
6388: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6389: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6390: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6391: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6392: FND_MSG_PUB.ADD;
6393: RAISE FND_API.G_EXC_ERROR;
6394: END get_party_rec;
6395:

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

6448: END LOOP;
6449:
6450: EXCEPTION
6451: WHEN OTHERS THEN
6452: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6453: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6454: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6455: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6456: FND_MSG_PUB.ADD;

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

6449:
6450: EXCEPTION
6451: WHEN OTHERS THEN
6452: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6453: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6454: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6455: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6456: FND_MSG_PUB.ADD;
6457: RAISE FND_API.G_EXC_ERROR;

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

6450: EXCEPTION
6451: WHEN OTHERS THEN
6452: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6453: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6454: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6455: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6456: FND_MSG_PUB.ADD;
6457: RAISE FND_API.G_EXC_ERROR;
6458: END get_party_site_rec;

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

6451: WHEN OTHERS THEN
6452: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6453: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6454: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6455: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6456: FND_MSG_PUB.ADD;
6457: RAISE FND_API.G_EXC_ERROR;
6458: END get_party_site_rec;
6459:

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

6506: END LOOP;
6507:
6508: EXCEPTION
6509: WHEN OTHERS THEN
6510: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6511: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6512: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6513: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6514: FND_MSG_PUB.ADD;

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

6507:
6508: EXCEPTION
6509: WHEN OTHERS THEN
6510: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6511: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6512: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6513: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6514: FND_MSG_PUB.ADD;
6515: RAISE FND_API.G_EXC_ERROR;

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

6508: EXCEPTION
6509: WHEN OTHERS THEN
6510: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6511: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6512: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6513: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6514: FND_MSG_PUB.ADD;
6515: RAISE FND_API.G_EXC_ERROR;
6516: END get_contact_rec;

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

6509: WHEN OTHERS THEN
6510: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6511: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6512: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6513: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6514: FND_MSG_PUB.ADD;
6515: RAISE FND_API.G_EXC_ERROR;
6516: END get_contact_rec;
6517:

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

6562: END LOOP;
6563:
6564: EXCEPTION
6565: WHEN OTHERS THEN
6566: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6567: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6568: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6569: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6570: FND_MSG_PUB.ADD;

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

6563:
6564: EXCEPTION
6565: WHEN OTHERS THEN
6566: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6567: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6568: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6569: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6570: FND_MSG_PUB.ADD;
6571: RAISE FND_API.G_EXC_ERROR;

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

6564: EXCEPTION
6565: WHEN OTHERS THEN
6566: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6567: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6568: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6569: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6570: FND_MSG_PUB.ADD;
6571: RAISE FND_API.G_EXC_ERROR;
6572: END get_contact_point_rec;

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

6565: WHEN OTHERS THEN
6566: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6567: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6568: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6569: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6570: FND_MSG_PUB.ADD;
6571: RAISE FND_API.G_EXC_ERROR;
6572: END get_contact_point_rec;
6573:

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

6758: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6759: END IF;
6760: EXCEPTION
6761: WHEN OTHERS THEN
6762: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6763: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6764: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6765: FND_MSG_PUB.ADD;
6766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6759: END IF;
6760: EXCEPTION
6761: WHEN OTHERS THEN
6762: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6763: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6764: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6765: FND_MSG_PUB.ADD;
6766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6767: END;

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

6760: EXCEPTION
6761: WHEN OTHERS THEN
6762: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6763: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6764: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6765: FND_MSG_PUB.ADD;
6766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6767: END;
6768:

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

6997: END IF;
6998: END LOOP;
6999: EXCEPTION
7000: WHEN OTHERS THEN
7001: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7002: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7003: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7004: FND_MSG_PUB.ADD;
7005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6998: END LOOP;
6999: EXCEPTION
7000: WHEN OTHERS THEN
7001: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7002: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7003: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7004: FND_MSG_PUB.ADD;
7005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7006: END;

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

6999: EXCEPTION
7000: WHEN OTHERS THEN
7001: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7002: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7003: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7004: FND_MSG_PUB.ADD;
7005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7006: END;
7007:

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

7100: END IF;
7101: END LOOP;
7102: EXCEPTION
7103: WHEN OTHERS THEN
7104: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7105: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7107: FND_MSG_PUB.ADD;
7108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7101: END LOOP;
7102: EXCEPTION
7103: WHEN OTHERS THEN
7104: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7105: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7107: FND_MSG_PUB.ADD;
7108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7109: END;

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

7102: EXCEPTION
7103: WHEN OTHERS THEN
7104: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7105: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7107: FND_MSG_PUB.ADD;
7108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7109: END;
7110:

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

7231: END IF;
7232: END LOOP;
7233: EXCEPTION
7234: WHEN OTHERS THEN
7235: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7236: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7237: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7238: FND_MSG_PUB.ADD;
7239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7232: END LOOP;
7233: EXCEPTION
7234: WHEN OTHERS THEN
7235: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7236: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7237: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7238: FND_MSG_PUB.ADD;
7239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7240: END;

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

7233: EXCEPTION
7234: WHEN OTHERS THEN
7235: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7236: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7237: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7238: FND_MSG_PUB.ADD;
7239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7240: END;
7241:

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

7258: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
7259: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7260: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7261: ) THEN
7262: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7263: FND_MSG_PUB.ADD;
7264: RAISE FND_API.G_EXC_ERROR;
7265: END IF;
7266: END LOOP;

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

7326: EXCEPTION
7327: WHEN FND_API.G_EXC_ERROR THEN
7328: RAISE FND_API.G_EXC_ERROR;
7329: WHEN OTHERS THEN
7330: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7331: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7332: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7333: FND_MSG_PUB.ADD;
7334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7327: WHEN FND_API.G_EXC_ERROR THEN
7328: RAISE FND_API.G_EXC_ERROR;
7329: WHEN OTHERS THEN
7330: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7331: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7332: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7333: FND_MSG_PUB.ADD;
7334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7335: END check_prim_cond;

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

7328: RAISE FND_API.G_EXC_ERROR;
7329: WHEN OTHERS THEN
7330: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7331: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7332: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7333: FND_MSG_PUB.ADD;
7334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7335: END check_prim_cond;
7336:

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

7390: EXIT WHEN x_secondary;
7391: END LOOP;
7392: EXCEPTION
7393: WHEN OTHERS THEN
7394: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7395: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7396: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7397: FND_MSG_PUB.ADD;
7398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7391: END LOOP;
7392: EXCEPTION
7393: WHEN OTHERS THEN
7394: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7395: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7396: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7397: FND_MSG_PUB.ADD;
7398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7399: END check_party_site_cond;

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

7392: EXCEPTION
7393: WHEN OTHERS THEN
7394: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7395: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7396: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7397: FND_MSG_PUB.ADD;
7398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7399: END check_party_site_cond;
7400:

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

7446: EXIT WHEN x_secondary;
7447: END LOOP;
7448: EXCEPTION
7449: WHEN OTHERS THEN
7450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7451: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7453: FND_MSG_PUB.ADD;
7454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7447: END LOOP;
7448: EXCEPTION
7449: WHEN OTHERS THEN
7450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7451: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7453: FND_MSG_PUB.ADD;
7454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7455: END check_contact_cond;

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

7448: EXCEPTION
7449: WHEN OTHERS THEN
7450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7451: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7453: FND_MSG_PUB.ADD;
7454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7455: END check_contact_cond;
7456:

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

7469: x_secondary:= FALSE;
7470:
7471: FOR I IN 1..p_contact_point_list.COUNT LOOP
7472: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7473: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7474: FND_MSG_PUB.ADD;
7475: RAISE FND_API.G_EXC_ERROR;
7476: END IF;
7477: END LOOP;

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

7493: EXIT WHEN x_secondary;
7494: END LOOP;
7495: EXCEPTION
7496: WHEN OTHERS THEN
7497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7498: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7499: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7500: FND_MSG_PUB.ADD;
7501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7494: END LOOP;
7495: EXCEPTION
7496: WHEN OTHERS THEN
7497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7498: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7499: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7500: FND_MSG_PUB.ADD;
7501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7502: END check_contact_point_cond;

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

7495: EXCEPTION
7496: WHEN OTHERS THEN
7497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7498: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7499: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7500: FND_MSG_PUB.ADD;
7501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7502: END check_contact_point_cond;
7503: