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

564: BEGIN
565: NULL ;
566: EXCEPTION
567: WHEN OTHERS THEN
568: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
569: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
570: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
571: FND_MSG_PUB.ADD;
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

565: NULL ;
566: EXCEPTION
567: WHEN OTHERS THEN
568: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
569: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
570: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
571: FND_MSG_PUB.ADD;
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: END;

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

566: EXCEPTION
567: WHEN OTHERS THEN
568: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
569: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
570: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
571: FND_MSG_PUB.ADD;
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: END;
574:

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

584: BEGIN
585: NULL ;
586: EXCEPTION
587: WHEN OTHERS THEN
588: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
589: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
590: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
591: FND_MSG_PUB.ADD;
592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

585: NULL ;
586: EXCEPTION
587: WHEN OTHERS THEN
588: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
589: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
590: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
591: FND_MSG_PUB.ADD;
592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
593: END;

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

586: EXCEPTION
587: WHEN OTHERS THEN
588: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
589: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
590: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
591: FND_MSG_PUB.ADD;
592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
593: END;
594:

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

604: BEGIN
605: NULL ;
606: EXCEPTION
607: WHEN OTHERS THEN
608: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
609: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
610: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
611: FND_MSG_PUB.ADD;
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

605: NULL ;
606: EXCEPTION
607: WHEN OTHERS THEN
608: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
609: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
610: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
611: FND_MSG_PUB.ADD;
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END;

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

606: EXCEPTION
607: WHEN OTHERS THEN
608: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
609: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
610: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
611: FND_MSG_PUB.ADD;
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END;
614:

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

624: BEGIN
625: NULL ;
626: EXCEPTION
627: WHEN OTHERS THEN
628: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
629: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
630: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
631: FND_MSG_PUB.ADD;
632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

625: NULL ;
626: EXCEPTION
627: WHEN OTHERS THEN
628: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
629: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
630: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
631: FND_MSG_PUB.ADD;
632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
633: END;

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

626: EXCEPTION
627: WHEN OTHERS THEN
628: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
629: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
630: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
631: FND_MSG_PUB.ADD;
632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
633: END;
634:

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

693: IF NOT check_prim_cond (p_party_search_rec,
694: p_party_site_list,
695: p_contact_list,
696: p_contact_point_list) THEN
697: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
698: FND_MSG_PUB.ADD;
699: RAISE FND_API.G_EXC_ERROR;
700: END IF;
701: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

910: ELSE
911: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
912: END IF;
913: IF lengthb(l_party_contains_str) > 4000 THEN
914: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
915: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
916: FND_MSG_PUB.ADD;
917: RAISE FND_API.G_EXC_ERROR;
918: END IF;

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

911: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
912: END IF;
913: IF lengthb(l_party_contains_str) > 4000 THEN
914: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
915: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
916: FND_MSG_PUB.ADD;
917: RAISE FND_API.G_EXC_ERROR;
918: END IF;
919: IF (p_match_str = ' AND ' OR p_party_max_score

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

979: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
980: END LOOP;
981: -- Add the search criteria to query string
982: IF lengthb(l_contains_str) > 4000 THEN
983: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
984: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
985: FND_MSG_PUB.ADD;
986: RAISE FND_API.G_EXC_ERROR;
987: END IF;

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

980: END LOOP;
981: -- Add the search criteria to query string
982: IF lengthb(l_contains_str) > 4000 THEN
983: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
984: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
985: FND_MSG_PUB.ADD;
986: RAISE FND_API.G_EXC_ERROR;
987: END IF;
988: x_denorm_str := l_den_contains_str;

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

1076: END IF;
1077: END LOOP;
1078: -- Add the search criteria to query string
1079: IF lengthb(l_contains_str) > 4000 THEN
1080: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1081: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1082: FND_MSG_PUB.ADD;
1083: RAISE FND_API.G_EXC_ERROR;
1084: END IF;

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

1077: END LOOP;
1078: -- Add the search criteria to query string
1079: IF lengthb(l_contains_str) > 4000 THEN
1080: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1081: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1082: FND_MSG_PUB.ADD;
1083: RAISE FND_API.G_EXC_ERROR;
1084: END IF;
1085: x_denorm_str := l_den_contains_str;

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

1290: END IF;
1291: exception
1292: when others then
1293: if (instrb(SQLERRM,'DRG-51030')>0) then
1294: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1295: FND_MSG_PUB.ADD;
1296: RAISE FND_API.G_EXC_ERROR;
1297: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1298: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1294: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1295: FND_MSG_PUB.ADD;
1296: RAISE FND_API.G_EXC_ERROR;
1297: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1298: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1299: FND_MSG_PUB.ADD;
1300: RAISE FND_API.G_EXC_ERROR;
1301: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1298: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1299: FND_MSG_PUB.ADD;
1300: RAISE FND_API.G_EXC_ERROR;
1301: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1303: FND_MSG_PUB.ADD;
1304: RAISE FND_API.G_EXC_ERROR;
1305: else
1306: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1303: FND_MSG_PUB.ADD;
1304: RAISE FND_API.G_EXC_ERROR;
1305: else
1306: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1307: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1308: FND_MSG_PUB.ADD;
1309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1310: end if;

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

1303: FND_MSG_PUB.ADD;
1304: RAISE FND_API.G_EXC_ERROR;
1305: else
1306: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1307: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1308: FND_MSG_PUB.ADD;
1309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1310: end if;
1311: END;

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

1535: output_long_strings('Restrict Sql = '||p_restrict_sql);
1536: exception
1537: when others then
1538: if (instrb(SQLERRM,'DRG-51030')>0) then
1539: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1540: FND_MSG_PUB.ADD;
1541: RAISE FND_API.G_EXC_ERROR;
1542: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1543: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1539: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1540: FND_MSG_PUB.ADD;
1541: RAISE FND_API.G_EXC_ERROR;
1542: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1543: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1544: FND_MSG_PUB.ADD;
1545: RAISE FND_API.G_EXC_ERROR;
1546: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1547: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1543: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1544: FND_MSG_PUB.ADD;
1545: RAISE FND_API.G_EXC_ERROR;
1546: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1547: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1548: FND_MSG_PUB.ADD;
1549: RAISE FND_API.G_EXC_ERROR;
1550: else
1551: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1547: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1548: FND_MSG_PUB.ADD;
1549: RAISE FND_API.G_EXC_ERROR;
1550: else
1551: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1552: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1553: FND_MSG_PUB.ADD;
1554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1555: end if;

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

1548: FND_MSG_PUB.ADD;
1549: RAISE FND_API.G_EXC_ERROR;
1550: else
1551: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1552: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1553: FND_MSG_PUB.ADD;
1554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1555: end if;
1556: END;

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

1682: output_long_strings('Restrict Sql = '||p_restrict_sql);
1683: exception
1684: when others then
1685: if (instrb(SQLERRM,'DRG-51030')>0) then
1686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1687: FND_MSG_PUB.ADD;
1688: RAISE FND_API.G_EXC_ERROR;
1689: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1690: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1687: FND_MSG_PUB.ADD;
1688: RAISE FND_API.G_EXC_ERROR;
1689: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1690: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1691: FND_MSG_PUB.ADD;
1692: RAISE FND_API.G_EXC_ERROR;
1693: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1694: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1690: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1691: FND_MSG_PUB.ADD;
1692: RAISE FND_API.G_EXC_ERROR;
1693: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1694: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1695: FND_MSG_PUB.ADD;
1696: RAISE FND_API.G_EXC_ERROR;
1697: else
1698: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1694: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1695: FND_MSG_PUB.ADD;
1696: RAISE FND_API.G_EXC_ERROR;
1697: else
1698: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1702: end if;

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

1695: FND_MSG_PUB.ADD;
1696: RAISE FND_API.G_EXC_ERROR;
1697: else
1698: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1702: end if;
1703: END;

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

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

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

1959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1960: FND_MSG_PUB.ADD;
1961: RAISE FND_API.G_EXC_ERROR;
1962: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1964: FND_MSG_PUB.ADD;
1965: RAISE FND_API.G_EXC_ERROR;
1966: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

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

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

1967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1968: FND_MSG_PUB.ADD;
1969: RAISE FND_API.G_EXC_ERROR;
1970: else
1971: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1973: FND_MSG_PUB.ADD;
1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1975: end if;

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

1968: FND_MSG_PUB.ADD;
1969: RAISE FND_API.G_EXC_ERROR;
1970: else
1971: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1973: FND_MSG_PUB.ADD;
1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1975: end if;
1976: END;

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

2216: IF p_index>1 THEN
2217: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2218: 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);
2219: END IF;
2220: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2221: FND_MSG_PUB.ADD;
2222: RAISE FND_API.G_EXC_ERROR;
2223: ELSE
2224: push_eval;

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

2264: IF p_index>1 THEN
2265: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2266: 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);
2267: END IF;
2268: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2269: FND_MSG_PUB.ADD;
2270: RAISE FND_API.G_EXC_ERROR;
2271: ELSE
2272: push_eval;

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

2337: IF p_index>1 THEN
2338: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2339: 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);
2340: END IF;
2341: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2342: FND_MSG_PUB.ADD;
2343: RAISE FND_API.G_EXC_ERROR;
2344: ELSE
2345: push_eval;

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

2449: IF p_index>1 THEN
2450: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2451: 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);
2452: END IF;
2453: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2454: FND_MSG_PUB.ADD;
2455: RAISE FND_API.G_EXC_ERROR;
2456: ELSE
2457: push_eval;

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

2560: IF p_index>1 THEN
2561: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2562: 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);
2563: END IF;
2564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2565: FND_MSG_PUB.ADD;
2566: RAISE FND_API.G_EXC_ERROR;
2567: ELSE
2568: push_eval;

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

2785: ELSE
2786: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2787: 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);
2788: END IF;
2789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2790: FND_MSG_PUB.ADD;
2791: RAISE FND_API.G_EXC_ERROR;
2792: END IF;
2793: ELSE

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

2793: ELSE
2794: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2795: 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);
2796: END IF;
2797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2798: FND_MSG_PUB.ADD;
2799: RAISE FND_API.G_EXC_ERROR;
2800: END IF;
2801: END IF;

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

2999: RAISE FND_API.G_EXC_ERROR;
3000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3002: WHEN OTHERS THEN
3003: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3004: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_parties');
3005: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3006: FND_MSG_PUB.ADD;
3007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3004: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_parties');

3000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3002: WHEN OTHERS THEN
3003: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3004: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_parties');
3005: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3006: FND_MSG_PUB.ADD;
3007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3008: END find_parties;

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

3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3002: WHEN OTHERS THEN
3003: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3004: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_parties');
3005: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3006: FND_MSG_PUB.ADD;
3007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3008: END find_parties;
3009:

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

3189: IF p_index>1 THEN
3190: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3191: 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);
3192: END IF;
3193: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3194: FND_MSG_PUB.ADD;
3195: RAISE FND_API.G_EXC_ERROR;
3196: ELSE
3197: push_eval;

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

3237: IF p_index>1 THEN
3238: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3239: 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);
3240: END IF;
3241: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3242: FND_MSG_PUB.ADD;
3243: RAISE FND_API.G_EXC_ERROR;
3244: ELSE
3245: push_eval;

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

3273: and d.search_context_id = p_search_ctx_id);
3274: exception
3275: when others then
3276: if (instrb(SQLERRM,'DRG-51030')>0) then
3277: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3278: FND_MSG_PUB.ADD;
3279: RAISE FND_API.G_EXC_ERROR;
3280: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3281: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3277: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3278: FND_MSG_PUB.ADD;
3279: RAISE FND_API.G_EXC_ERROR;
3280: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3281: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3282: FND_MSG_PUB.ADD;
3283: RAISE FND_API.G_EXC_ERROR;
3284: else
3285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3349: IF p_index>1 THEN
3350: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3351: 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);
3352: END IF;
3353: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3354: FND_MSG_PUB.ADD;
3355: RAISE FND_API.G_EXC_ERROR;
3356: ELSE
3357: push_eval;

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

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

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

3721: ELSE
3722: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3723: 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);
3724: END IF;
3725: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3726: FND_MSG_PUB.ADD;
3727: RAISE FND_API.G_EXC_ERROR;
3728: END IF;
3729: ELSE

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

3729: ELSE
3730: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3731: 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);
3732: END IF;
3733: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3734: FND_MSG_PUB.ADD;
3735: RAISE FND_API.G_EXC_ERROR;
3736: END IF;
3737: END IF;

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

3850: RAISE FND_API.G_EXC_ERROR;
3851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3853: WHEN OTHERS THEN
3854: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3855: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_persons');
3856: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3857: FND_MSG_PUB.ADD;
3858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3855: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_persons');

3851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3853: WHEN OTHERS THEN
3854: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3855: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_persons');
3856: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3857: FND_MSG_PUB.ADD;
3858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3859: END find_persons;

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

3852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3853: WHEN OTHERS THEN
3854: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3855: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_persons');
3856: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3857: FND_MSG_PUB.ADD;
3858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3859: END find_persons;
3860:

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

3918: RAISE FND_API.G_EXC_ERROR;
3919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3921: WHEN OTHERS THEN
3922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_party_details');
3924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3925: FND_MSG_PUB.ADD;
3926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_party_details');

3919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3921: WHEN OTHERS THEN
3922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_party_details');
3924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3925: FND_MSG_PUB.ADD;
3926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3927: END find_party_details;

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

3920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3921: WHEN OTHERS THEN
3922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_party_details');
3924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3925: FND_MSG_PUB.ADD;
3926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3927: END find_party_details;
3928:

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

4035: RAISE FND_API.G_EXC_ERROR;
4036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4038: WHEN OTHERS THEN
4039: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4040: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_parties');
4041: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4042: FND_MSG_PUB.ADD;
4043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4040: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_parties');

4036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4038: WHEN OTHERS THEN
4039: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4040: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_parties');
4041: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4042: FND_MSG_PUB.ADD;
4043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4044: END find_duplicate_parties;

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

4037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4038: WHEN OTHERS THEN
4039: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4040: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_parties');
4041: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4042: FND_MSG_PUB.ADD;
4043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4044: END find_duplicate_parties;
4045:

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

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

Line 4125: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_party_sites');

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

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

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

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

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

Line 4214: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.find_duplicate_contacts');

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

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

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

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_240.find_duplicate_contact_points');
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_240.find_duplicate_contact_points');

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_240.find_duplicate_contact_points');
4288: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4289: FND_MSG_PUB.ADD;
4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4291: END find_duplicate_contact_points;

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_240.find_duplicate_contact_points');
4288: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4289: FND_MSG_PUB.ADD;
4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4291: END find_duplicate_contact_points;
4292:

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

4583: RAISE FND_API.G_EXC_ERROR;
4584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4586: WHEN OTHERS THEN
4587: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4588: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.call_api_dynamic');
4589: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4590: FND_MSG_PUB.ADD;
4591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4588: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.call_api_dynamic');

4584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4586: WHEN OTHERS THEN
4587: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4588: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.call_api_dynamic');
4589: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4590: FND_MSG_PUB.ADD;
4591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4592: END call_api_dynamic;

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

4585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4586: WHEN OTHERS THEN
4587: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4588: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.call_api_dynamic');
4589: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4590: FND_MSG_PUB.ADD;
4591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4592: END call_api_dynamic;
4593:

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

4819: RAISE FND_API.G_EXC_ERROR;
4820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4822: WHEN OTHERS THEN
4823: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4824: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_party_sites');
4825: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4826: FND_MSG_PUB.ADD;
4827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4824: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_party_sites');

4820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4822: WHEN OTHERS THEN
4823: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4824: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_party_sites');
4825: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4826: FND_MSG_PUB.ADD;
4827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4828: END get_matching_party_sites;

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

4821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4822: WHEN OTHERS THEN
4823: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4824: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_party_sites');
4825: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4826: FND_MSG_PUB.ADD;
4827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4828: END get_matching_party_sites;
4829:

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

5046: RAISE FND_API.G_EXC_ERROR;
5047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5049: WHEN OTHERS THEN
5050: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5051: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_contacts');
5052: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5053: FND_MSG_PUB.ADD;
5054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5051: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_contacts');

5047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5049: WHEN OTHERS THEN
5050: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5051: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_contacts');
5052: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5053: FND_MSG_PUB.ADD;
5054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5055: END get_matching_contacts;

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

5048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5049: WHEN OTHERS THEN
5050: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5051: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_contacts');
5052: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5053: FND_MSG_PUB.ADD;
5054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5055: END get_matching_contacts;
5056:

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

5187: RAISE FND_API.G_EXC_ERROR;
5188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5190: WHEN OTHERS THEN
5191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5192: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_contact_points');
5193: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5194: FND_MSG_PUB.ADD;
5195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5192: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_contact_points');

5188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5190: WHEN OTHERS THEN
5191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5192: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_contact_points');
5193: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5194: FND_MSG_PUB.ADD;
5195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5196: END get_matching_contact_points;

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

5189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5190: WHEN OTHERS THEN
5191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5192: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_matching_contact_points');
5193: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5194: FND_MSG_PUB.ADD;
5195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5196: END get_matching_contact_points;
5197:

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

5388: RAISE FND_API.G_EXC_ERROR;
5389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5391: WHEN OTHERS THEN
5392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5393: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_score_details');
5394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5395: FND_MSG_PUB.ADD;
5396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5393: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_score_details');

5389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5391: WHEN OTHERS THEN
5392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5393: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_score_details');
5394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5395: FND_MSG_PUB.ADD;
5396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5397: END get_score_details;

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

5390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5391: WHEN OTHERS THEN
5392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5393: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_240.get_score_details');
5394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5395: FND_MSG_PUB.ADD;
5396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5397: END get_score_details;
5398:

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

5498: RAISE FND_API.G_EXC_ERROR;
5499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5501: WHEN OTHERS THEN
5502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5503: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5504: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5505: FND_MSG_PUB.ADD;
5506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5501: WHEN OTHERS THEN
5502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5503: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5504: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5505: FND_MSG_PUB.ADD;
5506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5507: END get_party_for_search;

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

5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5501: WHEN OTHERS THEN
5502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5503: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5504: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5505: FND_MSG_PUB.ADD;
5506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5507: END get_party_for_search;
5508:

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

5544: RAISE FND_API.G_EXC_ERROR;
5545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5547: WHEN OTHERS THEN
5548: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5549: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5550: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5551: FND_MSG_PUB.ADD;
5552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5547: WHEN OTHERS THEN
5548: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5549: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5550: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5551: FND_MSG_PUB.ADD;
5552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5553: END get_search_criteria;

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

5546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5547: WHEN OTHERS THEN
5548: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5549: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5550: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5551: FND_MSG_PUB.ADD;
5552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5553: END get_search_criteria;
5554:

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

5600: END IF;
5601:
5602: EXCEPTION
5603: WHEN OTHERS THEN
5604: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5605: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5606: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5608: FND_MSG_PUB.ADD;

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

5601:
5602: EXCEPTION
5603: WHEN OTHERS THEN
5604: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5605: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5606: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5608: FND_MSG_PUB.ADD;
5609: RAISE FND_API.G_EXC_ERROR;

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

5602: EXCEPTION
5603: WHEN OTHERS THEN
5604: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5605: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5606: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5608: FND_MSG_PUB.ADD;
5609: RAISE FND_API.G_EXC_ERROR;
5610: END get_party_rec;

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

5603: WHEN OTHERS THEN
5604: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5605: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5606: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5608: FND_MSG_PUB.ADD;
5609: RAISE FND_API.G_EXC_ERROR;
5610: END get_party_rec;
5611:

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

5656: END LOOP;
5657:
5658: EXCEPTION
5659: WHEN OTHERS THEN
5660: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5661: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5662: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5664: FND_MSG_PUB.ADD;

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

5657:
5658: EXCEPTION
5659: WHEN OTHERS THEN
5660: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5661: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5662: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5664: FND_MSG_PUB.ADD;
5665: RAISE FND_API.G_EXC_ERROR;

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

5658: EXCEPTION
5659: WHEN OTHERS THEN
5660: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5661: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5662: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5664: FND_MSG_PUB.ADD;
5665: RAISE FND_API.G_EXC_ERROR;
5666: END get_party_site_rec;

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

5659: WHEN OTHERS THEN
5660: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5661: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5662: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5664: FND_MSG_PUB.ADD;
5665: RAISE FND_API.G_EXC_ERROR;
5666: END get_party_site_rec;
5667:

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

5712: END LOOP;
5713:
5714: EXCEPTION
5715: WHEN OTHERS THEN
5716: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5717: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5718: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5719: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5720: FND_MSG_PUB.ADD;

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

5713:
5714: EXCEPTION
5715: WHEN OTHERS THEN
5716: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5717: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5718: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5719: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5720: FND_MSG_PUB.ADD;
5721: RAISE FND_API.G_EXC_ERROR;

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

5714: EXCEPTION
5715: WHEN OTHERS THEN
5716: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5717: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5718: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5719: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5720: FND_MSG_PUB.ADD;
5721: RAISE FND_API.G_EXC_ERROR;
5722: END get_contact_rec;

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

5715: WHEN OTHERS THEN
5716: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5717: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5718: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5719: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5720: FND_MSG_PUB.ADD;
5721: RAISE FND_API.G_EXC_ERROR;
5722: END get_contact_rec;
5723:

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

5768: END LOOP;
5769:
5770: EXCEPTION
5771: WHEN OTHERS THEN
5772: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5773: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5774: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5775: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5776: FND_MSG_PUB.ADD;

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

5769:
5770: EXCEPTION
5771: WHEN OTHERS THEN
5772: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5773: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5774: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5775: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5776: FND_MSG_PUB.ADD;
5777: RAISE FND_API.G_EXC_ERROR;

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

5770: EXCEPTION
5771: WHEN OTHERS THEN
5772: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5773: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5774: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5775: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5776: FND_MSG_PUB.ADD;
5777: RAISE FND_API.G_EXC_ERROR;
5778: END get_contact_point_rec;

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

5771: WHEN OTHERS THEN
5772: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5773: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5774: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5775: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5776: FND_MSG_PUB.ADD;
5777: RAISE FND_API.G_EXC_ERROR;
5778: END get_contact_point_rec;
5779:

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

5844: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
5845: END IF;
5846: EXCEPTION
5847: WHEN OTHERS THEN
5848: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5849: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5850: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5851: FND_MSG_PUB.ADD;
5852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5845: END IF;
5846: EXCEPTION
5847: WHEN OTHERS THEN
5848: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5849: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5850: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5851: FND_MSG_PUB.ADD;
5852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5853: END;

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

5846: EXCEPTION
5847: WHEN OTHERS THEN
5848: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5849: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5850: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5851: FND_MSG_PUB.ADD;
5852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5853: END;
5854:

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

5939: END IF;
5940: END LOOP;
5941: EXCEPTION
5942: WHEN OTHERS THEN
5943: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5944: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5945: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5946: FND_MSG_PUB.ADD;
5947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5940: END LOOP;
5941: EXCEPTION
5942: WHEN OTHERS THEN
5943: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5944: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5945: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5946: FND_MSG_PUB.ADD;
5947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5948: END;

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

5941: EXCEPTION
5942: WHEN OTHERS THEN
5943: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5944: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5945: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5946: FND_MSG_PUB.ADD;
5947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5948: END;
5949:

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

5981: END IF;
5982: NULL;
5983: EXCEPTION
5984: WHEN OTHERS THEN
5985: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5986: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5987: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5988: FND_MSG_PUB.ADD;
5989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5982: NULL;
5983: EXCEPTION
5984: WHEN OTHERS THEN
5985: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5986: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5987: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5988: FND_MSG_PUB.ADD;
5989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5990: END;

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

5983: EXCEPTION
5984: WHEN OTHERS THEN
5985: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5986: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5987: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5988: FND_MSG_PUB.ADD;
5989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5990: END;
5991:

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

6099: END IF;
6100: END LOOP;
6101: EXCEPTION
6102: WHEN OTHERS THEN
6103: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6104: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6105: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6106: FND_MSG_PUB.ADD;
6107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6100: END LOOP;
6101: EXCEPTION
6102: WHEN OTHERS THEN
6103: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6104: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6105: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6106: FND_MSG_PUB.ADD;
6107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6108: END;

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

6101: EXCEPTION
6102: WHEN OTHERS THEN
6103: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6104: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6105: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6106: FND_MSG_PUB.ADD;
6107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6108: END;
6109:

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

6126: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6127: p_contact_point_list(I).PHONE_NUMBER IS NOT NULL
6128: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6129: ) THEN
6130: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6131: FND_MSG_PUB.ADD;
6132: RAISE FND_API.G_EXC_ERROR;
6133: END IF;
6134: END LOOP;

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

6160: EXCEPTION
6161: WHEN FND_API.G_EXC_ERROR THEN
6162: RAISE FND_API.G_EXC_ERROR;
6163: WHEN OTHERS THEN
6164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6165: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6166: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6167: FND_MSG_PUB.ADD;
6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6161: WHEN FND_API.G_EXC_ERROR THEN
6162: RAISE FND_API.G_EXC_ERROR;
6163: WHEN OTHERS THEN
6164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6165: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6166: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6167: FND_MSG_PUB.ADD;
6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6169: END check_prim_cond;

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

6162: RAISE FND_API.G_EXC_ERROR;
6163: WHEN OTHERS THEN
6164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6165: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6166: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6167: FND_MSG_PUB.ADD;
6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6169: END check_prim_cond;
6170:

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

6216: EXIT WHEN x_secondary;
6217: END LOOP;
6218: EXCEPTION
6219: WHEN OTHERS THEN
6220: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6221: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6222: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6223: FND_MSG_PUB.ADD;
6224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6217: END LOOP;
6218: EXCEPTION
6219: WHEN OTHERS THEN
6220: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6221: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6222: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6223: FND_MSG_PUB.ADD;
6224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6225: END check_party_site_cond;

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

6218: EXCEPTION
6219: WHEN OTHERS THEN
6220: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6221: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6222: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6223: FND_MSG_PUB.ADD;
6224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6225: END check_party_site_cond;
6226:

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

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

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

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

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

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

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

6287: x_secondary:= FALSE;
6288:
6289: FOR I IN 1..p_contact_point_list.COUNT LOOP
6290: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6291: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6292: FND_MSG_PUB.ADD;
6293: RAISE FND_API.G_EXC_ERROR;
6294: END IF;
6295: END LOOP;

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

6311: EXIT WHEN x_secondary;
6312: END LOOP;
6313: EXCEPTION
6314: WHEN OTHERS THEN
6315: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6316: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6318: FND_MSG_PUB.ADD;
6319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6312: END LOOP;
6313: EXCEPTION
6314: WHEN OTHERS THEN
6315: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6316: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6318: FND_MSG_PUB.ADD;
6319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6320: END check_contact_point_cond;

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

6313: EXCEPTION
6314: WHEN OTHERS THEN
6315: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6316: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6318: FND_MSG_PUB.ADD;
6319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6320: END check_contact_point_cond;
6321: