eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_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 3646: FND_MSG_PUB.Count_And_Get (

3642:
3643: EXCEPTION
3644: WHEN FND_API.G_EXC_ERROR THEN
3645: p_return_status := FND_API.G_RET_STS_ERROR;
3646: FND_MSG_PUB.Count_And_Get (
3647: p_count => l_msg_count,
3648: p_data => l_msg_data);
3649: G_REGION_REDO_INDEX := 0;
3650: G_ITEM_REDO_INDEX := 0;

Line 3657: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

3653: G_ITEM_REDO_TBL.DELETE;
3654: G_LOV_RELATION_REDO_TBL.DELETE;
3655: WHEN OTHERS THEN
3656: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3657: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3658: SUBSTR (SQLERRM, 1, 240) );
3659: FND_MSG_PUB.Count_And_Get (
3660: p_count => l_msg_count,
3661: p_data => l_msg_data);

Line 3659: FND_MSG_PUB.Count_And_Get (

3655: WHEN OTHERS THEN
3656: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3657: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3658: SUBSTR (SQLERRM, 1, 240) );
3659: FND_MSG_PUB.Count_And_Get (
3660: p_count => l_msg_count,
3661: p_data => l_msg_data);
3662: G_REGION_REDO_INDEX := 0;
3663: G_ITEM_REDO_INDEX := 0;

Line 3887: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

3883: WHEN FND_API.G_EXC_ERROR THEN
3884: p_return_status := FND_API.G_RET_STS_ERROR;
3885: WHEN OTHERS THEN
3886: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3887: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3888: SUBSTR (SQLERRM, 1, 240) );
3889: FND_MSG_PUB.Add;
3890:
3891: end CHECK_DISPLAY_SEQUENCE;

Line 3889: FND_MSG_PUB.Add;

3885: WHEN OTHERS THEN
3886: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3887: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3888: SUBSTR (SQLERRM, 1, 240) );
3889: FND_MSG_PUB.Add;
3890:
3891: end CHECK_DISPLAY_SEQUENCE;
3892:
3893: /*

Line 3964: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

3960: p_return_status := FND_API.G_RET_STS_ERROR;
3961: return FALSE;
3962: WHEN OTHERS THEN
3963: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3964: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3965: SUBSTR (SQLERRM, 1, 240) );
3966: FND_MSG_PUB.Add;
3967: return FALSE;
3968: end GRAPH_COLUMN_EXISTS;

Line 3966: FND_MSG_PUB.Add;

3962: WHEN OTHERS THEN
3963: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3964: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3965: SUBSTR (SQLERRM, 1, 240) );
3966: FND_MSG_PUB.Add;
3967: return FALSE;
3968: end GRAPH_COLUMN_EXISTS;
3969: */
3970:

Line 4057: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

4053: p_return_status := FND_API.G_RET_STS_ERROR;
4054: return FALSE;
4055: WHEN OTHERS THEN
4056: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4057: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4058: SUBSTR (SQLERRM, 1, 240) );
4059: FND_MSG_PUB.Add;
4060: return FALSE;
4061: end LOV_RELATION_EXISTS;

Line 4059: FND_MSG_PUB.Add;

4055: WHEN OTHERS THEN
4056: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4057: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4058: SUBSTR (SQLERRM, 1, 240) );
4059: FND_MSG_PUB.Add;
4060: return FALSE;
4061: end LOV_RELATION_EXISTS;
4062:
4063: /*

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

4147: --** check that key columns are not null and not missing **
4148: if ((p_region_application_id is null) or
4149: (p_region_application_id = FND_API.G_MISS_NUM)) then
4150: l_error := TRUE;
4151: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4152: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4153: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4154: FND_MSG_PUB.Add;
4155: end if;

Line 4154: FND_MSG_PUB.Add;

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

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

4157:
4158: if ((p_region_code is null) or
4159: (p_region_code = FND_API.G_MISS_CHAR)) then
4160: l_error := TRUE;
4161: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4162: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4163: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4164: FND_MSG_PUB.Add;
4165: end if;

Line 4164: FND_MSG_PUB.Add;

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

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

4167:
4168: if ((p_attribute_application_id is null) or
4169: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
4170: l_error := TRUE;
4171: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4172: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4173: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4174: FND_MSG_PUB.Add;
4175: end if;

Line 4174: FND_MSG_PUB.Add;

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

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

4177:
4178: if ((p_attribute_code is null) or
4179: (p_attribute_code = FND_API.G_MISS_CHAR)) then
4180: l_error := TRUE;
4181: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4182: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4183: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4184: FND_MSG_PUB.Add;
4185: end if;

Line 4184: FND_MSG_PUB.Add;

4180: l_error := TRUE;
4181: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4182: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4183: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4184: FND_MSG_PUB.Add;
4185: end if;
4186: end if;
4187:
4188: if ((p_graph_number is null) or

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

4187:
4188: if ((p_graph_number is null) or
4189: (p_graph_number = FND_API.G_MISS_NUM)) then
4190: l_error := TRUE;
4191: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4192: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4193: FND_MESSAGE.SET_TOKEN('COLUMN', 'GRAPH_NUMBER');
4194: FND_MSG_PUB.Add;
4195: end if;

Line 4194: FND_MSG_PUB.Add;

4190: l_error := TRUE;
4191: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4192: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4193: FND_MESSAGE.SET_TOKEN('COLUMN', 'GRAPH_NUMBER');
4194: FND_MSG_PUB.Add;
4195: end if;
4196: end if;
4197:
4198: -- - Check that the parent region item exists

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

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

Line 4209: FND_MSG_PUB.Add;

4205: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4206: ' ' || p_region_code ||' '||
4207: to_char(p_attribute_application_id) || ' '||
4208: p_attribute_code);
4209: FND_MSG_PUB.Add;
4210: end if;
4211: end if;
4212: close l_check_region_item_csr;
4213:

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

4215: open l_check_region_graph_csr(p_region_code, p_region_application_id, p_graph_number);
4216: fetch l_check_Region_graph_csr into l_dummy;
4217: if (l_check_region_graph_csr%notfound) then
4218: l_error := TRUE;
4219: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4220: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_GRAPH_REFERENCE');
4221: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4222: ' ' || p_region_code ||' '||
4223: p_graph_number);

Line 4224: FND_MSG_PUB.Add;

4220: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_GRAPH_REFERENCE');
4221: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4222: ' ' || p_region_code ||' '||
4223: p_graph_number);
4224: FND_MSG_PUB.Add;
4225: end if;
4226: end if;
4227: close l_check_region_graph_csr;
4228:

Line 4239: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

4235: p_return_status := FND_API.G_RET_STS_ERROR;
4236: return FALSE;
4237: WHEN OTHERS THEN
4238: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4239: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4240: SUBSTR (SQLERRM, 1, 240) );
4241: FND_MSG_PUB.Add;
4242: return FALSE;
4243:

Line 4241: FND_MSG_PUB.Add;

4237: WHEN OTHERS THEN
4238: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4239: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4240: SUBSTR (SQLERRM, 1, 240) );
4241: FND_MSG_PUB.Add;
4242: return FALSE;
4243:
4244: end VALIDATE_GRAPH_COLUMN;
4245: */

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

4334: --** check that key columns are not null and not missing **
4335: if ((p_region_application_id is null) or
4336: (p_region_application_id = FND_API.G_MISS_NUM)) then
4337: l_error := TRUE;
4338: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4339: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4340: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4341: FND_MSG_PUB.Add;
4342: end if;

Line 4341: FND_MSG_PUB.Add;

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

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

4344:
4345: if ((p_region_code is null) or
4346: (p_region_code = FND_API.G_MISS_CHAR)) then
4347: l_error := TRUE;
4348: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4349: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4350: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4351: FND_MSG_PUB.Add;
4352: end if;

Line 4351: FND_MSG_PUB.Add;

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

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

4354:
4355: if ((p_attribute_application_id is null) or
4356: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
4357: l_error := TRUE;
4358: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4359: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4360: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4361: FND_MSG_PUB.Add;
4362: end if;

Line 4361: FND_MSG_PUB.Add;

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

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

4364:
4365: if ((p_attribute_code is null) or
4366: (p_attribute_code = FND_API.G_MISS_CHAR)) then
4367: l_error := TRUE;
4368: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4369: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4370: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4371: FND_MSG_PUB.Add;
4372: end if;

Line 4371: FND_MSG_PUB.Add;

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

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

4374:
4375: if ((p_lov_region_appl_id is null) or
4376: (p_lov_region_appl_id = FND_API.G_MISS_NUM)) then
4377: l_error := TRUE;
4378: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4379: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4380: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
4381: FND_MSG_PUB.Add;
4382: end if;

Line 4381: FND_MSG_PUB.Add;

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

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

4384:
4385: if ((p_lov_region_code is null) or
4386: (p_lov_region_code = FND_API.G_MISS_CHAR)) then
4387: l_error := TRUE;
4388: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4389: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4390: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
4391: FND_MSG_PUB.Add;
4392: end if;

Line 4391: FND_MSG_PUB.Add;

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

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

4394:
4395: if ((p_lov_attribute_appl_id is null) or
4396: (p_lov_attribute_appl_id = FND_API.G_MISS_NUM)) then
4397: l_error := TRUE;
4398: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4399: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4400: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4401: FND_MSG_PUB.Add;
4402: end if;

Line 4401: FND_MSG_PUB.Add;

4397: l_error := TRUE;
4398: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4399: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4400: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4401: FND_MSG_PUB.Add;
4402: end if;
4403: end if;
4404:
4405: if ((p_lov_attribute_code is null) or

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

4404:
4405: if ((p_lov_attribute_code is null) or
4406: (p_lov_attribute_code = FND_API.G_MISS_CHAR)) then
4407: l_error := TRUE;
4408: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4409: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4410: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4411: FND_MSG_PUB.Add;
4412: end if;

Line 4411: FND_MSG_PUB.Add;

4407: l_error := TRUE;
4408: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4409: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4410: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4411: FND_MSG_PUB.Add;
4412: end if;
4413: end if;
4414:
4415: -- do not raise an error for now, there are ppl who has an old jlt file and upload

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

4418: if ((p_base_region_appl_id is null) or
4419: (p_base_region_appl_id = FND_API.G_MISS_NUM)) then
4420:
4421: l_error := TRUE;
4422: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4423: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4424: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_REGION_APPL_ID');
4425: FND_MSG_PUB.Add;
4426: end if;

Line 4425: FND_MSG_PUB.Add;

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

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

4432: /**
4433: if ((p_base_region_code is null) or
4434: (p_base_region_code = FND_API.G_MISS_CHAR)) then
4435: l_error := TRUE;
4436: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4437: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4438: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_REGION_CODE');
4439: FND_MSG_PUB.Add;
4440: end if;

Line 4439: FND_MSG_PUB.Add;

4435: l_error := TRUE;
4436: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4437: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4438: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_REGION_CODE');
4439: FND_MSG_PUB.Add;
4440: end if;
4441: end if;
4442: **/
4443:

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

4445: --
4446: if ((p_base_attribute_appl_id is null) or
4447: (p_base_attribute_appl_id = FND_API.G_MISS_NUM)) then
4448: l_error := TRUE;
4449: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4450: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4451: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_ATTRIBUTE_APPL_ID');
4452: FND_MSG_PUB.Add;
4453: end if;

Line 4452: FND_MSG_PUB.Add;

4448: l_error := TRUE;
4449: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4450: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4451: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_ATTRIBUTE_APPL_ID');
4452: FND_MSG_PUB.Add;
4453: end if;
4454: end if;
4455:
4456: if ((p_base_attribute_code is null) or

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

4455:
4456: if ((p_base_attribute_code is null) or
4457: (p_base_attribute_code = FND_API.G_MISS_CHAR)) then
4458: l_error := TRUE;
4459: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4460: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4461: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_ATTRIBUTE_CODE');
4462: FND_MSG_PUB.Add;
4463: end if;

Line 4462: FND_MSG_PUB.Add;

4458: l_error := TRUE;
4459: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4460: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4461: FND_MESSAGE.SET_TOKEN('COLUMN', 'BASE_ATTRIBUTE_CODE');
4462: FND_MSG_PUB.Add;
4463: end if;
4464: end if;
4465:
4466: -- - Check that the parent region item exists

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

4468: p_attribute_code, p_attribute_application_id);
4469: fetch l_check_region_item_csr into l_dummy;
4470: if (l_check_region_item_csr%notfound) then
4471: l_error := TRUE;
4472: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4473: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
4474: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4475: ' ' || p_region_code ||' '||
4476: to_char(p_attribute_application_id)||' '||p_attribute_code);

Line 4477: FND_MSG_PUB.Add;

4473: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
4474: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4475: ' ' || p_region_code ||' '||
4476: to_char(p_attribute_application_id)||' '||p_attribute_code);
4477: FND_MSG_PUB.Add;
4478: end if;
4479: end if;
4480: close l_check_region_item_csr;
4481:

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

4483: open l_check_region_csr(p_lov_region_code, p_lov_region_appl_id);
4484: fetch l_check_region_csr into l_dummy;
4485: if (l_check_region_csr%notfound) then
4486: l_error := TRUE;
4487: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4488: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_REG_REFERENCE');
4489: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4490: ' ' || p_lov_region_code );
4491: FND_MSG_PUB.Add;

Line 4491: FND_MSG_PUB.Add;

4487: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4488: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_REG_REFERENCE');
4489: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4490: ' ' || p_lov_region_code );
4491: FND_MSG_PUB.Add;
4492: end if;
4493: end if;
4494: close l_check_region_csr;
4495:

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

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

Line 4507: FND_MSG_PUB.Add;

4503: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_ITEM_REFERENCE');
4504: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4505: ' ' || p_lov_region_code ||' '||
4506: to_char(p_lov_attribute_appl_id)||' '||p_lov_attribute_code);
4507: FND_MSG_PUB.Add;
4508: end if;
4509: end if;
4510: close l_check_region_item_csr;
4511:

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

4514: p_base_attribute_code, p_base_attribute_appl_id);
4515: fetch l_check_region_item_csr into l_dummy;
4516: if (l_check_region_item_csr%notfound) then
4517: l_error := TRUE;
4518: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4519: FND_MESSAGE.SET_NAME('AK','AK_INVALID_BASE_ITEM_REF');
4520: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4521: ' ' || p_lov_region_code ||' '||
4522: to_char(p_base_attribute_appl_id)||' '||p_base_attribute_code);

Line 4523: FND_MSG_PUB.Add;

4519: FND_MESSAGE.SET_NAME('AK','AK_INVALID_BASE_ITEM_REF');
4520: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_appl_id) ||
4521: ' ' || p_lov_region_code ||' '||
4522: to_char(p_base_attribute_appl_id)||' '||p_base_attribute_code);
4523: FND_MSG_PUB.Add;
4524: end if;
4525: end if;
4526: close l_check_region_item_csr;
4527:

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

4533: p_return_status => l_return_status,
4534: p_lookup_type => 'LOV_DIRECTION',
4535: p_lookup_code => p_direction_flag)) then
4536: l_error := TRUE;
4537: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4538: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
4539: FND_MESSAGE.SET_TOKEN('COLUMN','DIRECTION_FLAG');
4540: FND_MSG_PUB.Add;
4541: end if;

Line 4540: FND_MSG_PUB.Add;

4536: l_error := TRUE;
4537: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4538: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
4539: FND_MESSAGE.SET_TOKEN('COLUMN','DIRECTION_FLAG');
4540: FND_MSG_PUB.Add;
4541: end if;
4542: end if;
4543: else
4544: l_error := TRUE;

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

4541: end if;
4542: end if;
4543: else
4544: l_error := TRUE;
4545: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4546: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4547: FND_MESSAGE.SET_TOKEN('COLUMN', 'DIRECTION_FLAG');
4548: FND_MSG_PUB.Add;
4549: end if;

Line 4548: FND_MSG_PUB.Add;

4544: l_error := TRUE;
4545: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4546: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4547: FND_MESSAGE.SET_TOKEN('COLUMN', 'DIRECTION_FLAG');
4548: FND_MSG_PUB.Add;
4549: end if;
4550: end if;
4551:
4552: -- return true if no error, false otherwise

Line 4562: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

4558: p_return_status := FND_API.G_RET_STS_ERROR;
4559: return FALSE;
4560: WHEN OTHERS THEN
4561: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4562: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4563: SUBSTR (SQLERRM, 1, 240) );
4564: FND_MSG_PUB.Add;
4565: return FALSE;
4566:

Line 4564: FND_MSG_PUB.Add;

4560: WHEN OTHERS THEN
4561: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4562: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4563: SUBSTR (SQLERRM, 1, 240) );
4564: FND_MSG_PUB.Add;
4565: return FALSE;
4566:
4567: end VALIDATE_LOV_RELATION;
4568:

Line 4637: FND_MSG_PUB.initialize;

4633:
4634: -- Initialize the message table if requested.
4635:
4636: if p_init_msg_tbl then
4637: FND_MSG_PUB.initialize;
4638: end if;
4639:
4640: savepoint start_create_graph_column;
4641:

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

4647: p_region_code => p_region_code,
4648: p_attribute_application_id => p_attribute_application_id,
4649: p_attribute_code => p_attribute_code,
4650: p_graph_number => p_graph_number) then
4651: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4652: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_EXISTS');
4653: FND_MSG_PUB.Add;
4654: end if;
4655: raise FND_API.G_EXC_ERROR;

Line 4653: FND_MSG_PUB.Add;

4649: p_attribute_code => p_attribute_code,
4650: p_graph_number => p_graph_number) then
4651: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4652: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_EXISTS');
4653: FND_MSG_PUB.Add;
4654: end if;
4655: raise FND_API.G_EXC_ERROR;
4656: end if;
4657:

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

4723:
4724: -- ** commit the insert **
4725: -- commit;
4726:
4727: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4728: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_CREATED');
4729: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' ' ||
4730: p_region_code||' '||
4731: to_char(p_attribute_application_id)||

Line 4734: FND_MSG_PUB.Add;

4730: p_region_code||' '||
4731: to_char(p_attribute_application_id)||
4732: ' '||p_attribute_code||' '||
4733: to_char(p_graph_number));
4734: FND_MSG_PUB.Add;
4735: end if;
4736:
4737: p_return_status := FND_API.G_RET_STS_SUCCESS;
4738:

Line 4739: FND_MSG_PUB.Count_And_Get (

4735: end if;
4736:
4737: p_return_status := FND_API.G_RET_STS_SUCCESS;
4738:
4739: FND_MSG_PUB.Count_And_Get (
4740: p_count => p_msg_count,
4741: p_data => p_msg_data);
4742:
4743: EXCEPTION

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

4741: p_data => p_msg_data);
4742:
4743: EXCEPTION
4744: WHEN VALUE_ERROR THEN
4745: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4746: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_VALUE_ERROR');
4747: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
4748: p_region_code||' '||
4749: to_char(p_attribute_application_id)||

Line 4752: FND_MSG_PUB.Add;

4748: p_region_code||' '||
4749: to_char(p_attribute_application_id)||
4750: ' '||p_attribute_code||' '||
4751: to_char(p_graph_number));
4752: FND_MSG_PUB.Add;
4753: end if;
4754: p_return_status := FND_API.G_RET_STS_ERROR;
4755: rollback to start_create_graph_column;
4756: FND_MSG_PUB.Count_And_Get (

Line 4756: FND_MSG_PUB.Count_And_Get (

4752: FND_MSG_PUB.Add;
4753: end if;
4754: p_return_status := FND_API.G_RET_STS_ERROR;
4755: rollback to start_create_graph_column;
4756: FND_MSG_PUB.Count_And_Get (
4757: p_count => p_msg_count,
4758: p_data => p_msg_data);
4759: WHEN OTHERS THEN
4760: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4762: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

4758: p_data => p_msg_data);
4759: WHEN OTHERS THEN
4760: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4761: rollback to start_create_graph_column;
4762: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4763: SUBSTR (SQLERRM, 1, 240) );
4764: FND_MSG_PUB.Add;
4765: FND_MSG_PUB.Count_And_Get (
4766: p_count => p_msg_count,

Line 4764: FND_MSG_PUB.Add;

4760: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4761: rollback to start_create_graph_column;
4762: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4763: SUBSTR (SQLERRM, 1, 240) );
4764: FND_MSG_PUB.Add;
4765: FND_MSG_PUB.Count_And_Get (
4766: p_count => p_msg_count,
4767: p_data => p_msg_data);
4768:

Line 4765: FND_MSG_PUB.Count_And_Get (

4761: rollback to start_create_graph_column;
4762: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4763: SUBSTR (SQLERRM, 1, 240) );
4764: FND_MSG_PUB.Add;
4765: FND_MSG_PUB.Count_And_Get (
4766: p_count => p_msg_count,
4767: p_data => p_msg_data);
4768:
4769: end CREATE_GRAPH_COLUMN;

Line 4850: FND_MSG_PUB.initialize;

4846:
4847: -- Initialize the message table if requested.
4848:
4849: if p_init_msg_tbl then
4850: FND_MSG_PUB.initialize;
4851: end if;
4852:
4853: savepoint start_create_lov_relation;
4854:

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

4868: p_base_attribute_code => p_base_attribute_code,
4869: p_direction_flag => p_direction_flag,
4870: p_base_region_appl_id => p_base_region_appl_id,
4871: p_base_region_code => p_base_region_code) then
4872: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4873: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_EXISTS');
4874: FND_MSG_PUB.Add;
4875: end if;
4876: raise FND_API.G_EXC_ERROR;

Line 4874: FND_MSG_PUB.Add;

4870: p_base_region_appl_id => p_base_region_appl_id,
4871: p_base_region_code => p_base_region_code) then
4872: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4873: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_EXISTS');
4874: FND_MSG_PUB.Add;
4875: end if;
4876: raise FND_API.G_EXC_ERROR;
4877: end if;
4878:

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

4999:
5000: -- /** commit the insert **/
5001: -- commit;
5002:
5003: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5004: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_CREATED');
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:
5015: end if; -- /* if not p_copy_redo_flag */
5016:

Line 5019: FND_MSG_PUB.Count_And_Get (

5015: end if; -- /* if not p_copy_redo_flag */
5016:
5017: p_return_status := FND_API.G_RET_STS_SUCCESS;
5018:
5019: FND_MSG_PUB.Count_And_Get (
5020: p_count => p_msg_count,
5021: p_data => p_msg_data);
5022:
5023: EXCEPTION

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

5021: p_data => p_msg_data);
5022:
5023: EXCEPTION
5024: WHEN VALUE_ERROR THEN
5025: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5026: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
5027: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5028: p_region_code||' '||to_char(p_attribute_application_id)||
5029: ' '||p_attribute_code||' '||

Line 5034: FND_MSG_PUB.Add;

5030: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||
5031: ' '||to_char(p_lov_attribute_appl_id)||' '||
5032: p_lov_region_code||' '||to_char(p_base_attribute_appl_id)||
5033: ' '||p_base_attribute_code);
5034: FND_MSG_PUB.Add;
5035: end if;
5036: p_return_status := FND_API.G_RET_STS_ERROR;
5037: rollback to start_create_lov_relation;
5038: FND_MSG_PUB.Count_And_Get (

Line 5038: FND_MSG_PUB.Count_And_Get (

5034: FND_MSG_PUB.Add;
5035: end if;
5036: p_return_status := FND_API.G_RET_STS_ERROR;
5037: rollback to start_create_lov_relation;
5038: FND_MSG_PUB.Count_And_Get (
5039: p_count => p_msg_count,
5040: p_data => p_msg_data);
5041: WHEN FND_API.G_EXC_ERROR THEN
5042: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

5038: FND_MSG_PUB.Count_And_Get (
5039: p_count => p_msg_count,
5040: p_data => p_msg_data);
5041: WHEN FND_API.G_EXC_ERROR THEN
5042: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5043: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_CREATED');
5044: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5045: p_region_code||' '||to_char(p_attribute_application_id)||
5046: ' '||p_attribute_code||' '||

Line 5051: FND_MSG_PUB.Add;

5047: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||
5048: ' '||to_char(p_lov_attribute_appl_id)||' '||
5049: p_lov_region_code||' '||to_char(p_base_attribute_appl_id)||
5050: ' '||p_base_attribute_code);
5051: FND_MSG_PUB.Add;
5052: end if;
5053: p_return_status := FND_API.G_RET_STS_ERROR;
5054: rollback to start_create_lov_relation;
5055: FND_MSG_PUB.Count_And_Get (

Line 5055: FND_MSG_PUB.Count_And_Get (

5051: FND_MSG_PUB.Add;
5052: end if;
5053: p_return_status := FND_API.G_RET_STS_ERROR;
5054: rollback to start_create_lov_relation;
5055: FND_MSG_PUB.Count_And_Get (
5056: p_count => p_msg_count,
5057: p_data => p_msg_data);
5058: WHEN OTHERS THEN
5059: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5061: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5057: p_data => p_msg_data);
5058: WHEN OTHERS THEN
5059: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5060: rollback to start_create_region;
5061: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5062: SUBSTR (SQLERRM, 1, 240) );
5063: FND_MSG_PUB.Add;
5064: FND_MSG_PUB.Count_And_Get (
5065: p_count => p_msg_count,

Line 5063: FND_MSG_PUB.Add;

5059: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5060: rollback to start_create_region;
5061: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5062: SUBSTR (SQLERRM, 1, 240) );
5063: FND_MSG_PUB.Add;
5064: FND_MSG_PUB.Count_And_Get (
5065: p_count => p_msg_count,
5066: p_data => p_msg_data);
5067:

Line 5064: FND_MSG_PUB.Count_And_Get (

5060: rollback to start_create_region;
5061: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5062: SUBSTR (SQLERRM, 1, 240) );
5063: FND_MSG_PUB.Add;
5064: FND_MSG_PUB.Count_And_Get (
5065: p_count => p_msg_count,
5066: p_data => p_msg_data);
5067:
5068: end CREATE_LOV_RELATION;

Line 5144: FND_MSG_PUB.initialize;

5140:
5141: -- Initialize the message table if requested.
5142:
5143: if p_init_msg_tbl then
5144: FND_MSG_PUB.initialize;
5145: end if;
5146:
5147: savepoint start_update_graph_columns;
5148:

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

5149: --** retrieve ak_region_graph_columns row if it exists **
5150: open l_get_row_csr;
5151: fetch l_get_row_csr into l_graph_column_rec;
5152: if (l_get_row_csr%notfound) then
5153: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5154: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_DOES_NOT_EXIST');
5155: FND_MSG_PUB.Add;
5156: end if;
5157: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');

Line 5155: FND_MSG_PUB.Add;

5151: fetch l_get_row_csr into l_graph_column_rec;
5152: if (l_get_row_csr%notfound) then
5153: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5154: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_DOES_NOT_EXIST');
5155: FND_MSG_PUB.Add;
5156: end if;
5157: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
5158: close l_get_row_csr;
5159: raise FND_API.G_EXC_ERROR;

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

5216: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
5217: and ATTRIBUTE_CODE = p_attribute_code
5218: and GRAPH_NUMBER = p_graph_number;
5219: if (sql%notfound) then
5220: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5221: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_UPDATE_FAILED');
5222: FND_MSG_PUB.Add;
5223: end if;
5224: raise FND_API.G_EXC_ERROR;

Line 5222: FND_MSG_PUB.Add;

5218: and GRAPH_NUMBER = p_graph_number;
5219: if (sql%notfound) then
5220: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5221: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_UPDATE_FAILED');
5222: FND_MSG_PUB.Add;
5223: end if;
5224: raise FND_API.G_EXC_ERROR;
5225: end if;
5226:

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

5226:
5227: -- ** commit the update **
5228: -- commit;
5229:
5230: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5231: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_UPDATED');
5232: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5233: ' ' || p_region_code);
5234: FND_MSG_PUB.Add;

Line 5234: FND_MSG_PUB.Add;

5230: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5231: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_UPDATED');
5232: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5233: ' ' || p_region_code);
5234: FND_MSG_PUB.Add;
5235: end if;
5236:
5237: p_return_status := FND_API.G_RET_STS_SUCCESS;
5238:

Line 5239: FND_MSG_PUB.Count_And_Get (

5235: end if;
5236:
5237: p_return_status := FND_API.G_RET_STS_SUCCESS;
5238:
5239: FND_MSG_PUB.Count_And_Get (
5240: p_count => p_msg_count,
5241: p_data => p_msg_data);
5242:
5243: EXCEPTION

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

5241: p_data => p_msg_data);
5242:
5243: EXCEPTION
5244: WHEN VALUE_ERROR THEN
5245: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5246: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_VALUE_ERROR');
5247: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5248: p_region_code||' '||
5249: to_char(p_attribute_application_id)||

Line 5252: FND_MSG_PUB.Add;

5248: p_region_code||' '||
5249: to_char(p_attribute_application_id)||
5250: ' '||p_attribute_code||' '||
5251: to_char(p_graph_number));
5252: FND_MSG_PUB.Add;
5253: end if;
5254: rollback to start_update_graph_column;
5255: p_return_status := FND_API.G_RET_STS_ERROR;
5256: FND_MSG_PUB.Count_And_Get (

Line 5256: FND_MSG_PUB.Count_And_Get (

5252: FND_MSG_PUB.Add;
5253: end if;
5254: rollback to start_update_graph_column;
5255: p_return_status := FND_API.G_RET_STS_ERROR;
5256: FND_MSG_PUB.Count_And_Get (
5257: p_count => p_msg_count,
5258: p_data => p_msg_data);
5259: WHEN FND_API.G_EXC_ERROR THEN
5260: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

5256: FND_MSG_PUB.Count_And_Get (
5257: p_count => p_msg_count,
5258: p_data => p_msg_data);
5259: WHEN FND_API.G_EXC_ERROR THEN
5260: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5261: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_NOT_UPDATED');
5262: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5263: p_region_code||' '||
5264: to_char(p_attribute_application_id)||

Line 5267: FND_MSG_PUB.Add;

5263: p_region_code||' '||
5264: to_char(p_attribute_application_id)||
5265: ' '||p_attribute_code||' '||
5266: to_char(p_graph_number));
5267: FND_MSG_PUB.Add;
5268: end if;
5269: p_return_status := FND_API.G_RET_STS_ERROR;
5270: rollback to start_update_graph_column;
5271: FND_MSG_PUB.Count_And_Get (

Line 5271: FND_MSG_PUB.Count_And_Get (

5267: FND_MSG_PUB.Add;
5268: end if;
5269: p_return_status := FND_API.G_RET_STS_ERROR;
5270: rollback to start_update_graph_column;
5271: FND_MSG_PUB.Count_And_Get (
5272: p_count => p_msg_count,
5273: p_data => p_msg_data);
5274: WHEN OTHERS THEN
5275: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5277: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5273: p_data => p_msg_data);
5274: WHEN OTHERS THEN
5275: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5276: rollback to start_update_graph_column;
5277: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5278: SUBSTR (SQLERRM, 1, 240) );
5279: FND_MSG_PUB.Add;
5280: FND_MSG_PUB.Count_And_Get (
5281: p_count => p_msg_count,

Line 5279: FND_MSG_PUB.Add;

5275: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5276: rollback to start_update_graph_column;
5277: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5278: SUBSTR (SQLERRM, 1, 240) );
5279: FND_MSG_PUB.Add;
5280: FND_MSG_PUB.Count_And_Get (
5281: p_count => p_msg_count,
5282: p_data => p_msg_data);
5283: FND_MSG_PUB.Count_And_Get (

Line 5280: FND_MSG_PUB.Count_And_Get (

5276: rollback to start_update_graph_column;
5277: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5278: SUBSTR (SQLERRM, 1, 240) );
5279: FND_MSG_PUB.Add;
5280: FND_MSG_PUB.Count_And_Get (
5281: p_count => p_msg_count,
5282: p_data => p_msg_data);
5283: FND_MSG_PUB.Count_And_Get (
5284: p_count => p_msg_count,

Line 5283: FND_MSG_PUB.Count_And_Get (

5279: FND_MSG_PUB.Add;
5280: FND_MSG_PUB.Count_And_Get (
5281: p_count => p_msg_count,
5282: p_data => p_msg_data);
5283: FND_MSG_PUB.Count_And_Get (
5284: p_count => p_msg_count,
5285: p_data => p_msg_data);
5286:
5287: end UPDATE_GRAPH_COLUMN;

Line 5381: FND_MSG_PUB.initialize;

5377:
5378: -- Initialize the message table if requested.
5379:
5380: if p_init_msg_tbl then
5381: FND_MSG_PUB.initialize;
5382: end if;
5383:
5384: savepoint start_update_lov_relation;
5385:

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

5386: --** retrieve ak_region_lov_relations row if it exists **
5387: open l_get_row_csr;
5388: fetch l_get_row_csr into l_lov_relation_rec;
5389: if (l_get_row_csr%notfound) then
5390: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5391: FND_MESSAGE.SET_NAME('AK','AK_LOV_REGION_DOES_NOT_EXIST');
5392: FND_MSG_PUB.Add;
5393: end if;
5394: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');

Line 5392: FND_MSG_PUB.Add;

5388: fetch l_get_row_csr into l_lov_relation_rec;
5389: if (l_get_row_csr%notfound) then
5390: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5391: FND_MESSAGE.SET_NAME('AK','AK_LOV_REGION_DOES_NOT_EXIST');
5392: FND_MSG_PUB.Add;
5393: end if;
5394: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
5395: close l_get_row_csr;
5396: raise FND_API.G_EXC_ERROR;

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

5495: and DIRECTION_FLAG = p_direction_flag
5496: and BASE_REGION_APPL_ID = p_base_region_appl_id
5497: and BASE_REGION_CODE = p_base_region_code;
5498: if (sql%notfound) then
5499: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5500: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_UPDATE_FAILED');
5501: FND_MSG_PUB.Add;
5502: end if;
5503: raise FND_API.G_EXC_ERROR;

Line 5501: FND_MSG_PUB.Add;

5497: and BASE_REGION_CODE = p_base_region_code;
5498: if (sql%notfound) then
5499: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5500: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_UPDATE_FAILED');
5501: FND_MSG_PUB.Add;
5502: end if;
5503: raise FND_API.G_EXC_ERROR;
5504: end if;
5505:

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

5505:
5506: -- /** commit the update **/
5507: -- commit;
5508:
5509: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5510: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_UPDATED');
5511: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5512: ' ' || p_region_code);
5513: FND_MSG_PUB.Add;

Line 5513: FND_MSG_PUB.Add;

5509: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5510: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_UPDATED');
5511: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5512: ' ' || p_region_code);
5513: FND_MSG_PUB.Add;
5514: end if;
5515:
5516: end if;
5517:

Line 5522: FND_MSG_PUB.Count_And_Get (

5518: end if; -- /* if not p_copy_redo_flag */
5519:
5520: p_return_status := FND_API.G_RET_STS_SUCCESS;
5521:
5522: FND_MSG_PUB.Count_And_Get (
5523: p_count => p_msg_count,
5524: p_data => p_msg_data);
5525:
5526: EXCEPTION

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

5524: p_data => p_msg_data);
5525:
5526: EXCEPTION
5527: WHEN VALUE_ERROR THEN
5528: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5529: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_VALUE_ERROR');
5530: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5531: p_region_code||' '||to_char(p_attribute_application_id)||
5532: ' '||p_attribute_code||' '||

Line 5538: FND_MSG_PUB.Add;

5534: ' '||to_char(p_lov_attribute_appl_id)||' '||
5535: p_lov_region_code||' '||to_char(p_base_attribute_appl_id)||
5536: ' '||p_base_attribute_code||' '||p_direction_flag ||
5537: ' '||to_char(p_base_region_appl_id)||' '||p_base_region_code);
5538: FND_MSG_PUB.Add;
5539: end if;
5540: rollback to start_update_lov_relation;
5541: p_return_status := FND_API.G_RET_STS_ERROR;
5542: FND_MSG_PUB.Count_And_Get (

Line 5542: FND_MSG_PUB.Count_And_Get (

5538: FND_MSG_PUB.Add;
5539: end if;
5540: rollback to start_update_lov_relation;
5541: p_return_status := FND_API.G_RET_STS_ERROR;
5542: FND_MSG_PUB.Count_And_Get (
5543: p_count => p_msg_count,
5544: p_data => p_msg_data);
5545: WHEN FND_API.G_EXC_ERROR THEN
5546: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

5542: FND_MSG_PUB.Count_And_Get (
5543: p_count => p_msg_count,
5544: p_data => p_msg_data);
5545: WHEN FND_API.G_EXC_ERROR THEN
5546: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5547: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_NOT_UPDATED');
5548: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
5549: p_region_code||' '||to_char(p_attribute_application_id)||
5550: ' '||p_attribute_code||' '||

Line 5555: FND_MSG_PUB.Add;

5551: to_char(p_lov_region_appl_id)||' '||p_lov_region_code||
5552: ' '||to_char(p_lov_attribute_appl_id)||' '||
5553: p_lov_region_code||' '||to_char(p_base_attribute_appl_id)||
5554: ' '||p_base_attribute_code);
5555: FND_MSG_PUB.Add;
5556: end if;
5557: p_return_status := FND_API.G_RET_STS_ERROR;
5558: rollback to start_update_lov_relation;
5559: FND_MSG_PUB.Count_And_Get (

Line 5559: FND_MSG_PUB.Count_And_Get (

5555: FND_MSG_PUB.Add;
5556: end if;
5557: p_return_status := FND_API.G_RET_STS_ERROR;
5558: rollback to start_update_lov_relation;
5559: FND_MSG_PUB.Count_And_Get (
5560: p_count => p_msg_count,
5561: p_data => p_msg_data);
5562: WHEN OTHERS THEN
5563: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5565: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5561: p_data => p_msg_data);
5562: WHEN OTHERS THEN
5563: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5564: rollback to start_update_lov_relation;
5565: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5566: SUBSTR (SQLERRM, 1, 240) );
5567: FND_MSG_PUB.Add;
5568: FND_MSG_PUB.Count_And_Get (
5569: p_count => p_msg_count,

Line 5567: FND_MSG_PUB.Add;

5563: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5564: rollback to start_update_lov_relation;
5565: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5566: SUBSTR (SQLERRM, 1, 240) );
5567: FND_MSG_PUB.Add;
5568: FND_MSG_PUB.Count_And_Get (
5569: p_count => p_msg_count,
5570: p_data => p_msg_data);
5571: FND_MSG_PUB.Count_And_Get (

Line 5568: FND_MSG_PUB.Count_And_Get (

5564: rollback to start_update_lov_relation;
5565: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5566: SUBSTR (SQLERRM, 1, 240) );
5567: FND_MSG_PUB.Add;
5568: FND_MSG_PUB.Count_And_Get (
5569: p_count => p_msg_count,
5570: p_data => p_msg_data);
5571: FND_MSG_PUB.Count_And_Get (
5572: p_count => p_msg_count,

Line 5571: FND_MSG_PUB.Count_And_Get (

5567: FND_MSG_PUB.Add;
5568: FND_MSG_PUB.Count_And_Get (
5569: p_count => p_msg_count,
5570: p_data => p_msg_data);
5571: FND_MSG_PUB.Count_And_Get (
5572: p_count => p_msg_count,
5573: p_data => p_msg_data);
5574:
5575: end UPDATE_LOV_RELATION;

Line 5646: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5642: p_return_status := FND_API.G_RET_STS_ERROR;
5643: return FALSE;
5644: WHEN OTHERS THEN
5645: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5646: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5647: SUBSTR (SQLERRM, 1, 240) );
5648: FND_MSG_PUB.Add;
5649: return FALSE;
5650: end CATEGORY_USAGE_EXISTS;

Line 5648: FND_MSG_PUB.Add;

5644: WHEN OTHERS THEN
5645: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5646: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5647: SUBSTR (SQLERRM, 1, 240) );
5648: FND_MSG_PUB.Add;
5649: return FALSE;
5650: end CATEGORY_USAGE_EXISTS;
5651:
5652: --=======================================================

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

5736: --** check that key columns are not null and not missing **
5737: if ((p_region_application_id is null) or
5738: (p_region_application_id = FND_API.G_MISS_NUM)) then
5739: l_error := TRUE;
5740: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5741: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5742: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
5743: FND_MSG_PUB.Add;
5744: end if;

Line 5743: FND_MSG_PUB.Add;

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

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

5746:
5747: if ((p_region_code is null) or
5748: (p_region_code = FND_API.G_MISS_CHAR)) then
5749: l_error := TRUE;
5750: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5751: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5752: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
5753: FND_MSG_PUB.Add;
5754: end if;

Line 5753: FND_MSG_PUB.Add;

5749: l_error := TRUE;
5750: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5751: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5752: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
5753: FND_MSG_PUB.Add;
5754: end if;
5755: end if;
5756:
5757: if ((p_attribute_application_id is null) or

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

5756:
5757: if ((p_attribute_application_id is null) or
5758: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
5759: l_error := TRUE;
5760: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5761: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5762: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
5763: FND_MSG_PUB.Add;
5764: end if;

Line 5763: FND_MSG_PUB.Add;

5759: l_error := TRUE;
5760: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5761: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5762: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
5763: FND_MSG_PUB.Add;
5764: end if;
5765: end if;
5766:
5767: if ((p_attribute_code is null) or

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

5766:
5767: if ((p_attribute_code is null) or
5768: (p_attribute_code = FND_API.G_MISS_CHAR)) then
5769: l_error := TRUE;
5770: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5771: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5772: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
5773: FND_MSG_PUB.Add;
5774: end if;

Line 5773: FND_MSG_PUB.Add;

5769: l_error := TRUE;
5770: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5771: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
5772: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
5773: FND_MSG_PUB.Add;
5774: end if;
5775: end if;
5776:
5777: -- - Check that the parent region item exists

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

5779: p_attribute_code, p_attribute_application_id);
5780: fetch l_check_region_item_csr into l_item_style;
5781: if (l_check_region_item_csr%notfound) then
5782: l_error := TRUE;
5783: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5784: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
5785: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5786: ' ' || p_region_code ||' '||
5787: to_char(p_attribute_application_id)||' '||p_attribute_code);

Line 5788: FND_MSG_PUB.Add;

5784: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
5785: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5786: ' ' || p_region_code ||' '||
5787: to_char(p_attribute_application_id)||' '||p_attribute_code);
5788: FND_MSG_PUB.Add;
5789: end if;
5790: else
5791: if ( l_item_style <> 'ATTACHMENT_LINK' AND l_item_style <> 'ATTACHMENT_IMAGE' AND
5792: l_item_style <> 'ATTACHMENT_TABLE') then

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

5790: else
5791: if ( l_item_style <> 'ATTACHMENT_LINK' AND l_item_style <> 'ATTACHMENT_IMAGE' AND
5792: l_item_style <> 'ATTACHMENT_TABLE') then
5793: l_error := TRUE;
5794: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5795: FND_MESSAGE.SET_NAME('AK','AK_INVALID_ITEM_STYLE');
5796: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5797: ' ' || p_region_code ||' '||
5798: to_char(p_attribute_application_id)||' '||p_attribute_code||' '||l_item_style);

Line 5799: FND_MSG_PUB.Add;

5795: FND_MESSAGE.SET_NAME('AK','AK_INVALID_ITEM_STYLE');
5796: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5797: ' ' || p_region_code ||' '||
5798: to_char(p_attribute_application_id)||' '||p_attribute_code||' '||l_item_style);
5799: FND_MSG_PUB.Add;
5800: end if;
5801: end if; -- l_item_style <> 'ATTACHMENT%'
5802: end if;
5803: close l_check_region_item_csr;

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

5806: open l_check_category_csr(p_category_name);
5807: fetch l_check_category_csr into l_dummy;
5808: if (l_check_category_csr%notfound) then
5809: l_error := TRUE;
5810: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5811: FND_MESSAGE.SET_NAME('AK','AK_INVALID_CATEGORY_REFERENCE');
5812: FND_MESSAGE.SET_TOKEN('KEY', p_category_name);
5813: FND_MSG_PUB.Add;
5814: end if;

Line 5813: FND_MSG_PUB.Add;

5809: l_error := TRUE;
5810: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
5811: FND_MESSAGE.SET_NAME('AK','AK_INVALID_CATEGORY_REFERENCE');
5812: FND_MESSAGE.SET_TOKEN('KEY', p_category_name);
5813: FND_MSG_PUB.Add;
5814: end if;
5815: end if;
5816: close l_check_category_csr;
5817:

Line 5828: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5824: p_return_status := FND_API.G_RET_STS_ERROR;
5825: return FALSE;
5826: WHEN OTHERS THEN
5827: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5828: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5829: SUBSTR (SQLERRM, 1, 240) );
5830: FND_MSG_PUB.Add;
5831: return FALSE;
5832:

Line 5830: FND_MSG_PUB.Add;

5826: WHEN OTHERS THEN
5827: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5828: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5829: SUBSTR (SQLERRM, 1, 240) );
5830: FND_MSG_PUB.Add;
5831: return FALSE;
5832:
5833: end VALIDATE_CATEGORY_USAGE;
5834:

Line 5905: FND_MSG_PUB.initialize;

5901:
5902: -- Initialize the message table if requested.
5903:
5904: if p_init_msg_tbl then
5905: FND_MSG_PUB.initialize;
5906: end if;
5907:
5908: savepoint start_create_category_usage;
5909:

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

5915: p_region_code => p_region_code,
5916: p_attribute_application_id => p_attribute_application_id,
5917: p_attribute_code => p_attribute_code,
5918: p_category_name => p_category_name) then
5919: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5920: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_EXISTS');
5921: FND_MSG_PUB.Add;
5922: end if;
5923: raise FND_API.G_EXC_ERROR;

Line 5921: FND_MSG_PUB.Add;

5917: p_attribute_code => p_attribute_code,
5918: p_category_name => p_category_name) then
5919: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5920: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_EXISTS');
5921: FND_MSG_PUB.Add;
5922: end if;
5923: raise FND_API.G_EXC_ERROR;
5924: end if;
5925:

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

6023:
6024: -- /** commit the insert **/
6025: -- commit;
6026:
6027: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
6028: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_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:
6036: end if; -- /* if not p_copy_redo_flag */
6037:

Line 6040: FND_MSG_PUB.Count_And_Get (

6036: end if; -- /* if not p_copy_redo_flag */
6037:
6038: p_return_status := FND_API.G_RET_STS_SUCCESS;
6039:
6040: FND_MSG_PUB.Count_And_Get (
6041: p_count => p_msg_count,
6042: p_data => p_msg_data);
6043:
6044: EXCEPTION

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

6042: p_data => p_msg_data);
6043:
6044: EXCEPTION
6045: WHEN VALUE_ERROR THEN
6046: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6047: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_VALUE_ERROR');
6048: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6049: p_region_code||' '||to_char(p_attribute_application_id)||
6050: ' '||p_attribute_code||' '||

Line 6052: FND_MSG_PUB.Add;

6048: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6049: p_region_code||' '||to_char(p_attribute_application_id)||
6050: ' '||p_attribute_code||' '||
6051: p_category_name);
6052: FND_MSG_PUB.Add;
6053: end if;
6054: p_return_status := FND_API.G_RET_STS_ERROR;
6055: rollback to start_create_category_usage;
6056: FND_MSG_PUB.Count_And_Get (

Line 6056: FND_MSG_PUB.Count_And_Get (

6052: FND_MSG_PUB.Add;
6053: end if;
6054: p_return_status := FND_API.G_RET_STS_ERROR;
6055: rollback to start_create_category_usage;
6056: FND_MSG_PUB.Count_And_Get (
6057: p_count => p_msg_count,
6058: p_data => p_msg_data);
6059: WHEN FND_API.G_EXC_ERROR THEN
6060: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

6056: FND_MSG_PUB.Count_And_Get (
6057: p_count => p_msg_count,
6058: p_data => p_msg_data);
6059: WHEN FND_API.G_EXC_ERROR THEN
6060: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6061: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_NOT_CREATED');
6062: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6063: p_region_code||' '||to_char(p_attribute_application_id)||
6064: ' '||p_attribute_code||' '||

Line 6066: FND_MSG_PUB.Add;

6062: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6063: p_region_code||' '||to_char(p_attribute_application_id)||
6064: ' '||p_attribute_code||' '||
6065: p_category_name);
6066: FND_MSG_PUB.Add;
6067: end if;
6068: p_return_status := FND_API.G_RET_STS_ERROR;
6069: rollback to start_create_category_usage;
6070: FND_MSG_PUB.Count_And_Get (

Line 6070: FND_MSG_PUB.Count_And_Get (

6066: FND_MSG_PUB.Add;
6067: end if;
6068: p_return_status := FND_API.G_RET_STS_ERROR;
6069: rollback to start_create_category_usage;
6070: FND_MSG_PUB.Count_And_Get (
6071: p_count => p_msg_count,
6072: p_data => p_msg_data);
6073: WHEN OTHERS THEN
6074: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6076: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

6072: p_data => p_msg_data);
6073: WHEN OTHERS THEN
6074: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6075: rollback to start_create_category_usage;
6076: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6077: SUBSTR (SQLERRM, 1, 240) );
6078: FND_MSG_PUB.Add;
6079: FND_MSG_PUB.Count_And_Get (
6080: p_count => p_msg_count,

Line 6078: FND_MSG_PUB.Add;

6074: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6075: rollback to start_create_category_usage;
6076: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6077: SUBSTR (SQLERRM, 1, 240) );
6078: FND_MSG_PUB.Add;
6079: FND_MSG_PUB.Count_And_Get (
6080: p_count => p_msg_count,
6081: p_data => p_msg_data);
6082:

Line 6079: FND_MSG_PUB.Count_And_Get (

6075: rollback to start_create_category_usage;
6076: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6077: SUBSTR (SQLERRM, 1, 240) );
6078: FND_MSG_PUB.Add;
6079: FND_MSG_PUB.Count_And_Get (
6080: p_count => p_msg_count,
6081: p_data => p_msg_data);
6082:
6083: end CREATE_CATEGORY_USAGE;

Line 6160: FND_MSG_PUB.initialize;

6156:
6157: -- Initialize the message table if requested.
6158:
6159: if p_init_msg_tbl then
6160: FND_MSG_PUB.initialize;
6161: end if;
6162:
6163: savepoint start_update_category_usage;
6164:

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

6165: --** retrieve ak_category_usage row if it exists **
6166: open l_get_row_csr;
6167: fetch l_get_row_csr into l_category_usage_rec;
6168: if (l_get_row_csr%notfound) then
6169: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6170: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_DOES_NOT_EXIST');
6171: FND_MESSAGE.SET_TOKEN('KEY', (to_char(p_region_application_id) ||' '||
6172: p_region_code ||' '|| to_char(p_attribute_application_id)||' '||
6173: p_attribute_code ||' '|| p_category_name ||' '||

Line 6175: FND_MSG_PUB.Add;

6171: FND_MESSAGE.SET_TOKEN('KEY', (to_char(p_region_application_id) ||' '||
6172: p_region_code ||' '|| to_char(p_attribute_application_id)||' '||
6173: p_attribute_code ||' '|| p_category_name ||' '||
6174: to_char(p_application_id)));
6175: FND_MSG_PUB.Add;
6176: FND_MSG_PUB.Add;
6177: end if;
6178: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
6179: close l_get_row_csr;

Line 6176: FND_MSG_PUB.Add;

6172: p_region_code ||' '|| to_char(p_attribute_application_id)||' '||
6173: p_attribute_code ||' '|| p_category_name ||' '||
6174: to_char(p_application_id)));
6175: FND_MSG_PUB.Add;
6176: FND_MSG_PUB.Add;
6177: end if;
6178: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
6179: close l_get_row_csr;
6180: raise FND_API.G_EXC_ERROR;

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

6250: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
6251: and ATTRIBUTE_CODE = p_attribute_code
6252: and CATEGORY_NAME = p_category_name;
6253: if (sql%notfound) then
6254: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6255: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_UPDATE_FAILED');
6256: FND_MSG_PUB.Add;
6257: end if;
6258: raise FND_API.G_EXC_ERROR;

Line 6256: FND_MSG_PUB.Add;

6252: and CATEGORY_NAME = p_category_name;
6253: if (sql%notfound) then
6254: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6255: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_UPDATE_FAILED');
6256: FND_MSG_PUB.Add;
6257: end if;
6258: raise FND_API.G_EXC_ERROR;
6259: end if;
6260:

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

6260:
6261: -- /** commit the update **/
6262: -- commit;
6263:
6264: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
6265: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_UPDATED');
6266: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6267: ' ' || p_region_code);
6268: FND_MSG_PUB.Add;

Line 6268: FND_MSG_PUB.Add;

6264: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
6265: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_UPDATED');
6266: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6267: ' ' || p_region_code);
6268: FND_MSG_PUB.Add;
6269: end if;
6270:
6271: end if;
6272:

Line 6277: FND_MSG_PUB.Count_And_Get (

6273: end if; -- /* if not p_copy_redo_flag */
6274:
6275: p_return_status := FND_API.G_RET_STS_SUCCESS;
6276:
6277: FND_MSG_PUB.Count_And_Get (
6278: p_count => p_msg_count,
6279: p_data => p_msg_data);
6280:
6281: EXCEPTION

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

6279: p_data => p_msg_data);
6280:
6281: EXCEPTION
6282: WHEN VALUE_ERROR THEN
6283: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6284: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_VALUE_ERROR');
6285: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6286: p_region_code||' '||to_char(p_attribute_application_id)||' '||
6287: p_attribute_code||' '|| p_category_name ||' '||

Line 6289: FND_MSG_PUB.Add;

6285: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
6286: p_region_code||' '||to_char(p_attribute_application_id)||' '||
6287: p_attribute_code||' '|| p_category_name ||' '||
6288: to_char(p_application_id));
6289: FND_MSG_PUB.Add;
6290: end if;
6291: p_return_status := FND_API.G_RET_STS_ERROR;
6292: rollback to start_update_category_usage;
6293: FND_MSG_PUB.Count_And_Get (

Line 6293: FND_MSG_PUB.Count_And_Get (

6289: FND_MSG_PUB.Add;
6290: end if;
6291: p_return_status := FND_API.G_RET_STS_ERROR;
6292: rollback to start_update_category_usage;
6293: FND_MSG_PUB.Count_And_Get (
6294: p_count => p_msg_count,
6295: p_data => p_msg_data);
6296: WHEN OTHERS THEN
6297: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6299: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

6295: p_data => p_msg_data);
6296: WHEN OTHERS THEN
6297: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6298: rollback to start_update_category_usage;
6299: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6300: SUBSTR (SQLERRM, 1, 240) );
6301: FND_MSG_PUB.Add;
6302: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6303: 'PK = '||to_char(p_region_application_id) ||' '||

Line 6301: FND_MSG_PUB.Add;

6297: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6298: rollback to start_update_category_usage;
6299: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6300: SUBSTR (SQLERRM, 1, 240) );
6301: FND_MSG_PUB.Add;
6302: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6303: 'PK = '||to_char(p_region_application_id) ||' '||
6304: p_region_code||' '||to_char(p_attribute_application_id)||' '||
6305: p_attribute_code||' '|| p_category_name ||' '||

Line 6302: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

6298: rollback to start_update_category_usage;
6299: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6300: SUBSTR (SQLERRM, 1, 240) );
6301: FND_MSG_PUB.Add;
6302: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6303: 'PK = '||to_char(p_region_application_id) ||' '||
6304: p_region_code||' '||to_char(p_attribute_application_id)||' '||
6305: p_attribute_code||' '|| p_category_name ||' '||
6306: to_char(p_application_id) );

Line 6307: FND_MSG_PUB.Add;

6303: 'PK = '||to_char(p_region_application_id) ||' '||
6304: p_region_code||' '||to_char(p_attribute_application_id)||' '||
6305: p_attribute_code||' '|| p_category_name ||' '||
6306: to_char(p_application_id) );
6307: FND_MSG_PUB.Add;
6308: FND_MSG_PUB.Count_And_Get (
6309: p_count => p_msg_count,
6310: p_data => p_msg_data);
6311: FND_MSG_PUB.Count_And_Get (

Line 6308: FND_MSG_PUB.Count_And_Get (

6304: p_region_code||' '||to_char(p_attribute_application_id)||' '||
6305: p_attribute_code||' '|| p_category_name ||' '||
6306: to_char(p_application_id) );
6307: FND_MSG_PUB.Add;
6308: FND_MSG_PUB.Count_And_Get (
6309: p_count => p_msg_count,
6310: p_data => p_msg_data);
6311: FND_MSG_PUB.Count_And_Get (
6312: p_count => p_msg_count,

Line 6311: FND_MSG_PUB.Count_And_Get (

6307: FND_MSG_PUB.Add;
6308: FND_MSG_PUB.Count_And_Get (
6309: p_count => p_msg_count,
6310: p_data => p_msg_data);
6311: FND_MSG_PUB.Count_And_Get (
6312: p_count => p_msg_count,
6313: p_data => p_msg_data);
6314:
6315: end UPDATE_CATEGORY_USAGE;