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_COMP_PLAN_XMLCOPY_PVT dependencies on FND_API

Line 62: RAISE fnd_api.g_exc_unexpected_error;

58: WHERE exp_imp_request_id = p_exp_imp_request_id;
59:
60: -- Check if OrgId is not set
61: IF v_org_id IS NULL THEN
62: RAISE fnd_api.g_exc_unexpected_error;
63: END IF;
64:
65: -- Populating CLOB and XMLType Columns of cn_copy_requests_all
66: -- Plan Copy Import Request only populates the BLOB column.

Line 70: p_init_msg_list => FND_API.G_FALSE,

66: -- Plan Copy Import Request only populates the BLOB column.
67: -- Calling Common Utility Package for conversion to CLOB and XMLType
68: cn_plancopy_util_pvt.convert_blob_to_xmltype (
69: p_api_version => 1.0,
70: p_init_msg_list => FND_API.G_FALSE,
71: p_commit => FND_API.G_FALSE,
72: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
73: p_exp_imp_id => p_exp_imp_request_id,
74: x_return_status => x_return_status,

Line 71: p_commit => FND_API.G_FALSE,

67: -- Calling Common Utility Package for conversion to CLOB and XMLType
68: cn_plancopy_util_pvt.convert_blob_to_xmltype (
69: p_api_version => 1.0,
70: p_init_msg_list => FND_API.G_FALSE,
71: p_commit => FND_API.G_FALSE,
72: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
73: p_exp_imp_id => p_exp_imp_request_id,
74: x_return_status => x_return_status,
75: x_msg_count => x_msg_count,

Line 72: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

68: cn_plancopy_util_pvt.convert_blob_to_xmltype (
69: p_api_version => 1.0,
70: p_init_msg_list => FND_API.G_FALSE,
71: p_commit => FND_API.G_FALSE,
72: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
73: p_exp_imp_id => p_exp_imp_request_id,
74: x_return_status => x_return_status,
75: x_msg_count => x_msg_count,
76: x_msg_data => x_msg_data);

Line 77: IF x_return_status = fnd_api.g_ret_sts_success THEN

73: p_exp_imp_id => p_exp_imp_request_id,
74: x_return_status => x_return_status,
75: x_msg_count => x_msg_count,
76: x_msg_data => x_msg_data);
77: IF x_return_status = fnd_api.g_ret_sts_success THEN
78: COMMIT;
79: ELSE
80: RAISE fnd_api.g_exc_unexpected_error;
81: END IF;

Line 80: RAISE fnd_api.g_exc_unexpected_error;

76: x_msg_data => x_msg_data);
77: IF x_return_status = fnd_api.g_ret_sts_success THEN
78: COMMIT;
79: ELSE
80: RAISE fnd_api.g_exc_unexpected_error;
81: END IF;
82:
83: -- Fetching XML from XMLType.
84: OPEN oic_plan_copy;

Line 95: p_init_msg_list => FND_API.G_FALSE,

91: CLOSE oic_object_count;
92:
93: -- Parse XML
94: Parse_XML(p_api_version => 1.0,
95: p_init_msg_list => FND_API.G_FALSE,
96: p_commit => FND_API.G_FALSE,
97: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
98: p_xml => v_xml,
99: p_prefix => v_prefix,

Line 96: p_commit => FND_API.G_FALSE,

92:
93: -- Parse XML
94: Parse_XML(p_api_version => 1.0,
95: p_init_msg_list => FND_API.G_FALSE,
96: p_commit => FND_API.G_FALSE,
97: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
98: p_xml => v_xml,
99: p_prefix => v_prefix,
100: p_start_date => v_start_date,

Line 97: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

93: -- Parse XML
94: Parse_XML(p_api_version => 1.0,
95: p_init_msg_list => FND_API.G_FALSE,
96: p_commit => FND_API.G_FALSE,
97: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
98: p_xml => v_xml,
99: p_prefix => v_prefix,
100: p_start_date => v_start_date,
101: p_end_date => v_end_date,

Line 122: WHEN fnd_api.g_exc_unexpected_error THEN

118: COMMIT;
119: END IF;
120:
121: EXCEPTION
122: WHEN fnd_api.g_exc_unexpected_error THEN
123: ROLLBACK TO Import_PlanCopy;
124: retcode := 2;
125: errbuf := SQLCODE||' '||Sqlerrm;
126: UPDATE cn_copy_requests_all

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

148: -- updates cn_copy_requests table.
149: /***************************************************************************/
150: PROCEDURE Parse_XML
151: (p_api_version IN NUMBER := 1.0,
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155: p_xml IN cn_copy_requests_all.file_content_xmltype%TYPE,
156: p_prefix IN cn_copy_requests_all.prefix_info%TYPE,

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

149: /***************************************************************************/
150: PROCEDURE Parse_XML
151: (p_api_version IN NUMBER := 1.0,
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155: p_xml IN cn_copy_requests_all.file_content_xmltype%TYPE,
156: p_prefix IN cn_copy_requests_all.prefix_info%TYPE,
157: p_start_date IN DATE,

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

150: PROCEDURE Parse_XML
151: (p_api_version IN NUMBER := 1.0,
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155: p_xml IN cn_copy_requests_all.file_content_xmltype%TYPE,
156: p_prefix IN cn_copy_requests_all.prefix_info%TYPE,
157: p_start_date IN DATE,
158: p_end_date IN DATE,

Line 332: IF NOT fnd_api.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME )THEN

328: /**********************************************************************/
329: -- Standard Start of API savepoint
330: -- SAVEPOINT Parse_XML;
331: -- Standard call to check for call compatibility.
332: IF NOT fnd_api.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME )THEN
333: RAISE fnd_api.g_exc_unexpected_error;
334: END IF;
335:
336: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 333: RAISE fnd_api.g_exc_unexpected_error;

329: -- Standard Start of API savepoint
330: -- SAVEPOINT Parse_XML;
331: -- Standard call to check for call compatibility.
332: IF NOT fnd_api.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME )THEN
333: RAISE fnd_api.g_exc_unexpected_error;
334: END IF;
335:
336: -- Initialize message list if p_init_msg_list is set to TRUE.
337: IF fnd_api.to_Boolean( p_init_msg_list ) THEN

Line 337: IF fnd_api.to_Boolean( p_init_msg_list ) THEN

333: RAISE fnd_api.g_exc_unexpected_error;
334: END IF;
335:
336: -- Initialize message list if p_init_msg_list is set to TRUE.
337: IF fnd_api.to_Boolean( p_init_msg_list ) THEN
338: fnd_msg_pub.initialize;
339: END IF;
340:
341: -- Initialize the Import Status to 'FAILED'

Line 642: IF x_return_status = fnd_api.g_ret_sts_success THEN

638: x_return_status => x_return_status,
639: x_msg_count => x_msg_count,
640: x_msg_data => x_msg_data,
641: x_object_version_number => x_object_version_number);
642: IF x_return_status = fnd_api.g_ret_sts_success THEN
643: fnd_message.set_name ('CN' , 'CN_COPY_EXP_CREATE');
644: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
645: fnd_file.put_line(fnd_file.log, fnd_message.get);
646: COMMIT;

Line 649: IF x_return_status = fnd_api.g_ret_sts_error THEN

645: fnd_file.put_line(fnd_file.log, fnd_message.get);
646: COMMIT;
647: ELSE
648: ROLLBACK TO Create_Expression;
649: IF x_return_status = fnd_api.g_ret_sts_error THEN
650: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL_EXPECTED');
651: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
652: fnd_file.put_line(fnd_file.log, fnd_message.get);
653: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 655: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

651: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
652: fnd_file.put_line(fnd_file.log, fnd_message.get);
653: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
654: END IF;
655: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
656: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');
657: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
658: fnd_file.put_line(fnd_file.log, fnd_message.get);
659: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 815: IF x_return_status = fnd_api.g_ret_sts_success THEN

811: x_rate_dimension_id => l_rate_dimension_id,
812: x_return_status => x_return_status,
813: x_msg_count => x_msg_count,
814: x_msg_data => x_msg_data);
815: IF x_return_status = fnd_api.g_ret_sts_success THEN
816: fnd_message.set_name ('CN' , 'CN_COPY_RD_CREATE');
817: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
818: fnd_file.put_line(fnd_file.log, fnd_message.get);
819: IF (g_miss_rate_dim_exp_tbl.COUNT > 0 AND v_rate_dimension_rec.dim_unit_code = 'EXPRESSION') THEN

Line 834: IF x_return_status = fnd_api.g_ret_sts_error THEN

830: END IF;
831: COMMIT;
832: ELSE
833: ROLLBACK TO Create_RateDimension;
834: IF x_return_status = fnd_api.g_ret_sts_error THEN
835: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL_EXPECTED');
836: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
837: fnd_file.put_line(fnd_file.log, fnd_message.get);
838: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 840: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

836: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
837: fnd_file.put_line(fnd_file.log, fnd_message.get);
838: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
839: END IF;
840: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
841: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
842: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
843: fnd_file.put_line(fnd_file.log, fnd_message.get);
844: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 1007: IF x_return_status = fnd_api.g_ret_sts_success THEN

1003: x_rate_schedule_id => l_rate_schedule_id,
1004: x_return_status => x_return_status,
1005: x_msg_count => x_msg_count,
1006: x_msg_data => x_msg_data);
1007: IF x_return_status = fnd_api.g_ret_sts_success THEN
1008: --*********************************************************************
1009: -- Import Rate Tiers
1010: --*********************************************************************
1011: IF (v_rate_tiers_tbl.COUNT > 0) THEN

Line 1035: IF x_return_status = fnd_api.g_ret_sts_error THEN

1031: END IF;
1032: COMMIT;
1033: ELSE
1034: ROLLBACK TO Create_RateDimension;
1035: IF x_return_status = fnd_api.g_ret_sts_error THEN
1036: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL_EXPECTED');
1037: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1038: fnd_file.put_line(fnd_file.log, fnd_message.get);
1039: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 1041: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1037: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1038: fnd_file.put_line(fnd_file.log, fnd_message.get);
1039: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1040: END IF;
1041: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1042: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1043: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1044: fnd_file.put_line(fnd_file.log, fnd_message.get);
1045: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 1354: p_generate_packages => FND_API.G_TRUE,

1350: p_api_version => p_api_version,
1351: p_init_msg_list => p_init_msg_list,
1352: p_commit => p_commit,
1353: p_validation_level => p_validation_level,
1354: p_generate_packages => FND_API.G_TRUE,
1355: p_name => v_formula_rec.name,
1356: p_description => v_formula_rec.description,
1357: p_formula_type => v_formula_rec.formula_type,
1358: p_trx_group_code => v_formula_rec.trx_group_code,

Line 1377: IF x_return_status = fnd_api.g_ret_sts_success THEN

1373: x_return_status => x_return_status,
1374: x_msg_count => x_msg_count,
1375: x_msg_data => x_msg_data);
1376:
1377: IF x_return_status = fnd_api.g_ret_sts_success THEN
1378: fnd_message.set_name ('CN' , 'CN_COPY_FM_CREATE');
1379: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1380: fnd_file.put_line(fnd_file.log, fnd_message.get);
1381: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');

Line 1428: IF x_return_status = fnd_api.g_ret_sts_error THEN

1424: END IF;
1425: COMMIT;
1426: ELSE
1427: -- No ROLLBACK TO Create_Formula - Generate has a separate COMMIT cycle.
1428: IF x_return_status = fnd_api.g_ret_sts_error THEN
1429: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL_EXPECTED');
1430: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1431: fnd_file.put_line(fnd_file.log, fnd_message.get);
1432: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 1434: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1430: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1431: fnd_file.put_line(fnd_file.log, fnd_message.get);
1432: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1433: END IF;
1434: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1435: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1436: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1437: fnd_file.put_line(fnd_file.log, fnd_message.get);
1438: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 2129: IF x_return_status = fnd_api.g_ret_sts_success THEN

2125: p_rt_quota_asgns_rec_tbl => v_rt_quota_asgns_tbl,
2126: x_loading_status => x_loading_status,
2127: p_is_duplicate => 'N');
2128:
2129: IF x_return_status = fnd_api.g_ret_sts_success THEN
2130: -- Log Message for Plan Element creation.
2131: fnd_message.set_name ('CN' , 'CN_COPY_PE_CREATE');
2132: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2133: fnd_message.set_token('PLAN_ELEMENT_START_DATE',v_plan_element_rec.start_date);

Line 2178: IF x_return_status = fnd_api.g_ret_sts_error THEN

2174: g_miss_pe_exp_tbl(l_pe_counter).new_pe_id := g_miss_pe_exp_rec.new_pe_id;
2175: END IF;
2176: ELSE
2177: ROLLBACK TO Create_PlanElement;
2178: IF x_return_status = fnd_api.g_ret_sts_error THEN
2179: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL_EXPECTED');
2180: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2181: fnd_file.put_line(fnd_file.log, fnd_message.get);
2182: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 2184: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2180: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2181: fnd_file.put_line(fnd_file.log, fnd_message.get);
2182: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2183: END IF;
2184: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2185: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2186: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2187: fnd_file.put_line(fnd_file.log, fnd_message.get);
2188: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 2325: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2321: x_return_status => x_return_status,
2322: x_msg_count => x_msg_count,
2323: x_msg_data => x_msg_data);
2324:
2325: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2326: l_sql_fail_count := 1;
2327: END IF;
2328:
2329: IF l_sql_fail_count = 0 THEN

Line 2407: IF x_return_status = fnd_api.g_ret_sts_success THEN

2403: p_quota_assign => v_quota_assign_tbl(i),
2404: x_return_status => x_return_status,
2405: x_msg_count => x_msg_count,
2406: x_msg_data => x_msg_data);
2407: IF x_return_status = fnd_api.g_ret_sts_success THEN
2408: -- Validate the CompPlan
2409: v_comp_plan_rec.comp_plan_id := l_comp_plan_id;
2410: cn_comp_plan_pvt.validate_comp_plan(
2411: p_api_version => p_api_version,

Line 2419: IF x_return_status = fnd_api.g_ret_sts_success THEN

2415: p_comp_plan => v_comp_plan_rec,
2416: x_return_status => x_return_status,
2417: x_msg_count => x_msg_count,
2418: x_msg_data => x_msg_data);
2419: IF x_return_status = fnd_api.g_ret_sts_success THEN
2420: fnd_message.set_name ('CN' , 'CN_COPY_PE_ASSIGN');
2421: fnd_message.set_token('PLAN_NAME',v_name_node_value_new);
2422: fnd_message.set_token('PLAN_ELEMENT_NAME',v_quota_assign_tbl(i).name);
2423: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 2455: IF x_return_status = fnd_api.g_ret_sts_error THEN

2451: COMMIT;
2452: ELSE
2453: ROLLBACK TO Create_CompPlan;
2454: -- Comp Plan Fail Message
2455: IF x_return_status = fnd_api.g_ret_sts_error THEN
2456: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL_EXPECTED');
2457: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2458: fnd_file.put_line(fnd_file.log, fnd_message.get);
2459: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 2461: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2457: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2458: fnd_file.put_line(fnd_file.log, fnd_message.get);
2459: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2460: END IF;
2461: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2462: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2463: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2464: fnd_file.put_line(fnd_file.log, fnd_message.get);
2465: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 2517: IF x_return_status = fnd_api.g_ret_sts_error THEN

2513: END IF;
2514: ELSE
2515: ROLLBACK TO Create_CompPlan;
2516: -- Comp Plan Fail Message
2517: IF x_return_status = fnd_api.g_ret_sts_error THEN
2518: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL_EXPECTED');
2519: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2520: fnd_file.put_line(fnd_file.log, fnd_message.get);
2521: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 2523: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2519: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2520: fnd_file.put_line(fnd_file.log, fnd_message.get);
2521: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2522: END IF;
2523: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2524: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2525: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2526: fnd_file.put_line(fnd_file.log, fnd_message.get);
2527: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 2582: p_encoded => FND_API.G_FALSE);

2578: -- Standard call to get message count
2579: FND_MSG_PUB.Count_And_Get(
2580: p_count => x_msg_count,
2581: p_data => x_msg_data,
2582: p_encoded => FND_API.G_FALSE);
2583: EXCEPTION
2584: WHEN FND_API.G_EXC_ERROR THEN
2585: x_return_status := FND_API.G_RET_STS_ERROR;
2586: x_import_status := 'FAILED';

Line 2584: WHEN FND_API.G_EXC_ERROR THEN

2580: p_count => x_msg_count,
2581: p_data => x_msg_data,
2582: p_encoded => FND_API.G_FALSE);
2583: EXCEPTION
2584: WHEN FND_API.G_EXC_ERROR THEN
2585: x_return_status := FND_API.G_RET_STS_ERROR;
2586: x_import_status := 'FAILED';
2587: FND_MSG_PUB.count_and_get(
2588: p_count => x_msg_count,

Line 2585: x_return_status := FND_API.G_RET_STS_ERROR;

2581: p_data => x_msg_data,
2582: p_encoded => FND_API.G_FALSE);
2583: EXCEPTION
2584: WHEN FND_API.G_EXC_ERROR THEN
2585: x_return_status := FND_API.G_RET_STS_ERROR;
2586: x_import_status := 'FAILED';
2587: FND_MSG_PUB.count_and_get(
2588: p_count => x_msg_count,
2589: p_data => x_msg_data,

Line 2590: p_encoded => FND_API.G_FALSE);

2586: x_import_status := 'FAILED';
2587: FND_MSG_PUB.count_and_get(
2588: p_count => x_msg_count,
2589: p_data => x_msg_data,
2590: p_encoded => FND_API.G_FALSE);
2591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2593: x_import_status := 'FAILED';
2594: FND_MSG_PUB.count_and_get(

Line 2591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2587: FND_MSG_PUB.count_and_get(
2588: p_count => x_msg_count,
2589: p_data => x_msg_data,
2590: p_encoded => FND_API.G_FALSE);
2591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2593: x_import_status := 'FAILED';
2594: FND_MSG_PUB.count_and_get(
2595: p_count => x_msg_count,

Line 2592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2588: p_count => x_msg_count,
2589: p_data => x_msg_data,
2590: p_encoded => FND_API.G_FALSE);
2591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2593: x_import_status := 'FAILED';
2594: FND_MSG_PUB.count_and_get(
2595: p_count => x_msg_count,
2596: p_data => x_msg_data,

Line 2597: p_encoded => FND_API.G_FALSE);

2593: x_import_status := 'FAILED';
2594: FND_MSG_PUB.count_and_get(
2595: p_count => x_msg_count,
2596: p_data => x_msg_data,
2597: p_encoded => FND_API.G_FALSE);
2598: WHEN OTHERS THEN
2599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2600: x_import_status := 'FAILED';
2601: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2595: p_count => x_msg_count,
2596: p_data => x_msg_data,
2597: p_encoded => FND_API.G_FALSE);
2598: WHEN OTHERS THEN
2599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2600: x_import_status := 'FAILED';
2601: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2602: FND_MSG_PUB.add_exc_msg(G_PKG_NAME,l_api_name);
2603: END IF;

Line 2607: p_encoded => FND_API.G_FALSE);

2603: END IF;
2604: FND_MSG_PUB.count_and_get(
2605: p_count => x_msg_count,
2606: p_data => x_msg_data,
2607: p_encoded => FND_API.G_FALSE);
2608: END Parse_XML;
2609:
2610: /**********************************************************************/
2611: /* API Body - Finish */