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.

[Home] [Help]

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 789: x_return_status := FND_API.G_RET_STS_SUCCESS ;

785:
786: BEGIN
787:
788:
789: x_return_status := FND_API.G_RET_STS_SUCCESS ;
790: -- get the Production vl name.
791: BEGIN
792: SELECT FLEX_EXT.APPLICATION_VL_NAME
793: INTO p_prod_vl_name

Line 1132: x_return_status := FND_API.G_RET_STS_ERROR;

1128: l_dummy := DBMS_SQL.Execute(l_cursor_id);
1129:
1130: if ( DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
1131: THEN
1132: x_return_status := FND_API.G_RET_STS_ERROR;
1133: ERROR_HANDLER.Initialize();
1134: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
1135: ERROR_HANDLER.Add_Error_Message(
1136: p_message_name => 'EGO_EF_ROW_ALREADY_EXISTS'

Line 1138: ,p_message_type => FND_API.G_RET_STS_ERROR

1134: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
1135: ERROR_HANDLER.Add_Error_Message(
1136: p_message_name => 'EGO_EF_ROW_ALREADY_EXISTS'
1137: ,p_application_id => 'EGO'
1138: ,p_message_type => FND_API.G_RET_STS_ERROR
1139: ,p_addto_fnd_stack => 'Y'
1140: );
1141:
1142: x_msg_count := ERROR_HANDLER.Get_Message_Count();

Line 1159: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1155: END IF ; -- attribute group is MULTI ROW.
1156:
1157: -- if the row is unique in pending validate it against the production data.
1158:
1159: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1160: THEN
1161:
1162: IF g_debug_flag THEN
1163: Write_Debug('Start VALIDATE_USER_ATTRS');

Line 1276: ,p_commit => FND_API.G_FALSE

1272: ,p_pk_column_name_value_pairs => p_pk_column_name_value_pairs
1273: ,p_class_code_name_value_pairs => p_class_code_name_value_pairs
1274: -- ,p_user_privileges_on_object => l_user_privileges_on_object
1275: ,p_validate_only => p_validate_only
1276: ,p_commit => FND_API.G_FALSE
1277: ,p_init_fnd_msg_list => FND_API.G_TRUE
1278: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1279: ,x_failed_row_id_list => l_failed_row_id_list
1280: ,x_return_status => x_return_status

Line 1277: ,p_init_fnd_msg_list => FND_API.G_TRUE

1273: ,p_class_code_name_value_pairs => p_class_code_name_value_pairs
1274: -- ,p_user_privileges_on_object => l_user_privileges_on_object
1275: ,p_validate_only => p_validate_only
1276: ,p_commit => FND_API.G_FALSE
1277: ,p_init_fnd_msg_list => FND_API.G_TRUE
1278: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1279: ,x_failed_row_id_list => l_failed_row_id_list
1280: ,x_return_status => x_return_status
1281: ,x_errorcode => x_errorcode

Line 1278: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

1274: -- ,p_user_privileges_on_object => l_user_privileges_on_object
1275: ,p_validate_only => p_validate_only
1276: ,p_commit => FND_API.G_FALSE
1277: ,p_init_fnd_msg_list => FND_API.G_TRUE
1278: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1279: ,x_failed_row_id_list => l_failed_row_id_list
1280: ,x_return_status => x_return_status
1281: ,x_errorcode => x_errorcode
1282: ,x_msg_count => x_msg_count

Line 1370: x_return_status := FND_API.G_RET_STS_SUCCESS;

1366: WHERE CHANGE_ATTRIBUTE_GROUP_TYPE= p_attr_group_type
1367: AND APPLICATION_ID = p_application_id;
1368:
1369:
1370: x_return_status := FND_API.G_RET_STS_SUCCESS;
1371: l_extension_id := p_extension_id;
1372:
1373:
1374: IF P_MODE <> 'DELETE' -- AND (P_API_CALLER = G_EXEC_MODE_IMPORT OR P_API_CALLER = 'PWB')

Line 1527: ,p_validate_only => FND_API.G_TRUE

1523: ,p_alternate_ext_tl_table_name => l_pending_tl_tbl
1524: ,p_alternate_ext_vl_name => l_pending_vl
1525: ,p_user_privileges_on_object => NULL
1526: ,p_row_identifier => l_extension_id
1527: ,p_validate_only => FND_API.G_TRUE
1528: ,p_mode => p_mode
1529: ,p_acd_type => p_acd_type
1530: ,p_init_fnd_msg_list => FND_API.G_TRUE
1531: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

Line 1530: ,p_init_fnd_msg_list => FND_API.G_TRUE

1526: ,p_row_identifier => l_extension_id
1527: ,p_validate_only => FND_API.G_TRUE
1528: ,p_mode => p_mode
1529: ,p_acd_type => p_acd_type
1530: ,p_init_fnd_msg_list => FND_API.G_TRUE
1531: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1532: ,x_return_status => x_return_status
1533: ,x_errorcode => x_errorcode
1534: ,x_msg_count => x_msg_count

Line 1531: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

1527: ,p_validate_only => FND_API.G_TRUE
1528: ,p_mode => p_mode
1529: ,p_acd_type => p_acd_type
1530: ,p_init_fnd_msg_list => FND_API.G_TRUE
1531: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1532: ,x_return_status => x_return_status
1533: ,x_errorcode => x_errorcode
1534: ,x_msg_count => x_msg_count
1535: ,x_msg_data => x_msg_data

Line 1551: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1547: Write_Debug('x_msg_count: ' || TO_CHAR(x_msg_count));
1548: Write_Debug('x_msg_data: ' || x_msg_data);
1549: END IF ;
1550:
1551: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1552: THEN
1553:
1554: IF g_debug_flag THEN
1555: Write_Debug('Now Generate_DML_For_Row . . . ');

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

1554: IF g_debug_flag THEN
1555: Write_Debug('Now Generate_DML_For_Row . . . ');
1556: END IF ;
1557:
1558: IF x_return_status = FND_API.G_RET_STS_SUCCESS OR x_return_status is NULL
1559: THEN
1560:
1561:
1562: IF g_debug_flag THEN

Line 1604: ,p_execute_dml => FND_API.G_FALSE

1600: ,p_extra_pk_col_name_val_pairs => p_extra_pk_col_name_val_pairs
1601: ,p_alternate_ext_b_table_name => l_pending_base_tbl
1602: ,p_alternate_ext_tl_table_name => l_pending_tl_tbl
1603: ,p_alternate_ext_vl_name => l_pending_vl
1604: ,p_execute_dml => FND_API.G_FALSE
1605: ,p_init_fnd_msg_list => FND_API.G_FALSE
1606: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1607: ,p_raise_business_event => FALSE
1608: ,x_return_status => x_return_status

Line 1605: ,p_init_fnd_msg_list => FND_API.G_FALSE

1601: ,p_alternate_ext_b_table_name => l_pending_base_tbl
1602: ,p_alternate_ext_tl_table_name => l_pending_tl_tbl
1603: ,p_alternate_ext_vl_name => l_pending_vl
1604: ,p_execute_dml => FND_API.G_FALSE
1605: ,p_init_fnd_msg_list => FND_API.G_FALSE
1606: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1607: ,p_raise_business_event => FALSE
1608: ,x_return_status => x_return_status
1609: ,x_errorcode => x_errorcode

Line 1606: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

1602: ,p_alternate_ext_tl_table_name => l_pending_tl_tbl
1603: ,p_alternate_ext_vl_name => l_pending_vl
1604: ,p_execute_dml => FND_API.G_FALSE
1605: ,p_init_fnd_msg_list => FND_API.G_FALSE
1606: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1607: ,p_raise_business_event => FALSE
1608: ,x_return_status => x_return_status
1609: ,x_errorcode => x_errorcode
1610: ,x_msg_count => x_msg_count

Line 1863: ,p_init_fnd_msg_list => FND_API.G_FALSE

1859: ,p_pk_column_name_value_pairs => p_pk_column_name_value_pairs
1860: ,p_attr_group_request_table => l_attr_group_request_table
1861: ,x_attributes_row_table => l_attributes_row_table
1862: ,x_attributes_data_table => l_attributes_data_table
1863: ,p_init_fnd_msg_list => FND_API.G_FALSE
1864: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1865: ,x_return_status => x_return_status
1866: ,x_errorcode => x_errorcode
1867: ,x_msg_count => x_msg_count

Line 1864: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE

1860: ,p_attr_group_request_table => l_attr_group_request_table
1861: ,x_attributes_row_table => l_attributes_row_table
1862: ,x_attributes_data_table => l_attributes_data_table
1863: ,p_init_fnd_msg_list => FND_API.G_FALSE
1864: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1865: ,x_return_status => x_return_status
1866: ,x_errorcode => x_errorcode
1867: ,x_msg_count => x_msg_count
1868: ,x_msg_data => x_msg_data

Line 2798: x_return_status := FND_API.G_RET_STS_SUCCESS;

2794: WHERE LANGS.installed_flag IN ('B','I');
2795:
2796: BEGIN
2797:
2798: x_return_status := FND_API.G_RET_STS_SUCCESS;
2799: if 'CREATE' = p_transaction_mode
2800: then
2801: insert into EGO_MTL_SY_ITEMS_CHG_B(
2802: INVENTORY_ITEM_ID,