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_DEBUG

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 486: pa_debug.reset_err_stack;

482: x_msg_count := l_msg_count;
483: ELSE
484: x_msg_count := l_msg_count;
485: END IF;
486: pa_debug.reset_err_stack;
487: RETURN;
488: END IF;
489: -- Get the approvers user name
490: IF p_approver1_person_id IS NOT NULL THEN

Line 1461: p_procedure_name => pa_debug.g_err_stack );

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 ;
1465:

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 1531: pa_debug.reset_err_stack;

1527: x_msg_count := l_msg_count;
1528: ELSE
1529: x_msg_count := l_msg_count;
1530: END IF;
1531: pa_debug.reset_err_stack;
1532: x_return_status := FND_API.G_RET_STS_ERROR;
1533: RETURN;
1534: END IF;
1535:

Line 1562: p_procedure_name => pa_debug.g_err_stack );

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 ;
1566: END Get_workflow_process_info ;

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 1751: pa_debug.reset_err_stack;

1747: , itemkey => itemkey
1748: , aname => 'VIEW_CONFLICT_URL_INFO'
1749: , avalue => l_view_conflict_url );
1750:
1751: pa_debug.reset_err_stack;
1752:
1753: EXCEPTION
1754: WHEN OTHERS THEN
1755: WF_CORE.CONTEXT

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 1883: pa_debug.reset_err_stack;

1879: raise_application_error(-20001, l_error_message_code);
1880: END IF;
1881: END IF;
1882: resultout := wf_engine.eng_completed||':'||'S';
1883: pa_debug.reset_err_stack;
1884: EXCEPTION
1885: WHEN OTHERS THEN
1886: WF_CORE.CONTEXT
1887: ('PA_ASGMT_WFSTD',

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 1959: pa_debug.reset_err_stack;

1955: resultout := wf_engine.eng_completed||':'||'F';
1956: RETURN;
1957: END IF;
1958: resultout := wf_engine.eng_completed||':'||'S';
1959: pa_debug.reset_err_stack;
1960:
1961: EXCEPTION
1962: WHEN OTHERS THEN
1963: WF_CORE.CONTEXT

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 2036: pa_debug.reset_err_stack;

2032: resultout := wf_engine.eng_completed||':'||'F';
2033: RETURN;
2034: END IF;
2035: resultout := wf_engine.eng_completed||':'||'S';
2036: pa_debug.reset_err_stack;
2037:
2038: EXCEPTION
2039: WHEN OTHERS THEN
2040: WF_CORE.CONTEXT

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 2125: pa_debug.reset_err_stack;

2121: ELSE
2122: resultout := wf_engine.eng_completed||':'||'N';
2123: END IF;
2124: END IF;
2125: pa_debug.reset_err_stack;
2126: EXCEPTION
2127: WHEN OTHERS THEN
2128: WF_CORE.CONTEXT
2129: ('PA_ASGMT_WFSTD',

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 2233: pa_debug.reset_err_stack;

2229: , itemkey => itemkey
2230: , aname => 'NUMBER_OF_APPROVERS'
2231: , avalue => l_number_of_approvers
2232: );
2233: pa_debug.reset_err_stack;
2234:
2235: EXCEPTION
2236: WHEN OTHERS THEN
2237: WF_CORE.CONTEXT

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 2375: pa_debug.reset_err_stack;

2371: WHERE item_type = itemtype
2372: AND item_key = itemkey
2373: AND object_id1 = l_assignment_id;
2374: resultout := wf_engine.eng_completed||':'||'S';
2375: pa_debug.reset_err_stack;
2376: EXCEPTION
2377: WHEN OTHERS THEN
2378: WF_CORE.CONTEXT
2379: ('PA_ASGMT_WFSTD',

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 4467: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171

4463: l_ntfy_apprvl_recipient_name pa_wf_ntf_performers.user_name%TYPE; --- Commented for 3267790 fnd_user.user_name%TYPE; --used to set NTFY_APPRVL_RECIPIENT_NAME attribute
4464: l_prev_user fnd_user.user_name%TYPE; --used to set FORWARDED_FROM attribute
4465: l_number_of_assignments NUMBER;
4466: l_mass_approve_url VARCHAR2(2000); --Mass Approve page URL
4467: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
4468:
4469: BEGIN
4470:
4471: -- Initialize the Error Stack

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 4476: PA_DEBUG.write_log

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
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;

Line 4751: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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;
4755: END start_mass_approval_flow;

Line 4895: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171

4891:
4892: l_prev_asgmt_info_rec l_prev_asgmt_info_csr%ROWTYPE;
4893: l_assignments_rec l_assignments_csr%ROWTYPE;
4894: l_resource_rec l_resource_csr%ROWTYPE;
4895: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
4896:
4897: BEGIN
4898:
4899: -- Initialize the Error Stack

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 4904: PA_DEBUG.write_log

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
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;

Line 5437: PA_DEBUG.Reset_Err_Stack;

5433: ,p_msg_index_out => l_msg_index_out );
5434: END IF;
5435:
5436: -- Reset the error stack when returning to the calling program
5437: PA_DEBUG.Reset_Err_Stack;
5438:
5439: -- If g_error_exists is TRUE then set the x_return_status to 'E'
5440: IF FND_MSG_PUB.Count_Msg >0 THEN
5441: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5453: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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;
5457: END process_res_fyi_notification;

Line 5983: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171

5979: FROM pa_wf_ntf_performers
5980: WHERE wf_type_code = 'MASS_APPROVAL_FYI'
5981: AND group_id = p_group_id;
5982: l_notified_id NUMBER;
5983: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
5984:
5985: BEGIN
5986:
5987: -- Initialize the Error Stack

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 5992: PA_DEBUG.write_log

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
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;

Line 6022: PA_DEBUG.write_log

6018: IF l_admin_project = 'N' THEN
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;

Line 6409: PA_DEBUG.Reset_Err_Stack;

6405: ,p_msg_index_out => l_msg_index_out );
6406: END IF;
6407:
6408: -- Reset the error stack when returning to the calling program
6409: PA_DEBUG.Reset_Err_Stack;
6410:
6411: -- If g_error_exists is TRUE then set the x_return_status to 'E'
6412: IF FND_MSG_PUB.Count_Msg >0 THEN
6413: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6422: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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;
6426: END process_mgr_fyi_notification;

Line 6465: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171

6461: l_update_info_doc VARCHAR2(2000);
6462: l_submitter_user_name fnd_user.user_name%type; /* Commeted for bug 3261755 VARCHAR2(30); */
6463: l_note_to_approvers VARCHAR2(2000);
6464: l_forwarded_from fnd_user.user_name%type; /* Commeted for bug 3261755 VARCHAR2(30); */
6465: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
6466:
6467: BEGIN
6468: log_message('Inside mass_process_approval_result_wf');
6469:

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 6475: PA_DEBUG.write_log

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
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;

Line 6601: PA_DEBUG.Reset_Err_Stack;

6597: ,p_msg_index_out => l_msg_index_out );
6598: END IF;
6599:
6600: -- Reset the error stack when returning to the calling program
6601: PA_DEBUG.Reset_Err_Stack;
6602:
6603: -- If g_error_exists is TRUE then set the x_return_status to 'E'
6604: IF FND_MSG_PUB.Count_Msg >0 THEN
6605: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6614: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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;
6618: END process_approval_result_wf;

Line 7349: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171

7345:
7346: NO_ASSIGNMENT_ERRORS EXCEPTION;
7347:
7348: l_override_basis_name VARCHAR2(80) := NULL;
7349: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
7350:
7351:
7352: BEGIN
7353:

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 7359: PA_DEBUG.write_log

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
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;

Line 7741: PA_DEBUG.Reset_Err_Stack;

7737: ,p_msg_index_out => l_msg_index_out );
7738: END IF;
7739:
7740: -- Reset the error stack when returning to the calling program
7741: PA_DEBUG.Reset_Err_Stack;
7742:
7743: -- If g_error_exists is TRUE then set the x_return_status to 'E'
7744: IF FND_MSG_PUB.Count_Msg >0 THEN
7745: x_return_status := FND_API.G_RET_STS_ERROR;

Line 7759: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

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;
7763: END process_submitter_notification;

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 7805: pa_debug.reset_err_stack;

7801: resultout := wf_engine.eng_completed||':'||'S';
7802:
7803: END IF;
7804:
7805: pa_debug.reset_err_stack;
7806:
7807: EXCEPTION
7808: WHEN OTHERS THEN
7809: WF_CORE.CONTEXT