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 371: RAISE FND_API.G_EXC_ERROR;

367: RETURN l_data_level_id;
368: EXCEPTION
369: WHEN OTHERS THEN
370: Debug_Msg('Failed Get_Data_Level_Id-'||SQLERRM,0);
371: RAISE FND_API.G_EXC_ERROR;
372: END Get_Data_Level_Id;
373: ---------------------------------------------------------------------
374:
375: --

Line 424: x_name_value_pair_valid := FND_API.G_FALSE;

420: EXCEPTION
421: WHEN OTHERS THEN
422: Debug_Msg(l_api_name || ' EXCEPTION '||SQLERRM,1);
423: x_data_level_id := NULL;
424: x_name_value_pair_valid := FND_API.G_FALSE;
425: END;
426: l_name_value_pair_valid := FALSE;
427: IF x_data_level_id IS NOT NULL THEN
428: -- if the pk's passed satisfy this data_level, call Perform_DML_On_Template_Row

Line 477: x_name_value_pair_valid := FND_API.G_TRUE;

473:
474: Debug_Msg(l_api_name || ' 106 ',1);
475: IF l_name_value_pair_valid THEN
476: Debug_Msg(l_api_name || ' 107 ',1);
477: x_name_value_pair_valid := FND_API.G_TRUE;
478: ELSE
479: Debug_Msg(l_api_name || ' 108 ',1);
480: x_name_value_pair_valid := FND_API.G_FALSE;
481: END IF;

Line 480: x_name_value_pair_valid := FND_API.G_FALSE;

476: Debug_Msg(l_api_name || ' 107 ',1);
477: x_name_value_pair_valid := FND_API.G_TRUE;
478: ELSE
479: Debug_Msg(l_api_name || ' 108 ',1);
480: x_name_value_pair_valid := FND_API.G_FALSE;
481: END IF;
482:
483: END Is_Name_Value_Pairs_Valid;
484:

Line 1024: FND_API.TO_BOOLEAN(

1020: --support have been taken up.
1021: ----------------------------------------------------------------------------
1022: IF(p_data_level IS NOT NULL
1023: AND
1024: FND_API.TO_BOOLEAN(
1025: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => p_attr_group_metadata_obj.ext_table_vl_name
1026: ,p_column_name => 'DATA_LEVEL_ID'
1027: )
1028: )

Line 2420: FND_API.TO_BOOLEAN(

2416: -- support for data level p_data_level would be passed in. --
2417: --------------------------------------------------------------
2418: IF(p_data_level IS NOT NULL
2419: AND
2420: FND_API.TO_BOOLEAN(
2421: has_column_in_table_view(p_object_name => p_attr_group_metadata_obj.ext_table_vl_name
2422: ,p_column_name => 'DATA_LEVEL_ID'
2423: )
2424: )

Line 2539: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

2535: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2536: ,p_entity_id IN VARCHAR2
2537: ,p_entity_index IN NUMBER
2538: ,p_entity_code IN VARCHAR2
2539: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2540: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
2541: ,p_is_disp_to_int_query IN BOOLEAN
2542: ,p_final_bind_value IN VARCHAR2
2543: ,p_return_bound_sql IN BOOLEAN DEFAULT FALSE

Line 2683: ,p_message_type => FND_API.G_RET_STS_ERROR

2679: ERROR_HANDLER.Add_Error_Message(
2680: p_message_name => l_error_message_name
2681: ,p_application_id => 'EGO'
2682: ,p_token_tbl => l_token_table
2683: ,p_message_type => FND_API.G_RET_STS_ERROR
2684: ,p_row_identifier => G_USER_ROW_IDENTIFIER
2685: ,p_entity_id => p_entity_id
2686: ,p_entity_index => p_entity_index
2687: ,p_entity_code => p_entity_code

Line 2691: RAISE FND_API.G_EXC_ERROR;

2687: ,p_entity_code => p_entity_code
2688: ,p_addto_fnd_stack => p_add_errors_to_fnd_stack
2689: );
2690:
2691: RAISE FND_API.G_EXC_ERROR;
2692: END IF;
2693:
2694: ------------------------------------
2695: -- Otherwise, we have an AG token --

Line 2727: ,p_message_type => FND_API.G_RET_STS_ERROR

2723: ERROR_HANDLER.Add_Error_Message(
2724: p_message_name => l_error_message_name
2725: ,p_application_id => 'EGO'
2726: ,p_token_tbl => l_token_table
2727: ,p_message_type => FND_API.G_RET_STS_ERROR
2728: ,p_row_identifier => G_USER_ROW_IDENTIFIER
2729: ,p_entity_id => p_entity_id
2730: ,p_entity_index => p_entity_index
2731: ,p_entity_code => p_entity_code

Line 2735: RAISE FND_API.G_EXC_ERROR;

2731: ,p_entity_code => p_entity_code
2732: ,p_addto_fnd_stack => p_add_errors_to_fnd_stack
2733: );
2734:
2735: RAISE FND_API.G_EXC_ERROR;
2736:
2737: ELSE
2738:
2739: IF (p_return_bound_sql) THEN

Line 4229: ,p_message_type => FND_API.G_RET_STS_ERROR

4225: ERROR_HANDLER.Add_Error_Message(
4226: p_message_name => l_error_message_name
4227: ,p_application_id => 'EGO'
4228: ,p_token_tbl => l_token_table
4229: ,p_message_type => FND_API.G_RET_STS_ERROR
4230: ,p_row_identifier => G_USER_ROW_IDENTIFIER
4231: ,p_entity_id => p_entity_id
4232: ,p_entity_index => p_entity_index
4233: ,p_entity_code => p_entity_code

Line 4237: RAISE FND_API.G_EXC_ERROR;

4233: ,p_entity_code => p_entity_code
4234: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
4235: );
4236:
4237: RAISE FND_API.G_EXC_ERROR;
4238: ELSIF (x_extension_id IS NULL) THEN
4239: --------------------------------------------------------------------
4240: -- If there was no error and we don't yet have the ext ID, set it --
4241: -- based on the table on which the user is trying to perform DML --

Line 4282: ,p_message_type => FND_API.G_RET_STS_ERROR

4278: ERROR_HANDLER.Add_Error_Message(
4279: p_message_name => l_error_message_name
4280: ,p_application_id => 'EGO'
4281: ,p_token_tbl => l_token_table
4282: ,p_message_type => FND_API.G_RET_STS_ERROR
4283: ,p_row_identifier => G_USER_ROW_IDENTIFIER
4284: ,p_entity_id => p_entity_id
4285: ,p_entity_index => p_entity_index
4286: ,p_entity_code => p_entity_code

Line 4290: RAISE FND_API.G_EXC_ERROR;

4286: ,p_entity_code => p_entity_code
4287: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
4288: );
4289:
4290: RAISE FND_API.G_EXC_ERROR;
4291:
4292: ELSIF (x_extension_id IS NOT NULL AND
4293: x_mode = G_CREATE_MODE AND
4294: (NOT l_is_change_case OR p_change_obj.ACD_TYPE = 'ADD')) THEN

Line 4305: ,p_message_type => FND_API.G_RET_STS_ERROR

4301: ERROR_HANDLER.Add_Error_Message(
4302: p_message_name => l_error_message_name
4303: ,p_application_id => 'EGO'
4304: ,p_token_tbl => l_token_table
4305: ,p_message_type => FND_API.G_RET_STS_ERROR
4306: ,p_row_identifier => G_USER_ROW_IDENTIFIER
4307: ,p_entity_id => p_entity_id
4308: ,p_entity_index => p_entity_index
4309: ,p_entity_code => p_entity_code

Line 4313: RAISE FND_API.G_EXC_ERROR;

4309: ,p_entity_code => p_entity_code
4310: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
4311: );
4312:
4313: RAISE FND_API.G_EXC_ERROR;
4314:
4315: END IF;
4316:
4317: ----------------------------------------------------------------------

Line 4345: ,p_message_type => FND_API.G_RET_STS_ERROR

4341: ERROR_HANDLER.Add_Error_Message(
4342: p_message_name => l_error_message_name
4343: ,p_application_id => 'EGO'
4344: ,p_token_tbl => l_token_table
4345: ,p_message_type => FND_API.G_RET_STS_ERROR
4346: ,p_row_identifier => G_USER_ROW_IDENTIFIER
4347: ,p_entity_id => p_entity_id
4348: ,p_entity_index => p_entity_index
4349: ,p_entity_code => p_entity_code

Line 4353: RAISE FND_API.G_EXC_ERROR;

4349: ,p_entity_code => p_entity_code
4350: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
4351: );
4352:
4353: RAISE FND_API.G_EXC_ERROR;
4354:
4355: END IF;
4356: Debug_Msg('In Get_Extension_Id_And_Mode, done', 2);
4357:

Line 4359: WHEN FND_API.G_EXC_ERROR THEN

4355: END IF;
4356: Debug_Msg('In Get_Extension_Id_And_Mode, done', 2);
4357:
4358: EXCEPTION
4359: WHEN FND_API.G_EXC_ERROR THEN
4360: Debug_Msg(' Get_Extension_Id_And_Mode EXCEPTION FND_API.G_EXC_ERROR ');
4361: x_return_status := FND_API.G_RET_STS_ERROR;
4362:
4363: WHEN OTHERS THEN

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

4356: Debug_Msg('In Get_Extension_Id_And_Mode, done', 2);
4357:
4358: EXCEPTION
4359: WHEN FND_API.G_EXC_ERROR THEN
4360: Debug_Msg(' Get_Extension_Id_And_Mode EXCEPTION FND_API.G_EXC_ERROR ');
4361: x_return_status := FND_API.G_RET_STS_ERROR;
4362:
4363: WHEN OTHERS THEN
4364:

Line 4361: x_return_status := FND_API.G_RET_STS_ERROR;

4357:
4358: EXCEPTION
4359: WHEN FND_API.G_EXC_ERROR THEN
4360: Debug_Msg(' Get_Extension_Id_And_Mode EXCEPTION FND_API.G_EXC_ERROR ');
4361: x_return_status := FND_API.G_RET_STS_ERROR;
4362:
4363: WHEN OTHERS THEN
4364:
4365: Debug_Msg(' Get_Extension_Id_And_Mode EXCEPTION OTHERS '||SQLERRM);

Line 4366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4362:
4363: WHEN OTHERS THEN
4364:
4365: Debug_Msg(' Get_Extension_Id_And_Mode EXCEPTION OTHERS '||SQLERRM);
4366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4367:
4368: l_token_table.DELETE();
4369: l_token_table(1).TOKEN_NAME := 'PKG_NAME';
4370: l_token_table(1).TOKEN_VALUE := G_PKG_NAME;

Line 4380: ,p_message_type => FND_API.G_RET_STS_ERROR

4376: ERROR_HANDLER.Add_Error_Message(
4377: p_message_name => 'EGO_PLSQL_ERR'
4378: ,p_application_id => 'EGO'
4379: ,p_token_tbl => l_token_table
4380: ,p_message_type => FND_API.G_RET_STS_ERROR
4381: ,p_row_identifier => G_USER_ROW_IDENTIFIER
4382: ,p_entity_id => p_entity_id
4383: ,p_entity_index => p_entity_index
4384: ,p_entity_code => p_entity_code

Line 4440: ,p_message_type => FND_API.G_RET_STS_ERROR

4436: ERROR_HANDLER.Add_Error_Message(
4437: p_message_name => 'EGO_EF_ATTR_DOES_NOT_EXIST'
4438: ,p_application_id => 'EGO'
4439: ,p_token_tbl => l_token_table
4440: ,p_message_type => FND_API.G_RET_STS_ERROR
4441: ,p_row_identifier => G_USER_ROW_IDENTIFIER
4442: ,p_entity_id => p_entity_id
4443: ,p_entity_index => p_entity_index
4444: ,p_entity_code => p_entity_code

Line 5680: ,p_message_type => FND_API.G_RET_STS_ERROR

5676: ERROR_HANDLER.Add_Error_Message(
5677: p_message_name => l_err_msg_name
5678: ,p_application_id => 'EGO'
5679: ,p_token_tbl => l_token_table
5680: ,p_message_type => FND_API.G_RET_STS_ERROR
5681: ,p_row_identifier => G_USER_ROW_IDENTIFIER
5682: ,p_entity_id => p_entity_id
5683: ,p_entity_index => p_entity_index
5684: ,p_entity_code => p_entity_code

Line 5814: ,p_message_type => FND_API.G_RET_STS_ERROR

5810: ERROR_HANDLER.Add_Error_Message(
5811: p_message_name => 'EGO_EF_NO_VAL_FOR_REQ_ATTR'
5812: ,p_application_id => 'EGO'
5813: ,p_token_tbl => l_token_table
5814: ,p_message_type => FND_API.G_RET_STS_ERROR
5815: ,p_row_identifier => G_USER_ROW_IDENTIFIER
5816: ,p_entity_id => p_entity_id
5817: ,p_entity_index => p_entity_index
5818: ,p_entity_code => p_entity_code

Line 5906: ,p_message_type => FND_API.G_RET_STS_ERROR

5902: ERROR_HANDLER.Add_Error_Message(
5903: p_message_name => 'EGO_EF_ATTR_DOES_NOT_EXIST'
5904: ,p_application_id => 'EGO'
5905: ,p_token_tbl => l_token_table
5906: ,p_message_type => FND_API.G_RET_STS_ERROR
5907: ,p_row_identifier => p_row_identifier
5908: ,p_entity_id => p_entity_id
5909: ,p_entity_index => p_entity_index
5910: ,p_entity_code => p_entity_code

Line 6026: x_return_status := FND_API.G_RET_STS_ERROR;

6022: l_token_table(2).TOKEN_VALUE := l_attr_metadata_obj.ATTR_DISP_NAME;
6023: l_token_table(3).TOKEN_NAME := 'AG_NAME';
6024: l_token_table(3).TOKEN_VALUE := p_attr_group_metadata_obj.ATTR_GROUP_DISP_NAME;
6025:
6026: x_return_status := FND_API.G_RET_STS_ERROR;
6027:
6028: END IF;
6029:
6030: -----------------------------------------------------------------------------------

Line 6051: x_return_status := FND_API.G_RET_STS_ERROR;

6047: l_token_table(3).TOKEN_VALUE := l_attr_metadata_obj.DATA_TYPE_MEANING;
6048: l_token_table(4).TOKEN_NAME := 'VALUE';
6049: l_token_table(4).TOKEN_VALUE := px_attr_name_value_pairs(l_attr_value_index).ATTR_DISP_VALUE;
6050:
6051: x_return_status := FND_API.G_RET_STS_ERROR;
6052:
6053:
6054: ------------------------------------------------------------------------------
6055: -- Finally, we check for the much less common case where the Attribute is a --

Line 6087: x_return_status := FND_API.G_RET_STS_ERROR;

6083: l_token_table(3).TOKEN_NAME := 'DATA_TYPE';
6084: l_token_table(3).TOKEN_VALUE := l_attr_metadata_obj.DATA_TYPE_MEANING;
6085: l_token_table(4).TOKEN_NAME := 'VALUE';
6086: l_token_table(4).TOKEN_VALUE := px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR;
6087: x_return_status := FND_API.G_RET_STS_ERROR;
6088: END;
6089: END IF;
6090:
6091: ----------------------------------------------------------------------------

Line 6103: ,p_message_type => FND_API.G_RET_STS_ERROR

6099: ERROR_HANDLER.Add_Error_Message(
6100: p_message_name => l_err_msg_name
6101: ,p_application_id => 'EGO'
6102: ,p_token_tbl => l_token_table
6103: ,p_message_type => FND_API.G_RET_STS_ERROR
6104: ,p_row_identifier => G_USER_ROW_IDENTIFIER
6105: ,p_entity_id => p_entity_id
6106: ,p_entity_index => p_entity_index
6107: ,p_entity_code => p_entity_code

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

6347: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
6348: p_attr_group_metadata_obj.attr_metadata_table
6349: ,l_attr_rec.attr_name );
6350: -- abedajna Bug 6134504 end
6351: IF(NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_STR,FND_API.G_MISS_CHAR)<>
6352: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_STR,FND_API.G_MISS_CHAR)) THEN
6353: l_attr_name_val.EXTEND();
6354: l_attr_rec.attr_value := px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_STR;
6355: l_attr_name_val(l_attr_name_val.LAST) := l_attr_rec;

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

6348: p_attr_group_metadata_obj.attr_metadata_table
6349: ,l_attr_rec.attr_name );
6350: -- abedajna Bug 6134504 end
6351: IF(NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_STR,FND_API.G_MISS_CHAR)<>
6352: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_STR,FND_API.G_MISS_CHAR)) THEN
6353: l_attr_name_val.EXTEND();
6354: l_attr_rec.attr_value := px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_STR;
6355: l_attr_name_val(l_attr_name_val.LAST) := l_attr_rec;
6356: ELSIF ( NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_NUM,FND_API.G_MISS_NUM)<>

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

6352: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_STR,FND_API.G_MISS_CHAR)) THEN
6353: l_attr_name_val.EXTEND();
6354: l_attr_rec.attr_value := px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_STR;
6355: l_attr_name_val(l_attr_name_val.LAST) := l_attr_rec;
6356: ELSIF ( NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_NUM,FND_API.G_MISS_NUM)<>
6357: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_NUM,FND_API.G_MISS_NUM))THEN
6358: l_attr_name_val.EXTEND();
6359: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_NUM);
6360: l_attr_name_val(l_attr_name_val.LAST) :=l_attr_rec;

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

6353: l_attr_name_val.EXTEND();
6354: l_attr_rec.attr_value := px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_STR;
6355: l_attr_name_val(l_attr_name_val.LAST) := l_attr_rec;
6356: ELSIF ( NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_NUM,FND_API.G_MISS_NUM)<>
6357: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_NUM,FND_API.G_MISS_NUM))THEN
6358: l_attr_name_val.EXTEND();
6359: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_NUM);
6360: l_attr_name_val(l_attr_name_val.LAST) :=l_attr_rec;
6361: ELSIF (NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE,FND_API.G_MISS_DATE)<>

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

6357: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_NUM,FND_API.G_MISS_NUM))THEN
6358: l_attr_name_val.EXTEND();
6359: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_NUM);
6360: l_attr_name_val(l_attr_name_val.LAST) :=l_attr_rec;
6361: ELSIF (NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE,FND_API.G_MISS_DATE)<>
6362: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE,FND_API.G_MISS_DATE))THEN
6363: l_attr_name_val.EXTEND();
6364: -- l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
6365: -- abedajna Bug 6134504 begin

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

6358: l_attr_name_val.EXTEND();
6359: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_NUM);
6360: l_attr_name_val(l_attr_name_val.LAST) :=l_attr_rec;
6361: ELSIF (NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE,FND_API.G_MISS_DATE)<>
6362: NVL(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE,FND_API.G_MISS_DATE))THEN
6363: l_attr_name_val.EXTEND();
6364: -- l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
6365: -- abedajna Bug 6134504 begin
6366: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) then -- timestamp

Line 6537: ,p_message_type => FND_API.G_RET_STS_ERROR

6533: ERROR_HANDLER.Add_Error_Message(
6534: p_message_name => 'EGO_PLSQL_ERR'
6535: ,p_application_id => 'EGO'
6536: ,p_token_tbl => l_token_table
6537: ,p_message_type => FND_API.G_RET_STS_ERROR
6538: ,p_row_identifier => G_USER_ROW_IDENTIFIER
6539: ,p_entity_id => p_entity_id
6540: ,p_entity_index => p_entity_index
6541: ,p_entity_code => p_entity_code

Line 6591: ,p_message_type => FND_API.G_RET_STS_ERROR

6587: ERROR_HANDLER.Add_Error_Message(
6588: p_message_name => l_err_msg_name
6589: ,p_application_id => 'EGO'
6590: ,p_token_tbl => l_token_table
6591: ,p_message_type => FND_API.G_RET_STS_ERROR
6592: ,p_row_identifier => G_USER_ROW_IDENTIFIER
6593: ,p_entity_id => p_entity_id
6594: ,p_entity_index => p_entity_index
6595: ,p_entity_code => p_entity_code

Line 6599: RAISE FND_API.G_EXC_ERROR;

6595: ,p_entity_code => p_entity_code
6596: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
6597: );
6598:
6599: RAISE FND_API.G_EXC_ERROR;
6600:
6601: END IF;
6602:
6603: ---------------------------------------------------------------

Line 6620: ,p_message_type => FND_API.G_RET_STS_ERROR

6616: ERROR_HANDLER.Add_Error_Message(
6617: p_message_name => 'EGO_EF_EXT_TABLE_METADATA_ERR'
6618: ,p_application_id => 'EGO'
6619: ,p_token_tbl => l_token_table
6620: ,p_message_type => FND_API.G_RET_STS_ERROR
6621: ,p_row_identifier => G_USER_ROW_IDENTIFIER
6622: ,p_entity_id => p_entity_id
6623: ,p_entity_index => p_entity_index
6624: ,p_entity_code => p_entity_code

Line 6627: RAISE FND_API.G_EXC_ERROR;

6623: ,p_entity_index => p_entity_index
6624: ,p_entity_code => p_entity_code
6625: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
6626: );
6627: RAISE FND_API.G_EXC_ERROR;
6628: END IF;
6629:
6630: IF (NOT Are_Ext_Table_Col_Names_Right(l_ext_table_metadata_obj
6631: ,p_pk_column_name_value_pairs

Line 6640: ,p_message_type => FND_API.G_RET_STS_ERROR

6636: ERROR_HANDLER.Add_Error_Message(
6637: p_message_name => l_err_msg_name
6638: ,p_application_id => 'EGO'
6639: ,p_token_tbl => l_token_table
6640: ,p_message_type => FND_API.G_RET_STS_ERROR
6641: ,p_row_identifier => G_USER_ROW_IDENTIFIER
6642: ,p_entity_id => p_entity_id
6643: ,p_entity_index => p_entity_index
6644: ,p_entity_code => p_entity_code

Line 6647: RAISE FND_API.G_EXC_ERROR;

6643: ,p_entity_index => p_entity_index
6644: ,p_entity_code => p_entity_code
6645: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
6646: );
6647: RAISE FND_API.G_EXC_ERROR;
6648: END IF;
6649:
6650: -----------------------------------------------------------------------------
6651: -- Next, we check that the Primary Key column array has at least one value --

Line 6712: ,p_message_type => FND_API.G_RET_STS_ERROR

6708: ERROR_HANDLER.Add_Error_Message(
6709: p_message_name => l_err_msg_name
6710: ,p_application_id => 'EGO'
6711: ,p_token_tbl => l_token_table
6712: ,p_message_type => FND_API.G_RET_STS_ERROR
6713: ,p_row_identifier => G_USER_ROW_IDENTIFIER
6714: ,p_entity_id => p_entity_id
6715: ,p_entity_index => p_entity_index
6716: ,p_entity_code => p_entity_code

Line 6719: RAISE FND_API.G_EXC_ERROR;

6715: ,p_entity_index => p_entity_index
6716: ,p_entity_code => p_entity_code
6717: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
6718: );
6719: RAISE FND_API.G_EXC_ERROR;
6720: END IF;
6721:
6722: x_return_status := FND_API.G_RET_STS_SUCCESS;
6723: Debug_Msg('In Perform_Preliminary_Checks, done', 2);

Line 6722: x_return_status := FND_API.G_RET_STS_SUCCESS;

6718: );
6719: RAISE FND_API.G_EXC_ERROR;
6720: END IF;
6721:
6722: x_return_status := FND_API.G_RET_STS_SUCCESS;
6723: Debug_Msg('In Perform_Preliminary_Checks, done', 2);
6724:
6725: EXCEPTION
6726: WHEN FND_API.G_EXC_ERROR THEN

Line 6726: WHEN FND_API.G_EXC_ERROR THEN

6722: x_return_status := FND_API.G_RET_STS_SUCCESS;
6723: Debug_Msg('In Perform_Preliminary_Checks, done', 2);
6724:
6725: EXCEPTION
6726: WHEN FND_API.G_EXC_ERROR THEN
6727: Debug_Msg('In Perform_Preliminary_Checks, EXCEPTION FND_API.G_EXC_ERROR', 2);
6728: x_return_status := FND_API.G_RET_STS_ERROR;
6729:
6730: END Perform_Preliminary_Checks;

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

6723: Debug_Msg('In Perform_Preliminary_Checks, done', 2);
6724:
6725: EXCEPTION
6726: WHEN FND_API.G_EXC_ERROR THEN
6727: Debug_Msg('In Perform_Preliminary_Checks, EXCEPTION FND_API.G_EXC_ERROR', 2);
6728: x_return_status := FND_API.G_RET_STS_ERROR;
6729:
6730: END Perform_Preliminary_Checks;
6731:

Line 6728: x_return_status := FND_API.G_RET_STS_ERROR;

6724:
6725: EXCEPTION
6726: WHEN FND_API.G_EXC_ERROR THEN
6727: Debug_Msg('In Perform_Preliminary_Checks, EXCEPTION FND_API.G_EXC_ERROR', 2);
6728: x_return_status := FND_API.G_RET_STS_ERROR;
6729:
6730: END Perform_Preliminary_Checks;
6731:
6732: ----------------------------------------------------------------------

Line 6853: x_return_status := FND_API.G_RET_STS_SUCCESS;

6849: END IF;
6850: END IF;
6851:
6852: IF (l_has_edit_privilege) THEN
6853: x_return_status := FND_API.G_RET_STS_SUCCESS;
6854: ELSIF (l_error_message_name IS NULL) THEN
6855: l_error_message_name := 'EGO_EF_AG_USER_PRIV_ERR';
6856: END IF;
6857:

Line 6872: ,p_message_type => FND_API.G_RET_STS_ERROR

6868: ERROR_HANDLER.Add_Error_Message(
6869: p_message_name => l_error_message_name
6870: ,p_application_id => 'EGO'
6871: ,p_token_tbl => l_token_table
6872: ,p_message_type => FND_API.G_RET_STS_ERROR
6873: ,p_row_identifier => G_USER_ROW_IDENTIFIER
6874: ,p_entity_id => p_entity_id
6875: ,p_entity_index => p_entity_index
6876: ,p_entity_code => p_entity_code

Line 6880: x_return_status := FND_API.G_RET_STS_ERROR;

6876: ,p_entity_code => p_entity_code
6877: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
6878: );
6879:
6880: x_return_status := FND_API.G_RET_STS_ERROR;
6881: END IF;
6882:
6883: Debug_Msg('In Check_Privileges, done; x_return_status is '||x_return_status, 2);
6884:

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

6960:
6961: -----------------------------------------
6962: -- Initialize FND_MSG_PUB if necessary --
6963: -----------------------------------------
6964: IF (FND_API.To_Boolean(p_init_fnd_msg_list)) THEN
6965:
6966: FND_MSG_PUB.Initialize;
6967:
6968: END IF;

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

6983:
6984: END IF;
6985: END IF;
6986:
6987: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
6988: G_ADD_ERRORS_TO_FND_STACK := 'Y';
6989: ELSE
6990: G_ADD_ERRORS_TO_FND_STACK := 'N';
6991: END IF;

Line 7287: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE

7283: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
7284: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
7285: ,p_pending_b_table_name IN VARCHAR2
7286: ,p_pending_tl_table_name IN VARCHAR2
7287: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
7288: ,p_entity_id IN VARCHAR2
7289: ,p_entity_index IN NUMBER
7290: ,p_entity_code IN VARCHAR2
7291: ,p_commit IN VARCHAR2

Line 7350: IF FND_API.To_Boolean(p_commit) THEN

7346: BEGIN
7347:
7348: Debug_Msg('In Insert_Row, starting', 1);
7349:
7350: IF FND_API.To_Boolean(p_commit) THEN
7351: SAVEPOINT Insert_Row;
7352: END IF;
7353:
7354: l_pre_raise_flag := 'F';

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

7352: END IF;
7353:
7354: l_pre_raise_flag := 'F';
7355: -- Check for call compatibility
7356: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
7357: l_api_name, G_PKG_NAME)
7358: THEN
7359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7360: END IF;

Line 7359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7355: -- Check for call compatibility
7356: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
7357: l_api_name, G_PKG_NAME)
7358: THEN
7359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7360: END IF;
7361:
7362: IF (p_bulkload_flag) THEN
7363: l_propagate_hierarchy := FALSE;

Line 7576: FND_API.TO_BOOLEAN(

7572: -- Add data_level_id only if it has been provided --
7573: -----------------------------------------------------
7574: IF(p_data_level IS NOT NULL
7575: AND
7576: FND_API.TO_BOOLEAN(
7577: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_b_table_name
7578: ,p_column_name => 'DATA_LEVEL_ID'
7579: )
7580: )

Line 7659: IF (FND_API.TO_BOOLEAN(l_column_exists)) THEN

7655: -- The below function returns 'T' or 'F'
7656: l_column_exists:= HAS_COLUMN_IN_TABLE_VIEW(l_b_table_name,'UNIQUE_VALUE');
7657:
7658: -- Add UNIQUE_VALUE only if table has this column for multi row UDAs only
7659: IF (FND_API.TO_BOOLEAN(l_column_exists)) THEN
7660: FND_DSQL.Add_Text('UNIQUE_VALUE, ');
7661: END IF;
7662: END IF;
7663: -- Bug 10097738 : End

Line 7696: FND_API.TO_BOOLEAN(

7692: -----------------------------------------------------
7693: Debug_Msg(' in insert_row -- p_data_level-'||p_data_level);
7694: IF(p_data_level IS NOT NULL
7695: AND
7696: FND_API.TO_BOOLEAN(
7697: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_b_table_name
7698: ,p_column_name => 'DATA_LEVEL_ID'
7699: )
7700: )

Line 7759: IF (p_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y' AND FND_API.TO_BOOLEAN(l_column_exists)) THEN

7755: -- adds a trailing separator to the list if it adds anything to it) --
7756: ----------------------------------------------------------------------
7757:
7758: -- Bug 10097738 : Start
7759: IF (p_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y' AND FND_API.TO_BOOLEAN(l_column_exists)) THEN
7760: FND_DSQL.Add_Bind(l_new_extension_id); -- inserting the ext id value in UNIQUE_VALUE column for MR UDAs
7761: FND_DSQL.Add_Text(', ');
7762: END IF;
7763: -- Bug 10097738 : End

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

7796: ---------------------------------------------------------------------
7797: -- Next we parse the statement, bind our variables, and execute it --
7798: ---------------------------------------------------------------------
7799:
7800: IF (p_execute_dml = FND_API.G_TRUE) THEN
7801: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
7802: FND_DSQL.Set_Cursor(l_cursor_id);
7803: FND_DSQL.Do_Binds();
7804: END IF;

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

7832: END IF;
7833: END IF;
7834: --End 4105841
7835:
7836: IF (p_execute_dml = FND_API.G_TRUE) THEN
7837: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
7838: END IF;
7839:
7840: END IF;

Line 7870: FND_API.TO_BOOLEAN(

7866: -- Add data_level_id only if it has been provided --
7867: -----------------------------------------------------
7868: IF(p_data_level IS NOT NULL
7869: AND
7870: FND_API.TO_BOOLEAN(
7871: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_tl_table_name
7872: ,p_column_name => 'DATA_LEVEL_ID'
7873: )
7874: )

Line 7943: FND_API.TO_BOOLEAN(

7939: -- Add data_level_id only if it has been provided --
7940: -----------------------------------------------------
7941: IF(p_data_level IS NOT NULL
7942: AND
7943: FND_API.TO_BOOLEAN(
7944: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_tl_table_name
7945: ,p_column_name => 'DATA_LEVEL_ID'
7946: )
7947: )

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

8034:
8035: ---------------------------------------------------
8036: -- We re-use our cursor from the first statement --
8037: ---------------------------------------------------
8038: IF (p_execute_dml = FND_API.G_TRUE) THEN
8039: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
8040: FND_DSQL.Set_Cursor(l_cursor_id);
8041: FND_DSQL.Do_Binds();
8042: END IF;

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

8063: END IF;
8064: END IF;
8065: --End 4105841
8066:
8067: IF (p_execute_dml = FND_API.G_TRUE) THEN
8068: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
8069: END IF;
8070:
8071: END IF;

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

8076: DBMS_SQL.Close_Cursor(l_cursor_id);
8077:
8078: IF (l_propagate_hierarchy
8079: AND p_attr_group_metadata_obj.HIERARCHY_PROPAGATE_FLAG = 'Y'
8080: AND px_attr_diffs.COUNT > 0 AND p_execute_dml = FND_API.G_TRUE) THEN --Bug fix 5220020
8081: Propagate_Attributes( p_pk_column_name_value_pairs
8082: , p_class_code_name_value_pairs
8083: , p_data_level_name_value_pairs
8084: , px_attr_diffs

Line 8122: IF FND_API.To_Boolean(p_commit) THEN

8118: x_extension_id := l_new_extension_id;
8119:
8120: Debug_Msg('In Insert_Row, done', 1);
8121:
8122: IF FND_API.To_Boolean(p_commit) THEN
8123: COMMIT WORK;
8124: END IF;
8125:
8126: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8126: x_return_status := FND_API.G_RET_STS_SUCCESS;

8122: IF FND_API.To_Boolean(p_commit) THEN
8123: COMMIT WORK;
8124: END IF;
8125:
8126: x_return_status := FND_API.G_RET_STS_SUCCESS;
8127:
8128: EXCEPTION
8129: -----------------------------------------------------------
8130: -- There are no expected errors in this procedure, so... --

Line 8137: IF FND_API.To_Boolean(p_commit) THEN

8133: --Checking for Exception raised by preAttribute Change Event
8134: --don't put to the stack already added in EGO_WF_WRAPPER_PVT
8135: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
8136: Debug_Msg('Insert_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
8137: IF FND_API.To_Boolean(p_commit) THEN
8138: ROLLBACK TO insert_row;
8139: END IF;
8140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8141: --End 4105841

Line 8140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8136: Debug_Msg('Insert_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
8137: IF FND_API.To_Boolean(p_commit) THEN
8138: ROLLBACK TO insert_row;
8139: END IF;
8140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8141: --End 4105841
8142:
8143: WHEN OTHERS THEN
8144:

Line 8146: IF FND_API.To_Boolean(p_commit) THEN

8142:
8143: WHEN OTHERS THEN
8144:
8145: Debug_Msg('Insert_Row EXCEPTION others '||SQLERRM);
8146: IF FND_API.To_Boolean(p_commit) THEN
8147: ROLLBACK TO insert_row;
8148: END IF;
8149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8150:

Line 8149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8145: Debug_Msg('Insert_Row EXCEPTION others '||SQLERRM);
8146: IF FND_API.To_Boolean(p_commit) THEN
8147: ROLLBACK TO insert_row;
8148: END IF;
8149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8150:
8151: DECLARE
8152: l_token_table ERROR_HANDLER.Token_Tbl_Type;
8153: BEGIN

Line 8165: ,p_message_type => FND_API.G_RET_STS_ERROR

8161: ERROR_HANDLER.Add_Error_Message(
8162: p_message_name => 'EGO_PLSQL_ERR'
8163: ,p_application_id => 'EGO'
8164: ,p_token_tbl => l_token_table
8165: ,p_message_type => FND_API.G_RET_STS_ERROR
8166: ,p_row_identifier => G_USER_ROW_IDENTIFIER
8167: ,p_entity_id => p_entity_id
8168: ,p_entity_index => p_entity_index
8169: ,p_entity_code => p_entity_code

Line 8194: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE

8190: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
8191: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
8192: ,p_pending_b_table_name IN VARCHAR2
8193: ,p_pending_tl_table_name IN VARCHAR2
8194: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
8195: ,p_entity_id IN VARCHAR2
8196: ,p_entity_index IN NUMBER
8197: ,p_entity_code IN VARCHAR2
8198: ,p_commit IN VARCHAR2

Line 8251: IF FND_API.To_Boolean(p_commit) THEN

8247: BEGIN
8248:
8249: Debug_Msg('In Update_Row, starting', 1);
8250:
8251: IF FND_API.To_Boolean(p_commit) THEN
8252: SAVEPOINT update_row;
8253: END IF;
8254:
8255: l_pre_event_flag := 'F';

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

8253: END IF;
8254:
8255: l_pre_event_flag := 'F';
8256: -- Check for call compatibility
8257: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
8258: l_api_name, G_PKG_NAME)
8259: THEN
8260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8261: END IF;

Line 8260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8256: -- Check for call compatibility
8257: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
8258: l_api_name, G_PKG_NAME)
8259: THEN
8260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8261: END IF;
8262:
8263: IF (p_bulkload_flag) THEN
8264: l_propagate_hierarchy := FALSE;

Line 8447: FND_API.TO_BOOLEAN(

8443: --support have been taken up.
8444: ----------------------------------------------------------------------------
8445: IF(p_data_level IS NOT NULL
8446: AND
8447: FND_API.TO_BOOLEAN(
8448: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_b_table_name
8449: ,p_column_name => 'DATA_LEVEL_ID'
8450: )
8451: )

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

8492: Debug_Msg('In Update_Row, l_dynamic_sql:'||l_dynamic_sql, 3);
8493: Debug_SQL(FND_DSQL.Get_Text(TRUE));
8494: Set_Binds_And_Dml(l_dynamic_sql ,'B');
8495:
8496: IF (p_execute_dml = FND_API.G_TRUE) THEN
8497: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
8498: FND_DSQL.Set_Cursor(l_cursor_id);
8499: FND_DSQL.Do_Binds();
8500: END IF;

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

8528: END IF;
8529: END IF;
8530: --End 4105841
8531:
8532: IF (p_execute_dml = FND_API.G_TRUE) THEN
8533: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
8534: END IF;
8535:
8536: END IF;

Line 8592: FND_API.TO_BOOLEAN(

8588: --support have been taken up.
8589: ----------------------------------------------------------------------------
8590: IF(p_data_level IS NOT NULL
8591: AND
8592: FND_API.TO_BOOLEAN(
8593: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_tl_table_name
8594: ,p_column_name => 'DATA_LEVEL_ID'
8595: )
8596: )

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

8676:
8677: Debug_Msg('In Update_Row, l_dynamic_sql for TL table is as follows:', 3);
8678: Debug_SQL(FND_DSQL.Get_Text(TRUE));
8679:
8680: IF (p_execute_dml = FND_API.G_TRUE) THEN
8681: DBMS_SQL.Parse(l_cursor_id, l_dynamic_sql, DBMS_SQL.Native);
8682: FND_DSQL.Set_Cursor(l_cursor_id);
8683: FND_DSQL.Do_Binds();
8684: END IF;

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

8704: END IF;
8705: END IF;
8706: --End 4105841
8707:
8708: IF (p_execute_dml = FND_API.G_TRUE) THEN
8709: l_number_of_rows := DBMS_SQL.Execute(l_cursor_id);
8710: END IF;
8711:
8712:

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

8726: --
8727:
8728: IF (l_propagate_hierarchy
8729: AND p_attr_group_metadata_obj.HIERARCHY_PROPAGATE_FLAG = 'Y'
8730: AND px_attr_diffs.COUNT > 0 AND p_execute_dml = FND_API.G_TRUE) THEN --Bug fix 5220020
8731: Propagate_Attributes( p_pk_column_name_value_pairs
8732: , p_class_code_name_value_pairs
8733: , p_data_level_name_value_pairs
8734: , px_attr_diffs

Line 8770: IF FND_API.To_Boolean(p_commit) THEN

8766: END IF;
8767:
8768: Debug_Msg('In Update_Row, done', 1);
8769:
8770: IF FND_API.To_Boolean(p_commit) THEN
8771: COMMIT WORK;
8772: END IF;
8773:
8774: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8774: x_return_status := FND_API.G_RET_STS_SUCCESS;

8770: IF FND_API.To_Boolean(p_commit) THEN
8771: COMMIT WORK;
8772: END IF;
8773:
8774: x_return_status := FND_API.G_RET_STS_SUCCESS;
8775:
8776: EXCEPTION
8777: -----------------------------------------------------------
8778: -- There are no expected errors in this procedure, so... --

Line 8786: IF FND_API.To_Boolean(p_commit) THEN

8782: --don't put to the stack already added in EGO_WF_WRAPPER_PVT
8783: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
8784: Debug_Msg('Update_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
8785:
8786: IF FND_API.To_Boolean(p_commit) THEN
8787: ROLLBACK TO update_row;
8788: END IF;
8789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8790: --End 4105841

Line 8789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8785:
8786: IF FND_API.To_Boolean(p_commit) THEN
8787: ROLLBACK TO update_row;
8788: END IF;
8789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8790: --End 4105841
8791:
8792: WHEN OTHERS THEN
8793: Debug_Msg('Update_Row EXCEPTION others '||SQLERRM);

Line 8794: IF FND_API.To_Boolean(p_commit) THEN

8790: --End 4105841
8791:
8792: WHEN OTHERS THEN
8793: Debug_Msg('Update_Row EXCEPTION others '||SQLERRM);
8794: IF FND_API.To_Boolean(p_commit) THEN
8795: ROLLBACK TO update_row;
8796: END IF;
8797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8798:

Line 8797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8793: Debug_Msg('Update_Row EXCEPTION others '||SQLERRM);
8794: IF FND_API.To_Boolean(p_commit) THEN
8795: ROLLBACK TO update_row;
8796: END IF;
8797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8798:
8799: DECLARE
8800: l_token_table ERROR_HANDLER.Token_Tbl_Type;
8801: BEGIN

Line 8813: ,p_message_type => FND_API.G_RET_STS_ERROR

8809: ERROR_HANDLER.Add_Error_Message(
8810: p_message_name => 'EGO_PLSQL_ERR'
8811: ,p_application_id => 'EGO'
8812: ,p_token_tbl => l_token_table
8813: ,p_message_type => FND_API.G_RET_STS_ERROR
8814: ,p_row_identifier => G_USER_ROW_IDENTIFIER
8815: ,p_entity_id => p_entity_id
8816: ,p_entity_index => p_entity_index
8817: ,p_entity_code => p_entity_code

Line 8842: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE

8838: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ
8839: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
8840: ,p_pending_b_table_name IN VARCHAR2
8841: ,p_pending_tl_table_name IN VARCHAR2
8842: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
8843: -- Start ssingal -For Ucc Net Attribute Propagation
8844: ,p_bulkload_flag IN BOOLEAN DEFAULT FALSE
8845: ,px_attr_diffs IN OUT NOCOPY EGO_USER_ATTR_DIFF_TABLE
8846: -- End ssingal -For Ucc Net Attribute Propagation

Line 8885: IF FND_API.To_Boolean(p_commit) THEN

8881: BEGIN
8882:
8883: Debug_Msg('In Delete_Row, starting', 1);
8884:
8885: IF FND_API.To_Boolean(p_commit) THEN
8886: SAVEPOINT delete_row;
8887: END IF;
8888:
8889: -- Check for call compatibility

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

8886: SAVEPOINT delete_row;
8887: END IF;
8888:
8889: -- Check for call compatibility
8890: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
8891: l_api_name, G_PKG_NAME)
8892: THEN
8893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8894: END IF;

Line 8893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8889: -- Check for call compatibility
8890: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
8891: l_api_name, G_PKG_NAME)
8892: THEN
8893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8894: END IF;
8895:
8896: IF (p_extension_id IS NULL) THEN
8897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8894: END IF;
8895:
8896: IF (p_extension_id IS NULL) THEN
8897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8898: END IF;
8899: -- Start ssingal -For Ucc Net Attribute Propagation
8900: IF p_bulkload_flag THEN
8901: l_propagate_hierarchy := FALSE;

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

9033: --End 4105841
9034:
9035: Set_Binds_And_Dml(l_dynamic_sql ,'B');
9036:
9037: IF (p_execute_dml = FND_API.G_TRUE) THEN
9038: EXECUTE IMMEDIATE l_dynamic_sql;
9039: END IF;
9040: END IF;
9041:

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

9057: Debug_SQL(l_dynamic_sql);
9058:
9059: Set_Binds_And_Dml(l_dynamic_sql ,'TL');
9060:
9061: IF (p_execute_dml = FND_API.G_TRUE) THEN
9062: EXECUTE IMMEDIATE l_dynamic_sql;
9063: END IF;
9064: -- Start ssingal -For Ucc Net Attribute Propagation
9065:

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

9065:
9066: -- Only propagate if at least one attribute has EIH code = LP/AP
9067: IF (l_propagate_hierarchy AND
9068: p_attr_group_metadata_obj.HIERARCHY_PROPAGATE_FLAG = 'Y'
9069: AND px_attr_diffs.COUNT > 0 AND p_execute_dml = FND_API.G_TRUE) THEN --Bug fix 5220020
9070:
9071: Propagate_Attributes( p_pk_column_name_value_pairs
9072: , p_class_code_name_value_pairs
9073: , p_data_level_name_value_pairs

Line 9111: IF FND_API.To_Boolean(p_commit) THEN

9107: END IF;
9108:
9109: Debug_Msg('In Delete_Row, done', 1);
9110:
9111: IF FND_API.To_Boolean(p_commit) THEN
9112: COMMIT WORK;
9113: END IF;
9114:
9115: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9115: x_return_status := FND_API.G_RET_STS_SUCCESS;

9111: IF FND_API.To_Boolean(p_commit) THEN
9112: COMMIT WORK;
9113: END IF;
9114:
9115: x_return_status := FND_API.G_RET_STS_SUCCESS;
9116:
9117: EXCEPTION
9118: -----------------------------------------------------------
9119: -- There are no expected errors in this procedure, so... --

Line 9127: IF FND_API.To_Boolean(p_commit) THEN

9123: --don't put to the stack already added in EGO_WF_WRAPPER_PVT
9124: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
9125: Debug_Msg('Delete_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
9126:
9127: IF FND_API.To_Boolean(p_commit) THEN
9128: ROLLBACK TO delete_row;
9129: END IF;
9130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9131: --End 4105841

Line 9130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9126:
9127: IF FND_API.To_Boolean(p_commit) THEN
9128: ROLLBACK TO delete_row;
9129: END IF;
9130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9131: --End 4105841
9132: WHEN OTHERS THEN
9133: Debug_Msg('Delete_Row EXCEPTION others '||SQLERRM);
9134: IF FND_API.To_Boolean(p_commit) THEN

Line 9134: IF FND_API.To_Boolean(p_commit) THEN

9130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9131: --End 4105841
9132: WHEN OTHERS THEN
9133: Debug_Msg('Delete_Row EXCEPTION others '||SQLERRM);
9134: IF FND_API.To_Boolean(p_commit) THEN
9135: ROLLBACK TO delete_row;
9136: END IF;
9137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9138:

Line 9137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9133: Debug_Msg('Delete_Row EXCEPTION others '||SQLERRM);
9134: IF FND_API.To_Boolean(p_commit) THEN
9135: ROLLBACK TO delete_row;
9136: END IF;
9137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9138:
9139: DECLARE
9140: l_token_table ERROR_HANDLER.Token_Tbl_Type;
9141: BEGIN

Line 9153: ,p_message_type => FND_API.G_RET_STS_ERROR

9149: ERROR_HANDLER.Add_Error_Message(
9150: p_message_name => 'EGO_PLSQL_ERR'
9151: ,p_application_id => 'EGO'
9152: ,p_token_tbl => l_token_table
9153: ,p_message_type => FND_API.G_RET_STS_ERROR
9154: ,p_row_identifier => G_USER_ROW_IDENTIFIER
9155: ,p_entity_id => p_entity_id
9156: ,p_entity_index => p_entity_index
9157: ,p_entity_code => p_entity_code

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

9165:
9166: PROCEDURE Validate_Row_Pvt (
9167: p_api_version IN NUMBER
9168: ,p_object_id IN NUMBER
9169: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE --Added for bugFix:5275391
9170: ,p_attr_group_metadata_obj IN EGO_ATTR_GROUP_METADATA_OBJ
9171: ,p_ext_table_metadata_obj IN EGO_EXT_TABLE_METADATA_OBJ
9172: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
9173: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

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

9203:
9204: Debug_Msg(l_api_name || ' starting', 1);
9205:
9206: -- Check for call compatibility
9207: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
9208: l_api_name, G_PKG_NAME)
9209: THEN
9210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9211: END IF;

Line 9210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9206: -- Check for call compatibility
9207: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
9208: l_api_name, G_PKG_NAME)
9209: THEN
9210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9211: END IF;
9212:
9213: Debug_Msg(l_api_name || ' calling Is_Data_Level_Correct ', 1);
9214: IF (NOT Is_Data_Level_Correct(

Line 9230: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 9295: ,p_message_type => FND_API.G_RET_STS_ERROR

9291: ERROR_HANDLER.Add_Error_Message(
9292: p_message_name => l_err_msg_name
9293: ,p_application_id => 'EGO'
9294: ,p_token_tbl => l_token_table
9295: ,p_message_type => FND_API.G_RET_STS_ERROR
9296: ,p_row_identifier => G_USER_ROW_IDENTIFIER
9297: ,p_entity_id => p_entity_id
9298: ,p_entity_index => p_entity_index
9299: ,p_entity_code => p_entity_code

Line 9335: ,p_message_type => FND_API.G_RET_STS_ERROR

9331: ERROR_HANDLER.Add_Error_Message(
9332: p_message_name => l_err_msg_name
9333: ,p_application_id => 'EGO'
9334: ,p_token_tbl => l_token_table
9335: ,p_message_type => FND_API.G_RET_STS_ERROR
9336: ,p_row_identifier => G_USER_ROW_IDENTIFIER
9337: ,p_entity_id => p_entity_id
9338: ,p_entity_index => p_entity_index
9339: ,p_entity_code => p_entity_code

Line 9368: ,p_message_type => FND_API.G_RET_STS_ERROR

9364: ERROR_HANDLER.Add_Error_Message(
9365: p_message_name => l_err_msg_name
9366: ,p_application_id => 'EGO'
9367: ,p_token_tbl => l_token_table
9368: ,p_message_type => FND_API.G_RET_STS_ERROR
9369: ,p_row_identifier => G_USER_ROW_IDENTIFIER
9370: ,p_entity_id => p_entity_id
9371: ,p_entity_index => p_entity_index
9372: ,p_entity_code => p_entity_code

Line 9401: ,p_message_type => FND_API.G_RET_STS_ERROR

9397: ERROR_HANDLER.Add_Error_Message(
9398: p_message_name => l_err_msg_name
9399: ,p_application_id => 'EGO'
9400: ,p_token_tbl => l_token_table
9401: ,p_message_type => FND_API.G_RET_STS_ERROR
9402: ,p_row_identifier => G_USER_ROW_IDENTIFIER
9403: ,p_entity_id => p_entity_id
9404: ,p_entity_index => p_entity_index
9405: ,p_entity_code => p_entity_code

Line 9439: ,p_message_type => FND_API.G_RET_STS_ERROR

9435: ERROR_HANDLER.Add_Error_Message(
9436: p_message_name => l_err_msg_name
9437: ,p_application_id => 'EGO'
9438: ,p_token_tbl => l_token_table
9439: ,p_message_type => FND_API.G_RET_STS_ERROR
9440: ,p_row_identifier => G_USER_ROW_IDENTIFIER
9441: ,p_entity_id => p_entity_id
9442: ,p_entity_index => p_entity_index
9443: ,p_entity_code => p_entity_code

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

9479: -- Check if hierarchy security flags prevent the current changes from
9480: -- being made.
9481: -------------------------------------------------------------------------
9482:
9483: IF (FND_API.To_Boolean(p_validate_hierarchy) AND--Added for bugFix:5275391
9484: NOT (l_attr_metadata_obj.EDIT_IN_HIERARCHY_CODE = 'A' OR
9485: l_attr_metadata_obj.EDIT_IN_HIERARCHY_CODE = 'AP')
9486: ) THEN
9487: -- Get is_root/is_leaf

Line 9506: ,p_message_type => FND_API.G_RET_STS_ERROR

9502: ERROR_HANDLER.Add_Error_Message(
9503: p_message_name => l_err_msg_name
9504: ,p_application_id => 'EGO'
9505: ,p_token_tbl => l_token_table
9506: ,p_message_type => FND_API.G_RET_STS_ERROR
9507: ,p_row_identifier => G_USER_ROW_IDENTIFIER
9508: ,p_entity_id => p_entity_id
9509: ,p_entity_index => p_entity_index
9510: ,p_entity_code => p_entity_code

Line 9533: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 9585: RAISE FND_API.G_EXC_ERROR;

9581: Debug_Msg(l_api_name ||' done', 1);
9582:
9583: IF (NOT l_is_valid_row) THEN
9584:
9585: RAISE FND_API.G_EXC_ERROR;
9586:
9587: END IF;
9588:
9589: -----------------------------------

Line 9591: x_return_status := FND_API.G_RET_STS_SUCCESS;

9587: END IF;
9588:
9589: -----------------------------------
9590:
9591: x_return_status := FND_API.G_RET_STS_SUCCESS;
9592:
9593: EXCEPTION
9594: WHEN FND_API.G_EXC_ERROR THEN
9595: Debug_Msg(l_api_name ||' EXCEPTION FND_API.G_EXC_ERROR raised ', 1);

Line 9594: WHEN FND_API.G_EXC_ERROR THEN

9590:
9591: x_return_status := FND_API.G_RET_STS_SUCCESS;
9592:
9593: EXCEPTION
9594: WHEN FND_API.G_EXC_ERROR THEN
9595: Debug_Msg(l_api_name ||' EXCEPTION FND_API.G_EXC_ERROR raised ', 1);
9596: x_return_status := FND_API.G_RET_STS_ERROR;
9597:
9598: WHEN OTHERS THEN

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

9591: x_return_status := FND_API.G_RET_STS_SUCCESS;
9592:
9593: EXCEPTION
9594: WHEN FND_API.G_EXC_ERROR THEN
9595: Debug_Msg(l_api_name ||' EXCEPTION FND_API.G_EXC_ERROR raised ', 1);
9596: x_return_status := FND_API.G_RET_STS_ERROR;
9597:
9598: WHEN OTHERS THEN
9599: Debug_Msg(l_api_name ||' EXCEPTION OTHERS raised '||SQLERRM, 1);

Line 9596: x_return_status := FND_API.G_RET_STS_ERROR;

9592:
9593: EXCEPTION
9594: WHEN FND_API.G_EXC_ERROR THEN
9595: Debug_Msg(l_api_name ||' EXCEPTION FND_API.G_EXC_ERROR raised ', 1);
9596: x_return_status := FND_API.G_RET_STS_ERROR;
9597:
9598: WHEN OTHERS THEN
9599: Debug_Msg(l_api_name ||' EXCEPTION OTHERS raised '||SQLERRM, 1);
9600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9596: x_return_status := FND_API.G_RET_STS_ERROR;
9597:
9598: WHEN OTHERS THEN
9599: Debug_Msg(l_api_name ||' EXCEPTION OTHERS raised '||SQLERRM, 1);
9600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9601:
9602: l_token_table.DELETE();
9603: l_token_table(1).TOKEN_NAME := 'PKG_NAME';
9604: l_token_table(1).TOKEN_VALUE := G_PKG_NAME;

Line 9614: ,p_message_type => FND_API.G_RET_STS_ERROR

9610: ERROR_HANDLER.Add_Error_Message(
9611: p_message_name => 'EGO_PLSQL_ERR'
9612: ,p_application_id => 'EGO'
9613: ,p_token_tbl => l_token_table
9614: ,p_message_type => FND_API.G_RET_STS_ERROR
9615: ,p_row_identifier => G_USER_ROW_IDENTIFIER
9616: ,p_entity_id => p_entity_id
9617: ,p_entity_index => p_entity_index
9618: ,p_entity_code => p_entity_code

Line 9644: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE

9640: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
9641: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
9642: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
9643: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
9644: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_TRUE
9645: ,p_entity_id IN VARCHAR2 DEFAULT NULL
9646: ,p_entity_index IN NUMBER DEFAULT NULL
9647: ,p_entity_code IN VARCHAR2 DEFAULT NULL
9648: ,p_commit IN VARCHAR2

Line 9667: IF FND_API.To_Boolean(p_commit) THEN

9663: BEGIN
9664:
9665: Debug_Msg(l_api_name || ' starting with p_data_level '||p_data_level, 1);
9666:
9667: IF FND_API.To_Boolean(p_commit) THEN
9668: SAVEPOINT Perform_DML_On_Row_PVT;
9669: END IF;
9670:
9671: -- Check for call compatibility

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

9668: SAVEPOINT Perform_DML_On_Row_PVT;
9669: END IF;
9670:
9671: -- Check for call compatibility
9672: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
9673: l_api_name, G_PKG_NAME)
9674: THEN
9675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9676: END IF;

Line 9675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9671: -- Check for call compatibility
9672: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
9673: l_api_name, G_PKG_NAME)
9674: THEN
9675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9676: END IF;
9677:
9678: IF (p_mode = G_CREATE_MODE) THEN
9679: Insert_Row(

Line 9699: ,p_commit => FND_API.G_FALSE

9695: ,p_execute_dml => p_execute_dml
9696: ,p_entity_id => p_entity_id
9697: ,p_entity_index => p_entity_index
9698: ,p_entity_code => p_entity_code
9699: ,p_commit => FND_API.G_FALSE
9700: ,p_bulkload_flag => p_bulkload_flag
9701: ,px_attr_diffs => l_attr_diffs
9702: ,p_raise_business_event => p_raise_business_event
9703: ,x_extension_id => x_extension_id

Line 9727: ,p_commit => FND_API.G_FALSE

9723: ,p_execute_dml => p_execute_dml
9724: ,p_entity_id => p_entity_id
9725: ,p_entity_index => p_entity_index
9726: ,p_entity_code => p_entity_code
9727: ,p_commit => FND_API.G_FALSE
9728: ,p_bulkload_flag => p_bulkload_flag
9729: ,px_attr_diffs => l_attr_diffs
9730: ,p_raise_business_event => p_raise_business_event
9731: ,x_return_status => x_return_status

Line 9755: ,p_commit => FND_API.G_FALSE

9751: ,px_attr_diffs => l_attr_diffs
9752: ,p_entity_id => p_entity_id
9753: ,p_entity_index => p_entity_index
9754: ,p_entity_code => p_entity_code
9755: ,p_commit => FND_API.G_FALSE
9756: ,p_raise_business_event => p_raise_business_event
9757: ,x_return_status => x_return_status
9758: );
9759: ELSE

Line 9760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9756: ,p_raise_business_event => p_raise_business_event
9757: ,x_return_status => x_return_status
9758: );
9759: ELSE
9760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9761:
9762: END IF;
9763:
9764: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

9760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9761:
9762: END IF;
9763:
9764: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9765: RAISE FND_API.G_EXC_ERROR;
9766: END IF;
9767:
9768: IF(x_extension_id IS NULL AND p_extension_id IS NOT NULL ) THEN

Line 9765: RAISE FND_API.G_EXC_ERROR;

9761:
9762: END IF;
9763:
9764: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9765: RAISE FND_API.G_EXC_ERROR;
9766: END IF;
9767:
9768: IF(x_extension_id IS NULL AND p_extension_id IS NOT NULL ) THEN
9769: x_extension_id := p_extension_id;

Line 9772: IF FND_API.To_Boolean(p_commit) THEN

9768: IF(x_extension_id IS NULL AND p_extension_id IS NOT NULL ) THEN
9769: x_extension_id := p_extension_id;
9770: END IF;
9771:
9772: IF FND_API.To_Boolean(p_commit) THEN
9773: COMMIT WORK;
9774: END IF;
9775:
9776: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9776: x_return_status := FND_API.G_RET_STS_SUCCESS;

9772: IF FND_API.To_Boolean(p_commit) THEN
9773: COMMIT WORK;
9774: END IF;
9775:
9776: x_return_status := FND_API.G_RET_STS_SUCCESS;
9777: Debug_Msg( l_api_name || ' ending ', 1);
9778:
9779: EXCEPTION
9780: WHEN FND_API.G_EXC_ERROR THEN

Line 9780: WHEN FND_API.G_EXC_ERROR THEN

9776: x_return_status := FND_API.G_RET_STS_SUCCESS;
9777: Debug_Msg( l_api_name || ' ending ', 1);
9778:
9779: EXCEPTION
9780: WHEN FND_API.G_EXC_ERROR THEN
9781: Debug_Msg( l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR ', 1);
9782: IF FND_API.To_Boolean(p_commit) THEN
9783: ROLLBACK TO Perform_DML_On_Row_PVT;
9784: END IF;

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

9777: Debug_Msg( l_api_name || ' ending ', 1);
9778:
9779: EXCEPTION
9780: WHEN FND_API.G_EXC_ERROR THEN
9781: Debug_Msg( l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR ', 1);
9782: IF FND_API.To_Boolean(p_commit) THEN
9783: ROLLBACK TO Perform_DML_On_Row_PVT;
9784: END IF;
9785: -----------------------------------------------------------

Line 9782: IF FND_API.To_Boolean(p_commit) THEN

9778:
9779: EXCEPTION
9780: WHEN FND_API.G_EXC_ERROR THEN
9781: Debug_Msg( l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR ', 1);
9782: IF FND_API.To_Boolean(p_commit) THEN
9783: ROLLBACK TO Perform_DML_On_Row_PVT;
9784: END IF;
9785: -----------------------------------------------------------
9786: -- If we get here, then the nested API call (whichever --

Line 9793: IF FND_API.To_Boolean(p_commit) THEN

9789: -----------------------------------------------------------
9790:
9791: WHEN OTHERS THEN
9792: Debug_Msg( l_api_name || ' EXCEPTION OTHERS '||SQLERRM, 1);
9793: IF FND_API.To_Boolean(p_commit) THEN
9794: ROLLBACK TO Perform_DML_On_Row_PVT;
9795: END IF;
9796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9797:

Line 9796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9792: Debug_Msg( l_api_name || ' EXCEPTION OTHERS '||SQLERRM, 1);
9793: IF FND_API.To_Boolean(p_commit) THEN
9794: ROLLBACK TO Perform_DML_On_Row_PVT;
9795: END IF;
9796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9797:
9798: DECLARE
9799: l_token_table ERROR_HANDLER.Token_Tbl_Type;
9800: BEGIN

Line 9812: ,p_message_type => FND_API.G_RET_STS_ERROR

9808: ERROR_HANDLER.Add_Error_Message(
9809: p_message_name => 'EGO_PLSQL_ERR'
9810: ,p_application_id => 'EGO'
9811: ,p_token_tbl => l_token_table
9812: ,p_message_type => FND_API.G_RET_STS_ERROR
9813: ,p_row_identifier => G_USER_ROW_IDENTIFIER
9814: ,p_entity_id => p_entity_id
9815: ,p_entity_index => p_entity_index
9816: ,p_entity_code => p_entity_code

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

9867: ,p_data_level_name_value_pairs => p_data_level_name_value_pairs
9868: ,px_attr_name_value_pairs => px_attr_name_value_pairs
9869: ,x_return_status => l_return_status
9870: );
9871: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9872: RAISE FND_API.G_EXC_ERROR;
9873: END IF;
9874:
9875: --------------------------------------------------

Line 9872: RAISE FND_API.G_EXC_ERROR;

9868: ,px_attr_name_value_pairs => px_attr_name_value_pairs
9869: ,x_return_status => l_return_status
9870: );
9871: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9872: RAISE FND_API.G_EXC_ERROR;
9873: END IF;
9874:
9875: --------------------------------------------------
9876: -- Find out whether we're inserting or updating --

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

9887: ,x_extension_id => l_extension_id
9888: ,x_mode => l_mode
9889: ,x_return_status => l_return_status
9890: );
9891: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9892: RAISE FND_API.G_EXC_ERROR;
9893: END IF;
9894:
9895: ----------------------------------------------------------------------

Line 9892: RAISE FND_API.G_EXC_ERROR;

9888: ,x_mode => l_mode
9889: ,x_return_status => l_return_status
9890: );
9891: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9892: RAISE FND_API.G_EXC_ERROR;
9893: END IF;
9894:
9895: ----------------------------------------------------------------------
9896: -- Validate the current collection of Attribute values prior to DML --

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

9909: ,p_mode => l_mode
9910: ,px_attr_name_value_pairs => px_attr_name_value_pairs
9911: ,x_return_status => l_return_status
9912: );
9913: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9914: RAISE FND_API.G_EXC_ERROR;
9915: END IF;
9916:
9917: -----------------------------------------------------

Line 9914: RAISE FND_API.G_EXC_ERROR;

9910: ,px_attr_name_value_pairs => px_attr_name_value_pairs
9911: ,x_return_status => l_return_status
9912: );
9913: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9914: RAISE FND_API.G_EXC_ERROR;
9915: END IF;
9916:
9917: -----------------------------------------------------
9918: -- If the row is valid, either insert or update it --

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

9933: ,p_commit => p_commit
9934: ,x_extension_id => l_dummy_ext_id
9935: ,x_return_status => l_return_status
9936: );
9937: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9938: RAISE FND_API.G_EXC_ERROR;
9939: END IF;
9940: Debug_Msg(l_api_name || ' ending ',1);
9941:

Line 9938: RAISE FND_API.G_EXC_ERROR;

9934: ,x_extension_id => l_dummy_ext_id
9935: ,x_return_status => l_return_status
9936: );
9937: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9938: RAISE FND_API.G_EXC_ERROR;
9939: END IF;
9940: Debug_Msg(l_api_name || ' ending ',1);
9941:
9942: END Perform_DML_On_Template_Row;

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

10020: Debug_Msg(l_api_name || ' done Set_Up_Business_Object_Session: '||x_return_status, 2);
10021: ----------------------------------------------------------------------
10022: -- If an error was found, we've already added it to the error stack --
10023: ----------------------------------------------------------------------
10024: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10025:
10026: RAISE FND_API.G_EXC_ERROR;
10027:
10028: END IF;

Line 10026: RAISE FND_API.G_EXC_ERROR;

10022: -- If an error was found, we've already added it to the error stack --
10023: ----------------------------------------------------------------------
10024: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10025:
10026: RAISE FND_API.G_EXC_ERROR;
10027:
10028: END IF;
10029: END IF;
10030:

Line 10077: ,p_message_type => FND_API.G_RET_STS_ERROR

10073: ERROR_HANDLER.Add_Error_Message(
10074: p_message_name => l_err_msg_name
10075: ,p_application_id => 'EGO'
10076: ,p_token_tbl => l_token_table
10077: ,p_message_type => FND_API.G_RET_STS_ERROR
10078: ,p_row_identifier => G_USER_ROW_IDENTIFIER
10079: ,p_entity_id => p_entity_id
10080: ,p_entity_index => p_entity_index
10081: ,p_entity_code => p_entity_code

Line 10085: RAISE FND_API.G_EXC_ERROR;

10081: ,p_entity_code => p_entity_code
10082: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
10083: );
10084: Debug_Msg(l_api_name || 'before raising exception 0 ');
10085: RAISE FND_API.G_EXC_ERROR;
10086:
10087: ELSIF (NOT Do_All_Attrs_Exist(x_attr_group_metadata_obj
10088: ,px_attr_name_value_pairs
10089: ,p_entity_id

Line 10097: RAISE FND_API.G_EXC_ERROR;

10093: ----------------------------------------------------------------
10094: -- We've logged an error for every Attr that we couldn't find --
10095: ----------------------------------------------------------------
10096: Debug_Msg(l_api_name || 'before raising exception 1 ');
10097: RAISE FND_API.G_EXC_ERROR;
10098:
10099: END IF;
10100:
10101: x_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(px_object_id);

Line 10112: ,p_message_type => FND_API.G_RET_STS_ERROR

10108: ERROR_HANDLER.Add_Error_Message(
10109: p_message_name => 'EGO_EF_EXT_TABLE_METADATA_ERR'
10110: ,p_application_id => 'EGO'
10111: ,p_token_tbl => l_token_table
10112: ,p_message_type => FND_API.G_RET_STS_ERROR
10113: ,p_row_identifier => G_USER_ROW_IDENTIFIER
10114: ,p_entity_id => p_entity_id
10115: ,p_entity_index => p_entity_index
10116: ,p_entity_code => p_entity_code

Line 10121: RAISE FND_API.G_EXC_ERROR;

10117: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
10118: );
10119: Debug_Msg(l_api_name || 'before raising exception 2 ');
10120:
10121: RAISE FND_API.G_EXC_ERROR;
10122:
10123: END IF;
10124:
10125: -------------------------------------------------------------------------------

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

10154: ------------------------------------------------------------
10155: -- If errors were found in processing the display values, --
10156: -- we've already added them to the error stack --
10157: ------------------------------------------------------------
10158: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10159: RAISE FND_API.G_EXC_ERROR;
10160: END IF;
10161:
10162: --------------------------------------------------------------------

Line 10159: RAISE FND_API.G_EXC_ERROR;

10155: -- If errors were found in processing the display values, --
10156: -- we've already added them to the error stack --
10157: ------------------------------------------------------------
10158: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10159: RAISE FND_API.G_EXC_ERROR;
10160: END IF;
10161:
10162: --------------------------------------------------------------------
10163: -- Now we determine whether we're creating, updating or deleting, --

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

10187: -----------------------------------------------------
10188: -- If errors were found in the previous procedure, --
10189: -- we've already added them to the error stack --
10190: -----------------------------------------------------
10191: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10192: RAISE FND_API.G_EXC_ERROR;
10193: END IF;
10194:
10195: Debug_Msg(l_api_name || ' after checking, x_mode is '||x_mode);

Line 10192: RAISE FND_API.G_EXC_ERROR;

10188: -- If errors were found in the previous procedure, --
10189: -- we've already added them to the error stack --
10190: -----------------------------------------------------
10191: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10192: RAISE FND_API.G_EXC_ERROR;
10193: END IF;
10194:
10195: Debug_Msg(l_api_name || ' after checking, x_mode is '||x_mode);
10196: IF (UPPER(x_mode) = G_UPDATE_MODE OR UPPER(x_mode) = G_DELETE_MODE) THEN

Line 10203: WHEN FND_API.G_EXC_ERROR THEN

10199:
10200: Debug_Msg(l_api_name || ' done', 2);
10201:
10202: EXCEPTION
10203: WHEN FND_API.G_EXC_ERROR THEN
10204: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR', 1);
10205: x_return_status := FND_API.G_RET_STS_ERROR;
10206:
10207: WHEN OTHERS THEN

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

10200: Debug_Msg(l_api_name || ' done', 2);
10201:
10202: EXCEPTION
10203: WHEN FND_API.G_EXC_ERROR THEN
10204: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR', 1);
10205: x_return_status := FND_API.G_RET_STS_ERROR;
10206:
10207: WHEN OTHERS THEN
10208: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM, 1);

Line 10205: x_return_status := FND_API.G_RET_STS_ERROR;

10201:
10202: EXCEPTION
10203: WHEN FND_API.G_EXC_ERROR THEN
10204: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR', 1);
10205: x_return_status := FND_API.G_RET_STS_ERROR;
10206:
10207: WHEN OTHERS THEN
10208: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM, 1);
10209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10205: x_return_status := FND_API.G_RET_STS_ERROR;
10206:
10207: WHEN OTHERS THEN
10208: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM, 1);
10209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10210: l_token_table.DELETE();
10211: l_token_table(1).TOKEN_NAME := 'PKG_NAME';
10212: l_token_table(1).TOKEN_VALUE := G_PKG_NAME;
10213: l_token_table(2).TOKEN_NAME := 'API_NAME';

Line 10222: ,p_message_type => FND_API.G_RET_STS_ERROR

10218: ERROR_HANDLER.Add_Error_Message(
10219: p_message_name => 'EGO_PLSQL_ERR'
10220: ,p_application_id => 'EGO'
10221: ,p_token_tbl => l_token_table
10222: ,p_message_type => FND_API.G_RET_STS_ERROR
10223: ,p_row_identifier => G_USER_ROW_IDENTIFIER
10224: ,p_entity_id => p_entity_id
10225: ,p_entity_index => p_entity_index
10226: ,p_entity_code => p_entity_code

Line 10258: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE

10254: ,p_entity_id IN NUMBER DEFAULT NULL
10255: ,p_entity_index IN NUMBER DEFAULT NULL
10256: ,p_entity_code IN VARCHAR2 DEFAULT NULL
10257: ,p_debug_level IN NUMBER DEFAULT 0
10258: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
10259: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
10260: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
10261: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
10262: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 10259: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE

10255: ,p_entity_index IN NUMBER DEFAULT NULL
10256: ,p_entity_code IN VARCHAR2 DEFAULT NULL
10257: ,p_debug_level IN NUMBER DEFAULT 0
10258: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
10259: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
10260: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
10261: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
10262: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10263: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 10260: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE

10256: ,p_entity_code IN VARCHAR2 DEFAULT NULL
10257: ,p_debug_level IN NUMBER DEFAULT 0
10258: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
10259: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
10260: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
10261: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
10262: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10263: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
10264: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 10261: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

10257: ,p_debug_level IN NUMBER DEFAULT 0
10258: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
10259: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
10260: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
10261: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
10262: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10263: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
10264: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
10265: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 10262: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

10258: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
10259: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
10260: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
10261: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
10262: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10263: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
10264: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
10265: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
10266: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE

Line 10263: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

10259: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
10260: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
10261: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
10262: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10263: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
10264: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
10265: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
10266: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
10267: ,x_failed_row_id_list OUT NOCOPY VARCHAR2

Line 10264: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

10260: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
10261: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
10262: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10263: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
10264: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
10265: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
10266: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
10267: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
10268: ,x_return_status OUT NOCOPY VARCHAR2

Line 10265: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

10261: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
10262: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10263: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
10264: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
10265: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
10266: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
10267: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
10268: ,x_return_status OUT NOCOPY VARCHAR2
10269: ,x_errorcode OUT NOCOPY NUMBER

Line 10328: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE

10324: ,p_entity_id IN NUMBER DEFAULT NULL
10325: ,p_entity_index IN NUMBER DEFAULT NULL
10326: ,p_entity_code IN VARCHAR2 DEFAULT NULL
10327: ,p_debug_level IN NUMBER DEFAULT 0
10328: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
10329: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
10330: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
10331: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
10332: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 10329: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE

10325: ,p_entity_index IN NUMBER DEFAULT NULL
10326: ,p_entity_code IN VARCHAR2 DEFAULT NULL
10327: ,p_debug_level IN NUMBER DEFAULT 0
10328: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
10329: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
10330: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
10331: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
10332: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10333: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 10330: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE

10326: ,p_entity_code IN VARCHAR2 DEFAULT NULL
10327: ,p_debug_level IN NUMBER DEFAULT 0
10328: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
10329: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
10330: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
10331: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
10332: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10333: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
10334: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 10331: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

10327: ,p_debug_level IN NUMBER DEFAULT 0
10328: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
10329: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
10330: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
10331: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
10332: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10333: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
10334: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
10335: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 10332: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

10328: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
10329: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
10330: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
10331: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
10332: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10333: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
10334: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
10335: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
10336: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE

Line 10333: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

10329: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE
10330: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
10331: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
10332: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10333: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
10334: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
10335: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
10336: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
10337: ,x_extension_id OUT NOCOPY NUMBER

Line 10334: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

10330: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
10331: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
10332: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10333: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
10334: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
10335: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
10336: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
10337: ,x_extension_id OUT NOCOPY NUMBER
10338: ,x_mode OUT NOCOPY VARCHAR2

Line 10335: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

10331: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
10332: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
10333: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
10334: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
10335: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
10336: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
10337: ,x_extension_id OUT NOCOPY NUMBER
10338: ,x_mode OUT NOCOPY VARCHAR2
10339: ,x_failed_row_id_list OUT NOCOPY VARCHAR2

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

10375:
10376: Debug_Msg(l_api_name || ' starting', 1);
10377:
10378: -- Check for call compatibility
10379: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
10380: l_api_name, G_PKG_NAME)
10381: THEN
10382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10383: END IF;

Line 10382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10378: -- Check for call compatibility
10379: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
10380: l_api_name, G_PKG_NAME)
10381: THEN
10382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10383: END IF;
10384:
10385: --------------------------------------------------------------------------------
10386: -- Start by dealing with caching, error-handling, and preliminary validations --

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

10398: ,p_entity_id => p_entity_id
10399: ,p_entity_index => p_entity_index
10400: ,p_entity_code => p_entity_code
10401: ,p_debug_level => p_debug_level
10402: ,p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10403: ,p_object_name => p_object_name
10404: ,p_pk_column_name_value_pairs => p_pk_column_name_value_pairs
10405: ,p_class_code_name_value_pairs => p_class_code_name_value_pairs
10406: ,p_init_fnd_msg_list => p_init_fnd_msg_list

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

10411:
10412: ----------------------------------------------------------------------
10413: -- If an error was found, we've already added it to the error stack --
10414: ----------------------------------------------------------------------
10415: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10416:
10417: --------------------------------------------------
10418: -- Mark every row in this instance as a failure --
10419: --------------------------------------------------

Line 10433: RAISE FND_API.G_EXC_ERROR;

10429: -- Trim the trailing ',' from x_failed_row_id_list if necessary --
10430: ------------------------------------------------------------------
10431: x_failed_row_id_list := RTRIM(x_failed_row_id_list, ',');
10432:
10433: RAISE FND_API.G_EXC_ERROR;
10434: END IF;
10435:
10436: ---------------------------------------------------------------
10437: -- If we pass the preliminary tests, we can process the data --

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

10593:
10594: -------------------------------------------------------
10595: -- Check whether this row was successfully processed --
10596: -------------------------------------------------------
10597: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10598:
10599: ----------------------------------------------------------------------------
10600: -- Since this row failed, put its ROW_IDENTIFIER into the failed row list --
10601: ----------------------------------------------------------------------------

Line 10610: x_return_status = FND_API.G_RET_STS_SUCCESS OR

10606: -- We keep x_return_status updated to reflect --
10607: -- the most serious error we come across --
10608: ------------------------------------------------
10609: IF (x_return_status IS NULL OR
10610: x_return_status = FND_API.G_RET_STS_SUCCESS OR
10611: (x_return_status = FND_API.G_RET_STS_ERROR AND
10612: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)) THEN
10613:
10614: x_return_status := l_return_status;

Line 10611: (x_return_status = FND_API.G_RET_STS_ERROR AND

10607: -- the most serious error we come across --
10608: ------------------------------------------------
10609: IF (x_return_status IS NULL OR
10610: x_return_status = FND_API.G_RET_STS_SUCCESS OR
10611: (x_return_status = FND_API.G_RET_STS_ERROR AND
10612: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)) THEN
10613:
10614: x_return_status := l_return_status;
10615:

Line 10612: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)) THEN

10608: ------------------------------------------------
10609: IF (x_return_status IS NULL OR
10610: x_return_status = FND_API.G_RET_STS_SUCCESS OR
10611: (x_return_status = FND_API.G_RET_STS_ERROR AND
10612: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)) THEN
10613:
10614: x_return_status := l_return_status;
10615:
10616: END IF;

Line 10631: RAISE FND_API.G_EXC_ERROR;

10627: x_msg_count := ERROR_HANDLER.Get_Message_Count();
10628:
10629: IF (x_msg_count > 0) THEN
10630:
10631: RAISE FND_API.G_EXC_ERROR;
10632:
10633: END IF;
10634:
10635: Debug_Msg('In Process_User_Attrs_Data, done', 1);

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

10634:
10635: Debug_Msg('In Process_User_Attrs_Data, done', 1);
10636:
10637: Close_Business_Object_Session(
10638: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10639: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10640: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10641: );
10642:

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

10635: Debug_Msg('In Process_User_Attrs_Data, done', 1);
10636:
10637: Close_Business_Object_Session(
10638: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10639: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10640: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10641: );
10642:
10643: IF FND_API.To_Boolean(p_commit) THEN

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

10636:
10637: Close_Business_Object_Session(
10638: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10639: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10640: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10641: );
10642:
10643: IF FND_API.To_Boolean(p_commit) THEN
10644: COMMIT WORK;

Line 10643: IF FND_API.To_Boolean(p_commit) THEN

10639: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10640: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10641: );
10642:
10643: IF FND_API.To_Boolean(p_commit) THEN
10644: COMMIT WORK;
10645: END IF;
10646:
10647: IF (x_return_status IS NULL) THEN

Line 10648: x_return_status := FND_API.G_RET_STS_SUCCESS;

10644: COMMIT WORK;
10645: END IF;
10646:
10647: IF (x_return_status IS NULL) THEN
10648: x_return_status := FND_API.G_RET_STS_SUCCESS;
10649: END IF;
10650:
10651: EXCEPTION
10652:

Line 10661: WHEN FND_API.G_EXC_ERROR THEN

10657: -- it encounters. If callers want different behavior, they can establish --
10658: -- a SAVEPOINT prior to calling this procedure and ROLLBACK if we report --
10659: -- any errors. --
10660: ----------------------------------------------------------------------------
10661: WHEN FND_API.G_EXC_ERROR THEN
10662: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR ', 1);
10663:
10664: -----------------------------------------------------------------------------
10665: -- Since we want to commit all successful rows, we will always call commit --

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

10658: -- a SAVEPOINT prior to calling this procedure and ROLLBACK if we report --
10659: -- any errors. --
10660: ----------------------------------------------------------------------------
10661: WHEN FND_API.G_EXC_ERROR THEN
10662: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR ', 1);
10663:
10664: -----------------------------------------------------------------------------
10665: -- Since we want to commit all successful rows, we will always call commit --
10666: -----------------------------------------------------------------------------

Line 10667: IF FND_API.To_Boolean(p_commit) THEN

10663:
10664: -----------------------------------------------------------------------------
10665: -- Since we want to commit all successful rows, we will always call commit --
10666: -----------------------------------------------------------------------------
10667: IF FND_API.To_Boolean(p_commit) THEN
10668: COMMIT WORK;
10669: END IF;
10670:
10671: --bug 9559993

Line 10672: x_return_status := FND_API.G_RET_STS_ERROR;

10668: COMMIT WORK;
10669: END IF;
10670:
10671: --bug 9559993
10672: x_return_status := FND_API.G_RET_STS_ERROR;
10673:
10674: Close_Business_Object_Session(
10675: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10676: ,p_log_errors => FND_API.To_Boolean(p_log_errors)

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

10671: --bug 9559993
10672: x_return_status := FND_API.G_RET_STS_ERROR;
10673:
10674: Close_Business_Object_Session(
10675: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10676: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10677: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10678: );
10679:

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

10672: x_return_status := FND_API.G_RET_STS_ERROR;
10673:
10674: Close_Business_Object_Session(
10675: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10676: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10677: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10678: );
10679:
10680: x_msg_count := ERROR_HANDLER.Get_Message_Count();

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

10673:
10674: Close_Business_Object_Session(
10675: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10676: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10677: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10678: );
10679:
10680: x_msg_count := ERROR_HANDLER.Get_Message_Count();
10681:

Line 10699: IF FND_API.To_Boolean(p_commit) THEN

10695: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM, 1);
10696: -----------------------------------------------------------------------------
10697: -- Since we want to commit all successful rows, we will always call commit --
10698: -----------------------------------------------------------------------------
10699: IF FND_API.To_Boolean(p_commit) THEN
10700: COMMIT WORK;
10701: END IF;
10702:
10703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10699: IF FND_API.To_Boolean(p_commit) THEN
10700: COMMIT WORK;
10701: END IF;
10702:
10703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10704:
10705: DECLARE
10706: l_token_table ERROR_HANDLER.Token_Tbl_Type;
10707: BEGIN

Line 10719: ,p_message_type => FND_API.G_RET_STS_ERROR

10715: ERROR_HANDLER.Add_Error_Message(
10716: p_message_name => 'EGO_PLSQL_ERR'
10717: ,p_application_id => 'EGO'
10718: ,p_token_tbl => l_token_table
10719: ,p_message_type => FND_API.G_RET_STS_ERROR
10720: ,p_row_identifier => G_USER_ROW_IDENTIFIER
10721: ,p_entity_id => p_entity_id
10722: ,p_entity_index => p_entity_index
10723: ,p_entity_code => p_entity_code

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

10725: );
10726: END;
10727:
10728: Close_Business_Object_Session(
10729: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10730: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10731: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10732: );
10733:

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

10726: END;
10727:
10728: Close_Business_Object_Session(
10729: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10730: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10731: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10732: );
10733:
10734: x_msg_count := ERROR_HANDLER.Get_Message_Count();

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

10727:
10728: Close_Business_Object_Session(
10729: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
10730: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
10731: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
10732: );
10733:
10734: x_msg_count := ERROR_HANDLER.Get_Message_Count();
10735:

Line 11207: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE

11203: ,p_entity_id IN NUMBER DEFAULT NULL
11204: ,p_entity_index IN NUMBER DEFAULT NULL
11205: ,p_entity_code IN VARCHAR2 DEFAULT NULL
11206: ,p_debug_level IN NUMBER DEFAULT 0
11207: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
11208: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11209: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11210: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11211: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

Line 11208: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

11204: ,p_entity_index IN NUMBER DEFAULT NULL
11205: ,p_entity_code IN VARCHAR2 DEFAULT NULL
11206: ,p_debug_level IN NUMBER DEFAULT 0
11207: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
11208: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11209: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11210: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11211: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
11212: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

Line 11209: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

11205: ,p_entity_code IN VARCHAR2 DEFAULT NULL
11206: ,p_debug_level IN NUMBER DEFAULT 0
11207: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
11208: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11209: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11210: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11211: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
11212: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
11213: ,x_return_status OUT NOCOPY VARCHAR2

Line 11210: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

11206: ,p_debug_level IN NUMBER DEFAULT 0
11207: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
11208: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
11209: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
11210: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11211: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
11212: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
11213: ,x_return_status OUT NOCOPY VARCHAR2
11214: ,x_errorcode OUT NOCOPY NUMBER

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

11303: BEGIN
11304:
11305: Debug_Msg(l_api_name||' starting', 1);
11306: -- Check for call compatibility
11307: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
11308: l_api_name, G_PKG_NAME)
11309: THEN
11310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11311: END IF;

Line 11310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11306: -- Check for call compatibility
11307: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
11308: l_api_name, G_PKG_NAME)
11309: THEN
11310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11311: END IF;
11312:
11313: Debug_Msg(l_api_name||' call compatible', 3);
11314:

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

11338: ,p_entity_id => p_entity_id
11339: ,p_entity_index => p_entity_index
11340: ,p_entity_code => p_entity_code
11341: ,p_debug_level => p_debug_level
11342: ,p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
11343: ,p_object_name => p_object_name
11344: ,p_pk_column_name_value_pairs => p_pk_column_name_value_pairs
11345: ,p_class_code_name_value_pairs => NULL -- SSARNOBA - I'm not sure if this should be null
11346: ,p_init_fnd_msg_list => p_init_fnd_msg_list

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

11351:
11352: ----------------------------------------------------------------------
11353: -- If an error was found, we've already added it to the error stack --
11354: ----------------------------------------------------------------------
11355: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11356: RAISE FND_API.G_EXC_ERROR;
11357: END IF;
11358:
11359: -------------------------------------------------

Line 11356: RAISE FND_API.G_EXC_ERROR;

11352: ----------------------------------------------------------------------
11353: -- If an error was found, we've already added it to the error stack --
11354: ----------------------------------------------------------------------
11355: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11356: RAISE FND_API.G_EXC_ERROR;
11357: END IF;
11358:
11359: -------------------------------------------------
11360: -- We could have a batch metadata retrieval procedure for the *_User_Attrs_Data calls;

Line 11413: 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'));

11409: ,l_curr_ag_request_obj.ATTR_GROUP_TYPE
11410: ,l_curr_ag_request_obj.ATTR_GROUP_NAME);
11411:
11412: -- Determine if the EXT table has a data level column
11413: 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'));
11414:
11415:
11416: ----------------------------------------------------------------------
11417: -- Scan the list of enabled data levels, and see if the data level --

Line 11486: ,p_message_type => FND_API.G_RET_STS_ERROR

11482: ERROR_HANDLER.Add_Error_Message(
11483: p_message_name => 'EGO_EF_DL_AG_INVALID'
11484: ,p_application_id => 'EGO'
11485: ,p_token_tbl => l_token_table
11486: ,p_message_type => FND_API.G_RET_STS_ERROR
11487: ,p_row_identifier => G_USER_ROW_IDENTIFIER
11488: ,p_entity_id => p_entity_id
11489: ,p_entity_index => p_entity_index
11490: ,p_entity_code => p_entity_code

Line 11494: RAISE FND_API.G_EXC_ERROR;

11490: ,p_entity_code => p_entity_code
11491: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
11492: );
11493: l_token_table.DELETE();
11494: RAISE FND_API.G_EXC_ERROR;
11495: END IF;
11496:
11497: -- We've found the metadata for the data level of this attribute group
11498:

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

11554: ,p_entity_code => p_entity_code
11555: ,x_return_status => x_return_status
11556: );
11557:
11558: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
11559: l_can_view_this_attr_group := FALSE;
11560: END IF;
11561: END IF;
11562:

Line 11622: RAISE FND_API.G_EXC_ERROR;

11618: ---------------------------------------------------------------------------
11619: -- See whether we put error messages onto the stack in the previous call --
11620: ---------------------------------------------------------------------------
11621: IF (l_requested_attr_names_table.EXISTS(-1)) THEN
11622: RAISE FND_API.G_EXC_ERROR;
11623: END IF;
11624: --===================================================================--
11625: -- Loop 1.2
11626: -- For every Attribute in our table of Attribute names, we find its --

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

11817: ------------------------------------------------------
11818: -- We log all errors we got as we close our session --
11819: ------------------------------------------------------
11820: Close_Business_Object_Session(
11821: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
11822: ,p_log_errors => TRUE
11823: ,p_write_to_concurrent_log => FALSE
11824: );
11825:

Line 11826: x_return_status := FND_API.G_RET_STS_SUCCESS;

11822: ,p_log_errors => TRUE
11823: ,p_write_to_concurrent_log => FALSE
11824: );
11825:
11826: x_return_status := FND_API.G_RET_STS_SUCCESS;
11827: RETURN ;
11828: END IF;
11829:
11830: --------------------------------------------------------------------

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

12213: ------------------------------------------------------
12214: -- We log all errors we got as we close our session --
12215: ------------------------------------------------------
12216: Close_Business_Object_Session(
12217: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
12218: ,p_log_errors => TRUE
12219: ,p_write_to_concurrent_log => FALSE
12220: );
12221:

Line 12222: x_return_status := FND_API.G_RET_STS_SUCCESS;

12218: ,p_log_errors => TRUE
12219: ,p_write_to_concurrent_log => FALSE
12220: );
12221:
12222: x_return_status := FND_API.G_RET_STS_SUCCESS;
12223:
12224: EXCEPTION
12225:
12226: WHEN FND_API.G_EXC_ERROR THEN

Line 12226: WHEN FND_API.G_EXC_ERROR THEN

12222: x_return_status := FND_API.G_RET_STS_SUCCESS;
12223:
12224: EXCEPTION
12225:
12226: WHEN FND_API.G_EXC_ERROR THEN
12227: Debug_Msg(l_api_name || ' FND_API.G_EXC_ERROR '||SQLERRM);
12228: -----------------------------------------
12229: -- Close the cursor if it's still open --
12230: -----------------------------------------

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

12223:
12224: EXCEPTION
12225:
12226: WHEN FND_API.G_EXC_ERROR THEN
12227: Debug_Msg(l_api_name || ' FND_API.G_EXC_ERROR '||SQLERRM);
12228: -----------------------------------------
12229: -- Close the cursor if it's still open --
12230: -----------------------------------------
12231: IF (l_cursor_id IS NOT NULL) THEN

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

12236: ------------------------------------------------------
12237: -- We log all errors we got as we close our session --
12238: ------------------------------------------------------
12239: Close_Business_Object_Session(
12240: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
12241: ,p_log_errors => TRUE
12242: ,p_write_to_concurrent_log => FALSE
12243: );
12244:

Line 12245: x_return_status := FND_API.G_RET_STS_ERROR;

12241: ,p_log_errors => TRUE
12242: ,p_write_to_concurrent_log => FALSE
12243: );
12244:
12245: x_return_status := FND_API.G_RET_STS_ERROR;
12246:
12247: x_msg_count := ERROR_HANDLER.Get_Message_Count();
12248: IF (x_msg_count = 1) THEN
12249: DECLARE

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

12269: ------------------------------------------------------
12270: -- We log all errors we got as we close our session --
12271: ------------------------------------------------------
12272: Close_Business_Object_Session(
12273: p_init_error_handler_flag => FND_API.To_Boolean(p_init_error_handler)
12274: ,p_log_errors => TRUE
12275: ,p_write_to_concurrent_log => FALSE
12276: );
12277:

Line 12278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

12274: ,p_log_errors => TRUE
12275: ,p_write_to_concurrent_log => FALSE
12276: );
12277:
12278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12279: l_token_table(1).TOKEN_NAME := 'PKG_NAME';
12280: l_token_table(1).TOKEN_VALUE := G_PKG_NAME;
12281: l_token_table(2).TOKEN_NAME := 'API_NAME';
12282: l_token_table(2).TOKEN_VALUE := l_api_name;

Line 12290: ,p_message_type => FND_API.G_RET_STS_ERROR

12286: ERROR_HANDLER.Add_Error_Message(
12287: p_message_name => 'EGO_PLSQL_ERR'
12288: ,p_application_id => 'EGO'
12289: ,p_token_tbl => l_token_table
12290: ,p_message_type => FND_API.G_RET_STS_ERROR
12291: ,p_row_identifier => G_USER_ROW_IDENTIFIER
12292: ,p_entity_id => p_entity_id
12293: ,p_entity_index => p_entity_index
12294: ,p_entity_code => p_entity_code

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

12323: ,p_attr_group_id IN NUMBER DEFAULT NULL
12324: ,p_application_id IN NUMBER DEFAULT NULL
12325: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
12326: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12327: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
12328: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12329: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12330: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12331: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 12337: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE

12333: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12334: ,p_entity_id IN NUMBER DEFAULT NULL
12335: ,p_entity_index IN NUMBER DEFAULT NULL
12336: ,p_entity_code IN VARCHAR2 DEFAULT NULL
12337: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
12338: ,p_language_to_process IN VARCHAR2 DEFAULT NULL
12339: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
12340: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
12341: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL

Line 12344: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

12340: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
12341: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
12342: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
12343: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL
12344: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12345: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12346: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12347: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
12348: ,x_return_status OUT NOCOPY VARCHAR2

Line 12345: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

12341: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
12342: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
12343: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL
12344: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12345: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12346: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12347: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
12348: ,x_return_status OUT NOCOPY VARCHAR2
12349: ,x_errorcode OUT NOCOPY NUMBER

Line 12346: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

12342: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
12343: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL
12344: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12345: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12346: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12347: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
12348: ,x_return_status OUT NOCOPY VARCHAR2
12349: ,x_errorcode OUT NOCOPY NUMBER
12350: ,x_msg_count OUT NOCOPY NUMBER

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

12399: ,p_attr_group_id IN NUMBER DEFAULT NULL
12400: ,p_application_id IN NUMBER DEFAULT NULL
12401: ,p_attr_group_type IN VARCHAR2 DEFAULT NULL
12402: ,p_attr_group_name IN VARCHAR2 DEFAULT NULL
12403: ,p_validate_hierarchy IN VARCHAR2 DEFAULT FND_API.G_TRUE--Added for bugFix:5275391
12404: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12405: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
12406: ,p_data_level IN VARCHAR2 DEFAULT NULL --R12C
12407: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 12413: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE

12409: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
12410: ,p_entity_id IN NUMBER DEFAULT NULL
12411: ,p_entity_index IN NUMBER DEFAULT NULL
12412: ,p_entity_code IN VARCHAR2 DEFAULT NULL
12413: ,p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE
12414: ,p_language_to_process IN VARCHAR2 DEFAULT NULL
12415: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
12416: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
12417: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL

Line 12420: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

12416: ,p_change_obj IN EGO_USER_ATTR_CHANGE_OBJ DEFAULT NULL
12417: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
12418: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
12419: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL
12420: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12421: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12422: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12423: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
12424: ,x_extension_id OUT NOCOPY NUMBER

Line 12421: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

12417: ,p_pending_b_table_name IN VARCHAR2 DEFAULT NULL
12418: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
12419: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL
12420: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12421: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12422: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12423: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
12424: ,x_extension_id OUT NOCOPY NUMBER
12425: ,x_mode OUT NOCOPY VARCHAR2

Line 12422: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

12418: ,p_pending_tl_table_name IN VARCHAR2 DEFAULT NULL
12419: ,p_pending_vl_name IN VARCHAR2 DEFAULT NULL
12420: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12421: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12422: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12423: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
12424: ,x_extension_id OUT NOCOPY NUMBER
12425: ,x_mode OUT NOCOPY VARCHAR2
12426: ,x_return_status OUT NOCOPY VARCHAR2

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

12451: -- SAVEPOINT Process_Row_PUB;
12452: -- (See EXCEPTION notes for why this is commented out)
12453:
12454: -- Check for call compatibility
12455: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
12456: l_api_name, G_PKG_NAME)
12457: THEN
12458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12459: END IF;

Line 12458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

12454: -- Check for call compatibility
12455: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
12456: l_api_name, G_PKG_NAME)
12457: THEN
12458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12459: END IF;
12460:
12461: l_object_id := p_object_id;
12462: l_attr_name_value_pairs := p_attr_name_value_pairs;

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

12489: ,x_extension_id => l_extension_id
12490: ,x_mode => l_mode
12491: ,x_return_status => x_return_status
12492: );
12493: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12494: RAISE FND_API.G_EXC_ERROR;
12495: END IF;
12496:
12497: IF l_extension_id IS NOT NULL THEN

Line 12494: RAISE FND_API.G_EXC_ERROR;

12490: ,x_mode => l_mode
12491: ,x_return_status => x_return_status
12492: );
12493: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12494: RAISE FND_API.G_EXC_ERROR;
12495: END IF;
12496:
12497: IF l_extension_id IS NOT NULL THEN
12498: x_extension_id := l_extension_id;

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

12521: ,p_entity_code => p_entity_code
12522: ,x_return_status => x_return_status
12523: );
12524:
12525: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12526: RAISE FND_API.G_EXC_ERROR;
12527: END IF;
12528: END IF;
12529:

Line 12526: RAISE FND_API.G_EXC_ERROR;

12522: ,x_return_status => x_return_status
12523: );
12524:
12525: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12526: RAISE FND_API.G_EXC_ERROR;
12527: END IF;
12528: END IF;
12529:
12530: IF (l_mode IS NULL OR

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

12548: ,p_mode => l_mode
12549: ,px_attr_name_value_pairs => l_attr_name_value_pairs
12550: ,x_return_status => x_return_status
12551: );
12552: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12553: RAISE FND_API.G_EXC_ERROR;
12554: END IF;
12555: END IF;
12556:

Line 12553: RAISE FND_API.G_EXC_ERROR;

12549: ,px_attr_name_value_pairs => l_attr_name_value_pairs
12550: ,x_return_status => x_return_status
12551: );
12552: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12553: RAISE FND_API.G_EXC_ERROR;
12554: END IF;
12555: END IF;
12556:
12557:

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

12554: END IF;
12555: END IF;
12556:
12557:
12558: IF( p_validate_only = FND_API.G_FALSE) THEN
12559:
12560: Debug_Msg(l_api_name||' done with Validate_Row_Pvt and about to call Perform_DML_On_Row_Pvt', 2);
12561:
12562: Perform_DML_On_Row_Pvt(

Line 12581: ,p_commit => FND_API.G_FALSE

12577: ,p_pending_tl_table_name => p_pending_tl_table_name
12578: ,p_entity_id => p_entity_id
12579: ,p_entity_index => p_entity_index
12580: ,p_entity_code => p_entity_code
12581: ,p_commit => FND_API.G_FALSE
12582: ,p_raise_business_event => p_raise_business_event
12583: ,x_extension_id => x_extension_id
12584: ,x_return_status => x_return_status
12585: );

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

12582: ,p_raise_business_event => p_raise_business_event
12583: ,x_extension_id => x_extension_id
12584: ,x_return_status => x_return_status
12585: );
12586: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12587: RAISE FND_API.G_EXC_ERROR;
12588: END IF;
12589:
12590: Debug_Msg('In Process_Row, done', 1);

Line 12587: RAISE FND_API.G_EXC_ERROR;

12583: ,x_extension_id => x_extension_id
12584: ,x_return_status => x_return_status
12585: );
12586: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12587: RAISE FND_API.G_EXC_ERROR;
12588: END IF;
12589:
12590: Debug_Msg('In Process_Row, done', 1);
12591:

Line 12594: IF FND_API.To_Boolean(p_commit) THEN

12590: Debug_Msg('In Process_Row, done', 1);
12591:
12592: END IF;
12593:
12594: IF FND_API.To_Boolean(p_commit) THEN
12595: COMMIT WORK;
12596: END IF;
12597:
12598: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 12598: x_return_status := FND_API.G_RET_STS_SUCCESS;

12594: IF FND_API.To_Boolean(p_commit) THEN
12595: COMMIT WORK;
12596: END IF;
12597:
12598: x_return_status := FND_API.G_RET_STS_SUCCESS;
12599:
12600: EXCEPTION
12601: ----------------------------------------------------------------------------
12602: -- We don't do a ROLLBACK in this exception block; all exceptions will --

Line 12614: WHEN FND_API.G_EXC_ERROR THEN

12610: -- --
12611: -- so I took out the ROLLBACK call, which wasn't necessary anyway.) --
12612: ----------------------------------------------------------------------------
12613:
12614: WHEN FND_API.G_EXC_ERROR THEN
12615: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
12616:
12617: IF FND_API.To_Boolean(p_commit) THEN
12618: COMMIT WORK;

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

12611: -- so I took out the ROLLBACK call, which wasn't necessary anyway.) --
12612: ----------------------------------------------------------------------------
12613:
12614: WHEN FND_API.G_EXC_ERROR THEN
12615: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
12616:
12617: IF FND_API.To_Boolean(p_commit) THEN
12618: COMMIT WORK;
12619: END IF;

Line 12617: IF FND_API.To_Boolean(p_commit) THEN

12613:
12614: WHEN FND_API.G_EXC_ERROR THEN
12615: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
12616:
12617: IF FND_API.To_Boolean(p_commit) THEN
12618: COMMIT WORK;
12619: END IF;
12620: x_msg_count := ERROR_HANDLER.Get_Message_Count();
12621: IF (x_msg_count = 1) THEN

Line 12634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

12630: END IF;
12631:
12632: WHEN OTHERS THEN
12633: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM);
12634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12635: DECLARE
12636: l_token_table ERROR_HANDLER.Token_Tbl_Type;
12637: BEGIN
12638: l_token_table(1).TOKEN_NAME := 'PKG_NAME';

Line 12649: ,p_message_type => FND_API.G_RET_STS_ERROR

12645: ERROR_HANDLER.Add_Error_Message(
12646: p_message_name => 'EGO_PLSQL_ERR'
12647: ,p_application_id => 'EGO'
12648: ,p_token_tbl => l_token_table
12649: ,p_message_type => FND_API.G_RET_STS_ERROR
12650: ,p_row_identifier => G_USER_ROW_IDENTIFIER
12651: ,p_entity_id => p_entity_id
12652: ,p_entity_index => p_entity_index
12653: ,p_entity_code => p_entity_code

Line 12696: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

12692: ,p_entity_id IN NUMBER DEFAULT NULL
12693: ,p_entity_index IN NUMBER DEFAULT NULL
12694: ,p_entity_code IN VARCHAR2 DEFAULT NULL
12695: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
12696: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12697: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12698: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12699: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12700: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 12697: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

12693: ,p_entity_index IN NUMBER DEFAULT NULL
12694: ,p_entity_code IN VARCHAR2 DEFAULT NULL
12695: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
12696: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12697: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12698: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12699: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12700: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12701: ,x_return_status OUT NOCOPY VARCHAR2

Line 12698: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

12694: ,p_entity_code IN VARCHAR2 DEFAULT NULL
12695: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
12696: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12697: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12698: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12699: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12700: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12701: ,x_return_status OUT NOCOPY VARCHAR2
12702: ,x_errorcode OUT NOCOPY NUMBER

Line 12699: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

12695: ,p_mode IN VARCHAR2 DEFAULT G_SYNC_MODE
12696: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12697: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12698: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12699: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12700: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12701: ,x_return_status OUT NOCOPY VARCHAR2
12702: ,x_errorcode OUT NOCOPY NUMBER
12703: ,x_msg_count OUT NOCOPY NUMBER

Line 12700: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

12696: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12697: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12698: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12699: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12700: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12701: ,x_return_status OUT NOCOPY VARCHAR2
12702: ,x_errorcode OUT NOCOPY NUMBER
12703: ,x_msg_count OUT NOCOPY NUMBER
12704: ,x_msg_data OUT NOCOPY VARCHAR2

Line 12725: IF FND_API.To_Boolean(p_commit) THEN

12721: BEGIN
12722:
12723: Debug_Msg(l_api_name||' starting ', 1);
12724:
12725: IF FND_API.To_Boolean(p_commit) THEN
12726: SAVEPOINT Validate_Row_PUB;
12727: END IF;
12728:
12729: -- Check for call compatibility

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

12726: SAVEPOINT Validate_Row_PUB;
12727: END IF;
12728:
12729: -- Check for call compatibility
12730: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
12731: l_api_name, G_PKG_NAME)
12732: THEN
12733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12734: END IF;

Line 12733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

12729: -- Check for call compatibility
12730: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
12731: l_api_name, G_PKG_NAME)
12732: THEN
12733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12734: END IF;
12735:
12736: -----------------------------------
12737:

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

12762: ,x_extension_id => l_extension_id
12763: ,x_mode => l_mode
12764: ,x_return_status => x_return_status
12765: );
12766: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12767: RAISE FND_API.G_EXC_ERROR;
12768: END IF;
12769:
12770: Debug_Msg(l_api_name||' calling Validate_Row_Pvt ', 1);

Line 12767: RAISE FND_API.G_EXC_ERROR;

12763: ,x_mode => l_mode
12764: ,x_return_status => x_return_status
12765: );
12766: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12767: RAISE FND_API.G_EXC_ERROR;
12768: END IF;
12769:
12770: Debug_Msg(l_api_name||' calling Validate_Row_Pvt ', 1);
12771: Validate_Row_Pvt(

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

12784: ,p_mode => l_mode
12785: ,px_attr_name_value_pairs => l_attr_name_value_pairs
12786: ,x_return_status => x_return_status
12787: );
12788: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12789: RAISE FND_API.G_EXC_ERROR;
12790: END IF;
12791:
12792: Close_Business_Object_Session(

Line 12789: RAISE FND_API.G_EXC_ERROR;

12785: ,px_attr_name_value_pairs => l_attr_name_value_pairs
12786: ,x_return_status => x_return_status
12787: );
12788: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12789: RAISE FND_API.G_EXC_ERROR;
12790: END IF;
12791:
12792: Close_Business_Object_Session(
12793: p_init_error_handler_flag => FALSE

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

12790: END IF;
12791:
12792: Close_Business_Object_Session(
12793: p_init_error_handler_flag => FALSE
12794: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12795: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12796: );
12797:
12798: IF FND_API.To_Boolean(p_commit) THEN

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

12791:
12792: Close_Business_Object_Session(
12793: p_init_error_handler_flag => FALSE
12794: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12795: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12796: );
12797:
12798: IF FND_API.To_Boolean(p_commit) THEN
12799: COMMIT WORK;

Line 12798: IF FND_API.To_Boolean(p_commit) THEN

12794: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12795: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12796: );
12797:
12798: IF FND_API.To_Boolean(p_commit) THEN
12799: COMMIT WORK;
12800: END IF;
12801:
12802: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 12802: x_return_status := FND_API.G_RET_STS_SUCCESS;

12798: IF FND_API.To_Boolean(p_commit) THEN
12799: COMMIT WORK;
12800: END IF;
12801:
12802: x_return_status := FND_API.G_RET_STS_SUCCESS;
12803: Debug_Msg(l_api_name||' ending ', 1);
12804:
12805: EXCEPTION
12806: WHEN FND_API.G_EXC_ERROR THEN

Line 12806: WHEN FND_API.G_EXC_ERROR THEN

12802: x_return_status := FND_API.G_RET_STS_SUCCESS;
12803: Debug_Msg(l_api_name||' ending ', 1);
12804:
12805: EXCEPTION
12806: WHEN FND_API.G_EXC_ERROR THEN
12807: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
12808: IF FND_API.To_Boolean(p_commit) THEN
12809: ROLLBACK TO Validate_Row_PUB;
12810: END IF;

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

12803: Debug_Msg(l_api_name||' ending ', 1);
12804:
12805: EXCEPTION
12806: WHEN FND_API.G_EXC_ERROR THEN
12807: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
12808: IF FND_API.To_Boolean(p_commit) THEN
12809: ROLLBACK TO Validate_Row_PUB;
12810: END IF;
12811: Close_Business_Object_Session(

Line 12808: IF FND_API.To_Boolean(p_commit) THEN

12804:
12805: EXCEPTION
12806: WHEN FND_API.G_EXC_ERROR THEN
12807: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
12808: IF FND_API.To_Boolean(p_commit) THEN
12809: ROLLBACK TO Validate_Row_PUB;
12810: END IF;
12811: Close_Business_Object_Session(
12812: p_init_error_handler_flag => FALSE

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

12809: ROLLBACK TO Validate_Row_PUB;
12810: END IF;
12811: Close_Business_Object_Session(
12812: p_init_error_handler_flag => FALSE
12813: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12814: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12815: );
12816:
12817: x_msg_count := ERROR_HANDLER.Get_Message_Count();

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

12810: END IF;
12811: Close_Business_Object_Session(
12812: p_init_error_handler_flag => FALSE
12813: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12814: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12815: );
12816:
12817: x_msg_count := ERROR_HANDLER.Get_Message_Count();
12818: IF (x_msg_count = 1) THEN

Line 12831: IF FND_API.To_Boolean(p_commit) THEN

12827: END IF;
12828:
12829: WHEN OTHERS THEN
12830: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM);
12831: IF FND_API.To_Boolean(p_commit) THEN
12832: ROLLBACK TO Validate_Row_PUB;
12833: END IF;
12834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12835:

Line 12834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

12830: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM);
12831: IF FND_API.To_Boolean(p_commit) THEN
12832: ROLLBACK TO Validate_Row_PUB;
12833: END IF;
12834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12835:
12836: DECLARE
12837: l_token_table ERROR_HANDLER.Token_Tbl_Type;
12838: BEGIN

Line 12850: ,p_message_type => FND_API.G_RET_STS_ERROR

12846: ERROR_HANDLER.Add_Error_Message(
12847: p_message_name => 'EGO_PLSQL_ERR'
12848: ,p_application_id => 'EGO'
12849: ,p_token_tbl => l_token_table
12850: ,p_message_type => FND_API.G_RET_STS_ERROR
12851: ,p_row_identifier => G_USER_ROW_IDENTIFIER
12852: ,p_entity_id => p_entity_id
12853: ,p_entity_index => p_entity_index
12854: ,p_entity_code => p_entity_code

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

12857: END;
12858:
12859: Close_Business_Object_Session(
12860: p_init_error_handler_flag => FALSE
12861: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12862: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12863: );
12864:
12865: x_msg_count := ERROR_HANDLER.Get_Message_Count();

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

12858:
12859: Close_Business_Object_Session(
12860: p_init_error_handler_flag => FALSE
12861: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
12862: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
12863: );
12864:
12865: x_msg_count := ERROR_HANDLER.Get_Message_Count();
12866:

Line 12909: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_FALSE

12905: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
12906: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
12907: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL
12908: ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL
12909: ,p_execute_dml IN VARCHAR2 DEFAULT FND_API.G_FALSE
12910: ,p_entity_id IN NUMBER DEFAULT NULL
12911: ,p_entity_index IN NUMBER DEFAULT NULL
12912: ,p_entity_code IN VARCHAR2 DEFAULT NULL
12913: ,p_debug_level IN NUMBER DEFAULT 0

Line 12914: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE

12910: ,p_entity_id IN NUMBER DEFAULT NULL
12911: ,p_entity_index IN NUMBER DEFAULT NULL
12912: ,p_entity_code IN VARCHAR2 DEFAULT NULL
12913: ,p_debug_level IN NUMBER DEFAULT 0
12914: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
12915: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12916: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12917: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12918: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 12915: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

12911: ,p_entity_index IN NUMBER DEFAULT NULL
12912: ,p_entity_code IN VARCHAR2 DEFAULT NULL
12913: ,p_debug_level IN NUMBER DEFAULT 0
12914: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
12915: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12916: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12917: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12918: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12919: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 12916: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

12912: ,p_entity_code IN VARCHAR2 DEFAULT NULL
12913: ,p_debug_level IN NUMBER DEFAULT 0
12914: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
12915: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12916: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12917: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12918: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12919: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12920: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 12917: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

12913: ,p_debug_level IN NUMBER DEFAULT 0
12914: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
12915: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12916: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12917: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12918: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12919: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12920: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
12921: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE

Line 12918: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

12914: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
12915: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12916: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12917: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12918: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12919: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12920: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
12921: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
12922: ,x_return_status OUT NOCOPY VARCHAR2

Line 12919: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

12915: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
12916: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12917: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12918: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12919: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12920: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
12921: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
12922: ,x_return_status OUT NOCOPY VARCHAR2
12923: ,x_errorcode OUT NOCOPY NUMBER

Line 12920: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE

12916: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
12917: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
12918: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
12919: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
12920: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
12921: ,p_raise_business_event IN BOOLEAN DEFAULT TRUE
12922: ,x_return_status OUT NOCOPY VARCHAR2
12923: ,x_errorcode OUT NOCOPY NUMBER
12924: ,x_msg_count OUT NOCOPY NUMBER

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

12952: BEGIN
12953:
12954: Debug_Msg(l_api_name||' starting ', 1);
12955: -- Check for call compatibility
12956: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
12957: l_api_name, G_PKG_NAME)
12958: THEN
12959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12960: END IF;

Line 12959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

12955: -- Check for call compatibility
12956: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
12957: l_api_name, G_PKG_NAME)
12958: THEN
12959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12960: END IF;
12961:
12962: IF (FND_API.To_Boolean(p_init_fnd_msg_list)) THEN
12963: ERROR_HANDLER.Initialize();

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

12958: THEN
12959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12960: END IF;
12961:
12962: IF (FND_API.To_Boolean(p_init_fnd_msg_list)) THEN
12963: ERROR_HANDLER.Initialize();
12964: END IF;
12965:
12966: G_B_TABLE_DML := '';

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

13014: ,p_extra_pk_col_name_val_pairs => p_extra_pk_col_name_val_pairs
13015: ,p_pending_b_table_name => p_alternate_ext_b_table_name
13016: ,p_pending_vl_name => p_alternate_ext_vl_name
13017: ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
13018: ,p_use_def_vals_on_insert_flag => FND_API.To_Boolean(p_use_def_vals_on_insert)
13019: ,p_debug_level => p_debug_level
13020: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
13021: ,px_object_id => l_object_id
13022: ,px_attr_name_value_pairs => l_attr_name_value_pairs

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

13016: ,p_pending_vl_name => p_alternate_ext_vl_name
13017: ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
13018: ,p_use_def_vals_on_insert_flag => FND_API.To_Boolean(p_use_def_vals_on_insert)
13019: ,p_debug_level => p_debug_level
13020: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
13021: ,px_object_id => l_object_id
13022: ,px_attr_name_value_pairs => l_attr_name_value_pairs
13023: ,x_attr_group_metadata_obj => l_attr_group_metadata_obj
13024: ,x_ext_table_metadata_obj => l_ext_table_metadata_obj

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

13026: ,x_mode => l_mode
13027: ,x_return_status => x_return_status
13028: );
13029:
13030: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
13031: RAISE FND_API.G_EXC_ERROR;
13032: END IF;
13033:
13034: Debug_Msg(l_api_name||' calling Perform_DML_On_Row_Pvt', 1);

Line 13031: RAISE FND_API.G_EXC_ERROR;

13027: ,x_return_status => x_return_status
13028: );
13029:
13030: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
13031: RAISE FND_API.G_EXC_ERROR;
13032: END IF;
13033:
13034: Debug_Msg(l_api_name||' calling Perform_DML_On_Row_Pvt', 1);
13035: Perform_DML_On_Row_Pvt(

Line 13055: ,p_commit => FND_API.G_FALSE

13051: ,p_execute_dml => p_execute_dml
13052: ,p_entity_id => p_entity_id
13053: ,p_entity_index => p_entity_index
13054: ,p_entity_code => p_entity_code
13055: ,p_commit => FND_API.G_FALSE
13056: ,p_raise_business_event => p_raise_business_event
13057: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
13058: ,x_extension_id => l_extension_id
13059: ,x_return_status => x_return_status

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

13053: ,p_entity_index => p_entity_index
13054: ,p_entity_code => p_entity_code
13055: ,p_commit => FND_API.G_FALSE
13056: ,p_raise_business_event => p_raise_business_event
13057: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
13058: ,x_extension_id => l_extension_id
13059: ,x_return_status => x_return_status
13060: );
13061: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

13057: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
13058: ,x_extension_id => l_extension_id
13059: ,x_return_status => x_return_status
13060: );
13061: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
13062: RAISE FND_API.G_EXC_ERROR;
13063: END IF;
13064:
13065: x_b_dml_for_ag := G_B_TABLE_DML;

Line 13062: RAISE FND_API.G_EXC_ERROR;

13058: ,x_extension_id => l_extension_id
13059: ,x_return_status => x_return_status
13060: );
13061: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
13062: RAISE FND_API.G_EXC_ERROR;
13063: END IF;
13064:
13065: x_b_dml_for_ag := G_B_TABLE_DML;
13066: x_tl_dml_for_ag := G_TL_TABLE_DML;

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

13103: x_tl_bind_attr_table := l_tl_dml_bind_list;
13104:
13105: Close_Business_Object_Session(
13106: p_init_error_handler_flag => (p_debug_level > 0)
13107: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
13108: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
13109: );
13110:
13111: IF FND_API.To_Boolean(p_commit) THEN

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

13104:
13105: Close_Business_Object_Session(
13106: p_init_error_handler_flag => (p_debug_level > 0)
13107: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
13108: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
13109: );
13110:
13111: IF FND_API.To_Boolean(p_commit) THEN
13112: COMMIT WORK;

Line 13111: IF FND_API.To_Boolean(p_commit) THEN

13107: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
13108: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
13109: );
13110:
13111: IF FND_API.To_Boolean(p_commit) THEN
13112: COMMIT WORK;
13113: END IF;
13114:
13115: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 13115: x_return_status := FND_API.G_RET_STS_SUCCESS;

13111: IF FND_API.To_Boolean(p_commit) THEN
13112: COMMIT WORK;
13113: END IF;
13114:
13115: x_return_status := FND_API.G_RET_STS_SUCCESS;
13116:
13117: Debug_Msg(l_api_name||' ending ', 1);
13118:
13119: EXCEPTION

Line 13121: WHEN FND_API.G_EXC_ERROR THEN

13117: Debug_Msg(l_api_name||' ending ', 1);
13118:
13119: EXCEPTION
13120:
13121: WHEN FND_API.G_EXC_ERROR THEN
13122: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
13123:
13124: Close_Business_Object_Session(
13125: p_init_error_handler_flag => (p_debug_level > 0)

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

13118:
13119: EXCEPTION
13120:
13121: WHEN FND_API.G_EXC_ERROR THEN
13122: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
13123:
13124: Close_Business_Object_Session(
13125: p_init_error_handler_flag => (p_debug_level > 0)
13126: ,p_log_errors => FND_API.To_Boolean(p_log_errors)

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

13122: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
13123:
13124: Close_Business_Object_Session(
13125: p_init_error_handler_flag => (p_debug_level > 0)
13126: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
13127: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
13128: );
13129:
13130: x_msg_count := ERROR_HANDLER.Get_Message_Count();

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

13123:
13124: Close_Business_Object_Session(
13125: p_init_error_handler_flag => (p_debug_level > 0)
13126: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
13127: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
13128: );
13129:
13130: x_msg_count := ERROR_HANDLER.Get_Message_Count();
13131: IF (x_msg_count = 1) THEN

Line 13144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

13140: END IF;
13141:
13142: WHEN OTHERS THEN
13143: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM);
13144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13145: DECLARE
13146: l_token_table ERROR_HANDLER.Token_Tbl_Type;
13147: BEGIN
13148: l_token_table(1).TOKEN_NAME := 'PKG_NAME';

Line 13159: ,p_message_type => FND_API.G_RET_STS_ERROR

13155: ERROR_HANDLER.Add_Error_Message(
13156: p_message_name => 'EGO_PLSQL_ERR'
13157: ,p_application_id => 'EGO'
13158: ,p_token_tbl => l_token_table
13159: ,p_message_type => FND_API.G_RET_STS_ERROR
13160: ,p_row_identifier => G_USER_ROW_IDENTIFIER
13161: ,p_entity_id => p_entity_id
13162: ,p_entity_index => p_entity_index
13163: ,p_entity_code => p_entity_code

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

13166: END;
13167:
13168: Close_Business_Object_Session(
13169: p_init_error_handler_flag => (p_debug_level > 0)
13170: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
13171: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
13172: );
13173:
13174: x_msg_count := ERROR_HANDLER.Get_Message_Count();

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

13167:
13168: Close_Business_Object_Session(
13169: p_init_error_handler_flag => (p_debug_level > 0)
13170: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
13171: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
13172: );
13173:
13174: x_msg_count := ERROR_HANDLER.Get_Message_Count();
13175:

Line 13290: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE

13286: ,p_entity_id IN NUMBER DEFAULT NULL
13287: ,p_entity_index IN NUMBER DEFAULT NULL
13288: ,p_entity_code IN VARCHAR2 DEFAULT NULL
13289: ,p_debug_level IN NUMBER DEFAULT 0
13290: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
13291: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
13292: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13293: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
13294: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 13291: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

13287: ,p_entity_index IN NUMBER DEFAULT NULL
13288: ,p_entity_code IN VARCHAR2 DEFAULT NULL
13289: ,p_debug_level IN NUMBER DEFAULT 0
13290: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
13291: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
13292: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13293: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
13294: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13295: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 13292: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

13288: ,p_entity_code IN VARCHAR2 DEFAULT NULL
13289: ,p_debug_level IN NUMBER DEFAULT 0
13290: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
13291: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
13292: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13293: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
13294: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13295: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13296: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 13293: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

13289: ,p_debug_level IN NUMBER DEFAULT 0
13290: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
13291: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
13292: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13293: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
13294: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13295: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13296: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
13297: ,x_return_status OUT NOCOPY VARCHAR2

Line 13294: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

13290: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
13291: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
13292: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13293: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
13294: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13295: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13296: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
13297: ,x_return_status OUT NOCOPY VARCHAR2
13298: ,x_errorcode OUT NOCOPY NUMBER

Line 13295: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

13291: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
13292: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13293: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
13294: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13295: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13296: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
13297: ,x_return_status OUT NOCOPY VARCHAR2
13298: ,x_errorcode OUT NOCOPY NUMBER
13299: ,x_msg_count OUT NOCOPY NUMBER

Line 13296: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE

13292: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13293: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
13294: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13295: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13296: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
13297: ,x_return_status OUT NOCOPY VARCHAR2
13298: ,x_errorcode OUT NOCOPY NUMBER
13299: ,x_msg_count OUT NOCOPY NUMBER
13300: ,x_msg_data OUT NOCOPY VARCHAR2

Line 13373: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE

13369: ,p_entity_id IN NUMBER DEFAULT NULL
13370: ,p_entity_index IN NUMBER DEFAULT NULL
13371: ,p_entity_code IN VARCHAR2 DEFAULT NULL
13372: ,p_debug_level IN NUMBER DEFAULT 0
13373: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
13374: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
13375: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13376: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
13377: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 13374: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

13370: ,p_entity_index IN NUMBER DEFAULT NULL
13371: ,p_entity_code IN VARCHAR2 DEFAULT NULL
13372: ,p_debug_level IN NUMBER DEFAULT 0
13373: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
13374: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
13375: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13376: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
13377: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13378: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 13375: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

13371: ,p_entity_code IN VARCHAR2 DEFAULT NULL
13372: ,p_debug_level IN NUMBER DEFAULT 0
13373: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
13374: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
13375: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13376: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
13377: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13378: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13379: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 13376: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

13372: ,p_debug_level IN NUMBER DEFAULT 0
13373: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
13374: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
13375: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13376: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
13377: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13378: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13379: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
13380: --Added by geguo for 9373845 begin

Line 13377: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

13373: ,p_use_def_vals_on_insert IN VARCHAR2 DEFAULT FND_API.G_FALSE
13374: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
13375: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13376: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
13377: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13378: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13379: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
13380: --Added by geguo for 9373845 begin
13381: ,p_creation_date IN DATE DEFAULT NULL

Line 13378: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

13374: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
13375: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13376: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
13377: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13378: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13379: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
13380: --Added by geguo for 9373845 begin
13381: ,p_creation_date IN DATE DEFAULT NULL
13382: ,p_last_update_date IN DATE DEFAULT NULL

Line 13379: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE

13375: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13376: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
13377: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13378: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13379: ,p_bulkload_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
13380: --Added by geguo for 9373845 begin
13381: ,p_creation_date IN DATE DEFAULT NULL
13382: ,p_last_update_date IN DATE DEFAULT NULL
13383: --Added by geguo 9373845 end

Line 13413: IF FND_API.To_Boolean(p_commit) THEN

13409: G_WHO_CREATION_DATE := p_creation_date;
13410: G_WHO_LAST_UPDATE_DATE := p_last_update_date;
13411: Debug_Msg(l_api_name||' starting with data_level = '||p_data_level, 1);
13412:
13413: IF FND_API.To_Boolean(p_commit) THEN
13414: SAVEPOINT Perform_DML_On_Row_PUB;
13415: END IF;
13416:
13417: -- Check for call compatibility

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

13414: SAVEPOINT Perform_DML_On_Row_PUB;
13415: END IF;
13416:
13417: -- Check for call compatibility
13418: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
13419: l_api_name, G_PKG_NAME)
13420: THEN
13421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13422: END IF;

Line 13421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

13417: -- Check for call compatibility
13418: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
13419: l_api_name, G_PKG_NAME)
13420: THEN
13421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13422: END IF;
13423:
13424: IF (FND_API.To_Boolean(p_init_fnd_msg_list)) THEN
13425: ERROR_HANDLER.Initialize();

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

13420: THEN
13421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13422: END IF;
13423:
13424: IF (FND_API.To_Boolean(p_init_fnd_msg_list)) THEN
13425: ERROR_HANDLER.Initialize();
13426: END IF;
13427: G_SYNC_TO_UPDATE := 'N';
13428: l_object_id := p_object_id;

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

13447: ,p_change_obj => p_change_obj
13448: ,p_pending_b_table_name => p_pending_b_table_name
13449: ,p_pending_vl_name => p_pending_vl_name
13450: ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
13451: ,p_use_def_vals_on_insert_flag => FND_API.To_Boolean(p_use_def_vals_on_insert)
13452: ,p_debug_level => p_debug_level
13453: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
13454: ,px_object_id => l_object_id
13455: ,px_attr_name_value_pairs => l_attr_name_value_pairs

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

13449: ,p_pending_vl_name => p_pending_vl_name
13450: ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
13451: ,p_use_def_vals_on_insert_flag => FND_API.To_Boolean(p_use_def_vals_on_insert)
13452: ,p_debug_level => p_debug_level
13453: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
13454: ,px_object_id => l_object_id
13455: ,px_attr_name_value_pairs => l_attr_name_value_pairs
13456: ,x_attr_group_metadata_obj => l_attr_group_metadata_obj
13457: ,x_ext_table_metadata_obj => l_ext_table_metadata_obj

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

13464: AND p_attr_group_type in ('EGO_ITEM_GTIN_ATTRS','EGO_ITEM_GTIN_MULTI_ATTRS'))
13465: THEN
13466: G_SYNC_TO_UPDATE := 'Y' ;
13467: END IF;
13468: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
13469: RAISE FND_API.G_EXC_ERROR;
13470: END IF;
13471:
13472: l_extension_id := x_extension_id;

Line 13469: RAISE FND_API.G_EXC_ERROR;

13465: THEN
13466: G_SYNC_TO_UPDATE := 'Y' ;
13467: END IF;
13468: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
13469: RAISE FND_API.G_EXC_ERROR;
13470: END IF;
13471:
13472: l_extension_id := x_extension_id;
13473: l_mode := x_mode;

Line 13495: ,p_commit => FND_API.G_FALSE

13491: ,p_pending_tl_table_name => p_pending_tl_table_name
13492: ,p_entity_id => p_entity_id
13493: ,p_entity_index => p_entity_index
13494: ,p_entity_code => p_entity_code
13495: ,p_commit => FND_API.G_FALSE
13496: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
13497: ,x_extension_id => x_extension_id
13498: ,x_return_status => x_return_status
13499: );

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

13492: ,p_entity_id => p_entity_id
13493: ,p_entity_index => p_entity_index
13494: ,p_entity_code => p_entity_code
13495: ,p_commit => FND_API.G_FALSE
13496: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
13497: ,x_extension_id => x_extension_id
13498: ,x_return_status => x_return_status
13499: );
13500: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

13496: ,p_bulkload_flag => FND_API.To_Boolean(p_bulkload_flag)
13497: ,x_extension_id => x_extension_id
13498: ,x_return_status => x_return_status
13499: );
13500: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
13501: RAISE FND_API.G_EXC_ERROR;
13502: END IF;
13503:
13504: Close_Business_Object_Session(

Line 13501: RAISE FND_API.G_EXC_ERROR;

13497: ,x_extension_id => x_extension_id
13498: ,x_return_status => x_return_status
13499: );
13500: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
13501: RAISE FND_API.G_EXC_ERROR;
13502: END IF;
13503:
13504: Close_Business_Object_Session(
13505: p_init_error_handler_flag => (p_debug_level > 0)

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

13502: END IF;
13503:
13504: Close_Business_Object_Session(
13505: p_init_error_handler_flag => (p_debug_level > 0)
13506: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
13507: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
13508: );
13509:
13510: IF FND_API.To_Boolean(p_commit) THEN

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

13503:
13504: Close_Business_Object_Session(
13505: p_init_error_handler_flag => (p_debug_level > 0)
13506: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
13507: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
13508: );
13509:
13510: IF FND_API.To_Boolean(p_commit) THEN
13511: COMMIT WORK;

Line 13510: IF FND_API.To_Boolean(p_commit) THEN

13506: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
13507: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
13508: );
13509:
13510: IF FND_API.To_Boolean(p_commit) THEN
13511: COMMIT WORK;
13512: END IF;
13513:
13514: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 13514: x_return_status := FND_API.G_RET_STS_SUCCESS;

13510: IF FND_API.To_Boolean(p_commit) THEN
13511: COMMIT WORK;
13512: END IF;
13513:
13514: x_return_status := FND_API.G_RET_STS_SUCCESS;
13515:
13516: EXCEPTION
13517: WHEN FND_API.G_EXC_ERROR THEN
13518: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');

Line 13517: WHEN FND_API.G_EXC_ERROR THEN

13513:
13514: x_return_status := FND_API.G_RET_STS_SUCCESS;
13515:
13516: EXCEPTION
13517: WHEN FND_API.G_EXC_ERROR THEN
13518: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
13519: IF FND_API.To_Boolean(p_commit) THEN
13520: ROLLBACK TO Perform_DML_On_Row_PUB;
13521: END IF;

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

13514: x_return_status := FND_API.G_RET_STS_SUCCESS;
13515:
13516: EXCEPTION
13517: WHEN FND_API.G_EXC_ERROR THEN
13518: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
13519: IF FND_API.To_Boolean(p_commit) THEN
13520: ROLLBACK TO Perform_DML_On_Row_PUB;
13521: END IF;
13522: Close_Business_Object_Session(

Line 13519: IF FND_API.To_Boolean(p_commit) THEN

13515:
13516: EXCEPTION
13517: WHEN FND_API.G_EXC_ERROR THEN
13518: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
13519: IF FND_API.To_Boolean(p_commit) THEN
13520: ROLLBACK TO Perform_DML_On_Row_PUB;
13521: END IF;
13522: Close_Business_Object_Session(
13523: p_init_error_handler_flag => (p_debug_level > 0)

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

13520: ROLLBACK TO Perform_DML_On_Row_PUB;
13521: END IF;
13522: Close_Business_Object_Session(
13523: p_init_error_handler_flag => (p_debug_level > 0)
13524: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
13525: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
13526: );
13527:
13528: x_msg_count := ERROR_HANDLER.Get_Message_Count();

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

13521: END IF;
13522: Close_Business_Object_Session(
13523: p_init_error_handler_flag => (p_debug_level > 0)
13524: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
13525: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
13526: );
13527:
13528: x_msg_count := ERROR_HANDLER.Get_Message_Count();
13529: IF (x_msg_count = 1) THEN

Line 13542: IF FND_API.To_Boolean(p_commit) THEN

13538: END IF;
13539:
13540: WHEN OTHERS THEN
13541: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM);
13542: IF FND_API.To_Boolean(p_commit) THEN
13543: ROLLBACK TO Perform_DML_On_Row_PUB;
13544: END IF;
13545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13546:

Line 13545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

13541: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM);
13542: IF FND_API.To_Boolean(p_commit) THEN
13543: ROLLBACK TO Perform_DML_On_Row_PUB;
13544: END IF;
13545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13546:
13547: DECLARE
13548: l_token_table ERROR_HANDLER.Token_Tbl_Type;
13549: BEGIN

Line 13561: ,p_message_type => FND_API.G_RET_STS_ERROR

13557: ERROR_HANDLER.Add_Error_Message(
13558: p_message_name => 'EGO_PLSQL_ERR'
13559: ,p_application_id => 'EGO'
13560: ,p_token_tbl => l_token_table
13561: ,p_message_type => FND_API.G_RET_STS_ERROR
13562: ,p_row_identifier => G_USER_ROW_IDENTIFIER
13563: ,p_entity_id => p_entity_id
13564: ,p_entity_index => p_entity_index
13565: ,p_entity_code => p_entity_code

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

13568: END;
13569:
13570: Close_Business_Object_Session(
13571: p_init_error_handler_flag => (p_debug_level > 0)
13572: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
13573: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
13574: );
13575:
13576: x_msg_count := ERROR_HANDLER.Get_Message_Count();

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

13569:
13570: Close_Business_Object_Session(
13571: p_init_error_handler_flag => (p_debug_level > 0)
13572: ,p_log_errors => FND_API.To_Boolean(p_log_errors)
13573: ,p_write_to_concurrent_log => FND_API.To_Boolean(p_write_to_concurrent_log)
13574: );
13575:
13576: x_msg_count := ERROR_HANDLER.Get_Message_Count();
13577:

Line 13605: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

13601: ,p_data_level IN VARCHAR2 DEFAULT NULL
13602: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13603: ,p_attr_group_ids_to_exclude IN EGO_NUMBER_TBL_TYPE DEFAULT NULL
13604: ,p_debug_level IN NUMBER DEFAULT 0
13605: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13606: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13607: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13608: ,x_return_status OUT NOCOPY VARCHAR2
13609: ,x_errorcode OUT NOCOPY NUMBER

Line 13606: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

13602: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
13603: ,p_attr_group_ids_to_exclude IN EGO_NUMBER_TBL_TYPE DEFAULT NULL
13604: ,p_debug_level IN NUMBER DEFAULT 0
13605: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13606: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13607: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13608: ,x_return_status OUT NOCOPY VARCHAR2
13609: ,x_errorcode OUT NOCOPY NUMBER
13610: ,x_msg_count OUT NOCOPY NUMBER

Line 13607: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

13603: ,p_attr_group_ids_to_exclude IN EGO_NUMBER_TBL_TYPE DEFAULT NULL
13604: ,p_debug_level IN NUMBER DEFAULT 0
13605: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
13606: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
13607: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13608: ,x_return_status OUT NOCOPY VARCHAR2
13609: ,x_errorcode OUT NOCOPY NUMBER
13610: ,x_msg_count OUT NOCOPY NUMBER
13611: ,x_msg_data OUT NOCOPY VARCHAR2

Line 13670: IF FND_API.To_Boolean(p_commit) THEN

13666:
13667: BEGIN
13668: Debug_Msg(l_api_name||' starting ', 1);
13669:
13670: IF FND_API.To_Boolean(p_commit) THEN
13671: SAVEPOINT Perform_DML_From_Template;
13672: END IF;
13673:
13674: -- Check for call compatibility

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

13671: SAVEPOINT Perform_DML_From_Template;
13672: END IF;
13673:
13674: -- Check for call compatibility
13675: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
13676: l_api_name, G_PKG_NAME)
13677: THEN
13678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13679: END IF;

Line 13678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

13674: -- Check for call compatibility
13675: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
13676: l_api_name, G_PKG_NAME)
13677: THEN
13678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13679: END IF;
13680:
13681: ------------------------------------------------------------------
13682: -- Initialize the Business Object (flags, error-handling, etc.) --

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

13692: ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
13693: ,p_default_user_row_identifier => l_row_index
13694: ,x_return_status => x_return_status
13695: );
13696: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
13697: RAISE FND_API.G_EXC_ERROR;
13698: END IF;
13699:
13700: ----------------------------------------------

Line 13697: RAISE FND_API.G_EXC_ERROR;

13693: ,p_default_user_row_identifier => l_row_index
13694: ,x_return_status => x_return_status
13695: );
13696: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
13697: RAISE FND_API.G_EXC_ERROR;
13698: END IF;
13699:
13700: ----------------------------------------------
13701: -- Get the Object ID and Ext Table metadata --

Line 14004: IF FND_API.TO_BOOLEAN(l_Perform_DML_On_Template_Row) THEN

14000: ,x_data_level_id => l_data_level_id
14001: ,x_name_value_pair_valid => l_Perform_DML_On_Template_Row
14002: );
14003:
14004: IF FND_API.TO_BOOLEAN(l_Perform_DML_On_Template_Row) THEN
14005: Debug_Msg(l_api_name ||' CALLING Perform_DML_On_Template_Row in the loop ',1);
14006: Perform_DML_On_Template_Row(
14007: p_object_id => l_object_id
14008: ,p_attr_group_metadata_obj => l_attr_group_metadata_obj

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

14011: ,p_class_code_name_value_pairs => p_class_code_name_value_pairs
14012: ,p_data_level => p_data_level
14013: ,p_data_level_name_value_pairs => p_data_level_name_value_pairs
14014: ,px_attr_name_value_pairs => l_attr_name_value_pairs
14015: ,p_commit => FND_API.G_FALSE -- we don't commit until the end
14016: );
14017: ELSE
14018: Debug_Msg(l_api_name ||' no need to call Perform_DML_On_Template_Row in the loop ',1);
14019: END IF;

Line 14048: ,p_message_type => FND_API.G_RET_STS_ERROR

14044: ERROR_HANDLER.Add_Error_Message(
14045: p_message_name => 'EGO_EF_ATTR_GROUP_ID_NOT_FOUND'
14046: ,p_application_id => 'EGO'
14047: ,p_token_tbl => l_token_table
14048: ,p_message_type => FND_API.G_RET_STS_ERROR
14049: ,p_row_identifier => l_row_index + 1 --we haven't incremented yet
14050: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
14051: );
14052:

Line 14053: RAISE FND_API.G_EXC_ERROR;

14049: ,p_row_identifier => l_row_index + 1 --we haven't incremented yet
14050: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
14051: );
14052:
14053: RAISE FND_API.G_EXC_ERROR;
14054: END IF;
14055: END IF;
14056: END IF;
14057:

Line 14073: ,p_message_type => FND_API.G_RET_STS_ERROR

14069: ERROR_HANDLER.Add_Error_Message(
14070: p_message_name => 'EGO_EF_ATTR_ID_NOT_FOUND'
14071: ,p_application_id => 'EGO'
14072: ,p_token_tbl => l_token_table
14073: ,p_message_type => FND_API.G_RET_STS_ERROR
14074: ,p_row_identifier => l_row_index + 1 --we haven't incremented yet
14075: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
14076: );
14077:

Line 14078: RAISE FND_API.G_EXC_ERROR;

14074: ,p_row_identifier => l_row_index + 1 --we haven't incremented yet
14075: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
14076: );
14077:
14078: RAISE FND_API.G_EXC_ERROR;
14079: END IF;
14080:
14081: ------------------------------------------------------------------
14082: -- Whether or not we're at the start of a row, we've fetched a --

Line 14167: IF FND_API.TO_BOOLEAN(l_Perform_DML_On_Template_Row) THEN

14163: ,x_data_level_id => l_data_level_id
14164: ,x_name_value_pair_valid => l_Perform_DML_On_Template_Row
14165: );
14166:
14167: IF FND_API.TO_BOOLEAN(l_Perform_DML_On_Template_Row) THEN
14168: Debug_Msg(l_api_name || ' CALLING Perform_DML_On_Template_Row for data level out of loop',1);
14169: Perform_DML_On_Template_Row(
14170: p_object_id => l_object_id
14171: ,p_attr_group_metadata_obj => l_attr_group_metadata_obj

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

14174: ,p_class_code_name_value_pairs => p_class_code_name_value_pairs
14175: ,p_data_level => p_data_level
14176: ,p_data_level_name_value_pairs => p_data_level_name_value_pairs
14177: ,px_attr_name_value_pairs => l_attr_name_value_pairs
14178: ,p_commit => FND_API.G_FALSE -- we don't commit until the end
14179: );
14180: ELSE
14181: Debug_Msg(l_api_name || ' no need to call Perform_DML_On_Template_Row for data level out of loop',1);
14182: END IF;

Line 14187: IF FND_API.To_Boolean(p_commit) THEN

14183: --End Bug 5211171
14184:
14185: END IF;
14186:
14187: IF FND_API.To_Boolean(p_commit) THEN
14188: COMMIT WORK;
14189: END IF;
14190:
14191: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 14191: x_return_status := FND_API.G_RET_STS_SUCCESS;

14187: IF FND_API.To_Boolean(p_commit) THEN
14188: COMMIT WORK;
14189: END IF;
14190:
14191: x_return_status := FND_API.G_RET_STS_SUCCESS;
14192: Debug_Msg(l_api_name||' done ',1);
14193: G_ENABLE_DEBUG := FALSE;
14194:
14195: EXCEPTION

Line 14196: WHEN FND_API.G_EXC_ERROR THEN

14192: Debug_Msg(l_api_name||' done ',1);
14193: G_ENABLE_DEBUG := FALSE;
14194:
14195: EXCEPTION
14196: WHEN FND_API.G_EXC_ERROR THEN
14197: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
14198: IF FND_API.To_Boolean(p_commit) THEN
14199: ROLLBACK TO Perform_DML_From_Template;
14200: END IF;

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

14193: G_ENABLE_DEBUG := FALSE;
14194:
14195: EXCEPTION
14196: WHEN FND_API.G_EXC_ERROR THEN
14197: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
14198: IF FND_API.To_Boolean(p_commit) THEN
14199: ROLLBACK TO Perform_DML_From_Template;
14200: END IF;
14201: x_return_status := FND_API.G_RET_STS_ERROR;

Line 14198: IF FND_API.To_Boolean(p_commit) THEN

14194:
14195: EXCEPTION
14196: WHEN FND_API.G_EXC_ERROR THEN
14197: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
14198: IF FND_API.To_Boolean(p_commit) THEN
14199: ROLLBACK TO Perform_DML_From_Template;
14200: END IF;
14201: x_return_status := FND_API.G_RET_STS_ERROR;
14202:

Line 14201: x_return_status := FND_API.G_RET_STS_ERROR;

14197: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
14198: IF FND_API.To_Boolean(p_commit) THEN
14199: ROLLBACK TO Perform_DML_From_Template;
14200: END IF;
14201: x_return_status := FND_API.G_RET_STS_ERROR;
14202:
14203: x_msg_count := ERROR_HANDLER.Get_Message_Count();
14204:
14205: IF (x_msg_count > 0) THEN

Line 14230: IF FND_API.To_Boolean(p_commit) THEN

14226: END IF;
14227:
14228: WHEN OTHERS THEN
14229: Debug_Msg(l_api_name || ' EXCEPTION OTHERS'||SQLERRM);
14230: IF FND_API.To_Boolean(p_commit) THEN
14231: ROLLBACK TO Perform_DML_From_Template;
14232: END IF;
14233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14234:

Line 14233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

14229: Debug_Msg(l_api_name || ' EXCEPTION OTHERS'||SQLERRM);
14230: IF FND_API.To_Boolean(p_commit) THEN
14231: ROLLBACK TO Perform_DML_From_Template;
14232: END IF;
14233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14234:
14235: l_token_table(1).TOKEN_NAME := 'PKG_NAME';
14236: l_token_table(1).TOKEN_VALUE := G_PKG_NAME;
14237: l_token_table(2).TOKEN_NAME := 'API_NAME';

Line 14246: ,p_message_type => FND_API.G_RET_STS_ERROR

14242: ERROR_HANDLER.Add_Error_Message(
14243: p_message_name => 'EGO_PLSQL_ERR'
14244: ,p_application_id => 'EGO'
14245: ,p_token_tbl => l_token_table
14246: ,p_message_type => FND_API.G_RET_STS_ERROR
14247: ,p_row_identifier => l_row_index
14248: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
14249: );
14250:

Line 14290: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE

14286: ,p_new_data_level_id IN NUMBER DEFAULT NULL
14287: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14288: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14289: ,p_attr_group_list IN VARCHAR2 DEFAULT NULL
14290: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
14291: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
14292: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
14293: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
14294: ,x_return_status OUT NOCOPY VARCHAR2

Line 14291: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

14287: ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14288: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14289: ,p_attr_group_list IN VARCHAR2 DEFAULT NULL
14290: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
14291: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
14292: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
14293: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
14294: ,x_return_status OUT NOCOPY VARCHAR2
14295: ,x_errorcode OUT NOCOPY NUMBER

Line 14292: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

14288: ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14289: ,p_attr_group_list IN VARCHAR2 DEFAULT NULL
14290: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
14291: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
14292: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
14293: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
14294: ,x_return_status OUT NOCOPY VARCHAR2
14295: ,x_errorcode OUT NOCOPY NUMBER
14296: ,x_msg_count OUT NOCOPY NUMBER

Line 14293: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

14289: ,p_attr_group_list IN VARCHAR2 DEFAULT NULL
14290: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
14291: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
14292: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
14293: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
14294: ,x_return_status OUT NOCOPY VARCHAR2
14295: ,x_errorcode OUT NOCOPY NUMBER
14296: ,x_msg_count OUT NOCOPY NUMBER
14297: ,x_msg_data OUT NOCOPY VARCHAR2

Line 14378: IF FND_API.To_Boolean(p_commit) THEN

14374: BEGIN
14375:
14376: Debug_Msg(l_api_name || ' Starting ');
14377:
14378: IF FND_API.To_Boolean(p_commit) THEN
14379: SAVEPOINT Copy_User_Attrs_Data_PUB;
14380: END IF;
14381:
14382: -- Initialize FND_MSG_PUB if necessary

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

14379: SAVEPOINT Copy_User_Attrs_Data_PUB;
14380: END IF;
14381:
14382: -- Initialize FND_MSG_PUB if necessary
14383: IF (FND_API.To_Boolean(p_init_fnd_msg_list)) THEN
14384: FND_MSG_PUB.Initialize;
14385: END IF;
14386:
14387: -- Initialize ERROR_HANDLER if necessary

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

14384: FND_MSG_PUB.Initialize;
14385: END IF;
14386:
14387: -- Initialize ERROR_HANDLER if necessary
14388: IF (FND_API.To_Boolean(p_init_error_handler)) THEN
14389: ERROR_HANDLER.Initialize();
14390: END IF;
14391:
14392: -- Check for call compatibility

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

14389: ERROR_HANDLER.Initialize();
14390: END IF;
14391:
14392: -- Check for call compatibility
14393: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
14394: l_api_name, G_PKG_NAME)
14395: THEN
14396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14397: END IF;

Line 14396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

14392: -- Check for call compatibility
14393: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
14394: l_api_name, G_PKG_NAME)
14395: THEN
14396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14397: END IF;
14398:
14399: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
14400: G_ADD_ERRORS_TO_FND_STACK := 'Y';

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

14395: THEN
14396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14397: END IF;
14398:
14399: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
14400: G_ADD_ERRORS_TO_FND_STACK := 'Y';
14401: ELSE
14402: G_ADD_ERRORS_TO_FND_STACK := 'N';
14403: END IF;

Line 14433: RAISE FND_API.G_EXC_ERROR;

14429: END IF;
14430: -- processing the pk cols
14431: IF (p_old_pk_col_value_pairs.COUNT <> p_new_pk_col_value_pairs.COUNT) THEN
14432: x_msg_data := 'EGO_EF_CP_PK_COL_COUNT_ERR';
14433: RAISE FND_API.G_EXC_ERROR;
14434: END IF;
14435:
14436: l_pk_index := p_old_pk_col_value_pairs.FIRST;
14437: WHILE (l_pk_index <= p_old_pk_col_value_pairs.LAST)

Line 14454: RAISE FND_API.G_EXC_ERROR;

14450: END IF;
14451: l_where_not_in_sql := l_where_not_in_sql ||'''' ||l_pk_col_metadata_array(l_pk_index).COL_NAME ||''', ' ;
14452: ELSE
14453: x_msg_data := 'EGO_EF_CP_PK_COL_NAME_ERR';
14454: RAISE FND_API.G_EXC_ERROR;
14455: END IF;
14456:
14457: l_pk_index := p_old_pk_col_value_pairs.NEXT(l_pk_index);
14458: END LOOP;

Line 14507: RAISE FND_API.G_EXC_ERROR;

14503: IF (p_old_dtlevel_col_value_pairs IS NULL AND
14504: p_new_dtlevel_col_value_pairs IS NULL AND
14505: l_data_level_metadata_array IS NOT NULL) THEN
14506: x_msg_data := 'EGO_EF_CP_DL_NOT_PASSED_ERR';
14507: RAISE FND_API.G_EXC_ERROR;
14508: ELSIF (p_old_dtlevel_col_value_pairs IS NOT NULL AND
14509: p_new_dtlevel_col_value_pairs IS NOT NULL) THEN
14510: IF (p_old_dtlevel_col_value_pairs.COUNT <> p_new_dtlevel_col_value_pairs.COUNT) THEN
14511: x_msg_data := 'EGO_EF_CP_DL_COUNT_ERR';

Line 14512: RAISE FND_API.G_EXC_ERROR;

14508: ELSIF (p_old_dtlevel_col_value_pairs IS NOT NULL AND
14509: p_new_dtlevel_col_value_pairs IS NOT NULL) THEN
14510: IF (p_old_dtlevel_col_value_pairs.COUNT <> p_new_dtlevel_col_value_pairs.COUNT) THEN
14511: x_msg_data := 'EGO_EF_CP_DL_COUNT_ERR';
14512: RAISE FND_API.G_EXC_ERROR;
14513: END IF;
14514: l_dtlevel_index := p_old_dtlevel_col_value_pairs.FIRST;
14515: WHILE (l_dtlevel_index <= p_old_dtlevel_col_value_pairs.LAST)
14516: LOOP

Line 14535: RAISE FND_API.G_EXC_ERROR;

14531: l_insert_dtlevel_sql := l_insert_dtlevel_sql ||p_old_dtlevel_col_value_pairs(l_dtlevel_index).NAME ||', ';
14532: l_where_not_in_sql := l_where_not_in_sql ||'''' ||l_data_level_metadata_array(l_dtlevel_index).COL_NAME ||''', ';
14533: ELSE
14534: x_msg_data := 'EGO_EF_CP_DL_NAME_ERR';
14535: RAISE FND_API.G_EXC_ERROR;
14536: END IF;
14537: l_dtlevel_index := p_old_dtlevel_col_value_pairs.NEXT(l_dtlevel_index);
14538: END LOOP;
14539: END IF; -- if data level IS NOT NULL

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

14635: FROM EGO_ATTR_GROUP_TYPES_V
14636: WHERE APPLICATION_ID = p_application_id
14637: AND ATTR_GROUP_TYPE = l_attr_group_types(agt_itr);
14638:
14639: l_has_data_level_id := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
14640: p_table_name => l_b_table_name
14641: ,p_column_name => 'DATA_LEVEL_ID')
14642: );
14643: IF l_has_data_level_id THEN

Line 14957: IF FND_API.To_Boolean(p_commit) THEN

14953: --CLOSE l_dynamic_cursor;
14954: END LOOP;
14955: END IF; -- l_attr_group_types
14956:
14957: IF FND_API.To_Boolean(p_commit) THEN
14958: COMMIT WORK;
14959: END IF;
14960:
14961: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 14961: x_return_status := FND_API.G_RET_STS_SUCCESS;

14957: IF FND_API.To_Boolean(p_commit) THEN
14958: COMMIT WORK;
14959: END IF;
14960:
14961: x_return_status := FND_API.G_RET_STS_SUCCESS;
14962:
14963: EXCEPTION
14964: WHEN FND_API.G_EXC_ERROR THEN
14965: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');

Line 14964: WHEN FND_API.G_EXC_ERROR THEN

14960:
14961: x_return_status := FND_API.G_RET_STS_SUCCESS;
14962:
14963: EXCEPTION
14964: WHEN FND_API.G_EXC_ERROR THEN
14965: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
14966: IF FND_API.To_Boolean(p_commit) THEN
14967: ROLLBACK TO Copy_User_Attrs_Data_PUB;
14968: END IF;

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

14961: x_return_status := FND_API.G_RET_STS_SUCCESS;
14962:
14963: EXCEPTION
14964: WHEN FND_API.G_EXC_ERROR THEN
14965: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
14966: IF FND_API.To_Boolean(p_commit) THEN
14967: ROLLBACK TO Copy_User_Attrs_Data_PUB;
14968: END IF;
14969: x_return_status := FND_API.G_RET_STS_ERROR;

Line 14966: IF FND_API.To_Boolean(p_commit) THEN

14962:
14963: EXCEPTION
14964: WHEN FND_API.G_EXC_ERROR THEN
14965: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
14966: IF FND_API.To_Boolean(p_commit) THEN
14967: ROLLBACK TO Copy_User_Attrs_Data_PUB;
14968: END IF;
14969: x_return_status := FND_API.G_RET_STS_ERROR;
14970:

Line 14969: x_return_status := FND_API.G_RET_STS_ERROR;

14965: Debug_Msg(l_api_name || ' EXCEPTION FND_API.G_EXC_ERROR');
14966: IF FND_API.To_Boolean(p_commit) THEN
14967: ROLLBACK TO Copy_User_Attrs_Data_PUB;
14968: END IF;
14969: x_return_status := FND_API.G_RET_STS_ERROR;
14970:
14971: ERROR_HANDLER.Add_Error_Message(
14972: p_message_name => x_msg_data
14973: ,p_application_id => 'EGO'

Line 14974: ,p_message_type => FND_API.G_RET_STS_ERROR

14970:
14971: ERROR_HANDLER.Add_Error_Message(
14972: p_message_name => x_msg_data
14973: ,p_application_id => 'EGO'
14974: ,p_message_type => FND_API.G_RET_STS_ERROR
14975: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
14976: );
14977:
14978: WHEN OTHERS THEN

Line 14983: IF FND_API.To_Boolean(p_commit) THEN

14979: IF DBMS_SQL.IS_OPEN(l_pk_cursor) then
14980: DBMS_SQL.CLOSE_CURSOR(l_pk_cursor);
14981: END IF;
14982: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM);
14983: IF FND_API.To_Boolean(p_commit) THEN
14984: ROLLBACK TO Copy_User_Attrs_Data_PUB;
14985: END IF;
14986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14987:

Line 14986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

14982: Debug_Msg(l_api_name || ' EXCEPTION OTHERS '||SQLERRM);
14983: IF FND_API.To_Boolean(p_commit) THEN
14984: ROLLBACK TO Copy_User_Attrs_Data_PUB;
14985: END IF;
14986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14987:
14988: DECLARE
14989: l_token_table ERROR_HANDLER.Token_Tbl_Type;
14990: BEGIN

Line 15002: ,p_message_type => FND_API.G_RET_STS_ERROR

14998: ERROR_HANDLER.Add_Error_Message(
14999: p_message_name => 'EGO_PLSQL_ERR'
15000: ,p_application_id => 'EGO'
15001: ,p_token_tbl => l_token_table
15002: ,p_message_type => FND_API.G_RET_STS_ERROR
15003: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
15004: );
15005: END;
15006:

Line 15023: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

15019: ,p_change_line_id IN NUMBER
15020: ,p_old_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
15021: ,p_new_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
15022: ,p_related_class_code_function IN VARCHAR2
15023: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
15024: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
15025: ,x_return_status OUT NOCOPY VARCHAR2
15026: ,x_errorcode OUT NOCOPY NUMBER
15027: ,x_msg_count OUT NOCOPY NUMBER

Line 15024: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

15020: ,p_old_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
15021: ,p_new_data_level_nv_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
15022: ,p_related_class_code_function IN VARCHAR2
15023: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
15024: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
15025: ,x_return_status OUT NOCOPY VARCHAR2
15026: ,x_errorcode OUT NOCOPY NUMBER
15027: ,x_msg_count OUT NOCOPY NUMBER
15028: ,x_msg_data OUT NOCOPY VARCHAR2

Line 15086: IF FND_API.To_Boolean(p_commit) THEN

15082: BEGIN
15083:
15084: Debug_Msg('In Implement_Change_Line, starting', 1);
15085:
15086: IF FND_API.To_Boolean(p_commit) THEN
15087: SAVEPOINT Implement_Change_Line_PUB;
15088: END IF;
15089:
15090: -- Initialize FND_MSG_PUB and ERROR_HANDLER if necessary

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

15087: SAVEPOINT Implement_Change_Line_PUB;
15088: END IF;
15089:
15090: -- Initialize FND_MSG_PUB and ERROR_HANDLER if necessary
15091: IF (FND_API.To_Boolean(p_init_msg_list)) THEN
15092: FND_MSG_PUB.Initialize;
15093: ERROR_HANDLER.Initialize;
15094: END IF;
15095:

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

15093: ERROR_HANDLER.Initialize;
15094: END IF;
15095:
15096: -- Check for call compatibility
15097: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
15098: l_api_name, G_PKG_NAME)
15099: THEN
15100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15101: END IF;

Line 15100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

15096: -- Check for call compatibility
15097: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
15098: l_api_name, G_PKG_NAME)
15099: THEN
15100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15101: END IF;
15102:
15103: -----------------------------------------------
15104: -- First, we get the Object ID for our calls --

Line 15901: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

15897: ,p_extension_id => l_ext_id_for_current_row
15898: ,p_attr_name_value_pairs => l_attr_name_value_pairs
15899: ,p_language_to_process => l_current_row_language
15900: ,p_mode => l_mode_for_current_row
15901: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
15902: ,x_return_status => x_return_status
15903: ,x_errorcode => x_errorcode
15904: ,x_msg_count => x_msg_count
15905: ,x_msg_data => x_msg_data

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

15904: ,x_msg_count => x_msg_count
15905: ,x_msg_data => x_msg_data
15906: );
15907:
15908: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
15909: RAISE FND_API.G_EXC_ERROR;
15910: END IF;
15911: END IF;
15912: END LOOP;

Line 15909: RAISE FND_API.G_EXC_ERROR;

15905: ,x_msg_data => x_msg_data
15906: );
15907:
15908: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
15909: RAISE FND_API.G_EXC_ERROR;
15910: END IF;
15911: END IF;
15912: END LOOP;
15913: DBMS_SQL.Close_Cursor(l_cursor_id);

Line 15927: IF FND_API.To_Boolean(p_commit) THEN

15923: ' SET IMPLEMENTATION_DATE = :1'||
15924: ' WHERE CHANGE_LINE_ID = :2'
15925: USING SYSDATE, p_change_line_id;
15926:
15927: IF FND_API.To_Boolean(p_commit) THEN
15928: COMMIT WORK;
15929: END IF;
15930:
15931: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 15931: x_return_status := FND_API.G_RET_STS_SUCCESS;

15927: IF FND_API.To_Boolean(p_commit) THEN
15928: COMMIT WORK;
15929: END IF;
15930:
15931: x_return_status := FND_API.G_RET_STS_SUCCESS;
15932:
15933: Debug_Msg('In Implement_Change_Line, done', 1);
15934:
15935: EXCEPTION

Line 15936: WHEN FND_API.G_EXC_ERROR THEN

15932:
15933: Debug_Msg('In Implement_Change_Line, done', 1);
15934:
15935: EXCEPTION
15936: WHEN FND_API.G_EXC_ERROR THEN
15937: Debug_Msg('In Implement_Change_Line, EXCEPTION FND_API.G_EXC_ERROR ', 1);
15938: IF FND_API.To_Boolean(p_commit) THEN
15939: ROLLBACK TO Implement_Change_Line_PUB;
15940: END IF;

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

15933: Debug_Msg('In Implement_Change_Line, done', 1);
15934:
15935: EXCEPTION
15936: WHEN FND_API.G_EXC_ERROR THEN
15937: Debug_Msg('In Implement_Change_Line, EXCEPTION FND_API.G_EXC_ERROR ', 1);
15938: IF FND_API.To_Boolean(p_commit) THEN
15939: ROLLBACK TO Implement_Change_Line_PUB;
15940: END IF;
15941: x_return_status := FND_API.G_RET_STS_ERROR;

Line 15938: IF FND_API.To_Boolean(p_commit) THEN

15934:
15935: EXCEPTION
15936: WHEN FND_API.G_EXC_ERROR THEN
15937: Debug_Msg('In Implement_Change_Line, EXCEPTION FND_API.G_EXC_ERROR ', 1);
15938: IF FND_API.To_Boolean(p_commit) THEN
15939: ROLLBACK TO Implement_Change_Line_PUB;
15940: END IF;
15941: x_return_status := FND_API.G_RET_STS_ERROR;
15942:

Line 15941: x_return_status := FND_API.G_RET_STS_ERROR;

15937: Debug_Msg('In Implement_Change_Line, EXCEPTION FND_API.G_EXC_ERROR ', 1);
15938: IF FND_API.To_Boolean(p_commit) THEN
15939: ROLLBACK TO Implement_Change_Line_PUB;
15940: END IF;
15941: x_return_status := FND_API.G_RET_STS_ERROR;
15942:
15943: -----------------------------------------------------------------
15944: -- If Process_Row didn't return any errors, make one ourselves --
15945: -----------------------------------------------------------------

Line 15950: ,p_message_type => FND_API.G_RET_STS_ERROR

15946: IF (x_msg_data IS NULL AND x_msg_count = 0) THEN
15947: ERROR_HANDLER.Add_Error_Message(
15948: p_message_name => 'EGO_EF_IMPLEMENT_ERR'
15949: ,p_application_id => 'EGO'
15950: ,p_message_type => FND_API.G_RET_STS_ERROR
15951: ,p_addto_fnd_stack => 'Y'
15952: );
15953: END IF;
15954:

Line 15972: IF FND_API.To_Boolean(p_commit) THEN

15968: Debug_Msg('In Implement_Change_Line, got expected error: x_msg_data is '||x_msg_data, 3);
15969:
15970: WHEN OTHERS THEN
15971: Debug_Msg('In Implement_Change_Line, EXCEPTION OTHERS ', 1);
15972: IF FND_API.To_Boolean(p_commit) THEN
15973: ROLLBACK TO Implement_Change_Line_PUB;
15974: END IF;
15975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15976:

Line 15975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

15971: Debug_Msg('In Implement_Change_Line, EXCEPTION OTHERS ', 1);
15972: IF FND_API.To_Boolean(p_commit) THEN
15973: ROLLBACK TO Implement_Change_Line_PUB;
15974: END IF;
15975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15976:
15977: DECLARE
15978: l_dummy_entity_index NUMBER;
15979: l_dummy_entity_id VARCHAR2(60);

Line 15993: ,p_message_type => FND_API.G_RET_STS_ERROR

15989: ERROR_HANDLER.Add_Error_Message(
15990: p_message_name => 'EGO_PLSQL_ERR'
15991: ,p_application_id => 'EGO'
15992: ,p_token_tbl => l_token_table
15993: ,p_message_type => FND_API.G_RET_STS_ERROR
15994: ,p_addto_fnd_stack => 'Y'
15995: );
15996:
15997: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data

Line 16151: l_has_data_level_id := FND_API.TO_BOOLEAN(

16147: --------------------------------------------------------------
16148: -- WHERE conditions: Data Level ID, Data Level Primary Keys --
16149: --------------------------------------------------------------
16150:
16151: l_has_data_level_id := FND_API.TO_BOOLEAN(
16152: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => p_attr_group_metadata_obj.EXT_TABLE_B_NAME
16153: ,p_column_name => 'DATA_LEVEL_ID')
16154: );
16155:

Line 16183: ,p_message_type => FND_API.G_RET_STS_ERROR

16179: ERROR_HANDLER.Add_Error_Message(
16180: p_message_name => 'EGO_EF_DL_AG_INVALID'
16181: ,p_application_id => 'EGO'
16182: ,p_token_tbl => l_token_table
16183: ,p_message_type => FND_API.G_RET_STS_ERROR
16184: ,p_row_identifier => G_USER_ROW_IDENTIFIER
16185: ,p_entity_id => NULL
16186: ,p_entity_index => NULL
16187: ,p_entity_code => NULL

Line 16191: RAISE FND_API.G_EXC_ERROR;

16187: ,p_entity_code => NULL
16188: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
16189: );
16190: l_token_table.DELETE();
16191: RAISE FND_API.G_EXC_ERROR;
16192: END IF;
16193:
16194: END IF;
16195: ELSE

Line 16410: l_has_data_level_id := FND_API.TO_BOOLEAN(

16406: -- Get data level metadata, if applicable
16407: IF p_data_level IS NOT NULL THEN
16408: -- check if the passed in data level is valid for this attribute group.
16409: Debug_Msg(l_api_name || ' Non-null data level');
16410: l_has_data_level_id := FND_API.TO_BOOLEAN(
16411: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_attr_group_metadata_obj.EXT_TABLE_B_NAME
16412: ,p_column_name => 'DATA_LEVEL_ID')
16413: );
16414: IF l_has_data_level_id THEN

Line 16453: ,p_message_type => FND_API.G_RET_STS_ERROR

16449: ERROR_HANDLER.Add_Error_Message(
16450: p_message_name => 'EGO_EF_DL_AG_INVALID'
16451: ,p_application_id => 'EGO'
16452: ,p_token_tbl => l_token_table
16453: ,p_message_type => FND_API.G_RET_STS_ERROR
16454: ,p_row_identifier => G_USER_ROW_IDENTIFIER
16455: ,p_entity_id => NULL
16456: ,p_entity_index => NULL
16457: ,p_entity_code => NULL

Line 16461: RAISE FND_API.G_EXC_ERROR;

16457: ,p_entity_code => NULL
16458: ,p_addto_fnd_stack => G_ADD_ERRORS_TO_FND_STACK
16459: );
16460: l_token_table.DELETE();
16461: RAISE FND_API.G_EXC_ERROR;
16462: END IF;
16463:
16464: END IF;
16465: END IF; -- has_data_level

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

16735: ,x_return_status => l_return_status
16736: ,x_error_mesg => l_error_mesg
16737: );
16738:
16739: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
16740:
16741: ERROR_HANDLER.Add_Error_Message(
16742: p_message_text => l_error_mesg
16743: ,p_message_type => 'E'

Line 16891: ,p_commit => FND_API.G_FALSE

16887: ,p_data_level_name_value_pairs => p_data_level_name_value_pairs
16888: ,p_extension_id => l_extension_id
16889: ,p_attr_name_value_pairs => l_new_attr_name_value_pairs
16890: ,p_mode => l_mode
16891: ,p_commit => FND_API.G_FALSE
16892: ,p_bulkload_flag => TRUE
16893: ,x_extension_id => l_extension_id
16894: ,x_return_status => l_return_status
16895: );

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

16897: ELSE
16898: Debug_Msg('In Update_Attributes, skipped perform_dml');
16899: END IF;
16900:
16901: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
16902: Debug_Msg('In Update_Attributes, ERROR ret status: '||l_return_status, 2);
16903: RAISE FND_API.G_EXC_ERROR;
16904: END IF;
16905:

Line 16903: RAISE FND_API.G_EXC_ERROR;

16899: END IF;
16900:
16901: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
16902: Debug_Msg('In Update_Attributes, ERROR ret status: '||l_return_status, 2);
16903: RAISE FND_API.G_EXC_ERROR;
16904: END IF;
16905:
16906: EXCEPTION
16907: WHEN FND_API.G_EXC_ERROR THEN

Line 16907: WHEN FND_API.G_EXC_ERROR THEN

16903: RAISE FND_API.G_EXC_ERROR;
16904: END IF;
16905:
16906: EXCEPTION
16907: WHEN FND_API.G_EXC_ERROR THEN
16908: Debug_Msg('In Update_Attributes, EXCEPTION FND_API.G_EXC_ERROR');
16909: x_error_message := FND_API.G_RET_STS_ERROR;
16910:
16911: END Update_Attributes;

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

16904: END IF;
16905:
16906: EXCEPTION
16907: WHEN FND_API.G_EXC_ERROR THEN
16908: Debug_Msg('In Update_Attributes, EXCEPTION FND_API.G_EXC_ERROR');
16909: x_error_message := FND_API.G_RET_STS_ERROR;
16910:
16911: END Update_Attributes;
16912:

Line 16909: x_error_message := FND_API.G_RET_STS_ERROR;

16905:
16906: EXCEPTION
16907: WHEN FND_API.G_EXC_ERROR THEN
16908: Debug_Msg('In Update_Attributes, EXCEPTION FND_API.G_EXC_ERROR');
16909: x_error_message := FND_API.G_RET_STS_ERROR;
16910:
16911: END Update_Attributes;
16912:
16913: ----------------------------------------------------------------------

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

17018: Debug_Msg('In Get_Attr_Diffs, finished');
17019:
17020: EXCEPTION
17021: WHEN OTHERS THEN
17022: Debug_Msg('In Get_Attr_Diffs, EXCEPTION FND_API.G_EXC_ERROR');
17023: RAISE FND_API.G_EXC_ERROR;
17024:
17025: END Get_Attr_Diffs;
17026:

Line 17023: RAISE FND_API.G_EXC_ERROR;

17019:
17020: EXCEPTION
17021: WHEN OTHERS THEN
17022: Debug_Msg('In Get_Attr_Diffs, EXCEPTION FND_API.G_EXC_ERROR');
17023: RAISE FND_API.G_EXC_ERROR;
17024:
17025: END Get_Attr_Diffs;
17026:
17027: ---------------------------------------------------------------------------------

Line 17090: 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

17086: ,p_attr_group_name => p_attr_group_int_name
17087: );
17088:
17089: --todo: why is this here?
17090: 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
17091: -- data level exists
17092: NULL;
17093: END IF;
17094:

Line 17924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

17920: END IF;
17921: END LOOP;
17922:
17923: IF l_ix = -1 THEN
17924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
17925: END IF;
17926:
17927: IF p_attributes_data_table(j).ATTR_NAME = req_attr_rec.attr_name
17928: AND

Line 18007: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

18003: ,p_entity_id IN NUMBER DEFAULT NULL
18004: ,p_entity_index IN NUMBER DEFAULT NULL
18005: ,p_entity_code IN VARCHAR2 DEFAULT NULL
18006: ,p_debug_level IN NUMBER DEFAULT 0
18007: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
18008: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
18009: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
18010: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
18011: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 18008: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

18004: ,p_entity_index IN NUMBER DEFAULT NULL
18005: ,p_entity_code IN VARCHAR2 DEFAULT NULL
18006: ,p_debug_level IN NUMBER DEFAULT 0
18007: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
18008: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
18009: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
18010: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
18011: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
18012: ,x_attributes_req_table OUT NOCOPY EGO_USER_ATTR_TABLE

Line 18009: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

18005: ,p_entity_code IN VARCHAR2 DEFAULT NULL
18006: ,p_debug_level IN NUMBER DEFAULT 0
18007: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
18008: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
18009: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
18010: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
18011: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
18012: ,x_attributes_req_table OUT NOCOPY EGO_USER_ATTR_TABLE
18013: ,x_return_status OUT NOCOPY VARCHAR2

Line 18010: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

18006: ,p_debug_level IN NUMBER DEFAULT 0
18007: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
18008: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
18009: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
18010: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
18011: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
18012: ,x_attributes_req_table OUT NOCOPY EGO_USER_ATTR_TABLE
18013: ,x_return_status OUT NOCOPY VARCHAR2
18014: ,x_errorcode OUT NOCOPY NUMBER

Line 18011: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

18007: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
18008: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
18009: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
18010: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
18011: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
18012: ,x_attributes_req_table OUT NOCOPY EGO_USER_ATTR_TABLE
18013: ,x_return_status OUT NOCOPY VARCHAR2
18014: ,x_errorcode OUT NOCOPY NUMBER
18015: ,x_msg_count OUT NOCOPY NUMBER

Line 18152: WHEN FND_API.G_EXC_ERROR THEN

18148:
18149: Debug_Msg(l_api_name||' done', 2);
18150:
18151: EXCEPTION
18152: WHEN FND_API.G_EXC_ERROR THEN
18153: x_return_status := FND_API.G_RET_STS_ERROR;
18154:
18155: WHEN OTHERS THEN
18156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 18153: x_return_status := FND_API.G_RET_STS_ERROR;

18149: Debug_Msg(l_api_name||' done', 2);
18150:
18151: EXCEPTION
18152: WHEN FND_API.G_EXC_ERROR THEN
18153: x_return_status := FND_API.G_RET_STS_ERROR;
18154:
18155: WHEN OTHERS THEN
18156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
18157: l_token_table.DELETE();

Line 18156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

18152: WHEN FND_API.G_EXC_ERROR THEN
18153: x_return_status := FND_API.G_RET_STS_ERROR;
18154:
18155: WHEN OTHERS THEN
18156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
18157: l_token_table.DELETE();
18158: l_token_table(1).TOKEN_NAME := 'PKG_NAME';
18159: l_token_table(1).TOKEN_VALUE := G_PKG_NAME;
18160: l_token_table(2).TOKEN_NAME := 'API_NAME';

Line 18169: ,p_message_type => FND_API.G_RET_STS_ERROR

18165: ERROR_HANDLER.Add_Error_Message(
18166: p_message_name => 'EGO_PLSQL_ERR'
18167: ,p_application_id => 'EGO'
18168: ,p_token_tbl => l_token_table
18169: ,p_message_type => FND_API.G_RET_STS_ERROR
18170: ,p_row_identifier => G_USER_ROW_IDENTIFIER
18171: ,p_entity_id => p_entity_id
18172: ,p_entity_index => p_entity_index
18173: ,p_entity_code => p_entity_code

Line 18292: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE

18288: ,p_entity_id IN NUMBER DEFAULT NULL
18289: ,p_entity_index IN NUMBER DEFAULT NULL
18290: ,p_entity_code IN VARCHAR2 DEFAULT NULL
18291: ,p_debug_level IN NUMBER DEFAULT 0
18292: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
18293: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
18294: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
18295: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
18296: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 18293: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

18289: ,p_entity_index IN NUMBER DEFAULT NULL
18290: ,p_entity_code IN VARCHAR2 DEFAULT NULL
18291: ,p_debug_level IN NUMBER DEFAULT 0
18292: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
18293: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
18294: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
18295: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
18296: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
18297: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 18294: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

18290: ,p_entity_code IN VARCHAR2 DEFAULT NULL
18291: ,p_debug_level IN NUMBER DEFAULT 0
18292: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
18293: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
18294: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
18295: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
18296: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
18297: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
18298: ,x_failed_row_id_list OUT NOCOPY VARCHAR2

Line 18295: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

18291: ,p_debug_level IN NUMBER DEFAULT 0
18292: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
18293: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
18294: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
18295: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
18296: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
18297: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
18298: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
18299: ,x_return_status OUT NOCOPY VARCHAR2

Line 18296: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

18292: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
18293: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
18294: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
18295: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
18296: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
18297: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
18298: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
18299: ,x_return_status OUT NOCOPY VARCHAR2
18300: ,x_errorcode OUT NOCOPY NUMBER

Line 18297: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

18293: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
18294: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
18295: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
18296: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
18297: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
18298: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
18299: ,x_return_status OUT NOCOPY VARCHAR2
18300: ,x_errorcode OUT NOCOPY NUMBER
18301: ,x_msg_count OUT NOCOPY NUMBER

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

18412: -------------------------------------------------------------
18413: -- Find out weather the ATTR_GROUP_ID column exists in the --
18414: -- table where attribute data is to be uploaded or not --
18415: -------------------------------------------------------------
18416: l_ag_id_col_exists := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
18417: p_table_name => l_ext_b_table_name
18418: ,p_column_name => 'ATTR_GROUP_ID')
18419: );
18420:

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

18417: p_table_name => l_ext_b_table_name
18418: ,p_column_name => 'ATTR_GROUP_ID')
18419: );
18420:
18421: l_has_data_level_id := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
18422: p_table_name => l_ext_b_table_name
18423: ,p_column_name => 'DATA_LEVEL_ID')
18424: );
18425:

Line 18880: RETURN FND_API.G_TRUE;

18876: AND col.owner = syn.table_owner
18877: AND col.table_name = syn.table_name
18878: AND col.column_name = p_column_name;
18879:
18880: RETURN FND_API.G_TRUE;
18881: EXCEPTION
18882: WHEN OTHERS THEN
18883: RETURN FND_API.G_FALSE;
18884: END HAS_COLUMN_IN_TABLE_VIEW;

Line 18883: RETURN FND_API.G_FALSE;

18879:
18880: RETURN FND_API.G_TRUE;
18881: EXCEPTION
18882: WHEN OTHERS THEN
18883: RETURN FND_API.G_FALSE;
18884: END HAS_COLUMN_IN_TABLE_VIEW;
18885:
18886:
18887: