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 155: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

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

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

907: cdl_fully_reversible BOOLEAN; -- This flag will indicate if the
908: -- project asset line is fully reversed
909: x_translated_reversal VARCHAR2(80);
910: -- Fix for bug : 4878878
911: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
912: BEGIN
913:
914: x_err_code := 0;
915: x_err_stage := 'Reversing the Asset Lines';

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

1310: assetlinerec selassetlines%ROWTYPE;
1311: curr_asset_line_detail_id NUMBER;
1312: update_detail_lines BOOLEAN;
1313: -- Fix for bug : 4878878
1314: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
1315:
1316: BEGIN
1317:
1318: x_err_code := 0;

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

2180: l_asset_v boolean;
2181: l_profile_no_dpis varchar2(1); /* Added for bug 6788325 */
2182: orig_asset_id number(15);
2183: client_asset_id number(15);
2184: v_crl_profile varchar2(1) := NVL(FND_PROFILE.value('PA_CRL_LICENSED'), 'N'); /*bug5523708*/
2185: l_call_vi_info VARCHAR2(1):='Y'; /* Added for bug 7428263 */
2186: curr_doc_distribution_type pa_expenditure_items.document_distribution_type%TYPE; --Bug 13602288: self assessed tax enhancement
2187:
2188: -- Fix for bug : 4878878

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

2185: l_call_vi_info VARCHAR2(1):='Y'; /* Added for bug 7428263 */
2186: curr_doc_distribution_type pa_expenditure_items.document_distribution_type%TYPE; --Bug 13602288: self assessed tax enhancement
2187:
2188: -- Fix for bug : 4878878
2189: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
2190:
2191: cdlrec t_rec;
2192:
2193: BEGIN

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

2196:
2197: first_rec := TRUE;
2198: curr_asset_cost := 0;
2199: l_asset_v :=FALSE;
2200: l_profile_no_dpis := NVL(UPPER(SUBSTR(fnd_profile.value_specific('PA_ASSIGN_ASSET_LINE_WITH_NO_DPIS'), 1, 1)), 'Y');
2201: /* Added for bug 6788325 */
2202:
2203: SELECT pt.capital_cost_type_code
2204: INTO l_amount_type

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

3027: fai.asset_id;
3028:
3029: faassetrec selfaassets%ROWTYPE;
3030: -- Fix for bug : 4878878
3031: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
3032:
3033: v_fa_asset_id PA_PROJECT_ASSETS_ALL.fa_asset_id%TYPE;
3034:
3035:

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

3264: IS
3265: x_inventorial_flag VARCHAR2(3);
3266: l_amortization_start_date DATE;
3267: -- Fix for bug : 4878878
3268: --PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
3269: x_period_of_addition VARCHAR2(1);
3270: x_amort_flag VARCHAR2(3);
3271: -- Start: Added as part of the Bug 13256490
3272: l_ap_distribution_line_number NUMBER;

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

3785: l_po_vendor_id pa_project_asset_lines.po_vendor_id%TYPE;
3786:
3787:
3788: -- Fix for bug : 4878878
3789: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
3790:
3791: BEGIN
3792:
3793: begin

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

4521: x_err_stage VARCHAR2(120);
4522: x_err_code NUMBER;
4523: x_capital_cost_type_code varchar2(1) ;
4524: x_projects_cnt number;
4525: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); Fix for bug : 4878878
4526:
4527: l_ledger_id number;
4528:
4529: BEGIN

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

5044: /* Automatic asset capitalization changes JPULTORAK 04-FEB-03 */
5045: x_ret_rowcount NUMBER;
5046: /* End of Automatic asset capitalization changes */
5047: -- Fix for bug : 4878878
5048: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5049:
5050:
5051: BEGIN
5052:

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

5232: projrec selprjs%ROWTYPE;
5233: x_err_stage VARCHAR2(120);
5234: x_err_code NUMBER;
5235: -- Fix for bug : 4878878
5236: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5237: l_ledger_id NUMBER;
5238:
5239: BEGIN
5240:

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

5365: ) RETURN BOOLEAN IS
5366: dummy number;
5367: v_errbuf varchar2(250);
5368: -- Fix for bug : 4878878
5369: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5370:
5371: BEGIN
5372:
5373: /* ********

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

5998:
5999: no_event_proj_rec no_event_proj_cur%ROWTYPE;*/
6000:
6001: -- Fix for bug : 4878878
6002: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
6003: is_no_event_proj VARCHAR2(1) := 'N'; -- Added for bug 5758490
6004: BEGIN
6005:
6006: x_err_code := 0;