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 CN_MESSAGE_PKG

Line 114: cn_message_pkg.begin_batch

110: FROM cn_imp_headers
111: WHERE imp_header_id = p_imp_header_id;
112:
113: -- open process audit batch
114: cn_message_pkg.begin_batch
115: ( x_process_type => l_imp_type_code,
116: x_parent_proc_audit_id => p_imp_header_id ,
117: x_process_audit_id => l_process_audit_id,
118: x_request_id => null,

Line 121: cn_message_pkg.write

117: x_process_audit_id => l_process_audit_id,
118: x_request_id => null,
119: p_org_id => p_org_id);
120:
121: cn_message_pkg.write
122: (p_message_text => 'Importing ' || l_imp_header.name,
123: p_message_type => 'MILESTONE'
124: );
125: ----------------------------------------------+

Line 163: cn_message_pkg.write

159: IF l_request_id = 0 THEN
160: update_imp_headers
161: (p_imp_header_id => p_imp_header_id,
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;

Line 169: cn_message_pkg.write

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,
171: p_message_type => 'MILESTONE'
172: );
173:

Line 180: cn_message_pkg.debug('Status = '|| l_imp_header.status_code);

176: ELSE
177: -- Client Side Import. Stage Completed.
178: -- Load_Data call to transfer from stage to target.
179: --
180: cn_message_pkg.debug('Status = '|| l_imp_header.status_code);
181:
182: IF l_imp_header.status_code = 'STAGE' THEN
183:
184: FND_REQUEST.SET_ORG_ID(p_org_id);

Line 198: cn_message_pkg.write

194: IF l_request_id = 0 THEN
195: update_imp_headers
196: (p_imp_header_id => p_imp_header_id,
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;

Line 204: cn_message_pkg.write

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,
206: p_message_type => 'MILESTONE'
207: );
208:

Line 214: cn_message_pkg.end_batch(l_process_audit_id);

210: END IF;
211: END IF;
212:
213: -- close process batch
214: cn_message_pkg.end_batch(l_process_audit_id);
215:
216: -- End of API body.
217:
218: -- Standard check of p_commit.

Line 233: cn_message_pkg.end_batch(l_process_audit_id);

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 ,
237: p_encoded => FND_API.G_FALSE

Line 243: cn_message_pkg.end_batch(l_process_audit_id);

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 ,
247: p_encoded => FND_API.G_FALSE

Line 253: cn_message_pkg.set_error(l_api_name,'Unexpected error');

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
257: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

Line 254: cn_message_pkg.end_batch(l_process_audit_id);

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
257: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
258: END IF;

Line 330: cn_message_pkg.begin_batch

326: FROM cn_import_types
327: WHERE import_type_code = l_imp_type_code;
328:
329: -- open process audit batch
330: cn_message_pkg.begin_batch
331: ( x_process_type => l_imp_type_code,
332: x_parent_proc_audit_id => p_imp_header_id ,
333: x_process_audit_id => l_process_audit_id,
334: x_request_id => null,

Line 337: cn_message_pkg.write

333: x_process_audit_id => l_process_audit_id,
334: x_request_id => null,
335: p_org_id => p_org_id);
336:
337: cn_message_pkg.write
338: (p_message_text => 'Exporting ' || l_name,
339: p_message_type => 'MILESTONE');
340:
341: ----------------------------------------------+

Line 378: cn_message_pkg.write

374: IF l_request_id = 0 THEN
375: update_imp_headers
376: (p_imp_header_id => p_imp_header_id,
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;

Line 384: cn_message_pkg.write

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 ||
386: ' Started.REQ = '|| l_request_id,
387: p_message_type => 'MILESTONE');
388:

Line 392: cn_message_pkg.end_batch(l_process_audit_id);

388:
389: x_request_id := l_request_id;
390:
391: -- close process batch
392: cn_message_pkg.end_batch(l_process_audit_id);
393:
394: -- End of API body.
395:
396: -- Standard check of p_commit.

Line 411: cn_message_pkg.end_batch(l_process_audit_id);

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 ,
415: p_encoded => FND_API.G_FALSE

Line 421: cn_message_pkg.end_batch(l_process_audit_id);

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 ,
425: p_encoded => FND_API.G_FALSE

Line 431: cn_message_pkg.set_error(l_api_name,'Unexpected error');

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
435: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

Line 432: cn_message_pkg.end_batch(l_process_audit_id);

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
435: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
436: END IF;

Line 508: cn_message_pkg.begin_batch

504: FROM cn_imp_headers
505: WHERE imp_header_id = p_imp_header_id;
506:
507: -- open process audit batch
508: cn_message_pkg.begin_batch
509: ( x_process_type => l_imp_type_code,
510: x_parent_proc_audit_id => p_imp_header_id ,
511: x_process_audit_id => l_process_audit_id,
512: x_request_id => null,

Line 515: cn_message_pkg.write

511: x_process_audit_id => l_process_audit_id,
512: x_request_id => null,
513: p_org_id => p_org_id);
514:
515: cn_message_pkg.write
516: (p_message_text => 'Start Server Staging Data : Server_Stage_data - ' || l_short_name,
517: p_message_type => 'MILESTONE'
518: );
519:

Line 535: cn_message_pkg.debug('Staging Data : Conc Executable Created - ' || l_short_name);

531: execution_file_name => p_control_file,
532: language_code => USERENV ('LANG')
533: );
534:
535: cn_message_pkg.debug('Staging Data : Conc Executable Created - ' || l_short_name);
536:
537: -- Register the concurrent program.
538: FND_PROGRAM.REGISTER
539: (program => l_short_name,

Line 548: cn_message_pkg.debug('Staging Data : Conc Program Created - ' || l_short_name);

544: executable_application => 'CN',
545: language_code => USERENV ('LANG')
546: );
547:
548: cn_message_pkg.debug('Staging Data : Conc Program Created - ' || l_short_name);
549:
550: -- Since this is a SQL*Loader concurrent program,
551: -- we don't need to specify other parameters. The
552: -- only other parameter would be the data file name,

Line 562: cn_message_pkg.write

558: );
559:
560: IF l_request_id = 0 THEN
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:

Line 568: cn_message_pkg.debug('Staging Data : SQL*Loader Submited. Request ID = ' || l_request_id);

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;
570: -- when submit conc reg from pl/sql, a COMMIT is required
571: -- **** DO NOT REMOVE ****
572: COMMIT;

Line 596: cn_message_pkg.write

592: -- submitted.
593: ---------------------------------------------+
594: IF NOT l_wait_status THEN
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;

Line 608: cn_message_pkg.write

604: FND_MESSAGE.set_name ('CN', 'CN_IMP_DS_FAIL');
605: update_imp_headers
606: (p_imp_header_id => p_imp_header_id,
607: p_status_code => 'STAGE_FAIL');
608: cn_message_pkg.write
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;

Line 616: cn_message_pkg.debug('Staging Data : SQL*Loader Finished.');

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:
618: -- UPDATE cn_imp_headers
619: OPEN c_loaded_rows;
620: FETCH c_loaded_rows INTO l_loaded_rows;

Line 635: cn_message_pkg.debug('Staging Data : Delete Conc Program.');

631: FND_PROGRAM.DELETE_PROGRAM
632: (program_short_name => l_short_name,
633: application => 'CN'
634: );
635: cn_message_pkg.debug('Staging Data : Delete Conc Program.');
636:
637: --
638: -- The "executable" will be the same as the program short name
639: -- for all run-time generated concurrent programs. The registered

Line 645: cn_message_pkg.debug('Staging Data : Delete Conc Executable.');

641: FND_PROGRAM.DELETE_EXECUTABLE
642: (executable_short_name => l_short_name,
643: application => 'CN'
644: );
645: cn_message_pkg.debug('Staging Data : Delete Conc Executable.');
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

Line 655: cn_message_pkg.write

651: END IF;
652:
653: END IF; -- end status_code = 'SUBMIT' AND server_flag = 'Y'
654:
655: cn_message_pkg.write
656: (p_message_text => 'End Staging Data : Server_Stage_data - ' || l_short_name,
657: p_message_type => 'MILESTONE');
658:
659: -- close process batch

Line 660: cn_message_pkg.end_batch(l_process_audit_id);

656: (p_message_text => 'End Staging Data : Server_Stage_data - ' || l_short_name,
657: p_message_type => 'MILESTONE');
658:
659: -- close process batch
660: cn_message_pkg.end_batch(l_process_audit_id);
661:
662: -- Get imp_header status
663: SELECT name, status_code,server_flag
664: INTO l_imp_header.name ,l_imp_header.status_code ,l_imp_header.server_flag

Line 688: cn_message_pkg.end_batch(l_process_audit_id);

684: retcode := 2 ;
685: update_imp_headers
686: (p_imp_header_id => p_imp_header_id,
687: p_status_code => 'STAGE_FAIL');
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

Line 715: cn_message_pkg.set_error(l_api_name,errbuf);

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);
717:
718: END Server_Stage_data;
719:

Line 716: cn_message_pkg.end_batch(l_process_audit_id);

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);
717:
718: END Server_Stage_data;
719:
720: -- --------------------------------------------------------+

Line 777: cn_message_pkg.begin_batch

773: FROM cn_imp_headers
774: WHERE imp_header_id = p_imp_header_id;
775:
776: -- open process audit batch
777: cn_message_pkg.begin_batch
778: ( x_process_type => l_imp_type_code,
779: x_parent_proc_audit_id => p_imp_header_id ,
780: x_process_audit_id => l_process_audit_id,
781: x_request_id => null,

Line 784: cn_message_pkg.write

780: x_process_audit_id => l_process_audit_id,
781: x_request_id => null,
782: p_org_id => p_org_id);
783:
784: cn_message_pkg.write
785: (p_message_text => 'Start Loading Data : Load_Data - ' || l_conc_program,
786: p_message_type => 'MILESTONE');
787:
788: -- Start Loading Data

Line 810: cn_message_pkg.write

806: );
807:
808: IF l_request_id = 0 THEN
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:

Line 816: cn_message_pkg.debug('Loading Data : Conc Pgm Submited. Request ID = ' || l_request_id);

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;
818: -- when submit conc reg from pl/sql, a COMMIT is required
819: -- **** DO NOT REMOVE ****
820: COMMIT;

Line 842: cn_message_pkg.write

838: -- submitted.
839: ---------------------------------------------+
840: IF NOT l_wait_status THEN
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;

Line 854: cn_message_pkg.write

850: FND_MESSAGE.set_name ('CN', 'CN_IMP_ST_FAIL');
851: update_imp_headers
852: (p_imp_header_id => p_imp_header_id,
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;

Line 860: cn_message_pkg.debug('Loading Data : Load Data Conc Pgm Finished.');

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'
862: cn_message_pkg.write
863: (p_message_text => 'End Loading Data : Load_Data - ' || l_conc_program,
864: p_message_type => 'MILESTONE'

Line 862: cn_message_pkg.write

858: END IF;
859:
860: cn_message_pkg.debug('Loading Data : Load Data Conc Pgm Finished.');
861: END IF; -- end status_code = 'STAGE'
862: cn_message_pkg.write
863: (p_message_text => 'End Loading Data : Load_Data - ' || l_conc_program,
864: p_message_type => 'MILESTONE'
865: );
866:

Line 868: cn_message_pkg.end_batch(l_process_audit_id);

864: p_message_type => 'MILESTONE'
865: );
866:
867: -- Close process audit batch
868: cn_message_pkg.end_batch(l_process_audit_id);
869:
870: --errbuf := SUBSTR (FND_MESSAGE.GET, 1, 240);
871: -- End of API body.
872:

Line 879: cn_message_pkg.end_batch(l_process_audit_id);

875: retcode := 2 ;
876: update_imp_headers
877: (p_imp_header_id => p_imp_header_id,
878: p_status_code => 'IMPORT_FAIL');
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

Line 906: cn_message_pkg.set_error(l_api_name,errbuf);

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);
908:
909: END Load_Data;
910:

Line 907: cn_message_pkg.end_batch(l_process_audit_id);

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);
908:
909: END Load_Data;
910:
911: -- Start of comments

Line 1020: cn_message_pkg.begin_batch

1016: l_imp_header.status_code := 'SUBMIT';
1017: END IF;
1018:
1019: -- open process audit batch
1020: cn_message_pkg.begin_batch
1021: ( x_process_type => l_imp_type_code,
1022: x_parent_proc_audit_id => p_imp_header_id ,
1023: x_process_audit_id => l_process_audit_id,
1024: x_request_id => null,

Line 1027: cn_message_pkg.write

1023: x_process_audit_id => l_process_audit_id,
1024: x_request_id => null,
1025: p_org_id => p_org_id);
1026:
1027: cn_message_pkg.write
1028: (p_message_text => 'Start Client Staging Data : Client_Stage_data ' ,
1029: p_message_type => 'MILESTONE');
1030:
1031: -- Start staging

Line 1046: cn_message_pkg.write

1042: THEN
1043: FND_MESSAGE.SET_NAME ('CN' , 'CN_IMP_MAPPED_CHANGED');
1044: FND_MSG_PUB.Add;
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;

Line 1064: cn_message_pkg.debug('Staging Data : Unmapped data dropped.');

1060: l_src_index := l_src_index + 1;
1061: END LOOP; -- end l_row_count LOOP
1062: END LOOP; -- End FOR c_tar_col IN c_tar_col_cv LOOP
1063:
1064: cn_message_pkg.debug('Staging Data : Unmapped data dropped.');
1065:
1066: -- Insert data into stage table
1067: cn_import_client_pvt.insert_data
1068: (p_api_version => 1.0,

Line 1095: cn_message_pkg.write

1091: p_staged_row => l_loaded_rows);
1092:
1093: END IF; -- End IF l_imp_header.status_code = 'SUBMIT'
1094:
1095: cn_message_pkg.write
1096: (p_message_text => 'staged row = ' || l_row_count ,
1097: p_message_type => 'DEBUG');
1098:
1099: cn_message_pkg.write

Line 1099: cn_message_pkg.write

1095: cn_message_pkg.write
1096: (p_message_text => 'staged row = ' || l_row_count ,
1097: p_message_type => 'DEBUG');
1098:
1099: cn_message_pkg.write
1100: (p_message_text => 'End Client Staging Data : Client_Stage_data ' ,
1101: p_message_type => 'MILESTONE');
1102:
1103: -- close process batch

Line 1104: cn_message_pkg.end_batch(l_process_audit_id);

1100: (p_message_text => 'End Client Staging Data : Client_Stage_data ' ,
1101: p_message_type => 'MILESTONE');
1102:
1103: -- close process batch
1104: cn_message_pkg.end_batch(l_process_audit_id);
1105:
1106: -- End of API body.
1107:
1108: -- Standard check of p_commit.

Line 1126: cn_message_pkg.end_batch(l_process_audit_id);

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 ,
1130: p_encoded => FND_API.G_FALSE

Line 1139: cn_message_pkg.end_batch(l_process_audit_id);

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 ,
1143: p_encoded => FND_API.G_FALSE

Line 1152: cn_message_pkg.set_error(l_api_name,'Unexpected Error');

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
1156: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

Line 1153: cn_message_pkg.end_batch(l_process_audit_id);

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
1156: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1157: END IF;

Line 1277: -- cn_message_pkg.debug(x_header_list);

1273: x_sql_stmt := x_sql_stmt || ' WHERE imp_line_id = :id' ;
1274: END IF;
1275: CLOSE c_src_col_csr;
1276:
1277: -- cn_message_pkg.debug(x_header_list);
1278: -- cn_message_pkg.debug(x_sql_stmt);
1279:
1280: END build_error_rec;
1281:

Line 1278: -- cn_message_pkg.debug(x_sql_stmt);

1274: END IF;
1275: CLOSE c_src_col_csr;
1276:
1277: -- cn_message_pkg.debug(x_header_list);
1278: -- cn_message_pkg.debug(x_sql_stmt);
1279:
1280: END build_error_rec;
1281:
1282: -- --------------------------------------------------------+

Line 1300: cn_message_pkg.write

1296: BEGIN
1297:
1298: EXECUTE IMMEDIATE p_sql_stmt INTO l_data_list USING p_imp_line_id ;
1299:
1300: cn_message_pkg.write
1301: (p_message_text => '-- ' || p_header_list,
1302: p_message_type => 'ERROR');
1303:
1304: cn_message_pkg.write

Line 1304: cn_message_pkg.write

1300: cn_message_pkg.write
1301: (p_message_text => '-- ' || p_header_list,
1302: p_message_type => 'ERROR');
1303:
1304: cn_message_pkg.write
1305: (p_message_text => '-- ' || l_data_list,
1306: p_message_type => 'ERROR');
1307:
1308: END write_error_rec;