APPS.CSD_ISUP_DEPOT_WF_PVT dependencies on CSD_ISUP_DEPOT_WF_PVT

Line 1: PACKAGE BODY CSD_ISUP_DEPOT_WF_PVT AS

1: PACKAGE BODY CSD_ISUP_DEPOT_WF_PVT AS
2: /* $Header: csdviswb.pls 120.4.12010000.3 2008/11/06 10:47:28 subhat ship $ */
3:
4: /*-----------------------------------------------------------------*/
5: /* NOTE - This is the new workflow from isupport to depot integration*/

Line 34: lc_mod_name varchar2(75) := 'csd_plsql_csd_isup_depot_wf_pvt.check_sr_details_wf';

30: cs_incident_types_b cit
31: where ci.incident_number = g_incident_number
32: and ci.incident_type_id = cit.incident_type_id;
33:
34: lc_mod_name varchar2(75) := 'csd_plsql_csd_isup_depot_wf_pvt.check_sr_details_wf';
35:
36: BEGIN
37:
38: if funcmode = 'RUN' then

Line 152: lc_mod_name varchar2(75) := 'csd_plsql_csd_isup_depot_wf_pvt.create_ro_wf';

148: -- create logistics exception
149:
150: l_prod_exception exception;
151:
152: lc_mod_name varchar2(75) := 'csd_plsql_csd_isup_depot_wf_pvt.create_ro_wf';
153:
154: ---- Cursor to get Repair Mode
155:
156: cursor get_repair_mode(p_repair_type_id IN NUMBER ) IS

Line 558: WF_CORE.CONTEXT ('CSD_ISUP_DEPOT_WF_PVT','create_ro_wf', itemtype,itemkey, to_char(actid),funcmode);

554: WHEN l_ro_exception THEN
555: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
556: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,lc_mod_name||'exception','Error '||x_msg_data);
557: END IF;
558: WF_CORE.CONTEXT ('CSD_ISUP_DEPOT_WF_PVT','create_ro_wf', itemtype,itemkey, to_char(actid),funcmode);
559: ROLLBACK;
560: RAISE;
561: WHEN l_prod_exception THEN
562: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 565: WF_CORE.CONTEXT ('CSD_ISUP_DEPOT_WF_PVT','create_ro_wf', itemtype,itemkey, to_char(actid),funcmode);

561: WHEN l_prod_exception THEN
562: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
563: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,lc_mod_name||'exception','Error '||x_msg_data);
564: END IF;
565: WF_CORE.CONTEXT ('CSD_ISUP_DEPOT_WF_PVT','create_ro_wf', itemtype,itemkey, to_char(actid),funcmode);
566: ROLLBACK;
567: RAISE;
568: WHEN OTHERS THEN
569: WF_CORE.CONTEXT ('CSD_ISUP_DEPOT_WF_PVT','create_ro_wf', itemtype,itemkey, to_char(actid),funcmode);

Line 569: WF_CORE.CONTEXT ('CSD_ISUP_DEPOT_WF_PVT','create_ro_wf', itemtype,itemkey, to_char(actid),funcmode);

565: WF_CORE.CONTEXT ('CSD_ISUP_DEPOT_WF_PVT','create_ro_wf', itemtype,itemkey, to_char(actid),funcmode);
566: ROLLBACK;
567: RAISE;
568: WHEN OTHERS THEN
569: WF_CORE.CONTEXT ('CSD_ISUP_DEPOT_WF_PVT','create_ro_wf', itemtype,itemkey, to_char(actid),funcmode);
570: RAISE;
571: ROLLBACK;
572: end create_ro_wf;
573:

Line 574: END CSD_ISUP_DEPOT_WF_PVT;

570: RAISE;
571: ROLLBACK;
572: end create_ro_wf;
573:
574: END CSD_ISUP_DEPOT_WF_PVT;