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.CTO_UPDATE_CONFIGS_PK dependencies on CTO_UPDATE_CONFIGS_PK

Line 1: package body CTO_UPDATE_CONFIGS_PK as

1: package body CTO_UPDATE_CONFIGS_PK as
2: /* $Header: CTOUCFGB.pls 120.19.12020000.3 2012/07/26 11:34:59 abhissri ship $*/
3: /*----------------------------------------------------------------------------+
4: | Copyright (c) 1993 Oracle Corporation Belmont, California, USA
5: | All rights reserved.

Line 74: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CTO_UPDATE_CONFIGS_PK';

70: | nvl(to_char(msi.option_specific_sourced),'N')
71: |
72: +-----------------------------------------------------------------------------*/
73:
74: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CTO_UPDATE_CONFIGS_PK';
75: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);
76:
77: --forward declaration
78: PROCEDURE Check_invalid_configurations(

Line 870: WriteToLog('ERROR: Exp error in CTO_Update_Configs_Pk.Update_Configs:: '|| l_stmt_num ||'::'||sqlerrm);

866:
867: EXCEPTION
868:
869: WHEN FND_API.G_EXC_ERROR THEN
870: WriteToLog('ERROR: Exp error in CTO_Update_Configs_Pk.Update_Configs:: '|| l_stmt_num ||'::'||sqlerrm);
871: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
872: WriteToLog('Update Existing Configurations completed with ERROR.', 1);
873: WriteToLog('Please contact the system administrator.', 1);
874: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 879: WriteToLog('ERROR: Unexp error in CTO_Update_Configs_Pk.Update_Configs:: '|| l_stmt_num ||'::'||sqlerrm, 1);

875: errbuf := 'Program completed with error';
876: retcode := 2; --exits with error
877:
878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
879: WriteToLog('ERROR: Unexp error in CTO_Update_Configs_Pk.Update_Configs:: '|| l_stmt_num ||'::'||sqlerrm, 1);
880: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
881: WriteToLog('Update Existing Configurations completed with ERROR');
882: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
883: errbuf := 'Program completed with error';

Line 887: WriteToLog('ERROR: Others error in CTO_Update_Configs_Pk.Update_Configs:: '|| l_stmt_num ||'::'||sqlerrm, 1);

883: errbuf := 'Program completed with error';
884: retcode := 2; --exits with error
885:
886: WHEN OTHERS THEN
887: WriteToLog('ERROR: Others error in CTO_Update_Configs_Pk.Update_Configs:: '|| l_stmt_num ||'::'||sqlerrm, 1);
888: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
889: WriteToLog('Update Existing Configurations completed with ERROR.', 1);
890: WriteToLog('Please contact the system administrator.', 1);
891: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 3118: cto_update_configs_pk.bac_program_id, -- program_id

3114: sysdate, -- creation_date
3115: nvl(Fnd_Global.USER_ID, -1), -- created_by
3116: sysdate, -- last_update_date
3117: nvl(Fnd_Global.USER_ID, -1), -- last_updated_by
3118: cto_update_configs_pk.bac_program_id, -- program_id
3119: 'Y', -- perform_match /* Sushant made changes to identify matched items */
3120: 'N', -- reuse_config
3121: bac.organization_id
3122: from bom_ato_configurations bac,

Line 3564: cto_update_configs_pk.bac_program_id, -- program_id

3560: sysdate, -- creation_date
3561: nvl(Fnd_Global.USER_ID, -1), -- created_by
3562: sysdate, -- last_update_date
3563: nvl(Fnd_Global.USER_ID, -1), -- last_updated_by
3564: cto_update_configs_pk.bac_program_id, -- program_id
3565: bac.organization_id --Bugfix 10240482
3566: from bom_ato_configurations bac,
3567: mtl_system_items msi
3568: where bac.config_item_id = l_curr_config_id

Line 4270: WriteToLog('ERROR: Unexp error in CTO_Update_Configs_Pk.Check_invalid_configurations:: '|| l_stmt_num ||'::'||sqlerrm, 1);

4266:
4267: EXCEPTION
4268:
4269: WHEN OTHERS THEN
4270: WriteToLog('ERROR: Unexp error in CTO_Update_Configs_Pk.Check_invalid_configurations:: '|| l_stmt_num ||'::'||sqlerrm, 1);
4271: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
4272: WriteToLog('Update Existing Configurations completed with ERROR');
4273: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
4274: WriteToLog(' error in Check_invalid_configurations::'||sqlerrm, 1);

Line 4350: END CTO_UPDATE_CONFIGS_PK;

4346: --end bugfix 3377963
4347:
4348:
4349:
4350: END CTO_UPDATE_CONFIGS_PK;