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

Line 204: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

200: SELECT 'Y' INTO l_dummy
201: FROM HZ_PERSON_LANGUAGE
202: WHERE LANGUAGE_USE_REFERENCE_ID = p_person_language_rec.language_use_reference_id;
203:
204: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
205: FND_MESSAGE.SET_TOKEN('COLUMN', 'language_use_reference_id');
206: FND_MSG_PUB.ADD;
207: RAISE FND_API.G_EXC_ERROR;
208:

Line 205: FND_MESSAGE.SET_TOKEN('COLUMN', 'language_use_reference_id');

201: FROM HZ_PERSON_LANGUAGE
202: WHERE LANGUAGE_USE_REFERENCE_ID = p_person_language_rec.language_use_reference_id;
203:
204: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
205: FND_MESSAGE.SET_TOKEN('COLUMN', 'language_use_reference_id');
206: FND_MSG_PUB.ADD;
207: RAISE FND_API.G_EXC_ERROR;
208:
209: EXCEPTION

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

385: p_object_version_number = l_object_version_number
386: )
387: )
388: THEN
389: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
390: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PERSON_LANGUAGE');
391: FND_MSG_PUB.ADD;
392: RAISE FND_API.G_EXC_ERROR;
393: END IF;

Line 390: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PERSON_LANGUAGE');

386: )
387: )
388: THEN
389: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
390: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PERSON_LANGUAGE');
391: FND_MSG_PUB.ADD;
392: RAISE FND_API.G_EXC_ERROR;
393: END IF;
394:

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

395: p_object_version_number := nvl(l_object_version_number, 1) + 1;
396:
397: EXCEPTION
398: WHEN NO_DATA_FOUND THEN
399: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
400: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_PERSON_LANGUAGE');
401: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_person_language_rec.language_use_reference_id ), 'null' ) );
402: FND_MSG_PUB.ADD;
403: RAISE FND_API.G_EXC_ERROR;

Line 400: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_PERSON_LANGUAGE');

396:
397: EXCEPTION
398: WHEN NO_DATA_FOUND THEN
399: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
400: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_PERSON_LANGUAGE');
401: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_person_language_rec.language_use_reference_id ), 'null' ) );
402: FND_MSG_PUB.ADD;
403: RAISE FND_API.G_EXC_ERROR;
404: END;

Line 401: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_person_language_rec.language_use_reference_id ), 'null' ) );

397: EXCEPTION
398: WHEN NO_DATA_FOUND THEN
399: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
400: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_PERSON_LANGUAGE');
401: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_person_language_rec.language_use_reference_id ), 'null' ) );
402: FND_MSG_PUB.ADD;
403: RAISE FND_API.G_EXC_ERROR;
404: END;
405:

Line 564: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

560: SELECT 'Y' INTO l_dummy
561: FROM HZ_CITIZENSHIP
562: WHERE CITIZENSHIP_ID = p_citizenship_rec.citizenship_id;
563:
564: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
565: FND_MESSAGE.SET_TOKEN('COLUMN', 'citizenship_id');
566: FND_MSG_PUB.ADD;
567: RAISE FND_API.G_EXC_ERROR;
568:

Line 565: FND_MESSAGE.SET_TOKEN('COLUMN', 'citizenship_id');

561: FROM HZ_CITIZENSHIP
562: WHERE CITIZENSHIP_ID = p_citizenship_rec.citizenship_id;
563:
564: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
565: FND_MESSAGE.SET_TOKEN('COLUMN', 'citizenship_id');
566: FND_MSG_PUB.ADD;
567: RAISE FND_API.G_EXC_ERROR;
568:
569: EXCEPTION

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

664: p_object_version_number = l_object_version_number
665: )
666: )
667: THEN
668: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
669: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CITIZENSHIP');
670: FND_MSG_PUB.ADD;
671: RAISE FND_API.G_EXC_ERROR;
672: END IF;

Line 669: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CITIZENSHIP');

665: )
666: )
667: THEN
668: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
669: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CITIZENSHIP');
670: FND_MSG_PUB.ADD;
671: RAISE FND_API.G_EXC_ERROR;
672: END IF;
673:

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

674: p_object_version_number := nvl(l_object_version_number, 1) + 1;
675:
676: EXCEPTION
677: WHEN NO_DATA_FOUND THEN
678: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
679: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CITIZENSHIP');
680: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_citizenship_rec.citizenship_id ), 'null' ) );
681: FND_MSG_PUB.ADD;
682: RAISE FND_API.G_EXC_ERROR;

Line 679: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CITIZENSHIP');

675:
676: EXCEPTION
677: WHEN NO_DATA_FOUND THEN
678: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
679: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CITIZENSHIP');
680: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_citizenship_rec.citizenship_id ), 'null' ) );
681: FND_MSG_PUB.ADD;
682: RAISE FND_API.G_EXC_ERROR;
683: END;

Line 680: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_citizenship_rec.citizenship_id ), 'null' ) );

676: EXCEPTION
677: WHEN NO_DATA_FOUND THEN
678: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
679: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CITIZENSHIP');
680: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_citizenship_rec.citizenship_id ), 'null' ) );
681: FND_MSG_PUB.ADD;
682: RAISE FND_API.G_EXC_ERROR;
683: END;
684:

Line 767: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

763: SELECT 'Y' INTO l_dummy
764: FROM HZ_EDUCATION
765: WHERE EDUCATION_ID = p_education_rec.education_id;
766:
767: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
768: FND_MESSAGE.SET_TOKEN('COLUMN', 'education_id');
769: FND_MSG_PUB.ADD;
770: RAISE FND_API.G_EXC_ERROR;
771:

Line 768: FND_MESSAGE.SET_TOKEN('COLUMN', 'education_id');

764: FROM HZ_EDUCATION
765: WHERE EDUCATION_ID = p_education_rec.education_id;
766:
767: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
768: FND_MESSAGE.SET_TOKEN('COLUMN', 'education_id');
769: FND_MSG_PUB.ADD;
770: RAISE FND_API.G_EXC_ERROR;
771:
772: EXCEPTION

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

866: p_object_version_number = l_object_version_number
867: )
868: )
869: THEN
870: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
871: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_EDUCATION');
872: FND_MSG_PUB.ADD;
873: RAISE FND_API.G_EXC_ERROR;
874: END IF;

Line 871: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_EDUCATION');

867: )
868: )
869: THEN
870: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
871: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_EDUCATION');
872: FND_MSG_PUB.ADD;
873: RAISE FND_API.G_EXC_ERROR;
874: END IF;
875:

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

876: p_object_version_number := nvl(l_object_version_number, 1) + 1;
877:
878: EXCEPTION
879: WHEN NO_DATA_FOUND THEN
880: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
881: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_EDUCATION');
882: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_education_rec.education_id ), 'null' ) );
883: FND_MSG_PUB.ADD;
884: RAISE FND_API.G_EXC_ERROR;

Line 881: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_EDUCATION');

877:
878: EXCEPTION
879: WHEN NO_DATA_FOUND THEN
880: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
881: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_EDUCATION');
882: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_education_rec.education_id ), 'null' ) );
883: FND_MSG_PUB.ADD;
884: RAISE FND_API.G_EXC_ERROR;
885: END;

Line 882: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_education_rec.education_id ), 'null' ) );

878: EXCEPTION
879: WHEN NO_DATA_FOUND THEN
880: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
881: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_EDUCATION');
882: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_education_rec.education_id ), 'null' ) );
883: FND_MSG_PUB.ADD;
884: RAISE FND_API.G_EXC_ERROR;
885: END;
886:

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

963: SELECT 'Y' INTO l_dummy
964: FROM HZ_EMPLOYMENT_HISTORY
965: WHERE EMPLOYMENT_HISTORY_ID = p_employment_history_rec.employment_history_id;
966:
967: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
968: FND_MESSAGE.SET_TOKEN('COLUMN', 'employment_history_id');
969: FND_MSG_PUB.ADD;
970: RAISE FND_API.G_EXC_ERROR;
971:

Line 968: FND_MESSAGE.SET_TOKEN('COLUMN', 'employment_history_id');

964: FROM HZ_EMPLOYMENT_HISTORY
965: WHERE EMPLOYMENT_HISTORY_ID = p_employment_history_rec.employment_history_id;
966:
967: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
968: FND_MESSAGE.SET_TOKEN('COLUMN', 'employment_history_id');
969: FND_MSG_PUB.ADD;
970: RAISE FND_API.G_EXC_ERROR;
971:
972: EXCEPTION

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

1082: p_object_version_number = l_object_version_number
1083: )
1084: )
1085: THEN
1086: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1087: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_EMPLOYMENT_HISTORY');
1088: FND_MSG_PUB.ADD;
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;

Line 1087: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_EMPLOYMENT_HISTORY');

1083: )
1084: )
1085: THEN
1086: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1087: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_EMPLOYMENT_HISTORY');
1088: FND_MSG_PUB.ADD;
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;
1091:

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

1092: p_object_version_number := nvl(l_object_version_number, 1) + 1;
1093:
1094: EXCEPTION
1095: WHEN NO_DATA_FOUND THEN
1096: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1097: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_EMPLOYMENT_HISTORY');
1098: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_employment_history_rec.employment_history_id ), 'null' ) );
1099: FND_MSG_PUB.ADD;
1100: RAISE FND_API.G_EXC_ERROR;

Line 1097: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_EMPLOYMENT_HISTORY');

1093:
1094: EXCEPTION
1095: WHEN NO_DATA_FOUND THEN
1096: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1097: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_EMPLOYMENT_HISTORY');
1098: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_employment_history_rec.employment_history_id ), 'null' ) );
1099: FND_MSG_PUB.ADD;
1100: RAISE FND_API.G_EXC_ERROR;
1101: END;

Line 1098: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_employment_history_rec.employment_history_id ), 'null' ) );

1094: EXCEPTION
1095: WHEN NO_DATA_FOUND THEN
1096: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1097: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_EMPLOYMENT_HISTORY');
1098: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_employment_history_rec.employment_history_id ), 'null' ) );
1099: FND_MSG_PUB.ADD;
1100: RAISE FND_API.G_EXC_ERROR;
1101: END;
1102:

Line 1197: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

1193: SELECT 'Y' INTO l_dummy
1194: FROM HZ_WORK_CLASS
1195: WHERE WORK_CLASS_ID = p_work_class_rec.work_class_id;
1196:
1197: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1198: FND_MESSAGE.SET_TOKEN('COLUMN', 'work_class_id');
1199: FND_MSG_PUB.ADD;
1200: RAISE FND_API.G_EXC_ERROR;
1201:

Line 1198: FND_MESSAGE.SET_TOKEN('COLUMN', 'work_class_id');

1194: FROM HZ_WORK_CLASS
1195: WHERE WORK_CLASS_ID = p_work_class_rec.work_class_id;
1196:
1197: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1198: FND_MESSAGE.SET_TOKEN('COLUMN', 'work_class_id');
1199: FND_MSG_PUB.ADD;
1200: RAISE FND_API.G_EXC_ERROR;
1201:
1202: EXCEPTION

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

1295: p_object_version_number = l_object_version_number
1296: )
1297: )
1298: THEN
1299: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1300: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_WORK_CLASS');
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;

Line 1300: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_WORK_CLASS');

1296: )
1297: )
1298: THEN
1299: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1300: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_WORK_CLASS');
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;
1304:

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

1305: p_object_version_number := nvl(l_object_version_number, 1) + 1;
1306:
1307: EXCEPTION
1308: WHEN NO_DATA_FOUND THEN
1309: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1310: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_WORK_CLASS');
1311: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_work_class_rec.work_class_id ), 'null' ) );
1312: FND_MSG_PUB.ADD;
1313: RAISE FND_API.G_EXC_ERROR;

Line 1310: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_WORK_CLASS');

1306:
1307: EXCEPTION
1308: WHEN NO_DATA_FOUND THEN
1309: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1310: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_WORK_CLASS');
1311: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_work_class_rec.work_class_id ), 'null' ) );
1312: FND_MSG_PUB.ADD;
1313: RAISE FND_API.G_EXC_ERROR;
1314: END;

Line 1311: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_work_class_rec.work_class_id ), 'null' ) );

1307: EXCEPTION
1308: WHEN NO_DATA_FOUND THEN
1309: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1310: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_WORK_CLASS');
1311: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_work_class_rec.work_class_id ), 'null' ) );
1312: FND_MSG_PUB.ADD;
1313: RAISE FND_API.G_EXC_ERROR;
1314: END;
1315:

Line 1392: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

1388: SELECT 'Y' INTO l_dummy
1389: FROM HZ_person_interest
1390: WHERE person_interest_ID = p_person_interest_rec.person_interest_id;
1391:
1392: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1393: FND_MESSAGE.SET_TOKEN('COLUMN', 'person_interest_id');
1394: FND_MSG_PUB.ADD;
1395: RAISE FND_API.G_EXC_ERROR;
1396:

Line 1393: FND_MESSAGE.SET_TOKEN('COLUMN', 'person_interest_id');

1389: FROM HZ_person_interest
1390: WHERE person_interest_ID = p_person_interest_rec.person_interest_id;
1391:
1392: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1393: FND_MESSAGE.SET_TOKEN('COLUMN', 'person_interest_id');
1394: FND_MSG_PUB.ADD;
1395: RAISE FND_API.G_EXC_ERROR;
1396:
1397: EXCEPTION

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

1496: p_object_version_number = l_object_version_number
1497: )
1498: )
1499: THEN
1500: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1501: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_person_interest');
1502: FND_MSG_PUB.ADD;
1503: RAISE FND_API.G_EXC_ERROR;
1504: END IF;

Line 1501: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_person_interest');

1497: )
1498: )
1499: THEN
1500: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1501: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_person_interest');
1502: FND_MSG_PUB.ADD;
1503: RAISE FND_API.G_EXC_ERROR;
1504: END IF;
1505:

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

1506: p_object_version_number := nvl(l_object_version_number, 1) + 1;
1507:
1508: EXCEPTION
1509: WHEN NO_DATA_FOUND THEN
1510: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1511: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_person_interest');
1512: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_person_interest_rec.person_interest_id ), 'null' ) );
1513: FND_MSG_PUB.ADD;
1514: RAISE FND_API.G_EXC_ERROR;

Line 1511: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_person_interest');

1507:
1508: EXCEPTION
1509: WHEN NO_DATA_FOUND THEN
1510: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1511: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_person_interest');
1512: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_person_interest_rec.person_interest_id ), 'null' ) );
1513: FND_MSG_PUB.ADD;
1514: RAISE FND_API.G_EXC_ERROR;
1515: END;

Line 1512: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_person_interest_rec.person_interest_id ), 'null' ) );

1508: EXCEPTION
1509: WHEN NO_DATA_FOUND THEN
1510: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1511: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_person_interest');
1512: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_person_interest_rec.person_interest_id ), 'null' ) );
1513: FND_MSG_PUB.ADD;
1514: RAISE FND_API.G_EXC_ERROR;
1515: END;
1516:

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

1658:
1659: WHEN OTHERS THEN
1660: ROLLBACK TO create_person_language;
1661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1662: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1664: FND_MSG_PUB.ADD;
1665: FND_MSG_PUB.Count_And_Get(
1666: p_encoded => FND_API.G_FALSE,

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

1659: WHEN OTHERS THEN
1660: ROLLBACK TO create_person_language;
1661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1662: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1664: FND_MSG_PUB.ADD;
1665: FND_MSG_PUB.Count_And_Get(
1666: p_encoded => FND_API.G_FALSE,
1667: p_count => x_msg_count,

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

1786:
1787: WHEN OTHERS THEN
1788: ROLLBACK TO update_person_language;
1789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1790: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1791: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1792: FND_MSG_PUB.ADD;
1793: FND_MSG_PUB.Count_And_Get(
1794: p_encoded => FND_API.G_FALSE,

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

1787: WHEN OTHERS THEN
1788: ROLLBACK TO update_person_language;
1789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1790: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1791: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1792: FND_MSG_PUB.ADD;
1793: FND_MSG_PUB.Count_And_Get(
1794: p_encoded => FND_API.G_FALSE,
1795: p_count => x_msg_count,

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

1854:
1855: --Check whether primary key has been passed in.
1856: IF p_language_use_reference_id IS NULL OR
1857: p_language_use_reference_id = FND_API.G_MISS_NUM THEN
1858: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1859: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'language_use_reference_id' );
1860: FND_MSG_PUB.ADD;
1861: RAISE FND_API.G_EXC_ERROR;
1862: END IF;

Line 1859: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'language_use_reference_id' );

1855: --Check whether primary key has been passed in.
1856: IF p_language_use_reference_id IS NULL OR
1857: p_language_use_reference_id = FND_API.G_MISS_NUM THEN
1858: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1859: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'language_use_reference_id' );
1860: FND_MSG_PUB.ADD;
1861: RAISE FND_API.G_EXC_ERROR;
1862: END IF;
1863:

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

1903:
1904: WHEN OTHERS THEN
1905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1906:
1907: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1908: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1909: FND_MSG_PUB.ADD;
1910:
1911: FND_MSG_PUB.Count_And_Get(

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

1904: WHEN OTHERS THEN
1905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1906:
1907: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1908: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1909: FND_MSG_PUB.ADD;
1910:
1911: FND_MSG_PUB.Count_And_Get(
1912: p_encoded => FND_API.G_FALSE,

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

2018:
2019: WHEN OTHERS THEN
2020: ROLLBACK TO create_citizenship;
2021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2022: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2023: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2024: FND_MSG_PUB.ADD;
2025: FND_MSG_PUB.Count_And_Get(
2026: p_encoded => FND_API.G_FALSE,

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

2019: WHEN OTHERS THEN
2020: ROLLBACK TO create_citizenship;
2021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2022: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2023: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2024: FND_MSG_PUB.ADD;
2025: FND_MSG_PUB.Count_And_Get(
2026: p_encoded => FND_API.G_FALSE,
2027: p_count => x_msg_count,

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

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

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

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

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

2214:
2215: --Check whether primary key has been passed in.
2216: IF p_citizenship_id IS NULL OR
2217: p_citizenship_id = FND_API.G_MISS_NUM THEN
2218: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2219: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'citizenship_id' );
2220: FND_MSG_PUB.ADD;
2221: RAISE FND_API.G_EXC_ERROR;
2222: END IF;

Line 2219: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'citizenship_id' );

2215: --Check whether primary key has been passed in.
2216: IF p_citizenship_id IS NULL OR
2217: p_citizenship_id = FND_API.G_MISS_NUM THEN
2218: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2219: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'citizenship_id' );
2220: FND_MSG_PUB.ADD;
2221: RAISE FND_API.G_EXC_ERROR;
2222: END IF;
2223:

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

2264:
2265: WHEN OTHERS THEN
2266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2267:
2268: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2269: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2270: FND_MSG_PUB.ADD;
2271:
2272: FND_MSG_PUB.Count_And_Get(

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

2265: WHEN OTHERS THEN
2266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2267:
2268: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2269: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2270: FND_MSG_PUB.ADD;
2271:
2272: FND_MSG_PUB.Count_And_Get(
2273: p_encoded => FND_API.G_FALSE,

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

2381:
2382: WHEN OTHERS THEN
2383: ROLLBACK TO create_education;
2384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2385: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2386: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2387: FND_MSG_PUB.ADD;
2388: FND_MSG_PUB.Count_And_Get(
2389: p_encoded => FND_API.G_FALSE,

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

2382: WHEN OTHERS THEN
2383: ROLLBACK TO create_education;
2384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2385: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2386: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2387: FND_MSG_PUB.ADD;
2388: FND_MSG_PUB.Count_And_Get(
2389: p_encoded => FND_API.G_FALSE,
2390: p_count => x_msg_count,

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

2509:
2510: WHEN OTHERS THEN
2511: ROLLBACK TO update_education;
2512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2513: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2514: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2515: FND_MSG_PUB.ADD;
2516: FND_MSG_PUB.Count_And_Get(
2517: p_encoded => FND_API.G_FALSE,

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

2510: WHEN OTHERS THEN
2511: ROLLBACK TO update_education;
2512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2513: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2514: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2515: FND_MSG_PUB.ADD;
2516: FND_MSG_PUB.Count_And_Get(
2517: p_encoded => FND_API.G_FALSE,
2518: p_count => x_msg_count,

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

2577:
2578: --Check whether primary key has been passed in.
2579: IF p_education_id IS NULL OR
2580: p_education_id = FND_API.G_MISS_NUM THEN
2581: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2582: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'education_id' );
2583: FND_MSG_PUB.ADD;
2584: RAISE FND_API.G_EXC_ERROR;
2585: END IF;

Line 2582: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'education_id' );

2578: --Check whether primary key has been passed in.
2579: IF p_education_id IS NULL OR
2580: p_education_id = FND_API.G_MISS_NUM THEN
2581: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2582: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'education_id' );
2583: FND_MSG_PUB.ADD;
2584: RAISE FND_API.G_EXC_ERROR;
2585: END IF;
2586:

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

2628:
2629: WHEN OTHERS THEN
2630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2631:
2632: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2633: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2634: FND_MSG_PUB.ADD;
2635:
2636: FND_MSG_PUB.Count_And_Get(

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

2629: WHEN OTHERS THEN
2630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2631:
2632: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2633: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2634: FND_MSG_PUB.ADD;
2635:
2636: FND_MSG_PUB.Count_And_Get(
2637: p_encoded => FND_API.G_FALSE,

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

2742:
2743: WHEN OTHERS THEN
2744: ROLLBACK TO create_employment_history;
2745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2746: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2747: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2748: FND_MSG_PUB.ADD;
2749: FND_MSG_PUB.Count_And_Get(
2750: p_encoded => FND_API.G_FALSE,

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

2743: WHEN OTHERS THEN
2744: ROLLBACK TO create_employment_history;
2745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2746: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2747: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2748: FND_MSG_PUB.ADD;
2749: FND_MSG_PUB.Count_And_Get(
2750: p_encoded => FND_API.G_FALSE,
2751: p_count => x_msg_count,

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

2870:
2871: WHEN OTHERS THEN
2872: ROLLBACK TO update_employment_history;
2873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2874: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2875: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2876: FND_MSG_PUB.ADD;
2877: FND_MSG_PUB.Count_And_Get(
2878: p_encoded => FND_API.G_FALSE,

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

2871: WHEN OTHERS THEN
2872: ROLLBACK TO update_employment_history;
2873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2874: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2875: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2876: FND_MSG_PUB.ADD;
2877: FND_MSG_PUB.Count_And_Get(
2878: p_encoded => FND_API.G_FALSE,
2879: p_count => x_msg_count,

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

2937:
2938: --Check whether primary key has been passed in.
2939: IF p_employment_history_id IS NULL OR
2940: p_employment_history_id = FND_API.G_MISS_NUM THEN
2941: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2942: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'employment_history_id' );
2943: FND_MSG_PUB.ADD;
2944: RAISE FND_API.G_EXC_ERROR;
2945: END IF;

Line 2942: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'employment_history_id' );

2938: --Check whether primary key has been passed in.
2939: IF p_employment_history_id IS NULL OR
2940: p_employment_history_id = FND_API.G_MISS_NUM THEN
2941: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2942: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'employment_history_id' );
2943: FND_MSG_PUB.ADD;
2944: RAISE FND_API.G_EXC_ERROR;
2945: END IF;
2946:

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

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

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

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

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

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

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

3115: WHEN OTHERS THEN
3116: ROLLBACK TO create_work_class;
3117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3118: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3120: FND_MSG_PUB.ADD;
3121: FND_MSG_PUB.Count_And_Get(
3122: p_encoded => FND_API.G_FALSE,
3123: p_count => x_msg_count,

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

3242:
3243: WHEN OTHERS THEN
3244: ROLLBACK TO update_work_class;
3245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3246: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3247: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3248: FND_MSG_PUB.ADD;
3249: FND_MSG_PUB.Count_And_Get(
3250: p_encoded => FND_API.G_FALSE,

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

3243: WHEN OTHERS THEN
3244: ROLLBACK TO update_work_class;
3245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3246: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3247: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3248: FND_MSG_PUB.ADD;
3249: FND_MSG_PUB.Count_And_Get(
3250: p_encoded => FND_API.G_FALSE,
3251: p_count => x_msg_count,

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

3309:
3310: --Check whether primary key has been passed in.
3311: IF p_work_class_id IS NULL OR
3312: p_work_class_id = FND_API.G_MISS_NUM THEN
3313: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3314: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'work_class_id' );
3315: FND_MSG_PUB.ADD;
3316: RAISE FND_API.G_EXC_ERROR;
3317: END IF;

Line 3314: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'work_class_id' );

3310: --Check whether primary key has been passed in.
3311: IF p_work_class_id IS NULL OR
3312: p_work_class_id = FND_API.G_MISS_NUM THEN
3313: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3314: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'work_class_id' );
3315: FND_MSG_PUB.ADD;
3316: RAISE FND_API.G_EXC_ERROR;
3317: END IF;
3318:

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

3354:
3355: WHEN OTHERS THEN
3356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3357:
3358: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3359: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3360: FND_MSG_PUB.ADD;
3361:
3362: FND_MSG_PUB.Count_And_Get(

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

3355: WHEN OTHERS THEN
3356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3357:
3358: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3359: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3360: FND_MSG_PUB.ADD;
3361:
3362: FND_MSG_PUB.Count_And_Get(
3363: p_encoded => FND_API.G_FALSE,

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

3468:
3469: WHEN OTHERS THEN
3470: ROLLBACK TO create_person_interest;
3471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3472: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3473: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3474: FND_MSG_PUB.ADD;
3475: FND_MSG_PUB.Count_And_Get(
3476: p_encoded => FND_API.G_FALSE,

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

3469: WHEN OTHERS THEN
3470: ROLLBACK TO create_person_interest;
3471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3472: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3473: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3474: FND_MSG_PUB.ADD;
3475: FND_MSG_PUB.Count_And_Get(
3476: p_encoded => FND_API.G_FALSE,
3477: p_count => x_msg_count,

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

3596:
3597: WHEN OTHERS THEN
3598: ROLLBACK TO update_person_interest;
3599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3600: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3602: FND_MSG_PUB.ADD;
3603: FND_MSG_PUB.Count_And_Get(
3604: p_encoded => FND_API.G_FALSE,

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

3597: WHEN OTHERS THEN
3598: ROLLBACK TO update_person_interest;
3599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3600: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3602: FND_MSG_PUB.ADD;
3603: FND_MSG_PUB.Count_And_Get(
3604: p_encoded => FND_API.G_FALSE,
3605: p_count => x_msg_count,

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

3663:
3664: --Check whether primary key has been passed in.
3665: IF p_person_interest_id IS NULL OR
3666: p_person_interest_id = FND_API.G_MISS_NUM THEN
3667: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3668: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'person_interest_id' );
3669: FND_MSG_PUB.ADD;
3670: RAISE FND_API.G_EXC_ERROR;
3671: END IF;

Line 3668: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'person_interest_id' );

3664: --Check whether primary key has been passed in.
3665: IF p_person_interest_id IS NULL OR
3666: p_person_interest_id = FND_API.G_MISS_NUM THEN
3667: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3668: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'person_interest_id' );
3669: FND_MSG_PUB.ADD;
3670: RAISE FND_API.G_EXC_ERROR;
3671: END IF;
3672:

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

3715:
3716: WHEN OTHERS THEN
3717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3718:
3719: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3720: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3721: FND_MSG_PUB.ADD;
3722:
3723: FND_MSG_PUB.Count_And_Get(

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

3716: WHEN OTHERS THEN
3717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3718:
3719: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3720: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3721: FND_MSG_PUB.ADD;
3722:
3723: FND_MSG_PUB.Count_And_Get(
3724: p_encoded => FND_API.G_FALSE,