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 339: IF NOT fnd_api.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME )THEN

335: /**********************************************************************/
336: -- Standard Start of API savepoint
337: -- SAVEPOINT Parse_XML;
338: -- Standard call to check for call compatibility.
339: IF NOT fnd_api.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME )THEN
340: RAISE fnd_api.g_exc_unexpected_error;
341: END IF;
342:
343: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 340: RAISE fnd_api.g_exc_unexpected_error;

336: -- Standard Start of API savepoint
337: -- SAVEPOINT Parse_XML;
338: -- Standard call to check for call compatibility.
339: IF NOT fnd_api.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME )THEN
340: RAISE fnd_api.g_exc_unexpected_error;
341: END IF;
342:
343: -- Initialize message list if p_init_msg_list is set to TRUE.
344: IF fnd_api.to_Boolean( p_init_msg_list ) THEN

Line 344: IF fnd_api.to_Boolean( p_init_msg_list ) THEN

340: RAISE fnd_api.g_exc_unexpected_error;
341: END IF;
342:
343: -- Initialize message list if p_init_msg_list is set to TRUE.
344: IF fnd_api.to_Boolean( p_init_msg_list ) THEN
345: fnd_msg_pub.initialize;
346: END IF;
347:
348: -- Initialize the Import Status to 'FAILED'

Line 687: , p_update_parent_also => fnd_api.g_false

683: p_api_version => p_api_version
684: , p_init_msg_list => p_init_msg_list
685: , p_commit => p_commit
686: , p_validation_level => p_validation_level
687: , p_update_parent_also => fnd_api.g_false
688: , p_org_id => p_org_id
689: , p_calc_sql_exp_id => l_calc_sql_exp_id
690: , p_name => v_expression_rec.name
691: , p_description => v_expression_rec.description

Line 707: IF x_return_status = fnd_api.g_ret_sts_success THEN

703: , x_msg_count => x_msg_count
704: , x_msg_data => x_msg_data
705: );
706:
707: IF x_return_status = fnd_api.g_ret_sts_success THEN
708: fnd_message.set_name ('CN' , 'CN_COPY_EXP_REUSE');
709: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
710: fnd_file.put_line(fnd_file.log, fnd_message.get);
711: COMMIT;

Line 714: IF x_return_status = fnd_api.g_ret_sts_error THEN

710: fnd_file.put_line(fnd_file.log, fnd_message.get);
711: COMMIT;
712: ELSE
713: ROLLBACK TO Create_Expression;
714: IF x_return_status = fnd_api.g_ret_sts_error THEN
715: fnd_message.set_name ('CN' , 'Update of existing expression Failed with return status error');
716: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
717: fnd_file.put_line(fnd_file.log, fnd_message.get);
718: fnd_file.put_line(fnd_file.log, '***ERROR STATUS: '||x_msg_data);

Line 720: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

716: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
717: fnd_file.put_line(fnd_file.log, fnd_message.get);
718: fnd_file.put_line(fnd_file.log, '***ERROR STATUS: '||x_msg_data);
719: END IF;
720: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
721: fnd_message.set_name ('CN' , 'Update of existing expression failed with unexpected error');
722: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
723: fnd_file.put_line(fnd_file.log, fnd_message.get);
724: fnd_file.put_line(fnd_file.log, '***UNEXPECTED ERROR: '||x_msg_data);

Line 756: IF x_return_status = fnd_api.g_ret_sts_success THEN

752: x_return_status => x_return_status,
753: x_msg_count => x_msg_count,
754: x_msg_data => x_msg_data,
755: x_object_version_number => x_object_version_number);
756: IF x_return_status = fnd_api.g_ret_sts_success THEN
757: fnd_message.set_name ('CN' , 'CN_COPY_EXP_CREATE');
758: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
759: fnd_file.put_line(fnd_file.log, fnd_message.get);
760: COMMIT;

Line 763: IF x_return_status = fnd_api.g_ret_sts_error THEN

759: fnd_file.put_line(fnd_file.log, fnd_message.get);
760: COMMIT;
761: ELSE
762: ROLLBACK TO Create_Expression;
763: IF x_return_status = fnd_api.g_ret_sts_error THEN
764: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL_EXPECTED');
765: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
766: fnd_file.put_line(fnd_file.log, fnd_message.get);
767: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 769: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

765: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
766: fnd_file.put_line(fnd_file.log, fnd_message.get);
767: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
768: END IF;
769: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
770: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');
771: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
772: fnd_file.put_line(fnd_file.log, fnd_message.get);
773: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 933: IF x_return_status = fnd_api.g_ret_sts_success THEN

929: x_rate_dimension_id => l_rate_dimension_id,
930: x_return_status => x_return_status,
931: x_msg_count => x_msg_count,
932: x_msg_data => x_msg_data);
933: IF x_return_status = fnd_api.g_ret_sts_success THEN
934: fnd_message.set_name ('CN' , 'CN_COPY_RD_CREATE');
935: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
936: fnd_file.put_line(fnd_file.log, fnd_message.get);
937: IF (g_miss_rate_dim_exp_tbl.COUNT > 0 AND v_rate_dimension_rec.dim_unit_code = 'EXPRESSION') THEN

Line 952: IF x_return_status = fnd_api.g_ret_sts_error THEN

948: END IF;
949: COMMIT;
950: ELSE
951: ROLLBACK TO Create_RateDimension;
952: IF x_return_status = fnd_api.g_ret_sts_error THEN
953: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL_EXPECTED');
954: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
955: fnd_file.put_line(fnd_file.log, fnd_message.get);
956: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 958: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

954: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
955: fnd_file.put_line(fnd_file.log, fnd_message.get);
956: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
957: END IF;
958: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
959: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
960: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
961: fnd_file.put_line(fnd_file.log, fnd_message.get);
962: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 1130: IF x_return_status = fnd_api.g_ret_sts_success THEN

1126: x_rate_schedule_id => l_rate_schedule_id,
1127: x_return_status => x_return_status,
1128: x_msg_count => x_msg_count,
1129: x_msg_data => x_msg_data);
1130: IF x_return_status = fnd_api.g_ret_sts_success THEN
1131: --*********************************************************************
1132: -- Import Rate Tiers
1133: --*********************************************************************
1134: IF (v_rate_tiers_tbl.COUNT > 0) THEN

Line 1158: IF x_return_status = fnd_api.g_ret_sts_error THEN

1154: END IF;
1155: COMMIT;
1156: ELSE
1157: ROLLBACK TO Create_RateDimension;
1158: IF x_return_status = fnd_api.g_ret_sts_error THEN
1159: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL_EXPECTED');
1160: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1161: fnd_file.put_line(fnd_file.log, fnd_message.get);
1162: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 1164: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1160: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1161: fnd_file.put_line(fnd_file.log, fnd_message.get);
1162: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1163: END IF;
1164: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1165: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1166: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1167: fnd_file.put_line(fnd_file.log, fnd_message.get);
1168: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 1516: p_generate_packages => FND_API.G_TRUE,

1512: p_api_version => p_api_version,
1513: p_init_msg_list => p_init_msg_list,
1514: p_commit => p_commit,
1515: p_validation_level => p_validation_level,
1516: p_generate_packages => FND_API.G_TRUE,
1517: p_name => v_formula_rec.name,
1518: p_description => v_formula_rec.description,
1519: p_formula_type => v_formula_rec.formula_type,
1520: p_trx_group_code => v_formula_rec.trx_group_code,

Line 1539: IF x_return_status = fnd_api.g_ret_sts_success THEN

1535: x_return_status => x_return_status,
1536: x_msg_count => x_msg_count,
1537: x_msg_data => x_msg_data);
1538:
1539: IF x_return_status = fnd_api.g_ret_sts_success THEN
1540: fnd_message.set_name ('CN' , 'CN_COPY_FM_CREATE');
1541: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1542: fnd_file.put_line(fnd_file.log, fnd_message.get);
1543: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');

Line 1590: IF x_return_status = fnd_api.g_ret_sts_error THEN

1586: END IF;
1587: COMMIT;
1588: ELSE
1589: -- No ROLLBACK TO Create_Formula - Generate has a separate COMMIT cycle.
1590: IF x_return_status = fnd_api.g_ret_sts_error THEN
1591: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL_EXPECTED');
1592: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1593: fnd_file.put_line(fnd_file.log, fnd_message.get);
1594: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 1596: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1592: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1593: fnd_file.put_line(fnd_file.log, fnd_message.get);
1594: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1595: END IF;
1596: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1597: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1598: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1599: fnd_file.put_line(fnd_file.log, fnd_message.get);
1600: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 2357: RAISE FND_API.G_EXC_ERROR;

2353: fnd_file.put_line(fnd_file.log, 'Period Does not exist or a closed period. Check for the date: ' || p_start_date);
2354: fnd_message.set_name ('CN', 'CN_PERIOD_NOT_EXIST');
2355: fnd_message.set_token ('PERIOD_NAME', p_start_date);
2356: fnd_file.put_line(fnd_file.log, fnd_message.get);
2357: RAISE FND_API.G_EXC_ERROR;
2358:
2359: END IF; --end of l_period_exist_count
2360:
2361: select period_id into l_period_id from cn_period_statuses where start_date <= p_start_date and end_date >= p_start_date AND org_id = p_org_id;

Line 2498: IF x_return_status = fnd_api.g_ret_sts_success THEN

2494: p_is_duplicate => 'N');
2495:
2496:
2497:
2498: IF x_return_status = fnd_api.g_ret_sts_success THEN
2499: -- Log Message for Plan Element creation.
2500: fnd_message.set_name ('CN' , 'CN_COPY_PE_CREATE');
2501: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2502: fnd_message.set_token('PLAN_ELEMENT_START_DATE',v_plan_element_rec.start_date);

Line 2548: IF x_return_status = fnd_api.g_ret_sts_error THEN

2544: g_miss_pe_exp_tbl(l_pe_counter).new_pe_id := g_miss_pe_exp_rec.new_pe_id;
2545: END IF;
2546: ELSE
2547: ROLLBACK TO Create_PlanElement;
2548: IF x_return_status = fnd_api.g_ret_sts_error THEN
2549: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL_EXPECTED');
2550: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2551: fnd_file.put_line(fnd_file.log, fnd_message.get);
2552: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 2555: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2551: fnd_file.put_line(fnd_file.log, fnd_message.get);
2552: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2553: fnd_file.put_line(fnd_file.Log,'4$$$$$');
2554: END IF;
2555: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2556: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2557: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2558: fnd_file.put_line(fnd_file.log, fnd_message.get);
2559: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 2704: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2700: x_return_status => x_return_status,
2701: x_msg_count => x_msg_count,
2702: x_msg_data => x_msg_data);
2703:
2704: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2705: l_sql_fail_count := 1;
2706: END IF;
2707:
2708: IF l_sql_fail_count = 0 THEN

Line 2787: IF x_return_status = fnd_api.g_ret_sts_success THEN

2783: x_return_status => x_return_status,
2784: x_msg_count => x_msg_count,
2785: x_msg_data => x_msg_data);
2786:
2787: IF x_return_status = fnd_api.g_ret_sts_success THEN
2788: -- Validate the CompPlan
2789: v_comp_plan_rec.comp_plan_id := l_comp_plan_id;
2790: cn_comp_plan_pvt.validate_comp_plan(
2791: p_api_version => p_api_version,

Line 2801: IF x_return_status = fnd_api.g_ret_sts_success THEN

2797: x_msg_count => x_msg_count,
2798: x_msg_data => x_msg_data);
2799:
2800:
2801: IF x_return_status = fnd_api.g_ret_sts_success THEN
2802: fnd_message.set_name ('CN' , 'CN_COPY_PE_ASSIGN');
2803: fnd_message.set_token('PLAN_NAME',v_name_node_value_new);
2804: fnd_message.set_token('PLAN_ELEMENT_NAME',v_quota_assign_tbl(i).name);
2805: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 2837: IF x_return_status = fnd_api.g_ret_sts_error THEN

2833: COMMIT;
2834: ELSE
2835: ROLLBACK TO Create_CompPlan;
2836: -- Comp Plan Fail Message
2837: IF x_return_status = fnd_api.g_ret_sts_error THEN
2838: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL_EXPECTED');
2839: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2840: fnd_file.put_line(fnd_file.log, fnd_message.get);
2841: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 2843: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2839: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2840: fnd_file.put_line(fnd_file.log, fnd_message.get);
2841: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2842: END IF;
2843: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2844: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2845: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2846: fnd_file.put_line(fnd_file.log, fnd_message.get);
2847: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 2899: IF x_return_status = fnd_api.g_ret_sts_error THEN

2895: END IF;
2896: ELSE
2897: ROLLBACK TO Create_CompPlan;
2898: -- Comp Plan Fail Message
2899: IF x_return_status = fnd_api.g_ret_sts_error THEN
2900: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL_EXPECTED');
2901: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2902: fnd_file.put_line(fnd_file.log, fnd_message.get);
2903: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 2905: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2901: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2902: fnd_file.put_line(fnd_file.log, fnd_message.get);
2903: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2904: END IF;
2905: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2906: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2907: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2908: fnd_file.put_line(fnd_file.log, fnd_message.get);
2909: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

Line 2964: p_encoded => FND_API.G_FALSE);

2960: -- Standard call to get message count
2961: FND_MSG_PUB.Count_And_Get(
2962: p_count => x_msg_count,
2963: p_data => x_msg_data,
2964: p_encoded => FND_API.G_FALSE);
2965: EXCEPTION
2966: WHEN FND_API.G_EXC_ERROR THEN
2967: x_return_status := FND_API.G_RET_STS_ERROR;
2968: x_import_status := 'FAILED';

Line 2966: WHEN FND_API.G_EXC_ERROR THEN

2962: p_count => x_msg_count,
2963: p_data => x_msg_data,
2964: p_encoded => FND_API.G_FALSE);
2965: EXCEPTION
2966: WHEN FND_API.G_EXC_ERROR THEN
2967: x_return_status := FND_API.G_RET_STS_ERROR;
2968: x_import_status := 'FAILED';
2969: FND_MSG_PUB.count_and_get(
2970: p_count => x_msg_count,

Line 2967: x_return_status := FND_API.G_RET_STS_ERROR;

2963: p_data => x_msg_data,
2964: p_encoded => FND_API.G_FALSE);
2965: EXCEPTION
2966: WHEN FND_API.G_EXC_ERROR THEN
2967: x_return_status := FND_API.G_RET_STS_ERROR;
2968: x_import_status := 'FAILED';
2969: FND_MSG_PUB.count_and_get(
2970: p_count => x_msg_count,
2971: p_data => x_msg_data,

Line 2972: p_encoded => FND_API.G_FALSE);

2968: x_import_status := 'FAILED';
2969: FND_MSG_PUB.count_and_get(
2970: p_count => x_msg_count,
2971: p_data => x_msg_data,
2972: p_encoded => FND_API.G_FALSE);
2973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2975: x_import_status := 'FAILED';
2976: FND_MSG_PUB.count_and_get(

Line 2973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2969: FND_MSG_PUB.count_and_get(
2970: p_count => x_msg_count,
2971: p_data => x_msg_data,
2972: p_encoded => FND_API.G_FALSE);
2973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2975: x_import_status := 'FAILED';
2976: FND_MSG_PUB.count_and_get(
2977: p_count => x_msg_count,

Line 2974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2970: p_count => x_msg_count,
2971: p_data => x_msg_data,
2972: p_encoded => FND_API.G_FALSE);
2973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2975: x_import_status := 'FAILED';
2976: FND_MSG_PUB.count_and_get(
2977: p_count => x_msg_count,
2978: p_data => x_msg_data,

Line 2979: p_encoded => FND_API.G_FALSE);

2975: x_import_status := 'FAILED';
2976: FND_MSG_PUB.count_and_get(
2977: p_count => x_msg_count,
2978: p_data => x_msg_data,
2979: p_encoded => FND_API.G_FALSE);
2980: WHEN OTHERS THEN
2981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2982: x_import_status := 'FAILED';
2983: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2977: p_count => x_msg_count,
2978: p_data => x_msg_data,
2979: p_encoded => FND_API.G_FALSE);
2980: WHEN OTHERS THEN
2981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2982: x_import_status := 'FAILED';
2983: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2984: FND_MSG_PUB.add_exc_msg(G_PKG_NAME,l_api_name);
2985: END IF;

Line 2989: p_encoded => FND_API.G_FALSE);

2985: END IF;
2986: FND_MSG_PUB.count_and_get(
2987: p_count => x_msg_count,
2988: p_data => x_msg_data,
2989: p_encoded => FND_API.G_FALSE);
2990: END Parse_XML;
2991:
2992: /**********************************************************************/
2993: /* API Body - Finish */