DBA Data[Home] [Help]

APPS.GMI_PICK_WAVE_CONFIRM_PVT dependencies on GMI_TRANS_ENGINE_PUB

Line 2384: p_dflt_nonctl_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec

2380:
2381: /* Following procedure created for bug2901317*/
2382: PROCEDURE BALANCE_NONINV_TRAN
2383: (
2384: p_dflt_nonctl_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
2385: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2386: , p_requested_qty IN NUMBER
2387: , p_requested_qty2 IN NUMBER
2388: , p_delivery_detail_id IN NUMBER

Line 2396: l_dflt_nonctl_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

2392: , x_msg_data OUT NOCOPY VARCHAR2
2393: )
2394: IS
2395:
2396: l_dflt_nonctl_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2397: l_validation_level VARCHAR2(4) := FND_API.G_VALID_LEVEL_FULL;
2398: BEGIN
2399:
2400: l_dflt_nonctl_tran_rec := p_dflt_nonctl_tran_rec;

Line 2415: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(

2411: l_dflt_nonctl_tran_rec.line_detail_id := null;
2412:
2413:
2414: /* Updating the default transaction with backordered quantity */
2415: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(
2416: p_api_version => 1.0
2417: ,p_init_msg_list => FND_API.G_FALSE
2418: ,p_commit => p_commit
2419: ,p_validation_level => l_validation_level

Line 2428: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );

2424: ,x_msg_data => x_msg_data);
2425:
2426: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2427: GMI_reservation_Util.PrintLn('(opm_dbg) in PICK_CONFIRM:
2428: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2429: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2430: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2431: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2432: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');

Line 2431: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');

2427: GMI_reservation_Util.PrintLn('(opm_dbg) in PICK_CONFIRM:
2428: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2429: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2430: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2431: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2432: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');
2433: FND_MSG_PUB.Add;
2434: RAISE FND_API.G_EXC_ERROR;
2435: END IF;

Line 2447: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

2443:
2444: GMI_Reservation_Util.PrintLn('Creating new pending txn with req qty '||l_dflt_nonctl_tran_rec.trans_qty );
2445:
2446: /* Creating a new transaction with the staged quantity */
2447: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
2448: ( p_api_version => 1.0
2449: , p_init_msg_list => FND_API.G_FALSE
2450: , p_commit => FND_API.G_FALSE
2451: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2464: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');

2460: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
2461: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
2462: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2463: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2464: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2465: FND_MESSAGE.Set_Token('WHERE','PICK_CONFIRM');
2466: FND_MSG_PUB.Add;
2467: raise FND_API.G_EXC_ERROR;
2468: END IF;

Line 2546: l_dflt_nonctl_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

2542: from ic_item_mst
2543: where item_id = p_item_id;
2544:
2545: l_trans_id NUMBER;
2546: l_dflt_nonctl_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2547: l_dflt_nonctl_tran_rec1 GMI_TRANS_ENGINE_PUB.ictran_rec;
2548: l_validation_level VARCHAR2(4) := FND_API.G_VALID_LEVEL_FULL;
2549: l_tran_row IC_TRAN_PND%ROWTYPE;
2550: l_onhand_qty NUMBER := 0; -- Bug 2910069

Line 2547: l_dflt_nonctl_tran_rec1 GMI_TRANS_ENGINE_PUB.ictran_rec;

2543: where item_id = p_item_id;
2544:
2545: l_trans_id NUMBER;
2546: l_dflt_nonctl_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2547: l_dflt_nonctl_tran_rec1 GMI_TRANS_ENGINE_PUB.ictran_rec;
2548: l_validation_level VARCHAR2(4) := FND_API.G_VALID_LEVEL_FULL;
2549: l_tran_row IC_TRAN_PND%ROWTYPE;
2550: l_onhand_qty NUMBER := 0; -- Bug 2910069
2551: l_onhand_qty2 NUMBER := 0; -- Bug 2910069

Line 2620: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(

2616: l_dflt_nonctl_tran_rec.line_detail_id := p_delivery_detail_id;
2617: l_dflt_nonctl_tran_rec.staged_ind := 1;
2618:
2619: /* Updating the default transaction with requested quantity */
2620: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(
2621: p_api_version => 1.0
2622: ,p_init_msg_list => FND_API.G_FALSE
2623: ,p_commit => p_commit
2624: ,p_validation_level => l_validation_level

Line 2711: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(

2707: l_dflt_nonctl_tran_rec.staged_ind := 0;
2708: l_dflt_nonctl_tran_rec.line_detail_id := null;
2709:
2710: /* Updating the default transaction with backordered quantity */
2711: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(
2712: p_api_version => 1.0
2713: ,p_init_msg_list => FND_API.G_FALSE
2714: ,p_commit => p_commit
2715: ,p_validation_level => l_validation_level

Line 2731: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

2727:
2728: GMI_Reservation_Util.PrintLn('1. creating new pending txn with avail qty '||l_dflt_nonctl_tran_rec.trans_qty );
2729:
2730: /* Creating a new transaction with the staged quantity */
2731: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
2732: ( p_api_version => 1.0
2733: , p_init_msg_list => FND_API.G_FALSE
2734: , p_commit => FND_API.G_FALSE
2735: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2748: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');

2744: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
2745: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
2746: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2747: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2748: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2749: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
2750: FND_MSG_PUB.Add;
2751: raise FND_API.G_EXC_ERROR;
2752: END IF;

Line 2767: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(

2763: l_dflt_nonctl_tran_rec.staged_ind := 0;
2764: l_dflt_nonctl_tran_rec.line_detail_id := null;
2765:
2766: /* Updating the default transaction with backordered quantity */
2767: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(
2768: p_api_version => 1.0
2769: ,p_init_msg_list => FND_API.G_FALSE
2770: ,p_commit => p_commit
2771: ,p_validation_level => l_validation_level

Line 2780: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );

2776: ,x_msg_data => x_msg_data);
2777:
2778: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2779: GMI_reservation_Util.PrintLn('(opm_dbg) in PICK_CONFIRM:
2780: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2781: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2782: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2783: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2784: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');

Line 2783: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');

2779: GMI_reservation_Util.PrintLn('(opm_dbg) in PICK_CONFIRM:
2780: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2781: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2782: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2783: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2784: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');
2785: FND_MSG_PUB.Add;
2786: RAISE FND_API.G_EXC_ERROR;
2787: END IF;

Line 2798: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

2794:
2795: GMI_Reservation_Util.PrintLn('2. creating new pending txn with req qty '||l_dflt_nonctl_tran_rec.trans_qty );
2796:
2797: /* Creating a new transaction with the staged quantity */
2798: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
2799: ( p_api_version => 1.0
2800: , p_init_msg_list => FND_API.G_FALSE
2801: , p_commit => FND_API.G_FALSE
2802: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2815: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');

2811: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
2812: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
2813: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2814: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2815: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2816: FND_MESSAGE.Set_Token('WHERE','PICK_CONFIRM');
2817: FND_MSG_PUB.Add;
2818: raise FND_API.G_EXC_ERROR;
2819: END IF;

Line 2828: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(

2824: l_dflt_nonctl_tran_rec.staged_ind := 1;
2825:
2826: GMI_Reservation_Util.PrintLn('3. Updating pending txn with staged ind/delivery id');
2827:
2828: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(
2829: p_api_version => 1.0
2830: ,p_init_msg_list => FND_API.G_FALSE
2831: ,p_commit => p_commit
2832: ,p_validation_level => l_validation_level

Line 2841: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );

2837: ,x_msg_data => x_msg_data);
2838:
2839: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2840: GMI_reservation_Util.PrintLn('(opm_dbg) in PICK_CONFIRM:
2841: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2842: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2843: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2844: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2845: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');

Line 2844: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');

2840: GMI_reservation_Util.PrintLn('(opm_dbg) in PICK_CONFIRM:
2841: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
2842: GMI_reservation_Util.PrintLn(x_msg_data); -- Bug 3859774
2843: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2844: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2845: FND_MESSAGE.Set_Token('WHERE', 'PICK_CONFIRM');
2846: FND_MSG_PUB.Add;
2847: RAISE FND_API.G_EXC_ERROR;
2848: END IF;