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

694: BEGIN
695: NULL ;
696: EXCEPTION
697: WHEN OTHERS THEN
698: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
699: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
700: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
701: FND_MSG_PUB.ADD;
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

695: NULL ;
696: EXCEPTION
697: WHEN OTHERS THEN
698: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
699: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
700: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
701: FND_MSG_PUB.ADD;
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703: END;

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

696: EXCEPTION
697: WHEN OTHERS THEN
698: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
699: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
700: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
701: FND_MSG_PUB.ADD;
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703: END;
704:

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

714: BEGIN
715: NULL ;
716: EXCEPTION
717: WHEN OTHERS THEN
718: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
719: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
720: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
721: FND_MSG_PUB.ADD;
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

715: NULL ;
716: EXCEPTION
717: WHEN OTHERS THEN
718: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
719: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
720: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
721: FND_MSG_PUB.ADD;
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: END;

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

716: EXCEPTION
717: WHEN OTHERS THEN
718: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
719: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
720: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
721: FND_MSG_PUB.ADD;
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: END;
724:

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

734: BEGIN
735: NULL ;
736: EXCEPTION
737: WHEN OTHERS THEN
738: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
739: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
741: FND_MSG_PUB.ADD;
742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

735: NULL ;
736: EXCEPTION
737: WHEN OTHERS THEN
738: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
739: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
741: FND_MSG_PUB.ADD;
742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
743: END;

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

736: EXCEPTION
737: WHEN OTHERS THEN
738: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
739: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
741: FND_MSG_PUB.ADD;
742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
743: END;
744:

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

754: BEGIN
755: NULL ;
756: EXCEPTION
757: WHEN OTHERS THEN
758: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
759: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
761: FND_MSG_PUB.ADD;
762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

755: NULL ;
756: EXCEPTION
757: WHEN OTHERS THEN
758: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
759: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
761: FND_MSG_PUB.ADD;
762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
763: END;

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

756: EXCEPTION
757: WHEN OTHERS THEN
758: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
759: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
761: FND_MSG_PUB.ADD;
762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
763: END;
764:

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

823: IF NOT check_prim_cond (p_party_search_rec,
824: p_party_site_list,
825: p_contact_list,
826: p_contact_point_list) THEN
827: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
828: FND_MSG_PUB.ADD;
829: RAISE FND_API.G_EXC_ERROR;
830: END IF;
831: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1080: ELSE
1081: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1082: END IF;
1083: IF lengthb(l_party_contains_str) > 4000 THEN
1084: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1085: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1086: FND_MSG_PUB.ADD;
1087: RAISE FND_API.G_EXC_ERROR;
1088: END IF;

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

1081: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1082: END IF;
1083: IF lengthb(l_party_contains_str) > 4000 THEN
1084: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1085: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1086: FND_MSG_PUB.ADD;
1087: RAISE FND_API.G_EXC_ERROR;
1088: END IF;
1089: IF (p_match_str = ' AND ' OR p_party_max_score

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

1149: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1150: END LOOP;
1151: -- Add the search criteria to query string
1152: IF lengthb(l_contains_str) > 4000 THEN
1153: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1154: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1155: FND_MSG_PUB.ADD;
1156: RAISE FND_API.G_EXC_ERROR;
1157: END IF;

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

1150: END LOOP;
1151: -- Add the search criteria to query string
1152: IF lengthb(l_contains_str) > 4000 THEN
1153: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1154: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1155: FND_MSG_PUB.ADD;
1156: RAISE FND_API.G_EXC_ERROR;
1157: END IF;
1158: x_denorm_str := l_den_contains_str;

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

1193: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1194: END LOOP;
1195: -- Add the search criteria to query string
1196: IF lengthb(l_contains_str) > 4000 THEN
1197: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1198: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1199: FND_MSG_PUB.ADD;
1200: RAISE FND_API.G_EXC_ERROR;
1201: END IF;

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

1194: END LOOP;
1195: -- Add the search criteria to query string
1196: IF lengthb(l_contains_str) > 4000 THEN
1197: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1198: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1199: FND_MSG_PUB.ADD;
1200: RAISE FND_API.G_EXC_ERROR;
1201: END IF;
1202: x_denorm_str := l_den_contains_str;

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

1267: END IF;
1268: END LOOP;
1269: -- Add the search criteria to query string
1270: IF lengthb(l_contains_str) > 4000 THEN
1271: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1272: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1273: FND_MSG_PUB.ADD;
1274: RAISE FND_API.G_EXC_ERROR;
1275: END IF;

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

1268: END LOOP;
1269: -- Add the search criteria to query string
1270: IF lengthb(l_contains_str) > 4000 THEN
1271: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1272: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1273: FND_MSG_PUB.ADD;
1274: RAISE FND_API.G_EXC_ERROR;
1275: END IF;
1276: x_denorm_str := l_den_contains_str;

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

1507: END IF;
1508: exception
1509: when others then
1510: if (instrb(SQLERRM,'DRG-51030')>0) then
1511: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1512: FND_MSG_PUB.ADD;
1513: RAISE FND_API.G_EXC_ERROR;
1514: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1515: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1511: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1512: FND_MSG_PUB.ADD;
1513: RAISE FND_API.G_EXC_ERROR;
1514: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1515: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1516: FND_MSG_PUB.ADD;
1517: RAISE FND_API.G_EXC_ERROR;
1518: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1515: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1516: FND_MSG_PUB.ADD;
1517: RAISE FND_API.G_EXC_ERROR;
1518: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1520: FND_MSG_PUB.ADD;
1521: RAISE FND_API.G_EXC_ERROR;
1522: else
1523: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1520: FND_MSG_PUB.ADD;
1521: RAISE FND_API.G_EXC_ERROR;
1522: else
1523: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1524: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1525: FND_MSG_PUB.ADD;
1526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1527: end if;

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

1520: FND_MSG_PUB.ADD;
1521: RAISE FND_API.G_EXC_ERROR;
1522: else
1523: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1524: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1525: FND_MSG_PUB.ADD;
1526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1527: end if;
1528: END;

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

1752: output_long_strings('Restrict Sql = '||p_restrict_sql);
1753: exception
1754: when others then
1755: if (instrb(SQLERRM,'DRG-51030')>0) then
1756: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1757: FND_MSG_PUB.ADD;
1758: RAISE FND_API.G_EXC_ERROR;
1759: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1756: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1757: FND_MSG_PUB.ADD;
1758: RAISE FND_API.G_EXC_ERROR;
1759: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1761: FND_MSG_PUB.ADD;
1762: RAISE FND_API.G_EXC_ERROR;
1763: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1764: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1761: FND_MSG_PUB.ADD;
1762: RAISE FND_API.G_EXC_ERROR;
1763: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1764: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1765: FND_MSG_PUB.ADD;
1766: RAISE FND_API.G_EXC_ERROR;
1767: else
1768: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1764: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1765: FND_MSG_PUB.ADD;
1766: RAISE FND_API.G_EXC_ERROR;
1767: else
1768: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1769: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1770: FND_MSG_PUB.ADD;
1771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1772: end if;

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

1765: FND_MSG_PUB.ADD;
1766: RAISE FND_API.G_EXC_ERROR;
1767: else
1768: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1769: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1770: FND_MSG_PUB.ADD;
1771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1772: end if;
1773: END;

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

1899: output_long_strings('Restrict Sql = '||p_restrict_sql);
1900: exception
1901: when others then
1902: if (instrb(SQLERRM,'DRG-51030')>0) then
1903: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1904: FND_MSG_PUB.ADD;
1905: RAISE FND_API.G_EXC_ERROR;
1906: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1907: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1903: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1904: FND_MSG_PUB.ADD;
1905: RAISE FND_API.G_EXC_ERROR;
1906: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1907: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1908: FND_MSG_PUB.ADD;
1909: RAISE FND_API.G_EXC_ERROR;
1910: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1907: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1908: FND_MSG_PUB.ADD;
1909: RAISE FND_API.G_EXC_ERROR;
1910: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1912: FND_MSG_PUB.ADD;
1913: RAISE FND_API.G_EXC_ERROR;
1914: else
1915: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1912: FND_MSG_PUB.ADD;
1913: RAISE FND_API.G_EXC_ERROR;
1914: else
1915: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1916: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1917: FND_MSG_PUB.ADD;
1918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1919: end if;

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

1912: FND_MSG_PUB.ADD;
1913: RAISE FND_API.G_EXC_ERROR;
1914: else
1915: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1916: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1917: FND_MSG_PUB.ADD;
1918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1919: end if;
1920: END;

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

2172: output_long_strings('Restrict Sql = '||p_restrict_sql);
2173: exception
2174: when others then
2175: if (instrb(SQLERRM,'DRG-51030')>0) then
2176: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2177: FND_MSG_PUB.ADD;
2178: RAISE FND_API.G_EXC_ERROR;
2179: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2180: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2176: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2177: FND_MSG_PUB.ADD;
2178: RAISE FND_API.G_EXC_ERROR;
2179: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2180: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2181: FND_MSG_PUB.ADD;
2182: RAISE FND_API.G_EXC_ERROR;
2183: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2180: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2181: FND_MSG_PUB.ADD;
2182: RAISE FND_API.G_EXC_ERROR;
2183: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2185: FND_MSG_PUB.ADD;
2186: RAISE FND_API.G_EXC_ERROR;
2187: else
2188: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2185: FND_MSG_PUB.ADD;
2186: RAISE FND_API.G_EXC_ERROR;
2187: else
2188: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2189: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2190: FND_MSG_PUB.ADD;
2191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2192: end if;

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

2185: FND_MSG_PUB.ADD;
2186: RAISE FND_API.G_EXC_ERROR;
2187: else
2188: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2189: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2190: FND_MSG_PUB.ADD;
2191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2192: end if;
2193: END;

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

2438: IF p_index>1 THEN
2439: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2440: 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);
2441: END IF;
2442: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2443: FND_MSG_PUB.ADD;
2444: RAISE FND_API.G_EXC_ERROR;
2445: ELSE
2446: push_eval;

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

2486: IF p_index>1 THEN
2487: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2488: 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);
2489: END IF;
2490: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2491: FND_MSG_PUB.ADD;
2492: RAISE FND_API.G_EXC_ERROR;
2493: ELSE
2494: push_eval;

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

2559: IF p_index>1 THEN
2560: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2561: 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);
2562: END IF;
2563: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2564: FND_MSG_PUB.ADD;
2565: RAISE FND_API.G_EXC_ERROR;
2566: ELSE
2567: push_eval;

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

2671: IF p_index>1 THEN
2672: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2673: 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);
2674: END IF;
2675: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2676: FND_MSG_PUB.ADD;
2677: RAISE FND_API.G_EXC_ERROR;
2678: ELSE
2679: push_eval;

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

2782: IF p_index>1 THEN
2783: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2784: 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);
2785: END IF;
2786: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2787: FND_MSG_PUB.ADD;
2788: RAISE FND_API.G_EXC_ERROR;
2789: ELSE
2790: push_eval;

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

3007: ELSE
3008: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3009: 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);
3010: END IF;
3011: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3012: FND_MSG_PUB.ADD;
3013: RAISE FND_API.G_EXC_ERROR;
3014: END IF;
3015: ELSE

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

3015: ELSE
3016: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3017: 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);
3018: END IF;
3019: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3020: FND_MSG_PUB.ADD;
3021: RAISE FND_API.G_EXC_ERROR;
3022: END IF;
3023: END IF;

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

3221: RAISE FND_API.G_EXC_ERROR;
3222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3224: WHEN OTHERS THEN
3225: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3226: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_parties');
3227: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3228: FND_MSG_PUB.ADD;
3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3226: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_parties');

3222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3224: WHEN OTHERS THEN
3225: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3226: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_parties');
3227: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3228: FND_MSG_PUB.ADD;
3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3230: END find_parties;

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

3223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3224: WHEN OTHERS THEN
3225: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3226: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_parties');
3227: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3228: FND_MSG_PUB.ADD;
3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3230: END find_parties;
3231:

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

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

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

3464: IF p_index>1 THEN
3465: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3466: 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);
3467: END IF;
3468: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3469: FND_MSG_PUB.ADD;
3470: RAISE FND_API.G_EXC_ERROR;
3471: ELSE
3472: push_eval;

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

3500: and d.search_context_id = p_search_ctx_id);
3501: exception
3502: when others then
3503: if (instrb(SQLERRM,'DRG-51030')>0) then
3504: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3505: FND_MSG_PUB.ADD;
3506: RAISE FND_API.G_EXC_ERROR;
3507: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3508: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3504: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3505: FND_MSG_PUB.ADD;
3506: RAISE FND_API.G_EXC_ERROR;
3507: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3508: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3509: FND_MSG_PUB.ADD;
3510: RAISE FND_API.G_EXC_ERROR;
3511: else
3512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3576: IF p_index>1 THEN
3577: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3578: 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);
3579: END IF;
3580: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3581: FND_MSG_PUB.ADD;
3582: RAISE FND_API.G_EXC_ERROR;
3583: ELSE
3584: push_eval;

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

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

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

3948: ELSE
3949: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3950: 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);
3951: END IF;
3952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3953: FND_MSG_PUB.ADD;
3954: RAISE FND_API.G_EXC_ERROR;
3955: END IF;
3956: ELSE

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

3956: ELSE
3957: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3958: 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);
3959: END IF;
3960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3961: FND_MSG_PUB.ADD;
3962: RAISE FND_API.G_EXC_ERROR;
3963: END IF;
3964: END IF;

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

4077: RAISE FND_API.G_EXC_ERROR;
4078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4080: WHEN OTHERS THEN
4081: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4082: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_persons');
4083: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4084: FND_MSG_PUB.ADD;
4085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4082: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_persons');

4078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4080: WHEN OTHERS THEN
4081: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4082: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_persons');
4083: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4084: FND_MSG_PUB.ADD;
4085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4086: END find_persons;

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

4079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4080: WHEN OTHERS THEN
4081: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4082: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_persons');
4083: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4084: FND_MSG_PUB.ADD;
4085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4086: END find_persons;
4087:

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

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

Line 4150: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_party_details');

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

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

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

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

4262: RAISE FND_API.G_EXC_ERROR;
4263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4265: WHEN OTHERS THEN
4266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_parties');
4268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4269: FND_MSG_PUB.ADD;
4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_parties');

4263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4265: WHEN OTHERS THEN
4266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_parties');
4268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4269: FND_MSG_PUB.ADD;
4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4271: END find_duplicate_parties;

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

4264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4265: WHEN OTHERS THEN
4266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_parties');
4268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4269: FND_MSG_PUB.ADD;
4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4271: END find_duplicate_parties;
4272:

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

4347: RAISE FND_API.G_EXC_ERROR;
4348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4350: WHEN OTHERS THEN
4351: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4352: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_party_sites');
4353: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4354: FND_MSG_PUB.ADD;
4355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4352: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_party_sites');

4348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4350: WHEN OTHERS THEN
4351: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4352: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_party_sites');
4353: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4354: FND_MSG_PUB.ADD;
4355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4356: END find_duplicate_party_sites;

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

4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4350: WHEN OTHERS THEN
4351: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4352: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_party_sites');
4353: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4354: FND_MSG_PUB.ADD;
4355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4356: END find_duplicate_party_sites;
4357:

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

4436: RAISE FND_API.G_EXC_ERROR;
4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4439: WHEN OTHERS THEN
4440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4441: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_contacts');
4442: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4443: FND_MSG_PUB.ADD;
4444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4441: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_contacts');

4437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4439: WHEN OTHERS THEN
4440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4441: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_contacts');
4442: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4443: FND_MSG_PUB.ADD;
4444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4445: END find_duplicate_contacts;

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

4438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4439: WHEN OTHERS THEN
4440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4441: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_contacts');
4442: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4443: FND_MSG_PUB.ADD;
4444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4445: END find_duplicate_contacts;
4446:

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

4509: RAISE FND_API.G_EXC_ERROR;
4510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: WHEN OTHERS THEN
4513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4514: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_contact_points');
4515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4516: FND_MSG_PUB.ADD;
4517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4514: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_contact_points');

4510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: WHEN OTHERS THEN
4513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4514: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_contact_points');
4515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4516: FND_MSG_PUB.ADD;
4517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4518: END find_duplicate_contact_points;

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

4511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4512: WHEN OTHERS THEN
4513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4514: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_contact_points');
4515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4516: FND_MSG_PUB.ADD;
4517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4518: END find_duplicate_contact_points;
4519:

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

4814: RAISE FND_API.G_EXC_ERROR;
4815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4817: WHEN OTHERS THEN
4818: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4819: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.call_api_dynamic');
4820: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4821: FND_MSG_PUB.ADD;
4822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4819: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.call_api_dynamic');

4815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4817: WHEN OTHERS THEN
4818: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4819: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.call_api_dynamic');
4820: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4821: FND_MSG_PUB.ADD;
4822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4823: END call_api_dynamic;

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

4816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4817: WHEN OTHERS THEN
4818: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4819: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.call_api_dynamic');
4820: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4821: FND_MSG_PUB.ADD;
4822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4823: END call_api_dynamic;
4824:

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

5050: RAISE FND_API.G_EXC_ERROR;
5051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5053: WHEN OTHERS THEN
5054: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5055: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_party_sites');
5056: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5057: FND_MSG_PUB.ADD;
5058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5055: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_party_sites');

5051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5053: WHEN OTHERS THEN
5054: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5055: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_party_sites');
5056: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5057: FND_MSG_PUB.ADD;
5058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5059: END get_matching_party_sites;

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

5052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5053: WHEN OTHERS THEN
5054: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5055: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_party_sites');
5056: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5057: FND_MSG_PUB.ADD;
5058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5059: END get_matching_party_sites;
5060:

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

5278: RAISE FND_API.G_EXC_ERROR;
5279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5281: WHEN OTHERS THEN
5282: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5283: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_contacts');
5284: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5285: FND_MSG_PUB.ADD;
5286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5283: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_contacts');

5279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5281: WHEN OTHERS THEN
5282: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5283: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_contacts');
5284: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5285: FND_MSG_PUB.ADD;
5286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5287: END get_matching_contacts;

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

5280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5281: WHEN OTHERS THEN
5282: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5283: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_contacts');
5284: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5285: FND_MSG_PUB.ADD;
5286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5287: END get_matching_contacts;
5288:

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

5418: RAISE FND_API.G_EXC_ERROR;
5419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5421: WHEN OTHERS THEN
5422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5423: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_contact_points');
5424: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5425: FND_MSG_PUB.ADD;
5426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5423: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_contact_points');

5419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5421: WHEN OTHERS THEN
5422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5423: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_contact_points');
5424: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5425: FND_MSG_PUB.ADD;
5426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5427: END get_matching_contact_points;

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

5420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5421: WHEN OTHERS THEN
5422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5423: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_contact_points');
5424: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5425: FND_MSG_PUB.ADD;
5426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5427: END get_matching_contact_points;
5428:

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

5632: RAISE FND_API.G_EXC_ERROR;
5633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5635: WHEN OTHERS THEN
5636: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5637: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_score_details');
5638: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5639: FND_MSG_PUB.ADD;
5640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5637: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_score_details');

5633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5635: WHEN OTHERS THEN
5636: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5637: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_score_details');
5638: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5639: FND_MSG_PUB.ADD;
5640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5641: END get_score_details;

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

5634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5635: WHEN OTHERS THEN
5636: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5637: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_score_details');
5638: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5639: FND_MSG_PUB.ADD;
5640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5641: END get_score_details;
5642:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

6181: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6182: END IF;
6183: EXCEPTION
6184: WHEN OTHERS THEN
6185: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6186: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6188: FND_MSG_PUB.ADD;
6189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6182: END IF;
6183: EXCEPTION
6184: WHEN OTHERS THEN
6185: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6186: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6188: FND_MSG_PUB.ADD;
6189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6190: END;

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

6183: EXCEPTION
6184: WHEN OTHERS THEN
6185: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6186: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6188: FND_MSG_PUB.ADD;
6189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6190: END;
6191:

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

6299: END IF;
6300: END LOOP;
6301: EXCEPTION
6302: WHEN OTHERS THEN
6303: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6304: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6305: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6306: FND_MSG_PUB.ADD;
6307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6300: END LOOP;
6301: EXCEPTION
6302: WHEN OTHERS THEN
6303: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6304: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6305: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6306: FND_MSG_PUB.ADD;
6307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6308: END;

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

6301: EXCEPTION
6302: WHEN OTHERS THEN
6303: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6304: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6305: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6306: FND_MSG_PUB.ADD;
6307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6308: END;
6309:

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

6379: END IF;
6380: END LOOP;
6381: EXCEPTION
6382: WHEN OTHERS THEN
6383: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6384: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6385: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6386: FND_MSG_PUB.ADD;
6387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6380: END LOOP;
6381: EXCEPTION
6382: WHEN OTHERS THEN
6383: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6384: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6385: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6386: FND_MSG_PUB.ADD;
6387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6388: END;

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

6381: EXCEPTION
6382: WHEN OTHERS THEN
6383: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6384: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6385: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6386: FND_MSG_PUB.ADD;
6387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6388: END;
6389:

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

6471: END IF;
6472: END LOOP;
6473: EXCEPTION
6474: WHEN OTHERS THEN
6475: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6476: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6477: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6478: FND_MSG_PUB.ADD;
6479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6472: END LOOP;
6473: EXCEPTION
6474: WHEN OTHERS THEN
6475: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6476: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6477: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6478: FND_MSG_PUB.ADD;
6479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6480: END;

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

6473: EXCEPTION
6474: WHEN OTHERS THEN
6475: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6476: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6477: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6478: FND_MSG_PUB.ADD;
6479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6480: END;
6481:

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

6497: FOR I IN 1..p_contact_point_list.COUNT LOOP
6498: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6499: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6500: ) THEN
6501: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6502: FND_MSG_PUB.ADD;
6503: RAISE FND_API.G_EXC_ERROR;
6504: END IF;
6505: END LOOP;

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

6537: EXCEPTION
6538: WHEN FND_API.G_EXC_ERROR THEN
6539: RAISE FND_API.G_EXC_ERROR;
6540: WHEN OTHERS THEN
6541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6542: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6544: FND_MSG_PUB.ADD;
6545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6538: WHEN FND_API.G_EXC_ERROR THEN
6539: RAISE FND_API.G_EXC_ERROR;
6540: WHEN OTHERS THEN
6541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6542: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6544: FND_MSG_PUB.ADD;
6545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6546: END check_prim_cond;

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

6539: RAISE FND_API.G_EXC_ERROR;
6540: WHEN OTHERS THEN
6541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6542: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6544: FND_MSG_PUB.ADD;
6545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6546: END check_prim_cond;
6547:

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

6591: EXIT WHEN x_secondary;
6592: END LOOP;
6593: EXCEPTION
6594: WHEN OTHERS THEN
6595: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6596: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6597: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6598: FND_MSG_PUB.ADD;
6599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6592: END LOOP;
6593: EXCEPTION
6594: WHEN OTHERS THEN
6595: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6596: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6597: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6598: FND_MSG_PUB.ADD;
6599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6600: END check_party_site_cond;

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

6593: EXCEPTION
6594: WHEN OTHERS THEN
6595: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6596: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6597: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6598: FND_MSG_PUB.ADD;
6599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6600: END check_party_site_cond;
6601:

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

6645: EXIT WHEN x_secondary;
6646: END LOOP;
6647: EXCEPTION
6648: WHEN OTHERS THEN
6649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6650: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6652: FND_MSG_PUB.ADD;
6653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

6668: x_secondary:= FALSE;
6669:
6670: FOR I IN 1..p_contact_point_list.COUNT LOOP
6671: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6672: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6673: FND_MSG_PUB.ADD;
6674: RAISE FND_API.G_EXC_ERROR;
6675: END IF;
6676: END LOOP;

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

6690: EXIT WHEN x_secondary;
6691: END LOOP;
6692: EXCEPTION
6693: WHEN OTHERS THEN
6694: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6695: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6696: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6697: FND_MSG_PUB.ADD;
6698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6691: END LOOP;
6692: EXCEPTION
6693: WHEN OTHERS THEN
6694: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6695: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6696: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6697: FND_MSG_PUB.ADD;
6698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6699: END check_contact_point_cond;

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

6692: EXCEPTION
6693: WHEN OTHERS THEN
6694: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6695: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6696: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6697: FND_MSG_PUB.ADD;
6698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6699: END check_contact_point_cond;
6700: