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

954: OR (p_object_version_number is not null and
955: l_object_version_number is not null and
956: p_object_version_number = l_object_version_number))
957: THEN
958: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
959: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CODE_ASSIGNMENTS');
960: FND_MSG_PUB.ADD;
961: RAISE FND_API.G_EXC_ERROR;
962: END IF;

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

955: l_object_version_number is not null and
956: p_object_version_number = l_object_version_number))
957: THEN
958: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
959: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CODE_ASSIGNMENTS');
960: FND_MSG_PUB.ADD;
961: RAISE FND_API.G_EXC_ERROR;
962: END IF;
963:

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

963:
964: p_object_version_number := nvl(l_object_version_number, 1) + 1;
965:
966: EXCEPTION WHEN NO_DATA_FOUND THEN
967: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
968: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CODE_ASSIGNMENTS');
969: FND_MESSAGE.SET_TOKEN('VALUE', 'p_code_assignment_rec.code_assignment_id');
970: FND_MSG_PUB.ADD;
971: RAISE FND_API.G_EXC_ERROR;

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

964: p_object_version_number := nvl(l_object_version_number, 1) + 1;
965:
966: EXCEPTION WHEN NO_DATA_FOUND THEN
967: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
968: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CODE_ASSIGNMENTS');
969: FND_MESSAGE.SET_TOKEN('VALUE', 'p_code_assignment_rec.code_assignment_id');
970: FND_MSG_PUB.ADD;
971: RAISE FND_API.G_EXC_ERROR;
972: END;

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

965:
966: EXCEPTION WHEN NO_DATA_FOUND THEN
967: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
968: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CODE_ASSIGNMENTS');
969: FND_MESSAGE.SET_TOKEN('VALUE', 'p_code_assignment_rec.code_assignment_id');
970: FND_MSG_PUB.ADD;
971: RAISE FND_API.G_EXC_ERROR;
972: END;
973:

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

1338:
1339: IF NOT ((p_object_version_number is null and l_object_version_number is null)
1340: OR (p_object_version_number = l_object_version_number))
1341: THEN
1342: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1343: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CATEGORY_USES');
1344: FND_MSG_PUB.ADD;
1345: RAISE FND_API.G_EXC_ERROR;
1346: END IF;

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

1339: IF NOT ((p_object_version_number is null and l_object_version_number is null)
1340: OR (p_object_version_number = l_object_version_number))
1341: THEN
1342: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1343: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CATEGORY_USES');
1344: FND_MSG_PUB.ADD;
1345: RAISE FND_API.G_EXC_ERROR;
1346: END IF;
1347:

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

1347:
1348: p_object_version_number := nvl(l_object_version_number, 1) + 1;
1349:
1350: EXCEPTION WHEN NO_DATA_FOUND THEN
1351: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1352: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CATEGORY_USES');
1353: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_category_use_rec.class_category');
1354: FND_MSG_PUB.ADD;
1355: RAISE FND_API.G_EXC_ERROR;

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

1348: p_object_version_number := nvl(l_object_version_number, 1) + 1;
1349:
1350: EXCEPTION WHEN NO_DATA_FOUND THEN
1351: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1352: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CATEGORY_USES');
1353: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_category_use_rec.class_category');
1354: FND_MSG_PUB.ADD;
1355: RAISE FND_API.G_EXC_ERROR;
1356: END;

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

1349:
1350: EXCEPTION WHEN NO_DATA_FOUND THEN
1351: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1352: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CATEGORY_USES');
1353: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_category_use_rec.class_category');
1354: FND_MSG_PUB.ADD;
1355: RAISE FND_API.G_EXC_ERROR;
1356: END;
1357:

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

1477:
1478: WHEN OTHERS THEN
1479: ROLLBACK TO create_class_category;
1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1481: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1482: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1483: FND_MSG_PUB.ADD;
1484: FND_MSG_PUB.Count_And_Get(
1485: p_encoded => FND_API.G_FALSE,

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

1478: WHEN OTHERS THEN
1479: ROLLBACK TO create_class_category;
1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1481: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1482: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1483: FND_MSG_PUB.ADD;
1484: FND_MSG_PUB.Count_And_Get(
1485: p_encoded => FND_API.G_FALSE,
1486: p_count => x_msg_count,

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

1601:
1602: WHEN OTHERS THEN
1603: ROLLBACK TO update_class_category;
1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1605: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1606: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1607: FND_MSG_PUB.ADD;
1608: FND_MSG_PUB.Count_And_Get(
1609: p_encoded => FND_API.G_FALSE,

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

1602: WHEN OTHERS THEN
1603: ROLLBACK TO update_class_category;
1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1605: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1606: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1607: FND_MSG_PUB.ADD;
1608: FND_MSG_PUB.Count_And_Get(
1609: p_encoded => FND_API.G_FALSE,
1610: p_count => x_msg_count,

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

1706:
1707: WHEN OTHERS THEN
1708: ROLLBACK TO create_class_code_relation;
1709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1710: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1711: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1712: FND_MSG_PUB.ADD;
1713: FND_MSG_PUB.Count_And_Get(
1714: p_encoded => FND_API.G_FALSE,

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

1707: WHEN OTHERS THEN
1708: ROLLBACK TO create_class_code_relation;
1709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1710: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1711: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1712: FND_MSG_PUB.ADD;
1713: FND_MSG_PUB.Count_And_Get(
1714: p_encoded => FND_API.G_FALSE,
1715: p_count => x_msg_count,

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

1833:
1834: WHEN OTHERS THEN
1835: ROLLBACK TO update_class_code_relation;
1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1837: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1838: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1839: FND_MSG_PUB.ADD;
1840: FND_MSG_PUB.Count_And_Get(
1841: p_encoded => FND_API.G_FALSE,

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

1834: WHEN OTHERS THEN
1835: ROLLBACK TO update_class_code_relation;
1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1837: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1838: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1839: FND_MSG_PUB.ADD;
1840: FND_MSG_PUB.Count_And_Get(
1841: p_encoded => FND_API.G_FALSE,
1842: p_count => x_msg_count,

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

1971:
1972: WHEN OTHERS THEN
1973: ROLLBACK TO create_code_assignment;
1974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1975: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1976: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1977: FND_MSG_PUB.ADD;
1978: FND_MSG_PUB.Count_And_Get(
1979: p_encoded => FND_API.G_FALSE,

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

1972: WHEN OTHERS THEN
1973: ROLLBACK TO create_code_assignment;
1974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1975: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1976: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1977: FND_MSG_PUB.ADD;
1978: FND_MSG_PUB.Count_And_Get(
1979: p_encoded => FND_API.G_FALSE,
1980: p_count => x_msg_count,

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

2091: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
2092: --
2093: -- Bug 3835601: replaced the dss message with a more user friendly message
2094: --
2095: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
2096: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2097: hz_dss_util_pub.get_display_name('HZ_CODE_ASSIGNMENTS', null)); FND_MSG_PUB.ADD;
2098: RAISE FND_API.G_EXC_ERROR;
2099: end if;

Line 2096: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

2092: --
2093: -- Bug 3835601: replaced the dss message with a more user friendly message
2094: --
2095: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
2096: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
2097: hz_dss_util_pub.get_display_name('HZ_CODE_ASSIGNMENTS', null)); FND_MSG_PUB.ADD;
2098: RAISE FND_API.G_EXC_ERROR;
2099: end if;
2100: END IF;

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

2149: WHEN OTHERS THEN
2150: ROLLBACK TO update_code_assignment;
2151: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
2152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2153: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2154: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2155: FND_MSG_PUB.ADD;
2156: FND_MSG_PUB.Count_And_Get(
2157: p_encoded => FND_API.G_FALSE,

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

2150: ROLLBACK TO update_code_assignment;
2151: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
2152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2153: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2154: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2155: FND_MSG_PUB.ADD;
2156: FND_MSG_PUB.Count_And_Get(
2157: p_encoded => FND_API.G_FALSE,
2158: p_count => x_msg_count,

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

2351:
2352: WHEN OTHERS THEN
2353: ROLLBACK TO set_primary_code_assign;
2354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2355: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2356: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2357: FND_MSG_PUB.ADD;
2358: FND_MSG_PUB.Count_And_Get(
2359: p_encoded => FND_API.G_FALSE,

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

2352: WHEN OTHERS THEN
2353: ROLLBACK TO set_primary_code_assign;
2354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2355: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2356: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2357: FND_MSG_PUB.ADD;
2358: FND_MSG_PUB.Count_And_Get(
2359: p_encoded => FND_API.G_FALSE,
2360: p_count => x_msg_count,

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

2456:
2457: WHEN OTHERS THEN
2458: ROLLBACK TO create_class_category_use;
2459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2460: FND_MESSAGE.Set_Name('AR','HZ_API_OTHERS_EXCEP');
2461: FND_MESSAGE.Set_Token('ERROR',SQLERRM);
2462: FND_MSG_PUB.Count_And_Get(
2463: p_encoded => FND_API.G_FALSE,
2464: p_count => x_msg_count,

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

2457: WHEN OTHERS THEN
2458: ROLLBACK TO create_class_category_use;
2459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2460: FND_MESSAGE.Set_Name('AR','HZ_API_OTHERS_EXCEP');
2461: FND_MESSAGE.Set_Token('ERROR',SQLERRM);
2462: FND_MSG_PUB.Count_And_Get(
2463: p_encoded => FND_API.G_FALSE,
2464: p_count => x_msg_count,
2465: p_data => x_msg_data );

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

2584: WHEN OTHERS THEN
2585: ROLLBACK TO update_class_category_use;
2586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2587:
2588: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2589: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2590: FND_MSG_PUB.ADD;
2591:
2592: FND_MSG_PUB.Count_And_Get(

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

2585: ROLLBACK TO update_class_category_use;
2586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2587:
2588: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2589: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2590: FND_MSG_PUB.ADD;
2591:
2592: FND_MSG_PUB.Count_And_Get(
2593: p_encoded => FND_API.G_FALSE,

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

2833:
2834: --Check whether primary key has been passed in.
2835: IF p_class_category IS NULL OR
2836: p_class_category = FND_API.G_MISS_CHAR THEN
2837: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2838: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );
2839: FND_MSG_PUB.ADD;
2840: RAISE FND_API.G_EXC_ERROR;
2841: END IF;

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

2834: --Check whether primary key has been passed in.
2835: IF p_class_category IS NULL OR
2836: p_class_category = FND_API.G_MISS_CHAR THEN
2837: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2838: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );
2839: FND_MSG_PUB.ADD;
2840: RAISE FND_API.G_EXC_ERROR;
2841: END IF;
2842:

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

2877:
2878: WHEN OTHERS THEN
2879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2880:
2881: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2882: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2883: FND_MSG_PUB.ADD;
2884:
2885: FND_MSG_PUB.Count_And_Get(

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

2878: WHEN OTHERS THEN
2879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2880:
2881: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2882: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2883: FND_MSG_PUB.ADD;
2884:
2885: FND_MSG_PUB.Count_And_Get(
2886: p_encoded => FND_API.G_FALSE,

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

2944:
2945: --Check whether primary key has been passed in.
2946: IF p_class_category IS NULL OR
2947: p_class_category = FND_API.G_MISS_CHAR THEN
2948: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2949: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );
2950: FND_MSG_PUB.ADD;
2951: RAISE FND_API.G_EXC_ERROR;
2952: END IF;

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

2945: --Check whether primary key has been passed in.
2946: IF p_class_category IS NULL OR
2947: p_class_category = FND_API.G_MISS_CHAR THEN
2948: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2949: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );
2950: FND_MSG_PUB.ADD;
2951: RAISE FND_API.G_EXC_ERROR;
2952: END IF;
2953:

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

2952: END IF;
2953:
2954: IF p_owner_table IS NULL OR
2955: p_owner_table = FND_API.G_MISS_CHAR THEN
2956: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2957: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'owner_table' );
2958: FND_MSG_PUB.ADD;
2959: RAISE FND_API.G_EXC_ERROR;
2960: END IF;

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

2953:
2954: IF p_owner_table IS NULL OR
2955: p_owner_table = FND_API.G_MISS_CHAR THEN
2956: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2957: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'owner_table' );
2958: FND_MSG_PUB.ADD;
2959: RAISE FND_API.G_EXC_ERROR;
2960: END IF;
2961:

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

2996:
2997: WHEN OTHERS THEN
2998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2999:
3000: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3001: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3002: FND_MSG_PUB.ADD;
3003:
3004: FND_MSG_PUB.Count_And_Get(

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

2997: WHEN OTHERS THEN
2998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2999:
3000: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3001: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3002: FND_MSG_PUB.ADD;
3003:
3004: FND_MSG_PUB.Count_And_Get(
3005: p_encoded => FND_API.G_FALSE,

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

3067:
3068: --Check whether primary key has been passed in.
3069: IF p_class_category IS NULL OR
3070: p_class_category = FND_API.G_MISS_CHAR THEN
3071: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3072: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );
3073: FND_MSG_PUB.ADD;
3074: RAISE FND_API.G_EXC_ERROR;
3075: END IF;

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

3068: --Check whether primary key has been passed in.
3069: IF p_class_category IS NULL OR
3070: p_class_category = FND_API.G_MISS_CHAR THEN
3071: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3072: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );
3073: FND_MSG_PUB.ADD;
3074: RAISE FND_API.G_EXC_ERROR;
3075: END IF;
3076:

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

3075: END IF;
3076:
3077: IF p_class_code IS NULL OR
3078: p_class_code = FND_API.G_MISS_CHAR THEN
3079: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3080: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_code' );
3081: FND_MSG_PUB.ADD;
3082: RAISE FND_API.G_EXC_ERROR;
3083: END IF;

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

3076:
3077: IF p_class_code IS NULL OR
3078: p_class_code = FND_API.G_MISS_CHAR THEN
3079: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3080: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_code' );
3081: FND_MSG_PUB.ADD;
3082: RAISE FND_API.G_EXC_ERROR;
3083: END IF;
3084:

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

3083: END IF;
3084:
3085: IF p_sub_class_code IS NULL OR
3086: p_sub_class_code = FND_API.G_MISS_CHAR THEN
3087: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3088: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'sub_class_code' );
3089: FND_MSG_PUB.ADD;
3090: RAISE FND_API.G_EXC_ERROR;
3091: END IF;

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

3084:
3085: IF p_sub_class_code IS NULL OR
3086: p_sub_class_code = FND_API.G_MISS_CHAR THEN
3087: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3088: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'sub_class_code' );
3089: FND_MSG_PUB.ADD;
3090: RAISE FND_API.G_EXC_ERROR;
3091: END IF;
3092:

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

3091: END IF;
3092:
3093: IF p_start_date_active IS NULL OR
3094: p_start_date_active = FND_API.G_MISS_DATE THEN
3095: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3096: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'start_date_active' );
3097: FND_MSG_PUB.ADD;
3098: RAISE FND_API.G_EXC_ERROR;
3099: END IF;

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

3092:
3093: IF p_start_date_active IS NULL OR
3094: p_start_date_active = FND_API.G_MISS_DATE THEN
3095: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3096: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'start_date_active' );
3097: FND_MSG_PUB.ADD;
3098: RAISE FND_API.G_EXC_ERROR;
3099: END IF;
3100:

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

3138:
3139: WHEN OTHERS THEN
3140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3141:
3142: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3143: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3144: FND_MSG_PUB.ADD;
3145:
3146: FND_MSG_PUB.Count_And_Get(

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

3139: WHEN OTHERS THEN
3140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3141:
3142: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3143: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3144: FND_MSG_PUB.ADD;
3145:
3146: FND_MSG_PUB.Count_And_Get(
3147: p_encoded => FND_API.G_FALSE,

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

3206:
3207: --Check whether primary key has been passed in.
3208: IF p_code_assignment_id IS NULL OR
3209: p_code_assignment_id = FND_API.G_MISS_NUM THEN
3210: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3211: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'code_assignment_id' );
3212: FND_MSG_PUB.ADD;
3213: RAISE FND_API.G_EXC_ERROR;
3214: END IF;

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

3207: --Check whether primary key has been passed in.
3208: IF p_code_assignment_id IS NULL OR
3209: p_code_assignment_id = FND_API.G_MISS_NUM THEN
3210: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3211: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'code_assignment_id' );
3212: FND_MSG_PUB.ADD;
3213: RAISE FND_API.G_EXC_ERROR;
3214: END IF;
3215:

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

3264:
3265: WHEN OTHERS THEN
3266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3267:
3268: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3269: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3270: FND_MSG_PUB.ADD;
3271:
3272: FND_MSG_PUB.Count_And_Get(

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

3265: WHEN OTHERS THEN
3266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3267:
3268: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3269: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3270: FND_MSG_PUB.ADD;
3271:
3272: FND_MSG_PUB.Count_And_Get(
3273: p_encoded => FND_API.G_FALSE,

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

3596: x_return_status := FND_API.G_RET_STS_SUCCESS;
3597:
3598: If HZ_CLASS_VALIDATE_V2PUB.is_valid_class_code_meaning(l_class_code_rec.type,l_class_code_rec.meaning)='N'
3599: then
3600: FND_MESSAGE.SET_NAME('AR', 'HZ_MODIFY_CLASS_CODE_MEANING');
3601: FND_MSG_PUB.ADD;
3602: RAISE FND_API.G_EXC_ERROR;
3603: end if;
3604:

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

3699:
3700: WHEN OTHERS THEN
3701: ROLLBACK TO create_class_code;
3702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3703: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3705: FND_MSG_PUB.ADD;
3706: FND_MSG_PUB.Count_And_Get(
3707: p_encoded => FND_API.G_FALSE,

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

3700: WHEN OTHERS THEN
3701: ROLLBACK TO create_class_code;
3702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3703: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3705: FND_MSG_PUB.ADD;
3706: FND_MSG_PUB.Count_And_Get(
3707: p_encoded => FND_API.G_FALSE,
3708: p_count => x_msg_count,

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

3792: if (l_class_code_rec.meaning is not null and l_class_code_rec.meaning <> fnd_api.g_miss_char)
3793: then
3794: If HZ_CLASS_VALIDATE_V2PUB.is_valid_class_code_meaning(l_class_code_rec.type,l_class_code_rec.meaning)='N'
3795: then
3796: FND_MESSAGE.SET_NAME('AR', 'HZ_MODIFY_CLASS_CODE_MEANING');
3797: FND_MSG_PUB.ADD;
3798: RAISE FND_API.G_EXC_ERROR;
3799: end if;
3800: end if;

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

3863:
3864: WHEN OTHERS THEN
3865: ROLLBACK TO update_class_code;
3866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3867: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3869: FND_MSG_PUB.ADD;
3870: FND_MSG_PUB.Count_And_Get(
3871: p_encoded => FND_API.G_FALSE,

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

3864: WHEN OTHERS THEN
3865: ROLLBACK TO update_class_code;
3866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3867: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3869: FND_MSG_PUB.ADD;
3870: FND_MSG_PUB.Count_And_Get(
3871: p_encoded => FND_API.G_FALSE,
3872: p_count => x_msg_count,

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

3983: p_data => x_msg_data);
3984:
3985: WHEN OTHERS THEN
3986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3987: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3988: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3989: FND_MSG_PUB.ADD;
3990: FND_MSG_PUB.Count_And_Get(
3991: p_encoded => FND_API.G_FALSE,

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

3984:
3985: WHEN OTHERS THEN
3986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3987: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3988: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3989: FND_MSG_PUB.ADD;
3990: FND_MSG_PUB.Count_And_Get(
3991: p_encoded => FND_API.G_FALSE,
3992: p_count => x_msg_count,