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 498: xReturnStatus := fnd_api.g_ret_sts_success;

494: lCnt number;
495:
496: BEGIN
497:
498: xReturnStatus := fnd_api.g_ret_sts_success;
499:
500: IF PG_DEBUG <> 0 THEN
501: oe_debug_pub.add(' entered create_in_src_orgs: model ' || pModelId
502: || ' Line ' || pLineId , 1);

Line 511: if xReturnStatus <> fnd_api.g_ret_sts_success then

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

Line 512: raise fnd_api.g_exc_unexpected_error;

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

Line 747: raise fnd_api.g_exc_error;

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

Line 795: raise FND_API.G_EXC_ERROR;

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

Line 828: raise fnd_api.g_exc_unexpected_error;

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

Line 1025: raise fnd_api.g_exc_error;

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

Line 1062: raise fnd_api.g_exc_error;

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

Line 1175: raise fnd_api.g_exc_error;

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

Line 1444: raise fnd_api.g_exc_error;

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

Line 1483: raise fnd_api.g_exc_error;

1479: when others then
1480: IF PG_DEBUG <> 0 THEN
1481: oe_debug_pub.add ('Failed in stmt ' || lStmtNum || ' with error: '||sqlerrm);
1482: END IF;
1483: raise fnd_api.g_exc_error;
1484: END ;
1485:
1486: /* Bugfix 2986192 ends here */
1487:

Line 1547: raise fnd_api.g_exc_error;

1543: if( lStatus = -1) then /* add a message for unexpected errors(-1), expected errors(0) already have a message */
1544: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_BOM_ERROR');
1545: end if;
1546:
1547: raise fnd_api.g_exc_error;
1548:
1549: end if;
1550:
1551:

Line 1607: raise fnd_api.g_exc_error;

1603: oe_debug_pub.add('Deleted from bmi, rows::'||lCnt);
1604: END IF;
1605:
1606: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_ROUTING_ERROR');
1607: raise fnd_api.g_exc_error;
1608:
1609: end if;
1610:
1611:

Line 1668: raise fnd_api.g_exc_error;

1664: IF PG_DEBUG <> 0 THEN
1665: oe_debug_pub.add('added club_comp_error ' , 1) ;
1666: end if ;
1667:
1668: raise fnd_api.g_exc_error;
1669:
1670: end if;
1671:
1672: end if; -- end lCfgBillId > 0

Line 1712: raise fnd_api.g_exc_error;

1708: cto_msg_pub.cto_message('BOM','CTO_BOM_NOT_DEFINED');
1709: -- bugfix 2294708: Replaced msg CTO_CREATE_BOM_ERROR with more specific
1710: -- error CTO_BOM_NOT_DEFINED.
1711:
1712: raise fnd_api.g_exc_error;
1713:
1714:
1715:
1716:

Line 1760: raise fnd_api.g_exc_error;

1756: l_token1(1).token_name := 'MODEL_NAME';
1757: l_token1(1).token_value := v_model_item_name ;
1758:
1759: cto_msg_pub.cto_message('BOM','CTO_NO_BOM_CREATED_IN_ANY_ORGS', l_token1 ); -- Bug 3349142
1760: raise fnd_api.g_exc_error;
1761:
1762: end if ;
1763:
1764:

Line 1775: WHEN fnd_api.g_exc_error THEN

1771:
1772:
1773: EXCEPTION
1774:
1775: WHEN fnd_api.g_exc_error THEN
1776: IF PG_DEBUG <> 0 THEN
1777: oe_debug_pub.add('create_in_src_orgs: '
1778: || 'expected error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
1779: END IF;

Line 1781: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

1777: oe_debug_pub.add('create_in_src_orgs: '
1778: || 'expected error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
1779: END IF;
1780:
1781: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
1782: -- Get message count and data
1783: xReturnStatus := fnd_api.g_ret_sts_error;
1784: -- Get message count and data
1785:

Line 1783: xReturnStatus := fnd_api.g_ret_sts_error;

1779: END IF;
1780:
1781: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
1782: -- Get message count and data
1783: xReturnStatus := fnd_api.g_ret_sts_error;
1784: -- Get message count and data
1785:
1786:
1787: cto_msg_pub.count_and_get

Line 1798: WHEN fnd_api.g_exc_unexpected_error THEN

1794: oe_debug_pub.add('create_in_src_orgs: ' || xMsgCount , 1 ) ;
1795:
1796: END IF;
1797:
1798: WHEN fnd_api.g_exc_unexpected_error THEN
1799:
1800:
1801: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;
1802: -- Get message count and data

Line 1801: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;

1797:
1798: WHEN fnd_api.g_exc_unexpected_error THEN
1799:
1800:
1801: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;
1802: -- Get message count and data
1803:
1804:
1805: cto_msg_pub.count_and_get

Line 1817: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

1813: || 'create_in_src_orgs::others::'||to_char(lStmtNum)
1814: ||'::'||sqlerrm, 1);
1815: END IF;
1816:
1817: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
1818: -- Get message count and data
1819:
1820: cto_msg_pub.count_and_get
1821: ( p_msg_count => xMsgCount

Line 2035: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2031: IF PG_DEBUG <> 0 THEN
2032: oe_debug_pub.add('update_atp: ' || 'ATP returned ' || l_return_status);
2033: END IF;
2034:
2035: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2036: or l_return_status = FND_API.G_RET_STS_ERROR ) then
2037: raise atp_error;
2038: END IF;
2039: else

Line 2036: or l_return_status = FND_API.G_RET_STS_ERROR ) then

2032: oe_debug_pub.add('update_atp: ' || 'ATP returned ' || l_return_status);
2033: END IF;
2034:
2035: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2036: or l_return_status = FND_API.G_RET_STS_ERROR ) then
2037: raise atp_error;
2038: END IF;
2039: else
2040: IF PG_DEBUG <> 0 THEN

Line 2227: xReturnStatus := fnd_api.g_ret_sts_success;

2223: /* 2986190 End declaration */
2224:
2225: BEGIN
2226:
2227: xReturnStatus := fnd_api.g_ret_sts_success;
2228:
2229: -- check if model bom exists in src org
2230:
2231: lStmtNum := 10;

Line 2264: raise fnd_api.g_exc_error;

2260:
2261: exception
2262:
2263: when others then
2264: raise fnd_api.g_exc_error;
2265:
2266: end ;
2267:
2268: lStmtNum := 26;

Line 2282: raise FND_API.G_EXC_ERROR;

2278: exception
2279: when no_data_found then
2280:
2281: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
2282: raise FND_API.G_EXC_ERROR;
2283:
2284: when others then
2285:
2286: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2286: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2282: raise FND_API.G_EXC_ERROR;
2283:
2284: when others then
2285:
2286: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2287:
2288:
2289: end;
2290:

Line 2312: raise FND_API.G_EXC_ERROR;

2308: exception
2309: when no_data_found then
2310:
2311: cto_msg_pub.cto_message('BOM','CTO_BUY_COST_NOT_FOUND');
2312: raise FND_API.G_EXC_ERROR;
2313:
2314: when others then
2315:
2316: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2316: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2312: raise FND_API.G_EXC_ERROR;
2313:
2314: when others then
2315:
2316: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2317:
2318:
2319: end;
2320:

Line 2360: raise fnd_api.g_exc_error;

2356: v_cto_cost_xudc := null ;
2357:
2358: when others then
2359:
2360: raise fnd_api.g_exc_error;
2361:
2362: end ;
2363:
2364:

Line 2384: raise fnd_api.g_exc_error;

2380: v_valuation_cost := null ;
2381:
2382: when others then
2383:
2384: raise fnd_api.g_exc_error;
2385:
2386: end ;
2387:
2388:

Line 2406: raise fnd_api.g_exc_error ;

2402:
2403: exception
2404: when others then
2405:
2406: raise fnd_api.g_exc_error ;
2407:
2408: end ;
2409: end if ;
2410:

Line 2461: raise fnd_api.g_exc_error;

2457: END IF;
2458:
2459: when others then
2460:
2461: raise fnd_api.g_exc_error;
2462:
2463: end ;
2464:
2465:

Line 2552: -- raise fnd_api.g_exc_error;

2548: v_organization_type := 4 ;
2549: /* cost rollup is 'N' for child models of drop ship or buy */
2550:
2551:
2552: -- raise fnd_api.g_exc_error;
2553:
2554: end ;
2555:
2556:

Line 2955: WHEN fnd_api.g_exc_error THEN

2951:
2952:
2953:
2954: Exception
2955: WHEN fnd_api.g_exc_error THEN
2956: IF PG_DEBUG <> 0 THEN
2957: oe_debug_pub.add('create_in_src_orgs: '
2958: || 'expected error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2959: END IF;

Line 2961: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

2957: oe_debug_pub.add('create_in_src_orgs: '
2958: || 'expected error::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
2959: END IF;
2960:
2961: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
2962: -- Get message count and data
2963: xReturnStatus := fnd_api.g_ret_sts_error;
2964: -- Get message count and data
2965:

Line 2963: xReturnStatus := fnd_api.g_ret_sts_error;

2959: END IF;
2960:
2961: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
2962: -- Get message count and data
2963: xReturnStatus := fnd_api.g_ret_sts_error;
2964: -- Get message count and data
2965:
2966:
2967: cto_msg_pub.count_and_get

Line 2972: WHEN fnd_api.g_exc_unexpected_error THEN

2968: ( p_msg_count => xMsgCount
2969: , p_msg_data => xMsgData
2970: );
2971:
2972: WHEN fnd_api.g_exc_unexpected_error THEN
2973:
2974:
2975: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;
2976: -- Get message count and data

Line 2975: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;

2971:
2972: WHEN fnd_api.g_exc_unexpected_error THEN
2973:
2974:
2975: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;
2976: -- Get message count and data
2977:
2978:
2979: cto_msg_pub.count_and_get

Line 2991: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

2987: || 'create_in_src_orgs::others::'||to_char(lStmtNum)
2988: ||'::'||sqlerrm, 1);
2989: END IF;
2990:
2991: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
2992: -- Get message count and data
2993:
2994: cto_msg_pub.count_and_get
2995: ( p_msg_count => xMsgCount