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

Line 76: RAISE fnd_api.g_exc_error;

72: fnd_msg_pub.ADD;
73:
74: CLOSE c_plan_element_csr;
75:
76: RAISE fnd_api.g_exc_error;
77: END IF;
78:
79: CLOSE c_plan_element_csr;
80:

Line 162: x_return_status := fnd_api.g_ret_sts_success;

158: l_temp_2 VARCHAR2 (200);
159:
160: BEGIN
161: -- Initialize to success
162: x_return_status := fnd_api.g_ret_sts_success;
163: -- Initialize other fields
164: x_msg_data := fnd_api.g_null_char;
165: x_msg_count := fnd_api.g_null_num;
166:

Line 164: x_msg_data := fnd_api.g_null_char;

160: BEGIN
161: -- Initialize to success
162: x_return_status := fnd_api.g_ret_sts_success;
163: -- Initialize other fields
164: x_msg_data := fnd_api.g_null_char;
165: x_msg_count := fnd_api.g_null_num;
166:
167: IF (p_operation <> 'update') THEN
168: IF (p_operation = 'create') THEN

Line 165: x_msg_count := fnd_api.g_null_num;

161: -- Initialize to success
162: x_return_status := fnd_api.g_ret_sts_success;
163: -- Initialize other fields
164: x_msg_data := fnd_api.g_null_char;
165: x_msg_count := fnd_api.g_null_num;
166:
167: IF (p_operation <> 'update') THEN
168: IF (p_operation = 'create') THEN
169: fnd_message.set_name('CN','CNR12_NOTE_PE_NAME_CREATE');

Line 238: IF (NVL(p_plan_element_old.end_date, fnd_api.g_miss_date)

234: x_jtf_note_id => l_note_id -- returned
235: );*/
236: END IF;
237: -- CHECK IF END DATE WAS UPDATED
238: IF (NVL(p_plan_element_old.end_date, fnd_api.g_miss_date)
239: <> NVL(p_plan_element_new.end_date, fnd_api.g_miss_date)) THEN
240: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_ENDATE_UPDATE');
241: IF (p_plan_element_old.end_date IS NULL) THEN
242: fnd_message.set_token('PE_END_OLD', 'NULL');

Line 239: <> NVL(p_plan_element_new.end_date, fnd_api.g_miss_date)) THEN

235: );*/
236: END IF;
237: -- CHECK IF END DATE WAS UPDATED
238: IF (NVL(p_plan_element_old.end_date, fnd_api.g_miss_date)
239: <> NVL(p_plan_element_new.end_date, fnd_api.g_miss_date)) THEN
240: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_ENDATE_UPDATE');
241: IF (p_plan_element_old.end_date IS NULL) THEN
242: fnd_message.set_token('PE_END_OLD', 'NULL');
243: ELSE

Line 626: WHEN fnd_api.g_exc_error

622:
623: END IF;
624:
625: EXCEPTION
626: WHEN fnd_api.g_exc_error
627: THEN
628: x_return_status := fnd_api.g_ret_sts_error;
629: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
630: WHEN fnd_api.g_exc_unexpected_error

Line 628: x_return_status := fnd_api.g_ret_sts_error;

624:
625: EXCEPTION
626: WHEN fnd_api.g_exc_error
627: THEN
628: x_return_status := fnd_api.g_ret_sts_error;
629: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
630: WHEN fnd_api.g_exc_unexpected_error
631: THEN
632: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 629: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

625: EXCEPTION
626: WHEN fnd_api.g_exc_error
627: THEN
628: x_return_status := fnd_api.g_ret_sts_error;
629: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
630: WHEN fnd_api.g_exc_unexpected_error
631: THEN
632: x_return_status := fnd_api.g_ret_sts_unexp_error;
633: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 630: WHEN fnd_api.g_exc_unexpected_error

626: WHEN fnd_api.g_exc_error
627: THEN
628: x_return_status := fnd_api.g_ret_sts_error;
629: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
630: WHEN fnd_api.g_exc_unexpected_error
631: THEN
632: x_return_status := fnd_api.g_ret_sts_unexp_error;
633: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
634: WHEN OTHERS

Line 632: x_return_status := fnd_api.g_ret_sts_unexp_error;

628: x_return_status := fnd_api.g_ret_sts_error;
629: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
630: WHEN fnd_api.g_exc_unexpected_error
631: THEN
632: x_return_status := fnd_api.g_ret_sts_unexp_error;
633: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
634: WHEN OTHERS
635: THEN
636: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 633: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

629: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
630: WHEN fnd_api.g_exc_unexpected_error
631: THEN
632: x_return_status := fnd_api.g_ret_sts_unexp_error;
633: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
634: WHEN OTHERS
635: THEN
636: x_return_status := fnd_api.g_ret_sts_unexp_error;
637: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

Line 636: x_return_status := fnd_api.g_ret_sts_unexp_error;

632: x_return_status := fnd_api.g_ret_sts_unexp_error;
633: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
634: WHEN OTHERS
635: THEN
636: x_return_status := fnd_api.g_ret_sts_unexp_error;
637: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
638: THEN
639: fnd_msg_pub.add_exc_msg (g_pkg_name, 'add_system_note');
640: END IF;

Line 641: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

637: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
638: THEN
639: fnd_msg_pub.add_exc_msg (g_pkg_name, 'add_system_note');
640: END IF;
641: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
642:
643: END add_system_note;
644:
645: -------------------------------------------------------------------------+-+

Line 706: x_return_status := fnd_api.g_ret_sts_success;

702: -- Insert Rate Quota Assigs
703: -- first table count is 0
704:
705: -- Set Status
706: x_return_status := fnd_api.g_ret_sts_success;
707: x_loading_status := p_loading_status;
708:
709: IF p_pe_rec.quota_type_code <> 'NONE'
710: THEN

Line 763: IF (x_return_status <> fnd_api.g_ret_sts_success)

759: x_object_version_number => l_object_version_number
760: );
761:
762:
763: IF (x_return_status <> fnd_api.g_ret_sts_success)
764: THEN
765: RAISE fnd_api.g_exc_error;
766: END IF;
767: END IF;

Line 765: RAISE fnd_api.g_exc_error;

761:
762:
763: IF (x_return_status <> fnd_api.g_ret_sts_success)
764: THEN
765: RAISE fnd_api.g_exc_error;
766: END IF;
767: END IF;
768: ELSIF p_rt_quota_asgns_rec_tbl.COUNT > 0
769: THEN

Line 780: RAISE fnd_api.g_exc_error;

776: fnd_msg_pub.ADD;
777: END IF;
778:
779: x_loading_status := 'QUOTA_CANNOT_HAVE_RATES';
780: RAISE fnd_api.g_exc_error;
781: END IF;
782: -- End of rate_quotas
783: EXCEPTION
784: WHEN fnd_api.g_exc_error

Line 784: WHEN fnd_api.g_exc_error

780: RAISE fnd_api.g_exc_error;
781: END IF;
782: -- End of rate_quotas
783: EXCEPTION
784: WHEN fnd_api.g_exc_error
785: THEN
786: x_return_status := fnd_api.g_ret_sts_error;
787: WHEN fnd_api.g_exc_unexpected_error
788: THEN

Line 786: x_return_status := fnd_api.g_ret_sts_error;

782: -- End of rate_quotas
783: EXCEPTION
784: WHEN fnd_api.g_exc_error
785: THEN
786: x_return_status := fnd_api.g_ret_sts_error;
787: WHEN fnd_api.g_exc_unexpected_error
788: THEN
789: x_return_status := fnd_api.g_ret_sts_unexp_error;
790: x_loading_status := 'UNEXPECTED_ERR';

Line 787: WHEN fnd_api.g_exc_unexpected_error

783: EXCEPTION
784: WHEN fnd_api.g_exc_error
785: THEN
786: x_return_status := fnd_api.g_ret_sts_error;
787: WHEN fnd_api.g_exc_unexpected_error
788: THEN
789: x_return_status := fnd_api.g_ret_sts_unexp_error;
790: x_loading_status := 'UNEXPECTED_ERR';
791: WHEN OTHERS

Line 789: x_return_status := fnd_api.g_ret_sts_unexp_error;

785: THEN
786: x_return_status := fnd_api.g_ret_sts_error;
787: WHEN fnd_api.g_exc_unexpected_error
788: THEN
789: x_return_status := fnd_api.g_ret_sts_unexp_error;
790: x_loading_status := 'UNEXPECTED_ERR';
791: WHEN OTHERS
792: THEN
793: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 793: x_return_status := fnd_api.g_ret_sts_unexp_error;

789: x_return_status := fnd_api.g_ret_sts_unexp_error;
790: x_loading_status := 'UNEXPECTED_ERR';
791: WHEN OTHERS
792: THEN
793: x_return_status := fnd_api.g_ret_sts_unexp_error;
794: x_loading_status := 'UNEXPECTED_ERR';
795:
796: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
797: THEN

Line 892: x_return_status := fnd_api.g_ret_sts_success;

888: l_plan_element CN_CHK_PLAN_ELEMENT_PKG.pe_rec_type;
889: l_lookup_type CN_LOOKUPS.lookup_type%TYPE;
890: BEGIN
891: -- set the Status
892: x_return_status := fnd_api.g_ret_sts_success;
893: l_lookup_type := '';
894: -- Check/Valid quota_type_code
895: IF p_plan_element.quota_type_code NOT IN ('EXTERNAL', 'FORMULA')
896: THEN

Line 904: RAISE fnd_api.g_exc_error;

900: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_element_type);
901: fnd_msg_pub.ADD;
902: END IF;
903:
904: RAISE fnd_api.g_exc_error;
905: END IF;
906:
907: -- Check/Valid Incentive Type
908: l_lookup_type := 'INCENTIVE_TYPE';

Line 924: RAISE fnd_api.g_exc_error;

920: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_incentive_type_code);
921: fnd_msg_pub.ADD;
922: END IF;
923:
924: RAISE fnd_api.g_exc_error;
925: END IF;
926:
927: l_lookup_type := 'PAYMENT_GROUP_CODE';
928: SELECT COUNT (*)

Line 943: RAISE fnd_api.g_exc_error;

939: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PAYMENT_GROUP', 'PE_OBJECT_TYPE'));
940: fnd_msg_pub.ADD;
941: END IF;
942:
943: RAISE fnd_api.g_exc_error;
944: END IF;
945:
946: BEGIN
947: SELECT lookup_code

Line 961: RAISE fnd_api.g_exc_error;

957: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('QUOTA_GROUP', 'PE_OBJECT_TYPE'));
958: fnd_msg_pub.ADD;
959: END IF;
960:
961: RAISE fnd_api.g_exc_error;
962: WHEN OTHERS
963: THEN
964: RAISE fnd_api.g_exc_error;
965: END;

Line 964: RAISE fnd_api.g_exc_error;

960:
961: RAISE fnd_api.g_exc_error;
962: WHEN OTHERS
963: THEN
964: RAISE fnd_api.g_exc_error;
965: END;
966:
967: BEGIN
968: SELECT lookup_code

Line 982: RAISE fnd_api.g_exc_error;

978: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('STATUS', 'PE_OBJECT_TYPE'));
979: fnd_msg_pub.ADD;
980: END IF;
981:
982: RAISE fnd_api.g_exc_error;
983: WHEN OTHERS
984: THEN
985: RAISE fnd_api.g_exc_error;
986: END;

Line 985: RAISE fnd_api.g_exc_error;

981:
982: RAISE fnd_api.g_exc_error;
983: WHEN OTHERS
984: THEN
985: RAISE fnd_api.g_exc_error;
986: END;
987:
988: -- Validate Indirect Credit
989: l_lookup_type := 'INDIRECT_CREDIT_TYPE';

Line 1005: RAISE fnd_api.g_exc_error;

1001: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('INDIRECT_CREDIT_TYPE', 'PE_OBJECT_TYPE'));
1002: fnd_msg_pub.ADD;
1003: END IF;
1004:
1005: RAISE fnd_api.g_exc_error;
1006: END IF;
1007:
1008: -- validate that the formula is okay
1009: IF (p_plan_element.calc_formula_id IS NOT NULL OR p_plan_element.quota_status <> g_new_status)

Line 1053: RAISE fnd_api.g_exc_error;

1049: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('CREDIT_TYPE', 'PE_OBJECT_TYPE'));
1050: fnd_msg_pub.ADD;
1051: END IF;
1052:
1053: RAISE fnd_api.g_exc_error;
1054: END IF;
1055: END IF;
1056:
1057: IF (p_plan_element.interval_type_id IS NOT NULL)

Line 1074: RAISE fnd_api.g_exc_error;

1070: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PERIOD_TYPE', 'PE_OBJECT_TYPE'));
1071: fnd_msg_pub.ADD;
1072: END IF;
1073:
1074: RAISE fnd_api.g_exc_error;
1075: END IF;
1076: END IF;
1077:
1078: -- verify that the columns below are valid when not new

Line 1093: RAISE fnd_api.g_exc_error;

1089: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('CREDIT_TYPE', 'PE_OBJECT_TYPE'));
1090: fnd_msg_pub.ADD;
1091: END IF;
1092:
1093: RAISE fnd_api.g_exc_error;
1094: END IF;
1095:
1096: -- FROM:chk_pe_required Check interval_type_id can not be missing or NULL
1097: IF (p_plan_element.interval_type_id IS NULL)

Line 1106: RAISE fnd_api.g_exc_error;

1102: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PERIOD_TYPE', 'PE_OBJECT_TYPE'));
1103: fnd_msg_pub.ADD;
1104: END IF;
1105:
1106: RAISE fnd_api.g_exc_error;
1107: END IF;
1108:
1109: IF (p_plan_element.calc_formula_id IS NULL AND p_plan_element.quota_type_code = 'FORMULA')
1110: THEN

Line 1118: RAISE fnd_api.g_exc_error;

1114: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('FORMULA', 'QUOTA_TYPE'));
1115: fnd_msg_pub.ADD;
1116: END IF;
1117:
1118: RAISE fnd_api.g_exc_error;
1119: END IF;
1120: END validate_types;
1121:
1122: -- clku

Line 1216: RAISE fnd_api.g_exc_error;

1212: fnd_message.set_name ('CN', 'CN_INV_ACC_NO');
1213: fnd_msg_pub.ADD;
1214: END IF;
1215:
1216: RAISE fnd_api.g_exc_error;
1217: END IF;
1218:
1219: IF (l_count = 0 AND p_account_type = 'E')
1220: THEN

Line 1228: RAISE fnd_api.g_exc_error;

1224: fnd_message.set_name ('CN', 'CN_INV_ACC_NO');
1225: fnd_msg_pub.ADD;
1226: END IF;
1227:
1228: RAISE fnd_api.g_exc_error;
1229: END IF;
1230:
1231: sql_stmt := 'SELECT code_combination_id';
1232: where_stmt := ' ';

Line 1308: RAISE fnd_api.g_exc_error;

1304: fnd_message.set_name ('CN', 'CN_IMP_INVLD_LIABLTY_CODE');
1305: fnd_msg_pub.ADD;
1306: END IF;
1307:
1308: RAISE fnd_api.g_exc_error;
1309: END;
1310: END IF;
1311:
1312: --clku

Line 1336: RAISE fnd_api.g_exc_error;

1332: fnd_message.set_name ('CN', 'CN_IMP_INVLD_EXPENS_CODE');
1333: fnd_msg_pub.ADD;
1334: END IF;
1335:
1336: RAISE fnd_api.g_exc_error;
1337: END;
1338: END IF;
1339: END validate_and_update_ccids;
1340:

Line 1349: -- Default = FND_API.G_FALSE

1345: -- Pre-reqs : None.
1346: -- Parameters :
1347: -- IN : p_api_version IN NUMBER Required
1348: -- p_init_msg_list IN VARCHAR2 Optional
1349: -- Default = FND_API.G_FALSE
1350: -- p_commit IN VARCHAR2 Optional
1351: -- Default = FND_API.G_FALSE
1352: -- p_validation_level IN NUMBER Optional
1353: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1351: -- Default = FND_API.G_FALSE

1347: -- IN : p_api_version IN NUMBER Required
1348: -- p_init_msg_list IN VARCHAR2 Optional
1349: -- Default = FND_API.G_FALSE
1350: -- p_commit IN VARCHAR2 Optional
1351: -- Default = FND_API.G_FALSE
1352: -- p_validation_level IN NUMBER Optional
1353: -- Default = FND_API.G_VALID_LEVEL_FULL
1354: -- p_plan_element IN plan_element_rec_type
1355: -- OUT : x_return_status OUT VARCHAR2(1)

Line 1353: -- Default = FND_API.G_VALID_LEVEL_FULL

1349: -- Default = FND_API.G_FALSE
1350: -- p_commit IN VARCHAR2 Optional
1351: -- Default = FND_API.G_FALSE
1352: -- p_validation_level IN NUMBER Optional
1353: -- Default = FND_API.G_VALID_LEVEL_FULL
1354: -- p_plan_element IN plan_element_rec_type
1355: -- OUT : x_return_status OUT VARCHAR2(1)
1356: -- x_msg_count OUT NUMBER
1357: -- x_msg_data OUT VARCHAR2(2000)

Line 1365: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1361: --
1362: -- End of comments
1363: PROCEDURE create_plan_element (
1364: p_api_version IN NUMBER,
1365: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1366: p_commit IN VARCHAR2 := fnd_api.g_false,
1367: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1368: p_plan_element IN OUT NOCOPY plan_element_rec_type,
1369: x_return_status OUT NOCOPY VARCHAR2,

Line 1366: p_commit IN VARCHAR2 := fnd_api.g_false,

1362: -- End of comments
1363: PROCEDURE create_plan_element (
1364: p_api_version IN NUMBER,
1365: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1366: p_commit IN VARCHAR2 := fnd_api.g_false,
1367: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1368: p_plan_element IN OUT NOCOPY plan_element_rec_type,
1369: x_return_status OUT NOCOPY VARCHAR2,
1370: x_msg_count OUT NOCOPY NUMBER,

Line 1367: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

1363: PROCEDURE create_plan_element (
1364: p_api_version IN NUMBER,
1365: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1366: p_commit IN VARCHAR2 := fnd_api.g_false,
1367: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1368: p_plan_element IN OUT NOCOPY plan_element_rec_type,
1369: x_return_status OUT NOCOPY VARCHAR2,
1370: x_msg_count OUT NOCOPY NUMBER,
1371: x_msg_data OUT NOCOPY VARCHAR2

Line 1393: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

1389: -- Standard Start of API savepoint
1390: SAVEPOINT create_plan_element;
1391:
1392: -- Standard call to check for call compatibility.
1393: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1394: THEN
1395: RAISE fnd_api.g_exc_unexpected_error;
1396: END IF;
1397:

Line 1395: RAISE fnd_api.g_exc_unexpected_error;

1391:
1392: -- Standard call to check for call compatibility.
1393: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1394: THEN
1395: RAISE fnd_api.g_exc_unexpected_error;
1396: END IF;
1397:
1398: -- Initialize message list if p_init_msg_list is set to TRUE.
1399: IF fnd_api.to_boolean (p_init_msg_list)

Line 1399: IF fnd_api.to_boolean (p_init_msg_list)

1395: RAISE fnd_api.g_exc_unexpected_error;
1396: END IF;
1397:
1398: -- Initialize message list if p_init_msg_list is set to TRUE.
1399: IF fnd_api.to_boolean (p_init_msg_list)
1400: THEN
1401: fnd_msg_pub.initialize;
1402: END IF;
1403:

Line 1405: x_return_status := fnd_api.g_ret_sts_success;

1401: fnd_msg_pub.initialize;
1402: END IF;
1403:
1404: -- Initialize API return status to success
1405: x_return_status := fnd_api.g_ret_sts_success;
1406:
1407: -- API body
1408: IF p_plan_element.quota_id IS NULL
1409: THEN

Line 1425: IF (x_return_status <> fnd_api.g_ret_sts_success)

1421: x_msg_data => x_msg_data
1422: );
1423:
1424: -- raise an error if validate was not successful
1425: IF (x_return_status <> fnd_api.g_ret_sts_success)
1426: THEN
1427: RAISE fnd_api.g_exc_error;
1428: END IF;
1429:

Line 1427: RAISE fnd_api.g_exc_error;

1423:
1424: -- raise an error if validate was not successful
1425: IF (x_return_status <> fnd_api.g_ret_sts_success)
1426: THEN
1427: RAISE fnd_api.g_exc_error;
1428: END IF;
1429:
1430: -- update the account ids the UIs give a concatenated code
1431: validate_and_update_ccids (p_plan_element);

Line 1503: IF (x_return_status <> fnd_api.g_ret_sts_success)

1499: cn_rt_quota_asgns_pkg.INSERT_RECORD (x_quota_id => p_plan_element.quota_id, x_calc_formula_id => p_plan_element.calc_formula_id);
1500: END IF;
1501:
1502: -- Raise an Error if the Status is Failedx
1503: IF (x_return_status <> fnd_api.g_ret_sts_success)
1504: THEN
1505: RAISE fnd_api.g_exc_error;
1506: END IF;
1507: -- Calling proc to add system note for create

Line 1505: RAISE fnd_api.g_exc_error;

1501:
1502: -- Raise an Error if the Status is Failedx
1503: IF (x_return_status <> fnd_api.g_ret_sts_success)
1504: THEN
1505: RAISE fnd_api.g_exc_error;
1506: END IF;
1507: -- Calling proc to add system note for create
1508: add_system_note(
1509: p_plan_element,

Line 1516: IF (x_return_status <> fnd_api.g_ret_sts_success)

1512: x_return_status,
1513: x_msg_count,
1514: x_msg_data
1515: );
1516: IF (x_return_status <> fnd_api.g_ret_sts_success)
1517: THEN
1518: RAISE fnd_api.g_exc_error;
1519: END IF;
1520:

Line 1518: RAISE fnd_api.g_exc_error;

1514: x_msg_data
1515: );
1516: IF (x_return_status <> fnd_api.g_ret_sts_success)
1517: THEN
1518: RAISE fnd_api.g_exc_error;
1519: END IF;
1520:
1521: -- End of API body.
1522: -- Standard check of p_commit.

Line 1523: IF fnd_api.to_boolean (p_commit)

1519: END IF;
1520:
1521: -- End of API body.
1522: -- Standard check of p_commit.
1523: IF fnd_api.to_boolean (p_commit)
1524: THEN
1525: COMMIT WORK;
1526: END IF;
1527:

Line 1529: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1525: COMMIT WORK;
1526: END IF;
1527:
1528: -- Standard call to get message count and if count is 1, get message info.
1529: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1530: EXCEPTION
1531: WHEN fnd_api.g_exc_error
1532: THEN
1533: ROLLBACK TO create_plan_element;

Line 1531: WHEN fnd_api.g_exc_error

1527:
1528: -- Standard call to get message count and if count is 1, get message info.
1529: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1530: EXCEPTION
1531: WHEN fnd_api.g_exc_error
1532: THEN
1533: ROLLBACK TO create_plan_element;
1534: x_return_status := fnd_api.g_ret_sts_error;
1535: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 1534: x_return_status := fnd_api.g_ret_sts_error;

1530: EXCEPTION
1531: WHEN fnd_api.g_exc_error
1532: THEN
1533: ROLLBACK TO create_plan_element;
1534: x_return_status := fnd_api.g_ret_sts_error;
1535: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1536: WHEN fnd_api.g_exc_unexpected_error
1537: THEN
1538: ROLLBACK TO create_plan_element;

Line 1535: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1531: WHEN fnd_api.g_exc_error
1532: THEN
1533: ROLLBACK TO create_plan_element;
1534: x_return_status := fnd_api.g_ret_sts_error;
1535: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1536: WHEN fnd_api.g_exc_unexpected_error
1537: THEN
1538: ROLLBACK TO create_plan_element;
1539: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1536: WHEN fnd_api.g_exc_unexpected_error

1532: THEN
1533: ROLLBACK TO create_plan_element;
1534: x_return_status := fnd_api.g_ret_sts_error;
1535: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1536: WHEN fnd_api.g_exc_unexpected_error
1537: THEN
1538: ROLLBACK TO create_plan_element;
1539: x_return_status := fnd_api.g_ret_sts_unexp_error;
1540: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 1539: x_return_status := fnd_api.g_ret_sts_unexp_error;

1535: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1536: WHEN fnd_api.g_exc_unexpected_error
1537: THEN
1538: ROLLBACK TO create_plan_element;
1539: x_return_status := fnd_api.g_ret_sts_unexp_error;
1540: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1541: WHEN OTHERS
1542: THEN
1543: ROLLBACK TO create_plan_element;

Line 1540: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1536: WHEN fnd_api.g_exc_unexpected_error
1537: THEN
1538: ROLLBACK TO create_plan_element;
1539: x_return_status := fnd_api.g_ret_sts_unexp_error;
1540: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1541: WHEN OTHERS
1542: THEN
1543: ROLLBACK TO create_plan_element;
1544: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1544: x_return_status := fnd_api.g_ret_sts_unexp_error;

1540: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1541: WHEN OTHERS
1542: THEN
1543: ROLLBACK TO create_plan_element;
1544: x_return_status := fnd_api.g_ret_sts_unexp_error;
1545:
1546: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1547: THEN
1548: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1551: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1547: THEN
1548: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1549: END IF;
1550:
1551: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1552: END create_plan_element;
1553:
1554: -- Start of comments
1555: -- API name : Update_Plan_Element

Line 1562: -- Default = FND_API.G_FALSE

1558: -- Pre-reqs : None.
1559: -- Parameters :
1560: -- IN : p_api_version IN NUMBER Required
1561: -- p_init_msg_list IN VARCHAR2 Optional
1562: -- Default = FND_API.G_FALSE
1563: -- p_commit IN VARCHAR2 Optional
1564: -- Default = FND_API.G_FALSE
1565: -- p_validation_level IN NUMBER Optional
1566: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1564: -- Default = FND_API.G_FALSE

1560: -- IN : p_api_version IN NUMBER Required
1561: -- p_init_msg_list IN VARCHAR2 Optional
1562: -- Default = FND_API.G_FALSE
1563: -- p_commit IN VARCHAR2 Optional
1564: -- Default = FND_API.G_FALSE
1565: -- p_validation_level IN NUMBER Optional
1566: -- Default = FND_API.G_VALID_LEVEL_FULL
1567: -- p_plan_element IN plan_element_rec_type
1568: -- OUT : x_return_status OUT VARCHAR2(1)

Line 1566: -- Default = FND_API.G_VALID_LEVEL_FULL

1562: -- Default = FND_API.G_FALSE
1563: -- p_commit IN VARCHAR2 Optional
1564: -- Default = FND_API.G_FALSE
1565: -- p_validation_level IN NUMBER Optional
1566: -- Default = FND_API.G_VALID_LEVEL_FULL
1567: -- p_plan_element IN plan_element_rec_type
1568: -- OUT : x_return_status OUT VARCHAR2(1)
1569: -- x_msg_count OUT NUMBER
1570: -- x_msg_data OUT VARCHAR2(2000)

Line 1577: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1573: --
1574: -- End of comments
1575: PROCEDURE update_plan_element (
1576: p_api_version IN NUMBER,
1577: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1578: p_commit IN VARCHAR2 := fnd_api.g_false,
1579: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1580: p_plan_element IN OUT NOCOPY plan_element_rec_type,
1581: x_return_status OUT NOCOPY VARCHAR2,

Line 1578: p_commit IN VARCHAR2 := fnd_api.g_false,

1574: -- End of comments
1575: PROCEDURE update_plan_element (
1576: p_api_version IN NUMBER,
1577: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1578: p_commit IN VARCHAR2 := fnd_api.g_false,
1579: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1580: p_plan_element IN OUT NOCOPY plan_element_rec_type,
1581: x_return_status OUT NOCOPY VARCHAR2,
1582: x_msg_count OUT NOCOPY NUMBER,

Line 1579: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

1575: PROCEDURE update_plan_element (
1576: p_api_version IN NUMBER,
1577: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1578: p_commit IN VARCHAR2 := fnd_api.g_false,
1579: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1580: p_plan_element IN OUT NOCOPY plan_element_rec_type,
1581: x_return_status OUT NOCOPY VARCHAR2,
1582: x_msg_count OUT NOCOPY NUMBER,
1583: x_msg_data OUT NOCOPY VARCHAR2

Line 1685: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

1681: -- Standard Start of API savepoint
1682: SAVEPOINT update_plan_element;
1683:
1684: -- Standard call to check for call compatibility.
1685: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1686: THEN
1687: RAISE fnd_api.g_exc_unexpected_error;
1688: END IF;
1689:

Line 1687: RAISE fnd_api.g_exc_unexpected_error;

1683:
1684: -- Standard call to check for call compatibility.
1685: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1686: THEN
1687: RAISE fnd_api.g_exc_unexpected_error;
1688: END IF;
1689:
1690: -- Initialize message list if p_init_msg_list is set to TRUE.
1691: IF fnd_api.to_boolean (p_init_msg_list)

Line 1691: IF fnd_api.to_boolean (p_init_msg_list)

1687: RAISE fnd_api.g_exc_unexpected_error;
1688: END IF;
1689:
1690: -- Initialize message list if p_init_msg_list is set to TRUE.
1691: IF fnd_api.to_boolean (p_init_msg_list)
1692: THEN
1693: fnd_msg_pub.initialize;
1694: END IF;
1695:

Line 1697: x_return_status := fnd_api.g_ret_sts_success;

1693: fnd_msg_pub.initialize;
1694: END IF;
1695:
1696: -- Initialize API return status to success
1697: x_return_status := fnd_api.g_ret_sts_success;
1698: l_old_plan_element := get_plan_element (p_plan_element.quota_id);
1699: -- validate the plan element
1700: validate_plan_element (p_api_version => p_api_version,
1701: p_plan_element => p_plan_element,

Line 1710: IF (x_return_status <> fnd_api.g_ret_sts_success)

1706: x_msg_data => x_msg_data
1707: );
1708:
1709: -- in case of error, raise exception
1710: IF (x_return_status <> fnd_api.g_ret_sts_success)
1711: THEN
1712: RAISE fnd_api.g_exc_error;
1713: END IF;
1714:

Line 1712: RAISE fnd_api.g_exc_error;

1708:
1709: -- in case of error, raise exception
1710: IF (x_return_status <> fnd_api.g_ret_sts_success)
1711: THEN
1712: RAISE fnd_api.g_exc_error;
1713: END IF;
1714:
1715: -- Check the Plan Element start date and end date fall with in the rt_formula_asgns
1716: IF p_plan_element.calc_formula_id IS NOT NULL

Line 1732: IF (x_return_status <> fnd_api.g_ret_sts_success)

1728: x_loading_status := l_loading_status;
1729: END IF;
1730:
1731: -- error if the status is not success
1732: IF (x_return_status <> fnd_api.g_ret_sts_success)
1733: THEN
1734: RAISE fnd_api.g_exc_error;
1735: END IF;
1736: END IF;

Line 1734: RAISE fnd_api.g_exc_error;

1730:
1731: -- error if the status is not success
1732: IF (x_return_status <> fnd_api.g_ret_sts_success)
1733: THEN
1734: RAISE fnd_api.g_exc_error;
1735: END IF;
1736: END IF;
1737:
1738:

Line 1829: OR NVL (p_plan_element.end_date, fnd_api.g_miss_date)

1825: END IF;
1826: -- Commented out for Bug 4722521------------------------------------------------
1827: -- delete period quotas and distribute them again
1828: IF l_old_plan_element.start_date <> p_plan_element.start_date
1829: OR NVL (p_plan_element.end_date, fnd_api.g_miss_date)
1830: <> NVL (l_old_plan_element.end_date, fnd_api.g_miss_date)
1831: THEN
1832: -- Call the Table Handler to Delete the Old Period quotas
1833: -- cn_period_quotas_pkg.DELETE_RECORD (p_plan_element.quota_id);

Line 1830: <> NVL (l_old_plan_element.end_date, fnd_api.g_miss_date)

1826: -- Commented out for Bug 4722521------------------------------------------------
1827: -- delete period quotas and distribute them again
1828: IF l_old_plan_element.start_date <> p_plan_element.start_date
1829: OR NVL (p_plan_element.end_date, fnd_api.g_miss_date)
1830: <> NVL (l_old_plan_element.end_date, fnd_api.g_miss_date)
1831: THEN
1832: -- Call the Table Handler to Delete the Old Period quotas
1833: -- cn_period_quotas_pkg.DELETE_RECORD (p_plan_element.quota_id);
1834: cn_period_quotas_pkg.distribute_target (p_plan_element.quota_id);

Line 1928: IF (x_return_status <> fnd_api.g_ret_sts_success)

1924: x_loading_status => l_loading_status
1925: );
1926: x_loading_status := l_loading_status;
1927:
1928: IF (x_return_status <> fnd_api.g_ret_sts_success)
1929: THEN
1930: RAISE fnd_api.g_exc_error;
1931: END IF;
1932:

Line 1930: RAISE fnd_api.g_exc_error;

1926: x_loading_status := l_loading_status;
1927:
1928: IF (x_return_status <> fnd_api.g_ret_sts_success)
1929: THEN
1930: RAISE fnd_api.g_exc_error;
1931: END IF;
1932:
1933: -- Calling proc to add system note for update
1934: add_system_note(

Line 1942: IF (x_return_status <> fnd_api.g_ret_sts_success)

1938: x_return_status,
1939: x_msg_count,
1940: x_msg_data
1941: );
1942: IF (x_return_status <> fnd_api.g_ret_sts_success)
1943: THEN
1944: RAISE fnd_api.g_exc_error;
1945: END IF;
1946:

Line 1944: RAISE fnd_api.g_exc_error;

1940: x_msg_data
1941: );
1942: IF (x_return_status <> fnd_api.g_ret_sts_success)
1943: THEN
1944: RAISE fnd_api.g_exc_error;
1945: END IF;
1946:
1947: -- End of API body.
1948: -- Standard check of p_commit.

Line 1949: IF fnd_api.to_boolean (p_commit)

1945: END IF;
1946:
1947: -- End of API body.
1948: -- Standard check of p_commit.
1949: IF fnd_api.to_boolean (p_commit)
1950: THEN
1951: COMMIT WORK;
1952: END IF;
1953:

Line 1955: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1951: COMMIT WORK;
1952: END IF;
1953:
1954: -- Standard call to get message count and if count is 1, get message info.
1955: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1956: EXCEPTION
1957: WHEN fnd_api.g_exc_error
1958: THEN
1959: ROLLBACK TO update_plan_element;

Line 1957: WHEN fnd_api.g_exc_error

1953:
1954: -- Standard call to get message count and if count is 1, get message info.
1955: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1956: EXCEPTION
1957: WHEN fnd_api.g_exc_error
1958: THEN
1959: ROLLBACK TO update_plan_element;
1960: x_return_status := fnd_api.g_ret_sts_error;
1961: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 1960: x_return_status := fnd_api.g_ret_sts_error;

1956: EXCEPTION
1957: WHEN fnd_api.g_exc_error
1958: THEN
1959: ROLLBACK TO update_plan_element;
1960: x_return_status := fnd_api.g_ret_sts_error;
1961: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1962: WHEN fnd_api.g_exc_unexpected_error
1963: THEN
1964: ROLLBACK TO update_plan_element;

Line 1961: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1957: WHEN fnd_api.g_exc_error
1958: THEN
1959: ROLLBACK TO update_plan_element;
1960: x_return_status := fnd_api.g_ret_sts_error;
1961: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1962: WHEN fnd_api.g_exc_unexpected_error
1963: THEN
1964: ROLLBACK TO update_plan_element;
1965: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1962: WHEN fnd_api.g_exc_unexpected_error

1958: THEN
1959: ROLLBACK TO update_plan_element;
1960: x_return_status := fnd_api.g_ret_sts_error;
1961: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1962: WHEN fnd_api.g_exc_unexpected_error
1963: THEN
1964: ROLLBACK TO update_plan_element;
1965: x_return_status := fnd_api.g_ret_sts_unexp_error;
1966: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 1965: x_return_status := fnd_api.g_ret_sts_unexp_error;

1961: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1962: WHEN fnd_api.g_exc_unexpected_error
1963: THEN
1964: ROLLBACK TO update_plan_element;
1965: x_return_status := fnd_api.g_ret_sts_unexp_error;
1966: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1967: WHEN OTHERS
1968: THEN
1969: ROLLBACK TO update_plan_element;

Line 1966: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1962: WHEN fnd_api.g_exc_unexpected_error
1963: THEN
1964: ROLLBACK TO update_plan_element;
1965: x_return_status := fnd_api.g_ret_sts_unexp_error;
1966: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1967: WHEN OTHERS
1968: THEN
1969: ROLLBACK TO update_plan_element;
1970: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1970: x_return_status := fnd_api.g_ret_sts_unexp_error;

1966: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1967: WHEN OTHERS
1968: THEN
1969: ROLLBACK TO update_plan_element;
1970: x_return_status := fnd_api.g_ret_sts_unexp_error;
1971:
1972: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1973: THEN
1974: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1977: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1973: THEN
1974: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1975: END IF;
1976:
1977: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1978: END update_plan_element;
1979:
1980: -- Start of comments
1981: -- API name : Delete_Plan_Element

Line 1988: -- Default = FND_API.G_FALSE

1984: -- Pre-reqs : None.
1985: -- Parameters :
1986: -- IN : p_api_version IN NUMBER Required
1987: -- p_init_msg_list IN VARCHAR2 Optional
1988: -- Default = FND_API.G_FALSE
1989: -- p_commit IN VARCHAR2 Optional
1990: -- Default = FND_API.G_FALSE
1991: -- p_validation_level IN NUMBER Optional
1992: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1990: -- Default = FND_API.G_FALSE

1986: -- IN : p_api_version IN NUMBER Required
1987: -- p_init_msg_list IN VARCHAR2 Optional
1988: -- Default = FND_API.G_FALSE
1989: -- p_commit IN VARCHAR2 Optional
1990: -- Default = FND_API.G_FALSE
1991: -- p_validation_level IN NUMBER Optional
1992: -- Default = FND_API.G_VALID_LEVEL_FULL
1993: -- p_plan_element IN plan_element_rec_type
1994: -- OUT : x_return_status OUT VARCHAR2(1)

Line 1992: -- Default = FND_API.G_VALID_LEVEL_FULL

1988: -- Default = FND_API.G_FALSE
1989: -- p_commit IN VARCHAR2 Optional
1990: -- Default = FND_API.G_FALSE
1991: -- p_validation_level IN NUMBER Optional
1992: -- Default = FND_API.G_VALID_LEVEL_FULL
1993: -- p_plan_element IN plan_element_rec_type
1994: -- OUT : x_return_status OUT VARCHAR2(1)
1995: -- x_msg_count OUT NUMBER
1996: -- x_msg_data OUT VARCHAR2(2000)

Line 2003: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1999: --
2000: -- End of comments
2001: PROCEDURE delete_plan_element (
2002: p_api_version IN NUMBER,
2003: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2004: p_commit IN VARCHAR2 := fnd_api.g_false,
2005: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2006: p_plan_element IN OUT NOCOPY plan_element_rec_type,
2007: x_return_status OUT NOCOPY VARCHAR2,

Line 2004: p_commit IN VARCHAR2 := fnd_api.g_false,

2000: -- End of comments
2001: PROCEDURE delete_plan_element (
2002: p_api_version IN NUMBER,
2003: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2004: p_commit IN VARCHAR2 := fnd_api.g_false,
2005: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2006: p_plan_element IN OUT NOCOPY plan_element_rec_type,
2007: x_return_status OUT NOCOPY VARCHAR2,
2008: x_msg_count OUT NOCOPY NUMBER,

Line 2005: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

2001: PROCEDURE delete_plan_element (
2002: p_api_version IN NUMBER,
2003: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2004: p_commit IN VARCHAR2 := fnd_api.g_false,
2005: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2006: p_plan_element IN OUT NOCOPY plan_element_rec_type,
2007: x_return_status OUT NOCOPY VARCHAR2,
2008: x_msg_count OUT NOCOPY NUMBER,
2009: x_msg_data OUT NOCOPY VARCHAR2

Line 2020: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

2016: -- Standard Start of API savepoint
2017: SAVEPOINT delete_plan_element;
2018:
2019: -- Standard call to check for call compatibility.
2020: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2021: THEN
2022: RAISE fnd_api.g_exc_unexpected_error;
2023: END IF;
2024:

Line 2022: RAISE fnd_api.g_exc_unexpected_error;

2018:
2019: -- Standard call to check for call compatibility.
2020: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2021: THEN
2022: RAISE fnd_api.g_exc_unexpected_error;
2023: END IF;
2024:
2025: -- Initialize message list if p_init_msg_list is set to TRUE.
2026: IF fnd_api.to_boolean (p_init_msg_list)

Line 2026: IF fnd_api.to_boolean (p_init_msg_list)

2022: RAISE fnd_api.g_exc_unexpected_error;
2023: END IF;
2024:
2025: -- Initialize message list if p_init_msg_list is set to TRUE.
2026: IF fnd_api.to_boolean (p_init_msg_list)
2027: THEN
2028: fnd_msg_pub.initialize;
2029: END IF;
2030:

Line 2032: x_return_status := fnd_api.g_ret_sts_success;

2028: fnd_msg_pub.initialize;
2029: END IF;
2030:
2031: -- Initialize API return status to success
2032: x_return_status := fnd_api.g_ret_sts_success;
2033: -- validate plan element
2034: validate_plan_element (p_api_version => p_api_version,
2035: p_plan_element => p_plan_element,
2036: p_action => 'DELETE',

Line 2042: IF (x_return_status <> fnd_api.g_ret_sts_success)

2038: x_msg_count => x_msg_count,
2039: x_msg_data => x_msg_data
2040: );
2041:
2042: IF (x_return_status <> fnd_api.g_ret_sts_success)
2043: THEN
2044: RAISE fnd_api.g_exc_error;
2045: END IF;
2046:

Line 2044: RAISE fnd_api.g_exc_error;

2040: );
2041:
2042: IF (x_return_status <> fnd_api.g_ret_sts_success)
2043: THEN
2044: RAISE fnd_api.g_exc_error;
2045: END IF;
2046:
2047: -- API body
2048: SELECT NAME

Line 2065: IF (x_return_status <> fnd_api.g_ret_sts_success)

2061: x_return_status,
2062: x_msg_count,
2063: x_msg_data
2064: );
2065: IF (x_return_status <> fnd_api.g_ret_sts_success)
2066: THEN
2067: RAISE fnd_api.g_exc_error;
2068: END IF;
2069:

Line 2067: RAISE fnd_api.g_exc_error;

2063: x_msg_data
2064: );
2065: IF (x_return_status <> fnd_api.g_ret_sts_success)
2066: THEN
2067: RAISE fnd_api.g_exc_error;
2068: END IF;
2069:
2070: -- End of API body.
2071: -- Standard check of p_commit.

Line 2072: IF fnd_api.to_boolean (p_commit)

2068: END IF;
2069:
2070: -- End of API body.
2071: -- Standard check of p_commit.
2072: IF fnd_api.to_boolean (p_commit)
2073: THEN
2074: COMMIT WORK;
2075: END IF;
2076:

Line 2078: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2074: COMMIT WORK;
2075: END IF;
2076:
2077: -- Standard call to get message count and if count is 1, get message info.
2078: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2079: EXCEPTION
2080: WHEN fnd_api.g_exc_error
2081: THEN
2082: ROLLBACK TO delete_plan_element;

Line 2080: WHEN fnd_api.g_exc_error

2076:
2077: -- Standard call to get message count and if count is 1, get message info.
2078: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2079: EXCEPTION
2080: WHEN fnd_api.g_exc_error
2081: THEN
2082: ROLLBACK TO delete_plan_element;
2083: x_return_status := fnd_api.g_ret_sts_error;
2084: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 2083: x_return_status := fnd_api.g_ret_sts_error;

2079: EXCEPTION
2080: WHEN fnd_api.g_exc_error
2081: THEN
2082: ROLLBACK TO delete_plan_element;
2083: x_return_status := fnd_api.g_ret_sts_error;
2084: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2085: WHEN fnd_api.g_exc_unexpected_error
2086: THEN
2087: ROLLBACK TO delete_plan_element;

Line 2084: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2080: WHEN fnd_api.g_exc_error
2081: THEN
2082: ROLLBACK TO delete_plan_element;
2083: x_return_status := fnd_api.g_ret_sts_error;
2084: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2085: WHEN fnd_api.g_exc_unexpected_error
2086: THEN
2087: ROLLBACK TO delete_plan_element;
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2085: WHEN fnd_api.g_exc_unexpected_error

2081: THEN
2082: ROLLBACK TO delete_plan_element;
2083: x_return_status := fnd_api.g_ret_sts_error;
2084: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2085: WHEN fnd_api.g_exc_unexpected_error
2086: THEN
2087: ROLLBACK TO delete_plan_element;
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2089: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 2088: x_return_status := fnd_api.g_ret_sts_unexp_error;

2084: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2085: WHEN fnd_api.g_exc_unexpected_error
2086: THEN
2087: ROLLBACK TO delete_plan_element;
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2089: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2090: WHEN OTHERS
2091: THEN
2092: ROLLBACK TO delete_plan_element;

Line 2089: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2085: WHEN fnd_api.g_exc_unexpected_error
2086: THEN
2087: ROLLBACK TO delete_plan_element;
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2089: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2090: WHEN OTHERS
2091: THEN
2092: ROLLBACK TO delete_plan_element;
2093: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2093: x_return_status := fnd_api.g_ret_sts_unexp_error;

2089: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2090: WHEN OTHERS
2091: THEN
2092: ROLLBACK TO delete_plan_element;
2093: x_return_status := fnd_api.g_ret_sts_unexp_error;
2094:
2095: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2096: THEN
2097: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 2100: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2096: THEN
2097: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2098: END IF;
2099:
2100: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2101: END delete_plan_element;
2102:
2103: -- Start of comments
2104: -- API name : Validate_Plan_Element

Line 2111: -- Default = FND_API.G_FALSE

2107: -- Pre-reqs : None.
2108: -- Parameters :
2109: -- IN : p_api_version IN NUMBER Required
2110: -- p_init_msg_list IN VARCHAR2 Optional
2111: -- Default = FND_API.G_FALSE
2112: -- p_commit IN VARCHAR2 Optional
2113: -- Default = FND_API.G_FALSE
2114: -- p_validation_level IN NUMBER Optional
2115: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 2113: -- Default = FND_API.G_FALSE

2109: -- IN : p_api_version IN NUMBER Required
2110: -- p_init_msg_list IN VARCHAR2 Optional
2111: -- Default = FND_API.G_FALSE
2112: -- p_commit IN VARCHAR2 Optional
2113: -- Default = FND_API.G_FALSE
2114: -- p_validation_level IN NUMBER Optional
2115: -- Default = FND_API.G_VALID_LEVEL_FULL
2116: -- p_plan_element IN plan_element_rec_type
2117: -- OUT : x_return_status OUT VARCHAR2(1)

Line 2115: -- Default = FND_API.G_VALID_LEVEL_FULL

2111: -- Default = FND_API.G_FALSE
2112: -- p_commit IN VARCHAR2 Optional
2113: -- Default = FND_API.G_FALSE
2114: -- p_validation_level IN NUMBER Optional
2115: -- Default = FND_API.G_VALID_LEVEL_FULL
2116: -- p_plan_element IN plan_element_rec_type
2117: -- OUT : x_return_status OUT VARCHAR2(1)
2118: -- x_msg_count OUT NUMBER
2119: -- x_msg_data OUT VARCHAR2(2000)

Line 2126: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

2122: --
2123: -- End of comments
2124: PROCEDURE validate_plan_element (
2125: p_api_version IN NUMBER,
2126: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2127: p_commit IN VARCHAR2 := fnd_api.g_false,
2128: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2129: p_action IN VARCHAR2,
2130: p_plan_element IN OUT NOCOPY plan_element_rec_type,

Line 2127: p_commit IN VARCHAR2 := fnd_api.g_false,

2123: -- End of comments
2124: PROCEDURE validate_plan_element (
2125: p_api_version IN NUMBER,
2126: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2127: p_commit IN VARCHAR2 := fnd_api.g_false,
2128: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2129: p_action IN VARCHAR2,
2130: p_plan_element IN OUT NOCOPY plan_element_rec_type,
2131: p_old_plan_element IN plan_element_rec_type := NULL,

Line 2128: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

2124: PROCEDURE validate_plan_element (
2125: p_api_version IN NUMBER,
2126: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2127: p_commit IN VARCHAR2 := fnd_api.g_false,
2128: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2129: p_action IN VARCHAR2,
2130: p_plan_element IN OUT NOCOPY plan_element_rec_type,
2131: p_old_plan_element IN plan_element_rec_type := NULL,
2132: x_return_status OUT NOCOPY VARCHAR2,

Line 2160: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

2156: -- Standard Start of API savepoint
2157: SAVEPOINT validate_plan_element;
2158:
2159: -- Standard call to check for call compatibility.
2160: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2161: THEN
2162: RAISE fnd_api.g_exc_unexpected_error;
2163: END IF;
2164:

Line 2162: RAISE fnd_api.g_exc_unexpected_error;

2158:
2159: -- Standard call to check for call compatibility.
2160: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2161: THEN
2162: RAISE fnd_api.g_exc_unexpected_error;
2163: END IF;
2164:
2165: -- Initialize message list if p_init_msg_list is set to TRUE.
2166: IF fnd_api.to_boolean (p_init_msg_list)

Line 2166: IF fnd_api.to_boolean (p_init_msg_list)

2162: RAISE fnd_api.g_exc_unexpected_error;
2163: END IF;
2164:
2165: -- Initialize message list if p_init_msg_list is set to TRUE.
2166: IF fnd_api.to_boolean (p_init_msg_list)
2167: THEN
2168: fnd_msg_pub.initialize;
2169: END IF;
2170:

Line 2172: x_return_status := fnd_api.g_ret_sts_success;

2168: fnd_msg_pub.initialize;
2169: END IF;
2170:
2171: -- Initialize API return status to success
2172: x_return_status := fnd_api.g_ret_sts_success;
2173: p_plan_element.start_date := TRUNC (p_plan_element.start_date);
2174: p_plan_element.end_date := TRUNC (p_plan_element.end_date);
2175:
2176:

Line 2193: RAISE fnd_api.g_exc_error;

2189: fnd_message.set_name ('CN', 'CN_INVALID_DEL_REC');
2190: fnd_msg_pub.ADD;
2191: END IF;
2192:
2193: RAISE fnd_api.g_exc_error;
2194: END IF;
2195:
2196: -- check whether the plan element is already assigned to a complan
2197: BEGIN

Line 2212: RAISE fnd_api.g_exc_error;

2208: THEN
2209: fnd_message.set_name ('CN', 'PLN_QUOTA_DELETE_NA');
2210: fnd_msg_pub.ADD;
2211: END IF;
2212: RAISE fnd_api.g_exc_error;
2213: END;
2214: ELSE
2215: -- check whether user has access to this org
2216: IF (p_action = 'UPDATE')

Line 2221: RAISE fnd_api.g_exc_error;

2217: THEN
2218: -- better check that org_id first or you will cry
2219: IF NOT is_valid_org (p_plan_element.org_id, p_plan_element.quota_id)
2220: THEN
2221: RAISE fnd_api.g_exc_error;
2222: END IF;
2223:
2224: -- 1. check object version number
2225: IF p_old_plan_element.object_version_number <> p_plan_element.object_version_number

Line 2233: RAISE fnd_api.g_exc_error;

2229: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
2230: fnd_msg_pub.ADD;
2231: END IF;
2232:
2233: RAISE fnd_api.g_exc_error;
2234: END IF;
2235:
2236: -- 2. plan element name must be unique
2237: SELECT COUNT (1)

Line 2251: RAISE fnd_api.g_exc_error;

2247: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2248: fnd_msg_pub.ADD;
2249: END IF;
2250:
2251: RAISE fnd_api.g_exc_error;
2252: END IF;
2253:
2254: --Added by hanaraya for bug 6505174
2255: -- Check for date range overlap between plan element and quota rule uplifts

Line 2271: RAISE fnd_api.g_exc_error;

2267: THEN
2268: fnd_message.set_name ('CN', 'CN_UPLIFT_DT_NOT_WIN_QUOTA');
2269: fnd_msg_pub.ADD;
2270: END IF;
2271: RAISE fnd_api.g_exc_error;
2272: END IF;
2273:
2274: ELSIF (p_action = 'CREATE')
2275: THEN

Line 2279: RAISE fnd_api.g_exc_error;

2275: THEN
2276: -- better check that org_id first or you will cry
2277: IF NOT is_valid_org (p_plan_element.org_id)
2278: THEN
2279: RAISE fnd_api.g_exc_error;
2280: END IF;
2281:
2282: -- 2. plan element name must be unique
2283: SELECT COUNT (1)

Line 2297: RAISE fnd_api.g_exc_error;

2293: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2294: fnd_msg_pub.ADD;
2295: END IF;
2296:
2297: RAISE fnd_api.g_exc_error;
2298: END IF;
2299: END IF;
2300:
2301: --###########################################################################

Line 2306: IF (p_plan_element.NAME IS NULL) OR (p_plan_element.NAME = fnd_api.g_miss_char)

2302: --## VALIDATION FOR BOTH UPDATE AND CREATE
2303: --###########################################################################
2304:
2305: -- 1. name can not be null
2306: IF (p_plan_element.NAME IS NULL) OR (p_plan_element.NAME = fnd_api.g_miss_char)
2307: THEN
2308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2309: THEN
2310: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');

Line 2315: RAISE fnd_api.g_exc_error;

2311: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2312: fnd_msg_pub.ADD;
2313: END IF;
2314:
2315: RAISE fnd_api.g_exc_error;
2316: END IF;
2317:
2318: -- start date is not null
2319: IF (p_plan_element.start_date IS NULL) OR (p_plan_element.start_date = fnd_api.g_miss_date)

Line 2319: IF (p_plan_element.start_date IS NULL) OR (p_plan_element.start_date = fnd_api.g_miss_date)

2315: RAISE fnd_api.g_exc_error;
2316: END IF;
2317:
2318: -- start date is not null
2319: IF (p_plan_element.start_date IS NULL) OR (p_plan_element.start_date = fnd_api.g_miss_date)
2320: THEN
2321: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2322: THEN
2323: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');

Line 2328: RAISE fnd_api.g_exc_error;

2324: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('SD', 'INPUT_TOKEN'));
2325: fnd_msg_pub.ADD;
2326: END IF;
2327:
2328: RAISE fnd_api.g_exc_error;
2329: END IF;
2330:
2331: -- start date > end date
2332: IF (p_plan_element.end_date IS NOT NULL) AND (p_plan_element.start_date > p_plan_element.end_date)

Line 2340: RAISE fnd_api.g_exc_error;

2336: fnd_message.set_name ('CN', 'CN_DATE_RANGE_ERROR');
2337: fnd_msg_pub.ADD;
2338: END IF;
2339:
2340: RAISE fnd_api.g_exc_error;
2341: END IF;
2342:
2343:
2344:

Line 2361: RAISE fnd_api.g_exc_error;

2357: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));
2358: fnd_msg_pub.ADD;
2359: END IF;
2360:
2361: RAISE fnd_api.g_exc_error;
2362: END IF;
2363:
2364: IF (p_plan_element.payment_amount IS NULL)
2365: THEN

Line 2373: RAISE fnd_api.g_exc_error;

2369: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));
2370: fnd_msg_pub.ADD;
2371: END IF;
2372:
2373: RAISE fnd_api.g_exc_error;
2374: END IF;
2375:
2376: IF (p_plan_element.performance_goal IS NULL)
2377: THEN

Line 2385: RAISE fnd_api.g_exc_error;

2381: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));
2382: fnd_msg_pub.ADD;
2383: END IF;
2384:
2385: RAISE fnd_api.g_exc_error;
2386: END IF;
2387:
2388: IF (p_plan_element.payee_assign_flag NOT IN ('Y', 'N'))
2389: THEN

Line 2397: RAISE fnd_api.g_exc_error;

2393: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PAYEE_ASSIGN', 'PE_OBJECT_TYPE'));
2394: fnd_msg_pub.ADD;
2395: END IF;
2396:
2397: RAISE fnd_api.g_exc_error;
2398: END IF;
2399:
2400: IF p_plan_element.addup_from_rev_class_flag NOT IN ('Y', 'N')
2401: THEN

Line 2409: RAISE fnd_api.g_exc_error;

2405: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('ADD_FROM_REVCLASS', 'PE_OBJECT_TYPE'));
2406: fnd_msg_pub.ADD;
2407: END IF;
2408:
2409: RAISE fnd_api.g_exc_error;
2410: END IF;
2411:
2412:
2413: ---changes made for fixing the bug # 2739896

Line 2430: RAISE fnd_api.g_exc_error;

2426: IF (l_payeechk > 0)
2427: THEN
2428: fnd_message.set_name ('CN', 'CN_PAYEE_ASGN_FLAG_CHECK');
2429: fnd_msg_pub.ADD;
2430: RAISE fnd_api.g_exc_error;
2431: END IF;
2432: END IF;
2433: END IF; -- END OF DELETE VALIDATION
2434:

Line 2438: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2434:
2435: -- End of API body.
2436: <>
2437: -- Standard call to get message count and if count is 1, get message info.
2438: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2439: EXCEPTION
2440: WHEN fnd_api.g_exc_error
2441: THEN
2442: ROLLBACK TO validate_plan_element;

Line 2440: WHEN fnd_api.g_exc_error

2436: <>
2437: -- Standard call to get message count and if count is 1, get message info.
2438: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2439: EXCEPTION
2440: WHEN fnd_api.g_exc_error
2441: THEN
2442: ROLLBACK TO validate_plan_element;
2443: x_return_status := fnd_api.g_ret_sts_error;
2444: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 2443: x_return_status := fnd_api.g_ret_sts_error;

2439: EXCEPTION
2440: WHEN fnd_api.g_exc_error
2441: THEN
2442: ROLLBACK TO validate_plan_element;
2443: x_return_status := fnd_api.g_ret_sts_error;
2444: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2445: WHEN fnd_api.g_exc_unexpected_error
2446: THEN
2447: ROLLBACK TO validate_plan_element;

Line 2444: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2440: WHEN fnd_api.g_exc_error
2441: THEN
2442: ROLLBACK TO validate_plan_element;
2443: x_return_status := fnd_api.g_ret_sts_error;
2444: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2445: WHEN fnd_api.g_exc_unexpected_error
2446: THEN
2447: ROLLBACK TO validate_plan_element;
2448: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2445: WHEN fnd_api.g_exc_unexpected_error

2441: THEN
2442: ROLLBACK TO validate_plan_element;
2443: x_return_status := fnd_api.g_ret_sts_error;
2444: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2445: WHEN fnd_api.g_exc_unexpected_error
2446: THEN
2447: ROLLBACK TO validate_plan_element;
2448: x_return_status := fnd_api.g_ret_sts_unexp_error;
2449: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 2448: x_return_status := fnd_api.g_ret_sts_unexp_error;

2444: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2445: WHEN fnd_api.g_exc_unexpected_error
2446: THEN
2447: ROLLBACK TO validate_plan_element;
2448: x_return_status := fnd_api.g_ret_sts_unexp_error;
2449: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2450: WHEN OTHERS
2451: THEN
2452: ROLLBACK TO validate_plan_element;

Line 2449: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2445: WHEN fnd_api.g_exc_unexpected_error
2446: THEN
2447: ROLLBACK TO validate_plan_element;
2448: x_return_status := fnd_api.g_ret_sts_unexp_error;
2449: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2450: WHEN OTHERS
2451: THEN
2452: ROLLBACK TO validate_plan_element;
2453: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2453: x_return_status := fnd_api.g_ret_sts_unexp_error;

2449: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2450: WHEN OTHERS
2451: THEN
2452: ROLLBACK TO validate_plan_element;
2453: x_return_status := fnd_api.g_ret_sts_unexp_error;
2454:
2455: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2456: THEN
2457: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 2460: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2456: THEN
2457: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2458: END IF;
2459:
2460: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2461: END validate_plan_element;
2462:
2463: -- Start of comments
2464: -- API name : Duplicate_Plan_Element

Line 2581: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

2577:
2578: -- Check that the plan element is valid
2579: PROCEDURE validate_plan_element (
2580: p_api_version IN NUMBER,
2581: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2582: p_commit IN VARCHAR2 := fnd_api.g_false,
2583: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2584: p_comp_plan_id IN NUMBER := NULL,
2585: p_quota_id IN NUMBER,

Line 2582: p_commit IN VARCHAR2 := fnd_api.g_false,

2578: -- Check that the plan element is valid
2579: PROCEDURE validate_plan_element (
2580: p_api_version IN NUMBER,
2581: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2582: p_commit IN VARCHAR2 := fnd_api.g_false,
2583: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2584: p_comp_plan_id IN NUMBER := NULL,
2585: p_quota_id IN NUMBER,
2586: x_status_code OUT NOCOPY VARCHAR2,

Line 2583: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

2579: PROCEDURE validate_plan_element (
2580: p_api_version IN NUMBER,
2581: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2582: p_commit IN VARCHAR2 := fnd_api.g_false,
2583: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2584: p_comp_plan_id IN NUMBER := NULL,
2585: p_quota_id IN NUMBER,
2586: x_status_code OUT NOCOPY VARCHAR2,
2587: x_return_status OUT NOCOPY VARCHAR2,

Line 2642: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

2638: -- Standard Start of API savepoint
2639: SAVEPOINT validate_plan_element_2;
2640:
2641: -- Standard call to check for call compatibility.
2642: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2643: THEN
2644: RAISE fnd_api.g_exc_unexpected_error;
2645: END IF;
2646:

Line 2644: RAISE fnd_api.g_exc_unexpected_error;

2640:
2641: -- Standard call to check for call compatibility.
2642: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2643: THEN
2644: RAISE fnd_api.g_exc_unexpected_error;
2645: END IF;
2646:
2647: -- Initialize message list if p_init_msg_list is set to TRUE.
2648: IF fnd_api.to_boolean (p_init_msg_list)

Line 2648: IF fnd_api.to_boolean (p_init_msg_list)

2644: RAISE fnd_api.g_exc_unexpected_error;
2645: END IF;
2646:
2647: -- Initialize message list if p_init_msg_list is set to TRUE.
2648: IF fnd_api.to_boolean (p_init_msg_list)
2649: THEN
2650: fnd_msg_pub.initialize;
2651: END IF;
2652:

Line 2654: x_return_status := fnd_api.g_ret_sts_success;

2650: fnd_msg_pub.initialize;
2651: END IF;
2652:
2653: -- Initialize API return status to success
2654: x_return_status := fnd_api.g_ret_sts_success;
2655: -- fill the rec
2656: l_plan_element := get_plan_element (p_quota_id);
2657: -- validate the plan element
2658: validate_plan_element (p_api_version => p_api_version,

Line 2668: IF (x_return_status <> fnd_api.g_ret_sts_success)

2664: x_msg_data => x_msg_data
2665: );
2666:
2667: -- in case of error, raise exception
2668: IF (x_return_status <> fnd_api.g_ret_sts_success)
2669: THEN
2670: l_temp_status_code := g_incomplete;
2671: RAISE fnd_api.g_exc_error;
2672: END IF;

Line 2671: RAISE fnd_api.g_exc_error;

2667: -- in case of error, raise exception
2668: IF (x_return_status <> fnd_api.g_ret_sts_success)
2669: THEN
2670: l_temp_status_code := g_incomplete;
2671: RAISE fnd_api.g_exc_error;
2672: END IF;
2673:
2674: IF p_comp_plan_id IS NOT NULL
2675: THEN

Line 2822: IF fnd_api.to_boolean (p_commit)

2818: x_status_code := l_temp_status_code;
2819:
2820: -- End of API body.
2821: -- Standard check of p_commit.
2822: IF fnd_api.to_boolean (p_commit)
2823: THEN
2824: COMMIT WORK;
2825: END IF;
2826:

Line 2828: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2824: COMMIT WORK;
2825: END IF;
2826:
2827: -- Standard call to get message count and if count is 1, get message info.
2828: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2829: EXCEPTION
2830: WHEN fnd_api.g_exc_error
2831: THEN
2832: ROLLBACK TO validate_plan_element_2;

Line 2830: WHEN fnd_api.g_exc_error

2826:
2827: -- Standard call to get message count and if count is 1, get message info.
2828: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2829: EXCEPTION
2830: WHEN fnd_api.g_exc_error
2831: THEN
2832: ROLLBACK TO validate_plan_element_2;
2833: x_return_status := fnd_api.g_ret_sts_error;
2834: x_status_code := g_incomplete;

Line 2833: x_return_status := fnd_api.g_ret_sts_error;

2829: EXCEPTION
2830: WHEN fnd_api.g_exc_error
2831: THEN
2832: ROLLBACK TO validate_plan_element_2;
2833: x_return_status := fnd_api.g_ret_sts_error;
2834: x_status_code := g_incomplete;
2835: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2836: WHEN fnd_api.g_exc_unexpected_error
2837: THEN

Line 2835: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2831: THEN
2832: ROLLBACK TO validate_plan_element_2;
2833: x_return_status := fnd_api.g_ret_sts_error;
2834: x_status_code := g_incomplete;
2835: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2836: WHEN fnd_api.g_exc_unexpected_error
2837: THEN
2838: ROLLBACK TO validate_plan_element_2;
2839: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2836: WHEN fnd_api.g_exc_unexpected_error

2832: ROLLBACK TO validate_plan_element_2;
2833: x_return_status := fnd_api.g_ret_sts_error;
2834: x_status_code := g_incomplete;
2835: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2836: WHEN fnd_api.g_exc_unexpected_error
2837: THEN
2838: ROLLBACK TO validate_plan_element_2;
2839: x_return_status := fnd_api.g_ret_sts_unexp_error;
2840: x_status_code := g_incomplete;

Line 2839: x_return_status := fnd_api.g_ret_sts_unexp_error;

2835: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2836: WHEN fnd_api.g_exc_unexpected_error
2837: THEN
2838: ROLLBACK TO validate_plan_element_2;
2839: x_return_status := fnd_api.g_ret_sts_unexp_error;
2840: x_status_code := g_incomplete;
2841: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2842: WHEN OTHERS
2843: THEN

Line 2841: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2837: THEN
2838: ROLLBACK TO validate_plan_element_2;
2839: x_return_status := fnd_api.g_ret_sts_unexp_error;
2840: x_status_code := g_incomplete;
2841: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2842: WHEN OTHERS
2843: THEN
2844: ROLLBACK TO validate_plan_element_2;
2845: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2845: x_return_status := fnd_api.g_ret_sts_unexp_error;

2841: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2842: WHEN OTHERS
2843: THEN
2844: ROLLBACK TO validate_plan_element_2;
2845: x_return_status := fnd_api.g_ret_sts_unexp_error;
2846: x_status_code := g_incomplete;
2847:
2848: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2849: THEN

Line 2853: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2849: THEN
2850: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2851: END IF;
2852:
2853: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2854: END validate_plan_element;
2855: END cn_plan_element_pvt;