APPS.OE_PAYMENT_DATA_MIGRATION_UTIL dependencies on FND_API

Line 151: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS ;

147: l_status VARCHAR2(30) ;
148: l_industry VARCHAR2(30) ;
149: l_retstatus BOOLEAN ;
150:
151: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS ;
152: l_msg_count NUMBER := 0 ;
153: l_msg_data VARCHAR2(2000) ;
154:
155: l_process_total1 NUMBER := 0 ;

Line 1008: WHEN FND_API.G_EXC_ERROR THEN

1004:
1005: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
1006:
1007: EXCEPTION
1008: WHEN FND_API.G_EXC_ERROR THEN
1009: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
1010:
1011: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1012: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Migrate_Data_WKR');

Line 1016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1012: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Migrate_Data_WKR');
1013: END IF;
1014:
1015: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
1016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1017: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
1018:
1019: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1020: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Migrate_Data_WKR');

Line 1086: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS ;

1082: l_status VARCHAR2(30) ;
1083: l_industry VARCHAR2(30) ;
1084: l_retstatus BOOLEAN ;
1085:
1086: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS ;
1087: l_msg_count NUMBER := 0 ;
1088: l_msg_data VARCHAR2(2000) ;
1089:
1090: l_exists_header VARCHAR2(1) := 'N' ;

Line 1617: WHEN FND_API.G_EXC_ERROR THEN

1613:
1614: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
1615:
1616: EXCEPTION
1617: WHEN FND_API.G_EXC_ERROR THEN
1618: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
1619:
1620: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1621: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purge_Data_WKR');

Line 1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1621: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purge_Data_WKR');
1622: END IF;
1623:
1624: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1626: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
1627:
1628: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1629: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purge_Data_WKR');