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_IMP_HIERARCHY_PVT dependencies on CN_MESSAGE_PKG

Line 123: cn_message_pkg.debug

119: SAVEPOINT Imp_Hierarchy_Type ;
120: -- Initialize API return status to success
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122:
123: cn_message_pkg.debug
124: ('Start Import Hierarchy Type : ' || p_hier_record.hierarchy_type);
125:
126: -- Get BASE_TABLE_NAME,PRIMARY_KEY,HIERARCHY_VALUE
127: BEGIN

Line 149: cn_message_pkg.debug('-- Base table = ' || p_hier_record.base_table_name);

145: p_hier_record.primary_key := fnd_api.G_MISS_CHAR ;
146: p_hier_record.hierarchy_value := fnd_api.G_MISS_CHAR ;
147: RAISE FND_API.g_exc_error;
148: END;
149: cn_message_pkg.debug('-- Base table = ' || p_hier_record.base_table_name);
150:
151: -- Get IDs for BASE_TABLE_NAME
152: BEGIN
153: SELECT table_id INTO x_base_table_id

Line 163: cn_message_pkg.debug('-- Base table ID = ' || x_base_table_id);

159: l_message := fnd_message.get_string('CN','CN_HIER_NF_BTBL');
160: l_error_code := 'CN_HIER_NF_BTBL';
161: RAISE FND_API.g_exc_error;
162: END;
163: cn_message_pkg.debug('-- Base table ID = ' || x_base_table_id);
164:
165: -- Get IDs for PRIMARY_KEY
166: BEGIN
167: SELECT column_id INTO x_primary_key_id

Line 178: cn_message_pkg.debug('-- PK ID = ' || x_primary_key_id);

174: l_message := fnd_message.get_string('CN','CN_HIER_NF_PKEY');
175: l_error_code := 'CN_HIER_NF_PKEY';
176: RAISE FND_API.g_exc_error;
177: END;
178: cn_message_pkg.debug('-- PK ID = ' || x_primary_key_id);
179:
180: -- Get IDs for HIERARCHY_VALUE
181: BEGIN
182: SELECT column_id INTO x_hier_value_id

Line 194: cn_message_pkg.debug('-- Hier value ID = ' || x_hier_value_id);

190: l_message := fnd_message.get_string('CN','CN_HIER_NF_HIERVAL');
191: l_error_code := 'CN_HIER_NF_HIERVAL';
192: RAISE FND_API.g_exc_error;
193: END;
194: cn_message_pkg.debug('-- Hier value ID = ' || x_hier_value_id);
195:
196: -- Create new hierarchy type if not exist
197: BEGIN
198: SELECT dimension_id INTO x_dimension_id FROM cn_dimensions_vl

Line 239: cn_message_pkg.debug('-- dimension ID = ' || x_dimension_id);

235: END IF;
236: RAISE FND_API.g_exc_error;
237: END IF;
238: END;
239: cn_message_pkg.debug('-- dimension ID = ' || x_dimension_id);
240:
241: -- Check created/existed hierarchy type has same base table,pk,
242: -- hier_value within the import data
243: BEGIN

Line 264: cn_message_pkg.debug

260: END;
261:
262: x_error_msg := l_message;
263:
264: cn_message_pkg.debug
265: ('End Import Hierarchy Type : ' || p_hier_record.hierarchy_type ||
266: ' dimension_id = ' || x_dimension_id );
267:
268: EXCEPTION

Line 280: cn_message_pkg.write

276: p_error_code => l_error_code,
277: p_error_msg => l_message,
278: x_failed_row => x_failed_row,
279: x_processed_row => x_processed_row);
280: cn_message_pkg.write
281: (p_message_text => l_message ,
282: p_message_type => 'ERROR');
283: cn_message_pkg.write
284: (p_message_text =>

Line 283: cn_message_pkg.write

279: x_processed_row => x_processed_row);
280: cn_message_pkg.write
281: (p_message_text => l_message ,
282: p_message_type => 'ERROR');
283: cn_message_pkg.write
284: (p_message_text =>
285: ' All record with hierarchy type = ' || p_hier_record.hierarchy_type
286: || ' and base table = ' || p_hier_record.BASE_TABLE_NAME
287: || ' and primary key = ' || p_hier_record.primary_key

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

291:
292: WHEN OTHERS THEN
293: ROLLBACK TO Imp_Hierarchy_Type ;
294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295: cn_message_pkg.set_error(l_api_name,'Unexpected error');
296: l_error_code := SQLCODE;
297: l_message := SUBSTR (SQLERRM , 1 , 2000);
298: x_error_msg := l_message;
299: seterr_imp_hierarchy

Line 306: cn_message_pkg.write

302: p_error_code => l_error_code,
303: p_error_msg => l_message,
304: x_failed_row => x_failed_row,
305: x_processed_row => x_processed_row);
306: cn_message_pkg.write
307: (p_message_text => l_message ,
308: p_message_type => 'ERROR');
309: cn_message_pkg.write
310: (p_message_text =>

Line 309: cn_message_pkg.write

305: x_processed_row => x_processed_row);
306: cn_message_pkg.write
307: (p_message_text => l_message ,
308: p_message_type => 'ERROR');
309: cn_message_pkg.write
310: (p_message_text =>
311: ' All record with hierarchy type = ' || p_hier_record.hierarchy_type
312: || ' and base table = ' || p_hier_record.BASE_TABLE_NAME
313: || ' and primary key = ' || p_hier_record.primary_key

Line 348: cn_message_pkg.debug

344: SAVEPOINT Imp_Head_Hierarchy ;
345: -- Initialize API return status to success
346: x_return_status := FND_API.G_RET_STS_SUCCESS;
347:
348: cn_message_pkg.debug
349: ('Start Import Head Hierarchy : ' || p_hier_record.hierarchy_name);
350: -- Create new head hierarchy if not exist
351: BEGIN
352: SELECT head_hierarchy_id INTO x_head_hierarchy_id

Line 382: cn_message_pkg.debug

378: END;
379:
380: x_error_msg := l_message;
381:
382: cn_message_pkg.debug
383: ('End Import Head Hierarchy : ' || p_hier_record.hierarchy_name ||
384: ' head_hierarchy_id = ' || x_head_hierarchy_id );
385:
386: EXCEPTION

Line 398: cn_message_pkg.write

394: p_error_code => l_error_code,
395: p_error_msg => l_message,
396: x_failed_row => x_failed_row,
397: x_processed_row => x_processed_row);
398: cn_message_pkg.write
399: (p_message_text => l_message ,
400: p_message_type => 'ERROR');
401: cn_message_pkg.write
402: (p_message_text =>

Line 401: cn_message_pkg.write

397: x_processed_row => x_processed_row);
398: cn_message_pkg.write
399: (p_message_text => l_message ,
400: p_message_type => 'ERROR');
401: cn_message_pkg.write
402: (p_message_text =>
403: ' All record with hierarchy type = ' || p_hier_record.hierarchy_type
404: || ' and Hierarchy name = ' || p_hier_record.hierarchy_name
405: || ' are treated as failed records.' ,

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

407:
408: WHEN OTHERS THEN
409: ROLLBACK TO Imp_Head_Hierarchy ;
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: cn_message_pkg.set_error(l_api_name,'Unexpected error');
412: l_error_code := SQLCODE;
413: l_message := SUBSTR (SQLERRM , 1 , 2000);
414: x_error_msg := l_message;
415: seterr_imp_hierarchy

Line 422: cn_message_pkg.write

418: p_error_code => l_error_code,
419: p_error_msg => l_message,
420: x_failed_row => x_failed_row,
421: x_processed_row => x_processed_row);
422: cn_message_pkg.write
423: (p_message_text => l_message ,
424: p_message_type => 'ERROR');
425: cn_message_pkg.write
426: (p_message_text =>

Line 425: cn_message_pkg.write

421: x_processed_row => x_processed_row);
422: cn_message_pkg.write
423: (p_message_text => l_message ,
424: p_message_type => 'ERROR');
425: cn_message_pkg.write
426: (p_message_text =>
427: ' All record with hierarchy type = ' || p_hier_record.hierarchy_type
428: || ' and Hierarchy name = ' || p_hier_record.hierarchy_name
429: || ' are treated as failed records.' ,

Line 462: cn_message_pkg.debug

458: SAVEPOINT Imp_Dim_Hierarchy ;
459: -- Initialize API return status to success
460: x_return_status := FND_API.G_RET_STS_SUCCESS;
461:
462: cn_message_pkg.debug
463: ('Start Import Dim Hierarchy : ' || p_hier_record.start_date
464: || p_hier_record.end_date);
465: -- Create new dim hierarchy if not exist
466: BEGIN

Line 502: cn_message_pkg.debug

498: END;
499:
500: x_error_msg := l_message;
501:
502: cn_message_pkg.debug
503: ('End Import Dim Hierarchy : ' || p_hier_record.start_date ||
504: p_hier_record.end_date || ' dim_hierarchy_id = ' || x_dim_hierarchy_id );
505:
506: EXCEPTION

Line 518: cn_message_pkg.write

514: p_error_code => l_error_code,
515: p_error_msg => l_message,
516: x_failed_row => x_failed_row,
517: x_processed_row => x_processed_row);
518: cn_message_pkg.write
519: (p_message_text => l_message ,
520: p_message_type => 'ERROR');
521: cn_message_pkg.write
522: (p_message_text =>

Line 521: cn_message_pkg.write

517: x_processed_row => x_processed_row);
518: cn_message_pkg.write
519: (p_message_text => l_message ,
520: p_message_type => 'ERROR');
521: cn_message_pkg.write
522: (p_message_text =>
523: ' All record with hierarchy type = ' || p_hier_record.hierarchy_type
524: || ' and Hierarchy name = ' || p_hier_record.hierarchy_name
525: || ' Start Date = ' || p_hier_record.start_date

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

529:
530: WHEN OTHERS THEN
531: ROLLBACK TO Imp_Dim_Hierarchy ;
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533: cn_message_pkg.set_error(l_api_name,'Unexpected error');
534: l_error_code := SQLCODE;
535: l_message := SUBSTR (SQLERRM , 1 , 2000);
536: x_error_msg := l_message;
537: seterr_imp_hierarchy

Line 544: cn_message_pkg.write

540: p_error_code => l_error_code,
541: p_error_msg => l_message,
542: x_failed_row => x_failed_row,
543: x_processed_row => x_processed_row);
544: cn_message_pkg.write
545: (p_message_text => l_message ,
546: p_message_type => 'ERROR');
547: cn_message_pkg.write
548: (p_message_text =>

Line 547: cn_message_pkg.write

543: x_processed_row => x_processed_row);
544: cn_message_pkg.write
545: (p_message_text => l_message ,
546: p_message_type => 'ERROR');
547: cn_message_pkg.write
548: (p_message_text =>
549: ' All record with hierarchy type = ' || p_hier_record.hierarchy_type
550: || ' and Hierarchy name = ' || p_hier_record.hierarchy_name
551: || ' Start Date = ' || p_hier_record.start_date

Line 625: cn_message_pkg.debug('Start Import Hier Node.');

621: BEGIN
622: -- Initialize API return status to success
623: x_return_status := FND_API.G_RET_STS_SUCCESS;
624:
625: cn_message_pkg.debug('Start Import Hier Node.');
626:
627: FOR l_hierarchy_node_csr IN
628: c_hierarchy_node_csr
629: (p_hier_record.hierarchy_type,p_hier_record.BASE_TABLE_NAME,

Line 639: cn_message_pkg.debug

635: l_parent_ext_id := NULL;
636: l_external_id := NULL;
637: l_value_id := NULL;
638:
639: cn_message_pkg.debug
640: ('-- Importing Parent = ' || l_hierarchy_node_csr.parent_node_name
641: || ' ; Child = ' || l_hierarchy_node_csr.node_name);
642:
643: IF l_hierarchy_node_csr.parent_node_name IS NOT NULL THEN

Line 675: cn_message_pkg.debug

671: l_error_code := 'CN_HIER_NF_PARENT_NODE';
672: RAISE FND_API.g_exc_error;
673: END;
674: END IF;
675: cn_message_pkg.debug
676: ('---- Parent node ID = ' || l_parent_value_id ||
677: ' ; Child node = ' || l_hierarchy_node_csr.node_name);
678: -- Get external id of Node, skip default base node .
679: -- create edge if not exist

Line 681: cn_message_pkg.debug

677: ' ; Child node = ' || l_hierarchy_node_csr.node_name);
678: -- Get external id of Node, skip default base node .
679: -- create edge if not exist
680: IF l_hierarchy_node_csr.node_name <> p_def_base_name THEN
681: cn_message_pkg.debug
682: ('---- SELECT ' || p_hier_record.primary_key ||
683: ' FROM ' || p_hier_record.base_table_name ||
684: ' WHERE ' || p_hier_record.hierarchy_value ||
685: ' = ''' || l_hierarchy_node_csr.node_name ||'''');

Line 695: cn_message_pkg.debug('Node ID = ' || l_external_id);

691: LOOP
692: FETCH node_csr INTO l_external_id;
693: EXIT WHEN node_csr%notfound;
694:
695: cn_message_pkg.debug('Node ID = ' || l_external_id);
696:
697: END LOOP;
698: IF node_csr%rowcount = 0 THEN
699: l_message :=

Line 747: cn_message_pkg.debug('---- new edge created ');

743: fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_FIRST);
744: END IF;
745: RAISE FND_API.g_exc_error;
746: END IF;
747: cn_message_pkg.debug('---- new edge created ');
748: -- Create success
749: COMMIT;
750: END;
751: END IF;

Line 777: cn_message_pkg.write

773: (p_imp_header_id => p_imp_header_id,
774: p_status_code => 'IMPORT_FAIL',
775: p_failed_row => x_failed_row,
776: p_processed_row => x_processed_row);
777: cn_message_pkg.write
778: (p_message_text => 'Record ' ||
779: l_hierarchy_node_csr.record_num || ':' || l_message,
780: p_message_type => 'ERROR');
781: CN_IMPORT_PVT.write_error_rec

Line 803: cn_message_pkg.write

799: (p_imp_header_id => p_imp_header_id,
800: p_status_code => 'IMPORT_FAIL',
801: p_failed_row => x_failed_row,
802: p_processed_row => x_processed_row);
803: cn_message_pkg.write
804: (p_message_text => 'Record ' ||
805: l_hierarchy_node_csr.record_num || ':' || l_message,
806: p_message_type => 'ERROR');
807: CN_IMPORT_PVT.write_error_rec

Line 818: cn_message_pkg.debug('End Import Hier Node. ');

814: END LOOP; -- end c_hierarchy_node_csr loop
815:
816: x_error_msg := l_message;
817:
818: cn_message_pkg.debug('End Import Hier Node. ');
819:
820: END Imp_Hierarchy_Node;
821:
822: -- Start of comments

Line 959: cn_message_pkg.begin_batch

955:
956: l_hier_record.imp_header_id := p_imp_header_id;
957:
958: -- open process audit batch
959: cn_message_pkg.begin_batch
960: ( x_process_type => l_imp_header.import_type_code,
961: x_parent_proc_audit_id => p_imp_header_id ,
962: x_process_audit_id => l_process_audit_id,
963: x_request_id => null,

Line 966: cn_message_pkg.write

962: x_process_audit_id => l_process_audit_id,
963: x_request_id => null,
964: p_org_id => p_org_id);
965:
966: cn_message_pkg.write
967: (p_message_text => 'HIERARCHY: Start Transfer Data. imp_header_id = '
968: || To_char(p_imp_header_id),
969: p_message_type => 'MILESTONE');
970:

Line 993: cn_message_pkg.write

989: CN_IMPORT_PVT.update_imp_headers
990: (p_imp_header_id => p_imp_header_id,
991: p_status_code => 'IMPORT_FAIL',
992: p_failed_row => l_failed_row);
993: cn_message_pkg.write
994: (p_message_text => 'Record ' ||
995: To_char(l_miss_required_csr.record_num) || ':' || l_message,
996: p_message_type => 'ERROR');
997: CN_IMPORT_PVT.write_error_rec

Line 1023: cn_message_pkg.write

1019: CN_IMPORT_PVT.update_imp_headers
1020: (p_imp_header_id => p_imp_header_id,
1021: p_status_code => 'IMPORT_FAIL',
1022: p_failed_row => l_failed_row);
1023: cn_message_pkg.write
1024: (p_message_text => 'Record ' ||
1025: To_char(l_err_dflt_node_csr.record_num) || ':' || l_message,
1026: p_message_type => 'ERROR');
1027: CN_IMPORT_PVT.write_error_rec

Line 1060: cn_message_pkg.write

1056: p_error_msg => l_message,
1057: x_failed_row => l_failed_row,
1058: x_processed_row => l_processed_row);
1059:
1060: cn_message_pkg.write
1061: (p_message_text => l_message ,
1062: p_message_type => 'ERROR');
1063: cn_message_pkg.write
1064: (p_message_text =>

Line 1063: cn_message_pkg.write

1059:
1060: cn_message_pkg.write
1061: (p_message_text => l_message ,
1062: p_message_type => 'ERROR');
1063: cn_message_pkg.write
1064: (p_message_text =>
1065: ' All record with base table = ' ||
1066: l_hier_record.base_table_name ||
1067: ' are treated as failed records.' ,

Line 1188: cn_message_pkg.write

1184: p_error_msg => l_message,
1185: x_failed_row => l_failed_row,
1186: x_processed_row => l_processed_row);
1187:
1188: cn_message_pkg.write
1189: (p_message_text => l_message ,
1190: p_message_type => 'ERROR');
1191: cn_message_pkg.write
1192: (p_message_text =>

Line 1191: cn_message_pkg.write

1187:
1188: cn_message_pkg.write
1189: (p_message_text => l_message ,
1190: p_message_type => 'ERROR');
1191: cn_message_pkg.write
1192: (p_message_text =>
1193: ' All record with hierarchy type = '
1194: ||l_hier_record.hierarchy_type
1195: || ' and Hierarchy name = ' || l_hier_record.hierarchy_name

Line 1205: cn_message_pkg.debug('Def base node = ' || l_def_base_name);

1201: errbuf := l_message;
1202: GOTO end_dim_hier_loop;
1203: END IF;
1204:
1205: cn_message_pkg.debug('Def base node = ' || l_def_base_name);
1206:
1207: EXCEPTION
1208: WHEN no_data_found THEN
1209: -- get default name from DB

Line 1227: cn_message_pkg.write

1223: p_error_msg => l_message,
1224: x_failed_row => l_failed_row,
1225: x_processed_row => l_processed_row);
1226:
1227: cn_message_pkg.write
1228: (p_message_text => l_message ,
1229: p_message_type => 'ERROR');
1230: cn_message_pkg.write
1231: (p_message_text =>

Line 1230: cn_message_pkg.write

1226:
1227: cn_message_pkg.write
1228: (p_message_text => l_message ,
1229: p_message_type => 'ERROR');
1230: cn_message_pkg.write
1231: (p_message_text =>
1232: ' All record with hierarchy type = '
1233: ||l_hier_record.hierarchy_type
1234: || ' and Hierarchy name = ' || l_hier_record.hierarchy_name

Line 1287: cn_message_pkg.write

1283: p_status_code => 'COMPLETE',
1284: p_processed_row => l_processed_row,
1285: p_failed_row => l_failed_row);
1286: END IF;
1287: cn_message_pkg.write
1288: (p_message_text => 'HIERARCHY: End Transfer Data. imp_header_id = ' ||
1289: To_char(p_imp_header_id),
1290: p_message_type => 'MILESTONE');
1291:

Line 1293: cn_message_pkg.end_batch(l_process_audit_id);

1289: To_char(p_imp_header_id),
1290: p_message_type => 'MILESTONE');
1291:
1292: -- close process batch
1293: cn_message_pkg.end_batch(l_process_audit_id);
1294:
1295: -- Commit all imports
1296: COMMIT;
1297:

Line 1301: cn_message_pkg.end_batch(l_process_audit_id);

1297:
1298: EXCEPTION
1299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1300: retcode := 2 ;
1301: cn_message_pkg.end_batch(l_process_audit_id);
1302: FND_MSG_PUB.count_and_get
1303: (p_count => l_msg_count ,
1304: p_data => errbuf ,
1305: p_encoded => FND_API.G_FALSE

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

1321: p_data => errbuf ,
1322: p_encoded => FND_API.G_FALSE
1323: );
1324: END IF;
1325: cn_message_pkg.set_error(l_api_name,errbuf);
1326: cn_message_pkg.end_batch(l_process_audit_id);
1327:
1328: END Hierarchy_Import;
1329:

Line 1326: cn_message_pkg.end_batch(l_process_audit_id);

1322: p_encoded => FND_API.G_FALSE
1323: );
1324: END IF;
1325: cn_message_pkg.set_error(l_api_name,errbuf);
1326: cn_message_pkg.end_batch(l_process_audit_id);
1327:
1328: END Hierarchy_Import;
1329:
1330: END CN_IMP_HIERARCHY_PVT;