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.GMI_RESERVATION_UTIL dependencies on OP_ALOT_PRM

Line 2319: l_op_alot_prm_rec op_alot_prm%ROWTYPE;

2315: l_deleted_qty1 NUMBER(19,9);
2316: l_deleted_qty2 NUMBER(19,9);
2317:
2318: /* For the Allocation rules. */
2319: l_op_alot_prm_rec op_alot_prm%ROWTYPE;
2320: l_inventory_item_id NUMBER;
2321: l_ic_item_mst_rec GMI_Reservation_Util.ic_item_mst_rec;
2322: l_cust_no op_cust_mst.cust_no%TYPE;
2323: l_co_code op_cust_mst.co_code%TYPE; --B1731567 co_code of cust

Line 2507: x_op_alot_prm => l_op_alot_prm_rec,

2503: GMI_ALLOCATION_RULES_PVT.GET_ALLOCATION_PARMS
2504: ( p_co_code => l_co_code, --B1731567
2505: p_cust_no => l_cust_no,
2506: p_alloc_class => l_ic_item_mst_rec.alloc_class,
2507: x_op_alot_prm => l_op_alot_prm_rec,
2508: x_return_status => x_return_status,
2509: x_msg_count => x_msg_count,
2510: x_msg_data => x_msg_data
2511: );

Line 2515: IF ((l_op_alot_prm_rec.alloc_class = ' ') OR

2511: );
2512:
2513: /* if no allocation rules found, then Raise Exception and return */
2514: /* ------------------------------------------------------------------------ */
2515: IF ((l_op_alot_prm_rec.alloc_class = ' ') OR
2516: (l_op_alot_prm_rec.delete_mark = 1))
2517: THEN
2518: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation - Error missing allocation parms',1);
2519: FND_MESSAGE.SET_NAME('GML','GML_NO_ALLOCATION_PARMS');

Line 2516: (l_op_alot_prm_rec.delete_mark = 1))

2512:
2513: /* if no allocation rules found, then Raise Exception and return */
2514: /* ------------------------------------------------------------------------ */
2515: IF ((l_op_alot_prm_rec.alloc_class = ' ') OR
2516: (l_op_alot_prm_rec.delete_mark = 1))
2517: THEN
2518: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation - Error missing allocation parms',1);
2519: FND_MESSAGE.SET_NAME('GML','GML_NO_ALLOCATION_PARMS');
2520: FND_MESSAGE.SET_TOKEN('ALLOC_CLASS', l_ic_item_mst_rec.alloc_class);

Line 2528: IF (l_op_alot_prm_rec.alloc_horizon > 0) AND

2524:
2525: /* It is not possible to allocate (create/update) if the period between */
2526: /* trans_date and sysdate is greater than the Horizon period. */
2527: /* --------------------------------------------------------------------- */
2528: IF (l_op_alot_prm_rec.alloc_horizon > 0) AND
2529: (p_ic_tran_rec.trans_date > (SYSDATE + l_op_alot_prm_rec.alloc_horizon))
2530: THEN
2531: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation horizon is out - using '|| l_op_alot_prm_rec.alloc_horizon||' days.');
2532: GMI_Reservation_Util.PrintLn('(opm_dbg) do allocate from sysdate > ' || (p_ic_tran_rec.trans_date + l_op_alot_prm_rec.alloc_horizon));

Line 2529: (p_ic_tran_rec.trans_date > (SYSDATE + l_op_alot_prm_rec.alloc_horizon))

2525: /* It is not possible to allocate (create/update) if the period between */
2526: /* trans_date and sysdate is greater than the Horizon period. */
2527: /* --------------------------------------------------------------------- */
2528: IF (l_op_alot_prm_rec.alloc_horizon > 0) AND
2529: (p_ic_tran_rec.trans_date > (SYSDATE + l_op_alot_prm_rec.alloc_horizon))
2530: THEN
2531: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation horizon is out - using '|| l_op_alot_prm_rec.alloc_horizon||' days.');
2532: GMI_Reservation_Util.PrintLn('(opm_dbg) do allocate from sysdate > ' || (p_ic_tran_rec.trans_date + l_op_alot_prm_rec.alloc_horizon));
2533: GMI_Reservation_Util.PrintLn('(opm_dbg) or choose trans_date < '|| (SYSDATE + l_op_alot_prm_rec.alloc_horizon));

Line 2531: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation horizon is out - using '|| l_op_alot_prm_rec.alloc_horizon||' days.');

2527: /* --------------------------------------------------------------------- */
2528: IF (l_op_alot_prm_rec.alloc_horizon > 0) AND
2529: (p_ic_tran_rec.trans_date > (SYSDATE + l_op_alot_prm_rec.alloc_horizon))
2530: THEN
2531: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation horizon is out - using '|| l_op_alot_prm_rec.alloc_horizon||' days.');
2532: GMI_Reservation_Util.PrintLn('(opm_dbg) do allocate from sysdate > ' || (p_ic_tran_rec.trans_date + l_op_alot_prm_rec.alloc_horizon));
2533: GMI_Reservation_Util.PrintLn('(opm_dbg) or choose trans_date < '|| (SYSDATE + l_op_alot_prm_rec.alloc_horizon));
2534: FND_MESSAGE.SET_NAME('GML','SO_E_ALLOC_HORIZON_ERR');
2535: FND_MSG_PUB.Add;

Line 2532: GMI_Reservation_Util.PrintLn('(opm_dbg) do allocate from sysdate > ' || (p_ic_tran_rec.trans_date + l_op_alot_prm_rec.alloc_horizon));

2528: IF (l_op_alot_prm_rec.alloc_horizon > 0) AND
2529: (p_ic_tran_rec.trans_date > (SYSDATE + l_op_alot_prm_rec.alloc_horizon))
2530: THEN
2531: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation horizon is out - using '|| l_op_alot_prm_rec.alloc_horizon||' days.');
2532: GMI_Reservation_Util.PrintLn('(opm_dbg) do allocate from sysdate > ' || (p_ic_tran_rec.trans_date + l_op_alot_prm_rec.alloc_horizon));
2533: GMI_Reservation_Util.PrintLn('(opm_dbg) or choose trans_date < '|| (SYSDATE + l_op_alot_prm_rec.alloc_horizon));
2534: FND_MESSAGE.SET_NAME('GML','SO_E_ALLOC_HORIZON_ERR');
2535: FND_MSG_PUB.Add;
2536: RAISE FND_API.G_EXC_ERROR;

Line 2533: GMI_Reservation_Util.PrintLn('(opm_dbg) or choose trans_date < '|| (SYSDATE + l_op_alot_prm_rec.alloc_horizon));

2529: (p_ic_tran_rec.trans_date > (SYSDATE + l_op_alot_prm_rec.alloc_horizon))
2530: THEN
2531: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation horizon is out - using '|| l_op_alot_prm_rec.alloc_horizon||' days.');
2532: GMI_Reservation_Util.PrintLn('(opm_dbg) do allocate from sysdate > ' || (p_ic_tran_rec.trans_date + l_op_alot_prm_rec.alloc_horizon));
2533: GMI_Reservation_Util.PrintLn('(opm_dbg) or choose trans_date < '|| (SYSDATE + l_op_alot_prm_rec.alloc_horizon));
2534: FND_MESSAGE.SET_NAME('GML','SO_E_ALLOC_HORIZON_ERR');
2535: FND_MSG_PUB.Add;
2536: RAISE FND_API.G_EXC_ERROR;
2537: END IF;