DBA Data[Home] [Help]

APPS.FA_ASSET_DESC_PUB dependencies on FA_DEBUG_PKG

Line 68: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

64: end if;
65:
66: l_err_stage:= 'Compatible_API_Call';
67: if (g_log_level_rec.statement_level) then
68: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
69: end if;
70:
71: if (NOT FND_API.Compatible_API_Call(
72: G_API_VERSION,

Line 82: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

78:
79:
80: l_err_stage:= 'Init_Server_Message';
81: if (g_log_level_rec.statement_level) then
82: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
83: end if;
84:
85:
86: if (FND_API.To_Boolean(p_init_msg_list)) then

Line 91: FA_DEBUG_PKG.Initialize;

87: -- Initialize error message stack.
88: FA_SRVR_MSG.Init_Server_Message;
89:
90: -- Initialize debug message stack.
91: FA_DEBUG_PKG.Initialize;
92: end if;
93:
94:
95: l_err_stage:= 'validate mandatory input params';

Line 97: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

93:
94:
95: l_err_stage:= 'validate mandatory input params';
96: if (g_log_level_rec.statement_level) then
97: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
98: end if;
99:
100: if (px_asset_hdr_rec.asset_id is NULL) then
101: fa_srvr_msg.add_message(

Line 125: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

121:
122:
123: l_err_stage:= 'fa_cache_pkg.fazcbc';
124: if (g_log_level_rec.statement_level) then
125: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
126: end if;
127:
128: if (NOT fa_cache_pkg.fazcbc (
129: X_book => px_asset_hdr_rec.book_type_code

Line 137: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

133:
134:
135: l_err_stage:= 'FA_UTIL_PVT.get_asset_desc_rec';
136: if (g_log_level_rec.statement_level) then
137: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
138: end if;
139:
140: if not FA_UTIL_PVT.get_asset_desc_rec(
141: p_asset_hdr_rec => px_asset_hdr_rec,

Line 159: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

155:
156: -- Asset Number
157: l_err_stage:= 'Asset NUmber';
158: if (g_log_level_rec.statement_level) then
159: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
160: end if;
161:
162:
163: if (px_asset_desc_rec_new.asset_number is NOT NULL) then

Line 195: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

191:
192: -- Asset Description
193: l_err_stage:= 'Asset Description';
194: if (g_log_level_rec.statement_level) then
195: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
196: end if;
197:
198:
199: if (px_asset_desc_rec_new.description is NOT NULL) then

Line 220: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

216:
217: -- Tag Number
218: l_err_stage:= 'Tag Number';
219: if (g_log_level_rec.statement_level) then
220: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
221: end if;
222:
223: if (px_asset_desc_rec_new.tag_number is NOT NULL) then
224: if (nvl(l_asset_desc_rec.tag_number, '-999') <>

Line 246: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

242: end if;
243:
244: l_err_stage:= 'Get_asset_cat';
245: if (g_log_level_rec.statement_level) then
246: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
247: end if;
248:
249:
250: if not FA_UTIL_PVT.get_asset_cat_rec(

Line 277: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

273:
274: -- Serial Number
275: l_err_stage:= 'Serial Number';
276: if (g_log_level_rec.statement_level) then
277: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
278: end if;
279:
280:
281: if (px_asset_desc_rec_new.serial_number is NOT NULL) then

Line 326: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

322:
323: -- Asset Key
324: l_err_stage:= 'Asset Key';
325: if (g_log_level_rec.statement_level) then
326: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
327: end if;
328:
329:
330: if (px_asset_desc_rec_new.asset_key_ccid is NOT NULL) then

Line 384: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

380:
381: -- Parent asset
382: l_err_stage:= 'Parent Asset';
383: if (g_log_level_rec.statement_level) then
384: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
385: end if;
386:
387:
388: if (px_asset_desc_rec_new.parent_asset_id is NOT NULL) then

Line 411: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

407:
408: -- Manufacturer
409: l_err_stage:= 'Manufacturer';
410: if (g_log_level_rec.statement_level) then
411: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
412: end if;
413:
414:
415: if (px_asset_desc_rec_new.manufacturer_name is NOT NULL) then

Line 450: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

446:
447: -- Model Number
448: l_err_stage:= 'Model Number';
449: if (g_log_level_rec.statement_level) then
450: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
451: end if;
452:
453:
454: if (px_asset_desc_rec_new.model_number is NOT NULL) then

Line 470: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

466:
467: -- Warranty Number
468: l_err_stage:= 'Warranty Number';
469: if (g_log_level_rec.statement_level) then
470: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
471: end if;
472:
473:
474: if (px_asset_desc_rec_new.warranty_id is NOT NULL) then

Line 507: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

503:
504: -- Lease
505: l_err_stage:= 'Lease';
506: if (g_log_level_rec.statement_level) then
507: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
508: end if;
509:
510: if (px_asset_desc_rec_new.lease_id is NOT NULL) then
511: if (nvl(l_asset_desc_rec.lease_id, -999) <>

Line 839: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

835:
836: -- in_use_flag
837: l_err_stage:= 'in_use_flag';
838: if (g_log_level_rec.statement_level) then
839: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
840: end if;
841:
842:
843: if (px_asset_desc_rec_new.in_use_flag is NOT NULL) then

Line 860: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

856:
857: -- inventorial
858: l_err_stage:= 'inventorial';
859: if (g_log_level_rec.statement_level) then
860: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
861: end if;
862:
863:
864: if (px_asset_desc_rec_new.inventorial is NOT NULL) then

Line 880: fa_debug_pkg.add('Update_desc', 'before', l_err_stage

876:
877: -- commitment
878: l_err_stage:= 'commitment';
879: if (g_log_level_rec.statement_level) then
880: fa_debug_pkg.add('Update_desc', 'before', l_err_stage
881: ,p_log_level_rec => g_log_level_rec);
882: end if;
883:
884:

Line 894: fa_debug_pkg.add('Update_desc', 'before', l_err_stage

890:
891: -- investment_law
892: l_err_stage:= 'investment_law';
893: if (g_log_level_rec.statement_level) then
894: fa_debug_pkg.add('Update_desc', 'before', l_err_stage
895: ,p_log_level_rec => g_log_level_rec);
896: end if;
897:
898:

Line 908: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

904:
905: -- property_type_code
906: l_err_stage:= 'property_type_code';
907: if (g_log_level_rec.statement_level) then
908: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
909: end if;
910:
911:
912: if (px_asset_desc_rec_new.property_type_code is NOT NULL) then

Line 939: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

935:
936: -- property_1245_1250_code
937: l_err_stage:= 'property_1245_1250_code';
938: if (g_log_level_rec.statement_level) then
939: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
940: end if;
941:
942:
943: if (px_asset_desc_rec_new.property_1245_1250_code is NOT NULL) then

Line 972: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

968:
969: -- owned_leased
970: l_err_stage:= 'owned_leased';
971: if (g_log_level_rec.statement_level) then
972: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
973: end if;
974:
975:
976: if (px_asset_desc_rec_new.owned_leased is NOT NULL) then

Line 991: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

987:
988: -- new_used
989: l_err_stage:= 'new_used';
990: if (g_log_level_rec.statement_level) then
991: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
992: end if;
993:
994:
995: if (px_asset_desc_rec_new.new_used is NOT NULL) then

Line 1010: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

1006:
1007: -- add_cost_je_flag
1008: l_err_stage:= 'add_cost_je_flag';
1009: if (g_log_level_rec.statement_level) then
1010: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
1011: end if;
1012:
1013:
1014: if (px_asset_desc_rec_new.add_cost_je_flag is NOT NULL) then

Line 1031: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

1027:
1028: -- status
1029: l_err_stage:= 'status';
1030: if (g_log_level_rec.statement_level) then
1031: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
1032: end if;
1033:
1034:
1035: if (px_asset_desc_rec_new.status is NOT NULL) then

Line 1052: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

1048:
1049: -- Update Global Attributes
1050: l_err_stage:= 'Global_desc_flex';
1051: if (g_log_level_rec.statement_level) then
1052: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
1053: end if;
1054:
1055: l_asset_desc_rec.global_desc_flex := px_asset_desc_rec_new.global_desc_flex;
1056:

Line 1060: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);

1056:
1057:
1058: l_err_stage:= 'Update Row';
1059: if (g_log_level_rec.statement_level) then
1060: fa_debug_pkg.add('Update_desc', 'before', l_err_stage, p_log_level_rec => g_log_level_rec);
1061: end if;
1062:
1063: if (NOT update_row(
1064: p_trans_rec => px_trans_rec,

Line 1422: fa_debug_pkg.initialize;

1418: -- initialize error message stack.
1419: fa_srvr_msg.init_server_message;
1420:
1421: -- initialize debug message stack.
1422: fa_debug_pkg.initialize;
1423: end if;
1424:
1425: -- Check version of the API
1426: -- Standard call to check for API call compatibility.

Line 2031: fa_debug_pkg.initialize;

2027: -- initialize error message stack.
2028: fa_srvr_msg.init_server_message;
2029:
2030: -- initialize debug message stack.
2031: fa_debug_pkg.initialize;
2032: end if;
2033:
2034: -- Check version of the API
2035: -- Standard call to check for API call compatibility.

Line 2138: fa_debug_pkg.add('Set Of Books Id',

2134: */
2135: l_asset_retire_rec := px_asset_retire_rec_new;
2136:
2137: if (g_log_level_rec.statement_level) then
2138: fa_debug_pkg.add('Set Of Books Id',
2139: 'l_mrc_asset_hdr_rec.set_of_books_id',
2140: to_char(l_mrc_asset_hdr_rec.set_of_books_id));
2141: fa_debug_pkg.add('Reporting Flag','l_reporting_flag',
2142: l_reporting_flag, p_log_level_rec => g_log_level_rec);

Line 2141: fa_debug_pkg.add('Reporting Flag','l_reporting_flag',

2137: if (g_log_level_rec.statement_level) then
2138: fa_debug_pkg.add('Set Of Books Id',
2139: 'l_mrc_asset_hdr_rec.set_of_books_id',
2140: to_char(l_mrc_asset_hdr_rec.set_of_books_id));
2141: fa_debug_pkg.add('Reporting Flag','l_reporting_flag',
2142: l_reporting_flag, p_log_level_rec => g_log_level_rec);
2143: fa_debug_pkg.add('Retirement ID','l_asset_retire_rec.retirement_id',
2144: to_char(l_asset_retire_rec.retirement_id), g_log_level_rec);
2145: end if;

Line 2143: fa_debug_pkg.add('Retirement ID','l_asset_retire_rec.retirement_id',

2139: 'l_mrc_asset_hdr_rec.set_of_books_id',
2140: to_char(l_mrc_asset_hdr_rec.set_of_books_id));
2141: fa_debug_pkg.add('Reporting Flag','l_reporting_flag',
2142: l_reporting_flag, p_log_level_rec => g_log_level_rec);
2143: fa_debug_pkg.add('Retirement ID','l_asset_retire_rec.retirement_id',
2144: to_char(l_asset_retire_rec.retirement_id), g_log_level_rec);
2145: end if;
2146:
2147: if (NOT FA_UTIL_PVT.get_asset_retire_rec (