DBA Data[Home] [Help]

APPS.OZF_OFFER_PVT dependencies on FND_MESSAGE

Line 464: Fnd_Message.SET_NAME('OZF','OZF_QP_ERROR');

460: BEGIN
461: FOR i IN 1 .. p_msg_count LOOP
462: l_msg_data := Oe_Msg_Pub.get( p_msg_index => i,
463: p_encoded => 'F' );
464: Fnd_Message.SET_NAME('OZF','OZF_QP_ERROR');
465: Fnd_Message.SET_TOKEN('ERROR_MSG',l_msg_data);
466: Fnd_Msg_Pub.ADD;
467: END LOOP;
468: END add_message;

Line 465: Fnd_Message.SET_TOKEN('ERROR_MSG',l_msg_data);

461: FOR i IN 1 .. p_msg_count LOOP
462: l_msg_data := Oe_Msg_Pub.get( p_msg_index => i,
463: p_encoded => 'F' );
464: Fnd_Message.SET_NAME('OZF','OZF_QP_ERROR');
465: Fnd_Message.SET_TOKEN('ERROR_MSG',l_msg_data);
466: Fnd_Msg_Pub.ADD;
467: END LOOP;
468: END add_message;
469:

Line 3063: Fnd_Message.SET_NAME('OZF','OZF_OFFR_STARTDATE_LT_SYSDATE');

3059: AND p_offer_rec.start_date_active <> FND_API.G_MISS_DATE THEN
3060: IF p_offer_rec.offer_operation = 'CREATE' THEN
3061: IF p_offer_rec.start_date_active < TRUNC(SYSDATE) THEN
3062: IF p_offer_rec.offer_type <> 'NET_ACCRUAL' AND p_offer_rec.custom_setup_id <> 117 THEN
3063: Fnd_Message.SET_NAME('OZF','OZF_OFFR_STARTDATE_LT_SYSDATE');
3064: Fnd_Msg_Pub.ADD;
3065: RAISE FND_API.G_EXC_ERROR;
3066: END IF;
3067: END IF;

Line 3074: Fnd_Message.SET_NAME('OZF','OZF_OFFR_STARTDATE_LT_CREDATE');

3070: FETCH c_creation_date INTO l_creation_date;
3071: CLOSE c_creation_date;
3072: IF p_offer_rec.start_date_active < l_creation_date THEN
3073: IF p_offer_rec.offer_type <> 'NET_ACCRUAL' AND p_offer_rec.custom_setup_id <> 117 THEN
3074: Fnd_Message.SET_NAME('OZF','OZF_OFFR_STARTDATE_LT_CREDATE');
3075: Fnd_Msg_Pub.ADD;
3076: RAISE FND_API.G_EXC_ERROR;
3077: END IF;
3078: END IF;

Line 3087: Fnd_Message.SET_NAME('OZF','OZF_OFFR_ENDDATE_LT_SYSDATE');

3083: AND p_offer_rec.end_date_active <> FND_API.G_MISS_DATE THEN
3084: IF p_offer_rec.offer_operation = 'CREATE' THEN
3085: IF p_offer_rec.end_date_active < TRUNC(SYSDATE) THEN
3086: IF p_offer_rec.offer_type <> 'NET_ACCRUAL' AND p_offer_rec.custom_setup_id <> 117 THEN
3087: Fnd_Message.SET_NAME('OZF','OZF_OFFR_ENDDATE_LT_SYSDATE');
3088: Fnd_Msg_Pub.ADD;
3089: RAISE FND_API.G_EXC_ERROR;
3090: END IF;
3091: END IF;

Line 3098: Fnd_Message.SET_NAME('OZF','OZF_OFFR_ENDDATE_LT_CREDATE');

3094: FETCH c_creation_date INTO l_creation_date;
3095: CLOSE c_creation_date;
3096: IF p_offer_rec.end_date_active < l_creation_date THEN
3097: IF p_offer_rec.offer_type <> 'NET_ACCRUAL' AND p_offer_rec.custom_setup_id <> 117 THEN
3098: Fnd_Message.SET_NAME('OZF','OZF_OFFR_ENDDATE_LT_CREDATE');
3099: Fnd_Msg_Pub.ADD;
3100: RAISE FND_API.G_EXC_ERROR;
3101: END IF;
3102: END IF;

Line 4371: Fnd_Message.set_name('OZF', 'OZF_ACT_OFFER_DUP_OFFER_CODE');

4367: l_uk_flag := OZF_Utility_PVT.check_uniqueness('AMS_SOURCE_CODES','source_code = ''' || p_modifier_list_rec.offer_code || '''');
4368:
4369: IF l_uk_flag = Fnd_Api.g_false THEN
4370: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4371: Fnd_Message.set_name('OZF', 'OZF_ACT_OFFER_DUP_OFFER_CODE');
4372: Fnd_Msg_Pub.ADD;
4373: END IF;
4374: END IF;
4375: END IF;

Line 4701: FND_MESSAGE.SET_NAME('OZF','OZF_OFFR_IEB_LT_SCANVALUE');

4697: AND p_modifier_list_rec.budget_amount_tc <> FND_API.G_MISS_NUM THEN
4698: IF p_modifier_list_rec.budget_amount_tc >= l_scan_value THEN
4699: l_promotional_offers_rec.budget_amount_tc := p_modifier_list_rec.budget_amount_tc;
4700: ELSE
4701: FND_MESSAGE.SET_NAME('OZF','OZF_OFFR_IEB_LT_SCANVALUE');
4702: Fnd_Msg_Pub.ADD;
4703: RAISE FND_API.G_EXC_ERROR;
4704: END IF;
4705: END IF;

Line 4734: FND_MESSAGE.SET_NAME('OZF','OZF_OFFR_IEB_NEG');

4730: l_promotional_offers_rec.budget_amount_tc := p_modifier_list_rec.budget_amount_tc;
4731: END IF;
4732:
4733: IF l_promotional_offers_rec.budget_amount_tc < 0 THEN
4734: FND_MESSAGE.SET_NAME('OZF','OZF_OFFR_IEB_NEG');
4735: Fnd_Msg_Pub.ADD;
4736: RAISE FND_API.G_EXC_ERROR;
4737: END IF;
4738:

Line 5827: FND_MESSAGE.SET_NAME('OZF','OZF_UOM_QTY_REQD');

5823: AND p_modifier_line_tbl(j).pricing_attr_value_from <> FND_API.g_miss_num) OR
5824: (p_modifier_line_tbl(j).pricing_attr is not null
5825: AND p_modifier_line_tbl(j).pricing_attr <> FND_API.g_miss_char))
5826: THEN
5827: FND_MESSAGE.SET_NAME('OZF','OZF_UOM_QTY_REQD');
5828:
5829: Fnd_Msg_Pub.ADD;
5830: RAISE FND_API.G_EXC_ERROR;
5831: END IF;

Line 6889: FND_MESSAGE.SET_NAME('OZF','OZF_INVALID_DISTR_ACTIVE');

6885: IF l_lumpsum_offer.distribution_type = 'AMT' THEN
6886: IF l_lumpsum_offer.STATUS_CODE = 'PENDING' OR l_lumpsum_offer.STATUS_CODE = 'ACTIVE' THEN
6887:
6888: IF l_total_distribution <> l_lumpsum_offer.lumpsum_amount THEN
6889: FND_MESSAGE.SET_NAME('OZF','OZF_INVALID_DISTR_ACTIVE');
6890: Fnd_Msg_Pub.ADD;
6891: RAISE FND_API.G_EXC_ERROR;
6892: END IF;
6893:

Line 6897: FND_MESSAGE.SET_NAME('OZF','OZF_INVALID_DISTRIBUTION');

6893:
6894: ELSE
6895:
6896: IF l_total_distribution > l_lumpsum_offer.lumpsum_amount THEN
6897: FND_MESSAGE.SET_NAME('OZF','OZF_INVALID_DISTRIBUTION');
6898: Fnd_Msg_Pub.ADD;
6899: RAISE FND_API.G_EXC_ERROR;
6900: END IF;
6901:

Line 6909: FND_MESSAGE.SET_NAME('OZF','OZF_INVALID_DISTR_ACTIVE');

6905:
6906: IF l_lumpsum_offer.STATUS_CODE = 'PENDING' OR l_lumpsum_offer.STATUS_CODE = 'ACTIVE' THEN
6907:
6908: IF l_total_distribution <> 100 THEN
6909: FND_MESSAGE.SET_NAME('OZF','OZF_INVALID_DISTR_ACTIVE');
6910: Fnd_Msg_Pub.ADD;
6911: RAISE FND_API.G_EXC_ERROR;
6912: END IF;
6913:

Line 6918: FND_MESSAGE.SET_NAME('OZF','OZF_INVALID_DISTRIBUTION');

6914:
6915: ELSE
6916:
6917: IF l_total_distribution > 100 THEN
6918: FND_MESSAGE.SET_NAME('OZF','OZF_INVALID_DISTRIBUTION');
6919: Fnd_Msg_Pub.ADD;
6920: RAISE FND_API.G_EXC_ERROR;
6921: END IF;
6922:

Line 7271: FND_MESSAGE.SET_NAME('OZF','OZF_UOM_QTY_REQD');

7267: AND p_modifier_line_tbl(i).pricing_attr_value_from <> FND_API.g_miss_num) OR
7268: (p_modifier_line_tbl(i).pricing_attr is not null
7269: AND p_modifier_line_tbl(i).pricing_attr <> FND_API.g_miss_char))
7270: THEN
7271: FND_MESSAGE.SET_NAME('OZF','OZF_UOM_QTY_REQD');
7272:
7273: Fnd_Msg_Pub.ADD;
7274: RAISE FND_API.G_EXC_ERROR;
7275: END IF;

Line 7558: Fnd_Message.SET_NAME('OZF','OZF_TRD_DEAL_NEG_AMT');

7554: IF p_modifier_line_tbl(i).max_amount_per_rule IS NOT NULL
7555: AND p_modifier_line_tbl(i).max_amount_per_rule <> FND_API.G_MISS_NUM
7556: AND p_modifier_line_tbl(i).max_amount_per_rule <= 0 THEN
7557: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
7558: Fnd_Message.SET_NAME('OZF','OZF_TRD_DEAL_NEG_AMT');
7559: Fnd_Msg_Pub.ADD;
7560: END IF;
7561: RAISE Fnd_Api.g_exc_error;
7562: END IF;

Line 7568: Fnd_Message.SET_NAME('OZF','OZF_TRD_DEAL_NEG_QTY');

7564: IF p_modifier_line_tbl(i).max_qty_per_rule IS NOT NULL
7565: AND p_modifier_line_tbl(i).max_qty_per_rule <> FND_API.G_MISS_NUM
7566: AND p_modifier_line_tbl(i).max_qty_per_rule <= 0 THEN
7567: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
7568: Fnd_Message.SET_NAME('OZF','OZF_TRD_DEAL_NEG_QTY');
7569: Fnd_Msg_Pub.ADD;
7570: END IF;
7571: RAISE Fnd_Api.g_exc_error;
7572: END IF;

Line 7586: Fnd_Message.SET_NAME('OZF','OZF_TRD_DEAL_NO_OPERAND');

7582: OR (p_modifier_line_tbl(i).arithmetic_operator IS NULL OR p_modifier_line_tbl(i).arithmetic_operator = FND_API.g_miss_char))
7583: AND ((p_modifier_line_tbl(i).qd_operand IS NULL OR p_modifier_line_tbl(i).qd_operand = FND_API.g_miss_num)
7584: OR (p_modifier_line_tbl(i).qd_arithmetic_operator IS NULL OR p_modifier_line_tbl(i).qd_arithmetic_operator = FND_API.g_miss_char)) THEN
7585: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
7586: Fnd_Message.SET_NAME('OZF','OZF_TRD_DEAL_NO_OPERAND');
7587: Fnd_Msg_Pub.ADD;
7588: END IF;
7589: RAISE Fnd_Api.g_exc_error;
7590:

Line 7635: Fnd_Message.SET_NAME('OZF','OZF_TRD_DEAL_NO_ACC_OPERAND');

7631: CLOSE c_modifier_id;
7632:
7633: IF l_related_modifier_id IS NOT NULL THEN
7634: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
7635: Fnd_Message.SET_NAME('OZF','OZF_TRD_DEAL_NO_ACC_OPERAND');
7636: Fnd_Msg_Pub.ADD;
7637: x_error_location := i;
7638: END IF;
7639: RAISE Fnd_Api.g_exc_error;

Line 7666: Fnd_Message.SET_NAME('OZF','OZF_TRD_DEAL_NO_OFF_OPERAND');

7662: CLOSE c_modifier_id;
7663:
7664: IF l_modifier_id IS NOT NULL AND l_related_modifier_id IS NOT NULL THEN
7665: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
7666: Fnd_Message.SET_NAME('OZF','OZF_TRD_DEAL_NO_OFF_OPERAND');
7667: Fnd_Msg_Pub.ADD;
7668: x_error_location := i;
7669: END IF;
7670: RAISE Fnd_Api.g_exc_error;

Line 7892: Fnd_Message.SET_NAME('OZF','OZF_TRD_DEAL_NO_QTY');

7888:
7889: IF (l_modifier_line_tbl(i).max_qty_per_rule IS NULL OR l_modifier_line_tbl(i).max_qty_per_rule = FND_API.G_MISS_NUM)
7890: AND l_modifier_line_tbl(i).qd_estimated_qty_is_max = 'Y' THEN
7891: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
7892: Fnd_Message.SET_NAME('OZF','OZF_TRD_DEAL_NO_QTY');
7893: Fnd_Msg_Pub.ADD;
7894: END IF;
7895: RAISE Fnd_Api.g_exc_error;
7896: END IF;

Line 7901: Fnd_Message.SET_NAME('OZF', 'OZF_TRD_DEAL_NO_AMT');

7897:
7898: IF (l_modifier_line_tbl(i).max_amount_per_rule IS NULL OR l_modifier_line_tbl(i).max_amount_per_rule = FND_API.G_MISS_NUM)
7899: AND l_modifier_line_tbl(i).qd_estimated_amount_is_max = 'Y' THEN
7900: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
7901: Fnd_Message.SET_NAME('OZF', 'OZF_TRD_DEAL_NO_AMT');
7902: Fnd_Msg_Pub.ADD;
7903: END IF;
7904: RAISE Fnd_Api.g_exc_error;
7905: END IF;

Line 8818: FND_MESSAGE.set_name('OZF','OZF_NO_PRICING_PHASE_LINEGROUP');

8814: x_error_location := 0;
8815:
8816: -- added by julou 14-DEC-2001 check default profile values before going any further
8817: IF FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP') IS NULL THEN
8818: FND_MESSAGE.set_name('OZF','OZF_NO_PRICING_PHASE_LINEGROUP');
8819: FND_MSG_PUB.add;
8820: RAISE FND_API.g_exc_unexpected_error;
8821: END IF;
8822:

Line 8824: FND_MESSAGE.set_name('OZF','OZF_NO_PRICING_PHASE_LINE');

8820: RAISE FND_API.g_exc_unexpected_error;
8821: END IF;
8822:
8823: IF FND_PROFILE.value('OZF_PRICING_PHASE_LINE') IS NULL THEN
8824: FND_MESSAGE.set_name('OZF','OZF_NO_PRICING_PHASE_LINE');
8825: FND_MSG_PUB.add;
8826: RAISE FND_API.g_exc_unexpected_error;
8827: END IF;
8828:

Line 8830: FND_MESSAGE.set_name('OZF','OZF_NO_PRICING_PHASE_ORDER');

8826: RAISE FND_API.g_exc_unexpected_error;
8827: END IF;
8828:
8829: IF FND_PROFILE.value('OZF_PRICING_PHASE_ORDER') IS NULL THEN
8830: FND_MESSAGE.set_name('OZF','OZF_NO_PRICING_PHASE_ORDER');
8831: FND_MSG_PUB.add;
8832: RAISE FND_API.g_exc_unexpected_error;
8833: END IF;
8834:

Line 8836: FND_MESSAGE.set_name('OZF','OZF_NO_PRICING_GROUP_SEQUENCE');

8832: RAISE FND_API.g_exc_unexpected_error;
8833: END IF;
8834:
8835: IF FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE') IS NULL THEN
8836: FND_MESSAGE.set_name('OZF','OZF_NO_PRICING_GROUP_SEQUENCE');
8837: FND_MSG_PUB.add;
8838: RAISE FND_API.g_exc_unexpected_error;
8839: END IF;
8840:

Line 8842: FND_MESSAGE.set_name('OZF','OZF_NO_PRINT_ON_INVOICE');

8838: RAISE FND_API.g_exc_unexpected_error;
8839: END IF;
8840:
8841: IF FND_PROFILE.value('OZF_PRINT_ON_INVOICE') IS NULL THEN
8842: FND_MESSAGE.set_name('OZF','OZF_NO_PRINT_ON_INVOICE');
8843: FND_MSG_PUB.add;
8844: RAISE FND_API.g_exc_unexpected_error;
8845: END IF;
8846: /* julou bug 3498759 - comment OUT NOCOPY as these profiles are not mandatory

Line 8848: FND_MESSAGE.set_name('OZF','OZF_NO_INCOMPATIBILITY_GROUP');

8844: RAISE FND_API.g_exc_unexpected_error;
8845: END IF;
8846: /* julou bug 3498759 - comment OUT NOCOPY as these profiles are not mandatory
8847: IF FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP') IS NULL THEN
8848: FND_MESSAGE.set_name('OZF','OZF_NO_INCOMPATIBILITY_GROUP');
8849: FND_MSG_PUB.add;
8850: RAISE FND_API.g_exc_unexpected_error;
8851: END IF;
8852: */

Line 8854: FND_MESSAGE.set_name('OZF','OZF_NO_PRODUCT_PRECEDENCE');

8850: RAISE FND_API.g_exc_unexpected_error;
8851: END IF;
8852: */
8853: IF FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE') IS NULL THEN
8854: FND_MESSAGE.set_name('OZF','OZF_NO_PRODUCT_PRECEDENCE');
8855: FND_MSG_PUB.add;
8856: RAISE FND_API.g_exc_unexpected_error;
8857: END IF;
8858:

Line 8985: FND_MESSAGE.set_name('OZF', 'OZF_CLEAR_OU');

8981: l_modifier_list_rec.offer_type := p_offer_type;
8982:
8983: IF p_modifier_list_rec.global_flag = 'Y' THEN
8984: IF p_modifier_list_rec.orig_org_id IS NOT NULL AND p_modifier_list_rec.orig_org_id <> fnd_api.g_miss_num THEN
8985: FND_MESSAGE.set_name('OZF', 'OZF_CLEAR_OU');
8986: FND_MSG_PUB.add;
8987: RAISE FND_API.g_exc_error;
8988: END IF;
8989: END IF;

Line 9020: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

9016: (p_modifier_list_rec.orig_org_id IS NULL)
9017: )
9018: )
9019: THEN
9020: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
9021: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');
9022: FND_MSG_PUB.add;
9023: RAISE FND_API.g_exc_error;
9024: END IF;

Line 9021: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');

9017: )
9018: )
9019: THEN
9020: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
9021: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');
9022: FND_MSG_PUB.add;
9023: RAISE FND_API.g_exc_error;
9024: END IF;
9025: END IF;

Line 9259: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_NO_DISC_LINES');

9255:
9256: IF l_lines_count = 0 THEN
9257: IF p_modifier_list_rec.custom_setup_id <> 110 THEN
9258: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
9259: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_NO_DISC_LINES');
9260: FND_MSG_PUB.add;
9261: END IF;
9262: RAISE FND_API.g_exc_error;
9263: END IF;

Line 9268: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_EMPTY_DISC_STRUCT');

9264: END IF;
9265: -- julou end bug 2122722
9266: -- julou BREQ
9267: IF l_emptyDiscStruct = '1' THEN
9268: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_EMPTY_DISC_STRUCT');
9269: FND_MSG_PUB.add;
9270: RAISE FND_API.g_exc_error;
9271: END IF;
9272:

Line 9277: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_NO_BUDGET_REQUEST');

9273:
9274: IF l_budget_required = 'Y' THEN
9275: IF get_budget_source_count(p_modifier_list_rec.qp_list_header_id) = 0 THEN
9276: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
9277: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_NO_BUDGET_REQUEST');
9278: FND_MSG_PUB.add;
9279: END IF;
9280: RAISE FND_API.g_exc_error;
9281: END IF;

Line 10689: x_modifier_list_rec.COMMENTS := FND_MESSAGE.GET_STRING('OZF','OZF_SD_OFFER_COMMENTS');

10685: x_modifier_list_rec.NAME := NVL(l_authorization_number, l_request_number);
10686: x_modifier_list_rec.DESCRIPTION := NVL(l_authorization_number, l_request_number);
10687: --fix for bug 7580884
10688: x_modifier_list_rec.OFFER_CODE := l_request_number; --NVL(l_authorization_number, l_request_number);
10689: x_modifier_list_rec.COMMENTS := FND_MESSAGE.GET_STRING('OZF','OZF_SD_OFFER_COMMENTS');
10690: x_modifier_list_rec.ASK_FOR_FLAG := NVL(l_request_basis,'N');
10691:
10692: IF l_org_id IS NOT NULL AND l_org_id <> FND_API.G_MISS_NUM
10693: AND NVL(fnd_profile.value('QP_SECURITY_CONTROL'), 'OFF') <> 'OFF' THEN

Line 11457: FND_MESSAGE.set_name('OZF', 'OZF_SD_OFFR_NO_BUDGET_REQUEST');

11453: g_sd_offer := 'Y';
11454:
11455: IF FND_PROFILE.VALUE('OZF_SD_DEFAULT_BUDGET') IS NULL THEN
11456: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
11457: FND_MESSAGE.set_name('OZF', 'OZF_SD_OFFR_NO_BUDGET_REQUEST');
11458: FND_MSG_PUB.add;
11459: END IF;
11460: RAISE Fnd_Api.g_exc_unexpected_error;
11461: END IF;

Line 11624: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_NO_DISC_LINES');

11620:
11621: ELSE
11622:
11623: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
11624: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_NO_DISC_LINES');
11625: FND_MSG_PUB.add;
11626: END IF;
11627: RAISE FND_API.g_exc_error;
11628: END IF;