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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2461: IF p_index>1 THEN
2462: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2463: 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);
2464: END IF;
2465: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2466: FND_MSG_PUB.ADD;
2467: RAISE FND_API.G_EXC_ERROR;
2468: ELSE
2469: push_eval;

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

2534: IF p_index>1 THEN
2535: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2536: 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);
2537: END IF;
2538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2539: FND_MSG_PUB.ADD;
2540: RAISE FND_API.G_EXC_ERROR;
2541: ELSE
2542: push_eval;

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

2646: IF p_index>1 THEN
2647: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2648: 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);
2649: END IF;
2650: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2651: FND_MSG_PUB.ADD;
2652: RAISE FND_API.G_EXC_ERROR;
2653: ELSE
2654: push_eval;

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

2757: IF p_index>1 THEN
2758: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2759: 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);
2760: END IF;
2761: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2762: FND_MSG_PUB.ADD;
2763: RAISE FND_API.G_EXC_ERROR;
2764: ELSE
2765: push_eval;

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

2982: ELSE
2983: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2984: 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);
2985: END IF;
2986: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2987: FND_MSG_PUB.ADD;
2988: RAISE FND_API.G_EXC_ERROR;
2989: END IF;
2990: ELSE

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

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

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

3196: RAISE FND_API.G_EXC_ERROR;
3197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3199: WHEN OTHERS THEN
3200: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3201: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_parties');
3202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3203: FND_MSG_PUB.ADD;
3204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3199: WHEN OTHERS THEN
3200: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3201: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_parties');
3202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3203: FND_MSG_PUB.ADD;
3204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3205: END find_parties;

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

3198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3199: WHEN OTHERS THEN
3200: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3201: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_parties');
3202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3203: FND_MSG_PUB.ADD;
3204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3205: END find_parties;
3206:

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

3390: IF p_index>1 THEN
3391: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3392: 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);
3393: END IF;
3394: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3395: FND_MSG_PUB.ADD;
3396: RAISE FND_API.G_EXC_ERROR;
3397: ELSE
3398: push_eval;

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

3438: IF p_index>1 THEN
3439: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3440: 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);
3441: END IF;
3442: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3443: FND_MSG_PUB.ADD;
3444: RAISE FND_API.G_EXC_ERROR;
3445: ELSE
3446: push_eval;

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

3474: and d.search_context_id = p_search_ctx_id);
3475: exception
3476: when others then
3477: if (instrb(SQLERRM,'DRG-51030')>0) then
3478: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3479: FND_MSG_PUB.ADD;
3480: RAISE FND_API.G_EXC_ERROR;
3481: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3482: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3478: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3479: FND_MSG_PUB.ADD;
3480: RAISE FND_API.G_EXC_ERROR;
3481: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3482: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3483: FND_MSG_PUB.ADD;
3484: RAISE FND_API.G_EXC_ERROR;
3485: else
3486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3550: IF p_index>1 THEN
3551: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3552: 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);
3553: END IF;
3554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3555: FND_MSG_PUB.ADD;
3556: RAISE FND_API.G_EXC_ERROR;
3557: ELSE
3558: push_eval;

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

3809: IF p_index>1 THEN
3810: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3811: 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);
3812: END IF;
3813: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3814: FND_MSG_PUB.ADD;
3815: RAISE FND_API.G_EXC_ERROR;
3816: ELSE
3817: push_eval;

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

3922: ELSE
3923: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3924: 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);
3925: END IF;
3926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3927: FND_MSG_PUB.ADD;
3928: RAISE FND_API.G_EXC_ERROR;
3929: END IF;
3930: ELSE

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

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

4051: RAISE FND_API.G_EXC_ERROR;
4052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4054: WHEN OTHERS THEN
4055: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4056: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_persons');
4057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4058: FND_MSG_PUB.ADD;
4059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4054: WHEN OTHERS THEN
4055: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4056: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_persons');
4057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4058: FND_MSG_PUB.ADD;
4059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4060: END find_persons;

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

4053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4054: WHEN OTHERS THEN
4055: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4056: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_persons');
4057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4058: FND_MSG_PUB.ADD;
4059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4060: END find_persons;
4061:

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

4119: RAISE FND_API.G_EXC_ERROR;
4120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4122: WHEN OTHERS THEN
4123: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4124: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_party_details');
4125: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4126: FND_MSG_PUB.ADD;
4127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4122: WHEN OTHERS THEN
4123: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4124: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_party_details');
4125: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4126: FND_MSG_PUB.ADD;
4127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4128: END find_party_details;

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

