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.AHL_PRD_UTIL_PKG dependencies on FND_API

Line 42: x_return_status := FND_API.G_RET_STS_SUCCESS;

38: and nvl(disable_Date, sysdate) >= sysdate;
39:
40: BEGIN
41: -- Initialize API return status to success
42: x_return_status := FND_API.G_RET_STS_SUCCESS;
43: -- test if subinventory si null;
44: if (p_subinventory_code is null ) then
45:
46: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_PC_SUBINV_MANDATORY');

Line 49: RAISE FND_API.G_EXC_ERROR;

45:
46: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_PC_SUBINV_MANDATORY');
47:
48: FND_MSG_PUB.ADD;
49: RAISE FND_API.G_EXC_ERROR;
50: end if;
51:
52: -- Commented the following validation as locator id need not exist in
53: -- mtl_item_locations if it is setup as dynamic entry.

Line 61: x_return_status := FND_API.G_RET_STS_ERROR;

57: -- CLOSE ahl_locator_csr;
58:
59:
60: /* if (l_subinv_code is null) then
61: x_return_status := FND_API.G_RET_STS_ERROR;
62: FND_MESSAGE.Set_Name('AHL','AHL_PRD_LOCATOR_INVALID');
63: FND_MSG_PUB.ADD;
64:
65: END if;*/

Line 70: -- x_return_status := FND_API.G_RET_STS_ERROR;

66:
67: --Check if the locator is attached to the subinventory if subinventory is provided
68: -- if (l_subinv_code is not null
69: -- and l_subinv_code <> p_subinventory_code ) then
70: -- x_return_status := FND_API.G_RET_STS_ERROR;
71: -- FND_MESSAGE.Set_Name('AHL','AHL_PRD_LOCATOR_SUBINV_INVALID');
72: -- FND_MSG_PUB.ADD;
73:
74: -- END if;

Line 77: -- x_return_status := FND_API.G_RET_STS_ERROR;

73:
74: -- END if;
75: EXCEPTION
76: -- WHEN NO_DATA_FOUND THEN
77: -- x_return_status := FND_API.G_RET_STS_ERROR;
78: -- FND_MESSAGE.Set_Name('AHL','AHL_PRD_LOCATOR_INVALID');
79: -- FND_MSG_PUB.ADD;
80:
81:

Line 82: WHEN FND_API.G_EXC_ERROR THEN

78: -- FND_MESSAGE.Set_Name('AHL','AHL_PRD_LOCATOR_INVALID');
79: -- FND_MSG_PUB.ADD;
80:
81:
82: WHEN FND_API.G_EXC_ERROR THEN
83: x_return_status := FND_API.G_RET_STS_ERROR;
84: WHEN OTHERS THEN
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: END;

Line 83: x_return_status := FND_API.G_RET_STS_ERROR;

79: -- FND_MSG_PUB.ADD;
80:
81:
82: WHEN FND_API.G_EXC_ERROR THEN
83: x_return_status := FND_API.G_RET_STS_ERROR;
84: WHEN OTHERS THEN
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: END;
87: --Validates a removal condition

Line 85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

81:
82: WHEN FND_API.G_EXC_ERROR THEN
83: x_return_status := FND_API.G_RET_STS_ERROR;
84: WHEN OTHERS THEN
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: END;
87: --Validates a removal condition
88: procedure validate_condition
89: (

Line 107: x_return_status := FND_API.G_RET_STS_SUCCESS;

103: and enabled_flag =1;
104: BEGIN
105:
106: -- Initialize API return status to success
107: x_return_status := FND_API.G_RET_STS_SUCCESS;
108:
109: OPEN ahl_condition_csr(p_condition_id);
110: FETCH ahl_condition_csr INTO l_junk;
111: CLOSE ahl_condition_csr;

Line 114: x_return_status := FND_API.G_RET_STS_ERROR;

110: FETCH ahl_condition_csr INTO l_junk;
111: CLOSE ahl_condition_csr;
112:
113: if (l_junk is null) then
114: x_return_status := FND_API.G_RET_STS_ERROR;
115: FND_MESSAGE.Set_Name('AHL','AHL_PRD_PC_CONDN_MISSING');
116: FND_MSG_PUB.ADD;
117: END if;
118: END;

Line 139: x_return_status := FND_API.G_RET_STS_SUCCESS;

135:
136: l_junk varchar2(1) := null;
137: begin
138: -- Initialize API return status to success
139: x_return_status := FND_API.G_RET_STS_SUCCESS;
140:
141: OPEN ahl_reason_csr(p_reason_id);
142: FETCH ahl_reason_csr INTO l_junk;
143: CLOSE ahl_reason_csr;

Line 147: x_return_status := FND_API.G_RET_STS_ERROR;

143: CLOSE ahl_reason_csr;
144:
145:
146: if (l_junk is null) then
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_REASON');
149: FND_MESSAGE.Set_Token('REASON',p_reason_id);
150:
151: FND_MSG_PUB.ADD;

Line 181: x_return_status := FND_API.G_RET_STS_SUCCESS;

177:
178:
179:
180: -- Initialize API return status to success
181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182:
183: OPEN ahl_inv_status_csr(p_Organization_Id,p_Subinventory_Code);
184: FETCH ahl_inv_status_csr INTO l_status_id;
185: CLOSE ahl_inv_status_csr;

Line 191: x_return_status := FND_API.G_RET_STS_ERROR;

187: if l_status_id is null THEN
188: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_SUBINVENTORY');
189: FND_MESSAGE.set_token('INV', p_Subinventory_Code);
190: FND_MSG_PUB.ADD;
191: x_return_status := FND_API.G_RET_STS_ERROR;
192:
193: End if;
194: --dbms_output.put_line('ahl_prd_util_pkg - Condition id'|| p_condition_id);
195: -- dbms_output.put_line('ahl_prd_util_pkg - status id'|| l_status_id);

Line 214: x_return_status := FND_API.G_RET_STS_ERROR;

210:
211:
212: FND_MESSAGE.Set_Name('AHL','AHL_PRD_CONDN_SUBINV_MISMATCH');
213: FND_MSG_PUB.ADD;
214: x_return_status := FND_API.G_RET_STS_ERROR;
215:
216: END IF;
217:
218: END ;--VALIDATE_MATERIAL_STATUS;

Line 306: ) = FND_API.G_TRUE

302: THEN
303: IF AHL_UTIL_UC_PKG.Is_Unit_Quarantined(
304: p_unit_header_id => null,
305: p_instance_id => l_instance_id
306: ) = FND_API.G_TRUE
307: THEN
308: RETURN FND_API.G_TRUE;
309: END IF;
310:

Line 308: RETURN FND_API.G_TRUE;

304: p_unit_header_id => null,
305: p_instance_id => l_instance_id
306: ) = FND_API.G_TRUE
307: THEN
308: RETURN FND_API.G_TRUE;
309: END IF;
310:
311: ELSE
312: -- If visit task has item instance info.

Line 320: RETURN FND_API.G_FALSE;

316: );
317: END IF;
318: END LOOP;
319:
320: RETURN FND_API.G_FALSE;
321: -- if mr header id is input to the API.
322: ELSIF p_ue_id IS NOT NULL
323: THEN
324: OPEN c_get_ue_instance_id(p_ue_id);

Line 343: RETURN FND_API.G_FALSE;

339: p_instance_id => nvl(l_instance_id, l_item_instance_id) );
340: END IF;
341:
342: -- Control will reach here if all inputs to the API are null. return false then.
343: RETURN FND_API.G_FALSE;
344:
345: END Is_Unit_Locked;
346:
347: ------------------------------------------------------------------------------------------------

Line 355: p_check_unit IN VARCHAR2 DEFAULT FND_API.G_TRUE

351: -- 2. If the workorder status is any of 22, 12 and 7 then it cannot be updated.
352: ------------------------------------------------------------------------------------------------
353: FUNCTION Is_Wo_Updatable(
354: P_workorder_id IN NUMBER,
355: p_check_unit IN VARCHAR2 DEFAULT FND_API.G_TRUE
356: )
357: RETURN VARCHAR2
358: IS
359: /*

Line 378: RETURN FND_API.G_FALSE;

374: BEGIN
375: -- If workorder_id is null then immediately return false.
376: IF p_workorder_id IS NULL
377: THEN
378: RETURN FND_API.G_FALSE;
379: END IF;
380:
381: -- Check if the unit is locked... If so then return false to indicate
382: -- the workorder can't be updated.

Line 383: IF p_check_unit = FND_API.G_TRUE THEN

379: END IF;
380:
381: -- Check if the unit is locked... If so then return false to indicate
382: -- the workorder can't be updated.
383: IF p_check_unit = FND_API.G_TRUE THEN
384: IF Is_Unit_Locked(
385: p_workorder_id => p_workorder_id,
386: P_ue_id => null,
387: P_visit_id => null,

Line 389: ) = FND_API.G_TRUE

385: p_workorder_id => p_workorder_id,
386: P_ue_id => null,
387: P_visit_id => null,
388: P_item_instance_id => null
389: ) = FND_API.G_TRUE
390: THEN
391: RETURN FND_API.G_FALSE;
392: END IF;
393: END IF;

Line 391: RETURN FND_API.G_FALSE;

387: P_visit_id => null,
388: P_item_instance_id => null
389: ) = FND_API.G_TRUE
390: THEN
391: RETURN FND_API.G_FALSE;
392: END IF;
393: END IF;
394:
395: -- If the unit is not locked and the workorder is in any of

Line 403: RETURN FND_API.G_FALSE;

399: CLOSE c_validate_wo_status;
400:
401: IF l_exists IS NOT NULL
402: THEN
403: RETURN FND_API.G_FALSE;
404: END IF;
405:
406: -- If this point is reached then neither the unit is locked nor the workorder is
407: -- in invalid status. Return true here.

Line 408: RETURN FND_API.G_TRUE;

404: END IF;
405:
406: -- If this point is reached then neither the unit is locked nor the workorder is
407: -- in invalid status. Return true here.
408: RETURN FND_API.G_TRUE;
409:
410: END Is_Wo_Updatable;
411:
412: ------------------------------------------------------------------------------------------------

Line 423: p_check_unit IN VARCHAR2 DEFAULT FND_API.G_TRUE

419: ------------------------------------------------------------------------------------------------
420: FUNCTION Is_Op_Updatable(
421: p_workorder_id IN NUMBER,
422: p_operation_seq_num IN NUMBER,
423: p_check_unit IN VARCHAR2 DEFAULT FND_API.G_TRUE
424: )
425: RETURN VARCHAR2
426: IS
427:

Line 462: RETURN FND_API.G_FALSE;

458: -- If either of workorder_id or operation sequence number is null then
459: -- return false as it is incorrect input to this API.
460: IF p_workorder_id IS NULL OR p_operation_seq_num IS NULL
461: THEN
462: RETURN FND_API.G_FALSE;
463: END IF;
464:
465: -- If the unit associated with this workorder is locked then
466: -- operation should not be updatable.

Line 467: IF p_check_unit = FND_API.G_TRUE THEN

463: END IF;
464:
465: -- If the unit associated with this workorder is locked then
466: -- operation should not be updatable.
467: IF p_check_unit = FND_API.G_TRUE THEN
468: IF Is_Unit_Locked(
469: p_workorder_id => p_workorder_id,
470: P_ue_id => null,
471: P_visit_id => null,

Line 473: ) = FND_API.G_TRUE

469: p_workorder_id => p_workorder_id,
470: P_ue_id => null,
471: P_visit_id => null,
472: P_item_instance_id => null
473: ) = FND_API.G_TRUE
474: THEN
475: RETURN FND_API.G_FALSE;
476: END IF;
477: END IF;

Line 475: RETURN FND_API.G_FALSE;

471: P_visit_id => null,
472: P_item_instance_id => null
473: ) = FND_API.G_TRUE
474: THEN
475: RETURN FND_API.G_FALSE;
476: END IF;
477: END IF;
478:
479: -- If the workorder status is any of 7, 12 or 22 then return false.

Line 485: RETURN FND_API.G_FALSE;

481: FETCH c_validate_wo_status INTO l_exists;
482: CLOSE c_validate_wo_status;
483: IF l_exists IS NOT NULL
484: THEN
485: RETURN FND_API.G_FALSE;
486: END IF;
487:
488: -- If the operation status is 'Complete' then return false
489: -- to indicate the operation is not updatable.

Line 494: RETURN FND_API.G_FALSE;

490: OPEN c_validate_op_status(p_workorder_id, p_operation_seq_num);
491: FETCH c_validate_op_status INTO l_exists;
492: IF l_exists IS NOT NULL
493: THEN
494: RETURN FND_API.G_FALSE;
495: END IF;
496:
497: -- Control reaching here indicates above three checks are not valid for
498: -- the input hence return true to indicate the operation is updatable.

Line 499: RETURN FND_API.G_TRUE;

495: END IF;
496:
497: -- Control reaching here indicates above three checks are not valid for
498: -- the input hence return true to indicate the operation is updatable.
499: RETURN FND_API.G_TRUE;
500:
501: END Is_Op_Updatable;
502:
503: ------------------------------------------------------------------------------------------------

Line 510: p_check_unit IN VARCHAR2 DEFAULT FND_API.G_TRUE

506: -- The function returns QA Plan id or null if one is not associated with the MR.
507: ------------------------------------------------------------------------------------------------
508: FUNCTION Is_Mr_Qa_Enabled(
509: p_ue_id IN NUMBER,
510: p_check_unit IN VARCHAR2 DEFAULT FND_API.G_TRUE
511: )
512: RETURN NUMBER
513: IS
514:

Line 611: IF p_check_unit = FND_API.G_TRUE THEN

607: END IF;
608:
609: -- If the unit associated with this workorder is locked then
610: -- operation should not be updatable.
611: IF p_check_unit = FND_API.G_TRUE THEN
612: IF Is_Unit_Locked(
613: p_workorder_id => null,
614: P_ue_id => l_mr_id,
615: P_visit_id => null,

Line 617: ) = FND_API.G_TRUE

613: p_workorder_id => null,
614: P_ue_id => l_mr_id,
615: P_visit_id => null,
616: P_item_instance_id => null
617: ) = FND_API.G_TRUE
618: THEN
619: RETURN NULL;
620: END IF;
621: END IF;

Line 664: p_check_unit IN VARCHAR2 DEFAULT FND_API.G_TRUE

660: -- are not allowed.
661: ------------------------------------------------------------------------------------------------
662: FUNCTION Is_PartChange_Enabled(
663: P_workorder_id IN NUMBER,
664: p_check_unit IN VARCHAR2 DEFAULT FND_API.G_TRUE
665: )
666: RETURN VARCHAR2
667: IS
668: /*

Line 699: RETURN FND_API.G_FALSE;

695: BEGIN
696: -- If sole input to this API p_workorder_id is null then return false
697: IF p_workorder_id IS NULL
698: THEN
699: RETURN FND_API.G_FALSE;
700: END IF;
701:
702: -- If the Unit is locked then part changes cannot be done hence return false
703: IF p_check_unit = FND_API.G_TRUE THEN

Line 703: IF p_check_unit = FND_API.G_TRUE THEN

699: RETURN FND_API.G_FALSE;
700: END IF;
701:
702: -- If the Unit is locked then part changes cannot be done hence return false
703: IF p_check_unit = FND_API.G_TRUE THEN
704: IF Is_Unit_Locked(
705: p_workorder_id => p_workorder_id,
706: P_ue_id => null,
707: P_visit_id => null,

Line 709: ) = FND_API.G_TRUE THEN

705: p_workorder_id => p_workorder_id,
706: P_ue_id => null,
707: P_visit_id => null,
708: P_item_instance_id => null
709: ) = FND_API.G_TRUE THEN
710: RETURN FND_API.G_FALSE;
711: END IF;
712: END IF;
713:

Line 710: RETURN FND_API.G_FALSE;

706: P_ue_id => null,
707: P_visit_id => null,
708: P_item_instance_id => null
709: ) = FND_API.G_TRUE THEN
710: RETURN FND_API.G_FALSE;
711: END IF;
712: END IF;
713:
714: -- If workorder is in an invalid status where part changes cannot be done then

Line 721: RETURN FND_API.G_FALSE;

717: FETCH c_get_workorder_details INTO l_status_code, l_item_instance_id;
718: CLOSE c_get_workorder_details;
719:
720: IF l_status_code NOT IN ('3', '19') THEN
721: RETURN FND_API.G_FALSE;
722: END IF;
723:
724: AHL_PRD_PARTS_CHANGE_PVT.get_unit_config_information(
725: p_item_instance_id => l_item_instance_id,

Line 730: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

726: p_workorder_id => null,
727: x_unit_config_id => l_unit_config_id,
728: x_unit_config_name => l_unit_config_name,
729: x_return_status => l_return_status);
730: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
731: RETURN FND_API.G_FALSE;
732: END IF;
733:
734: -- All above conditions are false hence part changes can be done. return true.

Line 731: RETURN FND_API.G_FALSE;

727: x_unit_config_id => l_unit_config_id,
728: x_unit_config_name => l_unit_config_name,
729: x_return_status => l_return_status);
730: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
731: RETURN FND_API.G_FALSE;
732: END IF;
733:
734: -- All above conditions are false hence part changes can be done. return true.
735: RETURN FND_API.G_TRUE;

Line 735: RETURN FND_API.G_TRUE;

731: RETURN FND_API.G_FALSE;
732: END IF;
733:
734: -- All above conditions are false hence part changes can be done. return true.
735: RETURN FND_API.G_TRUE;
736:
737: END Is_PartChange_Enabled;
738:
739:

Line 750: p_check_unit IN VARCHAR2 DEFAULT FND_API.G_TRUE

746: ------------------------------------------------------------------------------------------------
747: FUNCTION IsDelAsg_Enabled(
748: P_assignment_id IN NUMBER,
749: P_workorder_id IN NUMBER,
750: p_check_unit IN VARCHAR2 DEFAULT FND_API.G_TRUE
751: )
752: RETURN VARCHAR2
753: IS
754:

Line 781: RETURN FND_API.G_FALSE;

777:
778: -- If sole input to this API p_workorder_id is null then return false
779: IF P_assignment_id IS NULL
780: THEN
781: RETURN FND_API.G_FALSE;
782: END IF;
783: -- If the Unit is locked then Assignment cant be deleted return false.
784: IF p_check_unit = FND_API.G_TRUE THEN
785: IF Is_Unit_Locked(

Line 784: IF p_check_unit = FND_API.G_TRUE THEN

780: THEN
781: RETURN FND_API.G_FALSE;
782: END IF;
783: -- If the Unit is locked then Assignment cant be deleted return false.
784: IF p_check_unit = FND_API.G_TRUE THEN
785: IF Is_Unit_Locked(
786: p_workorder_id => p_workorder_id,
787: P_ue_id => null,
788: P_visit_id => null,

Line 790: ) = FND_API.G_TRUE

786: p_workorder_id => p_workorder_id,
787: P_ue_id => null,
788: P_visit_id => null,
789: P_item_instance_id => null
790: ) = FND_API.G_TRUE
791: THEN
792: Fnd_Message.Set_Name('AHL', 'AHL_PP_DEL_RESASG_UNTLCKD');
793: Fnd_Msg_Pub.ADD;
794: RETURN FND_API.G_FALSE;

Line 794: RETURN FND_API.G_FALSE;

790: ) = FND_API.G_TRUE
791: THEN
792: Fnd_Message.Set_Name('AHL', 'AHL_PP_DEL_RESASG_UNTLCKD');
793: Fnd_Msg_Pub.ADD;
794: RETURN FND_API.G_FALSE;
795: END IF;
796: END IF;
797:
798: OPEN c_get_ass_details(p_assignment_id);

Line 809: RETURN FND_API.G_FALSE;

805: FND_MESSAGE.set_token( 'RES_SEQ' , l_res_seq_num);
806: Fnd_Msg_Pub.ADD;
807:
808: CLOSE c_get_ass_details;
809: RETURN FND_API.G_FALSE;
810: END IF;
811: CLOSE c_get_ass_details;
812:
813:

Line 818: RETURN FND_API.G_FALSE;

814: /*IF l_login_date IS NOT NULL
815: THEN
816: -- the user is currently logged in corresponding to this resource assignment
817: -- the resource assignment cannot be deleted
818: RETURN FND_API.G_FALSE;
819: END IF;
820: */
821:
822: RETURN FND_API.G_TRUE;

Line 822: RETURN FND_API.G_TRUE;

818: RETURN FND_API.G_FALSE;
819: END IF;
820: */
821:
822: RETURN FND_API.G_TRUE;
823:
824: END IsDelAsg_Enabled;
825:
826: FUNCTION Is_Wo_Completable(

Line 862: RETURN FND_API.G_FALSE;

858: BEGIN
859: -- If workorder_id is null then immediately return false.
860: IF p_workorder_id IS NULL
861: THEN
862: RETURN FND_API.G_FALSE;
863: END IF;
864:
865: OPEN c_validate_wo_status(p_workorder_id);
866: FETCH c_validate_wo_status INTO l_exists;

Line 871: RETURN FND_API.G_FALSE;

867: CLOSE c_validate_wo_status;
868:
869: IF l_exists IS NOT NULL
870: THEN
871: RETURN FND_API.G_FALSE;
872: END IF;
873:
874: OPEN c_validate_op_status(p_workorder_id);
875: FETCH c_validate_op_status INTO l_exists;

Line 880: RETURN FND_API.G_FALSE;

876: CLOSE c_validate_op_status;
877:
878: IF l_exists IS NOT NULL
879: THEN
880: RETURN FND_API.G_FALSE;
881: END IF;
882:
883: -- If this point is reached then neither the unit is locked nor the workorder is
884: -- in invalid status. Return true here.

Line 885: RETURN FND_API.G_TRUE;

881: END IF;
882:
883: -- If this point is reached then neither the unit is locked nor the workorder is
884: -- in invalid status. Return true here.
885: RETURN FND_API.G_TRUE;
886:
887: END Is_Wo_Completable;
888:
889: ------------------------------------------------------------------------------------------------

Line 897: -- Return : FND_API.G_TRUE or FND_API.G_FALSE.

893: -- Function name : Is_ResTxn_Allowed
894: -- Type : Private
895: -- Pre-reqs :
896: -- Parameters :
897: -- Return : FND_API.G_TRUE or FND_API.G_FALSE.
898: --
899: -- Standard IN Parameters :
900: -- None
901: --

Line 921: p_check_unit IN VARCHAR2 DEFAULT FND_API.G_TRUE

917: -- End of Comments
918:
919: FUNCTION Is_ResTxn_Allowed(
920: P_workorder_id IN NUMBER,
921: p_check_unit IN VARCHAR2 DEFAULT FND_API.G_TRUE
922: )
923: RETURN VARCHAR2
924: IS
925: -- cursor to retrieve the workorder status

Line 936: l_return_value := FND_API.G_FALSE;

932: l_return_value VARCHAR2(1);
933: l_wo_status VARCHAR2(30);
934: BEGIN
935:
936: l_return_value := FND_API.G_FALSE;
937: IF p_check_unit = FND_API.G_TRUE THEN
938: l_return_value := is_unit_locked(p_workorder_id => p_workorder_id,
939: p_ue_id => NULL,
940: p_item_instance_id => NULL,

Line 937: IF p_check_unit = FND_API.G_TRUE THEN

933: l_wo_status VARCHAR2(30);
934: BEGIN
935:
936: l_return_value := FND_API.G_FALSE;
937: IF p_check_unit = FND_API.G_TRUE THEN
938: l_return_value := is_unit_locked(p_workorder_id => p_workorder_id,
939: p_ue_id => NULL,
940: p_item_instance_id => NULL,
941: p_visit_id => NULL

Line 944: IF l_return_value = FND_API.G_TRUE THEN

940: p_item_instance_id => NULL,
941: p_visit_id => NULL
942: );
943: -- If the unit is locked, then resource transactions are not allowed
944: IF l_return_value = FND_API.G_TRUE THEN
945: RETURN FND_API.G_FALSE;
946: END IF;
947: END IF;
948:

Line 945: RETURN FND_API.G_FALSE;

941: p_visit_id => NULL
942: );
943: -- If the unit is locked, then resource transactions are not allowed
944: IF l_return_value = FND_API.G_TRUE THEN
945: RETURN FND_API.G_FALSE;
946: END IF;
947: END IF;
948:
949: OPEN get_wo_status(p_workorder_id);

Line 956: RETURN FND_API.G_FALSE;

952:
953: -- If the workorder is in status On Hold, Closed, Complete No Charge, Unreleased, Cancelled
954: -- then resource transactions are not allowed
955: IF l_wo_status IS NULL OR l_wo_status IN ('6','12','5','1', '7', '13') THEN
956: RETURN FND_API.G_FALSE;
957: END IF;
958:
959: RETURN FND_API.G_TRUE;
960:

Line 959: RETURN FND_API.G_TRUE;

955: IF l_wo_status IS NULL OR l_wo_status IN ('6','12','5','1', '7', '13') THEN
956: RETURN FND_API.G_FALSE;
957: END IF;
958:
959: RETURN FND_API.G_TRUE;
960:
961: END Is_ResTxn_Allowed;
962:
963: ------------------------------------------------------------------------------------------------

Line 972: -- Return : FND_API.G_TRUE or FND_API.G_FALSE.

968: -- Function name : Is_Wo_Cancel_Allowed
969: -- Type : Private
970: -- Pre-reqs :
971: -- Parameters :
972: -- Return : FND_API.G_TRUE or FND_API.G_FALSE.
973: --
974: -- Standard IN Parameters :
975: -- None
976: --

Line 1009: return FND_API.G_TRUE;

1005:
1006: -- if no workorder ID is passed, then check for only AHL_PRD_DISALLOW_CANCEL_JOBS
1007: -- function access.
1008: IF (p_workorder_id IS NULL) THEN
1009: return FND_API.G_TRUE;
1010: ELSE
1011: OPEN is_workorders_released(p_workorder_id);
1012: FETCH is_workorders_released INTO l_junk;
1013: IF(is_workorders_released%NOTFOUND)THEN

Line 1015: return FND_API.G_TRUE;

1011: OPEN is_workorders_released(p_workorder_id);
1012: FETCH is_workorders_released INTO l_junk;
1013: IF(is_workorders_released%NOTFOUND)THEN
1014: CLOSE is_workorders_released;
1015: return FND_API.G_TRUE;
1016: END IF;
1017: CLOSE is_workorders_released;
1018:
1019: IF(FND_FUNCTION.TEST('AHL_PRD_CANCEL_REL_JOBS',null))THEN

Line 1020: return FND_API.G_TRUE;

1016: END IF;
1017: CLOSE is_workorders_released;
1018:
1019: IF(FND_FUNCTION.TEST('AHL_PRD_CANCEL_REL_JOBS',null))THEN
1020: return FND_API.G_TRUE;
1021: END IF;
1022: END IF;
1023:
1024: END IF;

Line 1026: RETURN FND_API.G_FALSE;

1022: END IF;
1023:
1024: END IF;
1025:
1026: RETURN FND_API.G_FALSE;
1027:
1028: END Is_Wo_Cancel_Allowed;
1029:
1030: -- Start of Comments --

Line 1897: l_plan_id := is_Mr_Qa_Enabled(P_ue_id,FND_API.G_FALSE);

1893:
1894: if l_qa_collection_id is not null then
1895: l_qa_status := 'QA_ENTERED';
1896: elsif l_qa_insp_type is not null then
1897: l_plan_id := is_Mr_Qa_Enabled(P_ue_id,FND_API.G_FALSE);
1898: if l_plan_id is null then
1899: l_qa_status:='BLANK';
1900: else
1901: l_qa_status := 'QA_NOTENTERED';