[Home] [Help]
196: -- PROCEDURE
197: -- Process_ResCost
198: --
199: -- DESCRIPTION
200: -- This API processes all resources transactions in WIP_TRANSACTIONS for a
201: -- specified group id. For each transaction, it identifies the correct
202: -- eAM cost element, department type, then populate eAM tables accordingly.
203: -- The calling program should ensure that all transactions for a
204: -- specific group id are costed successfully before calling this API.
257: wt.operation_seq_num,
258: wt.resource_seq_num,
259: wt.charge_department_id,
260: to_char(wt.transaction_date,'YYYY/MM/DD HH24:MI:SS') txn_date
261: FROM wip_transactions wt
262: WHERE wt.group_id = p_group_id
263: AND EXISTS
264: (SELECT 'eam jobs'
265: FROM wip_entities we
7331: ----------------------------------------------------------------------------
7332: -- PROCEDURE --
7333: -- insert_direct_item_txn --
7334: -- DESCRIPTION --
7335: -- insert a transaction record into wip_transactions --
7336: -- * new transaction type called Direct Shopfloor Delivery --
7337: -- * called by cost_direct_item_txn --
7338: -- PURPOSE: --
7339: -- procedure that inserts a transaction into wip_transactions and --
7335: -- insert a transaction record into wip_transactions --
7336: -- * new transaction type called Direct Shopfloor Delivery --
7337: -- * called by cost_direct_item_txn --
7338: -- PURPOSE: --
7339: -- procedure that inserts a transaction into wip_transactions and --
7340: -- deletes the record from wip_cost_txn_interface --
7341: -- HISTORY: --
7342: -- 05/01/01 Anitha Dixit Created --
7343: ----------------------------------------------------------------------------
7394: -- Initialize API return status to success
7395: x_return_status := FND_API.G_RET_STS_SUCCESS;
7396:
7397:
7398: -- Insert into Wip_transactions
7399: l_stmt_num := 20;
7400: if (l_debug = 'Y') then
7401: fnd_file.put_line(fnd_file.log,'Insert into WT');
7402: end if;
7402: end if;
7403:
7404: /* Insert Currency_Actual_Resource_Rate also - Bug 2719622 */
7405:
7406: insert into wip_transactions (
7407: transaction_id,
7408: last_update_date,
7409: last_updated_by,
7410: creation_date,
8652: nvl(wt.rcv_transaction_id, -1)
8653: into l_po_header_id,
8654: l_po_line_id,
8655: l_rcv_txn_id
8656: from wip_transactions wt
8657: where wt.transaction_id = p_txn_id;
8658: exception
8659: when no_data_found then
8660: l_api_message := 'Transaction ID does not exist in WIP_TRANSACTIONS table. ';
8656: from wip_transactions wt
8657: where wt.transaction_id = p_txn_id;
8658: exception
8659: when no_data_found then
8660: l_api_message := 'Transaction ID does not exist in WIP_TRANSACTIONS table. ';
8661: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8662: FND_MESSAGE.set_token('TEXT', l_api_message);
8663: FND_MSG_PUB.add;
8664: RAISE fnd_api.g_exc_error;
8912: select nvl(wt.po_header_id, -1),
8913: nvl(wt.po_line_id, -1)
8914: into l_po_header_id,
8915: l_po_line_id
8916: from wip_transactions wt
8917: where wt.transaction_id = p_txn_id;
8918: exception
8919: when no_data_found then
8920: l_api_message := 'Transaction ID does not exist in WIP_TRANSACTIONS table.';
8916: from wip_transactions wt
8917: where wt.transaction_id = p_txn_id;
8918: exception
8919: when no_data_found then
8920: l_api_message := 'Transaction ID does not exist in WIP_TRANSACTIONS table.';
8921: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8922: FND_MESSAGE.set_token('TEXT', l_api_message);
8923: FND_MSG_PUB.add;
8924: RAISE fnd_api.g_exc_error;
8934: from po_headers_all pha
8935: where pha.po_header_id = l_po_header_id;
8936: else
8937: l_api_message := 'No po_header_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8938: l_api_message := l_api_message || ' wip_transactions ';
8939: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8940: FND_MESSAGE.set_token('TEXT', l_api_message);
8941: FND_MSG_pub.add;
8942: RAISE FND_API.g_exc_error;
8952: from po_lines_all pla
8953: where pla.po_line_id = l_po_line_id;
8954: else
8955: l_api_message := 'No po_line_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8956: l_api_message := l_api_message || ' wip_transactions ';
8957: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8958: FND_MESSAGE.set_token('TEXT', l_api_message);
8959: FND_MSG_pub.add;
8960: RAISE FND_API.g_exc_error;