4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4122: WHEN OTHERS THEN
4123: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4124: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_party_details');
4125: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4126: FND_MSG_PUB.ADD;
4127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4128: END find_party_details;
4129:

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

4236: RAISE FND_API.G_EXC_ERROR;
4237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4239: WHEN OTHERS THEN
4240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4241: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_parties');
4242: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4243: FND_MSG_PUB.ADD;
4244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4239: WHEN OTHERS THEN
4240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4241: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_parties');
4242: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4243: FND_MSG_PUB.ADD;
4244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4245: END find_duplicate_parties;

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

4238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4239: WHEN OTHERS THEN
4240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4241: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_parties');
4242: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4243: FND_MSG_PUB.ADD;
4244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4245: END find_duplicate_parties;
4246:

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

4321: RAISE FND_API.G_EXC_ERROR;
4322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4324: WHEN OTHERS THEN
4325: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4326: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_party_sites');
4327: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4328: FND_MSG_PUB.ADD;
4329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4324: WHEN OTHERS THEN
4325: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4326: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_party_sites');
4327: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4328: FND_MSG_PUB.ADD;
4329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4330: END find_duplicate_party_sites;

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

4323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4324: WHEN OTHERS THEN
4325: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4326: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_party_sites');
4327: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4328: FND_MSG_PUB.ADD;
4329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4330: END find_duplicate_party_sites;
4331:

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

4410: RAISE FND_API.G_EXC_ERROR;
4411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4413: WHEN OTHERS THEN
4414: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4415: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contacts');
4416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4417: FND_MSG_PUB.ADD;
4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4413: WHEN OTHERS THEN
4414: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4415: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contacts');
4416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4417: FND_MSG_PUB.ADD;
4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4419: END find_duplicate_contacts;

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

4412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4413: WHEN OTHERS THEN
4414: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4415: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contacts');
4416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4417: FND_MSG_PUB.ADD;
4418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4419: END find_duplicate_contacts;
4420:

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

4483: RAISE FND_API.G_EXC_ERROR;
4484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4486: WHEN OTHERS THEN
4487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4488: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contact_points');
4489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4490: FND_MSG_PUB.ADD;
4491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4486: WHEN OTHERS THEN
4487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4488: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contact_points');
4489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4490: FND_MSG_PUB.ADD;
4491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4492: END find_duplicate_contact_points;

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

4485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4486: WHEN OTHERS THEN
4487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4488: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contact_points');
4489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4490: FND_MSG_PUB.ADD;
4491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4492: END find_duplicate_contact_points;
4493:

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

4798: RAISE FND_API.G_EXC_ERROR;
4799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4801: WHEN OTHERS THEN
4802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.call_api_dynamic');
4804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4805: FND_MSG_PUB.ADD;
4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4801: WHEN OTHERS THEN
4802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.call_api_dynamic');
4804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4805: FND_MSG_PUB.ADD;
4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4807: END call_api_dynamic;

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

4800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4801: WHEN OTHERS THEN
4802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.call_api_dynamic');
4804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4805: FND_MSG_PUB.ADD;
4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4807: END call_api_dynamic;
4808:

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

5033: RAISE FND_API.G_EXC_ERROR;
5034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5036: WHEN OTHERS THEN
5037: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5038: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_party_sites');
5039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5040: FND_MSG_PUB.ADD;
5041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5036: WHEN OTHERS THEN
5037: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5038: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_party_sites');
5039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5040: FND_MSG_PUB.ADD;
5041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5042: END get_matching_party_sites;

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

5035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5036: WHEN OTHERS THEN
5037: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5038: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_party_sites');
5039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5040: FND_MSG_PUB.ADD;
5041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5042: END get_matching_party_sites;
5043:

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

5262: RAISE FND_API.G_EXC_ERROR;
5263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5265: WHEN OTHERS THEN
5266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contacts');
5268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5269: FND_MSG_PUB.ADD;
5270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5265: WHEN OTHERS THEN
5266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contacts');
5268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5269: FND_MSG_PUB.ADD;
5270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5271: END get_matching_contacts;

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

5264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5265: WHEN OTHERS THEN
5266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contacts');
5268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5269: FND_MSG_PUB.ADD;
5270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5271: END get_matching_contacts;
5272:

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

5404: RAISE FND_API.G_EXC_ERROR;
5405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5407: WHEN OTHERS THEN
5408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5409: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contact_points');
5410: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5411: FND_MSG_PUB.ADD;
5412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5407: WHEN OTHERS THEN
5408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5409: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contact_points');
5410: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5411: FND_MSG_PUB.ADD;
5412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5413: END get_matching_contact_points;

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

5406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5407: WHEN OTHERS THEN
5408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5409: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contact_points');
5410: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5411: FND_MSG_PUB.ADD;
5412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5413: END get_matching_contact_points;
5414:

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

5614: RAISE FND_API.G_EXC_ERROR;
5615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5617: WHEN OTHERS THEN
5618: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5619: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_score_details');
5620: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5621: FND_MSG_PUB.ADD;
5622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5617: WHEN OTHERS THEN
5618: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5619: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_score_details');
5620: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5621: FND_MSG_PUB.ADD;
5622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5623: END get_score_details;

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

5616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5617: WHEN OTHERS THEN
5618: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5619: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_score_details');
5620: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5621: FND_MSG_PUB.ADD;
5622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5623: END get_score_details;
5624:

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

5702: RAISE FND_API.G_EXC_ERROR;
5703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5705: WHEN OTHERS THEN
5706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5707: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5708: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5709: FND_MSG_PUB.ADD;
5710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5705: WHEN OTHERS THEN
5706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5707: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5708: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5709: FND_MSG_PUB.ADD;
5710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5711: END get_party_for_search;

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

5704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5705: WHEN OTHERS THEN
5706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5707: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5708: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5709: FND_MSG_PUB.ADD;
5710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5711: END get_party_for_search;
5712:

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

5748: RAISE FND_API.G_EXC_ERROR;
5749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5751: WHEN OTHERS THEN
5752: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5753: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5754: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5755: FND_MSG_PUB.ADD;
5756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5751: WHEN OTHERS THEN
5752: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5753: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5754: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5755: FND_MSG_PUB.ADD;
5756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5757: END get_search_criteria;

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

5750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5751: WHEN OTHERS THEN
5752: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5753: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5754: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5755: FND_MSG_PUB.ADD;
5756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5757: END get_search_criteria;
5758:

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

5812: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
5813:
5814: EXCEPTION
5815: WHEN OTHERS THEN
5816: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5817: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5818: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5819: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5820: FND_MSG_PUB.ADD;

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

5813:
5814: EXCEPTION
5815: WHEN OTHERS THEN
5816: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5817: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5818: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5819: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5820: FND_MSG_PUB.ADD;
5821: RAISE FND_API.G_EXC_ERROR;

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

5814: EXCEPTION
5815: WHEN OTHERS THEN
5816: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5817: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5818: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5819: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5820: FND_MSG_PUB.ADD;
5821: RAISE FND_API.G_EXC_ERROR;
5822: END get_party_rec;

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

5815: WHEN OTHERS THEN
5816: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5817: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5818: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5819: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5820: FND_MSG_PUB.ADD;
5821: RAISE FND_API.G_EXC_ERROR;
5822: END get_party_rec;
5823:

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

5864: END LOOP;
5865:
5866: EXCEPTION
5867: WHEN OTHERS THEN
5868: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5869: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5870: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5871: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5872: FND_MSG_PUB.ADD;

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

5865:
5866: EXCEPTION
5867: WHEN OTHERS THEN
5868: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5869: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5870: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5871: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5872: FND_MSG_PUB.ADD;
5873: RAISE FND_API.G_EXC_ERROR;

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

5866: EXCEPTION
5867: WHEN OTHERS THEN
5868: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5869: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5870: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5871: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5872: FND_MSG_PUB.ADD;
5873: RAISE FND_API.G_EXC_ERROR;
5874: END get_party_site_rec;

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

5867: WHEN OTHERS THEN
5868: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5869: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5870: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5871: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5872: FND_MSG_PUB.ADD;
5873: RAISE FND_API.G_EXC_ERROR;
5874: END get_party_site_rec;
5875:

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

5922: END LOOP;
5923:
5924: EXCEPTION
5925: WHEN OTHERS THEN
5926: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5927: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5928: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5929: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5930: FND_MSG_PUB.ADD;

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

5923:
5924: EXCEPTION
5925: WHEN OTHERS THEN
5926: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5927: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5928: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5929: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5930: FND_MSG_PUB.ADD;
5931: RAISE FND_API.G_EXC_ERROR;

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

