DBA Data[Home] [Help]

APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_API

Line 319: l_temp_1 := cn_api.get_lkup_meaning(p_plan_element_old.quota_type_code, 'QUOTA_TYPE');

315: -- CHECK IF FORMULA TYPE WAS UPDATED
316: IF (p_plan_element_old.quota_type_code <> p_plan_element_new.quota_type_code) THEN
317: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_FORTYPE_UPDATE');
318: l_plan_element_id := p_plan_element_new.quota_id;
319: l_temp_1 := cn_api.get_lkup_meaning(p_plan_element_old.quota_type_code, 'QUOTA_TYPE');
320: l_temp_2 := cn_api.get_lkup_meaning(p_plan_element_new.quota_type_code, 'QUOTA_TYPE');
321: fnd_message.set_token('PE_OLD_FOR', l_temp_1);
322: fnd_message.set_token('PE_NEW_FOR', l_temp_2);
323: l_note_msg := fnd_message.get;

Line 320: l_temp_2 := cn_api.get_lkup_meaning(p_plan_element_new.quota_type_code, 'QUOTA_TYPE');

316: IF (p_plan_element_old.quota_type_code <> p_plan_element_new.quota_type_code) THEN
317: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_FORTYPE_UPDATE');
318: l_plan_element_id := p_plan_element_new.quota_id;
319: l_temp_1 := cn_api.get_lkup_meaning(p_plan_element_old.quota_type_code, 'QUOTA_TYPE');
320: l_temp_2 := cn_api.get_lkup_meaning(p_plan_element_new.quota_type_code, 'QUOTA_TYPE');
321: fnd_message.set_token('PE_OLD_FOR', l_temp_1);
322: fnd_message.set_token('PE_NEW_FOR', l_temp_2);
323: l_note_msg := fnd_message.get;
324: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

Line 361: l_temp_1 := cn_api.get_lkup_meaning(p_plan_element_old.quota_type_code, 'QUOTA_TYPE');

357: WHERE CALC_FORMULA_ID = p_plan_element_new.calc_formula_id;
358: ELSE
359: l_temp_new := p_plan_element_new.package_name;
360: END IF;
361: l_temp_1 := cn_api.get_lkup_meaning(p_plan_element_old.quota_type_code, 'QUOTA_TYPE');
362: l_temp_2 := cn_api.get_lkup_meaning(p_plan_element_new.quota_type_code, 'QUOTA_TYPE');
363: fnd_message.set_token('FORMULA_TYPE_OLD', l_temp_1);
364: fnd_message.set_token('FORMULA_NAME_OLD', l_temp_old);
365: fnd_message.set_token('FORMULA_TYPE_NEW', l_temp_2);

Line 362: l_temp_2 := cn_api.get_lkup_meaning(p_plan_element_new.quota_type_code, 'QUOTA_TYPE');

358: ELSE
359: l_temp_new := p_plan_element_new.package_name;
360: END IF;
361: l_temp_1 := cn_api.get_lkup_meaning(p_plan_element_old.quota_type_code, 'QUOTA_TYPE');
362: l_temp_2 := cn_api.get_lkup_meaning(p_plan_element_new.quota_type_code, 'QUOTA_TYPE');
363: fnd_message.set_token('FORMULA_TYPE_OLD', l_temp_1);
364: fnd_message.set_token('FORMULA_NAME_OLD', l_temp_old);
365: fnd_message.set_token('FORMULA_TYPE_NEW', l_temp_2);
366: fnd_message.set_token('FORMULA_NAME_NEW', l_temp_new);

Line 524: l_temp_old := cn_api.get_lkup_meaning(p_plan_element_old.indirect_credit_code, 'INDIRECT_CREDIT_TYPE');

520:
521: -- CHECK IF CREDIT ROLLUP WAS UPDATED
522: IF (p_plan_element_old.indirect_credit_code <> p_plan_element_new.indirect_credit_code) THEN
523: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_CRROLL_UPDATE');
524: l_temp_old := cn_api.get_lkup_meaning(p_plan_element_old.indirect_credit_code, 'INDIRECT_CREDIT_TYPE');
525: l_temp_new := cn_api.get_lkup_meaning(p_plan_element_new.indirect_credit_code, 'INDIRECT_CREDIT_TYPE');
526: fnd_message.set_token('PE_CR_ROLL_OLD', l_temp_old);
527: fnd_message.set_token('PE_CR_ROLL_NEW', l_temp_new);
528: l_plan_element_id := p_plan_element_new.quota_id;

Line 525: l_temp_new := cn_api.get_lkup_meaning(p_plan_element_new.indirect_credit_code, 'INDIRECT_CREDIT_TYPE');

521: -- CHECK IF CREDIT ROLLUP WAS UPDATED
522: IF (p_plan_element_old.indirect_credit_code <> p_plan_element_new.indirect_credit_code) THEN
523: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_CRROLL_UPDATE');
524: l_temp_old := cn_api.get_lkup_meaning(p_plan_element_old.indirect_credit_code, 'INDIRECT_CREDIT_TYPE');
525: l_temp_new := cn_api.get_lkup_meaning(p_plan_element_new.indirect_credit_code, 'INDIRECT_CREDIT_TYPE');
526: fnd_message.set_token('PE_CR_ROLL_OLD', l_temp_old);
527: fnd_message.set_token('PE_CR_ROLL_NEW', l_temp_new);
528: l_plan_element_id := p_plan_element_new.quota_id;
529: l_note_msg := fnd_message.get;

Line 939: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PAYMENT_GROUP', 'PE_OBJECT_TYPE'));

935: THEN
936: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
937: THEN
938: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
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;

Line 957: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('QUOTA_GROUP', 'PE_OBJECT_TYPE'));

953: THEN
954: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
955: THEN
956: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
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;

Line 978: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('STATUS', 'PE_OBJECT_TYPE'));

974: THEN
975: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
976: THEN
977: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
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;

Line 1001: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('INDIRECT_CREDIT_TYPE', 'PE_OBJECT_TYPE'));

997: THEN
998: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
999: THEN
1000: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
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;

Line 1049: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('CREDIT_TYPE', 'PE_OBJECT_TYPE'));

1045: THEN
1046: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1047: THEN
1048: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
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;

Line 1070: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PERIOD_TYPE', 'PE_OBJECT_TYPE'));

1066: THEN
1067: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1068: THEN
1069: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
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;

Line 1089: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('CREDIT_TYPE', 'PE_OBJECT_TYPE'));

1085: THEN
1086: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1087: THEN
1088: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
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;

Line 1102: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PERIOD_TYPE', 'PE_OBJECT_TYPE'));

1098: THEN
1099: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1100: THEN
1101: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
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;

Line 1114: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('FORMULA', 'QUOTA_TYPE'));

1110: THEN
1111: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1112: THEN
1113: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
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;

Line 2247: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));

2243: THEN
2244: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2245: THEN
2246: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
2247: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2248: fnd_msg_pub.ADD;
2249: END IF;
2250:
2251: RAISE fnd_api.g_exc_error;

Line 2293: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));

2289: THEN
2290: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2291: THEN
2292: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
2293: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2294: fnd_msg_pub.ADD;
2295: END IF;
2296:
2297: RAISE fnd_api.g_exc_error;

Line 2311: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));

2307: THEN
2308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2309: THEN
2310: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2311: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
2312: fnd_msg_pub.ADD;
2313: END IF;
2314:
2315: RAISE fnd_api.g_exc_error;

Line 2324: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('SD', 'INPUT_TOKEN'));

2320: THEN
2321: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2322: THEN
2323: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2324: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('SD', 'INPUT_TOKEN'));
2325: fnd_msg_pub.ADD;
2326: END IF;
2327:
2328: RAISE fnd_api.g_exc_error;

Line 2357: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));

2353: THEN
2354: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2355: THEN
2356: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2357: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));
2358: fnd_msg_pub.ADD;
2359: END IF;
2360:
2361: RAISE fnd_api.g_exc_error;

Line 2369: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));

2365: THEN
2366: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2367: THEN
2368: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
2369: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));
2370: fnd_msg_pub.ADD;
2371: END IF;
2372:
2373: RAISE fnd_api.g_exc_error;

Line 2381: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLE(S)', 'PE_OBJECT_TYPE'));

2377: THEN
2378: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2379: THEN
2380: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
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;

Line 2393: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PAYEE_ASSIGN', 'PE_OBJECT_TYPE'));

2389: THEN
2390: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2391: THEN
2392: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
2393: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PAYEE_ASSIGN', 'PE_OBJECT_TYPE'));
2394: fnd_msg_pub.ADD;
2395: END IF;
2396:
2397: RAISE fnd_api.g_exc_error;

Line 2405: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('ADD_FROM_REVCLASS', 'PE_OBJECT_TYPE'));

2401: THEN
2402: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2403: THEN
2404: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
2405: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('ADD_FROM_REVCLASS', 'PE_OBJECT_TYPE'));
2406: fnd_msg_pub.ADD;
2407: END IF;
2408:
2409: RAISE fnd_api.g_exc_error;

Line 2470: p_api_version IN NUMBER := cn_api.g_miss_num,

2466: -- Function :
2467: -- Pre-reqs : None.
2468: -- Parameters :
2469: PROCEDURE duplicate_plan_element (
2470: p_api_version IN NUMBER := cn_api.g_miss_num,
2471: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
2472: p_commit IN VARCHAR2 := cn_api.g_false,
2473: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
2474: p_quota_id IN cn_quotas.quota_id%TYPE := NULL,

Line 2471: p_init_msg_list IN VARCHAR2 := cn_api.g_false,

2467: -- Pre-reqs : None.
2468: -- Parameters :
2469: PROCEDURE duplicate_plan_element (
2470: p_api_version IN NUMBER := cn_api.g_miss_num,
2471: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
2472: p_commit IN VARCHAR2 := cn_api.g_false,
2473: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
2474: p_quota_id IN cn_quotas.quota_id%TYPE := NULL,
2475: x_plan_element OUT NOCOPY plan_element_rec_type,

Line 2472: p_commit IN VARCHAR2 := cn_api.g_false,

2468: -- Parameters :
2469: PROCEDURE duplicate_plan_element (
2470: p_api_version IN NUMBER := cn_api.g_miss_num,
2471: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
2472: p_commit IN VARCHAR2 := cn_api.g_false,
2473: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
2474: p_quota_id IN cn_quotas.quota_id%TYPE := NULL,
2475: x_plan_element OUT NOCOPY plan_element_rec_type,
2476: x_return_status OUT NOCOPY VARCHAR2,

Line 2473: p_validation_level IN NUMBER := cn_api.g_valid_level_full,

2469: PROCEDURE duplicate_plan_element (
2470: p_api_version IN NUMBER := cn_api.g_miss_num,
2471: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
2472: p_commit IN VARCHAR2 := cn_api.g_false,
2473: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
2474: p_quota_id IN cn_quotas.quota_id%TYPE := NULL,
2475: x_plan_element OUT NOCOPY plan_element_rec_type,
2476: x_return_status OUT NOCOPY VARCHAR2,
2477: x_msg_count OUT NOCOPY NUMBER,