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 4546: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

4542: p_region_application_id => p_region_application_id,
4543: p_region_code => p_region_code,
4544: p_attribute_application_id => p_attribute_application_id,
4545: p_attribute_code => p_attribute_code) then
4546: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4547: FND_MESSAGE.SET_NAME('AK','AK_INSERT_REG_ITEM_FAILED');
4548: FND_MSG_PUB.Add;
4549: end if;
4550: --dbms_output.put_line(l_api_name || 'Error - row already exists');

Line 4548: FND_MSG_PUB.Add;

4544: p_attribute_application_id => p_attribute_application_id,
4545: p_attribute_code => p_attribute_code) then
4546: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4547: FND_MESSAGE.SET_NAME('AK','AK_INSERT_REG_ITEM_FAILED');
4548: FND_MSG_PUB.Add;
4549: end if;
4550: --dbms_output.put_line(l_api_name || 'Error - row already exists');
4551: raise FND_API.G_EXC_ERROR;
4552: end if;

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

4594:
4595: -- /** commit the insert **/
4596: commit;
4597:
4598: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4599: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_CREATED');
4600: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_REGION_ITEM',TRUE);
4601: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4602: ' ' || p_region_code ||

Line 4605: FND_MSG_PUB.Add;

4601: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4602: ' ' || p_region_code ||
4603: ' ' || to_char(p_attribute_application_id) ||
4604: ' ' || p_attribute_code);
4605: FND_MSG_PUB.Add;
4606: end if;
4607:
4608: p_return_status := FND_API.G_RET_STS_SUCCESS;
4609:

Line 4610: FND_MSG_PUB.Count_And_Get (

4606: end if;
4607:
4608: p_return_status := FND_API.G_RET_STS_SUCCESS;
4609:
4610: FND_MSG_PUB.Count_And_Get (
4611: p_count => p_msg_count,
4612: p_data => p_msg_data);
4613:
4614: EXCEPTION

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

4612: p_data => p_msg_data);
4613:
4614: EXCEPTION
4615: WHEN VALUE_ERROR THEN
4616: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4617: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_VALUE_ERROR');
4618: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4619: ' ' || p_region_code ||
4620: ' ' || to_char(p_attribute_application_id) ||

Line 4622: FND_MSG_PUB.Add;

4618: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4619: ' ' || p_region_code ||
4620: ' ' || to_char(p_attribute_application_id) ||
4621: ' ' || p_attribute_code);
4622: FND_MSG_PUB.Add;
4623: end if;
4624: p_return_status := FND_API.G_RET_STS_ERROR;
4625: rollback to start_create_item;
4626: FND_MSG_PUB.Count_And_Get (

Line 4626: FND_MSG_PUB.Count_And_Get (

4622: FND_MSG_PUB.Add;
4623: end if;
4624: p_return_status := FND_API.G_RET_STS_ERROR;
4625: rollback to start_create_item;
4626: FND_MSG_PUB.Count_And_Get (
4627: p_count => p_msg_count,
4628: p_data => p_msg_data);
4629: WHEN FND_API.G_EXC_ERROR THEN
4630: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

4626: FND_MSG_PUB.Count_And_Get (
4627: p_count => p_msg_count,
4628: p_data => p_msg_data);
4629: WHEN FND_API.G_EXC_ERROR THEN
4630: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4631: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_CREATED');
4632: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4633: ' ' || p_region_code ||
4634: ' ' || to_char(p_attribute_application_id) ||

Line 4636: FND_MSG_PUB.Add;

4632: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4633: ' ' || p_region_code ||
4634: ' ' || to_char(p_attribute_application_id) ||
4635: ' ' || p_attribute_code);
4636: FND_MSG_PUB.Add;
4637: end if;
4638: p_return_status := FND_API.G_RET_STS_ERROR;
4639: rollback to start_create_item;
4640: FND_MSG_PUB.Count_And_Get (

Line 4640: FND_MSG_PUB.Count_And_Get (

4636: FND_MSG_PUB.Add;
4637: end if;
4638: p_return_status := FND_API.G_RET_STS_ERROR;
4639: rollback to start_create_item;
4640: FND_MSG_PUB.Count_And_Get (
4641: p_count => p_msg_count,
4642: p_data => p_msg_data);
4643: WHEN OTHERS THEN
4644: if (SQLCODE = -1) then

Line 4752: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

4748: );
4749: else
4750: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4751: rollback to start_create_item;
4752: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4753: SUBSTR (SQLERRM, 1, 240) );
4754: FND_MSG_PUB.Add;
4755: FND_MSG_PUB.Count_And_Get (
4756: p_count => p_msg_count,

Line 4754: FND_MSG_PUB.Add;

4750: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4751: rollback to start_create_item;
4752: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4753: SUBSTR (SQLERRM, 1, 240) );
4754: FND_MSG_PUB.Add;
4755: FND_MSG_PUB.Count_And_Get (
4756: p_count => p_msg_count,
4757: p_data => p_msg_data);
4758: end if;

Line 4755: FND_MSG_PUB.Count_And_Get (

4751: rollback to start_create_item;
4752: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4753: SUBSTR (SQLERRM, 1, 240) );
4754: FND_MSG_PUB.Add;
4755: FND_MSG_PUB.Count_And_Get (
4756: p_count => p_msg_count,
4757: p_data => p_msg_data);
4758: end if;
4759: end CREATE_ITEM;

Line 4918: FND_MSG_PUB.initialize;

4914:
4915: -- Initialize the message table if requested.
4916:
4917: if p_init_msg_tbl then
4918: FND_MSG_PUB.initialize;
4919: end if;
4920:
4921: savepoint start_create_region;
4922:

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

4925: p_api_version_number => 1.0,
4926: p_return_status => l_return_status,
4927: p_region_application_id => p_region_application_id,
4928: p_region_code => p_region_code) then
4929: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4930: FND_MESSAGE.SET_NAME('AK','AK_REGION_EXISTS');
4931: FND_MSG_PUB.Add;
4932: end if;
4933: -- dbms_output.put_line(G_PKG_NAME || 'Error - Row already exists');

Line 4931: FND_MSG_PUB.Add;

4927: p_region_application_id => p_region_application_id,
4928: p_region_code => p_region_code) then
4929: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4930: FND_MESSAGE.SET_NAME('AK','AK_REGION_EXISTS');
4931: FND_MSG_PUB.Add;
4932: end if;
4933: -- dbms_output.put_line(G_PKG_NAME || 'Error - Row already exists');
4934: raise FND_API.G_EXC_ERROR;
4935: end if;

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

5305: p_api_version_number => 1.0,
5306: p_return_status => l_return_status,
5307: p_region_application_id => p_region_application_id,
5308: p_region_code => p_region_code) then
5309: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5310: FND_MESSAGE.SET_NAME('AK','AK_INSERT_REGION_FAILED');
5311: FND_MSG_PUB.Add;
5312: end if;
5313: -- dbms_output.put_line(G_PKG_NAME || 'Error - First insert failed');

Line 5311: FND_MSG_PUB.Add;

5307: p_region_application_id => p_region_application_id,
5308: p_region_code => p_region_code) then
5309: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5310: FND_MESSAGE.SET_NAME('AK','AK_INSERT_REGION_FAILED');
5311: FND_MSG_PUB.Add;
5312: end if;
5313: -- dbms_output.put_line(G_PKG_NAME || 'Error - First insert failed');
5314: raise FND_API.G_EXC_ERROR;
5315: end if;

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

5349:
5350: -- /** commit the insert **/
5351: commit;
5352:
5353: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5354: FND_MESSAGE.SET_NAME('AK','AK_REGION_CREATED');
5355: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5356: ' ' || p_region_code);
5357: FND_MSG_PUB.Add;

Line 5357: FND_MSG_PUB.Add;

5353: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5354: FND_MESSAGE.SET_NAME('AK','AK_REGION_CREATED');
5355: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5356: ' ' || p_region_code);
5357: FND_MSG_PUB.Add;
5358: end if;
5359:
5360: p_return_status := FND_API.G_RET_STS_SUCCESS;
5361:

Line 5362: FND_MSG_PUB.Count_And_Get (

5358: end if;
5359:
5360: p_return_status := FND_API.G_RET_STS_SUCCESS;
5361:
5362: FND_MSG_PUB.Count_And_Get (
5363: p_count => p_msg_count,
5364: p_data => p_msg_data);
5365:
5366: EXCEPTION

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

5364: p_data => p_msg_data);
5365:
5366: EXCEPTION
5367: WHEN VALUE_ERROR THEN
5368: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5369: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
5370: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5371: ' ' || p_region_code);
5372: FND_MSG_PUB.Add;

Line 5372: FND_MSG_PUB.Add;

5368: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5369: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
5370: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5371: ' ' || p_region_code);
5372: FND_MSG_PUB.Add;
5373: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5374: SUBSTR (SQLERRM, 1, 240));
5375: FND_MSG_PUB.Add;
5376: end if;

Line 5373: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5369: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
5370: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5371: ' ' || p_region_code);
5372: FND_MSG_PUB.Add;
5373: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5374: SUBSTR (SQLERRM, 1, 240));
5375: FND_MSG_PUB.Add;
5376: end if;
5377: p_return_status := FND_API.G_RET_STS_ERROR;

Line 5375: FND_MSG_PUB.Add;

5371: ' ' || p_region_code);
5372: FND_MSG_PUB.Add;
5373: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5374: SUBSTR (SQLERRM, 1, 240));
5375: FND_MSG_PUB.Add;
5376: end if;
5377: p_return_status := FND_API.G_RET_STS_ERROR;
5378: rollback to start_create_region;
5379: FND_MSG_PUB.Count_And_Get (

Line 5379: FND_MSG_PUB.Count_And_Get (

5375: FND_MSG_PUB.Add;
5376: end if;
5377: p_return_status := FND_API.G_RET_STS_ERROR;
5378: rollback to start_create_region;
5379: FND_MSG_PUB.Count_And_Get (
5380: p_count => p_msg_count,
5381: p_data => p_msg_data);
5382: WHEN FND_API.G_EXC_ERROR THEN
5383: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

5379: FND_MSG_PUB.Count_And_Get (
5380: p_count => p_msg_count,
5381: p_data => p_msg_data);
5382: WHEN FND_API.G_EXC_ERROR THEN
5383: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5384: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_CREATED');
5385: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5386: ' ' || p_region_code);
5387: FND_MSG_PUB.Add;

Line 5387: FND_MSG_PUB.Add;

5383: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5384: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_CREATED');
5385: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5386: ' ' || p_region_code);
5387: FND_MSG_PUB.Add;
5388: end if;
5389: p_return_status := FND_API.G_RET_STS_ERROR;
5390: rollback to start_create_region;
5391: FND_MSG_PUB.Count_And_Get (

Line 5391: FND_MSG_PUB.Count_And_Get (

5387: FND_MSG_PUB.Add;
5388: end if;
5389: p_return_status := FND_API.G_RET_STS_ERROR;
5390: rollback to start_create_region;
5391: FND_MSG_PUB.Count_And_Get (
5392: p_count => p_msg_count,
5393: p_data => p_msg_data);
5394: WHEN OTHERS THEN
5395: if (SQLCODE = -1) then

Line 5465: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5461: );
5462: else
5463: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5464: rollback to start_create_region;
5465: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5466: SUBSTR (SQLERRM, 1, 240) );
5467: FND_MSG_PUB.Add;
5468: FND_MSG_PUB.Count_And_Get (
5469: p_count => p_msg_count,

Line 5467: FND_MSG_PUB.Add;

5463: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5464: rollback to start_create_region;
5465: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5466: SUBSTR (SQLERRM, 1, 240) );
5467: FND_MSG_PUB.Add;
5468: FND_MSG_PUB.Count_And_Get (
5469: p_count => p_msg_count,
5470: p_data => p_msg_data);
5471: end if;

Line 5468: FND_MSG_PUB.Count_And_Get (

5464: rollback to start_create_region;
5465: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5466: SUBSTR (SQLERRM, 1, 240) );
5467: FND_MSG_PUB.Add;
5468: FND_MSG_PUB.Count_And_Get (
5469: p_count => p_msg_count,
5470: p_data => p_msg_data);
5471: end if;
5472: end CREATE_REGION;

Line 5539: FND_MSG_PUB.initialize;

5535:
5536: -- Initialize the message table if requested.
5537:
5538: if p_init_msg_tbl then
5539: FND_MSG_PUB.initialize;
5540: end if;
5541:
5542: savepoint start_delete_graph;
5543:

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

5549: p_return_status => l_return_status,
5550: p_region_application_id => p_region_application_id,
5551: p_region_code => p_region_code,
5552: p_graph_number => p_graph_number) then
5553: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5554: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
5555: FND_MSG_PUB.Add;
5556: end if;
5557: raise FND_API.G_EXC_ERROR;

Line 5555: FND_MSG_PUB.Add;

5551: p_region_code => p_region_code,
5552: p_graph_number => p_graph_number) then
5553: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5554: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
5555: FND_MSG_PUB.Add;
5556: end if;
5557: raise FND_API.G_EXC_ERROR;
5558: end if;
5559:

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

5569: fetch l_get_graph_column_csr into l_attribute_application_id,
5570: l_attribute_code;
5571: if l_get_graph_column_csr%found then
5572: close l_get_graph_column_csr;
5573: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5574: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_RI');
5575: FND_MSG_PUB.Add;
5576: end if;
5577: raise FND_API.G_EXC_ERROR;

Line 5575: FND_MSG_PUB.Add;

5571: if l_get_graph_column_csr%found then
5572: close l_get_graph_column_csr;
5573: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5574: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_RI');
5575: FND_MSG_PUB.Add;
5576: end if;
5577: raise FND_API.G_EXC_ERROR;
5578: end if;
5579: close l_get_graph_column_csr;

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

5619: and region_code = p_region_code
5620: and graph_number = p_graph_number;
5621:
5622: if (sql%notfound) then
5623: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5624: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
5625: FND_MSG_PUB.Add;
5626: end if;
5627: raise FND_API.G_EXC_ERROR;

Line 5625: FND_MSG_PUB.Add;

5621:
5622: if (sql%notfound) then
5623: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5624: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
5625: FND_MSG_PUB.Add;
5626: end if;
5627: raise FND_API.G_EXC_ERROR;
5628: end if;
5629:

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

5632: and region_code = p_region_code
5633: and graph_number = p_graph_number;
5634:
5635: if (sql%notfound) then
5636: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5637: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
5638: FND_MSG_PUB.Add;
5639: end if;
5640: raise FND_API.G_EXC_ERROR;

Line 5638: FND_MSG_PUB.Add;

5634:
5635: if (sql%notfound) then
5636: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5637: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
5638: FND_MSG_PUB.Add;
5639: end if;
5640: raise FND_API.G_EXC_ERROR;
5641: end if;
5642:

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

5642:
5643: --
5644: -- Load success message
5645: --
5646: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
5647: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DELETED');
5648: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5649: ' ' || p_region_code ||
5650: ' ' || p_graph_number);

Line 5651: FND_MSG_PUB.Add;

5647: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DELETED');
5648: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5649: ' ' || p_region_code ||
5650: ' ' || p_graph_number);
5651: FND_MSG_PUB.Add;
5652: end if;
5653:
5654: p_return_status := FND_API.G_RET_STS_SUCCESS;
5655:

Line 5656: FND_MSG_PUB.Count_And_Get (

5652: end if;
5653:
5654: p_return_status := FND_API.G_RET_STS_SUCCESS;
5655:
5656: FND_MSG_PUB.Count_And_Get (
5657: p_count => p_msg_count,
5658: p_data => p_msg_data);
5659:
5660: EXCEPTION

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

5658: p_data => p_msg_data);
5659:
5660: EXCEPTION
5661: WHEN FND_API.G_EXC_ERROR THEN
5662: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5663: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_NOT_DELETED');
5664: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5665: ' ' || p_region_code ||
5666: ' ' || p_graph_number);

Line 5667: FND_MSG_PUB.Add;

5663: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_NOT_DELETED');
5664: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5665: ' ' || p_region_code ||
5666: ' ' || p_graph_number);
5667: FND_MSG_PUB.Add;
5668: end if;
5669: p_return_status := FND_API.G_RET_STS_ERROR;
5670: rollback to start_delete_graph;
5671: FND_MSG_PUB.Count_And_Get (

Line 5671: FND_MSG_PUB.Count_And_Get (

5667: FND_MSG_PUB.Add;
5668: end if;
5669: p_return_status := FND_API.G_RET_STS_ERROR;
5670: rollback to start_delete_graph;
5671: FND_MSG_PUB.Count_And_Get (
5672: p_count => p_msg_count,
5673: p_data => p_msg_data);
5674: WHEN OTHERS THEN
5675: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5677: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5673: p_data => p_msg_data);
5674: WHEN OTHERS THEN
5675: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5676: rollback to start_delete_graph;
5677: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5678: SUBSTR (SQLERRM, 1, 240) );
5679: FND_MSG_PUB.Add;
5680: FND_MSG_PUB.Count_And_Get (
5681: p_count => p_msg_count,

Line 5679: FND_MSG_PUB.Add;

5675: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5676: rollback to start_delete_graph;
5677: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5678: SUBSTR (SQLERRM, 1, 240) );
5679: FND_MSG_PUB.Add;
5680: FND_MSG_PUB.Count_And_Get (
5681: p_count => p_msg_count,
5682: p_data => p_msg_data);
5683: end DELETE_GRAPH;

Line 5680: FND_MSG_PUB.Count_And_Get (

5676: rollback to start_delete_graph;
5677: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5678: SUBSTR (SQLERRM, 1, 240) );
5679: FND_MSG_PUB.Add;
5680: FND_MSG_PUB.Count_And_Get (
5681: p_count => p_msg_count,
5682: p_data => p_msg_data);
5683: end DELETE_GRAPH;
5684: */

Line 5780: FND_MSG_PUB.initialize;

5776:
5777: -- Initialize the message table if requested.
5778:
5779: if p_init_msg_tbl then
5780: FND_MSG_PUB.initialize;
5781: end if;
5782:
5783: savepoint start_delete_item;
5784:

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

5791: p_region_application_id => p_region_application_id,
5792: p_region_code => p_region_code,
5793: p_attribute_application_id => p_attribute_application_id,
5794: p_attribute_code => p_attribute_code) then
5795: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5796: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
5797: FND_MSG_PUB.Add;
5798: end if;
5799: raise FND_API.G_EXC_ERROR;

Line 5797: FND_MSG_PUB.Add;

5793: p_attribute_application_id => p_attribute_application_id,
5794: p_attribute_code => p_attribute_code) then
5795: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5796: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
5797: FND_MSG_PUB.Add;
5798: end if;
5799: raise FND_API.G_EXC_ERROR;
5800: end if;
5801:

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

5811: fetch l_get_page_region_item_csr into l_flow_application_id, l_flow_code,
5812: l_page_application_id, l_page_code;
5813: if l_get_page_region_item_csr%found then
5814: close l_get_page_region_item_csr;
5815: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5816: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_RI');
5817: FND_MSG_PUB.Add;
5818: end if;
5819: raise FND_API.G_EXC_ERROR;

Line 5817: FND_MSG_PUB.Add;

5813: if l_get_page_region_item_csr%found then
5814: close l_get_page_region_item_csr;
5815: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5816: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_RI');
5817: FND_MSG_PUB.Add;
5818: end if;
5819: raise FND_API.G_EXC_ERROR;
5820: end if;
5821: close l_get_page_region_item_csr;

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

5847: and base_region_appl_id = l_base_region_appl_id
5848: and base_region_code = l_base_region_code;
5849:
5850: if (sql%notfound) then
5851: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5852: FND_MESSAGE.SET_NAME('AK','AK_LOV_REL_DOES_NOT_EXIST');
5853: FND_MSG_PUB.Add;
5854: end if;
5855: close l_get_lov_relations_csr;

Line 5853: FND_MSG_PUB.Add;

5849:
5850: if (sql%notfound) then
5851: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5852: FND_MESSAGE.SET_NAME('AK','AK_LOV_REL_DOES_NOT_EXIST');
5853: FND_MSG_PUB.Add;
5854: end if;
5855: close l_get_lov_relations_csr;
5856: raise FND_API.G_EXC_ERROR;
5857: end if;

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

5872: and attribute_code = p_attribute_code
5873: and category_id = l_category_id;
5874:
5875: if (sql%notfound) then
5876: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5877: FND_MESSAGE.SET_NAME('AK','AK_CAT_USAGE_DOES_NOT_EXIST');
5878: FND_MSG_PUB.Add;
5879: end if;
5880: close l_get_category_usages_csr;

Line 5878: FND_MSG_PUB.Add;

5874:
5875: if (sql%notfound) then
5876: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5877: FND_MESSAGE.SET_NAME('AK','AK_CAT_USAGE_DOES_NOT_EXIST');
5878: FND_MSG_PUB.Add;
5879: end if;
5880: close l_get_category_usages_csr;
5881: raise FND_API.G_EXC_ERROR;
5882: end if;

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

5926: and attribute_application_id = p_attribute_application_id
5927: and attribute_code = p_attribute_code;
5928:
5929: if (sql%notfound) then
5930: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5931: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
5932: FND_MSG_PUB.Add;
5933: end if;
5934: raise FND_API.G_EXC_ERROR;

Line 5932: FND_MSG_PUB.Add;

5928:
5929: if (sql%notfound) then
5930: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5931: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
5932: FND_MSG_PUB.Add;
5933: end if;
5934: raise FND_API.G_EXC_ERROR;
5935: end if;
5936:

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

5940: and attribute_application_id = p_attribute_application_id
5941: and attribute_code = p_attribute_code;
5942:
5943: if (sql%notfound) then
5944: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5945: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
5946: FND_MSG_PUB.Add;
5947: end if;
5948: raise FND_API.G_EXC_ERROR;

Line 5946: FND_MSG_PUB.Add;

5942:
5943: if (sql%notfound) then
5944: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5945: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
5946: FND_MSG_PUB.Add;
5947: end if;
5948: raise FND_API.G_EXC_ERROR;
5949: end if;
5950:

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

5950:
5951: --
5952: -- Load success message
5953: --
5954: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
5955: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DELETED');
5956: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5957: ' ' || p_region_code ||
5958: ' ' || to_char(p_attribute_application_id) ||

Line 5960: FND_MSG_PUB.Add;

5956: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5957: ' ' || p_region_code ||
5958: ' ' || to_char(p_attribute_application_id) ||
5959: ' ' || p_attribute_code);
5960: FND_MSG_PUB.Add;
5961: end if;
5962:
5963: p_return_status := FND_API.G_RET_STS_SUCCESS;
5964:

Line 5965: FND_MSG_PUB.Count_And_Get (

5961: end if;
5962:
5963: p_return_status := FND_API.G_RET_STS_SUCCESS;
5964:
5965: FND_MSG_PUB.Count_And_Get (
5966: p_count => p_msg_count,
5967: p_data => p_msg_data);
5968:
5969: EXCEPTION

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

5967: p_data => p_msg_data);
5968:
5969: EXCEPTION
5970: WHEN FND_API.G_EXC_ERROR THEN
5971: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5972: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_DELETED');
5973: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5974: ' ' || p_region_code ||
5975: ' ' || to_char(p_attribute_application_id) ||

Line 5977: FND_MSG_PUB.Add;

