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

Line 1140: IF l_ss_record_table(i) IS NULL OR l_ss_record_table(i) = FND_API.G_MISS_CHAR

1136:
1137: l_count := l_ss_record_table.COUNT;
1138: FOR i IN 1..l_count
1139: LOOP
1140: IF l_ss_record_table(i) IS NULL OR l_ss_record_table(i) = FND_API.G_MISS_CHAR
1141: THEN
1142: Error_Handler.Add_Error_Token
1143: (
1144: p_message_name => 'BOM_SOURCE_SYS_REF_INVALID'

Line 1150: x_return_status := FND_API.G_RET_STS_ERROR;

1146: ,x_Mesg_token_Tbl => l_Mesg_Token_Tbl
1147: ,p_token_Tbl => l_Token_Tbl
1148: ,p_message_type => 'E'
1149: );
1150: x_return_status := FND_API.G_RET_STS_ERROR;
1151:
1152: ELSE
1153: write_debug('Updating the header x-refs ');
1154:

Line 1172: IF l_ss_record_table(i) IS NULL OR l_ss_record_table(i) = FND_API.G_MISS_CHAR

1168:
1169: l_count := l_ss_record_table.COUNT;
1170: FOR i IN 1..l_count
1171: LOOP
1172: IF l_ss_record_table(i) IS NULL OR l_ss_record_table(i) = FND_API.G_MISS_CHAR
1173: THEN
1174: Error_Handler.Add_Error_Token
1175: (
1176: p_message_name => 'BOM_SOURCE_SYS_REF_INVALID'

Line 1182: x_return_status := FND_API.G_RET_STS_ERROR;

1178: ,x_Mesg_token_Tbl => l_Mesg_Token_Tbl
1179: ,p_token_Tbl => l_Token_Tbl
1180: ,p_message_type => 'E'
1181: );
1182: x_return_status := FND_API.G_RET_STS_ERROR;
1183: ELSE
1184: write_debug('Updating the component x-refs ');
1185:
1186: UPDATE bom_inventory_comps_interface

Line 1212: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

1208: AND comp_source_system_reference = l_ss_record_table(i)
1209: AND ( process_flag = 1 OR process_flag = 5) ;
1210: END LOOP;
1211:
1212: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1213:
1214: EXCEPTION
1215: WHEN OTHERS THEN
1216:

Line 1231: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1227: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1228: );
1229: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1230: END IF;
1231: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1232:
1233: END RESOLVE_XREFS_FOR_BATCH;
1234:
1235: /* Update Match Data */

Line 1307: IF ( (l_ss_record_table(i) IS NULL AND l_item_num_table(i) IS NULL ) OR ( l_ss_record_table(i) = FND_API.G_MISS_CHAR AND l_item_num_table(i) = FND_API.G_MISS_CHAR) )

1303: l_count := l_ss_record_table.COUNT;
1304:
1305: FOR i IN 1..l_count
1306: LOOP
1307: IF ( (l_ss_record_table(i) IS NULL AND l_item_num_table(i) IS NULL ) OR ( l_ss_record_table(i) = FND_API.G_MISS_CHAR AND l_item_num_table(i) = FND_API.G_MISS_CHAR) )
1308: THEN
1309: Error_Handler.Add_Error_Token
1310: (
1311: p_message_name => 'BOM_SOURCE_SYS_REF_INVALID'

Line 1317: x_return_status := FND_API.G_RET_STS_ERROR;

1313: ,x_Mesg_token_Tbl => l_Mesg_Token_Tbl
1314: ,p_token_Tbl => l_Token_Tbl
1315: ,p_message_type => 'E'
1316: );
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: ELSE
1319: write_debug('Updating the Header matches ');
1320:
1321: UPDATE bom_bill_of_mtls_interface

Line 1341: IF ( (l_ss_record_table(i) IS NULL AND l_item_num_table(i) IS NULL ) OR ( l_ss_record_table(i) = FND_API.G_MISS_CHAR AND l_item_num_table(i) = FND_API.G_MISS_CHAR) )

1337:
1338:
1339: FOR i IN 1..l_count
1340: LOOP
1341: IF ( (l_ss_record_table(i) IS NULL AND l_item_num_table(i) IS NULL ) OR ( l_ss_record_table(i) = FND_API.G_MISS_CHAR AND l_item_num_table(i) = FND_API.G_MISS_CHAR) )
1342: THEN
1343: Error_Handler.Add_Error_Token
1344: (
1345: p_message_name => 'BOM_SOURCE_SYS_REF_INVALID'

Line 1351: x_return_status := FND_API.G_RET_STS_ERROR;

1347: ,x_Mesg_token_Tbl => l_Mesg_Token_Tbl
1348: ,p_token_Tbl => l_Token_Tbl
1349: ,p_message_type => 'E'
1350: );
1351: x_return_status := FND_API.G_RET_STS_ERROR;
1352: ELSE
1353: write_debug('Updating the Component Matches');
1354: UPDATE bom_inventory_comps_interface
1355: SET component_item_id = l_item_id_table(i),

Line 1400: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1396: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1397: );
1398: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1399: END IF;
1400: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1401: END UPDATE_MATCH_DATA;
1402:
1403: /* End Update Match Data */ --??DInu why two
1404:

Line 1733: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1729: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1730: );
1731: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1732: END IF;
1733: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1734: END UPDATE_BILL_INFO;
1735:
1736: /* End Update Bill Info */
1737:

Line 1937: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

1933: , p_mesg_token_tbl => l_mesg_token_tbl
1934: , x_mesg_token_tbl => l_mesg_token_tbl
1935: );
1936:
1937: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1938: THEN
1939: l_debug_flag := 'N';
1940: END IF;
1941: END IF;

Line 1976: x_return_status := FND_API.G_RET_STS_ERROR;

1972: );
1973:
1974: Error_Handler.Get_Message_List( x_message_list => l_message_list);
1975: x_Error_Mesg := l_message_list(1).Message_Text;
1976: x_return_status := FND_API.G_RET_STS_ERROR;
1977: RETURN;
1978: END IF;
1979:
1980: Write_Debug('In Data Upld Complete Retrieving Batch Options');

Line 2203: x_return_status := FND_API.G_RET_STS_SUCCESS;

2199: END IF;
2200:
2201: commit;
2202: --arudresh_debug('l_req_id--' || l_request_id);
2203: x_return_status := FND_API.G_RET_STS_SUCCESS;
2204: return;
2205: END IF;
2206:
2207: EXCEPTION

Line 2210: x_return_status := FND_API.G_RET_STS_ERROR;

2206:
2207: EXCEPTION
2208: WHEN l_submit_failure_exc THEN
2209: write_debug('Got Exception while Submitting Conc Request');
2210: x_return_status := FND_API.G_RET_STS_ERROR;
2211: WHEN G_EXC_SEV_QUIT_OBJECT THEN
2212: write_debug('Got User Defined Exception ');
2213: x_return_status := FND_API.G_RET_STS_ERROR;
2214: WHEN OTHERS THEN

Line 2213: x_return_status := FND_API.G_RET_STS_ERROR;

2209: write_debug('Got Exception while Submitting Conc Request');
2210: x_return_status := FND_API.G_RET_STS_ERROR;
2211: WHEN G_EXC_SEV_QUIT_OBJECT THEN
2212: write_debug('Got User Defined Exception ');
2213: x_return_status := FND_API.G_RET_STS_ERROR;
2214: WHEN OTHERS THEN
2215: write_debug('Got Other Exception');
2216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2217:

Line 2216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2212: write_debug('Got User Defined Exception ');
2213: x_return_status := FND_API.G_RET_STS_ERROR;
2214: WHEN OTHERS THEN
2215: write_debug('Got Other Exception');
2216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2217:
2218:
2219:
2220:

Line 2839: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

2835: , p_mesg_token_tbl => l_mesg_token_tbl
2836: , x_mesg_token_tbl => l_mesg_token_tbl
2837: );
2838:
2839: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2840: THEN
2841: l_debug_flag := 'N';
2842: END IF;
2843: END IF;

Line 2964: RETURN FND_API.G_MISS_NUM;

2960: FUNCTION get_G_MISS_NUM
2961: RETURN NUMBER
2962: IS
2963: BEGIN
2964: RETURN FND_API.G_MISS_NUM;
2965:
2966: END get_G_MISS_NUM;
2967:
2968: FUNCTION get_G_MISS_CHAR RETURN VARCHAR

Line 2971: RETURN FND_API.G_MISS_CHAR;

2967:
2968: FUNCTION get_G_MISS_CHAR RETURN VARCHAR
2969: IS
2970: BEGIN
2971: RETURN FND_API.G_MISS_CHAR;
2972:
2973: END get_G_MISS_CHAR;
2974:
2975: FUNCTION get_G_MISS_DATE RETURN DATE

Line 2978: RETURN FND_API.G_MISS_DATE;

2974:
2975: FUNCTION get_G_MISS_DATE RETURN DATE
2976: IS
2977: BEGIN
2978: RETURN FND_API.G_MISS_DATE;
2979:
2980: END get_G_MISS_DATE;
2981:
2982: FUNCTION get_ref_desgs

Line 5086: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

5082: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
5083: );
5084: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
5085: END IF;
5086: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
5087: END PROCESS_ALL_COMPS_BATCH;
5088:
5089: /**
5090: * This function is a public api that should be called by Ebusiness Suite Open

Line 5201: x_Ret_Code := FND_API.G_RET_STS_SUCCESS;

5197:
5198: DELETE bom_sub_op_resources_interface
5199: WHERE batch_id = p_batch_id;
5200:
5201: x_Ret_Code := FND_API.G_RET_STS_SUCCESS;
5202:
5203: EXCEPTION
5204: WHEN OTHERS THEN
5205: x_Error_Mesg := 'Delete Intf Rec (' || stmt_num || ') ' || SQLERRM;

Line 5206: x_Ret_Code := FND_API.G_RET_STS_UNEXP_ERROR;

5202:
5203: EXCEPTION
5204: WHEN OTHERS THEN
5205: x_Error_Mesg := 'Delete Intf Rec (' || stmt_num || ') ' || SQLERRM;
5206: x_Ret_Code := FND_API.G_RET_STS_UNEXP_ERROR;
5207:
5208: End Delete_Interface_Records;
5209:
5210: /*

Line 5515: x_Ret_Status := FND_API.G_RET_STS_SUCCESS;

5511: END IF; -- merge count >1
5512:
5513: END IF; --comp_table.process_flag = 1
5514: END LOOP; -- comp_table loop
5515: x_Ret_Status := FND_API.G_RET_STS_SUCCESS;
5516: END Merge_Duplicate_Rows;
5517:
5518: PROCEDURE Merge_Ref_Desgs
5519: (

Line 5590: x_Ret_Status := FND_API.G_RET_STS_SUCCESS;

5586: )
5587: AND component_reference_designator = l_comp_ref_des(i)
5588: AND interface_table_unique_id <> l_max_unique_id(i);
5589: END LOOP;
5590: x_Ret_Status := FND_API.G_RET_STS_SUCCESS;
5591: END Merge_Ref_Desgs;
5592:
5593: PROCEDURE Merge_User_Attrs
5594: (

Line 5749: x_Ret_Status := FND_API.G_RET_STS_SUCCESS;

5745: END IF; -- process flag = 1
5746: END IF; -- Multi Row
5747: END LOOP; -- attrs loop
5748:
5749: x_Ret_Status := FND_API.G_RET_STS_SUCCESS;
5750: END Merge_User_Attrs;
5751:
5752: PROCEDURE Process_CM_Options(p_batch_id IN NUMBER)
5753: IS