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 1034: fa_debug_pkg.add(l_calling_fn,

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

Line 1054: fa_debug_pkg.add(l_calling_fn,

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

Line 1062: fa_debug_pkg.add(l_calling_fn,

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

Line 1070: fa_debug_pkg.add(l_calling_fn,

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

Line 1079: fa_debug_pkg.add(l_calling_fn,

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

Line 1343: fa_debug_pkg.add(l_calling_fn,

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

Line 1355: fa_debug_pkg.add(l_calling_fn,

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

Line 1433: fa_debug_pkg.add(l_calling_fn,

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

Line 1526: fa_debug_pkg.add(l_calling_fn,

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

Line 1536: fa_debug_pkg.add(l_calling_fn,

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

Line 1560: fa_debug_pkg.add(l_calling_fn,

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

Line 1572: fa_debug_pkg.add(l_calling_fn,

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

Line 1591: fa_debug_pkg.add(l_calling_fn,

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

Line 1604: fa_debug_pkg.add(l_calling_fn,

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

Line 1617: fa_debug_pkg.add(l_calling_fn,

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

Line 1631: fa_debug_pkg.add(l_calling_fn,

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

Line 1640: fa_debug_pkg.add(l_calling_fn,

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