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

Line 54: , p_init_msg_list => FND_API.G_TRUE

50: -- First Get the parent event details (BillCreate/BillUpdate)
51: -- If the call fails or returns and error, the exception is not catched.
52: QA_EDR_STANDARD.GET_ERECORD_ID
53: ( p_api_version => 1.0
54: , p_init_msg_list => FND_API.G_TRUE
55: , x_return_status => l_return_status
56: , x_msg_count => l_msg_count
57: , x_msg_data => l_msg_data
58: , p_event_name => p_event_name

Line 80: , p_init_msg_list => FND_API.G_TRUE

76:
77: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Acknowledging eRecord_id='||l_erecord_id||' with status='||l_trans_status);
78: QA_EDR_STANDARD.SEND_ACKN
79: ( p_api_version => 1.0
80: , p_init_msg_list => FND_API.G_TRUE
81: , x_return_status => l_return_status
82: , x_msg_count => l_msg_count
83: , x_msg_data => l_msg_data
84: , p_event_name => p_event_name

Line 90: , p_autonomous_commit => FND_API.G_TRUE);

86: , p_erecord_id => l_erecord_id
87: , p_trans_status => l_trans_status
88: , p_ackn_by => l_ackn_by
89: , p_ackn_note => p_event_name||', '||p_event_key
90: , p_autonomous_commit => FND_API.G_TRUE);
91:
92: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||l_msg_count);
93:
94: IF (l_return_status <> FND_API.G_TRUE)

Line 94: IF (l_return_status <> FND_API.G_TRUE)

90: , p_autonomous_commit => FND_API.G_TRUE);
91:
92: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||l_msg_count);
93:
94: IF (l_return_status <> FND_API.G_TRUE)
95: THEN
96: RAISE SEND_ACKN_ERROR;
97: END IF;
98:

Line 109: p_encoded => FND_API.G_FALSE,

105: WHEN SEND_ACKN_ERROR THEN
106: FND_MSG_PUB.Get(
107: p_msg_index => 1,
108: p_data => l_msg_data,
109: p_encoded => FND_API.G_FALSE,
110: p_msg_index_out => l_dummy_cnt);
111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACKN Error: '||l_msg_data);
112:
113: WHEN OTHERS THEN

Line 780: x_return_status := FND_API.G_RET_STS_SUCCESS;

776: WHERE component_sequence_id = p_src_comp_seq_id;
777:
778: IF l_comp_rev_id IS NULL
779: THEN
780: x_return_status := FND_API.G_RET_STS_SUCCESS;
781: RETURN;
782: END IF;
783:
784: FOR org in get_common_orgs(p_src_bill_seq_id)

Line 788: x_return_status := FND_API.G_RET_STS_ERROR;

784: FOR org in get_common_orgs(p_src_bill_seq_id)
785: LOOP
786: IF get_rev_id_for_local_org(l_comp_rev_id, org.organization_id) IS NULL
787: THEN
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: RETURN;
790: END IF;
791: END LOOP;
792: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 792: x_return_status := FND_API.G_RET_STS_SUCCESS;

788: x_return_status := FND_API.G_RET_STS_ERROR;
789: RETURN;
790: END IF;
791: END LOOP;
792: x_return_status := FND_API.G_RET_STS_SUCCESS;
793: END;
794:
795:
796:

Line 867: x_Return_Status := FND_API.G_RET_STS_ERROR;

863: where bill_sequence_id = p_dest_bill_sequence_id;
864:
865: IF l_effectivity_ctrl in (2,3,4)
866: THEN
867: x_Return_Status := FND_API.G_RET_STS_ERROR;
868: --arudresh_debug('adding error token');
869: Error_Handler.Add_Error_Token
870: (p_Message_Name => 'BOM_EDIT_COMM_INVALID_EFF'
871: -- , p_Message_Text => NULL

Line 879: (p_error_status => FND_API.G_RET_STS_ERROR

875: );
876: fnd_message.set_name('BOM', 'BOM_EDIT_COMM_INVALID_EFF');
877: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
878: /*Error_Handler.Log_Error
879: (p_error_status => FND_API.G_RET_STS_ERROR
880: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
881: , p_error_scope => Error_Handler.G_SCOPE_RECORD
882: , p_error_level => Error_Handler.G_BH_LEVEL
883: , x_bom_header_rec => Bom_Bo_Pub.G_MISS_BOM_HEADER_REC

Line 899: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS

895: , p_assembly_item_id => l_assy_item_id
896: , p_organization_id => l_dest_org_id
897: , p_alt_desg => l_alt_bom_desg
898: , x_Return_Status => x_Return_Status);
899: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS
900: THEN
901: fnd_message.set_name('BOM', 'BOM_COMM_OP_SEQ_INVALID');
902: return;
903: END IF;

Line 1133: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS

1129: --DOnt copy the structure header user attrs
1130: Replicate_Comp_User_Attrs(p_src_bill_seq_id => p_src_bill_sequence_id,
1131: p_dest_bill_seq_id => p_dest_bill_sequence_id,
1132: x_Return_Status => x_Return_Status);
1133: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS
1134: THEN
1135: return;
1136: END IF;
1137: END IF; /*IF l_src_str_type = l_str_type*/

Line 1168: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS

1164: END IF;
1165: Replicate_Ref_Desg(p_component_sequence_id => comp_rec.component_sequence_id
1166: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
1167: , x_Return_Status => x_Return_Status);
1168: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS
1169: THEN
1170: return;
1171: END IF;
1172: Replicate_Sub_Comp(p_component_sequence_id => comp_rec.component_sequence_id

Line 1175: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS

1171: END IF;
1172: Replicate_Sub_Comp(p_component_sequence_id => comp_rec.component_sequence_id
1173: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
1174: , x_Return_Status => x_Return_Status);
1175: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS
1176: THEN
1177: return;
1178: END IF;
1179: Replicate_Comp_Ops(p_component_sequence_id => comp_rec.component_sequence_id

Line 1183: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS

1179: Replicate_Comp_Ops(p_component_sequence_id => comp_rec.component_sequence_id
1180: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
1181: , x_Return_Status => x_Return_Status);
1182:
1183: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS
1184: THEN
1185: return;
1186: END IF;
1187:

Line 1189: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

1185: return;
1186: END IF;
1187:
1188: end loop; /*FOR comp_rec in get_source_components(p_src_bill_sequence_id) */
1189: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1190:
1191: EXCEPTION
1192:
1193: WHEN OTHERS THEN

Line 1209: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1205: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1206: END IF;
1207: --arudresh_debug('Error in replicate component'||SQLERRM);
1208: fnd_message.set_name('BOM', 'BOM_REPLICATE_FAILED');
1209: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1210:
1211: END Replicate_Components;
1212:
1213:

Line 1230: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS

1226: Replicate_Components (p_src_bill_sequence_id => p_src_bill_sequence_id
1227: , p_dest_bill_sequence_id => p_dest_bill_sequence_id
1228: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1229: , x_Return_Status => l_Return_Status);
1230: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS
1231: THEN
1232: app_exception.raise_exception;
1233: END IF;
1234: END Replicate_Components;

Line 1309: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS

1305: Check_Comp_Fixed_Rev_Dtls(p_src_bill_seq_id => p_src_bill_seq_id
1306: , p_src_comp_seq_id => p_src_comp_seq_id
1307: , x_return_status => x_return_status);
1308:
1309: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS
1310: THEN
1311:
1312: SELECT concatenated_segments
1313: into l_comp_name

Line 1329: x_Return_Status := FND_API.G_RET_STS_ERROR;

1325: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1326: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1327: , p_Token_Tbl => l_token_tbl
1328: );
1329: x_Return_Status := FND_API.G_RET_STS_ERROR;
1330: fnd_message.set_name('BOM', 'BOM_FIXED_REV_NOT_ALLOWED');
1331: RETURN;
1332:
1333: END IF;

Line 1344: x_Return_Status := FND_API.G_RET_STS_ERROR;

1340: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1341: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1342: , p_Token_Tbl => l_token_tbl
1343: );
1344: x_Return_Status := FND_API.G_RET_STS_ERROR;
1345: fnd_message.set_name('BOM', 'BOM_COMMON_OP_SEQ_INVALID');
1346: RETURN;
1347: END IF;
1348:

Line 1469: , DECODE(src_comp_details.supply_locator_id, FND_API.G_MISS_NUM,

1465: , src_comp_details.HIGH_QUANTITY
1466: , src_comp_details.component_sequence_id
1467: , BOM_Globals.Get_Prog_AppId
1468: , src_comp_details.wip_supply_type
1469: , DECODE(src_comp_details.supply_locator_id, FND_API.G_MISS_NUM,
1470: NULL, src_comp_details.supply_locator_id)
1471: , src_comp_details.bom_item_type
1472: , src_comp_details.operation_seq_num --Check this too
1473: , src_comp_details.component_item_id

Line 1479: , DECODE(src_comp_details.ITEM_NUM, FND_API.G_MISS_NUM,

1475: , src_comp_details.last_updated_by /* Last Updated By */
1476: , SYSDATE /* Creation Date */
1477: , src_comp_details.created_by /* Created By */
1478: , src_comp_details.last_update_login /* Last Update Login */
1479: , DECODE(src_comp_details.ITEM_NUM, FND_API.G_MISS_NUM,
1480: 1, NULL,1,src_comp_details.ITEM_NUM)
1481: , src_comp_details.component_quantity
1482: , src_comp_details.COMPONENT_YIELD_FACTOR
1483: , src_comp_details.COMPONENT_REMARKS

Line 1525: -- , FND_API.G_MISS_NUM

1521: , NULL /* Include On Bill Docs */
1522: , src_comp_details.low_quantity
1523: , src_comp_details.acd_type
1524: -- , DECODE( p_rev_comp_Unexp_rec.old_component_sequence_id
1525: -- , FND_API.G_MISS_NUM
1526: -- , NULL
1527: -- ,p_rev_comp_Unexp_rec.old_component_sequence_id
1528: -- )
1529: , l_old_component_sequence_id --Chk this

Line 1537: , FND_API.G_MISS_CHAR

1533: , SYSDATE /* program_update_date */
1534: , src_comp_details.pick_components
1535: , src_comp_details.original_system_reference
1536: , DECODE( src_comp_details.from_end_item_unit_number
1537: , FND_API.G_MISS_CHAR
1538: , null
1539: , src_comp_details.from_end_item_unit_number
1540: )
1541: , DECODE( src_comp_details.to_end_item_unit_number

Line 1542: , FND_API.G_MISS_CHAR

1538: , null
1539: , src_comp_details.from_end_item_unit_number
1540: )
1541: , DECODE( src_comp_details.to_end_item_unit_number
1542: , FND_API.G_MISS_CHAR
1543: , null
1544: , src_comp_details.to_end_item_unit_number
1545: )
1546: , BOM_Globals.Get_Eco_For_Production

Line 1599: x_Return_Status := FND_API.G_RET_STS_ERROR;

1595: , p_rev_item_seq_id => src_comp_details.revised_item_sequence_id
1596: , p_src_bill_seq_id => bill_rec.source_bill_sequence_id
1597: )
1598: THEN --overlap exists
1599: x_Return_Status := FND_API.G_RET_STS_ERROR;
1600: SELECT concatenated_segments
1601: into l_comp_name
1602: from mtl_system_items_kfv
1603: where inventory_item_id = src_comp_details.component_item_id

Line 1651: x_Return_Status := FND_API.G_RET_STS_ERROR;

1647: AND basis_type = 2
1648: AND component_sequence_id = src_comp_details.component_sequence_id;
1649:
1650: --If such record exists, raise an error
1651: x_Return_Status := FND_API.G_RET_STS_ERROR;
1652:
1653: SELECT concatenated_segments
1654: into l_comp_name
1655: from mtl_system_items_kfv

Line 1699: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS

1695: NULL;
1696: END;
1697: /*Propagate_Comp_User_Attributes(p_src_comp_seq_id => src_comp_details.common_component_sequence_id,
1698: x_Return_Status => x_Return_Status);*/
1699: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS
1700: THEN
1701: return;
1702: END IF;
1703: end loop; --for src_comp_details in get_src_comp_details(p_src_comp_seq_id)

Line 1706: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

1702: END IF;
1703: end loop; --for src_comp_details in get_src_comp_details(p_src_comp_seq_id)
1704: end loop; --for bill_rec in get_related_bills(p_src_bill_seq_id)
1705:
1706: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1707:
1708: EXCEPTION
1709: WHEN OTHERS THEN
1710: --dbms_output.put_line(' SQL Error '||SQLERRM);

Line 1726: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1722: );
1723: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1724: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1725: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
1726: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1727:
1728: END Insert_Related_Components;
1729:
1730:

Line 1748: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS

1744: Insert_Related_Components(p_src_bill_seq_id => p_src_bill_seq_id
1745: , p_src_comp_seq_id => p_src_comp_seq_id
1746: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1747: , x_Return_Status => l_Return_Status);
1748: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS
1749: THEN
1750: app_exception.raise_exception;
1751: END IF;
1752:

Line 1796: (p_rev_component_rec.new_operation_sequence_number =FND_API.G_MISS_NUM) ) THEN

1792:
1793: /* need to populate Operation Lead Time percent corresponding to the operation
1794: -vhymavat bug3537394 */
1795: /*IF((p_rev_component_rec.new_operation_sequence_number IS NULL) OR
1796: (p_rev_component_rec.new_operation_sequence_number =FND_API.G_MISS_NUM) ) THEN
1797: l_operation_seq_num := p_rev_component_rec.operation_sequence_number;
1798:
1799: ELSE
1800: l_operation_seq_num :=p_rev_component_rec.new_operation_sequence_number;

Line 1825: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS

1821: Check_Comp_Fixed_Rev_Dtls(p_src_bill_seq_id => src_comp.bill_sequence_id
1822: , p_src_comp_seq_id => src_comp.component_sequence_id
1823: , x_return_status => x_return_status);
1824:
1825: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS
1826: THEN
1827:
1828: SELECT concatenated_segments
1829: into l_comp_name

Line 1845: x_Return_Status := FND_API.G_RET_STS_ERROR;

1841: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1842: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1843: , p_Token_Tbl => l_token_tbl
1844: );
1845: x_Return_Status := FND_API.G_RET_STS_ERROR;
1846: fnd_message.set_name('BOM', 'BOM_FIXED_REV_NOT_ALLOWED');
1847: fnd_message.set_token('COMP_NAME', l_comp_name, true);
1848: RETURN;
1849:

Line 1859: DECODE(p_rev_comp_Unexp_rec.supply_locator_id, FND_API.G_MISS_NUM,

1855: SET REQUIRED_FOR_REVENUE = src_comp.required_for_revenue
1856: , HIGH_QUANTITY = src_comp.HIGH_QUANTITY
1857: /* , WIP_SUPPLY_TYPE = p_rev_component_rec.wip_supply_type
1858: , SUPPLY_LOCATOR_ID =
1859: DECODE(p_rev_comp_Unexp_rec.supply_locator_id, FND_API.G_MISS_NUM,
1860: NULL, p_rev_comp_Unexp_rec.supply_locator_id)
1861: , OPERATION_SEQ_NUM = l_operation_seq_num*/
1862: , EFFECTIVITY_DATE = src_comp.effectivity_date
1863: , LAST_UPDATE_DATE = SYSDATE

Line 1940: x_Return_Status := FND_API.G_RET_STS_ERROR;

1936: , p_rev_item_seq_id => dest_comp.revised_item_Sequence_id
1937: , p_src_bill_seq_id => src_comp.bill_sequence_id
1938: )
1939: THEN --overlap exists
1940: x_Return_Status := FND_API.G_RET_STS_ERROR;
1941:
1942: SELECT Organization_id
1943: INTO l_dest_org_id
1944: FROM BOM_STRUCTURES_B

Line 2004: x_Return_Status := FND_API.G_RET_STS_ERROR;

2000: AND basis_type = 2
2001: AND component_sequence_id = dest_comp.component_sequence_id;
2002:
2003: --If such record exists, raise an error
2004: x_Return_Status := FND_API.G_RET_STS_ERROR;
2005:
2006: SELECT Organization_id
2007: INTO l_dest_org_id
2008: FROM BOM_STRUCTURES_B

Line 2076: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

2072: AND bill_sequence_id NOT IN (SELECT bill_sequence_id
2073: FROM eng_revised_items
2074: WHERE change_notice = bic.change_notice);
2075:
2076: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2077:
2078: EXCEPTION
2079:
2080: WHEN OTHERS THEN

Line 2094: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2090: );
2091: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2092: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2093: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
2094: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2095: END Update_Related_Components;
2096:
2097:
2098:

Line 2112: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS

2108: BEGIN
2109: Update_Related_Components( p_src_comp_seq_id => p_src_comp_seq_id
2110: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2111: , x_Return_Status => l_Return_Status);
2112: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS
2113: THEN
2114: app_exception.raise_exception;
2115: END IF;
2116: END Update_Related_Components;

Line 2177: , FND_API.G_MISS_CHAR

2173: , SYSDATE
2174: , ref_desg.CREATED_BY
2175: , ref_desg.LAST_UPDATE_LOGIN
2176: , DECODE( ref_desg.ref_designator_comment
2177: , FND_API.G_MISS_CHAR
2178: , NULL
2179: , ref_desg.ref_designator_comment )
2180: , ref_desg.change_notice
2181: , comp.component_sequence_id

Line 2219: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

2215: )
2216: ;
2217: /*insert into bom_reference_designators()
2218: values();*/
2219: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2220: EXCEPTION
2221: WHEN OTHERS THEN
2222: --dbms_output.put_line(' Error '||SQLERRM);
2223: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2237: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2233: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2234: END IF;
2235: fnd_message.set_name('BOM', 'BOM_REPLICATE_FAILED');
2236: --arudresh_debug('error in replicate ref desg'||SQLERRM);
2237: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2238: END Replicate_Ref_Desg;
2239:
2240:
2241: /*

Line 2254: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS

2250: BEGIN
2251: Replicate_Ref_Desg(p_component_sequence_id => p_component_sequence_id
2252: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2253: , x_Return_Status => l_Return_Status);
2254: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS
2255: THEN
2256: app_exception.raise_exception;
2257: END IF;
2258: END;

Line 2347: , FND_API.G_MISS_CHAR

2343: , SYSDATE
2344: , ref_desg.CREATED_BY
2345: , ref_desg.LAST_UPDATE_LOGIN
2346: , DECODE( ref_desg.ref_designator_comment
2347: , FND_API.G_MISS_CHAR
2348: , NULL
2349: , ref_desg.ref_designator_comment )
2350: , ref_desg.Change_Notice
2351: , dest_comp.component_sequence_id

Line 2378: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

2374: , ref_desg.component_sequence_id
2375: );
2376: end loop;--for dest_comp in get_destn_comps(p_component_sequence_id)
2377: end loop;--for ref_desg in get_ref_desg_details(p_component_sequence_id, p_ref_desg)
2378: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2379: EXCEPTION
2380: WHEN OTHERS THEN
2381: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2382: THEN

Line 2394: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2390: );
2391: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2392: END IF;
2393: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
2394: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2395:
2396: END Insert_Related_Ref_Desg;
2397:
2398:

Line 2415: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS

2411: Insert_Related_Ref_Desg(p_component_sequence_id => p_component_sequence_id
2412: , p_ref_desg => p_ref_desg
2413: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2414: , x_Return_Status => l_Return_Status);
2415: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS
2416: THEN
2417: app_exception.raise_exception;
2418: END IF;
2419: END Insert_Related_Ref_Desg;

Line 2491: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

2487: AND NVL(ACD_TYPE, 0) = nvl(p_acd_type, 0);
2488: --end loop; --for dest_comp in get_destn_comps(p_component_sequence_id)
2489: end loop; --for ref_desg in get_ref_desg_details(p_component_sequence_id, p_ref_desg)
2490:
2491: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2492:
2493: EXCEPTION
2494: WHEN OTHERS THEN
2495:

Line 2498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2494: WHEN OTHERS THEN
2495:
2496: /*IF G_CONTROL_REC.caller_type = 'FORM'
2497: THEN
2498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2499: RAISE;
2500: END IF;*/
2501: Error_Handler.Add_Error_Token
2502: ( p_Message_Name => NULL

Line 2510: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2506: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2507: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl);
2508:
2509: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
2510: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2511:
2512:
2513: END Update_Related_Ref_Desg;
2514:

Line 2536: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS

2532: , p_old_ref_desg => p_old_ref_desg
2533: , p_acd_type => p_acd_type
2534: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2535: , x_Return_Status => l_Return_Status);
2536: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS
2537: THEN
2538: app_exception.raise_exception;
2539: END IF;
2540: END;

Line 2653: x_return_status := FND_API.G_RET_STS_SUCCESS;

2649: and bsc2.substitute_component_id = sub_comp.substitute_component_id
2650: )
2651: ;
2652:
2653: x_return_status := FND_API.G_RET_STS_SUCCESS;
2654:
2655: EXCEPTION
2656:
2657: WHEN OTHERS THEN

Line 2672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2668: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2669: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2670: fnd_message.set_name('BOM', 'BOM_REPLICATE_FAILED');
2671: --arudresh_debug('error in replicate sub comp '||SQLERRM);
2672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2673: END Replicate_Sub_Comp;
2674:
2675: /*
2676: * This overloaded Procedure is called from Java to replicate the substitutes of components of the source BOM

Line 2688: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS

2684: BEGIN
2685: Replicate_Sub_Comp(p_component_sequence_id => p_component_sequence_id
2686: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2687: , x_Return_Status => l_Return_Status);
2688: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS
2689: THEN
2690: app_exception.raise_exception;
2691: END IF;
2692: END;

Line 2814: x_return_status := FND_API.G_RET_STS_SUCCESS;

2810: );
2811:
2812: end loop; --for dest_comp in get_destn_comps(p_component_sequence_id)
2813: end loop;--for sub_comp in get_sub_comp_details(p_component_sequence_id, p_sub_comp_item_id)
2814: x_return_status := FND_API.G_RET_STS_SUCCESS;
2815:
2816: EXCEPTION
2817:
2818: WHEN OTHERS THEN

Line 2832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2828: );
2829: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2830: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2831: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
2832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2833: END Insert_Related_Sub_Comp;
2834:
2835:
2836:

Line 2853: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS

2849: Insert_Related_Sub_Comp(p_component_sequence_id => p_component_sequence_id
2850: , p_sub_comp_item_id => p_sub_comp_item_id
2851: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2852: , x_Return_Status => l_Return_Status);
2853: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS
2854: THEN
2855: app_exception.raise_exception;
2856: END IF;
2857: end;

Line 2931: x_return_status := FND_API.G_RET_STS_SUCCESS;

2927: AND nvl(ACD_TYPE,0) = nvl(p_acd_type, 0)
2928: ;
2929: --end loop;--for dest_comp in get_destn_comps(p_component_sequence_id)
2930: end loop; --for sub_comp in get_sub_comp_details(p_component_sequence_id, p_sub_comp_item_id)
2931: x_return_status := FND_API.G_RET_STS_SUCCESS;
2932: EXCEPTION
2933:
2934: WHEN OTHERS THEN
2935: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2944: );
2945: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2946: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
2947: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
2948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2949: END Update_Related_Sub_Comp;
2950:
2951: /*
2952: * This overloaded Procedure is called from Java to update substitutes of the related components of the common boms whenever

Line 2971: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS

2967: , p_new_sub_comp_item_id => p_new_sub_comp_item_id
2968: , p_acd_type => p_acd_type
2969: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2970: , x_Return_Status => l_Return_Status);
2971: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS
2972: THEN
2973: app_exception.raise_exception;
2974: END IF;
2975: END;

Line 3022: x_return_status := FND_API.G_RET_STS_SUCCESS;

3018: WHERE component_sequence_id = p_component_sequence_id;
3019: EXCEPTION
3020: WHEN NO_DATA_FOUND THEN
3021: --No comp ops to replicate, return
3022: x_return_status := FND_API.G_RET_STS_SUCCESS;
3023: Return;
3024: WHEN TOO_MANY_ROWS THEN
3025: --Continue with validations
3026: Null;

Line 3060: x_return_status := FND_API.G_RET_STS_ERROR;

3056: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3057: , p_Token_Tbl => l_Token_Tbl
3058: );
3059: fnd_message.set_name('BOM', 'BOM_COMMON_OP_SEQ_INVALID');
3060: x_return_status := FND_API.G_RET_STS_ERROR;
3061: Return;
3062: WHEN TOO_MANY_ROWS THEN
3063: --Means just that more than one comp opn is associated with the comp.
3064: NULL;

Line 3137: x_return_status := FND_API.G_RET_STS_SUCCESS;

3133: where ops2.component_sequence_id = dest_comp.component_sequence_id
3134: )
3135: ;
3136:
3137: x_return_status := FND_API.G_RET_STS_SUCCESS;
3138:
3139: EXCEPTION
3140:
3141: WHEN OTHERS THEN

Line 3155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3151: );
3152: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3153: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
3154: fnd_message.set_name('BOM', 'BOM_REPLICATE_FAILED');
3155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3156: END Replicate_Comp_Ops;
3157:
3158:
3159: /*

Line 3172: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS

3168: BEGIN
3169: Replicate_Comp_Ops(p_component_sequence_id => p_component_sequence_id
3170: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3171: , x_Return_Status => l_Return_Status);
3172: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS
3173: THEN
3174: app_exception.raise_exception;
3175: END IF;
3176: END;

Line 3277: x_return_status := FND_API.G_RET_STS_SUCCESS;

3273: comp_ops.component_sequence_id
3274: );
3275: end loop; --for dest_comp in get_destn_comps(p_component_sequence_id)
3276: end loop; --for comp_ops in get_comp_op_details(p_component_sequence_id, p_comp_operation_seq_id)
3277: x_return_status := FND_API.G_RET_STS_SUCCESS;
3278:
3279: EXCEPTION
3280:
3281: WHEN OTHERS THEN

Line 3295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3291: );
3292: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3293: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
3294: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
3295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3296: END Insert_Related_Comp_Ops;
3297:
3298:
3299:

Line 3316: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS

3312: Insert_Related_Comp_Ops(p_component_sequence_id => p_component_sequence_id
3313: , p_operation_seq_num => p_operation_seq_num
3314: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3315: , x_Return_Status => l_Return_Status);
3316: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS
3317: THEN
3318: app_exception.raise_exception;
3319: END IF;
3320: end;

Line 3394: x_return_status := FND_API.G_RET_STS_SUCCESS;

3390: AND COMMON_COMPONENT_SEQUENCE_ID <> COMPONENT_SEQUENCE_ID
3391: ;
3392: --end loop; --for dest_comp in get_destn_comps(p_component_sequence_id)
3393: end loop; --for comp_ops in get_comp_op_details(p_component_sequence_id, p_comp_operation_seq_id)
3394: x_return_status := FND_API.G_RET_STS_SUCCESS;
3395: EXCEPTION
3396:
3397: WHEN OTHERS THEN
3398: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3407: );
3408: END IF; --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3409: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
3410: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
3411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3412: END Update_Related_Comp_Ops;
3413:
3414: /*
3415: * This overloaded Procedure is called from Java to update Component Operations of the common boms whenever

Line 3433: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS

3429: , p_old_operation_seq_num => p_old_operation_seq_num
3430: , p_new_operation_seq_num => p_new_operation_seq_num
3431: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3432: , x_Return_Status => l_Return_Status);
3433: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS
3434: THEN
3435: app_exception.raise_exception;
3436: END IF;
3437: END;

Line 3456: x_return_status := FND_API.G_RET_STS_SUCCESS;

3452: BEGIN
3453: DELETE FROM BOM_COMPONENT_OPERATIONS
3454: WHERE COMMON_COMPONENT_SEQUENCE_ID = p_src_comp_seq_id
3455: AND OPERATION_SEQ_NUM = p_operation_seq_num;
3456: x_return_status := FND_API.G_RET_STS_SUCCESS;
3457: EXCEPTION
3458: WHEN OTHERS THEN
3459: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
3460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3456: x_return_status := FND_API.G_RET_STS_SUCCESS;
3457: EXCEPTION
3458: WHEN OTHERS THEN
3459: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
3460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3461: END;
3462:
3463:
3464: /*

Line 3594: x_return_status := FND_API.G_RET_STS_ERROR;

3590: EXIT When not valid_op_seq;
3591: end loop; --for src_op_seq in get_src_op_seq(p_src_bill_sequence_id)
3592:
3593: if not valid_op_seq then
3594: x_return_status := FND_API.G_RET_STS_ERROR;
3595: else
3596: x_return_status := FND_API.G_RET_STS_SUCCESS;
3597: end if; --if not valid_op_seq
3598: EXCEPTION

Line 3596: x_return_status := FND_API.G_RET_STS_SUCCESS;

3592:
3593: if not valid_op_seq then
3594: x_return_status := FND_API.G_RET_STS_ERROR;
3595: else
3596: x_return_status := FND_API.G_RET_STS_SUCCESS;
3597: end if; --if not valid_op_seq
3598: EXCEPTION
3599: WHEN NO_DATA_FOUND THEN
3600: --Source bill doesnt have a rtg. No validation reqd.

Line 3601: x_return_status := FND_API.G_RET_STS_SUCCESS;

3597: end if; --if not valid_op_seq
3598: EXCEPTION
3599: WHEN NO_DATA_FOUND THEN
3600: --Source bill doesnt have a rtg. No validation reqd.
3601: x_return_status := FND_API.G_RET_STS_SUCCESS;
3602: RETURN;
3603: WHEN TOO_MANY_ROWS THEN
3604: NULL;
3605: END;

Line 3675: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS

3671: ,x_errorcode => l_errorcode
3672: ,x_msg_count => l_msg_count
3673: ,x_msg_data => l_msg_data
3674: );
3675: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS
3676: THEN
3677: fnd_message.set_name('BOM', 'BOM_REPLICATE_FAILED');
3678: return;
3679: END IF;

Line 3781: ,p_commit => FND_API.G_TRUE

3777: p_api_version => 1.0
3778: ,p_object_name => 'BOM_COMPONENTS'
3779: ,p_pk_column_name_value_pairs => l_src_pk_col_name_val_pairs
3780: ,p_attr_group_request_table => l_attr_group_request_table
3781: ,p_commit => FND_API.G_TRUE
3782: ,x_attributes_row_table => l_attributes_row_table
3783: ,x_attributes_data_table => l_attributes_data_table
3784: ,x_return_status => x_return_status
3785: ,x_errorcode => l_errorcode

Line 3789: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

3785: ,x_errorcode => l_errorcode
3786: ,x_msg_count => l_msg_count
3787: ,x_msg_data => l_msg_data
3788: );
3789: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3790: THEN
3791: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
3792: Return;
3793: END IF;

Line 3833: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

3829: ,x_errorcode => l_errorcode
3830: ,x_msg_count => l_msg_count
3831: ,x_msg_data => l_msg_data
3832: );
3833: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3834: THEN
3835: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
3836: Return;
3837: END IF;

Line 3971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3967: AND COMPONENT_REFERENCE_DESIGNATOR = p_ref_desg;
3968: EXCEPTION
3969: WHEN OTHERS THEN
3970: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
3971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3972: END;
3973:
3974: /*
3975: * This Procedure is used to delete related sub comps from the referencing boms when sub comps

Line 3991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3987: AND SUBSTITUTE_COMPONENT_ID = p_sub_comp_item_id;
3988: EXCEPTION
3989: WHEN OTHERS THEN
3990: fnd_message.set_name('BOM', 'BOM_PROPAGATE_FAILED');
3991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3992: END;
3993:
3994:
3995: /*

Line 4124: x_Return_Status := FND_API.G_RET_STS_ERROR;

4120: where component_sequence_id = p_src_comp_seq_id;
4121:
4122: IF l_impl_date IS NOT NULL
4123: THEN
4124: x_Return_Status := FND_API.G_RET_STS_ERROR;
4125: RETURN;
4126: END IF;
4127: */
4128: --Commented

Line 4141: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

4137:
4138: DELETE BOM_COMPONENT_OPERATIONS
4139: WHERE common_component_sequence_id = p_src_comp_seq_id;
4140:
4141: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
4142:
4143: EXCEPTION
4144:
4145: WHEN OTHERS THEN

Line 4146: x_Return_Status := FND_API.G_RET_STS_ERROR;

4142:
4143: EXCEPTION
4144:
4145: WHEN OTHERS THEN
4146: x_Return_Status := FND_API.G_RET_STS_ERROR;
4147: app_exception.raise_exception;
4148:
4149: END;
4150:

Line 4233: x_return_status := FND_API.G_RET_STS_SUCCESS;

4229: BEGIN
4230: --
4231: -- Initialize
4232: --
4233: x_return_status := FND_API.G_RET_STS_SUCCESS;
4234: l_old_rev_item_seq_id := NULL;
4235:
4236: Eng_globals.Init_System_Info_Rec
4237: ( x_mesg_token_tbl => l_mesg_token_tbl

Line 4274: l_return_status := FND_API.G_RET_STS_ERROR;

4270: --, OUT l_Mesg_Token_Tbl
4271: , OUT l_return_status;
4272: EXCEPTION
4273: WHEN OTHERS THEN
4274: l_return_status := FND_API.G_RET_STS_ERROR;
4275: END;
4276: END IF;
4277: IF (l_return_status = 'S')
4278: THEN

Line 4464: x_return_status := FND_API.G_RET_STS_ERROR;

4460: --, l_comp_revision_id
4461: --, l_comp_minor_revision_id
4462: );
4463: ELSE
4464: x_return_status := FND_API.G_RET_STS_ERROR;
4465: RETURN;
4466: END IF;
4467: END LOOP;
4468: END LOOP;

Line 4472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4468: END LOOP;
4469: x_return_status := l_return_status;
4470: EXCEPTION
4471: WHEN OTHERS THEN
4472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4473: END Copy_Pending_Dest_Components;
4474:
4475:
4476:

Line 4505: x_return_status := FND_API.G_RET_STS_ERROR;

4501: AND source.revision = dest.revision;
4502:
4503: IF l_comp_count <> l_rev_count
4504: THEN
4505: x_return_status := FND_API.G_RET_STS_ERROR;
4506: RETURN;
4507: END IF;
4508: END IF;
4509:

Line 4510: x_return_status := FND_API.G_RET_STS_SUCCESS;

4506: RETURN;
4507: END IF;
4508: END IF;
4509:
4510: x_return_status := FND_API.G_RET_STS_SUCCESS;
4511: END;
4512:
4513:
4514:

Line 4559: RETURN FND_API.G_RET_STS_ERROR;

4555: FOR org IN get_orgs
4556: LOOP
4557: IF get_rev_id_for_local_org(p_rev_id => p_rev_id, p_org_id => org.organization_id) IS NULL
4558: THEN
4559: RETURN FND_API.G_RET_STS_ERROR;
4560: END IF;
4561: END LOOP;
4562: RETURN FND_API.G_RET_STS_SUCCESS;
4563: END;

Line 4562: RETURN FND_API.G_RET_STS_SUCCESS;

4558: THEN
4559: RETURN FND_API.G_RET_STS_ERROR;
4560: END IF;
4561: END LOOP;
4562: RETURN FND_API.G_RET_STS_SUCCESS;
4563: END;
4564:
4565: END bompcmbm ;