DBA Data[Home] [Help]

APPS.POS_SPM_WF_PKG1 dependencies on POS_SPM_WF_PKG1

Line 1: PACKAGE BODY pos_spm_wf_pkg1 AS

1: PACKAGE BODY pos_spm_wf_pkg1 AS
2: /* $Header: POSSPM1B.pls 120.50.12020000.3 2013/02/09 13:16:48 hvutukur ship $ */
3:
4: TYPE g_refcur IS ref CURSOR;
5:

Line 6: g_package_name CONSTANT VARCHAR2(30) := 'POS_SPM_WF_PKG1';

2: /* $Header: POSSPM1B.pls 120.50.12020000.3 2013/02/09 13:16:48 hvutukur ship $ */
3:
4: TYPE g_refcur IS ref CURSOR;
5:
6: g_package_name CONSTANT VARCHAR2(30) := 'POS_SPM_WF_PKG1';
7:
8: g_log_module CONSTANT VARCHAR2(30) := 'POSSPM1B';
9:
10: g_supplier_function_name CONSTANT fnd_form_functions.function_name%TYPE := 'POS_HT_SP_S_SUP_DET';

Line 1683: avalue => 'PLSQL:POS_SPM_WF_PKG1.BUYER_NOTE/'||To_char(p_supplier_reg_id));

1679: /*
1680: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1681: itemkey => l_itemkey,
1682: aname => 'BUYER_NOTE',
1683: avalue => 'PLSQL:POS_SPM_WF_PKG1.BUYER_NOTE/'||To_char(p_supplier_reg_id));
1684: */
1685:
1686: -- Bug 8325979 - Following attributes have been replaced with FND Messages
1687:

Line 1696: avalue => 'PLSQLCLOB:pos_spm_wf_pkg1.GENERATE_APPRV_SUPPLIER_BODY/'||l_itemtype ||':' ||l_itemkey ||'#'||p_supplier_reg_id

1692:
1693:
1694: wf_engine.SetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey,
1695: aname => 'POS_APPROVE_SUPPLIER_BODY',
1696: avalue => 'PLSQLCLOB:pos_spm_wf_pkg1.GENERATE_APPRV_SUPPLIER_BODY/'||l_itemtype ||':' ||l_itemkey ||'#'||p_supplier_reg_id
1697: );
1698:
1699: l_step := 5;
1700: wf_engine.StartProcess(itemtype => l_itemtype,

Line 1874: avalue => 'PLSQL:POS_SPM_WF_PKG1.BUYER_NOTE/'||To_char(p_supplier_reg_id));

1870:
1871: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1872: itemkey => l_itemkey,
1873: aname => 'BUYER_NOTE',
1874: avalue => 'PLSQL:POS_SPM_WF_PKG1.BUYER_NOTE/'||To_char(p_supplier_reg_id));
1875:
1876: l_step := 10;
1877: wf_engine.StartProcess(itemtype => l_itemtype,
1878: itemkey => l_itemkey );

Line 2047: WF_CORE.CONTEXT ('POS_SPM_WF_PKG1', 'setup_acct_action_receiver', itemtype, itemkey, to_char(actid), funcmode);

2043: resultout := 'COMPLETE';
2044:
2045: EXCEPTION
2046: WHEN OTHERS THEN
2047: WF_CORE.CONTEXT ('POS_SPM_WF_PKG1', 'setup_acct_action_receiver', itemtype, itemkey, to_char(actid), funcmode);
2048: END setup_acct_action_receiver;
2049:
2050: -- wf function activity to setup buyer receivers for supplier account update
2051: PROCEDURE setup_acct_upd_buyer_rcvr

Line 2103: WF_CORE.CONTEXT ('POS_SPM_WF_PKG1', 'setup_acct_upd_buyer_rcvr', itemtype,

2099: RETURN;
2100:
2101: EXCEPTION
2102: WHEN OTHERS THEN
2103: WF_CORE.CONTEXT ('POS_SPM_WF_PKG1', 'setup_acct_upd_buyer_rcvr', itemtype,
2104: itemkey, to_char(actid), funcmode);
2105: RAISE;
2106: END setup_acct_upd_buyer_rcvr;
2107:

Line 2210: WF_CORE.CONTEXT ('POS_SPM_WF_PKG1', 'setup_acct_crt_buyer_rcvr', itemtype,itemkey, to_char(actid), funcmode);

2206: RETURN;
2207:
2208: EXCEPTION
2209: WHEN OTHERS THEN
2210: WF_CORE.CONTEXT ('POS_SPM_WF_PKG1', 'setup_acct_crt_buyer_rcvr', itemtype,itemkey, to_char(actid), funcmode);
2211: END setup_acct_crt_buyer_rcvr;
2212:
2213: -- wf function activity to setup supplier receiver for account creation
2214: PROCEDURE setup_acct_crt_supp_rcvr

Line 2670: avalue => 'PLSQL:POS_SPM_WF_PKG1.BANK_ACCT_BUYER_NOTE/'||p_note);

2666:
2667: wf_engine.SetItemAttrText (itemtype => l_itemtype,
2668: itemkey => l_itemkey,
2669: aname => 'BUYER_NOTE',
2670: avalue => 'PLSQL:POS_SPM_WF_PKG1.BANK_ACCT_BUYER_NOTE/'||p_note);
2671:
2672: IF l_process = 'PACCOUNT_VERIFY' OR l_process = 'PACCOUNT_VERIFY_FAILED'
2673: THEN
2674: get_enterprise_name(l_enterprise_name);

Line 2749: WF_CORE.CONTEXT ('POS_SPM_WF_PKG1', 'setup_acct_addr_receiver', itemtype,

2745: RETURN;
2746:
2747: EXCEPTION
2748: WHEN OTHERS THEN
2749: WF_CORE.CONTEXT ('POS_SPM_WF_PKG1', 'setup_acct_addr_receiver', itemtype,
2750: itemkey, to_char(actid), funcmode);
2751: RAISE;
2752: END setup_acct_addr_receiver;
2753:

Line 3314: FND_LOG.string(fnd_log.level_error, 'pos_spm_wf_pkg1' , 'Call to notify_bank_aprv_supp_aprv failed');

3310: EXCEPTION
3311: WHEN OTHERS THEN
3312: wf_core.context(g_package_name,'notify_bank_aprv_supp_aprv',l_itemtype,l_itemkey);
3313: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3314: FND_LOG.string(fnd_log.level_error, 'pos_spm_wf_pkg1' , 'Call to notify_bank_aprv_supp_aprv failed');
3315: END IF;
3316: END notify_bank_aprv_supp_aprv;
3317: -- notify the supplier that his/her supplier registration is approved
3318: -- when the user (primary contact) already exists in OID and auto-link of username is enabled

Line 3378: avalue => 'PLSQL:POS_SPM_WF_PKG1.BUYER_NOTE/'||To_char(p_supplier_reg_id));

3374:
3375: wf_engine.SetItemAttrText (itemtype => l_itemtype,
3376: itemkey => l_itemkey,
3377: aname => 'BUYER_NOTE',
3378: avalue => 'PLSQL:POS_SPM_WF_PKG1.BUYER_NOTE/'||To_char(p_supplier_reg_id));
3379:
3380: --
3381: -- Begin Supplier Hub: OSN Integration
3382: -- See FUNCTION get_osn_message for more info.

Line 3736: FND_LOG.string(fnd_log.level_error, 'pos_spm_wf_pkg1' , 'Call to the workflow process for sending reminder notifications for Business Classification Re-Certification failed.');

3732:
3733: wf_core.context(g_package_name,'bc_recert_workflow',l_itemtype,l_itemkey);
3734:
3735: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3736: FND_LOG.string(fnd_log.level_error, 'pos_spm_wf_pkg1' , 'Call to the workflow process for sending reminder notifications for Business Classification Re-Certification failed.');
3737: END IF;
3738:
3739: END bc_recert_workflow;
3740:

Line 3879: POS_SPM_WF_PKG1.BUYER_NOTE(To_char(l_supplier_reg_id),l_disp_type,l_note,l_disp_type);

3875:
3876: IF display_type = 'text/html' THEN
3877: l_disp_type:= display_type;
3878: fnd_message.set_name('POS','POS_APPROVE_SUPPLIER_HTML_BODY');
3879: POS_SPM_WF_PKG1.BUYER_NOTE(To_char(l_supplier_reg_id),l_disp_type,l_note,l_disp_type);
3880: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
3881: fnd_message.set_token('URL',l_url);
3882: fnd_message.set_token('USERNAME',l_username);
3883: fnd_message.set_token('PASSWORD',l_password);

Line 3902: POS_SPM_WF_PKG1.BUYER_NOTE(To_char(l_supplier_reg_id),l_disp_type,l_note,l_disp_type);

3898:
3899: ELSE
3900: l_disp_type:= display_type;
3901: fnd_message.set_name('POS','POS_APPROVE_SUPPLIER_TEXT_BODY');
3902: POS_SPM_WF_PKG1.BUYER_NOTE(To_char(l_supplier_reg_id),l_disp_type,l_note,l_disp_type);
3903: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
3904: fnd_message.set_token('URL',l_url);
3905: fnd_message.set_token('USERNAME',l_username);
3906: fnd_message.set_token('PASSWORD',l_password);

Line 3930: END pos_spm_wf_pkg1;

3926: RAISE;
3927: END GENERATE_APPRV_SUPPLIER_BODY;
3928:
3929:
3930: END pos_spm_wf_pkg1;