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_API

Line 46: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

42: -- Version Initial version number = 1.0
43: -- History Current version number = 1.0
44: --=======================================================
45: function VALIDATE_FLOW (
46: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
47: p_api_version_number IN NUMBER,
48: p_return_status OUT NOCOPY VARCHAR2,
49: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
50: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 49: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,

45: function VALIDATE_FLOW (
46: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
47: p_api_version_number IN NUMBER,
48: p_return_status OUT NOCOPY VARCHAR2,
49: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
50: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 50: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

46: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
47: p_api_version_number IN NUMBER,
48: p_return_status OUT NOCOPY VARCHAR2,
49: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
50: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 51: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,

47: p_api_version_number IN NUMBER,
48: p_return_status OUT NOCOPY VARCHAR2,
49: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
50: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_caller IN VARCHAR2,

Line 52: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

48: p_return_status OUT NOCOPY VARCHAR2,
49: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
50: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_caller IN VARCHAR2,
56: p_pass IN NUMBER := 2

Line 53: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

49: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
50: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_caller IN VARCHAR2,
56: p_pass IN NUMBER := 2
57: ) return BOOLEAN is

Line 54: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

50: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_caller IN VARCHAR2,
56: p_pass IN NUMBER := 2
57: ) return BOOLEAN is
58: cursor l_check_no_page_csr is

Line 70: IF NOT FND_API.Compatible_API_Call (

66: l_error BOOLEAN;
67: l_return_status VARCHAR2(1);
68: begin
69:
70: IF NOT FND_API.Compatible_API_Call (
71: l_api_version_number, p_api_version_number, l_api_name,
72: G_PKG_NAME) then
73: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74: return FALSE;

Line 73: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

69:
70: IF NOT FND_API.Compatible_API_Call (
71: l_api_version_number, p_api_version_number, l_api_name,
72: G_PKG_NAME) then
73: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74: return FALSE;
75: END IF;
76:
77: l_error := FALSE;

Line 80: if (p_validation_level = FND_API.G_VALID_LEVEL_NONE) then

76:
77: l_error := FALSE;
78:
79: --** if validation level is none, no validation is necessary
80: if (p_validation_level = FND_API.G_VALID_LEVEL_NONE) then
81: p_return_status := FND_API.G_RET_STS_SUCCESS;
82: return TRUE;
83: end if;
84:

Line 81: p_return_status := FND_API.G_RET_STS_SUCCESS;

77: l_error := FALSE;
78:
79: --** if validation level is none, no validation is necessary
80: if (p_validation_level = FND_API.G_VALID_LEVEL_NONE) then
81: p_return_status := FND_API.G_RET_STS_SUCCESS;
82: return TRUE;
83: end if;
84:
85: --** check that key columns are not null and not missing **

Line 87: (p_flow_application_id = FND_API.G_MISS_NUM)) then

83: end if;
84:
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');

Line 97: (p_flow_code = FND_API.G_MISS_CHAR)) then

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

