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 GMI_TRANS_ENGINE_PUB

Line 530: l_ictran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

526: ) IS
527:
528: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Default_Lot';
529:
530: l_ictran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
531: l_tran_row IC_TRAN_PND%ROWTYPE;
532: l_tmp_qty NUMBER(19,9);
533:
534: ll_trans_id NUMBER;

Line 654: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

650: Close get_line_info;
651: l_ictran_rec.trans_date := l_schedule_ship_date;
652: -- END - Bug 3216096
653:
654: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
655: ( p_api_version => 1.0
656: , p_init_msg_list => FND_API.G_FALSE
657: , p_commit => FND_API.G_FALSE
658: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

667: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
668: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
669: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
670: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
671: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
672: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
673: FND_MSG_PUB.Add;
674: raise FND_API.G_EXC_ERROR;
675: END IF;

Line 687: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION

683: before call update_pending_transaction qty1='||l_ictran_rec.trans_qty||' '
684: ||l_ictran_rec.trans_um||', qty2='||l_ictran_rec.trans_qty2||' '
685: ||l_ictran_rec.trans_um2||', trans_id='||l_ictran_rec.trans_id);
686:
687: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
688: ( p_api_version => 1.0
689: , p_init_msg_list => FND_API.G_FALSE
690: , p_commit => FND_API.G_FALSE
691: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

697:
698: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
699: THEN
700: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Default_Lot:
701: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
702: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
703: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
704: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
705: FND_MESSAGE.Set_Token('WHERE', 'Create_Default_Lot');

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

700: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Default_Lot:
701: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.' );
702: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
703: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
704: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
705: FND_MESSAGE.Set_Token('WHERE', 'Create_Default_Lot');
706: FND_MSG_PUB.Add;
707: RAISE FND_API.G_EXC_ERROR;
708: END IF;

Line 1415: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

1411: l_secondary_reservation_qty NUMBER(19,9);
1412: l_allocated_transactions NUMBER;
1413: l_delta_Not_Alloc_qty NUMBER(19,9);
1414: l_delta_Not_Alloc_qty2 NUMBER(19,9);
1415: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1416:
1417: l_qc_grade VARCHAR2(10);
1418: l_trans_qty2 NUMBER(19,9);
1419: l_trans_um2 VARCHAR2(4);

Line 1938: ( p_ic_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec

1934:
1935: END PrintLn;
1936:
1937: PROCEDURE Validation_ictran_rec
1938: ( p_ic_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
1939: , x_ic_tran_rec OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec
1940: , x_return_status OUT NOCOPY VARCHAR2
1941: , x_msg_count OUT NOCOPY NUMBER
1942: , x_msg_data OUT NOCOPY VARCHAR2

Line 1939: , x_ic_tran_rec OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec

1935: END PrintLn;
1936:
1937: PROCEDURE Validation_ictran_rec
1938: ( p_ic_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
1939: , x_ic_tran_rec OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec
1940: , x_return_status OUT NOCOPY VARCHAR2
1941: , x_msg_count OUT NOCOPY NUMBER
1942: , x_msg_data OUT NOCOPY VARCHAR2
1943: ) Is

Line 2270: ( p_ic_tran_rec IN OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec

2266: /* */
2267: /* The item_id is the OPM one. */
2268: /* ======================================================================== */
2269: PROCEDURE Set_Pick_Lots
2270: ( p_ic_tran_rec IN OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec
2271: , p_mo_line_id IN NUMBER
2272: , p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
2273: , x_return_status OUT NOCOPY VARCHAR2
2274: , x_msg_count OUT NOCOPY NUMBER

Line 2293: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

2289: l_mtl_reservation_tbl_count NUMBER;
2290: l_error_code NUMBER;
2291: l_default_lot_index NUMBER;
2292: l_original_tran_index NUMBER;
2293: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2294: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2295: l_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2296: ll_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2297: l_temp_tran_row ic_tran_pnd%ROWTYPE;

Line 2294: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

2290: l_error_code NUMBER;
2291: l_default_lot_index NUMBER;
2292: l_original_tran_index NUMBER;
2293: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2294: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2295: l_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2296: ll_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2297: l_temp_tran_row ic_tran_pnd%ROWTYPE;
2298:

Line 2295: l_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

2291: l_default_lot_index NUMBER;
2292: l_original_tran_index NUMBER;
2293: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2294: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2295: l_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2296: ll_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2297: l_temp_tran_row ic_tran_pnd%ROWTYPE;
2298:
2299: l_delta_qty1 NUMBER(19,9);

Line 2296: ll_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

2292: l_original_tran_index NUMBER;
2293: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2294: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2295: l_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2296: ll_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2297: l_temp_tran_row ic_tran_pnd%ROWTYPE;
2298:
2299: l_delta_qty1 NUMBER(19,9);
2300: l_delta_qty2 NUMBER(19,9);

Line 2835: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(

2831: l_original_tran_rec.trans_qty2 := (-1) * ll_ic_tran_rec.trans_qty2;
2832: l_original_tran_rec.trans_date := ll_ic_tran_rec.trans_date;
2833: l_original_tran_rec.reason_code := ll_ic_tran_rec.reason_code;
2834: GMI_reservation_Util.PrintLn('(opm_dbg)in Set_Pick_Lots: Update the transaction qty to:' || l_original_tran_rec.trans_qty , 'pick_lots.log');
2835: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(
2836: p_api_version => 1.0
2837: ,p_init_msg_list => FND_API.G_FALSE
2838: ,p_commit => l_commit
2839: ,p_validation_level => l_validation_level

Line 2848: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.', 'pick_lots.log');

2844: ,x_msg_data => x_msg_data);
2845:
2846: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2847: THEN
2848: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.', 'pick_lots.log');
2849: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2850: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2851: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2852: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

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

2847: THEN
2848: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.', 'pick_lots.log');
2849: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2850: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2851: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2852: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2853: FND_MSG_PUB.Add;
2854: RAISE FND_API.G_EXC_ERROR;
2855: END IF;

Line 2933: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION(

2929: gmi_reservation_util.println('Value of l_original_tran_rec.trans_qty2 is '||l_original_tran_rec.trans_qty2);
2930: gmi_reservation_util.println('Value of l_original_tran_rec.trans_um is '|| l_original_tran_rec.trans_um);
2931: gmi_reservation_util.println('Value of l_original_tran_rec.trans_um2 is '|| l_original_tran_rec.trans_um2);
2932: GMI_reservation_Util.PrintLn('(opm_dbg)in Set_Pick_Lots: Create the new transaction :', 'pick_lots.log');
2933: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION(
2934: p_api_version => 1.0
2935: ,p_init_msg_list => FND_API.G_FALSE
2936: ,p_commit => l_commit
2937: ,p_validation_level => l_validation_level

Line 2946: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');

2942: ,x_msg_data => x_msg_data);
2943:
2944: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2945: THEN
2946: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
2947: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2948: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2949: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2950: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

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

2945: THEN
2946: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
2947: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2948: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2949: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2950: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2951: FND_MSG_PUB.Add;
2952: RAISE FND_API.G_EXC_ERROR;
2953: END IF;

Line 3134: ( p_ic_default_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec

3130:
3131: END Set_Pick_Lots;
3132:
3133: PROCEDURE balance_default_lot
3134: ( p_ic_default_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
3135: , p_opm_item_id IN NUMBER
3136: , x_return_status OUT NOCOPY VARCHAR2
3137: , x_msg_count OUT NOCOPY NUMBER
3138: , x_msg_data OUT NOCOPY VARCHAR2

Line 3149: l_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

3145: l_trans_qty NUMBER;
3146: l_trans_qty2 NUMBER;
3147: l_commit VARCHAR2(5) := FND_API.G_FALSE;
3148: l_validation_level VARCHAR2(4) := FND_API.G_VALID_LEVEL_FULL;
3149: l_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3150: l_temp_tran_row ic_tran_pnd%ROWTYPE;
3151: l_organization_id NUMBER;
3152: l_inventory_item_id NUMBER;
3153: l_ctl_ind VARCHAR2(1) ;

Line 3325: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION(

3321: GMI_reservation_Util.PrintLn(' old whse '||l_whse_code);
3322: GMI_reservation_Util.PrintLn(' new whse '||l_ic_tran_rec.whse_code);
3323: GMI_reservation_Util.PrintLn(' old item_id '||l_opm_item_id);
3324: GMI_reservation_Util.PrintLn(' new item_id '||l_ic_tran_rec.item_id);
3325: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION(
3326: p_api_version => 1.0
3327: ,p_init_msg_list => fnd_api.g_false
3328: ,p_commit => l_commit
3329: ,p_validation_level => l_validation_level

Line 3341: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');

3337: THEN
3338: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Delete_Transaction().');
3339: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3340: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3341: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');
3342: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
3343: FND_MSG_PUB.Add;
3344: RAISE FND_API.G_EXC_ERROR;
3345: END IF;

Line 3354: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION(

3350: l_ic_tran_rec.item_id := l_opm_item_id;
3351: l_ic_tran_rec.trans_um := l_trans_um;
3352: l_ic_tran_rec.trans_um2 := l_trans_um2;
3353:
3354: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION(
3355: p_api_version => 1.0
3356: ,p_init_msg_list => FND_API.G_FALSE
3357: ,p_commit => l_commit
3358: ,p_validation_level => l_validation_level

Line 3367: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');

3363: ,x_msg_data => x_msg_data);
3364:
3365: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3366: THEN
3367: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
3368: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3369: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3370: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3371: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');

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

3366: THEN
3367: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
3368: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3369: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3370: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3371: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3372: FND_MSG_PUB.Add;
3373: RAISE FND_API.G_EXC_ERROR;
3374: END IF;

Line 3387: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION

3383: ) ;
3384:
3385: ELSE
3386: GMI_reservation_Util.PrintLn('(opm_dbg)in balancing the default lot, update pending trans');
3387: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
3388: (
3389: p_api_version => 1.0
3390: ,p_init_msg_list => FND_API.G_FALSE
3391: ,p_commit => l_commit

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

3399: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3400: GMI_reservation_Util.PrintLn('(opm_dbg)in balancing the default lot: ERROR');
3401: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3402: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3403: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
3404: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3405: FND_MSG_PUB.Add;
3406: RAISE FND_API.G_EXC_ERROR;
3407: END IF;

Line 3432: ( p_ic_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec

3428:
3429: END;
3430:
3431: PROCEDURE Create_Empty_Default_Lot
3432: ( p_ic_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
3433: , p_organization_id IN NUMBER
3434: , x_default_lot_index OUT NOCOPY BINARY_INTEGER
3435: , x_return_status OUT NOCOPY VARCHAR2
3436: , x_msg_count OUT NOCOPY NUMBER

Line 3449: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

3445: l_commit VARCHAR2(5) := FND_API.G_FALSE;
3446: l_validation_level VARCHAR2(4) := FND_API.G_VALID_LEVEL_FULL;
3447:
3448: l_temp_tran_row ic_tran_pnd%ROWTYPE;
3449: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3450: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3451: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
3452: l_mtl_reservation_tbl_count NUMBER;
3453: l_error_code NUMBER;

Line 3544: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION(

3540: , x_msg_data => x_msg_data);
3541:
3542: IF (ll_trans_id is NULL)
3543: THEN
3544: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION(
3545: p_api_version => 1.0
3546: ,p_init_msg_list => FND_API.G_FALSE
3547: ,p_commit => l_commit
3548: ,p_validation_level => l_validation_level

Line 3557: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');

3553: ,x_msg_data => x_msg_data);
3554:
3555: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3556: THEN
3557: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
3558: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3559: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3560: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3561: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');

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

3556: THEN
3557: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
3558: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3559: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3560: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3561: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3562: FND_MSG_PUB.Add;
3563: RAISE FND_API.G_EXC_ERROR;
3564: END IF;

Line 3765: l_ictran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

3761: , x_return_status OUT NOCOPY VARCHAR2
3762: , x_msg_count OUT NOCOPY NUMBER
3763: , x_msg_data OUT NOCOPY VARCHAR2
3764: ) IS
3765: l_ictran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3766: l_tran_row IC_TRAN_PND%ROWTYPE;
3767: l_uom1 Varchar2(5);
3768: l_uom2 Varchar2(5);
3769: l_orgn_code Varchar2(10);

Line 3858: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

3854: l_ictran_rec.text_code := NULL;
3855: l_ictran_rec.user_id := NULL;
3856: l_ictran_rec.create_lot_index := NULL;
3857:
3858: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
3859: ( p_api_version => 1.0
3860: , p_init_msg_list => FND_API.G_FALSE
3861: , p_commit => FND_API.G_FALSE
3862: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

3871: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
3872: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
3873: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3874: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3875: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3876: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
3877: FND_MSG_PUB.Add;
3878: raise FND_API.G_EXC_ERROR;
3879: END IF;

Line 3896: l_ictran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

3892: , x_msg_count OUT NOCOPY NUMBER
3893: , x_msg_data OUT NOCOPY VARCHAR2
3894: ) IS
3895:
3896: l_ictran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3897: l_tran_row IC_TRAN_PND%ROWTYPE;
3898: l_uom1 Varchar2(5);
3899: l_uom2 Varchar2(5);
3900: l_orgn_code Varchar2(10);

Line 4144: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

4140: END IF;
4141: Close get_lot_status;
4142: GMI_RESERVATION_UTIL.println('lot_status '||l_ictran_rec.lot_status);
4143:
4144: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
4145: ( p_api_version => 1.0
4146: , p_init_msg_list => FND_API.G_FALSE
4147: , p_commit => FND_API.G_FALSE
4148: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

4158: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
4159: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4160: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4161: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4162: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4163: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4164: FND_MSG_PUB.Add;
4165: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4166: END IF;

Line 4172: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED

4168: l_ictran_rec.trans_id := l_tran_row.trans_id;
4169: GMI_RESERVATION_UTIL.println('trans_id '||l_ictran_rec.trans_id);
4170:
4171: GMI_RESERVATION_UTIL.println('after create pending transaction ');
4172: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
4173: (
4174: p_api_version => 1
4175: ,p_init_msg_list => FND_API.G_FALSE
4176: ,p_commit => FND_API.G_FALSE

Line 4192: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');

4188: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by UPDATE_PENDING_TO_COMPLETED,
4189: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4190: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4191: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4192: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
4193: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4194: FND_MSG_PUB.Add;
4195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4196: END IF;

Line 4623: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

4619: x_return_status OUT NOCOPY VARCHAR2,
4620: x_msg_count OUT NOCOPY NUMBER,
4621: x_msg_data OUT NOCOPY VARCHAR2)
4622: IS
4623: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4624: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4625: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
4626: l_new_transaction_row ic_tran_pnd%ROWTYPE;
4627: l_trans_id ic_tran_pnd.trans_id%TYPE;

Line 4624: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

4620: x_msg_count OUT NOCOPY NUMBER,
4621: x_msg_data OUT NOCOPY VARCHAR2)
4622: IS
4623: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4624: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4625: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
4626: l_new_transaction_row ic_tran_pnd%ROWTYPE;
4627: l_trans_id ic_tran_pnd.trans_id%TYPE;
4628: l_new_trans_id ic_tran_pnd.trans_id%TYPE;

Line 4767: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

4763: l_new_transaction_rec.trans_qty2 := 0;
4764: l_new_transaction_rec.line_id := p_new_source_line_id;
4765:
4766: GMI_RESERVATION_UTIL.PrintLn('creating the default trans for the new line');
4767: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
4768: ( p_api_version => 1
4769: , p_init_msg_list => FND_API.G_FALSE
4770: , p_commit => FND_API.G_FALSE
4771: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

4782: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
4783: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4784: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4785: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4786: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4787: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4788: FND_MSG_PUB.Add;
4789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4790: END IF;

Line 4831: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

4827: l_new_transaction_rec.trans_qty2 := -1 * (abs(l_new_transaction_rec.trans_qty2)
4828: - l_qty2_to_fulfil);
4829: l_new_transaction_rec.line_id := p_new_source_line_id;
4830:
4831: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
4832: ( p_api_version => 1
4833: , p_init_msg_list => FND_API.G_FALSE
4834: , p_commit => FND_API.G_FALSE
4835: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

4846: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
4847: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4848: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4849: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4850: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4851: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4852: FND_MSG_PUB.Add;
4853:
4854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4951: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

4947: x_msg_data OUT NOCOPY VARCHAR2)
4948:
4949: IS
4950:
4951: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4952: l_old_transaction_row ic_tran_pnd%ROWTYPE;
4953:
4954: -- HW cursor for cntl items
4955: CURSOR get_opm_txn_cntl (p_trans_id NUMBER) IS

Line 5029: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED

5025: l_old_transaction_rec.staged_ind :=1;
5026: -- Make the Bill-To transactions unique so subledger can identify them since
5027: -- there are no records in wsh_delivery_details
5028: l_old_transaction_rec.line_detail_id := -999;
5029: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
5030: (
5031: p_api_version => 1
5032: ,p_init_msg_list => FND_API.G_FALSE
5033: ,p_commit => FND_API.G_FALSE

Line 5048: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');

5044: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by UPDATE_PENDING_TO_COMPLETED,
5045: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
5046: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
5047: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
5048: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
5049: FND_MESSAGE.Set_Token('WHERE','update_opm_trxns');
5050: FND_MSG_PUB.Add;
5051: x_return_status := FND_API.G_RET_STS_ERROR;
5052: RETURN;