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: ) IS
413: l_api_name VARCHAR2(30);

Line 429: l_token_table ERROR_HANDLER.Token_Tbl_Type;

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

Line 612: ' - p_initialize_error_handler: '|| p_initialize_error_handler ||

608: ,p_module => l_api_name
609: ,p_message => 'Started with 7 params '||
610: ' p_data_set_id: '|| p_data_set_id ||
611: ' - p_purge_successful_lines: '|| p_purge_successful_lines ||
612: ' - p_initialize_error_handler: '|| p_initialize_error_handler ||
613: ' - p_validate_only: ' || p_validate_only
614: );
615: -- write_records(p_data_set_id => p_data_set_id, p_module => l_api_name, p_message=> 'As given');
616: --If there are no rows to process for this data_set_id, return success.

Line 645: -- ERROR_HANDLER SET-UP --

641: END IF;
642: END IF;
643:
644: --======================--
645: -- ERROR_HANDLER SET-UP --
646: --======================--
647:
648: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
649:

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

644: --======================--
645: -- ERROR_HANDLER SET-UP --
646: --======================--
647:
648: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
649:
650: ERROR_HANDLER.Initialize();
651: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
652:

Line 650: ERROR_HANDLER.Initialize();

646: --======================--
647:
648: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
649:
650: ERROR_HANDLER.Initialize();
651: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
652:
653: ---------------------------------------------------
654: -- If we're debugging, we have to set up a Debug --

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

647:
648: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
649:
650: ERROR_HANDLER.Initialize();
651: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
652:
653: ---------------------------------------------------
654: -- If we're debugging, we have to set up a Debug --
655: -- session (unless our caller already did so) --

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

654: -- If we're debugging, we have to set up a Debug --
655: -- session (unless our caller already did so) --
656: ---------------------------------------------------
657:
658: IF (p_debug_level > 0 AND ERROR_HANDLER.Get_Debug() = 'N') THEN
659: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE, p_debug_level);
660: END IF;
661: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Item/Item Revision Concurrent Program for data set ID: '||p_data_set_id, 0);
662: END IF;

Line 2273: ERROR_HANDLER.Add_Error_Message(

2269: END IF;
2270: END IF;
2271:
2272: l_item_return_status := FND_API.G_RET_STS_ERROR;
2273: ERROR_HANDLER.Add_Error_Message(
2274: p_message_name => l_error_message_name
2275: ,p_application_id => 'EGO'
2276: ,p_token_tbl => l_token_table
2277: ,p_message_type => FND_API.G_RET_STS_ERROR

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

2386: ,p_entity_id => G_ENTITY_ID --IN NUMBER
2387: ,p_entity_index => l_entity_index_counter --IN NUMBER
2388: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2389: ,p_debug_level => p_debug_level --IN NUMBER
2390: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2391: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2392: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2393: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2394: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

Line 2498: ERROR_HANDLER.Add_Error_Message(

2494:
2495: l_error_message_name := 'EGO_BAD_VAR_VALUE';
2496: END IF;
2497:
2498: ERROR_HANDLER.Add_Error_Message(
2499: p_message_name => l_error_message_name
2500: ,p_application_id => 'EGO'
2501: ,p_token_tbl => l_token_table
2502: ,p_message_type => FND_API.G_RET_STS_ERROR

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

2534: ,p_entity_id => G_ENTITY_ID --IN NUMBER
2535: ,p_entity_index => l_entity_index_counter --IN NUMBER
2536: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2537: ,p_debug_level => p_debug_level --IN NUMBER
2538: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2539: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2540: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2541: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2542: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

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

2572: ,p_entity_id => G_ENTITY_ID --IN NUMBER
2573: ,p_entity_index => l_entity_index_counter --IN NUMBER
2574: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2575: ,p_debug_level => p_debug_level --IN NUMBER
2576: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2577: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2578: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2579: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2580: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

Line 2626: ERROR_HANDLER.Add_Error_Message(

2622:
2623: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2624: ERRBUF := l_msg_data;
2625: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2626: ERROR_HANDLER.Add_Error_Message(
2627: p_message_text => l_msg_data
2628: ,p_application_id => 'EGO'
2629: ,p_message_type => FND_API.G_RET_STS_ERROR
2630: ,p_row_identifier => l_err_reporting_transaction_id

Line 2660: ERROR_HANDLER.Add_Error_Message(

2656:
2657: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2658: ERRBUF := l_msg_data;
2659: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2660: ERROR_HANDLER.Add_Error_Message(
2661: p_message_text => l_msg_data
2662: ,p_application_id => 'EGO'
2663: ,p_message_type => FND_API.G_RET_STS_ERROR
2664: ,p_row_identifier => l_err_reporting_transaction_id

Line 2691: ERROR_HANDLER.Add_Error_Message(

2687:
2688: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2689: ERRBUF := l_msg_data;
2690: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2691: ERROR_HANDLER.Add_Error_Message(
2692: p_message_text => l_msg_data
2693: ,p_application_id => 'EGO'
2694: ,p_message_type => FND_API.G_RET_STS_ERROR
2695: ,p_row_identifier => l_err_reporting_transaction_id

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

2796: ,p_entity_id => G_ENTITY_ID --IN NUMBER
2797: ,p_entity_index => l_entity_index_counter --IN NUMBER
2798: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2799: ,p_debug_level => p_debug_level --IN NUMBER
2800: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2801: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2802: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2803: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2804: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

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

2834: ,p_entity_id => G_ENTITY_ID --IN NUMBER
2835: ,p_entity_index => l_entity_index_counter --IN NUMBER
2836: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2837: ,p_debug_level => p_debug_level --IN NUMBER
2838: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2839: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2840: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2841: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2842: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

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

2872: ,p_entity_id => G_ENTITY_ID --IN NUMBER
2873: ,p_entity_index => l_entity_index_counter --IN NUMBER
2874: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
2875: ,p_debug_level => p_debug_level --IN NUMBER
2876: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
2877: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
2878: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
2879: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
2880: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

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

2941: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Done with Item/Item Revision Concurrent Program', 0);
2942: END IF;
2943: END IF; -- IF p_validate_only = FND_API.G...
2944:
2945: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
2946:
2947: -------------------------------------------------------------------
2948: -- Finally, we log any errors that we've accumulated throughout --
2949: -- our conversions and looping (including all errors encountered --

Line 2952: ERROR_HANDLER.Log_Error(

2948: -- Finally, we log any errors that we've accumulated throughout --
2949: -- our conversions and looping (including all errors encountered --
2950: -- within our Business Object's processing) --
2951: -------------------------------------------------------------------
2952: ERROR_HANDLER.Log_Error(
2953: p_write_err_to_inttable => 'Y'
2954: ,p_write_err_to_conclog => 'Y'
2955: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2956: );

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

2951: -------------------------------------------------------------------
2952: ERROR_HANDLER.Log_Error(
2953: p_write_err_to_inttable => 'Y'
2954: ,p_write_err_to_conclog => 'Y'
2955: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2956: );
2957:
2958: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
2959: ERROR_HANDLER.Close_Debug_Session();

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

2954: ,p_write_err_to_conclog => 'Y'
2955: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2956: );
2957:
2958: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
2959: ERROR_HANDLER.Close_Debug_Session();
2960: END IF;
2961: END IF;
2962:

Line 2959: ERROR_HANDLER.Close_Debug_Session();

2955: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
2956: );
2957:
2958: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
2959: ERROR_HANDLER.Close_Debug_Session();
2960: END IF;
2961: END IF;
2962:
2963: COMMIT WORK;

Line 2989: ERROR_HANDLER.Add_Error_Message(

2985: ELSE
2986: l_err_reporting_transaction_id := -1;
2987: END IF;
2988:
2989: ERROR_HANDLER.Add_Error_Message(
2990: p_message_name => 'EGO_EF_NO_NAME_TO_VALIDATE'
2991: ,p_application_id => 'EGO'
2992: ,p_message_type => FND_API.G_RET_STS_ERROR
2993: ,p_row_identifier => l_err_reporting_transaction_id

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

2995: ,p_entity_code => G_ENTITY_CODE
2996: ,p_table_name => G_TABLE_NAME
2997: );
2998:
2999: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
3000:
3001: ---------------------------------------------------------------
3002: -- No matter what the error, we want to make sure everything --
3003: -- we've logged gets to the appropriate error locations --

Line 3005: ERROR_HANDLER.Log_Error(

3001: ---------------------------------------------------------------
3002: -- No matter what the error, we want to make sure everything --
3003: -- we've logged gets to the appropriate error locations --
3004: ---------------------------------------------------------------
3005: ERROR_HANDLER.Log_Error(
3006: p_write_err_to_inttable => 'Y'
3007: ,p_write_err_to_conclog => 'Y'
3008: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3009: );

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

3004: ---------------------------------------------------------------
3005: ERROR_HANDLER.Log_Error(
3006: p_write_err_to_inttable => 'Y'
3007: ,p_write_err_to_conclog => 'Y'
3008: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3009: );
3010:
3011: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
3012: ERROR_HANDLER.Close_Debug_Session();

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

3007: ,p_write_err_to_conclog => 'Y'
3008: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3009: );
3010:
3011: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
3012: ERROR_HANDLER.Close_Debug_Session();
3013: END IF;
3014: END IF;
3015:

Line 3012: ERROR_HANDLER.Close_Debug_Session();

3008: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3009: );
3010:
3011: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
3012: ERROR_HANDLER.Close_Debug_Session();
3013: END IF;
3014: END IF;
3015:
3016: RETCODE := L_CONC_RET_STS_WARNING;

Line 3042: ERROR_HANDLER.Add_Error_Message(

3038: ELSE
3039: l_err_reporting_transaction_id := -1;
3040: END IF;
3041:
3042: ERROR_HANDLER.Add_Error_Message(
3043: p_message_text => 'Unexpected error in '||G_PKG_NAME||'.Process_Item_User_Attrs_Data: '||SQLERRM
3044: ,p_application_id => 'EGO'
3045: ,p_message_type => FND_API.G_RET_STS_ERROR
3046: ,p_row_identifier => l_err_reporting_transaction_id

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

3048: ,p_entity_code => G_ENTITY_CODE
3049: ,p_table_name => G_TABLE_NAME
3050: );
3051:
3052: IF (FND_API.To_Boolean(p_initialize_error_handler)) THEN
3053:
3054: ---------------------------------------------------------------
3055: -- No matter what the error, we want to make sure everything --
3056: -- we've logged gets to the appropriate error locations --

Line 3058: ERROR_HANDLER.Log_Error(

3054: ---------------------------------------------------------------
3055: -- No matter what the error, we want to make sure everything --
3056: -- we've logged gets to the appropriate error locations --
3057: ---------------------------------------------------------------
3058: ERROR_HANDLER.Log_Error(
3059: p_write_err_to_inttable => 'Y'
3060: ,p_write_err_to_conclog => 'Y'
3061: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3062: );

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

3057: ---------------------------------------------------------------
3058: ERROR_HANDLER.Log_Error(
3059: p_write_err_to_inttable => 'Y'
3060: ,p_write_err_to_conclog => 'Y'
3061: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3062: );
3063:
3064: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
3065: ERROR_HANDLER.Close_Debug_Session();

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

3060: ,p_write_err_to_conclog => 'Y'
3061: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3062: );
3063:
3064: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
3065: ERROR_HANDLER.Close_Debug_Session();
3066: END IF;
3067: END IF;
3068:

Line 3065: ERROR_HANDLER.Close_Debug_Session();

3061: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
3062: );
3063:
3064: IF (ERROR_HANDLER.Get_Debug() = 'Y') THEN
3065: ERROR_HANDLER.Close_Debug_Session();
3066: END IF;
3067: END IF;
3068:
3069: RETCODE := L_CONC_RET_STS_ERROR;