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

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

13: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
14: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
15: PROCEDURE Process_Error(
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE,
20: p_message_name IN MTL_CC_INTERFACE_ERRORS.ERROR_MESSAGE%TYPE,
21: p_error_column_name IN MTL_CC_INTERFACE_ERRORS.ERROR_COLUMN_NAME%TYPE,

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

14: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
15: PROCEDURE Process_Error(
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE,
20: p_message_name IN MTL_CC_INTERFACE_ERRORS.ERROR_MESSAGE%TYPE,
21: p_error_column_name IN MTL_CC_INTERFACE_ERRORS.ERROR_COLUMN_NAME%TYPE,
22: p_error_table_name IN MTL_CC_INTERFACE_ERRORS.ERROR_TABLE_NAME%TYPE,

Line 37: IF NOT FND_API.Compatible_API_Call(l_api_version

33: -- Standard start of API savepoint
34: SAVEPOINT Process_Error;
35: --
36: -- Standard Call to check for call compatibility
37: IF NOT FND_API.Compatible_API_Call(l_api_version
38: , p_api_version
39: , l_api_name
40: , G_PKG_NAME) THEN
41: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 41: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

37: IF NOT FND_API.Compatible_API_Call(l_api_version
38: , p_api_version
39: , l_api_name
40: , G_PKG_NAME) THEN
41: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
42: END IF;
43:
44: --
45: -- Initialize message list if p_init_msg_list is set to true

Line 46: IF FND_API.to_Boolean(p_init_msg_list) THEN

42: END IF;
43:
44: --
45: -- Initialize message list if p_init_msg_list is set to true
46: IF FND_API.to_Boolean(p_init_msg_list) THEN
47: FND_MSG_PUB.initialize;
48: END IF;
49:
50: -- Initialize API return status to success

Line 51: x_return_status := FND_API.G_RET_STS_SUCCESS;

47: FND_MSG_PUB.initialize;
48: END IF;
49:
50: -- Initialize API return status to success
51: x_return_status := FND_API.G_RET_STS_SUCCESS;
52: --
53: -- API body
54: --
55:

Line 65: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

61: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
62: p_interface_rec=> p_interface_rec,
63: x_return_status => x_return_status);
64:
65: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
66: -- TODO: post FND message about not being able to create
67: -- a cycle count entry
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: END IF;

Line 68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

64:
65: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
66: -- TODO: post FND message about not being able to create
67: -- a cycle count entry
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: END IF;
70: END IF;
71:
72: --

Line 82: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

78: x_msg_data => x_msg_data,
79: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,
80: p_flags => p_flags);
81:
82: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
83: -- TODO: post FND message about not being able to set flags
84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86:

Line 84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

80: p_flags => p_flags);
81:
82: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
83: -- TODO: post FND message about not being able to set flags
84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86:
87: --
88: -- Write INTO Error TABLE

Line 101: IF FND_API.to_Boolean(p_commit) THEN

97: -- END of API body
98: --
99:
100: -- Standard check of p_commit
101: IF FND_API.to_Boolean(p_commit) THEN
102: COMMIT;
103: END IF;
104:
105: FND_MSG_PUB.Count_And_Get

Line 110: WHEN FND_API.G_EXC_ERROR THEN

106: (p_count => x_msg_count
107: , p_data => x_msg_data);
108:
109: EXCEPTION
110: WHEN FND_API.G_EXC_ERROR THEN
111: --
112: ROLLBACK TO Process_Error;
113: --
114: x_return_status := FND_API.G_RET_STS_ERROR;

Line 114: x_return_status := FND_API.G_RET_STS_ERROR;

110: WHEN FND_API.G_EXC_ERROR THEN
111: --
112: ROLLBACK TO Process_Error;
113: --
114: x_return_status := FND_API.G_RET_STS_ERROR;
115: --
116: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
117: , p_data => x_msg_data);
118: --

Line 119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

115: --
116: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
117: , p_data => x_msg_data);
118: --
119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
120: --
121: ROLLBACK TO Process_Error;
122: --
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
120: --
121: ROLLBACK TO Process_Error;
122: --
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: --
125: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
126: , p_data => x_msg_data);
127: --

Line 132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

128: WHEN OTHERS THEN
129: --
130: ROLLBACK TO Process_Error;
131: --
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133: --
134: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
135: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
136: END IF;

Line 150: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

146: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
147: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
148: PROCEDURE Export_CountRequest(
149: p_api_version IN NUMBER ,
150: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
151: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
152: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
153: x_return_status OUT NOCOPY VARCHAR2 ,
154: x_msg_count OUT NOCOPY NUMBER ,

Line 151: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

147: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
148: PROCEDURE Export_CountRequest(
149: p_api_version IN NUMBER ,
150: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
151: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
152: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
153: x_return_status OUT NOCOPY VARCHAR2 ,
154: x_msg_count OUT NOCOPY NUMBER ,
155: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 152: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

148: PROCEDURE Export_CountRequest(
149: p_api_version IN NUMBER ,
150: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
151: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
152: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
153: x_return_status OUT NOCOPY VARCHAR2 ,
154: x_msg_count OUT NOCOPY NUMBER ,
155: x_msg_data OUT NOCOPY VARCHAR2 ,
156: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )

Line 172: -- DEFAULT = FND_API.G_FALSE,

168: -- Parameters:
169: -- IN : p_api_version IN NUMBER (required)
170: -- API Version of this procedure
171: -- p_init_msg_level IN VARCHAR2 (optional)
172: -- DEFAULT = FND_API.G_FALSE,
173: -- p_commit IN VARCHAR2 (optional)
174: -- DEFAULT = FND_API.G_FALSE,
175: -- p_validation_level IN NUMBER (optional)
176: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,

Line 174: -- DEFAULT = FND_API.G_FALSE,

170: -- API Version of this procedure
171: -- p_init_msg_level IN VARCHAR2 (optional)
172: -- DEFAULT = FND_API.G_FALSE,
173: -- p_commit IN VARCHAR2 (optional)
174: -- DEFAULT = FND_API.G_FALSE,
175: -- p_validation_level IN NUMBER (optional)
176: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
177: -- p_interface_rec IN CCEOI_Rec_Type (required)
178: -- complete interface RECORD

Line 176: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,

172: -- DEFAULT = FND_API.G_FALSE,
173: -- p_commit IN VARCHAR2 (optional)
174: -- DEFAULT = FND_API.G_FALSE,
175: -- p_validation_level IN NUMBER (optional)
176: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
177: -- p_interface_rec IN CCEOI_Rec_Type (required)
178: -- complete interface RECORD
179: -- OUT : X_return_status OUT NUMBER
180: -- Result of all the operations

Line 207: IF NOT FND_API.Compatible_API_Call(l_api_version

203: -- Standard start of API savepoint
204: SAVEPOINT Export_CountRequest_PVT;
205: --
206: -- Standard Call to check for call compatibility
207: IF NOT FND_API.Compatible_API_Call(l_api_version
208: , p_api_version
209: , l_api_name
210: , G_PKG_NAME) THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

207: IF NOT FND_API.Compatible_API_Call(l_api_version
208: , p_api_version
209: , l_api_name
210: , G_PKG_NAME) THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213: --
214: -- Initialize message list if p_init_msg_list is set to true
215: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 215: IF FND_API.to_Boolean(p_init_msg_list) THEN

211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213: --
214: -- Initialize message list if p_init_msg_list is set to true
215: IF FND_API.to_Boolean(p_init_msg_list) THEN
216: FND_MSG_PUB.initialize;
217: END IF;
218: --
219: -- Initialisize API return status to access

Line 220: x_return_status := FND_API.G_RET_STS_SUCCESS;

216: FND_MSG_PUB.initialize;
217: END IF;
218: --
219: -- Initialisize API return status to access
220: x_return_status := FND_API.G_RET_STS_SUCCESS;
221: --
222: -- API body
223: --
224: -- Delete all error records first

Line 249: IF FND_API.to_Boolean(p_commit) THEN

245: x_return_status := L_return_status;
246: --
247: -- END of API body
248: -- Standard check of p_commit
249: IF FND_API.to_Boolean(p_commit) THEN
250: COMMIT;
251: END IF;
252: -- Standard call to get message count and if count is 1, get message info
253: FND_MSG_PUB.Count_And_Get

Line 257: WHEN FND_API.G_EXC_ERROR THEN

253: FND_MSG_PUB.Count_And_Get
254: (p_count => x_msg_count
255: , p_data => x_msg_data);
256: EXCEPTION
257: WHEN FND_API.G_EXC_ERROR THEN
258: --
259: ROLLBACK TO Export_CountRequest_PVT;
260: --
261: x_return_status := FND_API.G_RET_STS_ERROR;

Line 261: x_return_status := FND_API.G_RET_STS_ERROR;

257: WHEN FND_API.G_EXC_ERROR THEN
258: --
259: ROLLBACK TO Export_CountRequest_PVT;
260: --
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: --
263: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
264: , p_data => x_msg_data);
265: --

Line 266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

262: --
263: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
264: , p_data => x_msg_data);
265: --
266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
267: --
268: ROLLBACK TO Export_CountRequest_PVT;
269: --
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
267: --
268: ROLLBACK TO Export_CountRequest_PVT;
269: --
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
271: --
272: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
273: , p_data => x_msg_data);
274: --

Line 279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

275: WHEN OTHERS THEN
276: --
277: ROLLBACK TO Export_CountRequest_PVT;
278: --
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: --
281: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
282: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
283: END IF;

Line 296: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

292: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
293: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
294: PROCEDURE Create_CountRequest(
295: p_api_version IN NUMBER ,
296: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
297: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
298: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
299: x_return_status OUT NOCOPY VARCHAR2 ,
300: x_msg_count OUT NOCOPY NUMBER ,

Line 297: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

293: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
294: PROCEDURE Create_CountRequest(
295: p_api_version IN NUMBER ,
296: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
297: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
298: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
299: x_return_status OUT NOCOPY VARCHAR2 ,
300: x_msg_count OUT NOCOPY NUMBER ,
301: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 298: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

294: PROCEDURE Create_CountRequest(
295: p_api_version IN NUMBER ,
296: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
297: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
298: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
299: x_return_status OUT NOCOPY VARCHAR2 ,
300: x_msg_count OUT NOCOPY NUMBER ,
301: x_msg_data OUT NOCOPY VARCHAR2 ,
302: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 302: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE,

298: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
299: x_return_status OUT NOCOPY VARCHAR2 ,
300: x_msg_count OUT NOCOPY NUMBER ,
301: x_msg_data OUT NOCOPY VARCHAR2 ,
302: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE,
303: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
304: IS
305: L_api_version CONSTANT NUMBER := 0.9;
306: L_api_name CONSTANT VARCHAR2(30) := 'Create_CountRequest';

Line 323: -- DEFAULT = FND_API.G_FALSE,

319: -- p_api_version IN NUMBER (required)
320: -- API Version of this procedure
321: --
322: -- p_init_msg_l IN VARCHAR2 (optional)
323: -- DEFAULT = FND_API.G_FALSE,
324: --
325: -- p_commit IN VARCHAR2 (optional)
326: -- DEFAULT = FND_API.G_FALSE
327: --

Line 326: -- DEFAULT = FND_API.G_FALSE

322: -- p_init_msg_l IN VARCHAR2 (optional)
323: -- DEFAULT = FND_API.G_FALSE,
324: --
325: -- p_commit IN VARCHAR2 (optional)
326: -- DEFAULT = FND_API.G_FALSE
327: --
328: -- p_validation_level IN NUMBER (optional)
329: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
330: -- currently unused

Line 329: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL

325: -- p_commit IN VARCHAR2 (optional)
326: -- DEFAULT = FND_API.G_FALSE
327: --
328: -- p_validation_level IN NUMBER (optional)
329: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
330: -- currently unused
331: --
332: -- p_simulate IN VARCHAR2 (optional)
333: -- determines whether to do do actual processing or just simulate it

Line 334: -- DEFAULT = FND_API.G_FALSE

330: -- currently unused
331: --
332: -- p_simulate IN VARCHAR2 (optional)
333: -- determines whether to do do actual processing or just simulate it
334: -- DEFAULT = FND_API.G_FALSE
335: -- create record in mtl_cycle_count_entries
336: -- FND_API.G_TRUE
337: -- do not insert records into mtl_cycle_count_entries
338: --

Line 336: -- FND_API.G_TRUE

332: -- p_simulate IN VARCHAR2 (optional)
333: -- determines whether to do do actual processing or just simulate it
334: -- DEFAULT = FND_API.G_FALSE
335: -- create record in mtl_cycle_count_entries
336: -- FND_API.G_TRUE
337: -- do not insert records into mtl_cycle_count_entries
338: --
339: --
340: -- p_interface_rec MTL_CC_ENTRIES_INTERFACE%ROWTYPE (required)

Line 368: IF NOT FND_API.Compatible_API_Call(l_api_version

364: -- Standard start of API savepoint
365: SAVEPOINT Create_CountRequest;
366: --
367: -- Standard Call to check for call compatibility
368: IF NOT FND_API.Compatible_API_Call(l_api_version
369: , p_api_version
370: , l_api_name
371: , G_PKG_NAME) THEN
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

368: IF NOT FND_API.Compatible_API_Call(l_api_version
369: , p_api_version
370: , l_api_name
371: , G_PKG_NAME) THEN
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END IF;
374: --
375: -- Initialize message list if p_init_msg_list is set to true
376: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 376: IF FND_API.to_Boolean(p_init_msg_list) THEN

372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END IF;
374: --
375: -- Initialize message list if p_init_msg_list is set to true
376: IF FND_API.to_Boolean(p_init_msg_list) THEN
377: FND_MSG_PUB.initialize;
378: END IF;
379: --
380: -- Initialisize API return status to access

Line 381: x_return_status := FND_API.G_RET_STS_SUCCESS;

377: FND_MSG_PUB.initialize;
378: END IF;
379: --
380: -- Initialisize API return status to access
381: x_return_status := FND_API.G_RET_STS_SUCCESS;
382: --
383: -- API body
384: --
385:

Line 403: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

399: , x_msg_data => x_msg_data
400: , p_interface_rec => p_interface_rec
401: );
402:
403: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
404:
405: --
406: IF (l_debug = 1) THEN
407: MDEBUG( 'Process: Begin Unsch? '||to_char(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.UNSCHEDULED_COUNT_ENTRY));

Line 426: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

422: p_flags => '1$2$',
423: x_return_status => x_return_status,
424: x_msg_count => x_msg_count,
425: x_msg_data => x_msg_data);
426: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: END IF;
429:
430: x_return_status := FND_API.G_RET_STS_ERROR;

Line 427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

423: x_return_status => x_return_status,
424: x_msg_count => x_msg_count,
425: x_msg_data => x_msg_data);
426: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: END IF;
429:
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: RAISE FND_API.G_EXC_ERROR;

Line 430: x_return_status := FND_API.G_RET_STS_ERROR;

426: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: END IF;
429:
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: RAISE FND_API.G_EXC_ERROR;
432: --
433: -- Validation ok AND OPEN request exists
434: ELSIF MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST = TRUE THEN

Line 431: RAISE FND_API.G_EXC_ERROR;

427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: END IF;
429:
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: RAISE FND_API.G_EXC_ERROR;
432: --
433: -- Validation ok AND OPEN request exists
434: ELSIF MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST = TRUE THEN
435: --

Line 450: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

446: p_flags => '1$2$',
447: x_return_status => x_return_status,
448: x_msg_count => x_msg_count,
449: x_msg_data => x_msg_data);
450: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
452: END IF;
453:
454: x_return_status := FND_API.G_RET_STS_ERROR;

