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

525: BEGIN
526: NULL ;
527: EXCEPTION
528: WHEN OTHERS THEN
529: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
530: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

526: NULL ;
527: EXCEPTION
528: WHEN OTHERS THEN
529: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
530: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: END;

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

527: EXCEPTION
528: WHEN OTHERS THEN
529: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
530: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: END;
535:

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

545: BEGIN
546: NULL ;
547: EXCEPTION
548: WHEN OTHERS THEN
549: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
550: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
552: FND_MSG_PUB.ADD;
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

546: NULL ;
547: EXCEPTION
548: WHEN OTHERS THEN
549: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
550: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
552: FND_MSG_PUB.ADD;
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END;

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

547: EXCEPTION
548: WHEN OTHERS THEN
549: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
550: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
552: FND_MSG_PUB.ADD;
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END;
555:

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

565: BEGIN
566: NULL ;
567: EXCEPTION
568: WHEN OTHERS THEN
569: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
570: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
572: FND_MSG_PUB.ADD;
573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

566: NULL ;
567: EXCEPTION
568: WHEN OTHERS THEN
569: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
570: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
572: FND_MSG_PUB.ADD;
573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: END;

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

567: EXCEPTION
568: WHEN OTHERS THEN
569: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
570: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
572: FND_MSG_PUB.ADD;
573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: END;
575:

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

585: BEGIN
586: NULL ;
587: EXCEPTION
588: WHEN OTHERS THEN
589: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
590: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
592: FND_MSG_PUB.ADD;
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

586: NULL ;
587: EXCEPTION
588: WHEN OTHERS THEN
589: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
590: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
592: FND_MSG_PUB.ADD;
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END;

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

587: EXCEPTION
588: WHEN OTHERS THEN
589: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
590: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
592: FND_MSG_PUB.ADD;
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END;
595:

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

654: IF NOT check_prim_cond (p_party_search_rec,
655: p_party_site_list,
656: p_contact_list,
657: p_contact_point_list) THEN
658: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
659: FND_MSG_PUB.ADD;
660: RAISE FND_API.G_EXC_ERROR;
661: END IF;
662: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

911: ELSE
912: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
913: END IF;
914: IF lengthb(l_party_contains_str) > 4000 THEN
915: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
916: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
917: FND_MSG_PUB.ADD;
918: RAISE FND_API.G_EXC_ERROR;
919: END IF;

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

