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

489: BEGIN
490: NULL ;
491: EXCEPTION
492: WHEN OTHERS THEN
493: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
494: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
495: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
496: FND_MSG_PUB.ADD;
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

490: NULL ;
491: EXCEPTION
492: WHEN OTHERS THEN
493: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
494: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
495: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
496: FND_MSG_PUB.ADD;
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END;

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

491: EXCEPTION
492: WHEN OTHERS THEN
493: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
494: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
495: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
496: FND_MSG_PUB.ADD;
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END;
499:

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

509: BEGIN
510: NULL ;
511: EXCEPTION
512: WHEN OTHERS THEN
513: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
514: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
516: FND_MSG_PUB.ADD;
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

510: NULL ;
511: EXCEPTION
512: WHEN OTHERS THEN
513: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
514: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
516: FND_MSG_PUB.ADD;
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END;

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

511: EXCEPTION
512: WHEN OTHERS THEN
513: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
514: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
516: FND_MSG_PUB.ADD;
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END;
519:

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

529: BEGIN
530: NULL ;
531: EXCEPTION
532: WHEN OTHERS THEN
533: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
534: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
536: FND_MSG_PUB.ADD;
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

530: NULL ;
531: EXCEPTION
532: WHEN OTHERS THEN
533: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
534: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
536: FND_MSG_PUB.ADD;
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: END;

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

531: EXCEPTION
532: WHEN OTHERS THEN
533: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
534: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
536: FND_MSG_PUB.ADD;
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: END;
539:

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

549: BEGIN
550: NULL ;
551: EXCEPTION
552: WHEN OTHERS THEN
553: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
554: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
555: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
556: FND_MSG_PUB.ADD;
557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

550: NULL ;
551: EXCEPTION
552: WHEN OTHERS THEN
553: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
554: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
555: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
556: FND_MSG_PUB.ADD;
557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
558: END;

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

551: EXCEPTION
552: WHEN OTHERS THEN
553: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
554: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
555: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
556: FND_MSG_PUB.ADD;
557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
558: END;
559:

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

618: IF NOT check_prim_cond (p_party_search_rec,
619: p_party_site_list,
620: p_contact_list,
621: p_contact_point_list) THEN
622: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
623: FND_MSG_PUB.ADD;
624: RAISE FND_API.G_EXC_ERROR;
625: END IF;
626: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

835: ELSE
836: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
837: END IF;
838: IF lengthb(l_party_contains_str) > 4000 THEN
839: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
840: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
841: FND_MSG_PUB.ADD;
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;

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

836: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
837: END IF;
838: IF lengthb(l_party_contains_str) > 4000 THEN
839: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
840: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
841: FND_MSG_PUB.ADD;
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;
844: IF (p_match_str = ' AND ' OR p_party_max_score

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

934: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
935: END LOOP;
936: -- Add the search criteria to query string
937: IF lengthb(l_contains_str) > 4000 THEN
938: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
939: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
940: FND_MSG_PUB.ADD;
941: RAISE FND_API.G_EXC_ERROR;
942: END IF;

Line 939: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');

935: END LOOP;
936: -- Add the search criteria to query string
937: IF lengthb(l_contains_str) > 4000 THEN
938: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
939: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
940: FND_MSG_PUB.ADD;
941: RAISE FND_API.G_EXC_ERROR;
942: END IF;
943: x_denorm_str := l_den_contains_str;

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

1154: END IF;
1155: exception
1156: when others then
1157: if (instrb(SQLERRM,'DRG-51030')>0) then
1158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1159: FND_MSG_PUB.ADD;
1160: RAISE FND_API.G_EXC_ERROR;
1161: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1159: FND_MSG_PUB.ADD;
1160: RAISE FND_API.G_EXC_ERROR;
1161: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1163: FND_MSG_PUB.ADD;
1164: RAISE FND_API.G_EXC_ERROR;
1165: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1163: FND_MSG_PUB.ADD;
1164: RAISE FND_API.G_EXC_ERROR;
1165: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1167: FND_MSG_PUB.ADD;
1168: RAISE FND_API.G_EXC_ERROR;
1169: else
1170: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1167: FND_MSG_PUB.ADD;
1168: RAISE FND_API.G_EXC_ERROR;
1169: else
1170: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1171: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1172: FND_MSG_PUB.ADD;
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1174: end if;

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

1167: FND_MSG_PUB.ADD;
1168: RAISE FND_API.G_EXC_ERROR;
1169: else
1170: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1171: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1172: FND_MSG_PUB.ADD;
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1174: end if;
1175: END;

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

1399: output_long_strings('Restrict Sql = '||p_restrict_sql);
1400: exception
1401: when others then
1402: if (instrb(SQLERRM,'DRG-51030')>0) then
1403: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1404: FND_MSG_PUB.ADD;
1405: RAISE FND_API.G_EXC_ERROR;
1406: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1403: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1404: FND_MSG_PUB.ADD;
1405: RAISE FND_API.G_EXC_ERROR;
1406: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1408: FND_MSG_PUB.ADD;
1409: RAISE FND_API.G_EXC_ERROR;
1410: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1411: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1408: FND_MSG_PUB.ADD;
1409: RAISE FND_API.G_EXC_ERROR;
1410: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1411: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1412: FND_MSG_PUB.ADD;
1413: RAISE FND_API.G_EXC_ERROR;
1414: else
1415: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1411: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1412: FND_MSG_PUB.ADD;
1413: RAISE FND_API.G_EXC_ERROR;
1414: else
1415: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1417: FND_MSG_PUB.ADD;
1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1419: end if;

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

1412: FND_MSG_PUB.ADD;
1413: RAISE FND_API.G_EXC_ERROR;
1414: else
1415: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1417: FND_MSG_PUB.ADD;
1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1419: end if;
1420: END;

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

1546: output_long_strings('Restrict Sql = '||p_restrict_sql);
1547: exception
1548: when others then
1549: if (instrb(SQLERRM,'DRG-51030')>0) then
1550: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1551: FND_MSG_PUB.ADD;
1552: RAISE FND_API.G_EXC_ERROR;
1553: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1550: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1551: FND_MSG_PUB.ADD;
1552: RAISE FND_API.G_EXC_ERROR;
1553: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1555: FND_MSG_PUB.ADD;
1556: RAISE FND_API.G_EXC_ERROR;
1557: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1558: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1555: FND_MSG_PUB.ADD;
1556: RAISE FND_API.G_EXC_ERROR;
1557: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1558: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1559: FND_MSG_PUB.ADD;
1560: RAISE FND_API.G_EXC_ERROR;
1561: else
1562: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1558: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1559: FND_MSG_PUB.ADD;
1560: RAISE FND_API.G_EXC_ERROR;
1561: else
1562: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1563: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1564: FND_MSG_PUB.ADD;
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: end if;

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

1559: FND_MSG_PUB.ADD;
1560: RAISE FND_API.G_EXC_ERROR;
1561: else
1562: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1563: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1564: FND_MSG_PUB.ADD;
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: end if;
1567: END;

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

1819: output_long_strings('Restrict Sql = '||p_restrict_sql);
1820: exception
1821: when others then
1822: if (instrb(SQLERRM,'DRG-51030')>0) then
1823: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1824: FND_MSG_PUB.ADD;
1825: RAISE FND_API.G_EXC_ERROR;
1826: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1827: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1823: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1824: FND_MSG_PUB.ADD;
1825: RAISE FND_API.G_EXC_ERROR;
1826: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1827: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1828: FND_MSG_PUB.ADD;
1829: RAISE FND_API.G_EXC_ERROR;
1830: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1831: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1827: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1828: FND_MSG_PUB.ADD;
1829: RAISE FND_API.G_EXC_ERROR;
1830: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1831: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1832: FND_MSG_PUB.ADD;
1833: RAISE FND_API.G_EXC_ERROR;
1834: else
1835: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1831: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1832: FND_MSG_PUB.ADD;
1833: RAISE FND_API.G_EXC_ERROR;
1834: else
1835: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1837: FND_MSG_PUB.ADD;
1838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1839: end if;

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

1832: FND_MSG_PUB.ADD;
1833: RAISE FND_API.G_EXC_ERROR;
1834: else
1835: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1837: FND_MSG_PUB.ADD;
1838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1839: end if;
1840: END;

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

2079: IF p_index>1 THEN
2080: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2081: 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);
2082: END IF;
2083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2084: FND_MSG_PUB.ADD;
2085: RAISE FND_API.G_EXC_ERROR;
2086: ELSE
2087: push_eval;

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

