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_CLASSIFICATION_V2PUB dependencies on FND_MESSAGE

Line 240: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DELIMITER');

236: END IF;
237:
238: If HZ_CLASS_VALIDATE_V2PUB.is_valid_delimiter(p_class_cat_rec.class_category,p_class_cat_rec.delimiter)='N'
239: then
240: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DELIMITER');
241: FND_MSG_PUB.ADD;
242: RAISE FND_API.G_EXC_ERROR;
243: end if;
244:

Line 312: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

308:
309: IF NOT ((p_object_version_number is null and l_object_version_number is null)
310: OR (p_object_version_number = l_object_version_number))
311: THEN
312: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
313: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CATEGORIES');
314: FND_MSG_PUB.ADD;
315: RAISE FND_API.G_EXC_ERROR;
316: END IF;

Line 313: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CATEGORIES');

309: IF NOT ((p_object_version_number is null and l_object_version_number is null)
310: OR (p_object_version_number = l_object_version_number))
311: THEN
312: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
313: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CATEGORIES');
314: FND_MSG_PUB.ADD;
315: RAISE FND_API.G_EXC_ERROR;
316: END IF;
317:

Line 321: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

317:
318: p_object_version_number := nvl(l_object_version_number, 1) + 1;
319:
320: EXCEPTION WHEN NO_DATA_FOUND THEN
321: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
322: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CATEGORIES');
323: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_cat_rec.class_category');
324: FND_MSG_PUB.ADD;
325: RAISE FND_API.G_EXC_ERROR;

Line 322: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CATEGORIES');

318: p_object_version_number := nvl(l_object_version_number, 1) + 1;
319:
320: EXCEPTION WHEN NO_DATA_FOUND THEN
321: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
322: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CATEGORIES');
323: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_cat_rec.class_category');
324: FND_MSG_PUB.ADD;
325: RAISE FND_API.G_EXC_ERROR;
326: END;

Line 323: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_cat_rec.class_category');

319:
320: EXCEPTION WHEN NO_DATA_FOUND THEN
321: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
322: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CATEGORIES');
323: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_cat_rec.class_category');
324: FND_MSG_PUB.ADD;
325: RAISE FND_API.G_EXC_ERROR;
326: END;
327:

Line 340: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DELIMITER');

336: and (nvl(l_delimiter,fnd_api.g_miss_char) <> p_class_cat_rec.delimiter)
337: then
338: If HZ_CLASS_VALIDATE_V2PUB.is_valid_delimiter(p_class_cat_rec.class_category,p_class_cat_rec.delimiter)='N'
339: then
340: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DELIMITER');
341: FND_MSG_PUB.ADD;
342: RAISE FND_API.G_EXC_ERROR;
343: end if;
344: end if;

Line 490: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

486:
487: IF NOT ((p_object_version_number is null and l_object_version_number is null)
488: OR (p_object_version_number = l_object_version_number))
489: THEN
490: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
491: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CODE_RELATIONS');
492: FND_MSG_PUB.ADD;
493: RAISE FND_API.G_EXC_ERROR;
494: END IF;

Line 491: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CODE_RELATIONS');

487: IF NOT ((p_object_version_number is null and l_object_version_number is null)
488: OR (p_object_version_number = l_object_version_number))
489: THEN
490: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
491: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CODE_RELATIONS');
492: FND_MSG_PUB.ADD;
493: RAISE FND_API.G_EXC_ERROR;
494: END IF;
495:

Line 499: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

495:
496: p_object_version_number := nvl(l_object_version_number, 1) + 1;
497:
498: EXCEPTION WHEN NO_DATA_FOUND THEN
499: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
500: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CODE_RELATIONS');
501: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_code_rel_rec.class_category');
502: FND_MSG_PUB.ADD;
503: RAISE FND_API.G_EXC_ERROR;

Line 500: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CODE_RELATIONS');

496: p_object_version_number := nvl(l_object_version_number, 1) + 1;
497:
498: EXCEPTION WHEN NO_DATA_FOUND THEN
499: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
500: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CODE_RELATIONS');
501: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_code_rel_rec.class_category');
502: FND_MSG_PUB.ADD;
503: RAISE FND_API.G_EXC_ERROR;
504: END;

Line 501: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_code_rel_rec.class_category');

497:
498: EXCEPTION WHEN NO_DATA_FOUND THEN
499: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
500: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CODE_RELATIONS');
501: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_code_rel_rec.class_category');
502: FND_MSG_PUB.ADD;
503: RAISE FND_API.G_EXC_ERROR;
504: END;
505:

Line 708: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');

704: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
705: --
706: -- Bug 3835601: replaced the dss message with a more user friendly message
707: --
708: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
709: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
710: hz_dss_util_pub.get_display_name('HZ_CODE_ASSIGNMENTS', null));
711: FND_MSG_PUB.ADD;
712: RAISE FND_API.G_EXC_ERROR;

Line 709: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

705: --
706: -- Bug 3835601: replaced the dss message with a more user friendly message
707: --
708: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
709: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
710: hz_dss_util_pub.get_display_name('HZ_CODE_ASSIGNMENTS', null));
711: FND_MSG_PUB.ADD;
712: RAISE FND_API.G_EXC_ERROR;
713: end if;

Line 946: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

942: OR (p_object_version_number is not null and
943: l_object_version_number is not null and
944: p_object_version_number = l_object_version_number))
945: THEN
946: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
947: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CODE_ASSIGNMENTS');
948: FND_MSG_PUB.ADD;
949: RAISE FND_API.G_EXC_ERROR;
950: END IF;

Line 947: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CODE_ASSIGNMENTS');

943: l_object_version_number is not null and
944: p_object_version_number = l_object_version_number))
945: THEN
946: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
947: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CODE_ASSIGNMENTS');
948: FND_MSG_PUB.ADD;
949: RAISE FND_API.G_EXC_ERROR;
950: END IF;
951:

Line 955: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

951:
952: p_object_version_number := nvl(l_object_version_number, 1) + 1;
953:
954: EXCEPTION WHEN NO_DATA_FOUND THEN
955: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
956: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CODE_ASSIGNMENTS');
957: FND_MESSAGE.SET_TOKEN('VALUE', 'p_code_assignment_rec.code_assignment_id');
958: FND_MSG_PUB.ADD;
959: RAISE FND_API.G_EXC_ERROR;

Line 956: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CODE_ASSIGNMENTS');

952: p_object_version_number := nvl(l_object_version_number, 1) + 1;
953:
954: EXCEPTION WHEN NO_DATA_FOUND THEN
955: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
956: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CODE_ASSIGNMENTS');
957: FND_MESSAGE.SET_TOKEN('VALUE', 'p_code_assignment_rec.code_assignment_id');
958: FND_MSG_PUB.ADD;
959: RAISE FND_API.G_EXC_ERROR;
960: END;

Line 957: FND_MESSAGE.SET_TOKEN('VALUE', 'p_code_assignment_rec.code_assignment_id');

953:
954: EXCEPTION WHEN NO_DATA_FOUND THEN
955: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
956: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CODE_ASSIGNMENTS');
957: FND_MESSAGE.SET_TOKEN('VALUE', 'p_code_assignment_rec.code_assignment_id');
958: FND_MSG_PUB.ADD;
959: RAISE FND_API.G_EXC_ERROR;
960: END;
961:

Line 1316: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

1312:
1313: IF NOT ((p_object_version_number is null and l_object_version_number is null)
1314: OR (p_object_version_number = l_object_version_number))
1315: THEN
1316: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1317: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CATEGORY_USES');
1318: FND_MSG_PUB.ADD;
1319: RAISE FND_API.G_EXC_ERROR;
1320: END IF;

Line 1317: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CATEGORY_USES');

1313: IF NOT ((p_object_version_number is null and l_object_version_number is null)
1314: OR (p_object_version_number = l_object_version_number))
1315: THEN
1316: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1317: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CATEGORY_USES');
1318: FND_MSG_PUB.ADD;
1319: RAISE FND_API.G_EXC_ERROR;
1320: END IF;
1321:

Line 1325: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

1321:
1322: p_object_version_number := nvl(l_object_version_number, 1) + 1;
1323:
1324: EXCEPTION WHEN NO_DATA_FOUND THEN
1325: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1326: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CATEGORY_USES');
1327: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_category_use_rec.class_category');
1328: FND_MSG_PUB.ADD;
1329: RAISE FND_API.G_EXC_ERROR;

Line 1326: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CATEGORY_USES');

1322: p_object_version_number := nvl(l_object_version_number, 1) + 1;
1323:
1324: EXCEPTION WHEN NO_DATA_FOUND THEN
1325: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1326: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CATEGORY_USES');
1327: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_category_use_rec.class_category');
1328: FND_MSG_PUB.ADD;
1329: RAISE FND_API.G_EXC_ERROR;
1330: END;

Line 1327: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_category_use_rec.class_category');

1323:
1324: EXCEPTION WHEN NO_DATA_FOUND THEN
1325: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1326: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CATEGORY_USES');
1327: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_category_use_rec.class_category');
1328: FND_MSG_PUB.ADD;
1329: RAISE FND_API.G_EXC_ERROR;
1330: END;
1331:

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

1451:
1452: WHEN OTHERS THEN
1453: ROLLBACK TO create_class_category;
1454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1455: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1456: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1457: FND_MSG_PUB.ADD;
1458: FND_MSG_PUB.Count_And_Get(
1459: p_encoded => FND_API.G_FALSE,

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

1452: WHEN OTHERS THEN
1453: ROLLBACK TO create_class_category;
1454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1455: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1456: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1457: FND_MSG_PUB.ADD;
1458: FND_MSG_PUB.Count_And_Get(
1459: p_encoded => FND_API.G_FALSE,
1460: p_count => x_msg_count,

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

1575:
1576: WHEN OTHERS THEN
1577: ROLLBACK TO update_class_category;
1578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1579: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1580: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1581: FND_MSG_PUB.ADD;
1582: FND_MSG_PUB.Count_And_Get(
1583: p_encoded => FND_API.G_FALSE,

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

1576: WHEN OTHERS THEN
1577: ROLLBACK TO update_class_category;
1578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1579: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1580: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1581: FND_MSG_PUB.ADD;
1582: FND_MSG_PUB.Count_And_Get(
1583: p_encoded => FND_API.G_FALSE,
1584: p_count => x_msg_count,

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

1680:
1681: WHEN OTHERS THEN
1682: ROLLBACK TO create_class_code_relation;
1683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1684: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1685: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1686: FND_MSG_PUB.ADD;
1687: FND_MSG_PUB.Count_And_Get(
1688: p_encoded => FND_API.G_FALSE,

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

1681: WHEN OTHERS THEN
1682: ROLLBACK TO create_class_code_relation;
1683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1684: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1685: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1686: FND_MSG_PUB.ADD;
1687: FND_MSG_PUB.Count_And_Get(
1688: p_encoded => FND_API.G_FALSE,
1689: p_count => x_msg_count,

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

1807:
1808: WHEN OTHERS THEN
1809: ROLLBACK TO update_class_code_relation;
1810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1811: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1812: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1813: FND_MSG_PUB.ADD;
1814: FND_MSG_PUB.Count_And_Get(
1815: p_encoded => FND_API.G_FALSE,

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

1808: WHEN OTHERS THEN
1809: ROLLBACK TO update_class_code_relation;
1810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1811: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1812: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1813: FND_MSG_PUB.ADD;
1814: FND_MSG_PUB.Count_And_Get(
1815: p_encoded => FND_API.G_FALSE,
1816: p_count => x_msg_count,

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

1945:
1946: WHEN OTHERS THEN
1947: ROLLBACK TO create_code_assignment;
1948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1949: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1950: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1951: FND_MSG_PUB.ADD;
1952: FND_MSG_PUB.Count_And_Get(
1953: p_encoded => FND_API.G_FALSE,

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

1946: WHEN OTHERS THEN
1947: ROLLBACK TO create_code_assignment;
1948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1949: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1950: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1951: FND_MSG_PUB.ADD;
1952: FND_MSG_PUB.Count_And_Get(
1953: p_encoded => FND_API.G_FALSE,
1954: p_count => x_msg_count,

Line 2069: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');

2065: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
2066: --
2067: -- Bug 3835601: replaced the dss message with a more user friendly message
2068: --
2069: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
2070: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2071: hz_dss_util_pub.get_display_name('HZ_CODE_ASSIGNMENTS', null)); FND_MSG_PUB.ADD;
2072: RAISE FND_API.G_EXC_ERROR;
2073: end if;

Line 2070: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

2066: --
2067: -- Bug 3835601: replaced the dss message with a more user friendly message
2068: --
2069: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
2070: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2071: hz_dss_util_pub.get_display_name('HZ_CODE_ASSIGNMENTS', null)); FND_MSG_PUB.ADD;
2072: RAISE FND_API.G_EXC_ERROR;
2073: end if;
2074: END IF;

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

2123: WHEN OTHERS THEN
2124: ROLLBACK TO update_code_assignment;
2125: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
2126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2127: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2128: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2129: FND_MSG_PUB.ADD;
2130: FND_MSG_PUB.Count_And_Get(
2131: p_encoded => FND_API.G_FALSE,

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

2124: ROLLBACK TO update_code_assignment;
2125: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
2126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2127: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2128: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2129: FND_MSG_PUB.ADD;
2130: FND_MSG_PUB.Count_And_Get(
2131: p_encoded => FND_API.G_FALSE,
2132: p_count => x_msg_count,

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

2325:
2326: WHEN OTHERS THEN
2327: ROLLBACK TO set_primary_code_assign;
2328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2329: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2330: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2331: FND_MSG_PUB.ADD;
2332: FND_MSG_PUB.Count_And_Get(
2333: p_encoded => FND_API.G_FALSE,

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

2326: WHEN OTHERS THEN
2327: ROLLBACK TO set_primary_code_assign;
2328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2329: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2330: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2331: FND_MSG_PUB.ADD;
2332: FND_MSG_PUB.Count_And_Get(
2333: p_encoded => FND_API.G_FALSE,
2334: p_count => x_msg_count,

Line 2434: FND_MESSAGE.Set_Name('AR','HZ_API_OTHERS_EXCEP');

2430:
2431: WHEN OTHERS THEN
2432: ROLLBACK TO create_class_category_use;
2433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2434: FND_MESSAGE.Set_Name('AR','HZ_API_OTHERS_EXCEP');
2435: FND_MESSAGE.Set_Token('ERROR',SQLERRM);
2436: FND_MSG_PUB.Count_And_Get(
2437: p_encoded => FND_API.G_FALSE,
2438: p_count => x_msg_count,

Line 2435: FND_MESSAGE.Set_Token('ERROR',SQLERRM);

2431: WHEN OTHERS THEN
2432: ROLLBACK TO create_class_category_use;
2433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2434: FND_MESSAGE.Set_Name('AR','HZ_API_OTHERS_EXCEP');
2435: FND_MESSAGE.Set_Token('ERROR',SQLERRM);
2436: FND_MSG_PUB.Count_And_Get(
2437: p_encoded => FND_API.G_FALSE,
2438: p_count => x_msg_count,
2439: p_data => x_msg_data );

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

2558: WHEN OTHERS THEN
2559: ROLLBACK TO update_class_category_use;
2560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2561:
2562: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2563: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2564: FND_MSG_PUB.ADD;
2565:
2566: FND_MSG_PUB.Count_And_Get(

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

2559: ROLLBACK TO update_class_category_use;
2560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2561:
2562: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2563: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2564: FND_MSG_PUB.ADD;
2565:
2566: FND_MSG_PUB.Count_And_Get(
2567: p_encoded => FND_API.G_FALSE,

Line 2811: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

2807:
2808: --Check whether primary key has been passed in.
2809: IF p_class_category IS NULL OR
2810: p_class_category = FND_API.G_MISS_CHAR THEN
2811: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2812: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );
2813: FND_MSG_PUB.ADD;
2814: RAISE FND_API.G_EXC_ERROR;
2815: END IF;

Line 2812: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );

2808: --Check whether primary key has been passed in.
2809: IF p_class_category IS NULL OR
2810: p_class_category = FND_API.G_MISS_CHAR THEN
2811: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2812: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );
2813: FND_MSG_PUB.ADD;
2814: RAISE FND_API.G_EXC_ERROR;
2815: END IF;
2816:

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

2851:
2852: WHEN OTHERS THEN
2853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2854:
2855: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2856: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2857: FND_MSG_PUB.ADD;
2858:
2859: FND_MSG_PUB.Count_And_Get(

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

2852: WHEN OTHERS THEN
2853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2854:
2855: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2856: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2857: FND_MSG_PUB.ADD;
2858:
2859: FND_MSG_PUB.Count_And_Get(
2860: p_encoded => FND_API.G_FALSE,

Line 2922: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

2918:
2919: --Check whether primary key has been passed in.
2920: IF p_class_category IS NULL OR
2921: p_class_category = FND_API.G_MISS_CHAR THEN
2922: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2923: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );
2924: FND_MSG_PUB.ADD;
2925: RAISE FND_API.G_EXC_ERROR;
2926: END IF;

Line 2923: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );

2919: --Check whether primary key has been passed in.
2920: IF p_class_category IS NULL OR
2921: p_class_category = FND_API.G_MISS_CHAR THEN
2922: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2923: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );
2924: FND_MSG_PUB.ADD;
2925: RAISE FND_API.G_EXC_ERROR;
2926: END IF;
2927:

Line 2930: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

2926: END IF;
2927:
2928: IF p_owner_table IS NULL OR
2929: p_owner_table = FND_API.G_MISS_CHAR THEN
2930: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2931: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'owner_table' );
2932: FND_MSG_PUB.ADD;
2933: RAISE FND_API.G_EXC_ERROR;
2934: END IF;

Line 2931: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'owner_table' );

2927:
2928: IF p_owner_table IS NULL OR
2929: p_owner_table = FND_API.G_MISS_CHAR THEN
2930: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2931: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'owner_table' );
2932: FND_MSG_PUB.ADD;
2933: RAISE FND_API.G_EXC_ERROR;
2934: END IF;
2935:

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

2970:
2971: WHEN OTHERS THEN
2972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2973:
2974: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2975: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2976: FND_MSG_PUB.ADD;
2977:
2978: FND_MSG_PUB.Count_And_Get(

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

2971: WHEN OTHERS THEN
2972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2973:
2974: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2975: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2976: FND_MSG_PUB.ADD;
2977:
2978: FND_MSG_PUB.Count_And_Get(
2979: p_encoded => FND_API.G_FALSE,

Line 3045: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

3041:
3042: --Check whether primary key has been passed in.
3043: IF p_class_category IS NULL OR
3044: p_class_category = FND_API.G_MISS_CHAR THEN
3045: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3046: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );
3047: FND_MSG_PUB.ADD;
3048: RAISE FND_API.G_EXC_ERROR;
3049: END IF;

Line 3046: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );

3042: --Check whether primary key has been passed in.
3043: IF p_class_category IS NULL OR
3044: p_class_category = FND_API.G_MISS_CHAR THEN
3045: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3046: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );
3047: FND_MSG_PUB.ADD;
3048: RAISE FND_API.G_EXC_ERROR;
3049: END IF;
3050:

Line 3053: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

3049: END IF;
3050:
3051: IF p_class_code IS NULL OR
3052: p_class_code = FND_API.G_MISS_CHAR THEN
3053: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3054: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_code' );
3055: FND_MSG_PUB.ADD;
3056: RAISE FND_API.G_EXC_ERROR;
3057: END IF;

Line 3054: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_code' );

3050:
3051: IF p_class_code IS NULL OR
3052: p_class_code = FND_API.G_MISS_CHAR THEN
3053: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3054: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_code' );
3055: FND_MSG_PUB.ADD;
3056: RAISE FND_API.G_EXC_ERROR;
3057: END IF;
3058:

Line 3061: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

3057: END IF;
3058:
3059: IF p_sub_class_code IS NULL OR
3060: p_sub_class_code = FND_API.G_MISS_CHAR THEN
3061: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3062: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'sub_class_code' );
3063: FND_MSG_PUB.ADD;
3064: RAISE FND_API.G_EXC_ERROR;
3065: END IF;

Line 3062: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'sub_class_code' );

3058:
3059: IF p_sub_class_code IS NULL OR
3060: p_sub_class_code = FND_API.G_MISS_CHAR THEN
3061: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3062: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'sub_class_code' );
3063: FND_MSG_PUB.ADD;
3064: RAISE FND_API.G_EXC_ERROR;
3065: END IF;
3066:

Line 3069: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

3065: END IF;
3066:
3067: IF p_start_date_active IS NULL OR
3068: p_start_date_active = FND_API.G_MISS_DATE THEN
3069: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3070: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'start_date_active' );
3071: FND_MSG_PUB.ADD;
3072: RAISE FND_API.G_EXC_ERROR;
3073: END IF;

Line 3070: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'start_date_active' );

3066:
3067: IF p_start_date_active IS NULL OR
3068: p_start_date_active = FND_API.G_MISS_DATE THEN
3069: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3070: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'start_date_active' );
3071: FND_MSG_PUB.ADD;
3072: RAISE FND_API.G_EXC_ERROR;
3073: END IF;
3074:

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

3112:
3113: WHEN OTHERS THEN
3114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3115:
3116: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3117: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3118: FND_MSG_PUB.ADD;
3119:
3120: FND_MSG_PUB.Count_And_Get(

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

3113: WHEN OTHERS THEN
3114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3115:
3116: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3117: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3118: FND_MSG_PUB.ADD;
3119:
3120: FND_MSG_PUB.Count_And_Get(
3121: p_encoded => FND_API.G_FALSE,

Line 3184: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

3180:
3181: --Check whether primary key has been passed in.
3182: IF p_code_assignment_id IS NULL OR
3183: p_code_assignment_id = FND_API.G_MISS_NUM THEN
3184: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3185: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'code_assignment_id' );
3186: FND_MSG_PUB.ADD;
3187: RAISE FND_API.G_EXC_ERROR;
3188: END IF;

Line 3185: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'code_assignment_id' );

3181: --Check whether primary key has been passed in.
3182: IF p_code_assignment_id IS NULL OR
3183: p_code_assignment_id = FND_API.G_MISS_NUM THEN
3184: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3185: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'code_assignment_id' );
3186: FND_MSG_PUB.ADD;
3187: RAISE FND_API.G_EXC_ERROR;
3188: END IF;
3189:

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

3238:
3239: WHEN OTHERS THEN
3240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3241:
3242: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3243: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3244: FND_MSG_PUB.ADD;
3245:
3246: FND_MSG_PUB.Count_And_Get(

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

3239: WHEN OTHERS THEN
3240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3241:
3242: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3243: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3244: FND_MSG_PUB.ADD;
3245:
3246: FND_MSG_PUB.Count_And_Get(
3247: p_encoded => FND_API.G_FALSE,

Line 3574: FND_MESSAGE.SET_NAME('AR', 'HZ_MODIFY_CLASS_CODE_MEANING');

3570: x_return_status := FND_API.G_RET_STS_SUCCESS;
3571:
3572: If HZ_CLASS_VALIDATE_V2PUB.is_valid_class_code_meaning(l_class_code_rec.type,l_class_code_rec.meaning)='N'
3573: then
3574: FND_MESSAGE.SET_NAME('AR', 'HZ_MODIFY_CLASS_CODE_MEANING');
3575: FND_MSG_PUB.ADD;
3576: RAISE FND_API.G_EXC_ERROR;
3577: end if;
3578:

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

3673:
3674: WHEN OTHERS THEN
3675: ROLLBACK TO create_class_code;
3676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3677: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3678: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3679: FND_MSG_PUB.ADD;
3680: FND_MSG_PUB.Count_And_Get(
3681: p_encoded => FND_API.G_FALSE,

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

3674: WHEN OTHERS THEN
3675: ROLLBACK TO create_class_code;
3676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3677: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3678: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3679: FND_MSG_PUB.ADD;
3680: FND_MSG_PUB.Count_And_Get(
3681: p_encoded => FND_API.G_FALSE,
3682: p_count => x_msg_count,

Line 3770: FND_MESSAGE.SET_NAME('AR', 'HZ_MODIFY_CLASS_CODE_MEANING');

3766: if (l_class_code_rec.meaning is not null and l_class_code_rec.meaning <> fnd_api.g_miss_char)
3767: then
3768: If HZ_CLASS_VALIDATE_V2PUB.is_valid_class_code_meaning(l_class_code_rec.type,l_class_code_rec.meaning)='N'
3769: then
3770: FND_MESSAGE.SET_NAME('AR', 'HZ_MODIFY_CLASS_CODE_MEANING');
3771: FND_MSG_PUB.ADD;
3772: RAISE FND_API.G_EXC_ERROR;
3773: end if;
3774: end if;

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

3837:
3838: WHEN OTHERS THEN
3839: ROLLBACK TO update_class_code;
3840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3841: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3842: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3843: FND_MSG_PUB.ADD;
3844: FND_MSG_PUB.Count_And_Get(
3845: p_encoded => FND_API.G_FALSE,

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

3838: WHEN OTHERS THEN
3839: ROLLBACK TO update_class_code;
3840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3841: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3842: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3843: FND_MSG_PUB.ADD;
3844: FND_MSG_PUB.Count_And_Get(
3845: p_encoded => FND_API.G_FALSE,
3846: p_count => x_msg_count,

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

3957: p_data => x_msg_data);
3958:
3959: WHEN OTHERS THEN
3960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3961: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3962: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3963: FND_MSG_PUB.ADD;
3964: FND_MSG_PUB.Count_And_Get(
3965: p_encoded => FND_API.G_FALSE,

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

3958:
3959: WHEN OTHERS THEN
3960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3961: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3962: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3963: FND_MSG_PUB.ADD;
3964: FND_MSG_PUB.Count_And_Get(
3965: p_encoded => FND_API.G_FALSE,
3966: p_count => x_msg_count,