DBA Data[Home] [Help]

APPS.INL_TCAMERGE_GRP dependencies on FND_API

Line 94: x_return_status := FND_API.G_RET_STS_SUCCESS;

90: SAVEPOINT Merge_Vendors_GRP;
91: --
92:
93: -- Initialize API return status to success
94: x_return_status := FND_API.G_RET_STS_SUCCESS;
95: --
96:
97: -- Logging variables
98: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 314: WHEN FND_API.G_EXC_ERROR THEN

310: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
311: p_procedure_name => l_proc_name) ;
312:
313: EXCEPTION
314: WHEN FND_API.G_EXC_ERROR THEN
315: -- Standard Expected Error Logging
316: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
317: p_procedure_name => l_proc_name);
318: ROLLBACK TO Merge_Vendors_GRP;

Line 319: x_return_status := FND_API.G_RET_STS_ERROR;

315: -- Standard Expected Error Logging
316: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
317: p_procedure_name => l_proc_name);
318: ROLLBACK TO Merge_Vendors_GRP;
319: x_return_status := FND_API.G_RET_STS_ERROR;
320:
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
322: -- Standard Unexpected Error Logging
323: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

317: p_procedure_name => l_proc_name);
318: ROLLBACK TO Merge_Vendors_GRP;
319: x_return_status := FND_API.G_RET_STS_ERROR;
320:
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
322: -- Standard Unexpected Error Logging
323: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
324: p_procedure_name => l_proc_name);
325: ROLLBACK TO Merge_Vendors_GRP;

Line 326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

322: -- Standard Unexpected Error Logging
323: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
324: p_procedure_name => l_proc_name);
325: ROLLBACK TO Merge_Vendors_GRP;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327:
328: WHEN OTHERS THEN
329: -- Standard Unexpected Error Logging
330: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

329: -- Standard Unexpected Error Logging
330: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
331: p_procedure_name => l_proc_name);
332: ROLLBACK TO Merge_Vendors_GRP;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
335: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,l_proc_name);
336: END IF;
337: --}

Line 408: x_return_status := FND_API.G_RET_STS_SUCCESS;

404: -- Standard Start of API savepoint
405: SAVEPOINT Merge_VendorParties_GRP;
406:
407: -- Initialize API return status to success
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409: --
410:
411: -- Logging variables
412: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 523: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

519: p_procedure_name => l_proc_name,
520: p_debug_info => l_debug_info);
521:
522: -- If any errors happen abort API.
523: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
524: RAISE FND_API.G_EXC_ERROR;
525: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;

Line 524: RAISE FND_API.G_EXC_ERROR;

520: p_debug_info => l_debug_info);
521:
522: -- If any errors happen abort API.
523: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
524: RAISE FND_API.G_EXC_ERROR;
525: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528: --

Line 525: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

521:
522: -- If any errors happen abort API.
523: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
524: RAISE FND_API.G_EXC_ERROR;
525: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528: --
529: l_debug_info := 'x_return_status '||x_return_status;

Line 526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

522: -- If any errors happen abort API.
523: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
524: RAISE FND_API.G_EXC_ERROR;
525: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528: --
529: l_debug_info := 'x_return_status '||x_return_status;
530: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,

Line 535: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

531: p_procedure_name => l_proc_name,
532: p_debug_info => l_debug_info) ;
533:
534: -- Standard call to get message count and if count is 1, get message info.
535: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
536: p_count => x_msg_count,
537: p_data => x_msg_data);
538:
539: -- Standard End of Procedure/Function Logging

Line 545: WHEN FND_API.G_EXC_ERROR THEN

541: p_procedure_name => l_proc_name) ;
542:
543: --}
544: EXCEPTION
545: WHEN FND_API.G_EXC_ERROR THEN
546: -- Standard Expected Error Logging
547: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
548: p_procedure_name => l_proc_name);
549: ROLLBACK TO Merge_VendorParties_GRP;

Line 550: x_return_status := FND_API.G_RET_STS_ERROR;

546: -- Standard Expected Error Logging
547: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
548: p_procedure_name => l_proc_name);
549: ROLLBACK TO Merge_VendorParties_GRP;
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552: -- Standard Unexpected Error Logging
553: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
554: p_procedure_name => l_proc_name);

Line 551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

547: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
548: p_procedure_name => l_proc_name);
549: ROLLBACK TO Merge_VendorParties_GRP;
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552: -- Standard Unexpected Error Logging
553: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
554: p_procedure_name => l_proc_name);
555: ROLLBACK TO Merge_VendorParties_GRP;

Line 556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

552: -- Standard Unexpected Error Logging
553: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
554: p_procedure_name => l_proc_name);
555: ROLLBACK TO Merge_VendorParties_GRP;
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: WHEN OTHERS THEN
558: -- Standard Unexpected Error Logging
559: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
560: p_procedure_name => l_proc_name);

Line 562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

558: -- Standard Unexpected Error Logging
559: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
560: p_procedure_name => l_proc_name);
561: ROLLBACK TO Merge_VendorParties_GRP;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
564: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,l_proc_name);
565: END IF;
566: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 566: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
564: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,l_proc_name);
565: END IF;
566: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
567: p_count => x_msg_count,
568: p_data => x_msg_data);
569: END Merge_VendorParties;
570:

Line 624: x_return_status := FND_API.G_RET_STS_SUCCESS;

620: -- Standard Start of API savepoint
621: SAVEPOINT Merge_Parties_GRP;
622:
623: -- Initialize API return status to success
624: x_return_status := FND_API.G_RET_STS_SUCCESS;
625: --
626:
627: -- Logging variables
628: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 699: WHEN FND_API.G_EXC_ERROR THEN

695: p_procedure_name => l_proc_name) ;
696:
697: --}
698: EXCEPTION
699: WHEN FND_API.G_EXC_ERROR THEN
700: -- Standard Expected Error Logging
701: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
702: p_procedure_name => l_proc_name);
703: ROLLBACK TO Merge_Parties_GRP;

Line 704: x_return_status := FND_API.G_RET_STS_ERROR;

700: -- Standard Expected Error Logging
701: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
702: p_procedure_name => l_proc_name);
703: ROLLBACK TO Merge_Parties_GRP;
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
706: -- Standard Unexpected Error Logging
707: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
708: p_procedure_name => l_proc_name);

Line 705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

701: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
702: p_procedure_name => l_proc_name);
703: ROLLBACK TO Merge_Parties_GRP;
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
706: -- Standard Unexpected Error Logging
707: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
708: p_procedure_name => l_proc_name);
709: ROLLBACK TO Merge_Parties_GRP;

Line 710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

706: -- Standard Unexpected Error Logging
707: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
708: p_procedure_name => l_proc_name);
709: ROLLBACK TO Merge_Parties_GRP;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: WHEN OTHERS THEN
712: -- Standard Unexpected Error Logging
713: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
714: p_procedure_name => l_proc_name);

Line 716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

712: -- Standard Unexpected Error Logging
713: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
714: p_procedure_name => l_proc_name);
715: ROLLBACK TO Merge_Parties_GRP;
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
718: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,l_proc_name);
719: END IF;
720: END Merge_Parties;

Line 777: x_return_status := FND_API.G_RET_STS_SUCCESS;

773: -- Standard Start of API savepoint
774: SAVEPOINT Merge_PartySites_GRP;
775:
776: -- Initialize API return status to success
777: x_return_status := FND_API.G_RET_STS_SUCCESS;
778:
779: -- Logging variables
780: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
781: p_procedure_name => l_proc_name,

Line 851: WHEN FND_API.G_EXC_ERROR THEN

847: p_procedure_name => l_proc_name) ;
848:
849: --}
850: EXCEPTION
851: WHEN FND_API.G_EXC_ERROR THEN
852: -- Standard Expected Error Logging
853: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
854: p_procedure_name => l_proc_name);
855: ROLLBACK TO Merge_PartySites_GRP;

Line 856: x_return_status := FND_API.G_RET_STS_ERROR;

852: -- Standard Expected Error Logging
853: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
854: p_procedure_name => l_proc_name);
855: ROLLBACK TO Merge_PartySites_GRP;
856: x_return_status := FND_API.G_RET_STS_ERROR;
857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
858: -- Standard Unexpected Error Logging
859: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
860: p_procedure_name => l_proc_name);

Line 857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

853: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
854: p_procedure_name => l_proc_name);
855: ROLLBACK TO Merge_PartySites_GRP;
856: x_return_status := FND_API.G_RET_STS_ERROR;
857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
858: -- Standard Unexpected Error Logging
859: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
860: p_procedure_name => l_proc_name);
861: ROLLBACK TO Merge_PartySites_GRP;

Line 862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

858: -- Standard Unexpected Error Logging
859: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
860: p_procedure_name => l_proc_name);
861: ROLLBACK TO Merge_PartySites_GRP;
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
863: WHEN OTHERS THEN
864: -- Standard Unexpected Error Logging
865: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
866: p_procedure_name => l_proc_name);

Line 868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

864: -- Standard Unexpected Error Logging
865: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
866: p_procedure_name => l_proc_name);
867: ROLLBACK TO Merge_PartySites_GRP;
868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
869: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
870: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,l_proc_name);
871: END IF;
872: