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_FAXFACE dependencies on FND_PROFILE

Line 154: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

150: RETURN NUMBER
151: IS
152: asset_category_id NUMBER;
153: -- Fix for bug : 4878878
154: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
155: BEGIN
156:
157: --Bug 3250512: With receipt accruals the cdl.system_reference2 and cdl.system_reference3 corresponds to
158: --po_header_id and po_distribution_id. Hence need to add another SQL to fetch asset category for

Line 853: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

849: cdl_fully_reversible BOOLEAN; -- This flag will indicate if the
850: -- project asset line is fully reversed
851: x_translated_reversal VARCHAR2(80);
852: -- Fix for bug : 4878878
853: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
854: BEGIN
855:
856: x_err_code := 0;
857: x_err_stage := 'Reversing the Asset Lines';

Line 1236: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

1232: assetlinerec selassetlines%ROWTYPE;
1233: curr_asset_line_detail_id NUMBER;
1234: update_detail_lines BOOLEAN;
1235: -- Fix for bug : 4878878
1236: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
1237:
1238: BEGIN
1239:
1240: x_err_code := 0;

Line 1939: v_crl_profile varchar2(1) := NVL(FND_PROFILE.value('PA_CRL_LICENSED'), 'N'); /bug5523708/

1935: l_asset_v boolean;
1936: l_profile_no_dpis varchar2(1); /* Added for bug 6788325 */
1937: orig_asset_id number(15);
1938: client_asset_id number(15);
1939: v_crl_profile varchar2(1) := NVL(FND_PROFILE.value('PA_CRL_LICENSED'), 'N'); /*bug5523708*/
1940:
1941: -- Fix for bug : 4878878
1942: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
1943:

Line 1942: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

1938: client_asset_id number(15);
1939: v_crl_profile varchar2(1) := NVL(FND_PROFILE.value('PA_CRL_LICENSED'), 'N'); /*bug5523708*/
1940:
1941: -- Fix for bug : 4878878
1942: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
1943:
1944: cdlrec t_rec;
1945:
1946: BEGIN

Line 1953: l_profile_no_dpis := NVL(UPPER(SUBSTR(fnd_profile.value_specific('PA_ASSIGN_ASSET_LINE_WITH_NO_DPIS'), 1, 1)), 'Y');

1949:
1950: first_rec := TRUE;
1951: curr_asset_cost := 0;
1952: l_asset_v :=FALSE;
1953: l_profile_no_dpis := NVL(UPPER(SUBSTR(fnd_profile.value_specific('PA_ASSIGN_ASSET_LINE_WITH_NO_DPIS'), 1, 1)), 'Y');
1954: /* Added for bug 6788325 */
1955:
1956: SELECT pt.capital_cost_type_code
1957: INTO l_amount_type

Line 2698: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

2694: fai.asset_id;
2695:
2696: faassetrec selfaassets%ROWTYPE;
2697: -- Fix for bug : 4878878
2698: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
2699:
2700: v_fa_asset_id PA_PROJECT_ASSETS_ALL.fa_asset_id%TYPE;
2701:
2702:

Line 2935: --PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

2931: IS
2932: x_inventorial_flag VARCHAR2(3);
2933: l_amortization_start_date DATE;
2934: -- Fix for bug : 4878878
2935: --PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
2936: x_period_of_addition VARCHAR2(1);
2937: x_amort_flag VARCHAR2(3);
2938:
2939: BEGIN

Line 3417: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

3413: l_depreciation_expense_ccid NUMBER;
3414:
3415:
3416: -- Fix for bug : 4878878
3417: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
3418:
3419: BEGIN
3420:
3421: begin

Line 4141: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); Fix for bug : 4878878

4137: x_err_stage VARCHAR2(120);
4138: x_err_code NUMBER;
4139: x_capital_cost_type_code varchar2(1) ;
4140: x_projects_cnt number;
4141: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); Fix for bug : 4878878
4142:
4143: l_ledger_id number;
4144:
4145: BEGIN

Line 4662: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

4658: /* Automatic asset capitalization changes JPULTORAK 04-FEB-03 */
4659: x_ret_rowcount NUMBER;
4660: /* End of Automatic asset capitalization changes */
4661: -- Fix for bug : 4878878
4662: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4663:
4664:
4665: BEGIN
4666:

Line 4850: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

4846: projrec selprjs%ROWTYPE;
4847: x_err_stage VARCHAR2(120);
4848: x_err_code NUMBER;
4849: -- Fix for bug : 4878878
4850: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4851: l_ledger_id NUMBER;
4852:
4853: BEGIN
4854:

Line 4983: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

4979: ) RETURN BOOLEAN IS
4980: dummy number;
4981: v_errbuf varchar2(250);
4982: -- Fix for bug : 4878878
4983: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4984:
4985: BEGIN
4986:
4987: /* ********

Line 5616: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

5612:
5613: no_event_proj_rec no_event_proj_cur%ROWTYPE;*/
5614:
5615: -- Fix for bug : 4878878
5616: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5617: is_no_event_proj VARCHAR2(1) := 'N'; -- Added for bug 5758490
5618: BEGIN
5619:
5620: x_err_code := 0;