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_MESSAGE

Line 90: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 91: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_APPLICATION_ID');

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

Line 100: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 101: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_CODE');

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

Line 113: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 114: FND_MESSAGE.SET_TOKEN('COLUMN', 'PRIMARY_PAGE_APPL_ID');

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

Line 124: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 125: FND_MESSAGE.SET_TOKEN('COLUMN', 'PRIMARY_PAGE_CODE');

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

Line 135: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 136: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');

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

Line 159: FND_MESSAGE.SET_NAME('AK','NO_FLOW_DEFAULT_PAGE');

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 */
163: close l_check_no_page_csr;

Line 176: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FLOW_PG_REFERENCE');

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) ||
180: ' ' || p_primary_page_code);

Line 177: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_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) ||
180: ' ' || p_primary_page_code);
181: FND_MSG_PUB.Add;

Line 282: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 283: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_APPLICATION_ID');

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

Line 292: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 293: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_CODE');

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

Line 302: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 303: FND_MESSAGE.SET_TOKEN('COLUMN', 'PAGE_APPLICATION_ID');

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

Line 312: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 313: FND_MESSAGE.SET_TOKEN('COLUMN', 'PAGE_CODE');

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

Line 328: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FLOW_REFERENCE');

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

Line 329: FND_MESSAGE.SET_TOKEN('KEY', to_char(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;
332: end if;
333: --dbms_output.put_line('Parent flow does not exist!');

Line 343: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 344: FND_MESSAGE.SET_TOKEN('COLUMN', 'PRIMARY_REGION_APPL_ID');

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

Line 354: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 355: FND_MESSAGE.SET_TOKEN('COLUMN', 'PRIMARY_REGION_CODE');

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

Line 365: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 366: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');

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

Line 388: FND_MESSAGE.SET_NAME('AK','NO_PAGE_ROOT_REGION');

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 */
392: close l_check_no_region_csr;

Line 405: FND_MESSAGE.SET_NAME('AK','AK_INVALID_PG_REGION_REFERENCE');

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) ||
409: ' ' || p_page_code ||

Line 406: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_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) ||
409: ' ' || p_page_code ||
410: ' ' || to_char(p_primary_region_appl_id) ||

Line 537: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 538: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_APPLICATION_ID');

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

Line 547: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 548: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_CODE');

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

Line 557: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 558: FND_MESSAGE.SET_TOKEN('COLUMN', 'PAGE_APPLICATION_ID');

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

Line 567: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 568: FND_MESSAGE.SET_TOKEN('COLUMN', 'PAGE_CODE');

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

Line 577: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 578: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');

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

Line 587: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 588: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');

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

Line 605: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FLOW_PG_REFERENCE');

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) ||
609: ' ' || p_page_code);

Line 606: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_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) ||
609: ' ' || p_page_code);
610: FND_MSG_PUB.Add;

Line 624: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REGION_REFERENCE');

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

Line 625: FND_MESSAGE.SET_TOKEN('KEY', to_char(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;
628: end if;
629: end if;

Line 640: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 641: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_STYLE');

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

Line 656: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');

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;
660: --dbms_output.put_line(l_api_name || ' Invalid region style');

Line 657: FND_MESSAGE.SET_TOKEN('COLUMN','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;
660: --dbms_output.put_line(l_api_name || ' Invalid region style');
661: end if;

Line 674: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_DISPLAY_SEQUENCE');

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;
678: close l_check_seq_csr;

Line 704: FND_MESSAGE.SET_NAME('AK','AK_PARENT_REGION_DISALLOWED');

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

Line 718: FND_MESSAGE.SET_NAME('AK','EC_DISTINCT_REGIONS');

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

Line 737: FND_MESSAGE.SET_NAME('AK','AK_INVALID_PG_REGION_REFERENCE');

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) ||
741: ' ' || p_page_code ||

Line 738: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_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) ||
741: ' ' || p_page_code ||
742: ' ' || to_char(p_parent_region_application_id) ||

Line 778: FND_MESSAGE.SET_NAME('AK','AK_NO_INTRAPAGE_RELATION');

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) ||
782: ' ' || p_flow_code ||

Line 780: FND_MESSAGE.SET_NAME('AK','AK_INVALID_RELATION_REFERENCE');

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 ||
784: ' ' || to_char(p_page_application_id) ||

Line 781: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

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 ||
784: ' ' || to_char(p_page_application_id) ||
785: ' ' || p_page_code ||

Line 795: FND_MESSAGE.SET_NAME('AK','AK_NO_INTRAPAGE_RELATION');

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) ||
799: ' ' || p_flow_code ||

Line 797: FND_MESSAGE.SET_NAME('AK','AK_INVALID_RELATION_REFERENCE');

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 ||
801: ' ' || to_char(p_page_application_id) ||

Line 798: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

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 ||
801: ' ' || to_char(p_page_application_id) ||
802: ' ' || p_page_code ||

Line 923: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 924: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_APPLICATION_ID');

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

Line 933: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 934: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_CODE');

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

Line 943: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 944: FND_MESSAGE.SET_TOKEN('COLUMN', 'PAGE_APPLICATION_ID');

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

Line 953: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 954: FND_MESSAGE.SET_TOKEN('COLUMN', 'PAGE_CODE');

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

Line 963: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 964: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');

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

Line 973: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 974: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');

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

Line 983: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 984: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');

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

Line 993: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 994: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');

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

Line 1013: FND_MESSAGE.SET_NAME('AK','AK_INVALID_PG_REGION_REFERENCE');

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) ||
1017: ' ' || p_page_code ||

Line 1014: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_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) ||
1017: ' ' || p_page_code ||
1018: ' ' || to_char(p_region_application_id) ||

Line 1036: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REG_ITEM_REFERENCE');

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) ||
1040: ' ' || p_attribute_code);

Line 1037: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_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) ||
1040: ' ' || p_attribute_code);
1041: FND_MSG_PUB.Add;

Line 1057: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 1058: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_PAGE_CODE');

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

Line 1069: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 1070: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_PAGE_APPL_ID');

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

Line 1085: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 1086: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_URL_ATTRIBUTE_CODE');

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

Line 1097: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 1098: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_URL_ATTRIBUTE_APPL_ID');

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

Line 1113: FND_MESSAGE.SET_NAME('AK','AK_NO_LINK_SELECTED');

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

Line 1127: FND_MESSAGE.SET_NAME('AK','AK_TWO_LINK_SELECTED');

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

Line 1154: FND_MESSAGE.SET_NAME('AK','AK_NO_REGION_RELATION');

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) ||
1158: ' ' || p_to_page_code);

Line 1155: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_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) ||
1158: ' ' || p_to_page_code);
1159: FND_MSG_PUB.Add;

Line 1171: FND_MESSAGE.SET_NAME('AK','AK_INVALID_TO_PAGE_REFERENCE');

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) ||
1175: ' ' || p_to_page_code);

Line 1172: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

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) ||
1175: ' ' || p_to_page_code);
1176: FND_MSG_PUB.Add;

Line 1197: FND_MESSAGE.SET_NAME('AK','AK_INVALID_TO_URL_ATTRIBUTE');

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

Line 1198: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_to_url_attribute_appl_id) ||

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

Line 1324: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 1325: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_APPLICATION_ID');

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

Line 1334: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 1335: FND_MESSAGE.SET_TOKEN('COLUMN', 'FLOW_CODE');

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

Line 1344: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 1345: FND_MESSAGE.SET_TOKEN('COLUMN', 'FOREIGN_KEY_NAME');

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

Line 1354: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 1355: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_PAGE_APPL_ID');

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

Line 1364: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 1365: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_PAGE_CODE');

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

Line 1374: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 1375: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_REGION_APPL_ID');

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

Line 1384: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 1385: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_REGION_CODE');

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

Line 1394: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 1395: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_PAGE_APPL_ID');

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

Line 1404: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 1405: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_PAGE_CODE');

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

Line 1414: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 1415: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_REGION_APPL_ID');

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

Line 1424: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 1425: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_REGION_CODE');

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

Line 1440: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FLOW_REFERENCE');

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

Line 1441: FND_MESSAGE.SET_TOKEN('KEY', to_char(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;
1444: end if;
1445: end if;

Line 1456: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FK_REFERENCE');

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

Line 1457: FND_MESSAGE.SET_TOKEN('KEY', p_foreign_key_name);

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

Line 1476: FND_MESSAGE.SET_NAME('AK','AK_INVALID_PG_REGION_REFERENCE');

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) ||
1480: ' ' || p_from_page_code ||

Line 1477: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_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) ||
1480: ' ' || p_from_page_code ||
1481: ' ' || to_char(p_from_region_appl_id) ||

Line 1501: FND_MESSAGE.SET_NAME('AK','AK_INVALID_PG_REGION_REFERENCE');

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 ||
1505: ' ' || to_char(p_to_page_appl_id) ||

Line 1502: FND_MESSAGE.SET_TOKEN('REF_OBJECT','AK_FLOW_PAGE_REGION', TRUE);

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 ||
1505: ' ' || to_char(p_to_page_appl_id) ||
1506: ' ' || p_to_page_code ||

Line 1503: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

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 ||
1505: ' ' || to_char(p_to_page_appl_id) ||
1506: ' ' || p_to_page_code ||
1507: ' ' || to_char(p_to_region_appl_id) ||

Line 1522: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

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

Line 1523: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_ID');

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

Line 1541: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');

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

Line 1542: FND_MESSAGE.SET_TOKEN('COLUMN','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;
1545: end if;
1546: end if;

Line 1557: FND_MESSAGE.SET_NAME('AK','AK_INVALID_TARGET_REGION');

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

Line 1571: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FOREIGN_KEY');

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;
1575: close l_check_fk_connect_csr;