5973: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5974: ' ' || p_region_code ||
5975: ' ' || to_char(p_attribute_application_id) ||
5976: ' ' || p_attribute_code);
5977: FND_MSG_PUB.Add;
5978: end if;
5979: p_return_status := FND_API.G_RET_STS_ERROR;
5980: rollback to start_delete_item;
5981: FND_MSG_PUB.Count_And_Get (

Line 5981: FND_MSG_PUB.Count_And_Get (

5977: FND_MSG_PUB.Add;
5978: end if;
5979: p_return_status := FND_API.G_RET_STS_ERROR;
5980: rollback to start_delete_item;
5981: FND_MSG_PUB.Count_And_Get (
5982: p_count => p_msg_count,
5983: p_data => p_msg_data);
5984: WHEN OTHERS THEN
5985: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5987: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5983: p_data => p_msg_data);
5984: WHEN OTHERS THEN
5985: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5986: rollback to start_delete_item;
5987: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5988: SUBSTR (SQLERRM, 1, 240) );
5989: FND_MSG_PUB.Add;
5990: FND_MSG_PUB.Count_And_Get (
5991: p_count => p_msg_count,

Line 5989: FND_MSG_PUB.Add;

5985: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5986: rollback to start_delete_item;
5987: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5988: SUBSTR (SQLERRM, 1, 240) );
5989: FND_MSG_PUB.Add;
5990: FND_MSG_PUB.Count_And_Get (
5991: p_count => p_msg_count,
5992: p_data => p_msg_data);
5993: end DELETE_ITEM;

Line 5990: FND_MSG_PUB.Count_And_Get (

5986: rollback to start_delete_item;
5987: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5988: SUBSTR (SQLERRM, 1, 240) );
5989: FND_MSG_PUB.Add;
5990: FND_MSG_PUB.Count_And_Get (
5991: p_count => p_msg_count,
5992: p_data => p_msg_data);
5993: end DELETE_ITEM;
5994:

Line 6085: FND_MSG_PUB.initialize;

6081:
6082: -- Initialize the message table if requested.
6083:
6084: if p_init_msg_tbl then
6085: FND_MSG_PUB.initialize;
6086: end if;
6087:
6088: savepoint start_delete_region;
6089:

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

6096: p_api_version_number => 1.0,
6097: p_return_status => l_return_status,
6098: p_region_application_id => p_region_application_id,
6099: p_region_code => p_region_code) then
6100: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6101: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
6102: FND_MSG_PUB.Add;
6103: end if;
6104: raise FND_API.G_EXC_ERROR;

Line 6102: FND_MSG_PUB.Add;

6098: p_region_application_id => p_region_application_id,
6099: p_region_code => p_region_code) then
6100: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6101: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
6102: FND_MSG_PUB.Add;
6103: end if;
6104: raise FND_API.G_EXC_ERROR;
6105: end if;
6106: **/

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

6114: open l_is_region_a_child_csr;
6115: fetch l_is_region_a_child_csr into l_region_code, l_region_application_id;
6116: if l_is_region_a_child_csr%found then
6117: close l_is_region_a_child_csr;
6118: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6119: FND_MESSAGE.SET_NAME('AK','AK_REGION_IS_CHILD');
6120: FND_MSG_PUB.Add;
6121: end if;
6122: raise FND_API.G_EXC_ERROR;

Line 6120: FND_MSG_PUB.Add;

6116: if l_is_region_a_child_csr%found then
6117: close l_is_region_a_child_csr;
6118: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6119: FND_MESSAGE.SET_NAME('AK','AK_REGION_IS_CHILD');
6120: FND_MSG_PUB.Add;
6121: end if;
6122: raise FND_API.G_EXC_ERROR;
6123: end if;
6124: close l_is_region_a_child_csr;

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

6134: open l_get_items_csr;
6135: fetch l_get_items_csr into l_attribute_application_id, l_attribute_code;
6136: if l_get_items_csr%found then
6137: close l_get_items_csr;
6138: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6139: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_RI');
6140: FND_MSG_PUB.Add;
6141: end if;
6142: raise FND_API.G_EXC_ERROR;

Line 6140: FND_MSG_PUB.Add;

6136: if l_get_items_csr%found then
6137: close l_get_items_csr;
6138: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6139: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_RI');
6140: FND_MSG_PUB.Add;
6141: end if;
6142: raise FND_API.G_EXC_ERROR;
6143: end if;
6144: close l_get_items_csr;

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

6149: fetch l_get_page_region_csr into l_flow_application_id, l_flow_code,
6150: l_page_application_id, l_page_code;
6151: if l_get_page_region_csr%found then
6152: close l_get_page_region_csr;
6153: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6154: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_PGREG');
6155: FND_MSG_PUB.Add;
6156: end if;
6157: raise FND_API.G_EXC_ERROR;

Line 6155: FND_MSG_PUB.Add;

6151: if l_get_page_region_csr%found then
6152: close l_get_page_region_csr;
6153: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6154: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_PGREG');
6155: FND_MSG_PUB.Add;
6156: end if;
6157: raise FND_API.G_EXC_ERROR;
6158: end if;
6159: close l_get_page_region_csr;

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

6165: l_attribute_application_id, l_attribute_code,
6166: l_value_varchar2, l_value_date, l_value_number;
6167: if l_get_navigations_csr%found then
6168: close l_get_navigations_csr;
6169: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6170: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_NAV');
6171: FND_MSG_PUB.Add;
6172: end if;
6173: raise FND_API.G_EXC_ERROR;

Line 6171: FND_MSG_PUB.Add;

6167: if l_get_navigations_csr%found then
6168: close l_get_navigations_csr;
6169: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6170: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REG_NAV');
6171: FND_MSG_PUB.Add;
6172: end if;
6173: raise FND_API.G_EXC_ERROR;
6174: end if;
6175: close l_get_navigations_csr;

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

6272: where region_application_id = p_region_application_id
6273: and region_code = p_region_code;
6274:
6275: if (sql%notfound) then
6276: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6277: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
6278: FND_MSG_PUB.Add;
6279: end if;
6280: raise FND_API.G_EXC_ERROR;

Line 6278: FND_MSG_PUB.Add;

6274:
6275: if (sql%notfound) then
6276: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6277: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
6278: FND_MSG_PUB.Add;
6279: end if;
6280: raise FND_API.G_EXC_ERROR;
6281: end if;
6282:

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

6284: where region_application_id = p_region_application_id
6285: and region_code = p_region_code;
6286:
6287: if (sql%notfound) then
6288: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6289: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
6290: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_REGION',TRUE);
6291: FND_MSG_PUB.Add;
6292: end if;

Line 6291: FND_MSG_PUB.Add;

6287: if (sql%notfound) then
6288: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6289: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
6290: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_REGION',TRUE);
6291: FND_MSG_PUB.Add;
6292: end if;
6293: raise FND_API.G_EXC_ERROR;
6294: end if;
6295:

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

6295:
6296: --
6297: -- Load success message
6298: --
6299: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
6300: FND_MESSAGE.SET_NAME('AK','AK_REGION_DELETED');
6301: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6302: ' ' || p_region_code);
6303: FND_MSG_PUB.Add;

Line 6303: FND_MSG_PUB.Add;

6299: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
6300: FND_MESSAGE.SET_NAME('AK','AK_REGION_DELETED');
6301: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6302: ' ' || p_region_code);
6303: FND_MSG_PUB.Add;
6304: end if;
6305: end if; -- region exists
6306:
6307: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6309: FND_MSG_PUB.Count_And_Get (

6305: end if; -- region exists
6306:
6307: p_return_status := FND_API.G_RET_STS_SUCCESS;
6308:
6309: FND_MSG_PUB.Count_And_Get (
6310: p_count => p_msg_count,
6311: p_data => p_msg_data);
6312:
6313: EXCEPTION

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

6311: p_data => p_msg_data);
6312:
6313: EXCEPTION
6314: WHEN FND_API.G_EXC_ERROR THEN
6315: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6316: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_DELETED');
6317: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6318: ' ' || p_region_code);
6319: FND_MSG_PUB.Add;

Line 6319: FND_MSG_PUB.Add;

6315: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6316: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_DELETED');
6317: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
6318: ' ' || p_region_code);
6319: FND_MSG_PUB.Add;
6320: end if;
6321: p_return_status := FND_API.G_RET_STS_ERROR;
6322: rollback to start_delete_region;
6323: FND_MSG_PUB.Count_And_Get (

Line 6323: FND_MSG_PUB.Count_And_Get (

6319: FND_MSG_PUB.Add;
6320: end if;
6321: p_return_status := FND_API.G_RET_STS_ERROR;
6322: rollback to start_delete_region;
6323: FND_MSG_PUB.Count_And_Get (
6324: p_count => p_msg_count,
6325: p_data => p_msg_data);
6326: WHEN OTHERS THEN
6327: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6329: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

6325: p_data => p_msg_data);
6326: WHEN OTHERS THEN
6327: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6328: rollback to start_delete_region;
6329: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6330: SUBSTR (SQLERRM, 1, 240) );
6331: FND_MSG_PUB.Add;
6332: FND_MSG_PUB.Count_And_Get (
6333: p_count => p_msg_count,

Line 6331: FND_MSG_PUB.Add;

6327: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6328: rollback to start_delete_region;
6329: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6330: SUBSTR (SQLERRM, 1, 240) );
6331: FND_MSG_PUB.Add;
6332: FND_MSG_PUB.Count_And_Get (
6333: p_count => p_msg_count,
6334: p_data => p_msg_data);
6335: end DELETE_REGION;

Line 6332: FND_MSG_PUB.Count_And_Get (

6328: rollback to start_delete_region;
6329: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6330: SUBSTR (SQLERRM, 1, 240) );
6331: FND_MSG_PUB.Add;
6332: FND_MSG_PUB.Count_And_Get (
6333: p_count => p_msg_count,
6334: p_data => p_msg_data);
6335: end DELETE_REGION;
6336:

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

6481: -- - p_application_id alone, or
6482: -- - a list of region_application_id and region_code in p_object_PK_tbl
6483: if (p_application_id = FND_API.G_MISS_NUM) then
6484: if (p_region_PK_tbl.count = 0) then
6485: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6486: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
6487: FND_MSG_PUB.Add;
6488: end if;
6489: raise FND_API.G_EXC_ERROR;

Line 6487: FND_MSG_PUB.Add;

6483: if (p_application_id = FND_API.G_MISS_NUM) then
6484: if (p_region_PK_tbl.count = 0) then
6485: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6486: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
6487: FND_MSG_PUB.Add;
6488: end if;
6489: raise FND_API.G_EXC_ERROR;
6490: end if;
6491: else

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

6491: else
6492: if (p_region_PK_tbl.count > 0) then
6493: -- both application ID and a list of regions to be extracted are
6494: -- given, issue a warning that we will ignore the application ID
6495: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6496: FND_MESSAGE.SET_NAME('AK','AK_APPL_ID_IGNORED');
6497: FND_MSG_PUB.Add;
6498: end if;
6499: end if;

Line 6497: FND_MSG_PUB.Add;

6493: -- both application ID and a list of regions to be extracted are
6494: -- given, issue a warning that we will ignore the application ID
6495: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6496: FND_MESSAGE.SET_NAME('AK','AK_APPL_ID_IGNORED');
6497: FND_MSG_PUB.Add;
6498: end if;
6499: end if;
6500: end if;
6501:

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

6707: p_return_status := FND_API.G_RET_STS_SUCCESS;
6708:
6709: EXCEPTION
6710: WHEN VALUE_ERROR THEN
6711: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6712: FND_MESSAGE.SET_NAME('AK','AK_REGION_PK_VALUE_ERROR');
6713: FND_MSG_PUB.Add;
6714: end if;
6715: --dbms_output.put_line('Value error occurred - check your region list.');

Line 6713: FND_MSG_PUB.Add;

6709: EXCEPTION
6710: WHEN VALUE_ERROR THEN
6711: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6712: FND_MESSAGE.SET_NAME('AK','AK_REGION_PK_VALUE_ERROR');
6713: FND_MSG_PUB.Add;
6714: end if;
6715: --dbms_output.put_line('Value error occurred - check your region list.');
6716: p_return_status := FND_API.G_RET_STS_ERROR;
6717: WHEN FND_API.G_EXC_ERROR THEN

Line 6722: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

6718: p_return_status := FND_API.G_RET_STS_ERROR;
6719: WHEN OTHERS THEN
6720: --dbms_output.put_line(SUBSTR(SQLERRM,1,240));
6721: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6722: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6723: SUBSTR (SQLERRM, 1, 240) );
6724: FND_MSG_PUB.Add;
6725: end DOWNLOAD_REGION;
6726:

Line 6724: FND_MSG_PUB.Add;

6720: --dbms_output.put_line(SUBSTR(SQLERRM,1,240));
6721: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6722: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6723: SUBSTR (SQLERRM, 1, 240) );
6724: FND_MSG_PUB.Add;
6725: end DOWNLOAD_REGION;
6726:
6727: --=======================================================
6728: -- Procedure INSERT_REGION_PK_TABLE

Line 6804: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

6800: WHEN FND_API.G_EXC_ERROR THEN
6801: p_return_status := FND_API.G_RET_STS_ERROR;
6802: WHEN OTHERS THEN
6803: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6804: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6805: SUBSTR (SQLERRM, 1, 240) );
6806: FND_MSG_PUB.Add;
6807: end INSERT_REGION_PK_TABLE;
6808:

Line 6806: FND_MSG_PUB.Add;

6802: WHEN OTHERS THEN
6803: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6804: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6805: SUBSTR (SQLERRM, 1, 240) );
6806: FND_MSG_PUB.Add;
6807: end INSERT_REGION_PK_TABLE;
6808:
6809: /*
6810: --=======================================================

Line 6875: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

6871: p_return_status := FND_API.G_RET_STS_ERROR;
6872: return FALSE;
6873: WHEN OTHERS THEN
6874: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6875: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6876: SUBSTR (SQLERRM, 1, 240) );
6877: FND_MSG_PUB.Add;
6878: return FALSE;
6879:

Line 6877: FND_MSG_PUB.Add;

6873: WHEN OTHERS THEN
6874: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6875: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6876: SUBSTR (SQLERRM, 1, 240) );
6877: FND_MSG_PUB.Add;
6878: return FALSE;
6879:
6880: end GRAPH_EXISTS;
6881: */

Line 6950: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

6946: p_return_status := FND_API.G_RET_STS_ERROR;
6947: return FALSE;
6948: WHEN OTHERS THEN
6949: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6950: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6951: SUBSTR (SQLERRM, 1, 240) );
6952: FND_MSG_PUB.Add;
6953: return FALSE;
6954:

Line 6952: FND_MSG_PUB.Add;

6948: WHEN OTHERS THEN
6949: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6950: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
6951: SUBSTR (SQLERRM, 1, 240) );
6952: FND_MSG_PUB.Add;
6953: return FALSE;
6954:
6955: end ITEM_EXISTS;
6956:

Line 7020: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

7016: p_return_status := FND_API.G_RET_STS_ERROR;
7017: return FALSE;
7018: WHEN OTHERS THEN
7019: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7020: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
7021: SUBSTR (SQLERRM, 1, 240) );
7022: FND_MSG_PUB.Add;
7023: return FALSE;
7024: end REGION_EXISTS;

Line 7022: FND_MSG_PUB.Add;

7018: WHEN OTHERS THEN
7019: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7020: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
7021: SUBSTR (SQLERRM, 1, 240) );
7022: FND_MSG_PUB.Add;
7023: return FALSE;
7024: end REGION_EXISTS;
7025:
7026: /*

Line 7115: FND_MSG_PUB.initialize;

7111:
7112: -- Initialize the message table if requested.
7113:
7114: if p_init_msg_tbl then
7115: FND_MSG_PUB.initialize;
7116: end if;
7117:
7118: savepoint start_update_graph;
7119:

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

7123: --** retrieve ak_region_graphs row if it exists **
7124: open l_get_row_csr;
7125: fetch l_get_row_csr into l_graphs_rec;
7126: if (l_get_row_csr%notfound) then
7127: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
7128: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
7129: FND_MSG_PUB.Add;
7130: end if;
7131: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');

Line 7129: FND_MSG_PUB.Add;

7125: fetch l_get_row_csr into l_graphs_rec;
7126: if (l_get_row_csr%notfound) then
7127: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
7128: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
7129: FND_MSG_PUB.Add;
7130: end if;
7131: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
7132: close l_get_row_csr;
7133: raise FND_API.G_EXC_ERROR;

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

7137: --** retrieve ak_region_graphss_tl row if it exists **
7138: open l_get_tl_row_csr(l_lang);
7139: fetch l_get_tl_row_csr into l_graphs_tl_rec;
7140: if (l_get_tl_row_csr%notfound) then
7141: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
7142: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
7143: FND_MSG_PUB.Add;
7144: end if;
7145: -- dbms_output.put_line(l_api_name || 'Error - TL Row does not exist');

Line 7143: FND_MSG_PUB.Add;

7139: fetch l_get_tl_row_csr into l_graphs_tl_rec;
7140: if (l_get_tl_row_csr%notfound) then
7141: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
7142: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_DOES_NOT_EXIST');
7143: FND_MSG_PUB.Add;
7144: end if;
7145: -- dbms_output.put_line(l_api_name || 'Error - TL Row does not exist');
7146: close l_get_tl_row_csr;
7147: raise FND_API.G_EXC_ERROR;

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

7232: where REGION_APPLICATION_ID = p_region_application_id
7233: and REGION_CODE = p_region_code
7234: and GRAPH_NUMBER = p_graph_number;
7235: if (sql%notfound) then
7236: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7237: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_UPDATE_FAILED');
7238: FND_MSG_PUB.Add;
7239: end if;
7240: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');

Line 7238: FND_MSG_PUB.Add;

7234: and GRAPH_NUMBER = p_graph_number;
7235: if (sql%notfound) then
7236: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7237: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_UPDATE_FAILED');
7238: FND_MSG_PUB.Add;
7239: end if;
7240: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');
7241: raise FND_API.G_EXC_ERROR;
7242: end if;

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

7252: and REGION_CODE = p_region_code
7253: and GRAPH_NUMBER = p_graph_number
7254: and l_lang in (LANGUAGE, SOURCE_LANG);
7255: if (sql%notfound) then
7256: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7257: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_UPDATE_FAILED');
7258: FND_MSG_PUB.Add;
7259: end if;
7260: --dbms_output.put_line(l_api_name || 'TL Row does not exist during update');

Line 7258: FND_MSG_PUB.Add;

7254: and l_lang in (LANGUAGE, SOURCE_LANG);
7255: if (sql%notfound) then
7256: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7257: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_UPDATE_FAILED');
7258: FND_MSG_PUB.Add;
7259: end if;
7260: --dbms_output.put_line(l_api_name || 'TL Row does not exist during update');
7261: raise FND_API.G_EXC_ERROR;
7262: end if;

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

7263:
7264: -- ** commit the update **
7265: commit;
7266:
7267: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
7268: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_UPDATED');
7269: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
7270: ' ' || p_region_code ||
7271: ' ' || p_graph_number);

Line 7272: FND_MSG_PUB.Add;

7268: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_UPDATED');
7269: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
7270: ' ' || p_region_code ||
7271: ' ' || p_graph_number);
7272: FND_MSG_PUB.Add;
7273: end if;
7274:
7275: p_return_status := FND_API.G_RET_STS_SUCCESS;
7276:

Line 7277: FND_MSG_PUB.Count_And_Get (

7273: end if;
7274:
7275: p_return_status := FND_API.G_RET_STS_SUCCESS;
7276:
7277: FND_MSG_PUB.Count_And_Get (
7278: p_count => p_msg_count,
7279: p_data => p_msg_data);
7280:
7281: EXCEPTION

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

7279: p_data => p_msg_data);
7280:
7281: EXCEPTION
7282: WHEN VALUE_ERROR THEN
7283: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7284: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_VALUE_ERROR');
7285: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
7286: ' ' || p_region_code ||
7287: ' ' || p_graph_number);

Line 7288: FND_MSG_PUB.Add;

7284: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_VALUE_ERROR');
7285: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
7286: ' ' || p_region_code ||
7287: ' ' || p_graph_number);
7288: FND_MSG_PUB.Add;
7289: end if;
7290: rollback to start_update_graph;
7291: p_return_status := FND_API.G_RET_STS_ERROR;
7292: FND_MSG_PUB.Count_And_Get (

Line 7292: FND_MSG_PUB.Count_And_Get (

7288: FND_MSG_PUB.Add;
7289: end if;
7290: rollback to start_update_graph;
7291: p_return_status := FND_API.G_RET_STS_ERROR;
7292: FND_MSG_PUB.Count_And_Get (
7293: p_count => p_msg_count,
7294: p_data => p_msg_data);
7295: WHEN FND_API.G_EXC_ERROR THEN
7296: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

7292: FND_MSG_PUB.Count_And_Get (
7293: p_count => p_msg_count,
7294: p_data => p_msg_data);
7295: WHEN FND_API.G_EXC_ERROR THEN
7296: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7297: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_NOT_UPDATED');
7298: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
7299: ' ' || p_region_code ||
7300: ' ' || p_graph_number);

Line 7301: FND_MSG_PUB.Add;

7297: FND_MESSAGE.SET_NAME('AK','AK_REG_GRAPH_NOT_UPDATED');
7298: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
7299: ' ' || p_region_code ||
7300: ' ' || p_graph_number);
7301: FND_MSG_PUB.Add;
7302: end if;
7303: p_return_status := FND_API.G_RET_STS_ERROR;
7304: rollback to start_update_graph;
7305: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 7305: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

7301: FND_MSG_PUB.Add;
7302: end if;
7303: p_return_status := FND_API.G_RET_STS_ERROR;
7304: rollback to start_update_graph;
7305: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
7306: SUBSTR (SQLERRM, 1, 240) );
7307: FND_MSG_PUB.Add;
7308: FND_MSG_PUB.Count_And_Get (
7309: p_count => p_msg_count,

Line 7307: FND_MSG_PUB.Add;

7303: p_return_status := FND_API.G_RET_STS_ERROR;
7304: rollback to start_update_graph;
7305: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
7306: SUBSTR (SQLERRM, 1, 240) );
7307: FND_MSG_PUB.Add;
7308: FND_MSG_PUB.Count_And_Get (
7309: p_count => p_msg_count,
7310: p_data => p_msg_data);
7311: end UPDATE_GRAPH;

Line 7308: FND_MSG_PUB.Count_And_Get (

7304: rollback to start_update_graph;
7305: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
7306: SUBSTR (SQLERRM, 1, 240) );
7307: FND_MSG_PUB.Add;
7308: FND_MSG_PUB.Count_And_Get (
7309: p_count => p_msg_count,
7310: p_data => p_msg_data);
7311: end UPDATE_GRAPH;
7312: */

Line 7487: FND_MSG_PUB.initialize;

7483:
7484: -- Initialize the message table if requested.
7485:
7486: if p_init_msg_tbl then
7487: FND_MSG_PUB.initialize;
7488: end if;
7489:
7490: savepoint start_update_item;
7491:

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

7495: --** retrieve ak_region_items row if it exists **
7496: open l_get_row_csr;
7497: fetch l_get_row_csr into l_items_rec;
7498: if (l_get_row_csr%notfound) then
7499: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
7500: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
7501: FND_MSG_PUB.Add;
7502: end if;
7503: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');

Line 7501: FND_MSG_PUB.Add;

7497: fetch l_get_row_csr into l_items_rec;
7498: if (l_get_row_csr%notfound) then
7499: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
7500: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
7501: FND_MSG_PUB.Add;
7502: end if;
7503: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
7504: close l_get_row_csr;
7505: raise FND_API.G_EXC_ERROR;

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

7509: --** retrieve ak_region_items_tl row if it exists **
7510: open l_get_tl_row_csr(l_lang);
7511: fetch l_get_tl_row_csr into l_items_tl_rec;
7512: if (l_get_tl_row_csr%notfound) then
7513: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
7514: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
7515: FND_MSG_PUB.Add;
7516: end if;
7517: -- dbms_output.put_line(l_api_name || 'Error - TL Row does not exist');

Line 7515: FND_MSG_PUB.Add;

7511: fetch l_get_tl_row_csr into l_items_tl_rec;
7512: if (l_get_tl_row_csr%notfound) then
7513: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
7514: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_DOES_NOT_EXIST');
7515: FND_MSG_PUB.Add;
7516: end if;
7517: -- dbms_output.put_line(l_api_name || 'Error - TL Row does not exist');
7518: close l_get_tl_row_csr;
7519: raise FND_API.G_EXC_ERROR;

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

8160: and REGION_CODE = p_region_code
8161: and attribute_application_id = p_attribute_application_id
8162: and attribute_code = p_attribute_code;
8163: if (sql%notfound) then
8164: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8165: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_UPDATE_FAILED');
8166: FND_MSG_PUB.Add;
8167: end if;
8168: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');

Line 8166: FND_MSG_PUB.Add;

8162: and attribute_code = p_attribute_code;
8163: if (sql%notfound) then
8164: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8165: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_UPDATE_FAILED');
8166: FND_MSG_PUB.Add;
8167: end if;
8168: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');
8169: raise FND_API.G_EXC_ERROR;
8170: end if;

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

8182: and attribute_application_id = p_attribute_application_id
8183: and attribute_code = p_attribute_code
8184: and l_lang in (LANGUAGE, SOURCE_LANG);
8185: if (sql%notfound) then
8186: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8187: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_UPDATE_FAILED');
8188: FND_MSG_PUB.Add;
8189: end if;
8190: --dbms_output.put_line(l_api_name || 'TL Row does not exist during update');

Line 8188: FND_MSG_PUB.Add;

8184: and l_lang in (LANGUAGE, SOURCE_LANG);
8185: if (sql%notfound) then
8186: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8187: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_UPDATE_FAILED');
8188: FND_MSG_PUB.Add;
8189: end if;
8190: --dbms_output.put_line(l_api_name || 'TL Row does not exist during update');
8191: raise FND_API.G_EXC_ERROR;
8192: end if;

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

8193:
8194: -- /** commit the update **/
8195: commit;
8196:
8197: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
8198: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_UPDATED');
8199: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8200: ' ' || p_region_code ||
8201: ' ' || to_char(p_attribute_application_id) ||

Line 8203: FND_MSG_PUB.Add;

8199: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8200: ' ' || p_region_code ||
8201: ' ' || to_char(p_attribute_application_id) ||
8202: ' ' || p_attribute_code);
8203: FND_MSG_PUB.Add;
8204: end if;
8205:
8206: end if;
8207: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8209: FND_MSG_PUB.Count_And_Get (

8205:
8206: end if;
8207: p_return_status := FND_API.G_RET_STS_SUCCESS;
8208:
8209: FND_MSG_PUB.Count_And_Get (
8210: p_count => p_msg_count,
8211: p_data => p_msg_data);
8212:
8213: EXCEPTION

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

8211: p_data => p_msg_data);
8212:
8213: EXCEPTION
8214: WHEN VALUE_ERROR THEN
8215: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8216: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_VALUE_ERROR');
8217: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8218: ' ' || p_region_code ||
8219: ' ' || to_char(p_attribute_application_id) ||

Line 8221: FND_MSG_PUB.Add;

8217: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8218: ' ' || p_region_code ||
8219: ' ' || to_char(p_attribute_application_id) ||
8220: ' ' || p_attribute_code);
8221: FND_MSG_PUB.Add;
8222: end if;
8223: rollback to start_update_item;
8224: p_return_status := FND_API.G_RET_STS_ERROR;
8225: FND_MSG_PUB.Count_And_Get (

Line 8225: FND_MSG_PUB.Count_And_Get (

8221: FND_MSG_PUB.Add;
8222: end if;
8223: rollback to start_update_item;
8224: p_return_status := FND_API.G_RET_STS_ERROR;
8225: FND_MSG_PUB.Count_And_Get (
8226: p_count => p_msg_count,
8227: p_data => p_msg_data);
8228: WHEN FND_API.G_EXC_ERROR THEN
8229: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

8225: FND_MSG_PUB.Count_And_Get (
8226: p_count => p_msg_count,
8227: p_data => p_msg_data);
8228: WHEN FND_API.G_EXC_ERROR THEN
8229: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8230: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_UPDATED');
8231: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8232: ' ' || p_region_code ||
8233: ' ' || to_char(p_attribute_application_id) ||

Line 8235: FND_MSG_PUB.Add;

8231: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8232: ' ' || p_region_code ||
8233: ' ' || to_char(p_attribute_application_id) ||
8234: ' ' || p_attribute_code);
8235: FND_MSG_PUB.Add;
8236: end if;
8237: p_return_status := FND_API.G_RET_STS_ERROR;
8238: rollback to start_update_item;
8239: FND_MSG_PUB.Count_And_Get (

Line 8239: FND_MSG_PUB.Count_And_Get (

8235: FND_MSG_PUB.Add;
8236: end if;
8237: p_return_status := FND_API.G_RET_STS_ERROR;
8238: rollback to start_update_item;
8239: FND_MSG_PUB.Count_And_Get (
8240: p_count => p_msg_count,
8241: p_data => p_msg_data);
8242: WHEN OTHERS THEN
8243: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8245: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

8241: p_data => p_msg_data);
8242: WHEN OTHERS THEN
8243: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8244: rollback to start_update_item;
8245: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8246: SUBSTR (SQLERRM, 1, 240) );
8247: FND_MSG_PUB.Add;
8248: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_UPDATED');
8249: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

Line 8247: FND_MSG_PUB.Add;

8243: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8244: rollback to start_update_item;
8245: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8246: SUBSTR (SQLERRM, 1, 240) );
8247: FND_MSG_PUB.Add;
8248: FND_MESSAGE.SET_NAME('AK','AK_REG_ITEM_NOT_UPDATED');
8249: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8250: ' ' || p_region_code ||
8251: ' ' || to_char(p_attribute_application_id) ||

Line 8253: FND_MSG_PUB.Add;

8249: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8250: ' ' || p_region_code ||
8251: ' ' || to_char(p_attribute_application_id) ||
8252: ' ' || p_attribute_code);
8253: FND_MSG_PUB.Add;
8254: FND_MSG_PUB.Count_And_Get (
8255: p_count => p_msg_count,
8256: p_data => p_msg_data);
8257: end UPDATE_ITEM;

Line 8254: FND_MSG_PUB.Count_And_Get (

8250: ' ' || p_region_code ||
8251: ' ' || to_char(p_attribute_application_id) ||
8252: ' ' || p_attribute_code);
8253: FND_MSG_PUB.Add;
8254: FND_MSG_PUB.Count_And_Get (
8255: p_count => p_msg_count,
8256: p_data => p_msg_data);
8257: end UPDATE_ITEM;
8258:

Line 8385: FND_MSG_PUB.initialize;

8381:
8382: -- Initialize the message table if requested.
8383:
8384: if p_init_msg_tbl then
8385: FND_MSG_PUB.initialize;
8386: end if;
8387:
8388: savepoint start_update_region;
8389:

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

8393: --** retrieve ak_regions row if it exists **
8394: open l_get_row_csr;
8395: fetch l_get_row_csr into l_regions_rec;
8396: if (l_get_row_csr%notfound) then
8397: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
8398: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
8399: FND_MSG_PUB.Add;
8400: end if;
8401: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');

Line 8399: FND_MSG_PUB.Add;

8395: fetch l_get_row_csr into l_regions_rec;
8396: if (l_get_row_csr%notfound) then
8397: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
8398: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
8399: FND_MSG_PUB.Add;
8400: end if;
8401: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
8402: close l_get_row_csr;
8403: raise FND_API.G_EXC_ERROR;

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

8407: --** retrieve ak_regions_tl row if it exists **
8408: open l_get_tl_row_csr(l_lang);
8409: fetch l_get_tl_row_csr into l_regions_tl_rec;
8410: if (l_get_tl_row_csr%notfound) then
8411: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
8412: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
8413: FND_MSG_PUB.Add;
8414: end if;
8415: --dbms_output.put_line(l_api_name || 'Error - TL Row does not exist');

Line 8413: FND_MSG_PUB.Add;

8409: fetch l_get_tl_row_csr into l_regions_tl_rec;
8410: if (l_get_tl_row_csr%notfound) then
8411: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
8412: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
8413: FND_MSG_PUB.Add;
8414: end if;
8415: --dbms_output.put_line(l_api_name || 'Error - TL Row does not exist');
8416: close l_get_tl_row_csr;
8417: raise FND_API.G_EXC_ERROR;

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

8732: LAST_UPDATE_LOGIN = l_last_update_login
8733: where REGION_APPLICATION_ID = p_region_application_id
8734: and REGION_CODE = p_region_code;
8735: if (sql%notfound) then
8736: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8737: FND_MESSAGE.SET_NAME('AK','AK_REGION_UPDATE_FAILED');
8738: FND_MSG_PUB.Add;
8739: end if;
8740: raise FND_API.G_EXC_ERROR;

Line 8738: FND_MSG_PUB.Add;

8734: and REGION_CODE = p_region_code;
8735: if (sql%notfound) then
8736: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8737: FND_MESSAGE.SET_NAME('AK','AK_REGION_UPDATE_FAILED');
8738: FND_MSG_PUB.Add;
8739: end if;
8740: raise FND_API.G_EXC_ERROR;
8741: end if;
8742:

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

8751: and REGION_CODE = p_region_code
8752: and l_lang in (LANGUAGE, SOURCE_LANG);
8753:
8754: if (sql%notfound) then
8755: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8756: FND_MESSAGE.SET_NAME('AK','AK_REGION_UPDATE_FAILED');
8757: FND_MSG_PUB.Add;
8758: end if;
8759: raise FND_API.G_EXC_ERROR;

Line 8757: FND_MSG_PUB.Add;

8753:
8754: if (sql%notfound) then
8755: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8756: FND_MESSAGE.SET_NAME('AK','AK_REGION_UPDATE_FAILED');
8757: FND_MSG_PUB.Add;
8758: end if;
8759: raise FND_API.G_EXC_ERROR;
8760: end if;
8761:

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

8761:
8762: -- /** commit the update **/
8763: commit;
8764:
8765: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
8766: FND_MESSAGE.SET_NAME('AK','AK_REGION_UPDATED');
8767: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8768: ' ' || p_region_code);
8769: FND_MSG_PUB.Add;

Line 8769: FND_MSG_PUB.Add;

8765: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
8766: FND_MESSAGE.SET_NAME('AK','AK_REGION_UPDATED');
8767: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8768: ' ' || p_region_code);
8769: FND_MSG_PUB.Add;
8770: end if;
8771:
8772: end if;
8773: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8775: FND_MSG_PUB.Count_And_Get (

8771:
8772: end if;
8773: p_return_status := FND_API.G_RET_STS_SUCCESS;
8774:
8775: FND_MSG_PUB.Count_And_Get (
8776: p_count => p_msg_count,
8777: p_data => p_msg_data);
8778:
8779: EXCEPTION

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

8777: p_data => p_msg_data);
8778:
8779: EXCEPTION
8780: WHEN VALUE_ERROR THEN
8781: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8782: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
8783: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8784: ' ' || p_region_code);
8785: FND_MSG_PUB.Add;

Line 8785: FND_MSG_PUB.Add;

8781: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8782: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
8783: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8784: ' ' || p_region_code);
8785: FND_MSG_PUB.Add;
8786: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8787: SUBSTR (SQLERRM, 1, 240));
8788: FND_MSG_PUB.Add;
8789:

Line 8786: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

8782: FND_MESSAGE.SET_NAME('AK','AK_REGION_VALUE_ERROR');
8783: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8784: ' ' || p_region_code);
8785: FND_MSG_PUB.Add;
8786: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8787: SUBSTR (SQLERRM, 1, 240));
8788: FND_MSG_PUB.Add;
8789:
8790: end if;

Line 8788: FND_MSG_PUB.Add;

8784: ' ' || p_region_code);
8785: FND_MSG_PUB.Add;
8786: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8787: SUBSTR (SQLERRM, 1, 240));
8788: FND_MSG_PUB.Add;
8789:
8790: end if;
8791: rollback to start_update_region;
8792: p_return_status := FND_API.G_RET_STS_ERROR;

Line 8793: FND_MSG_PUB.Count_And_Get (

8789:
8790: end if;
8791: rollback to start_update_region;
8792: p_return_status := FND_API.G_RET_STS_ERROR;
8793: FND_MSG_PUB.Count_And_Get (
8794: p_count => p_msg_count,
8795: p_data => p_msg_data);
8796: WHEN FND_API.G_EXC_ERROR THEN
8797: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

8793: FND_MSG_PUB.Count_And_Get (
8794: p_count => p_msg_count,
8795: p_data => p_msg_data);
8796: WHEN FND_API.G_EXC_ERROR THEN
8797: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8798: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_UPDATED');
8799: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8800: ' ' || p_region_code);
8801: FND_MSG_PUB.Add;

Line 8801: FND_MSG_PUB.Add;

8797: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8798: FND_MESSAGE.SET_NAME('AK','AK_REGION_NOT_UPDATED');
8799: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
8800: ' ' || p_region_code);
8801: FND_MSG_PUB.Add;
8802: end if;
8803: p_return_status := FND_API.G_RET_STS_ERROR;
8804: rollback to start_update_region;
8805: FND_MSG_PUB.Count_And_Get (

Line 8805: FND_MSG_PUB.Count_And_Get (

8801: FND_MSG_PUB.Add;
8802: end if;
8803: p_return_status := FND_API.G_RET_STS_ERROR;
8804: rollback to start_update_region;
8805: FND_MSG_PUB.Count_And_Get (
8806: p_count => p_msg_count,
8807: p_data => p_msg_data);
8808: WHEN OTHERS THEN
8809: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8811: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

8807: p_data => p_msg_data);
8808: WHEN OTHERS THEN
8809: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8810: rollback to start_update_region;
8811: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8812: SUBSTR (SQLERRM, 1, 240) );
8813: FND_MSG_PUB.Add;
8814: FND_MSG_PUB.Count_And_Get (
8815: p_count => p_msg_count,

Line 8813: FND_MSG_PUB.Add;

8809: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8810: rollback to start_update_region;
8811: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8812: SUBSTR (SQLERRM, 1, 240) );
8813: FND_MSG_PUB.Add;
8814: FND_MSG_PUB.Count_And_Get (
8815: p_count => p_msg_count,
8816: p_data => p_msg_data);
8817: FND_MSG_PUB.Count_And_Get (

Line 8814: FND_MSG_PUB.Count_And_Get (

8810: rollback to start_update_region;
8811: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
8812: SUBSTR (SQLERRM, 1, 240) );
8813: FND_MSG_PUB.Add;
8814: FND_MSG_PUB.Count_And_Get (
8815: p_count => p_msg_count,
8816: p_data => p_msg_data);
8817: FND_MSG_PUB.Count_And_Get (
8818: p_count => p_msg_count,

Line 8817: FND_MSG_PUB.Count_And_Get (

8813: FND_MSG_PUB.Add;
8814: FND_MSG_PUB.Count_And_Get (
8815: p_count => p_msg_count,
8816: p_data => p_msg_data);
8817: FND_MSG_PUB.Count_And_Get (
8818: p_count => p_msg_count,
8819: p_data => p_msg_data);
8820: end UPDATE_REGION;
8821: