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 2307: l_op_alot_prm_rec op_alot_prm%ROWTYPE;

2303: l_deleted_qty1 NUMBER(19,9);
2304: l_deleted_qty2 NUMBER(19,9);
2305:
2306: /* For the Allocation rules. */
2307: l_op_alot_prm_rec op_alot_prm%ROWTYPE;
2308: l_inventory_item_id NUMBER;
2309: l_ic_item_mst_rec GMI_Reservation_Util.ic_item_mst_rec;
2310: l_cust_no op_cust_mst.cust_no%TYPE;
2311: l_co_code op_cust_mst.co_code%TYPE; --B1731567 co_code of cust

Line 2495: x_op_alot_prm => l_op_alot_prm_rec,

2491: GMI_ALLOCATION_RULES_PVT.GET_ALLOCATION_PARMS
2492: ( p_co_code => l_co_code, --B1731567
2493: p_cust_no => l_cust_no,
2494: p_alloc_class => l_ic_item_mst_rec.alloc_class,
2495: x_op_alot_prm => l_op_alot_prm_rec,
2496: x_return_status => x_return_status,
2497: x_msg_count => x_msg_count,
2498: x_msg_data => x_msg_data
2499: );

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

2499: );
2500:
2501: /* if no allocation rules found, then Raise Exception and return */
2502: /* ------------------------------------------------------------------------ */
2503: IF ((l_op_alot_prm_rec.alloc_class = ' ') OR
2504: (l_op_alot_prm_rec.delete_mark = 1))
2505: THEN
2506: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation - Error missing allocation parms',1);
2507: FND_MESSAGE.SET_NAME('GML','GML_NO_ALLOCATION_PARMS');

Line 2504: (l_op_alot_prm_rec.delete_mark = 1))

2500:
2501: /* if no allocation rules found, then Raise Exception and return */
2502: /* ------------------------------------------------------------------------ */
2503: IF ((l_op_alot_prm_rec.alloc_class = ' ') OR
2504: (l_op_alot_prm_rec.delete_mark = 1))
2505: THEN
2506: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation - Error missing allocation parms',1);
2507: FND_MESSAGE.SET_NAME('GML','GML_NO_ALLOCATION_PARMS');
2508: FND_MESSAGE.SET_TOKEN('ALLOC_CLASS', l_ic_item_mst_rec.alloc_class);

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

2512:
2513: /* It is not possible to allocate (create/update) if the period between */
2514: /* trans_date and sysdate is greater than the Horizon period. */
2515: /* --------------------------------------------------------------------- */
2516: IF (l_op_alot_prm_rec.alloc_horizon > 0) AND
2517: (p_ic_tran_rec.trans_date > (SYSDATE + l_op_alot_prm_rec.alloc_horizon))
2518: THEN
2519: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation horizon is out - using '|| l_op_alot_prm_rec.alloc_horizon||' days.');
2520: GMI_Reservation_Util.PrintLn('(opm_dbg) do allocate from sysdate > ' || (p_ic_tran_rec.trans_date + l_op_alot_prm_rec.alloc_horizon));

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

2513: /* It is not possible to allocate (create/update) if the period between */
2514: /* trans_date and sysdate is greater than the Horizon period. */
2515: /* --------------------------------------------------------------------- */
2516: IF (l_op_alot_prm_rec.alloc_horizon > 0) AND
2517: (p_ic_tran_rec.trans_date > (SYSDATE + l_op_alot_prm_rec.alloc_horizon))
2518: THEN
2519: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation horizon is out - using '|| l_op_alot_prm_rec.alloc_horizon||' days.');
2520: GMI_Reservation_Util.PrintLn('(opm_dbg) do allocate from sysdate > ' || (p_ic_tran_rec.trans_date + l_op_alot_prm_rec.alloc_horizon));
2521: GMI_Reservation_Util.PrintLn('(opm_dbg) or choose trans_date < '|| (SYSDATE + l_op_alot_prm_rec.alloc_horizon));

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

2515: /* --------------------------------------------------------------------- */
2516: IF (l_op_alot_prm_rec.alloc_horizon > 0) AND
2517: (p_ic_tran_rec.trans_date > (SYSDATE + l_op_alot_prm_rec.alloc_horizon))
2518: THEN
2519: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation horizon is out - using '|| l_op_alot_prm_rec.alloc_horizon||' days.');
2520: GMI_Reservation_Util.PrintLn('(opm_dbg) do allocate from sysdate > ' || (p_ic_tran_rec.trans_date + l_op_alot_prm_rec.alloc_horizon));
2521: GMI_Reservation_Util.PrintLn('(opm_dbg) or choose trans_date < '|| (SYSDATE + l_op_alot_prm_rec.alloc_horizon));
2522: FND_MESSAGE.SET_NAME('GML','SO_E_ALLOC_HORIZON_ERR');
2523: FND_MSG_PUB.Add;

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

2516: IF (l_op_alot_prm_rec.alloc_horizon > 0) AND
2517: (p_ic_tran_rec.trans_date > (SYSDATE + l_op_alot_prm_rec.alloc_horizon))
2518: THEN
2519: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation horizon is out - using '|| l_op_alot_prm_rec.alloc_horizon||' days.');
2520: GMI_Reservation_Util.PrintLn('(opm_dbg) do allocate from sysdate > ' || (p_ic_tran_rec.trans_date + l_op_alot_prm_rec.alloc_horizon));
2521: GMI_Reservation_Util.PrintLn('(opm_dbg) or choose trans_date < '|| (SYSDATE + l_op_alot_prm_rec.alloc_horizon));
2522: FND_MESSAGE.SET_NAME('GML','SO_E_ALLOC_HORIZON_ERR');
2523: FND_MSG_PUB.Add;
2524: RAISE FND_API.G_EXC_ERROR;

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

2517: (p_ic_tran_rec.trans_date > (SYSDATE + l_op_alot_prm_rec.alloc_horizon))
2518: THEN
2519: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation horizon is out - using '|| l_op_alot_prm_rec.alloc_horizon||' days.');
2520: GMI_Reservation_Util.PrintLn('(opm_dbg) do allocate from sysdate > ' || (p_ic_tran_rec.trans_date + l_op_alot_prm_rec.alloc_horizon));
2521: GMI_Reservation_Util.PrintLn('(opm_dbg) or choose trans_date < '|| (SYSDATE + l_op_alot_prm_rec.alloc_horizon));
2522: FND_MESSAGE.SET_NAME('GML','SO_E_ALLOC_HORIZON_ERR');
2523: FND_MSG_PUB.Add;
2524: RAISE FND_API.G_EXC_ERROR;
2525: END IF;