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.

[Home] [Help]

APPS.HZ_MATCH_RULE_42 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 1387: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

1383: BEGIN
1384: NULL ;
1385: EXCEPTION
1386: WHEN OTHERS THEN
1387: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1388: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1389: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1390: FND_MSG_PUB.ADD;
1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1384: NULL ;
1385: EXCEPTION
1386: WHEN OTHERS THEN
1387: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1388: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1389: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1390: FND_MSG_PUB.ADD;
1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1392: END;

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

1385: EXCEPTION
1386: WHEN OTHERS THEN
1387: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1388: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1389: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1390: FND_MSG_PUB.ADD;
1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1392: END;
1393:

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

1408: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,p_search_list(1).COUNTRY);
1409: END IF ;
1410: EXCEPTION
1411: WHEN OTHERS THEN
1412: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1413: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1415: FND_MSG_PUB.ADD;
1416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1409: END IF ;
1410: EXCEPTION
1411: WHEN OTHERS THEN
1412: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1413: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1415: FND_MSG_PUB.ADD;
1416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1417: END;

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

1410: EXCEPTION
1411: WHEN OTHERS THEN
1412: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1413: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1415: FND_MSG_PUB.ADD;
1416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1417: END;
1418:

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

1428: BEGIN
1429: NULL ;
1430: EXCEPTION
1431: WHEN OTHERS THEN
1432: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1433: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1435: FND_MSG_PUB.ADD;
1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1429: NULL ;
1430: EXCEPTION
1431: WHEN OTHERS THEN
1432: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1433: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1435: FND_MSG_PUB.ADD;
1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1437: END;

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

1430: EXCEPTION
1431: WHEN OTHERS THEN
1432: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1433: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1435: FND_MSG_PUB.ADD;
1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1437: END;
1438:

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

1448: BEGIN
1449: NULL ;
1450: EXCEPTION
1451: WHEN OTHERS THEN
1452: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1453: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1454: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1455: FND_MSG_PUB.ADD;
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1449: NULL ;
1450: EXCEPTION
1451: WHEN OTHERS THEN
1452: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1453: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1454: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1455: FND_MSG_PUB.ADD;
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END;

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

1450: EXCEPTION
1451: WHEN OTHERS THEN
1452: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1453: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1454: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1455: FND_MSG_PUB.ADD;
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END;
1458:

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

1517: IF NOT check_prim_cond (p_party_search_rec,
1518: p_party_site_list,
1519: p_contact_list,
1520: p_contact_point_list) THEN
1521: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1522: FND_MSG_PUB.ADD;
1523: RAISE FND_API.G_EXC_ERROR;
1524: END IF;
1525: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1904: ELSE
1905: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1906: END IF;
1907: IF lengthb(l_party_contains_str) > 4000 THEN
1908: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1909: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1910: FND_MSG_PUB.ADD;
1911: RAISE FND_API.G_EXC_ERROR;
1912: END IF;

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

1905: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1906: END IF;
1907: IF lengthb(l_party_contains_str) > 4000 THEN
1908: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1909: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1910: FND_MSG_PUB.ADD;
1911: RAISE FND_API.G_EXC_ERROR;
1912: END IF;
1913: IF (p_match_str = ' AND ' OR p_party_max_score

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

2023: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2024: END LOOP;
2025: -- Add the search criteria to query string
2026: IF lengthb(l_contains_str) > 4000 THEN
2027: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2028: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
2029: FND_MSG_PUB.ADD;
2030: RAISE FND_API.G_EXC_ERROR;
2031: END IF;

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

2024: END LOOP;
2025: -- Add the search criteria to query string
2026: IF lengthb(l_contains_str) > 4000 THEN
2027: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2028: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
2029: FND_MSG_PUB.ADD;
2030: RAISE FND_API.G_EXC_ERROR;
2031: END IF;
2032: x_denorm_str := l_den_contains_str;

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

2067: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2068: END LOOP;
2069: -- Add the search criteria to query string
2070: IF lengthb(l_contains_str) > 4000 THEN
2071: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2072: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
2073: FND_MSG_PUB.ADD;
2074: RAISE FND_API.G_EXC_ERROR;
2075: END IF;

Line 2072: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');

2068: END LOOP;
2069: -- Add the search criteria to query string
2070: IF lengthb(l_contains_str) > 4000 THEN
2071: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2072: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
2073: FND_MSG_PUB.ADD;
2074: RAISE FND_API.G_EXC_ERROR;
2075: END IF;
2076: x_denorm_str := l_den_contains_str;

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

2148: END IF;
2149: END LOOP;
2150: -- Add the search criteria to query string
2151: IF lengthb(l_contains_str) > 4000 THEN
2152: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2153: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
2154: FND_MSG_PUB.ADD;
2155: RAISE FND_API.G_EXC_ERROR;
2156: END IF;

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

2149: END LOOP;
2150: -- Add the search criteria to query string
2151: IF lengthb(l_contains_str) > 4000 THEN
2152: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2153: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
2154: FND_MSG_PUB.ADD;
2155: RAISE FND_API.G_EXC_ERROR;
2156: END IF;
2157: x_denorm_str := l_den_contains_str;

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

2472: END IF;
2473: exception
2474: when others then
2475: if (instrb(SQLERRM,'DRG-51030')>0) then
2476: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2477: FND_MSG_PUB.ADD;
2478: RAISE FND_API.G_EXC_ERROR;
2479: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2480: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2476: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2477: FND_MSG_PUB.ADD;
2478: RAISE FND_API.G_EXC_ERROR;
2479: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2480: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2481: FND_MSG_PUB.ADD;
2482: RAISE FND_API.G_EXC_ERROR;
2483: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2484: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2480: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2481: FND_MSG_PUB.ADD;
2482: RAISE FND_API.G_EXC_ERROR;
2483: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2484: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2485: FND_MSG_PUB.ADD;
2486: RAISE FND_API.G_EXC_ERROR;
2487: else
2488: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2484: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2485: FND_MSG_PUB.ADD;
2486: RAISE FND_API.G_EXC_ERROR;
2487: else
2488: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2490: FND_MSG_PUB.ADD;
2491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2492: end if;

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

2485: FND_MSG_PUB.ADD;
2486: RAISE FND_API.G_EXC_ERROR;
2487: else
2488: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2489: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2490: FND_MSG_PUB.ADD;
2491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2492: end if;
2493: END;

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

2717: output_long_strings('Restrict Sql = '||p_restrict_sql);
2718: exception
2719: when others then
2720: if (instrb(SQLERRM,'DRG-51030')>0) then
2721: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2722: FND_MSG_PUB.ADD;
2723: RAISE FND_API.G_EXC_ERROR;
2724: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2725: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2721: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2722: FND_MSG_PUB.ADD;
2723: RAISE FND_API.G_EXC_ERROR;
2724: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2725: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2726: FND_MSG_PUB.ADD;
2727: RAISE FND_API.G_EXC_ERROR;
2728: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2729: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2725: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2726: FND_MSG_PUB.ADD;
2727: RAISE FND_API.G_EXC_ERROR;
2728: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2729: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2730: FND_MSG_PUB.ADD;
2731: RAISE FND_API.G_EXC_ERROR;
2732: else
2733: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2729: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2730: FND_MSG_PUB.ADD;
2731: RAISE FND_API.G_EXC_ERROR;
2732: else
2733: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2734: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2735: FND_MSG_PUB.ADD;
2736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2737: end if;

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

2730: FND_MSG_PUB.ADD;
2731: RAISE FND_API.G_EXC_ERROR;
2732: else
2733: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2734: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2735: FND_MSG_PUB.ADD;
2736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2737: end if;
2738: END;

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

2864: output_long_strings('Restrict Sql = '||p_restrict_sql);
2865: exception
2866: when others then
2867: if (instrb(SQLERRM,'DRG-51030')>0) then
2868: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2869: FND_MSG_PUB.ADD;
2870: RAISE FND_API.G_EXC_ERROR;
2871: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2872: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2868: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2869: FND_MSG_PUB.ADD;
2870: RAISE FND_API.G_EXC_ERROR;
2871: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2872: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2873: FND_MSG_PUB.ADD;
2874: RAISE FND_API.G_EXC_ERROR;
2875: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2876: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2872: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2873: FND_MSG_PUB.ADD;
2874: RAISE FND_API.G_EXC_ERROR;
2875: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2876: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2877: FND_MSG_PUB.ADD;
2878: RAISE FND_API.G_EXC_ERROR;
2879: else
2880: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2876: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2877: FND_MSG_PUB.ADD;
2878: RAISE FND_API.G_EXC_ERROR;
2879: else
2880: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2881: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2882: FND_MSG_PUB.ADD;
2883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2884: end if;

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

2877: FND_MSG_PUB.ADD;
2878: RAISE FND_API.G_EXC_ERROR;
2879: else
2880: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2881: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2882: FND_MSG_PUB.ADD;
2883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2884: end if;
2885: END;

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

3137: output_long_strings('Restrict Sql = '||p_restrict_sql);
3138: exception
3139: when others then
3140: if (instrb(SQLERRM,'DRG-51030')>0) then
3141: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3142: FND_MSG_PUB.ADD;
3143: RAISE FND_API.G_EXC_ERROR;
3144: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3145: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3141: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3142: FND_MSG_PUB.ADD;
3143: RAISE FND_API.G_EXC_ERROR;
3144: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3145: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3146: FND_MSG_PUB.ADD;
3147: RAISE FND_API.G_EXC_ERROR;
3148: elsif (instrb(SQLERRM,'ORA-20000')>0) then
3149: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3145: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3146: FND_MSG_PUB.ADD;
3147: RAISE FND_API.G_EXC_ERROR;
3148: elsif (instrb(SQLERRM,'ORA-20000')>0) then
3149: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3150: FND_MSG_PUB.ADD;
3151: RAISE FND_API.G_EXC_ERROR;
3152: else
3153: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

3149: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3150: FND_MSG_PUB.ADD;
3151: RAISE FND_API.G_EXC_ERROR;
3152: else
3153: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3154: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3155: FND_MSG_PUB.ADD;
3156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3157: end if;

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

3150: FND_MSG_PUB.ADD;
3151: RAISE FND_API.G_EXC_ERROR;
3152: else
3153: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3154: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3155: FND_MSG_PUB.ADD;
3156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3157: end if;
3158: END;

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

3415: IF p_index>1 THEN
3416: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3417: 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);
3418: END IF;
3419: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3420: FND_MSG_PUB.ADD;
3421: RAISE FND_API.G_EXC_ERROR;
3422: ELSE
3423: push_eval;

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

3463: IF p_index>1 THEN
3464: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3465: 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);
3466: END IF;
3467: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3468: FND_MSG_PUB.ADD;
3469: RAISE FND_API.G_EXC_ERROR;
3470: ELSE
3471: push_eval;

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

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

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

3648: IF p_index>1 THEN
3649: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3650: 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);
3651: END IF;
3652: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3653: FND_MSG_PUB.ADD;
3654: RAISE FND_API.G_EXC_ERROR;
3655: ELSE
3656: push_eval;

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

3759: IF p_index>1 THEN
3760: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3761: 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);
3762: END IF;
3763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3764: FND_MSG_PUB.ADD;
3765: RAISE FND_API.G_EXC_ERROR;
3766: ELSE
3767: push_eval;

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

3984: ELSE
3985: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3986: 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);
3987: END IF;
3988: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3989: FND_MSG_PUB.ADD;
3990: RAISE FND_API.G_EXC_ERROR;
3991: END IF;
3992: ELSE

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

3992: ELSE
3993: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3994: 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);
3995: END IF;
3996: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3997: FND_MSG_PUB.ADD;
3998: RAISE FND_API.G_EXC_ERROR;
3999: END IF;
4000: END IF;

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

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

Line 4203: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_parties');

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

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

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

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

4405: IF p_index>1 THEN
4406: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4407: 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);
4408: END IF;
4409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4410: FND_MSG_PUB.ADD;
4411: RAISE FND_API.G_EXC_ERROR;
4412: ELSE
4413: push_eval;

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

4453: IF p_index>1 THEN
4454: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4455: 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);
4456: END IF;
4457: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4458: FND_MSG_PUB.ADD;
4459: RAISE FND_API.G_EXC_ERROR;
4460: ELSE
4461: push_eval;

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

4489: and d.search_context_id = p_search_ctx_id);
4490: exception
4491: when others then
4492: if (instrb(SQLERRM,'DRG-51030')>0) then
4493: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
4494: FND_MSG_PUB.ADD;
4495: RAISE FND_API.G_EXC_ERROR;
4496: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

4493: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
4494: FND_MSG_PUB.ADD;
4495: RAISE FND_API.G_EXC_ERROR;
4496: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4498: FND_MSG_PUB.ADD;
4499: RAISE FND_API.G_EXC_ERROR;
4500: else
4501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4565: IF p_index>1 THEN
4566: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4567: 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);
4568: END IF;
4569: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4570: FND_MSG_PUB.ADD;
4571: RAISE FND_API.G_EXC_ERROR;
4572: ELSE
4573: push_eval;

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

4824: IF p_index>1 THEN
4825: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4826: 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);
4827: END IF;
4828: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4829: FND_MSG_PUB.ADD;
4830: RAISE FND_API.G_EXC_ERROR;
4831: ELSE
4832: push_eval;

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

4937: ELSE
4938: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4939: 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);
4940: END IF;
4941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4942: FND_MSG_PUB.ADD;
4943: RAISE FND_API.G_EXC_ERROR;
4944: END IF;
4945: ELSE

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

4945: ELSE
4946: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4947: 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);
4948: END IF;
4949: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4950: FND_MSG_PUB.ADD;
4951: RAISE FND_API.G_EXC_ERROR;
4952: END IF;
4953: END IF;

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

5066: RAISE FND_API.G_EXC_ERROR;
5067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5069: WHEN OTHERS THEN
5070: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5071: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_persons');
5072: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5073: FND_MSG_PUB.ADD;
5074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5071: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_persons');

5067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5069: WHEN OTHERS THEN
5070: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5071: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_persons');
5072: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5073: FND_MSG_PUB.ADD;
5074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5075: END find_persons;

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

5068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5069: WHEN OTHERS THEN
5070: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5071: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_persons');
5072: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5073: FND_MSG_PUB.ADD;
5074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5075: END find_persons;
5076:

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

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

Line 5139: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_party_details');

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

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

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

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

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

Line 5256: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_parties');

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

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

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

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

5336: RAISE FND_API.G_EXC_ERROR;
5337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5339: WHEN OTHERS THEN
5340: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5341: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_party_sites');
5342: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5343: FND_MSG_PUB.ADD;
5344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5341: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_party_sites');

5337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5339: WHEN OTHERS THEN
5340: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5341: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_party_sites');
5342: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5343: FND_MSG_PUB.ADD;
5344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5345: END find_duplicate_party_sites;

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

5338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5339: WHEN OTHERS THEN
5340: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5341: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_party_sites');
5342: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5343: FND_MSG_PUB.ADD;
5344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5345: END find_duplicate_party_sites;
5346:

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

5425: RAISE FND_API.G_EXC_ERROR;
5426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5428: WHEN OTHERS THEN
5429: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5430: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contacts');
5431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5432: FND_MSG_PUB.ADD;
5433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5430: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contacts');

5426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5428: WHEN OTHERS THEN
5429: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5430: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contacts');
5431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5432: FND_MSG_PUB.ADD;
5433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5434: END find_duplicate_contacts;

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

5427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5428: WHEN OTHERS THEN
5429: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5430: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contacts');
5431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5432: FND_MSG_PUB.ADD;
5433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5434: END find_duplicate_contacts;
5435:

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

5498: RAISE FND_API.G_EXC_ERROR;
5499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5501: WHEN OTHERS THEN
5502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5503: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contact_points');
5504: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5505: FND_MSG_PUB.ADD;
5506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5503: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contact_points');

5499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5501: WHEN OTHERS THEN
5502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5503: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contact_points');
5504: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5505: FND_MSG_PUB.ADD;
5506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5507: END find_duplicate_contact_points;

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

5500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5501: WHEN OTHERS THEN
5502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5503: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.find_duplicate_contact_points');
5504: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5505: FND_MSG_PUB.ADD;
5506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5507: END find_duplicate_contact_points;
5508:

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

5918: RAISE FND_API.G_EXC_ERROR;
5919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5921: WHEN OTHERS THEN
5922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.call_api_dynamic');
5924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5925: FND_MSG_PUB.ADD;
5926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.call_api_dynamic');

5919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5921: WHEN OTHERS THEN
5922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.call_api_dynamic');
5924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5925: FND_MSG_PUB.ADD;
5926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5927: END call_api_dynamic;

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

5920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5921: WHEN OTHERS THEN
5922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.call_api_dynamic');
5924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5925: FND_MSG_PUB.ADD;
5926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5927: END call_api_dynamic;
5928:

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

6160: RAISE FND_API.G_EXC_ERROR;
6161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6163: WHEN OTHERS THEN
6164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6165: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_party_sites');
6166: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6167: FND_MSG_PUB.ADD;
6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6165: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_party_sites');

6161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6163: WHEN OTHERS THEN
6164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6165: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_party_sites');
6166: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6167: FND_MSG_PUB.ADD;
6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6169: END get_matching_party_sites;

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

6162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6163: WHEN OTHERS THEN
6164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6165: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_party_sites');
6166: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6167: FND_MSG_PUB.ADD;
6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6169: END get_matching_party_sites;
6170:

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

6388: RAISE FND_API.G_EXC_ERROR;
6389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6391: WHEN OTHERS THEN
6392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6393: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contacts');
6394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6395: FND_MSG_PUB.ADD;
6396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6393: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contacts');

6389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6391: WHEN OTHERS THEN
6392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6393: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contacts');
6394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6395: FND_MSG_PUB.ADD;
6396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6397: END get_matching_contacts;

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

6390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6391: WHEN OTHERS THEN
6392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6393: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contacts');
6394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6395: FND_MSG_PUB.ADD;
6396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6397: END get_matching_contacts;
6398:

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

6529: RAISE FND_API.G_EXC_ERROR;
6530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6532: WHEN OTHERS THEN
6533: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6534: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contact_points');
6535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6536: FND_MSG_PUB.ADD;
6537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6534: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contact_points');

6530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6532: WHEN OTHERS THEN
6533: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6534: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contact_points');
6535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6536: FND_MSG_PUB.ADD;
6537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6538: END get_matching_contact_points;

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

6531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6532: WHEN OTHERS THEN
6533: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6534: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_matching_contact_points');
6535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6536: FND_MSG_PUB.ADD;
6537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6538: END get_matching_contact_points;
6539:

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

6773: RAISE FND_API.G_EXC_ERROR;
6774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6776: WHEN OTHERS THEN
6777: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6778: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_score_details');
6779: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6780: FND_MSG_PUB.ADD;
6781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6778: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_score_details');

6774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6776: WHEN OTHERS THEN
6777: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6778: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_score_details');
6779: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6780: FND_MSG_PUB.ADD;
6781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6782: END get_score_details;

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

6775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6776: WHEN OTHERS THEN
6777: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6778: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_42.get_score_details');
6779: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6780: FND_MSG_PUB.ADD;
6781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6782: END get_score_details;
6783:

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

6896: RAISE FND_API.G_EXC_ERROR;
6897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6899: WHEN OTHERS THEN
6900: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6901: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6902: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6903: FND_MSG_PUB.ADD;
6904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6899: WHEN OTHERS THEN
6900: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6901: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6902: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6903: FND_MSG_PUB.ADD;
6904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6905: END get_party_for_search;

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

6898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6899: WHEN OTHERS THEN
6900: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6901: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6902: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6903: FND_MSG_PUB.ADD;
6904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6905: END get_party_for_search;
6906:

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

6948: RAISE FND_API.G_EXC_ERROR;
6949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6951: WHEN OTHERS THEN
6952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6953: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6954: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6955: FND_MSG_PUB.ADD;
6956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6951: WHEN OTHERS THEN
6952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6953: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6954: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6955: FND_MSG_PUB.ADD;
6956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6957: END get_search_criteria;

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

6950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6951: WHEN OTHERS THEN
6952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6953: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6954: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6955: FND_MSG_PUB.ADD;
6956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6957: END get_search_criteria;
6958:

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

7038: HZ_PARTY_ACQUIRE.get_account_info(p_party_id , 'PARTY','ALL_ACCOUNT_NUMBERS');
7039:
7040: EXCEPTION
7041: WHEN OTHERS THEN
7042: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7043: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7044: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7045: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7046: FND_MSG_PUB.ADD;

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

7039:
7040: EXCEPTION
7041: WHEN OTHERS THEN
7042: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7043: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7044: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7045: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7046: FND_MSG_PUB.ADD;
7047: RAISE FND_API.G_EXC_ERROR;

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

7040: EXCEPTION
7041: WHEN OTHERS THEN
7042: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7043: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7044: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7045: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7046: FND_MSG_PUB.ADD;
7047: RAISE FND_API.G_EXC_ERROR;
7048: END get_party_rec;

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

7041: WHEN OTHERS THEN
7042: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7043: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7044: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7045: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7046: FND_MSG_PUB.ADD;
7047: RAISE FND_API.G_EXC_ERROR;
7048: END get_party_rec;
7049:

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

7104: END LOOP;
7105:
7106: EXCEPTION
7107: WHEN OTHERS THEN
7108: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7109: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7110: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7112: FND_MSG_PUB.ADD;

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

7105:
7106: EXCEPTION
7107: WHEN OTHERS THEN
7108: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7109: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7110: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7112: FND_MSG_PUB.ADD;
7113: RAISE FND_API.G_EXC_ERROR;

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

7106: EXCEPTION
7107: WHEN OTHERS THEN
7108: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7109: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7110: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7112: FND_MSG_PUB.ADD;
7113: RAISE FND_API.G_EXC_ERROR;
7114: END get_party_site_rec;

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

7107: WHEN OTHERS THEN
7108: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7109: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7110: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7112: FND_MSG_PUB.ADD;
7113: RAISE FND_API.G_EXC_ERROR;
7114: END get_party_site_rec;
7115:

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

7162: END LOOP;
7163:
7164: EXCEPTION
7165: WHEN OTHERS THEN
7166: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7167: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7168: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7169: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7170: FND_MSG_PUB.ADD;

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

7163:
7164: EXCEPTION
7165: WHEN OTHERS THEN
7166: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7167: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7168: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7169: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7170: FND_MSG_PUB.ADD;
7171: RAISE FND_API.G_EXC_ERROR;

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

7164: EXCEPTION
7165: WHEN OTHERS THEN
7166: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7167: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7168: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7169: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7170: FND_MSG_PUB.ADD;
7171: RAISE FND_API.G_EXC_ERROR;
7172: END get_contact_rec;

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

7165: WHEN OTHERS THEN
7166: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7167: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7168: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7169: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7170: FND_MSG_PUB.ADD;
7171: RAISE FND_API.G_EXC_ERROR;
7172: END get_contact_rec;
7173:

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

7218: END LOOP;
7219:
7220: EXCEPTION
7221: WHEN OTHERS THEN
7222: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7223: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7224: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7225: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7226: FND_MSG_PUB.ADD;

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

7219:
7220: EXCEPTION
7221: WHEN OTHERS THEN
7222: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7223: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7224: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7225: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7226: FND_MSG_PUB.ADD;
7227: RAISE FND_API.G_EXC_ERROR;

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

7220: EXCEPTION
7221: WHEN OTHERS THEN
7222: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7223: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7224: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7225: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7226: FND_MSG_PUB.ADD;
7227: RAISE FND_API.G_EXC_ERROR;
7228: END get_contact_point_rec;

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

7221: WHEN OTHERS THEN
7222: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
7223: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7224: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7225: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7226: FND_MSG_PUB.ADD;
7227: RAISE FND_API.G_EXC_ERROR;
7228: END get_contact_point_rec;
7229:

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

7485: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
7486: END IF;
7487: EXCEPTION
7488: WHEN OTHERS THEN
7489: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7490: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
7491: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7492: FND_MSG_PUB.ADD;
7493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7486: END IF;
7487: EXCEPTION
7488: WHEN OTHERS THEN
7489: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7490: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
7491: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7492: FND_MSG_PUB.ADD;
7493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7494: END;

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

7487: EXCEPTION
7488: WHEN OTHERS THEN
7489: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7490: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
7491: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7492: FND_MSG_PUB.ADD;
7493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7494: END;
7495:

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

7693: END IF;
7694: END LOOP;
7695: EXCEPTION
7696: WHEN OTHERS THEN
7697: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7698: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7700: FND_MSG_PUB.ADD;
7701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7694: END LOOP;
7695: EXCEPTION
7696: WHEN OTHERS THEN
7697: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7698: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7700: FND_MSG_PUB.ADD;
7701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7702: END;

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

7695: EXCEPTION
7696: WHEN OTHERS THEN
7697: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7698: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7700: FND_MSG_PUB.ADD;
7701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7702: END;
7703:

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

7773: END IF;
7774: END LOOP;
7775: EXCEPTION
7776: WHEN OTHERS THEN
7777: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7778: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7779: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7780: FND_MSG_PUB.ADD;
7781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7774: END LOOP;
7775: EXCEPTION
7776: WHEN OTHERS THEN
7777: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7778: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7779: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7780: FND_MSG_PUB.ADD;
7781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7782: END;

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

7775: EXCEPTION
7776: WHEN OTHERS THEN
7777: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7778: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7779: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7780: FND_MSG_PUB.ADD;
7781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7782: END;
7783:

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

7881: END IF;
7882: END LOOP;
7883: EXCEPTION
7884: WHEN OTHERS THEN
7885: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7886: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7887: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7888: FND_MSG_PUB.ADD;
7889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7882: END LOOP;
7883: EXCEPTION
7884: WHEN OTHERS THEN
7885: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7886: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7887: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7888: FND_MSG_PUB.ADD;
7889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7890: END;

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

7883: EXCEPTION
7884: WHEN OTHERS THEN
7885: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7886: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7887: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7888: FND_MSG_PUB.ADD;
7889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7890: END;
7891:

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

7908: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
7909: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7910: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7911: ) THEN
7912: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7913: FND_MSG_PUB.ADD;
7914: RAISE FND_API.G_EXC_ERROR;
7915: END IF;
7916: END LOOP;

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

8002: EXCEPTION
8003: WHEN FND_API.G_EXC_ERROR THEN
8004: RAISE FND_API.G_EXC_ERROR;
8005: WHEN OTHERS THEN
8006: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8007: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8009: FND_MSG_PUB.ADD;
8010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

8003: WHEN FND_API.G_EXC_ERROR THEN
8004: RAISE FND_API.G_EXC_ERROR;
8005: WHEN OTHERS THEN
8006: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8007: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8009: FND_MSG_PUB.ADD;
8010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8011: END check_prim_cond;

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

8004: RAISE FND_API.G_EXC_ERROR;
8005: WHEN OTHERS THEN
8006: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8007: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8009: FND_MSG_PUB.ADD;
8010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8011: END check_prim_cond;
8012:

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

8068: EXIT WHEN x_secondary;
8069: END LOOP;
8070: EXCEPTION
8071: WHEN OTHERS THEN
8072: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8073: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
8074: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8075: FND_MSG_PUB.ADD;
8076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

8069: END LOOP;
8070: EXCEPTION
8071: WHEN OTHERS THEN
8072: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8073: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
8074: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8075: FND_MSG_PUB.ADD;
8076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8077: END check_party_site_cond;

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

8070: EXCEPTION
8071: WHEN OTHERS THEN
8072: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8073: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
8074: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8075: FND_MSG_PUB.ADD;
8076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8077: END check_party_site_cond;
8078:

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

8124: EXIT WHEN x_secondary;
8125: END LOOP;
8126: EXCEPTION
8127: WHEN OTHERS THEN
8128: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8129: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
8130: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8131: FND_MSG_PUB.ADD;
8132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

8125: END LOOP;
8126: EXCEPTION
8127: WHEN OTHERS THEN
8128: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8129: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
8130: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8131: FND_MSG_PUB.ADD;
8132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8133: END check_contact_cond;

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

8126: EXCEPTION
8127: WHEN OTHERS THEN
8128: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8129: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
8130: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8131: FND_MSG_PUB.ADD;
8132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8133: END check_contact_cond;
8134:

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

8147: x_secondary:= FALSE;
8148:
8149: FOR I IN 1..p_contact_point_list.COUNT LOOP
8150: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
8151: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
8152: FND_MSG_PUB.ADD;
8153: RAISE FND_API.G_EXC_ERROR;
8154: END IF;
8155: END LOOP;

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

8171: EXIT WHEN x_secondary;
8172: END LOOP;
8173: EXCEPTION
8174: WHEN OTHERS THEN
8175: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8176: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
8177: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8178: FND_MSG_PUB.ADD;
8179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

8172: END LOOP;
8173: EXCEPTION
8174: WHEN OTHERS THEN
8175: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8176: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
8177: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8178: FND_MSG_PUB.ADD;
8179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8180: END check_contact_point_cond;

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

8173: EXCEPTION
8174: WHEN OTHERS THEN
8175: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8176: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
8177: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8178: FND_MSG_PUB.ADD;
8179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8180: END check_contact_point_cond;
8181: