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_VALIDATE_ECO dependencies on ERROR_HANDLER

Line 177: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

173: IS
174: l_new_assembly_type NUMBER := 0;
175: l_assembly_type NUMBER := 0;
176: l_err_text VARCHAR2(2000) := NULL;
177: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
178: l_eng_item_flag VARCHAR2(1) := 'n';
179: CURSOR eng_item_cur IS
180: SELECT 'y'
181: FROM mtl_system_items

Line 224: Error_Handler.Add_Error_Token

220: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
221: THEN
222: l_err_text := G_PKG_NAME || ' : (Compatible_Change_Order_Type) -
223: Change_Notice ' || substrb(SQLERRM,1,200);
224: Error_Handler.Add_Error_Token
225: ( p_Message_Text => l_err_text
226: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
227: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
228: );

Line 241: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

237: PROCEDURE Check_Delete
238: ( p_eco_rec IN ENG_ECO_PUB.Eco_Rec_Type
239: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
240: , x_return_status OUT NOCOPY VARCHAR2
241: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
242: )
243: IS
244: l_Token_Tbl Error_Handler.Token_Tbl_Type;
245: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 244: l_Token_Tbl Error_Handler.Token_Tbl_Type;

240: , x_return_status OUT NOCOPY VARCHAR2
241: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
242: )
243: IS
244: l_Token_Tbl Error_Handler.Token_Tbl_Type;
245: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
246: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
247:
248: l_ri_exists NUMBER := 0;

Line 245: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

241: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
242: )
243: IS
244: l_Token_Tbl Error_Handler.Token_Tbl_Type;
245: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
246: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
247:
248: l_ri_exists NUMBER := 0;
249: CURSOR GetRevisedItems IS

Line 270: Error_Handler.Add_Error_Token

266: (l_ri_exists = 1 OR p_unexp_eco_rec.approval_status_type in (2,3,5))
267: THEN
268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
269: THEN
270: Error_Handler.Add_Error_Token
271: ( p_Message_Name => 'ENG_ECO_CANNOT_DELETE'
272: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
273: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
274: , p_Token_Tbl => l_Token_Tbl

Line 387: Error_Handler.Write_Debug('Check if Org Hierarchy is valid in org : ' || p_org_id );

383: end ;
384: */
385:
386: IF Bom_Globals.Get_Debug = 'Y' THEN
387: Error_Handler.Write_Debug('Check if Org Hierarchy is valid in org : ' || p_org_id );
388: END IF;
389:
390:
391: FOR l_org_hierarchy_rec IN l_org_hierarchy_csr

Line 398: Error_Handler.Write_Debug('Org hierarchy is valid' );

394: )
395: LOOP
396:
397: IF Bom_Globals.Get_Debug = 'Y' THEN
398: Error_Handler.Write_Debug('Org hierarchy is valid' );
399: END IF;
400:
401: l_ret_status := TRUE ;
402: END LOOP;

Line 458: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

454:
455: PROCEDURE Check_Entity
456: ( x_return_status OUT NOCOPY VARCHAR2
457: , x_err_text OUT NOCOPY VARCHAR2
458: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
459: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
460: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
461: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
462: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type

Line 469: l_Token_Tbl Error_Handler.Token_Tbl_Type;

465:
466: )
467: IS
468: l_err_text VARCHAR2(2000) := NULL;
469: l_Token_Tbl Error_Handler.Token_Tbl_Type;
470: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
471: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
472: l_dummy VARCHAR2(10) := NULL;
473: l_process_name VARCHAR2(30) := NULL;

Line 470: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

466: )
467: IS
468: l_err_text VARCHAR2(2000) := NULL;
469: l_Token_Tbl Error_Handler.Token_Tbl_Type;
470: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
471: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
472: l_dummy VARCHAR2(10) := NULL;
473: l_process_name VARCHAR2(30) := NULL;
474: l_rev_items_scheduled BOOLEAN := FALSE;

Line 577: Error_Handler.Add_Error_Token

573: l_ri_exists = 1
574: THEN
575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
576: THEN
577: Error_Handler.Add_Error_Token
578: ( p_Message_Name => 'ENG_ECO_CANNOT_DELETE'
579: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
580: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
581: , p_Token_Tbl => l_Token_Tbl

Line 593: Error_Handler.Add_Error_Token

589: l_cl_exists =1
590: THEN
591: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
592: THEN
593: Error_Handler.Add_Error_Token
594: ( p_Message_Name => 'ENG_ECO_CANNOT_DELETE_CL'
595: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
596: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
597: , p_Token_Tbl => l_Token_Tbl

Line 609: Error_Handler.Add_Error_Token

605: l_er_exists =1
606: THEN
607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
608: THEN
609: Error_Handler.Add_Error_Token
610: ( p_Message_Name => 'ENG_ECO_CANNOT_DELETE_ER'
611: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
612: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
613: , p_Token_Tbl => l_Token_Tbl

Line 633: Error_Handler.Add_Error_Token

629: l_Token_Tbl(2).token_value := p_Unexp_ECO_rec.status_type;
630:
631: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
632: THEN
633: Error_Handler.Add_Error_Token
634: ( p_Message_Name => 'ENG_ECO_STAT_MUST_NOT_BE_CNCL'
635: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
636: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
637: , p_Token_Tbl => l_Token_Tbl

Line 660: Error_Handler.Add_Error_Token

656: )
657: THEN
658: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
659: THEN
660: Error_Handler.Add_Error_Token
661: ( p_Message_Name => 'ENG_ECO_CANNOT_CNCL_FOR_REV_OP'
662: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
663: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
664: , p_Token_Tbl => l_Token_Tbl

Line 690: Error_Handler.Add_Error_Token

686: l_process_name IS NOT NULL
687: THEN
688: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
689: THEN
690: Error_Handler.Add_Error_Token
691: ( p_Message_Name => 'ENG_APPROV_LIST_PROCESS_EXISTS'
692: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
693: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
694: , p_Token_Tbl => l_Token_Tbl

Line 705: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('process : '|| l_process_name); END IF;

701:
702: -- If there is no approval list or process associated, the approval status can only be rejected or approved
703:
704: stmt_num := 10;
705: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('process : '|| l_process_name); END IF;
706: -- Added following Check as part of Fix to Bug 2815601
707: IF BOM_Globals.G_MASS_CHANGE <> 'MASSCHANGE' THEN
708: IF (p_control_rec.caller_type <> 'FORM' AND
709: p_Unexp_ECO_rec.approval_list_id IS NULL AND

Line 715: Error_Handler.Add_Error_Token

711: p_Unexp_ECO_rec.approval_status_type NOT IN (4,5))
712: THEN
713: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
714: THEN
715: Error_Handler.Add_Error_Token
716: ( p_Message_Name => 'ENG_APP_STATUS_REJ_APPROV'
717: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
718: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
719: , p_Token_Tbl => l_Token_Tbl

Line 741: Error_Handler.Add_Error_Token

737: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
738: THEN
739: l_token_tbl(1).token_name := 'ECO_NAME';
740: l_token_tbl(1).token_value := p_ECO_rec.eco_name;
741: Error_Handler.Add_Error_Token
742: ( p_Message_Name => 'ENG_ECO_MUST_BE_APPROVED'
743: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
744: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
745: , p_Token_Tbl => l_Token_Tbl

Line 766: Error_Handler.Add_Error_Token

762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
763: THEN
764: l_token_tbl(2).token_name := 'APPROVAL_STATUS_TYPE';
765: l_token_tbl(2).token_value := p_Unexp_ECO_rec.Approval_Status_Type;
766: Error_Handler.Add_Error_Token
767: ( p_Message_Name => 'ENG_APP_LIST_APP_STAT_INVALID'
768: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
769: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
770: , p_Token_Tbl => l_Token_Tbl

Line 784: Error_Handler.Add_Error_Token

780: NVL(p_Unexp_ECO_rec.approval_list_id, 0) <> NVL(p_old_Unexp_ECO_rec.approval_list_id, 0))
781: THEN
782: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
783: THEN
784: Error_Handler.Add_Error_Token
785: ( p_Message_Name => 'ENG_APP_LIST_MUST_NOT_CHANGE'
786: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
787: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
788: , p_Token_Tbl => l_Token_Tbl

Line 803: Error_Handler.Add_Error_Token

799: p_Unexp_ECO_rec.status_type <> p_old_Unexp_ECO_rec.status_type)
800: THEN
801: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
802: THEN
803: Error_Handler.Add_Error_Token
804: ( p_Message_Name => 'ENG_STAT_TYPE_MUST_NOT_CHANGE'
805: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
806: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
807: , p_Token_Tbl => l_Token_Tbl

Line 837: Error_Handler.Add_Error_Token

833: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
834: THEN
835: l_token_tbl(2).token_name := 'APPROVAL_STATUS_TYPE';
836: l_token_tbl(2).token_value := p_Unexp_ECO_rec.Approval_Status_Type;
837: Error_Handler.Add_Error_Token
838: ( p_Message_Name => 'ENG_PROC_APP_STAT_INVALID'
839: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
840: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
841: , p_Token_Tbl => l_Token_Tbl

Line 855: Error_Handler.Add_Error_Token

851: p_Unexp_ECO_rec.status_type = 4
852: THEN
853: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
854: THEN
855: Error_Handler.Add_Error_Token
856: ( p_Message_Name => 'ENG_PROC_CANNOT_SCHEDULE'
857: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
858: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
859: );

Line 875: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('eco name: ' || p_eco_rec.eco_name); END IF;

871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
872: THEN
873: l_token_tbl(1).token_value := 'ECO_NAME';
874: l_token_tbl(1).token_value := p_eco_rec.eco_name;
875: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('eco name: ' || p_eco_rec.eco_name); END IF;
876: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('priority_code: ' || p_Eco_rec.priority_code); END IF;
877: l_Token_Tbl(2).Token_Name := 'PRIORITY_CODE';
878: l_Token_Tbl(2).Token_Value := p_ECO_rec.priority_code;
879: Error_Handler.Add_Error_Token

Line 876: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('priority_code: ' || p_Eco_rec.priority_code); END IF;

872: THEN
873: l_token_tbl(1).token_value := 'ECO_NAME';
874: l_token_tbl(1).token_value := p_eco_rec.eco_name;
875: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('eco name: ' || p_eco_rec.eco_name); END IF;
876: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('priority_code: ' || p_Eco_rec.priority_code); END IF;
877: l_Token_Tbl(2).Token_Name := 'PRIORITY_CODE';
878: l_Token_Tbl(2).Token_Value := p_ECO_rec.priority_code;
879: Error_Handler.Add_Error_Token
880: ( p_Message_Name => 'ENG_ECO_REV_ITEMS_SCHED'

Line 879: Error_Handler.Add_Error_Token

875: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('eco name: ' || p_eco_rec.eco_name); END IF;
876: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('priority_code: ' || p_Eco_rec.priority_code); END IF;
877: l_Token_Tbl(2).Token_Name := 'PRIORITY_CODE';
878: l_Token_Tbl(2).Token_Value := p_ECO_rec.priority_code;
879: Error_Handler.Add_Error_Token
880: ( p_Message_Name => 'ENG_ECO_REV_ITEMS_SCHED'
881: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
882: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
883: , p_Token_Tbl => l_Token_Tbl

Line 898: Error_Handler.Add_Error_Token

894: p_ECO_rec.cancellation_comments IS NOT NULL
895: THEN
896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
897: THEN
898: Error_Handler.Add_Error_Token
899: ( p_Message_Name => 'ENG_ECO_CANCL_DETAILS_EXIST'
900: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
901: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
902: , p_Token_Tbl => l_Token_Tbl

Line 928: Error_Handler.Add_Error_Token

924: IF l_change_order_type_same = 0
925: THEN
926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
927: THEN
928: Error_Handler.Add_Error_Token
929: ( p_Message_Name => 'ENG_ECO_CANCL_DETAILS_EXIST'
930: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
931: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
932: , p_Token_Tbl => l_Token_Tbl);

Line 957: Error_Handler.Add_Error_Token

953: )
954: THEN
955: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
956: THEN
957: Error_Handler.Add_Error_Token
958: ( p_Message_Name => 'ENG_HIERARCHY_MUST_NOT_CHANGE'
959: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
960: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
961: , p_Token_Tbl => l_Token_Tbl

Line 982: Error_Handler.Add_Error_Token

978: THEN
979:
980: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
981: THEN
982: Error_Handler.Add_Error_Token
983: ( p_Message_Name => 'ENG_ORG_HIERARCHY_INVALID'
984: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
985: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
986: , p_Token_Tbl => l_Token_Tbl

Line 1004: Error_Handler.Write_Debug('Validation that Change Mgmt Type cannot be chagned . . . ' );

1000: )
1001: THEN
1002:
1003: IF Bom_Globals.Get_Debug = 'Y' THEN
1004: Error_Handler.Write_Debug('Validation that Change Mgmt Type cannot be chagned . . . ' );
1005: Error_Handler.Write_Debug('Old Change Mgmt Type: ' || p_old_Unexp_ECO_rec.Change_Mgmt_Type_Code);
1006: Error_Handler.Write_Debug('New Change Mgmt Type: ' || p_Unexp_ECO_rec.Change_Mgmt_Type_Code);
1007: END IF;
1008:

Line 1005: Error_Handler.Write_Debug('Old Change Mgmt Type: ' || p_old_Unexp_ECO_rec.Change_Mgmt_Type_Code);

1001: THEN
1002:
1003: IF Bom_Globals.Get_Debug = 'Y' THEN
1004: Error_Handler.Write_Debug('Validation that Change Mgmt Type cannot be chagned . . . ' );
1005: Error_Handler.Write_Debug('Old Change Mgmt Type: ' || p_old_Unexp_ECO_rec.Change_Mgmt_Type_Code);
1006: Error_Handler.Write_Debug('New Change Mgmt Type: ' || p_Unexp_ECO_rec.Change_Mgmt_Type_Code);
1007: END IF;
1008:
1009: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 1006: Error_Handler.Write_Debug('New Change Mgmt Type: ' || p_Unexp_ECO_rec.Change_Mgmt_Type_Code);

1002:
1003: IF Bom_Globals.Get_Debug = 'Y' THEN
1004: Error_Handler.Write_Debug('Validation that Change Mgmt Type cannot be chagned . . . ' );
1005: Error_Handler.Write_Debug('Old Change Mgmt Type: ' || p_old_Unexp_ECO_rec.Change_Mgmt_Type_Code);
1006: Error_Handler.Write_Debug('New Change Mgmt Type: ' || p_Unexp_ECO_rec.Change_Mgmt_Type_Code);
1007: END IF;
1008:
1009: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1010: THEN

Line 1011: Error_Handler.Add_Error_Token

1007: END IF;
1008:
1009: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1010: THEN
1011: Error_Handler.Add_Error_Token
1012: ( p_Message_Name => 'ENG_CHANGE_MGMT_MUST_NOT_UPD'
1013: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1014: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1015: , p_Token_Tbl => l_Token_Tbl

Line 1029: Error_Handler.Add_Error_Token

1025: THEN
1026:
1027: IF p_Unexp_ECO_Rec.Requestor_Id IS NULL AND p_Unexp_ECO_Rec.Assignee_Id IS NULL
1028: THEN
1029: Error_Handler.Add_Error_Token
1030: ( p_Message_Name => 'ENG_CHANGE_BOTH_RESP_NULL'
1031: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1032: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1033: , p_Token_Tbl => l_Token_Tbl

Line 1076: Error_Handler.Add_Error_Token

1072: OR l_return_status = FND_API.G_FALSE
1073: THEN
1074: l_return_status := FND_API.G_RET_STS_SUCCESS;
1075: ELSE
1076: Error_Handler.Add_Error_Token
1077: ( p_Message_Name => 'ENG_CHANGE_REQUESTOR_GRANT'
1078: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1079: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1080: , p_Token_Tbl => l_Token_Tbl

Line 1116: Error_Handler.Add_Error_Token

1112: OR l_return_status = FND_API.G_FALSE
1113: THEN
1114: l_return_status := FND_API.G_RET_STS_SUCCESS;
1115: ELSE
1116: Error_Handler.Add_Error_Token
1117: ( p_Message_Name => 'ENG_CHANGE_ASSIGNEE_GRANT'
1118: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1119: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1120: , p_Token_Tbl => l_Token_Tbl

Line 1140: Error_Handler.Add_Error_Token

1136:
1137: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1138: THEN
1139: l_err_text := G_PKG_NAME || ' : (Entity Validation) ' || substrb(SQLERRM,1,200);
1140: Error_Handler.Add_Error_Token
1141: ( p_Message_Text => l_err_text
1142: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1143: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1144: );

Line 1154: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

1150:
1151: PROCEDURE Check_Attributes
1152: ( x_return_status OUT NOCOPY VARCHAR2
1153: , x_err_text OUT NOCOPY VARCHAR2
1154: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1155: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
1156: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
1157: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
1158: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type

Line 1164: l_Token_Tbl Error_Handler.Token_Tbl_Type;

1160: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type --Bug 2908248
1161: )
1162: IS
1163: l_err_text VARCHAR2(2000) := '';
1164: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1165: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1166: l_disable_date DATE;
1167: ----Bug 2908248
1168: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;

Line 1165: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

1161: )
1162: IS
1163: l_err_text VARCHAR2(2000) := '';
1164: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1165: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1166: l_disable_date DATE;
1167: ----Bug 2908248
1168: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
1169: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type ;

Line 1245: Error_Handler.Add_Error_Token

1241: IF p_Unexp_ECO_rec.Approval_Status_Type = FND_API.G_MISS_NUM
1242: THEN
1243: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1244: THEN
1245: Error_Handler.Add_Error_Token
1246: ( p_Message_Name => 'ENG_APPROVAL_STAT_TYPE_NULL'
1247: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1248: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1249: , p_Token_Tbl => l_Token_Tbl

Line 1277: Error_Handler.Add_Error_Token

1273: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1274: THEN
1275: l_token_tbl(2).token_name := 'APPROVAL_STATUS_TYPE';
1276: l_token_tbl(2).token_value := p_Unexp_ECO_Rec.Approval_Status_Type;
1277: Error_Handler.Add_Error_Token
1278: ( p_Message_Name => 'ENG_APPROVAL_STAT_INVALID'
1279: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1280: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1281: , p_Token_Tbl => l_Token_Tbl

Line 1310: Error_Handler.Add_Error_Token

1306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1307: THEN
1308: l_token_tbl(2).token_name := 'ECO_DEPARTMENT';
1309: l_token_tbl(2).token_value := p_ECO_Rec.ECO_Department_Name;
1310: Error_Handler.Add_Error_Token
1311: ( p_Message_Name => 'ENG_RESP_ORG_DISABLED'
1312: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1313: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1314: , p_Token_Tbl => l_Token_Tbl

Line 1326: Error_Handler.Add_Error_Token

1322: IF p_Unexp_ECO_Rec.Status_Type = FND_API.G_MISS_NUM
1323: THEN
1324: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1325: THEN
1326: Error_Handler.Add_Error_Token
1327: ( p_Message_Name => 'ENG_ECO_STAT_TYPE_MISSING'
1328: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1329: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1330: , p_Token_Tbl => l_Token_Tbl

Line 1357: Error_Handler.Add_Error_Token

1353: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1354: THEN
1355: l_token_tbl(2).token_name := 'STATUS_TYPE';
1356: l_token_tbl(2).token_value := p_Unexp_ECO_Rec.Status_Type;
1357: Error_Handler.Add_Error_Token
1358: ( p_Message_Name => 'ENG_STATUS_TYPE_INVALID'
1359: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1360: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1361: , p_Token_Tbl => l_Token_Tbl

Line 1392: Error_Handler.Add_Error_Token

1388: l_token_tbl(1).token_value := p_Unexp_ECO_Rec.Status_Type;
1389:
1390: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1391: THEN
1392: Error_Handler.Add_Error_Token
1393: ( p_Message_Name => 'ENG_ECO_CREATE_STAT_INVALID'
1394: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1395: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1396: , p_Token_Tbl => l_Token_Tbl

Line 1417: Error_Handler.Add_Error_Token

1413: l_token_tbl(1).token_value := p_Unexp_ECO_Rec.Status_Type;
1414:
1415: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1416: THEN
1417: Error_Handler.Add_Error_Token
1418: ( p_Message_Name => 'ENG_ECO_CREATE_STAT_INVALID'
1419: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1420: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1421: , p_Token_Tbl => l_Token_Tbl

Line 1560: Error_Handler.Add_Error_Token

1556: l_token_tbl(1).token_name := 'STATUS_NAME';
1557: l_token_tbl(1).token_value := p_Unexp_ECO_Rec.Status_Type;
1558: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1559: THEN
1560: Error_Handler.Add_Error_Token
1561: ( p_Message_Name => 'ENG_ECO_CREATE_STAT_INVALID'
1562: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1563: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1564: , p_Token_Tbl => l_Token_Tbl

Line 1581: Error_Handler.Add_Error_Token

1577: IF p_Unexp_ECO_rec.status_type = 6
1578: THEN
1579: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1580: THEN
1581: Error_Handler.Add_Error_Token
1582: ( p_Message_Name => 'ENG_ECO_STAT_CANNOT_BE_IMPL'
1583: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1584: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1585: );

Line 1614: Error_Handler.Add_Error_Token

1610: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1611: THEN
1612: l_token_tbl(2).token_name := 'PRIORITY_CODE';
1613: l_token_tbl(2).token_value := p_ECO_Rec.Priority_Code;
1614: Error_Handler.Add_Error_Token
1615: ( p_Message_Name => 'ENG_PRIORITY_CODE_INVALID'
1616: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1617: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1618: , p_Token_Tbl => l_Token_Tbl

Line 1631: Error_Handler.Add_Error_Token

1627: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1628: THEN
1629: l_token_tbl(2).token_name := 'PRIORITY_CODE';
1630: l_token_tbl(2).token_value := p_ECO_Rec.Priority_Code;
1631: Error_Handler.Add_Error_Token
1632: ( p_Message_Name => 'ENG_PRIORITY_CODE_DISABLED'
1633: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1634: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1635: , p_Token_Tbl => l_Token_Tbl

Line 1655: Error_Handler.Add_Error_Token

1651: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1652: THEN
1653: l_token_tbl(2).token_name := 'PRIORITY_CODE';
1654: l_token_tbl(2).token_value := p_ECO_Rec.Priority_Code;
1655: Error_Handler.Add_Error_Token
1656: ( p_Message_Name => 'ENG_PRIORITY_CODE_INVALID'
1657: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1658: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1659: , p_Token_Tbl => l_Token_Tbl

Line 1679: Error_Handler.Add_Error_Token

1675: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1676: THEN
1677: l_token_tbl(2).token_name := 'ECO_NAME';
1678: l_token_tbl(2).token_value := p_ECO_Rec.Eco_Name;
1679: Error_Handler.Add_Error_Token
1680: ( p_Message_Name => 'ENG_PRIORITY_CODE_INVALID'
1681: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1682: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1683: , p_Token_Tbl => l_Token_Tbl

Line 1712: Error_Handler.Add_Error_Token

1708: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1709: THEN
1710: l_token_tbl(2).token_name := 'REASON_CODE';
1711: l_token_tbl(2).token_value := p_ECO_Rec.Reason_Code;
1712: Error_Handler.Add_Error_Token
1713: ( p_Message_Name => 'ENG_REASON_CODE_INVALID'
1714: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1715: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1716: , p_Token_Tbl => l_Token_Tbl

Line 1728: Error_Handler.Add_Error_Token

1724: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1725: THEN
1726: l_token_tbl(2).token_name := 'REASON_CODE';
1727: l_token_tbl(2).token_value := p_ECO_Rec.Reason_Code;
1728: Error_Handler.Add_Error_Token
1729: ( p_Message_Name => 'ENG_REASON_CODE_DISABLED'
1730: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1731: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1732: , p_Token_Tbl => l_Token_Tbl

Line 1754: Error_Handler.Add_Error_Token

1750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1751: THEN
1752: l_token_tbl(2).token_name := 'REASON_CODE';
1753: l_token_tbl(2).token_value := p_ECO_Rec.Reason_Code;
1754: Error_Handler.Add_Error_Token
1755: ( p_Message_Name => 'ENG_REASON_CODE_INVALID'
1756: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1757: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1758: , p_Token_Tbl => l_Token_Tbl

Line 1789: Error_Handler.Add_Error_Token

1785: IF p_ECO_rec.hierarchy_flag = FND_API.G_MISS_NUM
1786: THEN
1787: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1788: THEN
1789: Error_Handler.Add_Error_Token
1790: ( p_Message_Name => 'ENG_HIERARCHY_FLAG_MISSING'
1791: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1792: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1793: , p_Token_Tbl => l_Token_Tbl

Line 1807: Error_Handler.Add_Error_Token

1803: AND p_ECO_rec.hierarchy_flag <> FND_API.G_MISS_NUM
1804: THEN
1805: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1806: THEN
1807: Error_Handler.Add_Error_Token
1808: ( p_Message_Name => 'ENG_HIERARCHY_FLAG_INVALID'
1809: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1810: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1811: , p_Token_Tbl => l_Token_Tbl

Line 1827: Error_Handler.Add_Error_Token

1823: AND p_ECO_rec.internal_use_only <> FND_API.G_MISS_NUM
1824: THEN
1825: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1826: THEN
1827: Error_Handler.Add_Error_Token
1828: ( p_Message_Name => 'ENG_INTL_USE_ONLY_FLAG_INVALID'
1829: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1830: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1831: , p_Token_Tbl => l_Token_Tbl

Line 1844: Error_Handler.Add_Error_Token

1840: AND p_ECO_rec.need_by_date IS NOT NULL
1841: THEN
1842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1843: THEN
1844: Error_Handler.Add_Error_Token
1845: ( p_Message_Name => 'ENG_NEED_BY_DATE_LESS_CURR'
1846: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1847: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1848: , p_Token_Tbl => l_Token_Tbl

Line 1861: Error_Handler.Add_Error_Token

1857: AND p_ECO_rec.effort IS NOT NULL
1858: THEN
1859: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1860: THEN
1861: Error_Handler.Add_Error_Token
1862: ( p_Message_Name => 'ENG_EFFORT_LESS_ZERO'
1863: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1864: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1865: , p_Token_Tbl => l_Token_Tbl

Line 2027: Error_Handler.Add_Error_Token

2023: x_err_text := l_err_text;
2024:
2025: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2026: THEN
2027: Error_Handler.Add_Error_Token
2028: ( p_Message_Text => l_err_text
2029: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2030: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
2031: );

Line 2039: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

2035: -- Procedure Check_Required
2036:
2037: PROCEDURE Conditionally_Required
2038: ( x_return_status OUT NOCOPY VARCHAR2
2039: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2040: , p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type
2041: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
2042: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
2043: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type

Line 2048: l_Token_Tbl Error_Handler.Token_Tbl_Type;

2044: )
2045: IS
2046: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2047: l_err_text VARCHAR2(2000) := NULL;
2048: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2049: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2050: BEGIN
2051:
2052: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2049: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

2045: IS
2046: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2047: l_err_text VARCHAR2(2000) := NULL;
2048: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2049: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2050: BEGIN
2051:
2052: x_return_status := FND_API.G_RET_STS_SUCCESS;
2053:

Line 2074: Error_Handler.Add_Error_Token

2070: AND p_Unexp_ECO_rec.responsible_org_id IS NULL
2071: THEN
2072: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2073: THEN
2074: Error_Handler.Add_Error_Token
2075: ( p_Message_Name => 'ENG_RESP_ORG_MISSING'
2076: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2077: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
2078: , p_Token_Tbl => l_Token_Tbl

Line 2096: Error_Handler.Add_Error_Token

2092: THEN
2093:
2094: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2095: THEN
2096: Error_Handler.Add_Error_Token
2097: ( p_Message_Name => 'ENG_ORG_HIERARCHY_MISSING'
2098: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2099: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
2100: , p_Token_Tbl => l_Token_Tbl

Line 2117: Error_Handler.Add_Error_Token

2113:
2114: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2115: THEN
2116: l_err_text := G_PKG_NAME || ' : (Conditionally Required Fields Check) ' || substrb(SQLERRM,1,200);
2117: Error_Handler.Add_Error_Token
2118: ( p_Message_Text => l_err_text
2119: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2120: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
2121: );

Line 2146: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

2142: , p_calling_entity IN VARCHAR2
2143: , p_transaction_type IN VARCHAR2
2144: , x_eco_rec OUT NOCOPY Eng_Eco_Pub.Eco_Rec_Type
2145: , x_eco_unexp_rec OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2146: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2147: , x_Return_Status OUT NOCOPY VARCHAR2
2148: )
2149: IS
2150: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 2150: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

2146: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2147: , x_Return_Status OUT NOCOPY VARCHAR2
2148: )
2149: IS
2150: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2151: l_return_status VARCHAR2(1);
2152: l_err_text VARCHAR2(2000);
2153: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2154: BEGIN

Line 2153: l_Token_Tbl Error_Handler.Token_Tbl_Type;

2149: IS
2150: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2151: l_return_status VARCHAR2(1);
2152: l_err_text VARCHAR2(2000);
2153: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2154: BEGIN
2155: l_return_status := FND_API.G_RET_STS_SUCCESS;
2156:
2157: l_token_tbl(1).token_name := 'ECO_NAME';

Line 2176: Error_Handler.Add_Error_Token

2172: p_calling_entity = 'ECO' AND
2173: p_transaction_type = Eng_Globals.G_OPR_CREATE
2174: THEN
2175: l_return_status := FND_API.G_RET_STS_ERROR;
2176: Error_Handler.Add_Error_Token
2177: ( p_Message_Name => 'ENG_ECO_ALREADY_EXISTS'
2178: , p_Mesg_Token_Tbl => l_mesg_token_tbl
2179: , x_Mesg_Token_Tbl => l_mesg_token_tbl
2180: , p_Token_Tbl => l_token_tbl

Line 2188: Error_Handler.Add_Error_Token

2184: p_transaction_type = Eng_Globals.G_OPR_UPDATE AND
2185: x_eco_unexp_rec.approval_status_type in (3, 5) -- approved or approval requested
2186: THEN
2187: l_return_status := FND_API.G_RET_STS_ERROR;
2188: Error_Handler.Add_Error_Token
2189: ( p_Message_Name => 'ENG_ECO_CANNOT_UPDATE'
2190: , p_Mesg_Token_Tbl => l_mesg_token_tbl
2191: , x_Mesg_Token_Tbl => l_mesg_token_tbl
2192: , p_Token_Tbl => l_token_tbl

Line 2201: Error_Handler.Add_Error_Token

2197: p_transaction_type IN
2198: ( Eng_Globals.G_OPR_UPDATE, Eng_Globals.G_OPR_DELETE)
2199: THEN
2200: l_return_status := FND_API.G_RET_STS_ERROR;
2201: Error_Handler.Add_Error_Token
2202: ( p_Message_Name => 'ENG_ECO_DOES_NOT_EXIST'
2203: , p_Mesg_Token_Tbl => l_mesg_token_tbl
2204: , x_Mesg_Token_Tbl => l_mesg_token_tbl
2205: , p_Token_Tbl => l_token_tbl

Line 2215: Error_Handler.Add_Error_Token

2211: l_return_status := FND_API.G_RET_STS_ERROR;
2212:
2213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2214: THEN
2215: Error_Handler.Add_Error_Token
2216: ( p_Message_Name => NULL
2217: , p_Message_Text => l_err_text
2218: , p_Mesg_Token_Tbl => l_mesg_token_tbl
2219: , x_Mesg_Token_Tbl => l_mesg_token_tbl

Line 2306: , p_Mesg_Token_Tbl IN Error_Handler.Mesg_Token_Tbl_Type :=

2302: ( p_change_notice IN VARCHAR2
2303: , p_organization_id IN NUMBER
2304: , p_change_type_code IN VARCHAR2 := NULL
2305: , p_change_order_type_id IN NUMBER := NULL
2306: , p_Mesg_Token_Tbl IN Error_Handler.Mesg_Token_Tbl_Type :=
2307: Error_Handler.G_MISS_MESG_TOKEN_TBL
2308: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2309: , x_Return_Status OUT NOCOPY VARCHAR2
2310: , p_check_scheduled_status IN BOOLEAN DEFAULT TRUE -- Added for Enhancement 5470261

Line 2307: Error_Handler.G_MISS_MESG_TOKEN_TBL

2303: , p_organization_id IN NUMBER
2304: , p_change_type_code IN VARCHAR2 := NULL
2305: , p_change_order_type_id IN NUMBER := NULL
2306: , p_Mesg_Token_Tbl IN Error_Handler.Mesg_Token_Tbl_Type :=
2307: Error_Handler.G_MISS_MESG_TOKEN_TBL
2308: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2309: , x_Return_Status OUT NOCOPY VARCHAR2
2310: , p_check_scheduled_status IN BOOLEAN DEFAULT TRUE -- Added for Enhancement 5470261
2311: , p_status_check_required IN BOOLEAN DEFAULT TRUE -- Added for enhancement 5414834

Line 2308: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

2304: , p_change_type_code IN VARCHAR2 := NULL
2305: , p_change_order_type_id IN NUMBER := NULL
2306: , p_Mesg_Token_Tbl IN Error_Handler.Mesg_Token_Tbl_Type :=
2307: Error_Handler.G_MISS_MESG_TOKEN_TBL
2308: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2309: , x_Return_Status OUT NOCOPY VARCHAR2
2310: , p_check_scheduled_status IN BOOLEAN DEFAULT TRUE -- Added for Enhancement 5470261
2311: , p_status_check_required IN BOOLEAN DEFAULT TRUE -- Added for enhancement 5414834
2312: )

Line 2314: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type :=

2310: , p_check_scheduled_status IN BOOLEAN DEFAULT TRUE -- Added for Enhancement 5470261
2311: , p_status_check_required IN BOOLEAN DEFAULT TRUE -- Added for enhancement 5414834
2312: )
2313: IS
2314: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type :=
2315: p_Mesg_Token_Tbl;
2316: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2317: l_return_status VARCHAR2(1);
2318: l_ProcessExists BOOLEAN;

Line 2316: l_Token_Tbl Error_Handler.Token_Tbl_Type;

2312: )
2313: IS
2314: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type :=
2315: p_Mesg_Token_Tbl;
2316: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2317: l_return_status VARCHAR2(1);
2318: l_ProcessExists BOOLEAN;
2319: l_WorkflowInprogressExists BOOLEAN; -- bug no 3591968 by Rashmi
2320: l_Wkfl NUMBER; -- bug no 3591968 by Rashmi

Line 2511: Error_Handler.Add_Error_Token

2507:
2508: IF NVL(Eng_Globals.Is_Eco_Impl, FALSE) = TRUE
2509: THEN
2510: l_return_status := FND_API.G_RET_STS_ERROR;
2511: Error_Handler.Add_Error_Token
2512: ( p_Message_Name => 'ENG_ECO_IMPLEMENTED'
2513: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2514: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2515: , p_Token_Tbl => l_Token_Tbl

Line 2520: Error_Handler.Add_Error_Token

2516: );
2517: ELSIF NVL(Eng_Globals.Is_Eco_Cancl, FALSE) = TRUE
2518: THEN
2519: l_return_status := FND_API.G_RET_STS_ERROR;
2520: Error_Handler.Add_Error_Token
2521: ( p_Message_Name => 'ENG_ECO_CANCELLED'
2522: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2523: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2524: , p_Token_Tbl => l_Token_Tbl

Line 2529: Error_Handler.Add_Error_Token

2525: );
2526: ELSIF NVL(Eng_Globals.Is_WKFL_Process, FALSE) = TRUE
2527: THEN
2528: l_return_status := FND_API.G_RET_STS_ERROR;
2529: Error_Handler.Add_Error_Token
2530: ( p_Message_Name => 'ENG_ECO_WKFL_EXISTS'
2531: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2532: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2533: , p_Token_Tbl => l_Token_Tbl

Line 2540: Error_Handler.Add_Error_Token

2536: THEN
2537: l_return_status := FND_API.G_RET_STS_ERROR;
2538: l_token_tbl(2).token_name := 'CHANGE_TYPE_CODE';
2539: l_token_tbl(2).token_value := p_change_type_code;
2540: Error_Handler.Add_Error_Token
2541: ( p_Message_Name => 'ENG_ECO_ACCESS_DENIED'
2542: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2543: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2544: , p_Token_Tbl => l_Token_Tbl

Line 2551: Error_Handler.Add_Error_Token

2547: --Check if Workflow is in progress
2548: IF l_WorkflowInprogressExists = TRUE
2549: THEN
2550: l_return_status := FND_API.G_RET_STS_ERROR;
2551: Error_Handler.Add_Error_Token
2552: ( p_Message_Name => 'ENG_ECO_WKFL_INPROGRESS'
2553: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2554: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2555: , p_Token_Tbl => l_Token_Tbl

Line 2563: Error_Handler.Add_Error_Token

2559: THEN
2560: l_Token_Tbl(2).token_name := 'STATUS_NAME';
2561: l_Token_Tbl(2).token_value := l_status_name;
2562: l_return_status := FND_API.G_RET_STS_ERROR;
2563: Error_Handler.Add_Error_Token
2564: ( p_Message_Name => 'ENG_CHGUPD_NOTALLOWED'
2565: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2566: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2567: , p_Token_Tbl => l_Token_Tbl