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 659: l_token_table ERROR_HANDLER.Token_Tbl_Type;

655: ) RETURN EGO_USER_ATTR_ROW_TABLE IS
656:
657: l_object_id NUMBER;
658: l_is_required VARCHAR2(1);
659: l_token_table ERROR_HANDLER.Token_Tbl_Type;
660: l_attr_grp_id NUMBER;
661: l_rev_id VARCHAR2(150);
662: l_delete_sql VARCHAR2(200);
663: l_attr_data_table_index NUMBER;

Line 763: ERROR_HANDLER.Add_Error_Message(

759:
760: l_token_table(5).TOKEN_NAME := 'CATALOG_CATEGORY_NAME';
761: l_token_table(5).TOKEN_VALUE := l_current_category_name;
762:
763: ERROR_HANDLER.Add_Error_Message(
764: p_message_name => 'EGO_EF_BL_ITM_NOT_ALLOW_ERR'
765: ,p_application_id => 'EGO'
766: ,p_token_tbl => l_token_table
767: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2218: l_token_table ERROR_HANDLER.Token_Tbl_Type;

2214: RETURN VARCHAR2
2215: IS
2216:
2217: l_parent_cat_group_list VARCHAR2(150) := '';
2218: l_token_table ERROR_HANDLER.Token_Tbl_Type;
2219: l_dummy_transaction_id NUMBER;
2220:
2221: -------------------------------------------------------------------------
2222: -- For finding all parent catalog groups for the current catalog group --

Line 2268: ERROR_HANDLER.Add_Error_Message(

2264: INTO l_token_table(1).TOKEN_VALUE
2265: FROM MTL_ITEM_CATALOG_GROUPS_KFV
2266: WHERE ITEM_CATALOG_GROUP_ID = p_catalog_group_id;
2267:
2268: ERROR_HANDLER.Add_Error_Message(
2269: p_message_name => 'EGO_TOO_MANY_CAT_GROUPS'
2270: ,p_application_id => 'EGO'
2271: ,p_token_tbl => l_token_table
2272: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2336: l_token_table ERROR_HANDLER.Token_Tbl_Type;

2332: l_return_status VARCHAR2(1);
2333: l_user_privileges_table EGO_DATA_SECURITY.EGO_PRIVILEGE_NAME_TABLE_TYPE;
2334: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
2335: l_privilege_table_index NUMBER;
2336: l_token_table ERROR_HANDLER.Token_Tbl_Type;
2337: l_api_name CONSTANT VARCHAR2(30) := 'Get_User_Attrs_Privs';
2338: BEGIN
2339:
2340: --------------------------------------------------------------------------

Line 2363: ERROR_HANDLER.Add_Error_Message(

2359: WHERE USER_NAME = FND_GLOBAL.USER_NAME;
2360: EXCEPTION
2361: WHEN NO_DATA_FOUND THEN
2362:
2363: ERROR_HANDLER.Add_Error_Message(
2364: p_message_name => 'EGO_EF_NO_NAME_TO_VALIDATE'
2365: ,p_application_id => 'EGO'
2366: ,p_message_type => FND_API.G_RET_STS_ERROR
2367: ,p_entity_id => p_entity_id

Line 2464: ERROR_HANDLER.Add_Error_Message(

2460: l_token_table(2).TOKEN_VALUE := l_item_number;
2461: l_token_table(3).TOKEN_NAME := 'ORG_CODE';
2462: l_token_table(3).TOKEN_VALUE := l_org_code;
2463:
2464: ERROR_HANDLER.Add_Error_Message(
2465: p_message_name => l_error_message_name
2466: ,p_application_id => 'EGO'
2467: ,p_token_tbl => l_token_table
2468: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2501: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

2497: ,p_entity_id IN NUMBER DEFAULT NULL
2498: ,p_entity_index IN NUMBER DEFAULT NULL
2499: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2500: ,p_debug_level IN NUMBER DEFAULT 0
2501: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2502: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2503: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2504: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2505: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 2523: l_token_table ERROR_HANDLER.Token_Tbl_Type;

2519: l_class_code_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
2520: l_item_catalog_group_id NUMBER;
2521: l_related_class_codes_list VARCHAR2(150);
2522: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
2523: l_token_table ERROR_HANDLER.Token_Tbl_Type;
2524: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
2525: l_return_status VARCHAR2(2);
2526:
2527: BEGIN

Line 2565: ERROR_HANDLER.Add_Error_Message(

2561: l_token_table(1).TOKEN_NAME := 'ITEM_ID';
2562: l_token_table(1).TOKEN_VALUE := p_inventory_item_id;
2563:
2564: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
2565: ERROR_HANDLER.Add_Error_Message(
2566: p_message_name => 'EGO_EF_BL_INV_ITEM_ID_ERR'
2567: ,p_application_id => 'EGO'
2568: ,p_token_tbl => l_token_table
2569: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2576: ERROR_HANDLER.Add_Error_Message(

2572: ,p_entity_code => p_entity_code
2573: ,p_addto_fnd_stack => 'Y'
2574: );
2575: ELSE
2576: ERROR_HANDLER.Add_Error_Message(
2577: p_message_name => 'EGO_EF_BL_INV_ITEM_ID_ERR'
2578: ,p_application_id => 'EGO'
2579: ,p_token_tbl => l_token_table
2580: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2637: ERROR_HANDLER.Log_Error(

2633: l_attributes_row_table:=p_attributes_row_table;
2634: END IF;
2635: --writing the errors to the log
2636: IF (l_return_status=FND_API.G_RET_STS_ERROR) THEN
2637: ERROR_HANDLER.Log_Error(
2638: p_write_err_to_inttable => 'Y'
2639: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2640: );
2641: END IF;

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

2635: --writing the errors to the log
2636: IF (l_return_status=FND_API.G_RET_STS_ERROR) THEN
2637: ERROR_HANDLER.Log_Error(
2638: p_write_err_to_inttable => 'Y'
2639: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2640: );
2641: END IF;
2642:
2643: ---------------------------------------------------------------

Line 2663: ,p_init_error_handler => p_init_error_handler

2659: ,p_entity_index => p_entity_index
2660: ,p_entity_code => p_entity_code
2661: ,p_debug_level => p_debug_level
2662: ,p_validate_hierarchy => p_validate_hierarchy
2663: ,p_init_error_handler => p_init_error_handler
2664: ,p_write_to_concurrent_log => p_write_to_concurrent_log
2665: ,p_init_fnd_msg_list => p_init_fnd_msg_list
2666: ,p_log_errors => p_log_errors
2667: ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack

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

2677: WHEN FND_API.G_EXC_ERROR THEN
2678:
2679: x_return_status := FND_API.G_RET_STS_ERROR;
2680:
2681: x_msg_count := ERROR_HANDLER.Get_Message_Count();
2682:
2683: IF (x_msg_count > 0) THEN
2684: IF (FND_API.To_Boolean(p_log_errors)) THEN
2685: IF (FND_API.To_Boolean(p_write_to_concurrent_log)) THEN

Line 2686: ERROR_HANDLER.Log_Error(

2682:
2683: IF (x_msg_count > 0) THEN
2684: IF (FND_API.To_Boolean(p_log_errors)) THEN
2685: IF (FND_API.To_Boolean(p_write_to_concurrent_log)) THEN
2686: ERROR_HANDLER.Log_Error(
2687: p_write_err_to_inttable => 'Y'
2688: ,p_write_err_to_conclog => 'Y'
2689: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2690: );

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

2685: IF (FND_API.To_Boolean(p_write_to_concurrent_log)) THEN
2686: ERROR_HANDLER.Log_Error(
2687: p_write_err_to_inttable => 'Y'
2688: ,p_write_err_to_conclog => 'Y'
2689: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2690: );
2691: ELSE
2692: ERROR_HANDLER.Log_Error(
2693: p_write_err_to_inttable => 'Y'

Line 2692: ERROR_HANDLER.Log_Error(

2688: ,p_write_err_to_conclog => 'Y'
2689: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2690: );
2691: ELSE
2692: ERROR_HANDLER.Log_Error(
2693: p_write_err_to_inttable => 'Y'
2694: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2695: );
2696: END IF;

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

2690: );
2691: ELSE
2692: ERROR_HANDLER.Log_Error(
2693: p_write_err_to_inttable => 'Y'
2694: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2695: );
2696: END IF;
2697: END IF;
2698:

Line 2701: message_list ERROR_HANDLER.Error_Tbl_Type;

2697: END IF;
2698:
2699: IF (x_msg_count = 1) THEN
2700: DECLARE
2701: message_list ERROR_HANDLER.Error_Tbl_Type;
2702: BEGIN
2703: ERROR_HANDLER.Get_Message_List(message_list);
2704: x_msg_data := message_list(message_list.FIRST).message_text;
2705: END;

Line 2703: ERROR_HANDLER.Get_Message_List(message_list);

2699: IF (x_msg_count = 1) THEN
2700: DECLARE
2701: message_list ERROR_HANDLER.Error_Tbl_Type;
2702: BEGIN
2703: ERROR_HANDLER.Get_Message_List(message_list);
2704: x_msg_data := message_list(message_list.FIRST).message_text;
2705: END;
2706: ELSE
2707: x_msg_data := NULL;

Line 2728: ERROR_HANDLER.Add_Error_Message(

2724: l_token_table(3).TOKEN_NAME := 'SQL_ERR_MSG';
2725: l_token_table(3).TOKEN_VALUE := SQLERRM;
2726:
2727: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
2728: ERROR_HANDLER.Add_Error_Message(
2729: p_message_name => 'EGO_PLSQL_ERR'
2730: ,p_application_id => 'EGO'
2731: ,p_token_tbl => l_token_table
2732: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2736: ERROR_HANDLER.Add_Error_Message(

2732: ,p_message_type => FND_API.G_RET_STS_ERROR
2733: ,p_addto_fnd_stack => 'Y'
2734: );
2735: ELSE
2736: ERROR_HANDLER.Add_Error_Message(
2737: p_message_name => 'EGO_PLSQL_ERR'
2738: ,p_application_id => 'EGO'
2739: ,p_token_tbl => l_token_table
2740: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2744: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data

2740: ,p_message_type => FND_API.G_RET_STS_ERROR
2741: );
2742: END IF;
2743:
2744: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data
2745: ,x_entity_index => l_dummy_entity_index
2746: ,x_entity_id => l_dummy_entity_id
2747: ,x_message_type => l_dummy_message_type);
2748:

Line 2769: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

2765: ,p_entity_id IN NUMBER DEFAULT NULL
2766: ,p_entity_index IN NUMBER DEFAULT NULL
2767: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2768: ,p_debug_level IN NUMBER DEFAULT 0
2769: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2770: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2771: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2772: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2773: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

Line 2823: ,p_init_error_handler => p_init_error_handler

2819: ,p_entity_id => p_entity_id
2820: ,p_entity_index => p_entity_index
2821: ,p_entity_code => p_entity_code
2822: ,p_debug_level => p_debug_level
2823: ,p_init_error_handler => p_init_error_handler
2824: ,p_init_fnd_msg_list => p_init_fnd_msg_list
2825: ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
2826: ,p_commit => p_commit
2827: ,x_attributes_row_table => x_attributes_row_table

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

2837: WHEN FND_API.G_EXC_ERROR THEN
2838:
2839: x_return_status := FND_API.G_RET_STS_ERROR;
2840:
2841: x_msg_count := ERROR_HANDLER.Get_Message_Count();
2842:
2843: IF (x_msg_count > 0) THEN
2844: ERROR_HANDLER.Log_Error(
2845: p_write_err_to_inttable => 'Y'

Line 2844: ERROR_HANDLER.Log_Error(

2840:
2841: x_msg_count := ERROR_HANDLER.Get_Message_Count();
2842:
2843: IF (x_msg_count > 0) THEN
2844: ERROR_HANDLER.Log_Error(
2845: p_write_err_to_inttable => 'Y'
2846: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2847: );
2848:

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

2842:
2843: IF (x_msg_count > 0) THEN
2844: ERROR_HANDLER.Log_Error(
2845: p_write_err_to_inttable => 'Y'
2846: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2847: );
2848:
2849: IF (x_msg_count = 1) THEN
2850: DECLARE

Line 2851: message_list ERROR_HANDLER.Error_Tbl_Type;

2847: );
2848:
2849: IF (x_msg_count = 1) THEN
2850: DECLARE
2851: message_list ERROR_HANDLER.Error_Tbl_Type;
2852: BEGIN
2853: ERROR_HANDLER.Get_Message_List(message_list);
2854: x_msg_data := message_list(message_list.FIRST).message_text;
2855: END;

Line 2853: ERROR_HANDLER.Get_Message_List(message_list);

2849: IF (x_msg_count = 1) THEN
2850: DECLARE
2851: message_list ERROR_HANDLER.Error_Tbl_Type;
2852: BEGIN
2853: ERROR_HANDLER.Get_Message_List(message_list);
2854: x_msg_data := message_list(message_list.FIRST).message_text;
2855: END;
2856: ELSE
2857: x_msg_data := NULL;

Line 2866: l_token_table ERROR_HANDLER.Token_Tbl_Type;

2862:
2863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2864:
2865: DECLARE
2866: l_token_table ERROR_HANDLER.Token_Tbl_Type;
2867: l_dummy_entity_index NUMBER;
2868: l_dummy_entity_id VARCHAR2(60);
2869: l_dummy_message_type VARCHAR2(1);
2870: BEGIN

Line 2879: ERROR_HANDLER.Add_Error_Message(

2875: l_token_table(3).TOKEN_NAME := 'SQL_ERR_MSG';
2876: l_token_table(3).TOKEN_VALUE := SQLERRM;
2877:
2878: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
2879: ERROR_HANDLER.Add_Error_Message(
2880: p_message_name => 'EGO_PLSQL_ERR'
2881: ,p_application_id => 'EGO'
2882: ,p_token_tbl => l_token_table
2883: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2887: ERROR_HANDLER.Add_Error_Message(

2883: ,p_message_type => FND_API.G_RET_STS_ERROR
2884: ,p_addto_fnd_stack => 'Y'
2885: );
2886: ELSE
2887: ERROR_HANDLER.Add_Error_Message(
2888: p_message_name => 'EGO_PLSQL_ERR'
2889: ,p_application_id => 'EGO'
2890: ,p_token_tbl => l_token_table
2891: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 2895: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data

2891: ,p_message_type => FND_API.G_RET_STS_ERROR
2892: );
2893: END IF;
2894:
2895: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data
2896: ,x_entity_index => l_dummy_entity_index
2897: ,x_entity_id => l_dummy_entity_id
2898: ,x_message_type => l_dummy_message_type);
2899:

Line 3181: l_error_token_table ERROR_HANDLER.Token_Tbl_Type;

3177: ,x_msg_data OUT NOCOPY VARCHAR2
3178: ) IS
3179: l_api_name VARCHAR2(30);
3180: l_api_version NUMBER;
3181: l_error_token_table ERROR_HANDLER.Token_Tbl_Type;
3182: l_dummy_number NUMBER;
3183: l_dummy_char VARCHAR2(32767);
3184: l_sysdate DATE;
3185: l_start_date DATE;

Line 4840: l_token_table ERROR_HANDLER.Token_Tbl_Type;

4836: l_class_code_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
4837: l_attr_group_type_table EGO_VARCHAR_TBL_TYPE;
4838: l_item_catalog_group_id NUMBER;
4839: l_related_class_codes_list VARCHAR2(150);
4840: l_token_table ERROR_HANDLER.Token_Tbl_Type;
4841:
4842: CURSOR get_catalog_group_id IS
4843: SELECT ITEM_CATALOG_GROUP_ID
4844: INTO l_item_catalog_group_id

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

4910: WHEN FND_API.G_EXC_ERROR THEN
4911:
4912: x_return_status := FND_API.G_RET_STS_ERROR;
4913:
4914: x_msg_count := ERROR_HANDLER.Get_Message_Count();
4915:
4916: IF (x_msg_count > 0) THEN
4917: ERROR_HANDLER.Log_Error(
4918: p_write_err_to_inttable => 'Y'

Line 4917: ERROR_HANDLER.Log_Error(

4913:
4914: x_msg_count := ERROR_HANDLER.Get_Message_Count();
4915:
4916: IF (x_msg_count > 0) THEN
4917: ERROR_HANDLER.Log_Error(
4918: p_write_err_to_inttable => 'Y'
4919: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
4920: );
4921:

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

4915:
4916: IF (x_msg_count > 0) THEN
4917: ERROR_HANDLER.Log_Error(
4918: p_write_err_to_inttable => 'Y'
4919: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
4920: );
4921:
4922: IF (x_msg_count = 1) THEN
4923: DECLARE

Line 4924: message_list ERROR_HANDLER.Error_Tbl_Type;

4920: );
4921:
4922: IF (x_msg_count = 1) THEN
4923: DECLARE
4924: message_list ERROR_HANDLER.Error_Tbl_Type;
4925: BEGIN
4926: ERROR_HANDLER.Get_Message_List(message_list);
4927: x_msg_data := message_list(message_list.FIRST).message_text;
4928: END;

Line 4926: ERROR_HANDLER.Get_Message_List(message_list);

4922: IF (x_msg_count = 1) THEN
4923: DECLARE
4924: message_list ERROR_HANDLER.Error_Tbl_Type;
4925: BEGIN
4926: ERROR_HANDLER.Get_Message_List(message_list);
4927: x_msg_data := message_list(message_list.FIRST).message_text;
4928: END;
4929: ELSE
4930: x_msg_data := NULL;

Line 4939: l_token_table ERROR_HANDLER.Token_Tbl_Type;

4935:
4936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4937:
4938: DECLARE
4939: l_token_table ERROR_HANDLER.Token_Tbl_Type;
4940: l_dummy_entity_index NUMBER;
4941: l_dummy_entity_id VARCHAR2(60);
4942: l_dummy_message_type VARCHAR2(1);
4943: BEGIN

Line 4951: ERROR_HANDLER.Add_Error_Message(

4947: l_token_table(2).TOKEN_VALUE := l_api_name;
4948: l_token_table(3).TOKEN_NAME := 'SQL_ERR_MSG';
4949: l_token_table(3).TOKEN_VALUE := SQLERRM;
4950:
4951: ERROR_HANDLER.Add_Error_Message(
4952: p_message_name => 'EGO_PLSQL_ERR'
4953: ,p_application_id => 'EGO'
4954: ,p_token_tbl => l_token_table
4955: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 4958: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data

4954: ,p_token_tbl => l_token_table
4955: ,p_message_type => FND_API.G_RET_STS_ERROR
4956: );
4957:
4958: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data
4959: ,x_entity_index => l_dummy_entity_index
4960: ,x_entity_id => l_dummy_entity_id
4961: ,x_message_type => l_dummy_message_type);
4962:

Line 5705: ,p_init_error_handler => 'T'

5701: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs
5702: ,p_class_code_name_value_pairs => l_class_code_name_value_pairs
5703: ,p_data_level_values => l_data_level_values
5704: ,p_additional_class_Code_list => l_additional_class_Code_list
5705: ,p_init_error_handler => 'T'
5706: ,p_init_fnd_msg_list => 'T'
5707: ,p_log_errors => 'T'
5708: ,p_add_errors_to_fnd_stack => 'T'
5709: ,P_commit => l_commit