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

659: BEGIN
660: NULL ;
661: EXCEPTION
662: WHEN OTHERS THEN
663: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
664: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
665: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
666: FND_MSG_PUB.ADD;
667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

660: NULL ;
661: EXCEPTION
662: WHEN OTHERS THEN
663: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
664: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
665: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
666: FND_MSG_PUB.ADD;
667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
668: END;

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

661: EXCEPTION
662: WHEN OTHERS THEN
663: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
664: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
665: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
666: FND_MSG_PUB.ADD;
667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
668: END;
669:

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

679: BEGIN
680: NULL ;
681: EXCEPTION
682: WHEN OTHERS THEN
683: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
684: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
685: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
686: FND_MSG_PUB.ADD;
687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

680: NULL ;
681: EXCEPTION
682: WHEN OTHERS THEN
683: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
684: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
685: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
686: FND_MSG_PUB.ADD;
687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
688: END;

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

681: EXCEPTION
682: WHEN OTHERS THEN
683: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
684: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
685: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
686: FND_MSG_PUB.ADD;
687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
688: END;
689:

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

699: BEGIN
700: NULL ;
701: EXCEPTION
702: WHEN OTHERS THEN
703: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
704: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
705: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
706: FND_MSG_PUB.ADD;
707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

700: NULL ;
701: EXCEPTION
702: WHEN OTHERS THEN
703: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
704: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
705: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
706: FND_MSG_PUB.ADD;
707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
708: END;

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

701: EXCEPTION
702: WHEN OTHERS THEN
703: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
704: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
705: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
706: FND_MSG_PUB.ADD;
707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
708: END;
709:

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

719: BEGIN
720: NULL ;
721: EXCEPTION
722: WHEN OTHERS THEN
723: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
724: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
726: FND_MSG_PUB.ADD;
727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

720: NULL ;
721: EXCEPTION
722: WHEN OTHERS THEN
723: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
724: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
726: FND_MSG_PUB.ADD;
727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
728: END;

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

721: EXCEPTION
722: WHEN OTHERS THEN
723: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
724: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
726: FND_MSG_PUB.ADD;
727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
728: END;
729:

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

788: IF NOT check_prim_cond (p_party_search_rec,
789: p_party_site_list,
790: p_contact_list,
791: p_contact_point_list) THEN
792: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
793: FND_MSG_PUB.ADD;
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1022: ELSE
1023: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1024: END IF;
1025: IF lengthb(l_party_contains_str) > 4000 THEN
1026: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1027: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1028: FND_MSG_PUB.ADD;
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;

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

1023: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1024: END IF;
1025: IF lengthb(l_party_contains_str) > 4000 THEN
1026: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1027: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1028: FND_MSG_PUB.ADD;
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031: IF (p_match_str = ' AND ' OR p_party_max_score

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

1091: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1092: END LOOP;
1093: -- Add the search criteria to query string
1094: IF lengthb(l_contains_str) > 4000 THEN
1095: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1096: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1097: FND_MSG_PUB.ADD;
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;

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

1092: END LOOP;
1093: -- Add the search criteria to query string
1094: IF lengthb(l_contains_str) > 4000 THEN
1095: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1096: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1097: FND_MSG_PUB.ADD;
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100: x_denorm_str := l_den_contains_str;

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

1181: END IF;
1182: END LOOP;
1183: -- Add the search criteria to query string
1184: IF lengthb(l_contains_str) > 4000 THEN
1185: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1186: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1187: FND_MSG_PUB.ADD;
1188: RAISE FND_API.G_EXC_ERROR;
1189: END IF;

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

1182: END LOOP;
1183: -- Add the search criteria to query string
1184: IF lengthb(l_contains_str) > 4000 THEN
1185: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1186: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1187: FND_MSG_PUB.ADD;
1188: RAISE FND_API.G_EXC_ERROR;
1189: END IF;
1190: x_denorm_str := l_den_contains_str;

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

1400: END IF;
1401: exception
1402: when others then
1403: if (instrb(SQLERRM,'DRG-51030')>0) then
1404: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1405: FND_MSG_PUB.ADD;
1406: RAISE FND_API.G_EXC_ERROR;
1407: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1404: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1405: FND_MSG_PUB.ADD;
1406: RAISE FND_API.G_EXC_ERROR;
1407: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1409: FND_MSG_PUB.ADD;
1410: RAISE FND_API.G_EXC_ERROR;
1411: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1409: FND_MSG_PUB.ADD;
1410: RAISE FND_API.G_EXC_ERROR;
1411: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1413: FND_MSG_PUB.ADD;
1414: RAISE FND_API.G_EXC_ERROR;
1415: else
1416: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1413: FND_MSG_PUB.ADD;
1414: RAISE FND_API.G_EXC_ERROR;
1415: else
1416: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1418: FND_MSG_PUB.ADD;
1419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1420: end if;

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

1413: FND_MSG_PUB.ADD;
1414: RAISE FND_API.G_EXC_ERROR;
1415: else
1416: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1418: FND_MSG_PUB.ADD;
1419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1420: end if;
1421: END;

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

1645: output_long_strings('Restrict Sql = '||p_restrict_sql);
1646: exception
1647: when others then
1648: if (instrb(SQLERRM,'DRG-51030')>0) then
1649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1650: FND_MSG_PUB.ADD;
1651: RAISE FND_API.G_EXC_ERROR;
1652: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1650: FND_MSG_PUB.ADD;
1651: RAISE FND_API.G_EXC_ERROR;
1652: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1654: FND_MSG_PUB.ADD;
1655: RAISE FND_API.G_EXC_ERROR;
1656: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1657: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1654: FND_MSG_PUB.ADD;
1655: RAISE FND_API.G_EXC_ERROR;
1656: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1657: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1658: FND_MSG_PUB.ADD;
1659: RAISE FND_API.G_EXC_ERROR;
1660: else
1661: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1657: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1658: FND_MSG_PUB.ADD;
1659: RAISE FND_API.G_EXC_ERROR;
1660: else
1661: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1662: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1663: FND_MSG_PUB.ADD;
1664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1665: end if;

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

1658: FND_MSG_PUB.ADD;
1659: RAISE FND_API.G_EXC_ERROR;
1660: else
1661: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1662: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1663: FND_MSG_PUB.ADD;
1664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1665: end if;
1666: END;

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

1792: output_long_strings('Restrict Sql = '||p_restrict_sql);
1793: exception
1794: when others then
1795: if (instrb(SQLERRM,'DRG-51030')>0) then
1796: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1797: FND_MSG_PUB.ADD;
1798: RAISE FND_API.G_EXC_ERROR;
1799: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1800: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1796: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1797: FND_MSG_PUB.ADD;
1798: RAISE FND_API.G_EXC_ERROR;
1799: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1800: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1801: FND_MSG_PUB.ADD;
1802: RAISE FND_API.G_EXC_ERROR;
1803: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1800: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1801: FND_MSG_PUB.ADD;
1802: RAISE FND_API.G_EXC_ERROR;
1803: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1805: FND_MSG_PUB.ADD;
1806: RAISE FND_API.G_EXC_ERROR;
1807: else
1808: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1805: FND_MSG_PUB.ADD;
1806: RAISE FND_API.G_EXC_ERROR;
1807: else
1808: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1809: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1810: FND_MSG_PUB.ADD;
1811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1812: end if;

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

1805: FND_MSG_PUB.ADD;
1806: RAISE FND_API.G_EXC_ERROR;
1807: else
1808: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1809: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1810: FND_MSG_PUB.ADD;
1811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1812: end if;
1813: END;

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

2065: output_long_strings('Restrict Sql = '||p_restrict_sql);
2066: exception
2067: when others then
2068: if (instrb(SQLERRM,'DRG-51030')>0) then
2069: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2070: FND_MSG_PUB.ADD;
2071: RAISE FND_API.G_EXC_ERROR;
2072: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2073: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2069: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2070: FND_MSG_PUB.ADD;
2071: RAISE FND_API.G_EXC_ERROR;
2072: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2073: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2074: FND_MSG_PUB.ADD;
2075: RAISE FND_API.G_EXC_ERROR;
2076: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2077: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2073: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2074: FND_MSG_PUB.ADD;
2075: RAISE FND_API.G_EXC_ERROR;
2076: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2077: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2078: FND_MSG_PUB.ADD;
2079: RAISE FND_API.G_EXC_ERROR;
2080: else
2081: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2077: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2078: FND_MSG_PUB.ADD;
2079: RAISE FND_API.G_EXC_ERROR;
2080: else
2081: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2082: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2083: FND_MSG_PUB.ADD;
2084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2085: end if;

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

2078: FND_MSG_PUB.ADD;
2079: RAISE FND_API.G_EXC_ERROR;
2080: else
2081: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2082: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2083: FND_MSG_PUB.ADD;
2084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2085: end if;
2086: END;

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

2330: IF p_index>1 THEN
2331: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2332: 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);
2333: END IF;
2334: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2335: FND_MSG_PUB.ADD;
2336: RAISE FND_API.G_EXC_ERROR;
2337: ELSE
2338: push_eval;

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

2378: IF p_index>1 THEN
2379: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2380: 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);
2381: END IF;
2382: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2383: FND_MSG_PUB.ADD;
2384: RAISE FND_API.G_EXC_ERROR;
2385: ELSE
2386: push_eval;

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

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

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

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

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

2674: IF p_index>1 THEN
2675: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2676: 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);
2677: END IF;
2678: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2679: FND_MSG_PUB.ADD;
2680: RAISE FND_API.G_EXC_ERROR;
2681: ELSE
2682: push_eval;

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

2899: ELSE
2900: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2901: 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);
2902: END IF;
2903: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2904: FND_MSG_PUB.ADD;
2905: RAISE FND_API.G_EXC_ERROR;
2906: END IF;
2907: ELSE

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

2907: ELSE
2908: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2909: 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);
2910: END IF;
2911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2912: FND_MSG_PUB.ADD;
2913: RAISE FND_API.G_EXC_ERROR;
2914: END IF;
2915: END IF;

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

3113: RAISE FND_API.G_EXC_ERROR;
3114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3116: WHEN OTHERS THEN
3117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_parties');
3119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3120: FND_MSG_PUB.ADD;
3121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_parties');

3114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3116: WHEN OTHERS THEN
3117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_parties');
3119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3120: FND_MSG_PUB.ADD;
3121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3122: END find_parties;

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

3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3116: WHEN OTHERS THEN
3117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_parties');
3119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3120: FND_MSG_PUB.ADD;
3121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3122: END find_parties;
3123:

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

3307: IF p_index>1 THEN
3308: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3309: 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);
3310: END IF;
3311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3312: FND_MSG_PUB.ADD;
3313: RAISE FND_API.G_EXC_ERROR;
3314: ELSE
3315: push_eval;

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

3355: IF p_index>1 THEN
3356: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3357: 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);
3358: END IF;
3359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3360: FND_MSG_PUB.ADD;
3361: RAISE FND_API.G_EXC_ERROR;
3362: ELSE
3363: push_eval;

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

3391: and d.search_context_id = p_search_ctx_id);
3392: exception
3393: when others then
3394: if (instrb(SQLERRM,'DRG-51030')>0) then
3395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3396: FND_MSG_PUB.ADD;
3397: RAISE FND_API.G_EXC_ERROR;
3398: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3399: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3396: FND_MSG_PUB.ADD;
3397: RAISE FND_API.G_EXC_ERROR;
3398: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3399: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3400: FND_MSG_PUB.ADD;
3401: RAISE FND_API.G_EXC_ERROR;
3402: else
3403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3467: IF p_index>1 THEN
3468: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3469: 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);
3470: END IF;
3471: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3472: FND_MSG_PUB.ADD;
3473: RAISE FND_API.G_EXC_ERROR;
3474: ELSE
3475: push_eval;

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

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

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

3839: ELSE
3840: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3841: 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);
3842: END IF;
3843: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3844: FND_MSG_PUB.ADD;
3845: RAISE FND_API.G_EXC_ERROR;
3846: END IF;
3847: ELSE

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

3847: ELSE
3848: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3849: 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);
3850: END IF;
3851: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3852: FND_MSG_PUB.ADD;
3853: RAISE FND_API.G_EXC_ERROR;
3854: END IF;
3855: END IF;

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

3968: RAISE FND_API.G_EXC_ERROR;
3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN
3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_persons');
3974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3975: FND_MSG_PUB.ADD;
3976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_persons');

3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN
3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_persons');
3974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3975: FND_MSG_PUB.ADD;
3976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3977: END find_persons;

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

3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN
3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_persons');
3974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3975: FND_MSG_PUB.ADD;
3976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3977: END find_persons;
3978:

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

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

Line 4041: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_party_details');

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

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

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

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

4153: RAISE FND_API.G_EXC_ERROR;
4154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4156: WHEN OTHERS THEN
4157: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4158: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_parties');
4159: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4160: FND_MSG_PUB.ADD;
4161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4158: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_parties');

4154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4156: WHEN OTHERS THEN
4157: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4158: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_parties');
4159: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4160: FND_MSG_PUB.ADD;
4161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4162: END find_duplicate_parties;

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

4155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4156: WHEN OTHERS THEN
4157: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4158: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_parties');
4159: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4160: FND_MSG_PUB.ADD;
4161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4162: END find_duplicate_parties;
4163:

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

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

Line 4243: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_party_sites');

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

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

4240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4241: WHEN OTHERS THEN
4242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4243: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_party_sites');
4244: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4245: FND_MSG_PUB.ADD;
4246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4247: END find_duplicate_party_sites;
4248:

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_41.find_duplicate_contacts');
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_41.find_duplicate_contacts');

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_41.find_duplicate_contacts');
4333: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4334: FND_MSG_PUB.ADD;
4335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4336: END find_duplicate_contacts;

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_41.find_duplicate_contacts');
4333: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4334: FND_MSG_PUB.ADD;
4335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4336: END find_duplicate_contacts;
4337:

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

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

Line 4405: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_contact_points');

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

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

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

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

4708: RAISE FND_API.G_EXC_ERROR;
4709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4711: WHEN OTHERS THEN
4712: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4713: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.call_api_dynamic');
4714: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4715: FND_MSG_PUB.ADD;
4716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4713: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.call_api_dynamic');

4709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4711: WHEN OTHERS THEN
4712: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4713: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.call_api_dynamic');
4714: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4715: FND_MSG_PUB.ADD;
4716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4717: END call_api_dynamic;

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

4710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4711: WHEN OTHERS THEN
4712: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4713: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.call_api_dynamic');
4714: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4715: FND_MSG_PUB.ADD;
4716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4717: END call_api_dynamic;
4718:

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

4946: RAISE FND_API.G_EXC_ERROR;
4947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4949: WHEN OTHERS THEN
4950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4951: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_party_sites');
4952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4953: FND_MSG_PUB.ADD;
4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4951: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_party_sites');

4947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4949: WHEN OTHERS THEN
4950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4951: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_party_sites');
4952: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4953: FND_MSG_PUB.ADD;
4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4955: END get_matching_party_sites;

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

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

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

5174: RAISE FND_API.G_EXC_ERROR;
5175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5177: WHEN OTHERS THEN
5178: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5179: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contacts');
5180: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5181: FND_MSG_PUB.ADD;
5182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5179: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contacts');

5175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5177: WHEN OTHERS THEN
5178: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5179: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contacts');
5180: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5181: FND_MSG_PUB.ADD;
5182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5183: END get_matching_contacts;

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

5176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5177: WHEN OTHERS THEN
5178: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5179: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contacts');
5180: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5181: FND_MSG_PUB.ADD;
5182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5183: END get_matching_contacts;
5184:

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

5316: RAISE FND_API.G_EXC_ERROR;
5317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5319: WHEN OTHERS THEN
5320: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5321: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contact_points');
5322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5323: FND_MSG_PUB.ADD;
5324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5321: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contact_points');

5317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5319: WHEN OTHERS THEN
5320: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5321: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contact_points');
5322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5323: FND_MSG_PUB.ADD;
5324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5325: END get_matching_contact_points;

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

5318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5319: WHEN OTHERS THEN
5320: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5321: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contact_points');
5322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5323: FND_MSG_PUB.ADD;
5324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5325: END get_matching_contact_points;
5326:

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

5528: RAISE FND_API.G_EXC_ERROR;
5529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5531: WHEN OTHERS THEN
5532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5533: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_score_details');
5534: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5535: FND_MSG_PUB.ADD;
5536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5533: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_score_details');

5529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5531: WHEN OTHERS THEN
5532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5533: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_score_details');
5534: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5535: FND_MSG_PUB.ADD;
5536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5537: END get_score_details;

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

5530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5531: WHEN OTHERS THEN
5532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5533: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_score_details');
5534: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5535: FND_MSG_PUB.ADD;
5536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5537: END get_score_details;
5538:

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

5638: RAISE FND_API.G_EXC_ERROR;
5639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5641: WHEN OTHERS THEN
5642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5643: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5644: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5645: FND_MSG_PUB.ADD;
5646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5641: WHEN OTHERS THEN
5642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5643: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5644: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5645: FND_MSG_PUB.ADD;
5646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5647: END get_party_for_search;

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

5640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5641: WHEN OTHERS THEN
5642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5643: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5644: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5645: FND_MSG_PUB.ADD;
5646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5647: END get_party_for_search;
5648:

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

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

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

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

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

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

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

5744: END IF;
5745:
5746: EXCEPTION
5747: WHEN OTHERS THEN
5748: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5749: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5750: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5751: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5752: FND_MSG_PUB.ADD;

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

5745:
5746: EXCEPTION
5747: WHEN OTHERS THEN
5748: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5749: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5750: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5751: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5752: FND_MSG_PUB.ADD;
5753: RAISE FND_API.G_EXC_ERROR;

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

5746: EXCEPTION
5747: WHEN OTHERS THEN
5748: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5749: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5750: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5751: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5752: FND_MSG_PUB.ADD;
5753: RAISE FND_API.G_EXC_ERROR;
5754: END get_party_rec;

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

5747: WHEN OTHERS THEN
5748: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5749: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5750: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5751: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5752: FND_MSG_PUB.ADD;
5753: RAISE FND_API.G_EXC_ERROR;
5754: END get_party_rec;
5755:

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

5800: END LOOP;
5801:
5802: EXCEPTION
5803: WHEN OTHERS THEN
5804: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5805: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5806: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5807: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5808: FND_MSG_PUB.ADD;

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

5801:
5802: EXCEPTION
5803: WHEN OTHERS THEN
5804: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5805: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5806: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5807: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5808: FND_MSG_PUB.ADD;
5809: RAISE FND_API.G_EXC_ERROR;

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

5802: EXCEPTION
5803: WHEN OTHERS THEN
5804: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5805: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5806: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5807: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5808: FND_MSG_PUB.ADD;
5809: RAISE FND_API.G_EXC_ERROR;
5810: END get_party_site_rec;

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

5803: WHEN OTHERS THEN
5804: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5805: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5806: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5807: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5808: FND_MSG_PUB.ADD;
5809: RAISE FND_API.G_EXC_ERROR;
5810: END get_party_site_rec;
5811:

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

5856: END LOOP;
5857:
5858: EXCEPTION
5859: WHEN OTHERS THEN
5860: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5861: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5862: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5864: FND_MSG_PUB.ADD;

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

5857:
5858: EXCEPTION
5859: WHEN OTHERS THEN
5860: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5861: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5862: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5864: FND_MSG_PUB.ADD;
5865: RAISE FND_API.G_EXC_ERROR;

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

5858: EXCEPTION
5859: WHEN OTHERS THEN
5860: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5861: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5862: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5864: FND_MSG_PUB.ADD;
5865: RAISE FND_API.G_EXC_ERROR;
5866: END get_contact_rec;

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

5859: WHEN OTHERS THEN
5860: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5861: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5862: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5864: FND_MSG_PUB.ADD;
5865: RAISE FND_API.G_EXC_ERROR;
5866: END get_contact_rec;
5867:

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

5912: END LOOP;
5913:
5914: EXCEPTION
5915: WHEN OTHERS THEN
5916: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5917: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5918: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5919: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5920: FND_MSG_PUB.ADD;

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

5913:
5914: EXCEPTION
5915: WHEN OTHERS THEN
5916: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5917: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5918: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5919: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5920: FND_MSG_PUB.ADD;
5921: RAISE FND_API.G_EXC_ERROR;

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

5914: EXCEPTION
5915: WHEN OTHERS THEN
5916: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5917: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5918: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5919: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5920: FND_MSG_PUB.ADD;
5921: RAISE FND_API.G_EXC_ERROR;
5922: END get_contact_point_rec;

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

5915: WHEN OTHERS THEN
5916: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5917: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5918: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5919: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5920: FND_MSG_PUB.ADD;
5921: RAISE FND_API.G_EXC_ERROR;
5922: END get_contact_point_rec;
5923:

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

6027: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6028: END IF;
6029: EXCEPTION
6030: WHEN OTHERS THEN
6031: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6032: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6034: FND_MSG_PUB.ADD;
6035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6028: END IF;
6029: EXCEPTION
6030: WHEN OTHERS THEN
6031: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6032: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6034: FND_MSG_PUB.ADD;
6035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6036: END;

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

6029: EXCEPTION
6030: WHEN OTHERS THEN
6031: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6032: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6034: FND_MSG_PUB.ADD;
6035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6036: END;
6037:

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

6145: END IF;
6146: END LOOP;
6147: EXCEPTION
6148: WHEN OTHERS THEN
6149: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6150: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6151: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6152: FND_MSG_PUB.ADD;
6153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6146: END LOOP;
6147: EXCEPTION
6148: WHEN OTHERS THEN
6149: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6150: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6151: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6152: FND_MSG_PUB.ADD;
6153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6154: END;

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

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

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

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

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

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

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

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

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

6318: END IF;
6319: END LOOP;
6320: EXCEPTION
6321: WHEN OTHERS THEN
6322: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6323: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6324: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6325: FND_MSG_PUB.ADD;
6326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6319: END LOOP;
6320: EXCEPTION
6321: WHEN OTHERS THEN
6322: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6323: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6324: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6325: FND_MSG_PUB.ADD;
6326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6327: END;

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

6320: EXCEPTION
6321: WHEN OTHERS THEN
6322: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6323: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6324: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6325: FND_MSG_PUB.ADD;
6326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6327: END;
6328:

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

6344: FOR I IN 1..p_contact_point_list.COUNT LOOP
6345: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6346: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6347: ) THEN
6348: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6349: FND_MSG_PUB.ADD;
6350: RAISE FND_API.G_EXC_ERROR;
6351: END IF;
6352: END LOOP;

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

6376: EXCEPTION
6377: WHEN FND_API.G_EXC_ERROR THEN
6378: RAISE FND_API.G_EXC_ERROR;
6379: WHEN OTHERS THEN
6380: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6381: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6382: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6383: FND_MSG_PUB.ADD;
6384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6377: WHEN FND_API.G_EXC_ERROR THEN
6378: RAISE FND_API.G_EXC_ERROR;
6379: WHEN OTHERS THEN
6380: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6381: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6382: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6383: FND_MSG_PUB.ADD;
6384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6385: END check_prim_cond;

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

6378: RAISE FND_API.G_EXC_ERROR;
6379: WHEN OTHERS THEN
6380: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6381: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6382: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6383: FND_MSG_PUB.ADD;
6384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6385: END check_prim_cond;
6386:

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

6431: EXIT WHEN x_secondary;
6432: END LOOP;
6433: EXCEPTION
6434: WHEN OTHERS THEN
6435: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6436: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6437: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6438: FND_MSG_PUB.ADD;
6439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6432: END LOOP;
6433: EXCEPTION
6434: WHEN OTHERS THEN
6435: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6436: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6437: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6438: FND_MSG_PUB.ADD;
6439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6440: END check_party_site_cond;

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

6433: EXCEPTION
6434: WHEN OTHERS THEN
6435: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6436: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6437: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6438: FND_MSG_PUB.ADD;
6439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6440: END check_party_site_cond;
6441:

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

6478: EXIT WHEN x_secondary;
6479: END LOOP;
6480: EXCEPTION
6481: WHEN OTHERS THEN
6482: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6483: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6484: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6485: FND_MSG_PUB.ADD;
6486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6479: END LOOP;
6480: EXCEPTION
6481: WHEN OTHERS THEN
6482: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6483: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6484: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6485: FND_MSG_PUB.ADD;
6486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6487: END check_contact_cond;

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

6480: EXCEPTION
6481: WHEN OTHERS THEN
6482: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6483: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6484: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6485: FND_MSG_PUB.ADD;
6486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6487: END check_contact_cond;
6488:

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

6501: x_secondary:= FALSE;
6502:
6503: FOR I IN 1..p_contact_point_list.COUNT LOOP
6504: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6505: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6506: FND_MSG_PUB.ADD;
6507: RAISE FND_API.G_EXC_ERROR;
6508: END IF;
6509: END LOOP;

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

6524: EXIT WHEN x_secondary;
6525: END LOOP;
6526: EXCEPTION
6527: WHEN OTHERS THEN
6528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6529: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6530: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6531: FND_MSG_PUB.ADD;
6532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6525: END LOOP;
6526: EXCEPTION
6527: WHEN OTHERS THEN
6528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6529: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6530: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6531: FND_MSG_PUB.ADD;
6532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6533: END check_contact_point_cond;

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

6526: EXCEPTION
6527: WHEN OTHERS THEN
6528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6529: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6530: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6531: FND_MSG_PUB.ADD;
6532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6533: END check_contact_point_cond;
6534: