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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4084: WHEN OTHERS THEN
4085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4086: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_persons');
4087: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4088: FND_MSG_PUB.ADD;
4089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4090: END find_persons;
4091:

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

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

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

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

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

4151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4152: WHEN OTHERS THEN
4153: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4154: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_party_details');
4155: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4156: FND_MSG_PUB.ADD;
4157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4158: END find_party_details;
4159:

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

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

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

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

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

4268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4269: WHEN OTHERS THEN
4270: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4271: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_parties');
4272: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4273: FND_MSG_PUB.ADD;
4274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4275: END find_duplicate_parties;
4276:

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

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

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

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

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

4353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4354: WHEN OTHERS THEN
4355: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4356: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_party_sites');
4357: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4358: FND_MSG_PUB.ADD;
4359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4360: END find_duplicate_party_sites;
4361:

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

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

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

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

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

4442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4443: WHEN OTHERS THEN
4444: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4445: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_contacts');
4446: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4447: FND_MSG_PUB.ADD;
4448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4449: END find_duplicate_contacts;
4450:

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

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

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

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

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

4515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4516: WHEN OTHERS THEN
4517: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4518: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.find_duplicate_contact_points');
4519: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4520: FND_MSG_PUB.ADD;
4521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4522: END find_duplicate_contact_points;
4523:

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

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

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

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

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

4820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4821: WHEN OTHERS THEN
4822: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4823: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.call_api_dynamic');
4824: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4825: FND_MSG_PUB.ADD;
4826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4827: END call_api_dynamic;
4828:

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

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

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

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

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

5056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5057: WHEN OTHERS THEN
5058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5059: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_party_sites');
5060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5061: FND_MSG_PUB.ADD;
5062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5063: END get_matching_party_sites;
5064:

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

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

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

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

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

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

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

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

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

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

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

5424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5425: WHEN OTHERS THEN
5426: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5427: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_matching_contact_points');
5428: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5429: FND_MSG_PUB.ADD;
5430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5431: END get_matching_contact_points;
5432:

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

5637: RAISE FND_API.G_EXC_ERROR;
5638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5640: WHEN OTHERS THEN
5641: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5642: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_score_details');
5643: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5644: FND_MSG_PUB.ADD;
5645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5640: WHEN OTHERS THEN
5641: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5642: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_score_details');
5643: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5644: FND_MSG_PUB.ADD;
5645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5646: END get_score_details;

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

5639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5640: WHEN OTHERS THEN
5641: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5642: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_40.get_score_details');
5643: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5644: FND_MSG_PUB.ADD;
5645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5646: END get_score_details;
5647:

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

5760: RAISE FND_API.G_EXC_ERROR;
5761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5763: WHEN OTHERS THEN
5764: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5765: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5766: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5767: FND_MSG_PUB.ADD;
5768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5763: WHEN OTHERS THEN
5764: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5765: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5766: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5767: FND_MSG_PUB.ADD;
5768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5769: END get_party_for_search;

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

5762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5763: WHEN OTHERS THEN
5764: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5765: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5766: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5767: FND_MSG_PUB.ADD;
5768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5769: END get_party_for_search;
5770:

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

5812: RAISE FND_API.G_EXC_ERROR;
5813: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5815: WHEN OTHERS THEN
5816: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5817: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5818: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5819: FND_MSG_PUB.ADD;
5820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5813: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5815: WHEN OTHERS THEN
5816: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5817: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5818: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5819: FND_MSG_PUB.ADD;
5820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5821: END get_search_criteria;

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

5814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5815: WHEN OTHERS THEN
5816: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5817: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5818: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5819: FND_MSG_PUB.ADD;
5820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5821: END get_search_criteria;
5822:

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

5876: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
5877:
5878: EXCEPTION
5879: WHEN OTHERS THEN
5880: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5881: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5882: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5883: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5884: FND_MSG_PUB.ADD;

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

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

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

5878: EXCEPTION
5879: WHEN OTHERS THEN
5880: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5881: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5882: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5883: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5884: FND_MSG_PUB.ADD;
5885: RAISE FND_API.G_EXC_ERROR;
5886: END get_party_rec;

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

5879: WHEN OTHERS THEN
5880: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5881: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5882: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5883: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5884: FND_MSG_PUB.ADD;
5885: RAISE FND_API.G_EXC_ERROR;
5886: END get_party_rec;
5887:

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

5932: END LOOP;
5933:
5934: EXCEPTION
5935: WHEN OTHERS THEN
5936: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5937: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5938: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5940: FND_MSG_PUB.ADD;

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

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

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

5934: EXCEPTION
5935: WHEN OTHERS THEN
5936: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5937: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5938: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5940: FND_MSG_PUB.ADD;
5941: RAISE FND_API.G_EXC_ERROR;
5942: END get_party_site_rec;

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

5935: WHEN OTHERS THEN
5936: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5937: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5938: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5940: FND_MSG_PUB.ADD;
5941: RAISE FND_API.G_EXC_ERROR;
5942: END get_party_site_rec;
5943:

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

5990: END LOOP;
5991:
5992: EXCEPTION
5993: WHEN OTHERS THEN
5994: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5995: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5996: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5997: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5998: FND_MSG_PUB.ADD;

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

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

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

5992: EXCEPTION
5993: WHEN OTHERS THEN
5994: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5995: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5996: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5997: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5998: FND_MSG_PUB.ADD;
5999: RAISE FND_API.G_EXC_ERROR;
6000: END get_contact_rec;

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

5993: WHEN OTHERS THEN
5994: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5995: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5996: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5997: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5998: FND_MSG_PUB.ADD;
5999: RAISE FND_API.G_EXC_ERROR;
6000: END get_contact_rec;
6001:

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

6044: END LOOP;
6045:
6046: EXCEPTION
6047: WHEN OTHERS THEN
6048: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6049: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6050: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6051: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6052: FND_MSG_PUB.ADD;

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

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

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

6046: EXCEPTION
6047: WHEN OTHERS THEN
6048: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6049: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6050: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6051: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6052: FND_MSG_PUB.ADD;
6053: RAISE FND_API.G_EXC_ERROR;
6054: END get_contact_point_rec;

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

6047: WHEN OTHERS THEN
6048: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6049: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6050: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6051: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6052: FND_MSG_PUB.ADD;
6053: RAISE FND_API.G_EXC_ERROR;
6054: END get_contact_point_rec;
6055:

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

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

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

6187: END IF;
6188: EXCEPTION
6189: WHEN OTHERS THEN
6190: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6191: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6192: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6193: FND_MSG_PUB.ADD;
6194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6195: END;

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

6188: EXCEPTION
6189: WHEN OTHERS THEN
6190: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6191: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6192: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6193: FND_MSG_PUB.ADD;
6194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6195: END;
6196:

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

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

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

6305: END LOOP;
6306: EXCEPTION
6307: WHEN OTHERS THEN
6308: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6309: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6310: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6311: FND_MSG_PUB.ADD;
6312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6313: END;

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

6306: EXCEPTION
6307: WHEN OTHERS THEN
6308: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6309: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6310: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6311: FND_MSG_PUB.ADD;
6312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6313: END;
6314:

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

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

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

6385: END LOOP;
6386: EXCEPTION
6387: WHEN OTHERS THEN
6388: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6389: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6390: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6391: FND_MSG_PUB.ADD;
6392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6393: END;

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

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

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

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

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

6477: END LOOP;
6478: EXCEPTION
6479: WHEN OTHERS THEN
6480: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6481: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6482: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6483: FND_MSG_PUB.ADD;
6484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6485: END;

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

6478: EXCEPTION
6479: WHEN OTHERS THEN
6480: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6481: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6482: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6483: FND_MSG_PUB.ADD;
6484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6485: END;
6486:

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

6502: FOR I IN 1..p_contact_point_list.COUNT LOOP
6503: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6504: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6505: ) THEN
6506: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6507: FND_MSG_PUB.ADD;
6508: RAISE FND_API.G_EXC_ERROR;
6509: END IF;
6510: END LOOP;

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

6542: EXCEPTION
6543: WHEN FND_API.G_EXC_ERROR THEN
6544: RAISE FND_API.G_EXC_ERROR;
6545: WHEN OTHERS THEN
6546: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6547: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6549: FND_MSG_PUB.ADD;
6550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6543: WHEN FND_API.G_EXC_ERROR THEN
6544: RAISE FND_API.G_EXC_ERROR;
6545: WHEN OTHERS THEN
6546: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6547: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6549: FND_MSG_PUB.ADD;
6550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6551: END check_prim_cond;

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

6544: RAISE FND_API.G_EXC_ERROR;
6545: WHEN OTHERS THEN
6546: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6547: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6549: FND_MSG_PUB.ADD;
6550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6551: END check_prim_cond;
6552:

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

6596: EXIT WHEN x_secondary;
6597: END LOOP;
6598: EXCEPTION
6599: WHEN OTHERS THEN
6600: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6601: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6603: FND_MSG_PUB.ADD;
6604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6597: END LOOP;
6598: EXCEPTION
6599: WHEN OTHERS THEN
6600: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6601: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6603: FND_MSG_PUB.ADD;
6604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6605: END check_party_site_cond;

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

6598: EXCEPTION
6599: WHEN OTHERS THEN
6600: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6601: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6603: FND_MSG_PUB.ADD;
6604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6605: END check_party_site_cond;
6606:

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

6650: EXIT WHEN x_secondary;
6651: END LOOP;
6652: EXCEPTION
6653: WHEN OTHERS THEN
6654: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6655: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6656: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6657: FND_MSG_PUB.ADD;
6658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6651: END LOOP;
6652: EXCEPTION
6653: WHEN OTHERS THEN
6654: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6655: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6656: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6657: FND_MSG_PUB.ADD;
6658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6659: END check_contact_cond;

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

6652: EXCEPTION
6653: WHEN OTHERS THEN
6654: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6655: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6656: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6657: FND_MSG_PUB.ADD;
6658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6659: END check_contact_cond;
6660:

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

6673: x_secondary:= FALSE;
6674:
6675: FOR I IN 1..p_contact_point_list.COUNT LOOP
6676: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6677: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6678: FND_MSG_PUB.ADD;
6679: RAISE FND_API.G_EXC_ERROR;
6680: END IF;
6681: END LOOP;

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

6695: EXIT WHEN x_secondary;
6696: END LOOP;
6697: EXCEPTION
6698: WHEN OTHERS THEN
6699: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6700: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6701: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6702: FND_MSG_PUB.ADD;
6703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6696: END LOOP;
6697: EXCEPTION
6698: WHEN OTHERS THEN
6699: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6700: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6701: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6702: FND_MSG_PUB.ADD;
6703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6704: END check_contact_point_cond;

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

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