[Home] [Help]
5819: -- PROCEDURE --
5820: -- process_direct_item_txn --
5821: -- DESCRIPTION --
5822: -- This is the wrapper function to do direct item costing --
5823: -- * Inserts transaction into wip_cost_txn_interface --
5824: -- PURPOSE: --
5825: -- API to process direct item transaction. Called from the function --
5826: -- process_OSP_transaction in the receiving transaction processor --
5827: -- HISTORY: --
6397: ----------------------------------------------------------------------------
6398: -- PROCEDURE --
6399: -- cost_direct_item_txn --
6400: -- DESCRIPTION --
6401: -- cost a transaction record from wip_cost_txn_interface --
6402: -- * new transaction type called Direct Shopfloor Delivery --
6403: -- * called by cmlctw --
6404: -- * inserts debits and credits into wip_transaction_accounts --
6405: -- * update eam asset cost and asset period balances --
6464: to_char(transaction_date,'YYYY/MM/DD HH24:MI:SS') txn_date,
6465: rcv_transaction_id,
6466: currency_code, /* bug 4683371 */
6467: currency_conversion_rate /* bug 4683371 */
6468: from wip_cost_txn_interface
6469: where group_id = p_group_id
6470: and process_status = 2;
6471:
6472:
6756: l_stmt_num := 140;
6757: if (l_debug = 'Y') then
6758: fnd_file.put_line(fnd_file.log,'Delete from wcti');
6759: end if;
6760: delete from wip_cost_txn_interface
6761: where group_id = p_group_id
6762: and process_status = 2;
6763:
6764: -- Standard check of p_commit
6907: -- Get transaction details
6908: l_stmt_num := 30;
6909: select organization_id, currency_code
6910: into l_org_id,l_currency
6911: from wip_cost_txn_interface
6912: where transaction_id = p_txn_id;
6913:
6914: -- DBMS_OUTPUT.PUT_LINE('Currency ' || l_currency);
6915: -- Get functional currency
7044: p_request_id,
7045: p_prg_appl_id,
7046: p_prg_id,
7047: sysdate
7048: FROM wip_cost_txn_interface wcti
7049: WHERE wcti.transaction_id = p_txn_id;
7050:
7051: -- Standard check of p_commit
7052: IF FND_API.to_Boolean(p_commit) THEN
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: ----------------------------------------------------------------------------
7344: PROCEDURE insert_direct_item_txn (
7485: p_prg_id,
7486: 'N',
7487: wcti.project_id,
7488: wcti.task_id
7489: from wip_cost_txn_interface wcti
7490: where group_id = p_group_id
7491: and process_status = 2;
7492:
7493: -- Standard check of p_commit
7946: wdj.primary_item_id,
7947: wdj.project_id,
7948: wdj.task_id,
7949: wdj.maintenance_object_id
7950: from wip_cost_txn_interface wcti,
7951: wip_discrete_jobs wdj,
7952: wip_entities we,
7953: csi_item_instances cii
7954: where wcti.group_id = p_wcti_group_id
8019:
8020: SELECT DISTINCT COD.currency_code
8021: INTO l_currency_code
8022: FROM cst_organization_definitions COD,
8023: wip_cost_txn_interface WCTI
8024: WHERE WCTI.group_id = p_wcti_group_id
8025: AND WCTI.organization_id = COD.organization_id;
8026:
8027: l_stmt_num := 12;
8633: nvl(wcti.rcv_transaction_id, -1)
8634: into l_po_header_id,
8635: l_po_line_id,
8636: l_rcv_txn_id
8637: from wip_cost_txn_interface wcti
8638: where wcti.transaction_id = p_txn_id;
8639: exception
8640: when no_data_found then
8641: l_api_message := 'Transaction ID does not exist in WIP_COST_TXN_INTERFACE table. ';
8637: from wip_cost_txn_interface wcti
8638: where wcti.transaction_id = p_txn_id;
8639: exception
8640: when no_data_found then
8641: l_api_message := 'Transaction ID does not exist in WIP_COST_TXN_INTERFACE table. ';
8642: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8643: FND_MESSAGE.set_token('TEXT', l_api_message);
8644: FND_MSG_PUB.add;
8645: RAISE fnd_api.g_exc_error;
8678: from po_headers_all pha
8679: where pha.po_header_id = l_po_header_id;
8680: else
8681: l_api_message := 'No po_header_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8682: l_api_message := l_api_message || ' wip_cost_txn_interface ';
8683: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8684: FND_MESSAGE.set_token('TEXT', l_api_message);
8685: FND_MSG_pub.add;
8686: RAISE FND_API.g_exc_error;
8696: from po_lines_all pla
8697: where pla.po_line_id = l_po_line_id;
8698: else
8699: l_api_message := 'No po_line_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8700: l_api_message := l_api_message || ' wip_cost_txn_interface ';
8701: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8702: FND_MESSAGE.set_token('TEXT', l_api_message);
8703: FND_MSG_pub.add;
8704: RAISE FND_API.g_exc_error;
8718: from rcv_transactions
8719: where transaction_id = l_rcv_txn_id;
8720: Else
8721: l_api_message := 'No rcv_transaction_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8722: l_api_message := l_api_message || ' wip_cost_txn_interface ';
8723: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8724: FND_MESSAGE.set_token('TEXT', l_api_message);
8725: FND_MSG_pub.add;
8726: RAISE FND_API.g_exc_error;
8732: from po_releases_all
8733: where po_release_id = l_po_release_id;
8734: Else
8735: l_api_message := 'No po_release_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8736: l_api_message := l_api_message || ' wip_cost_txn_interface ';
8737: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
8738: FND_MESSAGE.set_token('TEXT', l_api_message);
8739: FND_MSG_pub.add;
8740: RAISE FND_API.g_exc_error;