DBA Data[Home] [Help]

APPS.MSC_SATP_FUNC dependencies on FND_API

Line 412: x_return_status := FND_API.G_RET_STS_SUCCESS;

408: IF PG_DEBUG in ('Y', 'C') THEN
409: msc_sch_wb.atp_debug('***** Begin Extend_Atp Procedure *****');
410: END IF;
411:
412: x_return_status := FND_API.G_RET_STS_SUCCESS;
413: msc_atp_global.extend_atp(p_atp_tab,
414: x_return_status,
415: p_index);
416: /* --s_cto_enhc

Line 517: x_return_status := FND_API.G_RET_STS_SUCCESS;

513: IF PG_DEBUG in ('Y', 'C') THEN
514: msc_sch_wb.atp_debug('***** Begin Assign_Atp_Input_Rec Procedure *****');
515: END IF;
516:
517: x_return_status := FND_API.G_RET_STS_SUCCESS;
518:
519: -- copy the p_index th elements in p_atp_table and append it to x_atp_table
520:
521: l_count := x_atp_table.Action.COUNT;

Line 1109: x_return_status := FND_API.G_RET_STS_SUCCESS;

1105: IF PG_DEBUG in ('Y', 'C') THEN
1106: msc_sch_wb.atp_debug('***** Begin Assign_Atp_Output_Rec Procedure *****');
1107: END IF;
1108:
1109: x_return_status := FND_API.G_RET_STS_SUCCESS;
1110:
1111: -- append the p_atp_table to x_atp_tablecopy
1112:
1113: l_count := x_atp_table.Action.COUNT;

Line 1454: x_return_status := FND_API.G_RET_STS_SUCCESS;

1450: Begin
1451:
1452: -- msc_sch_wb.atp_debug('***** Begin Extend_Atp_Period Procedure *****');
1453:
1454: x_return_status := FND_API.G_RET_STS_SUCCESS;
1455:
1456: p_atp_period.Level.Extend;
1457: p_atp_period.Inventory_Item_Id.Extend;
1458: p_atp_period.Request_Item_Id.Extend;

Line 1517: x_return_status := FND_API.G_RET_STS_SUCCESS;

1513: msc_sch_wb.atp_debug('***** Begin Extend_Atp_Supply_Demand Procedure *****');
1514: msc_sch_wb.atp_debug('Extend_Atp_Supply_Demand: ' || 'p_index = ' || p_index);
1515: END IF;
1516:
1517: x_return_status := FND_API.G_RET_STS_SUCCESS;
1518:
1519: -- rajjain added p_index 12/10/2002
1520: p_atp_supply_demand.Level.Extend(p_index);
1521: p_atp_supply_demand.Inventory_Item_Id.Extend(p_index);

Line 1575: x_return_status := FND_API.G_RET_STS_SUCCESS;

1571: IF PG_DEBUG in ('Y', 'C') THEN
1572: msc_sch_wb.atp_debug('***** Begin Trim_Atp_Supply_Demand Procedure *****');
1573: msc_sch_wb.atp_debug('Trim_Atp_Supply_Demand: ' || 'p_index = ' || p_index);
1574: END IF;
1575: x_return_status := FND_API.G_RET_STS_SUCCESS;
1576:
1577: p_atp_supply_demand.Level.Trim(p_index);
1578: p_atp_supply_demand.Inventory_Item_Id.Trim(p_index);
1579: p_atp_supply_demand.Request_Item_Id.Trim(p_index);

Line 1693: x_return_status := FND_API.G_RET_STS_SUCCESS;

1689: msc_sch_wb.atp_debug('Get_Regions_Old: ' || 'p_session_id : ' || p_session_id);
1690: msc_sch_wb.atp_debug('Get_Regions_Old: ' || 'p_dblink : ' || p_dblink);
1691: END IF;
1692:
1693: x_return_status := FND_API.G_RET_STS_SUCCESS;
1694: IF p_calling_module <> 724 THEN
1695: BEGIN
1696: /********************* BUG 2085071 Fix ************************/
1697: /* Old Select statement -- Incorrect and hence commented out.

Line 2165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2161: IF PG_DEBUG in ('Y', 'C') THEN
2162: msc_sch_wb.atp_debug('Get_Regions_Old: ' || 'sqlcode : ' || sqlcode || ' : ' || sqlerrm);
2163: msc_sch_wb.atp_debug('Get_Regions_Old: ' || 'Error for Customer with customer_site_id : ' || p_customer_site_id);
2164: END IF;
2165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2166: return;
2167: END IF;
2168: END Get_Regions_Old;
2169:

Line 2220: x_return_status := FND_API.G_RET_STS_SUCCESS;

2216: msc_sch_wb.atp_debug('Get_Regions_Shipping: ' || 'p_session_id : ' || p_session_id);
2217: msc_sch_wb.atp_debug('Get_Regions_Shipping: ' || 'p_dblink : ' || p_dblink);
2218: END IF;
2219:
2220: x_return_status := FND_API.G_RET_STS_SUCCESS;
2221: -- Always use destination table if supplier site is passed
2222: -- IF p_calling_module <> 724 AND nvl(p_supplier_site_id,-1)=-1 THEN -- For supplier intransit LT project
2223: -- Bug 3497370 - Handle null calling_module
2224: IF nvl(p_calling_module,-99) <> 724 AND nvl(p_supplier_site_id,-1)=-1 THEN -- For supplier intransit LT project

Line 2658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2654: msc_sch_wb.atp_debug('Get_Regions_Shipping: ' || 'sqlcode : ' || sqlcode || ' : ' || sqlerrm);
2655: msc_sch_wb.atp_debug('sqlcode : ' || sqlcode || ' : ' || sqlerrm);
2656: msc_sch_wb.atp_debug('Get_Regions_Shipping: ' || 'Error for Customer with customer_site_id : ' || p_customer_site_id);
2657: END IF;
2658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2659:
2660: --bug 3425497: delete data from local table
2661: delete msc_regions_temp where session_id = p_session_id;
2662: return;

Line 2962: x_return_status := FND_API.G_RET_STS_SUCCESS;

2958: IF PG_DEBUG in ('Y', 'C') THEN
2959: msc_sch_wb.atp_debug('***** Begin New_Extend_Atp Procedure *****');
2960: END IF;
2961:
2962: x_return_status := FND_API.G_RET_STS_SUCCESS;
2963:
2964: if p_tot_size > 0 then
2965: totlength := p_tot_size;
2966: elsif p_tot_size = 0 then

Line 3835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3831: --4500382 ENDS
3832:
3833: EXCEPTION
3834: when others then
3835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3836: msc_sch_wb.atp_debug ('Exception in New extend');
3837: msc_sch_wb.atp_debug ('Sqlcode ' || sqlcode);
3838: msc_sch_wb.atp_debug ('Sqlerr ' || sqlerrm);
3839: END new_extend_atp;

Line 4388: x_return_status := FND_API.G_RET_STS_SUCCESS;

4384: IF PG_DEBUG in ('Y', 'C') THEN
4385: msc_sch_wb.atp_debug('Begin get_dblink_profile');
4386: END IF;
4387:
4388: x_return_status := FND_API.G_RET_STS_SUCCESS;
4389:
4390: --Bug3765793 adding trim functions to remove spaces from db_link
4391: SELECT instance_id, ltrim(rtrim(a2m_dblink))
4392: INTO x_instance_id, x_dblink

Line 4405: x_return_status := FND_API.G_RET_STS_ERROR;

4401: -- something wrong so we want to rollback;
4402: IF PG_DEBUG in ('Y', 'C') THEN
4403: msc_sch_wb.atp_debug('Error in mrp_ap_apps_instances : ' || sqlcode);
4404: END IF;
4405: x_return_status := FND_API.G_RET_STS_ERROR;
4406:
4407: End get_dblink_profile;
4408:
4409: /*--------------------------------------------------------------------------

Line 4431: x_return_status := FND_API.G_RET_STS_SUCCESS;

4427: l_sysdate DATE := TRUNC(sysdate);
4428:
4429: BEGIN
4430: -- initialize API returm status to success
4431: x_return_status := FND_API.G_RET_STS_SUCCESS;
4432:
4433: l_user_id := FND_GLOBAL.USER_ID;
4434: l_count := 10; --optional_fw
4435:

Line 4496: x_return_status := FND_API.G_RET_STS_ERROR;

4492: WHEN OTHERS THEN
4493: IF PG_DEBUG in ('Y', 'C') THEN
4494: msc_sch_wb.atp_debug(' Error in put_src_to_dstn_profiles '||substr(sqlerrm,1,100));
4495: END IF;
4496: x_return_status := FND_API.G_RET_STS_ERROR;
4497: END put_src_to_dstn_profiles;
4498: /*--------------------------------------------------------------------------
4499: | End Procedure put_src_to_dstn_profiles added for Multiple allocation enh -3940999
4500: +-------------------------------------------------------------------------*/

Line 4522: x_return_status := FND_API.G_RET_STS_SUCCESS;

4518: l_sql_stmt varchar2(2000);
4519:
4520: BEGIN
4521: -- initialize API returm status to success
4522: x_return_status := FND_API.G_RET_STS_SUCCESS;
4523:
4524: IF PG_DEBUG in ('Y', 'C') THEN
4525: msc_sch_wb.atp_debug('enter get_src_to_dstn_profiles');
4526: msc_sch_wb.atp_debug('get_src_to_dstn_profiles: ' || 'p_session_id := ' || p_session_id);

Line 4580: x_return_status := FND_API.G_RET_STS_ERROR;

4576: WHEN OTHERS THEN
4577: IF PG_DEBUG in ('Y', 'C') THEN
4578: msc_sch_wb.atp_debug(' Error in get_src_to_dstn_profiles '||substr(sqlerrm,1,100));
4579: END IF;
4580: x_return_status := FND_API.G_RET_STS_ERROR;
4581: END get_src_to_dstn_profiles;
4582: /*--------------------------------------------------------------------------
4583: | End Procedure get_src_to_dstn_profiles added for Multiple allocation enh -3940999
4584: +-------------------------------------------------------------------------*/