DBA Data[Home] [Help]

APPS.CSI_ML_PROGRAM_PUB dependencies on FND_API

Line 77: p_called_from_grp => fnd_api.g_true,

73:
74: l_inst_interface_id := l_syncup_instance_rec.inst_interface_id;
75: csi_asset_pvt.get_syncup_tree
76: ( p_source_system_name => p_source_system_name,
77: p_called_from_grp => fnd_api.g_true,
78: px_instance_sync_tbl => l_instance_sync_tbl,
79: px_instance_asset_sync_tbl => l_instance_asset_sync_tbl,
80: x_fa_asset_sync_tbl => l_fa_asset_sync_tbl,
81: x_return_status => l_return_status,

Line 84: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

80: x_fa_asset_sync_tbl => l_fa_asset_sync_tbl,
81: x_return_status => l_return_status,
82: x_error_msg => l_error_message
83: );
84: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
85: IF(l_debug_level>1) THEN
86: FND_File.Put_Line(Fnd_File.LOG,'Error : '||l_error_message);
87: end if;
88: RAISE fnd_api.g_exc_error;

Line 88: RAISE fnd_api.g_exc_error;

84: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
85: IF(l_debug_level>1) THEN
86: FND_File.Put_Line(Fnd_File.LOG,'Error : '||l_error_message);
87: end if;
88: RAISE fnd_api.g_exc_error;
89: END IF;
90:
91: csi_asset_pvt.asset_syncup_validation
92: ( px_instance_sync_tbl => l_instance_sync_tbl,

Line 98: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

94: px_fa_asset_sync_tbl => l_fa_asset_sync_tbl,
95: x_return_status => l_return_status,
96: x_error_msg => l_error_message
97: );
98: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
99: IF(l_debug_level>1) THEN
100: FND_File.Put_Line(Fnd_File.LOG,'Error : '||l_error_message);
101: END IF;
102: RAISE fnd_api.g_exc_error;

Line 102: RAISE fnd_api.g_exc_error;

98: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
99: IF(l_debug_level>1) THEN
100: FND_File.Put_Line(Fnd_File.LOG,'Error : '||l_error_message);
101: END IF;
102: RAISE fnd_api.g_exc_error;
103: END IF;
104:
105: l_ctr := 0;
106:

Line 148: WHEN fnd_api.g_exc_error THEN

144: l_fa_asset_sync_tbl.delete;
145: END LOOP;
146: END IF;
147: EXCEPTION
148: WHEN fnd_api.g_exc_error THEN
149: x_return_status := l_return_status ;
150: x_error_message := l_error_message ;
151: END asset_vld_preprocessor;
152:

Line 171: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

167: l_msg_count NUMBER;
168: l_msg_data VARCHAR2(2000);
169: l_msg_index NUMBER;
170: l_sql_error VARCHAR2(2000);
171: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
172: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
173: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
174: l_api_name VARCHAR2(255) := 'CSI_ML_CREATE_PUB.EXECUTE_OPENINTERFACE';
175:

Line 172: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

168: l_msg_data VARCHAR2(2000);
169: l_msg_index NUMBER;
170: l_sql_error VARCHAR2(2000);
171: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
172: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
173: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
174: l_api_name VARCHAR2(255) := 'CSI_ML_CREATE_PUB.EXECUTE_OPENINTERFACE';
175:
176: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));

Line 173: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

169: l_msg_index NUMBER;
170: l_sql_error VARCHAR2(2000);
171: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
172: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
173: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
174: l_api_name VARCHAR2(255) := 'CSI_ML_CREATE_PUB.EXECUTE_OPENINTERFACE';
175:
176: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));
177:

Line 255: RAISE fnd_api.g_exc_error;

251: ,x_error_message => l_error_message
252: ,x_return_status => l_return_status
253: );
254: IF NOT l_return_status = l_fnd_success THEN
255: RAISE fnd_api.g_exc_error;
256: END IF;
257:
258: -- Step 1: Run the create process to create all instances in the
259: -- Interface Tables.

Line 273: RAISE fnd_api.g_exc_error;

269: p_batch_name,
270: p_resolve_ids );
271:
272: IF NOT l_return_status = l_fnd_success THEN
273: RAISE fnd_api.g_exc_error;
274: END IF;
275:
276: EXCEPTION
277: WHEN fnd_api.g_exc_error THEN

Line 277: WHEN fnd_api.g_exc_error THEN

273: RAISE fnd_api.g_exc_error;
274: END IF;
275:
276: EXCEPTION
277: WHEN fnd_api.g_exc_error THEN
278: IF(l_debug_level>1) THEN
279: FND_File.Put_Line(Fnd_File.LOG,l_error_message);
280: END IF;
281:

Line 415: l_fnd_success := FND_API.G_RET_STS_SUCCESS;

411: l_old_error:=0;
412: END;
413:
414:
415: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
416: l_fnd_error := FND_API.G_RET_STS_ERROR;
417: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
418:
419:

Line 416: l_fnd_error := FND_API.G_RET_STS_ERROR;

412: END;
413:
414:
415: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
416: l_fnd_error := FND_API.G_RET_STS_ERROR;
417: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
418:
419:
420: IF NVL(p_purge_processed_recs,'Y') = 'Y'

Line 417: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;

413:
414:
415: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
416: l_fnd_error := FND_API.G_RET_STS_ERROR;
417: l_fnd_unexpected := FND_API.G_RET_STS_UNEXP_ERROR;
418:
419:
420: IF NVL(p_purge_processed_recs,'Y') = 'Y'
421: THEN

Line 472: RAISE fnd_api.g_exc_error;

468: ,x_error_message => l_error_message
469: ,x_return_status => l_return_status
470: );
471: IF NOT l_return_status = l_fnd_success THEN
472: RAISE fnd_api.g_exc_error;
473: END IF;
474: IF(l_debug_level>1) THEN
475: FND_File.Put_Line(Fnd_File.LOG,'Begin Execute paralle create: '||p_worker_count);
476: END IF;