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_CHK_PLAN_ELEMENT_PKG dependencies on CN_API

Line 33: IF (cn_api.pe_char_field_cannot_null

29: ('TARGET','REVENUE','UNIT_BASED_QUOTA','UNIT_BASED_NON_QUOTA',
30: 'DISCOUNT','MARGIN') ) THEN
31: IF (p_pe_rec.rate_table_id IS NULL) THEN
32: -- Rasie error when user Pass in Rate table Name = NULL
33: IF (cn_api.pe_char_field_cannot_null
34: ( p_char_field => p_pe_rec.rate_table_name,
35: p_pe_type => p_pe_rec.quota_type_code,
36: p_obj_name => G_RATE_TB,
37: p_token1 => NULL ,

Line 45: IF ( (cn_api.chk_miss_char_para

41: x_loading_status => x_loading_status) = FND_API.G_FALSE) THEN
42: RAISE FND_API.G_EXC_ERROR ;
43: END IF;
44: -- Rasie error when user missing Pass in Rate table Name
45: IF ( (cn_api.chk_miss_char_para
46: ( p_char_para => p_pe_rec.rate_table_name,
47: p_para_name => G_RATE_TB,
48: p_loading_status => x_loading_status,
49: x_loading_status => x_loading_status)) = FND_API.G_TRUE) THEN

Line 54: IF (CN_API.get_rate_table_id(p_pe_rec.rate_table_name)) IS NULL THEN

50: RAISE FND_API.G_EXC_ERROR ;
51: END IF;
52: -- Rasie error when user pass in rate table name not exist in
53: -- cn_rate_schedules
54: IF (CN_API.get_rate_table_id(p_pe_rec.rate_table_name)) IS NULL THEN
55: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
56: THEN
57: FND_MESSAGE.SET_NAME ('CN' , 'CN_RATE_SCH_NOT_EXIST');
58: FND_MSG_PUB.Add;

Line 66: IF (CN_API.get_rate_table_name(p_pe_rec.rate_table_id)) IS NULL THEN

62: END IF ;
63: ELSIF p_pe_rec.rate_table_name IS NULL THEN
64: -- Rate_table_id not null and rate_table_name null, check if
65: -- Rate_table_id is exist in DB
66: IF (CN_API.get_rate_table_name(p_pe_rec.rate_table_id)) IS NULL THEN
67: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
68: THEN
69: FND_MESSAGE.SET_NAME ('CN' , 'CN_RATE_SCH_NOT_EXIST');
70: FND_MSG_PUB.Add;

Line 80: CN_API.get_rate_table_id(p_pe_rec.rate_table_name)) THEN

76: -- If rate_table_id and rate_table_name both are not missing or null,
77: -- make sure they're compatible, access to same record in
78: -- CN_RATE_SCHEDULES
79: IF(p_pe_rec.rate_table_id <>
80: CN_API.get_rate_table_id(p_pe_rec.rate_table_name)) THEN
81: -- Error, check the msg level and add an error message to the
82: -- API message list
83: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
84: THEN

Line 236: IF (cn_api.pe_char_field_cannot_null

232: IF (p_pe_rec.quota_type_code IN ('TARGET','REVENUE') ) AND
233: (p_pe_rec.disc_option_code IN ('PAYMENT','QUOTA')) THEN
234: IF (p_pe_rec.disc_rate_table_id IS NULL) THEN
235: -- Rasie error when user Pass in Discount Rate table Name = NULL
236: IF (cn_api.pe_char_field_cannot_null
237: ( p_char_field => p_pe_rec.disc_rate_table_name,
238: p_pe_type => p_pe_rec.quota_type_code,
239: p_obj_name => G_DISC_RATE_TB,
240: p_token1 => G_DISC_OPTION ||' = '||

Line 241: cn_api.get_lkup_meaning

237: ( p_char_field => p_pe_rec.disc_rate_table_name,
238: p_pe_type => p_pe_rec.quota_type_code,
239: p_obj_name => G_DISC_RATE_TB,
240: p_token1 => G_DISC_OPTION ||' = '||
241: cn_api.get_lkup_meaning
242: (p_pe_rec.disc_option_code,'DISCOUNT_OPTION'),
243: p_token2 => NULL ,
244: p_token3 => NULL ,
245: p_loading_status => x_loading_status,

Line 250: IF ( (cn_api.chk_miss_char_para

246: x_loading_status => x_loading_status) = FND_API.G_FALSE) THEN
247: RAISE FND_API.G_EXC_ERROR ;
248: END IF;
249: -- Rasie error when user missing Pass in Discount Rate table Name
250: IF ( (cn_api.chk_miss_char_para
251: ( p_char_para => p_pe_rec.disc_rate_table_name,
252: p_para_name => G_DISC_RATE_TB,
253: p_loading_status => x_loading_status,
254: x_loading_status => x_loading_status)) = FND_API.G_TRUE) THEN

Line 259: IF (CN_API.get_rate_table_id(p_pe_rec.disc_rate_table_name)) IS NULL

255: RAISE FND_API.G_EXC_ERROR ;
256: END IF;
257: -- Rasie error when user pass in dicsount rate table name not exist in
258: -- cn_rate_schedules
259: IF (CN_API.get_rate_table_id(p_pe_rec.disc_rate_table_name)) IS NULL
260: THEN
261: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
262: THEN
263: FND_MESSAGE.SET_NAME ('CN' , 'PLN_QUOTA_DISC_SCHED_REQUIRED');

Line 272: IF (CN_API.get_rate_table_name(p_pe_rec.disc_rate_table_id)) IS NULL

268: END IF ;
269: ELSIF p_pe_rec.disc_rate_table_name IS NULL THEN
270: -- Disc_Rate_table_id not null and disc_rate_table_name null, check if
271: -- Disc_rate_table_id is exist in DB
272: IF (CN_API.get_rate_table_name(p_pe_rec.disc_rate_table_id)) IS NULL
273: THEN
274: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
275: THEN
276: FND_MESSAGE.SET_NAME ('CN' ,'PLN_QUOTA_DISC_SCHED_REQUIRED');

Line 288: CN_API.get_rate_table_id(p_pe_rec.disc_rate_table_name)) THEN

284: -- missing or null,
285: -- make sure they're compatible, access to same record in
286: -- CN_RATE_SCHEDULES
287: IF(p_pe_rec.disc_rate_table_id <>
288: CN_API.get_rate_table_id(p_pe_rec.disc_rate_table_name)) THEN
289: -- Error, check the msg level and add an error message to the
290: -- API message list
291: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
292: THEN

Line 396: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('ORGANIZATION', 'PE_OBJECT_TYPE'));

392: THEN
393: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
394: THEN
395: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
396: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('ORGANIZATION', 'PE_OBJECT_TYPE'));
397: fnd_msg_pub.ADD;
398: END IF;
399:
400: RAISE fnd_api.g_exc_error;

Line 429: IF (cn_api.pe_char_field_cannot_null (p_char_field => p_pe_rec.rev_class_name,

425: THEN
426: IF (p_pe_rec.rev_class_id IS NULL)
427: THEN
428: -- Rasie error when user Pass in revenue class Name = NULL
429: IF (cn_api.pe_char_field_cannot_null (p_char_field => p_pe_rec.rev_class_name,
430: p_pe_type => p_pe_rec.quota_type_code,
431: p_obj_name => g_rev_cls_name,
432: p_token1 => NULL,
433: p_token2 => NULL,

Line 444: IF ((cn_api.chk_miss_char_para (p_char_para => p_pe_rec.rev_class_name,

440: RAISE fnd_api.g_exc_error;
441: END IF;
442:
443: -- Rasie error when user missing Pass in revenue class Name
444: IF ((cn_api.chk_miss_char_para (p_char_para => p_pe_rec.rev_class_name,
445: p_para_name => g_rev_cls_name,
446: p_loading_status => x_loading_status,
447: x_loading_status => l_loading_status
448: )

Line 457: IF (cn_api.get_rev_class_id (p_pe_rec.rev_class_name, p_pe_rec.org_id)) IS NULL

453: END IF;
454:
455: -- Rasie error when user pass in revenue class name not exist in
456: -- cn_revenue_classes
457: IF (cn_api.get_rev_class_id (p_pe_rec.rev_class_name, p_pe_rec.org_id)) IS NULL
458: THEN
459: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
460: THEN
461: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');

Line 472: IF (cn_api.get_rev_class_name (p_pe_rec.rev_class_id)) IS NULL

468: ELSIF p_pe_rec.rev_class_name IS NULL
469: THEN
470: -- Rev_class_id not null and rev_class_name null, check if
471: -- Rev_class_id is exist in DB
472: IF (cn_api.get_rev_class_name (p_pe_rec.rev_class_id)) IS NULL
473: THEN
474: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
475: THEN
476: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');

Line 488: IF (p_pe_rec.rev_class_id <> cn_api.get_rev_class_id (p_pe_rec.rev_class_name, p_pe_rec.org_id))

484: -- If rev_class_id and rev_class_name both are not
485: -- missing or null,
486: -- make sure they're compatible, access to same record in
487: -- CN_RATE_SCHEDULES
488: IF (p_pe_rec.rev_class_id <> cn_api.get_rev_class_id (p_pe_rec.rev_class_name, p_pe_rec.org_id))
489: THEN
490: -- Error, check the msg level and add an error message to the
491: -- API message list
492: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

Line 595: IF ( (cn_api.pe_char_field_must_null

591: -- NOT NULL : if it's DRAW type pe
592: -- Rate Table = NULL, Discount Rate Table = NULL, Revenue Class = NULL
593: --+
594: -- Check trx_group_code for DRAW and MANUAUL PE type
595: IF ( (cn_api.pe_char_field_must_null
596: ( p_char_field => p_pe_rec.trx_group_code,
597: p_pe_type => p_pe_rec.quota_type_code,
598: p_obj_name => G_TRX_GROUP,
599: p_token1 => NULL ,

Line 607: IF ( (cn_api.pe_char_field_must_null

603: x_loading_status => x_loading_status)) = FND_API.G_FALSE) THEN
604: RAISE FND_API.G_EXC_ERROR ;
605: END IF;
606: -- Check payment_type_code for DRAW and MANUAUL PE type
607: IF ( (cn_api.pe_char_field_must_null
608: ( p_char_field => p_pe_rec.payment_type_code,
609: p_pe_type => p_pe_rec.quota_type_code,
610: p_obj_name => G_PAYMENT_TYPE,
611: p_token1 => NULL ,

Line 624: cn_api.get_lkup_meaning

620: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
621: THEN
622: FND_MESSAGE.SET_NAME ('CN' , 'CN_DISC_OPTION_MUST_NONE');
623: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
624: cn_api.get_lkup_meaning
625: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
626: FND_MSG_PUB.Add;
627: END IF;
628: x_loading_status := 'CN_DISC_OPTION_MUST_NONE';

Line 638: cn_api.get_lkup_meaning

634: THEN
635: FND_MESSAGE.SET_NAME ('CN' , 'CN_CUM_FLAG_MUST_BE');
636: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
637: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
638: cn_api.get_lkup_meaning
639: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
640: FND_MESSAGE.SET_TOKEN ('TOKEN1',NULL);
641: FND_MSG_PUB.Add;
642: END IF;

Line 653: cn_api.get_lkup_meaning

649: THEN
650: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPLIT_FLAG_MUST_BE');
651: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
652: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
653: cn_api.get_lkup_meaning
654: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
655: FND_MESSAGE.SET_TOKEN ('TOKEN1',NULL);
656: FND_MESSAGE.SET_TOKEN ('TOKEN2',NULL);
657: FND_MESSAGE.SET_TOKEN ('TOKEN3',NULL);

Line 670: cn_api.get_lkup_meaning

666: THEN
667: FND_MESSAGE.SET_NAME ('CN' , 'CN_ITD_FLAG_MUST_BE');
668: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
669: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
670: cn_api.get_lkup_meaning
671: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
672: FND_MESSAGE.SET_TOKEN ('TOKEN1',NULL);
673: FND_MSG_PUB.Add;
674: END IF;

Line 682: IF (cn_api.pe_num_field_cannot_null

678: -- Payment Amount =
679: -- NULL : if it's MANUAL type pe
680: -- NOT NULL : if it's DRAW type pe
681: IF (p_pe_rec.quota_type_code = 'DRAW') THEN
682: IF (cn_api.pe_num_field_cannot_null
683: ( p_num_field => p_pe_rec.payment_amount,
684: p_pe_type => p_pe_rec.quota_type_code,
685: p_obj_name => G_DRAW_AMOUNT,
686: p_token1 => NULL ,

Line 694: IF (cn_api.pe_num_field_must_null

690: x_loading_status => x_loading_status) = FND_API.G_FALSE) THEN
691: RAISE FND_API.G_EXC_ERROR ;
692: END IF;
693: ELSIF (p_pe_rec.quota_type_code = 'MANUAL') THEN
694: IF (cn_api.pe_num_field_must_null
695: ( p_num_field => p_pe_rec.payment_amount,
696: p_pe_type => p_pe_rec.quota_type_code,
697: p_obj_name => G_PAYMENT_AMOUT,
698: p_token1 => NULL ,

Line 707: IF (cn_api.pe_num_field_must_null

703: RAISE FND_API.G_EXC_ERROR ;
704: END IF;
705: END IF;
706: -- Check for Rate Table = NULL in DRAW and MANUAUL PE type
707: IF (cn_api.pe_num_field_must_null
708: ( p_num_field => p_pe_rec.rate_table_id,
709: p_pe_type => p_pe_rec.quota_type_code,
710: p_obj_name => G_RATE_TB,
711: p_token1 => NULL ,

Line 719: IF (cn_api.pe_num_field_must_null

715: x_loading_status => x_loading_status) = FND_API.G_FALSE) THEN
716: RAISE FND_API.G_EXC_ERROR ;
717: END IF;
718: -- Check for Discount Rate Table = NULL in DRAW and MANUAUL PE type
719: IF (cn_api.pe_num_field_must_null
720: ( p_num_field => p_pe_rec.disc_rate_table_id,
721: p_pe_type => p_pe_rec.quota_type_code,
722: p_obj_name => G_DISC_RATE_TB,
723: p_token1 => NULL ,

Line 731: IF (cn_api.pe_num_field_must_null

727: x_loading_status => x_loading_status) = FND_API.G_FALSE) THEN
728: RAISE FND_API.G_EXC_ERROR ;
729: END IF;
730: -- Check for Revenue Class = NULL in DRAW and MANUAUL PE type
731: IF (cn_api.pe_num_field_must_null
732: ( p_num_field => p_pe_rec.rev_class_id,
733: p_pe_type => p_pe_rec.quota_type_code,
734: p_obj_name => G_REV_CLS_NAME,
735: p_token1 => NULL ,

Line 749: cn_api.get_lkup_meaning

745: THEN
746: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_TARGET_MUST_BE');
747: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE','= 0');
748: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
749: cn_api.get_lkup_meaning
750: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
751: FND_MESSAGE.SET_TOKEN ('TOKEN1',NULL);
752: FND_MSG_PUB.Add;
753: END IF;

Line 813: cn_api.get_lkup_meaning

809: THEN
810: FND_MESSAGE.SET_NAME ('CN' , 'CN_CUM_FLAG_MUST_BE');
811: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_yes);
812: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
813: cn_api.get_lkup_meaning
814: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
815: FND_MESSAGE.SET_TOKEN ('TOKEN1',NULL);
816: FND_MSG_PUB.Add;
817: END IF;

Line 839: cn_api.get_lkup_meaning

835: THEN
836: FND_MESSAGE.SET_NAME ('CN' , 'CN_ITD_FLAG_MUST_BE');
837: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
838: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
839: cn_api.get_lkup_meaning
840: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
841: FND_MESSAGE.SET_TOKEN ('TOKEN1',G_TRX_GROUP||' = '||
842: cn_api.get_lkup_meaning
843: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'))

Line 842: cn_api.get_lkup_meaning

838: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
839: cn_api.get_lkup_meaning
840: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
841: FND_MESSAGE.SET_TOKEN ('TOKEN1',G_TRX_GROUP||' = '||
842: cn_api.get_lkup_meaning
843: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'))
844: ;
845: FND_MSG_PUB.Add;
846: END IF;

Line 857: cn_api.get_lkup_meaning

853: THEN
854: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPLIT_FLAG_MUST_BE');
855: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
856: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
857: cn_api.get_lkup_meaning
858: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
859: FND_MESSAGE.SET_TOKEN ('TOKEN1',G_TRX_GROUP ||' = '||
860: cn_api.get_lkup_meaning
861: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'))

Line 860: cn_api.get_lkup_meaning

856: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
857: cn_api.get_lkup_meaning
858: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
859: FND_MESSAGE.SET_TOKEN ('TOKEN1',G_TRX_GROUP ||' = '||
860: cn_api.get_lkup_meaning
861: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'))
862: ;
863: FND_MESSAGE.SET_TOKEN ('TOKEN2',NULL);
864: FND_MESSAGE.SET_TOKEN ('TOKEN3',NULL);

Line 884: IF (cn_api.pe_num_field_cannot_null

880: -- Check Payment Amount
881: -- NOT NULL : if payment type code = Payment amount %
882: -- NULL : if payment type code = Fixed amount or applied Trx %
883: IF p_pe_rec.payment_type_code = 'PAYMENT' THEN
884: IF (cn_api.pe_num_field_cannot_null
885: ( p_num_field => p_pe_rec.payment_amount,
886: p_pe_type => p_pe_rec.quota_type_code,
887: p_obj_name => G_PAYMENT_AMOUT,
888: p_token1 => G_TRX_GROUP||' = '||

Line 889: cn_api.get_lkup_meaning

885: ( p_num_field => p_pe_rec.payment_amount,
886: p_pe_type => p_pe_rec.quota_type_code,
887: p_obj_name => G_PAYMENT_AMOUT,
888: p_token1 => G_TRX_GROUP||' = '||
889: cn_api.get_lkup_meaning
890: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
891: p_token2 => G_PAYMENT_TYPE ||' = '||
892: cn_api.get_lkup_meaning
893: (p_pe_rec.payment_type_code,'QUOTA_PAYMENT_TYPE'),

Line 892: cn_api.get_lkup_meaning

888: p_token1 => G_TRX_GROUP||' = '||
889: cn_api.get_lkup_meaning
890: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
891: p_token2 => G_PAYMENT_TYPE ||' = '||
892: cn_api.get_lkup_meaning
893: (p_pe_rec.payment_type_code,'QUOTA_PAYMENT_TYPE'),
894: p_token3 => NULL ,
895: p_loading_status => x_loading_status,
896: x_loading_status => x_loading_status) = FND_API.g_false)

Line 901: (cn_api.pe_num_field_must_null

897: THEN
898: RAISE FND_API.G_EXC_ERROR ;
899: END IF;
900: ELSIF p_pe_rec.payment_type_code IN ('TRANSACTION','FIXED') AND
901: (cn_api.pe_num_field_must_null
902: ( p_num_field => p_pe_rec.payment_amount,
903: p_pe_type => p_pe_rec.quota_type_code,
904: p_obj_name => G_PAYMENT_AMOUT,
905: p_token1 => G_TRX_GROUP||' = '||

Line 906: cn_api.get_lkup_meaning

902: ( p_num_field => p_pe_rec.payment_amount,
903: p_pe_type => p_pe_rec.quota_type_code,
904: p_obj_name => G_PAYMENT_AMOUT,
905: p_token1 => G_TRX_GROUP||' = '||
906: cn_api.get_lkup_meaning
907: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
908: p_token2 => G_PAYMENT_TYPE||' = '||
909: cn_api.get_lkup_meaning
910: (p_pe_rec.payment_type_code,'QUOTA_PAYMENT_TYPE'),

Line 909: cn_api.get_lkup_meaning

905: p_token1 => G_TRX_GROUP||' = '||
906: cn_api.get_lkup_meaning
907: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
908: p_token2 => G_PAYMENT_TYPE||' = '||
909: cn_api.get_lkup_meaning
910: (p_pe_rec.payment_type_code,'QUOTA_PAYMENT_TYPE'),
911: p_token3 => NULL ,
912: p_loading_status => x_loading_status,
913: x_loading_status => x_loading_status) = FND_API.g_false)

Line 951: cn_api.get_lkup_meaning

947: THEN
948: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPLIT_FLAG_MUST_BE');
949: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
950: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
951: cn_api.get_lkup_meaning
952: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
953: FND_MESSAGE.SET_TOKEN ('TOKEN1',G_TRX_GROUP||' = '||
954: cn_api.get_lkup_meaning
955: (p_pe_rec.trx_group_code,

Line 954: cn_api.get_lkup_meaning

950: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
951: cn_api.get_lkup_meaning
952: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
953: FND_MESSAGE.SET_TOKEN ('TOKEN1',G_TRX_GROUP||' = '||
954: cn_api.get_lkup_meaning
955: (p_pe_rec.trx_group_code,
956: 'QUOTA_TRX_GROUP'));
957: FND_MESSAGE.SET_TOKEN ('TOKEN2',G_PAYMENT_TYPE||' = '||
958: cn_api.get_lkup_meaning

Line 958: cn_api.get_lkup_meaning

954: cn_api.get_lkup_meaning
955: (p_pe_rec.trx_group_code,
956: 'QUOTA_TRX_GROUP'));
957: FND_MESSAGE.SET_TOKEN ('TOKEN2',G_PAYMENT_TYPE||' = '||
958: cn_api.get_lkup_meaning
959: (p_pe_rec.payment_type_code,
960: 'QUOTA_PAYMENT_TYPE'));
961: FND_MESSAGE.SET_TOKEN ('TOKEN3',G_ITD||' = '||
962: p_pe_rec.itd_flag);

Line 972: IF (cn_api.pe_num_field_cannot_null

968: -- Check Payment Amount
969: -- NOT NULL : if payment type code = Payment amount %
970: -- NULL : if payment type code = Fixed amount or applied Trx %
971: IF p_pe_rec.payment_type_code = 'PAYMENT' THEN
972: IF (cn_api.pe_num_field_cannot_null
973: ( p_num_field => p_pe_rec.payment_amount,
974: p_pe_type => p_pe_rec.quota_type_code,
975: p_obj_name => G_PAYMENT_AMOUT,
976: p_token1 => G_TRX_GROUP||' = '||

Line 977: cn_api.get_lkup_meaning

973: ( p_num_field => p_pe_rec.payment_amount,
974: p_pe_type => p_pe_rec.quota_type_code,
975: p_obj_name => G_PAYMENT_AMOUT,
976: p_token1 => G_TRX_GROUP||' = '||
977: cn_api.get_lkup_meaning
978: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
979: p_token2 => G_PAYMENT_TYPE||' = '||
980: cn_api.get_lkup_meaning
981: (p_pe_rec.payment_type_code,'QUOTA_PAYMENT_TYPE'),

Line 980: cn_api.get_lkup_meaning

976: p_token1 => G_TRX_GROUP||' = '||
977: cn_api.get_lkup_meaning
978: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
979: p_token2 => G_PAYMENT_TYPE||' = '||
980: cn_api.get_lkup_meaning
981: (p_pe_rec.payment_type_code,'QUOTA_PAYMENT_TYPE'),
982: p_token3 => G_ITD||' = '||p_pe_rec.itd_flag,
983: p_loading_status => x_loading_status,
984: x_loading_status => x_loading_status) = FND_API.g_false)

Line 989: (cn_api.pe_num_field_must_null

985: THEN
986: RAISE FND_API.G_EXC_ERROR ;
987: END IF;
988: ELSIF p_pe_rec.payment_type_code IN ('TRANSACTION','FIXED') AND
989: (cn_api.pe_num_field_must_null
990: ( p_num_field => p_pe_rec.payment_amount,
991: p_pe_type => p_pe_rec.quota_type_code,
992: p_obj_name => G_PAYMENT_AMOUT,
993: p_token1 => G_TRX_GROUP||' = '||

Line 994: cn_api.get_lkup_meaning

990: ( p_num_field => p_pe_rec.payment_amount,
991: p_pe_type => p_pe_rec.quota_type_code,
992: p_obj_name => G_PAYMENT_AMOUT,
993: p_token1 => G_TRX_GROUP||' = '||
994: cn_api.get_lkup_meaning
995: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
996: p_token2 => G_PAYMENT_TYPE||' = '||
997: cn_api.get_lkup_meaning
998: (p_pe_rec.payment_type_code,'QUOTA_PAYMENT_TYPE'),

Line 997: cn_api.get_lkup_meaning

993: p_token1 => G_TRX_GROUP||' = '||
994: cn_api.get_lkup_meaning
995: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
996: p_token2 => G_PAYMENT_TYPE||' = '||
997: cn_api.get_lkup_meaning
998: (p_pe_rec.payment_type_code,'QUOTA_PAYMENT_TYPE'),
999: p_token3 => G_ITD||' = '||p_pe_rec.itd_flag,
1000: p_loading_status => x_loading_status,
1001: x_loading_status => x_loading_status) = FND_API.G_FALSE)

Line 1021: cn_api.get_lkup_meaning

1017: THEN
1018: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_TARGET_MUST_BE');
1019: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE','= 0');
1020: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1021: cn_api.get_lkup_meaning
1022: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1023: FND_MESSAGE.SET_TOKEN ('TOKEN1',
1024: G_ITD||' = '||p_pe_rec.itd_flag);
1025: FND_MSG_PUB.Add;

Line 1049: cn_api.get_lkup_meaning

1045: THEN
1046: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPLIT_FLAG_MUST_BE');
1047: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
1048: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1049: cn_api.get_lkup_meaning
1050: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1051: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1052: cn_api.get_lkup_meaning
1053: (p_pe_rec.trx_group_code,

Line 1052: cn_api.get_lkup_meaning

1048: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1049: cn_api.get_lkup_meaning
1050: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1051: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1052: cn_api.get_lkup_meaning
1053: (p_pe_rec.trx_group_code,
1054: 'QUOTA_TRX_GROUP'));
1055: FND_MESSAGE.SET_TOKEN ('TOKEN2', G_PAYMENT_TYPE||' = '||
1056: cn_api.get_lkup_meaning

Line 1056: cn_api.get_lkup_meaning

1052: cn_api.get_lkup_meaning
1053: (p_pe_rec.trx_group_code,
1054: 'QUOTA_TRX_GROUP'));
1055: FND_MESSAGE.SET_TOKEN ('TOKEN2', G_PAYMENT_TYPE||' = '||
1056: cn_api.get_lkup_meaning
1057: (p_pe_rec.payment_type_code,
1058: 'QUOTA_PAYMENT_TYPE'));
1059: FND_MESSAGE.SET_TOKEN ('TOKEN3',
1060: G_ITD||' = '||p_pe_rec.itd_flag);

Line 1073: cn_api.get_lkup_meaning

1069: THEN
1070: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_PAYMENT_AMT_MUST_BE');
1071: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE','= 0');
1072: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1073: cn_api.get_lkup_meaning
1074: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1075: FND_MESSAGE.SET_TOKEN ('TOKEN1',G_TRX_GROUP||' = '||
1076: cn_api.get_lkup_meaning
1077: (p_pe_rec.trx_group_code,

Line 1076: cn_api.get_lkup_meaning

1072: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1073: cn_api.get_lkup_meaning
1074: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1075: FND_MESSAGE.SET_TOKEN ('TOKEN1',G_TRX_GROUP||' = '||
1076: cn_api.get_lkup_meaning
1077: (p_pe_rec.trx_group_code,
1078: 'QUOTA_TRX_GROUP'));
1079: FND_MESSAGE.SET_TOKEN ('TOKEN2',G_PAYMENT_TYPE||' = '||
1080: cn_api.get_lkup_meaning

Line 1080: cn_api.get_lkup_meaning

1076: cn_api.get_lkup_meaning
1077: (p_pe_rec.trx_group_code,
1078: 'QUOTA_TRX_GROUP'));
1079: FND_MESSAGE.SET_TOKEN ('TOKEN2',G_PAYMENT_TYPE||' = '||
1080: cn_api.get_lkup_meaning
1081: (p_pe_rec.payment_type_code,
1082: 'QUOTA_PAYMENT_TYPE'));
1083: FND_MESSAGE.SET_TOKEN ('TOKEN3',
1084: G_ITD||' = '||p_pe_rec.itd_flag);

Line 1113: IF (cn_api.pe_num_field_must_null

1109: RAISE FND_API.G_EXC_ERROR ;
1110: END IF;
1111: ELSE
1112: -- Check for Discount Rate Table must be NULL
1113: IF (cn_api.pe_num_field_must_null
1114: ( p_num_field => p_pe_rec.disc_rate_table_id,
1115: p_pe_type => p_pe_rec.quota_type_code,
1116: p_obj_name => G_DISC_RATE_TB,
1117: p_token1 =>

Line 1119: cn_api.get_lkup_meaning

1115: p_pe_type => p_pe_rec.quota_type_code,
1116: p_obj_name => G_DISC_RATE_TB,
1117: p_token1 =>
1118: G_DISC_OPTION||' = '||
1119: cn_api.get_lkup_meaning
1120: (p_pe_rec.disc_option_code,'DISCOUNT_OPTION'),
1121: p_token2 => NULL ,
1122: p_token3 => NULL ,
1123: p_loading_status => x_loading_status,

Line 1194: cn_api.get_lkup_meaning

1190: THEN
1191: FND_MESSAGE.SET_NAME ('CN' , 'CN_CUM_FLAG_MUST_BE');
1192: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_yes);
1193: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1194: cn_api.get_lkup_meaning
1195: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1196: FND_MESSAGE.SET_TOKEN ('TOKEN1',NULL);
1197: FND_MSG_PUB.Add;
1198: END IF;

Line 1220: cn_api.get_lkup_meaning

1216: THEN
1217: FND_MESSAGE.SET_NAME ('CN' , 'CN_ITD_FLAG_MUST_BE');
1218: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
1219: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1220: cn_api.get_lkup_meaning
1221: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1222: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1223: cn_api.get_lkup_meaning
1224: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'));

Line 1223: cn_api.get_lkup_meaning

1219: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1220: cn_api.get_lkup_meaning
1221: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1222: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1223: cn_api.get_lkup_meaning
1224: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'));
1225: FND_MSG_PUB.Add;
1226: END IF;
1227: x_loading_status := 'CN_ITD_FLAG_MUST_BE';

Line 1237: cn_api.get_lkup_meaning

1233: THEN
1234: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPLIT_FLAG_MUST_BE');
1235: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
1236: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1237: cn_api.get_lkup_meaning
1238: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1239: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1240: cn_api.get_lkup_meaning
1241: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'))

Line 1240: cn_api.get_lkup_meaning

1236: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1237: cn_api.get_lkup_meaning
1238: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1239: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1240: cn_api.get_lkup_meaning
1241: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'))
1242: ;
1243: FND_MESSAGE.SET_TOKEN ('TOKEN2',NULL);
1244: FND_MESSAGE.SET_TOKEN ('TOKEN3',NULL);

Line 1264: IF (cn_api.pe_num_field_cannot_null

1260: -- Check Payment Amount
1261: -- NOT NULL : if payment type code = Payment amount %
1262: -- NULL : if payment type code = Fixed amount or applied Trx %
1263: IF p_pe_rec.payment_type_code = 'PAYMENT' THEN
1264: IF (cn_api.pe_num_field_cannot_null
1265: ( p_num_field => p_pe_rec.payment_amount,
1266: p_pe_type => p_pe_rec.quota_type_code,
1267: p_obj_name => G_PAYMENT_AMOUT,
1268: p_token1 => G_TRX_GROUP||' = '||

Line 1269: cn_api.get_lkup_meaning

1265: ( p_num_field => p_pe_rec.payment_amount,
1266: p_pe_type => p_pe_rec.quota_type_code,
1267: p_obj_name => G_PAYMENT_AMOUT,
1268: p_token1 => G_TRX_GROUP||' = '||
1269: cn_api.get_lkup_meaning
1270: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1271: p_token2 => G_PAYMENT_TYPE||' = '||
1272: cn_api.get_lkup_meaning
1273: (p_pe_rec.payment_type_code,

Line 1272: cn_api.get_lkup_meaning

1268: p_token1 => G_TRX_GROUP||' = '||
1269: cn_api.get_lkup_meaning
1270: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1271: p_token2 => G_PAYMENT_TYPE||' = '||
1272: cn_api.get_lkup_meaning
1273: (p_pe_rec.payment_type_code,
1274: 'QUOTA_PAYMENT_TYPE'),
1275: p_token3 => NULL ,
1276: p_loading_status => x_loading_status,

Line 1282: (cn_api.pe_num_field_must_null

1278: THEN
1279: RAISE FND_API.G_EXC_ERROR ;
1280: END IF;
1281: ELSIF p_pe_rec.payment_type_code IN ('TRANSACTION','FIXED') AND
1282: (cn_api.pe_num_field_must_null
1283: ( p_num_field => p_pe_rec.payment_amount,
1284: p_pe_type => p_pe_rec.quota_type_code,
1285: p_obj_name => G_PAYMENT_AMOUT,
1286: p_token1 => G_TRX_GROUP||' = '||

Line 1287: cn_api.get_lkup_meaning

1283: ( p_num_field => p_pe_rec.payment_amount,
1284: p_pe_type => p_pe_rec.quota_type_code,
1285: p_obj_name => G_PAYMENT_AMOUT,
1286: p_token1 => G_TRX_GROUP||' = '||
1287: cn_api.get_lkup_meaning
1288: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1289: p_token2 => G_PAYMENT_TYPE||' = '||
1290: cn_api.get_lkup_meaning
1291: (p_pe_rec.payment_type_code,'QUOTA_PAYMENT_TYPE'),

Line 1290: cn_api.get_lkup_meaning

1286: p_token1 => G_TRX_GROUP||' = '||
1287: cn_api.get_lkup_meaning
1288: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1289: p_token2 => G_PAYMENT_TYPE||' = '||
1290: cn_api.get_lkup_meaning
1291: (p_pe_rec.payment_type_code,'QUOTA_PAYMENT_TYPE'),
1292: p_token3 => NULL ,
1293: p_loading_status => x_loading_status,
1294: x_loading_status => x_loading_status) = FND_API.g_false)

Line 1332: cn_api.get_lkup_meaning

1328: THEN
1329: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPLIT_FLAG_MUST_BE');
1330: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
1331: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1332: cn_api.get_lkup_meaning
1333: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1334: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1335: cn_api.get_lkup_meaning
1336: (p_pe_rec.trx_group_code,

Line 1335: cn_api.get_lkup_meaning

1331: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1332: cn_api.get_lkup_meaning
1333: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1334: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1335: cn_api.get_lkup_meaning
1336: (p_pe_rec.trx_group_code,
1337: 'QUOTA_TRX_GROUP'));
1338: FND_MESSAGE.SET_TOKEN ('TOKEN2',G_PAYMENT_TYPE||' = '||
1339: cn_api.get_lkup_meaning

Line 1339: cn_api.get_lkup_meaning

1335: cn_api.get_lkup_meaning
1336: (p_pe_rec.trx_group_code,
1337: 'QUOTA_TRX_GROUP'));
1338: FND_MESSAGE.SET_TOKEN ('TOKEN2',G_PAYMENT_TYPE||' = '||
1339: cn_api.get_lkup_meaning
1340: (p_pe_rec.payment_type_code,
1341: 'QUOTA_PAYMENT_TYPE'));
1342: FND_MESSAGE.SET_TOKEN ('TOKEN3',
1343: G_ITD||' = '||p_pe_rec.itd_flag);

Line 1353: IF (cn_api.pe_num_field_cannot_null

1349: -- Check Payment Amount
1350: -- NOT NULL : if payment type code = Payment amount %
1351: -- NULL : if payment type code = Fixed amount or applied Trx %
1352: IF p_pe_rec.payment_type_code = 'PAYMENT' THEN
1353: IF (cn_api.pe_num_field_cannot_null
1354: ( p_num_field => p_pe_rec.payment_amount,
1355: p_pe_type => p_pe_rec.quota_type_code,
1356: p_obj_name => G_PAYMENT_AMOUT,
1357: p_token1 => G_TRX_GROUP||' = '||

Line 1358: cn_api.get_lkup_meaning

1354: ( p_num_field => p_pe_rec.payment_amount,
1355: p_pe_type => p_pe_rec.quota_type_code,
1356: p_obj_name => G_PAYMENT_AMOUT,
1357: p_token1 => G_TRX_GROUP||' = '||
1358: cn_api.get_lkup_meaning
1359: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1360: p_token2 => G_PAYMENT_TYPE||' = '||
1361: cn_api.get_lkup_meaning
1362: (p_pe_rec.payment_type_code,

Line 1361: cn_api.get_lkup_meaning

1357: p_token1 => G_TRX_GROUP||' = '||
1358: cn_api.get_lkup_meaning
1359: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1360: p_token2 => G_PAYMENT_TYPE||' = '||
1361: cn_api.get_lkup_meaning
1362: (p_pe_rec.payment_type_code,
1363: 'QUOTA_PAYMENT_TYPE'),
1364: p_token3 => G_ITD||' = '||p_pe_rec.itd_flag,
1365: p_loading_status => x_loading_status,

Line 1371: (cn_api.pe_num_field_must_null

1367: THEN
1368: RAISE FND_API.G_EXC_ERROR ;
1369: END IF;
1370: ELSIF p_pe_rec.payment_type_code IN ('TRANSACTION','FIXED') AND
1371: (cn_api.pe_num_field_must_null
1372: ( p_num_field => p_pe_rec.payment_amount,
1373: p_pe_type => p_pe_rec.quota_type_code,
1374: p_obj_name => G_PAYMENT_AMOUT,
1375: p_token1 => G_TRX_GROUP||' = '||

Line 1376: cn_api.get_lkup_meaning

1372: ( p_num_field => p_pe_rec.payment_amount,
1373: p_pe_type => p_pe_rec.quota_type_code,
1374: p_obj_name => G_PAYMENT_AMOUT,
1375: p_token1 => G_TRX_GROUP||' = '||
1376: cn_api.get_lkup_meaning
1377: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1378: p_token2 => G_PAYMENT_TYPE||' = '||
1379: cn_api.get_lkup_meaning
1380: (p_pe_rec.payment_type_code,

Line 1379: cn_api.get_lkup_meaning

1375: p_token1 => G_TRX_GROUP||' = '||
1376: cn_api.get_lkup_meaning
1377: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1378: p_token2 => G_PAYMENT_TYPE||' = '||
1379: cn_api.get_lkup_meaning
1380: (p_pe_rec.payment_type_code,
1381: 'QUOTA_PAYMENT_TYPE'),
1382: p_token3 => G_ITD||' = '||p_pe_rec.itd_flag,
1383: p_loading_status => x_loading_status,

Line 1404: cn_api.get_lkup_meaning

1400: THEN
1401: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_TARGET_MUST_BE');
1402: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE','= 0');
1403: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1404: cn_api.get_lkup_meaning
1405: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1406: FND_MESSAGE.SET_TOKEN ('TOKEN1',
1407: G_ITD||' = '||p_pe_rec.itd_flag);
1408: FND_MSG_PUB.Add;

Line 1432: cn_api.get_lkup_meaning

1428: THEN
1429: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPLIT_FLAG_MUST_BE');
1430: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
1431: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1432: cn_api.get_lkup_meaning
1433: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1434: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1435: cn_api.get_lkup_meaning
1436: (p_pe_rec.trx_group_code,

Line 1435: cn_api.get_lkup_meaning

1431: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1432: cn_api.get_lkup_meaning
1433: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1434: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1435: cn_api.get_lkup_meaning
1436: (p_pe_rec.trx_group_code,
1437: 'QUOTA_TRX_GROUP'));
1438: FND_MESSAGE.SET_TOKEN ('TOKEN2', G_PAYMENT_TYPE||' = '||
1439: cn_api.get_lkup_meaning

Line 1439: cn_api.get_lkup_meaning

1435: cn_api.get_lkup_meaning
1436: (p_pe_rec.trx_group_code,
1437: 'QUOTA_TRX_GROUP'));
1438: FND_MESSAGE.SET_TOKEN ('TOKEN2', G_PAYMENT_TYPE||' = '||
1439: cn_api.get_lkup_meaning
1440: (p_pe_rec.payment_type_code,
1441: 'QUOTA_PAYMENT_TYPE'));
1442: FND_MESSAGE.SET_TOKEN ('TOKEN3',
1443: G_ITD||' = '||p_pe_rec.itd_flag);

Line 1456: cn_api.get_lkup_meaning

1452: THEN
1453: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_PAYMENT_AMT_MUST_BE');
1454: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE','= 0');
1455: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1456: cn_api.get_lkup_meaning
1457: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1458: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1459: cn_api.get_lkup_meaning
1460: (p_pe_rec.trx_group_code,

Line 1459: cn_api.get_lkup_meaning

1455: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1456: cn_api.get_lkup_meaning
1457: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1458: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1459: cn_api.get_lkup_meaning
1460: (p_pe_rec.trx_group_code,
1461: 'QUOTA_TRX_GROUP'));
1462: FND_MESSAGE.SET_TOKEN ('TOKEN2', G_PAYMENT_TYPE||' = '||
1463: cn_api.get_lkup_meaning

Line 1463: cn_api.get_lkup_meaning

1459: cn_api.get_lkup_meaning
1460: (p_pe_rec.trx_group_code,
1461: 'QUOTA_TRX_GROUP'));
1462: FND_MESSAGE.SET_TOKEN ('TOKEN2', G_PAYMENT_TYPE||' = '||
1463: cn_api.get_lkup_meaning
1464: (p_pe_rec.payment_type_code,
1465: 'QUOTA_PAYMENT_TYPE'));
1466: FND_MESSAGE.SET_TOKEN ('TOKEN3',
1467: G_ITD||' = '||p_pe_rec.itd_flag);

Line 1487: IF (cn_api.pe_num_field_must_null

1483: END IF;
1484: -- Check discount rate table = Not Allowed
1485: -- Discount Option Code must = NONE is validate when calling
1486: -- valid_lookup_code() from valid_plan_element
1487: IF (cn_api.pe_num_field_must_null
1488: ( p_num_field => p_pe_rec.disc_rate_table_id,
1489: p_pe_type => p_pe_rec.quota_type_code,
1490: p_obj_name => G_DISC_RATE_TB,
1491: p_token1 => NULL ,

Line 1565: cn_api.get_lkup_meaning

1561: THEN
1562: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_TARGET_MUST_BE');
1563: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE','= 0');
1564: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1565: cn_api.get_lkup_meaning
1566: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1567: FND_MESSAGE.SET_TOKEN ('TOKEN1',NULL);
1568: FND_MSG_PUB.Add;
1569: END IF;

Line 1580: cn_api.get_lkup_meaning

1576: THEN
1577: FND_MESSAGE.SET_NAME ('CN' , 'CN_ITD_FLAG_MUST_BE');
1578: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
1579: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1580: cn_api.get_lkup_meaning
1581: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1582: FND_MESSAGE.SET_TOKEN ('TOKEN1',NULL);
1583: FND_MSG_PUB.Add;
1584: END IF;

Line 1605: cn_api.get_lkup_meaning

1601: THEN
1602: FND_MESSAGE.SET_NAME ('CN' , 'CN_CUM_FLAG_MUST_BE');
1603: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
1604: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1605: cn_api.get_lkup_meaning
1606: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1607: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1608: cn_api.get_lkup_meaning
1609: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'));

Line 1608: cn_api.get_lkup_meaning

1604: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1605: cn_api.get_lkup_meaning
1606: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1607: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1608: cn_api.get_lkup_meaning
1609: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'));
1610: FND_MSG_PUB.Add;
1611: END IF;
1612: x_loading_status := 'CN_CUM_FLAG_MUST_BE';

Line 1622: cn_api.get_lkup_meaning

1618: THEN
1619: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPLIT_FLAG_MUST_BE');
1620: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
1621: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1622: cn_api.get_lkup_meaning
1623: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1624: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1625: cn_api.get_lkup_meaning
1626: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'));

Line 1625: cn_api.get_lkup_meaning

1621: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1622: cn_api.get_lkup_meaning
1623: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1624: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1625: cn_api.get_lkup_meaning
1626: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'));
1627: FND_MESSAGE.SET_TOKEN ('TOKEN2',NULL);
1628: FND_MESSAGE.SET_TOKEN ('TOKEN3',NULL);
1629: FND_MSG_PUB.Add;

Line 1638: IF (cn_api.pe_num_field_cannot_null

1634: -- Check Payment Amount
1635: -- NOT NULL : if payment type code = Payment amount %
1636: -- NULL : if payment type code = Fixed amount or applied Trx %
1637: IF p_pe_rec.payment_type_code = 'PAYMENT' THEN
1638: IF (cn_api.pe_num_field_cannot_null
1639: ( p_num_field => p_pe_rec.payment_amount,
1640: p_pe_type => p_pe_rec.quota_type_code,
1641: p_obj_name => G_PAYMENT_AMOUT,
1642: p_token1 => G_TRX_GROUP||' = '||

Line 1643: cn_api.get_lkup_meaning

1639: ( p_num_field => p_pe_rec.payment_amount,
1640: p_pe_type => p_pe_rec.quota_type_code,
1641: p_obj_name => G_PAYMENT_AMOUT,
1642: p_token1 => G_TRX_GROUP||' = '||
1643: cn_api.get_lkup_meaning
1644: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1645: p_token2 => G_PAYMENT_TYPE||' = '||
1646: cn_api.get_lkup_meaning
1647: (p_pe_rec.payment_type_code,

Line 1646: cn_api.get_lkup_meaning

1642: p_token1 => G_TRX_GROUP||' = '||
1643: cn_api.get_lkup_meaning
1644: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1645: p_token2 => G_PAYMENT_TYPE||' = '||
1646: cn_api.get_lkup_meaning
1647: (p_pe_rec.payment_type_code,
1648: 'QUOTA_PAYMENT_TYPE'),
1649: p_token3 => NULL ,
1650: p_loading_status => x_loading_status,

Line 1656: (cn_api.pe_num_field_must_null

1652: THEN
1653: RAISE FND_API.G_EXC_ERROR ;
1654: END IF;
1655: ELSIF p_pe_rec.payment_type_code IN ('TRANSACTION','FIXED') AND
1656: (cn_api.pe_num_field_must_null
1657: ( p_num_field => p_pe_rec.payment_amount,
1658: p_pe_type => p_pe_rec.quota_type_code,
1659: p_obj_name => G_PAYMENT_AMOUT,
1660: p_token1 => G_TRX_GROUP||' = '||

Line 1661: cn_api.get_lkup_meaning

1657: ( p_num_field => p_pe_rec.payment_amount,
1658: p_pe_type => p_pe_rec.quota_type_code,
1659: p_obj_name => G_PAYMENT_AMOUT,
1660: p_token1 => G_TRX_GROUP||' = '||
1661: cn_api.get_lkup_meaning
1662: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1663: p_token2 => G_PAYMENT_TYPE||' = '||
1664: cn_api.get_lkup_meaning
1665: (p_pe_rec.payment_type_code,

Line 1664: cn_api.get_lkup_meaning

1660: p_token1 => G_TRX_GROUP||' = '||
1661: cn_api.get_lkup_meaning
1662: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1663: p_token2 => G_PAYMENT_TYPE||' = '||
1664: cn_api.get_lkup_meaning
1665: (p_pe_rec.payment_type_code,
1666: 'QUOTA_PAYMENT_TYPE'),
1667: p_token3 => NULL ,
1668: p_loading_status => x_loading_status,

Line 1687: IF (cn_api.pe_num_field_must_null

1683: -- payment amount = NULL
1684: -- split flag = N if cumulative flag = N
1685: --+
1686: -- Check payment amount = NULL
1687: IF (cn_api.pe_num_field_must_null
1688: ( p_num_field => p_pe_rec.payment_amount,
1689: p_pe_type => p_pe_rec.quota_type_code,
1690: p_obj_name => G_PAYMENT_AMOUT,
1691: p_token1 => G_TRX_GROUP||' = '||

Line 1692: cn_api.get_lkup_meaning

1688: ( p_num_field => p_pe_rec.payment_amount,
1689: p_pe_type => p_pe_rec.quota_type_code,
1690: p_obj_name => G_PAYMENT_AMOUT,
1691: p_token1 => G_TRX_GROUP||' = '||
1692: cn_api.get_lkup_meaning
1693: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1694: p_token2 => G_PAYMENT_TYPE||' = '||
1695: cn_api.get_lkup_meaning
1696: (p_pe_rec.payment_type_code,

Line 1695: cn_api.get_lkup_meaning

1691: p_token1 => G_TRX_GROUP||' = '||
1692: cn_api.get_lkup_meaning
1693: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1694: p_token2 => G_PAYMENT_TYPE||' = '||
1695: cn_api.get_lkup_meaning
1696: (p_pe_rec.payment_type_code,
1697: 'QUOTA_PAYMENT_TYPE'),
1698: p_token3 => NULL ,
1699: p_loading_status => x_loading_status,

Line 1712: cn_api.get_lkup_meaning

1708: THEN
1709: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPLIT_FLAG_MUST_BE');
1710: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
1711: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1712: cn_api.get_lkup_meaning
1713: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1714: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1715: cn_api.get_lkup_meaning
1716: (p_pe_rec.trx_group_code,

Line 1715: cn_api.get_lkup_meaning

1711: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1712: cn_api.get_lkup_meaning
1713: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1714: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1715: cn_api.get_lkup_meaning
1716: (p_pe_rec.trx_group_code,
1717: 'QUOTA_TRX_GROUP'));
1718: FND_MESSAGE.SET_TOKEN ('TOKEN2', G_PAYMENT_TYPE||' = '||
1719: cn_api.get_lkup_meaning

Line 1719: cn_api.get_lkup_meaning

1715: cn_api.get_lkup_meaning
1716: (p_pe_rec.trx_group_code,
1717: 'QUOTA_TRX_GROUP'));
1718: FND_MESSAGE.SET_TOKEN ('TOKEN2', G_PAYMENT_TYPE||' = '||
1719: cn_api.get_lkup_meaning
1720: (p_pe_rec.payment_type_code,
1721: 'QUOTA_PAYMENT_TYPE'));
1722: FND_MESSAGE.SET_TOKEN ('TOKEN3',G_ACCMULATE||' = '||
1723: p_pe_rec.cumulative_flag);

Line 1745: cn_api.get_lkup_meaning

1741: THEN
1742: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPLIT_FLAG_MUST_BE');
1743: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
1744: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1745: cn_api.get_lkup_meaning
1746: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1747: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1748: cn_api.get_lkup_meaning
1749: (p_pe_rec.trx_group_code,

Line 1748: cn_api.get_lkup_meaning

1744: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1745: cn_api.get_lkup_meaning
1746: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1747: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1748: cn_api.get_lkup_meaning
1749: (p_pe_rec.trx_group_code,
1750: 'QUOTA_TRX_GROUP'));
1751: FND_MESSAGE.SET_TOKEN ('TOKEN2', G_PAYMENT_TYPE||' = '||
1752: cn_api.get_lkup_meaning

Line 1752: cn_api.get_lkup_meaning

1748: cn_api.get_lkup_meaning
1749: (p_pe_rec.trx_group_code,
1750: 'QUOTA_TRX_GROUP'));
1751: FND_MESSAGE.SET_TOKEN ('TOKEN2', G_PAYMENT_TYPE||' = '||
1752: cn_api.get_lkup_meaning
1753: (p_pe_rec.payment_type_code,
1754: 'QUOTA_PAYMENT_TYPE'));
1755: FND_MESSAGE.SET_TOKEN ('TOKEN3',NULL);
1756: FND_MSG_PUB.Add;

Line 1765: IF (cn_api.pe_num_field_cannot_null

1761: -- Check Payment Amount
1762: -- NOT NULL : if payment type code = Payment amount %
1763: -- NULL : if payment type code = Fixed amount
1764: IF p_pe_rec.payment_type_code = 'PAYMENT' THEN
1765: IF (cn_api.pe_num_field_cannot_null
1766: ( p_num_field => p_pe_rec.payment_amount,
1767: p_pe_type => p_pe_rec.quota_type_code,
1768: p_obj_name => G_PAYMENT_AMOUT,
1769: p_token1 => G_TRX_GROUP||' = '||

Line 1770: cn_api.get_lkup_meaning

1766: ( p_num_field => p_pe_rec.payment_amount,
1767: p_pe_type => p_pe_rec.quota_type_code,
1768: p_obj_name => G_PAYMENT_AMOUT,
1769: p_token1 => G_TRX_GROUP||' = '||
1770: cn_api.get_lkup_meaning
1771: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1772: p_token2 => G_PAYMENT_TYPE||' = '||
1773: cn_api.get_lkup_meaning
1774: (p_pe_rec.payment_type_code,

Line 1773: cn_api.get_lkup_meaning

1769: p_token1 => G_TRX_GROUP||' = '||
1770: cn_api.get_lkup_meaning
1771: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1772: p_token2 => G_PAYMENT_TYPE||' = '||
1773: cn_api.get_lkup_meaning
1774: (p_pe_rec.payment_type_code,
1775: 'QUOTA_PAYMENT_TYPE'),
1776: p_token3 => NULL ,
1777: p_loading_status => x_loading_status,

Line 1783: (cn_api.pe_num_field_must_null

1779: THEN
1780: RAISE FND_API.G_EXC_ERROR ;
1781: END IF;
1782: ELSIF p_pe_rec.payment_type_code = 'FIXED' AND
1783: (cn_api.pe_num_field_must_null
1784: ( p_num_field => p_pe_rec.payment_amount,
1785: p_pe_type => p_pe_rec.quota_type_code,
1786: p_obj_name => G_PAYMENT_AMOUT,
1787: p_token1 => G_TRX_GROUP||' = '||

Line 1788: cn_api.get_lkup_meaning

1784: ( p_num_field => p_pe_rec.payment_amount,
1785: p_pe_type => p_pe_rec.quota_type_code,
1786: p_obj_name => G_PAYMENT_AMOUT,
1787: p_token1 => G_TRX_GROUP||' = '||
1788: cn_api.get_lkup_meaning
1789: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1790: p_token2 => G_PAYMENT_TYPE||' = '||
1791: cn_api.get_lkup_meaning
1792: (p_pe_rec.payment_type_code,

Line 1791: cn_api.get_lkup_meaning

1787: p_token1 => G_TRX_GROUP||' = '||
1788: cn_api.get_lkup_meaning
1789: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1790: p_token2 => G_PAYMENT_TYPE||' = '||
1791: cn_api.get_lkup_meaning
1792: (p_pe_rec.payment_type_code,
1793: 'QUOTA_PAYMENT_TYPE'),
1794: p_token3 => NULL ,
1795: p_loading_status => x_loading_status,

Line 1824: IF (cn_api.pe_num_field_must_null

1820: RAISE FND_API.G_EXC_ERROR ;
1821: END IF;
1822: ELSE
1823: -- Check for Discount Rate Table must be NULL
1824: IF (cn_api.pe_num_field_must_null
1825: ( p_num_field => p_pe_rec.disc_rate_table_id,
1826: p_pe_type => p_pe_rec.quota_type_code,
1827: p_obj_name => G_DISC_RATE_TB,
1828: p_token1 =>

Line 1830: cn_api.get_lkup_meaning

1826: p_pe_type => p_pe_rec.quota_type_code,
1827: p_obj_name => G_DISC_RATE_TB,
1828: p_token1 =>
1829: G_DISC_OPTION||' = '||
1830: cn_api.get_lkup_meaning
1831: (p_pe_rec.disc_option_code,'DISCOUNT_OPTION'),
1832: p_token2 => NULL ,
1833: p_token3 => NULL ,
1834: p_loading_status => x_loading_status,

Line 1905: cn_api.get_lkup_meaning

1901: THEN
1902: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_TARGET_MUST_BE');
1903: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE','= 0');
1904: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1905: cn_api.get_lkup_meaning
1906: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1907: FND_MESSAGE.SET_TOKEN ('TOKEN1',NULL);
1908: FND_MSG_PUB.Add;
1909: END IF;

Line 1920: cn_api.get_lkup_meaning

1916: THEN
1917: FND_MESSAGE.SET_NAME ('CN' , 'CN_ITD_FLAG_MUST_BE');
1918: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
1919: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1920: cn_api.get_lkup_meaning
1921: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1922: FND_MESSAGE.SET_TOKEN ('TOKEN1',NULL);
1923: FND_MSG_PUB.Add;
1924: END IF;

Line 1945: cn_api.get_lkup_meaning

1941: THEN
1942: FND_MESSAGE.SET_NAME ('CN' , 'CN_CUM_FLAG_MUST_BE');
1943: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
1944: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1945: cn_api.get_lkup_meaning
1946: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1947: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1948: cn_api.get_lkup_meaning
1949: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'))

Line 1948: cn_api.get_lkup_meaning

1944: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1945: cn_api.get_lkup_meaning
1946: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1947: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1948: cn_api.get_lkup_meaning
1949: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'))
1950: ;
1951: FND_MSG_PUB.Add;
1952: END IF;

Line 1963: cn_api.get_lkup_meaning

1959: THEN
1960: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPLIT_FLAG_MUST_BE');
1961: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
1962: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1963: cn_api.get_lkup_meaning
1964: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1965: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1966: cn_api.get_lkup_meaning
1967: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'))

Line 1966: cn_api.get_lkup_meaning

1962: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
1963: cn_api.get_lkup_meaning
1964: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
1965: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
1966: cn_api.get_lkup_meaning
1967: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'))
1968: ;
1969: FND_MESSAGE.SET_TOKEN ('TOKEN2',NULL);
1970: FND_MESSAGE.SET_TOKEN ('TOKEN3',NULL);

Line 1980: IF (cn_api.pe_num_field_cannot_null

1976: -- Check Payment Amount
1977: -- NOT NULL : if payment type code = Payment amount %
1978: -- NULL : if payment type code = Fixed amount or applied Trx %
1979: IF p_pe_rec.payment_type_code = 'PAYMENT' THEN
1980: IF (cn_api.pe_num_field_cannot_null
1981: ( p_num_field => p_pe_rec.payment_amount,
1982: p_pe_type => p_pe_rec.quota_type_code,
1983: p_obj_name => G_PAYMENT_AMOUT,
1984: p_token1 => G_TRX_GROUP||' = '||

Line 1985: cn_api.get_lkup_meaning

1981: ( p_num_field => p_pe_rec.payment_amount,
1982: p_pe_type => p_pe_rec.quota_type_code,
1983: p_obj_name => G_PAYMENT_AMOUT,
1984: p_token1 => G_TRX_GROUP||' = '||
1985: cn_api.get_lkup_meaning
1986: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1987: p_token2 => G_PAYMENT_TYPE||' = '||
1988: cn_api.get_lkup_meaning
1989: (p_pe_rec.payment_type_code,

Line 1988: cn_api.get_lkup_meaning

1984: p_token1 => G_TRX_GROUP||' = '||
1985: cn_api.get_lkup_meaning
1986: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
1987: p_token2 => G_PAYMENT_TYPE||' = '||
1988: cn_api.get_lkup_meaning
1989: (p_pe_rec.payment_type_code,
1990: 'QUOTA_PAYMENT_TYPE'),
1991: p_token3 => NULL ,
1992: p_loading_status => x_loading_status,

Line 1998: (cn_api.pe_num_field_must_null

1994: THEN
1995: RAISE FND_API.G_EXC_ERROR ;
1996: END IF;
1997: ELSIF p_pe_rec.payment_type_code IN ('TRANSACTION','FIXED') AND
1998: (cn_api.pe_num_field_must_null
1999: ( p_num_field => p_pe_rec.payment_amount,
2000: p_pe_type => p_pe_rec.quota_type_code,
2001: p_obj_name => G_PAYMENT_AMOUT,
2002: p_token1 => G_TRX_GROUP||' = '||

Line 2003: cn_api.get_lkup_meaning

1999: ( p_num_field => p_pe_rec.payment_amount,
2000: p_pe_type => p_pe_rec.quota_type_code,
2001: p_obj_name => G_PAYMENT_AMOUT,
2002: p_token1 => G_TRX_GROUP||' = '||
2003: cn_api.get_lkup_meaning
2004: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
2005: p_token2 => G_PAYMENT_TYPE||' = '||
2006: cn_api.get_lkup_meaning
2007: (p_pe_rec.payment_type_code,

Line 2006: cn_api.get_lkup_meaning

2002: p_token1 => G_TRX_GROUP||' = '||
2003: cn_api.get_lkup_meaning
2004: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
2005: p_token2 => G_PAYMENT_TYPE||' = '||
2006: cn_api.get_lkup_meaning
2007: (p_pe_rec.payment_type_code,
2008: 'QUOTA_PAYMENT_TYPE'),
2009: p_token3 => NULL ,
2010: p_loading_status => x_loading_status,

Line 2029: IF (cn_api.pe_num_field_must_null

2025: -- payment amount = NULL
2026: -- split flag = N if cumulative flag = N
2027: --+
2028: -- Check payment amount = NULL
2029: IF (cn_api.pe_num_field_must_null
2030: ( p_num_field => p_pe_rec.payment_amount,
2031: p_pe_type => p_pe_rec.quota_type_code,
2032: p_obj_name => G_PAYMENT_AMOUT,
2033: p_token1 => G_TRX_GROUP||' = '||

Line 2034: cn_api.get_lkup_meaning

2030: ( p_num_field => p_pe_rec.payment_amount,
2031: p_pe_type => p_pe_rec.quota_type_code,
2032: p_obj_name => G_PAYMENT_AMOUT,
2033: p_token1 => G_TRX_GROUP||' = '||
2034: cn_api.get_lkup_meaning
2035: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
2036: p_token2 => G_PAYMENT_TYPE||' = '||
2037: cn_api.get_lkup_meaning
2038: (p_pe_rec.payment_type_code,

Line 2037: cn_api.get_lkup_meaning

2033: p_token1 => G_TRX_GROUP||' = '||
2034: cn_api.get_lkup_meaning
2035: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
2036: p_token2 => G_PAYMENT_TYPE||' = '||
2037: cn_api.get_lkup_meaning
2038: (p_pe_rec.payment_type_code,
2039: 'QUOTA_PAYMENT_TYPE'),
2040: p_token3 => NULL ,
2041: p_loading_status => x_loading_status,

Line 2054: cn_api.get_lkup_meaning

2050: THEN
2051: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPLIT_FLAG_MUST_BE');
2052: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
2053: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
2054: cn_api.get_lkup_meaning
2055: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
2056: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
2057: cn_api.get_lkup_meaning
2058: (p_pe_rec.trx_group_code,

Line 2057: cn_api.get_lkup_meaning

2053: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
2054: cn_api.get_lkup_meaning
2055: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
2056: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
2057: cn_api.get_lkup_meaning
2058: (p_pe_rec.trx_group_code,
2059: 'QUOTA_TRX_GROUP'));
2060: FND_MESSAGE.SET_TOKEN ('TOKEN2', G_PAYMENT_TYPE||' = '||
2061: cn_api.get_lkup_meaning

Line 2061: cn_api.get_lkup_meaning

2057: cn_api.get_lkup_meaning
2058: (p_pe_rec.trx_group_code,
2059: 'QUOTA_TRX_GROUP'));
2060: FND_MESSAGE.SET_TOKEN ('TOKEN2', G_PAYMENT_TYPE||' = '||
2061: cn_api.get_lkup_meaning
2062: (p_pe_rec.payment_type_code,
2063: 'QUOTA_PAYMENT_TYPE'));
2064: FND_MESSAGE.SET_TOKEN ('TOKEN3', G_ACCMULATE||' = '||
2065: p_pe_rec.cumulative_flag);

Line 2087: cn_api.get_lkup_meaning

2083: THEN
2084: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPLIT_FLAG_MUST_BE');
2085: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
2086: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
2087: cn_api.get_lkup_meaning
2088: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
2089: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
2090: cn_api.get_lkup_meaning
2091: (p_pe_rec.trx_group_code,

Line 2090: cn_api.get_lkup_meaning

2086: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
2087: cn_api.get_lkup_meaning
2088: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
2089: FND_MESSAGE.SET_TOKEN ('TOKEN1', G_TRX_GROUP||' = '||
2090: cn_api.get_lkup_meaning
2091: (p_pe_rec.trx_group_code,
2092: 'QUOTA_TRX_GROUP'));
2093: FND_MESSAGE.SET_TOKEN ('TOKEN2',G_PAYMENT_TYPE||' = '||
2094: cn_api.get_lkup_meaning

Line 2094: cn_api.get_lkup_meaning

2090: cn_api.get_lkup_meaning
2091: (p_pe_rec.trx_group_code,
2092: 'QUOTA_TRX_GROUP'));
2093: FND_MESSAGE.SET_TOKEN ('TOKEN2',G_PAYMENT_TYPE||' = '||
2094: cn_api.get_lkup_meaning
2095: (p_pe_rec.payment_type_code,
2096: 'QUOTA_PAYMENT_TYPE'));
2097: FND_MESSAGE.SET_TOKEN ('TOKEN3',NULL);
2098: FND_MSG_PUB.Add;

Line 2107: IF (cn_api.pe_num_field_cannot_null

2103: -- Check Payment Amount
2104: -- NOT NULL : if payment type code = Payment amount %
2105: -- NULL : if payment type code = Fixed amount
2106: IF p_pe_rec.payment_type_code = 'PAYMENT' THEN
2107: IF (cn_api.pe_num_field_cannot_null
2108: ( p_num_field => p_pe_rec.payment_amount,
2109: p_pe_type => p_pe_rec.quota_type_code,
2110: p_obj_name => G_PAYMENT_AMOUT,
2111: p_token1 => G_TRX_GROUP||' = '||

Line 2112: cn_api.get_lkup_meaning

2108: ( p_num_field => p_pe_rec.payment_amount,
2109: p_pe_type => p_pe_rec.quota_type_code,
2110: p_obj_name => G_PAYMENT_AMOUT,
2111: p_token1 => G_TRX_GROUP||' = '||
2112: cn_api.get_lkup_meaning
2113: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
2114: p_token2 => G_PAYMENT_TYPE||' = '||
2115: cn_api.get_lkup_meaning
2116: (p_pe_rec.payment_type_code,

Line 2115: cn_api.get_lkup_meaning

2111: p_token1 => G_TRX_GROUP||' = '||
2112: cn_api.get_lkup_meaning
2113: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
2114: p_token2 => G_PAYMENT_TYPE||' = '||
2115: cn_api.get_lkup_meaning
2116: (p_pe_rec.payment_type_code,
2117: 'QUOTA_PAYMENT_TYPE'),
2118: p_token3 => NULL ,
2119: p_loading_status => x_loading_status,

Line 2125: (cn_api.pe_num_field_must_null

2121: THEN
2122: RAISE FND_API.G_EXC_ERROR ;
2123: END IF;
2124: ELSIF p_pe_rec.payment_type_code = 'FIXED' AND
2125: (cn_api.pe_num_field_must_null
2126: ( p_num_field => p_pe_rec.payment_amount,
2127: p_pe_type => p_pe_rec.quota_type_code,
2128: p_obj_name => G_PAYMENT_AMOUT,
2129: p_token1 => G_TRX_GROUP||' = '||

Line 2130: cn_api.get_lkup_meaning

2126: ( p_num_field => p_pe_rec.payment_amount,
2127: p_pe_type => p_pe_rec.quota_type_code,
2128: p_obj_name => G_PAYMENT_AMOUT,
2129: p_token1 => G_TRX_GROUP||' = '||
2130: cn_api.get_lkup_meaning
2131: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
2132: p_token2 => G_PAYMENT_TYPE||' = '||
2133: cn_api.get_lkup_meaning
2134: (p_pe_rec.payment_type_code,

Line 2133: cn_api.get_lkup_meaning

2129: p_token1 => G_TRX_GROUP||' = '||
2130: cn_api.get_lkup_meaning
2131: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
2132: p_token2 => G_PAYMENT_TYPE||' = '||
2133: cn_api.get_lkup_meaning
2134: (p_pe_rec.payment_type_code,
2135: 'QUOTA_PAYMENT_TYPE'),
2136: p_token3 => NULL ,
2137: p_loading_status => x_loading_status,

Line 2157: IF (cn_api.pe_num_field_must_null

2153: END IF;
2154: -- Check discount rate table = Not Allowed
2155: -- Discount Option Code must = NONE is validate when calling
2156: -- valid_lookup_code() from valid_plan_element
2157: IF (cn_api.pe_num_field_must_null
2158: ( p_num_field => p_pe_rec.disc_rate_table_id,
2159: p_pe_type => p_pe_rec.quota_type_code,
2160: p_obj_name => G_DISC_RATE_TB,
2161: p_token1 => NULL ,

Line 2240: cn_api.get_lkup_meaning

2236: THEN
2237: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_TARGET_MUST_BE');
2238: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE','= 0');
2239: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
2240: cn_api.get_lkup_meaning
2241: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
2242: FND_MESSAGE.SET_TOKEN ('TOKEN1',NULL);
2243: FND_MSG_PUB.Add;
2244: END IF;

Line 2255: cn_api.get_lkup_meaning

2251: THEN
2252: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPLIT_FLAG_MUST_BE');
2253: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
2254: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
2255: cn_api.get_lkup_meaning
2256: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
2257: FND_MESSAGE.SET_TOKEN ('TOKEN1',NULL);
2258: FND_MESSAGE.SET_TOKEN ('TOKEN2',NULL);
2259: FND_MESSAGE.SET_TOKEN ('TOKEN3',NULL);

Line 2272: cn_api.get_lkup_meaning

2268: THEN
2269: FND_MESSAGE.SET_NAME ('CN' , 'CN_CUM_FLAG_MUST_BE');
2270: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
2271: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
2272: cn_api.get_lkup_meaning
2273: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
2274: FND_MESSAGE.SET_TOKEN ('TOKEN1',NULL);
2275: FND_MSG_PUB.Add;
2276: END IF;

Line 2287: cn_api.get_lkup_meaning

2283: THEN
2284: FND_MESSAGE.SET_NAME ('CN' , 'CN_ITD_FLAG_MUST_BE');
2285: FND_MESSAGE.SET_TOKEN ('OBJ_VALUE',l_no);
2286: FND_MESSAGE.SET_TOKEN ('PLAN_TYPE',
2287: cn_api.get_lkup_meaning
2288: (p_pe_rec.quota_type_code,'QUOTA_TYPE'));
2289: FND_MESSAGE.SET_TOKEN ('TOKEN1',NULL);
2290: FND_MSG_PUB.Add;
2291: END IF;

Line 2309: IF (cn_api.pe_num_field_cannot_null

2305: -- Check Payment Amount
2306: -- NOT NULL : if payment type code = Payment amount %
2307: -- NULL : if payment type code = Fixed amount or applied Trx %
2308: IF p_pe_rec.payment_type_code = 'PAYMENT' THEN
2309: IF (cn_api.pe_num_field_cannot_null
2310: ( p_num_field => p_pe_rec.payment_amount,
2311: p_pe_type => p_pe_rec.quota_type_code,
2312: p_obj_name => G_PAYMENT_AMOUT,
2313: p_token1 => G_TRX_GROUP||' = '||

Line 2314: cn_api.get_lkup_meaning

2310: ( p_num_field => p_pe_rec.payment_amount,
2311: p_pe_type => p_pe_rec.quota_type_code,
2312: p_obj_name => G_PAYMENT_AMOUT,
2313: p_token1 => G_TRX_GROUP||' = '||
2314: cn_api.get_lkup_meaning
2315: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
2316: p_token2 => G_PAYMENT_TYPE||' = '||
2317: cn_api.get_lkup_meaning
2318: (p_pe_rec.payment_type_code,

Line 2317: cn_api.get_lkup_meaning

2313: p_token1 => G_TRX_GROUP||' = '||
2314: cn_api.get_lkup_meaning
2315: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
2316: p_token2 => G_PAYMENT_TYPE||' = '||
2317: cn_api.get_lkup_meaning
2318: (p_pe_rec.payment_type_code,
2319: 'QUOTA_PAYMENT_TYPE'),
2320: p_token3 => NULL ,
2321: p_loading_status => x_loading_status,

Line 2327: (cn_api.pe_num_field_must_null

2323: THEN
2324: RAISE FND_API.G_EXC_ERROR ;
2325: END IF;
2326: ELSIF p_pe_rec.payment_type_code IN ('TRANSACTION','FIXED') AND
2327: (cn_api.pe_num_field_must_null
2328: ( p_num_field => p_pe_rec.payment_amount,
2329: p_pe_type => p_pe_rec.quota_type_code,
2330: p_obj_name => G_PAYMENT_AMOUT,
2331: p_token1 => G_TRX_GROUP||' = '||

Line 2332: cn_api.get_lkup_meaning

2328: ( p_num_field => p_pe_rec.payment_amount,
2329: p_pe_type => p_pe_rec.quota_type_code,
2330: p_obj_name => G_PAYMENT_AMOUT,
2331: p_token1 => G_TRX_GROUP||' = '||
2332: cn_api.get_lkup_meaning
2333: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
2334: p_token2 => G_PAYMENT_TYPE||' = '||
2335: cn_api.get_lkup_meaning
2336: (p_pe_rec.payment_type_code,

Line 2335: cn_api.get_lkup_meaning

2331: p_token1 => G_TRX_GROUP||' = '||
2332: cn_api.get_lkup_meaning
2333: (p_pe_rec.trx_group_code,'QUOTA_TRX_GROUP'),
2334: p_token2 => G_PAYMENT_TYPE||' = '||
2335: cn_api.get_lkup_meaning
2336: (p_pe_rec.payment_type_code,
2337: 'QUOTA_PAYMENT_TYPE'),
2338: p_token3 => NULL ,
2339: p_loading_status => x_loading_status,

Line 2354: IF (cn_api.pe_num_field_must_null

2350: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2351: RAISE FND_API.G_EXC_ERROR ;
2352: END IF;
2353: -- Check discount rate table = Not Allowed
2354: IF (cn_api.pe_num_field_must_null
2355: ( p_num_field => p_pe_rec.disc_rate_table_id,
2356: p_pe_type => p_pe_rec.quota_type_code,
2357: p_obj_name => G_DISC_RATE_TB,
2358: p_token1 => NULL ,

Line 2961: fnd_message.set_token ('FORMULA_TYPE', cn_api.get_lkup_meaning ('COMMISSION', 'INCENTIVE_TYPE'));

2957: THEN
2958: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2959: THEN
2960: fnd_message.set_name ('CN', 'CN_CANNOT_ASSIGN_FORMULA');
2961: fnd_message.set_token ('FORMULA_TYPE', cn_api.get_lkup_meaning ('COMMISSION', 'INCENTIVE_TYPE'));
2962: fnd_message.set_token ('PE_INC_TYPE', cn_api.get_lkup_meaning ('BONUS', 'INCENTIVE_TYPE'));
2963: fnd_msg_pub.ADD;
2964: END IF;
2965:

Line 2962: fnd_message.set_token ('PE_INC_TYPE', cn_api.get_lkup_meaning ('BONUS', 'INCENTIVE_TYPE'));

2958: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2959: THEN
2960: fnd_message.set_name ('CN', 'CN_CANNOT_ASSIGN_FORMULA');
2961: fnd_message.set_token ('FORMULA_TYPE', cn_api.get_lkup_meaning ('COMMISSION', 'INCENTIVE_TYPE'));
2962: fnd_message.set_token ('PE_INC_TYPE', cn_api.get_lkup_meaning ('BONUS', 'INCENTIVE_TYPE'));
2963: fnd_msg_pub.ADD;
2964: END IF;
2965:
2966: RAISE fnd_api.g_exc_error;

Line 2974: fnd_message.set_token ('FORMULA_TYPE', cn_api.get_lkup_meaning ('BONUS', 'INCENTIVE_TYPE'));

2970: THEN
2971: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2972: THEN
2973: fnd_message.set_name ('CN', 'CN_CANNOT_ASSIGN_FORMULA');
2974: fnd_message.set_token ('FORMULA_TYPE', cn_api.get_lkup_meaning ('BONUS', 'INCENTIVE_TYPE'));
2975: fnd_message.set_token ('PE_INC_TYPE', cn_api.get_lkup_meaning ('COMMISSION', 'INCENTIVE_TYPE'));
2976: fnd_msg_pub.ADD;
2977: END IF;
2978:

Line 2975: fnd_message.set_token ('PE_INC_TYPE', cn_api.get_lkup_meaning ('COMMISSION', 'INCENTIVE_TYPE'));

2971: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2972: THEN
2973: fnd_message.set_name ('CN', 'CN_CANNOT_ASSIGN_FORMULA');
2974: fnd_message.set_token ('FORMULA_TYPE', cn_api.get_lkup_meaning ('BONUS', 'INCENTIVE_TYPE'));
2975: fnd_message.set_token ('PE_INC_TYPE', cn_api.get_lkup_meaning ('COMMISSION', 'INCENTIVE_TYPE'));
2976: fnd_msg_pub.ADD;
2977: END IF;
2978:
2979: RAISE fnd_api.g_exc_error;

Line 3014: IF ((cn_api.pe_char_field_must_null (p_char_field => p_pe_rec.package_name,

3010: --+
3011: -- Validate Rule : if quota type is formula
3012: -- package Name = NULL, calc_formula_id must be not NULL.
3013: -- incentive_type should not be Manual.
3014: IF ((cn_api.pe_char_field_must_null (p_char_field => p_pe_rec.package_name,
3015: p_pe_type => p_pe_rec.quota_type_code,
3016: p_obj_name => g_package_name,
3017: p_token1 => NULL,
3018: p_token2 => NULL,

Line 3029: IF (cn_api.pe_num_field_cannot_null (p_num_field => p_pe_rec.calc_formula_id,

3025: THEN
3026: RAISE fnd_api.g_exc_error;
3027: END IF;
3028:
3029: IF (cn_api.pe_num_field_cannot_null (p_num_field => p_pe_rec.calc_formula_id,
3030: p_pe_type => p_pe_rec.quota_type_code,
3031: p_obj_name => g_formula_name,
3032: p_token1 => NULL,
3033: p_token2 => NULL,

Line 3049: fnd_message.set_token ('PLAN_TYPE', cn_api.get_lkup_meaning (p_pe_rec.quota_type_code, 'QUOTA_TYPE'));

3045: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
3046: THEN
3047: fnd_message.set_name ('CN', 'CN_INCENTIVE_TYPE_MUST_BE');
3048: fnd_message.set_token ('OBJ_VALUE', 'Bonus or Commission');
3049: fnd_message.set_token ('PLAN_TYPE', cn_api.get_lkup_meaning (p_pe_rec.quota_type_code, 'QUOTA_TYPE'));
3050: fnd_msg_pub.ADD;
3051: END IF;
3052:
3053: x_loading_status := 'CN_INCENTIVE_TYPE_MUST_BE';

Line 3096: IF ((cn_api.pe_num_field_must_null (p_num_field => p_pe_rec.calc_formula_id,

3092: --+
3093: -- Validate Rule : if quota type is EXTERNAL
3094: -- package Name must not be Null, Calc_Fromula_id must be null.
3095: -- incentive_type should not be MANUAL
3096: IF ((cn_api.pe_num_field_must_null (p_num_field => p_pe_rec.calc_formula_id,
3097: p_pe_type => p_pe_rec.quota_type_code,
3098: p_obj_name => g_formula_name,
3099: p_token1 => NULL,
3100: p_token2 => NULL,

Line 3111: IF (cn_api.pe_char_field_cannot_null (p_char_field => p_pe_rec.package_name,

3107: THEN
3108: RAISE fnd_api.g_exc_error;
3109: END IF;
3110:
3111: IF (cn_api.pe_char_field_cannot_null (p_char_field => p_pe_rec.package_name,
3112: p_pe_type => p_pe_rec.quota_type_code,
3113: p_obj_name => g_package_name,
3114: p_token1 => NULL,
3115: p_token2 => NULL,

Line 3131: fnd_message.set_token ('PLAN_TYPE', cn_api.get_lkup_meaning (p_pe_rec.quota_type_code, 'QUOTA_TYPE'));

3127: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
3128: THEN
3129: fnd_message.set_name ('CN', 'CN_INCENTIVE_TYPE_MUST_BE');
3130: fnd_message.set_token ('OBJ_VALUE', 'Bonus or Commission');
3131: fnd_message.set_token ('PLAN_TYPE', cn_api.get_lkup_meaning (p_pe_rec.quota_type_code, 'QUOTA_TYPE'));
3132: fnd_msg_pub.ADD;
3133: END IF;
3134:
3135: x_loading_status := 'CN_INCENTIVE_TYPE_MUST_BE';

Line 3178: IF ((cn_api.pe_num_field_must_null (p_num_field => p_pe_rec.calc_formula_id,

3174: --+
3175: -- Validate Rule : if quota type is OTHER
3176: -- package Name must be Null, Calc_Fromula_id must be null.
3177: -- incentive_type must me MANUAL
3178: IF ((cn_api.pe_num_field_must_null (p_num_field => p_pe_rec.calc_formula_id,
3179: p_pe_type => p_pe_rec.quota_type_code,
3180: p_obj_name => g_formula_name,
3181: p_token1 => NULL,
3182: p_token2 => NULL,

Line 3193: IF ((cn_api.pe_char_field_must_null (p_char_field => p_pe_rec.package_name,

3189: THEN
3190: RAISE fnd_api.g_exc_error;
3191: END IF;
3192:
3193: IF ((cn_api.pe_char_field_must_null (p_char_field => p_pe_rec.package_name,
3194: p_pe_type => p_pe_rec.quota_type_code,
3195: p_obj_name => g_package_name,
3196: p_token1 => NULL,
3197: p_token2 => NULL,

Line 3214: fnd_message.set_token ('PLAN_TYPE', cn_api.get_lkup_meaning (p_pe_rec.quota_type_code, 'QUOTA_TYPE'));

3210: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
3211: THEN
3212: fnd_message.set_name ('CN', 'CN_INCENTIVE_TYPE_MUST_BE');
3213: fnd_message.set_token ('OBJ_VALUE', 'Manual');
3214: fnd_message.set_token ('PLAN_TYPE', cn_api.get_lkup_meaning (p_pe_rec.quota_type_code, 'QUOTA_TYPE'));
3215: fnd_msg_pub.ADD;
3216: END IF;
3217:
3218: x_loading_status := 'CN_INCENTIVE_TYPE_MUST_BE';

Line 3783: IF (NOT cn_api.date_range_overlap (l_rec.start_date, l_rec.end_date, p_start_date, p_end_date))

3779: IF p_quota_id IS NOT NULL
3780: THEN
3781: FOR l_rec IN comp_plan_curs
3782: LOOP
3783: IF (NOT cn_api.date_range_overlap (l_rec.start_date, l_rec.end_date, p_start_date, p_end_date))
3784: THEN
3785: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
3786: THEN
3787: fnd_message.set_name ('CN', 'CN_CP_DT_NOT_WITHIN_QUOTA');