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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4214: RAISE FND_API.G_EXC_ERROR;
4215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4217: WHEN OTHERS THEN
4218: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4219: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_persons');
4220: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4221: FND_MSG_PUB.ADD;
4222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4217: WHEN OTHERS THEN
4218: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4219: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_persons');
4220: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4221: FND_MSG_PUB.ADD;
4222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4223: END find_persons;

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

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

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

4282: RAISE FND_API.G_EXC_ERROR;
4283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4285: WHEN OTHERS THEN
4286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4287: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_party_details');
4288: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4289: FND_MSG_PUB.ADD;
4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4285: WHEN OTHERS THEN
4286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4287: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_party_details');
4288: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4289: FND_MSG_PUB.ADD;
4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4291: END find_party_details;

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

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

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

4399: RAISE FND_API.G_EXC_ERROR;
4400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4402: WHEN OTHERS THEN
4403: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4404: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_parties');
4405: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4406: FND_MSG_PUB.ADD;
4407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4402: WHEN OTHERS THEN
4403: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4404: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_parties');
4405: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4406: FND_MSG_PUB.ADD;
4407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4408: END find_duplicate_parties;

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

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

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

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

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

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

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

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

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

4573: RAISE FND_API.G_EXC_ERROR;
4574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4576: WHEN OTHERS THEN
4577: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4578: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contacts');
4579: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4580: FND_MSG_PUB.ADD;
4581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4576: WHEN OTHERS THEN
4577: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4578: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contacts');
4579: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4580: FND_MSG_PUB.ADD;
4581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4582: END find_duplicate_contacts;

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

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

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

4646: RAISE FND_API.G_EXC_ERROR;
4647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4649: WHEN OTHERS THEN
4650: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4651: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contact_points');
4652: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4653: FND_MSG_PUB.ADD;
4654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4649: WHEN OTHERS THEN
4650: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4651: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contact_points');
4652: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4653: FND_MSG_PUB.ADD;
4654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4655: END find_duplicate_contact_points;

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

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

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

4948: RAISE FND_API.G_EXC_ERROR;
4949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4951: WHEN OTHERS THEN
4952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4953: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.call_api_dynamic');
4954: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4955: FND_MSG_PUB.ADD;
4956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4951: WHEN OTHERS THEN
4952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4953: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.call_api_dynamic');
4954: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4955: FND_MSG_PUB.ADD;
4956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4957: END call_api_dynamic;

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

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

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

5192: RAISE FND_API.G_EXC_ERROR;
5193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5195: WHEN OTHERS THEN
5196: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5197: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_party_sites');
5198: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5199: FND_MSG_PUB.ADD;
5200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5195: WHEN OTHERS THEN
5196: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5197: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_party_sites');
5198: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5199: FND_MSG_PUB.ADD;
5200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5201: END get_matching_party_sites;

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

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

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

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

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

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

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

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

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

5556: RAISE FND_API.G_EXC_ERROR;
5557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5559: WHEN OTHERS THEN
5560: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5561: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_contact_points');
5562: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5563: FND_MSG_PUB.ADD;
5564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5559: WHEN OTHERS THEN
5560: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5561: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_contact_points');
5562: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5563: FND_MSG_PUB.ADD;
5564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5565: END get_matching_contact_points;

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

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

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

5786: RAISE FND_API.G_EXC_ERROR;
5787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5789: WHEN OTHERS THEN
5790: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5791: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_score_details');
5792: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5793: FND_MSG_PUB.ADD;
5794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5789: WHEN OTHERS THEN
5790: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5791: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_score_details');
5792: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5793: FND_MSG_PUB.ADD;
5794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5795: END get_score_details;

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

5788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5789: WHEN OTHERS THEN
5790: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5791: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_score_details');
5792: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5793: FND_MSG_PUB.ADD;
5794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5795: END get_score_details;
5796:

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

5864: RAISE FND_API.G_EXC_ERROR;
5865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5867: WHEN OTHERS THEN
5868: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5869: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5870: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5871: FND_MSG_PUB.ADD;
5872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5867: WHEN OTHERS THEN
5868: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5869: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5870: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5871: FND_MSG_PUB.ADD;
5872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5873: END get_party_for_search;

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

5866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5867: WHEN OTHERS THEN
5868: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5869: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5870: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5871: FND_MSG_PUB.ADD;
5872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5873: END get_party_for_search;
5874:

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

5904: RAISE FND_API.G_EXC_ERROR;
5905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5907: WHEN OTHERS THEN
5908: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5909: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5911: FND_MSG_PUB.ADD;
5912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5907: WHEN OTHERS THEN
5908: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5909: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5911: FND_MSG_PUB.ADD;
5912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5913: END get_search_criteria;

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

5906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5907: WHEN OTHERS THEN
5908: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5909: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5911: FND_MSG_PUB.ADD;
5912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5913: END get_search_criteria;
5914:

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

5966: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
5967:
5968: EXCEPTION
5969: WHEN OTHERS THEN
5970: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5971: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5972: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5973: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5974: FND_MSG_PUB.ADD;

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

5967:
5968: EXCEPTION
5969: WHEN OTHERS THEN
5970: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5971: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5972: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5973: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5974: FND_MSG_PUB.ADD;
5975: RAISE FND_API.G_EXC_ERROR;

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

5968: EXCEPTION
5969: WHEN OTHERS THEN
5970: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5971: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5972: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5973: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5974: FND_MSG_PUB.ADD;
5975: RAISE FND_API.G_EXC_ERROR;
5976: END get_party_rec;

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

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

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

6032: END LOOP;
6033:
6034: EXCEPTION
6035: WHEN OTHERS THEN
6036: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6037: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6038: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6040: FND_MSG_PUB.ADD;

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

6033:
6034: EXCEPTION
6035: WHEN OTHERS THEN
6036: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6037: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6038: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6040: FND_MSG_PUB.ADD;
6041: RAISE FND_API.G_EXC_ERROR;

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

6034: EXCEPTION
6035: WHEN OTHERS THEN
6036: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6037: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6038: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6040: FND_MSG_PUB.ADD;
6041: RAISE FND_API.G_EXC_ERROR;
6042: END get_party_site_rec;

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

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

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

6088: END LOOP;
6089:
6090: EXCEPTION
6091: WHEN OTHERS THEN
6092: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6093: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6094: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6095: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6096: FND_MSG_PUB.ADD;

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

6089:
6090: EXCEPTION
6091: WHEN OTHERS THEN
6092: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6093: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6094: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6095: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6096: FND_MSG_PUB.ADD;
6097: RAISE FND_API.G_EXC_ERROR;

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

6090: EXCEPTION
6091: WHEN OTHERS THEN
6092: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6093: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6094: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6095: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6096: FND_MSG_PUB.ADD;
6097: RAISE FND_API.G_EXC_ERROR;
6098: END get_contact_rec;

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

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

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

6140: END LOOP;
6141:
6142: EXCEPTION
6143: WHEN OTHERS THEN
6144: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6145: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6146: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6147: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6148: FND_MSG_PUB.ADD;

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

6141:
6142: EXCEPTION
6143: WHEN OTHERS THEN
6144: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6145: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6146: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6147: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6148: FND_MSG_PUB.ADD;
6149: RAISE FND_API.G_EXC_ERROR;

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

6142: EXCEPTION
6143: WHEN OTHERS THEN
6144: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6145: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6146: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6147: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6148: FND_MSG_PUB.ADD;
6149: RAISE FND_API.G_EXC_ERROR;
6150: END get_contact_point_rec;

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

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

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

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

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

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

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

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

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

6533: END IF;
6534: END LOOP;
6535: EXCEPTION
6536: WHEN OTHERS THEN
6537: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6538: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6539: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6540: FND_MSG_PUB.ADD;
6541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6534: END LOOP;
6535: EXCEPTION
6536: WHEN OTHERS THEN
6537: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6538: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6539: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6540: FND_MSG_PUB.ADD;
6541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6542: END;

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

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

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

6575: END IF;
6576: NULL;
6577: EXCEPTION
6578: WHEN OTHERS THEN
6579: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6580: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6581: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6582: FND_MSG_PUB.ADD;
6583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6576: NULL;
6577: EXCEPTION
6578: WHEN OTHERS THEN
6579: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6580: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6581: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6582: FND_MSG_PUB.ADD;
6583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6584: END;

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

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

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

6642: END IF;
6643: NULL;
6644: EXCEPTION
6645: WHEN OTHERS THEN
6646: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6647: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6648: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6649: FND_MSG_PUB.ADD;
6650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6643: NULL;
6644: EXCEPTION
6645: WHEN OTHERS THEN
6646: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6647: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6648: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6649: FND_MSG_PUB.ADD;
6650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6651: END;

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

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

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

6710: EXCEPTION
6711: WHEN FND_API.G_EXC_ERROR THEN
6712: RAISE FND_API.G_EXC_ERROR;
6713: WHEN OTHERS THEN
6714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6715: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6717: FND_MSG_PUB.ADD;
6718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6711: WHEN FND_API.G_EXC_ERROR THEN
6712: RAISE FND_API.G_EXC_ERROR;
6713: WHEN OTHERS THEN
6714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6715: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6717: FND_MSG_PUB.ADD;
6718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6719: END check_prim_cond;

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

6712: RAISE FND_API.G_EXC_ERROR;
6713: WHEN OTHERS THEN
6714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6715: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6717: FND_MSG_PUB.ADD;
6718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6719: END check_prim_cond;
6720:

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

6766: NULL;
6767: END LOOP;
6768: EXCEPTION
6769: WHEN OTHERS THEN
6770: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6771: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6772: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6773: FND_MSG_PUB.ADD;
6774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6767: END LOOP;
6768: EXCEPTION
6769: WHEN OTHERS THEN
6770: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6771: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6772: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6773: FND_MSG_PUB.ADD;
6774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6775: END check_party_site_cond;

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

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

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

6804: NULL;
6805: END LOOP;
6806: EXCEPTION
6807: WHEN OTHERS THEN
6808: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6809: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6810: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6811: FND_MSG_PUB.ADD;
6812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6805: END LOOP;
6806: EXCEPTION
6807: WHEN OTHERS THEN
6808: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6809: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6810: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6811: FND_MSG_PUB.ADD;
6812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6813: END check_contact_cond;

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

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

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

6827: x_secondary:= FALSE;
6828:
6829: FOR I IN 1..p_contact_point_list.COUNT LOOP
6830: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6831: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6832: FND_MSG_PUB.ADD;
6833: RAISE FND_API.G_EXC_ERROR;
6834: END IF;
6835: END LOOP;

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

6841: NULL;
6842: END LOOP;
6843: EXCEPTION
6844: WHEN OTHERS THEN
6845: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6846: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6847: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6848: FND_MSG_PUB.ADD;
6849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6842: END LOOP;
6843: EXCEPTION
6844: WHEN OTHERS THEN
6845: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6846: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6847: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6848: FND_MSG_PUB.ADD;
6849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6850: END check_contact_point_cond;

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

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