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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2417: IF p_index>1 THEN
2418: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2419: 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);
2420: END IF;
2421: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2422: FND_MSG_PUB.ADD;
2423: RAISE FND_API.G_EXC_ERROR;
2424: ELSE
2425: push_eval;

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

2490: IF p_index>1 THEN
2491: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2492: 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);
2493: END IF;
2494: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2495: FND_MSG_PUB.ADD;
2496: RAISE FND_API.G_EXC_ERROR;
2497: ELSE
2498: push_eval;

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

2602: IF p_index>1 THEN
2603: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2604: 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);
2605: END IF;
2606: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2607: FND_MSG_PUB.ADD;
2608: RAISE FND_API.G_EXC_ERROR;
2609: ELSE
2610: push_eval;

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

2713: IF p_index>1 THEN
2714: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2715: 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);
2716: END IF;
2717: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2718: FND_MSG_PUB.ADD;
2719: RAISE FND_API.G_EXC_ERROR;
2720: ELSE
2721: push_eval;

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

2938: ELSE
2939: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2940: 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);
2941: END IF;
2942: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2943: FND_MSG_PUB.ADD;
2944: RAISE FND_API.G_EXC_ERROR;
2945: END IF;
2946: ELSE

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

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

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

3152: RAISE FND_API.G_EXC_ERROR;
3153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3155: WHEN OTHERS THEN
3156: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3157: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_parties');
3158: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3159: FND_MSG_PUB.ADD;
3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3155: WHEN OTHERS THEN
3156: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3157: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_parties');
3158: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3159: FND_MSG_PUB.ADD;
3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3161: END find_parties;

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

3154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3155: WHEN OTHERS THEN
3156: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3157: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_parties');
3158: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3159: FND_MSG_PUB.ADD;
3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3161: END find_parties;
3162:

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

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

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

3393: IF p_index>1 THEN
3394: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3395: 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);
3396: END IF;
3397: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3398: FND_MSG_PUB.ADD;
3399: RAISE FND_API.G_EXC_ERROR;
3400: ELSE
3401: push_eval;

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

3429: and d.search_context_id = p_search_ctx_id);
3430: exception
3431: when others then
3432: if (instrb(SQLERRM,'DRG-51030')>0) then
3433: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3434: FND_MSG_PUB.ADD;
3435: RAISE FND_API.G_EXC_ERROR;
3436: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3433: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3434: FND_MSG_PUB.ADD;
3435: RAISE FND_API.G_EXC_ERROR;
3436: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3438: FND_MSG_PUB.ADD;
3439: RAISE FND_API.G_EXC_ERROR;
3440: else
3441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3505: IF p_index>1 THEN
3506: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3507: 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);
3508: END IF;
3509: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3510: FND_MSG_PUB.ADD;
3511: RAISE FND_API.G_EXC_ERROR;
3512: ELSE
3513: push_eval;

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

3764: IF p_index>1 THEN
3765: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3766: 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);
3767: END IF;
3768: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3769: FND_MSG_PUB.ADD;
3770: RAISE FND_API.G_EXC_ERROR;
3771: ELSE
3772: push_eval;

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

3877: ELSE
3878: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3879: 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);
3880: END IF;
3881: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3882: FND_MSG_PUB.ADD;
3883: RAISE FND_API.G_EXC_ERROR;
3884: END IF;
3885: ELSE

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: END IF;

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

4006: RAISE FND_API.G_EXC_ERROR;
4007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4009: WHEN OTHERS THEN
4010: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4011: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_persons');
4012: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4013: FND_MSG_PUB.ADD;
4014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4009: WHEN OTHERS THEN
4010: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4011: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_persons');
4012: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4013: FND_MSG_PUB.ADD;
4014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4015: END find_persons;

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

4008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4009: WHEN OTHERS THEN
4010: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4011: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_persons');
4012: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4013: FND_MSG_PUB.ADD;
4014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4015: END find_persons;
4016:

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

4074: RAISE FND_API.G_EXC_ERROR;
4075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4077: WHEN OTHERS THEN
4078: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4079: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_party_details');
4080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4081: FND_MSG_PUB.ADD;
4082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4077: WHEN OTHERS THEN
4078: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4079: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_party_details');
4080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4081: FND_MSG_PUB.ADD;
4082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4083: END find_party_details;

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

4076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4077: WHEN OTHERS THEN
4078: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4079: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_party_details');
4080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4081: FND_MSG_PUB.ADD;
4082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4083: END find_party_details;
4084:

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

4191: RAISE FND_API.G_EXC_ERROR;
4192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4194: WHEN OTHERS THEN
4195: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4196: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_parties');
4197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4198: FND_MSG_PUB.ADD;
4199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4194: WHEN OTHERS THEN
4195: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4196: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_parties');
4197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4198: FND_MSG_PUB.ADD;
4199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4200: END find_duplicate_parties;

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

4193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4194: WHEN OTHERS THEN
4195: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4196: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_parties');
4197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4198: FND_MSG_PUB.ADD;
4199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4200: END find_duplicate_parties;
4201:

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

4276: RAISE FND_API.G_EXC_ERROR;
4277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4279: WHEN OTHERS THEN
4280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4281: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_party_sites');
4282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4283: FND_MSG_PUB.ADD;
4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4279: WHEN OTHERS THEN
4280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4281: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_party_sites');
4282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4283: FND_MSG_PUB.ADD;
4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4285: END find_duplicate_party_sites;

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

4278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4279: WHEN OTHERS THEN
4280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4281: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_party_sites');
4282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4283: FND_MSG_PUB.ADD;
4284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4285: END find_duplicate_party_sites;
4286:

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

4365: RAISE FND_API.G_EXC_ERROR;
4366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4368: WHEN OTHERS THEN
4369: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4370: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contacts');
4371: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4372: FND_MSG_PUB.ADD;
4373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4368: WHEN OTHERS THEN
4369: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4370: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contacts');
4371: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4372: FND_MSG_PUB.ADD;
4373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4374: END find_duplicate_contacts;

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

4367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4368: WHEN OTHERS THEN
4369: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4370: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contacts');
4371: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4372: FND_MSG_PUB.ADD;
4373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4374: END find_duplicate_contacts;
4375:

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

4438: RAISE FND_API.G_EXC_ERROR;
4439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4441: WHEN OTHERS THEN
4442: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4443: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contact_points');
4444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4445: FND_MSG_PUB.ADD;
4446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4441: WHEN OTHERS THEN
4442: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4443: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contact_points');
4444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4445: FND_MSG_PUB.ADD;
4446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4447: END find_duplicate_contact_points;

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

4440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4441: WHEN OTHERS THEN
4442: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4443: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contact_points');
4444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4445: FND_MSG_PUB.ADD;
4446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4447: END find_duplicate_contact_points;
4448:

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

4729: RAISE FND_API.G_EXC_ERROR;
4730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4732: WHEN OTHERS THEN
4733: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4734: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.call_api_dynamic');
4735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4736: FND_MSG_PUB.ADD;
4737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4732: WHEN OTHERS THEN
4733: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4734: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.call_api_dynamic');
4735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4736: FND_MSG_PUB.ADD;
4737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4738: END call_api_dynamic;

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

4731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4732: WHEN OTHERS THEN
4733: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4734: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.call_api_dynamic');
4735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4736: FND_MSG_PUB.ADD;
4737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4738: END call_api_dynamic;
4739:

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

4963: RAISE FND_API.G_EXC_ERROR;
4964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4966: WHEN OTHERS THEN
4967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4968: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_party_sites');
4969: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4970: FND_MSG_PUB.ADD;
4971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4966: WHEN OTHERS THEN
4967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4968: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_party_sites');
4969: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4970: FND_MSG_PUB.ADD;
4971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4972: END get_matching_party_sites;

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

4965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4966: WHEN OTHERS THEN
4967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4968: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_party_sites');
4969: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4970: FND_MSG_PUB.ADD;
4971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4972: END get_matching_party_sites;
4973:

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

5190: RAISE FND_API.G_EXC_ERROR;
5191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5193: WHEN OTHERS THEN
5194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5195: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contacts');
5196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5197: FND_MSG_PUB.ADD;
5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5193: WHEN OTHERS THEN
5194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5195: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contacts');
5196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5197: FND_MSG_PUB.ADD;
5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5199: END get_matching_contacts;

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

5192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5193: WHEN OTHERS THEN
5194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5195: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contacts');
5196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5197: FND_MSG_PUB.ADD;
5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5199: END get_matching_contacts;
5200:

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

5331: RAISE FND_API.G_EXC_ERROR;
5332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5334: WHEN OTHERS THEN
5335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contact_points');
5337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5338: FND_MSG_PUB.ADD;
5339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5334: WHEN OTHERS THEN
5335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contact_points');
5337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5338: FND_MSG_PUB.ADD;
5339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5340: END get_matching_contact_points;

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

