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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1078: ELSE
1079: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1080: END IF;
1081: IF lengthb(l_party_contains_str) > 4000 THEN
1082: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1083: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1084: FND_MSG_PUB.ADD;
1085: RAISE FND_API.G_EXC_ERROR;
1086: END IF;

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

1079: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1080: END IF;
1081: IF lengthb(l_party_contains_str) > 4000 THEN
1082: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1083: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1084: FND_MSG_PUB.ADD;
1085: RAISE FND_API.G_EXC_ERROR;
1086: END IF;
1087: IF (p_match_str = ' AND ' OR p_party_max_score

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

1199: END IF;
1200: END LOOP;
1201: -- Add the search criteria to query string
1202: IF lengthb(l_contains_str) > 4000 THEN
1203: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1204: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1205: FND_MSG_PUB.ADD;
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;

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

1200: END LOOP;
1201: -- Add the search criteria to query string
1202: IF lengthb(l_contains_str) > 4000 THEN
1203: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1204: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1205: FND_MSG_PUB.ADD;
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208: x_denorm_str := l_den_contains_str;

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

1442: END IF;
1443: exception
1444: when others then
1445: if (instrb(SQLERRM,'DRG-51030')>0) then
1446: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1447: FND_MSG_PUB.ADD;
1448: RAISE FND_API.G_EXC_ERROR;
1449: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1446: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1447: FND_MSG_PUB.ADD;
1448: RAISE FND_API.G_EXC_ERROR;
1449: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1451: FND_MSG_PUB.ADD;
1452: RAISE FND_API.G_EXC_ERROR;
1453: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1454: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1451: FND_MSG_PUB.ADD;
1452: RAISE FND_API.G_EXC_ERROR;
1453: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1454: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1455: FND_MSG_PUB.ADD;
1456: RAISE FND_API.G_EXC_ERROR;
1457: else
1458: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1454: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1455: FND_MSG_PUB.ADD;
1456: RAISE FND_API.G_EXC_ERROR;
1457: else
1458: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1459: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1460: FND_MSG_PUB.ADD;
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1462: end if;

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

1455: FND_MSG_PUB.ADD;
1456: RAISE FND_API.G_EXC_ERROR;
1457: else
1458: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1459: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1460: FND_MSG_PUB.ADD;
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1462: end if;
1463: END;

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

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

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

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

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

1695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1696: FND_MSG_PUB.ADD;
1697: RAISE FND_API.G_EXC_ERROR;
1698: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1699: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_ERROR;
1702: else
1703: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1699: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_ERROR;
1702: else
1703: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1705: FND_MSG_PUB.ADD;
1706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1707: end if;

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

1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_ERROR;
1702: else
1703: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1705: FND_MSG_PUB.ADD;
1706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1707: end if;
1708: END;

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

1834: output_long_strings('Restrict Sql = '||p_restrict_sql);
1835: exception
1836: when others then
1837: if (instrb(SQLERRM,'DRG-51030')>0) then
1838: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1839: FND_MSG_PUB.ADD;
1840: RAISE FND_API.G_EXC_ERROR;
1841: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1842: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1838: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1839: FND_MSG_PUB.ADD;
1840: RAISE FND_API.G_EXC_ERROR;
1841: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1842: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1843: FND_MSG_PUB.ADD;
1844: RAISE FND_API.G_EXC_ERROR;
1845: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1846: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1842: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1843: FND_MSG_PUB.ADD;
1844: RAISE FND_API.G_EXC_ERROR;
1845: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1846: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1847: FND_MSG_PUB.ADD;
1848: RAISE FND_API.G_EXC_ERROR;
1849: else
1850: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1846: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1847: FND_MSG_PUB.ADD;
1848: RAISE FND_API.G_EXC_ERROR;
1849: else
1850: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1852: FND_MSG_PUB.ADD;
1853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1854: end if;

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

1847: FND_MSG_PUB.ADD;
1848: RAISE FND_API.G_EXC_ERROR;
1849: else
1850: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1852: FND_MSG_PUB.ADD;
1853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1854: end if;
1855: END;

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

2107: output_long_strings('Restrict Sql = '||p_restrict_sql);
2108: exception
2109: when others then
2110: if (instrb(SQLERRM,'DRG-51030')>0) then
2111: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2112: FND_MSG_PUB.ADD;
2113: RAISE FND_API.G_EXC_ERROR;
2114: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2115: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2111: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2112: FND_MSG_PUB.ADD;
2113: RAISE FND_API.G_EXC_ERROR;
2114: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2115: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2116: FND_MSG_PUB.ADD;
2117: RAISE FND_API.G_EXC_ERROR;
2118: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2119: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2115: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2116: FND_MSG_PUB.ADD;
2117: RAISE FND_API.G_EXC_ERROR;
2118: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2119: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2120: FND_MSG_PUB.ADD;
2121: RAISE FND_API.G_EXC_ERROR;
2122: else
2123: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2119: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2120: FND_MSG_PUB.ADD;
2121: RAISE FND_API.G_EXC_ERROR;
2122: else
2123: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2124: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2125: FND_MSG_PUB.ADD;
2126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2127: end if;

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

2120: FND_MSG_PUB.ADD;
2121: RAISE FND_API.G_EXC_ERROR;
2122: else
2123: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2124: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2125: FND_MSG_PUB.ADD;
2126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2127: end if;
2128: END;

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

2422: IF p_index>1 THEN
2423: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2424: 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);
2425: END IF;
2426: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2427: FND_MSG_PUB.ADD;
2428: RAISE FND_API.G_EXC_ERROR;
2429: ELSE
2430: push_eval;

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

2495: IF p_index>1 THEN
2496: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2497: 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);
2498: END IF;
2499: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2500: FND_MSG_PUB.ADD;
2501: RAISE FND_API.G_EXC_ERROR;
2502: ELSE
2503: push_eval;

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

2607: IF p_index>1 THEN
2608: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2609: 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);
2610: END IF;
2611: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2612: FND_MSG_PUB.ADD;
2613: RAISE FND_API.G_EXC_ERROR;
2614: ELSE
2615: push_eval;

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

2718: IF p_index>1 THEN
2719: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2720: 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);
2721: END IF;
2722: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2723: FND_MSG_PUB.ADD;
2724: RAISE FND_API.G_EXC_ERROR;
2725: ELSE
2726: push_eval;

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

2943: ELSE
2944: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2945: 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);
2946: END IF;
2947: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2948: FND_MSG_PUB.ADD;
2949: RAISE FND_API.G_EXC_ERROR;
2950: END IF;
2951: ELSE

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

2951: ELSE
2952: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2953: 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);
2954: END IF;
2955: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2956: FND_MSG_PUB.ADD;
2957: RAISE FND_API.G_EXC_ERROR;
2958: END IF;
2959: END IF;

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

3157: RAISE FND_API.G_EXC_ERROR;
3158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3160: WHEN OTHERS THEN
3161: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3162: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_parties');
3163: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3164: FND_MSG_PUB.ADD;
3165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3162: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_parties');

3158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3160: WHEN OTHERS THEN
3161: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3162: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_parties');
3163: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3164: FND_MSG_PUB.ADD;
3165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3166: END find_parties;

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

3159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3160: WHEN OTHERS THEN
3161: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3162: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_parties');
3163: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3164: FND_MSG_PUB.ADD;
3165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3166: END find_parties;
3167:

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

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

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

3401: IF p_index>1 THEN
3402: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3403: 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);
3404: END IF;
3405: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3406: FND_MSG_PUB.ADD;
3407: RAISE FND_API.G_EXC_ERROR;
3408: ELSE
3409: push_eval;

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

3437: and d.search_context_id = p_search_ctx_id);
3438: exception
3439: when others then
3440: if (instrb(SQLERRM,'DRG-51030')>0) then
3441: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3442: FND_MSG_PUB.ADD;
3443: RAISE FND_API.G_EXC_ERROR;
3444: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3445: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3441: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3442: FND_MSG_PUB.ADD;
3443: RAISE FND_API.G_EXC_ERROR;
3444: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3445: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3446: FND_MSG_PUB.ADD;
3447: RAISE FND_API.G_EXC_ERROR;
3448: else
3449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3513: IF p_index>1 THEN
3514: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3515: 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);
3516: END IF;
3517: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3518: FND_MSG_PUB.ADD;
3519: RAISE FND_API.G_EXC_ERROR;
3520: ELSE
3521: push_eval;

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

3772: IF p_index>1 THEN
3773: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3774: 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);
3775: END IF;
3776: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3777: FND_MSG_PUB.ADD;
3778: RAISE FND_API.G_EXC_ERROR;
3779: ELSE
3780: push_eval;

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

3885: ELSE
3886: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3887: 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);
3888: END IF;
3889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3890: FND_MSG_PUB.ADD;
3891: RAISE FND_API.G_EXC_ERROR;
3892: END IF;
3893: ELSE

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

3893: ELSE
3894: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3895: 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);
3896: END IF;
3897: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3898: FND_MSG_PUB.ADD;
3899: RAISE FND_API.G_EXC_ERROR;
3900: END IF;
3901: END IF;

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

4014: RAISE FND_API.G_EXC_ERROR;
4015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4017: WHEN OTHERS THEN
4018: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4019: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_persons');
4020: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4021: FND_MSG_PUB.ADD;
4022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4019: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_persons');

4015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4017: WHEN OTHERS THEN
4018: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4019: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_persons');
4020: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4021: FND_MSG_PUB.ADD;
4022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4023: END find_persons;

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

4016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4017: WHEN OTHERS THEN
4018: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4019: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_persons');
4020: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4021: FND_MSG_PUB.ADD;
4022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4023: END find_persons;
4024:

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

4082: RAISE FND_API.G_EXC_ERROR;
4083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4085: WHEN OTHERS THEN
4086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4087: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_party_details');
4088: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4089: FND_MSG_PUB.ADD;
4090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4087: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_party_details');

4083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4085: WHEN OTHERS THEN
4086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4087: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_party_details');
4088: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4089: FND_MSG_PUB.ADD;
4090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4091: END find_party_details;

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

4084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4085: WHEN OTHERS THEN
4086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4087: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_party_details');
4088: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4089: FND_MSG_PUB.ADD;
4090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4091: END find_party_details;
4092:

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

4199: RAISE FND_API.G_EXC_ERROR;
4200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4202: WHEN OTHERS THEN
4203: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4204: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_parties');
4205: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4206: FND_MSG_PUB.ADD;
4207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4204: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_parties');

4200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4202: WHEN OTHERS THEN
4203: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4204: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_parties');
4205: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4206: FND_MSG_PUB.ADD;
4207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4208: END find_duplicate_parties;

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

4201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4202: WHEN OTHERS THEN
4203: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4204: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_parties');
4205: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4206: FND_MSG_PUB.ADD;
4207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4208: END find_duplicate_parties;
4209:

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

4284: RAISE FND_API.G_EXC_ERROR;
4285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4287: WHEN OTHERS THEN
4288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_party_sites');
4290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4291: FND_MSG_PUB.ADD;
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_party_sites');

4285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4287: WHEN OTHERS THEN
4288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_party_sites');
4290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4291: FND_MSG_PUB.ADD;
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4293: END find_duplicate_party_sites;

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

4286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4287: WHEN OTHERS THEN
4288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_party_sites');
4290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4291: FND_MSG_PUB.ADD;
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4293: END find_duplicate_party_sites;
4294:

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

4373: RAISE FND_API.G_EXC_ERROR;
4374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4376: WHEN OTHERS THEN
4377: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4378: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contacts');
4379: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4380: FND_MSG_PUB.ADD;
4381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4378: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contacts');

4374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4376: WHEN OTHERS THEN
4377: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4378: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contacts');
4379: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4380: FND_MSG_PUB.ADD;
4381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4382: END find_duplicate_contacts;

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

4375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4376: WHEN OTHERS THEN
4377: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4378: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contacts');
4379: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4380: FND_MSG_PUB.ADD;
4381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4382: END find_duplicate_contacts;
4383:

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

4446: RAISE FND_API.G_EXC_ERROR;
4447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4449: WHEN OTHERS THEN
4450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4451: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contact_points');
4452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4453: FND_MSG_PUB.ADD;
4454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4451: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contact_points');

4447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4449: WHEN OTHERS THEN
4450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4451: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contact_points');
4452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4453: FND_MSG_PUB.ADD;
4454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4455: END find_duplicate_contact_points;

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

4448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4449: WHEN OTHERS THEN
4450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4451: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contact_points');
4452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4453: FND_MSG_PUB.ADD;
4454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4455: END find_duplicate_contact_points;
4456:

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

4737: RAISE FND_API.G_EXC_ERROR;
4738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4740: WHEN OTHERS THEN
4741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4742: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.call_api_dynamic');
4743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4744: FND_MSG_PUB.ADD;
4745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4742: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.call_api_dynamic');

4738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4740: WHEN OTHERS THEN
4741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4742: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.call_api_dynamic');
4743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4744: FND_MSG_PUB.ADD;
4745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4746: END call_api_dynamic;

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

4739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4740: WHEN OTHERS THEN
4741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4742: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.call_api_dynamic');
4743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4744: FND_MSG_PUB.ADD;
4745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4746: END call_api_dynamic;
4747:

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

4971: RAISE FND_API.G_EXC_ERROR;
4972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4974: WHEN OTHERS THEN
4975: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4976: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_party_sites');
4977: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4978: FND_MSG_PUB.ADD;
4979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4976: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_party_sites');

4972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4974: WHEN OTHERS THEN
4975: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4976: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_party_sites');
4977: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4978: FND_MSG_PUB.ADD;
4979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4980: END get_matching_party_sites;

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

4973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4974: WHEN OTHERS THEN
4975: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4976: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_party_sites');
4977: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4978: FND_MSG_PUB.ADD;
4979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4980: END get_matching_party_sites;
4981:

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

5198: RAISE FND_API.G_EXC_ERROR;
5199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5201: WHEN OTHERS THEN
5202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5203: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contacts');
5204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5205: FND_MSG_PUB.ADD;
5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5203: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contacts');

5199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5201: WHEN OTHERS THEN
5202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5203: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contacts');
5204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5205: FND_MSG_PUB.ADD;
5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5207: END get_matching_contacts;

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

5200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5201: WHEN OTHERS THEN
5202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5203: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contacts');
5204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5205: FND_MSG_PUB.ADD;
5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5207: END get_matching_contacts;
5208:

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

5339: RAISE FND_API.G_EXC_ERROR;
5340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: WHEN OTHERS THEN
5343: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5344: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contact_points');
5345: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5346: FND_MSG_PUB.ADD;
5347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5344: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contact_points');

5340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: WHEN OTHERS THEN
5343: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5344: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contact_points');
5345: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5346: FND_MSG_PUB.ADD;
5347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5348: END get_matching_contact_points;

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

5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: WHEN OTHERS THEN
5343: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5344: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contact_points');
5345: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5346: FND_MSG_PUB.ADD;
5347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5348: END get_matching_contact_points;
5349:

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

5548: RAISE FND_API.G_EXC_ERROR;
5549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5551: WHEN OTHERS THEN
5552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5553: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_score_details');
5554: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5555: FND_MSG_PUB.ADD;
5556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5553: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_score_details');

5549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5551: WHEN OTHERS THEN
5552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5553: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_score_details');
5554: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5555: FND_MSG_PUB.ADD;
5556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5557: END get_score_details;

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

5550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5551: WHEN OTHERS THEN
5552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5553: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_score_details');
5554: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5555: FND_MSG_PUB.ADD;
5556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5557: END get_score_details;
5558:

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

5623: RAISE FND_API.G_EXC_ERROR;
5624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5626: WHEN OTHERS THEN
5627: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5628: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5629: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5630: FND_MSG_PUB.ADD;
5631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5626: WHEN OTHERS THEN
5627: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5628: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5629: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5630: FND_MSG_PUB.ADD;
5631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5632: END get_party_for_search;

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

5625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5626: WHEN OTHERS THEN
5627: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5628: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5629: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5630: FND_MSG_PUB.ADD;
5631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5632: END get_party_for_search;
5633:

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

5663: RAISE FND_API.G_EXC_ERROR;
5664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5666: WHEN OTHERS THEN
5667: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5668: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5669: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5670: FND_MSG_PUB.ADD;
5671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5666: WHEN OTHERS THEN
5667: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5668: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5669: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5670: FND_MSG_PUB.ADD;
5671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5672: END get_search_criteria;

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

5665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5666: WHEN OTHERS THEN
5667: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5668: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5669: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5670: FND_MSG_PUB.ADD;
5671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5672: END get_search_criteria;
5673:

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

5729: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
5730:
5731: EXCEPTION
5732: WHEN OTHERS THEN
5733: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5734: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5735: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5736: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5737: FND_MSG_PUB.ADD;

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

5730:
5731: EXCEPTION
5732: WHEN OTHERS THEN
5733: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5734: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5735: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5736: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5737: FND_MSG_PUB.ADD;
5738: RAISE FND_API.G_EXC_ERROR;

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

5731: EXCEPTION
5732: WHEN OTHERS THEN
5733: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5734: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5735: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5736: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5737: FND_MSG_PUB.ADD;
5738: RAISE FND_API.G_EXC_ERROR;
5739: END get_party_rec;

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

5732: WHEN OTHERS THEN
5733: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5734: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5735: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5736: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5737: FND_MSG_PUB.ADD;
5738: RAISE FND_API.G_EXC_ERROR;
5739: END get_party_rec;
5740:

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

5781: END LOOP;
5782:
5783: EXCEPTION
5784: WHEN OTHERS THEN
5785: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5786: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5787: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5788: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5789: FND_MSG_PUB.ADD;

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

5782:
5783: EXCEPTION
5784: WHEN OTHERS THEN
5785: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5786: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5787: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5788: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5789: FND_MSG_PUB.ADD;
5790: RAISE FND_API.G_EXC_ERROR;

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

5783: EXCEPTION
5784: WHEN OTHERS THEN
5785: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5786: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5787: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5788: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5789: FND_MSG_PUB.ADD;
5790: RAISE FND_API.G_EXC_ERROR;
5791: END get_party_site_rec;

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

5784: WHEN OTHERS THEN
5785: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5786: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5787: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5788: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5789: FND_MSG_PUB.ADD;
5790: RAISE FND_API.G_EXC_ERROR;
5791: END get_party_site_rec;
5792:

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

5837: END LOOP;
5838:
5839: EXCEPTION
5840: WHEN OTHERS THEN
5841: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5842: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5843: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5844: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5845: FND_MSG_PUB.ADD;

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

5838:
5839: EXCEPTION
5840: WHEN OTHERS THEN
5841: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5842: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5843: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5844: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5845: FND_MSG_PUB.ADD;
5846: RAISE FND_API.G_EXC_ERROR;

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

5839: EXCEPTION
5840: WHEN OTHERS THEN
5841: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5842: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5843: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5844: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5845: FND_MSG_PUB.ADD;
5846: RAISE FND_API.G_EXC_ERROR;
5847: END get_contact_rec;

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

5840: WHEN OTHERS THEN
5841: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5842: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5843: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5844: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5845: FND_MSG_PUB.ADD;
5846: RAISE FND_API.G_EXC_ERROR;
5847: END get_contact_rec;
5848:

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

5891: END LOOP;
5892:
5893: EXCEPTION
5894: WHEN OTHERS THEN
5895: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5896: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5897: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5898: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5899: FND_MSG_PUB.ADD;

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

5892:
5893: EXCEPTION
5894: WHEN OTHERS THEN
5895: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5896: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5897: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5898: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5899: FND_MSG_PUB.ADD;
5900: RAISE FND_API.G_EXC_ERROR;

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

5893: EXCEPTION
5894: WHEN OTHERS THEN
5895: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5896: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5897: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5898: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5899: FND_MSG_PUB.ADD;
5900: RAISE FND_API.G_EXC_ERROR;
5901: END get_contact_point_rec;

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

5894: WHEN OTHERS THEN
5895: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5896: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5897: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5898: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5899: FND_MSG_PUB.ADD;
5900: RAISE FND_API.G_EXC_ERROR;
5901: END get_contact_point_rec;
5902:

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

6085: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6086: END IF;
6087: EXCEPTION
6088: WHEN OTHERS THEN
6089: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6090: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6091: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6092: FND_MSG_PUB.ADD;
6093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

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

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

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

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

6130: EXCEPTION
6131: WHEN OTHERS THEN
6132: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6133: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6134: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6135: FND_MSG_PUB.ADD;
6136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6137: END;
6138:

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

6170: END IF;
6171: NULL;
6172: EXCEPTION
6173: WHEN OTHERS THEN
6174: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6175: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6176: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6177: FND_MSG_PUB.ADD;
6178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6171: NULL;
6172: EXCEPTION
6173: WHEN OTHERS THEN
6174: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6175: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6176: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6177: FND_MSG_PUB.ADD;
6178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6179: END;

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

6172: EXCEPTION
6173: WHEN OTHERS THEN
6174: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6175: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6176: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6177: FND_MSG_PUB.ADD;
6178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6179: END;
6180:

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

6275: END IF;
6276: END LOOP;
6277: EXCEPTION
6278: WHEN OTHERS THEN
6279: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6280: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6281: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6282: FND_MSG_PUB.ADD;
6283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6276: END LOOP;
6277: EXCEPTION
6278: WHEN OTHERS THEN
6279: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6280: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6281: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6282: FND_MSG_PUB.ADD;
6283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6284: END;

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

6277: EXCEPTION
6278: WHEN OTHERS THEN
6279: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6280: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6281: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6282: FND_MSG_PUB.ADD;
6283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6284: END;
6285:

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

6301: FOR I IN 1..p_contact_point_list.COUNT LOOP
6302: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6303: p_contact_point_list(I).URL IS NOT NULL
6304: ) THEN
6305: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6306: FND_MSG_PUB.ADD;
6307: RAISE FND_API.G_EXC_ERROR;
6308: END IF;
6309: END LOOP;

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

6332: EXCEPTION
6333: WHEN FND_API.G_EXC_ERROR THEN
6334: RAISE FND_API.G_EXC_ERROR;
6335: WHEN OTHERS THEN
6336: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6337: FND_MESSAGE.SET_TOKEN('PROC','check_prim_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_prim_cond');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

6445: x_secondary:= FALSE;
6446:
6447: FOR I IN 1..p_contact_point_list.COUNT LOOP
6448: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6449: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6450: FND_MSG_PUB.ADD;
6451: RAISE FND_API.G_EXC_ERROR;
6452: END IF;
6453: END LOOP;

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

6467: EXIT WHEN x_secondary;
6468: END LOOP;
6469: EXCEPTION
6470: WHEN OTHERS THEN
6471: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6472: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6473: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6474: FND_MSG_PUB.ADD;
6475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6468: END LOOP;
6469: EXCEPTION
6470: WHEN OTHERS THEN
6471: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6472: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6473: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6474: FND_MSG_PUB.ADD;
6475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6476: END check_contact_point_cond;

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

6469: EXCEPTION
6470: WHEN OTHERS THEN
6471: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6472: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6473: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6474: FND_MSG_PUB.ADD;
6475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6476: END check_contact_point_cond;
6477: