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.39 2010/09/22 01:04:05 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.39 2010/09/22 01:04:05 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 2937: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,

2933: PROCEDURE book_prodtxn
2934: (
2935: x_return_status OUT NOCOPY VARCHAR2,
2936: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
2937: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
2938: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
2939:
2940: ) IS
2941:

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

2938: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
2939:
2940: ) IS
2941:
2942: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.book_prodtxn';
2943: l_return_status VARCHAR2(1);
2944: l_order_line_id NUMBER;
2945: l_booked_flag VARCHAR2(1);
2946: l_ship_from_org_id NUMBER;

Line 3282: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,

3278: PROCEDURE pickrelease_prodtxn
3279: (
3280: x_return_status OUT NOCOPY VARCHAR2,
3281: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
3282: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
3283: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
3284: ) IS
3285: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.pickrelease_prodtxn';
3286: l_ship_from_org_id NUMBER;

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

3281: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
3282: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
3283: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
3284: ) IS
3285: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.pickrelease_prodtxn';
3286: l_ship_from_org_id NUMBER;
3287: l_picking_rule_id NUMBER;
3288: l_released_status wsh_delivery_details.released_status%TYPE;
3289: l_order_header_id NUMBER;

Line 3299: l_ItemAttributes Csd_Logistics_Util.ItemAttributes_Rec_Type;

3295:
3296: l_eligible_lines_pick_release NUMBER; /*Bug#4992402 */
3297:
3298: /* R12 SN reservations integration change Begin */
3299: l_ItemAttributes Csd_Logistics_Util.ItemAttributes_Rec_Type;
3300: l_auto_reserve_profile VARCHAR2(10);
3301: l_srl_reservation_id NUMBER;
3302: l_serial_rsv_rec CSD_SERIAL_RESERVE_REC_TYPE ;
3303: l_order_line_id NUMBER;

Line 3682: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,

3678: PROCEDURE ship_prodtxn
3679: (
3680: x_return_status OUT NOCOPY VARCHAR2,
3681: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
3682: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
3683: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
3684: ) IS
3685: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.ship_prodtxn';
3686: l_ship_from_org_id NUMBER;

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

3681: p_product_txn_rec IN Csd_Process_Pvt.PRODUCT_TXN_REC,
3682: p_prodtxn_db_attr IN Csd_Logistics_Util.PRODTXN_DB_ATTR_REC,
3683: px_order_rec IN OUT NOCOPY Csd_Process_Pvt.om_interface_rec
3684: ) IS
3685: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.ship_prodtxn';
3686: l_ship_from_org_id NUMBER;
3687: l_picking_rule_id NUMBER;
3688: l_released_status wsh_delivery_details.released_status%TYPE;
3689: l_return_status VARCHAR2(1);

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

3942: ) IS
3943:
3944: l_api_name CONSTANT VARCHAR2(30) := 'CANCEL_PRODTXN';
3945: l_api_version CONSTANT NUMBER := 1.0;
3946: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.cancel_prodtxn';
3947: l_org_id NUMBER;
3948:
3949: CURSOR C_cancel_reason IS
3950: SELECT lookup_code

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

3969:
3970: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
3971: THEN
3972: Fnd_Log.STRING(Fnd_Log.level_procedure,
3973: 'csd.plsql.csd_logistics_util.cancel_prodtxn.begin',
3974: 'Entering cancel_prodtxn');
3975: --dbms_output.put_line('Entering');
3976: END IF;
3977:

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

4073:
4074: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
4075: THEN
4076: Fnd_Log.STRING(Fnd_Log.level_procedure,
4077: 'csd.plsql.csd_logistics_util.cancel_prodtxn.end',
4078: 'cancel_prodtxn completed');
4079: END IF;
4080:
4081: -- Standard call to get message count and IF count is get message info.

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

4099:
4100: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
4101: THEN
4102: Fnd_Log.STRING(Fnd_Log.level_error,
4103: 'csd.plsql.csd_logistics_util.cancel_prodtxn',
4104: 'EXC_ERROR[' || x_msg_data || ']');
4105: END IF;
4106: --dbms_output.put_line('exec error raised');
4107: WHEN Fnd_Api.g_exc_unexpected_error THEN

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

4116:
4117: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4118: THEN
4119: Fnd_Log.STRING(Fnd_Log.level_exception,
4120: 'csd.plsql.csd_logistics_util.cancel_prodtxn',
4121: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
4122: END IF;
4123: --dbms_output.put_line('unexpected error raised');
4124: WHEN OTHERS THEN

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

4139:
4140: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4141: THEN
4142: Fnd_Log.STRING(Fnd_Log.level_exception,
4143: 'csd.plsql.csd_logistics_util.cancel_prodtxn',
4144: 'SQL MEssage[' || SQLERRM || ']');
4145: END IF;
4146: --dbms_output.put_line('other exception raised');
4147: --dbms_output.put_line('sqlerrm'||SQLERRM);

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

4506:
4507: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
4508: THEN
4509: Fnd_Log.STRING(Fnd_Log.level_error,
4510: 'csd.plsql.csd_logistics_util.reserve_serial_number',
4511: 'EXC_ERROR[' || l_msg_data || ']');
4512: END IF;
4513: --dbms_output.put_line('exec error raised');
4514: WHEN Fnd_Api.g_exc_unexpected_error THEN

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

4515: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4516: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4517: THEN
4518: Fnd_Log.STRING(Fnd_Log.level_exception,
4519: 'csd.plsql.csd_logistics_util.reserve_serial_number',
4520: 'EXC_UNEXP_ERROR[' || l_msg_data || ']');
4521: END IF;
4522: --dbms_output.put_line('unexpected error raised');
4523: WHEN OTHERS THEN

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

4524: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4525: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
4526: THEN
4527: Fnd_Log.STRING(Fnd_Log.level_exception,
4528: 'csd.plsql.csd_logistics_util.reserve_serial_number',
4529: 'SQL MEssage[' || SQLERRM || ']');
4530: END IF;
4531:
4532:

Line 4671: END Csd_Logistics_Util;

4667:
4668: END Unreserve_Serial_Number;
4669:
4670:
4671: END Csd_Logistics_Util;