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_FLOW3_PVT dependencies on FND_MSG_PUB

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

85: --** check that key columns are not null and not missing **
86: if ((p_flow_application_id is null) or
87: (p_flow_application_id = FND_API.G_MISS_NUM)) then
88: l_error := TRUE;
89: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
90: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
91: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_APPLICATION_ID');
92: FND_MSG_PUB.Add;
93: end if;

Line 92: FND_MSG_PUB.Add;

88: l_error := TRUE;
89: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
90: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
91: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_APPLICATION_ID');
92: FND_MSG_PUB.Add;
93: end if;
94: end if;
95:
96: if ((p_flow_code is null) or

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

95:
96: if ((p_flow_code is null) or
97: (p_flow_code = FND_API.G_MISS_CHAR)) then
98: l_error := TRUE;
99: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
100: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
101: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_CODE');
102: FND_MSG_PUB.Add;
103: end if;

Line 102: FND_MSG_PUB.Add;

98: l_error := TRUE;
99: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
100: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
101: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_CODE');
102: FND_MSG_PUB.Add;
103: end if;
104: end if;
105:
106: --** check that required columns are not null and, unless calling **

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

108: if ((p_primary_page_appl_id is null) or
109: (p_primary_page_appl_id = FND_API.G_MISS_NUM and
110: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
111: l_error := TRUE;
112: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
113: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
114: FND_MESSAGE.SET_TOKEN('COLUMN', 'PRIMARY_PAGE_APPL_ID');
115: FND_MSG_PUB.Add;
116: end if;

Line 115: FND_MSG_PUB.Add;

111: l_error := TRUE;
112: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
113: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
114: FND_MESSAGE.SET_TOKEN('COLUMN', 'PRIMARY_PAGE_APPL_ID');
115: FND_MSG_PUB.Add;
116: end if;
117: end if;
118:
119: if ((p_primary_page_code is null) or

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

119: if ((p_primary_page_code is null) or
120: (p_primary_page_code = FND_API.G_MISS_CHAR and
121: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
122: l_error := TRUE;
123: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
124: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
125: FND_MESSAGE.SET_TOKEN('COLUMN', 'PRIMARY_PAGE_CODE');
126: FND_MSG_PUB.Add;
127: end if;

Line 126: FND_MSG_PUB.Add;

122: l_error := TRUE;
123: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
124: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
125: FND_MESSAGE.SET_TOKEN('COLUMN', 'PRIMARY_PAGE_CODE');
126: FND_MSG_PUB.Add;
127: end if;
128: end if;
129:
130: if ((p_name is null) or

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

130: if ((p_name is null) or
131: (p_name = FND_API.G_MISS_CHAR and
132: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
133: l_error := TRUE;
134: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
135: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
136: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
137: FND_MSG_PUB.Add;
138: end if;

Line 137: FND_MSG_PUB.Add;

133: l_error := TRUE;
134: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
135: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
136: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
137: FND_MSG_PUB.Add;
138: end if;
139: end if;
140:
141:

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

154: open l_check_no_page_csr;
155: fetch l_check_no_page_csr into l_dummy;
156: if (l_check_no_page_csr%found) then
157: l_error := TRUE;
158: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
159: FND_MESSAGE.SET_NAME('AK','NO_FLOW_DEFAULT_PAGE');
160: FND_MSG_PUB.Add;
161: end if;
162: end if; /* if l_check_no_page_found */

Line 160: FND_MSG_PUB.Add;

156: if (l_check_no_page_csr%found) then
157: l_error := TRUE;
158: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
159: FND_MESSAGE.SET_NAME('AK','NO_FLOW_DEFAULT_PAGE');
160: FND_MSG_PUB.Add;
161: end if;
162: end if; /* if l_check_no_page_found */
163: close l_check_no_page_csr;
164: else

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

171: p_flow_code => p_flow_code,
172: p_page_application_id => p_primary_page_appl_id,
173: p_page_code => p_primary_page_code) then
174: l_error := TRUE;
175: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
176: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FLOW_PG_REFERENCE');
177: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
178: ' ' || p_flow_code ||
179: ' ' || to_char(p_primary_page_appl_id) ||

Line 181: FND_MSG_PUB.Add;

177: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
178: ' ' || p_flow_code ||
179: ' ' || to_char(p_primary_page_appl_id) ||
180: ' ' || p_primary_page_code);
181: FND_MSG_PUB.Add;
182: end if;
183: end if; /* if PAGE_EXISTS */
184: end if; -- /* if p_primary_page_code */
185: end if;

Line 196: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

192: p_return_status := FND_API.G_RET_STS_ERROR;
193: return FALSE;
194: WHEN OTHERS THEN
195: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
197: SUBSTR (SQLERRM, 1, 240) );
198: FND_MSG_PUB.Add;
199: return FALSE;
200: end VALIDATE_FLOW;

Line 198: FND_MSG_PUB.Add;

194: WHEN OTHERS THEN
195: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
197: SUBSTR (SQLERRM, 1, 240) );
198: FND_MSG_PUB.Add;
199: return FALSE;
200: end VALIDATE_FLOW;
201:
202: --=======================================================

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

277: --** check that key columns are not null and not missing **
278: if ((p_flow_application_id is null) or
279: (p_flow_application_id = FND_API.G_MISS_NUM)) then
280: l_error := TRUE;
281: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
282: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
283: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_APPLICATION_ID');
284: FND_MSG_PUB.Add;
285: end if;

Line 284: FND_MSG_PUB.Add;

280: l_error := TRUE;
281: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
282: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
283: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_APPLICATION_ID');
284: FND_MSG_PUB.Add;
285: end if;
286: end if;
287:
288: if ((p_flow_code is null) or

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

287:
288: if ((p_flow_code is null) or
289: (p_flow_code = FND_API.G_MISS_CHAR)) then
290: l_error := TRUE;
291: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
292: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
293: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_CODE');
294: FND_MSG_PUB.Add;
295: end if;

Line 294: FND_MSG_PUB.Add;

290: l_error := TRUE;
291: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
292: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
293: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_CODE');
294: FND_MSG_PUB.Add;
295: end if;
296: end if;
297:
298: if ((p_page_application_id is null) or

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

297:
298: if ((p_page_application_id is null) or
299: (p_page_application_id = FND_API.G_MISS_NUM)) then
300: l_error := TRUE;
301: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
302: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
303: FND_MESSAGE.SET_TOKEN('COLUMN', 'PAGE_APPLICATION_ID');
304: FND_MSG_PUB.Add;
305: end if;

Line 304: FND_MSG_PUB.Add;

300: l_error := TRUE;
301: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
302: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
303: FND_MESSAGE.SET_TOKEN('COLUMN', 'PAGE_APPLICATION_ID');
304: FND_MSG_PUB.Add;
305: end if;
306: end if;
307:
308: if ((p_page_code is null) or

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

307:
308: if ((p_page_code is null) or
309: (p_page_code = FND_API.G_MISS_CHAR)) then
310: l_error := TRUE;
311: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
312: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
313: FND_MESSAGE.SET_TOKEN('COLUMN', 'PAGE_CODE');
314: FND_MSG_PUB.Add;
315: end if;

Line 314: FND_MSG_PUB.Add;

310: l_error := TRUE;
311: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
312: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
313: FND_MESSAGE.SET_TOKEN('COLUMN', 'PAGE_CODE');
314: FND_MSG_PUB.Add;
315: end if;
316: end if;
317:
318: --

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

323: p_return_status => l_return_status,
324: p_flow_application_id => p_flow_application_id,
325: p_flow_code => p_flow_code) ) then
326: l_error := TRUE;
327: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
328: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FLOW_REFERENCE');
329: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
330: ' ' || p_flow_code );
331: FND_MSG_PUB.Add;

Line 331: FND_MSG_PUB.Add;

327: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
328: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FLOW_REFERENCE');
329: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
330: ' ' || p_flow_code );
331: FND_MSG_PUB.Add;
332: end if;
333: --dbms_output.put_line('Parent flow does not exist!');
334: end if;
335:

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

338: if ((p_primary_region_appl_id is null) or
339: (p_primary_region_appl_id = FND_API.G_MISS_NUM and
340: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
341: l_error := TRUE;
342: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
343: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
344: FND_MESSAGE.SET_TOKEN('COLUMN', 'PRIMARY_REGION_APPL_ID');
345: FND_MSG_PUB.Add;
346: end if;

Line 345: FND_MSG_PUB.Add;

341: l_error := TRUE;
342: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
343: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
344: FND_MESSAGE.SET_TOKEN('COLUMN', 'PRIMARY_REGION_APPL_ID');
345: FND_MSG_PUB.Add;
346: end if;
347: end if;
348:
349: if ((p_primary_region_code is null) or

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

349: if ((p_primary_region_code is null) or
350: (p_primary_region_code = FND_API.G_MISS_CHAR and
351: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
352: l_error := TRUE;
353: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
354: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
355: FND_MESSAGE.SET_TOKEN('COLUMN', 'PRIMARY_REGION_CODE');
356: FND_MSG_PUB.Add;
357: end if;

Line 356: FND_MSG_PUB.Add;

352: l_error := TRUE;
353: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
354: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
355: FND_MESSAGE.SET_TOKEN('COLUMN', 'PRIMARY_REGION_CODE');
356: FND_MSG_PUB.Add;
357: end if;
358: end if;
359:
360: if ((p_name is null) or

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

360: if ((p_name is null) or
361: (p_name = FND_API.G_MISS_CHAR and
362: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
363: l_error := TRUE;
364: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
365: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
366: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
367: FND_MSG_PUB.Add;
368: end if;

Line 367: FND_MSG_PUB.Add;

363: l_error := TRUE;
364: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
365: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
366: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
367: FND_MSG_PUB.Add;
368: end if;
369: end if;
370:
371: --** Validate columns **

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

383: open l_check_no_region_csr;
384: fetch l_check_no_region_csr into l_dummy;
385: if (l_check_no_region_csr%found) then
386: l_error := TRUE;
387: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
388: FND_MESSAGE.SET_NAME('AK','NO_PAGE_ROOT_REGION');
389: FND_MSG_PUB.Add;
390: end if;
391: end if; /* if l_check_no_region_csr%found */

Line 389: FND_MSG_PUB.Add;

385: if (l_check_no_region_csr%found) then
386: l_error := TRUE;
387: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
388: FND_MESSAGE.SET_NAME('AK','NO_PAGE_ROOT_REGION');
389: FND_MSG_PUB.Add;
390: end if;
391: end if; /* if l_check_no_region_csr%found */
392: close l_check_no_region_csr;
393: else

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

400: p_page_code => p_page_code,
401: p_region_application_id => p_primary_region_appl_id,
402: p_region_code => p_primary_region_code) then
403: l_error := TRUE;
404: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
405: FND_MESSAGE.SET_NAME('AK','AK_INVALID_PG_REGION_REFERENCE');
406: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
407: ' ' || p_flow_code ||
408: ' ' || to_char(p_page_application_id) ||

Line 412: FND_MSG_PUB.Add;

408: ' ' || to_char(p_page_application_id) ||
409: ' ' || p_page_code ||
410: ' ' || to_char(p_primary_region_appl_id) ||
411: ' ' || p_primary_region_code);
412: FND_MSG_PUB.Add;
413: end if;
414: end if; /* if PAGE_REGION_EXISTS */
415: end if;
416: end if;

Line 428: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

424: p_return_status := FND_API.G_RET_STS_ERROR;
425: return FALSE;
426: WHEN OTHERS THEN
427: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
429: SUBSTR (SQLERRM, 1, 240) );
430: FND_MSG_PUB.Add;
431: return FALSE;
432:

Line 430: FND_MSG_PUB.Add;

426: WHEN OTHERS THEN
427: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
429: SUBSTR (SQLERRM, 1, 240) );
430: FND_MSG_PUB.Add;
431: return FALSE;
432:
433: end VALIDATE_PAGE;
434:

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

532: --** check that key columns are not null and not missing **
533: if ((p_flow_application_id is null) or
534: (p_flow_application_id = FND_API.G_MISS_NUM)) then
535: l_error := TRUE;
536: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
537: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
538: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_APPLICATION_ID');
539: FND_MSG_PUB.Add;
540: end if;

Line 539: FND_MSG_PUB.Add;

535: l_error := TRUE;
536: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
537: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
538: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_APPLICATION_ID');
539: FND_MSG_PUB.Add;
540: end if;
541: end if;
542:
543: if ((p_flow_code 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:
543: if ((p_flow_code is null) or
544: (p_flow_code = FND_API.G_MISS_CHAR)) 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', 'FLOW_CODE');
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', 'FLOW_CODE');
549: FND_MSG_PUB.Add;
550: end if;
551: end if;
552:
553: if ((p_page_application_id is null) or

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

552:
553: if ((p_page_application_id is null) or
554: (p_page_application_id = FND_API.G_MISS_NUM)) then
555: l_error := TRUE;
556: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
557: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
558: FND_MESSAGE.SET_TOKEN('COLUMN', 'PAGE_APPLICATION_ID');
559: FND_MSG_PUB.Add;
560: end if;

Line 559: FND_MSG_PUB.Add;

555: l_error := TRUE;
556: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
557: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
558: FND_MESSAGE.SET_TOKEN('COLUMN', 'PAGE_APPLICATION_ID');
559: FND_MSG_PUB.Add;
560: end if;
561: end if;
562:
563: if ((p_page_code is null) or

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

562:
563: if ((p_page_code is null) or
564: (p_page_code = FND_API.G_MISS_CHAR)) then
565: l_error := TRUE;
566: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
567: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
568: FND_MESSAGE.SET_TOKEN('COLUMN', 'PAGE_CODE');
569: FND_MSG_PUB.Add;
570: end if;

Line 569: FND_MSG_PUB.Add;

565: l_error := TRUE;
566: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
567: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
568: FND_MESSAGE.SET_TOKEN('COLUMN', 'PAGE_CODE');
569: FND_MSG_PUB.Add;
570: end if;
571: end if;
572:
573: if ((p_region_application_id is null) or

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

572:
573: if ((p_region_application_id is null) or
574: (p_region_application_id = FND_API.G_MISS_NUM)) then
575: l_error := TRUE;
576: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
577: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
578: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
579: FND_MSG_PUB.Add;
580: end if;

Line 579: FND_MSG_PUB.Add;

575: l_error := TRUE;
576: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
577: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
578: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
579: FND_MSG_PUB.Add;
580: end if;
581: end if;
582:
583: if ((p_region_code is null) or

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

582:
583: if ((p_region_code is null) or
584: (p_region_code = FND_API.G_MISS_CHAR)) then
585: l_error := TRUE;
586: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
587: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
588: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
589: FND_MSG_PUB.Add;
590: end if;

Line 589: FND_MSG_PUB.Add;

585: l_error := TRUE;
586: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
587: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
588: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
589: FND_MSG_PUB.Add;
590: end if;
591: end if;
592:
593: --

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

600: p_flow_code => p_flow_code,
601: p_page_application_id => p_page_application_id,
602: p_page_code => p_page_code) ) then
603: l_error := TRUE;
604: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
605: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FLOW_PG_REFERENCE');
606: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
607: ' ' || p_flow_code ||
608: ' ' || to_char(p_page_application_id) ||

Line 610: FND_MSG_PUB.Add;

606: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
607: ' ' || p_flow_code ||
608: ' ' || to_char(p_page_application_id) ||
609: ' ' || p_page_code);
610: FND_MSG_PUB.Add;
611: end if;
612: end if;
613:
614: --

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

619: p_return_status => l_return_status,
620: p_region_application_id => p_region_application_id,
621: p_region_code => p_region_code) ) then
622: l_error := TRUE;
623: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
624: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REGION_REFERENCE');
625: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
626: ' ' || p_region_code);
627: FND_MSG_PUB.Add;

Line 627: FND_MSG_PUB.Add;

623: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
624: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REGION_REFERENCE');
625: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
626: ' ' || p_region_code);
627: FND_MSG_PUB.Add;
628: end if;
629: end if;
630:
631: --

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

635: if (p_region_style is null) or
636: ((p_region_style = FND_API.G_MISS_CHAR) and
637: (p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
638: l_error := TRUE;
639: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
640: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
641: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_STYLE');
642: FND_MSG_PUB.Add;
643: end if;

Line 642: FND_MSG_PUB.Add;

638: l_error := TRUE;
639: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
640: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
641: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_STYLE');
642: FND_MSG_PUB.Add;
643: end if;
644: end if;
645:
646: --** Validate columns **

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

651: p_return_status => l_return_status,
652: p_lookup_type => 'REGION_STYLE',
653: p_lookup_code => p_region_style)) then
654: l_error := TRUE;
655: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
656: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
657: FND_MESSAGE.SET_TOKEN('COLUMN','REGION_STYLE');
658: FND_MSG_PUB.Add;
659: end if;

Line 658: FND_MSG_PUB.Add;

654: l_error := TRUE;
655: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
656: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
657: FND_MESSAGE.SET_TOKEN('COLUMN','REGION_STYLE');
658: FND_MSG_PUB.Add;
659: end if;
660: --dbms_output.put_line(l_api_name || ' Invalid region style');
661: end if;
662: end if;

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

669: open l_check_seq_csr;
670: fetch l_check_seq_csr into l_dummy;
671: if (l_check_seq_csr%found) then
672: l_error := TRUE;
673: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
674: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_DISPLAY_SEQUENCE');
675: FND_MSG_PUB.Add;
676: end if;
677: end if;

Line 675: FND_MSG_PUB.Add;

671: if (l_check_seq_csr%found) then
672: l_error := TRUE;
673: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
674: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_DISPLAY_SEQUENCE');
675: FND_MSG_PUB.Add;
676: end if;
677: end if;
678: close l_check_seq_csr;
679: end if;

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

699: if ( (l_primary_region_appl_id = p_region_application_id) and
700: (l_primary_region_code = p_region_code) ) or
701: (p_set_primary_region = 'Y') then
702: l_error := TRUE;
703: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
704: FND_MESSAGE.SET_NAME('AK','AK_PARENT_REGION_DISALLOWED');
705: FND_MSG_PUB.Add;
706: end if;
707: end if;

Line 705: FND_MSG_PUB.Add;

701: (p_set_primary_region = 'Y') then
702: l_error := TRUE;
703: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
704: FND_MESSAGE.SET_NAME('AK','AK_PARENT_REGION_DISALLOWED');
705: FND_MSG_PUB.Add;
706: end if;
707: end if;
708: end if;
709: close l_get_primary_region_csr;

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

713: --
714: if (p_parent_region_application_id = p_region_application_id) and
715: (p_parent_region_code = p_region_code) then
716: l_error := TRUE;
717: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
718: FND_MESSAGE.SET_NAME('AK','EC_DISTINCT_REGIONS');
719: FND_MSG_PUB.Add;
720: end if;
721: end if;

Line 719: FND_MSG_PUB.Add;

715: (p_parent_region_code = p_region_code) then
716: l_error := TRUE;
717: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
718: FND_MESSAGE.SET_NAME('AK','EC_DISTINCT_REGIONS');
719: FND_MSG_PUB.Add;
720: end if;
721: end if;
722:
723: --

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

732: p_page_code => p_page_code,
733: p_region_application_id => p_parent_region_application_id,
734: p_region_code => p_parent_region_code) then
735: l_error := TRUE;
736: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
737: FND_MESSAGE.SET_NAME('AK','AK_INVALID_PG_REGION_REFERENCE');
738: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
739: ' ' || p_flow_code ||
740: ' ' || to_char(p_page_application_id) ||

Line 744: FND_MSG_PUB.Add;

740: ' ' || to_char(p_page_application_id) ||
741: ' ' || p_page_code ||
742: ' ' || to_char(p_parent_region_application_id) ||
743: ' ' || p_parent_region_code);
744: FND_MSG_PUB.Add;
745: end if;
746: end if; /* if PAGE_REGION_EXISTS */
747: --
748: -- 4. if the foreign key name is missing (or null), and the

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

773: p_to_page_code => p_page_code,
774: p_to_region_appl_id => p_region_application_id,
775: p_to_region_code => p_region_code) then
776: l_error := TRUE;
777: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
778: FND_MESSAGE.SET_NAME('AK','AK_NO_INTRAPAGE_RELATION');
779: FND_MSG_PUB.Add;
780: FND_MESSAGE.SET_NAME('AK','AK_INVALID_RELATION_REFERENCE');
781: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

Line 779: FND_MSG_PUB.Add;

775: p_to_region_code => p_region_code) then
776: l_error := TRUE;
777: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
778: FND_MESSAGE.SET_NAME('AK','AK_NO_INTRAPAGE_RELATION');
779: FND_MSG_PUB.Add;
780: FND_MESSAGE.SET_NAME('AK','AK_INVALID_RELATION_REFERENCE');
781: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
782: ' ' || p_flow_code ||
783: ' ' || p_foreign_key_name ||

Line 789: FND_MSG_PUB.Add;

785: ' ' || p_page_code ||
786: ' ' || to_char(p_parent_region_application_id) ||
787: ' ' || p_parent_region_code ||
788: ' ' || p_region_code);
789: FND_MSG_PUB.Add;
790: end if;
791: end if; /* if not region_relation_exists */
792: elsif (p_caller = AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
793: l_error := TRUE;

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

790: end if;
791: end if; /* if not region_relation_exists */
792: elsif (p_caller = AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
793: l_error := TRUE;
794: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
795: FND_MESSAGE.SET_NAME('AK','AK_NO_INTRAPAGE_RELATION');
796: FND_MSG_PUB.Add;
797: FND_MESSAGE.SET_NAME('AK','AK_INVALID_RELATION_REFERENCE');
798: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

Line 796: FND_MSG_PUB.Add;

792: elsif (p_caller = AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
793: l_error := TRUE;
794: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
795: FND_MESSAGE.SET_NAME('AK','AK_NO_INTRAPAGE_RELATION');
796: FND_MSG_PUB.Add;
797: FND_MESSAGE.SET_NAME('AK','AK_INVALID_RELATION_REFERENCE');
798: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
799: ' ' || p_flow_code ||
800: ' ' || p_foreign_key_name ||

Line 806: FND_MSG_PUB.Add;

802: ' ' || p_page_code ||
803: ' ' || to_char(p_parent_region_application_id) ||
804: ' ' || p_parent_region_code ||
805: ' ' || p_region_code);
806: FND_MSG_PUB.Add;
807: end if;
808: end if; /* if caller is create */
809: end if; /* if p_foreign_key_name is null or missing */
810: end if; /* p_parent_region_application_id */

Line 821: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

817: p_return_status := FND_API.G_RET_STS_ERROR;
818: return FALSE;
819: WHEN OTHERS THEN
820: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
822: SUBSTR (SQLERRM, 1, 240) );
823: FND_MSG_PUB.Add;
824: return FALSE;
825:

Line 823: FND_MSG_PUB.Add;

819: WHEN OTHERS THEN
820: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
822: SUBSTR (SQLERRM, 1, 240) );
823: FND_MSG_PUB.Add;
824: return FALSE;
825:
826: end VALIDATE_PAGE_REGION;
827:

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

918: --** check that key columns are not null and not missing **
919: if ((p_flow_application_id is null) or
920: (p_flow_application_id = FND_API.G_MISS_NUM)) then
921: l_error := TRUE;
922: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
923: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
924: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_APPLICATION_ID');
925: FND_MSG_PUB.Add;
926: end if;

Line 925: FND_MSG_PUB.Add;

921: l_error := TRUE;
922: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
923: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
924: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_APPLICATION_ID');
925: FND_MSG_PUB.Add;
926: end if;
927: end if;
928:
929: if ((p_flow_code is null) or

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

928:
929: if ((p_flow_code is null) or
930: (p_flow_code = FND_API.G_MISS_CHAR)) then
931: l_error := TRUE;
932: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
933: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
934: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_CODE');
935: FND_MSG_PUB.Add;
936: end if;

Line 935: FND_MSG_PUB.Add;

931: l_error := TRUE;
932: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
933: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
934: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_CODE');
935: FND_MSG_PUB.Add;
936: end if;
937: end if;
938:
939: if ((p_page_application_id is null) or

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

938:
939: if ((p_page_application_id is null) or
940: (p_page_application_id = FND_API.G_MISS_NUM)) then
941: l_error := TRUE;
942: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
943: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
944: FND_MESSAGE.SET_TOKEN('COLUMN', 'PAGE_APPLICATION_ID');
945: FND_MSG_PUB.Add;
946: end if;

Line 945: FND_MSG_PUB.Add;

941: l_error := TRUE;
942: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
943: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
944: FND_MESSAGE.SET_TOKEN('COLUMN', 'PAGE_APPLICATION_ID');
945: FND_MSG_PUB.Add;
946: end if;
947: end if;
948:
949: if ((p_page_code is null) or

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

948:
949: if ((p_page_code is null) or
950: (p_page_code = FND_API.G_MISS_CHAR)) then
951: l_error := TRUE;
952: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
953: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
954: FND_MESSAGE.SET_TOKEN('COLUMN', 'PAGE_CODE');
955: FND_MSG_PUB.Add;
956: end if;

Line 955: FND_MSG_PUB.Add;

951: l_error := TRUE;
952: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
953: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
954: FND_MESSAGE.SET_TOKEN('COLUMN', 'PAGE_CODE');
955: FND_MSG_PUB.Add;
956: end if;
957: end if;
958:
959: if ((p_region_application_id is null) or

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

958:
959: if ((p_region_application_id is null) or
960: (p_region_application_id = FND_API.G_MISS_NUM)) then
961: l_error := TRUE;
962: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
963: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
964: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
965: FND_MSG_PUB.Add;
966: end if;

Line 965: FND_MSG_PUB.Add;

961: l_error := TRUE;
962: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
963: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
964: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
965: FND_MSG_PUB.Add;
966: end if;
967: end if;
968:
969: if ((p_region_code is null) or

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

968:
969: if ((p_region_code is null) or
970: (p_region_code = FND_API.G_MISS_CHAR)) then
971: l_error := TRUE;
972: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
973: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
974: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
975: FND_MSG_PUB.Add;
976: end if;

Line 975: FND_MSG_PUB.Add;

971: l_error := TRUE;
972: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
973: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
974: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
975: FND_MSG_PUB.Add;
976: end if;
977: end if;
978:
979: if ((p_attribute_application_id is null) or

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

978:
979: if ((p_attribute_application_id is null) or
980: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
981: l_error := TRUE;
982: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
983: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
984: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
985: FND_MSG_PUB.Add;
986: end if;

Line 985: FND_MSG_PUB.Add;

981: l_error := TRUE;
982: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
983: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
984: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
985: FND_MSG_PUB.Add;
986: end if;
987: end if;
988:
989: if ((p_attribute_code is null) or

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

988:
989: if ((p_attribute_code is null) or
990: (p_attribute_code = FND_API.G_MISS_CHAR)) then
991: l_error := TRUE;
992: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
993: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
994: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
995: FND_MSG_PUB.Add;
996: end if;

Line 995: FND_MSG_PUB.Add;

991: l_error := TRUE;
992: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
993: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
994: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
995: FND_MSG_PUB.Add;
996: end if;
997: end if;
998:
999: --

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

1008: p_page_code => p_page_code,
1009: p_region_application_id => p_region_application_id,
1010: p_region_code => p_region_code) ) then
1011: l_error := TRUE;
1012: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1013: FND_MESSAGE.SET_NAME('AK','AK_INVALID_PG_REGION_REFERENCE');
1014: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1015: ' ' || p_flow_code ||
1016: ' ' || to_char(p_page_application_id) ||

Line 1020: FND_MSG_PUB.Add;

1016: ' ' || to_char(p_page_application_id) ||
1017: ' ' || p_page_code ||
1018: ' ' || to_char(p_region_application_id) ||
1019: ' ' || p_region_code);
1020: FND_MSG_PUB.Add;
1021: end if;
1022: end if;
1023:
1024: --

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

1031: p_region_code => p_region_code,
1032: p_attribute_application_id => p_attribute_application_id,
1033: p_attribute_code => p_attribute_code) ) then
1034: l_error := TRUE;
1035: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1036: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');
1037: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
1038: ' ' || p_region_code ||
1039: ' ' || to_char(p_attribute_application_id) ||

Line 1041: FND_MSG_PUB.Add;

1037: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
1038: ' ' || p_region_code ||
1039: ' ' || to_char(p_attribute_application_id) ||
1040: ' ' || p_attribute_code);
1041: FND_MSG_PUB.Add;
1042: end if;
1043: end if;
1044:
1045: --

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

1052: if (p_to_page_appl_id is not null) and
1053: (p_to_page_appl_id <> FND_API.G_MISS_NUM) and
1054: ((p_to_page_code is null) or (p_to_page_code = FND_API.G_MISS_CHAR)) then
1055: l_error := TRUE;
1056: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1057: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1058: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_PAGE_CODE');
1059: FND_MSG_PUB.Add;
1060: end if;

Line 1059: FND_MSG_PUB.Add;

1055: l_error := TRUE;
1056: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1057: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1058: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_PAGE_CODE');
1059: FND_MSG_PUB.Add;
1060: end if;
1061: end if;
1062:
1063: if (p_to_page_code is not null) and

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

1064: (p_to_page_code <> FND_API.G_MISS_CHAR) and
1065: ((p_to_page_appl_id is null) or
1066: (p_to_page_appl_id = FND_API.G_MISS_NUM)) 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', 'TO_PAGE_APPL_ID');
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', 'TO_PAGE_APPL_ID');
1071: FND_MSG_PUB.Add;
1072: end if;
1073: end if;
1074:
1075: --

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

1080: (p_to_url_attribute_appl_id <> FND_API.G_MISS_NUM) and
1081: ((p_to_url_attribute_code is null) or
1082: (p_to_url_attribute_code = FND_API.G_MISS_CHAR)) then
1083: l_error := TRUE;
1084: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1085: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1086: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_URL_ATTRIBUTE_CODE');
1087: FND_MSG_PUB.Add;
1088: end if;

Line 1087: FND_MSG_PUB.Add;

1083: l_error := TRUE;
1084: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1085: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1086: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_URL_ATTRIBUTE_CODE');
1087: FND_MSG_PUB.Add;
1088: end if;
1089: end if;
1090:
1091: if (p_to_url_attribute_code is not null) and

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

1092: (p_to_url_attribute_code <> FND_API.G_MISS_CHAR) and
1093: ((p_to_url_attribute_appl_id is null) or
1094: (p_to_url_attribute_appl_id = FND_API.G_MISS_NUM)) then
1095: l_error := TRUE;
1096: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1097: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1098: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_URL_ATTRIBUTE_APPL_ID');
1099: FND_MSG_PUB.Add;
1100: end if;

Line 1099: FND_MSG_PUB.Add;

1095: l_error := TRUE;
1096: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1097: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1098: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_URL_ATTRIBUTE_APPL_ID');
1099: FND_MSG_PUB.Add;
1100: end if;
1101: end if;
1102:
1103: --

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

1108: (p_to_page_code = FND_API.G_MISS_CHAR) ) and
1109: ( (p_to_url_attribute_code is null) or
1110: (p_to_url_attribute_code = FND_API.G_MISS_CHAR) ) then
1111: l_error := TRUE;
1112: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1113: FND_MESSAGE.SET_NAME('AK','AK_NO_LINK_SELECTED');
1114: FND_MSG_PUB.Add;
1115: end if;
1116: end if;

Line 1114: FND_MSG_PUB.Add;

1110: (p_to_url_attribute_code = FND_API.G_MISS_CHAR) ) then
1111: l_error := TRUE;
1112: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1113: FND_MESSAGE.SET_NAME('AK','AK_NO_LINK_SELECTED');
1114: FND_MSG_PUB.Add;
1115: end if;
1116: end if;
1117:
1118: --

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

1122: (p_to_page_code <> FND_API.G_MISS_CHAR) ) and
1123: ( (p_to_url_attribute_code is not null) and
1124: (p_to_url_attribute_code <> FND_API.G_MISS_CHAR) ) then
1125: l_error := TRUE;
1126: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1127: FND_MESSAGE.SET_NAME('AK','AK_TWO_LINK_SELECTED');
1128: FND_MSG_PUB.Add;
1129: end if;
1130: end if;

Line 1128: FND_MSG_PUB.Add;

1124: (p_to_url_attribute_code <> FND_API.G_MISS_CHAR) ) then
1125: l_error := TRUE;
1126: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1127: FND_MESSAGE.SET_NAME('AK','AK_TWO_LINK_SELECTED');
1128: FND_MSG_PUB.Add;
1129: end if;
1130: end if;
1131:
1132: --

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

1149: p_flow_code => p_flow_code,
1150: p_page_application_id => p_to_page_appl_id,
1151: p_page_code => p_to_page_code) ) then
1152: l_error := TRUE;
1153: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1154: FND_MESSAGE.SET_NAME('AK','AK_NO_REGION_RELATION');
1155: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1156: ' ' || p_flow_code ||
1157: ' ' || to_char(p_to_page_appl_id) ||

Line 1159: FND_MSG_PUB.Add;

1155: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1156: ' ' || p_flow_code ||
1157: ' ' || to_char(p_to_page_appl_id) ||
1158: ' ' || p_to_page_code);
1159: FND_MSG_PUB.Add;
1160: end if;
1161: end if; /* if PAGE_EXISTS */
1162: --
1163: -- 2. There must be a region relation linking this region and the

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

1166: open l_check_to_page_csr;
1167: fetch l_check_to_page_csr into l_dummy;
1168: if (l_check_to_page_csr%notfound) then
1169: l_error := TRUE;
1170: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1171: FND_MESSAGE.SET_NAME('AK','AK_INVALID_TO_PAGE_REFERENCE');
1172: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1173: ' ' || p_flow_code ||
1174: ' ' || to_char(p_to_page_appl_id) ||

Line 1176: FND_MSG_PUB.Add;

1172: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1173: ' ' || p_flow_code ||
1174: ' ' || to_char(p_to_page_appl_id) ||
1175: ' ' || p_to_page_code);
1176: FND_MSG_PUB.Add;
1177: end if;
1178: end if; /* if l_check_to_page */
1179: close l_check_to_page_csr;
1180:

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

1192: open l_check_to_url_csr;
1193: fetch l_check_to_url_csr into l_dummy;
1194: if (l_check_to_url_csr%notfound) then
1195: l_error := TRUE;
1196: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1197: FND_MESSAGE.SET_NAME('AK','AK_INVALID_TO_URL_ATTRIBUTE');
1198: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_to_url_attribute_appl_id) ||
1199: ' ' || p_to_url_attribute_code);
1200: FND_MSG_PUB.Add;

Line 1200: FND_MSG_PUB.Add;

1196: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1197: FND_MESSAGE.SET_NAME('AK','AK_INVALID_TO_URL_ATTRIBUTE');
1198: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_to_url_attribute_appl_id) ||
1199: ' ' || p_to_url_attribute_code);
1200: FND_MSG_PUB.Add;
1201: end if;
1202: end if;
1203: close l_check_to_url_csr;
1204: end if;

Line 1216: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1212: p_return_status := FND_API.G_RET_STS_ERROR;
1213: return FALSE;
1214: WHEN OTHERS THEN
1215: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1216: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1217: SUBSTR (SQLERRM, 1, 240) );
1218: FND_MSG_PUB.Add;
1219: return FALSE;
1220:

Line 1218: FND_MSG_PUB.Add;

1214: WHEN OTHERS THEN
1215: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1216: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1217: SUBSTR (SQLERRM, 1, 240) );
1218: FND_MSG_PUB.Add;
1219: return FALSE;
1220:
1221: end VALIDATE_PAGE_REGION_ITEM;
1222:

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

1319: --** check that key columns are not null and not missing **
1320: if ((p_flow_application_id is null) or
1321: (p_flow_application_id = FND_API.G_MISS_NUM)) then
1322: l_error := TRUE;
1323: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1324: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1325: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_APPLICATION_ID');
1326: FND_MSG_PUB.Add;
1327: end if;

Line 1326: FND_MSG_PUB.Add;

1322: l_error := TRUE;
1323: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1324: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1325: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_APPLICATION_ID');
1326: FND_MSG_PUB.Add;
1327: end if;
1328: end if;
1329:
1330: if ((p_flow_code is null) or

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

1329:
1330: if ((p_flow_code is null) or
1331: (p_flow_code = FND_API.G_MISS_CHAR)) then
1332: l_error := TRUE;
1333: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1334: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1335: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_CODE');
1336: FND_MSG_PUB.Add;
1337: end if;

Line 1336: FND_MSG_PUB.Add;

1332: l_error := TRUE;
1333: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1334: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1335: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_CODE');
1336: FND_MSG_PUB.Add;
1337: end if;
1338: end if;
1339:
1340: if ((p_foreign_key_name is null) or

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

1339:
1340: if ((p_foreign_key_name is null) or
1341: (p_foreign_key_name = FND_API.G_MISS_CHAR)) then
1342: l_error := TRUE;
1343: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1344: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1345: FND_MESSAGE.SET_TOKEN('COLUMN', 'FOREIGN_KEY_NAME');
1346: FND_MSG_PUB.Add;
1347: end if;

Line 1346: FND_MSG_PUB.Add;

1342: l_error := TRUE;
1343: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1344: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1345: FND_MESSAGE.SET_TOKEN('COLUMN', 'FOREIGN_KEY_NAME');
1346: FND_MSG_PUB.Add;
1347: end if;
1348: end if;
1349:
1350: if ((p_from_page_appl_id is null) or

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

1349:
1350: if ((p_from_page_appl_id is null) or
1351: (p_from_page_appl_id = FND_API.G_MISS_NUM)) then
1352: l_error := TRUE;
1353: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1354: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1355: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_PAGE_APPL_ID');
1356: FND_MSG_PUB.Add;
1357: end if;

Line 1356: FND_MSG_PUB.Add;

1352: l_error := TRUE;
1353: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1354: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1355: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_PAGE_APPL_ID');
1356: FND_MSG_PUB.Add;
1357: end if;
1358: end if;
1359:
1360: if ((p_from_page_code is null) or

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

1359:
1360: if ((p_from_page_code is null) or
1361: (p_from_page_code = FND_API.G_MISS_CHAR)) then
1362: l_error := TRUE;
1363: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1364: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1365: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_PAGE_CODE');
1366: FND_MSG_PUB.Add;
1367: end if;

Line 1366: FND_MSG_PUB.Add;

1362: l_error := TRUE;
1363: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1364: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1365: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_PAGE_CODE');
1366: FND_MSG_PUB.Add;
1367: end if;
1368: end if;
1369:
1370: if ((p_from_region_appl_id is null) or

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

1369:
1370: if ((p_from_region_appl_id is null) or
1371: (p_from_region_appl_id = FND_API.G_MISS_NUM)) then
1372: l_error := TRUE;
1373: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1374: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1375: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_REGION_APPL_ID');
1376: FND_MSG_PUB.Add;
1377: end if;

Line 1376: FND_MSG_PUB.Add;

1372: l_error := TRUE;
1373: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1374: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1375: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_REGION_APPL_ID');
1376: FND_MSG_PUB.Add;
1377: end if;
1378: end if;
1379:
1380: if ((p_from_region_code is null) or

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

1379:
1380: if ((p_from_region_code is null) or
1381: (p_from_region_code = FND_API.G_MISS_CHAR)) then
1382: l_error := TRUE;
1383: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1384: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1385: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_REGION_CODE');
1386: FND_MSG_PUB.Add;
1387: end if;

Line 1386: FND_MSG_PUB.Add;

1382: l_error := TRUE;
1383: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1384: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1385: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_REGION_CODE');
1386: FND_MSG_PUB.Add;
1387: end if;
1388: end if;
1389:
1390: if ((p_to_page_appl_id is null) or

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

1389:
1390: if ((p_to_page_appl_id is null) or
1391: (p_to_page_appl_id = FND_API.G_MISS_NUM)) then
1392: l_error := TRUE;
1393: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1394: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1395: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_PAGE_APPL_ID');
1396: FND_MSG_PUB.Add;
1397: end if;

Line 1396: FND_MSG_PUB.Add;

1392: l_error := TRUE;
1393: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1394: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1395: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_PAGE_APPL_ID');
1396: FND_MSG_PUB.Add;
1397: end if;
1398: end if;
1399:
1400: if ((p_to_page_code is null) or

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

1399:
1400: if ((p_to_page_code is null) or
1401: (p_to_page_code = FND_API.G_MISS_CHAR)) then
1402: l_error := TRUE;
1403: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1404: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1405: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_PAGE_CODE');
1406: FND_MSG_PUB.Add;
1407: end if;

Line 1406: FND_MSG_PUB.Add;

1402: l_error := TRUE;
1403: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1404: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1405: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_PAGE_CODE');
1406: FND_MSG_PUB.Add;
1407: end if;
1408: end if;
1409:
1410: if ((p_to_region_appl_id is null) or

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

1409:
1410: if ((p_to_region_appl_id is null) or
1411: (p_to_region_appl_id = FND_API.G_MISS_NUM)) then
1412: l_error := TRUE;
1413: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1414: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1415: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_REGION_APPL_ID');
1416: FND_MSG_PUB.Add;
1417: end if;

Line 1416: FND_MSG_PUB.Add;

1412: l_error := TRUE;
1413: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1414: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1415: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_REGION_APPL_ID');
1416: FND_MSG_PUB.Add;
1417: end if;
1418: end if;
1419:
1420: if ((p_to_region_code is null) or

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

1419:
1420: if ((p_to_region_code is null) or
1421: (p_to_region_code = FND_API.G_MISS_CHAR)) then
1422: l_error := TRUE;
1423: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1424: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1425: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_REGION_CODE');
1426: FND_MSG_PUB.Add;
1427: end if;

Line 1426: FND_MSG_PUB.Add;

1422: l_error := TRUE;
1423: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1424: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1425: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_REGION_CODE');
1426: FND_MSG_PUB.Add;
1427: end if;
1428: end if;
1429:
1430: --

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

1435: p_return_status => l_return_status,
1436: p_flow_application_id => p_flow_application_id,
1437: p_flow_code => p_flow_code) ) then
1438: l_error := TRUE;
1439: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1440: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FLOW_REFERENCE');
1441: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1442: ' ' || p_flow_code);
1443: FND_MSG_PUB.Add;

Line 1443: FND_MSG_PUB.Add;

1439: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1440: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FLOW_REFERENCE');
1441: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1442: ' ' || p_flow_code);
1443: FND_MSG_PUB.Add;
1444: end if;
1445: end if;
1446:
1447: --

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

1451: p_api_version_number => 1.0,
1452: p_return_status => l_return_status,
1453: p_foreign_key_name => p_foreign_key_name) ) then
1454: l_error := TRUE;
1455: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1456: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FK_REFERENCE');
1457: FND_MESSAGE.SET_TOKEN('KEY', p_foreign_key_name);
1458: FND_MSG_PUB.Add;
1459: end if;

Line 1458: FND_MSG_PUB.Add;

1454: l_error := TRUE;
1455: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1456: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FK_REFERENCE');
1457: FND_MESSAGE.SET_TOKEN('KEY', p_foreign_key_name);
1458: FND_MSG_PUB.Add;
1459: end if;
1460: end if;
1461:
1462: --

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

1471: p_page_code => p_from_page_code,
1472: p_region_application_id => p_from_region_appl_id,
1473: p_region_code => p_from_region_code) then
1474: l_error := TRUE;
1475: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1476: FND_MESSAGE.SET_NAME('AK','AK_INVALID_PG_REGION_REFERENCE');
1477: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1478: ' ' || p_flow_code ||
1479: ' ' || to_char(p_from_page_appl_id) ||

Line 1483: FND_MSG_PUB.Add;

1479: ' ' || to_char(p_from_page_appl_id) ||
1480: ' ' || p_from_page_code ||
1481: ' ' || to_char(p_from_region_appl_id) ||
1482: ' ' || p_from_region_code);
1483: FND_MSG_PUB.Add;
1484: end if;
1485: end if;
1486:
1487: --

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

1496: p_page_code => p_to_page_code,
1497: p_region_application_id => p_to_region_appl_id,
1498: p_region_code => p_to_region_code) then
1499: l_error := TRUE;
1500: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1501: FND_MESSAGE.SET_NAME('AK','AK_INVALID_PG_REGION_REFERENCE');
1502: FND_MESSAGE.SET_TOKEN('REF_OBJECT','AK_FLOW_PAGE_REGION', TRUE);
1503: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1504: ' ' || p_flow_code ||

Line 1509: FND_MSG_PUB.Add;

1505: ' ' || to_char(p_to_page_appl_id) ||
1506: ' ' || p_to_page_code ||
1507: ' ' || to_char(p_to_region_appl_id) ||
1508: ' ' || p_to_region_code);
1509: FND_MSG_PUB.Add;
1510: end if;
1511: end if;
1512:
1513: --

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

1517: if (p_application_id is null) or
1518: ((p_application_id = FND_API.G_MISS_NUM) and
1519: (p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1520: l_error := TRUE;
1521: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1522: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1523: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_ID');
1524: FND_MSG_PUB.Add;
1525: end if;

Line 1524: FND_MSG_PUB.Add;

1520: l_error := TRUE;
1521: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1522: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1523: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_ID');
1524: FND_MSG_PUB.Add;
1525: end if;
1526: end if;
1527:
1528: --

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

1536: p_return_status => l_return_status,
1537: p_application_id => p_application_id)
1538: ) then
1539: l_error := TRUE;
1540: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1541: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
1542: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');
1543: FND_MSG_PUB.Add;
1544: end if;

Line 1543: FND_MSG_PUB.Add;

1539: l_error := TRUE;
1540: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1541: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
1542: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');
1543: FND_MSG_PUB.Add;
1544: end if;
1545: end if;
1546: end if;
1547:

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

1552: (p_from_page_code = p_to_page_code) and
1553: (p_from_region_appl_id = p_to_region_appl_id) and
1554: (p_from_region_code = p_to_region_code) then
1555: l_error := TRUE;
1556: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1557: FND_MESSAGE.SET_NAME('AK','AK_INVALID_TARGET_REGION');
1558: FND_MSG_PUB.Add;
1559: end if;
1560: end if;

Line 1558: FND_MSG_PUB.Add;

1554: (p_from_region_code = p_to_region_code) then
1555: l_error := TRUE;
1556: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1557: FND_MESSAGE.SET_NAME('AK','AK_INVALID_TARGET_REGION');
1558: FND_MSG_PUB.Add;
1559: end if;
1560: end if;
1561:
1562: --

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

1566: open l_check_fk_connect_csr;
1567: fetch l_check_fk_connect_csr into l_dummy;
1568: if (l_check_fk_connect_csr%notfound) then
1569: l_error := TRUE;
1570: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1571: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FOREIGN_KEY');
1572: FND_MSG_PUB.Add;
1573: end if;
1574: end if;

Line 1572: FND_MSG_PUB.Add;

1568: if (l_check_fk_connect_csr%notfound) then
1569: l_error := TRUE;
1570: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1571: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FOREIGN_KEY');
1572: FND_MSG_PUB.Add;
1573: end if;
1574: end if;
1575: close l_check_fk_connect_csr;
1576:

Line 1587: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1583: p_return_status := FND_API.G_RET_STS_ERROR;
1584: return FALSE;
1585: WHEN OTHERS THEN
1586: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1587: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1588: SUBSTR (SQLERRM, 1, 240) );
1589: FND_MSG_PUB.Add;
1590: return FALSE;
1591:

Line 1589: FND_MSG_PUB.Add;

1585: WHEN OTHERS THEN
1586: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1587: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1588: SUBSTR (SQLERRM, 1, 240) );
1589: FND_MSG_PUB.Add;
1590: return FALSE;
1591:
1592: end VALIDATE_REGION_RELATION;
1593: