DBA Data[Home] [Help]

APPS.OE_PAYMENT_DATA_MIGRATION_UTIL dependencies on AD_CONC_UTILS_PKG

Line 59: AD_CONC_UTILS_PKG.submit_subrequests(

55: )
56: IS
57: l_product VARCHAR2(30) := 'ONT' ;
58: BEGIN
59: AD_CONC_UTILS_PKG.submit_subrequests(
60: X_errbuf => X_errbuf,
61: X_retcode => X_retcode,
62: X_WorkerConc_app_shortname => l_product,
63: X_workerConc_progname => 'ONTIBYFC_WKR',

Line 966: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;

962: END IF;
963:
964: COMMIT ;
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 ;

Line 970: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;

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');
974: END IF;

Line 978: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;

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');
982: END IF;

Line 986: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;

982: END IF;
983:
984: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
985: WHEN OTHERS THEN
986: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
987:
988: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
989: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Migrate_Data_WKR');
990: END IF;

Line 1004: AD_CONC_UTILS_PKG.submit_subrequests(

1000: )
1001: IS
1002: l_product VARCHAR2(30) := 'ONT' ;
1003: BEGIN
1004: AD_CONC_UTILS_PKG.submit_subrequests(
1005: X_errbuf => X_errbuf,
1006: X_retcode => X_retcode,
1007: X_WorkerConc_app_shortname => l_product,
1008: X_workerConc_progname => 'ONTIBYCN_WKR',

Line 1575: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;

1571: -- end of processsing oe_order_header_history
1572:
1573: COMMIT ;
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 ;

Line 1579: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;

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');
1583: END IF;

Line 1587: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;

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');
1591: END IF;

Line 1595: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;

1591: END IF;
1592:
1593: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
1594: WHEN OTHERS THEN
1595: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
1596:
1597: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1598: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purge_Data_WKR');
1599: END IF;