224: END IF;
225: --
226: -- Initialize message list if p_init_msg_list is set to true
227: IF FND_API.to_Boolean(p_init_msg_list) THEN
228: FND_MSG_PUB.initialize;
229: END IF;
230: --
231: -- Initialize API return status to access
232: x_return_status := FND_API.G_RET_STS_SUCCESS;
329: IF FND_API.to_Boolean(p_commit) THEN
330: COMMIT;
331: END IF;
332: -- Standard call to get message count and if count is 1, get message info
333: FND_MSG_PUB.Count_And_Get
334: (p_count => x_msg_count
335: , p_data => x_msg_data);
336: EXCEPTION
337: WHEN FND_API.G_EXC_ERROR THEN
337: WHEN FND_API.G_EXC_ERROR THEN
338: --
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: --
341: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
342: , p_data => x_msg_data);
343: --
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: --
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: --
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: --
348: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
349: , p_data => x_msg_data);
350: --
351: WHEN L_Statement_not_found THEN
352: --
352: --
353: x_return_status := FND_API.G_RET_STS_ERROR;
354: --
355: FND_MESSAGE.SET_NAME('INV','INV_SHORT_STATEMENT_NOT_FOUND');
356: FND_MSG_PUB.Add;
357: --
358: WHEN OTHERS THEN
359: --
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: WHEN OTHERS THEN
359: --
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: --
362: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
363: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
364: END IF;
365: --
366: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
359: --
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: --
362: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
363: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
364: END IF;
365: --
366: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
367: , p_data => x_msg_data);
362: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
363: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
364: END IF;
365: --
366: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
367: , p_data => x_msg_data);
368: END;
369: -- Start OF comments
370: -- API name : CheckPrerequisites
439: END IF;
440: --
441: -- Initialize message list if p_init_msg_list is set to true
442: IF FND_API.to_Boolean(p_init_msg_list) THEN
443: FND_MSG_PUB.initialize;
444: END IF;
445: --
446: -- Initialize API return status to access
447: x_return_status := FND_API.G_RET_STS_SUCCESS;
471: END IF;
472: END IF;
473: --
474: -- Standard call to get message count and if count is 1, get message info
475: FND_MSG_PUB.Count_And_Get
476: (p_count => x_msg_count
477: , p_data => x_msg_data);
478: EXCEPTION
479: WHEN FND_API.G_EXC_ERROR THEN
479: WHEN FND_API.G_EXC_ERROR THEN
480: --
481: x_return_status := FND_API.G_RET_STS_ERROR;
482: --
483: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
484: , p_data => x_msg_data);
485: --
486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
487: --
486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
487: --
488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: --
490: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
491: , p_data => x_msg_data);
492: --
493: WHEN OTHERS THEN
494: --
493: WHEN OTHERS THEN
494: --
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: --
497: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
498: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
499: END IF;
500: --
501: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
494: --
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: --
497: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
498: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
499: END IF;
500: --
501: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
502: , p_data => x_msg_data);
497: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
498: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
499: END IF;
500: --
501: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
502: , p_data => x_msg_data);
503: END;
504: -- Start OF comments
505: -- API name : SendNotifications
749: END IF;
750: --
751: -- Initialize message list if p_init_msg_list is set to true
752: IF FND_API.to_Boolean(p_init_msg_list) THEN
753: FND_MSG_PUB.initialize;
754: END IF;
755: --
756: -- Initialize API return status to access
757: x_return_status := FND_API.G_RET_STS_SUCCESS;
770: OPEN L_ShortParam_csr ( p_organization_id );
771: FETCH L_ShortParam_csr INTO L_ShortParam_rec;
772: IF L_ShortParam_csr%NOTFOUND THEN
773: FND_MESSAGE.SET_NAME('INV','INV_SHORT_PARAMETER_NOT_FOUND');
774: FND_MSG_PUB.Add;
775: RAISE FND_API.G_EXC_ERROR;
776: END IF;
777: CLOSE L_ShortParam_csr;
778: --
838: IF FND_API.to_Boolean(p_commit) THEN
839: COMMIT;
840: END IF;
841: -- Standard call to get message count and if count is 1, get message info
842: FND_MSG_PUB.Count_And_Get
843: (p_count => x_msg_count
844: , p_data => x_msg_data);
845: EXCEPTION
846: WHEN FND_API.G_EXC_ERROR THEN
846: WHEN FND_API.G_EXC_ERROR THEN
847: --
848: x_return_status := FND_API.G_RET_STS_ERROR;
849: --
850: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
851: , p_data => x_msg_data);
852: --
853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
854: --
853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
854: --
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
856: --
857: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
858: , p_data => x_msg_data);
859: --
860: WHEN OTHERS THEN
861: --
860: WHEN OTHERS THEN
861: --
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
863: --
864: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
865: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
866: END IF;
867: --
868: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
861: --
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
863: --
864: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
865: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
866: END IF;
867: --
868: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
869: , p_data => x_msg_data);
864: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
865: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
866: END IF;
867: --
868: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
869: , p_data => x_msg_data);
870: END;
871: -- Start OF comments
872: -- API name : PurgeTempTable
925: END IF;
926: --
927: -- Initialize message list if p_init_msg_list is set to true
928: IF FND_API.to_Boolean(p_init_msg_list) THEN
929: FND_MSG_PUB.initialize;
930: END IF;
931: --
932: -- Initialize API return status to success
933: x_return_status := FND_API.G_RET_STS_SUCCESS;
940: IF FND_API.to_Boolean(p_commit) THEN
941: COMMIT;
942: END IF;
943: -- Standard call to get message count and if count is 1, get message info
944: FND_MSG_PUB.Count_And_Get
945: (p_count => x_msg_count
946: , p_data => x_msg_data);
947: EXCEPTION
948: WHEN FND_API.G_EXC_ERROR THEN
948: WHEN FND_API.G_EXC_ERROR THEN
949: --
950: x_return_status := FND_API.G_RET_STS_ERROR;
951: --
952: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
953: , p_data => x_msg_data);
954: --
955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
956: --
955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
956: --
957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
958: --
959: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
960: , p_data => x_msg_data);
961: --
962: WHEN OTHERS THEN
963: --
962: WHEN OTHERS THEN
963: --
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
965: --
966: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
967: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
968: END IF;
969: --
970: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
963: --
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
965: --
966: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
967: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
968: END IF;
969: --
970: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
971: , p_data => x_msg_data);
966: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
967: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
968: END IF;
969: --
970: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
971: , p_data => x_msg_data);
972: END;
973: -- Start OF comments
974: -- API name : PrepareMessage