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

Line 37: -- p_init_msg_list FND_API.G_TRUE to reset list

33: --===================
34: --========================================================================
35: -- PROCEDURE : Process_Transaction PUBLIC
36: -- PARAMETERS: p_api_version_number known api version
37: -- p_init_msg_list FND_API.G_TRUE to reset list
38: -- x_return_status return status
39: -- x_msg_count number of messages in the list
40: -- x_msg_data message text
41: -- p_legal_entity_id Legal Entity ID

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

50: --========================================================================
51:
52: PROCEDURE Process_Transaction
53: ( p_api_version_number IN NUMBER
54: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
55: , p_legal_entity_id IN NUMBER
56: , p_start_date IN DATE
57: , p_end_date IN DATE
58: , p_source_type IN VARCHAR2

Line 71: IF NOT FND_API.Compatible_API_Call

67:
68: BEGIN
69:
70: -- Standard call to check for call compatibility
71: IF NOT FND_API.Compatible_API_Call
72: ( l_api_version_number
73: , p_api_version_number
74: , L_API_NAME
75: , G_PKG_NAME

Line 78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

74: , L_API_NAME
75: , G_PKG_NAME
76: )
77: THEN
78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
79: END IF;
80:
81: -- Initialize message stack if required
82: IF FND_API.to_Boolean(p_init_msg_list)

Line 82: IF FND_API.to_Boolean(p_init_msg_list)

78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
79: END IF;
80:
81: -- Initialize message stack if required
82: IF FND_API.to_Boolean(p_init_msg_list)
83: THEN
84: FND_MSG_PUB.initialize;
85: END IF;
86:

Line 87: x_return_status := FND_API.G_RET_STS_SUCCESS;

83: THEN
84: FND_MSG_PUB.initialize;
85: END IF;
86:
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88:
89: -- Call the Private Process Transaction which does the logic for
90: -- Movement Statistics before inserting the record in the
91: -- Movement Statistics table.

Line 95: , p_init_msg_list => FND_API.G_FALSE

91: -- Movement Statistics table.
92:
93: INV_MGD_MVT_STATS_PROC.PROCESS_TRANSACTION
94: ( p_api_version_number => l_api_version_number
95: , p_init_msg_list => FND_API.G_FALSE
96: , p_legal_entity_id => p_legal_entity_id
97: , p_start_date => p_start_date
98: , p_end_date => p_end_date
99: , p_source_type => p_source_type

Line 105: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

101: , x_msg_count => x_msg_count
102: , x_msg_data => x_msg_data
103: );
104:
105: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
106: THEN
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
109: THEN

Line 107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

103: );
104:
105: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
106: THEN
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
109: THEN
110: RAISE FND_API.G_EXC_ERROR;
111: END IF;

Line 108: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

104:
105: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
106: THEN
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
109: THEN
110: RAISE FND_API.G_EXC_ERROR;
111: END IF;
112:

Line 110: RAISE FND_API.G_EXC_ERROR;

106: THEN
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
109: THEN
110: RAISE FND_API.G_EXC_ERROR;
111: END IF;
112:
113: EXCEPTION
114:

Line 115: WHEN FND_API.G_EXC_ERROR THEN

111: END IF;
112:
113: EXCEPTION
114:
115: WHEN FND_API.G_EXC_ERROR THEN
116: x_return_status := FND_API.G_RET_STS_ERROR;
117:
118: -- Get message count and data
119: FND_MSG_PUB.Count_And_Get

Line 116: x_return_status := FND_API.G_RET_STS_ERROR;

112:
113: EXCEPTION
114:
115: WHEN FND_API.G_EXC_ERROR THEN
116: x_return_status := FND_API.G_RET_STS_ERROR;
117:
118: -- Get message count and data
119: FND_MSG_PUB.Count_And_Get
120: ( p_count => x_msg_count

Line 123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

119: FND_MSG_PUB.Count_And_Get
120: ( p_count => x_msg_count
121: , p_data => x_msg_data
122: );
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
125:
126: -- Get message count and data
127: FND_MSG_PUB.Count_And_Get

Line 124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

120: ( p_count => x_msg_count
121: , p_data => x_msg_data
122: );
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
125:
126: -- Get message count and data
127: FND_MSG_PUB.Count_And_Get
128: ( p_count => x_msg_count

Line 132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

128: ( p_count => x_msg_count
129: , p_data => x_msg_data
130: );
131: WHEN OTHERS THEN
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)
135: THEN
136: FND_MSG_PUB.Add_Exc_Msg

Line 152: -- p_init_msg_list FND_API.G_TRUE to reset list

148:
149: --========================================================================
150: -- PROCEDURE : Create_Movement_Statistics PUBLIC
151: -- PARAMETERS: p_api_version_number known api version
152: -- p_init_msg_list FND_API.G_TRUE to reset list
153: -- x_return_status return status
154: -- x_msg_count number of messages in the list
155: -- x_msg_data message text
156: -- p_movement_transaction movement transaction data record

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

160: --=======================================================================
161:
162: PROCEDURE Create_Movement_Statistics
163: ( p_api_version_number IN NUMBER
164: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
165: , p_movement_transaction IN
166: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
167: , x_movement_transaction OUT
168: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type

Line 184: IF NOT FND_API.Compatible_API_Call

180:
181: BEGIN
182:
183: -- Standard call to check for call compatibility
184: IF NOT FND_API.Compatible_API_Call
185: ( l_api_version_number
186: , p_api_version_number
187: , L_API_NAME
188: , G_PKG_NAME

Line 191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

187: , L_API_NAME
188: , G_PKG_NAME
189: )
190: THEN
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: END IF;
193:
194: -- Initialize message stack if required
195: IF FND_API.to_Boolean(p_init_msg_list)

Line 195: IF FND_API.to_Boolean(p_init_msg_list)

191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: END IF;
193:
194: -- Initialize message stack if required
195: IF FND_API.to_Boolean(p_init_msg_list)
196: THEN
197: FND_MSG_PUB.initialize;
198: END IF;
199:

Line 200: x_return_status := FND_API.G_RET_STS_SUCCESS;

196: THEN
197: FND_MSG_PUB.initialize;
198: END IF;
199:
200: x_return_status := FND_API.G_RET_STS_SUCCESS;
201:
202: l_movement_transaction := p_movement_transaction;
203:
204: -- Call the Private package which does the insert in the

Line 209: , p_init_msg_list => FND_API.G_FALSE

205: -- Movement Statistics table.
206:
207: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
208: ( p_api_version_number => l_api_version_number
209: , p_init_msg_list => FND_API.G_FALSE
210: , x_movement_transaction => l_movement_transaction
211: , x_return_status => x_return_status
212: , x_msg_count => x_msg_count
213: , x_msg_data => x_msg_data

Line 218: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

214: );
215:
216: x_movement_transaction := l_movement_transaction;
217:
218: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
219: THEN
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
221: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
222: THEN

Line 220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

216: x_movement_transaction := l_movement_transaction;
217:
218: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
219: THEN
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
221: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
222: THEN
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;

Line 221: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

217:
218: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
219: THEN
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
221: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
222: THEN
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
225:

Line 223: RAISE FND_API.G_EXC_ERROR;

219: THEN
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
221: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
222: THEN
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
225:
226: EXCEPTION
227:

Line 228: WHEN FND_API.G_EXC_ERROR THEN

224: END IF;
225:
226: EXCEPTION
227:
228: WHEN FND_API.G_EXC_ERROR THEN
229: x_return_status := FND_API.G_RET_STS_ERROR;
230:
231: -- Get message count and data
232: FND_MSG_PUB.Count_And_Get

Line 229: x_return_status := FND_API.G_RET_STS_ERROR;

225:
226: EXCEPTION
227:
228: WHEN FND_API.G_EXC_ERROR THEN
229: x_return_status := FND_API.G_RET_STS_ERROR;
230:
231: -- Get message count and data
232: FND_MSG_PUB.Count_And_Get
233: ( p_count => x_msg_count

Line 236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

232: FND_MSG_PUB.Count_And_Get
233: ( p_count => x_msg_count
234: , p_data => x_msg_data
235: );
236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238:
239: -- Get message count and data
240: FND_MSG_PUB.Count_And_Get

Line 237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

233: ( p_count => x_msg_count
234: , p_data => x_msg_data
235: );
236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238:
239: -- Get message count and data
240: FND_MSG_PUB.Count_And_Get
241: ( p_count => x_msg_count

Line 245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

241: ( p_count => x_msg_count
242: , p_data => x_msg_data
243: );
244: WHEN OTHERS THEN
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246:
247: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
248: THEN
249: FND_MSG_PUB.Add_Exc_Msg

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

289: --=======================================================================--
290:
291: PROCEDURE Reset_Transaction_Status
292: ( p_api_version_number IN NUMBER
293: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
294: , p_legal_entity_id IN NUMBER
295: , p_zone_code IN VARCHAR2
296: , p_usage_type IN VARCHAR2
297: , p_stat_type IN VARCHAR2

Line 308: l_init_msg_list VARCHAR2(300) := FND_API.G_FALSE ;

304: )
305: IS
306:
307: l_api_version_number NUMBER := 1.0;
308: l_init_msg_list VARCHAR2(300) := FND_API.G_FALSE ;
309: l_api_name CONSTANT VARCHAR2(30) := 'Reset_Transaction_Status';
310: l_period_name VARCHAR2(15);
311: l_legal_entity_id NUMBER;
312: l_zone_code VARCHAR2(10);

Line 322: IF NOT FND_API.Compatible_API_Call

318:
319: BEGIN
320:
321: -- Standard call to check for call compatibility
322: IF NOT FND_API.Compatible_API_Call
323: ( l_api_version_number
324: , p_api_version_number
325: , L_API_NAME
326: , G_PKG_NAME

Line 329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

325: , L_API_NAME
326: , G_PKG_NAME
327: )
328: THEN
329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
330: END IF;
331:
332: -- Initialize message stack if required
333: IF FND_API.to_Boolean(p_init_msg_list)

Line 333: IF FND_API.to_Boolean(p_init_msg_list)

329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
330: END IF;
331:
332: -- Initialize message stack if required
333: IF FND_API.to_Boolean(p_init_msg_list)
334: THEN
335: FND_MSG_PUB.initialize;
336: END IF;
337:

Line 338: l_return_status := FND_API.G_RET_STS_SUCCESS;

334: THEN
335: FND_MSG_PUB.initialize;
336: END IF;
337:
338: l_return_status := FND_API.G_RET_STS_SUCCESS;
339:
340:
341: -- Assign the Local Variables
342:

Line 361: , p_init_msg_list => FND_API.G_FALSE

357: --
358:
359: INV_MGD_MVT_RESET_TRANS.Reset_Transaction_Status
360: ( p_api_version_number => l_api_version_number
361: , p_init_msg_list => FND_API.G_FALSE
362: , p_legal_entity_id => l_legal_entity_id
363: , p_zone_code => l_zone_code
364: , p_usage_type => l_stat_type
365: , p_stat_type => l_stat_type

Line 375: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

371: , x_msg_data => x_msg_data
372: );
373:
374:
375: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
376: THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
379: THEN

Line 377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

373:
374:
375: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
376: THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
379: THEN
380: RAISE FND_API.G_EXC_ERROR;
381: END IF;

Line 378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

374:
375: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
376: THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
379: THEN
380: RAISE FND_API.G_EXC_ERROR;
381: END IF;
382:

Line 380: RAISE FND_API.G_EXC_ERROR;

376: THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
379: THEN
380: RAISE FND_API.G_EXC_ERROR;
381: END IF;
382:
383: EXCEPTION
384:

Line 385: WHEN FND_API.G_EXC_ERROR THEN

381: END IF;
382:
383: EXCEPTION
384:
385: WHEN FND_API.G_EXC_ERROR THEN
386: x_return_status := FND_API.G_RET_STS_ERROR;
387:
388: -- Get message count and data
389: FND_MSG_PUB.Count_And_Get

Line 386: x_return_status := FND_API.G_RET_STS_ERROR;

382:
383: EXCEPTION
384:
385: WHEN FND_API.G_EXC_ERROR THEN
386: x_return_status := FND_API.G_RET_STS_ERROR;
387:
388: -- Get message count and data
389: FND_MSG_PUB.Count_And_Get
390: ( p_count => x_msg_count

Line 393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

389: FND_MSG_PUB.Count_And_Get
390: ( p_count => x_msg_count
391: , p_data => x_msg_data
392: );
393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395:
396: -- Get message count and data
397: FND_MSG_PUB.Count_And_Get

Line 394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

390: ( p_count => x_msg_count
391: , p_data => x_msg_data
392: );
393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395:
396: -- Get message count and data
397: FND_MSG_PUB.Count_And_Get
398: ( p_count => x_msg_count

Line 402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

398: ( p_count => x_msg_count
399: , p_data => x_msg_data
400: );
401: WHEN OTHERS THEN
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
403:
404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
405: THEN
406: FND_MSG_PUB.Add_Exc_Msg

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

437: --=======================================================================--
438:
439: PROCEDURE Purge_Movement_Transactions
440: ( p_api_version_number IN NUMBER
441: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
442: , p_legal_entity_id IN NUMBER
443: , p_zone_code IN VARCHAR2
444: , p_usage_type IN VARCHAR2
445: , p_stat_type IN VARCHAR2

Line 455: l_init_msg_list VARCHAR2(300) := FND_API.G_FALSE ;

451: )
452: IS
453:
454: l_api_version_number NUMBER := 1.0 ;
455: l_init_msg_list VARCHAR2(300) := FND_API.G_FALSE ;
456: l_api_name CONSTANT VARCHAR2(30) := 'Reset_Transaction_Status';
457: l_period_name VARCHAR2(15);
458: l_legal_entity_id NUMBER;
459: l_zone_code VARCHAR2(10);

Line 468: IF NOT FND_API.Compatible_API_Call

464:
465: BEGIN
466:
467: -- Standard call to check for call compatibility
468: IF NOT FND_API.Compatible_API_Call
469: ( l_api_version_number
470: , p_api_version_number
471: , L_API_NAME
472: , G_PKG_NAME

Line 475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

471: , L_API_NAME
472: , G_PKG_NAME
473: )
474: THEN
475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476: END IF;
477:
478: -- Initialize message stack if required
479: IF FND_API.to_Boolean(p_init_msg_list)

Line 479: IF FND_API.to_Boolean(p_init_msg_list)

475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476: END IF;
477:
478: -- Initialize message stack if required
479: IF FND_API.to_Boolean(p_init_msg_list)
480: THEN
481: FND_MSG_PUB.initialize;
482: END IF;
483:

Line 484: l_return_status := FND_API.G_RET_STS_SUCCESS;

480: THEN
481: FND_MSG_PUB.initialize;
482: END IF;
483:
484: l_return_status := FND_API.G_RET_STS_SUCCESS;
485:
486:
487: -- Assign the Local Variables
488:

Line 506: , p_init_msg_list => FND_API.G_FALSE

502: --
503:
504: INV_MGD_MVT_PURGE_TRANS.Purge_Movement_Transactions
505: ( p_api_version_number => l_api_version_number
506: , p_init_msg_list => FND_API.G_FALSE
507: , p_legal_entity_id => l_legal_entity_id
508: , p_zone_code => l_zone_code
509: , p_usage_type => l_stat_type
510: , p_stat_type => l_stat_type

Line 519: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

515: , x_msg_data => x_msg_data
516: );
517:
518:
519: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
520: THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
523: THEN

Line 521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

517:
518:
519: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
520: THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
523: THEN
524: RAISE FND_API.G_EXC_ERROR;
525: END IF;

Line 522: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

518:
519: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
520: THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
523: THEN
524: RAISE FND_API.G_EXC_ERROR;
525: END IF;
526:

Line 524: RAISE FND_API.G_EXC_ERROR;

520: THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
523: THEN
524: RAISE FND_API.G_EXC_ERROR;
525: END IF;
526:
527: EXCEPTION
528:

Line 529: WHEN FND_API.G_EXC_ERROR THEN

525: END IF;
526:
527: EXCEPTION
528:
529: WHEN FND_API.G_EXC_ERROR THEN
530: x_return_status := FND_API.G_RET_STS_ERROR;
531:
532: -- Get message count and data
533: FND_MSG_PUB.Count_And_Get

Line 530: x_return_status := FND_API.G_RET_STS_ERROR;

526:
527: EXCEPTION
528:
529: WHEN FND_API.G_EXC_ERROR THEN
530: x_return_status := FND_API.G_RET_STS_ERROR;
531:
532: -- Get message count and data
533: FND_MSG_PUB.Count_And_Get
534: ( p_count => x_msg_count

Line 537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

533: FND_MSG_PUB.Count_And_Get
534: ( p_count => x_msg_count
535: , p_data => x_msg_data
536: );
537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539:
540: -- Get message count and data
541: FND_MSG_PUB.Count_And_Get

Line 538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

534: ( p_count => x_msg_count
535: , p_data => x_msg_data
536: );
537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539:
540: -- Get message count and data
541: FND_MSG_PUB.Count_And_Get
542: ( p_count => x_msg_count

Line 546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

542: ( p_count => x_msg_count
543: , p_data => x_msg_data
544: );
545: WHEN OTHERS THEN
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547:
548: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
549: THEN
550: FND_MSG_PUB.Add_Exc_Msg

Line 618: l_return_status := FND_API.G_RET_STS_SUCCESS;

614: l_updated_flag VARCHAR2(1);
615:
616: BEGIN
617:
618: l_return_status := FND_API.G_RET_STS_SUCCESS;
619:
620: INV_MGD_MVT_STATS_PVT.Validate_Movement_Statistics
621: ( p_movement_statistics => p_movement_statistics
622: , p_movement_stat_usages_rec => p_movement_stat_usages_rec

Line 633: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

629: );
630:
631: x_movement_statistics := l_ret_movement_statistics;
632:
633: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
634: THEN
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: ELSIF x_return_status = FND_API.G_RET_STS_ERROR
637: THEN

Line 635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

631: x_movement_statistics := l_ret_movement_statistics;
632:
633: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
634: THEN
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: ELSIF x_return_status = FND_API.G_RET_STS_ERROR
637: THEN
638: RAISE FND_API.G_EXC_ERROR;
639: END IF;

Line 636: ELSIF x_return_status = FND_API.G_RET_STS_ERROR

632:
633: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
634: THEN
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: ELSIF x_return_status = FND_API.G_RET_STS_ERROR
637: THEN
638: RAISE FND_API.G_EXC_ERROR;
639: END IF;
640:

Line 638: RAISE FND_API.G_EXC_ERROR;

634: THEN
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: ELSIF x_return_status = FND_API.G_RET_STS_ERROR
637: THEN
638: RAISE FND_API.G_EXC_ERROR;
639: END IF;
640:
641: EXCEPTION
642:

Line 643: WHEN FND_API.G_EXC_ERROR THEN

639: END IF;
640:
641: EXCEPTION
642:
643: WHEN FND_API.G_EXC_ERROR THEN
644: l_return_status := FND_API.G_RET_STS_ERROR;
645:
646: -- Get message count and data
647: FND_MSG_PUB.Count_And_Get

Line 644: l_return_status := FND_API.G_RET_STS_ERROR;

640:
641: EXCEPTION
642:
643: WHEN FND_API.G_EXC_ERROR THEN
644: l_return_status := FND_API.G_RET_STS_ERROR;
645:
646: -- Get message count and data
647: FND_MSG_PUB.Count_And_Get
648: ( p_count => x_msg_count

Line 651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

647: FND_MSG_PUB.Count_And_Get
648: ( p_count => x_msg_count
649: , p_data => x_msg_data
650: );
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
653:
654: -- Get message count and data
655: FND_MSG_PUB.Count_And_Get

Line 652: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

648: ( p_count => x_msg_count
649: , p_data => x_msg_data
650: );
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
653:
654: -- Get message count and data
655: FND_MSG_PUB.Count_And_Get
656: ( p_count => x_msg_count

Line 660: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

656: ( p_count => x_msg_count
657: , p_data => x_msg_data
658: );
659: WHEN OTHERS THEN
660: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
661:
662: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
663: THEN
664: FND_MSG_PUB.Add_Exc_Msg

Line 711: x_return_status := FND_API.G_RET_STS_SUCCESS;

707:
708: BEGIN
709:
710:
711: x_return_status := FND_API.G_RET_STS_SUCCESS;
712:
713: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
714: ( p_movement_statistics => l_ret_movement_statistics
715: , x_return_status => l_return_status

Line 720: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

716: , x_msg_count => l_msg_count
717: , x_msg_data => l_msg_data
718: );
719:
720: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
721: THEN
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
724: THEN

Line 722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

718: );
719:
720: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
721: THEN
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
724: THEN
725: RAISE FND_API.G_EXC_ERROR;
726: END IF;

Line 723: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

719:
720: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
721: THEN
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
724: THEN
725: RAISE FND_API.G_EXC_ERROR;
726: END IF;
727:

Line 725: RAISE FND_API.G_EXC_ERROR;

721: THEN
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
724: THEN
725: RAISE FND_API.G_EXC_ERROR;
726: END IF;
727:
728: EXCEPTION
729:

Line 730: WHEN FND_API.G_EXC_ERROR THEN

726: END IF;
727:
728: EXCEPTION
729:
730: WHEN FND_API.G_EXC_ERROR THEN
731: l_return_status := FND_API.G_RET_STS_ERROR;
732:
733: -- Get message count and data
734: FND_MSG_PUB.Count_And_Get

Line 731: l_return_status := FND_API.G_RET_STS_ERROR;

727:
728: EXCEPTION
729:
730: WHEN FND_API.G_EXC_ERROR THEN
731: l_return_status := FND_API.G_RET_STS_ERROR;
732:
733: -- Get message count and data
734: FND_MSG_PUB.Count_And_Get
735: ( p_count => x_msg_count

Line 738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

734: FND_MSG_PUB.Count_And_Get
735: ( p_count => x_msg_count
736: , p_data => x_msg_data
737: );
738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
739: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
740:
741: -- Get message count and data
742: FND_MSG_PUB.Count_And_Get

Line 739: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

735: ( p_count => x_msg_count
736: , p_data => x_msg_data
737: );
738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
739: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
740:
741: -- Get message count and data
742: FND_MSG_PUB.Count_And_Get
743: ( p_count => x_msg_count

Line 747: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

743: ( p_count => x_msg_count
744: , p_data => x_msg_data
745: );
746: WHEN OTHERS THEN
747: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
748:
749: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
750: THEN
751: FND_MSG_PUB.Add_Exc_Msg