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 304: IF (lStatus <> 1) AND (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

Line 308: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 314: raise FND_API.G_EXC_ERROR;

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

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

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

Line 352: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 358: raise FND_API.G_EXC_ERROR;

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

Line 389: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 400: when FND_API.G_EXC_ERROR then

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

Line 404: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 827: raise FND_API.G_EXC_ERROR;

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

Line 913: raise FND_API.G_EXC_ERROR;

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

Line 978: raise FND_API.G_EXC_ERROR;

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

Line 1243: raise FND_API.G_EXC_ERROR;

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

Line 1525: Raise FND_API.G_EXC_ERROR;

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

Line 1535: when FND_API.G_EXC_ERROR then

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

Line 1539: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1546: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1702: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

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

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

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

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

Line 2032: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 2036: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2038: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 2042: raise FND_API.G_EXC_ERROR;

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

Line 2053: when FND_API.G_EXC_ERROR then

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

Line 2057: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2063: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 2067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 2199: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2383: raise FND_API.G_EXC_ERROR;

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

Line 2441: raise FND_API.G_EXC_ERROR;

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

Line 2541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 2545: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2547: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 2551: raise FND_API.G_EXC_ERROR;

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

Line 2627: raise FND_API.G_EXC_ERROR;

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

Line 2914: when FND_API.G_EXC_ERROR then

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

Line 2918: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2924: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 2928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 3207: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 3211: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3216: p_sourcing_rule_exists := FND_API.G_FALSE ;

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

Line 3217: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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

Line 3236: p_sourcing_rule_exists := FND_API.G_TRUE;

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

Line 3298: p_sourcing_rule_exists := FND_API.G_TRUE ;

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

Line 3303: p_sourcing_rule_exists := FND_API.G_TRUE ;

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

Line 3340: p_sourcing_rule_exists := FND_API.G_TRUE ;

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

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

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

Line 3377: p_sourcing_rule_exists := FND_API.G_TRUE ;

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

Line 3383: p_sourcing_rule_exists := FND_API.G_TRUE ;

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

Line 3402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3420: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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

Line 3470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 3483: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3490: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 3491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3553: p_sourcing_rule_exists := FND_API.G_FALSE ;

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

Line 3556: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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

Line 3605: IF x_return_status = FND_API.G_RET_STS_ERROR

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

Line 3608: RAISE FND_API.G_EXC_ERROR;

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

Line 3609: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

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

Line 3612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 3664: RAISE FND_API.G_EXC_ERROR;

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

Line 3675: when FND_API.G_EXC_ERROR then

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

Line 3679: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3686: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

Line 3690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 3918: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3914: when others then
3915: IF PG_DEBUG <> 0 THEN
3916: oe_debug_pub.add ('check_rsv_quantity: ' || 'OTHERS excpn while checking for unreserved qty :' ||substr(sqlerrm,1,150));
3917: END IF;
3918: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3919:
3920: END CHECK_RSV_QUANTITY;
3921: -- end bugfix 2001824
3922:

Line 3941: x_return_status := fnd_api.g_ret_sts_success;

3937: l_buffer VARCHAR2(32767);
3938:
3939: BEGIN
3940:
3941: x_return_status := fnd_api.g_ret_sts_success;
3942:
3943: -- get the file attachment locator (blob)
3944: select fl.file_data into l_blob_loc
3945: from fnd_lobs fl, fnd_attached_documents fad, fnd_documents_tl fdt

Line 3955: x_return_status := fnd_api.g_ret_sts_error;

3951: and fdt.media_id = fl.file_id
3952: and fdt.language = userenv('LANG');
3953:
3954: if l_blob_loc is null then
3955: x_return_status := fnd_api.g_ret_sts_error;
3956: oe_debug_pub.add('get_cto_item_attachment: ' || 'File attachment is null. Nothing to convert to clob... returning null', 1);
3957: return null;
3958: end if;
3959:

Line 4000: x_return_status := fnd_api.g_ret_sts_error;

3996:
3997: Exception
3998:
3999: when no_data_found then
4000: x_return_status := fnd_api.g_ret_sts_error;
4001: IF PG_DEBUG <> 0 THEN
4002: oe_debug_pub.add('get_cto_item_attachment: ' || 'no file attachment existsfor given item and org', 1);
4003: END IF;
4004: return null;

Line 4007: x_return_status := fnd_api.g_ret_sts_unexp_error;

4003: END IF;
4004: return null;
4005:
4006: when others then
4007: x_return_status := fnd_api.g_ret_sts_unexp_error;
4008: IF PG_DEBUG <> 0 THEN
4009: oe_debug_pub.add('get_cto_item_attachment: ' || 'When others exception ..' || sqlerrm, 1);
4010: END IF;
4011: return null;

Line 4041: x_return_status := FND_API.G_RET_STS_SUCCESS;

4037: l_row_id Varchar2(1000);
4038: l_stmt Number;
4039:
4040: BEGIN
4041: x_return_status := FND_API.G_RET_STS_SUCCESS;
4042:
4043: l_stmt := 10;
4044: IF PG_DEBUG <> 0 THEN
4045: oe_debug_pub.add('create_attachment: ' || 'Entering Create_attachment...',1);

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

4046:
4047: oe_debug_pub.add('create_attachment: ' || 'Attachment desc = '||p_desc,1);
4048: END IF;
4049:
4050: -- The following FND API will create a document with the given Text information.
4051:
4052: -- Creating a long text document using text
4053:
4054: fnd_documents_pkg.insert_row(

Line 4190: when FND_API.G_EXC_UNEXPECTED_ERROR then

4186:
4187:
4188: EXCEPTION
4189:
4190: when FND_API.G_EXC_UNEXPECTED_ERROR then
4191: IF PG_DEBUG <> 0 THEN
4192: oe_debug_pub.add('create_attachment: ' || 'Create_attachment::unexp error::'||l_Stmt||'::'||sqlerrm,1);
4193: END IF;
4194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4190: when FND_API.G_EXC_UNEXPECTED_ERROR then
4191: IF PG_DEBUG <> 0 THEN
4192: oe_debug_pub.add('create_attachment: ' || 'Create_attachment::unexp error::'||l_Stmt||'::'||sqlerrm,1);
4193: END IF;
4194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4195:
4196: when FND_API.G_EXC_ERROR then
4197: IF PG_DEBUG <> 0 THEN
4198: oe_debug_pub.add('create_attachment: ' || 'Create_attachment::exp error::'||l_Stmt||'::'||sqlerrm,1);

Line 4196: when FND_API.G_EXC_ERROR then

4192: oe_debug_pub.add('create_attachment: ' || 'Create_attachment::unexp error::'||l_Stmt||'::'||sqlerrm,1);
4193: END IF;
4194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4195:
4196: when FND_API.G_EXC_ERROR then
4197: IF PG_DEBUG <> 0 THEN
4198: oe_debug_pub.add('create_attachment: ' || 'Create_attachment::exp error::'||l_Stmt||'::'||sqlerrm,1);
4199: END IF;
4200: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4200: x_return_status := FND_API.G_RET_STS_ERROR;

4196: when FND_API.G_EXC_ERROR then
4197: IF PG_DEBUG <> 0 THEN
4198: oe_debug_pub.add('create_attachment: ' || 'Create_attachment::exp error::'||l_Stmt||'::'||sqlerrm,1);
4199: END IF;
4200: x_return_status := FND_API.G_RET_STS_ERROR;
4201:
4202: when others then
4203: IF PG_DEBUG <> 0 THEN
4204: oe_debug_pub.add('create_attachment: ' || 'Create_attachment::OTHERS error::'||l_Stmt||'::'||sqlerrm,1);

Line 4206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4202: when others then
4203: IF PG_DEBUG <> 0 THEN
4204: oe_debug_pub.add('create_attachment: ' || 'Create_attachment::OTHERS error::'||l_Stmt||'::'||sqlerrm,1);
4205: END IF;
4206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4207:
4208:
4209: END create_attachment;
4210:

Line 4288: x_return_status := FND_API.G_RET_STS_SUCCESS;

4284: oe_debug_pub.add('GENERATE_BOM_ATTACH_TEXT: ' || 'line_id =>'||p_line_id,1);
4285: END IF;
4286:
4287:
4288: x_return_status := FND_API.G_RET_STS_SUCCESS;
4289:
4290: l_stmt := 10;
4291:
4292: -- rkaza. 02/06/2006. bug 4938433. FP for bug 4506153:

Line 4433: when FND_API.G_EXC_UNEXPECTED_ERROR then

4429:
4430:
4431: EXCEPTION
4432:
4433: when FND_API.G_EXC_UNEXPECTED_ERROR then
4434: IF PG_DEBUG <> 0 THEN
4435: oe_debug_pub.add('GENERATE_BOM_ATTACH_TEXT: ' || 'GENERATE_BOM_ATTACH_TEXT::unexp error::'||l_Stmt||sqlerrm,1);
4436: END IF;
4437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4433: when FND_API.G_EXC_UNEXPECTED_ERROR then
4434: IF PG_DEBUG <> 0 THEN
4435: oe_debug_pub.add('GENERATE_BOM_ATTACH_TEXT: ' || 'GENERATE_BOM_ATTACH_TEXT::unexp error::'||l_Stmt||sqlerrm,1);
4436: END IF;
4437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4438:
4439: when FND_API.G_EXC_ERROR then
4440: IF PG_DEBUG <> 0 THEN
4441: oe_debug_pub.add('GENERATE_BOM_ATTACH_TEXT: ' || 'GENERATE_BOM_ATTACH_TEXT::exp error::'||l_Stmt||sqlerrm,1);

Line 4439: when FND_API.G_EXC_ERROR then

4435: oe_debug_pub.add('GENERATE_BOM_ATTACH_TEXT: ' || 'GENERATE_BOM_ATTACH_TEXT::unexp error::'||l_Stmt||sqlerrm,1);
4436: END IF;
4437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4438:
4439: when FND_API.G_EXC_ERROR then
4440: IF PG_DEBUG <> 0 THEN
4441: oe_debug_pub.add('GENERATE_BOM_ATTACH_TEXT: ' || 'GENERATE_BOM_ATTACH_TEXT::exp error::'||l_Stmt||sqlerrm,1);
4442: END IF;
4443: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4443: x_return_status := FND_API.G_RET_STS_ERROR;

4439: when FND_API.G_EXC_ERROR then
4440: IF PG_DEBUG <> 0 THEN
4441: oe_debug_pub.add('GENERATE_BOM_ATTACH_TEXT: ' || 'GENERATE_BOM_ATTACH_TEXT::exp error::'||l_Stmt||sqlerrm,1);
4442: END IF;
4443: x_return_status := FND_API.G_RET_STS_ERROR;
4444:
4445: --
4446: -- bug 6717456
4447: -- ntungare

Line 4459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4455: when others then
4456: IF PG_DEBUG <> 0 THEN
4457: oe_debug_pub.add('GENERATE_BOM_ATTACH_TEXT: ' || 'GENERATE_BOM_ATTACH_TEXT::OTHERS error::'||l_Stmt||sqlerrm,1);
4458: END IF;
4459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4460:
4461: END GENERATE_BOM_ATTACH_TEXT;
4462:
4463:

Line 4570: x_return_status := FND_API.G_RET_STS_SUCCESS;

4566:
4567: IF PG_DEBUG <> 0 THEN
4568: oe_debug_pub.add('chk_all_rsv_details: ' || 'Entered CTO_UTILITY_PK.chk_all_rsv_details',1);
4569: END IF;
4570: x_return_status := FND_API.G_RET_STS_SUCCESS;
4571:
4572:
4573: l_stmt := 111;
4574: OPEN c_rsv_details;

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

4607:
4608: EXIT WHEN l_index = p_rsv_details.LAST;
4609: l_index := p_rsv_details.NEXT(l_index);
4610: END LOOP;
4611: x_return_status := FND_API.G_RET_STS_SUCCESS;--resv exists
4612: ELSE
4613: --no reservation exists
4614: x_return_status := FND_API.G_FALSE;
4615:

Line 4614: x_return_status := FND_API.G_FALSE;

4610: END LOOP;
4611: x_return_status := FND_API.G_RET_STS_SUCCESS;--resv exists
4612: ELSE
4613: --no reservation exists
4614: x_return_status := FND_API.G_FALSE;
4615:
4616: END IF;
4617:
4618:

Line 4625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4621:
4622:
4623: EXCEPTION
4624: when others then
4625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4626: IF PG_DEBUG <> 0 THEN
4627: oe_debug_pub.add ('chk_all_rsv_details: ' || 'unexpected error in called program chk_all_rsv_details'|| l_stmt||sqlerrm , 1);
4628: END IF;
4629: if fnd_msg_pub.check_msg_level

Line 4726: IF x_return_status = FND_API.G_RET_STS_ERROR

4722: oe_debug_pub.add('isModelMLMO: ' || ' after get model source status ' || x_return_status, 4 );
4723: END IF;
4724:
4725:
4726: IF x_return_status = FND_API.G_RET_STS_ERROR
4727: THEN
4728:
4729: RAISE FND_API.G_EXC_ERROR;
4730: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

Line 4729: RAISE FND_API.G_EXC_ERROR;

4725:
4726: IF x_return_status = FND_API.G_RET_STS_ERROR
4727: THEN
4728:
4729: RAISE FND_API.G_EXC_ERROR;
4730: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4731: THEN
4732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4733: END IF;

Line 4730: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

4726: IF x_return_status = FND_API.G_RET_STS_ERROR
4727: THEN
4728:
4729: RAISE FND_API.G_EXC_ERROR;
4730: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4731: THEN
4732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4733: END IF;
4734:

Line 4732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4728:
4729: RAISE FND_API.G_EXC_ERROR;
4730: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4731: THEN
4732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4733: END IF;
4734:
4735:
4736: if( FND_API.to_boolean( x_sourcing_rule_exists ) ) then

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

4732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4733: END IF;
4734:
4735:
4736: if( FND_API.to_boolean( x_sourcing_rule_exists ) ) then
4737: return 1;
4738: end if ;
4739:
4740:

Line 5294: x_return_status := FND_API.G_RET_STS_SUCCESS;

5290: l_exp_error_code NUMBER;
5291:
5292:
5293: BEGIN
5294: x_return_status := FND_API.G_RET_STS_SUCCESS;
5295: x_can_create_supply := 'Y';
5296:
5297: IF PG_DEBUG <> 0 THEN
5298: oe_debug_pub.add('check_cto_can_create_supply : ' ||'ENTERED',1);

Line 5326: IF X_return_status = FND_API.G_RET_STS_SUCCESS

5322:
5323: );
5324:
5325: lStmtNum:=30;
5326: IF X_return_status = FND_API.G_RET_STS_SUCCESS
5327: and
5328: X_custom_out_params_rec.can_cto_create_supply = 'Y' THEN
5329:
5330:

Line 5352: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

5348: x_return_status => x_return_status,
5349: x_exp_error_code => l_exp_error_code );
5350:
5351: lStmtNum:=50;
5352: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
5353: IF PG_DEBUG <> 0 THEN
5354: oe_debug_pub.add('check_cto_can_create_supply : '
5355: ||'success from query sourcing org',5);
5356: END IF;

Line 5393: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5389: END IF; --can_create = y and source_type =2
5390:
5391:
5392:
5393: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5394: IF PG_DEBUG <> 0 THEN
5395: oe_debug_pub.add('check_cto_can_create_supply : ' || 'Unexpected Error in the sourcing rule.',1);
5396: END IF;
5397: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5397: raise FND_API.G_EXC_UNEXPECTED_ERROR;

5393: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5394: IF PG_DEBUG <> 0 THEN
5395: oe_debug_pub.add('check_cto_can_create_supply : ' || 'Unexpected Error in the sourcing rule.',1);
5396: END IF;
5397: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5398:
5399: END IF;
5400:
5401: ELSIF X_return_status = FND_API.G_RET_STS_SUCCESS --cutsom API's out param

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

5397: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5398:
5399: END IF;
5400:
5401: ELSIF X_return_status = FND_API.G_RET_STS_SUCCESS --cutsom API's out param
5402: and X_custom_out_params_rec.can_cto_create_supply = 'N' THEN
5403:
5404: IF PG_DEBUG <> 0 THEN
5405: oe_debug_pub.add('check_cto_can_create_supply : '

Line 5412: ELSIF X_return_status = FND_API.G_RET_STS_ERROR THEN

5408:
5409: x_can_create_supply := 'N';
5410: x_message := 'Custom api for SUPPLY returned N';
5411:
5412: ELSIF X_return_status = FND_API.G_RET_STS_ERROR THEN
5413: RAISE FND_API.G_EXC_ERROR;
5414:
5415: ELSE
5416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5413: RAISE FND_API.G_EXC_ERROR;

5409: x_can_create_supply := 'N';
5410: x_message := 'Custom api for SUPPLY returned N';
5411:
5412: ELSIF X_return_status = FND_API.G_RET_STS_ERROR THEN
5413: RAISE FND_API.G_EXC_ERROR;
5414:
5415: ELSE
5416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5417:

Line 5416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5412: ELSIF X_return_status = FND_API.G_RET_STS_ERROR THEN
5413: RAISE FND_API.G_EXC_ERROR;
5414:
5415: ELSE
5416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5417:
5418: END IF;
5419:
5420: EXCEPTION

Line 5422: WHEN fnd_api.g_exc_error THEN

5418: END IF;
5419:
5420: EXCEPTION
5421:
5422: WHEN fnd_api.g_exc_error THEN
5423: IF PG_DEBUG <> 0 THEN
5424: oe_debug_pub.add('check_cto_can_create_supply: ' || 'Exception in stmt num: '
5425: || to_char(lStmtNum), 1);
5426: END IF;

Line 5427: x_return_status := FND_API.G_RET_STS_ERROR;

5423: IF PG_DEBUG <> 0 THEN
5424: oe_debug_pub.add('check_cto_can_create_supply: ' || 'Exception in stmt num: '
5425: || to_char(lStmtNum), 1);
5426: END IF;
5427: x_return_status := FND_API.G_RET_STS_ERROR;
5428: -- Get message count and data
5429: cto_msg_pub.count_and_get
5430: ( p_msg_count => x_msg_count
5431: , p_msg_data => x_msg_data

Line 5433: WHEN fnd_api.g_exc_unexpected_error THEN

5429: cto_msg_pub.count_and_get
5430: ( p_msg_count => x_msg_count
5431: , p_msg_data => x_msg_data
5432: );
5433: WHEN fnd_api.g_exc_unexpected_error THEN
5434: IF PG_DEBUG <> 0 THEN
5435: oe_debug_pub.add('check_cto_can_create_supply: ' || ' Unexpected Exception in stmt num: '
5436: || to_char(lStmtNum), 1);
5437: END IF;

Line 5438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5434: IF PG_DEBUG <> 0 THEN
5435: oe_debug_pub.add('check_cto_can_create_supply: ' || ' Unexpected Exception in stmt num: '
5436: || to_char(lStmtNum), 1);
5437: END IF;
5438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5439: -- Get message count and data
5440: cto_msg_pub.count_and_get
5441: ( p_msg_count => x_msg_count
5442: , p_msg_data => x_msg_data

Line 5451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5447: oe_debug_pub.add('check_cto_can_create_supply: ' || 'Others Exception in stmt num: '
5448: || to_char(lStmtNum), 1);
5449: oe_debug_pub.add('check_cto_can_create_supply: ' || 'errormsg='||sqlerrm, 1);
5450: END IF;
5451: x_return_status := FND_API.G_RET_STS_UNEXP_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 5577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5573: || to_char(lStmtNum), 1);
5574: oe_debug_pub.add('CTO_UTILITY_PK.split_line: ' || 'errormsg='||sqlerrm, 1);
5575:
5576: END IF;
5577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5578:
5579:
5580: end split_line ;
5581:

Line 5689: x_return_status := FND_API.G_RET_STS_SUCCESS;

5685: END IF;
5686: END IF;
5687:
5688: x_result := TRUE;
5689: x_return_status := FND_API.G_RET_STS_SUCCESS;
5690:
5691: EXCEPTION
5692: WHEN no_data_found THEN
5693: IF PG_DEBUG <> 0 THEN

Line 5696: x_return_status := FND_API.G_RET_STS_SUCCESS;

5692: WHEN no_data_found THEN
5693: IF PG_DEBUG <> 0 THEN
5694: oe_debug_pub.add('Reservation_Exists: ' || 'Coming out of reservation_exists procedure with FALSE...',2);
5695: END IF;
5696: x_return_status := FND_API.G_RET_STS_SUCCESS;
5697: x_result := FALSE;
5698:
5699: WHEN others THEN
5700: IF PG_DEBUG <> 0 THEN

Line 5705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5701: oe_debug_pub.add('Reservation_Exists: ' || 'OTHERS excpn occured in Reservation_Exists procedure..',2);
5702:
5703: oe_debug_pub.add('Reservation_Exists: ' || 'Error message is : '||sqlerrm,1);
5704: END IF;
5705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5706: x_result := FALSE;
5707:
5708: END Reservation_Exists;
5709:

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

6200: -- Added substr function to avoid buffer overflow error
6201:
6202: l_msg_data := substr(fnd_msg_pub.get(
6203: p_msg_index => l_index,
6204: p_encoded => FND_API.G_FALSE),1,2000);
6205:
6206: oe_debug_pub.add('CTO_UTILITY_PK.notify_expected_error: '||substr(l_msg_data,1,250));
6207:
6208: -- Fixed bug 5639511

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

6339: , x_return_status => x_return_status
6340: , x_msg_count => x_msg_count
6341: , x_msg_data => x_msg_data);
6342:
6343: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
6344: IF PG_DEBUG <> 0 THEN
6345: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with expected error.' ,1);
6346: END IF;
6347: raise FND_API.G_EXC_ERROR;

Line 6347: raise FND_API.G_EXC_ERROR;

6343: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
6344: IF PG_DEBUG <> 0 THEN
6345: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with expected error.' ,1);
6346: END IF;
6347: raise FND_API.G_EXC_ERROR;
6348:
6349: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6350: IF PG_DEBUG <> 0 THEN
6351: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with unexpected error.' ,1);

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

6345: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with expected error.' ,1);
6346: END IF;
6347: raise FND_API.G_EXC_ERROR;
6348:
6349: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6350: IF PG_DEBUG <> 0 THEN
6351: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with unexpected error.' ,1);
6352: END IF;
6353: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6353: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6349: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6350: IF PG_DEBUG <> 0 THEN
6351: oe_debug_pub.add('CTOCITMB:Failed in Apply Holds with unexpected error.' ,1);
6352: END IF;
6353: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6354: END IF;
6355:
6356: commit ; /* COMMIT FOR AUTONOMOUS TRANSACTION */
6357:

Line 6718: x_return_status := FND_API.G_RET_STS_SUCCESS ;

6714:
6715:
6716: begin
6717:
6718: x_return_status := FND_API.G_RET_STS_SUCCESS ;
6719:
6720: v_step := 'Step A17' ;
6721:
6722: --

Line 6743: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6739: if bcol_count <> oe_count then
6740: IF PG_DEBUG <> 0 THEN
6741: oe_debug_pub.add ('validate_oe_data: '||v_step||': OE count '||oe_count||' and BCOL count '||bcol_count||' does not match.');
6742: END IF;
6743: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6744: end if;
6745:
6746:
6747:

Line 6826: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6822: if( v_oe_bcol_diff = 'Y' ) then
6823: IF PG_DEBUG <> 0 THEN
6824: oe_debug_pub.add ('validate_oe_data: data in BCOL and OE_ORDER_LINES_ALL does not match' , 1);
6825: END IF;
6826: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6827: end if;
6828:
6829:
6830:

Line 6835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6831:
6832:
6833: exception
6834: when OTHERS then
6835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6836: oe_debug_pub.add('validate_oe_data: ' || 'validate_oe_data::others:: '||sqlerrm,1);
6837:
6838:
6839: end validate_oe_data ;

Line 6933: x_return_status := FND_API.G_RET_STS_SUCCESS;

6929: bcolOptions.line_id = bcolModel.line_id)
6930: order by 1;
6931:
6932: BEGIN
6933: x_return_status := FND_API.G_RET_STS_SUCCESS;
6934: x_lock_status := 0;
6935: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lock_For_Match Start Time: '||to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));
6936:
6937: OPEN c1;

Line 6943: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6939:
6940: if l_comp_item_id.count = 0 then
6941: -- This situation should never arise. If it does, raise error.
6942: oe_debug_pub.add ('l_comp_item_id.count = 0. Raising error..');
6943: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6944: end if;
6945:
6946: IF PG_DEBUG <> 0 THEN
6947: oe_debug_pub.add ('Number of records selected = '|| l_comp_item_id.count);

Line 7047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then

7043: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lock_For_Match End Time: '||to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'));
7044:
7045: EXCEPTION
7046:
7047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
7048: oe_debug_pub.add('lock_for_match: ' || 'Unexpected Error.');
7049: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
7050: -- Get message count and data
7051: cto_msg_pub.count_and_get

Line 7049: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

7045: EXCEPTION
7046:
7047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
7048: oe_debug_pub.add('lock_for_match: ' || 'Unexpected Error.');
7049: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
7050: -- Get message count and data
7051: cto_msg_pub.count_and_get
7052: ( p_msg_count => xMsgCount
7053: , p_msg_data => xMsgData

Line 7057: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

7053: , p_msg_data => xMsgData
7054: );
7055: WHEN OTHERS then
7056: oe_debug_pub.add('lock_for_match: ' || 'Others Exception : ' || sqlerrm);
7057: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
7058: -- Get message count and data
7059: cto_msg_pub.count_and_get
7060: ( p_msg_count => xMsgCount
7061: , p_msg_data => xMsgData

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

7081: , x_msg_data OUT NOCOPY VARCHAR2
7082: , p_hash_value IN VARCHAR2)
7083:
7084: IS
7085: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
7086: l_lock_handle VARCHAR2(128);
7087: l_status INTEGER;
7088:
7089:

Line 7096: RAISE fnd_api.g_exc_error;

7092: --validate hash_value
7093: IF (p_hash_value IS NULL) THEN
7094: --raise error condition
7095: oe_debug_pub.add('RELEASE_LOCK: Hash Value is null but required for releasing lock.');
7096: RAISE fnd_api.g_exc_error;
7097: END IF;
7098:
7099:
7100: --get lock handle by calling helper function

Line 7111: RAISE fnd_api.g_exc_error;

7107: -- do nothing
7108: --if parameter error or illegal lock handle (internal error)
7109: if l_status IN (3,5) THEN
7110: cto_msg_pub.cto_message('BOM','BOM_LOCK_RELEASE_ERROR');
7111: RAISE fnd_api.g_exc_error;
7112: end if;
7113:
7114: x_return_status := l_return_status;
7115:

Line 7118: WHEN fnd_api.g_exc_error THEN

7114: x_return_status := l_return_status;
7115:
7116: EXCEPTION
7117:
7118: WHEN fnd_api.g_exc_error THEN
7119: oe_debug_pub.add('release_lock: ' || 'expected error');
7120: x_return_status := fnd_api.g_ret_sts_error;
7121:
7122: WHEN fnd_api.g_exc_unexpected_error THEN

Line 7120: x_return_status := fnd_api.g_ret_sts_error;

7116: EXCEPTION
7117:
7118: WHEN fnd_api.g_exc_error THEN
7119: oe_debug_pub.add('release_lock: ' || 'expected error');
7120: x_return_status := fnd_api.g_ret_sts_error;
7121:
7122: WHEN fnd_api.g_exc_unexpected_error THEN
7123: oe_debug_pub.add('release_lock: ' || 'Unexpected error');
7124: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 7122: WHEN fnd_api.g_exc_unexpected_error THEN

7118: WHEN fnd_api.g_exc_error THEN
7119: oe_debug_pub.add('release_lock: ' || 'expected error');
7120: x_return_status := fnd_api.g_ret_sts_error;
7121:
7122: WHEN fnd_api.g_exc_unexpected_error THEN
7123: oe_debug_pub.add('release_lock: ' || 'Unexpected error');
7124: x_return_status := fnd_api.g_ret_sts_unexp_error ;
7125:
7126: WHEN OTHERS THEN

Line 7124: x_return_status := fnd_api.g_ret_sts_unexp_error ;

7120: x_return_status := fnd_api.g_ret_sts_error;
7121:
7122: WHEN fnd_api.g_exc_unexpected_error THEN
7123: oe_debug_pub.add('release_lock: ' || 'Unexpected error');
7124: x_return_status := fnd_api.g_ret_sts_unexp_error ;
7125:
7126: WHEN OTHERS THEN
7127: oe_debug_pub.add('release_lock: ' || 'Others Exception : ' || sqlerrm);
7128: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 7128: x_return_status := fnd_api.g_ret_sts_unexp_error ;

7124: x_return_status := fnd_api.g_ret_sts_unexp_error ;
7125:
7126: WHEN OTHERS THEN
7127: oe_debug_pub.add('release_lock: ' || 'Others Exception : ' || sqlerrm);
7128: x_return_status := fnd_api.g_ret_sts_unexp_error ;
7129:
7130: END release_lock;
7131:
7132:

Line 7220: x_return_status := FND_API.G_RET_STS_SUCCESS;

7216: l_int_req_secondary_qty Number;
7217:
7218: BEGIN
7219:
7220: x_return_status := FND_API.G_RET_STS_SUCCESS;
7221: --need this for flow and interface data alone
7222: Select msi.primary_uom_code
7223: into x_primary_uom_code
7224: from mtl_system_items msi,

Line 7405: WHEN fnd_api.g_exc_error THEN

7401: END LOOP;
7402:
7403:
7404: EXCEPTION
7405: WHEN fnd_api.g_exc_error THEN
7406: IF PG_DEBUG <> 0 THEN
7407: oe_debug_pub.add('get_resv_qty: ' || 'Exception in stmt num: '
7408: || to_char(lStmtNum), 1);
7409: END IF;

Line 7410: x_return_status := FND_API.G_RET_STS_ERROR;

7406: IF PG_DEBUG <> 0 THEN
7407: oe_debug_pub.add('get_resv_qty: ' || 'Exception in stmt num: '
7408: || to_char(lStmtNum), 1);
7409: END IF;
7410: x_return_status := FND_API.G_RET_STS_ERROR;
7411: -- Get message count and data
7412: cto_msg_pub.count_and_get
7413: ( p_msg_count => x_msg_count
7414: , p_msg_data => x_msg_data

Line 7416: WHEN fnd_api.g_exc_unexpected_error THEN

7412: cto_msg_pub.count_and_get
7413: ( p_msg_count => x_msg_count
7414: , p_msg_data => x_msg_data
7415: );
7416: WHEN fnd_api.g_exc_unexpected_error THEN
7417: IF PG_DEBUG <> 0 THEN
7418: oe_debug_pub.add('get_resv_qty: '|| ' Unexpected Exception in stmt num: '
7419: || to_char(lStmtNum), 1);
7420: END IF;

Line 7421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7417: IF PG_DEBUG <> 0 THEN
7418: oe_debug_pub.add('get_resv_qty: '|| ' Unexpected Exception in stmt num: '
7419: || to_char(lStmtNum), 1);
7420: END IF;
7421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7422: -- Get message count and data
7423: cto_msg_pub.count_and_get
7424: ( p_msg_count => x_msg_count
7425: , p_msg_data => x_msg_data

Line 7434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7430:
7431: oe_debug_pub.add('get_resv_qty: ' || 'Others Exception in stmt num: '
7432: || to_char(lStmtNum), 1);
7433: END IF;
7434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7435: -- Get message count and data
7436: cto_msg_pub.count_and_get
7437: ( p_msg_count => x_msg_count
7438: , p_msg_data => x_msg_data