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.AK_SECURITY_PVT dependencies on FND_MSG_PUB

Line 71: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

67: p_return_status := FND_API.G_RET_STS_ERROR;
68: return FALSE;
69: WHEN OTHERS THEN
70: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
71: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
72: SUBSTR (SQLERRM, 1, 240) );
73: FND_MSG_PUB.Add;
74: return FALSE;
75:

Line 73: FND_MSG_PUB.Add;

69: WHEN OTHERS THEN
70: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
71: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
72: SUBSTR (SQLERRM, 1, 240) );
73: FND_MSG_PUB.Add;
74: return FALSE;
75:
76: end EXCLUDED_ITEM_EXISTS;
77:

Line 146: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

142: p_return_status := FND_API.G_RET_STS_ERROR;
143: return FALSE;
144: WHEN OTHERS THEN
145: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
147: SUBSTR (SQLERRM, 1, 240) );
148: FND_MSG_PUB.Add;
149: return FALSE;
150:

Line 148: FND_MSG_PUB.Add;

144: WHEN OTHERS THEN
145: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
147: SUBSTR (SQLERRM, 1, 240) );
148: FND_MSG_PUB.Add;
149: return FALSE;
150:
151: end RESP_SECURITY_ATTR_EXISTS;
152:

Line 218: FND_MSG_PUB.initialize;

214:
215: -- Initialize the message table if requested.
216:
217: if p_init_msg_tbl then
218: FND_MSG_PUB.initialize;
219: end if;
220:
221:
222: savepoint start_create_excluded_item;

Line 235: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

231: p_responsibility_id => p_responsibility_id,
232: p_resp_application_id => p_resp_application_id,
233: p_attribute_code => p_attribute_code,
234: p_attribute_application_id => p_attribute_application_id) then
235: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
236: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_EXISTS');
237: FND_MSG_PUB.Add;
238: end if;
239: raise FND_API.G_EXC_ERROR;

Line 237: FND_MSG_PUB.Add;

233: p_attribute_code => p_attribute_code,
234: p_attribute_application_id => p_attribute_application_id) then
235: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
236: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_EXISTS');
237: FND_MSG_PUB.Add;
238: end if;
239: raise FND_API.G_EXC_ERROR;
240: end if;
241:

Line 336: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

332:
333: -- /** commit the insert **/
334: -- commit;
335:
336: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
337: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_CREATED');
338: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||
339: ' '||to_char(p_resp_application_id)||
340: ' '||to_char(p_attribute_application_id) ||

Line 342: FND_MSG_PUB.Add;

338: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||
339: ' '||to_char(p_resp_application_id)||
340: ' '||to_char(p_attribute_application_id) ||
341: ' ' || p_attribute_code);
342: FND_MSG_PUB.Add;
343: end if;
344:
345: p_return_status := FND_API.G_RET_STS_SUCCESS;
346:

Line 347: FND_MSG_PUB.Count_And_Get (

343: end if;
344:
345: p_return_status := FND_API.G_RET_STS_SUCCESS;
346:
347: FND_MSG_PUB.Count_And_Get (
348: p_count => p_msg_count,
349: p_data => p_msg_data);
350:
351:

Line 354: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

350:
351:
352: EXCEPTION
353: WHEN VALUE_ERROR THEN
354: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
355: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_VALUE_ERROR');
356: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||
357: ' ' || p_attribute_code);
358: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_NOT_CREATED');

Line 363: FND_MSG_PUB.Add;

359: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||
360: ' '||to_char(p_resp_application_id)||
361: ' '||to_char(p_attribute_application_id) ||
362: ' ' || p_attribute_code);
363: FND_MSG_PUB.Add;
364: end if;
365: p_return_status := FND_API.G_RET_STS_ERROR;
366: rollback to start_create_excluded_item;
367: FND_MSG_PUB.Count_And_Get (

Line 367: FND_MSG_PUB.Count_And_Get (

363: FND_MSG_PUB.Add;
364: end if;
365: p_return_status := FND_API.G_RET_STS_ERROR;
366: rollback to start_create_excluded_item;
367: FND_MSG_PUB.Count_And_Get (
368: p_count => p_msg_count,
369: p_data => p_msg_data);
370: WHEN FND_API.G_EXC_ERROR THEN
371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

367: FND_MSG_PUB.Count_And_Get (
368: p_count => p_msg_count,
369: p_data => p_msg_data);
370: WHEN FND_API.G_EXC_ERROR THEN
371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
372: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_NOT_CREATED');
373: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||
374: ' '||to_char(p_resp_application_id)||
375: ' '||to_char(p_attribute_application_id) ||

Line 377: FND_MSG_PUB.Add;

373: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||
374: ' '||to_char(p_resp_application_id)||
375: ' '||to_char(p_attribute_application_id) ||
376: ' ' || p_attribute_code);
377: FND_MSG_PUB.Add;
378: end if;
379: p_return_status := FND_API.G_RET_STS_ERROR;
380: rollback to start_create_excluded_item;
381: FND_MSG_PUB.Count_And_Get (

Line 381: FND_MSG_PUB.Count_And_Get (

377: FND_MSG_PUB.Add;
378: end if;
379: p_return_status := FND_API.G_RET_STS_ERROR;
380: rollback to start_create_excluded_item;
381: FND_MSG_PUB.Count_And_Get (
382: p_count => p_msg_count,
383: p_data => p_msg_data);
384: WHEN OTHERS THEN
385: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 387: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

383: p_data => p_msg_data);
384: WHEN OTHERS THEN
385: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: rollback to start_create_excluded_item;
387: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
388: SUBSTR (SQLERRM, 1, 240) );
389: FND_MSG_PUB.Count_And_Get (
390: p_count => p_msg_count,
391: p_data => p_msg_data);

Line 389: FND_MSG_PUB.Count_And_Get (

385: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: rollback to start_create_excluded_item;
387: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
388: SUBSTR (SQLERRM, 1, 240) );
389: FND_MSG_PUB.Count_And_Get (
390: p_count => p_msg_count,
391: p_data => p_msg_data);
392:
393:

Line 461: FND_MSG_PUB.initialize;

457:
458: -- Initialize the message table if requested.
459:
460: if p_init_msg_tbl then
461: FND_MSG_PUB.initialize;
462: end if;
463:
464:
465: savepoint start_create_excluded_item;

Line 477: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

473: p_responsibility_id => p_responsibility_id,
474: p_resp_application_id => p_resp_application_id,
475: p_attribute_code => p_attribute_code,
476: p_attribute_application_id => p_attribute_application_id) then
477: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
478: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_EXISTS');
479: FND_MSG_PUB.Add;
480: end if;
481: raise FND_API.G_EXC_ERROR;

Line 479: FND_MSG_PUB.Add;

475: p_attribute_code => p_attribute_code,
476: p_attribute_application_id => p_attribute_application_id) then
477: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
478: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_EXISTS');
479: FND_MSG_PUB.Add;
480: end if;
481: raise FND_API.G_EXC_ERROR;
482: end if;
483:

Line 575: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

571:
572: -- /** commit the insert **/
573: -- commit;
574:
575: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
576: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_CREATED');
577: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||
578: ' '||to_char(p_resp_application_id)||
579: ' '||to_char(p_attribute_application_id) ||

Line 581: FND_MSG_PUB.Add;

577: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||
578: ' '||to_char(p_resp_application_id)||
579: ' '||to_char(p_attribute_application_id) ||
580: ' ' || p_attribute_code);
581: FND_MSG_PUB.Add;
582: end if;
583:
584: p_return_status := FND_API.G_RET_STS_SUCCESS;
585:

Line 586: FND_MSG_PUB.Count_And_Get (

582: end if;
583:
584: p_return_status := FND_API.G_RET_STS_SUCCESS;
585:
586: FND_MSG_PUB.Count_And_Get (
587: p_count => p_msg_count,
588: p_data => p_msg_data);
589:
590:

Line 593: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

589:
590:
591: EXCEPTION
592: WHEN VALUE_ERROR THEN
593: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
594: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_VALUE_ERROR');
595: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||
596: ' '||to_char(p_resp_application_id)||
597: ' '||to_char(p_attribute_application_id) ||

Line 604: FND_MSG_PUB.Add;

600: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||
601: ' '||to_char(p_resp_application_id)||
602: ' '||to_char(p_attribute_application_id) ||
603: ' ' || p_attribute_code);
604: FND_MSG_PUB.Add;
605: end if;
606: p_return_status := FND_API.G_RET_STS_ERROR;
607: rollback to start_create_excluded_item;
608: FND_MSG_PUB.Count_And_Get (

Line 608: FND_MSG_PUB.Count_And_Get (

604: FND_MSG_PUB.Add;
605: end if;
606: p_return_status := FND_API.G_RET_STS_ERROR;
607: rollback to start_create_excluded_item;
608: FND_MSG_PUB.Count_And_Get (
609: p_count => p_msg_count,
610: p_data => p_msg_data);
611: WHEN FND_API.G_EXC_ERROR THEN
612: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 612: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

608: FND_MSG_PUB.Count_And_Get (
609: p_count => p_msg_count,
610: p_data => p_msg_data);
611: WHEN FND_API.G_EXC_ERROR THEN
612: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
613: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_NOT_CREATED');
614: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||
615: ' '||to_char(p_resp_application_id)||
616: ' '||to_char(p_attribute_application_id) ||

Line 618: FND_MSG_PUB.Add;

614: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||
615: ' '||to_char(p_resp_application_id)||
616: ' '||to_char(p_attribute_application_id) ||
617: ' ' || p_attribute_code);
618: FND_MSG_PUB.Add;
619: end if;
620: p_return_status := FND_API.G_RET_STS_ERROR;
621: rollback to start_create_excluded_item;
622: FND_MSG_PUB.Count_And_Get (

Line 622: FND_MSG_PUB.Count_And_Get (

618: FND_MSG_PUB.Add;
619: end if;
620: p_return_status := FND_API.G_RET_STS_ERROR;
621: rollback to start_create_excluded_item;
622: FND_MSG_PUB.Count_And_Get (
623: p_count => p_msg_count,
624: p_data => p_msg_data);
625: WHEN OTHERS THEN
626: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 628: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

624: p_data => p_msg_data);
625: WHEN OTHERS THEN
626: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: rollback to start_create_excluded_item;
628: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
629: SUBSTR (SQLERRM, 1, 240) );
630: FND_MSG_PUB.Count_And_Get (
631: p_count => p_msg_count,
632: p_data => p_msg_data);

Line 630: FND_MSG_PUB.Count_And_Get (

626: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: rollback to start_create_excluded_item;
628: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
629: SUBSTR (SQLERRM, 1, 240) );
630: FND_MSG_PUB.Count_And_Get (
631: p_count => p_msg_count,
632: p_data => p_msg_data);
633:
634:

Line 748: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

744: p_return_status := FND_API.G_RET_STS_SUCCESS;
745:
746: EXCEPTION
747: WHEN VALUE_ERROR THEN
748: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
749: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_VALUE_ERROR');
750: FND_MESSAGE.SET_TOKEN('KEY',
751: to_char(p_resp_sec_attr_rec.attribute_application_id) ||
752: ' ' || p_resp_sec_attr_rec.attribute_code);

Line 753: FND_MSG_PUB.Add;

749: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_VALUE_ERROR');
750: FND_MESSAGE.SET_TOKEN('KEY',
751: to_char(p_resp_sec_attr_rec.attribute_application_id) ||
752: ' ' || p_resp_sec_attr_rec.attribute_code);
753: FND_MSG_PUB.Add;
754: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_NOT_DWNLOADED');
755: FND_MESSAGE.SET_TOKEN('KEY',
756: to_char(p_resp_sec_attr_rec.attribute_application_id) ||
757: ' ' || p_resp_sec_attr_rec.attribute_code);

Line 758: FND_MSG_PUB.Add;

754: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_NOT_DWNLOADED');
755: FND_MESSAGE.SET_TOKEN('KEY',
756: to_char(p_resp_sec_attr_rec.attribute_application_id) ||
757: ' ' || p_resp_sec_attr_rec.attribute_code);
758: FND_MSG_PUB.Add;
759: end if;
760: p_return_status := FND_API.G_RET_STS_ERROR;
761: WHEN FND_API.G_EXC_ERROR THEN
762: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 762: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

758: FND_MSG_PUB.Add;
759: end if;
760: p_return_status := FND_API.G_RET_STS_ERROR;
761: WHEN FND_API.G_EXC_ERROR THEN
762: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
763: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_NOT_DWNLOADED');
764: FND_MESSAGE.SET_TOKEN('KEY',
765: to_char(p_resp_sec_attr_rec.attribute_application_id) ||
766: ' ' || p_resp_sec_attr_rec.attribute_code);

Line 767: FND_MSG_PUB.Add;

763: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_NOT_DWNLOADED');
764: FND_MESSAGE.SET_TOKEN('KEY',
765: to_char(p_resp_sec_attr_rec.attribute_application_id) ||
766: ' ' || p_resp_sec_attr_rec.attribute_code);
767: FND_MSG_PUB.Add;
768: end if;
769: p_return_status := FND_API.G_RET_STS_ERROR;
770: WHEN OTHERS THEN
771: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 772: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

768: end if;
769: p_return_status := FND_API.G_RET_STS_ERROR;
770: WHEN OTHERS THEN
771: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
773: SUBSTR (SQLERRM, 1, 240) );
774: FND_MSG_PUB.Add;
775: end WRITE_RESP_SEC_ATTR_TO_BUFFER;
776:

Line 774: FND_MSG_PUB.Add;

770: WHEN OTHERS THEN
771: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
773: SUBSTR (SQLERRM, 1, 240) );
774: FND_MSG_PUB.Add;
775: end WRITE_RESP_SEC_ATTR_TO_BUFFER;
776:
777: --=======================================================
778: -- Procedure WRITE_TO_BUFFER (local procedure)

Line 888: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

884: p_return_status := FND_API.G_RET_STS_SUCCESS;
885:
886: EXCEPTION
887: WHEN VALUE_ERROR THEN
888: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
889: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_VALUE_ERROR');
890: FND_MESSAGE.SET_TOKEN('KEY',
891: to_char(p_excluded_rec.attribute_application_id) ||
892: ' ' || p_excluded_rec.attribute_code);

Line 893: FND_MSG_PUB.Add;

889: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_VALUE_ERROR');
890: FND_MESSAGE.SET_TOKEN('KEY',
891: to_char(p_excluded_rec.attribute_application_id) ||
892: ' ' || p_excluded_rec.attribute_code);
893: FND_MSG_PUB.Add;
894: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_NOT_DOWNLOADED');
895: FND_MESSAGE.SET_TOKEN('KEY',
896: to_char(p_excluded_rec.attribute_application_id) ||
897: ' ' || p_excluded_rec.attribute_code);

Line 898: FND_MSG_PUB.Add;

894: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_NOT_DOWNLOADED');
895: FND_MESSAGE.SET_TOKEN('KEY',
896: to_char(p_excluded_rec.attribute_application_id) ||
897: ' ' || p_excluded_rec.attribute_code);
898: FND_MSG_PUB.Add;
899: end if;
900: p_return_status := FND_API.G_RET_STS_ERROR;
901: WHEN FND_API.G_EXC_ERROR THEN
902: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 902: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

898: FND_MSG_PUB.Add;
899: end if;
900: p_return_status := FND_API.G_RET_STS_ERROR;
901: WHEN FND_API.G_EXC_ERROR THEN
902: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
903: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_NOT_DOWNLOADED');
904: FND_MESSAGE.SET_TOKEN('KEY',
905: to_char(p_excluded_rec.attribute_application_id) ||
906: ' ' || p_excluded_rec.attribute_code);

Line 907: FND_MSG_PUB.Add;

903: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_NOT_DOWNLOADED');
904: FND_MESSAGE.SET_TOKEN('KEY',
905: to_char(p_excluded_rec.attribute_application_id) ||
906: ' ' || p_excluded_rec.attribute_code);
907: FND_MSG_PUB.Add;
908: end if;
909: p_return_status := FND_API.G_RET_STS_ERROR;
910: WHEN OTHERS THEN
911: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 912: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

908: end if;
909: p_return_status := FND_API.G_RET_STS_ERROR;
910: WHEN OTHERS THEN
911: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
913: SUBSTR (SQLERRM, 1, 240) );
914: FND_MSG_PUB.Add;
915: end WRITE_TO_BUFFER;
916:

Line 914: FND_MSG_PUB.Add;

910: WHEN OTHERS THEN
911: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
913: SUBSTR (SQLERRM, 1, 240) );
914: FND_MSG_PUB.Add;
915: end WRITE_TO_BUFFER;
916:
917: --=======================================================
918: -- Procedure DOWNLOAD_EXCLUDED

Line 999: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

995: -- p_attribute_application_id is missing in p_excluded_pk_tbl
996: --
997: if (p_application_id = FND_API.G_MISS_NUM) then
998: if (p_excluded_pk_tbl.count = 0) then
999: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1000: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
1001: FND_MSG_PUB.Add;
1002: end if;
1003: raise FND_API.G_EXC_ERROR;

Line 1001: FND_MSG_PUB.Add;

997: if (p_application_id = FND_API.G_MISS_NUM) then
998: if (p_excluded_pk_tbl.count = 0) then
999: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1000: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
1001: FND_MSG_PUB.Add;
1002: end if;
1003: raise FND_API.G_EXC_ERROR;
1004: else
1005: --

Line 1016: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1012: if (p_excluded_pk_tbl.exists(i)) then
1013: if (p_excluded_pk_tbl(i).responsibility_appl_id = FND_API.G_MISS_NUM) or
1014: (p_excluded_pk_tbl(i).responsibility_id = FND_API.G_MISS_NUM)
1015: then
1016: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1017: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LIST');
1018: FND_MESSAGE.SET_TOKEN('ELEMENT_NUM',to_char(i));
1019: FND_MSG_PUB.Add;
1020: end if;

Line 1019: FND_MSG_PUB.Add;

1015: then
1016: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1017: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LIST');
1018: FND_MESSAGE.SET_TOKEN('ELEMENT_NUM',to_char(i));
1019: FND_MSG_PUB.Add;
1020: end if;
1021: raise FND_API.G_EXC_ERROR;
1022: end if; /* if responsibility_appl_id is null */
1023: end if; /* if exists */

Line 1090: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1086: open l_get_resp_2_csr(l_responsibility_appl_id,
1087: p_excluded_pk_tbl(i).responsibility_id);
1088: fetch l_get_resp_2_csr into l_excluded_rec;
1089: if (l_get_resp_2_csr%notfound) then
1090: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1091: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_DOES_NOT_EXIST');
1092: FND_MSG_PUB.Add;
1093: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_NOT_DOWNLOADED');
1094: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_responsibility_appl_id) ||

Line 1092: FND_MSG_PUB.Add;

1088: fetch l_get_resp_2_csr into l_excluded_rec;
1089: if (l_get_resp_2_csr%notfound) then
1090: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1091: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_DOES_NOT_EXIST');
1092: FND_MSG_PUB.Add;
1093: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_NOT_DOWNLOADED');
1094: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_responsibility_appl_id) ||
1095: ' ' || p_excluded_pk_tbl(i).attribute_code);
1096: FND_MSG_PUB.Add;

Line 1096: FND_MSG_PUB.Add;

1092: FND_MSG_PUB.Add;
1093: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_NOT_DOWNLOADED');
1094: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_responsibility_appl_id) ||
1095: ' ' || p_excluded_pk_tbl(i).attribute_code);
1096: FND_MSG_PUB.Add;
1097: end if;
1098: l_responsibility_found := FALSE;
1099: end if;
1100: close l_get_resp_2_csr;

Line 1130: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

1126: WHEN FND_API.G_EXC_ERROR THEN
1127: p_return_status := FND_API.G_RET_STS_ERROR;
1128: WHEN OTHERS THEN
1129: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
1131: SUBSTR (SQLERRM, 1, 240) );
1132: end DOWNLOAD_EXCLUDED;
1133:
1134:

Line 1216: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1212: -- p_attribute_application_id is missing in p_resp_pk_tbl
1213: --
1214: if (p_application_id = FND_API.G_MISS_NUM) then
1215: if (p_resp_pk_tbl.count = 0) then
1216: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1217: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
1218: FND_MSG_PUB.Add;
1219: end if;
1220: raise FND_API.G_EXC_ERROR;

Line 1218: FND_MSG_PUB.Add;

1214: if (p_application_id = FND_API.G_MISS_NUM) then
1215: if (p_resp_pk_tbl.count = 0) then
1216: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1217: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
1218: FND_MSG_PUB.Add;
1219: end if;
1220: raise FND_API.G_EXC_ERROR;
1221: else
1222: --

Line 1233: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1229: if (p_resp_pk_tbl.exists(i)) then
1230: if (p_resp_pk_tbl(i).responsibility_appl_id = FND_API.G_MISS_NUM) or
1231: (p_resp_pk_tbl(i).responsibility_id = FND_API.G_MISS_NUM)
1232: then
1233: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1234: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LIST');
1235: FND_MESSAGE.SET_TOKEN('ELEMENT_NUM',to_char(i));
1236: FND_MSG_PUB.Add;
1237: end if;

Line 1236: FND_MSG_PUB.Add;

1232: then
1233: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1234: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LIST');
1235: FND_MESSAGE.SET_TOKEN('ELEMENT_NUM',to_char(i));
1236: FND_MSG_PUB.Add;
1237: end if;
1238: raise FND_API.G_EXC_ERROR;
1239: end if; /* if responsibility_appl_id is null */
1240: end if; /* if exists */

Line 1307: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1303: p_resp_pk_tbl(i).responsibility_id);
1304:
1305: fetch l_get_resp_2_csr into l_resp_rec;
1306: if (l_get_resp_2_csr%notfound) then
1307: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1308: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_DOES_NOT_EXIS');
1309: FND_MSG_PUB.Add;
1310: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_NOT_DWNLOADED');
1311: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_responsibility_appl_id) ||

Line 1309: FND_MSG_PUB.Add;

1305: fetch l_get_resp_2_csr into l_resp_rec;
1306: if (l_get_resp_2_csr%notfound) then
1307: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1308: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_DOES_NOT_EXIS');
1309: FND_MSG_PUB.Add;
1310: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_NOT_DWNLOADED');
1311: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_responsibility_appl_id) ||
1312: ' ' || p_resp_pk_tbl(i).attribute_code);
1313: FND_MSG_PUB.Add;

Line 1313: FND_MSG_PUB.Add;

1309: FND_MSG_PUB.Add;
1310: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_NOT_DWNLOADED');
1311: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_responsibility_appl_id) ||
1312: ' ' || p_resp_pk_tbl(i).attribute_code);
1313: FND_MSG_PUB.Add;
1314: end if;
1315: l_responsibility_found := FALSE;
1316: end if;
1317: close l_get_resp_2_csr;

Line 1344: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

1340: WHEN FND_API.G_EXC_ERROR THEN
1341: p_return_status := FND_API.G_RET_STS_ERROR;
1342: WHEN OTHERS THEN
1343: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1344: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
1345: SUBSTR (SQLERRM, 1, 240) );
1346: end DOWNLOAD_RESP_SEC;
1347:
1348: --=======================================================

Line 1422: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1418: WHEN FND_API.G_EXC_ERROR THEN
1419: p_return_status := FND_API.G_RET_STS_ERROR;
1420: WHEN OTHERS THEN
1421: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1423: SUBSTR (SQLERRM, 1, 240) );
1424: FND_MSG_PUB.Add;
1425: end INSERT_ATTRIBUTE_PK_TABLE;
1426:

Line 1424: FND_MSG_PUB.Add;

1420: WHEN OTHERS THEN
1421: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1423: SUBSTR (SQLERRM, 1, 240) );
1424: FND_MSG_PUB.Add;
1425: end INSERT_ATTRIBUTE_PK_TABLE;
1426:
1427: --=======================================================
1428: -- Procedure UPLOAD_SECURITY

Line 1570: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1566: --
1567: -- Error if there is nothing to be read from the file
1568: --
1569: if (l_buffer is null and l_eof_flag = 'Y') then
1570: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1571: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');
1572: FND_MSG_PUB.Add;
1573: end if;
1574: raise FND_API.G_EXC_ERROR;

Line 1572: FND_MSG_PUB.Add;

1568: --
1569: if (l_buffer is null and l_eof_flag = 'Y') then
1570: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1571: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');
1572: FND_MSG_PUB.Add;
1573: end if;
1574: raise FND_API.G_EXC_ERROR;
1575: end if;
1576:

Line 1594: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1590: -- to_char(sysdate, 'MON-DD HH24:MI:SS'));
1591:
1592: if (l_return_status = FND_API.G_RET_STS_ERROR) or
1593: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1594: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1595: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
1596: FND_MSG_PUB.Add;
1597: end if;
1598: -- dbms_output.put_line('Error parsing buffer');

Line 1596: FND_MSG_PUB.Add;

1592: if (l_return_status = FND_API.G_RET_STS_ERROR) or
1593: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1594: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1595: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
1596: FND_MSG_PUB.Add;
1597: end if;
1598: -- dbms_output.put_line('Error parsing buffer');
1599: raise FND_API.G_EXC_ERROR;
1600: end if;

Line 1609: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1605: l_excluded_items_rec := l_empty_excluded_items_rec;
1606: l_resp_sec_attr_rec := l_empty_resp_sec_attr_rec;
1607: l_state := 1;
1608: else
1609: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1610: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1611: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1612: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1613: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');

Line 1614: FND_MSG_PUB.Add;

1610: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1611: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1612: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1613: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
1614: FND_MSG_PUB.Add;
1615: end if;
1616: raise FND_API.G_EXC_ERROR;
1617: end if;
1618: elsif (l_state = 1) then

Line 1635: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1631: if (l_token is not null) then
1632: l_excluded_items_rec.responsibility_id := to_number(l_token);
1633: l_state := 3;
1634: else
1635: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1636: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1637: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1638: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1639: FND_MESSAGE.SET_TOKEN('EXPECTED','RESPONSIBILITY_ID');

Line 1640: FND_MSG_PUB.Add;

1636: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1637: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1638: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1639: FND_MESSAGE.SET_TOKEN('EXPECTED','RESPONSIBILITY_ID');
1640: FND_MSG_PUB.Add;
1641: end if;
1642: -- dbms_output.put_line('Expecting responsibility ID');
1643: raise FND_API.G_EXC_ERROR;
1644: end if;

Line 1650: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1646: if (l_token is not null) then
1647: l_excluded_items_rec.resp_application_id := to_number(l_token);
1648: l_state := 4;
1649: else
1650: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1651: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1652: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1653: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1654: FND_MESSAGE.SET_TOKEN('EXPECTED','RESP_APPLICATION_ID');

Line 1655: FND_MSG_PUB.Add;

1651: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1652: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1653: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1654: FND_MESSAGE.SET_TOKEN('EXPECTED','RESP_APPLICATION_ID');
1655: FND_MSG_PUB.Add;
1656: end if;
1657: --dbms_output.put_line('Expecting resp application id');
1658: raise FND_API.G_EXC_ERROR;
1659: end if;

Line 1665: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1661: if (l_token is not null) then
1662: l_excluded_items_rec.attribute_application_id := to_number(l_token);
1663: l_state := 5;
1664: else
1665: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1666: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1667: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1668: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1669: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_CODE');

Line 1670: FND_MSG_PUB.Add;

1666: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1667: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1668: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1669: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_CODE');
1670: FND_MSG_PUB.Add;
1671: end if;
1672: --dbms_output.put_line('Expecting attribute code');
1673: raise FND_API.G_EXC_ERROR;
1674: end if;

Line 1681: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1677: l_excluded_items_rec.attribute_code := l_token;
1678: l_value_count := null;
1679: l_state := 10;
1680: else
1681: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1682: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1683: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1684: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1685: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_APPLICATION_ID');

Line 1686: FND_MSG_PUB.Add;

1682: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1683: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1684: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1685: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_APPLICATION_ID');
1686: FND_MSG_PUB.Add;
1687: end if;
1688: --dbms_output.put_line('Expecting attribute code');
1689: raise FND_API.G_EXC_ERROR;
1690: end if;

Line 1719: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1715: l_saved_token := l_token;
1716: end if;
1717: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1718: (l_value_count is null) then
1719: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1720: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1721: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1722: if (l_value_count is null) then
1723: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

Line 1728: FND_MSG_PUB.Add;

1724: else
1725: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1726: end if;
1727: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE');
1728: FND_MSG_PUB.Add;
1729: end if;
1730: -- dbms_output.put_line('Expecting attribute field or END');
1731: raise FND_API.G_EXC_ERROR;
1732: end if;

Line 1738: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1734: elsif (l_state = 11) then
1735: if (l_token = '=') then
1736: l_state := 12;
1737: else
1738: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1739: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1740: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1741: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1742: FND_MESSAGE.SET_TOKEN('EXPECTED','=');

Line 1743: FND_MSG_PUB.Add;

1739: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1740: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1741: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1742: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
1743: FND_MSG_PUB.Add;
1744: end if;
1745: raise FND_API.G_EXC_ERROR;
1746: end if;
1747: elsif (l_state = 12) then

Line 1770: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1766: elsif (l_column = 'LAST_UPDATE_LOGIN') then
1767: l_excluded_items_rec.last_update_login := to_number(l_token);
1768: l_state := 10;
1769: else
1770: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1771: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1772: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1773: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1774: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);

Line 1775: FND_MSG_PUB.Add;

1771: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1772: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1773: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1774: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);
1775: FND_MSG_PUB.Add;
1776: end if;
1777: --dbms_output.put_line('Expecting ' || l_column || ' value');
1778: raise FND_API.G_EXC_ERROR;
1779: end if;

Line 1823: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1819: end if; -- /* if l_return_status */
1820: end if; -- /* if EXCLUDED_ITEM_EXISTS */
1821: l_state := 0;
1822: else
1823: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1824: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1825: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1826: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1827: FND_MESSAGE.SET_TOKEN('EXPECTED','EXCLUDED_ITEMS');

Line 1828: FND_MSG_PUB.Add;

1824: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1825: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1826: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1827: FND_MESSAGE.SET_TOKEN('EXPECTED','EXCLUDED_ITEMS');
1828: FND_MSG_PUB.Add;
1829: end if;
1830: raise FND_API.G_EXC_ERROR;
1831: end if;
1832: elsif (l_state = 30) then

Line 1860: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1856: l_saved_token := l_token;
1857: end if;
1858: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1859: (l_value_count is null) then
1860: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1861: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1862: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1863: if (l_value_count is null) then
1864: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

Line 1869: FND_MSG_PUB.Add;

1865: else
1866: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1867: end if;
1868: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE');
1869: FND_MSG_PUB.Add;
1870: end if;
1871: -- dbms_output.put_line('Expecting attribute field or END');
1872: raise FND_API.G_EXC_ERROR;
1873: end if;

Line 1880: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1876: if (l_token is not null) then
1877: l_resp_sec_attr_rec.responsibility_id := to_number(l_token);
1878: l_state := 33;
1879: else
1880: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1881: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1882: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1883: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1884: FND_MESSAGE.SET_TOKEN('EXPECTED','RESPONSIBILITY_ID');

Line 1885: FND_MSG_PUB.Add;

1881: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1882: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1883: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1884: FND_MESSAGE.SET_TOKEN('EXPECTED','RESPONSIBILITY_ID');
1885: FND_MSG_PUB.Add;
1886: end if;
1887: -- dbms_output.put_line('Expecting responsibility ID');
1888: raise FND_API.G_EXC_ERROR;
1889: end if;

Line 1895: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1891: if (l_token is not null) then
1892: l_resp_sec_attr_rec.resp_application_id := to_number(l_token);
1893: l_state := 34;
1894: else
1895: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1896: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1897: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1898: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1899: FND_MESSAGE.SET_TOKEN('EXPECTED','RESP_APPLICATION_ID');

Line 1900: FND_MSG_PUB.Add;

1896: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1897: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1898: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1899: FND_MESSAGE.SET_TOKEN('EXPECTED','RESP_APPLICATION_ID');
1900: FND_MSG_PUB.Add;
1901: end if;
1902: --dbms_output.put_line('Expecting resp application id');
1903: raise FND_API.G_EXC_ERROR;
1904: end if;

Line 1910: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1906: if (l_token is not null) then
1907: l_resp_sec_attr_rec.attribute_application_id := to_number(l_token);
1908: l_state := 35;
1909: else
1910: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1911: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1912: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1913: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1914: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_APPLICATION_ID');

Line 1915: FND_MSG_PUB.Add;

1911: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1912: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1913: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1914: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_APPLICATION_ID');
1915: FND_MSG_PUB.Add;
1916: end if;
1917: --dbms_output.put_line('Expecting attribute code');
1918: raise FND_API.G_EXC_ERROR;
1919: end if;

Line 1926: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1922: l_resp_sec_attr_rec.attribute_code := l_token;
1923: l_value_count := null;
1924: l_state := 30;
1925: else
1926: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1927: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1928: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1929: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1930: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_CODE');

Line 1931: FND_MSG_PUB.Add;

1927: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1928: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1929: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1930: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_CODE');
1931: FND_MSG_PUB.Add;
1932: end if;
1933: --dbms_output.put_line('Expecting attribute code');
1934: raise FND_API.G_EXC_ERROR;
1935: end if;

Line 1940: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1936: elsif (l_state = 36) then
1937: if (l_token = '=') then
1938: l_state := 37;
1939: else
1940: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1941: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1942: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1943: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1944: FND_MESSAGE.SET_TOKEN('EXPECTED','=');

Line 1945: FND_MSG_PUB.Add;

1941: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1942: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1943: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1944: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
1945: FND_MSG_PUB.Add;
1946: end if;
1947: raise FND_API.G_EXC_ERROR;
1948: end if;
1949: elsif (l_state = 37) then

Line 1972: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1968: elsif (l_column = 'LAST_UPDATE_LOGIN') then
1969: l_resp_sec_attr_rec.last_update_login := to_number(l_token);
1970: l_state := 30;
1971: else
1972: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1973: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1974: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1975: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1976: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);

Line 1977: FND_MSG_PUB.Add;

1973: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1974: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1975: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1976: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);
1977: FND_MSG_PUB.Add;
1978: end if;
1979: --dbms_output.put_line('Expecting ' || l_column || ' value');
1980: raise FND_API.G_EXC_ERROR;
1981: end if;

Line 2026: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2022: end if; -- /* if l_return_status */
2023: end if; -- /* if RESP_SECURITY_ATTR_EXISTS */
2024: l_state := 0;
2025: else
2026: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2027: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2028: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2029: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2030: FND_MESSAGE.SET_TOKEN('EXPECTED','RESP_SECURITY_ATTRIBUTES');

Line 2031: FND_MSG_PUB.Add;

2027: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2028: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2029: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2030: FND_MESSAGE.SET_TOKEN('EXPECTED','RESP_SECURITY_ATTRIBUTES');
2031: FND_MSG_PUB.Add;
2032: end if;
2033: raise FND_API.G_EXC_ERROR;
2034: end if;
2035: end if;

Line 2077: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2073: -- (state 0) or when the beginning of another business object was
2074: -- detected, then the file must have ended prematurely, which is an error
2075: --
2076: if (l_state <> 0) and (l_more_item) then
2077: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2078: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2079: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2080: FND_MESSAGE.SET_TOKEN('TOKEN','END OF FILE');
2081: FND_MESSAGE.SET_TOKEN('EXPECTED',null);

Line 2082: FND_MSG_PUB.Add;

2078: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2079: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2080: FND_MESSAGE.SET_TOKEN('TOKEN','END OF FILE');
2081: FND_MESSAGE.SET_TOKEN('EXPECTED',null);
2082: FND_MSG_PUB.Add;
2083: end if;
2084: --dbms_output.put_line('Unexpected END OF FILE: state is ' ||
2085: -- to_char(l_state));
2086: raise FND_API.G_EXC_ERROR;

Line 2104: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

2100: WHEN FND_API.G_EXC_ERROR THEN
2101: p_return_status := FND_API.G_RET_STS_ERROR;
2102: WHEN OTHERS THEN
2103: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2104: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2105: SUBSTR (SQLERRM, 1, 240) );
2106: FND_MSG_PUB.Add;
2107: end UPLOAD_SECURITY;
2108:

Line 2106: FND_MSG_PUB.Add;

2102: WHEN OTHERS THEN
2103: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2104: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2105: SUBSTR (SQLERRM, 1, 240) );
2106: FND_MSG_PUB.Add;
2107: end UPLOAD_SECURITY;
2108:
2109:
2110: --=======================================================

Line 2179: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2175: --
2176: if ((p_responsibility_appl_id is null) or
2177: (p_responsibility_appl_id = FND_API.G_MISS_NUM)) then
2178: l_error := TRUE;
2179: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2180: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2181: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESP_APPLICATION_ID');
2182: FND_MSG_PUB.Add;
2183: end if;

Line 2182: FND_MSG_PUB.Add;

2178: l_error := TRUE;
2179: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2180: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2181: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESP_APPLICATION_ID');
2182: FND_MSG_PUB.Add;
2183: end if;
2184: end if;
2185:
2186: if ((p_responsibility_id is null) or

Line 2189: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2185:
2186: if ((p_responsibility_id is null) or
2187: (p_responsibility_id = FND_API.G_MISS_NUM)) then
2188: l_error := TRUE;
2189: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2190: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2191: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESPONSIBILITY_ID');
2192: FND_MSG_PUB.Add;
2193: end if;

Line 2192: FND_MSG_PUB.Add;

2188: l_error := TRUE;
2189: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2190: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2191: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESPONSIBILITY_ID');
2192: FND_MSG_PUB.Add;
2193: end if;
2194: end if;
2195:
2196: if ((p_attribute_application_id is null) or

Line 2199: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2195:
2196: if ((p_attribute_application_id is null) or
2197: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
2198: l_error := TRUE;
2199: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2200: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2201: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
2202: FND_MSG_PUB.Add;
2203: end if;

Line 2202: FND_MSG_PUB.Add;

2198: l_error := TRUE;
2199: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2200: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2201: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
2202: FND_MSG_PUB.Add;
2203: end if;
2204: end if;
2205:
2206: if ((p_attribute_code is null) or

Line 2209: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2205:
2206: if ((p_attribute_code is null) or
2207: (p_attribute_code = FND_API.G_MISS_CHAR)) then
2208: l_error := TRUE;
2209: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2210: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2211: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
2212: FND_MSG_PUB.Add;
2213: end if;

Line 2212: FND_MSG_PUB.Add;

2208: l_error := TRUE;
2209: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2210: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2211: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
2212: FND_MSG_PUB.Add;
2213: end if;
2214: end if;
2215:
2216:

Line 2227: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2223: p_return_status => l_return_status,
2224: p_application_id => p_responsibility_appl_id)
2225: ) then
2226: l_error := TRUE;
2227: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2228: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
2229: FND_MESSAGE.SET_TOKEN('COLUMN','RESP_APPLICATION_ID');
2230: FND_MSG_PUB.Add;
2231: end if;

Line 2230: FND_MSG_PUB.Add;

2226: l_error := TRUE;
2227: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2228: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
2229: FND_MESSAGE.SET_TOKEN('COLUMN','RESP_APPLICATION_ID');
2230: FND_MSG_PUB.Add;
2231: end if;
2232: end if;
2233: end if;
2234:

Line 2243: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2239: p_return_status => l_return_status,
2240: p_application_id => p_attribute_application_id)
2241: ) then
2242: l_error := TRUE;
2243: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2244: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
2245: FND_MESSAGE.SET_TOKEN('COLUMN','ATTRIBUTE_APPLICATION_ID');
2246: FND_MSG_PUB.Add;
2247: end if;

Line 2246: FND_MSG_PUB.Add;

2242: l_error := TRUE;
2243: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2244: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
2245: FND_MESSAGE.SET_TOKEN('COLUMN','ATTRIBUTE_APPLICATION_ID');
2246: FND_MSG_PUB.Add;
2247: end if;
2248: end if;
2249: end if;
2250:

Line 2261: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

2257: p_return_status := FND_API.G_RET_STS_ERROR;
2258: return FALSE;
2259: WHEN OTHERS THEN
2260: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2261: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2262: SUBSTR (SQLERRM, 1, 240) );
2263: FND_MSG_PUB.Add;
2264: return FALSE;
2265:

Line 2263: FND_MSG_PUB.Add;

2259: WHEN OTHERS THEN
2260: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2261: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2262: SUBSTR (SQLERRM, 1, 240) );
2263: FND_MSG_PUB.Add;
2264: return FALSE;
2265:
2266: end VALIDATE_SECURITY;
2267: