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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1090: ELSE
1091: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1092: END IF;
1093: IF lengthb(l_party_contains_str) > 4000 THEN
1094: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1095: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1096: FND_MSG_PUB.ADD;
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;

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

1091: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1092: END IF;
1093: IF lengthb(l_party_contains_str) > 4000 THEN
1094: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1095: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1096: FND_MSG_PUB.ADD;
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099: IF (p_match_str = ' AND ' OR p_party_max_score

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

1168: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1169: END LOOP;
1170: -- Add the search criteria to query string
1171: IF lengthb(l_contains_str) > 4000 THEN
1172: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1173: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1174: FND_MSG_PUB.ADD;
1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;

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

1169: END LOOP;
1170: -- Add the search criteria to query string
1171: IF lengthb(l_contains_str) > 4000 THEN
1172: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1173: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1174: FND_MSG_PUB.ADD;
1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;
1177: x_denorm_str := l_den_contains_str;

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

1249: END IF;
1250: END LOOP;
1251: -- Add the search criteria to query string
1252: IF lengthb(l_contains_str) > 4000 THEN
1253: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1254: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1255: FND_MSG_PUB.ADD;
1256: RAISE FND_API.G_EXC_ERROR;
1257: END IF;

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

1250: END LOOP;
1251: -- Add the search criteria to query string
1252: IF lengthb(l_contains_str) > 4000 THEN
1253: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1254: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1255: FND_MSG_PUB.ADD;
1256: RAISE FND_API.G_EXC_ERROR;
1257: END IF;
1258: x_denorm_str := l_den_contains_str;

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

1485: END IF;
1486: exception
1487: when others then
1488: if (instrb(SQLERRM,'DRG-51030')>0) then
1489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1490: FND_MSG_PUB.ADD;
1491: RAISE FND_API.G_EXC_ERROR;
1492: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1493: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1490: FND_MSG_PUB.ADD;
1491: RAISE FND_API.G_EXC_ERROR;
1492: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1493: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1494: FND_MSG_PUB.ADD;
1495: RAISE FND_API.G_EXC_ERROR;
1496: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1493: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1494: FND_MSG_PUB.ADD;
1495: RAISE FND_API.G_EXC_ERROR;
1496: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1498: FND_MSG_PUB.ADD;
1499: RAISE FND_API.G_EXC_ERROR;
1500: else
1501: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1498: FND_MSG_PUB.ADD;
1499: RAISE FND_API.G_EXC_ERROR;
1500: else
1501: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1503: FND_MSG_PUB.ADD;
1504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1505: end if;

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

1498: FND_MSG_PUB.ADD;
1499: RAISE FND_API.G_EXC_ERROR;
1500: else
1501: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1503: FND_MSG_PUB.ADD;
1504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1505: end if;
1506: END;

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

1730: output_long_strings('Restrict Sql = '||p_restrict_sql);
1731: exception
1732: when others then
1733: if (instrb(SQLERRM,'DRG-51030')>0) then
1734: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1735: FND_MSG_PUB.ADD;
1736: RAISE FND_API.G_EXC_ERROR;
1737: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1734: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1735: FND_MSG_PUB.ADD;
1736: RAISE FND_API.G_EXC_ERROR;
1737: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1739: FND_MSG_PUB.ADD;
1740: RAISE FND_API.G_EXC_ERROR;
1741: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1742: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1739: FND_MSG_PUB.ADD;
1740: RAISE FND_API.G_EXC_ERROR;
1741: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1742: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1743: FND_MSG_PUB.ADD;
1744: RAISE FND_API.G_EXC_ERROR;
1745: else
1746: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1742: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1743: FND_MSG_PUB.ADD;
1744: RAISE FND_API.G_EXC_ERROR;
1745: else
1746: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1747: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1748: FND_MSG_PUB.ADD;
1749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1750: end if;

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

1743: FND_MSG_PUB.ADD;
1744: RAISE FND_API.G_EXC_ERROR;
1745: else
1746: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1747: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1748: FND_MSG_PUB.ADD;
1749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1750: end if;
1751: END;

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

1877: output_long_strings('Restrict Sql = '||p_restrict_sql);
1878: exception
1879: when others then
1880: if (instrb(SQLERRM,'DRG-51030')>0) then
1881: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1882: FND_MSG_PUB.ADD;
1883: RAISE FND_API.G_EXC_ERROR;
1884: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1885: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1881: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1882: FND_MSG_PUB.ADD;
1883: RAISE FND_API.G_EXC_ERROR;
1884: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1885: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1886: FND_MSG_PUB.ADD;
1887: RAISE FND_API.G_EXC_ERROR;
1888: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1885: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1886: FND_MSG_PUB.ADD;
1887: RAISE FND_API.G_EXC_ERROR;
1888: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1890: FND_MSG_PUB.ADD;
1891: RAISE FND_API.G_EXC_ERROR;
1892: else
1893: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1890: FND_MSG_PUB.ADD;
1891: RAISE FND_API.G_EXC_ERROR;
1892: else
1893: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1894: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1895: FND_MSG_PUB.ADD;
1896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1897: end if;

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

1890: FND_MSG_PUB.ADD;
1891: RAISE FND_API.G_EXC_ERROR;
1892: else
1893: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1894: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1895: FND_MSG_PUB.ADD;
1896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1897: end if;
1898: END;

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

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

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

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

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

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

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

2162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2163: FND_MSG_PUB.ADD;
2164: RAISE FND_API.G_EXC_ERROR;
2165: else
2166: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2167: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2168: FND_MSG_PUB.ADD;
2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2170: end if;

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

2163: FND_MSG_PUB.ADD;
2164: RAISE FND_API.G_EXC_ERROR;
2165: else
2166: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2167: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2168: FND_MSG_PUB.ADD;
2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2170: end if;
2171: END;

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

2416: IF p_index>1 THEN
2417: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2418: 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);
2419: END IF;
2420: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2421: FND_MSG_PUB.ADD;
2422: RAISE FND_API.G_EXC_ERROR;
2423: ELSE
2424: push_eval;

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

