DBA Data[Home] [Help]

APPS.FUN_WF_COMMON dependencies on FUN_WF_COMMON

Line 1: PACKAGE BODY FUN_WF_COMMON AS

1: PACKAGE BODY FUN_WF_COMMON AS
2: /* $Header: FUN_WF_COMMON_B.pls 120.34.12020000.3 2012/11/12 17:26:30 shnaraya ship $ */
3:
4: /*-----------------------------------------------------
5: * FUNCTION generate_event_key

Line 2: /* $Header: FUN_WF_COMMON_B.pls 120.34.12020000.3 2012/11/12 17:26:30 shnaraya ship $ */

1: PACKAGE BODY FUN_WF_COMMON AS
2: /* $Header: FUN_WF_COMMON_B.pls 120.34.12020000.3 2012/11/12 17:26:30 shnaraya ship $ */
3:
4: /*-----------------------------------------------------
5: * FUNCTION generate_event_key
6: * ----------------------------------------------------

Line 139: wf_core.context('FUN_WF_COMMON', 'IS_ARAP_BATCH_MODE',

135: RETURN;
136:
137: EXCEPTION
138: WHEN others THEN
139: wf_core.context('FUN_WF_COMMON', 'IS_ARAP_BATCH_MODE',
140: itemtype, itemkey, TO_CHAR(actid), funcmode);
141: RAISE;
142: END is_arap_batch_mode;
143:

Line 173: l_event_key := fun_wf_common.generate_event_key(l_batch_id, l_trx_id);

169: l_trx_id := wf_engine.GetItemAttrNumber
170: (itemtype => itemtype,
171: itemkey => itemkey,
172: aname => 'TRX_ID');
173: l_event_key := fun_wf_common.generate_event_key(l_batch_id, l_trx_id);
174:
175: wf_event.AddParameterToList(p_name => 'TRX_ID',
176: p_value => TO_CHAR(l_trx_id),
177: p_parameterlist => l_params);

Line 197: wf_core.context('FUN_WF_COMMON', 'RAISE_COMPLETE',

193: RETURN;
194:
195: EXCEPTION
196: WHEN others THEN
197: wf_core.context('FUN_WF_COMMON', 'RAISE_COMPLETE',
198: itemtype, itemkey, TO_CHAR(actid), funcmode);
199: RAISE;
200: END raise_complete;
201:

Line 338: wf_core.context('FUN_WF_COMMON', 'UPDATE_STATUS_COMPLETE',

334: RETURN;
335:
336: EXCEPTION
337: WHEN others THEN
338: wf_core.context('FUN_WF_COMMON', 'UPDATE_STATUS_COMPLETE',
339: itemtype, itemkey, TO_CHAR(actid), funcmode);
340: RAISE;
341: END update_status_complete;
342:

Line 483: fun_wf_common.get_ame_role_list

479: actid => actid,
480: aname => 'CONTACT_ORG_TYPE');
481:
482: -- Call the procedure which will return the AME role
483: fun_wf_common.get_ame_role_list
484: (itemkey => itemkey,
485: p_transaction_id => l_transaction_id,
486: p_fyi_notification => 'Y',
487: p_contact_type => l_contact_type,

Line 528: 'fun.plsql.fun_wf_common.get_ame_contacts',

524: THEN
525: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
526: THEN
527: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
528: 'fun.plsql.fun_wf_common.get_ame_contacts',
529: SQLERRM || ' Error occurred '||
530: ' for transaction ' || l_transaction_id);
531: END IF;
532:

Line 533: wf_core.context('FUN_WF_COMMON', 'GET_AME_CONTACTS',

529: SQLERRM || ' Error occurred '||
530: ' for transaction ' || l_transaction_id);
531: END IF;
532:
533: wf_core.context('FUN_WF_COMMON', 'GET_AME_CONTACTS',
534: itemtype, itemkey, TO_CHAR(actid), funcmode);
535: END get_ame_contacts;
536:
537: /* Bug:11722204-----------------------------------------------------------------

Line 580: fun_wf_common.get_ame_role_list

576: actid => actid,
577: aname => 'CONTACT_ORG_TYPE');
578:
579: -- Call the procedure which will return the AME role
580: fun_wf_common.get_ame_role_list
581: (itemkey => itemkey,
582: p_transaction_id => l_transaction_id,
583: p_fyi_notification => 'Y',
584: p_contact_type => l_contact_type,

Line 611: 'fun.plsql.fun_wf_common.get_ame_admin',

607: THEN
608: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
609: THEN
610: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
611: 'fun.plsql.fun_wf_common.get_ame_admin',
612: SQLERRM || ' Error occurred '||
613: ' for transaction ' || l_transaction_id);
614: END IF;
615:

Line 616: wf_core.context('FUN_WF_COMMON', 'GET_AME_CONTACTS',

612: SQLERRM || ' Error occurred '||
613: ' for transaction ' || l_transaction_id);
614: END IF;
615:
616: wf_core.context('FUN_WF_COMMON', 'GET_AME_CONTACTS',
617: itemtype, itemkey, TO_CHAR(actid), funcmode);
618: END get_ame_admin;
619:
620: /* ---------------------------------------------------------------------------

Line 690: fun_wf_common.get_ame_role_list

686: aname => 'UI_ACTION_USER_ID',
687: avalue => NULL);
688:
689: -- Call the procedure which will return the AME role list
690: fun_wf_common.get_ame_role_list
691: (itemkey => itemkey,
692: p_transaction_id => l_transaction_id,
693: p_fyi_notification => 'N',
694: p_contact_type => l_contact_type,

Line 738: 'fun.plsql.fun_wf_common.get_ame_approvers',

734: THEN
735: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
736: THEN
737: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
738: 'fun.plsql.fun_wf_common.get_ame_approvers',
739: SQLERRM || ' Error occurred '||
740: 'for transaction ' || l_transaction_id);
741: END IF;
742:

Line 743: wf_core.context('FUN_WF_COMMON', 'GET_AME_APPROVERS',

739: SQLERRM || ' Error occurred '||
740: 'for transaction ' || l_transaction_id);
741: END IF;
742:
743: wf_core.context('FUN_WF_COMMON', 'GET_AME_APPROVERS',
744: itemtype, itemkey, TO_CHAR(actid), funcmode);
745: END get_ame_approvers;
746:
747:

Line 924: l_valid_user := fun_wf_common.is_user_valid_approver

920: NULL;
921: END IF;
922:
923: -- For now, call is_valid_approver procedure
924: l_valid_user := fun_wf_common.is_user_valid_approver
925: (p_transaction_id => p_transaction_id,
926: p_user_id => NULL,
927: p_role_name => l_approver_table(l_index).name,
928: p_org_type => p_contact_type,

Line 962: 'fun.plsql.fun_wf_common.get_ame_role_list',

958: THEN
959: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
960: THEN
961: fnd_log.string(FND_LOG.LEVEL_ERROR,
962: 'fun.plsql.fun_wf_common.get_ame_role_list',
963: ' Invalid users found without access to org ' ||
964: 'for transaction ' || p_transaction_id);
965: END IF;
966:

Line 1027: 'fun.plsql.fun_wf_common.get_ame_role_list',

1023: THEN
1024: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1025: THEN
1026: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
1027: 'fun.plsql.fun_wf_common.get_ame_role_list',
1028: SQLERRM || ' Error occurred '||
1029: 'for transaction ' || p_transaction_id);
1030: END IF;
1031:

Line 1374: 'fun.plsql.fun_wf_common.set_invoice_reqd_flag',

1370: THEN
1371: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1372: THEN
1373: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
1374: 'fun.plsql.fun_wf_common.set_invoice_reqd_flag',
1375: SQLERRM || ' Error occurred '||
1376: 'for batch ' || p_batch_id);
1377: END IF;
1378:

Line 1468: END FUN_WF_COMMON;

1464: RAISE;
1465:
1466: END wf_abort;
1467:
1468: END FUN_WF_COMMON;