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

Line 333: x_return_status := FND_API.G_RET_STS_SUCCESS;

329: oe_debug_pub.add(' ',1);
330: oe_debug_pub.add('=========================================================================',1);
331:
332: g_pg_level := 3;
333: x_return_status := FND_API.G_RET_STS_SUCCESS;
334: l_Stmt_num := 10;
335:
336: If PG_DEBUG <> 0 Then
337: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGIRATIONS: Insise PROCESS_OSS_CONFIGURATION API',5);

Line 492: raise FND_API.G_EXC_ERROR;

488: Exception When no_data_found then
489: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS: Ship from org is not valid',1);
490: l_valid_ship_from_org := 'N';
491: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_SHIP_ORG');
492: raise FND_API.G_EXC_ERROR;
493: End;
494:
495: -- Added by Renga Kannan on 12/02/04 for bug # 3896824
496: -- The following validation is added for this bug.

Line 553: raise FND_API.G_EXC_ERROR;

549: if PG_DEBUG <> 0 then
550: oe_debug_pub.add(lpad(' ',g_pg_level)||
551: 'PROCESS_OSS_CONFIGURATIONS: Preconfiguration org is not a valid manufacturing or Procuring org',1);
552: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_PC_ORG');
553: raise FND_API.G_EXC_ERROR;
554: End if;
555: End;
556: End if;
557:

Line 612: If x_return_status = FND_API.G_RET_STS_ERROR Then

608: x_return_status => x_return_status,
609: x_msg_data => x_msg_data,
610: x_msg_count => x_msg_count);
611:
612: If x_return_status = FND_API.G_RET_STS_ERROR Then
613: IF PG_DEBUG <> 0 Then
614: oe_debug_pub.add(lpad(' ',g_pg_level)||
615: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
616: End if;

Line 617: raise FND_API.G_EXC_ERROR;

613: IF PG_DEBUG <> 0 Then
614: oe_debug_pub.add(lpad(' ',g_pg_level)||
615: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
616: End if;
617: raise FND_API.G_EXC_ERROR;
618: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
619: IF PG_DEBUG <> 0 Then
620: oe_debug_pub.add(lpad(' ',g_pg_level)||
621: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 618: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

614: oe_debug_pub.add(lpad(' ',g_pg_level)||
615: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
616: End if;
617: raise FND_API.G_EXC_ERROR;
618: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
619: IF PG_DEBUG <> 0 Then
620: oe_debug_pub.add(lpad(' ',g_pg_level)||
621: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
622: End if;

Line 623: raise FND_API.G_EXC_UNEXPECTED_ERROR;

619: IF PG_DEBUG <> 0 Then
620: oe_debug_pub.add(lpad(' ',g_pg_level)||
621: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
622: End if;
623: raise FND_API.G_EXC_UNEXPECTED_ERROR;
624: End if;
625:
626: l_stmt_num := 70;
627: If x_oss_exists = 'Y' Then

Line 635: If x_return_status = FND_API.G_RET_STS_ERROR Then

631: p_ato_line_id => p_ato_line_id,
632: x_return_status => x_return_status,
633: x_msg_count => x_msg_count,
634: x_msg_data => x_msg_data);
635: If x_return_status = FND_API.G_RET_STS_ERROR Then
636: IF PG_DEBUG <> 0 Then
637: oe_debug_pub.add(lpad(' ',g_pg_level)||
638: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
639: End if;

Line 640: raise FND_API.G_EXC_ERROR;

636: IF PG_DEBUG <> 0 Then
637: oe_debug_pub.add(lpad(' ',g_pg_level)||
638: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
639: End if;
640: raise FND_API.G_EXC_ERROR;
641: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
642: IF PG_DEBUG <> 0 Then
643: oe_debug_pub.add(lpad(' ',g_pg_level)||
644: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 641: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

637: oe_debug_pub.add(lpad(' ',g_pg_level)||
638: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
639: End if;
640: raise FND_API.G_EXC_ERROR;
641: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
642: IF PG_DEBUG <> 0 Then
643: oe_debug_pub.add(lpad(' ',g_pg_level)||
644: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
645: End if;

Line 646: raise FND_API.G_EXC_UNEXPECTED_ERROR;

642: IF PG_DEBUG <> 0 Then
643: oe_debug_pub.add(lpad(' ',g_pg_level)||
644: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
645: End if;
646: raise FND_API.G_EXC_UNEXPECTED_ERROR;
647: End if;
648:
649:
650: l_stmt_num := 80;

Line 658: If x_return_status = FND_API.G_RET_STS_ERROR Then

654: x_return_status => x_return_status,
655: x_msg_count => x_msg_count,
656: x_msg_data => x_msg_data);
657:
658: If x_return_status = FND_API.G_RET_STS_ERROR Then
659: IF PG_DEBUG <> 0 Then
660: oe_debug_pub.add(lpad(' ',g_pg_level)||
661: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
662: End if;

Line 663: raise FND_API.G_EXC_ERROR;

659: IF PG_DEBUG <> 0 Then
660: oe_debug_pub.add(lpad(' ',g_pg_level)||
661: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
662: End if;
663: raise FND_API.G_EXC_ERROR;
664: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
665: IF PG_DEBUG <> 0 Then
666: oe_debug_pub.add(lpad(' ',g_pg_level)||
667: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 664: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

660: oe_debug_pub.add(lpad(' ',g_pg_level)||
661: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
662: End if;
663: raise FND_API.G_EXC_ERROR;
664: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
665: IF PG_DEBUG <> 0 Then
666: oe_debug_pub.add(lpad(' ',g_pg_level)||
667: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
668: End if;

Line 669: raise FND_API.G_EXC_UNEXPECTED_ERROR;

665: IF PG_DEBUG <> 0 Then
666: oe_debug_pub.add(lpad(' ',g_pg_level)||
667: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
668: End if;
669: raise FND_API.G_EXC_UNEXPECTED_ERROR;
670: End if;
671:
672:
673:

Line 721: raise FND_API.G_EXC_ERROR;

717: If PG_DEBUG <> 0 Then
718: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS: Ship from org is not valid',5);
719: end if;
720: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_SHIP_ORG');
721: raise FND_API.G_EXC_ERROR;
722: End;
723:
724: -- Added By Renga Kannan on 11/30/04 for bug #3896824
725: --

Line 782: raise FND_API.G_EXC_ERROR;

778: 'PROCESS_OSS_CONFIGURATIONS::The Preconfiguration org is not a valid manufacturing/procuring org',3);
779: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS::Raising Expected error',1);
780: end if;
781: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_PC_ORG');
782: raise FND_API.G_EXC_ERROR;
783: End;
784: End if; /* l_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID */
785:
786: -- End of change for bug 3896824 on 11/30/04

Line 803: WHEN FND_API.G_EXC_ERROR THEN

799: End if;
800:
801: Exception
802:
803: WHEN FND_API.G_EXC_ERROR THEN
804: IF PG_DEBUG <> 0 THEN
805: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS::exp error::'
806: ||to_char(l_stmt_num)
807: ||'::'||sqlerrm,1);

Line 809: x_return_status := FND_API.G_RET_STS_ERROR;

805: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS::exp error::'
806: ||to_char(l_stmt_num)
807: ||'::'||sqlerrm,1);
808: END IF;
809: x_return_status := FND_API.G_RET_STS_ERROR;
810: g_pg_level := g_pg_level - 3;
811: cto_msg_pub.count_and_get(
812: p_msg_count => x_msg_count,
813: p_msg_data => x_msg_data

Line 815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

811: cto_msg_pub.count_and_get(
812: p_msg_count => x_msg_count,
813: p_msg_data => x_msg_data
814: );
815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
816: IF PG_DEBUG <> 0 THEN
817: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS::exp error::'
818: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
819: END IF;

Line 820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

816: IF PG_DEBUG <> 0 THEN
817: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS::exp error::'
818: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
819: END IF;
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: g_pg_level := g_pg_level - 3;
822: cto_msg_pub.count_and_get(
823: p_msg_count => x_msg_count,
824: p_msg_data => x_msg_data

Line 831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

827: IF PG_DEBUG <> 0 THEN
828: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS::exp error::'
829: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
830: END IF;
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
832: g_pg_level := g_pg_level - 3;
833: cto_msg_pub.count_and_get(
834: p_msg_count => x_msg_count,
835: p_msg_data => x_msg_data

Line 879: x_return_status := FND_API.G_RET_STS_SUCCESS;

875:
876: Begin
877:
878: g_pg_level := g_pg_level + 3;
879: x_return_status := FND_API.G_RET_STS_SUCCESS;
880: x_exp_error_code := 0;
881:
882: delete /*+ INDEX (bom_cto_oss_orgslist_gt BOM_CTO_OSS_ORGSLIST_GT_N1) */
883: from bom_cto_oss_orgslist_gt

Line 1027: raise FND_API.G_EXC_ERROR;

1023: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_OSS_CONFIG: Model line id = '||p_model_line_id,1);
1024: end if;
1025: If p_calling_mode = 'ACC' Then
1026: cto_msg_pub.cto_message('BOM','BOM_CTO_OSS_NO_COMMON_ORGS');
1027: raise FND_API.G_EXC_ERROR;
1028: Elsif p_calling_mode = 'ATP' Then
1029: x_exp_error_code := 350;
1030: g_pg_level := g_pg_level - 3;
1031: return;

Line 1208: raise FND_API.G_EXC_ERROR;

1204: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_OSS_CONFIG: Purning model tree results wiht no valid orgs',5);
1205: End if;
1206: If p_calling_mode = 'ACC' Then
1207: cto_msg_pub.cto_message('BOM','CTO_OSS_NO_VALID_TREE');
1208: raise FND_API.G_EXC_ERROR;
1209: Elsif p_calling_mode = 'ATP' Then
1210: x_exp_error_code := 370;
1211: g_pg_level := g_pg_level - 3;
1212: return;

Line 1255: WHEN FND_API.G_EXC_ERROR THEN

1251: g_pg_level := g_pg_level - 3;
1252:
1253: Exception
1254:
1255: WHEN FND_API.G_EXC_ERROR THEN
1256: IF PG_DEBUG <> 0 THEN
1257: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_OSS_CONFIG::exp error::'
1258: ||to_char(l_stmt_num)
1259: ||'::'||sqlerrm,1);

Line 1261: x_return_status := FND_API.G_RET_STS_ERROR;

1257: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_OSS_CONFIG::exp error::'
1258: ||to_char(l_stmt_num)
1259: ||'::'||sqlerrm,1);
1260: END IF;
1261: x_return_status := FND_API.G_RET_STS_ERROR;
1262: g_pg_level := g_pg_level - 3;
1263: cto_msg_pub.count_and_get(
1264: p_msg_count => x_msg_count,
1265: p_msg_data => x_msg_data

Line 1267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1263: cto_msg_pub.count_and_get(
1264: p_msg_count => x_msg_count,
1265: p_msg_data => x_msg_data
1266: );
1267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1268: IF PG_DEBUG <> 0 THEN
1269: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_OSS_CONFIG::exp error::'
1270: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1271: END IF;

Line 1272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1268: IF PG_DEBUG <> 0 THEN
1269: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_OSS_CONFIG::exp error::'
1270: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1271: END IF;
1272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1273: g_pg_level := g_pg_level - 3;
1274: cto_msg_pub.count_and_get(
1275: p_msg_count => x_msg_count,
1276: p_msg_data => x_msg_data

Line 1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1279: IF PG_DEBUG <> 0 THEN
1280: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_OSS_CONFIG::exp error::'
1281: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1282: END IF;
1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1284: g_pg_level := g_pg_level - 3;
1285: cto_msg_pub.count_and_get(
1286: p_msg_count => x_msg_count,
1287: p_msg_data => x_msg_data

Line 1352: x_return_status := FND_API.G_RET_STS_SUCCESS;

1348: End if;
1349: end if;
1350:
1351: g_pg_level := g_pg_level + 3;
1352: x_return_status := FND_API.G_RET_STS_SUCCESS;
1353: l_stmt_num := 10;
1354: /* Get the no of child that are oss for this parent model
1355: */
1356:

Line 1500: If x_return_status = FND_API.G_RET_STS_ERROR Then

1496: x_return_status => x_return_status,
1497: x_msg_count => x_msg_count,
1498: x_msg_data => x_msg_data
1499: );
1500: If x_return_status = FND_API.G_RET_STS_ERROR Then
1501: IF PG_DEBUG <> 0 Then
1502: oe_debug_pub.add(lpad(' ',g_pg_level)||
1503: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
1504: End if;

Line 1505: raise FND_API.G_EXC_ERROR;

1501: IF PG_DEBUG <> 0 Then
1502: oe_debug_pub.add(lpad(' ',g_pg_level)||
1503: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
1504: End if;
1505: raise FND_API.G_EXC_ERROR;
1506: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
1507: IF PG_DEBUG <> 0 Then
1508: oe_debug_pub.add(lpad(' ',g_pg_level)||
1509: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 1506: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

1502: oe_debug_pub.add(lpad(' ',g_pg_level)||
1503: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
1504: End if;
1505: raise FND_API.G_EXC_ERROR;
1506: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
1507: IF PG_DEBUG <> 0 Then
1508: oe_debug_pub.add(lpad(' ',g_pg_level)||
1509: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
1510: End if;

Line 1511: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1507: IF PG_DEBUG <> 0 Then
1508: oe_debug_pub.add(lpad(' ',g_pg_level)||
1509: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
1510: End if;
1511: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1512: End if;
1513:
1514: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG: '
1515: ||' Item Rule exists after pruning',1);

Line 1586: If x_return_status = FND_API.G_RET_STS_ERROR Then

1582: p_end_org => l_source_org_tbl(i),
1583: x_return_status => x_return_status,
1584: x_msg_data => x_msg_data,
1585: x_msg_count => x_msg_count);
1586: If x_return_status = FND_API.G_RET_STS_ERROR Then
1587: IF PG_DEBUG <> 0 Then
1588: oe_debug_pub.add(lpad(' ',g_pg_level)||
1589: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
1590: End if;

Line 1591: raise FND_API.G_EXC_ERROR;

1587: IF PG_DEBUG <> 0 Then
1588: oe_debug_pub.add(lpad(' ',g_pg_level)||
1589: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
1590: End if;
1591: raise FND_API.G_EXC_ERROR;
1592: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
1593: IF PG_DEBUG <> 0 Then
1594: oe_debug_pub.add(lpad(' ',g_pg_level)||
1595: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 1592: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

1588: oe_debug_pub.add(lpad(' ',g_pg_level)||
1589: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
1590: End if;
1591: raise FND_API.G_EXC_ERROR;
1592: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
1593: IF PG_DEBUG <> 0 Then
1594: oe_debug_pub.add(lpad(' ',g_pg_level)||
1595: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
1596: End if;

Line 1597: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1593: IF PG_DEBUG <> 0 Then
1594: oe_debug_pub.add(lpad(' ',g_pg_level)||
1595: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
1596: End if;
1597: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1598: End if;
1599:
1600: End loop;
1601: End if;

Line 1713: raise FND_API.G_EXC_ERROR;

1709: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG: After pruning there is no valid source node',4);
1710: End if;
1711: If p_calling_mode = 'ACC' Then
1712: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_NO_VALID_TREE');
1713: raise FND_API.G_EXC_ERROR;
1714: elsif p_calling_mode = 'ATP' Then
1715: x_exp_error_code := 350;
1716: End if;
1717: End if;

Line 1723: WHEN FND_API.G_EXC_ERROR THEN

1719: print_source_gt(p_line_id=> p_model_line_id);
1720: g_pg_level := g_pg_level - 3;
1721: Exception
1722:
1723: WHEN FND_API.G_EXC_ERROR THEN
1724: IF PG_DEBUG <> 0 THEN
1725: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG::exp error::'
1726: ||to_char(l_stmt_num)
1727: ||'::'||sqlerrm,1);

Line 1729: x_return_status := FND_API.G_RET_STS_ERROR;

1725: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG::exp error::'
1726: ||to_char(l_stmt_num)
1727: ||'::'||sqlerrm,1);
1728: END IF;
1729: x_return_status := FND_API.G_RET_STS_ERROR;
1730: g_pg_level := g_pg_level - 3;
1731: cto_msg_pub.count_and_get(
1732: p_msg_count => x_msg_count,
1733: p_msg_data => x_msg_data

Line 1735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1731: cto_msg_pub.count_and_get(
1732: p_msg_count => x_msg_count,
1733: p_msg_data => x_msg_data
1734: );
1735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1736: IF PG_DEBUG <> 0 THEN
1737: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG::exp error::'
1738: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1739: END IF;

Line 1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1736: IF PG_DEBUG <> 0 THEN
1737: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG::exp error::'
1738: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1739: END IF;
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: g_pg_level := g_pg_level - 3;
1742: cto_msg_pub.count_and_get(
1743: p_msg_count => x_msg_count,
1744: p_msg_data => x_msg_data

Line 1751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1747: IF PG_DEBUG <> 0 THEN
1748: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG::exp error::'
1749: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1750: END IF;
1751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1752: g_pg_level := g_pg_level - 3;
1753: cto_msg_pub.count_and_get(
1754: p_msg_count => x_msg_count,
1755: p_msg_data => x_msg_data

Line 1978: x_return_status := FND_API.G_RET_STS_SUCCESS;

1974: Begin
1975:
1976: l_stmt_num := 10;
1977: g_pg_level := 3;
1978: x_return_status := FND_API.G_RET_STS_SUCCESS;
1979:
1980: If PG_DEBUG <> 0 Then
1981: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULE: Inside Create OSS Sourcing Rule API',5);
1982: End if;

Line 2135: p_return_values => FND_API.G_TRUE,

2131: If l_cur_assg_id is not null then
2132: l_stmt_num := 100;
2133: MRP_SOURCING_RULE_PUB.PROCESS_SOURCING_RULE(
2134: p_api_version_number => 1.0,
2135: p_return_values => FND_API.G_TRUE,
2136: p_sourcing_rule_rec => l_sourcing_rule_rec,
2137: p_sourcing_rule_val_rec => l_sourcing_rule_val_rec,
2138: p_receiving_org_tbl => l_receiving_org_tbl,
2139: p_receiving_org_val_tbl => l_receiving_org_val_tbl,

Line 2155: p_encoded => FND_API.G_FALSE);

2151:
2152: FOR l_index IN 1..x_msg_count LOOP
2153: l_msg_data := fnd_msg_pub.get(
2154: p_msg_index => l_index,
2155: p_encoded => FND_API.G_FALSE);
2156: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES: error : '||substr(l_msg_data,1,250));
2157: END LOOP;
2158:
2159: If x_return_status = FND_API.G_RET_STS_ERROR Then

Line 2159: If x_return_status = FND_API.G_RET_STS_ERROR Then

2155: p_encoded => FND_API.G_FALSE);
2156: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES: error : '||substr(l_msg_data,1,250));
2157: END LOOP;
2158:
2159: If x_return_status = FND_API.G_RET_STS_ERROR Then
2160: IF PG_DEBUG <> 0 Then
2161: oe_debug_pub.add(lpad(' ',g_pg_level)||
2162: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
2163: End if;

Line 2164: raise FND_API.G_EXC_ERROR;

2160: IF PG_DEBUG <> 0 Then
2161: oe_debug_pub.add(lpad(' ',g_pg_level)||
2162: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
2163: End if;
2164: raise FND_API.G_EXC_ERROR;
2165: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
2166: IF PG_DEBUG <> 0 Then
2167: oe_debug_pub.add(lpad(' ',g_pg_level)||
2168: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 2165: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

2161: oe_debug_pub.add(lpad(' ',g_pg_level)||
2162: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
2163: End if;
2164: raise FND_API.G_EXC_ERROR;
2165: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
2166: IF PG_DEBUG <> 0 Then
2167: oe_debug_pub.add(lpad(' ',g_pg_level)||
2168: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);
2169: End if;

Line 2170: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2166: IF PG_DEBUG <> 0 Then
2167: oe_debug_pub.add(lpad(' ',g_pg_level)||
2168: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);
2169: End if;
2170: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2171: End if;
2172: l_receiving_org_tbl.delete;
2173: l_receiving_org_val_tbl.delete;
2174: l_shipping_org_tbl.delete;

Line 2489: p_return_values => FND_API.G_TRUE,

2485:
2486: If l_cur_line_id <> 0 then
2487: MRP_SOURCING_RULE_PUB.PROCESS_SOURCING_RULE(
2488: p_api_version_number => 1.0,
2489: p_return_values => FND_API.G_TRUE,
2490: p_sourcing_rule_rec => l_sourcing_rule_rec,
2491: p_sourcing_rule_val_rec => l_sourcing_rule_val_rec,
2492: p_receiving_org_tbl => l_receiving_org_tbl,
2493: p_receiving_org_val_tbl => l_receiving_org_val_tbl,

Line 2509: p_encoded => FND_API.G_FALSE);

2505:
2506: FOR l_index IN 1..x_msg_count LOOP
2507: l_msg_data := fnd_msg_pub.get(
2508: p_msg_index => l_index,
2509: p_encoded => FND_API.G_FALSE);
2510: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES: error : '||substr(l_msg_data,1,250));
2511: END LOOP;
2512:
2513: If x_return_status = FND_API.G_RET_STS_ERROR Then

Line 2513: If x_return_status = FND_API.G_RET_STS_ERROR Then

2509: p_encoded => FND_API.G_FALSE);
2510: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES: error : '||substr(l_msg_data,1,250));
2511: END LOOP;
2512:
2513: If x_return_status = FND_API.G_RET_STS_ERROR Then
2514: IF PG_DEBUG <> 0 Then
2515: oe_debug_pub.add(lpad(' ',g_pg_level)||
2516: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
2517: End if;

Line 2518: raise FND_API.G_EXC_ERROR;

2514: IF PG_DEBUG <> 0 Then
2515: oe_debug_pub.add(lpad(' ',g_pg_level)||
2516: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
2517: End if;
2518: raise FND_API.G_EXC_ERROR;
2519: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
2520: IF PG_DEBUG <> 0 Then
2521: oe_debug_pub.add(lpad(' ',g_pg_level)||
2522: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 2519: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

2515: oe_debug_pub.add(lpad(' ',g_pg_level)||
2516: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
2517: End if;
2518: raise FND_API.G_EXC_ERROR;
2519: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
2520: IF PG_DEBUG <> 0 Then
2521: oe_debug_pub.add(lpad(' ',g_pg_level)||
2522: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);
2523: End if;

Line 2524: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2520: IF PG_DEBUG <> 0 Then
2521: oe_debug_pub.add(lpad(' ',g_pg_level)||
2522: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);
2523: End if;
2524: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2525: End if;
2526:
2527: If PG_DEBUG <> 0 Then
2528: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES: New sourcing Rule created = '

Line 2613: p_return_values => FND_API.G_TRUE,

2609: l_stmt_num := 220;
2610:
2611: MRP_SOURCING_RULE_PUB.PROCESS_SOURCING_RULE(
2612: p_api_version_number => 1.0,
2613: p_return_values => FND_API.G_TRUE,
2614: p_commit => FND_API.G_FALSE,
2615: p_sourcing_rule_rec => l_sourcing_rule_rec,
2616: p_sourcing_rule_val_rec => l_sourcing_rule_val_rec,
2617: p_receiving_org_tbl => l_receiving_org_tbl,

Line 2614: p_commit => FND_API.G_FALSE,

2610:
2611: MRP_SOURCING_RULE_PUB.PROCESS_SOURCING_RULE(
2612: p_api_version_number => 1.0,
2613: p_return_values => FND_API.G_TRUE,
2614: p_commit => FND_API.G_FALSE,
2615: p_sourcing_rule_rec => l_sourcing_rule_rec,
2616: p_sourcing_rule_val_rec => l_sourcing_rule_val_rec,
2617: p_receiving_org_tbl => l_receiving_org_tbl,
2618: p_receiving_org_val_tbl => l_receiving_org_val_tbl,

Line 2631: If x_return_status = FND_API.G_RET_STS_ERROR Then

2627: x_return_status => x_return_status,
2628: x_msg_count => x_msg_count,
2629: x_msg_data => x_msg_data);
2630:
2631: If x_return_status = FND_API.G_RET_STS_ERROR Then
2632: IF PG_DEBUG <> 0 Then
2633: oe_debug_pub.add(lpad(' ',g_pg_level)||
2634: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
2635: End if;

Line 2636: raise FND_API.G_EXC_ERROR;

2632: IF PG_DEBUG <> 0 Then
2633: oe_debug_pub.add(lpad(' ',g_pg_level)||
2634: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
2635: End if;
2636: raise FND_API.G_EXC_ERROR;
2637: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
2638: IF PG_DEBUG <> 0 Then
2639: oe_debug_pub.add(lpad(' ',g_pg_level)||
2640: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 2637: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

2633: oe_debug_pub.add(lpad(' ',g_pg_level)||
2634: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
2635: End if;
2636: raise FND_API.G_EXC_ERROR;
2637: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
2638: IF PG_DEBUG <> 0 Then
2639: oe_debug_pub.add(lpad(' ',g_pg_level)||
2640: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);
2641: End if;

Line 2642: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2638: IF PG_DEBUG <> 0 Then
2639: oe_debug_pub.add(lpad(' ',g_pg_level)||
2640: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);
2641: End if;
2642: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2643: End if;
2644:
2645:
2646: If PG_DEBUG <> 0 Then

Line 2866: p_encoded => FND_API.G_FALSE);

2862: );
2863: FOR l_index IN 1..x_msg_count LOOP
2864: l_msg_data := fnd_msg_pub.get(
2865: p_msg_index => l_index,
2866: p_encoded => FND_API.G_FALSE);
2867: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES: error : '||substr(l_msg_data,1,250));
2868: END LOOP;
2869: If x_return_status = FND_API.G_RET_STS_ERROR Then
2870: IF PG_DEBUG <> 0 Then

Line 2869: If x_return_status = FND_API.G_RET_STS_ERROR Then

2865: p_msg_index => l_index,
2866: p_encoded => FND_API.G_FALSE);
2867: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES: error : '||substr(l_msg_data,1,250));
2868: END LOOP;
2869: If x_return_status = FND_API.G_RET_STS_ERROR Then
2870: IF PG_DEBUG <> 0 Then
2871: oe_debug_pub.add(lpad(' ',g_pg_level)||
2872: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
2873: End if;

Line 2874: raise FND_API.G_EXC_ERROR;

2870: IF PG_DEBUG <> 0 Then
2871: oe_debug_pub.add(lpad(' ',g_pg_level)||
2872: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
2873: End if;
2874: raise FND_API.G_EXC_ERROR;
2875: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
2876: IF PG_DEBUG <> 0 Then
2877: oe_debug_pub.add(lpad(' ',g_pg_level)||
2878: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 2875: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

2871: oe_debug_pub.add(lpad(' ',g_pg_level)||
2872: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
2873: End if;
2874: raise FND_API.G_EXC_ERROR;
2875: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
2876: IF PG_DEBUG <> 0 Then
2877: oe_debug_pub.add(lpad(' ',g_pg_level)||
2878: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);
2879: End if;

Line 2880: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2876: IF PG_DEBUG <> 0 Then
2877: oe_debug_pub.add(lpad(' ',g_pg_level)||
2878: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);
2879: End if;
2880: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2881: End if;
2882:
2883: End if;
2884:

Line 2917: WHEN FND_API.G_EXC_ERROR THEN

2913: end if;
2914:
2915: Exception
2916:
2917: WHEN FND_API.G_EXC_ERROR THEN
2918: IF PG_DEBUG <> 0 THEN
2919: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCNIG_RULES::exp error::'
2920: ||to_char(l_stmt_num)
2921: ||'::'||sqlerrm,1);

Line 2923: x_return_status := FND_API.G_RET_STS_ERROR;

2919: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCNIG_RULES::exp error::'
2920: ||to_char(l_stmt_num)
2921: ||'::'||sqlerrm,1);
2922: END IF;
2923: x_return_status := FND_API.G_RET_STS_ERROR;
2924: g_pg_level := g_pg_level - 3;
2925: cto_msg_pub.count_and_get(
2926: p_msg_count => x_msg_count,
2927: p_msg_data => x_msg_data

Line 2929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2925: cto_msg_pub.count_and_get(
2926: p_msg_count => x_msg_count,
2927: p_msg_data => x_msg_data
2928: );
2929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2930: IF PG_DEBUG <> 0 THEN
2931: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES::exp error::'
2932: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
2933: END IF;

Line 2934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2930: IF PG_DEBUG <> 0 THEN
2931: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES::exp error::'
2932: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
2933: END IF;
2934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2935: g_pg_level := g_pg_level - 3;
2936: cto_msg_pub.count_and_get(
2937: p_msg_count => x_msg_count,
2938: p_msg_data => x_msg_data

Line 2945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2941: IF PG_DEBUG <> 0 THEN
2942: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES::exp error::'
2943: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
2944: END IF;
2945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2946: g_pg_level := g_pg_level - 3;
2947: cto_msg_pub.count_and_get(
2948: p_msg_count => x_msg_count,
2949: p_msg_data => x_msg_data

Line 3008: If x_return_status = FND_API.G_RET_STS_ERROR Then

3004: x_return_status => x_return_status,
3005: x_msg_data => x_msg_data,
3006: x_msg_count => x_msg_count
3007: );
3008: If x_return_status = FND_API.G_RET_STS_ERROR Then
3009: IF PG_DEBUG <> 0 Then
3010: oe_debug_pub.add(lpad(' ',g_pg_level)||
3011: 'UPDATE_SOURCE_TREE: Exepected error occurred in update_oss_in_bcol API',5);
3012: End if;

Line 3013: raise FND_API.G_EXC_ERROR;

3009: IF PG_DEBUG <> 0 Then
3010: oe_debug_pub.add(lpad(' ',g_pg_level)||
3011: 'UPDATE_SOURCE_TREE: Exepected error occurred in update_oss_in_bcol API',5);
3012: End if;
3013: raise FND_API.G_EXC_ERROR;
3014: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3015: IF PG_DEBUG <> 0 Then
3016: oe_debug_pub.add(lpad(' ',g_pg_level)||
3017: 'UPDATE_SOURCE_TREE: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 3014: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3010: oe_debug_pub.add(lpad(' ',g_pg_level)||
3011: 'UPDATE_SOURCE_TREE: Exepected error occurred in update_oss_in_bcol API',5);
3012: End if;
3013: raise FND_API.G_EXC_ERROR;
3014: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3015: IF PG_DEBUG <> 0 Then
3016: oe_debug_pub.add(lpad(' ',g_pg_level)||
3017: 'UPDATE_SOURCE_TREE: Un Exepected error occurred in update_oss_in_bcol API',5);
3018: End if;

Line 3019: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3015: IF PG_DEBUG <> 0 Then
3016: oe_debug_pub.add(lpad(' ',g_pg_level)||
3017: 'UPDATE_SOURCE_TREE: Un Exepected error occurred in update_oss_in_bcol API',5);
3018: End if;
3019: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3020: End if;
3021:
3022: End loop;
3023: End if;

Line 3110: If x_return_status = FND_API.G_RET_STS_ERROR Then

3106: p_rcv_org_id => global_orgs_rec.source_org_id,
3107: x_return_status => x_return_status,
3108: x_msg_count => x_msg_count,
3109: x_msg_data => x_msg_data);
3110: If x_return_status = FND_API.G_RET_STS_ERROR Then
3111: IF PG_DEBUG <> 0 Then
3112: oe_debug_pub.add(lpad(' ',g_pg_level)||
3113: 'PRUNE_ITEM_LEVEL_RULE: Exepected error occurred in update_oss_in_bcol API',5);
3114: End if;

Line 3115: raise FND_API.G_EXC_ERROR;

3111: IF PG_DEBUG <> 0 Then
3112: oe_debug_pub.add(lpad(' ',g_pg_level)||
3113: 'PRUNE_ITEM_LEVEL_RULE: Exepected error occurred in update_oss_in_bcol API',5);
3114: End if;
3115: raise FND_API.G_EXC_ERROR;
3116: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3117: IF PG_DEBUG <> 0 Then
3118: oe_debug_pub.add(lpad(' ',g_pg_level)||
3119: 'PRUNE_ITEM_LEVEL_RULE: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 3116: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3112: oe_debug_pub.add(lpad(' ',g_pg_level)||
3113: 'PRUNE_ITEM_LEVEL_RULE: Exepected error occurred in update_oss_in_bcol API',5);
3114: End if;
3115: raise FND_API.G_EXC_ERROR;
3116: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3117: IF PG_DEBUG <> 0 Then
3118: oe_debug_pub.add(lpad(' ',g_pg_level)||
3119: 'PRUNE_ITEM_LEVEL_RULE: Un Exepected error occurred in update_oss_in_bcol API',5);
3120: End if;

Line 3121: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3117: IF PG_DEBUG <> 0 Then
3118: oe_debug_pub.add(lpad(' ',g_pg_level)||
3119: 'PRUNE_ITEM_LEVEL_RULE: Un Exepected error occurred in update_oss_in_bcol API',5);
3120: End if;
3121: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3122: End if;
3123: End loop;
3124:
3125: End;

Line 3195: If x_return_status = FND_API.G_RET_STS_ERROR Then

3191: p_valid_flag => 'Y',
3192: x_return_status => x_return_status,
3193: x_msg_count => x_msg_count,
3194: x_msg_data => x_msg_data);
3195: If x_return_status = FND_API.G_RET_STS_ERROR Then
3196: IF PG_DEBUG <> 0 Then
3197: oe_debug_pub.add(lpad(' ',g_pg_level)||
3198: 'PRUNE_ITEM_LEVEL_RULE: Exepected error occurred in update_oss_in_bcol API',5);
3199: End if;

Line 3200: raise FND_API.G_EXC_ERROR;

3196: IF PG_DEBUG <> 0 Then
3197: oe_debug_pub.add(lpad(' ',g_pg_level)||
3198: 'PRUNE_ITEM_LEVEL_RULE: Exepected error occurred in update_oss_in_bcol API',5);
3199: End if;
3200: raise FND_API.G_EXC_ERROR;
3201: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3202: IF PG_DEBUG <> 0 Then
3203: oe_debug_pub.add(lpad(' ',g_pg_level)||
3204: 'PRUNE_ITEM_LEVEL_RULE: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 3201: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3197: oe_debug_pub.add(lpad(' ',g_pg_level)||
3198: 'PRUNE_ITEM_LEVEL_RULE: Exepected error occurred in update_oss_in_bcol API',5);
3199: End if;
3200: raise FND_API.G_EXC_ERROR;
3201: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3202: IF PG_DEBUG <> 0 Then
3203: oe_debug_pub.add(lpad(' ',g_pg_level)||
3204: 'PRUNE_ITEM_LEVEL_RULE: Un Exepected error occurred in update_oss_in_bcol API',5);
3205: End if;

Line 3206: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3202: IF PG_DEBUG <> 0 Then
3203: oe_debug_pub.add(lpad(' ',g_pg_level)||
3204: 'PRUNE_ITEM_LEVEL_RULE: Un Exepected error occurred in update_oss_in_bcol API',5);
3205: End if;
3206: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3207: End if;
3208: End if;
3209:
3210: End loop;

Line 3280: If x_return_status = FND_API.G_RET_STS_ERROR Then

3276: x_return_status => x_return_status,
3277: x_msg_data => x_msg_data,
3278: x_msg_count => x_msg_count);
3279:
3280: If x_return_status = FND_API.G_RET_STS_ERROR Then
3281: IF PG_DEBUG <> 0 Then
3282: oe_debug_pub.add(lpad(' ',g_pg_level)||
3283: 'FIND_LEAF_NODE: Exepected error occurred in update_oss_in_bcol API',5);
3284: End if;

Line 3285: raise FND_API.G_EXC_ERROR;

3281: IF PG_DEBUG <> 0 Then
3282: oe_debug_pub.add(lpad(' ',g_pg_level)||
3283: 'FIND_LEAF_NODE: Exepected error occurred in update_oss_in_bcol API',5);
3284: End if;
3285: raise FND_API.G_EXC_ERROR;
3286: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3287: IF PG_DEBUG <> 0 Then
3288: oe_debug_pub.add(lpad(' ',g_pg_level)||
3289: 'FIND_LEAF_NODE: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 3286: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3282: oe_debug_pub.add(lpad(' ',g_pg_level)||
3283: 'FIND_LEAF_NODE: Exepected error occurred in update_oss_in_bcol API',5);
3284: End if;
3285: raise FND_API.G_EXC_ERROR;
3286: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3287: IF PG_DEBUG <> 0 Then
3288: oe_debug_pub.add(lpad(' ',g_pg_level)||
3289: 'FIND_LEAF_NODE: Un Exepected error occurred in update_oss_in_bcol API',5);
3290: End if;

Line 3291: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3287: IF PG_DEBUG <> 0 Then
3288: oe_debug_pub.add(lpad(' ',g_pg_level)||
3289: 'FIND_LEAF_NODE: Un Exepected error occurred in update_oss_in_bcol API',5);
3290: End if;
3291: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3292: End if;
3293: End if;
3294:
3295:

Line 3317: If x_return_status = FND_API.G_RET_STS_ERROR Then

3313: p_valid_flag => 'Y',
3314: x_return_status => x_return_status,
3315: x_msg_count => x_msg_count,
3316: x_msg_data => x_msg_data);
3317: If x_return_status = FND_API.G_RET_STS_ERROR Then
3318: IF PG_DEBUG <> 0 Then
3319: oe_debug_pub.add(lpad(' ',g_pg_level)||
3320: 'FIND_LEAF_NODE: Exepected error occurred in update_oss_in_bcol API',5);
3321: End if;

Line 3322: raise FND_API.G_EXC_ERROR;

3318: IF PG_DEBUG <> 0 Then
3319: oe_debug_pub.add(lpad(' ',g_pg_level)||
3320: 'FIND_LEAF_NODE: Exepected error occurred in update_oss_in_bcol API',5);
3321: End if;
3322: raise FND_API.G_EXC_ERROR;
3323: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3324: IF PG_DEBUG <> 0 Then
3325: oe_debug_pub.add(lpad(' ',g_pg_level)||
3326: 'FIND_LEAF_NODE: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 3323: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3319: oe_debug_pub.add(lpad(' ',g_pg_level)||
3320: 'FIND_LEAF_NODE: Exepected error occurred in update_oss_in_bcol API',5);
3321: End if;
3322: raise FND_API.G_EXC_ERROR;
3323: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3324: IF PG_DEBUG <> 0 Then
3325: oe_debug_pub.add(lpad(' ',g_pg_level)||
3326: 'FIND_LEAF_NODE: Un Exepected error occurred in update_oss_in_bcol API',5);
3327: End if;

Line 3328: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3324: IF PG_DEBUG <> 0 Then
3325: oe_debug_pub.add(lpad(' ',g_pg_level)||
3326: 'FIND_LEAF_NODE: Un Exepected error occurred in update_oss_in_bcol API',5);
3327: End if;
3328: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3329: End if;
3330:
3331: End if;/* Sql%rowcount <> 0 then */
3332: End Loop;

Line 3353: If x_return_status = FND_API.G_RET_STS_ERROR Then

3349: p_valid_flag => 'Y',
3350: x_return_status => x_return_status,
3351: x_msg_count => x_msg_count,
3352: x_msg_data => x_msg_data);
3353: If x_return_status = FND_API.G_RET_STS_ERROR Then
3354: IF PG_DEBUG <> 0 Then
3355: oe_debug_pub.add(lpad(' ',g_pg_level)||
3356: 'FIND_LEAF_NODE: Exepected error occurred in update_oss_in_bcol API',5);
3357: End if;

Line 3358: raise FND_API.G_EXC_ERROR;

3354: IF PG_DEBUG <> 0 Then
3355: oe_debug_pub.add(lpad(' ',g_pg_level)||
3356: 'FIND_LEAF_NODE: Exepected error occurred in update_oss_in_bcol API',5);
3357: End if;
3358: raise FND_API.G_EXC_ERROR;
3359: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3360: IF PG_DEBUG <> 0 Then
3361: oe_debug_pub.add(lpad(' ',g_pg_level)||
3362: 'FIND_LEAF_NODE: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 3359: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3355: oe_debug_pub.add(lpad(' ',g_pg_level)||
3356: 'FIND_LEAF_NODE: Exepected error occurred in update_oss_in_bcol API',5);
3357: End if;
3358: raise FND_API.G_EXC_ERROR;
3359: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3360: IF PG_DEBUG <> 0 Then
3361: oe_debug_pub.add(lpad(' ',g_pg_level)||
3362: 'FIND_LEAF_NODE: Un Exepected error occurred in update_oss_in_bcol API',5);
3363: End if;

Line 3364: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3360: IF PG_DEBUG <> 0 Then
3361: oe_debug_pub.add(lpad(' ',g_pg_level)||
3362: 'FIND_LEAF_NODE: Un Exepected error occurred in update_oss_in_bcol API',5);
3363: End if;
3364: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3365: End if;
3366:
3367: End if;
3368: End if; /* l_source_type.count = 0 */

Line 3427: if x_return_status = FND_API.G_RET_STS_ERROR Then

3423: p_valid_flag => 'Y',
3424: x_return_status => x_return_status,
3425: x_msg_count => x_msg_count,
3426: x_msg_data => x_msg_data);
3427: if x_return_status = FND_API.G_RET_STS_ERROR Then
3428: IF PG_DEBUG <> 0 Then
3429: oe_debug_pub.add(lpad(' ',g_pg_level)||
3430: 'TRAVERSE_UP_TREE: Exepected error occurred in update_oss_in_bcol API',5);
3431: End if;

Line 3432: raise FND_API.G_EXC_ERROR;

3428: IF PG_DEBUG <> 0 Then
3429: oe_debug_pub.add(lpad(' ',g_pg_level)||
3430: 'TRAVERSE_UP_TREE: Exepected error occurred in update_oss_in_bcol API',5);
3431: End if;
3432: raise FND_API.G_EXC_ERROR;
3433: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3434: IF PG_DEBUG <> 0 Then
3435: oe_debug_pub.add(lpad(' ',g_pg_level)||
3436: 'TRAVERSE_UP_TREE: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 3433: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3429: oe_debug_pub.add(lpad(' ',g_pg_level)||
3430: 'TRAVERSE_UP_TREE: Exepected error occurred in update_oss_in_bcol API',5);
3431: End if;
3432: raise FND_API.G_EXC_ERROR;
3433: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3434: IF PG_DEBUG <> 0 Then
3435: oe_debug_pub.add(lpad(' ',g_pg_level)||
3436: 'TRAVERSE_UP_TREE: Un Exepected error occurred in update_oss_in_bcol API',5);
3437: End if;

Line 3438: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3434: IF PG_DEBUG <> 0 Then
3435: oe_debug_pub.add(lpad(' ',g_pg_level)||
3436: 'TRAVERSE_UP_TREE: Un Exepected error occurred in update_oss_in_bcol API',5);
3437: End if;
3438: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3439: End if;
3440:
3441:
3442: null;

Line 3485: x_return_status := FND_API.G_RET_STS_SUCCESS;

3481:
3482: PG_DEBUG := 5;
3483: g_pg_level := 1;
3484:
3485: x_return_status := FND_API.G_RET_STS_SUCCESS;
3486: l_stmt_num := 10;
3487:
3488: oe_debug_pub.add('=========================================================================',1);
3489: oe_debug_pub.add(' ',1);

Line 3596: If x_return_status = FND_API.G_RET_STS_ERROR Then

3592: x_msg_count => x_msg_count,
3593: x_msg_data => x_msg_data
3594: );
3595:
3596: If x_return_status = FND_API.G_RET_STS_ERROR Then
3597: IF PG_DEBUG <> 0 Then
3598: oe_debug_pub.add(lpad(' ',g_pg_level)||
3599: 'GET_OSS_ORGS_LIST: Exepected error occurred in get_configurations_org API',5);
3600: End if;

Line 3601: raise FND_API.G_EXC_ERROR;

3597: IF PG_DEBUG <> 0 Then
3598: oe_debug_pub.add(lpad(' ',g_pg_level)||
3599: 'GET_OSS_ORGS_LIST: Exepected error occurred in get_configurations_org API',5);
3600: End if;
3601: raise FND_API.G_EXC_ERROR;
3602: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3603: IF PG_DEBUG <> 0 Then
3604: oe_debug_pub.add(lpad(' ',g_pg_level)||
3605: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_configurations_org API',5);

Line 3602: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3598: oe_debug_pub.add(lpad(' ',g_pg_level)||
3599: 'GET_OSS_ORGS_LIST: Exepected error occurred in get_configurations_org API',5);
3600: End if;
3601: raise FND_API.G_EXC_ERROR;
3602: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3603: IF PG_DEBUG <> 0 Then
3604: oe_debug_pub.add(lpad(' ',g_pg_level)||
3605: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_configurations_org API',5);
3606: End if;

Line 3607: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3603: IF PG_DEBUG <> 0 Then
3604: oe_debug_pub.add(lpad(' ',g_pg_level)||
3605: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_configurations_org API',5);
3606: End if;
3607: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3608: End if;
3609:
3610: /* The following is the procedure to get the organizations for all the ato items and
3611: matched configurations.

Line 3623: If x_return_status = FND_API.G_RET_STS_ERROR Then

3619: x_msg_count => x_msg_count,
3620: x_msg_data => x_msg_data
3621: );
3622:
3623: If x_return_status = FND_API.G_RET_STS_ERROR Then
3624: IF PG_DEBUG <> 0 Then
3625: oe_debug_pub.add(lpad(' ',g_pg_level)||
3626: 'GET_OSS_ORGS_LIST: Exepected error occurred in get_configurations_org API',5);
3627: End if;

Line 3628: raise FND_API.G_EXC_ERROR;

3624: IF PG_DEBUG <> 0 Then
3625: oe_debug_pub.add(lpad(' ',g_pg_level)||
3626: 'GET_OSS_ORGS_LIST: Exepected error occurred in get_configurations_org API',5);
3627: End if;
3628: raise FND_API.G_EXC_ERROR;
3629: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3630: IF PG_DEBUG <> 0 Then
3631: oe_debug_pub.add(lpad(' ',g_pg_level)||
3632: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_configurations_org API',5);

Line 3629: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3625: oe_debug_pub.add(lpad(' ',g_pg_level)||
3626: 'GET_OSS_ORGS_LIST: Exepected error occurred in get_configurations_org API',5);
3627: End if;
3628: raise FND_API.G_EXC_ERROR;
3629: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3630: IF PG_DEBUG <> 0 Then
3631: oe_debug_pub.add(lpad(' ',g_pg_level)||
3632: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_configurations_org API',5);
3633: End if;

Line 3634: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3630: IF PG_DEBUG <> 0 Then
3631: oe_debug_pub.add(lpad(' ',g_pg_level)||
3632: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_configurations_org API',5);
3633: End if;
3634: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3635: End if;
3636:
3637:
3638:

Line 3690: WHEN FND_API.G_EXC_ERROR THEN

3686:
3687:
3688: Exception
3689:
3690: WHEN FND_API.G_EXC_ERROR THEN
3691: IF PG_DEBUG <> 0 THEN
3692: oe_debug_pub.add(lpad(' ',g_pg_level)||'Get_OSS_Orgs_list::exp error::'
3693: ||to_char(l_stmt_num)
3694: ||'::'||sqlerrm,1);

Line 3696: x_return_status := FND_API.G_RET_STS_ERROR;

3692: oe_debug_pub.add(lpad(' ',g_pg_level)||'Get_OSS_Orgs_list::exp error::'
3693: ||to_char(l_stmt_num)
3694: ||'::'||sqlerrm,1);
3695: END IF;
3696: x_return_status := FND_API.G_RET_STS_ERROR;
3697: cto_msg_pub.count_and_get(
3698: p_msg_count => x_msg_count,
3699: p_msg_data => x_msg_data
3700: );

Line 3701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3697: cto_msg_pub.count_and_get(
3698: p_msg_count => x_msg_count,
3699: p_msg_data => x_msg_data
3700: );
3701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3702: IF PG_DEBUG <> 0 THEN
3703: oe_debug_pub.add(lpad(' ',g_pg_level)||'Get_OSS_Orgs_list::exp error::'
3704: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
3705: END IF;

Line 3706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3702: IF PG_DEBUG <> 0 THEN
3703: oe_debug_pub.add(lpad(' ',g_pg_level)||'Get_OSS_Orgs_list::exp error::'
3704: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
3705: END IF;
3706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3707: cto_msg_pub.count_and_get(
3708: p_msg_count => x_msg_count,
3709: p_msg_data => x_msg_data
3710: );

Line 3716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3712: IF PG_DEBUG <> 0 THEN
3713: oe_debug_pub.add(lpad(' ',g_pg_level)||'Get_OSS_Orgs_list::exp error::'
3714: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
3715: END IF;
3716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3717: cto_msg_pub.count_and_get(
3718: p_msg_count => x_msg_count,
3719: p_msg_data => x_msg_data
3720: );

Line 3780: x_return_status := FND_API.G_RET_STS_SUCCESS;

3776:
3777: Begin
3778:
3779: g_pg_level := g_pg_level + 3;
3780: x_return_status := FND_API.G_RET_STS_SUCCESS;
3781:
3782:
3783: If PG_DEBUG <> 0 Then
3784: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_CONFIGURATIONS_ORG : Entering Model Process',5);

Line 3811: If x_return_status = FND_API.G_RET_STS_ERROR Then

3807: x_oss_exists => x_oss_exists,
3808: x_return_status => x_return_status,
3809: x_msg_data => x_msg_data,
3810: x_msg_count => x_msg_count);
3811: If x_return_status = FND_API.G_RET_STS_ERROR Then
3812: IF PG_DEBUG <> 0 Then
3813: oe_debug_pub.add(lpad(' ',g_pg_level)||
3814: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
3815: End if;

Line 3816: raise FND_API.G_EXC_ERROR;

3812: IF PG_DEBUG <> 0 Then
3813: oe_debug_pub.add(lpad(' ',g_pg_level)||
3814: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
3815: End if;
3816: raise FND_API.G_EXC_ERROR;
3817: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3818: IF PG_DEBUG <> 0 Then
3819: oe_debug_pub.add(lpad(' ',g_pg_level)||
3820: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 3817: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3813: oe_debug_pub.add(lpad(' ',g_pg_level)||
3814: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
3815: End if;
3816: raise FND_API.G_EXC_ERROR;
3817: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3818: IF PG_DEBUG <> 0 Then
3819: oe_debug_pub.add(lpad(' ',g_pg_level)||
3820: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
3821: End if;

Line 3822: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3818: IF PG_DEBUG <> 0 Then
3819: oe_debug_pub.add(lpad(' ',g_pg_level)||
3820: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
3821: End if;
3822: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3823: End if;
3824:
3825:
3826: If X_oss_exists = 'Y' Then

Line 3839: If x_return_status = FND_API.G_RET_STS_ERROR Then

3835: x_return_status => x_return_status,
3836: x_msg_data => x_msg_data,
3837: x_msg_count => x_msg_count);
3838:
3839: If x_return_status = FND_API.G_RET_STS_ERROR Then
3840:
3841: IF PG_DEBUG <> 0 Then
3842: oe_debug_pub.add(lpad(' ',g_pg_level)||
3843: 'GET_OSS_ORGS_LIST: Exepected error occurred in get_sourcing_data API',5);

Line 3845: raise FND_API.G_EXC_ERROR;

3841: IF PG_DEBUG <> 0 Then
3842: oe_debug_pub.add(lpad(' ',g_pg_level)||
3843: 'GET_OSS_ORGS_LIST: Exepected error occurred in get_sourcing_data API',5);
3844: End if;
3845: raise FND_API.G_EXC_ERROR;
3846: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3847: IF PG_DEBUG <> 0 Then
3848: oe_debug_pub.add(lpad(' ',g_pg_level)||
3849: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_sourcing_data API',5);

Line 3846: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3842: oe_debug_pub.add(lpad(' ',g_pg_level)||
3843: 'GET_OSS_ORGS_LIST: Exepected error occurred in get_sourcing_data API',5);
3844: End if;
3845: raise FND_API.G_EXC_ERROR;
3846: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3847: IF PG_DEBUG <> 0 Then
3848: oe_debug_pub.add(lpad(' ',g_pg_level)||
3849: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_sourcing_data API',5);
3850: End if;

Line 3851: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3847: IF PG_DEBUG <> 0 Then
3848: oe_debug_pub.add(lpad(' ',g_pg_level)||
3849: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_sourcing_data API',5);
3850: End if;
3851: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3852: End if; /* x_return_status = FND_API.G_RET_STS_ERROR */
3853:
3854: Process_order_for_oss(
3855: p_ato_line_id => oss_top_model_rec.ato_line_id,

Line 3852: End if; /* x_return_status = FND_API.G_RET_STS_ERROR */

3848: oe_debug_pub.add(lpad(' ',g_pg_level)||
3849: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_sourcing_data API',5);
3850: End if;
3851: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3852: End if; /* x_return_status = FND_API.G_RET_STS_ERROR */
3853:
3854: Process_order_for_oss(
3855: p_ato_line_id => oss_top_model_rec.ato_line_id,
3856: p_calling_mode => 'ATP',

Line 3861: If x_return_status = FND_API.G_RET_STS_ERROR Then

3857: x_return_status => x_return_status,
3858: x_msg_count => x_msg_count,
3859: x_msg_data => x_msg_data);
3860:
3861: If x_return_status = FND_API.G_RET_STS_ERROR Then
3862: IF PG_DEBUG <> 0 Then
3863: oe_debug_pub.add(lpad(' ',g_pg_level)||
3864: 'GET_CONFIGURATIONS_ORG: Exepected error occurred in update_oss_in_bcol API',5);
3865: End if;

Line 3866: raise FND_API.G_EXC_ERROR;

3862: IF PG_DEBUG <> 0 Then
3863: oe_debug_pub.add(lpad(' ',g_pg_level)||
3864: 'GET_CONFIGURATIONS_ORG: Exepected error occurred in update_oss_in_bcol API',5);
3865: End if;
3866: raise FND_API.G_EXC_ERROR;
3867: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3868: IF PG_DEBUG <> 0 Then
3869: oe_debug_pub.add(lpad(' ',g_pg_level)||
3870: 'GET_CONFIGURATIONS_ORG: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 3867: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3863: oe_debug_pub.add(lpad(' ',g_pg_level)||
3864: 'GET_CONFIGURATIONS_ORG: Exepected error occurred in update_oss_in_bcol API',5);
3865: End if;
3866: raise FND_API.G_EXC_ERROR;
3867: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3868: IF PG_DEBUG <> 0 Then
3869: oe_debug_pub.add(lpad(' ',g_pg_level)||
3870: 'GET_CONFIGURATIONS_ORG: Un Exepected error occurred in update_oss_in_bcol API',5);
3871: End if;

Line 3872: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3868: IF PG_DEBUG <> 0 Then
3869: oe_debug_pub.add(lpad(' ',g_pg_level)||
3870: 'GET_CONFIGURATIONS_ORG: Un Exepected error occurred in update_oss_in_bcol API',5);
3871: End if;
3872: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3873: End if;
3874:
3875: Else
3876:

Line 3987: WHEN FND_API.G_EXC_ERROR THEN

3983: g_pg_level := g_pg_level - 3;
3984:
3985: Exception
3986:
3987: WHEN FND_API.G_EXC_ERROR THEN
3988: IF PG_DEBUG <> 0 THEN
3989: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_CONFIGURATIONS_ORG: get_configurations_org::exp error::'
3990: ||to_char(l_stmt_no)
3991: ||'::'||sqlerrm,1);

Line 3994: x_return_status := FND_API.G_RET_STS_ERROR;

3990: ||to_char(l_stmt_no)
3991: ||'::'||sqlerrm,1);
3992: END IF;
3993: g_pg_level := g_pg_level - 3;
3994: x_return_status := FND_API.G_RET_STS_ERROR;
3995: cto_msg_pub.count_and_get(
3996: p_msg_count => x_msg_count,
3997: p_msg_data => x_msg_data
3998: );

Line 3999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3995: cto_msg_pub.count_and_get(
3996: p_msg_count => x_msg_count,
3997: p_msg_data => x_msg_data
3998: );
3999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4000: IF PG_DEBUG <> 0 THEN
4001: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_CONFIGURATIONS_ORG: get_configurations_org::exp error::'
4002: ||to_char(l_stmt_no)||'::'||sqlerrm,1);
4003: END IF;

Line 4005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4001: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_CONFIGURATIONS_ORG: get_configurations_org::exp error::'
4002: ||to_char(l_stmt_no)||'::'||sqlerrm,1);
4003: END IF;
4004: g_pg_level := g_pg_level - 3;
4005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4006: cto_msg_pub.count_and_get(
4007: p_msg_count => x_msg_count,
4008: p_msg_data => x_msg_data
4009: );

Line 4016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4012: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_CONFIGURATIONS_ORG: get_configurations_org::exp error::'
4013: ||to_char(l_stmt_no)||'::'||sqlerrm,1);
4014: END IF;
4015: g_pg_level := g_pg_level - 3;
4016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4017: cto_msg_pub.count_and_get(
4018: p_msg_count => x_msg_count,
4019: p_msg_data => x_msg_data
4020: );

Line 4040: x_return_status := FND_API.G_RET_STS_SUCCESS;

4036:
4037: Begin
4038:
4039: g_pg_level := g_pg_level + 3;
4040: x_return_status := FND_API.G_RET_STS_SUCCESS;
4041:
4042: l_stmt_num := 10;
4043:
4044: If PG_DEBUG <> 0 Then

Line 4220: WHEN FND_API.G_EXC_ERROR THEN

4216: g_pg_level := g_pg_level - 3;
4217:
4218: Exception
4219:
4220: WHEN FND_API.G_EXC_ERROR THEN
4221: IF PG_DEBUG <> 0 THEN
4222: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ATO_ITEM_ORGS::exp error::'
4223: ||to_char(l_stmt_num)
4224: ||'::'||sqlerrm,1);

Line 4227: x_return_status := FND_API.G_RET_STS_ERROR;

4223: ||to_char(l_stmt_num)
4224: ||'::'||sqlerrm,1);
4225: END IF;
4226: g_pg_level := g_pg_level - 3;
4227: x_return_status := FND_API.G_RET_STS_ERROR;
4228: cto_msg_pub.count_and_get(
4229: p_msg_count => x_msg_count,
4230: p_msg_data => x_msg_data
4231: );

Line 4232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4228: cto_msg_pub.count_and_get(
4229: p_msg_count => x_msg_count,
4230: p_msg_data => x_msg_data
4231: );
4232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4233: IF PG_DEBUG <> 0 THEN
4234: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ATO_ITEM_ORGS::exp error::'
4235: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4236: END IF;

Line 4238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4234: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ATO_ITEM_ORGS::exp error::'
4235: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4236: END IF;
4237: g_pg_level := g_pg_level - 3;
4238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4239: cto_msg_pub.count_and_get(
4240: p_msg_count => x_msg_count,
4241: p_msg_data => x_msg_data
4242: );

Line 4249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4245: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ATO_ITEM_ORGS::exp error::'
4246: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4247: END IF;
4248: g_pg_level := g_pg_level - 3;
4249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4250: cto_msg_pub.count_and_get(
4251: p_msg_count => x_msg_count,
4252: p_msg_data => x_msg_data
4253: );

Line 4302: x_return_status := FND_API.G_RET_STS_SUCCESS;

4298:
4299:
4300: Begin
4301:
4302: x_return_status := FND_API.G_RET_STS_SUCCESS;
4303: g_pg_level := g_pg_level + 3;
4304:
4305: IF PG_DEBUG <> 0 Then
4306: oe_debug_pub.add(lpad(' ',g_pg_level)||'UPDATE_OSS_IN_BCOL: In UPDATE_OSS_BCOL API',5);

Line 4439: WHEN FND_API.G_EXC_ERROR THEN

4435:
4436: g_pg_level := g_pg_level - 3;
4437:
4438: Exception
4439: WHEN FND_API.G_EXC_ERROR THEN
4440: IF PG_DEBUG <> 0 THEN
4441: oe_debug_pub.add(lpad(' ',g_pg_level)||'UPDATE_OSS_IN_BCOL::exp error::'
4442: ||to_char(l_stmt_num)
4443: ||'::'||sqlerrm,1);

Line 4446: x_return_status := FND_API.G_RET_STS_ERROR;

4442: ||to_char(l_stmt_num)
4443: ||'::'||sqlerrm,1);
4444: END IF;
4445: g_pg_level := g_pg_level - 3;
4446: x_return_status := FND_API.G_RET_STS_ERROR;
4447: cto_msg_pub.count_and_get(
4448: p_msg_count => x_msg_count,
4449: p_msg_data => x_msg_data
4450: );

Line 4451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4447: cto_msg_pub.count_and_get(
4448: p_msg_count => x_msg_count,
4449: p_msg_data => x_msg_data
4450: );
4451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4452: IF PG_DEBUG <> 0 THEN
4453: oe_debug_pub.add(lpad(' ',g_pg_level)||'UPDATE_OSS_IN_BCOL::exp error::'
4454: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4455: END IF;

Line 4457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4453: oe_debug_pub.add(lpad(' ',g_pg_level)||'UPDATE_OSS_IN_BCOL::exp error::'
4454: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4455: END IF;
4456: g_pg_level := g_pg_level - 3;
4457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4458: cto_msg_pub.count_and_get(
4459: p_msg_count => x_msg_count,
4460: p_msg_data => x_msg_data
4461: );

Line 4468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4464: oe_debug_pub.add(lpad(' ',g_pg_level)||'UPDATE_OSS_IN_BCOL::exp error::'
4465: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4466: END IF;
4467: g_pg_level := g_pg_level - 3;
4468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4469: cto_msg_pub.count_and_get(
4470: p_msg_count => x_msg_count,
4471: p_msg_data => x_msg_data
4472: );

Line 4499: x_return_status := FND_API.G_RET_STS_SUCCESS;

4495: l_parent_ato_line_id Number;
4496: l_stmt_num Number;
4497: Begin
4498:
4499: x_return_status := FND_API.G_RET_STS_SUCCESS;
4500: l_stmt_num := 10;
4501: g_pg_level := g_pg_level + 3;
4502:
4503: /* If the parent is already marked, we don't need to mark it again

Line 4584: WHEN FND_API.G_EXC_ERROR THEN

4580:
4581: g_pg_level := g_pg_level - 3;
4582:
4583: Exception
4584: WHEN FND_API.G_EXC_ERROR THEN
4585: IF PG_DEBUG <> 0 THEN
4586: oe_debug_pub.add(lpad(' ',g_pg_level)||'UPDATE_PARENT_OSS_LINE::exp error::'
4587: ||to_char(l_stmt_num)
4588: ||'::'||sqlerrm,1);

Line 4591: x_return_status := FND_API.G_RET_STS_ERROR;

4587: ||to_char(l_stmt_num)
4588: ||'::'||sqlerrm,1);
4589: END IF;
4590: g_pg_level := g_pg_level - 3;
4591: x_return_status := FND_API.G_RET_STS_ERROR;
4592: cto_msg_pub.count_and_get(
4593: p_msg_count => x_msg_count,
4594: p_msg_data => x_msg_data
4595: );

Line 4596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4592: cto_msg_pub.count_and_get(
4593: p_msg_count => x_msg_count,
4594: p_msg_data => x_msg_data
4595: );
4596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4597: IF PG_DEBUG <> 0 THEN
4598: oe_debug_pub.add(lpad(' ',g_pg_level)||'UPDATE_PARENT_OSS_LINE::exp error::'
4599: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4600: END IF;

Line 4602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4598: oe_debug_pub.add(lpad(' ',g_pg_level)||'UPDATE_PARENT_OSS_LINE::exp error::'
4599: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4600: END IF;
4601: g_pg_level := g_pg_level - 3;
4602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4603: cto_msg_pub.count_and_get(
4604: p_msg_count => x_msg_count,
4605: p_msg_data => x_msg_data
4606: );

Line 4613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4609: oe_debug_pub.add(lpad(' ',g_pg_level)||'UPDATE_PARENT_OSS_LINE::exp error::'
4610: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4611: END IF;
4612: g_pg_level := g_pg_level - 3;
4613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4614: cto_msg_pub.count_and_get(
4615: p_msg_count => x_msg_count,
4616: p_msg_data => x_msg_data
4617: );

Line 4631: x_return_status := FND_API.G_RET_STS_SUCCESS;

4627: l_stmt_num Number;
4628:
4629: begin
4630: g_pg_level := g_pg_level + 3;
4631: x_return_status := FND_API.G_RET_STS_SUCCESS;
4632: l_stmt_num := 10;
4633:
4634: IF PG_DEBUG <> 0 Then
4635: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_SOURCING_DATA: Inside GET_SOURCING_DATA API',5);

Line 4880: x_return_status := FND_API.G_RET_STS_SUCCESS;

4876: x_exp_error_code Number :=0;
4877:
4878:
4879: Begin
4880: x_return_status := FND_API.G_RET_STS_SUCCESS;
4881: l_stmt_num := 10;
4882: g_pg_level := g_pg_level + 3;
4883:
4884: If PG_DEBUG <> 0 Then

Line 4931: If x_return_status = FND_API.G_RET_STS_ERROR Then

4927: x_msg_count => x_msg_count,
4928: x_msg_data => x_msg_data
4929: );
4930:
4931: If x_return_status = FND_API.G_RET_STS_ERROR Then
4932: IF PG_DEBUG <> 0 Then
4933: oe_debug_pub.add(lpad(' ',g_pg_level)||
4934: 'GET_OSS_ORGS_LIST: Exepected error occurred in prune_oss_config API',5);
4935: End if;

Line 4936: raise FND_API.G_EXC_ERROR;

4932: IF PG_DEBUG <> 0 Then
4933: oe_debug_pub.add(lpad(' ',g_pg_level)||
4934: 'GET_OSS_ORGS_LIST: Exepected error occurred in prune_oss_config API',5);
4935: End if;
4936: raise FND_API.G_EXC_ERROR;
4937:
4938: Elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
4939:
4940: IF PG_DEBUG <> 0 Then

Line 4938: Elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

4934: 'GET_OSS_ORGS_LIST: Exepected error occurred in prune_oss_config API',5);
4935: End if;
4936: raise FND_API.G_EXC_ERROR;
4937:
4938: Elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
4939:
4940: IF PG_DEBUG <> 0 Then
4941: oe_debug_pub.add(lpad(' ',g_pg_level)||
4942: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in prune_oss_config API',5);

Line 4944: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4940: IF PG_DEBUG <> 0 Then
4941: oe_debug_pub.add(lpad(' ',g_pg_level)||
4942: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in prune_oss_config API',5);
4943: End if;
4944: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4945:
4946: End if; /* x_return_status = FND_API.G_RET_STS_ERROR */
4947:
4948:

Line 4946: End if; /* x_return_status = FND_API.G_RET_STS_ERROR */

4942: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in prune_oss_config API',5);
4943: End if;
4944: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4945:
4946: End if; /* x_return_status = FND_API.G_RET_STS_ERROR */
4947:
4948:
4949: If x_exp_error_code <> 0 Then
4950: l_stmt_num :=80;

Line 5011: If x_return_status = FND_API.G_RET_STS_ERROR Then

5007: x_msg_count => x_msg_count,
5008: x_msg_data => x_msg_data
5009: );
5010:
5011: If x_return_status = FND_API.G_RET_STS_ERROR Then
5012: IF PG_DEBUG <> 0 Then
5013: oe_debug_pub.add(lpad(' ',g_pg_level)||
5014: 'PROCESS_ORDER_FOR_OSS: Exepected error occurred in prune_parent_oss_config API',5);
5015: End if;

Line 5016: raise FND_API.G_EXC_ERROR;

5012: IF PG_DEBUG <> 0 Then
5013: oe_debug_pub.add(lpad(' ',g_pg_level)||
5014: 'PROCESS_ORDER_FOR_OSS: Exepected error occurred in prune_parent_oss_config API',5);
5015: End if;
5016: raise FND_API.G_EXC_ERROR;
5017: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
5018: IF PG_DEBUG <> 0 Then
5019: oe_debug_pub.add(lpad(' ',g_pg_level)||
5020: 'PROCESS_ORDER_FOR_OSS: Un Exepected error occurred in prune_parent_oss_config API',5);

Line 5017: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

5013: oe_debug_pub.add(lpad(' ',g_pg_level)||
5014: 'PROCESS_ORDER_FOR_OSS: Exepected error occurred in prune_parent_oss_config API',5);
5015: End if;
5016: raise FND_API.G_EXC_ERROR;
5017: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
5018: IF PG_DEBUG <> 0 Then
5019: oe_debug_pub.add(lpad(' ',g_pg_level)||
5020: 'PROCESS_ORDER_FOR_OSS: Un Exepected error occurred in prune_parent_oss_config API',5);
5021: End if;

Line 5022: raise FND_API.G_EXC_UNEXPECTED_ERROR;

5018: IF PG_DEBUG <> 0 Then
5019: oe_debug_pub.add(lpad(' ',g_pg_level)||
5020: 'PROCESS_ORDER_FOR_OSS: Un Exepected error occurred in prune_parent_oss_config API',5);
5021: End if;
5022: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5023: End if; /* x_return_status = FND_API.G_RET_STS_ERROR */
5024:
5025: If x_exp_error_code <> 0 Then
5026: l_stmt_num := 120;

Line 5023: End if; /* x_return_status = FND_API.G_RET_STS_ERROR */

5019: oe_debug_pub.add(lpad(' ',g_pg_level)||
5020: 'PROCESS_ORDER_FOR_OSS: Un Exepected error occurred in prune_parent_oss_config API',5);
5021: End if;
5022: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5023: End if; /* x_return_status = FND_API.G_RET_STS_ERROR */
5024:
5025: If x_exp_error_code <> 0 Then
5026: l_stmt_num := 120;
5027: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */

Line 5056: WHEN FND_API.G_EXC_ERROR THEN

5052:
5053: g_pg_level := g_pg_level - 3;
5054:
5055: Exception
5056: WHEN FND_API.G_EXC_ERROR THEN
5057: IF PG_DEBUG <> 0 THEN
5058: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_ORDER_FOR_OSS::exp error::'
5059: ||to_char(l_stmt_num)
5060: ||'::'||sqlerrm,1);

Line 5063: x_return_status := FND_API.G_RET_STS_ERROR;

5059: ||to_char(l_stmt_num)
5060: ||'::'||sqlerrm,1);
5061: END IF;
5062: g_pg_level := g_pg_level - 3;
5063: x_return_status := FND_API.G_RET_STS_ERROR;
5064: cto_msg_pub.count_and_get(
5065: p_msg_count => x_msg_count,
5066: p_msg_data => x_msg_data
5067: );

Line 5068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5064: cto_msg_pub.count_and_get(
5065: p_msg_count => x_msg_count,
5066: p_msg_data => x_msg_data
5067: );
5068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5069: IF PG_DEBUG <> 0 THEN
5070: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_ORDER_FOR_OSS::exp error::'
5071: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5072: END IF;

Line 5074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5070: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_ORDER_FOR_OSS::exp error::'
5071: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5072: END IF;
5073: g_pg_level := g_pg_level - 3;
5074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5075: cto_msg_pub.count_and_get(
5076: p_msg_count => x_msg_count,
5077: p_msg_data => x_msg_data
5078: );

Line 5085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5081: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_ORDER_FOR_OSS::exp error::'
5082: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5083: END IF;
5084: g_pg_level := g_pg_level - 3;
5085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5086: cto_msg_pub.count_and_get(
5087: p_msg_count => x_msg_count,
5088: p_msg_data => x_msg_data
5089: );

Line 5102: x_return_status := FND_API.G_RET_STS_SUCCESS;

5098: l_stmt_num Number;
5099: Begin
5100:
5101: g_pg_level := g_pg_level + 3;
5102: x_return_status := FND_API.G_RET_STS_SUCCESS;
5103: l_stmt_num := 10;
5104:
5105: If pg_debug <> 0 Then
5106: oe_debug_pub.add(lpad(' ',g_pg_level)||'COPY_TO_BCOL_TEMP: Inside Copy to Bcol Temp API',5);

Line 5215: x_return_status := FND_API.G_RET_STS_SUCCESS;

5211: Begin
5212:
5213: l_stmt_num := 10;
5214: g_pg_level := g_pg_level + 3;
5215: x_return_status := FND_API.G_RET_STS_SUCCESS;
5216:
5217: delete /*+ INDEX (oss_src BOM_CTO_OSS_SOURCE_GT_N1) */
5218: from bom_cto_oss_source_gt oss_src where ato_line_id = p_ato_line_id;
5219:

Line 5486: WHEN FND_API.G_EXC_ERROR THEN

5482:
5483: g_pg_level := g_pg_level - 3;
5484:
5485: Exception
5486: WHEN FND_API.G_EXC_ERROR THEN
5487: IF PG_DEBUG <> 0 THEN
5488: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ORDER_SOURCING_DATA::exp error::'
5489: ||to_char(l_stmt_num)
5490: ||'::'||sqlerrm,1);

Line 5493: x_return_status := FND_API.G_RET_STS_ERROR;

5489: ||to_char(l_stmt_num)
5490: ||'::'||sqlerrm,1);
5491: END IF;
5492: g_pg_level := g_pg_level - 3;
5493: x_return_status := FND_API.G_RET_STS_ERROR;
5494: cto_msg_pub.count_and_get(
5495: p_msg_count => x_msg_count,
5496: p_msg_data => x_msg_data
5497: );

Line 5498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5494: cto_msg_pub.count_and_get(
5495: p_msg_count => x_msg_count,
5496: p_msg_data => x_msg_data
5497: );
5498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5499: IF PG_DEBUG <> 0 THEN
5500: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ORDER_SOURCING_DATA::exp error::'
5501: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5502: END IF;

Line 5504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5500: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ORDER_SOURCING_DATA::exp error::'
5501: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5502: END IF;
5503: g_pg_level := g_pg_level - 3;
5504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5505: cto_msg_pub.count_and_get(
5506: p_msg_count => x_msg_count,
5507: p_msg_data => x_msg_data
5508: );

Line 5515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5511: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ORDER_SOURCING_DATA::exp error::'
5512: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5513: END IF;
5514: g_pg_level := g_pg_level - 3;
5515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5516: cto_msg_pub.count_and_get(
5517: p_msg_count => x_msg_count,
5518: p_msg_data => x_msg_data
5519: );

Line 5562: x_return_status := FND_API.G_RET_STS_SUCCESS;

5558: l_stmt_num Number;
5559: Begin
5560: l_stmt_num := 10;
5561: g_pg_level := g_pg_level + 3;
5562: x_return_status := FND_API.G_RET_STS_SUCCESS;
5563:
5564: IF PG_DEBUG <> 0 Then
5565: oe_debug_pub.add(lpad(' ',g_pg_level)||'TRAVERSE_SOURCING_CHAIN: Inside Traverse_Souricng_Chain API',5);
5566: End if;

Line 5578: raise FND_API.G_EXC_ERROR;

5574: if PG_DEBUG <> 0 then
5575: oe_debug_pub.add(lpad(' ',g_pg_level)||'TRAVERSE_SOURCING_CHAIN: Circular sourcing deducted..',5);
5576: end if;
5577: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
5578: raise FND_API.G_EXC_ERROR;
5579: Else
5580: -- Push the org to the stack
5581: G_source_org_stk(p_org_id) := p_org_id;
5582: End if;

Line 5709: x_return_status := FND_API.G_RET_STS_SUCCESS;

5705: Begin
5706:
5707: l_stmt_num := 10;
5708: g_pg_level := g_pg_level + 3;
5709: x_return_status := FND_API.G_RET_STS_SUCCESS;
5710: i := 1;
5711:
5712: If PG_DEBUG <> 0 Then
5713: oe_debug_pub.add(lpad(' ',g_pg_level)||'QUERY_OSS_SOURCING_ORG: Inside Query OSS Sourcing Org API',5);

Line 5815: WHEN FND_API.G_EXC_ERROR THEN

5811: End if;
5812:
5813: g_pg_level := g_pg_level - 3;
5814: Exception
5815: WHEN FND_API.G_EXC_ERROR THEN
5816: IF PG_DEBUG <> 0 THEN
5817: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ORDER_SOURCING_DATA::exp error::'
5818: ||to_char(l_stmt_num)
5819: ||'::'||sqlerrm,1);

Line 5822: x_return_status := FND_API.G_RET_STS_ERROR;

5818: ||to_char(l_stmt_num)
5819: ||'::'||sqlerrm,1);
5820: END IF;
5821: g_pg_level := g_pg_level - 3;
5822: x_return_status := FND_API.G_RET_STS_ERROR;
5823: cto_msg_pub.count_and_get(
5824: p_msg_count => x_msg_count,
5825: p_msg_data => x_msg_data
5826: );

Line 5827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5823: cto_msg_pub.count_and_get(
5824: p_msg_count => x_msg_count,
5825: p_msg_data => x_msg_data
5826: );
5827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5828: IF PG_DEBUG <> 0 THEN
5829: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ORDER_SOURCING_DATA::exp error::'
5830: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5831: END IF;

Line 5833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5829: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ORDER_SOURCING_DATA::exp error::'
5830: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5831: END IF;
5832: g_pg_level := g_pg_level - 3;
5833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5834: cto_msg_pub.count_and_get(
5835: p_msg_count => x_msg_count,
5836: p_msg_data => x_msg_data
5837: );

Line 5844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5840: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ORDER_SOURCING_DATA::exp error::'
5841: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5842: END IF;
5843: g_pg_level := g_pg_level - 3;
5844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5845: cto_msg_pub.count_and_get(
5846: p_msg_count => x_msg_count,
5847: p_msg_data => x_msg_data
5848: );

Line 5868: x_return_status := FND_API.G_RET_STS_SUCCESS;

5864: l_line_id number;
5865:
5866: Begin
5867: g_pg_level := nvl(g_pg_level,0) + 3;
5868: x_return_status := FND_API.G_RET_STS_SUCCESS;
5869: l_stmt_num := 10;
5870:
5871: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_OSS_BOM_ORGS: Begin ',1);
5872: