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_PROCESS_PVT

Line 1: Package BODY Csd_Process_Pvt AS

1: Package BODY Csd_Process_Pvt AS
2: /* $Header: csdvintb.pls 120.52.12020000.6 2013/04/14 02:06:35 takwong ship $ */
3:
4: -- ---------------------------------------------------------
5: -- Define global variables

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_PROCESS_PVT';

4: -- ---------------------------------------------------------
5: -- Define global variables
6: -- ---------------------------------------------------------
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_PROCESS_PVT';
9: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvintb.pls';
10: g_debug NUMBER := Csd_Gen_Utility_Pvt.g_debug_level;
11:
12: /* R12 Srl reservation changes, begin */

Line 107: p_service_request_rec IN Csd_Process_Pvt.SERVICE_REQUEST_REC,

103: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
104: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
105: p_action IN VARCHAR2,
106: p_incident_id IN NUMBER := NULL,
107: p_service_request_rec IN Csd_Process_Pvt.SERVICE_REQUEST_REC,
108: x_incident_id OUT NOCOPY NUMBER,
109: x_incident_number OUT NOCOPY VARCHAR2,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,

Line 146: p_service_request_rec IN Csd_Process_Pvt.SERVICE_REQUEST_REC,

142: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
143: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
144: p_action IN VARCHAR2,
145: p_incident_id IN NUMBER := NULL,
146: p_service_request_rec IN Csd_Process_Pvt.SERVICE_REQUEST_REC,
147: p_notes_tbl IN Cs_Servicerequest_Pub.NOTES_TABLE,
148: x_incident_id OUT NOCOPY NUMBER,
149: x_incident_number OUT NOCOPY VARCHAR2,
150: x_return_status OUT NOCOPY VARCHAR2,

Line 428: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.process_charge_lines';

424:
425:
426: -- Variables used in FND Log
427: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
428: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.process_charge_lines';
429:
430: BEGIN
431: Debug('At the Beginning of process_charge_lines', l_mod_name, 1);
432:

Line 1392: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.process_sales_order';

1388: WHERE header_id = p_header_id;
1389:
1390: -- Variables used in FND Log
1391: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
1392: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.process_sales_order';
1393:
1394: /* pick release rule api changes/srl reservations changes *
1395: */
1396: l_batch_rec WSH_PICKING_BATCHES_PUB.Batch_Info_Rec ;

Line 2442: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.create_product_txn';

2438: --R12 Development Changes End
2439:
2440: -- Variables used in FND Log
2441: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
2442: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.create_product_txn';
2443: l_tmp_char VARCHAR2(1); --R12 Development Changes
2444: /* R12 SN reservations integration change Begin */
2445: l_ItemAttributes Csd_Logistics_Util.ItemAttributes_Rec_Type;
2446: l_auto_reserve_profile VARCHAR2(10);

Line 4672: l_order_Rec Csd_Process_Pvt.om_interface_rec;

4668: l_msg_index NUMBER;
4669: l_return_status VARCHAR2(1);
4670: l_estimate_Rec Cs_Charge_Details_Pub.charges_rec_type;
4671: l_prodtxn_db_attr Csd_Logistics_Util.PRODTXN_DB_ATTR_REC;
4672: l_order_Rec Csd_Process_Pvt.om_interface_rec;
4673: l_est_detail_id NUMBER;
4674: l_add_to_order_id NUMBER;
4675: l_add_to_order_flag VARCHAR2(1);
4676: l_transaction_type_id NUMBER;

Line 4702: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.update_product_txn';

4698: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;
4699: l_excep_level NUMBER := Fnd_Log.LEVEL_EXCEPTION;
4700: l_statement_level NUMBER := Fnd_Log.LEVEL_STATEMENT;
4701:
4702: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.update_product_txn';
4703:
4704: BEGIN
4705:
4706:

Line 5558: RETURN Csd_Process_Pvt.CREATE_TASK_REC_TYPE IS

5554: BEGIN
5555: RETURN TMP_CUST_PROFILE_REC_TYPE;
5556: END GET_CUST_PROFILE_REC_TYPE;
5557: FUNCTION GET_CREATE_TASK_REC_TYPE
5558: RETURN Csd_Process_Pvt.CREATE_TASK_REC_TYPE IS
5559: TMP_CREATE_TASK_REC_TYPE Csd_Process_Pvt.CREATE_TASK_REC_TYPE;
5560: BEGIN
5561: RETURN TMP_CREATE_TASK_REC_TYPE;
5562: END GET_CREATE_TASK_REC_TYPE;

Line 5559: TMP_CREATE_TASK_REC_TYPE Csd_Process_Pvt.CREATE_TASK_REC_TYPE;

5555: RETURN TMP_CUST_PROFILE_REC_TYPE;
5556: END GET_CUST_PROFILE_REC_TYPE;
5557: FUNCTION GET_CREATE_TASK_REC_TYPE
5558: RETURN Csd_Process_Pvt.CREATE_TASK_REC_TYPE IS
5559: TMP_CREATE_TASK_REC_TYPE Csd_Process_Pvt.CREATE_TASK_REC_TYPE;
5560: BEGIN
5561: RETURN TMP_CREATE_TASK_REC_TYPE;
5562: END GET_CREATE_TASK_REC_TYPE;
5563:

Line 5603: l_create_task_rec Csd_Process_Pvt.CREATE_TASK_REC_TYPE := p_create_task_rec;

5599: l_msg_index NUMBER;
5600: l_return_status VARCHAR2(1);
5601: l_task_id NUMBER;
5602: -- Task record
5603: l_create_task_rec Csd_Process_Pvt.CREATE_TASK_REC_TYPE := p_create_task_rec;
5604: BEGIN
5605: -- -----------------
5606: -- Begin create task
5607: -- -----------------

Line 5630: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.create_task before jtf_tasks_pub.CREATE_TASK');

5626: -- Api body starts
5627: -- ---------------
5628: IF (g_debug > 0)
5629: THEN
5630: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.create_task before jtf_tasks_pub.CREATE_TASK');
5631: END IF;
5632:
5633: -- ----------------------------------------
5634: -- Calling Public JTF API to create a Task

Line 5698: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.create_task after jtf_tasks_pub.CREATE_TASK x_return_status' ||

5694: X_TASK_ID => x_task_id);
5695:
5696: IF (g_debug > 0)
5697: THEN
5698: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.create_task after jtf_tasks_pub.CREATE_TASK x_return_status' ||
5699: x_return_status);
5700: END IF;
5701:
5702: -- -------------------

Line 5772: l_create_task_rec Csd_Process_Pvt.CREATE_TASK_REC_TYPE := p_create_task_rec;

5768: l_msg_index NUMBER;
5769: l_return_status VARCHAR2(1);
5770: l_task_id NUMBER;
5771: -- Task record
5772: l_create_task_rec Csd_Process_Pvt.CREATE_TASK_REC_TYPE := p_create_task_rec;
5773: BEGIN
5774: -- -----------------
5775: -- Begin update task
5776: -- -----------------

Line 5799: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.update_task before jtf_tasks_pub.UPDATE_TASK');

5795: -- Api body starts
5796: -- ---------------
5797: IF (g_debug > 0)
5798: THEN
5799: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.update_task before jtf_tasks_pub.UPDATE_TASK');
5800: END IF;
5801:
5802: -- ----------------------------------------
5803: -- Calling Public JTF API to Update a Task

Line 5868: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.update_task after jtf_tasks_pub.UPDATE_TASK x_return_status' ||

5864: X_MSG_DATA => x_msg_data);
5865:
5866: IF (g_debug > 0)
5867: THEN
5868: Csd_Gen_Utility_Pvt.ADD('CSD_PROCESS_PVT.update_task after jtf_tasks_pub.UPDATE_TASK x_return_status' ||
5869: x_return_status);
5870: END IF;
5871:
5872: -- -------------------

Line 5904: FUNCTION GET_ADDRESS_REC_TYPE RETURN Csd_Process_Pvt.ADDRESS_REC_TYPE IS

5900: END IF;
5901: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5902: p_data => x_msg_data);
5903: END update_task;
5904: FUNCTION GET_ADDRESS_REC_TYPE RETURN Csd_Process_Pvt.ADDRESS_REC_TYPE IS
5905: TMP_ADDRESS_REC_TYPE Csd_Process_Pvt.ADDRESS_REC_TYPE;
5906: BEGIN
5907: RETURN TMP_ADDRESS_REC_TYPE;
5908: END GET_ADDRESS_REC_TYPE;

Line 5905: TMP_ADDRESS_REC_TYPE Csd_Process_Pvt.ADDRESS_REC_TYPE;

5901: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5902: p_data => x_msg_data);
5903: END update_task;
5904: FUNCTION GET_ADDRESS_REC_TYPE RETURN Csd_Process_Pvt.ADDRESS_REC_TYPE IS
5905: TMP_ADDRESS_REC_TYPE Csd_Process_Pvt.ADDRESS_REC_TYPE;
5906: BEGIN
5907: RETURN TMP_ADDRESS_REC_TYPE;
5908: END GET_ADDRESS_REC_TYPE;
5909:

Line 6616: p_task_activity_rec IN Csd_Process_Pvt.TASK_ACTIVITY_REC,

6612: PROCEDURE Create_repair_task_hist(p_api_version IN NUMBER,
6613: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_true,
6614: p_commit IN VARCHAR2 := Fnd_Api.g_false,
6615: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
6616: p_task_activity_rec IN Csd_Process_Pvt.TASK_ACTIVITY_REC,
6617: x_return_status OUT NOCOPY VARCHAR2,
6618: x_msg_count OUT NOCOPY NUMBER,
6619: x_msg_data OUT NOCOPY VARCHAR2)
6620:

Line 6916: p_task_activity_rec IN Csd_Process_Pvt.TASK_ACTIVITY_REC,

6912: PROCEDURE Update_repair_task_hist(p_api_version IN NUMBER,
6913: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_true,
6914: p_commit IN VARCHAR2 := Fnd_Api.g_false,
6915: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
6916: p_task_activity_rec IN Csd_Process_Pvt.TASK_ACTIVITY_REC,
6917: x_return_status OUT NOCOPY VARCHAR2,
6918: x_msg_count OUT NOCOPY NUMBER,
6919: x_msg_data OUT NOCOPY VARCHAR2) IS
6920: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_AND_WRITE';

Line 8169: /* csd_process_pvt.product_txn_rec ) ; */

8165: /* x_return_status Standard Out parameter */
8166: /* x_msg_count Standard in parameter */
8167: /* x_msg_data Standard in parameter , */
8168: /* x_product_txn_rec in out record variable of type */
8169: /* csd_process_pvt.product_txn_rec ) ; */
8170: /*---------------------------------------------------------------------------------*/
8171: PROCEDURE update_iro_product_txn(p_api_version IN NUMBER,
8172: p_commit IN VARCHAR2,
8173: p_init_msg_list IN VARCHAR2,

Line 8175: x_product_txn_rec IN OUT nocopy Csd_Process_Pvt.product_txn_rec,

8171: PROCEDURE update_iro_product_txn(p_api_version IN NUMBER,
8172: p_commit IN VARCHAR2,
8173: p_init_msg_list IN VARCHAR2,
8174: p_validation_level IN NUMBER,
8175: x_product_txn_rec IN OUT nocopy Csd_Process_Pvt.product_txn_rec,
8176: x_return_status OUT nocopy VARCHAR2,
8177: x_msg_count OUT nocopy NUMBER,
8178: x_msg_data OUT nocopy VARCHAR2) IS
8179:

Line 8186: l_order_rec Csd_Process_Pvt.om_interface_rec;

8182: l_msg_count NUMBER;
8183: l_msg_data VARCHAR2(2000);
8184: l_msg_index NUMBER;
8185: l_check VARCHAR2(1);
8186: l_order_rec Csd_Process_Pvt.om_interface_rec;
8187: l_est_detail_id NUMBER := NULL;
8188: l_incident_id NUMBER := NULL;
8189: l_party_id NUMBER := NULL;
8190: l_account_id NUMBER := NULL;

Line 8236: l_module_name VARCHAR2(240) := 'csd.plsql.csd_process_pvt.update_iro_product_txn';

8232: -- examples : 4- exception internal software failure condition
8233: l_exception_level NUMBER := Fnd_Log.level_exception;
8234: -- examples : 5- error end user erros
8235: l_error_level NUMBER := Fnd_Log.level_error;
8236: l_module_name VARCHAR2(240) := 'csd.plsql.csd_process_pvt.update_iro_product_txn';
8237:
8238: -- a variable whose value tells us whether order header can be pick released or not.
8239: l_order_to_be_pickreleased VARCHAR2(1) := C_NO;
8240: -- a variable whose value tells us whether order header can be shipped or not.

Line 8725: Csd_Process_Pvt.process_sales_order(p_api_version => 1.0,

8721: Fnd_Log.string(l_statement_level,
8722: l_module_name,
8723: 'Calling process_sales_order to release so');
8724: END IF;
8725: Csd_Process_Pvt.process_sales_order(p_api_version => 1.0,
8726: p_commit => Fnd_Api.g_false,
8727: p_init_msg_list => Fnd_Api.g_true,
8728: p_validation_level => Fnd_Api.g_valid_level_full,
8729: p_action => C_Action_Pick_Release,

Line 8740: 'csd_process_pvt.process_sales_order failed');

8736: IF l_exception_level >= l_debug_level
8737: THEN
8738: Fnd_Log.string(l_exception_level,
8739: l_module_name,
8740: 'csd_process_pvt.process_sales_order failed');
8741: END IF;
8742: RAISE release_order_excep;
8743: ELSE
8744: IF l_statement_level >= l_debug_level

Line 8936: Csd_Process_Pvt.process_sales_order(p_api_version => 1.0,

8932: Fnd_Log.string(l_statement_level,
8933: l_module_name,
8934: 'Calling Process Sales Order API');
8935: END IF;
8936: Csd_Process_Pvt.process_sales_order(p_api_version => 1.0,
8937: p_commit => Fnd_Api.g_false,
8938: p_init_msg_list => Fnd_Api.g_true,
8939: p_validation_level => Fnd_Api.g_valid_level_full,
8940: p_action => C_Action_Ship,

Line 9135: x_Logistics_KeyAttr_Tbl OUT NOCOPY Csd_Process_Pvt.Logistics_KeyAttr_Tbl_Type) IS

9131: p_repair_line_id IN NUMBER,
9132: x_return_status OUT NOCOPY VARCHAR2,
9133: x_msg_count OUT NOCOPY NUMBER,
9134: x_msg_data OUT NOCOPY VARCHAR2,
9135: x_Logistics_KeyAttr_Tbl OUT NOCOPY Csd_Process_Pvt.Logistics_KeyAttr_Tbl_Type) IS
9136: l_api_name CONSTANT VARCHAR2(30) := 'Create_Default_Prod_Txn_Wrapr';
9137: l_api_version CONSTANT NUMBER := 1.0;
9138: l_msg_count NUMBER;
9139: l_msg_data VARCHAR2(2000);

Line 9419: l_create_task_rec Csd_Process_Pvt.REPAIR_TASK_REC := p_create_repair_task_rec;

9415: l_msg_index NUMBER;
9416: l_return_status VARCHAR2(1);
9417:
9418: -- Task record
9419: l_create_task_rec Csd_Process_Pvt.REPAIR_TASK_REC := p_create_repair_task_rec;
9420: l_applicable_qa_plans VARCHAR2(1);
9421: l_plan_txn_ids VARCHAR2(5000);
9422: l_dummy_char VARCHAR2(32000);
9423:

Line 9436: l_module_name VARCHAR2(240) := 'csd.plsql.csd_process_pvt.create_repair_task';

9432: -- examples : 4- exception internal software failure condition
9433: l_exception_level NUMBER := Fnd_Log.level_exception;
9434: -- examples : 5- error end user erros
9435: l_error_level NUMBER := Fnd_Log.level_error;
9436: l_module_name VARCHAR2(240) := 'csd.plsql.csd_process_pvt.create_repair_task';
9437:
9438: BEGIN
9439: -- -----------------
9440: -- Begin create repair task

Line 9629: l_update_task_rec Csd_Process_Pvt.REPAIR_TASK_REC := p_update_repair_task_rec;

9625: l_msg_index NUMBER;
9626: l_return_status VARCHAR2(1);
9627:
9628: -- Task record
9629: l_update_task_rec Csd_Process_Pvt.REPAIR_TASK_REC := p_update_repair_task_rec;
9630: l_applicable_qa_plans VARCHAR2(1);
9631: l_dummy_char VARCHAR2(32000);
9632: l_plan_txn_ids VARCHAR2(5000);
9633:

Line 9646: l_module_name VARCHAR2(240) := 'csd.plsql.csd_process_pvt.update_repair_task';

9642: -- examples : 4- exception internal software failure condition
9643: l_exception_level NUMBER := Fnd_Log.level_exception;
9644: -- examples : 5- error end user erros
9645: l_error_level NUMBER := Fnd_Log.level_error;
9646: l_module_name VARCHAR2(240) := 'csd.plsql.csd_process_pvt.update_repair_task';
9647:
9648: BEGIN
9649: -- -----------------
9650: -- Begin update repair task

Line 9807: FUNCTION GET_REPAIR_TASK_REC RETURN Csd_Process_Pvt.REPAIR_TASK_REC IS

9803: p_data => x_msg_data);
9804:
9805: END UPDATE_REPAIR_TASK;
9806:
9807: FUNCTION GET_REPAIR_TASK_REC RETURN Csd_Process_Pvt.REPAIR_TASK_REC IS
9808: TMP_REPAIR_TASK_REC Csd_Process_Pvt.REPAIR_TASK_REC;
9809: BEGIN
9810: RETURN TMP_REPAIR_TASK_REC;
9811: END GET_REPAIR_TASK_REC;

Line 9808: TMP_REPAIR_TASK_REC Csd_Process_Pvt.REPAIR_TASK_REC;

9804:
9805: END UPDATE_REPAIR_TASK;
9806:
9807: FUNCTION GET_REPAIR_TASK_REC RETURN Csd_Process_Pvt.REPAIR_TASK_REC IS
9808: TMP_REPAIR_TASK_REC Csd_Process_Pvt.REPAIR_TASK_REC;
9809: BEGIN
9810: RETURN TMP_REPAIR_TASK_REC;
9811: END GET_REPAIR_TASK_REC;
9812: END Csd_Process_Pvt;

Line 9812: END Csd_Process_Pvt;

9808: TMP_REPAIR_TASK_REC Csd_Process_Pvt.REPAIR_TASK_REC;
9809: BEGIN
9810: RETURN TMP_REPAIR_TASK_REC;
9811: END GET_REPAIR_TASK_REC;
9812: END Csd_Process_Pvt;