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 2583: l_ret_stat VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2579: ) RETURN VARCHAR2 IS
2580:
2581: v_make_buy_flag NUMBER;
2582: l_error_message VARCHAR2(100);
2583: l_ret_stat VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2584: l_reorder_qty NUMBER;
2585: l_move_ord_qty NUMBER;
2586:
2587: BEGIN

Line 2740: IF l_ret_stat <> FND_API.G_RET_STS_SUCCESS

2736: , x_ret_mesg => l_error_message
2737: , p_osfm_batch_id => p_osfm_batch_id /* Added for Bug 6807835 */
2738: );
2739:
2740: IF l_ret_stat <> FND_API.G_RET_STS_SUCCESS
2741: THEN
2742: IF G_TRACE_ON = 1 THEN
2743: print_debug('do_restock returned message: ' || l_error_message
2744: , 'get_reord_stat'

Line 2802: l_return_status := FND_API.G_RET_STS_SUCCESS;

2798: l_so_exception_set_id NUMBER;
2799:
2800: BEGIN
2801: SAVEPOINT sp_get_intransit_time;
2802: l_return_status := FND_API.G_RET_STS_SUCCESS;
2803: IF G_TRACE_ON = 1 THEN
2804: print_debug('Executing get_intransit_time with the following parameters:' || fnd_global.local_chr(10) ||
2805: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
2806: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||

Line 2853: RAISE fnd_api.g_exc_error;

2849: print_debug('MRP_SOURCING_API_PK.mrp_sourcing failed with error '|| l_msg_data
2850: , l_proc_name
2851: , 9);
2852: END IF;
2853: RAISE fnd_api.g_exc_error;
2854: ELSE
2855: IF G_TRACE_ON = 1 THEN
2856: 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
2857: , l_proc_name

Line 2890: RAISE fnd_api.g_exc_error;

2886: print_debug('Exception: Organization '||l_src_org ||' is not defined'
2887: , l_proc_name
2888: , 9);
2889: END IF;
2890: RAISE fnd_api.g_exc_error;
2891: END;
2892:
2893: --
2894: -- Get the Location associated with the Source Subinventory.

Line 2910: RAISE fnd_api.g_exc_error;

2906: print_debug('Exception: Subinventory '|| l_src_subinv || ' does not exist in the Organization '|| l_src_org
2907: , l_proc_name
2908: , 9);
2909: END IF;
2910: RAISE fnd_api.g_exc_error;
2911: END;
2912: END IF;
2913:
2914: --

Line 2933: RAISE fnd_api.g_exc_error;

2929: print_debug('Exception: No Source Location Exists for the Organization '|| l_src_org
2930: , l_proc_name
2931: , 9);
2932: END IF;
2933: RAISE fnd_api.g_exc_error;
2934: END;
2935: END IF;
2936: IF G_TRACE_ON = 1 THEN
2937: print_debug('From Location Id is: ' || l_from_location_id

Line 2954: RAISE fnd_api.g_exc_error;

2950: print_debug('Exception: MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL is not defined'
2951: , l_proc_name
2952: , 9);
2953: END IF;
2954: RAISE fnd_api.g_exc_error;
2955: END;
2956: IF G_TRACE_ON = 1 THEN
2957: print_debug('Calling MSC_ATP_PROC.ATP_Shipping_Lead_Time with session Id:'||l_session_id
2958: , l_proc_name

Line 2970: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2966: ,x_ship_method => l_ship_method
2967: ,x_intransit_time => l_intransit_time
2968: ,x_return_status => l_return_status
2969: );
2970: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2971: IF G_TRACE_ON = 1 THEN
2972: print_debug('MSC_ATP_PROC.ATP_Shipping_Lead_Time failed with unexpected error returning message: ' || l_msg_data
2973: , l_proc_name
2974: , 9);

Line 2976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2972: print_debug('MSC_ATP_PROC.ATP_Shipping_Lead_Time failed with unexpected error returning message: ' || l_msg_data
2973: , l_proc_name
2974: , 9);
2975: END IF;
2976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2977: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2978: IF G_TRACE_ON = 1 THEN
2979: print_debug('MSC_ATP_PROC.ATP_Shipping_Lead_Time failed with expected error returning message: ' || l_msg_data
2980: , l_proc_name

Line 2977: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2973: , l_proc_name
2974: , 9);
2975: END IF;
2976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2977: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2978: IF G_TRACE_ON = 1 THEN
2979: print_debug('MSC_ATP_PROC.ATP_Shipping_Lead_Time failed with expected error returning message: ' || l_msg_data
2980: , l_proc_name
2981: , 9);

Line 2983: RAISE FND_API.G_EXC_ERROR;

2979: print_debug('MSC_ATP_PROC.ATP_Shipping_Lead_Time failed with expected error returning message: ' || l_msg_data
2980: , l_proc_name
2981: , 9);
2982: END IF;
2983: RAISE FND_API.G_EXC_ERROR;
2984: ELSE
2985: x_intransit_time := NVL(l_intransit_time,0) ;
2986: IF G_TRACE_ON = 1 THEN
2987: print_debug('MSC_ATP_PROC.ATP_Shipping_Lead_Time returned success with Intransit Time '|| l_intransit_time

Line 2993: WHEN fnd_api.g_exc_error THEN

2989: , 9);
2990: END IF;
2991: END IF;
2992: EXCEPTION
2993: WHEN fnd_api.g_exc_error THEN
2994: ROLLBACK TO sp_get_intransit_time;
2995: x_return_status := fnd_api.g_ret_sts_error;
2996: fnd_msg_pub.count_and_get
2997: ( p_count => x_msg_count,

Line 2995: x_return_status := fnd_api.g_ret_sts_error;

2991: END IF;
2992: EXCEPTION
2993: WHEN fnd_api.g_exc_error THEN
2994: ROLLBACK TO sp_get_intransit_time;
2995: x_return_status := fnd_api.g_ret_sts_error;
2996: fnd_msg_pub.count_and_get
2997: ( p_count => x_msg_count,
2998: p_data => x_msg_data
2999: );

Line 3001: WHEN fnd_api.g_exc_unexpected_error THEN

2997: ( p_count => x_msg_count,
2998: p_data => x_msg_data
2999: );
3000:
3001: WHEN fnd_api.g_exc_unexpected_error THEN
3002: ROLLBACK TO sp_get_intransit_time;
3003: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3004: fnd_msg_pub.count_and_get
3005: ( p_count => x_msg_count,

Line 3003: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2999: );
3000:
3001: WHEN fnd_api.g_exc_unexpected_error THEN
3002: ROLLBACK TO sp_get_intransit_time;
3003: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3004: fnd_msg_pub.count_and_get
3005: ( p_count => x_msg_count,
3006: p_data => x_msg_data
3007: );

Line 3011: x_return_status := fnd_api.g_ret_sts_unexp_error;

3007: );
3008:
3009: WHEN OTHERS THEN
3010: ROLLBACK TO sp_get_intransit_time;
3011: x_return_status := fnd_api.g_ret_sts_unexp_error;
3012: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)THEN
3013: fnd_msg_pub.add_exc_msg
3014: ( G_PKG_NAME
3015: ,l_proc_name

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

3204: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3205: l_x_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3206: l_x_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3207: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3208: l_commit VARCHAR2(1) := FND_API.G_TRUE;
3209: l_mo_line_num NUMBER;
3210: l_order_count NUMBER := 1; /* total number of lines */
3211: l_intransit_time NUMBER := 0;
3212: l_approval NUMBER;

Line 3225: x_ret_stat := FND_API.G_RET_STS_SUCCESS;

3221: l_secondary_qty NUMBER ;
3222: l_secondary_uom VARCHAR2(3) ;
3223: BEGIN
3224: SAVEPOINT sp_do_restock;
3225: x_ret_stat := FND_API.G_RET_STS_SUCCESS;
3226: x_ret_mesg := '';
3227:
3228: --
3229: -- Query debug settings, set global variables.

Line 3381: IF l_ret_stat = FND_API.G_RET_STS_ERROR THEN

3377: , p_item_id => p_item_id
3378: , p_sourcing_date => l_sourcing_date);
3379:
3380:
3381: IF l_ret_stat = FND_API.G_RET_STS_ERROR THEN
3382: IF G_TRACE_ON = 1 THEN
3383: print_debug('INV_Minmax_PVT.get_lead_time failed with unexpected error returning message: ' || l_msg_data
3384: , l_proc_name
3385: , 9);

Line 3388: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN

3384: , l_proc_name
3385: , 9);
3386: END IF;
3387: RAISE requisition_exc;
3388: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN
3389: IF G_TRACE_ON = 1 THEN
3390: print_debug('INV_Minmax_PVT.get_lead_time failed with expected error returning message: ' || l_msg_data
3391: , l_proc_name
3392: , 9);

Line 3436: x_ret_stat := fnd_api.g_ret_sts_error;

3432: , l_proc_name
3433: , 9);
3434: END IF;
3435: x_ret_mesg := 'Exception occured in BOM Calendar';
3436: x_ret_stat := fnd_api.g_ret_sts_error;
3437: RETURN;
3438: END;
3439:
3440: IF G_TRACE_ON = 1 THEN

Line 3504: IF l_ret_stat = FND_API.G_RET_STS_ERROR THEN

3500: , p_src_subinv => p_src_subinv
3501: , p_approval => l_approval
3502: , p_need_by_date => l_need_by_date
3503: );
3504: IF l_ret_stat = FND_API.G_RET_STS_ERROR THEN
3505: IF G_TRACE_ON = 1 THEN
3506: print_debug('INV_MMX_WRAPPER_PVT.get_move_order_info failed with unexpected error returning message: ' || l_msg_data
3507: , l_proc_name
3508: , 9);

Line 3510: RAISE fnd_api.g_exc_unexpected_error;

3506: print_debug('INV_MMX_WRAPPER_PVT.get_move_order_info failed with unexpected error returning message: ' || l_msg_data
3507: , l_proc_name
3508: , 9);
3509: END IF;
3510: RAISE fnd_api.g_exc_unexpected_error;
3511: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN
3512: IF G_TRACE_ON = 1 THEN
3513: print_debug('INV_MMX_WRAPPER_PVT.get_move_order_info failed with expected error returning message: ' || l_msg_data
3514: , l_proc_name

Line 3511: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN

3507: , l_proc_name
3508: , 9);
3509: END IF;
3510: RAISE fnd_api.g_exc_unexpected_error;
3511: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN
3512: IF G_TRACE_ON = 1 THEN
3513: print_debug('INV_MMX_WRAPPER_PVT.get_move_order_info failed with expected error returning message: ' || l_msg_data
3514: , l_proc_name
3515: , 9);

Line 3517: RAISE fnd_api.g_exc_error;

3513: print_debug('INV_MMX_WRAPPER_PVT.get_move_order_info failed with expected error returning message: ' || l_msg_data
3514: , l_proc_name
3515: , 9);
3516: END IF;
3517: RAISE fnd_api.g_exc_error;
3518: ELSE
3519: IF G_TRACE_ON = 1 THEN
3520: 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
3521: , l_proc_name

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

3580: l_trolin_tbl(l_order_count).to_subinventory_code := p_subinv;
3581: l_trolin_tbl(l_order_count).uom_code := p_uom;
3582: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
3583: l_trolin_tbl(l_order_count).reference_type_code := INV_Transfer_Order_PVT.G_REF_TYPE_MINMAX;-- kkoothan For Bug Fix:2756930
3584: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;
3585: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;
3586: /* ------INVCONV Change Added secondary qty and uom------ */
3587: l_trolin_tbl(l_order_count).secondary_quantity := l_secondary_qty;
3588: l_trolin_tbl(l_order_count).secondary_uom := l_secondary_uom;

Line 3598: p_init_msg_list => FND_API.G_TRUE,

3594: , 9);
3595: END IF;
3596: INV_Move_Order_PUB.Create_Move_Order_Lines
3597: ( p_api_version_number => 1.0 ,
3598: p_init_msg_list => FND_API.G_TRUE,
3599: p_commit => l_commit,
3600: x_return_status => l_ret_stat,
3601: x_msg_count => l_msg_count,
3602: x_msg_data => l_msg_data,

Line 3609: IF l_ret_stat = FND_API.G_RET_STS_ERROR THEN

3605: x_trolin_tbl => l_x_trolin_tbl,
3606: x_trolin_val_tbl => l_x_trolin_val_tbl
3607: );
3608:
3609: IF l_ret_stat = FND_API.G_RET_STS_ERROR THEN
3610: IF G_TRACE_ON = 1 THEN
3611: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines failed with expected error returning message: ' || l_msg_data|| l_msg_count
3612: , l_proc_name
3613: , 9);

Line 3625: RAISE fnd_api.g_exc_unexpected_error;

3621: , 9);
3622: fnd_msg_pub.delete_msg(i);
3623: END LOOP;
3624: END IF;
3625: RAISE fnd_api.g_exc_unexpected_error;
3626: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN
3627: IF G_TRACE_ON = 1 THEN
3628: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines failed with unexpected error returning message: ' || l_msg_data
3629: , l_proc_name

Line 3626: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN

3622: fnd_msg_pub.delete_msg(i);
3623: END LOOP;
3624: END IF;
3625: RAISE fnd_api.g_exc_unexpected_error;
3626: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN
3627: IF G_TRACE_ON = 1 THEN
3628: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines failed with unexpected error returning message: ' || l_msg_data
3629: , l_proc_name
3630: , 9);

Line 3632: RAISE fnd_api.g_exc_error;

3628: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines failed with unexpected error returning message: ' || l_msg_data
3629: , l_proc_name
3630: , 9);
3631: END IF;
3632: RAISE fnd_api.g_exc_error;
3633: ELSE
3634: IF G_TRACE_ON = 1 THEN
3635: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines returned success'
3636: , l_proc_name

Line 3763: WHEN fnd_api.g_exc_error THEN

3759: x_ret_stat := l_ret_stat;
3760: END IF;
3761:
3762: EXCEPTION
3763: WHEN fnd_api.g_exc_error THEN
3764: ROLLBACK TO sp_do_restock;
3765: x_ret_stat := fnd_api.g_ret_sts_error;
3766: fnd_msg_pub.count_and_get
3767: ( p_count =>l_msg_count ,

Line 3765: x_ret_stat := fnd_api.g_ret_sts_error;

3761:
3762: EXCEPTION
3763: WHEN fnd_api.g_exc_error THEN
3764: ROLLBACK TO sp_do_restock;
3765: x_ret_stat := fnd_api.g_ret_sts_error;
3766: fnd_msg_pub.count_and_get
3767: ( p_count =>l_msg_count ,
3768: p_data => x_ret_mesg
3769: );

Line 3770: WHEN fnd_api.g_exc_unexpected_error THEN

3766: fnd_msg_pub.count_and_get
3767: ( p_count =>l_msg_count ,
3768: p_data => x_ret_mesg
3769: );
3770: WHEN fnd_api.g_exc_unexpected_error THEN
3771: ROLLBACK TO sp_do_restock;
3772: x_ret_stat := fnd_api.g_ret_sts_unexp_error;
3773: fnd_msg_pub.count_and_get
3774: ( p_count =>l_msg_count ,

Line 3772: x_ret_stat := fnd_api.g_ret_sts_unexp_error;

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

Line 3786: x_ret_stat := FND_API.G_RET_STS_ERROR;

3782: FROM mfg_lookups
3783: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
3784: AND lookup_code = 1;
3785:
3786: x_ret_stat := FND_API.G_RET_STS_ERROR;
3787:
3788: WHEN move_ord_exc THEN
3789: ROLLBACK TO sp_do_restock;
3790: SELECT meaning

Line 3796: x_ret_stat := FND_API.G_RET_STS_ERROR;

3792: FROM mfg_lookups
3793: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
3794: AND lookup_code = 5;
3795:
3796: x_ret_stat := FND_API.G_RET_STS_ERROR;
3797:
3798: WHEN others THEN
3799: IF G_TRACE_ON = 1 THEN
3800: print_debug(sqlcode || ', ' || sqlerrm, l_proc_name, 1);

Line 4088: x_ret_stat := FND_API.G_RET_STS_SUCCESS;

4084: p_budget_acct,
4085: 'P',
4086: p_po_org_id);
4087:
4088: x_ret_stat := FND_API.G_RET_STS_SUCCESS;
4089: x_ret_mesg := '';
4090:
4091: EXCEPTION
4092: WHEN OTHERS THEN

Line 4103: x_ret_stat := FND_API.G_RET_STS_ERROR;

4099: FROM mfg_lookups
4100: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
4101: AND lookup_code = 1;
4102:
4103: x_ret_stat := FND_API.G_RET_STS_ERROR;
4104: END re_po;
4105:
4106:
4107:

Line 4378: x_ret_stat := FND_API.G_RET_STS_SUCCESS;

4374: p_qty,
4375: DECODE(p_approval,1,3,1));
4376: END IF;
4377:
4378: x_ret_stat := FND_API.G_RET_STS_SUCCESS;
4379: x_ret_mesg := '';
4380:
4381: EXCEPTION
4382: WHEN OTHERS THEN

Line 4393: x_ret_stat := FND_API.G_RET_STS_ERROR;

4389: FROM mfg_lookups
4390: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
4391: AND lookup_code = 2;
4392:
4393: x_ret_stat := FND_API.G_RET_STS_ERROR;
4394: END re_wip;
4395: --
4396: /* nsinghi MIN-MAX INVCONV start */
4397:

Line 4455: ,p_init_msg_list => FND_API.G_TRUE

4451:
4452: gmp_batch_wrapper_pkg.create_batch(
4453: p_api_version => 2.0
4454: ,p_validation_level => 100
4455: ,p_init_msg_list => FND_API.G_TRUE
4456: ,p_commit => FND_API.G_TRUE
4457: ,x_message_count => x_message_count
4458: ,x_message_list => x_message_list
4459: ,x_return_status => return_status

Line 4456: ,p_commit => FND_API.G_TRUE

4452: gmp_batch_wrapper_pkg.create_batch(
4453: p_api_version => 2.0
4454: ,p_validation_level => 100
4455: ,p_init_msg_list => FND_API.G_TRUE
4456: ,p_commit => FND_API.G_TRUE
4457: ,x_message_count => x_message_count
4458: ,x_message_list => x_message_list
4459: ,x_return_status => return_status
4460: ,p_org_code => NULL

Line 4472: ,p_ignore_qty_below_cap => FND_API.G_TRUE

4468: ,p_recipe_version => NULL
4469: ,p_product_no => NULL
4470: ,p_item_revision => NULL
4471: ,p_product_id => p_item_id
4472: ,p_ignore_qty_below_cap => FND_API.G_TRUE
4473: ,p_use_workday_cal => NULL
4474: ,p_contiguity_override => NULL
4475: ,p_use_least_cost_validity_rule => FND_API.G_FALSE
4476: ,x_exception_material_tbl => x_exception_material_tbl

Line 4475: ,p_use_least_cost_validity_rule => FND_API.G_FALSE

4471: ,p_product_id => p_item_id
4472: ,p_ignore_qty_below_cap => FND_API.G_TRUE
4473: ,p_use_workday_cal => NULL
4474: ,p_contiguity_override => NULL
4475: ,p_use_least_cost_validity_rule => FND_API.G_FALSE
4476: ,x_exception_material_tbl => x_exception_material_tbl
4477: );
4478:
4479: -- IF (return_status <> 'S') THEN -- nsinghi bug 5931402

Line 4499: x_ret_stat := FND_API.G_RET_STS_SUCCESS;

4495: -- END IF; /* For l_eff_id <> NULL */
4496:
4497: END IF; /* For p_execution_enabled <> 'Y' AND p_recipe_enabled <> 'Y' */
4498:
4499: x_ret_stat := FND_API.G_RET_STS_SUCCESS;
4500: x_ret_mesg := '';
4501:
4502: EXCEPTION
4503: WHEN OTHERS THEN

Line 4514: x_ret_stat := FND_API.G_RET_STS_ERROR;

4510: FROM mfg_lookups
4511: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
4512: AND lookup_code = 2;
4513:
4514: x_ret_stat := FND_API.G_RET_STS_ERROR;
4515: END re_batch;
4516:
4517:
4518: --This procedure is to copmpute the loaded quantities for a WMS enabled org.