DBA Data[Home] [Help]

APPS.WSH_SHIPMENT_REQUEST_PKG dependencies on FND_GLOBAL

Line 699: IF FND_GLOBAL.Conc_Request_Id > 0 THEN

695: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
696: END IF;
697:
698: -- To Print in Concurrent Request Output File
699: IF FND_GLOBAL.Conc_Request_Id > 0 THEN
700: FND_FILE.put_line(FND_FILE.output, 'Time taken by OE_ORDER_GRP.Process_Order API alone in secs => ' || g_po_total_time);
701: FND_FILE.put_line(FND_FILE.output, '');
702: FND_FILE.put_line(FND_FILE.output, 'Summary:-');
703: FND_FILE.put_line(FND_FILE.output,'===================================');

Line 1000: IF FND_GLOBAL.Conc_Request_Id > 0 THEN

996: END IF;
997: --
998:
999: -- To Print in Concurrent Request Output File
1000: IF FND_GLOBAL.Conc_Request_Id > 0 THEN
1001: FND_FILE.put_line(FND_FILE.output, '**** Processing document ' || l_transaction_rec.document_number
1002: || ' with revision ' || l_transaction_rec.document_revision
1003: || ', action type ' || l_transaction_rec.action_type || ' ****' );
1004: END IF;

Line 1490: program_application_id = FND_GLOBAL.Prog_Appl_Id,

1486: IF l_txn_history_tbl.count > 0 THEN
1487: FORALL i in l_txn_history_tbl.FIRST..l_txn_history_tbl.LAST
1488: UPDATE wsh_transactions_history
1489: SET transaction_status = 'SC',
1490: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1491: program_id = FND_GLOBAL.Conc_Program_Id,
1492: request_id = FND_GLOBAL.Conc_Request_Id,
1493: program_update_date = sysdate,
1494: last_updated_by = FND_GLOBAL.User_Id,

Line 1491: program_id = FND_GLOBAL.Conc_Program_Id,

1487: FORALL i in l_txn_history_tbl.FIRST..l_txn_history_tbl.LAST
1488: UPDATE wsh_transactions_history
1489: SET transaction_status = 'SC',
1490: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1491: program_id = FND_GLOBAL.Conc_Program_Id,
1492: request_id = FND_GLOBAL.Conc_Request_Id,
1493: program_update_date = sysdate,
1494: last_updated_by = FND_GLOBAL.User_Id,
1495: last_update_date = sysdate,

Line 1492: request_id = FND_GLOBAL.Conc_Request_Id,

1488: UPDATE wsh_transactions_history
1489: SET transaction_status = 'SC',
1490: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1491: program_id = FND_GLOBAL.Conc_Program_Id,
1492: request_id = FND_GLOBAL.Conc_Request_Id,
1493: program_update_date = sysdate,
1494: last_updated_by = FND_GLOBAL.User_Id,
1495: last_update_date = sysdate,
1496: last_update_login = FND_GLOBAL.Login_Id

Line 1494: last_updated_by = FND_GLOBAL.User_Id,

1490: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1491: program_id = FND_GLOBAL.Conc_Program_Id,
1492: request_id = FND_GLOBAL.Conc_Request_Id,
1493: program_update_date = sysdate,
1494: last_updated_by = FND_GLOBAL.User_Id,
1495: last_update_date = sysdate,
1496: last_update_login = FND_GLOBAL.Login_Id
1497: WHERE transaction_id = l_txn_history_tbl(i);
1498:

Line 1496: last_update_login = FND_GLOBAL.Login_Id

1492: request_id = FND_GLOBAL.Conc_Request_Id,
1493: program_update_date = sysdate,
1494: last_updated_by = FND_GLOBAL.User_Id,
1495: last_update_date = sysdate,
1496: last_update_login = FND_GLOBAL.Login_Id
1497: WHERE transaction_id = l_txn_history_tbl(i);
1498:
1499: --
1500: IF l_debug_on THEN

Line 2018: last_updated_by = FND_GLOBAL.User_Id,

2014: ignore_for_planning = DECODE(l_modify_otm_flag,'Y',l_gnore_for_planning,ignore_for_planning),
2015: oe_interfaced_flag = DECODE(l_modify_oe_iface_flag,'Y','X',oe_interfaced_flag),
2016: -- LSP PROJECT
2017: last_update_date = sysdate,
2018: last_updated_by = FND_GLOBAL.User_Id,
2019: program_application_id = FND_GLOBAL.Prog_Appl_Id,
2020: program_id = FND_GLOBAL.Conc_Program_Id,
2021: request_id = FND_GLOBAL.Conc_Request_Id,
2022: program_update_date = sysdate

Line 2019: program_application_id = FND_GLOBAL.Prog_Appl_Id,

2015: oe_interfaced_flag = DECODE(l_modify_oe_iface_flag,'Y','X',oe_interfaced_flag),
2016: -- LSP PROJECT
2017: last_update_date = sysdate,
2018: last_updated_by = FND_GLOBAL.User_Id,
2019: program_application_id = FND_GLOBAL.Prog_Appl_Id,
2020: program_id = FND_GLOBAL.Conc_Program_Id,
2021: request_id = FND_GLOBAL.Conc_Request_Id,
2022: program_update_date = sysdate
2023: WHERE source_code = 'OE'

Line 2020: program_id = FND_GLOBAL.Conc_Program_Id,

2016: -- LSP PROJECT
2017: last_update_date = sysdate,
2018: last_updated_by = FND_GLOBAL.User_Id,
2019: program_application_id = FND_GLOBAL.Prog_Appl_Id,
2020: program_id = FND_GLOBAL.Conc_Program_Id,
2021: request_id = FND_GLOBAL.Conc_Request_Id,
2022: program_update_date = sysdate
2023: WHERE source_code = 'OE'
2024: AND source_line_id = l_details_interface_tab(i).line_id

Line 2021: request_id = FND_GLOBAL.Conc_Request_Id,

2017: last_update_date = sysdate,
2018: last_updated_by = FND_GLOBAL.User_Id,
2019: program_application_id = FND_GLOBAL.Prog_Appl_Id,
2020: program_id = FND_GLOBAL.Conc_Program_Id,
2021: request_id = FND_GLOBAL.Conc_Request_Id,
2022: program_update_date = sysdate
2023: WHERE source_code = 'OE'
2024: AND source_line_id = l_details_interface_tab(i).line_id
2025: RETURNING delivery_detail_id BULK COLLECT INTO l_delivery_detail_tab;

Line 2147: program_application_id = FND_GLOBAL.Prog_Appl_Id,

2143: UPDATE wsh_transactions_history
2144: SET transaction_status = 'SC',
2145: entity_type = decode(transaction_id, l_transaction_rec.transaction_id, 'ORDER', entity_type),
2146: entity_number = decode(transaction_id, l_transaction_rec.transaction_id, x_header_rec.header_id, entity_number),
2147: program_application_id = FND_GLOBAL.Prog_Appl_Id,
2148: program_id = FND_GLOBAL.Conc_Program_Id,
2149: request_id = FND_GLOBAL.Conc_Request_Id,
2150: program_update_date = sysdate,
2151: last_updated_by = FND_GLOBAL.User_Id,

Line 2148: program_id = FND_GLOBAL.Conc_Program_Id,

2144: SET transaction_status = 'SC',
2145: entity_type = decode(transaction_id, l_transaction_rec.transaction_id, 'ORDER', entity_type),
2146: entity_number = decode(transaction_id, l_transaction_rec.transaction_id, x_header_rec.header_id, entity_number),
2147: program_application_id = FND_GLOBAL.Prog_Appl_Id,
2148: program_id = FND_GLOBAL.Conc_Program_Id,
2149: request_id = FND_GLOBAL.Conc_Request_Id,
2150: program_update_date = sysdate,
2151: last_updated_by = FND_GLOBAL.User_Id,
2152: last_update_date = sysdate,

Line 2149: request_id = FND_GLOBAL.Conc_Request_Id,

2145: entity_type = decode(transaction_id, l_transaction_rec.transaction_id, 'ORDER', entity_type),
2146: entity_number = decode(transaction_id, l_transaction_rec.transaction_id, x_header_rec.header_id, entity_number),
2147: program_application_id = FND_GLOBAL.Prog_Appl_Id,
2148: program_id = FND_GLOBAL.Conc_Program_Id,
2149: request_id = FND_GLOBAL.Conc_Request_Id,
2150: program_update_date = sysdate,
2151: last_updated_by = FND_GLOBAL.User_Id,
2152: last_update_date = sysdate,
2153: last_update_login = FND_GLOBAL.Login_Id

Line 2151: last_updated_by = FND_GLOBAL.User_Id,

2147: program_application_id = FND_GLOBAL.Prog_Appl_Id,
2148: program_id = FND_GLOBAL.Conc_Program_Id,
2149: request_id = FND_GLOBAL.Conc_Request_Id,
2150: program_update_date = sysdate,
2151: last_updated_by = FND_GLOBAL.User_Id,
2152: last_update_date = sysdate,
2153: last_update_login = FND_GLOBAL.Login_Id
2154: WHERE transaction_id = l_upd_txn_history_tbl(i);
2155:

Line 2153: last_update_login = FND_GLOBAL.Login_Id

2149: request_id = FND_GLOBAL.Conc_Request_Id,
2150: program_update_date = sysdate,
2151: last_updated_by = FND_GLOBAL.User_Id,
2152: last_update_date = sysdate,
2153: last_update_login = FND_GLOBAL.Login_Id
2154: WHERE transaction_id = l_upd_txn_history_tbl(i);
2155:
2156: --
2157: IF l_debug_on THEN

Line 2316: IF FND_GLOBAL.Conc_Request_Id > 0 THEN

2312:
2313: IF l_temp_status in ( 'INVALID', 'INVALID_HEADER' ) THEN --{
2314: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2315: -- To Print in Concurrent Request Output File
2316: IF FND_GLOBAL.Conc_Request_Id > 0 THEN
2317: FND_FILE.put_line(FND_FILE.output, ' Process Shipment Request failed to process document number: ' || l_transaction_rec.document_number);
2318: END IF;
2319: --
2320: --Rollback the transaction