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.JTF_DSP_SECTION_ITEM_PVT dependencies on FND_API

Line 70: (x_section_item_id = FND_API.G_MISS_NUM))

66:
67: -- Primary key validation check
68: x_section_item_id := p_section_item_id;
69: IF ((x_section_item_id IS NULL) OR
70: (x_section_item_id = FND_API.G_MISS_NUM))
71: THEN
72: OPEN c2;
73: FETCH c2 INTO x_section_item_id;
74: CLOSE c2;

Line 103: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),

99: p_section_id,
100: p_inventory_item_id,
101: p_organization_id,
102: p_start_date_active,
103: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
104: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
105: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
106: NULL, p_association_reason_code),
107: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

Line 104: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),

100: p_inventory_item_id,
101: p_organization_id,
102: p_start_date_active,
103: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
104: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
105: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
106: NULL, p_association_reason_code),
107: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
108: p_creation_date),

Line 105: decode(p_association_reason_code, FND_API.G_MISS_CHAR,

101: p_organization_id,
102: p_start_date_active,
103: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
104: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
105: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
106: NULL, p_association_reason_code),
107: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
108: p_creation_date),
109: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 107: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

103: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
104: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
105: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
106: NULL, p_association_reason_code),
107: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
108: p_creation_date),
109: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
110: NULL, FND_GLOBAL.user_id, p_created_by),
111: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

Line 109: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

105: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
106: NULL, p_association_reason_code),
107: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
108: p_creation_date),
109: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
110: NULL, FND_GLOBAL.user_id, p_created_by),
111: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
112: p_last_update_date),
113: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 111: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

107: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
108: p_creation_date),
109: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
110: NULL, FND_GLOBAL.user_id, p_created_by),
111: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
112: p_last_update_date),
113: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
114: NULL, FND_GLOBAL.user_id, p_last_updated_by),
115: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

Line 113: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

109: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
110: NULL, FND_GLOBAL.user_id, p_created_by),
111: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
112: p_last_update_date),
113: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
114: NULL, FND_GLOBAL.user_id, p_last_updated_by),
115: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
116: NULL, FND_GLOBAL.login_id, p_last_update_login)
117: );

Line 115: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

111: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
112: p_last_update_date),
113: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
114: NULL, FND_GLOBAL.user_id, p_last_updated_by),
115: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
116: NULL, FND_GLOBAL.login_id, p_last_update_login)
117: );
118:
119: OPEN c;

Line 137: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

133:
134: PROCEDURE update_row
135: (
136: p_section_item_id IN NUMBER,
137: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
138: p_start_date_active IN DATE,
139: p_end_date_active IN DATE,
140: p_sort_order IN NUMBER,
141: p_association_reason_code IN VARCHAR2,

Line 152: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,

148:
149: -- update base
150: UPDATE jtf_dsp_section_items SET
151: object_version_number = object_version_number + 1,
152: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
153: sort_order, p_sort_order),
154: association_reason_code =
155: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
156: association_reason_code, p_association_reason_code),

Line 155: decode(p_association_reason_code, FND_API.G_MISS_CHAR,

151: object_version_number = object_version_number + 1,
152: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
153: sort_order, p_sort_order),
154: association_reason_code =
155: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
156: association_reason_code, p_association_reason_code),
157: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
158: start_date_active, p_start_date_active),
159: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,

Line 157: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,

153: sort_order, p_sort_order),
154: association_reason_code =
155: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
156: association_reason_code, p_association_reason_code),
157: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
158: start_date_active, p_start_date_active),
159: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
160: end_date_active, p_end_date_active),
161: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,

Line 159: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,

155: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
156: association_reason_code, p_association_reason_code),
157: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
158: start_date_active, p_start_date_active),
159: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
160: end_date_active, p_end_date_active),
161: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
162: sysdate, NULL, sysdate, p_last_update_date),
163: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,

Line 161: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,

157: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
158: start_date_active, p_start_date_active),
159: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
160: end_date_active, p_end_date_active),
161: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
162: sysdate, NULL, sysdate, p_last_update_date),
163: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
164: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
165: p_last_updated_by),

Line 163: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,

159: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
160: end_date_active, p_end_date_active),
161: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
162: sysdate, NULL, sysdate, p_last_update_date),
163: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
164: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
165: p_last_updated_by),
166: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
167: FND_GLOBAL.login_id, NULL,

Line 166: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,

162: sysdate, NULL, sysdate, p_last_update_date),
163: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
164: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
165: p_last_updated_by),
166: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
167: FND_GLOBAL.login_id, NULL,
168: FND_GLOBAL.login_id, p_last_update_login)
169: WHERE section_item_id = p_section_item_id
170: AND object_version_number = decode(p_object_version_number,

Line 171: FND_API.G_MISS_NUM,

167: FND_GLOBAL.login_id, NULL,
168: FND_GLOBAL.login_id, p_last_update_login)
169: WHERE section_item_id = p_section_item_id
170: AND object_version_number = decode(p_object_version_number,
171: FND_API.G_MISS_NUM,
172: object_version_number,
173: p_object_version_number);
174:
175: IF (sql%NOTFOUND) THEN

Line 221: -- x_return_status = FND_API.G_RET_STS_SUCCESS, if the section is duplicate

217: -- PROCEDURE Check_Duplicate_Entry()
218: --*****************************************************************************
219:
220: --
221: -- x_return_status = FND_API.G_RET_STS_SUCCESS, if the section is duplicate
222: -- x_return_status = FND_API.G_RET_STS_ERROR, if the section is not duplicate
223: --
224: --
225: PROCEDURE Check_Duplicate_Entry

Line 222: -- x_return_status = FND_API.G_RET_STS_ERROR, if the section is not duplicate

218: --*****************************************************************************
219:
220: --
221: -- x_return_status = FND_API.G_RET_STS_SUCCESS, if the section is duplicate
222: -- x_return_status = FND_API.G_RET_STS_ERROR, if the section is not duplicate
223: --
224: --
225: PROCEDURE Check_Duplicate_Entry
226: (

Line 227: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

223: --
224: --
225: PROCEDURE Check_Duplicate_Entry
226: (
227: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
228: p_section_id IN NUMBER,
229: p_inventory_item_id IN NUMBER,
230: p_organization_id IN NUMBER,
231: x_return_status OUT VARCHAR2,

Line 243: IF FND_API.to_Boolean(p_init_msg_list) THEN

239: l_tmp_section_item_id NUMBER;
240: BEGIN
241:
242: -- Initialize message list if p_init_msg_list is set to TRUE.
243: IF FND_API.to_Boolean(p_init_msg_list) THEN
244: FND_MSG_PUB.initialize;
245: END IF;
246:
247: -- Initialize API return status to error, i.e, its not duplicate

Line 248: x_return_status := FND_API.G_RET_STS_ERROR;

244: FND_MSG_PUB.initialize;
245: END IF;
246:
247: -- Initialize API return status to error, i.e, its not duplicate
248: x_return_status := FND_API.G_RET_STS_ERROR;
249:
250: -- Check duplicate entry
251: BEGIN
252:

Line 267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

263: -- do nothing
264: NULL;
265:
266: WHEN OTHERS THEN
267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
268:
269: END;
270:
271: IF (l_tmp_section_item_id IS NOT NULL) THEN

Line 273: RAISE FND_API.G_EXC_ERROR;

269: END;
270:
271: IF (l_tmp_section_item_id IS NOT NULL) THEN
272: -- found duplicate
273: RAISE FND_API.G_EXC_ERROR;
274: END IF;
275:
276: EXCEPTION
277:

Line 278: WHEN FND_API.G_EXC_ERROR THEN

274: END IF;
275:
276: EXCEPTION
277:
278: WHEN FND_API.G_EXC_ERROR THEN
279: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate
280: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
281: p_data => x_msg_data,
282: p_encoded => 'F');

Line 279: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate

275:
276: EXCEPTION
277:
278: WHEN FND_API.G_EXC_ERROR THEN
279: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate
280: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
281: p_data => x_msg_data,
282: p_encoded => 'F');
283:

Line 284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

280: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
281: p_data => x_msg_data,
282: p_encoded => 'F');
283:
284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
287: p_data => x_msg_data,
288: p_encoded => 'F');

Line 285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

281: p_data => x_msg_data,
282: p_encoded => 'F');
283:
284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
287: p_data => x_msg_data,
288: p_encoded => 'F');
289:

Line 291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

287: p_data => x_msg_data,
288: p_encoded => 'F');
289:
290: WHEN OTHERS THEN
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292:
293: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
294: THEN
295: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 308: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid

304:
305: --*****************************************************************************
306: -- PROCEDURE Validate_Create()
307: --*****************************************************************************
308: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
309: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
310:
311: PROCEDURE Validate_Create
312: (

Line 309: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid

305: --*****************************************************************************
306: -- PROCEDURE Validate_Create()
307: --*****************************************************************************
308: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
309: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
310:
311: PROCEDURE Validate_Create
312: (
313: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 313: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

309: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
310:
311: PROCEDURE Validate_Create
312: (
313: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
315: p_section_id IN NUMBER,
316: p_inventory_item_id IN NUMBER,
317: p_organization_id IN NUMBER,

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

310:
311: PROCEDURE Validate_Create
312: (
313: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
315: p_section_id IN NUMBER,
316: p_inventory_item_id IN NUMBER,
317: p_organization_id IN NUMBER,
318: p_start_date_active IN DATE,

Line 349: IF FND_API.to_Boolean(p_init_msg_list) THEN

345:
346: BEGIN
347:
348: -- Initialize message list if p_init_msg_list is set to TRUE.
349: IF FND_API.to_Boolean(p_init_msg_list) THEN
350: FND_MSG_PUB.initialize;
351: END IF;
352:
353: -- Initialize API return status to success

Line 354: x_return_status := FND_API.G_RET_STS_SUCCESS;

350: FND_MSG_PUB.initialize;
351: END IF;
352:
353: -- Initialize API return status to success
354: x_return_status := FND_API.G_RET_STS_SUCCESS;
355:
356: --
357: -- Check null values for required fields
358: --

Line 362: (p_section_id = FND_API.G_MISS_NUM))

358: --
359:
360: -- section id
361: IF ((p_section_id IS NULL) OR
362: (p_section_id = FND_API.G_MISS_NUM))
363: THEN
364: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_ID');
365: FND_MSG_PUB.Add;
366: RAISE FND_API.G_EXC_ERROR;

Line 366: RAISE FND_API.G_EXC_ERROR;

362: (p_section_id = FND_API.G_MISS_NUM))
363: THEN
364: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_ID');
365: FND_MSG_PUB.Add;
366: RAISE FND_API.G_EXC_ERROR;
367: END IF;
368:
369: -- inventory item id
370: IF ((p_inventory_item_id IS NULL) OR

Line 371: (p_inventory_item_id = FND_API.G_MISS_NUM))

367: END IF;
368:
369: -- inventory item id
370: IF ((p_inventory_item_id IS NULL) OR
371: (p_inventory_item_id = FND_API.G_MISS_NUM))
372: THEN
373: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_INV_ITEM_ID');
374: FND_MSG_PUB.Add;
375: RAISE FND_API.G_EXC_ERROR;

Line 375: RAISE FND_API.G_EXC_ERROR;

371: (p_inventory_item_id = FND_API.G_MISS_NUM))
372: THEN
373: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_INV_ITEM_ID');
374: FND_MSG_PUB.Add;
375: RAISE FND_API.G_EXC_ERROR;
376: END IF;
377:
378: -- organization id
379: IF ((p_organization_id IS NULL) OR

Line 380: (p_organization_id = FND_API.G_MISS_NUM))

376: END IF;
377:
378: -- organization id
379: IF ((p_organization_id IS NULL) OR
380: (p_organization_id = FND_API.G_MISS_NUM))
381: THEN
382: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_INV_ORG_ID');
383: FND_MSG_PUB.Add;
384: RAISE FND_API.G_EXC_ERROR;

Line 384: RAISE FND_API.G_EXC_ERROR;

380: (p_organization_id = FND_API.G_MISS_NUM))
381: THEN
382: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_INV_ORG_ID');
383: FND_MSG_PUB.Add;
384: RAISE FND_API.G_EXC_ERROR;
385: END IF;
386:
387: -- start_date_active
388: IF ((p_start_date_active IS NULL) OR

Line 389: (p_start_date_active = FND_API.G_MISS_DATE))

385: END IF;
386:
387: -- start_date_active
388: IF ((p_start_date_active IS NULL) OR
389: (p_start_date_active = FND_API.G_MISS_DATE))
390: THEN
391: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');
392: FND_MSG_PUB.Add;
393: RAISE FND_API.G_EXC_ERROR;

Line 393: RAISE FND_API.G_EXC_ERROR;

389: (p_start_date_active = FND_API.G_MISS_DATE))
390: THEN
391: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');
392: FND_MSG_PUB.Add;
393: RAISE FND_API.G_EXC_ERROR;
394: END IF;
395:
396: --
397: -- non-null field validation

Line 402: (p_sort_order <> FND_API.G_MISS_NUM))

398: --
399:
400: -- sort order
401: IF ((p_sort_order IS NOT NULL) AND
402: (p_sort_order <> FND_API.G_MISS_NUM))
403: THEN
404: IF(p_sort_order < 0) THEN
405: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_SORT_ORDER');
406: FND_MSG_PUB.Add;

Line 407: RAISE FND_API.G_EXC_ERROR;

403: THEN
404: IF(p_sort_order < 0) THEN
405: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_SORT_ORDER');
406: FND_MSG_PUB.Add;
407: RAISE FND_API.G_EXC_ERROR;
408: END IF;
409: END IF;
410:
411: --

Line 425: RAISE FND_API.G_EXC_ERROR;

421: WHEN NO_DATA_FOUND THEN
422: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ID');
423: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
424: FND_MSG_PUB.Add;
425: RAISE FND_API.G_EXC_ERROR;
426: WHEN OTHERS THEN
427: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ID');
428: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
429: FND_MSG_PUB.Add;

Line 430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

426: WHEN OTHERS THEN
427: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ID');
428: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
429: FND_MSG_PUB.Add;
430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
431: END;
432:
433: -- inventory item id and organization id
434: BEGIN

Line 452: RAISE FND_API.G_EXC_ERROR;

448: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_INV_ITEM_ID');
449: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
450: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
451: FND_MSG_PUB.Add;
452: RAISE FND_API.G_EXC_ERROR;
453: WHEN OTHERS THEN
454: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_GET_INV_ITEM_ID');
455: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
456: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);

Line 458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

454: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_GET_INV_ITEM_ID');
455: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
456: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
457: FND_MSG_PUB.Add;
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: END;
460:
461: -- Validate if the entry is duplicate
462: Check_Duplicate_Entry

Line 464: p_init_msg_list => FND_API.G_FALSE,

460:
461: -- Validate if the entry is duplicate
462: Check_Duplicate_Entry
463: (
464: p_init_msg_list => FND_API.G_FALSE,
465: p_section_id => p_section_id,
466: p_inventory_item_id => p_inventory_item_id,
467: p_organization_id => p_organization_id,
468: x_return_status => l_return_status,

Line 472: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

468: x_return_status => l_return_status,
469: x_msg_count => l_msg_count,
470: x_msg_data => l_msg_data);
471:
472: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
475: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_DUPLICATE_ENTRY');
476: FND_MSG_PUB.Add;

Line 473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

469: x_msg_count => l_msg_count,
470: x_msg_data => l_msg_data);
471:
472: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
475: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_DUPLICATE_ENTRY');
476: FND_MSG_PUB.Add;
477: RAISE FND_API.G_EXC_ERROR; -- duplicate entry

Line 474: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

470: x_msg_data => l_msg_data);
471:
472: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
475: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_DUPLICATE_ENTRY');
476: FND_MSG_PUB.Add;
477: RAISE FND_API.G_EXC_ERROR; -- duplicate entry
478: END IF;

Line 477: RAISE FND_API.G_EXC_ERROR; -- duplicate entry

473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
475: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_DUPLICATE_ENTRY');
476: FND_MSG_PUB.Add;
477: RAISE FND_API.G_EXC_ERROR; -- duplicate entry
478: END IF;
479:
480: --
481: -- Check if the p_section_id doesn't have any child as sections

Line 491: RAISE FND_API.G_EXC_ERROR;

487: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_HAS_CHILD_SCT');
488: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
489: FND_MSG_PUB.Add;
490: CLOSE c1;
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493: CLOSE c1;
494:
495: EXCEPTION

Line 497: WHEN FND_API.G_EXC_ERROR THEN

493: CLOSE c1;
494:
495: EXCEPTION
496:
497: WHEN FND_API.G_EXC_ERROR THEN
498: x_return_status := FND_API.G_RET_STS_ERROR;
499: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
500: p_data => x_msg_data,
501: p_encoded => 'F');

Line 498: x_return_status := FND_API.G_RET_STS_ERROR;

494:
495: EXCEPTION
496:
497: WHEN FND_API.G_EXC_ERROR THEN
498: x_return_status := FND_API.G_RET_STS_ERROR;
499: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
500: p_data => x_msg_data,
501: p_encoded => 'F');
502:

Line 503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

499: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
500: p_data => x_msg_data,
501: p_encoded => 'F');
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
506: p_data => x_msg_data,
507: p_encoded => 'F');

Line 504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

500: p_data => x_msg_data,
501: p_encoded => 'F');
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
506: p_data => x_msg_data,
507: p_encoded => 'F');
508:

Line 510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

506: p_data => x_msg_data,
507: p_encoded => 'F');
508:
509: WHEN OTHERS THEN
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511:
512: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
513: THEN
514: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 527: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid

523:
524: --*****************************************************************************
525: -- PROCEDURE Validate_Update()
526: --*****************************************************************************
527: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
528: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
529:
530: PROCEDURE Validate_Update
531: (

Line 528: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid

524: --*****************************************************************************
525: -- PROCEDURE Validate_Update()
526: --*****************************************************************************
527: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
528: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
529:
530: PROCEDURE Validate_Update
531: (
532: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 532: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

528: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
529:
530: PROCEDURE Validate_Update
531: (
532: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
533: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
534: p_section_item_id IN NUMBER,
535: p_object_version_number IN NUMBER,
536: p_start_date_active IN DATE,

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

529:
530: PROCEDURE Validate_Update
531: (
532: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
533: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
534: p_section_item_id IN NUMBER,
535: p_object_version_number IN NUMBER,
536: p_start_date_active IN DATE,
537: p_end_date_active IN DATE,

Line 559: IF FND_API.to_Boolean(p_init_msg_list) THEN

555:
556: BEGIN
557:
558: -- Initialize message list if p_init_msg_list is set to TRUE.
559: IF FND_API.to_Boolean(p_init_msg_list) THEN
560: FND_MSG_PUB.initialize;
561: END IF;
562:
563: -- Initialize API return status to success

Line 564: x_return_status := FND_API.G_RET_STS_SUCCESS;

560: FND_MSG_PUB.initialize;
561: END IF;
562:
563: -- Initialize API return status to success
564: x_return_status := FND_API.G_RET_STS_SUCCESS;
565:
566: --
567: -- Check null values for required fields
568: --

Line 574: RAISE FND_API.G_EXC_ERROR;

570: -- section_item_id
571: IF (p_section_item_id IS NULL) THEN
572: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_PRIMARY_KEY');
573: FND_MSG_PUB.Add;
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;
576:
577: -- start_date_active
578: IF (p_start_date_active IS NULL) THEN

Line 581: RAISE FND_API.G_EXC_ERROR;

577: -- start_date_active
578: IF (p_start_date_active IS NULL) THEN
579: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');
580: FND_MSG_PUB.Add;
581: RAISE FND_API.G_EXC_ERROR;
582: END IF;
583:
584: --
585: -- non-null field validation

Line 590: (p_sort_order <> FND_API.G_MISS_NUM))

586: --
587:
588: -- sort order
589: IF ((p_sort_order IS NOT NULL) AND
590: (p_sort_order <> FND_API.G_MISS_NUM))
591: THEN
592: IF(p_sort_order < 0) THEN
593: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_SORT_ORDER');
594: FND_MSG_PUB.Add;

Line 595: RAISE FND_API.G_EXC_ERROR;

591: THEN
592: IF(p_sort_order < 0) THEN
593: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_SORT_ORDER');
594: FND_MSG_PUB.Add;
595: RAISE FND_API.G_EXC_ERROR;
596: END IF;
597: END IF;
598:
599: EXCEPTION

Line 601: WHEN FND_API.G_EXC_ERROR THEN

597: END IF;
598:
599: EXCEPTION
600:
601: WHEN FND_API.G_EXC_ERROR THEN
602: x_return_status := FND_API.G_RET_STS_ERROR;
603: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
604: p_data => x_msg_data,
605: p_encoded => 'F');

Line 602: x_return_status := FND_API.G_RET_STS_ERROR;

598:
599: EXCEPTION
600:
601: WHEN FND_API.G_EXC_ERROR THEN
602: x_return_status := FND_API.G_RET_STS_ERROR;
603: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
604: p_data => x_msg_data,
605: p_encoded => 'F');
606:

Line 607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

603: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
604: p_data => x_msg_data,
605: p_encoded => 'F');
606:
607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
610: p_data => x_msg_data,
611: p_encoded => 'F');

Line 608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

604: p_data => x_msg_data,
605: p_encoded => 'F');
606:
607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
610: p_data => x_msg_data,
611: p_encoded => 'F');
612:

Line 614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

610: p_data => x_msg_data,
611: p_encoded => 'F');
612:
613: WHEN OTHERS THEN
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615:
616: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
617: THEN
618: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 634: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

630:
631: PROCEDURE Create_Section_Item
632: (
633: p_api_version IN NUMBER,
634: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
635: p_commit IN VARCHAR2 := FND_API.G_FALSE,
636: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
637: p_section_id IN NUMBER,
638: p_inventory_item_id IN NUMBER,

Line 635: p_commit IN VARCHAR2 := FND_API.G_FALSE,

631: PROCEDURE Create_Section_Item
632: (
633: p_api_version IN NUMBER,
634: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
635: p_commit IN VARCHAR2 := FND_API.G_FALSE,
636: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
637: p_section_id IN NUMBER,
638: p_inventory_item_id IN NUMBER,
639: p_organization_id IN NUMBER,

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

632: (
633: p_api_version IN NUMBER,
634: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
635: p_commit IN VARCHAR2 := FND_API.G_FALSE,
636: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
637: p_section_id IN NUMBER,
638: p_inventory_item_id IN NUMBER,
639: p_organization_id IN NUMBER,
640: p_start_date_active IN DATE,

Line 641: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

637: p_section_id IN NUMBER,
638: p_inventory_item_id IN NUMBER,
639: p_organization_id IN NUMBER,
640: p_start_date_active IN DATE,
641: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
642: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
643: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: x_section_item_id OUT NUMBER,
645: x_return_status OUT VARCHAR2,

Line 642: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,

638: p_inventory_item_id IN NUMBER,
639: p_organization_id IN NUMBER,
640: p_start_date_active IN DATE,
641: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
642: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
643: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: x_section_item_id OUT NUMBER,
645: x_return_status OUT VARCHAR2,
646: x_msg_count OUT NUMBER,

Line 643: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

639: p_organization_id IN NUMBER,
640: p_start_date_active IN DATE,
641: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
642: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
643: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
644: x_section_item_id OUT NUMBER,
645: x_return_status OUT VARCHAR2,
646: x_msg_count OUT NUMBER,
647: x_msg_data OUT VARCHAR2

Line 665: IF NOT FND_API.Compatible_API_Call(l_api_version,

661: -- Standard Start of API savepoint
662: SAVEPOINT CREATE_SECTION_ITEM_PVT;
663:
664: -- Standard call to check for call compatibility.
665: IF NOT FND_API.Compatible_API_Call(l_api_version,
666: p_api_version,
667: l_api_name,
668: G_PKG_NAME)
669: THEN

Line 670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

666: p_api_version,
667: l_api_name,
668: G_PKG_NAME)
669: THEN
670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
671: END IF;
672:
673: -- Initialize message list if p_init_msg_list is set to TRUE.
674: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 674: IF FND_API.to_Boolean(p_init_msg_list) THEN

670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
671: END IF;
672:
673: -- Initialize message list if p_init_msg_list is set to TRUE.
674: IF FND_API.to_Boolean(p_init_msg_list) THEN
675: FND_MSG_PUB.initialize;
676: END IF;
677:
678: -- Initialize API return status to success

Line 679: x_return_status := FND_API.G_RET_STS_SUCCESS;

675: FND_MSG_PUB.initialize;
676: END IF;
677:
678: -- Initialize API return status to success
679: x_return_status := FND_API.G_RET_STS_SUCCESS;
680:
681: -- API body
682: -- CALL FLOW :
683: -- 1. Validate

Line 692: p_init_msg_list => FND_API.G_FALSE,

688: -- 1. Validate
689: --
690: Validate_Create
691: (
692: p_init_msg_list => FND_API.G_FALSE,
693: p_validation_level => p_validation_level,
694: p_section_id => p_section_id,
695: p_inventory_item_id => p_inventory_item_id,
696: p_organization_id => p_organization_id,

Line 706: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

702: x_msg_count => l_msg_count,
703: x_msg_data => l_msg_data
704: );
705:
706: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
708: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
709: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INVALID_CREATE');
710: FND_MSG_PUB.Add;

Line 707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

703: x_msg_data => l_msg_data
704: );
705:
706: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
708: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
709: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INVALID_CREATE');
710: FND_MSG_PUB.Add;
711: RAISE FND_API.G_EXC_ERROR; -- invalid

Line 708: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

704: );
705:
706: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
708: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
709: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INVALID_CREATE');
710: FND_MSG_PUB.Add;
711: RAISE FND_API.G_EXC_ERROR; -- invalid
712: END IF;

Line 711: RAISE FND_API.G_EXC_ERROR; -- invalid

707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
708: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
709: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INVALID_CREATE');
710: FND_MSG_PUB.Add;
711: RAISE FND_API.G_EXC_ERROR; -- invalid
712: END IF;
713:
714: --
715: -- 2. Insert row

Line 720: FND_API.G_MISS_NUM,

716: --
717: BEGIN
718: insert_row
719: (
720: FND_API.G_MISS_NUM,
721: l_object_version_number,
722: p_section_id,
723: p_inventory_item_id,
724: p_organization_id,

Line 741: RAISE FND_API.G_EXC_ERROR;

737: EXCEPTION
738: WHEN NO_DATA_FOUND THEN
739: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INSERT_FAIL');
740: FND_MSG_PUB.Add;
741: RAISE FND_API.G_EXC_ERROR;
742: WHEN OTHERS THEN
743: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INSERT_FAIL');
744: FND_MSG_PUB.Add;
745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

741: RAISE FND_API.G_EXC_ERROR;
742: WHEN OTHERS THEN
743: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INSERT_FAIL');
744: FND_MSG_PUB.Add;
745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
746: END;
747:
748: --
749: -- Call api which makes changes in relationship tables

Line 761: IF (FND_API.To_Boolean(p_commit)) THEN

757: --
758: -- End of main API body.
759:
760: -- Standard check of p_commit.
761: IF (FND_API.To_Boolean(p_commit)) THEN
762: COMMIT WORK;
763: END IF;
764:
765: -- Standard call to get message count and if count is 1, get message info.

Line 772: WHEN FND_API.G_EXC_ERROR THEN

768: p_encoded => 'F');
769:
770: EXCEPTION
771:
772: WHEN FND_API.G_EXC_ERROR THEN
773: ROLLBACK TO CREATE_SECTION_ITEM_PVT;
774: x_return_status := FND_API.G_RET_STS_ERROR;
775: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
776: p_data => x_msg_data,

Line 774: x_return_status := FND_API.G_RET_STS_ERROR;

770: EXCEPTION
771:
772: WHEN FND_API.G_EXC_ERROR THEN
773: ROLLBACK TO CREATE_SECTION_ITEM_PVT;
774: x_return_status := FND_API.G_RET_STS_ERROR;
775: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
776: p_data => x_msg_data,
777: p_encoded => 'F');
778:

Line 779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

775: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
776: p_data => x_msg_data,
777: p_encoded => 'F');
778:
779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
780: ROLLBACK TO CREATE_SECTION_ITEM_PVT;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
783: p_data => x_msg_data,

Line 781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

777: p_encoded => 'F');
778:
779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
780: ROLLBACK TO CREATE_SECTION_ITEM_PVT;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
783: p_data => x_msg_data,
784: p_encoded => 'F');
785:

Line 788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

784: p_encoded => 'F');
785:
786: WHEN OTHERS THEN
787: ROLLBACK TO CREATE_SECTION_ITEM_PVT;
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
789:
790: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
791: THEN
792: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 804: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

800:
801: PROCEDURE Update_Section_Item
802: (
803: p_api_version IN NUMBER,
804: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
805: p_commit IN VARCHAR2 := FND_API.G_FALSE,
806: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
807: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
808: p_object_version_number IN NUMBER,

Line 805: p_commit IN VARCHAR2 := FND_API.G_FALSE,

801: PROCEDURE Update_Section_Item
802: (
803: p_api_version IN NUMBER,
804: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
805: p_commit IN VARCHAR2 := FND_API.G_FALSE,
806: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
807: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
808: p_object_version_number IN NUMBER,
809: p_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

802: (
803: p_api_version IN NUMBER,
804: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
805: p_commit IN VARCHAR2 := FND_API.G_FALSE,
806: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
807: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
808: p_object_version_number IN NUMBER,
809: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
810: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,

Line 807: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,

803: p_api_version IN NUMBER,
804: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
805: p_commit IN VARCHAR2 := FND_API.G_FALSE,
806: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
807: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
808: p_object_version_number IN NUMBER,
809: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
810: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
811: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,

Line 809: p_section_id IN NUMBER := FND_API.G_MISS_NUM,

805: p_commit IN VARCHAR2 := FND_API.G_FALSE,
806: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
807: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
808: p_object_version_number IN NUMBER,
809: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
810: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
811: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
812: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
813: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

Line 810: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,

806: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
807: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
808: p_object_version_number IN NUMBER,
809: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
810: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
811: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
812: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
813: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
814: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,

Line 811: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,

807: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
808: p_object_version_number IN NUMBER,
809: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
810: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
811: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
812: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
813: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
814: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
815: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 812: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

808: p_object_version_number IN NUMBER,
809: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
810: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
811: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
812: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
813: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
814: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
815: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
816: x_return_status OUT VARCHAR2,

Line 813: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

809: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
810: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
811: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
812: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
813: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
814: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
815: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
816: x_return_status OUT VARCHAR2,
817: x_msg_count OUT NUMBER,

Line 814: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,

810: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
811: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
812: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
813: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
814: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
815: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
816: x_return_status OUT VARCHAR2,
817: x_msg_count OUT NUMBER,
818: x_msg_data OUT VARCHAR2

Line 815: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

811: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
812: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
813: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
814: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
815: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
816: x_return_status OUT VARCHAR2,
817: x_msg_count OUT NUMBER,
818: x_msg_data OUT VARCHAR2
819: )

Line 835: IF NOT FND_API.Compatible_API_Call(l_api_version,

831: -- Standard Start of API savepoint
832: SAVEPOINT UPDATE_SECTION_ITEM_PVT;
833:
834: -- Standard call to check for call compatibility.
835: IF NOT FND_API.Compatible_API_Call(l_api_version,
836: p_api_version,
837: l_api_name,
838: G_PKG_NAME)
839: THEN

Line 840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

836: p_api_version,
837: l_api_name,
838: G_PKG_NAME)
839: THEN
840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
841: END IF;
842:
843: -- Initialize message list if p_init_msg_list is set to TRUE.
844: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 844: IF FND_API.to_Boolean(p_init_msg_list) THEN

840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
841: END IF;
842:
843: -- Initialize message list if p_init_msg_list is set to TRUE.
844: IF FND_API.to_Boolean(p_init_msg_list) THEN
845: FND_MSG_PUB.initialize;
846: END IF;
847:
848: -- Initialize API return status to success

Line 849: x_return_status := FND_API.G_RET_STS_SUCCESS;

845: FND_MSG_PUB.initialize;
846: END IF;
847:
848: -- Initialize API return status to success
849: x_return_status := FND_API.G_RET_STS_SUCCESS;
850:
851: -- API body
852: -- CALL FLOW :
853: -- 1. Check if either section_item_id or combination of

Line 861: (p_section_item_id <> FND_API.G_MISS_NUM))

857:
858: -- 1. Check if either section_item_id or combination of
859: -- section_id, inventory_item_id and organization_id is specified
860: IF ((p_section_item_id IS NOT NULL) AND
861: (p_section_item_id <> FND_API.G_MISS_NUM))
862: THEN
863: -- section_item_id specified, continue
864: l_section_item_id := p_section_item_id;
865: ELSIF ((p_section_id IS NOT NULL) AND

Line 866: (p_section_id <> FND_API.G_MISS_NUM) AND

862: THEN
863: -- section_item_id specified, continue
864: l_section_item_id := p_section_item_id;
865: ELSIF ((p_section_id IS NOT NULL) AND
866: (p_section_id <> FND_API.G_MISS_NUM) AND
867: (p_inventory_item_id IS NOT NULL) AND
868: (p_inventory_item_id <> FND_API.G_MISS_NUM) AND
869: (p_organization_id IS NOT NULL) AND
870: (p_organization_id <> FND_API.G_MISS_NUM))

Line 868: (p_inventory_item_id <> FND_API.G_MISS_NUM) AND

864: l_section_item_id := p_section_item_id;
865: ELSIF ((p_section_id IS NOT NULL) AND
866: (p_section_id <> FND_API.G_MISS_NUM) AND
867: (p_inventory_item_id IS NOT NULL) AND
868: (p_inventory_item_id <> FND_API.G_MISS_NUM) AND
869: (p_organization_id IS NOT NULL) AND
870: (p_organization_id <> FND_API.G_MISS_NUM))
871: THEN
872: -- If combination of section_id, inventory_item_id and organization_id

Line 870: (p_organization_id <> FND_API.G_MISS_NUM))

866: (p_section_id <> FND_API.G_MISS_NUM) AND
867: (p_inventory_item_id IS NOT NULL) AND
868: (p_inventory_item_id <> FND_API.G_MISS_NUM) AND
869: (p_organization_id IS NOT NULL) AND
870: (p_organization_id <> FND_API.G_MISS_NUM))
871: THEN
872: -- If combination of section_id, inventory_item_id and organization_id
873: -- is specified, then query for section_item_id
874: BEGIN

Line 889: RAISE FND_API.G_EXC_ERROR;

885: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
886: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
887: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
888: FND_MSG_PUB.Add;
889: RAISE FND_API.G_EXC_ERROR;
890: WHEN OTHERS THEN
891: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');
892: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
893: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);

Line 896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

892: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
893: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
894: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
895: FND_MSG_PUB.Add;
896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
897: END;
898:
899: ELSE
900: -- neither section_item_id nor combination of

Line 904: RAISE FND_API.G_EXC_ERROR;

900: -- neither section_item_id nor combination of
901: -- section_id, inventory_item_id and organization_id is specified
902: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_IDS_SPEC');
903: FND_MSG_PUB.Add;
904: RAISE FND_API.G_EXC_ERROR;
905: END IF;
906:
907: --
908: -- 1. Validate the input data

Line 912: p_init_msg_list => FND_API.G_FALSE,

908: -- 1. Validate the input data
909: --
910: Validate_Update
911: (
912: p_init_msg_list => FND_API.G_FALSE,
913: p_validation_level => p_validation_level,
914: p_section_item_id => l_section_item_id,
915: p_object_version_number => p_object_version_number,
916: p_start_date_active => p_start_date_active,

Line 925: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

921: x_msg_count => l_msg_count,
922: x_msg_data => l_msg_data
923: );
924:
925: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
928: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INVALID_UPDATE');
929: FND_MSG_PUB.Add;

Line 926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

922: x_msg_data => l_msg_data
923: );
924:
925: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
928: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INVALID_UPDATE');
929: FND_MSG_PUB.Add;
930: RAISE FND_API.G_EXC_ERROR; -- invalid

Line 927: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

923: );
924:
925: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
928: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INVALID_UPDATE');
929: FND_MSG_PUB.Add;
930: RAISE FND_API.G_EXC_ERROR; -- invalid
931: END IF;

Line 930: RAISE FND_API.G_EXC_ERROR; -- invalid

926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
928: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_INVALID_UPDATE');
929: FND_MSG_PUB.Add;
930: RAISE FND_API.G_EXC_ERROR; -- invalid
931: END IF;
932:
933: -- 2. update row
934: BEGIN

Line 951: RAISE FND_API.G_EXC_ERROR;

947: EXCEPTION
948: WHEN NO_DATA_FOUND THEN
949: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_UPDATE_FAIL');
950: FND_MSG_PUB.Add;
951: RAISE FND_API.G_EXC_ERROR;
952: WHEN OTHERS THEN
953: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_UPDATE_FAIL');
954: FND_MSG_PUB.Add;
955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

951: RAISE FND_API.G_EXC_ERROR;
952: WHEN OTHERS THEN
953: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SI_UPDATE_FAIL');
954: FND_MSG_PUB.Add;
955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
956: END;
957:
958: --
959: -- End of main API body.

Line 962: IF (FND_API.To_Boolean(p_commit)) THEN

958: --
959: -- End of main API body.
960:
961: -- Standard check of p_commit.
962: IF (FND_API.To_Boolean(p_commit)) THEN
963: COMMIT WORK;
964: END IF;
965:
966: -- Standard call to get message count and if count is 1, get message info.

Line 973: WHEN FND_API.G_EXC_ERROR THEN

969: p_encoded => 'F');
970:
971: EXCEPTION
972:
973: WHEN FND_API.G_EXC_ERROR THEN
974: ROLLBACK TO UPDATE_SECTION_ITEM_PVT;
975: x_return_status := FND_API.G_RET_STS_ERROR;
976: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
977: p_data => x_msg_data,

Line 975: x_return_status := FND_API.G_RET_STS_ERROR;

971: EXCEPTION
972:
973: WHEN FND_API.G_EXC_ERROR THEN
974: ROLLBACK TO UPDATE_SECTION_ITEM_PVT;
975: x_return_status := FND_API.G_RET_STS_ERROR;
976: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
977: p_data => x_msg_data,
978: p_encoded => 'F');
979:

Line 980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

976: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
977: p_data => x_msg_data,
978: p_encoded => 'F');
979:
980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
981: ROLLBACK TO UPDATE_SECTION_ITEM_PVT;
982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
983: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
984: p_data => x_msg_data,

Line 982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

978: p_encoded => 'F');
979:
980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
981: ROLLBACK TO UPDATE_SECTION_ITEM_PVT;
982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
983: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
984: p_data => x_msg_data,
985: p_encoded => 'F');
986:

Line 989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

985: p_encoded => 'F');
986:
987: WHEN OTHERS THEN
988: ROLLBACK TO UPDATE_SECTION_ITEM_PVT;
989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
990:
991: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
992: THEN
993: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 1005: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1001:
1002: PROCEDURE Delete_Section_Item
1003: (
1004: p_api_version IN NUMBER,
1005: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1006: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1007: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1008: p_call_from_trigger IN BOOLEAN := FALSE,
1009: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1006: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1002: PROCEDURE Delete_Section_Item
1003: (
1004: p_api_version IN NUMBER,
1005: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1006: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1007: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1008: p_call_from_trigger IN BOOLEAN := FALSE,
1009: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
1010: p_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

1003: (
1004: p_api_version IN NUMBER,
1005: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1006: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1007: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1008: p_call_from_trigger IN BOOLEAN := FALSE,
1009: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
1010: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1011: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1009: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,

1005: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1006: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1007: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1008: p_call_from_trigger IN BOOLEAN := FALSE,
1009: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
1010: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1011: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
1012: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
1013: x_return_status OUT VARCHAR2,

Line 1010: p_section_id IN NUMBER := FND_API.G_MISS_NUM,

1006: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1007: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1008: p_call_from_trigger IN BOOLEAN := FALSE,
1009: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
1010: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1011: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
1012: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
1013: x_return_status OUT VARCHAR2,
1014: x_msg_count OUT NUMBER,

Line 1011: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,

1007: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1008: p_call_from_trigger IN BOOLEAN := FALSE,
1009: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
1010: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1011: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
1012: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
1013: x_return_status OUT VARCHAR2,
1014: x_msg_count OUT NUMBER,
1015: x_msg_data OUT VARCHAR2

Line 1012: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,

1008: p_call_from_trigger IN BOOLEAN := FALSE,
1009: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
1010: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1011: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
1012: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
1013: x_return_status OUT VARCHAR2,
1014: x_msg_count OUT NUMBER,
1015: x_msg_data OUT VARCHAR2
1016: )

Line 1044: IF NOT FND_API.Compatible_API_Call(l_api_version,

1040: SAVEPOINT DELETE_SECTION_ITEM_PVT;
1041: END IF;
1042:
1043: -- Standard call to check for call compatibility.
1044: IF NOT FND_API.Compatible_API_Call(l_api_version,
1045: p_api_version,
1046: l_api_name,
1047: G_PKG_NAME)
1048: THEN

Line 1049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1045: p_api_version,
1046: l_api_name,
1047: G_PKG_NAME)
1048: THEN
1049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1050: END IF;
1051:
1052: -- Initialize message list if p_init_msg_list is set to TRUE.
1053: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1053: IF FND_API.to_Boolean(p_init_msg_list) THEN

1049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1050: END IF;
1051:
1052: -- Initialize message list if p_init_msg_list is set to TRUE.
1053: IF FND_API.to_Boolean(p_init_msg_list) THEN
1054: FND_MSG_PUB.initialize;
1055: END IF;
1056:
1057: -- Initialize API return status to success

Line 1058: x_return_status := FND_API.G_RET_STS_SUCCESS;

1054: FND_MSG_PUB.initialize;
1055: END IF;
1056:
1057: -- Initialize API return status to success
1058: x_return_status := FND_API.G_RET_STS_SUCCESS;
1059:
1060: -- CALL FLOW
1061: -- 1. If section_item_id specified, delete all references for it
1062: -- 2. If combination of section_id, inventory_item_id and organization_id

Line 1068: (p_section_item_id <> FND_API.G_MISS_NUM))

1064: -- all references
1065:
1066: -- 1. If section_item_id specified, delete all references for it
1067: IF ((p_section_item_id IS NOT NULL) AND
1068: (p_section_item_id <> FND_API.G_MISS_NUM))
1069: THEN
1070: -- section_item_id specified, continue
1071: l_section_item_id := p_section_item_id;
1072:

Line 1080: RAISE FND_API.G_EXC_ERROR;

1076: CLOSE c2;
1077: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SI_ID');
1078: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', l_section_item_id);
1079: FND_MSG_PUB.Add;
1080: RAISE FND_API.G_EXC_ERROR;
1081: END IF;
1082: CLOSE c2;
1083:
1084: ELSIF ((p_section_id IS NOT NULL) AND

Line 1085: (p_section_id <> FND_API.G_MISS_NUM) AND

1081: END IF;
1082: CLOSE c2;
1083:
1084: ELSIF ((p_section_id IS NOT NULL) AND
1085: (p_section_id <> FND_API.G_MISS_NUM) AND
1086: (p_inventory_item_id IS NOT NULL) AND
1087: (p_inventory_item_id <> FND_API.G_MISS_NUM) AND
1088: (p_organization_id IS NOT NULL) AND
1089: (p_organization_id <> FND_API.G_MISS_NUM))

Line 1087: (p_inventory_item_id <> FND_API.G_MISS_NUM) AND

1083:
1084: ELSIF ((p_section_id IS NOT NULL) AND
1085: (p_section_id <> FND_API.G_MISS_NUM) AND
1086: (p_inventory_item_id IS NOT NULL) AND
1087: (p_inventory_item_id <> FND_API.G_MISS_NUM) AND
1088: (p_organization_id IS NOT NULL) AND
1089: (p_organization_id <> FND_API.G_MISS_NUM))
1090: THEN
1091: -- If combination of section_id, inventory_item_id and organization_id

Line 1089: (p_organization_id <> FND_API.G_MISS_NUM))

1085: (p_section_id <> FND_API.G_MISS_NUM) AND
1086: (p_inventory_item_id IS NOT NULL) AND
1087: (p_inventory_item_id <> FND_API.G_MISS_NUM) AND
1088: (p_organization_id IS NOT NULL) AND
1089: (p_organization_id <> FND_API.G_MISS_NUM))
1090: THEN
1091: -- If combination of section_id, inventory_item_id and organization_id
1092: -- is specified, then query for section_item_id
1093: l_section_id := p_section_id;

Line 1112: RAISE FND_API.G_EXC_ERROR;

1108: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
1109: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1110: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1111: FND_MSG_PUB.Add;
1112: RAISE FND_API.G_EXC_ERROR;
1113: WHEN OTHERS THEN
1114: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_ID');
1115: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
1116: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);

Line 1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1115: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
1116: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1117: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1118: FND_MSG_PUB.Add;
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: END;
1121:
1122: ELSE
1123: -- neither section_item_id nor combination of

Line 1127: RAISE FND_API.G_EXC_ERROR;

1123: -- neither section_item_id nor combination of
1124: -- section_id, inventory_item_id and organization_id is specified
1125: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_SI_IDS_SPEC');
1126: FND_MSG_PUB.Add;
1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;
1129:
1130: -- delete from jtf_dsp_msite_sct_items table
1131: FOR r1 IN c1(l_section_item_id) LOOP

Line 1136: p_init_msg_list => FND_API.G_FALSE,

1132:
1133: JTF_DSP_MSITE_SCT_ITEM_PVT.Delete_MSite_Section_Item
1134: (
1135: p_api_version => p_api_version,
1136: p_init_msg_list => FND_API.G_FALSE,
1137: p_commit => FND_API.G_FALSE,
1138: p_validation_level => p_validation_level,
1139: p_call_from_trigger => p_call_from_trigger,
1140: p_mini_site_section_item_id => r1.mini_site_section_item_id,

Line 1137: p_commit => FND_API.G_FALSE,

1133: JTF_DSP_MSITE_SCT_ITEM_PVT.Delete_MSite_Section_Item
1134: (
1135: p_api_version => p_api_version,
1136: p_init_msg_list => FND_API.G_FALSE,
1137: p_commit => FND_API.G_FALSE,
1138: p_validation_level => p_validation_level,
1139: p_call_from_trigger => p_call_from_trigger,
1140: p_mini_site_section_item_id => r1.mini_site_section_item_id,
1141: p_mini_site_id => FND_API.G_MISS_NUM,

Line 1141: p_mini_site_id => FND_API.G_MISS_NUM,

1137: p_commit => FND_API.G_FALSE,
1138: p_validation_level => p_validation_level,
1139: p_call_from_trigger => p_call_from_trigger,
1140: p_mini_site_section_item_id => r1.mini_site_section_item_id,
1141: p_mini_site_id => FND_API.G_MISS_NUM,
1142: p_section_item_id => FND_API.G_MISS_NUM,
1143: x_return_status => x_return_status,
1144: x_msg_count => x_msg_count,
1145: x_msg_data => x_msg_data

Line 1142: p_section_item_id => FND_API.G_MISS_NUM,

1138: p_validation_level => p_validation_level,
1139: p_call_from_trigger => p_call_from_trigger,
1140: p_mini_site_section_item_id => r1.mini_site_section_item_id,
1141: p_mini_site_id => FND_API.G_MISS_NUM,
1142: p_section_item_id => FND_API.G_MISS_NUM,
1143: x_return_status => x_return_status,
1144: x_msg_count => x_msg_count,
1145: x_msg_data => x_msg_data
1146: );

Line 1148: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1144: x_msg_count => x_msg_count,
1145: x_msg_data => x_msg_data
1146: );
1147:
1148: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1149: RAISE FND_API.G_EXC_ERROR;
1150: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: END IF;

Line 1149: RAISE FND_API.G_EXC_ERROR;

1145: x_msg_data => x_msg_data
1146: );
1147:
1148: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1149: RAISE FND_API.G_EXC_ERROR;
1150: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: END IF;
1153:

Line 1150: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1146: );
1147:
1148: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1149: RAISE FND_API.G_EXC_ERROR;
1150: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: END IF;
1153:
1154: END LOOP;

Line 1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1147:
1148: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1149: RAISE FND_API.G_EXC_ERROR;
1150: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: END IF;
1153:
1154: END LOOP;
1155:

Line 1168: WHEN FND_API.G_EXC_ERROR THEN

1164: delete_row(l_section_item_id);
1165:
1166: EXCEPTION
1167:
1168: WHEN FND_API.G_EXC_ERROR THEN
1169: IF (p_call_from_trigger = FALSE) THEN
1170: ROLLBACK TO DELETE_SECTION_ITEM_PVT;
1171: END IF;
1172: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1172: x_return_status := FND_API.G_RET_STS_ERROR;

1168: WHEN FND_API.G_EXC_ERROR THEN
1169: IF (p_call_from_trigger = FALSE) THEN
1170: ROLLBACK TO DELETE_SECTION_ITEM_PVT;
1171: END IF;
1172: x_return_status := FND_API.G_RET_STS_ERROR;
1173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1174: p_data => x_msg_data,
1175: p_encoded => 'F');
1176:

Line 1177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1174: p_data => x_msg_data,
1175: p_encoded => 'F');
1176:
1177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1178: IF (p_call_from_trigger = FALSE) THEN
1179: ROLLBACK TO DELETE_SECTION_ITEM_PVT;
1180: END IF;
1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1178: IF (p_call_from_trigger = FALSE) THEN
1179: ROLLBACK TO DELETE_SECTION_ITEM_PVT;
1180: END IF;
1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1182: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1183: p_data => x_msg_data,
1184: p_encoded => 'F');
1185:

Line 1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1187: IF (p_call_from_trigger = FALSE) THEN
1188: ROLLBACK TO DELETE_SECTION_ITEM_PVT;
1189: END IF;
1190:
1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1192:
1193: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1194: THEN
1195: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

Line 1209: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,

1205: -- delete section items for input of inventory item id and organization id
1206: --
1207: PROCEDURE Delete_Section_Items_For_Item
1208: (
1209: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
1210: p_organization_id IN NUMBER := FND_API.G_MISS_NUM
1211: )
1212: IS
1213: l_api_name CONSTANT VARCHAR2(30) :='Delete_Section_Items_For_Item';

Line 1210: p_organization_id IN NUMBER := FND_API.G_MISS_NUM

1206: --
1207: PROCEDURE Delete_Section_Items_For_Item
1208: (
1209: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
1210: p_organization_id IN NUMBER := FND_API.G_MISS_NUM
1211: )
1212: IS
1213: l_api_name CONSTANT VARCHAR2(30) :='Delete_Section_Items_For_Item';
1214: l_api_version CONSTANT NUMBER := 1.0;

Line 1231: p_init_msg_list => FND_API.G_FALSE,

1227:
1228: Delete_Section_Item
1229: (
1230: p_api_version => l_api_version,
1231: p_init_msg_list => FND_API.G_FALSE,
1232: p_commit => FND_API.G_FALSE,
1233: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1234: p_call_from_trigger => TRUE,
1235: p_section_item_id => r1.section_item_id,

Line 1232: p_commit => FND_API.G_FALSE,

1228: Delete_Section_Item
1229: (
1230: p_api_version => l_api_version,
1231: p_init_msg_list => FND_API.G_FALSE,
1232: p_commit => FND_API.G_FALSE,
1233: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1234: p_call_from_trigger => TRUE,
1235: p_section_item_id => r1.section_item_id,
1236: p_section_id => FND_API.G_MISS_NUM,

Line 1233: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1229: (
1230: p_api_version => l_api_version,
1231: p_init_msg_list => FND_API.G_FALSE,
1232: p_commit => FND_API.G_FALSE,
1233: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1234: p_call_from_trigger => TRUE,
1235: p_section_item_id => r1.section_item_id,
1236: p_section_id => FND_API.G_MISS_NUM,
1237: p_inventory_item_id => FND_API.G_MISS_NUM,

Line 1236: p_section_id => FND_API.G_MISS_NUM,

1232: p_commit => FND_API.G_FALSE,
1233: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1234: p_call_from_trigger => TRUE,
1235: p_section_item_id => r1.section_item_id,
1236: p_section_id => FND_API.G_MISS_NUM,
1237: p_inventory_item_id => FND_API.G_MISS_NUM,
1238: p_organization_id => FND_API.G_MISS_NUM,
1239: x_return_status => l_return_status,
1240: x_msg_count => l_msg_count,

Line 1237: p_inventory_item_id => FND_API.G_MISS_NUM,

1233: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1234: p_call_from_trigger => TRUE,
1235: p_section_item_id => r1.section_item_id,
1236: p_section_id => FND_API.G_MISS_NUM,
1237: p_inventory_item_id => FND_API.G_MISS_NUM,
1238: p_organization_id => FND_API.G_MISS_NUM,
1239: x_return_status => l_return_status,
1240: x_msg_count => l_msg_count,
1241: x_msg_data => l_msg_data

Line 1238: p_organization_id => FND_API.G_MISS_NUM,

1234: p_call_from_trigger => TRUE,
1235: p_section_item_id => r1.section_item_id,
1236: p_section_id => FND_API.G_MISS_NUM,
1237: p_inventory_item_id => FND_API.G_MISS_NUM,
1238: p_organization_id => FND_API.G_MISS_NUM,
1239: x_return_status => l_return_status,
1240: x_msg_count => l_msg_count,
1241: x_msg_data => l_msg_data
1242: );

Line 1255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1251: --
1252: PROCEDURE Update_Delete_Sct_Itms
1253: (
1254: p_api_version IN NUMBER,
1255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1256: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1258: p_section_item_ids IN JTF_NUMBER_TABLE,
1259: p_object_version_numbers IN JTF_NUMBER_TABLE,

Line 1256: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1252: PROCEDURE Update_Delete_Sct_Itms
1253: (
1254: p_api_version IN NUMBER,
1255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1256: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1258: p_section_item_ids IN JTF_NUMBER_TABLE,
1259: p_object_version_numbers IN JTF_NUMBER_TABLE,
1260: p_start_date_actives IN JTF_DATE_TABLE,

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

1253: (
1254: p_api_version IN NUMBER,
1255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1256: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1258: p_section_item_ids IN JTF_NUMBER_TABLE,
1259: p_object_version_numbers IN JTF_NUMBER_TABLE,
1260: p_start_date_actives IN JTF_DATE_TABLE,
1261: p_end_date_actives IN JTF_DATE_TABLE,

Line 1284: IF NOT FND_API.Compatible_API_Call(l_api_version,

1280: -- Standard Start of API savepoint
1281: SAVEPOINT UPDATE_DELETE_SCT_ITMS_PVT;
1282:
1283: -- Standard call to check for call compatibility.
1284: IF NOT FND_API.Compatible_API_Call(l_api_version,
1285: p_api_version,
1286: l_api_name,
1287: G_PKG_NAME)
1288: THEN

Line 1289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1285: p_api_version,
1286: l_api_name,
1287: G_PKG_NAME)
1288: THEN
1289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1290: END IF;
1291:
1292: -- Initialize message list if p_init_msg_list is set to TRUE.
1293: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1293: IF FND_API.to_Boolean(p_init_msg_list) THEN

1289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1290: END IF;
1291:
1292: -- Initialize message list if p_init_msg_list is set to TRUE.
1293: IF FND_API.to_Boolean(p_init_msg_list) THEN
1294: FND_MSG_PUB.initialize;
1295: END IF;
1296:
1297: -- Initialize API return status to success

Line 1298: x_return_status := FND_API.G_RET_STS_SUCCESS;

1294: FND_MSG_PUB.initialize;
1295: END IF;
1296:
1297: -- Initialize API return status to success
1298: x_return_status := FND_API.G_RET_STS_SUCCESS;
1299:
1300: -- API body
1301: -- CALL FLOW :
1302: -- 1.

Line 1311: p_init_msg_list => FND_API.G_FALSE,

1307:
1308: Delete_Section_Item
1309: (
1310: p_api_version => p_api_version,
1311: p_init_msg_list => FND_API.G_FALSE,
1312: p_commit => FND_API.G_FALSE,
1313: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1314: p_section_item_id => p_section_item_ids(i),
1315: p_section_id => FND_API.G_MISS_NUM,

Line 1312: p_commit => FND_API.G_FALSE,

1308: Delete_Section_Item
1309: (
1310: p_api_version => p_api_version,
1311: p_init_msg_list => FND_API.G_FALSE,
1312: p_commit => FND_API.G_FALSE,
1313: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1314: p_section_item_id => p_section_item_ids(i),
1315: p_section_id => FND_API.G_MISS_NUM,
1316: p_inventory_item_id => FND_API.G_MISS_NUM,

Line 1313: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1309: (
1310: p_api_version => p_api_version,
1311: p_init_msg_list => FND_API.G_FALSE,
1312: p_commit => FND_API.G_FALSE,
1313: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1314: p_section_item_id => p_section_item_ids(i),
1315: p_section_id => FND_API.G_MISS_NUM,
1316: p_inventory_item_id => FND_API.G_MISS_NUM,
1317: p_organization_id => FND_API.G_MISS_NUM,

Line 1315: p_section_id => FND_API.G_MISS_NUM,

1311: p_init_msg_list => FND_API.G_FALSE,
1312: p_commit => FND_API.G_FALSE,
1313: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1314: p_section_item_id => p_section_item_ids(i),
1315: p_section_id => FND_API.G_MISS_NUM,
1316: p_inventory_item_id => FND_API.G_MISS_NUM,
1317: p_organization_id => FND_API.G_MISS_NUM,
1318: x_return_status => x_return_status,
1319: x_msg_count => x_msg_count,

Line 1316: p_inventory_item_id => FND_API.G_MISS_NUM,

1312: p_commit => FND_API.G_FALSE,
1313: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1314: p_section_item_id => p_section_item_ids(i),
1315: p_section_id => FND_API.G_MISS_NUM,
1316: p_inventory_item_id => FND_API.G_MISS_NUM,
1317: p_organization_id => FND_API.G_MISS_NUM,
1318: x_return_status => x_return_status,
1319: x_msg_count => x_msg_count,
1320: x_msg_data => x_msg_data

Line 1317: p_organization_id => FND_API.G_MISS_NUM,

1313: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1314: p_section_item_id => p_section_item_ids(i),
1315: p_section_id => FND_API.G_MISS_NUM,
1316: p_inventory_item_id => FND_API.G_MISS_NUM,
1317: p_organization_id => FND_API.G_MISS_NUM,
1318: x_return_status => x_return_status,
1319: x_msg_count => x_msg_count,
1320: x_msg_data => x_msg_data
1321: );

Line 1323: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1319: x_msg_count => x_msg_count,
1320: x_msg_data => x_msg_data
1321: );
1322:
1323: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1324: RAISE FND_API.G_EXC_ERROR;
1325: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327: END IF;

Line 1324: RAISE FND_API.G_EXC_ERROR;

1320: x_msg_data => x_msg_data
1321: );
1322:
1323: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1324: RAISE FND_API.G_EXC_ERROR;
1325: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327: END IF;
1328:

Line 1325: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1321: );
1322:
1323: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1324: RAISE FND_API.G_EXC_ERROR;
1325: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327: END IF;
1328:
1329: ELSE

Line 1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1322:
1323: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1324: RAISE FND_API.G_EXC_ERROR;
1325: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327: END IF;
1328:
1329: ELSE
1330:

Line 1334: p_init_msg_list => FND_API.G_FALSE,

1330:
1331: Update_Section_Item
1332: (
1333: p_api_version => p_api_version,
1334: p_init_msg_list => FND_API.G_FALSE,
1335: p_commit => FND_API.G_FALSE,
1336: p_validation_level => p_validation_level,
1337: p_section_item_id => p_section_item_ids(i),
1338: p_object_version_number => p_object_version_numbers(i),

Line 1335: p_commit => FND_API.G_FALSE,

1331: Update_Section_Item
1332: (
1333: p_api_version => p_api_version,
1334: p_init_msg_list => FND_API.G_FALSE,
1335: p_commit => FND_API.G_FALSE,
1336: p_validation_level => p_validation_level,
1337: p_section_item_id => p_section_item_ids(i),
1338: p_object_version_number => p_object_version_numbers(i),
1339: p_section_id => FND_API.G_MISS_NUM,

Line 1339: p_section_id => FND_API.G_MISS_NUM,

1335: p_commit => FND_API.G_FALSE,
1336: p_validation_level => p_validation_level,
1337: p_section_item_id => p_section_item_ids(i),
1338: p_object_version_number => p_object_version_numbers(i),
1339: p_section_id => FND_API.G_MISS_NUM,
1340: p_inventory_item_id => FND_API.G_MISS_NUM,
1341: p_organization_id => FND_API.G_MISS_NUM,
1342: p_start_date_active => p_start_date_actives(i),
1343: p_end_date_active => p_end_date_actives(i),

Line 1340: p_inventory_item_id => FND_API.G_MISS_NUM,

1336: p_validation_level => p_validation_level,
1337: p_section_item_id => p_section_item_ids(i),
1338: p_object_version_number => p_object_version_numbers(i),
1339: p_section_id => FND_API.G_MISS_NUM,
1340: p_inventory_item_id => FND_API.G_MISS_NUM,
1341: p_organization_id => FND_API.G_MISS_NUM,
1342: p_start_date_active => p_start_date_actives(i),
1343: p_end_date_active => p_end_date_actives(i),
1344: p_sort_order => p_sort_orders(i),

Line 1341: p_organization_id => FND_API.G_MISS_NUM,

1337: p_section_item_id => p_section_item_ids(i),
1338: p_object_version_number => p_object_version_numbers(i),
1339: p_section_id => FND_API.G_MISS_NUM,
1340: p_inventory_item_id => FND_API.G_MISS_NUM,
1341: p_organization_id => FND_API.G_MISS_NUM,
1342: p_start_date_active => p_start_date_actives(i),
1343: p_end_date_active => p_end_date_actives(i),
1344: p_sort_order => p_sort_orders(i),
1345: p_association_reason_code => p_association_reason_codes(i),

Line 1351: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1347: x_msg_count => x_msg_count,
1348: x_msg_data => x_msg_data
1349: );
1350:
1351: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1352: RAISE FND_API.G_EXC_ERROR;
1353: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1355: END IF;

Line 1352: RAISE FND_API.G_EXC_ERROR;

1348: x_msg_data => x_msg_data
1349: );
1350:
1351: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1352: RAISE FND_API.G_EXC_ERROR;
1353: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1355: END IF;
1356:

Line 1353: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1349: );
1350:
1351: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1352: RAISE FND_API.G_EXC_ERROR;
1353: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1355: END IF;
1356:
1357: END IF;

Line 1354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1350:
1351: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1352: RAISE FND_API.G_EXC_ERROR;
1353: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1355: END IF;
1356:
1357: END IF;
1358:

Line 1366: IF (FND_API.To_Boolean(p_commit)) THEN

1362: --
1363: -- End of main API body.
1364:
1365: -- Standard check of p_commit.
1366: IF (FND_API.To_Boolean(p_commit)) THEN
1367: COMMIT WORK;
1368: END IF;
1369:
1370: -- Standard call to get message count and if count is 1, get message info.

Line 1377: WHEN FND_API.G_EXC_ERROR THEN

1373: p_encoded => 'F');
1374:
1375: EXCEPTION
1376:
1377: WHEN FND_API.G_EXC_ERROR THEN
1378: ROLLBACK TO UPDATE_DELETE_SCT_ITMS_PVT;
1379: x_return_status := FND_API.G_RET_STS_ERROR;
1380: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1381: p_data => x_msg_data,

Line 1379: x_return_status := FND_API.G_RET_STS_ERROR;

1375: EXCEPTION
1376:
1377: WHEN FND_API.G_EXC_ERROR THEN
1378: ROLLBACK TO UPDATE_DELETE_SCT_ITMS_PVT;
1379: x_return_status := FND_API.G_RET_STS_ERROR;
1380: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1381: p_data => x_msg_data,
1382: p_encoded => 'F');
1383:

Line 1384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1380: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1381: p_data => x_msg_data,
1382: p_encoded => 'F');
1383:
1384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1385: ROLLBACK TO UPDATE_DELETE_SCT_ITMS_PVT;
1386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1387: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1388: p_data => x_msg_data,

Line 1386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1382: p_encoded => 'F');
1383:
1384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1385: ROLLBACK TO UPDATE_DELETE_SCT_ITMS_PVT;
1386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1387: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1388: p_data => x_msg_data,
1389: p_encoded => 'F');
1390:

Line 1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1389: p_encoded => 'F');
1390:
1391: WHEN OTHERS THEN
1392: ROLLBACK TO UPDATE_DELETE_SCT_ITMS_PVT;
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1394:
1395: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1396: THEN
1397: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);