APPS.OE_PAYMENT_DATA_MIGRATION_UTIL dependencies on FND_API

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

108: l_status VARCHAR2(30) ;
109: l_industry VARCHAR2(30) ;
110: l_retstatus BOOLEAN ;
111:
112: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS ;
113: l_msg_count NUMBER := 0 ;
114: l_msg_data VARCHAR2(2000) ;
115:
116: l_process_total1 NUMBER := 0 ;

Line 969: WHEN FND_API.G_EXC_ERROR THEN

965:
966: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
967:
968: EXCEPTION
969: WHEN FND_API.G_EXC_ERROR THEN
970: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
971:
972: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
973: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Migrate_Data_WKR');

Line 977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

973: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Migrate_Data_WKR');
974: END IF;
975:
976: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
978: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
979:
980: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
981: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Migrate_Data_WKR');

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

1043: l_status VARCHAR2(30) ;
1044: l_industry VARCHAR2(30) ;
1045: l_retstatus BOOLEAN ;
1046:
1047: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS ;
1048: l_msg_count NUMBER := 0 ;
1049: l_msg_data VARCHAR2(2000) ;
1050:
1051: l_exists_header VARCHAR2(1) := 'N' ;

Line 1578: WHEN FND_API.G_EXC_ERROR THEN

1574:
1575: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
1576:
1577: EXCEPTION
1578: WHEN FND_API.G_EXC_ERROR THEN
1579: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
1580:
1581: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1582: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purge_Data_WKR');

Line 1586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1582: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purge_Data_WKR');
1583: END IF;
1584:
1585: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
1586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1587: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
1588:
1589: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1590: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purge_Data_WKR');