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.13 2008/05/05 07:35:55 pbonthu noship $ */
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.13 2008/05/05 07:35:55 pbonthu noship $ */
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 3982: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;

3978: l_rsv_uom VARCHAR2(3);
3979: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
3980: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
3981: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
3982: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
3983: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
3984: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
3985: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
3986: l_mo_line_rec inv_move_order_pub.trolin_rec_type;

Line 3983: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;

3979: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
3980: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
3981: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
3982: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
3983: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
3984: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
3985: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
3986: l_mo_line_rec inv_move_order_pub.trolin_rec_type;
3987: l_mo_type NUMBER;

Line 4374: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;

4370: l_rsv_uom VARCHAR2(3);
4371: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4372: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4373: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4374: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4375: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4376: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4377: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4378: l_debug NUMBER;

Line 4375: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;

4371: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4372: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
4373: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4374: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4375: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4376: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4377: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4378: l_debug NUMBER;
4379: exc_not_deleted EXCEPTION;

Line 4969: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type ,

4965: The types of tasks that this API handles include Inbound, Outbound, Warehouse and Manufacturing Tasks.
4966:
4967: PROCEDURE delete_tasks ( p_transaction_number IN NUMBER DEFAULT NULL ,
4968: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
4969: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type ,
4970: x_undeleted_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
4971: x_return_status OUT NOCOPY VARCHAR2 ,
4972: x_msg_count OUT NOCOPY NUMBER ,
4973: x_msg_data OUT NOCOPY VARCHAR2 )

Line 4970: x_undeleted_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,

4966:
4967: PROCEDURE delete_tasks ( p_transaction_number IN NUMBER DEFAULT NULL ,
4968: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
4969: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type ,
4970: x_undeleted_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
4971: x_return_status OUT NOCOPY VARCHAR2 ,
4972: x_msg_count OUT NOCOPY NUMBER ,
4973: x_msg_data OUT NOCOPY VARCHAR2 )
4974:

Line 4989: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type ,

4985: -------------------------------------------------------------------------------------------------------------------*/
4986:
4987: PROCEDURE delete_tasks ( p_transaction_number IN NUMBER DEFAULT NULL ,
4988: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
4989: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type ,
4990: x_undeleted_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
4991: x_return_status OUT NOCOPY VARCHAR2 ,
4992: x_msg_count OUT NOCOPY NUMBER ,
4993: x_msg_data OUT NOCOPY VARCHAR2 ) IS

Line 4990: x_undeleted_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,

4986:
4987: PROCEDURE delete_tasks ( p_transaction_number IN NUMBER DEFAULT NULL ,
4988: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
4989: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type ,
4990: x_undeleted_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
4991: x_return_status OUT NOCOPY VARCHAR2 ,
4992: x_msg_count OUT NOCOPY NUMBER ,
4993: x_msg_data OUT NOCOPY VARCHAR2 ) IS
4994:

Line 4995: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;

4991: x_return_status OUT NOCOPY VARCHAR2 ,
4992: x_msg_count OUT NOCOPY NUMBER ,
4993: x_msg_data OUT NOCOPY VARCHAR2 ) IS
4994:
4995: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4996: l_task_rec task_record_type ;
4997: x_task_rec task_record_type ;
4998: l_transaction_number NUMBER;
4999: l_transaction_record mtl_material_transactions_temp%rowtype ;

Line 5001: l_ret_task_table WMS_TASK_MGMT_PUB.task_tab_type ;

4997: x_task_rec task_record_type ;
4998: l_transaction_number NUMBER;
4999: l_transaction_record mtl_material_transactions_temp%rowtype ;
5000: /*Local variable for the validate_task API*/
5001: l_ret_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
5002: l_val_ret_status VARCHAR2(30);
5003: l_task_type NUMBER ;
5004: l_task_exists NUMBER :=0 ;
5005: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;

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

5023: END IF;
5024: IF l_debug = 1 THEN
5025: debug_print('Values passed to delete_tasks p_transaction_number:'|| p_transaction_number );
5026: END IF ;
5027: WMS_TASK_MGMT_PUB.validate_tasks( p_init_msg_list =>'Y' ,
5028: p_transaction_number => l_transaction_number ,
5029: p_task_table => l_task_table ,
5030: x_wms_task => l_ret_task_table ,
5031: x_return_status => l_val_ret_status );

Line 6621: x_resultant_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,

6617: -------------------------------------------------------------------------------------------------------------------
6618: PROCEDURE split_task( p_source_transaction_number IN NUMBER DEFAULT NULL ,
6619: p_split_quantities IN task_qty_tbl_type ,
6620: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
6621: x_resultant_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
6622: x_resultant_task_details OUT NOCOPY task_detail_tbl_type ,
6623: x_return_status OUT NOCOPY VARCHAR2 ,
6624: x_msg_count OUT NOCOPY NUMBER ,
6625: x_msg_data OUT NOCOPY VARCHAR2 ) IS

Line 6669: l_new_tasks_output WMS_TASK_MGMT_PUB.task_tab_type;

6665: l_mol_num NUMBER;
6666: l_serial_control_code NUMBER;
6667: l_lot_control_code NUMBER;
6668: l_index NUMBER;
6669: l_new_tasks_output WMS_TASK_MGMT_PUB.task_tab_type;
6670: l_new_tasks_tbl WMS_TASK_MGMT_PUB.task_tab_type;
6671: x_task_table WMS_TASK_MGMT_PUB.task_tab_type;
6672: l_return_status VARCHAR2(10);
6673: l_msg_count NUMBER;

Line 6670: l_new_tasks_tbl WMS_TASK_MGMT_PUB.task_tab_type;

6666: l_serial_control_code NUMBER;
6667: l_lot_control_code NUMBER;
6668: l_index NUMBER;
6669: l_new_tasks_output WMS_TASK_MGMT_PUB.task_tab_type;
6670: l_new_tasks_tbl WMS_TASK_MGMT_PUB.task_tab_type;
6671: x_task_table WMS_TASK_MGMT_PUB.task_tab_type;
6672: l_return_status VARCHAR2(10);
6673: l_msg_count NUMBER;
6674: l_msg_data VARCHAR(200);

Line 6671: x_task_table WMS_TASK_MGMT_PUB.task_tab_type;

6667: l_lot_control_code NUMBER;
6668: l_index NUMBER;
6669: l_new_tasks_output WMS_TASK_MGMT_PUB.task_tab_type;
6670: l_new_tasks_tbl WMS_TASK_MGMT_PUB.task_tab_type;
6671: x_task_table WMS_TASK_MGMT_PUB.task_tab_type;
6672: l_return_status VARCHAR2(10);
6673: l_msg_count NUMBER;
6674: l_msg_data VARCHAR(200);
6675: l_validation_status VARCHAR2(10);

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

6964: END IF;
6965: FOR i IN new_task_table.FIRST .. new_task_table.LAST
6966: LOOP
6967: IF g_debug = 1 THEN
6968: print_msg(l_procedure_name, 'Before calling WMS_TASK_MGMT_PUB.query_task');
6969: WMS_TASK_MGMT_PUB.query_task ( new_task_table(i).transaction_temp_id ,
6970: NULL ,
6971: l_new_tasks_tbl ,
6972: l_return_status ,

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

6965: FOR i IN new_task_table.FIRST .. new_task_table.LAST
6966: LOOP
6967: IF g_debug = 1 THEN
6968: print_msg(l_procedure_name, 'Before calling WMS_TASK_MGMT_PUB.query_task');
6969: WMS_TASK_MGMT_PUB.query_task ( new_task_table(i).transaction_temp_id ,
6970: NULL ,
6971: l_new_tasks_tbl ,
6972: l_return_status ,
6973: l_msg_count ,

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

6974: l_msg_data );
6975:
6976: IF NVL(l_return_status,'N') = 'S' OR l_new_tasks_tbl.COUNT > 0 THEN
6977: IF g_debug = 1 THEN
6978: print_msg(l_procedure_name, 'WMS_TASK_MGMT_PUB.query_task returned success for task : ' || new_task_table(i).transaction_temp_id);
6979: END IF;
6980: IF l_new_tasks_tbl.COUNT > 0 THEN
6981: x_resultant_tasks(i) := l_new_tasks_tbl(1);
6982: END IF;

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

6981: x_resultant_tasks(i) := l_new_tasks_tbl(1);
6982: END IF;
6983: ELSE
6984: IF g_debug = 1 THEN
6985: print_msg(l_procedure_name, 'WMS_TASK_MGMT_PUB.query_task returned error');
6986: END IF;
6987: -- x_return_status := 'E';
6988: RAISE l_query_task_exception;
6989: END IF;

Line 7029: WMS_TASK_MGMT_PUB.query_task ( p_source_transaction_number ,

7025: IF g_debug = 1 THEN
7026: print_msg(l_procedure_name,'EXCEPTION BLOCK : Validate task returned error');
7027: END IF;
7028: x_return_status := 'S';
7029: WMS_TASK_MGMT_PUB.query_task ( p_source_transaction_number ,
7030: NULL ,
7031: l_new_tasks_tbl ,
7032: l_return_status ,
7033: l_msg_count ,

Line 7053: WMS_TASK_MGMT_PUB.query_task ( p_source_transaction_number ,

7049: IF g_debug = 1 THEN
7050: print_msg(l_procedure_name,'EXCEPTION BLOCK : Lot split error');
7051: END IF;
7052: x_return_status := 'S';
7053: WMS_TASK_MGMT_PUB.query_task ( p_source_transaction_number ,
7054: NULL ,
7055: l_new_tasks_tbl ,
7056: l_return_status ,
7057: l_msg_count ,

Line 7074: WMS_TASK_MGMT_PUB.query_task ( p_source_transaction_number ,

7070: IF g_debug = 1 THEN
7071: print_msg(l_procedure_name,'EXCEPTION BLOCK : Validate quantities returned error');
7072: END IF;
7073: x_return_status := 'S';
7074: WMS_TASK_MGMT_PUB.query_task ( p_source_transaction_number ,
7075: NULL ,
7076: l_new_tasks_tbl ,
7077: l_return_status ,
7078: l_msg_count ,

Line 7098: WMS_TASK_MGMT_PUB.query_task ( p_source_transaction_number ,

7094: print_msg(l_procedure_name,'EXCEPTION BLOCK : Query task returned error, ROLLING BACK THE TRANSACTIONS');
7095: END IF;
7096: x_return_status := 'S';
7097: ROLLBACK TO wms_split_task;
7098: WMS_TASK_MGMT_PUB.query_task ( p_source_transaction_number ,
7099: NULL ,
7100: l_new_tasks_tbl ,
7101: l_return_status ,
7102: l_msg_count ,

Line 7182: p_task_table IN WMS_TASK_MGMT_PUB.task_tab_type ,

7178:
7179: */
7180: -------------------------------------------------------------------------------------------------------------------
7181: PROCEDURE modify_task ( p_transaction_number IN NUMBER DEFAULT NULL ,
7182: p_task_table IN WMS_TASK_MGMT_PUB.task_tab_type ,
7183: p_new_task_status IN NUMBER DEFAULT NULL ,
7184: p_new_task_priority IN NUMBER DEFAULT NULL ,
7185: p_new_task_type IN VARCHAR2 DEFAULT NULL ,
7186: p_new_carton_lpn_id IN NUMBER DEFAULT NULL ,

Line 7190: x_updated_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,

7186: p_new_carton_lpn_id IN NUMBER DEFAULT NULL ,
7187: p_new_operation_plan_id IN NUMBER DEFAULT NULL ,
7188: p_person_id IN NUMBER DEFAULT NULL ,
7189: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
7190: x_updated_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
7191: x_return_status OUT NOCOPY VARCHAR2 ,
7192: x_msg_count OUT NOCOPY NUMBER ,
7193: x_msg_data OUT NOCOPY VARCHAR2 ) IS
7194:

Line 7195: temp_task_tab WMS_TASK_MGMT_PUB.task_tab_type;

7191: x_return_status OUT NOCOPY VARCHAR2 ,
7192: x_msg_count OUT NOCOPY NUMBER ,
7193: x_msg_data OUT NOCOPY VARCHAR2 ) IS
7194:
7195: temp_task_tab WMS_TASK_MGMT_PUB.task_tab_type;
7196: CURSOR op_plan_cur(c_op_plan_id NUMBER)
7197: IS
7198: SELECT system_task_type ,
7199: organization_id ,

Line 7223: p_temp_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;

7219: P_msg_count NUMBER;
7220: l_msg_count NUMBER;
7221: P_msg_data VARCHAR2(30);
7222: l_valid_task_counter NUMBER;
7223: p_temp_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
7224: l_op_plan_rec WMS_TASK_MGMT_PUB.op_plan_rec;
7225: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7226: l_api_name VARCHAR2(1000) := 'MODIFY_TASK';
7227: l_msg VARCHAR2(2000);

Line 7224: l_op_plan_rec WMS_TASK_MGMT_PUB.op_plan_rec;

7220: l_msg_count NUMBER;
7221: P_msg_data VARCHAR2(30);
7222: l_valid_task_counter NUMBER;
7223: p_temp_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
7224: l_op_plan_rec WMS_TASK_MGMT_PUB.op_plan_rec;
7225: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7226: l_api_name VARCHAR2(1000) := 'MODIFY_TASK';
7227: l_msg VARCHAR2(2000);
7228: l_err_msg VARCHAR2(2000);

Line 7231: l_updated_tasks WMS_TASK_MGMT_PUB.task_tab_type;

7227: l_msg VARCHAR2(2000);
7228: l_err_msg VARCHAR2(2000);
7229: l_error_msg VARCHAR2(2000);
7230: l_lock VARCHAR2(2);
7231: l_updated_tasks WMS_TASK_MGMT_PUB.task_tab_type;
7232:
7233:
7234: TYPE TransactionNumber IS TABLE OF NUMBER
7235: INDEX BY BINARY_INTEGER;

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

7360: FOR i IN 1..l_updated_tasks.count
7361: LOOP--Loop starts
7362: IF (nvl(l_updated_tasks(i).RESULT,'X')<> 'E') THEN
7363: temp_task_tab.delete;-- := NULL; --flush the temporary table
7364: WMS_TASK_MGMT_PUB.query_task( p_transaction_number => l_updated_tasks(i).transaction_number,
7365: p_query_name => NULL,
7366: x_task_tab => temp_task_tab,
7367: x_return_status => p_return_sts,
7368: x_msg_count => p_msg_count,

Line 7706: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type,

7702:
7703: PROCEDURE cancel_task(
7704: p_transaction_number IN NUMBER DEFAULT NULL,
7705: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
7706: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type,
7707: x_unprocessed_crossdock_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type,
7708: x_return_status OUT NOCOPY VARCHAR2,
7709: x_msg_count OUT NOCOPY NUMBER,
7710: x_msg_data OUT NOCOPY VARCHAR2

Line 7707: x_unprocessed_crossdock_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type,

7703: PROCEDURE cancel_task(
7704: p_transaction_number IN NUMBER DEFAULT NULL,
7705: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
7706: p_wms_task IN WMS_TASK_MGMT_PUB.task_tab_type,
7707: x_unprocessed_crossdock_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type,
7708: x_return_status OUT NOCOPY VARCHAR2,
7709: x_msg_count OUT NOCOPY NUMBER,
7710: x_msg_data OUT NOCOPY VARCHAR2
7711: )

Line 7715: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;

7711: )
7712: IS
7713:
7714: l_val_ret_status VARCHAR2(10) ;
7715: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
7716: l_transaction_number NUMBER ;
7717: l_ret_task_table WMS_TASK_MGMT_PUB.task_tab_type;
7718: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7719: l_unprocessed_crossdock_count NUMBER := 1;

Line 7717: l_ret_task_table WMS_TASK_MGMT_PUB.task_tab_type;

7713:
7714: l_val_ret_status VARCHAR2(10) ;
7715: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
7716: l_transaction_number NUMBER ;
7717: l_ret_task_table WMS_TASK_MGMT_PUB.task_tab_type;
7718: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7719: l_unprocessed_crossdock_count NUMBER := 1;
7720: l_msg VARCHAR2(2000);
7721:

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

7731: IF l_debug = 1 THEN
7732: inv_trx_util_pub.trace('CANCEL_TASK: Enter...');
7733: END IF;
7734:
7735: WMS_TASK_MGMT_PUB.validate_tasks( p_transaction_number => l_transaction_number ,
7736: p_task_table => l_task_table ,
7737: x_wms_task => l_ret_task_table ,
7738: x_return_status => l_val_ret_status );
7739: IF l_debug = 1 THEN

Line 7823: END WMS_TASK_MGMT_PUB;

7819: ROLLBACK TO SAVEPOINT1;
7820: RETURN;
7821: END cancel_task;
7822:
7823: END WMS_TASK_MGMT_PUB;