DBA Data[Home] [Help]

APPS.CSE_ASSET_WIP_PKG dependencies on FND_API

Line 95: p_commit => fnd_api.g_false,

91: l_relationship_query_rec.relationship_type_code := 'COMPONENT-OF' ;
92:
93: csi_ii_relationships_pub.get_relationships(
94: p_api_version => 1.0,
95: p_commit => fnd_api.g_false,
96: p_init_msg_list => fnd_api.g_true,
97: p_validation_level => fnd_api.g_valid_level_full,
98: p_relationship_query_rec => l_relationship_query_rec,
99: p_depth => 1,

Line 96: p_init_msg_list => fnd_api.g_true,

92:
93: csi_ii_relationships_pub.get_relationships(
94: p_api_version => 1.0,
95: p_commit => fnd_api.g_false,
96: p_init_msg_list => fnd_api.g_true,
97: p_validation_level => fnd_api.g_valid_level_full,
98: p_relationship_query_rec => l_relationship_query_rec,
99: p_depth => 1,
100: p_time_stamp => null ,

Line 97: p_validation_level => fnd_api.g_valid_level_full,

93: csi_ii_relationships_pub.get_relationships(
94: p_api_version => 1.0,
95: p_commit => fnd_api.g_false,
96: p_init_msg_list => fnd_api.g_true,
97: p_validation_level => fnd_api.g_valid_level_full,
98: p_relationship_query_rec => l_relationship_query_rec,
99: p_depth => 1,
100: p_time_stamp => null ,
101: p_active_relationship_only => fnd_api.g_true,

Line 101: p_active_relationship_only => fnd_api.g_true,

97: p_validation_level => fnd_api.g_valid_level_full,
98: p_relationship_query_rec => l_relationship_query_rec,
99: p_depth => 1,
100: p_time_stamp => null ,
101: p_active_relationship_only => fnd_api.g_true,
102: x_relationship_tbl => l_relationship_tbl,
103: x_return_status => l_return_status,
104: x_msg_count => l_msg_count,
105: x_msg_data => l_msg_data );

Line 108: IF l_return_status <> FND_API.G_Ret_Sts_Success

104: x_msg_count => l_msg_count,
105: x_msg_data => l_msg_data );
106:
107: cse_util_pkg.write_log('l_return_status After calling get_relationships :'||l_return_status);
108: IF l_return_status <> FND_API.G_Ret_Sts_Success
109: THEN
110: l_msg_index := 1;
111: l_error_message := l_msg_data;
112: WHILE l_msg_count > 0

Line 114: l_error_message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE)||l_error_message;

110: l_msg_index := 1;
111: l_error_message := l_msg_data;
112: WHILE l_msg_count > 0
113: LOOP
114: l_error_message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE)||l_error_message;
115: l_msg_index := l_msg_index + 1;
116: l_Msg_Count := l_Msg_Count - 1;
117: END LOOP;
118: END IF;

Line 194: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

190: ,p_reviewer_comments => get_item_instance_rec.instance_id
191: ,x_error_msg => l_error_message
192: ,x_return_status => l_return_status );
193:
194: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
195: THEN
196: RAISE e_error_exception ;
197: END IF ;
198: ELSE

Line 249: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

245: AND fab.date_ineffective IS NULL ;
246:
247: e_error EXCEPTION ;
248: BEGIN
249: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
250: cse_util_pkg.write_log ('Asset ID : '||p_asset_id);
251: cse_util_pkg.write_log ('Book Type: '||p_book_type_code);
252: cse_util_pkg.write_log ('FA Location : '||p_location_id);
253: cse_util_pkg.write_log ('Expense CCID :'|| p_expense_ccid);

Line 295: ,p_commit => FND_API.G_FALSE

291: l_mass_add_rec.last_update_login := fnd_global.login_id ;
292:
293: cse_asset_util_pkg.insert_mass_add(
294: p_api_version => 1.0
295: ,p_commit => FND_API.G_FALSE
296: ,p_init_msg_list => FND_API.G_TRUE
297: ,p_mass_add_rec => l_mass_add_rec
298: ,x_return_status => l_return_status
299: ,x_msg_count => l_msg_count

Line 296: ,p_init_msg_list => FND_API.G_TRUE

292:
293: cse_asset_util_pkg.insert_mass_add(
294: p_api_version => 1.0
295: ,p_commit => FND_API.G_FALSE
296: ,p_init_msg_list => FND_API.G_TRUE
297: ,p_mass_add_rec => l_mass_add_rec
298: ,x_return_status => l_return_status
299: ,x_msg_count => l_msg_count
300: ,x_msg_data => l_msg_data );

Line 302: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS

298: ,x_return_status => l_return_status
299: ,x_msg_count => l_msg_count
300: ,x_msg_data => l_msg_data );
301:
302: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS
303: THEN
304: l_error_msg := l_msg_data ;
305: RAISE e_error ;
306: END IF ;

Line 322: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS

318: x_new_dist_id => l_new_dist_id,
319: x_return_status => l_return_status,
320: x_error_msg => l_error_msg);
321:
322: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS
323: THEN
324: RAISE e_error ;
325: END IF ;
326: END IF ;

Line 330: x_return_status := fnd_api.G_RET_STS_ERROR ;

326: END IF ;
327:
328: EXCEPTION
329: WHEN e_error THEN
330: x_return_status := fnd_api.G_RET_STS_ERROR ;
331: x_error_msg := l_error_msg ;
332: cse_util_pkg.write_log('Error in adjust_fa_cost_n_unit :'|| x_error_msg);
333: WHEN OTHERS THEN
334: x_return_status := fnd_api.G_RET_STS_ERROR ;

Line 334: x_return_status := fnd_api.G_RET_STS_ERROR ;

330: x_return_status := fnd_api.G_RET_STS_ERROR ;
331: x_error_msg := l_error_msg ;
332: cse_util_pkg.write_log('Error in adjust_fa_cost_n_unit :'|| x_error_msg);
333: WHEN OTHERS THEN
334: x_return_status := fnd_api.G_RET_STS_ERROR ;
335: x_error_msg := SQLERRM ;
336: cse_util_pkg.write_log('Error in adjust_fa_cost_n_unit :'|| x_error_msg);
337: END adjust_fa_cost_n_unit ;
338: