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.INV_MINMAX_PVT dependencies on FND_API

Line 2593: l_ret_stat VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2589: ) RETURN VARCHAR2 IS
2590:
2591: v_make_buy_flag NUMBER;
2592: l_error_message VARCHAR2(100);
2593: l_ret_stat VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2594: l_reorder_qty NUMBER;
2595: l_move_ord_qty NUMBER;
2596:
2597: BEGIN

Line 2750: IF l_ret_stat <> FND_API.G_RET_STS_SUCCESS

2746: , x_ret_mesg => l_error_message
2747: , p_osfm_batch_id => p_osfm_batch_id /* Added for Bug 6807835 */
2748: );
2749:
2750: IF l_ret_stat <> FND_API.G_RET_STS_SUCCESS
2751: THEN
2752: IF G_TRACE_ON = 1 THEN
2753: print_debug('do_restock returned message: ' || l_error_message
2754: , 'get_reord_stat'

Line 2812: l_return_status := FND_API.G_RET_STS_SUCCESS;

2808: l_so_exception_set_id NUMBER;
2809:
2810: BEGIN
2811: SAVEPOINT sp_get_intransit_time;
2812: l_return_status := FND_API.G_RET_STS_SUCCESS;
2813: IF G_TRACE_ON = 1 THEN
2814: print_debug('Executing get_intransit_time with the following parameters:' || fnd_global.local_chr(10) ||
2815: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
2816: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||

Line 2863: RAISE fnd_api.g_exc_error;

2859: print_debug('MRP_SOURCING_API_PK.mrp_sourcing failed with error '|| l_msg_data
2860: , l_proc_name
2861: , 9);
2862: END IF;
2863: RAISE fnd_api.g_exc_error;
2864: ELSE
2865: IF G_TRACE_ON = 1 THEN
2866: print_debug('MRP_SOURCING_API_PK.mrp_sourcing returned success with Source Sub and Source Org '|| fnd_global.local_chr(10) || l_src_subinv || ' and '|| l_src_org
2867: , l_proc_name

Line 2900: RAISE fnd_api.g_exc_error;

2896: print_debug('Exception: Organization '||l_src_org ||' is not defined'
2897: , l_proc_name
2898: , 9);
2899: END IF;
2900: RAISE fnd_api.g_exc_error;
2901: END;
2902:
2903: --
2904: -- Get the Location associated with the Source Subinventory.

Line 2920: RAISE fnd_api.g_exc_error;

2916: print_debug('Exception: Subinventory '|| l_src_subinv || ' does not exist in the Organization '|| l_src_org
2917: , l_proc_name
2918: , 9);
2919: END IF;
2920: RAISE fnd_api.g_exc_error;
2921: END;
2922: END IF;
2923:
2924: --

Line 2943: RAISE fnd_api.g_exc_error;

2939: print_debug('Exception: No Source Location Exists for the Organization '|| l_src_org
2940: , l_proc_name
2941: , 9);
2942: END IF;
2943: RAISE fnd_api.g_exc_error;
2944: END;
2945: END IF;
2946: IF G_TRACE_ON = 1 THEN
2947: print_debug('From Location Id is: ' || l_from_location_id

Line 2964: RAISE fnd_api.g_exc_error;

2960: print_debug('Exception: MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL is not defined'
2961: , l_proc_name
2962: , 9);
2963: END IF;
2964: RAISE fnd_api.g_exc_error;
2965: END;
2966: IF G_TRACE_ON = 1 THEN
2967: print_debug('Calling MSC_ATP_PROC.ATP_Shipping_Lead_Time with session Id:'||l_session_id
2968: , l_proc_name

Line 2980: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2976: ,x_ship_method => l_ship_method
2977: ,x_intransit_time => l_intransit_time
2978: ,x_return_status => l_return_status
2979: );
2980: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2981: IF G_TRACE_ON = 1 THEN
2982: print_debug('MSC_ATP_PROC.ATP_Shipping_Lead_Time failed with unexpected error returning message: ' || l_msg_data
2983: , l_proc_name
2984: , 9);

Line 2986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2982: print_debug('MSC_ATP_PROC.ATP_Shipping_Lead_Time failed with unexpected error returning message: ' || l_msg_data
2983: , l_proc_name
2984: , 9);
2985: END IF;
2986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2987: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2988: IF G_TRACE_ON = 1 THEN
2989: print_debug('MSC_ATP_PROC.ATP_Shipping_Lead_Time failed with expected error returning message: ' || l_msg_data
2990: , l_proc_name

Line 2987: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2983: , l_proc_name
2984: , 9);
2985: END IF;
2986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2987: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2988: IF G_TRACE_ON = 1 THEN
2989: print_debug('MSC_ATP_PROC.ATP_Shipping_Lead_Time failed with expected error returning message: ' || l_msg_data
2990: , l_proc_name
2991: , 9);

Line 2993: RAISE FND_API.G_EXC_ERROR;

2989: print_debug('MSC_ATP_PROC.ATP_Shipping_Lead_Time failed with expected error returning message: ' || l_msg_data
2990: , l_proc_name
2991: , 9);
2992: END IF;
2993: RAISE FND_API.G_EXC_ERROR;
2994: ELSE
2995: x_intransit_time := NVL(l_intransit_time,0) ;
2996: IF G_TRACE_ON = 1 THEN
2997: print_debug('MSC_ATP_PROC.ATP_Shipping_Lead_Time returned success with Intransit Time '|| l_intransit_time

Line 3003: WHEN fnd_api.g_exc_error THEN

2999: , 9);
3000: END IF;
3001: END IF;
3002: EXCEPTION
3003: WHEN fnd_api.g_exc_error THEN
3004: ROLLBACK TO sp_get_intransit_time;
3005: x_return_status := fnd_api.g_ret_sts_error;
3006: fnd_msg_pub.count_and_get
3007: ( p_count => x_msg_count,

Line 3005: x_return_status := fnd_api.g_ret_sts_error;

3001: END IF;
3002: EXCEPTION
3003: WHEN fnd_api.g_exc_error THEN
3004: ROLLBACK TO sp_get_intransit_time;
3005: x_return_status := fnd_api.g_ret_sts_error;
3006: fnd_msg_pub.count_and_get
3007: ( p_count => x_msg_count,
3008: p_data => x_msg_data
3009: );

Line 3011: WHEN fnd_api.g_exc_unexpected_error THEN

3007: ( p_count => x_msg_count,
3008: p_data => x_msg_data
3009: );
3010:
3011: WHEN fnd_api.g_exc_unexpected_error THEN
3012: ROLLBACK TO sp_get_intransit_time;
3013: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3014: fnd_msg_pub.count_and_get
3015: ( p_count => x_msg_count,

Line 3013: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3009: );
3010:
3011: WHEN fnd_api.g_exc_unexpected_error THEN
3012: ROLLBACK TO sp_get_intransit_time;
3013: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3014: fnd_msg_pub.count_and_get
3015: ( p_count => x_msg_count,
3016: p_data => x_msg_data
3017: );

Line 3021: x_return_status := fnd_api.g_ret_sts_unexp_error;

3017: );
3018:
3019: WHEN OTHERS THEN
3020: ROLLBACK TO sp_get_intransit_time;
3021: x_return_status := fnd_api.g_ret_sts_unexp_error;
3022: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)THEN
3023: fnd_msg_pub.add_exc_msg
3024: ( G_PKG_NAME
3025: ,l_proc_name

Line 3218: l_commit VARCHAR2(1) := FND_API.G_TRUE;

3214: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3215: l_x_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3216: l_x_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3217: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3218: l_commit VARCHAR2(1) := FND_API.G_TRUE;
3219: l_mo_line_num NUMBER;
3220: l_order_count NUMBER := 1; /* total number of lines */
3221: l_intransit_time NUMBER := 0;
3222: l_approval NUMBER;

Line 3235: x_ret_stat := FND_API.G_RET_STS_SUCCESS;

3231: l_secondary_qty NUMBER ;
3232: l_secondary_uom VARCHAR2(3) ;
3233: BEGIN
3234: SAVEPOINT sp_do_restock;
3235: x_ret_stat := FND_API.G_RET_STS_SUCCESS;
3236: x_ret_mesg := '';
3237:
3238: --
3239: -- Query debug settings, set global variables.

Line 3391: IF l_ret_stat = FND_API.G_RET_STS_ERROR THEN

3387: , p_item_id => p_item_id
3388: , p_sourcing_date => l_sourcing_date);
3389:
3390:
3391: IF l_ret_stat = FND_API.G_RET_STS_ERROR THEN
3392: IF G_TRACE_ON = 1 THEN
3393: print_debug('INV_Minmax_PVT.get_lead_time failed with unexpected error returning message: ' || l_msg_data
3394: , l_proc_name
3395: , 9);

Line 3398: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN

3394: , l_proc_name
3395: , 9);
3396: END IF;
3397: RAISE requisition_exc;
3398: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN
3399: IF G_TRACE_ON = 1 THEN
3400: print_debug('INV_Minmax_PVT.get_lead_time failed with expected error returning message: ' || l_msg_data
3401: , l_proc_name
3402: , 9);

Line 3446: x_ret_stat := fnd_api.g_ret_sts_error;

3442: , l_proc_name
3443: , 9);
3444: END IF;
3445: x_ret_mesg := 'Exception occured in BOM Calendar';
3446: x_ret_stat := fnd_api.g_ret_sts_error;
3447: RETURN;
3448: END;
3449:
3450: IF G_TRACE_ON = 1 THEN

Line 3514: IF l_ret_stat = FND_API.G_RET_STS_ERROR THEN

3510: , p_src_subinv => p_src_subinv
3511: , p_approval => l_approval
3512: , p_need_by_date => l_need_by_date
3513: );
3514: IF l_ret_stat = FND_API.G_RET_STS_ERROR THEN
3515: IF G_TRACE_ON = 1 THEN
3516: print_debug('INV_MMX_WRAPPER_PVT.get_move_order_info failed with unexpected error returning message: ' || l_msg_data
3517: , l_proc_name
3518: , 9);

Line 3520: RAISE fnd_api.g_exc_unexpected_error;

3516: print_debug('INV_MMX_WRAPPER_PVT.get_move_order_info failed with unexpected error returning message: ' || l_msg_data
3517: , l_proc_name
3518: , 9);
3519: END IF;
3520: RAISE fnd_api.g_exc_unexpected_error;
3521: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN
3522: IF G_TRACE_ON = 1 THEN
3523: print_debug('INV_MMX_WRAPPER_PVT.get_move_order_info failed with expected error returning message: ' || l_msg_data
3524: , l_proc_name

Line 3521: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN

3517: , l_proc_name
3518: , 9);
3519: END IF;
3520: RAISE fnd_api.g_exc_unexpected_error;
3521: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN
3522: IF G_TRACE_ON = 1 THEN
3523: print_debug('INV_MMX_WRAPPER_PVT.get_move_order_info failed with expected error returning message: ' || l_msg_data
3524: , l_proc_name
3525: , 9);

Line 3527: RAISE fnd_api.g_exc_error;

3523: print_debug('INV_MMX_WRAPPER_PVT.get_move_order_info failed with expected error returning message: ' || l_msg_data
3524: , l_proc_name
3525: , 9);
3526: END IF;
3527: RAISE fnd_api.g_exc_error;
3528: ELSE
3529: IF G_TRACE_ON = 1 THEN
3530: print_debug('INV_MMX_WRAPPER_PVT.get_move_order_info returned success with MO Header Id and MO Line Number '|| fnd_global.local_chr(10) || l_mo_header_id ||' and '|| l_mo_line_num
3531: , l_proc_name

Line 3591: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;

3587: l_trolin_tbl(l_order_count).to_subinventory_code := p_subinv;
3588: l_trolin_tbl(l_order_count).uom_code := p_uom;
3589: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
3590: l_trolin_tbl(l_order_count).reference_type_code := INV_Transfer_Order_PVT.G_REF_TYPE_MINMAX;-- kkoothan For Bug Fix:2756930
3591: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;
3592: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;
3593: /* ------INVCONV Change Added secondary qty and uom------ */
3594: l_trolin_tbl(l_order_count).secondary_quantity := l_secondary_qty;
3595: l_trolin_tbl(l_order_count).secondary_uom := l_secondary_uom;

Line 3605: p_init_msg_list => FND_API.G_TRUE,

3601: , 9);
3602: END IF;
3603: INV_Move_Order_PUB.Create_Move_Order_Lines
3604: ( p_api_version_number => 1.0 ,
3605: p_init_msg_list => FND_API.G_TRUE,
3606: p_commit => l_commit,
3607: x_return_status => l_ret_stat,
3608: x_msg_count => l_msg_count,
3609: x_msg_data => l_msg_data,

Line 3616: IF l_ret_stat = FND_API.G_RET_STS_ERROR THEN

3612: x_trolin_tbl => l_x_trolin_tbl,
3613: x_trolin_val_tbl => l_x_trolin_val_tbl
3614: );
3615:
3616: IF l_ret_stat = FND_API.G_RET_STS_ERROR THEN
3617: IF G_TRACE_ON = 1 THEN
3618: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines failed with expected error returning message: ' || l_msg_data|| l_msg_count
3619: , l_proc_name
3620: , 9);

Line 3632: RAISE fnd_api.g_exc_unexpected_error;

3628: , 9);
3629: fnd_msg_pub.delete_msg(i);
3630: END LOOP;
3631: END IF;
3632: RAISE fnd_api.g_exc_unexpected_error;
3633: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN
3634: IF G_TRACE_ON = 1 THEN
3635: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines failed with unexpected error returning message: ' || l_msg_data
3636: , l_proc_name

Line 3633: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN

3629: fnd_msg_pub.delete_msg(i);
3630: END LOOP;
3631: END IF;
3632: RAISE fnd_api.g_exc_unexpected_error;
3633: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN
3634: IF G_TRACE_ON = 1 THEN
3635: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines failed with unexpected error returning message: ' || l_msg_data
3636: , l_proc_name
3637: , 9);

Line 3639: RAISE fnd_api.g_exc_error;

3635: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines failed with unexpected error returning message: ' || l_msg_data
3636: , l_proc_name
3637: , 9);
3638: END IF;
3639: RAISE fnd_api.g_exc_error;
3640: ELSE
3641: IF G_TRACE_ON = 1 THEN
3642: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines returned success'
3643: , l_proc_name

Line 3770: WHEN fnd_api.g_exc_error THEN

3766: x_ret_stat := l_ret_stat;
3767: END IF;
3768:
3769: EXCEPTION
3770: WHEN fnd_api.g_exc_error THEN
3771: ROLLBACK TO sp_do_restock;
3772: x_ret_stat := fnd_api.g_ret_sts_error;
3773: fnd_msg_pub.count_and_get
3774: ( p_count =>l_msg_count ,

Line 3772: x_ret_stat := fnd_api.g_ret_sts_error;

3768:
3769: EXCEPTION
3770: WHEN fnd_api.g_exc_error THEN
3771: ROLLBACK TO sp_do_restock;
3772: x_ret_stat := fnd_api.g_ret_sts_error;
3773: fnd_msg_pub.count_and_get
3774: ( p_count =>l_msg_count ,
3775: p_data => x_ret_mesg
3776: );

Line 3777: WHEN fnd_api.g_exc_unexpected_error THEN

3773: fnd_msg_pub.count_and_get
3774: ( p_count =>l_msg_count ,
3775: p_data => x_ret_mesg
3776: );
3777: WHEN fnd_api.g_exc_unexpected_error THEN
3778: ROLLBACK TO sp_do_restock;
3779: x_ret_stat := fnd_api.g_ret_sts_unexp_error;
3780: fnd_msg_pub.count_and_get
3781: ( p_count =>l_msg_count ,

Line 3779: x_ret_stat := fnd_api.g_ret_sts_unexp_error;

3775: p_data => x_ret_mesg
3776: );
3777: WHEN fnd_api.g_exc_unexpected_error THEN
3778: ROLLBACK TO sp_do_restock;
3779: x_ret_stat := fnd_api.g_ret_sts_unexp_error;
3780: fnd_msg_pub.count_and_get
3781: ( p_count =>l_msg_count ,
3782: p_data => x_ret_mesg
3783: );

Line 3793: x_ret_stat := FND_API.G_RET_STS_ERROR;

3789: FROM mfg_lookups
3790: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
3791: AND lookup_code = 1;
3792:
3793: x_ret_stat := FND_API.G_RET_STS_ERROR;
3794:
3795: WHEN move_ord_exc THEN
3796: ROLLBACK TO sp_do_restock;
3797: SELECT meaning

Line 3803: x_ret_stat := FND_API.G_RET_STS_ERROR;

3799: FROM mfg_lookups
3800: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
3801: AND lookup_code = 5;
3802:
3803: x_ret_stat := FND_API.G_RET_STS_ERROR;
3804:
3805: WHEN others THEN
3806: IF G_TRACE_ON = 1 THEN
3807: print_debug(sqlcode || ', ' || sqlerrm, l_proc_name, 1);

Line 4095: x_ret_stat := FND_API.G_RET_STS_SUCCESS;

4091: p_budget_acct,
4092: 'P',
4093: p_po_org_id);
4094:
4095: x_ret_stat := FND_API.G_RET_STS_SUCCESS;
4096: x_ret_mesg := '';
4097:
4098: EXCEPTION
4099: WHEN OTHERS THEN

Line 4110: x_ret_stat := FND_API.G_RET_STS_ERROR;

4106: FROM mfg_lookups
4107: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
4108: AND lookup_code = 1;
4109:
4110: x_ret_stat := FND_API.G_RET_STS_ERROR;
4111: END re_po;
4112:
4113:
4114:

Line 4398: x_ret_stat := FND_API.G_RET_STS_SUCCESS;

4394: p_qty,
4395: DECODE(p_approval,1,3,1));
4396: END IF;
4397:
4398: x_ret_stat := FND_API.G_RET_STS_SUCCESS;
4399: x_ret_mesg := '';
4400:
4401: EXCEPTION
4402: WHEN OTHERS THEN

Line 4413: x_ret_stat := FND_API.G_RET_STS_ERROR;

4409: FROM mfg_lookups
4410: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
4411: AND lookup_code = 2;
4412:
4413: x_ret_stat := FND_API.G_RET_STS_ERROR;
4414: END re_wip;
4415: --
4416: /* nsinghi MIN-MAX INVCONV start */
4417:

Line 4475: ,p_init_msg_list => FND_API.G_TRUE

4471:
4472: gmp_batch_wrapper_pkg.create_batch(
4473: p_api_version => 2.0
4474: ,p_validation_level => 100
4475: ,p_init_msg_list => FND_API.G_TRUE
4476: ,p_commit => FND_API.G_TRUE
4477: ,x_message_count => x_message_count
4478: ,x_message_list => x_message_list
4479: ,x_return_status => return_status

Line 4476: ,p_commit => FND_API.G_TRUE

4472: gmp_batch_wrapper_pkg.create_batch(
4473: p_api_version => 2.0
4474: ,p_validation_level => 100
4475: ,p_init_msg_list => FND_API.G_TRUE
4476: ,p_commit => FND_API.G_TRUE
4477: ,x_message_count => x_message_count
4478: ,x_message_list => x_message_list
4479: ,x_return_status => return_status
4480: ,p_org_code => NULL

Line 4492: ,p_ignore_qty_below_cap => FND_API.G_TRUE

4488: ,p_recipe_version => NULL
4489: ,p_product_no => NULL
4490: ,p_item_revision => NULL
4491: ,p_product_id => p_item_id
4492: ,p_ignore_qty_below_cap => FND_API.G_TRUE
4493: ,p_use_workday_cal => NULL
4494: ,p_contiguity_override => NULL
4495: ,p_use_least_cost_validity_rule => FND_API.G_FALSE
4496: ,x_exception_material_tbl => x_exception_material_tbl

Line 4495: ,p_use_least_cost_validity_rule => FND_API.G_FALSE

4491: ,p_product_id => p_item_id
4492: ,p_ignore_qty_below_cap => FND_API.G_TRUE
4493: ,p_use_workday_cal => NULL
4494: ,p_contiguity_override => NULL
4495: ,p_use_least_cost_validity_rule => FND_API.G_FALSE
4496: ,x_exception_material_tbl => x_exception_material_tbl
4497: );
4498:
4499: -- IF (return_status <> 'S') THEN -- nsinghi bug 5931402

Line 4519: x_ret_stat := FND_API.G_RET_STS_SUCCESS;

4515: -- END IF; /* For l_eff_id <> NULL */
4516:
4517: END IF; /* For p_execution_enabled <> 'Y' AND p_recipe_enabled <> 'Y' */
4518:
4519: x_ret_stat := FND_API.G_RET_STS_SUCCESS;
4520: x_ret_mesg := '';
4521:
4522: EXCEPTION
4523: WHEN OTHERS THEN

Line 4534: x_ret_stat := FND_API.G_RET_STS_ERROR;

4530: FROM mfg_lookups
4531: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
4532: AND lookup_code = 2;
4533:
4534: x_ret_stat := FND_API.G_RET_STS_ERROR;
4535: END re_batch;
4536:
4537:
4538: --This procedure is to copmpute the loaded quantities for a WMS enabled org.