DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_CST_TXN_COST_DETAILS_PKG

Line 3133: print_debug('Calling MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row', 9);

3129: -- inv_mmt_insert returns success
3130: -- Loop through the records of pl/sql table, if transaction cost is not null,
3131: -- call costing API to insert into MTL_CST_TXN_COST_DETAILS
3132: IF (l_debug = 1) THEN
3133: print_debug('Calling MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row', 9);
3134: END IF;
3135:
3136: IF (p_logical_trx_type_code = G_LOGTRXCODE_RETROPRICEUPD) THEN
3137: l_progress := 440;

Line 3170: MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row(

3166:
3167: IF l_process_enabled_flag = 'N'
3168: THEN
3169:
3170: MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row(
3171: X_Rowid => l_row_id
3172: , X_Transaction_Id => l_mtl_trx_tbl(i).transaction_id
3173: , X_Organization_Id => l_mtl_trx_tbl(i).organization_id
3174: , X_Cost_Element_Id => 1

Line 3185: print_debug('MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row returns error', 9);

3181: , X_Transaction_Cost => l_mtl_trx_tbl(i).old_po_price
3182: , X_Value_Change => l_mtl_trx_tbl(i).old_po_price-l_mtl_trx_tbl(i).new_po_price);
3183: IF (l_row_id is null or l_row_id < 0) THEN
3184: IF (l_debug = 1) THEN
3185: print_debug('MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row returns error', 9);
3186: print_debug('l_row_id = ' || l_row_id, 9);
3187: END IF;
3188: FND_MESSAGE.SET_NAME('INV', 'INV_INSERT_COST_ERR');
3189: FND_MSG_PUB.ADD;

Line 3252: MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row(

3248: */
3249:
3250: print_debug('X_Transaction_Cost in primary uom = ' || l_mtl_trx_tbl(i).transaction_cost, 9);
3251:
3252: MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row(
3253: X_Rowid => l_row_id
3254: , X_Transaction_Id => l_mtl_trx_tbl(i).transaction_id
3255: , X_Organization_Id => l_mtl_trx_tbl(i).organization_id
3256: , X_Cost_Element_Id => 1

Line 3267: print_debug('MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row returns error', 9);

3263: , X_Transaction_Cost => l_mtl_trx_tbl(i).transaction_cost
3264: , X_Value_Change => null);
3265: IF (l_row_id is null or l_row_id < 0) THEN
3266: IF (l_debug = 1) THEN
3267: print_debug('MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row returns error', 9);
3268: print_debug('l_row_id = ' || l_row_id, 9);
3269: END IF;
3270: FND_MESSAGE.SET_NAME('INV', 'INV_INSERT_COST_ERR');
3271: FND_MSG_PUB.ADD;

Line 3275: print_debug('MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row returns success', 9);

3271: FND_MSG_PUB.ADD;
3272: RAISE FND_API.G_EXC_ERROR;
3273: ELSE
3274: IF (l_debug = 1) THEN
3275: print_debug('MTL_CST_TXN_COST_DETAILS_PKG.Insert_Row returns success', 9);
3276: END IF;
3277: END IF;
3278: END IF;
3279: END LOOP;