DBA Data[Home] [Help]

APPS.QP_LIMIT_BALANCE_CHECK_PVT dependencies on FND_MESSAGE

Line 93: FND_MESSAGE.SET_NAME('QP','QP_HEADER_LIMIT_EXCEEDED');

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;

Line 94: FND_MESSAGE.SET_TOKEN('PROMOTION_NUMBER',l_modifier_name);

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

Line 95: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);

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');

Line 96: FND_MESSAGE.SET_TOKEN('LIMIT_EXCEEDED_BY',nvl(l_limit_exceeded_by,0));

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);

Line 97: l_message_text := FND_MESSAGE.GET;

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);

Line 99: FND_MESSAGE.SET_NAME('QP','QP_LINE_LIMIT_EXCEEDED');

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;

Line 100: FND_MESSAGE.SET_TOKEN('MODIFIER_NUMBER',l_list_line_no);

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;

Line 101: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);

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;

Line 102: FND_MESSAGE.SET_TOKEN('LIMIT_EXCEEDED_BY',nvl(l_limit_exceeded_by,0));

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:

Line 103: l_message_text := FND_MESSAGE.GET;

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

Line 109: FND_MESSAGE.SET_NAME('QP','QP_HEADER_LIMIT_ADJUSTED');

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);

Line 110: FND_MESSAGE.SET_TOKEN('PROMOTION_NUMBER',l_modifier_name);

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);

Line 111: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);

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;

Line 112: FND_MESSAGE.SET_TOKEN('OPERAND',l_original_modifier_value);

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

Line 113: FND_MESSAGE.SET_TOKEN('PERCENT',p_operand_value);

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');

Line 114: FND_MESSAGE.SET_TOKEN('OPERATOR',l_operator_name);

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);

Line 115: l_message_text := FND_MESSAGE.GET;

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);

Line 117: FND_MESSAGE.SET_NAME('QP','QP_LINE_LIMIT_ADJUSTED');

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);

Line 118: FND_MESSAGE.SET_TOKEN('MODIFIER_NUMBER',l_list_line_no);

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);

Line 119: FND_MESSAGE.SET_TOKEN('LIMIT_NUMBER',l_limit_number);

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;

Line 120: FND_MESSAGE.SET_TOKEN('OPERAND',l_original_modifier_value);

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;

Line 121: FND_MESSAGE.SET_TOKEN('PERCENT',p_operand_value);

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;

Line 122: FND_MESSAGE.SET_TOKEN('OPERATOR',l_operator_name);

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:

Line 123: l_message_text := FND_MESSAGE.GET;

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;

Line 507: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');

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.

Line 508: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);

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: /*

Line 509: l_message := FND_MESSAGE.GET;

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

Line 552: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');

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: /*

Line 553: l_message := FND_MESSAGE.GET;

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

Line 634: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');

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.

Line 635: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);

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: /*

Line 636: l_message := FND_MESSAGE.GET;

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

Line 679: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');

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: /*

Line 680: l_message := FND_MESSAGE.GET;

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

Line 1002: FND_MESSAGE.SET_NAME('QP','QP_ORDER_PRICE_REQ_CODE_NULL');

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: /*

Line 1003: l_message := FND_MESSAGE.GET;

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

Line 1041: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');

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.

Line 1042: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);

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: /*

Line 1043: l_message := FND_MESSAGE.GET;

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

Line 1086: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');

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: /*

Line 1087: l_message := FND_MESSAGE.GET;

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

Line 1532: FND_MESSAGE.SET_NAME('QP','QP_ORDER_PRICE_REQ_CODE_NULL');

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: /*

Line 1533: l_message := FND_MESSAGE.GET;

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

Line 1571: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');

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.

Line 1572: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);

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: /*

Line 1573: l_message := FND_MESSAGE.GET;

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

Line 1617: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');

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.

Line 1618: l_message := FND_MESSAGE.GET;

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: /*