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

729: BEGIN
730: NULL ;
731: EXCEPTION
732: WHEN OTHERS THEN
733: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
734: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
736: FND_MSG_PUB.ADD;
737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

730: NULL ;
731: EXCEPTION
732: WHEN OTHERS THEN
733: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
734: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
736: FND_MSG_PUB.ADD;
737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
738: END;

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

731: EXCEPTION
732: WHEN OTHERS THEN
733: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
734: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
736: FND_MSG_PUB.ADD;
737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
738: END;
739:

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

754: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,p_search_list(1).COUNTRY);
755: END IF ;
756: EXCEPTION
757: WHEN OTHERS THEN
758: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
759: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
761: FND_MSG_PUB.ADD;
762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

755: END IF ;
756: EXCEPTION
757: WHEN OTHERS THEN
758: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
759: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
761: FND_MSG_PUB.ADD;
762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
763: END;

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

756: EXCEPTION
757: WHEN OTHERS THEN
758: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
759: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
761: FND_MSG_PUB.ADD;
762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
763: END;
764:

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

774: BEGIN
775: NULL ;
776: EXCEPTION
777: WHEN OTHERS THEN
778: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
779: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
780: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
781: FND_MSG_PUB.ADD;
782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

775: NULL ;
776: EXCEPTION
777: WHEN OTHERS THEN
778: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
779: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
780: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
781: FND_MSG_PUB.ADD;
782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
783: END;

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

776: EXCEPTION
777: WHEN OTHERS THEN
778: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
779: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
780: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
781: FND_MSG_PUB.ADD;
782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
783: END;
784:

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

794: BEGIN
795: NULL ;
796: EXCEPTION
797: WHEN OTHERS THEN
798: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
799: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
801: FND_MSG_PUB.ADD;
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

795: NULL ;
796: EXCEPTION
797: WHEN OTHERS THEN
798: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
799: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
801: FND_MSG_PUB.ADD;
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: END;

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

796: EXCEPTION
797: WHEN OTHERS THEN
798: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
799: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
801: FND_MSG_PUB.ADD;
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: END;
804:

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

