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 FND_API

Line 31: Decode(p_hier_record.start_date,FND_API.G_MISS_CHAR,start_date,

27: SET status_code = p_status_code, error_code = p_error_code,
28: error_msg = p_error_msg
29: WHERE
30: (start_date =
31: Decode(p_hier_record.start_date,FND_API.G_MISS_CHAR,start_date,
32: p_hier_record.start_date)
33: )
34: AND
35: (Nvl(end_date,FND_API.g_miss_char) =

Line 35: (Nvl(end_date,FND_API.g_miss_char) =

31: Decode(p_hier_record.start_date,FND_API.G_MISS_CHAR,start_date,
32: p_hier_record.start_date)
33: )
34: AND
35: (Nvl(end_date,FND_API.g_miss_char) =
36: Decode(p_hier_record.end_date,
37: FND_API.G_MISS_CHAR,Nvl(end_date,FND_API.g_miss_char) ,
38: NULL,FND_API.g_miss_char,
39: p_hier_record.end_date)

Line 37: FND_API.G_MISS_CHAR,Nvl(end_date,FND_API.g_miss_char) ,

33: )
34: AND
35: (Nvl(end_date,FND_API.g_miss_char) =
36: Decode(p_hier_record.end_date,
37: FND_API.G_MISS_CHAR,Nvl(end_date,FND_API.g_miss_char) ,
38: NULL,FND_API.g_miss_char,
39: p_hier_record.end_date)
40: )
41: AND

Line 38: NULL,FND_API.g_miss_char,

34: AND
35: (Nvl(end_date,FND_API.g_miss_char) =
36: Decode(p_hier_record.end_date,
37: FND_API.G_MISS_CHAR,Nvl(end_date,FND_API.g_miss_char) ,
38: NULL,FND_API.g_miss_char,
39: p_hier_record.end_date)
40: )
41: AND
42: (hierarchy_name =

Line 43: Decode(p_hier_record.hierarchy_name,FND_API.G_MISS_CHAR,hierarchy_name,

39: p_hier_record.end_date)
40: )
41: AND
42: (hierarchy_name =
43: Decode(p_hier_record.hierarchy_name,FND_API.G_MISS_CHAR,hierarchy_name,
44: p_hier_record.hierarchy_name)
45: )
46: AND
47: (Upper(hierarchy_value) =

Line 48: Decode(p_hier_record.hierarchy_value,FND_API.G_MISS_CHAR,

44: p_hier_record.hierarchy_name)
45: )
46: AND
47: (Upper(hierarchy_value) =
48: Decode(p_hier_record.hierarchy_value,FND_API.G_MISS_CHAR,
49: Upper(hierarchy_value),p_hier_record.hierarchy_value)
50: )
51: AND
52: (Upper(primary_key) =

Line 53: Decode(p_hier_record.primary_key,FND_API.G_MISS_CHAR,Upper(primary_key),

49: Upper(hierarchy_value),p_hier_record.hierarchy_value)
50: )
51: AND
52: (Upper(primary_key) =
53: Decode(p_hier_record.primary_key,FND_API.G_MISS_CHAR,Upper(primary_key),
54: p_hier_record.primary_key)
55: )
56: AND
57: (Upper(base_table_name) =

Line 58: Decode(p_hier_record.base_table_name,FND_API.G_MISS_CHAR,

54: p_hier_record.primary_key)
55: )
56: AND
57: (Upper(base_table_name) =
58: Decode(p_hier_record.base_table_name,FND_API.G_MISS_CHAR,
59: Upper(base_table_name),p_hier_record.base_table_name)
60: )
61: AND
62: (hierarchy_type=

Line 63: Decode(p_hier_record.hierarchy_type,FND_API.G_MISS_CHAR,hierarchy_type,

59: Upper(base_table_name),p_hier_record.base_table_name)
60: )
61: AND
62: (hierarchy_type=
63: Decode(p_hier_record.hierarchy_type,FND_API.G_MISS_CHAR,hierarchy_type,
64: p_hier_record.hierarchy_type)
65: )
66: AND
67: (imp_line_id =

Line 68: Decode(p_hier_record.imp_line_id,FND_API.G_MISS_NUM,imp_line_id,

64: p_hier_record.hierarchy_type)
65: )
66: AND
67: (imp_line_id =
68: Decode(p_hier_record.imp_line_id,FND_API.G_MISS_NUM,imp_line_id,
69: p_hier_record.imp_line_id)
70: )
71: AND (imp_header_id = p_hier_record.imp_header_id)
72: AND status_code = 'STAGE'

Line 121: x_return_status := FND_API.G_RET_STS_SUCCESS;

117: BEGIN
118: -- Standard Start of API savepoint
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:

Line 144: p_hier_record.base_table_name := fnd_api.G_MISS_CHAR ;

140: -- the same hierarchy type within this import
141: WHEN TOO_MANY_ROWS THEN
142: l_message := fnd_message.get_string('CN','CN_HIER_MULTI_BTBL');
143: l_error_code := 'CN_HIER_MULTI_BTBL';
144: p_hier_record.base_table_name := fnd_api.G_MISS_CHAR ;
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;

Line 145: p_hier_record.primary_key := fnd_api.G_MISS_CHAR ;

141: WHEN TOO_MANY_ROWS THEN
142: l_message := fnd_message.get_string('CN','CN_HIER_MULTI_BTBL');
143: l_error_code := 'CN_HIER_MULTI_BTBL';
144: p_hier_record.base_table_name := fnd_api.G_MISS_CHAR ;
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);

Line 146: p_hier_record.hierarchy_value := fnd_api.G_MISS_CHAR ;

142: l_message := fnd_message.get_string('CN','CN_HIER_MULTI_BTBL');
143: l_error_code := 'CN_HIER_MULTI_BTBL';
144: p_hier_record.base_table_name := fnd_api.G_MISS_CHAR ;
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:

Line 147: RAISE FND_API.g_exc_error;

143: l_error_code := 'CN_HIER_MULTI_BTBL';
144: p_hier_record.base_table_name := fnd_api.G_MISS_CHAR ;
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

Line 161: RAISE FND_API.g_exc_error;

157: -- base table not exist in cn_obj_tables_v
158: WHEN NO_DATA_FOUND THEN
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

Line 176: RAISE FND_API.g_exc_error;

172: -- primary_key not exist
173: WHEN NO_DATA_FOUND THEN
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

Line 192: RAISE FND_API.g_exc_error;

188: -- hierarchy_value not exist
189: WHEN NO_DATA_FOUND THEN
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

Line 214: RAISE FND_API.g_exc_error;

210: EXCEPTION
211: WHEN no_data_found THEN
212: l_message := fnd_message.get_string('CN','CN_HIER_DUP_BTBL');
213: l_error_code := 'CN_HIER_DUP_BTBL';
214: RAISE FND_API.g_exc_error;
215: END;
216:
217: cn_dim_hierarchies_pvt.Create_Hierarchy_Type
218: (p_api_version => 1.0,

Line 219: p_init_msg_list => FND_API.G_TRUE,

215: END;
216:
217: cn_dim_hierarchies_pvt.Create_Hierarchy_Type
218: (p_api_version => 1.0,
219: p_init_msg_list => FND_API.G_TRUE,
220: p_name => p_hier_record.hierarchy_type,
221: p_base_table_id => x_base_table_id,
222: p_primary_key_id => x_primary_key_id,
223: p_user_column_id => x_hier_value_id,

Line 230: IF x_return_status <> FND_API.g_ret_sts_success THEN

226: x_return_status => x_return_status,
227: x_msg_count => l_msg_count,
228: x_msg_data => l_message,
229: x_dimension_id => x_dimension_id);
230: IF x_return_status <> FND_API.g_ret_sts_success THEN
231: l_error_code := 'CN_HIER_FAIL_CREATE';
232: IF l_msg_count > 1 THEN
233: l_message :=
234: fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_FIRST);

Line 236: RAISE FND_API.g_exc_error;

232: IF l_msg_count > 1 THEN
233: l_message :=
234: fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_FIRST);
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:

Line 259: RAISE FND_API.g_exc_error;

255: EXCEPTION
256: WHEN no_data_found THEN
257: l_message := fnd_message.get_string('CN','CN_HIER_NOTMATCH');
258: l_error_code := 'CN_HIER_NOTMATCH';
259: RAISE FND_API.g_exc_error;
260: END;
261:
262: x_error_msg := l_message;
263:

Line 269: WHEN FND_API.G_EXC_ERROR THEN

265: ('End Import Hierarchy Type : ' || p_hier_record.hierarchy_type ||
266: ' dimension_id = ' || x_dimension_id );
267:
268: EXCEPTION
269: WHEN FND_API.G_EXC_ERROR THEN
270: ROLLBACK TO Imp_Hierarchy_Type ;
271: x_return_status := FND_API.G_RET_STS_ERROR ;
272: x_error_msg := l_message;
273: seterr_imp_hierarchy

Line 271: x_return_status := FND_API.G_RET_STS_ERROR ;

267:
268: EXCEPTION
269: WHEN FND_API.G_EXC_ERROR THEN
270: ROLLBACK TO Imp_Hierarchy_Type ;
271: x_return_status := FND_API.G_RET_STS_ERROR ;
272: x_error_msg := l_message;
273: seterr_imp_hierarchy
274: (p_hier_record => p_hier_record,
275: p_status_code => 'FAIL',

Line 294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

290: p_message_type => '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;

Line 346: x_return_status := FND_API.G_RET_STS_SUCCESS;

342: BEGIN
343: -- Standard Start of API savepoint
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

Line 362: p_init_msg_list => FND_API.G_TRUE,

358: EXCEPTION
359: WHEN no_data_found THEN
360: cn_dim_hierarchies_pvt.Create_Head_Hierarchy
361: (p_api_version => 1.0,
362: p_init_msg_list => FND_API.G_TRUE,
363: p_name => p_hier_record.hierarchy_name,
364: p_dimension_id => p_dimension_id,
365: p_org_id => p_org_id,
366: x_return_status => x_return_status,

Line 370: IF x_return_status <> FND_API.g_ret_sts_success THEN

366: x_return_status => x_return_status,
367: x_msg_count => l_msg_count,
368: x_msg_data => l_message,
369: x_head_hierarchy_id => x_head_hierarchy_id);
370: IF x_return_status <> FND_API.g_ret_sts_success THEN
371: l_error_code := 'CN_HIER_FAIL_CREATE';
372: IF l_msg_count > 1 THEN
373: l_message :=
374: fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_FIRST);

Line 376: RAISE FND_API.g_exc_error;

372: IF l_msg_count > 1 THEN
373: l_message :=
374: fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_FIRST);
375: END IF;
376: RAISE FND_API.g_exc_error;
377: END IF;
378: END;
379:
380: x_error_msg := l_message;

Line 387: WHEN FND_API.G_EXC_ERROR THEN

383: ('End Import Head Hierarchy : ' || p_hier_record.hierarchy_name ||
384: ' head_hierarchy_id = ' || x_head_hierarchy_id );
385:
386: EXCEPTION
387: WHEN FND_API.G_EXC_ERROR THEN
388: ROLLBACK TO Imp_Head_Hierarchy ;
389: x_return_status := FND_API.G_RET_STS_ERROR ;
390: x_error_msg := l_message;
391: seterr_imp_hierarchy

Line 389: x_return_status := FND_API.G_RET_STS_ERROR ;

385:
386: EXCEPTION
387: WHEN FND_API.G_EXC_ERROR THEN
388: ROLLBACK TO Imp_Head_Hierarchy ;
389: x_return_status := FND_API.G_RET_STS_ERROR ;
390: x_error_msg := l_message;
391: seterr_imp_hierarchy
392: (p_hier_record => p_hier_record,
393: p_status_code => 'FAIL',

Line 410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

406: p_message_type => '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;

Line 460: x_return_status := FND_API.G_RET_STS_SUCCESS;

456: BEGIN
457: -- Standard Start of API savepoint
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);

Line 472: AND Nvl(end_date,FND_API.g_miss_date) =

468: FROM cn_dim_hierarchies
469: WHERE header_dim_hierarchy_id = p_head_hierarchy_id
470: AND org_id = p_org_id
471: AND start_date = To_date(p_hier_record.start_date, 'DD/MM/YYYY')
472: AND Nvl(end_date,FND_API.g_miss_date) =
473: Nvl(To_date(p_hier_record.end_date, 'DD/MM/YYYY'),FND_API.g_miss_date)
474: ;
475:
476: EXCEPTION

Line 473: Nvl(To_date(p_hier_record.end_date, 'DD/MM/YYYY'),FND_API.g_miss_date)

469: WHERE header_dim_hierarchy_id = p_head_hierarchy_id
470: AND org_id = p_org_id
471: AND start_date = To_date(p_hier_record.start_date, 'DD/MM/YYYY')
472: AND Nvl(end_date,FND_API.g_miss_date) =
473: Nvl(To_date(p_hier_record.end_date, 'DD/MM/YYYY'),FND_API.g_miss_date)
474: ;
475:
476: EXCEPTION
477: WHEN no_data_found THEN

Line 480: p_init_msg_list => FND_API.G_TRUE,

476: EXCEPTION
477: WHEN no_data_found THEN
478: cn_dim_hierarchies_pvt.Create_Dim_Hierarchy
479: (p_api_version => 1.0,
480: p_init_msg_list => FND_API.G_TRUE,
481: p_head_hierarchy_id => p_head_hierarchy_id,
482: p_start_date => To_date(p_hier_record.start_date, 'DD/MM/YYYY'),
483: p_end_date => To_date(p_hier_record.end_date, 'DD/MM/YYYY'),
484: p_root_node => NULL,

Line 490: IF x_return_status <> FND_API.g_ret_sts_success THEN

486: x_return_status => x_return_status,
487: x_msg_count => l_msg_count,
488: x_msg_data => l_message,
489: x_dim_hierarchy_id => x_dim_hierarchy_id);
490: IF x_return_status <> FND_API.g_ret_sts_success THEN
491: l_error_code := 'CN_HIER_FAIL_CREATE';
492: IF l_msg_count > 1 THEN
493: l_message :=
494: fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_FIRST);

Line 496: RAISE FND_API.g_exc_error;

492: IF l_msg_count > 1 THEN
493: l_message :=
494: fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_FIRST);
495: END IF;
496: RAISE FND_API.g_exc_error;
497: END IF;
498: END;
499:
500: x_error_msg := l_message;

Line 507: WHEN FND_API.G_EXC_ERROR THEN

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
507: WHEN FND_API.G_EXC_ERROR THEN
508: ROLLBACK TO Imp_Dim_Hierarchy ;
509: x_return_status := FND_API.G_RET_STS_ERROR ;
510: x_error_msg := l_message;
511: seterr_imp_hierarchy

Line 509: x_return_status := FND_API.G_RET_STS_ERROR ;

505:
506: EXCEPTION
507: WHEN FND_API.G_EXC_ERROR THEN
508: ROLLBACK TO Imp_Dim_Hierarchy ;
509: x_return_status := FND_API.G_RET_STS_ERROR ;
510: x_error_msg := l_message;
511: seterr_imp_hierarchy
512: (p_hier_record => p_hier_record,
513: p_status_code => 'FAIL',

Line 532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

528: p_message_type => '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;

Line 609: AND Nvl(end_date,FND_API.g_miss_char) =

605: AND hierarchy_type = l_hier_type
606: AND BASE_TABLE_NAME = l_base_tbl
607: AND hierarchy_name = l_hier_name
608: AND start_date = l_start_date
609: AND Nvl(end_date,FND_API.g_miss_char) =
610: Nvl(l_end_date,FND_API.g_miss_char)
611: ORDER BY level_num
612: ;
613:

Line 610: Nvl(l_end_date,FND_API.g_miss_char)

606: AND BASE_TABLE_NAME = l_base_tbl
607: AND hierarchy_name = l_hier_name
608: AND start_date = l_start_date
609: AND Nvl(end_date,FND_API.g_miss_char) =
610: Nvl(l_end_date,FND_API.g_miss_char)
611: ORDER BY level_num
612: ;
613:
614: TYPE refcurtype IS ref CURSOR;

Line 623: x_return_status := FND_API.G_RET_STS_SUCCESS;

619: l_value_id cn_hierarchy_nodes.value_id%TYPE ;
620:
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

Line 648: RAISE FND_API.g_exc_error;

644: -- parent_node_name must be null for default Base Node
645: IF l_hierarchy_node_csr.default_node_flag = 'Y' THEN
646: l_message := fnd_message.get_string('CN','CN_HIER_NN_DFLTNODE');
647: l_error_code := 'CN_HIER_NN_DFLTNODE';
648: RAISE FND_API.g_exc_error;
649: END IF;
650:
651: -- Get value id of parent Node
652: BEGIN

Line 672: RAISE FND_API.g_exc_error;

668: -- parent_node not exist in cn_hierarchy_nodes
669: l_message :=
670: fnd_message.get_string('CN','CN_HIER_NF_PARENT_NODE');
671: l_error_code := 'CN_HIER_NF_PARENT_NODE';
672: RAISE FND_API.g_exc_error;
673: END;
674:
675: -- Bug fix 6732446
676: ELSE

Line 708: RAISE FND_API.g_exc_error;

704: IF node_csr%rowcount = 0 THEN
705: l_message :=
706: fnd_message.get_string('CN','CN_HIER_NF_NODE');
707: l_error_code := 'CN_HIER_NF_NODE';
708: RAISE FND_API.g_exc_error;
709: END IF;
710: CLOSE node_csr;
711:
712: -- Create hierarchy edge while not exist

Line 734: p_init_msg_list => FND_API.G_TRUE,

730: EXCEPTION
731: WHEN no_data_found THEN
732: cn_dim_hierarchies_pvt.Create_Edge
733: (p_api_version => 1.0,
734: p_init_msg_list => FND_API.G_TRUE,
735: p_dim_hierarchy_id => p_dim_hierarchy_id,
736: p_parent_value_id => l_parent_value_id,
737: p_name => l_hierarchy_node_csr.node_name,
738: p_external_id => l_external_id,

Line 745: IF x_return_status <> FND_API.g_ret_sts_success THEN

741: x_msg_count => l_msg_count,
742: x_msg_data => l_message,
743: x_value_id => l_value_id);
744:
745: IF x_return_status <> FND_API.g_ret_sts_success THEN
746: l_error_code := 'CN_HIER_FAIL_CREATE';
747: IF l_msg_count > 1 THEN
748: l_message :=
749: fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_FIRST);

Line 751: RAISE FND_API.g_exc_error;

747: IF l_msg_count > 1 THEN
748: l_message :=
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;

Line 768: WHEN FND_API.g_exc_error THEN

764:
765: x_processed_row := x_processed_row + 1;
766:
767: EXCEPTION
768: WHEN FND_API.g_exc_error THEN
769: x_failed_row := x_failed_row + 1;
770: x_processed_row := x_processed_row + 1;
771: x_return_status := FND_API.G_RET_STS_ERROR ;
772: x_error_msg := l_message;

Line 771: x_return_status := FND_API.G_RET_STS_ERROR ;

767: EXCEPTION
768: WHEN FND_API.g_exc_error THEN
769: x_failed_row := x_failed_row + 1;
770: x_processed_row := x_processed_row + 1;
771: x_return_status := FND_API.G_RET_STS_ERROR ;
772: x_error_msg := l_message;
773: CN_IMPORT_PVT.update_imp_lines
774: (p_imp_line_id => l_hierarchy_node_csr.imp_line_id,
775: p_status_code => 'FAIL',

Line 795: x_return_status := FND_API.G_RET_STS_ERROR ;

791: p_sql_stmt => p_sql_stmt);
792: WHEN OTHERS THEN
793: x_failed_row := x_failed_row + 1;
794: x_processed_row := x_processed_row + 1;
795: x_return_status := FND_API.G_RET_STS_ERROR ;
796: l_error_code := SQLCODE;
797: l_message := SUBSTR (SQLERRM , 1 , 2000);
798: x_error_msg := l_message;
799: CN_IMPORT_PVT.update_imp_lines

Line 950: l_return_status := FND_API.G_RET_STS_SUCCESS;

946:
947: BEGIN
948:
949: -- Initialize API return status to success
950: l_return_status := FND_API.G_RET_STS_SUCCESS;
951: retcode := 0 ;
952:
953: -- Get imp_header info
954: SELECT name, status_code,server_flag,imp_map_id, source_column_num,

Line 1106: IF l_return_status <> FND_API.g_ret_sts_success THEN

1102: x_failed_row => l_failed_row,
1103: x_processed_row => l_processed_row,
1104: p_org_id => p_org_id);
1105:
1106: IF l_return_status <> FND_API.g_ret_sts_success THEN
1107: retcode := 2;
1108: errbuf := l_message;
1109: GOTO end_hier_type_loop;
1110: END IF;

Line 1132: IF l_return_status <> FND_API.g_ret_sts_success THEN

1128: x_failed_row => l_failed_row,
1129: x_processed_row => l_processed_row,
1130: p_org_id => p_org_id);
1131:
1132: IF l_return_status <> FND_API.g_ret_sts_success THEN
1133: retcode := 2;
1134: errbuf := l_message;
1135: GOTO end_head_hier_loop;
1136: END IF;

Line 1158: IF l_return_status <> FND_API.g_ret_sts_success THEN

1154: x_failed_row => l_failed_row,
1155: x_processed_row => l_processed_row,
1156: p_org_id => p_org_id);
1157:
1158: IF l_return_status <> FND_API.g_ret_sts_success THEN
1159: retcode := 2;
1160: errbuf := l_message;
1161: GOTO end_dim_hier_loop;
1162: END IF;

Line 1177: AND Nvl(end_date,FND_API.g_miss_char) =

1173: AND status_code = l_stage_status
1174: AND hierarchy_type = l_hier_record.hierarchy_type
1175: AND hierarchy_name = l_hier_record.hierarchy_name
1176: AND start_date = l_hier_record.start_date
1177: AND Nvl(end_date,FND_API.g_miss_char) =
1178: Nvl(l_hier_record.end_date,FND_API.g_miss_char)
1179: AND default_node_flag = 'Y'
1180: ;
1181: -- parent_node_name must be null if default_node_flag = 'Y'

Line 1178: Nvl(l_hier_record.end_date,FND_API.g_miss_char)

1174: AND hierarchy_type = l_hier_record.hierarchy_type
1175: AND hierarchy_name = l_hier_record.hierarchy_name
1176: AND start_date = l_hier_record.start_date
1177: AND Nvl(end_date,FND_API.g_miss_char) =
1178: Nvl(l_hier_record.end_date,FND_API.g_miss_char)
1179: AND default_node_flag = 'Y'
1180: ;
1181: -- parent_node_name must be null if default_node_flag = 'Y'
1182: IF l_parent_node_name IS NOT NULL THEN

Line 1264: IF l_return_status <> FND_API.g_ret_sts_success THEN

1260: x_failed_row => l_failed_row,
1261: x_processed_row => l_processed_row,
1262: p_org_id => p_org_id);
1263:
1264: IF l_return_status <> FND_API.g_ret_sts_success THEN
1265: retcode := 2;
1266: errbuf := l_message;
1267: GOTO end_dim_hier_loop;
1268: END IF;

Line 1305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1301: -- Commit all imports
1302: COMMIT;
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 ,

Line 1311: p_encoded => FND_API.G_FALSE

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
1312: );
1313:
1314: WHEN OTHERS THEN
1315: err_num := SQLCODE;

Line 1328: p_encoded => FND_API.G_FALSE

1324: END IF;
1325: FND_MSG_PUB.count_and_get
1326: (p_count => l_msg_count ,
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);