5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5334: WHEN OTHERS THEN
5335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contact_points');
5337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5338: FND_MSG_PUB.ADD;
5339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5340: END get_matching_contact_points;
5341:

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

5537: RAISE FND_API.G_EXC_ERROR;
5538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5540: WHEN OTHERS THEN
5541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5542: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_score_details');
5543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5544: FND_MSG_PUB.ADD;
5545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5540: WHEN OTHERS THEN
5541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5542: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_score_details');
5543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5544: FND_MSG_PUB.ADD;
5545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5546: END get_score_details;

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

5539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5540: WHEN OTHERS THEN
5541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5542: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_score_details');
5543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5544: FND_MSG_PUB.ADD;
5545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5546: END get_score_details;
5547:

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

5612: RAISE FND_API.G_EXC_ERROR;
5613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5615: WHEN OTHERS THEN
5616: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5617: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5618: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5619: FND_MSG_PUB.ADD;
5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5615: WHEN OTHERS THEN
5616: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5617: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5618: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5619: FND_MSG_PUB.ADD;
5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5621: END get_party_for_search;

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

5614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5615: WHEN OTHERS THEN
5616: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5617: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5618: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5619: FND_MSG_PUB.ADD;
5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5621: END get_party_for_search;
5622:

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

5652: RAISE FND_API.G_EXC_ERROR;
5653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5655: WHEN OTHERS THEN
5656: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5657: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5659: FND_MSG_PUB.ADD;
5660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5655: WHEN OTHERS THEN
5656: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5657: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5659: FND_MSG_PUB.ADD;
5660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5661: END get_search_criteria;

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

5654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5655: WHEN OTHERS THEN
5656: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5657: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5659: FND_MSG_PUB.ADD;
5660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5661: END get_search_criteria;
5662:

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

5718: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
5719:
5720: EXCEPTION
5721: WHEN OTHERS THEN
5722: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5723: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5724: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5726: FND_MSG_PUB.ADD;

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

5719:
5720: EXCEPTION
5721: WHEN OTHERS THEN
5722: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5723: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5724: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5726: FND_MSG_PUB.ADD;
5727: RAISE FND_API.G_EXC_ERROR;

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

5720: EXCEPTION
5721: WHEN OTHERS THEN
5722: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5723: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5724: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5726: FND_MSG_PUB.ADD;
5727: RAISE FND_API.G_EXC_ERROR;
5728: END get_party_rec;

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

5721: WHEN OTHERS THEN
5722: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5723: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5724: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5726: FND_MSG_PUB.ADD;
5727: RAISE FND_API.G_EXC_ERROR;
5728: END get_party_rec;
5729:

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

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

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

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

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

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

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

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

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

5826: END LOOP;
5827:
5828: EXCEPTION
5829: WHEN OTHERS THEN
5830: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5831: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5832: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5834: FND_MSG_PUB.ADD;

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

5827:
5828: EXCEPTION
5829: WHEN OTHERS THEN
5830: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5831: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5832: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5834: FND_MSG_PUB.ADD;
5835: RAISE FND_API.G_EXC_ERROR;

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

5828: EXCEPTION
5829: WHEN OTHERS THEN
5830: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5831: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5832: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5834: FND_MSG_PUB.ADD;
5835: RAISE FND_API.G_EXC_ERROR;
5836: END get_contact_rec;

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

5829: WHEN OTHERS THEN
5830: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5831: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5832: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5834: FND_MSG_PUB.ADD;
5835: RAISE FND_API.G_EXC_ERROR;
5836: END get_contact_rec;
5837:

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

5880: END LOOP;
5881:
5882: EXCEPTION
5883: WHEN OTHERS THEN
5884: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5885: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5886: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5887: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5888: FND_MSG_PUB.ADD;

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

5881:
5882: EXCEPTION
5883: WHEN OTHERS THEN
5884: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5885: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5886: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5887: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5888: FND_MSG_PUB.ADD;
5889: RAISE FND_API.G_EXC_ERROR;

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

5882: EXCEPTION
5883: WHEN OTHERS THEN
5884: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5885: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5886: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5887: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5888: FND_MSG_PUB.ADD;
5889: RAISE FND_API.G_EXC_ERROR;
5890: END get_contact_point_rec;

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

5883: WHEN OTHERS THEN
5884: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5885: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5886: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5887: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5888: FND_MSG_PUB.ADD;
5889: RAISE FND_API.G_EXC_ERROR;
5890: END get_contact_point_rec;
5891:

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

6074: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6075: END IF;
6076: EXCEPTION
6077: WHEN OTHERS THEN
6078: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6079: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6081: FND_MSG_PUB.ADD;
6082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6075: END IF;
6076: EXCEPTION
6077: WHEN OTHERS THEN
6078: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6079: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6081: FND_MSG_PUB.ADD;
6082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6083: END;

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

6076: EXCEPTION
6077: WHEN OTHERS THEN
6078: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6079: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6081: FND_MSG_PUB.ADD;
6082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6083: END;
6084:

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

6117: END IF;
6118: NULL;
6119: EXCEPTION
6120: WHEN OTHERS THEN
6121: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6122: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6123: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6124: FND_MSG_PUB.ADD;
6125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6118: NULL;
6119: EXCEPTION
6120: WHEN OTHERS THEN
6121: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6122: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6123: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6124: FND_MSG_PUB.ADD;
6125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6126: END;

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

6119: EXCEPTION
6120: WHEN OTHERS THEN
6121: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6122: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6123: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6124: FND_MSG_PUB.ADD;
6125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6126: END;
6127:

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

6159: END IF;
6160: NULL;
6161: EXCEPTION
6162: WHEN OTHERS THEN
6163: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6164: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6165: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6166: FND_MSG_PUB.ADD;
6167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

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

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

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

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

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

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

6290: FOR I IN 1..p_contact_point_list.COUNT LOOP
6291: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6292: p_contact_point_list(I).URL IS NOT NULL
6293: ) THEN
6294: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6295: FND_MSG_PUB.ADD;
6296: RAISE FND_API.G_EXC_ERROR;
6297: END IF;
6298: END LOOP;

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

6321: EXCEPTION
6322: WHEN FND_API.G_EXC_ERROR THEN
6323: RAISE FND_API.G_EXC_ERROR;
6324: WHEN OTHERS THEN
6325: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6326: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6327: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6328: FND_MSG_PUB.ADD;
6329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6322: WHEN FND_API.G_EXC_ERROR THEN
6323: RAISE FND_API.G_EXC_ERROR;
6324: WHEN OTHERS THEN
6325: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6326: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6327: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6328: FND_MSG_PUB.ADD;
6329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6330: END check_prim_cond;

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

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

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

6365: EXIT WHEN x_secondary;
6366: END LOOP;
6367: EXCEPTION
6368: WHEN OTHERS THEN
6369: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6370: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6371: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6372: FND_MSG_PUB.ADD;
6373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6366: END LOOP;
6367: EXCEPTION
6368: WHEN OTHERS THEN
6369: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6370: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6371: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6372: FND_MSG_PUB.ADD;
6373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6374: END check_party_site_cond;

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

6367: EXCEPTION
6368: WHEN OTHERS THEN
6369: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6370: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6371: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6372: FND_MSG_PUB.ADD;
6373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6374: END check_party_site_cond;
6375:

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

6411: EXIT WHEN x_secondary;
6412: END LOOP;
6413: EXCEPTION
6414: WHEN OTHERS THEN
6415: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6416: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6418: FND_MSG_PUB.ADD;
6419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6412: END LOOP;
6413: EXCEPTION
6414: WHEN OTHERS THEN
6415: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6416: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6418: FND_MSG_PUB.ADD;
6419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6420: END check_contact_cond;

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

6413: EXCEPTION
6414: WHEN OTHERS THEN
6415: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6416: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6418: FND_MSG_PUB.ADD;
6419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6420: END check_contact_cond;
6421:

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

6434: x_secondary:= FALSE;
6435:
6436: FOR I IN 1..p_contact_point_list.COUNT LOOP
6437: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6438: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6439: FND_MSG_PUB.ADD;
6440: RAISE FND_API.G_EXC_ERROR;
6441: END IF;
6442: END LOOP;

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

6456: EXIT WHEN x_secondary;
6457: END LOOP;
6458: EXCEPTION
6459: WHEN OTHERS THEN
6460: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6461: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6462: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6463: FND_MSG_PUB.ADD;
6464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6457: END LOOP;
6458: EXCEPTION
6459: WHEN OTHERS THEN
6460: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6461: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6462: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6463: FND_MSG_PUB.ADD;
6464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6465: END check_contact_point_cond;

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

6458: EXCEPTION
6459: WHEN OTHERS THEN
6460: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6461: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6462: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6463: FND_MSG_PUB.ADD;
6464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6465: END check_contact_point_cond;
6466: