DBA Data[Home] [Help]

APPS.AK_SECURITY_PVT dependencies on FND_MESSAGE

Line 236: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_EXISTS');

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;
240: end if;

Line 337: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_CREATED');

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) ||
341: ' ' || p_attribute_code);

Line 338: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||

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) ||
341: ' ' || p_attribute_code);
342: FND_MSG_PUB.Add;

Line 355: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_VALUE_ERROR');

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');
359: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||

Line 356: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_attribute_application_id) ||

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');
359: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||
360: ' '||to_char(p_resp_application_id)||

Line 358: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_NOT_CREATED');

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');
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);

Line 359: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||

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');
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;

Line 372: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_NOT_CREATED');

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) ||
376: ' ' || p_attribute_code);

Line 373: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||

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) ||
376: ' ' || p_attribute_code);
377: FND_MSG_PUB.Add;

Line 478: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_EXISTS');

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;
482: end if;

Line 576: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_CREATED');

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) ||
580: ' ' || p_attribute_code);

Line 577: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||

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) ||
580: ' ' || p_attribute_code);
581: FND_MSG_PUB.Add;

Line 594: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_VALUE_ERROR');

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) ||
598: ' ' || p_attribute_code);

Line 595: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||

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) ||
598: ' ' || p_attribute_code);
599: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_NOT_CREATED');

Line 599: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_NOT_CREATED');

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) ||
598: ' ' || p_attribute_code);
599: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_NOT_CREATED');
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);

Line 600: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||

596: ' '||to_char(p_resp_application_id)||
597: ' '||to_char(p_attribute_application_id) ||
598: ' ' || p_attribute_code);
599: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_NOT_CREATED');
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;

Line 613: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_NOT_CREATED');

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) ||
617: ' ' || p_attribute_code);

Line 614: FND_MESSAGE.SET_TOKEN('KEY',to_char(p_responsibility_id)||

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) ||
617: ' ' || p_attribute_code);
618: FND_MSG_PUB.Add;

Line 749: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_VALUE_ERROR');

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);
753: FND_MSG_PUB.Add;

Line 750: FND_MESSAGE.SET_TOKEN('KEY',

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);
753: FND_MSG_PUB.Add;
754: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_NOT_DWNLOADED');

Line 754: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_NOT_DWNLOADED');

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);
758: FND_MSG_PUB.Add;

Line 755: 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);
758: FND_MSG_PUB.Add;
759: end if;

Line 763: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_NOT_DWNLOADED');

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);
767: FND_MSG_PUB.Add;

Line 764: FND_MESSAGE.SET_TOKEN('KEY',

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);
767: FND_MSG_PUB.Add;
768: end if;

Line 889: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_VALUE_ERROR');

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);
893: FND_MSG_PUB.Add;

Line 890: FND_MESSAGE.SET_TOKEN('KEY',

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);
893: FND_MSG_PUB.Add;
894: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_NOT_DOWNLOADED');

Line 894: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_NOT_DOWNLOADED');

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);
898: FND_MSG_PUB.Add;

Line 895: 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);
898: FND_MSG_PUB.Add;
899: end if;

Line 903: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_NOT_DOWNLOADED');

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);
907: FND_MSG_PUB.Add;

Line 904: FND_MESSAGE.SET_TOKEN('KEY',

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);
907: FND_MSG_PUB.Add;
908: end if;

Line 1000: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');

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;
1004: else

Line 1017: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LIST');

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;
1021: raise FND_API.G_EXC_ERROR;

Line 1018: FND_MESSAGE.SET_TOKEN('ELEMENT_NUM',to_char(i));

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;
1021: raise FND_API.G_EXC_ERROR;
1022: end if; /* if responsibility_appl_id is null */

Line 1091: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_DOES_NOT_EXIST');

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) ||
1095: ' ' || p_excluded_pk_tbl(i).attribute_code);

Line 1093: FND_MESSAGE.SET_NAME('AK','AK_EXCL_ITEM_NOT_DOWNLOADED');

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;
1097: end if;

Line 1094: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_responsibility_appl_id) ||

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;
1097: end if;
1098: l_responsibility_found := FALSE;

Line 1217: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');

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;
1221: else

Line 1234: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LIST');

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;
1238: raise FND_API.G_EXC_ERROR;

Line 1235: FND_MESSAGE.SET_TOKEN('ELEMENT_NUM',to_char(i));

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;
1238: raise FND_API.G_EXC_ERROR;
1239: end if; /* if responsibility_appl_id is null */

Line 1308: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_DOES_NOT_EXIS');

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) ||
1312: ' ' || p_resp_pk_tbl(i).attribute_code);

Line 1310: FND_MESSAGE.SET_NAME('AK','AK_RESP_SEC_ATTR_NOT_DWNLOADED');

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;
1314: end if;

Line 1311: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_responsibility_appl_id) ||

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;
1314: end if;
1315: l_responsibility_found := FALSE;

Line 1571: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');

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;
1575: end if;

Line 1595: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');

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');
1599: raise FND_API.G_EXC_ERROR;

Line 1610: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

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');
1614: FND_MSG_PUB.Add;

Line 1611: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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');
1614: FND_MSG_PUB.Add;
1615: end if;

Line 1612: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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');
1614: FND_MSG_PUB.Add;
1615: end if;
1616: raise FND_API.G_EXC_ERROR;

Line 1613: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');

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');
1614: FND_MSG_PUB.Add;
1615: end if;
1616: raise FND_API.G_EXC_ERROR;
1617: end if;

Line 1636: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

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');
1640: FND_MSG_PUB.Add;

Line 1637: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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');
1640: FND_MSG_PUB.Add;
1641: end if;

Line 1638: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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');
1640: FND_MSG_PUB.Add;
1641: end if;
1642: -- dbms_output.put_line('Expecting responsibility ID');

Line 1639: FND_MESSAGE.SET_TOKEN('EXPECTED','RESPONSIBILITY_ID');

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');
1640: FND_MSG_PUB.Add;
1641: end if;
1642: -- dbms_output.put_line('Expecting responsibility ID');
1643: raise FND_API.G_EXC_ERROR;

Line 1651: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

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');
1655: FND_MSG_PUB.Add;

Line 1652: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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');
1655: FND_MSG_PUB.Add;
1656: end if;

Line 1653: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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');
1655: FND_MSG_PUB.Add;
1656: end if;
1657: --dbms_output.put_line('Expecting resp application id');

Line 1654: FND_MESSAGE.SET_TOKEN('EXPECTED','RESP_APPLICATION_ID');

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');
1655: FND_MSG_PUB.Add;
1656: end if;
1657: --dbms_output.put_line('Expecting resp application id');
1658: raise FND_API.G_EXC_ERROR;

Line 1666: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

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');
1670: FND_MSG_PUB.Add;

Line 1667: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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');
1670: FND_MSG_PUB.Add;
1671: end if;

Line 1668: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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');
1670: FND_MSG_PUB.Add;
1671: end if;
1672: --dbms_output.put_line('Expecting attribute code');

Line 1669: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_CODE');

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');
1670: FND_MSG_PUB.Add;
1671: end if;
1672: --dbms_output.put_line('Expecting attribute code');
1673: raise FND_API.G_EXC_ERROR;

Line 1682: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

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');
1686: FND_MSG_PUB.Add;

Line 1683: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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');
1686: FND_MSG_PUB.Add;
1687: end if;

Line 1684: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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');
1686: FND_MSG_PUB.Add;
1687: end if;
1688: --dbms_output.put_line('Expecting attribute code');

Line 1685: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_APPLICATION_ID');

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');
1686: FND_MSG_PUB.Add;
1687: end if;
1688: --dbms_output.put_line('Expecting attribute code');
1689: raise FND_API.G_EXC_ERROR;

Line 1720: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');

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);
1724: else

Line 1721: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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);
1724: else
1725: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

Line 1723: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

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);
1724: else
1725: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1726: end if;
1727: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE');

Line 1725: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

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);
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;

Line 1727: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE');

1723: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
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;

Line 1739: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

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','=');
1743: FND_MSG_PUB.Add;

Line 1740: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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','=');
1743: FND_MSG_PUB.Add;
1744: end if;

Line 1741: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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','=');
1743: FND_MSG_PUB.Add;
1744: end if;
1745: raise FND_API.G_EXC_ERROR;

Line 1742: FND_MESSAGE.SET_TOKEN('EXPECTED','=');

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','=');
1743: FND_MSG_PUB.Add;
1744: end if;
1745: raise FND_API.G_EXC_ERROR;
1746: end if;

Line 1771: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

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);
1775: FND_MSG_PUB.Add;

Line 1772: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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);
1775: FND_MSG_PUB.Add;
1776: end if;

Line 1773: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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);
1775: FND_MSG_PUB.Add;
1776: end if;
1777: --dbms_output.put_line('Expecting ' || l_column || ' value');

Line 1774: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);

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);
1775: FND_MSG_PUB.Add;
1776: end if;
1777: --dbms_output.put_line('Expecting ' || l_column || ' value');
1778: raise FND_API.G_EXC_ERROR;

Line 1824: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

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');
1828: FND_MSG_PUB.Add;

Line 1825: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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');
1828: FND_MSG_PUB.Add;
1829: end if;

Line 1826: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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');
1828: FND_MSG_PUB.Add;
1829: end if;
1830: raise FND_API.G_EXC_ERROR;

Line 1827: FND_MESSAGE.SET_TOKEN('EXPECTED','EXCLUDED_ITEMS');

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');
1828: FND_MSG_PUB.Add;
1829: end if;
1830: raise FND_API.G_EXC_ERROR;
1831: end if;

Line 1861: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');

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);
1865: else

Line 1862: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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);
1865: else
1866: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

Line 1864: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

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);
1865: else
1866: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1867: end if;
1868: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE');

Line 1866: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

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);
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;

Line 1868: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE');

1864: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
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;

Line 1881: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

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');
1885: FND_MSG_PUB.Add;

Line 1882: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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');
1885: FND_MSG_PUB.Add;
1886: end if;

Line 1883: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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');
1885: FND_MSG_PUB.Add;
1886: end if;
1887: -- dbms_output.put_line('Expecting responsibility ID');

Line 1884: FND_MESSAGE.SET_TOKEN('EXPECTED','RESPONSIBILITY_ID');

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');
1885: FND_MSG_PUB.Add;
1886: end if;
1887: -- dbms_output.put_line('Expecting responsibility ID');
1888: raise FND_API.G_EXC_ERROR;

Line 1896: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

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');
1900: FND_MSG_PUB.Add;

Line 1897: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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');
1900: FND_MSG_PUB.Add;
1901: end if;

Line 1898: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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');
1900: FND_MSG_PUB.Add;
1901: end if;
1902: --dbms_output.put_line('Expecting resp application id');

Line 1899: FND_MESSAGE.SET_TOKEN('EXPECTED','RESP_APPLICATION_ID');

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');
1900: FND_MSG_PUB.Add;
1901: end if;
1902: --dbms_output.put_line('Expecting resp application id');
1903: raise FND_API.G_EXC_ERROR;

Line 1911: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

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');
1915: FND_MSG_PUB.Add;

Line 1912: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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');
1915: FND_MSG_PUB.Add;
1916: end if;

Line 1913: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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');
1915: FND_MSG_PUB.Add;
1916: end if;
1917: --dbms_output.put_line('Expecting attribute code');

Line 1914: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_APPLICATION_ID');

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');
1915: FND_MSG_PUB.Add;
1916: end if;
1917: --dbms_output.put_line('Expecting attribute code');
1918: raise FND_API.G_EXC_ERROR;

Line 1927: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

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');
1931: FND_MSG_PUB.Add;

Line 1928: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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');
1931: FND_MSG_PUB.Add;
1932: end if;

Line 1929: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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');
1931: FND_MSG_PUB.Add;
1932: end if;
1933: --dbms_output.put_line('Expecting attribute code');

Line 1930: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_CODE');

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');
1931: FND_MSG_PUB.Add;
1932: end if;
1933: --dbms_output.put_line('Expecting attribute code');
1934: raise FND_API.G_EXC_ERROR;

Line 1941: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

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','=');
1945: FND_MSG_PUB.Add;

Line 1942: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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','=');
1945: FND_MSG_PUB.Add;
1946: end if;

Line 1943: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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','=');
1945: FND_MSG_PUB.Add;
1946: end if;
1947: raise FND_API.G_EXC_ERROR;

Line 1944: FND_MESSAGE.SET_TOKEN('EXPECTED','=');

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','=');
1945: FND_MSG_PUB.Add;
1946: end if;
1947: raise FND_API.G_EXC_ERROR;
1948: end if;

Line 1973: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

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);
1977: FND_MSG_PUB.Add;

Line 1974: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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);
1977: FND_MSG_PUB.Add;
1978: end if;

Line 1975: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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);
1977: FND_MSG_PUB.Add;
1978: end if;
1979: --dbms_output.put_line('Expecting ' || l_column || ' value');

Line 1976: FND_MESSAGE.SET_TOKEN('EXPECTED',l_column);

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);
1977: FND_MSG_PUB.Add;
1978: end if;
1979: --dbms_output.put_line('Expecting ' || l_column || ' value');
1980: raise FND_API.G_EXC_ERROR;

Line 2027: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

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');
2031: FND_MSG_PUB.Add;

Line 2028: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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');
2031: FND_MSG_PUB.Add;
2032: end if;

Line 2029: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

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');
2031: FND_MSG_PUB.Add;
2032: end if;
2033: raise FND_API.G_EXC_ERROR;

Line 2030: FND_MESSAGE.SET_TOKEN('EXPECTED','RESP_SECURITY_ATTRIBUTES');

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');
2031: FND_MSG_PUB.Add;
2032: end if;
2033: raise FND_API.G_EXC_ERROR;
2034: end if;

Line 2078: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

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);
2082: FND_MSG_PUB.Add;

Line 2079: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

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);
2082: FND_MSG_PUB.Add;
2083: end if;

Line 2080: FND_MESSAGE.SET_TOKEN('TOKEN','END OF FILE');

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);
2082: FND_MSG_PUB.Add;
2083: end if;
2084: --dbms_output.put_line('Unexpected END OF FILE: state is ' ||

Line 2081: FND_MESSAGE.SET_TOKEN('EXPECTED',null);

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);
2082: FND_MSG_PUB.Add;
2083: end if;
2084: --dbms_output.put_line('Unexpected END OF FILE: state is ' ||
2085: -- to_char(l_state));

Line 2180: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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;
2184: end if;

Line 2181: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESP_APPLICATION_ID');

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;
2184: end if;
2185:

Line 2190: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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;
2194: end if;

Line 2191: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESPONSIBILITY_ID');

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;
2194: end if;
2195:

Line 2200: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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;
2204: end if;

Line 2201: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');

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;
2204: end if;
2205:

Line 2210: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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;
2214: end if;

Line 2211: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');

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;
2214: end if;
2215:

Line 2228: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');

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;
2232: end if;

Line 2229: FND_MESSAGE.SET_TOKEN('COLUMN','RESP_APPLICATION_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;
2232: end if;
2233: end if;

Line 2244: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');

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;
2248: end if;

Line 2245: FND_MESSAGE.SET_TOKEN('COLUMN','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;
2248: end if;
2249: end if;