2466: IF p_index>1 THEN
2467: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2468: 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);
2469: END IF;
2470: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2471: FND_MSG_PUB.ADD;
2472: RAISE FND_API.G_EXC_ERROR;
2473: ELSE
2474: push_eval;

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

2539: IF p_index>1 THEN
2540: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2541: 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);
2542: END IF;
2543: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2544: FND_MSG_PUB.ADD;
2545: RAISE FND_API.G_EXC_ERROR;
2546: ELSE
2547: push_eval;

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

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

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

2762: IF p_index>1 THEN
2763: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2764: 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);
2765: END IF;
2766: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2767: FND_MSG_PUB.ADD;
2768: RAISE FND_API.G_EXC_ERROR;
2769: ELSE
2770: push_eval;

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

2987: ELSE
2988: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2989: 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);
2990: END IF;
2991: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2992: FND_MSG_PUB.ADD;
2993: RAISE FND_API.G_EXC_ERROR;
2994: END IF;
2995: ELSE

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

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

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

3201: RAISE FND_API.G_EXC_ERROR;
3202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3204: WHEN OTHERS THEN
3205: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3206: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_parties');
3207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3208: FND_MSG_PUB.ADD;
3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3206: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_parties');

3202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3204: WHEN OTHERS THEN
3205: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3206: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_parties');
3207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3208: FND_MSG_PUB.ADD;
3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3210: END find_parties;

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

3203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3204: WHEN OTHERS THEN
3205: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3206: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_parties');
3207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3208: FND_MSG_PUB.ADD;
3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3210: END find_parties;
3211:

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

3396: IF p_index>1 THEN
3397: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3398: 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);
3399: END IF;
3400: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3401: FND_MSG_PUB.ADD;
3402: RAISE FND_API.G_EXC_ERROR;
3403: ELSE
3404: push_eval;

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

3446: IF p_index>1 THEN
3447: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3448: 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);
3449: END IF;
3450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3451: FND_MSG_PUB.ADD;
3452: RAISE FND_API.G_EXC_ERROR;
3453: ELSE
3454: push_eval;

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

3482: and d.search_context_id = p_search_ctx_id);
3483: exception
3484: when others then
3485: if (instrb(SQLERRM,'DRG-51030')>0) then
3486: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3487: FND_MSG_PUB.ADD;
3488: RAISE FND_API.G_EXC_ERROR;
3489: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3490: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3486: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3487: FND_MSG_PUB.ADD;
3488: RAISE FND_API.G_EXC_ERROR;
3489: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3490: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3491: FND_MSG_PUB.ADD;
3492: RAISE FND_API.G_EXC_ERROR;
3493: else
3494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3558: IF p_index>1 THEN
3559: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3560: 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);
3561: END IF;
3562: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3563: FND_MSG_PUB.ADD;
3564: RAISE FND_API.G_EXC_ERROR;
3565: ELSE
3566: push_eval;

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

3817: IF p_index>1 THEN
3818: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3819: 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);
3820: END IF;
3821: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3822: FND_MSG_PUB.ADD;
3823: RAISE FND_API.G_EXC_ERROR;
3824: ELSE
3825: push_eval;

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

3930: ELSE
3931: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3932: 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);
3933: END IF;
3934: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3935: FND_MSG_PUB.ADD;
3936: RAISE FND_API.G_EXC_ERROR;
3937: END IF;
3938: ELSE

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

3938: ELSE
3939: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3940: 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);
3941: END IF;
3942: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3943: FND_MSG_PUB.ADD;
3944: RAISE FND_API.G_EXC_ERROR;
3945: END IF;
3946: END IF;

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

4059: RAISE FND_API.G_EXC_ERROR;
4060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4062: WHEN OTHERS THEN
4063: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4064: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_persons');
4065: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4066: FND_MSG_PUB.ADD;
4067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4064: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_persons');

4060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4062: WHEN OTHERS THEN
4063: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4064: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_persons');
4065: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4066: FND_MSG_PUB.ADD;
4067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4068: END find_persons;

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

4061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4062: WHEN OTHERS THEN
4063: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4064: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_persons');
4065: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4066: FND_MSG_PUB.ADD;
4067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4068: END find_persons;
4069:

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

4127: RAISE FND_API.G_EXC_ERROR;
4128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4130: WHEN OTHERS THEN
4131: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4132: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_party_details');
4133: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4134: FND_MSG_PUB.ADD;
4135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4132: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_party_details');

4128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4130: WHEN OTHERS THEN
4131: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4132: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_party_details');
4133: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4134: FND_MSG_PUB.ADD;
4135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4136: END find_party_details;

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

4129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4130: WHEN OTHERS THEN
4131: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4132: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_party_details');
4133: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4134: FND_MSG_PUB.ADD;
4135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4136: END find_party_details;
4137:

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

4244: RAISE FND_API.G_EXC_ERROR;
4245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4247: WHEN OTHERS THEN
4248: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4249: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_parties');
4250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4251: FND_MSG_PUB.ADD;
4252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4249: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_parties');

4245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4247: WHEN OTHERS THEN
4248: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4249: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_parties');
4250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4251: FND_MSG_PUB.ADD;
4252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4253: END find_duplicate_parties;

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

4246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4247: WHEN OTHERS THEN
4248: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4249: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_parties');
4250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4251: FND_MSG_PUB.ADD;
4252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4253: END find_duplicate_parties;
4254:

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

4329: RAISE FND_API.G_EXC_ERROR;
4330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4332: WHEN OTHERS THEN
4333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4334: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_party_sites');
4335: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4336: FND_MSG_PUB.ADD;
4337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4334: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_party_sites');

4330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4332: WHEN OTHERS THEN
4333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4334: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_party_sites');
4335: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4336: FND_MSG_PUB.ADD;
4337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4338: END find_duplicate_party_sites;

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

4331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4332: WHEN OTHERS THEN
4333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4334: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_party_sites');
4335: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4336: FND_MSG_PUB.ADD;
4337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4338: END find_duplicate_party_sites;
4339:

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

4418: RAISE FND_API.G_EXC_ERROR;
4419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4421: WHEN OTHERS THEN
4422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4423: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contacts');
4424: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4425: FND_MSG_PUB.ADD;
4426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4423: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contacts');

4419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4421: WHEN OTHERS THEN
4422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4423: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contacts');
4424: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4425: FND_MSG_PUB.ADD;
4426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4427: END find_duplicate_contacts;

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

4420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4421: WHEN OTHERS THEN
4422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4423: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contacts');
4424: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4425: FND_MSG_PUB.ADD;
4426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4427: END find_duplicate_contacts;
4428:

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

4491: RAISE FND_API.G_EXC_ERROR;
4492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4494: WHEN OTHERS THEN
4495: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4496: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contact_points');
4497: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4498: FND_MSG_PUB.ADD;
4499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4496: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contact_points');

4492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4494: WHEN OTHERS THEN
4495: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4496: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contact_points');
4497: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4498: FND_MSG_PUB.ADD;
4499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4500: END find_duplicate_contact_points;

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

4493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4494: WHEN OTHERS THEN
4495: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4496: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contact_points');
4497: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4498: FND_MSG_PUB.ADD;
4499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4500: END find_duplicate_contact_points;
4501:

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

4806: RAISE FND_API.G_EXC_ERROR;
4807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4809: WHEN OTHERS THEN
4810: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4811: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.call_api_dynamic');
4812: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4813: FND_MSG_PUB.ADD;
4814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4811: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.call_api_dynamic');

4807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4809: WHEN OTHERS THEN
4810: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4811: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.call_api_dynamic');
4812: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4813: FND_MSG_PUB.ADD;
4814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4815: END call_api_dynamic;

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

4808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4809: WHEN OTHERS THEN
4810: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4811: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.call_api_dynamic');
4812: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4813: FND_MSG_PUB.ADD;
4814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4815: END call_api_dynamic;
4816:

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

5041: RAISE FND_API.G_EXC_ERROR;
5042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5044: WHEN OTHERS THEN
5045: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5046: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_party_sites');
5047: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5048: FND_MSG_PUB.ADD;
5049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5046: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_party_sites');

5042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5044: WHEN OTHERS THEN
5045: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5046: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_party_sites');
5047: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5048: FND_MSG_PUB.ADD;
5049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5050: END get_matching_party_sites;

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

5043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5044: WHEN OTHERS THEN
5045: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5046: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_party_sites');
5047: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5048: FND_MSG_PUB.ADD;
5049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5050: END get_matching_party_sites;
5051:

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

5270: RAISE FND_API.G_EXC_ERROR;
5271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5273: WHEN OTHERS THEN
5274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5275: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contacts');
5276: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5277: FND_MSG_PUB.ADD;
5278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5275: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contacts');

5271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5273: WHEN OTHERS THEN
5274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5275: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contacts');
5276: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5277: FND_MSG_PUB.ADD;
5278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5279: END get_matching_contacts;

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

5272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5273: WHEN OTHERS THEN
5274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5275: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contacts');
5276: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5277: FND_MSG_PUB.ADD;
5278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5279: END get_matching_contacts;
5280:

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

5412: RAISE FND_API.G_EXC_ERROR;
5413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5415: WHEN OTHERS THEN
5416: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5417: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contact_points');
5418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5419: FND_MSG_PUB.ADD;
5420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5417: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contact_points');

