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.26 2011/04/29 18:37:42 svmohamm 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 2159: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_Approvers');

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

Line 2248: ('PA_ASGMT_WFSTD',

2244:
2245: EXCEPTION
2246: WHEN OTHERS THEN
2247: WF_CORE.CONTEXT
2248: ('PA_ASGMT_WFSTD',
2249: 'Generate_Approvers',
2250: itemtype,
2251: itemkey,
2252: to_char(actid),

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

2280: Set approvals loop counter
2281: Resultout = 'S'
2282: */
2283: -- Return if WF Not Running
2284: pa_debug.init_err_stack ('pa_asgmt_wfstd.get_approver');
2285: IF (funcmode <> wf_engine.eng_run) THEN
2286: resultout := wf_engine.eng_null;
2287: RETURN;
2288: END IF;

Line 2389: ('PA_ASGMT_WFSTD',

2385: pa_debug.reset_err_stack;
2386: EXCEPTION
2387: WHEN OTHERS THEN
2388: WF_CORE.CONTEXT
2389: ('PA_ASGMT_WFSTD',
2390: 'Get_Approver',
2391: itemtype,
2392: itemkey,
2393: to_char(actid),

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

2425: BEGIN
2426: -- This will not do anything in milestone 1. In version 1
2427: -- appropriate client extensions will be called
2428:
2429: pa_debug.init_err_stack ('pa_asgmt_wfstd.Generate_apprvl_nf_recipients');
2430: -- Return if WF Not Running
2431: IF (funcmode <> wf_engine.eng_run) THEN
2432: resultout := wf_engine.eng_null;
2433: RETURN;

Line 2537: ('PA_ASGMT_WFSTD',

2533:
2534: EXCEPTION
2535: WHEN OTHERS THEN
2536: WF_CORE.CONTEXT
2537: ('PA_ASGMT_WFSTD',
2538: 'Generate_apprvl_nf_recipients',
2539: itemtype,
2540: itemkey,
2541: to_char(actid),

Line 2631: ('PA_ASGMT_WFSTD',

2627: resultout := wf_engine.eng_completed||':'||'S';
2628: EXCEPTION
2629: WHEN OTHERS THEN
2630: WF_CORE.CONTEXT
2631: ('PA_ASGMT_WFSTD',
2632: 'Get_Approval_NF_Recipient',
2633: itemtype,
2634: itemkey,
2635: to_char(actid),

Line 2777: ('PA_ASGMT_WFSTD',

2773: END IF;
2774: EXCEPTION
2775: WHEN OTHERS THEN
2776: WF_CORE.CONTEXT
2777: ('PA_ASGMT_WFSTD',
2778: 'Generate_reject_nf_recipients',
2779: itemtype,
2780: itemkey,
2781: to_char(actid),

Line 2871: ('PA_ASGMT_WFSTD',

2867: resultout := wf_engine.eng_completed||':'||'S';
2868: EXCEPTION
2869: WHEN OTHERS THEN
2870: WF_CORE.CONTEXT
2871: ('PA_ASGMT_WFSTD',
2872: 'Get_Reject_NF_Recipient',
2873: itemtype,
2874: itemkey,
2875: to_char(actid),

Line 3026: ('PA_ASGMT_WFSTD',

3022: END IF;
3023: EXCEPTION
3024: WHEN OTHERS THEN
3025: WF_CORE.CONTEXT
3026: ('PA_ASGMT_WFSTD',
3027: 'Generate_cancel_nf_recipients',
3028: itemtype,
3029: itemkey,
3030: to_char(actid),

Line 3121: ('PA_ASGMT_WFSTD',

3117: resultout := wf_engine.eng_completed||':'||'S';
3118: EXCEPTION
3119: WHEN OTHERS THEN
3120: WF_CORE.CONTEXT
3121: ('PA_ASGMT_WFSTD',
3122: 'Get_Cancel_NF_Recipient',
3123: itemtype,
3124: itemkey,
3125: to_char(actid),

Line 3173: ('PA_ASGMT_WFSTD',

3169: );
3170: EXCEPTION
3171: WHEN OTHERS THEN
3172: WF_CORE.CONTEXT
3173: ('PA_ASGMT_WFSTD',
3174: 'Set_Forwarded_From',
3175: itemtype,
3176: itemkey,
3177: to_char(actid),

Line 3222: ('PA_ASGMT_WFSTD',

3218:
3219: EXCEPTION
3220: WHEN OTHERS THEN
3221: WF_CORE.CONTEXT
3222: ('PA_ASGMT_WFSTD',
3223: 'Set_Approval_Reqd_Msg',
3224: itemtype,
3225: itemkey,
3226: to_char(actid),

Line 3257: ('PA_ASGMT_WFSTD',

3253:
3254: EXCEPTION
3255: WHEN OTHERS THEN
3256: WF_CORE.CONTEXT
3257: ('PA_ASGMT_WFSTD',
3258: 'Set_Approved_Msg',
3259: itemtype,
3260: itemkey,
3261: to_char(actid),

Line 3292: ('PA_ASGMT_WFSTD',

3288: p_msg_type => 'REJECTION_FYI');
3289: EXCEPTION
3290: WHEN OTHERS THEN
3291: WF_CORE.CONTEXT
3292: ('PA_ASGMT_WFSTD',
3293: 'Set_Rejected_Msg',
3294: itemtype,
3295: itemkey,
3296: to_char(actid),

Line 3328: ('PA_ASGMT_WFSTD',

3324: p_msg_type => 'CANCELLATION_FYI');
3325: EXCEPTION
3326: WHEN OTHERS THEN
3327: WF_CORE.CONTEXT
3328: ('PA_ASGMT_WFSTD',
3329: 'Set_Canceled_Msg',
3330: itemtype,
3331: itemkey,
3332: to_char(actid),

Line 3361: ('PA_ASGMT_WFSTD',

3357: NULL;
3358: EXCEPTION
3359: WHEN invalid_user_exception THEN
3360: WF_CORE.CONTEXT
3361: ('PA_ASGMT_WFSTD',
3362: 'Validate_Forwarded_User',
3363: l_msg_text,
3364: NULL,
3365: NULL,

Line 3371: ('PA_ASGMT_WFSTD',

3367: RAISE;
3368:
3369: WHEN OTHERS THEN
3370: WF_CORE.CONTEXT
3371: ('PA_ASGMT_WFSTD',
3372: 'Validate_Forwarded_User',
3373: itemtype,
3374: itemkey,
3375: to_char(actid),

Line 3401: ('PA_ASGMT_WFSTD',

3397:
3398: EXCEPTION
3399: WHEN OTHERS THEN
3400: WF_CORE.CONTEXT
3401: ('PA_ASGMT_WFSTD',
3402: 'Set_Approval_Pending',
3403: itemtype,
3404: itemkey,
3405: to_char(actid),

Line 3552: ('PA_ASGMT_WFSTD',

3548: , avalue => l_apprvl_status_code);
3549: EXCEPTION
3550: WHEN NO_ASSIGNMENT_ID THEN
3551: WF_CORE.CONTEXT
3552: ('PA_ASGMT_WFSTD',
3553: 'Set_Asgmt_wf_result_status',
3554: p_item_type,
3555: p_item_key,
3556: 'INVALID_ASSIGNMENT_ID',

Line 3721: ('PA_ASGMT_WFSTD',

3717: END IF; --end of checking in 'TRANSFER'/'FORWARD' mode
3718: exception
3719: WHEN OTHERS THEN
3720: wf_core.context
3721: ('PA_ASGMT_WFSTD',
3722: 'Capture_approver_comment',
3723: itemtype,
3724: itemkey);
3725: RAISE;

Line 3784: ('PA_ASGMT_WFSTD',

3780: p_rect_type => NULL );
3781: EXCEPTION
3782: WHEN OTHERS THEN
3783: wf_core.context
3784: ('PA_ASGMT_WFSTD',
3785: 'Populate_approval_NF_comments' ,
3786: itemtype,
3787: itemkey);
3788: RAISE;

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

3849: END IF;
3850:
3851: exception
3852: WHEN OTHERS THEN
3853: wf_core.context('PA_ASGMT_WFSTD','Generate_sch_err_msg',Document_id,NULL);
3854: RAISE;
3855: END generate_sch_err_msg;
3856:
3857: PROCEDURE set_nf_error_msg_attr (p_item_type IN VARCHAR2,

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

4483:
4484: BEGIN
4485:
4486: -- Initialize the Error Stack
4487: PA_DEBUG.init_err_stack('PA_ASGMT_WFSTD.start_mass_approval_flow');
4488:
4489: --Log Message
4490: IF l_debug_mode = 'Y' THEN -- 5345171
4491: PA_DEBUG.write_log

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

4488:
4489: --Log Message
4490: IF l_debug_mode = 'Y' THEN -- 5345171
4491: PA_DEBUG.write_log
4492: ( x_module => 'pa.plsql.PA_ASGMT_WFSTD.start_mass_approval_flow.begin'
4493: ,x_msg => 'Beginning of mass approval workflow api'
4494: ,x_log_level => 1);
4495: END IF;
4496:

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

4642: wf_engine.SetItemAttrText
4643: ( itemtype => l_wf_item_type
4644: , itemkey => l_itemkey
4645: , aname => 'APPROVAL_TYPE'
4646: , avalue => PA_ASGMT_WFSTD.G_MASS_APPROVAL );
4647:
4648: --Setting Mass Assignments details
4649: wf_engine.SetItemAttrText
4650: ( itemtype => l_wf_item_type

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

4762: wf_engine.threshold := l_save_threshold;
4763:
4764: -- Set the excetption Message and the stack
4765: FND_MSG_PUB.add_exc_msg
4766: ( p_pkg_name => 'PA_ASGMT_WFSTD.start_mass_Approval_flow'
4767: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4768:
4769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4770: RAISE;

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

4912:
4913: BEGIN
4914:
4915: -- Initialize the Error Stack
4916: PA_DEBUG.init_err_stack('PA_ASGMT_WFSTD.process_res_fyi_notification');
4917:
4918: --Log Message
4919: IF l_debug_mode = 'Y' THEN -- 5345171
4920: PA_DEBUG.write_log

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

4917:
4918: --Log Message
4919: IF l_debug_mode = 'Y' THEN -- 5345171
4920: PA_DEBUG.write_log
4921: ( x_module => 'pa.plsql.PA_ASGMT_WFSTD.process_res_fyi_notification.begin'
4922: ,x_msg => 'Beginning of mass fyi workflow api'
4923: ,x_log_level => 1);
4924: END IF;
4925: log_message('Inside process res mgr');

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

5464: wf_engine.threshold := l_save_threshold;
5465:
5466: -- Set the excetption Message and the stack
5467: FND_MSG_PUB.add_exc_msg
5468: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_res_fyi_notification'
5469: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
5470:
5471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5472: RAISE;

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

6000:
6001: BEGIN
6002:
6003: -- Initialize the Error Stack
6004: PA_DEBUG.init_err_stack('PA_ASGMT_WFSTD.process_mgr_fyi_notification');
6005:
6006: --Log Message
6007: IF l_debug_mode = 'Y' THEN -- 5345171
6008: PA_DEBUG.write_log

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

6005:
6006: --Log Message
6007: IF l_debug_mode = 'Y' THEN -- 5345171
6008: PA_DEBUG.write_log
6009: ( x_module => 'pa.plsql.PA_ASGMT_WFSTD.process_mgr_fyi_notification.begin'
6010: ,x_msg => 'Beginning of mass fyi workflow api'
6011: ,x_log_level => 1);
6012: END IF;
6013:

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

6035:
6036: --Log Message
6037: IF l_debug_mode = 'Y' THEN -- 5345171
6038: PA_DEBUG.write_log
6039: (x_module => 'pa.plsql.PA_ASGMT_WFSTD.process_mgr_fyi_notification.check_prj_manager.'
6040: ,x_msg => 'Check if project manger exists.'
6041: ,x_log_level => 1);
6042: END IF;
6043:

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

6433: WHEN OTHERS THEN
6434:
6435: -- Set the excetption Message and the stack
6436: FND_MSG_PUB.add_exc_msg
6437: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_mgr_fyi_notification'
6438: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
6439:
6440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6441: RAISE;

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

6483: BEGIN
6484: log_message('Inside mass_process_approval_result_wf');
6485:
6486: -- Initialize the Error Stack
6487: PA_DEBUG.init_err_stack('PA_ASGMT_WFSTD.mass_process_approval_result_wf');
6488:
6489: --Log Message
6490: IF l_debug_mode = 'Y' THEN -- 5345171
6491: PA_DEBUG.write_log

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

6488:
6489: --Log Message
6490: IF l_debug_mode = 'Y' THEN -- 5345171
6491: PA_DEBUG.write_log
6492: ( x_module => 'pa.plsql.PA_ASGMT_WFSTD.mass_process_approval_result_wf.begin'
6493: ,x_msg => 'Beginning of mass_assignment_approval'
6494: ,x_log_level => 1);
6495: END IF;
6496:

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

6625: WHEN OTHERS THEN
6626:
6627: -- Set the excetption Message and the stack
6628: FND_MSG_PUB.add_exc_msg
6629: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_approval_result_wf'
6630: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
6631:
6632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6633: RAISE;

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

7367:
7368: BEGIN
7369:
7370: -- Initialize the Error Stack
7371: PA_DEBUG.init_err_stack('PA_ASGMT_WFSTD.process_submitter_notification');
7372:
7373: --Log Message
7374: IF l_debug_mode = 'Y' THEN -- 5345171
7375: PA_DEBUG.write_log

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

7372:
7373: --Log Message
7374: IF l_debug_mode = 'Y' THEN -- 5345171
7375: PA_DEBUG.write_log
7376: ( x_module => 'pa.plsql.PA_ASGMT_WFSTD.process_submitter_notification.begin'
7377: ,x_msg => 'Beginning of mass fyi workflow api'
7378: ,x_log_level => 1);
7379: END IF;
7380:

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

7770: wf_engine.threshold := l_save_threshold;
7771:
7772: -- Set the excetption Message and the stack
7773: FND_MSG_PUB.add_exc_msg
7774: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_submitter_notification'
7775: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
7776:
7777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7778: RAISE;

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

7794: l_approval_type VARCHAR2(10);
7795:
7796: BEGIN
7797:
7798: pa_debug.init_err_stack ('pa_asgmt_wfstd.Check_approval_type');
7799:
7800: -- Return if WF Not Running
7801: IF (funcmode <> wf_engine.eng_run) THEN
7802: resultout := wf_engine.eng_null;

Line 7811: IF l_approval_type = PA_ASGMT_WFSTD.G_MASS_APPROVAL THEN

7807: (itemtype => itemtype,
7808: itemkey => itemkey,
7809: aname => 'APPROVAL_TYPE');
7810:
7811: IF l_approval_type = PA_ASGMT_WFSTD.G_MASS_APPROVAL THEN
7812:
7813: resultout := wf_engine.eng_completed||':'||'M';
7814:
7815: ELSIF l_approval_type = PA_ASGMT_WFSTD.G_SINGLE_APPROVAL THEN

Line 7815: ELSIF l_approval_type = PA_ASGMT_WFSTD.G_SINGLE_APPROVAL THEN

7811: IF l_approval_type = PA_ASGMT_WFSTD.G_MASS_APPROVAL THEN
7812:
7813: resultout := wf_engine.eng_completed||':'||'M';
7814:
7815: ELSIF l_approval_type = PA_ASGMT_WFSTD.G_SINGLE_APPROVAL THEN
7816:
7817: resultout := wf_engine.eng_completed||':'||'S';
7818:
7819: END IF;

Line 7826: ('PA_ASGMT_WFSTD',

7822:
7823: EXCEPTION
7824: WHEN OTHERS THEN
7825: WF_CORE.CONTEXT
7826: ('PA_ASGMT_WFSTD',
7827: 'Check_approval_type',
7828: itemtype,
7829: itemkey,
7830: to_char(actid),

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

8004: END IF; --end timeout case
8005: -- 4537865 : Included Exception Block
8006: EXCEPTION
8007: WHEN OTHERS THEN
8008: Wf_Core.Context('PA_ASGMT_WFSTD','Check_Notification_Completed',itemtype,itemkey,to_char(actid),funcmode);
8009: RAISE;
8010: END Check_Notification_Completed ;
8011:
8012: PROCEDURE Set_Submitter_User_Name

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

8048: log_message('After Set_Submitter_User_Name');
8049: -- 4537865 : Included Exception Block
8050: EXCEPTION
8051: WHEN OTHERS THEN
8052: Wf_Core.Context('PA_ASGMT_WFSTD','Set_Submitter_User_Name',p_item_type,p_item_key,to_char(p_actid),p_funcmode);
8053: RAISE;
8054: END Set_Submitter_User_Name;
8055:
8056: --if there is an unexpected error then the sysadmin can choose to abort or retry

Line 8168: END PA_ASGMT_WFSTD;

8164: RAISE;
8165:
8166: END Abort_Remaining_Trx;
8167:
8168: END PA_ASGMT_WFSTD;