912: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
913: END IF;
914: IF lengthb(l_party_contains_str) > 4000 THEN
915: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
916: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
917: FND_MSG_PUB.ADD;
918: RAISE FND_API.G_EXC_ERROR;
919: END IF;
920: IF (p_match_str = ' AND ' OR p_party_max_score

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

970: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
971: END LOOP;
972: -- Add the search criteria to query string
973: IF lengthb(l_contains_str) > 4000 THEN
974: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
975: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
976: FND_MSG_PUB.ADD;
977: RAISE FND_API.G_EXC_ERROR;
978: END IF;

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

971: END LOOP;
972: -- Add the search criteria to query string
973: IF lengthb(l_contains_str) > 4000 THEN
974: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
975: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
976: FND_MSG_PUB.ADD;
977: RAISE FND_API.G_EXC_ERROR;
978: END IF;
979: x_denorm_str := l_den_contains_str;

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

1238: END IF;
1239: exception
1240: when others then
1241: if (instrb(SQLERRM,'DRG-51030')>0) then
1242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1243: FND_MSG_PUB.ADD;
1244: RAISE FND_API.G_EXC_ERROR;
1245: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1246: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1243: FND_MSG_PUB.ADD;
1244: RAISE FND_API.G_EXC_ERROR;
1245: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1246: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1247: FND_MSG_PUB.ADD;
1248: RAISE FND_API.G_EXC_ERROR;
1249: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1250: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1246: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1247: FND_MSG_PUB.ADD;
1248: RAISE FND_API.G_EXC_ERROR;
1249: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1250: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1251: FND_MSG_PUB.ADD;
1252: RAISE FND_API.G_EXC_ERROR;
1253: else
1254: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1250: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1251: FND_MSG_PUB.ADD;
1252: RAISE FND_API.G_EXC_ERROR;
1253: else
1254: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1256: FND_MSG_PUB.ADD;
1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1258: end if;

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

1251: FND_MSG_PUB.ADD;
1252: RAISE FND_API.G_EXC_ERROR;
1253: else
1254: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1256: FND_MSG_PUB.ADD;
1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1258: end if;
1259: END;

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

1483: output_long_strings('Restrict Sql = '||p_restrict_sql);
1484: exception
1485: when others then
1486: if (instrb(SQLERRM,'DRG-51030')>0) then
1487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1488: FND_MSG_PUB.ADD;
1489: RAISE FND_API.G_EXC_ERROR;
1490: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1491: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1488: FND_MSG_PUB.ADD;
1489: RAISE FND_API.G_EXC_ERROR;
1490: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1491: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1492: FND_MSG_PUB.ADD;
1493: RAISE FND_API.G_EXC_ERROR;
1494: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1495: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1491: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1492: FND_MSG_PUB.ADD;
1493: RAISE FND_API.G_EXC_ERROR;
1494: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1495: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1496: FND_MSG_PUB.ADD;
1497: RAISE FND_API.G_EXC_ERROR;
1498: else
1499: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1495: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1496: FND_MSG_PUB.ADD;
1497: RAISE FND_API.G_EXC_ERROR;
1498: else
1499: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1500: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1501: FND_MSG_PUB.ADD;
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1503: end if;

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

1496: FND_MSG_PUB.ADD;
1497: RAISE FND_API.G_EXC_ERROR;
1498: else
1499: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1500: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1501: FND_MSG_PUB.ADD;
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1503: end if;
1504: END;

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

1630: output_long_strings('Restrict Sql = '||p_restrict_sql);
1631: exception
1632: when others then
1633: if (instrb(SQLERRM,'DRG-51030')>0) then
1634: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1635: FND_MSG_PUB.ADD;
1636: RAISE FND_API.G_EXC_ERROR;
1637: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1634: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1635: FND_MSG_PUB.ADD;
1636: RAISE FND_API.G_EXC_ERROR;
1637: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1639: FND_MSG_PUB.ADD;
1640: RAISE FND_API.G_EXC_ERROR;
1641: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1639: FND_MSG_PUB.ADD;
1640: RAISE FND_API.G_EXC_ERROR;
1641: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1643: FND_MSG_PUB.ADD;
1644: RAISE FND_API.G_EXC_ERROR;
1645: else
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1643: FND_MSG_PUB.ADD;
1644: RAISE FND_API.G_EXC_ERROR;
1645: else
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1648: FND_MSG_PUB.ADD;
1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1650: end if;

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

1643: FND_MSG_PUB.ADD;
1644: RAISE FND_API.G_EXC_ERROR;
1645: else
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1648: FND_MSG_PUB.ADD;
1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1650: end if;
1651: END;

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

1903: output_long_strings('Restrict Sql = '||p_restrict_sql);
1904: exception
1905: when others then
1906: if (instrb(SQLERRM,'DRG-51030')>0) then
1907: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1908: FND_MSG_PUB.ADD;
1909: RAISE FND_API.G_EXC_ERROR;
1910: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1907: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1908: FND_MSG_PUB.ADD;
1909: RAISE FND_API.G_EXC_ERROR;
1910: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1912: FND_MSG_PUB.ADD;
1913: RAISE FND_API.G_EXC_ERROR;
1914: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1915: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1912: FND_MSG_PUB.ADD;
1913: RAISE FND_API.G_EXC_ERROR;
1914: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1915: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1916: FND_MSG_PUB.ADD;
1917: RAISE FND_API.G_EXC_ERROR;
1918: else
1919: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1915: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1916: FND_MSG_PUB.ADD;
1917: RAISE FND_API.G_EXC_ERROR;
1918: else
1919: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1920: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1921: FND_MSG_PUB.ADD;
1922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1923: end if;

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

1916: FND_MSG_PUB.ADD;
1917: RAISE FND_API.G_EXC_ERROR;
1918: else
1919: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1920: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1921: FND_MSG_PUB.ADD;
1922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1923: end if;
1924: END;

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

2164: IF p_index>1 THEN
2165: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2166: 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);
2167: END IF;
2168: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2169: FND_MSG_PUB.ADD;
2170: RAISE FND_API.G_EXC_ERROR;
2171: ELSE
2172: push_eval;

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

2212: IF p_index>1 THEN
2213: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2214: 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);
2215: END IF;
2216: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2217: FND_MSG_PUB.ADD;
2218: RAISE FND_API.G_EXC_ERROR;
2219: ELSE
2220: push_eval;

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

2285: IF p_index>1 THEN
2286: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2287: 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);
2288: END IF;
2289: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2290: FND_MSG_PUB.ADD;
2291: RAISE FND_API.G_EXC_ERROR;
2292: ELSE
2293: push_eval;

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

2508: IF p_index>1 THEN
2509: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2510: 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);
2511: END IF;
2512: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2513: FND_MSG_PUB.ADD;
2514: RAISE FND_API.G_EXC_ERROR;
2515: ELSE
2516: push_eval;

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

2652: ELSE
2653: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2654: 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);
2655: END IF;
2656: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2657: FND_MSG_PUB.ADD;
2658: RAISE FND_API.G_EXC_ERROR;
2659: END IF;
2660: ELSE

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

2660: ELSE
2661: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2662: 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);
2663: END IF;
2664: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2665: FND_MSG_PUB.ADD;
2666: RAISE FND_API.G_EXC_ERROR;
2667: END IF;
2668: END IF;

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

2909: RAISE FND_API.G_EXC_ERROR;
2910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2912: WHEN OTHERS THEN
2913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2914: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_parties');
2915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2916: FND_MSG_PUB.ADD;
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2914: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_parties');

2910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2912: WHEN OTHERS THEN
2913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2914: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_parties');
2915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2916: FND_MSG_PUB.ADD;
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: END find_parties;

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

2911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2912: WHEN OTHERS THEN
2913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2914: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_parties');
2915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2916: FND_MSG_PUB.ADD;
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: END find_parties;
2919:

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

3099: IF p_index>1 THEN
3100: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3101: 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);
3102: END IF;
3103: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3104: FND_MSG_PUB.ADD;
3105: RAISE FND_API.G_EXC_ERROR;
3106: ELSE
3107: push_eval;

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

3147: IF p_index>1 THEN
3148: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3149: 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);
3150: END IF;
3151: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3152: FND_MSG_PUB.ADD;
3153: RAISE FND_API.G_EXC_ERROR;
3154: ELSE
3155: push_eval;

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

3183: and d.search_context_id = p_search_ctx_id);
3184: exception
3185: when others then
3186: if (instrb(SQLERRM,'DRG-51030')>0) then
3187: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3188: FND_MSG_PUB.ADD;
3189: RAISE FND_API.G_EXC_ERROR;
3190: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3187: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3188: FND_MSG_PUB.ADD;
3189: RAISE FND_API.G_EXC_ERROR;
3190: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3192: FND_MSG_PUB.ADD;
3193: RAISE FND_API.G_EXC_ERROR;
3194: else
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3259: IF p_index>1 THEN
3260: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3261: 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);
3262: END IF;
3263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3264: FND_MSG_PUB.ADD;
3265: RAISE FND_API.G_EXC_ERROR;
3266: ELSE
3267: push_eval;

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

3448: IF p_index>1 THEN
3449: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3450: 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);
3451: END IF;
3452: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3453: FND_MSG_PUB.ADD;
3454: RAISE FND_API.G_EXC_ERROR;
3455: ELSE
3456: push_eval;

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

