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
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 1363: pa_debug.debug('create_cmt_txns: ' || x_err_stage);

1359: ELSE
1360:
1361: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1362: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_V Source';
1363: pa_debug.debug('create_cmt_txns: ' || x_err_stage);
1364: END IF;
1365:
1366: -- Insert Commitments from the Oracle Projects User-Defined PA_COMMITMENT_TXNS_V
1367: -- View.

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

2431: -- End: Grants Management Integrated Commitment Processing ---------------------
2432:
2433:
2434: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2435: pa_debug.debug('create_cmt_txns: ' || 'Records Inserted = '||TO_CHAR(SQL%ROWCOUNT));
2436: END IF;
2437:
2438: EXCEPTION
2439: WHEN OTHERS THEN

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

2665: x_cdl_line_type IN VARCHAR2,
2666: x_err_stage IN OUT NOCOPY VARCHAR2,
2667: x_err_code IN OUT NOCOPY NUMBER)
2668: IS
2669: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
2670:
2671:
2672: -- The cursor selcdl selects all CDLs which
2673: -- satisfy the pa_period given as the parameters

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

2831: commit_rows :=0;
2832: x_err_stage := 'Accumulating CDLs';
2833:
2834: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2835: pa_debug.debug('accum_cdls: ' || x_err_stage);
2836: END IF;
2837:
2838: /* Included for bug# 1770772 */
2839:

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

2958: COMMIT;
2959: END IF;
2960:
2961: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2962: pa_debug.debug('accum_cdls: ' || 'Number of CDL Processed = ' || TO_CHAR(row_processed));
2963: END IF;
2964:
2965: EXCEPTION
2966: WHEN OTHERS THEN

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

3004: x_mode IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
3005: x_err_stage IN OUT NOCOPY VARCHAR2,
3006: x_err_code IN OUT NOCOPY NUMBER)
3007: IS
3008: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
3009:
3010:
3011: CURSOR selrdls IS
3012: SELECT

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

3103: x_err_code :=0;
3104: row_processed :=0;
3105: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3106: x_err_stage := 'Accumulating revenue';
3107: pa_debug.debug('accum_rdls: ' || x_err_stage);
3108: END IF;
3109:
3110: FOR rdlrec IN selrdls LOOP
3111:

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

3186:
3187: END LOOP;
3188:
3189: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3190: pa_debug.debug('accum_rdls: ' || 'Number of RDL Processed = ' || TO_CHAR(row_processed));
3191: END IF;
3192:
3193: EXCEPTION
3194: WHEN OTHERS THEN

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

3233: x_mode IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
3234: x_err_stage IN OUT NOCOPY VARCHAR2,
3235: x_err_code IN OUT NOCOPY NUMBER)
3236: IS
3237: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
3238:
3239:
3240:
3241: CURSOR selevents IS

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

3321: x_err_code :=0;
3322: row_processed :=0;
3323: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3324: x_err_stage := 'Accumulating Event Revenue';
3325: pa_debug.debug('accum_erdls: ' || x_err_stage);
3326: END IF;
3327:
3328: FOR eventrec IN selevents LOOP
3329:

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

3404:
3405: END LOOP;
3406:
3407: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3408: pa_debug.debug('accum_erdls: ' || 'Number of Event RDL Processed = ' || TO_CHAR(row_processed));
3409: END IF;
3410:
3411: EXCEPTION
3412: WHEN OTHERS THEN

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

3452: x_mode IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
3453: x_err_stage IN OUT NOCOPY VARCHAR2,
3454: x_err_code IN OUT NOCOPY NUMBER)
3455: IS
3456: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
3457:
3458: CURSOR selrdls IS
3459: SELECT
3460: 'R' line_type,

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

3587:
3588: BEGIN
3589: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3590: x_err_stage := 'Accumulating All Revenues';
3591: pa_debug.debug('accum_revenue: ' || x_err_stage);
3592: END IF;
3593:
3594: x_txn_accum_id :=0;
3595: x_err_code :=0;

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

3597: commit_rows :=0;
3598:
3599:
3600: FOR rdlrec IN selrdls LOOP
3601: -- pa_debug.debug('Each row, drrowid='||rdlrec.drrowid);
3602: -- pa_debug.debug('Each row, curr_rowid='||curr_rowid);
3603:
3604: row_processed := row_processed + 1;
3605:

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

3598:
3599:
3600: FOR rdlrec IN selrdls LOOP
3601: -- pa_debug.debug('Each row, drrowid='||rdlrec.drrowid);
3602: -- pa_debug.debug('Each row, curr_rowid='||curr_rowid);
3603:
3604: row_processed := row_processed + 1;
3605:
3606: IF rdlrec.drrowid <> curr_rowid THEN

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

3603:
3604: row_processed := row_processed + 1;
3605:
3606: IF rdlrec.drrowid <> curr_rowid THEN
3607: -- pa_debug.debug('drrowid='||rdlrec.drrowid);
3608: -- pa_debug.debug('curr_rowid='||curr_rowid);
3609:
3610: --- Update the DR.Resource_accumulated_flag = 'Y' Now
3611: UPDATE

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

3604: row_processed := row_processed + 1;
3605:
3606: IF rdlrec.drrowid <> curr_rowid THEN
3607: -- pa_debug.debug('drrowid='||rdlrec.drrowid);
3608: -- pa_debug.debug('curr_rowid='||curr_rowid);
3609:
3610: --- Update the DR.Resource_accumulated_flag = 'Y' Now
3611: UPDATE
3612: pa_draft_revenues

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

3622:
3623: IF commit_rows >= pa_proj_accum_main.x_commit_size THEN
3624: COMMIT;
3625: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3626: pa_debug.debug('accum_revenue: ' || 'Number of Records Commited = '|| TO_CHAR(commit_rows));
3627: END IF;
3628: commit_rows := 0;
3629: END IF;
3630: END IF;

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

3713:
3714: COMMIT;
3715:
3716: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3717: pa_debug.debug('accum_revenue: ' || 'Number of Draft Revenues Processed = '||TO_CHAR(row_processed));
3718: END IF;
3719:
3720: EXCEPTION
3721: WHEN OTHERS THEN

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

3742: -- 04-MAR-99 jwhite Implemented latest design changes:
3743: -- 1) Removed all references to amount_delivered columns.
3744: -- 2) Added generation_error_flag to Update
3745: -- pa_project_accum_headers
3746: -- 3) Removed pa_debug design elements.
3747: --
3748: -- 03-DEC-2001 jwhite Bug 2119738
3749: -- The parameter list for the following was changed:
3750: -- pa_multi_currency_txn.get_currency_amounts. This change

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

3758: x_system_linkage_function IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
3759: x_err_stage IN OUT NOCOPY VARCHAR2,
3760: x_err_code IN OUT NOCOPY NUMBER)
3761: IS
3762: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
3763: --
3764: -- Cursors ---------------------------------------------------
3765: --
3766: -- The cursor selcmts selects all PA_COMMITMENT_TXNS which

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

3869:
3870: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3871: x_err_stage := 'Accumulating Commitments';
3872: row_processed :=0;
3873: pa_debug.debug('accum_commitments: ' || x_err_stage);
3874: END IF;
3875:
3876:
3877: -- Get Project Currency Code for Project

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

4101: END LOOP; -- CMTREC Processing
4102:
4103: COMMIT;
4104: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
4105: pa_debug.debug('accum_commitments: ' || 'Number of Commitments Processed = ' || TO_CHAR(row_processed));
4106: END IF;
4107:
4108: --
4109: -- UPDATE PROJECT LOCKROW to Record Exception, If Any -----------