DBA Data[Home] [Help]

APPS.GMO_DISPENSE_PVT dependencies on FND_API

Line 282: X_RESERVATION_UOM_CONVERTIBLE := FND_API.G_FALSE;

278: null,
279: null);
280:
281: if(l_mtl_reserved_qty = -99999) then
282: X_RESERVATION_UOM_CONVERTIBLE := FND_API.G_FALSE;
283: else
284: X_RESERVATION_UOM_CONVERTIBLE := FND_API.G_TRUE;
285: end if ;
286: X_RESERVED_QUANTITY := l_mtl_reserved_qty;

Line 284: X_RESERVATION_UOM_CONVERTIBLE := FND_API.G_TRUE;

280:
281: if(l_mtl_reserved_qty = -99999) then
282: X_RESERVATION_UOM_CONVERTIBLE := FND_API.G_FALSE;
283: else
284: X_RESERVATION_UOM_CONVERTIBLE := FND_API.G_TRUE;
285: end if ;
286: X_RESERVED_QUANTITY := l_mtl_reserved_qty;
287: l_net_mtl_dispensed_quantity := GET_NET_MTL_DISPENSED_QTY(P_MATERIAL_DETAILS_ID, l_dispense_uom);
288: l_planned_quantity := inv_convert.inv_um_convert(p_inventory_item_id,

Line 298: X_PLAN_UOM_CONVERTIBLE := FND_API.G_FALSE;

294: l_dispense_uom,
295: null,
296: null);
297: IF (l_planned_quantity = -99999) THEN
298: X_PLAN_UOM_CONVERTIBLE := FND_API.G_FALSE;
299: else
300: X_PLAN_UOM_CONVERTIBLE := FND_API.G_TRUE;
301: END IF;
302: IF (l_planned_quantity = -99999 OR l_mtl_reserved_qty = -99999) THEN

Line 300: X_PLAN_UOM_CONVERTIBLE := FND_API.G_TRUE;

296: null);
297: IF (l_planned_quantity = -99999) THEN
298: X_PLAN_UOM_CONVERTIBLE := FND_API.G_FALSE;
299: else
300: X_PLAN_UOM_CONVERTIBLE := FND_API.G_TRUE;
301: END IF;
302: IF (l_planned_quantity = -99999 OR l_mtl_reserved_qty = -99999) THEN
303: X_PENDING_DISPENSE_QUANTITY := -99999; -- Make this row as dispense required
304: X_MAX_ALLOWED_QUANTITY := 0;

Line 397: return FND_API.G_TRUE;

393: X_RESERVATION_UOM_CONVERTIBLE => l_revervation_uom_converted,
394: X_SECURITY_FLAG =>l_security_flag);
395: -- change for kIosk : End
396: IF ( l_PENDING_DISPENSE_QUANTITY > 0 OR l_PENDING_DISPENSE_QUANTITY = -99999) THEN
397: return FND_API.G_TRUE;
398: END IF;
399: return FND_API.G_FALSE;
400: END IS_DISPENSE_REQUIRED;
401: /* Used by Dispesnig Bc4J objects to get reverse dispense related information */

Line 399: return FND_API.G_FALSE;

395: -- change for kIosk : End
396: IF ( l_PENDING_DISPENSE_QUANTITY > 0 OR l_PENDING_DISPENSE_QUANTITY = -99999) THEN
397: return FND_API.G_TRUE;
398: END IF;
399: return FND_API.G_FALSE;
400: END IS_DISPENSE_REQUIRED;
401: /* Used by Dispesnig Bc4J objects to get reverse dispense related information */
402: -- Kiosk : Start
403: PROCEDURE GET_REVERSE_DISPENSE_DATA(P_DISPENSE_ID IN NUMBER,

Line 664: IF(l_return_status<> FND_API.G_RET_STS_SUCCESS ) THEN

660: X_MANDATORY_PENDING_INSTR =>L_MANDATORY_PENDING_INSTR,
661: X_RETURN_STATUS =>l_return_status,
662: X_MSG_COUNT =>l_msg_count,
663: X_MSG_DATA =>l_msg_data);
664: IF(l_return_status<> FND_API.G_RET_STS_SUCCESS ) THEN
665: RAISE INSTRUNCTION_EXCEPTION;
666: END IF;
667: IF (L_MANDATORY_PENDING_INSTR > 0) THEN
668: l_result_record.external_source_line_id := -1;

Line 833: P_INIT_MSG_LIST=>FND_API.G_TRUE,

829: l_transaction_type := INV_LABEL.TRX_ID_UNDIS;
830: end if;
831: GMO_LABEL_MGMT_GRP.PRINT_LABEL
832: (P_API_VERSION=>1,
833: P_INIT_MSG_LIST=>FND_API.G_TRUE,
834: X_RETURN_STATUS=>L_RETURN_STATUS,
835: X_MSG_COUNT=>L_MSG_COUNT,
836: X_MSG_DATA=>L_MSG_DATA,
837: P_ENTITY_NAME=>'GMO_DISPENSING',

Line 847: IF(L_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS ) THEN

843: P_APPLICATION_SHORT_NAME=>'GMO',
844: P_REQUESTER=>fnd_global.user_id,
845: P_CONTEXT=>L_CONTEXT,
846: X_LABEL_ID=> l_label_request_id);
847: IF(L_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS ) THEN
848: RAISE l_EXCEPTION;
849: END IF;
850: return l_label_request_id;
851: EXCEPTION WHEN l_EXCEPTION THEN

Line 862: return FND_API.G_TRUE;

858: FUNCTION IS_AUTO_PRINT_ENABLED RETURN VARCHAR2
859: IS
860: BEGIN
861: IF(GMO_LABEL_MGMT_GRP.AUTO_PRINT_ENABLED ()) THEN
862: return FND_API.G_TRUE;
863: END IF;
864: return FND_API.G_FALSE;
865: END;
866: /* Used by dispense dispatch report query*/

Line 864: return FND_API.G_FALSE;

860: BEGIN
861: IF(GMO_LABEL_MGMT_GRP.AUTO_PRINT_ENABLED ()) THEN
862: return FND_API.G_TRUE;
863: END IF;
864: return FND_API.G_FALSE;
865: END;
866: /* Used by dispense dispatch report query*/
867: FUNCTION GET_PENDING_DISPENSE_QTY(P_RESERVATION_ID NUMBER,
868: P_INVENTORY_ITEM_ID NUMBER,

Line 951: P_INIT_MSG_LIST => FND_API.G_TRUE,

947: END IF;
948: --Obtain the process instruction details in XML format for the specified instruction process ID.
949: GMO_INSTRUCTION_GRP.GET_INSTR_INSTANCE_XML
950: (P_API_VERSION => 1.0,
951: P_INIT_MSG_LIST => FND_API.G_TRUE,
952: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,
953: P_INSTRUCTION_PROCESS_ID => P_INSTRUCTION_PROCESS_ID,
954: X_OUTPUT_XML => L_INSTR_XML,
955: X_RETURN_STATUS => L_RETURN_STATUS,

Line 952: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,

948: --Obtain the process instruction details in XML format for the specified instruction process ID.
949: GMO_INSTRUCTION_GRP.GET_INSTR_INSTANCE_XML
950: (P_API_VERSION => 1.0,
951: P_INIT_MSG_LIST => FND_API.G_TRUE,
952: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_NONE,
953: P_INSTRUCTION_PROCESS_ID => P_INSTRUCTION_PROCESS_ID,
954: X_OUTPUT_XML => L_INSTR_XML,
955: X_RETURN_STATUS => L_RETURN_STATUS,
956: X_MSG_COUNT => L_MSG_COUNT,

Line 959: IF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR OR L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

955: X_RETURN_STATUS => L_RETURN_STATUS,
956: X_MSG_COUNT => L_MSG_COUNT,
957: X_MSG_DATA => L_MSG_DATA);
958: --If the return status is EXCEPTION or UNEXPECTED ERROR then raise an exception.
959: IF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR OR L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
960: RAISE XML_ERROR;
961: END IF;
962: --If the XML representing the process instruction details is not null then append the same into the final XMl CLOB holder.
963: IF L_INSTR_XML IS NOT NULL AND DBMS_LOB.GETLENGTH(L_INSTR_XML) > 0 THEN