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.PA_ASGMT_WFSTD dependencies on PA_ASGMT_WFSTD

Line 1: PACKAGE BODY PA_ASGMT_WFSTD AS

1: PACKAGE BODY PA_ASGMT_WFSTD AS
2: -- $Header: PAWFAAPB.pls 120.13.12010000.9 2008/12/12 09:16:02 kjai ship $
3: -- forward declarations
4: --------------------------------------------------------------------------------------------------------------
5: -- This procedure prints the text which is being passed as the input

Line 314: pa_debug.init_err_stack ('pa_asgmt_wfstd.start_workflow');

310: fnd_msg_pub.count_msg);
311: END IF;
312: */
313: fnd_msg_pub.initialize;
314: pa_debug.init_err_stack ('pa_asgmt_wfstd.start_workflow');
315: x_msg_count := 0;
316: -- Create the unique item key to launch WF with
317: SELECT pa_prm_wf_item_key_s.nextval
318: INTO l_itemkey

Line 628: , avalue => PA_ASGMT_WFSTD.G_SINGLE_APPROVAL );

624: wf_engine.SetItemAttrText
625: ( itemtype => p_wf_item_type
626: , itemkey => l_itemkey
627: , aname => 'APPROVAL_TYPE'
628: , avalue => PA_ASGMT_WFSTD.G_SINGLE_APPROVAL );
629:
630: -- Now set the values as appropriate in the WF attributes
631: -- Set Project details attributes
632: wf_engine.SetItemAttrNumber

Line 1460: (p_pkg_name => 'PA_ASGMT_WFSTD',

1456: x_msg_data := SUBSTRB(SQLERRM,1,240);
1457: x_error_message_code := SQLCODE ;
1458: -- 4537865 : End
1459: fnd_msg_pub.add_exc_msg
1460: (p_pkg_name => 'PA_ASGMT_WFSTD',
1461: p_procedure_name => pa_debug.g_err_stack );
1462: x_msg_count := fnd_msg_pub.count_msg;
1463: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1464: END Start_Workflow ;

Line 1502: pa_debug.init_err_stack ('pa_asgmt_wfstd.get_workflow_process_info');

1498: -- workflow is an APPROVAL WORKFLOW. else if the status
1499: -- is an APPROVED or REJECTED status, the workflow is a FYI only
1500: x_return_status := FND_API.G_RET_STS_SUCCESS;
1501: x_msg_count := 0;
1502: pa_debug.init_err_stack ('pa_asgmt_wfstd.get_workflow_process_info');
1503: OPEN l_stus_csr;
1504: FETCH l_stus_csr INTO l_stus_rec;
1505: IF l_stus_csr%NOTFOUND THEN
1506: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1561: (p_pkg_name => 'PA_ASGMT_WFSTD',

1557: x_wf_type := NULL ;
1558:
1559: -- 4537865 : End
1560: fnd_msg_pub.add_exc_msg
1561: (p_pkg_name => 'PA_ASGMT_WFSTD',
1562: p_procedure_name => pa_debug.g_err_stack );
1563: x_msg_count := fnd_msg_pub.count_msg;
1564: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1565: RAISE ;

Line 1616: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_URL');

1612:
1613: l_asgmt_type pa_project_assignments.assignment_type%TYPE; /*Added for bug 6408552*/
1614: BEGIN
1615:
1616: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_URL');
1617: -- Return if WF Not Running
1618: IF (funcmode <> wf_engine.eng_run) THEN
1619: resultout := wf_engine.eng_null;
1620: RETURN;

Line 1756: ('PA_ASGMT_WFSTD',

1752:
1753: EXCEPTION
1754: WHEN OTHERS THEN
1755: WF_CORE.CONTEXT
1756: ('PA_ASGMT_WFSTD',
1757: 'Generate_URL',
1758: itemtype,
1759: itemkey,
1760: to_char(actid),

Line 1792: ('PA_ASGMT_WFSTD',

1788: );
1789: EXCEPTION
1790: WHEN OTHERS THEN
1791: WF_CORE.CONTEXT
1792: ('PA_ASGMT_WFSTD',
1793: 'Generate_URL_Failure',
1794: itemtype,
1795: itemkey,
1796: to_char(actid),

Line 1820: pa_debug.init_err_stack ('pa_asgmt_wfstd.start_new_wf');

1816: l_msg_data VARCHAR2(200);
1817: l_error_message_code VARCHAR2(200);
1818: l_return_status VARCHAR2(30);
1819: BEGIN
1820: pa_debug.init_err_stack ('pa_asgmt_wfstd.start_new_wf');
1821: -- Return if WF Not Running
1822: IF (funcmode <> wf_engine.eng_run) THEN
1823: resultout := wf_engine.eng_null;
1824: RETURN;

Line 1887: ('PA_ASGMT_WFSTD',

1883: pa_debug.reset_err_stack;
1884: EXCEPTION
1885: WHEN OTHERS THEN
1886: WF_CORE.CONTEXT
1887: ('PA_ASGMT_WFSTD',
1888: 'Start_New_WF',
1889: itemtype,
1890: itemkey,
1891: to_char(actid),

Line 1914: pa_debug.init_err_stack ('pa_asgmt_wfstd.Set_Success_Status');

1910: l_return_status VARCHAR2(30);
1911: l_schedule_exception_id NUMBER;
1912: l_is_new_assignment_flag VARCHAR2(1);
1913: BEGIN
1914: pa_debug.init_err_stack ('pa_asgmt_wfstd.Set_Success_Status');
1915: -- Return if WF Not Running
1916: IF (funcmode <> wf_engine.eng_run) THEN
1917: resultout := wf_engine.eng_null;
1918: RETURN;

Line 1964: ('PA_ASGMT_WFSTD',

1960:
1961: EXCEPTION
1962: WHEN OTHERS THEN
1963: WF_CORE.CONTEXT
1964: ('PA_ASGMT_WFSTD',
1965: 'Set_Success_Status',
1966: itemtype,
1967: itemkey,
1968: to_char(actid),

Line 1991: pa_debug.init_err_stack ('pa_asgmt_wfstd.Set_Failure_Status');

1987: l_return_status VARCHAR2(30);
1988: l_schedule_exception_id pa_schedule_exceptions.schedule_exception_id%TYPE;
1989: l_is_new_assignment_flag VARCHAR2(1);
1990: BEGIN
1991: pa_debug.init_err_stack ('pa_asgmt_wfstd.Set_Failure_Status');
1992: -- Return if WF Not Running
1993: IF (funcmode <> wf_engine.eng_run) THEN
1994: resultout := wf_engine.eng_null;
1995: RETURN;

Line 2041: ('PA_ASGMT_WFSTD',

2037:
2038: EXCEPTION
2039: WHEN OTHERS THEN
2040: WF_CORE.CONTEXT
2041: ('PA_ASGMT_WFSTD',
2042: 'Set_Failure_Status',
2043: itemtype,
2044: itemkey,
2045: to_char(actid),

Line 2078: pa_debug.init_err_stack ('pa_asgmt_wfstd.Check_Wf_Enabled');

2074: else
2075: set the new wf item type and new wf process attr
2076: resultout = 'T'
2077: */
2078: pa_debug.init_err_stack ('pa_asgmt_wfstd.Check_Wf_Enabled');
2079: -- Return if WF Not Running
2080: IF (funcmode <> wf_engine.eng_run) THEN
2081: resultout := wf_engine.eng_null;
2082: RETURN;

Line 2129: ('PA_ASGMT_WFSTD',

2125: pa_debug.reset_err_stack;
2126: EXCEPTION
2127: WHEN OTHERS THEN
2128: WF_CORE.CONTEXT
2129: ('PA_ASGMT_WFSTD',
2130: 'Check_Wf_Enabled',
2131: itemtype,
2132: itemkey,
2133: to_char(actid),

Line 2158: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_Approvers');

2154: l_approver_type VARCHAR2(30);
2155: l_item_attr_name VARCHAR2(30);
2156: l_approvers_list_tbl_idx NUMBER := 1;
2157: BEGIN
2158: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_Approvers');
2159: -- Return if WF Not Running
2160: IF (funcmode <> wf_engine.eng_run) THEN
2161: resultout := wf_engine.eng_null;
2162: RETURN;

Line 2238: ('PA_ASGMT_WFSTD',

2234:
2235: EXCEPTION
2236: WHEN OTHERS THEN
2237: WF_CORE.CONTEXT
2238: ('PA_ASGMT_WFSTD',
2239: 'Generate_Approvers',
2240: itemtype,
2241: itemkey,
2242: to_char(actid),

Line 2274: pa_debug.init_err_stack ('pa_asgmt_wfstd.get_approver');

2270: Set approvals loop counter
2271: Resultout = 'S'
2272: */
2273: -- Return if WF Not Running
2274: pa_debug.init_err_stack ('pa_asgmt_wfstd.get_approver');
2275: IF (funcmode <> wf_engine.eng_run) THEN
2276: resultout := wf_engine.eng_null;
2277: RETURN;
2278: END IF;

Line 2379: ('PA_ASGMT_WFSTD',

2375: pa_debug.reset_err_stack;
2376: EXCEPTION
2377: WHEN OTHERS THEN
2378: WF_CORE.CONTEXT
2379: ('PA_ASGMT_WFSTD',
2380: 'Get_Approver',
2381: itemtype,
2382: itemkey,
2383: to_char(actid),

Line 2419: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_apprvl_nf_recipients');

2415: BEGIN
2416: -- This will not do anything in milestone 1. In version 1
2417: -- appropriate client extensions will be called
2418:
2419: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_apprvl_nf_recipients');
2420: -- Return if WF Not Running
2421: IF (funcmode <> wf_engine.eng_run) THEN
2422: resultout := wf_engine.eng_null;
2423: RETURN;

Line 2526: ('PA_ASGMT_WFSTD',

2522:
2523: EXCEPTION
2524: WHEN OTHERS THEN
2525: WF_CORE.CONTEXT
2526: ('PA_ASGMT_WFSTD',
2527: 'Generate_apprvl_nf_recipients',
2528: itemtype,
2529: itemkey,
2530: to_char(actid),

Line 2620: ('PA_ASGMT_WFSTD',

2616: resultout := wf_engine.eng_completed||':'||'S';
2617: EXCEPTION
2618: WHEN OTHERS THEN
2619: WF_CORE.CONTEXT
2620: ('PA_ASGMT_WFSTD',
2621: 'Get_Approval_NF_Recipient',
2622: itemtype,
2623: itemkey,
2624: to_char(actid),

Line 2762: ('PA_ASGMT_WFSTD',

2758: END IF;
2759: EXCEPTION
2760: WHEN OTHERS THEN
2761: WF_CORE.CONTEXT
2762: ('PA_ASGMT_WFSTD',
2763: 'Generate_reject_nf_recipients',
2764: itemtype,
2765: itemkey,
2766: to_char(actid),

Line 2856: ('PA_ASGMT_WFSTD',

2852: resultout := wf_engine.eng_completed||':'||'S';
2853: EXCEPTION
2854: WHEN OTHERS THEN
2855: WF_CORE.CONTEXT
2856: ('PA_ASGMT_WFSTD',
2857: 'Get_Reject_NF_Recipient',
2858: itemtype,
2859: itemkey,
2860: to_char(actid),

Line 3011: ('PA_ASGMT_WFSTD',

3007: END IF;
3008: EXCEPTION
3009: WHEN OTHERS THEN
3010: WF_CORE.CONTEXT
3011: ('PA_ASGMT_WFSTD',
3012: 'Generate_cancel_nf_recipients',
3013: itemtype,
3014: itemkey,
3015: to_char(actid),

Line 3106: ('PA_ASGMT_WFSTD',

3102: resultout := wf_engine.eng_completed||':'||'S';
3103: EXCEPTION
3104: WHEN OTHERS THEN
3105: WF_CORE.CONTEXT
3106: ('PA_ASGMT_WFSTD',
3107: 'Get_Cancel_NF_Recipient',
3108: itemtype,
3109: itemkey,
3110: to_char(actid),

Line 3158: ('PA_ASGMT_WFSTD',

3154: );
3155: EXCEPTION
3156: WHEN OTHERS THEN
3157: WF_CORE.CONTEXT
3158: ('PA_ASGMT_WFSTD',
3159: 'Set_Forwarded_From',
3160: itemtype,
3161: itemkey,
3162: to_char(actid),

Line 3207: ('PA_ASGMT_WFSTD',

3203:
3204: EXCEPTION
3205: WHEN OTHERS THEN
3206: WF_CORE.CONTEXT
3207: ('PA_ASGMT_WFSTD',
3208: 'Set_Approval_Reqd_Msg',
3209: itemtype,
3210: itemkey,
3211: to_char(actid),

Line 3242: ('PA_ASGMT_WFSTD',

3238:
3239: EXCEPTION
3240: WHEN OTHERS THEN
3241: WF_CORE.CONTEXT
3242: ('PA_ASGMT_WFSTD',
3243: 'Set_Approved_Msg',
3244: itemtype,
3245: itemkey,
3246: to_char(actid),

Line 3277: ('PA_ASGMT_WFSTD',

3273: p_msg_type => 'REJECTION_FYI');
3274: EXCEPTION
3275: WHEN OTHERS THEN
3276: WF_CORE.CONTEXT
3277: ('PA_ASGMT_WFSTD',
3278: 'Set_Rejected_Msg',
3279: itemtype,
3280: itemkey,
3281: to_char(actid),

Line 3313: ('PA_ASGMT_WFSTD',

3309: p_msg_type => 'CANCELLATION_FYI');
3310: EXCEPTION
3311: WHEN OTHERS THEN
3312: WF_CORE.CONTEXT
3313: ('PA_ASGMT_WFSTD',
3314: 'Set_Canceled_Msg',
3315: itemtype,
3316: itemkey,
3317: to_char(actid),

Line 3346: ('PA_ASGMT_WFSTD',

3342: NULL;
3343: EXCEPTION
3344: WHEN invalid_user_exception THEN
3345: WF_CORE.CONTEXT
3346: ('PA_ASGMT_WFSTD',
3347: 'Validate_Forwarded_User',
3348: l_msg_text,
3349: NULL,
3350: NULL,

Line 3356: ('PA_ASGMT_WFSTD',

3352: RAISE;
3353:
3354: WHEN OTHERS THEN
3355: WF_CORE.CONTEXT
3356: ('PA_ASGMT_WFSTD',
3357: 'Validate_Forwarded_User',
3358: itemtype,
3359: itemkey,
3360: to_char(actid),

Line 3386: ('PA_ASGMT_WFSTD',

3382:
3383: EXCEPTION
3384: WHEN OTHERS THEN
3385: WF_CORE.CONTEXT
3386: ('PA_ASGMT_WFSTD',
3387: 'Set_Approval_Pending',
3388: itemtype,
3389: itemkey,
3390: to_char(actid),

Line 3537: ('PA_ASGMT_WFSTD',

3533: , avalue => l_apprvl_status_code);
3534: EXCEPTION
3535: WHEN NO_ASSIGNMENT_ID THEN
3536: WF_CORE.CONTEXT
3537: ('PA_ASGMT_WFSTD',
3538: 'Set_Asgmt_wf_result_status',
3539: p_item_type,
3540: p_item_key,
3541: 'INVALID_ASSIGNMENT_ID',

Line 3706: ('PA_ASGMT_WFSTD',

3702: END IF; --end of checking in 'TRANSFER'/'FORWARD' mode
3703: exception
3704: WHEN OTHERS THEN
3705: wf_core.context
3706: ('PA_ASGMT_WFSTD',
3707: 'Capture_approver_comment',
3708: itemtype,
3709: itemkey);
3710: RAISE;

Line 3769: ('PA_ASGMT_WFSTD',

3765: p_rect_type => NULL );
3766: EXCEPTION
3767: WHEN OTHERS THEN
3768: wf_core.context
3769: ('PA_ASGMT_WFSTD',
3770: 'Populate_approval_NF_comments' ,
3771: itemtype,
3772: itemkey);
3773: RAISE;

Line 3838: wf_core.context('PA_ASGMT_WFSTD','Generate_sch_err_msg',Document_id,NULL);

3834: END IF;
3835:
3836: exception
3837: WHEN OTHERS THEN
3838: wf_core.context('PA_ASGMT_WFSTD','Generate_sch_err_msg',Document_id,NULL);
3839: RAISE;
3840: END generate_sch_err_msg;
3841:
3842: PROCEDURE set_nf_error_msg_attr (p_item_type IN VARCHAR2,

Line 4472: PA_DEBUG.init_err_stack('PA_ASGMT_WFSTD.start_mass_approval_flow');

4468:
4469: BEGIN
4470:
4471: -- Initialize the Error Stack
4472: PA_DEBUG.init_err_stack('PA_ASGMT_WFSTD.start_mass_approval_flow');
4473:
4474: --Log Message
4475: IF l_debug_mode = 'Y' THEN -- 5345171
4476: PA_DEBUG.write_log

Line 4477: ( x_module => 'pa.plsql.PA_ASGMT_WFSTD.start_mass_approval_flow.begin'

4473:
4474: --Log Message
4475: IF l_debug_mode = 'Y' THEN -- 5345171
4476: PA_DEBUG.write_log
4477: ( x_module => 'pa.plsql.PA_ASGMT_WFSTD.start_mass_approval_flow.begin'
4478: ,x_msg => 'Beginning of mass approval workflow api'
4479: ,x_log_level => 1);
4480: END IF;
4481:

Line 4631: , avalue => PA_ASGMT_WFSTD.G_MASS_APPROVAL );

4627: wf_engine.SetItemAttrText
4628: ( itemtype => l_wf_item_type
4629: , itemkey => l_itemkey
4630: , aname => 'APPROVAL_TYPE'
4631: , avalue => PA_ASGMT_WFSTD.G_MASS_APPROVAL );
4632:
4633: --Setting Mass Assignments details
4634: wf_engine.SetItemAttrText
4635: ( itemtype => l_wf_item_type

Line 4750: ( p_pkg_name => 'PA_ASGMT_WFSTD.start_mass_Approval_flow'

4746: wf_engine.threshold := l_save_threshold;
4747:
4748: -- Set the excetption Message and the stack
4749: FND_MSG_PUB.add_exc_msg
4750: ( p_pkg_name => 'PA_ASGMT_WFSTD.start_mass_Approval_flow'
4751: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4752:
4753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4754: RAISE;

Line 4900: PA_DEBUG.init_err_stack('PA_ASGMT_WFSTD.process_res_fyi_notification');

4896:
4897: BEGIN
4898:
4899: -- Initialize the Error Stack
4900: PA_DEBUG.init_err_stack('PA_ASGMT_WFSTD.process_res_fyi_notification');
4901:
4902: --Log Message
4903: IF l_debug_mode = 'Y' THEN -- 5345171
4904: PA_DEBUG.write_log

Line 4905: ( x_module => 'pa.plsql.PA_ASGMT_WFSTD.process_res_fyi_notification.begin'

4901:
4902: --Log Message
4903: IF l_debug_mode = 'Y' THEN -- 5345171
4904: PA_DEBUG.write_log
4905: ( x_module => 'pa.plsql.PA_ASGMT_WFSTD.process_res_fyi_notification.begin'
4906: ,x_msg => 'Beginning of mass fyi workflow api'
4907: ,x_log_level => 1);
4908: END IF;
4909: log_message('Inside process res mgr');

Line 5452: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_res_fyi_notification'

5448: wf_engine.threshold := l_save_threshold;
5449:
5450: -- Set the excetption Message and the stack
5451: FND_MSG_PUB.add_exc_msg
5452: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_res_fyi_notification'
5453: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
5454:
5455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5456: RAISE;

Line 5988: PA_DEBUG.init_err_stack('PA_ASGMT_WFSTD.process_mgr_fyi_notification');

5984:
5985: BEGIN
5986:
5987: -- Initialize the Error Stack
5988: PA_DEBUG.init_err_stack('PA_ASGMT_WFSTD.process_mgr_fyi_notification');
5989:
5990: --Log Message
5991: IF l_debug_mode = 'Y' THEN -- 5345171
5992: PA_DEBUG.write_log

Line 5993: ( x_module => 'pa.plsql.PA_ASGMT_WFSTD.process_mgr_fyi_notification.begin'

5989:
5990: --Log Message
5991: IF l_debug_mode = 'Y' THEN -- 5345171
5992: PA_DEBUG.write_log
5993: ( x_module => 'pa.plsql.PA_ASGMT_WFSTD.process_mgr_fyi_notification.begin'
5994: ,x_msg => 'Beginning of mass fyi workflow api'
5995: ,x_log_level => 1);
5996: END IF;
5997:

Line 6023: (x_module => 'pa.plsql.PA_ASGMT_WFSTD.process_mgr_fyi_notification.check_prj_manager.'

6019:
6020: --Log Message
6021: IF l_debug_mode = 'Y' THEN -- 5345171
6022: PA_DEBUG.write_log
6023: (x_module => 'pa.plsql.PA_ASGMT_WFSTD.process_mgr_fyi_notification.check_prj_manager.'
6024: ,x_msg => 'Check if project manger exists.'
6025: ,x_log_level => 1);
6026: END IF;
6027:

Line 6421: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_mgr_fyi_notification'

6417: WHEN OTHERS THEN
6418:
6419: -- Set the excetption Message and the stack
6420: FND_MSG_PUB.add_exc_msg
6421: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_mgr_fyi_notification'
6422: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
6423:
6424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6425: RAISE;

Line 6471: PA_DEBUG.init_err_stack('PA_ASGMT_WFSTD.mass_process_approval_result_wf');

6467: BEGIN
6468: log_message('Inside mass_process_approval_result_wf');
6469:
6470: -- Initialize the Error Stack
6471: PA_DEBUG.init_err_stack('PA_ASGMT_WFSTD.mass_process_approval_result_wf');
6472:
6473: --Log Message
6474: IF l_debug_mode = 'Y' THEN -- 5345171
6475: PA_DEBUG.write_log

Line 6476: ( x_module => 'pa.plsql.PA_ASGMT_WFSTD.mass_process_approval_result_wf.begin'

6472:
6473: --Log Message
6474: IF l_debug_mode = 'Y' THEN -- 5345171
6475: PA_DEBUG.write_log
6476: ( x_module => 'pa.plsql.PA_ASGMT_WFSTD.mass_process_approval_result_wf.begin'
6477: ,x_msg => 'Beginning of mass_assignment_approval'
6478: ,x_log_level => 1);
6479: END IF;
6480:

Line 6613: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_approval_result_wf'

6609: WHEN OTHERS THEN
6610:
6611: -- Set the excetption Message and the stack
6612: FND_MSG_PUB.add_exc_msg
6613: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_approval_result_wf'
6614: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
6615:
6616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6617: RAISE;

Line 7355: PA_DEBUG.init_err_stack('PA_ASGMT_WFSTD.process_submitter_notification');

7351:
7352: BEGIN
7353:
7354: -- Initialize the Error Stack
7355: PA_DEBUG.init_err_stack('PA_ASGMT_WFSTD.process_submitter_notification');
7356:
7357: --Log Message
7358: IF l_debug_mode = 'Y' THEN -- 5345171
7359: PA_DEBUG.write_log

Line 7360: ( x_module => 'pa.plsql.PA_ASGMT_WFSTD.process_submitter_notification.begin'

7356:
7357: --Log Message
7358: IF l_debug_mode = 'Y' THEN -- 5345171
7359: PA_DEBUG.write_log
7360: ( x_module => 'pa.plsql.PA_ASGMT_WFSTD.process_submitter_notification.begin'
7361: ,x_msg => 'Beginning of mass fyi workflow api'
7362: ,x_log_level => 1);
7363: END IF;
7364:

Line 7758: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_submitter_notification'

7754: wf_engine.threshold := l_save_threshold;
7755:
7756: -- Set the excetption Message and the stack
7757: FND_MSG_PUB.add_exc_msg
7758: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_submitter_notification'
7759: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
7760:
7761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7762: RAISE;

Line 7782: pa_debug.init_err_stack ('pa_asgmt_wfstd.Check_approval_type');

7778: l_approval_type VARCHAR2(10);
7779:
7780: BEGIN
7781:
7782: pa_debug.init_err_stack ('pa_asgmt_wfstd.Check_approval_type');
7783:
7784: -- Return if WF Not Running
7785: IF (funcmode <> wf_engine.eng_run) THEN
7786: resultout := wf_engine.eng_null;

Line 7795: IF l_approval_type = PA_ASGMT_WFSTD.G_MASS_APPROVAL THEN

7791: (itemtype => itemtype,
7792: itemkey => itemkey,
7793: aname => 'APPROVAL_TYPE');
7794:
7795: IF l_approval_type = PA_ASGMT_WFSTD.G_MASS_APPROVAL THEN
7796:
7797: resultout := wf_engine.eng_completed||':'||'M';
7798:
7799: ELSIF l_approval_type = PA_ASGMT_WFSTD.G_SINGLE_APPROVAL THEN

Line 7799: ELSIF l_approval_type = PA_ASGMT_WFSTD.G_SINGLE_APPROVAL THEN

7795: IF l_approval_type = PA_ASGMT_WFSTD.G_MASS_APPROVAL THEN
7796:
7797: resultout := wf_engine.eng_completed||':'||'M';
7798:
7799: ELSIF l_approval_type = PA_ASGMT_WFSTD.G_SINGLE_APPROVAL THEN
7800:
7801: resultout := wf_engine.eng_completed||':'||'S';
7802:
7803: END IF;

Line 7810: ('PA_ASGMT_WFSTD',

7806:
7807: EXCEPTION
7808: WHEN OTHERS THEN
7809: WF_CORE.CONTEXT
7810: ('PA_ASGMT_WFSTD',
7811: 'Check_approval_type',
7812: itemtype,
7813: itemkey,
7814: to_char(actid),

Line 7992: Wf_Core.Context('PA_ASGMT_WFSTD','Check_Notification_Completed',itemtype,itemkey,to_char(actid),funcmode);

7988: END IF; --end timeout case
7989: -- 4537865 : Included Exception Block
7990: EXCEPTION
7991: WHEN OTHERS THEN
7992: Wf_Core.Context('PA_ASGMT_WFSTD','Check_Notification_Completed',itemtype,itemkey,to_char(actid),funcmode);
7993: RAISE;
7994: END Check_Notification_Completed ;
7995:
7996: PROCEDURE Set_Submitter_User_Name

Line 8036: Wf_Core.Context('PA_ASGMT_WFSTD','Set_Submitter_User_Name',p_item_type,p_item_key,to_char(p_actid),p_funcmode);

8032: log_message('After Set_Submitter_User_Name');
8033: -- 4537865 : Included Exception Block
8034: EXCEPTION
8035: WHEN OTHERS THEN
8036: Wf_Core.Context('PA_ASGMT_WFSTD','Set_Submitter_User_Name',p_item_type,p_item_key,to_char(p_actid),p_funcmode);
8037: RAISE;
8038: END Set_Submitter_User_Name;
8039:
8040: --if there is an unexpected error then the sysadmin can choose to abort or retry

Line 8152: END PA_ASGMT_WFSTD;

8148: RAISE;
8149:
8150: END Abort_Remaining_Trx;
8151:
8152: END PA_ASGMT_WFSTD;