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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3687: RAISE FND_API.G_EXC_ERROR;
3688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3690: WHEN OTHERS THEN
3691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3692: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_persons');
3693: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3694: FND_MSG_PUB.ADD;
3695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3690: WHEN OTHERS THEN
3691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3692: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_persons');
3693: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3694: FND_MSG_PUB.ADD;
3695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3696: END find_persons;

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

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

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

3755: RAISE FND_API.G_EXC_ERROR;
3756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3758: WHEN OTHERS THEN
3759: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3760: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_party_details');
3761: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3762: FND_MSG_PUB.ADD;
3763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3758: WHEN OTHERS THEN
3759: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3760: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_party_details');
3761: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3762: FND_MSG_PUB.ADD;
3763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3764: END find_party_details;

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

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

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

3872: RAISE FND_API.G_EXC_ERROR;
3873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3875: WHEN OTHERS THEN
3876: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3877: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_parties');
3878: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3879: FND_MSG_PUB.ADD;
3880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3875: WHEN OTHERS THEN
3876: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3877: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_parties');
3878: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3879: FND_MSG_PUB.ADD;
3880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3881: END find_duplicate_parties;

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

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

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

3957: RAISE FND_API.G_EXC_ERROR;
3958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3960: WHEN OTHERS THEN
3961: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3962: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_party_sites');
3963: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3964: FND_MSG_PUB.ADD;
3965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3960: WHEN OTHERS THEN
3961: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3962: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_party_sites');
3963: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3964: FND_MSG_PUB.ADD;
3965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3966: END find_duplicate_party_sites;

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

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

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

4046: RAISE FND_API.G_EXC_ERROR;
4047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4049: WHEN OTHERS THEN
4050: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4051: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contacts');
4052: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4053: FND_MSG_PUB.ADD;
4054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4049: WHEN OTHERS THEN
4050: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4051: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contacts');
4052: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4053: FND_MSG_PUB.ADD;
4054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4055: END find_duplicate_contacts;

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

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

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

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

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

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

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

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

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

4386: RAISE FND_API.G_EXC_ERROR;
4387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4389: WHEN OTHERS THEN
4390: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4391: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.call_api_dynamic');
4392: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4393: FND_MSG_PUB.ADD;
4394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4389: WHEN OTHERS THEN
4390: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4391: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.call_api_dynamic');
4392: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4393: FND_MSG_PUB.ADD;
4394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4395: END call_api_dynamic;

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

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

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

4619: RAISE FND_API.G_EXC_ERROR;
4620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4622: WHEN OTHERS THEN
4623: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4624: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_party_sites');
4625: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4626: FND_MSG_PUB.ADD;
4627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4622: WHEN OTHERS THEN
4623: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4624: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_party_sites');
4625: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4626: FND_MSG_PUB.ADD;
4627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4628: END get_matching_party_sites;

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

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

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

4844: RAISE FND_API.G_EXC_ERROR;
4845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4847: WHEN OTHERS THEN
4848: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4849: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contacts');
4850: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4851: FND_MSG_PUB.ADD;
4852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4847: WHEN OTHERS THEN
4848: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4849: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contacts');
4850: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4851: FND_MSG_PUB.ADD;
4852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4853: END get_matching_contacts;

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

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

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

4983: RAISE FND_API.G_EXC_ERROR;
4984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4986: WHEN OTHERS THEN
4987: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4988: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contact_points');
4989: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4990: FND_MSG_PUB.ADD;
4991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4986: WHEN OTHERS THEN
4987: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4988: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contact_points');
4989: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4990: FND_MSG_PUB.ADD;
4991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4992: END get_matching_contact_points;

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

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

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

5180: RAISE FND_API.G_EXC_ERROR;
5181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5183: WHEN OTHERS THEN
5184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5185: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_score_details');
5186: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5187: FND_MSG_PUB.ADD;
5188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5183: WHEN OTHERS THEN
5184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5185: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_score_details');
5186: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5187: FND_MSG_PUB.ADD;
5188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5189: END get_score_details;

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

5182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5183: WHEN OTHERS THEN
5184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5185: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_score_details');
5186: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5187: FND_MSG_PUB.ADD;
5188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5189: END get_score_details;
5190:

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

5258: RAISE FND_API.G_EXC_ERROR;
5259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5261: WHEN OTHERS THEN
5262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5263: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5264: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5265: FND_MSG_PUB.ADD;
5266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5261: WHEN OTHERS THEN
5262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5263: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5264: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5265: FND_MSG_PUB.ADD;
5266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5267: END get_party_for_search;

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

5260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5261: WHEN OTHERS THEN
5262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5263: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5264: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5265: FND_MSG_PUB.ADD;
5266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5267: END get_party_for_search;
5268:

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

5298: RAISE FND_API.G_EXC_ERROR;
5299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5301: WHEN OTHERS THEN
5302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5303: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5304: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5305: FND_MSG_PUB.ADD;
5306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5301: WHEN OTHERS THEN
5302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5303: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5304: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5305: FND_MSG_PUB.ADD;
5306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5307: END get_search_criteria;

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

5300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5301: WHEN OTHERS THEN
5302: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5303: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5304: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5305: FND_MSG_PUB.ADD;
5306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5307: END get_search_criteria;
5308:

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

5362: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
5363:
5364: EXCEPTION
5365: WHEN OTHERS THEN
5366: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5367: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5368: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5370: FND_MSG_PUB.ADD;

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

5363:
5364: EXCEPTION
5365: WHEN OTHERS THEN
5366: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5367: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5368: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5370: FND_MSG_PUB.ADD;
5371: RAISE FND_API.G_EXC_ERROR;

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

5364: EXCEPTION
5365: WHEN OTHERS THEN
5366: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5367: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5368: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5370: FND_MSG_PUB.ADD;
5371: RAISE FND_API.G_EXC_ERROR;
5372: END get_party_rec;

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

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

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

5416: END LOOP;
5417:
5418: EXCEPTION
5419: WHEN OTHERS THEN
5420: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5421: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5422: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5423: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5424: FND_MSG_PUB.ADD;

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

5417:
5418: EXCEPTION
5419: WHEN OTHERS THEN
5420: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5421: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5422: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5423: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5424: FND_MSG_PUB.ADD;
5425: RAISE FND_API.G_EXC_ERROR;

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

5418: EXCEPTION
5419: WHEN OTHERS THEN
5420: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5421: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5422: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5423: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5424: FND_MSG_PUB.ADD;
5425: RAISE FND_API.G_EXC_ERROR;
5426: END get_party_site_rec;

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

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

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

5472: END LOOP;
5473:
5474: EXCEPTION
5475: WHEN OTHERS THEN
5476: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5477: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5478: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5480: FND_MSG_PUB.ADD;

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

5473:
5474: EXCEPTION
5475: WHEN OTHERS THEN
5476: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5477: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5478: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5480: FND_MSG_PUB.ADD;
5481: RAISE FND_API.G_EXC_ERROR;

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

5474: EXCEPTION
5475: WHEN OTHERS THEN
5476: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5477: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5478: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5480: FND_MSG_PUB.ADD;
5481: RAISE FND_API.G_EXC_ERROR;
5482: END get_contact_rec;

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

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

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

5524: END LOOP;
5525:
5526: EXCEPTION
5527: WHEN OTHERS THEN
5528: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5529: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5530: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5532: FND_MSG_PUB.ADD;

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

5525:
5526: EXCEPTION
5527: WHEN OTHERS THEN
5528: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5529: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5530: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5532: FND_MSG_PUB.ADD;
5533: RAISE FND_API.G_EXC_ERROR;

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

5526: EXCEPTION
5527: WHEN OTHERS THEN
5528: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5529: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5530: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5532: FND_MSG_PUB.ADD;
5533: RAISE FND_API.G_EXC_ERROR;
5534: END get_contact_point_rec;

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

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

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

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

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

5646: END IF;
5647: EXCEPTION
5648: WHEN OTHERS THEN
5649: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5650: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5652: FND_MSG_PUB.ADD;
5653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5654: END;

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

5647: EXCEPTION
5648: WHEN OTHERS THEN
5649: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5650: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5652: FND_MSG_PUB.ADD;
5653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5654: END;
5655:

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

5714: END IF;
5715: END LOOP;
5716: EXCEPTION
5717: WHEN OTHERS THEN
5718: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5719: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5720: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5721: FND_MSG_PUB.ADD;
5722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5715: END LOOP;
5716: EXCEPTION
5717: WHEN OTHERS THEN
5718: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5719: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5720: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5721: FND_MSG_PUB.ADD;
5722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5723: END;

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

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

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

5756: END IF;
5757: NULL;
5758: EXCEPTION
5759: WHEN OTHERS THEN
5760: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5761: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5762: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5763: FND_MSG_PUB.ADD;
5764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5757: NULL;
5758: EXCEPTION
5759: WHEN OTHERS THEN
5760: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5761: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5762: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5763: FND_MSG_PUB.ADD;
5764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5765: END;

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

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

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

5799: END IF;
5800: NULL;
5801: EXCEPTION
5802: WHEN OTHERS THEN
5803: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5804: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5805: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5806: FND_MSG_PUB.ADD;
5807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5800: NULL;
5801: EXCEPTION
5802: WHEN OTHERS THEN
5803: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5804: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5805: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5806: FND_MSG_PUB.ADD;
5807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5808: END;

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

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

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

5840: EXCEPTION
5841: WHEN FND_API.G_EXC_ERROR THEN
5842: RAISE FND_API.G_EXC_ERROR;
5843: WHEN OTHERS THEN
5844: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5845: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5846: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5847: FND_MSG_PUB.ADD;
5848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5841: WHEN FND_API.G_EXC_ERROR THEN
5842: RAISE FND_API.G_EXC_ERROR;
5843: WHEN OTHERS THEN
5844: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5845: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5846: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5847: FND_MSG_PUB.ADD;
5848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5849: END check_prim_cond;

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

5842: RAISE FND_API.G_EXC_ERROR;
5843: WHEN OTHERS THEN
5844: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5845: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5846: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5847: FND_MSG_PUB.ADD;
5848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5849: END check_prim_cond;
5850:

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

5884: NULL;
5885: END LOOP;
5886: EXCEPTION
5887: WHEN OTHERS THEN
5888: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5889: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5890: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5891: FND_MSG_PUB.ADD;
5892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5885: END LOOP;
5886: EXCEPTION
5887: WHEN OTHERS THEN
5888: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5889: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5890: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5891: FND_MSG_PUB.ADD;
5892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5893: END check_party_site_cond;

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

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

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

5922: NULL;
5923: END LOOP;
5924: EXCEPTION
5925: WHEN OTHERS THEN
5926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5927: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5928: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5929: FND_MSG_PUB.ADD;
5930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5923: END LOOP;
5924: EXCEPTION
5925: WHEN OTHERS THEN
5926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5927: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5928: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5929: FND_MSG_PUB.ADD;
5930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5931: END check_contact_cond;

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

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

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

5945: x_secondary:= FALSE;
5946:
5947: FOR I IN 1..p_contact_point_list.COUNT LOOP
5948: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5949: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5950: FND_MSG_PUB.ADD;
5951: RAISE FND_API.G_EXC_ERROR;
5952: END IF;
5953: END LOOP;

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

5959: NULL;
5960: END LOOP;
5961: EXCEPTION
5962: WHEN OTHERS THEN
5963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5964: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5966: FND_MSG_PUB.ADD;
5967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5960: END LOOP;
5961: EXCEPTION
5962: WHEN OTHERS THEN
5963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5964: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5966: FND_MSG_PUB.ADD;
5967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5968: END check_contact_point_cond;

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

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