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

Line 34: RETURN FND_API.G_MISS_NUM;

30: WHEN NO_DATA_FOUND THEN
31: RETURN NULL;
32:
33: WHEN OTHERS THEN
34: RETURN FND_API.G_MISS_NUM;
35:
36: END ret_app_status;
37:
38:

Line 72: RETURN FND_API.G_MISS_NUM;

68: WHEN NO_DATA_FOUND THEN
69: l_id :=0;
70: RETURN l_id;
71: WHEN OTHERS THEN
72: RETURN FND_API.G_MISS_NUM;
73: END ret_pro_name ;
74: -- End Changes 3047312
75:
76: -- Procedure Clear_Dependent_Attr

Line 79: ( p_attr_id IN NUMBER := NULL --FND_API.G_MISS_NUM

75:
76: -- Procedure Clear_Dependent_Attr
77:
78: PROCEDURE Clear_Dependent_Attr
79: ( p_attr_id IN NUMBER := NULL --FND_API.G_MISS_NUM
80: , p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
81: , p_old_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
82: , x_eco_revision_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Rec_Type
83: )

Line 162: FND_API.G_MISS_CHAR,

158: UPDATE ENG_CHANGE_ORDER_REVISIONS
159: SET REVISION = DECODE
160: ( p_eco_revision_rec.new_revision, NULL,
161: p_eco_revision_rec.revision,
162: FND_API.G_MISS_CHAR,
163: p_eco_revision_rec.revision,
164: p_eco_revision_rec.new_revision )
165: , LAST_UPDATE_DATE = SYSDATE
166: , LAST_UPDATED_BY = l_user_id

Line 169: , FND_API.G_MISS_CHAR

165: , LAST_UPDATE_DATE = SYSDATE
166: , LAST_UPDATED_BY = l_user_id
167: , LAST_UPDATE_LOGIN = l_login_id
168: , COMMENTS = DECODE( p_eco_revision_rec.comments
169: , FND_API.G_MISS_CHAR
170: , null
171: , p_eco_revision_rec.comments
172: )
173: , ATTRIBUTE_CATEGORY = p_eco_revision_rec.attribute_category

Line 196: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

192:
193:
194: WHERE REVISION_ID = p_Eco_Rev_Unexp_Rec.revision_id;
195:
196: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
197: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
198:
199: EXCEPTION
200:

Line 205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

201: WHEN OTHERS THEN
202:
203: IF G_CONTROL_REC.caller_type = 'FORM'
204: THEN
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
206: RAISE;
207: END IF;
208:
209: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

216: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
217: );
218: END IF;
219:
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221:
222: END Update_Row;
223:
224: /***************************************************************************

Line 302: , FND_API.G_MISS_CHAR

298: , p_Eco_Revision_Rec.Eco_Name
299: , p_Eco_Rev_Unexp_Rec.organization_id
300: , p_eco_revision_rec.revision
301: , DECODE( p_eco_revision_rec.comments
302: , FND_API.G_MISS_CHAR
303: , NULL
304: , p_eco_revision_rec.comments
305: )
306: , p_eco_revision_rec.attribute_category

Line 382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

378: WHEN OTHERS THEN
379:
380: IF G_CONTROL_REC.caller_type = 'FORM'
381: THEN
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: RAISE;
384: END IF;
385:
386: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 397: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

393: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
394: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
395: );
396: END IF;
397: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
398: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
399:
400: END Insert_Row;
401:

Line 427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

423:
424: WHEN NO_DATA_FOUND THEN
425: IF G_CONTROL_REC.caller_type = 'FORM'
426: THEN
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: RAISE;
429: END IF;
430:
431: Error_Handler.Add_Error_Token

Line 436: x_Return_Status := FND_API.G_RET_STS_ERROR;

432: ( p_Message_Name => 'OE_LOCK_ROW_DELETED'
433: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
434: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
435: );
436: x_Return_Status := FND_API.G_RET_STS_ERROR;
437: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
438: WHEN OTHERS THEN
439:
440: IF G_CONTROL_REC.caller_type = 'FORM'

Line 442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

438: WHEN OTHERS THEN
439:
440: IF G_CONTROL_REC.caller_type = 'FORM'
441: THEN
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: RAISE;
444: END IF;
445:
446: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 458: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

454: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
455: );
456: END IF;
457:
458: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
459: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
460:
461: END Delete_Row;
462:

Line 541: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

537:
538: WHEN NO_DATA_FOUND THEN
539: x_Return_Status := Eng_Globals.G_RECORD_NOT_FOUND;
540: WHEN OTHERS THEN
541: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
542:
543: END Query_Row;
544:
545: /****************************************************************************

Line 567: l_return_status := FND_API.G_RET_STS_SUCCESS;

563: IS
564: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
565: l_return_status VARCHAR2(1);
566: BEGIN
567: l_return_status := FND_API.G_RET_STS_SUCCESS;
568:
569: G_CONTROL_REC := p_control_rec;
570:
571: IF p_eco_revision_rec.transaction_type = Eng_Globals.G_OPR_CREATE

Line 684: ((p_eco_revision_rec.attribute11 = FND_API.G_MISS_CHAR) OR

680: -- Row locked. Compare IN attributes to DB attributes.
681:
682: IF ( (l_eco_revision_rec.attribute11 =
683: p_eco_revision_rec.attribute11) OR
684: ((p_eco_revision_rec.attribute11 = FND_API.G_MISS_CHAR) OR
685: ( (l_eco_revision_rec.attribute11 IS NULL) AND
686: (p_eco_revision_rec.attribute11 IS NULL))))
687: AND ( (l_eco_revision_rec.attribute12 =
688: p_eco_revision_rec.attribute12) OR

Line 689: ((p_eco_revision_rec.attribute12 = FND_API.G_MISS_CHAR) OR

685: ( (l_eco_revision_rec.attribute11 IS NULL) AND
686: (p_eco_revision_rec.attribute11 IS NULL))))
687: AND ( (l_eco_revision_rec.attribute12 =
688: p_eco_revision_rec.attribute12) OR
689: ((p_eco_revision_rec.attribute12 = FND_API.G_MISS_CHAR) OR
690: ( (l_eco_revision_rec.attribute12 IS NULL) AND
691: (p_eco_revision_rec.attribute12 IS NULL))))
692: AND ( (l_eco_revision_rec.attribute13 =
693: p_eco_revision_rec.attribute13) OR

Line 694: ((p_eco_revision_rec.attribute13 = FND_API.G_MISS_CHAR) OR

690: ( (l_eco_revision_rec.attribute12 IS NULL) AND
691: (p_eco_revision_rec.attribute12 IS NULL))))
692: AND ( (l_eco_revision_rec.attribute13 =
693: p_eco_revision_rec.attribute13) OR
694: ((p_eco_revision_rec.attribute13 = FND_API.G_MISS_CHAR) OR
695: ( (l_eco_revision_rec.attribute13 IS NULL) AND
696: (p_eco_revision_rec.attribute13 IS NULL))))
697: AND ( (l_eco_revision_rec.attribute14 =
698: p_eco_revision_rec.attribute14) OR

Line 699: ((p_eco_revision_rec.attribute14 = FND_API.G_MISS_CHAR) OR

695: ( (l_eco_revision_rec.attribute13 IS NULL) AND
696: (p_eco_revision_rec.attribute13 IS NULL))))
697: AND ( (l_eco_revision_rec.attribute14 =
698: p_eco_revision_rec.attribute14) OR
699: ((p_eco_revision_rec.attribute14 = FND_API.G_MISS_CHAR) OR
700: ( (l_eco_revision_rec.attribute14 IS NULL) AND
701: (p_eco_revision_rec.attribute14 IS NULL))))
702: AND ( (l_eco_revision_rec.attribute15 =
703: p_eco_revision_rec.attribute15) OR

Line 704: ((p_eco_revision_rec.attribute15 = FND_API.G_MISS_CHAR) OR

700: ( (l_eco_revision_rec.attribute14 IS NULL) AND
701: (p_eco_revision_rec.attribute14 IS NULL))))
702: AND ( (l_eco_revision_rec.attribute15 =
703: p_eco_revision_rec.attribute15) OR
704: ((p_eco_revision_rec.attribute15 = FND_API.G_MISS_CHAR) OR
705: ( (l_eco_revision_rec.attribute15 IS NULL) AND
706: (p_eco_revision_rec.attribute15 IS NULL))))
707: AND ( (l_eco_revision_rec.program_application_id =
708: p_eco_revision_rec.program_application_id) OR

Line 709: ((p_eco_revision_rec.program_application_id = FND_API.G_MISS_NUM) OR

705: ( (l_eco_revision_rec.attribute15 IS NULL) AND
706: (p_eco_revision_rec.attribute15 IS NULL))))
707: AND ( (l_eco_revision_rec.program_application_id =
708: p_eco_revision_rec.program_application_id) OR
709: ((p_eco_revision_rec.program_application_id = FND_API.G_MISS_NUM) OR
710: ( (l_eco_revision_rec.program_application_id IS NULL) AND
711: (p_eco_revision_rec.program_application_id IS NULL))))
712: AND ( (l_eco_revision_rec.program_id =
713: p_eco_revision_rec.program_id) OR

Line 714: ((p_eco_revision_rec.program_id = FND_API.G_MISS_NUM) OR

710: ( (l_eco_revision_rec.program_application_id IS NULL) AND
711: (p_eco_revision_rec.program_application_id IS NULL))))
712: AND ( (l_eco_revision_rec.program_id =
713: p_eco_revision_rec.program_id) OR
714: ((p_eco_revision_rec.program_id = FND_API.G_MISS_NUM) OR
715: ( (l_eco_revision_rec.program_id IS NULL) AND
716: (p_eco_revision_rec.program_id IS NULL))))
717: AND ( (l_eco_revision_rec.program_update_date =
718: p_eco_revision_rec.program_update_date) OR

Line 719: ((p_eco_revision_rec.program_update_date = FND_API.G_MISS_DATE) OR

715: ( (l_eco_revision_rec.program_id IS NULL) AND
716: (p_eco_revision_rec.program_id IS NULL))))
717: AND ( (l_eco_revision_rec.program_update_date =
718: p_eco_revision_rec.program_update_date) OR
719: ((p_eco_revision_rec.program_update_date = FND_API.G_MISS_DATE) OR
720: ( (l_eco_revision_rec.program_update_date IS NULL) AND
721: (p_eco_revision_rec.program_update_date IS NULL))))
722: AND ( (l_eco_revision_rec.request_id =
723: p_eco_revision_rec.request_id) OR

Line 724: ((p_eco_revision_rec.request_id = FND_API.G_MISS_NUM) OR

720: ( (l_eco_revision_rec.program_update_date IS NULL) AND
721: (p_eco_revision_rec.program_update_date IS NULL))))
722: AND ( (l_eco_revision_rec.request_id =
723: p_eco_revision_rec.request_id) OR
724: ((p_eco_revision_rec.request_id = FND_API.G_MISS_NUM) OR
725: ( (l_eco_revision_rec.request_id IS NULL) AND
726: (p_eco_revision_rec.request_id IS NULL))))
727: AND ( (l_eco_revision_rec.revision_id =
728: p_eco_revision_rec.revision_id) OR

Line 729: ((p_eco_revision_rec.revision_id = FND_API.G_MISS_NUM) OR

725: ( (l_eco_revision_rec.request_id IS NULL) AND
726: (p_eco_revision_rec.request_id IS NULL))))
727: AND ( (l_eco_revision_rec.revision_id =
728: p_eco_revision_rec.revision_id) OR
729: ((p_eco_revision_rec.revision_id = FND_API.G_MISS_NUM) OR
730: ( (l_eco_revision_rec.revision_id IS NULL) AND
731: (p_eco_revision_rec.revision_id IS NULL))))
732: AND ( (l_eco_revision_rec.change_notice =
733: p_eco_revision_rec.change_notice) OR

Line 734: ((p_eco_revision_rec.change_notice = FND_API.G_MISS_CHAR) OR

730: ( (l_eco_revision_rec.revision_id IS NULL) AND
731: (p_eco_revision_rec.revision_id IS NULL))))
732: AND ( (l_eco_revision_rec.change_notice =
733: p_eco_revision_rec.change_notice) OR
734: ((p_eco_revision_rec.change_notice = FND_API.G_MISS_CHAR) OR
735: ( (l_eco_revision_rec.change_notice IS NULL) AND
736: (p_eco_revision_rec.change_notice IS NULL))))
737: AND ( (l_eco_revision_rec.organization_id =
738: p_eco_revision_rec.organization_id) OR

Line 739: ((p_eco_revision_rec.organization_id = FND_API.G_MISS_NUM) OR

735: ( (l_eco_revision_rec.change_notice IS NULL) AND
736: (p_eco_revision_rec.change_notice IS NULL))))
737: AND ( (l_eco_revision_rec.organization_id =
738: p_eco_revision_rec.organization_id) OR
739: ((p_eco_revision_rec.organization_id = FND_API.G_MISS_NUM) OR
740: ( (l_eco_revision_rec.organization_id IS NULL) AND
741: (p_eco_revision_rec.organization_id IS NULL))))
742: AND ( (l_eco_revision_rec.rev =
743: p_eco_revision_rec.rev) OR

Line 744: ((p_eco_revision_rec.rev = FND_API.G_MISS_CHAR) OR

740: ( (l_eco_revision_rec.organization_id IS NULL) AND
741: (p_eco_revision_rec.organization_id IS NULL))))
742: AND ( (l_eco_revision_rec.rev =
743: p_eco_revision_rec.rev) OR
744: ((p_eco_revision_rec.rev = FND_API.G_MISS_CHAR) OR
745: ( (l_eco_revision_rec.rev IS NULL) AND
746: (p_eco_revision_rec.rev IS NULL))))
747: AND ( (l_eco_revision_rec.last_update_date =
748: p_eco_revision_rec.last_update_date) OR

Line 749: ((p_eco_revision_rec.last_update_date = FND_API.G_MISS_DATE) OR

745: ( (l_eco_revision_rec.rev IS NULL) AND
746: (p_eco_revision_rec.rev IS NULL))))
747: AND ( (l_eco_revision_rec.last_update_date =
748: p_eco_revision_rec.last_update_date) OR
749: ((p_eco_revision_rec.last_update_date = FND_API.G_MISS_DATE) OR
750: ( (l_eco_revision_rec.last_update_date IS NULL) AND
751: (p_eco_revision_rec.last_update_date IS NULL))))
752: AND ( (l_eco_revision_rec.last_updated_by =
753: p_eco_revision_rec.last_updated_by) OR

Line 754: ((p_eco_revision_rec.last_updated_by = FND_API.G_MISS_NUM) OR

750: ( (l_eco_revision_rec.last_update_date IS NULL) AND
751: (p_eco_revision_rec.last_update_date IS NULL))))
752: AND ( (l_eco_revision_rec.last_updated_by =
753: p_eco_revision_rec.last_updated_by) OR
754: ((p_eco_revision_rec.last_updated_by = FND_API.G_MISS_NUM) OR
755: ( (l_eco_revision_rec.last_updated_by IS NULL) AND
756: (p_eco_revision_rec.last_updated_by IS NULL))))
757: AND ( (l_eco_revision_rec.creation_date =
758: p_eco_revision_rec.creation_date) OR

Line 759: ((p_eco_revision_rec.creation_date = FND_API.G_MISS_DATE) OR

755: ( (l_eco_revision_rec.last_updated_by IS NULL) AND
756: (p_eco_revision_rec.last_updated_by IS NULL))))
757: AND ( (l_eco_revision_rec.creation_date =
758: p_eco_revision_rec.creation_date) OR
759: ((p_eco_revision_rec.creation_date = FND_API.G_MISS_DATE) OR
760: ( (l_eco_revision_rec.creation_date IS NULL) AND
761: (p_eco_revision_rec.creation_date IS NULL))))
762: AND ( (l_eco_revision_rec.created_by =
763: p_eco_revision_rec.created_by) OR

Line 764: ((p_eco_revision_rec.created_by = FND_API.G_MISS_NUM) OR

760: ( (l_eco_revision_rec.creation_date IS NULL) AND
761: (p_eco_revision_rec.creation_date IS NULL))))
762: AND ( (l_eco_revision_rec.created_by =
763: p_eco_revision_rec.created_by) OR
764: ((p_eco_revision_rec.created_by = FND_API.G_MISS_NUM) OR
765: ( (l_eco_revision_rec.created_by IS NULL) AND
766: (p_eco_revision_rec.created_by IS NULL))))
767: AND ( (l_eco_revision_rec.last_update_login =
768: p_eco_revision_rec.last_update_login) OR

Line 769: ((p_eco_revision_rec.last_update_login = FND_API.G_MISS_NUM) OR

765: ( (l_eco_revision_rec.created_by IS NULL) AND
766: (p_eco_revision_rec.created_by IS NULL))))
767: AND ( (l_eco_revision_rec.last_update_login =
768: p_eco_revision_rec.last_update_login) OR
769: ((p_eco_revision_rec.last_update_login = FND_API.G_MISS_NUM) OR
770: ( (l_eco_revision_rec.last_update_login IS NULL) AND
771: (p_eco_revision_rec.last_update_login IS NULL))))
772: AND ( (l_eco_revision_rec.comments =
773: p_eco_revision_rec.comments) OR

Line 774: ((p_eco_revision_rec.comments = FND_API.G_MISS_CHAR) OR

770: ( (l_eco_revision_rec.last_update_login IS NULL) AND
771: (p_eco_revision_rec.last_update_login IS NULL))))
772: AND ( (l_eco_revision_rec.comments =
773: p_eco_revision_rec.comments) OR
774: ((p_eco_revision_rec.comments = FND_API.G_MISS_CHAR) OR
775: ( (l_eco_revision_rec.comments IS NULL) AND
776: (p_eco_revision_rec.comments IS NULL))))
777: AND ( (l_eco_revision_rec.attribute_category =
778: p_eco_revision_rec.attribute_category) OR

Line 779: ((p_eco_revision_rec.attribute_category = FND_API.G_MISS_CHAR) OR

775: ( (l_eco_revision_rec.comments IS NULL) AND
776: (p_eco_revision_rec.comments IS NULL))))
777: AND ( (l_eco_revision_rec.attribute_category =
778: p_eco_revision_rec.attribute_category) OR
779: ((p_eco_revision_rec.attribute_category = FND_API.G_MISS_CHAR) OR
780: ( (l_eco_revision_rec.attribute_category IS NULL) AND
781: (p_eco_revision_rec.attribute_category IS NULL))))
782: AND ( (l_eco_revision_rec.attribute1 =
783: p_eco_revision_rec.attribute1) OR

Line 784: ((p_eco_revision_rec.attribute1 = FND_API.G_MISS_CHAR) OR

780: ( (l_eco_revision_rec.attribute_category IS NULL) AND
781: (p_eco_revision_rec.attribute_category IS NULL))))
782: AND ( (l_eco_revision_rec.attribute1 =
783: p_eco_revision_rec.attribute1) OR
784: ((p_eco_revision_rec.attribute1 = FND_API.G_MISS_CHAR) OR
785: ( (l_eco_revision_rec.attribute1 IS NULL) AND
786: (p_eco_revision_rec.attribute1 IS NULL))))
787: AND ( (l_eco_revision_rec.attribute2 =
788: p_eco_revision_rec.attribute2) OR

Line 789: ((p_eco_revision_rec.attribute2 = FND_API.G_MISS_CHAR) OR

785: ( (l_eco_revision_rec.attribute1 IS NULL) AND
786: (p_eco_revision_rec.attribute1 IS NULL))))
787: AND ( (l_eco_revision_rec.attribute2 =
788: p_eco_revision_rec.attribute2) OR
789: ((p_eco_revision_rec.attribute2 = FND_API.G_MISS_CHAR) OR
790: ( (l_eco_revision_rec.attribute2 IS NULL) AND
791: (p_eco_revision_rec.attribute2 IS NULL))))
792: AND ( (l_eco_revision_rec.attribute3 =
793: p_eco_revision_rec.attribute3) OR

Line 794: ((p_eco_revision_rec.attribute3 = FND_API.G_MISS_CHAR) OR

790: ( (l_eco_revision_rec.attribute2 IS NULL) AND
791: (p_eco_revision_rec.attribute2 IS NULL))))
792: AND ( (l_eco_revision_rec.attribute3 =
793: p_eco_revision_rec.attribute3) OR
794: ((p_eco_revision_rec.attribute3 = FND_API.G_MISS_CHAR) OR
795: ( (l_eco_revision_rec.attribute3 IS NULL) AND
796: (p_eco_revision_rec.attribute3 IS NULL))))
797: AND ( (l_eco_revision_rec.attribute4 =
798: p_eco_revision_rec.attribute4) OR

Line 799: ((p_eco_revision_rec.attribute4 = FND_API.G_MISS_CHAR) OR

795: ( (l_eco_revision_rec.attribute3 IS NULL) AND
796: (p_eco_revision_rec.attribute3 IS NULL))))
797: AND ( (l_eco_revision_rec.attribute4 =
798: p_eco_revision_rec.attribute4) OR
799: ((p_eco_revision_rec.attribute4 = FND_API.G_MISS_CHAR) OR
800: ( (l_eco_revision_rec.attribute4 IS NULL) AND
801: (p_eco_revision_rec.attribute4 IS NULL))))
802: AND ( (l_eco_revision_rec.attribute5 =
803: p_eco_revision_rec.attribute5) OR

Line 804: ((p_eco_revision_rec.attribute5 = FND_API.G_MISS_CHAR) OR

800: ( (l_eco_revision_rec.attribute4 IS NULL) AND
801: (p_eco_revision_rec.attribute4 IS NULL))))
802: AND ( (l_eco_revision_rec.attribute5 =
803: p_eco_revision_rec.attribute5) OR
804: ((p_eco_revision_rec.attribute5 = FND_API.G_MISS_CHAR) OR
805: ( (l_eco_revision_rec.attribute5 IS NULL) AND
806: (p_eco_revision_rec.attribute5 IS NULL))))
807: AND ( (l_eco_revision_rec.attribute6 =
808: p_eco_revision_rec.attribute6) OR

Line 809: ((p_eco_revision_rec.attribute6 = FND_API.G_MISS_CHAR) OR

805: ( (l_eco_revision_rec.attribute5 IS NULL) AND
806: (p_eco_revision_rec.attribute5 IS NULL))))
807: AND ( (l_eco_revision_rec.attribute6 =
808: p_eco_revision_rec.attribute6) OR
809: ((p_eco_revision_rec.attribute6 = FND_API.G_MISS_CHAR) OR
810: ( (l_eco_revision_rec.attribute6 IS NULL) AND
811: (p_eco_revision_rec.attribute6 IS NULL))))
812: AND ( (l_eco_revision_rec.attribute7 =
813: p_eco_revision_rec.attribute7) OR

Line 814: ((p_eco_revision_rec.attribute7 = FND_API.G_MISS_CHAR) OR

810: ( (l_eco_revision_rec.attribute6 IS NULL) AND
811: (p_eco_revision_rec.attribute6 IS NULL))))
812: AND ( (l_eco_revision_rec.attribute7 =
813: p_eco_revision_rec.attribute7) OR
814: ((p_eco_revision_rec.attribute7 = FND_API.G_MISS_CHAR) OR
815: ( (l_eco_revision_rec.attribute7 IS NULL) AND
816: (p_eco_revision_rec.attribute7 IS NULL))))
817: AND ( (l_eco_revision_rec.attribute8 =
818: p_eco_revision_rec.attribute8) OR

Line 819: ((p_eco_revision_rec.attribute8 = FND_API.G_MISS_CHAR) OR

815: ( (l_eco_revision_rec.attribute7 IS NULL) AND
816: (p_eco_revision_rec.attribute7 IS NULL))))
817: AND ( (l_eco_revision_rec.attribute8 =
818: p_eco_revision_rec.attribute8) OR
819: ((p_eco_revision_rec.attribute8 = FND_API.G_MISS_CHAR) OR
820: ( (l_eco_revision_rec.attribute8 IS NULL) AND
821: (p_eco_revision_rec.attribute8 IS NULL))))
822: AND ( (l_eco_revision_rec.attribute9 =
823: p_eco_revision_rec.attribute9) OR

Line 824: ((p_eco_revision_rec.attribute9 = FND_API.G_MISS_CHAR) OR

820: ( (l_eco_revision_rec.attribute8 IS NULL) AND
821: (p_eco_revision_rec.attribute8 IS NULL))))
822: AND ( (l_eco_revision_rec.attribute9 =
823: p_eco_revision_rec.attribute9) OR
824: ((p_eco_revision_rec.attribute9 = FND_API.G_MISS_CHAR) OR
825: ( (l_eco_revision_rec.attribute9 IS NULL) AND
826: (p_eco_revision_rec.attribute9 IS NULL))))
827: AND ( (l_eco_revision_rec.attribute10 =
828: p_eco_revision_rec.attribute10) OR

Line 829: ((p_eco_revision_rec.attribute10 = FND_API.G_MISS_CHAR) OR

825: ( (l_eco_revision_rec.attribute9 IS NULL) AND
826: (p_eco_revision_rec.attribute9 IS NULL))))
827: AND ( (l_eco_revision_rec.attribute10 =
828: p_eco_revision_rec.attribute10) OR
829: ((p_eco_revision_rec.attribute10 = FND_API.G_MISS_CHAR) OR
830: ( (l_eco_revision_rec.attribute10 IS NULL) AND
831: (p_eco_revision_rec.attribute10 IS NULL))))
832: THEN
833:

Line 840: x_return_status := FND_API.G_RET_STS_SUCCESS;

836: x_eco_revision_rec := l_eco_revision_rec;
837:
838: -- Set return status
839:
840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841: x_eco_revision_rec.return_status := FND_API.G_RET_STS_SUCCESS;
842:
843: ELSE
844:

Line 841: x_eco_revision_rec.return_status := FND_API.G_RET_STS_SUCCESS;

837:
838: -- Set return status
839:
840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841: x_eco_revision_rec.return_status := FND_API.G_RET_STS_SUCCESS;
842:
843: ELSE
844:
845: -- Row has changed by another user.

Line 847: x_return_status := FND_API.G_RET_STS_ERROR;

843: ELSE
844:
845: -- Row has changed by another user.
846:
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: x_eco_revision_rec.return_status := FND_API.G_RET_STS_ERROR;
849: Eng_Eco_Pub.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC
850: , p_msg_name => 'OE_LOCK_ROW_CHANGED'
851: , x_err_text => x_err_text );

Line 848: x_eco_revision_rec.return_status := FND_API.G_RET_STS_ERROR;

844:
845: -- Row has changed by another user.
846:
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: x_eco_revision_rec.return_status := FND_API.G_RET_STS_ERROR;
849: Eng_Eco_Pub.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC
850: , p_msg_name => 'OE_LOCK_ROW_CHANGED'
851: , x_err_text => x_err_text );
852: END IF;

Line 858: x_return_status := FND_API.G_RET_STS_ERROR;

854: EXCEPTION
855:
856: WHEN NO_DATA_FOUND THEN
857:
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: x_eco_revision_rec.return_status := FND_API.G_RET_STS_ERROR;
860: Eng_Eco_Pub.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC
861: , p_msg_name => 'OE_LOCK_ROW_DELETED'
862: , x_err_text => x_err_text );

Line 859: x_eco_revision_rec.return_status := FND_API.G_RET_STS_ERROR;

855:
856: WHEN NO_DATA_FOUND THEN
857:
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: x_eco_revision_rec.return_status := FND_API.G_RET_STS_ERROR;
860: Eng_Eco_Pub.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC
861: , p_msg_name => 'OE_LOCK_ROW_DELETED'
862: , x_err_text => x_err_text );
863:

Line 866: x_return_status := FND_API.G_RET_STS_ERROR;

862: , x_err_text => x_err_text );
863:
864: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
865:
866: x_return_status := FND_API.G_RET_STS_ERROR;
867: x_eco_revision_rec.return_status := FND_API.G_RET_STS_ERROR;
868: Eng_Eco_Pub.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC
869: , p_msg_name => 'OE_LOCK_ROW_ALREADY_LOCKED'
870: , x_err_text => x_err_text );

Line 867: x_eco_revision_rec.return_status := FND_API.G_RET_STS_ERROR;

863:
864: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
865:
866: x_return_status := FND_API.G_RET_STS_ERROR;
867: x_eco_revision_rec.return_status := FND_API.G_RET_STS_ERROR;
868: Eng_Eco_Pub.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC
869: , p_msg_name => 'OE_LOCK_ROW_ALREADY_LOCKED'
870: , x_err_text => x_err_text );
871: WHEN OTHERS THEN

Line 873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

869: , p_msg_name => 'OE_LOCK_ROW_ALREADY_LOCKED'
870: , x_err_text => x_err_text );
871: WHEN OTHERS THEN
872:
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: x_eco_revision_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
875:
876: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
877: THEN

Line 874: x_eco_revision_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

870: , x_err_text => x_err_text );
871: WHEN OTHERS THEN
872:
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: x_eco_revision_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
875:
876: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
877: THEN
878: x_err_text := G_PKG_NAME || '( Utility ) - Lock_Row' || substr(SQLERRM,1,60);