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

Line 663: l_token_table ERROR_HANDLER.Token_Tbl_Type;

659: ) RETURN EGO_USER_ATTR_ROW_TABLE IS
660:
661: l_object_id NUMBER;
662: l_is_required VARCHAR2(1);
663: l_token_table ERROR_HANDLER.Token_Tbl_Type;
664: l_attr_grp_id NUMBER;
665: l_rev_id VARCHAR2(150);
666: l_delete_sql VARCHAR2(200);
667: l_attr_data_table_index NUMBER;

Line 767: ERROR_HANDLER.Add_Error_Message(

763:
764: l_token_table(5).TOKEN_NAME := 'CATALOG_CATEGORY_NAME';
765: l_token_table(5).TOKEN_VALUE := l_current_category_name;
766:
767: ERROR_HANDLER.Add_Error_Message(
768: p_message_name => 'EGO_EF_BL_ITM_NOT_ALLOW_ERR'
769: ,p_application_id => 'EGO'
770: ,p_token_tbl => l_token_table
771: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2444: l_token_table ERROR_HANDLER.Token_Tbl_Type;

2440: RETURN VARCHAR2
2441: IS
2442:
2443: l_parent_cat_group_list VARCHAR2(150) := '';
2444: l_token_table ERROR_HANDLER.Token_Tbl_Type;
2445: l_dummy_transaction_id NUMBER;
2446:
2447: -------------------------------------------------------------------------
2448: -- For finding all parent catalog groups for the current catalog group --

Line 2494: ERROR_HANDLER.Add_Error_Message(

2490: INTO l_token_table(1).TOKEN_VALUE
2491: FROM MTL_ITEM_CATALOG_GROUPS_KFV
2492: WHERE ITEM_CATALOG_GROUP_ID = p_catalog_group_id;
2493:
2494: ERROR_HANDLER.Add_Error_Message(
2495: p_message_name => 'EGO_TOO_MANY_CAT_GROUPS'
2496: ,p_application_id => 'EGO'
2497: ,p_token_tbl => l_token_table
2498: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2562: l_token_table ERROR_HANDLER.Token_Tbl_Type;

2558: l_return_status VARCHAR2(1);
2559: l_user_privileges_table EGO_DATA_SECURITY.EGO_PRIVILEGE_NAME_TABLE_TYPE;
2560: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
2561: l_privilege_table_index NUMBER;
2562: l_token_table ERROR_HANDLER.Token_Tbl_Type;
2563: l_api_name CONSTANT VARCHAR2(30) := 'Get_User_Attrs_Privs';
2564: BEGIN
2565:
2566: --------------------------------------------------------------------------

Line 2589: ERROR_HANDLER.Add_Error_Message(

2585: WHERE USER_NAME = FND_GLOBAL.USER_NAME;
2586: EXCEPTION
2587: WHEN NO_DATA_FOUND THEN
2588:
2589: ERROR_HANDLER.Add_Error_Message(
2590: p_message_name => 'EGO_EF_NO_NAME_TO_VALIDATE'
2591: ,p_application_id => 'EGO'
2592: ,p_message_type => FND_API.G_RET_STS_ERROR
2593: ,p_entity_id => p_entity_id

Line 2690: ERROR_HANDLER.Add_Error_Message(

2686: l_token_table(2).TOKEN_VALUE := l_item_number;
2687: l_token_table(3).TOKEN_NAME := 'ORG_CODE';
2688: l_token_table(3).TOKEN_VALUE := l_org_code;
2689:
2690: ERROR_HANDLER.Add_Error_Message(
2691: p_message_name => l_error_message_name
2692: ,p_application_id => 'EGO'
2693: ,p_token_tbl => l_token_table
2694: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2727: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

2723: ,p_entity_id IN NUMBER DEFAULT NULL
2724: ,p_entity_index IN NUMBER DEFAULT NULL
2725: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2726: ,p_debug_level IN NUMBER DEFAULT 0
2727: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2728: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2729: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2730: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2731: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 2749: l_token_table ERROR_HANDLER.Token_Tbl_Type;

2745: l_class_code_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
2746: l_item_catalog_group_id NUMBER;
2747: l_related_class_codes_list VARCHAR2(150);
2748: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
2749: l_token_table ERROR_HANDLER.Token_Tbl_Type;
2750: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
2751: l_return_status VARCHAR2(2);
2752:
2753: BEGIN

Line 2791: ERROR_HANDLER.Add_Error_Message(

2787: l_token_table(1).TOKEN_NAME := 'ITEM_ID';
2788: l_token_table(1).TOKEN_VALUE := p_inventory_item_id;
2789:
2790: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
2791: ERROR_HANDLER.Add_Error_Message(
2792: p_message_name => 'EGO_EF_BL_INV_ITEM_ID_ERR'
2793: ,p_application_id => 'EGO'
2794: ,p_token_tbl => l_token_table
2795: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2802: ERROR_HANDLER.Add_Error_Message(

2798: ,p_entity_code => p_entity_code
2799: ,p_addto_fnd_stack => 'Y'
2800: );
2801: ELSE
2802: ERROR_HANDLER.Add_Error_Message(
2803: p_message_name => 'EGO_EF_BL_INV_ITEM_ID_ERR'
2804: ,p_application_id => 'EGO'
2805: ,p_token_tbl => l_token_table
2806: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2863: ERROR_HANDLER.Log_Error(

2859: l_attributes_row_table:=p_attributes_row_table;
2860: END IF;
2861: --writing the errors to the log
2862: IF (l_return_status=FND_API.G_RET_STS_ERROR) THEN
2863: ERROR_HANDLER.Log_Error(
2864: p_write_err_to_inttable => 'Y'
2865: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2866: );
2867: END IF;

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

2861: --writing the errors to the log
2862: IF (l_return_status=FND_API.G_RET_STS_ERROR) THEN
2863: ERROR_HANDLER.Log_Error(
2864: p_write_err_to_inttable => 'Y'
2865: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2866: );
2867: END IF;
2868:
2869: ---------------------------------------------------------------

Line 2889: ,p_init_error_handler => p_init_error_handler

2885: ,p_entity_index => p_entity_index
2886: ,p_entity_code => p_entity_code
2887: ,p_debug_level => p_debug_level
2888: ,p_validate_hierarchy => p_validate_hierarchy
2889: ,p_init_error_handler => p_init_error_handler
2890: ,p_write_to_concurrent_log => p_write_to_concurrent_log
2891: ,p_init_fnd_msg_list => p_init_fnd_msg_list
2892: ,p_log_errors => p_log_errors
2893: ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack

Line 2907: x_msg_count := ERROR_HANDLER.Get_Message_Count();

2903: WHEN FND_API.G_EXC_ERROR THEN
2904:
2905: x_return_status := FND_API.G_RET_STS_ERROR;
2906:
2907: x_msg_count := ERROR_HANDLER.Get_Message_Count();
2908:
2909: IF (x_msg_count > 0) THEN
2910: IF (FND_API.To_Boolean(p_log_errors)) THEN
2911: IF (FND_API.To_Boolean(p_write_to_concurrent_log)) THEN

Line 2912: ERROR_HANDLER.Log_Error(

2908:
2909: IF (x_msg_count > 0) THEN
2910: IF (FND_API.To_Boolean(p_log_errors)) THEN
2911: IF (FND_API.To_Boolean(p_write_to_concurrent_log)) THEN
2912: ERROR_HANDLER.Log_Error(
2913: p_write_err_to_inttable => 'Y'
2914: ,p_write_err_to_conclog => 'Y'
2915: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2916: );

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

2911: IF (FND_API.To_Boolean(p_write_to_concurrent_log)) THEN
2912: ERROR_HANDLER.Log_Error(
2913: p_write_err_to_inttable => 'Y'
2914: ,p_write_err_to_conclog => 'Y'
2915: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2916: );
2917: ELSE
2918: ERROR_HANDLER.Log_Error(
2919: p_write_err_to_inttable => 'Y'

Line 2918: ERROR_HANDLER.Log_Error(

2914: ,p_write_err_to_conclog => 'Y'
2915: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2916: );
2917: ELSE
2918: ERROR_HANDLER.Log_Error(
2919: p_write_err_to_inttable => 'Y'
2920: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2921: );
2922: END IF;

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

2916: );
2917: ELSE
2918: ERROR_HANDLER.Log_Error(
2919: p_write_err_to_inttable => 'Y'
2920: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2921: );
2922: END IF;
2923: END IF;
2924:

Line 2927: message_list ERROR_HANDLER.Error_Tbl_Type;

2923: END IF;
2924:
2925: IF (x_msg_count = 1) THEN
2926: DECLARE
2927: message_list ERROR_HANDLER.Error_Tbl_Type;
2928: BEGIN
2929: ERROR_HANDLER.Get_Message_List(message_list);
2930: x_msg_data := message_list(message_list.FIRST).message_text;
2931: END;

Line 2929: ERROR_HANDLER.Get_Message_List(message_list);

2925: IF (x_msg_count = 1) THEN
2926: DECLARE
2927: message_list ERROR_HANDLER.Error_Tbl_Type;
2928: BEGIN
2929: ERROR_HANDLER.Get_Message_List(message_list);
2930: x_msg_data := message_list(message_list.FIRST).message_text;
2931: END;
2932: ELSE
2933: x_msg_data := NULL;

Line 2954: ERROR_HANDLER.Add_Error_Message(

2950: l_token_table(3).TOKEN_NAME := 'SQL_ERR_MSG';
2951: l_token_table(3).TOKEN_VALUE := SQLERRM;
2952:
2953: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
2954: ERROR_HANDLER.Add_Error_Message(
2955: p_message_name => 'EGO_PLSQL_ERR'
2956: ,p_application_id => 'EGO'
2957: ,p_token_tbl => l_token_table
2958: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2962: ERROR_HANDLER.Add_Error_Message(

2958: ,p_message_type => FND_API.G_RET_STS_ERROR
2959: ,p_addto_fnd_stack => 'Y'
2960: );
2961: ELSE
2962: ERROR_HANDLER.Add_Error_Message(
2963: p_message_name => 'EGO_PLSQL_ERR'
2964: ,p_application_id => 'EGO'
2965: ,p_token_tbl => l_token_table
2966: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2970: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data

2966: ,p_message_type => FND_API.G_RET_STS_ERROR
2967: );
2968: END IF;
2969:
2970: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data
2971: ,x_entity_index => l_dummy_entity_index
2972: ,x_entity_id => l_dummy_entity_id
2973: ,x_message_type => l_dummy_message_type);
2974:

Line 2995: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

2991: ,p_entity_id IN NUMBER DEFAULT NULL
2992: ,p_entity_index IN NUMBER DEFAULT NULL
2993: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2994: ,p_debug_level IN NUMBER DEFAULT 0
2995: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2996: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2997: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2998: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2999: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

Line 3049: ,p_init_error_handler => p_init_error_handler

3045: ,p_entity_id => p_entity_id
3046: ,p_entity_index => p_entity_index
3047: ,p_entity_code => p_entity_code
3048: ,p_debug_level => p_debug_level
3049: ,p_init_error_handler => p_init_error_handler
3050: ,p_init_fnd_msg_list => p_init_fnd_msg_list
3051: ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
3052: ,p_commit => p_commit
3053: ,x_attributes_row_table => x_attributes_row_table

Line 3067: x_msg_count := ERROR_HANDLER.Get_Message_Count();

3063: WHEN FND_API.G_EXC_ERROR THEN
3064:
3065: x_return_status := FND_API.G_RET_STS_ERROR;
3066:
3067: x_msg_count := ERROR_HANDLER.Get_Message_Count();
3068:
3069: IF (x_msg_count > 0) THEN
3070: ERROR_HANDLER.Log_Error(
3071: p_write_err_to_inttable => 'Y'

Line 3070: ERROR_HANDLER.Log_Error(

3066:
3067: x_msg_count := ERROR_HANDLER.Get_Message_Count();
3068:
3069: IF (x_msg_count > 0) THEN
3070: ERROR_HANDLER.Log_Error(
3071: p_write_err_to_inttable => 'Y'
3072: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3073: );
3074:

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

3068:
3069: IF (x_msg_count > 0) THEN
3070: ERROR_HANDLER.Log_Error(
3071: p_write_err_to_inttable => 'Y'
3072: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3073: );
3074:
3075: IF (x_msg_count = 1) THEN
3076: DECLARE

Line 3077: message_list ERROR_HANDLER.Error_Tbl_Type;

3073: );
3074:
3075: IF (x_msg_count = 1) THEN
3076: DECLARE
3077: message_list ERROR_HANDLER.Error_Tbl_Type;
3078: BEGIN
3079: ERROR_HANDLER.Get_Message_List(message_list);
3080: x_msg_data := message_list(message_list.FIRST).message_text;
3081: END;

Line 3079: ERROR_HANDLER.Get_Message_List(message_list);

3075: IF (x_msg_count = 1) THEN
3076: DECLARE
3077: message_list ERROR_HANDLER.Error_Tbl_Type;
3078: BEGIN
3079: ERROR_HANDLER.Get_Message_List(message_list);
3080: x_msg_data := message_list(message_list.FIRST).message_text;
3081: END;
3082: ELSE
3083: x_msg_data := NULL;

Line 3092: l_token_table ERROR_HANDLER.Token_Tbl_Type;

3088:
3089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3090:
3091: DECLARE
3092: l_token_table ERROR_HANDLER.Token_Tbl_Type;
3093: l_dummy_entity_index NUMBER;
3094: l_dummy_entity_id VARCHAR2(60);
3095: l_dummy_message_type VARCHAR2(1);
3096: BEGIN

Line 3105: ERROR_HANDLER.Add_Error_Message(

3101: l_token_table(3).TOKEN_NAME := 'SQL_ERR_MSG';
3102: l_token_table(3).TOKEN_VALUE := SQLERRM;
3103:
3104: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
3105: ERROR_HANDLER.Add_Error_Message(
3106: p_message_name => 'EGO_PLSQL_ERR'
3107: ,p_application_id => 'EGO'
3108: ,p_token_tbl => l_token_table
3109: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 3113: ERROR_HANDLER.Add_Error_Message(

3109: ,p_message_type => FND_API.G_RET_STS_ERROR
3110: ,p_addto_fnd_stack => 'Y'
3111: );
3112: ELSE
3113: ERROR_HANDLER.Add_Error_Message(
3114: p_message_name => 'EGO_PLSQL_ERR'
3115: ,p_application_id => 'EGO'
3116: ,p_token_tbl => l_token_table
3117: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 3121: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data

3117: ,p_message_type => FND_API.G_RET_STS_ERROR
3118: );
3119: END IF;
3120:
3121: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data
3122: ,x_entity_index => l_dummy_entity_index
3123: ,x_entity_id => l_dummy_entity_id
3124: ,x_message_type => l_dummy_message_type);
3125:

Line 3441: l_error_token_table ERROR_HANDLER.Token_Tbl_Type;

3437: ,x_msg_data OUT NOCOPY VARCHAR2
3438: ) IS
3439: l_api_name VARCHAR2(30);
3440: l_api_version NUMBER;
3441: l_error_token_table ERROR_HANDLER.Token_Tbl_Type;
3442: l_dummy_number NUMBER;
3443: l_dummy_char VARCHAR2(32767);
3444: l_sysdate DATE;
3445: l_start_date DATE;

Line 5336: l_token_table ERROR_HANDLER.Token_Tbl_Type;

5332: l_class_code_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
5333: l_attr_group_type_table EGO_VARCHAR_TBL_TYPE;
5334: l_item_catalog_group_id NUMBER;
5335: l_related_class_codes_list VARCHAR2(150);
5336: l_token_table ERROR_HANDLER.Token_Tbl_Type;
5337:
5338: CURSOR get_catalog_group_id IS
5339: SELECT ITEM_CATALOG_GROUP_ID
5340: INTO l_item_catalog_group_id

Line 5410: x_msg_count := ERROR_HANDLER.Get_Message_Count();

5406: WHEN FND_API.G_EXC_ERROR THEN
5407:
5408: x_return_status := FND_API.G_RET_STS_ERROR;
5409:
5410: x_msg_count := ERROR_HANDLER.Get_Message_Count();
5411:
5412: IF (x_msg_count > 0) THEN
5413: ERROR_HANDLER.Log_Error(
5414: p_write_err_to_inttable => 'Y'

Line 5413: ERROR_HANDLER.Log_Error(

5409:
5410: x_msg_count := ERROR_HANDLER.Get_Message_Count();
5411:
5412: IF (x_msg_count > 0) THEN
5413: ERROR_HANDLER.Log_Error(
5414: p_write_err_to_inttable => 'Y'
5415: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
5416: );
5417:

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

5411:
5412: IF (x_msg_count > 0) THEN
5413: ERROR_HANDLER.Log_Error(
5414: p_write_err_to_inttable => 'Y'
5415: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
5416: );
5417:
5418: IF (x_msg_count = 1) THEN
5419: DECLARE

Line 5420: message_list ERROR_HANDLER.Error_Tbl_Type;

5416: );
5417:
5418: IF (x_msg_count = 1) THEN
5419: DECLARE
5420: message_list ERROR_HANDLER.Error_Tbl_Type;
5421: BEGIN
5422: ERROR_HANDLER.Get_Message_List(message_list);
5423: x_msg_data := message_list(message_list.FIRST).message_text;
5424: END;

Line 5422: ERROR_HANDLER.Get_Message_List(message_list);

5418: IF (x_msg_count = 1) THEN
5419: DECLARE
5420: message_list ERROR_HANDLER.Error_Tbl_Type;
5421: BEGIN
5422: ERROR_HANDLER.Get_Message_List(message_list);
5423: x_msg_data := message_list(message_list.FIRST).message_text;
5424: END;
5425: ELSE
5426: x_msg_data := NULL;

Line 5435: l_token_table ERROR_HANDLER.Token_Tbl_Type;

5431:
5432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5433:
5434: DECLARE
5435: l_token_table ERROR_HANDLER.Token_Tbl_Type;
5436: l_dummy_entity_index NUMBER;
5437: l_dummy_entity_id VARCHAR2(60);
5438: l_dummy_message_type VARCHAR2(1);
5439: BEGIN

Line 5447: ERROR_HANDLER.Add_Error_Message(

5443: l_token_table(2).TOKEN_VALUE := l_api_name;
5444: l_token_table(3).TOKEN_NAME := 'SQL_ERR_MSG';
5445: l_token_table(3).TOKEN_VALUE := SQLERRM;
5446:
5447: ERROR_HANDLER.Add_Error_Message(
5448: p_message_name => 'EGO_PLSQL_ERR'
5449: ,p_application_id => 'EGO'
5450: ,p_token_tbl => l_token_table
5451: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 5454: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data

5450: ,p_token_tbl => l_token_table
5451: ,p_message_type => FND_API.G_RET_STS_ERROR
5452: );
5453:
5454: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data
5455: ,x_entity_index => l_dummy_entity_index
5456: ,x_entity_id => l_dummy_entity_id
5457: ,x_message_type => l_dummy_message_type);
5458:

Line 6220: ,p_init_error_handler => 'T'

6216: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs
6217: ,p_class_code_name_value_pairs => l_class_code_name_value_pairs
6218: ,p_data_level_values => l_data_level_values
6219: ,p_additional_class_Code_list => l_additional_class_Code_list
6220: ,p_init_error_handler => 'T'
6221: ,p_init_fnd_msg_list => 'T'
6222: ,p_log_errors => 'T'
6223: ,p_add_errors_to_fnd_stack => 'T'
6224: ,P_commit => l_commit