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 1030: IF NOT FND_API.Compatible_API_Call(l_api_version

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

Line 1034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1038: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 1043: L_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1051: l_simulate := fnd_api.g_true;

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

Line 1053: l_simulate := fnd_api.g_false;

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

Line 1068: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 1171: L_return_status := FND_API.G_RET_STS_SUCCESS ;

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

Line 1177: L_return_status := FND_API.G_RET_STS_SUCCESS ;

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

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

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

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

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

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

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

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

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

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

1440: p_employee_id => p_interface_rec.employee_id,
1441: p_employee_name => p_interface_rec.employee_full_name
1442: );
1443: --
1444: IF L_errorcode <>0 AND L_return_status <> FND_API.G_RET_STS_SUCCESS
1445: THEN
1446: IF (l_debug = 1) THEN
1447: MDEBUG( 'Error Count Date '||to_char(l_errorcode));
1448: END IF;

Line 1465: IF L_return_status = FND_API.G_RET_STS_SUCCESS

1461: END IF;
1462:
1463: --
1464: -- UPDATE the interface TABLE flags
1465: IF L_return_status = FND_API.G_RET_STS_SUCCESS
1466: AND p_validation_level=1 THEN
1467: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
1468: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
1469: p_api_version => 0.9,

Line 1481: L_return_status = FND_API.G_RET_STS_SUCCESS

1477: MDEBUG( 'Successfully Validated ');
1478: END IF;
1479: -- the flag means no errors, successful validated, valid
1480: ELSIF
1481: L_return_status = FND_API.G_RET_STS_SUCCESS
1482: AND p_validation_level=0 THEN
1483: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
1484: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
1485: p_api_version => 0.9,

Line 1525: IF FND_API.to_Boolean(p_commit) THEN

1521: END IF;
1522: --
1523: -- END of API body
1524: -- Standard check of p_commit
1525: IF FND_API.to_Boolean(p_commit) THEN
1526: COMMIT;
1527: END IF;
1528: -- Standard call to get message count and if count is 1, get message info
1529: FND_MSG_PUB.Count_And_Get

Line 1533: WHEN FND_API.G_EXC_ERROR THEN

1529: FND_MSG_PUB.Count_And_Get
1530: (p_count => x_msg_count
1531: , p_data => x_msg_data);
1532: EXCEPTION
1533: WHEN FND_API.G_EXC_ERROR THEN
1534: --
1535: --ROLLBACK TO Validate_CountRequest;
1536: --
1537: IF (l_debug = 1) THEN

Line 1540: x_return_status := FND_API.G_RET_STS_ERROR;

1536: --
1537: IF (l_debug = 1) THEN
1538: mdebug('Validate_CountRequest: Error' || sqlerrm);
1539: END IF;
1540: x_return_status := FND_API.G_RET_STS_ERROR;
1541: --
1542: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1543: , p_data => x_msg_data);
1544: --

Line 1545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1541: --
1542: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1543: , p_data => x_msg_data);
1544: --
1545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1546: --
1547: --ROLLBACK TO Validate_CountRequest;
1548: --
1549: IF (l_debug = 1) THEN

Line 1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1548: --
1549: IF (l_debug = 1) THEN
1550: mdebug('Validate_CountRequest: Error' || sqlerrm);
1551: END IF;
1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1553: --
1554: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1555: , p_data => x_msg_data);
1556: --

Line 1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1557: WHEN OTHERS THEN
1558: --
1559: --ROLLBACK TO Validate_CountRequest;
1560: --
1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1562: --
1563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1564: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1565: END IF;

Line 1577: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1573: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
1574: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
1575: Procedure ValSim_CountRequest(
1576: p_api_version IN NUMBER ,
1577: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1578: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1579: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1580: x_return_status OUT NOCOPY VARCHAR2 ,
1581: x_msg_count OUT NOCOPY NUMBER ,

Line 1578: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1574: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
1575: Procedure ValSim_CountRequest(
1576: p_api_version IN NUMBER ,
1577: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1578: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1579: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1580: x_return_status OUT NOCOPY VARCHAR2 ,
1581: x_msg_count OUT NOCOPY NUMBER ,
1582: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 1579: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

1575: Procedure ValSim_CountRequest(
1576: p_api_version IN NUMBER ,
1577: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1578: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1579: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1580: x_return_status OUT NOCOPY VARCHAR2 ,
1581: x_msg_count OUT NOCOPY NUMBER ,
1582: x_msg_data OUT NOCOPY VARCHAR2 ,
1583: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )

Line 1598: -- DEFAULT = FND_API.G_FALSE,

1594: -- p_api_version IN NUMBER (required)
1595: -- API Version of this procedure
1596: --
1597: -- p_init_msg_list IN VARCHAR2 (optional)
1598: -- DEFAULT = FND_API.G_FALSE,
1599: --
1600: -- p_commit IN VARCHAR2 (optional)
1601: -- DEFAULT = FND_API.G_FALSE
1602: --

Line 1601: -- DEFAULT = FND_API.G_FALSE

1597: -- p_init_msg_list IN VARCHAR2 (optional)
1598: -- DEFAULT = FND_API.G_FALSE,
1599: --
1600: -- p_commit IN VARCHAR2 (optional)
1601: -- DEFAULT = FND_API.G_FALSE
1602: --
1603: -- p_validation_level IN NUMBER (optional)
1604: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
1605: --

Line 1604: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,

1600: -- p_commit IN VARCHAR2 (optional)
1601: -- DEFAULT = FND_API.G_FALSE
1602: --
1603: -- p_validation_level IN NUMBER (optional)
1604: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
1605: --
1606: --
1607: -- OUT :
1608: -- X_return_status OUT NUMBER

Line 1631: IF NOT FND_API.Compatible_API_Call(l_api_version

1627: -- Standard start of API savepoint
1628: SAVEPOINT ValSim_CountRequest;
1629: --
1630: -- Standard Call to check for call compatibility
1631: IF NOT FND_API.Compatible_API_Call(l_api_version
1632: , p_api_version
1633: , l_api_name
1634: , G_PKG_NAME) THEN
1635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1631: IF NOT FND_API.Compatible_API_Call(l_api_version
1632: , p_api_version
1633: , l_api_name
1634: , G_PKG_NAME) THEN
1635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1636: END IF;
1637: --
1638: -- Initialize message list if p_init_msg_list is set to true
1639: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1639: IF FND_API.to_Boolean(p_init_msg_list) THEN

1635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1636: END IF;
1637: --
1638: -- Initialize message list if p_init_msg_list is set to true
1639: IF FND_API.to_Boolean(p_init_msg_list) THEN
1640: FND_MSG_PUB.initialize;
1641: END IF;
1642: --
1643: -- Initialisize API return status to access

Line 1644: L_return_status := FND_API.G_RET_STS_SUCCESS;

1640: FND_MSG_PUB.initialize;
1641: END IF;
1642: --
1643: -- Initialisize API return status to access
1644: L_return_status := FND_API.G_RET_STS_SUCCESS;
1645: --
1646: -- API body
1647: --
1648: -- Delete all error records first

Line 1663: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1659: , x_msg_data => x_msg_data
1660: , p_interface_rec => p_interface_rec
1661: );
1662: --
1663: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1664: --
1665: -- If online mode insert interface record first
1666: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = FALSE THEN
1667: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(

Line 1699: IF FND_API.to_Boolean(p_commit) THEN

1695: x_return_status := L_return_status;
1696: --
1697: -- END of API body
1698: -- Standard check of p_commit
1699: IF FND_API.to_Boolean(p_commit) THEN
1700: COMMIT;
1701: END IF;
1702: -- Standard call to get message count and if count is 1, get message info
1703: FND_MSG_PUB.Count_And_Get

Line 1707: WHEN FND_API.G_EXC_ERROR THEN

1703: FND_MSG_PUB.Count_And_Get
1704: (p_count => x_msg_count
1705: , p_data => x_msg_data);
1706: EXCEPTION
1707: WHEN FND_API.G_EXC_ERROR THEN
1708: --
1709: ROLLBACK TO ValSim_CountRequest;
1710: --
1711: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1711: x_return_status := FND_API.G_RET_STS_ERROR;

1707: WHEN FND_API.G_EXC_ERROR THEN
1708: --
1709: ROLLBACK TO ValSim_CountRequest;
1710: --
1711: x_return_status := FND_API.G_RET_STS_ERROR;
1712: --
1713: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1714: , p_data => x_msg_data);
1715: --

Line 1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1712: --
1713: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1714: , p_data => x_msg_data);
1715: --
1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1717: --
1718: ROLLBACK TO ValSim_CountRequest;
1719: --
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1717: --
1718: ROLLBACK TO ValSim_CountRequest;
1719: --
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1721: --
1722: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1723: , p_data => x_msg_data);
1724: --

Line 1729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1725: WHEN OTHERS THEN
1726: --
1727: ROLLBACK TO ValSim_CountRequest;
1728: --
1729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1730: --
1731: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1732: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1733: END IF;

Line 1745: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1741: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data OUT
1742: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
1743: PROCEDURE Update_Insert_CountRequest(
1744: p_api_version IN NUMBER ,
1745: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1746: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1747: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1748: x_return_status OUT NOCOPY VARCHAR2 ,
1749: x_msg_count OUT NOCOPY NUMBER ,

Line 1746: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1742: --parameters to comply with GSCC File.Sql.39 standard. Bug:4410902
1743: PROCEDURE Update_Insert_CountRequest(
1744: p_api_version IN NUMBER ,
1745: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1746: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1747: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1748: x_return_status OUT NOCOPY VARCHAR2 ,
1749: x_msg_count OUT NOCOPY NUMBER ,
1750: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 1747: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

1743: PROCEDURE Update_Insert_CountRequest(
1744: p_api_version IN NUMBER ,
1745: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1746: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1747: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1748: x_return_status OUT NOCOPY VARCHAR2 ,
1749: x_msg_count OUT NOCOPY NUMBER ,
1750: x_msg_data OUT NOCOPY VARCHAR2 ,
1751: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )

Line 1769: -- DEFAULT = FND_API.G_FALSE,

1765: -- p_api_version IN NUMBER (required)
1766: -- API Version of this procedure
1767: --
1768: -- p_init_msg_l IN VARCHAR2 (optional)
1769: -- DEFAULT = FND_API.G_FALSE,
1770: --
1771: -- p_commit IN VARCHAR2 (optional)
1772: -- DEFAULT = FND_API.G_FALSE
1773: --

Line 1772: -- DEFAULT = FND_API.G_FALSE

1768: -- p_init_msg_l IN VARCHAR2 (optional)
1769: -- DEFAULT = FND_API.G_FALSE,
1770: --
1771: -- p_commit IN VARCHAR2 (optional)
1772: -- DEFAULT = FND_API.G_FALSE
1773: --
1774: -- p_validation_level IN NUMBER (optional)
1775: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
1776: --

Line 1775: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,

1771: -- p_commit IN VARCHAR2 (optional)
1772: -- DEFAULT = FND_API.G_FALSE
1773: --
1774: -- p_validation_level IN NUMBER (optional)
1775: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
1776: --
1777: -- p_interface_rec MTL_CC_ENTRIES_INTERFACE%ROWTYPE (required)
1778: -- the interface RECORD
1779: --

Line 1808: IF NOT FND_API.Compatible_API_Call(l_api_version

1804: -- Standard start of API savepoint
1805: SAVEPOINT UpdateInsert_CountRequest;
1806: --
1807: -- Standard Call to check for call compatibility
1808: IF NOT FND_API.Compatible_API_Call(l_api_version
1809: , p_api_version
1810: , l_api_name
1811: , G_PKG_NAME) THEN
1812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1808: IF NOT FND_API.Compatible_API_Call(l_api_version
1809: , p_api_version
1810: , l_api_name
1811: , G_PKG_NAME) THEN
1812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1813: END IF;
1814: --
1815: -- Initialize message list if p_init_msg_list is set to true
1816: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1816: IF FND_API.to_Boolean(p_init_msg_list) THEN

1812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1813: END IF;
1814: --
1815: -- Initialize message list if p_init_msg_list is set to true
1816: IF FND_API.to_Boolean(p_init_msg_list) THEN
1817: FND_MSG_PUB.initialize;
1818: END IF;
1819: --
1820: -- Initialisize API return status to access

Line 1821: L_return_status := FND_API.G_RET_STS_SUCCESS;

1817: FND_MSG_PUB.initialize;
1818: END IF;
1819: --
1820: -- Initialisize API return status to access
1821: L_return_status := FND_API.G_RET_STS_SUCCESS;
1822: --
1823: -- API body
1824: --
1825: -- If the validation error out, because the values

Line 1849: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1845: MTL_CCEOI_PROCESS_PVT.Update_CCIEntry(
1846: p_interface_rec => p_interface_rec
1847: , x_return_status => L_return_status);
1848: --
1849: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1850: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_UPDATE_FAILED');
1851: FND_MSG_PUB.Add;
1852: RAISE FND_API.G_EXC_ERROR;
1853: END IF;

Line 1852: RAISE FND_API.G_EXC_ERROR;

1848: --
1849: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1850: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_UPDATE_FAILED');
1851: FND_MSG_PUB.Add;
1852: RAISE FND_API.G_EXC_ERROR;
1853: END IF;
1854: --
1855: EXCEPTION
1856: WHEN NO_DATA_FOUND THEN

Line 1868: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1864: --
1865: IF (l_debug = 1) THEN
1866: Mdebug('After Insert_CCIEntry');
1867: END IF;
1868: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1869: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_INSERT_FAILED');
1870: FND_MSG_PUB.Add;
1871: RAISE FND_API.G_EXC_ERROR;
1872: END IF;

Line 1871: RAISE FND_API.G_EXC_ERROR;

1867: END IF;
1868: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1869: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_INSERT_FAILED');
1870: FND_MSG_PUB.Add;
1871: RAISE FND_API.G_EXC_ERROR;
1872: END IF;
1873: END;
1874: --
1875: x_return_status := L_return_status;

Line 1879: IF FND_API.to_Boolean(p_commit) THEN

1875: x_return_status := L_return_status;
1876: --
1877: -- END of API body
1878: -- Standard check of p_commit
1879: IF FND_API.to_Boolean(p_commit) THEN
1880: COMMIT;
1881: END IF;
1882: -- Standard call to get message count and if count is 1, get message info
1883: FND_MSG_PUB.Count_And_Get

Line 1886: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN

1882: -- Standard call to get message count and if count is 1, get message info
1883: FND_MSG_PUB.Count_And_Get
1884: (p_count => x_msg_count
1885: , p_data => x_msg_data);
1886: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN
1887: --
1888: x_return_status := FND_API.G_RET_STS_ERROR;
1889: --
1890: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 1888: x_return_status := FND_API.G_RET_STS_ERROR;

1884: (p_count => x_msg_count
1885: , p_data => x_msg_data);
1886: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN
1887: --
1888: x_return_status := FND_API.G_RET_STS_ERROR;
1889: --
1890: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1891: , p_data => x_msg_data);
1892: --

Line 1893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1889: --
1890: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1891: , p_data => x_msg_data);
1892: --
1893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1894: --
1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1896: --
1897: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1891: , p_data => x_msg_data);
1892: --
1893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1894: --
1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1896: --
1897: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1898: , p_data => x_msg_data);
1899: --

Line 1902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1898: , p_data => x_msg_data);
1899: --
1900: WHEN OTHERS THEN
1901: --
1902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1903: --
1904: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1905: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1906: END IF;