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.EGO_ITEMCAT_VAL_TO_ID dependencies on ERROR_HANDLER

Line 25: g_token_tbl Error_Handler.Token_Tbl_Type;

21: -- different combinations of key input data(group id,
22: -- name and segments)
23: ****************************************************************************/
24: G_Pkg_Name VARCHAR2(30) := 'EGO_ItemCat_Val_To_Id';
25: g_token_tbl Error_Handler.Token_Tbl_Type;
26:
27:
28: G_Error_Msg_Text VARCHAR2(2000);
29:

Line 433: ( x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

429: * Return Status
430: * Purpose :
431: *********************************************************************/
432: PROCEDURE EGO_ItemCatalog_UUI_To_UI
433: ( x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
434: , x_Return_Status OUT NOCOPY VARCHAR2
435: )
436: IS
437: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 437: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

433: ( x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
434: , x_Return_Status OUT NOCOPY VARCHAR2
435: )
436: IS
437: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
438: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
439: l_result VARCHAR2(2000);
440:
441: is_valid boolean;

Line 476: Error_Handler.Add_Error_Token

472: IF EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name IS NULL
473: THEN
474: -- dbms_output.put_line('concat group name is NULL ' );
475:
476: Error_Handler.Add_Error_Token
477: ( x_mesg_token_Tbl => l_mesg_token_tbl
478: , p_application_id => 'EGO'
479: , p_message_name => 'EGO_CAT_SEGMENTS_INVALID'
480: );

Line 505: Error_Handler.Add_Error_Token

501:
502: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type =
503: EGO_Globals.G_OPR_CREATE
504: THEN
505: Error_Handler.Add_Error_Token
506: ( x_mesg_token_Tbl => l_mesg_token_tbl
507: , p_application_id => 'EGO'
508: , p_message_name => 'EGO_CATALOG_ALREADY_EXISTS'
509: );

Line 522: Error_Handler.Add_Error_Token

518:
519: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type IN
520: (EGO_Globals.G_OPR_UPDATE,EGO_Globals.G_OPR_DELETE)
521: THEN
522: Error_Handler.Add_Error_Token
523: ( x_mesg_token_Tbl => l_mesg_token_tbl
524: , p_application_id => 'EGO'
525: , p_message_name => 'EGO_CATALOG_DOESNOT_EXIST'
526: );

Line 550: Error_Handler.Add_Error_Token

546: Generate_Catalog_Group_Id;
547:
548: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);
549: ELSE
550: Error_Handler.Add_Error_Token
551: ( x_mesg_token_Tbl => l_mesg_token_tbl
552: , p_application_id => 'EGO'
553: , p_message_name => 'EGO_CAT_SEGMENTS_INVALID'
554: );

Line 594: Error_Handler.Add_Error_Token

590:
591: IF l_Catalog_Group_Name IS NOT NULL AND EGO_Globals.G_Catalog_Group_Rec.Transaction_Type =
592: EGO_Globals.G_OPR_CREATE
593: THEN
594: Error_Handler.Add_Error_Token
595: ( x_mesg_token_Tbl => l_mesg_token_tbl
596: , p_application_id => 'EGO'
597: , p_message_name => 'EGO_CATALOG_ALREADY_EXISTS'
598: );

Line 608: Error_Handler.Add_Error_Token

604: ELSIF l_Catalog_Group_Name IS NULL AND
605: EGO_Globals.G_Catalog_Group_Rec.Transaction_Type <> EGO_Globals.G_OPR_CREATE
606: THEN
607:
608: Error_Handler.Add_Error_Token
609: ( x_mesg_token_Tbl => l_mesg_token_tbl
610: , p_application_id => 'EGO'
611: , p_message_name => 'EGO_CATALOG_DOESNOT_EXIST'
612: );

Line 661: Error_Handler.Add_Error_Token

657: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name :=
658: concat_Group_Name;
659: END IF;
660: ELSE
661: Error_Handler.Add_Error_Token
662: ( x_mesg_token_Tbl => l_mesg_token_tbl
663: , p_application_id => 'EGO'
664: , p_message_name => 'EGO_CAT_SEGMENTS_INVALID'
665: );

Line 677: Error_Handler.Add_Error_Token

673: -- the Segments apart from the Id
674:
675: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE
676: THEN
677: Error_Handler.Add_Error_Token
678: ( x_mesg_token_Tbl => l_mesg_token_tbl
679: , p_application_id => 'EGO'
680: , p_message_name => 'EGO_CAT_SEGMENTS_INVALID'
681: );

Line 697: Error_Handler.Write_Debug('getting id for ' ||

693: THEN
694:
695: is_passed := TRUE;
696:
697: Error_Handler.Write_Debug('getting id for ' ||
698: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
699:
700: -- dbms_output.put_line('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
701:

Line 718: Error_Handler.Add_Error_Token

714: when the transaction type is CREATE */
715:
716: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type = EGO_Globals.G_OPR_CREATE
717: THEN
718: Error_Handler.Add_Error_Token
719: ( x_mesg_token_Tbl => l_mesg_token_tbl
720: , p_application_id => 'EGO'
721: , p_message_name => 'EGO_CATALOG_ALREADY_EXISTS'
722: );

Line 733: Error_Handler.Add_Error_Token

729:
730: IF EGO_Globals.G_Catalog_Group_Rec.Transaction_Type IN
731: (EGO_Globals.G_OPR_UPDATE,EGO_Globals.G_OPR_DELETE)
732: THEN
733: Error_Handler.Add_Error_Token
734: ( x_mesg_token_Tbl => l_mesg_token_tbl
735: , p_application_id => 'EGO'
736: , p_message_name => 'EGO_CATALOG_DOESNOT_EXIST'
737: );

Line 757: Error_Handler.Add_Error_Token

753:
754: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);
755: ELSIF (check_status = 0)
756: THEN
757: Error_Handler.Add_Error_Token
758: ( x_mesg_token_Tbl => l_mesg_token_tbl
759: , p_application_id => 'EGO'
760: , p_message_text => G_Error_Msg_Text
761: );

Line 771: Error_Handler.Add_Error_Token

767:
768: -- If there are no key values passed for this row, then raise error
769: --
770: IF NOT is_passed THEN
771: Error_Handler.Add_Error_Token
772: ( x_mesg_token_Tbl => l_mesg_token_tbl
773: , p_application_id => 'EGO'
774: , p_message_text => 'EGO_CAT_KEYCOLS_NOT_PASSED'
775: );

Line 791: Error_Handler.Write_Debug('Parent Catalog Group Id: ' ||

787: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name
788: , p_operation => 'FIND_COMBINATION'
789: );
790:
791: Error_Handler.Write_Debug('Parent Catalog Group Id: ' ||
792: EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);
793:
794: -- dbms_output.put_line('Parent Catalog Group Id: ' || EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);
795:

Line 800: Error_Handler.Add_Error_Token

796: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id IS NULL
797: THEN
798:
799: -- dbms_output.put_line('Parent Catalog Group Id NOT FOUND . . . ');
800: Error_Handler.Add_Error_Token
801: ( x_mesg_token_Tbl => l_mesg_token_tbl
802: , p_application_id => 'EGO'
803: , p_message_text => G_Error_Msg_Text
804: );

Line 826: Error_Handler.Add_Error_Token

822:
823: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name IS NULL
824: THEN
825:
826: Error_Handler.Add_Error_Token
827: ( x_mesg_token_Tbl => l_mesg_token_tbl
828: , p_application_id => 'EGO'
829: , p_message_text => G_Error_Msg_Text
830: );

Line 838: Error_Handler.Write_Debug('UUI Conversion done . . . returning ' || l_return_status) ;

834:
835: END IF;
836:
837: -- dbms_output.put_line('UUI Conversion done . . .returning ' || l_return_status);
838: Error_Handler.Write_Debug('UUI Conversion done . . . returning ' || l_return_status) ;
839:
840: x_return_status := l_return_status;
841: x_mesg_token_tbl := l_mesg_token_tbl;
842:

Line 856: ( x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

852: * Return Status
853: * Purpose :
854: *********************************************************************/
855: PROCEDURE EGO_ItemCatalog_UUI_To_UI2
856: ( x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
857: , x_Return_Status OUT NOCOPY VARCHAR2
858: )
859: IS
860: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 860: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

856: ( x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
857: , x_Return_Status OUT NOCOPY VARCHAR2
858: )
859: IS
860: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
861: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
862: l_result VARCHAR2(2000);
863:
864: is_valid boolean;

Line 902: Error_Handler.Add_Error_Token

898: IF EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name IS NULL
899: THEN
900: -- dbms_output.put_line('concat group name is NULL ' );
901:
902: Error_Handler.Add_Error_Token
903: ( x_mesg_token_Tbl => l_mesg_token_tbl
904: , p_application_id => 'EGO'
905: , p_message_name => 'EGO_CAT_SEGMENTS_INVALID'
906: );

Line 962: Error_Handler.Add_Error_Token

958:
959: IF l_Catalog_Group_Name IS NULL
960: THEN
961:
962: Error_Handler.Add_Error_Token
963: ( x_mesg_token_Tbl => l_mesg_token_tbl
964: , p_application_id => 'EGO'
965: , p_message_text => G_Error_Msg_Text
966: );

Line 1007: Error_Handler.Add_Error_Token

1003: -- during database writes.
1004: check_status := Perform_Segment_Breakup(p_create_new => false);
1005: END IF;
1006: ELSE
1007: Error_Handler.Add_Error_Token
1008: ( x_mesg_token_Tbl => l_mesg_token_tbl
1009: , p_application_id => 'EGO'
1010: , p_message_name => 'EGO_CAT_SEGMENTS_INVALID'
1011: );

Line 1029: Error_Handler.Write_Debug('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);

1025: EGO_Globals.G_Catalog_Group_Rec.catalog_group_id = FND_API.G_MISS_NUM
1026: )
1027: )
1028: THEN
1029: Error_Handler.Write_Debug('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
1030: -- dbms_output.put_line('getting id for ' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_name);
1031: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_id :=
1032: Get_Catalog_Group_Id( p_catalog_group_name =>
1033: EGO_Globals.G_Catalog_Group_Rec.catalog_group_name

Line 1057: Error_Handler.Add_Error_Token

1053:
1054: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);
1055: ELSIF (check_status = 0)
1056: THEN
1057: Error_Handler.Add_Error_Token
1058: ( x_mesg_token_Tbl => l_mesg_token_tbl
1059: , p_application_id => 'EGO'
1060: , p_message_text => G_Error_Msg_Text
1061: );

Line 1099: Error_Handler.Add_Error_Token

1095:
1096: -- dbms_output.put_line('ccid assigned: ' || EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id);
1097: ELSIF (check_status = 0)
1098: THEN
1099: Error_Handler.Add_Error_Token
1100: ( x_mesg_token_Tbl => l_mesg_token_tbl
1101: , p_application_id => 'EGO'
1102: , p_message_text => G_Error_Msg_Text
1103: );

Line 1124: Error_Handler.Write_Debug('Parent Catalog Group Id: ' ||

1120: EGO_Globals.G_Catalog_Group_Rec.parent_catalog_group_name
1121: , p_operation => 'FIND_COMBINATION'
1122: );
1123:
1124: Error_Handler.Write_Debug('Parent Catalog Group Id: ' ||
1125: EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);
1126:
1127: -- dbms_output.put_line('Parent Catalog Group Id: ' || EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id);
1128:

Line 1133: Error_Handler.Add_Error_Token

1129: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id IS NULL
1130: THEN
1131:
1132: -- dbms_output.put_line('Parent Catalog Group Id NOT FOUND . . . ');
1133: Error_Handler.Add_Error_Token
1134: ( x_mesg_token_Tbl => l_mesg_token_tbl
1135: , p_application_id => 'EGO'
1136: , p_message_text => G_Error_Msg_Text
1137: );

Line 1159: Error_Handler.Add_Error_Token

1155:
1156: IF EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name IS NULL
1157: THEN
1158:
1159: Error_Handler.Add_Error_Token
1160: ( x_mesg_token_Tbl => l_mesg_token_tbl
1161: , p_application_id => 'EGO'
1162: , p_message_text => G_Error_Msg_Text
1163: );

Line 1170: Error_Handler.Write_Debug('UUI Conversion done . . . returning ' || l_return_status) ;

1166: -- dbms_output.put_line('Getting Parent Group Name from ID ... ' || EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name);
1167: END IF;
1168:
1169: -- dbms_output.put_line('UUI Conversion done . . .returning ' || l_return_status);
1170: Error_Handler.Write_Debug('UUI Conversion done . . . returning ' || l_return_status) ;
1171:
1172: x_return_status := l_return_status;
1173: x_mesg_token_tbl := l_mesg_token_tbl;
1174:

Line 1188: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

1184: * Purpose :
1185: *********************************************************************/
1186: PROCEDURE EGO_ItemCatalog_VID
1187: ( x_Return_Status OUT NOCOPY VARCHAR2
1188: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1189: )
1190: IS
1191: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
1192: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 1192: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

1188: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1189: )
1190: IS
1191: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
1192: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1193: l_err_text VARCHAR2(2000);
1194: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1195: BEGIN
1196:

Line 1194: l_Token_Tbl Error_Handler.Token_Tbl_Type;

1190: IS
1191: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
1192: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1193: l_err_text VARCHAR2(2000);
1194: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1195: BEGIN
1196:
1197: Error_Handler.Write_Debug('VID conversion . . . ');
1198:

Line 1197: Error_Handler.Write_Debug('VID conversion . . . ');

1193: l_err_text VARCHAR2(2000);
1194: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1195: BEGIN
1196:
1197: Error_Handler.Write_Debug('VID conversion . . . ');
1198:
1199: x_return_status := l_return_status;
1200: x_mesg_token_tbl := l_mesg_token_tbl;
1201: