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

Line 1: PACKAGE BODY gms_wf_pkg AS

1: PACKAGE BODY gms_wf_pkg AS
2: /* $Header: gmsfbuvb.pls 120.8.12010000.3 2009/10/08 11:55:07 byeturi ship $ */
3:
4:
5: -- -------------------------------------------------------------------------------------

Line 495: WF_CORE.CONTEXT('GMS_WF_PKG','REJECT_BUDGET', itemtype, itemkey, to_char(actid), funcmode);

491: EXCEPTION
492:
493: WHEN FND_API.G_EXC_ERROR
494: THEN
495: WF_CORE.CONTEXT('GMS_WF_PKG','REJECT_BUDGET', itemtype, itemkey, to_char(actid), funcmode);
496: RAISE;
497:
498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
499: THEN

Line 500: WF_CORE.CONTEXT('GMS_WF_PKG','REJECT_BUDGET', itemtype, itemkey, to_char(actid), funcmode);

496: RAISE;
497:
498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
499: THEN
500: WF_CORE.CONTEXT('GMS_WF_PKG','REJECT_BUDGET', itemtype, itemkey, to_char(actid), funcmode);
501: RAISE;
502:
503: WHEN OTHERS
504: THEN

Line 505: WF_CORE.CONTEXT('GMS_WF_PKG','REJECT_BUDGET', itemtype, itemkey, to_char(actid), funcmode);

501: RAISE;
502:
503: WHEN OTHERS
504: THEN
505: WF_CORE.CONTEXT('GMS_WF_PKG','REJECT_BUDGET', itemtype, itemkey, to_char(actid), funcmode);
506: RAISE;
507:
508:
509:

Line 692: WF_CORE.CONTEXT('GMS_WF_PKG','SELECT_BUDGET_APPROVER', itemtype, itemkey, to_char(actid), funcmode);

688: EXCEPTION
689:
690: WHEN FND_API.G_EXC_ERROR
691: THEN
692: WF_CORE.CONTEXT('GMS_WF_PKG','SELECT_BUDGET_APPROVER', itemtype, itemkey, to_char(actid), funcmode);
693: RAISE;
694:
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
696: THEN

Line 697: WF_CORE.CONTEXT('GMS_WF_PKG','SELECT_BUDGET_APPROVER', itemtype, itemkey, to_char(actid), funcmode);

693: RAISE;
694:
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
696: THEN
697: WF_CORE.CONTEXT('GMS_WF_PKG','SELECT_BUDGET_APPROVER', itemtype, itemkey, to_char(actid), funcmode);
698: RAISE;
699:
700: WHEN OTHERS
701: THEN

Line 702: WF_CORE.CONTEXT('GMS_WF_PKG','SELECT_BUDGET_APPROVER', itemtype, itemkey, to_char(actid), funcmode);

698: RAISE;
699:
700: WHEN OTHERS
701: THEN
702: WF_CORE.CONTEXT('GMS_WF_PKG','SELECT_BUDGET_APPROVER', itemtype, itemkey, to_char(actid), funcmode);
703: RAISE;
704:
705:
706: END Select_Budget_Approver;

Line 1001: WF_CORE.CONTEXT('GMS_WF_PKG','VERIFY_BUDGET_RULES', itemtype, itemkey, to_char(actid), funcmode);

997: EXCEPTION
998:
999: WHEN FND_API.G_EXC_ERROR
1000: THEN
1001: WF_CORE.CONTEXT('GMS_WF_PKG','VERIFY_BUDGET_RULES', itemtype, itemkey, to_char(actid), funcmode);
1002: RAISE;
1003:
1004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1005: THEN

Line 1006: WF_CORE.CONTEXT('GMS_WF_PKG','VERIFY_BUDGET_RULES', itemtype, itemkey, to_char(actid), funcmode);

1002: RAISE;
1003:
1004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1005: THEN
1006: WF_CORE.CONTEXT('GMS_WF_PKG','VERIFY_BUDGET_RULES', itemtype, itemkey, to_char(actid), funcmode);
1007: RAISE;
1008:
1009: WHEN OTHERS THEN
1010: WF_CORE.CONTEXT('GMS_WF_PKG','VERIFY_BUDGET_RULES', itemtype, itemkey, to_char(actid), funcmode);

Line 1010: WF_CORE.CONTEXT('GMS_WF_PKG','VERIFY_BUDGET_RULES', itemtype, itemkey, to_char(actid), funcmode);

1006: WF_CORE.CONTEXT('GMS_WF_PKG','VERIFY_BUDGET_RULES', itemtype, itemkey, to_char(actid), funcmode);
1007: RAISE;
1008:
1009: WHEN OTHERS THEN
1010: WF_CORE.CONTEXT('GMS_WF_PKG','VERIFY_BUDGET_RULES', itemtype, itemkey, to_char(actid), funcmode);
1011: RAISE;
1012:
1013:
1014: END Verify_Budget_Rules;

Line 1293: WF_CORE.CONTEXT('GMS_WF_PKG','BASELINE_BUDGET', itemtype, itemkey, to_char(actid), funcmode);

1289: -- Business Errors.
1290:
1291: IF (l_err_code <> 0)
1292: THEN
1293: WF_CORE.CONTEXT('GMS_WF_PKG','BASELINE_BUDGET', itemtype, itemkey, to_char(actid), funcmode);
1294: RAISE FND_API.G_EXC_ERROR;
1295: END IF;
1296:
1297:

Line 1325: WF_CORE.CONTEXT('GMS_WF_PKG','BASELINE_BUDGET', itemtype, itemkey, to_char(actid), funcmode);

1321: );
1322:
1323: IF (l_err_code <> 0)
1324: THEN
1325: WF_CORE.CONTEXT('GMS_WF_PKG','BASELINE_BUDGET', itemtype, itemkey, to_char(actid), funcmode);
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327: END IF;
1328:
1329: END IF ; -- OK to Baseline

Line 1587: WF_CORE.CONTEXT('GMS_WF_PKG','FUNDS_CHECK', itemtype, itemkey, to_char(actid), funcmode);

1583: l_prev_baselined_version_id := null;
1584: l_prev_entry_level_code := null;
1585:
1586: when OTHERS then
1587: WF_CORE.CONTEXT('GMS_WF_PKG','FUNDS_CHECK', itemtype, itemkey, to_char(actid), funcmode);
1588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1589: end;
1590: -- Bug 2386041
1591:

Line 1622: WF_CORE.CONTEXT('GMS_WF_PKG','FUNDS_CHECK', itemtype, itemkey, to_char(actid), funcmode);

1618:
1619:
1620: if l_err_code <> 0
1621: then
1622: WF_CORE.CONTEXT('GMS_WF_PKG','FUNDS_CHECK', itemtype, itemkey, to_char(actid), funcmode);
1623: RAISE FND_API.G_EXC_ERROR;
1624: -- Bug 2386041
1625: end if;
1626:

Line 1704: WF_CORE.CONTEXT('GMS_WF_PKG','FUNDS_CHECK', itemtype, itemkey, to_char(actid), funcmode,'1');

1700:
1701: exception
1702: when OTHERS
1703: then
1704: WF_CORE.CONTEXT('GMS_WF_PKG','FUNDS_CHECK', itemtype, itemkey, to_char(actid), funcmode,'1');
1705: RAISE FND_API.G_EXC_ERROR;
1706: end;
1707:
1708:

Line 1809: WF_CORE.CONTEXT('GMS_WF_PKG','FUNDS_CHECK', itemtype, itemkey, to_char(actid), funcmode);

1805: -- Bug 2386041
1806:
1807: if l_return_status <> 'S'
1808: then
1809: WF_CORE.CONTEXT('GMS_WF_PKG','FUNDS_CHECK', itemtype, itemkey, to_char(actid), funcmode);
1810: -- Bug 2386041
1811: update gms_budget_versions
1812: set current_flag = 'Y'
1813: where budget_version_id = l_prev_baselined_version_id;

Line 1868: WF_CORE.CONTEXT('GMS_WF_PKG','FUNDS_CHECK', itemtype, itemkey, to_char(actid), funcmode);

1864: x_award_id => l_award_id);
1865:
1866: if l_err_code <> 0 then -- Checking for 0 (zero) instead of 'S' for Bug:2464800
1867:
1868: WF_CORE.CONTEXT('GMS_WF_PKG','FUNDS_CHECK', itemtype, itemkey, to_char(actid), funcmode);
1869: -- Bug 2386041
1870: update gms_budget_versions
1871: set current_flag = 'Y'
1872: where budget_version_id = l_prev_baselined_version_id;

Line 1930: WF_CORE.CONTEXT('GMS_WF_PKG','FUNDS_CHECK', itemtype, itemkey, to_char(actid), funcmode);

1926: EXCEPTION
1927:
1928: WHEN FND_API.G_EXC_ERROR
1929: THEN
1930: WF_CORE.CONTEXT('GMS_WF_PKG','FUNDS_CHECK', itemtype, itemkey, to_char(actid), funcmode);
1931: resultout := 'COMPLETE:FUNDSCHECK_FAIL';
1932:
1933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1934: THEN

Line 1935: WF_CORE.CONTEXT('GMS_WF_PKG','FUNDS_CHECK', itemtype, itemkey, to_char(actid), funcmode);

1931: resultout := 'COMPLETE:FUNDSCHECK_FAIL';
1932:
1933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1934: THEN
1935: WF_CORE.CONTEXT('GMS_WF_PKG','FUNDS_CHECK', itemtype, itemkey, to_char(actid), funcmode);
1936: resultout := 'COMPLETE:FUNDSCHECK_FAIL';
1937:
1938: WHEN OTHERS
1939: THEN

Line 1940: WF_CORE.CONTEXT('GMS_WF_PKG','FUNDS_CHECK', itemtype, itemkey, to_char(actid), funcmode);

1936: resultout := 'COMPLETE:FUNDSCHECK_FAIL';
1937:
1938: WHEN OTHERS
1939: THEN
1940: WF_CORE.CONTEXT('GMS_WF_PKG','FUNDS_CHECK', itemtype, itemkey, to_char(actid), funcmode);
1941: resultout := 'COMPLETE:FUNDSCHECK_FAIL';
1942:
1943: END Funds_check;
1944:

Line 2285: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - start', 'C');

2281:
2282: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
2283:
2284: IF L_DEBUG = 'Y' THEN
2285: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - start', 'C');
2286: END IF;
2287:
2288: -- Start of code added for Bug 1868293
2289: l_offset_days := p_offset_days;

Line 2308: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - Offset Days = '||to_char(l_offset_days), 'C');

2304:
2305:
2306: If (l_offset_days >= 0) Then -- End of code added for Bug 1868293
2307: IF L_DEBUG = 'Y' THEN
2308: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - Offset Days = '||to_char(l_offset_days), 'C');
2309: END IF;
2310:
2311: open c1;
2312: loop

Line 2349: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - role_name = '||l_role_name, 'C');

2345: l_role_name := l_award_id||'-'||l_report_id; -- change from l_report_name bug 2282107
2346: l_role_name_disp:= l_role_name ;
2347:
2348: IF L_DEBUG = 'Y' THEN
2349: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - role_name = '||l_role_name, 'C');
2350: END IF;
2351: --start bug fix 2204122--
2352: --Commented the following line as this is called from procedure call_gms_debug--
2353: --gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - user_roles = '||l_user_roles, 'C');

Line 2353: --gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - user_roles = '||l_user_roles, 'C');

2349: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - role_name = '||l_role_name, 'C');
2350: END IF;
2351: --start bug fix 2204122--
2352: --Commented the following line as this is called from procedure call_gms_debug--
2353: --gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - user_roles = '||l_user_roles, 'C');
2354: gms_client_extn_budget_wf.call_gms_debug(p_user_roles => l_user_roles
2355: ,p_disp_text =>'GMS_WF_PKG.SCHEDULE_NOTIFICATION - user_roles = ') ;
2356: --end bug fix 2204122--
2357:

Line 2355: ,p_disp_text =>'GMS_WF_PKG.SCHEDULE_NOTIFICATION - user_roles = ') ;

2351: --start bug fix 2204122--
2352: --Commented the following line as this is called from procedure call_gms_debug--
2353: --gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - user_roles = '||l_user_roles, 'C');
2354: gms_client_extn_budget_wf.call_gms_debug(p_user_roles => l_user_roles
2355: ,p_disp_text =>'GMS_WF_PKG.SCHEDULE_NOTIFICATION - user_roles = ') ;
2356: --end bug fix 2204122--
2357:
2358: ----------------------------------------------------------------------------
2359: begin

Line 2373: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - created adhoc role', 'C');

2369: then
2370: NULL;
2371: end;
2372: IF L_DEBUG = 'Y' THEN
2373: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - created adhoc role', 'C');
2374: END IF;
2375: ----------------------------------------------------------------------------
2376:
2377: wf_directory.RemoveUsersFromAdhocRole(role_name => l_role_name);

Line 2380: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - removed users from adhoc role', 'C');

2376:
2377: wf_directory.RemoveUsersFromAdhocRole(role_name => l_role_name);
2378:
2379: IF L_DEBUG = 'Y' THEN
2380: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - removed users from adhoc role', 'C');
2381: END IF;
2382:
2383: begin
2384: --start bug fix 2204122--

Line 2400: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - added users to adhoc role', 'C');

2396: NULL;
2397: end;
2398:
2399: IF L_DEBUG = 'Y' THEN
2400: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - added users to adhoc role', 'C');
2401: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - Calling start_report_wf_process...', 'C');
2402: END IF;
2403:
2404: gms_wf_pkg.start_report_wf_process(

Line 2401: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - Calling start_report_wf_process...', 'C');

2397: end;
2398:
2399: IF L_DEBUG = 'Y' THEN
2400: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - added users to adhoc role', 'C');
2401: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - Calling start_report_wf_process...', 'C');
2402: END IF;
2403:
2404: gms_wf_pkg.start_report_wf_process(
2405: x_award_id => l_award_id,

Line 2404: gms_wf_pkg.start_report_wf_process(

2400: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - added users to adhoc role', 'C');
2401: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - Calling start_report_wf_process...', 'C');
2402: END IF;
2403:
2404: gms_wf_pkg.start_report_wf_process(
2405: x_award_id => l_award_id,
2406: x_award_number => l_award_number,
2407: x_award_short_name => l_award_short_name,
2408: x_installment_number => l_installment_num,

Line 2417: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - After start_report_wf_process...', 'C');

2413: x_err_code => l_err_code,
2414: x_err_stage => l_err_stage);
2415:
2416: IF L_DEBUG = 'Y' THEN
2417: gms_error_pkg.gms_debug('GMS_WF_PKG.SCHEDULE_NOTIFICATION - After start_report_wf_process...', 'C');
2418: END IF;
2419: --start bug fix 2204122--
2420: --As new set of userid's will get stored in l_user_roles. reinitializing the variable--
2421: l_user_roles := NULL ;

Line 2539: gms_wf_pkg.start_installment_wf( x_award_id => x_award_id

2535:
2536: -- l_wf_threshold_orig := wf_engine.threshold;
2537: -- wf_engine.threshold := -1;
2538:
2539: gms_wf_pkg.start_installment_wf( x_award_id => x_award_id
2540: ,x_install_id => x_installment_id
2541: ,x_role => l_role_name
2542: ,x_err_code => l_err_code
2543: ,x_err_stage => l_err_stage);

Line 2885: gms_wf_pkg.Get_Burden_amount(cmt.expenditure_type,

2881: ,cmt.document_type
2882: ,PA_CURRENCY.ROUND_CURRENCY_AMT(SUM (cmt.acct_raw_cost +
2883: DECODE(nvl(cmt.ind_compiled_set_id,0),0,0,
2884: DECODE(NVL(cmt.burdenable_raw_cost,0),0,0,
2885: gms_wf_pkg.Get_Burden_amount(cmt.expenditure_type,
2886: cmt.organization_id,
2887: cmt.ind_compiled_set_id,
2888: cmt.burdenable_raw_cost)
2889: )

Line 3220: avalue => 'PLSQL:GMS_WF_PKG.Get_Inst_Open_Commitments/'||itemtype||':'||to_char(itemkey));

3216:
3217: wf_engine.SetItemAttrtext( itemtype => itemtype,
3218: itemkey => itemkey,
3219: aname => 'CLOSEOUT_MESSAGE',
3220: avalue => 'PLSQL:GMS_WF_PKG.Get_Inst_Open_Commitments/'||itemtype||':'||to_char(itemkey));
3221:
3222: wf_engine.SetItemAttrText ( itemtype => itemtype,
3223: itemkey => itemkey,
3224: aname => 'NOTIF_RECIPIENT_ROLE',

Line 3511: END gms_wf_pkg;

3507: END IF;
3508: --do not exclude
3509: RETURN 'N';
3510: END Excl_Person_From_Notification;
3511: END gms_wf_pkg;