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.FA_CUA_MASS_EXT_RET_PKG dependencies on FA_DEBUG_PKG

Line 497: FA_DEBUG_PKG.Initialize;

493: g_log_level_rec.statement_level := fa_cache_pkg.fa_print_debug;
494: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
495:
496: -- clear the debug stack initially and later for each asset
497: FA_DEBUG_PKG.Initialize;
498: -- reset the message level to prevent bogus errors
499: FA_SRVR_MSG.Set_Message_Level(message_level => 10);
500:
501: g_i := 0;

Line 503: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_retire_id', px_max_mass_ext_retire_id,g_log_level_rec);

499: FA_SRVR_MSG.Set_Message_Level(message_level => 10);
500:
501: g_i := 0;
502: if (g_log_level_rec.statement_level) then
503: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_retire_id', px_max_mass_ext_retire_id,g_log_level_rec);
504: fa_debug_pkg.add(l_calling_fn, 'p_book', p_book_type_code, g_log_level_rec);
505: fa_debug_pkg.add(l_calling_fn, 'p_parent_request_id', p_parent_request_id,g_log_level_rec);
506: fa_debug_pkg.add(l_calling_fn, 'p_total_requests', p_total_requests,g_log_level_rec);
507: fa_debug_pkg.add(l_calling_fn, 'p_request_number', p_request_number,g_log_level_rec);

Line 504: fa_debug_pkg.add(l_calling_fn, 'p_book', p_book_type_code, g_log_level_rec);

500:
501: g_i := 0;
502: if (g_log_level_rec.statement_level) then
503: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_retire_id', px_max_mass_ext_retire_id,g_log_level_rec);
504: fa_debug_pkg.add(l_calling_fn, 'p_book', p_book_type_code, g_log_level_rec);
505: fa_debug_pkg.add(l_calling_fn, 'p_parent_request_id', p_parent_request_id,g_log_level_rec);
506: fa_debug_pkg.add(l_calling_fn, 'p_total_requests', p_total_requests,g_log_level_rec);
507: fa_debug_pkg.add(l_calling_fn, 'p_request_number', p_request_number,g_log_level_rec);
508: end if;

Line 505: fa_debug_pkg.add(l_calling_fn, 'p_parent_request_id', p_parent_request_id,g_log_level_rec);

501: g_i := 0;
502: if (g_log_level_rec.statement_level) then
503: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_retire_id', px_max_mass_ext_retire_id,g_log_level_rec);
504: fa_debug_pkg.add(l_calling_fn, 'p_book', p_book_type_code, g_log_level_rec);
505: fa_debug_pkg.add(l_calling_fn, 'p_parent_request_id', p_parent_request_id,g_log_level_rec);
506: fa_debug_pkg.add(l_calling_fn, 'p_total_requests', p_total_requests,g_log_level_rec);
507: fa_debug_pkg.add(l_calling_fn, 'p_request_number', p_request_number,g_log_level_rec);
508: end if;
509:

Line 506: fa_debug_pkg.add(l_calling_fn, 'p_total_requests', p_total_requests,g_log_level_rec);

502: if (g_log_level_rec.statement_level) then
503: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_retire_id', px_max_mass_ext_retire_id,g_log_level_rec);
504: fa_debug_pkg.add(l_calling_fn, 'p_book', p_book_type_code, g_log_level_rec);
505: fa_debug_pkg.add(l_calling_fn, 'p_parent_request_id', p_parent_request_id,g_log_level_rec);
506: fa_debug_pkg.add(l_calling_fn, 'p_total_requests', p_total_requests,g_log_level_rec);
507: fa_debug_pkg.add(l_calling_fn, 'p_request_number', p_request_number,g_log_level_rec);
508: end if;
509:
510: -- if (g_log_level_rec.statement_level) then

Line 507: fa_debug_pkg.add(l_calling_fn, 'p_request_number', p_request_number,g_log_level_rec);

503: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_retire_id', px_max_mass_ext_retire_id,g_log_level_rec);
504: fa_debug_pkg.add(l_calling_fn, 'p_book', p_book_type_code, g_log_level_rec);
505: fa_debug_pkg.add(l_calling_fn, 'p_parent_request_id', p_parent_request_id,g_log_level_rec);
506: fa_debug_pkg.add(l_calling_fn, 'p_total_requests', p_total_requests,g_log_level_rec);
507: fa_debug_pkg.add(l_calling_fn, 'p_request_number', p_request_number,g_log_level_rec);
508: end if;
509:
510: -- if (g_log_level_rec.statement_level) then
511: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

Line 511: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

507: fa_debug_pkg.add(l_calling_fn, 'p_request_number', p_request_number,g_log_level_rec);
508: end if;
509:
510: -- if (g_log_level_rec.statement_level) then
511: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
512: -- end if;
513:
514:
515: -- Initial outfile heading

Line 523: fa_debug_pkg.add('FACXTREMB.pls',

519:
520: if (px_max_mass_ext_retire_id = 0) then
521:
522: if (g_log_level_rec.statement_level) then
523: fa_debug_pkg.add('FACXTREMB.pls',
524: 'FND_FILE init: BOOK ',
525: P_BOOK_TYPE_CODE,g_log_level_rec);
526: End if;
527:

Line 545: fa_debug_pkg.add('FACXTREMB.pls',

541: FND_FILE.new_line(FND_FILE.output,1);
542:
543: end if;
544: if (g_log_level_rec.statement_level) then
545: fa_debug_pkg.add('FACXTREMB.pls',
546: 'Before CRL test ',
547: '',g_log_level_rec);
548: End if;
549:

Line 578: fa_debug_pkg.add('FACXTREMB.pls',

574: end if;
575:
576:
577: if (g_log_level_rec.statement_level) then
578: fa_debug_pkg.add('FACXTREMB.pls',
579: 'Before mass ext mainselect ',
580: '',g_log_level_rec);
581: End if;
582:

Line 652: fa_debug_pkg.add('FACXTREMB.pls',

648: LIMIT l_batch_size;
649: Close Mass_external_retirement;
650:
651: IF (g_log_level_rec.statement_level) then
652: fa_debug_pkg.add('FACXTREMB.pls',
653: 'Before for loop, number of loops ',
654: l_asset_id.count);
655: END IF;
656:

Line 663: FA_DEBUG_PKG.Initialize;

659: raise done_exc;
660: end if;
661:
662: -- clear the debug stack for each asset
663: FA_DEBUG_PKG.Initialize;
664: -- reset the message level to prevent bogus errors
665: FA_SRVR_MSG.Set_Message_Level(message_level => 10);
666:
667: For i in 1..l_asset_id.count loop -- mass_external_retirement

Line 746: fa_debug_pkg.add('FACXTREMB.pls',

742: g_attribute14 := L_Attribute14(i);
743: g_attribute15 := L_Attribute15(i);
744:
745: IF (g_log_level_rec.statement_level) then
746: fa_debug_pkg.add('FACXTREMB.pls',
747: 'Before Validation subblock: asset_id',
748: g_asset_id,g_log_level_rec);
749: END IF;
750:

Line 790: fa_debug_pkg.add('FACXTREMB.pls',

786: g_single_dist_array := 'YES';
787: end if;
788:
789: IF (g_log_level_rec.statement_level) then
790: fa_debug_pkg.add('FACXTREMB.pls',
791: 'g_single_dist_array:',
792: g_single_dist_array, g_log_level_rec );
793: end if;
794:

Line 805: fa_debug_pkg.add('FACXTREMB.pls',

801: -- Deleting table only when changing asset, also when changing batch...?
802: l_asset_dist_tbl.delete;
803:
804: IF (g_log_level_rec.statement_level) then
805: fa_debug_pkg.add('FACXTREMB.pls',
806: 'Number of distributions:',
807: g_num_of_distributions,g_log_level_rec);
808: END IF;
809:

Line 879: fa_debug_pkg.add('FACXTREMB.pls',

875:
876: end if; -- if distribution_id null
877:
878: IF (g_log_level_rec.statement_level) then
879: fa_debug_pkg.add('FACXTREMB.pls',
880: 'Before validate call mass_ext_ret_id ',
881: g_mass_external_retire_id,g_log_level_rec);
882: END IF;
883:

Line 887: fa_debug_pkg.add('FACXTREMB.pls',

883:
884: -- modified and added additional logic for bugfix 2036777
885:
886: IF (g_log_level_rec.statement_level) then
887: fa_debug_pkg.add('FACXTREMB.pls',
888: 'Before source line retirement loop: lv_new_inv_txn_id',
889: lv_new_inv_txn_id,g_log_level_rec);
890: END IF;
891:

Line 898: fa_debug_pkg.add('FACXTREMB.pls',

894: l_inv_tbl.delete;
895: For Source_lines_rec in Source_lines_C Loop
896:
897: IF (g_log_level_rec.statement_level) then
898: fa_debug_pkg.add('FACXTREMB.pls',
899: 'In source line retirement loop:',
900: source_lines_rec.source_line_id,g_log_level_rec);
901: END IF;
902:

Line 920: fa_debug_pkg.add('FACXTREMB.pls',

916:
917: -- ***** Invoice Info ***** --
918:
919: IF (g_log_level_rec.statement_level) then
920: fa_debug_pkg.add('FACXTREMB.pls',
921: 'In source line loop 2: c3_lines.slid',
922: c3_lines.source_line_id,g_log_level_rec);
923: END IF;
924: -- Use C3_lines.Source_Line_ID, due to bug 2036777

Line 944: fa_debug_pkg.add('FACXTREMB.pls',

940:
941: end loop;
942:
943: IF (g_log_level_rec.statement_level) then
944: fa_debug_pkg.add('FACXTREMB.pls',
945: 'Before loading arrays: Transaction_name ',
946: g_transaction_name, g_log_level_rec);
947: END IF;
948:

Line 954: fa_debug_pkg.add('FACXTREMB.pls',

950: -- ***** Asset Transaction Info ***** --
951: -- activate when mass_transaction_id exists in trans_rec.
952: -- mass_transaction_id only populated where we have a prim-foreign key relation
953: IF (g_log_level_rec.statement_level) then
954: fa_debug_pkg.add('FACXTREMB.pls',
955: 'Loading arrays: g_Batch_name ',
956: g_batch_name,g_log_level_rec);
957: END IF;
958:

Line 966: fa_debug_pkg.add('FACXTREMB.pls',

962: l_trans_rec.mass_transaction_id := to_number(substr(g_batch_name,9,30));
963: end if;
964:
965: IF (g_log_level_rec.statement_level) then
966: fa_debug_pkg.add('FACXTREMB.pls',
967: 'Loading arrays: Mass trx id ',
968: l_trans_rec.mass_transaction_id, g_log_level_rec);
969: END IF;
970:

Line 1042: fa_debug_pkg.add('FACXTREMB.pls',

1038: -- Derive set of books id for primary book
1039: l_asset_hdr_rec.set_of_books_id := G_set_of_books_id;
1040:
1041: IF (g_log_level_rec.statement_level) then
1042: fa_debug_pkg.add('FACXTREMB.pls',
1043: 'Before loading Retirement1 arrays: cost_retired ',
1044: g_cost_retired,g_log_level_rec);
1045: fa_debug_pkg.add('FACXTREMB.pls',
1046: 'Before loading Retirement1 arrays: units_retired ',

Line 1045: fa_debug_pkg.add('FACXTREMB.pls',

1041: IF (g_log_level_rec.statement_level) then
1042: fa_debug_pkg.add('FACXTREMB.pls',
1043: 'Before loading Retirement1 arrays: cost_retired ',
1044: g_cost_retired,g_log_level_rec);
1045: fa_debug_pkg.add('FACXTREMB.pls',
1046: 'Before loading Retirement1 arrays: units_retired ',
1047: g_units, g_log_level_rec);
1048: END IF;
1049:

Line 1094: fa_debug_pkg.add('FACXTREMB.pls',

1090: l_asset_retire_rec.desc_flex.attribute_category_code :=
1091: g_attribute_category;
1092:
1093: IF (g_log_level_rec.statement_level) then
1094: fa_debug_pkg.add('FACXTREMB.pls',
1095: 'Before loading dist arrays g_units',
1096: g_units, g_log_level_rec);
1097: fa_debug_pkg.add('FACXTREMB.pls',
1098: 'Before loading dist arrays g_current_units',

Line 1097: fa_debug_pkg.add('FACXTREMB.pls',

1093: IF (g_log_level_rec.statement_level) then
1094: fa_debug_pkg.add('FACXTREMB.pls',
1095: 'Before loading dist arrays g_units',
1096: g_units, g_log_level_rec);
1097: fa_debug_pkg.add('FACXTREMB.pls',
1098: 'Before loading dist arrays g_current_units',
1099: g_current_units, g_log_level_rec);
1100: END IF;
1101:

Line 1108: fa_debug_pkg.add('FACXTREMB.pls',

1104: -- l_asset_dist_tbl.delete;
1105: if ( nvl(G_Units,0) <> 0 and G_Units < G_current_units) then
1106: -- ***** Asset Distribution Info ***** --
1107: IF (g_log_level_rec.statement_level) then
1108: fa_debug_pkg.add('FACXTREMB.pls',
1109: 'Before loading dist arrays inside if',
1110: g_current_units, g_log_level_rec);
1111: END IF;
1112:

Line 1135: fa_debug_pkg.add('FACXTREMB.pls',

1131: l_asset_dist_rec.distribution_id := g_distribution_id;
1132: l_asset_dist_tbl(num_dist) := l_asset_dist_rec;
1133:
1134: IF (g_log_level_rec.statement_level) then
1135: fa_debug_pkg.add('FACXTREMB.pls',
1136: 'Before loading dist arrays inside if',
1137: num_dist, g_log_level_rec);
1138: fa_debug_pkg.add('FACXTREMB.pls',
1139: 'Before loading dist arrays inside if',

Line 1138: fa_debug_pkg.add('FACXTREMB.pls',

1134: IF (g_log_level_rec.statement_level) then
1135: fa_debug_pkg.add('FACXTREMB.pls',
1136: 'Before loading dist arrays inside if',
1137: num_dist, g_log_level_rec);
1138: fa_debug_pkg.add('FACXTREMB.pls',
1139: 'Before loading dist arrays inside if',
1140: g_distribution_id, g_log_level_rec);
1141: fa_debug_pkg.add('FACXTREMB.pls',
1142: 'Before loading dist arrays inside if',

Line 1141: fa_debug_pkg.add('FACXTREMB.pls',

1137: num_dist, g_log_level_rec);
1138: fa_debug_pkg.add('FACXTREMB.pls',
1139: 'Before loading dist arrays inside if',
1140: g_distribution_id, g_log_level_rec);
1141: fa_debug_pkg.add('FACXTREMB.pls',
1142: 'Before loading dist arrays inside if',
1143: g_location_id, g_log_level_rec);
1144: fa_debug_pkg.add('FACXTREMB.pls',
1145: 'Before loading dist arrays inside if',

Line 1144: fa_debug_pkg.add('FACXTREMB.pls',

1140: g_distribution_id, g_log_level_rec);
1141: fa_debug_pkg.add('FACXTREMB.pls',
1142: 'Before loading dist arrays inside if',
1143: g_location_id, g_log_level_rec);
1144: fa_debug_pkg.add('FACXTREMB.pls',
1145: 'Before loading dist arrays inside if',
1146: g_code_combination_id,g_log_level_rec);
1147: fa_debug_pkg.add('FACXTREMB.pls',
1148: 'Before loading dist arrays inside if',

Line 1147: fa_debug_pkg.add('FACXTREMB.pls',

1143: g_location_id, g_log_level_rec);
1144: fa_debug_pkg.add('FACXTREMB.pls',
1145: 'Before loading dist arrays inside if',
1146: g_code_combination_id,g_log_level_rec);
1147: fa_debug_pkg.add('FACXTREMB.pls',
1148: 'Before loading dist arrays inside if',
1149: l_asset_dist_rec.transaction_units,g_log_level_rec);
1150: END IF;
1151:

Line 1178: fa_debug_pkg.add('FACXTREMB.pls',

1174:
1175: if (g_num_of_distributions = 0) OR (g_single_dist_array = 'YES') then
1176:
1177: IF (g_log_level_rec.statement_level) then
1178: fa_debug_pkg.add('FACXTREMB.pls',
1179: 'Before do_retirement call ',
1180: G_Asset_Number, g_log_level_rec);
1181: END IF;
1182:

Line 1202: fa_debug_pkg.add('FACXTREMB.pls',

1198: p_subcomp_tbl => l_subcomp_tbl,
1199: p_inv_tbl => l_inv_tbl);
1200:
1201: IF (g_log_level_rec.statement_level) then
1202: fa_debug_pkg.add('FACXTREMB.pls',
1203: 'After do_retirement call, status',
1204: l_return_status, g_log_level_rec);
1205: fa_debug_pkg.add('FACXTREMB.pls',
1206: 'After do_retirement call, msg_count',

Line 1205: fa_debug_pkg.add('FACXTREMB.pls',

1201: IF (g_log_level_rec.statement_level) then
1202: fa_debug_pkg.add('FACXTREMB.pls',
1203: 'After do_retirement call, status',
1204: l_return_status, g_log_level_rec);
1205: fa_debug_pkg.add('FACXTREMB.pls',
1206: 'After do_retirement call, msg_count',
1207: l_msg_count, g_log_level_rec);
1208: END IF;
1209:

Line 1227: fa_debug_pkg.add('FACXTREMB.pls',

1223: G_success_count := G_success_count + 1;
1224: x_success_count := x_success_count + 1;
1225:
1226: IF (g_log_level_rec.statement_level) then
1227: fa_debug_pkg.add('FACXTREMB.pls',
1228: 'Skipped do_retirement call ',
1229: g_num_of_distributions, g_log_level_rec);
1230: END IF;
1231:

Line 1260: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

1256: Exception
1257: WHEN G_Subroutine_Fail THEN
1258:
1259: -- if (g_log_level_rec.statement_level) then
1260: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1261: -- end if;
1262:
1263: UPDATE fa_mass_Ext_retirements
1264: SET review_status = 'ERROR',

Line 1293: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

1289: WHEN Validation_Error THEN
1290:
1291: FND_CONCURRENT.AF_ROLLBACK;
1292: -- if( g_log_level_rec.statement_level) then
1293: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1294: -- end if;
1295:
1296: UPDATE fa_mass_Ext_retirements
1297: SET review_status = 'ERROR',

Line 1336: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

1332: WHEN Fully_Reserved_Error THEN
1333:
1334: FND_CONCURRENT.AF_ROLLBACK;
1335: -- if( g_log_level_rec.statement_level) then
1336: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1337: -- end if;
1338:
1339: UPDATE fa_mass_Ext_retirements
1340: SET review_status = 'ERROR',

Line 1367: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

1363:
1364: FND_CONCURRENT.AF_ROLLBACK;
1365:
1366: -- if(g_log_level_rec.statement_level) then
1367: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1368: -- end if;
1369:
1370: UPDATE fa_mass_Ext_retirements
1371: SET review_status = 'ERROR',

Line 1410: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_retire_id', px_max_mass_ext_retire_id, g_log_level_rec);

1406:
1407:
1408:
1409: if (g_log_level_rec.statement_level) then
1410: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_retire_id', px_max_mass_ext_retire_id, g_log_level_rec);
1411: fa_debug_pkg.add(l_calling_fn, 'End of Mass External Retirement session', x_return_status,g_log_level_rec);
1412: end if;
1413:
1414: -- if (g_log_level_rec.statement_level) then

Line 1411: fa_debug_pkg.add(l_calling_fn, 'End of Mass External Retirement session', x_return_status,g_log_level_rec);

1407:
1408:
1409: if (g_log_level_rec.statement_level) then
1410: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_retire_id', px_max_mass_ext_retire_id, g_log_level_rec);
1411: fa_debug_pkg.add(l_calling_fn, 'End of Mass External Retirement session', x_return_status,g_log_level_rec);
1412: end if;
1413:
1414: -- if (g_log_level_rec.statement_level) then
1415: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

Line 1415: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

1411: fa_debug_pkg.add(l_calling_fn, 'End of Mass External Retirement session', x_return_status,g_log_level_rec);
1412: end if;
1413:
1414: -- if (g_log_level_rec.statement_level) then
1415: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1416: -- end if;
1417:
1418:
1419: EXCEPTION -- Mass_Ext_Retire

Line 1428: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

1424: x_return_status := 0;
1425: FND_CONCURRENT.AF_COMMIT;
1426:
1427: -- if (g_log_level_rec.statement_level) then
1428: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1429: -- end if;
1430:
1431: -- msiddiqu Feb-24-2001
1432: WHEN pending_batch THEN

Line 1463: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

1459: FND_CONCURRENT.AF_COMMIT;
1460: x_return_status := 2;
1461:
1462: -- if (g_log_level_rec.statement_level) then
1463: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1464: -- end if;
1465:
1466:
1467: WHEN Init_problem THEN

Line 1488: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

1484:
1485: x_return_status := 2;
1486:
1487: -- if (g_log_level_rec.statement_level) then
1488: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1489: -- end if;
1490:
1491:
1492: WHEN Others THEN

Line 1513: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

1509:
1510: x_return_status := 2;
1511:
1512: -- if (g_log_level_rec.statement_level) then
1513: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1514: -- end if;
1515:
1516:
1517: END Mass_Ext_Retire;