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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2848: IF p_index>1 THEN
2849: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2850: hz_utility_v2pub.debug(p_message=>'In eval 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);
2851: END IF;
2852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2853: FND_MSG_PUB.ADD;
2854: RAISE FND_API.G_EXC_ERROR;
2855: ELSE
2856: push_eval;

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

2896: IF p_index>1 THEN
2897: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2898: 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);
2899: END IF;
2900: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2901: FND_MSG_PUB.ADD;
2902: RAISE FND_API.G_EXC_ERROR;
2903: ELSE
2904: push_eval;

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

2969: IF p_index>1 THEN
2970: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2971: 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);
2972: END IF;
2973: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2974: FND_MSG_PUB.ADD;
2975: RAISE FND_API.G_EXC_ERROR;
2976: ELSE
2977: push_eval;

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

3081: IF p_index>1 THEN
3082: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3083: 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);
3084: END IF;
3085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3086: FND_MSG_PUB.ADD;
3087: RAISE FND_API.G_EXC_ERROR;
3088: ELSE
3089: push_eval;

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

3192: IF p_index>1 THEN
3193: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3194: 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);
3195: END IF;
3196: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3197: FND_MSG_PUB.ADD;
3198: RAISE FND_API.G_EXC_ERROR;
3199: ELSE
3200: push_eval;

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

3417: ELSE
3418: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3419: 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);
3420: END IF;
3421: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3422: FND_MSG_PUB.ADD;
3423: RAISE FND_API.G_EXC_ERROR;
3424: END IF;
3425: ELSE

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

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

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

3631: RAISE FND_API.G_EXC_ERROR;
3632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3634: WHEN OTHERS THEN
3635: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3636: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_parties');
3637: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3638: FND_MSG_PUB.ADD;
3639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3634: WHEN OTHERS THEN
3635: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3636: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_parties');
3637: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3638: FND_MSG_PUB.ADD;
3639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3640: END find_parties;

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

3633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3634: WHEN OTHERS THEN
3635: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3636: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_parties');
3637: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3638: FND_MSG_PUB.ADD;
3639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3640: END find_parties;
3641:

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

3834: IF p_index>1 THEN
3835: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3836: 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);
3837: END IF;
3838: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3839: FND_MSG_PUB.ADD;
3840: RAISE FND_API.G_EXC_ERROR;
3841: ELSE
3842: push_eval;

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

3882: IF p_index>1 THEN
3883: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3884: 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);
3885: END IF;
3886: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3887: FND_MSG_PUB.ADD;
3888: RAISE FND_API.G_EXC_ERROR;
3889: ELSE
3890: push_eval;

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

3918: and d.search_context_id = p_search_ctx_id);
3919: exception
3920: when others then
3921: if (instrb(SQLERRM,'DRG-51030')>0) then
3922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3923: FND_MSG_PUB.ADD;
3924: RAISE FND_API.G_EXC_ERROR;
3925: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3923: FND_MSG_PUB.ADD;
3924: RAISE FND_API.G_EXC_ERROR;
3925: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3927: FND_MSG_PUB.ADD;
3928: RAISE FND_API.G_EXC_ERROR;
3929: else
3930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3994: IF p_index>1 THEN
3995: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3996: 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);
3997: END IF;
3998: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3999: FND_MSG_PUB.ADD;
4000: RAISE FND_API.G_EXC_ERROR;
4001: ELSE
4002: push_eval;

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

4253: IF p_index>1 THEN
4254: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4255: 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);
4256: END IF;
4257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4258: FND_MSG_PUB.ADD;
4259: RAISE FND_API.G_EXC_ERROR;
4260: ELSE
4261: push_eval;

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

4366: ELSE
4367: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4368: 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);
4369: END IF;
4370: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4371: FND_MSG_PUB.ADD;
4372: RAISE FND_API.G_EXC_ERROR;
4373: END IF;
4374: ELSE

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: END IF;

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

4495: RAISE FND_API.G_EXC_ERROR;
4496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4498: WHEN OTHERS THEN
4499: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4500: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_persons');
4501: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4502: FND_MSG_PUB.ADD;
4503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4498: WHEN OTHERS THEN
4499: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4500: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_persons');
4501: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4502: FND_MSG_PUB.ADD;
4503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4504: END find_persons;

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

4497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4498: WHEN OTHERS THEN
4499: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4500: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_persons');
4501: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4502: FND_MSG_PUB.ADD;
4503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4504: END find_persons;
4505:

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

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

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

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

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

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

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

4680: RAISE FND_API.G_EXC_ERROR;
4681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4683: WHEN OTHERS THEN
4684: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4685: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_parties');
4686: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4687: FND_MSG_PUB.ADD;
4688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4683: WHEN OTHERS THEN
4684: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4685: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_parties');
4686: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4687: FND_MSG_PUB.ADD;
4688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4689: END find_duplicate_parties;

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

4682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4683: WHEN OTHERS THEN
4684: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4685: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_parties');
4686: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4687: FND_MSG_PUB.ADD;
4688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4689: END find_duplicate_parties;
4690:

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

4765: RAISE FND_API.G_EXC_ERROR;
4766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4768: WHEN OTHERS THEN
4769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4770: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_party_sites');
4771: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4772: FND_MSG_PUB.ADD;
4773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4768: WHEN OTHERS THEN
4769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4770: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_party_sites');
4771: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4772: FND_MSG_PUB.ADD;
4773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4774: END find_duplicate_party_sites;

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

4767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4768: WHEN OTHERS THEN
4769: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4770: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_party_sites');
4771: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4772: FND_MSG_PUB.ADD;
4773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4774: END find_duplicate_party_sites;
4775:

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

4854: RAISE FND_API.G_EXC_ERROR;
4855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4857: WHEN OTHERS THEN
4858: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4859: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contacts');
4860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4861: FND_MSG_PUB.ADD;
4862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4857: WHEN OTHERS THEN
4858: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4859: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contacts');
4860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4861: FND_MSG_PUB.ADD;
4862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4863: END find_duplicate_contacts;

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

4856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4857: WHEN OTHERS THEN
4858: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4859: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contacts');
4860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4861: FND_MSG_PUB.ADD;
4862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4863: END find_duplicate_contacts;
4864:

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

4927: RAISE FND_API.G_EXC_ERROR;
4928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4930: WHEN OTHERS THEN
4931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contact_points');
4933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4934: FND_MSG_PUB.ADD;
4935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4930: WHEN OTHERS THEN
4931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contact_points');
4933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4934: FND_MSG_PUB.ADD;
4935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4936: END find_duplicate_contact_points;

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

4929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4930: WHEN OTHERS THEN
4931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.find_duplicate_contact_points');
4933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4934: FND_MSG_PUB.ADD;
4935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4936: END find_duplicate_contact_points;
4937:

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

5284: RAISE FND_API.G_EXC_ERROR;
5285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5287: WHEN OTHERS THEN
5288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.call_api_dynamic');
5290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5291: FND_MSG_PUB.ADD;
5292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5287: WHEN OTHERS THEN
5288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.call_api_dynamic');
5290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5291: FND_MSG_PUB.ADD;
5292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5293: END call_api_dynamic;

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

5286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5287: WHEN OTHERS THEN
5288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.call_api_dynamic');
5290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5291: FND_MSG_PUB.ADD;
5292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5293: END call_api_dynamic;
5294:

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

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

Line 5533: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_party_sites');

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

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

5530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5531: WHEN OTHERS THEN
5532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5533: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_party_sites');
5534: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5535: FND_MSG_PUB.ADD;
5536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5537: END get_matching_party_sites;
5538:

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

5756: RAISE FND_API.G_EXC_ERROR;
5757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5759: WHEN OTHERS THEN
5760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5761: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contacts');
5762: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5763: FND_MSG_PUB.ADD;
5764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5759: WHEN OTHERS THEN
5760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5761: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contacts');
5762: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5763: FND_MSG_PUB.ADD;
5764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5765: END get_matching_contacts;

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

5758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5759: WHEN OTHERS THEN
5760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5761: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contacts');
5762: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5763: FND_MSG_PUB.ADD;
5764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5765: END get_matching_contacts;
5766:

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

5898: RAISE FND_API.G_EXC_ERROR;
5899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5901: WHEN OTHERS THEN
5902: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5903: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contact_points');
5904: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5905: FND_MSG_PUB.ADD;
5906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5903: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contact_points');

5899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5901: WHEN OTHERS THEN
5902: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5903: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contact_points');
5904: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5905: FND_MSG_PUB.ADD;
5906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5907: END get_matching_contact_points;

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

5900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5901: WHEN OTHERS THEN
5902: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5903: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_matching_contact_points');
5904: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5905: FND_MSG_PUB.ADD;
5906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5907: END get_matching_contact_points;
5908:

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

6136: RAISE FND_API.G_EXC_ERROR;
6137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6139: WHEN OTHERS THEN
6140: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6141: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_score_details');
6142: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6143: FND_MSG_PUB.ADD;
6144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6139: WHEN OTHERS THEN
6140: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6141: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_score_details');
6142: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6143: FND_MSG_PUB.ADD;
6144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6145: END get_score_details;

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

6138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6139: WHEN OTHERS THEN
6140: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6141: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_33.get_score_details');
6142: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6143: FND_MSG_PUB.ADD;
6144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6145: END get_score_details;
6146:

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

6259: RAISE FND_API.G_EXC_ERROR;
6260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6262: WHEN OTHERS THEN
6263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6264: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6265: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6266: FND_MSG_PUB.ADD;
6267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6262: WHEN OTHERS THEN
6263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6264: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6265: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6266: FND_MSG_PUB.ADD;
6267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6268: END get_party_for_search;

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

6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6262: WHEN OTHERS THEN
6263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6264: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6265: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6266: FND_MSG_PUB.ADD;
6267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6268: END get_party_for_search;
6269:

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

6311: RAISE FND_API.G_EXC_ERROR;
6312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6314: WHEN OTHERS THEN
6315: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6316: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6318: FND_MSG_PUB.ADD;
6319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6314: WHEN OTHERS THEN
6315: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6316: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6318: FND_MSG_PUB.ADD;
6319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6320: END get_search_criteria;

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

6313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6314: WHEN OTHERS THEN
6315: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6316: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6318: FND_MSG_PUB.ADD;
6319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6320: END get_search_criteria;
6321:

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

6373: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6374:
6375: EXCEPTION
6376: WHEN OTHERS THEN
6377: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6378: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6379: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6380: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6381: FND_MSG_PUB.ADD;

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

6374:
6375: EXCEPTION
6376: WHEN OTHERS THEN
6377: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6378: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6379: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6380: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6381: FND_MSG_PUB.ADD;
6382: RAISE FND_API.G_EXC_ERROR;

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

6375: EXCEPTION
6376: WHEN OTHERS THEN
6377: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6378: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6379: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6380: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6381: FND_MSG_PUB.ADD;
6382: RAISE FND_API.G_EXC_ERROR;
6383: END get_party_rec;

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

6376: WHEN OTHERS THEN
6377: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6378: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6379: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6380: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6381: FND_MSG_PUB.ADD;
6382: RAISE FND_API.G_EXC_ERROR;
6383: END get_party_rec;
6384:

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

6437: END LOOP;
6438:
6439: EXCEPTION
6440: WHEN OTHERS THEN
6441: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6442: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6443: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6445: FND_MSG_PUB.ADD;

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

6438:
6439: EXCEPTION
6440: WHEN OTHERS THEN
6441: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6442: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6443: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6445: FND_MSG_PUB.ADD;
6446: RAISE FND_API.G_EXC_ERROR;

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

6439: EXCEPTION
6440: WHEN OTHERS THEN
6441: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6442: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6443: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6445: FND_MSG_PUB.ADD;
6446: RAISE FND_API.G_EXC_ERROR;
6447: END get_party_site_rec;

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

6440: WHEN OTHERS THEN
6441: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6442: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6443: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6445: FND_MSG_PUB.ADD;
6446: RAISE FND_API.G_EXC_ERROR;
6447: END get_party_site_rec;
6448:

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

6495: END LOOP;
6496:
6497: EXCEPTION
6498: WHEN OTHERS THEN
6499: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6500: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6501: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6503: FND_MSG_PUB.ADD;

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

6496:
6497: EXCEPTION
6498: WHEN OTHERS THEN
6499: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6500: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6501: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6503: FND_MSG_PUB.ADD;
6504: RAISE FND_API.G_EXC_ERROR;

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

6497: EXCEPTION
6498: WHEN OTHERS THEN
6499: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6500: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6501: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6503: FND_MSG_PUB.ADD;
6504: RAISE FND_API.G_EXC_ERROR;
6505: END get_contact_rec;

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

6498: WHEN OTHERS THEN
6499: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6500: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6501: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6503: FND_MSG_PUB.ADD;
6504: RAISE FND_API.G_EXC_ERROR;
6505: END get_contact_rec;
6506:

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

6551: END LOOP;
6552:
6553: EXCEPTION
6554: WHEN OTHERS THEN
6555: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6556: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6557: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6558: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6559: FND_MSG_PUB.ADD;

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

6552:
6553: EXCEPTION
6554: WHEN OTHERS THEN
6555: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6556: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6557: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6558: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6559: FND_MSG_PUB.ADD;
6560: RAISE FND_API.G_EXC_ERROR;

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

6553: EXCEPTION
6554: WHEN OTHERS THEN
6555: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6556: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6557: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6558: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6559: FND_MSG_PUB.ADD;
6560: RAISE FND_API.G_EXC_ERROR;
6561: END get_contact_point_rec;

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

6554: WHEN OTHERS THEN
6555: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6556: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6557: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6558: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6559: FND_MSG_PUB.ADD;
6560: RAISE FND_API.G_EXC_ERROR;
6561: END get_contact_point_rec;
6562:

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

6747: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6748: END IF;
6749: EXCEPTION
6750: WHEN OTHERS THEN
6751: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6752: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6753: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6754: FND_MSG_PUB.ADD;
6755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6748: END IF;
6749: EXCEPTION
6750: WHEN OTHERS THEN
6751: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6752: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6753: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6754: FND_MSG_PUB.ADD;
6755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6756: END;

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

6749: EXCEPTION
6750: WHEN OTHERS THEN
6751: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6752: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6753: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6754: FND_MSG_PUB.ADD;
6755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6756: END;
6757:

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

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

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

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

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

6988: EXCEPTION
6989: WHEN OTHERS THEN
6990: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6991: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6992: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6993: FND_MSG_PUB.ADD;
6994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6995: END;
6996:

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

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

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

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

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

7091: EXCEPTION
7092: WHEN OTHERS THEN
7093: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7094: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7095: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7096: FND_MSG_PUB.ADD;
7097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7098: END;
7099:

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

7220: END IF;
7221: END LOOP;
7222: EXCEPTION
7223: WHEN OTHERS THEN
7224: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7225: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7226: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7227: FND_MSG_PUB.ADD;
7228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7221: END LOOP;
7222: EXCEPTION
7223: WHEN OTHERS THEN
7224: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7225: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7226: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7227: FND_MSG_PUB.ADD;
7228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7229: END;

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

7222: EXCEPTION
7223: WHEN OTHERS THEN
7224: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7225: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7226: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7227: FND_MSG_PUB.ADD;
7228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7229: END;
7230:

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

7247: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
7248: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7249: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7250: ) THEN
7251: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7252: FND_MSG_PUB.ADD;
7253: RAISE FND_API.G_EXC_ERROR;
7254: END IF;
7255: END LOOP;

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

7315: EXCEPTION
7316: WHEN FND_API.G_EXC_ERROR THEN
7317: RAISE FND_API.G_EXC_ERROR;
7318: WHEN OTHERS THEN
7319: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7320: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7321: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7322: FND_MSG_PUB.ADD;
7323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7316: WHEN FND_API.G_EXC_ERROR THEN
7317: RAISE FND_API.G_EXC_ERROR;
7318: WHEN OTHERS THEN
7319: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7320: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7321: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7322: FND_MSG_PUB.ADD;
7323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7324: END check_prim_cond;

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

7317: RAISE FND_API.G_EXC_ERROR;
7318: WHEN OTHERS THEN
7319: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7320: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7321: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7322: FND_MSG_PUB.ADD;
7323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7324: END check_prim_cond;
7325:

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

7379: EXIT WHEN x_secondary;
7380: END LOOP;
7381: EXCEPTION
7382: WHEN OTHERS THEN
7383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7384: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7385: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7386: FND_MSG_PUB.ADD;
7387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7380: END LOOP;
7381: EXCEPTION
7382: WHEN OTHERS THEN
7383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7384: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7385: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7386: FND_MSG_PUB.ADD;
7387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7388: END check_party_site_cond;

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

7381: EXCEPTION
7382: WHEN OTHERS THEN
7383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7384: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7385: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7386: FND_MSG_PUB.ADD;
7387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7388: END check_party_site_cond;
7389:

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

7435: EXIT WHEN x_secondary;
7436: END LOOP;
7437: EXCEPTION
7438: WHEN OTHERS THEN
7439: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7440: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7441: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7442: FND_MSG_PUB.ADD;
7443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7436: END LOOP;
7437: EXCEPTION
7438: WHEN OTHERS THEN
7439: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7440: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7441: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7442: FND_MSG_PUB.ADD;
7443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7444: END check_contact_cond;

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

7437: EXCEPTION
7438: WHEN OTHERS THEN
7439: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7440: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7441: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7442: FND_MSG_PUB.ADD;
7443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7444: END check_contact_cond;
7445:

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

7458: x_secondary:= FALSE;
7459:
7460: FOR I IN 1..p_contact_point_list.COUNT LOOP
7461: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7462: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7463: FND_MSG_PUB.ADD;
7464: RAISE FND_API.G_EXC_ERROR;
7465: END IF;
7466: END LOOP;

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

7482: EXIT WHEN x_secondary;
7483: END LOOP;
7484: EXCEPTION
7485: WHEN OTHERS THEN
7486: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7487: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7488: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7489: FND_MSG_PUB.ADD;
7490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7483: END LOOP;
7484: EXCEPTION
7485: WHEN OTHERS THEN
7486: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7487: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7488: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7489: FND_MSG_PUB.ADD;
7490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7491: END check_contact_point_cond;

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

7484: EXCEPTION
7485: WHEN OTHERS THEN
7486: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7487: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7488: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7489: FND_MSG_PUB.ADD;
7490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7491: END check_contact_point_cond;
7492: