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:
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88:
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
121: , p_data => x_msg_data
122: );
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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
129: , p_data => x_msg_data
130: );
131: WHEN OTHERS THEN
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
137: ( G_PKG_NAME
138: , 'Process_Transaction'
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
137: ( G_PKG_NAME
138: , 'Process_Transaction'
139: );
140: END IF;
138: , 'Process_Transaction'
139: );
140: END IF;
141: -- Get message count and data
142: FND_MSG_PUB.Count_And_Get
143: ( p_count => x_msg_count
144: , p_data => x_msg_data
145: );
146:
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:
200: x_return_status := FND_API.G_RET_STS_SUCCESS;
201:
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
234: , p_data => x_msg_data
235: );
236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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
242: , p_data => x_msg_data
243: );
244: WHEN OTHERS THEN
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
250: ( G_PKG_NAME
251: , 'Create_Movement_Statistics'
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
250: ( G_PKG_NAME
251: , 'Create_Movement_Statistics'
252: );
253: END IF;
251: , 'Create_Movement_Statistics'
252: );
253: END IF;
254: -- Get message count and data
255: FND_MSG_PUB.Count_And_Get
256: ( p_count => x_msg_count
257: , p_data => x_msg_data
258: );
259: END Create_Movement_Statistics;
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:
338: l_return_status := FND_API.G_RET_STS_SUCCESS;
339:
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
391: , p_data => x_msg_data
392: );
393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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
399: , p_data => x_msg_data
400: );
401: WHEN OTHERS THEN
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
407: ( G_PKG_NAME
408: , 'Reset_Transaction_Status'
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
407: ( G_PKG_NAME
408: , 'Reset_Transaction_Status'
409: );
410: END IF;
408: , 'Reset_Transaction_Status'
409: );
410: END IF;
411: -- Get message count and data
412: FND_MSG_PUB.Count_And_Get
413: ( p_count => x_msg_count
414: , p_data => x_msg_data
415: );
416:
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:
484: l_return_status := FND_API.G_RET_STS_SUCCESS;
485:
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
535: , p_data => x_msg_data
536: );
537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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
543: , p_data => x_msg_data
544: );
545: WHEN OTHERS THEN
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
551: ( G_PKG_NAME
552: , 'Purge_Movement_Transactions'
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
551: ( G_PKG_NAME
552: , 'Purge_Movement_Transactions'
553: );
554: END IF;
552: , 'Purge_Movement_Transactions'
553: );
554: END IF;
555: -- Get message count and data
556: FND_MSG_PUB.Count_And_Get
557: ( p_count => x_msg_count
558: , p_data => x_msg_data
559: );
560:
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
649: , p_data => x_msg_data
650: );
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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
657: , p_data => x_msg_data
658: );
659: WHEN OTHERS THEN
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
665: ( G_PKG_NAME
666: , 'Validate_Movement_Statistics'
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
665: ( G_PKG_NAME
666: , 'Validate_Movement_Statistics'
667: );
668: END IF;
666: , 'Validate_Movement_Statistics'
667: );
668: END IF;
669: -- Get message count and data
670: FND_MSG_PUB.Count_And_Get
671: ( p_count => x_msg_count
672: , p_data => x_msg_data
673: );
674:
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
736: , p_data => x_msg_data
737: );
738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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
744: , p_data => x_msg_data
745: );
746: WHEN OTHERS THEN
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
752: ( G_PKG_NAME
753: , 'Update_Movement_Statistics'
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
752: ( G_PKG_NAME
753: , 'Update_Movement_Statistics'
754: );
755: END IF;
753: , 'Update_Movement_Statistics'
754: );
755: END IF;
756: -- Get message count and data
757: FND_MSG_PUB.Count_And_Get
758: ( p_count => x_msg_count
759: , p_data => x_msg_data
760: );
761: END Update_Movement_Statistics;