89: l_original_modifier_value := (100 * p_operand_value)/p_least_percent;
90:
91: IF (p_limit_code = QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED) THEN
92: IF (p_limit_level = 'H') THEN
93: FND_MESSAGE.SET_NAME('QP','QP_HEADER_LIMIT_EXCEEDED');
94: FND_MESSAGE.SET_TOKEN('PROMOTION_NUMBER',l_modifier_name);
95: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
96: FND_MESSAGE.SET_TOKEN('LIMIT_EXCEEDED_BY',nvl(l_limit_exceeded_by,0));
97: l_message_text := FND_MESSAGE.GET;
90:
91: IF (p_limit_code = QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED) THEN
92: IF (p_limit_level = 'H') THEN
93: FND_MESSAGE.SET_NAME('QP','QP_HEADER_LIMIT_EXCEEDED');
94: FND_MESSAGE.SET_TOKEN('PROMOTION_NUMBER',l_modifier_name);
95: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
96: FND_MESSAGE.SET_TOKEN('LIMIT_EXCEEDED_BY',nvl(l_limit_exceeded_by,0));
97: l_message_text := FND_MESSAGE.GET;
98: ELSIF (p_limit_level = 'L') THEN
91: IF (p_limit_code = QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED) THEN
92: IF (p_limit_level = 'H') THEN
93: FND_MESSAGE.SET_NAME('QP','QP_HEADER_LIMIT_EXCEEDED');
94: FND_MESSAGE.SET_TOKEN('PROMOTION_NUMBER',l_modifier_name);
95: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
96: FND_MESSAGE.SET_TOKEN('LIMIT_EXCEEDED_BY',nvl(l_limit_exceeded_by,0));
97: l_message_text := FND_MESSAGE.GET;
98: ELSIF (p_limit_level = 'L') THEN
99: FND_MESSAGE.SET_NAME('QP','QP_LINE_LIMIT_EXCEEDED');
92: IF (p_limit_level = 'H') THEN
93: FND_MESSAGE.SET_NAME('QP','QP_HEADER_LIMIT_EXCEEDED');
94: FND_MESSAGE.SET_TOKEN('PROMOTION_NUMBER',l_modifier_name);
95: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
96: FND_MESSAGE.SET_TOKEN('LIMIT_EXCEEDED_BY',nvl(l_limit_exceeded_by,0));
97: l_message_text := FND_MESSAGE.GET;
98: ELSIF (p_limit_level = 'L') THEN
99: FND_MESSAGE.SET_NAME('QP','QP_LINE_LIMIT_EXCEEDED');
100: FND_MESSAGE.SET_TOKEN('MODIFIER_NUMBER',l_list_line_no);
93: FND_MESSAGE.SET_NAME('QP','QP_HEADER_LIMIT_EXCEEDED');
94: FND_MESSAGE.SET_TOKEN('PROMOTION_NUMBER',l_modifier_name);
95: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
96: FND_MESSAGE.SET_TOKEN('LIMIT_EXCEEDED_BY',nvl(l_limit_exceeded_by,0));
97: l_message_text := FND_MESSAGE.GET;
98: ELSIF (p_limit_level = 'L') THEN
99: FND_MESSAGE.SET_NAME('QP','QP_LINE_LIMIT_EXCEEDED');
100: FND_MESSAGE.SET_TOKEN('MODIFIER_NUMBER',l_list_line_no);
101: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
95: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
96: FND_MESSAGE.SET_TOKEN('LIMIT_EXCEEDED_BY',nvl(l_limit_exceeded_by,0));
97: l_message_text := FND_MESSAGE.GET;
98: ELSIF (p_limit_level = 'L') THEN
99: FND_MESSAGE.SET_NAME('QP','QP_LINE_LIMIT_EXCEEDED');
100: FND_MESSAGE.SET_TOKEN('MODIFIER_NUMBER',l_list_line_no);
101: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
102: FND_MESSAGE.SET_TOKEN('LIMIT_EXCEEDED_BY',nvl(l_limit_exceeded_by,0));
103: l_message_text := FND_MESSAGE.GET;
96: FND_MESSAGE.SET_TOKEN('LIMIT_EXCEEDED_BY',nvl(l_limit_exceeded_by,0));
97: l_message_text := FND_MESSAGE.GET;
98: ELSIF (p_limit_level = 'L') THEN
99: FND_MESSAGE.SET_NAME('QP','QP_LINE_LIMIT_EXCEEDED');
100: FND_MESSAGE.SET_TOKEN('MODIFIER_NUMBER',l_list_line_no);
101: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
102: FND_MESSAGE.SET_TOKEN('LIMIT_EXCEEDED_BY',nvl(l_limit_exceeded_by,0));
103: l_message_text := FND_MESSAGE.GET;
104: END IF;
97: l_message_text := FND_MESSAGE.GET;
98: ELSIF (p_limit_level = 'L') THEN
99: FND_MESSAGE.SET_NAME('QP','QP_LINE_LIMIT_EXCEEDED');
100: FND_MESSAGE.SET_TOKEN('MODIFIER_NUMBER',l_list_line_no);
101: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
102: FND_MESSAGE.SET_TOKEN('LIMIT_EXCEEDED_BY',nvl(l_limit_exceeded_by,0));
103: l_message_text := FND_MESSAGE.GET;
104: END IF;
105: END IF;
98: ELSIF (p_limit_level = 'L') THEN
99: FND_MESSAGE.SET_NAME('QP','QP_LINE_LIMIT_EXCEEDED');
100: FND_MESSAGE.SET_TOKEN('MODIFIER_NUMBER',l_list_line_no);
101: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
102: FND_MESSAGE.SET_TOKEN('LIMIT_EXCEEDED_BY',nvl(l_limit_exceeded_by,0));
103: l_message_text := FND_MESSAGE.GET;
104: END IF;
105: END IF;
106:
99: FND_MESSAGE.SET_NAME('QP','QP_LINE_LIMIT_EXCEEDED');
100: FND_MESSAGE.SET_TOKEN('MODIFIER_NUMBER',l_list_line_no);
101: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
102: FND_MESSAGE.SET_TOKEN('LIMIT_EXCEEDED_BY',nvl(l_limit_exceeded_by,0));
103: l_message_text := FND_MESSAGE.GET;
104: END IF;
105: END IF;
106:
107: IF (p_limit_code = QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED) THEN
105: END IF;
106:
107: IF (p_limit_code = QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED) THEN
108: IF (p_limit_level = 'H') THEN
109: FND_MESSAGE.SET_NAME('QP','QP_HEADER_LIMIT_ADJUSTED');
110: FND_MESSAGE.SET_TOKEN('PROMOTION_NUMBER',l_modifier_name);
111: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
112: FND_MESSAGE.SET_TOKEN('OPERAND',l_original_modifier_value);
113: FND_MESSAGE.SET_TOKEN('PERCENT',p_operand_value);
106:
107: IF (p_limit_code = QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED) THEN
108: IF (p_limit_level = 'H') THEN
109: FND_MESSAGE.SET_NAME('QP','QP_HEADER_LIMIT_ADJUSTED');
110: FND_MESSAGE.SET_TOKEN('PROMOTION_NUMBER',l_modifier_name);
111: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
112: FND_MESSAGE.SET_TOKEN('OPERAND',l_original_modifier_value);
113: FND_MESSAGE.SET_TOKEN('PERCENT',p_operand_value);
114: FND_MESSAGE.SET_TOKEN('OPERATOR',l_operator_name);
107: IF (p_limit_code = QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED) THEN
108: IF (p_limit_level = 'H') THEN
109: FND_MESSAGE.SET_NAME('QP','QP_HEADER_LIMIT_ADJUSTED');
110: FND_MESSAGE.SET_TOKEN('PROMOTION_NUMBER',l_modifier_name);
111: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
112: FND_MESSAGE.SET_TOKEN('OPERAND',l_original_modifier_value);
113: FND_MESSAGE.SET_TOKEN('PERCENT',p_operand_value);
114: FND_MESSAGE.SET_TOKEN('OPERATOR',l_operator_name);
115: l_message_text := FND_MESSAGE.GET;
108: IF (p_limit_level = 'H') THEN
109: FND_MESSAGE.SET_NAME('QP','QP_HEADER_LIMIT_ADJUSTED');
110: FND_MESSAGE.SET_TOKEN('PROMOTION_NUMBER',l_modifier_name);
111: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
112: FND_MESSAGE.SET_TOKEN('OPERAND',l_original_modifier_value);
113: FND_MESSAGE.SET_TOKEN('PERCENT',p_operand_value);
114: FND_MESSAGE.SET_TOKEN('OPERATOR',l_operator_name);
115: l_message_text := FND_MESSAGE.GET;
116: ELSIF (p_limit_level = 'L') THEN
109: FND_MESSAGE.SET_NAME('QP','QP_HEADER_LIMIT_ADJUSTED');
110: FND_MESSAGE.SET_TOKEN('PROMOTION_NUMBER',l_modifier_name);
111: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
112: FND_MESSAGE.SET_TOKEN('OPERAND',l_original_modifier_value);
113: FND_MESSAGE.SET_TOKEN('PERCENT',p_operand_value);
114: FND_MESSAGE.SET_TOKEN('OPERATOR',l_operator_name);
115: l_message_text := FND_MESSAGE.GET;
116: ELSIF (p_limit_level = 'L') THEN
117: FND_MESSAGE.SET_NAME('QP','QP_LINE_LIMIT_ADJUSTED');
110: FND_MESSAGE.SET_TOKEN('PROMOTION_NUMBER',l_modifier_name);
111: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
112: FND_MESSAGE.SET_TOKEN('OPERAND',l_original_modifier_value);
113: FND_MESSAGE.SET_TOKEN('PERCENT',p_operand_value);
114: FND_MESSAGE.SET_TOKEN('OPERATOR',l_operator_name);
115: l_message_text := FND_MESSAGE.GET;
116: ELSIF (p_limit_level = 'L') THEN
117: FND_MESSAGE.SET_NAME('QP','QP_LINE_LIMIT_ADJUSTED');
118: FND_MESSAGE.SET_TOKEN('MODIFIER_NUMBER',l_list_line_no);
111: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
112: FND_MESSAGE.SET_TOKEN('OPERAND',l_original_modifier_value);
113: FND_MESSAGE.SET_TOKEN('PERCENT',p_operand_value);
114: FND_MESSAGE.SET_TOKEN('OPERATOR',l_operator_name);
115: l_message_text := FND_MESSAGE.GET;
116: ELSIF (p_limit_level = 'L') THEN
117: FND_MESSAGE.SET_NAME('QP','QP_LINE_LIMIT_ADJUSTED');
118: FND_MESSAGE.SET_TOKEN('MODIFIER_NUMBER',l_list_line_no);
119: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
113: FND_MESSAGE.SET_TOKEN('PERCENT',p_operand_value);
114: FND_MESSAGE.SET_TOKEN('OPERATOR',l_operator_name);
115: l_message_text := FND_MESSAGE.GET;
116: ELSIF (p_limit_level = 'L') THEN
117: FND_MESSAGE.SET_NAME('QP','QP_LINE_LIMIT_ADJUSTED');
118: FND_MESSAGE.SET_TOKEN('MODIFIER_NUMBER',l_list_line_no);
119: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
120: FND_MESSAGE.SET_TOKEN('OPERAND',l_original_modifier_value);
121: FND_MESSAGE.SET_TOKEN('PERCENT',p_operand_value);
114: FND_MESSAGE.SET_TOKEN('OPERATOR',l_operator_name);
115: l_message_text := FND_MESSAGE.GET;
116: ELSIF (p_limit_level = 'L') THEN
117: FND_MESSAGE.SET_NAME('QP','QP_LINE_LIMIT_ADJUSTED');
118: FND_MESSAGE.SET_TOKEN('MODIFIER_NUMBER',l_list_line_no);
119: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
120: FND_MESSAGE.SET_TOKEN('OPERAND',l_original_modifier_value);
121: FND_MESSAGE.SET_TOKEN('PERCENT',p_operand_value);
122: FND_MESSAGE.SET_TOKEN('OPERATOR',l_operator_name);
115: l_message_text := FND_MESSAGE.GET;
116: ELSIF (p_limit_level = 'L') THEN
117: FND_MESSAGE.SET_NAME('QP','QP_LINE_LIMIT_ADJUSTED');
118: FND_MESSAGE.SET_TOKEN('MODIFIER_NUMBER',l_list_line_no);
119: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
120: FND_MESSAGE.SET_TOKEN('OPERAND',l_original_modifier_value);
121: FND_MESSAGE.SET_TOKEN('PERCENT',p_operand_value);
122: FND_MESSAGE.SET_TOKEN('OPERATOR',l_operator_name);
123: l_message_text := FND_MESSAGE.GET;
116: ELSIF (p_limit_level = 'L') THEN
117: FND_MESSAGE.SET_NAME('QP','QP_LINE_LIMIT_ADJUSTED');
118: FND_MESSAGE.SET_TOKEN('MODIFIER_NUMBER',l_list_line_no);
119: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
120: FND_MESSAGE.SET_TOKEN('OPERAND',l_original_modifier_value);
121: FND_MESSAGE.SET_TOKEN('PERCENT',p_operand_value);
122: FND_MESSAGE.SET_TOKEN('OPERATOR',l_operator_name);
123: l_message_text := FND_MESSAGE.GET;
124: END IF;
117: FND_MESSAGE.SET_NAME('QP','QP_LINE_LIMIT_ADJUSTED');
118: FND_MESSAGE.SET_TOKEN('MODIFIER_NUMBER',l_list_line_no);
119: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
120: FND_MESSAGE.SET_TOKEN('OPERAND',l_original_modifier_value);
121: FND_MESSAGE.SET_TOKEN('PERCENT',p_operand_value);
122: FND_MESSAGE.SET_TOKEN('OPERATOR',l_operator_name);
123: l_message_text := FND_MESSAGE.GET;
124: END IF;
125: END IF;
118: FND_MESSAGE.SET_TOKEN('MODIFIER_NUMBER',l_list_line_no);
119: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
120: FND_MESSAGE.SET_TOKEN('OPERAND',l_original_modifier_value);
121: FND_MESSAGE.SET_TOKEN('PERCENT',p_operand_value);
122: FND_MESSAGE.SET_TOKEN('OPERATOR',l_operator_name);
123: l_message_text := FND_MESSAGE.GET;
124: END IF;
125: END IF;
126:
119: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);
120: FND_MESSAGE.SET_TOKEN('OPERAND',l_original_modifier_value);
121: FND_MESSAGE.SET_TOKEN('PERCENT',p_operand_value);
122: FND_MESSAGE.SET_TOKEN('OPERATOR',l_operator_name);
123: l_message_text := FND_MESSAGE.GET;
124: END IF;
125: END IF;
126:
127: p_message_text := l_message_text;
503:
504: END IF;
505: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
506: THEN
507: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
508: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
509: l_message := FND_MESSAGE.GET;
510:
511: --Update the lines_tmp table with the translated error message.
504: END IF;
505: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
506: THEN
507: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
508: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
509: l_message := FND_MESSAGE.GET;
510:
511: --Update the lines_tmp table with the translated error message.
512: /*
505: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
506: THEN
507: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
508: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
509: l_message := FND_MESSAGE.GET;
510:
511: --Update the lines_tmp table with the translated error message.
512: /*
513: INDX,qp_limit_balance_check_pvt.recheck_balance.upd1,qp_npreq_lines_tmp_N1,LINE_INDEX,1
548:
549: END IF;
550: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
551: THEN
552: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
553: l_message := FND_MESSAGE.GET;
554:
555: --Update the lines_tmp table with the translated error message.
556: /*
549: END IF;
550: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
551: THEN
552: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
553: l_message := FND_MESSAGE.GET;
554:
555: --Update the lines_tmp table with the translated error message.
556: /*
557: INDX,qp_limit_balance_check_pvt.recheck_balance.upd3,qp_npreq_lines_tmp_N1,LINE_INDEX,1
630:
631: END IF;
632: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
633: THEN
634: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
635: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
636: l_message := FND_MESSAGE.GET;
637:
638: --Update the lines_tmp table with the translated error message.
631: END IF;
632: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
633: THEN
634: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
635: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
636: l_message := FND_MESSAGE.GET;
637:
638: --Update the lines_tmp table with the translated error message.
639: /*
632: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
633: THEN
634: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
635: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
636: l_message := FND_MESSAGE.GET;
637:
638: --Update the lines_tmp table with the translated error message.
639: /*
640: INDX,qp_limit_balance_check_pvt.recheck_balance.upd5,qp_npreq_lines_tmp_N1,LINE_INDEX,1
675:
676: END IF;
677: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
678: THEN
679: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
680: l_message := FND_MESSAGE.GET;
681:
682: --Update the lines_tmp table with the translated error message.
683: /*
676: END IF;
677: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
678: THEN
679: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
680: l_message := FND_MESSAGE.GET;
681:
682: --Update the lines_tmp table with the translated error message.
683: /*
684: INDX,qp_limit_balance_check_pvt.recheck_balance.upd7,qp_npreq_lines_tmp_N1,LINE_INDEX,1
998: WHEN E_ORDER_PRICE_REQ_CODE_NULL THEN
999:
1000: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1001: THEN
1002: FND_MESSAGE.SET_NAME('QP','QP_ORDER_PRICE_REQ_CODE_NULL');
1003: l_message := FND_MESSAGE.GET;
1004:
1005: --Update the lines_tmp table with the translated error message.
1006: /*
999:
1000: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1001: THEN
1002: FND_MESSAGE.SET_NAME('QP','QP_ORDER_PRICE_REQ_CODE_NULL');
1003: l_message := FND_MESSAGE.GET;
1004:
1005: --Update the lines_tmp table with the translated error message.
1006: /*
1007: INDX,qp_limit_balance_check_pvt.check_balance.upd9,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1037:
1038: END IF;
1039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1040: THEN
1041: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
1042: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
1043: l_message := FND_MESSAGE.GET;
1044:
1045: --Update the lines_tmp table with the translated error message.
1038: END IF;
1039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1040: THEN
1041: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
1042: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
1043: l_message := FND_MESSAGE.GET;
1044:
1045: --Update the lines_tmp table with the translated error message.
1046: /*
1039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1040: THEN
1041: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
1042: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
1043: l_message := FND_MESSAGE.GET;
1044:
1045: --Update the lines_tmp table with the translated error message.
1046: /*
1047: INDX,qp_limit_balance_check_pvt.check_balance.upd1,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1082:
1083: END IF;
1084: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1085: THEN
1086: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
1087: l_message := FND_MESSAGE.GET;
1088: l_message := substr(ltrim(rtrim(l_message))||l_message, 1, 2000);
1089: --Update the lines_tmp table with the translated error message.
1090: /*
1083: END IF;
1084: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1085: THEN
1086: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
1087: l_message := FND_MESSAGE.GET;
1088: l_message := substr(ltrim(rtrim(l_message))||l_message, 1, 2000);
1089: --Update the lines_tmp table with the translated error message.
1090: /*
1091: INDX,qp_limit_balance_check_pvt.check_balance.upd3,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1528: WHEN E_ORDER_PRICE_REQ_CODE_NULL THEN
1529:
1530: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1531: THEN
1532: FND_MESSAGE.SET_NAME('QP','QP_ORDER_PRICE_REQ_CODE_NULL');
1533: l_message := FND_MESSAGE.GET;
1534:
1535: --Update the lines_tmp table with the translated error message.
1536: /*
1529:
1530: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1531: THEN
1532: FND_MESSAGE.SET_NAME('QP','QP_ORDER_PRICE_REQ_CODE_NULL');
1533: l_message := FND_MESSAGE.GET;
1534:
1535: --Update the lines_tmp table with the translated error message.
1536: /*
1537: INDX,qp_limit_balance_check_pvt.check_balance.upd11,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1567:
1568: END IF;
1569: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1570: THEN
1571: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
1572: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
1573: l_message := FND_MESSAGE.GET;
1574:
1575: --Update the lines_tmp table with the translated error message.
1568: END IF;
1569: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1570: THEN
1571: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
1572: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
1573: l_message := FND_MESSAGE.GET;
1574:
1575: --Update the lines_tmp table with the translated error message.
1576: /*
1569: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1570: THEN
1571: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
1572: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
1573: l_message := FND_MESSAGE.GET;
1574:
1575: --Update the lines_tmp table with the translated error message.
1576: /*
1577: INDX,qp_limit_balance_check_pvt.check_balance.upd5,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1613:
1614: END IF;
1615: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1616: THEN
1617: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
1618: l_message := FND_MESSAGE.GET;
1619: l_message := substr(ltrim(rtrim(l_message))||l_message, 1, 2000);
1620:
1621: --Update the lines_tmp table with the translated error message.
1614: END IF;
1615: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1616: THEN
1617: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
1618: l_message := FND_MESSAGE.GET;
1619: l_message := substr(ltrim(rtrim(l_message))||l_message, 1, 2000);
1620:
1621: --Update the lines_tmp table with the translated error message.
1622: /*