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.7 2010/08/31 11:12:12 subhat ship $ */
3:
4: /*-----------------------------------------------------------------*/
5: /* NOTE - This is the new workflow from isupport to depot integration*/

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

34: and ci.incident_type_id = cit.incident_type_id
35: and cbp.business_process_id = cit.business_process_id
36: and cbp.name = 'Depot Repair';
37:
38: lc_mod_name varchar2(75) := 'csd_plsql_csd_isup_depot_wf_pvt.check_sr_details_wf';
39:
40: BEGIN
41:
42: if funcmode = 'RUN' then

Line 141: lc_mod_name CONSTANT VARCHAR2(75) := 'csd_plsql_csd_isup_depot_wf_pvt.create_ro_wf';

137: x_JTF_NOTE_ID NUMBER ;
138:
139: l_ro_exception EXCEPTION;
140: l_prod_exception EXCEPTION;
141: lc_mod_name CONSTANT VARCHAR2(75) := 'csd_plsql_csd_isup_depot_wf_pvt.create_ro_wf';
142:
143: ---- Cursor to get Repair Mode
144:
145: CURSOR get_repair_mode(p_repair_type_id IN NUMBER ) IS

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

675: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
676: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,lc_mod_name||'exception','Error '||x_msg_data);
677: END IF;
678: END IF;
679: WF_CORE.CONTEXT ('CSD_ISUP_DEPOT_WF_PVT','create_ro_wf', itemtype,itemkey, to_char(actid),funcmode);
680: ROLLBACK;
681: RAISE;
682: WHEN l_prod_exception THEN
683: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

684: p_data => x_msg_data);
685: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
686: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,lc_mod_name||'exception','Error '||x_msg_data);
687: END IF;
688: WF_CORE.CONTEXT ('CSD_ISUP_DEPOT_WF_PVT','create_ro_wf', itemtype,itemkey, to_char(actid),funcmode);
689: ROLLBACK;
690: RAISE;
691: WHEN OTHERS THEN
692: WF_CORE.CONTEXT ('CSD_ISUP_DEPOT_WF_PVT','create_ro_wf', itemtype,itemkey, to_char(actid),funcmode);

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

688: WF_CORE.CONTEXT ('CSD_ISUP_DEPOT_WF_PVT','create_ro_wf', itemtype,itemkey, to_char(actid),funcmode);
689: ROLLBACK;
690: RAISE;
691: WHEN OTHERS THEN
692: WF_CORE.CONTEXT ('CSD_ISUP_DEPOT_WF_PVT','create_ro_wf', itemtype,itemkey, to_char(actid),funcmode);
693: RAISE;
694: ROLLBACK;
695: END create_ro_wf;
696:

Line 697: END CSD_ISUP_DEPOT_WF_PVT;

693: RAISE;
694: ROLLBACK;
695: END create_ro_wf;
696:
697: END CSD_ISUP_DEPOT_WF_PVT;