[Home] [Help]
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;
4543: p_region_code => p_region_code,
4544: p_attribute_application_id => p_attribute_application_id,
4545: p_attribute_code => p_attribute_code) then
4546: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4547: FND_MESSAGE.SET_NAME('AK','AK_INSERT_REG_ITEM_FAILED');
4548: FND_MSG_PUB.Add;
4549: end if;
4550: --dbms_output.put_line(l_api_name || 'Error - row already exists');
4551: raise FND_API.G_EXC_ERROR;
4595: -- /** commit the insert **/
4596: commit;
4597:
4598: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4599: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_CREATED');
4600: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_REGION_ITEM',TRUE);
4601: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4602: ' ' || p_region_code ||
4603: ' ' || to_char(p_attribute_application_id) ||
4596: commit;
4597:
4598: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4599: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_CREATED');
4600: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_REGION_ITEM',TRUE);
4601: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4602: ' ' || p_region_code ||
4603: ' ' || to_char(p_attribute_application_id) ||
4604: ' ' || p_attribute_code);
4597:
4598: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4599: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_CREATED');
4600: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_REGION_ITEM',TRUE);
4601: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4602: ' ' || p_region_code ||
4603: ' ' || to_char(p_attribute_application_id) ||
4604: ' ' || p_attribute_code);
4605: FND_MSG_PUB.Add;
4613:
4614: EXCEPTION
4615: WHEN VALUE_ERROR THEN
4616: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4617: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_VALUE_ERROR');
4618: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4619: ' ' || p_region_code ||
4620: ' ' || to_char(p_attribute_application_id) ||
4621: ' ' || p_attribute_code);
4614: EXCEPTION
4615: WHEN VALUE_ERROR THEN
4616: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4617: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_VALUE_ERROR');
4618: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4619: ' ' || p_region_code ||
4620: ' ' || to_char(p_attribute_application_id) ||
4621: ' ' || p_attribute_code);
4622: FND_MSG_PUB.Add;
4627: p_count => p_msg_count,
4628: p_data => p_msg_data);
4629: WHEN FND_API.G_EXC_ERROR THEN
4630: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4631: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_CREATED');
4632: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4633: ' ' || p_region_code ||
4634: ' ' || to_char(p_attribute_application_id) ||
4635: ' ' || p_attribute_code);
4628: p_data => p_msg_data);
4629: WHEN FND_API.G_EXC_ERROR THEN
4630: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4631: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_CREATED');
4632: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4633: ' ' || p_region_code ||
4634: ' ' || to_char(p_attribute_application_id) ||
4635: ' ' || p_attribute_code);
4636: FND_MSG_PUB.Add;
4926: p_return_status => l_return_status,
4927: p_region_application_id => p_region_application_id,
4928: p_region_code => p_region_code) then
4929: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4930: FND_MESSAGE.SET_NAME('AK','AK_REGION_EXISTS');
4931: FND_MSG_PUB.Add;
4932: end if;
4933: -- dbms_output.put_line(G_PKG_NAME || 'Error - Row already exists');
4934: raise FND_API.G_EXC_ERROR;
5306: p_return_status => l_return_status,
5307: p_region_application_id => p_region_application_id,
5308: p_region_code => p_region_code) then
5309: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5310: FND_MESSAGE.SET_NAME('AK','AK_INSERT_REGION_FAILED');
5311: FND_MSG_PUB.Add;
5312: end if;
5313: -- dbms_output.put_line(G_PKG_NAME || 'Error - First insert failed');
5314: raise FND_API.G_EXC_ERROR;
5350: -- /** commit the insert **/
5351: commit;
5352:
5353: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5354: FND_MESSAGE.SET_NAME('AK','AK_REGION_CREATED');
5355: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5356: ' ' || p_region_code);
5357: FND_MSG_PUB.Add;
5358: end if;
5351: commit;
5352:
5353: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5354: FND_MESSAGE.SET_NAME('AK','AK_REGION_CREATED');
5355: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5356: ' ' || p_region_code);
5357: FND_MSG_PUB.Add;
5358: end if;
5359:
5365:
5366: EXCEPTION
5367: WHEN VALUE_ERROR THEN
5368: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5369: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
5370: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5371: ' ' || p_region_code);
5372: FND_MSG_PUB.Add;
5373: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5366: EXCEPTION
5367: WHEN VALUE_ERROR THEN
5368: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5369: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
5370: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5371: ' ' || p_region_code);
5372: FND_MSG_PUB.Add;
5373: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5374: SUBSTR (SQLERRM, 1, 240));
5380: p_count => p_msg_count,
5381: p_data => p_msg_data);
5382: WHEN FND_API.G_EXC_ERROR THEN
5383: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5384: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_CREATED');
5385: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5386: ' ' || p_region_code);
5387: FND_MSG_PUB.Add;
5388: end if;
5381: p_data => p_msg_data);
5382: WHEN FND_API.G_EXC_ERROR THEN
5383: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5384: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_CREATED');
5385: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5386: ' ' || p_region_code);
5387: FND_MSG_PUB.Add;
5388: end if;
5389: p_return_status := FND_API.G_RET_STS_ERROR;
5550: p_region_application_id => p_region_application_id,
5551: p_region_code => p_region_code,
5552: p_graph_number => p_graph_number) then
5553: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5554: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
5555: FND_MSG_PUB.Add;
5556: end if;
5557: raise FND_API.G_EXC_ERROR;
5558: end if;
5570: l_attribute_code;
5571: if l_get_graph_column_csr%found then
5572: close l_get_graph_column_csr;
5573: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5574: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_RI');
5575: FND_MSG_PUB.Add;
5576: end if;
5577: raise FND_API.G_EXC_ERROR;
5578: end if;
5620: and graph_number = p_graph_number;
5621:
5622: if (sql%notfound) then
5623: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5624: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
5625: FND_MSG_PUB.Add;
5626: end if;
5627: raise FND_API.G_EXC_ERROR;
5628: end if;
5633: and graph_number = p_graph_number;
5634:
5635: if (sql%notfound) then
5636: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5637: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
5638: FND_MSG_PUB.Add;
5639: end if;
5640: raise FND_API.G_EXC_ERROR;
5641: end if;
5643: --
5644: -- Load success message
5645: --
5646: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
5647: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DELETED');
5648: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5649: ' ' || p_region_code ||
5650: ' ' || p_graph_number);
5651: FND_MSG_PUB.Add;
5644: -- Load success message
5645: --
5646: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
5647: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DELETED');
5648: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5649: ' ' || p_region_code ||
5650: ' ' || p_graph_number);
5651: FND_MSG_PUB.Add;
5652: end if;
5659:
5660: EXCEPTION
5661: WHEN FND_API.G_EXC_ERROR THEN
5662: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5663: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_NOT_DELETED');
5664: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5665: ' ' || p_region_code ||
5666: ' ' || p_graph_number);
5667: FND_MSG_PUB.Add;
5660: EXCEPTION
5661: WHEN FND_API.G_EXC_ERROR THEN
5662: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5663: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_NOT_DELETED');
5664: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5665: ' ' || p_region_code ||
5666: ' ' || p_graph_number);
5667: FND_MSG_PUB.Add;
5668: end if;
5792: p_region_code => p_region_code,
5793: p_attribute_application_id => p_attribute_application_id,
5794: p_attribute_code => p_attribute_code) then
5795: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5796: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
5797: FND_MSG_PUB.Add;
5798: end if;
5799: raise FND_API.G_EXC_ERROR;
5800: end if;
5812: l_page_application_id, l_page_code;
5813: if l_get_page_region_item_csr%found then
5814: close l_get_page_region_item_csr;
5815: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5816: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_RI');
5817: FND_MSG_PUB.Add;
5818: end if;
5819: raise FND_API.G_EXC_ERROR;
5820: end if;
5848: and base_region_code = l_base_region_code;
5849:
5850: if (sql%notfound) then
5851: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5852: FND_MESSAGE.SET_NAME('AK','AK_LOV_REL_DOES_NOT_EXIST');
5853: FND_MSG_PUB.Add;
5854: end if;
5855: close l_get_lov_relations_csr;
5856: raise FND_API.G_EXC_ERROR;
5873: and category_id = l_category_id;
5874:
5875: if (sql%notfound) then
5876: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5877: FND_MESSAGE.SET_NAME('AK','AK_CAT_USAGE_DOES_NOT_EXIST');
5878: FND_MSG_PUB.Add;
5879: end if;
5880: close l_get_category_usages_csr;
5881: raise FND_API.G_EXC_ERROR;
5927: and attribute_code = p_attribute_code;
5928:
5929: if (sql%notfound) then
5930: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5931: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
5932: FND_MSG_PUB.Add;
5933: end if;
5934: raise FND_API.G_EXC_ERROR;
5935: end if;
5941: and attribute_code = p_attribute_code;
5942:
5943: if (sql%notfound) then
5944: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5945: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
5946: FND_MSG_PUB.Add;
5947: end if;
5948: raise FND_API.G_EXC_ERROR;
5949: end if;
5951: --
5952: -- Load success message
5953: --
5954: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
5955: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DELETED');
5956: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5957: ' ' || p_region_code ||
5958: ' ' || to_char(p_attribute_application_id) ||
5959: ' ' || p_attribute_code);
5952: -- Load success message
5953: --
5954: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
5955: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DELETED');
5956: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5957: ' ' || p_region_code ||
5958: ' ' || to_char(p_attribute_application_id) ||
5959: ' ' || p_attribute_code);
5960: FND_MSG_PUB.Add;
5968:
5969: EXCEPTION
5970: WHEN FND_API.G_EXC_ERROR THEN
5971: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5972: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_DELETED');
5973: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5974: ' ' || p_region_code ||
5975: ' ' || to_char(p_attribute_application_id) ||
5976: ' ' || p_attribute_code);
5969: EXCEPTION
5970: WHEN FND_API.G_EXC_ERROR THEN
5971: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5972: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_DELETED');
5973: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5974: ' ' || p_region_code ||
5975: ' ' || to_char(p_attribute_application_id) ||
5976: ' ' || p_attribute_code);
5977: FND_MSG_PUB.Add;
6097: p_return_status => l_return_status,
6098: p_region_application_id => p_region_application_id,
6099: p_region_code => p_region_code) then
6100: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6101: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
6102: FND_MSG_PUB.Add;
6103: end if;
6104: raise FND_API.G_EXC_ERROR;
6105: end if;
6115: fetch l_is_region_a_child_csr into l_region_code, l_region_application_id;
6116: if l_is_region_a_child_csr%found then
6117: close l_is_region_a_child_csr;
6118: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6119: FND_MESSAGE.SET_NAME('AK','AK_REGION_IS_CHILD');
6120: FND_MSG_PUB.Add;
6121: end if;
6122: raise FND_API.G_EXC_ERROR;
6123: end if;
6135: fetch l_get_items_csr into l_attribute_application_id, l_attribute_code;
6136: if l_get_items_csr%found then
6137: close l_get_items_csr;
6138: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6139: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_RI');
6140: FND_MSG_PUB.Add;
6141: end if;
6142: raise FND_API.G_EXC_ERROR;
6143: end if;
6150: l_page_application_id, l_page_code;
6151: if l_get_page_region_csr%found then
6152: close l_get_page_region_csr;
6153: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6154: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_PGREG');
6155: FND_MSG_PUB.Add;
6156: end if;
6157: raise FND_API.G_EXC_ERROR;
6158: end if;
6166: l_value_varchar2, l_value_date, l_value_number;
6167: if l_get_navigations_csr%found then
6168: close l_get_navigations_csr;
6169: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6170: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_NAV');
6171: FND_MSG_PUB.Add;
6172: end if;
6173: raise FND_API.G_EXC_ERROR;
6174: end if;
6273: and region_code = p_region_code;
6274:
6275: if (sql%notfound) then
6276: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6277: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
6278: FND_MSG_PUB.Add;
6279: end if;
6280: raise FND_API.G_EXC_ERROR;
6281: end if;
6285: and region_code = p_region_code;
6286:
6287: if (sql%notfound) then
6288: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6289: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
6290: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_REGION',TRUE);
6291: FND_MSG_PUB.Add;
6292: end if;
6293: raise FND_API.G_EXC_ERROR;
6286:
6287: if (sql%notfound) then
6288: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6289: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
6290: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_REGION',TRUE);
6291: FND_MSG_PUB.Add;
6292: end if;
6293: raise FND_API.G_EXC_ERROR;
6294: end if;
6296: --
6297: -- Load success message
6298: --
6299: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
6300: FND_MESSAGE.SET_NAME('AK','AK_REGION_DELETED');
6301: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6302: ' ' || p_region_code);
6303: FND_MSG_PUB.Add;
6304: end if;
6297: -- Load success message
6298: --
6299: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
6300: FND_MESSAGE.SET_NAME('AK','AK_REGION_DELETED');
6301: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6302: ' ' || p_region_code);
6303: FND_MSG_PUB.Add;
6304: end if;
6305: end if; -- region exists
6312:
6313: EXCEPTION
6314: WHEN FND_API.G_EXC_ERROR THEN
6315: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6316: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_DELETED');
6317: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6318: ' ' || p_region_code);
6319: FND_MSG_PUB.Add;
6320: end if;
6313: EXCEPTION
6314: WHEN FND_API.G_EXC_ERROR THEN
6315: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6316: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_DELETED');
6317: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6318: ' ' || p_region_code);
6319: FND_MSG_PUB.Add;
6320: end if;
6321: p_return_status := FND_API.G_RET_STS_ERROR;
6482: -- - a list of region_application_id and region_code in p_object_PK_tbl
6483: if (p_application_id = FND_API.G_MISS_NUM) then
6484: if (p_region_PK_tbl.count = 0) then
6485: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6486: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
6487: FND_MSG_PUB.Add;
6488: end if;
6489: raise FND_API.G_EXC_ERROR;
6490: end if;
6492: if (p_region_PK_tbl.count > 0) then
6493: -- both application ID and a list of regions to be extracted are
6494: -- given, issue a warning that we will ignore the application ID
6495: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6496: FND_MESSAGE.SET_NAME('AK','AK_APPL_ID_IGNORED');
6497: FND_MSG_PUB.Add;
6498: end if;
6499: end if;
6500: end if;
6708:
6709: EXCEPTION
6710: WHEN VALUE_ERROR THEN
6711: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6712: FND_MESSAGE.SET_NAME('AK','AK_REGION_PK_VALUE_ERROR');
6713: FND_MSG_PUB.Add;
6714: end if;
6715: --dbms_output.put_line('Value error occurred - check your region list.');
6716: p_return_status := FND_API.G_RET_STS_ERROR;
7124: open l_get_row_csr;
7125: fetch l_get_row_csr into l_graphs_rec;
7126: if (l_get_row_csr%notfound) then
7127: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
7128: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
7129: FND_MSG_PUB.Add;
7130: end if;
7131: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
7132: close l_get_row_csr;
7138: open l_get_tl_row_csr(l_lang);
7139: fetch l_get_tl_row_csr into l_graphs_tl_rec;
7140: if (l_get_tl_row_csr%notfound) then
7141: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
7142: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
7143: FND_MSG_PUB.Add;
7144: end if;
7145: -- dbms_output.put_line(l_api_name || 'Error - TL Row does not exist');
7146: close l_get_tl_row_csr;
7233: and REGION_CODE = p_region_code
7234: and GRAPH_NUMBER = p_graph_number;
7235: if (sql%notfound) then
7236: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7237: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_UPDATE_FAILED');
7238: FND_MSG_PUB.Add;
7239: end if;
7240: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');
7241: raise FND_API.G_EXC_ERROR;
7253: and GRAPH_NUMBER = p_graph_number
7254: and l_lang in (LANGUAGE, SOURCE_LANG);
7255: if (sql%notfound) then
7256: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7257: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_UPDATE_FAILED');
7258: FND_MSG_PUB.Add;
7259: end if;
7260: --dbms_output.put_line(l_api_name || 'TL Row does not exist during update');
7261: raise FND_API.G_EXC_ERROR;
7264: -- ** commit the update **
7265: commit;
7266:
7267: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
7268: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_UPDATED');
7269: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
7270: ' ' || p_region_code ||
7271: ' ' || p_graph_number);
7272: FND_MSG_PUB.Add;
7265: commit;
7266:
7267: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
7268: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_UPDATED');
7269: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
7270: ' ' || p_region_code ||
7271: ' ' || p_graph_number);
7272: FND_MSG_PUB.Add;
7273: end if;
7280:
7281: EXCEPTION
7282: WHEN VALUE_ERROR THEN
7283: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7284: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_VALUE_ERROR');
7285: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
7286: ' ' || p_region_code ||
7287: ' ' || p_graph_number);
7288: FND_MSG_PUB.Add;
7281: EXCEPTION
7282: WHEN VALUE_ERROR THEN
7283: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7284: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_VALUE_ERROR');
7285: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
7286: ' ' || p_region_code ||
7287: ' ' || p_graph_number);
7288: FND_MSG_PUB.Add;
7289: end if;
7293: p_count => p_msg_count,
7294: p_data => p_msg_data);
7295: WHEN FND_API.G_EXC_ERROR THEN
7296: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7297: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_NOT_UPDATED');
7298: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
7299: ' ' || p_region_code ||
7300: ' ' || p_graph_number);
7301: FND_MSG_PUB.Add;
7294: p_data => p_msg_data);
7295: WHEN FND_API.G_EXC_ERROR THEN
7296: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7297: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_NOT_UPDATED');
7298: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
7299: ' ' || p_region_code ||
7300: ' ' || p_graph_number);
7301: FND_MSG_PUB.Add;
7302: end if;
7496: open l_get_row_csr;
7497: fetch l_get_row_csr into l_items_rec;
7498: if (l_get_row_csr%notfound) then
7499: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
7500: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
7501: FND_MSG_PUB.Add;
7502: end if;
7503: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
7504: close l_get_row_csr;
7510: open l_get_tl_row_csr(l_lang);
7511: fetch l_get_tl_row_csr into l_items_tl_rec;
7512: if (l_get_tl_row_csr%notfound) then
7513: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
7514: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
7515: FND_MSG_PUB.Add;
7516: end if;
7517: -- dbms_output.put_line(l_api_name || 'Error - TL Row does not exist');
7518: close l_get_tl_row_csr;
8161: and attribute_application_id = p_attribute_application_id
8162: and attribute_code = p_attribute_code;
8163: if (sql%notfound) then
8164: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8165: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_UPDATE_FAILED');
8166: FND_MSG_PUB.Add;
8167: end if;
8168: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');
8169: raise FND_API.G_EXC_ERROR;
8183: and attribute_code = p_attribute_code
8184: and l_lang in (LANGUAGE, SOURCE_LANG);
8185: if (sql%notfound) then
8186: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8187: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_UPDATE_FAILED');
8188: FND_MSG_PUB.Add;
8189: end if;
8190: --dbms_output.put_line(l_api_name || 'TL Row does not exist during update');
8191: raise FND_API.G_EXC_ERROR;
8194: -- /** commit the update **/
8195: commit;
8196:
8197: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
8198: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_UPDATED');
8199: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8200: ' ' || p_region_code ||
8201: ' ' || to_char(p_attribute_application_id) ||
8202: ' ' || p_attribute_code);
8195: commit;
8196:
8197: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
8198: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_UPDATED');
8199: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8200: ' ' || p_region_code ||
8201: ' ' || to_char(p_attribute_application_id) ||
8202: ' ' || p_attribute_code);
8203: FND_MSG_PUB.Add;
8212:
8213: EXCEPTION
8214: WHEN VALUE_ERROR THEN
8215: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8216: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_VALUE_ERROR');
8217: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8218: ' ' || p_region_code ||
8219: ' ' || to_char(p_attribute_application_id) ||
8220: ' ' || p_attribute_code);
8213: EXCEPTION
8214: WHEN VALUE_ERROR THEN
8215: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8216: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_VALUE_ERROR');
8217: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8218: ' ' || p_region_code ||
8219: ' ' || to_char(p_attribute_application_id) ||
8220: ' ' || p_attribute_code);
8221: FND_MSG_PUB.Add;
8226: p_count => p_msg_count,
8227: p_data => p_msg_data);
8228: WHEN FND_API.G_EXC_ERROR THEN
8229: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8230: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_UPDATED');
8231: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8232: ' ' || p_region_code ||
8233: ' ' || to_char(p_attribute_application_id) ||
8234: ' ' || p_attribute_code);
8227: p_data => p_msg_data);
8228: WHEN FND_API.G_EXC_ERROR THEN
8229: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8230: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_UPDATED');
8231: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8232: ' ' || p_region_code ||
8233: ' ' || to_char(p_attribute_application_id) ||
8234: ' ' || p_attribute_code);
8235: FND_MSG_PUB.Add;
8244: rollback to start_update_item;
8245: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8246: SUBSTR (SQLERRM, 1, 240) );
8247: FND_MSG_PUB.Add;
8248: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_UPDATED');
8249: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8250: ' ' || p_region_code ||
8251: ' ' || to_char(p_attribute_application_id) ||
8252: ' ' || p_attribute_code);
8245: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8246: SUBSTR (SQLERRM, 1, 240) );
8247: FND_MSG_PUB.Add;
8248: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_UPDATED');
8249: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8250: ' ' || p_region_code ||
8251: ' ' || to_char(p_attribute_application_id) ||
8252: ' ' || p_attribute_code);
8253: FND_MSG_PUB.Add;
8394: open l_get_row_csr;
8395: fetch l_get_row_csr into l_regions_rec;
8396: if (l_get_row_csr%notfound) then
8397: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
8398: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
8399: FND_MSG_PUB.Add;
8400: end if;
8401: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
8402: close l_get_row_csr;
8408: open l_get_tl_row_csr(l_lang);
8409: fetch l_get_tl_row_csr into l_regions_tl_rec;
8410: if (l_get_tl_row_csr%notfound) then
8411: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
8412: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
8413: FND_MSG_PUB.Add;
8414: end if;
8415: --dbms_output.put_line(l_api_name || 'Error - TL Row does not exist');
8416: close l_get_tl_row_csr;
8733: where REGION_APPLICATION_ID = p_region_application_id
8734: and REGION_CODE = p_region_code;
8735: if (sql%notfound) then
8736: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8737: FND_MESSAGE.SET_NAME('AK','AK_REGION_UPDATE_FAILED');
8738: FND_MSG_PUB.Add;
8739: end if;
8740: raise FND_API.G_EXC_ERROR;
8741: end if;
8752: and l_lang in (LANGUAGE, SOURCE_LANG);
8753:
8754: if (sql%notfound) then
8755: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8756: FND_MESSAGE.SET_NAME('AK','AK_REGION_UPDATE_FAILED');
8757: FND_MSG_PUB.Add;
8758: end if;
8759: raise FND_API.G_EXC_ERROR;
8760: end if;
8762: -- /** commit the update **/
8763: commit;
8764:
8765: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
8766: FND_MESSAGE.SET_NAME('AK','AK_REGION_UPDATED');
8767: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8768: ' ' || p_region_code);
8769: FND_MSG_PUB.Add;
8770: end if;
8763: commit;
8764:
8765: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
8766: FND_MESSAGE.SET_NAME('AK','AK_REGION_UPDATED');
8767: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8768: ' ' || p_region_code);
8769: FND_MSG_PUB.Add;
8770: end if;
8771:
8778:
8779: EXCEPTION
8780: WHEN VALUE_ERROR THEN
8781: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8782: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
8783: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8784: ' ' || p_region_code);
8785: FND_MSG_PUB.Add;
8786: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8779: EXCEPTION
8780: WHEN VALUE_ERROR THEN
8781: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8782: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
8783: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8784: ' ' || p_region_code);
8785: FND_MSG_PUB.Add;
8786: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8787: SUBSTR (SQLERRM, 1, 240));
8794: p_count => p_msg_count,
8795: p_data => p_msg_data);
8796: WHEN FND_API.G_EXC_ERROR THEN
8797: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8798: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_UPDATED');
8799: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8800: ' ' || p_region_code);
8801: FND_MSG_PUB.Add;
8802: end if;
8795: p_data => p_msg_data);
8796: WHEN FND_API.G_EXC_ERROR THEN
8797: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8798: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_UPDATED');
8799: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8800: ' ' || p_region_code);
8801: FND_MSG_PUB.Add;
8802: end if;
8803: p_return_status := FND_API.G_RET_STS_ERROR;