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.33.12010000.6 2008/11/10 23:20:57 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.33.12010000.6 2008/11/10 23:20:57 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:
8: /*

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

541: -- activity (Transaction_type_id).
542: -- If transaction_type_id is not passed to this API then it derive the transaction_type_id
543: -- using parameter p_txn_billing_type_id and then it derive the correct txn_billing_type_id
544: -- for transaction.
545: -- Called from : WVI trigger of rcv_ship.TRANSACTION_TYPE and CSD_PROCESS_UTIL.build_prodtxn_tbl_int
546: -- Input Parm : p_api_version NUMBER Api Version number
547: -- p_init_msg_list VARCHAR2 Initializes message stack if fnd_api.g_true,
548: -- default value is fnd_api.g_false
549: -- p_incident_id NUMBER incident id of service request

Line 632: IF csd_process_util.is_multiorg_enabled THEN

628:
629: l_org_id := cs_std.get_item_valdn_orgzn_id;
630:
631: /*Derive the operating unit */
632: IF csd_process_util.is_multiorg_enabled THEN
633: CS_MultiOrg_Pub.Get_OrgId(
634: P_API_VERSION => 1.0,
635: P_INIT_MSG_LIST => 'F',
636: P_COMMIT => 'F',

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

640: X_MSG_COUNT => x_msg_count,
641: X_MSG_DATA => x_msg_data,
642: X_ORG_ID => l_operating_unit,
643: X_PROFILE => l_profile);
644: IF (x_return_status <> CSD_PROCESS_UTIL.G_RET_STS_SUCCESS) THEN
645: csd_gen_utility_pvt.ADD('Error in Deriving the Operating Unit ');
646: END IF;
647: ELSE
648: Fnd_Profile.Get('ORG_ID',l_operating_unit);

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

793: l_currency_code varchar(15);
794: l_return_status VARCHAR2(1);
795: l_msg_count NUMBER;
796: l_msg_data VARCHAR2(2000);
797: l_pricing_rec csd_process_util.pricing_attr_rec := csd_process_util.ui_pricing_attr_rec;
798: l_enable_advanced_pricing VARCHAR2(1);
799:
800:
801: /*Bug#5190905 added below variables*/

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

1179: csd_gen_utility_pvt.add('l_lr_txn_billing_type_id ='||l_lr_txn_billing_type_id );
1180: END IF;
1181:
1182:
1183: l_org_id := csd_process_util.get_org_id(l_incident_id);
1184: -- Inv_org Change, Vijay , 20/3/2006
1185: -- taken from the repair_order record.
1186: --l_inv_org_id := csd_process_util.get_inv_org_id;
1187:

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

1182:
1183: l_org_id := csd_process_util.get_org_id(l_incident_id);
1184: -- Inv_org Change, Vijay , 20/3/2006
1185: -- taken from the repair_order record.
1186: --l_inv_org_id := csd_process_util.get_inv_org_id;
1187:
1188: IF (g_debug > 0 ) THEN
1189:
1190: csd_gen_utility_pvt.add('l_incident_id ='||l_incident_id);

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

1323: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
1324: end if;
1325:
1326:
1327: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cps_txn_billing_type_id);
1328: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
1329: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;
1330:
1331:

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

1486: x_prod_txn_tbl(l_index).contract_id := l_contract_id ;
1487: -- R12 contract changes
1488: x_prod_txn_tbl(l_index).contract_line_id := l_contract_line_id ;
1489: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
1490: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cpr_txn_billing_type_id) ;
1491: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
1492: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;
1493:
1494: -- auto process the RMA for the customer

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

1691: else
1692: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
1693: end if;
1694:
1695: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cps_txn_billing_type_id);
1696: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
1697: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;
1698:
1699:

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

1861: else
1862: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
1863: end if;
1864:
1865: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_ls_txn_billing_type_id ) ;
1866: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
1867: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;
1868:
1869: IF NVL(l_interface_to_om_flag, 'N') = 'Y' THEN

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

2010: -- R12 contract changes
2011: x_prod_txn_tbl(l_index).contract_line_id := l_contract_line_id ;
2012: x_prod_txn_tbl(l_index).contract_id := l_contract_id ;
2013: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
2014: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_lr_txn_billing_type_id) ;
2015: x_prod_txn_tbl(l_index).interface_to_om_flag := 'N' ;
2016: x_prod_txn_tbl(l_index).book_sales_order_flag := 'N' ;
2017: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
2018: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;

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

2195: else
2196: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
2197: end if;
2198:
2199: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cps_txn_billing_type_id) ;
2200: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
2201: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;
2202:
2203: IF NVL(l_interface_to_om_flag, 'N') = 'Y' THEN

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

2340: -- R12 contract changes
2341: x_prod_txn_tbl(l_index).contract_line_id := l_contract_line_id ;
2342: x_prod_txn_tbl(l_index).contract_id := l_contract_id ;
2343: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
2344: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cpr_txn_billing_type_id);
2345: x_prod_txn_tbl(l_index).interface_to_om_flag := 'N' ;
2346: x_prod_txn_tbl(l_index).book_sales_order_flag := 'N' ;
2347: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
2348: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;

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

2526: else
2527: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
2528: end if;
2529:
2530: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_ls_txn_billing_type_id);
2531: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
2532: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;
2533:
2534: IF NVL(l_interface_to_om_flag, 'N') = 'Y' and l_repair_type_ref = 'ARR' THEN

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

2675: -- R12 contract changes
2676: x_prod_txn_tbl(l_index).contract_line_id := l_contract_line_id ;
2677: x_prod_txn_tbl(l_index).contract_id := l_contract_id ;
2678: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
2679: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cpr_txn_billing_type_id);
2680: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
2681: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;
2682:
2683: IF NVL(l_auto_process_rma, 'N') = 'Y' THEN

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

2869: else
2870: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
2871: end if;
2872:
2873: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_cps_txn_billing_type_id) ;
2874: x_prod_txn_tbl(l_index).interface_to_om_flag := 'N' ;
2875: x_prod_txn_tbl(l_index).book_sales_order_flag := 'N' ;
2876: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
2877: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;

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

3000: -- R12 contract changes
3001: x_prod_txn_tbl(l_index).contract_line_id := l_contract_line_id ;
3002: x_prod_txn_tbl(l_index).contract_id := l_contract_id ;
3003: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
3004: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_lr_txn_billing_type_id);
3005: x_prod_txn_tbl(l_index).interface_to_om_flag := 'N' ;
3006: x_prod_txn_tbl(l_index).book_sales_order_flag := 'N' ;
3007: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
3008: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;

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

3176: else
3177: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
3178: end if;
3179:
3180: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_third_ship_txn_b_type_id);
3181: x_prod_txn_tbl(l_index).release_sales_order_flag := 'N' ;
3182: x_prod_txn_tbl(l_index).ship_sales_order_flag := 'N' ;
3183:
3184:

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

3370: x_prod_txn_tbl(l_index).contract_id := l_contract_id ;
3371: -- R12 contract changes
3372: x_prod_txn_tbl(l_index).contract_line_id := l_contract_line_id ;
3373: x_prod_txn_tbl(l_index).sub_inventory := FND_API.G_MISS_CHAR;
3374: x_prod_txn_tbl(l_index).no_charge_flag := csd_process_util.get_no_chg_flag(l_third_rma_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: -- auto process the RMA for the customer

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

3770: p_incident_id => p_incident_id,
3771: x_org_id => l_org_id,
3772: x_profile => l_profile);
3773:
3774: if( l_return_status <> csd_process_util.g_ret_sts_success) then
3775: csd_gen_utility_pvt.add('Error in deriving the Org id ');
3776: end if;
3777:
3778: ELSE

Line 4502: FUNCTION ui_pricing_attr_rec RETURN csd_process_util.pricing_attr_rec

4498: BEGIN
4499: RETURN l_est_line_rec;
4500: END ui_estimate_line_rec ;
4501:
4502: FUNCTION ui_pricing_attr_rec RETURN csd_process_util.pricing_attr_rec
4503: IS
4504: l_pric_att_rec csd_process_util.pricing_attr_rec ;
4505: BEGIN
4506: RETURN l_pric_att_rec;

Line 4504: l_pric_att_rec csd_process_util.pricing_attr_rec ;

4500: END ui_estimate_line_rec ;
4501:
4502: FUNCTION ui_pricing_attr_rec RETURN csd_process_util.pricing_attr_rec
4503: IS
4504: l_pric_att_rec csd_process_util.pricing_attr_rec ;
4505: BEGIN
4506: RETURN l_pric_att_rec;
4507: END ui_pricing_attr_rec ;
4508:

Line 4852: CSD_PROCESS_UTIL.Check_Reqd_Param

4848: csd_gen_utility_pvt.ADD ('Check required parameters and validate them');
4849: END IF;
4850:
4851: -- Check the required parameters
4852: CSD_PROCESS_UTIL.Check_Reqd_Param
4853: ( p_param_value => p_repair_type_id,
4854: p_param_name => 'REPAIR_TYPE_ID',
4855: p_api_name => l_api_name);
4856:

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

4854: p_param_name => 'REPAIR_TYPE_ID',
4855: p_api_name => l_api_name);
4856:
4857: -- Validate the repair type ID
4858: IF NOT( CSD_PROCESS_UTIL.Validate_repair_type_id ( p_repair_type_id => p_repair_type_id )) THEN
4859: RAISE FND_API.G_EXC_ERROR;
4860: END IF;
4861:
4862: -- Validate the incident ID

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

4860: END IF;
4861:
4862: -- Validate the incident ID
4863: IF (p_incident_id IS NOT NULL) THEN
4864: IF NOT( CSD_PROCESS_UTIL.Validate_incident_id ( p_incident_id => p_incident_id )) THEN
4865: RAISE FND_API.G_EXC_ERROR;
4866: END IF;
4867: END IF;
4868:

Line 5185: p_pricing_rec in CSD_PROCESS_UTIL.PRICING_ATTR_REC,

5181: p_currency_code in VARCHAR2,
5182: p_quantity_required in NUMBER,
5183: p_account_id in NUMBER DEFAULT null, --bug#3875036
5184: p_org_id in NUMBER, -- added for R12
5185: p_pricing_rec in CSD_PROCESS_UTIL.PRICING_ATTR_REC,
5186: x_selling_price OUT NOCOPY NUMBER,
5187: x_return_status OUT NOCOPY VARCHAR2,
5188: x_msg_count OUT NOCOPY NUMBER,
5189: x_msg_data OUT NOCOPY VARCHAR2)

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

5339: x_msg_data => x_msg_data);
5340:
5341: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5342: IF (g_debug > 0 ) THEN
5343: csd_gen_utility_pvt.ADD('CSD_PROCESS_UTIL.PRICE_REQUEST failed');
5344: END IF;
5345: END IF;
5346:
5347: END IF;

Line 5365: p_pricing_rec in CSD_PROCESS_UTIL.PRICING_ATTR_REC,

5361: p_unit_of_measure_code in VARCHAR2,
5362: p_currency_code in VARCHAR2,
5363: p_quantity_required in NUMBER,
5364: p_account_id in NUMBER DEFAULT null,
5365: p_pricing_rec in CSD_PROCESS_UTIL.PRICING_ATTR_REC,
5366: x_selling_price OUT NOCOPY NUMBER,
5367: x_return_status OUT NOCOPY VARCHAR2,
5368: x_msg_count OUT NOCOPY NUMBER,
5369: x_msg_data OUT NOCOPY VARCHAR2)

Line 5843: END CSD_PROCESS_UTIL;

5839: -- bug fix for 4108369, End
5840:
5841:
5842:
5843: END CSD_PROCESS_UTIL;