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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3975: WHEN OTHERS THEN
3976: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3977: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_persons');
3978: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3979: FND_MSG_PUB.ADD;
3980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3981: END find_persons;
3982:

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

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

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

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

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

4042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4043: WHEN OTHERS THEN
4044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4045: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_party_details');
4046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4047: FND_MSG_PUB.ADD;
4048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4049: END find_party_details;
4050:

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

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

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

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

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

4159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4160: WHEN OTHERS THEN
4161: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4162: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_parties');
4163: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4164: FND_MSG_PUB.ADD;
4165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4166: END find_duplicate_parties;
4167:

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

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

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

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

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

4244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4245: WHEN OTHERS THEN
4246: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4247: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_party_sites');
4248: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4249: FND_MSG_PUB.ADD;
4250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4251: END find_duplicate_party_sites;
4252:

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

4331: RAISE FND_API.G_EXC_ERROR;
4332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4334: WHEN OTHERS THEN
4335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_contacts');
4337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4338: FND_MSG_PUB.ADD;
4339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_contacts');

4332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4334: WHEN OTHERS THEN
4335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_contacts');
4337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4338: FND_MSG_PUB.ADD;
4339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4340: END find_duplicate_contacts;

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

4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4334: WHEN OTHERS THEN
4335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.find_duplicate_contacts');
4337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4338: FND_MSG_PUB.ADD;
4339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4340: END find_duplicate_contacts;
4341:

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

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

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

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

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

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

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

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

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

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

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

4714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4715: WHEN OTHERS THEN
4716: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4717: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.call_api_dynamic');
4718: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4719: FND_MSG_PUB.ADD;
4720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4721: END call_api_dynamic;
4722:

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

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

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

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

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

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

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

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

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

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

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

5180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5181: WHEN OTHERS THEN
5182: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5183: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contacts');
5184: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5185: FND_MSG_PUB.ADD;
5186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5187: END get_matching_contacts;
5188:

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

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

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

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

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

5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5323: WHEN OTHERS THEN
5324: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5325: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_matching_contact_points');
5326: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5327: FND_MSG_PUB.ADD;
5328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5329: END get_matching_contact_points;
5330:

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

5533: RAISE FND_API.G_EXC_ERROR;
5534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5536: WHEN OTHERS THEN
5537: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5538: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_score_details');
5539: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5540: FND_MSG_PUB.ADD;
5541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5536: WHEN OTHERS THEN
5537: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5538: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_score_details');
5539: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5540: FND_MSG_PUB.ADD;
5541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5542: END get_score_details;

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

5535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5536: WHEN OTHERS THEN
5537: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5538: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_41.get_score_details');
5539: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5540: FND_MSG_PUB.ADD;
5541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5542: END get_score_details;
5543:

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

5643: RAISE FND_API.G_EXC_ERROR;
5644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5646: WHEN OTHERS THEN
5647: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5648: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5649: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5650: FND_MSG_PUB.ADD;
5651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5646: WHEN OTHERS THEN
5647: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5648: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5649: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5650: FND_MSG_PUB.ADD;
5651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5652: END get_party_for_search;

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

5645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5646: WHEN OTHERS THEN
5647: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5648: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5649: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5650: FND_MSG_PUB.ADD;
5651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5652: END get_party_for_search;
5653:

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

5689: RAISE FND_API.G_EXC_ERROR;
5690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5692: WHEN OTHERS THEN
5693: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5694: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5695: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5696: FND_MSG_PUB.ADD;
5697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5692: WHEN OTHERS THEN
5693: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5694: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5695: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5696: FND_MSG_PUB.ADD;
5697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5698: END get_search_criteria;

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

5691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5692: WHEN OTHERS THEN
5693: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5694: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5695: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5696: FND_MSG_PUB.ADD;
5697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5698: END get_search_criteria;
5699:

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

5749: END IF;
5750:
5751: EXCEPTION
5752: WHEN OTHERS THEN
5753: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5754: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5755: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5756: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5757: FND_MSG_PUB.ADD;

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

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

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

5751: EXCEPTION
5752: WHEN OTHERS THEN
5753: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5754: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5755: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5756: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5757: FND_MSG_PUB.ADD;
5758: RAISE FND_API.G_EXC_ERROR;
5759: END get_party_rec;

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

5752: WHEN OTHERS THEN
5753: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5754: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5755: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5756: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5757: FND_MSG_PUB.ADD;
5758: RAISE FND_API.G_EXC_ERROR;
5759: END get_party_rec;
5760:

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

5805: END LOOP;
5806:
5807: EXCEPTION
5808: WHEN OTHERS THEN
5809: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5810: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5811: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5812: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5813: FND_MSG_PUB.ADD;

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

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

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

5807: EXCEPTION
5808: WHEN OTHERS THEN
5809: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5810: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5811: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5812: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5813: FND_MSG_PUB.ADD;
5814: RAISE FND_API.G_EXC_ERROR;
5815: END get_party_site_rec;

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

5808: WHEN OTHERS THEN
5809: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5810: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5811: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5812: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5813: FND_MSG_PUB.ADD;
5814: RAISE FND_API.G_EXC_ERROR;
5815: END get_party_site_rec;
5816:

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

5861: END LOOP;
5862:
5863: EXCEPTION
5864: WHEN OTHERS THEN
5865: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5866: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5867: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5869: FND_MSG_PUB.ADD;

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

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

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

5863: EXCEPTION
5864: WHEN OTHERS THEN
5865: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5866: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5867: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5869: FND_MSG_PUB.ADD;
5870: RAISE FND_API.G_EXC_ERROR;
5871: END get_contact_rec;

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

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

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

5917: END LOOP;
5918:
5919: EXCEPTION
5920: WHEN OTHERS THEN
5921: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5922: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5923: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5925: FND_MSG_PUB.ADD;

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

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

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

5919: EXCEPTION
5920: WHEN OTHERS THEN
5921: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5922: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5923: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5925: FND_MSG_PUB.ADD;
5926: RAISE FND_API.G_EXC_ERROR;
5927: END get_contact_point_rec;

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

5920: WHEN OTHERS THEN
5921: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5922: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5923: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5925: FND_MSG_PUB.ADD;
5926: RAISE FND_API.G_EXC_ERROR;
5927: END get_contact_point_rec;
5928:

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

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

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

6033: END IF;
6034: EXCEPTION
6035: WHEN OTHERS THEN
6036: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6037: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6038: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6039: FND_MSG_PUB.ADD;
6040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6041: END;

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

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

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

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

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

6151: END LOOP;
6152: EXCEPTION
6153: WHEN OTHERS THEN
6154: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6155: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6156: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6157: FND_MSG_PUB.ADD;
6158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6159: END;

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

6152: EXCEPTION
6153: WHEN OTHERS THEN
6154: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6155: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6156: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6157: FND_MSG_PUB.ADD;
6158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6159: END;
6160:

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

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

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

6193: NULL;
6194: EXCEPTION
6195: WHEN OTHERS THEN
6196: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6197: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6198: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6199: FND_MSG_PUB.ADD;
6200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6201: END;

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

6194: EXCEPTION
6195: WHEN OTHERS THEN
6196: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6197: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6198: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6199: FND_MSG_PUB.ADD;
6200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6201: END;
6202:

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

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

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

6324: END LOOP;
6325: EXCEPTION
6326: WHEN OTHERS THEN
6327: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6328: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6329: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6330: FND_MSG_PUB.ADD;
6331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6332: END;

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

6325: EXCEPTION
6326: WHEN OTHERS THEN
6327: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6328: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6329: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6330: FND_MSG_PUB.ADD;
6331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6332: END;
6333:

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

6349: FOR I IN 1..p_contact_point_list.COUNT LOOP
6350: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6351: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6352: ) THEN
6353: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6354: FND_MSG_PUB.ADD;
6355: RAISE FND_API.G_EXC_ERROR;
6356: END IF;
6357: END LOOP;

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

6381: EXCEPTION
6382: WHEN FND_API.G_EXC_ERROR THEN
6383: RAISE FND_API.G_EXC_ERROR;
6384: WHEN OTHERS THEN
6385: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6386: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6387: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6388: FND_MSG_PUB.ADD;
6389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6382: WHEN FND_API.G_EXC_ERROR THEN
6383: RAISE FND_API.G_EXC_ERROR;
6384: WHEN OTHERS THEN
6385: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6386: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6387: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6388: FND_MSG_PUB.ADD;
6389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6390: END check_prim_cond;

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

6383: RAISE FND_API.G_EXC_ERROR;
6384: WHEN OTHERS THEN
6385: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6386: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6387: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6388: FND_MSG_PUB.ADD;
6389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6390: END check_prim_cond;
6391:

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

6436: EXIT WHEN x_secondary;
6437: END LOOP;
6438: EXCEPTION
6439: WHEN OTHERS THEN
6440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6441: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6442: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6443: FND_MSG_PUB.ADD;
6444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6437: END LOOP;
6438: EXCEPTION
6439: WHEN OTHERS THEN
6440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6441: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6442: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6443: FND_MSG_PUB.ADD;
6444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6445: END check_party_site_cond;

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

6438: EXCEPTION
6439: WHEN OTHERS THEN
6440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6441: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6442: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6443: FND_MSG_PUB.ADD;
6444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6445: END check_party_site_cond;
6446:

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

6483: EXIT WHEN x_secondary;
6484: END LOOP;
6485: EXCEPTION
6486: WHEN OTHERS THEN
6487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6488: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6490: FND_MSG_PUB.ADD;
6491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6484: END LOOP;
6485: EXCEPTION
6486: WHEN OTHERS THEN
6487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6488: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6490: FND_MSG_PUB.ADD;
6491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6492: END check_contact_cond;

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

6485: EXCEPTION
6486: WHEN OTHERS THEN
6487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6488: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6490: FND_MSG_PUB.ADD;
6491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6492: END check_contact_cond;
6493:

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

6506: x_secondary:= FALSE;
6507:
6508: FOR I IN 1..p_contact_point_list.COUNT LOOP
6509: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6510: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6511: FND_MSG_PUB.ADD;
6512: RAISE FND_API.G_EXC_ERROR;
6513: END IF;
6514: END LOOP;

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

6529: EXIT WHEN x_secondary;
6530: END LOOP;
6531: EXCEPTION
6532: WHEN OTHERS THEN
6533: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6534: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6536: FND_MSG_PUB.ADD;
6537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6530: END LOOP;
6531: EXCEPTION
6532: WHEN OTHERS THEN
6533: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6534: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6536: FND_MSG_PUB.ADD;
6537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6538: END check_contact_point_cond;

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

6531: EXCEPTION
6532: WHEN OTHERS THEN
6533: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6534: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6536: FND_MSG_PUB.ADD;
6537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6538: END check_contact_point_cond;
6539: