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 999: IF l_ss_record_table(i) IS NULL OR l_ss_record_table(i) = FND_API.G_MISS_CHAR

995:
996: l_count := l_ss_record_table.COUNT;
997: FOR i IN 1..l_count
998: LOOP
999: IF l_ss_record_table(i) IS NULL OR l_ss_record_table(i) = FND_API.G_MISS_CHAR
1000: THEN
1001: Error_Handler.Add_Error_Token
1002: (
1003: p_message_name => 'BOM_SOURCE_SYS_REF_INVALID'

Line 1009: x_return_status := FND_API.G_RET_STS_ERROR;

1005: ,x_Mesg_token_Tbl => l_Mesg_Token_Tbl
1006: ,p_token_Tbl => l_Token_Tbl
1007: ,p_message_type => 'E'
1008: );
1009: x_return_status := FND_API.G_RET_STS_ERROR;
1010:
1011: ELSE
1012: write_debug('Updating the header x-refs ');
1013:

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

1027:
1028: l_count := l_ss_record_table.COUNT;
1029: FOR i IN 1..l_count
1030: LOOP
1031: IF l_ss_record_table(i) IS NULL OR l_ss_record_table(i) = FND_API.G_MISS_CHAR
1032: THEN
1033: Error_Handler.Add_Error_Token
1034: (
1035: p_message_name => 'BOM_SOURCE_SYS_REF_INVALID'

Line 1041: x_return_status := FND_API.G_RET_STS_ERROR;

1037: ,x_Mesg_token_Tbl => l_Mesg_Token_Tbl
1038: ,p_token_Tbl => l_Token_Tbl
1039: ,p_message_type => 'E'
1040: );
1041: x_return_status := FND_API.G_RET_STS_ERROR;
1042: ELSE
1043: write_debug('Updating the component x-refs ');
1044:
1045: UPDATE bom_inventory_comps_interface

Line 1071: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

1067: AND comp_source_system_reference = l_ss_record_table(i)
1068: AND ( process_flag = 1 OR process_flag = 5) ;
1069: END LOOP;
1070:
1071: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1072:
1073: EXCEPTION
1074: WHEN OTHERS THEN
1075:

Line 1090: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1086: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1087: );
1088: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1089: END IF;
1090: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1091:
1092: END RESOLVE_XREFS_FOR_BATCH;
1093:
1094: /* Update Match Data */

Line 1166: 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) )

1162: l_count := l_ss_record_table.COUNT;
1163:
1164: FOR i IN 1..l_count
1165: LOOP
1166: 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) )
1167: THEN
1168: Error_Handler.Add_Error_Token
1169: (
1170: p_message_name => 'BOM_SOURCE_SYS_REF_INVALID'

Line 1176: x_return_status := FND_API.G_RET_STS_ERROR;

1172: ,x_Mesg_token_Tbl => l_Mesg_Token_Tbl
1173: ,p_token_Tbl => l_Token_Tbl
1174: ,p_message_type => 'E'
1175: );
1176: x_return_status := FND_API.G_RET_STS_ERROR;
1177: ELSE
1178: write_debug('Updating the Header matches ');
1179:
1180: UPDATE bom_bill_of_mtls_interface

Line 1200: 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) )

1196:
1197:
1198: FOR i IN 1..l_count
1199: LOOP
1200: 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) )
1201: THEN
1202: Error_Handler.Add_Error_Token
1203: (
1204: p_message_name => 'BOM_SOURCE_SYS_REF_INVALID'

Line 1210: x_return_status := FND_API.G_RET_STS_ERROR;

1206: ,x_Mesg_token_Tbl => l_Mesg_Token_Tbl
1207: ,p_token_Tbl => l_Token_Tbl
1208: ,p_message_type => 'E'
1209: );
1210: x_return_status := FND_API.G_RET_STS_ERROR;
1211: ELSE
1212: write_debug('Updating the Component Matches');
1213: UPDATE bom_inventory_comps_interface
1214: SET component_item_id = l_item_id_table(i),

Line 1259: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1255: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1256: );
1257: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1258: END IF;
1259: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1260: END UPDATE_MATCH_DATA;
1261:
1262: /* End Update Match Data */ --??DInu why two
1263:

Line 1590: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1586: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1587: );
1588: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1589: END IF;
1590: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1591: END UPDATE_BILL_INFO;
1592:
1593: /* End Update Bill Info */
1594:

Line 1794: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

1790: , p_mesg_token_tbl => l_mesg_token_tbl
1791: , x_mesg_token_tbl => l_mesg_token_tbl
1792: );
1793:
1794: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1795: THEN
1796: l_debug_flag := 'N';
1797: END IF;
1798: END IF;

Line 1833: x_return_status := FND_API.G_RET_STS_ERROR;

1829: );
1830:
1831: Error_Handler.Get_Message_List( x_message_list => l_message_list);
1832: x_Error_Mesg := l_message_list(1).Message_Text;
1833: x_return_status := FND_API.G_RET_STS_ERROR;
1834: RETURN;
1835: END IF;
1836:
1837: Write_Debug('In Data Upld Complete Retrieving Batch Options');

Line 2060: x_return_status := FND_API.G_RET_STS_SUCCESS;

2056: END IF;
2057:
2058: commit;
2059: --arudresh_debug('l_req_id--' || l_request_id);
2060: x_return_status := FND_API.G_RET_STS_SUCCESS;
2061: return;
2062: END IF;
2063:
2064: EXCEPTION

Line 2067: x_return_status := FND_API.G_RET_STS_ERROR;

2063:
2064: EXCEPTION
2065: WHEN l_submit_failure_exc THEN
2066: write_debug('Got Exception while Submitting Conc Request');
2067: x_return_status := FND_API.G_RET_STS_ERROR;
2068: WHEN G_EXC_SEV_QUIT_OBJECT THEN
2069: write_debug('Got User Defined Exception ');
2070: x_return_status := FND_API.G_RET_STS_ERROR;
2071: WHEN OTHERS THEN

Line 2070: x_return_status := FND_API.G_RET_STS_ERROR;

2066: write_debug('Got Exception while Submitting Conc Request');
2067: x_return_status := FND_API.G_RET_STS_ERROR;
2068: WHEN G_EXC_SEV_QUIT_OBJECT THEN
2069: write_debug('Got User Defined Exception ');
2070: x_return_status := FND_API.G_RET_STS_ERROR;
2071: WHEN OTHERS THEN
2072: write_debug('Got Other Exception');
2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2074:

Line 2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2069: write_debug('Got User Defined Exception ');
2070: x_return_status := FND_API.G_RET_STS_ERROR;
2071: WHEN OTHERS THEN
2072: write_debug('Got Other Exception');
2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2074:
2075:
2076:
2077:

Line 2686: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

2682: , p_mesg_token_tbl => l_mesg_token_tbl
2683: , x_mesg_token_tbl => l_mesg_token_tbl
2684: );
2685:
2686: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2687: THEN
2688: l_debug_flag := 'N';
2689: END IF;
2690: END IF;

Line 2811: RETURN FND_API.G_MISS_NUM;

2807: FUNCTION get_G_MISS_NUM
2808: RETURN NUMBER
2809: IS
2810: BEGIN
2811: RETURN FND_API.G_MISS_NUM;
2812:
2813: END get_G_MISS_NUM;
2814:
2815: FUNCTION get_G_MISS_CHAR RETURN VARCHAR

Line 2818: RETURN FND_API.G_MISS_CHAR;

2814:
2815: FUNCTION get_G_MISS_CHAR RETURN VARCHAR
2816: IS
2817: BEGIN
2818: RETURN FND_API.G_MISS_CHAR;
2819:
2820: END get_G_MISS_CHAR;
2821:
2822: FUNCTION get_G_MISS_DATE RETURN DATE

Line 2825: RETURN FND_API.G_MISS_DATE;

2821:
2822: FUNCTION get_G_MISS_DATE RETURN DATE
2823: IS
2824: BEGIN
2825: RETURN FND_API.G_MISS_DATE;
2826:
2827: END get_G_MISS_DATE;
2828:
2829: FUNCTION get_ref_desgs

Line 4694: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

4690: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4691: );
4692: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
4693: END IF;
4694: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
4695: END PROCESS_ALL_COMPS_BATCH;
4696:
4697: /**
4698: * This function is a public api that should be called by Ebusiness Suite Open

Line 4809: x_Ret_Code := FND_API.G_RET_STS_SUCCESS;

4805:
4806: DELETE bom_sub_op_resources_interface
4807: WHERE batch_id = p_batch_id;
4808:
4809: x_Ret_Code := FND_API.G_RET_STS_SUCCESS;
4810:
4811: EXCEPTION
4812: WHEN OTHERS THEN
4813: x_Error_Mesg := 'Delete Intf Rec (' || stmt_num || ') ' || SQLERRM;

Line 4814: x_Ret_Code := FND_API.G_RET_STS_UNEXP_ERROR;

4810:
4811: EXCEPTION
4812: WHEN OTHERS THEN
4813: x_Error_Mesg := 'Delete Intf Rec (' || stmt_num || ') ' || SQLERRM;
4814: x_Ret_Code := FND_API.G_RET_STS_UNEXP_ERROR;
4815:
4816: End Delete_Interface_Records;
4817:
4818: /*

Line 5123: x_Ret_Status := FND_API.G_RET_STS_SUCCESS;

5119: END IF; -- merge count >1
5120:
5121: END IF; --comp_table.process_flag = 1
5122: END LOOP; -- comp_table loop
5123: x_Ret_Status := FND_API.G_RET_STS_SUCCESS;
5124: END Merge_Duplicate_Rows;
5125:
5126: PROCEDURE Merge_Ref_Desgs
5127: (

Line 5198: x_Ret_Status := FND_API.G_RET_STS_SUCCESS;

5194: )
5195: AND component_reference_designator = l_comp_ref_des(i)
5196: AND interface_table_unique_id <> l_max_unique_id(i);
5197: END LOOP;
5198: x_Ret_Status := FND_API.G_RET_STS_SUCCESS;
5199: END Merge_Ref_Desgs;
5200:
5201: PROCEDURE Merge_User_Attrs
5202: (

Line 5357: x_Ret_Status := FND_API.G_RET_STS_SUCCESS;

5353: END IF; -- process flag = 1
5354: END IF; -- Multi Row
5355: END LOOP; -- attrs loop
5356:
5357: x_Ret_Status := FND_API.G_RET_STS_SUCCESS;
5358: END Merge_User_Attrs;
5359:
5360: PROCEDURE Process_CM_Options(p_batch_id IN NUMBER)
5361: IS