Line 109: (p_primary_page_appl_id = FND_API.G_MISS_NUM and

105:
106: --** check that required columns are not null and, unless calling **
107: --** from UPDATE procedure, the columns are not missing **
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');

Line 120: (p_primary_page_code = FND_API.G_MISS_CHAR and

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

Line 131: (p_name = FND_API.G_MISS_CHAR and

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

Line 151: if (p_primary_page_appl_id <> FND_API.G_MISS_NUM) and

147: -- is G_NO_PRIMARY_PAGE_CODE (as in the case when a flow is created
148: -- and before any pages have been added for that flow),
149: -- check that no pages exist for the flow.
150: --
151: if (p_primary_page_appl_id <> FND_API.G_MISS_NUM) and
152: (p_primary_page_code <> FND_API.G_MISS_CHAR) then
153: if (p_primary_page_code = G_NO_PRIMARY_PAGE_CODE) then
154: open l_check_no_page_csr;
155: fetch l_check_no_page_csr into l_dummy;

Line 152: (p_primary_page_code <> FND_API.G_MISS_CHAR) then

148: -- and before any pages have been added for that flow),
149: -- check that no pages exist for the flow.
150: --
151: if (p_primary_page_appl_id <> FND_API.G_MISS_NUM) and
152: (p_primary_page_code <> FND_API.G_MISS_CHAR) then
153: if (p_primary_page_code = G_NO_PRIMARY_PAGE_CODE) 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

Line 187: p_return_status := FND_API.G_RET_STS_SUCCESS;

183: end if; /* if PAGE_EXISTS */
184: end if; -- /* if p_primary_page_code */
185: end if;
186: -- return true if no error, false otherwise
187: p_return_status := FND_API.G_RET_STS_SUCCESS;
188: return (not l_error);
189:
190: EXCEPTION
191: WHEN FND_API.G_EXC_ERROR THEN

Line 191: WHEN FND_API.G_EXC_ERROR THEN

187: p_return_status := FND_API.G_RET_STS_SUCCESS;
188: return (not l_error);
189:
190: EXCEPTION
191: WHEN FND_API.G_EXC_ERROR THEN
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;

Line 192: p_return_status := FND_API.G_RET_STS_ERROR;

188: return (not l_error);
189:
190: EXCEPTION
191: WHEN FND_API.G_EXC_ERROR THEN
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,

Line 195: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

230: -- Version Initial version number = 1.0
231: -- History Current version number = 1.0
232: --=======================================================
233: function VALIDATE_PAGE (
234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
235: p_api_version_number IN NUMBER,
236: p_return_status OUT NOCOPY VARCHAR2,
237: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
238: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 237: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,

233: function VALIDATE_PAGE (
234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
235: p_api_version_number IN NUMBER,
236: p_return_status OUT NOCOPY VARCHAR2,
237: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
238: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
240: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,

Line 238: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
235: p_api_version_number IN NUMBER,
236: p_return_status OUT NOCOPY VARCHAR2,
237: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
238: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
240: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
242: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 239: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,

235: p_api_version_number IN NUMBER,
236: p_return_status OUT NOCOPY VARCHAR2,
237: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
238: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
240: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
242: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 240: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

236: p_return_status OUT NOCOPY VARCHAR2,
237: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
238: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
240: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
242: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 241: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,

237: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
238: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
240: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
242: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_caller IN VARCHAR2,

Line 242: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

238: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
240: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
242: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_caller IN VARCHAR2,
246: p_pass IN NUMBER := 2

Line 243: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

239: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
240: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
242: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_caller IN VARCHAR2,
246: p_pass IN NUMBER := 2
247: ) return BOOLEAN is

Line 244: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

240: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
241: p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
242: p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
244: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
245: p_caller IN VARCHAR2,
246: p_pass IN NUMBER := 2
247: ) return BOOLEAN is
248: cursor l_check_no_region_csr is

Line 262: IF NOT FND_API.Compatible_API_Call (

258: l_error BOOLEAN;
259: l_return_status varchar2(1);
260: begin
261:
262: IF NOT FND_API.Compatible_API_Call (
263: l_api_version_number, p_api_version_number, l_api_name,
264: G_PKG_NAME) then
265: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: return FALSE;

Line 265: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

261:
262: IF NOT FND_API.Compatible_API_Call (
263: l_api_version_number, p_api_version_number, l_api_name,
264: G_PKG_NAME) then
265: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: return FALSE;
267: END IF;
268:
269: l_error := FALSE;

Line 272: if (p_validation_level = FND_API.G_VALID_LEVEL_NONE) then

268:
269: l_error := FALSE;
270:
271: --** if validation level is none, no validation is necessary
272: if (p_validation_level = FND_API.G_VALID_LEVEL_NONE) then
273: p_return_status := FND_API.G_RET_STS_SUCCESS;
274: return TRUE;
275: end if;
276:

Line 273: p_return_status := FND_API.G_RET_STS_SUCCESS;

269: l_error := FALSE;
270:
271: --** if validation level is none, no validation is necessary
272: if (p_validation_level = FND_API.G_VALID_LEVEL_NONE) then
273: p_return_status := FND_API.G_RET_STS_SUCCESS;
274: return TRUE;
275: end if;
276:
277: --** check that key columns are not null and not missing **

Line 279: (p_flow_application_id = FND_API.G_MISS_NUM)) then

275: end if;
276:
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');

Line 289: (p_flow_code = FND_API.G_MISS_CHAR)) then

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

Line 299: (p_page_application_id = FND_API.G_MISS_NUM)) then

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

Line 309: (p_page_code = FND_API.G_MISS_CHAR)) then

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

Line 339: (p_primary_region_appl_id = FND_API.G_MISS_NUM and

335:
336: --** check that required columns are not null and, unless calling **
337: --** from UPDATE procedure, the columns are not missing **
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');

Line 350: (p_primary_region_code = FND_API.G_MISS_CHAR and

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

Line 361: (p_name = FND_API.G_MISS_CHAR and

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

Line 380: if (p_primary_region_appl_id <> FND_API.G_MISS_NUM) and

376: -- is G_NO_PRIMARY_REGION_CODE (as in the case when a page is created
377: -- and before any regions have been added for that flow),
378: -- check that no regions exist for the flow page.
379: --
380: if (p_primary_region_appl_id <> FND_API.G_MISS_NUM) and
381: (p_primary_region_code <> FND_API.G_MISS_CHAR) then
382: if (p_primary_region_code = G_NO_PRIMARY_REGION_CODE) then
383: open l_check_no_region_csr;
384: fetch l_check_no_region_csr into l_dummy;

Line 381: (p_primary_region_code <> FND_API.G_MISS_CHAR) then

377: -- and before any regions have been added for that flow),
378: -- check that no regions exist for the flow page.
379: --
380: if (p_primary_region_appl_id <> FND_API.G_MISS_NUM) and
381: (p_primary_region_code <> FND_API.G_MISS_CHAR) then
382: if (p_primary_region_code = G_NO_PRIMARY_REGION_CODE) 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

Line 419: p_return_status := FND_API.G_RET_STS_SUCCESS;

415: end if;
416: end if;
417:
418: -- return true if no error, false otherwise
419: p_return_status := FND_API.G_RET_STS_SUCCESS;
420: return (not l_error);
421:
422: EXCEPTION
423: WHEN FND_API.G_EXC_ERROR THEN

Line 423: WHEN FND_API.G_EXC_ERROR THEN

419: p_return_status := FND_API.G_RET_STS_SUCCESS;
420: return (not l_error);
421:
422: EXCEPTION
423: WHEN FND_API.G_EXC_ERROR THEN
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;

Line 424: p_return_status := FND_API.G_RET_STS_ERROR;

420: return (not l_error);
421:
422: EXCEPTION
423: WHEN FND_API.G_EXC_ERROR THEN
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,

Line 427: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 471: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

467: -- Version Initial version number = 1.0
468: -- History Current version number = 1.0
469: --=======================================================
470: function VALIDATE_PAGE_REGION (
471: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
472: p_api_version_number IN NUMBER,
473: p_return_status OUT NOCOPY VARCHAR2,
474: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
475: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 474: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,

470: function VALIDATE_PAGE_REGION (
471: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
472: p_api_version_number IN NUMBER,
473: p_return_status OUT NOCOPY VARCHAR2,
474: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
475: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
476: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
477: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
478: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 475: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

471: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
472: p_api_version_number IN NUMBER,
473: p_return_status OUT NOCOPY VARCHAR2,
474: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
475: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
476: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
477: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
478: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
479: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 476: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,

472: p_api_version_number IN NUMBER,
473: p_return_status OUT NOCOPY VARCHAR2,
474: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
475: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
476: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
477: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
478: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
479: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,

Line 477: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

473: p_return_status OUT NOCOPY VARCHAR2,
474: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
475: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
476: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
477: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
478: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
479: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
481: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 478: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

474: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
475: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
476: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
477: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
478: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
479: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
481: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
482: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,

Line 479: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

475: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
476: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
477: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
478: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
479: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
481: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
482: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
483: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 480: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,

476: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
477: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
478: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
479: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
481: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
482: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
483: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 481: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,

477: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
478: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
479: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
481: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
482: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
483: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
485: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 482: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,

478: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
479: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
481: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
482: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
483: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
485: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 483: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,

479: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
481: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
482: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
483: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
485: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 484: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

480: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
481: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
482: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
483: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
485: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
488: p_caller IN VARCHAR2,

Line 485: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

481: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
482: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
483: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
485: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
488: p_caller IN VARCHAR2,
489: p_pass IN NUMBER := 2

Line 486: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

482: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
483: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
485: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
488: p_caller IN VARCHAR2,
489: p_pass IN NUMBER := 2
490: ) return BOOLEAN is

Line 487: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,

483: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
485: p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
488: p_caller IN VARCHAR2,
489: p_pass IN NUMBER := 2
490: ) return BOOLEAN is
491: cursor l_check_seq_csr is

Line 517: IF NOT FND_API.Compatible_API_Call (

513: l_primary_region_code VARCHAR2(30);
514: l_return_status varchar2(1);
515: begin
516:
517: IF NOT FND_API.Compatible_API_Call (
518: l_api_version_number, p_api_version_number, l_api_name,
519: G_PKG_NAME) then
520: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521: return FALSE;

Line 520: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

516:
517: IF NOT FND_API.Compatible_API_Call (
518: l_api_version_number, p_api_version_number, l_api_name,
519: G_PKG_NAME) then
520: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521: return FALSE;
522: END IF;
523:
524: l_error := FALSE;

Line 527: if (p_validation_level = FND_API.G_VALID_LEVEL_NONE) then

523:
524: l_error := FALSE;
525:
526: --** if validation level is none, no validation is necessary
527: if (p_validation_level = FND_API.G_VALID_LEVEL_NONE) then
528: p_return_status := FND_API.G_RET_STS_SUCCESS;
529: return TRUE;
530: end if;
531:

Line 528: p_return_status := FND_API.G_RET_STS_SUCCESS;

524: l_error := FALSE;
525:
526: --** if validation level is none, no validation is necessary
527: if (p_validation_level = FND_API.G_VALID_LEVEL_NONE) then
528: p_return_status := FND_API.G_RET_STS_SUCCESS;
529: return TRUE;
530: end if;
531:
532: --** check that key columns are not null and not missing **

Line 534: (p_flow_application_id = FND_API.G_MISS_NUM)) then

530: end if;
531:
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');

Line 544: (p_flow_code = FND_API.G_MISS_CHAR)) then

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

Line 554: (p_page_application_id = FND_API.G_MISS_NUM)) then

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

Line 564: (p_page_code = FND_API.G_MISS_CHAR)) then

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

Line 574: (p_region_application_id = FND_API.G_MISS_NUM)) then

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

Line 584: (p_region_code = FND_API.G_MISS_CHAR)) then

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

Line 636: ((p_region_style = FND_API.G_MISS_CHAR) and

632: --** check that required columns are not null and, unless calling **
633: --** from UPDATE procedure, the columns are not missing **
634: --
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');

Line 648: if (p_region_style <> FND_API.G_MISS_CHAR) then

644: end if;
645:
646: --** Validate columns **
647: -- - Region style
648: if (p_region_style <> FND_API.G_MISS_CHAR) then
649: if (NOT AK_ON_OBJECTS_PVT.VALID_LOOKUP_CODE (
650: p_api_version_number => 1.0,
651: p_return_status => l_return_status,
652: p_lookup_type => 'REGION_STYLE',

Line 667: if (p_display_sequence <> FND_API.G_MISS_NUM) and

663:
664: --
665: -- - Display sequence (must be unique within page)
666: --
667: if (p_display_sequence <> FND_API.G_MISS_NUM) and
668: (p_display_sequence is not null) then
669: open l_check_seq_csr;
670: fetch l_check_seq_csr into l_dummy;
671: if (l_check_seq_csr%found) then

Line 685: if ( ( (p_parent_region_application_id <> FND_API.G_MISS_NUM) and

681: --
682: -- - Checks for parent_region_application_id and parent_region_code
683: -- (do not perform check if both parms are missing or null)
684: --
685: if ( ( (p_parent_region_application_id <> FND_API.G_MISS_NUM) and
686: (p_parent_region_application_id is not null) )
687: or
688: ( (p_parent_region_code <> FND_API.G_MISS_CHAR) and
689: (p_parent_region_code is not null) ) )then

Line 688: ( (p_parent_region_code <> FND_API.G_MISS_CHAR) and

684: --
685: if ( ( (p_parent_region_application_id <> FND_API.G_MISS_NUM) and
686: (p_parent_region_application_id is not null) )
687: or
688: ( (p_parent_region_code <> FND_API.G_MISS_CHAR) and
689: (p_parent_region_code is not null) ) )then
690: -- dbms_output.put_line('parent region in validate_page_region = '||to_char(p_parent_region_application_id)
691: -- ||' '||p_parent_region_code);
692: --

Line 756: if ( (p_foreign_key_name = FND_API.G_MISS_CHAR) or

752: --
753: -- if the current action is to download a page region, the
754: -- foreign key name cannot be missing.
755: --
756: if ( (p_foreign_key_name = FND_API.G_MISS_CHAR) or
757: (p_foreign_key_name is null) ) then
758: -- dbms_output.put_line('p_foreign_key_name is null: '||p_flow_code||' '||p_page_code||' '||
759: -- p_parent_region_code);
760: if (p_caller <> AK_ON_OBJECTS_PVT.G_DOWNLOAD) then

Line 812: p_return_status := FND_API.G_RET_STS_SUCCESS;

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 */
811: -- return true if no error, false otherwise
812: p_return_status := FND_API.G_RET_STS_SUCCESS;
813: return (not l_error);
814:
815: EXCEPTION
816: WHEN FND_API.G_EXC_ERROR THEN

Line 816: WHEN FND_API.G_EXC_ERROR THEN

812: p_return_status := FND_API.G_RET_STS_SUCCESS;
813: return (not l_error);
814:
815: EXCEPTION
816: WHEN FND_API.G_EXC_ERROR THEN
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;

Line 817: p_return_status := FND_API.G_RET_STS_ERROR;

813: return (not l_error);
814:
815: EXCEPTION
816: WHEN FND_API.G_EXC_ERROR THEN
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,

Line 820: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 860: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

856: -- Version Initial version number = 1.0
857: -- History Current version number = 1.0
858: --=======================================================
859: function VALIDATE_PAGE_REGION_ITEM (
860: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
861: p_api_version_number IN NUMBER,
862: p_return_status OUT NOCOPY VARCHAR2,
863: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
864: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 863: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,

859: function VALIDATE_PAGE_REGION_ITEM (
860: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
861: p_api_version_number IN NUMBER,
862: p_return_status OUT NOCOPY VARCHAR2,
863: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
864: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
866: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 864: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

860: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
861: p_api_version_number IN NUMBER,
862: p_return_status OUT NOCOPY VARCHAR2,
863: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
864: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
866: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
868: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 865: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,

861: p_api_version_number IN NUMBER,
862: p_return_status OUT NOCOPY VARCHAR2,
863: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
864: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
866: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
868: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 866: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

862: p_return_status OUT NOCOPY VARCHAR2,
863: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
864: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
866: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
868: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
870: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 867: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

863: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
864: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
866: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
868: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
870: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,

Line 868: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

864: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
865: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
866: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
868: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
870: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
872: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 869: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

865: p_page_application_id IN NUMBER := FND_API.G_MISS_NUM,
866: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
868: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
870: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
872: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,

Line 870: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

866: p_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
867: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
868: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
870: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
872: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
874: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 871: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,

867: p_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
868: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
870: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
872: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
874: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_caller IN VARCHAR2,

Line 872: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

868: p_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
869: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
870: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
872: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
874: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_caller IN VARCHAR2,
876: p_pass IN NUMBER := 2

Line 873: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,

869: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
870: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
872: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
874: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_caller IN VARCHAR2,
876: p_pass IN NUMBER := 2
877: ) return BOOLEAN is

Line 874: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

870: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
871: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
872: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
873: p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
874: p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
875: p_caller IN VARCHAR2,
876: p_pass IN NUMBER := 2
877: ) return BOOLEAN is
878: cursor l_check_to_url_csr is

Line 903: IF NOT FND_API.Compatible_API_Call (

899: l_error BOOLEAN;
900: l_return_status varchar2(1);
901: begin
902:
903: IF NOT FND_API.Compatible_API_Call (
904: l_api_version_number, p_api_version_number, l_api_name,
905: G_PKG_NAME) then
906: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
907: return FALSE;

Line 906: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

902:
903: IF NOT FND_API.Compatible_API_Call (
904: l_api_version_number, p_api_version_number, l_api_name,
905: G_PKG_NAME) then
906: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
907: return FALSE;
908: END IF;
909:
910: l_error := FALSE;

Line 913: if (p_validation_level = FND_API.G_VALID_LEVEL_NONE) then

909:
910: l_error := FALSE;
911:
912: --** if validation level is none, no validation is necessary
913: if (p_validation_level = FND_API.G_VALID_LEVEL_NONE) then
914: p_return_status := FND_API.G_RET_STS_SUCCESS;
915: return TRUE;
916: end if;
917:

Line 914: p_return_status := FND_API.G_RET_STS_SUCCESS;

910: l_error := FALSE;
911:
912: --** if validation level is none, no validation is necessary
913: if (p_validation_level = FND_API.G_VALID_LEVEL_NONE) then
914: p_return_status := FND_API.G_RET_STS_SUCCESS;
915: return TRUE;
916: end if;
917:
918: --** check that key columns are not null and not missing **

Line 920: (p_flow_application_id = FND_API.G_MISS_NUM)) then

916: end if;
917:
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');

Line 930: (p_flow_code = FND_API.G_MISS_CHAR)) then

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

Line 940: (p_page_application_id = FND_API.G_MISS_NUM)) then

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

Line 950: (p_page_code = FND_API.G_MISS_CHAR)) then

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

Line 960: (p_region_application_id = FND_API.G_MISS_NUM)) then

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

Line 970: (p_region_code = FND_API.G_MISS_CHAR)) then

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

Line 980: (p_attribute_application_id = FND_API.G_MISS_NUM)) then

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

Line 990: (p_attribute_code = FND_API.G_MISS_CHAR)) then

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

Line 1053: (p_to_page_appl_id <> FND_API.G_MISS_NUM) and

1049: -- - if to_page_appl_id is given, to_page_code must also be given, and
1050: -- vice versa.
1051: --
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');

Line 1054: ((p_to_page_code is null) or (p_to_page_code = FND_API.G_MISS_CHAR)) then

1050: -- vice versa.
1051: --
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');

Line 1064: (p_to_page_code <> FND_API.G_MISS_CHAR) and

1060: end if;
1061: end if;
1062:
1063: if (p_to_page_code is not null) and
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

Line 1066: (p_to_page_appl_id = FND_API.G_MISS_NUM)) then

1062:
1063: if (p_to_page_code is not null) and
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');

Line 1080: (p_to_url_attribute_appl_id <> FND_API.G_MISS_NUM) and

1076: -- - if to_url_attribute_appl_id is given, to_url_attribute_code must
1077: -- also be given, and vice versa.
1078: --
1079: if (p_to_url_attribute_appl_id is not null) and
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

Line 1082: (p_to_url_attribute_code = FND_API.G_MISS_CHAR)) then

1078: --
1079: if (p_to_url_attribute_appl_id is not null) and
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');

Line 1092: (p_to_url_attribute_code <> FND_API.G_MISS_CHAR) and

1088: end if;
1089: end if;
1090:
1091: if (p_to_url_attribute_code is not null) and
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

Line 1094: (p_to_url_attribute_appl_id = FND_API.G_MISS_NUM)) then

1090:
1091: if (p_to_url_attribute_code is not null) and
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');

Line 1108: (p_to_page_code = FND_API.G_MISS_CHAR) ) and

1104: -- - either to_page or to_url_attribute must be specified,
1105: -- unless calling from update.
1106: --
1107: if ( (p_to_page_code is null) or
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

Line 1110: (p_to_url_attribute_code = FND_API.G_MISS_CHAR) ) then

1106: --
1107: if ( (p_to_page_code is null) or
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;

Line 1122: (p_to_page_code <> FND_API.G_MISS_CHAR) ) and

1118: --
1119: -- - cannot specify both to_page and to_url_attribute
1120: --
1121: if ( (p_to_page_code is not null) and
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

Line 1124: (p_to_url_attribute_code <> FND_API.G_MISS_CHAR) ) then

1120: --
1121: if ( (p_to_page_code is not null) and
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;

Line 1137: if not ( ( (p_to_page_appl_id = FND_API.G_MISS_NUM) or

1133: --** Validate columns **
1134: --
1135: -- to_page_appl_id and to_page_code
1136: --
1137: if not ( ( (p_to_page_appl_id = FND_API.G_MISS_NUM) or
1138: (p_to_page_appl_id is null) )
1139: or
1140: ( (p_to_page_code = FND_API.G_MISS_CHAR) or
1141: (p_to_page_code is null) ) ) then

Line 1140: ( (p_to_page_code = FND_API.G_MISS_CHAR) or

1136: --
1137: if not ( ( (p_to_page_appl_id = FND_API.G_MISS_NUM) or
1138: (p_to_page_appl_id is null) )
1139: or
1140: ( (p_to_page_code = FND_API.G_MISS_CHAR) or
1141: (p_to_page_code is null) ) ) then
1142: --
1143: -- 1. The target page must exist
1144: --

Line 1188: if (p_to_url_attribute_appl_id <> FND_API.G_MISS_NUM and

1184: -- to_url_attribute_appl_id and to_url_attribute_code
1185: --
1186: -- - To URL attribute must be a 'URL' type attribute
1187: --
1188: if (p_to_url_attribute_appl_id <> FND_API.G_MISS_NUM and
1189: p_to_url_attribute_appl_id is not null) OR
1190: (p_to_url_attribute_code <> FND_API.G_MISS_CHAR and
1191: p_to_url_attribute_code is not null) then
1192: open l_check_to_url_csr;

Line 1190: (p_to_url_attribute_code <> FND_API.G_MISS_CHAR and

1186: -- - To URL attribute must be a 'URL' type attribute
1187: --
1188: if (p_to_url_attribute_appl_id <> FND_API.G_MISS_NUM and
1189: p_to_url_attribute_appl_id is not null) OR
1190: (p_to_url_attribute_code <> FND_API.G_MISS_CHAR and
1191: p_to_url_attribute_code is not null) 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

Line 1207: p_return_status := FND_API.G_RET_STS_SUCCESS;

1203: close l_check_to_url_csr;
1204: end if;
1205:
1206: -- return true if no error, false otherwise
1207: p_return_status := FND_API.G_RET_STS_SUCCESS;
1208: return (not l_error);
1209:
1210: EXCEPTION
1211: WHEN FND_API.G_EXC_ERROR THEN

Line 1211: WHEN FND_API.G_EXC_ERROR THEN

1207: p_return_status := FND_API.G_RET_STS_SUCCESS;
1208: return (not l_error);
1209:
1210: EXCEPTION
1211: WHEN FND_API.G_EXC_ERROR THEN
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;

Line 1212: p_return_status := FND_API.G_RET_STS_ERROR;

1208: return (not l_error);
1209:
1210: EXCEPTION
1211: WHEN FND_API.G_EXC_ERROR THEN
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,

Line 1215: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1255: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1251: -- Version Initial version number = 1.0
1252: -- History Current version number = 1.0
1253: --=======================================================
1254: function VALIDATE_REGION_RELATION (
1255: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1256: p_api_version_number IN NUMBER,
1257: p_return_status OUT NOCOPY VARCHAR2,
1258: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
1259: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1258: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,

1254: function VALIDATE_REGION_RELATION (
1255: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1256: p_api_version_number IN NUMBER,
1257: p_return_status OUT NOCOPY VARCHAR2,
1258: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
1259: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1260: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1261: p_from_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1262: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1259: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

1255: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1256: p_api_version_number IN NUMBER,
1257: p_return_status OUT NOCOPY VARCHAR2,
1258: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
1259: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1260: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1261: p_from_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1262: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1260: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

1256: p_api_version_number IN NUMBER,
1257: p_return_status OUT NOCOPY VARCHAR2,
1258: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
1259: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1260: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1261: p_from_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1262: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1264: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1261: p_from_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,

1257: p_return_status OUT NOCOPY VARCHAR2,
1258: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
1259: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1260: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1261: p_from_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1262: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1264: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1265: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1262: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

1258: p_flow_application_id IN NUMBER := FND_API.G_MISS_NUM,
1259: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1260: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1261: p_from_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1262: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1264: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1265: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1266: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1263: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,

1259: p_flow_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1260: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1261: p_from_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1262: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1264: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1265: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1266: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1267: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1264: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

1260: p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1261: p_from_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1262: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1264: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1265: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1266: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1267: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1268: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1265: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,

1261: p_from_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1262: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1264: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1265: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1266: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1267: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1268: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1269: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1266: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

1262: p_from_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1263: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1264: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1265: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1266: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1267: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1268: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1269: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1270: p_caller IN VARCHAR2,

Line 1267: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,

1263: p_from_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1264: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1265: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1266: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1267: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1268: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1269: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1270: p_caller IN VARCHAR2,
1271: p_pass IN NUMBER := 2

Line 1268: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

1264: p_from_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1265: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1266: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1267: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1268: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1269: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1270: p_caller IN VARCHAR2,
1271: p_pass IN NUMBER := 2
1272: ) return BOOLEAN is

Line 1269: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

1265: p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1266: p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1267: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1268: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1269: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1270: p_caller IN VARCHAR2,
1271: p_pass IN NUMBER := 2
1272: ) return BOOLEAN is
1273: cursor l_check_fk_connect_csr is

Line 1304: IF NOT FND_API.Compatible_API_Call (

1300: l_error BOOLEAN;
1301: l_return_status varchar2(1);
1302: begin
1303:
1304: IF NOT FND_API.Compatible_API_Call (
1305: l_api_version_number, p_api_version_number, l_api_name,
1306: G_PKG_NAME) then
1307: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1308: return FALSE;

Line 1307: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1303:
1304: IF NOT FND_API.Compatible_API_Call (
1305: l_api_version_number, p_api_version_number, l_api_name,
1306: G_PKG_NAME) then
1307: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1308: return FALSE;
1309: END IF;
1310:
1311: l_error := FALSE;

Line 1314: if (p_validation_level = FND_API.G_VALID_LEVEL_NONE) then

1310:
1311: l_error := FALSE;
1312:
1313: --** if validation level is none, no validation is necessary
1314: if (p_validation_level = FND_API.G_VALID_LEVEL_NONE) then
1315: p_return_status := FND_API.G_RET_STS_SUCCESS;
1316: return TRUE;
1317: end if;
1318:

Line 1315: p_return_status := FND_API.G_RET_STS_SUCCESS;

1311: l_error := FALSE;
1312:
1313: --** if validation level is none, no validation is necessary
1314: if (p_validation_level = FND_API.G_VALID_LEVEL_NONE) then
1315: p_return_status := FND_API.G_RET_STS_SUCCESS;
1316: return TRUE;
1317: end if;
1318:
1319: --** check that key columns are not null and not missing **

Line 1321: (p_flow_application_id = FND_API.G_MISS_NUM)) then

1317: end if;
1318:
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');

Line 1331: (p_flow_code = FND_API.G_MISS_CHAR)) then

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

Line 1341: (p_foreign_key_name = FND_API.G_MISS_CHAR)) then

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

Line 1351: (p_from_page_appl_id = FND_API.G_MISS_NUM)) then

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

Line 1361: (p_from_page_code = FND_API.G_MISS_CHAR)) then

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

Line 1371: (p_from_region_appl_id = FND_API.G_MISS_NUM)) then

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

Line 1381: (p_from_region_code = FND_API.G_MISS_CHAR)) then

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

Line 1391: (p_to_page_appl_id = FND_API.G_MISS_NUM)) then

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

Line 1401: (p_to_page_code = FND_API.G_MISS_CHAR)) then

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

Line 1411: (p_to_region_appl_id = FND_API.G_MISS_NUM)) then

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

Line 1421: (p_to_region_code = FND_API.G_MISS_CHAR)) then

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

Line 1518: ((p_application_id = FND_API.G_MISS_NUM) and

1514: --** check that required columns are not null and, unless calling **
1515: --** from UPDATE procedure, the columns are not missing **
1516: --
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');

Line 1533: if (p_application_id <> FND_API.G_MISS_NUM) then

1529: -- Validate columns
1530: --
1531: -- - application ID
1532: --
1533: if (p_application_id <> FND_API.G_MISS_NUM) then
1534: if (NOT AK_ON_OBJECTS_PVT.VALID_APPLICATION_ID (
1535: p_api_version_number => 1.0,
1536: p_return_status => l_return_status,
1537: p_application_id => p_application_id)

Line 1578: p_return_status := FND_API.G_RET_STS_SUCCESS;

1574: end if;
1575: close l_check_fk_connect_csr;
1576:
1577: -- return true if no error, false otherwise
1578: p_return_status := FND_API.G_RET_STS_SUCCESS;
1579: return (not l_error);
1580:
1581: EXCEPTION
1582: WHEN FND_API.G_EXC_ERROR THEN

Line 1582: WHEN FND_API.G_EXC_ERROR THEN

1578: p_return_status := FND_API.G_RET_STS_SUCCESS;
1579: return (not l_error);
1580:
1581: EXCEPTION
1582: WHEN FND_API.G_EXC_ERROR THEN
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;

Line 1583: p_return_status := FND_API.G_RET_STS_ERROR;

1579: return (not l_error);
1580:
1581: EXCEPTION
1582: WHEN FND_API.G_EXC_ERROR THEN
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,

Line 1586: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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