3536: ELSE
3537: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3538: 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);
3539: END IF;
3540: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3541: FND_MSG_PUB.ADD;
3542: RAISE FND_API.G_EXC_ERROR;
3543: END IF;
3544: ELSE

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

3544: ELSE
3545: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3546: 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);
3547: END IF;
3548: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3549: FND_MSG_PUB.ADD;
3550: RAISE FND_API.G_EXC_ERROR;
3551: END IF;
3552: END IF;

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

3691: RAISE FND_API.G_EXC_ERROR;
3692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3694: WHEN OTHERS THEN
3695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3696: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_persons');
3697: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3698: FND_MSG_PUB.ADD;
3699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3696: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_persons');

3692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3694: WHEN OTHERS THEN
3695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3696: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_persons');
3697: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3698: FND_MSG_PUB.ADD;
3699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3700: END find_persons;

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

3693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3694: WHEN OTHERS THEN
3695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3696: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_persons');
3697: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3698: FND_MSG_PUB.ADD;
3699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3700: END find_persons;
3701:

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

3759: RAISE FND_API.G_EXC_ERROR;
3760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3762: WHEN OTHERS THEN
3763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3764: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_party_details');
3765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3766: FND_MSG_PUB.ADD;
3767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3764: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_party_details');

3760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3762: WHEN OTHERS THEN
3763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3764: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_party_details');
3765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3766: FND_MSG_PUB.ADD;
3767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3768: END find_party_details;

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

3761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3762: WHEN OTHERS THEN
3763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3764: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_party_details');
3765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3766: FND_MSG_PUB.ADD;
3767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3768: END find_party_details;
3769:

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

3876: RAISE FND_API.G_EXC_ERROR;
3877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3879: WHEN OTHERS THEN
3880: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3881: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_parties');
3882: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3883: FND_MSG_PUB.ADD;
3884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3881: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_parties');

3877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3879: WHEN OTHERS THEN
3880: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3881: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_parties');
3882: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3883: FND_MSG_PUB.ADD;
3884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3885: END find_duplicate_parties;

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

3878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3879: WHEN OTHERS THEN
3880: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3881: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_parties');
3882: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3883: FND_MSG_PUB.ADD;
3884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3885: END find_duplicate_parties;
3886:

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

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

Line 3966: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_party_sites');

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

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

3963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3964: WHEN OTHERS THEN
3965: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3966: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_party_sites');
3967: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3968: FND_MSG_PUB.ADD;
3969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3970: END find_duplicate_party_sites;
3971:

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

4050: RAISE FND_API.G_EXC_ERROR;
4051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4053: WHEN OTHERS THEN
4054: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4055: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contacts');
4056: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4057: FND_MSG_PUB.ADD;
4058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4055: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contacts');

4051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4053: WHEN OTHERS THEN
4054: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4055: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contacts');
4056: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4057: FND_MSG_PUB.ADD;
4058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4059: END find_duplicate_contacts;

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

4052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4053: WHEN OTHERS THEN
4054: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4055: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contacts');
4056: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4057: FND_MSG_PUB.ADD;
4058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4059: END find_duplicate_contacts;
4060:

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

4123: RAISE FND_API.G_EXC_ERROR;
4124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4126: WHEN OTHERS THEN
4127: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4128: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contact_points');
4129: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4130: FND_MSG_PUB.ADD;
4131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4128: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contact_points');

4124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4126: WHEN OTHERS THEN
4127: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4128: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contact_points');
4129: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4130: FND_MSG_PUB.ADD;
4131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4132: END find_duplicate_contact_points;

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

4125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4126: WHEN OTHERS THEN
4127: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4128: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contact_points');
4129: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4130: FND_MSG_PUB.ADD;
4131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4132: END find_duplicate_contact_points;
4133:

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

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

Line 4395: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.call_api_dynamic');

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

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

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

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

4623: RAISE FND_API.G_EXC_ERROR;
4624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4626: WHEN OTHERS THEN
4627: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4628: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_party_sites');
4629: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4630: FND_MSG_PUB.ADD;
4631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4628: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_party_sites');

4624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4626: WHEN OTHERS THEN
4627: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4628: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_party_sites');
4629: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4630: FND_MSG_PUB.ADD;
4631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4632: END get_matching_party_sites;

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

4625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4626: WHEN OTHERS THEN
4627: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4628: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_party_sites');
4629: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4630: FND_MSG_PUB.ADD;
4631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4632: END get_matching_party_sites;
4633:

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

4848: RAISE FND_API.G_EXC_ERROR;
4849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4851: WHEN OTHERS THEN
4852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4853: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contacts');
4854: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4855: FND_MSG_PUB.ADD;
4856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4853: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contacts');

4849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4851: WHEN OTHERS THEN
4852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4853: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contacts');
4854: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4855: FND_MSG_PUB.ADD;
4856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4857: END get_matching_contacts;

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

4850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4851: WHEN OTHERS THEN
4852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4853: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contacts');
4854: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4855: FND_MSG_PUB.ADD;
4856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4857: END get_matching_contacts;
4858:

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

4987: RAISE FND_API.G_EXC_ERROR;
4988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4990: WHEN OTHERS THEN
4991: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4992: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contact_points');
4993: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4994: FND_MSG_PUB.ADD;
4995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4992: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contact_points');

4988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4990: WHEN OTHERS THEN
4991: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4992: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contact_points');
4993: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4994: FND_MSG_PUB.ADD;
4995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4996: END get_matching_contact_points;

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

4989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4990: WHEN OTHERS THEN
4991: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4992: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contact_points');
4993: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4994: FND_MSG_PUB.ADD;
4995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4996: END get_matching_contact_points;
4997:

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

5185: RAISE FND_API.G_EXC_ERROR;
5186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5188: WHEN OTHERS THEN
5189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_score_details');
5191: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5192: FND_MSG_PUB.ADD;
5193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_score_details');

5186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5188: WHEN OTHERS THEN
5189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_score_details');
5191: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5192: FND_MSG_PUB.ADD;
5193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5194: END get_score_details;

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

5187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5188: WHEN OTHERS THEN
5189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_score_details');
5191: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5192: FND_MSG_PUB.ADD;
5193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5194: END get_score_details;
5195:

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

5263: RAISE FND_API.G_EXC_ERROR;
5264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5266: WHEN OTHERS THEN
5267: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5268: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5269: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5270: FND_MSG_PUB.ADD;
5271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5266: WHEN OTHERS THEN
5267: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5268: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5269: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5270: FND_MSG_PUB.ADD;
5271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5272: END get_party_for_search;

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

5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5266: WHEN OTHERS THEN
5267: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5268: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5269: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5270: FND_MSG_PUB.ADD;
5271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5272: END get_party_for_search;
5273:

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

5303: RAISE FND_API.G_EXC_ERROR;
5304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5306: WHEN OTHERS THEN
5307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5308: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5310: FND_MSG_PUB.ADD;
5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5306: WHEN OTHERS THEN
5307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5308: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5310: FND_MSG_PUB.ADD;
5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5312: END get_search_criteria;

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

5305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5306: WHEN OTHERS THEN
5307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5308: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5310: FND_MSG_PUB.ADD;
5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5312: END get_search_criteria;
5313:

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

5367: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
5368:
5369: EXCEPTION
5370: WHEN OTHERS THEN
5371: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5372: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5373: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5374: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5375: FND_MSG_PUB.ADD;

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

5368:
5369: EXCEPTION
5370: WHEN OTHERS THEN
5371: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5372: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5373: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5374: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5375: FND_MSG_PUB.ADD;
5376: RAISE FND_API.G_EXC_ERROR;

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

5369: EXCEPTION
5370: WHEN OTHERS THEN
5371: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5372: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5373: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5374: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5375: FND_MSG_PUB.ADD;
5376: RAISE FND_API.G_EXC_ERROR;
5377: END get_party_rec;

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

5370: WHEN OTHERS THEN
5371: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5372: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5373: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5374: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5375: FND_MSG_PUB.ADD;
5376: RAISE FND_API.G_EXC_ERROR;
5377: END get_party_rec;
5378:

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

5421: END LOOP;
5422:
5423: EXCEPTION
5424: WHEN OTHERS THEN
5425: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5426: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5427: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5428: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5429: FND_MSG_PUB.ADD;

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

5422:
5423: EXCEPTION
5424: WHEN OTHERS THEN
5425: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5426: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5427: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5428: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5429: FND_MSG_PUB.ADD;
5430: RAISE FND_API.G_EXC_ERROR;

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

5423: EXCEPTION
5424: WHEN OTHERS THEN
5425: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5426: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5427: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5428: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5429: FND_MSG_PUB.ADD;
5430: RAISE FND_API.G_EXC_ERROR;
5431: END get_party_site_rec;

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

5424: WHEN OTHERS THEN
5425: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5426: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5427: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5428: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5429: FND_MSG_PUB.ADD;
5430: RAISE FND_API.G_EXC_ERROR;
5431: END get_party_site_rec;
5432:

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

5477: END LOOP;
5478:
5479: EXCEPTION
5480: WHEN OTHERS THEN
5481: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5482: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5483: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5484: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5485: FND_MSG_PUB.ADD;

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

5478:
5479: EXCEPTION
5480: WHEN OTHERS THEN
5481: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5482: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5483: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5484: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5485: FND_MSG_PUB.ADD;
5486: RAISE FND_API.G_EXC_ERROR;

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

5479: EXCEPTION
5480: WHEN OTHERS THEN
5481: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5482: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5483: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5484: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5485: FND_MSG_PUB.ADD;
5486: RAISE FND_API.G_EXC_ERROR;
5487: END get_contact_rec;

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

5480: WHEN OTHERS THEN
5481: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5482: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5483: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5484: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5485: FND_MSG_PUB.ADD;
5486: RAISE FND_API.G_EXC_ERROR;
5487: END get_contact_rec;
5488:

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

5529: END LOOP;
5530:
5531: EXCEPTION
5532: WHEN OTHERS THEN
5533: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5534: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5535: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5536: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5537: FND_MSG_PUB.ADD;

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

5530:
5531: EXCEPTION
5532: WHEN OTHERS THEN
5533: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5534: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5535: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5536: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5537: FND_MSG_PUB.ADD;
5538: RAISE FND_API.G_EXC_ERROR;

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

5531: EXCEPTION
5532: WHEN OTHERS THEN
5533: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5534: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5535: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5536: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5537: FND_MSG_PUB.ADD;
5538: RAISE FND_API.G_EXC_ERROR;
5539: END get_contact_point_rec;

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

5532: WHEN OTHERS THEN
5533: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5534: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5535: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5536: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5537: FND_MSG_PUB.ADD;
5538: RAISE FND_API.G_EXC_ERROR;
5539: END get_contact_point_rec;
5540:

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

5650: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
5651: END IF;
5652: EXCEPTION
5653: WHEN OTHERS THEN
5654: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5655: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5656: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5657: FND_MSG_PUB.ADD;
5658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5651: END IF;
5652: EXCEPTION
5653: WHEN OTHERS THEN
5654: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5655: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5656: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5657: FND_MSG_PUB.ADD;
5658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5659: END;

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

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

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

5719: END IF;
5720: END LOOP;
5721: EXCEPTION
5722: WHEN OTHERS THEN
5723: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5724: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5726: FND_MSG_PUB.ADD;
5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5720: END LOOP;
5721: EXCEPTION
5722: WHEN OTHERS THEN
5723: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5724: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5726: FND_MSG_PUB.ADD;
5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5728: END;

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

5721: EXCEPTION
5722: WHEN OTHERS THEN
5723: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5724: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5726: FND_MSG_PUB.ADD;
5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5728: END;
5729:

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

5761: END IF;
5762: NULL;
5763: EXCEPTION
5764: WHEN OTHERS THEN
5765: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5766: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5767: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5768: FND_MSG_PUB.ADD;
5769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5762: NULL;
5763: EXCEPTION
5764: WHEN OTHERS THEN
5765: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5766: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5767: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5768: FND_MSG_PUB.ADD;
5769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5770: END;

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

5763: EXCEPTION
5764: WHEN OTHERS THEN
5765: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5766: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5767: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5768: FND_MSG_PUB.ADD;
5769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5770: END;
5771:

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

5804: END IF;
5805: NULL;
5806: EXCEPTION
5807: WHEN OTHERS THEN
5808: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5809: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5810: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5811: FND_MSG_PUB.ADD;
5812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5805: NULL;
5806: EXCEPTION
5807: WHEN OTHERS THEN
5808: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5809: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5810: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5811: FND_MSG_PUB.ADD;
5812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5813: END;

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

5806: EXCEPTION
5807: WHEN OTHERS THEN
5808: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5809: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5810: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5811: FND_MSG_PUB.ADD;
5812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5813: END;
5814:

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

5845: EXCEPTION
5846: WHEN FND_API.G_EXC_ERROR THEN
5847: RAISE FND_API.G_EXC_ERROR;
5848: WHEN OTHERS THEN
5849: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5850: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5852: FND_MSG_PUB.ADD;
5853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5846: WHEN FND_API.G_EXC_ERROR THEN
5847: RAISE FND_API.G_EXC_ERROR;
5848: WHEN OTHERS THEN
5849: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5850: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5852: FND_MSG_PUB.ADD;
5853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5854: END check_prim_cond;

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

5847: RAISE FND_API.G_EXC_ERROR;
5848: WHEN OTHERS THEN
5849: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5850: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5852: FND_MSG_PUB.ADD;
5853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5854: END check_prim_cond;
5855:

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

5889: NULL;
5890: END LOOP;
5891: EXCEPTION
5892: WHEN OTHERS THEN
5893: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5894: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5895: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5896: FND_MSG_PUB.ADD;
5897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5890: END LOOP;
5891: EXCEPTION
5892: WHEN OTHERS THEN
5893: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5894: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5895: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5896: FND_MSG_PUB.ADD;
5897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5898: END check_party_site_cond;

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

5891: EXCEPTION
5892: WHEN OTHERS THEN
5893: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5894: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5895: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5896: FND_MSG_PUB.ADD;
5897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5898: END check_party_site_cond;
5899:

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

5927: NULL;
5928: END LOOP;
5929: EXCEPTION
5930: WHEN OTHERS THEN
5931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5932: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5934: FND_MSG_PUB.ADD;
5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5928: END LOOP;
5929: EXCEPTION
5930: WHEN OTHERS THEN
5931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5932: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5934: FND_MSG_PUB.ADD;
5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5936: END check_contact_cond;

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

5929: EXCEPTION
5930: WHEN OTHERS THEN
5931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5932: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5934: FND_MSG_PUB.ADD;
5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5936: END check_contact_cond;
5937:

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

5950: x_secondary:= FALSE;
5951:
5952: FOR I IN 1..p_contact_point_list.COUNT LOOP
5953: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5954: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5955: FND_MSG_PUB.ADD;
5956: RAISE FND_API.G_EXC_ERROR;
5957: END IF;
5958: END LOOP;

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

5964: NULL;
5965: END LOOP;
5966: EXCEPTION
5967: WHEN OTHERS THEN
5968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5969: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5970: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5971: FND_MSG_PUB.ADD;
5972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5965: END LOOP;
5966: EXCEPTION
5967: WHEN OTHERS THEN
5968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5969: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5970: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5971: FND_MSG_PUB.ADD;
5972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5973: END check_contact_point_cond;

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

5966: EXCEPTION
5967: WHEN OTHERS THEN
5968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5969: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5970: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5971: FND_MSG_PUB.ADD;
5972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5973: END check_contact_point_cond;
5974: