DBA Data[Home] [Help]

APPS.FA_RECLASS_PUB dependencies on FND_API

Line 28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

24:
25: PROCEDURE do_reclass (
26: -- std parameters
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_calling_fn IN VARCHAR2,
32: x_return_status OUT NOCOPY VARCHAR2,

Line 29: p_commit IN VARCHAR2 := FND_API.G_FALSE,

25: PROCEDURE do_reclass (
26: -- std parameters
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_calling_fn IN VARCHAR2,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,

Line 30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

26: -- std parameters
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_calling_fn IN VARCHAR2,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2,

Line 93: raise FND_API.G_EXC_UNEXPECTED_ERROR;

89: if (not g_log_level_rec.initialized) then
90: if (NOT fa_util_pub.get_log_level_rec (
91: x_log_level_rec => g_log_level_rec
92: )) then
93: raise FND_API.G_EXC_UNEXPECTED_ERROR;
94: end if;
95: end if;
96:
97: l_err_stage:= 'Standard call to check for call compatibility.';

Line 99: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

95: end if;
96:
97: l_err_stage:= 'Standard call to check for call compatibility.';
98: -- dbms_output.put_line(l_err_stage);
99: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
100: l_api_name, G_PKG_NAME) then
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103:

Line 101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

97: l_err_stage:= 'Standard call to check for call compatibility.';
98: -- dbms_output.put_line(l_err_stage);
99: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
100: l_api_name, G_PKG_NAME) then
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103:
104: l_err_stage:= 'Initialize message list if p_init_msg_list is set to TRUE.';
105: -- dbms_output.put_line(l_err_stage);

Line 106: IF FND_API.To_Boolean(p_init_msg_list) THEN

102: END IF;
103:
104: l_err_stage:= 'Initialize message list if p_init_msg_list is set to TRUE.';
105: -- dbms_output.put_line(l_err_stage);
106: IF FND_API.To_Boolean(p_init_msg_list) THEN
107: -- Initialize error message stack.
108: FA_SRVR_MSG.Init_Server_Message;
109: -- Initialize debug message stack.
110: FA_DEBUG_PKG.Initialize;

Line 114: -- IF FND_API.To_Boolean(p_debug_flag) THEN

110: FA_DEBUG_PKG.Initialize;
111: END IF;
112:
113: -- bugfix 2158910 Override FA: PRINT_DEBUG profile option.
114: -- IF FND_API.To_Boolean(p_debug_flag) THEN
115: -- FA_DEBUG_PKG.Set_Debug_Flag;
116: -- ELSE
117: -- FA_DEBUG_PKG.Set_Debug_Flag('NO', p_log_level_rec => g_log_level_rec);
118: -- END IF;

Line 127: raise FND_API.G_EXC_ERROR;

123: px_asset_cat_rec_new.category_id is null ) then
124: fa_srvr_msg.add_message(
125: calling_fn => l_calling_fn,
126: name => 'FA_SHARED_ITEM_NULL' , p_log_level_rec => g_log_level_rec);
127: raise FND_API.G_EXC_ERROR;
128: end if;
129:
130:
131: l_err_stage:= 'check that asset is valid';

Line 142: raise FND_API.G_EXC_ERROR;

138: if l_num_dummy = 0 then
139: fa_srvr_msg.add_message(
140: calling_fn => l_calling_fn,
141: name => 'FA_INVALID_ASSET' , p_log_level_rec => g_log_level_rec);
142: raise FND_API.G_EXC_ERROR;
143: end if;
144:
145: l_err_stage:= 'determine the corporate book';
146: -- dbms_output.put_line(l_err_stage);

Line 153: raise FND_API.G_EXC_ERROR;

149: if l_corp_book is null then
150: close c_corp_book;
151: FA_SRVR_MSG.Add_Message(
152: calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
153: raise FND_API.G_EXC_ERROR;
154: end if;
155: close c_corp_book;
156:
157: px_asset_hdr_rec.book_type_code := l_corp_book;

Line 161: raise FND_API.G_EXC_ERROR;

157: px_asset_hdr_rec.book_type_code := l_corp_book;
158:
159: -- load the book controls cache
160: if not fa_cache_pkg.fazcbc(X_book => px_asset_hdr_rec.book_type_code, p_log_level_rec => g_log_level_rec) then
161: raise FND_API.G_EXC_ERROR;
162: end if;
163:
164: --Verify if impairment has happened in same period
165: if not FA_ASSET_VAL_PVT.validate_impairment_exists

Line 171: raise FND_API.G_EXC_ERROR;

167: p_book => px_asset_hdr_rec.book_type_code,
168: p_mrc_sob_type_code => 'P',
169: p_set_of_books_id => px_asset_hdr_rec.set_of_books_id,
170: p_log_level_rec => g_log_level_rec) then
171: raise FND_API.G_EXC_ERROR;
172: end if;
173:
174: if (g_log_level_rec.statement_level) then
175: fa_debug_pkg.add(l_calling_fn, 'Book', px_asset_hdr_rec.book_type_code, p_log_level_rec => g_log_level_rec);

Line 194: raise FND_API.G_EXC_ERROR;

190: X_trx_date =>px_trans_rec.transaction_date_entered,
191: X_init_message_flag=>'NO', p_log_level_rec => g_log_level_rec) then
192: FA_SRVR_MSG.Add_Message(
193: Calling_FN => l_calling_fn, p_log_level_rec => g_log_level_rec);
194: raise FND_API.G_EXC_ERROR;
195: end if;
196: end if;
197:
198: -- BUG# 3549470

Line 204: raise FND_API.G_EXC_ERROR;

200:
201: if not FA_UTIL_PVT.get_period_rec
202: (p_book => px_asset_hdr_rec.book_type_code,
203: x_period_rec => l_period_rec, p_log_level_rec => g_log_level_rec) then
204: raise FND_API.G_EXC_ERROR;
205: end if;
206:
207: px_trans_rec.transaction_date_entered :=
208: greatest(l_period_rec.calendar_period_open_date,

Line 233: raise FND_API.G_EXC_ERROR;

229: px_asset_desc_rec => l_asset_desc_rec , p_log_level_rec => g_log_level_rec) then
230: fa_srvr_msg.add_message(
231: calling_fn => l_calling_fn,
232: name => 'FA_PROJ_GET_ASSET_INFO' , p_log_level_rec => g_log_level_rec);
233: raise FND_API.G_EXC_ERROR;
234: end if;
235:
236: l_err_stage:= 'fa_utils_pvt.get_asset_type_rec';
237: -- dbms_output.put_line(l_err_stage);

Line 244: raise FND_API.G_EXC_ERROR;

240: px_asset_type_rec => l_asset_type_rec,
241: p_date_effective => null , p_log_level_rec => g_log_level_rec) then
242: fa_srvr_msg.add_message(
243: calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
244: raise FND_API.G_EXC_ERROR;
245: end if;
246:
247: -- get current category details
248: l_err_stage:= 'fa_utils_pvt.get_asset_cat_rec';

Line 256: raise FND_API.G_EXC_ERROR;

252: px_asset_cat_rec => l_asset_cat_rec_old,
253: p_date_effective => null , p_log_level_rec => g_log_level_rec) then
254: fa_srvr_msg.add_message(
255: calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
256: raise FND_API.G_EXC_ERROR;
257: end if;
258:
259: l_err_stage:= 'check if old and new categories are same';
260: -- dbms_output.put_line(l_err_stage);

Line 285: raise FND_API.G_EXC_ERROR;

281: x_override_flag => l_override_flag,
282: p_log_level_rec => g_log_level_rec)) then
283: fa_srvr_msg.add_message(
284: calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
285: raise FND_API.G_EXC_ERROR;
286: end if;
287: if l_override_flag = 'N' then
288: fa_srvr_msg.add_message(
289: calling_fn => l_calling_fn,

Line 292: raise FND_API.G_EXC_ERROR;

288: fa_srvr_msg.add_message(
289: calling_fn => l_calling_fn,
290: name => 'FA_OVERRIDE_NOT_ALLOWED',
291: token1 => 'CATEGORY', p_log_level_rec => g_log_level_rec);
292: raise FND_API.G_EXC_ERROR;
293: end if;
294:
295: l_err_stage:= 'c_asset_parent';
296: -- dbms_output.put_line(l_err_stage);

Line 335: raise FND_API.G_EXC_ERROR;

331: if not FA_ASSET_HIERARCHY_PVT.create_batch(
332: p_asset_hdr_rec => px_asset_hdr_rec,
333: p_trans_rec => px_trans_rec,
334: p_asset_hr_opt_rec => l_asset_hr_opt_rec , p_log_level_rec => g_log_level_rec) then
335: raise FND_API.G_EXC_ERROR;
336: end if;
337: end if; -- parent_hierarchy not null
338: end if; -- if l_crl_enabled
339:

Line 362: raise FND_API.G_EXC_ERROR;

358: l_asset_cat_rec_old,
359: px_asset_cat_rec_new,
360: p_recl_opt_rec , p_log_level_rec => g_log_level_rec) then
361:
362: raise FND_API.G_EXC_ERROR;
363: end if;
364: end if; -- if not crl_enabled
365:
366: if FND_API.To_Boolean(p_commit) THEN

Line 366: if FND_API.To_Boolean(p_commit) THEN

362: raise FND_API.G_EXC_ERROR;
363: end if;
364: end if; -- if not crl_enabled
365:
366: if FND_API.To_Boolean(p_commit) THEN
367: commit;
368: end if;
369:
370: FND_MSG_PUB.Count_And_Get(

Line 374: x_return_status := FND_API.G_RET_STS_SUCCESS;

370: FND_MSG_PUB.Count_And_Get(
371: p_count => x_msg_count,
372: p_data => x_msg_data );
373:
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375:
376: EXCEPTION
377: when FND_API.G_EXC_ERROR then
378: rollback to Reclass_Asset_Begin;

Line 377: when FND_API.G_EXC_ERROR then

373:
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375:
376: EXCEPTION
377: when FND_API.G_EXC_ERROR then
378: rollback to Reclass_Asset_Begin;
379: FA_SRVR_MSG.Add_Message(
380: calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
381: FND_MSG_PUB.Count_And_Get(

Line 384: x_return_status := FND_API.G_RET_STS_ERROR;

380: calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
381: FND_MSG_PUB.Count_And_Get(
382: p_count => x_msg_count,
383: p_data => x_msg_data );
384: x_return_status := FND_API.G_RET_STS_ERROR;
385:
386: when others then
387: rollback to Reclass_Asset_Begin;
388: fa_srvr_msg.add_sql_error(

Line 393: raise FND_API.G_EXC_UNEXPECTED_ERROR;

389: calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
390: FND_MSG_PUB.Count_And_Get(
391: p_count => x_msg_count,
392: p_data => x_msg_data );
393: raise FND_API.G_EXC_UNEXPECTED_ERROR;
394: END do_reclass;
395:
396:
397: END FA_RECLASS_PUB;