5924: EXCEPTION
5925: WHEN OTHERS THEN
5926: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5927: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5928: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5929: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5930: FND_MSG_PUB.ADD;
5931: RAISE FND_API.G_EXC_ERROR;
5932: END get_contact_rec;

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

5925: WHEN OTHERS THEN
5926: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5927: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5928: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5929: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5930: FND_MSG_PUB.ADD;
5931: RAISE FND_API.G_EXC_ERROR;
5932: END get_contact_rec;
5933:

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

5978: END LOOP;
5979:
5980: EXCEPTION
5981: WHEN OTHERS THEN
5982: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5983: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5984: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5986: FND_MSG_PUB.ADD;

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

5979:
5980: EXCEPTION
5981: WHEN OTHERS THEN
5982: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5983: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5984: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5986: FND_MSG_PUB.ADD;
5987: RAISE FND_API.G_EXC_ERROR;

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

5980: EXCEPTION
5981: WHEN OTHERS THEN
5982: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5983: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5984: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5986: FND_MSG_PUB.ADD;
5987: RAISE FND_API.G_EXC_ERROR;
5988: END get_contact_point_rec;

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

5981: WHEN OTHERS THEN
5982: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5983: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5984: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5986: FND_MSG_PUB.ADD;
5987: RAISE FND_API.G_EXC_ERROR;
5988: END get_contact_point_rec;
5989:

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

6153: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6154: END IF;
6155: EXCEPTION
6156: WHEN OTHERS THEN
6157: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6158: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6159: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6160: FND_MSG_PUB.ADD;
6161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6154: END IF;
6155: EXCEPTION
6156: WHEN OTHERS THEN
6157: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6158: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6159: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6160: FND_MSG_PUB.ADD;
6161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6162: END;

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

6155: EXCEPTION
6156: WHEN OTHERS THEN
6157: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6158: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6159: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6160: FND_MSG_PUB.ADD;
6161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6162: END;
6163:

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

6196: END IF;
6197: NULL;
6198: EXCEPTION
6199: WHEN OTHERS THEN
6200: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6201: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6203: FND_MSG_PUB.ADD;
6204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6197: NULL;
6198: EXCEPTION
6199: WHEN OTHERS THEN
6200: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6201: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6203: FND_MSG_PUB.ADD;
6204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6205: END;

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

6198: EXCEPTION
6199: WHEN OTHERS THEN
6200: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6201: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6203: FND_MSG_PUB.ADD;
6204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6205: END;
6206:

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

6253: END IF;
6254: END LOOP;
6255: EXCEPTION
6256: WHEN OTHERS THEN
6257: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6258: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6260: FND_MSG_PUB.ADD;
6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6254: END LOOP;
6255: EXCEPTION
6256: WHEN OTHERS THEN
6257: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6258: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6260: FND_MSG_PUB.ADD;
6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6262: END;

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

6255: EXCEPTION
6256: WHEN OTHERS THEN
6257: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6258: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6260: FND_MSG_PUB.ADD;
6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6262: END;
6263:

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_POINT_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_POINT_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_POINT_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_POINT_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 6415: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');

6411: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6412: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6413: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6414: ) THEN
6415: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6416: FND_MSG_PUB.ADD;
6417: RAISE FND_API.G_EXC_ERROR;
6418: END IF;
6419: END LOOP;

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

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

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

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

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

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

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

6495: EXIT WHEN x_secondary;
6496: END LOOP;
6497: EXCEPTION
6498: WHEN OTHERS THEN
6499: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6500: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6501: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6502: FND_MSG_PUB.ADD;
6503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6496: END LOOP;
6497: EXCEPTION
6498: WHEN OTHERS THEN
6499: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6500: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6501: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6502: FND_MSG_PUB.ADD;
6503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6504: END check_party_site_cond;

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

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

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

6551: EXIT WHEN x_secondary;
6552: END LOOP;
6553: EXCEPTION
6554: WHEN OTHERS THEN
6555: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6556: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6557: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6558: FND_MSG_PUB.ADD;
6559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6552: END LOOP;
6553: EXCEPTION
6554: WHEN OTHERS THEN
6555: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6556: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6557: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6558: FND_MSG_PUB.ADD;
6559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6560: END check_contact_cond;

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

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

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

6574: x_secondary:= FALSE;
6575:
6576: FOR I IN 1..p_contact_point_list.COUNT LOOP
6577: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6578: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6579: FND_MSG_PUB.ADD;
6580: RAISE FND_API.G_EXC_ERROR;
6581: END IF;
6582: END LOOP;

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

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

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

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

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

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