5413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5415: WHEN OTHERS THEN
5416: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5417: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contact_points');
5418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5419: FND_MSG_PUB.ADD;
5420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5421: END get_matching_contact_points;

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

5414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5415: WHEN OTHERS THEN
5416: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5417: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contact_points');
5418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5419: FND_MSG_PUB.ADD;
5420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5421: END get_matching_contact_points;
5422:

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

5625: RAISE FND_API.G_EXC_ERROR;
5626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5628: WHEN OTHERS THEN
5629: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5630: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_score_details');
5631: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5632: FND_MSG_PUB.ADD;
5633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5630: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_score_details');

5626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5628: WHEN OTHERS THEN
5629: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5630: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_score_details');
5631: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5632: FND_MSG_PUB.ADD;
5633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5634: END get_score_details;

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

5627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5628: WHEN OTHERS THEN
5629: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5630: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_score_details');
5631: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5632: FND_MSG_PUB.ADD;
5633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5634: END get_score_details;
5635:

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

5713: RAISE FND_API.G_EXC_ERROR;
5714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5716: WHEN OTHERS THEN
5717: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5718: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5719: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5720: FND_MSG_PUB.ADD;
5721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5716: WHEN OTHERS THEN
5717: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5718: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5719: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5720: FND_MSG_PUB.ADD;
5721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5722: END get_party_for_search;

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

5715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5716: WHEN OTHERS THEN
5717: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5718: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5719: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5720: FND_MSG_PUB.ADD;
5721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5722: END get_party_for_search;
5723:

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

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

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

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

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

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

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

5823: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
5824:
5825: EXCEPTION
5826: WHEN OTHERS THEN
5827: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5828: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5829: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5830: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5831: FND_MSG_PUB.ADD;

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

5824:
5825: EXCEPTION
5826: WHEN OTHERS THEN
5827: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5828: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5829: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5830: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5831: FND_MSG_PUB.ADD;
5832: RAISE FND_API.G_EXC_ERROR;

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

5825: EXCEPTION
5826: WHEN OTHERS THEN
5827: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5828: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5829: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5830: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5831: FND_MSG_PUB.ADD;
5832: RAISE FND_API.G_EXC_ERROR;
5833: END get_party_rec;

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

5826: WHEN OTHERS THEN
5827: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5828: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5829: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5830: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5831: FND_MSG_PUB.ADD;
5832: RAISE FND_API.G_EXC_ERROR;
5833: END get_party_rec;
5834:

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

5875: END LOOP;
5876:
5877: EXCEPTION
5878: WHEN OTHERS THEN
5879: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5880: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5881: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5882: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5883: FND_MSG_PUB.ADD;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

6164: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6165: END IF;
6166: EXCEPTION
6167: WHEN OTHERS THEN
6168: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6169: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6170: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6171: FND_MSG_PUB.ADD;
6172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6165: END IF;
6166: EXCEPTION
6167: WHEN OTHERS THEN
6168: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6169: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6170: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6171: FND_MSG_PUB.ADD;
6172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6173: END;

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

6166: EXCEPTION
6167: WHEN OTHERS THEN
6168: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6169: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6170: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6171: FND_MSG_PUB.ADD;
6172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6173: END;
6174:

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

6207: END IF;
6208: NULL;
6209: EXCEPTION
6210: WHEN OTHERS THEN
6211: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6212: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6213: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6214: FND_MSG_PUB.ADD;
6215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6208: NULL;
6209: EXCEPTION
6210: WHEN OTHERS THEN
6211: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6212: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6213: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6214: FND_MSG_PUB.ADD;
6215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6216: END;

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

6209: EXCEPTION
6210: WHEN OTHERS THEN
6211: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6212: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6213: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6214: FND_MSG_PUB.ADD;
6215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6216: END;
6217:

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

