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 1390: Error_Handler.Add_Error_Token

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

Line 1414: Error_Handler.Add_Error_Token

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

Line 1557: Error_Handler.Add_Error_Token

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

Line 1578: Error_Handler.Add_Error_Token

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

Line 1611: Error_Handler.Add_Error_Token

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

Line 1628: Error_Handler.Add_Error_Token

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

Line 1652: Error_Handler.Add_Error_Token

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

Line 1676: Error_Handler.Add_Error_Token

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

Line 1709: Error_Handler.Add_Error_Token

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

Line 1725: Error_Handler.Add_Error_Token

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

Line 1751: Error_Handler.Add_Error_Token

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

Line 1786: Error_Handler.Add_Error_Token

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

Line 1804: Error_Handler.Add_Error_Token

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

Line 1824: Error_Handler.Add_Error_Token

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

Line 1841: Error_Handler.Add_Error_Token

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

Line 1858: Error_Handler.Add_Error_Token

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

Line 2024: Error_Handler.Add_Error_Token

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

Line 2036: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

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

Line 2045: l_Token_Tbl Error_Handler.Token_Tbl_Type;

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

Line 2046: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

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

Line 2071: Error_Handler.Add_Error_Token

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

Line 2093: Error_Handler.Add_Error_Token

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

Line 2114: Error_Handler.Add_Error_Token

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

Line 2143: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

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

Line 2147: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

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

Line 2150: l_Token_Tbl Error_Handler.Token_Tbl_Type;

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

Line 2173: Error_Handler.Add_Error_Token

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

Line 2185: Error_Handler.Add_Error_Token

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

Line 2198: Error_Handler.Add_Error_Token

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

Line 2212: Error_Handler.Add_Error_Token

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

Line 2303: , p_Mesg_Token_Tbl IN Error_Handler.Mesg_Token_Tbl_Type :=

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

Line 2304: Error_Handler.G_MISS_MESG_TOKEN_TBL

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

Line 2305: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

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

Line 2311: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type :=

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

Line 2313: l_Token_Tbl Error_Handler.Token_Tbl_Type;

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

Line 2508: Error_Handler.Add_Error_Token

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

Line 2517: Error_Handler.Add_Error_Token

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

Line 2526: Error_Handler.Add_Error_Token

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

Line 2537: Error_Handler.Add_Error_Token

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

Line 2548: Error_Handler.Add_Error_Token

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

Line 2560: Error_Handler.Add_Error_Token

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