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 681: cn_message_pkg.debug

677: l_parent_value_id := 0;
678: -- End bug fix 6732446
679:
680: END IF;
681: cn_message_pkg.debug
682: ('---- Parent node ID = ' || l_parent_value_id ||
683: ' ; Child node = ' || l_hierarchy_node_csr.node_name);
684: -- Get external id of Node, skip default base node .
685: -- create edge if not exist

Line 687: cn_message_pkg.debug

683: ' ; Child node = ' || l_hierarchy_node_csr.node_name);
684: -- Get external id of Node, skip default base node .
685: -- create edge if not exist
686: IF l_hierarchy_node_csr.node_name <> p_def_base_name THEN
687: cn_message_pkg.debug
688: ('---- SELECT ' || p_hier_record.primary_key ||
689: ' FROM ' || p_hier_record.base_table_name ||
690: ' WHERE ' || p_hier_record.hierarchy_value ||
691: ' = ''' || l_hierarchy_node_csr.node_name ||'''');

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

697: LOOP
698: FETCH node_csr INTO l_external_id;
699: EXIT WHEN node_csr%notfound;
700:
701: cn_message_pkg.debug('Node ID = ' || l_external_id);
702:
703: END LOOP;
704: IF node_csr%rowcount = 0 THEN
705: l_message :=

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

749: fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_FIRST);
750: END IF;
751: RAISE FND_API.g_exc_error;
752: END IF;
753: cn_message_pkg.debug('---- new edge created ');
754: -- Create success
755: COMMIT;
756: END;
757: END IF;

Line 783: cn_message_pkg.write

779: (p_imp_header_id => p_imp_header_id,
780: p_status_code => 'IMPORT_FAIL',
781: p_failed_row => x_failed_row,
782: p_processed_row => x_processed_row);
783: cn_message_pkg.write
784: (p_message_text => 'Record ' ||
785: l_hierarchy_node_csr.record_num || ':' || l_message,
786: p_message_type => 'ERROR');
787: CN_IMPORT_PVT.write_error_rec

Line 809: cn_message_pkg.write

805: (p_imp_header_id => p_imp_header_id,
806: p_status_code => 'IMPORT_FAIL',
807: p_failed_row => x_failed_row,
808: p_processed_row => x_processed_row);
809: cn_message_pkg.write
810: (p_message_text => 'Record ' ||
811: l_hierarchy_node_csr.record_num || ':' || l_message,
812: p_message_type => 'ERROR');
813: CN_IMPORT_PVT.write_error_rec

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

820: END LOOP; -- end c_hierarchy_node_csr loop
821:
822: x_error_msg := l_message;
823:
824: cn_message_pkg.debug('End Import Hier Node. ');
825:
826: END Imp_Hierarchy_Node;
827:
828: -- Start of comments

Line 965: cn_message_pkg.begin_batch

961:
962: l_hier_record.imp_header_id := p_imp_header_id;
963:
964: -- open process audit batch
965: cn_message_pkg.begin_batch
966: ( x_process_type => l_imp_header.import_type_code,
967: x_parent_proc_audit_id => p_imp_header_id ,
968: x_process_audit_id => l_process_audit_id,
969: x_request_id => null,

Line 972: cn_message_pkg.write

968: x_process_audit_id => l_process_audit_id,
969: x_request_id => null,
970: p_org_id => p_org_id);
971:
972: cn_message_pkg.write
973: (p_message_text => 'HIERARCHY: Start Transfer Data. imp_header_id = '
974: || To_char(p_imp_header_id),
975: p_message_type => 'MILESTONE');
976:

Line 999: cn_message_pkg.write

995: CN_IMPORT_PVT.update_imp_headers
996: (p_imp_header_id => p_imp_header_id,
997: p_status_code => 'IMPORT_FAIL',
998: p_failed_row => l_failed_row);
999: cn_message_pkg.write
1000: (p_message_text => 'Record ' ||
1001: To_char(l_miss_required_csr.record_num) || ':' || l_message,
1002: p_message_type => 'ERROR');
1003: CN_IMPORT_PVT.write_error_rec

Line 1029: cn_message_pkg.write

1025: CN_IMPORT_PVT.update_imp_headers
1026: (p_imp_header_id => p_imp_header_id,
1027: p_status_code => 'IMPORT_FAIL',
1028: p_failed_row => l_failed_row);
1029: cn_message_pkg.write
1030: (p_message_text => 'Record ' ||
1031: To_char(l_err_dflt_node_csr.record_num) || ':' || l_message,
1032: p_message_type => 'ERROR');
1033: CN_IMPORT_PVT.write_error_rec

Line 1066: cn_message_pkg.write

1062: p_error_msg => l_message,
1063: x_failed_row => l_failed_row,
1064: x_processed_row => l_processed_row);
1065:
1066: cn_message_pkg.write
1067: (p_message_text => l_message ,
1068: p_message_type => 'ERROR');
1069: cn_message_pkg.write
1070: (p_message_text =>

Line 1069: cn_message_pkg.write

1065:
1066: cn_message_pkg.write
1067: (p_message_text => l_message ,
1068: p_message_type => 'ERROR');
1069: cn_message_pkg.write
1070: (p_message_text =>
1071: ' All record with base table = ' ||
1072: l_hier_record.base_table_name ||
1073: ' are treated as failed records.' ,

Line 1194: cn_message_pkg.write

1190: p_error_msg => l_message,
1191: x_failed_row => l_failed_row,
1192: x_processed_row => l_processed_row);
1193:
1194: cn_message_pkg.write
1195: (p_message_text => l_message ,
1196: p_message_type => 'ERROR');
1197: cn_message_pkg.write
1198: (p_message_text =>

Line 1197: cn_message_pkg.write

1193:
1194: cn_message_pkg.write
1195: (p_message_text => l_message ,
1196: p_message_type => 'ERROR');
1197: cn_message_pkg.write
1198: (p_message_text =>
1199: ' All record with hierarchy type = '
1200: ||l_hier_record.hierarchy_type
1201: || ' and Hierarchy name = ' || l_hier_record.hierarchy_name

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

1207: errbuf := l_message;
1208: GOTO end_dim_hier_loop;
1209: END IF;
1210:
1211: cn_message_pkg.debug('Def base node = ' || l_def_base_name);
1212:
1213: EXCEPTION
1214: WHEN no_data_found THEN
1215: -- get default name from DB

Line 1233: cn_message_pkg.write

1229: p_error_msg => l_message,
1230: x_failed_row => l_failed_row,
1231: x_processed_row => l_processed_row);
1232:
1233: cn_message_pkg.write
1234: (p_message_text => l_message ,
1235: p_message_type => 'ERROR');
1236: cn_message_pkg.write
1237: (p_message_text =>

Line 1236: cn_message_pkg.write

1232:
1233: cn_message_pkg.write
1234: (p_message_text => l_message ,
1235: p_message_type => 'ERROR');
1236: cn_message_pkg.write
1237: (p_message_text =>
1238: ' All record with hierarchy type = '
1239: ||l_hier_record.hierarchy_type
1240: || ' and Hierarchy name = ' || l_hier_record.hierarchy_name

Line 1293: cn_message_pkg.write

1289: p_status_code => 'COMPLETE',
1290: p_processed_row => l_processed_row,
1291: p_failed_row => l_failed_row);
1292: END IF;
1293: cn_message_pkg.write
1294: (p_message_text => 'HIERARCHY: End Transfer Data. imp_header_id = ' ||
1295: To_char(p_imp_header_id),
1296: p_message_type => 'MILESTONE');
1297:

Line 1299: cn_message_pkg.end_batch(l_process_audit_id);

1295: To_char(p_imp_header_id),
1296: p_message_type => 'MILESTONE');
1297:
1298: -- close process batch
1299: cn_message_pkg.end_batch(l_process_audit_id);
1300:
1301: -- Commit all imports
1302: COMMIT;
1303:

Line 1307: cn_message_pkg.end_batch(l_process_audit_id);

1303:
1304: EXCEPTION
1305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1306: retcode := 2 ;
1307: cn_message_pkg.end_batch(l_process_audit_id);
1308: FND_MSG_PUB.count_and_get
1309: (p_count => l_msg_count ,
1310: p_data => errbuf ,
1311: p_encoded => FND_API.G_FALSE

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

1327: p_data => errbuf ,
1328: p_encoded => FND_API.G_FALSE
1329: );
1330: END IF;
1331: cn_message_pkg.set_error(l_api_name,errbuf);
1332: cn_message_pkg.end_batch(l_process_audit_id);
1333:
1334: END Hierarchy_Import;
1335:

Line 1332: cn_message_pkg.end_batch(l_process_audit_id);

1328: p_encoded => FND_API.G_FALSE
1329: );
1330: END IF;
1331: cn_message_pkg.set_error(l_api_name,errbuf);
1332: cn_message_pkg.end_batch(l_process_audit_id);
1333:
1334: END Hierarchy_Import;
1335:
1336: END CN_IMP_HIERARCHY_PVT;