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_UTILITY_PK dependencies on FND_API

Line 306: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

302: x_return_status,
303: x_msg_count,
304: x_msg_data);
305:
306: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
307: IF PG_DEBUG <> 0 THEN
308: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
309: END IF;
310: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 310: raise FND_API.G_EXC_UNEXPECTED_ERROR;

306: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
307: IF PG_DEBUG <> 0 THEN
308: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
309: END IF;
310: raise FND_API.G_EXC_UNEXPECTED_ERROR;
311:
312: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
313: IF PG_DEBUG <> 0 THEN
314: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);

Line 312: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN

308: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
309: END IF;
310: raise FND_API.G_EXC_UNEXPECTED_ERROR;
311:
312: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
313: IF PG_DEBUG <> 0 THEN
314: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);
315: END IF;
316: raise FND_API.G_EXC_ERROR;

Line 316: raise FND_API.G_EXC_ERROR;

312: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
313: IF PG_DEBUG <> 0 THEN
314: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);
315: END IF;
316: raise FND_API.G_EXC_ERROR;
317: END IF;
318: IF PG_DEBUG <> 0 THEN
319: oe_debug_pub.add('populate_plan_level: ' || 'after calling GAIO::lStatus::'||to_char(lStatus),2);
320: END IF;

Line 350: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

346: x_return_status,
347: x_msg_count,
348: x_msg_data);
349:
350: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
351: IF PG_DEBUG <> 0 THEN
352: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
353: END IF;
354: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 354: raise FND_API.G_EXC_UNEXPECTED_ERROR;

350: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
351: IF PG_DEBUG <> 0 THEN
352: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
353: END IF;
354: raise FND_API.G_EXC_UNEXPECTED_ERROR;
355:
356: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
357: IF PG_DEBUG <> 0 THEN
358: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);

Line 356: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN

352: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with unexp error',1);
353: END IF;
354: raise FND_API.G_EXC_UNEXPECTED_ERROR;
355:
356: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
357: IF PG_DEBUG <> 0 THEN
358: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);
359: END IF;
360: raise FND_API.G_EXC_ERROR;

Line 360: raise FND_API.G_EXC_ERROR;

356: ELSIF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_ERROR) THEN
357: IF PG_DEBUG <> 0 THEN
358: oe_debug_pub.add('populate_plan_level: ' || 'GAIO returned with exp error',1);
359: END IF;
360: raise FND_API.G_EXC_ERROR;
361: END IF;
362:
363: END LOOP;
364: END IF;

Line 391: when FND_API.G_EXC_UNEXPECTED_ERROR then

387: return(1);
388:
389: EXCEPTION
390:
391: when FND_API.G_EXC_UNEXPECTED_ERROR then
392: IF PG_DEBUG <> 0 THEN
393: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::unexp error::'||lStmtNumber||sqlerrm,1);
394: END IF;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

391: when FND_API.G_EXC_UNEXPECTED_ERROR then
392: IF PG_DEBUG <> 0 THEN
393: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::unexp error::'||lStmtNumber||sqlerrm,1);
394: END IF;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: CTO_MSG_PUB.Count_And_Get
397: (p_msg_count => x_msg_count
398: ,p_msg_data => x_msg_data
399: );

Line 402: when FND_API.G_EXC_ERROR then

398: ,p_msg_data => x_msg_data
399: );
400: return(0);
401:
402: when FND_API.G_EXC_ERROR then
403: IF PG_DEBUG <> 0 THEN
404: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::exp error::'||lStmtNumber||sqlerrm,1);
405: END IF;
406: x_return_status := FND_API.G_RET_STS_ERROR;

Line 406: x_return_status := FND_API.G_RET_STS_ERROR;

402: when FND_API.G_EXC_ERROR then
403: IF PG_DEBUG <> 0 THEN
404: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::exp error::'||lStmtNumber||sqlerrm,1);
405: END IF;
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: CTO_MSG_PUB.Count_And_Get
408: (p_msg_count => x_msg_count
409: ,p_msg_data => x_msg_data);
410: return(0);

Line 416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

412: when others then
413: IF PG_DEBUG <> 0 THEN
414: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::others::'||lStmtNumber||sqlerrm,1);
415: END IF;
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
418: FND_MSG_PUB.Add_Exc_Msg
419: (G_PKG_NAME
420: ,'populate_src_orgs'

Line 829: raise FND_API.G_EXC_ERROR;

825: -- This is because if we not set the token once again the
826: -- second add will not get the message.
827:
828: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
829: raise FND_API.G_EXC_ERROR;
830: ELSE
831:
832: IF PG_DEBUG <> 0 THEN
833: oe_debug_pub.add('populate_plan_level: ' || 'This model is having buy sourcing rule...',1);

Line 915: raise FND_API.G_EXC_ERROR;

911: -- This is because if we not set the token once again the
912: -- second add will not get the message.
913:
914: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
915: raise FND_API.G_EXC_ERROR;
916:
917: END;
918:
919: -- End of addition by Renga on 11/07/01

Line 980: raise FND_API.G_EXC_ERROR;

976: ||to_char(pRcvOrgId), 1);
977: END IF;
978:
979: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
980: raise FND_API.G_EXC_ERROR;
981: END IF;
982:
983: lStmtNumber := 120;
984: insert into bom_cto_src_orgs

Line 1245: raise FND_API.G_EXC_ERROR;

1241:
1242:
1243: if lVAlidationOrg = -99 then -- bugfix 2646849
1244: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
1245: raise FND_API.G_EXC_ERROR;
1246: end if;
1247: IF PG_DEBUG <> 0 THEN
1248: oe_debug_pub.add('populate_plan_level: ' || 'Validation Org is :' || lValidationOrg,2);
1249: END IF;

Line 1527: Raise FND_API.G_EXC_ERROR;

1523: WHEN po_multiorg_error THEN
1524: IF PG_DEBUG <> 0 THEN
1525: oe_debug_pub.add('populate_plan_level: ' || 'po_multiorg_error, not inserting row for PO val org',2);
1526: END IF;
1527: Raise FND_API.G_EXC_ERROR;
1528: WHEN others THEN
1529: IF PG_DEBUG <> 0 THEN
1530: oe_debug_pub.add('populate_plan_level: ' || 'others exception in PO validation block, not inserting row for PO val org',2);
1531: END IF;

Line 1537: when FND_API.G_EXC_ERROR then

1533: END;
1534: return(1);
1535:
1536: EXCEPTION
1537: when FND_API.G_EXC_ERROR then
1538: IF PG_DEBUG <> 0 THEN
1539: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::exp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1540: END IF;
1541: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1541: x_return_status := FND_API.G_RET_STS_ERROR;

1537: when FND_API.G_EXC_ERROR then
1538: IF PG_DEBUG <> 0 THEN
1539: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::exp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1540: END IF;
1541: x_return_status := FND_API.G_RET_STS_ERROR;
1542: CTO_MSG_PUB.Count_And_Get
1543: (p_msg_count => x_msg_count
1544: ,p_msg_data => x_msg_data
1545: );

Line 1548: when FND_API.G_EXC_UNEXPECTED_ERROR then

1544: ,p_msg_data => x_msg_data
1545: );
1546: return(0);
1547:
1548: when FND_API.G_EXC_UNEXPECTED_ERROR then
1549: IF PG_DEBUG <> 0 THEN
1550: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::unexp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1551: END IF;
1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1548: when FND_API.G_EXC_UNEXPECTED_ERROR then
1549: IF PG_DEBUG <> 0 THEN
1550: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::unexp error::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1551: END IF;
1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1553: CTO_MSG_PUB.Count_And_Get (
1554: p_msg_count => x_msg_count
1555: ,p_msg_data => x_msg_data
1556: );

Line 1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1559: when OTHERS then
1560: IF PG_DEBUG <> 0 THEN
1561: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::others::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1562: END IF;
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1564: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1565: FND_MSG_PUB.Add_Exc_Msg
1566: (G_PKG_NAME
1567: ,'Get_All_Item_Orgs'

Line 1704: x_return_status := FND_API.G_RET_STS_SUCCESS;

1700: No_sourcing_defined Exception;
1701:
1702: BEGIN
1703:
1704: x_return_status := FND_API.G_RET_STS_SUCCESS;
1705: lAssignmentExists := 0;
1706:
1707: lStmtNum := 10;
1708: /* get MRP's default assignment set */

Line 2018: --, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2014: -- confirm with raghu, confirmed with stupe
2015:
2016: MRP_Src_Assignment_PUB.Process_Assignment
2017: ( p_api_version_number => 1.0
2018: --, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2019: --, p_return_values IN VARCHAR2 := FND_API.G_FALSE
2020: --, p_commit IN VARCHAR2 := FND_API.G_FALSE
2021: , x_return_status => l_return_status
2022: , x_msg_count => l_msg_count

Line 2019: --, p_return_values IN VARCHAR2 := FND_API.G_FALSE

2015:
2016: MRP_Src_Assignment_PUB.Process_Assignment
2017: ( p_api_version_number => 1.0
2018: --, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2019: --, p_return_values IN VARCHAR2 := FND_API.G_FALSE
2020: --, p_commit IN VARCHAR2 := FND_API.G_FALSE
2021: , x_return_status => l_return_status
2022: , x_msg_count => l_msg_count
2023: , x_msg_data => l_msg_data

Line 2020: --, p_commit IN VARCHAR2 := FND_API.G_FALSE

2016: MRP_Src_Assignment_PUB.Process_Assignment
2017: ( p_api_version_number => 1.0
2018: --, p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2019: --, p_return_values IN VARCHAR2 := FND_API.G_FALSE
2020: --, p_commit IN VARCHAR2 := FND_API.G_FALSE
2021: , x_return_status => l_return_status
2022: , x_msg_count => l_msg_count
2023: , x_msg_data => l_msg_data
2024: , p_Assignment_Set_rec => lAssignmentSetRec

Line 2034: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2030: , x_Assignment_tbl => xAssignmentTbl
2031: , x_Assignment_val_tbl => xAssignmentValTbl
2032: );
2033:
2034: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2035: IF PG_DEBUG <> 0 THEN
2036: oe_debug_pub.add('populate_plan_level: ' || 'unexp error in process_assignment::'||sqlerrm,1);
2037: END IF;
2038: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2038: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2034: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2035: IF PG_DEBUG <> 0 THEN
2036: oe_debug_pub.add('populate_plan_level: ' || 'unexp error in process_assignment::'||sqlerrm,1);
2037: END IF;
2038: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2039:
2040: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2041: IF PG_DEBUG <> 0 THEN
2042: oe_debug_pub.add('populate_plan_level: ' || 'error in process_assignment::'||sqlerrm,1);

Line 2040: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2036: oe_debug_pub.add('populate_plan_level: ' || 'unexp error in process_assignment::'||sqlerrm,1);
2037: END IF;
2038: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2039:
2040: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2041: IF PG_DEBUG <> 0 THEN
2042: oe_debug_pub.add('populate_plan_level: ' || 'error in process_assignment::'||sqlerrm,1);
2043: END IF;
2044: raise FND_API.G_EXC_ERROR;

Line 2044: raise FND_API.G_EXC_ERROR;

2040: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2041: IF PG_DEBUG <> 0 THEN
2042: oe_debug_pub.add('populate_plan_level: ' || 'error in process_assignment::'||sqlerrm,1);
2043: END IF;
2044: raise FND_API.G_EXC_ERROR;
2045:
2046: END IF;
2047: IF PG_DEBUG <> 0 THEN
2048: oe_debug_pub.add('populate_plan_level: ' || 'success in process_assignment',2);

Line 2055: when FND_API.G_EXC_ERROR then

2051: EXCEPTION
2052: When NO_sourcing_defined THEN
2053: null;
2054:
2055: when FND_API.G_EXC_ERROR then
2056: IF PG_DEBUG <> 0 THEN
2057: oe_debug_pub.add('populate_plan_level: ' || 'Create_Src_Rules::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
2058: END IF;
2059: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2059: x_return_status := FND_API.G_RET_STS_ERROR;

2055: when FND_API.G_EXC_ERROR then
2056: IF PG_DEBUG <> 0 THEN
2057: oe_debug_pub.add('populate_plan_level: ' || 'Create_Src_Rules::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
2058: END IF;
2059: x_return_status := FND_API.G_RET_STS_ERROR;
2060: CTO_MSG_PUB.Count_And_Get
2061: (p_msg_count => x_msg_count
2062: ,p_msg_data => x_msg_data
2063: );

Line 2065: when FND_API.G_EXC_UNEXPECTED_ERROR then

2061: (p_msg_count => x_msg_count
2062: ,p_msg_data => x_msg_data
2063: );
2064:
2065: when FND_API.G_EXC_UNEXPECTED_ERROR then
2066: IF PG_DEBUG <> 0 THEN
2067: oe_debug_pub.add('populate_plan_level: ' || 'Create_Src_Rules::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
2068: END IF;
2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2065: when FND_API.G_EXC_UNEXPECTED_ERROR then
2066: IF PG_DEBUG <> 0 THEN
2067: oe_debug_pub.add('populate_plan_level: ' || 'Create_Src_Rules::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
2068: END IF;
2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2070: CTO_MSG_PUB.Count_And_Get
2071: (p_msg_count => x_msg_count
2072: ,p_msg_data => x_msg_data
2073: );

Line 2079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2075: when OTHERS then
2076: IF PG_DEBUG <> 0 THEN
2077: oe_debug_pub.add('populate_plan_level: ' || 'Create_Src_Rules::others::'||to_char(lStmtNum)||'::'||sqlerrm,1);
2078: END IF;
2079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2080: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2081: FND_MSG_PUB.Add_Exc_Msg
2082: (G_PKG_NAME
2083: ,'Create_Sourcing_Rules'

Line 2201: x_return_status := FND_API.G_RET_STS_SUCCESS;

2197:
2198: gUserId := nvl(Fnd_Global.USER_ID, -1);
2199: gLoginId := nvl(Fnd_Global.LOGIN_ID, -1);
2200:
2201: x_return_status := FND_API.G_RET_STS_SUCCESS;
2202:
2203: v_step := 'Step A1' ;
2204:
2205: select bom_explosion_temp_s.nextval

Line 2385: raise FND_API.G_EXC_ERROR;

2381:
2382: oe_debug_pub.add('populate_bcol: ' || 'error in top ato model line id::'||sqlerrm , 1 );
2383: END IF;
2384: cto_msg_pub.cto_message('BOM','CTO_CREATE_ITEM_ERROR');
2385: raise FND_API.G_EXC_ERROR;
2386:
2387: end;
2388:
2389:

Line 2443: raise FND_API.G_EXC_ERROR;

2439: oe_debug_pub.add('populate_bcol: ' || ' ---- CONFIG Exists ', 1 );
2440: END IF;
2441:
2442: cto_msg_pub.cto_message('BOM','CTO_CONFIG_ITEM_EXISTS');
2443: raise FND_API.G_EXC_ERROR;
2444:
2445: end if ;
2446:
2447:

Line 2543: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2539: oe_config_util.update_mfg_comp_seq_id( t_bcol(i).line_id
2540: , v_mfg_comp_seq_id
2541: , l_return_status );
2542:
2543: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2544: IF PG_DEBUG <> 0 THEN
2545: oe_debug_pub.add('populate_bcol: ' || 'unexp error in update_mfg_comp_seq_id::'||sqlerrm , 1 );
2546: END IF;
2547: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2547: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2543: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2544: IF PG_DEBUG <> 0 THEN
2545: oe_debug_pub.add('populate_bcol: ' || 'unexp error in update_mfg_comp_seq_id::'||sqlerrm , 1 );
2546: END IF;
2547: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2548:
2549: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2550: IF PG_DEBUG <> 0 THEN
2551: oe_debug_pub.add('populate_bcol: ' || 'error in update_mfg_comp_seq_id::'||sqlerrm , 1 );

Line 2549: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2545: oe_debug_pub.add('populate_bcol: ' || 'unexp error in update_mfg_comp_seq_id::'||sqlerrm , 1 );
2546: END IF;
2547: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2548:
2549: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2550: IF PG_DEBUG <> 0 THEN
2551: oe_debug_pub.add('populate_bcol: ' || 'error in update_mfg_comp_seq_id::'||sqlerrm , 1 );
2552: END IF;
2553: raise FND_API.G_EXC_ERROR;

Line 2553: raise FND_API.G_EXC_ERROR;

2549: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2550: IF PG_DEBUG <> 0 THEN
2551: oe_debug_pub.add('populate_bcol: ' || 'error in update_mfg_comp_seq_id::'||sqlerrm , 1 );
2552: END IF;
2553: raise FND_API.G_EXC_ERROR;
2554: END IF;
2555:
2556: end if ;
2557:

Line 2629: raise FND_API.G_EXC_ERROR;

2625: END IF;
2626:
2627:
2628: cto_msg_pub.cto_message('BOM','CTO_INVALID_MODEL_SETUP');
2629: raise FND_API.G_EXC_ERROR;
2630:
2631: end if;
2632:
2633: end if ;

Line 2916: when FND_API.G_EXC_ERROR then

2912: END IF;
2913:
2914: exception
2915:
2916: when FND_API.G_EXC_ERROR then
2917: IF PG_DEBUG <> 0 THEN
2918: oe_debug_pub.add('populate_bcol: ' || 'populate_Bcol::exp error::'|| v_step ||'::'||sqlerrm , 1);
2919: END IF;
2920: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2920: x_return_status := FND_API.G_RET_STS_ERROR;

2916: when FND_API.G_EXC_ERROR then
2917: IF PG_DEBUG <> 0 THEN
2918: oe_debug_pub.add('populate_bcol: ' || 'populate_Bcol::exp error::'|| v_step ||'::'||sqlerrm , 1);
2919: END IF;
2920: x_return_status := FND_API.G_RET_STS_ERROR;
2921: CTO_MSG_PUB.Count_And_Get
2922: (p_msg_count => x_msg_count
2923: ,p_msg_data => x_msg_data
2924: );

Line 2926: when FND_API.G_EXC_UNEXPECTED_ERROR then

2922: (p_msg_count => x_msg_count
2923: ,p_msg_data => x_msg_data
2924: );
2925:
2926: when FND_API.G_EXC_UNEXPECTED_ERROR then
2927: IF PG_DEBUG <> 0 THEN
2928: oe_debug_pub.add('populate_bcol: ' || 'populate_Bcol::unexp error::'|| v_step ||'::'||sqlerrm , 1);
2929: END IF;
2930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2926: when FND_API.G_EXC_UNEXPECTED_ERROR then
2927: IF PG_DEBUG <> 0 THEN
2928: oe_debug_pub.add('populate_bcol: ' || 'populate_Bcol::unexp error::'|| v_step ||'::'||sqlerrm , 1);
2929: END IF;
2930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2931: CTO_MSG_PUB.Count_And_Get
2932: (p_msg_count => x_msg_count
2933: ,p_msg_data => x_msg_data
2934: );

Line 2940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2936: when OTHERS then
2937: IF PG_DEBUG <> 0 THEN
2938: oe_debug_pub.add('populate_bcol: ' || 'populate_Bcol::others::'|| v_step ||'::'||sqlerrm , 1 );
2939: END IF;
2940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2941: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2942: FND_MSG_PUB.Add_Exc_Msg
2943: (G_PKG_NAME
2944: ,'populate_bcol'

Line 3209: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3205: IF PG_DEBUG <> 0 THEN
3206: oe_debug_pub.add('query_sourcing_org: ' || 'Initializing the assignment set',5);
3207: END IF;
3208: initialize_assignment_set(x_return_status);
3209: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3210: IF PG_DEBUG <> 0 THEN
3211: oe_debug_pub.add('query_sourcing_org: ' || 'Error in initializing assignment set',5);
3212: END IF;
3213: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3213: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3209: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3210: IF PG_DEBUG <> 0 THEN
3211: oe_debug_pub.add('query_sourcing_org: ' || 'Error in initializing assignment set',5);
3212: END IF;
3213: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3214: end if;
3215: End IF;
3216:
3217:

Line 3218: p_sourcing_rule_exists := FND_API.G_FALSE ;

3214: end if;
3215: End IF;
3216:
3217:
3218: p_sourcing_rule_exists := FND_API.G_FALSE ;
3219: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3220: p_transit_lead_time := 0 ;
3221:
3222:

Line 3219: x_return_status := FND_API.G_RET_STS_SUCCESS ;

3215: End IF;
3216:
3217:
3218: p_sourcing_rule_exists := FND_API.G_FALSE ;
3219: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3220: p_transit_lead_time := 0 ;
3221:
3222:
3223: -- Added by Renga Kannan on 08/27/01

Line 3238: p_sourcing_rule_exists := FND_API.G_TRUE;

3234: IF l_make_buy_code = 2 THEN
3235: p_source_type := 3;
3236: -- Renga Kannan added on 09/13/01 to set the sourcin_rule_exists
3237: -- Output value to Y even in the case of Buy attribute
3238: p_sourcing_rule_exists := FND_API.G_TRUE;
3239:
3240: ELSE
3241: p_source_type := 2;
3242:

Line 3300: p_sourcing_rule_exists := FND_API.G_TRUE ;

3296:
3297: p_source_type := v_source_type;
3298:
3299: if( v_source_type = 1 ) then
3300: p_sourcing_rule_exists := FND_API.G_TRUE ;
3301:
3302: --- The following elseif clause is added by Renga Kannan
3303: --- For procuring config project change.
3304: elsif (v_source_type = 3) then

Line 3305: p_sourcing_rule_exists := FND_API.G_TRUE ;

3301:
3302: --- The following elseif clause is added by Renga Kannan
3303: --- For procuring config project change.
3304: elsif (v_source_type = 3) then
3305: p_sourcing_rule_exists := FND_API.G_TRUE ;
3306: IF PG_DEBUG <> 0 THEN
3307: oe_debug_pub.add('query_sourcing_org: ' || 'Buy Sourcing rule exists...',1);
3308: END IF;
3309: end if ;

Line 3342: p_sourcing_rule_exists := FND_API.G_TRUE ;

3338: AND organization_id = p_organization_id;
3339:
3340: IF l_make_buy_code = 2 THEN
3341: p_source_type := 3;
3342: p_sourcing_rule_exists := FND_API.G_TRUE ;
3343: ELSE
3344: p_source_type := 2;
3345: END IF;
3346:

Line 3369: /* x_return_status := FND_API.G_RET_STS_ERROR;

3365:
3366:
3367: if( v_sourcing_rule_count > 0 ) then
3368:
3369: /* x_return_status := FND_API.G_RET_STS_ERROR;
3370: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
3371: x_exp_error_code := 66;
3372:
3373: */

Line 3379: p_sourcing_rule_exists := FND_API.G_TRUE ;

3375: --by Kiran Konada , for DMF-J mutliple sources support
3376: --from DMF-J , having multiple sources is not error
3377: --use 66 as source type for multiple sourcing
3378: p_source_type := 66;
3379: p_sourcing_rule_exists := FND_API.G_TRUE ;
3380:
3381:
3382: else
3383:

Line 3385: p_sourcing_rule_exists := FND_API.G_TRUE ;

3381:
3382: else
3383:
3384: p_source_type := 3 ;
3385: p_sourcing_rule_exists := FND_API.G_TRUE ;
3386:
3387:
3388: end if ;
3389:

Line 3404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3400:
3401: oe_debug_pub.add('query_sourcing_org: ' || ' came into others when finding source ' , 1 );
3402: END IF;
3403:
3404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3405:
3406:
3407:
3408: END ;

Line 3422: x_return_status := FND_API.G_RET_STS_SUCCESS ;

3418: INVALID_MRP_ASSIGNMENT_SET exception ;
3419:
3420: BEGIN
3421: /* begin for static block */
3422: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3423:
3424: /*
3425: ** get MRP's default assignment set
3426: */

Line 3472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3468: RAISE INVALID_MRP_ASSIGNMENT_SET ;
3469:
3470: when others then
3471:
3472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3473: end ;
3474:
3475: IF PG_DEBUG <> 0 THEN
3476: oe_debug_pub.add('initialize_assignment_set: ' || 'Default assignment set name is '||

Line 3485: x_return_status := FND_API.G_RET_STS_ERROR;

3481:
3482: END IF;
3483: exception
3484: when INVALID_MRP_ASSIGNMENT_SET then
3485: x_return_status := FND_API.G_RET_STS_ERROR;
3486:
3487: IF PG_DEBUG <> 0 THEN
3488: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::INVALID ASSIGNMENT SET ::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3489: END IF;

Line 3492: when FND_API.G_EXC_UNEXPECTED_ERROR then

3488: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::INVALID ASSIGNMENT SET ::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3489: END IF;
3490:
3491:
3492: when FND_API.G_EXC_UNEXPECTED_ERROR then
3493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3494: IF PG_DEBUG <> 0 THEN
3495: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3496: END IF;

Line 3493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3489: END IF;
3490:
3491:
3492: when FND_API.G_EXC_UNEXPECTED_ERROR then
3493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3494: IF PG_DEBUG <> 0 THEN
3495: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3496: END IF;
3497:

Line 3500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3496: END IF;
3497:
3498:
3499: when OTHERS then
3500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3501: IF PG_DEBUG <> 0 THEN
3502: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::others::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3503: END IF;
3504:

Line 3555: p_sourcing_rule_exists := FND_API.G_FALSE ;

3551:
3552: BEGIN
3553: l_stmt_num := 1;
3554:
3555: p_sourcing_rule_exists := FND_API.G_FALSE ;
3556: p_transit_lead_time := 0 ;
3557:
3558: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3559:

Line 3558: x_return_status := FND_API.G_RET_STS_SUCCESS ;

3554:
3555: p_sourcing_rule_exists := FND_API.G_FALSE ;
3556: p_transit_lead_time := 0 ;
3557:
3558: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3559:
3560: v_organization_id := p_organization_id ;
3561: v_transit_lead_time := 0 ;
3562: v_circular_sourcing := FALSE ;

Line 3607: IF x_return_status = FND_API.G_RET_STS_ERROR

3603:
3604:
3605: l_stmt_num := 40 ;
3606:
3607: IF x_return_status = FND_API.G_RET_STS_ERROR
3608: THEN
3609:
3610: RAISE FND_API.G_EXC_ERROR;
3611: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

Line 3610: RAISE FND_API.G_EXC_ERROR;

3606:
3607: IF x_return_status = FND_API.G_RET_STS_ERROR
3608: THEN
3609:
3610: RAISE FND_API.G_EXC_ERROR;
3611: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3612: THEN
3613:
3614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3611: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

3607: IF x_return_status = FND_API.G_RET_STS_ERROR
3608: THEN
3609:
3610: RAISE FND_API.G_EXC_ERROR;
3611: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3612: THEN
3613:
3614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3615: END IF;

Line 3614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3610: RAISE FND_API.G_EXC_ERROR;
3611: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3612: THEN
3613:
3614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3615: END IF;
3616:
3617: /* The following block is added by Renga Kannan on 08/21/01. This change is done as
3618: Part of BUY Model sourcing changes. The source type is being returned from

Line 3633: if( FND_API.to_boolean( v_sourcing_rule_exists ) ) then

3629: p_sourcing_rule_exists := 'T' ;
3630: exit;
3631: ELSE
3632:
3633: if( FND_API.to_boolean( v_sourcing_rule_exists ) ) then
3634: p_sourcing_rule_exists := 'T' ;
3635: else
3636: exit ; /* always exit when no more sourcing rules to cascade */
3637: end if ;

Line 3666: RAISE FND_API.G_EXC_ERROR;

3662: END IF;
3663:
3664: --bugfix 2813271: Added message to show the user
3665: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING'); -- bugfix 2813271
3666: RAISE FND_API.G_EXC_ERROR;
3667:
3668: end if ;
3669:
3670: p_sourcing_org := v_organization_id ;

Line 3677: when FND_API.G_EXC_ERROR then

3673: oe_debug_pub.add('get_model_sourcing_org: ' || 'sourcing org is ' || p_sourcing_org || ' lead time ' || to_char( p_transit_lead_time ) , 1 );
3674: END IF;
3675:
3676: exception
3677: when FND_API.G_EXC_ERROR then
3678: IF PG_DEBUG <> 0 THEN
3679: oe_debug_pub.add('get_model_sourcing_org: ' || 'GET_MODEL_SOURCING_ORG::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3680: END IF;
3681: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3681: x_return_status := FND_API.G_RET_STS_ERROR;

3677: when FND_API.G_EXC_ERROR then
3678: IF PG_DEBUG <> 0 THEN
3679: oe_debug_pub.add('get_model_sourcing_org: ' || 'GET_MODEL_SOURCING_ORG::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3680: END IF;
3681: x_return_status := FND_API.G_RET_STS_ERROR;
3682:
3683: CTO_MSG_PUB.Count_And_Get(
3684: p_msg_count => x_msg_count
3685: , p_msg_data => x_msg_data

Line 3688: when FND_API.G_EXC_UNEXPECTED_ERROR then

3684: p_msg_count => x_msg_count
3685: , p_msg_data => x_msg_data
3686: );
3687:
3688: when FND_API.G_EXC_UNEXPECTED_ERROR then
3689: IF PG_DEBUG <> 0 THEN
3690: oe_debug_pub.add('get_model_sourcing_org: ' || 'GET_MODEL_SOURCING_ORG::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3691: END IF;
3692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3688: when FND_API.G_EXC_UNEXPECTED_ERROR then
3689: IF PG_DEBUG <> 0 THEN
3690: oe_debug_pub.add('get_model_sourcing_org: ' || 'GET_MODEL_SOURCING_ORG::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3691: END IF;
3692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3693:
3694: CTO_MSG_PUB.Count_And_Get(
3695: p_msg_count => x_msg_count
3696: , p_msg_data => x_msg_data

Line 3703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3699: when OTHERS then
3700: IF PG_DEBUG <> 0 THEN
3701: oe_debug_pub.add('get_model_sourcing_org: ' || 'GET_MODEL_SOURCING_ORG::others::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3702: END IF;
3703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3704:
3705: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3706: FND_MSG_PUB.Add_Exc_Msg(
3707: G_PKG_NAME

Line 3940: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3936: when others then
3937: IF PG_DEBUG <> 0 THEN
3938: oe_debug_pub.add ('check_rsv_quantity: ' || 'OTHERS excpn while checking for unreserved qty :' ||substr(sqlerrm,1,150));
3939: END IF;
3940: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3941:
3942: END CHECK_RSV_QUANTITY;
3943: -- end bugfix 2001824
3944:

Line 3963: x_return_status := fnd_api.g_ret_sts_success;

3959: l_buffer VARCHAR2(32767);
3960:
3961: BEGIN
3962:
3963: x_return_status := fnd_api.g_ret_sts_success;
3964:
3965: -- get the file attachment locator (blob)
3966: select fl.file_data into l_blob_loc
3967: from fnd_lobs fl, fnd_attached_documents fad, fnd_documents_tl fdt

Line 3977: x_return_status := fnd_api.g_ret_sts_error;

3973: and fdt.media_id = fl.file_id
3974: and fdt.language = userenv('LANG');
3975:
3976: if l_blob_loc is null then
3977: x_return_status := fnd_api.g_ret_sts_error;
3978: oe_debug_pub.add('get_cto_item_attachment: ' || 'File attachment is null. Nothing to convert to clob... returning null', 1);
3979: return null;
3980: end if;
3981:

Line 4022: x_return_status := fnd_api.g_ret_sts_error;

4018:
4019: Exception
4020:
4021: when no_data_found then
4022: x_return_status := fnd_api.g_ret_sts_error;
4023: IF PG_DEBUG <> 0 THEN
4024: oe_debug_pub.add('get_cto_item_attachment: ' || 'no file attachment existsfor given item and org', 1);
4025: END IF;
4026: return null;

Line 4029: x_return_status := fnd_api.g_ret_sts_unexp_error;

4025: END IF;
4026: return null;
4027:
4028: when others then
4029: x_return_status := fnd_api.g_ret_sts_unexp_error;
4030: IF PG_DEBUG <> 0 THEN
4031: oe_debug_pub.add('get_cto_item_attachment: ' || 'When others exception ..' || sqlerrm, 1);
4032: END IF;
4033: return null;

Line 4063: x_return_status := FND_API.G_RET_STS_SUCCESS;

4059: l_row_id Varchar2(1000);
4060: l_stmt Number;
4061:
4062: BEGIN
4063: x_return_status := FND_API.G_RET_STS_SUCCESS;
4064:
4065: l_stmt := 10;
4066: IF PG_DEBUG <> 0 THEN
4067: oe_debug_pub.add('create_attachment: ' || 'Entering Create_attachment...',1);

Line 4072: -- The following FND API will create a document with the given Text information.

4068:
4069: oe_debug_pub.add('create_attachment: ' || 'Attachment desc = '||p_desc,1);
4070: END IF;
4071:
4072: -- The following FND API will create a document with the given Text information.
4073:
4074: -- Creating a long text document using text
4075:
4076: fnd_documents_pkg.insert_row(

Line 4214: when FND_API.G_EXC_UNEXPECTED_ERROR then

4210:
4211:
4212: EXCEPTION
4213:
4214: when FND_API.G_EXC_UNEXPECTED_ERROR then
4215: IF PG_DEBUG <> 0 THEN
4216: oe_debug_pub.add('create_attachment: ' || 'Create_attachment::unexp error::'||l_Stmt||'::'||sqlerrm,1);
4217: END IF;
4218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4214: when FND_API.G_EXC_UNEXPECTED_ERROR then
4215: IF PG_DEBUG <> 0 THEN
4216: oe_debug_pub.add('create_attachment: ' || 'Create_attachment::unexp error::'||l_Stmt||'::'||sqlerrm,1);
4217: END IF;
4218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4219:
4220: when FND_API.G_EXC_ERROR then
4221: IF PG_DEBUG <> 0 THEN
4222: oe_debug_pub.add('create_attachment: ' || 'Create_attachment::exp error::'||l_Stmt||'::'||sqlerrm,1);

Line 4220: when FND_API.G_EXC_ERROR then

4216: oe_debug_pub.add('create_attachment: ' || 'Create_attachment::unexp error::'||l_Stmt||'::'||sqlerrm,1);
4217: END IF;
4218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4219:
4220: when FND_API.G_EXC_ERROR then
4221: IF PG_DEBUG <> 0 THEN
4222: oe_debug_pub.add('create_attachment: ' || 'Create_attachment::exp error::'||l_Stmt||'::'||sqlerrm,1);
4223: END IF;
4224: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4224: x_return_status := FND_API.G_RET_STS_ERROR;

4220: when FND_API.G_EXC_ERROR then
4221: IF PG_DEBUG <> 0 THEN
4222: oe_debug_pub.add('create_attachment: ' || 'Create_attachment::exp error::'||l_Stmt||'::'||sqlerrm,1);
4223: END IF;
4224: x_return_status := FND_API.G_RET_STS_ERROR;
4225:
4226: when others then
4227: IF PG_DEBUG <> 0 THEN
4228: oe_debug_pub.add('create_attachment: ' || 'Create_attachment::OTHERS error::'||l_Stmt||'::'||sqlerrm,1);

Line 4230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4226: when others then
4227: IF PG_DEBUG <> 0 THEN
4228: oe_debug_pub.add('create_attachment: ' || 'Create_attachment::OTHERS error::'||l_Stmt||'::'||sqlerrm,1);
4229: END IF;
4230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4231:
4232:
4233: END create_attachment;
4234:

Line 4312: x_return_status := FND_API.G_RET_STS_SUCCESS;

4308: oe_debug_pub.add('GENERATE_BOM_ATTACH_TEXT: ' || 'line_id =>'||p_line_id,1);
4309: END IF;
4310:
4311:
4312: x_return_status := FND_API.G_RET_STS_SUCCESS;
4313:
4314: l_stmt := 10;
4315:
4316: -- rkaza. 02/06/2006. bug 4938433. FP for bug 4506153:

Line 4457: when FND_API.G_EXC_UNEXPECTED_ERROR then

4453:
4454:
4455: EXCEPTION
4456:
4457: when FND_API.G_EXC_UNEXPECTED_ERROR then
4458: IF PG_DEBUG <> 0 THEN
4459: oe_debug_pub.add('GENERATE_BOM_ATTACH_TEXT: ' || 'GENERATE_BOM_ATTACH_TEXT::unexp error::'||l_Stmt||sqlerrm,1);
4460: END IF;
4461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4457: when FND_API.G_EXC_UNEXPECTED_ERROR then
4458: IF PG_DEBUG <> 0 THEN
4459: oe_debug_pub.add('GENERATE_BOM_ATTACH_TEXT: ' || 'GENERATE_BOM_ATTACH_TEXT::unexp error::'||l_Stmt||sqlerrm,1);
4460: END IF;
4461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4462:
4463: when FND_API.G_EXC_ERROR then
4464: IF PG_DEBUG <> 0 THEN
4465: oe_debug_pub.add('GENERATE_BOM_ATTACH_TEXT: ' || 'GENERATE_BOM_ATTACH_TEXT::exp error::'||l_Stmt||sqlerrm,1);

Line 4463: when FND_API.G_EXC_ERROR then

4459: oe_debug_pub.add('GENERATE_BOM_ATTACH_TEXT: ' || 'GENERATE_BOM_ATTACH_TEXT::unexp error::'||l_Stmt||sqlerrm,1);
4460: END IF;
4461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4462:
4463: when FND_API.G_EXC_ERROR then
4464: IF PG_DEBUG <> 0 THEN
4465: oe_debug_pub.add('GENERATE_BOM_ATTACH_TEXT: ' || 'GENERATE_BOM_ATTACH_TEXT::exp error::'||l_Stmt||sqlerrm,1);
4466: END IF;
4467: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4467: x_return_status := FND_API.G_RET_STS_ERROR;

4463: when FND_API.G_EXC_ERROR then
4464: IF PG_DEBUG <> 0 THEN
4465: oe_debug_pub.add('GENERATE_BOM_ATTACH_TEXT: ' || 'GENERATE_BOM_ATTACH_TEXT::exp error::'||l_Stmt||sqlerrm,1);
4466: END IF;
4467: x_return_status := FND_API.G_RET_STS_ERROR;
4468:
4469: --
4470: -- bug 6717456
4471: -- ntungare

Line 4483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4479: when others then
4480: IF PG_DEBUG <> 0 THEN
4481: oe_debug_pub.add('GENERATE_BOM_ATTACH_TEXT: ' || 'GENERATE_BOM_ATTACH_TEXT::OTHERS error::'||l_Stmt||sqlerrm,1);
4482: END IF;
4483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4484:
4485: END GENERATE_BOM_ATTACH_TEXT;
4486:
4487:

Line 4594: x_return_status := FND_API.G_RET_STS_SUCCESS;

4590:
4591: IF PG_DEBUG <> 0 THEN
4592: oe_debug_pub.add('chk_all_rsv_details: ' || 'Entered CTO_UTILITY_PK.chk_all_rsv_details',1);
4593: END IF;
4594: x_return_status := FND_API.G_RET_STS_SUCCESS;
4595:
4596:
4597: l_stmt := 111;
4598: OPEN c_rsv_details;

Line 4635: x_return_status := FND_API.G_RET_STS_SUCCESS;--resv exists

4631:
4632: EXIT WHEN l_index = p_rsv_details.LAST;
4633: l_index := p_rsv_details.NEXT(l_index);
4634: END LOOP;
4635: x_return_status := FND_API.G_RET_STS_SUCCESS;--resv exists
4636: ELSE
4637: --no reservation exists
4638: x_return_status := FND_API.G_FALSE;
4639:

Line 4638: x_return_status := FND_API.G_FALSE;

4634: END LOOP;
4635: x_return_status := FND_API.G_RET_STS_SUCCESS;--resv exists
4636: ELSE
4637: --no reservation exists
4638: x_return_status := FND_API.G_FALSE;
4639:
4640: END IF;
4641:
4642:

Line 4649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4645:
4646:
4647: EXCEPTION
4648: when others then
4649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4650: IF PG_DEBUG <> 0 THEN
4651: oe_debug_pub.add ('chk_all_rsv_details: ' || 'unexpected error in called program chk_all_rsv_details'|| l_stmt||sqlerrm , 1);
4652: END IF;
4653: if fnd_msg_pub.check_msg_level

Line 4750: IF x_return_status = FND_API.G_RET_STS_ERROR

4746: oe_debug_pub.add('isModelMLMO: ' || ' after get model source status ' || x_return_status, 4 );
4747: END IF;
4748:
4749:
4750: IF x_return_status = FND_API.G_RET_STS_ERROR
4751: THEN
4752:
4753: RAISE FND_API.G_EXC_ERROR;
4754: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

Line 4753: RAISE FND_API.G_EXC_ERROR;

4749:
4750: IF x_return_status = FND_API.G_RET_STS_ERROR
4751: THEN
4752:
4753: RAISE FND_API.G_EXC_ERROR;
4754: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4755: THEN
4756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4757: END IF;

Line 4754: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

4750: IF x_return_status = FND_API.G_RET_STS_ERROR
4751: THEN
4752:
4753: RAISE FND_API.G_EXC_ERROR;
4754: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4755: THEN
4756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4757: END IF;
4758:

Line 4756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4752:
4753: RAISE FND_API.G_EXC_ERROR;
4754: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4755: THEN
4756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4757: END IF;
4758:
4759:
4760: if( FND_API.to_boolean( x_sourcing_rule_exists ) ) then

Line 4760: if( FND_API.to_boolean( x_sourcing_rule_exists ) ) then

4756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4757: END IF;
4758:
4759:
4760: if( FND_API.to_boolean( x_sourcing_rule_exists ) ) then
4761: return 1;
4762: end if ;
4763:
4764:

Line 5318: x_return_status := FND_API.G_RET_STS_SUCCESS;

5314: l_exp_error_code NUMBER;
5315:
5316:
5317: BEGIN
5318: x_return_status := FND_API.G_RET_STS_SUCCESS;
5319: x_can_create_supply := 'Y';
5320:
5321: IF PG_DEBUG <> 0 THEN
5322: oe_debug_pub.add('check_cto_can_create_supply : ' ||'ENTERED',1);

Line 5350: IF X_return_status = FND_API.G_RET_STS_SUCCESS

5346:
5347: );
5348:
5349: lStmtNum:=30;
5350: IF X_return_status = FND_API.G_RET_STS_SUCCESS
5351: and
5352: X_custom_out_params_rec.can_cto_create_supply = 'Y' THEN
5353:
5354:

Line 5376: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

5372: x_return_status => x_return_status,
5373: x_exp_error_code => l_exp_error_code );
5374:
5375: lStmtNum:=50;
5376: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
5377: IF PG_DEBUG <> 0 THEN
5378: oe_debug_pub.add('check_cto_can_create_supply : '
5379: ||'success from query sourcing org',5);
5380: END IF;

Line 5417: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5413: END IF; --can_create = y and source_type =2
5414:
5415:
5416:
5417: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5418: IF PG_DEBUG <> 0 THEN
5419: oe_debug_pub.add('check_cto_can_create_supply : ' || 'Unexpected Error in the sourcing rule.',1);
5420: END IF;
5421: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5421: raise FND_API.G_EXC_UNEXPECTED_ERROR;

5417: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5418: IF PG_DEBUG <> 0 THEN
5419: oe_debug_pub.add('check_cto_can_create_supply : ' || 'Unexpected Error in the sourcing rule.',1);
5420: END IF;
5421: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5422:
5423: END IF;
5424:
5425: ELSIF X_return_status = FND_API.G_RET_STS_SUCCESS --cutsom API's out param

Line 5425: ELSIF X_return_status = FND_API.G_RET_STS_SUCCESS --cutsom API's out param

5421: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5422:
5423: END IF;
5424:
5425: ELSIF X_return_status = FND_API.G_RET_STS_SUCCESS --cutsom API's out param
5426: and X_custom_out_params_rec.can_cto_create_supply = 'N' THEN
5427:
5428: IF PG_DEBUG <> 0 THEN
5429: oe_debug_pub.add('check_cto_can_create_supply : '

Line 5436: ELSIF X_return_status = FND_API.G_RET_STS_ERROR THEN

5432:
5433: x_can_create_supply := 'N';
5434: x_message := 'Custom api for SUPPLY returned N';
5435:
5436: ELSIF X_return_status = FND_API.G_RET_STS_ERROR THEN
5437: RAISE FND_API.G_EXC_ERROR;
5438:
5439: ELSE
5440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5437: RAISE FND_API.G_EXC_ERROR;

5433: x_can_create_supply := 'N';
5434: x_message := 'Custom api for SUPPLY returned N';
5435:
5436: ELSIF X_return_status = FND_API.G_RET_STS_ERROR THEN
5437: RAISE FND_API.G_EXC_ERROR;
5438:
5439: ELSE
5440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5441:

Line 5440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5436: ELSIF X_return_status = FND_API.G_RET_STS_ERROR THEN
5437: RAISE FND_API.G_EXC_ERROR;
5438:
5439: ELSE
5440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5441:
5442: END IF;
5443:
5444: EXCEPTION

Line 5446: WHEN fnd_api.g_exc_error THEN

5442: END IF;
5443:
5444: EXCEPTION
5445:
5446: WHEN fnd_api.g_exc_error THEN
5447: IF PG_DEBUG <> 0 THEN
5448: oe_debug_pub.add('check_cto_can_create_supply: ' || 'Exception in stmt num: '
5449: || to_char(lStmtNum), 1);
5450: END IF;

Line 5451: x_return_status := FND_API.G_RET_STS_ERROR;

5447: IF PG_DEBUG <> 0 THEN
5448: oe_debug_pub.add('check_cto_can_create_supply: ' || 'Exception in stmt num: '
5449: || to_char(lStmtNum), 1);
5450: END IF;
5451: x_return_status := FND_API.G_RET_STS_ERROR;
5452: -- Get message count and data
5453: cto_msg_pub.count_and_get
5454: ( p_msg_count => x_msg_count
5455: , p_msg_data => x_msg_data

Line 5457: WHEN fnd_api.g_exc_unexpected_error THEN

5453: cto_msg_pub.count_and_get
5454: ( p_msg_count => x_msg_count
5455: , p_msg_data => x_msg_data
5456: );
5457: WHEN fnd_api.g_exc_unexpected_error THEN
5458: IF PG_DEBUG <> 0 THEN
5459: oe_debug_pub.add('check_cto_can_create_supply: ' || ' Unexpected Exception in stmt num: '
5460: || to_char(lStmtNum), 1);
5461: END IF;

Line 5462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5458: IF PG_DEBUG <> 0 THEN
5459: oe_debug_pub.add('check_cto_can_create_supply: ' || ' Unexpected Exception in stmt num: '
5460: || to_char(lStmtNum), 1);
5461: END IF;
5462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5463: -- Get message count and data
5464: cto_msg_pub.count_and_get
5465: ( p_msg_count => x_msg_count
5466: , p_msg_data => x_msg_data

Line 5475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5471: oe_debug_pub.add('check_cto_can_create_supply: ' || 'Others Exception in stmt num: '
5472: || to_char(lStmtNum), 1);
5473: oe_debug_pub.add('check_cto_can_create_supply: ' || 'errormsg='||sqlerrm, 1);
5474: END IF;
5475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5476: -- Get message count and data
5477: cto_msg_pub.count_and_get
5478: ( p_msg_count => x_msg_count
5479: , p_msg_data => x_msg_data

Line 5601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5597: || to_char(lStmtNum), 1);
5598: oe_debug_pub.add('CTO_UTILITY_PK.split_line: ' || 'errormsg='||sqlerrm, 1);
5599:
5600: END IF;
5601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5602:
5603:
5604: end split_line ;
5605:

Line 5713: x_return_status := FND_API.G_RET_STS_SUCCESS;

5709: END IF;
5710: END IF;
5711:
5712: x_result := TRUE;
5713: x_return_status := FND_API.G_RET_STS_SUCCESS;
5714:
5715: EXCEPTION
5716: WHEN no_data_found THEN
5717: IF PG_DEBUG <> 0 THEN

Line 5720: x_return_status := FND_API.G_RET_STS_SUCCESS;

5716: WHEN no_data_found THEN
5717: IF PG_DEBUG <> 0 THEN
5718: oe_debug_pub.add('Reservation_Exists: ' || 'Coming out of reservation_exists procedure with FALSE...',2);
5719: END IF;
5720: x_return_status := FND_API.G_RET_STS_SUCCESS;
5721: x_result := FALSE;
5722:
5723: WHEN others THEN
5724: IF PG_DEBUG <> 0 THEN

Line 5729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5725: oe_debug_pub.add('Reservation_Exists: ' || 'OTHERS excpn occured in Reservation_Exists procedure..',2);
5726:
5727: oe_debug_pub.add('Reservation_Exists: ' || 'Error message is : '||sqlerrm,1);
5728: END IF;
5729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5730: x_result := FALSE;
5731:
5732: END Reservation_Exists;
5733:

Line 6228: p_encoded => FND_API.G_FALSE),1,2000);

6224: -- Added substr function to avoid buffer overflow error
6225:
6226: l_msg_data := substr(fnd_msg_pub.get(
6227: p_msg_index => l_index,
6228: p_encoded => FND_API.G_FALSE),1,2000);
6229:
6230: oe_debug_pub.add('CTO_UTILITY_PK.notify_expected_error: '||substr(l_msg_data,1,250));
6231:
6232: -- Fixed bug 5639511

Line 6367: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

6363: , x_return_status => x_return_status
6364: , x_msg_count => x_msg_count
6365: , x_msg_data => x_msg_data);
6366:
6367: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
6368: IF PG_DEBUG <> 0 THEN
6369: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with expected error.' ,1);
6370: END IF;
6371: raise FND_API.G_EXC_ERROR;

Line 6371: raise FND_API.G_EXC_ERROR;

6367: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
6368: IF PG_DEBUG <> 0 THEN
6369: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with expected error.' ,1);
6370: END IF;
6371: raise FND_API.G_EXC_ERROR;
6372:
6373: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6374: IF PG_DEBUG <> 0 THEN
6375: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with unexpected error.' ,1);

Line 6373: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

6369: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with expected error.' ,1);
6370: END IF;
6371: raise FND_API.G_EXC_ERROR;
6372:
6373: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6374: IF PG_DEBUG <> 0 THEN
6375: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with unexpected error.' ,1);
6376: END IF;
6377: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6377: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6373: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6374: IF PG_DEBUG <> 0 THEN
6375: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with unexpected error.' ,1);
6376: END IF;
6377: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6378: END IF;
6379:
6380: commit ; /* COMMIT FOR AUTONOMOUS TRANSACTION */
6381:

Line 6742: x_return_status := FND_API.G_RET_STS_SUCCESS ;

6738:
6739:
6740: begin
6741:
6742: x_return_status := FND_API.G_RET_STS_SUCCESS ;
6743:
6744: v_step := 'Step A17' ;
6745:
6746: --

Line 6767: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6763: if bcol_count <> oe_count then
6764: IF PG_DEBUG <> 0 THEN
6765: oe_debug_pub.add ('validate_oe_data: '||v_step||': OE count '||oe_count||' and BCOL count '||bcol_count||' does not match.');
6766: END IF;
6767: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6768: end if;
6769:
6770:
6771:

Line 6850: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6846: if( v_oe_bcol_diff = 'Y' ) then
6847: IF PG_DEBUG <> 0 THEN
6848: oe_debug_pub.add ('validate_oe_data: data in BCOL and OE_ORDER_LINES_ALL does not match' , 1);
6849: END IF;
6850: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6851: end if;
6852:
6853:
6854:

Line 6859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6855:
6856:
6857: exception
6858: when OTHERS then
6859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6860: oe_debug_pub.add('validate_oe_data: ' || 'validate_oe_data::others:: '||sqlerrm,1);
6861:
6862:
6863: end validate_oe_data ;

Line 6957: x_return_status := FND_API.G_RET_STS_SUCCESS;

6953: bcolOptions.line_id = bcolModel.line_id)
6954: order by 1;
6955:
6956: BEGIN
6957: x_return_status := FND_API.G_RET_STS_SUCCESS;
6958: x_lock_status := 0;
6959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lock_For_Match Start Time: '||to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));
6960:
6961: OPEN c1;

Line 6967: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6963:
6964: if l_comp_item_id.count = 0 then
6965: -- This situation should never arise. If it does, raise error.
6966: oe_debug_pub.add ('l_comp_item_id.count = 0. Raising error..');
6967: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6968: end if;
6969:
6970: IF PG_DEBUG <> 0 THEN
6971: oe_debug_pub.add ('Number of records selected = '|| l_comp_item_id.count);

Line 7071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then

7067: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lock_For_Match End Time: '||to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));
7068:
7069: EXCEPTION
7070:
7071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
7072: oe_debug_pub.add('lock_for_match: ' || 'Unexpected Error.');
7073: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
7074: -- Get message count and data
7075: cto_msg_pub.count_and_get

Line 7073: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

7069: EXCEPTION
7070:
7071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
7072: oe_debug_pub.add('lock_for_match: ' || 'Unexpected Error.');
7073: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
7074: -- Get message count and data
7075: cto_msg_pub.count_and_get
7076: ( p_msg_count => xMsgCount
7077: , p_msg_data => xMsgData

Line 7081: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

7077: , p_msg_data => xMsgData
7078: );
7079: WHEN OTHERS then
7080: oe_debug_pub.add('lock_for_match: ' || 'Others Exception : ' || sqlerrm);
7081: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
7082: -- Get message count and data
7083: cto_msg_pub.count_and_get
7084: ( p_msg_count => xMsgCount
7085: , p_msg_data => xMsgData

Line 7109: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

7105: , x_msg_data OUT NOCOPY VARCHAR2
7106: , p_hash_value IN VARCHAR2)
7107:
7108: IS
7109: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
7110: l_lock_handle VARCHAR2(128);
7111: l_status INTEGER;
7112:
7113:

Line 7120: RAISE fnd_api.g_exc_error;

7116: --validate hash_value
7117: IF (p_hash_value IS NULL) THEN
7118: --raise error condition
7119: oe_debug_pub.add('RELEASE_LOCK: Hash Value is null but required for releasing lock.');
7120: RAISE fnd_api.g_exc_error;
7121: END IF;
7122:
7123:
7124: --get lock handle by calling helper function

Line 7135: RAISE fnd_api.g_exc_error;

7131: -- do nothing
7132: --if parameter error or illegal lock handle (internal error)
7133: if l_status IN (3,5) THEN
7134: cto_msg_pub.cto_message('BOM','BOM_LOCK_RELEASE_ERROR');
7135: RAISE fnd_api.g_exc_error;
7136: end if;
7137:
7138: x_return_status := l_return_status;
7139:

Line 7142: WHEN fnd_api.g_exc_error THEN

7138: x_return_status := l_return_status;
7139:
7140: EXCEPTION
7141:
7142: WHEN fnd_api.g_exc_error THEN
7143: oe_debug_pub.add('release_lock: ' || 'expected error');
7144: x_return_status := fnd_api.g_ret_sts_error;
7145:
7146: WHEN fnd_api.g_exc_unexpected_error THEN

Line 7144: x_return_status := fnd_api.g_ret_sts_error;

7140: EXCEPTION
7141:
7142: WHEN fnd_api.g_exc_error THEN
7143: oe_debug_pub.add('release_lock: ' || 'expected error');
7144: x_return_status := fnd_api.g_ret_sts_error;
7145:
7146: WHEN fnd_api.g_exc_unexpected_error THEN
7147: oe_debug_pub.add('release_lock: ' || 'Unexpected error');
7148: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 7146: WHEN fnd_api.g_exc_unexpected_error THEN

7142: WHEN fnd_api.g_exc_error THEN
7143: oe_debug_pub.add('release_lock: ' || 'expected error');
7144: x_return_status := fnd_api.g_ret_sts_error;
7145:
7146: WHEN fnd_api.g_exc_unexpected_error THEN
7147: oe_debug_pub.add('release_lock: ' || 'Unexpected error');
7148: x_return_status := fnd_api.g_ret_sts_unexp_error ;
7149:
7150: WHEN OTHERS THEN

Line 7148: x_return_status := fnd_api.g_ret_sts_unexp_error ;

7144: x_return_status := fnd_api.g_ret_sts_error;
7145:
7146: WHEN fnd_api.g_exc_unexpected_error THEN
7147: oe_debug_pub.add('release_lock: ' || 'Unexpected error');
7148: x_return_status := fnd_api.g_ret_sts_unexp_error ;
7149:
7150: WHEN OTHERS THEN
7151: oe_debug_pub.add('release_lock: ' || 'Others Exception : ' || sqlerrm);
7152: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 7152: x_return_status := fnd_api.g_ret_sts_unexp_error ;

7148: x_return_status := fnd_api.g_ret_sts_unexp_error ;
7149:
7150: WHEN OTHERS THEN
7151: oe_debug_pub.add('release_lock: ' || 'Others Exception : ' || sqlerrm);
7152: x_return_status := fnd_api.g_ret_sts_unexp_error ;
7153:
7154: END release_lock;
7155:
7156:

Line 7250: x_return_status := FND_API.G_RET_STS_SUCCESS;

7246: l_routing_type bom_operational_routings.cfm_routing_flag%type;
7247:
7248: BEGIN
7249:
7250: x_return_status := FND_API.G_RET_STS_SUCCESS;
7251: --need this for flow and interface data alone
7252:
7253: -- Bugfix 16236435: Modifying this sql to get routing type for the item.
7254: -- This is needed to determine if the GET_FLOW_QUANTITY() API needs to

Line 7527: WHEN fnd_api.g_exc_error THEN

7523: END LOOP;
7524:
7525:
7526: EXCEPTION
7527: WHEN fnd_api.g_exc_error THEN
7528: IF PG_DEBUG <> 0 THEN
7529: oe_debug_pub.add('get_resv_qty: ' || 'Exception in stmt num: '
7530: || to_char(lStmtNum), 1);
7531: END IF;

Line 7532: x_return_status := FND_API.G_RET_STS_ERROR;

7528: IF PG_DEBUG <> 0 THEN
7529: oe_debug_pub.add('get_resv_qty: ' || 'Exception in stmt num: '
7530: || to_char(lStmtNum), 1);
7531: END IF;
7532: x_return_status := FND_API.G_RET_STS_ERROR;
7533: -- Get message count and data
7534: cto_msg_pub.count_and_get
7535: ( p_msg_count => x_msg_count
7536: , p_msg_data => x_msg_data

Line 7538: WHEN fnd_api.g_exc_unexpected_error THEN

7534: cto_msg_pub.count_and_get
7535: ( p_msg_count => x_msg_count
7536: , p_msg_data => x_msg_data
7537: );
7538: WHEN fnd_api.g_exc_unexpected_error THEN
7539: IF PG_DEBUG <> 0 THEN
7540: oe_debug_pub.add('get_resv_qty: '|| ' Unexpected Exception in stmt num: '
7541: || to_char(lStmtNum), 1);
7542: END IF;

Line 7543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7539: IF PG_DEBUG <> 0 THEN
7540: oe_debug_pub.add('get_resv_qty: '|| ' Unexpected Exception in stmt num: '
7541: || to_char(lStmtNum), 1);
7542: END IF;
7543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7544: -- Get message count and data
7545: cto_msg_pub.count_and_get
7546: ( p_msg_count => x_msg_count
7547: , p_msg_data => x_msg_data

Line 7556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7552:
7553: oe_debug_pub.add('get_resv_qty: ' || 'Others Exception in stmt num: '
7554: || to_char(lStmtNum), 1);
7555: END IF;
7556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7557: -- Get message count and data
7558: cto_msg_pub.count_and_get
7559: ( p_msg_count => x_msg_count
7560: , p_msg_data => x_msg_data