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

Line 73: (x_section_item_id = FND_API.G_MISS_NUM))

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

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

103: p_section_id,
104: p_inventory_item_id,
105: p_organization_id,
106: p_start_date_active,
107: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
108: decode(p_usage_name, FND_API.G_MISS_CHAR, NULL, p_usage_name),
109: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
110: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
111: NULL, p_association_reason_code),

Line 108: decode(p_usage_name, FND_API.G_MISS_CHAR, NULL, p_usage_name),

104: p_inventory_item_id,
105: p_organization_id,
106: p_start_date_active,
107: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
108: decode(p_usage_name, FND_API.G_MISS_CHAR, NULL, p_usage_name),
109: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
110: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
111: NULL, p_association_reason_code),
112: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

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

105: p_organization_id,
106: p_start_date_active,
107: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
108: decode(p_usage_name, FND_API.G_MISS_CHAR, NULL, p_usage_name),
109: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
110: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
111: NULL, p_association_reason_code),
112: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
113: p_creation_date),

Line 110: decode(p_association_reason_code, FND_API.G_MISS_CHAR,

106: p_start_date_active,
107: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
108: decode(p_usage_name, FND_API.G_MISS_CHAR, NULL, p_usage_name),
109: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
110: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
111: NULL, p_association_reason_code),
112: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
113: p_creation_date),
114: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

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

108: decode(p_usage_name, FND_API.G_MISS_CHAR, NULL, p_usage_name),
109: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
110: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
111: NULL, p_association_reason_code),
112: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
113: p_creation_date),
114: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
115: NULL, FND_GLOBAL.user_id, p_created_by),
116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

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

110: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
111: NULL, p_association_reason_code),
112: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
113: p_creation_date),
114: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
115: NULL, FND_GLOBAL.user_id, p_created_by),
116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

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

112: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
113: p_creation_date),
114: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
115: NULL, FND_GLOBAL.user_id, p_created_by),
116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
119: NULL, FND_GLOBAL.user_id, p_last_updated_by),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

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

114: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
115: NULL, FND_GLOBAL.user_id, p_created_by),
116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
119: NULL, FND_GLOBAL.user_id, p_last_updated_by),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
121: NULL, FND_GLOBAL.login_id, p_last_update_login)
122: );

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

116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
119: NULL, FND_GLOBAL.user_id, p_last_updated_by),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
121: NULL, FND_GLOBAL.login_id, p_last_update_login)
122: );
123:
124: OPEN c;

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

138:
139: PROCEDURE update_row
140: (
141: p_section_item_id IN NUMBER,
142: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
143: p_start_date_active IN DATE,
144: p_end_date_active IN DATE,
145: p_usage_name IN VARCHAR2,
146: p_sort_order IN NUMBER,

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

154:
155: -- update base
156: UPDATE ibe_dsp_section_items SET
157: object_version_number = object_version_number + 1,
158: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
159: sort_order, p_sort_order),
160: association_reason_code =
161: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
162: association_reason_code, p_association_reason_code),

Line 161: decode(p_association_reason_code, FND_API.G_MISS_CHAR,

157: object_version_number = object_version_number + 1,
158: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
159: sort_order, p_sort_order),
160: association_reason_code =
161: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
162: association_reason_code, p_association_reason_code),
163: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
164: start_date_active, p_start_date_active),
165: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,

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

159: sort_order, p_sort_order),
160: association_reason_code =
161: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
162: association_reason_code, p_association_reason_code),
163: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
164: start_date_active, p_start_date_active),
165: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
166: end_date_active, p_end_date_active),
167: usage_name = decode(p_usage_name, FND_API.G_MISS_CHAR, usage_name, p_usage_name),

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

161: decode(p_association_reason_code, FND_API.G_MISS_CHAR,
162: association_reason_code, p_association_reason_code),
163: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
164: start_date_active, p_start_date_active),
165: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
166: end_date_active, p_end_date_active),
167: usage_name = decode(p_usage_name, FND_API.G_MISS_CHAR, usage_name, p_usage_name),
168: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
169: sysdate, NULL, sysdate, p_last_update_date),

Line 167: usage_name = decode(p_usage_name, FND_API.G_MISS_CHAR, usage_name, p_usage_name),

163: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
164: start_date_active, p_start_date_active),
165: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
166: end_date_active, p_end_date_active),
167: usage_name = decode(p_usage_name, FND_API.G_MISS_CHAR, usage_name, p_usage_name),
168: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
169: sysdate, NULL, sysdate, p_last_update_date),
170: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
171: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

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

164: start_date_active, p_start_date_active),
165: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
166: end_date_active, p_end_date_active),
167: usage_name = decode(p_usage_name, FND_API.G_MISS_CHAR, usage_name, p_usage_name),
168: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
169: sysdate, NULL, sysdate, p_last_update_date),
170: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
171: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
172: p_last_updated_by),

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

166: end_date_active, p_end_date_active),
167: usage_name = decode(p_usage_name, FND_API.G_MISS_CHAR, usage_name, p_usage_name),
168: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
169: sysdate, NULL, sysdate, p_last_update_date),
170: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
171: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
172: p_last_updated_by),
173: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
174: FND_GLOBAL.login_id, NULL,

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

169: sysdate, NULL, sysdate, p_last_update_date),
170: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
171: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
172: p_last_updated_by),
173: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
174: FND_GLOBAL.login_id, NULL,
175: FND_GLOBAL.login_id, p_last_update_login)
176: WHERE section_item_id = p_section_item_id
177: AND object_version_number = decode(p_object_version_number,

Line 178: FND_API.G_MISS_NUM,

174: FND_GLOBAL.login_id, NULL,
175: FND_GLOBAL.login_id, p_last_update_login)
176: WHERE section_item_id = p_section_item_id
177: AND object_version_number = decode(p_object_version_number,
178: FND_API.G_MISS_NUM,
179: object_version_number,
180: p_object_version_number);
181:
182: IF (sql%NOTFOUND) THEN

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

224: -- PROCEDURE Check_Duplicate_Entry()
225: --*****************************************************************************
226:
227: --
228: -- x_return_status = FND_API.G_RET_STS_SUCCESS, if the section is duplicate
229: -- x_return_status = FND_API.G_RET_STS_ERROR, if the section is not duplicate
230: --
231: --
232: PROCEDURE Check_Duplicate_Entry

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

225: --*****************************************************************************
226:
227: --
228: -- x_return_status = FND_API.G_RET_STS_SUCCESS, if the section is duplicate
229: -- x_return_status = FND_API.G_RET_STS_ERROR, if the section is not duplicate
230: --
231: --
232: PROCEDURE Check_Duplicate_Entry
233: (

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

230: --
231: --
232: PROCEDURE Check_Duplicate_Entry
233: (
234: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
235: p_section_id IN NUMBER,
236: p_inventory_item_id IN NUMBER,
237: p_organization_id IN NUMBER,
238: x_return_status OUT NOCOPY VARCHAR2,

Line 250: IF FND_API.to_Boolean(p_init_msg_list) THEN

246: l_tmp_section_item_id NUMBER;
247: BEGIN
248:
249: -- Initialize message list if p_init_msg_list is set to TRUE.
250: IF FND_API.to_Boolean(p_init_msg_list) THEN
251: FND_MSG_PUB.initialize;
252: END IF;
253:
254: -- Initialize API return status to error, i.e, its not duplicate

Line 255: x_return_status := FND_API.G_RET_STS_ERROR;

251: FND_MSG_PUB.initialize;
252: END IF;
253:
254: -- Initialize API return status to error, i.e, its not duplicate
255: x_return_status := FND_API.G_RET_STS_ERROR;
256:
257: -- Check duplicate entry
258: BEGIN
259:

Line 280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

276: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
277: FND_MESSAGE.Set_Token('REASON', SQLERRM);
278: FND_MSG_PUB.Add;
279:
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281:
282: END;
283:
284: IF (l_tmp_section_item_id IS NOT NULL) THEN

Line 286: RAISE FND_API.G_EXC_ERROR;

282: END;
283:
284: IF (l_tmp_section_item_id IS NOT NULL) THEN
285: -- found duplicate
286: RAISE FND_API.G_EXC_ERROR;
287: END IF;
288:
289: EXCEPTION
290:

Line 291: WHEN FND_API.G_EXC_ERROR THEN

287: END IF;
288:
289: EXCEPTION
290:
291: WHEN FND_API.G_EXC_ERROR THEN
292: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate
293: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
294: p_data => x_msg_data,
295: p_encoded => 'F');

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

288:
289: EXCEPTION
290:
291: WHEN FND_API.G_EXC_ERROR THEN
292: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate
293: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
294: p_data => x_msg_data,
295: p_encoded => 'F');
296:

Line 297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

293: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
294: p_data => x_msg_data,
295: p_encoded => 'F');
296:
297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
300: p_data => x_msg_data,
301: p_encoded => 'F');

Line 298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

294: p_data => x_msg_data,
295: p_encoded => 'F');
296:
297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
300: p_data => x_msg_data,
301: p_encoded => 'F');
302:

Line 310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

306: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
307: FND_MESSAGE.Set_Token('REASON', SQLERRM);
308: FND_MSG_PUB.Add;
309:
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311:
312: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
313: THEN
314: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

323:
324: --*****************************************************************************
325: -- PROCEDURE Validate_Create()
326: --*****************************************************************************
327: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
328: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
329:
330: PROCEDURE Validate_Create
331: (

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

324: --*****************************************************************************
325: -- PROCEDURE Validate_Create()
326: --*****************************************************************************
327: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
328: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
329:
330: PROCEDURE Validate_Create
331: (
332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

328: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
329:
330: PROCEDURE Validate_Create
331: (
332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
333: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
334: p_section_id IN NUMBER,
335: p_inventory_item_id IN NUMBER,
336: p_organization_id IN NUMBER,

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

329:
330: PROCEDURE Validate_Create
331: (
332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
333: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
334: p_section_id IN NUMBER,
335: p_inventory_item_id IN NUMBER,
336: p_organization_id IN NUMBER,
337: p_start_date_active IN DATE,

Line 374: IF FND_API.to_Boolean(p_init_msg_list) THEN

370: AND mini_site_id = l_c_minisite_id;
371: BEGIN
372:
373: -- Initialize message list if p_init_msg_list is set to TRUE.
374: IF FND_API.to_Boolean(p_init_msg_list) THEN
375: FND_MSG_PUB.initialize;
376: END IF;
377:
378: -- Initialize API return status to success

Line 379: x_return_status := FND_API.G_RET_STS_SUCCESS;

375: FND_MSG_PUB.initialize;
376: END IF;
377:
378: -- Initialize API return status to success
379: x_return_status := FND_API.G_RET_STS_SUCCESS;
380:
381: --
382: -- Check null values for required fields
383: --

Line 387: (p_section_id = FND_API.G_MISS_NUM))

383: --
384:
385: -- section id
386: IF ((p_section_id IS NULL) OR
387: (p_section_id = FND_API.G_MISS_NUM))
388: THEN
389: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_ID');
390: FND_MSG_PUB.Add;
391: RAISE FND_API.G_EXC_ERROR;

Line 391: RAISE FND_API.G_EXC_ERROR;

387: (p_section_id = FND_API.G_MISS_NUM))
388: THEN
389: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_ID');
390: FND_MSG_PUB.Add;
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: -- inventory item id
395: IF ((p_inventory_item_id IS NULL) OR

Line 396: (p_inventory_item_id = FND_API.G_MISS_NUM))

392: END IF;
393:
394: -- inventory item id
395: IF ((p_inventory_item_id IS NULL) OR
396: (p_inventory_item_id = FND_API.G_MISS_NUM))
397: THEN
398: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_INV_ITEM_ID');
399: FND_MSG_PUB.Add;
400: RAISE FND_API.G_EXC_ERROR;

Line 400: RAISE FND_API.G_EXC_ERROR;

396: (p_inventory_item_id = FND_API.G_MISS_NUM))
397: THEN
398: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_INV_ITEM_ID');
399: FND_MSG_PUB.Add;
400: RAISE FND_API.G_EXC_ERROR;
401: END IF;
402:
403: -- organization id
404: IF ((p_organization_id IS NULL) OR

Line 405: (p_organization_id = FND_API.G_MISS_NUM))

401: END IF;
402:
403: -- organization id
404: IF ((p_organization_id IS NULL) OR
405: (p_organization_id = FND_API.G_MISS_NUM))
406: THEN
407: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_INV_ORG_ID');
408: FND_MSG_PUB.Add;
409: RAISE FND_API.G_EXC_ERROR;

Line 409: RAISE FND_API.G_EXC_ERROR;

405: (p_organization_id = FND_API.G_MISS_NUM))
406: THEN
407: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_INV_ORG_ID');
408: FND_MSG_PUB.Add;
409: RAISE FND_API.G_EXC_ERROR;
410: END IF;
411:
412: -- start_date_active
413: IF ((p_start_date_active IS NULL) OR

Line 414: (p_start_date_active = FND_API.G_MISS_DATE))

410: END IF;
411:
412: -- start_date_active
413: IF ((p_start_date_active IS NULL) OR
414: (p_start_date_active = FND_API.G_MISS_DATE))
415: THEN
416: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_START_DATE');
417: FND_MSG_PUB.Add;
418: RAISE FND_API.G_EXC_ERROR;

Line 418: RAISE FND_API.G_EXC_ERROR;

414: (p_start_date_active = FND_API.G_MISS_DATE))
415: THEN
416: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_START_DATE');
417: FND_MSG_PUB.Add;
418: RAISE FND_API.G_EXC_ERROR;
419: END IF;
420:
421: --
422: -- non-null field validation

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

423: --
424:
425: -- sort order
426: IF ((p_sort_order IS NOT NULL) AND
427: (p_sort_order <> FND_API.G_MISS_NUM))
428: THEN
429: IF(p_sort_order < 0) THEN
430: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_SORT_ORDER');
431: FND_MSG_PUB.Add;

Line 432: RAISE FND_API.G_EXC_ERROR;

428: THEN
429: IF(p_sort_order < 0) THEN
430: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_SORT_ORDER');
431: FND_MSG_PUB.Add;
432: RAISE FND_API.G_EXC_ERROR;
433: END IF;
434: END IF;
435:
436: --

Line 450: RAISE FND_API.G_EXC_ERROR;

446: WHEN NO_DATA_FOUND THEN
447: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ID');
448: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
449: FND_MSG_PUB.Add;
450: RAISE FND_API.G_EXC_ERROR;
451: WHEN OTHERS THEN
452: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
453: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
454: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

457:
458: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ID');
459: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
460: FND_MSG_PUB.Add;
461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
462: END;
463:
464: -- inventory item id and organization id
465: BEGIN

Line 483: RAISE FND_API.G_EXC_ERROR;

479: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_INV_ITEM_ID');
480: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
481: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
482: FND_MSG_PUB.Add;
483: RAISE FND_API.G_EXC_ERROR;
484: WHEN OTHERS THEN
485: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
486: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
487: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

491: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_GET_INV_ITEM_ID');
492: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
493: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
494: FND_MSG_PUB.Add;
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END;
497:
498: -- Validate if the entry is duplicate
499: Check_Duplicate_Entry

Line 501: p_init_msg_list => FND_API.G_FALSE,

497:
498: -- Validate if the entry is duplicate
499: Check_Duplicate_Entry
500: (
501: p_init_msg_list => FND_API.G_FALSE,
502: p_section_id => p_section_id,
503: p_inventory_item_id => p_inventory_item_id,
504: p_organization_id => p_organization_id,
505: x_return_status => l_return_status,

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

505: x_return_status => l_return_status,
506: x_msg_count => l_msg_count,
507: x_msg_data => l_msg_data);
508:
509: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
512: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_DUPLICATE_ENTRY');
513: FND_MSG_PUB.Add;

Line 510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

506: x_msg_count => l_msg_count,
507: x_msg_data => l_msg_data);
508:
509: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
512: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_DUPLICATE_ENTRY');
513: FND_MSG_PUB.Add;
514: RAISE FND_API.G_EXC_ERROR; -- duplicate entry

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

507: x_msg_data => l_msg_data);
508:
509: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
512: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_DUPLICATE_ENTRY');
513: FND_MSG_PUB.Add;
514: RAISE FND_API.G_EXC_ERROR; -- duplicate entry
515: END IF;

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

510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
512: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_DUPLICATE_ENTRY');
513: FND_MSG_PUB.Add;
514: RAISE FND_API.G_EXC_ERROR; -- duplicate entry
515: END IF;
516:
517: --
518: -- Check if the p_section_id doesn't have any child as sections

Line 533: RAISE FND_API.G_EXC_ERROR;

529: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_HAS_CHILD_SCT');
530: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
531: FND_MSG_PUB.Add;
532: CLOSE c1;
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;
535: CLOSE c1;
536:
537: EXCEPTION

Line 539: WHEN FND_API.G_EXC_ERROR THEN

535: CLOSE c1;
536:
537: EXCEPTION
538:
539: WHEN FND_API.G_EXC_ERROR THEN
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
542: p_data => x_msg_data,
543: p_encoded => 'F');

Line 540: x_return_status := FND_API.G_RET_STS_ERROR;

536:
537: EXCEPTION
538:
539: WHEN FND_API.G_EXC_ERROR THEN
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
542: p_data => x_msg_data,
543: p_encoded => 'F');
544:

Line 545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

541: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
542: p_data => x_msg_data,
543: p_encoded => 'F');
544:
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
548: p_data => x_msg_data,
549: p_encoded => 'F');

Line 546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

542: p_data => x_msg_data,
543: p_encoded => 'F');
544:
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
548: p_data => x_msg_data,
549: p_encoded => 'F');
550:

Line 558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

554: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
555: FND_MESSAGE.Set_Token('REASON', SQLERRM);
556: FND_MSG_PUB.Add;
557:
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559:
560: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
561: THEN
562: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

571:
572: --*****************************************************************************
573: -- PROCEDURE Validate_Update()
574: --*****************************************************************************
575: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
576: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
577:
578: PROCEDURE Validate_Update
579: (

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

572: --*****************************************************************************
573: -- PROCEDURE Validate_Update()
574: --*****************************************************************************
575: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
576: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
577:
578: PROCEDURE Validate_Update
579: (
580: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

576: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
577:
578: PROCEDURE Validate_Update
579: (
580: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
581: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
582: p_section_item_id IN NUMBER,
583: p_object_version_number IN NUMBER,
584: p_start_date_active IN DATE,

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

577:
578: PROCEDURE Validate_Update
579: (
580: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
581: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
582: p_section_item_id IN NUMBER,
583: p_object_version_number IN NUMBER,
584: p_start_date_active IN DATE,
585: p_end_date_active IN DATE,

Line 607: IF FND_API.to_Boolean(p_init_msg_list) THEN

603:
604: BEGIN
605:
606: -- Initialize message list if p_init_msg_list is set to TRUE.
607: IF FND_API.to_Boolean(p_init_msg_list) THEN
608: FND_MSG_PUB.initialize;
609: END IF;
610:
611: -- Initialize API return status to success

Line 612: x_return_status := FND_API.G_RET_STS_SUCCESS;

608: FND_MSG_PUB.initialize;
609: END IF;
610:
611: -- Initialize API return status to success
612: x_return_status := FND_API.G_RET_STS_SUCCESS;
613:
614: --
615: -- Check null values for required fields
616: --

Line 622: RAISE FND_API.G_EXC_ERROR;

618: -- section_item_id
619: IF (p_section_item_id IS NULL) THEN
620: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_PRIMARY_KEY');
621: FND_MSG_PUB.Add;
622: RAISE FND_API.G_EXC_ERROR;
623: END IF;
624:
625: -- start_date_active
626: IF (p_start_date_active IS NULL) THEN

Line 629: RAISE FND_API.G_EXC_ERROR;

625: -- start_date_active
626: IF (p_start_date_active IS NULL) THEN
627: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_START_DATE');
628: FND_MSG_PUB.Add;
629: RAISE FND_API.G_EXC_ERROR;
630: END IF;
631:
632: --
633: -- non-null field validation

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

634: --
635:
636: -- sort order
637: IF ((p_sort_order IS NOT NULL) AND
638: (p_sort_order <> FND_API.G_MISS_NUM))
639: THEN
640: IF(p_sort_order < 0) THEN
641: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_SORT_ORDER');
642: FND_MSG_PUB.Add;

Line 643: RAISE FND_API.G_EXC_ERROR;

639: THEN
640: IF(p_sort_order < 0) THEN
641: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_SORT_ORDER');
642: FND_MSG_PUB.Add;
643: RAISE FND_API.G_EXC_ERROR;
644: END IF;
645: END IF;
646:
647: EXCEPTION

Line 649: WHEN FND_API.G_EXC_ERROR THEN

645: END IF;
646:
647: EXCEPTION
648:
649: WHEN FND_API.G_EXC_ERROR THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
652: p_data => x_msg_data,
653: p_encoded => 'F');

Line 650: x_return_status := FND_API.G_RET_STS_ERROR;

646:
647: EXCEPTION
648:
649: WHEN FND_API.G_EXC_ERROR THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
652: p_data => x_msg_data,
653: p_encoded => 'F');
654:

Line 655: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

651: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
652: p_data => x_msg_data,
653: p_encoded => 'F');
654:
655: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
658: p_data => x_msg_data,
659: p_encoded => 'F');

Line 656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

652: p_data => x_msg_data,
653: p_encoded => 'F');
654:
655: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
658: p_data => x_msg_data,
659: p_encoded => 'F');
660:

Line 668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

664: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
665: FND_MESSAGE.Set_Token('REASON', SQLERRM);
666: FND_MSG_PUB.Add;
667:
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669:
670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
671: THEN
672: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

684:
685: PROCEDURE Create_Section_Item
686: (
687: p_api_version IN NUMBER,
688: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
689: p_commit IN VARCHAR2 := FND_API.G_FALSE,
690: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
691: p_section_id IN NUMBER,
692: p_inventory_item_id IN NUMBER,

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

685: PROCEDURE Create_Section_Item
686: (
687: p_api_version IN NUMBER,
688: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
689: p_commit IN VARCHAR2 := FND_API.G_FALSE,
690: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
691: p_section_id IN NUMBER,
692: p_inventory_item_id IN NUMBER,
693: p_organization_id IN NUMBER,

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

686: (
687: p_api_version IN NUMBER,
688: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
689: p_commit IN VARCHAR2 := FND_API.G_FALSE,
690: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
691: p_section_id IN NUMBER,
692: p_inventory_item_id IN NUMBER,
693: p_organization_id IN NUMBER,
694: p_start_date_active IN DATE,

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

691: p_section_id IN NUMBER,
692: p_inventory_item_id IN NUMBER,
693: p_organization_id IN NUMBER,
694: p_start_date_active IN DATE,
695: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
696: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
697: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
698: x_section_item_id OUT NOCOPY NUMBER,
699: x_return_status OUT NOCOPY VARCHAR2,

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

692: p_inventory_item_id IN NUMBER,
693: p_organization_id IN NUMBER,
694: p_start_date_active IN DATE,
695: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
696: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
697: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
698: x_section_item_id OUT NOCOPY NUMBER,
699: x_return_status OUT NOCOPY VARCHAR2,
700: x_msg_count OUT NOCOPY NUMBER,

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

693: p_organization_id IN NUMBER,
694: p_start_date_active IN DATE,
695: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
696: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
697: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
698: x_section_item_id OUT NOCOPY NUMBER,
699: x_return_status OUT NOCOPY VARCHAR2,
700: x_msg_count OUT NOCOPY NUMBER,
701: x_msg_data OUT NOCOPY VARCHAR2

Line 719: IF NOT FND_API.Compatible_API_Call(l_api_version,

715: -- Standard Start of API savepoint
716: SAVEPOINT CREATE_SECTION_ITEM_PVT;
717:
718: -- Standard call to check for call compatibility.
719: IF NOT FND_API.Compatible_API_Call(l_api_version,
720: p_api_version,
721: l_api_name,
722: G_PKG_NAME)
723: THEN

Line 724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

720: p_api_version,
721: l_api_name,
722: G_PKG_NAME)
723: THEN
724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
725: END IF;
726:
727: -- Initialize message list if p_init_msg_list is set to TRUE.
728: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 728: IF FND_API.to_Boolean(p_init_msg_list) THEN

724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
725: END IF;
726:
727: -- Initialize message list if p_init_msg_list is set to TRUE.
728: IF FND_API.to_Boolean(p_init_msg_list) THEN
729: FND_MSG_PUB.initialize;
730: END IF;
731:
732: -- Initialize API return status to success

Line 733: x_return_status := FND_API.G_RET_STS_SUCCESS;

729: FND_MSG_PUB.initialize;
730: END IF;
731:
732: -- Initialize API return status to success
733: x_return_status := FND_API.G_RET_STS_SUCCESS;
734:
735: -- API body
736: -- CALL FLOW :
737: -- 1. Validate

Line 746: p_init_msg_list => FND_API.G_FALSE,

742: -- 1. Validate
743: --
744: Validate_Create
745: (
746: p_init_msg_list => FND_API.G_FALSE,
747: p_validation_level => p_validation_level,
748: p_section_id => p_section_id,
749: p_inventory_item_id => p_inventory_item_id,
750: p_organization_id => p_organization_id,

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

756: x_msg_count => l_msg_count,
757: x_msg_data => l_msg_data
758: );
759:
760: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
763: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INVALID_CREATE');
764: FND_MSG_PUB.Add;

Line 761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

757: x_msg_data => l_msg_data
758: );
759:
760: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
763: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INVALID_CREATE');
764: FND_MSG_PUB.Add;
765: RAISE FND_API.G_EXC_ERROR; -- invalid

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

758: );
759:
760: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
763: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INVALID_CREATE');
764: FND_MSG_PUB.Add;
765: RAISE FND_API.G_EXC_ERROR; -- invalid
766: END IF;

Line 765: RAISE FND_API.G_EXC_ERROR; -- invalid

761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
763: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INVALID_CREATE');
764: FND_MSG_PUB.Add;
765: RAISE FND_API.G_EXC_ERROR; -- invalid
766: END IF;
767:
768: --
769: -- 2. Insert row

Line 774: FND_API.G_MISS_NUM,

770: --
771: BEGIN
772: insert_row
773: (
774: FND_API.G_MISS_NUM,
775: l_object_version_number,
776: p_section_id,
777: p_inventory_item_id,
778: p_organization_id,

Line 796: RAISE FND_API.G_EXC_ERROR;

792: EXCEPTION
793: WHEN NO_DATA_FOUND THEN
794: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INSERT_FAIL');
795: FND_MSG_PUB.Add;
796: RAISE FND_API.G_EXC_ERROR;
797: WHEN OTHERS THEN
798: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
799: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
800: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

802: FND_MSG_PUB.Add;
803:
804: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INSERT_FAIL');
805: FND_MSG_PUB.Add;
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: END;
808:
809: --
810: -- Call api which makes changes in relationship tables

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

819: --
820: -- End of main API body.
821:
822: -- Standard check of p_commit.
823: IF (FND_API.To_Boolean(p_commit)) THEN
824: COMMIT WORK;
825: END IF;
826:
827: -- Standard call to get message count and if count is 1, get message info.

Line 834: WHEN FND_API.G_EXC_ERROR THEN

830: p_encoded => 'F');
831:
832: EXCEPTION
833:
834: WHEN FND_API.G_EXC_ERROR THEN
835: ROLLBACK TO CREATE_SECTION_ITEM_PVT;
836: x_return_status := FND_API.G_RET_STS_ERROR;
837: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
838: p_data => x_msg_data,

Line 836: x_return_status := FND_API.G_RET_STS_ERROR;

832: EXCEPTION
833:
834: WHEN FND_API.G_EXC_ERROR THEN
835: ROLLBACK TO CREATE_SECTION_ITEM_PVT;
836: x_return_status := FND_API.G_RET_STS_ERROR;
837: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
838: p_data => x_msg_data,
839: p_encoded => 'F');
840:

Line 841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

837: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
838: p_data => x_msg_data,
839: p_encoded => 'F');
840:
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: ROLLBACK TO CREATE_SECTION_ITEM_PVT;
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
844: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
845: p_data => x_msg_data,

Line 843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

839: p_encoded => 'F');
840:
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: ROLLBACK TO CREATE_SECTION_ITEM_PVT;
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
844: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
845: p_data => x_msg_data,
846: p_encoded => 'F');
847:

Line 857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

853: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
854: FND_MESSAGE.Set_Token('REASON', SQLERRM);
855: FND_MSG_PUB.Add;
856:
857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858:
859: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
860: THEN
861: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

869:
870: PROCEDURE Update_Section_Item
871: (
872: p_api_version IN NUMBER,
873: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
874: p_commit IN VARCHAR2 := FND_API.G_FALSE,
875: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
876: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
877: p_object_version_number IN NUMBER,

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

870: PROCEDURE Update_Section_Item
871: (
872: p_api_version IN NUMBER,
873: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
874: p_commit IN VARCHAR2 := FND_API.G_FALSE,
875: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
876: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
877: p_object_version_number IN NUMBER,
878: p_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

871: (
872: p_api_version IN NUMBER,
873: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
874: p_commit IN VARCHAR2 := FND_API.G_FALSE,
875: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
876: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
877: p_object_version_number IN NUMBER,
878: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
879: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,

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

872: p_api_version IN NUMBER,
873: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
874: p_commit IN VARCHAR2 := FND_API.G_FALSE,
875: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
876: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
877: p_object_version_number IN NUMBER,
878: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
879: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
880: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,

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

874: p_commit IN VARCHAR2 := FND_API.G_FALSE,
875: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
876: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
877: p_object_version_number IN NUMBER,
878: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
879: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
880: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
881: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
882: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

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

875: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
876: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
877: p_object_version_number IN NUMBER,
878: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
879: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
880: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
881: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
882: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
883: p_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

876: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
877: p_object_version_number IN NUMBER,
878: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
879: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
880: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
881: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
882: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
883: p_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
884: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,

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

877: p_object_version_number IN NUMBER,
878: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
879: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
880: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
881: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
882: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
883: p_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
884: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
885: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

878: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
879: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
880: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
881: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
882: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
883: p_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
884: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
885: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
886: x_return_status OUT NOCOPY VARCHAR2,

Line 883: p_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

879: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
880: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
881: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
882: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
883: p_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
884: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
885: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
886: x_return_status OUT NOCOPY VARCHAR2,
887: x_msg_count OUT NOCOPY NUMBER,

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

880: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
881: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
882: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
883: p_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
884: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
885: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
886: x_return_status OUT NOCOPY VARCHAR2,
887: x_msg_count OUT NOCOPY NUMBER,
888: x_msg_data OUT NOCOPY VARCHAR2

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

881: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
882: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
883: p_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
884: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
885: p_association_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
886: x_return_status OUT NOCOPY VARCHAR2,
887: x_msg_count OUT NOCOPY NUMBER,
888: x_msg_data OUT NOCOPY VARCHAR2
889: )

Line 905: IF NOT FND_API.Compatible_API_Call(l_api_version,

901: -- Standard Start of API savepoint
902: SAVEPOINT UPDATE_SECTION_ITEM_PVT;
903:
904: -- Standard call to check for call compatibility.
905: IF NOT FND_API.Compatible_API_Call(l_api_version,
906: p_api_version,
907: l_api_name,
908: G_PKG_NAME)
909: THEN

Line 910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

906: p_api_version,
907: l_api_name,
908: G_PKG_NAME)
909: THEN
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: END IF;
912:
913: -- Initialize message list if p_init_msg_list is set to TRUE.
914: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 914: IF FND_API.to_Boolean(p_init_msg_list) THEN

910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: END IF;
912:
913: -- Initialize message list if p_init_msg_list is set to TRUE.
914: IF FND_API.to_Boolean(p_init_msg_list) THEN
915: FND_MSG_PUB.initialize;
916: END IF;
917:
918: -- Initialize API return status to success

Line 919: x_return_status := FND_API.G_RET_STS_SUCCESS;

915: FND_MSG_PUB.initialize;
916: END IF;
917:
918: -- Initialize API return status to success
919: x_return_status := FND_API.G_RET_STS_SUCCESS;
920:
921: -- API body
922: -- CALL FLOW :
923: -- 1. Check if either section_item_id or combination of

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

927:
928: -- 1. Check if either section_item_id or combination of
929: -- section_id, inventory_item_id and organization_id is specified
930: IF ((p_section_item_id IS NOT NULL) AND
931: (p_section_item_id <> FND_API.G_MISS_NUM))
932: THEN
933: -- section_item_id specified, continue
934: l_section_item_id := p_section_item_id;
935: ELSIF ((p_section_id IS NOT NULL) AND

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

932: THEN
933: -- section_item_id specified, continue
934: l_section_item_id := p_section_item_id;
935: ELSIF ((p_section_id IS NOT NULL) AND
936: (p_section_id <> FND_API.G_MISS_NUM) AND
937: (p_inventory_item_id IS NOT NULL) AND
938: (p_inventory_item_id <> FND_API.G_MISS_NUM) AND
939: (p_organization_id IS NOT NULL) AND
940: (p_organization_id <> FND_API.G_MISS_NUM))

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

934: l_section_item_id := p_section_item_id;
935: ELSIF ((p_section_id IS NOT NULL) AND
936: (p_section_id <> FND_API.G_MISS_NUM) AND
937: (p_inventory_item_id IS NOT NULL) AND
938: (p_inventory_item_id <> FND_API.G_MISS_NUM) AND
939: (p_organization_id IS NOT NULL) AND
940: (p_organization_id <> FND_API.G_MISS_NUM))
941: THEN
942: -- If combination of section_id, inventory_item_id and organization_id

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

936: (p_section_id <> FND_API.G_MISS_NUM) AND
937: (p_inventory_item_id IS NOT NULL) AND
938: (p_inventory_item_id <> FND_API.G_MISS_NUM) AND
939: (p_organization_id IS NOT NULL) AND
940: (p_organization_id <> FND_API.G_MISS_NUM))
941: THEN
942: -- If combination of section_id, inventory_item_id and organization_id
943: -- is specified, then query for section_item_id
944: BEGIN

Line 959: RAISE FND_API.G_EXC_ERROR;

955: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
956: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
957: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
958: FND_MSG_PUB.Add;
959: RAISE FND_API.G_EXC_ERROR;
960: WHEN OTHERS THEN
961: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
962: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
963: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

968: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
969: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
970: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
971: FND_MSG_PUB.Add;
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
973: END;
974:
975: ELSE
976: -- neither section_item_id nor combination of

Line 980: RAISE FND_API.G_EXC_ERROR;

976: -- neither section_item_id nor combination of
977: -- section_id, inventory_item_id and organization_id is specified
978: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_SI_IDS_SPEC');
979: FND_MSG_PUB.Add;
980: RAISE FND_API.G_EXC_ERROR;
981: END IF;
982:
983: --
984: -- 1. Validate the input data

Line 988: p_init_msg_list => FND_API.G_FALSE,

984: -- 1. Validate the input data
985: --
986: Validate_Update
987: (
988: p_init_msg_list => FND_API.G_FALSE,
989: p_validation_level => p_validation_level,
990: p_section_item_id => l_section_item_id,
991: p_object_version_number => p_object_version_number,
992: p_start_date_active => p_start_date_active,

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

997: x_msg_count => l_msg_count,
998: x_msg_data => l_msg_data
999: );
1000:
1001: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1004: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INVALID_UPDATE');
1005: FND_MSG_PUB.Add;

Line 1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

998: x_msg_data => l_msg_data
999: );
1000:
1001: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1004: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INVALID_UPDATE');
1005: FND_MSG_PUB.Add;
1006: RAISE FND_API.G_EXC_ERROR; -- invalid

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

999: );
1000:
1001: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1004: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INVALID_UPDATE');
1005: FND_MSG_PUB.Add;
1006: RAISE FND_API.G_EXC_ERROR; -- invalid
1007: END IF;

Line 1006: RAISE FND_API.G_EXC_ERROR; -- invalid

1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1004: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_INVALID_UPDATE');
1005: FND_MSG_PUB.Add;
1006: RAISE FND_API.G_EXC_ERROR; -- invalid
1007: END IF;
1008:
1009: -- 2. update row
1010: BEGIN

Line 1028: RAISE FND_API.G_EXC_ERROR;

1024: EXCEPTION
1025: WHEN NO_DATA_FOUND THEN
1026: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_UPDATE_FAIL');
1027: FND_MSG_PUB.Add;
1028: RAISE FND_API.G_EXC_ERROR;
1029: WHEN OTHERS THEN
1030: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1031: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1032: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1034: FND_MSG_PUB.Add;
1035:
1036: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SI_UPDATE_FAIL');
1037: FND_MSG_PUB.Add;
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: END;
1040:
1041: --
1042: -- End of main API body.

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

1041: --
1042: -- End of main API body.
1043:
1044: -- Standard check of p_commit.
1045: IF (FND_API.To_Boolean(p_commit)) THEN
1046: COMMIT WORK;
1047: END IF;
1048:
1049: -- Standard call to get message count and if count is 1, get message info.

Line 1056: WHEN FND_API.G_EXC_ERROR THEN

1052: p_encoded => 'F');
1053:
1054: EXCEPTION
1055:
1056: WHEN FND_API.G_EXC_ERROR THEN
1057: ROLLBACK TO UPDATE_SECTION_ITEM_PVT;
1058: x_return_status := FND_API.G_RET_STS_ERROR;
1059: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1060: p_data => x_msg_data,

Line 1058: x_return_status := FND_API.G_RET_STS_ERROR;

1054: EXCEPTION
1055:
1056: WHEN FND_API.G_EXC_ERROR THEN
1057: ROLLBACK TO UPDATE_SECTION_ITEM_PVT;
1058: x_return_status := FND_API.G_RET_STS_ERROR;
1059: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1060: p_data => x_msg_data,
1061: p_encoded => 'F');
1062:

Line 1063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1059: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1060: p_data => x_msg_data,
1061: p_encoded => 'F');
1062:
1063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1064: ROLLBACK TO UPDATE_SECTION_ITEM_PVT;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1066: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1067: p_data => x_msg_data,

Line 1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1061: p_encoded => 'F');
1062:
1063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1064: ROLLBACK TO UPDATE_SECTION_ITEM_PVT;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1066: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1067: p_data => x_msg_data,
1068: p_encoded => 'F');
1069:

Line 1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1075: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1076: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1077: FND_MSG_PUB.Add;
1078:
1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1080:
1081: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1082: THEN
1083: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

1091:
1092: PROCEDURE Delete_Section_Item
1093: (
1094: p_api_version IN NUMBER,
1095: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1096: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1097: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1098: p_call_from_trigger IN BOOLEAN := FALSE,
1099: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,

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

1092: PROCEDURE Delete_Section_Item
1093: (
1094: p_api_version IN NUMBER,
1095: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1096: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1097: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1098: p_call_from_trigger IN BOOLEAN := FALSE,
1099: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
1100: p_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

1093: (
1094: p_api_version IN NUMBER,
1095: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1096: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1097: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1098: p_call_from_trigger IN BOOLEAN := FALSE,
1099: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
1100: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1101: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,

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

1095: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1096: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1097: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1098: p_call_from_trigger IN BOOLEAN := FALSE,
1099: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
1100: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1101: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
1102: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
1103: x_return_status OUT NOCOPY VARCHAR2,

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

1096: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1097: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1098: p_call_from_trigger IN BOOLEAN := FALSE,
1099: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
1100: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1101: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
1102: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
1103: x_return_status OUT NOCOPY VARCHAR2,
1104: x_msg_count OUT NOCOPY NUMBER,

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

1097: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1098: p_call_from_trigger IN BOOLEAN := FALSE,
1099: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
1100: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1101: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
1102: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
1103: x_return_status OUT NOCOPY VARCHAR2,
1104: x_msg_count OUT NOCOPY NUMBER,
1105: x_msg_data OUT NOCOPY VARCHAR2

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

1098: p_call_from_trigger IN BOOLEAN := FALSE,
1099: p_section_item_id IN NUMBER := FND_API.G_MISS_NUM,
1100: p_section_id IN NUMBER := FND_API.G_MISS_NUM,
1101: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
1102: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
1103: x_return_status OUT NOCOPY VARCHAR2,
1104: x_msg_count OUT NOCOPY NUMBER,
1105: x_msg_data OUT NOCOPY VARCHAR2
1106: )

Line 1135: IF NOT FND_API.Compatible_API_Call(l_api_version,

1131: SAVEPOINT DELETE_SECTION_ITEM_PVT;
1132: END IF;
1133:
1134: -- Standard call to check for call compatibility.
1135: IF NOT FND_API.Compatible_API_Call(l_api_version,
1136: p_api_version,
1137: l_api_name,
1138: G_PKG_NAME)
1139: THEN

Line 1140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1136: p_api_version,
1137: l_api_name,
1138: G_PKG_NAME)
1139: THEN
1140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1141: END IF;
1142:
1143: -- Initialize message list if p_init_msg_list is set to TRUE.
1144: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1144: IF FND_API.to_Boolean(p_init_msg_list) THEN

1140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1141: END IF;
1142:
1143: -- Initialize message list if p_init_msg_list is set to TRUE.
1144: IF FND_API.to_Boolean(p_init_msg_list) THEN
1145: FND_MSG_PUB.initialize;
1146: END IF;
1147:
1148: -- Initialize API return status to success

Line 1149: x_return_status := FND_API.G_RET_STS_SUCCESS;

1145: FND_MSG_PUB.initialize;
1146: END IF;
1147:
1148: -- Initialize API return status to success
1149: x_return_status := FND_API.G_RET_STS_SUCCESS;
1150:
1151: -- CALL FLOW
1152: -- 1. If section_item_id specified, delete all references for it
1153: -- 2. If combination of section_id, inventory_item_id and organization_id

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

1155: -- all references
1156:
1157: -- 1. If section_item_id specified, delete all references for it
1158: IF ((p_section_item_id IS NOT NULL) AND
1159: (p_section_item_id <> FND_API.G_MISS_NUM))
1160: THEN
1161: -- section_item_id specified, continue
1162: l_section_item_id := p_section_item_id;
1163:

Line 1171: RAISE FND_API.G_EXC_ERROR;

1167: CLOSE c2;
1168: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SI_ID');
1169: FND_MESSAGE.Set_Token('SECTION_ITEM_ID', l_section_item_id);
1170: FND_MSG_PUB.Add;
1171: RAISE FND_API.G_EXC_ERROR;
1172: END IF;
1173: CLOSE c2;
1174:
1175: ELSIF ((p_section_id IS NOT NULL) AND

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

1172: END IF;
1173: CLOSE c2;
1174:
1175: ELSIF ((p_section_id IS NOT NULL) AND
1176: (p_section_id <> FND_API.G_MISS_NUM) AND
1177: (p_inventory_item_id IS NOT NULL) AND
1178: (p_inventory_item_id <> FND_API.G_MISS_NUM) AND
1179: (p_organization_id IS NOT NULL) AND
1180: (p_organization_id <> FND_API.G_MISS_NUM))

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

1174:
1175: ELSIF ((p_section_id IS NOT NULL) AND
1176: (p_section_id <> FND_API.G_MISS_NUM) AND
1177: (p_inventory_item_id IS NOT NULL) AND
1178: (p_inventory_item_id <> FND_API.G_MISS_NUM) AND
1179: (p_organization_id IS NOT NULL) AND
1180: (p_organization_id <> FND_API.G_MISS_NUM))
1181: THEN
1182: -- If combination of section_id, inventory_item_id and organization_id

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

1176: (p_section_id <> FND_API.G_MISS_NUM) AND
1177: (p_inventory_item_id IS NOT NULL) AND
1178: (p_inventory_item_id <> FND_API.G_MISS_NUM) AND
1179: (p_organization_id IS NOT NULL) AND
1180: (p_organization_id <> FND_API.G_MISS_NUM))
1181: THEN
1182: -- If combination of section_id, inventory_item_id and organization_id
1183: -- is specified, then query for section_item_id
1184: l_section_id := p_section_id;

Line 1203: RAISE FND_API.G_EXC_ERROR;

1199: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
1200: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1201: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1202: FND_MSG_PUB.Add;
1203: RAISE FND_API.G_EXC_ERROR;
1204: WHEN OTHERS THEN
1205: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1206: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1207: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1212: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
1213: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1214: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1215: FND_MSG_PUB.Add;
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1217: END;
1218:
1219: ELSE
1220: -- neither section_item_id nor combination of

Line 1224: RAISE FND_API.G_EXC_ERROR;

1220: -- neither section_item_id nor combination of
1221: -- section_id, inventory_item_id and organization_id is specified
1222: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_SI_IDS_SPEC');
1223: FND_MSG_PUB.Add;
1224: RAISE FND_API.G_EXC_ERROR;
1225: END IF;
1226:
1227: -- delete from ibe_dsp_msite_sct_items table
1228: FOR r1 IN c1(l_section_item_id) LOOP

Line 1232: p_init_msg_list => FND_API.G_FALSE,

1228: FOR r1 IN c1(l_section_item_id) LOOP
1229: IBE_DSP_MSITE_SCT_ITEM_PVT.Delete_MSite_Section_Item
1230: (
1231: p_api_version => p_api_version,
1232: p_init_msg_list => FND_API.G_FALSE,
1233: p_commit => FND_API.G_FALSE,
1234: p_validation_level => p_validation_level,
1235: p_call_from_trigger => p_call_from_trigger,
1236: p_mini_site_section_item_id => r1.mini_site_section_item_id,

Line 1233: p_commit => FND_API.G_FALSE,

1229: IBE_DSP_MSITE_SCT_ITEM_PVT.Delete_MSite_Section_Item
1230: (
1231: p_api_version => p_api_version,
1232: p_init_msg_list => FND_API.G_FALSE,
1233: p_commit => FND_API.G_FALSE,
1234: p_validation_level => p_validation_level,
1235: p_call_from_trigger => p_call_from_trigger,
1236: p_mini_site_section_item_id => r1.mini_site_section_item_id,
1237: p_mini_site_id => FND_API.G_MISS_NUM,

Line 1237: p_mini_site_id => FND_API.G_MISS_NUM,

1233: p_commit => FND_API.G_FALSE,
1234: p_validation_level => p_validation_level,
1235: p_call_from_trigger => p_call_from_trigger,
1236: p_mini_site_section_item_id => r1.mini_site_section_item_id,
1237: p_mini_site_id => FND_API.G_MISS_NUM,
1238: p_section_item_id => FND_API.G_MISS_NUM,
1239: x_return_status => x_return_status,
1240: x_msg_count => x_msg_count,
1241: x_msg_data => x_msg_data

Line 1238: p_section_item_id => FND_API.G_MISS_NUM,

1234: p_validation_level => p_validation_level,
1235: p_call_from_trigger => p_call_from_trigger,
1236: p_mini_site_section_item_id => r1.mini_site_section_item_id,
1237: p_mini_site_id => FND_API.G_MISS_NUM,
1238: p_section_item_id => FND_API.G_MISS_NUM,
1239: x_return_status => x_return_status,
1240: x_msg_count => x_msg_count,
1241: x_msg_data => x_msg_data
1242: );

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

1240: x_msg_count => x_msg_count,
1241: x_msg_data => x_msg_data
1242: );
1243:
1244: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1245: RAISE FND_API.G_EXC_ERROR;
1246: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: END IF;

Line 1245: RAISE FND_API.G_EXC_ERROR;

1241: x_msg_data => x_msg_data
1242: );
1243:
1244: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1245: RAISE FND_API.G_EXC_ERROR;
1246: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: END IF;
1249:

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

1242: );
1243:
1244: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1245: RAISE FND_API.G_EXC_ERROR;
1246: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: END IF;
1249:
1250: END LOOP;

Line 1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1243:
1244: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1245: RAISE FND_API.G_EXC_ERROR;
1246: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: END IF;
1249:
1250: END LOOP;
1251:

Line 1265: WHEN FND_API.G_EXC_ERROR THEN

1261: delete_row(l_section_item_id);
1262:
1263: EXCEPTION
1264:
1265: WHEN FND_API.G_EXC_ERROR THEN
1266: IF (p_call_from_trigger = FALSE) THEN
1267: ROLLBACK TO DELETE_SECTION_ITEM_PVT;
1268: END IF;
1269: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1269: x_return_status := FND_API.G_RET_STS_ERROR;

1265: WHEN FND_API.G_EXC_ERROR THEN
1266: IF (p_call_from_trigger = FALSE) THEN
1267: ROLLBACK TO DELETE_SECTION_ITEM_PVT;
1268: END IF;
1269: x_return_status := FND_API.G_RET_STS_ERROR;
1270: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1271: p_data => x_msg_data,
1272: p_encoded => 'F');
1273:

Line 1274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1270: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1271: p_data => x_msg_data,
1272: p_encoded => 'F');
1273:
1274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1275: IF (p_call_from_trigger = FALSE) THEN
1276: ROLLBACK TO DELETE_SECTION_ITEM_PVT;
1277: END IF;
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1275: IF (p_call_from_trigger = FALSE) THEN
1276: ROLLBACK TO DELETE_SECTION_ITEM_PVT;
1277: END IF;
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1279: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1280: p_data => x_msg_data,
1281: p_encoded => 'F');
1282:

Line 1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1290: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1291: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1292: FND_MSG_PUB.Add;
1293:
1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1295:
1296: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1297: THEN
1298: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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

1308: -- delete section items for input of inventory item id and organization id
1309: --
1310: PROCEDURE Delete_Section_Items_For_Item
1311: (
1312: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
1313: p_organization_id IN NUMBER := FND_API.G_MISS_NUM
1314: )
1315: IS
1316: l_api_name CONSTANT VARCHAR2(30) :='Delete_Section_Items_For_Item';

Line 1313: p_organization_id IN NUMBER := FND_API.G_MISS_NUM

1309: --
1310: PROCEDURE Delete_Section_Items_For_Item
1311: (
1312: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
1313: p_organization_id IN NUMBER := FND_API.G_MISS_NUM
1314: )
1315: IS
1316: l_api_name CONSTANT VARCHAR2(30) :='Delete_Section_Items_For_Item';
1317: l_api_version CONSTANT NUMBER := 1.0;

Line 1334: p_init_msg_list => FND_API.G_FALSE,

1330:
1331: Delete_Section_Item
1332: (
1333: p_api_version => l_api_version,
1334: p_init_msg_list => FND_API.G_FALSE,
1335: p_commit => FND_API.G_FALSE,
1336: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1337: p_call_from_trigger => TRUE,
1338: p_section_item_id => r1.section_item_id,

Line 1335: p_commit => FND_API.G_FALSE,

1331: Delete_Section_Item
1332: (
1333: p_api_version => l_api_version,
1334: p_init_msg_list => FND_API.G_FALSE,
1335: p_commit => FND_API.G_FALSE,
1336: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1337: p_call_from_trigger => TRUE,
1338: p_section_item_id => r1.section_item_id,
1339: p_section_id => FND_API.G_MISS_NUM,

Line 1336: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1332: (
1333: p_api_version => l_api_version,
1334: p_init_msg_list => FND_API.G_FALSE,
1335: p_commit => FND_API.G_FALSE,
1336: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1337: p_call_from_trigger => TRUE,
1338: p_section_item_id => r1.section_item_id,
1339: p_section_id => FND_API.G_MISS_NUM,
1340: p_inventory_item_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 => FND_API.G_VALID_LEVEL_FULL,
1337: p_call_from_trigger => TRUE,
1338: p_section_item_id => r1.section_item_id,
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: x_return_status => l_return_status,
1343: x_msg_count => l_msg_count,

Line 1340: p_inventory_item_id => FND_API.G_MISS_NUM,

1336: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1337: p_call_from_trigger => TRUE,
1338: p_section_item_id => r1.section_item_id,
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: x_return_status => l_return_status,
1343: x_msg_count => l_msg_count,
1344: x_msg_data => l_msg_data

Line 1341: p_organization_id => FND_API.G_MISS_NUM,

1337: p_call_from_trigger => TRUE,
1338: p_section_item_id => r1.section_item_id,
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: x_return_status => l_return_status,
1343: x_msg_count => l_msg_count,
1344: x_msg_data => l_msg_data
1345: );

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

1343: x_msg_count => l_msg_count,
1344: x_msg_data => l_msg_data
1345: );
1346:
1347: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1349: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1350: RAISE FND_API.G_EXC_ERROR;
1351: END IF;

Line 1348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1344: x_msg_data => l_msg_data
1345: );
1346:
1347: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1349: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1350: RAISE FND_API.G_EXC_ERROR;
1351: END IF;
1352:

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

1345: );
1346:
1347: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1349: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1350: RAISE FND_API.G_EXC_ERROR;
1351: END IF;
1352:
1353: END LOOP;

Line 1350: RAISE FND_API.G_EXC_ERROR;

1346:
1347: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1349: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1350: RAISE FND_API.G_EXC_ERROR;
1351: END IF;
1352:
1353: END LOOP;
1354:

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

1360: --
1361: PROCEDURE Update_Delete_Sct_Itms
1362: (
1363: p_api_version IN NUMBER,
1364: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1365: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1366: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1367: p_section_item_ids IN JTF_NUMBER_TABLE,
1368: p_object_version_numbers IN JTF_NUMBER_TABLE,

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

1361: PROCEDURE Update_Delete_Sct_Itms
1362: (
1363: p_api_version IN NUMBER,
1364: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1365: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1366: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1367: p_section_item_ids IN JTF_NUMBER_TABLE,
1368: p_object_version_numbers IN JTF_NUMBER_TABLE,
1369: p_start_date_actives IN JTF_DATE_TABLE,

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

1362: (
1363: p_api_version IN NUMBER,
1364: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1365: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1366: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1367: p_section_item_ids IN JTF_NUMBER_TABLE,
1368: p_object_version_numbers IN JTF_NUMBER_TABLE,
1369: p_start_date_actives IN JTF_DATE_TABLE,
1370: p_end_date_actives IN JTF_DATE_TABLE,

Line 1394: IF NOT FND_API.Compatible_API_Call(l_api_version,

1390: -- Standard Start of API savepoint
1391: SAVEPOINT UPDATE_DELETE_SCT_ITMS_PVT;
1392:
1393: -- Standard call to check for call compatibility.
1394: IF NOT FND_API.Compatible_API_Call(l_api_version,
1395: p_api_version,
1396: l_api_name,
1397: G_PKG_NAME)
1398: THEN

Line 1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1395: p_api_version,
1396: l_api_name,
1397: G_PKG_NAME)
1398: THEN
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: END IF;
1401:
1402: -- Initialize message list if p_init_msg_list is set to TRUE.
1403: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1403: IF FND_API.to_Boolean(p_init_msg_list) THEN

1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: END IF;
1401:
1402: -- Initialize message list if p_init_msg_list is set to TRUE.
1403: IF FND_API.to_Boolean(p_init_msg_list) THEN
1404: FND_MSG_PUB.initialize;
1405: END IF;
1406:
1407: -- Initialize API return status to success

Line 1408: x_return_status := FND_API.G_RET_STS_SUCCESS;

1404: FND_MSG_PUB.initialize;
1405: END IF;
1406:
1407: -- Initialize API return status to success
1408: x_return_status := FND_API.G_RET_STS_SUCCESS;
1409:
1410: -- API body
1411: -- CALL FLOW :
1412: -- 1.

Line 1420: p_init_msg_list => FND_API.G_FALSE,

1416:
1417: Delete_Section_Item
1418: (
1419: p_api_version => p_api_version,
1420: p_init_msg_list => FND_API.G_FALSE,
1421: p_commit => FND_API.G_FALSE,
1422: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1423: p_section_item_id => p_section_item_ids(i),
1424: p_section_id => FND_API.G_MISS_NUM,

Line 1421: p_commit => FND_API.G_FALSE,

1417: Delete_Section_Item
1418: (
1419: p_api_version => p_api_version,
1420: p_init_msg_list => FND_API.G_FALSE,
1421: p_commit => FND_API.G_FALSE,
1422: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1423: p_section_item_id => p_section_item_ids(i),
1424: p_section_id => FND_API.G_MISS_NUM,
1425: p_inventory_item_id => FND_API.G_MISS_NUM,

Line 1422: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1418: (
1419: p_api_version => p_api_version,
1420: p_init_msg_list => FND_API.G_FALSE,
1421: p_commit => FND_API.G_FALSE,
1422: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1423: p_section_item_id => p_section_item_ids(i),
1424: p_section_id => FND_API.G_MISS_NUM,
1425: p_inventory_item_id => FND_API.G_MISS_NUM,
1426: p_organization_id => FND_API.G_MISS_NUM,

Line 1424: p_section_id => FND_API.G_MISS_NUM,

1420: p_init_msg_list => FND_API.G_FALSE,
1421: p_commit => FND_API.G_FALSE,
1422: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1423: p_section_item_id => p_section_item_ids(i),
1424: p_section_id => FND_API.G_MISS_NUM,
1425: p_inventory_item_id => FND_API.G_MISS_NUM,
1426: p_organization_id => FND_API.G_MISS_NUM,
1427: x_return_status => x_return_status,
1428: x_msg_count => x_msg_count,

Line 1425: p_inventory_item_id => FND_API.G_MISS_NUM,

1421: p_commit => FND_API.G_FALSE,
1422: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1423: p_section_item_id => p_section_item_ids(i),
1424: p_section_id => FND_API.G_MISS_NUM,
1425: p_inventory_item_id => FND_API.G_MISS_NUM,
1426: p_organization_id => FND_API.G_MISS_NUM,
1427: x_return_status => x_return_status,
1428: x_msg_count => x_msg_count,
1429: x_msg_data => x_msg_data

Line 1426: p_organization_id => FND_API.G_MISS_NUM,

1422: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1423: p_section_item_id => p_section_item_ids(i),
1424: p_section_id => FND_API.G_MISS_NUM,
1425: p_inventory_item_id => FND_API.G_MISS_NUM,
1426: p_organization_id => FND_API.G_MISS_NUM,
1427: x_return_status => x_return_status,
1428: x_msg_count => x_msg_count,
1429: x_msg_data => x_msg_data
1430: );

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

1429: x_msg_data => x_msg_data
1430: );
1431:
1432:
1433: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1434: RAISE FND_API.G_EXC_ERROR;
1435: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1437: END IF;

Line 1434: RAISE FND_API.G_EXC_ERROR;

1430: );
1431:
1432:
1433: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1434: RAISE FND_API.G_EXC_ERROR;
1435: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1437: END IF;
1438:

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

1431:
1432:
1433: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1434: RAISE FND_API.G_EXC_ERROR;
1435: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1437: END IF;
1438:
1439: ELSE

Line 1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1432:
1433: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1434: RAISE FND_API.G_EXC_ERROR;
1435: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1437: END IF;
1438:
1439: ELSE
1440: Update_Section_Item

Line 1443: p_init_msg_list => FND_API.G_FALSE,

1439: ELSE
1440: Update_Section_Item
1441: (
1442: p_api_version => p_api_version,
1443: p_init_msg_list => FND_API.G_FALSE,
1444: p_commit => FND_API.G_FALSE,
1445: p_validation_level => p_validation_level,
1446: p_section_item_id => p_section_item_ids(i),
1447: p_object_version_number => p_object_version_numbers(i),

Line 1444: p_commit => FND_API.G_FALSE,

1440: Update_Section_Item
1441: (
1442: p_api_version => p_api_version,
1443: p_init_msg_list => FND_API.G_FALSE,
1444: p_commit => FND_API.G_FALSE,
1445: p_validation_level => p_validation_level,
1446: p_section_item_id => p_section_item_ids(i),
1447: p_object_version_number => p_object_version_numbers(i),
1448: p_section_id => FND_API.G_MISS_NUM,

Line 1448: p_section_id => FND_API.G_MISS_NUM,

1444: p_commit => FND_API.G_FALSE,
1445: p_validation_level => p_validation_level,
1446: p_section_item_id => p_section_item_ids(i),
1447: p_object_version_number => p_object_version_numbers(i),
1448: p_section_id => FND_API.G_MISS_NUM,
1449: p_inventory_item_id => FND_API.G_MISS_NUM,
1450: p_organization_id => FND_API.G_MISS_NUM,
1451: p_start_date_active => p_start_date_actives(i),
1452: p_end_date_active => p_end_date_actives(i),

Line 1449: p_inventory_item_id => FND_API.G_MISS_NUM,

1445: p_validation_level => p_validation_level,
1446: p_section_item_id => p_section_item_ids(i),
1447: p_object_version_number => p_object_version_numbers(i),
1448: p_section_id => FND_API.G_MISS_NUM,
1449: p_inventory_item_id => FND_API.G_MISS_NUM,
1450: p_organization_id => FND_API.G_MISS_NUM,
1451: p_start_date_active => p_start_date_actives(i),
1452: p_end_date_active => p_end_date_actives(i),
1453: p_usage_name => p_usage_names(i),

Line 1450: p_organization_id => FND_API.G_MISS_NUM,

1446: p_section_item_id => p_section_item_ids(i),
1447: p_object_version_number => p_object_version_numbers(i),
1448: p_section_id => FND_API.G_MISS_NUM,
1449: p_inventory_item_id => FND_API.G_MISS_NUM,
1450: p_organization_id => FND_API.G_MISS_NUM,
1451: p_start_date_active => p_start_date_actives(i),
1452: p_end_date_active => p_end_date_actives(i),
1453: p_usage_name => p_usage_names(i),
1454: p_sort_order => p_sort_orders(i),

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

1457: x_msg_count => x_msg_count,
1458: x_msg_data => x_msg_data
1459: );
1460:
1461: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1462: RAISE FND_API.G_EXC_ERROR;
1463: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1465: END IF;

Line 1462: RAISE FND_API.G_EXC_ERROR;

1458: x_msg_data => x_msg_data
1459: );
1460:
1461: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1462: RAISE FND_API.G_EXC_ERROR;
1463: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1465: END IF;
1466:

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

1459: );
1460:
1461: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1462: RAISE FND_API.G_EXC_ERROR;
1463: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1465: END IF;
1466:
1467: END IF;

Line 1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1460:
1461: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1462: RAISE FND_API.G_EXC_ERROR;
1463: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1465: END IF;
1466:
1467: END IF;
1468:

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

1472: --
1473: -- End of main API body.
1474:
1475: -- Standard check of p_commit.
1476: IF (FND_API.To_Boolean(p_commit)) THEN
1477: COMMIT WORK;
1478: END IF;
1479:
1480: -- Standard call to get message count and if count is 1, get message info.

Line 1487: WHEN FND_API.G_EXC_ERROR THEN

1483: p_encoded => 'F');
1484:
1485: EXCEPTION
1486:
1487: WHEN FND_API.G_EXC_ERROR THEN
1488: ROLLBACK TO UPDATE_DELETE_SCT_ITMS_PVT;
1489: x_return_status := FND_API.G_RET_STS_ERROR;
1490: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1491: p_data => x_msg_data,

Line 1489: x_return_status := FND_API.G_RET_STS_ERROR;

1485: EXCEPTION
1486:
1487: WHEN FND_API.G_EXC_ERROR THEN
1488: ROLLBACK TO UPDATE_DELETE_SCT_ITMS_PVT;
1489: x_return_status := FND_API.G_RET_STS_ERROR;
1490: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1491: p_data => x_msg_data,
1492: p_encoded => 'F');
1493:

Line 1494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1490: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1491: p_data => x_msg_data,
1492: p_encoded => 'F');
1493:
1494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1495: ROLLBACK TO UPDATE_DELETE_SCT_ITMS_PVT;
1496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1497: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1498: p_data => x_msg_data,

Line 1496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1492: p_encoded => 'F');
1493:
1494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1495: ROLLBACK TO UPDATE_DELETE_SCT_ITMS_PVT;
1496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1497: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1498: p_data => x_msg_data,
1499: p_encoded => 'F');
1500:

Line 1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1506: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1507: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1508: FND_MSG_PUB.Add;
1509:
1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511:
1512: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1513: THEN
1514: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);