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

APPS.AK_REGION_PVT dependencies on FND_MSG_PUB

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

81: --** check that key columns are not null and not missing **
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;

Line 88: FND_MSG_PUB.Add;

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

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

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;

Line 98: FND_MSG_PUB.Add;

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

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

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;

Line 108: FND_MSG_PUB.Add;

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:
112: -- - Check that the parent region exists and retrieve the

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

114: open l_check_region_csr;
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;

Line 122: FND_MSG_PUB.Add;

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

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

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;

Line 132: FND_MSG_PUB.Add;

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;
135: close l_check_region_csr;
136:

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

140: if ((p_graph_style is null) or
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;

Line 147: FND_MSG_PUB.Add;

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:
151: if ((p_display_flag is null) or

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

151: if ((p_display_flag is null) or
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;

Line 158: FND_MSG_PUB.Add;

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:
162: -- === Validate columns ===

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

165: --
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;

Line 172: FND_MSG_PUB.Add;

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;
176:

Line 188: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

184: p_return_status := FND_API.G_RET_STS_ERROR;
185: return FALSE;
186: WHEN OTHERS THEN
187: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
189: SUBSTR (SQLERRM, 1, 240) );
190: FND_MSG_PUB.Add;
191: return FALSE;
192:

Line 190: FND_MSG_PUB.Add;

186: WHEN OTHERS THEN
187: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
189: SUBSTR (SQLERRM, 1, 240) );
190: FND_MSG_PUB.Add;
191: return FALSE;
192:
193: end VALIDATE_GRAPH;
194: */

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

355: --** check that key columns are not null and not missing **
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;

Line 362: FND_MSG_PUB.Add;

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

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

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;

Line 372: FND_MSG_PUB.Add;

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

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

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;

Line 382: FND_MSG_PUB.Add;

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

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

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;

Line 392: FND_MSG_PUB.Add;

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:
396: -- - Check that the parent region exists and retrieve the

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

398: open l_check_region_csr;
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;

Line 406: FND_MSG_PUB.Add;

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!');
409: end if;
410: close l_check_region_csr;

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

419: p_database_object_name => l_database_object_name,
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);

Line 428: FND_MSG_PUB.Add;

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;
430: RAISE FND_API.G_EXC_ERROR;
431: --dbms_output.put_line('Object Attribute referenced does not exist!');
432: end if;

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

436: p_return_status => l_return_status,
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;

Line 444: FND_MSG_PUB.Add;

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;
447: -- dbms_output.put_line('Attribute referenced does not exist!');
448: end if;

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

