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

Line 39: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/Added the default profile option variable initialization for bug 2674619/

35: x_err_stage IN OUT NOCOPY VARCHAR2,
36: x_err_code IN OUT NOCOPY NUMBER)
37: IS
38: x_err_stack VARCHAR2(255);
39: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
40:
41: BEGIN
42: x_err_code :=0;
43: x_err_stage := 'Getting the accumulation configuration';

Line 47: pa_debug.debug('get_accum_configurations: ' || x_err_stage);

43: x_err_stage := 'Getting the accumulation configuration';
44: x_err_stack := '->get_accum_configurations';
45:
46: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
47: pa_debug.debug('get_accum_configurations: ' || x_err_stage);
48: END IF;
49:
50: -- Pass on the project_id to determine the configuration
51:

Line 146: pa_debug.debug('get_accum_configurations: ' || 'The following columns are configured for accumulation for this project:');

142: x_err_stage,
143: x_err_stack);
144:
145: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
146: pa_debug.debug('get_accum_configurations: ' || 'The following columns are configured for accumulation for this project:');
147: pa_debug.debug('get_accum_configurations: ' || 'Raw_cost='||RAW_COST_FLAG||' Burdened_cost='||BURDENED_COST_FLAG||
148: ' Quantity='||QUANTITY_FLAG||' Labor_hours='||LABOR_HOURS_FLAG);
149: pa_debug.debug('get_accum_configurations: ' || 'Billable_raw_cost='||BILLABLE_RAW_COST_FLAG||
150: ' Billable_burdened_cost='||BILLABLE_BURDENED_COST_FLAG||

Line 147: pa_debug.debug('get_accum_configurations: ' || 'Raw_cost='||RAW_COST_FLAG||' Burdened_cost='||BURDENED_COST_FLAG||

143: x_err_stack);
144:
145: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
146: pa_debug.debug('get_accum_configurations: ' || 'The following columns are configured for accumulation for this project:');
147: pa_debug.debug('get_accum_configurations: ' || 'Raw_cost='||RAW_COST_FLAG||' Burdened_cost='||BURDENED_COST_FLAG||
148: ' Quantity='||QUANTITY_FLAG||' Labor_hours='||LABOR_HOURS_FLAG);
149: pa_debug.debug('get_accum_configurations: ' || 'Billable_raw_cost='||BILLABLE_RAW_COST_FLAG||
150: ' Billable_burdened_cost='||BILLABLE_BURDENED_COST_FLAG||
151: ' Billable_quantity='||BILLABLE_QUANTITY_FLAG||

Line 149: pa_debug.debug('get_accum_configurations: ' || 'Billable_raw_cost='||BILLABLE_RAW_COST_FLAG||

145: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
146: pa_debug.debug('get_accum_configurations: ' || 'The following columns are configured for accumulation for this project:');
147: pa_debug.debug('get_accum_configurations: ' || 'Raw_cost='||RAW_COST_FLAG||' Burdened_cost='||BURDENED_COST_FLAG||
148: ' Quantity='||QUANTITY_FLAG||' Labor_hours='||LABOR_HOURS_FLAG);
149: pa_debug.debug('get_accum_configurations: ' || 'Billable_raw_cost='||BILLABLE_RAW_COST_FLAG||
150: ' Billable_burdened_cost='||BILLABLE_BURDENED_COST_FLAG||
151: ' Billable_quantity='||BILLABLE_QUANTITY_FLAG||
152: ' Billable_labor_hours='|| BILLABLE_LABOR_HOURS_FLAG);
153: pa_debug.debug('get_accum_configurations: ' || 'Revenue='||REVENUE_FLAG||' Cmt_raw_cost'||CMT_RAW_COST_FLAG||

Line 153: pa_debug.debug('get_accum_configurations: ' || 'Revenue='||REVENUE_FLAG||' Cmt_raw_cost'||CMT_RAW_COST_FLAG||

149: pa_debug.debug('get_accum_configurations: ' || 'Billable_raw_cost='||BILLABLE_RAW_COST_FLAG||
150: ' Billable_burdened_cost='||BILLABLE_BURDENED_COST_FLAG||
151: ' Billable_quantity='||BILLABLE_QUANTITY_FLAG||
152: ' Billable_labor_hours='|| BILLABLE_LABOR_HOURS_FLAG);
153: pa_debug.debug('get_accum_configurations: ' || 'Revenue='||REVENUE_FLAG||' Cmt_raw_cost'||CMT_RAW_COST_FLAG||
154: ' Cmt_burdened_cost='|| CMT_BURDENED_COST_FLAG);
155: END IF;
156:
157: EXCEPTION

Line 182: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/Added the default profile option variable initialization for bug 2674619/

178: x_err_stage IN OUT NOCOPY VARCHAR2,
179: x_err_code IN OUT NOCOPY NUMBER)
180: IS
181: tot_recs_processed NUMBER;
182: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
183: /*Code Changes for Bug No.2984871 start */
184: l_rowcount number :=0;
185: /*Code Changes for Bug No.2984871 end */
186:

Line 191: pa_debug.debug('update_resource_flag: ' || x_err_stage);

187: BEGIN
188: x_err_code :=0;
189: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
190: x_err_stage := 'Updating resource_accumulated_flag';
191: pa_debug.debug('update_resource_flag: ' || x_err_stage);
192: END IF;
193: tot_recs_processed := 0;
194:
195: LOOP

Line 212: pa_debug.debug('update_resource_flag: ' || 'Number of Records Commited cumulatively = '|| TO_CHAR(tot_recs_processed));

208: /*Bug 2984871:Replaced sql%rowcount with l_rowcount */
209: tot_recs_processed := tot_recs_processed + l_rowcount;
210:
211: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
212: pa_debug.debug('update_resource_flag: ' || 'Number of Records Commited cumulatively = '|| TO_CHAR(tot_recs_processed));
213: END IF;
214: /*Bug 2984871:Replaced sql%rowcount with l_rowcount */
215: IF (l_rowcount < pa_proj_accum_main.x_commit_size) THEN
216: EXIT;

Line 236: pa_debug.debug('update_resource_flag: ' || 'Number of Records Commited cumulatively = '|| TO_CHAR(tot_recs_processed));

232: /*Bug 2984871:Replaced sql%rowcount with l_rowcount */
233: tot_recs_processed := tot_recs_processed + l_rowcount;
234:
235: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
236: pa_debug.debug('update_resource_flag: ' || 'Number of Records Commited cumulatively = '|| TO_CHAR(tot_recs_processed));
237: END IF;
238: /*Bug 2984871:Replaced sql%rowcount with l_rowcount */
239: IF (l_rowcount < pa_proj_accum_main.x_commit_size) THEN
240: EXIT;

Line 263: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/Added the default profile option variable initialization for bug 2674619/

259: x_system_linkage_function IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
260: x_err_stage IN OUT NOCOPY VARCHAR2,
261: x_err_code IN OUT NOCOPY NUMBER)
262: IS
263: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
264:
265:
266: BEGIN
267: x_err_code :=0;

Line 278: pa_debug.debug('refresh_txn_accum: ' || x_err_stage);

274: -- If it is not specified then all the accumulation figures need
275: -- to be refreshed
276: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
277: x_err_stage := 'Refreshing transaction accum';
278: pa_debug.debug('refresh_txn_accum: ' || x_err_stage);
279: END IF;
280:
281: IF ( x_transaction_type = 'C' ) THEN
282: -- Refresh actual cost accumulation Figures

Line 438: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/Added the default profile option variable initialization for bug 2674619/

434: x_system_linkage_function IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
435: x_err_stage IN OUT NOCOPY VARCHAR2,
436: x_err_code IN OUT NOCOPY NUMBER)
437: IS
438: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
439:
440:
441: BEGIN
442: x_err_code :=0;

Line 446: pa_debug.debug('refresh_act_txn_accum: ' || x_err_stage);

442: x_err_code :=0;
443:
444: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
445: x_err_stage := 'Refreshing Actual transaction accum';
446: pa_debug.debug('refresh_act_txn_accum: ' || x_err_stage);
447: END IF;
448:
449: UPDATE
450: pa_txn_accum pta

Line 495: pa_debug.debug('refresh_act_txn_accum: ' || 'Records Updated = '||TO_CHAR(SQL%ROWCOUNT));

491: AND end_date <= x_end_pa_date
492: );
493:
494: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
495: pa_debug.debug('refresh_act_txn_accum: ' || 'Records Updated = '||TO_CHAR(SQL%ROWCOUNT));
496: END IF;
497:
498: COMMIT;
499:

Line 522: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/Added the default profile option variable initialization for bug 2674619/

518: x_err_stage IN OUT NOCOPY VARCHAR2,
519: x_err_code IN OUT NOCOPY NUMBER)
520:
521: IS
522: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
523: BEGIN
524: x_err_code :=0;
525: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
526: x_err_stage := 'Refreshing Revenue transaction accum';

Line 527: pa_debug.debug('refresh_rev_txn_accum: ' || x_err_stage);

523: BEGIN
524: x_err_code :=0;
525: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
526: x_err_stage := 'Refreshing Revenue transaction accum';
527: pa_debug.debug('refresh_rev_txn_accum: ' || x_err_stage);
528: END IF;
529:
530: UPDATE
531: pa_txn_accum pta

Line 559: pa_debug.debug('refresh_rev_txn_accum: ' || 'Records Updated = '||TO_CHAR(SQL%ROWCOUNT));

555: AND end_date <= x_end_pa_date
556: );
557:
558: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
559: pa_debug.debug('refresh_rev_txn_accum: ' || 'Records Updated = '||TO_CHAR(SQL%ROWCOUNT));
560: END IF;
561:
562: COMMIT;
563:

Line 584: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/Added the default profile option variable initialization for bug 2674619/

580: x_system_linkage_function IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
581: x_err_stage IN OUT NOCOPY VARCHAR2,
582: x_err_code IN OUT NOCOPY NUMBER)
583: IS
584: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
585: BEGIN
586: x_err_code :=0;
587: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
588: x_err_stage := 'Refreshing commitments transaction accum';

Line 589: pa_debug.debug('refresh_cmt_txn_accum: ' || x_err_stage);

585: BEGIN
586: x_err_code :=0;
587: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
588: x_err_stage := 'Refreshing commitments transaction accum';
589: pa_debug.debug('refresh_cmt_txn_accum: ' || x_err_stage);
590: END IF;
591:
592: UPDATE /*+ leading(PTA) */ /* 10144700 */
593: pa_txn_accum pta

Line 624: pa_debug.debug('refresh_cmt_txn_accum: ' || 'Records Updated = '||TO_CHAR(SQL%ROWCOUNT));

620: AND end_date <= x_end_pa_date
621: );
622:
623: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
624: pa_debug.debug('refresh_cmt_txn_accum: ' || 'Records Updated = '||TO_CHAR(SQL%ROWCOUNT));
625: END IF;
626:
627: COMMIT;
628:

Line 643: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/Added the default profile option variable initialization for bug 2674619/

639: x_end_project_id IN NUMBER,
640: x_err_stage IN OUT NOCOPY VARCHAR2,
641: x_err_code IN OUT NOCOPY NUMBER)
642: IS
643: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
644: BEGIN
645: x_err_code :=0;
646:
647: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 649: pa_debug.debug('update_act_txn_accum: ' || x_err_stage);

645: x_err_code :=0;
646:
647: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
648: x_err_stage := 'Refreshing transaction accumulation for Reaccumulation';
649: pa_debug.debug('update_act_txn_accum: ' || x_err_stage);
650: END IF;
651:
652: UPDATE
653: pa_txn_accum pta

Line 711: pa_debug.debug('update_act_txn_accum: ' || 'Records Updated = '||TO_CHAR(SQL%ROWCOUNT));

707: AND ptad.line_type IN ('C','R','E')
708: );
709:
710: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
711: pa_debug.debug('update_act_txn_accum: ' || 'Records Updated = '||TO_CHAR(SQL%ROWCOUNT));
712: END IF;
713:
714: COMMIT;
715:

Line 735: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/Added the default profile option variable initialization for bug 2674619/

731: x_system_linkage_function IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
732: x_err_stage IN OUT NOCOPY VARCHAR2,
733: x_err_code IN OUT NOCOPY NUMBER)
734: IS
735: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
736: tot_recs_processed NUMBER;
737: /*Code Changes for Bug No.2984871 start */
738: l_rowcount number :=0;
739: /*Code Changes for Bug No.2984871 end */

Line 746: pa_debug.debug('delete_act_txn_accum_details: ' || x_err_stage);

742: x_err_code :=0;
743: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
744: x_err_stage := 'Deleteing Actual transaction accum details';
745: tot_recs_processed := 0;
746: pa_debug.debug('delete_act_txn_accum_details: ' || x_err_stage);
747: END IF;
748:
749: LOOP
750: DELETE pa_txn_accum_details ptad

Line 774: pa_debug.debug('delete_act_txn_accum_details: ' || 'Number of Records Commited cumulatively = '|| TO_CHAR(tot_recs_processed));

770: COMMIT;
771: /*Bug 2984871:Replaced sql%rowcount with l_rowcount */
772: tot_recs_processed := tot_recs_processed + l_rowcount;
773: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
774: pa_debug.debug('delete_act_txn_accum_details: ' || 'Number of Records Commited cumulatively = '|| TO_CHAR(tot_recs_processed));
775: END IF;
776: /*Bug 2984871:Replaced sql%rowcount with l_rowcount */
777: IF l_rowcount < pa_proj_accum_main.x_commit_size THEN
778: EXIT;

Line 783: pa_debug.debug('delete_act_txn_accum_details: ' || 'Records Deleted = '||TO_CHAR(tot_recs_processed));

779: END IF;
780: END LOOP;
781:
782: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
783: pa_debug.debug('delete_act_txn_accum_details: ' || 'Records Deleted = '||TO_CHAR(tot_recs_processed));
784: END IF;
785:
786: EXCEPTION
787: WHEN OTHERS THEN

Line 805: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/Added the default profile option variable initialization for bug 2674619/

801: x_end_pa_date IN DATE,
802: x_err_stage IN OUT NOCOPY VARCHAR2,
803: x_err_code IN OUT NOCOPY NUMBER)
804: IS
805: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
806: tot_recs_processed NUMBER;
807: /*Code Changes for Bug No.2984871 start */
808: l_rowcount number :=0;
809: /*Code Changes for Bug No.2984871 end */

Line 816: pa_debug.debug('delete_rev_txn_accum_details: ' || x_err_stage);

812: x_err_code :=0;
813: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
814: x_err_stage := 'Deleteing Revenue transaction accum details';
815: tot_recs_processed := 0;
816: pa_debug.debug('delete_rev_txn_accum_details: ' || x_err_stage);
817: END IF;
818:
819: LOOP
820: DELETE pa_txn_accum_details ptad

Line 843: pa_debug.debug('delete_rev_txn_accum_details: ' || 'Number of Records Commited cumulatively = '|| TO_CHAR(tot_recs_processed));

839: COMMIT;
840: /*Bug 2984871:Replaced sql%rowcount with l_rowcount */
841: tot_recs_processed := tot_recs_processed + l_rowcount;
842: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
843: pa_debug.debug('delete_rev_txn_accum_details: ' || 'Number of Records Commited cumulatively = '|| TO_CHAR(tot_recs_processed));
844: END IF;
845: /*Bug 2984871:Replaced sql%rowcount with l_rowcount */
846: IF (l_rowcount < pa_proj_accum_main.x_commit_size) THEN
847: EXIT;

Line 852: pa_debug.debug('delete_rev_txn_accum_details: ' || 'Records Deleted = '||TO_CHAR(tot_recs_processed));

848: END IF;
849: END LOOP;
850:
851: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
852: pa_debug.debug('delete_rev_txn_accum_details: ' || 'Records Deleted = '||TO_CHAR(tot_recs_processed));
853: END IF;
854:
855: EXCEPTION
856: WHEN OTHERS THEN

Line 874: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/Added the default profile option variable initialization for bug 2674619/

870: x_system_linkage_function IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
871: x_err_stage IN OUT NOCOPY VARCHAR2,
872: x_err_code IN OUT NOCOPY NUMBER)
873: IS
874: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
875: /*Code Changes for Bug No.2984871 start */
876: l_rowcount number :=0;
877: /*Code Changes for Bug No.2984871 end */
878:

Line 886: pa_debug.debug('delete_cmt_txn_accum_details: ' || x_err_stage);

882: x_err_code :=0;
883: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
884: x_err_stage := 'Deleteing commitments transaction accum details';
885: tot_recs_processed := 0;
886: pa_debug.debug('delete_cmt_txn_accum_details: ' || x_err_stage);
887: END IF;
888:
889: LOOP
890: DELETE pa_txn_accum_details ptad

Line 914: pa_debug.debug('delete_cmt_txn_accum_details: ' || 'Number of Records Commited cumulatively = '|| TO_CHAR(tot_recs_processed));

910: COMMIT;
911: /*Bug 2984871:Replaced sql%rowcount with l_rowcount */
912: tot_recs_processed := tot_recs_processed + l_rowcount;
913: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
914: pa_debug.debug('delete_cmt_txn_accum_details: ' || 'Number of Records Commited cumulatively = '|| TO_CHAR(tot_recs_processed));
915: END IF;
916: /*Bug 2984871:Replaced sql%rowcount with l_rowcount */
917: IF l_rowcount < pa_proj_accum_main.x_commit_size THEN
918: EXIT;

Line 923: pa_debug.debug('delete_cmt_txn_accum_details: ' || 'Records Deleted = '||TO_CHAR(tot_recs_processed));

919: END IF;
920: END LOOP;
921:
922: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
923: pa_debug.debug('delete_cmt_txn_accum_details: ' || 'Records Deleted = '||TO_CHAR(tot_recs_processed));
924: END IF;
925:
926: EXCEPTION
927: WHEN OTHERS THEN

Line 1237: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/Added the default profile option variable initialization for bug 2674619/

1233: x_err_stage IN OUT NOCOPY VARCHAR2,
1234: x_err_code IN OUT NOCOPY NUMBER)
1235:
1236: IS
1237: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
1238:
1239: tot_recs_processed NUMBER;
1240: /*Code Changes for Bug No.2984871 start */
1241: l_rowcount number :=0;

Line 1249: pa_debug.debug('delete_cmt_txns: ' || x_err_stage);

1245: x_err_code :=0;
1246: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1247: x_err_stage := 'Deleting commitments transaction';
1248: tot_recs_processed := 0;
1249: pa_debug.debug('delete_cmt_txns: ' || x_err_stage);
1250: END IF;
1251:
1252:
1253: LOOP

Line 1277: pa_debug.debug('delete_cmt_txns: ' || 'Number of Records Commited cumulatively = '|| TO_CHAR(tot_recs_processed));

1273: COMMIT;
1274: /*Bug 2984871:Replaced sql%rowcount with l_rowcount */
1275: tot_recs_processed := tot_recs_processed + l_rowcount;
1276: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1277: pa_debug.debug('delete_cmt_txns: ' || 'Number of Records Commited cumulatively = '|| TO_CHAR(tot_recs_processed));
1278: END IF;
1279: /*Bug 2984871:Replaced sql%rowcount with l_rowcount */
1280: IF l_rowcount < pa_proj_accum_main.x_commit_size THEN
1281: EXIT;

Line 1286: pa_debug.debug('delete_cmt_txns: ' || 'Records Deleted = '||TO_CHAR(tot_recs_processed));

1282: END IF;
1283: END LOOP;
1284:
1285: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1286: pa_debug.debug('delete_cmt_txns: ' || 'Records Deleted = '||TO_CHAR(tot_recs_processed));
1287: END IF;
1288:
1289: EXCEPTION
1290: WHEN OTHERS THEN

Line 1327: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/Added the default profile option variable initialization for bug 2674619/

1323: x_err_code IN OUT NOCOPY NUMBER,
1324: x_use_tmp_table IN VARCHAR2 DEFAULT 'N' /*Added for bug 5635857*/)
1325: IS
1326:
1327: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
1328:
1329: l_cur_pa_period varchar2(20); /* Added for commitment change request */
1330: l_cur_gl_period varchar2(15); /* Added for commitment change request */
1331:

Line 1347: pa_debug.debug('create_cmt_txns: ' || x_err_stage);

1343: THEN
1344:
1345: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1346: x_err_stage := 'Creating commitment txns from Grants Management Source';
1347: pa_debug.debug('create_cmt_txns: ' || x_err_stage);
1348: END IF;
1349:
1350: -- Insert Commitments from GMS Source
1351: GMS_PA_API3.create_cmt_txns

Line 1364: pa_debug.debug('create_cmt_txns: ' || x_err_stage);

1360:
1361: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1362: IF x_use_tmp_table = 'N' THEN /* 14457478 */
1363: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_V Source';
1364: pa_debug.debug('create_cmt_txns: ' || x_err_stage);
1365: ELSIF x_use_tmp_table = 'Y' THEN
1366: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_TMP Source';
1367: pa_debug.debug('create_cmt_txns: ' || x_err_stage);
1368: END IF; /* 14457478 */

Line 1367: pa_debug.debug('create_cmt_txns: ' || x_err_stage);

1363: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_V Source';
1364: pa_debug.debug('create_cmt_txns: ' || x_err_stage);
1365: ELSIF x_use_tmp_table = 'Y' THEN
1366: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_TMP Source';
1367: pa_debug.debug('create_cmt_txns: ' || x_err_stage);
1368: END IF; /* 14457478 */
1369: END IF;
1370:
1371: -- Insert Commitments from the Oracle Projects User-Defined PA_COMMITMENT_TXNS_V

Line 2520: pa_debug.debug('create_cmt_txns: ' || 'Records Inserted = '||TO_CHAR(SQL%ROWCOUNT));

2516: -- End: Grants Management Integrated Commitment Processing ---------------------
2517:
2518:
2519: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2520: pa_debug.debug('create_cmt_txns: ' || 'Records Inserted = '||TO_CHAR(SQL%ROWCOUNT));
2521: END IF;
2522:
2523: EXCEPTION
2524: WHEN OTHERS THEN

Line 2760: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/Added the default profile option variable initialization for bug 2674619/

2756: x_cdl_line_type IN VARCHAR2,
2757: x_err_stage IN OUT NOCOPY VARCHAR2,
2758: x_err_code IN OUT NOCOPY NUMBER)
2759: IS
2760: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
2761:
2762:
2763: -- The cursor selcdl selects all CDLs which
2764: -- satisfy the pa_period given as the parameters

Line 2962: pa_debug.debug('accum_cdls: ' || x_err_stage);

2958: commit_rows :=0;
2959: x_err_stage := 'Accumulating CDLs';
2960:
2961: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2962: pa_debug.debug('accum_cdls: ' || x_err_stage);
2963: END IF;
2964:
2965: /* Included for bug# 1770772 */
2966:

Line 3142: pa_debug.debug('accum_cdls: ' || 'Number of CDL Processed = ' || TO_CHAR(row_processed));

3138: COMMIT;
3139: END IF;
3140:
3141: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3142: pa_debug.debug('accum_cdls: ' || 'Number of CDL Processed = ' || TO_CHAR(row_processed));
3143: END IF;
3144:
3145: EXCEPTION
3146: WHEN OTHERS THEN

Line 3188: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/Added the default profile option variable initialization for bug 2674619/

3184: x_mode IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
3185: x_err_stage IN OUT NOCOPY VARCHAR2,
3186: x_err_code IN OUT NOCOPY NUMBER)
3187: IS
3188: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
3189:
3190:
3191: CURSOR selrdls IS
3192: SELECT

Line 3287: pa_debug.debug('accum_rdls: ' || x_err_stage);

3283: x_err_code :=0;
3284: row_processed :=0;
3285: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3286: x_err_stage := 'Accumulating revenue';
3287: pa_debug.debug('accum_rdls: ' || x_err_stage);
3288: END IF;
3289:
3290: FOR rdlrec IN selrdls LOOP
3291:

Line 3370: pa_debug.debug('accum_rdls: ' || 'Number of RDL Processed = ' || TO_CHAR(row_processed));

3366:
3367: END LOOP;
3368:
3369: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3370: pa_debug.debug('accum_rdls: ' || 'Number of RDL Processed = ' || TO_CHAR(row_processed));
3371: END IF;
3372:
3373: EXCEPTION
3374: WHEN OTHERS THEN

Line 3417: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/Added the default profile option variable initialization for bug 2674619/

3413: x_mode IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
3414: x_err_stage IN OUT NOCOPY VARCHAR2,
3415: x_err_code IN OUT NOCOPY NUMBER)
3416: IS
3417: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
3418:
3419:
3420:
3421: CURSOR selevents IS

Line 3505: pa_debug.debug('accum_erdls: ' || x_err_stage);

3501: x_err_code :=0;
3502: row_processed :=0;
3503: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3504: x_err_stage := 'Accumulating Event Revenue';
3505: pa_debug.debug('accum_erdls: ' || x_err_stage);
3506: END IF;
3507:
3508: FOR eventrec IN selevents LOOP
3509:

Line 3588: pa_debug.debug('accum_erdls: ' || 'Number of Event RDL Processed = ' || TO_CHAR(row_processed));

3584:
3585: END LOOP;
3586:
3587: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3588: pa_debug.debug('accum_erdls: ' || 'Number of Event RDL Processed = ' || TO_CHAR(row_processed));
3589: END IF;
3590:
3591: EXCEPTION
3592: WHEN OTHERS THEN

Line 3636: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/Added the default profile option variable initialization for bug 2674619/

3632: x_mode IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
3633: x_err_stage IN OUT NOCOPY VARCHAR2,
3634: x_err_code IN OUT NOCOPY NUMBER)
3635: IS
3636: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
3637:
3638: CURSOR selrdls IS
3639: SELECT
3640: 'R' line_type,

Line 3771: pa_debug.debug('accum_revenue: ' || x_err_stage);

3767:
3768: BEGIN
3769: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3770: x_err_stage := 'Accumulating All Revenues';
3771: pa_debug.debug('accum_revenue: ' || x_err_stage);
3772: END IF;
3773:
3774: x_txn_accum_id :=0;
3775: x_err_code :=0;

Line 3781: -- pa_debug.debug('Each row, drrowid='||rdlrec.drrowid);

3777: commit_rows :=0;
3778:
3779:
3780: FOR rdlrec IN selrdls LOOP
3781: -- pa_debug.debug('Each row, drrowid='||rdlrec.drrowid);
3782: -- pa_debug.debug('Each row, curr_rowid='||curr_rowid);
3783:
3784: row_processed := row_processed + 1;
3785:

Line 3782: -- pa_debug.debug('Each row, curr_rowid='||curr_rowid);

3778:
3779:
3780: FOR rdlrec IN selrdls LOOP
3781: -- pa_debug.debug('Each row, drrowid='||rdlrec.drrowid);
3782: -- pa_debug.debug('Each row, curr_rowid='||curr_rowid);
3783:
3784: row_processed := row_processed + 1;
3785:
3786: IF rdlrec.drrowid <> curr_rowid THEN

Line 3787: -- pa_debug.debug('drrowid='||rdlrec.drrowid);

3783:
3784: row_processed := row_processed + 1;
3785:
3786: IF rdlrec.drrowid <> curr_rowid THEN
3787: -- pa_debug.debug('drrowid='||rdlrec.drrowid);
3788: -- pa_debug.debug('curr_rowid='||curr_rowid);
3789:
3790: --- Update the DR.Resource_accumulated_flag = 'Y' Now
3791: UPDATE

Line 3788: -- pa_debug.debug('curr_rowid='||curr_rowid);

3784: row_processed := row_processed + 1;
3785:
3786: IF rdlrec.drrowid <> curr_rowid THEN
3787: -- pa_debug.debug('drrowid='||rdlrec.drrowid);
3788: -- pa_debug.debug('curr_rowid='||curr_rowid);
3789:
3790: --- Update the DR.Resource_accumulated_flag = 'Y' Now
3791: UPDATE
3792: pa_draft_revenues

Line 3806: pa_debug.debug('accum_revenue: ' || 'Number of Records Commited = '|| TO_CHAR(commit_rows));

3802:
3803: IF commit_rows >= pa_proj_accum_main.x_commit_size THEN
3804: COMMIT;
3805: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3806: pa_debug.debug('accum_revenue: ' || 'Number of Records Commited = '|| TO_CHAR(commit_rows));
3807: END IF;
3808: commit_rows := 0;
3809: END IF;
3810: END IF;

Line 3897: pa_debug.debug('accum_revenue: ' || 'Number of Draft Revenues Processed = '||TO_CHAR(row_processed));

3893:
3894: COMMIT;
3895:
3896: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3897: pa_debug.debug('accum_revenue: ' || 'Number of Draft Revenues Processed = '||TO_CHAR(row_processed));
3898: END IF;
3899:
3900: EXCEPTION
3901: WHEN OTHERS THEN

Line 3926: -- 3) Removed pa_debug design elements.

3922: -- 04-MAR-99 jwhite Implemented latest design changes:
3923: -- 1) Removed all references to amount_delivered columns.
3924: -- 2) Added generation_error_flag to Update
3925: -- pa_project_accum_headers
3926: -- 3) Removed pa_debug design elements.
3927: --
3928: -- 03-DEC-2001 jwhite Bug 2119738
3929: -- The parameter list for the following was changed:
3930: -- pa_multi_currency_txn.get_currency_amounts. This change

Line 3942: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/Added the default profile option variable initialization for bug 2674619/

3938: x_system_linkage_function IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
3939: x_err_stage IN OUT NOCOPY VARCHAR2,
3940: x_err_code IN OUT NOCOPY NUMBER)
3941: IS
3942: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
3943: --
3944: -- Cursors ---------------------------------------------------
3945: --
3946: -- The cursor selcmts selects all PA_COMMITMENT_TXNS which

Line 4053: pa_debug.debug('accum_commitments: ' || x_err_stage);

4049:
4050: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
4051: x_err_stage := 'Accumulating Commitments';
4052: row_processed :=0;
4053: pa_debug.debug('accum_commitments: ' || x_err_stage);
4054: END IF;
4055:
4056:
4057: -- Get Project Currency Code for Project

Line 4291: pa_debug.debug('accum_commitments: ' || 'Number of Commitments Processed = ' || TO_CHAR(row_processed));

4287: END LOOP; -- CMTREC Processing
4288:
4289: COMMIT;
4290: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
4291: pa_debug.debug('accum_commitments: ' || 'Number of Commitments Processed = ' || TO_CHAR(row_processed));
4292: END IF;
4293:
4294: --
4295: -- UPDATE PROJECT LOCKROW to Record Exception, If Any -----------