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

Line 424: x_return_status := FND_API.G_RET_STS_SUCCESS ;

420: BEGIN
421:
422: l_stmt_num := 10 ;
423:
424: x_return_status := FND_API.G_RET_STS_SUCCESS ;
425:
426: IF PG_DEBUG <> 0 THEN
427: oe_debug_pub.add('***get_atp_bom: ' || ' Entered get_atp_bom' , 1);
428: oe_debug_pub.add('get_atp_bom: ' || ' identifier ' || p_shipset.identifier.count || ' inventory ' || p_shipset.inventory_item_id.count || ' ship_set_name ' || p_shipset.ship_set_name.count, 3);

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

442:
443: /* get assignment set and check its validity */
444: initialize_assignment_set( x_return_status ) ;
445:
446: IF( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
447: FOR l_error_loc IN
448: p_shipset.ship_set_name.first..p_shipset.ship_set_name.last
449: LOOP
450: p_shipset.error_code(l_error_loc) := 65 ;

Line 452: RAISE FND_API.G_EXC_ERROR ;

448: p_shipset.ship_set_name.first..p_shipset.ship_set_name.last
449: LOOP
450: p_shipset.error_code(l_error_loc) := 65 ;
451: END LOOP ;
452: RAISE FND_API.G_EXC_ERROR ;
453: ELSIF( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
455: END IF ;
456:

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

449: LOOP
450: p_shipset.error_code(l_error_loc) := 65 ;
451: END LOOP ;
452: RAISE FND_API.G_EXC_ERROR ;
453: ELSIF( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
455: END IF ;
456:
457: l_stmt_num := 90 ;

Line 454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

450: p_shipset.error_code(l_error_loc) := 65 ;
451: END LOOP ;
452: RAISE FND_API.G_EXC_ERROR ;
453: ELSIF( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
455: END IF ;
456:
457: l_stmt_num := 90 ;
458:

Line 624: IF( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

620: /*
621: ** perform all cleanup operations in case of an expected error
622: ** no cleanup is required for unexpected error
623: */
624: IF( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
625:
626: l_stmt_num := 205 ;
627:
628: /*

Line 660: RAISE FND_API.G_EXC_ERROR ;

656: p_shipset,
657: l_return_status );
658: END LOOP ;
659:
660: RAISE FND_API.G_EXC_ERROR ;
661:
662: ELSIF( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
663:
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 662: ELSIF( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

658: END LOOP ;
659:
660: RAISE FND_API.G_EXC_ERROR ;
661:
662: ELSIF( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
663:
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
665: /*
666: ** END of cleanup operation for expected error

Line 664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

660: RAISE FND_API.G_EXC_ERROR ;
661:
662: ELSIF( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
663:
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
665: /*
666: ** END of cleanup operation for expected error
667: */
668: END IF ;

Line 829: IF( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

825: IF PG_DEBUG <> 0 THEN
826: oe_debug_pub.add('get_atp_bom: ' || 'Evaluate shipset returned ' || l_return_status ,1);
827: END IF;
828:
829: IF( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
830:
831: l_stmt_num := 445 ;
832:
833: FOR k IN v_shipset.ship_set_name.first..v_shipset.ship_set_name.last

Line 863: RAISE FND_API.G_EXC_ERROR ;

859: print_shipset( p_shipset ) ;
860: oe_debug_pub.add('get_atp_bom: ' || ' going to raise expected error ' , 1 );
861: END IF;
862:
863: RAISE FND_API.G_EXC_ERROR ;
864:
865: ELSIF( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
867: END IF ;

Line 865: ELSIF( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

861: END IF;
862:
863: RAISE FND_API.G_EXC_ERROR ;
864:
865: ELSIF( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
867: END IF ;
868:
869: l_stmt_num := 460 ;

Line 866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

862:
863: RAISE FND_API.G_EXC_ERROR ;
864:
865: ELSIF( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
867: END IF ;
868:
869: l_stmt_num := 460 ;
870:

Line 1017: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1013: l_stmt_num := 680 ;
1014: print_shipset( p_shipset ) ;
1015: END IF;
1016:
1017: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1018:
1019: IF PG_DEBUG <> 0 THEN
1020: oe_debug_pub.add('get_atp_bom: ' || ' Done get atp bom' , 1 );
1021: END IF;

Line 1024: WHEN FND_API.G_EXC_ERROR THEN

1020: oe_debug_pub.add('get_atp_bom: ' || ' Done get atp bom' , 1 );
1021: END IF;
1022:
1023: EXCEPTION
1024: WHEN FND_API.G_EXC_ERROR THEN
1025: IF PG_DEBUG <> 0 THEN
1026: oe_debug_pub.add('get_atp_bom: ' || 'GET_ATP_BOM_PUB::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1027: oe_debug_pub.add('get_atp_bom: ' || ' Printing shipset to show exp error ' , 2 );
1028: END IF;

Line 1029: x_return_status := FND_API.G_RET_STS_ERROR;

1025: IF PG_DEBUG <> 0 THEN
1026: oe_debug_pub.add('get_atp_bom: ' || 'GET_ATP_BOM_PUB::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1027: oe_debug_pub.add('get_atp_bom: ' || ' Printing shipset to show exp error ' , 2 );
1028: END IF;
1029: x_return_status := FND_API.G_RET_STS_ERROR;
1030:
1031: print_shipset( p_shipset ) ;
1032:
1033: FND_MSG_PUB.Count_And_Get(

Line 1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1034: p_count => x_msg_count
1035: , p_data => x_msg_data
1036: );
1037:
1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1039: IF PG_DEBUG <> 0 THEN
1040: oe_debug_pub.add('get_atp_bom: ' || 'GET_ATP_BOM_PUB::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1041: END IF;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1039: IF PG_DEBUG <> 0 THEN
1040: oe_debug_pub.add('get_atp_bom: ' || 'GET_ATP_BOM_PUB::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1041: END IF;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: FND_MSG_PUB.Count_And_Get(
1044: p_count => x_msg_count
1045: , p_data => x_msg_data
1046: );

Line 1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1048: WHEN OTHERS THEN
1049: IF PG_DEBUG <> 0 THEN
1050: oe_debug_pub.add('get_atp_bom: ' || 'GET_ATP_BOM_PUB::others::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
1051: END IF;
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1053: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1054: FND_MSG_PUB.Add_Exc_Msg(
1055: G_PKG_NAME
1056: , 'GET_ATP_BOM_PUB'

Line 1156: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1152:
1153: l_stmt_num := 10 ;
1154:
1155: p_model_sourced := FALSE ;
1156: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1157: local_cto_shipset.delete ;
1158:
1159: /*
1160: ** evaluate call from OM or CZ

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

1216: END IF;
1217:
1218: l_stmt_num := 120 ;
1219:
1220: IF( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1221: RAISE FND_API.G_EXC_ERROR ;
1222: ELSIF( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1224: END IF ;

Line 1221: RAISE FND_API.G_EXC_ERROR ;

1217:
1218: l_stmt_num := 120 ;
1219:
1220: IF( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1221: RAISE FND_API.G_EXC_ERROR ;
1222: ELSIF( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1224: END IF ;
1225:

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

1218: l_stmt_num := 120 ;
1219:
1220: IF( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1221: RAISE FND_API.G_EXC_ERROR ;
1222: ELSIF( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1224: END IF ;
1225:
1226: ELSIF ( v_call_from = 'CZ' ) THEN

Line 1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1219:
1220: IF( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1221: RAISE FND_API.G_EXC_ERROR ;
1222: ELSIF( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1224: END IF ;
1225:
1226: ELSIF ( v_call_from = 'CZ' ) THEN
1227: IF PG_DEBUG <> 0 THEN

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

1240: oe_debug_pub.add('evaluate_shipset: ' || 'Returned from populate cz shipset:: '||x_return_status, 4);
1241: END IF;
1242: l_stmt_num := 180 ;
1243:
1244: IF( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1245: RAISE FND_API.G_EXC_ERROR ;
1246: ELSIF( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1248: END IF ;

Line 1245: RAISE FND_API.G_EXC_ERROR ;

1241: END IF;
1242: l_stmt_num := 180 ;
1243:
1244: IF( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1245: RAISE FND_API.G_EXC_ERROR ;
1246: ELSIF( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1248: END IF ;
1249:

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

1242: l_stmt_num := 180 ;
1243:
1244: IF( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1245: RAISE FND_API.G_EXC_ERROR ;
1246: ELSIF( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1248: END IF ;
1249:
1250: END IF ;

Line 1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1243:
1244: IF( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1245: RAISE FND_API.G_EXC_ERROR ;
1246: ELSIF( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1248: END IF ;
1249:
1250: END IF ;
1251:

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

1520: ) ;
1521:
1522: l_stmt_num := 540 ;
1523:
1524: IF( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1525: l_stmt_num := 545 ;
1526: IF( local_cto_shipset.count > 0 ) THEN
1527: l_stmt_num := 550 ;
1528: FOR l_lcs_count IN local_cto_shipset.first..local_cto_shipset.last

Line 1549: RAISE FND_API.G_EXC_ERROR ;

1545: x_return_status);
1546:
1547: l_stmt_num := 557 ;
1548: populate_error( p_shipset , x_return_status ) ;
1549: RAISE FND_API.G_EXC_ERROR ;
1550: ELSIF( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1552: END IF ;
1553:

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

1546:
1547: l_stmt_num := 557 ;
1548: populate_error( p_shipset , x_return_status ) ;
1549: RAISE FND_API.G_EXC_ERROR ;
1550: ELSIF( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1552: END IF ;
1553:
1554: IF( local_cto_shipset(i).sourced_components )

Line 1551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1547: l_stmt_num := 557 ;
1548: populate_error( p_shipset , x_return_status ) ;
1549: RAISE FND_API.G_EXC_ERROR ;
1550: ELSIF( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1552: END IF ;
1553:
1554: IF( local_cto_shipset(i).sourced_components )
1555: THEN

Line 1895: IF( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

1891: , l_msg_count
1892: );
1893:
1894: l_stmt_num := 880 ;
1895: IF( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1896: populate_error( p_shipset , l_return_status ) ;
1897: RAISE FND_API.G_EXC_ERROR ;
1898: ELSIF( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 1897: RAISE FND_API.G_EXC_ERROR ;

1893:
1894: l_stmt_num := 880 ;
1895: IF( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1896: populate_error( p_shipset , l_return_status ) ;
1897: RAISE FND_API.G_EXC_ERROR ;
1898: ELSIF( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1900: END IF ;
1901:

Line 1898: ELSIF( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

1894: l_stmt_num := 880 ;
1895: IF( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1896: populate_error( p_shipset , l_return_status ) ;
1897: RAISE FND_API.G_EXC_ERROR ;
1898: ELSIF( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1900: END IF ;
1901:
1902: IF PG_DEBUG <> 0 THEN

Line 1899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1895: IF( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1896: populate_error( p_shipset , l_return_status ) ;
1897: RAISE FND_API.G_EXC_ERROR ;
1898: ELSIF( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1900: END IF ;
1901:
1902: IF PG_DEBUG <> 0 THEN
1903: oe_debug_pub.add('evaluate_shipset: ' || ' Create ATP BOM information ' , 4 );

Line 2052: WHEN FND_API.G_EXC_ERROR THEN

2048: */
2049: p_shipset := v_shipset ;
2050:
2051: EXCEPTION
2052: WHEN FND_API.G_EXC_ERROR THEN
2053: IF PG_DEBUG <> 0 THEN
2054: oe_debug_pub.add('evaluate_shipset: ' || ':exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2055: END IF;
2056: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2056: x_return_status := FND_API.G_RET_STS_ERROR;

2052: WHEN FND_API.G_EXC_ERROR THEN
2053: IF PG_DEBUG <> 0 THEN
2054: oe_debug_pub.add('evaluate_shipset: ' || ':exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2055: END IF;
2056: x_return_status := FND_API.G_RET_STS_ERROR;
2057: FND_MSG_PUB.Count_And_Get(
2058: p_count => x_msg_count
2059: , p_data => x_msg_data
2060: );

Line 2061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2057: FND_MSG_PUB.Count_And_Get(
2058: p_count => x_msg_count
2059: , p_data => x_msg_data
2060: );
2061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2062: IF PG_DEBUG <> 0 THEN
2063: oe_debug_pub.add('evaluate_shipset: ' || ':unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2064: END IF;
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2062: IF PG_DEBUG <> 0 THEN
2063: oe_debug_pub.add('evaluate_shipset: ' || ':unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2064: END IF;
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066: FND_MSG_PUB.Count_And_Get(
2067: p_count => x_msg_count
2068: , p_data => x_msg_data
2069: );

Line 2074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2070: WHEN OTHERS THEN
2071: IF PG_DEBUG <> 0 THEN
2072: oe_debug_pub.add('evaluate_shipset: ' || ':others::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2073: END IF;
2074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2075: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2076: FND_MSG_PUB.Add_Exc_Msg(
2077: G_PKG_NAME
2078: , 'EVALUATE_SHIPSET'

Line 2237: RAISE FND_API.G_EXC_ERROR ;

2233: ** for TYPE 'MTL_DEMAND_INTERFACE_ERRORS'
2234: */
2235: END LOOP ;
2236:
2237: RAISE FND_API.G_EXC_ERROR ;
2238: END IF ;
2239:
2240: --- We re storing the l_validation_org value in pkg variable,which will be used
2241: --- in BOM creation module to get the calendar code for validation org.

Line 2357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2353: oe_debug_pub.add('populate_cz_shipset: ' || 'No data found for bill sequence id ' , 2 );
2354: END IF;
2355: v_bill_sequence_id := null ;
2356: WHEN others THEN
2357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2358: END ;
2359:
2360: l_stmt_num := 44 ;
2361: IF( g_requests_tab(j).bom_item_type = '1' ) THEN

Line 2390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2386: IF PG_DEBUG <> 0 THEN
2387: oe_debug_pub.add('populate_cz_shipset: ' || ' other error raise ' || SQLCODE ,2 );
2388: oe_debug_pub.add('populate_cz_shipset: ' || ' other error raise ' || SQLERRM ,2 );
2389: END IF;
2390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2391: END ;
2392:
2393: END IF ;
2394: END LOOP ;

Line 2499: WHEN FND_API.G_EXC_ERROR THEN

2495: END IF;
2496:
2497:
2498: EXCEPTION
2499: WHEN FND_API.G_EXC_ERROR THEN
2500: IF PG_DEBUG <> 0 THEN
2501: oe_debug_pub.add('populate_cz_shipset: ' || 'POPULATE_CZ_SHIPSET::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2502: END IF;
2503: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2503: x_return_status := FND_API.G_RET_STS_ERROR;

2499: WHEN FND_API.G_EXC_ERROR THEN
2500: IF PG_DEBUG <> 0 THEN
2501: oe_debug_pub.add('populate_cz_shipset: ' || 'POPULATE_CZ_SHIPSET::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2502: END IF;
2503: x_return_status := FND_API.G_RET_STS_ERROR;
2504: FND_MSG_PUB.Count_And_Get(
2505: p_count => x_msg_count
2506: , p_data => x_msg_data
2507: );

Line 2508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2504: FND_MSG_PUB.Count_And_Get(
2505: p_count => x_msg_count
2506: , p_data => x_msg_data
2507: );
2508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2509: IF PG_DEBUG <> 0 THEN
2510: oe_debug_pub.add('populate_cz_shipset: ' || 'POPULATE_CZ_SHIPSET::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2511: END IF;
2512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2509: IF PG_DEBUG <> 0 THEN
2510: oe_debug_pub.add('populate_cz_shipset: ' || 'POPULATE_CZ_SHIPSET::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2511: END IF;
2512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2513: FND_MSG_PUB.Count_And_Get(
2514: p_count => x_msg_count
2515: , p_data => x_msg_data
2516: );

Line 2521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2517: WHEN OTHERS THEN
2518: IF PG_DEBUG <> 0 THEN
2519: oe_debug_pub.add('populate_cz_shipset: ' || 'POPULATE_CZ_SHIPSET::others::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2520: END IF;
2521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2522: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2523: FND_MSG_PUB.Add_Exc_Msg(
2524: G_PKG_NAME
2525: , 'POPULATE_CZ_SHIPSET'

Line 2552: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2548: l_stmt_num := 1 ;
2549: IF PG_DEBUG <> 0 THEN
2550: oe_debug_pub.add('populate_om_shipset: ' || ' In populate om shipset ' , 1 );
2551: END IF;
2552: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2553: p_shipset_contains_model := FALSE ;
2554:
2555: /*
2556: ** Find Validation Organization

Line 2572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2568: WHEN NO_DATA_FOUND THEN
2569: l_validation_org := -99 ; --bugfix 2646849: changed from null to -99
2570:
2571: WHEN OTHERS THEN
2572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2573: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2574: END ;
2575:
2576: l_stmt_num := 6 ;

Line 2573: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2569: l_validation_org := -99 ; --bugfix 2646849: changed from null to -99
2570:
2571: WHEN OTHERS THEN
2572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2573: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2574: END ;
2575:
2576: l_stmt_num := 6 ;
2577: IF( l_validation_org = -99 ) THEN --bugfix 2646849: changed from null to -99

Line 2586: RAISE FND_API.G_EXC_ERROR ;

2582: /* error code for Invalid Validation Org seeded in MFG_LOOKUPS
2583: ** for TYPE 'MTL_DEMAND_INTERFACE_ERRORS'
2584: */
2585: END LOOP ;
2586: RAISE FND_API.G_EXC_ERROR ;
2587:
2588: END IF ;
2589:
2590: --- We re storing the l_validation_org value in pkg variable,which will be used

Line 2704: WHEN FND_API.G_EXC_ERROR THEN

2700: show_contents( p_orig_shipset_tracker ) ;
2701: END IF;
2702:
2703: EXCEPTION
2704: WHEN FND_API.G_EXC_ERROR THEN
2705: IF PG_DEBUG <> 0 THEN
2706: oe_debug_pub.add('populate_om_shipset: ' || 'POPULATE_OM_SHIPSET::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2707: END IF;
2708: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2708: x_return_status := FND_API.G_RET_STS_ERROR;

2704: WHEN FND_API.G_EXC_ERROR THEN
2705: IF PG_DEBUG <> 0 THEN
2706: oe_debug_pub.add('populate_om_shipset: ' || 'POPULATE_OM_SHIPSET::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2707: END IF;
2708: x_return_status := FND_API.G_RET_STS_ERROR;
2709: FND_MSG_PUB.Count_And_Get(
2710: p_count => x_msg_count
2711: , p_data => x_msg_data
2712: );

Line 2713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2709: FND_MSG_PUB.Count_And_Get(
2710: p_count => x_msg_count
2711: , p_data => x_msg_data
2712: );
2713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2714: IF PG_DEBUG <> 0 THEN
2715: oe_debug_pub.add('populate_om_shipset: ' || 'POPULATE_OM_SHIPSET::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2716: END IF;
2717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2714: IF PG_DEBUG <> 0 THEN
2715: oe_debug_pub.add('populate_om_shipset: ' || 'POPULATE_OM_SHIPSET::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2716: END IF;
2717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2718: FND_MSG_PUB.Count_And_Get(
2719: p_count => x_msg_count
2720: , p_data => x_msg_data
2721: );

Line 2726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2722: WHEN OTHERS THEN
2723: IF PG_DEBUG <> 0 THEN
2724: oe_debug_pub.add('populate_om_shipset: ' || 'POPULATE_OM_SHIPSET::others::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2725: END IF;
2726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2727: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2728: FND_MSG_PUB.Add_Exc_Msg(
2729: G_PKG_NAME
2730: , 'POPULATE_OM_SHIPSET'

Line 2773: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2769:
2770: l_stmt_num := 1 ;
2771: v_new_org := p_org ;
2772: v_model_line_id := local_cto_shipset(p_location).line_id ;
2773: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2774:
2775: IF PG_DEBUG <> 0 THEN
2776: oe_debug_pub.add('process_sourcing_chain: ' || ' p_top_location is '|| to_char(p_top_location) , 5 );
2777: oe_debug_pub.add('process_sourcing_chain: ' || ' p_location is '|| to_char(p_location) , 5 );

Line 2821: IF x_return_status = FND_API.G_RET_STS_ERROR

2817:
2818: g_expected_error_code := x_exp_error_code;
2819:
2820: l_stmt_num := 30 ;
2821: IF x_return_status = FND_API.G_RET_STS_ERROR
2822: THEN
2823: RAISE FND_API.G_EXC_ERROR;
2824: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2825: THEN

Line 2823: RAISE FND_API.G_EXC_ERROR;

2819:
2820: l_stmt_num := 30 ;
2821: IF x_return_status = FND_API.G_RET_STS_ERROR
2822: THEN
2823: RAISE FND_API.G_EXC_ERROR;
2824: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2825: THEN
2826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2827: END IF;

Line 2824: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2820: l_stmt_num := 30 ;
2821: IF x_return_status = FND_API.G_RET_STS_ERROR
2822: THEN
2823: RAISE FND_API.G_EXC_ERROR;
2824: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2825: THEN
2826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2827: END IF;
2828: ELSE /* assignment set is null */

Line 2826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2822: THEN
2823: RAISE FND_API.G_EXC_ERROR;
2824: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2825: THEN
2826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2827: END IF;
2828: ELSE /* assignment set is null */
2829: IF PG_DEBUG <> 0 THEN
2830: oe_debug_pub.add('process_sourcing_chain: ' || '***$$$ Going to check Planning type attribute as assignment set is null ' , 3 );

Line 2861: IF( FND_API.to_boolean( v_sourcing_rule_exists ) )

2857: local_cto_shipset(p_top_location).sourced_components := TRUE ;
2858: local_cto_shipset(p_location).sourced_components := TRUE ; --bug2803895
2859: ELSE
2860: local_cto_shipset(p_location).buy_model := 'N' ;
2861: IF( FND_API.to_boolean( v_sourcing_rule_exists ) )
2862: THEN
2863: local_cto_shipset(p_location).sourcing_org := v_new_org ;
2864: local_cto_shipset(p_top_location).sourced_components := TRUE ;
2865: local_cto_shipset(p_location).sourced_components := TRUE ; --bug2803895

Line 2925: IF x_return_status = FND_API.G_RET_STS_ERROR

2921: , x_return_status
2922: ) ;
2923:
2924: l_stmt_num := 90 ;
2925: IF x_return_status = FND_API.G_RET_STS_ERROR
2926: THEN
2927: RAISE FND_API.G_EXC_ERROR;
2928: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2929: THEN

Line 2927: RAISE FND_API.G_EXC_ERROR;

2923:
2924: l_stmt_num := 90 ;
2925: IF x_return_status = FND_API.G_RET_STS_ERROR
2926: THEN
2927: RAISE FND_API.G_EXC_ERROR;
2928: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2929: THEN
2930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2931: END IF;

Line 2928: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2924: l_stmt_num := 90 ;
2925: IF x_return_status = FND_API.G_RET_STS_ERROR
2926: THEN
2927: RAISE FND_API.G_EXC_ERROR;
2928: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2929: THEN
2930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2931: END IF;
2932: END IF ;

Line 2930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2926: THEN
2927: RAISE FND_API.G_EXC_ERROR;
2928: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2929: THEN
2930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2931: END IF;
2932: END IF ;
2933: END LOOP ;
2934: EXCEPTION

Line 2935: WHEN FND_API.G_EXC_ERROR THEN

2931: END IF;
2932: END IF ;
2933: END LOOP ;
2934: EXCEPTION
2935: WHEN FND_API.G_EXC_ERROR THEN
2936: IF PG_DEBUG <> 0 THEN
2937: oe_debug_pub.add('process_sourcing_chain: ' || 'PROCESS_SOURCING_CHAIN::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2938: END IF;
2939: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2939: x_return_status := FND_API.G_RET_STS_ERROR;

2935: WHEN FND_API.G_EXC_ERROR THEN
2936: IF PG_DEBUG <> 0 THEN
2937: oe_debug_pub.add('process_sourcing_chain: ' || 'PROCESS_SOURCING_CHAIN::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2938: END IF;
2939: x_return_status := FND_API.G_RET_STS_ERROR;
2940: FND_MSG_PUB.Count_And_Get(
2941: p_count => x_msg_count
2942: , p_data => x_msg_data
2943: );

Line 2944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2940: FND_MSG_PUB.Count_And_Get(
2941: p_count => x_msg_count
2942: , p_data => x_msg_data
2943: );
2944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2945: IF PG_DEBUG <> 0 THEN
2946: oe_debug_pub.add('process_sourcing_chain: ' || 'PROCESS_SOURCING_CHAIN::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2947: END IF;
2948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2945: IF PG_DEBUG <> 0 THEN
2946: oe_debug_pub.add('process_sourcing_chain: ' || 'PROCESS_SOURCING_CHAIN::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2947: END IF;
2948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2949: FND_MSG_PUB.Count_And_Get(
2950: p_count => x_msg_count
2951: , p_data => x_msg_data
2952: );

Line 2957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2953: WHEN OTHERS THEN
2954: IF PG_DEBUG <> 0 THEN
2955: oe_debug_pub.add('process_sourcing_chain: ' || 'PROCESS_SOURCING_CHAIN::others::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
2956: END IF;
2957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2958: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2959: FND_MSG_PUB.Add_Exc_Msg(
2960: G_PKG_NAME
2961: , 'PROCESS_SOURCING_CHAIN'

Line 3004: p_sourcing_rule_exists := FND_API.G_FALSE ;

3000:
3001: BEGIN
3002: l_stmt_num := 1;
3003:
3004: p_sourcing_rule_exists := FND_API.G_FALSE ;
3005: p_transit_lead_time := 0 ;
3006: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3007: v_organization_id := p_organization_id ;
3008: v_transit_lead_time := 0 ;

Line 3006: x_return_status := FND_API.G_RET_STS_SUCCESS ;

3002: l_stmt_num := 1;
3003:
3004: p_sourcing_rule_exists := FND_API.G_FALSE ;
3005: p_transit_lead_time := 0 ;
3006: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3007: v_organization_id := p_organization_id ;
3008: v_transit_lead_time := 0 ;
3009: v_circular_sourcing := FALSE ;
3010: v_orgs_tbl.delete ; /* reinitialize table to check circular sourcing */

Line 3044: IF x_return_status = FND_API.G_RET_STS_ERROR

3040: , x_return_status
3041: ) ;
3042:
3043: l_stmt_num := 40 ;
3044: IF x_return_status = FND_API.G_RET_STS_ERROR
3045: THEN
3046: RAISE FND_API.G_EXC_ERROR;
3047: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3048: THEN

Line 3046: RAISE FND_API.G_EXC_ERROR;

3042:
3043: l_stmt_num := 40 ;
3044: IF x_return_status = FND_API.G_RET_STS_ERROR
3045: THEN
3046: RAISE FND_API.G_EXC_ERROR;
3047: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3048: THEN
3049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3050: END IF;

Line 3047: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

3043: l_stmt_num := 40 ;
3044: IF x_return_status = FND_API.G_RET_STS_ERROR
3045: THEN
3046: RAISE FND_API.G_EXC_ERROR;
3047: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3048: THEN
3049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3050: END IF;
3051:

Line 3049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3045: THEN
3046: RAISE FND_API.G_EXC_ERROR;
3047: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3048: THEN
3049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3050: END IF;
3051:
3052: p_source_type := v_source_type ;
3053: IF( v_source_type = '3' ) THEN

Line 3056: IF( FND_API.to_boolean( v_sourcing_rule_exists ) ) THEN

3052: p_source_type := v_source_type ;
3053: IF( v_source_type = '3' ) THEN
3054: exit ;
3055: ELSE
3056: IF( FND_API.to_boolean( v_sourcing_rule_exists ) ) THEN
3057: p_sourcing_rule_exists := 'T' ;
3058: ELSE
3059: exit ; /* always exit when no more sourcing rules to cascade */
3060: END IF ;

Line 3080: RAISE FND_API.G_EXC_ERROR;

3076: g_expected_error_code := 66 ;
3077: IF PG_DEBUG <> 0 THEN
3078: oe_debug_pub.add('get_model_sourcing_org: ' || '***Circular sourcing error ' , 1 );
3079: END IF;
3080: RAISE FND_API.G_EXC_ERROR;
3081: END IF ;
3082:
3083: p_sourcing_org := v_organization_id ;
3084: IF PG_DEBUG <> 0 THEN

Line 3089: WHEN FND_API.G_EXC_ERROR THEN

3085: oe_debug_pub.add('get_model_sourcing_org: ' || 'Sourcing org is ' || p_sourcing_org || ' lead time ' || to_char( p_transit_lead_time ) , 2 );
3086: END IF;
3087:
3088: EXCEPTION
3089: WHEN FND_API.G_EXC_ERROR THEN
3090: IF PG_DEBUG <> 0 THEN
3091: oe_debug_pub.add('get_model_sourcing_org: ' || 'GET_MODEL_SOURCING_ORG::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3092: END IF;
3093: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3093: x_return_status := FND_API.G_RET_STS_ERROR;

3089: WHEN FND_API.G_EXC_ERROR THEN
3090: IF PG_DEBUG <> 0 THEN
3091: oe_debug_pub.add('get_model_sourcing_org: ' || 'GET_MODEL_SOURCING_ORG::exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3092: END IF;
3093: x_return_status := FND_API.G_RET_STS_ERROR;
3094:
3095: FND_MSG_PUB.Count_And_Get(
3096: p_count => x_msg_count
3097: , p_data => x_msg_data

Line 3100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3096: p_count => x_msg_count
3097: , p_data => x_msg_data
3098: );
3099:
3100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3101: IF PG_DEBUG <> 0 THEN
3102: oe_debug_pub.add('get_model_sourcing_org: ' || 'GET_MODEL_SOURCING_ORG::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3103: END IF;
3104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3101: IF PG_DEBUG <> 0 THEN
3102: oe_debug_pub.add('get_model_sourcing_org: ' || 'GET_MODEL_SOURCING_ORG::unexp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3103: END IF;
3104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3105:
3106: FND_MSG_PUB.Count_And_Get(
3107: p_count => x_msg_count
3108: , p_data => x_msg_data

Line 3115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3111: WHEN OTHERS THEN
3112: IF PG_DEBUG <> 0 THEN
3113: oe_debug_pub.add('get_model_sourcing_org: ' || 'GET_MODEL_SOURCING_ORG::others::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3114: END IF;
3115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3116:
3117: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3118: FND_MSG_PUB.Add_Exc_Msg(
3119: G_PKG_NAME

Line 3155: p_sourcing_rule_exists := FND_API.G_FALSE ;

3151: ** This routine should consider no data found or one make at sourcing rule
3152: ** as no sourcing rule exist.
3153: */
3154: l_stmt_num := 1 ;
3155: p_sourcing_rule_exists := FND_API.G_FALSE ;
3156: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3157: p_transit_lead_time := 0 ;
3158:
3159: /*

Line 3156: x_return_status := FND_API.G_RET_STS_SUCCESS ;

3152: ** as no sourcing rule exist.
3153: */
3154: l_stmt_num := 1 ;
3155: p_sourcing_rule_exists := FND_API.G_FALSE ;
3156: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3157: p_transit_lead_time := 0 ;
3158:
3159: /*
3160: ** Fix for Bug 1610583

Line 3198: p_sourcing_rule_exists := FND_API.G_TRUE ;

3194: l_stmt_num := 20 ;
3195: p_source_type := v_source_type ;
3196:
3197: IF( v_source_type = 1 ) THEN
3198: p_sourcing_rule_exists := FND_API.G_TRUE ;
3199: ELSIF v_source_type = 3 THEN
3200: IF PG_DEBUG <> 0 THEN
3201: oe_debug_pub.add('query_sourcing_org: ' || 'Buy Sourcing rule exists...',4);
3202: END IF;

Line 3251: x_return_status := FND_API.G_RET_STS_ERROR;

3247: and nvl(effective_date,sysdate) <= nvl(disable_date, sysdate)
3248: and nvl(disable_date, sysdate+1) > sysdate;
3249:
3250: IF( v_sourcing_rule_count > 0 ) THEN
3251: x_return_status := FND_API.G_RET_STS_ERROR;
3252: g_expected_error_code := 66;
3253: ELSE
3254: p_source_type := 3 ;
3255: END IF ;

Line 3267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3263: oe_debug_pub.add('query_sourcing_org: ' || ' SQLERRM ' || SQLERRM , 1 );
3264: oe_debug_pub.add('query_sourcing_org: ' || ' came into others when finding source ' , 1 );
3265: END IF;
3266:
3267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3268: END ;
3269: END query_sourcing_org ;
3270:
3271:

Line 3355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3351: oe_debug_pub.add('populate_plan_level: ' || ' error ' || SQLCODE , 1 );
3352:
3353: oe_debug_pub.add('populate_plan_level: ' || ' error ' || SQLERRM , 1 );
3354: END IF;
3355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3356: END populate_plan_level ;
3357:
3358:
3359:

Line 3536: v_char varchar2(1) := FND_API.G_TRUE ;

3532: v_reduced_shipset_init MRP_ATP_PUB.ATP_REC_TYP ;
3533: v_shipset_init MRP_ATP_PUB.ATP_REC_TYP ;
3534: v_null_atp_rec MRP_ATP_PUB.ATP_REC_TYP ;
3535: v_shipset_loc number ;
3536: v_char varchar2(1) := FND_API.G_TRUE ;
3537: v_success_status boolean ;
3538: l_stmt_num number ;
3539: k number:=0;
3540: v_auto_gen boolean;

Line 3604: IF( FND_API.to_boolean(p_success_flag_tbl.status(m)))

3600: LOOP
3601: l_stmt_num := 40 ;
3602: IF( p_success_flag_tbl.ship_set_name(m) = g_shipset_status_tbl(j).ship_set_name ) THEN
3603: l_stmt_num := 50 ;
3604: IF( FND_API.to_boolean(p_success_flag_tbl.status(m)))
3605: THEN
3606: g_shipset_status_tbl(j).success_status := TRUE ;
3607: ELSE
3608: g_shipset_status_tbl(j).success_status := FALSE ;

Line 3821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3817: oe_debug_pub.add('reconstruct_shipset: ' || ' error encountered in reconstruct_shipset at line ' || to_char(l_stmt_num ) , 1 );
3818: oe_debug_pub.add('reconstruct_shipset: ' || ' error ' || SQLCODE , 1 );
3819: oe_debug_pub.add('reconstruct_shipset: ' || ' error ' || SQLERRM , 1 );
3820: END IF;
3821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3822:
3823: END reconstruct_shipset ;
3824:
3825:

Line 4077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4073: oe_debug_pub.add('resurrect_shipset: ' || ' error encountered in resurrect_shipset at line ' || to_char(l_stmt_num ) , 1 );
4074: oe_debug_pub.add('resurrect_shipset: ' || ' error ' || SQLCODE , 1 );
4075: oe_debug_pub.add('resurrect_shipset: ' || ' error ' || SQLERRM , 1 );
4076: END IF;
4077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4078: END resurrect_shipset;
4079:
4080:
4081:

Line 4146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4142: oe_debug_pub.add('populate_configuration_status: ' || ' error encountered in populate_configuration_status at line ' || to_char(l_stmt_num ) , 1 );
4143: oe_debug_pub.add('populate_configuration_status: ' || ' error ' || SQLCODE , 1 );
4144: oe_debug_pub.add('populate_configuration_status: ' || ' error ' || SQLERRM , 1 );
4145: END IF;
4146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4147: END populate_configuration_status ;
4148:
4149:
4150:

Line 4219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4215: oe_debug_pub.add('populate_visible_demand: ' || ' error encountered in Populate_visible_demand at line ' || to_char(l_stmt_num ) , 1 );
4216: oe_debug_pub.add('populate_visible_demand: ' || ' error ' || SQLCODE , 1 );
4217: oe_debug_pub.add('populate_visible_demand: ' || ' error ' || SQLERRM , 1 );
4218: END IF;
4219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4220: END populate_visible_demand;
4221:
4222:
4223:

Line 4816: x_return_status := FND_API.G_RET_STS_SUCCESS;

4812:
4813: oe_debug_pub.add('create_atp_bom: ' || 'G_Cto_Sparse_Shipset.COUNT :: '||to_char(G_Cto_Sparse_Shipset.COUNT), 2);
4814: END IF;
4815: lStmtNum := 10;
4816: x_return_status := FND_API.G_RET_STS_SUCCESS;
4817:
4818: IF PG_DEBUG <> 0 THEN
4819: oe_debug_pub.add('create_atp_bom: ' || 'Getting eff and dis date for optional comps', 4);
4820: END IF;

Line 4890: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4886: Extend_Atp_Bom(p_atp_bom,
4887: x_Return_Status,
4888: x_Msg_Count,
4889: x_Msg_Data);
4890: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4891: IF PG_DEBUG <> 0 THEN
4892: oe_debug_pub.add('**create_atp_bom: ' || 'Unexp error in Extend_ATP_BOM::'||sqlerrm,1);
4893: END IF;
4894: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4894: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4890: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4891: IF PG_DEBUG <> 0 THEN
4892: oe_debug_pub.add('**create_atp_bom: ' || 'Unexp error in Extend_ATP_BOM::'||sqlerrm,1);
4893: END IF;
4894: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4895: END IF;
4896: IF PG_DEBUG <> 0 THEN
4897: oe_debug_pub.add('**create_atp_bom: ' || 'After extend_atp', 5);
4898: END IF;

Line 4994: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4990: Extend_Atp_Bom(p_atp_bom,
4991: x_Return_Status,
4992: x_Msg_Count,
4993: x_Msg_Data);
4994: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4995: IF PG_DEBUG <> 0 THEN
4996: oe_debug_pub.add('**create_atp_bom: ' || 'Unexp error in Extend_ATP_BOM::'||sqlerrm,1);
4997: END IF;
4998: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4998: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4994: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4995: IF PG_DEBUG <> 0 THEN
4996: oe_debug_pub.add('**create_atp_bom: ' || 'Unexp error in Extend_ATP_BOM::'||sqlerrm,1);
4997: END IF;
4998: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4999: END IF;
5000: IF PG_DEBUG <> 0 THEN
5001: oe_debug_pub.add('**create_atp_bom: ' || 'After extend_atp', 5);
5002: END IF;

Line 5032: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5028: l_index,
5029: x_Return_Status,
5030: x_Msg_Count,
5031: x_Msg_Data);
5032: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5033: IF PG_DEBUG <> 0 THEN
5034: oe_debug_pub.add('**create_atp_bom: ' || 'Unexp error in Populate_Mandatory_Components::'||sqlerrm,1);
5035: END IF;
5036: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5036: raise FND_API.G_EXC_UNEXPECTED_ERROR;

5032: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5033: IF PG_DEBUG <> 0 THEN
5034: oe_debug_pub.add('**create_atp_bom: ' || 'Unexp error in Populate_Mandatory_Components::'||sqlerrm,1);
5035: END IF;
5036: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5037: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5038: IF PG_DEBUG <> 0 THEN
5039: oe_debug_pub.add('**create_atp_bom: ' || 'Exp error in Populate_Mandatory_Components::'||sqlerrm,1);
5040: END IF;

Line 5037: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

5033: IF PG_DEBUG <> 0 THEN
5034: oe_debug_pub.add('**create_atp_bom: ' || 'Unexp error in Populate_Mandatory_Components::'||sqlerrm,1);
5035: END IF;
5036: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5037: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5038: IF PG_DEBUG <> 0 THEN
5039: oe_debug_pub.add('**create_atp_bom: ' || 'Exp error in Populate_Mandatory_Components::'||sqlerrm,1);
5040: END IF;
5041: raise FND_API.G_EXC_ERROR;

Line 5041: raise FND_API.G_EXC_ERROR;

5037: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5038: IF PG_DEBUG <> 0 THEN
5039: oe_debug_pub.add('**create_atp_bom: ' || 'Exp error in Populate_Mandatory_Components::'||sqlerrm,1);
5040: END IF;
5041: raise FND_API.G_EXC_ERROR;
5042: END IF;
5043: IF PG_DEBUG <> 0 THEN
5044: oe_debug_pub.add('**create_atp_bom: ' || 'After Populate_Mandatory_Components', 5);
5045: END IF;

Line 5082: WHEN FND_API.G_EXC_ERROR THEN

5078:
5079: END IF; /* G_Cto_Sparse_Shipset.COUNT > 0 */
5080:
5081: EXCEPTION
5082: WHEN FND_API.G_EXC_ERROR THEN
5083: IF PG_DEBUG <> 0 THEN
5084: oe_debug_pub.add('create_atp_bom: ' || 'Create_Atp_Bom::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
5085: END IF;
5086: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5086: x_return_status := FND_API.G_RET_STS_ERROR;

5082: WHEN FND_API.G_EXC_ERROR THEN
5083: IF PG_DEBUG <> 0 THEN
5084: oe_debug_pub.add('create_atp_bom: ' || 'Create_Atp_Bom::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
5085: END IF;
5086: x_return_status := FND_API.G_RET_STS_ERROR;
5087: FND_MSG_PUB.Count_And_Get
5088: (p_count => x_msg_count
5089: ,p_data => x_msg_data
5090: );

Line 5091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5087: FND_MSG_PUB.Count_And_Get
5088: (p_count => x_msg_count
5089: ,p_data => x_msg_data
5090: );
5091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5092: IF PG_DEBUG <> 0 THEN
5093: oe_debug_pub.add('create_atp_bom: ' || 'Create_Atp_Bom::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
5094: END IF;
5095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5092: IF PG_DEBUG <> 0 THEN
5093: oe_debug_pub.add('create_atp_bom: ' || 'Create_Atp_Bom::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
5094: END IF;
5095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5096: FND_MSG_PUB.Count_And_Get
5097: (p_count => x_msg_count
5098: ,p_data => x_msg_data
5099: );

Line 5104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5100: WHEN OTHERS THEN
5101: IF PG_DEBUG <> 0 THEN
5102: oe_debug_pub.add('create_atp_bom: ' || 'Create_Atp_Bom::others::'||to_char(lStmtNum)||'::'||sqlerrm,1);
5103: END IF;
5104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5105: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5106: FND_MSG_PUB.Add_Exc_Msg
5107: (G_PKG_NAME
5108: ,'Create_Atp_Bom'

Line 5134: x_return_status := FND_API.G_RET_STS_SUCCESS;

5130: -- Current number of elements in BOM is 12
5131: -- This procedure needs to be updated each time a new element is
5132: -- added to the BOM
5133: --
5134: x_return_status := FND_API.G_RET_STS_SUCCESS;
5135: p_atp_bom.Assembly_Identifier.EXTEND;
5136: p_atp_bom.Assembly_Item_Id.EXTEND;
5137: p_atp_bom.Component_Identifier.EXTEND;
5138: p_atp_bom.Component_Item_Id.EXTEND;

Line 5156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5152: WHEN OTHERS THEN
5153: IF PG_DEBUG <> 0 THEN
5154: oe_debug_pub.add('Extend_Atp_Bom: ' || 'Extend_Atp_Bom::others::'||sqlerrm,1);
5155: END IF;
5156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5157: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5158: FND_MSG_PUB.Add_Exc_Msg
5159: (G_PKG_NAME
5160: ,'Extend_Atp_Bom'

Line 5259: x_return_status := FND_API.G_RET_STS_SUCCESS;

5255: IF PG_DEBUG <> 0 THEN
5256: oe_debug_pub.add('Populate_Mandatory_Components: ' || 'Begin Populate_Mandatory_Components', 2);
5257: END IF;
5258: lStmtNum := 110;
5259: x_return_status := FND_API.G_RET_STS_SUCCESS;
5260: l_model_item_id := g_cto_sparse_shipset(p_index).Inventory_Item_Id;
5261: l_model_src_org := g_cto_sparse_shipset(p_index).Sourcing_Org;
5262: l_model_line_id := g_cto_sparse_shipset(p_index).Line_Id;
5263:

Line 5356: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5352: x_Return_Status,
5353: x_Msg_Count,
5354: x_Msg_Data);
5355:
5356: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5357: IF PG_DEBUG <> 0 THEN
5358: oe_debug_pub.add('Populate_Mandatory_Components: ' || 'Unexp error in Extend_ATP_BOM::'||sqlerrm,1);
5359: END IF;
5360: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5360: raise FND_API.G_EXC_UNEXPECTED_ERROR;

5356: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5357: IF PG_DEBUG <> 0 THEN
5358: oe_debug_pub.add('Populate_Mandatory_Components: ' || 'Unexp error in Extend_ATP_BOM::'||sqlerrm,1);
5359: END IF;
5360: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5361: END IF;
5362: IF PG_DEBUG <> 0 THEN
5363: oe_debug_pub.add('Populate_Mandatory_Components: ' || 'After extend_atp', 5);
5364: END IF;

Line 5427: WHEN FND_API.G_EXC_ERROR THEN

5423: oe_debug_pub.add('Populate_Mandatory_Components: ' || 'added '||to_char(j)||' mand comps for item '||to_char(l_model_item_id)||' in org '||to_char(l_model_src_org), 2);
5424: END IF;
5425:
5426: EXCEPTION
5427: WHEN FND_API.G_EXC_ERROR THEN
5428: IF PG_DEBUG <> 0 THEN
5429: oe_debug_pub.add('Populate_Mandatory_Components: ' || 'Populate_Mandatory_Components::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
5430: END IF;
5431: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5431: x_return_status := FND_API.G_RET_STS_ERROR;

5427: WHEN FND_API.G_EXC_ERROR THEN
5428: IF PG_DEBUG <> 0 THEN
5429: oe_debug_pub.add('Populate_Mandatory_Components: ' || 'Populate_Mandatory_Components::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
5430: END IF;
5431: x_return_status := FND_API.G_RET_STS_ERROR;
5432:
5433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5434: IF PG_DEBUG <> 0 THEN
5435: oe_debug_pub.add('Populate_Mandatory_Components: ' || 'Populate_Mandatory_Components::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);

Line 5433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5429: oe_debug_pub.add('Populate_Mandatory_Components: ' || 'Populate_Mandatory_Components::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
5430: END IF;
5431: x_return_status := FND_API.G_RET_STS_ERROR;
5432:
5433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5434: IF PG_DEBUG <> 0 THEN
5435: oe_debug_pub.add('Populate_Mandatory_Components: ' || 'Populate_Mandatory_Components::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
5436: END IF;
5437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5434: IF PG_DEBUG <> 0 THEN
5435: oe_debug_pub.add('Populate_Mandatory_Components: ' || 'Populate_Mandatory_Components::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
5436: END IF;
5437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5438: FND_MSG_PUB.Count_And_Get
5439: (p_count => x_msg_count
5440: ,p_data => x_msg_data
5441: );

Line 5446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5442: WHEN OTHERS THEN
5443: IF PG_DEBUG <> 0 THEN
5444: oe_debug_pub.add('Populate_Mandatory_Components: ' || 'Populate_Mandatory_Components::others::'||to_char(lStmtNum)||'::'||sqlerrm,1);
5445: END IF;
5446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5447: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5448: FND_MSG_PUB.Add_Exc_Msg
5449: (G_PKG_NAME
5450: ,'Populate_Mandatory_Components'

Line 5527: xreturn_status - Return FND_API.G_RET_STS_SUCCESS if the procedure

5523: in the peggin tree
5524: Process : The records in the table BOM_CTO_ORDER_DEMAND is
5525: populated
5526: Output :
5527: xreturn_status - Return FND_API.G_RET_STS_SUCCESS if the procedure
5528: is executed successfully
5529: Return FND_API.G_RET_STS_ERROR if the procedure
5530: is completed with expected error
5531: Return FND_API.G_RET_STS_UNEXP_ERROR if the

Line 5529: Return FND_API.G_RET_STS_ERROR if the procedure

5525: populated
5526: Output :
5527: xreturn_status - Return FND_API.G_RET_STS_SUCCESS if the procedure
5528: is executed successfully
5529: Return FND_API.G_RET_STS_ERROR if the procedure
5530: is completed with expected error
5531: Return FND_API.G_RET_STS_UNEXP_ERROR if the
5532: procedure is completed with unexpected error
5533:

Line 5531: Return FND_API.G_RET_STS_UNEXP_ERROR if the

5527: xreturn_status - Return FND_API.G_RET_STS_SUCCESS if the procedure
5528: is executed successfully
5529: Return FND_API.G_RET_STS_ERROR if the procedure
5530: is completed with expected error
5531: Return FND_API.G_RET_STS_UNEXP_ERROR if the
5532: procedure is completed with unexpected error
5533:
5534: The Logic for CREATE_CTO_MODEL_DEMAND is as follows:
5535: 1. Scan through the records in the Shared shipset

Line 5596: -- Get the user id and Login id by calling the FND api

5592: oe_debug_pub.add('create_cto_model_demand: ' || 'Begin CREATE_CTO_MODEL_DEMAND module ....',1);
5593: oe_debug_pub.add('create_cto_model_demand: ' || 'Session id passed by ATP = '||to_char(p_session_id),1);
5594: END IF;
5595:
5596: -- Get the user id and Login id by calling the FND api
5597: guserid := nvl(FND_GLOBAL.user_id,-1);
5598: gloginid := nvl(FND_GLOBAL.login_id,-1);
5599:
5600: IF PG_DEBUG <> 0 THEN

Line 5608: raise FND_API.G_EXC_UNEXPECTED_ERROR;

5604: IF p_shipset.action.count = 0 THEN
5605: IF PG_DEBUG <> 0 THEN
5606: oe_debug_pub.add('create_cto_model_demand: ' || 'There are no records to process in ATP Shipset ',2);
5607: END IF;
5608: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5609: END IF;
5610:
5611: /*
5612: The following part of the code is added for the Scheduling bug in OM.

Line 5654: xreturn_status := FND_API.G_RET_STS_SUCCESS;

5650: IF PG_DEBUG <> 0 THEN
5651: oe_debug_pub.add('create_cto_model_demand: ' || 'No of records deleted..'||sql%rowcount,2);
5652: END IF;
5653:
5654: xreturn_status := FND_API.G_RET_STS_SUCCESS;
5655:
5656: IF PG_DEBUG <> 0 THEN
5657: oe_debug_pub.add('create_cto_model_demand: ' || 'Returning the control to ATP..',2);
5658: END IF;

Line 5725: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;

5721: -- IF g_final_cto_shipset.count = 0 THEN
5722: -- IF PG_DEBUG <> 0 THEN
5723: -- oe_debug_pub.add('create_cto_model_demand: ' || '.. CREATE_CTO_MODEL_DEMAND module raising exp error::' ||'There are no records to process in the shared'||' Structure.....',1);
5724: -- END IF;
5725: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;
5726: -- END IF;
5727:
5728: --
5729: -- We need to auto-generate shipset names once again in the structure

Line 5795: IF (FND_API.to_boolean(l_shipset_status)) THEN

5791: l_vis_demand_flag := 'Y';
5792: END IF;
5793:
5794: lStmtNum := 35;
5795: IF (FND_API.to_boolean(l_shipset_status)) THEN
5796: -- Deleted the information from BCOD table if the line is the
5797: -- Top model ATO line,
5798: -- Delete the line only if the action is rescheduling
5799:

Line 6145: IF xreturn_status = FND_API.G_RET_STS_ERROR THEN

6141: IF PG_DEBUG <> 0 THEN
6142: oe_debug_pub.add('create_cto_model_demand: ' || 'coming out of Reconstruct ship set with status ..'||xreturn_status,2);
6143: END IF;
6144:
6145: IF xreturn_status = FND_API.G_RET_STS_ERROR THEN
6146: IF PG_DEBUG <> 0 THEN
6147: oe_debug_pub.add('create_cto_model_demand: ' || ' exp Error in Resurrect_shipset procedure..',1);
6148: END IF;
6149: raise FND_API.G_EXC_ERROR;

Line 6149: raise FND_API.G_EXC_ERROR;

6145: IF xreturn_status = FND_API.G_RET_STS_ERROR THEN
6146: IF PG_DEBUG <> 0 THEN
6147: oe_debug_pub.add('create_cto_model_demand: ' || ' exp Error in Resurrect_shipset procedure..',1);
6148: END IF;
6149: raise FND_API.G_EXC_ERROR;
6150: ELSIF xreturn_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6151: IF PG_DEBUG <> 0 THEN
6152: oe_debug_pub.add('create_cto_model_demand: ' || ' Unexp Error in Resurrect_shipset procedure..',1);
6153: END IF;

Line 6150: ELSIF xreturn_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6146: IF PG_DEBUG <> 0 THEN
6147: oe_debug_pub.add('create_cto_model_demand: ' || ' exp Error in Resurrect_shipset procedure..',1);
6148: END IF;
6149: raise FND_API.G_EXC_ERROR;
6150: ELSIF xreturn_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6151: IF PG_DEBUG <> 0 THEN
6152: oe_debug_pub.add('create_cto_model_demand: ' || ' Unexp Error in Resurrect_shipset procedure..',1);
6153: END IF;
6154: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6154: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6150: ELSIF xreturn_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6151: IF PG_DEBUG <> 0 THEN
6152: oe_debug_pub.add('create_cto_model_demand: ' || ' Unexp Error in Resurrect_shipset procedure..',1);
6153: END IF;
6154: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6155: END IF;
6156: xreturn_status := FND_API.G_RET_STS_SUCCESS;
6157:
6158: EXCEPTION

Line 6156: xreturn_status := FND_API.G_RET_STS_SUCCESS;

6152: oe_debug_pub.add('create_cto_model_demand: ' || ' Unexp Error in Resurrect_shipset procedure..',1);
6153: END IF;
6154: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6155: END IF;
6156: xreturn_status := FND_API.G_RET_STS_SUCCESS;
6157:
6158: EXCEPTION
6159: WHEN FND_API.G_EXC_ERROR THEN
6160: ROLLBACK to create_cto_model_demand_begin;

Line 6159: WHEN FND_API.G_EXC_ERROR THEN

6155: END IF;
6156: xreturn_status := FND_API.G_RET_STS_SUCCESS;
6157:
6158: EXCEPTION
6159: WHEN FND_API.G_EXC_ERROR THEN
6160: ROLLBACK to create_cto_model_demand_begin;
6161: IF PG_DEBUG <> 0 THEN
6162: oe_debug_pub.add('create_cto_model_demand: ' || ' CREATE_CTO_MODEL_DEMAND :: exp error::'|| to_char(lStmtNum)||'::'||sqlerrm,1);
6163: END IF;

Line 6164: xreturn_status := FND_API.G_RET_STS_ERROR;

6160: ROLLBACK to create_cto_model_demand_begin;
6161: IF PG_DEBUG <> 0 THEN
6162: oe_debug_pub.add('create_cto_model_demand: ' || ' CREATE_CTO_MODEL_DEMAND :: exp error::'|| to_char(lStmtNum)||'::'||sqlerrm,1);
6163: END IF;
6164: xreturn_status := FND_API.G_RET_STS_ERROR;
6165: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'CREATE_CTO_MODEL_DEMAND');
6166: FND_MSG_PUB.Count_and_get(
6167: p_count => XMsgcount,
6168: p_data => XMsgData);

Line 6169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6165: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'CREATE_CTO_MODEL_DEMAND');
6166: FND_MSG_PUB.Count_and_get(
6167: p_count => XMsgcount,
6168: p_data => XMsgData);
6169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6170: ROLLBACK to create_cto_model_demand_begin;
6171: IF PG_DEBUG <> 0 THEN
6172: oe_debug_pub.add('create_cto_model_demand: ' || ' CREATE_CTO_MODEL_DEMAND :: unexp error::'|| to_char(lStmtNum)||'::'||sqlerrm,1);
6173: END IF;

Line 6174: xreturn_status := FND_API.G_RET_STS_UNEXP_ERROR;

6170: ROLLBACK to create_cto_model_demand_begin;
6171: IF PG_DEBUG <> 0 THEN
6172: oe_debug_pub.add('create_cto_model_demand: ' || ' CREATE_CTO_MODEL_DEMAND :: unexp error::'|| to_char(lStmtNum)||'::'||sqlerrm,1);
6173: END IF;
6174: xreturn_status := FND_API.G_RET_STS_UNEXP_ERROR;
6175: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6176: FND_MSG_PUB.Add_Exc_Msg(
6177: G_PKG_NAME
6178: , 'CREATE_CTO_MODEL_DEMAND'

Line 6190: xreturn_status := FND_API.G_RET_STS_UNEXP_ERROR;

6186: ROLLBACK to create_cto_model_demand_begin;
6187: IF PG_DEBUG <> 0 THEN
6188: oe_debug_pub.add('create_cto_model_demand: ' || ' CREATE_CTO_MODEL_DEMAND :: Other error ::'|| to_char(lStmtNum)||'::'||sqlerrm,1);
6189: END IF;
6190: xreturn_status := FND_API.G_RET_STS_UNEXP_ERROR;
6191: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6192: FND_MSG_PUB.Add_Exc_Msg(
6193: G_PKG_NAME
6194: , 'CREATE_CTO_MODEL_DEMAND'

Line 6219: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6215: IF p_shipset_tbl.ship_set_name.count = 0 THEN
6216: IF PG_DEBUG <> 0 THEN
6217: oe_debug_pub.add('get_shipset_status: ' || ' UNEXP ERROR :: GET_SHIPSET_STATUS '|| ' No records found in the shipset status structure ',2);
6218: END IF;
6219: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6220: END IF;
6221:
6222: FOR i IN p_shipset_tbl.ship_set_name.first..p_shipset_tbl.ship_set_name.last
6223: LOOP

Line 6296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6292: END IF;
6293: x_config_exists := 'N';
6294: return x_config_exists;
6295: WHEN OTHERS THEN
6296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6297: END is_config_line_exists;
6298:
6299:
6300:

Line 6472: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6468: to_char(l_inv_item_id)
6469: ||' And Sourcing org ...'
6470: ||to_char(l_org_id)||sqlerrm,1);
6471: END IF;
6472: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6473: WHEN ATP_NO_RECORD_ERROR THEN
6474: IF PG_DEBUG <> 0 THEN
6475: oe_debug_pub.add('create_demand_line: ' || 'error at statement no #'||to_char(l_stmt_no),1);
6476: END IF;

Line 6477: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6473: WHEN ATP_NO_RECORD_ERROR THEN
6474: IF PG_DEBUG <> 0 THEN
6475: oe_debug_pub.add('create_demand_line: ' || 'error at statement no #'||to_char(l_stmt_no),1);
6476: END IF;
6477: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6478: WHEN OTHERS THEN
6479: IF PG_DEBUG <> 0 THEN
6480: oe_debug_pub.add('create_demand_line: ' || 'error at statement no #'||to_char(l_stmt_no),1);
6481: oe_debug_pub.add('create_demand_line: ' || 'Error in select :: Other:: in the ATP Pegging Tree for line_id ..'|| to_char(l_line_id)||

Line 6487: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6483: to_char(l_inv_item_id)
6484: ||' And Sourcing org ...'
6485: ||to_char(l_org_id)||sqlerrm,1);
6486: END IF;
6487: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6488: END Create_demand_line;
6489:
6490:
6491: PROCEDURE ato_item_exp(p_item_id mtl_system_items.inventory_item_id%type,

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

6588: lStmtNum := 13;
6589: /* initialize assignment set */
6590: initialize_assignment_set( x_return_status ) ;
6591:
6592: IF( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
6593: IF PG_DEBUG <> 0 THEN
6594: oe_debug_pub.add('create_cto_item_demand: ' || 'initialize_assignment_set returned with Expected error',1);
6595: END IF;
6596: RAISE FND_API.G_EXC_ERROR ;

Line 6596: RAISE FND_API.G_EXC_ERROR ;

6592: IF( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
6593: IF PG_DEBUG <> 0 THEN
6594: oe_debug_pub.add('create_cto_item_demand: ' || 'initialize_assignment_set returned with Expected error',1);
6595: END IF;
6596: RAISE FND_API.G_EXC_ERROR ;
6597:
6598: ELSIF( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
6599: IF PG_DEBUG <> 0 THEN
6600: oe_debug_pub.add('create_cto_item_demand: ' || 'initialize_assignment_set returned with Unexpected error',1);

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

6594: oe_debug_pub.add('create_cto_item_demand: ' || 'initialize_assignment_set returned with Expected error',1);
6595: END IF;
6596: RAISE FND_API.G_EXC_ERROR ;
6597:
6598: ELSIF( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
6599: IF PG_DEBUG <> 0 THEN
6600: oe_debug_pub.add('create_cto_item_demand: ' || 'initialize_assignment_set returned with Unexpected error',1);
6601: END IF;
6602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 6602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

6598: ELSIF( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
6599: IF PG_DEBUG <> 0 THEN
6600: oe_debug_pub.add('create_cto_item_demand: ' || 'initialize_assignment_set returned with Unexpected error',1);
6601: END IF;
6602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
6603: END IF ;
6604:
6605: IF PG_DEBUG <> 0 THEN
6606: oe_debug_pub.add('create_cto_item_demand: ' || 'Before getting the instance id ..',2);

Line 6616: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6612: EXCEPTION WHEN OTHERS THEN
6613: IF PG_DEBUG <> 0 THEN
6614: oe_debug_pub.add('create_cto_item_demand: ' || 'UNEXP ::Error in getting instance id '||sqlerrm||'::'||'line number'||to_char(lStmtNum), 1);
6615: END IF;
6616: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6617: END;
6618:
6619: IF PG_DEBUG <> 0 THEN
6620: oe_debug_pub.add('create_cto_item_demand: ' || 'Instance_id = '||to_char(ginstance_id),2);

Line 6663: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

6659: x_return_status,
6660: x_msg_count,
6661: x_msg_data);
6662:
6663: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6664: IF PG_DEBUG <> 0 THEN
6665: oe_debug_pub.add('create_cto_item_demand: ' || 'Exp Error in is_item_sourced procedure for the item_id'
6666: ||to_char(myrec.inventory_item_id)
6667: ||' and org id...'||to_char(myrec.ship_from_org_id)

Line 6670: raise FND_API.G_EXC_ERROR;

6666: ||to_char(myrec.inventory_item_id)
6667: ||' and org id...'||to_char(myrec.ship_from_org_id)
6668: ,1);
6669: END IF;
6670: raise FND_API.G_EXC_ERROR;
6671: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6672: IF PG_DEBUG <> 0 THEN
6673: oe_debug_pub.add('create_cto_item_demand: ' || 'Unexp Error in is_item_sourced procedure for the item_id'
6674: ||to_char(myrec.inventory_item_id)

Line 6671: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6667: ||' and org id...'||to_char(myrec.ship_from_org_id)
6668: ,1);
6669: END IF;
6670: raise FND_API.G_EXC_ERROR;
6671: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6672: IF PG_DEBUG <> 0 THEN
6673: oe_debug_pub.add('create_cto_item_demand: ' || 'Unexp Error in is_item_sourced procedure for the item_id'
6674: ||to_char(myrec.inventory_item_id)
6675: ||' and org id...'||to_char(myrec.ship_from_org_id)

Line 6678: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6674: ||to_char(myrec.inventory_item_id)
6675: ||' and org id...'||to_char(myrec.ship_from_org_id)
6676: ,1);
6677: END IF;
6678: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6679: END IF;
6680:
6681: IF PG_DEBUG <> 0 THEN
6682: oe_debug_pub.add('create_cto_item_demand: ' || 'Source_flag = '||l_source_flag,2);

Line 6755: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

6751: x_return_status,
6752: x_msg_count,
6753: x_msg_data);
6754:
6755: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
6756: IF PG_DEBUG <> 0 THEN
6757: oe_debug_pub.add('create_cto_item_demand: ' || 'Exp Error in ato_item_exp procedure for the item_id'
6758: ||to_char(myrec.inventory_item_id)
6759: ||' and org id...'||to_char(myrec.ship_from_org_id)

Line 6762: raise FND_API.G_EXC_ERROR;

6758: ||to_char(myrec.inventory_item_id)
6759: ||' and org id...'||to_char(myrec.ship_from_org_id)
6760: ||'and line_id = '||to_char(myrec.line_id),1);
6761: END IF;
6762: raise FND_API.G_EXC_ERROR;
6763: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6764: IF PG_DEBUG <> 0 THEN
6765: oe_debug_pub.add('create_cto_item_demand: ' || 'Unexp Error in ato_item_exp procedure for the item_id'
6766: ||to_char(myrec.inventory_item_id)

Line 6763: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6759: ||' and org id...'||to_char(myrec.ship_from_org_id)
6760: ||'and line_id = '||to_char(myrec.line_id),1);
6761: END IF;
6762: raise FND_API.G_EXC_ERROR;
6763: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6764: IF PG_DEBUG <> 0 THEN
6765: oe_debug_pub.add('create_cto_item_demand: ' || 'Unexp Error in ato_item_exp procedure for the item_id'
6766: ||to_char(myrec.inventory_item_id)
6767: ||' and org id...'||to_char(myrec.ship_from_org_id)

Line 6770: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6766: ||to_char(myrec.inventory_item_id)
6767: ||' and org id...'||to_char(myrec.ship_from_org_id)
6768: ||' and line_id = '||to_char(myrec.line_id),1);
6769: END IF;
6770: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6771: END IF;
6772: END IF;
6773: END LOOP;
6774: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6774: x_return_status := FND_API.G_RET_STS_SUCCESS;

6770: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6771: END IF;
6772: END IF;
6773: END LOOP;
6774: x_return_status := FND_API.G_RET_STS_SUCCESS;
6775:
6776: EXCEPTION
6777: WHEN FND_API.G_EXC_ERROR THEN
6778: ROLLBACK to create_cto_item_demand_begin;

Line 6777: WHEN FND_API.G_EXC_ERROR THEN

6773: END LOOP;
6774: x_return_status := FND_API.G_RET_STS_SUCCESS;
6775:
6776: EXCEPTION
6777: WHEN FND_API.G_EXC_ERROR THEN
6778: ROLLBACK to create_cto_item_demand_begin;
6779: IF PG_DEBUG <> 0 THEN
6780: oe_debug_pub.add('create_cto_item_demand: ' || ' CREATE_CTO_ITEM_DEMAND :: exp error::'|| to_char(lStmtNum)||'::'||sqlerrm,1);
6781: END IF;

Line 6782: x_return_status := FND_API.G_RET_STS_ERROR;

6778: ROLLBACK to create_cto_item_demand_begin;
6779: IF PG_DEBUG <> 0 THEN
6780: oe_debug_pub.add('create_cto_item_demand: ' || ' CREATE_CTO_ITEM_DEMAND :: exp error::'|| to_char(lStmtNum)||'::'||sqlerrm,1);
6781: END IF;
6782: x_return_status := FND_API.G_RET_STS_ERROR;
6783: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'CREATE_CTO_MODEL_DEMAND');
6784: FND_MSG_PUB.Count_and_get(
6785: p_count => X_Msg_count,
6786: p_data => X_Msg_Data);

Line 6788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6784: FND_MSG_PUB.Count_and_get(
6785: p_count => X_Msg_count,
6786: p_data => X_Msg_Data);
6787:
6788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6789: ROLLBACK to create_cto_item_demand_begin;
6790: IF PG_DEBUG <> 0 THEN
6791: oe_debug_pub.add('create_cto_item_demand: ' || ' CREATE_CTO_ITEM_DEMAND :: unexp error::'|| to_char(lStmtNum)||'::'||sqlerrm,1);
6792: END IF;

Line 6793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6789: ROLLBACK to create_cto_item_demand_begin;
6790: IF PG_DEBUG <> 0 THEN
6791: oe_debug_pub.add('create_cto_item_demand: ' || ' CREATE_CTO_ITEM_DEMAND :: unexp error::'|| to_char(lStmtNum)||'::'||sqlerrm,1);
6792: END IF;
6793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6794: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6795: FND_MSG_PUB.Add_Exc_Msg(
6796: G_PKG_NAME
6797: , 'CREATE_CTO_MODEL_DEMAND'

Line 6810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6806: ROLLBACK to create_cto_item_demand_begin;
6807: IF PG_DEBUG <> 0 THEN
6808: oe_debug_pub.add('create_cto_item_demand: ' || ' CREATE_CTO_ITEM_DEMAND :: Other error ::'|| to_char(lStmtNum)||'::'||sqlerrm,1);
6809: END IF;
6810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6811: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6812: FND_MSG_PUB.Add_Exc_Msg(
6813: G_PKG_NAME
6814: , 'CREATE_CTO_MODEL_DEMAND'

Line 6874: IF x_ret_status = FND_API.G_RET_STS_ERROR THEN

6870: v_source_type,
6871: x_lead_time,
6872: x_ret_status);
6873:
6874: IF x_ret_status = FND_API.G_RET_STS_ERROR THEN
6875: IF PG_DEBUG <> 0 THEN
6876: oe_debug_pub.add('ato_item_exp: ' || 'get_model_sourcing_org returned expected error',1);
6877: END IF;
6878: raise FND_API.G_EXC_ERROR;

Line 6878: raise FND_API.G_EXC_ERROR;

6874: IF x_ret_status = FND_API.G_RET_STS_ERROR THEN
6875: IF PG_DEBUG <> 0 THEN
6876: oe_debug_pub.add('ato_item_exp: ' || 'get_model_sourcing_org returned expected error',1);
6877: END IF;
6878: raise FND_API.G_EXC_ERROR;
6879: ELSIF x_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6880: IF PG_DEBUG <> 0 THEN
6881: oe_debug_pub.add('ato_item_exp: ' || 'Get_model_sourcing_org returned unexpected error',1);
6882: END IF;

Line 6879: ELSIF x_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

6875: IF PG_DEBUG <> 0 THEN
6876: oe_debug_pub.add('ato_item_exp: ' || 'get_model_sourcing_org returned expected error',1);
6877: END IF;
6878: raise FND_API.G_EXC_ERROR;
6879: ELSIF x_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6880: IF PG_DEBUG <> 0 THEN
6881: oe_debug_pub.add('ato_item_exp: ' || 'Get_model_sourcing_org returned unexpected error',1);
6882: END IF;
6883: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6883: raise FND_API.G_EXC_UNEXPECTED_ERROR;

6879: ELSIF x_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6880: IF PG_DEBUG <> 0 THEN
6881: oe_debug_pub.add('ato_item_exp: ' || 'Get_model_sourcing_org returned unexpected error',1);
6882: END IF;
6883: raise FND_API.G_EXC_UNEXPECTED_ERROR;
6884: END IF;
6885:
6886: IF PG_DEBUG <> 0 THEN
6887: oe_debug_pub.add('ato_item_exp: ' || 'Source_flag = '||x_rule_exists,2);

Line 7143: IF x_ret_status = FND_API.G_RET_STS_ERROR THEN

7139: v_source_type,
7140: x_lead_time,
7141: x_ret_status);
7142:
7143: IF x_ret_status = FND_API.G_RET_STS_ERROR THEN
7144: IF PG_DEBUG <> 0 THEN
7145: oe_debug_pub.add('is_item_sourced: ' || 'get_model_sourcing_org returned expected error',1);
7146: END IF;
7147: raise FND_API.G_EXC_ERROR;

Line 7147: raise FND_API.G_EXC_ERROR;

7143: IF x_ret_status = FND_API.G_RET_STS_ERROR THEN
7144: IF PG_DEBUG <> 0 THEN
7145: oe_debug_pub.add('is_item_sourced: ' || 'get_model_sourcing_org returned expected error',1);
7146: END IF;
7147: raise FND_API.G_EXC_ERROR;
7148: ELSIF x_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7149: IF PG_DEBUG <> 0 THEN
7150: oe_debug_pub.add('is_item_sourced: ' || 'Get_model_sourcing_org returned unexpected error',1);
7151: END IF;

Line 7148: ELSIF x_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

7144: IF PG_DEBUG <> 0 THEN
7145: oe_debug_pub.add('is_item_sourced: ' || 'get_model_sourcing_org returned expected error',1);
7146: END IF;
7147: raise FND_API.G_EXC_ERROR;
7148: ELSIF x_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7149: IF PG_DEBUG <> 0 THEN
7150: oe_debug_pub.add('is_item_sourced: ' || 'Get_model_sourcing_org returned unexpected error',1);
7151: END IF;
7152: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7152: raise FND_API.G_EXC_UNEXPECTED_ERROR;

7148: ELSIF x_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7149: IF PG_DEBUG <> 0 THEN
7150: oe_debug_pub.add('is_item_sourced: ' || 'Get_model_sourcing_org returned unexpected error',1);
7151: END IF;
7152: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7153: END IF;
7154:
7155: IF PG_DEBUG <> 0 THEN
7156: oe_debug_pub.add('is_item_sourced: ' || 'source_flag ='||x_rule_exists, 4);

Line 7201: x_return_status := FND_API.G_RET_STS_SUCCESS ;

7197: PROCEDURE initialize_assignment_set ( x_return_status out varchar2 )
7198: IS
7199: BEGIN
7200:
7201: x_return_status := FND_API.G_RET_STS_SUCCESS ;
7202:
7203: /*
7204: ** get MRP's default assignment set
7205: */

Line 7245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

7241:
7242: RAISE INVALID_MRP_ASSIGNMENT_SET ;
7243:
7244: WHEN others THEN
7245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
7246: END ;
7247:
7248: IF PG_DEBUG <> 0 THEN
7249: oe_debug_pub.add('initialize_assignment_set: ' || 'Default assignment set name is '|| gMrpAssignmentSetName ,1);

Line 7255: x_return_status := FND_API.G_RET_STS_ERROR;

7251: END IF;
7252:
7253: EXCEPTION
7254: WHEN INVALID_MRP_ASSIGNMENT_SET THEN
7255: x_return_status := FND_API.G_RET_STS_ERROR;
7256:
7257: IF PG_DEBUG <> 0 THEN
7258: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::INVALID ASSIGNMENT SET ::'||to_char(g_stmt_num)||'::'||sqlerrm,1);
7259: END IF;

Line 7261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7257: IF PG_DEBUG <> 0 THEN
7258: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::INVALID ASSIGNMENT SET ::'||to_char(g_stmt_num)||'::'||sqlerrm,1);
7259: END IF;
7260:
7261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7263: IF PG_DEBUG <> 0 THEN
7264: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::unexp error::'||to_char(g_stmt_num)||'::'||sqlerrm,1);
7265: END IF;

Line 7262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7258: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::INVALID ASSIGNMENT SET ::'||to_char(g_stmt_num)||'::'||sqlerrm,1);
7259: END IF;
7260:
7261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7263: IF PG_DEBUG <> 0 THEN
7264: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::unexp error::'||to_char(g_stmt_num)||'::'||sqlerrm,1);
7265: END IF;
7266:

Line 7268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7264: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::unexp error::'||to_char(g_stmt_num)||'::'||sqlerrm,1);
7265: END IF;
7266:
7267: WHEN OTHERS THEN
7268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7269: IF PG_DEBUG <> 0 THEN
7270: oe_debug_pub.add('initialize_assignment_set: ' || 'INITIALIZE_ASSIGNMENT_SET::others::'||to_char(g_stmt_num)||'::'||sqlerrm,1);
7271: END IF;
7272: