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.ENG_CHANGE_ATTR_UTIL dependencies on FND_API

Line 85: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

81: -- ( G_PKG_NAME ,
82: -- 'Open_Debug_Session' ,
83: -- l_error_mesg ) ;
84:
85: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
86: -- RETURN;
87: END IF;
88:
89: g_debug_file := utl_file.fopen( g_output_dir

Line 100: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

96: EXCEPTION
97: WHEN OTHERS THEN
98: g_debug_errmesg := Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240);
99: g_debug_flag := FALSE;
100: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
101:
102: END Open_Debug_Session ;
103:
104:

Line 130: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

126: -- ( G_PKG_NAME ,
127: -- 'Close_Debug_Session' ,
128: -- l_error_mesg ) ;
129: --
130: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
131:
132: END Close_Debug_Session ;
133:
134:

Line 165: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

161: -- ( G_PKG_NAME ,
162: -- 'Write_Debug' ,
163: -- l_error_mesg ) ;
164:
165: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
166:
167: END Write_Debug;
168:
169: --------------------------

Line 206: ,p_message_type => FND_API.G_RET_STS_ERROR

202:
203: ERROR_HANDLER.Add_Error_Message(
204: p_message_name => 'EGO_EF_NO_NAME_TO_VALIDATE'
205: ,p_application_id => 'EGO'
206: ,p_message_type => FND_API.G_RET_STS_ERROR
207: ,p_entity_id => p_entity_id
208: ,p_entity_index => p_entity_index
209: ,p_entity_code => p_entity_code
210: );

Line 212: RAISE FND_API.G_EXC_ERROR;

208: ,p_entity_index => p_entity_index
209: ,p_entity_code => p_entity_code
210: );
211:
212: RAISE FND_API.G_EXC_ERROR;
213:
214: END;
215:
216: EGO_DATA_SECURITY.Get_Functions(

Line 284: ,p_message_type => FND_API.G_RET_STS_ERROR

280: ERROR_HANDLER.Add_Error_Message(
281: p_message_name => l_error_message_name
282: ,p_application_id => 'EGO'
283: ,p_token_tbl => l_token_table
284: ,p_message_type => FND_API.G_RET_STS_ERROR
285: ,p_entity_id => p_entity_id
286: ,p_entity_index => p_entity_index
287: ,p_entity_code => p_entity_code
288: );

Line 290: RAISE FND_API.G_EXC_ERROR;

286: ,p_entity_index => p_entity_index
287: ,p_entity_code => p_entity_code
288: );
289:
290: RAISE FND_API.G_EXC_ERROR;
291:
292: END;
293: END IF;
294:

Line 355: x_return_status := FND_API.G_RET_STS_SUCCESS;

351: OPEN_DEBUG_SESSION( p_output_dir => g_output_dir,
352: p_file_name => g_debug_filename);
353: END IF;
354:
355: x_return_status := FND_API.G_RET_STS_SUCCESS;
356:
357: --Validate GDSN SINGLE ROW START
358: ---------------------------------
359: IF (p_attr_group_type = 'EGO_ITEM_GTIN_ATTRS' AND p_exec_mode = 'PWB')

Line 378: IF x_return_status = FND_API.G_RET_STS_SUCCESS

374: ---------------------------------
375: --Validate GDSN SINGLE ROW END
376: ---------------------------------
377:
378: IF x_return_status = FND_API.G_RET_STS_SUCCESS
379: THEN
380:
381: FOR i IN p_base_attr_names_values.FIRST .. p_base_attr_names_values.LAST
382: LOOP

Line 555: x_return_status := FND_API.G_RET_STS_SUCCESS;

551: OPEN_DEBUG_SESSION( p_output_dir => g_output_dir,
552: p_file_name => g_debug_filename);
553: END IF;
554:
555: x_return_status := FND_API.G_RET_STS_SUCCESS;
556: ---------------------------------
557: --Validate GDSN SINGLE ROW START
558: ---------------------------------
559: IF (p_attr_group_type = 'EGO_ITEM_GTIN_ATTRS' AND p_exec_mode = 'PWB')

Line 576: IF x_return_status = FND_API.G_RET_STS_SUCCESS

572: END IF;
573: ---------------------------------
574: --Validate GDSN SINGLE ROW END
575: ---------------------------------
576: IF x_return_status = FND_API.G_RET_STS_SUCCESS
577: THEN
578:
579: IF p_pk_attr_names_values IS NOT NULL
580: THEN

Line 794: x_return_status := FND_API.G_RET_STS_SUCCESS ;

790:
791: BEGIN
792:
793:
794: x_return_status := FND_API.G_RET_STS_SUCCESS ;
795: -- get the Production vl name.
796: BEGIN
797: SELECT FLEX_EXT.APPLICATION_VL_NAME
798: INTO p_prod_vl_name

Line 1157: x_return_status := FND_API.G_RET_STS_ERROR;

1153: l_dummy := DBMS_SQL.Execute(l_cursor_id);
1154:
1155: if ( DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
1156: THEN
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158: ERROR_HANDLER.Initialize();
1159: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
1160: ERROR_HANDLER.Add_Error_Message(
1161: p_message_name => 'EGO_EF_ROW_ALREADY_EXISTS'

Line 1163: ,p_message_type => FND_API.G_RET_STS_ERROR

1159: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
1160: ERROR_HANDLER.Add_Error_Message(
1161: p_message_name => 'EGO_EF_ROW_ALREADY_EXISTS'
1162: ,p_application_id => 'EGO'
1163: ,p_message_type => FND_API.G_RET_STS_ERROR
1164: ,p_addto_fnd_stack => 'Y'
1165: );
1166:
1167: x_msg_count := ERROR_HANDLER.Get_Message_Count();

Line 1189: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1185: END IF ; -- attribute group is MULTI ROW.
1186:
1187: -- if the row is unique in pending validate it against the production data.
1188:
1189: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1190: THEN
1191:
1192: IF g_debug_flag THEN
1193: Write_Debug('Start VALIDATE_USER_ATTRS');

Line 1306: ,p_commit => FND_API.G_FALSE

1302: ,p_pk_column_name_value_pairs => p_pk_column_name_value_pairs
1303: ,p_class_code_name_value_pairs => p_class_code_name_value_pairs
1304: -- ,p_user_privileges_on_object => l_user_privileges_on_object
1305: ,p_validate_only => p_validate_only
1306: ,p_commit => FND_API.G_FALSE
1307: ,p_init_fnd_msg_list => FND_API.G_TRUE
1308: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1309: ,x_failed_row_id_list => l_failed_row_id_list
1310: ,x_return_status => x_return_status

Line 1307: ,p_init_fnd_msg_list => FND_API.G_TRUE

1303: ,p_class_code_name_value_pairs => p_class_code_name_value_pairs
1304: -- ,p_user_privileges_on_object => l_user_privileges_on_object
1305: ,p_validate_only => p_validate_only
1306: ,p_commit => FND_API.G_FALSE
1307: ,p_init_fnd_msg_list => FND_API.G_TRUE
1308: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1309: ,x_failed_row_id_list => l_failed_row_id_list
1310: ,x_return_status => x_return_status
1311: ,x_errorcode => x_errorcode

Line 1308: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

1304: -- ,p_user_privileges_on_object => l_user_privileges_on_object
1305: ,p_validate_only => p_validate_only
1306: ,p_commit => FND_API.G_FALSE
1307: ,p_init_fnd_msg_list => FND_API.G_TRUE
1308: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1309: ,x_failed_row_id_list => l_failed_row_id_list
1310: ,x_return_status => x_return_status
1311: ,x_errorcode => x_errorcode
1312: ,x_msg_count => x_msg_count

Line 1401: x_return_status := FND_API.G_RET_STS_SUCCESS;

1397: WHERE CHANGE_ATTRIBUTE_GROUP_TYPE= p_attr_group_type
1398: AND APPLICATION_ID = p_application_id;
1399:
1400:
1401: x_return_status := FND_API.G_RET_STS_SUCCESS;
1402: l_extension_id := p_extension_id;
1403:
1404:
1405: IF P_MODE <> 'DELETE' -- AND (P_API_CALLER = G_EXEC_MODE_IMPORT OR P_API_CALLER = 'PWB')

Line 1558: ,p_validate_only => FND_API.G_TRUE

1554: ,p_alternate_ext_tl_table_name => l_pending_tl_tbl
1555: ,p_alternate_ext_vl_name => l_pending_vl
1556: ,p_user_privileges_on_object => NULL
1557: ,p_row_identifier => l_extension_id
1558: ,p_validate_only => FND_API.G_TRUE
1559: ,p_mode => p_mode
1560: ,p_acd_type => p_acd_type
1561: ,p_init_fnd_msg_list => FND_API.G_TRUE
1562: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

Line 1561: ,p_init_fnd_msg_list => FND_API.G_TRUE

1557: ,p_row_identifier => l_extension_id
1558: ,p_validate_only => FND_API.G_TRUE
1559: ,p_mode => p_mode
1560: ,p_acd_type => p_acd_type
1561: ,p_init_fnd_msg_list => FND_API.G_TRUE
1562: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1563: ,x_return_status => x_return_status
1564: ,x_errorcode => x_errorcode
1565: ,x_msg_count => x_msg_count

Line 1562: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

1558: ,p_validate_only => FND_API.G_TRUE
1559: ,p_mode => p_mode
1560: ,p_acd_type => p_acd_type
1561: ,p_init_fnd_msg_list => FND_API.G_TRUE
1562: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1563: ,x_return_status => x_return_status
1564: ,x_errorcode => x_errorcode
1565: ,x_msg_count => x_msg_count
1566: ,x_msg_data => x_msg_data

Line 1582: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1578: Write_Debug('x_msg_count: ' || TO_CHAR(x_msg_count));
1579: Write_Debug('x_msg_data: ' || x_msg_data);
1580: END IF ;
1581:
1582: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1583: THEN
1584:
1585: IF g_debug_flag THEN
1586: Write_Debug('Now Generate_DML_For_Row . . . ');

Line 1589: IF x_return_status = FND_API.G_RET_STS_SUCCESS OR x_return_status is NULL

1585: IF g_debug_flag THEN
1586: Write_Debug('Now Generate_DML_For_Row . . . ');
1587: END IF ;
1588:
1589: IF x_return_status = FND_API.G_RET_STS_SUCCESS OR x_return_status is NULL
1590: THEN
1591:
1592:
1593: IF g_debug_flag THEN

Line 1635: ,p_execute_dml => FND_API.G_FALSE

1631: ,p_extra_pk_col_name_val_pairs => p_extra_pk_col_name_val_pairs
1632: ,p_alternate_ext_b_table_name => l_pending_base_tbl
1633: ,p_alternate_ext_tl_table_name => l_pending_tl_tbl
1634: ,p_alternate_ext_vl_name => l_pending_vl
1635: ,p_execute_dml => FND_API.G_FALSE
1636: ,p_init_fnd_msg_list => FND_API.G_FALSE
1637: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1638: ,p_raise_business_event => FALSE
1639: ,x_return_status => x_return_status

Line 1636: ,p_init_fnd_msg_list => FND_API.G_FALSE

1632: ,p_alternate_ext_b_table_name => l_pending_base_tbl
1633: ,p_alternate_ext_tl_table_name => l_pending_tl_tbl
1634: ,p_alternate_ext_vl_name => l_pending_vl
1635: ,p_execute_dml => FND_API.G_FALSE
1636: ,p_init_fnd_msg_list => FND_API.G_FALSE
1637: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1638: ,p_raise_business_event => FALSE
1639: ,x_return_status => x_return_status
1640: ,x_errorcode => x_errorcode

Line 1637: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

1633: ,p_alternate_ext_tl_table_name => l_pending_tl_tbl
1634: ,p_alternate_ext_vl_name => l_pending_vl
1635: ,p_execute_dml => FND_API.G_FALSE
1636: ,p_init_fnd_msg_list => FND_API.G_FALSE
1637: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1638: ,p_raise_business_event => FALSE
1639: ,x_return_status => x_return_status
1640: ,x_errorcode => x_errorcode
1641: ,x_msg_count => x_msg_count

Line 1894: ,p_init_fnd_msg_list => FND_API.G_FALSE

1890: ,p_pk_column_name_value_pairs => p_pk_column_name_value_pairs
1891: ,p_attr_group_request_table => l_attr_group_request_table
1892: ,x_attributes_row_table => l_attributes_row_table
1893: ,x_attributes_data_table => l_attributes_data_table
1894: ,p_init_fnd_msg_list => FND_API.G_FALSE
1895: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1896: ,x_return_status => x_return_status
1897: ,x_errorcode => x_errorcode
1898: ,x_msg_count => x_msg_count

Line 1895: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

1891: ,p_attr_group_request_table => l_attr_group_request_table
1892: ,x_attributes_row_table => l_attributes_row_table
1893: ,x_attributes_data_table => l_attributes_data_table
1894: ,p_init_fnd_msg_list => FND_API.G_FALSE
1895: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1896: ,x_return_status => x_return_status
1897: ,x_errorcode => x_errorcode
1898: ,x_msg_count => x_msg_count
1899: ,x_msg_data => x_msg_data

Line 2829: x_return_status := FND_API.G_RET_STS_SUCCESS;

2825: WHERE LANGS.installed_flag IN ('B','I');
2826:
2827: BEGIN
2828:
2829: x_return_status := FND_API.G_RET_STS_SUCCESS;
2830: if 'CREATE' = p_transaction_mode
2831: then
2832: insert into EGO_MTL_SY_ITEMS_CHG_B(
2833: INVENTORY_ITEM_ID,