454: if ((p_display_sequence is null) or
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;

Line 461: FND_MSG_PUB.Add;

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:
465: if ((p_node_display_flag is null) or

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

465: if ((p_node_display_flag is null) or
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;

Line 472: FND_MSG_PUB.Add;

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:
476: if ((p_node_query_flag is null) or

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

476: if ((p_node_query_flag is null) or
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;

Line 483: FND_MSG_PUB.Add;

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:
487: if ((p_attribute_label_length is null) or

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

487: if ((p_attribute_label_length is null) or
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;

Line 494: FND_MSG_PUB.Add;

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:
498: if ((p_display_value_length is null) or

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

498: if ((p_display_value_length is null) or
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;

Line 505: FND_MSG_PUB.Add;

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:
509: if ((p_bold is null) or

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

509: if ((p_bold is null) or
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;

Line 516: FND_MSG_PUB.Add;

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:
520: if ((p_italic is null) or

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

520: if ((p_italic is null) or
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;

Line 527: FND_MSG_PUB.Add;

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:
531: if ((p_vertical_alignment is null) or

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

531: if ((p_vertical_alignment is null) or
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;

Line 538: FND_MSG_PUB.Add;

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:
542: if ((p_horizontal_alignment is null) or

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

542: if ((p_horizontal_alignment is null) or
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;

Line 549: FND_MSG_PUB.Add;

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:
553: if ((p_item_style is null) or

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

553: if ((p_item_style is null) or
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;

Line 560: FND_MSG_PUB.Add;

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:
564: if ((p_object_attribute_flag is null) or

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

564: if ((p_object_attribute_flag is null) or
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;

Line 571: FND_MSG_PUB.Add;

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:
575: if ((p_update_flag is null) or

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

575: if ((p_update_flag is null) or
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;

Line 582: FND_MSG_PUB.Add;

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:
586: if ((p_required_flag is null) or

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

586: if ((p_required_flag is null) or
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;

Line 593: FND_MSG_PUB.Add;

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:
597: -- === Validate columns ===

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

602: open l_check_seq_csr;
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;

Line 608: FND_MSG_PUB.Add;

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

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

614: -- - node_display_flag
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;

Line 621: FND_MSG_PUB.Add;

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;
625:

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

626: -- - node_query_flag
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;

Line 633: FND_MSG_PUB.Add;

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;
637:

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

638: -- - bold
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;

Line 645: FND_MSG_PUB.Add;

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;
649:

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

650: -- - italic
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;

Line 657: FND_MSG_PUB.Add;

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;
661:

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

666: p_return_status => l_return_status,
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;

Line 673: FND_MSG_PUB.Add;

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;
677:

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

682: p_return_status => l_return_status,
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;

Line 689: FND_MSG_PUB.Add;

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;
693:

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

698: p_return_status => l_return_status,
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;

Line 705: FND_MSG_PUB.Add;

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;
709:

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

710: -- - object attribute flag
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;

Line 717: FND_MSG_PUB.Add;

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;
721:

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

722: -- - update_flag
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;

Line 729: FND_MSG_PUB.Add;

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;
733:

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

734: -- - required_flag
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;

Line 741: FND_MSG_PUB.Add;

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;
745:

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

753: p_return_status => l_return_status,
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;

Line 760: FND_MSG_PUB.Add;

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;
764:

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

772: p_return_status => l_return_status,
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;

Line 779: FND_MSG_PUB.Add;

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;
783:

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

793: p_region_code => p_lov_region_code,
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;

Line 801: FND_MSG_PUB.Add;

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

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

810: p_api_version_number => 1.0,
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;

Line 816: FND_MSG_PUB.Add;

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;
820:

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

825: p_return_status => l_return_status,
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;

Line 832: FND_MSG_PUB.Add;

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;
836:

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

841: p_return_status => l_return_status,
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;

Line 848: FND_MSG_PUB.Add;

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;
852:

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

855: open l_check_menu_name(p_menu_name);
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;

Line 862: FND_MSG_PUB.Add;

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

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

870: open l_check_flexfield_name(p_flexfield_name, p_flexfield_application_id);
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;

Line 877: FND_MSG_PUB.Add;

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

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

885: open l_check_message_name(p_tip_message_name, p_tip_message_application_id);
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;

Line 892: FND_MSG_PUB.Add;

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

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

900: open l_check_entity_id(p_entity_id);
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;

Line 907: FND_MSG_PUB.Add;

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

Line 922: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass =

918: p_return_status => l_return_status,
919: p_lookup_type => 'INIT_SORT_TYPE',
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;

Line 926: FND_MSG_PUB.Add;

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;
930:

Line 941: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

937: p_return_status := FND_API.G_RET_STS_ERROR;
938: return FALSE;
939: WHEN OTHERS THEN
940: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
942: SUBSTR (SQLERRM, 1, 240) );
943: FND_MSG_PUB.Add;
944: return FALSE;
945:

Line 943: FND_MSG_PUB.Add;

939: WHEN OTHERS THEN
940: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
942: SUBSTR (SQLERRM, 1, 240) );
943: FND_MSG_PUB.Add;
944: return FALSE;
945:
946: end VALIDATE_ITEM;
947:

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

1019: --** check that key columns are not null and not missing **
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;

Line 1026: FND_MSG_PUB.Add;

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

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

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;

Line 1036: FND_MSG_PUB.Add;

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:
1040: --** check that required columns are not null and, unless calling **

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

1042: if ((p_database_object_name is null) or
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;

Line 1049: FND_MSG_PUB.Add;

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:
1053: if (p_region_style is null) or

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

1053: if (p_region_style is null) or
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;

Line 1060: FND_MSG_PUB.Add;

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:
1064: if ((p_name is null) or

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

1064: if ((p_name is null) or
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;

Line 1071: FND_MSG_PUB.Add;

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:
1075: --** Validate columns **

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

1079: p_api_version_number => 1.0,
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;

Line 1086: FND_MSG_PUB.Add;

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

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

1096: p_return_status => l_return_status,
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;

Line 1103: FND_MSG_PUB.Add;

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

Line 1119: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1115: p_return_status := FND_API.G_RET_STS_ERROR;
1116: return FALSE;
1117: WHEN OTHERS THEN
1118: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1119: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1120: SUBSTR (SQLERRM, 1, 240) );
1121: FND_MSG_PUB.Add;
1122: return FALSE;
1123:

Line 1121: FND_MSG_PUB.Add;

1117: WHEN OTHERS THEN
1118: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1119: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1120: SUBSTR (SQLERRM, 1, 240) );
1121: FND_MSG_PUB.Add;
1122: return FALSE;
1123:
1124: end VALIDATE_REGION;
1125:

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

1195: p_attribute_code => l_graph_columns_rec.attribute_code,
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;

Line 1203: FND_MSG_PUB.Add;

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;
1206: raise FND_API.G_EXC_ERROR;
1207: end if; -- if AK_REGION2_PVT.VALIDATE_GRAPH_COLUMN

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

1259: p_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 1267: FND_MSG_PUB.Add;

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;
1270: WHEN FND_API.G_EXC_ERROR THEN
1271: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

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

Line 1275: FND_MSG_PUB.Add;

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;
1278: WHEN OTHERS THEN
1279: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1280: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1276: end if;
1277: p_return_status := FND_API.G_RET_STS_ERROR;
1278: WHEN OTHERS THEN
1279: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1280: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1281: SUBSTR (SQLERRM, 1, 240) );
1282: FND_MSG_PUB.Add;
1283: end WRITE_GRAPH_COL_TO_BUFFER;
1284: */

Line 1282: FND_MSG_PUB.Add;

1278: WHEN OTHERS THEN
1279: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1280: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1281: SUBSTR (SQLERRM, 1, 240) );
1282: FND_MSG_PUB.Add;
1283: end WRITE_GRAPH_COL_TO_BUFFER;
1284: */
1285:
1286: --=======================================================

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

1358: p_application_id => l_category_usage_rec.application_id,
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);

Line 1367: FND_MSG_PUB.Add;

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;
1369: close l_get_category_usages_csr;
1370: raise FND_API.G_EXC_ERROR;
1371: end if; /* if AK_REGION2_PVT.VALIDATE_CATEGORY_USAGE */

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

1442: p_return_status := FND_API.G_RET_STS_SUCCESS;
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);

Line 1451: FND_MSG_PUB.Add;

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

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

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

Line 1460: FND_MSG_PUB.Add;

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;
1462: p_return_status := FND_API.G_RET_STS_ERROR;
1463: WHEN OTHERS THEN
1464: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1465: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1461: end if;
1462: p_return_status := FND_API.G_RET_STS_ERROR;
1463: WHEN OTHERS THEN
1464: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1465: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1466: SUBSTR (SQLERRM, 1, 240) );
1467: FND_MSG_PUB.Add;
1468: end WRITE_CAT_USAGES_TO_BUFFER;
1469:

Line 1467: FND_MSG_PUB.Add;

1463: WHEN OTHERS THEN
1464: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1465: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1466: SUBSTR (SQLERRM, 1, 240) );
1467: FND_MSG_PUB.Add;
1468: end WRITE_CAT_USAGES_TO_BUFFER;
1469:
1470: --=======================================================
1471: -- Procedure WRITE_LOV_RELATION_TO_BUFFER (local procedure)

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

1543: p_base_region_appl_id => l_lov_relation_rec.base_region_appl_id,
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;

Line 1551: FND_MSG_PUB.Add;

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;
1554: raise FND_API.G_EXC_ERROR;
1555: end if; /* if AK_REGION2_PVT.VALIDATE_LOV_RELATION */

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

1630: p_return_status := FND_API.G_RET_STS_SUCCESS;
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)||

Line 1640: FND_MSG_PUB.Add;

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

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

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

Line 1650: FND_MSG_PUB.Add;

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;
1651: end if;
1652: p_return_status := FND_API.G_RET_STS_ERROR;
1653: WHEN OTHERS THEN
1654: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1655: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1651: end if;
1652: p_return_status := FND_API.G_RET_STS_ERROR;
1653: WHEN OTHERS THEN
1654: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1655: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1656: SUBSTR (SQLERRM, 1, 240) );
1657: FND_MSG_PUB.Add;
1658: end WRITE_LOV_RELATION_TO_BUFFER;
1659:

Line 1657: FND_MSG_PUB.Add;

1653: WHEN OTHERS THEN
1654: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1655: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1656: SUBSTR (SQLERRM, 1, 240) );
1657: FND_MSG_PUB.Add;
1658: end WRITE_LOV_RELATION_TO_BUFFER;
1659:
1660: /*
1661: --=======================================================

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

1746: p_depth_radius => l_graphs_rec.depth_radius,
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));

Line 1755: FND_MSG_PUB.Add;

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;
1757: close l_get_graphs_csr;
1758: RAISE FND_API.G_EXC_ERROR;
1759: end if;

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

1841: p_region_code => p_region_code,
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;

Line 1847: FND_MSG_PUB.Add;

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
1851:

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

1889: p_return_status := FND_API.G_RET_STS_SUCCESS;
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);

Line 1898: FND_MSG_PUB.Add;

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;
1900: p_return_status := FND_API.G_RET_STS_ERROR;
1901: WHEN FND_API.G_EXC_ERROR THEN
1902: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1905: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1901: WHEN FND_API.G_EXC_ERROR THEN
1902: p_return_status := FND_API.G_RET_STS_ERROR;
1903: WHEN OTHERS THEN
1904: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1905: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1906: SUBSTR (SQLERRM, 1, 240) );
1907: FND_MSG_PUB.Add;
1908: end WRITE_GRAPH_TO_BUFFER;
1909: */

Line 1907: FND_MSG_PUB.Add;

1903: WHEN OTHERS THEN
1904: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1905: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1906: SUBSTR (SQLERRM, 1, 240) );
1907: FND_MSG_PUB.Add;
1908: end WRITE_GRAPH_TO_BUFFER;
1909: */
1910:
1911: --=======================================================

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

2077: p_customization_code => l_items_rec.customization_code,
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) ||

Line 2087: FND_MSG_PUB.Add;

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;
2088: close l_get_item_tl_csr;
2089: close l_get_items_csr;
2090: RAISE FND_API.G_EXC_ERROR;
2091: end if;

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

2720: p_lov_region_appl_id => l_items_rec.lov_region_application_id,
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;

Line 2726: FND_MSG_PUB.Add;

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

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

2785: p_return_status := FND_API.G_RET_STS_SUCCESS;
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) ||

Line 2795: FND_MSG_PUB.Add;

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;
2796: end if;
2797: p_return_status := FND_API.G_RET_STS_ERROR;
2798: WHEN FND_API.G_EXC_ERROR THEN
2799: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2802: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

2798: WHEN FND_API.G_EXC_ERROR THEN
2799: p_return_status := FND_API.G_RET_STS_ERROR;
2800: WHEN OTHERS THEN
2801: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2802: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2803: SUBSTR (SQLERRM, 1, 240) );
2804: FND_MSG_PUB.Add;
2805: end WRITE_ITEM_TO_BUFFER;
2806:

Line 2804: FND_MSG_PUB.Add;

2800: WHEN OTHERS THEN
2801: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2802: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2803: SUBSTR (SQLERRM, 1, 240) );
2804: FND_MSG_PUB.Add;
2805: end WRITE_ITEM_TO_BUFFER;
2806:
2807: --=======================================================
2808: -- Procedure WRITE_TO_BUFFER (local procedure)

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

2860: open l_get_region_csr;
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);

Line 2866: FND_MSG_PUB.Add;

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

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

2875: open l_get_region_tl_csr;
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);

Line 2881: FND_MSG_PUB.Add;

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

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

2908: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
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;

Line 2916: FND_MSG_PUB.Add;

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;
2919: end if; /* if AK_REGION_PVT.VALIDATE_REGION */
2920: end if; /* if p_validation_level */

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

3341: p_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 3349: FND_MSG_PUB.Add;

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;
3352: WHEN FND_API.G_EXC_ERROR THEN
3353: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

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

Line 3357: FND_MSG_PUB.Add;

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;
3360: WHEN OTHERS THEN
3361: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3362: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

3358: end if;
3359: p_return_status := FND_API.G_RET_STS_ERROR;
3360: WHEN OTHERS THEN
3361: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3362: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3363: SUBSTR (SQLERRM, 1, 240) );
3364: FND_MSG_PUB.Add;
3365: end WRITE_TO_BUFFER;
3366:

Line 3364: FND_MSG_PUB.Add;

3360: WHEN OTHERS THEN
3361: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3362: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3363: SUBSTR (SQLERRM, 1, 240) );
3364: FND_MSG_PUB.Add;
3365: end WRITE_TO_BUFFER;
3366:
3367: /*
3368: --=======================================================

Line 3443: FND_MSG_PUB.initialize;

3439:
3440: -- Initialize the message table if requested.
3441:
3442: if p_init_msg_tbl then
3443: FND_MSG_PUB.initialize;
3444: end if;
3445:
3446: savepoint start_create_graph;
3447:

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

3451: p_return_status => l_return_status,
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');

Line 3457: FND_MSG_PUB.Add;

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

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

3553: p_return_status => l_return_status,
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');

Line 3559: FND_MSG_PUB.Add;

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

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

3600:
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 ||

Line 3610: FND_MSG_PUB.Add;

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;
3612:
3613: p_return_status := FND_API.G_RET_STS_SUCCESS;
3614:

Line 3615: FND_MSG_PUB.Count_And_Get (

3611: end if;
3612:
3613: p_return_status := FND_API.G_RET_STS_SUCCESS;
3614:
3615: FND_MSG_PUB.Count_And_Get (
3616: p_count => p_msg_count,
3617: p_data => p_msg_data);
3618:
3619: EXCEPTION

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

3617: p_data => p_msg_data);
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);

Line 3626: FND_MSG_PUB.Add;

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;
3628: p_return_status := FND_API.G_RET_STS_ERROR;
3629: rollback to start_create_graph;
3630: FND_MSG_PUB.Count_And_Get (

Line 3630: FND_MSG_PUB.Count_And_Get (

3626: FND_MSG_PUB.Add;
3627: end if;
3628: p_return_status := FND_API.G_RET_STS_ERROR;
3629: rollback to start_create_graph;
3630: FND_MSG_PUB.Count_And_Get (
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

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

3630: FND_MSG_PUB.Count_And_Get (
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);

Line 3639: FND_MSG_PUB.Add;

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;
3641: p_return_status := FND_API.G_RET_STS_ERROR;
3642: rollback to start_create_graph;
3643: FND_MSG_PUB.Count_And_Get (

Line 3643: FND_MSG_PUB.Count_And_Get (

3639: FND_MSG_PUB.Add;
3640: end if;
3641: p_return_status := FND_API.G_RET_STS_ERROR;
3642: rollback to start_create_graph;
3643: FND_MSG_PUB.Count_And_Get (
3644: p_count => p_msg_count,
3645: p_data => p_msg_data);
3646: WHEN OTHERS THEN
3647: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3649: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

3645: p_data => p_msg_data);
3646: WHEN OTHERS THEN
3647: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3648: rollback to start_create_graph;
3649: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3650: SUBSTR (SQLERRM, 1, 240) );
3651: FND_MSG_PUB.Add;
3652: FND_MSG_PUB.Count_And_Get (
3653: p_count => p_msg_count,

Line 3651: FND_MSG_PUB.Add;

3647: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3648: rollback to start_create_graph;
3649: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3650: SUBSTR (SQLERRM, 1, 240) );
3651: FND_MSG_PUB.Add;
3652: FND_MSG_PUB.Count_And_Get (
3653: p_count => p_msg_count,
3654: p_data => p_msg_data);
3655: end CREATE_GRAPH;

Line 3652: FND_MSG_PUB.Count_And_Get (

3648: rollback to start_create_graph;
3649: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3650: SUBSTR (SQLERRM, 1, 240) );
3651: FND_MSG_PUB.Add;
3652: FND_MSG_PUB.Count_And_Get (
3653: p_count => p_msg_count,
3654: p_data => p_msg_data);
3655: end CREATE_GRAPH;
3656: */

Line 3882: FND_MSG_PUB.initialize;

3878:
3879: -- Initialize the message table if requested.
3880:
3881: if p_init_msg_tbl then
3882: FND_MSG_PUB.initialize;
3883: end if;
3884:
3885: savepoint start_create_item;
3886:

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

3893: p_region_application_id => p_region_application_id,
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');

Line 3899: FND_MSG_PUB.Add;

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;
3903: end if; */

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

4545: p_region_application_id => p_region_application_id,
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');

Line 4551: FND_MSG_PUB.Add;

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

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

4597:
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 ||

Line 4608: FND_MSG_PUB.Add;

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;
4609: end if;
4610:
4611: end if; -- /* if not p_copy_redo_flag */
4612:

Line 4615: FND_MSG_PUB.Count_And_Get (

4611: end if; -- /* if not p_copy_redo_flag */
4612:
4613: p_return_status := FND_API.G_RET_STS_SUCCESS;
4614:
4615: FND_MSG_PUB.Count_And_Get (
4616: p_count => p_msg_count,
4617: p_data => p_msg_data);
4618:
4619:

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

4618:
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) ||

Line 4628: FND_MSG_PUB.Add;

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;
4629: end if;
4630: p_return_status := FND_API.G_RET_STS_ERROR;
4631: rollback to start_create_item;
4632: FND_MSG_PUB.Count_And_Get (

Line 4632: FND_MSG_PUB.Count_And_Get (

4628: FND_MSG_PUB.Add;
4629: end if;
4630: p_return_status := FND_API.G_RET_STS_ERROR;
4631: rollback to start_create_item;
4632: FND_MSG_PUB.Count_And_Get (
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

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

4632: FND_MSG_PUB.Count_And_Get (
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) ||

Line 4642: FND_MSG_PUB.Add;

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;
4643: end if;
4644: p_return_status := FND_API.G_RET_STS_ERROR;
4645: rollback to start_create_item;
4646: FND_MSG_PUB.Count_And_Get (

Line 4646: FND_MSG_PUB.Count_And_Get (

4642: FND_MSG_PUB.Add;
4643: end if;
4644: p_return_status := FND_API.G_RET_STS_ERROR;
4645: rollback to start_create_item;
4646: FND_MSG_PUB.Count_And_Get (
4647: p_count => p_msg_count,
4648: p_data => p_msg_data);
4649: WHEN OTHERS THEN
4650: if (SQLCODE = -1) then

Line 4758: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

4754: );
4755: else
4756: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4757: rollback to start_create_item;
4758: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4759: SUBSTR (SQLERRM, 1, 240) );
4760: FND_MSG_PUB.Add;
4761: FND_MSG_PUB.Count_And_Get (
4762: p_count => p_msg_count,

Line 4760: FND_MSG_PUB.Add;

4756: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4757: rollback to start_create_item;
4758: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4759: SUBSTR (SQLERRM, 1, 240) );
4760: FND_MSG_PUB.Add;
4761: FND_MSG_PUB.Count_And_Get (
4762: p_count => p_msg_count,
4763: p_data => p_msg_data);
4764: end if;

Line 4761: FND_MSG_PUB.Count_And_Get (

4757: rollback to start_create_item;
4758: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4759: SUBSTR (SQLERRM, 1, 240) );
4760: FND_MSG_PUB.Add;
4761: FND_MSG_PUB.Count_And_Get (
4762: p_count => p_msg_count,
4763: p_data => p_msg_data);
4764: end if;
4765: end CREATE_ITEM;

Line 4924: FND_MSG_PUB.initialize;

4920:
4921: -- Initialize the message table if requested.
4922:
4923: if p_init_msg_tbl then
4924: FND_MSG_PUB.initialize;
4925: end if;
4926:
4927: savepoint start_create_region;
4928:

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

4931: p_api_version_number => 1.0,
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');

Line 4937: FND_MSG_PUB.Add;

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

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

5314: p_api_version_number => 1.0,
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');

Line 5320: FND_MSG_PUB.Add;

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

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

5358:
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;

Line 5366: FND_MSG_PUB.Add;

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:
5369: end if; -- /* if not p_copy_redo_flag */
5370:

Line 5373: FND_MSG_PUB.Count_And_Get (

5369: end if; -- /* if not p_copy_redo_flag */
5370:
5371: p_return_status := FND_API.G_RET_STS_SUCCESS;
5372:
5373: FND_MSG_PUB.Count_And_Get (
5374: p_count => p_msg_count,
5375: p_data => p_msg_data);
5376:
5377: EXCEPTION

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

5375: p_data => p_msg_data);
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;

Line 5383: FND_MSG_PUB.Add;

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

Line 5384: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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));
5386: FND_MSG_PUB.Add;
5387: end if;
5388: p_return_status := FND_API.G_RET_STS_ERROR;

Line 5386: FND_MSG_PUB.Add;

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));
5386: FND_MSG_PUB.Add;
5387: end if;
5388: p_return_status := FND_API.G_RET_STS_ERROR;
5389: rollback to start_create_region;
5390: FND_MSG_PUB.Count_And_Get (

Line 5390: FND_MSG_PUB.Count_And_Get (

5386: FND_MSG_PUB.Add;
5387: end if;
5388: p_return_status := FND_API.G_RET_STS_ERROR;
5389: rollback to start_create_region;
5390: FND_MSG_PUB.Count_And_Get (
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

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

5390: FND_MSG_PUB.Count_And_Get (
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;

Line 5398: FND_MSG_PUB.Add;

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;
5401: rollback to start_create_region;
5402: FND_MSG_PUB.Count_And_Get (

Line 5402: FND_MSG_PUB.Count_And_Get (

5398: FND_MSG_PUB.Add;
5399: end if;
5400: p_return_status := FND_API.G_RET_STS_ERROR;
5401: rollback to start_create_region;
5402: FND_MSG_PUB.Count_And_Get (
5403: p_count => p_msg_count,
5404: p_data => p_msg_data);
5405: WHEN OTHERS THEN
5406: if (SQLCODE = -1) then

Line 5476: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5472: );
5473: else
5474: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5475: rollback to start_create_region;
5476: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5477: SUBSTR (SQLERRM, 1, 240) );
5478: FND_MSG_PUB.Add;
5479: FND_MSG_PUB.Count_And_Get (
5480: p_count => p_msg_count,

Line 5478: FND_MSG_PUB.Add;

5474: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5475: rollback to start_create_region;
5476: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5477: SUBSTR (SQLERRM, 1, 240) );
5478: FND_MSG_PUB.Add;
5479: FND_MSG_PUB.Count_And_Get (
5480: p_count => p_msg_count,
5481: p_data => p_msg_data);
5482: end if;

Line 5479: FND_MSG_PUB.Count_And_Get (

5475: rollback to start_create_region;
5476: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5477: SUBSTR (SQLERRM, 1, 240) );
5478: FND_MSG_PUB.Add;
5479: FND_MSG_PUB.Count_And_Get (
5480: p_count => p_msg_count,
5481: p_data => p_msg_data);
5482: end if;
5483: end CREATE_REGION;

Line 5550: FND_MSG_PUB.initialize;

5546:
5547: -- Initialize the message table if requested.
5548:
5549: if p_init_msg_tbl then
5550: FND_MSG_PUB.initialize;
5551: end if;
5552:
5553: savepoint start_delete_graph;
5554:

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

5560: p_return_status => l_return_status,
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;

Line 5566: FND_MSG_PUB.Add;

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;
5570:

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

5580: fetch l_get_graph_column_csr into l_attribute_application_id,
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;

Line 5586: FND_MSG_PUB.Add;

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;
5590: close l_get_graph_column_csr;

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

5630: and region_code = p_region_code
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;

Line 5636: FND_MSG_PUB.Add;

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;
5640:

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

5643: and region_code = p_region_code
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;

Line 5649: FND_MSG_PUB.Add;

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;
5653:

Line 5657: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then

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

Line 5662: FND_MSG_PUB.Add;

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;
5664:
5665: p_return_status := FND_API.G_RET_STS_SUCCESS;
5666:

Line 5667: FND_MSG_PUB.Count_And_Get (

5663: end if;
5664:
5665: p_return_status := FND_API.G_RET_STS_SUCCESS;
5666:
5667: FND_MSG_PUB.Count_And_Get (
5668: p_count => p_msg_count,
5669: p_data => p_msg_data);
5670:
5671: EXCEPTION

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

5669: p_data => p_msg_data);
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);

Line 5678: FND_MSG_PUB.Add;

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;
5680: p_return_status := FND_API.G_RET_STS_ERROR;
5681: rollback to start_delete_graph;
5682: FND_MSG_PUB.Count_And_Get (

Line 5682: FND_MSG_PUB.Count_And_Get (

5678: FND_MSG_PUB.Add;
5679: end if;
5680: p_return_status := FND_API.G_RET_STS_ERROR;
5681: rollback to start_delete_graph;
5682: FND_MSG_PUB.Count_And_Get (
5683: p_count => p_msg_count,
5684: p_data => p_msg_data);
5685: WHEN OTHERS THEN
5686: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5688: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5684: p_data => p_msg_data);
5685: WHEN OTHERS THEN
5686: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5687: rollback to start_delete_graph;
5688: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5689: SUBSTR (SQLERRM, 1, 240) );
5690: FND_MSG_PUB.Add;
5691: FND_MSG_PUB.Count_And_Get (
5692: p_count => p_msg_count,

Line 5690: FND_MSG_PUB.Add;

5686: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5687: rollback to start_delete_graph;
5688: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5689: SUBSTR (SQLERRM, 1, 240) );
5690: FND_MSG_PUB.Add;
5691: FND_MSG_PUB.Count_And_Get (
5692: p_count => p_msg_count,
5693: p_data => p_msg_data);
5694: end DELETE_GRAPH;

Line 5691: FND_MSG_PUB.Count_And_Get (

5687: rollback to start_delete_graph;
5688: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5689: SUBSTR (SQLERRM, 1, 240) );
5690: FND_MSG_PUB.Add;
5691: FND_MSG_PUB.Count_And_Get (
5692: p_count => p_msg_count,
5693: p_data => p_msg_data);
5694: end DELETE_GRAPH;
5695: */

Line 5791: FND_MSG_PUB.initialize;

5787:
5788: -- Initialize the message table if requested.
5789:
5790: if p_init_msg_tbl then
5791: FND_MSG_PUB.initialize;
5792: end if;
5793:
5794: savepoint start_delete_item;
5795:

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

5802: p_region_application_id => p_region_application_id,
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;

Line 5808: FND_MSG_PUB.Add;

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;
5812:

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

5822: fetch l_get_page_region_item_csr into l_flow_application_id, l_flow_code,
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;

Line 5828: FND_MSG_PUB.Add;

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;
5832: close l_get_page_region_item_csr;

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

5858: and base_region_appl_id = l_base_region_appl_id
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;

Line 5864: FND_MSG_PUB.Add;

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

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

5883: and attribute_code = p_attribute_code
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;

Line 5889: FND_MSG_PUB.Add;

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

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

5937: and attribute_application_id = p_attribute_application_id
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;

Line 5943: FND_MSG_PUB.Add;

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;
5947:

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

5951: and attribute_application_id = p_attribute_application_id
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;

Line 5957: FND_MSG_PUB.Add;

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;
5961:

Line 5965: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then

5961:
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) ||

Line 5971: FND_MSG_PUB.Add;

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;
5972: end if;
5973:
5974: p_return_status := FND_API.G_RET_STS_SUCCESS;
5975:

Line 5976: FND_MSG_PUB.Count_And_Get (

5972: end if;
5973:
5974: p_return_status := FND_API.G_RET_STS_SUCCESS;
5975:
5976: FND_MSG_PUB.Count_And_Get (
5977: p_count => p_msg_count,
5978: p_data => p_msg_data);
5979:
5980: EXCEPTION

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

5978: p_data => p_msg_data);
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) ||

Line 5988: FND_MSG_PUB.Add;

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;
5989: end if;
5990: p_return_status := FND_API.G_RET_STS_ERROR;
5991: rollback to start_delete_item;
5992: FND_MSG_PUB.Count_And_Get (

Line 5992: FND_MSG_PUB.Count_And_Get (

5988: FND_MSG_PUB.Add;
5989: end if;
5990: p_return_status := FND_API.G_RET_STS_ERROR;
5991: rollback to start_delete_item;
5992: FND_MSG_PUB.Count_And_Get (
5993: p_count => p_msg_count,
5994: p_data => p_msg_data);
5995: WHEN OTHERS THEN
5996: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5998: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5994: p_data => p_msg_data);
5995: WHEN OTHERS THEN
5996: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5997: rollback to start_delete_item;
5998: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5999: SUBSTR (SQLERRM, 1, 240) );
6000: FND_MSG_PUB.Add;
6001: FND_MSG_PUB.Count_And_Get (
6002: p_count => p_msg_count,

Line 6000: FND_MSG_PUB.Add;

5996: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5997: rollback to start_delete_item;
5998: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5999: SUBSTR (SQLERRM, 1, 240) );
6000: FND_MSG_PUB.Add;
6001: FND_MSG_PUB.Count_And_Get (
6002: p_count => p_msg_count,
6003: p_data => p_msg_data);
6004: end DELETE_ITEM;

Line 6001: FND_MSG_PUB.Count_And_Get (

5997: rollback to start_delete_item;
5998: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5999: SUBSTR (SQLERRM, 1, 240) );
6000: FND_MSG_PUB.Add;
6001: FND_MSG_PUB.Count_And_Get (
6002: p_count => p_msg_count,
6003: p_data => p_msg_data);
6004: end DELETE_ITEM;
6005:

Line 6096: FND_MSG_PUB.initialize;

6092:
6093: -- Initialize the message table if requested.
6094:
6095: if p_init_msg_tbl then
6096: FND_MSG_PUB.initialize;
6097: end if;
6098:
6099: savepoint start_delete_region;
6100:

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

6107: p_api_version_number => 1.0,
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;

Line 6113: FND_MSG_PUB.Add;

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;
6117: **/

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

6125: open l_is_region_a_child_csr;
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;

Line 6131: FND_MSG_PUB.Add;

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;
6135: close l_is_region_a_child_csr;

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

6145: open l_get_items_csr;
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;

Line 6151: FND_MSG_PUB.Add;

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;
6155: close l_get_items_csr;

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

6160: fetch l_get_page_region_csr into l_flow_application_id, l_flow_code,
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;

Line 6166: FND_MSG_PUB.Add;

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;
6170: close l_get_page_region_csr;

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

6176: l_attribute_application_id, l_attribute_code,
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;

Line 6182: FND_MSG_PUB.Add;

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;
6186: close l_get_navigations_csr;

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

6283: where region_application_id = p_region_application_id
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;

Line 6289: FND_MSG_PUB.Add;

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;
6293:

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

6295: where region_application_id = p_region_application_id
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;

Line 6302: FND_MSG_PUB.Add;

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;
6306:

Line 6310: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then

6306:
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;

Line 6314: FND_MSG_PUB.Add;

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
6317:
6318: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6320: FND_MSG_PUB.Count_And_Get (

6316: end if; -- region exists
6317:
6318: p_return_status := FND_API.G_RET_STS_SUCCESS;
6319:
6320: FND_MSG_PUB.Count_And_Get (
6321: p_count => p_msg_count,
6322: p_data => p_msg_data);
6323:
6324: EXCEPTION

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

6322: p_data => p_msg_data);
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;

Line 6330: FND_MSG_PUB.Add;

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;
6333: rollback to start_delete_region;
6334: FND_MSG_PUB.Count_And_Get (

Line 6334: FND_MSG_PUB.Count_And_Get (

6330: FND_MSG_PUB.Add;
6331: end if;
6332: p_return_status := FND_API.G_RET_STS_ERROR;
6333: rollback to start_delete_region;
6334: FND_MSG_PUB.Count_And_Get (
6335: p_count => p_msg_count,
6336: p_data => p_msg_data);
6337: WHEN OTHERS THEN
6338: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6340: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

6336: p_data => p_msg_data);
6337: WHEN OTHERS THEN
6338: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6339: rollback to start_delete_region;
6340: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6341: SUBSTR (SQLERRM, 1, 240) );
6342: FND_MSG_PUB.Add;
6343: FND_MSG_PUB.Count_And_Get (
6344: p_count => p_msg_count,

Line 6342: FND_MSG_PUB.Add;

6338: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6339: rollback to start_delete_region;
6340: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6341: SUBSTR (SQLERRM, 1, 240) );
6342: FND_MSG_PUB.Add;
6343: FND_MSG_PUB.Count_And_Get (
6344: p_count => p_msg_count,
6345: p_data => p_msg_data);
6346: end DELETE_REGION;

Line 6343: FND_MSG_PUB.Count_And_Get (

6339: rollback to start_delete_region;
6340: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6341: SUBSTR (SQLERRM, 1, 240) );
6342: FND_MSG_PUB.Add;
6343: FND_MSG_PUB.Count_And_Get (
6344: p_count => p_msg_count,
6345: p_data => p_msg_data);
6346: end DELETE_REGION;
6347:

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

6492: -- - p_application_id alone, or
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;

Line 6498: FND_MSG_PUB.Add;

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

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

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

Line 6508: FND_MSG_PUB.Add;

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;
6512:

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

6718: p_return_status := FND_API.G_RET_STS_SUCCESS;
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.');

Line 6724: FND_MSG_PUB.Add;

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;
6728: WHEN FND_API.G_EXC_ERROR THEN

Line 6733: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

6729: p_return_status := FND_API.G_RET_STS_ERROR;
6730: WHEN OTHERS THEN
6731: --dbms_output.put_line(SUBSTR(SQLERRM,1,240));
6732: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6733: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6734: SUBSTR (SQLERRM, 1, 240) );
6735: FND_MSG_PUB.Add;
6736: end DOWNLOAD_REGION;
6737:

Line 6735: FND_MSG_PUB.Add;

6731: --dbms_output.put_line(SUBSTR(SQLERRM,1,240));
6732: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6733: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6734: SUBSTR (SQLERRM, 1, 240) );
6735: FND_MSG_PUB.Add;
6736: end DOWNLOAD_REGION;
6737:
6738: --=======================================================
6739: -- Procedure INSERT_REGION_PK_TABLE

Line 6815: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

6811: WHEN FND_API.G_EXC_ERROR THEN
6812: p_return_status := FND_API.G_RET_STS_ERROR;
6813: WHEN OTHERS THEN
6814: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6815: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6816: SUBSTR (SQLERRM, 1, 240) );
6817: FND_MSG_PUB.Add;
6818: end INSERT_REGION_PK_TABLE;
6819:

Line 6817: FND_MSG_PUB.Add;

6813: WHEN OTHERS THEN
6814: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6815: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6816: SUBSTR (SQLERRM, 1, 240) );
6817: FND_MSG_PUB.Add;
6818: end INSERT_REGION_PK_TABLE;
6819:
6820: /*
6821: --=======================================================

Line 6886: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

6882: p_return_status := FND_API.G_RET_STS_ERROR;
6883: return FALSE;
6884: WHEN OTHERS THEN
6885: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6886: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6887: SUBSTR (SQLERRM, 1, 240) );
6888: FND_MSG_PUB.Add;
6889: return FALSE;
6890:

Line 6888: FND_MSG_PUB.Add;

6884: WHEN OTHERS THEN
6885: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6886: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6887: SUBSTR (SQLERRM, 1, 240) );
6888: FND_MSG_PUB.Add;
6889: return FALSE;
6890:
6891: end GRAPH_EXISTS;
6892: */

Line 6961: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

6957: p_return_status := FND_API.G_RET_STS_ERROR;
6958: return FALSE;
6959: WHEN OTHERS THEN
6960: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6961: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6962: SUBSTR (SQLERRM, 1, 240) );
6963: FND_MSG_PUB.Add;
6964: return FALSE;
6965:

Line 6963: FND_MSG_PUB.Add;

6959: WHEN OTHERS THEN
6960: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6961: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6962: SUBSTR (SQLERRM, 1, 240) );
6963: FND_MSG_PUB.Add;
6964: return FALSE;
6965:
6966: end ITEM_EXISTS;
6967:

