eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_IMPORT_PVT dependencies on FND_API

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

64: -- End of comments
65:
66: PROCEDURE Import_Data
67: ( p_api_version IN NUMBER ,
68: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
69: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
70: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
71: x_return_status OUT NOCOPY VARCHAR2 ,
72: x_msg_count OUT NOCOPY NUMBER ,

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

65:
66: PROCEDURE Import_Data
67: ( p_api_version IN NUMBER ,
68: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
69: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
70: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
71: x_return_status OUT NOCOPY VARCHAR2 ,
72: x_msg_count OUT NOCOPY NUMBER ,
73: x_msg_data OUT NOCOPY VARCHAR2 ,

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

66: PROCEDURE Import_Data
67: ( p_api_version IN NUMBER ,
68: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
69: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
70: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
71: x_return_status OUT NOCOPY VARCHAR2 ,
72: x_msg_count OUT NOCOPY NUMBER ,
73: x_msg_data OUT NOCOPY VARCHAR2 ,
74: p_imp_header_id IN NUMBER,

Line 94: IF NOT FND_API.compatible_api_call

90: BEGIN
91: -- Standard Start of API savepoint
92: SAVEPOINT Import_Data;
93: -- Standard call to check for call compatibility.
94: IF NOT FND_API.compatible_api_call
95: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
96: THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;

Line 97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

93: -- Standard call to check for call compatibility.
94: IF NOT FND_API.compatible_api_call
95: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
96: THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99: -- Initialize message list if p_init_msg_list is set to TRUE.
100: IF FND_API.to_Boolean( p_init_msg_list ) THEN
101: FND_MSG_PUB.initialize;

Line 100: IF FND_API.to_Boolean( p_init_msg_list ) THEN

96: THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99: -- Initialize message list if p_init_msg_list is set to TRUE.
100: IF FND_API.to_Boolean( p_init_msg_list ) THEN
101: FND_MSG_PUB.initialize;
102: END IF;
103: -- Initialize API return status to success
104: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 104: x_return_status := FND_API.G_RET_STS_SUCCESS;

100: IF FND_API.to_Boolean( p_init_msg_list ) THEN
101: FND_MSG_PUB.initialize;
102: END IF;
103: -- Initialize API return status to success
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105: -- API body
106: l_imp_type_code := get_imp_type_code(p_imp_header_id);
107: SELECT name, status_code,server_flag
108: INTO l_imp_header.name ,l_imp_header.status_code ,

Line 166: RAISE FND_API.g_exc_unexpected_error;

162: p_status_code => 'FAIL');
163: cn_message_pkg.write
164: (p_message_text => 'CNIMPDS submission fail.',
165: p_message_type => 'ERROR');
166: RAISE FND_API.g_exc_unexpected_error;
167: END IF;
168:
169: cn_message_pkg.write
170: (p_message_text => 'Staging Concurrent Program CNIMPDS Started.REQ = '|| l_request_id,

Line 201: RAISE FND_API.g_exc_unexpected_error;

197: p_status_code => 'FAIL');
198: cn_message_pkg.write
199: (p_message_text => 'CNIMPST submission fail.',
200: p_message_type => 'ERROR');
201: RAISE FND_API.g_exc_unexpected_error;
202: END IF;
203:
204: cn_message_pkg.write
205: (p_message_text => 'Loading Concurrent Program CNIMPST Started.REQ = '|| l_request_id,

Line 219: IF FND_API.To_Boolean( p_commit ) THEN

215:
216: -- End of API body.
217:
218: -- Standard check of p_commit.
219: IF FND_API.To_Boolean( p_commit ) THEN
220: COMMIT WORK;
221: END IF;
222: -- Standard call to get message count and if count is 1, get message info.
223: FND_MSG_PUB.count_and_get

Line 226: p_encoded => FND_API.G_FALSE

222: -- Standard call to get message count and if count is 1, get message info.
223: FND_MSG_PUB.count_and_get
224: (p_count => x_msg_count ,
225: p_data => x_msg_data ,
226: p_encoded => FND_API.G_FALSE
227: );
228:
229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN

Line 230: WHEN FND_API.G_EXC_ERROR THEN

226: p_encoded => FND_API.G_FALSE
227: );
228:
229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN
231: ROLLBACK TO Import_Data ;
232: x_return_status := FND_API.G_RET_STS_ERROR ;
233: cn_message_pkg.end_batch(l_process_audit_id);
234: FND_MSG_PUB.Count_And_Get(

Line 232: x_return_status := FND_API.G_RET_STS_ERROR ;

228:
229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN
231: ROLLBACK TO Import_Data ;
232: x_return_status := FND_API.G_RET_STS_ERROR ;
233: cn_message_pkg.end_batch(l_process_audit_id);
234: FND_MSG_PUB.Count_And_Get(
235: p_count => x_msg_count ,
236: p_data => x_msg_data ,

Line 237: p_encoded => FND_API.G_FALSE

233: cn_message_pkg.end_batch(l_process_audit_id);
234: FND_MSG_PUB.Count_And_Get(
235: p_count => x_msg_count ,
236: p_data => x_msg_data ,
237: p_encoded => FND_API.G_FALSE
238: );
239:
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: ROLLBACK TO Import_Data ;

Line 240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

236: p_data => x_msg_data ,
237: p_encoded => FND_API.G_FALSE
238: );
239:
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: ROLLBACK TO Import_Data ;
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
243: cn_message_pkg.end_batch(l_process_audit_id);
244: FND_MSG_PUB.Count_And_Get(

Line 242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

238: );
239:
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: ROLLBACK TO Import_Data ;
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
243: cn_message_pkg.end_batch(l_process_audit_id);
244: FND_MSG_PUB.Count_And_Get(
245: p_count => x_msg_count ,
246: p_data => x_msg_data ,

Line 247: p_encoded => FND_API.G_FALSE

243: cn_message_pkg.end_batch(l_process_audit_id);
244: FND_MSG_PUB.Count_And_Get(
245: p_count => x_msg_count ,
246: p_data => x_msg_data ,
247: p_encoded => FND_API.G_FALSE
248: );
249:
250: WHEN OTHERS THEN
251: ROLLBACK TO Import_Data ;

Line 252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

248: );
249:
250: WHEN OTHERS THEN
251: ROLLBACK TO Import_Data ;
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
253: cn_message_pkg.set_error(l_api_name,'Unexpected error');
254: cn_message_pkg.end_batch(l_process_audit_id);
255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN

Line 263: p_encoded => FND_API.G_FALSE

259: FND_MSG_PUB.Count_And_Get
260: (
261: p_count => x_msg_count ,
262: p_data => x_msg_data ,
263: p_encoded => FND_API.G_FALSE
264: );
265: END import_data;
266:
267: -- Start of comments

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

273: -- Version : Current version 1.0
274: -- End of comments
275: PROCEDURE Export_Data
276: ( p_api_version IN NUMBER ,
277: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
278: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
279: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280: x_return_status OUT NOCOPY VARCHAR2 ,
281: x_msg_count OUT NOCOPY NUMBER ,

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

274: -- End of comments
275: PROCEDURE Export_Data
276: ( p_api_version IN NUMBER ,
277: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
278: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
279: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280: x_return_status OUT NOCOPY VARCHAR2 ,
281: x_msg_count OUT NOCOPY NUMBER ,
282: x_msg_data OUT NOCOPY VARCHAR2 ,

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

275: PROCEDURE Export_Data
276: ( p_api_version IN NUMBER ,
277: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
278: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
279: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280: x_return_status OUT NOCOPY VARCHAR2 ,
281: x_msg_count OUT NOCOPY NUMBER ,
282: x_msg_data OUT NOCOPY VARCHAR2 ,
283: p_imp_header_id IN NUMBER,

Line 304: IF NOT FND_API.compatible_api_call

300: BEGIN
301: -- Standard Start of API savepoint
302: SAVEPOINT Export_Data;
303: -- Standard call to check for call compatibility.
304: IF NOT FND_API.compatible_api_call
305: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
306: THEN
307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
308: END IF;

Line 307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

303: -- Standard call to check for call compatibility.
304: IF NOT FND_API.compatible_api_call
305: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
306: THEN
307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
308: END IF;
309: -- Initialize message list if p_init_msg_list is set to TRUE.
310: IF FND_API.to_Boolean( p_init_msg_list ) THEN
311: FND_MSG_PUB.initialize;

Line 310: IF FND_API.to_Boolean( p_init_msg_list ) THEN

306: THEN
307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
308: END IF;
309: -- Initialize message list if p_init_msg_list is set to TRUE.
310: IF FND_API.to_Boolean( p_init_msg_list ) THEN
311: FND_MSG_PUB.initialize;
312: END IF;
313: -- Initialize API return status to success
314: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 314: x_return_status := FND_API.G_RET_STS_SUCCESS;

310: IF FND_API.to_Boolean( p_init_msg_list ) THEN
311: FND_MSG_PUB.initialize;
312: END IF;
313: -- Initialize API return status to success
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315: -- API body
316:
317: l_imp_type_code := get_imp_type_code(p_imp_header_id);
318:

Line 381: RAISE FND_API.g_exc_unexpected_error;

377: p_status_code => 'FAIL');
378: cn_message_pkg.write
379: (p_message_text => l_conc_pgm || ' submission fail.',
380: p_message_type => 'ERROR');
381: RAISE FND_API.g_exc_unexpected_error;
382: END IF;
383:
384: cn_message_pkg.write
385: (p_message_text => 'Loading Concurrent Program ' || l_conc_pgm ||

Line 397: IF FND_API.To_Boolean( p_commit ) THEN

393:
394: -- End of API body.
395:
396: -- Standard check of p_commit.
397: IF FND_API.To_Boolean( p_commit ) THEN
398: COMMIT WORK;
399: END IF;
400: -- Standard call to get message count and if count is 1, get message info.
401: FND_MSG_PUB.count_and_get

Line 404: p_encoded => FND_API.G_FALSE

400: -- Standard call to get message count and if count is 1, get message info.
401: FND_MSG_PUB.count_and_get
402: (p_count => x_msg_count ,
403: p_data => x_msg_data ,
404: p_encoded => FND_API.G_FALSE
405: );
406:
407: EXCEPTION
408: WHEN FND_API.G_EXC_ERROR THEN

Line 408: WHEN FND_API.G_EXC_ERROR THEN

404: p_encoded => FND_API.G_FALSE
405: );
406:
407: EXCEPTION
408: WHEN FND_API.G_EXC_ERROR THEN
409: ROLLBACK TO Export_Data ;
410: x_return_status := FND_API.G_RET_STS_ERROR ;
411: cn_message_pkg.end_batch(l_process_audit_id);
412: FND_MSG_PUB.Count_And_Get(

Line 410: x_return_status := FND_API.G_RET_STS_ERROR ;

406:
407: EXCEPTION
408: WHEN FND_API.G_EXC_ERROR THEN
409: ROLLBACK TO Export_Data ;
410: x_return_status := FND_API.G_RET_STS_ERROR ;
411: cn_message_pkg.end_batch(l_process_audit_id);
412: FND_MSG_PUB.Count_And_Get(
413: p_count => x_msg_count ,
414: p_data => x_msg_data ,

Line 415: p_encoded => FND_API.G_FALSE

411: cn_message_pkg.end_batch(l_process_audit_id);
412: FND_MSG_PUB.Count_And_Get(
413: p_count => x_msg_count ,
414: p_data => x_msg_data ,
415: p_encoded => FND_API.G_FALSE
416: );
417:
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: ROLLBACK TO Export_Data ;

Line 418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

414: p_data => x_msg_data ,
415: p_encoded => FND_API.G_FALSE
416: );
417:
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: ROLLBACK TO Export_Data ;
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
421: cn_message_pkg.end_batch(l_process_audit_id);
422: FND_MSG_PUB.Count_And_Get(

Line 420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

416: );
417:
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: ROLLBACK TO Export_Data ;
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
421: cn_message_pkg.end_batch(l_process_audit_id);
422: FND_MSG_PUB.Count_And_Get(
423: p_count => x_msg_count ,
424: p_data => x_msg_data ,

Line 425: p_encoded => FND_API.G_FALSE

421: cn_message_pkg.end_batch(l_process_audit_id);
422: FND_MSG_PUB.Count_And_Get(
423: p_count => x_msg_count ,
424: p_data => x_msg_data ,
425: p_encoded => FND_API.G_FALSE
426: );
427:
428: WHEN OTHERS THEN
429: ROLLBACK TO Export_Data ;

Line 430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

426: );
427:
428: WHEN OTHERS THEN
429: ROLLBACK TO Export_Data ;
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
431: cn_message_pkg.set_error(l_api_name,'Unexpected error');
432: cn_message_pkg.end_batch(l_process_audit_id);
433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
434: THEN

Line 441: p_encoded => FND_API.G_FALSE

437: FND_MSG_PUB.Count_And_Get
438: (
439: p_count => x_msg_count ,
440: p_data => x_msg_data ,
441: p_encoded => FND_API.G_FALSE
442: );
443: END Export_Data;
444:
445: -- --------------------------------------------------------+

Line 565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

561: FND_MESSAGE.set_name ('CN', 'CN_IMP_DS_SUBMIT_FAIL');
562: cn_message_pkg.write
563: (p_message_text => fnd_message.get_string('CN','CN_IMP_DS_SUBMIT_FAIL'),
564: p_message_type => 'ERROR');
565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
566:
567: ELSE
568: cn_message_pkg.debug('Staging Data : SQL*Loader Submited. Request ID = ' || l_request_id);
569: END IF;

Line 599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

595: FND_MESSAGE.set_name ('CN', 'CN_IMP_DS_SUBMIT_FAIL');
596: cn_message_pkg.write
597: (p_message_text => fnd_message.get_string('CN','CN_IMP_DS_SUBMIT_FAIL'),
598: p_message_type => 'ERROR');
599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
600: END IF;
601:
602: IF l_dev_phase <> 'COMPLETE' OR l_dev_status <> 'NORMAL' THEN
603: -- Conc req complete with error or not complete

Line 613: -- RAISE FND_API.g_exc_unexpected_error;

609: (p_message_text => fnd_message.get_string('CN','CN_IMP_DS_FAIL'),
610: p_message_type => 'ERROR');
611: -- raise error after clean up creaated conc
612: GOTO delete_conc;
613: -- RAISE FND_API.g_exc_unexpected_error;
614: END IF;
615:
616: cn_message_pkg.debug('Staging Data : SQL*Loader Finished.');
617:

Line 650: RAISE FND_API.g_exc_unexpected_error;

646:
647: IF l_dev_phase <> 'COMPLETE' OR l_dev_status <> 'NORMAL' THEN
648: -- Conc req complete with error or not complete
649: -- raise error after clean up created conc
650: RAISE FND_API.g_exc_unexpected_error;
651: END IF;
652:
653: END IF; -- end status_code = 'SUBMIT' AND server_flag = 'Y'
654:

Line 683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

679: --errbuf := SUBSTR (FND_MESSAGE.GET, 1, 240);
680: -- End of API body.
681:
682: EXCEPTION
683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
684: retcode := 2 ;
685: update_imp_headers
686: (p_imp_header_id => p_imp_header_id,
687: p_status_code => 'STAGE_FAIL');

Line 692: p_encoded => FND_API.G_FALSE

688: cn_message_pkg.end_batch(l_process_audit_id);
689: FND_MSG_PUB.Count_And_Get(
690: p_count => l_msg_count ,
691: p_data => errbuf ,
692: p_encoded => FND_API.G_FALSE
693: );
694:
695: WHEN OTHERS THEN
696: update_imp_headers

Line 712: p_encoded => FND_API.G_FALSE

708: END IF;
709: FND_MSG_PUB.count_and_get
710: (p_count => l_msg_count ,
711: p_data => errbuf ,
712: p_encoded => FND_API.G_FALSE
713: );
714: END IF;
715: cn_message_pkg.set_error(l_api_name,errbuf);
716: cn_message_pkg.end_batch(l_process_audit_id);

Line 813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

809: FND_MESSAGE.set_name ('CN', 'CN_IMP_ST_SUBMIT_FAIL');
810: cn_message_pkg.write
811: (p_message_text => fnd_message.get_string('CN','CN_IMP_ST_SUBMIT_FAIL') || ' ' || l_conc_program,
812: p_message_type => 'ERROR');
813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
814:
815: ELSE
816: cn_message_pkg.debug('Loading Data : Conc Pgm Submited. Request ID = ' || l_request_id);
817: END IF;

Line 845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

841: FND_MESSAGE.set_name ('CN', 'CN_IMP_ST_SUBMIT_FAIL');
842: cn_message_pkg.write
843: (p_message_text => fnd_message.get_string('CN','CN_IMP_ST_SUBMIT_FAIL'),
844: p_message_type => 'ERROR');
845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
846: END IF;
847:
848: IF l_dev_phase <> 'COMPLETE' OR l_dev_status <> 'NORMAL' THEN
849: -- Conc req complete with error or not complete

Line 857: RAISE FND_API.g_exc_unexpected_error;

853: p_status_code => 'IMPORT_FAIL');
854: cn_message_pkg.write
855: (p_message_text => fnd_message.get_string('CN','CN_IMP_ST_FAIL'),
856: p_message_type => 'ERROR');
857: RAISE FND_API.g_exc_unexpected_error;
858: END IF;
859:
860: cn_message_pkg.debug('Loading Data : Load Data Conc Pgm Finished.');
861: END IF; -- end status_code = 'STAGE'

Line 874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

870: --errbuf := SUBSTR (FND_MESSAGE.GET, 1, 240);
871: -- End of API body.
872:
873: EXCEPTION
874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
875: retcode := 2 ;
876: update_imp_headers
877: (p_imp_header_id => p_imp_header_id,
878: p_status_code => 'IMPORT_FAIL');

Line 883: p_encoded => FND_API.G_FALSE

879: cn_message_pkg.end_batch(l_process_audit_id);
880: FND_MSG_PUB.Count_And_Get(
881: p_count => l_msg_count ,
882: p_data => errbuf ,
883: p_encoded => FND_API.G_FALSE
884: );
885:
886: WHEN OTHERS THEN
887: update_imp_headers

Line 903: p_encoded => FND_API.G_FALSE

899: END IF;
900: FND_MSG_PUB.count_and_get
901: (p_count => l_msg_count ,
902: p_data => errbuf ,
903: p_encoded => FND_API.G_FALSE
904: );
905: END IF;
906: cn_message_pkg.set_error(l_api_name,errbuf);
907: cn_message_pkg.end_batch(l_process_audit_id);

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

933: -- End of comments
934:
935: PROCEDURE Client_Stage_Data
936: ( p_api_version IN NUMBER ,
937: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
938: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
939: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
940: x_return_status OUT NOCOPY VARCHAR2 ,
941: x_msg_count OUT NOCOPY NUMBER ,

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

934:
935: PROCEDURE Client_Stage_Data
936: ( p_api_version IN NUMBER ,
937: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
938: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
939: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
940: x_return_status OUT NOCOPY VARCHAR2 ,
941: x_msg_count OUT NOCOPY NUMBER ,
942: x_msg_data OUT NOCOPY VARCHAR2 ,

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

935: PROCEDURE Client_Stage_Data
936: ( p_api_version IN NUMBER ,
937: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
938: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
939: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
940: x_return_status OUT NOCOPY VARCHAR2 ,
941: x_msg_count OUT NOCOPY NUMBER ,
942: x_msg_data OUT NOCOPY VARCHAR2 ,
943: p_imp_header_id IN NUMBER,

Line 986: IF NOT FND_API.compatible_api_call

982: BEGIN
983: -- Standard Start of API savepoint
984: SAVEPOINT Client_Stage_Data;
985: -- Standard call to check for call compatibility.
986: IF NOT FND_API.compatible_api_call
987: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
988: THEN
989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
990: END IF;

Line 989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

985: -- Standard call to check for call compatibility.
986: IF NOT FND_API.compatible_api_call
987: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
988: THEN
989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
990: END IF;
991: -- Initialize message list if p_init_msg_list is set to TRUE.
992: IF FND_API.to_Boolean( p_init_msg_list ) THEN
993: FND_MSG_PUB.initialize;

Line 992: IF FND_API.to_Boolean( p_init_msg_list ) THEN

988: THEN
989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
990: END IF;
991: -- Initialize message list if p_init_msg_list is set to TRUE.
992: IF FND_API.to_Boolean( p_init_msg_list ) THEN
993: FND_MSG_PUB.initialize;
994: END IF;
995: -- Initialize API return status to success
996: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 996: x_return_status := FND_API.G_RET_STS_SUCCESS;

992: IF FND_API.to_Boolean( p_init_msg_list ) THEN
993: FND_MSG_PUB.initialize;
994: END IF;
995: -- Initialize API return status to success
996: x_return_status := FND_API.G_RET_STS_SUCCESS;
997: -- API body
998: l_imp_type_code := get_imp_type_code(p_imp_header_id);
999:
1000: -- Get imp_header info

Line 1049: RAISE FND_API.G_EXC_ERROR ;

1045: END IF;
1046: cn_message_pkg.write
1047: (p_message_text => fnd_message.get_string('CN','CN_IMP_MAPPED_CHANGED'),
1048: p_message_type => 'ERROR');
1049: RAISE FND_API.G_EXC_ERROR ;
1050: END IF;
1051: -- build column list
1052: l_columns(l_index) := c_tar_col.target_column_name;
1053: l_index := l_index + 1;

Line 1079: IF x_return_status <> FND_API.g_ret_sts_success THEN

1075: x_return_status => x_return_status,
1076: x_msg_count => x_msg_count,
1077: x_msg_data => x_msg_data);
1078:
1079: IF x_return_status <> FND_API.g_ret_sts_success THEN
1080: RAISE FND_API.G_EXC_ERROR;
1081: END IF;
1082: -- UPDATE cn_imp_headers
1083: OPEN c_loaded_rows;

Line 1080: RAISE FND_API.G_EXC_ERROR;

1076: x_msg_count => x_msg_count,
1077: x_msg_data => x_msg_data);
1078:
1079: IF x_return_status <> FND_API.g_ret_sts_success THEN
1080: RAISE FND_API.G_EXC_ERROR;
1081: END IF;
1082: -- UPDATE cn_imp_headers
1083: OPEN c_loaded_rows;
1084: FETCH c_loaded_rows INTO l_loaded_rows;

Line 1109: IF FND_API.To_Boolean( p_commit ) THEN

1105:
1106: -- End of API body.
1107:
1108: -- Standard check of p_commit.
1109: IF FND_API.To_Boolean( p_commit ) THEN
1110: COMMIT WORK;
1111: END IF;
1112: -- Standard call to get message count and if count is 1, get message info.
1113: FND_MSG_PUB.count_and_get

Line 1116: p_encoded => FND_API.G_FALSE

1112: -- Standard call to get message count and if count is 1, get message info.
1113: FND_MSG_PUB.count_and_get
1114: (p_count => x_msg_count ,
1115: p_data => x_msg_data ,
1116: p_encoded => FND_API.G_FALSE
1117: );
1118:
1119: EXCEPTION
1120: WHEN FND_API.G_EXC_ERROR THEN

Line 1120: WHEN FND_API.G_EXC_ERROR THEN

1116: p_encoded => FND_API.G_FALSE
1117: );
1118:
1119: EXCEPTION
1120: WHEN FND_API.G_EXC_ERROR THEN
1121: ROLLBACK TO Client_Stage_Data ;
1122: update_imp_headers
1123: (p_imp_header_id => p_imp_header_id,
1124: p_status_code => 'STAGE_FAIL');

Line 1125: x_return_status := FND_API.G_RET_STS_ERROR ;

1121: ROLLBACK TO Client_Stage_Data ;
1122: update_imp_headers
1123: (p_imp_header_id => p_imp_header_id,
1124: p_status_code => 'STAGE_FAIL');
1125: x_return_status := FND_API.G_RET_STS_ERROR ;
1126: cn_message_pkg.end_batch(l_process_audit_id);
1127: FND_MSG_PUB.Count_And_Get(
1128: p_count => x_msg_count ,
1129: p_data => x_msg_data ,

Line 1130: p_encoded => FND_API.G_FALSE

1126: cn_message_pkg.end_batch(l_process_audit_id);
1127: FND_MSG_PUB.Count_And_Get(
1128: p_count => x_msg_count ,
1129: p_data => x_msg_data ,
1130: p_encoded => FND_API.G_FALSE
1131: );
1132:
1133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1134: ROLLBACK TO Client_Stage_Data ;

Line 1133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1129: p_data => x_msg_data ,
1130: p_encoded => FND_API.G_FALSE
1131: );
1132:
1133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1134: ROLLBACK TO Client_Stage_Data ;
1135: update_imp_headers
1136: (p_imp_header_id => p_imp_header_id,
1137: p_status_code => 'STAGE_FAIL');

Line 1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1134: ROLLBACK TO Client_Stage_Data ;
1135: update_imp_headers
1136: (p_imp_header_id => p_imp_header_id,
1137: p_status_code => 'STAGE_FAIL');
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1139: cn_message_pkg.end_batch(l_process_audit_id);
1140: FND_MSG_PUB.Count_And_Get(
1141: p_count => x_msg_count ,
1142: p_data => x_msg_data ,

Line 1143: p_encoded => FND_API.G_FALSE

1139: cn_message_pkg.end_batch(l_process_audit_id);
1140: FND_MSG_PUB.Count_And_Get(
1141: p_count => x_msg_count ,
1142: p_data => x_msg_data ,
1143: p_encoded => FND_API.G_FALSE
1144: );
1145:
1146: WHEN OTHERS THEN
1147: ROLLBACK TO Client_Stage_Data ;

Line 1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1147: ROLLBACK TO Client_Stage_Data ;
1148: update_imp_headers
1149: (p_imp_header_id => p_imp_header_id,
1150: p_status_code => 'STAGE_FAIL');
1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1152: cn_message_pkg.set_error(l_api_name,'Unexpected Error');
1153: cn_message_pkg.end_batch(l_process_audit_id);
1154: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1155: THEN

Line 1162: p_encoded => FND_API.G_FALSE

1158: FND_MSG_PUB.Count_And_Get
1159: (
1160: p_count => x_msg_count ,
1161: p_data => x_msg_data ,
1162: p_encoded => FND_API.G_FALSE
1163: );
1164:
1165: END Client_Stage_Data ;
1166: