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_WF_PROCESS_PVT dependencies on CSD_WF_PROCESS_PVT

Line 1: PACKAGE BODY CSD_WF_PROCESS_PVT AS

1: PACKAGE BODY CSD_WF_PROCESS_PVT AS
2: /* $Header: csdvwfpb.pls 120.3.12020000.3 2013/04/04 09:35:40 subhat ship $ */
3:
4: /*-----------------------------------------------------------------*/
5: /* procedure name: get_ro_details_wf */

Line 30: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_WF_PROCESS_PVT.get_ro_details_wf';

26: l_contact_name varchar2(360);
27:
28: l_msg_text VARCHAR2(2000);
29:
30: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_WF_PROCESS_PVT.get_ro_details_wf';
31:
32: -- cursor to get the workorder details to be used in WF notification.
33: Cursor get_ro_attributes (p_repair_line_id in number) is
34: select sr.cont_email,

Line 147: WF_CORE.CONTEXT ('csd_wf_process_pvt','get_ro_details_wf', itemtype,itemkey, to_char(actid),funcmode);

143: END IF;
144:
145: EXCEPTION
146: WHEN OTHERS THEN
147: WF_CORE.CONTEXT ('csd_wf_process_pvt','get_ro_details_wf', itemtype,itemkey, to_char(actid),funcmode);
148: raise;
149: END;
150:
151:

Line 178: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_WF_PROCESS_PVT.create_cu_msg_wf';

174: l_flow_status varchar2(80);
175:
176: l_msg_text VARCHAR2(2000);
177:
178: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_WF_PROCESS_PVT.create_cu_msg_wf';
179:
180:
181: -- cursor to get the workorder details to be used in WF notification.
182: Cursor get_ro_attributes (p_repair_line_id in number) is

Line 297: WF_CORE.CONTEXT ('csd_wf_process_pvt','create_cu_msg_wf', itemtype,itemkey, to_char(actid),funcmode);

293: END IF;
294:
295: EXCEPTION
296: WHEN OTHERS THEN
297: WF_CORE.CONTEXT ('csd_wf_process_pvt','create_cu_msg_wf', itemtype,itemkey, to_char(actid),funcmode);
298: raise;
299: END;
300:
301:

Line 331: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_WF_PROCESS_PVT.create_cu_rep_msg_wf';

327: l_source_last_name varchar2(360);
328:
329: l_msg_text VARCHAR2(2000);
330:
331: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_WF_PROCESS_PVT.create_cu_rep_msg_wf';
332:
333: -- cursor to get the workorder details to be used in WF notification.
334: Cursor get_ro_attributes (p_repair_line_id in number) is
335: Select wr.name, wr.email_address, sr.incident_number,

Line 406: WF_CORE.CONTEXT ('csd_wf_process_pvt','create_cu_rep_msg_wf', itemtype,itemkey, to_char(actid),funcmode);

402: END IF;
403:
404: EXCEPTION
405: WHEN OTHERS THEN
406: WF_CORE.CONTEXT ('csd_wf_process_pvt','create_cu_rep_msg_wf', itemtype,itemkey, to_char(actid),funcmode);
407: raise;
408: END;
409:
410:

Line 517: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS.BEGIN',

513: IF funcmode ='RUN' THEN
514:
515: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
516: fnd_log.STRING (fnd_log.level_procedure,
517: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS.BEGIN',
518: 'Enter - auto_create_repair_orders');
519: END IF;
520:
521: --initialize resultout to Error

Line 576: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',

572: IF NOT(l_created_sr) THEN
573:
574: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
575: fnd_log.STRING (fnd_log.level_statement,
576: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',
577: 'Begin Create Internal SR');
578: End if;
579:
580: l_intr_party_id := null;

Line 608: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',

604: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
605:
606: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
607: fnd_log.STRING (fnd_log.level_statement,
608: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',
609: 'Create Internal SR Failed');
610: End if;
611:
612: RAISE FND_API.G_EXC_ERROR;

Line 620: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',

616: l_created_sr := true;
617:
618: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
619: fnd_log.STRING (fnd_log.level_statement,
620: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',
621: 'Created Internal SR: Incident Number = ' || l_incident_number);
622: END IF;
623:
624: END IF;

Line 632: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',

628: -------------------------------
629:
630: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
631: fnd_log.STRING (fnd_log.level_statement,
632: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',
633: 'Begin Create RO for transaction id = ' || l_transaction_id);
634: END IF;
635:
636: -- Derive the Currency code if transaction_currency is null

Line 660: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',

656: End if;
657:
658: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
659: fnd_log.STRING (fnd_log.level_statement,
660: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',
661: 'Derived Currency Code = '|| l_currency_code);
662: End if;
663:
664: END IF;

Line 697: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',

693: Close c_get_ib_info;
694:
695: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
696: fnd_log.STRING (fnd_log.level_statement,
697: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',
698: 'Derived Instance Id = '|| l_instance_id || ' for Item Id = '|| l_inventory_item_id ||
699: ' Serial Number = ' || l_serial_number );
700: End if;
701:

Line 729: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',

725: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
726:
727: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
728: fnd_log.STRING (fnd_log.level_statement,
729: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',
730: 'Create RO Failed for transaction id = ' || l_transaction_id);
731: End if;
732:
733: RAISE FND_API.G_EXC_ERROR;

Line 739: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',

735: END IF;
736:
737: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
738: fnd_log.STRING (fnd_log.level_statement,
739: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',
740: 'Created RO: Repair Number = ' || l_repair_number || ' for transaction id = ' || l_transaction_id);
741: END IF;
742:
743: -- insert new into CSD_RO_CREATION_WIP_TXNS to keep track of transaction ids of created ROs

Line 770: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',

766: );
767:
768: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
769: fnd_log.STRING (fnd_log.level_statement,
770: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS',
771: 'Inserted transaction id = ' || l_transaction_id || ' into CSD_RO_CREATION_WIP_TXNS');
772: END IF;
773:
774: -- clear/reset values in l_repln_rec

Line 785: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS.END',

781: resultout := 'COMPLETE:SUCCESS';
782:
783: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
784: fnd_log.STRING (fnd_log.level_procedure,
785: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS.END',
786: 'Exit - auto_create_repair_orders');
787: END IF;
788:
789: RETURN;

Line 798: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS.END',

794: WHEN OTHERS THEN
795: Rollback To auto_create_ro_savepoint;
796: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
797: fnd_log.STRING (fnd_log.level_procedure,
798: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS.END',
799: 'Error/Exception occurred, Roll back all SR and ROs created');
800: END IF;
801:
802: WF_CORE.CONTEXT ('csd_wf_process_pvt','create_cu_rep_msg_wf', itemtype,itemkey, to_char(actid),funcmode);

Line 802: WF_CORE.CONTEXT ('csd_wf_process_pvt','create_cu_rep_msg_wf', itemtype,itemkey, to_char(actid),funcmode);

798: 'CSD.PLSQL.CSD_WF_PROCESS_PVT.AUTO_CREATE_REPAIR_ORDERS.END',
799: 'Error/Exception occurred, Roll back all SR and ROs created');
800: END IF;
801:
802: WF_CORE.CONTEXT ('csd_wf_process_pvt','create_cu_rep_msg_wf', itemtype,itemkey, to_char(actid),funcmode);
803: Raise;
804: END;
805:
806: PROCEDURE create_service_warranty_wf

Line 815: lc_mod_name CONSTANT VARCHAR2(50) := 'csd_wf_process_pvt.create_service_warranty_wf';

811: resultout out NOCOPY varchar2)
812: IS
813: l_order_line_id NUMBER;
814: l_repair_line_id NUMBER;
815: lc_mod_name CONSTANT VARCHAR2(50) := 'csd_wf_process_pvt.create_service_warranty_wf';
816: x_msg_data varchar2(2000);
817: x_msg_count number;
818: x_return_status varchar2(1);
819: x_contract_number varchar2(30);

Line 857: WF_CORE.CONTEXT ('csd_wf_process_pvt','create_service_warranty_wf', itemtype,itemkey, to_char(actid),funcmode);

853: END IF;
854:
855: EXCEPTION
856: WHEN OTHERS THEN
857: WF_CORE.CONTEXT ('csd_wf_process_pvt','create_service_warranty_wf', itemtype,itemkey, to_char(actid),funcmode);
858: RAISE;
859:
860: END create_service_warranty_wf;
861:

Line 862: END CSD_WF_PROCESS_PVT;

858: RAISE;
859:
860: END create_service_warranty_wf;
861:
862: END CSD_WF_PROCESS_PVT;