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

Line 37: ( x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

33: * values into exposed columns and unexposed columns and
34: * return with those records.
35: ***********************************************************************/
36: PROCEDURE Query_Row
37: ( x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
38: , x_Return_status OUT NOCOPY VARCHAR2
39: )
40: IS
41: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

Line 44: Error_Handler.Write_Debug('Performing Query Row for catalog group ' ||

40: IS
41: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
42: l_dummy varchar2(10);
43: BEGIN
44: Error_Handler.Write_Debug('Performing Query Row for catalog group ' ||
45: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Name);
46:
47: SELECT item_catalog_group_id
48: , parent_catalog_group_id

Line 158: ( x_mesg_token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

154: * Return Status
155: * Purpose :
156: *********************************************************************/
157: PROCEDURE Insert_Row
158: ( x_mesg_token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
159: , x_return_Status OUT NOCOPY VARCHAR2
160: )
161: IS
162: l_UserId NUMBER := FND_GLOBAL.User_Id;

Line 167: Error_Handler.Write_Debug('Inserting Catalog Group . . . ');

163: l_LanguageCode VARCHAR2(4) := EGO_Globals.Get_Language_Code;
164:
165: BEGIN
166:
167: Error_Handler.Write_Debug('Inserting Catalog Group . . . ');
168: -- dbms_output.put_line('Inserting Catalog Group . . . ID' || EGO_Globals.G_Catalog_Group_Rec.catalog_group_id);
169:
170: INSERT INTO mtl_Item_Catalog_Groups_b
171: ( item_catalog_group_id

Line 312: Error_Handler.Add_Error_Token

308: );
309:
310: EXCEPTION
311: WHEN OTHERS THEN
312: Error_Handler.Add_Error_Token
313: ( p_message_name => NULL
314: , p_application_id => 'EGO'
315: , p_message_text => G_PKG_NAME ||
316: ' :Inserting Record ' ||

Line 334: ( x_mesg_token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

330: * Purpose : Procedure will perfrom an Update into the
331: * BOM_Bill_Of_Materials table.
332: *********************************************************************/
333: PROCEDURE Update_Row
334: ( x_mesg_token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
335: , x_return_Status OUT NOCOPY VARCHAR2
336: )
337: IS
338:

Line 352: Error_Handler.Write_Debug('Updating catalog group . . . ');

348: --
349: -- User can update the inactive date, description and choose to rename the
350: -- the catalog group.
351: --
352: Error_Handler.Write_Debug('Updating catalog group . . . ');
353:
354: SELECT parent_catalog_group_id
355: INTO l_old_parent_id
356: FROM mtl_item_catalog_groups_b

Line 466: Error_Handler.Add_Error_Token

462: EXCEPTION
463: WHEN OTHERS THEN
464: -- dbms_output.put_line('Error while updating : ' || SQLERRM);
465:
466: Error_Handler.Add_Error_Token
467: ( p_message_name => NULL
468: , p_application_id => 'EGO'
469: , p_message_text => G_PKG_NAME ||
470: ' :Updating Record ' ||

Line 487: ( x_mesg_token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

483: * Return Status
484: * Purpose : Procedure will perfrom an Delete
485: *********************************************************************/
486: PROCEDURE Delete_Row
487: ( x_mesg_token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
488: , x_return_Status OUT NOCOPY VARCHAR2
489: )
490: IS
491: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 491: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

487: ( x_mesg_token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
488: , x_return_Status OUT NOCOPY VARCHAR2
489: )
490: IS
491: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
492:
493: BEGIN
494:
495: /* Delete from TL */

Line 512: Error_Handler.Add_Error_Token

508: EXCEPTION WHEN OTHERS
509: THEN
510: -- dbms_output.put_line('Error while deleting : ' || SQLERRM);
511:
512: Error_Handler.Add_Error_Token
513: ( p_message_name => NULL
514: , p_application_id => 'EGO'
515: , p_message_text => G_PKG_NAME ||
516: ' :Deleting Record ' ||

Line 534: ( x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

530: * access to when he/she needs to perform any kind of
531: * writes to the catalog groups table.
532: *********************************************************************/
533: PROCEDURE Perform_Writes
534: ( x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
535: , x_return_status OUT NOCOPY VARCHAR2
536: )
537: IS
538: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 538: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;

534: ( x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
535: , x_return_status OUT NOCOPY VARCHAR2
536: )
537: IS
538: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;
539: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
540: BEGIN
541: IF EGO_Globals.G_Catalog_Group_Rec.transaction_type = EGO_GLOBALS.G_OPR_CREATE
542: THEN