APPS.EGO_VS_BULKLOAD_PVT dependencies on ERROR_HANDLER

Line 110: G_TOKEN_TBL Error_Handler.Token_Tbl_Type;

106: G_P4TP_PROFILE_ENABLED BOOLEAN := FALSE;
107:
108:
109: G_TABLE_NAME CONSTANT VARCHAR2(30) := 'EGO_FLEX_VALUE_SET_INTF';
110: G_TOKEN_TBL Error_Handler.Token_Tbl_Type;
111:
112: --------------------------------------------------------------
113: -- The Entity Codes are used for error-handling purposes. --
114: --------------------------------------------------------------

Line 533: l_token_table ERROR_HANDLER.Token_Tbl_Type;

529: l_entity_code VARCHAR2(30) := G_ENTITY_VS_VAL;
530: l_table_name VARCHAR2(240):= G_ENTITY_VAL_HEADER_TAB;
531: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
532: l_application_id NUMBER := G_Application_Id;
533: l_token_table ERROR_HANDLER.Token_Tbl_Type;
534: l_valid_type NUMBER := NULL;
535:
536: CURSOR Cur_format_meaning(cp_format_code VARCHAR2)
537: IS

Line 592: ERROR_HANDLER.Add_Error_Message(

588: l_token_table(2).TOKEN_VALUE := To_Char(SYSDATE,l_mask_format) ;
589:
590:
591:
592: ERROR_HANDLER.Add_Error_Message(
593: p_message_name => l_error_message_name
594: ,p_application_id => G_App_Short_Name
595: ,p_token_tbl => l_token_table
596: ,p_message_type => G_RET_STS_ERROR

Line 621: ERROR_HANDLER.Add_Error_Message(

617: l_token_table(2).TOKEN_VALUE := To_Char(SYSDATE,l_mask_format) ;
618:
619:
620:
621: ERROR_HANDLER.Add_Error_Message(
622: p_message_name => l_error_message_name
623: ,p_application_id => G_App_Short_Name
624: ,p_token_tbl => l_token_table
625: ,p_message_type => G_RET_STS_ERROR

Line 696: ERROR_HANDLER.Add_Error_Message(

692: --Log error
693: l_return_status := G_RET_STS_ERROR;
694:
695:
696: ERROR_HANDLER.Add_Error_Message(
697: p_message_name => l_error_message_name
698: ,p_application_id => G_App_Short_Name
699: ,p_token_tbl => l_token_table
700: ,p_message_type => G_RET_STS_ERROR

Line 865: l_token_table ERROR_HANDLER.Token_Tbl_Type;

861: l_entity_code VARCHAR2(40) := G_ENTITY_CHILD_VS;
862: l_table_name VARCHAR2(240) := G_ENTITY_VS_HEADER_TAB;
863: l_application_id NUMBER := G_Application_Id;
864:
865: l_token_table ERROR_HANDLER.Token_Tbl_Type;
866: l_error_message_name VARCHAR2(500);
867: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
868:
869:

Line 897: ERROR_HANDLER.Add_Error_Message(

893: l_token_table(2).TOKEN_NAME := 'VALUE_SET_ID';
894: l_token_table(2).TOKEN_VALUE := l_value_set_id;
895:
896:
897: ERROR_HANDLER.Add_Error_Message(
898: p_message_name => l_error_message_name
899: ,p_application_id => G_App_Short_Name
900: ,p_token_tbl => l_token_table
901: ,p_message_type => G_RET_STS_ERROR

Line 934: ERROR_HANDLER.Add_Error_Message(

930: l_token_table(1).TOKEN_NAME := 'VALUE_SET_NAME';
931: l_token_table(1).TOKEN_VALUE := l_value_set_name;
932:
933:
934: ERROR_HANDLER.Add_Error_Message(
935: p_message_name => l_error_message_name
936: ,p_application_id => G_App_Short_Name
937: ,p_token_tbl => l_token_table
938: ,p_message_type => G_RET_STS_ERROR

Line 966: ERROR_HANDLER.Add_Error_Message(

962: l_token_table(1).TOKEN_NAME := 'VALUE_SET_NAME';
963: l_token_table(1).TOKEN_VALUE := l_value_set_name;
964:
965:
966: ERROR_HANDLER.Add_Error_Message(
967: p_message_name => l_error_message_name
968: ,p_application_id => G_App_Short_Name
969: ,p_token_tbl => l_token_table
970: ,p_message_type => G_RET_STS_ERROR

Line 998: ERROR_HANDLER.Add_Error_Message(

994: l_token_table(1).TOKEN_NAME := 'VALUE_SET_NAME';
995: l_token_table(1).TOKEN_VALUE := l_value_set_name;
996:
997:
998: ERROR_HANDLER.Add_Error_Message(
999: p_message_name => l_error_message_name
1000: ,p_application_id => G_App_Short_Name
1001: ,p_token_tbl => l_token_table
1002: ,p_message_type => G_RET_STS_ERROR

Line 1100: l_token_table ERROR_HANDLER.Token_Tbl_Type;

1096: l_application_id NUMBER := G_Application_Id;
1097:
1098: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1099:
1100: l_token_table ERROR_HANDLER.Token_Tbl_Type;
1101: l_error_message_name VARCHAR2(500);
1102: l_tab_exist NUMBER := NULL;
1103: l_col_exist NUMBER := NULL;
1104:

Line 1145: ERROR_HANDLER.Add_Error_Message(

1141:
1142: l_error_message_name := 'EGO_VS_VAL_DATA_TYPE_MISMATCH';
1143: l_return_status := G_RET_STS_ERROR;
1144:
1145: ERROR_HANDLER.Add_Error_Message(
1146: p_message_name => l_error_message_name
1147: ,p_application_id => G_App_Short_Name
1148: ,p_token_tbl => l_token_table
1149: ,p_message_type => G_RET_STS_ERROR

Line 1168: ERROR_HANDLER.Add_Error_Message(

1164:
1165: l_error_message_name := 'EGO_VS_VAL_DATA_TYPE_MISMATCH';
1166: l_return_status := G_RET_STS_ERROR;
1167:
1168: ERROR_HANDLER.Add_Error_Message(
1169: p_message_name => l_error_message_name
1170: ,p_application_id => G_App_Short_Name
1171: ,p_token_tbl => l_token_table
1172: ,p_message_type => G_RET_STS_ERROR

Line 1196: ERROR_HANDLER.Add_Error_Message(

1192:
1193: l_error_message_name := 'EGO_VS_VAL_DATA_TYPE_MISMATCH';
1194: l_return_status := G_RET_STS_ERROR;
1195:
1196: ERROR_HANDLER.Add_Error_Message(
1197: p_message_name => l_error_message_name
1198: ,p_application_id => G_App_Short_Name
1199: ,p_token_tbl => l_token_table
1200: ,p_message_type => G_RET_STS_ERROR

Line 1219: ERROR_HANDLER.Add_Error_Message(

1215:
1216: l_error_message_name := 'EGO_VS_VAL_DATA_TYPE_MISMATCH';
1217: l_return_status := G_RET_STS_ERROR;
1218:
1219: ERROR_HANDLER.Add_Error_Message(
1220: p_message_name => l_error_message_name
1221: ,p_application_id => G_App_Short_Name
1222: ,p_token_tbl => l_token_table
1223: ,p_message_type => G_RET_STS_ERROR

Line 1252: ERROR_HANDLER.Add_Error_Message(

1248:
1249: l_error_message_name := 'EGO_VS_VAL_DATA_TYPE_MISMATCH';
1250: l_return_status := G_RET_STS_ERROR;
1251:
1252: ERROR_HANDLER.Add_Error_Message(
1253: p_message_name => l_error_message_name
1254: ,p_application_id => G_App_Short_Name
1255: ,p_token_tbl => l_token_table
1256: ,p_message_type => G_RET_STS_ERROR

Line 1334: ERROR_HANDLER.Add_Error_Message(

1330:
1331: l_error_message_name := 'EGO_VS_TABLE_SETUP_ERROR';
1332: l_return_status := G_RET_STS_ERROR;
1333:
1334: ERROR_HANDLER.Add_Error_Message(
1335: p_message_name => l_error_message_name
1336: ,p_application_id => G_App_Short_Name
1337: ,p_token_tbl => l_token_table
1338: ,p_message_type => G_RET_STS_ERROR

Line 1925: l_token_table ERROR_HANDLER.Token_Tbl_Type;

1921: l_entity_code VARCHAR2(40) := G_ENTITY_VS_VER;
1922: l_table_name VARCHAR2(240):= G_ENTITY_VS_HEADER_TAB;
1923: l_application_id NUMBER := G_Application_Id;
1924:
1925: l_token_table ERROR_HANDLER.Token_Tbl_Type;
1926: l_error_message_name VARCHAR2(500);
1927:
1928:
1929: l_target_max_ver NUMBER := NULL ;

Line 2007: ERROR_HANDLER.Add_Error_Message(

2003:
2004: x_return_status := G_RET_STS_ERROR;
2005: l_error_message_name := 'EGO_VSET_VERSION_DATE_ERROR';
2006:
2007: ERROR_HANDLER.Add_Error_Message(
2008: p_message_name => l_error_message_name
2009: ,p_application_id => G_App_Short_Name
2010: ,p_token_tbl => l_token_table
2011: ,p_message_type => G_RET_STS_ERROR

Line 2047: ERROR_HANDLER.Add_Error_Message(

2043:
2044: x_return_status := G_RET_STS_ERROR;
2045: l_error_message_name := 'EGO_VSET_VERSION_DATE_ERROR';
2046:
2047: ERROR_HANDLER.Add_Error_Message(
2048: p_message_name => l_error_message_name
2049: ,p_application_id => G_App_Short_Name
2050: ,p_token_tbl => l_token_table
2051: ,p_message_type => G_RET_STS_ERROR

Line 2088: ERROR_HANDLER.Add_Error_Message(

2084: l_error_message_name := 'EGO_VSET_VER_RELDATE_ERROR';
2085: l_token_table(1).TOKEN_NAME := 'VALUE_SET_ID';
2086: l_token_table(1).TOKEN_VALUE := l_value_set_id;
2087:
2088: ERROR_HANDLER.Add_Error_Message(
2089: p_message_name => l_error_message_name
2090: ,p_application_id => G_App_Short_Name
2091: ,p_token_tbl => l_token_table
2092: ,p_message_type => G_RET_STS_ERROR

Line 2243: ERROR_HANDLER.Add_Error_Message (

2239: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
2240: G_TOKEN_TBL(4).Token_Value := 'Get_Lock_Info';
2241:
2242:
2243: ERROR_HANDLER.Add_Error_Message (
2244: p_message_name => 'EGO_ENTITY_API_FAILED'
2245: ,p_application_id => G_App_Short_Name
2246: ,p_token_tbl => G_TOKEN_TBL
2247: ,p_message_type => G_RET_STS_ERROR

Line 2286: ERROR_HANDLER.Add_Error_Message(

2282: l_token_table(2).TOKEN_NAME := 'PARTY_NAME';
2283: l_token_table(2).TOKEN_VALUE := G_Locking_Party_Name;
2284:
2285:
2286: ERROR_HANDLER.Add_Error_Message(
2287: p_message_name => l_error_message_name
2288: ,p_application_id => G_App_Short_Name
2289: ,p_token_tbl => l_token_table
2290: ,p_message_type => G_RET_STS_ERROR

Line 2427: ERROR_HANDLER.Add_Error_Message (

2423: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
2424: G_TOKEN_TBL(4).Token_Value := 'Lock_Unlock_Object';
2425:
2426:
2427: ERROR_HANDLER.Add_Error_Message (
2428: p_message_name => 'EGO_ENTITY_API_FAILED'
2429: ,p_application_id => G_App_Short_Name
2430: ,p_token_tbl => G_TOKEN_TBL
2431: ,p_message_type => G_RET_STS_ERROR

Line 2520: l_token_table ERROR_HANDLER.Token_Tbl_Type;

2516: l_entity_code VARCHAR2(40) := G_ENTITY_VS;
2517: l_table_name VARCHAR2(240) := G_ENTITY_VS_HEADER_TAB;
2518: l_application_id NUMBER := G_Application_Id;
2519:
2520: l_token_table ERROR_HANDLER.Token_Tbl_Type;
2521: l_error_message_name VARCHAR2(500);
2522:
2523:
2524: CURSOR cur_value

Line 2622: ERROR_HANDLER.Add_Error_Message(

2618: l_token_table(1).TOKEN_NAME := 'VALUE_SET_NAME';
2619: l_token_table(1).TOKEN_VALUE := l_value_set_name;
2620:
2621:
2622: ERROR_HANDLER.Add_Error_Message(
2623: p_message_name => l_error_message_name
2624: ,p_application_id => G_App_Short_Name
2625: ,p_token_tbl => l_token_table
2626: ,p_message_type => G_RET_STS_ERROR

Line 2651: ERROR_HANDLER.Add_Error_Message(

2647: l_token_table(1).TOKEN_NAME := 'VALUE_SET_NAME';
2648: l_token_table(1).TOKEN_VALUE := l_value_set_name;
2649:
2650:
2651: ERROR_HANDLER.Add_Error_Message(
2652: p_message_name => l_error_message_name
2653: ,p_application_id => G_App_Short_Name
2654: ,p_token_tbl => l_token_table
2655: ,p_message_type => G_RET_STS_ERROR

Line 2684: ERROR_HANDLER.Add_Error_Message(

2680:
2681: l_token_table(1).TOKEN_NAME := 'VALUE_SET_NAME';
2682: l_token_table(1).TOKEN_VALUE := l_value_set_name;
2683:
2684: ERROR_HANDLER.Add_Error_Message(
2685: p_message_name => l_error_message_name
2686: ,p_application_id => G_App_Short_Name
2687: ,p_token_tbl => l_token_table
2688: ,p_message_type => G_RET_STS_ERROR

Line 2722: ERROR_HANDLER.Add_Error_Message(

2718: l_token_table(1).TOKEN_NAME := 'MAXVALUE';
2719: l_token_table(1).TOKEN_VALUE := x_maximum_value;
2720:
2721:
2722: ERROR_HANDLER.Add_Error_Message(
2723: p_message_name => l_error_message_name
2724: ,p_application_id => G_App_Short_Name
2725: ,p_token_tbl => l_token_table
2726: ,p_message_type => G_RET_STS_ERROR

Line 3599: l_token_table ERROR_HANDLER.Token_Tbl_Type;

3595: /* Local variable to be used in error handling mechanism*/
3596: l_entity_code VARCHAR2(40) := G_ENTITY_VS;
3597: l_table_name VARCHAR2(240):= G_ENTITY_VS_HEADER_TAB;
3598:
3599: l_token_table ERROR_HANDLER.Token_Tbl_Type;
3600: l_application_id NUMBER := G_Application_Id;
3601: l_error_message_name VARCHAR2(500);
3602: --l_error_row_identifier NUMBER;
3603: l_transaction_id NUMBER :=p_transaction_id;

Line 3626: ERROR_HANDLER.Add_Error_Message(

3622: l_token_table(1).TOKEN_VALUE := l_value_set_name;
3623: x_return_status := G_RET_STS_ERROR;
3624:
3625:
3626: ERROR_HANDLER.Add_Error_Message(
3627: p_message_name => l_error_message_name
3628: ,p_application_id => G_App_Short_Name
3629: ,p_token_tbl => l_token_table
3630: ,p_message_type => G_RET_STS_ERROR

Line 3650: ERROR_HANDLER.Add_Error_Message(

3646: l_token_table(1).TOKEN_NAME := 'VALUE_SET_NAME';
3647: l_token_table(1).TOKEN_VALUE := l_value_set_name;
3648: x_return_status := G_RET_STS_ERROR;
3649:
3650: ERROR_HANDLER.Add_Error_Message(
3651: p_message_name => l_error_message_name
3652: ,p_application_id => G_App_Short_Name
3653: ,p_token_tbl => l_token_table
3654: ,p_message_type => G_RET_STS_ERROR

Line 3675: ERROR_HANDLER.Add_Error_Message(

3671: l_token_table(1).TOKEN_NAME := 'VALUE_SET_NAME';
3672: l_token_table(1).TOKEN_VALUE := l_value_set_name;
3673: x_return_status := G_RET_STS_ERROR;
3674:
3675: ERROR_HANDLER.Add_Error_Message(
3676: p_message_name => l_error_message_name
3677: ,p_application_id => G_App_Short_Name
3678: ,p_token_tbl => l_token_table
3679: ,p_message_type => G_RET_STS_ERROR

Line 3704: ERROR_HANDLER.Add_Error_Message(

3700: l_token_table(1).TOKEN_NAME := 'VALUE_SET_NAME';
3701: l_token_table(1).TOKEN_VALUE := l_value_set_name;
3702: x_return_status := G_RET_STS_ERROR;
3703:
3704: ERROR_HANDLER.Add_Error_Message(
3705: p_message_name => l_error_message_name
3706: ,p_application_id => G_App_Short_Name
3707: ,p_token_tbl => l_token_table
3708: ,p_message_type => G_RET_STS_ERROR

Line 3735: ERROR_HANDLER.Add_Error_Message(

3731: l_token_table(1).TOKEN_NAME := 'VALUE_SET_NAME';
3732: l_token_table(1).TOKEN_VALUE := l_value_set_name;
3733: x_return_status := G_RET_STS_ERROR;
3734:
3735: ERROR_HANDLER.Add_Error_Message(
3736: p_message_name => l_error_message_name
3737: ,p_application_id => G_App_Short_Name
3738: ,p_token_tbl => l_token_table
3739: ,p_message_type => G_RET_STS_ERROR

Line 3773: ERROR_HANDLER.Add_Error_Message(

3769: l_token_table(1).TOKEN_NAME := 'MAXVALUE';
3770: l_token_table(1).TOKEN_VALUE := l_maximum_value;
3771:
3772:
3773: ERROR_HANDLER.Add_Error_Message(
3774: p_message_name => l_error_message_name
3775: ,p_application_id => G_App_Short_Name
3776: ,p_token_tbl => l_token_table
3777: ,p_message_type => G_RET_STS_ERROR

Line 3807: ERROR_HANDLER.Add_Error_Message(

3803: l_error_message_name := 'EGO_VS_MAXSIZE_REQ';
3804: x_return_status := G_RET_STS_ERROR;
3805:
3806:
3807: ERROR_HANDLER.Add_Error_Message(
3808: p_message_name => l_error_message_name
3809: ,p_application_id => G_App_Short_Name
3810: ,p_token_tbl => l_token_table
3811: ,p_message_type => G_RET_STS_ERROR

Line 4907: ERROR_HANDLER.Add_Error_Message (

4903: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
4904: G_TOKEN_TBL(4).Token_Value := 'Release_Value_Set_Version';
4905:
4906:
4907: ERROR_HANDLER.Add_Error_Message (
4908: p_message_name => 'EGO_ENTITY_API_FAILED'
4909: ,p_application_id => G_App_Short_Name
4910: ,p_token_tbl => G_TOKEN_TBL
4911: ,p_message_type => G_RET_STS_ERROR

Line 5064: ERROR_HANDLER.Add_Error_Message (

5060: x_return_status := l_return_status;
5061: l_valueset_tab(j).process_status := G_ERROR_RECORD;
5062:
5063:
5064: ERROR_HANDLER.Add_Error_Message (
5065: p_message_name => 'EGO_VERS_VS_VAL_REQ'
5066: ,p_application_id => G_App_Short_Name
5067: ,p_token_tbl => G_TOKEN_TBL
5068: ,p_message_type => G_RET_STS_ERROR

Line 5123: ERROR_HANDLER.Add_Error_Message (

5119: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
5120: G_TOKEN_TBL(4).Token_Value := 'Sync_VS_With_Draft';
5121:
5122:
5123: ERROR_HANDLER.Add_Error_Message (
5124: p_message_name => 'EGO_ENTITY_API_FAILED'
5125: ,p_application_id => G_App_Short_Name
5126: ,p_token_tbl => G_TOKEN_TBL
5127: ,p_message_type => G_RET_STS_ERROR

Line 5168: ERROR_HANDLER.Add_Error_Message (

5164: write_debug(G_PKG_Name,l_api_name,'Err_Msg-TID=' ||l_valueset_tab(j).transaction_id||'-(VS Id)=('
5165: ||l_valueset_tab(j).value_set_id||')'||' Release of value set failed. ');
5166:
5167:
5168: ERROR_HANDLER.Add_Error_Message (
5169: p_message_name => 'EGO_VS_RELEASE_FAILED'
5170: ,p_application_id => G_App_Short_Name
5171: ,p_token_tbl => G_TOKEN_TBL
5172: ,p_message_type => G_RET_STS_ERROR

Line 5206: ERROR_HANDLER.Add_Error_Message (

5202: write_debug(G_PKG_Name,l_api_name,'Err_Msg-TID=' ||l_valueset_tab(j).transaction_id||'-(VS Id)=('
5203: ||l_valueset_val_tab(Val_Cur).transaction_id||')'||' Release of value set failed. ');
5204:
5205:
5206: ERROR_HANDLER.Add_Error_Message (
5207: p_message_name => 'EGO_VS_RELEASE_FAILED'
5208: ,p_application_id => G_App_Short_Name
5209: ,p_token_tbl => G_TOKEN_TBL
5210: ,p_message_type => G_RET_STS_ERROR

Line 5237: ERROR_HANDLER.Add_Error_Message (

5233:
5234: write_debug(G_PKG_Name,l_api_name,'Err_Msg-TID=' ||l_valueset_tab(j).transaction_id||'-(VS Id)=('
5235: ||l_valueset_val_tl_tbl(Tl_Val).transaction_id||')'||' Release of value set failed. ');
5236:
5237: ERROR_HANDLER.Add_Error_Message (
5238: p_message_name => 'EGO_VS_RELEASE_FAILED'
5239: ,p_application_id => G_App_Short_Name
5240: ,p_token_tbl => G_TOKEN_TBL
5241: ,p_message_type => G_RET_STS_ERROR

Line 5677: l_token_table ERROR_HANDLER.Token_Tbl_Type;

5673: l_entity_code VARCHAR2(40) := G_ENTITY_VS;
5674: l_table_name VARCHAR2(240) := G_ENTITY_VS_HEADER_TAB;
5675: l_application_id NUMBER := G_Application_Id;
5676:
5677: l_token_table ERROR_HANDLER.Token_Tbl_Type;
5678:
5679: l_error_message_name VARCHAR2(500);
5680: l_error_row_identifier NUMBER;
5681: l_transaction_id NUMBER;

Line 5739: -- Error handler initialization

5735: write_debug(G_PKG_Name,l_api_name,' Start of API. ' );
5736: ----Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' Start of API. ' );
5737:
5738:
5739: -- Error handler initialization
5740: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_VS);
5741:
5742: -- Get application id
5743: SELECT application_id

Line 5740: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_VS);

5736: ----Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' Start of API. ' );
5737:
5738:
5739: -- Error handler initialization
5740: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_VS);
5741:
5742: -- Get application id
5743: SELECT application_id
5744: INTO l_application_id

Line 5826: ERROR_HANDLER.Add_Error_Message(

5822: l_token_table(1).TOKEN_NAME := 'VALUE_SET_ID';
5823: l_token_table(1).TOKEN_VALUE := l_value_set_id;
5824:
5825:
5826: ERROR_HANDLER.Add_Error_Message(
5827: p_message_name => l_error_message_name
5828: ,p_application_id => G_App_Short_Name
5829: ,p_token_tbl => l_token_table
5830: ,p_message_type => G_RET_STS_ERROR

Line 5866: ERROR_HANDLER.Add_Error_Message(

5862: l_last_update_login := g_login_id;
5863:
5864:
5865:
5866: ERROR_HANDLER.Add_Error_Message(
5867: p_message_name => l_error_message_name
5868: ,p_application_id => G_App_Short_Name
5869: ,p_token_tbl => l_token_table
5870: ,p_message_type => G_RET_STS_ERROR

Line 5906: ERROR_HANDLER.Add_Error_Message(

5902:
5903: l_error_message_name := 'FEM_ADMIN_VSNAME_EXISTS_ERR';
5904:
5905:
5906: ERROR_HANDLER.Add_Error_Message(
5907: p_message_name => l_error_message_name
5908: ,p_application_id => G_App_Short_Name
5909: ,p_token_tbl => l_token_table
5910: ,p_message_type => G_RET_STS_ERROR

Line 5946: ERROR_HANDLER.Add_Error_Message(

5942: l_last_update_date := SYSDATE;
5943: l_last_update_login := g_login_id;
5944:
5945:
5946: ERROR_HANDLER.Add_Error_Message(
5947: p_message_name => l_error_message_name
5948: ,p_application_id => G_App_Short_Name
5949: ,p_token_tbl => l_token_table
5950: ,p_message_type => G_RET_STS_ERROR

Line 6027: ERROR_HANDLER.Add_Error_Message(

6023: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
6024: G_TOKEN_TBL(4).Token_Value := 'Get_Key_VS_Columns';
6025:
6026:
6027: ERROR_HANDLER.Add_Error_Message(
6028: p_message_name => 'EGO_ENTITY_API_FAILED'
6029: ,p_application_id => G_App_Short_Name
6030: ,p_token_tbl => G_TOKEN_TBL
6031: ,p_message_type => G_RET_STS_ERROR

Line 6244: ERROR_HANDLER.Add_Error_Message(

6240: G_TOKEN_TBL(4).Token_Value := 'Create_Value_Set';
6241:
6242:
6243:
6244: ERROR_HANDLER.Add_Error_Message(
6245: p_message_name => 'EGO_ENTITY_API_FAILED'
6246: ,p_application_id => G_App_Short_Name
6247: ,p_token_tbl => G_TOKEN_TBL
6248: ,p_message_type => G_RET_STS_ERROR

Line 6322: ERROR_HANDLER.Add_Error_Message(

6318: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
6319: G_TOKEN_TBL(4).Token_Value := 'Insert_Value_Set_Table_Inf';
6320:
6321:
6322: ERROR_HANDLER.Add_Error_Message(
6323: p_message_name => 'EGO_ENTITY_API_FAILED'
6324: ,p_application_id => G_App_Short_Name
6325: ,p_token_tbl => G_TOKEN_TBL
6326: ,p_message_type => G_RET_STS_ERROR

Line 6361: ERROR_HANDLER.Add_Error_Message(

6357: l_error_message_name := 'EGO_NONE_VS_VERSION_ERROR';
6358: l_token_table(1).TOKEN_NAME := 'VALUE_SET_NAME';
6359: l_token_table(1).TOKEN_VALUE := l_value_set_name;
6360:
6361: ERROR_HANDLER.Add_Error_Message(
6362: p_message_name => l_error_message_name
6363: ,p_application_id => G_App_Short_Name
6364: ,p_token_tbl => l_token_table
6365: ,p_message_type => G_RET_STS_ERROR

Line 6431: ERROR_HANDLER.Add_Error_Message(

6427: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
6428: G_TOKEN_TBL(4).Token_Value := 'Create_Value_Set';
6429:
6430:
6431: ERROR_HANDLER.Add_Error_Message(
6432: p_message_name => 'EGO_ENTITY_API_FAILED'
6433: ,p_application_id => G_App_Short_Name
6434: ,p_token_tbl => G_TOKEN_TBL
6435: ,p_message_type => G_RET_STS_ERROR

Line 6512: ERROR_HANDLER.Add_Error_Message(

6508: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
6509: G_TOKEN_TBL(4).Token_Value := 'Create_Value_Set';
6510:
6511:
6512: ERROR_HANDLER.Add_Error_Message(
6513: p_message_name => 'EGO_ENTITY_API_FAILED'
6514: ,p_application_id => G_App_Short_Name
6515: ,p_token_tbl => G_TOKEN_TBL
6516: ,p_message_type => G_RET_STS_ERROR

Line 6598: ERROR_HANDLER.Add_Error_Message(

6594: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
6595: G_TOKEN_TBL(4).Token_Value := 'Get_Key_VS_Columns';
6596:
6597:
6598: ERROR_HANDLER.Add_Error_Message(
6599: p_message_name => 'EGO_ENTITY_API_FAILED'
6600: ,p_application_id => G_App_Short_Name
6601: ,p_token_tbl => G_TOKEN_TBL
6602: ,p_message_type => G_RET_STS_ERROR

Line 6706: ERROR_HANDLER.Add_Error_Message(

6702: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
6703: G_TOKEN_TBL(4).Token_Value := 'Update_Value_Set';
6704:
6705:
6706: ERROR_HANDLER.Add_Error_Message(
6707: p_message_name => 'EGO_ENTITY_API_FAILED'
6708: ,p_application_id => G_App_Short_Name
6709: ,p_token_tbl => G_TOKEN_TBL
6710: ,p_message_type => G_RET_STS_ERROR

Line 6810: ERROR_HANDLER.Add_Error_Message(

6806: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
6807: G_TOKEN_TBL(4).Token_Value := 'Update_Value_Set_Table_Inf';
6808:
6809:
6810: ERROR_HANDLER.Add_Error_Message(
6811: p_message_name => 'EGO_ENTITY_API_FAILED'
6812: ,p_application_id => G_App_Short_Name
6813: ,p_token_tbl => G_TOKEN_TBL
6814: ,p_message_type => G_RET_STS_ERROR

Line 6880: ERROR_HANDLER.Add_Error_Message(

6876: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
6877: G_TOKEN_TBL(4).Token_Value := 'Insert_Value_Set_Table_Inf';
6878:
6879:
6880: ERROR_HANDLER.Add_Error_Message(
6881: p_message_name => 'EGO_ENTITY_API_FAILED'
6882: ,p_application_id => G_App_Short_Name
6883: ,p_token_tbl => G_TOKEN_TBL
6884: ,p_message_type => G_RET_STS_ERROR

Line 7170: l_token_table ERROR_HANDLER.Token_Tbl_Type;

7166: l_is_versioned VARCHAR2(20):=NULL;
7167: l_api_mode NUMBER := G_FLOW_TYPE;
7168: l_validation_code VARCHAR2(10);
7169: l_format_code VARCHAR2(10);
7170: l_token_table ERROR_HANDLER.Token_Tbl_Type;
7171: l_application_id NUMBER;
7172:
7173: l_return_status VARCHAR2(1) := NULL;
7174:

Line 7312: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_VS);

7308: -- Call API to get current value of mask.
7309: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_mask_format);
7310:
7311:
7312: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_VS);
7313:
7314: FOR i IN p_value_set_val_tbl.first..p_value_set_val_tbl.last
7315: LOOP
7316: --Assigning value per record

Line 7374: ERROR_HANDLER.Add_Error_Message(

7370: l_last_update_login := g_login_id;
7371:
7372:
7373:
7374: ERROR_HANDLER.Add_Error_Message(
7375: p_message_name => l_error_message_name
7376: ,p_application_id => G_App_Short_Name
7377: ,p_token_tbl => l_token_table
7378: ,p_message_type => G_RET_STS_ERROR

Line 7415: ERROR_HANDLER.Add_Error_Message(

7411: l_token_table(2).TOKEN_NAME := 'VALUE_SET_ID';
7412: l_token_table(2).TOKEN_VALUE := l_value_set_name;
7413:
7414:
7415: ERROR_HANDLER.Add_Error_Message(
7416: p_message_name => l_error_message_name
7417: ,p_application_id => G_App_Short_Name
7418: ,p_token_tbl => l_token_table
7419: ,p_message_type => G_RET_STS_ERROR

Line 7463: ERROR_HANDLER.Add_Error_Message(

7459: l_last_update_login := g_login_id;
7460:
7461:
7462:
7463: ERROR_HANDLER.Add_Error_Message(
7464: p_message_name => l_error_message_name
7465: ,p_application_id => G_App_Short_Name
7466: ,p_token_tbl => l_token_table
7467: ,p_message_type => G_RET_STS_ERROR

Line 7548: ERROR_HANDLER.Add_Error_Message(

7544: l_token_table(2).TOKEN_NAME := 'FLEX_VALUE_ID';
7545: l_token_table(2).TOKEN_VALUE := l_flex_value_id;
7546:
7547:
7548: ERROR_HANDLER.Add_Error_Message(
7549: p_message_name => l_error_message_name
7550: ,p_application_id => G_App_Short_Name
7551: ,p_token_tbl => l_token_table
7552: ,p_message_type => G_RET_STS_ERROR

Line 7599: ERROR_HANDLER.Add_Error_Message(

7595: l_last_update_login := g_login_id;
7596:
7597: l_error_message_name := 'EGO_EF_VAL_SEQ_ERR';
7598:
7599: ERROR_HANDLER.Add_Error_Message(
7600: p_message_name => l_error_message_name
7601: ,p_application_id => G_App_Short_Name
7602: ,p_token_tbl => l_token_table
7603: ,p_message_type => G_RET_STS_ERROR

Line 7633: ERROR_HANDLER.Add_Error_Message(

7629: l_last_update_login := g_login_id;
7630:
7631: l_error_message_name := 'EGO_EF_VAL_SEQ_ERR';
7632:
7633: ERROR_HANDLER.Add_Error_Message(
7634: p_message_name => l_error_message_name
7635: ,p_application_id => G_App_Short_Name
7636: ,p_token_tbl => l_token_table
7637: ,p_message_type => G_RET_STS_ERROR

Line 7661: ERROR_HANDLER.Add_Error_Message(

7657: l_token_table(1).TOKEN_NAME := 'VALUE_SET_NAME';
7658: l_token_table(1).TOKEN_VALUE := l_value_set_name;
7659: x_return_status := G_RET_STS_ERROR;
7660:
7661: ERROR_HANDLER.Add_Error_Message(
7662: p_message_name => l_error_message_name
7663: ,p_application_id => G_App_Short_Name
7664: ,p_token_tbl => l_token_table
7665: ,p_message_type => G_RET_STS_ERROR

Line 7693: ERROR_HANDLER.Add_Error_Message(

7689: l_error_message_name := 'EGO_VALUE_VALIDATION_ERROR';
7690: l_token_table(1).TOKEN_NAME := 'VALUE_SET_NAME';
7691: l_token_table(1).TOKEN_VALUE := l_value_set_name;
7692:
7693: ERROR_HANDLER.Add_Error_Message(
7694: p_message_name => l_error_message_name
7695: ,p_application_id => G_App_Short_Name
7696: ,p_token_tbl => l_token_table
7697: ,p_message_type => G_RET_STS_ERROR

Line 7726: ERROR_HANDLER.Add_Error_Message(

7722: l_last_update_date := SYSDATE;
7723: l_last_update_login := g_login_id;
7724:
7725:
7726: ERROR_HANDLER.Add_Error_Message(
7727: p_message_name => l_error_message_name
7728: ,p_application_id => G_App_Short_Name
7729: ,p_token_tbl => l_token_table
7730: ,p_message_type => G_RET_STS_ERROR

Line 7780: ERROR_HANDLER.Add_Error_Message(

7776: l_last_update_date := SYSDATE;
7777: l_last_update_login := g_login_id;
7778:
7779:
7780: ERROR_HANDLER.Add_Error_Message(
7781: p_message_name => l_error_message_name
7782: ,p_application_id => G_App_Short_Name
7783: ,p_token_tbl => l_token_table
7784: ,p_message_type => G_RET_STS_ERROR

Line 7811: ERROR_HANDLER.Add_Error_Message(

7807: l_last_update_date := SYSDATE;
7808: l_last_update_login := g_login_id;
7809:
7810:
7811: ERROR_HANDLER.Add_Error_Message(
7812: p_message_name => l_error_message_name
7813: ,p_application_id => G_App_Short_Name
7814: ,p_token_tbl => l_token_table
7815: ,p_message_type => G_RET_STS_ERROR

Line 7845: ERROR_HANDLER.Add_Error_Message(

7841: l_last_update_login := g_login_id;
7842:
7843:
7844:
7845: ERROR_HANDLER.Add_Error_Message(
7846: p_message_name => l_error_message_name
7847: ,p_application_id => G_App_Short_Name
7848: ,p_token_tbl => l_token_table
7849: ,p_message_type => G_RET_STS_ERROR

Line 7878: ERROR_HANDLER.Add_Error_Message(

7874:
7875: l_token_table(1).TOKEN_NAME := 'FORMAT_MEANING';
7876: l_token_table(1).TOKEN_VALUE := G_NUMBER_FORMAT;
7877:
7878: ERROR_HANDLER.Add_Error_Message(
7879: p_message_name => l_error_message_name
7880: ,p_application_id => G_App_Short_Name
7881: ,p_token_tbl => l_token_table
7882: ,p_message_type => G_RET_STS_ERROR

Line 7933: ERROR_HANDLER.Add_Error_Message(

7929: l_last_update_date := SYSDATE;
7930: l_last_update_login := g_login_id;
7931:
7932:
7933: ERROR_HANDLER.Add_Error_Message(
7934: p_message_name => l_error_message_name
7935: ,p_application_id => G_App_Short_Name
7936: ,p_token_tbl => l_token_table
7937: ,p_message_type => G_RET_STS_ERROR

Line 8062: ERROR_HANDLER.Add_Error_Message(

8058: l_last_update_date := SYSDATE;
8059: l_last_update_login := g_login_id;
8060:
8061:
8062: ERROR_HANDLER.Add_Error_Message(
8063: p_message_name => l_error_message_name
8064: ,p_application_id => G_App_Short_Name
8065: ,p_token_tbl => l_token_table
8066: ,p_message_type => G_RET_STS_ERROR

Line 8143: ERROR_HANDLER.Add_Error_Message(

8139: l_last_update_date := SYSDATE;
8140: l_last_update_login := g_login_id;
8141:
8142:
8143: ERROR_HANDLER.Add_Error_Message(
8144: p_message_name => l_error_message_name
8145: ,p_application_id => G_App_Short_Name
8146: ,p_token_tbl => l_token_table
8147: ,p_message_type => G_RET_STS_ERROR

Line 8208: ERROR_HANDLER.Add_Error_Message(

8204: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
8205: G_TOKEN_TBL(4).Token_Value := 'Get_Key_Value_Columns';
8206:
8207:
8208: ERROR_HANDLER.Add_Error_Message(
8209: p_message_name => 'EGO_ENTITY_API_FAILED'
8210: ,p_application_id => G_App_Short_Name
8211: ,p_token_tbl => G_TOKEN_TBL
8212: ,p_message_type => G_RET_STS_ERROR

Line 8244: ERROR_HANDLER.Add_Error_Message(

8240: l_last_update_date := SYSDATE;
8241: l_last_update_login := g_login_id;
8242:
8243:
8244: ERROR_HANDLER.Add_Error_Message(
8245: p_message_name => l_error_message_name
8246: ,p_application_id => G_App_Short_Name
8247: ,p_token_tbl => l_token_table
8248: ,p_message_type => G_RET_STS_ERROR

Line 8277: ERROR_HANDLER.Add_Error_Message(

8273: l_last_update_date := SYSDATE;
8274: l_last_update_login := g_login_id;
8275:
8276:
8277: ERROR_HANDLER.Add_Error_Message(
8278: p_message_name => l_error_message_name
8279: ,p_application_id => G_App_Short_Name
8280: ,p_token_tbl => l_token_table
8281: ,p_message_type => G_RET_STS_ERROR

Line 8305: ERROR_HANDLER.Add_Error_Message(

8301: l_error_message_name := 'EGO_VAL_KEY_REQ_ERR';
8302:
8303: --Dbms_Output.put_line( ' l_flex_value_meaning IS NULL OR l_disp_sequence IS NULL THEN ');
8304:
8305: ERROR_HANDLER.Add_Error_Message(
8306: p_message_name => l_error_message_name
8307: ,p_application_id => G_App_Short_Name
8308: ,p_token_tbl => l_token_table
8309: ,p_message_type => G_RET_STS_ERROR

Line 8379: ERROR_HANDLER.Add_Error_Message(

8375: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
8376: G_TOKEN_TBL(4).Token_Value := 'Create_Value_Set_Val';
8377:
8378:
8379: ERROR_HANDLER.Add_Error_Message(
8380: p_message_name => 'EGO_ENTITY_API_FAILED'
8381: ,p_application_id => G_App_Short_Name
8382: ,p_token_tbl => G_TOKEN_TBL
8383: ,p_message_type => G_RET_STS_ERROR

Line 8568: ERROR_HANDLER.Add_Error_Message(

8564: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
8565: G_TOKEN_TBL(4).Token_Value := 'Update_Value_Set_Val';
8566:
8567:
8568: ERROR_HANDLER.Add_Error_Message(
8569: p_message_name => 'EGO_ENTITY_API_FAILED'
8570: ,p_application_id => G_App_Short_Name
8571: ,p_token_tbl => G_TOKEN_TBL
8572: ,p_message_type => G_RET_STS_ERROR

Line 8764: ERROR_HANDLER.Add_Error_Message(

8760:
8761: l_error_message_name := 'EGO_BASE_LANG_REC_REQ';
8762:
8763:
8764: ERROR_HANDLER.Add_Error_Message(
8765: p_message_name => l_error_message_name
8766: ,p_application_id => G_App_Short_Name
8767: ,p_token_tbl => l_token_table
8768: ,p_message_type => G_RET_STS_ERROR

Line 8813: ERROR_HANDLER.Add_Error_Message(

8809:
8810: l_return_status := G_RET_STS_ERROR;
8811: l_error_message_name := 'EGO_BASE_LANG_REC_REQ';
8812:
8813: ERROR_HANDLER.Add_Error_Message(
8814: p_message_name => l_error_message_name
8815: ,p_application_id => G_App_Short_Name
8816: ,p_token_tbl => l_token_table
8817: ,p_message_type => G_RET_STS_ERROR

Line 9073: l_token_table ERROR_HANDLER.Token_Tbl_Type;

9069: l_is_versioned VARCHAR2(20):=NULL;
9070: l_api_mode NUMBER := G_FLOW_TYPE;
9071: l_validation_code VARCHAR2(10);
9072: l_format_code VARCHAR2(10);
9073: l_token_table ERROR_HANDLER.Token_Tbl_Type;
9074: l_application_id NUMBER;
9075:
9076: l_return_status VARCHAR2(1) := NULL;
9077:

Line 9142: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_VS);

9138:
9139: -- Get Application Id
9140: --G_Application_Id := Get_Application_Id();
9141:
9142: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_VS);
9143:
9144:
9145: --==============================
9146: -- Process values, only values passed

Line 9207: ERROR_HANDLER.Add_Error_Message(

9203: l_last_update_login := g_login_id;
9204:
9205:
9206:
9207: ERROR_HANDLER.Add_Error_Message(
9208: p_message_name => l_error_message_name
9209: ,p_application_id => G_App_Short_Name
9210: ,p_token_tbl => l_token_table
9211: ,p_message_type => G_RET_STS_ERROR

Line 9259: ERROR_HANDLER.Add_Error_Message(

9255: l_last_update_login := g_login_id;
9256:
9257:
9258:
9259: ERROR_HANDLER.Add_Error_Message(
9260: p_message_name => l_error_message_name
9261: ,p_application_id => G_App_Short_Name
9262: ,p_token_tbl => l_token_table
9263: ,p_message_type => G_RET_STS_ERROR

Line 9347: ERROR_HANDLER.Add_Error_Message(

9343: l_token_table(2).TOKEN_NAME := 'VALUE_SET_ID';
9344: l_token_table(2).TOKEN_VALUE := l_value_set_name;
9345:
9346:
9347: ERROR_HANDLER.Add_Error_Message(
9348: p_message_name => l_error_message_name
9349: ,p_application_id => G_App_Short_Name
9350: ,p_token_tbl => l_token_table
9351: ,p_message_type => G_RET_STS_ERROR

Line 9377: ERROR_HANDLER.Add_Error_Message(

9373: l_token_table(2).TOKEN_NAME := 'FLEX_VALUE_ID';
9374: l_token_table(2).TOKEN_VALUE := l_flex_value_id;
9375:
9376:
9377: ERROR_HANDLER.Add_Error_Message(
9378: p_message_name => l_error_message_name
9379: ,p_application_id => G_App_Short_Name
9380: ,p_token_tbl => l_token_table
9381: ,p_message_type => G_RET_STS_ERROR

Line 9435: ERROR_HANDLER.Add_Error_Message(

9431: l_last_update_login := g_login_id;
9432:
9433: l_error_message_name := 'EGO_EF_VAL_SEQ_ERR';
9434:
9435: ERROR_HANDLER.Add_Error_Message(
9436: p_message_name => l_error_message_name
9437: ,p_application_id => G_App_Short_Name
9438: ,p_token_tbl => l_token_table
9439: ,p_message_type => G_RET_STS_ERROR

Line 9464: ERROR_HANDLER.Add_Error_Message(

9460:
9461:
9462: l_error_message_name := 'EGO_EF_VAL_INT_NAME_EXIST';
9463:
9464: ERROR_HANDLER.Add_Error_Message(
9465: p_message_name => l_error_message_name
9466: ,p_application_id => G_App_Short_Name
9467: ,p_token_tbl => l_token_table
9468: ,p_message_type => G_RET_STS_ERROR

Line 9501: ERROR_HANDLER.Add_Error_Message(

9497: l_error_message_name := 'EGO_VALUE_VALIDATION_ERROR';
9498: l_token_table(1).TOKEN_NAME := 'VALUE_SET_NAME';
9499: l_token_table(1).TOKEN_VALUE := l_value_set_name;
9500:
9501: ERROR_HANDLER.Add_Error_Message(
9502: p_message_name => l_error_message_name
9503: ,p_application_id => G_App_Short_Name
9504: ,p_token_tbl => l_token_table
9505: ,p_message_type => G_RET_STS_ERROR

Line 9535: ERROR_HANDLER.Add_Error_Message(

9531: l_last_update_date := SYSDATE;
9532: l_last_update_login := g_login_id;
9533:
9534:
9535: ERROR_HANDLER.Add_Error_Message(
9536: p_message_name => l_error_message_name
9537: ,p_application_id => G_App_Short_Name
9538: ,p_token_tbl => l_token_table
9539: ,p_message_type => G_RET_STS_ERROR

Line 9571: ERROR_HANDLER.Add_Error_Message(

9567: l_last_update_date := SYSDATE;
9568: l_last_update_login := g_login_id;
9569:
9570:
9571: ERROR_HANDLER.Add_Error_Message(
9572: p_message_name => l_error_message_name
9573: ,p_application_id => G_App_Short_Name
9574: ,p_token_tbl => l_token_table
9575: ,p_message_type => G_RET_STS_ERROR

Line 9603: ERROR_HANDLER.Add_Error_Message(

9599:
9600:
9601: l_error_message_name := 'EGO_VAL_TRANS_DISP_ERR';
9602:
9603: ERROR_HANDLER.Add_Error_Message(
9604: p_message_name => l_error_message_name
9605: ,p_application_id => G_App_Short_Name
9606: ,p_token_tbl => l_token_table
9607: ,p_message_type => G_RET_STS_ERROR

Line 9640: ERROR_HANDLER.Add_Error_Message(

9636: IF l_flex_value_meaning IS NULL OR l_disp_sequence IS NULL OR l_enabled_flag IS NULL THEN
9637:
9638: l_error_message_name := 'EGO_VAL_KEY_REQ_ERR';
9639:
9640: ERROR_HANDLER.Add_Error_Message(
9641: p_message_name => l_error_message_name
9642: ,p_application_id => G_App_Short_Name
9643: ,p_token_tbl => l_token_table
9644: ,p_message_type => G_RET_STS_ERROR

Line 9684: ERROR_HANDLER.Add_Error_Message(

9680: l_last_update_date := SYSDATE;
9681: l_last_update_login := g_login_id;
9682:
9683:
9684: ERROR_HANDLER.Add_Error_Message(
9685: p_message_name => l_error_message_name
9686: ,p_application_id => G_App_Short_Name
9687: ,p_token_tbl => l_token_table
9688: ,p_message_type => G_RET_STS_ERROR

Line 9760: ERROR_HANDLER.Add_Error_Message(

9756: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
9757: G_TOKEN_TBL(4).Token_Value := 'Update_Value_Set_Val';
9758:
9759:
9760: ERROR_HANDLER.Add_Error_Message(
9761: p_message_name => 'EGO_ENTITY_API_FAILED'
9762: ,p_application_id => G_App_Short_Name
9763: ,p_token_tbl => G_TOKEN_TBL
9764: ,p_message_type => G_RET_STS_ERROR

Line 9937: ERROR_HANDLER.Add_Error_Message(

9933: l_last_update_login := g_login_id;
9934:
9935:
9936:
9937: ERROR_HANDLER.Add_Error_Message(
9938: p_message_name => l_error_message_name
9939: ,p_application_id => G_App_Short_Name
9940: ,p_token_tbl => l_token_table
9941: ,p_message_type => G_RET_STS_ERROR

Line 9990: ERROR_HANDLER.Add_Error_Message(

9986: l_last_update_login := g_login_id;
9987:
9988:
9989:
9990: ERROR_HANDLER.Add_Error_Message(
9991: p_message_name => l_error_message_name
9992: ,p_application_id => G_App_Short_Name
9993: ,p_token_tbl => l_token_table
9994: ,p_message_type => G_RET_STS_ERROR

Line 10081: ERROR_HANDLER.Add_Error_Message(

10077: l_token_table(2).TOKEN_NAME := 'VALUE_SET_ID';
10078: l_token_table(2).TOKEN_VALUE := l_value_set_name;
10079:
10080:
10081: ERROR_HANDLER.Add_Error_Message(
10082: p_message_name => l_error_message_name
10083: ,p_application_id => G_App_Short_Name
10084: ,p_token_tbl => l_token_table
10085: ,p_message_type => G_RET_STS_ERROR

Line 10111: ERROR_HANDLER.Add_Error_Message(

10107: l_token_table(2).TOKEN_NAME := 'FLEX_VALUE_ID';
10108: l_token_table(2).TOKEN_VALUE := l_flex_value_id;
10109:
10110:
10111: ERROR_HANDLER.Add_Error_Message(
10112: p_message_name => l_error_message_name
10113: ,p_application_id => G_App_Short_Name
10114: ,p_token_tbl => l_token_table
10115: ,p_message_type => G_RET_STS_ERROR

Line 10161: ERROR_HANDLER.Add_Error_Message(

10157:
10158:
10159: l_error_message_name := 'EGO_EF_VAL_INT_NAME_EXIST';
10160:
10161: ERROR_HANDLER.Add_Error_Message(
10162: p_message_name => l_error_message_name
10163: ,p_application_id => G_App_Short_Name
10164: ,p_token_tbl => l_token_table
10165: ,p_message_type => G_RET_STS_ERROR

Line 10199: ERROR_HANDLER.Add_Error_Message(

10195: l_error_message_name := 'EGO_VALUE_VALIDATION_ERROR';
10196: l_token_table(1).TOKEN_NAME := 'VALUE_SET_NAME';
10197: l_token_table(1).TOKEN_VALUE := l_value_set_name;
10198:
10199: ERROR_HANDLER.Add_Error_Message(
10200: p_message_name => l_error_message_name
10201: ,p_application_id => G_App_Short_Name
10202: ,p_token_tbl => l_token_table
10203: ,p_message_type => G_RET_STS_ERROR

Line 10226: ERROR_HANDLER.Add_Error_Message(

10222:
10223:
10224: l_error_message_name := 'EGO_VAL_TRANS_DISP_ERR';
10225:
10226: ERROR_HANDLER.Add_Error_Message(
10227: p_message_name => l_error_message_name
10228: ,p_application_id => G_App_Short_Name
10229: ,p_token_tbl => l_token_table
10230: ,p_message_type => G_RET_STS_ERROR

Line 10259: ERROR_HANDLER.Add_Error_Message(

10255: l_last_update_date := SYSDATE;
10256: l_last_update_login := g_login_id;
10257:
10258:
10259: ERROR_HANDLER.Add_Error_Message(
10260: p_message_name => l_error_message_name
10261: ,p_application_id => G_App_Short_Name
10262: ,p_token_tbl => l_token_table
10263: ,p_message_type => G_RET_STS_ERROR

Line 10304: ERROR_HANDLER.Add_Error_Message(

10300:
10301: l_error_message_name := 'EGO_VAL_KEY_REQ_ERR';
10302: --Dbms_Output.put_line( ' UP: l_flex_value_meaning IS NULL OR l_disp_sequence IS NULL THEN ');
10303:
10304: ERROR_HANDLER.Add_Error_Message(
10305: p_message_name => l_error_message_name
10306: ,p_application_id => G_App_Short_Name
10307: ,p_token_tbl => l_token_table
10308: ,p_message_type => G_RET_STS_ERROR

Line 10385: ERROR_HANDLER.Add_Error_Message(

10381: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
10382: G_TOKEN_TBL(4).Token_Value := 'Update_Value_Set_Val';
10383:
10384:
10385: ERROR_HANDLER.Add_Error_Message(
10386: p_message_name => 'EGO_ENTITY_API_FAILED'
10387: ,p_application_id => G_App_Short_Name
10388: ,p_token_tbl => G_TOKEN_TBL
10389: ,p_message_type => G_RET_STS_ERROR

Line 10617: l_token_table ERROR_HANDLER.Token_Tbl_Type;

10613: /* Local variable to be used in error handling mechanism*/
10614: l_entity_code VARCHAR2(40) := G_ENTITY_CHILD_VS;
10615: l_table_name VARCHAR2(240):= G_ENTITY_VS_HEADER_TAB;
10616:
10617: l_token_table ERROR_HANDLER.Token_Tbl_Type;
10618: l_application_id NUMBER := G_Application_Id;
10619: l_error_message_name VARCHAR2(500);
10620: l_return_msg VARCHAR2(1000);
10621: --l_error_row_identifier NUMBER;

Line 10684: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_VS);

10680: l_child_vs_value_ids := EGO_EXT_FWK_PUB.EGO_VALUE_SET_VALUE_IDS();
10681: -- Get Application Id
10682: --G_Application_Id := Get_Application_Id();
10683:
10684: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_VS);
10685:
10686:
10687:
10688:

Line 10765: ERROR_HANDLER.Add_Error_Message(

10761: l_last_update_login := g_login_id;
10762:
10763:
10764:
10765: ERROR_HANDLER.Add_Error_Message(
10766: p_message_name => l_error_message_name
10767: ,p_application_id => G_App_Short_Name
10768: ,p_token_tbl => l_token_table
10769: ,p_message_type => G_RET_STS_ERROR

Line 10828: ERROR_HANDLER.Add_Error_Message(

10824:
10825:
10826:
10827:
10828: ERROR_HANDLER.Add_Error_Message(
10829: p_message_name => l_error_message_name
10830: ,p_application_id => G_App_Short_Name
10831: ,p_token_tbl => l_token_table
10832: ,p_message_type => G_RET_STS_ERROR

Line 10859: ERROR_HANDLER.Add_Error_Message(

10855:
10856:
10857:
10858:
10859: ERROR_HANDLER.Add_Error_Message(
10860: p_message_name => l_error_message_name
10861: ,p_application_id => G_App_Short_Name
10862: ,p_token_tbl => l_token_table
10863: ,p_message_type => G_RET_STS_ERROR

Line 10922: ERROR_HANDLER.Add_Error_Message(

10918: l_return_status := G_RET_STS_ERROR;
10919: l_error_message_name := 'EGO_CHILD_VS_INVALID_PARENT';
10920:
10921:
10922: ERROR_HANDLER.Add_Error_Message(
10923: p_message_name => l_error_message_name
10924: ,p_application_id => G_App_Short_Name
10925: ,p_token_tbl => l_token_table
10926: ,p_message_type => G_RET_STS_ERROR

Line 10988: ERROR_HANDLER.Add_Error_Message(

10984: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
10985: G_TOKEN_TBL(4).Token_Value := 'Get_Key_VS_Columns';
10986:
10987:
10988: ERROR_HANDLER.Add_Error_Message(
10989: p_message_name => 'EGO_ENTITY_API_FAILED'
10990: ,p_application_id => G_App_Short_Name
10991: ,p_token_tbl => G_TOKEN_TBL
10992: ,p_message_type => G_RET_STS_ERROR

Line 11079: ERROR_HANDLER.Add_Error_Message(

11075: p_valueset_val_tab(j).process_status := G_ERROR_RECORD;
11076: p_valueset_val_tab(j).transaction_type := l_transaction_type;
11077: l_error_message_name := 'EGO_CHILD_VS_CREATION_FAILED';
11078:
11079: ERROR_HANDLER.Add_Error_Message(
11080: p_message_name => l_error_message_name
11081: ,p_application_id => G_App_Short_Name
11082: ,p_token_tbl => l_token_table
11083: ,p_message_type => G_RET_STS_ERROR

Line 11108: ERROR_HANDLER.Add_Error_Message(

11104: l_last_update_login := g_login_id;
11105:
11106:
11107:
11108: ERROR_HANDLER.Add_Error_Message(
11109: p_message_name => l_error_message_name
11110: ,p_application_id => G_App_Short_Name
11111: ,p_token_tbl => l_token_table
11112: ,p_message_type => G_RET_STS_ERROR

Line 11142: ERROR_HANDLER.Add_Error_Message(

11138: l_last_update_login := g_login_id;
11139:
11140: l_error_message_name := 'EGO_VS_VAL_INVALID_SEQ';
11141:
11142: ERROR_HANDLER.Add_Error_Message(
11143: p_message_name => l_error_message_name
11144: ,p_application_id => G_App_Short_Name
11145: ,p_token_tbl => l_token_table
11146: ,p_message_type => G_RET_STS_ERROR

Line 11180: ERROR_HANDLER.Add_Error_Message(

11176: p_valueset_val_tab(j).process_status := G_ERROR_RECORD;
11177: p_valueset_val_tab(j).transaction_type := l_transaction_type;
11178: l_error_message_name := 'EGO_CHILD_VS_CREATION_FAILED';
11179:
11180: ERROR_HANDLER.Add_Error_Message(
11181: p_message_name => l_error_message_name
11182: ,p_application_id => G_App_Short_Name
11183: ,p_token_tbl => l_token_table
11184: ,p_message_type => G_RET_STS_ERROR

Line 11297: ERROR_HANDLER.Add_Error_Message(

11293: l_token_table(1).TOKEN_NAME := 'VALUE_SET_NAME';
11294: l_token_table(1).TOKEN_VALUE := l_value_set_name;
11295:
11296:
11297: ERROR_HANDLER.Add_Error_Message(
11298: p_message_name => l_error_message_name
11299: ,p_application_id => G_App_Short_Name
11300: ,p_token_tbl => l_token_table
11301: ,p_message_type => G_RET_STS_ERROR

Line 11409: ERROR_HANDLER.Add_Error_Message (

11405: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
11406: G_TOKEN_TBL(4).Token_Value := 'Create_Child_Value_Set';
11407:
11408:
11409: ERROR_HANDLER.Add_Error_Message (
11410: p_message_name => 'EGO_ENTITY_API_FAILED'
11411: ,p_application_id => G_App_Short_Name
11412: ,p_token_tbl => G_TOKEN_TBL
11413: ,p_message_type => G_RET_STS_ERROR

Line 11458: ERROR_HANDLER.Add_Error_Message(

11454: l_token_table(1).TOKEN_NAME := 'VALUE_SET_NAME';
11455: l_token_table(1).TOKEN_VALUE := l_value_set_name;
11456:
11457:
11458: ERROR_HANDLER.Add_Error_Message(
11459: p_message_name => l_error_message_name
11460: ,p_application_id => G_App_Short_Name
11461: ,p_token_tbl => l_token_table
11462: ,p_message_type => G_RET_STS_ERROR

Line 11514: ERROR_HANDLER.Add_Error_Message(

11510: p_valueset_val_tab(j).process_status := G_ERROR_RECORD;
11511: p_valueset_val_tab(j).transaction_type := l_transaction_type;
11512: l_error_message_name := 'EGO_CHILD_VS_CREATION_FAILED';
11513:
11514: ERROR_HANDLER.Add_Error_Message(
11515: p_message_name => l_error_message_name
11516: ,p_application_id => G_App_Short_Name
11517: ,p_token_tbl => l_token_table
11518: ,p_message_type => G_RET_STS_ERROR

Line 11544: ERROR_HANDLER.Add_Error_Message(

11540: l_last_update_login := g_login_id;
11541:
11542:
11543:
11544: ERROR_HANDLER.Add_Error_Message(
11545: p_message_name => l_error_message_name
11546: ,p_application_id => G_App_Short_Name
11547: ,p_token_tbl => l_token_table
11548: ,p_message_type => G_RET_STS_ERROR

Line 11573: ERROR_HANDLER.Add_Error_Message(

11569: p_valueset_val_tab(j).process_status := G_ERROR_RECORD;
11570: p_valueset_val_tab(j).transaction_type := l_transaction_type;
11571: l_error_message_name := 'EGO_CHILD_VS_CREATION_FAILED';
11572:
11573: ERROR_HANDLER.Add_Error_Message(
11574: p_message_name => l_error_message_name
11575: ,p_application_id => G_App_Short_Name
11576: ,p_token_tbl => l_token_table
11577: ,p_message_type => G_RET_STS_ERROR

Line 11694: ERROR_HANDLER.Add_Error_Message(

11690: l_token_table(2).TOKEN_NAME := 'VALUE_SET_ID';
11691: l_token_table(2).TOKEN_VALUE := l_value_set_name;
11692:
11693:
11694: ERROR_HANDLER.Add_Error_Message(
11695: p_message_name => l_error_message_name
11696: ,p_application_id => G_App_Short_Name
11697: ,p_token_tbl => l_token_table
11698: ,p_message_type => G_RET_STS_ERROR

Line 11785: ERROR_HANDLER.Add_Error_Message(

11781: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
11782: G_TOKEN_TBL(4).Token_Value := 'Update_Child_Value_Set';
11783:
11784:
11785: ERROR_HANDLER.Add_Error_Message(
11786: p_message_name => 'EGO_ENTITY_API_FAILED'
11787: ,p_application_id => G_App_Short_Name
11788: ,p_token_tbl => G_TOKEN_TBL
11789: ,p_message_type => G_RET_STS_ERROR

Line 11837: ERROR_HANDLER.Add_Error_Message(

11833: l_token_table(1).TOKEN_NAME := 'VALUE_SET_NAME';
11834: l_token_table(1).TOKEN_VALUE := l_value_set_name;
11835:
11836:
11837: ERROR_HANDLER.Add_Error_Message(
11838: p_message_name => l_error_message_name
11839: ,p_application_id => G_App_Short_Name
11840: ,p_token_tbl => l_token_table
11841: ,p_message_type => G_RET_STS_ERROR