6264: END IF;
6265: END LOOP;
6266: EXCEPTION
6267: WHEN OTHERS THEN
6268: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6269: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6270: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6271: FND_MSG_PUB.ADD;
6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6265: END LOOP;
6266: EXCEPTION
6267: WHEN OTHERS THEN
6268: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6269: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6270: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6271: FND_MSG_PUB.ADD;
6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6273: END;

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

6266: EXCEPTION
6267: WHEN OTHERS THEN
6268: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6269: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6270: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6271: FND_MSG_PUB.ADD;
6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6273: END;
6274:

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

6395: END IF;
6396: END LOOP;
6397: EXCEPTION
6398: WHEN OTHERS THEN
6399: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6400: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6401: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6402: FND_MSG_PUB.ADD;
6403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6396: END LOOP;
6397: EXCEPTION
6398: WHEN OTHERS THEN
6399: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6400: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6401: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6402: FND_MSG_PUB.ADD;
6403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6404: END;

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

6397: EXCEPTION
6398: WHEN OTHERS THEN
6399: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6400: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6401: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6402: FND_MSG_PUB.ADD;
6403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6404: END;
6405:

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

6422: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6423: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6424: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6425: ) THEN
6426: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6427: FND_MSG_PUB.ADD;
6428: RAISE FND_API.G_EXC_ERROR;
6429: END IF;
6430: END LOOP;

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

6460: EXCEPTION
6461: WHEN FND_API.G_EXC_ERROR THEN
6462: RAISE FND_API.G_EXC_ERROR;
6463: WHEN OTHERS THEN
6464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6465: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6467: FND_MSG_PUB.ADD;
6468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6461: WHEN FND_API.G_EXC_ERROR THEN
6462: RAISE FND_API.G_EXC_ERROR;
6463: WHEN OTHERS THEN
6464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6465: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6467: FND_MSG_PUB.ADD;
6468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6469: END check_prim_cond;

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

6462: RAISE FND_API.G_EXC_ERROR;
6463: WHEN OTHERS THEN
6464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6465: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6467: FND_MSG_PUB.ADD;
6468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6469: END check_prim_cond;
6470:

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

6506: EXIT WHEN x_secondary;
6507: END LOOP;
6508: EXCEPTION
6509: WHEN OTHERS THEN
6510: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6511: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6513: FND_MSG_PUB.ADD;
6514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6507: END LOOP;
6508: EXCEPTION
6509: WHEN OTHERS THEN
6510: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6511: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6513: FND_MSG_PUB.ADD;
6514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6515: END check_party_site_cond;

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

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

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

6562: EXIT WHEN x_secondary;
6563: END LOOP;
6564: EXCEPTION
6565: WHEN OTHERS THEN
6566: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6567: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6568: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6569: FND_MSG_PUB.ADD;
6570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6563: END LOOP;
6564: EXCEPTION
6565: WHEN OTHERS THEN
6566: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6567: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6568: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6569: FND_MSG_PUB.ADD;
6570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6571: END check_contact_cond;

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

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

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

6585: x_secondary:= FALSE;
6586:
6587: FOR I IN 1..p_contact_point_list.COUNT LOOP
6588: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6589: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6590: FND_MSG_PUB.ADD;
6591: RAISE FND_API.G_EXC_ERROR;
6592: END IF;
6593: END LOOP;

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

6609: EXIT WHEN x_secondary;
6610: END LOOP;
6611: EXCEPTION
6612: WHEN OTHERS THEN
6613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6614: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6615: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6616: FND_MSG_PUB.ADD;
6617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6610: END LOOP;
6611: EXCEPTION
6612: WHEN OTHERS THEN
6613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6614: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6615: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6616: FND_MSG_PUB.ADD;
6617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6618: END check_contact_point_cond;

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

6611: EXCEPTION
6612: WHEN OTHERS THEN
6613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6614: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6615: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6616: FND_MSG_PUB.ADD;
6617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6618: END check_contact_point_cond;
6619: