DBA Data[Home] [Help]

APPS.OE_PAYMENT_DATA_MIGRATION_UTIL dependencies on AD_CONC_UTILS_PKG

Line 98: AD_CONC_UTILS_PKG.submit_subrequests(

94: )
95: IS
96: l_product VARCHAR2(30) := 'ONT' ;
97: BEGIN
98: AD_CONC_UTILS_PKG.submit_subrequests(
99: X_errbuf => X_errbuf,
100: X_retcode => X_retcode,
101: X_WorkerConc_app_shortname => l_product,
102: X_workerConc_progname => 'ONTIBYFC_WKR',

Line 1005: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;

1001: END IF;
1002:
1003: COMMIT ;
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 ;

Line 1009: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;

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

Line 1017: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;

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

Line 1025: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;

1021: END IF;
1022:
1023: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
1024: WHEN OTHERS THEN
1025: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
1026:
1027: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1028: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Migrate_Data_WKR');
1029: END IF;

Line 1043: AD_CONC_UTILS_PKG.submit_subrequests(

1039: )
1040: IS
1041: l_product VARCHAR2(30) := 'ONT' ;
1042: BEGIN
1043: AD_CONC_UTILS_PKG.submit_subrequests(
1044: X_errbuf => X_errbuf,
1045: X_retcode => X_retcode,
1046: X_WorkerConc_app_shortname => l_product,
1047: X_workerConc_progname => 'ONTIBYCN_WKR',

Line 1614: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;

1610: -- end of processsing oe_order_header_history
1611:
1612: COMMIT ;
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 ;

Line 1618: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;

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

Line 1626: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;

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

Line 1634: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;

1630: END IF;
1631:
1632: FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent Request Error : '||substr(sqlerrm,1,200));
1633: WHEN OTHERS THEN
1634: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL ;
1635:
1636: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1637: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purge_Data_WKR');
1638: END IF;