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 526: l_ictran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

522: ) IS
523:
524: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Default_Lot';
525:
526: l_ictran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
527: l_tran_row IC_TRAN_PND%ROWTYPE;
528: l_tmp_qty NUMBER(19,9);
529:
530: ll_trans_id NUMBER;

Line 650: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

646: Close get_line_info;
647: l_ictran_rec.trans_date := l_schedule_ship_date;
648: -- END - Bug 3216096
649:
650: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
651: ( p_api_version => 1.0
652: , p_init_msg_list => FND_API.G_FALSE
653: , p_commit => FND_API.G_FALSE
654: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

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

Line 683: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION

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

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

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

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

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

Line 1411: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

1407: l_secondary_reservation_qty NUMBER(19,9);
1408: l_allocated_transactions NUMBER;
1409: l_delta_Not_Alloc_qty NUMBER(19,9);
1410: l_delta_Not_Alloc_qty2 NUMBER(19,9);
1411: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1412:
1413: l_qc_grade VARCHAR2(10);
1414: l_trans_qty2 NUMBER(19,9);
1415: l_trans_um2 VARCHAR2(4);

Line 1926: ( p_ic_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec

1922:
1923: END PrintLn;
1924:
1925: PROCEDURE Validation_ictran_rec
1926: ( p_ic_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
1927: , x_ic_tran_rec OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec
1928: , x_return_status OUT NOCOPY VARCHAR2
1929: , x_msg_count OUT NOCOPY NUMBER
1930: , x_msg_data OUT NOCOPY VARCHAR2

Line 1927: , x_ic_tran_rec OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec

1923: END PrintLn;
1924:
1925: PROCEDURE Validation_ictran_rec
1926: ( p_ic_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
1927: , x_ic_tran_rec OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec
1928: , x_return_status OUT NOCOPY VARCHAR2
1929: , x_msg_count OUT NOCOPY NUMBER
1930: , x_msg_data OUT NOCOPY VARCHAR2
1931: ) Is

Line 2258: ( p_ic_tran_rec IN OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec

2254: /* */
2255: /* The item_id is the OPM one. */
2256: /* ======================================================================== */
2257: PROCEDURE Set_Pick_Lots
2258: ( p_ic_tran_rec IN OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec
2259: , p_mo_line_id IN NUMBER
2260: , p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
2261: , x_return_status OUT NOCOPY VARCHAR2
2262: , x_msg_count OUT NOCOPY NUMBER

Line 2281: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

2277: l_mtl_reservation_tbl_count NUMBER;
2278: l_error_code NUMBER;
2279: l_default_lot_index NUMBER;
2280: l_original_tran_index NUMBER;
2281: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2282: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2283: l_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2284: ll_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2285: l_temp_tran_row ic_tran_pnd%ROWTYPE;

Line 2282: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

2278: l_error_code NUMBER;
2279: l_default_lot_index NUMBER;
2280: l_original_tran_index NUMBER;
2281: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2282: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2283: l_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2284: ll_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2285: l_temp_tran_row ic_tran_pnd%ROWTYPE;
2286:

Line 2283: l_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

2279: l_default_lot_index NUMBER;
2280: l_original_tran_index NUMBER;
2281: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2282: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2283: l_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2284: ll_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2285: l_temp_tran_row ic_tran_pnd%ROWTYPE;
2286:
2287: l_delta_qty1 NUMBER(19,9);

Line 2284: ll_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

2280: l_original_tran_index NUMBER;
2281: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2282: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2283: l_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2284: ll_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2285: l_temp_tran_row ic_tran_pnd%ROWTYPE;
2286:
2287: l_delta_qty1 NUMBER(19,9);
2288: l_delta_qty2 NUMBER(19,9);

Line 2823: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(

2819: l_original_tran_rec.trans_qty2 := (-1) * ll_ic_tran_rec.trans_qty2;
2820: l_original_tran_rec.trans_date := ll_ic_tran_rec.trans_date;
2821: l_original_tran_rec.reason_code := ll_ic_tran_rec.reason_code;
2822: GMI_reservation_Util.PrintLn('(opm_dbg)in Set_Pick_Lots: Update the transaction qty to:' || l_original_tran_rec.trans_qty , 'pick_lots.log');
2823: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(
2824: p_api_version => 1.0
2825: ,p_init_msg_list => FND_API.G_FALSE
2826: ,p_commit => l_commit
2827: ,p_validation_level => l_validation_level

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

2832: ,x_msg_data => x_msg_data);
2833:
2834: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2835: THEN
2836: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.', 'pick_lots.log');
2837: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2838: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2839: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2840: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

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

2835: THEN
2836: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.', 'pick_lots.log');
2837: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2838: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2839: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2840: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2841: FND_MSG_PUB.Add;
2842: RAISE FND_API.G_EXC_ERROR;
2843: END IF;

Line 2921: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION(

2917: gmi_reservation_util.println('Value of l_original_tran_rec.trans_qty2 is '||l_original_tran_rec.trans_qty2);
2918: gmi_reservation_util.println('Value of l_original_tran_rec.trans_um is '|| l_original_tran_rec.trans_um);
2919: gmi_reservation_util.println('Value of l_original_tran_rec.trans_um2 is '|| l_original_tran_rec.trans_um2);
2920: GMI_reservation_Util.PrintLn('(opm_dbg)in Set_Pick_Lots: Create the new transaction :', 'pick_lots.log');
2921: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION(
2922: p_api_version => 1.0
2923: ,p_init_msg_list => FND_API.G_FALSE
2924: ,p_commit => l_commit
2925: ,p_validation_level => l_validation_level

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

2930: ,x_msg_data => x_msg_data);
2931:
2932: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
2933: THEN
2934: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
2935: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2936: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2937: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2938: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');

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

2933: THEN
2934: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.', 'pick_lots.log');
2935: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2936: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2937: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2938: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2939: FND_MSG_PUB.Add;
2940: RAISE FND_API.G_EXC_ERROR;
2941: END IF;

Line 3122: ( p_ic_default_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec

3118:
3119: END Set_Pick_Lots;
3120:
3121: PROCEDURE balance_default_lot
3122: ( p_ic_default_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
3123: , p_opm_item_id IN NUMBER
3124: , x_return_status OUT NOCOPY VARCHAR2
3125: , x_msg_count OUT NOCOPY NUMBER
3126: , x_msg_data OUT NOCOPY VARCHAR2

Line 3137: l_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

3133: l_trans_qty NUMBER;
3134: l_trans_qty2 NUMBER;
3135: l_commit VARCHAR2(5) := FND_API.G_FALSE;
3136: l_validation_level VARCHAR2(4) := FND_API.G_VALID_LEVEL_FULL;
3137: l_ic_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3138: l_temp_tran_row ic_tran_pnd%ROWTYPE;
3139: l_organization_id NUMBER;
3140: l_inventory_item_id NUMBER;
3141: l_ctl_ind VARCHAR2(1) ;

Line 3313: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION(

3309: GMI_reservation_Util.PrintLn(' old whse '||l_whse_code);
3310: GMI_reservation_Util.PrintLn(' new whse '||l_ic_tran_rec.whse_code);
3311: GMI_reservation_Util.PrintLn(' old item_id '||l_opm_item_id);
3312: GMI_reservation_Util.PrintLn(' new item_id '||l_ic_tran_rec.item_id);
3313: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION(
3314: p_api_version => 1.0
3315: ,p_init_msg_list => fnd_api.g_false
3316: ,p_commit => l_commit
3317: ,p_validation_level => l_validation_level

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

3325: THEN
3326: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Delete_Transaction().');
3327: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3328: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3329: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');
3330: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
3331: FND_MSG_PUB.Add;
3332: RAISE FND_API.G_EXC_ERROR;
3333: END IF;

Line 3342: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION(

3338: l_ic_tran_rec.item_id := l_opm_item_id;
3339: l_ic_tran_rec.trans_um := l_trans_um;
3340: l_ic_tran_rec.trans_um2 := l_trans_um2;
3341:
3342: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION(
3343: p_api_version => 1.0
3344: ,p_init_msg_list => FND_API.G_FALSE
3345: ,p_commit => l_commit
3346: ,p_validation_level => l_validation_level

Line 3355: 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');

3351: ,x_msg_data => x_msg_data);
3352:
3353: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3354: THEN
3355: 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');
3356: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3357: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3358: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3359: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');

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

3354: THEN
3355: 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');
3356: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3357: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3358: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3359: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3360: FND_MSG_PUB.Add;
3361: RAISE FND_API.G_EXC_ERROR;
3362: END IF;

Line 3375: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION

3371: ) ;
3372:
3373: ELSE
3374: GMI_reservation_Util.PrintLn('(opm_dbg)in balancing the default lot, update pending trans');
3375: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
3376: (
3377: p_api_version => 1.0
3378: ,p_init_msg_list => FND_API.G_FALSE
3379: ,p_commit => l_commit

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

3387: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3388: GMI_reservation_Util.PrintLn('(opm_dbg)in balancing the default lot: ERROR');
3389: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3390: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3391: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
3392: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3393: FND_MSG_PUB.Add;
3394: RAISE FND_API.G_EXC_ERROR;
3395: END IF;

Line 3420: ( p_ic_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec

3416:
3417: END;
3418:
3419: PROCEDURE Create_Empty_Default_Lot
3420: ( p_ic_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
3421: , p_organization_id IN NUMBER
3422: , x_default_lot_index OUT NOCOPY BINARY_INTEGER
3423: , x_return_status OUT NOCOPY VARCHAR2
3424: , x_msg_count OUT NOCOPY NUMBER

Line 3437: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

3433: l_commit VARCHAR2(5) := FND_API.G_FALSE;
3434: l_validation_level VARCHAR2(4) := FND_API.G_VALID_LEVEL_FULL;
3435:
3436: l_temp_tran_row ic_tran_pnd%ROWTYPE;
3437: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3438: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3439: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
3440: l_mtl_reservation_tbl_count NUMBER;
3441: l_error_code NUMBER;

Line 3532: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION(

3528: , x_msg_data => x_msg_data);
3529:
3530: IF (ll_trans_id is NULL)
3531: THEN
3532: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION(
3533: p_api_version => 1.0
3534: ,p_init_msg_list => FND_API.G_FALSE
3535: ,p_commit => l_commit
3536: ,p_validation_level => l_validation_level

Line 3545: 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');

3541: ,x_msg_data => x_msg_data);
3542:
3543: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3544: THEN
3545: 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');
3546: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3547: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3548: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3549: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');

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

3544: THEN
3545: 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');
3546: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3547: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3548: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3549: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3550: FND_MSG_PUB.Add;
3551: RAISE FND_API.G_EXC_ERROR;
3552: END IF;

Line 3753: l_ictran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

3749: , x_return_status OUT NOCOPY VARCHAR2
3750: , x_msg_count OUT NOCOPY NUMBER
3751: , x_msg_data OUT NOCOPY VARCHAR2
3752: ) IS
3753: l_ictran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3754: l_tran_row IC_TRAN_PND%ROWTYPE;
3755: l_uom1 Varchar2(5);
3756: l_uom2 Varchar2(5);
3757: l_orgn_code Varchar2(10);

Line 3846: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

3842: l_ictran_rec.text_code := NULL;
3843: l_ictran_rec.user_id := NULL;
3844: l_ictran_rec.create_lot_index := NULL;
3845:
3846: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
3847: ( p_api_version => 1.0
3848: , p_init_msg_list => FND_API.G_FALSE
3849: , p_commit => FND_API.G_FALSE
3850: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

3859: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
3860: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
3861: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3862: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3863: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3864: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
3865: FND_MSG_PUB.Add;
3866: raise FND_API.G_EXC_ERROR;
3867: END IF;

Line 3884: l_ictran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

3880: , x_msg_count OUT NOCOPY NUMBER
3881: , x_msg_data OUT NOCOPY VARCHAR2
3882: ) IS
3883:
3884: l_ictran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3885: l_tran_row IC_TRAN_PND%ROWTYPE;
3886: l_uom1 Varchar2(5);
3887: l_uom2 Varchar2(5);
3888: l_orgn_code Varchar2(10);

Line 4132: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

4128: END IF;
4129: Close get_lot_status;
4130: GMI_RESERVATION_UTIL.println('lot_status '||l_ictran_rec.lot_status);
4131:
4132: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
4133: ( p_api_version => 1.0
4134: , p_init_msg_list => FND_API.G_FALSE
4135: , p_commit => FND_API.G_FALSE
4136: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

4146: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
4147: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4148: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4149: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4150: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4151: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4152: FND_MSG_PUB.Add;
4153: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4154: END IF;

Line 4160: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED

4156: l_ictran_rec.trans_id := l_tran_row.trans_id;
4157: GMI_RESERVATION_UTIL.println('trans_id '||l_ictran_rec.trans_id);
4158:
4159: GMI_RESERVATION_UTIL.println('after create pending transaction ');
4160: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
4161: (
4162: p_api_version => 1
4163: ,p_init_msg_list => FND_API.G_FALSE
4164: ,p_commit => FND_API.G_FALSE

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

4176: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by UPDATE_PENDING_TO_COMPLETED,
4177: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4178: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4179: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4180: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
4181: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4182: FND_MSG_PUB.Add;
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4184: END IF;

Line 4611: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

4607: x_return_status OUT NOCOPY VARCHAR2,
4608: x_msg_count OUT NOCOPY NUMBER,
4609: x_msg_data OUT NOCOPY VARCHAR2)
4610: IS
4611: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4612: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4613: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
4614: l_new_transaction_row ic_tran_pnd%ROWTYPE;
4615: l_trans_id ic_tran_pnd.trans_id%TYPE;

Line 4612: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

4608: x_msg_count OUT NOCOPY NUMBER,
4609: x_msg_data OUT NOCOPY VARCHAR2)
4610: IS
4611: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4612: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4613: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
4614: l_new_transaction_row ic_tran_pnd%ROWTYPE;
4615: l_trans_id ic_tran_pnd.trans_id%TYPE;
4616: l_new_trans_id ic_tran_pnd.trans_id%TYPE;

Line 4755: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

4751: l_new_transaction_rec.trans_qty2 := 0;
4752: l_new_transaction_rec.line_id := p_new_source_line_id;
4753:
4754: GMI_RESERVATION_UTIL.PrintLn('creating the default trans for the new line');
4755: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
4756: ( p_api_version => 1
4757: , p_init_msg_list => FND_API.G_FALSE
4758: , p_commit => FND_API.G_FALSE
4759: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

4770: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
4771: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4772: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4773: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4774: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4775: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4776: FND_MSG_PUB.Add;
4777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4778: END IF;

Line 4819: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

4815: l_new_transaction_rec.trans_qty2 := -1 * (abs(l_new_transaction_rec.trans_qty2)
4816: - l_qty2_to_fulfil);
4817: l_new_transaction_rec.line_id := p_new_source_line_id;
4818:
4819: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
4820: ( p_api_version => 1
4821: , p_init_msg_list => FND_API.G_FALSE
4822: , p_commit => FND_API.G_FALSE
4823: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

4834: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by Create_Pending_Transaction,
4835: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
4836: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4837: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4838: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4839: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4840: FND_MSG_PUB.Add;
4841:
4842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4939: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

4935: x_msg_data OUT NOCOPY VARCHAR2)
4936:
4937: IS
4938:
4939: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4940: l_old_transaction_row ic_tran_pnd%ROWTYPE;
4941:
4942: -- HW cursor for cntl items
4943: CURSOR get_opm_txn_cntl (p_trans_id NUMBER) IS

Line 5017: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED

5013: l_old_transaction_rec.staged_ind :=1;
5014: -- Make the Bill-To transactions unique so subledger can identify them since
5015: -- there are no records in wsh_delivery_details
5016: l_old_transaction_rec.line_detail_id := -999;
5017: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
5018: (
5019: p_api_version => 1
5020: ,p_init_msg_list => FND_API.G_FALSE
5021: ,p_commit => FND_API.G_FALSE

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

5032: GMI_reservation_Util.PrintLn('(opm_dbg) Error return by UPDATE_PENDING_TO_COMPLETED,
5033: return_status='|| x_return_status||', x_msg_count='|| x_msg_count||'.');
5034: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
5035: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
5036: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
5037: FND_MESSAGE.Set_Token('WHERE','update_opm_trxns');
5038: FND_MSG_PUB.Add;
5039: x_return_status := FND_API.G_RET_STS_ERROR;
5040: RETURN;