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

780: BEGIN
781: NULL ;
782: EXCEPTION
783: WHEN OTHERS THEN
784: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
785: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
786: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
787: FND_MSG_PUB.ADD;
788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

781: NULL ;
782: EXCEPTION
783: WHEN OTHERS THEN
784: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
785: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
786: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
787: FND_MSG_PUB.ADD;
788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
789: END;

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

782: EXCEPTION
783: WHEN OTHERS THEN
784: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
785: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
786: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
787: FND_MSG_PUB.ADD;
788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
789: END;
790:

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

805: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,p_search_list(1).COUNTRY);
806: END IF ;
807: EXCEPTION
808: WHEN OTHERS THEN
809: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
810: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
811: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
812: FND_MSG_PUB.ADD;
813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

806: END IF ;
807: EXCEPTION
808: WHEN OTHERS THEN
809: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
810: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
811: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
812: FND_MSG_PUB.ADD;
813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
814: END;

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

807: EXCEPTION
808: WHEN OTHERS THEN
809: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
810: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
811: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
812: FND_MSG_PUB.ADD;
813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
814: END;
815:

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

825: BEGIN
826: NULL ;
827: EXCEPTION
828: WHEN OTHERS THEN
829: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
830: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
831: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
832: FND_MSG_PUB.ADD;
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

826: NULL ;
827: EXCEPTION
828: WHEN OTHERS THEN
829: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
830: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
831: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
832: FND_MSG_PUB.ADD;
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: END;

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

827: EXCEPTION
828: WHEN OTHERS THEN
829: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
830: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
831: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
832: FND_MSG_PUB.ADD;
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: END;
835:

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

845: BEGIN
846: NULL ;
847: EXCEPTION
848: WHEN OTHERS THEN
849: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
850: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
852: FND_MSG_PUB.ADD;
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

846: NULL ;
847: EXCEPTION
848: WHEN OTHERS THEN
849: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
850: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
852: FND_MSG_PUB.ADD;
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
854: END;

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

847: EXCEPTION
848: WHEN OTHERS THEN
849: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
850: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
852: FND_MSG_PUB.ADD;
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
854: END;
855:

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

914: IF NOT check_prim_cond (p_party_search_rec,
915: p_party_site_list,
916: p_contact_list,
917: p_contact_point_list) THEN
918: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
919: FND_MSG_PUB.ADD;
920: RAISE FND_API.G_EXC_ERROR;
921: END IF;
922: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1184: ELSE
1185: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1186: END IF;
1187: IF lengthb(l_party_contains_str) > 4000 THEN
1188: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1189: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1190: FND_MSG_PUB.ADD;
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;

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

1185: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1186: END IF;
1187: IF lengthb(l_party_contains_str) > 4000 THEN
1188: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1189: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1190: FND_MSG_PUB.ADD;
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;
1193: IF (p_match_str = ' AND ' OR p_party_max_score

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

1273: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1274: END LOOP;
1275: -- Add the search criteria to query string
1276: IF lengthb(l_contains_str) > 4000 THEN
1277: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1278: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1279: FND_MSG_PUB.ADD;
1280: RAISE FND_API.G_EXC_ERROR;
1281: END IF;

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

1274: END LOOP;
1275: -- Add the search criteria to query string
1276: IF lengthb(l_contains_str) > 4000 THEN
1277: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1278: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1279: FND_MSG_PUB.ADD;
1280: RAISE FND_API.G_EXC_ERROR;
1281: END IF;
1282: x_denorm_str := l_den_contains_str;

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

1568: END IF;
1569: exception
1570: when others then
1571: if (instrb(SQLERRM,'DRG-51030')>0) then
1572: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1573: FND_MSG_PUB.ADD;
1574: RAISE FND_API.G_EXC_ERROR;
1575: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1576: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1572: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1573: FND_MSG_PUB.ADD;
1574: RAISE FND_API.G_EXC_ERROR;
1575: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1576: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1577: FND_MSG_PUB.ADD;
1578: RAISE FND_API.G_EXC_ERROR;
1579: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1580: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1576: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1577: FND_MSG_PUB.ADD;
1578: RAISE FND_API.G_EXC_ERROR;
1579: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1580: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1581: FND_MSG_PUB.ADD;
1582: RAISE FND_API.G_EXC_ERROR;
1583: else
1584: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1580: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1581: FND_MSG_PUB.ADD;
1582: RAISE FND_API.G_EXC_ERROR;
1583: else
1584: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1585: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1586: FND_MSG_PUB.ADD;
1587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1588: end if;

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

1581: FND_MSG_PUB.ADD;
1582: RAISE FND_API.G_EXC_ERROR;
1583: else
1584: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1585: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1586: FND_MSG_PUB.ADD;
1587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1588: end if;
1589: END;

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

1813: output_long_strings('Restrict Sql = '||p_restrict_sql);
1814: exception
1815: when others then
1816: if (instrb(SQLERRM,'DRG-51030')>0) then
1817: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1818: FND_MSG_PUB.ADD;
1819: RAISE FND_API.G_EXC_ERROR;
1820: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1821: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1817: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1818: FND_MSG_PUB.ADD;
1819: RAISE FND_API.G_EXC_ERROR;
1820: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1821: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1822: FND_MSG_PUB.ADD;
1823: RAISE FND_API.G_EXC_ERROR;
1824: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1825: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1821: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1822: FND_MSG_PUB.ADD;
1823: RAISE FND_API.G_EXC_ERROR;
1824: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1825: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1826: FND_MSG_PUB.ADD;
1827: RAISE FND_API.G_EXC_ERROR;
1828: else
1829: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1825: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1826: FND_MSG_PUB.ADD;
1827: RAISE FND_API.G_EXC_ERROR;
1828: else
1829: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1830: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1831: FND_MSG_PUB.ADD;
1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1833: end if;

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

1826: FND_MSG_PUB.ADD;
1827: RAISE FND_API.G_EXC_ERROR;
1828: else
1829: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1830: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1831: FND_MSG_PUB.ADD;
1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1833: end if;
1834: END;

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

1960: output_long_strings('Restrict Sql = '||p_restrict_sql);
1961: exception
1962: when others then
1963: if (instrb(SQLERRM,'DRG-51030')>0) then
1964: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1965: FND_MSG_PUB.ADD;
1966: RAISE FND_API.G_EXC_ERROR;
1967: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1964: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1965: FND_MSG_PUB.ADD;
1966: RAISE FND_API.G_EXC_ERROR;
1967: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1969: FND_MSG_PUB.ADD;
1970: RAISE FND_API.G_EXC_ERROR;
1971: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1969: FND_MSG_PUB.ADD;
1970: RAISE FND_API.G_EXC_ERROR;
1971: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1973: FND_MSG_PUB.ADD;
1974: RAISE FND_API.G_EXC_ERROR;
1975: else
1976: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1973: FND_MSG_PUB.ADD;
1974: RAISE FND_API.G_EXC_ERROR;
1975: else
1976: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1977: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1978: FND_MSG_PUB.ADD;
1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1980: end if;

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

1973: FND_MSG_PUB.ADD;
1974: RAISE FND_API.G_EXC_ERROR;
1975: else
1976: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1977: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1978: FND_MSG_PUB.ADD;
1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1980: end if;
1981: END;

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

2233: output_long_strings('Restrict Sql = '||p_restrict_sql);
2234: exception
2235: when others then
2236: if (instrb(SQLERRM,'DRG-51030')>0) then
2237: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2238: FND_MSG_PUB.ADD;
2239: RAISE FND_API.G_EXC_ERROR;
2240: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2241: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2237: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2238: FND_MSG_PUB.ADD;
2239: RAISE FND_API.G_EXC_ERROR;
2240: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2241: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2242: FND_MSG_PUB.ADD;
2243: RAISE FND_API.G_EXC_ERROR;
2244: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2245: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2241: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2242: FND_MSG_PUB.ADD;
2243: RAISE FND_API.G_EXC_ERROR;
2244: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2245: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2246: FND_MSG_PUB.ADD;
2247: RAISE FND_API.G_EXC_ERROR;
2248: else
2249: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2245: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2246: FND_MSG_PUB.ADD;
2247: RAISE FND_API.G_EXC_ERROR;
2248: else
2249: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2251: FND_MSG_PUB.ADD;
2252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2253: end if;

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

2246: FND_MSG_PUB.ADD;
2247: RAISE FND_API.G_EXC_ERROR;
2248: else
2249: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2251: FND_MSG_PUB.ADD;
2252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2253: end if;
2254: END;

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

2501: IF p_index>1 THEN
2502: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2503: 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);
2504: END IF;
2505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2506: FND_MSG_PUB.ADD;
2507: RAISE FND_API.G_EXC_ERROR;
2508: ELSE
2509: push_eval;

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

2549: IF p_index>1 THEN
2550: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2551: 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);
2552: END IF;
2553: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2554: FND_MSG_PUB.ADD;
2555: RAISE FND_API.G_EXC_ERROR;
2556: ELSE
2557: push_eval;

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

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

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

2734: IF p_index>1 THEN
2735: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2736: 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);
2737: END IF;
2738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2739: FND_MSG_PUB.ADD;
2740: RAISE FND_API.G_EXC_ERROR;
2741: ELSE
2742: push_eval;

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

2845: IF p_index>1 THEN
2846: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2847: 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);
2848: END IF;
2849: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2850: FND_MSG_PUB.ADD;
2851: RAISE FND_API.G_EXC_ERROR;
2852: ELSE
2853: push_eval;

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

3070: ELSE
3071: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3072: 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);
3073: END IF;
3074: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3075: FND_MSG_PUB.ADD;
3076: RAISE FND_API.G_EXC_ERROR;
3077: END IF;
3078: ELSE

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

3078: ELSE
3079: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3080: 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);
3081: END IF;
3082: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3083: FND_MSG_PUB.ADD;
3084: RAISE FND_API.G_EXC_ERROR;
3085: END IF;
3086: END IF;

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

3284: RAISE FND_API.G_EXC_ERROR;
3285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3287: WHEN OTHERS THEN
3288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_parties');
3290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3291: FND_MSG_PUB.ADD;
3292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_parties');

3285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3287: WHEN OTHERS THEN
3288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_parties');
3290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3291: FND_MSG_PUB.ADD;
3292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3293: END find_parties;

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

3286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3287: WHEN OTHERS THEN
3288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_parties');
3290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3291: FND_MSG_PUB.ADD;
3292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3293: END find_parties;
3294:

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

3481: IF p_index>1 THEN
3482: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3483: 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);
3484: END IF;
3485: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3486: FND_MSG_PUB.ADD;
3487: RAISE FND_API.G_EXC_ERROR;
3488: ELSE
3489: push_eval;

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

3529: IF p_index>1 THEN
3530: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3531: 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);
3532: END IF;
3533: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3534: FND_MSG_PUB.ADD;
3535: RAISE FND_API.G_EXC_ERROR;
3536: ELSE
3537: push_eval;

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

3565: and d.search_context_id = p_search_ctx_id);
3566: exception
3567: when others then
3568: if (instrb(SQLERRM,'DRG-51030')>0) then
3569: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3570: FND_MSG_PUB.ADD;
3571: RAISE FND_API.G_EXC_ERROR;
3572: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3573: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3569: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3570: FND_MSG_PUB.ADD;
3571: RAISE FND_API.G_EXC_ERROR;
3572: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3573: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3574: FND_MSG_PUB.ADD;
3575: RAISE FND_API.G_EXC_ERROR;
3576: else
3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3641: IF p_index>1 THEN
3642: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3643: 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);
3644: END IF;
3645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3646: FND_MSG_PUB.ADD;
3647: RAISE FND_API.G_EXC_ERROR;
3648: ELSE
3649: push_eval;

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

3900: IF p_index>1 THEN
3901: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3902: 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);
3903: END IF;
3904: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3905: FND_MSG_PUB.ADD;
3906: RAISE FND_API.G_EXC_ERROR;
3907: ELSE
3908: push_eval;

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

4013: ELSE
4014: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4015: 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);
4016: END IF;
4017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4018: FND_MSG_PUB.ADD;
4019: RAISE FND_API.G_EXC_ERROR;
4020: END IF;
4021: ELSE

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

4021: ELSE
4022: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4023: 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);
4024: END IF;
4025: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4026: FND_MSG_PUB.ADD;
4027: RAISE FND_API.G_EXC_ERROR;
4028: END IF;
4029: END IF;

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

4142: RAISE FND_API.G_EXC_ERROR;
4143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4145: WHEN OTHERS THEN
4146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4147: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_persons');
4148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4149: FND_MSG_PUB.ADD;
4150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4147: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_persons');

4143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4145: WHEN OTHERS THEN
4146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4147: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_persons');
4148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4149: FND_MSG_PUB.ADD;
4150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4151: END find_persons;

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

4144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4145: WHEN OTHERS THEN
4146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4147: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_persons');
4148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4149: FND_MSG_PUB.ADD;
4150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4151: END find_persons;
4152:

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

4210: RAISE FND_API.G_EXC_ERROR;
4211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4213: WHEN OTHERS THEN
4214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4215: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_party_details');
4216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4217: FND_MSG_PUB.ADD;
4218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4215: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_party_details');

4211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4213: WHEN OTHERS THEN
4214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4215: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_party_details');
4216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4217: FND_MSG_PUB.ADD;
4218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4219: END find_party_details;

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

4212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4213: WHEN OTHERS THEN
4214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4215: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_party_details');
4216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4217: FND_MSG_PUB.ADD;
4218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4219: END find_party_details;
4220:

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

4327: RAISE FND_API.G_EXC_ERROR;
4328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4330: WHEN OTHERS THEN
4331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4332: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_parties');
4333: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4334: FND_MSG_PUB.ADD;
4335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4332: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_parties');

4328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4330: WHEN OTHERS THEN
4331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4332: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_parties');
4333: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4334: FND_MSG_PUB.ADD;
4335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4336: END find_duplicate_parties;

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

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

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

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

Line 4417: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_party_sites');

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

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

4414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4415: WHEN OTHERS THEN
4416: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4417: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_party_sites');
4418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4419: FND_MSG_PUB.ADD;
4420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4421: END find_duplicate_party_sites;
4422:

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

4501: RAISE FND_API.G_EXC_ERROR;
4502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4504: WHEN OTHERS THEN
4505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4506: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contacts');
4507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4508: FND_MSG_PUB.ADD;
4509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4506: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contacts');

4502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4504: WHEN OTHERS THEN
4505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4506: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contacts');
4507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4508: FND_MSG_PUB.ADD;
4509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4510: END find_duplicate_contacts;

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

4503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4504: WHEN OTHERS THEN
4505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4506: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contacts');
4507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4508: FND_MSG_PUB.ADD;
4509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4510: END find_duplicate_contacts;
4511:

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

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

Line 4579: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contact_points');

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

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

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

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

4862: RAISE FND_API.G_EXC_ERROR;
4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4865: WHEN OTHERS THEN
4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.call_api_dynamic');
4868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4869: FND_MSG_PUB.ADD;
4870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.call_api_dynamic');

4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4865: WHEN OTHERS THEN
4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.call_api_dynamic');
4868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4869: FND_MSG_PUB.ADD;
4870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4871: END call_api_dynamic;

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

4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4865: WHEN OTHERS THEN
4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.call_api_dynamic');
4868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4869: FND_MSG_PUB.ADD;
4870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4871: END call_api_dynamic;
4872:

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

5100: RAISE FND_API.G_EXC_ERROR;
5101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5103: WHEN OTHERS THEN
5104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5105: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_party_sites');
5106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5107: FND_MSG_PUB.ADD;
5108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5105: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_party_sites');

5101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5103: WHEN OTHERS THEN
5104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5105: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_party_sites');
5106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5107: FND_MSG_PUB.ADD;
5108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5109: END get_matching_party_sites;

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

5102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5103: WHEN OTHERS THEN
5104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5105: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_party_sites');
5106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5107: FND_MSG_PUB.ADD;
5108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5109: END get_matching_party_sites;
5110:

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

5325: RAISE FND_API.G_EXC_ERROR;
5326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5328: WHEN OTHERS THEN
5329: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5330: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contacts');
5331: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5332: FND_MSG_PUB.ADD;
5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5330: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contacts');

5326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5328: WHEN OTHERS THEN
5329: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5330: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contacts');
5331: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5332: FND_MSG_PUB.ADD;
5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5334: END get_matching_contacts;

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

5327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5328: WHEN OTHERS THEN
5329: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5330: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contacts');
5331: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5332: FND_MSG_PUB.ADD;
5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5334: END get_matching_contacts;
5335:

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

5464: RAISE FND_API.G_EXC_ERROR;
5465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5467: WHEN OTHERS THEN
5468: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5469: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contact_points');
5470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5471: FND_MSG_PUB.ADD;
5472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5469: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contact_points');

5465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5467: WHEN OTHERS THEN
5468: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5469: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contact_points');
5470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5471: FND_MSG_PUB.ADD;
5472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5473: END get_matching_contact_points;

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

5466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5467: WHEN OTHERS THEN
5468: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5469: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contact_points');
5470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5471: FND_MSG_PUB.ADD;
5472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5473: END get_matching_contact_points;
5474:

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

5682: RAISE FND_API.G_EXC_ERROR;
5683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5685: WHEN OTHERS THEN
5686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5687: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_score_details');
5688: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5689: FND_MSG_PUB.ADD;
5690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5687: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_score_details');

5683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5685: WHEN OTHERS THEN
5686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5687: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_score_details');
5688: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5689: FND_MSG_PUB.ADD;
5690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5691: END get_score_details;

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

5684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5685: WHEN OTHERS THEN
5686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5687: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_score_details');
5688: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5689: FND_MSG_PUB.ADD;
5690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5691: END get_score_details;
5692:

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

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

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

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

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

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

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

5800: RAISE FND_API.G_EXC_ERROR;
5801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5803: WHEN OTHERS THEN
5804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5805: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5807: FND_MSG_PUB.ADD;
5808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5803: WHEN OTHERS THEN
5804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5805: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5807: FND_MSG_PUB.ADD;
5808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5809: END get_search_criteria;

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

5802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5803: WHEN OTHERS THEN
5804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5805: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5807: FND_MSG_PUB.ADD;
5808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5809: END get_search_criteria;
5810:

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

5864: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
5865:
5866: EXCEPTION
5867: WHEN OTHERS THEN
5868: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5869: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5870: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5871: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5872: FND_MSG_PUB.ADD;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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_contact_point_rec');
6038: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6040: FND_MSG_PUB.ADD;

Line 6037: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_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_contact_point_rec');
6038: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_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_contact_point_id);

6034: EXCEPTION
6035: WHEN OTHERS THEN
6036: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6037: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6038: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6040: FND_MSG_PUB.ADD;
6041: RAISE FND_API.G_EXC_ERROR;
6042: END get_contact_point_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_contact_point_rec');
6038: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6040: FND_MSG_PUB.ADD;
6041: RAISE FND_API.G_EXC_ERROR;
6042: END get_contact_point_rec;
6043:

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

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

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

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

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

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

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

6349: END IF;
6350: END LOOP;
6351: EXCEPTION
6352: WHEN OTHERS THEN
6353: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6354: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6355: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6356: FND_MSG_PUB.ADD;
6357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6350: END LOOP;
6351: EXCEPTION
6352: WHEN OTHERS THEN
6353: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6354: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6355: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6356: FND_MSG_PUB.ADD;
6357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6358: END;

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

6351: EXCEPTION
6352: WHEN OTHERS THEN
6353: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6354: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6355: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6356: FND_MSG_PUB.ADD;
6357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6358: END;
6359:

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

6391: END IF;
6392: NULL;
6393: EXCEPTION
6394: WHEN OTHERS THEN
6395: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6396: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6398: FND_MSG_PUB.ADD;
6399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6392: NULL;
6393: EXCEPTION
6394: WHEN OTHERS THEN
6395: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6396: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6398: FND_MSG_PUB.ADD;
6399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6400: END;

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

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

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

6458: END IF;
6459: NULL;
6460: EXCEPTION
6461: WHEN OTHERS THEN
6462: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6463: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6464: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6465: FND_MSG_PUB.ADD;
6466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6459: NULL;
6460: EXCEPTION
6461: WHEN OTHERS THEN
6462: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6463: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6464: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6465: FND_MSG_PUB.ADD;
6466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6467: END;

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

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

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

6517: EXCEPTION
6518: WHEN FND_API.G_EXC_ERROR THEN
6519: RAISE FND_API.G_EXC_ERROR;
6520: WHEN OTHERS THEN
6521: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6522: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6523: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6524: FND_MSG_PUB.ADD;
6525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6518: WHEN FND_API.G_EXC_ERROR THEN
6519: RAISE FND_API.G_EXC_ERROR;
6520: WHEN OTHERS THEN
6521: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6522: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6523: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6524: FND_MSG_PUB.ADD;
6525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6526: END check_prim_cond;

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

6519: RAISE FND_API.G_EXC_ERROR;
6520: WHEN OTHERS THEN
6521: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6522: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6523: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6524: FND_MSG_PUB.ADD;
6525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6526: END check_prim_cond;
6527:

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

6567: NULL;
6568: END LOOP;
6569: EXCEPTION
6570: WHEN OTHERS THEN
6571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6572: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6573: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6574: FND_MSG_PUB.ADD;
6575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6568: END LOOP;
6569: EXCEPTION
6570: WHEN OTHERS THEN
6571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6572: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6573: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6574: FND_MSG_PUB.ADD;
6575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6576: END check_party_site_cond;

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

6569: EXCEPTION
6570: WHEN OTHERS THEN
6571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6572: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6573: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6574: FND_MSG_PUB.ADD;
6575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6576: END check_party_site_cond;
6577:

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

6605: NULL;
6606: END LOOP;
6607: EXCEPTION
6608: WHEN OTHERS THEN
6609: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6610: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6611: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6612: FND_MSG_PUB.ADD;
6613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6606: END LOOP;
6607: EXCEPTION
6608: WHEN OTHERS THEN
6609: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6610: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6611: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6612: FND_MSG_PUB.ADD;
6613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6614: END check_contact_cond;

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

6607: EXCEPTION
6608: WHEN OTHERS THEN
6609: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6610: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6611: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6612: FND_MSG_PUB.ADD;
6613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6614: END check_contact_cond;
6615:

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

6628: x_secondary:= FALSE;
6629:
6630: FOR I IN 1..p_contact_point_list.COUNT LOOP
6631: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6632: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6633: FND_MSG_PUB.ADD;
6634: RAISE FND_API.G_EXC_ERROR;
6635: END IF;
6636: END LOOP;

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

6642: NULL;
6643: END LOOP;
6644: EXCEPTION
6645: WHEN OTHERS THEN
6646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6647: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
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','check_contact_point_cond');

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

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

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