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_FUNDS_CONTROL_PKG dependencies on PA_DEBUG

Line 1269: pa_debug.init_err_stack('PA_FUNDS_CONTROL_PKG.result_status_code_update');

1265:
1266: PRAGMA AUTONOMOUS_TRANSACTION;
1267:
1268: BEGIN
1269: pa_debug.init_err_stack('PA_FUNDS_CONTROL_PKG.result_status_code_update');
1270: /******
1271: -- Added if else condition to avoid full table scan on pa_bc_packets
1272: --EXPLAIN PLAN IS:
1273: --1:UPDATE STATEMENT :(cost=2,rows=1)

Line 1378: PA_DEBUG.reset_err_stack;

1374: /* Commented as part of 13009945 IF cur_pkts%isopen then
1375: close cur_pkts;
1376: END IF; */
1377: commit; -- to end an active autonmous transaction
1378: PA_DEBUG.reset_err_stack;
1379: return;
1380: EXCEPTION
1381: WHEN OTHERS THEN
1382: /* Commented as part of 13009945

Line 1423: pa_debug.g_err_stage := 'Stage :'|| substr(p_stage,1,250);

1419: /* write the debug log only if debug is enabled */
1420: IF g_debug_mode = 'Y' THEN
1421:
1422: IF p_stage is NOT null then
1423: pa_debug.g_err_stage := 'Stage :'|| substr(p_stage,1,250);
1424: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1425: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_PKG','LOG: '||pa_debug.g_err_stage,3);
1426: g_error_stage := substr(p_stage,1,10);
1427: END IF;

Line 1424: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);

1420: IF g_debug_mode = 'Y' THEN
1421:
1422: IF p_stage is NOT null then
1423: pa_debug.g_err_stage := 'Stage :'|| substr(p_stage,1,250);
1424: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1425: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_PKG','LOG: '||pa_debug.g_err_stage,3);
1426: g_error_stage := substr(p_stage,1,10);
1427: END IF;
1428:

Line 1425: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_PKG','LOG: '||pa_debug.g_err_stage,3);

1421:
1422: IF p_stage is NOT null then
1423: pa_debug.g_err_stage := 'Stage :'|| substr(p_stage,1,250);
1424: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1425: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_PKG','LOG: '||pa_debug.g_err_stage,3);
1426: g_error_stage := substr(p_stage,1,10);
1427: END IF;
1428:
1429: IF p_error_msg is NOT NULL then

Line 1430: pa_debug.g_err_stage := 'Error Msg :'||substr(p_error_msg,1,250);

1426: g_error_stage := substr(p_stage,1,10);
1427: END IF;
1428:
1429: IF p_error_msg is NOT NULL then
1430: pa_debug.g_err_stage := 'Error Msg :'||substr(p_error_msg,1,250);
1431: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1432: PA_DEBUG.write
1433: (x_Module => 'pa.plsql.PA_FUNDS_CONTROL_PKG'
1434: ,x_Msg => substr('LOG:'||p_error_msg,1,240)

Line 1431: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);

1427: END IF;
1428:
1429: IF p_error_msg is NOT NULL then
1430: pa_debug.g_err_stage := 'Error Msg :'||substr(p_error_msg,1,250);
1431: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1432: PA_DEBUG.write
1433: (x_Module => 'pa.plsql.PA_FUNDS_CONTROL_PKG'
1434: ,x_Msg => substr('LOG:'||p_error_msg,1,240)
1435: ,x_Log_Level => 3);

Line 1432: PA_DEBUG.write

1428:
1429: IF p_error_msg is NOT NULL then
1430: pa_debug.g_err_stage := 'Error Msg :'||substr(p_error_msg,1,250);
1431: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1432: PA_DEBUG.write
1433: (x_Module => 'pa.plsql.PA_FUNDS_CONTROL_PKG'
1434: ,x_Msg => substr('LOG:'||p_error_msg,1,240)
1435: ,x_Log_Level => 3);
1436: g_error_msg := p_error_msg;

Line 1441: pa_debug.g_err_stage := substr(p_msg_token2,1,250);

1437: END IF;
1438:
1439: IF p_msg_token1 is NOT NULL or p_msg_token2 is NOT NULL then
1440: IF p_msg_token2 is not null then
1441: pa_debug.g_err_stage := substr(p_msg_token2,1,250);
1442: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1443: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_PKG','LOG: '||pa_debug.g_err_stage,3);
1444: END IF;
1445: IF p_msg_token1 is NOT NULL then

Line 1442: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);

1438:
1439: IF p_msg_token1 is NOT NULL or p_msg_token2 is NOT NULL then
1440: IF p_msg_token2 is not null then
1441: pa_debug.g_err_stage := substr(p_msg_token2,1,250);
1442: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1443: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_PKG','LOG: '||pa_debug.g_err_stage,3);
1444: END IF;
1445: IF p_msg_token1 is NOT NULL then
1446: pa_debug.g_err_stage := substr(p_msg_token1,1,250);

Line 1443: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_PKG','LOG: '||pa_debug.g_err_stage,3);

1439: IF p_msg_token1 is NOT NULL or p_msg_token2 is NOT NULL then
1440: IF p_msg_token2 is not null then
1441: pa_debug.g_err_stage := substr(p_msg_token2,1,250);
1442: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1443: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_PKG','LOG: '||pa_debug.g_err_stage,3);
1444: END IF;
1445: IF p_msg_token1 is NOT NULL then
1446: pa_debug.g_err_stage := substr(p_msg_token1,1,250);
1447: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);

Line 1446: pa_debug.g_err_stage := substr(p_msg_token1,1,250);

1442: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1443: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_PKG','LOG: '||pa_debug.g_err_stage,3);
1444: END IF;
1445: IF p_msg_token1 is NOT NULL then
1446: pa_debug.g_err_stage := substr(p_msg_token1,1,250);
1447: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1448: PA_DEBUG.write
1449: (x_Module => 'pa.plsql.PA_FUNDS_CONTROL_PKG'
1450: ,x_Msg => substr('LOG:'||p_msg_token1,1,240)

Line 1447: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);

1443: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_PKG','LOG: '||pa_debug.g_err_stage,3);
1444: END IF;
1445: IF p_msg_token1 is NOT NULL then
1446: pa_debug.g_err_stage := substr(p_msg_token1,1,250);
1447: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1448: PA_DEBUG.write
1449: (x_Module => 'pa.plsql.PA_FUNDS_CONTROL_PKG'
1450: ,x_Msg => substr('LOG:'||p_msg_token1,1,240)
1451: ,x_Log_Level => 3);

Line 1448: PA_DEBUG.write

1444: END IF;
1445: IF p_msg_token1 is NOT NULL then
1446: pa_debug.g_err_stage := substr(p_msg_token1,1,250);
1447: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1448: PA_DEBUG.write
1449: (x_Module => 'pa.plsql.PA_FUNDS_CONTROL_PKG'
1450: ,x_Msg => substr('LOG:'||p_msg_token1,1,240)
1451: ,x_Log_Level => 3);
1452:

Line 1589: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.is_ap_from_project');

1585: log_message(p_msg_token1 => 'Inside the is_ap_from project api');
1586: End If;
1587:
1588: --Initialize the error stack
1589: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.is_ap_from_project');
1590:
1591: x_return_status := 'S';
1592:
1593: IF p_calling_module = 'GL' then

Line 1697: PA_DEBUG.reset_err_stack;

1693: End IF;
1694: IF g_debug_mode = 'Y' THEN
1695: log_message(p_msg_token1 => 'End of is_ap_from_project api');
1696: End If;
1697: PA_DEBUG.reset_err_stack;
1698: commit; -- to end an active autonmous transaction
1699: return;
1700:
1701: EXCEPTION

Line 6464: PA_DEBUG.Set_User_Lock_Mode

6460: log_message(p_msg_token1 => 'Inside the get arrival seq api');
6461: End if;
6462:
6463: ------- Acquire a lock before processing ----------------
6464: PA_DEBUG.Set_User_Lock_Mode
6465: ( x_Lock_Mode => 6
6466: ,x_Commit_Mode => FALSE
6467: ,x_TimeOut => 30);
6468:

Line 6469: l_number := pa_debug.acquire_user_lock('PAFUNDSCHECKLOCKER');

6465: ( x_Lock_Mode => 6
6466: ,x_Commit_Mode => FALSE
6467: ,x_TimeOut => 30);
6468:
6469: l_number := pa_debug.acquire_user_lock('PAFUNDSCHECKLOCKER');
6470: IF g_debug_mode = 'Y' THEN
6471: log_message(p_msg_token1 => 'the value of lock handler = '||l_number);
6472: End if;
6473: If l_number = 0 then

Line 6523: If (pa_debug.release_user_lock('PAFUNDSCHECKLOCKER') = 0) then

6519: End if;
6520: log_message(p_error_msg =>sqlcode||sqlerrm);
6521: END;
6522: ------------- Release the Lock --------------
6523: If (pa_debug.release_user_lock('PAFUNDSCHECKLOCKER') = 0) then
6524: IF g_debug_mode = 'Y' THEN
6525: log_message(p_msg_token1 => 'Released the Lock');
6526: End if;
6527: END If;

Line 6551: If (pa_debug.release_user_lock('PAFUNDSCHECKLOCKER') = 0) then

6547: RETURN nvl(v_arrival_seq,0);
6548:
6549: EXCEPTION
6550: when others then
6551: If (pa_debug.release_user_lock('PAFUNDSCHECKLOCKER') = 0) then
6552: IF g_debug_mode = 'Y' THEN
6553: log_message(p_msg_token1 => 'Released the Lock');
6554: End if;
6555: null;

Line 7796: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.Derive_rlmi');

7792:
7793: BEGIN
7794:
7795: -- Initialize the error stack
7796: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.Derive_rlmi');
7797: IF g_debug_mode = 'Y' THEN
7798: log_message(p_msg_token1 => 'inside the fundscheck derive rlmi');
7799: End if;
7800: -- initialize the pl/sql talbes

Line 8276: PA_DEBUG.reset_err_stack;

8272:
8273: END IF;
8274:
8275: COMMIT;
8276: PA_DEBUG.reset_err_stack;
8277:
8278: EXCEPTION
8279: WHEN OTHERS THEN
8280: RAISE;

Line 8460: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.setup');

8456: l_imp_count Number := 0;
8457:
8458: BEGIN
8459: -- Initialize the error stack
8460: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.setup');
8461:
8462: If p_calling_module in ('DISTBTC','DISTERADJ','CBC','EXPENDITURE','DISTCWKST','DISTVIADJ'
8463: ,'TRXIMPORT','RESERVE_BASELINE') then
8464:

Line 9356: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.update_trxn_doc_levl');

9352:
9353: l_num_rows NUMBER := 200;
9354: BEGIN
9355: -- Initialize the error stack
9356: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.update_trxn_doc_levl');
9357:
9358: --reset the return status
9359: x_return_status := 'S';
9360: IF g_debug_mode = 'Y' THEN

Line 9632: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.status_code_update');

9628: -- initialize the return status to success
9629: x_return_status := 'S';
9630:
9631: --Initialize the err stack
9632: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.status_code_update');
9633:
9634: IF g_debug_mode = 'Y' THEN
9635: log_message(p_msg_token1 =>'Inside the status code update api p_calling_module['
9636: ||p_calling_module||']packet_id['||p_packet_id||']mode['

Line 9668: pa_debug.reset_err_stack;

9664: END LOOP;
9665:
9666: CLOSE cur_fatal_error;
9667: --commit; -- to end an active autonomous transaction
9668: pa_debug.reset_err_stack;
9669: RETURN;
9670:
9671: END IF;
9672:

Line 9992: pa_debug.reset_err_stack;

9988: END IF; -- end if for calling mode
9989:
9990:
9991: --reset the error stack
9992: pa_debug.reset_err_stack;
9993: --commit; -- to end an active autonmous transaction
9994: IF cur_projects%isopen then
9995: close cur_projects;
9996: End if;

Line 10079: pa_debug.init_err_stack('PA_FUNDS_CONTROL_PKG.update_EIS');

10075:
10076: BEGIN
10077:
10078: --Initialize the error stack
10079: pa_debug.init_err_stack('PA_FUNDS_CONTROL_PKG.update_EIS');
10080:
10081: -- initialize the return status
10082: x_return_status := 'S';
10083: IF g_debug_mode = 'Y' THEN

Line 10317: pa_debug.reset_err_stack;

10313: END LOOP;
10314: END IF;
10315:
10316: END IF;
10317: pa_debug.reset_err_stack;
10318:
10319: Return;
10320: EXCEPTION
10321: WHEN OTHERS THEN

Line 10372: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.upd_bdgt_encum_bal');

10368:
10369: BEGIN
10370: g_debug_mode := 'Y';
10371: --Initialize the error stack
10372: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.upd_bdgt_encum_bal');
10373: IF g_debug_mode = 'Y' THEN
10374: log_message(p_msg_token1 => 'inside the update budget acct api'||
10375: 'calling module ['||p_calling_module||']p_mode ['||p_mode||
10376: ']p_packet_status ['||p_packet_status ||']' );

Line 10445: pa_debug.reset_err_stack;

10441: CLOSE bdgt_encum_details;
10442:
10443: END IF; -- end if for packet status
10444:
10445: pa_debug.reset_err_stack;
10446:
10447: RETURN;
10448:
10449: EXCEPTION

Line 10485: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.create_liqd_entry');

10481: l_max_batch_line_id number(10);
10482:
10483: BEGIN
10484: --Initialize the error stack
10485: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.create_liqd_entry');
10486:
10487: x_return_status := 'S';
10488: If g_debug_mode = 'Y' Then
10489: log_message(p_msg_token1 => 'Inside the create_liqd_entry api ');

Line 10631: pa_debug.reset_err_stack;

10627: End if;
10628:
10629: END IF;
10630:
10631: pa_debug.reset_err_stack;
10632: return;
10633: EXCEPTION
10634: when others then
10635: result_status_code_update

Line 10704: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.gen_return_code');

10700: If g_debug_mode = 'Y' Then
10701: log_message(p_msg_token1 => 'Inside gen_return_code api');
10702: End if;
10703: -- Initialize the error stack
10704: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.gen_return_code');
10705:
10706: -- Initialize the return status to success
10707: x_return_status := l_return_code;
10708:

Line 10750: PA_DEBUG.reset_err_stack;

10746: x_return_status := l_return_code;
10747: END IF;
10748:
10749: -- reset the error stack
10750: PA_DEBUG.reset_err_stack;
10751:
10752: return;
10753:
10754: EXCEPTION

Line 10822: pa_debug.init_err_stack ('PA_Funds_Control_Pkg.Post_Burden_Lines_To_GL');

10818: BEGIN
10819:
10820: x_return_status := FND_API.G_RET_STS_SUCCESS;
10821:
10822: pa_debug.init_err_stack ('PA_Funds_Control_Pkg.Post_Burden_Lines_To_GL');
10823:
10824: If g_debug_mode = 'Y' Then
10825: log_message(p_msg_token1 => 'Inside the Post_Burden_Lines_To_GL api');
10826: log_message(p_msg_token1 => 'p_calling_module='||p_calling_module);

Line 10959: pa_debug.reset_err_stack ;

10955: log_message(p_msg_token1 => 'No of rows inseted to IGC = '||l_rowcount);
10956: End if;
10957:
10958: END IF;
10959: pa_debug.reset_err_stack ;
10960:
10961: EXCEPTION
10962:
10963: WHEN OTHERS THEN

Line 11035: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.update_GL_CBC_result_code');

11031: WHERE gl.packet_id = p_packet_id;
11032: BEGIN
11033:
11034: --Initialize the err stack
11035: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.update_GL_CBC_result_code');
11036:
11037: -- initialize the return status to success
11038: x_return_status := 'S';
11039: l_pkt_fatal_error_flag := 'N';

Line 11789: PA_DEBUG.reset_err_stack;

11785: close pkt_status;
11786: End if;
11787:
11788: -- reset the error stack
11789: PA_DEBUG.reset_err_stack;
11790:
11791: Return;
11792:
11793: EXCEPTION

Line 11877: IF (pa_debug.acquire_user_lock('BSLNFCHKLOCK:'||

11873: End if;
11874: EXIT;
11875: END IF;
11876:
11877: IF (pa_debug.acquire_user_lock('BSLNFCHKLOCK:'||
11878: g_tab_project_id(i))) = 0 then
11879: -- if the lock is acquired for project
11880: -- indicates the budget is not under baseline
11881: -- for this project so release the lock

Line 11882: IF (pa_debug.release_user_lock('BSLNFCHKLOCK:'||

11878: g_tab_project_id(i))) = 0 then
11879: -- if the lock is acquired for project
11880: -- indicates the budget is not under baseline
11881: -- for this project so release the lock
11882: IF (pa_debug.release_user_lock('BSLNFCHKLOCK:'||
11883: g_tab_project_id(i))) = 0 then
11884: null;
11885: END IF;
11886:

Line 11942: l_lck_number := pa_debug.release_user_lock('BSLNFCHKLOCK:'|| l_pre_project_id);

11938: WHEN OTHERS THEN
11939: If cur_projects%isopen then
11940: close cur_projects;
11941: End if;
11942: l_lck_number := pa_debug.release_user_lock('BSLNFCHKLOCK:'|| l_pre_project_id);
11943: result_status_code_update
11944: (p_status_code => 'T',
11945: p_packet_id => p_packet_id);
11946: If g_debug_mode = 'Y' Then

Line 12093: PA_DEBUG.init_err_stack ('PA_FUNDS_CONTROL_PKG.pa_funds_check');

12089: --------------------------------------------------------------------------------------------------------------
12090: BEGIN
12091:
12092: --- Initialize the error statck
12093: PA_DEBUG.init_err_stack ('PA_FUNDS_CONTROL_PKG.pa_funds_check');
12094:
12095: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode);
12096: g_debug_mode := NVL(g_debug_mode, 'N');
12097:

Line 12095: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode);

12091:
12092: --- Initialize the error statck
12093: PA_DEBUG.init_err_stack ('PA_FUNDS_CONTROL_PKG.pa_funds_check');
12094:
12095: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode);
12096: g_debug_mode := NVL(g_debug_mode, 'N');
12097:
12098: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
12099: ,x_write_file => 'LOG'

Line 12098: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

12094:
12095: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode);
12096: g_debug_mode := NVL(g_debug_mode, 'N');
12097:
12098: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
12099: ,x_write_file => 'LOG'
12100: ,x_debug_mode => g_debug_mode
12101: );
12102: If g_debug_mode = 'Y' then

Line 12121: PA_DEBUG.Reset_err_stack;

12117: If g_debug_mode = 'Y' then
12118: log_message(p_msg_token1=>'PA NOT INSTALLED IN THIS OU.return status='||
12119: x_return_status);
12120: End if;
12121: PA_DEBUG.Reset_err_stack;
12122: Return True;
12123: END IF;
12124: /** End of Bug fix **/
12125:

Line 12230: PA_DEBUG.Reset_err_stack;

12226: End If;
12227:
12228: End If;
12229:
12230: PA_DEBUG.Reset_err_stack;
12231: Return TRUE;
12232:
12233: End If; -- II
12234:

Line 12336: pa_debug.reset_err_stack;

12332: l_fc_final_exit_flag := 'NORMAL_ERROR';
12333: If g_debug_mode = 'Y' then
12334: log_message(p_msg_token1 => 'Return status :'||x_return_status);
12335: end if;
12336: pa_debug.reset_err_stack;
12337: return FALSE;
12338:
12339: End if;
12340: g_packet_id := l_packet_id;

Line 12372: pa_debug.reset_err_stack;

12368: x_return_status := l_packet_status;
12369: If g_debug_mode = 'Y' then
12370: log_message(p_msg_token1 => 'Return status :'||x_return_status);
12371: end if;
12372: pa_debug.reset_err_stack;
12373: return true;
12374:
12375: End IF; -- end of Unreserve mode
12376:

Line 12847: PA_DEBUG.reset_err_stack;

12843: End if;
12844:
12845: END IF;
12846: -- Reset the error stack
12847: PA_DEBUG.reset_err_stack;
12848: If g_debug_mode = 'Y' then
12849: log_message(p_msg_token1 => 'Return status :'||x_return_status);
12850: end if;
12851: RETURN ( TRUE );

Line 12906: PA_DEBUG.reset_err_stack;

12902: If g_debug_mode = 'Y' then
12903: log_message(p_msg_token1 => 'failed in pa_funds_check apiSQLERR :'||sqlcode||sqlerrm);
12904: end if;
12905: -- Reset the error stack
12906: PA_DEBUG.reset_err_stack;
12907: RETURN ( false );
12908:
12909: END pa_funds_check;
12910:

Line 13249: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.PA_GL_CBC_CONFIRMATION');

13245: l_event_result_status VARCHAR2(15);
13246:
13247: BEGIN
13248: --Initialize the error stack
13249: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.PA_GL_CBC_CONFIRMATION');
13250:
13251: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode );
13252: g_debug_mode := NVL(g_debug_mode, 'N');
13253:

Line 13251: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode );

13247: BEGIN
13248: --Initialize the error stack
13249: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.PA_GL_CBC_CONFIRMATION');
13250:
13251: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode );
13252: g_debug_mode := NVL(g_debug_mode, 'N');
13253:
13254: If g_debug_mode = 'Y' then
13255: log_message(p_msg_token1=>'Inside PA_GL_CBC_CONFIRMATION api');

Line 13258: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

13254: If g_debug_mode = 'Y' then
13255: log_message(p_msg_token1=>'Inside PA_GL_CBC_CONFIRMATION api');
13256: end if;
13257:
13258: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
13259: ,x_write_file => 'LOG'
13260: ,x_debug_mode => g_debug_mode
13261: );
13262:

Line 13275: PA_DEBUG.Reset_err_stack;

13271: If g_debug_mode = 'Y' then
13272: log_message(p_msg_token1=>'PA NOT INSTALLED IN THIS OU.return status='
13273: ||x_return_status);
13274: end if;
13275: PA_DEBUG.Reset_err_stack;
13276: Return;
13277: END IF;
13278: /** End of Bug fix **/
13279:

Line 13308: PA_DEBUG.Reset_err_stack;

13304: p_gl_cbc_return_code := 'T';
13305: x_return_status := 'T';
13306: g_return_status := 'T';
13307:
13308: PA_DEBUG.Reset_err_stack;
13309:
13310: RETURN;
13311: END IF;
13312: -- ------------------------------------------------------------------------------------------+

Line 13348: PA_DEBUG.Reset_err_stack;

13344: If g_debug_mode = 'Y' then
13345: log_message(p_msg_token1=>'PA FC called for non-project transactions: EXIT FC program');
13346: End If;
13347:
13348: PA_DEBUG.Reset_err_stack;
13349: RETURN;
13350:
13351: End If;
13352:

Line 13636: PA_DEBUG.reset_err_stack;

13632: into p_gl_cbc_return_code -- Added for bug 9156359
13633: from dual;
13634:
13635: -- Reset the error stack
13636: PA_DEBUG.reset_err_stack;
13637:
13638: RETURN;
13639: EXCEPTION
13640: WHEN OTHERS THEN

Line 13659: PA_DEBUG.reset_err_stack;

13655: log_message(p_msg_token1 => 'Un handled Exception Error in PA_GL_CBC_CONFIRMATION');
13656: End if;
13657: log_message(p_error_msg => sqlcode||sqlerrm);
13658: -- Reset the error stack
13659: PA_DEBUG.reset_err_stack;
13660:
13661: END PA_GL_CBC_CONFIRMATION;
13662:
13663: /* The following API is added to tie back the status code of the

Line 13700: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.tieback_pkt_status');

13696: l_mode := p_mode;
13697: l_partial_flag := NVl(p_partial_flag,'N');
13698:
13699: --Initialize the error stack
13700: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.tieback_pkt_status');
13701:
13702: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode );
13703: g_debug_mode := NVL(g_debug_mode, 'N');
13704:

Line 13702: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode );

13698:
13699: --Initialize the error stack
13700: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.tieback_pkt_status');
13701:
13702: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode );
13703: g_debug_mode := NVL(g_debug_mode, 'N');
13704:
13705: If g_debug_mode = 'Y' then
13706: log_message(p_msg_token1=>'Inside tieback_pkt_status api');

Line 13709: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

13705: If g_debug_mode = 'Y' then
13706: log_message(p_msg_token1=>'Inside tieback_pkt_status api');
13707: end if;
13708:
13709: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
13710: ,x_write_file => 'LOG'
13711: ,x_debug_mode => g_debug_mode
13712: );
13713:

Line 13729: PA_DEBUG.Reset_err_stack;

13725:
13726: If g_debug_mode = 'Y' then
13727: log_message(p_msg_token1=>'PA NOT INSTALLED IN THIS OU.return status='||x_return_status);
13728: end if;
13729: PA_DEBUG.Reset_err_stack;
13730: Return;
13731: END IF;
13732:
13733: IF p_calling_module in ('DISTBTC','DISTVIADJ','DISTCWKST' ) Then

Line 13813: PA_DEBUG.reset_err_stack;

13809: log_message(p_msg_token1=>'End of tieback_pkt_status API');
13810: End If;
13811:
13812: -- Reset the error stack
13813: PA_DEBUG.reset_err_stack;
13814:
13815: RETURN;
13816: EXCEPTION
13817: WHEN OTHERS THEN

Line 13819: PA_DEBUG.reset_err_stack;

13815: RETURN;
13816: EXCEPTION
13817: WHEN OTHERS THEN
13818: x_return_status := 'U';
13819: PA_DEBUG.reset_err_stack;
13820: Raise;
13821:
13822: END tieback_pkt_status;
13823: