[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;
2556: shipment_number ,
2557: org_cost_group_id ,
2558: cost_type_id ,
2559: transaction_status ,
2560: standard_operation_id ,
2561: task_priority ,
2562: wms_task_type ,
2563: parent_line_id ,
2564: source_lot_number ,
2794: shipment_number ,
2795: org_cost_group_id ,
2796: cost_type_id ,
2797: transaction_status ,
2798: standard_operation_id ,
2799: task_priority ,
2800: wms_task_type ,
2801: parent_line_id ,
2802: source_lot_number ,
7728: SET wms_task_status = l_mmtt_status_id_table(i) ,
7729: operation_plan_id = l_mmtt_operation_plan_id_table(i),
7730: cartonization_id = l_mmtt_cartonization_id_table(i) ,
7731: task_priority = l_mmtt_priority_table(i) ,
7732: standard_operation_id = l_mmtt_usertask_type_id_table(i)
7733: WHERE transaction_temp_id = l_mmtt_transaction_num_table(i);
7734: END IF;
7735:
7736: IF (l_mcce_transaction_num_table.COUNT > 0) THEN
7736: IF (l_mcce_transaction_num_table.COUNT > 0) THEN
7737: FORALL i in 1..l_mcce_transaction_num_table.COUNT
7738: UPDATE mtl_cycle_count_entries
7739: SET task_priority = l_mcce_priority_table(i) ,
7740: standard_operation_id = l_mcce_usertask_type_id_table(i)
7741: WHERE cycle_count_entry_id = l_mcce_transaction_num_table(i);
7742: END IF;
7743:
7744: IF (l_wdt_transaction_num_table.COUNT > 0) THEN