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

630: BEGIN
631: NULL ;
632: EXCEPTION
633: WHEN OTHERS THEN
634: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
635: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
636: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
637: FND_MSG_PUB.ADD;
638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

631: NULL ;
632: EXCEPTION
633: WHEN OTHERS THEN
634: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
635: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
636: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
637: FND_MSG_PUB.ADD;
638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
639: END;

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

632: EXCEPTION
633: WHEN OTHERS THEN
634: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
635: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
636: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
637: FND_MSG_PUB.ADD;
638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
639: END;
640:

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

650: BEGIN
651: NULL ;
652: EXCEPTION
653: WHEN OTHERS THEN
654: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
655: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
656: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
657: FND_MSG_PUB.ADD;
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

651: NULL ;
652: EXCEPTION
653: WHEN OTHERS THEN
654: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
655: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
656: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
657: FND_MSG_PUB.ADD;
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END;

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

652: EXCEPTION
653: WHEN OTHERS THEN
654: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
655: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
656: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
657: FND_MSG_PUB.ADD;
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END;
660:

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

670: BEGIN
671: NULL ;
672: EXCEPTION
673: WHEN OTHERS THEN
674: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
675: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
676: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
677: FND_MSG_PUB.ADD;
678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

671: NULL ;
672: EXCEPTION
673: WHEN OTHERS THEN
674: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
675: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
676: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
677: FND_MSG_PUB.ADD;
678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
679: END;

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

672: EXCEPTION
673: WHEN OTHERS THEN
674: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
675: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
676: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
677: FND_MSG_PUB.ADD;
678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
679: END;
680:

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

690: BEGIN
691: NULL ;
692: EXCEPTION
693: WHEN OTHERS THEN
694: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
695: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
696: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
697: FND_MSG_PUB.ADD;
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

691: NULL ;
692: EXCEPTION
693: WHEN OTHERS THEN
694: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
695: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
696: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
697: FND_MSG_PUB.ADD;
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: END;

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

692: EXCEPTION
693: WHEN OTHERS THEN
694: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
695: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
696: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
697: FND_MSG_PUB.ADD;
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: END;
700:

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

759: IF NOT check_prim_cond (p_party_search_rec,
760: p_party_site_list,
761: p_contact_list,
762: p_contact_point_list) THEN
763: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
764: FND_MSG_PUB.ADD;
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;
767: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1010: ELSE
1011: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1012: END IF;
1013: IF lengthb(l_party_contains_str) > 4000 THEN
1014: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1015: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1016: FND_MSG_PUB.ADD;
1017: RAISE FND_API.G_EXC_ERROR;
1018: END IF;

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

1011: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1012: END IF;
1013: IF lengthb(l_party_contains_str) > 4000 THEN
1014: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1015: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1016: FND_MSG_PUB.ADD;
1017: RAISE FND_API.G_EXC_ERROR;
1018: END IF;
1019: IF (p_match_str = ' AND ' OR p_party_max_score

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

1079: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1080: END LOOP;
1081: -- Add the search criteria to query string
1082: IF lengthb(l_contains_str) > 4000 THEN
1083: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1084: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1085: FND_MSG_PUB.ADD;
1086: RAISE FND_API.G_EXC_ERROR;
1087: END IF;

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

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

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

1169: END IF;
1170: END LOOP;
1171: -- Add the search criteria to query string
1172: IF lengthb(l_contains_str) > 4000 THEN
1173: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1174: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1175: FND_MSG_PUB.ADD;
1176: RAISE FND_API.G_EXC_ERROR;
1177: END IF;

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

1170: END LOOP;
1171: -- Add the search criteria to query string
1172: IF lengthb(l_contains_str) > 4000 THEN
1173: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1174: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1175: FND_MSG_PUB.ADD;
1176: RAISE FND_API.G_EXC_ERROR;
1177: END IF;
1178: x_denorm_str := l_den_contains_str;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2324: IF p_index>1 THEN
2325: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2326: 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);
2327: END IF;
2328: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2329: FND_MSG_PUB.ADD;
2330: RAISE FND_API.G_EXC_ERROR;
2331: ELSE
2332: push_eval;

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

2372: IF p_index>1 THEN
2373: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2374: 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);
2375: END IF;
2376: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2377: FND_MSG_PUB.ADD;
2378: RAISE FND_API.G_EXC_ERROR;
2379: ELSE
2380: push_eval;

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

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

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

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

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

2668: IF p_index>1 THEN
2669: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2670: 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);
2671: END IF;
2672: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2673: FND_MSG_PUB.ADD;
2674: RAISE FND_API.G_EXC_ERROR;
2675: ELSE
2676: push_eval;

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

2893: ELSE
2894: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2895: 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);
2896: END IF;
2897: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2898: FND_MSG_PUB.ADD;
2899: RAISE FND_API.G_EXC_ERROR;
2900: END IF;
2901: ELSE

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

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

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

3107: RAISE FND_API.G_EXC_ERROR;
3108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3110: WHEN OTHERS THEN
3111: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3112: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_parties');
3113: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3114: FND_MSG_PUB.ADD;
3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3112: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_parties');

3108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3110: WHEN OTHERS THEN
3111: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3112: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_parties');
3113: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3114: FND_MSG_PUB.ADD;
3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3116: END find_parties;

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

3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3110: WHEN OTHERS THEN
3111: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3112: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_parties');
3113: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3114: FND_MSG_PUB.ADD;
3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3116: END find_parties;
3117:

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

3298: IF p_index>1 THEN
3299: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3300: 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);
3301: END IF;
3302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3303: FND_MSG_PUB.ADD;
3304: RAISE FND_API.G_EXC_ERROR;
3305: ELSE
3306: push_eval;

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

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

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

3382: and d.search_context_id = p_search_ctx_id);
3383: exception
3384: when others then
3385: if (instrb(SQLERRM,'DRG-51030')>0) then
3386: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3387: FND_MSG_PUB.ADD;
3388: RAISE FND_API.G_EXC_ERROR;
3389: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3390: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3386: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3387: FND_MSG_PUB.ADD;
3388: RAISE FND_API.G_EXC_ERROR;
3389: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3390: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3391: FND_MSG_PUB.ADD;
3392: RAISE FND_API.G_EXC_ERROR;
3393: else
3394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3458: IF p_index>1 THEN
3459: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3460: 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);
3461: END IF;
3462: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3463: FND_MSG_PUB.ADD;
3464: RAISE FND_API.G_EXC_ERROR;
3465: ELSE
3466: push_eval;

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

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

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

3830: ELSE
3831: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3832: 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);
3833: END IF;
3834: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3835: FND_MSG_PUB.ADD;
3836: RAISE FND_API.G_EXC_ERROR;
3837: END IF;
3838: ELSE

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

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

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

3959: RAISE FND_API.G_EXC_ERROR;
3960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3962: WHEN OTHERS THEN
3963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3964: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_persons');
3965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3966: FND_MSG_PUB.ADD;
3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3964: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_persons');

3960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3962: WHEN OTHERS THEN
3963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3964: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_persons');
3965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3966: FND_MSG_PUB.ADD;
3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3968: END find_persons;

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

3961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3962: WHEN OTHERS THEN
3963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3964: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_persons');
3965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3966: FND_MSG_PUB.ADD;
3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3968: END find_persons;
3969:

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

4027: RAISE FND_API.G_EXC_ERROR;
4028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4030: WHEN OTHERS THEN
4031: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4032: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_party_details');
4033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4034: FND_MSG_PUB.ADD;
4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4032: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_party_details');

4028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4030: WHEN OTHERS THEN
4031: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4032: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_party_details');
4033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4034: FND_MSG_PUB.ADD;
4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4036: END find_party_details;

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

4029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4030: WHEN OTHERS THEN
4031: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4032: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_party_details');
4033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4034: FND_MSG_PUB.ADD;
4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4036: END find_party_details;
4037:

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

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

Line 4149: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_parties');

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

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

4146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4147: WHEN OTHERS THEN
4148: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4149: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_parties');
4150: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4151: FND_MSG_PUB.ADD;
4152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4153: END find_duplicate_parties;
4154:

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

4229: RAISE FND_API.G_EXC_ERROR;
4230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4232: WHEN OTHERS THEN
4233: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4234: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_party_sites');
4235: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4236: FND_MSG_PUB.ADD;
4237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4234: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_party_sites');

4230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4232: WHEN OTHERS THEN
4233: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4234: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_party_sites');
4235: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4236: FND_MSG_PUB.ADD;
4237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4238: END find_duplicate_party_sites;

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

4231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4232: WHEN OTHERS THEN
4233: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4234: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_party_sites');
4235: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4236: FND_MSG_PUB.ADD;
4237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4238: END find_duplicate_party_sites;
4239:

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

4318: RAISE FND_API.G_EXC_ERROR;
4319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4321: WHEN OTHERS THEN
4322: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4323: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_contacts');
4324: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4325: FND_MSG_PUB.ADD;
4326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4323: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_contacts');

4319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4321: WHEN OTHERS THEN
4322: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4323: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_contacts');
4324: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4325: FND_MSG_PUB.ADD;
4326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4327: END find_duplicate_contacts;

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

4320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4321: WHEN OTHERS THEN
4322: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4323: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_contacts');
4324: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4325: FND_MSG_PUB.ADD;
4326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4327: END find_duplicate_contacts;
4328:

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

4391: RAISE FND_API.G_EXC_ERROR;
4392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4394: WHEN OTHERS THEN
4395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4396: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_contact_points');
4397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4398: FND_MSG_PUB.ADD;
4399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4396: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_contact_points');

4392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4394: WHEN OTHERS THEN
4395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4396: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_contact_points');
4397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4398: FND_MSG_PUB.ADD;
4399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4400: END find_duplicate_contact_points;

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

4393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4394: WHEN OTHERS THEN
4395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4396: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.find_duplicate_contact_points');
4397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4398: FND_MSG_PUB.ADD;
4399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4400: END find_duplicate_contact_points;
4401:

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

4682: RAISE FND_API.G_EXC_ERROR;
4683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4685: WHEN OTHERS THEN
4686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4687: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.call_api_dynamic');
4688: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4689: FND_MSG_PUB.ADD;
4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4687: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.call_api_dynamic');

4683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4685: WHEN OTHERS THEN
4686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4687: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.call_api_dynamic');
4688: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4689: FND_MSG_PUB.ADD;
4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4691: END call_api_dynamic;

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

4684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4685: WHEN OTHERS THEN
4686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4687: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.call_api_dynamic');
4688: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4689: FND_MSG_PUB.ADD;
4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4691: END call_api_dynamic;
4692:

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

4917: RAISE FND_API.G_EXC_ERROR;
4918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4920: WHEN OTHERS THEN
4921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4922: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_party_sites');
4923: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4924: FND_MSG_PUB.ADD;
4925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4922: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_party_sites');

4918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4920: WHEN OTHERS THEN
4921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4922: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_party_sites');
4923: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4924: FND_MSG_PUB.ADD;
4925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4926: END get_matching_party_sites;

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

4919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4920: WHEN OTHERS THEN
4921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4922: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_party_sites');
4923: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4924: FND_MSG_PUB.ADD;
4925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4926: END get_matching_party_sites;
4927:

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

5143: RAISE FND_API.G_EXC_ERROR;
5144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5146: WHEN OTHERS THEN
5147: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5148: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_contacts');
5149: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5150: FND_MSG_PUB.ADD;
5151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5148: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_contacts');

5144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5146: WHEN OTHERS THEN
5147: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5148: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_contacts');
5149: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5150: FND_MSG_PUB.ADD;
5151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5152: END get_matching_contacts;

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

5145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5146: WHEN OTHERS THEN
5147: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5148: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_contacts');
5149: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5150: FND_MSG_PUB.ADD;
5151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5152: END get_matching_contacts;
5153:

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

5283: RAISE FND_API.G_EXC_ERROR;
5284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5286: WHEN OTHERS THEN
5287: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5288: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_contact_points');
5289: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5290: FND_MSG_PUB.ADD;
5291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5288: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_contact_points');

5284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5286: WHEN OTHERS THEN
5287: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5288: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_contact_points');
5289: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5290: FND_MSG_PUB.ADD;
5291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5292: END get_matching_contact_points;

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

5285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5286: WHEN OTHERS THEN
5287: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5288: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_matching_contact_points');
5289: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5290: FND_MSG_PUB.ADD;
5291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5292: END get_matching_contact_points;
5293:

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

5485: RAISE FND_API.G_EXC_ERROR;
5486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5488: WHEN OTHERS THEN
5489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5490: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_score_details');
5491: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5492: FND_MSG_PUB.ADD;
5493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5490: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_score_details');

5486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5488: WHEN OTHERS THEN
5489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5490: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_score_details');
5491: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5492: FND_MSG_PUB.ADD;
5493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5494: END get_score_details;

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

5487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5488: WHEN OTHERS THEN
5489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5490: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_238.get_score_details');
5491: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5492: FND_MSG_PUB.ADD;
5493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5494: END get_score_details;
5495:

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

5595: RAISE FND_API.G_EXC_ERROR;
5596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5598: WHEN OTHERS THEN
5599: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5600: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5602: FND_MSG_PUB.ADD;
5603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5598: WHEN OTHERS THEN
5599: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5600: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5602: FND_MSG_PUB.ADD;
5603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5604: END get_party_for_search;

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

5597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5598: WHEN OTHERS THEN
5599: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5600: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5602: FND_MSG_PUB.ADD;
5603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5604: END get_party_for_search;
5605:

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

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

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

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

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

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

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

5703: END IF;
5704:
5705: EXCEPTION
5706: WHEN OTHERS THEN
5707: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5708: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5709: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5710: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5711: FND_MSG_PUB.ADD;

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

5704:
5705: EXCEPTION
5706: WHEN OTHERS THEN
5707: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5708: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5709: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5710: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5711: FND_MSG_PUB.ADD;
5712: RAISE FND_API.G_EXC_ERROR;

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

5705: EXCEPTION
5706: WHEN OTHERS THEN
5707: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5708: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5709: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5710: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5711: FND_MSG_PUB.ADD;
5712: RAISE FND_API.G_EXC_ERROR;
5713: END get_party_rec;

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

5706: WHEN OTHERS THEN
5707: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5708: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5709: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5710: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5711: FND_MSG_PUB.ADD;
5712: RAISE FND_API.G_EXC_ERROR;
5713: END get_party_rec;
5714:

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

5759: END LOOP;
5760:
5761: EXCEPTION
5762: WHEN OTHERS THEN
5763: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5764: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5765: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5766: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5767: FND_MSG_PUB.ADD;

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

5760:
5761: EXCEPTION
5762: WHEN OTHERS THEN
5763: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5764: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5765: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5766: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5767: FND_MSG_PUB.ADD;
5768: RAISE FND_API.G_EXC_ERROR;

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

5761: EXCEPTION
5762: WHEN OTHERS THEN
5763: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5764: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5765: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5766: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5767: FND_MSG_PUB.ADD;
5768: RAISE FND_API.G_EXC_ERROR;
5769: END get_party_site_rec;

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

5762: WHEN OTHERS THEN
5763: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5764: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5765: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5766: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5767: FND_MSG_PUB.ADD;
5768: RAISE FND_API.G_EXC_ERROR;
5769: END get_party_site_rec;
5770:

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

5815: END LOOP;
5816:
5817: EXCEPTION
5818: WHEN OTHERS THEN
5819: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5820: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5821: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5822: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5823: FND_MSG_PUB.ADD;

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

5816:
5817: EXCEPTION
5818: WHEN OTHERS THEN
5819: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5820: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5821: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5822: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5823: FND_MSG_PUB.ADD;
5824: RAISE FND_API.G_EXC_ERROR;

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

5817: EXCEPTION
5818: WHEN OTHERS THEN
5819: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5820: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5821: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5822: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5823: FND_MSG_PUB.ADD;
5824: RAISE FND_API.G_EXC_ERROR;
5825: END get_contact_rec;

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

5818: WHEN OTHERS THEN
5819: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5820: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5821: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5822: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5823: FND_MSG_PUB.ADD;
5824: RAISE FND_API.G_EXC_ERROR;
5825: END get_contact_rec;
5826:

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

5869: END LOOP;
5870:
5871: EXCEPTION
5872: WHEN OTHERS THEN
5873: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5874: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5875: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5876: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5877: FND_MSG_PUB.ADD;

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

5870:
5871: EXCEPTION
5872: WHEN OTHERS THEN
5873: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5874: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5875: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5876: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5877: FND_MSG_PUB.ADD;
5878: RAISE FND_API.G_EXC_ERROR;

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

5871: EXCEPTION
5872: WHEN OTHERS THEN
5873: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5874: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5875: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5876: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5877: FND_MSG_PUB.ADD;
5878: RAISE FND_API.G_EXC_ERROR;
5879: END get_contact_point_rec;

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

5872: WHEN OTHERS THEN
5873: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5874: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5875: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5876: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5877: FND_MSG_PUB.ADD;
5878: RAISE FND_API.G_EXC_ERROR;
5879: END get_contact_point_rec;
5880:

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

5988: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
5989: END IF;
5990: EXCEPTION
5991: WHEN OTHERS THEN
5992: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5993: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5994: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5995: FND_MSG_PUB.ADD;
5996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5989: END IF;
5990: EXCEPTION
5991: WHEN OTHERS THEN
5992: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5993: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5994: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5995: FND_MSG_PUB.ADD;
5996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5997: END;

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

5990: EXCEPTION
5991: WHEN OTHERS THEN
5992: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5993: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5994: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5995: FND_MSG_PUB.ADD;
5996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5997: END;
5998:

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

6083: END IF;
6084: END LOOP;
6085: EXCEPTION
6086: WHEN OTHERS THEN
6087: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6088: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6089: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6090: FND_MSG_PUB.ADD;
6091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6084: END LOOP;
6085: EXCEPTION
6086: WHEN OTHERS THEN
6087: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6088: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6089: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6090: FND_MSG_PUB.ADD;
6091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6092: END;

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

6085: EXCEPTION
6086: WHEN OTHERS THEN
6087: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6088: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6089: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6090: FND_MSG_PUB.ADD;
6091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6092: END;
6093:

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

6125: END IF;
6126: NULL;
6127: EXCEPTION
6128: WHEN OTHERS THEN
6129: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6130: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6131: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6132: FND_MSG_PUB.ADD;
6133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6126: NULL;
6127: EXCEPTION
6128: WHEN OTHERS THEN
6129: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6130: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6131: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6132: FND_MSG_PUB.ADD;
6133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6134: END;

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

6127: EXCEPTION
6128: WHEN OTHERS THEN
6129: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6130: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6131: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6132: FND_MSG_PUB.ADD;
6133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6134: END;
6135:

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

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

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

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

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

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

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

6243: FOR I IN 1..p_contact_point_list.COUNT LOOP
6244: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6245: p_contact_point_list(I).PHONE_NUMBER IS NOT NULL
6246: ) THEN
6247: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6248: FND_MSG_PUB.ADD;
6249: RAISE FND_API.G_EXC_ERROR;
6250: END IF;
6251: END LOOP;

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

6278: EXCEPTION
6279: WHEN FND_API.G_EXC_ERROR THEN
6280: RAISE FND_API.G_EXC_ERROR;
6281: WHEN OTHERS THEN
6282: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6283: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6284: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6285: FND_MSG_PUB.ADD;
6286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6279: WHEN FND_API.G_EXC_ERROR THEN
6280: RAISE FND_API.G_EXC_ERROR;
6281: WHEN OTHERS THEN
6282: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6283: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6284: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6285: FND_MSG_PUB.ADD;
6286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6287: END check_prim_cond;

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

6280: RAISE FND_API.G_EXC_ERROR;
6281: WHEN OTHERS THEN
6282: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6283: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6284: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6285: FND_MSG_PUB.ADD;
6286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6287: END check_prim_cond;
6288:

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

6332: EXIT WHEN x_secondary;
6333: END LOOP;
6334: EXCEPTION
6335: WHEN OTHERS THEN
6336: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6337: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6338: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6339: FND_MSG_PUB.ADD;
6340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6333: END LOOP;
6334: EXCEPTION
6335: WHEN OTHERS THEN
6336: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6337: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6338: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6339: FND_MSG_PUB.ADD;
6340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6341: END check_party_site_cond;

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

6334: EXCEPTION
6335: WHEN OTHERS THEN
6336: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6337: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6338: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6339: FND_MSG_PUB.ADD;
6340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6341: END check_party_site_cond;
6342:

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

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

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

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

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

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

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

6401: x_secondary:= FALSE;
6402:
6403: FOR I IN 1..p_contact_point_list.COUNT LOOP
6404: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6405: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6406: FND_MSG_PUB.ADD;
6407: RAISE FND_API.G_EXC_ERROR;
6408: END IF;
6409: END LOOP;

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

6423: EXIT WHEN x_secondary;
6424: END LOOP;
6425: EXCEPTION
6426: WHEN OTHERS THEN
6427: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6428: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6429: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6430: FND_MSG_PUB.ADD;
6431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6424: END LOOP;
6425: EXCEPTION
6426: WHEN OTHERS THEN
6427: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6428: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6429: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6430: FND_MSG_PUB.ADD;
6431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6432: END check_contact_point_cond;

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

6425: EXCEPTION
6426: WHEN OTHERS THEN
6427: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6428: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6429: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6430: FND_MSG_PUB.ADD;
6431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6432: END check_contact_point_cond;
6433: