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_PUB dependencies on FND_MSG_PUB

Line 34: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

30: WHERE lookup_type = 'PAYMENT_GROUP_CODE' AND lookup_code = p_payment_group_code;
31:
32: IF (l_tmp_exist = 0)
33: THEN
34: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
35: THEN
36: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
37: fnd_message.set_token ('OBJ_NAME', p_payment_group_code);
38: fnd_msg_pub.ADD;

Line 38: fnd_msg_pub.ADD;

34: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
35: THEN
36: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
37: fnd_message.set_token ('OBJ_NAME', p_payment_group_code);
38: fnd_msg_pub.ADD;
39: END IF;
40:
41: RAISE fnd_api.g_exc_error;
42: END IF;

Line 59: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

55: WHEN OTHERS
56: THEN
57: x_return_status := fnd_api.g_ret_sts_unexp_error;
58:
59: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
60: THEN
61: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
62: END IF;
63: END validate_payment_group_code;

Line 61: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

57: x_return_status := fnd_api.g_ret_sts_unexp_error;
58:
59: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
60: THEN
61: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
62: END IF;
63: END validate_payment_group_code;
64:
65:

Line 90: fnd_msg_pub.ADD;

86: BEGIN
87: IF p_org_id IS NULL
88: THEN
89: fnd_message.set_name ('FND', 'MO_OU_REQUIRED');
90: fnd_msg_pub.ADD;
91: RAISE fnd_api.g_exc_error;
92: END IF;
93: END;
94:

Line 487: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

483:
484: -- Check credit_type_id can not be missing or NULL
485: IF (p_pe_rec.credit_type IS NOT NULL AND p_pe_rec.credit_type_id IS NULL)
486: THEN
487: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
488: THEN
489: fnd_message.set_name ('CN', 'CN_CREDIT_TYPE_NOT_EXIST');
490: fnd_message.set_token ('CREDIT_TYPE', p_pe_rec.credit_type);
491: fnd_msg_pub.ADD;

Line 491: fnd_msg_pub.ADD;

487: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
488: THEN
489: fnd_message.set_name ('CN', 'CN_CREDIT_TYPE_NOT_EXIST');
490: fnd_message.set_token ('CREDIT_TYPE', p_pe_rec.credit_type);
491: fnd_msg_pub.ADD;
492: END IF;
493:
494: x_loading_status := 'CREDIT_TYPE_NOT_EXIST';
495: RAISE fnd_api.g_exc_error;

Line 501: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

497:
498: -- Check interval_type_id can not be missing or NULL
499: IF (p_pe_rec.interval_name IS NOT NULL AND p_pe_rec.interval_type_id IS NULL)
500: THEN
501: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
502: THEN
503: fnd_message.set_name ('CN', 'CN_INTERVAL_TYPE_NOT_EXIST');
504: fnd_message.set_token ('INTERVAL_NAME', p_pe_rec.interval_name);
505: fnd_msg_pub.ADD;

Line 505: fnd_msg_pub.ADD;

501: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
502: THEN
503: fnd_message.set_name ('CN', 'CN_INTERVAL_TYPE_NOT_EXIST');
504: fnd_message.set_token ('INTERVAL_NAME', p_pe_rec.interval_name);
505: fnd_msg_pub.ADD;
506: END IF;
507:
508: x_loading_status := 'INTERVAL_TYPE_NOT_EXIST';
509: RAISE fnd_api.g_exc_error;

Line 588: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

584: THEN
585: x_return_status := fnd_api.g_ret_sts_unexp_error;
586: x_loading_status := 'UNEXPECTED_ERR';
587:
588: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
589: THEN
590: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
591: END IF;
592: END chk_pe_required;

Line 590: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

586: x_loading_status := 'UNEXPECTED_ERR';
587:
588: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
589: THEN
590: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
591: END IF;
592: END chk_pe_required;
593:
594: -- -------------------------------------------------------------------------+-+

Line 638: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

634: IF (l_pe_csr.description <> p_pe_rec.description)
635: THEN
636: -- Error, check the msg level and add an error message to the
637: -- API message list
638: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
639: THEN
640: fnd_message.set_name ('CN', 'CN_PLN_NOT_CONSISTENT');
641: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
642: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_desc);

Line 643: fnd_msg_pub.ADD;

639: THEN
640: fnd_message.set_name ('CN', 'CN_PLN_NOT_CONSISTENT');
641: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
642: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_desc);
643: fnd_msg_pub.ADD;
644: END IF;
645:
646: x_loading_status := 'CN_PLN_NOT_CONSISTENT';
647: RAISE fnd_api.g_exc_error;

Line 655: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

651: IF (l_pe_csr.quota_type_code <> p_pe_rec.quota_type_code)
652: THEN
653: -- Error, check the msg level and add an error message to the
654: -- API message list
655: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
656: THEN
657: fnd_message.set_name ('CN', 'CN_PLN_NOT_CONSISTENT');
658: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
659: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_element_type);

Line 660: fnd_msg_pub.ADD;

656: THEN
657: fnd_message.set_name ('CN', 'CN_PLN_NOT_CONSISTENT');
658: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
659: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_element_type);
660: fnd_msg_pub.ADD;
661: END IF;
662:
663: x_loading_status := 'CN_PLN_NOT_CONSISTENT';
664: RAISE fnd_api.g_exc_error;

Line 672: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

668: IF (l_pe_csr.target <> p_pe_rec.target)
669: THEN
670: -- Error, check the msg level and add an error message to the
671: -- API message list
672: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
673: THEN
674: fnd_message.set_name ('CN', 'CN_PLN_NOT_CONSISTENT');
675: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
676: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_target);

Line 677: fnd_msg_pub.ADD;

673: THEN
674: fnd_message.set_name ('CN', 'CN_PLN_NOT_CONSISTENT');
675: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
676: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_target);
677: fnd_msg_pub.ADD;
678: END IF;
679:
680: x_loading_status := 'CN_PLN_NOT_CONSISTENT';
681: RAISE fnd_api.g_exc_error;

Line 698: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

694: THEN
695: x_return_status := fnd_api.g_ret_sts_unexp_error;
696: x_loading_status := 'UNEXPECTED_ERR';
697:
698: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
699: THEN
700: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
701: END IF;
702: END chk_pe_consistent;

Line 700: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

696: x_loading_status := 'UNEXPECTED_ERR';
697:
698: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
699: THEN
700: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
701: END IF;
702: END chk_pe_consistent;
703:
704: -- -------------------------------------------------------------------------+-+

Line 807: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

803: WHERE lookup_type = 'QUOTA_TYPE' AND lookup_code = p_pe_rec.quota_type_code;
804:
805: IF (l_tmp_exist = 0)
806: THEN
807: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
808: THEN
809: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
810: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_element_type);
811: fnd_msg_pub.ADD;

Line 811: fnd_msg_pub.ADD;

807: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
808: THEN
809: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
810: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_element_type);
811: fnd_msg_pub.ADD;
812: END IF;
813:
814: x_loading_status := 'CN_INVALID_DATA';
815: RAISE fnd_api.g_exc_error;

Line 826: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

822: WHERE lookup_type = 'INCENTIVE_TYPE' AND lookup_code = p_pe_rec.incentive_type_code;
823:
824: IF (l_tmp_exist = 0)
825: THEN
826: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
827: THEN
828: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
829: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_incentive_type_code);
830: fnd_msg_pub.ADD;

Line 830: fnd_msg_pub.ADD;

826: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
827: THEN
828: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
829: fnd_message.set_token ('OBJ_NAME', cn_chk_plan_element_pkg.g_incentive_type_code);
830: fnd_msg_pub.ADD;
831: END IF;
832:
833: x_loading_status := 'CN_INVALID_DATA';
834: RAISE fnd_api.g_exc_error;

Line 850: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

846: THEN
847: x_return_status := fnd_api.g_ret_sts_unexp_error;
848: x_loading_status := 'UNEXPECTED_ERR';
849:
850: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
851: THEN
852: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
853: END IF;
854: END valid_lookup_code;

Line 852: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

848: x_loading_status := 'UNEXPECTED_ERR';
849:
850: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
851: THEN
852: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
853: END IF;
854: END valid_lookup_code;
855:
856: -- -------------------------------------------------------------------------+-+

Line 973: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

969: -- then raise an error
970: ELSIF p_pe_rec.quota_type_code = 'NONE' AND p_rt_quota_asgns_rec_tbl.COUNT > 0
971: THEN
972: -- Error you cannot have rates for quota type is NONE
973: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
974: THEN
975: fnd_message.set_name ('CN', 'CN_QUOTA_CANNOT_HAVE_RATES');
976: fnd_message.set_token ('PLAN_NAME', p_quota_name);
977: fnd_msg_pub.ADD;

Line 977: fnd_msg_pub.ADD;

973: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
974: THEN
975: fnd_message.set_name ('CN', 'CN_QUOTA_CANNOT_HAVE_RATES');
976: fnd_message.set_token ('PLAN_NAME', p_quota_name);
977: fnd_msg_pub.ADD;
978: END IF;
979:
980: x_loading_status := 'QUOTA_CANNOT_HAVE_RATES';
981: RAISE fnd_api.g_exc_error;

Line 997: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

993: THEN
994: x_return_status := fnd_api.g_ret_sts_unexp_error;
995: x_loading_status := 'UNEXPECTED_ERR';
996:
997: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
998: THEN
999: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1000: END IF;
1001: END update_rate_quotas;

Line 999: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

995: x_loading_status := 'UNEXPECTED_ERR';
996:
997: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
998: THEN
999: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1000: END IF;
1001: END update_rate_quotas;
1002:
1003: -- -------------------------------------------------------------------------+-+

Line 1096: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1092: -- then raise an error
1093: ELSIF p_pe_rec.quota_type_code = 'NONE' AND p_rt_quota_asgns_rec_tbl.COUNT > 0
1094: THEN
1095: -- Error you cannot have rates for quota type is NONE
1096: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1097: THEN
1098: fnd_message.set_name ('CN', 'CN_QUOTA_CANNOT_HAVE_RATES');
1099: fnd_message.set_token ('PLAN_NAME', p_quota_name);
1100: fnd_msg_pub.ADD;

Line 1100: fnd_msg_pub.ADD;

1096: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1097: THEN
1098: fnd_message.set_name ('CN', 'CN_QUOTA_CANNOT_HAVE_RATES');
1099: fnd_message.set_token ('PLAN_NAME', p_quota_name);
1100: fnd_msg_pub.ADD;
1101: END IF;
1102:
1103: x_loading_status := 'QUOTA_CANNOT_HAVE_RATES';
1104: RAISE fnd_api.g_exc_error;

Line 1120: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1116: THEN
1117: x_return_status := fnd_api.g_ret_sts_unexp_error;
1118: x_loading_status := 'UNEXPECTED_ERR';
1119:
1120: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1121: THEN
1122: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1123: END IF;
1124: END insert_rate_quotas;

Line 1122: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1118: x_loading_status := 'UNEXPECTED_ERR';
1119:
1120: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1121: THEN
1122: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1123: END IF;
1124: END insert_rate_quotas;
1125:
1126: -- -------------------------------------------------------------------------+-+

Line 1234: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1230: THEN
1231: x_return_status := fnd_api.g_ret_sts_unexp_error;
1232: x_loading_status := 'UNEXPECTED_ERR';
1233:
1234: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1235: THEN
1236: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1237: END IF;
1238: END update_period_quotas;

Line 1236: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1232: x_loading_status := 'UNEXPECTED_ERR';
1233:
1234: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1235: THEN
1236: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1237: END IF;
1238: END update_period_quotas;
1239:
1240: -- -------------------------------------------------------------------------+-+

Line 1312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1308: -- an error
1309: /*ELSIF Nvl(cn_api.get_itd_flag(p_pe_rec.calc_formula_id),'N') = 'N'
1310: AND p_period_quotas_rec_tbl.COUNT > 0 THEN
1311:
1312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1313: THEN
1314: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_CANNOT_HAVE_PERIODS');
1315: FND_MSG_PUB.Add;
1316: END IF;

Line 1315: FND_MSG_PUB.Add;

1311:
1312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1313: THEN
1314: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_CANNOT_HAVE_PERIODS');
1315: FND_MSG_PUB.Add;
1316: END IF;
1317: x_loading_status := 'QUOTA_CANNOT_HAVE_PERIODS';
1318: RAISE FND_API.G_EXC_ERROR ;
1319: --END IF; -- clku, enhancement 2380234*/

Line 1335: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1331: THEN
1332: x_return_status := fnd_api.g_ret_sts_unexp_error;
1333: x_loading_status := 'UNEXPECTED_ERR';
1334:
1335: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1336: THEN
1337: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1338: END IF;
1339: END create_period_quotas;

Line 1337: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1333: x_loading_status := 'UNEXPECTED_ERR';
1334:
1335: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1336: THEN
1337: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1338: END IF;
1339: END create_period_quotas;
1340:
1341: -- -------------------------------------------------------------------------+-+

Line 1407: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1403:
1404: -- Check the revenue class name is assigned.
1405: IF l_trx_factor_rec_tbl (OUTER).rev_class_name IS NULL
1406: THEN
1407: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1408: THEN
1409: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_ASSIGNED');
1410: fnd_msg_pub.ADD;
1411: END IF;

Line 1410: fnd_msg_pub.ADD;

1406: THEN
1407: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1408: THEN
1409: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_ASSIGNED');
1410: fnd_msg_pub.ADD;
1411: END IF;
1412:
1413: x_loading_status := 'REV_CLASS_NOT_ASSIGNED';
1414: RAISE fnd_api.g_exc_error;

Line 1420: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1416:
1417: -- check the revenue class exists
1418: IF l_rev_class_id IS NULL AND l_trx_factor_rec_tbl (OUTER).rev_class_name IS NOT NULL
1419: THEN
1420: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1421: THEN
1422: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
1423: fnd_msg_pub.ADD;
1424: END IF;

Line 1423: fnd_msg_pub.ADD;

1419: THEN
1420: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1421: THEN
1422: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
1423: fnd_msg_pub.ADD;
1424: END IF;
1425:
1426: x_loading_status := 'CN_REV_CLASS_NOT_EXIST';
1427: RAISE fnd_api.g_exc_error;

Line 1436: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1432:
1433: -- Quota rule_id is null raise an error
1434: IF l_quota_rule_id IS NULL
1435: THEN
1436: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1437: THEN
1438: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
1439: fnd_message.set_token ('PLAN_NAME', p_quota_name);
1440: fnd_message.set_token ('REVENUE_CLASS_NAME', l_trx_factor_rec_tbl (OUTER).rev_class_name);

Line 1441: fnd_msg_pub.ADD;

1437: THEN
1438: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
1439: fnd_message.set_token ('PLAN_NAME', p_quota_name);
1440: fnd_message.set_token ('REVENUE_CLASS_NAME', l_trx_factor_rec_tbl (OUTER).rev_class_name);
1441: fnd_msg_pub.ADD;
1442: END IF;
1443:
1444: x_loading_status := 'QUOTA_RULE_NOT_EXIST';
1445: RAISE fnd_api.g_exc_error;

Line 1457: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1453: l_meaning := cn_api.get_lkup_meaning (p_trx_factor_rec_tbl (INNER).trx_type, 'TRX TYPES');
1454:
1455: IF l_meaning IS NULL
1456: THEN
1457: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1458: THEN
1459: fnd_message.set_name ('CN', 'CN_TRX_TYPE_NOT_EXIST');
1460: fnd_message.set_token ('TRANSACTION_TYPE', p_trx_factor_rec_tbl (INNER).trx_type);
1461: fnd_msg_pub.ADD;

Line 1461: fnd_msg_pub.ADD;

1457: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1458: THEN
1459: fnd_message.set_name ('CN', 'CN_TRX_TYPE_NOT_EXIST');
1460: fnd_message.set_token ('TRANSACTION_TYPE', p_trx_factor_rec_tbl (INNER).trx_type);
1461: fnd_msg_pub.ADD;
1462: END IF;
1463:
1464: x_loading_status := 'CN_TRX_TYPE_NOT_EXISTS';
1465: RAISE fnd_api.g_exc_error;

Line 1505: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1501: THEN
1502: x_return_status := fnd_api.g_ret_sts_unexp_error;
1503: x_loading_status := 'UNEXPECTED_ERR';
1504:
1505: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1506: THEN
1507: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1508: END IF;
1509: END trx_factors;

Line 1507: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1503: x_loading_status := 'UNEXPECTED_ERR';
1504:
1505: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1506: THEN
1507: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1508: END IF;
1509: END trx_factors;
1510:
1511: -- -------------------------------------------------------------------------+-+

Line 1579: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1575: IF x_quota_id IS NULL
1576: THEN
1577: IF p_quota_name_old IS NOT NULL
1578: THEN
1579: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1580: THEN
1581: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
1582: fnd_message.set_token ('PE_NAME', p_quota_name_old);
1583: fnd_msg_pub.ADD;

Line 1583: fnd_msg_pub.ADD;

1579: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1580: THEN
1581: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
1582: fnd_message.set_token ('PE_NAME', p_quota_name_old);
1583: fnd_msg_pub.ADD;
1584: END IF;
1585:
1586: x_loading_status := 'CN_PLN_NOT_EXIST';
1587: RAISE fnd_api.g_exc_error;

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

1588: END IF;
1589: END IF;
1590:
1591: -- Standard message count
1592: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1593: -- end check_quota_exists
1594: EXCEPTION
1595: WHEN fnd_api.g_exc_error
1596: THEN

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

1594: EXCEPTION
1595: WHEN fnd_api.g_exc_error
1596: THEN
1597: x_return_status := fnd_api.g_ret_sts_error;
1598: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1599: WHEN fnd_api.g_exc_unexpected_error
1600: THEN
1601: x_return_status := fnd_api.g_ret_sts_unexp_error;
1602: x_loading_status := 'UNEXPECTED_ERR';

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

1599: WHEN fnd_api.g_exc_unexpected_error
1600: THEN
1601: x_return_status := fnd_api.g_ret_sts_unexp_error;
1602: x_loading_status := 'UNEXPECTED_ERR';
1603: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1604: WHEN OTHERS
1605: THEN
1606: x_return_status := fnd_api.g_ret_sts_unexp_error;
1607: x_loading_status := 'UNEXPECTED_ERR';

Line 1609: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1605: THEN
1606: x_return_status := fnd_api.g_ret_sts_unexp_error;
1607: x_loading_status := 'UNEXPECTED_ERR';
1608:
1609: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1610: THEN
1611: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1612: END IF;
1613:

Line 1611: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1607: x_loading_status := 'UNEXPECTED_ERR';
1608:
1609: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1610: THEN
1611: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1612: END IF;
1613:
1614: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1615: END check_quota_exists;

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

1610: THEN
1611: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1612: END IF;
1613:
1614: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1615: END check_quota_exists;
1616:
1617: -- -------------------------------------------------------------------------+-+
1618: --| Procedure: Valid_plan_Element

Line 1677: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1673:
1674: -- Validate Rule : End period must be greater than Start period
1675: IF (p_pe_rec.end_date IS NOT NULL AND TRUNC (p_pe_rec.end_date) < TRUNC (p_pe_rec.start_date))
1676: THEN
1677: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1678: THEN
1679: fnd_message.set_name ('CN', 'CN_INVALID_DATE_RANGE');
1680: fnd_msg_pub.ADD;
1681: END IF;

Line 1680: fnd_msg_pub.ADD;

1676: THEN
1677: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1678: THEN
1679: fnd_message.set_name ('CN', 'CN_INVALID_DATE_RANGE');
1680: fnd_msg_pub.ADD;
1681: END IF;
1682:
1683: x_loading_status := 'INVALID_END_DATE';
1684: RAISE fnd_api.g_exc_error;

Line 1691: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1687: -- Formula name is not null but the ID is not in the Database
1688: -- Raise an Error
1689: IF (p_pe_rec.calc_formula_name IS NOT NULL AND p_pe_rec.calc_formula_id IS NULL)
1690: THEN
1691: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1692: THEN
1693: fnd_message.set_name ('CN', 'CN_FORMULA_NOT_EXIST');
1694: fnd_message.set_token ('FORMULA_NAME', p_pe_rec.calc_formula_name);
1695: fnd_msg_pub.ADD;

Line 1695: fnd_msg_pub.ADD;

1691: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1692: THEN
1693: fnd_message.set_name ('CN', 'CN_FORMULA_NOT_EXIST');
1694: fnd_message.set_token ('FORMULA_NAME', p_pe_rec.calc_formula_name);
1695: fnd_msg_pub.ADD;
1696: END IF;
1697:
1698: x_loading_status := 'FORMULA_NOT_EXIST';
1699: RAISE fnd_api.g_exc_error;

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

1767: -- End of API body.
1768: <>
1769: NULL;
1770: -- Standard call to get message count and if count is 1, get message info.
1771: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1772: -- end valid_plan_element
1773: EXCEPTION
1774: WHEN fnd_api.g_exc_error
1775: THEN

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

1773: EXCEPTION
1774: WHEN fnd_api.g_exc_error
1775: THEN
1776: x_return_status := fnd_api.g_ret_sts_error;
1777: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1778: WHEN fnd_api.g_exc_unexpected_error
1779: THEN
1780: x_return_status := fnd_api.g_ret_sts_unexp_error;
1781: x_loading_status := 'UNEXPECTED_ERR';

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

1778: WHEN fnd_api.g_exc_unexpected_error
1779: THEN
1780: x_return_status := fnd_api.g_ret_sts_unexp_error;
1781: x_loading_status := 'UNEXPECTED_ERR';
1782: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1783: WHEN OTHERS
1784: THEN
1785: x_return_status := fnd_api.g_ret_sts_unexp_error;
1786: x_loading_status := 'UNEXPECTED_ERR';

Line 1788: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1784: THEN
1785: x_return_status := fnd_api.g_ret_sts_unexp_error;
1786: x_loading_status := 'UNEXPECTED_ERR';
1787:
1788: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1789: THEN
1790: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1791: END IF;
1792:

Line 1790: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1786: x_loading_status := 'UNEXPECTED_ERR';
1787:
1788: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1789: THEN
1790: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1791: END IF;
1792:
1793: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1794: END valid_plan_element;

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

1789: THEN
1790: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1791: END IF;
1792:
1793: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1794: END valid_plan_element;
1795:
1796: --|--------------------------------------------------------------------------+
1797: --|Procedure: Check Valid Update

Line 1863: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1859: IF x_old_pe_rec.quota_id IS NULL
1860: THEN
1861: IF p_quota_name_old IS NOT NULL
1862: THEN
1863: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1864: THEN
1865: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
1866: fnd_message.set_token ('PE_NAME', p_quota_name_old);
1867: fnd_msg_pub.ADD;

Line 1867: fnd_msg_pub.ADD;

1863: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1864: THEN
1865: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
1866: fnd_message.set_token ('PE_NAME', p_quota_name_old);
1867: fnd_msg_pub.ADD;
1868: END IF;
1869:
1870: x_loading_status := 'CN_PLN_NOT_EXIST';
1871: RAISE fnd_api.g_exc_error;

Line 1883: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

1879: -- or just parent.
1880: -- Check the New Quota name, must be unique
1881: IF p_new_pe_rec.quota_id IS NOT NULL AND p_new_pe_rec.quota_id <> x_old_pe_rec.quota_id
1882: THEN
1883: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1884: THEN
1885: fnd_message.set_name ('CN', 'PLN_QUOTA_EXISTS');
1886: fnd_msg_pub.ADD;
1887: END IF;

Line 1886: fnd_msg_pub.ADD;

1882: THEN
1883: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1884: THEN
1885: fnd_message.set_name ('CN', 'PLN_QUOTA_EXISTS');
1886: fnd_msg_pub.ADD;
1887: END IF;
1888:
1889: x_loading_status := 'CN_PLN_EXISTS';
1890: RAISE fnd_api.g_exc_error;

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

1972: RAISE fnd_api.g_exc_error;
1973: END IF;
1974:
1975: -- Standard call to get message count and if count is 1, get message info.
1976: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1977: -- End of Check_valid_update
1978: EXCEPTION
1979: WHEN fnd_api.g_exc_error
1980: THEN

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

1978: EXCEPTION
1979: WHEN fnd_api.g_exc_error
1980: THEN
1981: x_return_status := fnd_api.g_ret_sts_error;
1982: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1983: WHEN fnd_api.g_exc_unexpected_error
1984: THEN
1985: x_return_status := fnd_api.g_ret_sts_unexp_error;
1986: x_loading_status := 'UNEXPECTED_ERR';

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

1983: WHEN fnd_api.g_exc_unexpected_error
1984: THEN
1985: x_return_status := fnd_api.g_ret_sts_unexp_error;
1986: x_loading_status := 'UNEXPECTED_ERR';
1987: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1988: WHEN OTHERS
1989: THEN
1990: x_return_status := fnd_api.g_ret_sts_unexp_error;
1991: x_loading_status := 'UNEXPECTED_ERR';

Line 1993: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1989: THEN
1990: x_return_status := fnd_api.g_ret_sts_unexp_error;
1991: x_loading_status := 'UNEXPECTED_ERR';
1992:
1993: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1994: THEN
1995: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1996: END IF;
1997:

Line 1995: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1991: x_loading_status := 'UNEXPECTED_ERR';
1992:
1993: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1994: THEN
1995: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1996: END IF;
1997:
1998: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1999: END check_valid_update;

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

1994: THEN
1995: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1996: END IF;
1997:
1998: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1999: END check_valid_update;
2000:
2001: --|--------------------------------------------------------------------------+
2002: --|Procedure: Create_plan_element

Line 2068: fnd_msg_pub.initialize;

2064:
2065: -- Initialize message list if p_init_msg_list is set to TRUE.
2066: IF fnd_api.to_boolean (p_init_msg_list)
2067: THEN
2068: fnd_msg_pub.initialize;
2069: END IF;
2070:
2071: -- Initialize API return status to success
2072: x_return_status := fnd_api.g_ret_sts_success;

Line 2406: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

2402: AND l_p_period_quotas_rec_tbl.COUNT = 0
2403: AND l_p_rt_quota_asgns_rec_tbl.COUNT = 0
2404: )
2405: THEN
2406: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2407: THEN
2408: fnd_message.set_name ('CN', 'PLN_QUOTA_EXISTS');
2409: fnd_msg_pub.ADD;
2410: END IF;

Line 2409: fnd_msg_pub.ADD;

2405: THEN
2406: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2407: THEN
2408: fnd_message.set_name ('CN', 'PLN_QUOTA_EXISTS');
2409: fnd_msg_pub.ADD;
2410: END IF;
2411:
2412: GOTO end_api_body;
2413: ELSE

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

2633:
2634: --
2635: -- Standard call to get message count and if count is 1, get message info.
2636: --
2637: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2638: EXCEPTION
2639: WHEN fnd_api.g_exc_error
2640: THEN
2641: ROLLBACK TO create_plan_element;

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

2639: WHEN fnd_api.g_exc_error
2640: THEN
2641: ROLLBACK TO create_plan_element;
2642: x_return_status := fnd_api.g_ret_sts_error;
2643: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2644: WHEN fnd_api.g_exc_unexpected_error
2645: THEN
2646: ROLLBACK TO create_plan_element;
2647: x_loading_status := 'UNEXPECTED_ERR';

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

2645: THEN
2646: ROLLBACK TO create_plan_element;
2647: x_loading_status := 'UNEXPECTED_ERR';
2648: x_return_status := fnd_api.g_ret_sts_unexp_error;
2649: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2650: WHEN COLLECTION_IS_NULL
2651: THEN
2652: ROLLBACK TO create_plan_element;
2653: x_loading_status := 'COLLECTION_IS_NULL';

Line 2656: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2652: ROLLBACK TO create_plan_element;
2653: x_loading_status := 'COLLECTION_IS_NULL';
2654: x_return_status := fnd_api.g_ret_sts_unexp_error;
2655:
2656: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2657: THEN
2658: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2659: END IF;
2660:

Line 2658: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2654: x_return_status := fnd_api.g_ret_sts_unexp_error;
2655:
2656: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2657: THEN
2658: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2659: END IF;
2660:
2661: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2662: WHEN SUBSCRIPT_BEYOND_COUNT

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

2657: THEN
2658: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2659: END IF;
2660:
2661: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2662: WHEN SUBSCRIPT_BEYOND_COUNT
2663: THEN
2664: ROLLBACK TO create_plan_element;
2665: x_loading_status := 'SUBSCRIPT_BEYOND_COUNT';

Line 2668: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2664: ROLLBACK TO create_plan_element;
2665: x_loading_status := 'SUBSCRIPT_BEYOND_COUNT';
2666: x_return_status := fnd_api.g_ret_sts_unexp_error;
2667:
2668: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2669: THEN
2670: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2671: END IF;
2672:

Line 2670: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2666: x_return_status := fnd_api.g_ret_sts_unexp_error;
2667:
2668: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2669: THEN
2670: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2671: END IF;
2672:
2673: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2674: WHEN SUBSCRIPT_OUTSIDE_LIMIT

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

2669: THEN
2670: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2671: END IF;
2672:
2673: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2674: WHEN SUBSCRIPT_OUTSIDE_LIMIT
2675: THEN
2676: ROLLBACK TO create_plan_element;
2677: x_loading_status := 'SUBSCRIPT_OUTSIDE_LIMIT';

Line 2680: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2676: ROLLBACK TO create_plan_element;
2677: x_loading_status := 'SUBSCRIPT_OUTSIDE_LIMIT';
2678: x_return_status := fnd_api.g_ret_sts_unexp_error;
2679:
2680: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2681: THEN
2682: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2683: END IF;
2684:

Line 2682: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2678: x_return_status := fnd_api.g_ret_sts_unexp_error;
2679:
2680: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2681: THEN
2682: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2683: END IF;
2684:
2685: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2686: WHEN OTHERS

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

2681: THEN
2682: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2683: END IF;
2684:
2685: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2686: WHEN OTHERS
2687: THEN
2688: ROLLBACK TO create_plan_element;
2689: x_loading_status := 'UNEXPECTED_ERR';

Line 2692: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2688: ROLLBACK TO create_plan_element;
2689: x_loading_status := 'UNEXPECTED_ERR';
2690: x_return_status := fnd_api.g_ret_sts_unexp_error;
2691:
2692: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2693: THEN
2694: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2695: END IF;
2696:

Line 2694: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2690: x_return_status := fnd_api.g_ret_sts_unexp_error;
2691:
2692: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2693: THEN
2694: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2695: END IF;
2696:
2697: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2698: END create_plan_element;

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

2693: THEN
2694: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2695: END IF;
2696:
2697: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2698: END create_plan_element;
2699:
2700: --***********************Very Important Please Read**************************
2701: -- 1. You Must the pass the full new record for update and the Unique key

Line 2834: fnd_msg_pub.initialize;

2830:
2831: -- Initialize message list if p_init_msg_list is set to TRUE.
2832: IF fnd_api.to_boolean (p_init_msg_list)
2833: THEN
2834: fnd_msg_pub.initialize;
2835: END IF;
2836:
2837: -- Initialize API return status to success
2838: x_return_status := fnd_api.g_ret_sts_success;

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

3499: COMMIT WORK;
3500: END IF;
3501:
3502: -- Standard call to get message count and if count is 1, get message info.
3503: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3504: -- End of Update Plan Element
3505: EXCEPTION
3506: WHEN fnd_api.g_exc_error
3507: THEN

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

3506: WHEN fnd_api.g_exc_error
3507: THEN
3508: ROLLBACK TO update_plan_element;
3509: x_return_status := fnd_api.g_ret_sts_error;
3510: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3511: WHEN fnd_api.g_exc_unexpected_error
3512: THEN
3513: ROLLBACK TO update_plan_element;
3514: x_loading_status := 'UNEXPECTED_ERR';

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

3512: THEN
3513: ROLLBACK TO update_plan_element;
3514: x_loading_status := 'UNEXPECTED_ERR';
3515: x_return_status := fnd_api.g_ret_sts_unexp_error;
3516: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3517: WHEN COLLECTION_IS_NULL
3518: THEN
3519: ROLLBACK TO update_plan_element;
3520: x_loading_status := 'COLLECTION_IS_NULL';

Line 3523: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

3519: ROLLBACK TO update_plan_element;
3520: x_loading_status := 'COLLECTION_IS_NULL';
3521: x_return_status := fnd_api.g_ret_sts_unexp_error;
3522:
3523: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3524: THEN
3525: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3526: END IF;
3527:

Line 3525: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3521: x_return_status := fnd_api.g_ret_sts_unexp_error;
3522:
3523: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3524: THEN
3525: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3526: END IF;
3527:
3528: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3529: WHEN SUBSCRIPT_BEYOND_COUNT

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

3524: THEN
3525: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3526: END IF;
3527:
3528: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3529: WHEN SUBSCRIPT_BEYOND_COUNT
3530: THEN
3531: ROLLBACK TO update_plan_element;
3532: x_loading_status := 'SUBSCRIPT_BEYOND_COUNT';

Line 3535: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

3531: ROLLBACK TO update_plan_element;
3532: x_loading_status := 'SUBSCRIPT_BEYOND_COUNT';
3533: x_return_status := fnd_api.g_ret_sts_unexp_error;
3534:
3535: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3536: THEN
3537: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3538: END IF;
3539:

Line 3537: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3533: x_return_status := fnd_api.g_ret_sts_unexp_error;
3534:
3535: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3536: THEN
3537: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3538: END IF;
3539:
3540: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3541: WHEN SUBSCRIPT_OUTSIDE_LIMIT

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

3536: THEN
3537: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3538: END IF;
3539:
3540: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3541: WHEN SUBSCRIPT_OUTSIDE_LIMIT
3542: THEN
3543: ROLLBACK TO update_plan_element;
3544: x_loading_status := 'SUBSCRIPT_OUTSIDE_LIMIT';

Line 3547: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

3543: ROLLBACK TO update_plan_element;
3544: x_loading_status := 'SUBSCRIPT_OUTSIDE_LIMIT';
3545: x_return_status := fnd_api.g_ret_sts_unexp_error;
3546:
3547: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3548: THEN
3549: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3550: END IF;
3551:

Line 3549: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3545: x_return_status := fnd_api.g_ret_sts_unexp_error;
3546:
3547: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3548: THEN
3549: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3550: END IF;
3551:
3552: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3553: WHEN OTHERS

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

3548: THEN
3549: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3550: END IF;
3551:
3552: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3553: WHEN OTHERS
3554: THEN
3555: ROLLBACK TO update_plan_element;
3556: x_loading_status := 'UNEXPECTED_ERR';

Line 3559: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

3555: ROLLBACK TO update_plan_element;
3556: x_loading_status := 'UNEXPECTED_ERR';
3557: x_return_status := fnd_api.g_ret_sts_unexp_error;
3558:
3559: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3560: THEN
3561: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3562: END IF;
3563:

Line 3561: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3557: x_return_status := fnd_api.g_ret_sts_unexp_error;
3558:
3559: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3560: THEN
3561: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3562: END IF;
3563:
3564: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3565: END update_plan_element;

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

3560: THEN
3561: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3562: END IF;
3563:
3564: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3565: END update_plan_element;
3566:
3567: -- End Update Plan Element
3568:

Line 3678: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

3674: -- check the Quota id if the Quota ID is Null and the Quota name is Not null
3675: -- Raise an Error
3676: IF l_quota_id IS NULL AND l_p_quota_name IS NOT NULL
3677: THEN
3678: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
3679: THEN
3680: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
3681: fnd_message.set_token ('PE_NAME', l_p_quota_name);
3682: fnd_msg_pub.ADD;

Line 3682: fnd_msg_pub.ADD;

3678: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
3679: THEN
3680: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
3681: fnd_message.set_token ('PE_NAME', l_p_quota_name);
3682: fnd_msg_pub.ADD;
3683: END IF;
3684:
3685: x_loading_status := 'CN_PLN_NOT_EXIST';
3686: RAISE fnd_api.g_exc_error;

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

3716: WHEN fnd_api.g_exc_error
3717: THEN
3718: ROLLBACK TO process_input_records;
3719: x_return_status := fnd_api.g_ret_sts_error;
3720: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3721: WHEN fnd_api.g_exc_unexpected_error
3722: THEN
3723: ROLLBACK TO process_input_records;
3724: x_loading_status := 'UNEXPECTED_ERR';

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

3722: THEN
3723: ROLLBACK TO process_input_records;
3724: x_loading_status := 'UNEXPECTED_ERR';
3725: x_return_status := fnd_api.g_ret_sts_unexp_error;
3726: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3727: WHEN OTHERS
3728: THEN
3729: ROLLBACK TO process_input_records;
3730: x_loading_status := 'UNEXPECTED_ERR';

Line 3733: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

3729: ROLLBACK TO process_input_records;
3730: x_loading_status := 'UNEXPECTED_ERR';
3731: x_return_status := fnd_api.g_ret_sts_unexp_error;
3732:
3733: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3734: THEN
3735: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3736: END IF;
3737:

Line 3735: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3731: x_return_status := fnd_api.g_ret_sts_unexp_error;
3732:
3733: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3734: THEN
3735: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3736: END IF;
3737:
3738: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3739: END process_input_records;

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

3734: THEN
3735: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3736: END IF;
3737:
3738: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3739: END process_input_records;
3740:
3741: PROCEDURE delete_plan_element (
3742: p_api_version IN NUMBER := 0,

Line 3799: fnd_msg_pub.initialize;

3795:
3796: -- Initialize message list if p_init_msg_list is set to TRUE.
3797: IF fnd_api.to_boolean (p_init_msg_list)
3798: THEN
3799: fnd_msg_pub.initialize;
3800: END IF;
3801:
3802: -- Initialize API return status to success
3803: x_return_status := fnd_api.g_ret_sts_success;

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

4063:
4064: --
4065: -- Standard call to get message count and if count is 1, get message info.
4066: --
4067: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4068: -- End of Delete Plan Element
4069: EXCEPTION
4070: WHEN fnd_api.g_exc_error
4071: THEN

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

4070: WHEN fnd_api.g_exc_error
4071: THEN
4072: ROLLBACK TO delete_plan_element;
4073: x_return_status := fnd_api.g_ret_sts_error;
4074: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4075: WHEN fnd_api.g_exc_unexpected_error
4076: THEN
4077: ROLLBACK TO delete_plan_element;
4078: x_loading_status := 'UNEXPECTED_ERR';

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

4076: THEN
4077: ROLLBACK TO delete_plan_element;
4078: x_loading_status := 'UNEXPECTED_ERR';
4079: x_return_status := fnd_api.g_ret_sts_unexp_error;
4080: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4081: WHEN OTHERS
4082: THEN
4083: ROLLBACK TO delete_plan_element;
4084: x_loading_status := 'UNEXPECTED_ERR';

Line 4087: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

4083: ROLLBACK TO delete_plan_element;
4084: x_loading_status := 'UNEXPECTED_ERR';
4085: x_return_status := fnd_api.g_ret_sts_unexp_error;
4086:
4087: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
4088: THEN
4089: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4090: END IF;
4091:

Line 4089: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

4085: x_return_status := fnd_api.g_ret_sts_unexp_error;
4086:
4087: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
4088: THEN
4089: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4090: END IF;
4091:
4092: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4093: END delete_plan_element;

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

4088: THEN
4089: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4090: END IF;
4091:
4092: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4093: END delete_plan_element;
4094:
4095: -- -------------------------------------------------------------------------+
4096: -- | Procedure: Get_Plan_Element

Line 4371: fnd_msg_pub.initialize;

4367:
4368: -- Initialize message list if p_init_msg_list is set to TRUE.
4369: IF fnd_api.to_boolean (p_init_msg_list)
4370: THEN
4371: fnd_msg_pub.initialize;
4372: END IF;
4373:
4374: -- Initialize API return status to success
4375: x_return_status := fnd_api.g_ret_sts_success;

Line 4451: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

4447: -- Check the Quota ID for for the Quota Name you Passed
4448: -- if the Quota ID id null then raise an Error
4449: IF l_quota_id IS NULL
4450: THEN
4451: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4452: THEN
4453: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
4454: fnd_message.set_token ('PE_NAME', l_pe_name);
4455: fnd_msg_pub.ADD;

Line 4455: fnd_msg_pub.ADD;

4451: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4452: THEN
4453: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
4454: fnd_message.set_token ('PE_NAME', l_pe_name);
4455: fnd_msg_pub.ADD;
4456: END IF;
4457:
4458: x_loading_status := 'CN_PLN_NOT_EXIST';
4459: GOTO end_api;

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

4570:
4571: <>
4572: NULL;
4573: -- Standard call to get message count and if count is 1, get message info.
4574: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4575: -- END get plan element
4576: EXCEPTION
4577: WHEN fnd_api.g_exc_error
4578: THEN

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

4577: WHEN fnd_api.g_exc_error
4578: THEN
4579: ROLLBACK TO get_plan_element;
4580: x_return_status := fnd_api.g_ret_sts_error;
4581: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4582: WHEN fnd_api.g_exc_unexpected_error
4583: THEN
4584: ROLLBACK TO get_plan_element;
4585: x_loading_status := 'UNEXPECTED_ERR';

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

4583: THEN
4584: ROLLBACK TO get_plan_element;
4585: x_loading_status := 'UNEXPECTED_ERR';
4586: x_return_status := fnd_api.g_ret_sts_unexp_error;
4587: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4588: WHEN COLLECTION_IS_NULL
4589: THEN
4590: ROLLBACK TO get_plan_element;
4591: x_loading_status := 'COLLECTION_IS_NULL';

Line 4594: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

4590: ROLLBACK TO get_plan_element;
4591: x_loading_status := 'COLLECTION_IS_NULL';
4592: x_return_status := fnd_api.g_ret_sts_unexp_error;
4593:
4594: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
4595: THEN
4596: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4597: END IF;
4598:

Line 4596: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

4592: x_return_status := fnd_api.g_ret_sts_unexp_error;
4593:
4594: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
4595: THEN
4596: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4597: END IF;
4598:
4599: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4600: WHEN NO_DATA_FOUND

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

4595: THEN
4596: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4597: END IF;
4598:
4599: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4600: WHEN NO_DATA_FOUND
4601: THEN
4602: ROLLBACK TO get_plan_element;
4603: x_loading_status := 'NO_DATA_FOUND';

Line 4606: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

4602: ROLLBACK TO get_plan_element;
4603: x_loading_status := 'NO_DATA_FOUND';
4604: x_return_status := fnd_api.g_ret_sts_unexp_error;
4605:
4606: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
4607: THEN
4608: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4609: END IF;
4610:

Line 4608: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

4604: x_return_status := fnd_api.g_ret_sts_unexp_error;
4605:
4606: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
4607: THEN
4608: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4609: END IF;
4610:
4611: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4612: WHEN SUBSCRIPT_BEYOND_COUNT

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

4607: THEN
4608: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4609: END IF;
4610:
4611: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4612: WHEN SUBSCRIPT_BEYOND_COUNT
4613: THEN
4614: ROLLBACK TO get_plan_element;
4615: x_loading_status := 'SUBSCRIPT_BEYOND_COUNT';

Line 4618: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

4614: ROLLBACK TO get_plan_element;
4615: x_loading_status := 'SUBSCRIPT_BEYOND_COUNT';
4616: x_return_status := fnd_api.g_ret_sts_unexp_error;
4617:
4618: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
4619: THEN
4620: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4621: END IF;
4622:

Line 4620: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

4616: x_return_status := fnd_api.g_ret_sts_unexp_error;
4617:
4618: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
4619: THEN
4620: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4621: END IF;
4622:
4623: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4624: WHEN SUBSCRIPT_OUTSIDE_LIMIT

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

4619: THEN
4620: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4621: END IF;
4622:
4623: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4624: WHEN SUBSCRIPT_OUTSIDE_LIMIT
4625: THEN
4626: ROLLBACK TO get_plan_element;
4627: x_loading_status := 'SUBSCRIPT_OUTSIDE_LIMIT';

Line 4630: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

4626: ROLLBACK TO get_plan_element;
4627: x_loading_status := 'SUBSCRIPT_OUTSIDE_LIMIT';
4628: x_return_status := fnd_api.g_ret_sts_unexp_error;
4629:
4630: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
4631: THEN
4632: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4633: END IF;
4634:

Line 4632: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

4628: x_return_status := fnd_api.g_ret_sts_unexp_error;
4629:
4630: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
4631: THEN
4632: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4633: END IF;
4634:
4635: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4636: WHEN OTHERS

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

4631: THEN
4632: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4633: END IF;
4634:
4635: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4636: WHEN OTHERS
4637: THEN
4638: ROLLBACK TO get_plan_element;
4639: x_loading_status := 'UNEXPECTED_ERR';

Line 4642: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

4638: ROLLBACK TO get_plan_element;
4639: x_loading_status := 'UNEXPECTED_ERR';
4640: x_return_status := fnd_api.g_ret_sts_unexp_error;
4641:
4642: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
4643: THEN
4644: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4645: END IF;
4646:

Line 4644: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

4640: x_return_status := fnd_api.g_ret_sts_unexp_error;
4641:
4642: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
4643: THEN
4644: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4645: END IF;
4646:
4647: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4648: END get_plan_element;

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

4643: THEN
4644: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4645: END IF;
4646:
4647: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4648: END get_plan_element;
4649:
4650: -- -------------------------------------------------------------------------+
4651: -- | Procedure: Duplicate_Plan_Element

Line 4706: fnd_msg_pub.initialize;

4702:
4703: -- Initialize message list if p_init_msg_list is set to TRUE.
4704: IF fnd_api.to_boolean (p_init_msg_list)
4705: THEN
4706: fnd_msg_pub.initialize;
4707: END IF;
4708:
4709: -- Initialize API return status to success
4710: x_return_status := fnd_api.g_ret_sts_success;

Line 4807: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

4803: THEN
4804: l_x_plan_element_name := CONCAT (SUBSTRB (l_plan_element_rec.NAME, 1, l_length), '_2');
4805:
4806: -- Add CN_DUP_PLN_NAME_TOO_LONG message
4807: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4808: THEN
4809: fnd_message.set_name ('CN', 'CN_DUP_PLN_NAME_TOO_LONG');
4810: fnd_message.set_token ('FROM_PE', l_p_plan_element_name);
4811: fnd_message.set_token ('TO_PE', l_x_plan_element_name);

Line 4812: fnd_msg_pub.ADD;

4808: THEN
4809: fnd_message.set_name ('CN', 'CN_DUP_PLN_NAME_TOO_LONG');
4810: fnd_message.set_token ('FROM_PE', l_p_plan_element_name);
4811: fnd_message.set_token ('TO_PE', l_x_plan_element_name);
4812: fnd_msg_pub.ADD;
4813: END IF;
4814:
4815: l_warning_flag := 'Y';
4816: ELSE

Line 4850: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

4846: -- Check The Created Plan Element Already Exists in Database
4847: IF cn_chk_plan_element_pkg.get_quota_id (l_x_plan_element_name,p_org_id) IS NOT NULL
4848: THEN
4849: -- IF Plan Element Exists Raise an Error
4850: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4851: THEN
4852: fnd_message.set_name ('CN', 'PLN_QUOTA_EXISTS');
4853: fnd_msg_pub.ADD;
4854: END IF;

Line 4853: fnd_msg_pub.ADD;

4849: -- IF Plan Element Exists Raise an Error
4850: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4851: THEN
4852: fnd_message.set_name ('CN', 'PLN_QUOTA_EXISTS');
4853: fnd_msg_pub.ADD;
4854: END IF;
4855:
4856: x_loading_status := 'CN_PLN_EXISTS';
4857: RAISE fnd_api.g_exc_error;

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

4980: COMMIT WORK;
4981: END IF;
4982:
4983: -- Standard call to get message count and if count is 1, get message info.
4984: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4985: -- End of Duplicate Plan ELement
4986: EXCEPTION
4987: WHEN fnd_api.g_exc_error
4988: THEN

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

4987: WHEN fnd_api.g_exc_error
4988: THEN
4989: ROLLBACK TO duplicate_pe;
4990: x_return_status := fnd_api.g_ret_sts_error;
4991: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4992: WHEN fnd_api.g_exc_unexpected_error
4993: THEN
4994: ROLLBACK TO duplicate_pe;
4995: x_loading_status := 'UNEXPECTED_ERR';

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

4993: THEN
4994: ROLLBACK TO duplicate_pe;
4995: x_loading_status := 'UNEXPECTED_ERR';
4996: x_return_status := fnd_api.g_ret_sts_unexp_error;
4997: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4998: WHEN OTHERS
4999: THEN
5000: ROLLBACK TO duplicate_pe;
5001: x_loading_status := 'UNEXPECTED_ERR';

Line 5004: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

5000: ROLLBACK TO duplicate_pe;
5001: x_loading_status := 'UNEXPECTED_ERR';
5002: x_return_status := fnd_api.g_ret_sts_unexp_error;
5003:
5004: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
5005: THEN
5006: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5007: END IF;
5008:

Line 5006: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

5002: x_return_status := fnd_api.g_ret_sts_unexp_error;
5003:
5004: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
5005: THEN
5006: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5007: END IF;
5008:
5009: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
5010: END duplicate_plan_element;

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

5005: THEN
5006: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5007: END IF;
5008:
5009: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
5010: END duplicate_plan_element;
5011: END cn_plan_element_pub;