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_UTIL dependencies on CSD_PROCESS_UTIL

Line 1: PACKAGE BODY CSD_PROCESS_UTIL as

1: PACKAGE BODY CSD_PROCESS_UTIL as
2: /* $Header: csdvutlb.pls 120.48.12020000.6 2013/03/15 00:42:19 takwong ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_PROCESS_UTIL';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvutlb.pls';

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

1: PACKAGE BODY CSD_PROCESS_UTIL as
2: /* $Header: csdvutlb.pls 120.48.12020000.6 2013/03/15 00:42:19 takwong ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_PROCESS_UTIL';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvutlb.pls';
6: g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
7: -- bug#7355526, nnadig.
8: -- cache for maintaining the inventory parameters for negative inventory.

Line 553: -- Called from : WVI trigger of rcv_ship.TRANSACTION_TYPE and CSD_PROCESS_UTIL.build_prodtxn_tbl_int

549: -- activity (Transaction_type_id).
550: -- If transaction_type_id is not passed to this API then it derive the transaction_type_id
551: -- using parameter p_txn_billing_type_id and then it derive the correct txn_billing_type_id
552: -- for transaction.
553: -- Called from : WVI trigger of rcv_ship.TRANSACTION_TYPE and CSD_PROCESS_UTIL.build_prodtxn_tbl_int
554: -- Input Parm : p_api_version NUMBER Api Version number
555: -- p_init_msg_list VARCHAR2 Initializes message stack if fnd_api.g_true,
556: -- default value is fnd_api.g_false
557: -- p_incident_id NUMBER incident id of service request

Line 640: IF csd_process_util.is_multiorg_enabled THEN

636:
637: l_org_id := cs_std.get_item_valdn_orgzn_id;
638:
639: /*Derive the operating unit */
640: IF csd_process_util.is_multiorg_enabled THEN
641: CS_MultiOrg_Pub.Get_OrgId(
642: P_API_VERSION => 1.0,
643: P_INIT_MSG_LIST => 'F',
644: P_COMMIT => 'F',

Line 652: IF (x_return_status <> CSD_PROCESS_UTIL.G_RET_STS_SUCCESS) THEN

648: X_MSG_COUNT => x_msg_count,
649: X_MSG_DATA => x_msg_data,
650: X_ORG_ID => l_operating_unit,
651: X_PROFILE => l_profile);
652: IF (x_return_status <> CSD_PROCESS_UTIL.G_RET_STS_SUCCESS) THEN
653: csd_gen_utility_pvt.ADD('Error in Deriving the Operating Unit ');
654: END IF;
655: ELSE
656: Fnd_Profile.Get('ORG_ID',l_operating_unit);

Line 809: l_pricing_rec csd_process_util.pricing_attr_rec := csd_process_util.ui_pricing_attr_rec;

805: l_currency_code varchar(15);
806: l_return_status VARCHAR2(1);
807: l_msg_count NUMBER;
808: l_msg_data VARCHAR2(2000);
809: l_pricing_rec csd_process_util.pricing_attr_rec := csd_process_util.ui_pricing_attr_rec;
810: l_enable_advanced_pricing VARCHAR2(1);
811:
812:
813: /*Bug#5190905 added below variables*/

Line 1214: l_org_id := csd_process_util.get_org_id(l_incident_id);

1210: csd_gen_utility_pvt.add('l_lr_txn_billing_type_id ='||l_lr_txn_billing_type_id );
1211: END IF;
1212:
1213:
1214: l_org_id := csd_process_util.get_org_id(l_incident_id);
1215: -- Inv_org Change, Vijay , 20/3/2006
1216: -- taken from the repair_order record.
1217: --l_inv_org_id := csd_process_util.get_inv_org_id;
1218:

Line 1217: --l_inv_org_id := csd_process_util.get_inv_org_id;

1213:
1214: l_org_id := csd_process_util.get_org_id(l_incident_id);
1215: -- Inv_org Change, Vijay , 20/3/2006
1216: -- taken from the repair_order record.
1217: --l_inv_org_id := csd_process_util.get_inv_org_id;
1218:
1219: IF (g_debug > 0 ) THEN
1220:
1221: csd_gen_utility_pvt.add('l_incident_id ='||l_incident_id);

Line 1373: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cps_txn_billing_type_id);

1369: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
1370: end if;
1371:
1372:
1373: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cps_txn_billing_type_id);
1374: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
1375: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;
1376:
1377:

Line 1541: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cpr_txn_billing_type_id) ;

1537: x_prod_txn_tbl(l_index).contract_id := l_contract_id ;
1538: -- R12 contract changes
1539: x_prod_txn_tbl(l_index).contract_line_id := l_contract_line_id ;
1540: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
1541: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cpr_txn_billing_type_id) ;
1542: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
1543: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;
1544:
1545: -- auto process the RMA for the customer

Line 1762: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cps_txn_billing_type_id);

1758: else
1759: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
1760: end if;
1761:
1762: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cps_txn_billing_type_id);
1763: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
1764: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;
1765:
1766:

Line 1945: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_ls_txn_billing_type_id ) ;

1941: else
1942: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
1943: end if;
1944:
1945: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_ls_txn_billing_type_id ) ;
1946: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
1947: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;
1948:
1949: IF NVL(l_interface_to_om_flag, 'N') = 'Y' THEN

Line 2108: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_lr_txn_billing_type_id) ;

2104: -- R12 contract changes
2105: x_prod_txn_tbl(l_index).contract_line_id := l_contract_line_id ;
2106: x_prod_txn_tbl(l_index).contract_id := l_contract_id ;
2107: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
2108: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_lr_txn_billing_type_id) ;
2109: x_prod_txn_tbl(l_index).interface_to_om_flag := 'N' ;
2110: x_prod_txn_tbl(l_index).book_sales_order_flag := 'N' ;
2111: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
2112: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;

Line 2308: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cps_txn_billing_type_id) ;

2304: else
2305: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
2306: end if;
2307:
2308: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cps_txn_billing_type_id) ;
2309: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
2310: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;
2311:
2312: IF NVL(l_interface_to_om_flag, 'N') = 'Y' THEN

Line 2466: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cpr_txn_billing_type_id);

2462: -- R12 contract changes
2463: x_prod_txn_tbl(l_index).contract_line_id := l_contract_line_id ;
2464: x_prod_txn_tbl(l_index).contract_id := l_contract_id ;
2465: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
2466: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cpr_txn_billing_type_id);
2467: x_prod_txn_tbl(l_index).interface_to_om_flag := 'N' ;
2468: x_prod_txn_tbl(l_index).book_sales_order_flag := 'N' ;
2469: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
2470: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;

Line 2665: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_ls_txn_billing_type_id);

2661: else
2662: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
2663: end if;
2664:
2665: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_ls_txn_billing_type_id);
2666: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
2667: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;
2668:
2669: IF NVL(l_interface_to_om_flag, 'N') = 'Y' and l_repair_type_ref = 'ARR' THEN

Line 2829: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cpr_txn_billing_type_id);

2825: -- R12 contract changes
2826: x_prod_txn_tbl(l_index).contract_line_id := l_contract_line_id ;
2827: x_prod_txn_tbl(l_index).contract_id := l_contract_id ;
2828: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
2829: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cpr_txn_billing_type_id);
2830: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
2831: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;
2832:
2833: IF NVL(l_auto_process_rma, 'N') = 'Y' THEN

Line 3038: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cps_txn_billing_type_id) ;

3034: else
3035: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
3036: end if;
3037:
3038: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cps_txn_billing_type_id) ;
3039: x_prod_txn_tbl(l_index).interface_to_om_flag := 'N' ;
3040: x_prod_txn_tbl(l_index).book_sales_order_flag := 'N' ;
3041: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
3042: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;

Line 3184: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_lr_txn_billing_type_id);

3180: -- R12 contract changes
3181: x_prod_txn_tbl(l_index).contract_line_id := l_contract_line_id ;
3182: x_prod_txn_tbl(l_index).contract_id := l_contract_id ;
3183: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
3184: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_lr_txn_billing_type_id);
3185: x_prod_txn_tbl(l_index).interface_to_om_flag := 'N' ;
3186: x_prod_txn_tbl(l_index).book_sales_order_flag := 'N' ;
3187: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
3188: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;

Line 3374: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_third_ship_txn_b_type_id);

3370: else
3371: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
3372: end if;
3373:
3374: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_third_ship_txn_b_type_id);
3375: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
3376: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;
3377:
3378: --bug#12888392 --14120502

Line 3580: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_third_rma_txn_b_type_id) ;

3576: x_prod_txn_tbl(l_index).contract_id := l_contract_id ;
3577: -- R12 contract changes
3578: x_prod_txn_tbl(l_index).contract_line_id := l_contract_line_id ;
3579: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
3580: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_third_rma_txn_b_type_id) ;
3581: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
3582: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;
3583:
3584: -- auto process the RMA for the customer

Line 4005: if( l_return_status <> csd_process_util.g_ret_sts_success) then

4001: p_incident_id => p_incident_id,
4002: x_org_id => l_org_id,
4003: x_profile => l_profile);
4004:
4005: if( l_return_status <> csd_process_util.g_ret_sts_success) then
4006: csd_gen_utility_pvt.add('Error in deriving the Org id ');
4007: end if;
4008:
4009: ELSE

Line 4768: FUNCTION ui_pricing_attr_rec RETURN csd_process_util.pricing_attr_rec

4764: BEGIN
4765: RETURN l_est_line_rec;
4766: END ui_estimate_line_rec ;
4767:
4768: FUNCTION ui_pricing_attr_rec RETURN csd_process_util.pricing_attr_rec
4769: IS
4770: l_pric_att_rec csd_process_util.pricing_attr_rec ;
4771: BEGIN
4772: RETURN l_pric_att_rec;

Line 4770: l_pric_att_rec csd_process_util.pricing_attr_rec ;

4766: END ui_estimate_line_rec ;
4767:
4768: FUNCTION ui_pricing_attr_rec RETURN csd_process_util.pricing_attr_rec
4769: IS
4770: l_pric_att_rec csd_process_util.pricing_attr_rec ;
4771: BEGIN
4772: RETURN l_pric_att_rec;
4773: END ui_pricing_attr_rec ;
4774:

Line 5118: CSD_PROCESS_UTIL.Check_Reqd_Param

5114: csd_gen_utility_pvt.ADD ('Check required parameters and validate them');
5115: END IF;
5116:
5117: -- Check the required parameters
5118: CSD_PROCESS_UTIL.Check_Reqd_Param
5119: ( p_param_value => p_repair_type_id,
5120: p_param_name => 'REPAIR_TYPE_ID',
5121: p_api_name => l_api_name);
5122:

Line 5124: IF NOT( CSD_PROCESS_UTIL.Validate_repair_type_id ( p_repair_type_id => p_repair_type_id )) THEN

5120: p_param_name => 'REPAIR_TYPE_ID',
5121: p_api_name => l_api_name);
5122:
5123: -- Validate the repair type ID
5124: IF NOT( CSD_PROCESS_UTIL.Validate_repair_type_id ( p_repair_type_id => p_repair_type_id )) THEN
5125: RAISE FND_API.G_EXC_ERROR;
5126: END IF;
5127:
5128: -- Validate the incident ID

Line 5130: IF NOT( CSD_PROCESS_UTIL.Validate_incident_id ( p_incident_id => p_incident_id )) THEN

5126: END IF;
5127:
5128: -- Validate the incident ID
5129: IF (p_incident_id IS NOT NULL) THEN
5130: IF NOT( CSD_PROCESS_UTIL.Validate_incident_id ( p_incident_id => p_incident_id )) THEN
5131: RAISE FND_API.G_EXC_ERROR;
5132: END IF;
5133: END IF;
5134:

Line 5451: p_pricing_rec in CSD_PROCESS_UTIL.PRICING_ATTR_REC,

5447: p_currency_code in VARCHAR2,
5448: p_quantity_required in NUMBER,
5449: p_account_id in NUMBER DEFAULT null, --bug#3875036
5450: p_org_id in NUMBER, -- added for R12
5451: p_pricing_rec in CSD_PROCESS_UTIL.PRICING_ATTR_REC,
5452: x_selling_price OUT NOCOPY NUMBER,
5453: x_return_status OUT NOCOPY VARCHAR2,
5454: x_msg_count OUT NOCOPY NUMBER,
5455: x_msg_data OUT NOCOPY VARCHAR2)

Line 5651: csd_gen_utility_pvt.ADD('CSD_PROCESS_UTIL.PRICE_REQUEST failed');

5647: x_msg_data => x_msg_data);
5648:
5649: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5650: IF (g_debug > 0 ) THEN
5651: csd_gen_utility_pvt.ADD('CSD_PROCESS_UTIL.PRICE_REQUEST failed');
5652: END IF;
5653: END IF;
5654:
5655: END IF;

Line 5673: p_pricing_rec in CSD_PROCESS_UTIL.PRICING_ATTR_REC,

5669: p_unit_of_measure_code in VARCHAR2,
5670: p_currency_code in VARCHAR2,
5671: p_quantity_required in NUMBER,
5672: p_account_id in NUMBER DEFAULT null,
5673: p_pricing_rec in CSD_PROCESS_UTIL.PRICING_ATTR_REC,
5674: x_selling_price OUT NOCOPY NUMBER,
5675: x_return_status OUT NOCOPY VARCHAR2,
5676: x_msg_count OUT NOCOPY NUMBER,
5677: x_msg_data OUT NOCOPY VARCHAR2)

Line 6202: lc_mod_name VARCHAR2(240) := 'csd.plsql.csd_process_util.validate_subinventory_ship';

6198: l_override_negative_qty NUMBER;
6199: l_exists VARCHAR2(3) := 'Y';
6200: l_current_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6201: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
6202: lc_mod_name VARCHAR2(240) := 'csd.plsql.csd_process_util.validate_subinventory_ship';
6203:
6204: --bug#13498183
6205: l_serial_control_Code NUMBER ;
6206: --bug#13498183

Line 6398: END CSD_PROCESS_UTIL;

6394:
6395: end validate_order_for_holds;
6396: -- end bug#7355526, nnadig
6397:
6398: END CSD_PROCESS_UTIL;