[Home] [Help]
3: -- Start of Comments
4: -- Package name : CSP_MO_MTLTXNS_UTIL
5: -- Purpose : This package includes the procedures that handle material transactions associated with any move orders.
6: -- History
7: -- 08-Feb-00, Add standard messages and validations.
8: -- 29-Dec-99, Vernon Lou.
9: --
10: -- NOTE :
11: -- End of Comments
67: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
68: -- initialize message list
69: FND_MSG_PUB.initialize;
70: END IF;
71: -- Standard call to check for call compatibility.
72: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
73: p_api_version_number,
74: l_api_name,
75: G_PKG_NAME)
311: -- is not allowed but will be implemented in the future release.
312: -- klou 05-Apr-2000 Add over receiving and receipt short.
313: -- klou 22-Mar-2000 Add logic to move data from the temp table to the interface table. This is required for
314: -- calling the process_online procedure.
315: -- klou 08-Feb-2000 Add standard messages.
316: -- klou 22-Jan-2000 Include codes to handle material transactions for item under serial and/or lot control.
317: -- klou 07-Jan-2000 include codes to check whether the quantity_received exceed the
318: -- (shipped_quantity - quantity_received). add p_to_subiventroy_code
319: -- and p_to_locator_id.
368: l_packlist_line_status VARCHAR2(30) := NULL;
369: l_count NUMBER;
370:
371: -- for inserting data, the validation_level should be none
372: -- because we do not want to call core apps standard validations.
373: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
374: l_move_order_line_id NUMBER;
375: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
376: l_csp_mtltxn_over_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
587: TASK_GROUP_ID ,
588: PICK_SLIP_NUMBER ,
589: RESERVATION_ID ,
590: TRANSACTION_STATUS ,
591: STANDARD_OPERATION_ID ,
592: TASK_PRIORITY ,
593: -- ADDED by phegde 02/23
594: WMS_TASK_TYPE ,
595: PARENT_LINE_ID
678: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
679: -- initialize message list
680: FND_MSG_PUB.initialize;
681: END IF;
682: -- Standard call to check for call compatibility.
683: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
684: p_api_version_number,
685: l_api_name,
686: G_PKG_NAME)
2401: TASK_GROUP_ID ,
2402: PICK_SLIP_NUMBER ,
2403: RESERVATION_ID ,
2404: TRANSACTION_STATUS ,
2405: STANDARD_OPERATION_ID ,
2406: TASK_PRIORITY ,
2407: -- ADDED by phegde 02/23
2408: WMS_TASK_TYPE ,
2409: PARENT_LINE_ID
2788: TASK_GROUP_ID ,
2789: PICK_SLIP_NUMBER ,
2790: RESERVATION_ID ,
2791: TRANSACTION_STATUS ,
2792: STANDARD_OPERATION_ID ,
2793: TASK_PRIORITY ,
2794: -- ADDED by phegde 02/23
2795: WMS_TASK_TYPE ,
2796: PARENT_LINE_ID