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

Line 22: /* The following two variables are for Error_Handler */

18: G_API_VERSION NUMBER := 1.0;
19: G_ITEM_NAME CONSTANT VARCHAR2(10) := 'EGO_ITEM';
20: G_ITEM_OBJECT_ID NUMBER;
21:
22: /*** The following two variables are for Error_Handler ***/
23: G_ENTITY_ID NUMBER;
24: G_ENTITY_CODE CONSTANT VARCHAR2(30) := 'ITEM_USER_ATTRS_ENTITY_CODE';
25:
26: G_REQUEST_ID NUMBER;

Line 261: l_token_table ERROR_HANDLER.Token_Tbl_Type;

257: RETURN VARCHAR2
258: IS
259:
260: l_parent_cat_group_list VARCHAR2(1000) := '';
261: l_token_table ERROR_HANDLER.Token_Tbl_Type;
262: -------------------------------------------------------------------------
263: -- For finding all parent catalog groups for the current catalog group --
264: -------------------------------------------------------------------------
265: CURSOR parent_catalog_group_cursor IS

Line 301: ERROR_HANDLER.Add_Error_Message(

297: SELECT CONCATENATED_SEGMENTS
298: INTO l_token_table(1).TOKEN_VALUE
299: FROM MTL_ITEM_CATALOG_GROUPS_KFV
300: WHERE ITEM_CATALOG_GROUP_ID = p_catalog_group_id;
301: ERROR_HANDLER.Add_Error_Message(
302: p_message_name => 'EGO_TOO_MANY_CAT_GROUPS'
303: ,p_application_id => 'EGO'
304: ,p_token_tbl => l_token_table
305: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 409: ,p_initialize_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

405: ,RETCODE OUT NOCOPY VARCHAR2
406: ,p_data_set_id IN NUMBER
407: ,p_debug_level IN NUMBER DEFAULT 0
408: ,p_purge_successful_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE
409: ,p_initialize_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
410: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
411: ,p_ignore_security_for_validate IN VARCHAR2 DEFAULT FND_API.G_FALSE
412: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE /* Added to fix Bug#7422423*/
413: ,p_is_id_validations_reqd IN VARCHAR2 DEFAULT FND_API.G_TRUE /* Fix for bug#9660659 */

Line 431: l_token_table ERROR_HANDLER.Token_Tbl_Type;

427: l_prev_loop_inv_item_id NUMBER;
428: l_prev_loop_row_identifier NUMBER;
429: l_at_start_of_instance BOOLEAN;
430: l_can_edit_this_instance VARCHAR2(1);
431: l_token_table ERROR_HANDLER.Token_Tbl_Type;
432: l_could_edit_prev_instance VARCHAR2(1);
433: l_at_start_of_row BOOLEAN;
434: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
435: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

Line 735: ' - p_initialize_error_handler: '|| p_initialize_error_handler ||

731: ,p_module => l_api_name
732: ,p_message => 'Started with 7 params '||
733: ' p_data_set_id: '|| p_data_set_id ||
734: ' - p_purge_successful_lines: '|| p_purge_successful_lines ||
735: ' - p_initialize_error_handler: '|| p_initialize_error_handler ||
736: ' - p_validate_only: ' || p_validate_only
737: );
738: -- write_records(p_data_set_id => p_data_set_id, p_module => l_api_name, p_message=> 'As given');
739: --If there are no rows to process for this data_set_id, return success.

Line 773: -- ERROR_HANDLER SET-UP --

769: END IF;
770: END IF;
771:
772: --======================--
773: -- ERROR_HANDLER SET-UP --
774: --======================--
775:
776: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
777:

Line 776: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN

772: --======================--
773: -- ERROR_HANDLER SET-UP --
774: --======================--
775:
776: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
777:
778: ERROR_HANDLER.Initialize();
779: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
780:

Line 778: ERROR_HANDLER.Initialize();

774: --======================--
775:
776: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
777:
778: ERROR_HANDLER.Initialize();
779: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
780:
781: ---------------------------------------------------
782: -- If we're debugging, we have to set up a Debug --

Line 779: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);

775:
776: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
777:
778: ERROR_HANDLER.Initialize();
779: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
780:
781: ---------------------------------------------------
782: -- If we're debugging, we have to set up a Debug --
783: -- session (unless our caller already did so) --

Line 786: IF (p_debug_level > 0 AND ERROR_HANDLER.Get_Debug() = 'N') THEN

782: -- If we're debugging, we have to set up a Debug --
783: -- session (unless our caller already did so) --
784: ---------------------------------------------------
785:
786: IF (p_debug_level > 0 AND ERROR_HANDLER.Get_Debug() = 'N') THEN
787: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE, p_debug_level);
788: END IF;
789: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Item/Item Revision Concurrent Program for data set ID: '||p_data_set_id, 0);
790: END IF;

Line 2502: ERROR_HANDLER.Add_Error_Message(

2498: l_token_table(1).TOKEN_NAME := 'ATTR_GROUP_NAME';
2499: l_token_table(1).TOKEN_VALUE := l_error_attr_group_name;
2500: l_error_message_name := l_error_message;
2501: l_item_return_status := FND_API.G_RET_STS_ERROR;
2502: ERROR_HANDLER.Add_Error_Message(
2503: p_message_name => l_error_message_name
2504: ,p_application_id => 'EGO'
2505: ,p_token_tbl => l_token_table
2506: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2819: ERROR_HANDLER.Add_Error_Message(

2815: END IF;
2816: END IF;
2817:
2818: l_item_return_status := FND_API.G_RET_STS_ERROR;
2819: ERROR_HANDLER.Add_Error_Message(
2820: p_message_name => l_error_message_name
2821: ,p_application_id => 'EGO'
2822: ,p_token_tbl => l_token_table
2823: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 3040: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2

3036: ,p_entity_id => G_ENTITY_ID --IN NUMBER
3037: ,p_entity_index => l_entity_index_counter --IN NUMBER
3038: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3039: ,p_debug_level => p_debug_level --IN NUMBER
3040: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3041: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3042: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3043: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3044: ,p_commit => p_commit -- FND_API.G_TRUE --IN VARCHAR2/* Added to fix Bug#7422423*/

Line 3151: ERROR_HANDLER.Add_Error_Message(

3147:
3148: l_error_message_name := 'EGO_BAD_VAR_VALUE';
3149: END IF;
3150:
3151: ERROR_HANDLER.Add_Error_Message(
3152: p_message_name => l_error_message_name
3153: ,p_application_id => 'EGO'
3154: ,p_token_tbl => l_token_table
3155: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 3207: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2

3203: ,p_entity_id => G_ENTITY_ID --IN NUMBER
3204: ,p_entity_index => l_entity_index_counter --IN NUMBER
3205: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3206: ,p_debug_level => p_debug_level --IN NUMBER
3207: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3208: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3209: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3210: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3211: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2

Line 3263: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2

3259: ,p_entity_id => G_ENTITY_ID --IN NUMBER
3260: ,p_entity_index => l_entity_index_counter --IN NUMBER
3261: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3262: ,p_debug_level => p_debug_level --IN NUMBER
3263: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3264: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3265: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3266: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3267: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2

Line 3316: ERROR_HANDLER.Add_Error_Message(

3312:
3313: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3314: ERRBUF := l_msg_data;
3315: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3316: ERROR_HANDLER.Add_Error_Message(
3317: p_message_text => l_msg_data
3318: ,p_application_id => 'EGO'
3319: ,p_message_type => FND_API.G_RET_STS_ERROR
3320: ,p_row_identifier => l_err_reporting_transaction_id

Line 3352: ERROR_HANDLER.Add_Error_Message(

3348:
3349: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3350: ERRBUF := l_msg_data;
3351: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3352: ERROR_HANDLER.Add_Error_Message(
3353: p_message_text => l_msg_data
3354: ,p_application_id => 'EGO'
3355: ,p_message_type => FND_API.G_RET_STS_ERROR
3356: ,p_row_identifier => l_err_reporting_transaction_id

Line 3385: ERROR_HANDLER.Add_Error_Message(

3381:
3382: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3383: ERRBUF := l_msg_data;
3384: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
3385: ERROR_HANDLER.Add_Error_Message(
3386: p_message_text => l_msg_data
3387: ,p_application_id => 'EGO'
3388: ,p_message_type => FND_API.G_RET_STS_ERROR
3389: ,p_row_identifier => l_err_reporting_transaction_id

Line 3537: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2

3533: ,p_entity_id => G_ENTITY_ID --IN NUMBER
3534: ,p_entity_index => l_entity_index_counter --IN NUMBER
3535: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3536: ,p_debug_level => p_debug_level --IN NUMBER
3537: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3538: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3539: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3540: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3541: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2

Line 3576: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2

3572: ,p_entity_id => G_ENTITY_ID --IN NUMBER
3573: ,p_entity_index => l_entity_index_counter --IN NUMBER
3574: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3575: ,p_debug_level => p_debug_level --IN NUMBER
3576: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3577: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3578: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3579: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3580: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2

Line 3616: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2

3612: ,p_entity_id => G_ENTITY_ID --IN NUMBER
3613: ,p_entity_index => l_entity_index_counter --IN NUMBER
3614: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
3615: ,p_debug_level => p_debug_level --IN NUMBER
3616: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
3617: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
3618: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
3619: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
3620: ,p_commit => p_commit -- bug 10060587 FND_API.G_TRUE --IN VARCHAR2

Line 3686: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN

3682: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Done with Item/Item Revision Concurrent Program', 0);
3683: END IF;
3684: END IF; -- IF p_validate_only = FND_API.G...
3685:
3686: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
3687:
3688: -------------------------------------------------------------------
3689: -- Finally, we log any errors that we've accumulated throughout --
3690: -- our conversions and looping (including all errors encountered --

Line 3693: ERROR_HANDLER.Log_Error(

3689: -- Finally, we log any errors that we've accumulated throughout --
3690: -- our conversions and looping (including all errors encountered --
3691: -- within our Business Object's processing) --
3692: -------------------------------------------------------------------
3693: ERROR_HANDLER.Log_Error(
3694: p_write_err_to_inttable => 'Y'
3695: ,p_write_err_to_conclog => 'Y'
3696: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3697: );

Line 3696: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()

3692: -------------------------------------------------------------------
3693: ERROR_HANDLER.Log_Error(
3694: p_write_err_to_inttable => 'Y'
3695: ,p_write_err_to_conclog => 'Y'
3696: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3697: );
3698:
3699: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
3700: ERROR_HANDLER.Close_Debug_Session();

Line 3699: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN

3695: ,p_write_err_to_conclog => 'Y'
3696: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3697: );
3698:
3699: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
3700: ERROR_HANDLER.Close_Debug_Session();
3701: END IF;
3702: END IF;
3703: IF FND_API.To_Boolean( p_commit ) THEN /* Added to fix Bug#7422423*/

Line 3700: ERROR_HANDLER.Close_Debug_Session();

3696: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3697: );
3698:
3699: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
3700: ERROR_HANDLER.Close_Debug_Session();
3701: END IF;
3702: END IF;
3703: IF FND_API.To_Boolean( p_commit ) THEN /* Added to fix Bug#7422423*/
3704: COMMIT WORK;

Line 3731: ERROR_HANDLER.Add_Error_Message(

3727: ELSE
3728: l_err_reporting_transaction_id := -1;
3729: END IF;
3730:
3731: ERROR_HANDLER.Add_Error_Message(
3732: p_message_name => 'EGO_EF_NO_NAME_TO_VALIDATE'
3733: ,p_application_id => 'EGO'
3734: ,p_message_type => FND_API.G_RET_STS_ERROR
3735: ,p_row_identifier => l_err_reporting_transaction_id

Line 3741: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN

3737: ,p_entity_code => G_ENTITY_CODE
3738: ,p_table_name => G_TABLE_NAME
3739: );
3740:
3741: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
3742:
3743: ---------------------------------------------------------------
3744: -- No matter what the error, we want to make sure everything --
3745: -- we've logged gets to the appropriate error locations --

Line 3747: ERROR_HANDLER.Log_Error(

3743: ---------------------------------------------------------------
3744: -- No matter what the error, we want to make sure everything --
3745: -- we've logged gets to the appropriate error locations --
3746: ---------------------------------------------------------------
3747: ERROR_HANDLER.Log_Error(
3748: p_write_err_to_inttable => 'Y'
3749: ,p_write_err_to_conclog => 'Y'
3750: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3751: );

Line 3750: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()

3746: ---------------------------------------------------------------
3747: ERROR_HANDLER.Log_Error(
3748: p_write_err_to_inttable => 'Y'
3749: ,p_write_err_to_conclog => 'Y'
3750: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3751: );
3752:
3753: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
3754: ERROR_HANDLER.Close_Debug_Session();

Line 3753: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN

3749: ,p_write_err_to_conclog => 'Y'
3750: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3751: );
3752:
3753: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
3754: ERROR_HANDLER.Close_Debug_Session();
3755: END IF;
3756: END IF;
3757:

Line 3754: ERROR_HANDLER.Close_Debug_Session();

3750: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3751: );
3752:
3753: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
3754: ERROR_HANDLER.Close_Debug_Session();
3755: END IF;
3756: END IF;
3757:
3758: RETCODE := L_CONC_RET_STS_WARNING;

Line 3784: ERROR_HANDLER.Add_Error_Message(

3780: ELSE
3781: l_err_reporting_transaction_id := -1;
3782: END IF;
3783:
3784: ERROR_HANDLER.Add_Error_Message(
3785: p_message_text => 'Unexpected error in '||G_PKG_NAME||'.Process_Item_User_Attrs_Data: '||SQLERRM
3786: ,p_application_id => 'EGO'
3787: ,p_message_type => FND_API.G_RET_STS_ERROR
3788: ,p_row_identifier => l_err_reporting_transaction_id

Line 3794: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN

3790: ,p_entity_code => G_ENTITY_CODE
3791: ,p_table_name => G_TABLE_NAME
3792: );
3793:
3794: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
3795:
3796: ---------------------------------------------------------------
3797: -- No matter what the error, we want to make sure everything --
3798: -- we've logged gets to the appropriate error locations --

Line 3800: ERROR_HANDLER.Log_Error(

3796: ---------------------------------------------------------------
3797: -- No matter what the error, we want to make sure everything --
3798: -- we've logged gets to the appropriate error locations --
3799: ---------------------------------------------------------------
3800: ERROR_HANDLER.Log_Error(
3801: p_write_err_to_inttable => 'Y'
3802: ,p_write_err_to_conclog => 'Y'
3803: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3804: );

Line 3803: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()

3799: ---------------------------------------------------------------
3800: ERROR_HANDLER.Log_Error(
3801: p_write_err_to_inttable => 'Y'
3802: ,p_write_err_to_conclog => 'Y'
3803: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3804: );
3805:
3806: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
3807: ERROR_HANDLER.Close_Debug_Session();

Line 3806: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN

3802: ,p_write_err_to_conclog => 'Y'
3803: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3804: );
3805:
3806: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
3807: ERROR_HANDLER.Close_Debug_Session();
3808: END IF;
3809: END IF;
3810:

Line 3807: ERROR_HANDLER.Close_Debug_Session();

3803: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3804: );
3805:
3806: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
3807: ERROR_HANDLER.Close_Debug_Session();
3808: END IF;
3809: END IF;
3810:
3811: RETCODE := L_CONC_RET_STS_ERROR;