Line 451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

447: x_return_status => x_return_status,
448: x_msg_count => x_msg_count,
449: x_msg_data => x_msg_data);
450: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
452: END IF;
453:
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: --

Line 454: x_return_status := FND_API.G_RET_STS_ERROR;

450: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
452: END IF;
453:
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: --
456: -- all ok. It IS an unscheduled entry, AND the information IS correct
457: ELSE
458: IF (l_debug = 1) THEN

Line 466: IF (p_simulate = FND_API.G_FALSE) THEN

462: -- set unscheduled count type code
463: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.COUNT_TYPE_CODE := 2;
464:
465: -- create count request if not in simulation mode
466: IF (p_simulate = FND_API.G_FALSE) THEN
467:
468:
469: -- insert count request into mtl_cycle_count_entries
470: MTL_CCEOI_PROCESS_PVT.Insert_CCEntry(

Line 500: if (x_return_status <> fnd_api.g_ret_sts_success) then

496: -- from that point no SKU changes can be made
497: MTL_CCEOI_PROCESS_PVT.Update_CCIEntry(l_interface_rec,
498: x_return_status);
499:
500: if (x_return_status <> fnd_api.g_ret_sts_success) then
501: raise fnd_api.g_exc_unexpected_error;
502: end if;
503:
504: IF (l_debug = 1) THEN

Line 501: raise fnd_api.g_exc_unexpected_error;

497: MTL_CCEOI_PROCESS_PVT.Update_CCIEntry(l_interface_rec,
498: x_return_status);
499:
500: if (x_return_status <> fnd_api.g_ret_sts_success) then
501: raise fnd_api.g_exc_unexpected_error;
502: end if;
503:
504: IF (l_debug = 1) THEN
505: mdebug('updating ccei_id='||l_interface_rec.cc_entry_interface_id||' with cce_id='|| l_cycle_count_entry_id);

Line 528: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

524: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,
525: p_flags => '2$0$');
526: -- the flag means no errors, successful processed
527: END IF; -- if record is in system
528: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530: END IF;
531:
532: IF (l_debug = 1) THEN

Line 529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

525: p_flags => '2$0$');
526: -- the flag means no errors, successful processed
527: END IF; -- if record is in system
528: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530: END IF;
531:
532: IF (l_debug = 1) THEN
533: MDEBUG( 'Process: End of Unsch ');

Line 541: IF FND_API.to_Boolean(p_commit) THEN

537:
538: --
539: -- END of API body
540: -- Standard check of p_commit
541: IF FND_API.to_Boolean(p_commit) THEN
542: COMMIT;
543: END IF;
544: -- Standard call to get message count and if count is 1, get message info
545: FND_MSG_PUB.Count_And_Get

Line 550: WHEN FND_API.G_EXC_ERROR THEN

546: (p_count => x_msg_count
547: , p_data => x_msg_data);
548:
549: EXCEPTION
550: WHEN FND_API.G_EXC_ERROR THEN
551: --
552: ROLLBACK TO Create_CountRequest;
553: --
554: x_return_status := FND_API.G_RET_STS_ERROR;

Line 554: x_return_status := FND_API.G_RET_STS_ERROR;

550: WHEN FND_API.G_EXC_ERROR THEN
551: --
552: ROLLBACK TO Create_CountRequest;
553: --
554: x_return_status := FND_API.G_RET_STS_ERROR;
555: --
556: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
557: , p_data => x_msg_data);
558: --

Line 559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

555: --
556: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
557: , p_data => x_msg_data);
558: --
559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560: --
561: ROLLBACK TO Create_CountRequest;
562: --
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560: --
561: ROLLBACK TO Create_CountRequest;
562: --
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: --
565: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
566: , p_data => x_msg_data);
567: --

Line 572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

568: WHEN OTHERS THEN
569: --
570: ROLLBACK TO Create_CountRequest;
571: --
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
573: --
574: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
575: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
576: END IF;

Line 592: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

588: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
589: PROCEDURE Process_CountRequest
590: (
591: p_api_version IN NUMBER ,
592: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
593: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
594: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
595: x_return_status OUT NOCOPY VARCHAR2 ,
596: x_msg_count OUT NOCOPY NUMBER ,

Line 593: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

589: PROCEDURE Process_CountRequest
590: (
591: p_api_version IN NUMBER ,
592: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
593: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
594: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
595: x_return_status OUT NOCOPY VARCHAR2 ,
596: x_msg_count OUT NOCOPY NUMBER ,
597: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 594: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

590: (
591: p_api_version IN NUMBER ,
592: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
593: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
594: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
595: x_return_status OUT NOCOPY VARCHAR2 ,
596: x_msg_count OUT NOCOPY NUMBER ,
597: x_msg_data OUT NOCOPY VARCHAR2 ,
598: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 598: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE,

594: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
595: x_return_status OUT NOCOPY VARCHAR2 ,
596: x_msg_count OUT NOCOPY NUMBER ,
597: x_msg_data OUT NOCOPY VARCHAR2 ,
598: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE,
599: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
600: IS
601: L_error_code NUMBER;
602: --

Line 620: -- DEFAULT = FND_API.G_FALSE,

616: -- p_api_version IN NUMBER (required)
617: -- API Version of this procedure
618: --
619: -- p_init_msg_list IN VARCHAR2 (optional)
620: -- DEFAULT = FND_API.G_FALSE,
621: --
622: -- p_commit IN VARCHAR2 (optional)
623: -- DEFAULT = FND_API.G_FALSE
624: --

Line 623: -- DEFAULT = FND_API.G_FALSE

619: -- p_init_msg_list IN VARCHAR2 (optional)
620: -- DEFAULT = FND_API.G_FALSE,
621: --
622: -- p_commit IN VARCHAR2 (optional)
623: -- DEFAULT = FND_API.G_FALSE
624: --
625: -- p_validation_level IN NUMBER (optional)
626: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
627: -- currently unused

Line 626: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL

622: -- p_commit IN VARCHAR2 (optional)
623: -- DEFAULT = FND_API.G_FALSE
624: --
625: -- p_validation_level IN NUMBER (optional)
626: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
627: -- currently unused
628: --
629: -- p_simulate IN VARCHAR2 (optional)
630: -- determines whether to do do actual processing or just simulate it

Line 631: -- DEFAULT = FND_API.G_FALSE

627: -- currently unused
628: --
629: -- p_simulate IN VARCHAR2 (optional)
630: -- determines whether to do do actual processing or just simulate it
631: -- DEFAULT = FND_API.G_FALSE
632: -- - update processed info in mtl_cycle_count_entries (and any
633: -- other table necessary)
634: -- FND_API.G_TRUE
635: -- - do not insert record into mtl_cycle_count_entries

Line 634: -- FND_API.G_TRUE

630: -- determines whether to do do actual processing or just simulate it
631: -- DEFAULT = FND_API.G_FALSE
632: -- - update processed info in mtl_cycle_count_entries (and any
633: -- other table necessary)
634: -- FND_API.G_TRUE
635: -- - do not insert record into mtl_cycle_count_entries
636: --
637: -- OUT :
638: -- X_return_status OUT NUMBER

Line 657: IF NOT FND_API.Compatible_API_Call(l_api_version

653: -- Standard start of API savepoint
654: SAVEPOINT Process_CountRequest;
655: --
656: -- Standard Call to check for call compatibility
657: IF NOT FND_API.Compatible_API_Call(l_api_version
658: , p_api_version
659: , l_api_name
660: , G_PKG_NAME) THEN
661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

657: IF NOT FND_API.Compatible_API_Call(l_api_version
658: , p_api_version
659: , l_api_name
660: , G_PKG_NAME) THEN
661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
662: END IF;
663: --
664: -- Initialize message list if p_init_msg_list is set to true
665: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 665: IF FND_API.to_Boolean(p_init_msg_list) THEN

661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
662: END IF;
663: --
664: -- Initialize message list if p_init_msg_list is set to true
665: IF FND_API.to_Boolean(p_init_msg_list) THEN
666: FND_MSG_PUB.initialize;
667: END IF;
668: --
669: -- Initialisize API return status to access

Line 670: x_return_status := FND_API.G_RET_STS_SUCCESS;

666: FND_MSG_PUB.initialize;
667: END IF;
668: --
669: -- Initialisize API return status to access
670: x_return_status := FND_API.G_RET_STS_SUCCESS;
671: --
672: -- API body
673: --
674:

Line 681: MDEBUG( 'Level number '||to_char(FND_API.G_VALID_LEVEL_FULL));

677: END IF;
678:
679: IF (l_debug = 1) THEN
680: MDEBUG( 'Count Qty '||to_char(p_interface_rec.count_quantity));
681: MDEBUG( 'Level number '||to_char(FND_API.G_VALID_LEVEL_FULL));
682: END IF;
683:
684: IF (l_debug = 1) THEN
685: MDEBUG( 'Process: Delete all errors ');

Line 703: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

699: , p_validation_level => 1 -- Validate for processing
700: , p_interface_rec => p_interface_rec
701: );
702:
703: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
704: IF MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST = FALSE
705: AND MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.UNSCHEDULED_COUNT_ENTRY=2
706: THEN
707: IF (l_debug = 1) THEN

Line 720: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

716: p_flags => '1$2$',
717: x_return_status => x_return_status,
718: x_msg_count => x_msg_count,
719: x_msg_data => x_msg_data);
720: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723: RAISE FND_API.G_EXC_ERROR;
724:

Line 721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

717: x_return_status => x_return_status,
718: x_msg_count => x_msg_count,
719: x_msg_data => x_msg_data);
720: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723: RAISE FND_API.G_EXC_ERROR;
724:
725: ELSIF MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST = FALSE AND

Line 723: RAISE FND_API.G_EXC_ERROR;

719: x_msg_data => x_msg_data);
720: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723: RAISE FND_API.G_EXC_ERROR;
724:
725: ELSIF MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST = FALSE AND
726: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.UNSCHEDULED_COUNT_ENTRY=1
727: THEN

Line 744: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

