eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_TASK_MGMT_PUB dependencies on WMS_TASK_MGMT_PUB

Line 1: PACKAGE BODY WMS_TASK_MGMT_PUB AS

1: PACKAGE BODY WMS_TASK_MGMT_PUB AS
2: /*$Header: WMSTKMPB.pls 120.14.12020000.4 2013/04/15 06:52:35 raminoch ship $ */
3: ------------------------------------------------------------------------------------------------------
4: g_pkg_name VARCHAR2(30) := 'WMS_TASK_MGMT_PUB';
5: g_debug NUMBER := nvl(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);

Line 4: g_pkg_name VARCHAR2(30) := 'WMS_TASK_MGMT_PUB';

1: PACKAGE BODY WMS_TASK_MGMT_PUB AS
2: /*$Header: WMSTKMPB.pls 120.14.12020000.4 2013/04/15 06:52:35 raminoch ship $ */
3: ------------------------------------------------------------------------------------------------------
4: g_pkg_name VARCHAR2(30) := 'WMS_TASK_MGMT_PUB';
5: g_debug NUMBER := nvl(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);
6: ------------------------------------------------------------------------------------------------------
7: -- START OF QUERY TASKS
8: PROCEDURE initialize_main_table

Line 209: p_task_table IN WMS_TASK_MGMT_PUB.task_tab_type ,

205: /*Procedure to log error message to the x_updated_tasks rec*/
206: -------------------------------------------------------------------------------------------------------------------
207:
208: PROCEDURE log_error(p_transaction_number IN NUMBER DEFAULT NULL ,
209: p_task_table IN WMS_TASK_MGMT_PUB.task_tab_type ,
210: p_error_msg IN VARCHAR2 ,
211: x_updated_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type) IS
212:
213: BEGIN

Line 211: x_updated_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type) IS

207:
208: PROCEDURE log_error(p_transaction_number IN NUMBER DEFAULT NULL ,
209: p_task_table IN WMS_TASK_MGMT_PUB.task_tab_type ,
210: p_error_msg IN VARCHAR2 ,
211: x_updated_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type) IS
212:
213: BEGIN
214: IF p_transaction_number is NOT NULL THEN
215: x_updated_tasks(1).RESULT := 'E';

Line 231: PROCEDURE check_cartonization ( p_task_table IN WMS_TASK_MGMT_PUB.task_tab_type ,

227: set of input tasks.
228: Even if any one of the task fail validation, the API returns error.
229: */
230: --------------------------------------------------------------------------------------------------------
231: PROCEDURE check_cartonization ( p_task_table IN WMS_TASK_MGMT_PUB.task_tab_type ,
232: p_new_carton_lpn_id IN NUMBER DEFAULT NULL ,
233: x_error_msg OUT NOCOPY VARCHAR2 ,
234: x_return_status OUT NOCOPY VARCHAR2 )
235: IS

Line 535: PROCEDURE modify_single_task( p_task_rec IN WMS_TASK_MGMT_PUB.task_output_rectype,

531: /*This procedure checks if the various attributes that are passed can be updated
532: on the provided task*/
533: -------------------------------------------------------------------------------------------------------------------
534:
535: PROCEDURE modify_single_task( p_task_rec IN WMS_TASK_MGMT_PUB.task_output_rectype,
536: P_new_task_status IN NUMBER DEFAULT NULL,
537: P_new_task_priority IN NUMBER DEFAULT NULL,
538: P_new_task_type IN VARCHAR2 DEFAULT NULL,
539: P_new_carton_lpn_id IN NUMBER DEFAULT NULL,

Line 541: p_output_task_rec OUT NOCOPY WMS_TASK_MGMT_PUB.task_output_rectype,

537: P_new_task_priority IN NUMBER DEFAULT NULL,
538: P_new_task_type IN VARCHAR2 DEFAULT NULL,
539: P_new_carton_lpn_id IN NUMBER DEFAULT NULL,
540: p_new_operation_plan_id IN NUMBER DEFAULT NULL,
541: p_output_task_rec OUT NOCOPY WMS_TASK_MGMT_PUB.task_output_rectype,
542: p_op_plan_rec IN WMS_TASK_MGMT_PUB.op_plan_rec)
543: IS
544: l_lpn VARCHAR2(30);
545: l_return_status VARCHAR2(10);

Line 542: p_op_plan_rec IN WMS_TASK_MGMT_PUB.op_plan_rec)

538: P_new_task_type IN VARCHAR2 DEFAULT NULL,
539: P_new_carton_lpn_id IN NUMBER DEFAULT NULL,
540: p_new_operation_plan_id IN NUMBER DEFAULT NULL,
541: p_output_task_rec OUT NOCOPY WMS_TASK_MGMT_PUB.task_output_rectype,
542: p_op_plan_rec IN WMS_TASK_MGMT_PUB.op_plan_rec)
543: IS
544: l_lpn VARCHAR2(30);
545: l_return_status VARCHAR2(10);
546: l_count NUMBER DEFAULT 0;

Line 1039: x_task_table OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type )IS

1035:
1036: -------------------------------------------------------------------------------------------------------------------
1037: /*This procedure is to create a dummy task table with only the task_idThis will be used if user gives the task_id as input.*/
1038: PROCEDURE Create_Task_Table ( p_transaction_number IN NUMBER DEFAULT NULL ,
1039: x_task_table OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type )IS
1040:
1041: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
1042: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
1043: BEGIN

Line 1041: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;

1037: /*This procedure is to create a dummy task table with only the task_idThis will be used if user gives the task_id as input.*/
1038: PROCEDURE Create_Task_Table ( p_transaction_number IN NUMBER DEFAULT NULL ,
1039: x_task_table OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type )IS
1040:
1041: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
1042: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
1043: BEGIN
1044: l_task_rec.TRANSACTION_NUMBER := p_transaction_number;
1045: l_task_table(1) := l_task_rec ;

Line 1042: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;

1038: PROCEDURE Create_Task_Table ( p_transaction_number IN NUMBER DEFAULT NULL ,
1039: x_task_table OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type )IS
1040:
1041: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
1042: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
1043: BEGIN
1044: l_task_rec.TRANSACTION_NUMBER := p_transaction_number;
1045: l_task_table(1) := l_task_rec ;
1046: x_task_table := l_task_table;

Line 1169: p_task_table IN WMS_TASK_MGMT_PUB.task_tab_type ,

1165:
1166: /*Main procedure for task validation. */
1167: PROCEDURE validate_tasks ( p_init_msg_list IN VARCHAR2 DEFAULT 'Y' ,
1168: p_transaction_number IN NUMBER DEFAULT NULL ,
1169: p_task_table IN WMS_TASK_MGMT_PUB.task_tab_type ,
1170: p_action IN VARCHAR2 DEFAULT NULL, --6850212
1171: x_wms_task OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
1172: x_return_status OUT NOCOPY VARCHAR2 ) IS
1173:

Line 1171: x_wms_task OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,

1167: PROCEDURE validate_tasks ( p_init_msg_list IN VARCHAR2 DEFAULT 'Y' ,
1168: p_transaction_number IN NUMBER DEFAULT NULL ,
1169: p_task_table IN WMS_TASK_MGMT_PUB.task_tab_type ,
1170: p_action IN VARCHAR2 DEFAULT NULL, --6850212
1171: x_wms_task OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
1172: x_return_status OUT NOCOPY VARCHAR2 ) IS
1173:
1174: l_validate_task_ret VARCHAR2(1) ;
1175: l_error_msg VARCHAR2(240);

Line 1176: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;

1172: x_return_status OUT NOCOPY VARCHAR2 ) IS
1173:
1174: l_validate_task_ret VARCHAR2(1) ;
1175: l_error_msg VARCHAR2(240);
1176: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
1177: BEGIN
1178: x_return_status := 'S';
1179: IF ( p_transaction_number IS NOT NULL ) THEN
1180: Create_Task_Table (p_transaction_number => p_transaction_number, --create a dummy table

Line 1206: /*PROCEDURE check_cartonization ( p_task_table IN WMS_TASK_MGMT_PUB.task_tab_type ,

1202: ---------------------------------------------------------------------------------------------------------
1203:
1204: /*This procedure checks if cartonization can be done on the taks.
1205: If the API returns success, then carton_lpn_id can be stamped on the tasks*/
1206: /*PROCEDURE check_cartonization ( p_task_table IN WMS_TASK_MGMT_PUB.task_tab_type ,
1207: p_new_carton_lpn_id IN NUMBER DEFAULT NULL ,
1208: x_error_msg OUT NOCOPY VARCHAR2 ,
1209: x_return_status OUT NOCOPY VARCHAR2 ) IS
1210:

Line 4071: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;

4067: l_rsv_uom VARCHAR2(3);
4068: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4069: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4070: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4071: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4072: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4073: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4074: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4075: l_mo_line_rec inv_move_order_pub.trolin_rec_type;

Line 4072: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;

4068: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4069: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4070: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4071: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4072: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4073: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4074: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4075: l_mo_line_rec inv_move_order_pub.trolin_rec_type;
4076: l_mo_type NUMBER;

Line 4463: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;

4459: l_rsv_uom VARCHAR2(3);
4460: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4461: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4462: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4463: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4464: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4465: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4466: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4467: l_debug NUMBER;

Line 4464: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;

4460: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4461: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4462: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4463: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4464: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4465: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4466: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4467: l_debug NUMBER;
4468: exc_not_deleted EXCEPTION;

Line 5058: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type ,

5054: The types of tasks that this API handles include Inbound, Outbound, Warehouse and Manufacturing Tasks.
5055:
5056: PROCEDURE delete_tasks ( p_transaction_number IN NUMBER DEFAULT NULL ,
5057: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
5058: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type ,
5059: x_undeleted_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
5060: x_return_status OUT NOCOPY VARCHAR2 ,
5061: x_msg_count OUT NOCOPY NUMBER ,
5062: x_msg_data OUT NOCOPY VARCHAR2 )

Line 5059: x_undeleted_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,

5055:
5056: PROCEDURE delete_tasks ( p_transaction_number IN NUMBER DEFAULT NULL ,
5057: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
5058: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type ,
5059: x_undeleted_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
5060: x_return_status OUT NOCOPY VARCHAR2 ,
5061: x_msg_count OUT NOCOPY NUMBER ,
5062: x_msg_data OUT NOCOPY VARCHAR2 )
5063:

Line 5078: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type ,

5074: -------------------------------------------------------------------------------------------------------------------*/
5075:
5076: PROCEDURE delete_tasks ( p_transaction_number IN NUMBER DEFAULT NULL ,
5077: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
5078: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type ,
5079: x_undeleted_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
5080: x_return_status OUT NOCOPY VARCHAR2 ,
5081: x_msg_count OUT NOCOPY NUMBER ,
5082: x_msg_data OUT NOCOPY VARCHAR2 ) IS

Line 5079: x_undeleted_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,

5075:
5076: PROCEDURE delete_tasks ( p_transaction_number IN NUMBER DEFAULT NULL ,
5077: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
5078: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type ,
5079: x_undeleted_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
5080: x_return_status OUT NOCOPY VARCHAR2 ,
5081: x_msg_count OUT NOCOPY NUMBER ,
5082: x_msg_data OUT NOCOPY VARCHAR2 ) IS
5083:

Line 5084: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;

5080: x_return_status OUT NOCOPY VARCHAR2 ,
5081: x_msg_count OUT NOCOPY NUMBER ,
5082: x_msg_data OUT NOCOPY VARCHAR2 ) IS
5083:
5084: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
5085: l_task_rec task_record_type ;
5086: x_task_rec task_record_type ;
5087: l_transaction_number NUMBER;
5088: l_transaction_record mtl_material_transactions_temp%rowtype ;

Line 5090: l_ret_task_table WMS_TASK_MGMT_PUB.task_tab_type ;

5086: x_task_rec task_record_type ;
5087: l_transaction_number NUMBER;
5088: l_transaction_record mtl_material_transactions_temp%rowtype ;
5089: /*Local variable for the validate_task API*/
5090: l_ret_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
5091: l_val_ret_status VARCHAR2(30);
5092: l_task_type NUMBER ;
5093: l_task_exists NUMBER :=0 ;
5094: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;

Line 5116: WMS_TASK_MGMT_PUB.validate_tasks( p_init_msg_list =>'Y' ,

5112: END IF;
5113: IF l_debug = 1 THEN
5114: debug_print('Values passed to delete_tasks p_transaction_number:'|| p_transaction_number );
5115: END IF ;
5116: WMS_TASK_MGMT_PUB.validate_tasks( p_init_msg_list =>'Y' ,
5117: p_transaction_number => l_transaction_number ,
5118: p_task_table => l_task_table ,
5119: x_wms_task => l_ret_task_table ,
5120: x_return_status => l_val_ret_status );

Line 6716: x_resultant_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,

6712: -------------------------------------------------------------------------------------------------------------------
6713: PROCEDURE split_task( p_source_transaction_number IN NUMBER DEFAULT NULL ,
6714: p_split_quantities IN task_qty_tbl_type ,
6715: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
6716: x_resultant_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
6717: x_resultant_task_details OUT NOCOPY task_detail_tbl_type ,
6718: x_return_status OUT NOCOPY VARCHAR2 ,
6719: x_msg_count OUT NOCOPY NUMBER ,
6720: x_msg_data OUT NOCOPY VARCHAR2 ) IS

Line 6764: l_new_tasks_output WMS_TASK_MGMT_PUB.task_tab_type;

6760: l_mol_num NUMBER;
6761: l_serial_control_code NUMBER;
6762: l_lot_control_code NUMBER;
6763: l_index NUMBER;
6764: l_new_tasks_output WMS_TASK_MGMT_PUB.task_tab_type;
6765: l_new_tasks_tbl WMS_TASK_MGMT_PUB.task_tab_type;
6766: x_task_table WMS_TASK_MGMT_PUB.task_tab_type;
6767: l_return_status VARCHAR2(10);
6768: l_msg_count NUMBER;

Line 6765: l_new_tasks_tbl WMS_TASK_MGMT_PUB.task_tab_type;

6761: l_serial_control_code NUMBER;
6762: l_lot_control_code NUMBER;
6763: l_index NUMBER;
6764: l_new_tasks_output WMS_TASK_MGMT_PUB.task_tab_type;
6765: l_new_tasks_tbl WMS_TASK_MGMT_PUB.task_tab_type;
6766: x_task_table WMS_TASK_MGMT_PUB.task_tab_type;
6767: l_return_status VARCHAR2(10);
6768: l_msg_count NUMBER;
6769: l_msg_data VARCHAR(200);

Line 6766: x_task_table WMS_TASK_MGMT_PUB.task_tab_type;

6762: l_lot_control_code NUMBER;
6763: l_index NUMBER;
6764: l_new_tasks_output WMS_TASK_MGMT_PUB.task_tab_type;
6765: l_new_tasks_tbl WMS_TASK_MGMT_PUB.task_tab_type;
6766: x_task_table WMS_TASK_MGMT_PUB.task_tab_type;
6767: l_return_status VARCHAR2(10);
6768: l_msg_count NUMBER;
6769: l_msg_data VARCHAR(200);
6770: l_validation_status VARCHAR2(10);

Line 7067: print_msg(l_procedure_name, 'Before calling WMS_TASK_MGMT_PUB.query_task');

7063: END IF;
7064: FOR i IN new_task_table.FIRST .. new_task_table.LAST
7065: LOOP
7066: IF g_debug = 1 THEN
7067: print_msg(l_procedure_name, 'Before calling WMS_TASK_MGMT_PUB.query_task');
7068: WMS_TASK_MGMT_PUB.query_task ( new_task_table(i).transaction_temp_id ,
7069: NULL ,
7070: l_new_tasks_tbl ,
7071: l_return_status ,

Line 7068: WMS_TASK_MGMT_PUB.query_task ( new_task_table(i).transaction_temp_id ,

7064: FOR i IN new_task_table.FIRST .. new_task_table.LAST
7065: LOOP
7066: IF g_debug = 1 THEN
7067: print_msg(l_procedure_name, 'Before calling WMS_TASK_MGMT_PUB.query_task');
7068: WMS_TASK_MGMT_PUB.query_task ( new_task_table(i).transaction_temp_id ,
7069: NULL ,
7070: l_new_tasks_tbl ,
7071: l_return_status ,
7072: l_msg_count ,

Line 7077: print_msg(l_procedure_name, 'WMS_TASK_MGMT_PUB.query_task returned success for task : ' || new_task_table(i).transaction_temp_id);

7073: l_msg_data );
7074:
7075: IF NVL(l_return_status,'N') = 'S' OR l_new_tasks_tbl.COUNT > 0 THEN
7076: IF g_debug = 1 THEN
7077: print_msg(l_procedure_name, 'WMS_TASK_MGMT_PUB.query_task returned success for task : ' || new_task_table(i).transaction_temp_id);
7078: END IF;
7079: IF l_new_tasks_tbl.COUNT > 0 THEN
7080: x_resultant_tasks(i) := l_new_tasks_tbl(1);
7081: END IF;

Line 7084: print_msg(l_procedure_name, 'WMS_TASK_MGMT_PUB.query_task returned error');

7080: x_resultant_tasks(i) := l_new_tasks_tbl(1);
7081: END IF;
7082: ELSE
7083: IF g_debug = 1 THEN
7084: print_msg(l_procedure_name, 'WMS_TASK_MGMT_PUB.query_task returned error');
7085: END IF;
7086: -- x_return_status := 'E';
7087: RAISE l_query_task_exception;
7088: END IF;

Line 7128: WMS_TASK_MGMT_PUB.query_task ( p_source_transaction_number ,

7124: IF g_debug = 1 THEN
7125: print_msg(l_procedure_name,'EXCEPTION BLOCK : Validate task returned error');
7126: END IF;
7127: x_return_status := 'S';
7128: WMS_TASK_MGMT_PUB.query_task ( p_source_transaction_number ,
7129: NULL ,
7130: l_new_tasks_tbl ,
7131: l_return_status ,
7132: l_msg_count ,

Line 7152: WMS_TASK_MGMT_PUB.query_task ( p_source_transaction_number ,

7148: IF g_debug = 1 THEN
7149: print_msg(l_procedure_name,'EXCEPTION BLOCK : Lot split error');
7150: END IF;
7151: x_return_status := 'S';
7152: WMS_TASK_MGMT_PUB.query_task ( p_source_transaction_number ,
7153: NULL ,
7154: l_new_tasks_tbl ,
7155: l_return_status ,
7156: l_msg_count ,

Line 7173: WMS_TASK_MGMT_PUB.query_task ( p_source_transaction_number ,

7169: IF g_debug = 1 THEN
7170: print_msg(l_procedure_name,'EXCEPTION BLOCK : Validate quantities returned error');
7171: END IF;
7172: x_return_status := 'S';
7173: WMS_TASK_MGMT_PUB.query_task ( p_source_transaction_number ,
7174: NULL ,
7175: l_new_tasks_tbl ,
7176: l_return_status ,
7177: l_msg_count ,

Line 7197: WMS_TASK_MGMT_PUB.query_task ( p_source_transaction_number ,

7193: print_msg(l_procedure_name,'EXCEPTION BLOCK : Query task returned error, ROLLING BACK THE TRANSACTIONS');
7194: END IF;
7195: x_return_status := 'S';
7196: ROLLBACK TO wms_split_task;
7197: WMS_TASK_MGMT_PUB.query_task ( p_source_transaction_number ,
7198: NULL ,
7199: l_new_tasks_tbl ,
7200: l_return_status ,
7201: l_msg_count ,

Line 7281: p_task_table IN WMS_TASK_MGMT_PUB.task_tab_type ,

7277:
7278: */
7279: -------------------------------------------------------------------------------------------------------------------
7280: PROCEDURE modify_task ( p_transaction_number IN NUMBER DEFAULT NULL ,
7281: p_task_table IN WMS_TASK_MGMT_PUB.task_tab_type ,
7282: p_new_task_status IN NUMBER DEFAULT NULL ,
7283: p_new_task_priority IN NUMBER DEFAULT NULL ,
7284: p_new_task_type IN VARCHAR2 DEFAULT NULL ,
7285: p_new_carton_lpn_id IN NUMBER DEFAULT NULL ,

Line 7289: x_updated_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,

7285: p_new_carton_lpn_id IN NUMBER DEFAULT NULL ,
7286: p_new_operation_plan_id IN NUMBER DEFAULT NULL ,
7287: p_person_id IN NUMBER DEFAULT NULL ,
7288: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
7289: x_updated_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
7290: x_return_status OUT NOCOPY VARCHAR2 ,
7291: x_msg_count OUT NOCOPY NUMBER ,
7292: x_msg_data OUT NOCOPY VARCHAR2 ) IS
7293:

Line 7294: temp_task_tab WMS_TASK_MGMT_PUB.task_tab_type;

7290: x_return_status OUT NOCOPY VARCHAR2 ,
7291: x_msg_count OUT NOCOPY NUMBER ,
7292: x_msg_data OUT NOCOPY VARCHAR2 ) IS
7293:
7294: temp_task_tab WMS_TASK_MGMT_PUB.task_tab_type;
7295: CURSOR op_plan_cur(c_op_plan_id NUMBER)
7296: IS
7297: SELECT system_task_type ,
7298: organization_id ,

Line 7322: p_temp_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;

7318: P_msg_count NUMBER;
7319: l_msg_count NUMBER;
7320: P_msg_data VARCHAR2(30);
7321: l_valid_task_counter NUMBER;
7322: p_temp_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
7323: l_op_plan_rec WMS_TASK_MGMT_PUB.op_plan_rec;
7324: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7325: l_api_name VARCHAR2(1000) := 'MODIFY_TASK';
7326: l_msg VARCHAR2(2000);

Line 7323: l_op_plan_rec WMS_TASK_MGMT_PUB.op_plan_rec;

7319: l_msg_count NUMBER;
7320: P_msg_data VARCHAR2(30);
7321: l_valid_task_counter NUMBER;
7322: p_temp_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
7323: l_op_plan_rec WMS_TASK_MGMT_PUB.op_plan_rec;
7324: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7325: l_api_name VARCHAR2(1000) := 'MODIFY_TASK';
7326: l_msg VARCHAR2(2000);
7327: l_err_msg VARCHAR2(2000);

Line 7330: l_updated_tasks WMS_TASK_MGMT_PUB.task_tab_type;

7326: l_msg VARCHAR2(2000);
7327: l_err_msg VARCHAR2(2000);
7328: l_error_msg VARCHAR2(2000);
7329: l_lock VARCHAR2(2);
7330: l_updated_tasks WMS_TASK_MGMT_PUB.task_tab_type;
7331:
7332:
7333: TYPE TransactionNumber IS TABLE OF NUMBER
7334: INDEX BY BINARY_INTEGER;

Line 7463: WMS_TASK_MGMT_PUB.query_task( p_transaction_number => l_updated_tasks(i).transaction_number,

7459: FOR i IN 1..l_updated_tasks.count
7460: LOOP--Loop starts
7461: IF (nvl(l_updated_tasks(i).RESULT,'X')<> 'E') THEN
7462: temp_task_tab.delete;-- := NULL; --flush the temporary table
7463: WMS_TASK_MGMT_PUB.query_task( p_transaction_number => l_updated_tasks(i).transaction_number,
7464: p_query_name => NULL,
7465: x_task_tab => temp_task_tab,
7466: x_return_status => p_return_sts,
7467: x_msg_count => p_msg_count,

Line 7805: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type,

7801:
7802: PROCEDURE cancel_task(
7803: p_transaction_number IN NUMBER DEFAULT NULL,
7804: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
7805: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type,
7806: x_unprocessed_crossdock_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type,
7807: x_return_status OUT NOCOPY VARCHAR2,
7808: x_msg_count OUT NOCOPY NUMBER,
7809: x_msg_data OUT NOCOPY VARCHAR2

Line 7806: x_unprocessed_crossdock_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type,

7802: PROCEDURE cancel_task(
7803: p_transaction_number IN NUMBER DEFAULT NULL,
7804: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
7805: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type,
7806: x_unprocessed_crossdock_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type,
7807: x_return_status OUT NOCOPY VARCHAR2,
7808: x_msg_count OUT NOCOPY NUMBER,
7809: x_msg_data OUT NOCOPY VARCHAR2
7810: )

Line 7814: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;

7810: )
7811: IS
7812:
7813: l_val_ret_status VARCHAR2(10) ;
7814: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
7815: l_transaction_number NUMBER ;
7816: l_ret_task_table WMS_TASK_MGMT_PUB.task_tab_type;
7817: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7818: l_unprocessed_crossdock_count NUMBER := 1;

Line 7816: l_ret_task_table WMS_TASK_MGMT_PUB.task_tab_type;

7812:
7813: l_val_ret_status VARCHAR2(10) ;
7814: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
7815: l_transaction_number NUMBER ;
7816: l_ret_task_table WMS_TASK_MGMT_PUB.task_tab_type;
7817: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7818: l_unprocessed_crossdock_count NUMBER := 1;
7819: l_msg VARCHAR2(2000);
7820:

Line 7834: WMS_TASK_MGMT_PUB.validate_tasks( p_transaction_number => l_transaction_number ,

7830: IF l_debug = 1 THEN
7831: inv_trx_util_pub.trace('CANCEL_TASK: Enter...');
7832: END IF;
7833:
7834: WMS_TASK_MGMT_PUB.validate_tasks( p_transaction_number => l_transaction_number ,
7835: p_task_table => l_task_table ,
7836: x_wms_task => l_ret_task_table ,
7837: x_return_status => l_val_ret_status );
7838: IF l_debug = 1 THEN

Line 7922: END WMS_TASK_MGMT_PUB;

7918: ROLLBACK TO SAVEPOINT1;
7919: RETURN;
7920: END cancel_task;
7921:
7922: END WMS_TASK_MGMT_PUB;