2127: IF p_index>1 THEN
2128: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2129: 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);
2130: END IF;
2131: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2132: FND_MSG_PUB.ADD;
2133: RAISE FND_API.G_EXC_ERROR;
2134: ELSE
2135: push_eval;

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

2200: IF p_index>1 THEN
2201: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2202: 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);
2203: END IF;
2204: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2205: FND_MSG_PUB.ADD;
2206: RAISE FND_API.G_EXC_ERROR;
2207: ELSE
2208: push_eval;

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

2312: IF p_index>1 THEN
2313: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2314: 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);
2315: END IF;
2316: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2317: FND_MSG_PUB.ADD;
2318: RAISE FND_API.G_EXC_ERROR;
2319: ELSE
2320: push_eval;

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

2423: IF p_index>1 THEN
2424: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2425: 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);
2426: END IF;
2427: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2428: FND_MSG_PUB.ADD;
2429: RAISE FND_API.G_EXC_ERROR;
2430: ELSE
2431: push_eval;

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

2567: ELSE
2568: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2569: 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);
2570: END IF;
2571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2572: FND_MSG_PUB.ADD;
2573: RAISE FND_API.G_EXC_ERROR;
2574: END IF;
2575: ELSE

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

2575: ELSE
2576: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2577: 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);
2578: END IF;
2579: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2580: FND_MSG_PUB.ADD;
2581: RAISE FND_API.G_EXC_ERROR;
2582: END IF;
2583: END IF;

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

2824: RAISE FND_API.G_EXC_ERROR;
2825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2827: WHEN OTHERS THEN
2828: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2829: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_parties');
2830: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2831: FND_MSG_PUB.ADD;
2832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2829: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_parties');

2825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2827: WHEN OTHERS THEN
2828: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2829: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_parties');
2830: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2831: FND_MSG_PUB.ADD;
2832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2833: END find_parties;

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

2826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2827: WHEN OTHERS THEN
2828: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2829: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_parties');
2830: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2831: FND_MSG_PUB.ADD;
2832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2833: END find_parties;
2834:

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

3013: IF p_index>1 THEN
3014: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3015: 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);
3016: END IF;
3017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3018: FND_MSG_PUB.ADD;
3019: RAISE FND_API.G_EXC_ERROR;
3020: ELSE
3021: push_eval;

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

3061: IF p_index>1 THEN
3062: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3063: 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);
3064: END IF;
3065: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3066: FND_MSG_PUB.ADD;
3067: RAISE FND_API.G_EXC_ERROR;
3068: ELSE
3069: push_eval;

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

3097: and d.search_context_id = p_search_ctx_id);
3098: exception
3099: when others then
3100: if (instrb(SQLERRM,'DRG-51030')>0) then
3101: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3102: FND_MSG_PUB.ADD;
3103: RAISE FND_API.G_EXC_ERROR;
3104: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3105: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3101: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3102: FND_MSG_PUB.ADD;
3103: RAISE FND_API.G_EXC_ERROR;
3104: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3105: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3106: FND_MSG_PUB.ADD;
3107: RAISE FND_API.G_EXC_ERROR;
3108: else
3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3173: IF p_index>1 THEN
3174: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3175: 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);
3176: END IF;
3177: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3178: FND_MSG_PUB.ADD;
3179: RAISE FND_API.G_EXC_ERROR;
3180: ELSE
3181: push_eval;

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

3362: IF p_index>1 THEN
3363: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3364: 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);
3365: END IF;
3366: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3367: FND_MSG_PUB.ADD;
3368: RAISE FND_API.G_EXC_ERROR;
3369: ELSE
3370: push_eval;

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

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

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

3458: ELSE
3459: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3460: 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);
3461: END IF;
3462: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3463: FND_MSG_PUB.ADD;
3464: RAISE FND_API.G_EXC_ERROR;
3465: END IF;
3466: END IF;

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

3605: RAISE FND_API.G_EXC_ERROR;
3606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3608: WHEN OTHERS THEN
3609: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3610: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_persons');
3611: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3612: FND_MSG_PUB.ADD;
3613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3610: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_persons');

3606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3608: WHEN OTHERS THEN
3609: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3610: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_persons');
3611: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3612: FND_MSG_PUB.ADD;
3613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3614: END find_persons;

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

3607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3608: WHEN OTHERS THEN
3609: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3610: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_persons');
3611: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3612: FND_MSG_PUB.ADD;
3613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3614: END find_persons;
3615:

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

3673: RAISE FND_API.G_EXC_ERROR;
3674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3676: WHEN OTHERS THEN
3677: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3678: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_party_details');
3679: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3680: FND_MSG_PUB.ADD;
3681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3678: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_party_details');

3674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3676: WHEN OTHERS THEN
3677: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3678: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_party_details');
3679: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3680: FND_MSG_PUB.ADD;
3681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3682: END find_party_details;

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

3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3676: WHEN OTHERS THEN
3677: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3678: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_party_details');
3679: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3680: FND_MSG_PUB.ADD;
3681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3682: END find_party_details;
3683:

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

3790: RAISE FND_API.G_EXC_ERROR;
3791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3793: WHEN OTHERS THEN
3794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3795: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_parties');
3796: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3797: FND_MSG_PUB.ADD;
3798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3795: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_parties');

3791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3793: WHEN OTHERS THEN
3794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3795: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_parties');
3796: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3797: FND_MSG_PUB.ADD;
3798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3799: END find_duplicate_parties;

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

3792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3793: WHEN OTHERS THEN
3794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3795: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_parties');
3796: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3797: FND_MSG_PUB.ADD;
3798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3799: END find_duplicate_parties;
3800:

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

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

Line 3880: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_party_sites');

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

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

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

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

3964: RAISE FND_API.G_EXC_ERROR;
3965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3967: WHEN OTHERS THEN
3968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3969: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contacts');
3970: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3971: FND_MSG_PUB.ADD;
3972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3969: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contacts');

3965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3967: WHEN OTHERS THEN
3968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3969: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contacts');
3970: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3971: FND_MSG_PUB.ADD;
3972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3973: END find_duplicate_contacts;

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

3966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3967: WHEN OTHERS THEN
3968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3969: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contacts');
3970: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3971: FND_MSG_PUB.ADD;
3972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3973: END find_duplicate_contacts;
3974:

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

4037: RAISE FND_API.G_EXC_ERROR;
4038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4040: WHEN OTHERS THEN
4041: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4042: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contact_points');
4043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4044: FND_MSG_PUB.ADD;
4045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4042: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contact_points');

4038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4040: WHEN OTHERS THEN
4041: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4042: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contact_points');
4043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4044: FND_MSG_PUB.ADD;
4045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4046: END find_duplicate_contact_points;

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

4039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4040: WHEN OTHERS THEN
4041: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4042: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contact_points');
4043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4044: FND_MSG_PUB.ADD;
4045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4046: END find_duplicate_contact_points;
4047:

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

4331: RAISE FND_API.G_EXC_ERROR;
4332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4334: WHEN OTHERS THEN
4335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.call_api_dynamic');
4337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4338: FND_MSG_PUB.ADD;
4339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.call_api_dynamic');

4332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4334: WHEN OTHERS THEN
4335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.call_api_dynamic');
4337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4338: FND_MSG_PUB.ADD;
4339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4340: END call_api_dynamic;

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

4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4334: WHEN OTHERS THEN
4335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.call_api_dynamic');
4337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4338: FND_MSG_PUB.ADD;
4339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4340: END call_api_dynamic;
4341:

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

4566: RAISE FND_API.G_EXC_ERROR;
4567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4569: WHEN OTHERS THEN
4570: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4571: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_party_sites');
4572: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4573: FND_MSG_PUB.ADD;
4574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4571: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_party_sites');

4567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4569: WHEN OTHERS THEN
4570: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4571: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_party_sites');
4572: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4573: FND_MSG_PUB.ADD;
4574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4575: END get_matching_party_sites;

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

4568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4569: WHEN OTHERS THEN
4570: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4571: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_party_sites');
4572: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4573: FND_MSG_PUB.ADD;
4574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4575: END get_matching_party_sites;
4576:

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

4794: RAISE FND_API.G_EXC_ERROR;
4795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4797: WHEN OTHERS THEN
4798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4799: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contacts');
4800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4801: FND_MSG_PUB.ADD;
4802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4799: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contacts');

4795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4797: WHEN OTHERS THEN
4798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4799: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contacts');
4800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4801: FND_MSG_PUB.ADD;
4802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4803: END get_matching_contacts;

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

4796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4797: WHEN OTHERS THEN
4798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4799: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contacts');
4800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4801: FND_MSG_PUB.ADD;
4802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4803: END get_matching_contacts;
4804:

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

4936: RAISE FND_API.G_EXC_ERROR;
4937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4939: WHEN OTHERS THEN
4940: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4941: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contact_points');
4942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4943: FND_MSG_PUB.ADD;
4944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4941: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contact_points');

4937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4939: WHEN OTHERS THEN
4940: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4941: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contact_points');
4942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4943: FND_MSG_PUB.ADD;
4944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4945: END get_matching_contact_points;

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

4938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4939: WHEN OTHERS THEN
4940: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4941: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contact_points');
4942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4943: FND_MSG_PUB.ADD;
4944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4945: END get_matching_contact_points;
4946:

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

5135: RAISE FND_API.G_EXC_ERROR;
5136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5138: WHEN OTHERS THEN
5139: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5140: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_score_details');
5141: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5142: FND_MSG_PUB.ADD;
5143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5140: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_score_details');

5136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5138: WHEN OTHERS THEN
5139: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5140: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_score_details');
5141: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5142: FND_MSG_PUB.ADD;
5143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5144: END get_score_details;

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

5137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5138: WHEN OTHERS THEN
5139: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5140: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_score_details');
5141: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5142: FND_MSG_PUB.ADD;
5143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5144: END get_score_details;
5145:

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

5210: RAISE FND_API.G_EXC_ERROR;
5211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5213: WHEN OTHERS THEN
5214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5215: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5217: FND_MSG_PUB.ADD;
5218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5213: WHEN OTHERS THEN
5214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5215: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5217: FND_MSG_PUB.ADD;
5218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5219: END get_party_for_search;

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

5212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5213: WHEN OTHERS THEN
5214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5215: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5217: FND_MSG_PUB.ADD;
5218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5219: END get_party_for_search;
5220:

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

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

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

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

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

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

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

5310: END IF;
5311:
5312: EXCEPTION
5313: WHEN OTHERS THEN
5314: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5315: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5316: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5318: FND_MSG_PUB.ADD;

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

5311:
5312: EXCEPTION
5313: WHEN OTHERS THEN
5314: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5315: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5316: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5318: FND_MSG_PUB.ADD;
5319: RAISE FND_API.G_EXC_ERROR;

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

5312: EXCEPTION
5313: WHEN OTHERS THEN
5314: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5315: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5316: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5318: FND_MSG_PUB.ADD;
5319: RAISE FND_API.G_EXC_ERROR;
5320: END get_party_rec;

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

5313: WHEN OTHERS THEN
5314: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5315: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5316: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5318: FND_MSG_PUB.ADD;
5319: RAISE FND_API.G_EXC_ERROR;
5320: END get_party_rec;
5321:

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

5362: END LOOP;
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_site_rec');
5368: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5370: FND_MSG_PUB.ADD;

Line 5367: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_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_site_rec');
5368: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_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',l_party_site_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_site_rec');
5368: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5370: FND_MSG_PUB.ADD;
5371: RAISE FND_API.G_EXC_ERROR;
5372: END get_party_site_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_site_rec');
5368: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5370: FND_MSG_PUB.ADD;
5371: RAISE FND_API.G_EXC_ERROR;
5372: END get_party_site_rec;
5373:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

5552: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
5553: END IF;
5554: EXCEPTION
5555: WHEN OTHERS THEN
5556: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5557: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5558: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5559: FND_MSG_PUB.ADD;
5560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5553: END IF;
5554: EXCEPTION
5555: WHEN OTHERS THEN
5556: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5557: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5558: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5559: FND_MSG_PUB.ADD;
5560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5561: END;

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

5554: EXCEPTION
5555: WHEN OTHERS THEN
5556: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5557: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5558: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5559: FND_MSG_PUB.ADD;
5560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5561: END;
5562:

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

5595: END IF;
5596: NULL;
5597: EXCEPTION
5598: WHEN OTHERS THEN
5599: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5600: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5602: FND_MSG_PUB.ADD;
5603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5596: NULL;
5597: EXCEPTION
5598: WHEN OTHERS THEN
5599: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5600: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5602: FND_MSG_PUB.ADD;
5603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5604: END;

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

5597: EXCEPTION
5598: WHEN OTHERS THEN
5599: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5600: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5602: FND_MSG_PUB.ADD;
5603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5604: END;
5605:

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

5637: END IF;
5638: NULL;
5639: EXCEPTION
5640: WHEN OTHERS THEN
5641: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5642: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5643: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5644: FND_MSG_PUB.ADD;
5645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5638: NULL;
5639: EXCEPTION
5640: WHEN OTHERS THEN
5641: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5642: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5643: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5644: FND_MSG_PUB.ADD;
5645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5646: END;

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

5639: EXCEPTION
5640: WHEN OTHERS THEN
5641: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5642: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5643: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5644: FND_MSG_PUB.ADD;
5645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5646: END;
5647:

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

5744: END IF;
5745: END LOOP;
5746: EXCEPTION
5747: WHEN OTHERS THEN
5748: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5749: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5750: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5751: FND_MSG_PUB.ADD;
5752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5745: END LOOP;
5746: EXCEPTION
5747: WHEN OTHERS THEN
5748: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5749: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5750: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5751: FND_MSG_PUB.ADD;
5752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5753: END;

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

5746: EXCEPTION
5747: WHEN OTHERS THEN
5748: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5749: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5750: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5751: FND_MSG_PUB.ADD;
5752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5753: END;
5754:

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

5771: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
5772: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
5773: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
5774: ) THEN
5775: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5776: FND_MSG_PUB.ADD;
5777: RAISE FND_API.G_EXC_ERROR;
5778: END IF;
5779: END LOOP;

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

5795: EXCEPTION
5796: WHEN FND_API.G_EXC_ERROR THEN
5797: RAISE FND_API.G_EXC_ERROR;
5798: WHEN OTHERS THEN
5799: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5800: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5801: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5802: FND_MSG_PUB.ADD;
5803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5796: WHEN FND_API.G_EXC_ERROR THEN
5797: RAISE FND_API.G_EXC_ERROR;
5798: WHEN OTHERS THEN
5799: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5800: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5801: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5802: FND_MSG_PUB.ADD;
5803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5804: END check_prim_cond;

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

5797: RAISE FND_API.G_EXC_ERROR;
5798: WHEN OTHERS THEN
5799: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5800: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5801: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5802: FND_MSG_PUB.ADD;
5803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5804: END check_prim_cond;
5805:

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

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

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

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

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

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

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

5889: EXIT WHEN x_secondary;
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_contact_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_contact_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_contact_cond');
5895: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5896: FND_MSG_PUB.ADD;
5897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5898: END check_contact_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_contact_cond');
5895: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5896: FND_MSG_PUB.ADD;
5897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5898: END check_contact_cond;
5899:

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

5912: x_secondary:= FALSE;
5913:
5914: FOR I IN 1..p_contact_point_list.COUNT LOOP
5915: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5916: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5917: FND_MSG_PUB.ADD;
5918: RAISE FND_API.G_EXC_ERROR;
5919: END IF;
5920: END LOOP;

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

5936: EXIT WHEN x_secondary;
5937: END LOOP;
5938: EXCEPTION
5939: WHEN OTHERS THEN
5940: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5941: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5943: FND_MSG_PUB.ADD;
5944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5937: END LOOP;
5938: EXCEPTION
5939: WHEN OTHERS THEN
5940: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5941: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5943: FND_MSG_PUB.ADD;
5944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5945: END check_contact_point_cond;

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

5938: EXCEPTION
5939: WHEN OTHERS THEN
5940: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5941: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5943: FND_MSG_PUB.ADD;
5944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5945: END check_contact_point_cond;
5946: