DBA Data[Home] [Help]

APPS.FA_MASSADD_PREP_ENERGY_PKG dependencies on FA_DEBUG_PKG

Line 24: fa_debug_pkg.add(l_calling_fn,

20: (px_mass_add_rec.asset_category_id is not null) and
21: (px_mass_add_rec.asset_key_ccid is not null) then
22: l_debug_str := 'Check the cost';
23: if (p_log_level_rec.statement_level) then
24: fa_debug_pkg.add(l_calling_fn,
25: l_debug_str,
26: '',
27: p_log_level_rec => p_log_level_rec);
28: end if;

Line 50: fa_debug_pkg.add(l_calling_fn,

46: where mass_addition_id = px_mass_add_rec.mass_addition_id;
47: else
48: l_debug_str := 'Cost is negative';
49: if (p_log_level_rec.statement_level) then
50: fa_debug_pkg.add(l_calling_fn,
51: l_debug_str,
52: '',
53: p_log_level_rec => p_log_level_rec);
54: end if;

Line 70: fa_debug_pkg.add(l_calling_fn,

66: end if;
67: else
68: l_debug_str := 'Expense Account not generated';
69: if (p_log_level_rec.statement_level) then
70: fa_debug_pkg.add(l_calling_fn,
71: l_debug_str,
72: '',
73: p_log_level_rec => p_log_level_rec);
74: end if;

Line 112: fa_debug_pkg.add(l_calling_fn,

108: begin
109: if (px_mass_add_rec.add_to_asset_id is not null) then
110: l_debug_str := 'Check the cost validity';
111: if (p_log_level_rec.statement_level) then
112: fa_debug_pkg.add(l_calling_fn,
113: l_debug_str,
114: '',
115: p_log_level_rec => p_log_level_rec);
116: end if;

Line 134: fa_debug_pkg.add(l_calling_fn,

130: and transaction_header_id_out is null;
131: if (l_total_cost > 0) then
132: l_debug_str := 'Cost is positive';
133: if (p_log_level_rec.statement_level) then
134: fa_debug_pkg.add(l_calling_fn,
135: l_debug_str,
136: '',
137: p_log_level_rec => p_log_level_rec);
138: end if;

Line 150: fa_debug_pkg.add(l_calling_fn,

146:
147: else
148: l_debug_str := 'Cost is negative';
149: if (p_log_level_rec.statement_level) then
150: fa_debug_pkg.add(l_calling_fn,
151: l_debug_str,
152: '',
153: p_log_level_rec => p_log_level_rec);
154: end if;

Line 340: fa_debug_pkg.add(l_calling_fn,

336:
337: BEGIN
338: l_debug_str := 'Get the Asset Key';
339: if (p_log_level_rec.statement_level) then
340: fa_debug_pkg.add(l_calling_fn,
341: l_debug_str,
342: '',
343: p_log_level_rec => p_log_level_rec);
344: end if;

Line 366: fa_debug_pkg.add(l_calling_fn,

362: INTO akey_ccid_seq
363: FROM DUAL;
364: l_debug_str := 'Insert the asset key';
365: if (p_log_level_rec.statement_level) then
366: fa_debug_pkg.add(l_calling_fn,
367: l_debug_str,
368: '',
369: p_log_level_rec => p_log_level_rec);
370: end if;

Line 419: fa_debug_pkg.add(l_calling_fn,

415:
416: if (length(l_query) is not null) then
417: l_debug_str := 'Preparing the query, Define the Columns';
418: if (p_log_level_rec.statement_level) then
419: fa_debug_pkg.add(l_calling_fn,
420: l_debug_str,
421: '',
422: p_log_level_rec => p_log_level_rec);
423: end if;

Line 552: fa_debug_pkg.add(l_calling_fn,

548:
549: if (px_mass_add_rec.PAYABLES_CODE_COMBINATION_ID is not null) then
550: l_debug_str := 'Get the Accounting Flex Field';
551: if (p_log_level_rec.statement_level) then
552: fa_debug_pkg.add(l_calling_fn,
553: l_debug_str,
554: '',
555: p_log_level_rec => p_log_level_rec);
556: end if;

Line 563: fa_debug_pkg.add(l_calling_fn,

559: l_seg_num(i) := -1;
560: end loop;
561: l_debug_str := 'Get the Category Mapping';
562: if (p_log_level_rec.statement_level) then
563: fa_debug_pkg.add(l_calling_fn,
564: l_debug_str,
565: '',
566: p_log_level_rec => p_log_level_rec);
567: end if;

Line 647: fa_debug_pkg.add(l_calling_fn,

643: end loop;
644: if (px_mass_add_rec.asset_type = 'CAPITALIZED') then
645: l_debug_str := 'Get the Clearing Account for Capitalized Assets';
646: if (p_log_level_rec.statement_level) then
647: fa_debug_pkg.add(l_calling_fn,
648: l_debug_str,
649: '',
650: p_log_level_rec => p_log_level_rec);
651: end if;

Line 724: fa_debug_pkg.add(l_calling_fn,

720: gl_ccid.code_combination_id
721: and cat.book_type_code = px_mass_add_rec.book_type_code);
722: l_debug_str := 'Get the Category for Capitalized Assets';
723: if (p_log_level_rec.statement_level) then
724: fa_debug_pkg.add(l_calling_fn,
725: l_debug_str,
726: '',
727: p_log_level_rec => p_log_level_rec);
728: end if;

Line 738: fa_debug_pkg.add(l_calling_fn,

734: and rownum = 1;
735: elsif (px_mass_add_rec.asset_type = 'CIP') then
736: l_debug_str := 'Get the Clearing Account for CIP Assets';
737: if (p_log_level_rec.statement_level) then
738: fa_debug_pkg.add(l_calling_fn,
739: l_debug_str,
740: '',
741: p_log_level_rec => p_log_level_rec);
742: end if;

Line 815: fa_debug_pkg.add(l_calling_fn,

811: gl_ccid.code_combination_id
812: and cat.book_type_code = px_mass_add_rec.book_type_code);
813: l_debug_str := 'Get the Clearing Account for CIP Assets';
814: if (p_log_level_rec.statement_level) then
815: fa_debug_pkg.add(l_calling_fn,
816: l_debug_str,
817: '',
818: p_log_level_rec => p_log_level_rec);
819: end if;

Line 1032: fa_debug_pkg.add(l_calling_fn,

1028: -- Process all the records
1029: while true loop
1030: l_debug_str := 'In Loop';
1031: if (p_log_level_rec.statement_level) then
1032: fa_debug_pkg.add(l_calling_fn,
1033: l_debug_str,
1034: '',
1035: p_log_level_rec => p_log_level_rec);
1036: end if;

Line 1052: fa_debug_pkg.add(l_calling_fn,

1048: l_debug_str := 'Calling prepare_asset_key';
1049: if not prepare_asset_key(l_mass_add_rec_tbl(l_count)) then
1050: l_debug_str := 'prepare_asset_key returned failure';
1051: if (p_log_level_rec.statement_level) then
1052: fa_debug_pkg.add(l_calling_fn,
1053: l_debug_str,
1054: '',
1055: p_log_level_rec => p_log_level_rec);
1056: end if;

Line 1060: fa_debug_pkg.add(l_calling_fn,

1056: end if;
1057: end if;
1058: l_debug_str := 'Calling prepare_category';
1059: if (p_log_level_rec.statement_level) then
1060: fa_debug_pkg.add(l_calling_fn,
1061: l_debug_str,
1062: '',
1063: p_log_level_rec => p_log_level_rec);
1064: end if;

Line 1068: fa_debug_pkg.add(l_calling_fn,

1064: end if;
1065: if not prepare_category(l_mass_add_rec_tbl(l_count)) then
1066: l_debug_str := 'prepare_category returned failuer';
1067: if (p_log_level_rec.statement_level) then
1068: fa_debug_pkg.add(l_calling_fn,
1069: l_debug_str,
1070: '',
1071: p_log_level_rec => p_log_level_rec);
1072: end if;

Line 1077: fa_debug_pkg.add(l_calling_fn,

1073: end if;
1074: end loop;
1075: l_debug_str := 'Calling update_mass_additions';
1076: if (p_log_level_rec.statement_level) then
1077: fa_debug_pkg.add(l_calling_fn,
1078: l_debug_str,
1079: '',
1080: p_log_level_rec => p_log_level_rec);
1081: end if;

Line 1341: fa_debug_pkg.add(l_calling_fn,

1337: from fa_locations
1338: where rownum = 1;
1339: l_debug_str := 'Getting Mapping for Location';
1340: if (p_log_level_rec.statement_level) then
1341: fa_debug_pkg.add(l_calling_fn,
1342: l_debug_str,
1343: '',
1344: p_log_level_rec => p_log_level_rec);
1345: end if;

Line 1353: fa_debug_pkg.add(l_calling_fn,

1349: END LOOP;
1350: if (l_loc_seg_name is not null) then
1351: l_debug_str := 'Get values from payables_ccid';
1352: if (p_log_level_rec.statement_level) then
1353: fa_debug_pkg.add(l_calling_fn,
1354: l_debug_str,
1355: '',
1356: p_log_level_rec => p_log_level_rec);
1357: end if;

Line 1431: fa_debug_pkg.add(l_calling_fn,

1427: END IF;
1428: end loop;
1429: l_debug_str := 'Get the Loaction';
1430: if (p_log_level_rec.statement_level) then
1431: fa_debug_pkg.add(l_calling_fn,
1432: l_debug_str,
1433: '',
1434: p_log_level_rec => p_log_level_rec);
1435: end if;

Line 1524: fa_debug_pkg.add(l_calling_fn,

1520: l_group_asset_rec.rec_mode := 'PREPARE';
1521:
1522: l_debug_str := 'energy calling create_group_asset';
1523: if (p_log_level_rec.statement_level) then
1524: fa_debug_pkg.add(l_calling_fn,
1525: l_debug_str,
1526: '',
1527: p_log_level_rec => p_log_level_rec);
1528: end if;

Line 1534: fa_debug_pkg.add(l_calling_fn,

1530: FA_CREATE_GROUP_ASSET_PKG.create_group_asset(l_group_asset_rec,
1531: p_log_level_rec => p_log_level_rec) then
1532: l_debug_str := 'energy create_group_asset returned failure';
1533: if (p_log_level_rec.statement_level) then
1534: fa_debug_pkg.add(l_calling_fn,
1535: l_debug_str,
1536: '',
1537: p_log_level_rec => p_log_level_rec);
1538: end if;

Line 1558: fa_debug_pkg.add(l_calling_fn,

1554: if not prepare_location_id(px_mass_add_rec,
1555: p_log_level_rec => p_log_level_rec) then
1556: l_debug_str := ' energy prepare_location_id returned failure';
1557: if (p_log_level_rec.statement_level) then
1558: fa_debug_pkg.add(l_calling_fn,
1559: l_debug_str,
1560: '',
1561: p_log_level_rec => p_log_level_rec);
1562: end if;

Line 1570: fa_debug_pkg.add(l_calling_fn,

1566: if not prepare_expense_ccid(px_mass_add_rec,
1567: p_log_level_rec => p_log_level_rec) then
1568: l_debug_str := 'energy prepare_expense_ccid returned failure';
1569: if (p_log_level_rec.statement_level) then
1570: fa_debug_pkg.add(l_calling_fn,
1571: l_debug_str,
1572: '',
1573: p_log_level_rec => p_log_level_rec);
1574: end if;

Line 1589: fa_debug_pkg.add(l_calling_fn,

1585: if not prepare_group_asset_id(px_mass_add_rec,
1586: p_log_level_rec => p_log_level_rec) then
1587: l_debug_str := 'energy prepare group_asset_id returned failure';
1588: if (p_log_level_rec.statement_level) then
1589: fa_debug_pkg.add(l_calling_fn,
1590: l_debug_str,
1591: '',
1592: p_log_level_rec => p_log_level_rec);
1593: end if;

Line 1602: fa_debug_pkg.add(l_calling_fn,

1598: l_status,
1599: p_log_level_rec => p_log_level_rec)) then
1600: l_debug_str := 'check_addition_or_adj';
1601: if (p_log_level_rec.statement_level) then
1602: fa_debug_pkg.add(l_calling_fn,
1603: l_debug_str,
1604: '',
1605: p_log_level_rec => p_log_level_rec);
1606: end if;

Line 1615: fa_debug_pkg.add(l_calling_fn,

1611: if not (create_new_asset(px_mass_add_rec,
1612: p_log_level_rec => p_log_level_rec)) then
1613: l_debug_str := 'create_new_asset';
1614: if (p_log_level_rec.statement_level) then
1615: fa_debug_pkg.add(l_calling_fn,
1616: l_debug_str,
1617: '',
1618: p_log_level_rec => p_log_level_rec);
1619: end if;

Line 1629: fa_debug_pkg.add(l_calling_fn,

1625: if not (cost_adjustment(px_mass_add_rec,
1626: p_log_level_rec => p_log_level_rec)) then
1627: l_debug_str := 'cost_adjustment';
1628: if (p_log_level_rec.statement_level) then
1629: fa_debug_pkg.add(l_calling_fn,
1630: l_debug_str,
1631: '',
1632: p_log_level_rec => p_log_level_rec);
1633: end if;

Line 1638: fa_debug_pkg.add(l_calling_fn,

1634: end if;
1635: end if;
1636: l_debug_str := 'Validating expense account for distributions';
1637: if (p_log_level_rec.statement_level) then
1638: fa_debug_pkg.add(l_calling_fn,
1639: l_debug_str,
1640: '',
1641: p_log_level_rec => p_log_level_rec);
1642: end if;