740:
741: --
742: END IF;
743:
744: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
745:
746: -- process the data
747: MTL_CCEOI_PROCESS_PVT.Process_Data
748: (p_api_version => 0.9

Line 760: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

756: IF (l_debug = 1) THEN
757: MDEBUG('Process : After process Data '||x_return_status);
758: END IF;
759:
760: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
761:
762: -- count errors (left over from previous code which
763: -- had to count errors even in successful case because
764: -- of poor error handling that would lose error status

Line 785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

781: IF (l_err_count <> 0) THEN
782: IF (l_debug = 1) THEN
783: mdebug('Return status success while there are errors in the table');
784: END IF;
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: /*
787: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
788: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
789: p_api_version => 0.9,

Line 799: x_return_status := FND_API.G_RET_STS_ERROR;

795: p_flags => '1$22');
796:
797: END IF;
798:
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: */
801: ELSE
802: IF MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.ENTRY_STATUS_CODE = 3
803: THEN

Line 831: IF (p_simulate = FND_API.G_FALSE) THEN

827: END IF;
828:
829: END IF;
830:
831: IF (p_simulate = FND_API.G_FALSE) THEN
832:
833: -- XXX this is leftover from previous poor error
834: -- processing. This line should go
835: IF MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID is NULL THEN

Line 836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

832:
833: -- XXX this is leftover from previous poor error
834: -- processing. This line should go
835: IF MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID is NULL THEN
836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
837: END IF;
838:
839: MTL_CCEOI_PROCESS_PVT.Update_CCEntry(
840: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID);

Line 860: RAISE FND_API.G_EXC_ERROR;

856: x_return_status => x_return_status,
857: x_msg_count => x_msg_count,
858: x_msg_data => x_msg_data);
859:
860: RAISE FND_API.G_EXC_ERROR;
861: ELSE
862: -- XXX this is clearly a strange message
863: Process_Error(
864: p_api_version => 0.9,

Line 874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

870: x_return_status => x_return_status,
871: x_msg_count => x_msg_count,
872: x_msg_data => x_msg_data);
873:
874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
875: END IF; -- error_code of unsuccessful process_data
876: END IF; -- process_data return status
877:
878: END IF; -- x_return_status = true/create's return status

Line 885: IF FND_API.to_Boolean(p_commit) THEN

881:
882: --
883: -- END of API body
884: -- Standard check of p_commit
885: IF FND_API.to_Boolean(p_commit) THEN
886: COMMIT;
887: END IF;
888: -- Standard call to get message count and if count is 1, get message info
889: FND_MSG_PUB.Count_And_Get

Line 894: WHEN FND_API.G_EXC_ERROR THEN

890: (p_count => x_msg_count
891: , p_data => x_msg_data);
892:
893: EXCEPTION
894: WHEN FND_API.G_EXC_ERROR THEN
895: --
896: x_return_status := FND_API.G_RET_STS_ERROR;
897: --
898: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 896: x_return_status := FND_API.G_RET_STS_ERROR;

892:
893: EXCEPTION
894: WHEN FND_API.G_EXC_ERROR THEN
895: --
896: x_return_status := FND_API.G_RET_STS_ERROR;
897: --
898: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
899: , p_data => x_msg_data);
900: --

Line 905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

901: IF (l_debug = 1) THEN
902: MDEBUG('Process : Exc Err' || sqlerrm);
903: END IF;
904:
905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
906: --
907: --
908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909: --

Line 908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

904:
905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
906: --
907: --
908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909: --
910: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
911: , p_data => x_msg_data);
912: --

Line 919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

915: END IF;
916:
917: WHEN OTHERS THEN
918: --
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: --
921: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
922: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
923: END IF;

Line 938: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

934: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
935: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
936: PROCEDURE Validate_CountRequest(
937: p_api_version IN NUMBER ,
938: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
939: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
940: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_NONE,
941: x_return_status OUT NOCOPY VARCHAR2 ,
942: x_msg_count OUT NOCOPY NUMBER ,

Line 939: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

935: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
936: PROCEDURE Validate_CountRequest(
937: p_api_version IN NUMBER ,
938: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
939: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
940: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_NONE,
941: x_return_status OUT NOCOPY VARCHAR2 ,
942: x_msg_count OUT NOCOPY NUMBER ,
943: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 940: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_NONE,

936: PROCEDURE Validate_CountRequest(
937: p_api_version IN NUMBER ,
938: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
939: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
940: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_NONE,
941: x_return_status OUT NOCOPY VARCHAR2 ,
942: x_msg_count OUT NOCOPY NUMBER ,
943: x_msg_data OUT NOCOPY VARCHAR2 ,
944: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )

Line 961: -- DEFAULT = FND_API.G_FALSE,

957: -- p_api_version IN NUMBER (required)
958: -- API Version of this procedure
959: --
960: -- p_init_msg_list IN VARCHAR2 (optional)
961: -- DEFAULT = FND_API.G_FALSE,
962: --
963: -- p_commit IN VARCHAR2 (optional)
964: -- DEFAULT = FND_API.G_FALSE
965: --

Line 964: -- DEFAULT = FND_API.G_FALSE

960: -- p_init_msg_list IN VARCHAR2 (optional)
961: -- DEFAULT = FND_API.G_FALSE,
962: --
963: -- p_commit IN VARCHAR2 (optional)
964: -- DEFAULT = FND_API.G_FALSE
965: --
966: -- p_validation_level IN NUMBER DEFAULT 0 (optional- defaulted)
967: -- 0 = FND_API.G_VALID_LEVEL_NONE (no processing),
968: -- 1 = Validate FOR processing

Line 967: -- 0 = FND_API.G_VALID_LEVEL_NONE (no processing),

963: -- p_commit IN VARCHAR2 (optional)
964: -- DEFAULT = FND_API.G_FALSE
965: --
966: -- p_validation_level IN NUMBER DEFAULT 0 (optional- defaulted)
967: -- 0 = FND_API.G_VALID_LEVEL_NONE (no processing),
968: -- 1 = Validate FOR processing
969: --
970: --
971: -- p_interface_rec IN MTL_CC_ENTRIES_INTERFACE%ROWTYPE (required)

Line 1033: IF NOT FND_API.Compatible_API_Call(l_api_version

1029: -- Standard start of API savepoint
1030: SAVEPOINT Validate_CountRequest;
1031: --
1032: -- Standard Call to check for call compatibility
1033: IF NOT FND_API.Compatible_API_Call(l_api_version
1034: , p_api_version
1035: , l_api_name
1036: , G_PKG_NAME) THEN
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1033: IF NOT FND_API.Compatible_API_Call(l_api_version
1034: , p_api_version
1035: , l_api_name
1036: , G_PKG_NAME) THEN
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1038: END IF;
1039: --
1040: -- Initialize message list if p_init_msg_list is set to true
1041: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1041: IF FND_API.to_Boolean(p_init_msg_list) THEN

1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1038: END IF;
1039: --
1040: -- Initialize message list if p_init_msg_list is set to true
1041: IF FND_API.to_Boolean(p_init_msg_list) THEN
1042: FND_MSG_PUB.initialize;
1043: END IF;
1044: --
1045: -- Initialisize API return status to access

Line 1046: L_return_status := FND_API.G_RET_STS_SUCCESS;

1042: FND_MSG_PUB.initialize;
1043: END IF;
1044: --
1045: -- Initialisize API return status to access
1046: L_return_status := FND_API.G_RET_STS_SUCCESS;
1047: --
1048: -- API body
1049: --
1050:

Line 1054: l_simulate := fnd_api.g_true;

1050:
1051: -- determine whether this is a simulation run in which we
1052: -- shall not modify non-interface related tables
1053: if (p_interface_rec.action_code = mtl_cceoi_var_pvt.g_valsim) then
1054: l_simulate := fnd_api.g_true;
1055: else
1056: l_simulate := fnd_api.g_false;
1057: end if;
1058:

Line 1056: l_simulate := fnd_api.g_false;

1052: -- shall not modify non-interface related tables
1053: if (p_interface_rec.action_code = mtl_cceoi_var_pvt.g_valsim) then
1054: l_simulate := fnd_api.g_true;
1055: else
1056: l_simulate := fnd_api.g_false;
1057: end if;
1058:
1059: -- Delete all error records first
1060: MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(

Line 1071: RAISE FND_API.G_EXC_ERROR;

1067: IF p_interface_rec.cc_entry_interface_id IS NULL THEN
1068: L_errorcode := 21;
1069: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_NO_IFACE_ID');
1070: FND_MSG_PUB.Add;
1071: RAISE FND_API.G_EXC_ERROR;
1072: END IF;
1073:
1074: -- Current processed interface RECORD
1075: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID :=

Line 1102: IF L_errorcode <>0 AND L_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1098: );
1099: IF (l_debug = 1) THEN
1100: mdebug('Return CHeader='||L_return_status);
1101: END IF;
1102: IF L_errorcode <>0 AND L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1103: GOTO end_VALIDATE;
1104: IF (l_debug = 1) THEN
1105: mdebug('Cycle Count Header Error');
1106: END IF;

Line 1174: L_return_status := FND_API.G_RET_STS_SUCCESS ;

1170: update mtl_cycle_count_headers
1171: set next_user_count_sequence = MTL_CCEOI_VAR_PVT.G_Seq_No + 1
1172: where cycle_count_header_id = p_interface_rec.cycle_count_header_id;
1173: L_errorcode := 0;
1174: L_return_status := FND_API.G_RET_STS_SUCCESS ;
1175: exception
1176: when others then null;
1177: end;
1178: ELSIF L_errorcode = 66 then -- new count_list_sequence not found in CCE

Line 1180: L_return_status := FND_API.G_RET_STS_SUCCESS ;

1176: when others then null;
1177: end;
1178: ELSIF L_errorcode = 66 then -- new count_list_sequence not found in CCE
1179: L_errorcode := 0;
1180: L_return_status := FND_API.G_RET_STS_SUCCESS ;
1181: IF (l_debug = 1) THEN
1182: MDEBUG( 'Existing New Sequence ='||to_char(MTL_CCEOI_VAR_PVT.G_Seq_No));
1183: END IF;
1184: l_derivable_item_sku := FALSE;

Line 1190: IF L_errorcode <>0 AND L_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1186: IF (l_debug = 1) THEN
1187: MDEBUG( 'New Sequence ='||to_char(MTL_CCEOI_VAR_PVT.G_Seq_No));
1188: END IF;
1189: -- Else condition is introduced by suresh to errored out with correct status
1190: IF L_errorcode <>0 AND L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1191: IF (l_debug = 1) THEN
1192: mdebug('Error Sequence Count List');
1193: END IF;
1194: GOTO end_VALIDATE;

Line 1303: IF L_errorcode<>0 AND L_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1299: p_simulate => l_simulate
1300: -- p_organization_id => p_interface_rec.organization_id
1301: );
1302: --
1303: IF L_errorcode<>0 AND L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1304: IF (l_debug = 1) THEN
1305: MDEBUG( 'Error ItemSKU');
1306: END IF;
1307:

Line 1385: IF L_errorcode <>0 AND L_return_status <> FND_API.G_RET_STS_SUCCESS

1381: mdebug('UOMQunatity Error ='||to_char(L_errorcode));
1382: mdebug('Errortext ='||x_msg_data);
1383: END IF;
1384:
1385: IF L_errorcode <>0 AND L_return_status <> FND_API.G_RET_STS_SUCCESS
1386: THEN
1387: IF (l_debug = 1) THEN
1388: mdebug('Error UOM Quantity');
1389: END IF;

Line 1423: IF L_errorcode <>0 AND L_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1419: mdebug('Secondary UOM Quantity Error = '||to_char(L_errorcode));
1420: mdebug('Errortext = '||x_msg_data);
1421: END IF;
1422:
1423: IF L_errorcode <>0 AND L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1424: IF (l_debug = 1) THEN
1425: mdebug('Error Secondary UOM Quantity');
1426: END IF;
1427: GOTO end_VALIDATE;

Line 1461: l_return_status := FND_API.G_RET_STS_ERROR;

1457:
1458: FND_MESSAGE.SET_NAME('INV', 'INV_INT_REACODE');
1459: FND_MSG_PUB.Add;
1460:
1461: l_return_status := FND_API.G_RET_STS_ERROR;
1462:
1463: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
1464: P_CC_ENTRY_INTERFACE_ID => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
1465: , P_ERROR_COLUMN_NAME => 'TRANSACTION_REASON_ID'

Line 1493: IF L_errorcode <>0 AND L_return_status <> FND_API.G_RET_STS_SUCCESS

1489: p_employee_id => p_interface_rec.employee_id,
1490: p_employee_name => p_interface_rec.employee_full_name
1491: );
1492: --
1493: IF L_errorcode <>0 AND L_return_status <> FND_API.G_RET_STS_SUCCESS
1494: THEN
1495: IF (l_debug = 1) THEN
1496: MDEBUG( 'Error Count Date '||to_char(l_errorcode));
1497: END IF;

Line 1514: IF L_return_status = FND_API.G_RET_STS_SUCCESS

1510: END IF;
1511:
1512: --
1513: -- UPDATE the interface TABLE flags
1514: IF L_return_status = FND_API.G_RET_STS_SUCCESS
1515: AND p_validation_level=1 THEN
1516: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
1517: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
1518: p_api_version => 0.9,

Line 1530: L_return_status = FND_API.G_RET_STS_SUCCESS

1526: MDEBUG( 'Successfully Validated ');
1527: END IF;
1528: -- the flag means no errors, successful validated, valid
1529: ELSIF
1530: L_return_status = FND_API.G_RET_STS_SUCCESS
1531: AND p_validation_level=0 THEN
1532: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
1533: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
1534: p_api_version => 0.9,

Line 1574: IF FND_API.to_Boolean(p_commit) THEN

1570: END IF;
1571: --
1572: -- END of API body
1573: -- Standard check of p_commit
1574: IF FND_API.to_Boolean(p_commit) THEN
1575: COMMIT;
1576: END IF;
1577: -- Standard call to get message count and if count is 1, get message info
1578: FND_MSG_PUB.Count_And_Get

Line 1582: WHEN FND_API.G_EXC_ERROR THEN

1578: FND_MSG_PUB.Count_And_Get
1579: (p_count => x_msg_count
1580: , p_data => x_msg_data);
1581: EXCEPTION
1582: WHEN FND_API.G_EXC_ERROR THEN
1583: --
1584: --ROLLBACK TO Validate_CountRequest;
1585: --
1586: IF (l_debug = 1) THEN

Line 1589: x_return_status := FND_API.G_RET_STS_ERROR;

1585: --
1586: IF (l_debug = 1) THEN
1587: mdebug('Validate_CountRequest: Error' || sqlerrm);
1588: END IF;
1589: x_return_status := FND_API.G_RET_STS_ERROR;
1590: --
1591: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1592: , p_data => x_msg_data);
1593: --

Line 1594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1590: --
1591: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1592: , p_data => x_msg_data);
1593: --
1594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1595: --
1596: --ROLLBACK TO Validate_CountRequest;
1597: --
1598: IF (l_debug = 1) THEN

Line 1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1597: --
1598: IF (l_debug = 1) THEN
1599: mdebug('Validate_CountRequest: Error' || sqlerrm);
1600: END IF;
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: --
1603: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1604: , p_data => x_msg_data);
1605: --

Line 1610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1606: WHEN OTHERS THEN
1607: --
1608: --ROLLBACK TO Validate_CountRequest;
1609: --
1610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1611: --
1612: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1613: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1614: END IF;

Line 1626: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1622: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
1623: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
1624: Procedure ValSim_CountRequest(
1625: p_api_version IN NUMBER ,
1626: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1627: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1628: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1629: x_return_status OUT NOCOPY VARCHAR2 ,
1630: x_msg_count OUT NOCOPY NUMBER ,

Line 1627: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1623: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
1624: Procedure ValSim_CountRequest(
1625: p_api_version IN NUMBER ,
1626: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1627: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1628: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1629: x_return_status OUT NOCOPY VARCHAR2 ,
1630: x_msg_count OUT NOCOPY NUMBER ,
1631: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 1628: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

1624: Procedure ValSim_CountRequest(
1625: p_api_version IN NUMBER ,
1626: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1627: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1628: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1629: x_return_status OUT NOCOPY VARCHAR2 ,
1630: x_msg_count OUT NOCOPY NUMBER ,
1631: x_msg_data OUT NOCOPY VARCHAR2 ,
1632: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )

Line 1647: -- DEFAULT = FND_API.G_FALSE,

1643: -- p_api_version IN NUMBER (required)
1644: -- API Version of this procedure
1645: --
1646: -- p_init_msg_list IN VARCHAR2 (optional)
1647: -- DEFAULT = FND_API.G_FALSE,
1648: --
1649: -- p_commit IN VARCHAR2 (optional)
1650: -- DEFAULT = FND_API.G_FALSE
1651: --

Line 1650: -- DEFAULT = FND_API.G_FALSE

1646: -- p_init_msg_list IN VARCHAR2 (optional)
1647: -- DEFAULT = FND_API.G_FALSE,
1648: --
1649: -- p_commit IN VARCHAR2 (optional)
1650: -- DEFAULT = FND_API.G_FALSE
1651: --
1652: -- p_validation_level IN NUMBER (optional)
1653: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
1654: --

Line 1653: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,

1649: -- p_commit IN VARCHAR2 (optional)
1650: -- DEFAULT = FND_API.G_FALSE
1651: --
1652: -- p_validation_level IN NUMBER (optional)
1653: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
1654: --
1655: --
1656: -- OUT :
1657: -- X_return_status OUT NUMBER

Line 1680: IF NOT FND_API.Compatible_API_Call(l_api_version

1676: -- Standard start of API savepoint
1677: SAVEPOINT ValSim_CountRequest;
1678: --
1679: -- Standard Call to check for call compatibility
1680: IF NOT FND_API.Compatible_API_Call(l_api_version
1681: , p_api_version
1682: , l_api_name
1683: , G_PKG_NAME) THEN
1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1680: IF NOT FND_API.Compatible_API_Call(l_api_version
1681: , p_api_version
1682: , l_api_name
1683: , G_PKG_NAME) THEN
1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1685: END IF;
1686: --
1687: -- Initialize message list if p_init_msg_list is set to true
1688: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1688: IF FND_API.to_Boolean(p_init_msg_list) THEN

1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1685: END IF;
1686: --
1687: -- Initialize message list if p_init_msg_list is set to true
1688: IF FND_API.to_Boolean(p_init_msg_list) THEN
1689: FND_MSG_PUB.initialize;
1690: END IF;
1691: --
1692: -- Initialisize API return status to access

Line 1693: L_return_status := FND_API.G_RET_STS_SUCCESS;

1689: FND_MSG_PUB.initialize;
1690: END IF;
1691: --
1692: -- Initialisize API return status to access
1693: L_return_status := FND_API.G_RET_STS_SUCCESS;
1694: --
1695: -- API body
1696: --
1697: -- Delete all error records first

Line 1712: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1708: , x_msg_data => x_msg_data
1709: , p_interface_rec => p_interface_rec
1710: );
1711: --
1712: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1713: --
1714: -- If online mode insert interface record first
1715: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = FALSE THEN
1716: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(

Line 1748: IF FND_API.to_Boolean(p_commit) THEN

1744: x_return_status := L_return_status;
1745: --
1746: -- END of API body
1747: -- Standard check of p_commit
1748: IF FND_API.to_Boolean(p_commit) THEN
1749: COMMIT;
1750: END IF;
1751: -- Standard call to get message count and if count is 1, get message info
1752: FND_MSG_PUB.Count_And_Get

Line 1756: WHEN FND_API.G_EXC_ERROR THEN

1752: FND_MSG_PUB.Count_And_Get
1753: (p_count => x_msg_count
1754: , p_data => x_msg_data);
1755: EXCEPTION
1756: WHEN FND_API.G_EXC_ERROR THEN
1757: --
1758: ROLLBACK TO ValSim_CountRequest;
1759: --
1760: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1760: x_return_status := FND_API.G_RET_STS_ERROR;

1756: WHEN FND_API.G_EXC_ERROR THEN
1757: --
1758: ROLLBACK TO ValSim_CountRequest;
1759: --
1760: x_return_status := FND_API.G_RET_STS_ERROR;
1761: --
1762: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1763: , p_data => x_msg_data);
1764: --

Line 1765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1761: --
1762: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1763: , p_data => x_msg_data);
1764: --
1765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1766: --
1767: ROLLBACK TO ValSim_CountRequest;
1768: --
1769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1766: --
1767: ROLLBACK TO ValSim_CountRequest;
1768: --
1769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1770: --
1771: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1772: , p_data => x_msg_data);
1773: --

Line 1778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1774: WHEN OTHERS THEN
1775: --
1776: ROLLBACK TO ValSim_CountRequest;
1777: --
1778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1779: --
1780: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1781: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1782: END IF;

Line 1794: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1790: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
1791: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
1792: PROCEDURE Update_Insert_CountRequest(
1793: p_api_version IN NUMBER ,
1794: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1795: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1796: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1797: x_return_status OUT NOCOPY VARCHAR2 ,
1798: x_msg_count OUT NOCOPY NUMBER ,

Line 1795: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1791: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
1792: PROCEDURE Update_Insert_CountRequest(
1793: p_api_version IN NUMBER ,
1794: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1795: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1796: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1797: x_return_status OUT NOCOPY VARCHAR2 ,
1798: x_msg_count OUT NOCOPY NUMBER ,
1799: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 1796: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

1792: PROCEDURE Update_Insert_CountRequest(
1793: p_api_version IN NUMBER ,
1794: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1795: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1796: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1797: x_return_status OUT NOCOPY VARCHAR2 ,
1798: x_msg_count OUT NOCOPY NUMBER ,
1799: x_msg_data OUT NOCOPY VARCHAR2 ,
1800: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )

Line 1818: -- DEFAULT = FND_API.G_FALSE,

1814: -- p_api_version IN NUMBER (required)
1815: -- API Version of this procedure
1816: --
1817: -- p_init_msg_l IN VARCHAR2 (optional)
1818: -- DEFAULT = FND_API.G_FALSE,
1819: --
1820: -- p_commit IN VARCHAR2 (optional)
1821: -- DEFAULT = FND_API.G_FALSE
1822: --

Line 1821: -- DEFAULT = FND_API.G_FALSE

1817: -- p_init_msg_l IN VARCHAR2 (optional)
1818: -- DEFAULT = FND_API.G_FALSE,
1819: --
1820: -- p_commit IN VARCHAR2 (optional)
1821: -- DEFAULT = FND_API.G_FALSE
1822: --
1823: -- p_validation_level IN NUMBER (optional)
1824: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
1825: --

Line 1824: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,

1820: -- p_commit IN VARCHAR2 (optional)
1821: -- DEFAULT = FND_API.G_FALSE
1822: --
1823: -- p_validation_level IN NUMBER (optional)
1824: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
1825: --
1826: -- p_interface_rec MTL_CC_ENTRIES_INTERFACE%ROWTYPE (required)
1827: -- the interface RECORD
1828: --

Line 1857: IF NOT FND_API.Compatible_API_Call(l_api_version

1853: -- Standard start of API savepoint
1854: SAVEPOINT UpdateInsert_CountRequest;
1855: --
1856: -- Standard Call to check for call compatibility
1857: IF NOT FND_API.Compatible_API_Call(l_api_version
1858: , p_api_version
1859: , l_api_name
1860: , G_PKG_NAME) THEN
1861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1857: IF NOT FND_API.Compatible_API_Call(l_api_version
1858: , p_api_version
1859: , l_api_name
1860: , G_PKG_NAME) THEN
1861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1862: END IF;
1863: --
1864: -- Initialize message list if p_init_msg_list is set to true
1865: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1865: IF FND_API.to_Boolean(p_init_msg_list) THEN

1861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1862: END IF;
1863: --
1864: -- Initialize message list if p_init_msg_list is set to true
1865: IF FND_API.to_Boolean(p_init_msg_list) THEN
1866: FND_MSG_PUB.initialize;
1867: END IF;
1868: --
1869: -- Initialisize API return status to access

Line 1870: L_return_status := FND_API.G_RET_STS_SUCCESS;

1866: FND_MSG_PUB.initialize;
1867: END IF;
1868: --
1869: -- Initialisize API return status to access
1870: L_return_status := FND_API.G_RET_STS_SUCCESS;
1871: --
1872: -- API body
1873: --
1874: -- If the validation error out, because the values

Line 1898: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1894: MTL_CCEOI_PROCESS_PVT.Update_CCIEntry(
1895: p_interface_rec => p_interface_rec
1896: , x_return_status => L_return_status);
1897: --
1898: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1899: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_UPDATE_FAILED');
1900: FND_MSG_PUB.Add;
1901: RAISE FND_API.G_EXC_ERROR;
1902: END IF;

Line 1901: RAISE FND_API.G_EXC_ERROR;

1897: --
1898: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1899: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_UPDATE_FAILED');
1900: FND_MSG_PUB.Add;
1901: RAISE FND_API.G_EXC_ERROR;
1902: END IF;
1903: --
1904: EXCEPTION
1905: WHEN NO_DATA_FOUND THEN

Line 1917: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1913: --
1914: IF (l_debug = 1) THEN
1915: Mdebug('After Insert_CCIEntry');
1916: END IF;
1917: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1918: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_INSERT_FAILED');
1919: FND_MSG_PUB.Add;
1920: RAISE FND_API.G_EXC_ERROR;
1921: END IF;

Line 1920: RAISE FND_API.G_EXC_ERROR;

1916: END IF;
1917: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1918: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_INSERT_FAILED');
1919: FND_MSG_PUB.Add;
1920: RAISE FND_API.G_EXC_ERROR;
1921: END IF;
1922: END;
1923: --
1924: x_return_status := L_return_status;

Line 1928: IF FND_API.to_Boolean(p_commit) THEN

1924: x_return_status := L_return_status;
1925: --
1926: -- END of API body
1927: -- Standard check of p_commit
1928: IF FND_API.to_Boolean(p_commit) THEN
1929: COMMIT;
1930: END IF;
1931: -- Standard call to get message count and if count is 1, get message info
1932: FND_MSG_PUB.Count_And_Get

Line 1935: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN

1931: -- Standard call to get message count and if count is 1, get message info
1932: FND_MSG_PUB.Count_And_Get
1933: (p_count => x_msg_count
1934: , p_data => x_msg_data);
1935: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN
1936: --
1937: x_return_status := FND_API.G_RET_STS_ERROR;
1938: --
1939: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 1937: x_return_status := FND_API.G_RET_STS_ERROR;

1933: (p_count => x_msg_count
1934: , p_data => x_msg_data);
1935: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN
1936: --
1937: x_return_status := FND_API.G_RET_STS_ERROR;
1938: --
1939: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1940: , p_data => x_msg_data);
1941: --

Line 1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1938: --
1939: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1940: , p_data => x_msg_data);
1941: --
1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1943: --
1944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1945: --
1946: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 1944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1940: , p_data => x_msg_data);
1941: --
1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1943: --
1944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1945: --
1946: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1947: , p_data => x_msg_data);
1948: --

Line 1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1947: , p_data => x_msg_data);
1948: --
1949: WHEN OTHERS THEN
1950: --
1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1952: --
1953: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1954: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1955: END IF;