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;
480:
481: END IF;
482: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
483: THEN
484: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
485: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
486: l_message := FND_MESSAGE.GET;
487:
488: --Update the lines_tmp table with the translated error message.
481: END IF;
482: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
483: THEN
484: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
485: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
486: l_message := FND_MESSAGE.GET;
487:
488: --Update the lines_tmp table with the translated error message.
489: /*
482: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
483: THEN
484: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
485: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
486: l_message := FND_MESSAGE.GET;
487:
488: --Update the lines_tmp table with the translated error message.
489: /*
490: INDX,qp_limit_balance_check_pvt.recheck_balance.upd1,qp_npreq_lines_tmp_N1,LINE_INDEX,1
525:
526: END IF;
527: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
528: THEN
529: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
530: l_message := FND_MESSAGE.GET;
531:
532: --Update the lines_tmp table with the translated error message.
533: /*
526: END IF;
527: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
528: THEN
529: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
530: l_message := FND_MESSAGE.GET;
531:
532: --Update the lines_tmp table with the translated error message.
533: /*
534: INDX,qp_limit_balance_check_pvt.recheck_balance.upd3,qp_npreq_lines_tmp_N1,LINE_INDEX,1
607:
608: END IF;
609: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
610: THEN
611: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
612: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
613: l_message := FND_MESSAGE.GET;
614:
615: --Update the lines_tmp table with the translated error message.
608: END IF;
609: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
610: THEN
611: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
612: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
613: l_message := FND_MESSAGE.GET;
614:
615: --Update the lines_tmp table with the translated error message.
616: /*
609: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
610: THEN
611: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
612: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
613: l_message := FND_MESSAGE.GET;
614:
615: --Update the lines_tmp table with the translated error message.
616: /*
617: INDX,qp_limit_balance_check_pvt.recheck_balance.upd5,qp_npreq_lines_tmp_N1,LINE_INDEX,1
652:
653: END IF;
654: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
655: THEN
656: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
657: l_message := FND_MESSAGE.GET;
658:
659: --Update the lines_tmp table with the translated error message.
660: /*
653: END IF;
654: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
655: THEN
656: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
657: l_message := FND_MESSAGE.GET;
658:
659: --Update the lines_tmp table with the translated error message.
660: /*
661: INDX,qp_limit_balance_check_pvt.recheck_balance.upd7,qp_npreq_lines_tmp_N1,LINE_INDEX,1
974: WHEN E_ORDER_PRICE_REQ_CODE_NULL THEN
975:
976: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
977: THEN
978: FND_MESSAGE.SET_NAME('QP','QP_ORDER_PRICE_REQ_CODE_NULL');
979: l_message := FND_MESSAGE.GET;
980:
981: --Update the lines_tmp table with the translated error message.
982: /*
975:
976: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
977: THEN
978: FND_MESSAGE.SET_NAME('QP','QP_ORDER_PRICE_REQ_CODE_NULL');
979: l_message := FND_MESSAGE.GET;
980:
981: --Update the lines_tmp table with the translated error message.
982: /*
983: INDX,qp_limit_balance_check_pvt.check_balance.upd9,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1013:
1014: END IF;
1015: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1016: THEN
1017: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
1018: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
1019: l_message := FND_MESSAGE.GET;
1020:
1021: --Update the lines_tmp table with the translated error message.
1014: END IF;
1015: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1016: THEN
1017: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
1018: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
1019: l_message := FND_MESSAGE.GET;
1020:
1021: --Update the lines_tmp table with the translated error message.
1022: /*
1015: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1016: THEN
1017: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
1018: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
1019: l_message := FND_MESSAGE.GET;
1020:
1021: --Update the lines_tmp table with the translated error message.
1022: /*
1023: INDX,qp_limit_balance_check_pvt.check_balance.upd1,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1058:
1059: END IF;
1060: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1061: THEN
1062: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
1063: l_message := FND_MESSAGE.GET;
1064: l_message := substr(ltrim(rtrim(l_message))||l_message, 1, 2000);
1065: --Update the lines_tmp table with the translated error message.
1066: /*
1059: END IF;
1060: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1061: THEN
1062: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
1063: l_message := FND_MESSAGE.GET;
1064: l_message := substr(ltrim(rtrim(l_message))||l_message, 1, 2000);
1065: --Update the lines_tmp table with the translated error message.
1066: /*
1067: INDX,qp_limit_balance_check_pvt.check_balance.upd3,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1502: WHEN E_ORDER_PRICE_REQ_CODE_NULL THEN
1503:
1504: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1505: THEN
1506: FND_MESSAGE.SET_NAME('QP','QP_ORDER_PRICE_REQ_CODE_NULL');
1507: l_message := FND_MESSAGE.GET;
1508:
1509: --Update the lines_tmp table with the translated error message.
1510: /*
1503:
1504: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1505: THEN
1506: FND_MESSAGE.SET_NAME('QP','QP_ORDER_PRICE_REQ_CODE_NULL');
1507: l_message := FND_MESSAGE.GET;
1508:
1509: --Update the lines_tmp table with the translated error message.
1510: /*
1511: INDX,qp_limit_balance_check_pvt.check_balance.upd11,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1541:
1542: END IF;
1543: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1544: THEN
1545: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
1546: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
1547: l_message := FND_MESSAGE.GET;
1548:
1549: --Update the lines_tmp table with the translated error message.
1542: END IF;
1543: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1544: THEN
1545: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
1546: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
1547: l_message := FND_MESSAGE.GET;
1548:
1549: --Update the lines_tmp table with the translated error message.
1550: /*
1543: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1544: THEN
1545: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
1546: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
1547: l_message := FND_MESSAGE.GET;
1548:
1549: --Update the lines_tmp table with the translated error message.
1550: /*
1551: INDX,qp_limit_balance_check_pvt.check_balance.upd5,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1587:
1588: END IF;
1589: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1590: THEN
1591: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
1592: l_message := FND_MESSAGE.GET;
1593: l_message := substr(ltrim(rtrim(l_message))||l_message, 1, 2000);
1594:
1595: --Update the lines_tmp table with the translated error message.
1588: END IF;
1589: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1590: THEN
1591: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
1592: l_message := FND_MESSAGE.GET;
1593: l_message := substr(ltrim(rtrim(l_message))||l_message, 1, 2000);
1594:
1595: --Update the lines_tmp table with the translated error message.
1596: /*