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

841: BEGIN
842: NULL ;
843: EXCEPTION
844: WHEN OTHERS THEN
845: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
846: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
847: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
848: FND_MSG_PUB.ADD;
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

842: NULL ;
843: EXCEPTION
844: WHEN OTHERS THEN
845: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
846: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
847: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
848: FND_MSG_PUB.ADD;
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: END;

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

843: EXCEPTION
844: WHEN OTHERS THEN
845: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
846: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
847: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
848: FND_MSG_PUB.ADD;
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: END;
851:

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

866: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,p_search_list(1).COUNTRY);
867: END IF ;
868: EXCEPTION
869: WHEN OTHERS THEN
870: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
871: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
872: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
873: FND_MSG_PUB.ADD;
874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

867: END IF ;
868: EXCEPTION
869: WHEN OTHERS THEN
870: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
871: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
872: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
873: FND_MSG_PUB.ADD;
874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
875: END;

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

868: EXCEPTION
869: WHEN OTHERS THEN
870: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
871: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
872: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
873: FND_MSG_PUB.ADD;
874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
875: END;
876:

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

886: BEGIN
887: NULL ;
888: EXCEPTION
889: WHEN OTHERS THEN
890: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
891: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
892: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
893: FND_MSG_PUB.ADD;
894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

887: NULL ;
888: EXCEPTION
889: WHEN OTHERS THEN
890: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
891: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
892: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
893: FND_MSG_PUB.ADD;
894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
895: END;

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

888: EXCEPTION
889: WHEN OTHERS THEN
890: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
891: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
892: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
893: FND_MSG_PUB.ADD;
894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
895: END;
896:

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

906: BEGIN
907: NULL ;
908: EXCEPTION
909: WHEN OTHERS THEN
910: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
911: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
913: FND_MSG_PUB.ADD;
914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

907: NULL ;
908: EXCEPTION
909: WHEN OTHERS THEN
910: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
911: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
913: FND_MSG_PUB.ADD;
914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
915: END;

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

908: EXCEPTION
909: WHEN OTHERS THEN
910: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
911: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
913: FND_MSG_PUB.ADD;
914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
915: END;
916:

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

975: IF NOT check_prim_cond (p_party_search_rec,
976: p_party_site_list,
977: p_contact_list,
978: p_contact_point_list) THEN
979: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
980: FND_MSG_PUB.ADD;
981: RAISE FND_API.G_EXC_ERROR;
982: END IF;
983: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1209: ELSE
1210: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1211: END IF;
1212: IF lengthb(l_party_contains_str) > 4000 THEN
1213: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1214: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1215: FND_MSG_PUB.ADD;
1216: RAISE FND_API.G_EXC_ERROR;
1217: END IF;

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

1210: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1211: END IF;
1212: IF lengthb(l_party_contains_str) > 4000 THEN
1213: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1214: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1215: FND_MSG_PUB.ADD;
1216: RAISE FND_API.G_EXC_ERROR;
1217: END IF;
1218: IF (p_match_str = ' AND ' OR p_party_max_score

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

1328: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1329: END LOOP;
1330: -- Add the search criteria to query string
1331: IF lengthb(l_contains_str) > 4000 THEN
1332: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1333: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1334: FND_MSG_PUB.ADD;
1335: RAISE FND_API.G_EXC_ERROR;
1336: END IF;

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

1329: END LOOP;
1330: -- Add the search criteria to query string
1331: IF lengthb(l_contains_str) > 4000 THEN
1332: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1333: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1334: FND_MSG_PUB.ADD;
1335: RAISE FND_API.G_EXC_ERROR;
1336: END IF;
1337: x_denorm_str := l_den_contains_str;

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

1636: END IF;
1637: exception
1638: when others then
1639: if (instrb(SQLERRM,'DRG-51030')>0) then
1640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1641: FND_MSG_PUB.ADD;
1642: RAISE FND_API.G_EXC_ERROR;
1643: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1644: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1641: FND_MSG_PUB.ADD;
1642: RAISE FND_API.G_EXC_ERROR;
1643: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1644: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1645: FND_MSG_PUB.ADD;
1646: RAISE FND_API.G_EXC_ERROR;
1647: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1648: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1644: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1645: FND_MSG_PUB.ADD;
1646: RAISE FND_API.G_EXC_ERROR;
1647: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1648: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1649: FND_MSG_PUB.ADD;
1650: RAISE FND_API.G_EXC_ERROR;
1651: else
1652: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1648: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1649: FND_MSG_PUB.ADD;
1650: RAISE FND_API.G_EXC_ERROR;
1651: else
1652: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1654: FND_MSG_PUB.ADD;
1655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1656: end if;

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

1649: FND_MSG_PUB.ADD;
1650: RAISE FND_API.G_EXC_ERROR;
1651: else
1652: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1654: FND_MSG_PUB.ADD;
1655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1656: end if;
1657: END;

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

1881: output_long_strings('Restrict Sql = '||p_restrict_sql);
1882: exception
1883: when others then
1884: if (instrb(SQLERRM,'DRG-51030')>0) then
1885: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1886: FND_MSG_PUB.ADD;
1887: RAISE FND_API.G_EXC_ERROR;
1888: elsif (instrb(SQLERRM,'DRG-50943')>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_WILDCARD_ERR');
1886: FND_MSG_PUB.ADD;
1887: RAISE FND_API.G_EXC_ERROR;
1888: elsif (instrb(SQLERRM,'DRG-50943')>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: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1893: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

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

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

1893: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1894: FND_MSG_PUB.ADD;
1895: RAISE FND_API.G_EXC_ERROR;
1896: else
1897: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1898: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1899: FND_MSG_PUB.ADD;
1900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1901: end if;

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

1894: FND_MSG_PUB.ADD;
1895: RAISE FND_API.G_EXC_ERROR;
1896: else
1897: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1898: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1899: FND_MSG_PUB.ADD;
1900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1901: end if;
1902: END;

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

2028: output_long_strings('Restrict Sql = '||p_restrict_sql);
2029: exception
2030: when others then
2031: if (instrb(SQLERRM,'DRG-51030')>0) then
2032: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2033: FND_MSG_PUB.ADD;
2034: RAISE FND_API.G_EXC_ERROR;
2035: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2036: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2032: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2033: FND_MSG_PUB.ADD;
2034: RAISE FND_API.G_EXC_ERROR;
2035: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2036: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2037: FND_MSG_PUB.ADD;
2038: RAISE FND_API.G_EXC_ERROR;
2039: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2040: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2036: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2037: FND_MSG_PUB.ADD;
2038: RAISE FND_API.G_EXC_ERROR;
2039: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2040: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: else
2044: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2040: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: else
2044: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2045: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2046: FND_MSG_PUB.ADD;
2047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2048: end if;

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

2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: else
2044: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2045: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2046: FND_MSG_PUB.ADD;
2047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2048: end if;
2049: END;

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

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

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

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

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

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

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

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

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

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

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

2573: IF p_index>1 THEN
2574: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2575: 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);
2576: END IF;
2577: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2578: FND_MSG_PUB.ADD;
2579: RAISE FND_API.G_EXC_ERROR;
2580: ELSE
2581: push_eval;

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

2621: IF p_index>1 THEN
2622: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2623: 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);
2624: END IF;
2625: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2626: FND_MSG_PUB.ADD;
2627: RAISE FND_API.G_EXC_ERROR;
2628: ELSE
2629: push_eval;

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

2694: IF p_index>1 THEN
2695: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2696: 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);
2697: END IF;
2698: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2699: FND_MSG_PUB.ADD;
2700: RAISE FND_API.G_EXC_ERROR;
2701: ELSE
2702: push_eval;

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

2806: IF p_index>1 THEN
2807: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2808: 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);
2809: END IF;
2810: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2811: FND_MSG_PUB.ADD;
2812: RAISE FND_API.G_EXC_ERROR;
2813: ELSE
2814: push_eval;

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

2917: IF p_index>1 THEN
2918: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2919: 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);
2920: END IF;
2921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2922: FND_MSG_PUB.ADD;
2923: RAISE FND_API.G_EXC_ERROR;
2924: ELSE
2925: push_eval;

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

3142: ELSE
3143: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3144: 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);
3145: END IF;
3146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3147: FND_MSG_PUB.ADD;
3148: RAISE FND_API.G_EXC_ERROR;
3149: END IF;
3150: ELSE

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

3150: ELSE
3151: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3152: 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);
3153: END IF;
3154: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3155: FND_MSG_PUB.ADD;
3156: RAISE FND_API.G_EXC_ERROR;
3157: END IF;
3158: END IF;

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

3356: RAISE FND_API.G_EXC_ERROR;
3357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3359: WHEN OTHERS THEN
3360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3361: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_parties');
3362: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3363: FND_MSG_PUB.ADD;
3364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3361: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_parties');

3357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3359: WHEN OTHERS THEN
3360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3361: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_parties');
3362: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3363: FND_MSG_PUB.ADD;
3364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3365: END find_parties;

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

3358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3359: WHEN OTHERS THEN
3360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3361: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_parties');
3362: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3363: FND_MSG_PUB.ADD;
3364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3365: END find_parties;
3366:

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

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

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

3605: IF p_index>1 THEN
3606: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3607: 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);
3608: END IF;
3609: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3610: FND_MSG_PUB.ADD;
3611: RAISE FND_API.G_EXC_ERROR;
3612: ELSE
3613: push_eval;

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

3641: and d.search_context_id = p_search_ctx_id);
3642: exception
3643: when others then
3644: if (instrb(SQLERRM,'DRG-51030')>0) then
3645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3646: FND_MSG_PUB.ADD;
3647: RAISE FND_API.G_EXC_ERROR;
3648: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3646: FND_MSG_PUB.ADD;
3647: RAISE FND_API.G_EXC_ERROR;
3648: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3650: FND_MSG_PUB.ADD;
3651: RAISE FND_API.G_EXC_ERROR;
3652: else
3653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3717: IF p_index>1 THEN
3718: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3719: 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);
3720: END IF;
3721: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3722: FND_MSG_PUB.ADD;
3723: RAISE FND_API.G_EXC_ERROR;
3724: ELSE
3725: push_eval;

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

3976: IF p_index>1 THEN
3977: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3978: 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);
3979: END IF;
3980: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3981: FND_MSG_PUB.ADD;
3982: RAISE FND_API.G_EXC_ERROR;
3983: ELSE
3984: push_eval;

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

4089: ELSE
4090: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4091: 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);
4092: END IF;
4093: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4094: FND_MSG_PUB.ADD;
4095: RAISE FND_API.G_EXC_ERROR;
4096: END IF;
4097: ELSE

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

4097: ELSE
4098: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4099: 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);
4100: END IF;
4101: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4102: FND_MSG_PUB.ADD;
4103: RAISE FND_API.G_EXC_ERROR;
4104: END IF;
4105: END IF;

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

4218: RAISE FND_API.G_EXC_ERROR;
4219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4221: WHEN OTHERS THEN
4222: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4223: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_persons');
4224: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4225: FND_MSG_PUB.ADD;
4226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4223: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_persons');

4219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4221: WHEN OTHERS THEN
4222: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4223: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_persons');
4224: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4225: FND_MSG_PUB.ADD;
4226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4227: END find_persons;

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

4220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4221: WHEN OTHERS THEN
4222: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4223: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_persons');
4224: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4225: FND_MSG_PUB.ADD;
4226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4227: END find_persons;
4228:

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

4286: RAISE FND_API.G_EXC_ERROR;
4287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4289: WHEN OTHERS THEN
4290: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4291: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_party_details');
4292: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4293: FND_MSG_PUB.ADD;
4294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4291: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_party_details');

4287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4289: WHEN OTHERS THEN
4290: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4291: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_party_details');
4292: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4293: FND_MSG_PUB.ADD;
4294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4295: END find_party_details;

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

4288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4289: WHEN OTHERS THEN
4290: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4291: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_party_details');
4292: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4293: FND_MSG_PUB.ADD;
4294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4295: END find_party_details;
4296:

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

4403: RAISE FND_API.G_EXC_ERROR;
4404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4406: WHEN OTHERS THEN
4407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4408: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_parties');
4409: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4410: FND_MSG_PUB.ADD;
4411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4408: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_parties');

4404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4406: WHEN OTHERS THEN
4407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4408: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_parties');
4409: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4410: FND_MSG_PUB.ADD;
4411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4412: END find_duplicate_parties;

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

4405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4406: WHEN OTHERS THEN
4407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4408: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_parties');
4409: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4410: FND_MSG_PUB.ADD;
4411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4412: END find_duplicate_parties;
4413:

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

4488: RAISE FND_API.G_EXC_ERROR;
4489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4491: WHEN OTHERS THEN
4492: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4493: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_party_sites');
4494: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4495: FND_MSG_PUB.ADD;
4496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4493: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_party_sites');

4489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4491: WHEN OTHERS THEN
4492: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4493: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_party_sites');
4494: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4495: FND_MSG_PUB.ADD;
4496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4497: END find_duplicate_party_sites;

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

4490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4491: WHEN OTHERS THEN
4492: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4493: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_party_sites');
4494: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4495: FND_MSG_PUB.ADD;
4496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4497: END find_duplicate_party_sites;
4498:

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

4577: RAISE FND_API.G_EXC_ERROR;
4578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4580: WHEN OTHERS THEN
4581: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4582: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contacts');
4583: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4584: FND_MSG_PUB.ADD;
4585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4582: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contacts');

4578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4580: WHEN OTHERS THEN
4581: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4582: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contacts');
4583: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4584: FND_MSG_PUB.ADD;
4585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4586: END find_duplicate_contacts;

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

4579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4580: WHEN OTHERS THEN
4581: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4582: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contacts');
4583: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4584: FND_MSG_PUB.ADD;
4585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4586: END find_duplicate_contacts;
4587:

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

4650: RAISE FND_API.G_EXC_ERROR;
4651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4653: WHEN OTHERS THEN
4654: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4655: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contact_points');
4656: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4657: FND_MSG_PUB.ADD;
4658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4655: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contact_points');

4651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4653: WHEN OTHERS THEN
4654: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4655: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contact_points');
4656: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4657: FND_MSG_PUB.ADD;
4658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4659: END find_duplicate_contact_points;

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

4652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4653: WHEN OTHERS THEN
4654: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4655: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contact_points');
4656: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4657: FND_MSG_PUB.ADD;
4658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4659: END find_duplicate_contact_points;
4660:

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

4952: RAISE FND_API.G_EXC_ERROR;
4953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4955: WHEN OTHERS THEN
4956: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4957: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.call_api_dynamic');
4958: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4959: FND_MSG_PUB.ADD;
4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4957: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.call_api_dynamic');

4953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4955: WHEN OTHERS THEN
4956: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4957: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.call_api_dynamic');
4958: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4959: FND_MSG_PUB.ADD;
4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4961: END call_api_dynamic;

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

4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4955: WHEN OTHERS THEN
4956: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4957: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.call_api_dynamic');
4958: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4959: FND_MSG_PUB.ADD;
4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4961: END call_api_dynamic;
4962:

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

5196: RAISE FND_API.G_EXC_ERROR;
5197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5199: WHEN OTHERS THEN
5200: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5201: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_party_sites');
5202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5203: FND_MSG_PUB.ADD;
5204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5201: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_party_sites');

5197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5199: WHEN OTHERS THEN
5200: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5201: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_party_sites');
5202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5203: FND_MSG_PUB.ADD;
5204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5205: END get_matching_party_sites;

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

5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5199: WHEN OTHERS THEN
5200: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5201: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_party_sites');
5202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5203: FND_MSG_PUB.ADD;
5204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5205: END get_matching_party_sites;
5206:

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

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

Line 5426: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_contacts');

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

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

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

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

5560: RAISE FND_API.G_EXC_ERROR;
5561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5563: WHEN OTHERS THEN
5564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5565: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_contact_points');
5566: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5567: FND_MSG_PUB.ADD;
5568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5565: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_contact_points');

5561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5563: WHEN OTHERS THEN
5564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5565: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_contact_points');
5566: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5567: FND_MSG_PUB.ADD;
5568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5569: END get_matching_contact_points;

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

5562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5563: WHEN OTHERS THEN
5564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5565: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_contact_points');
5566: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5567: FND_MSG_PUB.ADD;
5568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5569: END get_matching_contact_points;
5570:

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

5791: RAISE FND_API.G_EXC_ERROR;
5792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5794: WHEN OTHERS THEN
5795: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5796: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_score_details');
5797: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5798: FND_MSG_PUB.ADD;
5799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5796: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_score_details');

5792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5794: WHEN OTHERS THEN
5795: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5796: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_score_details');
5797: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5798: FND_MSG_PUB.ADD;
5799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5800: END get_score_details;

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

5793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5794: WHEN OTHERS THEN
5795: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5796: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_score_details');
5797: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5798: FND_MSG_PUB.ADD;
5799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5800: END get_score_details;
5801:

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

5869: RAISE FND_API.G_EXC_ERROR;
5870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5872: WHEN OTHERS THEN
5873: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5874: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5875: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5876: FND_MSG_PUB.ADD;
5877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5872: WHEN OTHERS THEN
5873: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5874: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5875: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5876: FND_MSG_PUB.ADD;
5877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5878: END get_party_for_search;

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

5871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5872: WHEN OTHERS THEN
5873: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5874: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5875: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5876: FND_MSG_PUB.ADD;
5877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5878: END get_party_for_search;
5879:

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

5909: RAISE FND_API.G_EXC_ERROR;
5910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5912: WHEN OTHERS THEN
5913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5914: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5916: FND_MSG_PUB.ADD;
5917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5912: WHEN OTHERS THEN
5913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5914: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5916: FND_MSG_PUB.ADD;
5917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5918: END get_search_criteria;

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

5911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5912: WHEN OTHERS THEN
5913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5914: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5916: FND_MSG_PUB.ADD;
5917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5918: END get_search_criteria;
5919:

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

5971: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
5972:
5973: EXCEPTION
5974: WHEN OTHERS THEN
5975: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5976: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5977: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5978: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5979: FND_MSG_PUB.ADD;

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

5972:
5973: EXCEPTION
5974: WHEN OTHERS THEN
5975: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5976: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5977: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5978: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5979: FND_MSG_PUB.ADD;
5980: RAISE FND_API.G_EXC_ERROR;

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

5973: EXCEPTION
5974: WHEN OTHERS THEN
5975: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5976: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5977: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5978: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5979: FND_MSG_PUB.ADD;
5980: RAISE FND_API.G_EXC_ERROR;
5981: END get_party_rec;

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

5974: WHEN OTHERS THEN
5975: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5976: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5977: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5978: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5979: FND_MSG_PUB.ADD;
5980: RAISE FND_API.G_EXC_ERROR;
5981: END get_party_rec;
5982:

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

6037: END LOOP;
6038:
6039: EXCEPTION
6040: WHEN OTHERS THEN
6041: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6042: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6043: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6045: FND_MSG_PUB.ADD;

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

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

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

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

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

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

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

6093: END LOOP;
6094:
6095: EXCEPTION
6096: WHEN OTHERS THEN
6097: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6098: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6099: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6101: FND_MSG_PUB.ADD;

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

6094:
6095: EXCEPTION
6096: WHEN OTHERS THEN
6097: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6098: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6099: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6101: FND_MSG_PUB.ADD;
6102: RAISE FND_API.G_EXC_ERROR;

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

6095: EXCEPTION
6096: WHEN OTHERS THEN
6097: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6098: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6099: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6101: FND_MSG_PUB.ADD;
6102: RAISE FND_API.G_EXC_ERROR;
6103: END get_contact_rec;

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

6096: WHEN OTHERS THEN
6097: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6098: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6099: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6101: FND_MSG_PUB.ADD;
6102: RAISE FND_API.G_EXC_ERROR;
6103: END get_contact_rec;
6104:

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

6145: END LOOP;
6146:
6147: EXCEPTION
6148: WHEN OTHERS THEN
6149: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6150: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6151: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6153: FND_MSG_PUB.ADD;

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

6146:
6147: EXCEPTION
6148: WHEN OTHERS THEN
6149: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6150: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6151: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6153: FND_MSG_PUB.ADD;
6154: RAISE FND_API.G_EXC_ERROR;

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

6147: EXCEPTION
6148: WHEN OTHERS THEN
6149: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6150: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6151: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6153: FND_MSG_PUB.ADD;
6154: RAISE FND_API.G_EXC_ERROR;
6155: END get_contact_point_rec;

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

6148: WHEN OTHERS THEN
6149: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6150: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6151: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6153: FND_MSG_PUB.ADD;
6154: RAISE FND_API.G_EXC_ERROR;
6155: END get_contact_point_rec;
6156:

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

6268: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6269: END IF;
6270: EXCEPTION
6271: WHEN OTHERS THEN
6272: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6273: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6274: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6275: FND_MSG_PUB.ADD;
6276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6269: END IF;
6270: EXCEPTION
6271: WHEN OTHERS THEN
6272: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6273: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6274: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6275: FND_MSG_PUB.ADD;
6276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6277: END;

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

6270: EXCEPTION
6271: WHEN OTHERS THEN
6272: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6273: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6274: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6275: FND_MSG_PUB.ADD;
6276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6277: END;
6278:

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

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

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

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

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

6540: EXCEPTION
6541: WHEN OTHERS THEN
6542: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6543: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6544: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6545: FND_MSG_PUB.ADD;
6546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6547: END;
6548:

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

6580: END IF;
6581: NULL;
6582: EXCEPTION
6583: WHEN OTHERS THEN
6584: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6585: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6586: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6587: FND_MSG_PUB.ADD;
6588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6581: NULL;
6582: EXCEPTION
6583: WHEN OTHERS THEN
6584: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6585: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6586: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6587: FND_MSG_PUB.ADD;
6588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6589: END;

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

6582: EXCEPTION
6583: WHEN OTHERS THEN
6584: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6585: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6586: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6587: FND_MSG_PUB.ADD;
6588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6589: END;
6590:

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

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

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

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

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

6649: EXCEPTION
6650: WHEN OTHERS THEN
6651: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6652: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6654: FND_MSG_PUB.ADD;
6655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6656: END;
6657:

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

6715: EXCEPTION
6716: WHEN FND_API.G_EXC_ERROR THEN
6717: RAISE FND_API.G_EXC_ERROR;
6718: WHEN OTHERS THEN
6719: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6720: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6722: FND_MSG_PUB.ADD;
6723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6716: WHEN FND_API.G_EXC_ERROR THEN
6717: RAISE FND_API.G_EXC_ERROR;
6718: WHEN OTHERS THEN
6719: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6720: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6722: FND_MSG_PUB.ADD;
6723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6724: END check_prim_cond;

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

6717: RAISE FND_API.G_EXC_ERROR;
6718: WHEN OTHERS THEN
6719: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6720: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6722: FND_MSG_PUB.ADD;
6723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6724: END check_prim_cond;
6725:

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

6771: NULL;
6772: END LOOP;
6773: EXCEPTION
6774: WHEN OTHERS THEN
6775: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6776: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6777: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6778: FND_MSG_PUB.ADD;
6779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6772: END LOOP;
6773: EXCEPTION
6774: WHEN OTHERS THEN
6775: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6776: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6777: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6778: FND_MSG_PUB.ADD;
6779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6780: END check_party_site_cond;

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

6773: EXCEPTION
6774: WHEN OTHERS THEN
6775: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6776: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6777: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6778: FND_MSG_PUB.ADD;
6779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6780: END check_party_site_cond;
6781:

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

6809: NULL;
6810: END LOOP;
6811: EXCEPTION
6812: WHEN OTHERS THEN
6813: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6814: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6815: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6816: FND_MSG_PUB.ADD;
6817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6810: END LOOP;
6811: EXCEPTION
6812: WHEN OTHERS THEN
6813: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6814: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6815: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6816: FND_MSG_PUB.ADD;
6817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6818: END check_contact_cond;

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

6811: EXCEPTION
6812: WHEN OTHERS THEN
6813: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6814: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6815: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6816: FND_MSG_PUB.ADD;
6817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6818: END check_contact_cond;
6819:

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

6832: x_secondary:= FALSE;
6833:
6834: FOR I IN 1..p_contact_point_list.COUNT LOOP
6835: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6836: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6837: FND_MSG_PUB.ADD;
6838: RAISE FND_API.G_EXC_ERROR;
6839: END IF;
6840: END LOOP;

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

6846: NULL;
6847: END LOOP;
6848: EXCEPTION
6849: WHEN OTHERS THEN
6850: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6851: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6852: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6853: FND_MSG_PUB.ADD;
6854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6847: END LOOP;
6848: EXCEPTION
6849: WHEN OTHERS THEN
6850: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6851: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6852: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6853: FND_MSG_PUB.ADD;
6854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6855: END check_contact_point_cond;

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

6848: EXCEPTION
6849: WHEN OTHERS THEN
6850: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6851: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6852: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6853: FND_MSG_PUB.ADD;
6854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6855: END check_contact_point_cond;
6856: