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

Line 182: xReturnStatus := FND_API.G_RET_STS_SUCCESS;

178: BEGIN
179:
180:
181:
182: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
183:
184:
185:
186: select count(*) into v_bcol_count from bom_cto_order_lines

Line 217: if( xReturnStatus = FND_API.G_RET_STS_ERROR ) then

213:
214: /* BUG #1957336 Change for preconfigure bom by Sushant Sawant */
215: /* Sushant corrected this implementation */
216:
217: if( xReturnStatus = FND_API.G_RET_STS_ERROR ) then
218: RAISE FND_API.G_EXC_ERROR ;
219:
220: elsif( xReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR ) then
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 218: RAISE FND_API.G_EXC_ERROR ;

214: /* BUG #1957336 Change for preconfigure bom by Sushant Sawant */
215: /* Sushant corrected this implementation */
216:
217: if( xReturnStatus = FND_API.G_RET_STS_ERROR ) then
218: RAISE FND_API.G_EXC_ERROR ;
219:
220: elsif( xReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR ) then
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
222:

Line 220: elsif( xReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR ) then

216:
217: if( xReturnStatus = FND_API.G_RET_STS_ERROR ) then
218: RAISE FND_API.G_EXC_ERROR ;
219:
220: elsif( xReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR ) then
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
222:
223: end if ;
224:

Line 221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

217: if( xReturnStatus = FND_API.G_RET_STS_ERROR ) then
218: RAISE FND_API.G_EXC_ERROR ;
219:
220: elsif( xReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR ) then
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
222:
223: end if ;
224:
225: end loop;

Line 258: WHEN fnd_api.g_exc_error THEN

254:
255:
256: EXCEPTION
257:
258: WHEN fnd_api.g_exc_error THEN
259: xReturnStatus := fnd_api.g_ret_sts_error;
260: -- Get message count and data
261: if( xMsgData is null ) then
262: cto_msg_pub.count_and_get

Line 259: xReturnStatus := fnd_api.g_ret_sts_error;

255:
256: EXCEPTION
257:
258: WHEN fnd_api.g_exc_error THEN
259: xReturnStatus := fnd_api.g_ret_sts_error;
260: -- Get message count and data
261: if( xMsgData is null ) then
262: cto_msg_pub.count_and_get
263: ( p_msg_count => xMsgCount

Line 272: WHEN fnd_api.g_exc_unexpected_error THEN

268: IF PG_DEBUG <> 0 THEN
269: oe_debug_pub.add('create_all_boms_and_routings: ' || xMsgData , 1);
270: END IF;
271:
272: WHEN fnd_api.g_exc_unexpected_error THEN
273: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;
274: -- Get message count and data
275: cto_msg_pub.count_and_get
276: ( p_msg_count => xMsgCount

Line 273: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;

269: oe_debug_pub.add('create_all_boms_and_routings: ' || xMsgData , 1);
270: END IF;
271:
272: WHEN fnd_api.g_exc_unexpected_error THEN
273: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;
274: -- Get message count and data
275: cto_msg_pub.count_and_get
276: ( p_msg_count => xMsgCount
277: , p_msg_data => xMsgData

Line 284: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

280: WHEN OTHERS then
281: IF PG_DEBUG <> 0 THEN
282: oe_debug_pub.add('create_all_boms_and_routings: ' || 'create_all_boms_and_routings::others::'||'::'||sqlerrm, 1);
283: END IF;
284: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
285: -- Get message count and data
286: cto_msg_pub.count_and_get
287: ( p_msg_count => xMsgCount
288: , p_msg_data => xMsgData

Line 315: x_return_status := FND_API.G_RET_STS_SUCCESS;

311: x_return_status OUT NOCOPY varchar2) is
312:
313: Begin
314:
315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316:
317: select ato_line_id, header_id
318: into x_ato_line_id, x_header_id
319: from bom_cto_order_lines

Line 328: when FND_API.G_EXC_ERROR THEN

324: END IF;
325:
326: Exception
327:
328: when FND_API.G_EXC_ERROR THEN
329: IF PG_DEBUG <> 0 THEN
330: oe_debug_pub.add('get_ato_line_id: ' || 'expected error: ' || sqlerrm, 1);
331: END IF;
332: x_return_status := FND_API.G_RET_STS_ERROR;

Line 332: x_return_status := FND_API.G_RET_STS_ERROR;

328: when FND_API.G_EXC_ERROR THEN
329: IF PG_DEBUG <> 0 THEN
330: oe_debug_pub.add('get_ato_line_id: ' || 'expected error: ' || sqlerrm, 1);
331: END IF;
332: x_return_status := FND_API.G_RET_STS_ERROR;
333:
334: when FND_API.G_EXC_UNEXPECTED_ERROR then
335: IF PG_DEBUG <> 0 THEN
336: oe_debug_pub.add('get_ato_line_id: ' || 'unexpected error: ' || sqlerrm, 1);

Line 334: when FND_API.G_EXC_UNEXPECTED_ERROR then

330: oe_debug_pub.add('get_ato_line_id: ' || 'expected error: ' || sqlerrm, 1);
331: END IF;
332: x_return_status := FND_API.G_RET_STS_ERROR;
333:
334: when FND_API.G_EXC_UNEXPECTED_ERROR then
335: IF PG_DEBUG <> 0 THEN
336: oe_debug_pub.add('get_ato_line_id: ' || 'unexpected error: ' || sqlerrm, 1);
337: END IF;
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

334: when FND_API.G_EXC_UNEXPECTED_ERROR then
335: IF PG_DEBUG <> 0 THEN
336: oe_debug_pub.add('get_ato_line_id: ' || 'unexpected error: ' || sqlerrm, 1);
337: END IF;
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339:
340: when others then
341: IF PG_DEBUG <> 0 THEN
342: oe_debug_pub.add('get_ato_line_id: ' || 'When others exception ..' || sqlerrm, 1);

Line 344: x_return_status := fnd_api.g_ret_sts_unexp_error;

340: when others then
341: IF PG_DEBUG <> 0 THEN
342: oe_debug_pub.add('get_ato_line_id: ' || 'When others exception ..' || sqlerrm, 1);
343: END IF;
344: x_return_status := fnd_api.g_ret_sts_unexp_error;
345:
346: End get_ato_line_id;
347:
348:

Line 495: xReturnStatus := fnd_api.g_ret_sts_success;

491: lplanner_code mtl_system_items_vl.planner_code%type;
492:
493: BEGIN
494:
495: xReturnStatus := fnd_api.g_ret_sts_success;
496:
497: IF PG_DEBUG <> 0 THEN
498: oe_debug_pub.add(' entered create_in_src_orgs: model ' || pModelId
499: || ' Line ' || pLineId , 1);

Line 508: if xReturnStatus <> fnd_api.g_ret_sts_success then

504: x_ato_line_id => l_ato_line_id,
505: x_header_id => l_header_id,
506: x_return_status => xReturnStatus);
507:
508: if xReturnStatus <> fnd_api.g_ret_sts_success then
509: raise fnd_api.g_exc_unexpected_error;
510: end if;
511:
512: --- Fixed bug 5485452

Line 509: raise fnd_api.g_exc_unexpected_error;

505: x_header_id => l_header_id,
506: x_return_status => xReturnStatus);
507:
508: if xReturnStatus <> fnd_api.g_ret_sts_success then
509: raise fnd_api.g_exc_unexpected_error;
510: end if;
511:
512: --- Fixed bug 5485452
513: select program_id

Line 744: raise fnd_api.g_exc_error;

740: when others then
741: IF PG_DEBUG <> 0 THEN
742: oe_debug_pub.add('Failed to insert into bom_inventory_comps_interface with error '||sqlerrm);
743: END IF;
744: raise fnd_api.g_exc_error;
745: end ;
746:
747: lStmtNum := 112;
748:

Line 792: raise FND_API.G_EXC_ERROR;

788: Exception when others then
789: IF PG_DEBUG <> 0 THEN
790: oe_debug_pub.add('create_in_src_orgs: ' || 'Failed in get_model_lead_time. ', 1);
791: END IF;
792: raise FND_API.G_EXC_ERROR;
793: End;
794:
795: If PG_DEBUG <> 0 Then
796: oe_debug_pub.add('Create_in_src_orgs: '||' Config item lead time = '||to_char(lLeadTime),1);

Line 825: raise fnd_api.g_exc_unexpected_error;

821: when no_data_found then
822: IF PG_DEBUG <> 0 THEN
823: oe_debug_pub.add('Create_in_src_orgs: ' || 'Unexpected error while computing estimated relase date',1);
824: END IF;
825: raise fnd_api.g_exc_unexpected_error;
826: end;
827:
828: If PG_DEBUG <> 0 Then
829: oe_debug_pub.add('Create_in_src_orgs: '||' Estimated Release Date = '||to_char(lEstRelDate,'mm/dd/yy:hh:mi:ss'),1);

Line 1022: raise fnd_api.g_exc_error;

1018: when others then
1019: IF PG_DEBUG <> 0 THEN
1020: oe_debug_pub.add('Others excepn from stmt '||lStmtNum ||':'||sqlerrm);
1021: END IF;
1022: raise fnd_api.g_exc_error;
1023: END ;
1024:
1025: end loop;
1026: /* Fixed by Renga Kannan for bug 5199775

Line 1059: raise fnd_api.g_exc_error;

1055:
1056: -- pop up message that model is put on hold.
1057: cto_msg_pub.cto_message('BOM','CTO_MODEL_LINE_EXCPN_HOLD');
1058:
1059: raise fnd_api.g_exc_error;
1060:
1061: end if;
1062:
1063: end if;

Line 1172: raise fnd_api.g_exc_error;

1168: CTO_CONFIG_BOM_PK.G_T_DROPPED_ITEM_TYPE(v_table_count).REQUEST_ID := to_char( fnd_global.conc_request_id ) ;
1169:
1170:
1171:
1172: raise fnd_api.g_exc_error;
1173:
1174: end if; /* lcreate_item = 1 */
1175:
1176: end if; /*mismatched_items%ROWCOUNT > 0 */

Line 1441: raise fnd_api.g_exc_error;

1437: cto_msg_pub.cto_message('BOM','CTO_MODEL_LINE_EXCPN_HOLD');
1438:
1439:
1440:
1441: raise fnd_api.g_exc_error;
1442:
1443: end if; /* create item profile condition */
1444:
1445: end if; /* missed lines cursor condition */

Line 1465: raise fnd_api.g_exc_error;

1461: when others then
1462: IF PG_DEBUG <> 0 THEN
1463: oe_debug_pub.add ('Failed in stmt ' || lStmtNum || ' with error: '||sqlerrm);
1464: END IF;
1465: raise fnd_api.g_exc_error;
1466: END ;
1467:
1468: /* Bugfix 2986192 ends here */
1469:

Line 1515: raise fnd_api.g_exc_error;

1511: if( lStatus = -1) then /* add a message for unexpected errors(-1), expected errors(0) already have a message */
1512: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_BOM_ERROR');
1513: end if;
1514:
1515: raise fnd_api.g_exc_error;
1516:
1517: end if;
1518:
1519:

Line 1561: raise fnd_api.g_exc_error;

1557: delete from bom_inventory_comps_interface
1558: where bill_sequence_id = lCfgBillId;
1559:
1560: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_ROUTING_ERROR');
1561: raise fnd_api.g_exc_error;
1562:
1563: end if;
1564:
1565:

Line 1608: raise fnd_api.g_exc_error;

1604: IF PG_DEBUG <> 0 THEN
1605: oe_debug_pub.add('added club_comp_error ' , 1) ;
1606: end if ;
1607:
1608: raise fnd_api.g_exc_error;
1609:
1610: end if;
1611:
1612: end if; -- end lCfgBillId > 0

Line 1652: raise fnd_api.g_exc_error;

1648: cto_msg_pub.cto_message('BOM','CTO_BOM_NOT_DEFINED');
1649: -- bugfix 2294708: Replaced msg CTO_CREATE_BOM_ERROR with more specific
1650: -- error CTO_BOM_NOT_DEFINED.
1651:
1652: raise fnd_api.g_exc_error;
1653:
1654:
1655:
1656:

Line 1700: raise fnd_api.g_exc_error;

1696: l_token1(1).token_name := 'MODEL_NAME';
1697: l_token1(1).token_value := v_model_item_name ;
1698:
1699: cto_msg_pub.cto_message('BOM','CTO_NO_BOM_CREATED_IN_ANY_ORGS', l_token1 ); -- Bug 3349142
1700: raise fnd_api.g_exc_error;
1701:
1702: end if ;
1703:
1704:

Line 1715: WHEN fnd_api.g_exc_error THEN

1711:
1712:
1713: EXCEPTION
1714:
1715: WHEN fnd_api.g_exc_error THEN
1716: IF PG_DEBUG <> 0 THEN
1717: oe_debug_pub.add('create_in_src_orgs: '
1718: || 'expected error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
1719: END IF;

Line 1721: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

1717: oe_debug_pub.add('create_in_src_orgs: '
1718: || 'expected error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
1719: END IF;
1720:
1721: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
1722: -- Get message count and data
1723: xReturnStatus := fnd_api.g_ret_sts_error;
1724: -- Get message count and data
1725:

Line 1723: xReturnStatus := fnd_api.g_ret_sts_error;

1719: END IF;
1720:
1721: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
1722: -- Get message count and data
1723: xReturnStatus := fnd_api.g_ret_sts_error;
1724: -- Get message count and data
1725:
1726:
1727: cto_msg_pub.count_and_get

Line 1738: WHEN fnd_api.g_exc_unexpected_error THEN

1734: oe_debug_pub.add('create_in_src_orgs: ' || xMsgCount , 1 ) ;
1735:
1736: END IF;
1737:
1738: WHEN fnd_api.g_exc_unexpected_error THEN
1739:
1740:
1741: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;
1742: -- Get message count and data

Line 1741: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;

1737:
1738: WHEN fnd_api.g_exc_unexpected_error THEN
1739:
1740:
1741: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;
1742: -- Get message count and data
1743:
1744:
1745: cto_msg_pub.count_and_get

Line 1757: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

1753: || 'create_in_src_orgs::others::'||to_char(lStmtNum)
1754: ||'::'||sqlerrm, 1);
1755: END IF;
1756:
1757: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
1758: -- Get message count and data
1759:
1760: cto_msg_pub.count_and_get
1761: ( p_msg_count => xMsgCount

Line 1975: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1971: IF PG_DEBUG <> 0 THEN
1972: oe_debug_pub.add('update_atp: ' || 'ATP returned ' || l_return_status);
1973: END IF;
1974:
1975: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1976: or l_return_status = FND_API.G_RET_STS_ERROR ) then
1977: raise atp_error;
1978: END IF;
1979: else

Line 1976: or l_return_status = FND_API.G_RET_STS_ERROR ) then

1972: oe_debug_pub.add('update_atp: ' || 'ATP returned ' || l_return_status);
1973: END IF;
1974:
1975: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1976: or l_return_status = FND_API.G_RET_STS_ERROR ) then
1977: raise atp_error;
1978: END IF;
1979: else
1980: IF PG_DEBUG <> 0 THEN

Line 2167: xReturnStatus := fnd_api.g_ret_sts_success;

2163: /* 2986190 End declaration */
2164:
2165: BEGIN
2166:
2167: xReturnStatus := fnd_api.g_ret_sts_success;
2168:
2169: -- check if model bom exists in src org
2170:
2171: lStmtNum := 10;

Line 2204: raise fnd_api.g_exc_error;

2200:
2201: exception
2202:
2203: when others then
2204: raise fnd_api.g_exc_error;
2205:
2206: end ;
2207:
2208: lStmtNum := 26;

Line 2222: raise FND_API.G_EXC_ERROR;

2218: exception
2219: when no_data_found then
2220:
2221: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
2222: raise FND_API.G_EXC_ERROR;
2223:
2224: when others then
2225:
2226: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2226: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2222: raise FND_API.G_EXC_ERROR;
2223:
2224: when others then
2225:
2226: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2227:
2228:
2229: end;
2230:

Line 2252: raise FND_API.G_EXC_ERROR;

2248: exception
2249: when no_data_found then
2250:
2251: cto_msg_pub.cto_message('BOM','CTO_BUY_COST_NOT_FOUND');
2252: raise FND_API.G_EXC_ERROR;
2253:
2254: when others then
2255:
2256: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2256: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2252: raise FND_API.G_EXC_ERROR;
2253:
2254: when others then
2255:
2256: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2257:
2258:
2259: end;
2260:

Line 2300: raise fnd_api.g_exc_error;

2296: v_cto_cost_xudc := null ;
2297:
2298: when others then
2299:
2300: raise fnd_api.g_exc_error;
2301:
2302: end ;
2303:
2304:

Line 2324: raise fnd_api.g_exc_error;

2320: v_valuation_cost := null ;
2321:
2322: when others then
2323:
2324: raise fnd_api.g_exc_error;
2325:
2326: end ;
2327:
2328:

Line 2346: raise fnd_api.g_exc_error ;

2342:
2343: exception
2344: when others then
2345:
2346: raise fnd_api.g_exc_error ;
2347:
2348: end ;
2349: end if ;
2350:

Line 2401: raise fnd_api.g_exc_error;

2397: END IF;
2398:
2399: when others then
2400:
2401: raise fnd_api.g_exc_error;
2402:
2403: end ;
2404:
2405:

Line 2492: -- raise fnd_api.g_exc_error;

2488: v_organization_type := 4 ;
2489: /* cost rollup is 'N' for child models of drop ship or buy */
2490:
2491:
2492: -- raise fnd_api.g_exc_error;
2493:
2494: end ;
2495:
2496:

Line 2895: WHEN fnd_api.g_exc_error THEN

2891:
2892:
2893:
2894: Exception
2895: WHEN fnd_api.g_exc_error THEN
2896: IF PG_DEBUG <> 0 THEN
2897: oe_debug_pub.add('create_in_src_orgs: '
2898: || 'expected error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2899: END IF;

Line 2901: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

2897: oe_debug_pub.add('create_in_src_orgs: '
2898: || 'expected error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2899: END IF;
2900:
2901: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
2902: -- Get message count and data
2903: xReturnStatus := fnd_api.g_ret_sts_error;
2904: -- Get message count and data
2905:

Line 2903: xReturnStatus := fnd_api.g_ret_sts_error;

2899: END IF;
2900:
2901: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
2902: -- Get message count and data
2903: xReturnStatus := fnd_api.g_ret_sts_error;
2904: -- Get message count and data
2905:
2906:
2907: cto_msg_pub.count_and_get

Line 2912: WHEN fnd_api.g_exc_unexpected_error THEN

2908: ( p_msg_count => xMsgCount
2909: , p_msg_data => xMsgData
2910: );
2911:
2912: WHEN fnd_api.g_exc_unexpected_error THEN
2913:
2914:
2915: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;
2916: -- Get message count and data

Line 2915: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;

2911:
2912: WHEN fnd_api.g_exc_unexpected_error THEN
2913:
2914:
2915: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;
2916: -- Get message count and data
2917:
2918:
2919: cto_msg_pub.count_and_get

Line 2931: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

2927: || 'create_in_src_orgs::others::'||to_char(lStmtNum)
2928: ||'::'||sqlerrm, 1);
2929: END IF;
2930:
2931: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
2932: -- Get message count and data
2933:
2934: cto_msg_pub.count_and_get
2935: ( p_msg_count => xMsgCount