Line 7031: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

7027: p_return_status := FND_API.G_RET_STS_ERROR;
7028: return FALSE;
7029: WHEN OTHERS THEN
7030: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7031: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
7032: SUBSTR (SQLERRM, 1, 240) );
7033: FND_MSG_PUB.Add;
7034: return FALSE;
7035: end REGION_EXISTS;

Line 7033: FND_MSG_PUB.Add;

7029: WHEN OTHERS THEN
7030: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7031: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
7032: SUBSTR (SQLERRM, 1, 240) );
7033: FND_MSG_PUB.Add;
7034: return FALSE;
7035: end REGION_EXISTS;
7036:
7037: /*

Line 7126: FND_MSG_PUB.initialize;

7122:
7123: -- Initialize the message table if requested.
7124:
7125: if p_init_msg_tbl then
7126: FND_MSG_PUB.initialize;
7127: end if;
7128:
7129: savepoint start_update_graph;
7130:

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

7134: --** retrieve ak_region_graphs row if it exists **
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');

Line 7140: FND_MSG_PUB.Add;

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

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

7148: --** retrieve ak_region_graphss_tl row if it exists **
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');

Line 7154: FND_MSG_PUB.Add;

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

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

7243: where REGION_APPLICATION_ID = p_region_application_id
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');

Line 7249: FND_MSG_PUB.Add;

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

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

7263: and REGION_CODE = p_region_code
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');

Line 7269: FND_MSG_PUB.Add;

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

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

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

Line 7283: FND_MSG_PUB.Add;

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;
7285:
7286: p_return_status := FND_API.G_RET_STS_SUCCESS;
7287:

Line 7288: FND_MSG_PUB.Count_And_Get (

7284: end if;
7285:
7286: p_return_status := FND_API.G_RET_STS_SUCCESS;
7287:
7288: FND_MSG_PUB.Count_And_Get (
7289: p_count => p_msg_count,
7290: p_data => p_msg_data);
7291:
7292: EXCEPTION

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

7290: p_data => p_msg_data);
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);

Line 7299: FND_MSG_PUB.Add;

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;
7301: rollback to start_update_graph;
7302: p_return_status := FND_API.G_RET_STS_ERROR;
7303: FND_MSG_PUB.Count_And_Get (

Line 7303: FND_MSG_PUB.Count_And_Get (

7299: FND_MSG_PUB.Add;
7300: end if;
7301: rollback to start_update_graph;
7302: p_return_status := FND_API.G_RET_STS_ERROR;
7303: FND_MSG_PUB.Count_And_Get (
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

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

7303: FND_MSG_PUB.Count_And_Get (
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);

Line 7312: FND_MSG_PUB.Add;

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;
7314: p_return_status := FND_API.G_RET_STS_ERROR;
7315: rollback to start_update_graph;
7316: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 7316: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

7312: FND_MSG_PUB.Add;
7313: end if;
7314: p_return_status := FND_API.G_RET_STS_ERROR;
7315: rollback to start_update_graph;
7316: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
7317: SUBSTR (SQLERRM, 1, 240) );
7318: FND_MSG_PUB.Add;
7319: FND_MSG_PUB.Count_And_Get (
7320: p_count => p_msg_count,

Line 7318: FND_MSG_PUB.Add;

7314: p_return_status := FND_API.G_RET_STS_ERROR;
7315: rollback to start_update_graph;
7316: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
7317: SUBSTR (SQLERRM, 1, 240) );
7318: FND_MSG_PUB.Add;
7319: FND_MSG_PUB.Count_And_Get (
7320: p_count => p_msg_count,
7321: p_data => p_msg_data);
7322: end UPDATE_GRAPH;

Line 7319: FND_MSG_PUB.Count_And_Get (

7315: rollback to start_update_graph;
7316: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
7317: SUBSTR (SQLERRM, 1, 240) );
7318: FND_MSG_PUB.Add;
7319: FND_MSG_PUB.Count_And_Get (
7320: p_count => p_msg_count,
7321: p_data => p_msg_data);
7322: end UPDATE_GRAPH;
7323: */

Line 7498: FND_MSG_PUB.initialize;

7494:
7495: -- Initialize the message table if requested.
7496:
7497: if p_init_msg_tbl then
7498: FND_MSG_PUB.initialize;
7499: end if;
7500:
7501: savepoint start_update_item;
7502:

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

7506: --** retrieve ak_region_items row if it exists **
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');

Line 7512: FND_MSG_PUB.Add;

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

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

7520: --** retrieve ak_region_items_tl row if it exists **
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');

Line 7526: FND_MSG_PUB.Add;

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

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

8174: and REGION_CODE = p_region_code
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');

Line 8180: FND_MSG_PUB.Add;

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

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

8196: and attribute_application_id = p_attribute_application_id
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');

Line 8202: FND_MSG_PUB.Add;

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

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

8207:
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) ||

Line 8217: FND_MSG_PUB.Add;

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;
8218: end if;
8219:
8220: end if;
8221:

Line 8226: FND_MSG_PUB.Count_And_Get (

8222: end if; -- /* if not p_copy_redo_flag */
8223:
8224: p_return_status := FND_API.G_RET_STS_SUCCESS;
8225:
8226: FND_MSG_PUB.Count_And_Get (
8227: p_count => p_msg_count,
8228: p_data => p_msg_data);
8229:
8230: EXCEPTION

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

8228: p_data => p_msg_data);
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) ||

Line 8238: FND_MSG_PUB.Add;

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;
8239: end if;
8240: rollback to start_update_item;
8241: p_return_status := FND_API.G_RET_STS_ERROR;
8242: FND_MSG_PUB.Count_And_Get (

Line 8242: FND_MSG_PUB.Count_And_Get (

8238: FND_MSG_PUB.Add;
8239: end if;
8240: rollback to start_update_item;
8241: p_return_status := FND_API.G_RET_STS_ERROR;
8242: FND_MSG_PUB.Count_And_Get (
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

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

8242: FND_MSG_PUB.Count_And_Get (
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) ||

Line 8252: FND_MSG_PUB.Add;

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;
8253: end if;
8254: p_return_status := FND_API.G_RET_STS_ERROR;
8255: rollback to start_update_item;
8256: FND_MSG_PUB.Count_And_Get (

Line 8256: FND_MSG_PUB.Count_And_Get (

8252: FND_MSG_PUB.Add;
8253: end if;
8254: p_return_status := FND_API.G_RET_STS_ERROR;
8255: rollback to start_update_item;
8256: FND_MSG_PUB.Count_And_Get (
8257: p_count => p_msg_count,
8258: p_data => p_msg_data);
8259: WHEN OTHERS THEN
8260: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8262: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

8258: p_data => p_msg_data);
8259: WHEN OTHERS THEN
8260: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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) ||

Line 8264: FND_MSG_PUB.Add;

8260: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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) ||

Line 8270: FND_MSG_PUB.Add;

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;
8271: FND_MSG_PUB.Count_And_Get (
8272: p_count => p_msg_count,
8273: p_data => p_msg_data);
8274: end UPDATE_ITEM;

Line 8271: FND_MSG_PUB.Count_And_Get (

8267: ' ' || p_region_code ||
8268: ' ' || to_char(p_attribute_application_id) ||
8269: ' ' || p_attribute_code);
8270: FND_MSG_PUB.Add;
8271: FND_MSG_PUB.Count_And_Get (
8272: p_count => p_msg_count,
8273: p_data => p_msg_data);
8274: end UPDATE_ITEM;
8275:

Line 8402: FND_MSG_PUB.initialize;

8398:
8399: -- Initialize the message table if requested.
8400:
8401: if p_init_msg_tbl then
8402: FND_MSG_PUB.initialize;
8403: end if;
8404:
8405: savepoint start_update_region;
8406:

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

8410: --** retrieve ak_regions row if it exists **
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');

Line 8416: FND_MSG_PUB.Add;

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

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

8424: --** retrieve ak_regions_tl row if it exists **
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');

Line 8430: FND_MSG_PUB.Add;

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

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

8752: LAST_UPDATE_LOGIN = l_last_update_login
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;

Line 8758: FND_MSG_PUB.Add;

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;
8762:

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

8771: and REGION_CODE = p_region_code
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;

Line 8777: FND_MSG_PUB.Add;

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;
8781:

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

8781:
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;

Line 8789: FND_MSG_PUB.Add;

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

Line 8798: FND_MSG_PUB.Count_And_Get (

8794: end if; -- /* if not p_copy_redo_flag */
8795:
8796: p_return_status := FND_API.G_RET_STS_SUCCESS;
8797:
8798: FND_MSG_PUB.Count_And_Get (
8799: p_count => p_msg_count,
8800: p_data => p_msg_data);
8801:
8802: EXCEPTION

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

8800: p_data => p_msg_data);
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;

Line 8808: FND_MSG_PUB.Add;

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

Line 8809: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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));
8811: FND_MSG_PUB.Add;
8812:
8813: end if;

Line 8811: FND_MSG_PUB.Add;

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));
8811: FND_MSG_PUB.Add;
8812:
8813: end if;
8814: rollback to start_update_region;
8815: p_return_status := FND_API.G_RET_STS_ERROR;

Line 8816: FND_MSG_PUB.Count_And_Get (

8812:
8813: end if;
8814: rollback to start_update_region;
8815: p_return_status := FND_API.G_RET_STS_ERROR;
8816: FND_MSG_PUB.Count_And_Get (
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

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

8816: FND_MSG_PUB.Count_And_Get (
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;

Line 8824: FND_MSG_PUB.Add;

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;
8827: rollback to start_update_region;
8828: FND_MSG_PUB.Count_And_Get (

Line 8828: FND_MSG_PUB.Count_And_Get (

8824: FND_MSG_PUB.Add;
8825: end if;
8826: p_return_status := FND_API.G_RET_STS_ERROR;
8827: rollback to start_update_region;
8828: FND_MSG_PUB.Count_And_Get (
8829: p_count => p_msg_count,
8830: p_data => p_msg_data);
8831: WHEN OTHERS THEN
8832: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8834: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

8830: p_data => p_msg_data);
8831: WHEN OTHERS THEN
8832: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8833: rollback to start_update_region;
8834: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8835: SUBSTR (SQLERRM, 1, 240) );
8836: FND_MSG_PUB.Add;
8837: FND_MSG_PUB.Count_And_Get (
8838: p_count => p_msg_count,

Line 8836: FND_MSG_PUB.Add;

8832: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8833: rollback to start_update_region;
8834: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8835: SUBSTR (SQLERRM, 1, 240) );
8836: FND_MSG_PUB.Add;
8837: FND_MSG_PUB.Count_And_Get (
8838: p_count => p_msg_count,
8839: p_data => p_msg_data);
8840: FND_MSG_PUB.Count_And_Get (

Line 8837: FND_MSG_PUB.Count_And_Get (

8833: rollback to start_update_region;
8834: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8835: SUBSTR (SQLERRM, 1, 240) );
8836: FND_MSG_PUB.Add;
8837: FND_MSG_PUB.Count_And_Get (
8838: p_count => p_msg_count,
8839: p_data => p_msg_data);
8840: FND_MSG_PUB.Count_And_Get (
8841: p_count => p_msg_count,

Line 8840: FND_MSG_PUB.Count_And_Get (

8836: FND_MSG_PUB.Add;
8837: FND_MSG_PUB.Count_And_Get (
8838: p_count => p_msg_count,
8839: p_data => p_msg_data);
8840: FND_MSG_PUB.Count_And_Get (
8841: p_count => p_msg_count,
8842: p_data => p_msg_data);
8843: end UPDATE_REGION;
8844: