DBA Data[Home] [Help]

APPS.INV_SHORTCHECKEXEC_PVT dependencies on FND_MSG_PUB

Line 228: FND_MSG_PUB.initialize;

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;

Line 333: FND_MSG_PUB.Count_And_Get

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

Line 341: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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: --

Line 348: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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: --

Line 356: FND_MSG_PUB.Add;

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;

Line 362: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

Line 363: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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);

Line 366: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

Line 443: FND_MSG_PUB.initialize;

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;

Line 475: FND_MSG_PUB.Count_And_Get

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

Line 483: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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: --

Line 490: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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: --

Line 497: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

Line 498: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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);

Line 501: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

Line 753: FND_MSG_PUB.initialize;

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;

Line 774: FND_MSG_PUB.Add;

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: --

Line 842: FND_MSG_PUB.Count_And_Get

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

Line 850: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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: --

Line 857: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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: --

Line 864: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

Line 865: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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);

Line 868: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

Line 929: FND_MSG_PUB.initialize;

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;

Line 944: FND_MSG_PUB.Count_And_Get

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

Line 952: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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: --

Line 959: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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: --

Line 966: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

Line 967: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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);

Line 970: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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