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 358: x_return_status := FND_API.G_RET_STS_SUCCESS;

354: oe_debug_pub.add(' ',1);
355: oe_debug_pub.add('=========================================================================',1);
356:
357: g_pg_level := 3;
358: x_return_status := FND_API.G_RET_STS_SUCCESS;
359: l_Stmt_num := 10;
360:
361: If PG_DEBUG <> 0 Then
362: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGIRATIONS: Insise PROCESS_OSS_CONFIGURATION API',5);

Line 533: raise FND_API.G_EXC_ERROR;

529: Exception When no_data_found then
530: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS: Ship from org is not valid',1);
531: l_valid_ship_from_org := 'N';
532: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_SHIP_ORG');
533: raise FND_API.G_EXC_ERROR;
534: End;
535:
536: -- Added by Renga Kannan on 12/02/04 for bug # 3896824
537: -- The following validation is added for this bug.

Line 594: raise FND_API.G_EXC_ERROR;

590: if PG_DEBUG <> 0 then
591: oe_debug_pub.add(lpad(' ',g_pg_level)||
592: 'PROCESS_OSS_CONFIGURATIONS: Preconfiguration org is not a valid manufacturing or Procuring org',1);
593: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_PC_ORG');
594: raise FND_API.G_EXC_ERROR;
595: End if;
596: End;
597: End if;
598:

Line 658: If x_return_status = FND_API.G_RET_STS_ERROR Then

654: x_return_status => x_return_status,
655: x_msg_data => x_msg_data,
656: x_msg_count => x_msg_count);
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: -- Moved this update stmt from update_oss_in_bcol to here. Wanted to execute this update only for ACC.
673: -- Adding the p_mode condition as part of Bugfix 8894392. Didn't want to disturb the behaviour for ACC

Line 704: If x_return_status = FND_API.G_RET_STS_ERROR Then

700: p_ato_line_id => p_ato_line_id,
701: x_return_status => x_return_status,
702: x_msg_count => x_msg_count,
703: x_msg_data => x_msg_data);
704: If x_return_status = FND_API.G_RET_STS_ERROR Then
705: IF PG_DEBUG <> 0 Then
706: oe_debug_pub.add(lpad(' ',g_pg_level)||
707: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
708: End if;

Line 709: raise FND_API.G_EXC_ERROR;

705: IF PG_DEBUG <> 0 Then
706: oe_debug_pub.add(lpad(' ',g_pg_level)||
707: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
708: End if;
709: raise FND_API.G_EXC_ERROR;
710: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
711: IF PG_DEBUG <> 0 Then
712: oe_debug_pub.add(lpad(' ',g_pg_level)||
713: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 710: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

706: oe_debug_pub.add(lpad(' ',g_pg_level)||
707: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
708: End if;
709: raise FND_API.G_EXC_ERROR;
710: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
711: IF PG_DEBUG <> 0 Then
712: oe_debug_pub.add(lpad(' ',g_pg_level)||
713: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
714: End if;

Line 715: raise FND_API.G_EXC_UNEXPECTED_ERROR;

711: IF PG_DEBUG <> 0 Then
712: oe_debug_pub.add(lpad(' ',g_pg_level)||
713: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
714: End if;
715: raise FND_API.G_EXC_UNEXPECTED_ERROR;
716: End if;
717:
718:
719: l_stmt_num := 80;

Line 727: If x_return_status = FND_API.G_RET_STS_ERROR Then

723: x_return_status => x_return_status,
724: x_msg_count => x_msg_count,
725: x_msg_data => x_msg_data);
726:
727: If x_return_status = FND_API.G_RET_STS_ERROR Then
728: IF PG_DEBUG <> 0 Then
729: oe_debug_pub.add(lpad(' ',g_pg_level)||
730: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
731: End if;

Line 732: raise FND_API.G_EXC_ERROR;

728: IF PG_DEBUG <> 0 Then
729: oe_debug_pub.add(lpad(' ',g_pg_level)||
730: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
731: End if;
732: raise FND_API.G_EXC_ERROR;
733: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
734: IF PG_DEBUG <> 0 Then
735: oe_debug_pub.add(lpad(' ',g_pg_level)||
736: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 733: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

729: oe_debug_pub.add(lpad(' ',g_pg_level)||
730: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
731: End if;
732: raise FND_API.G_EXC_ERROR;
733: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
734: IF PG_DEBUG <> 0 Then
735: oe_debug_pub.add(lpad(' ',g_pg_level)||
736: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
737: End if;

Line 738: raise FND_API.G_EXC_UNEXPECTED_ERROR;

734: IF PG_DEBUG <> 0 Then
735: oe_debug_pub.add(lpad(' ',g_pg_level)||
736: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
737: End if;
738: raise FND_API.G_EXC_UNEXPECTED_ERROR;
739: End if;
740:
741:
742:

Line 807: raise FND_API.G_EXC_ERROR;

803: If PG_DEBUG <> 0 Then
804: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS: Ship from org is not valid',5);
805: end if;
806: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_SHIP_ORG');
807: raise FND_API.G_EXC_ERROR;
808: End;
809:
810: END IF; -- IF (l_program_id <> cto_update_configs_pk.bac_program_id) Bugfix 8894392
811:

Line 870: raise FND_API.G_EXC_ERROR;

866: 'PROCESS_OSS_CONFIGURATIONS::The Preconfiguration org is not a valid manufacturing/procuring org',3);
867: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS::Raising Expected error',1);
868: end if;
869: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_PC_ORG');
870: raise FND_API.G_EXC_ERROR;
871: End;
872: End if; /* l_program_id = CTO_UTILITY_PK.PC_BOM_PROGRAM_ID */
873:
874: -- End of change for bug 3896824 on 11/30/04

Line 891: WHEN FND_API.G_EXC_ERROR THEN

887: End if;
888:
889: Exception
890:
891: WHEN FND_API.G_EXC_ERROR THEN
892: IF PG_DEBUG <> 0 THEN
893: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS::exp error::'
894: ||to_char(l_stmt_num)
895: ||'::'||sqlerrm,1);

Line 897: x_return_status := FND_API.G_RET_STS_ERROR;

893: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS::exp error::'
894: ||to_char(l_stmt_num)
895: ||'::'||sqlerrm,1);
896: END IF;
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: g_pg_level := g_pg_level - 3;
899: cto_msg_pub.count_and_get(
900: p_msg_count => x_msg_count,
901: p_msg_data => x_msg_data

Line 903: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

899: cto_msg_pub.count_and_get(
900: p_msg_count => x_msg_count,
901: p_msg_data => x_msg_data
902: );
903: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
904: IF PG_DEBUG <> 0 THEN
905: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS::exp error::'
906: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
907: END IF;

Line 908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

904: IF PG_DEBUG <> 0 THEN
905: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS::exp error::'
906: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
907: END IF;
908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909: g_pg_level := g_pg_level - 3;
910: cto_msg_pub.count_and_get(
911: p_msg_count => x_msg_count,
912: p_msg_data => x_msg_data

Line 919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

915: IF PG_DEBUG <> 0 THEN
916: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_OSS_CONFIGURATIONS::exp error::'
917: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
918: END IF;
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
920: g_pg_level := g_pg_level - 3;
921: cto_msg_pub.count_and_get(
922: p_msg_count => x_msg_count,
923: p_msg_data => x_msg_data

Line 967: x_return_status := FND_API.G_RET_STS_SUCCESS;

963:
964: Begin
965:
966: g_pg_level := g_pg_level + 3;
967: x_return_status := FND_API.G_RET_STS_SUCCESS;
968: x_exp_error_code := 0;
969:
970: delete /*+ INDEX (bom_cto_oss_orgslist_gt BOM_CTO_OSS_ORGSLIST_GT_N1) */
971: from bom_cto_oss_orgslist_gt

Line 1115: raise FND_API.G_EXC_ERROR;

1111: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_OSS_CONFIG: Model line id = '||p_model_line_id,1);
1112: end if;
1113: If p_calling_mode in ('ACC', 'UPG') Then --Bugfix 8894392
1114: cto_msg_pub.cto_message('BOM','BOM_CTO_OSS_NO_COMMON_ORGS');
1115: raise FND_API.G_EXC_ERROR;
1116: Elsif p_calling_mode = 'ATP' Then
1117: x_exp_error_code := 350;
1118: g_pg_level := g_pg_level - 3;
1119: return;

Line 1303: raise FND_API.G_EXC_ERROR;

1299:
1300: del_from_msa(p_config_item_id); --Bugfix 8894392
1301:
1302: cto_msg_pub.cto_message('BOM','CTO_OSS_NO_VALID_TREE');
1303: raise FND_API.G_EXC_ERROR;
1304: Elsif p_calling_mode = 'ATP' Then
1305: x_exp_error_code := 370;
1306: g_pg_level := g_pg_level - 3;
1307: return;

Line 1356: WHEN FND_API.G_EXC_ERROR THEN

1352: g_pg_level := g_pg_level - 3;
1353:
1354: Exception
1355:
1356: WHEN FND_API.G_EXC_ERROR THEN
1357: IF PG_DEBUG <> 0 THEN
1358: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_OSS_CONFIG::exp error::'
1359: ||to_char(l_stmt_num)
1360: ||'::'||sqlerrm,1);

Line 1362: x_return_status := FND_API.G_RET_STS_ERROR;

1358: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_OSS_CONFIG::exp error::'
1359: ||to_char(l_stmt_num)
1360: ||'::'||sqlerrm,1);
1361: END IF;
1362: x_return_status := FND_API.G_RET_STS_ERROR;
1363: g_pg_level := g_pg_level - 3;
1364: cto_msg_pub.count_and_get(
1365: p_msg_count => x_msg_count,
1366: p_msg_data => x_msg_data

Line 1368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1364: cto_msg_pub.count_and_get(
1365: p_msg_count => x_msg_count,
1366: p_msg_data => x_msg_data
1367: );
1368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1369: IF PG_DEBUG <> 0 THEN
1370: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_OSS_CONFIG::exp error::'
1371: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1372: END IF;

Line 1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1369: IF PG_DEBUG <> 0 THEN
1370: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_OSS_CONFIG::exp error::'
1371: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1372: END IF;
1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1374: g_pg_level := g_pg_level - 3;
1375: cto_msg_pub.count_and_get(
1376: p_msg_count => x_msg_count,
1377: p_msg_data => x_msg_data

Line 1384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1380: IF PG_DEBUG <> 0 THEN
1381: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_OSS_CONFIG::exp error::'
1382: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1383: END IF;
1384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1385: g_pg_level := g_pg_level - 3;
1386: cto_msg_pub.count_and_get(
1387: p_msg_count => x_msg_count,
1388: p_msg_data => x_msg_data

Line 1455: x_return_status := FND_API.G_RET_STS_SUCCESS;

1451: End if;
1452: end if;
1453:
1454: g_pg_level := g_pg_level + 3;
1455: x_return_status := FND_API.G_RET_STS_SUCCESS;
1456: l_stmt_num := 10;
1457: /* Get the no of child that are oss for this parent model
1458: */
1459:

Line 1641: If x_return_status = FND_API.G_RET_STS_ERROR Then

1637: x_return_status => x_return_status,
1638: x_msg_count => x_msg_count,
1639: x_msg_data => x_msg_data
1640: );
1641: If x_return_status = FND_API.G_RET_STS_ERROR Then
1642: IF PG_DEBUG <> 0 Then
1643: oe_debug_pub.add(lpad(' ',g_pg_level)||
1644: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
1645: End if;

Line 1646: raise FND_API.G_EXC_ERROR;

1642: IF PG_DEBUG <> 0 Then
1643: oe_debug_pub.add(lpad(' ',g_pg_level)||
1644: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
1645: End if;
1646: raise FND_API.G_EXC_ERROR;
1647: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
1648: IF PG_DEBUG <> 0 Then
1649: oe_debug_pub.add(lpad(' ',g_pg_level)||
1650: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 1647: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

1643: oe_debug_pub.add(lpad(' ',g_pg_level)||
1644: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
1645: End if;
1646: raise FND_API.G_EXC_ERROR;
1647: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
1648: IF PG_DEBUG <> 0 Then
1649: oe_debug_pub.add(lpad(' ',g_pg_level)||
1650: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
1651: End if;

Line 1652: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1648: IF PG_DEBUG <> 0 Then
1649: oe_debug_pub.add(lpad(' ',g_pg_level)||
1650: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
1651: End if;
1652: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1653: End if;
1654:
1655: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG: '
1656: ||' Item Rule exists after pruning',1);

Line 1727: If x_return_status = FND_API.G_RET_STS_ERROR Then

1723: p_end_org => l_source_org_tbl(i),
1724: x_return_status => x_return_status,
1725: x_msg_data => x_msg_data,
1726: x_msg_count => x_msg_count);
1727: If x_return_status = FND_API.G_RET_STS_ERROR Then
1728: IF PG_DEBUG <> 0 Then
1729: oe_debug_pub.add(lpad(' ',g_pg_level)||
1730: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
1731: End if;

Line 1732: raise FND_API.G_EXC_ERROR;

1728: IF PG_DEBUG <> 0 Then
1729: oe_debug_pub.add(lpad(' ',g_pg_level)||
1730: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
1731: End if;
1732: raise FND_API.G_EXC_ERROR;
1733: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
1734: IF PG_DEBUG <> 0 Then
1735: oe_debug_pub.add(lpad(' ',g_pg_level)||
1736: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 1733: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

1729: oe_debug_pub.add(lpad(' ',g_pg_level)||
1730: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
1731: End if;
1732: raise FND_API.G_EXC_ERROR;
1733: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
1734: IF PG_DEBUG <> 0 Then
1735: oe_debug_pub.add(lpad(' ',g_pg_level)||
1736: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
1737: End if;

Line 1738: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1734: IF PG_DEBUG <> 0 Then
1735: oe_debug_pub.add(lpad(' ',g_pg_level)||
1736: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
1737: End if;
1738: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1739: End if;
1740:
1741: End loop;
1742: End if;

Line 1854: raise FND_API.G_EXC_ERROR;

1850: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG: After pruning there is no valid source node',4);
1851: End if;
1852: If p_calling_mode in ('ACC', 'UPG') Then --Bugfix 8894392
1853: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_NO_VALID_TREE');
1854: raise FND_API.G_EXC_ERROR;
1855: elsif p_calling_mode = 'ATP' Then
1856: x_exp_error_code := 350;
1857: End if;
1858: End if;

Line 1870: WHEN FND_API.G_EXC_ERROR THEN

1866:
1867: g_pg_level := g_pg_level - 3;
1868: Exception
1869:
1870: WHEN FND_API.G_EXC_ERROR THEN
1871: IF PG_DEBUG <> 0 THEN
1872: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG::exp error::'
1873: ||to_char(l_stmt_num)
1874: ||'::'||sqlerrm,1);

Line 1876: x_return_status := FND_API.G_RET_STS_ERROR;

1872: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG::exp error::'
1873: ||to_char(l_stmt_num)
1874: ||'::'||sqlerrm,1);
1875: END IF;
1876: x_return_status := FND_API.G_RET_STS_ERROR;
1877: g_pg_level := g_pg_level - 3;
1878: cto_msg_pub.count_and_get(
1879: p_msg_count => x_msg_count,
1880: p_msg_data => x_msg_data

Line 1882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1878: cto_msg_pub.count_and_get(
1879: p_msg_count => x_msg_count,
1880: p_msg_data => x_msg_data
1881: );
1882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1883: IF PG_DEBUG <> 0 THEN
1884: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG::exp error::'
1885: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1886: END IF;

Line 1887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1883: IF PG_DEBUG <> 0 THEN
1884: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG::exp error::'
1885: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1886: END IF;
1887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1888: g_pg_level := g_pg_level - 3;
1889: cto_msg_pub.count_and_get(
1890: p_msg_count => x_msg_count,
1891: p_msg_data => x_msg_data

Line 1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1894: IF PG_DEBUG <> 0 THEN
1895: oe_debug_pub.add(lpad(' ',g_pg_level)||'PRUNE_PARENT_OSS_CONFIG::exp error::'
1896: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
1897: END IF;
1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1899: g_pg_level := g_pg_level - 3;
1900: cto_msg_pub.count_and_get(
1901: p_msg_count => x_msg_count,
1902: p_msg_data => x_msg_data

Line 2167: x_return_status := FND_API.G_RET_STS_SUCCESS;

2163: Begin
2164:
2165: l_stmt_num := 10;
2166: g_pg_level := 3;
2167: x_return_status := FND_API.G_RET_STS_SUCCESS;
2168:
2169: If PG_DEBUG <> 0 Then
2170: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULE: Inside Create OSS Sourcing Rule API',5);
2171: End if;

Line 2348: p_return_values => FND_API.G_TRUE,

2344: If l_cur_assg_id is not null then
2345: l_stmt_num := 100;
2346: MRP_SOURCING_RULE_PUB.PROCESS_SOURCING_RULE(
2347: p_api_version_number => 1.0,
2348: p_return_values => FND_API.G_TRUE,
2349: p_sourcing_rule_rec => l_sourcing_rule_rec,
2350: p_sourcing_rule_val_rec => l_sourcing_rule_val_rec,
2351: p_receiving_org_tbl => l_receiving_org_tbl,
2352: p_receiving_org_val_tbl => l_receiving_org_val_tbl,

Line 2368: p_encoded => FND_API.G_FALSE);

2364:
2365: FOR l_index IN 1..x_msg_count LOOP
2366: l_msg_data := fnd_msg_pub.get(
2367: p_msg_index => l_index,
2368: p_encoded => FND_API.G_FALSE);
2369: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES: error : '||substr(l_msg_data,1,250));
2370: END LOOP;
2371:
2372: If x_return_status = FND_API.G_RET_STS_ERROR Then

Line 2372: If x_return_status = FND_API.G_RET_STS_ERROR Then

2368: p_encoded => FND_API.G_FALSE);
2369: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES: error : '||substr(l_msg_data,1,250));
2370: END LOOP;
2371:
2372: If x_return_status = FND_API.G_RET_STS_ERROR Then
2373: IF PG_DEBUG <> 0 Then
2374: oe_debug_pub.add(lpad(' ',g_pg_level)||
2375: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
2376: End if;

Line 2377: raise FND_API.G_EXC_ERROR;

2373: IF PG_DEBUG <> 0 Then
2374: oe_debug_pub.add(lpad(' ',g_pg_level)||
2375: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
2376: End if;
2377: raise FND_API.G_EXC_ERROR;
2378: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
2379: IF PG_DEBUG <> 0 Then
2380: oe_debug_pub.add(lpad(' ',g_pg_level)||
2381: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 2378: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

2374: oe_debug_pub.add(lpad(' ',g_pg_level)||
2375: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
2376: End if;
2377: raise FND_API.G_EXC_ERROR;
2378: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
2379: IF PG_DEBUG <> 0 Then
2380: oe_debug_pub.add(lpad(' ',g_pg_level)||
2381: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);
2382: End if;

Line 2383: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2379: IF PG_DEBUG <> 0 Then
2380: oe_debug_pub.add(lpad(' ',g_pg_level)||
2381: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);
2382: End if;
2383: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2384: End if;
2385: l_receiving_org_tbl.delete;
2386: l_receiving_org_val_tbl.delete;
2387:

Line 2920: p_return_values => FND_API.G_TRUE,

2916: END If;
2917:
2918: MRP_SOURCING_RULE_PUB.PROCESS_SOURCING_RULE(
2919: p_api_version_number => 1.0,
2920: p_return_values => FND_API.G_TRUE,
2921: p_sourcing_rule_rec => l_sourcing_rule_rec,
2922: p_sourcing_rule_val_rec => l_sourcing_rule_val_rec,
2923: p_receiving_org_tbl => l_receiving_org_tbl,
2924: p_receiving_org_val_tbl => l_receiving_org_val_tbl,

Line 2940: p_encoded => FND_API.G_FALSE);

2936:
2937: FOR l_index IN 1..x_msg_count LOOP
2938: l_msg_data := fnd_msg_pub.get(
2939: p_msg_index => l_index,
2940: p_encoded => FND_API.G_FALSE);
2941: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES: error : '||substr(l_msg_data,1,250));
2942: END LOOP;
2943:
2944: If x_return_status = FND_API.G_RET_STS_ERROR Then

Line 2944: If x_return_status = FND_API.G_RET_STS_ERROR Then

2940: p_encoded => FND_API.G_FALSE);
2941: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES: error : '||substr(l_msg_data,1,250));
2942: END LOOP;
2943:
2944: If x_return_status = FND_API.G_RET_STS_ERROR Then
2945: IF PG_DEBUG <> 0 Then
2946: oe_debug_pub.add(lpad(' ',g_pg_level)||
2947: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
2948: End if;

Line 2949: raise FND_API.G_EXC_ERROR;

2945: IF PG_DEBUG <> 0 Then
2946: oe_debug_pub.add(lpad(' ',g_pg_level)||
2947: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
2948: End if;
2949: raise FND_API.G_EXC_ERROR;
2950: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
2951: IF PG_DEBUG <> 0 Then
2952: oe_debug_pub.add(lpad(' ',g_pg_level)||
2953: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 2950: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

2946: oe_debug_pub.add(lpad(' ',g_pg_level)||
2947: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
2948: End if;
2949: raise FND_API.G_EXC_ERROR;
2950: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
2951: IF PG_DEBUG <> 0 Then
2952: oe_debug_pub.add(lpad(' ',g_pg_level)||
2953: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);
2954: End if;

Line 2955: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2951: IF PG_DEBUG <> 0 Then
2952: oe_debug_pub.add(lpad(' ',g_pg_level)||
2953: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);
2954: End if;
2955: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2956: End if;
2957:
2958: If PG_DEBUG <> 0 Then
2959: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES: New sourcing Rule created = '

Line 3044: p_return_values => FND_API.G_TRUE,

3040: l_stmt_num := 220;
3041:
3042: MRP_SOURCING_RULE_PUB.PROCESS_SOURCING_RULE(
3043: p_api_version_number => 1.0,
3044: p_return_values => FND_API.G_TRUE,
3045: p_commit => FND_API.G_FALSE,
3046: p_sourcing_rule_rec => l_sourcing_rule_rec,
3047: p_sourcing_rule_val_rec => l_sourcing_rule_val_rec,
3048: p_receiving_org_tbl => l_receiving_org_tbl,

Line 3045: p_commit => FND_API.G_FALSE,

3041:
3042: MRP_SOURCING_RULE_PUB.PROCESS_SOURCING_RULE(
3043: p_api_version_number => 1.0,
3044: p_return_values => FND_API.G_TRUE,
3045: p_commit => FND_API.G_FALSE,
3046: p_sourcing_rule_rec => l_sourcing_rule_rec,
3047: p_sourcing_rule_val_rec => l_sourcing_rule_val_rec,
3048: p_receiving_org_tbl => l_receiving_org_tbl,
3049: p_receiving_org_val_tbl => l_receiving_org_val_tbl,

Line 3062: If x_return_status = FND_API.G_RET_STS_ERROR Then

3058: x_return_status => x_return_status,
3059: x_msg_count => x_msg_count,
3060: x_msg_data => x_msg_data);
3061:
3062: If x_return_status = FND_API.G_RET_STS_ERROR Then
3063: IF PG_DEBUG <> 0 Then
3064: oe_debug_pub.add(lpad(' ',g_pg_level)||
3065: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
3066: End if;

Line 3067: raise FND_API.G_EXC_ERROR;

3063: IF PG_DEBUG <> 0 Then
3064: oe_debug_pub.add(lpad(' ',g_pg_level)||
3065: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
3066: End if;
3067: raise FND_API.G_EXC_ERROR;
3068: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3069: IF PG_DEBUG <> 0 Then
3070: oe_debug_pub.add(lpad(' ',g_pg_level)||
3071: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 3068: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3064: oe_debug_pub.add(lpad(' ',g_pg_level)||
3065: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
3066: End if;
3067: raise FND_API.G_EXC_ERROR;
3068: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3069: IF PG_DEBUG <> 0 Then
3070: oe_debug_pub.add(lpad(' ',g_pg_level)||
3071: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);
3072: End if;

Line 3073: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3069: IF PG_DEBUG <> 0 Then
3070: oe_debug_pub.add(lpad(' ',g_pg_level)||
3071: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);
3072: End if;
3073: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3074: End if;
3075:
3076:
3077: If PG_DEBUG <> 0 Then

Line 3301: p_encoded => FND_API.G_FALSE);

3297: );
3298: FOR l_index IN 1..x_msg_count LOOP
3299: l_msg_data := fnd_msg_pub.get(
3300: p_msg_index => l_index,
3301: p_encoded => FND_API.G_FALSE);
3302: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES: error : '||substr(l_msg_data,1,250));
3303: END LOOP;
3304: If x_return_status = FND_API.G_RET_STS_ERROR Then
3305: IF PG_DEBUG <> 0 Then

Line 3304: If x_return_status = FND_API.G_RET_STS_ERROR Then

3300: p_msg_index => l_index,
3301: p_encoded => FND_API.G_FALSE);
3302: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES: error : '||substr(l_msg_data,1,250));
3303: END LOOP;
3304: If x_return_status = FND_API.G_RET_STS_ERROR Then
3305: IF PG_DEBUG <> 0 Then
3306: oe_debug_pub.add(lpad(' ',g_pg_level)||
3307: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
3308: End if;

Line 3309: raise FND_API.G_EXC_ERROR;

3305: IF PG_DEBUG <> 0 Then
3306: oe_debug_pub.add(lpad(' ',g_pg_level)||
3307: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
3308: End if;
3309: raise FND_API.G_EXC_ERROR;
3310: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3311: IF PG_DEBUG <> 0 Then
3312: oe_debug_pub.add(lpad(' ',g_pg_level)||
3313: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 3310: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3306: oe_debug_pub.add(lpad(' ',g_pg_level)||
3307: 'CREATE_OSS_SOURCING_RULES: Exepected error occurred in update_oss_in_bcol API',5);
3308: End if;
3309: raise FND_API.G_EXC_ERROR;
3310: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3311: IF PG_DEBUG <> 0 Then
3312: oe_debug_pub.add(lpad(' ',g_pg_level)||
3313: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);
3314: End if;

Line 3315: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3311: IF PG_DEBUG <> 0 Then
3312: oe_debug_pub.add(lpad(' ',g_pg_level)||
3313: 'CREATE_OSS_SOURCING_RULES: Un Exepected error occurred in update_oss_in_bcol API',5);
3314: End if;
3315: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3316: End if;
3317:
3318: End if;
3319:

Line 3355: WHEN FND_API.G_EXC_ERROR THEN

3351: end if;
3352:
3353: Exception
3354:
3355: WHEN FND_API.G_EXC_ERROR THEN
3356: IF PG_DEBUG <> 0 THEN
3357: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCNIG_RULES::exp error::'
3358: ||to_char(l_stmt_num)
3359: ||'::'||sqlerrm,1);

Line 3361: x_return_status := FND_API.G_RET_STS_ERROR;

3357: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCNIG_RULES::exp error::'
3358: ||to_char(l_stmt_num)
3359: ||'::'||sqlerrm,1);
3360: END IF;
3361: x_return_status := FND_API.G_RET_STS_ERROR;
3362: g_pg_level := g_pg_level - 3;
3363: cto_msg_pub.count_and_get(
3364: p_msg_count => x_msg_count,
3365: p_msg_data => x_msg_data

Line 3367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3363: cto_msg_pub.count_and_get(
3364: p_msg_count => x_msg_count,
3365: p_msg_data => x_msg_data
3366: );
3367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3368: IF PG_DEBUG <> 0 THEN
3369: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES::exp error::'
3370: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
3371: END IF;

Line 3372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3368: IF PG_DEBUG <> 0 THEN
3369: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES::exp error::'
3370: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
3371: END IF;
3372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3373: g_pg_level := g_pg_level - 3;
3374: cto_msg_pub.count_and_get(
3375: p_msg_count => x_msg_count,
3376: p_msg_data => x_msg_data

Line 3383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3379: IF PG_DEBUG <> 0 THEN
3380: oe_debug_pub.add(lpad(' ',g_pg_level)||'CREATE_OSS_SOURCING_RULES::exp error::'
3381: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
3382: END IF;
3383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3384: g_pg_level := g_pg_level - 3;
3385: cto_msg_pub.count_and_get(
3386: p_msg_count => x_msg_count,
3387: p_msg_data => x_msg_data

Line 3446: If x_return_status = FND_API.G_RET_STS_ERROR Then

3442: x_return_status => x_return_status,
3443: x_msg_data => x_msg_data,
3444: x_msg_count => x_msg_count
3445: );
3446: If x_return_status = FND_API.G_RET_STS_ERROR Then
3447: IF PG_DEBUG <> 0 Then
3448: oe_debug_pub.add(lpad(' ',g_pg_level)||
3449: 'UPDATE_SOURCE_TREE: Exepected error occurred in update_oss_in_bcol API',5);
3450: End if;

Line 3451: raise FND_API.G_EXC_ERROR;

3447: IF PG_DEBUG <> 0 Then
3448: oe_debug_pub.add(lpad(' ',g_pg_level)||
3449: 'UPDATE_SOURCE_TREE: Exepected error occurred in update_oss_in_bcol API',5);
3450: End if;
3451: raise FND_API.G_EXC_ERROR;
3452: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3453: IF PG_DEBUG <> 0 Then
3454: oe_debug_pub.add(lpad(' ',g_pg_level)||
3455: 'UPDATE_SOURCE_TREE: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 3452: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3448: oe_debug_pub.add(lpad(' ',g_pg_level)||
3449: 'UPDATE_SOURCE_TREE: Exepected error occurred in update_oss_in_bcol API',5);
3450: End if;
3451: raise FND_API.G_EXC_ERROR;
3452: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3453: IF PG_DEBUG <> 0 Then
3454: oe_debug_pub.add(lpad(' ',g_pg_level)||
3455: 'UPDATE_SOURCE_TREE: Un Exepected error occurred in update_oss_in_bcol API',5);
3456: End if;

Line 3457: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3453: IF PG_DEBUG <> 0 Then
3454: oe_debug_pub.add(lpad(' ',g_pg_level)||
3455: 'UPDATE_SOURCE_TREE: Un Exepected error occurred in update_oss_in_bcol API',5);
3456: End if;
3457: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3458: End if;
3459:
3460: End loop;
3461: End if;

Line 3548: If x_return_status = FND_API.G_RET_STS_ERROR Then

3544: p_rcv_org_id => global_orgs_rec.source_org_id,
3545: x_return_status => x_return_status,
3546: x_msg_count => x_msg_count,
3547: x_msg_data => x_msg_data);
3548: If x_return_status = FND_API.G_RET_STS_ERROR Then
3549: IF PG_DEBUG <> 0 Then
3550: oe_debug_pub.add(lpad(' ',g_pg_level)||
3551: 'PRUNE_ITEM_LEVEL_RULE: Exepected error occurred in update_oss_in_bcol API',5);
3552: End if;

Line 3553: raise FND_API.G_EXC_ERROR;

3549: IF PG_DEBUG <> 0 Then
3550: oe_debug_pub.add(lpad(' ',g_pg_level)||
3551: 'PRUNE_ITEM_LEVEL_RULE: Exepected error occurred in update_oss_in_bcol API',5);
3552: End if;
3553: raise FND_API.G_EXC_ERROR;
3554: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3555: IF PG_DEBUG <> 0 Then
3556: oe_debug_pub.add(lpad(' ',g_pg_level)||
3557: 'PRUNE_ITEM_LEVEL_RULE: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 3554: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3550: oe_debug_pub.add(lpad(' ',g_pg_level)||
3551: 'PRUNE_ITEM_LEVEL_RULE: Exepected error occurred in update_oss_in_bcol API',5);
3552: End if;
3553: raise FND_API.G_EXC_ERROR;
3554: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3555: IF PG_DEBUG <> 0 Then
3556: oe_debug_pub.add(lpad(' ',g_pg_level)||
3557: 'PRUNE_ITEM_LEVEL_RULE: Un Exepected error occurred in update_oss_in_bcol API',5);
3558: End if;

Line 3559: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3555: IF PG_DEBUG <> 0 Then
3556: oe_debug_pub.add(lpad(' ',g_pg_level)||
3557: 'PRUNE_ITEM_LEVEL_RULE: Un Exepected error occurred in update_oss_in_bcol API',5);
3558: End if;
3559: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3560: End if;
3561: End loop;
3562:
3563: End;

Line 3633: If x_return_status = FND_API.G_RET_STS_ERROR Then

3629: p_valid_flag => 'Y',
3630: x_return_status => x_return_status,
3631: x_msg_count => x_msg_count,
3632: x_msg_data => x_msg_data);
3633: If x_return_status = FND_API.G_RET_STS_ERROR Then
3634: IF PG_DEBUG <> 0 Then
3635: oe_debug_pub.add(lpad(' ',g_pg_level)||
3636: 'PRUNE_ITEM_LEVEL_RULE: Exepected error occurred in update_oss_in_bcol API',5);
3637: End if;

Line 3638: raise FND_API.G_EXC_ERROR;

3634: IF PG_DEBUG <> 0 Then
3635: oe_debug_pub.add(lpad(' ',g_pg_level)||
3636: 'PRUNE_ITEM_LEVEL_RULE: Exepected error occurred in update_oss_in_bcol API',5);
3637: End if;
3638: raise FND_API.G_EXC_ERROR;
3639: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3640: IF PG_DEBUG <> 0 Then
3641: oe_debug_pub.add(lpad(' ',g_pg_level)||
3642: 'PRUNE_ITEM_LEVEL_RULE: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 3639: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3635: oe_debug_pub.add(lpad(' ',g_pg_level)||
3636: 'PRUNE_ITEM_LEVEL_RULE: Exepected error occurred in update_oss_in_bcol API',5);
3637: End if;
3638: raise FND_API.G_EXC_ERROR;
3639: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3640: IF PG_DEBUG <> 0 Then
3641: oe_debug_pub.add(lpad(' ',g_pg_level)||
3642: 'PRUNE_ITEM_LEVEL_RULE: Un Exepected error occurred in update_oss_in_bcol API',5);
3643: End if;

Line 3644: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3640: IF PG_DEBUG <> 0 Then
3641: oe_debug_pub.add(lpad(' ',g_pg_level)||
3642: 'PRUNE_ITEM_LEVEL_RULE: Un Exepected error occurred in update_oss_in_bcol API',5);
3643: End if;
3644: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3645: End if;
3646: End if;
3647:
3648: End loop;

Line 3750: If x_return_status = FND_API.G_RET_STS_ERROR Then

3746: x_return_status => x_return_status,
3747: x_msg_data => x_msg_data,
3748: x_msg_count => x_msg_count);
3749:
3750: If x_return_status = FND_API.G_RET_STS_ERROR Then
3751: IF PG_DEBUG <> 0 Then
3752: oe_debug_pub.add(lpad(' ',g_pg_level)||
3753: 'FIND_LEAF_NODE: Exepected error occurred in update_oss_in_bcol API',5);
3754: End if;

Line 3755: raise FND_API.G_EXC_ERROR;

3751: IF PG_DEBUG <> 0 Then
3752: oe_debug_pub.add(lpad(' ',g_pg_level)||
3753: 'FIND_LEAF_NODE: Exepected error occurred in update_oss_in_bcol API',5);
3754: End if;
3755: raise FND_API.G_EXC_ERROR;
3756: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3757: IF PG_DEBUG <> 0 Then
3758: oe_debug_pub.add(lpad(' ',g_pg_level)||
3759: 'FIND_LEAF_NODE: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 3756: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3752: oe_debug_pub.add(lpad(' ',g_pg_level)||
3753: 'FIND_LEAF_NODE: Exepected error occurred in update_oss_in_bcol API',5);
3754: End if;
3755: raise FND_API.G_EXC_ERROR;
3756: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3757: IF PG_DEBUG <> 0 Then
3758: oe_debug_pub.add(lpad(' ',g_pg_level)||
3759: 'FIND_LEAF_NODE: Un Exepected error occurred in update_oss_in_bcol API',5);
3760: End if;

Line 3761: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3757: IF PG_DEBUG <> 0 Then
3758: oe_debug_pub.add(lpad(' ',g_pg_level)||
3759: 'FIND_LEAF_NODE: Un Exepected error occurred in update_oss_in_bcol API',5);
3760: End if;
3761: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3762: End if;
3763: End if;
3764:
3765: /*Bugfix 13540153-FP(13360098): Changing rcv_org_id to source_org_id and adding an nvl.

Line 3823: If x_return_status = FND_API.G_RET_STS_ERROR Then

3819: p_valid_flag => 'Y',
3820: x_return_status => x_return_status,
3821: x_msg_count => x_msg_count,
3822: x_msg_data => x_msg_data);
3823: If x_return_status = FND_API.G_RET_STS_ERROR Then
3824: IF PG_DEBUG <> 0 Then
3825: oe_debug_pub.add(lpad(' ',g_pg_level)||
3826: 'FIND_LEAF_NODE: Exepected error occurred in update_oss_in_bcol API',5);
3827: End if;

Line 3828: raise FND_API.G_EXC_ERROR;

3824: IF PG_DEBUG <> 0 Then
3825: oe_debug_pub.add(lpad(' ',g_pg_level)||
3826: 'FIND_LEAF_NODE: Exepected error occurred in update_oss_in_bcol API',5);
3827: End if;
3828: raise FND_API.G_EXC_ERROR;
3829: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3830: IF PG_DEBUG <> 0 Then
3831: oe_debug_pub.add(lpad(' ',g_pg_level)||
3832: 'FIND_LEAF_NODE: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 3829: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3825: oe_debug_pub.add(lpad(' ',g_pg_level)||
3826: 'FIND_LEAF_NODE: Exepected error occurred in update_oss_in_bcol API',5);
3827: End if;
3828: raise FND_API.G_EXC_ERROR;
3829: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3830: IF PG_DEBUG <> 0 Then
3831: oe_debug_pub.add(lpad(' ',g_pg_level)||
3832: 'FIND_LEAF_NODE: Un Exepected error occurred in update_oss_in_bcol API',5);
3833: End if;

Line 3834: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3830: IF PG_DEBUG <> 0 Then
3831: oe_debug_pub.add(lpad(' ',g_pg_level)||
3832: 'FIND_LEAF_NODE: Un Exepected error occurred in update_oss_in_bcol API',5);
3833: End if;
3834: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3835: End if;
3836:
3837: End if;/* Sql%rowcount <> 0 then */
3838: End Loop;

Line 3872: If x_return_status = FND_API.G_RET_STS_ERROR Then

3868: p_valid_flag => 'Y',
3869: x_return_status => x_return_status,
3870: x_msg_count => x_msg_count,
3871: x_msg_data => x_msg_data);
3872: If x_return_status = FND_API.G_RET_STS_ERROR Then
3873: IF PG_DEBUG <> 0 Then
3874: oe_debug_pub.add(lpad(' ',g_pg_level)||
3875: 'FIND_LEAF_NODE: Exepected error occurred in update_oss_in_bcol API',5);
3876: End if;

Line 3877: raise FND_API.G_EXC_ERROR;

3873: IF PG_DEBUG <> 0 Then
3874: oe_debug_pub.add(lpad(' ',g_pg_level)||
3875: 'FIND_LEAF_NODE: Exepected error occurred in update_oss_in_bcol API',5);
3876: End if;
3877: raise FND_API.G_EXC_ERROR;
3878: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3879: IF PG_DEBUG <> 0 Then
3880: oe_debug_pub.add(lpad(' ',g_pg_level)||
3881: 'FIND_LEAF_NODE: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 3878: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3874: oe_debug_pub.add(lpad(' ',g_pg_level)||
3875: 'FIND_LEAF_NODE: Exepected error occurred in update_oss_in_bcol API',5);
3876: End if;
3877: raise FND_API.G_EXC_ERROR;
3878: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3879: IF PG_DEBUG <> 0 Then
3880: oe_debug_pub.add(lpad(' ',g_pg_level)||
3881: 'FIND_LEAF_NODE: Un Exepected error occurred in update_oss_in_bcol API',5);
3882: End if;

Line 3883: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3879: IF PG_DEBUG <> 0 Then
3880: oe_debug_pub.add(lpad(' ',g_pg_level)||
3881: 'FIND_LEAF_NODE: Un Exepected error occurred in update_oss_in_bcol API',5);
3882: End if;
3883: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3884: End if;
3885:
3886: End if;
3887: End if; /* l_source_type.count = 0 */

Line 3946: if x_return_status = FND_API.G_RET_STS_ERROR Then

3942: p_valid_flag => 'Y',
3943: x_return_status => x_return_status,
3944: x_msg_count => x_msg_count,
3945: x_msg_data => x_msg_data);
3946: if x_return_status = FND_API.G_RET_STS_ERROR Then
3947: IF PG_DEBUG <> 0 Then
3948: oe_debug_pub.add(lpad(' ',g_pg_level)||
3949: 'TRAVERSE_UP_TREE: Exepected error occurred in update_oss_in_bcol API',5);
3950: End if;

Line 3951: raise FND_API.G_EXC_ERROR;

3947: IF PG_DEBUG <> 0 Then
3948: oe_debug_pub.add(lpad(' ',g_pg_level)||
3949: 'TRAVERSE_UP_TREE: Exepected error occurred in update_oss_in_bcol API',5);
3950: End if;
3951: raise FND_API.G_EXC_ERROR;
3952: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3953: IF PG_DEBUG <> 0 Then
3954: oe_debug_pub.add(lpad(' ',g_pg_level)||
3955: 'TRAVERSE_UP_TREE: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 3952: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

3948: oe_debug_pub.add(lpad(' ',g_pg_level)||
3949: 'TRAVERSE_UP_TREE: Exepected error occurred in update_oss_in_bcol API',5);
3950: End if;
3951: raise FND_API.G_EXC_ERROR;
3952: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
3953: IF PG_DEBUG <> 0 Then
3954: oe_debug_pub.add(lpad(' ',g_pg_level)||
3955: 'TRAVERSE_UP_TREE: Un Exepected error occurred in update_oss_in_bcol API',5);
3956: End if;

Line 3957: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3953: IF PG_DEBUG <> 0 Then
3954: oe_debug_pub.add(lpad(' ',g_pg_level)||
3955: 'TRAVERSE_UP_TREE: Un Exepected error occurred in update_oss_in_bcol API',5);
3956: End if;
3957: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3958: End if;
3959:
3960:
3961: null;

Line 4004: x_return_status := FND_API.G_RET_STS_SUCCESS;

4000:
4001: PG_DEBUG := 5;
4002: g_pg_level := 1;
4003:
4004: x_return_status := FND_API.G_RET_STS_SUCCESS;
4005: l_stmt_num := 10;
4006:
4007: oe_debug_pub.add('=========================================================================',1);
4008: oe_debug_pub.add(' ',1);

Line 4115: If x_return_status = FND_API.G_RET_STS_ERROR Then

4111: x_msg_count => x_msg_count,
4112: x_msg_data => x_msg_data
4113: );
4114:
4115: If x_return_status = FND_API.G_RET_STS_ERROR Then
4116: IF PG_DEBUG <> 0 Then
4117: oe_debug_pub.add(lpad(' ',g_pg_level)||
4118: 'GET_OSS_ORGS_LIST: Exepected error occurred in get_configurations_org API',5);
4119: End if;

Line 4120: raise FND_API.G_EXC_ERROR;

4116: IF PG_DEBUG <> 0 Then
4117: oe_debug_pub.add(lpad(' ',g_pg_level)||
4118: 'GET_OSS_ORGS_LIST: Exepected error occurred in get_configurations_org API',5);
4119: End if;
4120: raise FND_API.G_EXC_ERROR;
4121: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
4122: IF PG_DEBUG <> 0 Then
4123: oe_debug_pub.add(lpad(' ',g_pg_level)||
4124: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_configurations_org API',5);

Line 4121: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

4117: oe_debug_pub.add(lpad(' ',g_pg_level)||
4118: 'GET_OSS_ORGS_LIST: Exepected error occurred in get_configurations_org API',5);
4119: End if;
4120: raise FND_API.G_EXC_ERROR;
4121: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
4122: IF PG_DEBUG <> 0 Then
4123: oe_debug_pub.add(lpad(' ',g_pg_level)||
4124: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_configurations_org API',5);
4125: End if;

Line 4126: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4122: IF PG_DEBUG <> 0 Then
4123: oe_debug_pub.add(lpad(' ',g_pg_level)||
4124: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_configurations_org API',5);
4125: End if;
4126: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4127: End if;
4128:
4129: /* The following is the procedure to get the organizations for all the ato items and
4130: matched configurations.

Line 4142: If x_return_status = FND_API.G_RET_STS_ERROR Then

4138: x_msg_count => x_msg_count,
4139: x_msg_data => x_msg_data
4140: );
4141:
4142: If x_return_status = FND_API.G_RET_STS_ERROR Then
4143: IF PG_DEBUG <> 0 Then
4144: oe_debug_pub.add(lpad(' ',g_pg_level)||
4145: 'GET_OSS_ORGS_LIST: Exepected error occurred in get_configurations_org API',5);
4146: End if;

Line 4147: raise FND_API.G_EXC_ERROR;

4143: IF PG_DEBUG <> 0 Then
4144: oe_debug_pub.add(lpad(' ',g_pg_level)||
4145: 'GET_OSS_ORGS_LIST: Exepected error occurred in get_configurations_org API',5);
4146: End if;
4147: raise FND_API.G_EXC_ERROR;
4148: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
4149: IF PG_DEBUG <> 0 Then
4150: oe_debug_pub.add(lpad(' ',g_pg_level)||
4151: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_configurations_org API',5);

Line 4148: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

4144: oe_debug_pub.add(lpad(' ',g_pg_level)||
4145: 'GET_OSS_ORGS_LIST: Exepected error occurred in get_configurations_org API',5);
4146: End if;
4147: raise FND_API.G_EXC_ERROR;
4148: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
4149: IF PG_DEBUG <> 0 Then
4150: oe_debug_pub.add(lpad(' ',g_pg_level)||
4151: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_configurations_org API',5);
4152: End if;

Line 4153: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4149: IF PG_DEBUG <> 0 Then
4150: oe_debug_pub.add(lpad(' ',g_pg_level)||
4151: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_configurations_org API',5);
4152: End if;
4153: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4154: End if;
4155:
4156:
4157:

Line 4209: WHEN FND_API.G_EXC_ERROR THEN

4205:
4206:
4207: Exception
4208:
4209: WHEN FND_API.G_EXC_ERROR THEN
4210: IF PG_DEBUG <> 0 THEN
4211: oe_debug_pub.add(lpad(' ',g_pg_level)||'Get_OSS_Orgs_list::exp error::'
4212: ||to_char(l_stmt_num)
4213: ||'::'||sqlerrm,1);

Line 4215: x_return_status := FND_API.G_RET_STS_ERROR;

4211: oe_debug_pub.add(lpad(' ',g_pg_level)||'Get_OSS_Orgs_list::exp error::'
4212: ||to_char(l_stmt_num)
4213: ||'::'||sqlerrm,1);
4214: END IF;
4215: x_return_status := FND_API.G_RET_STS_ERROR;
4216: cto_msg_pub.count_and_get(
4217: p_msg_count => x_msg_count,
4218: p_msg_data => x_msg_data
4219: );

Line 4220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4216: cto_msg_pub.count_and_get(
4217: p_msg_count => x_msg_count,
4218: p_msg_data => x_msg_data
4219: );
4220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4221: IF PG_DEBUG <> 0 THEN
4222: oe_debug_pub.add(lpad(' ',g_pg_level)||'Get_OSS_Orgs_list::exp error::'
4223: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4224: END IF;

Line 4225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4221: IF PG_DEBUG <> 0 THEN
4222: oe_debug_pub.add(lpad(' ',g_pg_level)||'Get_OSS_Orgs_list::exp error::'
4223: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4224: END IF;
4225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4226: cto_msg_pub.count_and_get(
4227: p_msg_count => x_msg_count,
4228: p_msg_data => x_msg_data
4229: );

Line 4235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4231: IF PG_DEBUG <> 0 THEN
4232: oe_debug_pub.add(lpad(' ',g_pg_level)||'Get_OSS_Orgs_list::exp error::'
4233: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4234: END IF;
4235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4236: cto_msg_pub.count_and_get(
4237: p_msg_count => x_msg_count,
4238: p_msg_data => x_msg_data
4239: );

Line 4299: x_return_status := FND_API.G_RET_STS_SUCCESS;

4295:
4296: Begin
4297:
4298: g_pg_level := g_pg_level + 3;
4299: x_return_status := FND_API.G_RET_STS_SUCCESS;
4300:
4301:
4302: If PG_DEBUG <> 0 Then
4303: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_CONFIGURATIONS_ORG : Entering Model Process',5);

Line 4330: If x_return_status = FND_API.G_RET_STS_ERROR Then

4326: x_oss_exists => x_oss_exists,
4327: x_return_status => x_return_status,
4328: x_msg_data => x_msg_data,
4329: x_msg_count => x_msg_count);
4330: If x_return_status = FND_API.G_RET_STS_ERROR Then
4331: IF PG_DEBUG <> 0 Then
4332: oe_debug_pub.add(lpad(' ',g_pg_level)||
4333: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
4334: End if;

Line 4335: raise FND_API.G_EXC_ERROR;

4331: IF PG_DEBUG <> 0 Then
4332: oe_debug_pub.add(lpad(' ',g_pg_level)||
4333: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
4334: End if;
4335: raise FND_API.G_EXC_ERROR;
4336: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
4337: IF PG_DEBUG <> 0 Then
4338: oe_debug_pub.add(lpad(' ',g_pg_level)||
4339: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 4336: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

4332: oe_debug_pub.add(lpad(' ',g_pg_level)||
4333: 'GET_OSS_ORGS_LIST: Exepected error occurred in update_oss_in_bcol API',5);
4334: End if;
4335: raise FND_API.G_EXC_ERROR;
4336: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
4337: IF PG_DEBUG <> 0 Then
4338: oe_debug_pub.add(lpad(' ',g_pg_level)||
4339: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
4340: End if;

Line 4341: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4337: IF PG_DEBUG <> 0 Then
4338: oe_debug_pub.add(lpad(' ',g_pg_level)||
4339: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in update_oss_in_bcol API',5);
4340: End if;
4341: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4342: End if;
4343:
4344:
4345: If X_oss_exists = 'Y' Then

Line 4358: If x_return_status = FND_API.G_RET_STS_ERROR Then

4354: x_return_status => x_return_status,
4355: x_msg_data => x_msg_data,
4356: x_msg_count => x_msg_count);
4357:
4358: If x_return_status = FND_API.G_RET_STS_ERROR Then
4359:
4360: IF PG_DEBUG <> 0 Then
4361: oe_debug_pub.add(lpad(' ',g_pg_level)||
4362: 'GET_OSS_ORGS_LIST: Exepected error occurred in get_sourcing_data API',5);

Line 4364: raise FND_API.G_EXC_ERROR;

4360: IF PG_DEBUG <> 0 Then
4361: oe_debug_pub.add(lpad(' ',g_pg_level)||
4362: 'GET_OSS_ORGS_LIST: Exepected error occurred in get_sourcing_data API',5);
4363: End if;
4364: raise FND_API.G_EXC_ERROR;
4365: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
4366: IF PG_DEBUG <> 0 Then
4367: oe_debug_pub.add(lpad(' ',g_pg_level)||
4368: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_sourcing_data API',5);

Line 4365: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

4361: oe_debug_pub.add(lpad(' ',g_pg_level)||
4362: 'GET_OSS_ORGS_LIST: Exepected error occurred in get_sourcing_data API',5);
4363: End if;
4364: raise FND_API.G_EXC_ERROR;
4365: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
4366: IF PG_DEBUG <> 0 Then
4367: oe_debug_pub.add(lpad(' ',g_pg_level)||
4368: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_sourcing_data API',5);
4369: End if;

Line 4370: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4366: IF PG_DEBUG <> 0 Then
4367: oe_debug_pub.add(lpad(' ',g_pg_level)||
4368: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_sourcing_data API',5);
4369: End if;
4370: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4371: End if; /* x_return_status = FND_API.G_RET_STS_ERROR */
4372:
4373: Process_order_for_oss(
4374: p_ato_line_id => oss_top_model_rec.ato_line_id,

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

4367: oe_debug_pub.add(lpad(' ',g_pg_level)||
4368: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in get_sourcing_data API',5);
4369: End if;
4370: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4371: End if; /* x_return_status = FND_API.G_RET_STS_ERROR */
4372:
4373: Process_order_for_oss(
4374: p_ato_line_id => oss_top_model_rec.ato_line_id,
4375: p_calling_mode => 'ATP',

Line 4380: If x_return_status = FND_API.G_RET_STS_ERROR Then

4376: x_return_status => x_return_status,
4377: x_msg_count => x_msg_count,
4378: x_msg_data => x_msg_data);
4379:
4380: If x_return_status = FND_API.G_RET_STS_ERROR Then
4381: IF PG_DEBUG <> 0 Then
4382: oe_debug_pub.add(lpad(' ',g_pg_level)||
4383: 'GET_CONFIGURATIONS_ORG: Exepected error occurred in update_oss_in_bcol API',5);
4384: End if;

Line 4385: raise FND_API.G_EXC_ERROR;

4381: IF PG_DEBUG <> 0 Then
4382: oe_debug_pub.add(lpad(' ',g_pg_level)||
4383: 'GET_CONFIGURATIONS_ORG: Exepected error occurred in update_oss_in_bcol API',5);
4384: End if;
4385: raise FND_API.G_EXC_ERROR;
4386: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
4387: IF PG_DEBUG <> 0 Then
4388: oe_debug_pub.add(lpad(' ',g_pg_level)||
4389: 'GET_CONFIGURATIONS_ORG: Un Exepected error occurred in update_oss_in_bcol API',5);

Line 4386: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

4382: oe_debug_pub.add(lpad(' ',g_pg_level)||
4383: 'GET_CONFIGURATIONS_ORG: Exepected error occurred in update_oss_in_bcol API',5);
4384: End if;
4385: raise FND_API.G_EXC_ERROR;
4386: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
4387: IF PG_DEBUG <> 0 Then
4388: oe_debug_pub.add(lpad(' ',g_pg_level)||
4389: 'GET_CONFIGURATIONS_ORG: Un Exepected error occurred in update_oss_in_bcol API',5);
4390: End if;

Line 4391: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4387: IF PG_DEBUG <> 0 Then
4388: oe_debug_pub.add(lpad(' ',g_pg_level)||
4389: 'GET_CONFIGURATIONS_ORG: Un Exepected error occurred in update_oss_in_bcol API',5);
4390: End if;
4391: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4392: End if;
4393:
4394: Else
4395:

Line 4511: WHEN FND_API.G_EXC_ERROR THEN

4507: END IF;
4508:
4509: Exception
4510:
4511: WHEN FND_API.G_EXC_ERROR THEN
4512: IF PG_DEBUG <> 0 THEN
4513: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_CONFIGURATIONS_ORG: get_configurations_org::exp error::'
4514: ||to_char(l_stmt_no)
4515: ||'::'||sqlerrm,1);

Line 4518: x_return_status := FND_API.G_RET_STS_ERROR;

4514: ||to_char(l_stmt_no)
4515: ||'::'||sqlerrm,1);
4516: END IF;
4517: g_pg_level := g_pg_level - 3;
4518: x_return_status := FND_API.G_RET_STS_ERROR;
4519: cto_msg_pub.count_and_get(
4520: p_msg_count => x_msg_count,
4521: p_msg_data => x_msg_data
4522: );

Line 4523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4519: cto_msg_pub.count_and_get(
4520: p_msg_count => x_msg_count,
4521: p_msg_data => x_msg_data
4522: );
4523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4524: IF PG_DEBUG <> 0 THEN
4525: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_CONFIGURATIONS_ORG: get_configurations_org::exp error::'
4526: ||to_char(l_stmt_no)||'::'||sqlerrm,1);
4527: END IF;

Line 4529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4525: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_CONFIGURATIONS_ORG: get_configurations_org::exp error::'
4526: ||to_char(l_stmt_no)||'::'||sqlerrm,1);
4527: END IF;
4528: g_pg_level := g_pg_level - 3;
4529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4530: cto_msg_pub.count_and_get(
4531: p_msg_count => x_msg_count,
4532: p_msg_data => x_msg_data
4533: );

Line 4540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4536: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_CONFIGURATIONS_ORG: get_configurations_org::exp error::'
4537: ||to_char(l_stmt_no)||'::'||sqlerrm,1);
4538: END IF;
4539: g_pg_level := g_pg_level - 3;
4540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4541: cto_msg_pub.count_and_get(
4542: p_msg_count => x_msg_count,
4543: p_msg_data => x_msg_data
4544: );

Line 4564: x_return_status := FND_API.G_RET_STS_SUCCESS;

4560:
4561: Begin
4562:
4563: g_pg_level := g_pg_level + 3;
4564: x_return_status := FND_API.G_RET_STS_SUCCESS;
4565:
4566: l_stmt_num := 10;
4567:
4568: If PG_DEBUG <> 0 Then

Line 4749: WHEN FND_API.G_EXC_ERROR THEN

4745: END IF;
4746:
4747: Exception
4748:
4749: WHEN FND_API.G_EXC_ERROR THEN
4750: IF PG_DEBUG <> 0 THEN
4751: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ATO_ITEM_ORGS::exp error::'
4752: ||to_char(l_stmt_num)
4753: ||'::'||sqlerrm,1);

Line 4756: x_return_status := FND_API.G_RET_STS_ERROR;

4752: ||to_char(l_stmt_num)
4753: ||'::'||sqlerrm,1);
4754: END IF;
4755: g_pg_level := g_pg_level - 3;
4756: x_return_status := FND_API.G_RET_STS_ERROR;
4757: cto_msg_pub.count_and_get(
4758: p_msg_count => x_msg_count,
4759: p_msg_data => x_msg_data
4760: );

Line 4761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4757: cto_msg_pub.count_and_get(
4758: p_msg_count => x_msg_count,
4759: p_msg_data => x_msg_data
4760: );
4761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4762: IF PG_DEBUG <> 0 THEN
4763: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ATO_ITEM_ORGS::exp error::'
4764: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4765: END IF;

Line 4767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4763: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ATO_ITEM_ORGS::exp error::'
4764: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4765: END IF;
4766: g_pg_level := g_pg_level - 3;
4767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4768: cto_msg_pub.count_and_get(
4769: p_msg_count => x_msg_count,
4770: p_msg_data => x_msg_data
4771: );

Line 4778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4774: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ATO_ITEM_ORGS::exp error::'
4775: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4776: END IF;
4777: g_pg_level := g_pg_level - 3;
4778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4779: cto_msg_pub.count_and_get(
4780: p_msg_count => x_msg_count,
4781: p_msg_data => x_msg_data
4782: );

Line 4834: x_return_status := FND_API.G_RET_STS_SUCCESS;

4830:
4831:
4832: Begin
4833:
4834: x_return_status := FND_API.G_RET_STS_SUCCESS;
4835: g_pg_level := g_pg_level + 3;
4836:
4837: IF PG_DEBUG <> 0 Then
4838: oe_debug_pub.add(lpad(' ',g_pg_level)||'UPDATE_OSS_IN_BCOL: In UPDATE_OSS_BCOL API',5);

Line 4981: WHEN FND_API.G_EXC_ERROR THEN

4977:
4978: g_pg_level := g_pg_level - 3;
4979:
4980: Exception
4981: WHEN FND_API.G_EXC_ERROR THEN
4982: IF PG_DEBUG <> 0 THEN
4983: oe_debug_pub.add(lpad(' ',g_pg_level)||'UPDATE_OSS_IN_BCOL::exp error::'
4984: ||to_char(l_stmt_num)
4985: ||'::'||sqlerrm,1);

Line 4988: x_return_status := FND_API.G_RET_STS_ERROR;

4984: ||to_char(l_stmt_num)
4985: ||'::'||sqlerrm,1);
4986: END IF;
4987: g_pg_level := g_pg_level - 3;
4988: x_return_status := FND_API.G_RET_STS_ERROR;
4989: cto_msg_pub.count_and_get(
4990: p_msg_count => x_msg_count,
4991: p_msg_data => x_msg_data
4992: );

Line 4993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4989: cto_msg_pub.count_and_get(
4990: p_msg_count => x_msg_count,
4991: p_msg_data => x_msg_data
4992: );
4993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4994: IF PG_DEBUG <> 0 THEN
4995: oe_debug_pub.add(lpad(' ',g_pg_level)||'UPDATE_OSS_IN_BCOL::exp error::'
4996: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4997: END IF;

Line 4999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4995: oe_debug_pub.add(lpad(' ',g_pg_level)||'UPDATE_OSS_IN_BCOL::exp error::'
4996: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
4997: END IF;
4998: g_pg_level := g_pg_level - 3;
4999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5000: cto_msg_pub.count_and_get(
5001: p_msg_count => x_msg_count,
5002: p_msg_data => x_msg_data
5003: );

Line 5010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5006: oe_debug_pub.add(lpad(' ',g_pg_level)||'UPDATE_OSS_IN_BCOL::exp error::'
5007: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5008: END IF;
5009: g_pg_level := g_pg_level - 3;
5010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5011: cto_msg_pub.count_and_get(
5012: p_msg_count => x_msg_count,
5013: p_msg_data => x_msg_data
5014: );

Line 5041: x_return_status := FND_API.G_RET_STS_SUCCESS;

5037: l_parent_ato_line_id Number;
5038: l_stmt_num Number;
5039: Begin
5040:
5041: x_return_status := FND_API.G_RET_STS_SUCCESS;
5042: l_stmt_num := 10;
5043: g_pg_level := g_pg_level + 3;
5044:
5045: /* If the parent is already marked, we don't need to mark it again

Line 5137: WHEN FND_API.G_EXC_ERROR THEN

5133:
5134: g_pg_level := g_pg_level - 3;
5135:
5136: Exception
5137: WHEN FND_API.G_EXC_ERROR THEN
5138: IF PG_DEBUG <> 0 THEN
5139: oe_debug_pub.add(lpad(' ',g_pg_level)||'UPDATE_PARENT_OSS_LINE::exp error::'
5140: ||to_char(l_stmt_num)
5141: ||'::'||sqlerrm,1);

Line 5144: x_return_status := FND_API.G_RET_STS_ERROR;

5140: ||to_char(l_stmt_num)
5141: ||'::'||sqlerrm,1);
5142: END IF;
5143: g_pg_level := g_pg_level - 3;
5144: x_return_status := FND_API.G_RET_STS_ERROR;
5145: cto_msg_pub.count_and_get(
5146: p_msg_count => x_msg_count,
5147: p_msg_data => x_msg_data
5148: );

Line 5149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5145: cto_msg_pub.count_and_get(
5146: p_msg_count => x_msg_count,
5147: p_msg_data => x_msg_data
5148: );
5149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5150: IF PG_DEBUG <> 0 THEN
5151: oe_debug_pub.add(lpad(' ',g_pg_level)||'UPDATE_PARENT_OSS_LINE::exp error::'
5152: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5153: END IF;

Line 5155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5151: oe_debug_pub.add(lpad(' ',g_pg_level)||'UPDATE_PARENT_OSS_LINE::exp error::'
5152: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5153: END IF;
5154: g_pg_level := g_pg_level - 3;
5155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5156: cto_msg_pub.count_and_get(
5157: p_msg_count => x_msg_count,
5158: p_msg_data => x_msg_data
5159: );

Line 5166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5162: oe_debug_pub.add(lpad(' ',g_pg_level)||'UPDATE_PARENT_OSS_LINE::exp error::'
5163: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5164: END IF;
5165: g_pg_level := g_pg_level - 3;
5166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5167: cto_msg_pub.count_and_get(
5168: p_msg_count => x_msg_count,
5169: p_msg_data => x_msg_data
5170: );

Line 5184: x_return_status := FND_API.G_RET_STS_SUCCESS;

5180: l_stmt_num Number;
5181:
5182: begin
5183: g_pg_level := g_pg_level + 3;
5184: x_return_status := FND_API.G_RET_STS_SUCCESS;
5185: l_stmt_num := 10;
5186:
5187: IF PG_DEBUG <> 0 Then
5188: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_SOURCING_DATA: Inside GET_SOURCING_DATA API',5);

Line 5513: x_return_status := FND_API.G_RET_STS_SUCCESS;

5509: VALIDATION_ORG
5510: FROM bom_cto_order_lines_gt;
5511:
5512: Begin
5513: x_return_status := FND_API.G_RET_STS_SUCCESS;
5514: l_stmt_num := 10;
5515: g_pg_level := g_pg_level + 3;
5516:
5517: If PG_DEBUG <> 0 Then

Line 5593: If x_return_status = FND_API.G_RET_STS_ERROR Then

5589: x_msg_count => x_msg_count,
5590: x_msg_data => x_msg_data
5591: );
5592:
5593: If x_return_status = FND_API.G_RET_STS_ERROR Then
5594: IF PG_DEBUG <> 0 Then
5595: oe_debug_pub.add(lpad(' ',g_pg_level)||
5596: 'GET_OSS_ORGS_LIST: Exepected error occurred in prune_oss_config API',5);
5597: End if;

Line 5598: raise FND_API.G_EXC_ERROR;

5594: IF PG_DEBUG <> 0 Then
5595: oe_debug_pub.add(lpad(' ',g_pg_level)||
5596: 'GET_OSS_ORGS_LIST: Exepected error occurred in prune_oss_config API',5);
5597: End if;
5598: raise FND_API.G_EXC_ERROR;
5599:
5600: Elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
5601:
5602: IF PG_DEBUG <> 0 Then

Line 5600: Elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

5596: 'GET_OSS_ORGS_LIST: Exepected error occurred in prune_oss_config API',5);
5597: End if;
5598: raise FND_API.G_EXC_ERROR;
5599:
5600: Elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
5601:
5602: IF PG_DEBUG <> 0 Then
5603: oe_debug_pub.add(lpad(' ',g_pg_level)||
5604: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in prune_oss_config API',5);

Line 5606: raise FND_API.G_EXC_UNEXPECTED_ERROR;

5602: IF PG_DEBUG <> 0 Then
5603: oe_debug_pub.add(lpad(' ',g_pg_level)||
5604: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in prune_oss_config API',5);
5605: End if;
5606: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5607:
5608: End if; /* x_return_status = FND_API.G_RET_STS_ERROR */
5609:
5610:

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

5604: 'GET_OSS_ORGS_LIST: Un Exepected error occurred in prune_oss_config API',5);
5605: End if;
5606: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5607:
5608: End if; /* x_return_status = FND_API.G_RET_STS_ERROR */
5609:
5610:
5611: If x_exp_error_code <> 0 Then
5612: l_stmt_num :=80;

Line 5673: If x_return_status = FND_API.G_RET_STS_ERROR Then

5669: x_msg_count => x_msg_count,
5670: x_msg_data => x_msg_data
5671: );
5672:
5673: If x_return_status = FND_API.G_RET_STS_ERROR Then
5674: IF PG_DEBUG <> 0 Then
5675: oe_debug_pub.add(lpad(' ',g_pg_level)||
5676: 'PROCESS_ORDER_FOR_OSS: Exepected error occurred in prune_parent_oss_config API',5);
5677: End if;

Line 5678: raise FND_API.G_EXC_ERROR;

5674: IF PG_DEBUG <> 0 Then
5675: oe_debug_pub.add(lpad(' ',g_pg_level)||
5676: 'PROCESS_ORDER_FOR_OSS: Exepected error occurred in prune_parent_oss_config API',5);
5677: End if;
5678: raise FND_API.G_EXC_ERROR;
5679: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
5680: IF PG_DEBUG <> 0 Then
5681: oe_debug_pub.add(lpad(' ',g_pg_level)||
5682: 'PROCESS_ORDER_FOR_OSS: Un Exepected error occurred in prune_parent_oss_config API',5);

Line 5679: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then

5675: oe_debug_pub.add(lpad(' ',g_pg_level)||
5676: 'PROCESS_ORDER_FOR_OSS: Exepected error occurred in prune_parent_oss_config API',5);
5677: End if;
5678: raise FND_API.G_EXC_ERROR;
5679: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
5680: IF PG_DEBUG <> 0 Then
5681: oe_debug_pub.add(lpad(' ',g_pg_level)||
5682: 'PROCESS_ORDER_FOR_OSS: Un Exepected error occurred in prune_parent_oss_config API',5);
5683: End if;

Line 5684: raise FND_API.G_EXC_UNEXPECTED_ERROR;

5680: IF PG_DEBUG <> 0 Then
5681: oe_debug_pub.add(lpad(' ',g_pg_level)||
5682: 'PROCESS_ORDER_FOR_OSS: Un Exepected error occurred in prune_parent_oss_config API',5);
5683: End if;
5684: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5685: End if; /* x_return_status = FND_API.G_RET_STS_ERROR */
5686:
5687: If x_exp_error_code <> 0 Then
5688: l_stmt_num := 120;

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

5681: oe_debug_pub.add(lpad(' ',g_pg_level)||
5682: 'PROCESS_ORDER_FOR_OSS: Un Exepected error occurred in prune_parent_oss_config API',5);
5683: End if;
5684: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5685: End if; /* x_return_status = FND_API.G_RET_STS_ERROR */
5686:
5687: If x_exp_error_code <> 0 Then
5688: l_stmt_num := 120;
5689: update /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_U1) */

Line 5718: WHEN FND_API.G_EXC_ERROR THEN

5714:
5715: g_pg_level := g_pg_level - 3;
5716:
5717: Exception
5718: WHEN FND_API.G_EXC_ERROR THEN
5719: IF PG_DEBUG <> 0 THEN
5720: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_ORDER_FOR_OSS::exp error::'
5721: ||to_char(l_stmt_num)
5722: ||'::'||sqlerrm,1);

Line 5725: x_return_status := FND_API.G_RET_STS_ERROR;

5721: ||to_char(l_stmt_num)
5722: ||'::'||sqlerrm,1);
5723: END IF;
5724: g_pg_level := g_pg_level - 3;
5725: x_return_status := FND_API.G_RET_STS_ERROR;
5726: cto_msg_pub.count_and_get(
5727: p_msg_count => x_msg_count,
5728: p_msg_data => x_msg_data
5729: );

Line 5730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5726: cto_msg_pub.count_and_get(
5727: p_msg_count => x_msg_count,
5728: p_msg_data => x_msg_data
5729: );
5730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5731: IF PG_DEBUG <> 0 THEN
5732: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_ORDER_FOR_OSS::exp error::'
5733: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5734: END IF;

Line 5736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5732: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_ORDER_FOR_OSS::exp error::'
5733: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5734: END IF;
5735: g_pg_level := g_pg_level - 3;
5736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5737: cto_msg_pub.count_and_get(
5738: p_msg_count => x_msg_count,
5739: p_msg_data => x_msg_data
5740: );

Line 5747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5743: oe_debug_pub.add(lpad(' ',g_pg_level)||'PROCESS_ORDER_FOR_OSS::exp error::'
5744: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
5745: END IF;
5746: g_pg_level := g_pg_level - 3;
5747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5748: cto_msg_pub.count_and_get(
5749: p_msg_count => x_msg_count,
5750: p_msg_data => x_msg_data
5751: );

Line 5764: x_return_status := FND_API.G_RET_STS_SUCCESS;

5760: l_stmt_num Number;
5761: Begin
5762:
5763: g_pg_level := g_pg_level + 3;
5764: x_return_status := FND_API.G_RET_STS_SUCCESS;
5765: l_stmt_num := 10;
5766:
5767: If pg_debug <> 0 Then
5768: oe_debug_pub.add(lpad(' ',g_pg_level)||'COPY_TO_BCOL_TEMP: Inside Copy to Bcol Temp API',5);

Line 5880: x_return_status := FND_API.G_RET_STS_SUCCESS;

5876: Begin
5877:
5878: l_stmt_num := 10;
5879: g_pg_level := g_pg_level + 3;
5880: x_return_status := FND_API.G_RET_STS_SUCCESS;
5881:
5882: delete /*+ INDEX (oss_src BOM_CTO_OSS_SOURCE_GT_N1) */
5883: from bom_cto_oss_source_gt oss_src where ato_line_id = p_ato_line_id;
5884:

Line 6167: WHEN FND_API.G_EXC_ERROR THEN

6163:
6164: g_pg_level := g_pg_level - 3;
6165:
6166: Exception
6167: WHEN FND_API.G_EXC_ERROR THEN
6168: IF PG_DEBUG <> 0 THEN
6169: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ORDER_SOURCING_DATA::exp error::'
6170: ||to_char(l_stmt_num)
6171: ||'::'||sqlerrm,1);

Line 6174: x_return_status := FND_API.G_RET_STS_ERROR;

6170: ||to_char(l_stmt_num)
6171: ||'::'||sqlerrm,1);
6172: END IF;
6173: g_pg_level := g_pg_level - 3;
6174: x_return_status := FND_API.G_RET_STS_ERROR;
6175: cto_msg_pub.count_and_get(
6176: p_msg_count => x_msg_count,
6177: p_msg_data => x_msg_data
6178: );

Line 6179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6175: cto_msg_pub.count_and_get(
6176: p_msg_count => x_msg_count,
6177: p_msg_data => x_msg_data
6178: );
6179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6180: IF PG_DEBUG <> 0 THEN
6181: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ORDER_SOURCING_DATA::exp error::'
6182: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
6183: END IF;

Line 6185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6181: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ORDER_SOURCING_DATA::exp error::'
6182: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
6183: END IF;
6184: g_pg_level := g_pg_level - 3;
6185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6186: cto_msg_pub.count_and_get(
6187: p_msg_count => x_msg_count,
6188: p_msg_data => x_msg_data
6189: );

Line 6196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6192: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ORDER_SOURCING_DATA::exp error::'
6193: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
6194: END IF;
6195: g_pg_level := g_pg_level - 3;
6196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6197: cto_msg_pub.count_and_get(
6198: p_msg_count => x_msg_count,
6199: p_msg_data => x_msg_data
6200: );

Line 6243: x_return_status := FND_API.G_RET_STS_SUCCESS;

6239: l_stmt_num Number;
6240: Begin
6241: l_stmt_num := 10;
6242: g_pg_level := g_pg_level + 3;
6243: x_return_status := FND_API.G_RET_STS_SUCCESS;
6244:
6245: IF PG_DEBUG <> 0 Then
6246: oe_debug_pub.add(lpad(' ',g_pg_level)||'TRAVERSE_SOURCING_CHAIN: Inside Traverse_Souricng_Chain API',5);
6247: End if;

Line 6259: raise FND_API.G_EXC_ERROR;

6255: if PG_DEBUG <> 0 then
6256: oe_debug_pub.add(lpad(' ',g_pg_level)||'TRAVERSE_SOURCING_CHAIN: Circular sourcing deducted..',5);
6257: end if;
6258: cto_msg_pub.cto_message('BOM','CTO_INVALID_SOURCING');
6259: raise FND_API.G_EXC_ERROR;
6260: Else
6261: -- Push the org to the stack
6262: G_source_org_stk(p_org_id) := p_org_id;
6263: End if;

Line 6390: x_return_status := FND_API.G_RET_STS_SUCCESS;

6386: Begin
6387:
6388: l_stmt_num := 10;
6389: g_pg_level := g_pg_level + 3;
6390: x_return_status := FND_API.G_RET_STS_SUCCESS;
6391: i := 1;
6392:
6393: If PG_DEBUG <> 0 Then
6394: oe_debug_pub.add(lpad(' ',g_pg_level)||'QUERY_OSS_SOURCING_ORG: Inside Query OSS Sourcing Org API',5);

Line 6496: WHEN FND_API.G_EXC_ERROR THEN

6492: End if;
6493:
6494: g_pg_level := g_pg_level - 3;
6495: Exception
6496: WHEN FND_API.G_EXC_ERROR THEN
6497: IF PG_DEBUG <> 0 THEN
6498: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ORDER_SOURCING_DATA::exp error::'
6499: ||to_char(l_stmt_num)
6500: ||'::'||sqlerrm,1);

Line 6503: x_return_status := FND_API.G_RET_STS_ERROR;

6499: ||to_char(l_stmt_num)
6500: ||'::'||sqlerrm,1);
6501: END IF;
6502: g_pg_level := g_pg_level - 3;
6503: x_return_status := FND_API.G_RET_STS_ERROR;
6504: cto_msg_pub.count_and_get(
6505: p_msg_count => x_msg_count,
6506: p_msg_data => x_msg_data
6507: );

Line 6508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6504: cto_msg_pub.count_and_get(
6505: p_msg_count => x_msg_count,
6506: p_msg_data => x_msg_data
6507: );
6508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6509: IF PG_DEBUG <> 0 THEN
6510: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ORDER_SOURCING_DATA::exp error::'
6511: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
6512: END IF;

Line 6514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6510: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ORDER_SOURCING_DATA::exp error::'
6511: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
6512: END IF;
6513: g_pg_level := g_pg_level - 3;
6514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6515: cto_msg_pub.count_and_get(
6516: p_msg_count => x_msg_count,
6517: p_msg_data => x_msg_data
6518: );

Line 6525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6521: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_ORDER_SOURCING_DATA::exp error::'
6522: ||to_char(l_stmt_num)||'::'||sqlerrm,1);
6523: END IF;
6524: g_pg_level := g_pg_level - 3;
6525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6526: cto_msg_pub.count_and_get(
6527: p_msg_count => x_msg_count,
6528: p_msg_data => x_msg_data
6529: );

Line 6549: x_return_status := FND_API.G_RET_STS_SUCCESS;

6545: l_line_id number;
6546:
6547: Begin
6548: g_pg_level := nvl(g_pg_level,0) + 3;
6549: x_return_status := FND_API.G_RET_STS_SUCCESS;
6550: l_stmt_num := 10;
6551:
6552: oe_debug_pub.add(lpad(' ',g_pg_level)||'GET_OSS_BOM_ORGS: Begin ',1);
6553: