APPS.AK_REGION2_PVT dependencies on FND_MSG_PUB

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

182: --
183: -- Error if there is nothing to be read from the file
184: --
185: if (l_buffer is null and l_eof_flag = 'Y') then
186: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
187: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');
188: FND_MSG_PUB.Add;
189: end if;
190: raise FND_API.G_EXC_ERROR;

Line 188: FND_MSG_PUB.Add;

184: --
185: if (l_buffer is null and l_eof_flag = 'Y') then
186: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
187: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');
188: FND_MSG_PUB.Add;
189: end if;
190: raise FND_API.G_EXC_ERROR;
191: end if;
192:

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

204: --dbms_output.put_line(' State:' || l_state || 'Token:' || l_token);
205:
206: if (l_return_status = FND_API.G_RET_STS_ERROR) or
207: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
208: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
209: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
210: FND_MSG_PUB.Add;
211: end if;
212: --dbms_output.put_line(l_api_name || ' Error parsing buffer');

Line 210: FND_MSG_PUB.Add;

206: if (l_return_status = FND_API.G_RET_STS_ERROR) or
207: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
208: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
209: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
210: FND_MSG_PUB.Add;
211: end if;
212: --dbms_output.put_line(l_api_name || ' Error parsing buffer');
213: raise FND_API.G_EXC_ERROR;
214: end if;

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

220: if (l_state = 0) then
221: if (l_token = 'BEGIN') then
222: l_state := 1;
223: else
224: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
225: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
226: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
227: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
228: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');

Line 229: FND_MSG_PUB.Add;

225: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
226: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
227: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
228: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
229: FND_MSG_PUB.Add;
230: end if;
231: raise FND_API.G_EXC_ERROR;
232: end if;
233: elsif (l_state = 1) then

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

255: l_region_rec.region_code := l_token;
256: l_value_count := null;
257: l_state := 10;
258: else
259: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
260: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
261: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
262: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
263: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_CODE');

Line 264: FND_MSG_PUB.Add;

260: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
261: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
262: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
263: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_CODE');
264: FND_MSG_PUB.Add;
265: end if;
266: raise FND_API.G_EXC_ERROR;
267: end if;
268: elsif (l_state = 10) then

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

341: l_saved_token := l_token;
342: end if;
343: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
344: (l_value_count is null) then
345: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
346: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
347: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
348: if (l_value_count is null) then
349: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

Line 354: FND_MSG_PUB.Add;

350: else
351: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
352: end if;
353: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION');
354: FND_MSG_PUB.Add;
355: end if;
356: -- dbms_output.put_line('Expecting region field, BEGIN, or END');
357: raise FND_API.G_EXC_ERROR;
358: end if;

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

360: elsif (l_state = 11) then
361: if (l_token = '=') then
362: l_state := 12;
363: else
364: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
365: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
366: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
367: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
368: FND_MESSAGE.SET_TOKEN('EXPECTED','=');

Line 369: FND_MSG_PUB.Add;

365: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
366: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
367: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
368: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
369: FND_MSG_PUB.Add;
370: end if;
371: raise FND_API.G_EXC_ERROR;
372: end if;
373: elsif (l_state = 12) then

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

482: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
483: elsif (l_column = 'LAST_UPDATE_LOGIN') then
484: l_region_rec.last_update_login := to_number(l_token);
485: else
486: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
487: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
488: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
489: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
490: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

Line 491: FND_MSG_PUB.Add;

487: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
488: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
489: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
490: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
491: FND_MSG_PUB.Add;
492: end if;
493: raise FND_API.G_EXC_ERROR;
494: end if;
495: l_state := 10;

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

534: -- l_graph_column_rec.region_code := l_graph_rec.region_code;
535: -- l_graph_column_rec.graph_number := l_graph_rec.graph_number;
536: l_state := 400;
537: else
538: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
539: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
540: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
541: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
542: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_ITEM, REGION_LOV_RELATION, CATEGORY_USAGE');

Line 543: FND_MSG_PUB.Add;

539: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
540: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
541: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
542: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_ITEM, REGION_LOV_RELATION, CATEGORY_USAGE');
543: FND_MSG_PUB.Add;
544: end if;
545: raise FND_API.G_EXC_ERROR;
546: end if;
547: elsif (l_state = 19) then

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

549: l_state := 0;
550: l_region_index := l_region_index + 1;
551: l_region_tbl(l_region_index) := l_region_rec;
552: else
553: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
554: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
555: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
556: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
557: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION');

Line 558: FND_MSG_PUB.Add;

554: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
555: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
556: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
557: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION');
558: FND_MSG_PUB.Add;
559: end if;
560: raise FND_API.G_EXC_ERROR;
561: end if;
562:

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

567: if (l_token is not null) then
568: l_item_rec.attribute_application_id := to_number(l_token);
569: l_state := 21;
570: else
571: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
572: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
573: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
574: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
575: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');

Line 576: FND_MSG_PUB.Add;

572: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
573: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
574: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
575: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
576: FND_MSG_PUB.Add;
577: end if;
578: raise FND_API.G_EXC_ERROR;
579: end if;
580: elsif (l_state = 21) then

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

582: l_item_rec.attribute_code := l_token;
583: l_value_count := null;
584: l_state := 30;
585: else
586: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
587: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
588: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
589: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
590: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');

Line 591: FND_MSG_PUB.Add;

587: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
588: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
589: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
590: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
591: FND_MSG_PUB.Add;
592: end if;
593: raise FND_API.G_EXC_ERROR;
594: end if;
595: elsif (l_state = 30) then

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

702: l_saved_token := l_token;
703: end if;
704: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
705: (l_value_count is null) then
706: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
707: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
708: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
709: if (l_value_count is null) then
710: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

Line 715: FND_MSG_PUB.Add;

711: else
712: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
713: end if;
714: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_ITEM');
715: FND_MSG_PUB.Add;
716: end if;
717: raise FND_API.G_EXC_ERROR;
718: end if;
719: end if;

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

720: elsif (l_state = 31) then
721: if (l_token = '=') then
722: l_state := 32;
723: else
724: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
725: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
726: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
727: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
728: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');

Line 729: FND_MSG_PUB.Add;

725: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
726: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
727: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
728: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
729: FND_MSG_PUB.Add;
730: end if;
731: raise FND_API.G_EXC_ERROR;
732: end if;
733: elsif (l_state = 32) then

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

999: elsif (l_column = 'DESCRIPTION') then
1000: l_item_rec.DESCRIPTION := l_token;
1001: l_state := 30;
1002: else
1003: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1004: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1005: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1006: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1007: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');

Line 1008: FND_MSG_PUB.Add;

1004: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1005: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1006: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1007: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1008: FND_MSG_PUB.Add;
1009: end if;
1010: raise FND_API.G_EXC_ERROR;
1011: end if;
1012: elsif (l_state = 34) then

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

1016: elsif (l_column = 'LOV_ATTRIBUTE') then
1017: l_item_rec.lov_attribute_code := l_token;
1018: l_state := 30;
1019: else
1020: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1021: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1022: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1023: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1024: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

Line 1025: FND_MSG_PUB.Add;

1021: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1022: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1023: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1024: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
1025: FND_MSG_PUB.Add;
1026: end if;
1027: raise FND_API.G_EXC_ERROR;
1028: end if;
1029: elsif (l_state = 39) then

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

1032: l_state := 10;
1033: l_item_index := l_item_index + 1;
1034: l_item_tbl(l_item_index) := l_item_rec;
1035: else
1036: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1037: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1038: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1039: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1040: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_ITEM');

Line 1041: FND_MSG_PUB.Add;

1037: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1038: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1039: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1040: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_ITEM');
1041: FND_MSG_PUB.Add;
1042: end if;
1043: raise FND_API.G_EXC_ERROR;
1044: end if;
1045:

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

1050: if (l_token is not null) then
1051: l_lov_relation_rec.lov_region_appl_id := to_number(l_token);
1052: l_state := 101;
1053: else
1054: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1055: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1056: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1057: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1058: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_REGION_APPL_ID');

Line 1059: FND_MSG_PUB.Add;

1055: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1056: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1057: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1058: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_REGION_APPL_ID');
1059: FND_MSG_PUB.Add;
1060: end if;
1061: raise FND_API.G_EXC_ERROR;
1062: end if;
1063: elsif (l_state = 101) then

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

1065: l_lov_relation_rec.lov_region_code := l_token;
1066: l_value_count := null;
1067: l_state := 102;
1068: else
1069: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1070: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1071: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1072: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1073: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_REGION_CODE');

Line 1074: FND_MSG_PUB.Add;

1070: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1071: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1072: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1073: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_REGION_CODE');
1074: FND_MSG_PUB.Add;
1075: end if;
1076: raise FND_API.G_EXC_ERROR;
1077: end if;
1078: elsif (l_state = 102) then

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

1079: if (l_token is not null) then
1080: l_lov_relation_rec.lov_attribute_appl_id := to_number(l_token);
1081: l_state := 103;
1082: else
1083: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1084: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1085: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1086: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1087: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_ATTRIBUTE_APPL_ID');

Line 1088: FND_MSG_PUB.Add;

1084: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1085: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1086: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1087: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_ATTRIBUTE_APPL_ID');
1088: FND_MSG_PUB.Add;
1089: end if;
1090: raise FND_API.G_EXC_ERROR;
1091: end if;
1092: elsif (l_state = 103) then

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

1094: l_lov_relation_rec.lov_attribute_code := l_token;
1095: l_value_count := null;
1096: l_state := 104;
1097: else
1098: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1099: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1100: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1101: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1102: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_ATTRIBUTE_CODE');

Line 1103: FND_MSG_PUB.Add;

1099: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1100: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1101: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1102: FND_MESSAGE.SET_TOKEN('EXPECTED', 'LOV_ATTRIBUTE_CODE');
1103: FND_MSG_PUB.Add;
1104: end if;
1105: raise FND_API.G_EXC_ERROR;
1106: end if;
1107: elsif (l_state = 104) then

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

1108: if (l_token is not null) then
1109: l_lov_relation_rec.base_attribute_appl_id := to_number(l_token);
1110: l_state := 105;
1111: else
1112: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1113: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1114: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1115: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1116: FND_MESSAGE.SET_TOKEN('EXPECTED', 'BASE_ATTRIBUTE_APPL_ID');

Line 1117: FND_MSG_PUB.Add;

1113: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1114: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1115: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1116: FND_MESSAGE.SET_TOKEN('EXPECTED', 'BASE_ATTRIBUTE_APPL_ID');
1117: FND_MSG_PUB.Add;
1118: end if;
1119: raise FND_API.G_EXC_ERROR;
1120: end if;
1121: elsif (l_state = 105) then

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

1123: l_lov_relation_rec.base_attribute_code := l_token;
1124: l_value_count := null;
1125: l_state := 106;
1126: else
1127: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1128: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1129: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1130: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1131: FND_MESSAGE.SET_TOKEN('EXPECTED', 'BASE_ATTRIBUTE_CODE');

Line 1132: FND_MSG_PUB.Add;

1128: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1129: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1130: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1131: FND_MESSAGE.SET_TOKEN('EXPECTED', 'BASE_ATTRIBUTE_CODE');
1132: FND_MSG_PUB.Add;
1133: end if;
1134: raise FND_API.G_EXC_ERROR;
1135: end if;
1136: elsif (l_state = 106) then

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

1138: l_lov_relation_rec.direction_flag := l_token;
1139: l_value_count := null;
1140: l_state := 130;
1141: else
1142: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1143: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1144: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1145: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1146: FND_MESSAGE.SET_TOKEN('EXPECTED', 'DIRECTION_FLAG');

Line 1147: FND_MSG_PUB.Add;

1143: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1144: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1145: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1146: FND_MESSAGE.SET_TOKEN('EXPECTED', 'DIRECTION_FLAG');
1147: FND_MSG_PUB.Add;
1148: end if;
1149: raise FND_API.G_EXC_ERROR;
1150: end if;
1151: elsif (l_state = 130) then

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

1177: l_saved_token := l_token;
1178: end if;
1179: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1180: (l_value_count is null) then
1181: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1182: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1183: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1184: if (l_value_count is null) then
1185: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

Line 1190: FND_MSG_PUB.Add;

1186: else
1187: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1188: end if;
1189: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_LOV_RELATION');
1190: FND_MSG_PUB.Add;
1191: end if;
1192: raise FND_API.G_EXC_ERROR;
1193: end if;
1194: end if;

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

1195: elsif (l_state = 131) then
1196: if (l_token = '=') then
1197: l_state := 132;
1198: else
1199: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1200: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1201: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1202: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1203: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');

Line 1204: FND_MSG_PUB.Add;

1200: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1201: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1202: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1203: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1204: FND_MSG_PUB.Add;
1205: end if;
1206: raise FND_API.G_EXC_ERROR;
1207: end if;
1208: elsif (l_state = 132) then

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

1236: elsif (l_column = 'LAST_UPDATE_LOGIN') then
1237: l_lov_relation_rec.last_update_login := to_number(l_token);
1238: l_state := 130;
1239: else
1240: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1241: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1242: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1243: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1244: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');

Line 1245: FND_MSG_PUB.Add;

1241: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1242: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1243: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1244: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1245: FND_MSG_PUB.Add;
1246: end if;
1247: raise FND_API.G_EXC_ERROR;
1248: end if;
1249: elsif (l_state = 139) then

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

1252: l_state := 30;
1253: l_lov_relation_index := l_lov_relation_index + 1;
1254: l_lov_relation_tbl(l_lov_relation_index) := l_lov_relation_rec;
1255: else
1256: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1257: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1258: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1259: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1260: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_LOV_RELATION');

Line 1261: FND_MSG_PUB.Add;

1257: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1258: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1259: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1260: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_LOV_RELATION');
1261: FND_MSG_PUB.Add;
1262: end if;
1263: raise FND_API.G_EXC_ERROR;
1264: end if;
1265:

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

1272: -- select name into l_category_usage_rec.category_name from fnd_document_categories where category_id = l_category_usage_rec.category_id;
1273: l_value_count := null;
1274: l_state := 230;
1275: else
1276: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1277: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1278: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1279: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1280: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CATEGORY_ID');

Line 1281: FND_MSG_PUB.Add;

1277: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1278: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1279: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1280: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CATEGORY_ID');
1281: FND_MSG_PUB.Add;
1282: end if;
1283: raise FND_API.G_EXC_ERROR;
1284: end if;
1285: elsif (l_state = 230) then

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

1311: l_saved_token := l_token;
1312: end if;
1313: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1314: (l_value_count is null) then
1315: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1316: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1317: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1318: if (l_value_count is null) then
1319: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

Line 1324: FND_MSG_PUB.Add;

1320: else
1321: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1322: end if;
1323: FND_MESSAGE.SET_TOKEN('EXPECTED','CATEGORY_USAGE');
1324: FND_MSG_PUB.Add;
1325: end if;
1326: raise FND_API.G_EXC_ERROR;
1327: end if;
1328: end if;

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

1329: elsif (l_state = 231) then
1330: if (l_token = '=') then
1331: l_state := 232;
1332: else
1333: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1334: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1335: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1336: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1337: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');

Line 1338: FND_MSG_PUB.Add;

1334: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1335: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1336: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1337: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1338: FND_MSG_PUB.Add;
1339: end if;
1340: raise FND_API.G_EXC_ERROR;
1341: end if;
1342: elsif (l_state = 232) then

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

1370: elsif (l_column = 'LAST_UPDATE_LOGIN') then
1371: l_category_usage_rec.last_update_login := to_number(l_token);
1372: l_state := 230;
1373: else
1374: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1375: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1376: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1377: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1378: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');

Line 1379: FND_MSG_PUB.Add;

1375: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1376: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1377: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1378: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1379: FND_MSG_PUB.Add;
1380: end if;
1381: raise FND_API.G_EXC_ERROR;
1382: end if;
1383: elsif (l_state = 239) then

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

1386: l_state := 30;
1387: l_category_usage_index := l_category_usage_index + 1;
1388: l_category_usage_tbl(l_category_usage_index) := l_category_usage_rec;
1389: else
1390: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1391: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1392: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1393: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1394: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CATEGORY_USAGE');

Line 1395: FND_MSG_PUB.Add;

1391: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1392: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1393: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1394: FND_MESSAGE.SET_TOKEN('EXPECTED', 'CATEGORY_USAGE');
1395: FND_MSG_PUB.Add;
1396: end if;
1397: raise FND_API.G_EXC_ERROR;
1398: end if;
1399:

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

1404: if (l_token is not null) then
1405: -- l_graph_rec.graph_number := to_number(l_token);
1406: l_state := 310;
1407: else
1408: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1409: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1410: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1411: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1412: FND_MESSAGE.SET_TOKEN('EXPECTED', 'GRAPH_NUMBER');

Line 1413: FND_MSG_PUB.Add;

1409: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1410: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1411: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1412: FND_MESSAGE.SET_TOKEN('EXPECTED', 'GRAPH_NUMBER');
1413: FND_MSG_PUB.Add;
1414: end if;
1415: raise FND_API.G_EXC_ERROR;
1416: end if;
1417: elsif (l_state = 310) then

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

1446: l_saved_token := l_token;
1447: end if;
1448: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1449: (l_value_count is null) then
1450: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1451: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1452: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1453: if (l_value_count is null) then
1454: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

Line 1459: FND_MSG_PUB.Add;

1455: else
1456: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1457: end if;
1458: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_GRAPH');
1459: FND_MSG_PUB.Add;
1460: end if;
1461: raise FND_API.G_EXC_ERROR;
1462: end if;
1463: end if;

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

1464: elsif (l_state = 311) then
1465: if (l_token = '=') then
1466: l_state := 312;
1467: else
1468: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1469: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1470: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1471: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1472: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');

Line 1473: FND_MSG_PUB.Add;

1469: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1470: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1471: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1472: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
1473: FND_MSG_PUB.Add;
1474: end if;
1475: raise FND_API.G_EXC_ERROR;
1476: end if;
1477: elsif (l_state = 312) then

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

1508: elsif (l_column = 'LAST_UPDATE_LOGIN') then
1509: -- l_graph_rec.last_update_login := to_number(l_token);
1510: l_state := 310;
1511: else
1512: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1513: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1514: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1515: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1516: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');

Line 1517: FND_MSG_PUB.Add;

1513: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1514: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1515: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1516: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
1517: FND_MSG_PUB.Add;
1518: end if;
1519: raise FND_API.G_EXC_ERROR;
1520: end if;
1521: elsif (l_state = 319) then

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

1524: l_state := 10;
1525: -- l_graph_index := l_graph_index + 1;
1526: -- l_graph_tbl(l_graph_index) := l_graph_rec;
1527: else
1528: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1529: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1530: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1531: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1532: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_GRAPH');

Line 1533: FND_MSG_PUB.Add;

1529: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1530: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1531: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1532: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_GRAPH');
1533: FND_MSG_PUB.Add;
1534: end if;
1535: raise FND_API.G_EXC_ERROR;
1536: end if;
1537:

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

1542: if (l_token is not null) then
1543: -- l_graph_column_rec.attribute_application_id := to_number(l_token);
1544: l_state := 401;
1545: else
1546: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1547: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1548: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1549: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1550: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');

Line 1551: FND_MSG_PUB.Add;

1547: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1548: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1549: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1550: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
1551: FND_MSG_PUB.Add;
1552: end if;
1553: raise FND_API.G_EXC_ERROR;
1554: end if;
1555: elsif (l_state = 401) then

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

1557: -- l_graph_column_rec.attribute_code := l_token;
1558: l_value_count := null;
1559: l_state := 410;
1560: else
1561: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1562: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1563: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1564: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1565: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');

Line 1566: FND_MSG_PUB.Add;

1562: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
1563: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1564: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1565: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
1566: FND_MSG_PUB.Add;
1567: end if;
1568: raise FND_API.G_EXC_ERROR;
1569: end if;
1570: elsif (l_state = 410) then

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

1585: l_saved_token := l_token;
1586: end if;
1587: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
1588: (l_value_count is null) then
1589: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1590: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
1591: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1592: if (l_value_count is null) then
1593: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

Line 1598: FND_MSG_PUB.Add;

1594: else
1595: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
1596: end if;
1597: FND_MESSAGE.SET_TOKEN('EXPECTED','REGION_GRAPH_COLUMN');
1598: FND_MSG_PUB.Add;
1599: end if;
1600: raise FND_API.G_EXC_ERROR;
1601: end if;
1602: end if;

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

1606: l_state := 310;
1607: -- l_graph_column_index := l_graph_column_index + 1;
1608: -- l_graph_column_tbl(l_graph_column_index) := l_graph_column_rec;
1609: else
1610: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1611: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1612: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1613: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1614: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_GRAPH_COLUMN');

Line 1615: FND_MSG_PUB.Add;

1611: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1612: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1613: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
1614: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_GRAPH_COLUMN');
1615: FND_MSG_PUB.Add;
1616: end if;
1617: raise FND_API.G_EXC_ERROR;
1618: end if;
1619:

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

1653: -- If the loops end in a state other then at the end of a region
1654: -- (state 0) or when the beginning of another business object was
1655: -- detected, then the file must have ended prematurely, which is an error
1656: if (l_state <> 0) and (l_more_region) then
1657: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1658: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1659: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1660: FND_MESSAGE.SET_TOKEN('TOKEN', 'END OF FILE');
1661: FND_MESSAGE.SET_TOKEN('EXPECTED', null);

Line 1662: FND_MSG_PUB.Add;

1658: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
1659: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
1660: FND_MESSAGE.SET_TOKEN('TOKEN', 'END OF FILE');
1661: FND_MESSAGE.SET_TOKEN('EXPECTED', null);
1662: FND_MSG_PUB.Add;
1663: end if;
1664: --dbms_output.put_line('Unexpected END OF FILE: state is ' ||
1665: -- to_char(l_state));
1666: raise FND_API.G_EXC_ERROR;

Line 2541: FND_MSG_PUB.Add;

2537: fetch l_check_fnd_category_name_csr into l_category_usage_tbl(l_index).category_name;
2538: if (l_check_fnd_category_name_csr%notfound) then
2539: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_SKIPPED');
2540: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_category_usage_tbl(l_index).category_id));
2541: FND_MSG_PUB.Add;
2542: end if;
2543: close l_check_fnd_category_name_csr;
2544: elsif (l_category_usage_tbl(l_index).category_name is not null) then
2545: open l_check_fnd_category_id_csr(l_category_usage_tbl(l_index).category_name);

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

2544: elsif (l_category_usage_tbl(l_index).category_name is not null) then
2545: open l_check_fnd_category_id_csr(l_category_usage_tbl(l_index).category_name);
2546: fetch l_check_fnd_category_id_csr into l_category_usage_tbl(l_index).category_id;
2547: if (l_check_fnd_category_id_csr%notfound) then
2548: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2549: FND_MESSAGE.SET_NAME('AK','AK_FND_CATEGORY_DOES_NOT_EXIST');
2550: FND_MESSAGE.SET_TOKEN('KEY', (l_category_usage_tbl(l_index).category_name));
2551: FND_MSG_PUB.Add;
2552: end if;

Line 2551: FND_MSG_PUB.Add;

2547: if (l_check_fnd_category_id_csr%notfound) then
2548: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2549: FND_MESSAGE.SET_NAME('AK','AK_FND_CATEGORY_DOES_NOT_EXIST');
2550: FND_MESSAGE.SET_TOKEN('KEY', (l_category_usage_tbl(l_index).category_name));
2551: FND_MSG_PUB.Add;
2552: end if;
2553: close l_check_fnd_category_id_csr;
2554: raise FND_API.G_EXC_ERROR;
2555: end if;

Line 2892: FND_MSG_PUB.Add;

2888: p_return_status := FND_API.G_RET_STS_ERROR;
2889: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
2890: FND_MESSAGE.SET_TOKEN('KEY',to_char(l_region_rec.region_application_id)||' '||
2891: l_region_rec.region_code);
2892: FND_MSG_PUB.Add;
2893: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2894: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );
2895: FND_MSG_PUB.Add;
2896: WHEN OTHERS THEN

Line 2893: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

2889: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
2890: FND_MESSAGE.SET_TOKEN('KEY',to_char(l_region_rec.region_application_id)||' '||
2891: l_region_rec.region_code);
2892: FND_MSG_PUB.Add;
2893: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2894: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );
2895: FND_MSG_PUB.Add;
2896: WHEN OTHERS THEN
2897: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2895: FND_MSG_PUB.Add;

2891: l_region_rec.region_code);
2892: FND_MSG_PUB.Add;
2893: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2894: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );
2895: FND_MSG_PUB.Add;
2896: WHEN OTHERS THEN
2897: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2898: --rollback to Start_Upload;
2899: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 2899: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

2895: FND_MSG_PUB.Add;
2896: WHEN OTHERS THEN
2897: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2898: --rollback to Start_Upload;
2899: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2900: SUBSTR (SQLERRM, 1, 240) );
2901: FND_MSG_PUB.Add;
2902: end UPLOAD_REGION;
2903:

Line 2901: FND_MSG_PUB.Add;

2897: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2898: --rollback to Start_Upload;
2899: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2900: SUBSTR (SQLERRM, 1, 240) );
2901: FND_MSG_PUB.Add;
2902: end UPLOAD_REGION;
2903:
2904: --=======================================================
2905: -- Procedure UPLOAD_REGION_SECOND

Line 3640: FND_MSG_PUB.Count_And_Get (

3636:
3637: EXCEPTION
3638: WHEN FND_API.G_EXC_ERROR THEN
3639: p_return_status := FND_API.G_RET_STS_ERROR;
3640: FND_MSG_PUB.Count_And_Get (
3641: p_count => l_msg_count,
3642: p_data => l_msg_data);
3643: WHEN OTHERS THEN
3644: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3645: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

3641: p_count => l_msg_count,
3642: p_data => l_msg_data);
3643: WHEN OTHERS THEN
3644: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3645: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3646: SUBSTR (SQLERRM, 1, 240) );
3647: FND_MSG_PUB.Count_And_Get (
3648: p_count => l_msg_count,
3649: p_data => l_msg_data);

Line 3647: FND_MSG_PUB.Count_And_Get (

3643: WHEN OTHERS THEN
3644: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3645: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3646: SUBSTR (SQLERRM, 1, 240) );
3647: FND_MSG_PUB.Count_And_Get (
3648: p_count => l_msg_count,
3649: p_data => l_msg_data);
3650:
3651: end UPLOAD_REGION_SECOND;

Line 3870: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

3866: WHEN FND_API.G_EXC_ERROR THEN
3867: p_return_status := FND_API.G_RET_STS_ERROR;
3868: WHEN OTHERS THEN
3869: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3870: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3871: SUBSTR (SQLERRM, 1, 240) );
3872: FND_MSG_PUB.Add;
3873:
3874: end CHECK_DISPLAY_SEQUENCE;

Line 3872: FND_MSG_PUB.Add;

3868: WHEN OTHERS THEN
3869: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3870: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3871: SUBSTR (SQLERRM, 1, 240) );
3872: FND_MSG_PUB.Add;
3873:
3874: end CHECK_DISPLAY_SEQUENCE;
3875:
3876: /*

Line 3947: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

3943: p_return_status := FND_API.G_RET_STS_ERROR;
3944: return FALSE;
3945: WHEN OTHERS THEN
3946: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3947: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3948: SUBSTR (SQLERRM, 1, 240) );
3949: FND_MSG_PUB.Add;
3950: return FALSE;
3951: end GRAPH_COLUMN_EXISTS;

Line 3949: FND_MSG_PUB.Add;

3945: WHEN OTHERS THEN
3946: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3947: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3948: SUBSTR (SQLERRM, 1, 240) );
3949: FND_MSG_PUB.Add;
3950: return FALSE;
3951: end GRAPH_COLUMN_EXISTS;
3952: */
3953:

Line 4040: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

4036: p_return_status := FND_API.G_RET_STS_ERROR;
4037: return FALSE;
4038: WHEN OTHERS THEN
4039: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4040: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4041: SUBSTR (SQLERRM, 1, 240) );
4042: FND_MSG_PUB.Add;
4043: return FALSE;
4044: end LOV_RELATION_EXISTS;

Line 4042: FND_MSG_PUB.Add;

4038: WHEN OTHERS THEN
4039: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4040: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4041: SUBSTR (SQLERRM, 1, 240) );
4042: FND_MSG_PUB.Add;
4043: return FALSE;
4044: end LOV_RELATION_EXISTS;
4045:
4046: /*

Line 4134: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4130: --** check that key columns are not null and not missing **
4131: if ((p_region_application_id is null) or
4132: (p_region_application_id = FND_API.G_MISS_NUM)) then
4133: l_error := TRUE;
4134: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4135: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4136: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4137: FND_MSG_PUB.Add;
4138: end if;

Line 4137: FND_MSG_PUB.Add;

4133: l_error := TRUE;
4134: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4135: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4136: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4137: FND_MSG_PUB.Add;
4138: end if;
4139: end if;
4140:
4141: if ((p_region_code is null) or

Line 4144: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4140:
4141: if ((p_region_code is null) or
4142: (p_region_code = FND_API.G_MISS_CHAR)) then
4143: l_error := TRUE;
4144: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4145: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4146: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4147: FND_MSG_PUB.Add;
4148: end if;

Line 4147: FND_MSG_PUB.Add;

4143: l_error := TRUE;
4144: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4145: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4146: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4147: FND_MSG_PUB.Add;
4148: end if;
4149: end if;
4150:
4151: if ((p_attribute_application_id is null) or

Line 4154: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4150:
4151: if ((p_attribute_application_id is null) or
4152: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
4153: l_error := TRUE;
4154: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4155: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4156: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4157: FND_MSG_PUB.Add;
4158: end if;

Line 4157: FND_MSG_PUB.Add;

4153: l_error := TRUE;
4154: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4155: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4156: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4157: FND_MSG_PUB.Add;
4158: end if;
4159: end if;
4160:
4161: if ((p_attribute_code is null) or

Line 4164: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4160:
4161: if ((p_attribute_code is null) or
4162: (p_attribute_code = FND_API.G_MISS_CHAR)) then
4163: l_error := TRUE;
4164: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4165: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4166: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4167: FND_MSG_PUB.Add;
4168: end if;

Line 4167: FND_MSG_PUB.Add;

4163: l_error := TRUE;
4164: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4165: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4166: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4167: FND_MSG_PUB.Add;
4168: end if;
4169: end if;
4170:
4171: if ((p_graph_number is null) or

Line 4174: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4170:
4171: if ((p_graph_number is null) or
4172: (p_graph_number = FND_API.G_MISS_NUM)) then
4173: l_error := TRUE;
4174: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4175: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4176: FND_MESSAGE.SET_TOKEN('COLUMN', 'GRAPH_NUMBER');
4177: FND_MSG_PUB.Add;
4178: end if;

Line 4177: FND_MSG_PUB.Add;

4173: l_error := TRUE;
4174: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4175: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4176: FND_MESSAGE.SET_TOKEN('COLUMN', 'GRAPH_NUMBER');
4177: FND_MSG_PUB.Add;
4178: end if;
4179: end if;
4180:
4181: -- - Check that the parent region item exists

Line 4186: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4182: open l_check_region_item_csr(p_region_code, p_region_application_id, p_attribute_application_id, p_attribute_code);
4183: fetch l_check_region_item_csr into l_dummy;
4184: if (l_check_region_item_csr%notfound) then
4185: l_error := TRUE;
4186: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4187: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
4188: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4189: ' ' || p_region_code ||' '||
4190: to_char(p_attribute_application_id) || ' '||

Line 4192: FND_MSG_PUB.Add;

4188: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4189: ' ' || p_region_code ||' '||
4190: to_char(p_attribute_application_id) || ' '||
4191: p_attribute_code);
4192: FND_MSG_PUB.Add;
4193: end if;
4194: end if;
4195: close l_check_region_item_csr;
4196:

Line 4202: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4198: open l_check_region_graph_csr(p_region_code, p_region_application_id, p_graph_number);
4199: fetch l_check_Region_graph_csr into l_dummy;
4200: if (l_check_region_graph_csr%notfound) then
4201: l_error := TRUE;
4202: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4203: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_GRAPH_REFERENCE');
4204: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4205: ' ' || p_region_code ||' '||
4206: p_graph_number);

Line 4207: FND_MSG_PUB.Add;

4203: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_GRAPH_REFERENCE');
4204: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4205: ' ' || p_region_code ||' '||
4206: p_graph_number);
4207: FND_MSG_PUB.Add;
4208: end if;
4209: end if;
4210: close l_check_region_graph_csr;
4211:

Line 4222: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

4218: p_return_status := FND_API.G_RET_STS_ERROR;
4219: return FALSE;
4220: WHEN OTHERS THEN
4221: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4222: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4223: SUBSTR (SQLERRM, 1, 240) );
4224: FND_MSG_PUB.Add;
4225: return FALSE;
4226:

Line 4224: FND_MSG_PUB.Add;

4220: WHEN OTHERS THEN
4221: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4222: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4223: SUBSTR (SQLERRM, 1, 240) );
4224: FND_MSG_PUB.Add;
4225: return FALSE;
4226:
4227: end VALIDATE_GRAPH_COLUMN;
4228: */

Line 4321: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4317: --** check that key columns are not null and not missing **
4318: if ((p_region_application_id is null) or
4319: (p_region_application_id = FND_API.G_MISS_NUM)) then
4320: l_error := TRUE;
4321: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4322: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4323: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4324: FND_MSG_PUB.Add;
4325: end if;

Line 4324: FND_MSG_PUB.Add;

4320: l_error := TRUE;
4321: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4322: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4323: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4324: FND_MSG_PUB.Add;
4325: end if;
4326: end if;
4327:
4328: if ((p_region_code is null) or

Line 4331: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4327:
4328: if ((p_region_code is null) or
4329: (p_region_code = FND_API.G_MISS_CHAR)) then
4330: l_error := TRUE;
4331: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4332: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4333: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4334: FND_MSG_PUB.Add;
4335: end if;

Line 4334: FND_MSG_PUB.Add;

4330: l_error := TRUE;
4331: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4332: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4333: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4334: FND_MSG_PUB.Add;
4335: end if;
4336: end if;
4337:
4338: if ((p_attribute_application_id is null) or

Line 4341: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4337:
4338: if ((p_attribute_application_id is null) or
4339: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
4340: l_error := TRUE;
4341: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4342: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4343: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4344: FND_MSG_PUB.Add;
4345: end if;

Line 4344: FND_MSG_PUB.Add;

4340: l_error := TRUE;
4341: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4342: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4343: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4344: FND_MSG_PUB.Add;
4345: end if;
4346: end if;
4347:
4348: if ((p_attribute_code is null) or

Line 4351: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4347:
4348: if ((p_attribute_code is null) or
4349: (p_attribute_code = FND_API.G_MISS_CHAR)) then
4350: l_error := TRUE;
4351: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4352: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4353: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4354: FND_MSG_PUB.Add;
4355: end if;

Line 4354: FND_MSG_PUB.Add;

4350: l_error := TRUE;
4351: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4352: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4353: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4354: FND_MSG_PUB.Add;
4355: end if;
4356: end if;
4357:
4358: if ((p_lov_region_appl_id is null) or

Line 4361: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4357:
4358: if ((p_lov_region_appl_id is null) or
4359: (p_lov_region_appl_id = FND_API.G_MISS_NUM)) then
4360: l_error := TRUE;
4361: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4362: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4363: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4364: FND_MSG_PUB.Add;
4365: end if;

Line 4364: FND_MSG_PUB.Add;

4360: l_error := TRUE;
4361: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4362: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4363: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4364: FND_MSG_PUB.Add;
4365: end if;
4366: end if;
4367:
4368: if ((p_lov_region_code is null) or

Line 4371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4367:
4368: if ((p_lov_region_code is null) or
4369: (p_lov_region_code = FND_API.G_MISS_CHAR)) then
4370: l_error := TRUE;
4371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4372: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4373: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4374: FND_MSG_PUB.Add;
4375: end if;

Line 4374: FND_MSG_PUB.Add;

4370: l_error := TRUE;
4371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4372: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4373: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4374: FND_MSG_PUB.Add;
4375: end if;
4376: end if;
4377:
4378: if ((p_lov_attribute_appl_id is null) or

Line 4381: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4377:
4378: if ((p_lov_attribute_appl_id is null) or
4379: (p_lov_attribute_appl_id = FND_API.G_MISS_NUM)) then
4380: l_error := TRUE;
4381: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4382: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4383: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4384: FND_MSG_PUB.Add;
4385: end if;

Line 4384: FND_MSG_PUB.Add;

4380: l_error := TRUE;
4381: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4382: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4383: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4384: FND_MSG_PUB.Add;
4385: end if;
4386: end if;
4387:
4388: if ((p_lov_attribute_code is null) or

Line 4391: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4387:
4388: if ((p_lov_attribute_code is null) or
4389: (p_lov_attribute_code = FND_API.G_MISS_CHAR)) then
4390: l_error := TRUE;
4391: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4392: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4393: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4394: FND_MSG_PUB.Add;
4395: end if;

Line 4394: FND_MSG_PUB.Add;

4390: l_error := TRUE;
4391: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4392: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4393: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4394: FND_MSG_PUB.Add;
4395: end if;
4396: end if;
4397:
4398: -- do not raise an error for now, there are ppl who has an old jlt file and upload

Line 4405: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4401: if ((p_base_region_appl_id is null) or
4402: (p_base_region_appl_id = FND_API.G_MISS_NUM)) then
4403:
4404: l_error := TRUE;
4405: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4406: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4407: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_REGION_APPL_ID');
4408: FND_MSG_PUB.Add;
4409: end if;

Line 4408: FND_MSG_PUB.Add;

4404: l_error := TRUE;
4405: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4406: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4407: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_REGION_APPL_ID');
4408: FND_MSG_PUB.Add;
4409: end if;
4410: end if;
4411: **/
4412:

Line 4419: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4415: /**
4416: if ((p_base_region_code is null) or
4417: (p_base_region_code = FND_API.G_MISS_CHAR)) then
4418: l_error := TRUE;
4419: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4420: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4421: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_REGION_CODE');
4422: FND_MSG_PUB.Add;
4423: end if;

Line 4422: FND_MSG_PUB.Add;

4418: l_error := TRUE;
4419: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4420: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4421: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_REGION_CODE');
4422: FND_MSG_PUB.Add;
4423: end if;
4424: end if;
4425: **/
4426:

Line 4432: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4428: --
4429: if ((p_base_attribute_appl_id is null) or
4430: (p_base_attribute_appl_id = FND_API.G_MISS_NUM)) then
4431: l_error := TRUE;
4432: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4433: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4434: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_ATTRIBUTE_APPL_ID');
4435: FND_MSG_PUB.Add;
4436: end if;

Line 4435: FND_MSG_PUB.Add;

4431: l_error := TRUE;
4432: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4433: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4434: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_ATTRIBUTE_APPL_ID');
4435: FND_MSG_PUB.Add;
4436: end if;
4437: end if;
4438:
4439: if ((p_base_attribute_code is null) or

Line 4442: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4438:
4439: if ((p_base_attribute_code is null) or
4440: (p_base_attribute_code = FND_API.G_MISS_CHAR)) then
4441: l_error := TRUE;
4442: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4443: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4444: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_ATTRIBUTE_CODE');
4445: FND_MSG_PUB.Add;
4446: end if;

Line 4445: FND_MSG_PUB.Add;

4441: l_error := TRUE;
4442: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4443: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4444: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_ATTRIBUTE_CODE');
4445: FND_MSG_PUB.Add;
4446: end if;
4447: end if;
4448:
4449: -- - Check that the parent region item exists

Line 4455: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4451: p_attribute_code, p_attribute_application_id);
4452: fetch l_check_region_item_csr into l_dummy;
4453: if (l_check_region_item_csr%notfound) then
4454: l_error := TRUE;
4455: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4456: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
4457: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4458: ' ' || p_region_code ||' '||
4459: to_char(p_attribute_application_id)||' '||p_attribute_code);

Line 4460: FND_MSG_PUB.Add;

4456: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
4457: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4458: ' ' || p_region_code ||' '||
4459: to_char(p_attribute_application_id)||' '||p_attribute_code);
4460: FND_MSG_PUB.Add;
4461: end if;
4462: end if;
4463: close l_check_region_item_csr;
4464:

Line 4470: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4466: open l_check_region_csr(p_lov_region_code, p_lov_region_appl_id);
4467: fetch l_check_region_csr into l_dummy;
4468: if (l_check_region_csr%notfound) then
4469: l_error := TRUE;
4470: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4471: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_REG_REFERENCE');
4472: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4473: ' ' || p_lov_region_code );
4474: FND_MSG_PUB.Add;

Line 4474: FND_MSG_PUB.Add;

4470: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4471: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_REG_REFERENCE');
4472: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4473: ' ' || p_lov_region_code );
4474: FND_MSG_PUB.Add;
4475: end if;
4476: end if;
4477: close l_check_region_csr;
4478:

Line 4485: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4481: p_lov_attribute_code, p_lov_attribute_appl_id);
4482: fetch l_check_region_item_csr into l_dummy;
4483: if (l_check_region_item_csr%notfound) then
4484: l_error := TRUE;
4485: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4486: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_ITEM_REFERENCE');
4487: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4488: ' ' || p_lov_region_code ||' '||
4489: to_char(p_lov_attribute_appl_id)||' '||p_lov_attribute_code);

Line 4490: FND_MSG_PUB.Add;

4486: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_ITEM_REFERENCE');
4487: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4488: ' ' || p_lov_region_code ||' '||
4489: to_char(p_lov_attribute_appl_id)||' '||p_lov_attribute_code);
4490: FND_MSG_PUB.Add;
4491: end if;
4492: end if;
4493: close l_check_region_item_csr;
4494:

Line 4501: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4497: p_base_attribute_code, p_base_attribute_appl_id);
4498: fetch l_check_region_item_csr into l_dummy;
4499: if (l_check_region_item_csr%notfound) then
4500: l_error := TRUE;
4501: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4502: FND_MESSAGE.SET_NAME('AK','AK_INVALID_BASE_ITEM_REF');
4503: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4504: ' ' || p_lov_region_code ||' '||
4505: to_char(p_base_attribute_appl_id)||' '||p_base_attribute_code);

Line 4506: FND_MSG_PUB.Add;

4502: FND_MESSAGE.SET_NAME('AK','AK_INVALID_BASE_ITEM_REF');
4503: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4504: ' ' || p_lov_region_code ||' '||
4505: to_char(p_base_attribute_appl_id)||' '||p_base_attribute_code);
4506: FND_MSG_PUB.Add;
4507: end if;
4508: end if;
4509: close l_check_region_item_csr;
4510:

Line 4520: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4516: p_return_status => l_return_status,
4517: p_lookup_type => 'LOV_DIRECTION',
4518: p_lookup_code => p_direction_flag)) then
4519: l_error := TRUE;
4520: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4521: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
4522: FND_MESSAGE.SET_TOKEN('COLUMN','DIRECTION_FLAG');
4523: FND_MSG_PUB.Add;
4524: end if;

Line 4523: FND_MSG_PUB.Add;

4519: l_error := TRUE;
4520: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4521: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
4522: FND_MESSAGE.SET_TOKEN('COLUMN','DIRECTION_FLAG');
4523: FND_MSG_PUB.Add;
4524: end if;
4525: end if;
4526: else
4527: l_error := TRUE;

Line 4528: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

4524: end if;
4525: end if;
4526: else
4527: l_error := TRUE;
4528: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4529: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4530: FND_MESSAGE.SET_TOKEN('COLUMN', 'DIRECTION_FLAG');
4531: FND_MSG_PUB.Add;
4532: end if;

Line 4531: FND_MSG_PUB.Add;

4527: l_error := TRUE;
4528: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4529: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4530: FND_MESSAGE.SET_TOKEN('COLUMN', 'DIRECTION_FLAG');
4531: FND_MSG_PUB.Add;
4532: end if;
4533: end if;
4534:
4535: -- return true if no error, false otherwise

Line 4545: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

4541: p_return_status := FND_API.G_RET_STS_ERROR;
4542: return FALSE;
4543: WHEN OTHERS THEN
4544: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4545: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4546: SUBSTR (SQLERRM, 1, 240) );
4547: FND_MSG_PUB.Add;
4548: return FALSE;
4549:

Line 4547: FND_MSG_PUB.Add;

4543: WHEN OTHERS THEN
4544: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4545: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4546: SUBSTR (SQLERRM, 1, 240) );
4547: FND_MSG_PUB.Add;
4548: return FALSE;
4549:
4550: end VALIDATE_LOV_RELATION;
4551:

Line 4620: FND_MSG_PUB.initialize;

4616:
4617: -- Initialize the message table if requested.
4618:
4619: if p_init_msg_tbl then
4620: FND_MSG_PUB.initialize;
4621: end if;
4622:
4623: savepoint start_create_graph_column;
4624:

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

4630: p_region_code => p_region_code,
4631: p_attribute_application_id => p_attribute_application_id,
4632: p_attribute_code => p_attribute_code,
4633: p_graph_number => p_graph_number) then
4634: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4635: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_EXISTS');
4636: FND_MSG_PUB.Add;
4637: end if;
4638: raise FND_API.G_EXC_ERROR;

Line 4636: FND_MSG_PUB.Add;

4632: p_attribute_code => p_attribute_code,
4633: p_graph_number => p_graph_number) then
4634: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4635: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_EXISTS');
4636: FND_MSG_PUB.Add;
4637: end if;
4638: raise FND_API.G_EXC_ERROR;
4639: end if;
4640:

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

4706:
4707: -- ** commit the insert **
4708: -- commit;
4709:
4710: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4711: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_CREATED');
4712: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||
4713: p_region_code||' '||
4714: to_char(p_attribute_application_id)||

Line 4717: FND_MSG_PUB.Add;

4713: p_region_code||' '||
4714: to_char(p_attribute_application_id)||
4715: ' '||p_attribute_code||' '||
4716: to_char(p_graph_number));
4717: FND_MSG_PUB.Add;
4718: end if;
4719:
4720: p_return_status := FND_API.G_RET_STS_SUCCESS;
4721:

Line 4722: FND_MSG_PUB.Count_And_Get (

4718: end if;
4719:
4720: p_return_status := FND_API.G_RET_STS_SUCCESS;
4721:
4722: FND_MSG_PUB.Count_And_Get (
4723: p_count => p_msg_count,
4724: p_data => p_msg_data);
4725:
4726: EXCEPTION

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

4724: p_data => p_msg_data);
4725:
4726: EXCEPTION
4727: WHEN VALUE_ERROR THEN
4728: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4729: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_VALUE_ERROR');
4730: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
4731: p_region_code||' '||
4732: to_char(p_attribute_application_id)||

Line 4735: FND_MSG_PUB.Add;

4731: p_region_code||' '||
4732: to_char(p_attribute_application_id)||
4733: ' '||p_attribute_code||' '||
4734: to_char(p_graph_number));
4735: FND_MSG_PUB.Add;
4736: end if;
4737: p_return_status := FND_API.G_RET_STS_ERROR;
4738: rollback to start_create_graph_column;
4739: FND_MSG_PUB.Count_And_Get (

Line 4739: FND_MSG_PUB.Count_And_Get (

4735: FND_MSG_PUB.Add;
4736: end if;
4737: p_return_status := FND_API.G_RET_STS_ERROR;
4738: rollback to start_create_graph_column;
4739: FND_MSG_PUB.Count_And_Get (
4740: p_count => p_msg_count,
4741: p_data => p_msg_data);
4742: WHEN OTHERS THEN
4743: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4745: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

4741: p_data => p_msg_data);
4742: WHEN OTHERS THEN
4743: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4744: rollback to start_create_graph_column;
4745: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4746: SUBSTR (SQLERRM, 1, 240) );
4747: FND_MSG_PUB.Add;
4748: FND_MSG_PUB.Count_And_Get (
4749: p_count => p_msg_count,

Line 4747: FND_MSG_PUB.Add;

4743: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4744: rollback to start_create_graph_column;
4745: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4746: SUBSTR (SQLERRM, 1, 240) );
4747: FND_MSG_PUB.Add;
4748: FND_MSG_PUB.Count_And_Get (
4749: p_count => p_msg_count,
4750: p_data => p_msg_data);
4751:

Line 4748: FND_MSG_PUB.Count_And_Get (

4744: rollback to start_create_graph_column;
4745: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4746: SUBSTR (SQLERRM, 1, 240) );
4747: FND_MSG_PUB.Add;
4748: FND_MSG_PUB.Count_And_Get (
4749: p_count => p_msg_count,
4750: p_data => p_msg_data);
4751:
4752: end CREATE_GRAPH_COLUMN;

Line 4833: FND_MSG_PUB.initialize;

4829:
4830: -- Initialize the message table if requested.
4831:
4832: if p_init_msg_tbl then
4833: FND_MSG_PUB.initialize;
4834: end if;
4835:
4836: savepoint start_create_lov_relation;
4837:

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

4851: p_base_attribute_code => p_base_attribute_code,
4852: p_direction_flag => p_direction_flag,
4853: p_base_region_appl_id => p_base_region_appl_id,
4854: p_base_region_code => p_base_region_code) then
4855: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4856: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_EXISTS');
4857: FND_MSG_PUB.Add;
4858: end if;
4859: raise FND_API.G_EXC_ERROR;

Line 4857: FND_MSG_PUB.Add;

4853: p_base_region_appl_id => p_base_region_appl_id,
4854: p_base_region_code => p_base_region_code) then
4855: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4856: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_EXISTS');
4857: FND_MSG_PUB.Add;
4858: end if;
4859: raise FND_API.G_EXC_ERROR;
4860: end if;
4861:

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

4979:
4980: -- /** commit the insert **/
4981: -- commit;
4982:
4983: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4984: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_CREATED');
4985: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||
4986: p_region_code||' '||to_char(p_attribute_application_id)||
4987: ' '||p_attribute_code||' '||

Line 4992: FND_MSG_PUB.Add;

4988: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||
4989: ' '||to_char(p_lov_attribute_appl_id)||' '||
4990: p_lov_region_code||' '||to_char(p_base_attribute_appl_id)||
4991: ' '||p_base_attribute_code);
4992: FND_MSG_PUB.Add;
4993: end if;
4994:
4995: p_return_status := FND_API.G_RET_STS_SUCCESS;
4996:

Line 4997: FND_MSG_PUB.Count_And_Get (

4993: end if;
4994:
4995: p_return_status := FND_API.G_RET_STS_SUCCESS;
4996:
4997: FND_MSG_PUB.Count_And_Get (
4998: p_count => p_msg_count,
4999: p_data => p_msg_data);
5000:
5001: EXCEPTION

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

4999: p_data => p_msg_data);
5000:
5001: EXCEPTION
5002: WHEN VALUE_ERROR THEN
5003: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5004: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
5005: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5006: p_region_code||' '||to_char(p_attribute_application_id)||
5007: ' '||p_attribute_code||' '||

Line 5012: FND_MSG_PUB.Add;

5008: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||
5009: ' '||to_char(p_lov_attribute_appl_id)||' '||
5010: p_lov_region_code||' '||to_char(p_base_attribute_appl_id)||
5011: ' '||p_base_attribute_code);
5012: FND_MSG_PUB.Add;
5013: end if;
5014: p_return_status := FND_API.G_RET_STS_ERROR;
5015: rollback to start_create_lov_relation;
5016: FND_MSG_PUB.Count_And_Get (

Line 5016: FND_MSG_PUB.Count_And_Get (

5012: FND_MSG_PUB.Add;
5013: end if;
5014: p_return_status := FND_API.G_RET_STS_ERROR;
5015: rollback to start_create_lov_relation;
5016: FND_MSG_PUB.Count_And_Get (
5017: p_count => p_msg_count,
5018: p_data => p_msg_data);
5019: WHEN FND_API.G_EXC_ERROR THEN
5020: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

5016: FND_MSG_PUB.Count_And_Get (
5017: p_count => p_msg_count,
5018: p_data => p_msg_data);
5019: WHEN FND_API.G_EXC_ERROR THEN
5020: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5021: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_CREATED');
5022: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5023: p_region_code||' '||to_char(p_attribute_application_id)||
5024: ' '||p_attribute_code||' '||

Line 5029: FND_MSG_PUB.Add;

5025: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||
5026: ' '||to_char(p_lov_attribute_appl_id)||' '||
5027: p_lov_region_code||' '||to_char(p_base_attribute_appl_id)||
5028: ' '||p_base_attribute_code);
5029: FND_MSG_PUB.Add;
5030: end if;
5031: p_return_status := FND_API.G_RET_STS_ERROR;
5032: rollback to start_create_lov_relation;
5033: FND_MSG_PUB.Count_And_Get (

Line 5033: FND_MSG_PUB.Count_And_Get (

5029: FND_MSG_PUB.Add;
5030: end if;
5031: p_return_status := FND_API.G_RET_STS_ERROR;
5032: rollback to start_create_lov_relation;
5033: FND_MSG_PUB.Count_And_Get (
5034: p_count => p_msg_count,
5035: p_data => p_msg_data);
5036: WHEN OTHERS THEN
5037: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5039: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5035: p_data => p_msg_data);
5036: WHEN OTHERS THEN
5037: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5038: rollback to start_create_region;
5039: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5040: SUBSTR (SQLERRM, 1, 240) );
5041: FND_MSG_PUB.Add;
5042: FND_MSG_PUB.Count_And_Get (
5043: p_count => p_msg_count,

Line 5041: FND_MSG_PUB.Add;

5037: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5038: rollback to start_create_region;
5039: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5040: SUBSTR (SQLERRM, 1, 240) );
5041: FND_MSG_PUB.Add;
5042: FND_MSG_PUB.Count_And_Get (
5043: p_count => p_msg_count,
5044: p_data => p_msg_data);
5045:

Line 5042: FND_MSG_PUB.Count_And_Get (

5038: rollback to start_create_region;
5039: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5040: SUBSTR (SQLERRM, 1, 240) );
5041: FND_MSG_PUB.Add;
5042: FND_MSG_PUB.Count_And_Get (
5043: p_count => p_msg_count,
5044: p_data => p_msg_data);
5045:
5046: end CREATE_LOV_RELATION;

Line 5122: FND_MSG_PUB.initialize;

5118:
5119: -- Initialize the message table if requested.
5120:
5121: if p_init_msg_tbl then
5122: FND_MSG_PUB.initialize;
5123: end if;
5124:
5125: savepoint start_update_graph_columns;
5126:

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

5127: --** retrieve ak_region_graph_columns row if it exists **
5128: open l_get_row_csr;
5129: fetch l_get_row_csr into l_graph_column_rec;
5130: if (l_get_row_csr%notfound) then
5131: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5132: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_DOES_NOT_EXIST');
5133: FND_MSG_PUB.Add;
5134: end if;
5135: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');

Line 5133: FND_MSG_PUB.Add;

5129: fetch l_get_row_csr into l_graph_column_rec;
5130: if (l_get_row_csr%notfound) then
5131: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5132: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_DOES_NOT_EXIST');
5133: FND_MSG_PUB.Add;
5134: end if;
5135: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
5136: close l_get_row_csr;
5137: raise FND_API.G_EXC_ERROR;

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

5194: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
5195: and ATTRIBUTE_CODE = p_attribute_code
5196: and GRAPH_NUMBER = p_graph_number;
5197: if (sql%notfound) then
5198: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5199: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_UPDATE_FAILED');
5200: FND_MSG_PUB.Add;
5201: end if;
5202: raise FND_API.G_EXC_ERROR;

Line 5200: FND_MSG_PUB.Add;

5196: and GRAPH_NUMBER = p_graph_number;
5197: if (sql%notfound) then
5198: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5199: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_UPDATE_FAILED');
5200: FND_MSG_PUB.Add;
5201: end if;
5202: raise FND_API.G_EXC_ERROR;
5203: end if;
5204:

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

5204:
5205: -- ** commit the update **
5206: -- commit;
5207:
5208: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5209: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_UPDATED');
5210: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5211: ' ' || p_region_code);
5212: FND_MSG_PUB.Add;

Line 5212: FND_MSG_PUB.Add;

5208: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5209: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_UPDATED');
5210: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5211: ' ' || p_region_code);
5212: FND_MSG_PUB.Add;
5213: end if;
5214:
5215: p_return_status := FND_API.G_RET_STS_SUCCESS;
5216:

Line 5217: FND_MSG_PUB.Count_And_Get (

5213: end if;
5214:
5215: p_return_status := FND_API.G_RET_STS_SUCCESS;
5216:
5217: FND_MSG_PUB.Count_And_Get (
5218: p_count => p_msg_count,
5219: p_data => p_msg_data);
5220:
5221: EXCEPTION

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

5219: p_data => p_msg_data);
5220:
5221: EXCEPTION
5222: WHEN VALUE_ERROR THEN
5223: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5224: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_VALUE_ERROR');
5225: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5226: p_region_code||' '||
5227: to_char(p_attribute_application_id)||

Line 5230: FND_MSG_PUB.Add;

5226: p_region_code||' '||
5227: to_char(p_attribute_application_id)||
5228: ' '||p_attribute_code||' '||
5229: to_char(p_graph_number));
5230: FND_MSG_PUB.Add;
5231: end if;
5232: rollback to start_update_graph_column;
5233: p_return_status := FND_API.G_RET_STS_ERROR;
5234: FND_MSG_PUB.Count_And_Get (

Line 5234: FND_MSG_PUB.Count_And_Get (

5230: FND_MSG_PUB.Add;
5231: end if;
5232: rollback to start_update_graph_column;
5233: p_return_status := FND_API.G_RET_STS_ERROR;
5234: FND_MSG_PUB.Count_And_Get (
5235: p_count => p_msg_count,
5236: p_data => p_msg_data);
5237: WHEN FND_API.G_EXC_ERROR THEN
5238: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

5234: FND_MSG_PUB.Count_And_Get (
5235: p_count => p_msg_count,
5236: p_data => p_msg_data);
5237: WHEN FND_API.G_EXC_ERROR THEN
5238: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5239: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_NOT_UPDATED');
5240: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5241: p_region_code||' '||
5242: to_char(p_attribute_application_id)||

Line 5245: FND_MSG_PUB.Add;

5241: p_region_code||' '||
5242: to_char(p_attribute_application_id)||
5243: ' '||p_attribute_code||' '||
5244: to_char(p_graph_number));
5245: FND_MSG_PUB.Add;
5246: end if;
5247: p_return_status := FND_API.G_RET_STS_ERROR;
5248: rollback to start_update_graph_column;
5249: FND_MSG_PUB.Count_And_Get (

Line 5249: FND_MSG_PUB.Count_And_Get (

5245: FND_MSG_PUB.Add;
5246: end if;
5247: p_return_status := FND_API.G_RET_STS_ERROR;
5248: rollback to start_update_graph_column;
5249: FND_MSG_PUB.Count_And_Get (
5250: p_count => p_msg_count,
5251: p_data => p_msg_data);
5252: WHEN OTHERS THEN
5253: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5255: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5251: p_data => p_msg_data);
5252: WHEN OTHERS THEN
5253: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5254: rollback to start_update_graph_column;
5255: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5256: SUBSTR (SQLERRM, 1, 240) );
5257: FND_MSG_PUB.Add;
5258: FND_MSG_PUB.Count_And_Get (
5259: p_count => p_msg_count,

Line 5257: FND_MSG_PUB.Add;

5253: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5254: rollback to start_update_graph_column;
5255: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5256: SUBSTR (SQLERRM, 1, 240) );
5257: FND_MSG_PUB.Add;
5258: FND_MSG_PUB.Count_And_Get (
5259: p_count => p_msg_count,
5260: p_data => p_msg_data);
5261: FND_MSG_PUB.Count_And_Get (

Line 5258: FND_MSG_PUB.Count_And_Get (

5254: rollback to start_update_graph_column;
5255: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5256: SUBSTR (SQLERRM, 1, 240) );
5257: FND_MSG_PUB.Add;
5258: FND_MSG_PUB.Count_And_Get (
5259: p_count => p_msg_count,
5260: p_data => p_msg_data);
5261: FND_MSG_PUB.Count_And_Get (
5262: p_count => p_msg_count,

Line 5261: FND_MSG_PUB.Count_And_Get (

5257: FND_MSG_PUB.Add;
5258: FND_MSG_PUB.Count_And_Get (
5259: p_count => p_msg_count,
5260: p_data => p_msg_data);
5261: FND_MSG_PUB.Count_And_Get (
5262: p_count => p_msg_count,
5263: p_data => p_msg_data);
5264:
5265: end UPDATE_GRAPH_COLUMN;

Line 5359: FND_MSG_PUB.initialize;

5355:
5356: -- Initialize the message table if requested.
5357:
5358: if p_init_msg_tbl then
5359: FND_MSG_PUB.initialize;
5360: end if;
5361:
5362: savepoint start_update_lov_relation;
5363:

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

5364: --** retrieve ak_region_lov_relations row if it exists **
5365: open l_get_row_csr;
5366: fetch l_get_row_csr into l_lov_relation_rec;
5367: if (l_get_row_csr%notfound) then
5368: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5369: FND_MESSAGE.SET_NAME('AK','AK_LOV_REGION_DOES_NOT_EXIST');
5370: FND_MSG_PUB.Add;
5371: end if;
5372: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');

Line 5370: FND_MSG_PUB.Add;

5366: fetch l_get_row_csr into l_lov_relation_rec;
5367: if (l_get_row_csr%notfound) then
5368: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5369: FND_MESSAGE.SET_NAME('AK','AK_LOV_REGION_DOES_NOT_EXIST');
5370: FND_MSG_PUB.Add;
5371: end if;
5372: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
5373: close l_get_row_csr;
5374: raise FND_API.G_EXC_ERROR;

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

5470: and DIRECTION_FLAG = p_direction_flag
5471: and BASE_REGION_APPL_ID = p_base_region_appl_id
5472: and BASE_REGION_CODE = p_base_region_code;
5473: if (sql%notfound) then
5474: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5475: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_UPDATE_FAILED');
5476: FND_MSG_PUB.Add;
5477: end if;
5478: raise FND_API.G_EXC_ERROR;

Line 5476: FND_MSG_PUB.Add;

5472: and BASE_REGION_CODE = p_base_region_code;
5473: if (sql%notfound) then
5474: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5475: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_UPDATE_FAILED');
5476: FND_MSG_PUB.Add;
5477: end if;
5478: raise FND_API.G_EXC_ERROR;
5479: end if;
5480:

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

5480:
5481: -- /** commit the update **/
5482: -- commit;
5483:
5484: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5485: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_UPDATED');
5486: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5487: ' ' || p_region_code);
5488: FND_MSG_PUB.Add;

Line 5488: FND_MSG_PUB.Add;

5484: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5485: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_UPDATED');
5486: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5487: ' ' || p_region_code);
5488: FND_MSG_PUB.Add;
5489: end if;
5490:
5491: end if;
5492: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5494: FND_MSG_PUB.Count_And_Get (

5490:
5491: end if;
5492: p_return_status := FND_API.G_RET_STS_SUCCESS;
5493:
5494: FND_MSG_PUB.Count_And_Get (
5495: p_count => p_msg_count,
5496: p_data => p_msg_data);
5497:
5498: EXCEPTION

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

5496: p_data => p_msg_data);
5497:
5498: EXCEPTION
5499: WHEN VALUE_ERROR THEN
5500: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5501: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_VALUE_ERROR');
5502: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5503: p_region_code||' '||to_char(p_attribute_application_id)||
5504: ' '||p_attribute_code||' '||

Line 5510: FND_MSG_PUB.Add;

5506: ' '||to_char(p_lov_attribute_appl_id)||' '||
5507: p_lov_region_code||' '||to_char(p_base_attribute_appl_id)||
5508: ' '||p_base_attribute_code||' '||p_direction_flag ||
5509: ' '||to_char(p_base_region_appl_id)||' '||p_base_region_code);
5510: FND_MSG_PUB.Add;
5511: end if;
5512: rollback to start_update_lov_relation;
5513: p_return_status := FND_API.G_RET_STS_ERROR;
5514: FND_MSG_PUB.Count_And_Get (

Line 5514: FND_MSG_PUB.Count_And_Get (

5510: FND_MSG_PUB.Add;
5511: end if;
5512: rollback to start_update_lov_relation;
5513: p_return_status := FND_API.G_RET_STS_ERROR;
5514: FND_MSG_PUB.Count_And_Get (
5515: p_count => p_msg_count,
5516: p_data => p_msg_data);
5517: WHEN FND_API.G_EXC_ERROR THEN
5518: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

5514: FND_MSG_PUB.Count_And_Get (
5515: p_count => p_msg_count,
5516: p_data => p_msg_data);
5517: WHEN FND_API.G_EXC_ERROR THEN
5518: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5519: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_NOT_UPDATED');
5520: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5521: p_region_code||' '||to_char(p_attribute_application_id)||
5522: ' '||p_attribute_code||' '||

Line 5527: FND_MSG_PUB.Add;

5523: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||
5524: ' '||to_char(p_lov_attribute_appl_id)||' '||
5525: p_lov_region_code||' '||to_char(p_base_attribute_appl_id)||
5526: ' '||p_base_attribute_code);
5527: FND_MSG_PUB.Add;
5528: end if;
5529: p_return_status := FND_API.G_RET_STS_ERROR;
5530: rollback to start_update_lov_relation;
5531: FND_MSG_PUB.Count_And_Get (

Line 5531: FND_MSG_PUB.Count_And_Get (

5527: FND_MSG_PUB.Add;
5528: end if;
5529: p_return_status := FND_API.G_RET_STS_ERROR;
5530: rollback to start_update_lov_relation;
5531: FND_MSG_PUB.Count_And_Get (
5532: p_count => p_msg_count,
5533: p_data => p_msg_data);
5534: WHEN OTHERS THEN
5535: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5537: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5533: p_data => p_msg_data);
5534: WHEN OTHERS THEN
5535: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5536: rollback to start_update_lov_relation;
5537: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5538: SUBSTR (SQLERRM, 1, 240) );
5539: FND_MSG_PUB.Add;
5540: FND_MSG_PUB.Count_And_Get (
5541: p_count => p_msg_count,

Line 5539: FND_MSG_PUB.Add;

5535: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5536: rollback to start_update_lov_relation;
5537: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5538: SUBSTR (SQLERRM, 1, 240) );
5539: FND_MSG_PUB.Add;
5540: FND_MSG_PUB.Count_And_Get (
5541: p_count => p_msg_count,
5542: p_data => p_msg_data);
5543: FND_MSG_PUB.Count_And_Get (

Line 5540: FND_MSG_PUB.Count_And_Get (

5536: rollback to start_update_lov_relation;
5537: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5538: SUBSTR (SQLERRM, 1, 240) );
5539: FND_MSG_PUB.Add;
5540: FND_MSG_PUB.Count_And_Get (
5541: p_count => p_msg_count,
5542: p_data => p_msg_data);
5543: FND_MSG_PUB.Count_And_Get (
5544: p_count => p_msg_count,

Line 5543: FND_MSG_PUB.Count_And_Get (

5539: FND_MSG_PUB.Add;
5540: FND_MSG_PUB.Count_And_Get (
5541: p_count => p_msg_count,
5542: p_data => p_msg_data);
5543: FND_MSG_PUB.Count_And_Get (
5544: p_count => p_msg_count,
5545: p_data => p_msg_data);
5546:
5547: end UPDATE_LOV_RELATION;

Line 5618: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5614: p_return_status := FND_API.G_RET_STS_ERROR;
5615: return FALSE;
5616: WHEN OTHERS THEN
5617: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5618: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5619: SUBSTR (SQLERRM, 1, 240) );
5620: FND_MSG_PUB.Add;
5621: return FALSE;
5622: end CATEGORY_USAGE_EXISTS;

Line 5620: FND_MSG_PUB.Add;

5616: WHEN OTHERS THEN
5617: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5618: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5619: SUBSTR (SQLERRM, 1, 240) );
5620: FND_MSG_PUB.Add;
5621: return FALSE;
5622: end CATEGORY_USAGE_EXISTS;
5623:
5624: --=======================================================

Line 5712: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

5708: --** check that key columns are not null and not missing **
5709: if ((p_region_application_id is null) or
5710: (p_region_application_id = FND_API.G_MISS_NUM)) then
5711: l_error := TRUE;
5712: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5713: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5714: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
5715: FND_MSG_PUB.Add;
5716: end if;

Line 5715: FND_MSG_PUB.Add;

5711: l_error := TRUE;
5712: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5713: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5714: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
5715: FND_MSG_PUB.Add;
5716: end if;
5717: end if;
5718:
5719: if ((p_region_code is null) or

Line 5722: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

5718:
5719: if ((p_region_code is null) or
5720: (p_region_code = FND_API.G_MISS_CHAR)) then
5721: l_error := TRUE;
5722: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5723: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5724: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
5725: FND_MSG_PUB.Add;
5726: end if;

Line 5725: FND_MSG_PUB.Add;

5721: l_error := TRUE;
5722: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5723: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5724: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
5725: FND_MSG_PUB.Add;
5726: end if;
5727: end if;
5728:
5729: if ((p_attribute_application_id is null) or

Line 5732: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

5728:
5729: if ((p_attribute_application_id is null) or
5730: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
5731: l_error := TRUE;
5732: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5733: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5734: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
5735: FND_MSG_PUB.Add;
5736: end if;

Line 5735: FND_MSG_PUB.Add;

5731: l_error := TRUE;
5732: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5733: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5734: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
5735: FND_MSG_PUB.Add;
5736: end if;
5737: end if;
5738:
5739: if ((p_attribute_code is null) or

Line 5742: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

5738:
5739: if ((p_attribute_code is null) or
5740: (p_attribute_code = FND_API.G_MISS_CHAR)) then
5741: l_error := TRUE;
5742: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5743: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5744: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
5745: FND_MSG_PUB.Add;
5746: end if;

Line 5745: FND_MSG_PUB.Add;

5741: l_error := TRUE;
5742: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5743: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5744: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
5745: FND_MSG_PUB.Add;
5746: end if;
5747: end if;
5748:
5749: -- - Check that the parent region item exists

Line 5755: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

5751: p_attribute_code, p_attribute_application_id);
5752: fetch l_check_region_item_csr into l_item_style;
5753: if (l_check_region_item_csr%notfound) then
5754: l_error := TRUE;
5755: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5756: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
5757: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5758: ' ' || p_region_code ||' '||
5759: to_char(p_attribute_application_id)||' '||p_attribute_code);

Line 5760: FND_MSG_PUB.Add;

5756: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
5757: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5758: ' ' || p_region_code ||' '||
5759: to_char(p_attribute_application_id)||' '||p_attribute_code);
5760: FND_MSG_PUB.Add;
5761: end if;
5762: else
5763: if ( l_item_style <> 'ATTACHMENT_LINK' AND l_item_style <> 'ATTACHMENT_IMAGE' AND
5764: l_item_style <> 'ATTACHMENT_TABLE') then

Line 5766: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

5762: else
5763: if ( l_item_style <> 'ATTACHMENT_LINK' AND l_item_style <> 'ATTACHMENT_IMAGE' AND
5764: l_item_style <> 'ATTACHMENT_TABLE') then
5765: l_error := TRUE;
5766: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5767: FND_MESSAGE.SET_NAME('AK','AK_INVALID_ITEM_STYLE');
5768: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5769: ' ' || p_region_code ||' '||
5770: to_char(p_attribute_application_id)||' '||p_attribute_code||' '||l_item_style);

Line 5771: FND_MSG_PUB.Add;

5767: FND_MESSAGE.SET_NAME('AK','AK_INVALID_ITEM_STYLE');
5768: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5769: ' ' || p_region_code ||' '||
5770: to_char(p_attribute_application_id)||' '||p_attribute_code||' '||l_item_style);
5771: FND_MSG_PUB.Add;
5772: end if;
5773: end if; -- l_item_style <> 'ATTACHMENT%'
5774: end if;
5775: close l_check_region_item_csr;

Line 5782: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

5778: open l_check_category_csr(p_category_name);
5779: fetch l_check_category_csr into l_dummy;
5780: if (l_check_category_csr%notfound) then
5781: l_error := TRUE;
5782: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5783: FND_MESSAGE.SET_NAME('AK','AK_INVALID_CATEGORY_REFERENCE');
5784: FND_MESSAGE.SET_TOKEN('KEY', p_category_name);
5785: FND_MSG_PUB.Add;
5786: end if;

Line 5785: FND_MSG_PUB.Add;

5781: l_error := TRUE;
5782: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5783: FND_MESSAGE.SET_NAME('AK','AK_INVALID_CATEGORY_REFERENCE');
5784: FND_MESSAGE.SET_TOKEN('KEY', p_category_name);
5785: FND_MSG_PUB.Add;
5786: end if;
5787: end if;
5788: close l_check_category_csr;
5789:

Line 5800: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5796: p_return_status := FND_API.G_RET_STS_ERROR;
5797: return FALSE;
5798: WHEN OTHERS THEN
5799: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5800: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5801: SUBSTR (SQLERRM, 1, 240) );
5802: FND_MSG_PUB.Add;
5803: return FALSE;
5804:

Line 5802: FND_MSG_PUB.Add;

5798: WHEN OTHERS THEN
5799: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5800: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5801: SUBSTR (SQLERRM, 1, 240) );
5802: FND_MSG_PUB.Add;
5803: return FALSE;
5804:
5805: end VALIDATE_CATEGORY_USAGE;
5806:

Line 5877: FND_MSG_PUB.initialize;

5873:
5874: -- Initialize the message table if requested.
5875:
5876: if p_init_msg_tbl then
5877: FND_MSG_PUB.initialize;
5878: end if;
5879:
5880: savepoint start_create_category_usage;
5881:

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

5887: p_region_code => p_region_code,
5888: p_attribute_application_id => p_attribute_application_id,
5889: p_attribute_code => p_attribute_code,
5890: p_category_name => p_category_name) then
5891: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5892: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_EXISTS');
5893: FND_MSG_PUB.Add;
5894: end if;
5895: raise FND_API.G_EXC_ERROR;

Line 5893: FND_MSG_PUB.Add;

5889: p_attribute_code => p_attribute_code,
5890: p_category_name => p_category_name) then
5891: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5892: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_EXISTS');
5893: FND_MSG_PUB.Add;
5894: end if;
5895: raise FND_API.G_EXC_ERROR;
5896: end if;
5897:

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

5992:
5993: -- /** commit the insert **/
5994: -- commit;
5995:
5996: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5997: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_CREATED');
5998: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||
5999: p_region_code||' '||to_char(p_attribute_application_id)||
6000: ' '||p_attribute_code||' '||

Line 6002: FND_MSG_PUB.Add;

5998: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||
5999: p_region_code||' '||to_char(p_attribute_application_id)||
6000: ' '||p_attribute_code||' '||
6001: p_category_name);
6002: FND_MSG_PUB.Add;
6003: end if;
6004:
6005: p_return_status := FND_API.G_RET_STS_SUCCESS;
6006:

Line 6007: FND_MSG_PUB.Count_And_Get (

6003: end if;
6004:
6005: p_return_status := FND_API.G_RET_STS_SUCCESS;
6006:
6007: FND_MSG_PUB.Count_And_Get (
6008: p_count => p_msg_count,
6009: p_data => p_msg_data);
6010:
6011: EXCEPTION

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

6009: p_data => p_msg_data);
6010:
6011: EXCEPTION
6012: WHEN VALUE_ERROR THEN
6013: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6014: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_VALUE_ERROR');
6015: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6016: p_region_code||' '||to_char(p_attribute_application_id)||
6017: ' '||p_attribute_code||' '||

Line 6019: FND_MSG_PUB.Add;

6015: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6016: p_region_code||' '||to_char(p_attribute_application_id)||
6017: ' '||p_attribute_code||' '||
6018: p_category_name);
6019: FND_MSG_PUB.Add;
6020: end if;
6021: p_return_status := FND_API.G_RET_STS_ERROR;
6022: rollback to start_create_category_usage;
6023: FND_MSG_PUB.Count_And_Get (

Line 6023: FND_MSG_PUB.Count_And_Get (

6019: FND_MSG_PUB.Add;
6020: end if;
6021: p_return_status := FND_API.G_RET_STS_ERROR;
6022: rollback to start_create_category_usage;
6023: FND_MSG_PUB.Count_And_Get (
6024: p_count => p_msg_count,
6025: p_data => p_msg_data);
6026: WHEN FND_API.G_EXC_ERROR THEN
6027: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

6023: FND_MSG_PUB.Count_And_Get (
6024: p_count => p_msg_count,
6025: p_data => p_msg_data);
6026: WHEN FND_API.G_EXC_ERROR THEN
6027: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6028: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_NOT_CREATED');
6029: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6030: p_region_code||' '||to_char(p_attribute_application_id)||
6031: ' '||p_attribute_code||' '||

Line 6033: FND_MSG_PUB.Add;

6029: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6030: p_region_code||' '||to_char(p_attribute_application_id)||
6031: ' '||p_attribute_code||' '||
6032: p_category_name);
6033: FND_MSG_PUB.Add;
6034: end if;
6035: p_return_status := FND_API.G_RET_STS_ERROR;
6036: rollback to start_create_category_usage;
6037: FND_MSG_PUB.Count_And_Get (

Line 6037: FND_MSG_PUB.Count_And_Get (

6033: FND_MSG_PUB.Add;
6034: end if;
6035: p_return_status := FND_API.G_RET_STS_ERROR;
6036: rollback to start_create_category_usage;
6037: FND_MSG_PUB.Count_And_Get (
6038: p_count => p_msg_count,
6039: p_data => p_msg_data);
6040: WHEN OTHERS THEN
6041: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6043: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

6039: p_data => p_msg_data);
6040: WHEN OTHERS THEN
6041: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6042: rollback to start_create_category_usage;
6043: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6044: SUBSTR (SQLERRM, 1, 240) );
6045: FND_MSG_PUB.Add;
6046: FND_MSG_PUB.Count_And_Get (
6047: p_count => p_msg_count,

Line 6045: FND_MSG_PUB.Add;

6041: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6042: rollback to start_create_category_usage;
6043: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6044: SUBSTR (SQLERRM, 1, 240) );
6045: FND_MSG_PUB.Add;
6046: FND_MSG_PUB.Count_And_Get (
6047: p_count => p_msg_count,
6048: p_data => p_msg_data);
6049:

Line 6046: FND_MSG_PUB.Count_And_Get (

6042: rollback to start_create_category_usage;
6043: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6044: SUBSTR (SQLERRM, 1, 240) );
6045: FND_MSG_PUB.Add;
6046: FND_MSG_PUB.Count_And_Get (
6047: p_count => p_msg_count,
6048: p_data => p_msg_data);
6049:
6050: end CREATE_CATEGORY_USAGE;

Line 6127: FND_MSG_PUB.initialize;

6123:
6124: -- Initialize the message table if requested.
6125:
6126: if p_init_msg_tbl then
6127: FND_MSG_PUB.initialize;
6128: end if;
6129:
6130: savepoint start_update_category_usage;
6131:

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

6132: --** retrieve ak_category_usage row if it exists **
6133: open l_get_row_csr;
6134: fetch l_get_row_csr into l_category_usage_rec;
6135: if (l_get_row_csr%notfound) then
6136: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6137: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_DOES_NOT_EXIST');
6138: FND_MESSAGE.SET_TOKEN('KEY', (to_char(p_region_application_id) ||' '||
6139: p_region_code ||' '|| to_char(p_attribute_application_id)||' '||
6140: p_attribute_code ||' '|| p_category_name ||' '||

Line 6142: FND_MSG_PUB.Add;

6138: FND_MESSAGE.SET_TOKEN('KEY', (to_char(p_region_application_id) ||' '||
6139: p_region_code ||' '|| to_char(p_attribute_application_id)||' '||
6140: p_attribute_code ||' '|| p_category_name ||' '||
6141: to_char(p_application_id)));
6142: FND_MSG_PUB.Add;
6143: FND_MSG_PUB.Add;
6144: end if;
6145: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
6146: close l_get_row_csr;

Line 6143: FND_MSG_PUB.Add;

6139: p_region_code ||' '|| to_char(p_attribute_application_id)||' '||
6140: p_attribute_code ||' '|| p_category_name ||' '||
6141: to_char(p_application_id)));
6142: FND_MSG_PUB.Add;
6143: FND_MSG_PUB.Add;
6144: end if;
6145: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
6146: close l_get_row_csr;
6147: raise FND_API.G_EXC_ERROR;

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

6214: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
6215: and ATTRIBUTE_CODE = p_attribute_code
6216: and CATEGORY_NAME = p_category_name;
6217: if (sql%notfound) then
6218: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6219: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_UPDATE_FAILED');
6220: FND_MSG_PUB.Add;
6221: end if;
6222: raise FND_API.G_EXC_ERROR;

Line 6220: FND_MSG_PUB.Add;

6216: and CATEGORY_NAME = p_category_name;
6217: if (sql%notfound) then
6218: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6219: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_UPDATE_FAILED');
6220: FND_MSG_PUB.Add;
6221: end if;
6222: raise FND_API.G_EXC_ERROR;
6223: end if;
6224:

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

6224:
6225: -- /** commit the update **/
6226: -- commit;
6227:
6228: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
6229: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_UPDATED');
6230: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6231: ' ' || p_region_code);
6232: FND_MSG_PUB.Add;

Line 6232: FND_MSG_PUB.Add;

6228: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
6229: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_UPDATED');
6230: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6231: ' ' || p_region_code);
6232: FND_MSG_PUB.Add;
6233: end if;
6234:
6235: end if;
6236:

Line 6239: FND_MSG_PUB.Count_And_Get (

6235: end if;
6236:
6237: p_return_status := FND_API.G_RET_STS_SUCCESS;
6238:
6239: FND_MSG_PUB.Count_And_Get (
6240: p_count => p_msg_count,
6241: p_data => p_msg_data);
6242:
6243: EXCEPTION

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

6241: p_data => p_msg_data);
6242:
6243: EXCEPTION
6244: WHEN VALUE_ERROR THEN
6245: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6246: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_VALUE_ERROR');
6247: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6248: p_region_code||' '||to_char(p_attribute_application_id)||' '||
6249: p_attribute_code||' '|| p_category_name ||' '||

Line 6251: FND_MSG_PUB.Add;

6247: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6248: p_region_code||' '||to_char(p_attribute_application_id)||' '||
6249: p_attribute_code||' '|| p_category_name ||' '||
6250: to_char(p_application_id));
6251: FND_MSG_PUB.Add;
6252: end if;
6253: p_return_status := FND_API.G_RET_STS_ERROR;
6254: rollback to start_update_category_usage;
6255: FND_MSG_PUB.Count_And_Get (

Line 6255: FND_MSG_PUB.Count_And_Get (

6251: FND_MSG_PUB.Add;
6252: end if;
6253: p_return_status := FND_API.G_RET_STS_ERROR;
6254: rollback to start_update_category_usage;
6255: FND_MSG_PUB.Count_And_Get (
6256: p_count => p_msg_count,
6257: p_data => p_msg_data);
6258: WHEN OTHERS THEN
6259: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6261: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

6257: p_data => p_msg_data);
6258: WHEN OTHERS THEN
6259: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6260: rollback to start_update_category_usage;
6261: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6262: SUBSTR (SQLERRM, 1, 240) );
6263: FND_MSG_PUB.Add;
6264: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6265: 'PK = '||to_char(p_region_application_id) ||' '||

Line 6263: FND_MSG_PUB.Add;

6259: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6260: rollback to start_update_category_usage;
6261: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6262: SUBSTR (SQLERRM, 1, 240) );
6263: FND_MSG_PUB.Add;
6264: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6265: 'PK = '||to_char(p_region_application_id) ||' '||
6266: p_region_code||' '||to_char(p_attribute_application_id)||' '||
6267: p_attribute_code||' '|| p_category_name ||' '||

Line 6264: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

6260: rollback to start_update_category_usage;
6261: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6262: SUBSTR (SQLERRM, 1, 240) );
6263: FND_MSG_PUB.Add;
6264: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6265: 'PK = '||to_char(p_region_application_id) ||' '||
6266: p_region_code||' '||to_char(p_attribute_application_id)||' '||
6267: p_attribute_code||' '|| p_category_name ||' '||
6268: to_char(p_application_id) );

Line 6269: FND_MSG_PUB.Add;

6265: 'PK = '||to_char(p_region_application_id) ||' '||
6266: p_region_code||' '||to_char(p_attribute_application_id)||' '||
6267: p_attribute_code||' '|| p_category_name ||' '||
6268: to_char(p_application_id) );
6269: FND_MSG_PUB.Add;
6270: FND_MSG_PUB.Count_And_Get (
6271: p_count => p_msg_count,
6272: p_data => p_msg_data);
6273: FND_MSG_PUB.Count_And_Get (

Line 6270: FND_MSG_PUB.Count_And_Get (

6266: p_region_code||' '||to_char(p_attribute_application_id)||' '||
6267: p_attribute_code||' '|| p_category_name ||' '||
6268: to_char(p_application_id) );
6269: FND_MSG_PUB.Add;
6270: FND_MSG_PUB.Count_And_Get (
6271: p_count => p_msg_count,
6272: p_data => p_msg_data);
6273: FND_MSG_PUB.Count_And_Get (
6274: p_count => p_msg_count,

Line 6273: FND_MSG_PUB.Count_And_Get (

6269: FND_MSG_PUB.Add;
6270: FND_MSG_PUB.Count_And_Get (
6271: p_count => p_msg_count,
6272: p_data => p_msg_data);
6273: FND_MSG_PUB.Count_And_Get (
6274: p_count => p_msg_count,
6275: p_data => p_msg_data);
6276:
6277: end UPDATE_CATEGORY_USAGE;