863: IF NOT check_prim_cond (p_party_search_rec,
864: p_party_site_list,
865: p_contact_list,
866: p_contact_point_list) THEN
867: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
868: FND_MSG_PUB.ADD;
869: RAISE FND_API.G_EXC_ERROR;
870: END IF;
871: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1063: hz_utility_v2pub.debug(p_message=>'calculated denorm string l_denorm_str is '||l_denorm_str,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1064: END IF;
1065: END IF;
1066: IF lengthb(l_party_contains_str) > 4000 THEN
1067: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1068: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1069: FND_MSG_PUB.ADD;
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;

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

1064: END IF;
1065: END IF;
1066: IF lengthb(l_party_contains_str) > 4000 THEN
1067: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1068: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1069: FND_MSG_PUB.ADD;
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;
1072: IF (p_match_str = ' AND ' OR p_party_max_score

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

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

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

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

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

1461: END IF;
1462: exception
1463: when others then
1464: if (instrb(SQLERRM,'DRG-51030')>0) then
1465: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1466: FND_MSG_PUB.ADD;
1467: RAISE FND_API.G_EXC_ERROR;
1468: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1465: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1466: FND_MSG_PUB.ADD;
1467: RAISE FND_API.G_EXC_ERROR;
1468: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1470: FND_MSG_PUB.ADD;
1471: RAISE FND_API.G_EXC_ERROR;
1472: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1473: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1470: FND_MSG_PUB.ADD;
1471: RAISE FND_API.G_EXC_ERROR;
1472: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1473: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1474: FND_MSG_PUB.ADD;
1475: RAISE FND_API.G_EXC_ERROR;
1476: else
1477: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1473: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1474: FND_MSG_PUB.ADD;
1475: RAISE FND_API.G_EXC_ERROR;
1476: else
1477: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1478: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1479: FND_MSG_PUB.ADD;
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1481: end if;

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

1474: FND_MSG_PUB.ADD;
1475: RAISE FND_API.G_EXC_ERROR;
1476: else
1477: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1478: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1479: FND_MSG_PUB.ADD;
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1481: end if;
1482: END;

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

1706: output_long_strings('Restrict Sql = '||p_restrict_sql);
1707: exception
1708: when others then
1709: if (instrb(SQLERRM,'DRG-51030')>0) then
1710: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1711: FND_MSG_PUB.ADD;
1712: RAISE FND_API.G_EXC_ERROR;
1713: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1710: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1711: FND_MSG_PUB.ADD;
1712: RAISE FND_API.G_EXC_ERROR;
1713: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1715: FND_MSG_PUB.ADD;
1716: RAISE FND_API.G_EXC_ERROR;
1717: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1718: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1715: FND_MSG_PUB.ADD;
1716: RAISE FND_API.G_EXC_ERROR;
1717: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1718: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1719: FND_MSG_PUB.ADD;
1720: RAISE FND_API.G_EXC_ERROR;
1721: else
1722: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1718: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1719: FND_MSG_PUB.ADD;
1720: RAISE FND_API.G_EXC_ERROR;
1721: else
1722: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1723: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1724: FND_MSG_PUB.ADD;
1725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1726: end if;

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

1719: FND_MSG_PUB.ADD;
1720: RAISE FND_API.G_EXC_ERROR;
1721: else
1722: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1723: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1724: FND_MSG_PUB.ADD;
1725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1726: end if;
1727: END;

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

1853: output_long_strings('Restrict Sql = '||p_restrict_sql);
1854: exception
1855: when others then
1856: if (instrb(SQLERRM,'DRG-51030')>0) then
1857: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1858: FND_MSG_PUB.ADD;
1859: RAISE FND_API.G_EXC_ERROR;
1860: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1861: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1857: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1858: FND_MSG_PUB.ADD;
1859: RAISE FND_API.G_EXC_ERROR;
1860: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1861: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1862: FND_MSG_PUB.ADD;
1863: RAISE FND_API.G_EXC_ERROR;
1864: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1865: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1861: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1862: FND_MSG_PUB.ADD;
1863: RAISE FND_API.G_EXC_ERROR;
1864: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1865: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1866: FND_MSG_PUB.ADD;
1867: RAISE FND_API.G_EXC_ERROR;
1868: else
1869: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1865: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1866: FND_MSG_PUB.ADD;
1867: RAISE FND_API.G_EXC_ERROR;
1868: else
1869: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1870: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1871: FND_MSG_PUB.ADD;
1872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1873: end if;

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

1866: FND_MSG_PUB.ADD;
1867: RAISE FND_API.G_EXC_ERROR;
1868: else
1869: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1870: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1871: FND_MSG_PUB.ADD;
1872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1873: end if;
1874: END;

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

2126: output_long_strings('Restrict Sql = '||p_restrict_sql);
2127: exception
2128: when others then
2129: if (instrb(SQLERRM,'DRG-51030')>0) then
2130: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2131: FND_MSG_PUB.ADD;
2132: RAISE FND_API.G_EXC_ERROR;
2133: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2130: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2131: FND_MSG_PUB.ADD;
2132: RAISE FND_API.G_EXC_ERROR;
2133: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2135: FND_MSG_PUB.ADD;
2136: RAISE FND_API.G_EXC_ERROR;
2137: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2135: FND_MSG_PUB.ADD;
2136: RAISE FND_API.G_EXC_ERROR;
2137: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2139: FND_MSG_PUB.ADD;
2140: RAISE FND_API.G_EXC_ERROR;
2141: else
2142: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2139: FND_MSG_PUB.ADD;
2140: RAISE FND_API.G_EXC_ERROR;
2141: else
2142: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2144: FND_MSG_PUB.ADD;
2145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2146: end if;

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

2139: FND_MSG_PUB.ADD;
2140: RAISE FND_API.G_EXC_ERROR;
2141: else
2142: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2144: FND_MSG_PUB.ADD;
2145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2146: end if;
2147: END;

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

2394: IF p_index>1 THEN
2395: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2396: 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);
2397: END IF;
2398: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2399: FND_MSG_PUB.ADD;
2400: RAISE FND_API.G_EXC_ERROR;
2401: ELSE
2402: push_eval;

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

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

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

2515: IF p_index>1 THEN
2516: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2517: 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);
2518: END IF;
2519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2520: FND_MSG_PUB.ADD;
2521: RAISE FND_API.G_EXC_ERROR;
2522: ELSE
2523: push_eval;

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

2627: IF p_index>1 THEN
2628: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2629: 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);
2630: END IF;
2631: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2632: FND_MSG_PUB.ADD;
2633: RAISE FND_API.G_EXC_ERROR;
2634: ELSE
2635: push_eval;

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

2738: IF p_index>1 THEN
2739: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2740: 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);
2741: END IF;
2742: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2743: FND_MSG_PUB.ADD;
2744: RAISE FND_API.G_EXC_ERROR;
2745: ELSE
2746: push_eval;

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

2882: ELSE
2883: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2884: 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);
2885: END IF;
2886: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2887: FND_MSG_PUB.ADD;
2888: RAISE FND_API.G_EXC_ERROR;
2889: END IF;
2890: ELSE

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

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

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

3139: RAISE FND_API.G_EXC_ERROR;
3140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3142: WHEN OTHERS THEN
3143: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3144: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_parties');
3145: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3146: FND_MSG_PUB.ADD;
3147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3144: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_parties');

3140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3142: WHEN OTHERS THEN
3143: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3144: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_parties');
3145: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3146: FND_MSG_PUB.ADD;
3147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3148: END find_parties;

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

3141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3142: WHEN OTHERS THEN
3143: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3144: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_parties');
3145: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3146: FND_MSG_PUB.ADD;
3147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3148: END find_parties;
3149:

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

3336: IF p_index>1 THEN
3337: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3338: 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);
3339: END IF;
3340: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3341: FND_MSG_PUB.ADD;
3342: RAISE FND_API.G_EXC_ERROR;
3343: ELSE
3344: push_eval;

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

3384: IF p_index>1 THEN
3385: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3386: 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);
3387: END IF;
3388: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3389: FND_MSG_PUB.ADD;
3390: RAISE FND_API.G_EXC_ERROR;
3391: ELSE
3392: push_eval;

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

3420: and d.search_context_id = p_search_ctx_id);
3421: exception
3422: when others then
3423: if (instrb(SQLERRM,'DRG-51030')>0) then
3424: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3425: FND_MSG_PUB.ADD;
3426: RAISE FND_API.G_EXC_ERROR;
3427: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3424: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3425: FND_MSG_PUB.ADD;
3426: RAISE FND_API.G_EXC_ERROR;
3427: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3429: FND_MSG_PUB.ADD;
3430: RAISE FND_API.G_EXC_ERROR;
3431: else
3432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3496: IF p_index>1 THEN
3497: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3498: 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);
3499: END IF;
3500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3501: FND_MSG_PUB.ADD;
3502: RAISE FND_API.G_EXC_ERROR;
3503: ELSE
3504: push_eval;

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

3685: IF p_index>1 THEN
3686: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3687: 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);
3688: END IF;
3689: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3690: FND_MSG_PUB.ADD;
3691: RAISE FND_API.G_EXC_ERROR;
3692: ELSE
3693: push_eval;

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

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

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

3781: ELSE
3782: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3783: 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);
3784: END IF;
3785: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3786: FND_MSG_PUB.ADD;
3787: RAISE FND_API.G_EXC_ERROR;
3788: END IF;
3789: END IF;

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

3928: RAISE FND_API.G_EXC_ERROR;
3929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3931: WHEN OTHERS THEN
3932: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3933: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_persons');
3934: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3935: FND_MSG_PUB.ADD;
3936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3933: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_persons');

3929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3931: WHEN OTHERS THEN
3932: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3933: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_persons');
3934: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3935: FND_MSG_PUB.ADD;
3936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3937: END find_persons;

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

3930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3931: WHEN OTHERS THEN
3932: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3933: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_persons');
3934: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3935: FND_MSG_PUB.ADD;
3936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3937: END find_persons;
3938:

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

3996: RAISE FND_API.G_EXC_ERROR;
3997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3999: WHEN OTHERS THEN
4000: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4001: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_party_details');
4002: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4003: FND_MSG_PUB.ADD;
4004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4001: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_party_details');

3997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3999: WHEN OTHERS THEN
4000: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4001: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_party_details');
4002: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4003: FND_MSG_PUB.ADD;
4004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4005: END find_party_details;

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

3998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3999: WHEN OTHERS THEN
4000: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4001: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_party_details');
4002: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4003: FND_MSG_PUB.ADD;
4004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4005: END find_party_details;
4006:

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

4113: RAISE FND_API.G_EXC_ERROR;
4114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4116: WHEN OTHERS THEN
4117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_parties');
4119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4120: FND_MSG_PUB.ADD;
4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_parties');

4114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4116: WHEN OTHERS THEN
4117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_parties');
4119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4120: FND_MSG_PUB.ADD;
4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4122: END find_duplicate_parties;

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

4115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4116: WHEN OTHERS THEN
4117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_parties');
4119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4120: FND_MSG_PUB.ADD;
4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4122: END find_duplicate_parties;
4123:

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

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

Line 4203: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_party_sites');

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

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

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

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

4287: RAISE FND_API.G_EXC_ERROR;
4288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4290: WHEN OTHERS THEN
4291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4292: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_contacts');
4293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4294: FND_MSG_PUB.ADD;
4295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4292: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_contacts');

4288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4290: WHEN OTHERS THEN
4291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4292: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_contacts');
4293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4294: FND_MSG_PUB.ADD;
4295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4296: END find_duplicate_contacts;

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

4289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4290: WHEN OTHERS THEN
4291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4292: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_contacts');
4293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4294: FND_MSG_PUB.ADD;
4295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4296: END find_duplicate_contacts;
4297:

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

4360: RAISE FND_API.G_EXC_ERROR;
4361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4363: WHEN OTHERS THEN
4364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4365: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_contact_points');
4366: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4367: FND_MSG_PUB.ADD;
4368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4365: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_contact_points');

4361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4363: WHEN OTHERS THEN
4364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4365: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_contact_points');
4366: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4367: FND_MSG_PUB.ADD;
4368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4369: END find_duplicate_contact_points;

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

4362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4363: WHEN OTHERS THEN
4364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4365: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_contact_points');
4366: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4367: FND_MSG_PUB.ADD;
4368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4369: END find_duplicate_contact_points;
4370:

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

4641: RAISE FND_API.G_EXC_ERROR;
4642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4644: WHEN OTHERS THEN
4645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4646: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.call_api_dynamic');
4647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4648: FND_MSG_PUB.ADD;
4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4646: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.call_api_dynamic');

4642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4644: WHEN OTHERS THEN
4645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4646: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.call_api_dynamic');
4647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4648: FND_MSG_PUB.ADD;
4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4650: END call_api_dynamic;

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

4643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4644: WHEN OTHERS THEN
4645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4646: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.call_api_dynamic');
4647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4648: FND_MSG_PUB.ADD;
4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4650: END call_api_dynamic;
4651:

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

4885: RAISE FND_API.G_EXC_ERROR;
4886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4888: WHEN OTHERS THEN
4889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4890: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_party_sites');
4891: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4892: FND_MSG_PUB.ADD;
4893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4890: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_party_sites');

4886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4888: WHEN OTHERS THEN
4889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4890: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_party_sites');
4891: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4892: FND_MSG_PUB.ADD;
4893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4894: END get_matching_party_sites;

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

4887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4888: WHEN OTHERS THEN
4889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4890: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_party_sites');
4891: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4892: FND_MSG_PUB.ADD;
4893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4894: END get_matching_party_sites;
4895:

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

5110: RAISE FND_API.G_EXC_ERROR;
5111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5113: WHEN OTHERS THEN
5114: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5115: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_contacts');
5116: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5117: FND_MSG_PUB.ADD;
5118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5115: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_contacts');

5111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5113: WHEN OTHERS THEN
5114: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5115: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_contacts');
5116: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5117: FND_MSG_PUB.ADD;
5118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5119: END get_matching_contacts;

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

5112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5113: WHEN OTHERS THEN
5114: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5115: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_contacts');
5116: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5117: FND_MSG_PUB.ADD;
5118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5119: END get_matching_contacts;
5120:

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

5249: RAISE FND_API.G_EXC_ERROR;
5250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5252: WHEN OTHERS THEN
5253: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5254: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_contact_points');
5255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5256: FND_MSG_PUB.ADD;
5257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5254: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_contact_points');

5250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5252: WHEN OTHERS THEN
5253: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5254: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_contact_points');
5255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5256: FND_MSG_PUB.ADD;
5257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5258: END get_matching_contact_points;

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

5251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5252: WHEN OTHERS THEN
5253: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5254: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_contact_points');
5255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5256: FND_MSG_PUB.ADD;
5257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5258: END get_matching_contact_points;
5259:

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

5472: RAISE FND_API.G_EXC_ERROR;
5473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5475: WHEN OTHERS THEN
5476: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5477: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_score_details');
5478: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5479: FND_MSG_PUB.ADD;
5480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5477: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_score_details');

5473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5475: WHEN OTHERS THEN
5476: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5477: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_score_details');
5478: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5479: FND_MSG_PUB.ADD;
5480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5481: END get_score_details;

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

5474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5475: WHEN OTHERS THEN
5476: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5477: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_score_details');
5478: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5479: FND_MSG_PUB.ADD;
5480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5481: END get_score_details;
5482:

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

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

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

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

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

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

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

5584: RAISE FND_API.G_EXC_ERROR;
5585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5587: WHEN OTHERS THEN
5588: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5589: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5590: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5591: FND_MSG_PUB.ADD;
5592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5587: WHEN OTHERS THEN
5588: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5589: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5590: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5591: FND_MSG_PUB.ADD;
5592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5593: END get_search_criteria;

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

5586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5587: WHEN OTHERS THEN
5588: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5589: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5590: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5591: FND_MSG_PUB.ADD;
5592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5593: END get_search_criteria;
5594:

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

5626: END IF;
5627:
5628: EXCEPTION
5629: WHEN OTHERS THEN
5630: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5631: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5632: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5633: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5634: FND_MSG_PUB.ADD;

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

5627:
5628: EXCEPTION
5629: WHEN OTHERS THEN
5630: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5631: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5632: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5633: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5634: FND_MSG_PUB.ADD;
5635: RAISE FND_API.G_EXC_ERROR;

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

5628: EXCEPTION
5629: WHEN OTHERS THEN
5630: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5631: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5632: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5633: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5634: FND_MSG_PUB.ADD;
5635: RAISE FND_API.G_EXC_ERROR;
5636: END get_party_rec;

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

5629: WHEN OTHERS THEN
5630: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5631: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5632: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5633: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5634: FND_MSG_PUB.ADD;
5635: RAISE FND_API.G_EXC_ERROR;
5636: END get_party_rec;
5637:

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

5692: END LOOP;
5693:
5694: EXCEPTION
5695: WHEN OTHERS THEN
5696: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5697: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5698: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5700: FND_MSG_PUB.ADD;

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

5693:
5694: EXCEPTION
5695: WHEN OTHERS THEN
5696: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5697: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5698: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5700: FND_MSG_PUB.ADD;
5701: RAISE FND_API.G_EXC_ERROR;

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

5694: EXCEPTION
5695: WHEN OTHERS THEN
5696: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5697: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5698: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5700: FND_MSG_PUB.ADD;
5701: RAISE FND_API.G_EXC_ERROR;
5702: END get_party_site_rec;

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

5695: WHEN OTHERS THEN
5696: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5697: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5698: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5700: FND_MSG_PUB.ADD;
5701: RAISE FND_API.G_EXC_ERROR;
5702: END get_party_site_rec;
5703:

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

5748: END LOOP;
5749:
5750: EXCEPTION
5751: WHEN OTHERS THEN
5752: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5753: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5754: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5755: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5756: FND_MSG_PUB.ADD;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

5852: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
5853: END IF;
5854: EXCEPTION
5855: WHEN OTHERS THEN
5856: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5857: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5858: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5859: FND_MSG_PUB.ADD;
5860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5853: END IF;
5854: EXCEPTION
5855: WHEN OTHERS THEN
5856: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5857: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5858: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5859: FND_MSG_PUB.ADD;
5860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5861: END;

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

5854: EXCEPTION
5855: WHEN OTHERS THEN
5856: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5857: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5858: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5859: FND_MSG_PUB.ADD;
5860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5861: END;
5862:

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

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

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

6123: END LOOP;
6124: EXCEPTION
6125: WHEN OTHERS THEN
6126: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6127: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6128: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6129: FND_MSG_PUB.ADD;
6130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6131: END;

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

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

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

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

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

6165: NULL;
6166: EXCEPTION
6167: WHEN OTHERS THEN
6168: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6169: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6170: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6171: FND_MSG_PUB.ADD;
6172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6173: END;

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

6166: EXCEPTION
6167: WHEN OTHERS THEN
6168: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6169: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6170: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6171: FND_MSG_PUB.ADD;
6172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6173: END;
6174:

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

6207: END IF;
6208: NULL;
6209: EXCEPTION
6210: WHEN OTHERS THEN
6211: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6212: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6213: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6214: FND_MSG_PUB.ADD;
6215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6208: NULL;
6209: EXCEPTION
6210: WHEN OTHERS THEN
6211: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6212: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6213: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6214: FND_MSG_PUB.ADD;
6215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6216: END;

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

6209: EXCEPTION
6210: WHEN OTHERS THEN
6211: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6212: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6213: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6214: FND_MSG_PUB.ADD;
6215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6216: END;
6217:

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

6269: EXCEPTION
6270: WHEN FND_API.G_EXC_ERROR THEN
6271: RAISE FND_API.G_EXC_ERROR;
6272: WHEN OTHERS THEN
6273: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6274: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6276: FND_MSG_PUB.ADD;
6277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6270: WHEN FND_API.G_EXC_ERROR THEN
6271: RAISE FND_API.G_EXC_ERROR;
6272: WHEN OTHERS THEN
6273: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6274: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6276: FND_MSG_PUB.ADD;
6277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6278: END check_prim_cond;

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

6271: RAISE FND_API.G_EXC_ERROR;
6272: WHEN OTHERS THEN
6273: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6274: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6276: FND_MSG_PUB.ADD;
6277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6278: END check_prim_cond;
6279:

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

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

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

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

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

6327: EXCEPTION
6328: WHEN OTHERS THEN
6329: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6330: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6331: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6332: FND_MSG_PUB.ADD;
6333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6334: END check_party_site_cond;
6335:

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

6363: NULL;
6364: END LOOP;
6365: EXCEPTION
6366: WHEN OTHERS THEN
6367: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6368: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6370: FND_MSG_PUB.ADD;
6371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

6386: x_secondary:= FALSE;
6387:
6388: FOR I IN 1..p_contact_point_list.COUNT LOOP
6389: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6390: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6391: FND_MSG_PUB.ADD;
6392: RAISE FND_API.G_EXC_ERROR;
6393: END IF;
6394: END LOOP;

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

6400: NULL;
6401: END LOOP;
6402: EXCEPTION
6403: WHEN OTHERS THEN
6404: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6405: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6407: FND_MSG_PUB.ADD;
6408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6401: END LOOP;
6402: EXCEPTION
6403: WHEN OTHERS THEN
6404: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6405: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6407: FND_MSG_PUB.ADD;
6408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6409: END check_contact_point_cond;

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

6402: EXCEPTION
6403: WHEN OTHERS THEN
6404: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6405: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6407: FND_MSG_PUB.ADD;
6408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6409: END check_contact_point_cond;
6410: