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.CSD_PROCESS_PVT dependencies on CSD_PRODUCT_TRANSACTIONS

Line 2946: Debug('Call csd_product_transactions_pkg.insert_row to insert prod txns',

2942:
2943: Debug('NEW ESTIMATE DETAIL ID =' || x_estimate_detail_id,
2944: l_mod_name,
2945: 1);
2946: Debug('Call csd_product_transactions_pkg.insert_row to insert prod txns',
2947: l_mod_name,
2948: 1);
2949:
2950: -- Note (TTRV) at this point I would like to derive values for the new columns, every column is not

Line 2956: Csd_Product_Transactions_Pkg.INSERT_ROW(px_PRODUCT_TRANSACTION_ID => x_product_txn_rec.PRODUCT_TRANSACTION_ID,

2952: -- they need not be filled at the time of creation of product transaction record. Some of the columns
2953: -- are updated by update programs.
2954: -- Please come back and verify that for repair types, Exchange, Advance Exchange, Replacement
2955: -- non-source columns are picked from UI. These comments are added by saupadhy TTRV
2956: Csd_Product_Transactions_Pkg.INSERT_ROW(px_PRODUCT_TRANSACTION_ID => x_product_txn_rec.PRODUCT_TRANSACTION_ID,
2957: p_REPAIR_LINE_ID => x_product_txn_rec.REPAIR_LINE_ID,
2958: p_ESTIMATE_DETAIL_ID => x_estimate_detail_id,
2959: p_ACTION_TYPE => x_product_txn_rec.ACTION_TYPE,
2960: p_ACTION_CODE => x_product_txn_rec.ACTION_CODE,

Line 3131: UPDATE csd_product_transactions

3127: Debug('process_sales_order failed', l_mod_name, 1);
3128: RAISE CREATE_ORDER;
3129: END IF;
3130:
3131: UPDATE csd_product_transactions
3132: SET prod_txn_status = 'SUBMITTED',
3133: interface_to_om_flag = 'Y'
3134: WHERE product_transaction_id =
3135: x_product_txn_rec.PRODUCT_TRANSACTION_ID;

Line 3469: -- UPDATE csd_product_transactions

3465: END IF;
3466: END IF;
3467:
3468: -- -- Update product txn with the status
3469: -- UPDATE csd_product_transactions
3470: -- SET prod_txn_status = 'BOOKED',
3471: -- book_sales_order_flag = 'Y'
3472: -- WHERE product_transaction_id = x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3473: -- IF SQL%NOTFOUND then

Line 3723: UPDATE csd_product_transactions

3719: -- swai: bug 5931926 - 12.0.2 added 3rd party action type
3720: IF (x_product_txn_rec.ACTION_TYPE IN
3721: ('SHIP', 'WALK_IN_ISSUE', 'SHIP_THIRD_PTY'))
3722: THEN
3723: UPDATE csd_product_transactions
3724: SET prod_txn_status = 'RELEASED',
3725: release_sales_order_flag = 'Y'
3726: WHERE product_transaction_id =
3727: x_product_txn_rec.PRODUCT_TRANSACTION_ID;

Line 3759: UPDATE csd_product_transactions

3755: -- swai: bug 5931926 - 12.0.2 added 3rd party action type
3756: IF (x_product_txn_rec.ACTION_TYPE IN
3757: ('SHIP', 'WALK_IN_ISSUE', 'SHIP_THIRD_PTY'))
3758: THEN
3759: UPDATE csd_product_transactions
3760: SET prod_txn_status = 'BOOKED'
3761: WHERE product_transaction_id =
3762: x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3763: IF SQL%NOTFOUND

Line 3864: UPDATE csd_product_transactions

3860: -- swai: bug 5931926 - 12.0.2 added 3rd party action type
3861: IF (x_product_txn_rec.ACTION_TYPE IN
3862: ('SHIP', 'WALK_IN_ISSUE', 'SHIP_THIRD_PTY'))
3863: THEN
3864: UPDATE csd_product_transactions
3865: SET prod_txn_status = 'SHIPPED',
3866: ship_sales_order_flag = 'Y'
3867: WHERE product_transaction_id =
3868: x_product_txn_rec.PRODUCT_TRANSACTION_ID;

Line 3925: UPDATE csd_product_transactions

3921: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3922: ROLLBACK TO create_sales_order;
3923: -- update the prod txn as the charge
3924: -- line was not interfaced
3925: UPDATE csd_product_transactions
3926: SET interface_to_om_flag = 'N',
3927: book_sales_order_flag = 'N',
3928: release_sales_order_flag = 'N',
3929: ship_sales_order_flag = 'N'

Line 3948: UPDATE csd_product_transactions

3944: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3945: ROLLBACK TO book_sales_order;
3946: -- update the prod txn as the order
3947: -- line was not booked
3948: UPDATE csd_product_transactions
3949: SET book_sales_order_flag = 'N',
3950: release_sales_order_flag = 'N',
3951: ship_sales_order_flag = 'N'
3952: WHERE product_transaction_id =

Line 3970: UPDATE csd_product_transactions

3966: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3967: ROLLBACK TO release_sales_order;
3968: -- update the prod txn as the order
3969: -- line was not booked
3970: UPDATE csd_product_transactions
3971: SET release_sales_order_flag = 'N',
3972: ship_sales_order_flag = 'N'
3973: WHERE product_transaction_id =
3974: x_product_txn_rec.PRODUCT_TRANSACTION_ID;

Line 3982: UPDATE csd_product_transactions

3978: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3979: ROLLBACK TO ship_sales_order;
3980: -- update the prod txn as the order
3981: -- line was not booked
3982: UPDATE csd_product_transactions
3983: SET ship_sales_order_flag = 'N'
3984: WHERE product_transaction_id =
3985: x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3986: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

Line 4445: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.insert_row to insert prod txns');

4441: x_product_txn_rec.currency_code := l_curr_code;
4442: x_product_txn_rec.line_category_code := l_line_category_code;
4443: x_estimate_detail_id := x_product_txn_rec.estimate_detail_id;
4444:
4445: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.insert_row to insert prod txns');
4446:
4447: Csd_Product_Transactions_Pkg.INSERT_ROW(px_PRODUCT_TRANSACTION_ID => x_product_txn_rec.PRODUCT_TRANSACTION_ID,
4448: p_REPAIR_LINE_ID => x_product_txn_rec.REPAIR_LINE_ID,
4449: p_ESTIMATE_DETAIL_ID => x_estimate_detail_id,

Line 4447: Csd_Product_Transactions_Pkg.INSERT_ROW(px_PRODUCT_TRANSACTION_ID => x_product_txn_rec.PRODUCT_TRANSACTION_ID,

4443: x_estimate_detail_id := x_product_txn_rec.estimate_detail_id;
4444:
4445: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.insert_row to insert prod txns');
4446:
4447: Csd_Product_Transactions_Pkg.INSERT_ROW(px_PRODUCT_TRANSACTION_ID => x_product_txn_rec.PRODUCT_TRANSACTION_ID,
4448: p_REPAIR_LINE_ID => x_product_txn_rec.REPAIR_LINE_ID,
4449: p_ESTIMATE_DETAIL_ID => x_estimate_detail_id,
4450: p_ACTION_TYPE => x_product_txn_rec.ACTION_TYPE,
4451: p_ACTION_CODE => x_product_txn_rec.ACTION_CODE,

Line 4791: UPDATE csd_product_transactions

4787: ROLLBACK TO UPDATE_PRODUCT_TXN_PVT;
4788:
4789: -- update the prod txn as the charge
4790: -- line was not interfaced
4791: UPDATE csd_product_transactions
4792: SET interface_to_om_flag = 'N',
4793: book_sales_order_flag = 'N',
4794: release_sales_order_flag = 'N',
4795: ship_sales_order_flag = 'N'

Line 4805: UPDATE csd_product_transactions

4801: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4802: ROLLBACK TO book_sales_order;
4803: -- update the prod txn as the order
4804: -- line was not booked
4805: UPDATE csd_product_transactions
4806: SET book_sales_order_flag = 'N',
4807: release_sales_order_flag = 'N',
4808: ship_sales_order_flag = 'N'
4809: WHERE product_transaction_id =

Line 4818: UPDATE csd_product_transactions

4814: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4815: ROLLBACK TO release_sales_order;
4816: -- update the prod txn as the order
4817: -- line was not booked
4818: UPDATE csd_product_transactions
4819: SET release_sales_order_flag = 'N',
4820: ship_sales_order_flag = 'N'
4821: WHERE product_transaction_id =
4822: x_product_txn_rec.PRODUCT_TRANSACTION_ID;

Line 4830: UPDATE csd_product_transactions

4826: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4827: ROLLBACK TO ship_sales_order;
4828: -- update the prod txn as the order
4829: -- line was not booked
4830: UPDATE csd_product_transactions
4831: SET ship_sales_order_flag = 'N'
4832: WHERE product_transaction_id =
4833: x_product_txn_rec.PRODUCT_TRANSACTION_ID;
4834: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

Line 4972: FROM csd_product_transactions a, cs_estimate_details b

4968: -- only if it is not interfaced
4969: BEGIN
4970: SELECT a.estimate_detail_id
4971: INTO l_est_detail_id
4972: FROM csd_product_transactions a, cs_estimate_details b
4973: WHERE a.estimate_detail_id = b.estimate_detail_id
4974: AND a.product_transaction_id = p_product_txn_id
4975: AND b.order_header_id IS NULL;
4976:

Line 5030: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.Delete_Row');

5026: END IF;
5027:
5028: IF (g_debug > 0)
5029: THEN
5030: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.Delete_Row');
5031: END IF;
5032:
5033: Csd_Product_Transactions_Pkg.Delete_Row(p_PRODUCT_TRANSACTION_ID => p_product_txn_id);
5034: END IF; --end of delete

Line 5033: Csd_Product_Transactions_Pkg.Delete_Row(p_PRODUCT_TRANSACTION_ID => p_product_txn_id);

5029: THEN
5030: Csd_Gen_Utility_Pvt.ADD('Call csd_product_transactions_pkg.Delete_Row');
5031: END IF;
5032:
5033: Csd_Product_Transactions_Pkg.Delete_Row(p_PRODUCT_TRANSACTION_ID => p_product_txn_id);
5034: END IF; --end of delete
5035:
5036: -- Api body ends here
5037:

Line 8125: FROM csd_product_transactions

8121: book_sales_order_flag,
8122: release_sales_order_flag,
8123: ship_sales_order_flag,
8124: object_version_number
8125: FROM csd_product_transactions
8126: WHERE product_transaction_id = p_prod_txn_id;
8127:
8128: CURSOR released_lines_cur(p_order_header_id IN NUMBER, p_Order_Line_id IN NUMBER) IS
8129: SELECT source_header_id, source_line_id, released_status

Line 8298: -- validate the prod_txn_id if it exists in csd_product_transactions

8294: l_module_name || '.check_in_parameters',
8295: 'product txn id is valid');
8296: END IF;
8297:
8298: -- validate the prod_txn_id if it exists in csd_product_transactions
8299: IF NOT
8300: (Csd_Process_Util.validate_prod_txn_id(p_prod_txn_id => x_product_txn_rec.product_transaction_id))
8301: THEN
8302: IF l_exception_level >= l_debug_level

Line 8643: UPDATE csd_product_transactions

8639: FOR released_line_rec IN released_lines_cur(x_product_txn_rec.order_header_id,
8640: x_product_txn_rec.order_line_id)
8641: LOOP
8642: -- update product transaction tables
8643: UPDATE csd_product_transactions
8644: SET prod_txn_status = C_Status_Released,
8645: release_sales_order_flag = C_Yes,
8646: object_version_number = Object_Version_Number + 1,
8647: Last_Update_Date = SYSDATE,

Line 8830: UPDATE csd_product_transactions

8826: FOR Shipped_line_rec IN Shipped_lines_cur(x_product_txn_rec.order_header_id,
8827: x_product_txn_rec.Order_line_id)
8828: LOOP
8829: -- update product transaction tables
8830: UPDATE csd_product_transactions
8831: SET -- prod_txn_status = C_Status_Shipped ,
8832: release_sales_order_flag = C_Yes,
8833: ship_sales_order_flag = C_Yes,
8834: object_version_number = Object_Version_Number + 1,

Line 9007: FROM csd_product_Transactions cpt, cs_estimate_Details ced

9003: SELECT cpt.product_Transaction_Id,
9004: ced.Estimate_Detail_Id,
9005: ced.order_header_Id,
9006: ced.order_Line_Id
9007: FROM csd_product_Transactions cpt, cs_estimate_Details ced
9008: WHERE cpt.repair_line_id = p_Repair_Line_Id
9009: AND cpt.estimate_detail_id = ced.estimate_detail_id;
9010: BEGIN
9011: -- Standard call to check for call compatibility.

Line 9148: FROM csd_product_Transactions

9144: -- CHeck if there are any product txn lines for a given repair line id
9145: BEGIN
9146: SELECT COUNT(Product_Transaction_Id)
9147: INTO l_Prod_Txn_Lines_Count
9148: FROM csd_product_Transactions
9149: WHERE Repair_Line_id = p_Repair_Line_Id;
9150: IF l_Prod_Txn_Lines_Count > 0
9151: THEN
9152: -- Default product transaction lines are not created as product transaction lines exist