DBA Data[Home] [Help]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2893: ELSE
2894: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2895: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2896: END IF;
2897: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2898: FND_MSG_PUB.ADD;
2899: RAISE FND_API.G_EXC_ERROR;
2900: END IF;
2901: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3935: WHEN OTHERS THEN
3936: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3937: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_persons');
3938: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3939: FND_MSG_PUB.ADD;
3940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3941: END find_persons;
3942:

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

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

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

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

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

4002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4003: WHEN OTHERS THEN
4004: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4005: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_party_details');
4006: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4007: FND_MSG_PUB.ADD;
4008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4009: END find_party_details;
4010:

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

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

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

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

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

4119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4120: WHEN OTHERS THEN
4121: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4122: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_parties');
4123: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4124: FND_MSG_PUB.ADD;
4125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4126: END find_duplicate_parties;
4127:

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

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

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

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

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

4204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4205: WHEN OTHERS THEN
4206: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4207: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_party_sites');
4208: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4209: FND_MSG_PUB.ADD;
4210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4211: END find_duplicate_party_sites;
4212:

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

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

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

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

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

4293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4294: WHEN OTHERS THEN
4295: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4296: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_contacts');
4297: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4298: FND_MSG_PUB.ADD;
4299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4300: END find_duplicate_contacts;
4301:

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

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

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

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

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

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

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

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

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

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

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

4647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4648: WHEN OTHERS THEN
4649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4650: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.call_api_dynamic');
4651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4652: FND_MSG_PUB.ADD;
4653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4654: END call_api_dynamic;
4655:

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

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

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

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

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

4891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4892: WHEN OTHERS THEN
4893: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4894: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_party_sites');
4895: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4896: FND_MSG_PUB.ADD;
4897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4898: END get_matching_party_sites;
4899:

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

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

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

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

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

5116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5117: WHEN OTHERS THEN
5118: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5119: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_contacts');
5120: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5121: FND_MSG_PUB.ADD;
5122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5123: END get_matching_contacts;
5124:

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

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

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

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

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

5255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5256: WHEN OTHERS THEN
5257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5258: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_contact_points');
5259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5260: FND_MSG_PUB.ADD;
5261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5262: END get_matching_contact_points;
5263:

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

5477: RAISE FND_API.G_EXC_ERROR;
5478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5480: WHEN OTHERS THEN
5481: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5482: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_score_details');
5483: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5484: FND_MSG_PUB.ADD;
5485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5480: WHEN OTHERS THEN
5481: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5482: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_score_details');
5483: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5484: FND_MSG_PUB.ADD;
5485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5486: END get_score_details;

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

5479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5480: WHEN OTHERS THEN
5481: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5482: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_score_details');
5483: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5484: FND_MSG_PUB.ADD;
5485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5486: END get_score_details;
5487:

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

5555: RAISE FND_API.G_EXC_ERROR;
5556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5558: WHEN OTHERS THEN
5559: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5560: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5561: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5562: FND_MSG_PUB.ADD;
5563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5558: WHEN OTHERS THEN
5559: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5560: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5561: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5562: FND_MSG_PUB.ADD;
5563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5564: END get_party_for_search;

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

5557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5558: WHEN OTHERS THEN
5559: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5560: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5561: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5562: FND_MSG_PUB.ADD;
5563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5564: END get_party_for_search;
5565:

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

5589: RAISE FND_API.G_EXC_ERROR;
5590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5592: WHEN OTHERS THEN
5593: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5594: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5595: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5596: FND_MSG_PUB.ADD;
5597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5592: WHEN OTHERS THEN
5593: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5594: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5595: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5596: FND_MSG_PUB.ADD;
5597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5598: END get_search_criteria;

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

5591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5592: WHEN OTHERS THEN
5593: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5594: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5595: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5596: FND_MSG_PUB.ADD;
5597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5598: END get_search_criteria;
5599:

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

5631: END IF;
5632:
5633: EXCEPTION
5634: WHEN OTHERS THEN
5635: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5636: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5637: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5638: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5639: FND_MSG_PUB.ADD;

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

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

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

5633: EXCEPTION
5634: WHEN OTHERS THEN
5635: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5636: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5637: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5638: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5639: FND_MSG_PUB.ADD;
5640: RAISE FND_API.G_EXC_ERROR;
5641: END get_party_rec;

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

5634: WHEN OTHERS THEN
5635: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5636: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5637: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5638: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5639: FND_MSG_PUB.ADD;
5640: RAISE FND_API.G_EXC_ERROR;
5641: END get_party_rec;
5642:

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

5697: END LOOP;
5698:
5699: EXCEPTION
5700: WHEN OTHERS THEN
5701: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5702: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5703: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5705: FND_MSG_PUB.ADD;

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

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

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

5699: EXCEPTION
5700: WHEN OTHERS THEN
5701: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5702: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5703: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5705: FND_MSG_PUB.ADD;
5706: RAISE FND_API.G_EXC_ERROR;
5707: END get_party_site_rec;

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

5700: WHEN OTHERS THEN
5701: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5702: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5703: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5705: FND_MSG_PUB.ADD;
5706: RAISE FND_API.G_EXC_ERROR;
5707: END get_party_site_rec;
5708:

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

5753: END LOOP;
5754:
5755: EXCEPTION
5756: WHEN OTHERS THEN
5757: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5758: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5759: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5761: FND_MSG_PUB.ADD;

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

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

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

5755: EXCEPTION
5756: WHEN OTHERS THEN
5757: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5758: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5759: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5761: FND_MSG_PUB.ADD;
5762: RAISE FND_API.G_EXC_ERROR;
5763: END get_contact_rec;

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

5756: WHEN OTHERS THEN
5757: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5758: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5759: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5761: FND_MSG_PUB.ADD;
5762: RAISE FND_API.G_EXC_ERROR;
5763: END get_contact_rec;
5764:

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

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

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

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

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

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

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

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

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

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

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

5858: END IF;
5859: EXCEPTION
5860: WHEN OTHERS THEN
5861: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5862: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5864: FND_MSG_PUB.ADD;
5865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5866: END;

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

5859: EXCEPTION
5860: WHEN OTHERS THEN
5861: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5862: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5864: FND_MSG_PUB.ADD;
5865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5866: END;
5867:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

6213: NULL;
6214: EXCEPTION
6215: WHEN OTHERS THEN
6216: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6217: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6218: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6219: FND_MSG_PUB.ADD;
6220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6221: END;

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

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

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

6274: EXCEPTION
6275: WHEN FND_API.G_EXC_ERROR THEN
6276: RAISE FND_API.G_EXC_ERROR;
6277: WHEN OTHERS THEN
6278: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6279: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6280: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6281: FND_MSG_PUB.ADD;
6282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

6370: EXCEPTION
6371: WHEN OTHERS THEN
6372: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6373: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6374: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6375: FND_MSG_PUB.ADD;
6376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6377: END check_contact_cond;
6378:

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

6391: x_secondary:= FALSE;
6392:
6393: FOR I IN 1..p_contact_point_list.COUNT LOOP
6394: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6395: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6396: FND_MSG_PUB.ADD;
6397: RAISE FND_API.G_EXC_ERROR;
6398: END IF;
6399: END LOOP;

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

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

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

6406: END LOOP;
6407: EXCEPTION
6408: WHEN OTHERS THEN
6409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6410: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6411: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6412: FND_MSG_PUB.ADD;
6413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6414: END check_contact_point_cond;

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

6407: EXCEPTION
6408: WHEN OTHERS THEN
6409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6410: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6411: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6412: FND_MSG_PUB.ADD;
6413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6414: END check_contact_point_cond;
6415: