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: ------ Bug 8796904 ------
1716: -- Assiged quota to comp plan check if the start date and the end date changes.

Line 1718: Trunc(Nvl(p_plan_element.end_date,fnd_api.g_miss_date))

1714:
1715: ------ Bug 8796904 ------
1716: -- Assiged quota to comp plan check if the start date and the end date changes.
1717: IF Trunc(p_plan_element.start_date) <> Trunc(l_old_plan_element.start_date) OR
1718: Trunc(Nvl(p_plan_element.end_date,fnd_api.g_miss_date))
1719: <> Trunc(Nvl(l_old_plan_element.end_date,fnd_api.G_MISS_DATE )) THEN
1720:
1721: cn_chk_plan_element_pkg.chk_comp_plan_date
1722: (

Line 1719: <> Trunc(Nvl(l_old_plan_element.end_date,fnd_api.G_MISS_DATE )) THEN

1715: ------ Bug 8796904 ------
1716: -- Assiged quota to comp plan check if the start date and the end date changes.
1717: IF Trunc(p_plan_element.start_date) <> Trunc(l_old_plan_element.start_date) OR
1718: Trunc(Nvl(p_plan_element.end_date,fnd_api.g_miss_date))
1719: <> Trunc(Nvl(l_old_plan_element.end_date,fnd_api.G_MISS_DATE )) THEN
1720:
1721: cn_chk_plan_element_pkg.chk_comp_plan_date
1722: (
1723: x_return_status => x_return_status,

Line 1734: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1730: );
1731: x_loading_status := l_loading_status;
1732: END IF;
1733:
1734: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1735: RAISE FND_API.G_EXC_ERROR ;
1736: END IF;
1737:
1738:

Line 1735: RAISE FND_API.G_EXC_ERROR ;

1731: x_loading_status := l_loading_status;
1732: END IF;
1733:
1734: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1735: RAISE FND_API.G_EXC_ERROR ;
1736: END IF;
1737:
1738:
1739: -- Check the Plan Element start date and end date fall with in the rt_formula_asgns

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

1752: x_loading_status := l_loading_status;
1753: END IF;
1754:
1755: -- error if the status is not success
1756: IF (x_return_status <> fnd_api.g_ret_sts_success)
1757: THEN
1758: RAISE fnd_api.g_exc_error;
1759: END IF;
1760: END IF;

Line 1758: RAISE fnd_api.g_exc_error;

1754:
1755: -- error if the status is not success
1756: IF (x_return_status <> fnd_api.g_ret_sts_success)
1757: THEN
1758: RAISE fnd_api.g_exc_error;
1759: END IF;
1760: END IF;
1761:
1762:

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

1849: END IF;
1850: -- Commented out for Bug 4722521------------------------------------------------
1851: -- delete period quotas and distribute them again
1852: IF l_old_plan_element.start_date <> p_plan_element.start_date
1853: OR NVL (p_plan_element.end_date, fnd_api.g_miss_date)
1854: <> NVL (l_old_plan_element.end_date, fnd_api.g_miss_date)
1855: THEN
1856: -- Call the Table Handler to Delete the Old Period quotas
1857: -- cn_period_quotas_pkg.DELETE_RECORD (p_plan_element.quota_id);

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

1850: -- Commented out for Bug 4722521------------------------------------------------
1851: -- delete period quotas and distribute them again
1852: IF l_old_plan_element.start_date <> p_plan_element.start_date
1853: OR NVL (p_plan_element.end_date, fnd_api.g_miss_date)
1854: <> NVL (l_old_plan_element.end_date, fnd_api.g_miss_date)
1855: THEN
1856: -- Call the Table Handler to Delete the Old Period quotas
1857: -- cn_period_quotas_pkg.DELETE_RECORD (p_plan_element.quota_id);
1858: cn_period_quotas_pkg.distribute_target (p_plan_element.quota_id);

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

1948: x_loading_status => l_loading_status
1949: );
1950: x_loading_status := l_loading_status;
1951:
1952: IF (x_return_status <> fnd_api.g_ret_sts_success)
1953: THEN
1954: RAISE fnd_api.g_exc_error;
1955: END IF;
1956:

Line 1954: RAISE fnd_api.g_exc_error;

1950: x_loading_status := l_loading_status;
1951:
1952: IF (x_return_status <> fnd_api.g_ret_sts_success)
1953: THEN
1954: RAISE fnd_api.g_exc_error;
1955: END IF;
1956:
1957: -- Calling proc to add system note for update
1958: add_system_note(

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

1962: x_return_status,
1963: x_msg_count,
1964: x_msg_data
1965: );
1966: IF (x_return_status <> fnd_api.g_ret_sts_success)
1967: THEN
1968: RAISE fnd_api.g_exc_error;
1969: END IF;
1970:

Line 1968: RAISE fnd_api.g_exc_error;

1964: x_msg_data
1965: );
1966: IF (x_return_status <> fnd_api.g_ret_sts_success)
1967: THEN
1968: RAISE fnd_api.g_exc_error;
1969: END IF;
1970:
1971: -- End of API body.
1972: -- Standard check of p_commit.

Line 1973: IF fnd_api.to_boolean (p_commit)

1969: END IF;
1970:
1971: -- End of API body.
1972: -- Standard check of p_commit.
1973: IF fnd_api.to_boolean (p_commit)
1974: THEN
1975: COMMIT WORK;
1976: END IF;
1977:

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

1975: COMMIT WORK;
1976: END IF;
1977:
1978: -- Standard call to get message count and if count is 1, get message info.
1979: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1980: EXCEPTION
1981: WHEN fnd_api.g_exc_error
1982: THEN
1983: ROLLBACK TO update_plan_element;

Line 1981: WHEN fnd_api.g_exc_error

1977:
1978: -- Standard call to get message count and if count is 1, get message info.
1979: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1980: EXCEPTION
1981: WHEN fnd_api.g_exc_error
1982: THEN
1983: ROLLBACK TO update_plan_element;
1984: x_return_status := fnd_api.g_ret_sts_error;
1985: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 1984: x_return_status := fnd_api.g_ret_sts_error;

1980: EXCEPTION
1981: WHEN fnd_api.g_exc_error
1982: THEN
1983: ROLLBACK TO update_plan_element;
1984: x_return_status := fnd_api.g_ret_sts_error;
1985: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1986: WHEN fnd_api.g_exc_unexpected_error
1987: THEN
1988: ROLLBACK TO update_plan_element;

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

1981: WHEN fnd_api.g_exc_error
1982: THEN
1983: ROLLBACK TO update_plan_element;
1984: x_return_status := fnd_api.g_ret_sts_error;
1985: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1986: WHEN fnd_api.g_exc_unexpected_error
1987: THEN
1988: ROLLBACK TO update_plan_element;
1989: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1986: WHEN fnd_api.g_exc_unexpected_error

1982: THEN
1983: ROLLBACK TO update_plan_element;
1984: x_return_status := fnd_api.g_ret_sts_error;
1985: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1986: WHEN fnd_api.g_exc_unexpected_error
1987: THEN
1988: ROLLBACK TO update_plan_element;
1989: x_return_status := fnd_api.g_ret_sts_unexp_error;
1990: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 1989: x_return_status := fnd_api.g_ret_sts_unexp_error;

1985: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1986: WHEN fnd_api.g_exc_unexpected_error
1987: THEN
1988: ROLLBACK TO update_plan_element;
1989: x_return_status := fnd_api.g_ret_sts_unexp_error;
1990: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1991: WHEN OTHERS
1992: THEN
1993: ROLLBACK TO update_plan_element;

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

1986: WHEN fnd_api.g_exc_unexpected_error
1987: THEN
1988: ROLLBACK TO update_plan_element;
1989: x_return_status := fnd_api.g_ret_sts_unexp_error;
1990: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1991: WHEN OTHERS
1992: THEN
1993: ROLLBACK TO update_plan_element;
1994: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1994: x_return_status := fnd_api.g_ret_sts_unexp_error;

1990: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1991: WHEN OTHERS
1992: THEN
1993: ROLLBACK TO update_plan_element;
1994: x_return_status := fnd_api.g_ret_sts_unexp_error;
1995:
1996: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1997: THEN
1998: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

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

1997: THEN
1998: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1999: END IF;
2000:
2001: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2002: END update_plan_element;
2003:
2004: -- Start of comments
2005: -- API name : Delete_Plan_Element

Line 2012: -- Default = FND_API.G_FALSE

2008: -- Pre-reqs : None.
2009: -- Parameters :
2010: -- IN : p_api_version IN NUMBER Required
2011: -- p_init_msg_list IN VARCHAR2 Optional
2012: -- Default = FND_API.G_FALSE
2013: -- p_commit IN VARCHAR2 Optional
2014: -- Default = FND_API.G_FALSE
2015: -- p_validation_level IN NUMBER Optional
2016: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 2014: -- Default = FND_API.G_FALSE

2010: -- IN : p_api_version IN NUMBER Required
2011: -- p_init_msg_list IN VARCHAR2 Optional
2012: -- Default = FND_API.G_FALSE
2013: -- p_commit IN VARCHAR2 Optional
2014: -- Default = FND_API.G_FALSE
2015: -- p_validation_level IN NUMBER Optional
2016: -- Default = FND_API.G_VALID_LEVEL_FULL
2017: -- p_plan_element IN plan_element_rec_type
2018: -- OUT : x_return_status OUT VARCHAR2(1)

Line 2016: -- Default = FND_API.G_VALID_LEVEL_FULL

2012: -- Default = FND_API.G_FALSE
2013: -- p_commit IN VARCHAR2 Optional
2014: -- Default = FND_API.G_FALSE
2015: -- p_validation_level IN NUMBER Optional
2016: -- Default = FND_API.G_VALID_LEVEL_FULL
2017: -- p_plan_element IN plan_element_rec_type
2018: -- OUT : x_return_status OUT VARCHAR2(1)
2019: -- x_msg_count OUT NUMBER
2020: -- x_msg_data OUT VARCHAR2(2000)

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

2023: --
2024: -- End of comments
2025: PROCEDURE delete_plan_element (
2026: p_api_version IN NUMBER,
2027: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2028: p_commit IN VARCHAR2 := fnd_api.g_false,
2029: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2030: p_plan_element IN OUT NOCOPY plan_element_rec_type,
2031: x_return_status OUT NOCOPY VARCHAR2,

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

2024: -- End of comments
2025: PROCEDURE delete_plan_element (
2026: p_api_version IN NUMBER,
2027: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2028: p_commit IN VARCHAR2 := fnd_api.g_false,
2029: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2030: p_plan_element IN OUT NOCOPY plan_element_rec_type,
2031: x_return_status OUT NOCOPY VARCHAR2,
2032: x_msg_count OUT NOCOPY NUMBER,

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

2025: PROCEDURE delete_plan_element (
2026: p_api_version IN NUMBER,
2027: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2028: p_commit IN VARCHAR2 := fnd_api.g_false,
2029: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2030: p_plan_element IN OUT NOCOPY plan_element_rec_type,
2031: x_return_status OUT NOCOPY VARCHAR2,
2032: x_msg_count OUT NOCOPY NUMBER,
2033: x_msg_data OUT NOCOPY VARCHAR2

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

2040: -- Standard Start of API savepoint
2041: SAVEPOINT delete_plan_element;
2042:
2043: -- Standard call to check for call compatibility.
2044: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2045: THEN
2046: RAISE fnd_api.g_exc_unexpected_error;
2047: END IF;
2048:

Line 2046: RAISE fnd_api.g_exc_unexpected_error;

2042:
2043: -- Standard call to check for call compatibility.
2044: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2045: THEN
2046: RAISE fnd_api.g_exc_unexpected_error;
2047: END IF;
2048:
2049: -- Initialize message list if p_init_msg_list is set to TRUE.
2050: IF fnd_api.to_boolean (p_init_msg_list)

Line 2050: IF fnd_api.to_boolean (p_init_msg_list)

2046: RAISE fnd_api.g_exc_unexpected_error;
2047: END IF;
2048:
2049: -- Initialize message list if p_init_msg_list is set to TRUE.
2050: IF fnd_api.to_boolean (p_init_msg_list)
2051: THEN
2052: fnd_msg_pub.initialize;
2053: END IF;
2054:

Line 2056: x_return_status := fnd_api.g_ret_sts_success;

2052: fnd_msg_pub.initialize;
2053: END IF;
2054:
2055: -- Initialize API return status to success
2056: x_return_status := fnd_api.g_ret_sts_success;
2057: -- validate plan element
2058: validate_plan_element (p_api_version => p_api_version,
2059: p_plan_element => p_plan_element,
2060: p_action => 'DELETE',

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

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

Line 2068: RAISE fnd_api.g_exc_error;

2064: );
2065:
2066: IF (x_return_status <> fnd_api.g_ret_sts_success)
2067: THEN
2068: RAISE fnd_api.g_exc_error;
2069: END IF;
2070:
2071: -- API body
2072: SELECT NAME

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

2085: x_return_status,
2086: x_msg_count,
2087: x_msg_data
2088: );
2089: IF (x_return_status <> fnd_api.g_ret_sts_success)
2090: THEN
2091: RAISE fnd_api.g_exc_error;
2092: END IF;
2093:

Line 2091: RAISE fnd_api.g_exc_error;

2087: x_msg_data
2088: );
2089: IF (x_return_status <> fnd_api.g_ret_sts_success)
2090: THEN
2091: RAISE fnd_api.g_exc_error;
2092: END IF;
2093:
2094: -- End of API body.
2095: -- Standard check of p_commit.

Line 2096: IF fnd_api.to_boolean (p_commit)

2092: END IF;
2093:
2094: -- End of API body.
2095: -- Standard check of p_commit.
2096: IF fnd_api.to_boolean (p_commit)
2097: THEN
2098: COMMIT WORK;
2099: END IF;
2100:

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

2098: COMMIT WORK;
2099: END IF;
2100:
2101: -- Standard call to get message count and if count is 1, get message info.
2102: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2103: EXCEPTION
2104: WHEN fnd_api.g_exc_error
2105: THEN
2106: ROLLBACK TO delete_plan_element;

Line 2104: WHEN fnd_api.g_exc_error

2100:
2101: -- Standard call to get message count and if count is 1, get message info.
2102: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2103: EXCEPTION
2104: WHEN fnd_api.g_exc_error
2105: THEN
2106: ROLLBACK TO delete_plan_element;
2107: x_return_status := fnd_api.g_ret_sts_error;
2108: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 2107: x_return_status := fnd_api.g_ret_sts_error;

2103: EXCEPTION
2104: WHEN fnd_api.g_exc_error
2105: THEN
2106: ROLLBACK TO delete_plan_element;
2107: x_return_status := fnd_api.g_ret_sts_error;
2108: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2109: WHEN fnd_api.g_exc_unexpected_error
2110: THEN
2111: ROLLBACK TO delete_plan_element;

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

2104: WHEN fnd_api.g_exc_error
2105: THEN
2106: ROLLBACK TO delete_plan_element;
2107: x_return_status := fnd_api.g_ret_sts_error;
2108: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2109: WHEN fnd_api.g_exc_unexpected_error
2110: THEN
2111: ROLLBACK TO delete_plan_element;
2112: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2109: WHEN fnd_api.g_exc_unexpected_error

2105: THEN
2106: ROLLBACK TO delete_plan_element;
2107: x_return_status := fnd_api.g_ret_sts_error;
2108: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2109: WHEN fnd_api.g_exc_unexpected_error
2110: THEN
2111: ROLLBACK TO delete_plan_element;
2112: x_return_status := fnd_api.g_ret_sts_unexp_error;
2113: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 2112: x_return_status := fnd_api.g_ret_sts_unexp_error;

2108: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2109: WHEN fnd_api.g_exc_unexpected_error
2110: THEN
2111: ROLLBACK TO delete_plan_element;
2112: x_return_status := fnd_api.g_ret_sts_unexp_error;
2113: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2114: WHEN OTHERS
2115: THEN
2116: ROLLBACK TO delete_plan_element;

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

2109: WHEN fnd_api.g_exc_unexpected_error
2110: THEN
2111: ROLLBACK TO delete_plan_element;
2112: x_return_status := fnd_api.g_ret_sts_unexp_error;
2113: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2114: WHEN OTHERS
2115: THEN
2116: ROLLBACK TO delete_plan_element;
2117: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2117: x_return_status := fnd_api.g_ret_sts_unexp_error;

2113: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2114: WHEN OTHERS
2115: THEN
2116: ROLLBACK TO delete_plan_element;
2117: x_return_status := fnd_api.g_ret_sts_unexp_error;
2118:
2119: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2120: THEN
2121: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

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

2120: THEN
2121: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2122: END IF;
2123:
2124: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2125: END delete_plan_element;
2126:
2127: -- Start of comments
2128: -- API name : Validate_Plan_Element

Line 2135: -- Default = FND_API.G_FALSE

2131: -- Pre-reqs : None.
2132: -- Parameters :
2133: -- IN : p_api_version IN NUMBER Required
2134: -- p_init_msg_list IN VARCHAR2 Optional
2135: -- Default = FND_API.G_FALSE
2136: -- p_commit IN VARCHAR2 Optional
2137: -- Default = FND_API.G_FALSE
2138: -- p_validation_level IN NUMBER Optional
2139: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 2137: -- Default = FND_API.G_FALSE

2133: -- IN : p_api_version IN NUMBER Required
2134: -- p_init_msg_list IN VARCHAR2 Optional
2135: -- Default = FND_API.G_FALSE
2136: -- p_commit IN VARCHAR2 Optional
2137: -- Default = FND_API.G_FALSE
2138: -- p_validation_level IN NUMBER Optional
2139: -- Default = FND_API.G_VALID_LEVEL_FULL
2140: -- p_plan_element IN plan_element_rec_type
2141: -- OUT : x_return_status OUT VARCHAR2(1)

Line 2139: -- Default = FND_API.G_VALID_LEVEL_FULL

2135: -- Default = FND_API.G_FALSE
2136: -- p_commit IN VARCHAR2 Optional
2137: -- Default = FND_API.G_FALSE
2138: -- p_validation_level IN NUMBER Optional
2139: -- Default = FND_API.G_VALID_LEVEL_FULL
2140: -- p_plan_element IN plan_element_rec_type
2141: -- OUT : x_return_status OUT VARCHAR2(1)
2142: -- x_msg_count OUT NUMBER
2143: -- x_msg_data OUT VARCHAR2(2000)

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

2146: --
2147: -- End of comments
2148: PROCEDURE validate_plan_element (
2149: p_api_version IN NUMBER,
2150: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2151: p_commit IN VARCHAR2 := fnd_api.g_false,
2152: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2153: p_action IN VARCHAR2,
2154: p_plan_element IN OUT NOCOPY plan_element_rec_type,

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

2147: -- End of comments
2148: PROCEDURE validate_plan_element (
2149: p_api_version IN NUMBER,
2150: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2151: p_commit IN VARCHAR2 := fnd_api.g_false,
2152: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2153: p_action IN VARCHAR2,
2154: p_plan_element IN OUT NOCOPY plan_element_rec_type,
2155: p_old_plan_element IN plan_element_rec_type := NULL,

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

2148: PROCEDURE validate_plan_element (
2149: p_api_version IN NUMBER,
2150: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2151: p_commit IN VARCHAR2 := fnd_api.g_false,
2152: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2153: p_action IN VARCHAR2,
2154: p_plan_element IN OUT NOCOPY plan_element_rec_type,
2155: p_old_plan_element IN plan_element_rec_type := NULL,
2156: x_return_status OUT NOCOPY VARCHAR2,

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

2180: -- Standard Start of API savepoint
2181: SAVEPOINT validate_plan_element;
2182:
2183: -- Standard call to check for call compatibility.
2184: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2185: THEN
2186: RAISE fnd_api.g_exc_unexpected_error;
2187: END IF;
2188:

Line 2186: RAISE fnd_api.g_exc_unexpected_error;

2182:
2183: -- Standard call to check for call compatibility.
2184: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2185: THEN
2186: RAISE fnd_api.g_exc_unexpected_error;
2187: END IF;
2188:
2189: -- Initialize message list if p_init_msg_list is set to TRUE.
2190: IF fnd_api.to_boolean (p_init_msg_list)

Line 2190: IF fnd_api.to_boolean (p_init_msg_list)

2186: RAISE fnd_api.g_exc_unexpected_error;
2187: END IF;
2188:
2189: -- Initialize message list if p_init_msg_list is set to TRUE.
2190: IF fnd_api.to_boolean (p_init_msg_list)
2191: THEN
2192: fnd_msg_pub.initialize;
2193: END IF;
2194:

Line 2196: x_return_status := fnd_api.g_ret_sts_success;

2192: fnd_msg_pub.initialize;
2193: END IF;
2194:
2195: -- Initialize API return status to success
2196: x_return_status := fnd_api.g_ret_sts_success;
2197: p_plan_element.start_date := TRUNC (p_plan_element.start_date);
2198: p_plan_element.end_date := TRUNC (p_plan_element.end_date);
2199:
2200:

Line 2217: RAISE fnd_api.g_exc_error;

2213: fnd_message.set_name ('CN', 'CN_INVALID_DEL_REC');
2214: fnd_msg_pub.ADD;
2215: END IF;
2216:
2217: RAISE fnd_api.g_exc_error;
2218: END IF;
2219:
2220: -- check whether the plan element is already assigned to a complan
2221: BEGIN

Line 2236: RAISE fnd_api.g_exc_error;

2232: THEN
2233: fnd_message.set_name ('CN', 'PLN_QUOTA_DELETE_NA');
2234: fnd_msg_pub.ADD;
2235: END IF;
2236: RAISE fnd_api.g_exc_error;
2237: END;
2238: ELSE
2239: -- check whether user has access to this org
2240: IF (p_action = 'UPDATE')

Line 2245: RAISE fnd_api.g_exc_error;

2241: THEN
2242: -- better check that org_id first or you will cry
2243: IF NOT is_valid_org (p_plan_element.org_id, p_plan_element.quota_id)
2244: THEN
2245: RAISE fnd_api.g_exc_error;
2246: END IF;
2247:
2248: -- 1. check object version number
2249: IF p_old_plan_element.object_version_number <> p_plan_element.object_version_number

Line 2257: RAISE fnd_api.g_exc_error;

2253: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
2254: fnd_msg_pub.ADD;
2255: END IF;
2256:
2257: RAISE fnd_api.g_exc_error;
2258: END IF;
2259:
2260: -- 2. plan element name must be unique
2261: SELECT COUNT (1)

Line 2275: RAISE fnd_api.g_exc_error;

2271: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2272: fnd_msg_pub.ADD;
2273: END IF;
2274:
2275: RAISE fnd_api.g_exc_error;
2276: END IF;
2277:
2278: --Added by hanaraya for bug 6505174
2279: -- Check for date range overlap between plan element and quota rule uplifts

Line 2295: RAISE fnd_api.g_exc_error;

2291: THEN
2292: fnd_message.set_name ('CN', 'CN_UPLIFT_DT_NOT_WIN_QUOTA');
2293: fnd_msg_pub.ADD;
2294: END IF;
2295: RAISE fnd_api.g_exc_error;
2296: END IF;
2297:
2298: ELSIF (p_action = 'CREATE')
2299: THEN

Line 2303: RAISE fnd_api.g_exc_error;

2299: THEN
2300: -- better check that org_id first or you will cry
2301: IF NOT is_valid_org (p_plan_element.org_id)
2302: THEN
2303: RAISE fnd_api.g_exc_error;
2304: END IF;
2305:
2306: -- 2. plan element name must be unique
2307: SELECT COUNT (1)

Line 2321: RAISE fnd_api.g_exc_error;

2317: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2318: fnd_msg_pub.ADD;
2319: END IF;
2320:
2321: RAISE fnd_api.g_exc_error;
2322: END IF;
2323: END IF;
2324:
2325: --###########################################################################

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

2326: --## VALIDATION FOR BOTH UPDATE AND CREATE
2327: --###########################################################################
2328:
2329: -- 1. name can not be null
2330: IF (p_plan_element.NAME IS NULL) OR (p_plan_element.NAME = fnd_api.g_miss_char)
2331: THEN
2332: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2333: THEN
2334: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');

Line 2339: RAISE fnd_api.g_exc_error;

2335: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2336: fnd_msg_pub.ADD;
2337: END IF;
2338:
2339: RAISE fnd_api.g_exc_error;
2340: END IF;
2341:
2342: -- start date is not null
2343: IF (p_plan_element.start_date IS NULL) OR (p_plan_element.start_date = fnd_api.g_miss_date)

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

2339: RAISE fnd_api.g_exc_error;
2340: END IF;
2341:
2342: -- start date is not null
2343: IF (p_plan_element.start_date IS NULL) OR (p_plan_element.start_date = fnd_api.g_miss_date)
2344: THEN
2345: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2346: THEN
2347: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');

Line 2352: RAISE fnd_api.g_exc_error;

2348: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('SD', 'INPUT_TOKEN'));
2349: fnd_msg_pub.ADD;
2350: END IF;
2351:
2352: RAISE fnd_api.g_exc_error;
2353: END IF;
2354:
2355: -- start date > end date
2356: IF (p_plan_element.end_date IS NOT NULL) AND (p_plan_element.start_date > p_plan_element.end_date)

Line 2364: RAISE fnd_api.g_exc_error;

2360: fnd_message.set_name ('CN', 'CN_DATE_RANGE_ERROR');
2361: fnd_msg_pub.ADD;
2362: END IF;
2363:
2364: RAISE fnd_api.g_exc_error;
2365: END IF;
2366:
2367:
2368:

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.payment_amount IS NULL)
2389: THEN

Line 2397: RAISE fnd_api.g_exc_error;

2393: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', '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.performance_goal IS NULL)
2401: THEN

Line 2409: RAISE fnd_api.g_exc_error;

2405: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));
2406: fnd_msg_pub.ADD;
2407: END IF;
2408:
2409: RAISE fnd_api.g_exc_error;
2410: END IF;
2411:
2412: IF (p_plan_element.payee_assign_flag NOT IN ('Y', 'N'))
2413: THEN

Line 2421: RAISE fnd_api.g_exc_error;

2417: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PAYEE_ASSIGN', 'PE_OBJECT_TYPE'));
2418: fnd_msg_pub.ADD;
2419: END IF;
2420:
2421: RAISE fnd_api.g_exc_error;
2422: END IF;
2423:
2424: IF p_plan_element.addup_from_rev_class_flag NOT IN ('Y', 'N')
2425: THEN

Line 2433: RAISE fnd_api.g_exc_error;

2429: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('ADD_FROM_REVCLASS', 'PE_OBJECT_TYPE'));
2430: fnd_msg_pub.ADD;
2431: END IF;
2432:
2433: RAISE fnd_api.g_exc_error;
2434: END IF;
2435:
2436:
2437: ---changes made for fixing the bug # 2739896

Line 2454: RAISE fnd_api.g_exc_error;

2450: IF (l_payeechk > 0)
2451: THEN
2452: fnd_message.set_name ('CN', 'CN_PAYEE_ASGN_FLAG_CHECK');
2453: fnd_msg_pub.ADD;
2454: RAISE fnd_api.g_exc_error;
2455: END IF;
2456: END IF;
2457: END IF; -- END OF DELETE VALIDATION
2458:

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

2458:
2459: -- End of API body.
2460: <>
2461: -- Standard call to get message count and if count is 1, get message info.
2462: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2463: EXCEPTION
2464: WHEN fnd_api.g_exc_error
2465: THEN
2466: ROLLBACK TO validate_plan_element;

Line 2464: WHEN fnd_api.g_exc_error

2460: <>
2461: -- Standard call to get message count and if count is 1, get message info.
2462: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2463: EXCEPTION
2464: WHEN fnd_api.g_exc_error
2465: THEN
2466: ROLLBACK TO validate_plan_element;
2467: x_return_status := fnd_api.g_ret_sts_error;
2468: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 2467: x_return_status := fnd_api.g_ret_sts_error;

2463: EXCEPTION
2464: WHEN fnd_api.g_exc_error
2465: THEN
2466: ROLLBACK TO validate_plan_element;
2467: x_return_status := fnd_api.g_ret_sts_error;
2468: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2469: WHEN fnd_api.g_exc_unexpected_error
2470: THEN
2471: ROLLBACK TO validate_plan_element;

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

2464: WHEN fnd_api.g_exc_error
2465: THEN
2466: ROLLBACK TO validate_plan_element;
2467: x_return_status := fnd_api.g_ret_sts_error;
2468: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2469: WHEN fnd_api.g_exc_unexpected_error
2470: THEN
2471: ROLLBACK TO validate_plan_element;
2472: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2469: WHEN fnd_api.g_exc_unexpected_error

2465: THEN
2466: ROLLBACK TO validate_plan_element;
2467: x_return_status := fnd_api.g_ret_sts_error;
2468: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2469: WHEN fnd_api.g_exc_unexpected_error
2470: THEN
2471: ROLLBACK TO validate_plan_element;
2472: x_return_status := fnd_api.g_ret_sts_unexp_error;
2473: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 2472: x_return_status := fnd_api.g_ret_sts_unexp_error;

2468: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2469: WHEN fnd_api.g_exc_unexpected_error
2470: THEN
2471: ROLLBACK TO validate_plan_element;
2472: x_return_status := fnd_api.g_ret_sts_unexp_error;
2473: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2474: WHEN OTHERS
2475: THEN
2476: ROLLBACK TO validate_plan_element;

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

2469: WHEN fnd_api.g_exc_unexpected_error
2470: THEN
2471: ROLLBACK TO validate_plan_element;
2472: x_return_status := fnd_api.g_ret_sts_unexp_error;
2473: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2474: WHEN OTHERS
2475: THEN
2476: ROLLBACK TO validate_plan_element;
2477: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2477: x_return_status := fnd_api.g_ret_sts_unexp_error;

2473: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2474: WHEN OTHERS
2475: THEN
2476: ROLLBACK TO validate_plan_element;
2477: x_return_status := fnd_api.g_ret_sts_unexp_error;
2478:
2479: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2480: THEN
2481: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

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

2480: THEN
2481: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2482: END IF;
2483:
2484: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2485: END validate_plan_element;
2486:
2487: -- Start of comments
2488: -- API name : Duplicate_Plan_Element

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

2601:
2602: -- Check that the plan element is valid
2603: PROCEDURE validate_plan_element (
2604: p_api_version IN NUMBER,
2605: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2606: p_commit IN VARCHAR2 := fnd_api.g_false,
2607: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2608: p_comp_plan_id IN NUMBER := NULL,
2609: p_quota_id IN NUMBER,

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

2602: -- Check that the plan element is valid
2603: PROCEDURE validate_plan_element (
2604: p_api_version IN NUMBER,
2605: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2606: p_commit IN VARCHAR2 := fnd_api.g_false,
2607: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2608: p_comp_plan_id IN NUMBER := NULL,
2609: p_quota_id IN NUMBER,
2610: x_status_code OUT NOCOPY VARCHAR2,

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

2603: PROCEDURE validate_plan_element (
2604: p_api_version IN NUMBER,
2605: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2606: p_commit IN VARCHAR2 := fnd_api.g_false,
2607: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2608: p_comp_plan_id IN NUMBER := NULL,
2609: p_quota_id IN NUMBER,
2610: x_status_code OUT NOCOPY VARCHAR2,
2611: x_return_status OUT NOCOPY VARCHAR2,

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

2662: -- Standard Start of API savepoint
2663: SAVEPOINT validate_plan_element_2;
2664:
2665: -- Standard call to check for call compatibility.
2666: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2667: THEN
2668: RAISE fnd_api.g_exc_unexpected_error;
2669: END IF;
2670:

Line 2668: RAISE fnd_api.g_exc_unexpected_error;

2664:
2665: -- Standard call to check for call compatibility.
2666: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2667: THEN
2668: RAISE fnd_api.g_exc_unexpected_error;
2669: END IF;
2670:
2671: -- Initialize message list if p_init_msg_list is set to TRUE.
2672: IF fnd_api.to_boolean (p_init_msg_list)

Line 2672: IF fnd_api.to_boolean (p_init_msg_list)

2668: RAISE fnd_api.g_exc_unexpected_error;
2669: END IF;
2670:
2671: -- Initialize message list if p_init_msg_list is set to TRUE.
2672: IF fnd_api.to_boolean (p_init_msg_list)
2673: THEN
2674: fnd_msg_pub.initialize;
2675: END IF;
2676:

Line 2678: x_return_status := fnd_api.g_ret_sts_success;

2674: fnd_msg_pub.initialize;
2675: END IF;
2676:
2677: -- Initialize API return status to success
2678: x_return_status := fnd_api.g_ret_sts_success;
2679: -- fill the rec
2680: l_plan_element := get_plan_element (p_quota_id);
2681: -- validate the plan element
2682: validate_plan_element (p_api_version => p_api_version,

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

2688: x_msg_data => x_msg_data
2689: );
2690:
2691: -- in case of error, raise exception
2692: IF (x_return_status <> fnd_api.g_ret_sts_success)
2693: THEN
2694: l_temp_status_code := g_incomplete;
2695: RAISE fnd_api.g_exc_error;
2696: END IF;

Line 2695: RAISE fnd_api.g_exc_error;

2691: -- in case of error, raise exception
2692: IF (x_return_status <> fnd_api.g_ret_sts_success)
2693: THEN
2694: l_temp_status_code := g_incomplete;
2695: RAISE fnd_api.g_exc_error;
2696: END IF;
2697:
2698: IF p_comp_plan_id IS NOT NULL
2699: THEN

Line 2846: IF fnd_api.to_boolean (p_commit)

2842: x_status_code := l_temp_status_code;
2843:
2844: -- End of API body.
2845: -- Standard check of p_commit.
2846: IF fnd_api.to_boolean (p_commit)
2847: THEN
2848: COMMIT WORK;
2849: END IF;
2850:

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

2848: COMMIT WORK;
2849: END IF;
2850:
2851: -- Standard call to get message count and if count is 1, get message info.
2852: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2853: EXCEPTION
2854: WHEN fnd_api.g_exc_error
2855: THEN
2856: ROLLBACK TO validate_plan_element_2;

Line 2854: WHEN fnd_api.g_exc_error

2850:
2851: -- Standard call to get message count and if count is 1, get message info.
2852: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2853: EXCEPTION
2854: WHEN fnd_api.g_exc_error
2855: THEN
2856: ROLLBACK TO validate_plan_element_2;
2857: x_return_status := fnd_api.g_ret_sts_error;
2858: x_status_code := g_incomplete;

Line 2857: x_return_status := fnd_api.g_ret_sts_error;

2853: EXCEPTION
2854: WHEN fnd_api.g_exc_error
2855: THEN
2856: ROLLBACK TO validate_plan_element_2;
2857: x_return_status := fnd_api.g_ret_sts_error;
2858: x_status_code := g_incomplete;
2859: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2860: WHEN fnd_api.g_exc_unexpected_error
2861: THEN

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

2855: THEN
2856: ROLLBACK TO validate_plan_element_2;
2857: x_return_status := fnd_api.g_ret_sts_error;
2858: x_status_code := g_incomplete;
2859: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2860: WHEN fnd_api.g_exc_unexpected_error
2861: THEN
2862: ROLLBACK TO validate_plan_element_2;
2863: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2860: WHEN fnd_api.g_exc_unexpected_error

2856: ROLLBACK TO validate_plan_element_2;
2857: x_return_status := fnd_api.g_ret_sts_error;
2858: x_status_code := g_incomplete;
2859: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2860: WHEN fnd_api.g_exc_unexpected_error
2861: THEN
2862: ROLLBACK TO validate_plan_element_2;
2863: x_return_status := fnd_api.g_ret_sts_unexp_error;
2864: x_status_code := g_incomplete;

Line 2863: x_return_status := fnd_api.g_ret_sts_unexp_error;

2859: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2860: WHEN fnd_api.g_exc_unexpected_error
2861: THEN
2862: ROLLBACK TO validate_plan_element_2;
2863: x_return_status := fnd_api.g_ret_sts_unexp_error;
2864: x_status_code := g_incomplete;
2865: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2866: WHEN OTHERS
2867: THEN

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

2861: THEN
2862: ROLLBACK TO validate_plan_element_2;
2863: x_return_status := fnd_api.g_ret_sts_unexp_error;
2864: x_status_code := g_incomplete;
2865: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2866: WHEN OTHERS
2867: THEN
2868: ROLLBACK TO validate_plan_element_2;
2869: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2869: x_return_status := fnd_api.g_ret_sts_unexp_error;

2865: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2866: WHEN OTHERS
2867: THEN
2868: ROLLBACK TO validate_plan_element_2;
2869: x_return_status := fnd_api.g_ret_sts_unexp_error;
2870: x_status_code := g_incomplete;
2871:
2872: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2873: THEN

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

2873: THEN
2874: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2875: END IF;
2876:
2877: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2878: END validate_plan_element;
2879: END cn_plan_element_pvt;