82: if ((p_region_application_id is null) or
83: (p_region_application_id = FND_API.G_MISS_NUM)) then
84: l_error := TRUE;
85: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
86: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
87: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
88: FND_MSG_PUB.Add;
89: end if;
90: end if;
83: (p_region_application_id = FND_API.G_MISS_NUM)) then
84: l_error := TRUE;
85: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
86: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
87: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
88: FND_MSG_PUB.Add;
89: end if;
90: end if;
91:
92: if ((p_region_code is null) or
93: (p_region_code = FND_API.G_MISS_CHAR)) then
94: l_error := TRUE;
95: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
96: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
97: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
98: FND_MSG_PUB.Add;
99: end if;
100: end if;
93: (p_region_code = FND_API.G_MISS_CHAR)) then
94: l_error := TRUE;
95: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
96: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
97: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
98: FND_MSG_PUB.Add;
99: end if;
100: end if;
101:
102: if ((p_graph_number is null) or
103: (p_graph_number = FND_API.G_MISS_NUM)) then
104: l_error := TRUE;
105: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
106: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
107: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
108: FND_MSG_PUB.Add;
109: end if;
110: end if;
103: (p_graph_number = FND_API.G_MISS_NUM)) then
104: l_error := TRUE;
105: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
106: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
107: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
108: FND_MSG_PUB.Add;
109: end if;
110: end if;
111:
115: fetch l_check_region_csr into l_reg_style;
116: if (l_check_region_csr%notfound) then
117: l_error := TRUE;
118: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
119: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REGION_REFERENCE');
120: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
121: ' ' || p_region_code );
122: FND_MSG_PUB.Add;
123: end if;
116: if (l_check_region_csr%notfound) then
117: l_error := TRUE;
118: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
119: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REGION_REFERENCE');
120: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
121: ' ' || p_region_code );
122: FND_MSG_PUB.Add;
123: end if;
124: --dbms_output.put_line('Parent region does not exist!');
125: end if;
126: if (l_reg_style <> 'GRAPH_DATA') then
127: l_error := TRUE;
128: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
129: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REGION_STYLE');
130: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
131: ' ' || p_region_code );
132: FND_MSG_PUB.Add;
133: end if;
126: if (l_reg_style <> 'GRAPH_DATA') then
127: l_error := TRUE;
128: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
129: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REGION_STYLE');
130: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
131: ' ' || p_region_code );
132: FND_MSG_PUB.Add;
133: end if;
134: end if;
141: (p_graph_style = FND_API.G_MISS_NUM and
142: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
143: l_error := TRUE;
144: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
145: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
146: FND_MESSAGE.SET_TOKEN('COLUMN', 'GRAPH_STYLE');
147: FND_MSG_PUB.Add;
148: end if;
149: end if;
142: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
143: l_error := TRUE;
144: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
145: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
146: FND_MESSAGE.SET_TOKEN('COLUMN', 'GRAPH_STYLE');
147: FND_MSG_PUB.Add;
148: end if;
149: end if;
150:
152: (p_display_flag = FND_API.G_MISS_CHAR and
153: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
154: l_error := TRUE;
155: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
156: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
157: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPLAY_FLAG');
158: FND_MSG_PUB.Add;
159: end if;
160: end if;
153: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
154: l_error := TRUE;
155: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
156: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
157: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPLAY_FLAG');
158: FND_MSG_PUB.Add;
159: end if;
160: end if;
161:
166: if (p_display_flag <> FND_API.G_MISS_CHAR) then
167: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_display_flag)) then
168: l_error := TRUE;
169: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
170: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
171: FND_MESSAGE.SET_TOKEN('COLUMN','DISPLAY_FLAG');
172: FND_MSG_PUB.Add;
173: end if;
174: end if;
167: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_display_flag)) then
168: l_error := TRUE;
169: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
170: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
171: FND_MESSAGE.SET_TOKEN('COLUMN','DISPLAY_FLAG');
172: FND_MSG_PUB.Add;
173: end if;
174: end if;
175: end if;
356: if ((p_region_application_id is null) or
357: (p_region_application_id = FND_API.G_MISS_NUM)) then
358: l_error := TRUE;
359: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
360: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
361: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
362: FND_MSG_PUB.Add;
363: end if;
364: end if;
357: (p_region_application_id = FND_API.G_MISS_NUM)) then
358: l_error := TRUE;
359: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
360: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
361: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
362: FND_MSG_PUB.Add;
363: end if;
364: end if;
365:
366: if ((p_region_code is null) or
367: (p_region_code = FND_API.G_MISS_CHAR)) then
368: l_error := TRUE;
369: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
370: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
371: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
372: FND_MSG_PUB.Add;
373: end if;
374: end if;
367: (p_region_code = FND_API.G_MISS_CHAR)) then
368: l_error := TRUE;
369: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
370: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
371: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
372: FND_MSG_PUB.Add;
373: end if;
374: end if;
375:
376: if ((p_attribute_application_id is null) or
377: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
378: l_error := TRUE;
379: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
380: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
381: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
382: FND_MSG_PUB.Add;
383: end if;
384: end if;
377: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
378: l_error := TRUE;
379: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
380: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
381: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
382: FND_MSG_PUB.Add;
383: end if;
384: end if;
385:
386: if ((p_attribute_code is null) or
387: (p_attribute_code = FND_API.G_MISS_CHAR)) then
388: l_error := TRUE;
389: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
390: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
391: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
392: FND_MSG_PUB.Add;
393: end if;
394: end if;
387: (p_attribute_code = FND_API.G_MISS_CHAR)) then
388: l_error := TRUE;
389: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
390: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
391: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
392: FND_MSG_PUB.Add;
393: end if;
394: end if;
395:
399: fetch l_check_region_csr into l_database_object_name;
400: if (l_check_region_csr%notfound) then
401: l_error := TRUE;
402: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
403: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REGION_REFERENCE');
404: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
405: ' ' || p_region_code );
406: FND_MSG_PUB.Add;
407: end if;
400: if (l_check_region_csr%notfound) then
401: l_error := TRUE;
402: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
403: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REGION_REFERENCE');
404: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
405: ' ' || p_region_code );
406: FND_MSG_PUB.Add;
407: end if;
408: --dbms_output.put_line('Parent region does not exist!');
420: p_attribute_application_id => p_attribute_application_id,
421: p_attribute_code => p_attribute_code) ) then
422: l_error := TRUE;
423: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
424: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OA_REFERENCE');
425: FND_MESSAGE.SET_TOKEN('KEY', l_database_object_name ||
426: ' ' || to_char(p_attribute_application_id) ||
427: ' ' || p_attribute_code);
428: FND_MSG_PUB.Add;
421: p_attribute_code => p_attribute_code) ) then
422: l_error := TRUE;
423: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
424: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OA_REFERENCE');
425: FND_MESSAGE.SET_TOKEN('KEY', l_database_object_name ||
426: ' ' || to_char(p_attribute_application_id) ||
427: ' ' || p_attribute_code);
428: FND_MSG_PUB.Add;
429: end if;
437: p_attribute_application_id => p_attribute_application_id,
438: p_attribute_code => p_attribute_code) ) then
439: l_error := TRUE;
440: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
441: FND_MESSAGE.SET_NAME('AK','AK_INVALID_ATTR_REFERENCE');
442: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_attribute_application_id) ||
443: ' ' || p_attribute_code);
444: FND_MSG_PUB.Add;
445: end if;
438: p_attribute_code => p_attribute_code) ) then
439: l_error := TRUE;
440: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
441: FND_MESSAGE.SET_NAME('AK','AK_INVALID_ATTR_REFERENCE');
442: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_attribute_application_id) ||
443: ' ' || p_attribute_code);
444: FND_MSG_PUB.Add;
445: end if;
446: RAISE FND_API.G_EXC_ERROR;
455: (p_display_sequence = FND_API.G_MISS_NUM and
456: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
457: l_error := TRUE;
458: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
459: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
460: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPLAY_SEQUENCE');
461: FND_MSG_PUB.Add;
462: end if;
463: end if;
456: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
457: l_error := TRUE;
458: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
459: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
460: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPLAY_SEQUENCE');
461: FND_MSG_PUB.Add;
462: end if;
463: end if;
464:
466: (p_node_display_flag = FND_API.G_MISS_CHAR and
467: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
468: l_error := TRUE;
469: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
470: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
471: FND_MESSAGE.SET_TOKEN('COLUMN', 'NODE_DISPLAY_FLAG');
472: FND_MSG_PUB.Add;
473: end if;
474: end if;
467: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
468: l_error := TRUE;
469: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
470: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
471: FND_MESSAGE.SET_TOKEN('COLUMN', 'NODE_DISPLAY_FLAG');
472: FND_MSG_PUB.Add;
473: end if;
474: end if;
475:
477: (p_node_query_flag = FND_API.G_MISS_CHAR and
478: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
479: l_error := TRUE;
480: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
481: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
482: FND_MESSAGE.SET_TOKEN('COLUMN', 'NODE_QUERY_FLAG');
483: FND_MSG_PUB.Add;
484: end if;
485: end if;
478: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
479: l_error := TRUE;
480: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
481: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
482: FND_MESSAGE.SET_TOKEN('COLUMN', 'NODE_QUERY_FLAG');
483: FND_MSG_PUB.Add;
484: end if;
485: end if;
486:
488: (p_attribute_label_length = FND_API.G_MISS_NUM and
489: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
490: l_error := TRUE;
491: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
492: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
493: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_LABEL_LENGTH');
494: FND_MSG_PUB.Add;
495: end if;
496: end if;
489: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
490: l_error := TRUE;
491: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
492: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
493: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_LABEL_LENGTH');
494: FND_MSG_PUB.Add;
495: end if;
496: end if;
497:
499: (p_display_value_length = FND_API.G_MISS_NUM and
500: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
501: l_error := TRUE;
502: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
503: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
504: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPLAY_VALUE_LENGTH');
505: FND_MSG_PUB.Add;
506: end if;
507: end if;
500: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
501: l_error := TRUE;
502: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
503: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
504: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPLAY_VALUE_LENGTH');
505: FND_MSG_PUB.Add;
506: end if;
507: end if;
508:
510: (p_bold = FND_API.G_MISS_CHAR and
511: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
512: l_error := TRUE;
513: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
514: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
515: FND_MESSAGE.SET_TOKEN('COLUMN', 'BOLD');
516: FND_MSG_PUB.Add;
517: end if;
518: end if;
511: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
512: l_error := TRUE;
513: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
514: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
515: FND_MESSAGE.SET_TOKEN('COLUMN', 'BOLD');
516: FND_MSG_PUB.Add;
517: end if;
518: end if;
519:
521: (p_italic = FND_API.G_MISS_CHAR and
522: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
523: l_error := TRUE;
524: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
525: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
526: FND_MESSAGE.SET_TOKEN('COLUMN','ITALIC');
527: FND_MSG_PUB.Add;
528: end if;
529: end if;
522: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
523: l_error := TRUE;
524: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
525: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
526: FND_MESSAGE.SET_TOKEN('COLUMN','ITALIC');
527: FND_MSG_PUB.Add;
528: end if;
529: end if;
530:
532: (p_vertical_alignment = FND_API.G_MISS_CHAR and
533: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
534: l_error := TRUE;
535: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
536: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
537: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERTICAL_ALIGNMENT');
538: FND_MSG_PUB.Add;
539: end if;
540: end if;
533: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
534: l_error := TRUE;
535: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
536: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
537: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERTICAL_ALIGNMENT');
538: FND_MSG_PUB.Add;
539: end if;
540: end if;
541:
543: (p_horizontal_alignment = FND_API.G_MISS_CHAR and
544: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
545: l_error := TRUE;
546: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
547: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
548: FND_MESSAGE.SET_TOKEN('COLUMN', 'HORIZONTAL_ALIGNMENT');
549: FND_MSG_PUB.Add;
550: end if;
551: end if;
544: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
545: l_error := TRUE;
546: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
547: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
548: FND_MESSAGE.SET_TOKEN('COLUMN', 'HORIZONTAL_ALIGNMENT');
549: FND_MSG_PUB.Add;
550: end if;
551: end if;
552:
554: (p_item_style = FND_API.G_MISS_CHAR and
555: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
556: l_error := TRUE;
557: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
558: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
559: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_SYTLE');
560: FND_MSG_PUB.Add;
561: end if;
562: end if;
555: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
556: l_error := TRUE;
557: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
558: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
559: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_SYTLE');
560: FND_MSG_PUB.Add;
561: end if;
562: end if;
563:
565: (p_object_attribute_flag = FND_API.G_MISS_CHAR and
566: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
567: l_error := TRUE;
568: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
569: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
570: FND_MESSAGE.SET_TOKEN('COLUMN', 'OBJECT_ATTRIBUTE_FLAG');
571: FND_MSG_PUB.Add;
572: end if;
573: end if;
566: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
567: l_error := TRUE;
568: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
569: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
570: FND_MESSAGE.SET_TOKEN('COLUMN', 'OBJECT_ATTRIBUTE_FLAG');
571: FND_MSG_PUB.Add;
572: end if;
573: end if;
574:
576: (p_update_flag = FND_API.G_MISS_CHAR and
577: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
578: l_error := TRUE;
579: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
580: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
581: FND_MESSAGE.SET_TOKEN('COLUMN', 'UPDATE_FLAG');
582: FND_MSG_PUB.Add;
583: end if;
584: end if;
577: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
578: l_error := TRUE;
579: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
580: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
581: FND_MESSAGE.SET_TOKEN('COLUMN', 'UPDATE_FLAG');
582: FND_MSG_PUB.Add;
583: end if;
584: end if;
585:
587: (p_required_flag = FND_API.G_MISS_CHAR and
588: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
589: l_error := TRUE;
590: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
591: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
592: FND_MESSAGE.SET_TOKEN('COLUMN', 'REQUIRED_FLAG');
593: FND_MSG_PUB.Add;
594: end if;
595: end if;
588: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
589: l_error := TRUE;
590: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
591: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
592: FND_MESSAGE.SET_TOKEN('COLUMN', 'REQUIRED_FLAG');
593: FND_MSG_PUB.Add;
594: end if;
595: end if;
596:
603: fetch l_check_seq_csr into l_dummy;
604: if (l_check_seq_csr%found) then
605: l_error := TRUE;
606: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
607: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_DISPLAY_SEQUENCE');
608: FND_MSG_PUB.Add;
609: end if;
610: end if;
611: close l_check_seq_csr;
615: if (p_node_display_flag <> FND_API.G_MISS_CHAR) then
616: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_node_display_flag)) then
617: l_error := TRUE;
618: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
619: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
620: FND_MESSAGE.SET_TOKEN('COLUMN','NODE_DISPLAY_FLAG');
621: FND_MSG_PUB.Add;
622: end if;
623: end if;
616: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_node_display_flag)) then
617: l_error := TRUE;
618: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
619: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
620: FND_MESSAGE.SET_TOKEN('COLUMN','NODE_DISPLAY_FLAG');
621: FND_MSG_PUB.Add;
622: end if;
623: end if;
624: end if;
627: if (p_node_query_flag <> FND_API.G_MISS_CHAR) then
628: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_node_query_flag)) then
629: l_error := TRUE;
630: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
631: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
632: FND_MESSAGE.SET_TOKEN('COLUMN','NODE_QUERY_FLAG');
633: FND_MSG_PUB.Add;
634: end if;
635: end if;
628: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_node_query_flag)) then
629: l_error := TRUE;
630: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
631: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
632: FND_MESSAGE.SET_TOKEN('COLUMN','NODE_QUERY_FLAG');
633: FND_MSG_PUB.Add;
634: end if;
635: end if;
636: end if;
639: if (p_bold <> FND_API.G_MISS_CHAR) then
640: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_bold)) then
641: l_error := TRUE;
642: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
643: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
644: FND_MESSAGE.SET_TOKEN('COLUMN','BOLD');
645: FND_MSG_PUB.Add;
646: end if;
647: end if;
640: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_bold)) then
641: l_error := TRUE;
642: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
643: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
644: FND_MESSAGE.SET_TOKEN('COLUMN','BOLD');
645: FND_MSG_PUB.Add;
646: end if;
647: end if;
648: end if;
651: if (p_italic <> FND_API.G_MISS_CHAR) then
652: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_italic)) then
653: l_error := TRUE;
654: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
655: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
656: FND_MESSAGE.SET_TOKEN('COLUMN','ITALIC');
657: FND_MSG_PUB.Add;
658: end if;
659: end if;
652: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_italic)) then
653: l_error := TRUE;
654: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
655: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
656: FND_MESSAGE.SET_TOKEN('COLUMN','ITALIC');
657: FND_MSG_PUB.Add;
658: end if;
659: end if;
660: end if;
667: p_lookup_type => 'VERTICAL_ALIGNMENT',
668: p_lookup_code => p_vertical_alignment)) then
669: l_error := TRUE;
670: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
671: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
672: FND_MESSAGE.SET_TOKEN('COLUMN','VERTICAL_ALIGNMENT');
673: FND_MSG_PUB.Add;
674: end if;
675: end if;
668: p_lookup_code => p_vertical_alignment)) then
669: l_error := TRUE;
670: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
671: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
672: FND_MESSAGE.SET_TOKEN('COLUMN','VERTICAL_ALIGNMENT');
673: FND_MSG_PUB.Add;
674: end if;
675: end if;
676: end if;
683: p_lookup_type => 'HORIZONTAL_ALIGNMENT',
684: p_lookup_code => p_horizontal_alignment)) then
685: l_error := TRUE;
686: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
687: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
688: FND_MESSAGE.SET_TOKEN('COLUMN','HORIZONTAL_ALIGNMENT');
689: FND_MSG_PUB.Add;
690: end if;
691: end if;
684: p_lookup_code => p_horizontal_alignment)) then
685: l_error := TRUE;
686: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
687: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
688: FND_MESSAGE.SET_TOKEN('COLUMN','HORIZONTAL_ALIGNMENT');
689: FND_MSG_PUB.Add;
690: end if;
691: end if;
692: end if;
699: p_lookup_type => 'ITEM_STYLE',
700: p_lookup_code => p_item_style)) then
701: l_error := TRUE;
702: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
703: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
704: FND_MESSAGE.SET_TOKEN('COLUMN','ITEM_STYLE');
705: FND_MSG_PUB.Add;
706: end if;
707: end if;
700: p_lookup_code => p_item_style)) then
701: l_error := TRUE;
702: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
703: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
704: FND_MESSAGE.SET_TOKEN('COLUMN','ITEM_STYLE');
705: FND_MSG_PUB.Add;
706: end if;
707: end if;
708: end if;
711: if (p_object_attribute_flag <> FND_API.G_MISS_CHAR) then
712: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_object_attribute_flag)) then
713: l_error := TRUE;
714: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
715: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
716: FND_MESSAGE.SET_TOKEN('COLUMN','OBJECT_ATTRIBUTE_FLAG');
717: FND_MSG_PUB.Add;
718: end if;
719: end if;
712: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_object_attribute_flag)) then
713: l_error := TRUE;
714: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
715: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
716: FND_MESSAGE.SET_TOKEN('COLUMN','OBJECT_ATTRIBUTE_FLAG');
717: FND_MSG_PUB.Add;
718: end if;
719: end if;
720: end if;
723: if (p_update_flag <> FND_API.G_MISS_CHAR) then
724: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_update_flag)) then
725: l_error := TRUE;
726: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
727: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
728: FND_MESSAGE.SET_TOKEN('COLUMN','UPDATE_FLAG');
729: FND_MSG_PUB.Add;
730: end if;
731: end if;
724: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_update_flag)) then
725: l_error := TRUE;
726: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
727: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
728: FND_MESSAGE.SET_TOKEN('COLUMN','UPDATE_FLAG');
729: FND_MSG_PUB.Add;
730: end if;
731: end if;
732: end if;
735: if (p_required_flag <> FND_API.G_MISS_CHAR) then
736: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_required_flag)) then
737: l_error := TRUE;
738: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
739: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
740: FND_MESSAGE.SET_TOKEN('COLUMN','REQUIRED_FLAG');
741: FND_MSG_PUB.Add;
742: end if;
743: end if;
736: if (NOT AK_ON_OBJECTS_PVT.VALID_YES_NO(p_required_flag)) then
737: l_error := TRUE;
738: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
739: FND_MESSAGE.SET_NAME('AK','AK_VALUE_NOT_YES_NO');
740: FND_MESSAGE.SET_TOKEN('COLUMN','REQUIRED_FLAG');
741: FND_MSG_PUB.Add;
742: end if;
743: end if;
744: end if;
754: p_region_application_id => p_nested_region_appl_id,
755: p_region_code => p_nested_region_code)) then
756: l_error := TRUE;
757: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
758: FND_MESSAGE.SET_NAME('AK','AK_NST_REG_DOES_NOT_EXIST');
759: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_nested_region_appl_id) || ' ' || p_nested_region_code);
760: FND_MSG_PUB.Add;
761: end if;
762: end if;
755: p_region_code => p_nested_region_code)) then
756: l_error := TRUE;
757: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
758: FND_MESSAGE.SET_NAME('AK','AK_NST_REG_DOES_NOT_EXIST');
759: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_nested_region_appl_id) || ' ' || p_nested_region_code);
760: FND_MSG_PUB.Add;
761: end if;
762: end if;
763: end if;
773: p_region_application_id => p_lov_region_application_id,
774: p_region_code => p_lov_region_code)) then
775: l_error := TRUE;
776: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
777: FND_MESSAGE.SET_NAME('AK','AK_LOV_REG_DOES_NOT_EXIST');
778: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_application_id) || ' ' || p_lov_region_code);
779: FND_MSG_PUB.Add;
780: end if;
781: end if;
774: p_region_code => p_lov_region_code)) then
775: l_error := TRUE;
776: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
777: FND_MESSAGE.SET_NAME('AK','AK_LOV_REG_DOES_NOT_EXIST');
778: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_lov_region_application_id) || ' ' || p_lov_region_code);
779: FND_MSG_PUB.Add;
780: end if;
781: end if;
782: end if;
794: p_attribute_application_id => p_lov_attribute_application_id,
795: p_attribute_code => p_lov_attribute_code)) then
796: l_error := TRUE;
797: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
798: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_ITEM_REFERENCE');
799: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id)||' '||p_region_code||' '||
800: to_char(p_attribute_application_id) ||' ' || p_attribute_code);
801: FND_MSG_PUB.Add;
802: end if;
795: p_attribute_code => p_lov_attribute_code)) then
796: l_error := TRUE;
797: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
798: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_ITEM_REFERENCE');
799: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id)||' '||p_region_code||' '||
800: to_char(p_attribute_application_id) ||' ' || p_attribute_code);
801: FND_MSG_PUB.Add;
802: end if;
803: end if;
811: p_return_status => l_return_status,
812: p_foreign_key_name => p_lov_foreign_key_name)) then
813: l_error := TRUE;
814: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
815: FND_MESSAGE.SET_NAME('AK','AK_INVALID_LOV_FK_REFERENCE');
816: FND_MSG_PUB.Add;
817: end if;
818: end if;
819: end if;
826: p_lookup_type => 'LOV_DEFAULT_FLAG',
827: p_lookup_code => p_lov_default_flag)) then
828: l_error := TRUE;
829: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
830: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
831: FND_MESSAGE.SET_TOKEN('COLUMN','LOV_DEFAULT_FLAG');
832: FND_MSG_PUB.Add;
833: end if;
834: end if;
827: p_lookup_code => p_lov_default_flag)) then
828: l_error := TRUE;
829: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
830: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
831: FND_MESSAGE.SET_TOKEN('COLUMN','LOV_DEFAULT_FLAG');
832: FND_MSG_PUB.Add;
833: end if;
834: end if;
835: end if;
842: p_lookup_type => 'ORDER_DIRECTION',
843: p_lookup_code => p_order_direction)) then
844: l_error := TRUE;
845: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
846: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
847: FND_MESSAGE.SET_TOKEN('COLUMN','ORDER_DIRECTION');
848: FND_MSG_PUB.Add;
849: end if;
850: end if;
843: p_lookup_code => p_order_direction)) then
844: l_error := TRUE;
845: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
846: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
847: FND_MESSAGE.SET_TOKEN('COLUMN','ORDER_DIRECTION');
848: FND_MSG_PUB.Add;
849: end if;
850: end if;
851: end if;
856: fetch l_check_menu_name into l_dummy;
857: if ( l_check_menu_name%notfound) then
858: l_error := TRUE;
859: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
860: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
861: FND_MESSAGE.SET_TOKEN('COLUMN','MENU_NAME');
862: FND_MSG_PUB.Add;
863: end if;
864: end if;
857: if ( l_check_menu_name%notfound) then
858: l_error := TRUE;
859: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
860: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
861: FND_MESSAGE.SET_TOKEN('COLUMN','MENU_NAME');
862: FND_MSG_PUB.Add;
863: end if;
864: end if;
865: close l_check_menu_name;
871: fetch l_check_flexfield_name into l_dummy;
872: if ( l_check_flexfield_name%notfound) then
873: l_error := TRUE;
874: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
875: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
876: FND_MESSAGE.SET_TOKEN('COLUMN','FLEXFIELD_NAME');
877: FND_MSG_PUB.Add;
878: end if;
879: end if;
872: if ( l_check_flexfield_name%notfound) then
873: l_error := TRUE;
874: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
875: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
876: FND_MESSAGE.SET_TOKEN('COLUMN','FLEXFIELD_NAME');
877: FND_MSG_PUB.Add;
878: end if;
879: end if;
880: close l_check_flexfield_name;
886: fetch l_check_message_name into l_dummy;
887: if ( l_check_message_name%notfound) then
888: l_error := TRUE;
889: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
890: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
891: FND_MESSAGE.SET_TOKEN('COLUMN','TIP_MESSAGE_NAME');
892: FND_MSG_PUB.Add;
893: end if;
894: end if;
887: if ( l_check_message_name%notfound) then
888: l_error := TRUE;
889: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
890: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
891: FND_MESSAGE.SET_TOKEN('COLUMN','TIP_MESSAGE_NAME');
892: FND_MSG_PUB.Add;
893: end if;
894: end if;
895: close l_check_message_name;
901: fetch l_check_entity_id into l_dummy;
902: if ( l_check_entity_id%notfound) then
903: l_error := TRUE;
904: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
905: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
906: FND_MESSAGE.SET_TOKEN('COLUMN','ENTITY_ID');
907: FND_MSG_PUB.Add;
908: end if;
909: end if;
902: if ( l_check_entity_id%notfound) then
903: l_error := TRUE;
904: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
905: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
906: FND_MESSAGE.SET_TOKEN('COLUMN','ENTITY_ID');
907: FND_MSG_PUB.Add;
908: end if;
909: end if;
910: close l_check_entity_id;
920: p_lookup_code => p_initial_sort_sequence)) then
921: l_error := TRUE;
922: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass =
923: 2) then
924: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
925: FND_MESSAGE.SET_TOKEN('COLUMN','INITIAL_SORT_SEQUENCE');
926: FND_MSG_PUB.Add;
927: end if;
928: end if;
921: l_error := TRUE;
922: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass =
923: 2) then
924: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
925: FND_MESSAGE.SET_TOKEN('COLUMN','INITIAL_SORT_SEQUENCE');
926: FND_MSG_PUB.Add;
927: end if;
928: end if;
929: end if;
1020: if ((p_region_application_id is null) or
1021: (p_region_application_id = FND_API.G_MISS_NUM)) then
1022: l_error := TRUE;
1023: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1024: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1025: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
1026: FND_MSG_PUB.Add;
1027: end if;
1028: end if;
1021: (p_region_application_id = FND_API.G_MISS_NUM)) then
1022: l_error := TRUE;
1023: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1024: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1025: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
1026: FND_MSG_PUB.Add;
1027: end if;
1028: end if;
1029:
1030: if ((p_region_code is null) or
1031: (p_region_code = FND_API.G_MISS_CHAR)) then
1032: l_error := TRUE;
1033: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1034: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1035: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
1036: FND_MSG_PUB.Add;
1037: end if;
1038: end if;
1031: (p_region_code = FND_API.G_MISS_CHAR)) then
1032: l_error := TRUE;
1033: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1034: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1035: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
1036: FND_MSG_PUB.Add;
1037: end if;
1038: end if;
1039:
1043: (p_database_object_name = FND_API.G_MISS_CHAR and
1044: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1045: l_error := TRUE;
1046: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1047: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1048: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
1049: FND_MSG_PUB.Add;
1050: end if;
1051: end if;
1044: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1045: l_error := TRUE;
1046: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1047: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1048: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
1049: FND_MSG_PUB.Add;
1050: end if;
1051: end if;
1052:
1054: ((p_region_style = FND_API.G_MISS_CHAR) and
1055: (p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1056: l_error := TRUE;
1057: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1058: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1059: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_STYLE');
1060: FND_MSG_PUB.Add;
1061: end if;
1062: end if;
1055: (p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1056: l_error := TRUE;
1057: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1058: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1059: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_STYLE');
1060: FND_MSG_PUB.Add;
1061: end if;
1062: end if;
1063:
1065: (p_name = FND_API.G_MISS_CHAR and
1066: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1067: l_error := TRUE;
1068: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1069: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1070: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
1071: FND_MSG_PUB.Add;
1072: end if;
1073: end if;
1066: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1067: l_error := TRUE;
1068: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1069: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1070: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
1071: FND_MSG_PUB.Add;
1072: end if;
1073: end if;
1074:
1080: p_return_status => l_return_status,
1081: p_database_object_name => p_database_object_name)) then
1082: l_error := TRUE;
1083: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1084: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OBJECT_REFERENCE');
1085: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
1086: FND_MSG_PUB.Add;
1087: end if;
1088: --dbms_output.put_line(l_api_name || ' Invalid database object name');
1081: p_database_object_name => p_database_object_name)) then
1082: l_error := TRUE;
1083: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1084: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OBJECT_REFERENCE');
1085: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
1086: FND_MSG_PUB.Add;
1087: end if;
1088: --dbms_output.put_line(l_api_name || ' Invalid database object name');
1089: end if;
1097: p_lookup_type => 'REGION_STYLE',
1098: p_lookup_code => p_region_style)) then
1099: l_error := TRUE;
1100: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1101: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
1102: FND_MESSAGE.SET_TOKEN('COLUMN','REGION_STYLE');
1103: FND_MSG_PUB.Add;
1104: end if;
1105: --dbms_output.put_line(l_api_name || ' Invalid region style');
1098: p_lookup_code => p_region_style)) then
1099: l_error := TRUE;
1100: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1101: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
1102: FND_MESSAGE.SET_TOKEN('COLUMN','REGION_STYLE');
1103: FND_MSG_PUB.Add;
1104: end if;
1105: --dbms_output.put_line(l_api_name || ' Invalid region style');
1106: end if;
1196: p_graph_number => l_graph_columns_rec.graph_number,
1197: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
1198: then
1199: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1200: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_NOT_DOWNLOADED');
1201: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1202: p_region_code);
1203: FND_MSG_PUB.Add;
1204: end if;
1197: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
1198: then
1199: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1200: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_NOT_DOWNLOADED');
1201: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1202: p_region_code);
1203: FND_MSG_PUB.Add;
1204: end if;
1205: close l_get_graph_columns_csr;
1260:
1261: EXCEPTION
1262: WHEN VALUE_ERROR THEN
1263: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1264: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_VALUE_ERROR');
1265: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1266: p_region_code);
1267: FND_MSG_PUB.Add;
1268: end if;
1261: EXCEPTION
1262: WHEN VALUE_ERROR THEN
1263: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1264: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_VALUE_ERROR');
1265: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1266: p_region_code);
1267: FND_MSG_PUB.Add;
1268: end if;
1269: p_return_status := FND_API.G_RET_STS_ERROR;
1268: end if;
1269: p_return_status := FND_API.G_RET_STS_ERROR;
1270: WHEN FND_API.G_EXC_ERROR THEN
1271: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1272: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_NOT_DOWNLOADED');
1273: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1274: p_region_code);
1275: FND_MSG_PUB.Add;
1276: end if;
1269: p_return_status := FND_API.G_RET_STS_ERROR;
1270: WHEN FND_API.G_EXC_ERROR THEN
1271: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1272: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COLUMN_NOT_DOWNLOADED');
1273: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1274: p_region_code);
1275: FND_MSG_PUB.Add;
1276: end if;
1277: p_return_status := FND_API.G_RET_STS_ERROR;
1359: p_show_all => l_category_usage_rec.show_all,
1360: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
1361: then
1362: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1363: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_NOT_DOWNLOADED');
1364: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1365: p_region_code||' '||to_char(p_attribute_application_id)||
1366: ' '||p_attribute_code);
1367: FND_MSG_PUB.Add;
1360: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
1361: then
1362: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1363: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_NOT_DOWNLOADED');
1364: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1365: p_region_code||' '||to_char(p_attribute_application_id)||
1366: ' '||p_attribute_code);
1367: FND_MSG_PUB.Add;
1368: end if;
1443:
1444: EXCEPTION
1445: WHEN VALUE_ERROR THEN
1446: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1447: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_VALUE_ERROR');
1448: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1449: p_region_code||' '||to_char(p_attribute_application_id)||
1450: ' '||p_attribute_code);
1451: FND_MSG_PUB.Add;
1444: EXCEPTION
1445: WHEN VALUE_ERROR THEN
1446: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1447: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_VALUE_ERROR');
1448: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1449: p_region_code||' '||to_char(p_attribute_application_id)||
1450: ' '||p_attribute_code);
1451: FND_MSG_PUB.Add;
1452: end if;
1452: end if;
1453: p_return_status := FND_API.G_RET_STS_ERROR;
1454: WHEN FND_API.G_EXC_ERROR THEN
1455: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1456: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_NOT_DOWNLOADED');
1457: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1458: p_region_code||' '||to_char(p_attribute_application_id)||
1459: ' '||p_attribute_code);
1460: FND_MSG_PUB.Add;
1453: p_return_status := FND_API.G_RET_STS_ERROR;
1454: WHEN FND_API.G_EXC_ERROR THEN
1455: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1456: FND_MESSAGE.SET_NAME('AK','AK_CATEGORY_USAGE_NOT_DOWNLOADED');
1457: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1458: p_region_code||' '||to_char(p_attribute_application_id)||
1459: ' '||p_attribute_code);
1460: FND_MSG_PUB.Add;
1461: end if;
1544: p_base_region_code => l_lov_relation_rec.base_region_code,
1545: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
1546: then
1547: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1548: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_NOT_DOWNLOADED');
1549: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1550: p_region_code);
1551: FND_MSG_PUB.Add;
1552: end if;
1545: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
1546: then
1547: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1548: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_NOT_DOWNLOADED');
1549: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1550: p_region_code);
1551: FND_MSG_PUB.Add;
1552: end if;
1553: close l_get_lov_relations_csr;
1631:
1632: EXCEPTION
1633: WHEN VALUE_ERROR THEN
1634: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1635: FND_MESSAGE.SET_NAME('AK','AK_LOV_REGION_VALUE_ERROR');
1636: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1637: p_region_code||' '||to_char(p_attribute_application_id)||
1638: ' '||p_attribute_code||' '||to_char(p_lov_region_appl_id)||
1639: ' '||p_lov_region_code);
1632: EXCEPTION
1633: WHEN VALUE_ERROR THEN
1634: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1635: FND_MESSAGE.SET_NAME('AK','AK_LOV_REGION_VALUE_ERROR');
1636: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1637: p_region_code||' '||to_char(p_attribute_application_id)||
1638: ' '||p_attribute_code||' '||to_char(p_lov_region_appl_id)||
1639: ' '||p_lov_region_code);
1640: FND_MSG_PUB.Add;
1641: end if;
1642: p_return_status := FND_API.G_RET_STS_ERROR;
1643: WHEN FND_API.G_EXC_ERROR THEN
1644: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1645: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_NOT_DOWNLOADED');
1646: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1647: p_region_code||' '||to_char(p_attribute_application_id)||
1648: ' '||p_attribute_code||' '||to_char(p_lov_region_appl_id)||
1649: ' '||p_lov_region_code);
1642: p_return_status := FND_API.G_RET_STS_ERROR;
1643: WHEN FND_API.G_EXC_ERROR THEN
1644: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1645: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_NOT_DOWNLOADED');
1646: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1647: p_region_code||' '||to_char(p_attribute_application_id)||
1648: ' '||p_attribute_code||' '||to_char(p_lov_region_appl_id)||
1649: ' '||p_lov_region_code);
1650: FND_MSG_PUB.Add;
1747: p_graph_title => l_graphs_tl_rec.graph_title,
1748: p_y_axis_label => l_graphs_tl_rec.y_axis_label,
1749: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
1750: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1751: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_NOT_DOWNLOADED');
1752: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
1753: ' ' || p_region_code ||
1754: ' ' || to_char(l_graphs_rec.graph_number));
1755: FND_MSG_PUB.Add;
1748: p_y_axis_label => l_graphs_tl_rec.y_axis_label,
1749: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
1750: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1751: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_NOT_DOWNLOADED');
1752: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
1753: ' ' || p_region_code ||
1754: ' ' || to_char(l_graphs_rec.graph_number));
1755: FND_MSG_PUB.Add;
1756: close l_get_graph_tl_csr;
1842: p_graph_number => l_graphs_rec.graph_number
1843: );
1844: else
1845: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1846: FND_MESSAGE.SET_NAME('AK','AK_GRAPH_COL_DOES_NOT_EXIST');
1847: FND_MSG_PUB.Add;
1848: end if;
1849: -- RAISE FND_API.G_EXC_ERROR;
1850: end if; -- end if l_write_column_flag
1890:
1891: EXCEPTION
1892: WHEN VALUE_ERROR THEN
1893: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1894: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_VALUE_ERROR');
1895: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
1896: ' ' || p_region_code ||
1897: ' ' || l_graphs_rec.graph_number);
1898: FND_MSG_PUB.Add;
1891: EXCEPTION
1892: WHEN VALUE_ERROR THEN
1893: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1894: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_VALUE_ERROR');
1895: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
1896: ' ' || p_region_code ||
1897: ' ' || l_graphs_rec.graph_number);
1898: FND_MSG_PUB.Add;
1899: end if;
2078: p_attribute_label_long => l_items_tl_rec.attribute_label_long,
2079: p_attribute_label_short => l_items_tl_rec.attribute_label_short,
2080: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
2081: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2082: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_DOWNLOADED');
2083: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
2084: ' ' || p_region_code ||
2085: ' ' || to_char(l_items_rec.attribute_application_id) ||
2086: ' ' || l_items_rec.attribute_code);
2079: p_attribute_label_short => l_items_tl_rec.attribute_label_short,
2080: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
2081: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2082: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_DOWNLOADED');
2083: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
2084: ' ' || p_region_code ||
2085: ' ' || to_char(l_items_rec.attribute_application_id) ||
2086: ' ' || l_items_rec.attribute_code);
2087: FND_MSG_PUB.Add;
2721: p_lov_region_code => l_items_rec.lov_region_code
2722: );
2723: else
2724: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2725: FND_MESSAGE.SET_NAME('AK','AK_LOV_RELATION_DOES_NOT_EXIST');
2726: FND_MSG_PUB.Add;
2727: end if;
2728: -- RAISE FND_API.G_EXC_ERROR;
2729: end if; -- end if l_write_relation_flag
2786:
2787: EXCEPTION
2788: WHEN VALUE_ERROR THEN
2789: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2790: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_VALUE_ERROR');
2791: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
2792: ' ' || p_region_code ||
2793: ' ' || to_char(l_items_rec.attribute_application_id) ||
2794: ' ' || l_items_rec.attribute_code);
2787: EXCEPTION
2788: WHEN VALUE_ERROR THEN
2789: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2790: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_VALUE_ERROR');
2791: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
2792: ' ' || p_region_code ||
2793: ' ' || to_char(l_items_rec.attribute_application_id) ||
2794: ' ' || l_items_rec.attribute_code);
2795: FND_MSG_PUB.Add;
2861: fetch l_get_region_csr into l_regions_rec;
2862: if (l_get_region_csr%notfound) then
2863: close l_get_region_csr;
2864: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2865: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
2866: FND_MSG_PUB.Add;
2867: end if;
2868: -- dbms_output.put_line('Cannot find region '||p_region_code);
2869: RAISE FND_API.G_EXC_ERROR;
2876: fetch l_get_region_tl_csr into l_regions_tl_rec;
2877: if (l_get_region_tl_csr%notfound) then
2878: close l_get_region_tl_csr;
2879: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2880: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
2881: FND_MSG_PUB.Add;
2882: end if;
2883: --dbms_output.put_line('Cannot find region TL '||p_region_code);
2884: RAISE FND_API.G_EXC_ERROR;
2909: then
2910: -- dbms_output.put_line('Region ' || p_region_code
2911: -- || ' not downloaded due to validation error');
2912: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2913: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_DOWNLOADED');
2914: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
2915: p_region_code);
2916: FND_MSG_PUB.Add;
2917: end if;
2910: -- dbms_output.put_line('Region ' || p_region_code
2911: -- || ' not downloaded due to validation error');
2912: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2913: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_DOWNLOADED');
2914: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
2915: p_region_code);
2916: FND_MSG_PUB.Add;
2917: end if;
2918: raise FND_API.G_EXC_ERROR;
3342:
3343: EXCEPTION
3344: WHEN VALUE_ERROR THEN
3345: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3346: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
3347: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
3348: ' ' || p_region_code);
3349: FND_MSG_PUB.Add;
3350: end if;
3343: EXCEPTION
3344: WHEN VALUE_ERROR THEN
3345: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3346: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
3347: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
3348: ' ' || p_region_code);
3349: FND_MSG_PUB.Add;
3350: end if;
3351: p_return_status := FND_API.G_RET_STS_ERROR;
3350: end if;
3351: p_return_status := FND_API.G_RET_STS_ERROR;
3352: WHEN FND_API.G_EXC_ERROR THEN
3353: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3354: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_DOWNLOADED');
3355: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
3356: ' ' || p_region_code);
3357: FND_MSG_PUB.Add;
3358: end if;
3351: p_return_status := FND_API.G_RET_STS_ERROR;
3352: WHEN FND_API.G_EXC_ERROR THEN
3353: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3354: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_DOWNLOADED');
3355: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
3356: ' ' || p_region_code);
3357: FND_MSG_PUB.Add;
3358: end if;
3359: p_return_status := FND_API.G_RET_STS_ERROR;
3452: p_region_application_id => p_region_application_id,
3453: p_region_code => p_region_code,
3454: p_graph_number => p_graph_number) then
3455: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3456: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_EXISTS');
3457: FND_MSG_PUB.Add;
3458: end if;
3459: --dbms_output.put_line(l_api_name || 'Error - row already exists');
3460: raise FND_API.G_EXC_ERROR;
3554: p_region_application_id => p_region_application_id,
3555: p_region_code => p_region_code,
3556: p_graph_number => p_graph_number) then
3557: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3558: FND_MESSAGE.SET_NAME('AK','AK_INSERT_REG_GRAPH_FAILED');
3559: FND_MSG_PUB.Add;
3560: end if;
3561: --dbms_output.put_line(l_api_name || 'Error - row already exists');
3562: raise FND_API.G_EXC_ERROR;
3601: -- ** commit the insert **
3602: commit;
3603:
3604: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3605: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_CREATED');
3606: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_REGION_GRAPH',TRUE);
3607: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
3608: ' ' || p_region_code ||
3609: ' ' || p_graph_number);
3602: commit;
3603:
3604: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3605: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_CREATED');
3606: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_REGION_GRAPH',TRUE);
3607: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
3608: ' ' || p_region_code ||
3609: ' ' || p_graph_number);
3610: FND_MSG_PUB.Add;
3603:
3604: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3605: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_CREATED');
3606: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_REGION_GRAPH',TRUE);
3607: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
3608: ' ' || p_region_code ||
3609: ' ' || p_graph_number);
3610: FND_MSG_PUB.Add;
3611: end if;
3618:
3619: EXCEPTION
3620: WHEN VALUE_ERROR THEN
3621: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3622: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_VALUE_ERROR');
3623: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
3624: ' ' || p_region_code ||
3625: ' ' || p_graph_number);
3626: FND_MSG_PUB.Add;
3619: EXCEPTION
3620: WHEN VALUE_ERROR THEN
3621: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3622: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_VALUE_ERROR');
3623: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
3624: ' ' || p_region_code ||
3625: ' ' || p_graph_number);
3626: FND_MSG_PUB.Add;
3627: end if;
3631: p_count => p_msg_count,
3632: p_data => p_msg_data);
3633: WHEN FND_API.G_EXC_ERROR THEN
3634: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3635: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_NOT_CREATED');
3636: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
3637: ' ' || p_region_code ||
3638: ' ' || p_graph_number);
3639: FND_MSG_PUB.Add;
3632: p_data => p_msg_data);
3633: WHEN FND_API.G_EXC_ERROR THEN
3634: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3635: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_NOT_CREATED');
3636: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
3637: ' ' || p_region_code ||
3638: ' ' || p_graph_number);
3639: FND_MSG_PUB.Add;
3640: end if;
3894: p_region_code => p_region_code,
3895: p_attribute_application_id => p_attribute_application_id,
3896: p_attribute_code => p_attribute_code) then
3897: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3898: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_EXISTS');
3899: FND_MSG_PUB.Add;
3900: end if;
3901: --dbms_output.put_line(l_api_name || 'Error - row already exists');
3902: raise FND_API.G_EXC_ERROR;
4546: p_region_code => p_region_code,
4547: p_attribute_application_id => p_attribute_application_id,
4548: p_attribute_code => p_attribute_code) then
4549: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4550: FND_MESSAGE.SET_NAME('AK','AK_INSERT_REG_ITEM_FAILED');
4551: FND_MSG_PUB.Add;
4552: end if;
4553: --dbms_output.put_line(l_api_name || 'Error - row already exists');
4554: raise FND_API.G_EXC_ERROR;
4598: -- /** commit the insert **/
4599: commit;
4600:
4601: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4602: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_CREATED');
4603: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_REGION_ITEM',TRUE);
4604: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4605: ' ' || p_region_code ||
4606: ' ' || to_char(p_attribute_application_id) ||
4599: commit;
4600:
4601: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4602: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_CREATED');
4603: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_REGION_ITEM',TRUE);
4604: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4605: ' ' || p_region_code ||
4606: ' ' || to_char(p_attribute_application_id) ||
4607: ' ' || p_attribute_code);
4600:
4601: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4602: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_CREATED');
4603: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_REGION_ITEM',TRUE);
4604: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4605: ' ' || p_region_code ||
4606: ' ' || to_char(p_attribute_application_id) ||
4607: ' ' || p_attribute_code);
4608: FND_MSG_PUB.Add;
4619:
4620: EXCEPTION
4621: WHEN VALUE_ERROR THEN
4622: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4623: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_VALUE_ERROR');
4624: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4625: ' ' || p_region_code ||
4626: ' ' || to_char(p_attribute_application_id) ||
4627: ' ' || p_attribute_code);
4620: EXCEPTION
4621: WHEN VALUE_ERROR THEN
4622: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4623: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_VALUE_ERROR');
4624: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4625: ' ' || p_region_code ||
4626: ' ' || to_char(p_attribute_application_id) ||
4627: ' ' || p_attribute_code);
4628: FND_MSG_PUB.Add;
4633: p_count => p_msg_count,
4634: p_data => p_msg_data);
4635: WHEN FND_API.G_EXC_ERROR THEN
4636: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4637: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_CREATED');
4638: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4639: ' ' || p_region_code ||
4640: ' ' || to_char(p_attribute_application_id) ||
4641: ' ' || p_attribute_code);
4634: p_data => p_msg_data);
4635: WHEN FND_API.G_EXC_ERROR THEN
4636: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4637: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_CREATED');
4638: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4639: ' ' || p_region_code ||
4640: ' ' || to_char(p_attribute_application_id) ||
4641: ' ' || p_attribute_code);
4642: FND_MSG_PUB.Add;
4932: p_return_status => l_return_status,
4933: p_region_application_id => p_region_application_id,
4934: p_region_code => p_region_code) then
4935: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4936: FND_MESSAGE.SET_NAME('AK','AK_REGION_EXISTS');
4937: FND_MSG_PUB.Add;
4938: end if;
4939: -- dbms_output.put_line(G_PKG_NAME || 'Error - Row already exists');
4940: raise FND_API.G_EXC_ERROR;
5315: p_return_status => l_return_status,
5316: p_region_application_id => p_region_application_id,
5317: p_region_code => p_region_code) then
5318: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5319: FND_MESSAGE.SET_NAME('AK','AK_INSERT_REGION_FAILED');
5320: FND_MSG_PUB.Add;
5321: end if;
5322: -- dbms_output.put_line(G_PKG_NAME || 'Error - First insert failed');
5323: raise FND_API.G_EXC_ERROR;
5359: -- /** commit the insert **/
5360: commit;
5361:
5362: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5363: FND_MESSAGE.SET_NAME('AK','AK_REGION_CREATED');
5364: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5365: ' ' || p_region_code);
5366: FND_MSG_PUB.Add;
5367: end if;
5360: commit;
5361:
5362: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5363: FND_MESSAGE.SET_NAME('AK','AK_REGION_CREATED');
5364: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5365: ' ' || p_region_code);
5366: FND_MSG_PUB.Add;
5367: end if;
5368:
5376:
5377: EXCEPTION
5378: WHEN VALUE_ERROR THEN
5379: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5380: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
5381: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5382: ' ' || p_region_code);
5383: FND_MSG_PUB.Add;
5384: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5377: EXCEPTION
5378: WHEN VALUE_ERROR THEN
5379: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5380: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
5381: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5382: ' ' || p_region_code);
5383: FND_MSG_PUB.Add;
5384: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5385: SUBSTR (SQLERRM, 1, 240));
5391: p_count => p_msg_count,
5392: p_data => p_msg_data);
5393: WHEN FND_API.G_EXC_ERROR THEN
5394: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5395: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_CREATED');
5396: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5397: ' ' || p_region_code);
5398: FND_MSG_PUB.Add;
5399: end if;
5392: p_data => p_msg_data);
5393: WHEN FND_API.G_EXC_ERROR THEN
5394: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5395: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_CREATED');
5396: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5397: ' ' || p_region_code);
5398: FND_MSG_PUB.Add;
5399: end if;
5400: p_return_status := FND_API.G_RET_STS_ERROR;
5561: p_region_application_id => p_region_application_id,
5562: p_region_code => p_region_code,
5563: p_graph_number => p_graph_number) then
5564: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5565: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
5566: FND_MSG_PUB.Add;
5567: end if;
5568: raise FND_API.G_EXC_ERROR;
5569: end if;
5581: l_attribute_code;
5582: if l_get_graph_column_csr%found then
5583: close l_get_graph_column_csr;
5584: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5585: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_RI');
5586: FND_MSG_PUB.Add;
5587: end if;
5588: raise FND_API.G_EXC_ERROR;
5589: end if;
5631: and graph_number = p_graph_number;
5632:
5633: if (sql%notfound) then
5634: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5635: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
5636: FND_MSG_PUB.Add;
5637: end if;
5638: raise FND_API.G_EXC_ERROR;
5639: end if;
5644: and graph_number = p_graph_number;
5645:
5646: if (sql%notfound) then
5647: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5648: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
5649: FND_MSG_PUB.Add;
5650: end if;
5651: raise FND_API.G_EXC_ERROR;
5652: end if;
5654: --
5655: -- Load success message
5656: --
5657: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
5658: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DELETED');
5659: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5660: ' ' || p_region_code ||
5661: ' ' || p_graph_number);
5662: FND_MSG_PUB.Add;
5655: -- Load success message
5656: --
5657: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
5658: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DELETED');
5659: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5660: ' ' || p_region_code ||
5661: ' ' || p_graph_number);
5662: FND_MSG_PUB.Add;
5663: end if;
5670:
5671: EXCEPTION
5672: WHEN FND_API.G_EXC_ERROR THEN
5673: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5674: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_NOT_DELETED');
5675: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5676: ' ' || p_region_code ||
5677: ' ' || p_graph_number);
5678: FND_MSG_PUB.Add;
5671: EXCEPTION
5672: WHEN FND_API.G_EXC_ERROR THEN
5673: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5674: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_NOT_DELETED');
5675: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5676: ' ' || p_region_code ||
5677: ' ' || p_graph_number);
5678: FND_MSG_PUB.Add;
5679: end if;
5803: p_region_code => p_region_code,
5804: p_attribute_application_id => p_attribute_application_id,
5805: p_attribute_code => p_attribute_code) then
5806: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5807: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
5808: FND_MSG_PUB.Add;
5809: end if;
5810: raise FND_API.G_EXC_ERROR;
5811: end if;
5823: l_page_application_id, l_page_code;
5824: if l_get_page_region_item_csr%found then
5825: close l_get_page_region_item_csr;
5826: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5827: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_RI');
5828: FND_MSG_PUB.Add;
5829: end if;
5830: raise FND_API.G_EXC_ERROR;
5831: end if;
5859: and base_region_code = l_base_region_code;
5860:
5861: if (sql%notfound) then
5862: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5863: FND_MESSAGE.SET_NAME('AK','AK_LOV_REL_DOES_NOT_EXIST');
5864: FND_MSG_PUB.Add;
5865: end if;
5866: close l_get_lov_relations_csr;
5867: raise FND_API.G_EXC_ERROR;
5884: and category_id = l_category_id;
5885:
5886: if (sql%notfound) then
5887: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5888: FND_MESSAGE.SET_NAME('AK','AK_CAT_USAGE_DOES_NOT_EXIST');
5889: FND_MSG_PUB.Add;
5890: end if;
5891: close l_get_category_usages_csr;
5892: raise FND_API.G_EXC_ERROR;
5938: and attribute_code = p_attribute_code;
5939:
5940: if (sql%notfound) then
5941: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5942: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
5943: FND_MSG_PUB.Add;
5944: end if;
5945: raise FND_API.G_EXC_ERROR;
5946: end if;
5952: and attribute_code = p_attribute_code;
5953:
5954: if (sql%notfound) then
5955: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5956: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
5957: FND_MSG_PUB.Add;
5958: end if;
5959: raise FND_API.G_EXC_ERROR;
5960: end if;
5962: --
5963: -- Load success message
5964: --
5965: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
5966: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DELETED');
5967: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5968: ' ' || p_region_code ||
5969: ' ' || to_char(p_attribute_application_id) ||
5970: ' ' || p_attribute_code);
5963: -- Load success message
5964: --
5965: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
5966: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DELETED');
5967: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5968: ' ' || p_region_code ||
5969: ' ' || to_char(p_attribute_application_id) ||
5970: ' ' || p_attribute_code);
5971: FND_MSG_PUB.Add;
5979:
5980: EXCEPTION
5981: WHEN FND_API.G_EXC_ERROR THEN
5982: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5983: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_DELETED');
5984: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5985: ' ' || p_region_code ||
5986: ' ' || to_char(p_attribute_application_id) ||
5987: ' ' || p_attribute_code);
5980: EXCEPTION
5981: WHEN FND_API.G_EXC_ERROR THEN
5982: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5983: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_DELETED');
5984: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5985: ' ' || p_region_code ||
5986: ' ' || to_char(p_attribute_application_id) ||
5987: ' ' || p_attribute_code);
5988: FND_MSG_PUB.Add;
6108: p_return_status => l_return_status,
6109: p_region_application_id => p_region_application_id,
6110: p_region_code => p_region_code) then
6111: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6112: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
6113: FND_MSG_PUB.Add;
6114: end if;
6115: raise FND_API.G_EXC_ERROR;
6116: end if;
6126: fetch l_is_region_a_child_csr into l_region_code, l_region_application_id;
6127: if l_is_region_a_child_csr%found then
6128: close l_is_region_a_child_csr;
6129: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6130: FND_MESSAGE.SET_NAME('AK','AK_REGION_IS_CHILD');
6131: FND_MSG_PUB.Add;
6132: end if;
6133: raise FND_API.G_EXC_ERROR;
6134: end if;
6146: fetch l_get_items_csr into l_attribute_application_id, l_attribute_code;
6147: if l_get_items_csr%found then
6148: close l_get_items_csr;
6149: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6150: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_RI');
6151: FND_MSG_PUB.Add;
6152: end if;
6153: raise FND_API.G_EXC_ERROR;
6154: end if;
6161: l_page_application_id, l_page_code;
6162: if l_get_page_region_csr%found then
6163: close l_get_page_region_csr;
6164: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6165: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_PGREG');
6166: FND_MSG_PUB.Add;
6167: end if;
6168: raise FND_API.G_EXC_ERROR;
6169: end if;
6177: l_value_varchar2, l_value_date, l_value_number;
6178: if l_get_navigations_csr%found then
6179: close l_get_navigations_csr;
6180: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6181: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_NAV');
6182: FND_MSG_PUB.Add;
6183: end if;
6184: raise FND_API.G_EXC_ERROR;
6185: end if;
6284: and region_code = p_region_code;
6285:
6286: if (sql%notfound) then
6287: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6288: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
6289: FND_MSG_PUB.Add;
6290: end if;
6291: raise FND_API.G_EXC_ERROR;
6292: end if;
6296: and region_code = p_region_code;
6297:
6298: if (sql%notfound) then
6299: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6300: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
6301: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_REGION',TRUE);
6302: FND_MSG_PUB.Add;
6303: end if;
6304: raise FND_API.G_EXC_ERROR;
6297:
6298: if (sql%notfound) then
6299: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6300: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
6301: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_REGION',TRUE);
6302: FND_MSG_PUB.Add;
6303: end if;
6304: raise FND_API.G_EXC_ERROR;
6305: end if;
6307: --
6308: -- Load success message
6309: --
6310: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
6311: FND_MESSAGE.SET_NAME('AK','AK_REGION_DELETED');
6312: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6313: ' ' || p_region_code);
6314: FND_MSG_PUB.Add;
6315: end if;
6308: -- Load success message
6309: --
6310: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
6311: FND_MESSAGE.SET_NAME('AK','AK_REGION_DELETED');
6312: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6313: ' ' || p_region_code);
6314: FND_MSG_PUB.Add;
6315: end if;
6316: end if; -- region exists
6323:
6324: EXCEPTION
6325: WHEN FND_API.G_EXC_ERROR THEN
6326: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6327: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_DELETED');
6328: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6329: ' ' || p_region_code);
6330: FND_MSG_PUB.Add;
6331: end if;
6324: EXCEPTION
6325: WHEN FND_API.G_EXC_ERROR THEN
6326: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6327: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_DELETED');
6328: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6329: ' ' || p_region_code);
6330: FND_MSG_PUB.Add;
6331: end if;
6332: p_return_status := FND_API.G_RET_STS_ERROR;
6493: -- - a list of region_application_id and region_code in p_object_PK_tbl
6494: if (p_application_id = FND_API.G_MISS_NUM) then
6495: if (p_region_PK_tbl.count = 0) then
6496: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6497: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
6498: FND_MSG_PUB.Add;
6499: end if;
6500: raise FND_API.G_EXC_ERROR;
6501: end if;
6503: if (p_region_PK_tbl.count > 0) then
6504: -- both application ID and a list of regions to be extracted are
6505: -- given, issue a warning that we will ignore the application ID
6506: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6507: FND_MESSAGE.SET_NAME('AK','AK_APPL_ID_IGNORED');
6508: FND_MSG_PUB.Add;
6509: end if;
6510: end if;
6511: end if;
6719:
6720: EXCEPTION
6721: WHEN VALUE_ERROR THEN
6722: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6723: FND_MESSAGE.SET_NAME('AK','AK_REGION_PK_VALUE_ERROR');
6724: FND_MSG_PUB.Add;
6725: end if;
6726: --dbms_output.put_line('Value error occurred - check your region list.');
6727: p_return_status := FND_API.G_RET_STS_ERROR;
7135: open l_get_row_csr;
7136: fetch l_get_row_csr into l_graphs_rec;
7137: if (l_get_row_csr%notfound) then
7138: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
7139: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
7140: FND_MSG_PUB.Add;
7141: end if;
7142: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
7143: close l_get_row_csr;
7149: open l_get_tl_row_csr(l_lang);
7150: fetch l_get_tl_row_csr into l_graphs_tl_rec;
7151: if (l_get_tl_row_csr%notfound) then
7152: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
7153: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
7154: FND_MSG_PUB.Add;
7155: end if;
7156: -- dbms_output.put_line(l_api_name || 'Error - TL Row does not exist');
7157: close l_get_tl_row_csr;
7244: and REGION_CODE = p_region_code
7245: and GRAPH_NUMBER = p_graph_number;
7246: if (sql%notfound) then
7247: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7248: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_UPDATE_FAILED');
7249: FND_MSG_PUB.Add;
7250: end if;
7251: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');
7252: raise FND_API.G_EXC_ERROR;
7264: and GRAPH_NUMBER = p_graph_number
7265: and l_lang in (LANGUAGE, SOURCE_LANG);
7266: if (sql%notfound) then
7267: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7268: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_UPDATE_FAILED');
7269: FND_MSG_PUB.Add;
7270: end if;
7271: --dbms_output.put_line(l_api_name || 'TL Row does not exist during update');
7272: raise FND_API.G_EXC_ERROR;
7275: -- ** commit the update **
7276: commit;
7277:
7278: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
7279: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_UPDATED');
7280: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
7281: ' ' || p_region_code ||
7282: ' ' || p_graph_number);
7283: FND_MSG_PUB.Add;
7276: commit;
7277:
7278: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
7279: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_UPDATED');
7280: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
7281: ' ' || p_region_code ||
7282: ' ' || p_graph_number);
7283: FND_MSG_PUB.Add;
7284: end if;
7291:
7292: EXCEPTION
7293: WHEN VALUE_ERROR THEN
7294: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7295: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_VALUE_ERROR');
7296: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
7297: ' ' || p_region_code ||
7298: ' ' || p_graph_number);
7299: FND_MSG_PUB.Add;
7292: EXCEPTION
7293: WHEN VALUE_ERROR THEN
7294: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7295: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_VALUE_ERROR');
7296: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
7297: ' ' || p_region_code ||
7298: ' ' || p_graph_number);
7299: FND_MSG_PUB.Add;
7300: end if;
7304: p_count => p_msg_count,
7305: p_data => p_msg_data);
7306: WHEN FND_API.G_EXC_ERROR THEN
7307: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7308: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_NOT_UPDATED');
7309: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
7310: ' ' || p_region_code ||
7311: ' ' || p_graph_number);
7312: FND_MSG_PUB.Add;
7305: p_data => p_msg_data);
7306: WHEN FND_API.G_EXC_ERROR THEN
7307: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7308: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_NOT_UPDATED');
7309: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
7310: ' ' || p_region_code ||
7311: ' ' || p_graph_number);
7312: FND_MSG_PUB.Add;
7313: end if;
7507: open l_get_row_csr;
7508: fetch l_get_row_csr into l_items_rec;
7509: if (l_get_row_csr%notfound) then
7510: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
7511: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
7512: FND_MSG_PUB.Add;
7513: end if;
7514: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
7515: close l_get_row_csr;
7521: open l_get_tl_row_csr(l_lang);
7522: fetch l_get_tl_row_csr into l_items_tl_rec;
7523: if (l_get_tl_row_csr%notfound) then
7524: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
7525: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
7526: FND_MSG_PUB.Add;
7527: end if;
7528: -- dbms_output.put_line(l_api_name || 'Error - TL Row does not exist');
7529: close l_get_tl_row_csr;
8175: and attribute_application_id = p_attribute_application_id
8176: and attribute_code = p_attribute_code;
8177: if (sql%notfound) then
8178: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8179: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_UPDATE_FAILED');
8180: FND_MSG_PUB.Add;
8181: end if;
8182: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');
8183: raise FND_API.G_EXC_ERROR;
8197: and attribute_code = p_attribute_code
8198: and l_lang in (LANGUAGE, SOURCE_LANG);
8199: if (sql%notfound) then
8200: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8201: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_UPDATE_FAILED');
8202: FND_MSG_PUB.Add;
8203: end if;
8204: --dbms_output.put_line(l_api_name || 'TL Row does not exist during update');
8205: raise FND_API.G_EXC_ERROR;
8208: -- /** commit the update **/
8209: commit;
8210:
8211: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
8212: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_UPDATED');
8213: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8214: ' ' || p_region_code ||
8215: ' ' || to_char(p_attribute_application_id) ||
8216: ' ' || p_attribute_code);
8209: commit;
8210:
8211: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
8212: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_UPDATED');
8213: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8214: ' ' || p_region_code ||
8215: ' ' || to_char(p_attribute_application_id) ||
8216: ' ' || p_attribute_code);
8217: FND_MSG_PUB.Add;
8229:
8230: EXCEPTION
8231: WHEN VALUE_ERROR THEN
8232: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8233: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_VALUE_ERROR');
8234: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8235: ' ' || p_region_code ||
8236: ' ' || to_char(p_attribute_application_id) ||
8237: ' ' || p_attribute_code);
8230: EXCEPTION
8231: WHEN VALUE_ERROR THEN
8232: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8233: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_VALUE_ERROR');
8234: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8235: ' ' || p_region_code ||
8236: ' ' || to_char(p_attribute_application_id) ||
8237: ' ' || p_attribute_code);
8238: FND_MSG_PUB.Add;
8243: p_count => p_msg_count,
8244: p_data => p_msg_data);
8245: WHEN FND_API.G_EXC_ERROR THEN
8246: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8247: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_UPDATED');
8248: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8249: ' ' || p_region_code ||
8250: ' ' || to_char(p_attribute_application_id) ||
8251: ' ' || p_attribute_code);
8244: p_data => p_msg_data);
8245: WHEN FND_API.G_EXC_ERROR THEN
8246: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8247: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_UPDATED');
8248: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8249: ' ' || p_region_code ||
8250: ' ' || to_char(p_attribute_application_id) ||
8251: ' ' || p_attribute_code);
8252: FND_MSG_PUB.Add;
8261: rollback to start_update_item;
8262: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8263: SUBSTR (SQLERRM, 1, 240) );
8264: FND_MSG_PUB.Add;
8265: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_UPDATED');
8266: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8267: ' ' || p_region_code ||
8268: ' ' || to_char(p_attribute_application_id) ||
8269: ' ' || p_attribute_code);
8262: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8263: SUBSTR (SQLERRM, 1, 240) );
8264: FND_MSG_PUB.Add;
8265: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_UPDATED');
8266: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8267: ' ' || p_region_code ||
8268: ' ' || to_char(p_attribute_application_id) ||
8269: ' ' || p_attribute_code);
8270: FND_MSG_PUB.Add;
8411: open l_get_row_csr;
8412: fetch l_get_row_csr into l_regions_rec;
8413: if (l_get_row_csr%notfound) then
8414: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
8415: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
8416: FND_MSG_PUB.Add;
8417: end if;
8418: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
8419: close l_get_row_csr;
8425: open l_get_tl_row_csr(l_lang);
8426: fetch l_get_tl_row_csr into l_regions_tl_rec;
8427: if (l_get_tl_row_csr%notfound) then
8428: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
8429: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
8430: FND_MSG_PUB.Add;
8431: end if;
8432: --dbms_output.put_line(l_api_name || 'Error - TL Row does not exist');
8433: close l_get_tl_row_csr;
8753: where REGION_APPLICATION_ID = p_region_application_id
8754: and REGION_CODE = p_region_code;
8755: if (sql%notfound) then
8756: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8757: FND_MESSAGE.SET_NAME('AK','AK_REGION_UPDATE_FAILED');
8758: FND_MSG_PUB.Add;
8759: end if;
8760: raise FND_API.G_EXC_ERROR;
8761: end if;
8772: and l_lang in (LANGUAGE, SOURCE_LANG);
8773:
8774: if (sql%notfound) then
8775: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8776: FND_MESSAGE.SET_NAME('AK','AK_REGION_UPDATE_FAILED');
8777: FND_MSG_PUB.Add;
8778: end if;
8779: raise FND_API.G_EXC_ERROR;
8780: end if;
8782: -- /** commit the update **/
8783: commit;
8784:
8785: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
8786: FND_MESSAGE.SET_NAME('AK','AK_REGION_UPDATED');
8787: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8788: ' ' || p_region_code);
8789: FND_MSG_PUB.Add;
8790: end if;
8783: commit;
8784:
8785: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
8786: FND_MESSAGE.SET_NAME('AK','AK_REGION_UPDATED');
8787: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8788: ' ' || p_region_code);
8789: FND_MSG_PUB.Add;
8790: end if;
8791:
8801:
8802: EXCEPTION
8803: WHEN VALUE_ERROR THEN
8804: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8805: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
8806: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8807: ' ' || p_region_code);
8808: FND_MSG_PUB.Add;
8809: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8802: EXCEPTION
8803: WHEN VALUE_ERROR THEN
8804: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8805: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
8806: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8807: ' ' || p_region_code);
8808: FND_MSG_PUB.Add;
8809: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8810: SUBSTR (SQLERRM, 1, 240));
8817: p_count => p_msg_count,
8818: p_data => p_msg_data);
8819: WHEN FND_API.G_EXC_ERROR THEN
8820: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8821: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_UPDATED');
8822: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8823: ' ' || p_region_code);
8824: FND_MSG_PUB.Add;
8825: end if;
8818: p_data => p_msg_data);
8819: WHEN FND_API.G_EXC_ERROR THEN
8820: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8821: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_UPDATED');
8822: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8823: ' ' || p_region_code);
8824: FND_MSG_PUB.Add;
8825: end if;
8826: p_return_status := FND_API.G_RET_STS_ERROR;