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 1265: pa_debug.init_err_stack('PA_FUNDS_CONTROL_PKG.result_status_code_update');

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

Line 1372: PA_DEBUG.reset_err_stack;

1368: IF cur_pkts%isopen then
1369: close cur_pkts;
1370: END IF;
1371: commit; -- to end an active autonmous transaction
1372: PA_DEBUG.reset_err_stack;
1373: return;
1374: EXCEPTION
1375: WHEN OTHERS THEN
1376: IF cur_pkts%isopen then

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

1412: /* write the debug log only if debug is enabled */
1413: IF g_debug_mode = 'Y' THEN
1414:
1415: IF p_stage is NOT null then
1416: pa_debug.g_err_stage := 'Stage :'|| substr(p_stage,1,250);
1417: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1418: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_PKG','LOG: '||pa_debug.g_err_stage,3);
1419: g_error_stage := substr(p_stage,1,10);
1420: END IF;

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

1413: IF g_debug_mode = 'Y' THEN
1414:
1415: IF p_stage is NOT null then
1416: pa_debug.g_err_stage := 'Stage :'|| substr(p_stage,1,250);
1417: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1418: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_PKG','LOG: '||pa_debug.g_err_stage,3);
1419: g_error_stage := substr(p_stage,1,10);
1420: END IF;
1421:

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

1414:
1415: IF p_stage is NOT null then
1416: pa_debug.g_err_stage := 'Stage :'|| substr(p_stage,1,250);
1417: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1418: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_PKG','LOG: '||pa_debug.g_err_stage,3);
1419: g_error_stage := substr(p_stage,1,10);
1420: END IF;
1421:
1422: IF p_error_msg is NOT NULL then

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

1419: g_error_stage := substr(p_stage,1,10);
1420: END IF;
1421:
1422: IF p_error_msg is NOT NULL then
1423: pa_debug.g_err_stage := 'Error Msg :'||substr(p_error_msg,1,250);
1424: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1425: PA_DEBUG.write
1426: (x_Module => 'pa.plsql.PA_FUNDS_CONTROL_PKG'
1427: ,x_Msg => substr('LOG:'||p_error_msg,1,240)

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

1420: END IF;
1421:
1422: IF p_error_msg is NOT NULL then
1423: pa_debug.g_err_stage := 'Error Msg :'||substr(p_error_msg,1,250);
1424: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1425: PA_DEBUG.write
1426: (x_Module => 'pa.plsql.PA_FUNDS_CONTROL_PKG'
1427: ,x_Msg => substr('LOG:'||p_error_msg,1,240)
1428: ,x_Log_Level => 3);

Line 1425: PA_DEBUG.write

1421:
1422: IF p_error_msg is NOT NULL then
1423: pa_debug.g_err_stage := 'Error Msg :'||substr(p_error_msg,1,250);
1424: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1425: PA_DEBUG.write
1426: (x_Module => 'pa.plsql.PA_FUNDS_CONTROL_PKG'
1427: ,x_Msg => substr('LOG:'||p_error_msg,1,240)
1428: ,x_Log_Level => 3);
1429: g_error_msg := p_error_msg;

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

1430: END IF;
1431:
1432: IF p_msg_token1 is NOT NULL or p_msg_token2 is NOT NULL then
1433: IF p_msg_token2 is not null then
1434: pa_debug.g_err_stage := substr(p_msg_token2,1,250);
1435: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1436: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_PKG','LOG: '||pa_debug.g_err_stage,3);
1437: END IF;
1438: IF p_msg_token1 is NOT NULL then

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

1431:
1432: IF p_msg_token1 is NOT NULL or p_msg_token2 is NOT NULL then
1433: IF p_msg_token2 is not null then
1434: pa_debug.g_err_stage := substr(p_msg_token2,1,250);
1435: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1436: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_PKG','LOG: '||pa_debug.g_err_stage,3);
1437: END IF;
1438: IF p_msg_token1 is NOT NULL then
1439: pa_debug.g_err_stage := substr(p_msg_token1,1,250);

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

1432: IF p_msg_token1 is NOT NULL or p_msg_token2 is NOT NULL then
1433: IF p_msg_token2 is not null then
1434: pa_debug.g_err_stage := substr(p_msg_token2,1,250);
1435: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1436: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_PKG','LOG: '||pa_debug.g_err_stage,3);
1437: END IF;
1438: IF p_msg_token1 is NOT NULL then
1439: pa_debug.g_err_stage := substr(p_msg_token1,1,250);
1440: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);

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

1435: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1436: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_PKG','LOG: '||pa_debug.g_err_stage,3);
1437: END IF;
1438: IF p_msg_token1 is NOT NULL then
1439: pa_debug.g_err_stage := substr(p_msg_token1,1,250);
1440: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1441: PA_DEBUG.write
1442: (x_Module => 'pa.plsql.PA_FUNDS_CONTROL_PKG'
1443: ,x_Msg => substr('LOG:'||p_msg_token1,1,240)

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

1436: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_PKG','LOG: '||pa_debug.g_err_stage,3);
1437: END IF;
1438: IF p_msg_token1 is NOT NULL then
1439: pa_debug.g_err_stage := substr(p_msg_token1,1,250);
1440: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1441: PA_DEBUG.write
1442: (x_Module => 'pa.plsql.PA_FUNDS_CONTROL_PKG'
1443: ,x_Msg => substr('LOG:'||p_msg_token1,1,240)
1444: ,x_Log_Level => 3);

Line 1441: PA_DEBUG.write

1437: END IF;
1438: IF p_msg_token1 is NOT NULL then
1439: pa_debug.g_err_stage := substr(p_msg_token1,1,250);
1440: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
1441: PA_DEBUG.write
1442: (x_Module => 'pa.plsql.PA_FUNDS_CONTROL_PKG'
1443: ,x_Msg => substr('LOG:'||p_msg_token1,1,240)
1444: ,x_Log_Level => 3);
1445:

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

1578: log_message(p_msg_token1 => 'Inside the is_ap_from project api');
1579: End If;
1580:
1581: --Initialize the error stack
1582: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.is_ap_from_project');
1583:
1584: x_return_status := 'S';
1585:
1586: IF p_calling_module = 'GL' then

Line 1690: PA_DEBUG.reset_err_stack;

1686: End IF;
1687: IF g_debug_mode = 'Y' THEN
1688: log_message(p_msg_token1 => 'End of is_ap_from_project api');
1689: End If;
1690: PA_DEBUG.reset_err_stack;
1691: commit; -- to end an active autonmous transaction
1692: return;
1693:
1694: EXCEPTION

Line 6312: PA_DEBUG.Set_User_Lock_Mode

6308: log_message(p_msg_token1 => 'Inside the get arrival seq api');
6309: End if;
6310:
6311: ------- Acquire a lock before processing ----------------
6312: PA_DEBUG.Set_User_Lock_Mode
6313: ( x_Lock_Mode => 6
6314: ,x_Commit_Mode => FALSE
6315: ,x_TimeOut => 30);
6316:

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

6313: ( x_Lock_Mode => 6
6314: ,x_Commit_Mode => FALSE
6315: ,x_TimeOut => 30);
6316:
6317: l_number := pa_debug.acquire_user_lock('PAFUNDSCHECKLOCKER');
6318: IF g_debug_mode = 'Y' THEN
6319: log_message(p_msg_token1 => 'the value of lock handler = '||l_number);
6320: End if;
6321: If l_number = 0 then

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

6367: End if;
6368: log_message(p_error_msg =>sqlcode||sqlerrm);
6369: END;
6370: ------------- Release the Lock --------------
6371: If (pa_debug.release_user_lock('PAFUNDSCHECKLOCKER') = 0) then
6372: IF g_debug_mode = 'Y' THEN
6373: log_message(p_msg_token1 => 'Released the Lock');
6374: End if;
6375: END If;

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

6395: RETURN nvl(v_arrival_seq,0);
6396:
6397: EXCEPTION
6398: when others then
6399: If (pa_debug.release_user_lock('PAFUNDSCHECKLOCKER') = 0) then
6400: IF g_debug_mode = 'Y' THEN
6401: log_message(p_msg_token1 => 'Released the Lock');
6402: End if;
6403: null;

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

7594:
7595: BEGIN
7596:
7597: -- Initialize the error stack
7598: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.Derive_rlmi');
7599: IF g_debug_mode = 'Y' THEN
7600: log_message(p_msg_token1 => 'inside the fundscheck derive rlmi');
7601: End if;
7602: -- initialize the pl/sql talbes

Line 8055: PA_DEBUG.reset_err_stack;

8051:
8052: END IF;
8053:
8054: COMMIT;
8055: PA_DEBUG.reset_err_stack;
8056:
8057: EXCEPTION
8058: WHEN OTHERS THEN
8059: RAISE;

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

8233: l_imp_count Number := 0;
8234:
8235: BEGIN
8236: -- Initialize the error stack
8237: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.setup');
8238:
8239: If p_calling_module in ('DISTBTC','DISTERADJ','CBC','EXPENDITURE','DISTCWKST','DISTVIADJ'
8240: ,'TRXIMPORT','RESERVE_BASELINE') then
8241:

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

9104:
9105: l_num_rows NUMBER := 200;
9106: BEGIN
9107: -- Initialize the error stack
9108: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.update_trxn_doc_levl');
9109:
9110: --reset the return status
9111: x_return_status := 'S';
9112: IF g_debug_mode = 'Y' THEN

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

9375: -- initialize the return status to success
9376: x_return_status := 'S';
9377:
9378: --Initialize the err stack
9379: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.status_code_update');
9380:
9381: IF g_debug_mode = 'Y' THEN
9382: log_message(p_msg_token1 =>'Inside the status code update api p_calling_module['
9383: ||p_calling_module||']packet_id['||p_packet_id||']mode['

Line 9415: pa_debug.reset_err_stack;

9411: END LOOP;
9412:
9413: CLOSE cur_fatal_error;
9414: --commit; -- to end an active autonomous transaction
9415: pa_debug.reset_err_stack;
9416: RETURN;
9417:
9418: END IF;
9419:

Line 9739: pa_debug.reset_err_stack;

9735: END IF; -- end if for calling mode
9736:
9737:
9738: --reset the error stack
9739: pa_debug.reset_err_stack;
9740: --commit; -- to end an active autonmous transaction
9741: IF cur_projects%isopen then
9742: close cur_projects;
9743: End if;

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

9822:
9823: BEGIN
9824:
9825: --Initialize the error stack
9826: pa_debug.init_err_stack('PA_FUNDS_CONTROL_PKG.update_EIS');
9827:
9828: -- initialize the return status
9829: x_return_status := 'S';
9830:

Line 10060: pa_debug.reset_err_stack;

10056: END LOOP;
10057: END IF;
10058:
10059: END IF;
10060: pa_debug.reset_err_stack;
10061:
10062: Return;
10063: EXCEPTION
10064: WHEN OTHERS THEN

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

10111:
10112: BEGIN
10113: g_debug_mode := 'Y';
10114: --Initialize the error stack
10115: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.upd_bdgt_encum_bal');
10116: IF g_debug_mode = 'Y' THEN
10117: log_message(p_msg_token1 => 'inside the update budget acct api'||
10118: 'calling module ['||p_calling_module||']p_mode ['||p_mode||
10119: ']p_packet_status ['||p_packet_status ||']' );

Line 10188: pa_debug.reset_err_stack;

10184: CLOSE bdgt_encum_details;
10185:
10186: END IF; -- end if for packet status
10187:
10188: pa_debug.reset_err_stack;
10189:
10190: RETURN;
10191:
10192: EXCEPTION

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

10224: l_max_batch_line_id number(10);
10225:
10226: BEGIN
10227: --Initialize the error stack
10228: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.create_liqd_entry');
10229:
10230: x_return_status := 'S';
10231: If g_debug_mode = 'Y' Then
10232: log_message(p_msg_token1 => 'Inside the create_liqd_entry api ');

Line 10371: pa_debug.reset_err_stack;

10367: End if;
10368:
10369: END IF;
10370:
10371: pa_debug.reset_err_stack;
10372: return;
10373: EXCEPTION
10374: when others then
10375: result_status_code_update

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

10438:
10439: BEGIN
10440:
10441: -- Initialize the error stack
10442: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.gen_return_code');
10443:
10444: -- Initialize the return status to success
10445: x_return_status := l_return_code;
10446:

Line 10488: PA_DEBUG.reset_err_stack;

10484: x_return_status := l_return_code;
10485: END IF;
10486:
10487: -- reset the error stack
10488: PA_DEBUG.reset_err_stack;
10489:
10490: return;
10491:
10492: EXCEPTION

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

10556: BEGIN
10557:
10558: x_return_status := FND_API.G_RET_STS_SUCCESS;
10559:
10560: pa_debug.init_err_stack ('PA_Funds_Control_Pkg.Post_Burden_Lines_To_GL');
10561:
10562: If g_debug_mode = 'Y' Then
10563: log_message(p_msg_token1 => 'Inside the Post_Burden_Lines_To_GL api');
10564: End if;

Line 10696: pa_debug.reset_err_stack ;

10692: log_message(p_msg_token1 => 'No of rows inseted to IGC = '||l_rowcount);
10693: End if;
10694:
10695: END IF;
10696: pa_debug.reset_err_stack ;
10697:
10698: EXCEPTION
10699:
10700: WHEN OTHERS THEN

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

10768: WHERE gl.packet_id = p_packet_id;
10769: BEGIN
10770:
10771: --Initialize the err stack
10772: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.update_GL_CBC_result_code');
10773:
10774: -- initialize the return status to success
10775: x_return_status := 'S';
10776: l_pkt_fatal_error_flag := 'N';

Line 11523: PA_DEBUG.reset_err_stack;

11519: close pkt_status;
11520: End if;
11521:
11522: -- reset the error stack
11523: PA_DEBUG.reset_err_stack;
11524:
11525: Return;
11526:
11527: EXCEPTION

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

11603: End if;
11604: EXIT;
11605: END IF;
11606:
11607: IF (pa_debug.acquire_user_lock('BSLNFCHKLOCK:'||
11608: g_tab_project_id(i))) = 0 then
11609: -- if the lock is acquired for project
11610: -- indicates the budget is not under baseline
11611: -- for this project so release the lock

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

11608: g_tab_project_id(i))) = 0 then
11609: -- if the lock is acquired for project
11610: -- indicates the budget is not under baseline
11611: -- for this project so release the lock
11612: IF (pa_debug.release_user_lock('BSLNFCHKLOCK:'||
11613: g_tab_project_id(i))) = 0 then
11614: null;
11615: END IF;
11616:

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

11668: WHEN OTHERS THEN
11669: If cur_projects%isopen then
11670: close cur_projects;
11671: End if;
11672: l_lck_number := pa_debug.release_user_lock('BSLNFCHKLOCK:'|| l_pre_project_id);
11673: result_status_code_update
11674: (p_status_code => 'T',
11675: p_packet_id => p_packet_id);
11676: If g_debug_mode = 'Y' Then

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

11819: --------------------------------------------------------------------------------------------------------------
11820: BEGIN
11821:
11822: --- Initialize the error statck
11823: PA_DEBUG.init_err_stack ('PA_FUNDS_CONTROL_PKG.pa_funds_check');
11824:
11825: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode);
11826: g_debug_mode := NVL(g_debug_mode, 'N');
11827:

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

11821:
11822: --- Initialize the error statck
11823: PA_DEBUG.init_err_stack ('PA_FUNDS_CONTROL_PKG.pa_funds_check');
11824:
11825: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode);
11826: g_debug_mode := NVL(g_debug_mode, 'N');
11827:
11828: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
11829: ,x_write_file => 'LOG'

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

11824:
11825: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode);
11826: g_debug_mode := NVL(g_debug_mode, 'N');
11827:
11828: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
11829: ,x_write_file => 'LOG'
11830: ,x_debug_mode => g_debug_mode
11831: );
11832: If g_debug_mode = 'Y' then

Line 11851: PA_DEBUG.Reset_err_stack;

11847: If g_debug_mode = 'Y' then
11848: log_message(p_msg_token1=>'PA NOT INSTALLED IN THIS OU.return status='||
11849: x_return_status);
11850: End if;
11851: PA_DEBUG.Reset_err_stack;
11852: Return True;
11853: END IF;
11854: /** End of Bug fix **/
11855:

Line 11957: PA_DEBUG.Reset_err_stack;

11953: End If;
11954:
11955: End If;
11956:
11957: PA_DEBUG.Reset_err_stack;
11958: Return TRUE;
11959:
11960: End If; -- II
11961:

Line 12050: pa_debug.reset_err_stack;

12046: l_fc_final_exit_flag := 'NORMAL_ERROR';
12047: If g_debug_mode = 'Y' then
12048: log_message(p_msg_token1 => 'Return status :'||x_return_status);
12049: end if;
12050: pa_debug.reset_err_stack;
12051: return FALSE;
12052:
12053: End if;
12054: g_packet_id := l_packet_id;

Line 12084: pa_debug.reset_err_stack;

12080: x_return_status := l_packet_status;
12081: If g_debug_mode = 'Y' then
12082: log_message(p_msg_token1 => 'Return status :'||x_return_status);
12083: end if;
12084: pa_debug.reset_err_stack;
12085: return true;
12086:
12087: End IF; -- end of Unreserve mode
12088:

Line 12522: PA_DEBUG.reset_err_stack;

12518: End if;
12519:
12520: END IF;
12521: -- Reset the error stack
12522: PA_DEBUG.reset_err_stack;
12523: If g_debug_mode = 'Y' then
12524: log_message(p_msg_token1 => 'Return status :'||x_return_status);
12525: end if;
12526: RETURN ( TRUE );

Line 12581: PA_DEBUG.reset_err_stack;

12577: If g_debug_mode = 'Y' then
12578: log_message(p_msg_token1 => 'failed in pa_funds_check apiSQLERR :'||sqlcode||sqlerrm);
12579: end if;
12580: -- Reset the error stack
12581: PA_DEBUG.reset_err_stack;
12582: RETURN ( false );
12583:
12584: END pa_funds_check;
12585:

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

12917: l_event_result_status VARCHAR2(15);
12918:
12919: BEGIN
12920: --Initialize the error stack
12921: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.PA_GL_CBC_CONFIRMATION');
12922:
12923: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode );
12924: g_debug_mode := NVL(g_debug_mode, 'N');
12925:

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

12919: BEGIN
12920: --Initialize the error stack
12921: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.PA_GL_CBC_CONFIRMATION');
12922:
12923: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode );
12924: g_debug_mode := NVL(g_debug_mode, 'N');
12925:
12926: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
12927: ,x_write_file => 'LOG'

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

12922:
12923: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode );
12924: g_debug_mode := NVL(g_debug_mode, 'N');
12925:
12926: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
12927: ,x_write_file => 'LOG'
12928: ,x_debug_mode => g_debug_mode
12929: );
12930:

Line 12943: PA_DEBUG.Reset_err_stack;

12939: If g_debug_mode = 'Y' then
12940: log_message(p_msg_token1=>'PA NOT INSTALLED IN THIS OU.return status='
12941: ||x_return_status);
12942: end if;
12943: PA_DEBUG.Reset_err_stack;
12944: Return;
12945: END IF;
12946: /** End of Bug fix **/
12947:

Line 12976: PA_DEBUG.Reset_err_stack;

12972: p_gl_cbc_return_code := 'T';
12973: x_return_status := 'T';
12974: g_return_status := 'T';
12975:
12976: PA_DEBUG.Reset_err_stack;
12977:
12978: RETURN;
12979: END IF;
12980: -- ------------------------------------------------------------------------------------------+

Line 13016: PA_DEBUG.Reset_err_stack;

13012: If g_debug_mode = 'Y' then
13013: log_message(p_msg_token1=>'PA FC called for non-project transactions: EXIT FC program');
13014: End If;
13015:
13016: PA_DEBUG.Reset_err_stack;
13017: RETURN;
13018:
13019: End If;
13020:

Line 13301: PA_DEBUG.reset_err_stack;

13297: End if;
13298:
13299:
13300: -- Reset the error stack
13301: PA_DEBUG.reset_err_stack;
13302:
13303: RETURN;
13304: EXCEPTION
13305: WHEN OTHERS THEN

Line 13324: PA_DEBUG.reset_err_stack;

13320: log_message(p_msg_token1 => 'Un handled Exception Error in PA_GL_CBC_CONFIRMATION');
13321: End if;
13322: log_message(p_error_msg => sqlcode||sqlerrm);
13323: -- Reset the error stack
13324: PA_DEBUG.reset_err_stack;
13325:
13326: END PA_GL_CBC_CONFIRMATION;
13327:
13328: /* The following API is added to tie back the status code of the

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

13361: l_mode := p_mode;
13362: l_partial_flag := NVl(p_partial_flag,'N');
13363:
13364: --Initialize the error stack
13365: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.tieback_pkt_status');
13366:
13367: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode );
13368: g_debug_mode := NVL(g_debug_mode, 'N');
13369:

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

13363:
13364: --Initialize the error stack
13365: PA_DEBUG.init_err_stack('PA_FUNDS_CONTROL_PKG.tieback_pkt_status');
13366:
13367: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode );
13368: g_debug_mode := NVL(g_debug_mode, 'N');
13369:
13370: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
13371: ,x_write_file => 'LOG'

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

13366:
13367: fnd_profile.get('PA_DEBUG_MODE',g_debug_mode );
13368: g_debug_mode := NVL(g_debug_mode, 'N');
13369:
13370: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
13371: ,x_write_file => 'LOG'
13372: ,x_debug_mode => g_debug_mode
13373: );
13374:

Line 13390: PA_DEBUG.Reset_err_stack;

13386:
13387: If g_debug_mode = 'Y' then
13388: log_message(p_msg_token1=>'PA NOT INSTALLED IN THIS OU.return status='||x_return_status);
13389: end if;
13390: PA_DEBUG.Reset_err_stack;
13391: Return;
13392: END IF;
13393:
13394: IF p_calling_module in ('DISTBTC','DISTVIADJ','DISTCWKST' ) Then

Line 13465: PA_DEBUG.reset_err_stack;

13461: log_message(p_msg_token1=>'End of tieback_pkt_status API');
13462: End If;
13463:
13464: -- Reset the error stack
13465: PA_DEBUG.reset_err_stack;
13466:
13467: RETURN;
13468: EXCEPTION
13469: WHEN OTHERS THEN

Line 13471: PA_DEBUG.reset_err_stack;

13467: RETURN;
13468: EXCEPTION
13469: WHEN OTHERS THEN
13470: x_return_status := 'U';
13471: PA_DEBUG.reset_err_stack;
13472: Raise;
13473:
13474: END tieback_pkt_status;
13475: