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_USER_ATTRS_DATA_PVT dependencies on FND_API

Line 271: RAISE FND_API.G_EXC_ERROR;

267: RETURN l_data_level_id;
268: EXCEPTION
269: WHEN OTHERS THEN
270: Debug_Msg('Failed Get_Data_Level_Id-'||SQLERRM,0);
271: RAISE FND_API.G_EXC_ERROR;
272: END Get_Data_Level_Id;
273: ---------------------------------------------------------------------
274:
275: --

Line 324: x_name_value_pair_valid := FND_API.G_FALSE;

320: EXCEPTION
321: WHEN OTHERS THEN
322: Debug_Msg(l_api_name || ' EXCEPTION '||SQLERRM,1);
323: x_data_level_id := NULL;
324: x_name_value_pair_valid := FND_API.G_FALSE;
325: END;
326: l_name_value_pair_valid := FALSE;
327: IF x_data_level_id IS NOT NULL THEN
328: -- if the pk's passed satisfy this data_level, call Perform_DML_On_Template_Row

Line 377: x_name_value_pair_valid := FND_API.G_TRUE;

373:
374: Debug_Msg(l_api_name || ' 106 ',1);
375: IF l_name_value_pair_valid THEN
376: Debug_Msg(l_api_name || ' 107 ',1);
377: x_name_value_pair_valid := FND_API.G_TRUE;
378: ELSE
379: Debug_Msg(l_api_name || ' 108 ',1);
380: x_name_value_pair_valid := FND_API.G_FALSE;
381: END IF;

Line 380: x_name_value_pair_valid := FND_API.G_FALSE;

376: Debug_Msg(l_api_name || ' 107 ',1);
377: x_name_value_pair_valid := FND_API.G_TRUE;
378: ELSE
379: Debug_Msg(l_api_name || ' 108 ',1);
380: x_name_value_pair_valid := FND_API.G_FALSE;
381: END IF;
382:
383: END Is_Name_Value_Pairs_Valid;
384:

Line 924: FND_API.TO_BOOLEAN(

920: --support have been taken up.
921: ----------------------------------------------------------------------------
922: IF(p_data_level IS NOT NULL
923: AND
924: FND_API.TO_BOOLEAN(
925: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => p_attr_group_metadata_obj.ext_table_vl_name
926: ,p_column_name => 'DATA_LEVEL_ID'
927: )
928: )

Line 2199: FND_API.TO_BOOLEAN(

2195: -- support for data level p_data_level would be passed in. --
2196: --------------------------------------------------------------
2197: IF(p_data_level IS NOT NULL
2198: AND
2199: FND_API.TO_BOOLEAN(
2200: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => p_attr_group_metadata_obj.ext_table_vl_name
2201: ,p_column_name => 'DATA_LEVEL_ID'
2202: )
2203: )

Line 2318: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

2314: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2315: ,p_entity_id IN VARCHAR2
2316: ,p_entity_index IN NUMBER
2317: ,p_entity_code IN VARCHAR2
2318: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2319: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
2320: ,p_is_disp_to_int_query IN BOOLEAN
2321: ,p_final_bind_value IN VARCHAR2
2322: ,p_return_bound_sql IN BOOLEAN DEFAULT FALSE

Line 2462: ,p_message_type => FND_API.G_RET_STS_ERROR

2458: ERROR_HANDLER.Add_Error_Message(
2459: p_message_name => l_error_message_name
2460: ,p_application_id => 'EGO'
2461: ,p_token_tbl => l_token_table
2462: ,p_message_type => FND_API.G_RET_STS_ERROR
2463: ,p_row_identifier => G_USER_ROW_IDENTIFIER
2464: ,p_entity_id => p_entity_id
2465: ,p_entity_index => p_entity_index
2466: ,p_entity_code => p_entity_code

Line 2470: RAISE FND_API.G_EXC_ERROR;

2466: ,p_entity_code => p_entity_code
2467: ,p_addto_fnd_stack => p_add_errors_to_fnd_stack
2468: );
2469:
2470: RAISE FND_API.G_EXC_ERROR;
2471: END IF;
2472:
2473: ------------------------------------
2474: -- Otherwise, we have an AG token --

Line 2506: ,p_message_type => FND_API.G_RET_STS_ERROR

2502: ERROR_HANDLER.Add_Error_Message(
2503: p_message_name => l_error_message_name
2504: ,p_application_id => 'EGO'
2505: ,p_token_tbl => l_token_table
2506: ,p_message_type => FND_API.G_RET_STS_ERROR
2507: ,p_row_identifier => G_USER_ROW_IDENTIFIER
2508: ,p_entity_id => p_entity_id
2509: ,p_entity_index => p_entity_index
2510: ,p_entity_code => p_entity_code

Line 2514: RAISE FND_API.G_EXC_ERROR;

2510: ,p_entity_code => p_entity_code
2511: ,p_addto_fnd_stack => p_add_errors_to_fnd_stack
2512: );
2513:
2514: RAISE FND_API.G_EXC_ERROR;
2515:
2516: ELSE
2517:
2518: IF (p_return_bound_sql) THEN

Line 3778: ,p_message_type => FND_API.G_RET_STS_ERROR

3774: ERROR_HANDLER.Add_Error_Message(
3775: p_message_name => l_error_message_name
3776: ,p_application_id => 'EGO'
3777: ,p_token_tbl => l_token_table
3778: ,p_message_type => FND_API.G_RET_STS_ERROR
3779: ,p_row_identifier => G_USER_ROW_IDENTIFIER
3780: ,p_entity_id => p_entity_id
3781: ,p_entity_index => p_entity_index
3782: ,p_entity_code => p_entity_code

Line 3786: RAISE FND_API.G_EXC_ERROR;

3782: ,p_entity_code => p_entity_code
3783: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
3784: );
3785:
3786: RAISE FND_API.G_EXC_ERROR;
3787: ELSIF (x_extension_id IS NULL) THEN
3788: --------------------------------------------------------------------
3789: -- If there was no error and we don't yet have the ext ID, set it --
3790: -- based on the table on which the user is trying to perform DML --

Line 3831: ,p_message_type => FND_API.G_RET_STS_ERROR

3827: ERROR_HANDLER.Add_Error_Message(
3828: p_message_name => l_error_message_name
3829: ,p_application_id => 'EGO'
3830: ,p_token_tbl => l_token_table
3831: ,p_message_type => FND_API.G_RET_STS_ERROR
3832: ,p_row_identifier => G_USER_ROW_IDENTIFIER
3833: ,p_entity_id => p_entity_id
3834: ,p_entity_index => p_entity_index
3835: ,p_entity_code => p_entity_code

Line 3839: RAISE FND_API.G_EXC_ERROR;

3835: ,p_entity_code => p_entity_code
3836: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
3837: );
3838:
3839: RAISE FND_API.G_EXC_ERROR;
3840:
3841: ELSIF (x_extension_id IS NOT NULL AND
3842: x_mode = G_CREATE_MODE AND
3843: (NOT l_is_change_case OR p_change_obj.ACD_TYPE = 'ADD')) THEN

Line 3854: ,p_message_type => FND_API.G_RET_STS_ERROR

3850: ERROR_HANDLER.Add_Error_Message(
3851: p_message_name => l_error_message_name
3852: ,p_application_id => 'EGO'
3853: ,p_token_tbl => l_token_table
3854: ,p_message_type => FND_API.G_RET_STS_ERROR
3855: ,p_row_identifier => G_USER_ROW_IDENTIFIER
3856: ,p_entity_id => p_entity_id
3857: ,p_entity_index => p_entity_index
3858: ,p_entity_code => p_entity_code

Line 3862: RAISE FND_API.G_EXC_ERROR;

3858: ,p_entity_code => p_entity_code
3859: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
3860: );
3861:
3862: RAISE FND_API.G_EXC_ERROR;
3863:
3864: END IF;
3865:
3866: ----------------------------------------------------------------------

Line 3894: ,p_message_type => FND_API.G_RET_STS_ERROR

3890: ERROR_HANDLER.Add_Error_Message(
3891: p_message_name => l_error_message_name
3892: ,p_application_id => 'EGO'
3893: ,p_token_tbl => l_token_table
3894: ,p_message_type => FND_API.G_RET_STS_ERROR
3895: ,p_row_identifier => G_USER_ROW_IDENTIFIER
3896: ,p_entity_id => p_entity_id
3897: ,p_entity_index => p_entity_index
3898: ,p_entity_code => p_entity_code

Line 3902: RAISE FND_API.G_EXC_ERROR;

3898: ,p_entity_code => p_entity_code
3899: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
3900: );
3901:
3902: RAISE FND_API.G_EXC_ERROR;
3903:
3904: END IF;
3905: Debug_Msg('In Get_Extension_Id_And_Mode, done', 2);
3906:

Line 3908: WHEN FND_API.G_EXC_ERROR THEN

3904: END IF;
3905: Debug_Msg('In Get_Extension_Id_And_Mode, done', 2);
3906:
3907: EXCEPTION
3908: WHEN FND_API.G_EXC_ERROR THEN
3909: Debug_Msg(' Get_Extension_Id_And_Mode EXCEPTION FND_API.G_EXC_ERROR ');
3910: x_return_status := FND_API.G_RET_STS_ERROR;
3911:
3912: WHEN OTHERS THEN

Line 3909: Debug_Msg(' Get_Extension_Id_And_Mode EXCEPTION FND_API.G_EXC_ERROR ');

3905: Debug_Msg('In Get_Extension_Id_And_Mode, done', 2);
3906:
3907: EXCEPTION
3908: WHEN FND_API.G_EXC_ERROR THEN
3909: Debug_Msg(' Get_Extension_Id_And_Mode EXCEPTION FND_API.G_EXC_ERROR ');
3910: x_return_status := FND_API.G_RET_STS_ERROR;
3911:
3912: WHEN OTHERS THEN
3913:

Line 3910: x_return_status := FND_API.G_RET_STS_ERROR;

3906:
3907: EXCEPTION
3908: WHEN FND_API.G_EXC_ERROR THEN
3909: Debug_Msg(' Get_Extension_Id_And_Mode EXCEPTION FND_API.G_EXC_ERROR ');
3910: x_return_status := FND_API.G_RET_STS_ERROR;
3911:
3912: WHEN OTHERS THEN
3913:
3914: Debug_Msg(' Get_Extension_Id_And_Mode EXCEPTION OTHERS '||SQLERRM);

Line 3915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3911:
3912: WHEN OTHERS THEN
3913:
3914: Debug_Msg(' Get_Extension_Id_And_Mode EXCEPTION OTHERS '||SQLERRM);
3915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3916:
3917: l_token_table.DELETE();
3918: l_token_table(1).TOKEN_NAME := 'PKG_NAME';
3919: l_token_table(1).TOKEN_VALUE := G_PKG_NAME;

Line 3929: ,p_message_type => FND_API.G_RET_STS_ERROR

3925: ERROR_HANDLER.Add_Error_Message(
3926: p_message_name => 'EGO_PLSQL_ERR'
3927: ,p_application_id => 'EGO'
3928: ,p_token_tbl => l_token_table
3929: ,p_message_type => FND_API.G_RET_STS_ERROR
3930: ,p_row_identifier => G_USER_ROW_IDENTIFIER
3931: ,p_entity_id => p_entity_id
3932: ,p_entity_index => p_entity_index
3933: ,p_entity_code => p_entity_code

Line 3989: ,p_message_type => FND_API.G_RET_STS_ERROR

3985: ERROR_HANDLER.Add_Error_Message(
3986: p_message_name => 'EGO_EF_ATTR_DOES_NOT_EXIST'
3987: ,p_application_id => 'EGO'
3988: ,p_token_tbl => l_token_table
3989: ,p_message_type => FND_API.G_RET_STS_ERROR
3990: ,p_row_identifier => G_USER_ROW_IDENTIFIER
3991: ,p_entity_id => p_entity_id
3992: ,p_entity_index => p_entity_index
3993: ,p_entity_code => p_entity_code

Line 5185: ,p_message_type => FND_API.G_RET_STS_ERROR

5181: ERROR_HANDLER.Add_Error_Message(
5182: p_message_name => l_err_msg_name
5183: ,p_application_id => 'EGO'
5184: ,p_token_tbl => l_token_table
5185: ,p_message_type => FND_API.G_RET_STS_ERROR
5186: ,p_row_identifier => G_USER_ROW_IDENTIFIER
5187: ,p_entity_id => p_entity_id
5188: ,p_entity_index => p_entity_index
5189: ,p_entity_code => p_entity_code

Line 5319: ,p_message_type => FND_API.G_RET_STS_ERROR

5315: ERROR_HANDLER.Add_Error_Message(
5316: p_message_name => 'EGO_EF_NO_VAL_FOR_REQ_ATTR'
5317: ,p_application_id => 'EGO'
5318: ,p_token_tbl => l_token_table
5319: ,p_message_type => FND_API.G_RET_STS_ERROR
5320: ,p_row_identifier => G_USER_ROW_IDENTIFIER
5321: ,p_entity_id => p_entity_id
5322: ,p_entity_index => p_entity_index
5323: ,p_entity_code => p_entity_code

Line 5411: ,p_message_type => FND_API.G_RET_STS_ERROR

5407: ERROR_HANDLER.Add_Error_Message(
5408: p_message_name => 'EGO_EF_ATTR_DOES_NOT_EXIST'
5409: ,p_application_id => 'EGO'
5410: ,p_token_tbl => l_token_table
5411: ,p_message_type => FND_API.G_RET_STS_ERROR
5412: ,p_row_identifier => p_row_identifier
5413: ,p_entity_id => p_entity_id
5414: ,p_entity_index => p_entity_index
5415: ,p_entity_code => p_entity_code

Line 5531: x_return_status := FND_API.G_RET_STS_ERROR;

5527: l_token_table(2).TOKEN_VALUE := l_attr_metadata_obj.ATTR_DISP_NAME;
5528: l_token_table(3).TOKEN_NAME := 'AG_NAME';
5529: l_token_table(3).TOKEN_VALUE := p_attr_group_metadata_obj.ATTR_GROUP_DISP_NAME;
5530:
5531: x_return_status := FND_API.G_RET_STS_ERROR;
5532:
5533: END IF;
5534:
5535: -----------------------------------------------------------------------------------

Line 5556: x_return_status := FND_API.G_RET_STS_ERROR;

5552: l_token_table(3).TOKEN_VALUE := l_attr_metadata_obj.DATA_TYPE_MEANING;
5553: l_token_table(4).TOKEN_NAME := 'VALUE';
5554: l_token_table(4).TOKEN_VALUE := px_attr_name_value_pairs(l_attr_value_index).ATTR_DISP_VALUE;
5555:
5556: x_return_status := FND_API.G_RET_STS_ERROR;
5557:
5558:
5559: ------------------------------------------------------------------------------
5560: -- Finally, we check for the much less common case where the Attribute is a --

Line 5592: x_return_status := FND_API.G_RET_STS_ERROR;

5588: l_token_table(3).TOKEN_NAME := 'DATA_TYPE';
5589: l_token_table(3).TOKEN_VALUE := l_attr_metadata_obj.DATA_TYPE_MEANING;
5590: l_token_table(4).TOKEN_NAME := 'VALUE';
5591: l_token_table(4).TOKEN_VALUE := px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR;
5592: x_return_status := FND_API.G_RET_STS_ERROR;
5593: END;
5594: END IF;
5595:
5596: ----------------------------------------------------------------------------

Line 5608: ,p_message_type => FND_API.G_RET_STS_ERROR

5604: ERROR_HANDLER.Add_Error_Message(
5605: p_message_name => l_err_msg_name
5606: ,p_application_id => 'EGO'
5607: ,p_token_tbl => l_token_table
5608: ,p_message_type => FND_API.G_RET_STS_ERROR
5609: ,p_row_identifier => G_USER_ROW_IDENTIFIER
5610: ,p_entity_id => p_entity_id
5611: ,p_entity_index => p_entity_index
5612: ,p_entity_code => p_entity_code

Line 5856: IF(NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_STR,FND_API.G_MISS_CHAR)<>

5852: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
5853: p_attr_group_metadata_obj.attr_metadata_table
5854: ,l_attr_rec.attr_name );
5855: -- abedajna Bug 6134504 end
5856: IF(NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_STR,FND_API.G_MISS_CHAR)<>
5857: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_STR,FND_API.G_MISS_CHAR)) THEN
5858: l_attr_name_val.EXTEND();
5859: l_attr_rec.attr_value := px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_STR;
5860: l_attr_name_val(l_attr_name_val.LAST) := l_attr_rec;

Line 5857: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_STR,FND_API.G_MISS_CHAR)) THEN

5853: p_attr_group_metadata_obj.attr_metadata_table
5854: ,l_attr_rec.attr_name );
5855: -- abedajna Bug 6134504 end
5856: IF(NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_STR,FND_API.G_MISS_CHAR)<>
5857: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_STR,FND_API.G_MISS_CHAR)) THEN
5858: l_attr_name_val.EXTEND();
5859: l_attr_rec.attr_value := px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_STR;
5860: l_attr_name_val(l_attr_name_val.LAST) := l_attr_rec;
5861: ELSIF ( NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_NUM,FND_API.G_MISS_NUM)<>

Line 5861: ELSIF ( NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_NUM,FND_API.G_MISS_NUM)<>

5857: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_STR,FND_API.G_MISS_CHAR)) THEN
5858: l_attr_name_val.EXTEND();
5859: l_attr_rec.attr_value := px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_STR;
5860: l_attr_name_val(l_attr_name_val.LAST) := l_attr_rec;
5861: ELSIF ( NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_NUM,FND_API.G_MISS_NUM)<>
5862: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_NUM,FND_API.G_MISS_NUM))THEN
5863: l_attr_name_val.EXTEND();
5864: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_NUM);
5865: l_attr_name_val(l_attr_name_val.LAST) :=l_attr_rec;

Line 5862: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_NUM,FND_API.G_MISS_NUM))THEN

5858: l_attr_name_val.EXTEND();
5859: l_attr_rec.attr_value := px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_STR;
5860: l_attr_name_val(l_attr_name_val.LAST) := l_attr_rec;
5861: ELSIF ( NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_NUM,FND_API.G_MISS_NUM)<>
5862: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_NUM,FND_API.G_MISS_NUM))THEN
5863: l_attr_name_val.EXTEND();
5864: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_NUM);
5865: l_attr_name_val(l_attr_name_val.LAST) :=l_attr_rec;
5866: ELSIF (NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE,FND_API.G_MISS_DATE)<>

Line 5866: ELSIF (NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE,FND_API.G_MISS_DATE)<>

5862: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_NUM,FND_API.G_MISS_NUM))THEN
5863: l_attr_name_val.EXTEND();
5864: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_NUM);
5865: l_attr_name_val(l_attr_name_val.LAST) :=l_attr_rec;
5866: ELSIF (NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE,FND_API.G_MISS_DATE)<>
5867: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE,FND_API.G_MISS_DATE))THEN
5868: l_attr_name_val.EXTEND();
5869: -- l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
5870: -- abedajna Bug 6134504 begin

Line 5867: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE,FND_API.G_MISS_DATE))THEN

5863: l_attr_name_val.EXTEND();
5864: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_NUM);
5865: l_attr_name_val(l_attr_name_val.LAST) :=l_attr_rec;
5866: ELSIF (NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE,FND_API.G_MISS_DATE)<>
5867: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE,FND_API.G_MISS_DATE))THEN
5868: l_attr_name_val.EXTEND();
5869: -- l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
5870: -- abedajna Bug 6134504 begin
5871: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) then -- timestamp

Line 6042: ,p_message_type => FND_API.G_RET_STS_ERROR

6038: ERROR_HANDLER.Add_Error_Message(
6039: p_message_name => 'EGO_PLSQL_ERR'
6040: ,p_application_id => 'EGO'
6041: ,p_token_tbl => l_token_table
6042: ,p_message_type => FND_API.G_RET_STS_ERROR
6043: ,p_row_identifier => G_USER_ROW_IDENTIFIER
6044: ,p_entity_id => p_entity_id
6045: ,p_entity_index => p_entity_index
6046: ,p_entity_code => p_entity_code

Line 6096: ,p_message_type => FND_API.G_RET_STS_ERROR

6092: ERROR_HANDLER.Add_Error_Message(
6093: p_message_name => l_err_msg_name
6094: ,p_application_id => 'EGO'
6095: ,p_token_tbl => l_token_table
6096: ,p_message_type => FND_API.G_RET_STS_ERROR
6097: ,p_row_identifier => G_USER_ROW_IDENTIFIER
6098: ,p_entity_id => p_entity_id
6099: ,p_entity_index => p_entity_index
6100: ,p_entity_code => p_entity_code

Line 6104: RAISE FND_API.G_EXC_ERROR;

6100: ,p_entity_code => p_entity_code
6101: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
6102: );
6103:
6104: RAISE FND_API.G_EXC_ERROR;
6105:
6106: END IF;
6107:
6108: ---------------------------------------------------------------

Line 6125: ,p_message_type => FND_API.G_RET_STS_ERROR

6121: ERROR_HANDLER.Add_Error_Message(
6122: p_message_name => 'EGO_EF_EXT_TABLE_METADATA_ERR'
6123: ,p_application_id => 'EGO'
6124: ,p_token_tbl => l_token_table
6125: ,p_message_type => FND_API.G_RET_STS_ERROR
6126: ,p_row_identifier => G_USER_ROW_IDENTIFIER
6127: ,p_entity_id => p_entity_id
6128: ,p_entity_index => p_entity_index
6129: ,p_entity_code => p_entity_code

Line 6132: RAISE FND_API.G_EXC_ERROR;

6128: ,p_entity_index => p_entity_index
6129: ,p_entity_code => p_entity_code
6130: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
6131: );
6132: RAISE FND_API.G_EXC_ERROR;
6133: END IF;
6134:
6135: IF (NOT Are_Ext_Table_Col_Names_Right(l_ext_table_metadata_obj
6136: ,p_pk_column_name_value_pairs

Line 6145: ,p_message_type => FND_API.G_RET_STS_ERROR

6141: ERROR_HANDLER.Add_Error_Message(
6142: p_message_name => l_err_msg_name
6143: ,p_application_id => 'EGO'
6144: ,p_token_tbl => l_token_table
6145: ,p_message_type => FND_API.G_RET_STS_ERROR
6146: ,p_row_identifier => G_USER_ROW_IDENTIFIER
6147: ,p_entity_id => p_entity_id
6148: ,p_entity_index => p_entity_index
6149: ,p_entity_code => p_entity_code

Line 6152: RAISE FND_API.G_EXC_ERROR;

6148: ,p_entity_index => p_entity_index
6149: ,p_entity_code => p_entity_code
6150: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
6151: );
6152: RAISE FND_API.G_EXC_ERROR;
6153: END IF;
6154:
6155: -----------------------------------------------------------------------------
6156: -- Next, we check that the Primary Key column array has at least one value --

Line 6217: ,p_message_type => FND_API.G_RET_STS_ERROR

6213: ERROR_HANDLER.Add_Error_Message(
6214: p_message_name => l_err_msg_name
6215: ,p_application_id => 'EGO'
6216: ,p_token_tbl => l_token_table
6217: ,p_message_type => FND_API.G_RET_STS_ERROR
6218: ,p_row_identifier => G_USER_ROW_IDENTIFIER
6219: ,p_entity_id => p_entity_id
6220: ,p_entity_index => p_entity_index
6221: ,p_entity_code => p_entity_code

Line 6224: RAISE FND_API.G_EXC_ERROR;

6220: ,p_entity_index => p_entity_index
6221: ,p_entity_code => p_entity_code
6222: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
6223: );
6224: RAISE FND_API.G_EXC_ERROR;
6225: END IF;
6226:
6227: x_return_status := FND_API.G_RET_STS_SUCCESS;
6228: Debug_Msg('In Perform_Preliminary_Checks, done', 2);

Line 6227: x_return_status := FND_API.G_RET_STS_SUCCESS;

6223: );
6224: RAISE FND_API.G_EXC_ERROR;
6225: END IF;
6226:
6227: x_return_status := FND_API.G_RET_STS_SUCCESS;
6228: Debug_Msg('In Perform_Preliminary_Checks, done', 2);
6229:
6230: EXCEPTION
6231: WHEN FND_API.G_EXC_ERROR THEN

Line 6231: WHEN FND_API.G_EXC_ERROR THEN

6227: x_return_status := FND_API.G_RET_STS_SUCCESS;
6228: Debug_Msg('In Perform_Preliminary_Checks, done', 2);
6229:
6230: EXCEPTION
6231: WHEN FND_API.G_EXC_ERROR THEN
6232: Debug_Msg('In Perform_Preliminary_Checks, EXCEPTION FND_API.G_EXC_ERROR', 2);
6233: x_return_status := FND_API.G_RET_STS_ERROR;
6234:
6235: END Perform_Preliminary_Checks;

Line 6232: Debug_Msg('In Perform_Preliminary_Checks, EXCEPTION FND_API.G_EXC_ERROR', 2);

6228: Debug_Msg('In Perform_Preliminary_Checks, done', 2);
6229:
6230: EXCEPTION
6231: WHEN FND_API.G_EXC_ERROR THEN
6232: Debug_Msg('In Perform_Preliminary_Checks, EXCEPTION FND_API.G_EXC_ERROR', 2);
6233: x_return_status := FND_API.G_RET_STS_ERROR;
6234:
6235: END Perform_Preliminary_Checks;
6236:

Line 6233: x_return_status := FND_API.G_RET_STS_ERROR;

6229:
6230: EXCEPTION
6231: WHEN FND_API.G_EXC_ERROR THEN
6232: Debug_Msg('In Perform_Preliminary_Checks, EXCEPTION FND_API.G_EXC_ERROR', 2);
6233: x_return_status := FND_API.G_RET_STS_ERROR;
6234:
6235: END Perform_Preliminary_Checks;
6236:
6237: ----------------------------------------------------------------------

Line 6358: x_return_status := FND_API.G_RET_STS_SUCCESS;

6354: END IF;
6355: END IF;
6356:
6357: IF (l_has_edit_privilege) THEN
6358: x_return_status := FND_API.G_RET_STS_SUCCESS;
6359: ELSIF (l_error_message_name IS NULL) THEN
6360: l_error_message_name := 'EGO_EF_AG_USER_PRIV_ERR';
6361: END IF;
6362:

Line 6377: ,p_message_type => FND_API.G_RET_STS_ERROR

6373: ERROR_HANDLER.Add_Error_Message(
6374: p_message_name => l_error_message_name
6375: ,p_application_id => 'EGO'
6376: ,p_token_tbl => l_token_table
6377: ,p_message_type => FND_API.G_RET_STS_ERROR
6378: ,p_row_identifier => G_USER_ROW_IDENTIFIER
6379: ,p_entity_id => p_entity_id
6380: ,p_entity_index => p_entity_index
6381: ,p_entity_code => p_entity_code

Line 6385: x_return_status := FND_API.G_RET_STS_ERROR;

6381: ,p_entity_code => p_entity_code
6382: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
6383: );
6384:
6385: x_return_status := FND_API.G_RET_STS_ERROR;
6386: END IF;
6387:
6388: Debug_Msg('In Check_Privileges, done; x_return_status is '||x_return_status, 2);
6389:

Line 6469: IF (FND_API.To_Boolean(p_init_fnd_msg_list)) THEN

6465:
6466: -----------------------------------------
6467: -- Initialize FND_MSG_PUB if necessary --
6468: -----------------------------------------
6469: IF (FND_API.To_Boolean(p_init_fnd_msg_list)) THEN
6470:
6471: FND_MSG_PUB.Initialize;
6472:
6473: END IF;

Line 6492: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN

6488:
6489: END IF;
6490: END IF;
6491:
6492: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
6493: G_ADD_ERRORS_TO_FND_STACK := 'Y';
6494: ELSE
6495: G_ADD_ERRORS_TO_FND_STACK := 'N';
6496: END IF;

Line 6773: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE

6769: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
6770: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
6771: ,p_pending_b_table_name IN VARCHAR2
6772: ,p_pending_tl_table_name IN VARCHAR2
6773: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
6774: ,p_entity_id IN VARCHAR2
6775: ,p_entity_index IN NUMBER
6776: ,p_entity_code IN VARCHAR2
6777: ,p_commit IN VARCHAR2

Line 6834: IF FND_API.To_Boolean(p_commit) THEN

6830: BEGIN
6831:
6832: Debug_Msg('In Insert_Row, starting', 1);
6833:
6834: IF FND_API.To_Boolean(p_commit) THEN
6835: SAVEPOINT Insert_Row;
6836: END IF;
6837:
6838: l_pre_raise_flag := 'F';

Line 6840: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

6836: END IF;
6837:
6838: l_pre_raise_flag := 'F';
6839: -- Check for call compatibility
6840: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
6841: l_api_name, G_PKG_NAME)
6842: THEN
6843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6844: END IF;

Line 6843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6839: -- Check for call compatibility
6840: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
6841: l_api_name, G_PKG_NAME)
6842: THEN
6843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6844: END IF;
6845:
6846: IF (p_bulkload_flag) THEN
6847: l_propagate_hierarchy := FALSE;

Line 7060: FND_API.TO_BOOLEAN(

7056: -- Add data_level_id only if it has been provided --
7057: -----------------------------------------------------
7058: IF(p_data_level IS NOT NULL
7059: AND
7060: FND_API.TO_BOOLEAN(
7061: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_b_table_name
7062: ,p_column_name => 'DATA_LEVEL_ID'
7063: )
7064: )

Line 7167: FND_API.TO_BOOLEAN(

7163: -----------------------------------------------------
7164: Debug_Msg(' in insert_row -- p_data_level-'||p_data_level);
7165: IF(p_data_level IS NOT NULL
7166: AND
7167: FND_API.TO_BOOLEAN(
7168: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_b_table_name
7169: ,p_column_name => 'DATA_LEVEL_ID'
7170: )
7171: )

Line 7256: IF (p_execute_dml = FND_API.G_TRUE) THEN

7252: ---------------------------------------------------------------------
7253: -- Next we parse the statement, bind our variables, and execute it --
7254: ---------------------------------------------------------------------
7255:
7256: IF (p_execute_dml = FND_API.G_TRUE) THEN
7257: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
7258: FND_DSQL.Set_Cursor(l_cursor_id);
7259: FND_DSQL.Do_Binds();
7260: END IF;

Line 7283: IF (p_execute_dml = FND_API.G_TRUE) THEN

7279: END IF;
7280: END IF;
7281: --End 4105841
7282:
7283: IF (p_execute_dml = FND_API.G_TRUE) THEN
7284: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
7285: END IF;
7286:
7287: END IF;

Line 7317: FND_API.TO_BOOLEAN(

7313: -- Add data_level_id only if it has been provided --
7314: -----------------------------------------------------
7315: IF(p_data_level IS NOT NULL
7316: AND
7317: FND_API.TO_BOOLEAN(
7318: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_tl_table_name
7319: ,p_column_name => 'DATA_LEVEL_ID'
7320: )
7321: )

Line 7390: FND_API.TO_BOOLEAN(

7386: -- Add data_level_id only if it has been provided --
7387: -----------------------------------------------------
7388: IF(p_data_level IS NOT NULL
7389: AND
7390: FND_API.TO_BOOLEAN(
7391: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_tl_table_name
7392: ,p_column_name => 'DATA_LEVEL_ID'
7393: )
7394: )

Line 7485: IF (p_execute_dml = FND_API.G_TRUE) THEN

7481:
7482: ---------------------------------------------------
7483: -- We re-use our cursor from the first statement --
7484: ---------------------------------------------------
7485: IF (p_execute_dml = FND_API.G_TRUE) THEN
7486: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
7487: FND_DSQL.Set_Cursor(l_cursor_id);
7488: FND_DSQL.Do_Binds();
7489: END IF;

Line 7514: IF (p_execute_dml = FND_API.G_TRUE) THEN

7510: END IF;
7511: END IF;
7512: --End 4105841
7513:
7514: IF (p_execute_dml = FND_API.G_TRUE) THEN
7515: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
7516: END IF;
7517:
7518: END IF;

Line 7527: AND px_attr_diffs.COUNT > 0 AND p_execute_dml = FND_API.G_TRUE) THEN --Bug fix 5220020

7523: DBMS_SQL.Close_Cursor(l_cursor_id);
7524:
7525: IF (l_propagate_hierarchy
7526: AND p_attr_group_metadata_obj.HIERARCHY_PROPAGATE_FLAG = 'Y'
7527: AND px_attr_diffs.COUNT > 0 AND p_execute_dml = FND_API.G_TRUE) THEN --Bug fix 5220020
7528: Propagate_Attributes( p_pk_column_name_value_pairs
7529: , p_class_code_name_value_pairs
7530: , p_data_level_name_value_pairs
7531: , px_attr_diffs

Line 7569: IF FND_API.To_Boolean(p_commit) THEN

7565: x_extension_id := l_new_extension_id;
7566:
7567: Debug_Msg('In Insert_Row, done', 1);
7568:
7569: IF FND_API.To_Boolean(p_commit) THEN
7570: COMMIT WORK;
7571: END IF;
7572:
7573: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7573: x_return_status := FND_API.G_RET_STS_SUCCESS;

7569: IF FND_API.To_Boolean(p_commit) THEN
7570: COMMIT WORK;
7571: END IF;
7572:
7573: x_return_status := FND_API.G_RET_STS_SUCCESS;
7574:
7575: EXCEPTION
7576: -----------------------------------------------------------
7577: -- There are no expected errors in this procedure, so... --

Line 7584: IF FND_API.To_Boolean(p_commit) THEN

7580: --Checking for Exception raised by preAttribute Change Event
7581: --don't put to the stack already added in EGO_WF_WRAPPER_PVT
7582: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
7583: Debug_Msg('Insert_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
7584: IF FND_API.To_Boolean(p_commit) THEN
7585: ROLLBACK TO insert_row;
7586: END IF;
7587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7588: --End 4105841

Line 7587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7583: Debug_Msg('Insert_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
7584: IF FND_API.To_Boolean(p_commit) THEN
7585: ROLLBACK TO insert_row;
7586: END IF;
7587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7588: --End 4105841
7589:
7590: WHEN OTHERS THEN
7591:

Line 7593: IF FND_API.To_Boolean(p_commit) THEN

7589:
7590: WHEN OTHERS THEN
7591:
7592: Debug_Msg('Insert_Row EXCEPTION others '||SQLERRM);
7593: IF FND_API.To_Boolean(p_commit) THEN
7594: ROLLBACK TO insert_row;
7595: END IF;
7596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7597:

Line 7596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7592: Debug_Msg('Insert_Row EXCEPTION others '||SQLERRM);
7593: IF FND_API.To_Boolean(p_commit) THEN
7594: ROLLBACK TO insert_row;
7595: END IF;
7596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7597:
7598: DECLARE
7599: l_token_table ERROR_HANDLER.Token_Tbl_Type;
7600: BEGIN

Line 7612: ,p_message_type => FND_API.G_RET_STS_ERROR

7608: ERROR_HANDLER.Add_Error_Message(
7609: p_message_name => 'EGO_PLSQL_ERR'
7610: ,p_application_id => 'EGO'
7611: ,p_token_tbl => l_token_table
7612: ,p_message_type => FND_API.G_RET_STS_ERROR
7613: ,p_row_identifier => G_USER_ROW_IDENTIFIER
7614: ,p_entity_id => p_entity_id
7615: ,p_entity_index => p_entity_index
7616: ,p_entity_code => p_entity_code

Line 7641: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE

7637: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
7638: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
7639: ,p_pending_b_table_name IN VARCHAR2
7640: ,p_pending_tl_table_name IN VARCHAR2
7641: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
7642: ,p_entity_id IN VARCHAR2
7643: ,p_entity_index IN NUMBER
7644: ,p_entity_code IN VARCHAR2
7645: ,p_commit IN VARCHAR2

Line 7698: IF FND_API.To_Boolean(p_commit) THEN

7694: BEGIN
7695:
7696: Debug_Msg('In Update_Row, starting', 1);
7697:
7698: IF FND_API.To_Boolean(p_commit) THEN
7699: SAVEPOINT update_row;
7700: END IF;
7701:
7702: l_pre_event_flag := 'F';

Line 7704: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

7700: END IF;
7701:
7702: l_pre_event_flag := 'F';
7703: -- Check for call compatibility
7704: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
7705: l_api_name, G_PKG_NAME)
7706: THEN
7707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7708: END IF;

Line 7707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7703: -- Check for call compatibility
7704: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
7705: l_api_name, G_PKG_NAME)
7706: THEN
7707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7708: END IF;
7709:
7710: IF (p_bulkload_flag) THEN
7711: l_propagate_hierarchy := FALSE;

Line 7892: FND_API.TO_BOOLEAN(

7888: --support have been taken up.
7889: ----------------------------------------------------------------------------
7890: IF(p_data_level IS NOT NULL
7891: AND
7892: FND_API.TO_BOOLEAN(
7893: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_b_table_name
7894: ,p_column_name => 'DATA_LEVEL_ID'
7895: )
7896: )

Line 7941: IF (p_execute_dml = FND_API.G_TRUE) THEN

7937: Debug_Msg('In Update_Row, l_dynamic_sql:'||l_dynamic_sql, 3);
7938: Debug_SQL(FND_DSQL.Get_Text(TRUE));
7939: Set_Binds_And_Dml(l_dynamic_sql ,'B');
7940:
7941: IF (p_execute_dml = FND_API.G_TRUE) THEN
7942: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
7943: FND_DSQL.Set_Cursor(l_cursor_id);
7944: FND_DSQL.Do_Binds();
7945: END IF;

Line 7968: IF (p_execute_dml = FND_API.G_TRUE) THEN

7964: END IF;
7965: END IF;
7966: --End 4105841
7967:
7968: IF (p_execute_dml = FND_API.G_TRUE) THEN
7969: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
7970: END IF;
7971:
7972: END IF;

Line 8022: FND_API.TO_BOOLEAN(

8018: --support have been taken up.
8019: ----------------------------------------------------------------------------
8020: IF(p_data_level IS NOT NULL
8021: AND
8022: FND_API.TO_BOOLEAN(
8023: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_tl_table_name
8024: ,p_column_name => 'DATA_LEVEL_ID'
8025: )
8026: )

Line 8101: IF (p_execute_dml = FND_API.G_TRUE) THEN

8097:
8098: Debug_Msg('In Update_Row, l_dynamic_sql for TL table is as follows:', 3);
8099: Debug_SQL(FND_DSQL.Get_Text(TRUE));
8100:
8101: IF (p_execute_dml = FND_API.G_TRUE) THEN
8102: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
8103: FND_DSQL.Set_Cursor(l_cursor_id);
8104: FND_DSQL.Do_Binds();
8105: END IF;

Line 8129: IF (p_execute_dml = FND_API.G_TRUE) THEN

8125: END IF;
8126: END IF;
8127: --End 4105841
8128:
8129: IF (p_execute_dml = FND_API.G_TRUE) THEN
8130: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
8131: END IF;
8132:
8133:

Line 8151: AND px_attr_diffs.COUNT > 0 AND p_execute_dml = FND_API.G_TRUE) THEN --Bug fix 5220020

8147: --
8148:
8149: IF (l_propagate_hierarchy
8150: AND p_attr_group_metadata_obj.HIERARCHY_PROPAGATE_FLAG = 'Y'
8151: AND px_attr_diffs.COUNT > 0 AND p_execute_dml = FND_API.G_TRUE) THEN --Bug fix 5220020
8152: Propagate_Attributes( p_pk_column_name_value_pairs
8153: , p_class_code_name_value_pairs
8154: , p_data_level_name_value_pairs
8155: , px_attr_diffs

Line 8191: IF FND_API.To_Boolean(p_commit) THEN

8187: END IF;
8188:
8189: Debug_Msg('In Update_Row, done', 1);
8190:
8191: IF FND_API.To_Boolean(p_commit) THEN
8192: COMMIT WORK;
8193: END IF;
8194:
8195: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8195: x_return_status := FND_API.G_RET_STS_SUCCESS;

8191: IF FND_API.To_Boolean(p_commit) THEN
8192: COMMIT WORK;
8193: END IF;
8194:
8195: x_return_status := FND_API.G_RET_STS_SUCCESS;
8196:
8197: EXCEPTION
8198: -----------------------------------------------------------
8199: -- There are no expected errors in this procedure, so... --

Line 8207: IF FND_API.To_Boolean(p_commit) THEN

8203: --don't put to the stack already added in EGO_WF_WRAPPER_PVT
8204: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
8205: Debug_Msg('Update_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
8206:
8207: IF FND_API.To_Boolean(p_commit) THEN
8208: ROLLBACK TO update_row;
8209: END IF;
8210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8211: --End 4105841

Line 8210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8206:
8207: IF FND_API.To_Boolean(p_commit) THEN
8208: ROLLBACK TO update_row;
8209: END IF;
8210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8211: --End 4105841
8212:
8213: WHEN OTHERS THEN
8214: Debug_Msg('Update_Row EXCEPTION others '||SQLERRM);

Line 8215: IF FND_API.To_Boolean(p_commit) THEN

8211: --End 4105841
8212:
8213: WHEN OTHERS THEN
8214: Debug_Msg('Update_Row EXCEPTION others '||SQLERRM);
8215: IF FND_API.To_Boolean(p_commit) THEN
8216: ROLLBACK TO update_row;
8217: END IF;
8218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8219:

Line 8218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8214: Debug_Msg('Update_Row EXCEPTION others '||SQLERRM);
8215: IF FND_API.To_Boolean(p_commit) THEN
8216: ROLLBACK TO update_row;
8217: END IF;
8218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8219:
8220: DECLARE
8221: l_token_table ERROR_HANDLER.Token_Tbl_Type;
8222: BEGIN

Line 8234: ,p_message_type => FND_API.G_RET_STS_ERROR

8230: ERROR_HANDLER.Add_Error_Message(
8231: p_message_name => 'EGO_PLSQL_ERR'
8232: ,p_application_id => 'EGO'
8233: ,p_token_tbl => l_token_table
8234: ,p_message_type => FND_API.G_RET_STS_ERROR
8235: ,p_row_identifier => G_USER_ROW_IDENTIFIER
8236: ,p_entity_id => p_entity_id
8237: ,p_entity_index => p_entity_index
8238: ,p_entity_code => p_entity_code

Line 8263: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE

8259: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ
8260: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
8261: ,p_pending_b_table_name IN VARCHAR2
8262: ,p_pending_tl_table_name IN VARCHAR2
8263: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
8264: -- Start ssingal -For Ucc Net Attribute Propagation
8265: ,p_bulkload_flag IN BOOLEAN DEFAULT FALSE
8266: ,px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
8267: -- End ssingal -For Ucc Net Attribute Propagation

Line 8306: IF FND_API.To_Boolean(p_commit) THEN

8302: BEGIN
8303:
8304: Debug_Msg('In Delete_Row, starting', 1);
8305:
8306: IF FND_API.To_Boolean(p_commit) THEN
8307: SAVEPOINT delete_row;
8308: END IF;
8309:
8310: -- Check for call compatibility

Line 8311: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

8307: SAVEPOINT delete_row;
8308: END IF;
8309:
8310: -- Check for call compatibility
8311: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
8312: l_api_name, G_PKG_NAME)
8313: THEN
8314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8315: END IF;

Line 8314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8310: -- Check for call compatibility
8311: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
8312: l_api_name, G_PKG_NAME)
8313: THEN
8314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8315: END IF;
8316:
8317: IF (p_extension_id IS NULL) THEN
8318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8315: END IF;
8316:
8317: IF (p_extension_id IS NULL) THEN
8318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8319: END IF;
8320: -- Start ssingal -For Ucc Net Attribute Propagation
8321: IF p_bulkload_flag THEN
8322: l_propagate_hierarchy := FALSE;

Line 8458: IF (p_execute_dml = FND_API.G_TRUE) THEN

8454: --End 4105841
8455:
8456: Set_Binds_And_Dml(l_dynamic_sql ,'B');
8457:
8458: IF (p_execute_dml = FND_API.G_TRUE) THEN
8459: EXECUTE IMMEDIATE l_dynamic_sql;
8460: END IF;
8461: END IF;
8462:

Line 8482: IF (p_execute_dml = FND_API.G_TRUE) THEN

8478: Debug_SQL(l_dynamic_sql);
8479:
8480: Set_Binds_And_Dml(l_dynamic_sql ,'TL');
8481:
8482: IF (p_execute_dml = FND_API.G_TRUE) THEN
8483: EXECUTE IMMEDIATE l_dynamic_sql;
8484: END IF;
8485: -- Start ssingal -For Ucc Net Attribute Propagation
8486:

Line 8490: AND px_attr_diffs.COUNT > 0 AND p_execute_dml = FND_API.G_TRUE) THEN --Bug fix 5220020

8486:
8487: -- Only propagate if at least one attribute has EIH code = LP/AP
8488: IF (l_propagate_hierarchy AND
8489: p_attr_group_metadata_obj.HIERARCHY_PROPAGATE_FLAG = 'Y'
8490: AND px_attr_diffs.COUNT > 0 AND p_execute_dml = FND_API.G_TRUE) THEN --Bug fix 5220020
8491:
8492: Propagate_Attributes( p_pk_column_name_value_pairs
8493: , p_class_code_name_value_pairs
8494: , p_data_level_name_value_pairs

Line 8532: IF FND_API.To_Boolean(p_commit) THEN

8528: END IF;
8529:
8530: Debug_Msg('In Delete_Row, done', 1);
8531:
8532: IF FND_API.To_Boolean(p_commit) THEN
8533: COMMIT WORK;
8534: END IF;
8535:
8536: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8536: x_return_status := FND_API.G_RET_STS_SUCCESS;

8532: IF FND_API.To_Boolean(p_commit) THEN
8533: COMMIT WORK;
8534: END IF;
8535:
8536: x_return_status := FND_API.G_RET_STS_SUCCESS;
8537:
8538: EXCEPTION
8539: -----------------------------------------------------------
8540: -- There are no expected errors in this procedure, so... --

Line 8548: IF FND_API.To_Boolean(p_commit) THEN

8544: --don't put to the stack already added in EGO_WF_WRAPPER_PVT
8545: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
8546: Debug_Msg('Delete_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
8547:
8548: IF FND_API.To_Boolean(p_commit) THEN
8549: ROLLBACK TO delete_row;
8550: END IF;
8551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8552: --End 4105841

Line 8551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8547:
8548: IF FND_API.To_Boolean(p_commit) THEN
8549: ROLLBACK TO delete_row;
8550: END IF;
8551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8552: --End 4105841
8553: WHEN OTHERS THEN
8554: Debug_Msg('Delete_Row EXCEPTION others '||SQLERRM);
8555: IF FND_API.To_Boolean(p_commit) THEN

Line 8555: IF FND_API.To_Boolean(p_commit) THEN

8551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8552: --End 4105841
8553: WHEN OTHERS THEN
8554: Debug_Msg('Delete_Row EXCEPTION others '||SQLERRM);
8555: IF FND_API.To_Boolean(p_commit) THEN
8556: ROLLBACK TO delete_row;
8557: END IF;
8558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8559:

Line 8558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8554: Debug_Msg('Delete_Row EXCEPTION others '||SQLERRM);
8555: IF FND_API.To_Boolean(p_commit) THEN
8556: ROLLBACK TO delete_row;
8557: END IF;
8558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8559:
8560: DECLARE
8561: l_token_table ERROR_HANDLER.Token_Tbl_Type;
8562: BEGIN

Line 8574: ,p_message_type => FND_API.G_RET_STS_ERROR

8570: ERROR_HANDLER.Add_Error_Message(
8571: p_message_name => 'EGO_PLSQL_ERR'
8572: ,p_application_id => 'EGO'
8573: ,p_token_tbl => l_token_table
8574: ,p_message_type => FND_API.G_RET_STS_ERROR
8575: ,p_row_identifier => G_USER_ROW_IDENTIFIER
8576: ,p_entity_id => p_entity_id
8577: ,p_entity_index => p_entity_index
8578: ,p_entity_code => p_entity_code

Line 8590: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE --Added for bugFix:5275391

8586:
8587: PROCEDURE Validate_Row_Pvt (
8588: p_api_version IN NUMBER
8589: ,p_object_id IN NUMBER
8590: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE --Added for bugFix:5275391
8591: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
8592: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
8593: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
8594: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 8628: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

8624:
8625: Debug_Msg(l_api_name || ' starting', 1);
8626:
8627: -- Check for call compatibility
8628: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
8629: l_api_name, G_PKG_NAME)
8630: THEN
8631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8632: END IF;

Line 8631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8627: -- Check for call compatibility
8628: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
8629: l_api_name, G_PKG_NAME)
8630: THEN
8631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8632: END IF;
8633:
8634: Debug_Msg(l_api_name || ' calling Is_Data_Level_Correct ', 1);
8635: IF (NOT Is_Data_Level_Correct(

Line 8651: ,p_message_type => FND_API.G_RET_STS_ERROR

8647: ERROR_HANDLER.Add_Error_Message(
8648: p_message_name => l_err_msg_name
8649: ,p_application_id => 'EGO'
8650: ,p_token_tbl => l_token_table
8651: ,p_message_type => FND_API.G_RET_STS_ERROR
8652: ,p_row_identifier => G_USER_ROW_IDENTIFIER
8653: ,p_entity_id => p_entity_id
8654: ,p_entity_index => p_entity_index
8655: ,p_entity_code => p_entity_code

Line 8716: ,p_message_type => FND_API.G_RET_STS_ERROR

8712: ERROR_HANDLER.Add_Error_Message(
8713: p_message_name => l_err_msg_name
8714: ,p_application_id => 'EGO'
8715: ,p_token_tbl => l_token_table
8716: ,p_message_type => FND_API.G_RET_STS_ERROR
8717: ,p_row_identifier => G_USER_ROW_IDENTIFIER
8718: ,p_entity_id => p_entity_id
8719: ,p_entity_index => p_entity_index
8720: ,p_entity_code => p_entity_code

Line 8756: ,p_message_type => FND_API.G_RET_STS_ERROR

8752: ERROR_HANDLER.Add_Error_Message(
8753: p_message_name => l_err_msg_name
8754: ,p_application_id => 'EGO'
8755: ,p_token_tbl => l_token_table
8756: ,p_message_type => FND_API.G_RET_STS_ERROR
8757: ,p_row_identifier => G_USER_ROW_IDENTIFIER
8758: ,p_entity_id => p_entity_id
8759: ,p_entity_index => p_entity_index
8760: ,p_entity_code => p_entity_code

Line 8789: ,p_message_type => FND_API.G_RET_STS_ERROR

8785: ERROR_HANDLER.Add_Error_Message(
8786: p_message_name => l_err_msg_name
8787: ,p_application_id => 'EGO'
8788: ,p_token_tbl => l_token_table
8789: ,p_message_type => FND_API.G_RET_STS_ERROR
8790: ,p_row_identifier => G_USER_ROW_IDENTIFIER
8791: ,p_entity_id => p_entity_id
8792: ,p_entity_index => p_entity_index
8793: ,p_entity_code => p_entity_code

Line 8822: ,p_message_type => FND_API.G_RET_STS_ERROR

8818: ERROR_HANDLER.Add_Error_Message(
8819: p_message_name => l_err_msg_name
8820: ,p_application_id => 'EGO'
8821: ,p_token_tbl => l_token_table
8822: ,p_message_type => FND_API.G_RET_STS_ERROR
8823: ,p_row_identifier => G_USER_ROW_IDENTIFIER
8824: ,p_entity_id => p_entity_id
8825: ,p_entity_index => p_entity_index
8826: ,p_entity_code => p_entity_code

Line 8860: ,p_message_type => FND_API.G_RET_STS_ERROR

8856: ERROR_HANDLER.Add_Error_Message(
8857: p_message_name => l_err_msg_name
8858: ,p_application_id => 'EGO'
8859: ,p_token_tbl => l_token_table
8860: ,p_message_type => FND_API.G_RET_STS_ERROR
8861: ,p_row_identifier => G_USER_ROW_IDENTIFIER
8862: ,p_entity_id => p_entity_id
8863: ,p_entity_index => p_entity_index
8864: ,p_entity_code => p_entity_code

Line 8904: IF (FND_API.To_Boolean(p_validate_hierarchy) AND--Added for bugFix:5275391

8900: -- Check if hierarchy security flags prevent the current changes from
8901: -- being made.
8902: -------------------------------------------------------------------------
8903:
8904: IF (FND_API.To_Boolean(p_validate_hierarchy) AND--Added for bugFix:5275391
8905: NOT (l_attr_metadata_obj.EDIT_IN_HIERARCHY_CODE = 'A' OR
8906: l_attr_metadata_obj.EDIT_IN_HIERARCHY_CODE = 'AP')
8907: ) THEN
8908: -- Get is_root/is_leaf

Line 8927: ,p_message_type => FND_API.G_RET_STS_ERROR

8923: ERROR_HANDLER.Add_Error_Message(
8924: p_message_name => l_err_msg_name
8925: ,p_application_id => 'EGO'
8926: ,p_token_tbl => l_token_table
8927: ,p_message_type => FND_API.G_RET_STS_ERROR
8928: ,p_row_identifier => G_USER_ROW_IDENTIFIER
8929: ,p_entity_id => p_entity_id
8930: ,p_entity_index => p_entity_index
8931: ,p_entity_code => p_entity_code

Line 8954: ,p_message_type => FND_API.G_RET_STS_ERROR

8950: ERROR_HANDLER.Add_Error_Message(
8951: p_message_name => l_err_msg_name
8952: ,p_application_id => 'EGO'
8953: ,p_token_tbl => l_token_table
8954: ,p_message_type => FND_API.G_RET_STS_ERROR
8955: ,p_row_identifier => G_USER_ROW_IDENTIFIER
8956: ,p_entity_id => p_entity_id
8957: ,p_entity_index => p_entity_index
8958: ,p_entity_code => p_entity_code

Line 9006: RAISE FND_API.G_EXC_ERROR;

9002: Debug_Msg(l_api_name ||' done', 1);
9003:
9004: IF (NOT l_is_valid_row) THEN
9005:
9006: RAISE FND_API.G_EXC_ERROR;
9007:
9008: END IF;
9009:
9010: -----------------------------------

Line 9012: x_return_status := FND_API.G_RET_STS_SUCCESS;

9008: END IF;
9009:
9010: -----------------------------------
9011:
9012: x_return_status := FND_API.G_RET_STS_SUCCESS;
9013:
9014: EXCEPTION
9015: WHEN FND_API.G_EXC_ERROR THEN
9016: Debug_Msg(l_api_name ||' EXCEPTION FND_API.G_EXC_ERROR raised ', 1);

Line 9015: WHEN FND_API.G_EXC_ERROR THEN

9011:
9012: x_return_status := FND_API.G_RET_STS_SUCCESS;
9013:
9014: EXCEPTION
9015: WHEN FND_API.G_EXC_ERROR THEN
9016: Debug_Msg(l_api_name ||' EXCEPTION FND_API.G_EXC_ERROR raised ', 1);
9017: x_return_status := FND_API.G_RET_STS_ERROR;
9018:
9019: WHEN OTHERS THEN

Line 9016: Debug_Msg(l_api_name ||' EXCEPTION FND_API.G_EXC_ERROR raised ', 1);

9012: x_return_status := FND_API.G_RET_STS_SUCCESS;
9013:
9014: EXCEPTION
9015: WHEN FND_API.G_EXC_ERROR THEN
9016: Debug_Msg(l_api_name ||' EXCEPTION FND_API.G_EXC_ERROR raised ', 1);
9017: x_return_status := FND_API.G_RET_STS_ERROR;
9018:
9019: WHEN OTHERS THEN
9020: Debug_Msg(l_api_name ||' EXCEPTION OTHERS raised '||SQLERRM, 1);

Line 9017: x_return_status := FND_API.G_RET_STS_ERROR;

9013:
9014: EXCEPTION
9015: WHEN FND_API.G_EXC_ERROR THEN
9016: Debug_Msg(l_api_name ||' EXCEPTION FND_API.G_EXC_ERROR raised ', 1);
9017: x_return_status := FND_API.G_RET_STS_ERROR;
9018:
9019: WHEN OTHERS THEN
9020: Debug_Msg(l_api_name ||' EXCEPTION OTHERS raised '||SQLERRM, 1);
9021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9017: x_return_status := FND_API.G_RET_STS_ERROR;
9018:
9019: WHEN OTHERS THEN
9020: Debug_Msg(l_api_name ||' EXCEPTION OTHERS raised '||SQLERRM, 1);
9021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9022:
9023: l_token_table.DELETE();
9024: l_token_table(1).TOKEN_NAME := 'PKG_NAME';
9025: l_token_table(1).TOKEN_VALUE := G_PKG_NAME;

Line 9035: ,p_message_type => FND_API.G_RET_STS_ERROR

9031: ERROR_HANDLER.Add_Error_Message(
9032: p_message_name => 'EGO_PLSQL_ERR'
9033: ,p_application_id => 'EGO'
9034: ,p_token_tbl => l_token_table
9035: ,p_message_type => FND_API.G_RET_STS_ERROR
9036: ,p_row_identifier => G_USER_ROW_IDENTIFIER
9037: ,p_entity_id => p_entity_id
9038: ,p_entity_index => p_entity_index
9039: ,p_entity_code => p_entity_code

Line 9065: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE

9061: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
9062: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
9063: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
9064: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
9065: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
9066: ,p_entity_id IN VARCHAR2 DEFAULT NULL
9067: ,p_entity_index IN NUMBER DEFAULT NULL
9068: ,p_entity_code IN VARCHAR2 DEFAULT NULL
9069: ,p_commit IN VARCHAR2

Line 9088: IF FND_API.To_Boolean(p_commit) THEN

9084: BEGIN
9085:
9086: Debug_Msg(l_api_name || ' starting with p_data_level '||p_data_level, 1);
9087:
9088: IF FND_API.To_Boolean(p_commit) THEN
9089: SAVEPOINT Perform_DML_On_Row_PVT;
9090: END IF;
9091:
9092: -- Check for call compatibility

Line 9093: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

9089: SAVEPOINT Perform_DML_On_Row_PVT;
9090: END IF;
9091:
9092: -- Check for call compatibility
9093: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
9094: l_api_name, G_PKG_NAME)
9095: THEN
9096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9097: END IF;

Line 9096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9092: -- Check for call compatibility
9093: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
9094: l_api_name, G_PKG_NAME)
9095: THEN
9096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9097: END IF;
9098:
9099: IF (p_mode = G_CREATE_MODE) THEN
9100: Insert_Row(

Line 9120: ,p_commit => FND_API.G_FALSE

9116: ,p_execute_dml => p_execute_dml
9117: ,p_entity_id => p_entity_id
9118: ,p_entity_index => p_entity_index
9119: ,p_entity_code => p_entity_code
9120: ,p_commit => FND_API.G_FALSE
9121: ,p_bulkload_flag => p_bulkload_flag
9122: ,px_attr_diffs => l_attr_diffs
9123: ,p_raise_business_event => p_raise_business_event
9124: ,x_extension_id => x_extension_id

Line 9148: ,p_commit => FND_API.G_FALSE

9144: ,p_execute_dml => p_execute_dml
9145: ,p_entity_id => p_entity_id
9146: ,p_entity_index => p_entity_index
9147: ,p_entity_code => p_entity_code
9148: ,p_commit => FND_API.G_FALSE
9149: ,p_bulkload_flag => p_bulkload_flag
9150: ,px_attr_diffs => l_attr_diffs
9151: ,p_raise_business_event => p_raise_business_event
9152: ,x_return_status => x_return_status

Line 9175: ,p_commit => FND_API.G_FALSE

9171: ,px_attr_diffs => l_attr_diffs
9172: ,p_entity_id => p_entity_id
9173: ,p_entity_index => p_entity_index
9174: ,p_entity_code => p_entity_code
9175: ,p_commit => FND_API.G_FALSE
9176: ,p_raise_business_event => p_raise_business_event
9177: ,x_return_status => x_return_status
9178: );
9179: ELSE

Line 9180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9176: ,p_raise_business_event => p_raise_business_event
9177: ,x_return_status => x_return_status
9178: );
9179: ELSE
9180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9181:
9182: END IF;
9183:
9184: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 9184: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9181:
9182: END IF;
9183:
9184: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9185: RAISE FND_API.G_EXC_ERROR;
9186: END IF;
9187:
9188: IF(x_extension_id IS NULL AND p_extension_id IS NOT NULL ) THEN

Line 9185: RAISE FND_API.G_EXC_ERROR;

9181:
9182: END IF;
9183:
9184: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9185: RAISE FND_API.G_EXC_ERROR;
9186: END IF;
9187:
9188: IF(x_extension_id IS NULL AND p_extension_id IS NOT NULL ) THEN
9189: x_extension_id := p_extension_id;

Line 9192: IF FND_API.To_Boolean(p_commit) THEN

9188: IF(x_extension_id IS NULL AND p_extension_id IS NOT NULL ) THEN
9189: x_extension_id := p_extension_id;
9190: END IF;
9191:
9192: IF FND_API.To_Boolean(p_commit) THEN
9193: COMMIT WORK;
9194: END IF;
9195:
9196: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9196: x_return_status := FND_API.G_RET_STS_SUCCESS;

9192: IF FND_API.To_Boolean(p_commit) THEN
9193: COMMIT WORK;
9194: END IF;
9195:
9196: x_return_status := FND_API.G_RET_STS_SUCCESS;
9197: Debug_Msg( l_api_name || ' ending ', 1);
9198:
9199: EXCEPTION
9200: WHEN FND_API.G_EXC_ERROR THEN

Line 9200: WHEN FND_API.G_EXC_ERROR THEN

9196: x_return_status := FND_API.G_RET_STS_SUCCESS;
9197: Debug_Msg( l_api_name || ' ending ', 1);
9198:
9199: EXCEPTION
9200: WHEN FND_API.G_EXC_ERROR THEN
9201: Debug_Msg( l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR ', 1);
9202: IF FND_API.To_Boolean(p_commit) THEN
9203: ROLLBACK TO Perform_DML_On_Row_PVT;
9204: END IF;

Line 9201: Debug_Msg( l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR ', 1);

9197: Debug_Msg( l_api_name || ' ending ', 1);
9198:
9199: EXCEPTION
9200: WHEN FND_API.G_EXC_ERROR THEN
9201: Debug_Msg( l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR ', 1);
9202: IF FND_API.To_Boolean(p_commit) THEN
9203: ROLLBACK TO Perform_DML_On_Row_PVT;
9204: END IF;
9205: -----------------------------------------------------------

Line 9202: IF FND_API.To_Boolean(p_commit) THEN

9198:
9199: EXCEPTION
9200: WHEN FND_API.G_EXC_ERROR THEN
9201: Debug_Msg( l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR ', 1);
9202: IF FND_API.To_Boolean(p_commit) THEN
9203: ROLLBACK TO Perform_DML_On_Row_PVT;
9204: END IF;
9205: -----------------------------------------------------------
9206: -- If we get here, then the nested API call (whichever --

Line 9213: IF FND_API.To_Boolean(p_commit) THEN

9209: -----------------------------------------------------------
9210:
9211: WHEN OTHERS THEN
9212: Debug_Msg( l_api_name || ' EXCEPTION OTHERS '||SQLERRM, 1);
9213: IF FND_API.To_Boolean(p_commit) THEN
9214: ROLLBACK TO Perform_DML_On_Row_PVT;
9215: END IF;
9216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9217:

Line 9216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9212: Debug_Msg( l_api_name || ' EXCEPTION OTHERS '||SQLERRM, 1);
9213: IF FND_API.To_Boolean(p_commit) THEN
9214: ROLLBACK TO Perform_DML_On_Row_PVT;
9215: END IF;
9216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9217:
9218: DECLARE
9219: l_token_table ERROR_HANDLER.Token_Tbl_Type;
9220: BEGIN

Line 9232: ,p_message_type => FND_API.G_RET_STS_ERROR

9228: ERROR_HANDLER.Add_Error_Message(
9229: p_message_name => 'EGO_PLSQL_ERR'
9230: ,p_application_id => 'EGO'
9231: ,p_token_tbl => l_token_table
9232: ,p_message_type => FND_API.G_RET_STS_ERROR
9233: ,p_row_identifier => G_USER_ROW_IDENTIFIER
9234: ,p_entity_id => p_entity_id
9235: ,p_entity_index => p_entity_index
9236: ,p_entity_code => p_entity_code

Line 9291: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9287: ,p_data_level_name_value_pairs => p_data_level_name_value_pairs
9288: ,px_attr_name_value_pairs => px_attr_name_value_pairs
9289: ,x_return_status => l_return_status
9290: );
9291: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9292: RAISE FND_API.G_EXC_ERROR;
9293: END IF;
9294:
9295: --------------------------------------------------

Line 9292: RAISE FND_API.G_EXC_ERROR;

9288: ,px_attr_name_value_pairs => px_attr_name_value_pairs
9289: ,x_return_status => l_return_status
9290: );
9291: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9292: RAISE FND_API.G_EXC_ERROR;
9293: END IF;
9294:
9295: --------------------------------------------------
9296: -- Find out whether we're inserting or updating --

Line 9311: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9307: ,x_extension_id => l_extension_id
9308: ,x_mode => l_mode
9309: ,x_return_status => l_return_status
9310: );
9311: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9312: RAISE FND_API.G_EXC_ERROR;
9313: END IF;
9314:
9315: ----------------------------------------------------------------------

Line 9312: RAISE FND_API.G_EXC_ERROR;

9308: ,x_mode => l_mode
9309: ,x_return_status => l_return_status
9310: );
9311: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9312: RAISE FND_API.G_EXC_ERROR;
9313: END IF;
9314:
9315: ----------------------------------------------------------------------
9316: -- Validate the current collection of Attribute values prior to DML --

Line 9333: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9329: ,p_mode => l_mode
9330: ,px_attr_name_value_pairs => px_attr_name_value_pairs
9331: ,x_return_status => l_return_status
9332: );
9333: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9334: RAISE FND_API.G_EXC_ERROR;
9335: END IF;
9336:
9337: -----------------------------------------------------

Line 9334: RAISE FND_API.G_EXC_ERROR;

9330: ,px_attr_name_value_pairs => px_attr_name_value_pairs
9331: ,x_return_status => l_return_status
9332: );
9333: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9334: RAISE FND_API.G_EXC_ERROR;
9335: END IF;
9336:
9337: -----------------------------------------------------
9338: -- If the row is valid, either insert or update it --

Line 9357: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9353: ,p_commit => p_commit
9354: ,x_extension_id => l_dummy_ext_id
9355: ,x_return_status => l_return_status
9356: );
9357: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9358: RAISE FND_API.G_EXC_ERROR;
9359: END IF;
9360: Debug_Msg(l_api_name || ' ending ',1);
9361:

Line 9358: RAISE FND_API.G_EXC_ERROR;

9354: ,x_extension_id => l_dummy_ext_id
9355: ,x_return_status => l_return_status
9356: );
9357: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9358: RAISE FND_API.G_EXC_ERROR;
9359: END IF;
9360: Debug_Msg(l_api_name || ' ending ',1);
9361:
9362: END Perform_DML_On_Template_Row;

Line 9444: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9440: Debug_Msg(l_api_name || ' done Set_Up_Business_Object_Session: '||x_return_status, 2);
9441: ----------------------------------------------------------------------
9442: -- If an error was found, we've already added it to the error stack --
9443: ----------------------------------------------------------------------
9444: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9445:
9446: RAISE FND_API.G_EXC_ERROR;
9447:
9448: END IF;

Line 9446: RAISE FND_API.G_EXC_ERROR;

9442: -- If an error was found, we've already added it to the error stack --
9443: ----------------------------------------------------------------------
9444: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9445:
9446: RAISE FND_API.G_EXC_ERROR;
9447:
9448: END IF;
9449: END IF;
9450:

Line 9497: ,p_message_type => FND_API.G_RET_STS_ERROR

9493: ERROR_HANDLER.Add_Error_Message(
9494: p_message_name => l_err_msg_name
9495: ,p_application_id => 'EGO'
9496: ,p_token_tbl => l_token_table
9497: ,p_message_type => FND_API.G_RET_STS_ERROR
9498: ,p_row_identifier => G_USER_ROW_IDENTIFIER
9499: ,p_entity_id => p_entity_id
9500: ,p_entity_index => p_entity_index
9501: ,p_entity_code => p_entity_code

Line 9505: RAISE FND_API.G_EXC_ERROR;

9501: ,p_entity_code => p_entity_code
9502: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
9503: );
9504: Debug_Msg(l_api_name || 'before raising exception 0 ');
9505: RAISE FND_API.G_EXC_ERROR;
9506:
9507: ELSIF (NOT Do_All_Attrs_Exist(x_attr_group_metadata_obj
9508: ,px_attr_name_value_pairs
9509: ,p_entity_id

Line 9517: RAISE FND_API.G_EXC_ERROR;

9513: ----------------------------------------------------------------
9514: -- We've logged an error for every Attr that we couldn't find --
9515: ----------------------------------------------------------------
9516: Debug_Msg(l_api_name || 'before raising exception 1 ');
9517: RAISE FND_API.G_EXC_ERROR;
9518:
9519: END IF;
9520:
9521: x_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(px_object_id);

Line 9532: ,p_message_type => FND_API.G_RET_STS_ERROR

9528: ERROR_HANDLER.Add_Error_Message(
9529: p_message_name => 'EGO_EF_EXT_TABLE_METADATA_ERR'
9530: ,p_application_id => 'EGO'
9531: ,p_token_tbl => l_token_table
9532: ,p_message_type => FND_API.G_RET_STS_ERROR
9533: ,p_row_identifier => G_USER_ROW_IDENTIFIER
9534: ,p_entity_id => p_entity_id
9535: ,p_entity_index => p_entity_index
9536: ,p_entity_code => p_entity_code

Line 9541: RAISE FND_API.G_EXC_ERROR;

9537: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
9538: );
9539: Debug_Msg(l_api_name || 'before raising exception 2 ');
9540:
9541: RAISE FND_API.G_EXC_ERROR;
9542:
9543: END IF;
9544:
9545: -------------------------------------------------------------------------------

Line 9578: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9574: ------------------------------------------------------------
9575: -- If errors were found in processing the display values, --
9576: -- we've already added them to the error stack --
9577: ------------------------------------------------------------
9578: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9579: RAISE FND_API.G_EXC_ERROR;
9580: END IF;
9581:
9582: --------------------------------------------------------------------

Line 9579: RAISE FND_API.G_EXC_ERROR;

9575: -- If errors were found in processing the display values, --
9576: -- we've already added them to the error stack --
9577: ------------------------------------------------------------
9578: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9579: RAISE FND_API.G_EXC_ERROR;
9580: END IF;
9581:
9582: --------------------------------------------------------------------
9583: -- Now we determine whether we're creating, updating or deleting, --

Line 9611: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9607: -----------------------------------------------------
9608: -- If errors were found in the previous procedure, --
9609: -- we've already added them to the error stack --
9610: -----------------------------------------------------
9611: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9612: RAISE FND_API.G_EXC_ERROR;
9613: END IF;
9614:
9615: Debug_Msg(l_api_name || ' after checking, x_mode is '||x_mode);

Line 9612: RAISE FND_API.G_EXC_ERROR;

9608: -- If errors were found in the previous procedure, --
9609: -- we've already added them to the error stack --
9610: -----------------------------------------------------
9611: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9612: RAISE FND_API.G_EXC_ERROR;
9613: END IF;
9614:
9615: Debug_Msg(l_api_name || ' after checking, x_mode is '||x_mode);
9616: IF (UPPER(x_mode) = G_UPDATE_MODE OR UPPER(x_mode) = G_DELETE_MODE) THEN

Line 9623: WHEN FND_API.G_EXC_ERROR THEN

9619:
9620: Debug_Msg(l_api_name || ' done', 2);
9621:
9622: EXCEPTION
9623: WHEN FND_API.G_EXC_ERROR THEN
9624: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR', 1);
9625: x_return_status := FND_API.G_RET_STS_ERROR;
9626:
9627: WHEN OTHERS THEN

Line 9624: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR', 1);

9620: Debug_Msg(l_api_name || ' done', 2);
9621:
9622: EXCEPTION
9623: WHEN FND_API.G_EXC_ERROR THEN
9624: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR', 1);
9625: x_return_status := FND_API.G_RET_STS_ERROR;
9626:
9627: WHEN OTHERS THEN
9628: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM, 1);

Line 9625: x_return_status := FND_API.G_RET_STS_ERROR;

9621:
9622: EXCEPTION
9623: WHEN FND_API.G_EXC_ERROR THEN
9624: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR', 1);
9625: x_return_status := FND_API.G_RET_STS_ERROR;
9626:
9627: WHEN OTHERS THEN
9628: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM, 1);
9629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9625: x_return_status := FND_API.G_RET_STS_ERROR;
9626:
9627: WHEN OTHERS THEN
9628: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM, 1);
9629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9630: l_token_table.DELETE();
9631: l_token_table(1).TOKEN_NAME := 'PKG_NAME';
9632: l_token_table(1).TOKEN_VALUE := G_PKG_NAME;
9633: l_token_table(2).TOKEN_NAME := 'API_NAME';

Line 9642: ,p_message_type => FND_API.G_RET_STS_ERROR

9638: ERROR_HANDLER.Add_Error_Message(
9639: p_message_name => 'EGO_PLSQL_ERR'
9640: ,p_application_id => 'EGO'
9641: ,p_token_tbl => l_token_table
9642: ,p_message_type => FND_API.G_RET_STS_ERROR
9643: ,p_row_identifier => G_USER_ROW_IDENTIFIER
9644: ,p_entity_id => p_entity_id
9645: ,p_entity_index => p_entity_index
9646: ,p_entity_code => p_entity_code

Line 9678: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE

9674: ,p_entity_id IN NUMBER DEFAULT NULL
9675: ,p_entity_index IN NUMBER DEFAULT NULL
9676: ,p_entity_code IN VARCHAR2 DEFAULT NULL
9677: ,p_debug_level IN NUMBER DEFAULT 0
9678: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
9679: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
9680: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
9681: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
9682: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 9679: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE

9675: ,p_entity_index IN NUMBER DEFAULT NULL
9676: ,p_entity_code IN VARCHAR2 DEFAULT NULL
9677: ,p_debug_level IN NUMBER DEFAULT 0
9678: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
9679: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
9680: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
9681: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
9682: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
9683: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 9680: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE

9676: ,p_entity_code IN VARCHAR2 DEFAULT NULL
9677: ,p_debug_level IN NUMBER DEFAULT 0
9678: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
9679: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
9680: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
9681: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
9682: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
9683: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
9684: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 9681: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

9677: ,p_debug_level IN NUMBER DEFAULT 0
9678: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
9679: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
9680: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
9681: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
9682: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
9683: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
9684: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
9685: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 9682: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

9678: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
9679: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
9680: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
9681: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
9682: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
9683: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
9684: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
9685: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
9686: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE

Line 9683: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

9679: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
9680: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
9681: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
9682: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
9683: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
9684: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
9685: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
9686: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
9687: ,x_failed_row_id_list OUT NOCOPY VARCHAR2

Line 9684: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

9680: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
9681: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
9682: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
9683: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
9684: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
9685: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
9686: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
9687: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
9688: ,x_return_status OUT NOCOPY VARCHAR2

Line 9685: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

9681: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
9682: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
9683: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
9684: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
9685: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
9686: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
9687: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
9688: ,x_return_status OUT NOCOPY VARCHAR2
9689: ,x_errorcode OUT NOCOPY NUMBER

Line 9748: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE

9744: ,p_entity_id IN NUMBER DEFAULT NULL
9745: ,p_entity_index IN NUMBER DEFAULT NULL
9746: ,p_entity_code IN VARCHAR2 DEFAULT NULL
9747: ,p_debug_level IN NUMBER DEFAULT 0
9748: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
9749: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
9750: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
9751: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
9752: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 9749: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE

9745: ,p_entity_index IN NUMBER DEFAULT NULL
9746: ,p_entity_code IN VARCHAR2 DEFAULT NULL
9747: ,p_debug_level IN NUMBER DEFAULT 0
9748: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
9749: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
9750: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
9751: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
9752: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
9753: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 9750: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE

9746: ,p_entity_code IN VARCHAR2 DEFAULT NULL
9747: ,p_debug_level IN NUMBER DEFAULT 0
9748: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
9749: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
9750: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
9751: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
9752: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
9753: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
9754: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 9751: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

9747: ,p_debug_level IN NUMBER DEFAULT 0
9748: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
9749: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
9750: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
9751: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
9752: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
9753: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
9754: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
9755: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 9752: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

9748: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
9749: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
9750: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
9751: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
9752: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
9753: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
9754: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
9755: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
9756: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE

Line 9753: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

9749: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
9750: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
9751: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
9752: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
9753: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
9754: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
9755: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
9756: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
9757: ,x_extension_id OUT NOCOPY NUMBER

Line 9754: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

9750: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
9751: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
9752: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
9753: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
9754: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
9755: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
9756: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
9757: ,x_extension_id OUT NOCOPY NUMBER
9758: ,x_mode OUT NOCOPY VARCHAR2

Line 9755: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

9751: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
9752: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
9753: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
9754: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
9755: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
9756: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
9757: ,x_extension_id OUT NOCOPY NUMBER
9758: ,x_mode OUT NOCOPY VARCHAR2
9759: ,x_failed_row_id_list OUT NOCOPY VARCHAR2

Line 9799: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

9795:
9796: Debug_Msg(l_api_name || ' starting', 1);
9797:
9798: -- Check for call compatibility
9799: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
9800: l_api_name, G_PKG_NAME)
9801: THEN
9802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9803: END IF;

Line 9802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9798: -- Check for call compatibility
9799: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
9800: l_api_name, G_PKG_NAME)
9801: THEN
9802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9803: END IF;
9804:
9805: --------------------------------------------------------------------------------
9806: -- Start by dealing with caching, error-handling, and preliminary validations --

Line 9822: ,p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)

9818: ,p_entity_id => p_entity_id
9819: ,p_entity_index => p_entity_index
9820: ,p_entity_code => p_entity_code
9821: ,p_debug_level => p_debug_level
9822: ,p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
9823: ,p_object_name => p_object_name
9824: ,p_pk_column_name_value_pairs => p_pk_column_name_value_pairs
9825: ,p_class_code_name_value_pairs => p_class_code_name_value_pairs
9826: ,p_init_fnd_msg_list => p_init_fnd_msg_list

Line 9835: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9831:
9832: ----------------------------------------------------------------------
9833: -- If an error was found, we've already added it to the error stack --
9834: ----------------------------------------------------------------------
9835: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9836:
9837: --------------------------------------------------
9838: -- Mark every row in this instance as a failure --
9839: --------------------------------------------------

Line 9853: RAISE FND_API.G_EXC_ERROR;

9849: -- Trim the trailing ',' from x_failed_row_id_list if necessary --
9850: ------------------------------------------------------------------
9851: x_failed_row_id_list := RTRIM(x_failed_row_id_list, ',');
9852:
9853: RAISE FND_API.G_EXC_ERROR;
9854: END IF;
9855:
9856: ---------------------------------------------------------------
9857: -- If we pass the preliminary tests, we can process the data --

Line 10017: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

10013:
10014: -------------------------------------------------------
10015: -- Check whether this row was successfully processed --
10016: -------------------------------------------------------
10017: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10018:
10019: ----------------------------------------------------------------------------
10020: -- Since this row failed, put its ROW_IDENTIFIER into the failed row list --
10021: ----------------------------------------------------------------------------

Line 10030: x_return_status = FND_API.G_RET_STS_SUCCESS OR

10026: -- We keep x_return_status updated to reflect --
10027: -- the most serious error we come across --
10028: ------------------------------------------------
10029: IF (x_return_status IS NULL OR
10030: x_return_status = FND_API.G_RET_STS_SUCCESS OR
10031: (x_return_status = FND_API.G_RET_STS_ERROR AND
10032: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)) THEN
10033:
10034: x_return_status := l_return_status;

Line 10031: (x_return_status = FND_API.G_RET_STS_ERROR AND

10027: -- the most serious error we come across --
10028: ------------------------------------------------
10029: IF (x_return_status IS NULL OR
10030: x_return_status = FND_API.G_RET_STS_SUCCESS OR
10031: (x_return_status = FND_API.G_RET_STS_ERROR AND
10032: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)) THEN
10033:
10034: x_return_status := l_return_status;
10035:

Line 10032: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)) THEN

10028: ------------------------------------------------
10029: IF (x_return_status IS NULL OR
10030: x_return_status = FND_API.G_RET_STS_SUCCESS OR
10031: (x_return_status = FND_API.G_RET_STS_ERROR AND
10032: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)) THEN
10033:
10034: x_return_status := l_return_status;
10035:
10036: END IF;

Line 10051: RAISE FND_API.G_EXC_ERROR;

10047: x_msg_count := ERROR_HANDLER.Get_Message_Count();
10048:
10049: IF (x_msg_count > 0) THEN
10050:
10051: RAISE FND_API.G_EXC_ERROR;
10052:
10053: END IF;
10054:
10055: Debug_Msg('In Process_User_Attrs_Data, done', 1);

Line 10058: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)

10054:
10055: Debug_Msg('In Process_User_Attrs_Data, done', 1);
10056:
10057: Close_Business_Object_Session(
10058: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10059: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10060: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10061: );
10062:

Line 10059: ,p_log_errors => FND_API.To_Boolean(p_log_errors)

10055: Debug_Msg('In Process_User_Attrs_Data, done', 1);
10056:
10057: Close_Business_Object_Session(
10058: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10059: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10060: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10061: );
10062:
10063: IF FND_API.To_Boolean(p_commit) THEN

Line 10060: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)

10056:
10057: Close_Business_Object_Session(
10058: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10059: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10060: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10061: );
10062:
10063: IF FND_API.To_Boolean(p_commit) THEN
10064: COMMIT WORK;

Line 10063: IF FND_API.To_Boolean(p_commit) THEN

10059: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10060: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10061: );
10062:
10063: IF FND_API.To_Boolean(p_commit) THEN
10064: COMMIT WORK;
10065: END IF;
10066:
10067: IF (x_return_status IS NULL) THEN

Line 10068: x_return_status := FND_API.G_RET_STS_SUCCESS;

10064: COMMIT WORK;
10065: END IF;
10066:
10067: IF (x_return_status IS NULL) THEN
10068: x_return_status := FND_API.G_RET_STS_SUCCESS;
10069: END IF;
10070:
10071: EXCEPTION
10072:

Line 10081: WHEN FND_API.G_EXC_ERROR THEN

10077: -- it encounters. If callers want different behavior, they can establish --
10078: -- a SAVEPOINT prior to calling this procedure and ROLLBACK if we report --
10079: -- any errors. --
10080: ----------------------------------------------------------------------------
10081: WHEN FND_API.G_EXC_ERROR THEN
10082: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR ', 1);
10083:
10084: -----------------------------------------------------------------------------
10085: -- Since we want to commit all successful rows, we will always call commit --

Line 10082: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR ', 1);

10078: -- a SAVEPOINT prior to calling this procedure and ROLLBACK if we report --
10079: -- any errors. --
10080: ----------------------------------------------------------------------------
10081: WHEN FND_API.G_EXC_ERROR THEN
10082: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR ', 1);
10083:
10084: -----------------------------------------------------------------------------
10085: -- Since we want to commit all successful rows, we will always call commit --
10086: -----------------------------------------------------------------------------

Line 10087: IF FND_API.To_Boolean(p_commit) THEN

10083:
10084: -----------------------------------------------------------------------------
10085: -- Since we want to commit all successful rows, we will always call commit --
10086: -----------------------------------------------------------------------------
10087: IF FND_API.To_Boolean(p_commit) THEN
10088: COMMIT WORK;
10089: END IF;
10090:
10091: Close_Business_Object_Session(

Line 10092: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)

10088: COMMIT WORK;
10089: END IF;
10090:
10091: Close_Business_Object_Session(
10092: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10093: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10094: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10095: );
10096:

Line 10093: ,p_log_errors => FND_API.To_Boolean(p_log_errors)

10089: END IF;
10090:
10091: Close_Business_Object_Session(
10092: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10093: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10094: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10095: );
10096:
10097: x_msg_count := ERROR_HANDLER.Get_Message_Count();

Line 10094: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)

10090:
10091: Close_Business_Object_Session(
10092: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10093: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10094: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10095: );
10096:
10097: x_msg_count := ERROR_HANDLER.Get_Message_Count();
10098:

Line 10116: IF FND_API.To_Boolean(p_commit) THEN

10112: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM, 1);
10113: -----------------------------------------------------------------------------
10114: -- Since we want to commit all successful rows, we will always call commit --
10115: -----------------------------------------------------------------------------
10116: IF FND_API.To_Boolean(p_commit) THEN
10117: COMMIT WORK;
10118: END IF;
10119:
10120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10116: IF FND_API.To_Boolean(p_commit) THEN
10117: COMMIT WORK;
10118: END IF;
10119:
10120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10121:
10122: DECLARE
10123: l_token_table ERROR_HANDLER.Token_Tbl_Type;
10124: BEGIN

Line 10136: ,p_message_type => FND_API.G_RET_STS_ERROR

10132: ERROR_HANDLER.Add_Error_Message(
10133: p_message_name => 'EGO_PLSQL_ERR'
10134: ,p_application_id => 'EGO'
10135: ,p_token_tbl => l_token_table
10136: ,p_message_type => FND_API.G_RET_STS_ERROR
10137: ,p_row_identifier => G_USER_ROW_IDENTIFIER
10138: ,p_entity_id => p_entity_id
10139: ,p_entity_index => p_entity_index
10140: ,p_entity_code => p_entity_code

Line 10146: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)

10142: );
10143: END;
10144:
10145: Close_Business_Object_Session(
10146: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10147: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10148: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10149: );
10150:

Line 10147: ,p_log_errors => FND_API.To_Boolean(p_log_errors)

10143: END;
10144:
10145: Close_Business_Object_Session(
10146: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10147: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10148: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10149: );
10150:
10151: x_msg_count := ERROR_HANDLER.Get_Message_Count();

Line 10148: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)

10144:
10145: Close_Business_Object_Session(
10146: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10147: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10148: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10149: );
10150:
10151: x_msg_count := ERROR_HANDLER.Get_Message_Count();
10152:

Line 10178: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE

10174: ,p_entity_id IN NUMBER DEFAULT NULL
10175: ,p_entity_index IN NUMBER DEFAULT NULL
10176: ,p_entity_code IN VARCHAR2 DEFAULT NULL
10177: ,p_debug_level IN NUMBER DEFAULT 0
10178: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
10179: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10180: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
10181: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
10182: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

Line 10179: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

10175: ,p_entity_index IN NUMBER DEFAULT NULL
10176: ,p_entity_code IN VARCHAR2 DEFAULT NULL
10177: ,p_debug_level IN NUMBER DEFAULT 0
10178: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
10179: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10180: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
10181: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
10182: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
10183: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

Line 10180: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

10176: ,p_entity_code IN VARCHAR2 DEFAULT NULL
10177: ,p_debug_level IN NUMBER DEFAULT 0
10178: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
10179: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10180: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
10181: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
10182: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
10183: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
10184: ,x_return_status OUT NOCOPY VARCHAR2

Line 10181: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

10177: ,p_debug_level IN NUMBER DEFAULT 0
10178: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
10179: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10180: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
10181: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
10182: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
10183: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
10184: ,x_return_status OUT NOCOPY VARCHAR2
10185: ,x_errorcode OUT NOCOPY NUMBER

Line 10256: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

10252: BEGIN
10253:
10254: Debug_Msg(l_api_name||' starting', 1);
10255: -- Check for call compatibility
10256: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
10257: l_api_name, G_PKG_NAME)
10258: THEN
10259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10260: END IF;

Line 10259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10255: -- Check for call compatibility
10256: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
10257: l_api_name, G_PKG_NAME)
10258: THEN
10259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10260: END IF;
10261:
10262: Debug_Msg(l_api_name||' call compatible', 3);
10263:

Line 10291: ,p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)

10287: ,p_entity_id => p_entity_id
10288: ,p_entity_index => p_entity_index
10289: ,p_entity_code => p_entity_code
10290: ,p_debug_level => p_debug_level
10291: ,p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10292: ,p_object_name => p_object_name
10293: ,p_pk_column_name_value_pairs => p_pk_column_name_value_pairs
10294: ,p_class_code_name_value_pairs => NULL -- SSARNOBA - I'm not sure if this should be null
10295: ,p_init_fnd_msg_list => p_init_fnd_msg_list

Line 10304: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

10300:
10301: ----------------------------------------------------------------------
10302: -- If an error was found, we've already added it to the error stack --
10303: ----------------------------------------------------------------------
10304: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10305: RAISE FND_API.G_EXC_ERROR;
10306: END IF;
10307:
10308: -------------------------------------------------

Line 10305: RAISE FND_API.G_EXC_ERROR;

10301: ----------------------------------------------------------------------
10302: -- If an error was found, we've already added it to the error stack --
10303: ----------------------------------------------------------------------
10304: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10305: RAISE FND_API.G_EXC_ERROR;
10306: END IF;
10307:
10308: -------------------------------------------------
10309: -- We could have a batch metadata retrieval procedure for the *_User_Attrs_Data calls;

Line 10362: l_has_data_level_col := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(l_curr_ag_metadata_obj.EXT_TABLE_B_NAME, 'DATA_LEVEL_ID'));

10358: ,l_curr_ag_request_obj.ATTR_GROUP_TYPE
10359: ,l_curr_ag_request_obj.ATTR_GROUP_NAME);
10360:
10361: -- Determine if the EXT table has a data level column
10362: l_has_data_level_col := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(l_curr_ag_metadata_obj.EXT_TABLE_B_NAME, 'DATA_LEVEL_ID'));
10363:
10364:
10365: ----------------------------------------------------------------------
10366: -- Scan the list of enabled data levels, and see if the data level --

Line 10435: ,p_message_type => FND_API.G_RET_STS_ERROR

10431: ERROR_HANDLER.Add_Error_Message(
10432: p_message_name => 'EGO_EF_DL_AG_INVALID'
10433: ,p_application_id => 'EGO'
10434: ,p_token_tbl => l_token_table
10435: ,p_message_type => FND_API.G_RET_STS_ERROR
10436: ,p_row_identifier => G_USER_ROW_IDENTIFIER
10437: ,p_entity_id => p_entity_id
10438: ,p_entity_index => p_entity_index
10439: ,p_entity_code => p_entity_code

Line 10443: RAISE FND_API.G_EXC_ERROR;

10439: ,p_entity_code => p_entity_code
10440: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
10441: );
10442: l_token_table.DELETE();
10443: RAISE FND_API.G_EXC_ERROR;
10444: END IF;
10445:
10446: -- We've found the metadata for the data level of this attribute group
10447:

Line 10507: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

10503: ,p_entity_code => p_entity_code
10504: ,x_return_status => x_return_status
10505: );
10506:
10507: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10508: l_can_view_this_attr_group := FALSE;
10509: END IF;
10510: END IF;
10511:

Line 10570: RAISE FND_API.G_EXC_ERROR;

10566: ---------------------------------------------------------------------------
10567: -- See whether we put error messages onto the stack in the previous call --
10568: ---------------------------------------------------------------------------
10569: IF (l_requested_attr_names_table.EXISTS(-1)) THEN
10570: RAISE FND_API.G_EXC_ERROR;
10571: END IF;
10572: --===================================================================--
10573: -- Loop 1.2
10574: -- For every Attribute in our table of Attribute names, we find its --

Line 10858: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)

10854: ------------------------------------------------------
10855: -- We log all errors we got as we close our session --
10856: ------------------------------------------------------
10857: Close_Business_Object_Session(
10858: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10859: ,p_log_errors => TRUE
10860: ,p_write_to_concurrent_log => FALSE
10861: );
10862:

Line 10863: x_return_status := FND_API.G_RET_STS_SUCCESS;

10859: ,p_log_errors => TRUE
10860: ,p_write_to_concurrent_log => FALSE
10861: );
10862:
10863: x_return_status := FND_API.G_RET_STS_SUCCESS;
10864: RETURN ;
10865: END IF;
10866:
10867: --------------------------------------------------------------------

Line 11198: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)

11194: ------------------------------------------------------
11195: -- We log all errors we got as we close our session --
11196: ------------------------------------------------------
11197: Close_Business_Object_Session(
11198: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
11199: ,p_log_errors => TRUE
11200: ,p_write_to_concurrent_log => FALSE
11201: );
11202:

Line 11203: x_return_status := FND_API.G_RET_STS_SUCCESS;

11199: ,p_log_errors => TRUE
11200: ,p_write_to_concurrent_log => FALSE
11201: );
11202:
11203: x_return_status := FND_API.G_RET_STS_SUCCESS;
11204:
11205: EXCEPTION
11206:
11207: WHEN FND_API.G_EXC_ERROR THEN

Line 11207: WHEN FND_API.G_EXC_ERROR THEN

11203: x_return_status := FND_API.G_RET_STS_SUCCESS;
11204:
11205: EXCEPTION
11206:
11207: WHEN FND_API.G_EXC_ERROR THEN
11208: Debug_Msg(l_api_name || ' FND_API.G_EXC_ERROR '||SQLERRM);
11209: -----------------------------------------
11210: -- Close the cursor if it's still open --
11211: -----------------------------------------

Line 11208: Debug_Msg(l_api_name || ' FND_API.G_EXC_ERROR '||SQLERRM);

11204:
11205: EXCEPTION
11206:
11207: WHEN FND_API.G_EXC_ERROR THEN
11208: Debug_Msg(l_api_name || ' FND_API.G_EXC_ERROR '||SQLERRM);
11209: -----------------------------------------
11210: -- Close the cursor if it's still open --
11211: -----------------------------------------
11212: IF (l_cursor_id IS NOT NULL) THEN

Line 11221: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)

11217: ------------------------------------------------------
11218: -- We log all errors we got as we close our session --
11219: ------------------------------------------------------
11220: Close_Business_Object_Session(
11221: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
11222: ,p_log_errors => TRUE
11223: ,p_write_to_concurrent_log => FALSE
11224: );
11225:

Line 11226: x_return_status := FND_API.G_RET_STS_ERROR;

11222: ,p_log_errors => TRUE
11223: ,p_write_to_concurrent_log => FALSE
11224: );
11225:
11226: x_return_status := FND_API.G_RET_STS_ERROR;
11227:
11228: x_msg_count := ERROR_HANDLER.Get_Message_Count();
11229: IF (x_msg_count = 1) THEN
11230: DECLARE

Line 11254: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)

11250: ------------------------------------------------------
11251: -- We log all errors we got as we close our session --
11252: ------------------------------------------------------
11253: Close_Business_Object_Session(
11254: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
11255: ,p_log_errors => TRUE
11256: ,p_write_to_concurrent_log => FALSE
11257: );
11258:

Line 11259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11255: ,p_log_errors => TRUE
11256: ,p_write_to_concurrent_log => FALSE
11257: );
11258:
11259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11260: l_token_table(1).TOKEN_NAME := 'PKG_NAME';
11261: l_token_table(1).TOKEN_VALUE := G_PKG_NAME;
11262: l_token_table(2).TOKEN_NAME := 'API_NAME';
11263: l_token_table(2).TOKEN_VALUE := l_api_name;

Line 11271: ,p_message_type => FND_API.G_RET_STS_ERROR

11267: ERROR_HANDLER.Add_Error_Message(
11268: p_message_name => 'EGO_PLSQL_ERR'
11269: ,p_application_id => 'EGO'
11270: ,p_token_tbl => l_token_table
11271: ,p_message_type => FND_API.G_RET_STS_ERROR
11272: ,p_row_identifier => G_USER_ROW_IDENTIFIER
11273: ,p_entity_id => p_entity_id
11274: ,p_entity_index => p_entity_index
11275: ,p_entity_code => p_entity_code

Line 11308: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391

11304: ,p_attr_group_id IN NUMBER DEFAULT NULL
11305: ,p_application_id IN NUMBER DEFAULT NULL
11306: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
11307: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
11308: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
11309: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
11310: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
11311: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
11312: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 11318: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE

11314: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
11315: ,p_entity_id IN NUMBER DEFAULT NULL
11316: ,p_entity_index IN NUMBER DEFAULT NULL
11317: ,p_entity_code IN VARCHAR2 DEFAULT NULL
11318: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
11319: ,p_language_to_process IN VARCHAR2 DEFAULT NULL
11320: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
11321: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
11322: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL

Line 11325: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

11321: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
11322: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
11323: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
11324: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL
11325: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11326: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11327: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11328: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
11329: ,x_return_status OUT NOCOPY VARCHAR2

Line 11326: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

11322: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
11323: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
11324: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL
11325: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11326: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11327: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11328: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
11329: ,x_return_status OUT NOCOPY VARCHAR2
11330: ,x_errorcode OUT NOCOPY NUMBER

Line 11327: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

11323: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
11324: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL
11325: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11326: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11327: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11328: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
11329: ,x_return_status OUT NOCOPY VARCHAR2
11330: ,x_errorcode OUT NOCOPY NUMBER
11331: ,x_msg_count OUT NOCOPY NUMBER

Line 11383: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391

11379: ,p_attr_group_id IN NUMBER DEFAULT NULL
11380: ,p_application_id IN NUMBER DEFAULT NULL
11381: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
11382: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
11383: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
11384: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
11385: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
11386: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
11387: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 11393: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE

11389: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
11390: ,p_entity_id IN NUMBER DEFAULT NULL
11391: ,p_entity_index IN NUMBER DEFAULT NULL
11392: ,p_entity_code IN VARCHAR2 DEFAULT NULL
11393: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
11394: ,p_language_to_process IN VARCHAR2 DEFAULT NULL
11395: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
11396: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
11397: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL

Line 11400: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

11396: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
11397: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
11398: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
11399: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL
11400: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11401: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11402: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11403: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
11404: ,x_extension_id OUT NOCOPY NUMBER

Line 11401: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

11397: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
11398: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
11399: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL
11400: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11401: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11402: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11403: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
11404: ,x_extension_id OUT NOCOPY NUMBER
11405: ,x_mode OUT NOCOPY VARCHAR2

Line 11402: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

11398: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
11399: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL
11400: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11401: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11402: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11403: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
11404: ,x_extension_id OUT NOCOPY NUMBER
11405: ,x_mode OUT NOCOPY VARCHAR2
11406: ,x_return_status OUT NOCOPY VARCHAR2

Line 11435: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

11431: -- SAVEPOINT Process_Row_PUB;
11432: -- (See EXCEPTION notes for why this is commented out)
11433:
11434: -- Check for call compatibility
11435: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
11436: l_api_name, G_PKG_NAME)
11437: THEN
11438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11439: END IF;

Line 11438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11434: -- Check for call compatibility
11435: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
11436: l_api_name, G_PKG_NAME)
11437: THEN
11438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11439: END IF;
11440:
11441: l_object_id := p_object_id;
11442: l_attr_name_value_pairs := p_attr_name_value_pairs;

Line 11473: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

11469: ,x_extension_id => l_extension_id
11470: ,x_mode => l_mode
11471: ,x_return_status => x_return_status
11472: );
11473: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11474: RAISE FND_API.G_EXC_ERROR;
11475: END IF;
11476:
11477: IF l_extension_id IS NOT NULL THEN

Line 11474: RAISE FND_API.G_EXC_ERROR;

11470: ,x_mode => l_mode
11471: ,x_return_status => x_return_status
11472: );
11473: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11474: RAISE FND_API.G_EXC_ERROR;
11475: END IF;
11476:
11477: IF l_extension_id IS NOT NULL THEN
11478: x_extension_id := l_extension_id;

Line 11505: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

11501: ,p_entity_code => p_entity_code
11502: ,x_return_status => x_return_status
11503: );
11504:
11505: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11506: RAISE FND_API.G_EXC_ERROR;
11507: END IF;
11508: END IF;
11509:

Line 11506: RAISE FND_API.G_EXC_ERROR;

11502: ,x_return_status => x_return_status
11503: );
11504:
11505: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11506: RAISE FND_API.G_EXC_ERROR;
11507: END IF;
11508: END IF;
11509:
11510: IF (l_mode IS NULL OR

Line 11532: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

11528: ,p_mode => l_mode
11529: ,px_attr_name_value_pairs => l_attr_name_value_pairs
11530: ,x_return_status => x_return_status
11531: );
11532: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11533: RAISE FND_API.G_EXC_ERROR;
11534: END IF;
11535: END IF;
11536:

Line 11533: RAISE FND_API.G_EXC_ERROR;

11529: ,px_attr_name_value_pairs => l_attr_name_value_pairs
11530: ,x_return_status => x_return_status
11531: );
11532: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11533: RAISE FND_API.G_EXC_ERROR;
11534: END IF;
11535: END IF;
11536:
11537:

Line 11538: IF( p_validate_only = FND_API.G_FALSE) THEN

11534: END IF;
11535: END IF;
11536:
11537:
11538: IF( p_validate_only = FND_API.G_FALSE) THEN
11539:
11540: Debug_Msg(l_api_name||' done with Validate_Row_Pvt and about to call Perform_DML_On_Row_Pvt', 2);
11541:
11542: Perform_DML_On_Row_Pvt(

Line 11561: ,p_commit => FND_API.G_FALSE

11557: ,p_pending_tl_table_name => p_pending_tl_table_name
11558: ,p_entity_id => p_entity_id
11559: ,p_entity_index => p_entity_index
11560: ,p_entity_code => p_entity_code
11561: ,p_commit => FND_API.G_FALSE
11562: ,p_raise_business_event => p_raise_business_event
11563: ,x_extension_id => x_extension_id
11564: ,x_return_status => x_return_status
11565: );

Line 11566: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

11562: ,p_raise_business_event => p_raise_business_event
11563: ,x_extension_id => x_extension_id
11564: ,x_return_status => x_return_status
11565: );
11566: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11567: RAISE FND_API.G_EXC_ERROR;
11568: END IF;
11569:
11570: Debug_Msg('In Process_Row, done', 1);

Line 11567: RAISE FND_API.G_EXC_ERROR;

11563: ,x_extension_id => x_extension_id
11564: ,x_return_status => x_return_status
11565: );
11566: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11567: RAISE FND_API.G_EXC_ERROR;
11568: END IF;
11569:
11570: Debug_Msg('In Process_Row, done', 1);
11571:

Line 11574: IF FND_API.To_Boolean(p_commit) THEN

11570: Debug_Msg('In Process_Row, done', 1);
11571:
11572: END IF;
11573:
11574: IF FND_API.To_Boolean(p_commit) THEN
11575: COMMIT WORK;
11576: END IF;
11577:
11578: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 11578: x_return_status := FND_API.G_RET_STS_SUCCESS;

11574: IF FND_API.To_Boolean(p_commit) THEN
11575: COMMIT WORK;
11576: END IF;
11577:
11578: x_return_status := FND_API.G_RET_STS_SUCCESS;
11579:
11580: EXCEPTION
11581: ----------------------------------------------------------------------------
11582: -- We don't do a ROLLBACK in this exception block; all exceptions will --

Line 11594: WHEN FND_API.G_EXC_ERROR THEN

11590: -- --
11591: -- so I took out the ROLLBACK call, which wasn't necessary anyway.) --
11592: ----------------------------------------------------------------------------
11593:
11594: WHEN FND_API.G_EXC_ERROR THEN
11595: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
11596:
11597: IF FND_API.To_Boolean(p_commit) THEN
11598: COMMIT WORK;

Line 11595: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');

11591: -- so I took out the ROLLBACK call, which wasn't necessary anyway.) --
11592: ----------------------------------------------------------------------------
11593:
11594: WHEN FND_API.G_EXC_ERROR THEN
11595: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
11596:
11597: IF FND_API.To_Boolean(p_commit) THEN
11598: COMMIT WORK;
11599: END IF;

Line 11597: IF FND_API.To_Boolean(p_commit) THEN

11593:
11594: WHEN FND_API.G_EXC_ERROR THEN
11595: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
11596:
11597: IF FND_API.To_Boolean(p_commit) THEN
11598: COMMIT WORK;
11599: END IF;
11600: x_msg_count := ERROR_HANDLER.Get_Message_Count();
11601: IF (x_msg_count = 1) THEN

Line 11614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11610: END IF;
11611:
11612: WHEN OTHERS THEN
11613: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM);
11614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11615: DECLARE
11616: l_token_table ERROR_HANDLER.Token_Tbl_Type;
11617: BEGIN
11618: l_token_table(1).TOKEN_NAME := 'PKG_NAME';

Line 11629: ,p_message_type => FND_API.G_RET_STS_ERROR

11625: ERROR_HANDLER.Add_Error_Message(
11626: p_message_name => 'EGO_PLSQL_ERR'
11627: ,p_application_id => 'EGO'
11628: ,p_token_tbl => l_token_table
11629: ,p_message_type => FND_API.G_RET_STS_ERROR
11630: ,p_row_identifier => G_USER_ROW_IDENTIFIER
11631: ,p_entity_id => p_entity_id
11632: ,p_entity_index => p_entity_index
11633: ,p_entity_code => p_entity_code

Line 11676: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

11672: ,p_entity_id IN NUMBER DEFAULT NULL
11673: ,p_entity_index IN NUMBER DEFAULT NULL
11674: ,p_entity_code IN VARCHAR2 DEFAULT NULL
11675: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
11676: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
11677: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11678: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
11679: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11680: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 11677: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

11673: ,p_entity_index IN NUMBER DEFAULT NULL
11674: ,p_entity_code IN VARCHAR2 DEFAULT NULL
11675: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
11676: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
11677: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11678: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
11679: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11680: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11681: ,x_return_status OUT NOCOPY VARCHAR2

Line 11678: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

11674: ,p_entity_code IN VARCHAR2 DEFAULT NULL
11675: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
11676: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
11677: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11678: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
11679: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11680: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11681: ,x_return_status OUT NOCOPY VARCHAR2
11682: ,x_errorcode OUT NOCOPY NUMBER

Line 11679: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

11675: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
11676: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
11677: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11678: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
11679: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11680: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11681: ,x_return_status OUT NOCOPY VARCHAR2
11682: ,x_errorcode OUT NOCOPY NUMBER
11683: ,x_msg_count OUT NOCOPY NUMBER

Line 11680: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

11676: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
11677: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11678: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
11679: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11680: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11681: ,x_return_status OUT NOCOPY VARCHAR2
11682: ,x_errorcode OUT NOCOPY NUMBER
11683: ,x_msg_count OUT NOCOPY NUMBER
11684: ,x_msg_data OUT NOCOPY VARCHAR2

Line 11705: IF FND_API.To_Boolean(p_commit) THEN

11701: BEGIN
11702:
11703: Debug_Msg(l_api_name||' starting ', 1);
11704:
11705: IF FND_API.To_Boolean(p_commit) THEN
11706: SAVEPOINT Validate_Row_PUB;
11707: END IF;
11708:
11709: -- Check for call compatibility

Line 11710: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

11706: SAVEPOINT Validate_Row_PUB;
11707: END IF;
11708:
11709: -- Check for call compatibility
11710: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
11711: l_api_name, G_PKG_NAME)
11712: THEN
11713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11714: END IF;

Line 11713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11709: -- Check for call compatibility
11710: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
11711: l_api_name, G_PKG_NAME)
11712: THEN
11713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11714: END IF;
11715:
11716: -----------------------------------
11717:

Line 11746: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

11742: ,x_extension_id => l_extension_id
11743: ,x_mode => l_mode
11744: ,x_return_status => x_return_status
11745: );
11746: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11747: RAISE FND_API.G_EXC_ERROR;
11748: END IF;
11749:
11750: Debug_Msg(l_api_name||' calling Validate_Row_Pvt ', 1);

Line 11747: RAISE FND_API.G_EXC_ERROR;

11743: ,x_mode => l_mode
11744: ,x_return_status => x_return_status
11745: );
11746: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11747: RAISE FND_API.G_EXC_ERROR;
11748: END IF;
11749:
11750: Debug_Msg(l_api_name||' calling Validate_Row_Pvt ', 1);
11751: Validate_Row_Pvt(

Line 11768: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

11764: ,p_mode => l_mode
11765: ,px_attr_name_value_pairs => l_attr_name_value_pairs
11766: ,x_return_status => x_return_status
11767: );
11768: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11769: RAISE FND_API.G_EXC_ERROR;
11770: END IF;
11771:
11772: Close_Business_Object_Session(

Line 11769: RAISE FND_API.G_EXC_ERROR;

11765: ,px_attr_name_value_pairs => l_attr_name_value_pairs
11766: ,x_return_status => x_return_status
11767: );
11768: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11769: RAISE FND_API.G_EXC_ERROR;
11770: END IF;
11771:
11772: Close_Business_Object_Session(
11773: p_init_error_handler_flag => FALSE

Line 11774: ,p_log_errors => FND_API.To_Boolean(p_log_errors)

11770: END IF;
11771:
11772: Close_Business_Object_Session(
11773: p_init_error_handler_flag => FALSE
11774: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
11775: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
11776: );
11777:
11778: IF FND_API.To_Boolean(p_commit) THEN

Line 11775: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)

11771:
11772: Close_Business_Object_Session(
11773: p_init_error_handler_flag => FALSE
11774: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
11775: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
11776: );
11777:
11778: IF FND_API.To_Boolean(p_commit) THEN
11779: COMMIT WORK;

Line 11778: IF FND_API.To_Boolean(p_commit) THEN

11774: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
11775: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
11776: );
11777:
11778: IF FND_API.To_Boolean(p_commit) THEN
11779: COMMIT WORK;
11780: END IF;
11781:
11782: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 11782: x_return_status := FND_API.G_RET_STS_SUCCESS;

11778: IF FND_API.To_Boolean(p_commit) THEN
11779: COMMIT WORK;
11780: END IF;
11781:
11782: x_return_status := FND_API.G_RET_STS_SUCCESS;
11783: Debug_Msg(l_api_name||' ending ', 1);
11784:
11785: EXCEPTION
11786: WHEN FND_API.G_EXC_ERROR THEN

Line 11786: WHEN FND_API.G_EXC_ERROR THEN

11782: x_return_status := FND_API.G_RET_STS_SUCCESS;
11783: Debug_Msg(l_api_name||' ending ', 1);
11784:
11785: EXCEPTION
11786: WHEN FND_API.G_EXC_ERROR THEN
11787: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
11788: IF FND_API.To_Boolean(p_commit) THEN
11789: ROLLBACK TO Validate_Row_PUB;
11790: END IF;

Line 11787: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');

11783: Debug_Msg(l_api_name||' ending ', 1);
11784:
11785: EXCEPTION
11786: WHEN FND_API.G_EXC_ERROR THEN
11787: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
11788: IF FND_API.To_Boolean(p_commit) THEN
11789: ROLLBACK TO Validate_Row_PUB;
11790: END IF;
11791: Close_Business_Object_Session(

Line 11788: IF FND_API.To_Boolean(p_commit) THEN

11784:
11785: EXCEPTION
11786: WHEN FND_API.G_EXC_ERROR THEN
11787: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
11788: IF FND_API.To_Boolean(p_commit) THEN
11789: ROLLBACK TO Validate_Row_PUB;
11790: END IF;
11791: Close_Business_Object_Session(
11792: p_init_error_handler_flag => FALSE

Line 11793: ,p_log_errors => FND_API.To_Boolean(p_log_errors)

11789: ROLLBACK TO Validate_Row_PUB;
11790: END IF;
11791: Close_Business_Object_Session(
11792: p_init_error_handler_flag => FALSE
11793: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
11794: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
11795: );
11796:
11797: x_msg_count := ERROR_HANDLER.Get_Message_Count();

Line 11794: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)

11790: END IF;
11791: Close_Business_Object_Session(
11792: p_init_error_handler_flag => FALSE
11793: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
11794: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
11795: );
11796:
11797: x_msg_count := ERROR_HANDLER.Get_Message_Count();
11798: IF (x_msg_count = 1) THEN

Line 11811: IF FND_API.To_Boolean(p_commit) THEN

11807: END IF;
11808:
11809: WHEN OTHERS THEN
11810: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM);
11811: IF FND_API.To_Boolean(p_commit) THEN
11812: ROLLBACK TO Validate_Row_PUB;
11813: END IF;
11814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11815:

Line 11814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11810: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM);
11811: IF FND_API.To_Boolean(p_commit) THEN
11812: ROLLBACK TO Validate_Row_PUB;
11813: END IF;
11814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11815:
11816: DECLARE
11817: l_token_table ERROR_HANDLER.Token_Tbl_Type;
11818: BEGIN

Line 11830: ,p_message_type => FND_API.G_RET_STS_ERROR

11826: ERROR_HANDLER.Add_Error_Message(
11827: p_message_name => 'EGO_PLSQL_ERR'
11828: ,p_application_id => 'EGO'
11829: ,p_token_tbl => l_token_table
11830: ,p_message_type => FND_API.G_RET_STS_ERROR
11831: ,p_row_identifier => G_USER_ROW_IDENTIFIER
11832: ,p_entity_id => p_entity_id
11833: ,p_entity_index => p_entity_index
11834: ,p_entity_code => p_entity_code

Line 11841: ,p_log_errors => FND_API.To_Boolean(p_log_errors)

11837: END;
11838:
11839: Close_Business_Object_Session(
11840: p_init_error_handler_flag => FALSE
11841: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
11842: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
11843: );
11844:
11845: x_msg_count := ERROR_HANDLER.Get_Message_Count();

Line 11842: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)

11838:
11839: Close_Business_Object_Session(
11840: p_init_error_handler_flag => FALSE
11841: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
11842: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
11843: );
11844:
11845: x_msg_count := ERROR_HANDLER.Get_Message_Count();
11846:

Line 11889: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_FALSE

11885: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
11886: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
11887: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL
11888: ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL
11889: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_FALSE
11890: ,p_entity_id IN NUMBER DEFAULT NULL
11891: ,p_entity_index IN NUMBER DEFAULT NULL
11892: ,p_entity_code IN VARCHAR2 DEFAULT NULL
11893: ,p_debug_level IN NUMBER DEFAULT 0

Line 11894: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE

11890: ,p_entity_id IN NUMBER DEFAULT NULL
11891: ,p_entity_index IN NUMBER DEFAULT NULL
11892: ,p_entity_code IN VARCHAR2 DEFAULT NULL
11893: ,p_debug_level IN NUMBER DEFAULT 0
11894: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
11895: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
11896: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11897: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
11898: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 11895: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

11891: ,p_entity_index IN NUMBER DEFAULT NULL
11892: ,p_entity_code IN VARCHAR2 DEFAULT NULL
11893: ,p_debug_level IN NUMBER DEFAULT 0
11894: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
11895: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
11896: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11897: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
11898: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11899: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 11896: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

11892: ,p_entity_code IN VARCHAR2 DEFAULT NULL
11893: ,p_debug_level IN NUMBER DEFAULT 0
11894: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
11895: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
11896: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11897: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
11898: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11899: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11900: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 11897: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

11893: ,p_debug_level IN NUMBER DEFAULT 0
11894: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
11895: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
11896: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11897: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
11898: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11899: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11900: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
11901: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE

Line 11898: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

11894: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
11895: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
11896: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11897: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
11898: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11899: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11900: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
11901: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
11902: ,x_return_status OUT NOCOPY VARCHAR2

Line 11899: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

11895: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
11896: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11897: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
11898: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11899: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11900: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
11901: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
11902: ,x_return_status OUT NOCOPY VARCHAR2
11903: ,x_errorcode OUT NOCOPY NUMBER

Line 11900: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE

11896: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11897: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
11898: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11899: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11900: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
11901: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
11902: ,x_return_status OUT NOCOPY VARCHAR2
11903: ,x_errorcode OUT NOCOPY NUMBER
11904: ,x_msg_count OUT NOCOPY NUMBER

Line 11936: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

11932: BEGIN
11933:
11934: Debug_Msg(l_api_name||' starting ', 1);
11935: -- Check for call compatibility
11936: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
11937: l_api_name, G_PKG_NAME)
11938: THEN
11939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11940: END IF;

Line 11939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11935: -- Check for call compatibility
11936: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
11937: l_api_name, G_PKG_NAME)
11938: THEN
11939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11940: END IF;
11941:
11942: IF (FND_API.To_Boolean(p_init_fnd_msg_list)) THEN
11943: ERROR_HANDLER.Initialize();

Line 11942: IF (FND_API.To_Boolean(p_init_fnd_msg_list)) THEN

11938: THEN
11939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11940: END IF;
11941:
11942: IF (FND_API.To_Boolean(p_init_fnd_msg_list)) THEN
11943: ERROR_HANDLER.Initialize();
11944: END IF;
11945:
11946: G_B_TABLE_DML := '';

Line 11998: ,p_use_def_vals_on_insert_flag => FND_API.To_Boolean(p_use_def_vals_on_insert)

11994: ,p_extra_pk_col_name_val_pairs => p_extra_pk_col_name_val_pairs
11995: ,p_pending_b_table_name => p_alternate_ext_b_table_name
11996: ,p_pending_vl_name => p_alternate_ext_vl_name
11997: ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
11998: ,p_use_def_vals_on_insert_flag => FND_API.To_Boolean(p_use_def_vals_on_insert)
11999: ,p_debug_level => p_debug_level
12000: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
12001: ,px_object_id => l_object_id
12002: ,px_attr_name_value_pairs => l_attr_name_value_pairs

Line 12000: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)

11996: ,p_pending_vl_name => p_alternate_ext_vl_name
11997: ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
11998: ,p_use_def_vals_on_insert_flag => FND_API.To_Boolean(p_use_def_vals_on_insert)
11999: ,p_debug_level => p_debug_level
12000: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
12001: ,px_object_id => l_object_id
12002: ,px_attr_name_value_pairs => l_attr_name_value_pairs
12003: ,x_attr_group_metadata_obj => l_attr_group_metadata_obj
12004: ,x_ext_table_metadata_obj => l_ext_table_metadata_obj

Line 12010: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

12006: ,x_mode => l_mode
12007: ,x_return_status => x_return_status
12008: );
12009:
12010: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12011: RAISE FND_API.G_EXC_ERROR;
12012: END IF;
12013:
12014: Debug_Msg(l_api_name||' calling Perform_DML_On_Row_Pvt', 1);

Line 12011: RAISE FND_API.G_EXC_ERROR;

12007: ,x_return_status => x_return_status
12008: );
12009:
12010: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12011: RAISE FND_API.G_EXC_ERROR;
12012: END IF;
12013:
12014: Debug_Msg(l_api_name||' calling Perform_DML_On_Row_Pvt', 1);
12015: Perform_DML_On_Row_Pvt(

Line 12035: ,p_commit => FND_API.G_FALSE

12031: ,p_execute_dml => p_execute_dml
12032: ,p_entity_id => p_entity_id
12033: ,p_entity_index => p_entity_index
12034: ,p_entity_code => p_entity_code
12035: ,p_commit => FND_API.G_FALSE
12036: ,p_raise_business_event => p_raise_business_event
12037: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
12038: ,x_extension_id => l_extension_id
12039: ,x_return_status => x_return_status

Line 12037: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)

12033: ,p_entity_index => p_entity_index
12034: ,p_entity_code => p_entity_code
12035: ,p_commit => FND_API.G_FALSE
12036: ,p_raise_business_event => p_raise_business_event
12037: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
12038: ,x_extension_id => l_extension_id
12039: ,x_return_status => x_return_status
12040: );
12041: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 12041: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

12037: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
12038: ,x_extension_id => l_extension_id
12039: ,x_return_status => x_return_status
12040: );
12041: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12042: RAISE FND_API.G_EXC_ERROR;
12043: END IF;
12044:
12045: x_b_dml_for_ag := G_B_TABLE_DML;

Line 12042: RAISE FND_API.G_EXC_ERROR;

12038: ,x_extension_id => l_extension_id
12039: ,x_return_status => x_return_status
12040: );
12041: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12042: RAISE FND_API.G_EXC_ERROR;
12043: END IF;
12044:
12045: x_b_dml_for_ag := G_B_TABLE_DML;
12046: x_tl_dml_for_ag := G_TL_TABLE_DML;

Line 12087: ,p_log_errors => FND_API.To_Boolean(p_log_errors)

12083: x_tl_bind_attr_table := l_tl_dml_bind_list;
12084:
12085: Close_Business_Object_Session(
12086: p_init_error_handler_flag => (p_debug_level > 0)
12087: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12088: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12089: );
12090:
12091: IF FND_API.To_Boolean(p_commit) THEN

Line 12088: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)

12084:
12085: Close_Business_Object_Session(
12086: p_init_error_handler_flag => (p_debug_level > 0)
12087: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12088: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12089: );
12090:
12091: IF FND_API.To_Boolean(p_commit) THEN
12092: COMMIT WORK;

Line 12091: IF FND_API.To_Boolean(p_commit) THEN

12087: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12088: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12089: );
12090:
12091: IF FND_API.To_Boolean(p_commit) THEN
12092: COMMIT WORK;
12093: END IF;
12094:
12095: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 12095: x_return_status := FND_API.G_RET_STS_SUCCESS;

12091: IF FND_API.To_Boolean(p_commit) THEN
12092: COMMIT WORK;
12093: END IF;
12094:
12095: x_return_status := FND_API.G_RET_STS_SUCCESS;
12096:
12097: Debug_Msg(l_api_name||' ending ', 1);
12098:
12099: EXCEPTION

Line 12101: WHEN FND_API.G_EXC_ERROR THEN

12097: Debug_Msg(l_api_name||' ending ', 1);
12098:
12099: EXCEPTION
12100:
12101: WHEN FND_API.G_EXC_ERROR THEN
12102: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
12103:
12104: Close_Business_Object_Session(
12105: p_init_error_handler_flag => (p_debug_level > 0)

Line 12102: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');

12098:
12099: EXCEPTION
12100:
12101: WHEN FND_API.G_EXC_ERROR THEN
12102: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
12103:
12104: Close_Business_Object_Session(
12105: p_init_error_handler_flag => (p_debug_level > 0)
12106: ,p_log_errors => FND_API.To_Boolean(p_log_errors)

Line 12106: ,p_log_errors => FND_API.To_Boolean(p_log_errors)

12102: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
12103:
12104: Close_Business_Object_Session(
12105: p_init_error_handler_flag => (p_debug_level > 0)
12106: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12107: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12108: );
12109:
12110: x_msg_count := ERROR_HANDLER.Get_Message_Count();

Line 12107: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)

12103:
12104: Close_Business_Object_Session(
12105: p_init_error_handler_flag => (p_debug_level > 0)
12106: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12107: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12108: );
12109:
12110: x_msg_count := ERROR_HANDLER.Get_Message_Count();
12111: IF (x_msg_count = 1) THEN

Line 12124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

12120: END IF;
12121:
12122: WHEN OTHERS THEN
12123: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM);
12124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12125: DECLARE
12126: l_token_table ERROR_HANDLER.Token_Tbl_Type;
12127: BEGIN
12128: l_token_table(1).TOKEN_NAME := 'PKG_NAME';

Line 12139: ,p_message_type => FND_API.G_RET_STS_ERROR

12135: ERROR_HANDLER.Add_Error_Message(
12136: p_message_name => 'EGO_PLSQL_ERR'
12137: ,p_application_id => 'EGO'
12138: ,p_token_tbl => l_token_table
12139: ,p_message_type => FND_API.G_RET_STS_ERROR
12140: ,p_row_identifier => G_USER_ROW_IDENTIFIER
12141: ,p_entity_id => p_entity_id
12142: ,p_entity_index => p_entity_index
12143: ,p_entity_code => p_entity_code

Line 12150: ,p_log_errors => FND_API.To_Boolean(p_log_errors)

12146: END;
12147:
12148: Close_Business_Object_Session(
12149: p_init_error_handler_flag => (p_debug_level > 0)
12150: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12151: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12152: );
12153:
12154: x_msg_count := ERROR_HANDLER.Get_Message_Count();

Line 12151: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)

12147:
12148: Close_Business_Object_Session(
12149: p_init_error_handler_flag => (p_debug_level > 0)
12150: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12151: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12152: );
12153:
12154: x_msg_count := ERROR_HANDLER.Get_Message_Count();
12155:

Line 12270: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE

12266: ,p_entity_id IN NUMBER DEFAULT NULL
12267: ,p_entity_index IN NUMBER DEFAULT NULL
12268: ,p_entity_code IN VARCHAR2 DEFAULT NULL
12269: ,p_debug_level IN NUMBER DEFAULT 0
12270: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
12271: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12272: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12273: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12274: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 12271: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

12267: ,p_entity_index IN NUMBER DEFAULT NULL
12268: ,p_entity_code IN VARCHAR2 DEFAULT NULL
12269: ,p_debug_level IN NUMBER DEFAULT 0
12270: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
12271: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12272: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12273: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12274: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12275: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 12272: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

12268: ,p_entity_code IN VARCHAR2 DEFAULT NULL
12269: ,p_debug_level IN NUMBER DEFAULT 0
12270: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
12271: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12272: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12273: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12274: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12275: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12276: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 12273: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

12269: ,p_debug_level IN NUMBER DEFAULT 0
12270: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
12271: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12272: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12273: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12274: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12275: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12276: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
12277: ,x_return_status OUT NOCOPY VARCHAR2

Line 12274: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

12270: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
12271: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12272: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12273: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12274: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12275: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12276: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
12277: ,x_return_status OUT NOCOPY VARCHAR2
12278: ,x_errorcode OUT NOCOPY NUMBER

Line 12275: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

12271: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12272: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12273: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12274: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12275: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12276: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
12277: ,x_return_status OUT NOCOPY VARCHAR2
12278: ,x_errorcode OUT NOCOPY NUMBER
12279: ,x_msg_count OUT NOCOPY NUMBER

Line 12276: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE

12272: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12273: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12274: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12275: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12276: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
12277: ,x_return_status OUT NOCOPY VARCHAR2
12278: ,x_errorcode OUT NOCOPY NUMBER
12279: ,x_msg_count OUT NOCOPY NUMBER
12280: ,x_msg_data OUT NOCOPY VARCHAR2

Line 12353: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE

12349: ,p_entity_id IN NUMBER DEFAULT NULL
12350: ,p_entity_index IN NUMBER DEFAULT NULL
12351: ,p_entity_code IN VARCHAR2 DEFAULT NULL
12352: ,p_debug_level IN NUMBER DEFAULT 0
12353: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
12354: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12355: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12356: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12357: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 12354: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

12350: ,p_entity_index IN NUMBER DEFAULT NULL
12351: ,p_entity_code IN VARCHAR2 DEFAULT NULL
12352: ,p_debug_level IN NUMBER DEFAULT 0
12353: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
12354: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12355: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12356: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12357: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12358: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 12355: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

12351: ,p_entity_code IN VARCHAR2 DEFAULT NULL
12352: ,p_debug_level IN NUMBER DEFAULT 0
12353: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
12354: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12355: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12356: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12357: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12358: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12359: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 12356: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

12352: ,p_debug_level IN NUMBER DEFAULT 0
12353: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
12354: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12355: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12356: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12357: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12358: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12359: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
12360: ,x_extension_id OUT NOCOPY NUMBER

Line 12357: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

12353: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
12354: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12355: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12356: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12357: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12358: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12359: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
12360: ,x_extension_id OUT NOCOPY NUMBER
12361: ,x_mode OUT NOCOPY VARCHAR2

Line 12358: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

12354: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12355: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12356: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12357: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12358: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12359: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
12360: ,x_extension_id OUT NOCOPY NUMBER
12361: ,x_mode OUT NOCOPY VARCHAR2
12362: ,x_return_status OUT NOCOPY VARCHAR2

Line 12359: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE

12355: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12356: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12357: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12358: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12359: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
12360: ,x_extension_id OUT NOCOPY NUMBER
12361: ,x_mode OUT NOCOPY VARCHAR2
12362: ,x_return_status OUT NOCOPY VARCHAR2
12363: ,x_errorcode OUT NOCOPY NUMBER

Line 12387: IF FND_API.To_Boolean(p_commit) THEN

12383: BEGIN
12384:
12385: Debug_Msg(l_api_name||' starting with data_level = '||p_data_level, 1);
12386:
12387: IF FND_API.To_Boolean(p_commit) THEN
12388: SAVEPOINT Perform_DML_On_Row_PUB;
12389: END IF;
12390:
12391: -- Check for call compatibility

Line 12392: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

12388: SAVEPOINT Perform_DML_On_Row_PUB;
12389: END IF;
12390:
12391: -- Check for call compatibility
12392: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
12393: l_api_name, G_PKG_NAME)
12394: THEN
12395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12396: END IF;

Line 12395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

12391: -- Check for call compatibility
12392: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
12393: l_api_name, G_PKG_NAME)
12394: THEN
12395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12396: END IF;
12397:
12398: IF (FND_API.To_Boolean(p_init_fnd_msg_list)) THEN
12399: ERROR_HANDLER.Initialize();

Line 12398: IF (FND_API.To_Boolean(p_init_fnd_msg_list)) THEN

12394: THEN
12395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12396: END IF;
12397:
12398: IF (FND_API.To_Boolean(p_init_fnd_msg_list)) THEN
12399: ERROR_HANDLER.Initialize();
12400: END IF;
12401: G_SYNC_TO_UPDATE := 'N';
12402: l_object_id := p_object_id;

Line 12425: ,p_use_def_vals_on_insert_flag => FND_API.To_Boolean(p_use_def_vals_on_insert)

12421: ,p_change_obj => p_change_obj
12422: ,p_pending_b_table_name => p_pending_b_table_name
12423: ,p_pending_vl_name => p_pending_vl_name
12424: ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
12425: ,p_use_def_vals_on_insert_flag => FND_API.To_Boolean(p_use_def_vals_on_insert)
12426: ,p_debug_level => p_debug_level
12427: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
12428: ,px_object_id => l_object_id
12429: ,px_attr_name_value_pairs => l_attr_name_value_pairs

Line 12427: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)

12423: ,p_pending_vl_name => p_pending_vl_name
12424: ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
12425: ,p_use_def_vals_on_insert_flag => FND_API.To_Boolean(p_use_def_vals_on_insert)
12426: ,p_debug_level => p_debug_level
12427: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
12428: ,px_object_id => l_object_id
12429: ,px_attr_name_value_pairs => l_attr_name_value_pairs
12430: ,x_attr_group_metadata_obj => l_attr_group_metadata_obj
12431: ,x_ext_table_metadata_obj => l_ext_table_metadata_obj

Line 12442: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

12438: AND p_attr_group_type in ('EGO_ITEM_GTIN_ATTRS','EGO_ITEM_GTIN_MULTI_ATTRS'))
12439: THEN
12440: G_SYNC_TO_UPDATE := 'Y' ;
12441: END IF;
12442: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12443: RAISE FND_API.G_EXC_ERROR;
12444: END IF;
12445:
12446: l_extension_id := x_extension_id;

Line 12443: RAISE FND_API.G_EXC_ERROR;

12439: THEN
12440: G_SYNC_TO_UPDATE := 'Y' ;
12441: END IF;
12442: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12443: RAISE FND_API.G_EXC_ERROR;
12444: END IF;
12445:
12446: l_extension_id := x_extension_id;
12447: l_mode := x_mode;

Line 12469: ,p_commit => FND_API.G_FALSE

12465: ,p_pending_tl_table_name => p_pending_tl_table_name
12466: ,p_entity_id => p_entity_id
12467: ,p_entity_index => p_entity_index
12468: ,p_entity_code => p_entity_code
12469: ,p_commit => FND_API.G_FALSE
12470: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
12471: ,x_extension_id => x_extension_id
12472: ,x_return_status => x_return_status
12473: );

Line 12470: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)

12466: ,p_entity_id => p_entity_id
12467: ,p_entity_index => p_entity_index
12468: ,p_entity_code => p_entity_code
12469: ,p_commit => FND_API.G_FALSE
12470: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
12471: ,x_extension_id => x_extension_id
12472: ,x_return_status => x_return_status
12473: );
12474: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 12474: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

12470: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
12471: ,x_extension_id => x_extension_id
12472: ,x_return_status => x_return_status
12473: );
12474: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12475: RAISE FND_API.G_EXC_ERROR;
12476: END IF;
12477:
12478: Close_Business_Object_Session(

Line 12475: RAISE FND_API.G_EXC_ERROR;

12471: ,x_extension_id => x_extension_id
12472: ,x_return_status => x_return_status
12473: );
12474: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12475: RAISE FND_API.G_EXC_ERROR;
12476: END IF;
12477:
12478: Close_Business_Object_Session(
12479: p_init_error_handler_flag => (p_debug_level > 0)

Line 12480: ,p_log_errors => FND_API.To_Boolean(p_log_errors)

12476: END IF;
12477:
12478: Close_Business_Object_Session(
12479: p_init_error_handler_flag => (p_debug_level > 0)
12480: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12481: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12482: );
12483:
12484: IF FND_API.To_Boolean(p_commit) THEN

Line 12481: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)

12477:
12478: Close_Business_Object_Session(
12479: p_init_error_handler_flag => (p_debug_level > 0)
12480: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12481: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12482: );
12483:
12484: IF FND_API.To_Boolean(p_commit) THEN
12485: COMMIT WORK;

Line 12484: IF FND_API.To_Boolean(p_commit) THEN

12480: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12481: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12482: );
12483:
12484: IF FND_API.To_Boolean(p_commit) THEN
12485: COMMIT WORK;
12486: END IF;
12487:
12488: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 12488: x_return_status := FND_API.G_RET_STS_SUCCESS;

12484: IF FND_API.To_Boolean(p_commit) THEN
12485: COMMIT WORK;
12486: END IF;
12487:
12488: x_return_status := FND_API.G_RET_STS_SUCCESS;
12489:
12490: EXCEPTION
12491: WHEN FND_API.G_EXC_ERROR THEN
12492: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');

Line 12491: WHEN FND_API.G_EXC_ERROR THEN

12487:
12488: x_return_status := FND_API.G_RET_STS_SUCCESS;
12489:
12490: EXCEPTION
12491: WHEN FND_API.G_EXC_ERROR THEN
12492: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
12493: IF FND_API.To_Boolean(p_commit) THEN
12494: ROLLBACK TO Perform_DML_On_Row_PUB;
12495: END IF;

Line 12492: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');

12488: x_return_status := FND_API.G_RET_STS_SUCCESS;
12489:
12490: EXCEPTION
12491: WHEN FND_API.G_EXC_ERROR THEN
12492: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
12493: IF FND_API.To_Boolean(p_commit) THEN
12494: ROLLBACK TO Perform_DML_On_Row_PUB;
12495: END IF;
12496: Close_Business_Object_Session(

Line 12493: IF FND_API.To_Boolean(p_commit) THEN

12489:
12490: EXCEPTION
12491: WHEN FND_API.G_EXC_ERROR THEN
12492: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
12493: IF FND_API.To_Boolean(p_commit) THEN
12494: ROLLBACK TO Perform_DML_On_Row_PUB;
12495: END IF;
12496: Close_Business_Object_Session(
12497: p_init_error_handler_flag => (p_debug_level > 0)

Line 12498: ,p_log_errors => FND_API.To_Boolean(p_log_errors)

12494: ROLLBACK TO Perform_DML_On_Row_PUB;
12495: END IF;
12496: Close_Business_Object_Session(
12497: p_init_error_handler_flag => (p_debug_level > 0)
12498: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12499: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12500: );
12501:
12502: x_msg_count := ERROR_HANDLER.Get_Message_Count();

Line 12499: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)

12495: END IF;
12496: Close_Business_Object_Session(
12497: p_init_error_handler_flag => (p_debug_level > 0)
12498: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12499: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12500: );
12501:
12502: x_msg_count := ERROR_HANDLER.Get_Message_Count();
12503: IF (x_msg_count = 1) THEN

Line 12516: IF FND_API.To_Boolean(p_commit) THEN

12512: END IF;
12513:
12514: WHEN OTHERS THEN
12515: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM);
12516: IF FND_API.To_Boolean(p_commit) THEN
12517: ROLLBACK TO Perform_DML_On_Row_PUB;
12518: END IF;
12519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12520:

Line 12519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

12515: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM);
12516: IF FND_API.To_Boolean(p_commit) THEN
12517: ROLLBACK TO Perform_DML_On_Row_PUB;
12518: END IF;
12519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12520:
12521: DECLARE
12522: l_token_table ERROR_HANDLER.Token_Tbl_Type;
12523: BEGIN

Line 12535: ,p_message_type => FND_API.G_RET_STS_ERROR

12531: ERROR_HANDLER.Add_Error_Message(
12532: p_message_name => 'EGO_PLSQL_ERR'
12533: ,p_application_id => 'EGO'
12534: ,p_token_tbl => l_token_table
12535: ,p_message_type => FND_API.G_RET_STS_ERROR
12536: ,p_row_identifier => G_USER_ROW_IDENTIFIER
12537: ,p_entity_id => p_entity_id
12538: ,p_entity_index => p_entity_index
12539: ,p_entity_code => p_entity_code

Line 12546: ,p_log_errors => FND_API.To_Boolean(p_log_errors)

12542: END;
12543:
12544: Close_Business_Object_Session(
12545: p_init_error_handler_flag => (p_debug_level > 0)
12546: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12547: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12548: );
12549:
12550: x_msg_count := ERROR_HANDLER.Get_Message_Count();

Line 12547: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)

12543:
12544: Close_Business_Object_Session(
12545: p_init_error_handler_flag => (p_debug_level > 0)
12546: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12547: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12548: );
12549:
12550: x_msg_count := ERROR_HANDLER.Get_Message_Count();
12551:

Line 12579: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

12575: ,p_data_level IN VARCHAR2 DEFAULT NULL
12576: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
12577: ,p_attr_group_ids_to_exclude IN EGO_NUMBER_TBL_TYPE DEFAULT NULL
12578: ,p_debug_level IN NUMBER DEFAULT 0
12579: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12580: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12581: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12582: ,x_return_status OUT NOCOPY VARCHAR2
12583: ,x_errorcode OUT NOCOPY NUMBER

Line 12580: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

12576: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
12577: ,p_attr_group_ids_to_exclude IN EGO_NUMBER_TBL_TYPE DEFAULT NULL
12578: ,p_debug_level IN NUMBER DEFAULT 0
12579: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12580: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12581: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12582: ,x_return_status OUT NOCOPY VARCHAR2
12583: ,x_errorcode OUT NOCOPY NUMBER
12584: ,x_msg_count OUT NOCOPY NUMBER

Line 12581: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

12577: ,p_attr_group_ids_to_exclude IN EGO_NUMBER_TBL_TYPE DEFAULT NULL
12578: ,p_debug_level IN NUMBER DEFAULT 0
12579: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12580: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12581: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12582: ,x_return_status OUT NOCOPY VARCHAR2
12583: ,x_errorcode OUT NOCOPY NUMBER
12584: ,x_msg_count OUT NOCOPY NUMBER
12585: ,x_msg_data OUT NOCOPY VARCHAR2

Line 12644: IF FND_API.To_Boolean(p_commit) THEN

12640:
12641: BEGIN
12642: Debug_Msg(l_api_name||' starting ', 1);
12643:
12644: IF FND_API.To_Boolean(p_commit) THEN
12645: SAVEPOINT Perform_DML_From_Template;
12646: END IF;
12647:
12648: -- Check for call compatibility

Line 12649: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

12645: SAVEPOINT Perform_DML_From_Template;
12646: END IF;
12647:
12648: -- Check for call compatibility
12649: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
12650: l_api_name, G_PKG_NAME)
12651: THEN
12652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12653: END IF;

Line 12652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

12648: -- Check for call compatibility
12649: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
12650: l_api_name, G_PKG_NAME)
12651: THEN
12652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12653: END IF;
12654:
12655: ------------------------------------------------------------------
12656: -- Initialize the Business Object (flags, error-handling, etc.) --

Line 12670: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

12666: ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
12667: ,p_default_user_row_identifier => l_row_index
12668: ,x_return_status => x_return_status
12669: );
12670: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12671: RAISE FND_API.G_EXC_ERROR;
12672: END IF;
12673:
12674: ----------------------------------------------

Line 12671: RAISE FND_API.G_EXC_ERROR;

12667: ,p_default_user_row_identifier => l_row_index
12668: ,x_return_status => x_return_status
12669: );
12670: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12671: RAISE FND_API.G_EXC_ERROR;
12672: END IF;
12673:
12674: ----------------------------------------------
12675: -- Get the Object ID and Ext Table metadata --

Line 12978: IF FND_API.TO_BOOLEAN(l_Perform_DML_On_Template_Row) THEN

12974: ,x_data_level_id => l_data_level_id
12975: ,x_name_value_pair_valid => l_Perform_DML_On_Template_Row
12976: );
12977:
12978: IF FND_API.TO_BOOLEAN(l_Perform_DML_On_Template_Row) THEN
12979: Debug_Msg(l_api_name ||' CALLING Perform_DML_On_Template_Row in the loop ',1);
12980: Perform_DML_On_Template_Row(
12981: p_object_id => l_object_id
12982: ,p_attr_group_metadata_obj => l_attr_group_metadata_obj

Line 12989: ,p_commit => FND_API.G_FALSE -- we don't commit until the end

12985: ,p_class_code_name_value_pairs => p_class_code_name_value_pairs
12986: ,p_data_level => p_data_level
12987: ,p_data_level_name_value_pairs => p_data_level_name_value_pairs
12988: ,px_attr_name_value_pairs => l_attr_name_value_pairs
12989: ,p_commit => FND_API.G_FALSE -- we don't commit until the end
12990: );
12991: ELSE
12992: Debug_Msg(l_api_name ||' no need to call Perform_DML_On_Template_Row in the loop ',1);
12993: END IF;

Line 13022: ,p_message_type => FND_API.G_RET_STS_ERROR

13018: ERROR_HANDLER.Add_Error_Message(
13019: p_message_name => 'EGO_EF_ATTR_GROUP_ID_NOT_FOUND'
13020: ,p_application_id => 'EGO'
13021: ,p_token_tbl => l_token_table
13022: ,p_message_type => FND_API.G_RET_STS_ERROR
13023: ,p_row_identifier => l_row_index + 1 --we haven't incremented yet
13024: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
13025: );
13026:

Line 13027: RAISE FND_API.G_EXC_ERROR;

13023: ,p_row_identifier => l_row_index + 1 --we haven't incremented yet
13024: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
13025: );
13026:
13027: RAISE FND_API.G_EXC_ERROR;
13028: END IF;
13029: END IF;
13030: END IF;
13031:

Line 13047: ,p_message_type => FND_API.G_RET_STS_ERROR

13043: ERROR_HANDLER.Add_Error_Message(
13044: p_message_name => 'EGO_EF_ATTR_ID_NOT_FOUND'
13045: ,p_application_id => 'EGO'
13046: ,p_token_tbl => l_token_table
13047: ,p_message_type => FND_API.G_RET_STS_ERROR
13048: ,p_row_identifier => l_row_index + 1 --we haven't incremented yet
13049: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
13050: );
13051:

Line 13052: RAISE FND_API.G_EXC_ERROR;

13048: ,p_row_identifier => l_row_index + 1 --we haven't incremented yet
13049: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
13050: );
13051:
13052: RAISE FND_API.G_EXC_ERROR;
13053: END IF;
13054:
13055: ------------------------------------------------------------------
13056: -- Whether or not we're at the start of a row, we've fetched a --

Line 13138: IF FND_API.TO_BOOLEAN(l_Perform_DML_On_Template_Row) THEN

13134: ,x_data_level_id => l_data_level_id
13135: ,x_name_value_pair_valid => l_Perform_DML_On_Template_Row
13136: );
13137:
13138: IF FND_API.TO_BOOLEAN(l_Perform_DML_On_Template_Row) THEN
13139: Debug_Msg(l_api_name || ' CALLING Perform_DML_On_Template_Row for data level out of loop',1);
13140: Perform_DML_On_Template_Row(
13141: p_object_id => l_object_id
13142: ,p_attr_group_metadata_obj => l_attr_group_metadata_obj

Line 13149: ,p_commit => FND_API.G_FALSE -- we don't commit until the end

13145: ,p_class_code_name_value_pairs => p_class_code_name_value_pairs
13146: ,p_data_level => p_data_level
13147: ,p_data_level_name_value_pairs => p_data_level_name_value_pairs
13148: ,px_attr_name_value_pairs => l_attr_name_value_pairs
13149: ,p_commit => FND_API.G_FALSE -- we don't commit until the end
13150: );
13151: ELSE
13152: Debug_Msg(l_api_name || ' no need to call Perform_DML_On_Template_Row for data level out of loop',1);
13153: END IF;

Line 13158: IF FND_API.To_Boolean(p_commit) THEN

13154: --End Bug 5211171
13155:
13156: END IF;
13157:
13158: IF FND_API.To_Boolean(p_commit) THEN
13159: COMMIT WORK;
13160: END IF;
13161:
13162: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 13162: x_return_status := FND_API.G_RET_STS_SUCCESS;

13158: IF FND_API.To_Boolean(p_commit) THEN
13159: COMMIT WORK;
13160: END IF;
13161:
13162: x_return_status := FND_API.G_RET_STS_SUCCESS;
13163: Debug_Msg(l_api_name||' done ',1);
13164: G_ENABLE_DEBUG := FALSE;
13165:
13166: EXCEPTION

Line 13167: WHEN FND_API.G_EXC_ERROR THEN

13163: Debug_Msg(l_api_name||' done ',1);
13164: G_ENABLE_DEBUG := FALSE;
13165:
13166: EXCEPTION
13167: WHEN FND_API.G_EXC_ERROR THEN
13168: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
13169: IF FND_API.To_Boolean(p_commit) THEN
13170: ROLLBACK TO Perform_DML_From_Template;
13171: END IF;

Line 13168: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');

13164: G_ENABLE_DEBUG := FALSE;
13165:
13166: EXCEPTION
13167: WHEN FND_API.G_EXC_ERROR THEN
13168: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
13169: IF FND_API.To_Boolean(p_commit) THEN
13170: ROLLBACK TO Perform_DML_From_Template;
13171: END IF;
13172: x_return_status := FND_API.G_RET_STS_ERROR;

Line 13169: IF FND_API.To_Boolean(p_commit) THEN

13165:
13166: EXCEPTION
13167: WHEN FND_API.G_EXC_ERROR THEN
13168: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
13169: IF FND_API.To_Boolean(p_commit) THEN
13170: ROLLBACK TO Perform_DML_From_Template;
13171: END IF;
13172: x_return_status := FND_API.G_RET_STS_ERROR;
13173:

Line 13172: x_return_status := FND_API.G_RET_STS_ERROR;

13168: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
13169: IF FND_API.To_Boolean(p_commit) THEN
13170: ROLLBACK TO Perform_DML_From_Template;
13171: END IF;
13172: x_return_status := FND_API.G_RET_STS_ERROR;
13173:
13174: x_msg_count := ERROR_HANDLER.Get_Message_Count();
13175:
13176: IF (x_msg_count > 0) THEN

Line 13201: IF FND_API.To_Boolean(p_commit) THEN

13197: END IF;
13198:
13199: WHEN OTHERS THEN
13200: Debug_Msg(l_api_name || ' EXCEPTION OTHERS'||SQLERRM);
13201: IF FND_API.To_Boolean(p_commit) THEN
13202: ROLLBACK TO Perform_DML_From_Template;
13203: END IF;
13204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13205:

Line 13204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

13200: Debug_Msg(l_api_name || ' EXCEPTION OTHERS'||SQLERRM);
13201: IF FND_API.To_Boolean(p_commit) THEN
13202: ROLLBACK TO Perform_DML_From_Template;
13203: END IF;
13204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13205:
13206: l_token_table(1).TOKEN_NAME := 'PKG_NAME';
13207: l_token_table(1).TOKEN_VALUE := G_PKG_NAME;
13208: l_token_table(2).TOKEN_NAME := 'API_NAME';

Line 13217: ,p_message_type => FND_API.G_RET_STS_ERROR

13213: ERROR_HANDLER.Add_Error_Message(
13214: p_message_name => 'EGO_PLSQL_ERR'
13215: ,p_application_id => 'EGO'
13216: ,p_token_tbl => l_token_table
13217: ,p_message_type => FND_API.G_RET_STS_ERROR
13218: ,p_row_identifier => l_row_index
13219: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
13220: );
13221:

Line 13261: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE

13257: ,p_new_data_level_id IN NUMBER DEFAULT NULL
13258: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13259: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13260: ,p_attr_group_list IN VARCHAR2 DEFAULT NULL
13261: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
13262: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13263: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13264: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13265: ,x_return_status OUT NOCOPY VARCHAR2

Line 13262: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

13258: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13259: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13260: ,p_attr_group_list IN VARCHAR2 DEFAULT NULL
13261: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
13262: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13263: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13264: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13265: ,x_return_status OUT NOCOPY VARCHAR2
13266: ,x_errorcode OUT NOCOPY NUMBER

Line 13263: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

13259: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13260: ,p_attr_group_list IN VARCHAR2 DEFAULT NULL
13261: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
13262: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13263: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13264: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13265: ,x_return_status OUT NOCOPY VARCHAR2
13266: ,x_errorcode OUT NOCOPY NUMBER
13267: ,x_msg_count OUT NOCOPY NUMBER

Line 13264: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

13260: ,p_attr_group_list IN VARCHAR2 DEFAULT NULL
13261: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
13262: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13263: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13264: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13265: ,x_return_status OUT NOCOPY VARCHAR2
13266: ,x_errorcode OUT NOCOPY NUMBER
13267: ,x_msg_count OUT NOCOPY NUMBER
13268: ,x_msg_data OUT NOCOPY VARCHAR2

Line 13337: IF FND_API.To_Boolean(p_commit) THEN

13333: BEGIN
13334:
13335: Debug_Msg(l_api_name || ' Starting ');
13336:
13337: IF FND_API.To_Boolean(p_commit) THEN
13338: SAVEPOINT Copy_User_Attrs_Data_PUB;
13339: END IF;
13340:
13341: -- Initialize FND_MSG_PUB if necessary

Line 13342: IF (FND_API.To_Boolean(p_init_fnd_msg_list)) THEN

13338: SAVEPOINT Copy_User_Attrs_Data_PUB;
13339: END IF;
13340:
13341: -- Initialize FND_MSG_PUB if necessary
13342: IF (FND_API.To_Boolean(p_init_fnd_msg_list)) THEN
13343: FND_MSG_PUB.Initialize;
13344: END IF;
13345:
13346: -- Initialize ERROR_HANDLER if necessary

Line 13347: IF (FND_API.To_Boolean(p_init_error_handler)) THEN

13343: FND_MSG_PUB.Initialize;
13344: END IF;
13345:
13346: -- Initialize ERROR_HANDLER if necessary
13347: IF (FND_API.To_Boolean(p_init_error_handler)) THEN
13348: ERROR_HANDLER.Initialize();
13349: END IF;
13350:
13351: -- Check for call compatibility

Line 13352: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

13348: ERROR_HANDLER.Initialize();
13349: END IF;
13350:
13351: -- Check for call compatibility
13352: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
13353: l_api_name, G_PKG_NAME)
13354: THEN
13355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13356: END IF;

Line 13355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

13351: -- Check for call compatibility
13352: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
13353: l_api_name, G_PKG_NAME)
13354: THEN
13355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13356: END IF;
13357:
13358: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
13359: G_ADD_ERRORS_TO_FND_STACK := 'Y';

Line 13358: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN

13354: THEN
13355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13356: END IF;
13357:
13358: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
13359: G_ADD_ERRORS_TO_FND_STACK := 'Y';
13360: ELSE
13361: G_ADD_ERRORS_TO_FND_STACK := 'N';
13362: END IF;

Line 13392: RAISE FND_API.G_EXC_ERROR;

13388: END IF;
13389: -- processing the pk cols
13390: IF (p_old_pk_col_value_pairs.COUNT <> p_new_pk_col_value_pairs.COUNT) THEN
13391: x_msg_data := 'EGO_EF_CP_PK_COL_COUNT_ERR';
13392: RAISE FND_API.G_EXC_ERROR;
13393: END IF;
13394:
13395: l_pk_index := p_old_pk_col_value_pairs.FIRST;
13396: WHILE (l_pk_index <= p_old_pk_col_value_pairs.LAST)

Line 13411: RAISE FND_API.G_EXC_ERROR;

13407: END IF;
13408: l_where_not_in_sql := l_where_not_in_sql ||'''' ||l_pk_col_metadata_array(l_pk_index).COL_NAME ||''', ' ;
13409: ELSE
13410: x_msg_data := 'EGO_EF_CP_PK_COL_NAME_ERR';
13411: RAISE FND_API.G_EXC_ERROR;
13412: END IF;
13413:
13414: l_pk_index := p_old_pk_col_value_pairs.NEXT(l_pk_index);
13415: END LOOP;

Line 13462: RAISE FND_API.G_EXC_ERROR;

13458: IF (p_old_dtlevel_col_value_pairs IS NULL AND
13459: p_new_dtlevel_col_value_pairs IS NULL AND
13460: l_data_level_metadata_array IS NOT NULL) THEN
13461: x_msg_data := 'EGO_EF_CP_DL_NOT_PASSED_ERR';
13462: RAISE FND_API.G_EXC_ERROR;
13463: ELSIF (p_old_dtlevel_col_value_pairs IS NOT NULL AND
13464: p_new_dtlevel_col_value_pairs IS NOT NULL) THEN
13465: IF (p_old_dtlevel_col_value_pairs.COUNT <> p_new_dtlevel_col_value_pairs.COUNT) THEN
13466: x_msg_data := 'EGO_EF_CP_DL_COUNT_ERR';

Line 13467: RAISE FND_API.G_EXC_ERROR;

13463: ELSIF (p_old_dtlevel_col_value_pairs IS NOT NULL AND
13464: p_new_dtlevel_col_value_pairs IS NOT NULL) THEN
13465: IF (p_old_dtlevel_col_value_pairs.COUNT <> p_new_dtlevel_col_value_pairs.COUNT) THEN
13466: x_msg_data := 'EGO_EF_CP_DL_COUNT_ERR';
13467: RAISE FND_API.G_EXC_ERROR;
13468: END IF;
13469: l_dtlevel_index := p_old_dtlevel_col_value_pairs.FIRST;
13470: WHILE (l_dtlevel_index <= p_old_dtlevel_col_value_pairs.LAST)
13471: LOOP

Line 13488: RAISE FND_API.G_EXC_ERROR;

13484: l_insert_dtlevel_sql := l_insert_dtlevel_sql ||p_old_dtlevel_col_value_pairs(l_dtlevel_index).NAME ||', ';
13485: l_where_not_in_sql := l_where_not_in_sql ||'''' ||l_data_level_metadata_array(l_dtlevel_index).COL_NAME ||''', ';
13486: ELSE
13487: x_msg_data := 'EGO_EF_CP_DL_NAME_ERR';
13488: RAISE FND_API.G_EXC_ERROR;
13489: END IF;
13490: l_dtlevel_index := p_old_dtlevel_col_value_pairs.NEXT(l_dtlevel_index);
13491: END LOOP;
13492: END IF; -- if data level IS NOT NULL

Line 13572: l_has_data_level_id := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(

13568: FROM EGO_ATTR_GROUP_TYPES_V
13569: WHERE APPLICATION_ID = p_application_id
13570: AND ATTR_GROUP_TYPE = group_rec.ATTR_GROUP_TYPE;
13571:
13572: l_has_data_level_id := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
13573: p_table_name => l_b_table_name
13574: ,p_column_name => 'DATA_LEVEL_ID')
13575: );
13576: IF l_has_data_level_id THEN

Line 13810: IF FND_API.To_Boolean(p_commit) THEN

13806: END LOOP;
13807: CLOSE l_dynamic_cursor;
13808: END LOOP;
13809:
13810: IF FND_API.To_Boolean(p_commit) THEN
13811: COMMIT WORK;
13812: END IF;
13813:
13814: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 13814: x_return_status := FND_API.G_RET_STS_SUCCESS;

13810: IF FND_API.To_Boolean(p_commit) THEN
13811: COMMIT WORK;
13812: END IF;
13813:
13814: x_return_status := FND_API.G_RET_STS_SUCCESS;
13815:
13816: EXCEPTION
13817: WHEN FND_API.G_EXC_ERROR THEN
13818: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');

Line 13817: WHEN FND_API.G_EXC_ERROR THEN

13813:
13814: x_return_status := FND_API.G_RET_STS_SUCCESS;
13815:
13816: EXCEPTION
13817: WHEN FND_API.G_EXC_ERROR THEN
13818: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
13819: IF FND_API.To_Boolean(p_commit) THEN
13820: ROLLBACK TO Copy_User_Attrs_Data_PUB;
13821: END IF;

Line 13818: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');

13814: x_return_status := FND_API.G_RET_STS_SUCCESS;
13815:
13816: EXCEPTION
13817: WHEN FND_API.G_EXC_ERROR THEN
13818: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
13819: IF FND_API.To_Boolean(p_commit) THEN
13820: ROLLBACK TO Copy_User_Attrs_Data_PUB;
13821: END IF;
13822: x_return_status := FND_API.G_RET_STS_ERROR;

Line 13819: IF FND_API.To_Boolean(p_commit) THEN

13815:
13816: EXCEPTION
13817: WHEN FND_API.G_EXC_ERROR THEN
13818: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
13819: IF FND_API.To_Boolean(p_commit) THEN
13820: ROLLBACK TO Copy_User_Attrs_Data_PUB;
13821: END IF;
13822: x_return_status := FND_API.G_RET_STS_ERROR;
13823:

Line 13822: x_return_status := FND_API.G_RET_STS_ERROR;

13818: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
13819: IF FND_API.To_Boolean(p_commit) THEN
13820: ROLLBACK TO Copy_User_Attrs_Data_PUB;
13821: END IF;
13822: x_return_status := FND_API.G_RET_STS_ERROR;
13823:
13824: ERROR_HANDLER.Add_Error_Message(
13825: p_message_name => x_msg_data
13826: ,p_application_id => 'EGO'

Line 13827: ,p_message_type => FND_API.G_RET_STS_ERROR

13823:
13824: ERROR_HANDLER.Add_Error_Message(
13825: p_message_name => x_msg_data
13826: ,p_application_id => 'EGO'
13827: ,p_message_type => FND_API.G_RET_STS_ERROR
13828: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
13829: );
13830:
13831: WHEN OTHERS THEN

Line 13833: IF FND_API.To_Boolean(p_commit) THEN

13829: );
13830:
13831: WHEN OTHERS THEN
13832: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM);
13833: IF FND_API.To_Boolean(p_commit) THEN
13834: ROLLBACK TO Copy_User_Attrs_Data_PUB;
13835: END IF;
13836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13837:

Line 13836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

13832: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM);
13833: IF FND_API.To_Boolean(p_commit) THEN
13834: ROLLBACK TO Copy_User_Attrs_Data_PUB;
13835: END IF;
13836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13837:
13838: DECLARE
13839: l_token_table ERROR_HANDLER.Token_Tbl_Type;
13840: BEGIN

Line 13852: ,p_message_type => FND_API.G_RET_STS_ERROR

13848: ERROR_HANDLER.Add_Error_Message(
13849: p_message_name => 'EGO_PLSQL_ERR'
13850: ,p_application_id => 'EGO'
13851: ,p_token_tbl => l_token_table
13852: ,p_message_type => FND_API.G_RET_STS_ERROR
13853: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
13854: );
13855: END;
13856:

Line 13873: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

13869: ,p_change_line_id IN NUMBER
13870: ,p_old_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13871: ,p_new_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13872: ,p_related_class_code_function IN VARCHAR2
13873: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13874: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13875: ,x_return_status OUT NOCOPY VARCHAR2
13876: ,x_errorcode OUT NOCOPY NUMBER
13877: ,x_msg_count OUT NOCOPY NUMBER

Line 13874: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

13870: ,p_old_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13871: ,p_new_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13872: ,p_related_class_code_function IN VARCHAR2
13873: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13874: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13875: ,x_return_status OUT NOCOPY VARCHAR2
13876: ,x_errorcode OUT NOCOPY NUMBER
13877: ,x_msg_count OUT NOCOPY NUMBER
13878: ,x_msg_data OUT NOCOPY VARCHAR2

Line 13936: IF FND_API.To_Boolean(p_commit) THEN

13932: BEGIN
13933:
13934: Debug_Msg('In Implement_Change_Line, starting', 1);
13935:
13936: IF FND_API.To_Boolean(p_commit) THEN
13937: SAVEPOINT Implement_Change_Line_PUB;
13938: END IF;
13939:
13940: -- Initialize FND_MSG_PUB and ERROR_HANDLER if necessary

Line 13941: IF (FND_API.To_Boolean(p_init_msg_list)) THEN

13937: SAVEPOINT Implement_Change_Line_PUB;
13938: END IF;
13939:
13940: -- Initialize FND_MSG_PUB and ERROR_HANDLER if necessary
13941: IF (FND_API.To_Boolean(p_init_msg_list)) THEN
13942: FND_MSG_PUB.Initialize;
13943: ERROR_HANDLER.Initialize;
13944: END IF;
13945:

Line 13947: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

13943: ERROR_HANDLER.Initialize;
13944: END IF;
13945:
13946: -- Check for call compatibility
13947: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
13948: l_api_name, G_PKG_NAME)
13949: THEN
13950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13951: END IF;

Line 13950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

13946: -- Check for call compatibility
13947: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
13948: l_api_name, G_PKG_NAME)
13949: THEN
13950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13951: END IF;
13952:
13953: -----------------------------------------------
13954: -- First, we get the Object ID for our calls --

Line 14751: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

14747: ,p_extension_id => l_ext_id_for_current_row
14748: ,p_attr_name_value_pairs => l_attr_name_value_pairs
14749: ,p_language_to_process => l_current_row_language
14750: ,p_mode => l_mode_for_current_row
14751: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
14752: ,x_return_status => x_return_status
14753: ,x_errorcode => x_errorcode
14754: ,x_msg_count => x_msg_count
14755: ,x_msg_data => x_msg_data

Line 14758: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

14754: ,x_msg_count => x_msg_count
14755: ,x_msg_data => x_msg_data
14756: );
14757:
14758: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
14759: RAISE FND_API.G_EXC_ERROR;
14760: END IF;
14761: END IF;
14762: END LOOP;

Line 14759: RAISE FND_API.G_EXC_ERROR;

14755: ,x_msg_data => x_msg_data
14756: );
14757:
14758: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
14759: RAISE FND_API.G_EXC_ERROR;
14760: END IF;
14761: END IF;
14762: END LOOP;
14763: DBMS_SQL.Close_Cursor(l_cursor_id);

Line 14777: IF FND_API.To_Boolean(p_commit) THEN

14773: ' SET IMPLEMENTATION_DATE = :1'||
14774: ' WHERE CHANGE_LINE_ID = :2'
14775: USING SYSDATE, p_change_line_id;
14776:
14777: IF FND_API.To_Boolean(p_commit) THEN
14778: COMMIT WORK;
14779: END IF;
14780:
14781: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 14781: x_return_status := FND_API.G_RET_STS_SUCCESS;

14777: IF FND_API.To_Boolean(p_commit) THEN
14778: COMMIT WORK;
14779: END IF;
14780:
14781: x_return_status := FND_API.G_RET_STS_SUCCESS;
14782:
14783: Debug_Msg('In Implement_Change_Line, done', 1);
14784:
14785: EXCEPTION

Line 14786: WHEN FND_API.G_EXC_ERROR THEN

14782:
14783: Debug_Msg('In Implement_Change_Line, done', 1);
14784:
14785: EXCEPTION
14786: WHEN FND_API.G_EXC_ERROR THEN
14787: Debug_Msg('In Implement_Change_Line, EXCEPTION FND_API.G_EXC_ERROR ', 1);
14788: IF FND_API.To_Boolean(p_commit) THEN
14789: ROLLBACK TO Implement_Change_Line_PUB;
14790: END IF;

Line 14787: Debug_Msg('In Implement_Change_Line, EXCEPTION FND_API.G_EXC_ERROR ', 1);

14783: Debug_Msg('In Implement_Change_Line, done', 1);
14784:
14785: EXCEPTION
14786: WHEN FND_API.G_EXC_ERROR THEN
14787: Debug_Msg('In Implement_Change_Line, EXCEPTION FND_API.G_EXC_ERROR ', 1);
14788: IF FND_API.To_Boolean(p_commit) THEN
14789: ROLLBACK TO Implement_Change_Line_PUB;
14790: END IF;
14791: x_return_status := FND_API.G_RET_STS_ERROR;

Line 14788: IF FND_API.To_Boolean(p_commit) THEN

14784:
14785: EXCEPTION
14786: WHEN FND_API.G_EXC_ERROR THEN
14787: Debug_Msg('In Implement_Change_Line, EXCEPTION FND_API.G_EXC_ERROR ', 1);
14788: IF FND_API.To_Boolean(p_commit) THEN
14789: ROLLBACK TO Implement_Change_Line_PUB;
14790: END IF;
14791: x_return_status := FND_API.G_RET_STS_ERROR;
14792:

Line 14791: x_return_status := FND_API.G_RET_STS_ERROR;

14787: Debug_Msg('In Implement_Change_Line, EXCEPTION FND_API.G_EXC_ERROR ', 1);
14788: IF FND_API.To_Boolean(p_commit) THEN
14789: ROLLBACK TO Implement_Change_Line_PUB;
14790: END IF;
14791: x_return_status := FND_API.G_RET_STS_ERROR;
14792:
14793: -----------------------------------------------------------------
14794: -- If Process_Row didn't return any errors, make one ourselves --
14795: -----------------------------------------------------------------

Line 14800: ,p_message_type => FND_API.G_RET_STS_ERROR

14796: IF (x_msg_data IS NULL AND x_msg_count = 0) THEN
14797: ERROR_HANDLER.Add_Error_Message(
14798: p_message_name => 'EGO_EF_IMPLEMENT_ERR'
14799: ,p_application_id => 'EGO'
14800: ,p_message_type => FND_API.G_RET_STS_ERROR
14801: ,p_addto_fnd_stack => 'Y'
14802: );
14803: END IF;
14804:

Line 14822: IF FND_API.To_Boolean(p_commit) THEN

14818: Debug_Msg('In Implement_Change_Line, got expected error: x_msg_data is '||x_msg_data, 3);
14819:
14820: WHEN OTHERS THEN
14821: Debug_Msg('In Implement_Change_Line, EXCEPTION OTHERS ', 1);
14822: IF FND_API.To_Boolean(p_commit) THEN
14823: ROLLBACK TO Implement_Change_Line_PUB;
14824: END IF;
14825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14826:

Line 14825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

14821: Debug_Msg('In Implement_Change_Line, EXCEPTION OTHERS ', 1);
14822: IF FND_API.To_Boolean(p_commit) THEN
14823: ROLLBACK TO Implement_Change_Line_PUB;
14824: END IF;
14825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14826:
14827: DECLARE
14828: l_dummy_entity_index NUMBER;
14829: l_dummy_entity_id VARCHAR2(60);

Line 14843: ,p_message_type => FND_API.G_RET_STS_ERROR

14839: ERROR_HANDLER.Add_Error_Message(
14840: p_message_name => 'EGO_PLSQL_ERR'
14841: ,p_application_id => 'EGO'
14842: ,p_token_tbl => l_token_table
14843: ,p_message_type => FND_API.G_RET_STS_ERROR
14844: ,p_addto_fnd_stack => 'Y'
14845: );
14846:
14847: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data

Line 15001: l_has_data_level_id := FND_API.TO_BOOLEAN(

14997: --------------------------------------------------------------
14998: -- WHERE conditions: Data Level ID, Data Level Primary Keys --
14999: --------------------------------------------------------------
15000:
15001: l_has_data_level_id := FND_API.TO_BOOLEAN(
15002: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => p_attr_group_metadata_obj.EXT_TABLE_B_NAME
15003: ,p_column_name => 'DATA_LEVEL_ID')
15004: );
15005:

Line 15033: ,p_message_type => FND_API.G_RET_STS_ERROR

15029: ERROR_HANDLER.Add_Error_Message(
15030: p_message_name => 'EGO_EF_DL_AG_INVALID'
15031: ,p_application_id => 'EGO'
15032: ,p_token_tbl => l_token_table
15033: ,p_message_type => FND_API.G_RET_STS_ERROR
15034: ,p_row_identifier => G_USER_ROW_IDENTIFIER
15035: ,p_entity_id => NULL
15036: ,p_entity_index => NULL
15037: ,p_entity_code => NULL

Line 15041: RAISE FND_API.G_EXC_ERROR;

15037: ,p_entity_code => NULL
15038: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
15039: );
15040: l_token_table.DELETE();
15041: RAISE FND_API.G_EXC_ERROR;
15042: END IF;
15043:
15044: END IF;
15045: ELSE

Line 15260: l_has_data_level_id := FND_API.TO_BOOLEAN(

15256: -- Get data level metadata, if applicable
15257: IF p_data_level IS NOT NULL THEN
15258: -- check if the passed in data level is valid for this attribute group.
15259: Debug_Msg(l_api_name || ' Non-null data level');
15260: l_has_data_level_id := FND_API.TO_BOOLEAN(
15261: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_attr_group_metadata_obj.EXT_TABLE_B_NAME
15262: ,p_column_name => 'DATA_LEVEL_ID')
15263: );
15264: IF l_has_data_level_id THEN

Line 15303: ,p_message_type => FND_API.G_RET_STS_ERROR

15299: ERROR_HANDLER.Add_Error_Message(
15300: p_message_name => 'EGO_EF_DL_AG_INVALID'
15301: ,p_application_id => 'EGO'
15302: ,p_token_tbl => l_token_table
15303: ,p_message_type => FND_API.G_RET_STS_ERROR
15304: ,p_row_identifier => G_USER_ROW_IDENTIFIER
15305: ,p_entity_id => NULL
15306: ,p_entity_index => NULL
15307: ,p_entity_code => NULL

Line 15311: RAISE FND_API.G_EXC_ERROR;

15307: ,p_entity_code => NULL
15308: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
15309: );
15310: l_token_table.DELETE();
15311: RAISE FND_API.G_EXC_ERROR;
15312: END IF;
15313:
15314: END IF;
15315: END IF; -- has_data_level

Line 15578: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

15574: ,x_return_status => l_return_status
15575: ,x_error_mesg => l_error_mesg
15576: );
15577:
15578: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
15579:
15580: ERROR_HANDLER.Add_Error_Message(
15581: p_message_text => l_error_mesg
15582: ,p_message_type => 'E'

Line 15730: ,p_commit => FND_API.G_FALSE

15726: ,p_data_level_name_value_pairs => p_data_level_name_value_pairs
15727: ,p_extension_id => l_extension_id
15728: ,p_attr_name_value_pairs => l_new_attr_name_value_pairs
15729: ,p_mode => l_mode
15730: ,p_commit => FND_API.G_FALSE
15731: ,p_bulkload_flag => TRUE
15732: ,x_extension_id => l_extension_id
15733: ,x_return_status => l_return_status
15734: );

Line 15740: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

15736: ELSE
15737: Debug_Msg('In Update_Attributes, skipped perform_dml');
15738: END IF;
15739:
15740: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
15741: Debug_Msg('In Update_Attributes, ERROR ret status: '||l_return_status, 2);
15742: RAISE FND_API.G_EXC_ERROR;
15743: END IF;
15744:

Line 15742: RAISE FND_API.G_EXC_ERROR;

15738: END IF;
15739:
15740: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
15741: Debug_Msg('In Update_Attributes, ERROR ret status: '||l_return_status, 2);
15742: RAISE FND_API.G_EXC_ERROR;
15743: END IF;
15744:
15745: EXCEPTION
15746: WHEN FND_API.G_EXC_ERROR THEN

Line 15746: WHEN FND_API.G_EXC_ERROR THEN

15742: RAISE FND_API.G_EXC_ERROR;
15743: END IF;
15744:
15745: EXCEPTION
15746: WHEN FND_API.G_EXC_ERROR THEN
15747: Debug_Msg('In Update_Attributes, EXCEPTION FND_API.G_EXC_ERROR');
15748: x_error_message := FND_API.G_RET_STS_ERROR;
15749:
15750: END Update_Attributes;

Line 15747: Debug_Msg('In Update_Attributes, EXCEPTION FND_API.G_EXC_ERROR');

15743: END IF;
15744:
15745: EXCEPTION
15746: WHEN FND_API.G_EXC_ERROR THEN
15747: Debug_Msg('In Update_Attributes, EXCEPTION FND_API.G_EXC_ERROR');
15748: x_error_message := FND_API.G_RET_STS_ERROR;
15749:
15750: END Update_Attributes;
15751:

Line 15748: x_error_message := FND_API.G_RET_STS_ERROR;

15744:
15745: EXCEPTION
15746: WHEN FND_API.G_EXC_ERROR THEN
15747: Debug_Msg('In Update_Attributes, EXCEPTION FND_API.G_EXC_ERROR');
15748: x_error_message := FND_API.G_RET_STS_ERROR;
15749:
15750: END Update_Attributes;
15751:
15752: ----------------------------------------------------------------------

Line 15861: Debug_Msg('In Get_Attr_Diffs, EXCEPTION FND_API.G_EXC_ERROR');

15857: Debug_Msg('In Get_Attr_Diffs, finished');
15858:
15859: EXCEPTION
15860: WHEN OTHERS THEN
15861: Debug_Msg('In Get_Attr_Diffs, EXCEPTION FND_API.G_EXC_ERROR');
15862: RAISE FND_API.G_EXC_ERROR;
15863:
15864: END Get_Attr_Diffs;
15865:

Line 15862: RAISE FND_API.G_EXC_ERROR;

15858:
15859: EXCEPTION
15860: WHEN OTHERS THEN
15861: Debug_Msg('In Get_Attr_Diffs, EXCEPTION FND_API.G_EXC_ERROR');
15862: RAISE FND_API.G_EXC_ERROR;
15863:
15864: END Get_Attr_Diffs;
15865:
15866: ---------------------------------------------------------------------------------

Line 15929: IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(l_attr_group_metadata_obj.EXT_TABLE_B_NAME, 'DATA_LEVEL_ID')) THEN

15925: ,p_attr_group_name => p_attr_group_int_name
15926: );
15927:
15928: --todo: why is this here?
15929: IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(l_attr_group_metadata_obj.EXT_TABLE_B_NAME, 'DATA_LEVEL_ID')) THEN
15930: -- data level exists
15931: NULL;
15932: END IF;
15933:

Line 16763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

16759: END IF;
16760: END LOOP;
16761:
16762: IF l_ix = -1 THEN
16763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16764: END IF;
16765:
16766: IF p_attributes_data_table(j).ATTR_NAME = req_attr_rec.attr_name
16767: AND

Line 16846: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

16842: ,p_entity_id IN NUMBER DEFAULT NULL
16843: ,p_entity_index IN NUMBER DEFAULT NULL
16844: ,p_entity_code IN VARCHAR2 DEFAULT NULL
16845: ,p_debug_level IN NUMBER DEFAULT 0
16846: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
16847: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
16848: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
16849: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
16850: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 16847: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

16843: ,p_entity_index IN NUMBER DEFAULT NULL
16844: ,p_entity_code IN VARCHAR2 DEFAULT NULL
16845: ,p_debug_level IN NUMBER DEFAULT 0
16846: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
16847: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
16848: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
16849: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
16850: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
16851: ,x_attributes_req_table OUT NOCOPY EGO_USER_ATTR_TABLE

Line 16848: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

16844: ,p_entity_code IN VARCHAR2 DEFAULT NULL
16845: ,p_debug_level IN NUMBER DEFAULT 0
16846: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
16847: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
16848: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
16849: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
16850: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
16851: ,x_attributes_req_table OUT NOCOPY EGO_USER_ATTR_TABLE
16852: ,x_return_status OUT NOCOPY VARCHAR2

Line 16849: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

16845: ,p_debug_level IN NUMBER DEFAULT 0
16846: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
16847: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
16848: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
16849: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
16850: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
16851: ,x_attributes_req_table OUT NOCOPY EGO_USER_ATTR_TABLE
16852: ,x_return_status OUT NOCOPY VARCHAR2
16853: ,x_errorcode OUT NOCOPY NUMBER

Line 16850: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

16846: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
16847: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
16848: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
16849: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
16850: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
16851: ,x_attributes_req_table OUT NOCOPY EGO_USER_ATTR_TABLE
16852: ,x_return_status OUT NOCOPY VARCHAR2
16853: ,x_errorcode OUT NOCOPY NUMBER
16854: ,x_msg_count OUT NOCOPY NUMBER

Line 16991: WHEN FND_API.G_EXC_ERROR THEN

16987:
16988: Debug_Msg(l_api_name||' done', 2);
16989:
16990: EXCEPTION
16991: WHEN FND_API.G_EXC_ERROR THEN
16992: x_return_status := FND_API.G_RET_STS_ERROR;
16993:
16994: WHEN OTHERS THEN
16995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 16992: x_return_status := FND_API.G_RET_STS_ERROR;

16988: Debug_Msg(l_api_name||' done', 2);
16989:
16990: EXCEPTION
16991: WHEN FND_API.G_EXC_ERROR THEN
16992: x_return_status := FND_API.G_RET_STS_ERROR;
16993:
16994: WHEN OTHERS THEN
16995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16996: l_token_table.DELETE();

Line 16995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

16991: WHEN FND_API.G_EXC_ERROR THEN
16992: x_return_status := FND_API.G_RET_STS_ERROR;
16993:
16994: WHEN OTHERS THEN
16995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16996: l_token_table.DELETE();
16997: l_token_table(1).TOKEN_NAME := 'PKG_NAME';
16998: l_token_table(1).TOKEN_VALUE := G_PKG_NAME;
16999: l_token_table(2).TOKEN_NAME := 'API_NAME';

Line 17008: ,p_message_type => FND_API.G_RET_STS_ERROR

17004: ERROR_HANDLER.Add_Error_Message(
17005: p_message_name => 'EGO_PLSQL_ERR'
17006: ,p_application_id => 'EGO'
17007: ,p_token_tbl => l_token_table
17008: ,p_message_type => FND_API.G_RET_STS_ERROR
17009: ,p_row_identifier => G_USER_ROW_IDENTIFIER
17010: ,p_entity_id => p_entity_id
17011: ,p_entity_index => p_entity_index
17012: ,p_entity_code => p_entity_code

Line 17131: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE

17127: ,p_entity_id IN NUMBER DEFAULT NULL
17128: ,p_entity_index IN NUMBER DEFAULT NULL
17129: ,p_entity_code IN VARCHAR2 DEFAULT NULL
17130: ,p_debug_level IN NUMBER DEFAULT 0
17131: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
17132: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
17133: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
17134: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
17135: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 17132: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

17128: ,p_entity_index IN NUMBER DEFAULT NULL
17129: ,p_entity_code IN VARCHAR2 DEFAULT NULL
17130: ,p_debug_level IN NUMBER DEFAULT 0
17131: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
17132: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
17133: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
17134: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
17135: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
17136: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 17133: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

17129: ,p_entity_code IN VARCHAR2 DEFAULT NULL
17130: ,p_debug_level IN NUMBER DEFAULT 0
17131: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
17132: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
17133: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
17134: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
17135: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
17136: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
17137: ,x_failed_row_id_list OUT NOCOPY VARCHAR2

Line 17134: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

17130: ,p_debug_level IN NUMBER DEFAULT 0
17131: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
17132: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
17133: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
17134: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
17135: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
17136: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
17137: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
17138: ,x_return_status OUT NOCOPY VARCHAR2

Line 17135: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

17131: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
17132: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
17133: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
17134: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
17135: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
17136: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
17137: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
17138: ,x_return_status OUT NOCOPY VARCHAR2
17139: ,x_errorcode OUT NOCOPY NUMBER

Line 17136: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

17132: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
17133: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
17134: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
17135: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
17136: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
17137: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
17138: ,x_return_status OUT NOCOPY VARCHAR2
17139: ,x_errorcode OUT NOCOPY NUMBER
17140: ,x_msg_count OUT NOCOPY NUMBER

Line 17255: l_ag_id_col_exists := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(

17251: -------------------------------------------------------------
17252: -- Find out weather the ATTR_GROUP_ID column exists in the --
17253: -- table where attribute data is to be uploaded or not --
17254: -------------------------------------------------------------
17255: l_ag_id_col_exists := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
17256: p_table_name => l_ext_b_table_name
17257: ,p_column_name => 'ATTR_GROUP_ID')
17258: );
17259:

Line 17260: l_has_data_level_id := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(

17256: p_table_name => l_ext_b_table_name
17257: ,p_column_name => 'ATTR_GROUP_ID')
17258: );
17259:
17260: l_has_data_level_id := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
17261: p_table_name => l_ext_b_table_name
17262: ,p_column_name => 'DATA_LEVEL_ID')
17263: );
17264: