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_LOGISTICS_UTIL dependencies on CSD_LOGISTICS_UTIL

Line 1: PACKAGE BODY Csd_Logistics_Util AS

1: PACKAGE BODY Csd_Logistics_Util AS
2: /* $Header: csdulogb.pls 120.35.12010000.3 2008/11/11 23:20:34 takwong ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_LOGISTICS_UTIL';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdulogs.plb';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_LOGISTICS_UTIL';

1: PACKAGE BODY Csd_Logistics_Util AS
2: /* $Header: csdulogb.pls 120.35.12010000.3 2008/11/11 23:20:34 takwong ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_LOGISTICS_UTIL';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdulogs.plb';
6: g_debug NUMBER := Csd_Gen_Utility_Pvt.g_debug_level;
7:
8: -- Define constants here

Line 1180: l_ItemAttributes Csd_Logistics_Util.ItemAttributes_Rec_Type;

1176: x_return_status OUT NOCOPY VARCHAR2,
1177: x_msg_count OUT NOCOPY NUMBER,
1178: x_msg_data OUT NOCOPY VARCHAR2) IS
1179: -- Define local Variables
1180: l_ItemAttributes Csd_Logistics_Util.ItemAttributes_Rec_Type;
1181: l_api_name CONSTANT VARCHAR2(30) := 'Validate_ProductTrxnRec';
1182: l_Customer_Id NUMBER;
1183: l_Currency_Code VARCHAR2(30);
1184: l_Serial_Number VARCHAR2(30);

Line 2044: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.get_order_rec';

2040: FUNCTION get_order_rec (p_repair_line_id IN NUMBER)
2041: RETURN Csd_Process_Pvt.om_interface_rec
2042: IS
2043: l_incident_id NUMBER;
2044: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.get_order_rec';
2045: x_order_rec Csd_Process_Pvt.om_interface_rec;
2046:
2047: CURSOR cur_order_rec(p_incident_id IN NUMBER) IS
2048: SELECT customer_id, account_id

Line 2101: RETURN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC

2097: /* Desc: Gets the product txn record attributes from database */
2098: /*************************************************************************/
2099:
2100: FUNCTION get_prodtxn_db_attr (p_product_txn_id IN NUMBER)
2101: RETURN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC
2102: IS
2103:
2104: CURSOR prod_txn(p_prod_txn_id IN NUMBER) IS
2105: SELECT estimate_detail_id,

Line 2115: x_prodtxn_db_attr Csd_Logistics_Util.PRODTXN_DB_ATTR_REC;

2111: object_version_number
2112: FROM CSD_PRODUCT_TRANSACTIONS
2113: WHERE product_transaction_id = p_prod_txn_id;
2114:
2115: x_prodtxn_db_attr Csd_Logistics_Util.PRODTXN_DB_ATTR_REC;
2116:
2117:
2118: BEGIN
2119: IF NVL(p_product_txn_id, Fnd_Api.G_MISS_NUM) <> Fnd_Api.G_MISS_NUM

Line 2154: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,

2150: /*------------------------------------------------------------------------*/
2151: PROCEDURE upd_prodtxn_n_chrgline
2152: (
2153: p_product_txn_rec IN OUT NOCOPY Csd_Process_Pvt.PRODUCT_TXN_REC,
2154: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
2155: x_estimate_detail_id OUT NOCOPY NUMBER,
2156: x_repair_line_id OUT NOCOPY NUMBER,
2157: x_add_to_order_flag OUT NOCOPY VARCHAR2,
2158: x_add_to_order_id OUT NOCOPY NUMBER,

Line 2163: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.upd_prodtxn_n_chrgline';

2159: x_transaction_type_id OUT NOCOPY NUMBER
2160: ) IS
2161:
2162:
2163: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.upd_prodtxn_n_chrgline';
2164: C_STATEMENT_LEVEL CONSTANT NUMBER := 4; -- temporarily changed to 4 from 1 since the fnd profile can not be changed.
2165: C_EXCEPTION_LEVEL CONSTANT NUMBER := 4;
2166: l_tmp_char VARCHAR2(1) ;
2167: l_est_detail_id NUMBER;

Line 2611: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,

2607: PROCEDURE interface_prodtxn
2608: (
2609: x_return_status OUT NOCOPY VARCHAR2,
2610: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
2611: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
2612: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
2613: ) IS
2614:
2615:

Line 2627: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.interface_prodtxn';

2623: l_msg_data VARCHAR2(2000);
2624: l_dummy VARCHAR2(1);
2625: l_rev_ctl_code NUMBER;
2626:
2627: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.interface_prodtxn';
2628:
2629: l_order_line_id NUMBER;
2630: l_sr_account_id NUMBER; -- swai: bug 6001057
2631:

Line 2930: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,

2926: PROCEDURE book_prodtxn
2927: (
2928: x_return_status OUT NOCOPY VARCHAR2,
2929: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
2930: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
2931: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
2932:
2933: ) IS
2934:

Line 2935: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.book_prodtxn';

2931: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
2932:
2933: ) IS
2934:
2935: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.book_prodtxn';
2936: l_return_status VARCHAR2(1);
2937: l_order_line_id NUMBER;
2938: l_booked_flag VARCHAR2(1);
2939: l_ship_from_org_id NUMBER;

Line 3268: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,

3264: PROCEDURE pickrelease_prodtxn
3265: (
3266: x_return_status OUT NOCOPY VARCHAR2,
3267: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
3268: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
3269: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
3270: ) IS
3271: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.pickrelease_prodtxn';
3272: l_ship_from_org_id NUMBER;

Line 3271: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.pickrelease_prodtxn';

3267: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
3268: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
3269: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
3270: ) IS
3271: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.pickrelease_prodtxn';
3272: l_ship_from_org_id NUMBER;
3273: l_picking_rule_id NUMBER;
3274: l_released_status wsh_delivery_details.released_status%TYPE;
3275: l_order_header_id NUMBER;

Line 3285: l_ItemAttributes Csd_Logistics_Util.ItemAttributes_Rec_Type;

3281:
3282: l_eligible_lines_pick_release NUMBER; /*Bug#4992402 */
3283:
3284: /* R12 SN reservations integration change Begin */
3285: l_ItemAttributes Csd_Logistics_Util.ItemAttributes_Rec_Type;
3286: l_auto_reserve_profile VARCHAR2(10);
3287: l_srl_reservation_id NUMBER;
3288: l_serial_rsv_rec CSD_SERIAL_RESERVE_REC_TYPE ;
3289: l_order_line_id NUMBER;

Line 3668: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,

3664: PROCEDURE ship_prodtxn
3665: (
3666: x_return_status OUT NOCOPY VARCHAR2,
3667: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
3668: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
3669: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
3670: ) IS
3671: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.ship_prodtxn';
3672: l_ship_from_org_id NUMBER;

Line 3671: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.ship_prodtxn';

3667: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
3668: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
3669: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
3670: ) IS
3671: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.ship_prodtxn';
3672: l_ship_from_org_id NUMBER;
3673: l_picking_rule_id NUMBER;
3674: l_released_status wsh_delivery_details.released_status%TYPE;
3675: l_return_status VARCHAR2(1);

Line 3932: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.cancel_prodtxn';

3928: ) IS
3929:
3930: l_api_name CONSTANT VARCHAR2(30) := 'CANCEL_PRODTXN';
3931: l_api_version CONSTANT NUMBER := 1.0;
3932: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.cancel_prodtxn';
3933: l_org_id NUMBER;
3934:
3935: CURSOR C_cancel_reason IS
3936: SELECT lookup_code

Line 3959: 'csd.plsql.csd_logistics_util.cancel_prodtxn.begin',

3955:
3956: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
3957: THEN
3958: Fnd_Log.STRING(Fnd_Log.level_procedure,
3959: 'csd.plsql.csd_logistics_util.cancel_prodtxn.begin',
3960: 'Entering cancel_prodtxn');
3961: --dbms_output.put_line('Entering');
3962: END IF;
3963:

Line 4063: 'csd.plsql.csd_logistics_util.cancel_prodtxn.end',

4059:
4060: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
4061: THEN
4062: Fnd_Log.STRING(Fnd_Log.level_procedure,
4063: 'csd.plsql.csd_logistics_util.cancel_prodtxn.end',
4064: 'cancel_prodtxn completed');
4065: END IF;
4066:
4067: -- Standard call to get message count and IF count is get message info.

Line 4089: 'csd.plsql.csd_logistics_util.cancel_prodtxn',

4085:
4086: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
4087: THEN
4088: Fnd_Log.STRING(Fnd_Log.level_error,
4089: 'csd.plsql.csd_logistics_util.cancel_prodtxn',
4090: 'EXC_ERROR[' || x_msg_data || ']');
4091: END IF;
4092: --dbms_output.put_line('exec error raised');
4093: WHEN Fnd_Api.g_exc_unexpected_error THEN

Line 4106: 'csd.plsql.csd_logistics_util.cancel_prodtxn',

4102:
4103: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4104: THEN
4105: Fnd_Log.STRING(Fnd_Log.level_exception,
4106: 'csd.plsql.csd_logistics_util.cancel_prodtxn',
4107: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
4108: END IF;
4109: --dbms_output.put_line('unexpected error raised');
4110: WHEN OTHERS THEN

Line 4129: 'csd.plsql.csd_logistics_util.cancel_prodtxn',

4125:
4126: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4127: THEN
4128: Fnd_Log.STRING(Fnd_Log.level_exception,
4129: 'csd.plsql.csd_logistics_util.cancel_prodtxn',
4130: 'SQL MEssage[' || SQLERRM || ']');
4131: END IF;
4132: --dbms_output.put_line('other exception raised');
4133: --dbms_output.put_line('sqlerrm'||SQLERRM);

Line 4496: 'csd.plsql.csd_logistics_util.reserve_serial_number',

4492:
4493: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
4494: THEN
4495: Fnd_Log.STRING(Fnd_Log.level_error,
4496: 'csd.plsql.csd_logistics_util.reserve_serial_number',
4497: 'EXC_ERROR[' || l_msg_data || ']');
4498: END IF;
4499: --dbms_output.put_line('exec error raised');
4500: WHEN Fnd_Api.g_exc_unexpected_error THEN

Line 4505: 'csd.plsql.csd_logistics_util.reserve_serial_number',

4501: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4502: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4503: THEN
4504: Fnd_Log.STRING(Fnd_Log.level_exception,
4505: 'csd.plsql.csd_logistics_util.reserve_serial_number',
4506: 'EXC_UNEXP_ERROR[' || l_msg_data || ']');
4507: END IF;
4508: --dbms_output.put_line('unexpected error raised');
4509: WHEN OTHERS THEN

Line 4514: 'csd.plsql.csd_logistics_util.reserve_serial_number',

4510: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4511: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4512: THEN
4513: Fnd_Log.STRING(Fnd_Log.level_exception,
4514: 'csd.plsql.csd_logistics_util.reserve_serial_number',
4515: 'SQL MEssage[' || SQLERRM || ']');
4516: END IF;
4517:
4518:

Line 4657: END Csd_Logistics_Util;

4653:
4654: END Unreserve_Serial_Number;
4655:
4656:
4657: END Csd_Logistics_Util;