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_ICC_BULKLOAD_PVT dependencies on EGO_ITEM_CATALOG_PUB

Line 3794: l_null_icc_rec_type EGO_ITEM_CATALOG_PUB.Catalog_Group_Rec_Type := null ;

3790: , x_return_msg OUT NOCOPY VARCHAR2
3791: )
3792: IS
3793: l_proc_name CONSTANT VARCHAR2(30) := 'Attribute_Defaulting';
3794: l_null_icc_rec_type EGO_ITEM_CATALOG_PUB.Catalog_Group_Rec_Type := null ;
3795: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;
3796:
3797:
3798: -- for error logging

Line 3811: --- defaulting of other columns takes place in the EGO_ITEM_CATALOG_PUB API

3807: x_return_status := G_RET_STS_SUCCESS;
3808:
3809: IF p_entity = G_ENTITY_ICC_HEADER then
3810:
3811: --- defaulting of other columns takes place in the EGO_ITEM_CATALOG_PUB API
3812: ---
3813: IF (p_icc_rec.Item_Creation_Allowed_Flag = G_MISS_CHAR OR p_icc_rec.Item_Creation_Allowed_Flag IS NULL ) then
3814: p_icc_rec.Item_Creation_Allowed_Flag := 'N';
3815: END IF;

Line 3956: l_null_icc_rec_type EGO_ITEM_CATALOG_PUB.Catalog_Group_Rec_Type := null ;

3952: )
3953: IS
3954: l_proc_name CONSTANT VARCHAR2(30) := 'Populate_Null_Cols';
3955:
3956: l_null_icc_rec_type EGO_ITEM_CATALOG_PUB.Catalog_Group_Rec_Type := null ;
3957: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;
3958:
3959:
3960: -- for error logging

Line 4046: -- Populating NULL is taken care by EGO_ITEM_CATALOG_PUB API ,

4042: END IF;
4043: end comment Bug 12394675 */
4044:
4045: -- Start DFF attributes
4046: -- Populating NULL is taken care by EGO_ITEM_CATALOG_PUB API ,
4047: -- adding only the additional columns not accepted by the API
4048: --
4049:
4050: IF p_icc_rec.ITEM_NUM_GEN_METHOD_TYPE = G_MISS_CHAR THEN

Line 4640: l_null_icc_rec_type EGO_ITEM_CATALOG_PUB.Catalog_Group_Rec_Type := null ;

4636: )
4637: IS
4638: l_proc_name CONSTANT VARCHAR2(30) := 'Value_To_ID_COnversion';
4639: e_stop_processing EXCEPTION;
4640: l_null_icc_rec_type EGO_ITEM_CATALOG_PUB.Catalog_Group_Rec_Type := null ;
4641: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;
4642: l_dummy boolean;
4643: l_data_level_id ego_data_level_b.data_level_id%TYPE := NULL;
4644: l_icc_name mtl_item_catalog_groups_b_kfv.padded_concatenated_segments%TYPE := null;

Line 5502: --- it to the record type required by the ego_item_catalog_pub API

5498: END Create_Draft_Version;
5499:
5500: /********************************************************************
5501: --- This procedure accepts the interface table record type , converts
5502: --- it to the record type required by the ego_item_catalog_pub API
5503: ---
5504: ********************************************************************/
5505:
5506:

Line 5509: , x_api_icc_rec OUT NOCOPY EGO_ITEM_CATALOG_PUB.Catalog_Group_Rec_Type

5505:
5506:
5507: PROCEDURE Convert_intf_rec_to_API_type ( p_entity IN VARCHAR2
5508: , p_icc_rec IN ego_icc_rec_type
5509: , x_api_icc_rec OUT NOCOPY EGO_ITEM_CATALOG_PUB.Catalog_Group_Rec_Type
5510: )
5511: IS
5512: l_proc_name VARCHAR2(30) := 'Convert_to_API_tbl_type';
5513: BEGIN

Line 5575: --- This procedure accepts the ego_item_catalog_pub API record type , converts

5571: END Convert_intf_rec_to_API_type;
5572:
5573:
5574: /********************************************************************
5575: --- This procedure accepts the ego_item_catalog_pub API record type , converts
5576: --- it to the interface table record type
5577: ---
5578: ********************************************************************/
5579:

Line 5582: , p_api_icc_rec IN EGO_ITEM_CATALOG_PUB.Catalog_Group_Rec_Type

5578: ********************************************************************/
5579:
5580: PROCEDURE Convert_API_type_to_intf_rec ( p_entity IN VARCHAR2
5581: , x_icc_rec IN OUT NOCOPY ego_icc_rec_type
5582: , p_api_icc_rec IN EGO_ITEM_CATALOG_PUB.Catalog_Group_Rec_Type
5583: )
5584: IS
5585: l_proc_name VARCHAR2(30) := 'Convert_API_type_to_intf_rec';
5586: BEGIN

Line 6643: l_api_icc_rec EGO_ITEM_CATALOG_PUB.Catalog_Group_Rec_Type := null;

6639: is
6640:
6641: l_proc_name VARCHAR2(30) := 'Create_ICC';
6642:
6643: l_api_icc_rec EGO_ITEM_CATALOG_PUB.Catalog_Group_Rec_Type := null;
6644: l_api_icc_tbl EGO_ITEM_CATALOG_PUB.Catalog_Group_Tbl_Type;
6645: x_api_icc_tbl EGO_ITEM_CATALOG_PUB.Catalog_Group_Tbl_Type;
6646:
6647: l_grant_guid fnd_grants.grant_guid%TYPE;

Line 6644: l_api_icc_tbl EGO_ITEM_CATALOG_PUB.Catalog_Group_Tbl_Type;

6640:
6641: l_proc_name VARCHAR2(30) := 'Create_ICC';
6642:
6643: l_api_icc_rec EGO_ITEM_CATALOG_PUB.Catalog_Group_Rec_Type := null;
6644: l_api_icc_tbl EGO_ITEM_CATALOG_PUB.Catalog_Group_Tbl_Type;
6645: x_api_icc_tbl EGO_ITEM_CATALOG_PUB.Catalog_Group_Tbl_Type;
6646:
6647: l_grant_guid fnd_grants.grant_guid%TYPE;
6648:

Line 6645: x_api_icc_tbl EGO_ITEM_CATALOG_PUB.Catalog_Group_Tbl_Type;

6641: l_proc_name VARCHAR2(30) := 'Create_ICC';
6642:
6643: l_api_icc_rec EGO_ITEM_CATALOG_PUB.Catalog_Group_Rec_Type := null;
6644: l_api_icc_tbl EGO_ITEM_CATALOG_PUB.Catalog_Group_Tbl_Type;
6645: x_api_icc_tbl EGO_ITEM_CATALOG_PUB.Catalog_Group_Tbl_Type;
6646:
6647: l_grant_guid fnd_grants.grant_guid%TYPE;
6648:
6649: x_message_list Error_Handler.Error_Tbl_Type;

Line 6738: write_debug(l_proc_name, 'Call EGO_ITEM_CATALOG_PUB.Calling Process_Catalog_Groups ');

6734:
6735: l_api_icc_tbl(1) := l_api_icc_rec;
6736: write_debug(l_proc_name, 'Convert Intf rec to API type end');
6737:
6738: write_debug(l_proc_name, 'Call EGO_ITEM_CATALOG_PUB.Calling Process_Catalog_Groups ');
6739:
6740: --*****************************************************
6741: -- CREATE/UPDATE Base ICC
6742: --*****************************************************

Line 6745: EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups

6741: -- CREATE/UPDATE Base ICC
6742: --*****************************************************
6743: l_entity_code := G_ENTITY_ICC_HEADER; -- for error handler
6744:
6745: EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups
6746: (
6747: p_api_version_number => 1.0
6748: , p_init_msg_list => FALSE --- need to be FALSE since this API uses the same error_handler pkg bug 9767869
6749: , p_catalog_group_tbl => l_api_icc_tbl

Line 6761: write_debug(l_proc_name, 'End EGO_ITEM_CATALOG_PUB.Calling Process_Catalog_Groups msg count=>'||l_message_count);

6757: , p_bo_identifier =>'ICC'
6758: --, p_language_code IN VARCHAR2 := 'US'
6759: );
6760:
6761: write_debug(l_proc_name, 'End EGO_ITEM_CATALOG_PUB.Calling Process_Catalog_Groups msg count=>'||l_message_count);
6762:
6763: IF x_return_status = G_RET_STS_ERROR THEN
6764:
6765: Error_Handler.GET_MESSAGE_LIST(x_message_list=>x_message_list);

Line 6766: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', 'Error Messages :');

6762:
6763: IF x_return_status = G_RET_STS_ERROR THEN
6764:
6765: Error_Handler.GET_MESSAGE_LIST(x_message_list=>x_message_list);
6766: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', 'Error Messages :');
6767:
6768: FOR i IN 1..l_message_count LOOP
6769: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', x_message_list(i).message_text);
6770:

Line 6769: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', x_message_list(i).message_text);

6765: Error_Handler.GET_MESSAGE_LIST(x_message_list=>x_message_list);
6766: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', 'Error Messages :');
6767:
6768: FOR i IN 1..l_message_count LOOP
6769: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', x_message_list(i).message_text);
6770:
6771: ERROR_HANDLER.Add_Error_Message(
6772: p_message_text => x_message_list(i).message_text
6773: ,p_application_id => G_APPL_NAME

Line 6785: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', 'Unexpected error');

6781: RAISE e_skip_record;
6782: ELSIF x_return_status = G_RET_STS_UNEXP_ERROR THEN
6783:
6784: Error_Handler.GET_MESSAGE_LIST(x_message_list=>x_message_list);
6785: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', 'Unexpected error');
6786: FOR i IN 1..l_message_count LOOP
6787: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', x_message_list(i).message_text);
6788:
6789: ERROR_HANDLER.Add_Error_Message(

Line 6787: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', x_message_list(i).message_text);

6783:
6784: Error_Handler.GET_MESSAGE_LIST(x_message_list=>x_message_list);
6785: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', 'Unexpected error');
6786: FOR i IN 1..l_message_count LOOP
6787: write_debug('EGO_ITEM_CATALOG_PUB.Process_Catalog_Groups', x_message_list(i).message_text);
6788:
6789: ERROR_HANDLER.Add_Error_Message(
6790: p_message_text => x_message_list(i).message_text
6791: ,p_application_id => G_APPL_NAME