[Home] [Help]
557:
558: Cursor c_usr_task_type(p_std_task_type NUMBER,
559: p_operation_code VARCHAR2,
560: p_org_id NUMBER) IS
561: SELECT standard_operation_id
562: FROM BOM_STANDARD_OPERATIONS_V
563: WHERE wms_task_type = p_std_task_type
564: AND operation_code = p_operation_code
565: AND organization_id = p_org_id ;
558: Cursor c_usr_task_type(p_std_task_type NUMBER,
559: p_operation_code VARCHAR2,
560: p_org_id NUMBER) IS
561: SELECT standard_operation_id
562: FROM BOM_STANDARD_OPERATIONS_V
563: WHERE wms_task_type = p_std_task_type
564: AND operation_code = p_operation_code
565: AND organization_id = p_org_id ;
566:
806: IF c_usr_task_type%NOTFOUND THEN
807: fnd_message.set_name('WMS', 'WMS_INVALID_USER_TASK');--new message
808: fnd_msg_pub.ADD;
809: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
810: l_msg := 'Standard task type associated with the user task is different from the current standard task type';
811: IF(l_debug = 1) THEN
812: inv_trx_util_pub.trace(l_api_name|| ': '||l_msg);
813: END IF;
814: p_output_task_rec.RESULT := 'E';
844: WHERE OPERATION_PLAN_ID=p_task_rec.OPERATION_PLAN_ID;
845:
846: IF (l_operation_plan_type_id IS NOT NULL ) THEN
847: /* An inspection operation plan can be replaced with another inspection operation plan and
848: like wise a standard operation plan can be replaced only with another Standard operation plan. */
849: /*only in case of cross dock tasks, a cross dock operation can be replaced with another cross dock operation plan or
850: it can also be replaced with a non-cross dock Operation plan */
851: IF ( l_operation_plan_type_id = 3 OR
852: ( p_op_plan_rec.plan_type_id = 1 AND l_operation_plan_type_id = 1) OR
857: fnd_msg_pub.ADD;
858: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
859: p_output_task_rec.RESULT := 'E';
860: p_output_task_rec.ERROR := l_err_msg;
861: l_msg := 'Inspection/Standard operation plan can only be replaced with another Inspection/Standard operation plan
862: and cross dock operation can be replaced with another cross dock operation plan or non-cross dock Operation plan ';
863: IF(l_debug = 1) THEN
864: inv_trx_util_pub.trace(l_api_name|| ': '||l_msg);
865: END IF;
2469: shipment_number ,
2470: org_cost_group_id ,
2471: cost_type_id ,
2472: transaction_status ,
2473: standard_operation_id ,
2474: task_priority ,
2475: wms_task_type ,
2476: parent_line_id ,
2477: source_lot_number ,
2706: shipment_number ,
2707: org_cost_group_id ,
2708: cost_type_id ,
2709: transaction_status ,
2710: standard_operation_id ,
2711: task_priority ,
2712: wms_task_type ,
2713: parent_line_id ,
2714: source_lot_number ,
7629: SET wms_task_status = l_mmtt_status_id_table(i) ,
7630: operation_plan_id = l_mmtt_operation_plan_id_table(i),
7631: cartonization_id = l_mmtt_cartonization_id_table(i) ,
7632: task_priority = l_mmtt_priority_table(i) ,
7633: standard_operation_id = l_mmtt_usertask_type_id_table(i)
7634: WHERE transaction_temp_id = l_mmtt_transaction_num_table(i);
7635: END IF;
7636:
7637: IF (l_mcce_transaction_num_table.COUNT > 0) THEN
7637: IF (l_mcce_transaction_num_table.COUNT > 0) THEN
7638: FORALL i in 1..l_mcce_transaction_num_table.COUNT
7639: UPDATE mtl_cycle_count_entries
7640: SET task_priority = l_mcce_priority_table(i) ,
7641: standard_operation_id = l_mcce_usertask_type_id_table(i)
7642: WHERE cycle_count_entry_id = l_mcce_transaction_num_table(i);
7643: END IF;
7644:
7645: IF (l_wdt_transaction_num_table.COUNT > 0) THEN