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.QP_LIMIT_BALANCE_CHECK_PVT dependencies on QP_PREQ_GRP

Line 31: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

27: l_limit_exceeded_by NUMBER;
28: l_original_modifier_value NUMBER := 0; --defined as number for bug 4912649 (10,2) := 0;
29: l_operator_name VARCHAR2(80);
30: BEGIN
31: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
32:
33: IF l_debug = FND_API.G_TRUE THEN
34: QP_PREQ_GRP.engine_debug('*** Entering Build_Message_Text ****');
35: QP_PREQ_GRP.engine_debug('Limit Level '||p_limit_level);

Line 34: QP_PREQ_GRP.engine_debug('* Entering Build_Message_Text **');

30: BEGIN
31: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
32:
33: IF l_debug = FND_API.G_TRUE THEN
34: QP_PREQ_GRP.engine_debug('*** Entering Build_Message_Text ****');
35: QP_PREQ_GRP.engine_debug('Limit Level '||p_limit_level);
36: END IF;
37:
38: IF p_limit_level = 'H' THEN

Line 35: QP_PREQ_GRP.engine_debug('Limit Level '||p_limit_level);

31: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
32:
33: IF l_debug = FND_API.G_TRUE THEN
34: QP_PREQ_GRP.engine_debug('*** Entering Build_Message_Text ****');
35: QP_PREQ_GRP.engine_debug('Limit Level '||p_limit_level);
36: END IF;
37:
38: IF p_limit_level = 'H' THEN
39: BEGIN

Line 45: QP_PREQ_GRP.engine_debug('* list header not found for id *' || p_List_Header_Id);

41: where list_header_id = p_List_Header_Id;
42: EXCEPTION
43: when no_data_found then
44: IF l_debug = FND_API.G_TRUE THEN
45: QP_PREQ_GRP.engine_debug('*** list header not found for id ***' || p_List_Header_Id);
46: END IF;
47: END;
48: END IF;
49:

Line 57: QP_PREQ_GRP.engine_debug('* list line not found for id *' || p_List_Line_Id);

53: where list_line_id = p_List_Line_Id;
54: EXCEPTION
55: when no_data_found then
56: IF l_debug = FND_API.G_TRUE THEN
57: QP_PREQ_GRP.engine_debug('*** list line not found for id ***' || p_List_Line_Id);
58: END IF;
59: END;
60: END IF;
61:

Line 68: QP_PREQ_GRP.engine_debug('* limit not found for id *'||p_Limit_Id);

64: where limit_id = p_Limit_Id;
65: EXCEPTION
66: when no_data_found then
67: IF l_debug = FND_API.G_TRUE THEN
68: QP_PREQ_GRP.engine_debug('*** limit not found for id ***'||p_Limit_Id);
69: END IF;
70: END;
71:
72: BEGIN

Line 78: QP_PREQ_GRP.engine_debug('* lookup code found *');

74: where LOOKUP_TYPE = 'ARITHMETIC_OPERATOR' and lookup_code = p_operand_calculation_code;
75: EXCEPTION
76: when no_data_found then
77: IF l_debug = FND_API.G_TRUE THEN
78: QP_PREQ_GRP.engine_debug('*** lookup code found ***');
79: END IF;
80: END;
81:
82: IF l_debug = FND_API.G_TRUE THEN

Line 83: QP_PREQ_GRP.engine_debug('######INSIDE BUILD_MESSAGE_TEXT######- ARITHMETIC_OPERATOR ' || p_operand_calculation_code);

79: END IF;
80: END;
81:
82: IF l_debug = FND_API.G_TRUE THEN
83: QP_PREQ_GRP.engine_debug('######INSIDE BUILD_MESSAGE_TEXT######- ARITHMETIC_OPERATOR ' || p_operand_calculation_code);
84:
85: QP_PREQ_GRP.engine_debug('######INSIDE BUILD_MESSAGE_TEXT######- ARITHMETIC_OPERATOR ' || l_operator_name);
86:
87: END IF;

Line 85: QP_PREQ_GRP.engine_debug('######INSIDE BUILD_MESSAGE_TEXT######- ARITHMETIC_OPERATOR ' || l_operator_name);

81:
82: IF l_debug = FND_API.G_TRUE THEN
83: QP_PREQ_GRP.engine_debug('######INSIDE BUILD_MESSAGE_TEXT######- ARITHMETIC_OPERATOR ' || p_operand_calculation_code);
84:
85: QP_PREQ_GRP.engine_debug('######INSIDE BUILD_MESSAGE_TEXT######- ARITHMETIC_OPERATOR ' || l_operator_name);
86:
87: END IF;
88: l_limit_exceeded_by := p_wanted_amount - p_full_available_amount;
89: l_original_modifier_value := (100 * p_operand_value)/p_least_percent;

Line 91: IF (p_limit_code = QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED) THEN

87: END IF;
88: l_limit_exceeded_by := p_wanted_amount - p_full_available_amount;
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);

Line 107: IF (p_limit_code = QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED) THEN

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

Line 130: QP_PREQ_GRP.engine_debug('* Leaving Build_Message_Text **');

126:
127: p_message_text := l_message_text;
128:
129: IF l_debug = FND_API.G_TRUE THEN
130: QP_PREQ_GRP.engine_debug('*** Leaving Build_Message_Text ****');
131: END IF;
132:
133: END Build_Message_Text;
134:

Line 147: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

143: e_balance_not_available EXCEPTION;
144: l_return_status VARCHAR2(1);
145:
146: BEGIN
147: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
148: IF l_debug = FND_API.G_TRUE THEN
149: QP_PREQ_GRP.engine_debug('------------------------');
150: QP_PREQ_GRP.engine_debug('***Begin Update_Balance***');
151:

Line 149: QP_PREQ_GRP.engine_debug('------------------------');

145:
146: BEGIN
147: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
148: IF l_debug = FND_API.G_TRUE THEN
149: QP_PREQ_GRP.engine_debug('------------------------');
150: QP_PREQ_GRP.engine_debug('***Begin Update_Balance***');
151:
152: END IF;
153: IF g_limit_balance_line.COUNT > 0 THEN

Line 150: QP_PREQ_GRP.engine_debug('Begin Update_Balance');

146: BEGIN
147: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
148: IF l_debug = FND_API.G_TRUE THEN
149: QP_PREQ_GRP.engine_debug('------------------------');
150: QP_PREQ_GRP.engine_debug('***Begin Update_Balance***');
151:
152: END IF;
153: IF g_limit_balance_line.COUNT > 0 THEN
154:

Line 159: QP_PREQ_GRP.engine_debug('Processing g_limit_balance_line ' || i);

155: --Get the minimum available_percent across all limitbalances for a given line
156: FOR i IN g_limit_balance_line.FIRST..g_limit_balance_line.LAST
157: LOOP
158: IF l_debug = FND_API.G_TRUE THEN
159: QP_PREQ_GRP.engine_debug('Processing g_limit_balance_line ' || i);
160:
161: END IF;
162: IF g_limit_balance_line(i).hard_limit_exceeded THEN
163: IF l_debug = FND_API.G_TRUE THEN

Line 164: QP_PREQ_GRP.engine_debug('Hard Limit with 0 balance encountered. ' ||

160:
161: END IF;
162: IF g_limit_balance_line(i).hard_limit_exceeded THEN
163: IF l_debug = FND_API.G_TRUE THEN
164: QP_PREQ_GRP.engine_debug('Hard Limit with 0 balance encountered. ' ||
165: 'Deleting all Balance lines for current list_line_id. ');
166: END IF;
167: g_limit_balance_line.DELETE; -- No need to process balances further
168: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 175: QP_PREQ_GRP.engine_debug('least percent so far' || l_percent);

171: END IF;
172:
173: l_percent := least(l_percent, g_limit_balance_line(i).available_percent);
174: IF l_debug = FND_API.G_TRUE THEN
175: QP_PREQ_GRP.engine_debug('least percent so far' || l_percent);
176: END IF;
177: END LOOP;
178:
179: --Perform Update or Insert into qp_limit_balances as required.

Line 183: QP_PREQ_GRP.engine_debug('Processing limit '||g_limit_balance_line(i).limit_id);

179: --Perform Update or Insert into qp_limit_balances as required.
180: FOR i IN g_limit_balance_line.FIRST..g_limit_balance_line.LAST
181: LOOP
182: IF l_debug = FND_API.G_TRUE THEN
183: QP_PREQ_GRP.engine_debug('Processing limit '||g_limit_balance_line(i).limit_id);
184:
185: QP_PREQ_GRP.engine_debug('Limit Level Code '||
186: g_limit_balance_line(i).limit_level_code);
187: QP_PREQ_GRP.engine_debug('Organization Context '||

Line 185: QP_PREQ_GRP.engine_debug('Limit Level Code '||

181: LOOP
182: IF l_debug = FND_API.G_TRUE THEN
183: QP_PREQ_GRP.engine_debug('Processing limit '||g_limit_balance_line(i).limit_id);
184:
185: QP_PREQ_GRP.engine_debug('Limit Level Code '||
186: g_limit_balance_line(i).limit_level_code);
187: QP_PREQ_GRP.engine_debug('Organization Context '||
188: g_limit_balance_line(i).organization_attr_context);
189: QP_PREQ_GRP.engine_debug('Organization Attribute '||

Line 187: QP_PREQ_GRP.engine_debug('Organization Context '||

183: QP_PREQ_GRP.engine_debug('Processing limit '||g_limit_balance_line(i).limit_id);
184:
185: QP_PREQ_GRP.engine_debug('Limit Level Code '||
186: g_limit_balance_line(i).limit_level_code);
187: QP_PREQ_GRP.engine_debug('Organization Context '||
188: g_limit_balance_line(i).organization_attr_context);
189: QP_PREQ_GRP.engine_debug('Organization Attribute '||
190: g_limit_balance_line(i).organization_attribute);
191: QP_PREQ_GRP.engine_debug('Organization Attr Value '||

Line 189: QP_PREQ_GRP.engine_debug('Organization Attribute '||

185: QP_PREQ_GRP.engine_debug('Limit Level Code '||
186: g_limit_balance_line(i).limit_level_code);
187: QP_PREQ_GRP.engine_debug('Organization Context '||
188: g_limit_balance_line(i).organization_attr_context);
189: QP_PREQ_GRP.engine_debug('Organization Attribute '||
190: g_limit_balance_line(i).organization_attribute);
191: QP_PREQ_GRP.engine_debug('Organization Attr Value '||
192: g_limit_balance_line(i).organization_attr_value);
193: QP_PREQ_GRP.engine_debug('Multival Attr1 Context '||

Line 191: QP_PREQ_GRP.engine_debug('Organization Attr Value '||

187: QP_PREQ_GRP.engine_debug('Organization Context '||
188: g_limit_balance_line(i).organization_attr_context);
189: QP_PREQ_GRP.engine_debug('Organization Attribute '||
190: g_limit_balance_line(i).organization_attribute);
191: QP_PREQ_GRP.engine_debug('Organization Attr Value '||
192: g_limit_balance_line(i).organization_attr_value);
193: QP_PREQ_GRP.engine_debug('Multival Attr1 Context '||
194: g_limit_balance_line(i).multival_attr1_context);
195: QP_PREQ_GRP.engine_debug('Multival Attribute1 '||

Line 193: QP_PREQ_GRP.engine_debug('Multival Attr1 Context '||

189: QP_PREQ_GRP.engine_debug('Organization Attribute '||
190: g_limit_balance_line(i).organization_attribute);
191: QP_PREQ_GRP.engine_debug('Organization Attr Value '||
192: g_limit_balance_line(i).organization_attr_value);
193: QP_PREQ_GRP.engine_debug('Multival Attr1 Context '||
194: g_limit_balance_line(i).multival_attr1_context);
195: QP_PREQ_GRP.engine_debug('Multival Attribute1 '||
196: g_limit_balance_line(i).multival_attribute1);
197: QP_PREQ_GRP.engine_debug('Multival Attr1 Value '||

Line 195: QP_PREQ_GRP.engine_debug('Multival Attribute1 '||

191: QP_PREQ_GRP.engine_debug('Organization Attr Value '||
192: g_limit_balance_line(i).organization_attr_value);
193: QP_PREQ_GRP.engine_debug('Multival Attr1 Context '||
194: g_limit_balance_line(i).multival_attr1_context);
195: QP_PREQ_GRP.engine_debug('Multival Attribute1 '||
196: g_limit_balance_line(i).multival_attribute1);
197: QP_PREQ_GRP.engine_debug('Multival Attr1 Value '||
198: g_limit_balance_line(i).multival_attr1_value);
199: QP_PREQ_GRP.engine_debug('Multival Attr2 Context '||

Line 197: QP_PREQ_GRP.engine_debug('Multival Attr1 Value '||

193: QP_PREQ_GRP.engine_debug('Multival Attr1 Context '||
194: g_limit_balance_line(i).multival_attr1_context);
195: QP_PREQ_GRP.engine_debug('Multival Attribute1 '||
196: g_limit_balance_line(i).multival_attribute1);
197: QP_PREQ_GRP.engine_debug('Multival Attr1 Value '||
198: g_limit_balance_line(i).multival_attr1_value);
199: QP_PREQ_GRP.engine_debug('Multival Attr2 Context '||
200: g_limit_balance_line(i).multival_attr2_context);
201: QP_PREQ_GRP.engine_debug('Multival Attribute2 '||

Line 199: QP_PREQ_GRP.engine_debug('Multival Attr2 Context '||

195: QP_PREQ_GRP.engine_debug('Multival Attribute1 '||
196: g_limit_balance_line(i).multival_attribute1);
197: QP_PREQ_GRP.engine_debug('Multival Attr1 Value '||
198: g_limit_balance_line(i).multival_attr1_value);
199: QP_PREQ_GRP.engine_debug('Multival Attr2 Context '||
200: g_limit_balance_line(i).multival_attr2_context);
201: QP_PREQ_GRP.engine_debug('Multival Attribute2 '||
202: g_limit_balance_line(i).multival_attribute2);
203: QP_PREQ_GRP.engine_debug('Multival Attr2 Value '||

Line 201: QP_PREQ_GRP.engine_debug('Multival Attribute2 '||

197: QP_PREQ_GRP.engine_debug('Multival Attr1 Value '||
198: g_limit_balance_line(i).multival_attr1_value);
199: QP_PREQ_GRP.engine_debug('Multival Attr2 Context '||
200: g_limit_balance_line(i).multival_attr2_context);
201: QP_PREQ_GRP.engine_debug('Multival Attribute2 '||
202: g_limit_balance_line(i).multival_attribute2);
203: QP_PREQ_GRP.engine_debug('Multival Attr2 Value '||
204: g_limit_balance_line(i).multival_attr2_value);
205: QP_PREQ_GRP.engine_debug('Balance Price Request Code '||

Line 203: QP_PREQ_GRP.engine_debug('Multival Attr2 Value '||

199: QP_PREQ_GRP.engine_debug('Multival Attr2 Context '||
200: g_limit_balance_line(i).multival_attr2_context);
201: QP_PREQ_GRP.engine_debug('Multival Attribute2 '||
202: g_limit_balance_line(i).multival_attribute2);
203: QP_PREQ_GRP.engine_debug('Multival Attr2 Value '||
204: g_limit_balance_line(i).multival_attr2_value);
205: QP_PREQ_GRP.engine_debug('Balance Price Request Code '||
206: g_limit_balance_line(i).bal_price_request_code);
207: QP_PREQ_GRP.engine_debug('Amount Given '||l_given_amount);

Line 205: QP_PREQ_GRP.engine_debug('Balance Price Request Code '||

201: QP_PREQ_GRP.engine_debug('Multival Attribute2 '||
202: g_limit_balance_line(i).multival_attribute2);
203: QP_PREQ_GRP.engine_debug('Multival Attr2 Value '||
204: g_limit_balance_line(i).multival_attr2_value);
205: QP_PREQ_GRP.engine_debug('Balance Price Request Code '||
206: g_limit_balance_line(i).bal_price_request_code);
207: QP_PREQ_GRP.engine_debug('Amount Given '||l_given_amount);
208: QP_PREQ_GRP.engine_debug('Limit Id '|| g_limit_balance_line(i).limit_id);
209: QP_PREQ_GRP.engine_debug('Limit Balance Id '||

Line 207: QP_PREQ_GRP.engine_debug('Amount Given '||l_given_amount);

203: QP_PREQ_GRP.engine_debug('Multival Attr2 Value '||
204: g_limit_balance_line(i).multival_attr2_value);
205: QP_PREQ_GRP.engine_debug('Balance Price Request Code '||
206: g_limit_balance_line(i).bal_price_request_code);
207: QP_PREQ_GRP.engine_debug('Amount Given '||l_given_amount);
208: QP_PREQ_GRP.engine_debug('Limit Id '|| g_limit_balance_line(i).limit_id);
209: QP_PREQ_GRP.engine_debug('Limit Balance Id '||
210: g_limit_balance_line(i).limit_balance_id);
211:

Line 208: QP_PREQ_GRP.engine_debug('Limit Id '|| g_limit_balance_line(i).limit_id);

204: g_limit_balance_line(i).multival_attr2_value);
205: QP_PREQ_GRP.engine_debug('Balance Price Request Code '||
206: g_limit_balance_line(i).bal_price_request_code);
207: QP_PREQ_GRP.engine_debug('Amount Given '||l_given_amount);
208: QP_PREQ_GRP.engine_debug('Limit Id '|| g_limit_balance_line(i).limit_id);
209: QP_PREQ_GRP.engine_debug('Limit Balance Id '||
210: g_limit_balance_line(i).limit_balance_id);
211:
212:

Line 209: QP_PREQ_GRP.engine_debug('Limit Balance Id '||

205: QP_PREQ_GRP.engine_debug('Balance Price Request Code '||
206: g_limit_balance_line(i).bal_price_request_code);
207: QP_PREQ_GRP.engine_debug('Amount Given '||l_given_amount);
208: QP_PREQ_GRP.engine_debug('Limit Id '|| g_limit_balance_line(i).limit_id);
209: QP_PREQ_GRP.engine_debug('Limit Balance Id '||
210: g_limit_balance_line(i).limit_balance_id);
211:
212:
213: END IF;

Line 219: QP_PREQ_GRP.engine_debug('Update Required');

215: l_given_amount := round((l_percent/100) * g_limit_balance_line(i).wanted_amount,2);
216:
217: IF g_limit_balance_line(i).process_action = g_update THEN
218: IF l_debug = FND_API.G_TRUE THEN
219: QP_PREQ_GRP.engine_debug('Update Required');
220:
221: END IF;
222: IF g_limit_balance_line(i).limit_level_code = 'ACROSS_TRANSACTION' THEN
223: /*

Line 287: QP_PREQ_GRP.engine_debug('Balance no longer available ');

283:
284: --Calculated Limit Balance no longer available. Raise error.
285: IF SQL%ROWCOUNT = 0 THEN
286: IF l_debug = FND_API.G_TRUE THEN
287: QP_PREQ_GRP.engine_debug('Balance no longer available ');
288: END IF;
289: RAISE E_BALANCE_NOT_AVAILABLE;
290: END IF;
291:

Line 294: QP_PREQ_GRP.engine_debug('Insert Required');

290: END IF;
291:
292: ELSIF g_limit_balance_line(i).process_action = g_insert THEN
293: IF l_debug = FND_API.G_TRUE THEN
294: QP_PREQ_GRP.engine_debug('Insert Required');
295:
296: QP_PREQ_GRP.engine_debug('given_amount '|| l_given_amount);
297: QP_PREQ_GRP.engine_debug('transaction_amount '||
298: nvl(g_limit_balance_line(i).transaction_amount, 0));

Line 296: QP_PREQ_GRP.engine_debug('given_amount '|| l_given_amount);

292: ELSIF g_limit_balance_line(i).process_action = g_insert THEN
293: IF l_debug = FND_API.G_TRUE THEN
294: QP_PREQ_GRP.engine_debug('Insert Required');
295:
296: QP_PREQ_GRP.engine_debug('given_amount '|| l_given_amount);
297: QP_PREQ_GRP.engine_debug('transaction_amount '||
298: nvl(g_limit_balance_line(i).transaction_amount, 0));
299:
300: END IF;

Line 297: QP_PREQ_GRP.engine_debug('transaction_amount '||

293: IF l_debug = FND_API.G_TRUE THEN
294: QP_PREQ_GRP.engine_debug('Insert Required');
295:
296: QP_PREQ_GRP.engine_debug('given_amount '|| l_given_amount);
297: QP_PREQ_GRP.engine_debug('transaction_amount '||
298: nvl(g_limit_balance_line(i).transaction_amount, 0));
299:
300: END IF;
301: INSERT INTO qp_limit_balances

Line 357: QP_PREQ_GRP.engine_debug('amount given'||l_given_amount);

353:
354: END IF;
355:
356: IF l_debug = FND_API.G_TRUE THEN
357: QP_PREQ_GRP.engine_debug('amount given'||l_given_amount);
358: END IF;
359: g_limit_balance_line(i).given_amount := l_given_amount;
360: g_limit_balance_line(i).least_percent := l_percent;
361:

Line 396: QP_PREQ_GRP.engine_debug('End Update_Balance');

392:
393: COMMIT;
394:
395: IF l_debug = FND_API.G_TRUE THEN
396: QP_PREQ_GRP.engine_debug('***End Update_Balance***');
397: QP_PREQ_GRP.engine_debug('------------------------');
398:
399: END IF;
400: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 397: QP_PREQ_GRP.engine_debug('------------------------');

393: COMMIT;
394:
395: IF l_debug = FND_API.G_TRUE THEN
396: QP_PREQ_GRP.engine_debug('***End Update_Balance***');
397: QP_PREQ_GRP.engine_debug('------------------------');
398:
399: END IF;
400: l_return_status := FND_API.G_RET_STS_SUCCESS;
401: x_return_text := 'Success';

Line 408: QP_PREQ_GRP.engine_debug('Insert Failed with Duplicate Value on Index');

404:
405: EXCEPTION
406: WHEN DUP_VAL_ON_INDEX THEN
407: IF l_debug = FND_API.G_TRUE THEN
408: QP_PREQ_GRP.engine_debug('Insert Failed with Duplicate Value on Index');
409: END IF;
410: l_return_status := FND_API.G_RET_STS_ERROR;
411: x_return_text := 'Insert Failed with Duplicate Value on Index error ' ||
412: 'in procedure Update_Balance';

Line 418: QP_PREQ_GRP.engine_debug('Limit Balance no longer available.Update Failed.');

414: RETURN l_return_status;
415:
416: WHEN E_BALANCE_NOT_AVAILABLE THEN
417: IF l_debug = FND_API.G_TRUE THEN
418: QP_PREQ_GRP.engine_debug('Limit Balance no longer available.Update Failed.');
419: END IF;
420: l_return_status := FND_API.G_RET_STS_ERROR;
421: x_return_text := 'Update Failed in procedure Update_Balance because ' ||
422: 'Limit Balance no longer available';

Line 428: QP_PREQ_GRP.engine_debug('Other Exception in Update_Balance');

424: RETURN l_return_status;
425:
426: WHEN OTHERS THEN
427: IF l_debug = FND_API.G_TRUE THEN
428: QP_PREQ_GRP.engine_debug('Other Exception in Update_Balance');
429: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
430: END IF;
431: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432: x_return_text := substr(sqlerrm, 1, 2000);

Line 429: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));

425:
426: WHEN OTHERS THEN
427: IF l_debug = FND_API.G_TRUE THEN
428: QP_PREQ_GRP.engine_debug('Other Exception in Update_Balance');
429: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
430: END IF;
431: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432: x_return_text := substr(sqlerrm, 1, 2000);
433: ROLLBACK;

Line 452: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

448: l_message VARCHAR2(240);
449:
450: BEGIN
451:
452: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
453: --Increment the recheck loop count everytime the Function is entered.
454: G_LOOP_COUNT := G_LOOP_COUNT + 1;
455:
456: IF l_debug = FND_API.G_TRUE THEN

Line 457: QP_PREQ_GRP.engine_debug('Begin Recheck_Balance');

453: --Increment the recheck loop count everytime the Function is entered.
454: G_LOOP_COUNT := G_LOOP_COUNT + 1;
455:
456: IF l_debug = FND_API.G_TRUE THEN
457: QP_PREQ_GRP.engine_debug('***Begin Recheck_Balance***');
458:
459: END IF;
460: IF g_limit_balance_line.COUNT > 0 THEN
461:

Line 466: QP_PREQ_GRP.engine_debug('Each attr does not exist');

462: FOR i IN g_limit_balance_line.FIRST..g_limit_balance_line.LAST
463: LOOP
464: IF g_limit_balance_line(i).each_attr_exists = 'N' THEN
465: IF l_debug = FND_API.G_TRUE THEN
466: QP_PREQ_GRP.engine_debug('Each attr does not exist');
467: END IF;
468: BEGIN
469:
470: IF g_limit_balance_line(i).limit_level_code = 'ACROSS_TRANSACTION' THEN

Line 502: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));

498: g_limit_balance_line(i).process_action := g_insert;
499:
500: WHEN TOO_MANY_ROWS THEN
501: IF l_debug = FND_API.G_TRUE THEN
502: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
503:
504: END IF;
505: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
506: THEN

Line 518: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

514: */
515: --sql statement upd1
516: UPDATE qp_npreq_lines_tmp
517: SET pricing_status_text = l_message,
518: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
519: WHERE line_index = g_limit_balance_line(i).line_index;
520:
521: --Update the ldets_tmp table with the translated error message.
522: /*

Line 529: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

525: */
526: --sql statement upd2
527: UPDATE qp_npreq_ldets_tmp
528: SET pricing_status_text = l_message,
529: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
530: WHERE line_index = g_limit_balance_line(i).line_index
531: AND created_from_list_line_id =
532: g_limit_balance_line(i).list_line_id;
533:

Line 535: QP_PREQ_GRP.engine_debug(l_message);

531: AND created_from_list_line_id =
532: g_limit_balance_line(i).list_line_id;
533:
534: IF l_debug = FND_API.G_TRUE THEN
535: QP_PREQ_GRP.engine_debug(l_message);
536:
537: END IF;
538: END IF;
539:

Line 547: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));

543: RAISE;
544:
545: WHEN OTHERS THEN
546: IF l_debug = FND_API.G_TRUE THEN
547: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
548:
549: END IF;
550: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
551: THEN

Line 562: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

558: */
559: --sql statement upd3
560: UPDATE qp_npreq_lines_tmp
561: SET pricing_status_text = l_message,
562: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
563: WHERE line_index = g_limit_balance_line(i).line_index;
564:
565: --Update the ldets_tmp table with the translated error message.
566: /*

Line 573: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

569: */
570: --sql statement upd4
571: UPDATE qp_npreq_ldets_tmp
572: SET pricing_status_text = l_message,
573: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
574: WHERE line_index = g_limit_balance_line(i).line_index
575: AND created_from_list_line_id =
576: g_limit_balance_line(i).list_line_id;
577:

Line 579: QP_PREQ_GRP.engine_debug(l_message);

575: AND created_from_list_line_id =
576: g_limit_balance_line(i).list_line_id;
577:
578: IF l_debug = FND_API.G_TRUE THEN
579: QP_PREQ_GRP.engine_debug(l_message);
580:
581: END IF;
582: END IF;
583:

Line 593: QP_PREQ_GRP.engine_debug('Each attr exists');

589: END;--End of Block around Select Stmt when limit does not have each attrs
590:
591: ELSIF g_limit_balance_line(i).each_attr_exists = 'Y' THEN
592: IF l_debug = FND_API.G_TRUE THEN
593: QP_PREQ_GRP.engine_debug('Each attr exists');
594: END IF;
595: BEGIN
596:
597: IF g_limit_balance_line(i).limit_level_code = 'ACROSS_TRANSACTION' THEN

Line 629: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));

625: g_limit_balance_line(i).process_action := g_insert;
626:
627: WHEN TOO_MANY_ROWS THEN
628: IF l_debug = FND_API.G_TRUE THEN
629: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
630:
631: END IF;
632: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
633: THEN

Line 645: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

641: */
642: --sql statement upd5
643: UPDATE qp_npreq_lines_tmp
644: SET pricing_status_text = l_message,
645: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
646: WHERE line_index = g_limit_balance_line(i).line_index;
647:
648: --Update the ldets_tmp table with the translated error message.
649: /*

Line 656: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

652: */
653: --sql statement upd6
654: UPDATE qp_npreq_ldets_tmp
655: SET pricing_status_text = l_message,
656: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
657: WHERE line_index = g_limit_balance_line(i).line_index
658: AND created_from_list_line_id =
659: g_limit_balance_line(i).list_line_id;
660:

Line 662: QP_PREQ_GRP.engine_debug(l_message);

658: AND created_from_list_line_id =
659: g_limit_balance_line(i).list_line_id;
660:
661: IF l_debug = FND_API.G_TRUE THEN
662: QP_PREQ_GRP.engine_debug(l_message);
663:
664: END IF;
665: END IF;
666:

Line 674: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));

670: RAISE;
671:
672: WHEN OTHERS THEN
673: IF l_debug = FND_API.G_TRUE THEN
674: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
675:
676: END IF;
677: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
678: THEN

Line 689: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

685: */
686: --sql statement upd7
687: UPDATE qp_npreq_lines_tmp
688: SET pricing_status_text = l_message,
689: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
690: WHERE line_index = g_limit_balance_line(i).line_index;
691:
692: --Update the ldets_tmp table with the translated error message.
693: /*

Line 700: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

696: */
697: --sql statement upd8
698: UPDATE qp_npreq_ldets_tmp
699: SET pricing_status_text = l_message,
700: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
701: WHERE line_index = g_limit_balance_line(i).line_index
702: AND created_from_list_line_id =
703: g_limit_balance_line(i).list_line_id;
704:

Line 706: QP_PREQ_GRP.engine_debug(l_message);

702: AND created_from_list_line_id =
703: g_limit_balance_line(i).list_line_id;
704:
705: IF l_debug = FND_API.G_TRUE THEN
706: QP_PREQ_GRP.engine_debug(l_message);
707:
708: END IF;
709: END IF;
710:

Line 721: QP_PREQ_GRP.engine_debug('Action to take '||g_limit_balance_line(i).process_action);

717:
718: END IF; --If each_attr_exists
719:
720: IF l_debug = FND_API.G_TRUE THEN
721: QP_PREQ_GRP.engine_debug('Action to take '||g_limit_balance_line(i).process_action);
722:
723: END IF;
724: --Check the Limit Transaction Table to see if the same request has a
725: --record. If so, this is a repricing request so populate the

Line 771: QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED;

767:
768: --10023220
769: IF g_limit_balance_line(i).wanted_amount > l_full_available_amount AND ((g_limit_balance_line(i).wanted_amount - l_full_available_amount) NOT BETWEEN 0 AND 0.1 ) THEN
770: g_limit_balance_line(i).limit_code :=
771: QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED;
772: ELSE
773: g_limit_balance_line(i).limit_code :=
774: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;
775: END IF; --if p_wanted_amount > l_full_available_amount

Line 774: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;

770: g_limit_balance_line(i).limit_code :=
771: QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED;
772: ELSE
773: g_limit_balance_line(i).limit_code :=
774: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;
775: END IF; --if p_wanted_amount > l_full_available_amount
776:
777: ELSE --Soft Limit
778:

Line 785: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;

781:
782: IF g_limit_balance_line(i).line_category = 'RETURN' THEN
783:
784: g_limit_balance_line(i).limit_code :=
785: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;
786:
787: ELSE --If line_category is not 'RETURN'
788:
789: IF g_limit_balance_line(i).wanted_amount > l_full_available_amount

Line 792: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED;

788:
789: IF g_limit_balance_line(i).wanted_amount > l_full_available_amount
790: THEN
791: g_limit_balance_line(i).limit_code :=
792: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED;
793: ELSE
794: g_limit_balance_line(i).limit_code :=
795: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;
796: END IF; --If wanted_amount > l_full_available_amount

Line 795: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;

791: g_limit_balance_line(i).limit_code :=
792: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED;
793: ELSE
794: g_limit_balance_line(i).limit_code :=
795: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;
796: END IF; --If wanted_amount > l_full_available_amount
797:
798: END IF;--If line_category is 'RETURN'
799:

Line 818: QP_PREQ_GRP.engine_debug('End Recheck_Balance');

814:
815: END IF; --g_limit_balance_line.COUNT > 0
816:
817: IF l_debug = FND_API.G_TRUE THEN
818: QP_PREQ_GRP.engine_debug('***End Recheck_Balance***');
819:
820: END IF;
821: EXCEPTION
822: WHEN OTHERS THEN

Line 824: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));

820: END IF;
821: EXCEPTION
822: WHEN OTHERS THEN
823: IF l_debug = FND_API.G_TRUE THEN
824: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
825: END IF;
826: RETURN FALSE;
827: END Recheck_Balance;
828:

Line 860: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED;

856: FROM qp_npreq_line_attrs_tmp
857: WHERE line_index = a_line_index
858: AND context = a_context
859: AND attribute = a_attribute
860: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED;
861:
862: TYPE each_attr_rec_type IS RECORD
863: (context VARCHAR2(30),
864: attribute VARCHAR2(30),

Line 883: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

879: E_ORDER_PRICE_REQ_CODE_NULL EXCEPTION;
880:
881: BEGIN
882:
883: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
884: IF l_debug = FND_API.G_TRUE THEN
885: QP_PREQ_GRP.engine_debug('***Begin Check_Balance***');
886: END IF;
887: IF g_Limit_balance_line.COUNT = 0 THEN

Line 885: QP_PREQ_GRP.engine_debug('Begin Check_Balance');

881: BEGIN
882:
883: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
884: IF l_debug = FND_API.G_TRUE THEN
885: QP_PREQ_GRP.engine_debug('***Begin Check_Balance***');
886: END IF;
887: IF g_Limit_balance_line.COUNT = 0 THEN
888: i:=1;
889: ELSE

Line 895: QP_PREQ_GRP.engine_debug('populating limit_balance_line '||i);

891: END IF;
892: x_skip_limit := FALSE;
893:
894: IF l_debug = FND_API.G_TRUE THEN
895: QP_PREQ_GRP.engine_debug('populating limit_balance_line '||i);
896: QP_PREQ_GRP.engine_debug('limit_id '||p_limit_rec.limit_id);
897:
898: END IF;
899: IF p_limit_rec.each_attr_exists = 'N' THEN

Line 896: QP_PREQ_GRP.engine_debug('limit_id '||p_limit_rec.limit_id);

892: x_skip_limit := FALSE;
893:
894: IF l_debug = FND_API.G_TRUE THEN
895: QP_PREQ_GRP.engine_debug('populating limit_balance_line '||i);
896: QP_PREQ_GRP.engine_debug('limit_id '||p_limit_rec.limit_id);
897:
898: END IF;
899: IF p_limit_rec.each_attr_exists = 'N' THEN
900: --If limit has no each (pure non-each) or no attributes

Line 903: QP_PREQ_GRP.engine_debug('No Each-type attributes defined for this limit');

899: IF p_limit_rec.each_attr_exists = 'N' THEN
900: --If limit has no each (pure non-each) or no attributes
901: --(For such cases a balance record will always exist since setup creates one)
902: IF l_debug = FND_API.G_TRUE THEN
903: QP_PREQ_GRP.engine_debug('No Each-type attributes defined for this limit');
904:
905: END IF;
906: g_limit_balance_line(i).limit_id := p_limit_rec.limit_id;
907: g_limit_balance_line(i).line_index := p_limit_rec.line_index;

Line 934: QP_PREQ_GRP.G_ORDER_PRICE_REQUEST_CODE;

930: IF p_limit_rec.limit_level_code = 'ACROSS_TRANSACTION' THEN
931: g_limit_balance_line(i).bal_price_request_code := NULL;
932: ELSIF p_limit_rec.limit_level_code = 'TRANSACTION' THEN
933: g_limit_balance_line(i).bal_price_request_code :=
934: QP_PREQ_GRP.G_ORDER_PRICE_REQUEST_CODE;
935: END IF; --If limit_level_code = 'ACROSS_TRANSACTION'
936: IF l_debug = FND_API.G_TRUE THEN
937: QP_PREQ_GRP.engine_debug('bal_price_request_code '||
938: g_limit_balance_line(i).bal_price_request_code);

Line 937: QP_PREQ_GRP.engine_debug('bal_price_request_code '||

933: g_limit_balance_line(i).bal_price_request_code :=
934: QP_PREQ_GRP.G_ORDER_PRICE_REQUEST_CODE;
935: END IF; --If limit_level_code = 'ACROSS_TRANSACTION'
936: IF l_debug = FND_API.G_TRUE THEN
937: QP_PREQ_GRP.engine_debug('bal_price_request_code '||
938: g_limit_balance_line(i).bal_price_request_code);
939: END IF;
940: --Populate price_request_code from limits_cur for limit_transns table
941: g_limit_balance_line(i).price_request_code :=

Line 968: IF QP_PREQ_GRP.G_ORDER_PRICE_REQUEST_CODE IS NULL THEN

964: INDX,qp_limit_balance_check_pvt.check_balance.sel2,QP_LIMIT_BALANCES_N1,PRICE_REQUEST_CODE,2
965: */
966:
967: --If g_order_price_request_code is null then raise an error.
968: IF QP_PREQ_GRP.G_ORDER_PRICE_REQUEST_CODE IS NULL THEN
969: RAISE E_ORDER_PRICE_REQ_CODE_NULL;
970: END IF;
971:
972: --sql statement sel2

Line 985: QP_PREQ_GRP.engine_debug('Available Balance '|| l_full_available_amount);

981:
982: g_limit_balance_line(i).process_action := g_update;
983:
984: IF l_debug = FND_API.G_TRUE THEN
985: QP_PREQ_GRP.engine_debug('Available Balance '|| l_full_available_amount);
986:
987: END IF;
988: EXCEPTION
989: WHEN NO_DATA_FOUND THEN

Line 995: QP_PREQ_GRP.engine_debug('Balance Record Missing');

991: into g_limit_balance_line(i).limit_balance_id from dual;
992: l_full_available_amount := p_limit_rec.amount;
993: g_limit_balance_line(i).process_action := g_insert;
994: IF l_debug = FND_API.G_TRUE THEN
995: QP_PREQ_GRP.engine_debug('Balance Record Missing');
996:
997: END IF;
998: WHEN E_ORDER_PRICE_REQ_CODE_NULL THEN
999:

Line 1012: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

1008: */
1009: --sql statement upd9
1010: UPDATE qp_npreq_lines_tmp
1011: SET pricing_status_text = l_message,
1012: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1013: WHERE line_index = g_limit_balance_line(i).line_index;
1014:
1015: --Update the ldets_tmp table with the translated error message.
1016: /*

Line 1023: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

1019: */
1020: --sql statement upd10
1021: UPDATE qp_npreq_ldets_tmp
1022: SET pricing_status_text = l_message,
1023: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1024: WHERE line_index = g_limit_balance_line(i).line_index
1025: AND created_from_list_line_id =
1026: g_limit_balance_line(i).list_line_id;
1027:

Line 1029: QP_PREQ_GRP.engine_debug(l_message);

1025: AND created_from_list_line_id =
1026: g_limit_balance_line(i).list_line_id;
1027:
1028: IF l_debug = FND_API.G_TRUE THEN
1029: QP_PREQ_GRP.engine_debug(l_message);
1030:
1031: END IF;
1032: END IF;
1033:

Line 1036: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));

1032: END IF;
1033:
1034: WHEN TOO_MANY_ROWS THEN
1035: IF l_debug = FND_API.G_TRUE THEN
1036: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
1037:
1038: END IF;
1039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1040: THEN

Line 1052: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

1048: */
1049: --sql statement upd1
1050: UPDATE qp_npreq_lines_tmp
1051: SET pricing_status_text = l_message,
1052: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1053: WHERE line_index = g_limit_balance_line(i).line_index;
1054:
1055: --Update the ldets_tmp table with the translated error message.
1056: /*

Line 1063: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

1059: */
1060: --sql statement upd2
1061: UPDATE qp_npreq_ldets_tmp
1062: SET pricing_status_text = l_message,
1063: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1064: WHERE line_index = g_limit_balance_line(i).line_index
1065: AND created_from_list_line_id =
1066: g_limit_balance_line(i).list_line_id;
1067:

Line 1069: QP_PREQ_GRP.engine_debug(l_message);

1065: AND created_from_list_line_id =
1066: g_limit_balance_line(i).list_line_id;
1067:
1068: IF l_debug = FND_API.G_TRUE THEN
1069: QP_PREQ_GRP.engine_debug(l_message);
1070:
1071: END IF;
1072: END IF;
1073:

Line 1081: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));

1077: RAISE;
1078:
1079: WHEN OTHERS THEN
1080: IF l_debug = FND_API.G_TRUE THEN
1081: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
1082:
1083: END IF;
1084: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1085: THEN

Line 1096: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

1092: */
1093: --sql statement upd3
1094: UPDATE qp_npreq_lines_tmp
1095: SET pricing_status_text = l_message,
1096: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1097: WHERE line_index = g_limit_balance_line(i).line_index;
1098:
1099: --Update the ldets_tmp table with the translated error message.
1100: /*

Line 1107: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

1103: */
1104: --sql statement upd4
1105: UPDATE qp_npreq_ldets_tmp
1106: SET pricing_status_text = l_message,
1107: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1108: WHERE line_index = g_limit_balance_line(i).line_index
1109: AND created_from_list_line_id =
1110: g_limit_balance_line(i).list_line_id;
1111:

Line 1113: QP_PREQ_GRP.engine_debug(l_message);

1109: AND created_from_list_line_id =
1110: g_limit_balance_line(i).list_line_id;
1111:
1112: IF l_debug = FND_API.G_TRUE THEN
1113: QP_PREQ_GRP.engine_debug(l_message);
1114:
1115: END IF;
1116: END IF;
1117:

Line 1173: QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED;

1169:
1170: --10023220
1171: IF p_wanted_amount > l_full_available_amount AND ((p_wanted_amount - l_full_available_amount) NOT BETWEEN 0 AND 0.1 )THEN
1172: g_limit_balance_line(i).limit_code :=
1173: QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED;
1174: ELSE
1175: g_limit_balance_line(i).limit_code :=
1176: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;
1177: END IF; --if p_wanted_amount > l_full_available_amount

Line 1176: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;

1172: g_limit_balance_line(i).limit_code :=
1173: QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED;
1174: ELSE
1175: g_limit_balance_line(i).limit_code :=
1176: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;
1177: END IF; --if p_wanted_amount > l_full_available_amount
1178:
1179: ELSE --Soft Limit
1180:

Line 1186: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;

1182:
1183: IF g_limit_balance_line(i).line_category = 'RETURN' THEN
1184:
1185: g_limit_balance_line(i).limit_code :=
1186: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;
1187:
1188: ELSE--If line_category is not 'RETURN'
1189:
1190: IF p_wanted_amount > l_full_available_amount

Line 1193: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED;

1189:
1190: IF p_wanted_amount > l_full_available_amount
1191: THEN
1192: g_limit_balance_line(i).limit_code :=
1193: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED;
1194: ELSE
1195: g_limit_balance_line(i).limit_code :=
1196: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;
1197: END IF; --If wanted_amount > l_full_available_amount

Line 1196: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;

1192: g_limit_balance_line(i).limit_code :=
1193: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED;
1194: ELSE
1195: g_limit_balance_line(i).limit_code :=
1196: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;
1197: END IF; --If wanted_amount > l_full_available_amount
1198:
1199: END IF;--If line_category is 'RETURN'
1200:

Line 1204: QP_PREQ_GRP.engine_debug('p_wanted_amount '||p_wanted_amount);

1200:
1201: END IF; --If limit_exceed_action_code = 'HARD'
1202:
1203: IF l_debug = FND_API.G_TRUE THEN
1204: QP_PREQ_GRP.engine_debug('p_wanted_amount '||p_wanted_amount);
1205: QP_PREQ_GRP.engine_debug('available_amount '||
1206: g_limit_balance_line(i).available_amount);
1207:
1208: END IF;

Line 1205: QP_PREQ_GRP.engine_debug('available_amount '||

1201: END IF; --If limit_exceed_action_code = 'HARD'
1202:
1203: IF l_debug = FND_API.G_TRUE THEN
1204: QP_PREQ_GRP.engine_debug('p_wanted_amount '||p_wanted_amount);
1205: QP_PREQ_GRP.engine_debug('available_amount '||
1206: g_limit_balance_line(i).available_amount);
1207:
1208: END IF;
1209: IF p_wanted_amount <> 0 THEN

Line 1217: QP_PREQ_GRP.engine_debug('available_percent '||

1213: g_limit_balance_line(i).available_percent := 100;
1214: END IF;
1215:
1216: IF l_debug = FND_API.G_TRUE THEN
1217: QP_PREQ_GRP.engine_debug('available_percent '||
1218: g_limit_balance_line(i).available_percent);
1219: END IF;
1220:
1221: g_limit_balance_line(i).hard_limit_exceeded := FALSE;

Line 1223: QP_PREQ_GRP.engine_debug('End Check_Balance');

1219: END IF;
1220:
1221: g_limit_balance_line(i).hard_limit_exceeded := FALSE;
1222: IF l_debug = FND_API.G_TRUE THEN
1223: QP_PREQ_GRP.engine_debug('***End Check_Balance***');
1224: END IF;
1225: RETURN TRUE;
1226:
1227: ELSIF p_limit_rec.each_attr_exists = 'Y' THEN

Line 1231: QP_PREQ_GRP.engine_debug('Each-type attributes defined for this limit');

1227: ELSIF p_limit_rec.each_attr_exists = 'Y' THEN
1228: --Mixed case where both Each and Non-Each Attributes exist for the limit
1229: --and pure Each case
1230: IF l_debug = FND_API.G_TRUE THEN
1231: QP_PREQ_GRP.engine_debug('Each-type attributes defined for this limit');
1232: END IF;
1233:
1234: --Fetch all the org, customer and item type context,attribute and value
1235: --combinations for the current list_line from the request line attrs table.

Line 1267: QP_PREQ_GRP.engine_debug('Organization Attr Count '|| l_org_table.count);

1263: i3 := i3+1;
1264: END LOOP;
1265:
1266: IF l_debug = FND_API.G_TRUE THEN
1267: QP_PREQ_GRP.engine_debug('Organization Attr Count '|| l_org_table.count);
1268: QP_PREQ_GRP.engine_debug('Attribute1 Count '|| l_cust_table.count);
1269: QP_PREQ_GRP.engine_debug('Attribute2 Count '|| l_item_table.count);
1270:
1271: END IF;

Line 1268: QP_PREQ_GRP.engine_debug('Attribute1 Count '|| l_cust_table.count);

1264: END LOOP;
1265:
1266: IF l_debug = FND_API.G_TRUE THEN
1267: QP_PREQ_GRP.engine_debug('Organization Attr Count '|| l_org_table.count);
1268: QP_PREQ_GRP.engine_debug('Attribute1 Count '|| l_cust_table.count);
1269: QP_PREQ_GRP.engine_debug('Attribute2 Count '|| l_item_table.count);
1270:
1271: END IF;
1272: --If for any of org, customer and item limit attribute setup for 'EACH'

Line 1269: QP_PREQ_GRP.engine_debug('Attribute2 Count '|| l_item_table.count);

1265:
1266: IF l_debug = FND_API.G_TRUE THEN
1267: QP_PREQ_GRP.engine_debug('Organization Attr Count '|| l_org_table.count);
1268: QP_PREQ_GRP.engine_debug('Attribute1 Count '|| l_cust_table.count);
1269: QP_PREQ_GRP.engine_debug('Attribute2 Count '|| l_item_table.count);
1270:
1271: END IF;
1272: --If for any of org, customer and item limit attribute setup for 'EACH'
1273: --value doesn't have any corresponding records from the request attrs table

Line 1283: QP_PREQ_GRP.engine_debug('Skipping Limit '|| p_limit_rec.limit_id);

1279: OR p_limit_rec.multival_attr2_context <> 'NA' AND
1280: l_item_table.COUNT = 0
1281: THEN
1282: IF l_debug = FND_API.G_TRUE THEN
1283: QP_PREQ_GRP.engine_debug('Skipping Limit '|| p_limit_rec.limit_id);
1284: END IF;
1285: x_skip_limit := TRUE;
1286: RETURN TRUE;
1287: END IF;

Line 1353: QP_PREQ_GRP.G_ORDER_PRICE_REQUEST_CODE;

1349: IF p_limit_rec.limit_level_code = 'ACROSS_TRANSACTION' THEN
1350: g_limit_balance_line(i).bal_price_request_code := NULL;
1351: ELSIF p_limit_rec.limit_level_code = 'TRANSACTION' THEN
1352: g_limit_balance_line(i).bal_price_request_code :=
1353: QP_PREQ_GRP.G_ORDER_PRICE_REQUEST_CODE;
1354: END IF;--If limit_level_code = 'ACROSS_TRANSACTION'
1355: IF l_debug = FND_API.G_TRUE THEN
1356: QP_PREQ_GRP.engine_debug('bal_price_request_code '||
1357: g_limit_balance_line(i).bal_price_request_code);

Line 1356: QP_PREQ_GRP.engine_debug('bal_price_request_code '||

1352: g_limit_balance_line(i).bal_price_request_code :=
1353: QP_PREQ_GRP.G_ORDER_PRICE_REQUEST_CODE;
1354: END IF;--If limit_level_code = 'ACROSS_TRANSACTION'
1355: IF l_debug = FND_API.G_TRUE THEN
1356: QP_PREQ_GRP.engine_debug('bal_price_request_code '||
1357: g_limit_balance_line(i).bal_price_request_code);
1358: END IF;
1359: --Populate price_request_code for limit_transactions table
1360: g_limit_balance_line(i).price_request_code :=

Line 1440: IF QP_PREQ_GRP.G_ORDER_PRICE_REQUEST_CODE IS NULL THEN

1436: INDX,qp_limit_balance_check_pvt.check_balance.sel5,QP_LIMIT_BALANCES_U2,MULTIVAL_ATTR2_VALUE,10
1437: INDX,qp_limit_balance_check_pvt.check_balance.sel5,QP_LIMIT_BALANCES_U2,PRICE_REQUEST_CODE,11
1438: */
1439: --If g_order_price_request_code is null then raise an error.
1440: IF QP_PREQ_GRP.G_ORDER_PRICE_REQUEST_CODE IS NULL THEN
1441: RAISE E_ORDER_PRICE_REQ_CODE_NULL;
1442: END IF;
1443:
1444: --sql statement sel5

Line 1488: QP_PREQ_GRP.engine_debug('Available Balance '|| l_full_available_amount);

1484:
1485: g_limit_balance_line(i).process_action := g_update;
1486:
1487: IF l_debug = FND_API.G_TRUE THEN
1488: QP_PREQ_GRP.engine_debug('Available Balance '|| l_full_available_amount);
1489: END IF;
1490: EXCEPTION
1491: WHEN NO_DATA_FOUND THEN
1492:

Line 1542: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

1538: */
1539: --sql statement upd11
1540: UPDATE qp_npreq_lines_tmp
1541: SET pricing_status_text = l_message,
1542: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1543: WHERE line_index = g_limit_balance_line(i).line_index;
1544:
1545: --Update the ldets_tmp table with the translated error message.
1546: /*

Line 1553: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

1549: */
1550: --sql statement upd12
1551: UPDATE qp_npreq_ldets_tmp
1552: SET pricing_status_text = l_message,
1553: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1554: WHERE line_index = g_limit_balance_line(i).line_index
1555: AND created_from_list_line_id =
1556: g_limit_balance_line(i).list_line_id;
1557:

Line 1559: QP_PREQ_GRP.engine_debug(l_message);

1555: AND created_from_list_line_id =
1556: g_limit_balance_line(i).list_line_id;
1557:
1558: IF l_debug = FND_API.G_TRUE THEN
1559: QP_PREQ_GRP.engine_debug(l_message);
1560:
1561: END IF;
1562: END IF;
1563:

Line 1566: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));

1562: END IF;
1563:
1564: WHEN TOO_MANY_ROWS THEN
1565: IF l_debug = FND_API.G_TRUE THEN
1566: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
1567:
1568: END IF;
1569: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1570: THEN

Line 1582: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

1578: */
1579: --sql statement upd5
1580: UPDATE qp_npreq_lines_tmp
1581: SET pricing_status_text = l_message,
1582: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1583: WHERE line_index = g_limit_balance_line(i).line_index;
1584:
1585: --Update the ldets_tmp table with the translated error message.
1586: /*

Line 1594: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

1590: --sql statement upd6
1591: UPDATE qp_npreq_ldets_tmp
1592: SET pricing_status_text = l_message,
1593: pricing_status_code =
1594: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1595: WHERE line_index = g_limit_balance_line(i).line_index
1596: AND created_from_list_line_id =
1597: g_limit_balance_line(i).list_line_id;
1598:

Line 1600: QP_PREQ_GRP.engine_debug(l_message);

1596: AND created_from_list_line_id =
1597: g_limit_balance_line(i).list_line_id;
1598:
1599: IF l_debug = FND_API.G_TRUE THEN
1600: QP_PREQ_GRP.engine_debug(l_message);
1601:
1602: END IF;
1603: END IF;
1604:

Line 1612: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));

1608: RAISE;
1609:
1610: WHEN OTHERS THEN
1611: IF l_debug = FND_API.G_TRUE THEN
1612: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
1613:
1614: END IF;
1615: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1616: THEN

Line 1628: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

1624: */
1625: --sql statement upd7
1626: UPDATE qp_npreq_lines_tmp
1627: SET pricing_status_text = l_message,
1628: pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1629: WHERE line_index = g_limit_balance_line(i).line_index;
1630:
1631: --Update the ldets_tmp table with the translated error message.
1632: /*

Line 1640: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

1636: --sql statement upd8
1637: UPDATE qp_npreq_ldets_tmp
1638: SET pricing_status_text = l_message,
1639: pricing_status_code =
1640: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1641: WHERE line_index = g_limit_balance_line(i).line_index
1642: AND created_from_list_line_id =
1643: g_limit_balance_line(i).list_line_id;
1644:

Line 1646: QP_PREQ_GRP.engine_debug(l_message);

1642: AND created_from_list_line_id =
1643: g_limit_balance_line(i).list_line_id;
1644:
1645: IF l_debug = FND_API.G_TRUE THEN
1646: QP_PREQ_GRP.engine_debug(l_message);
1647:
1648: END IF;
1649: END IF;
1650:

Line 1704: QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED;

1700:
1701: --10023220
1702: IF p_wanted_amount > l_full_available_amount AND ((p_wanted_amount - l_full_available_amount) NOT BETWEEN 0 AND 0.1 )THEN
1703: g_limit_balance_line(i).limit_code :=
1704: QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED;
1705: ELSE
1706: g_limit_balance_line(i).limit_code :=
1707: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;
1708: END IF; --if p_wanted_amount > l_full_available_amount

Line 1707: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;

1703: g_limit_balance_line(i).limit_code :=
1704: QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED;
1705: ELSE
1706: g_limit_balance_line(i).limit_code :=
1707: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;
1708: END IF; --if p_wanted_amount > l_full_available_amount
1709:
1710: ELSE --Soft Limit
1711: g_limit_balance_line(i).available_amount := p_wanted_amount;

Line 1716: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;

1712:
1713: IF g_limit_balance_line(i).line_category = 'RETURN' THEN
1714:
1715: g_limit_balance_line(i).limit_code :=
1716: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;
1717:
1718: ELSE --If line_category is not 'RETURN'
1719:
1720: IF p_wanted_amount > l_full_available_amount

Line 1723: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED;

1719:
1720: IF p_wanted_amount > l_full_available_amount
1721: THEN
1722: g_limit_balance_line(i).limit_code :=
1723: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED;
1724: ELSE
1725: g_limit_balance_line(i).limit_code :=
1726: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;
1727: END IF; --If wanted_amount > l_full_available_amount

Line 1726: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;

1722: g_limit_balance_line(i).limit_code :=
1723: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED;
1724: ELSE
1725: g_limit_balance_line(i).limit_code :=
1726: QP_PREQ_GRP.G_STATUS_LIMIT_CONSUMED;
1727: END IF; --If wanted_amount > l_full_available_amount
1728:
1729: END IF; --If line_category is 'RETURN'
1730:

Line 1734: QP_PREQ_GRP.engine_debug('p_wanted_amount '||p_wanted_amount);

1730:
1731: END IF; --If limit_exceed_action_code is 'HARD'
1732:
1733: IF l_debug = FND_API.G_TRUE THEN
1734: QP_PREQ_GRP.engine_debug('p_wanted_amount '||p_wanted_amount);
1735: QP_PREQ_GRP.engine_debug('available_amount '||
1736: g_limit_balance_line(i).available_amount);
1737:
1738: END IF;

Line 1735: QP_PREQ_GRP.engine_debug('available_amount '||

1731: END IF; --If limit_exceed_action_code is 'HARD'
1732:
1733: IF l_debug = FND_API.G_TRUE THEN
1734: QP_PREQ_GRP.engine_debug('p_wanted_amount '||p_wanted_amount);
1735: QP_PREQ_GRP.engine_debug('available_amount '||
1736: g_limit_balance_line(i).available_amount);
1737:
1738: END IF;
1739: IF p_wanted_amount <> 0 THEN

Line 1747: QP_PREQ_GRP.engine_debug('available_percent '||

1743: g_limit_balance_line(i).available_percent := 100;
1744: END IF;
1745:
1746: IF l_debug = FND_API.G_TRUE THEN
1747: QP_PREQ_GRP.engine_debug('available_percent '||
1748: g_limit_balance_line(i).available_percent);
1749:
1750: END IF;
1751: g_limit_balance_line(i).hard_limit_exceeded := FALSE;

Line 1760: QP_PREQ_GRP.engine_debug('End Check_balance');

1756: END LOOP; --over l_cust_table
1757: END LOOP; --over l_org_table
1758:
1759: IF l_debug = FND_API.G_TRUE THEN
1760: QP_PREQ_GRP.engine_debug('***End Check_balance***');
1761: END IF;
1762: RETURN TRUE;
1763:
1764: END IF; --If Each Attributes Exist for the Limit

Line 1769: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));

1765:
1766: EXCEPTION
1767: WHEN OTHERS THEN
1768: IF l_debug = FND_API.G_TRUE THEN
1769: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
1770: END IF;
1771: RETURN FALSE;
1772: END Check_Balance;
1773:

Line 1804: QP_PREQ_GRP.engine_debug('results not found' || SQLERRM);

1800: AND pricing_attribute = 'PRICING_ATTRIBUTE12';
1801: EXCEPTION
1802: WHEN OTHERS THEN
1803: IF l_debug = FND_API.G_TRUE THEN
1804: QP_PREQ_GRP.engine_debug('results not found' || SQLERRM);
1805: END IF;
1806: l_amt_exist_flag := 'N';
1807: END;
1808: END IF;

Line 1874: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));

1870:
1871: EXCEPTION
1872: WHEN OTHERS THEN
1873: IF l_debug = FND_API.G_TRUE THEN
1874: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
1875: END IF;
1876: RETURN FALSE;
1877: END Check_Balance_Wrapper;
1878:

Line 1934: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,

1930: '%', q.unit_price * r.operand_value/100,
1931: r.operand_value),
1932: r.adjustment_amount * q.priced_quantity)) cost_wanted,
1933: /*decode(r.operand_calculation_code,
1934: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
1935: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
1936: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
1937: q.priced_quantity quantity_wanted
1938: FROM qp_npreq_ldets_tmp r, qp_limits l,

Line 1942: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

1938: FROM qp_npreq_ldets_tmp r, qp_limits l,
1939: qp_limit_attributes a, qp_npreq_line_attrs_tmp rl, qp_npreq_lines_tmp q
1940: WHERE r.created_from_list_header_id = l.list_header_id
1941: AND r.created_from_list_line_id = l.list_line_id
1942: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
1943: AND r.applied_flag = 'Y' -- [5385851/5322832]
1944: AND r.header_limit_exists = 'Y' --common flag for both header and line
1945: AND r.CREATED_FROM_LIST_LINE_TYPE NOT IN ('OID','PRG','CIE','IUE','TSN') --Bug#4101675
1946: AND l.limit_id = a.limit_id

Line 1951: AND rl.pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED

1947: AND a.limit_attribute_context = rl.context
1948: AND a.limit_attribute = rl.attribute
1949: AND a.limit_attr_value = rl.value_from
1950: AND a.limit_attribute_type = rl.attribute_type
1951: AND rl.pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
1952: AND r.line_index = rl.line_index
1953: AND r.line_index = q.line_index
1954: GROUP BY r.line_index, r.created_from_list_header_id,
1955: r.created_from_list_line_id, 'L', l.limit_id,

Line 2003: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,

1999: '%', q.unit_price * r.operand_value/100,
2000: r.operand_value),
2001: r.adjustment_amount * q.priced_quantity)) cost_wanted,
2002: /*decode(r.operand_calculation_code,
2003: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
2004: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
2005: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
2006: q.priced_quantity quantity_wanted
2007: FROM qp_npreq_ldets_tmp r, qp_limits l, qp_npreq_lines_tmp q

Line 2010: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

2006: q.priced_quantity quantity_wanted
2007: FROM qp_npreq_ldets_tmp r, qp_limits l, qp_npreq_lines_tmp q
2008: WHERE r.created_from_list_header_id = l.list_header_id
2009: AND r.created_from_list_line_id = l.list_line_id
2010: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2011: AND r.applied_flag = 'Y' -- [5385851/5322832]
2012: AND r.header_limit_exists = 'Y' --common flag for both header and line
2013: AND r.CREATED_FROM_LIST_LINE_TYPE NOT IN ('OID','PRG','CIE','IUE','TSN') --Bug#4101675
2014: AND r.line_index = q.line_index

Line 2048: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,

2044: '%', q.unit_price * r.operand_value/100,
2045: r.operand_value),
2046: r.adjustment_amount * q.priced_quantity)) cost_wanted,
2047: /* decode(r.operand_calculation_code,
2048: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
2049: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
2050: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
2051: q.priced_quantity quantity_wanted
2052: FROM qp_npreq_ldets_tmp r, qp_limits l,

Line 2056: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

2052: FROM qp_npreq_ldets_tmp r, qp_limits l,
2053: qp_limit_attributes a, qp_npreq_line_attrs_tmp rl, qp_npreq_lines_tmp q
2054: WHERE r.created_from_list_header_id = l.list_header_id
2055: AND l.list_line_id = -1
2056: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2057: AND r.applied_flag = 'Y' -- [5385851/5322832]
2058: AND r.header_limit_exists = 'Y' --common flag for both header and line
2059: AND r.CREATED_FROM_LIST_LINE_TYPE NOT IN ('OID','PRG','CIE','IUE','TSN') --Bug#4101675
2060: AND l.limit_id = a.limit_id

Line 2065: AND rl.pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED

2061: AND a.limit_attribute_context = rl.context
2062: AND a.limit_attribute = rl.attribute
2063: AND a.limit_attr_value = rl.value_from
2064: AND a.limit_attribute_type = rl.attribute_type
2065: AND rl.pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
2066: AND r.line_index = rl.line_index
2067: AND r.line_index = q.line_index
2068: GROUP BY r.line_index, r.created_from_list_header_id,
2069: r.created_from_list_line_id, 'H', l.limit_id,

Line 2117: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,

2113: '%', q.unit_price * r.operand_value/100,
2114: r.operand_value),
2115: r.adjustment_amount * q.priced_quantity)) cost_wanted,
2116: /*decode(r.operand_calculation_code,
2117: QP_PREQ_GRP.G_LUMPSUM_DISCOUNT, r.benefit_qty,
2118: r.benefit_qty * q.priced_quantity) accrual_wanted, -- 3598337, see bug for explanation*/
2119: r.benefit_qty accrual_wanted, --4328118, see bug for explanation.
2120: q.priced_quantity quantity_wanted
2121: FROM qp_npreq_ldets_tmp r, qp_limits l, qp_npreq_lines_tmp q

Line 2124: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

2120: q.priced_quantity quantity_wanted
2121: FROM qp_npreq_ldets_tmp r, qp_limits l, qp_npreq_lines_tmp q
2122: WHERE r.created_from_list_header_id = l.list_header_id
2123: AND l.list_line_id = -1
2124: AND r.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2125: AND r.applied_flag = 'Y' -- [5385851/5322832]
2126: AND r.header_limit_exists = 'Y' --common flag for both header and line
2127: AND r.CREATED_FROM_LIST_LINE_TYPE NOT IN ('OID','PRG','CIE','IUE','TSN') --Bug#4101675
2128: AND r.line_index = q.line_index

Line 2159: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

2155: l_modifier_level_code VARCHAR2(30) := ''; --Bug 4457725
2156:
2157: BEGIN
2158:
2159: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
2160: IF l_debug = FND_API.G_TRUE THEN
2161: QP_PREQ_GRP.engine_debug('***Begin Process_Limits***');
2162:
2163: END IF;

Line 2161: QP_PREQ_GRP.engine_debug('Begin Process_Limits');

2157: BEGIN
2158:
2159: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
2160: IF l_debug = FND_API.G_TRUE THEN
2161: QP_PREQ_GRP.engine_debug('***Begin Process_Limits***');
2162:
2163: END IF;
2164: --Initialize x_return_status
2165: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2180: QP_PREQ_GRP.engine_debug('========================');

2176: FOR l_limit_rec IN limits_cur
2177: LOOP
2178:
2179: IF l_debug = FND_API.G_TRUE THEN
2180: QP_PREQ_GRP.engine_debug('========================');
2181: QP_PREQ_GRP.engine_debug('In limits_cur loop');
2182:
2183: QP_PREQ_GRP.engine_debug('list header id of previous limit ' || l_old_limit_rec.created_from_list_header_id);
2184: QP_PREQ_GRP.engine_debug('list header id of current limit ' || l_limit_rec.created_from_list_header_id);

Line 2181: QP_PREQ_GRP.engine_debug('In limits_cur loop');

2177: LOOP
2178:
2179: IF l_debug = FND_API.G_TRUE THEN
2180: QP_PREQ_GRP.engine_debug('========================');
2181: QP_PREQ_GRP.engine_debug('In limits_cur loop');
2182:
2183: QP_PREQ_GRP.engine_debug('list header id of previous limit ' || l_old_limit_rec.created_from_list_header_id);
2184: QP_PREQ_GRP.engine_debug('list header id of current limit ' || l_limit_rec.created_from_list_header_id);
2185: QP_PREQ_GRP.engine_debug('------------------------');

Line 2183: QP_PREQ_GRP.engine_debug('list header id of previous limit ' || l_old_limit_rec.created_from_list_header_id);

2179: IF l_debug = FND_API.G_TRUE THEN
2180: QP_PREQ_GRP.engine_debug('========================');
2181: QP_PREQ_GRP.engine_debug('In limits_cur loop');
2182:
2183: QP_PREQ_GRP.engine_debug('list header id of previous limit ' || l_old_limit_rec.created_from_list_header_id);
2184: QP_PREQ_GRP.engine_debug('list header id of current limit ' || l_limit_rec.created_from_list_header_id);
2185: QP_PREQ_GRP.engine_debug('------------------------');
2186: QP_PREQ_GRP.engine_debug('list_line_id of previous limit ' || l_old_limit_rec.created_from_list_line_id);
2187: QP_PREQ_GRP.engine_debug('list_line_id of current limit ' || l_limit_rec.created_from_list_line_id);

Line 2184: QP_PREQ_GRP.engine_debug('list header id of current limit ' || l_limit_rec.created_from_list_header_id);

2180: QP_PREQ_GRP.engine_debug('========================');
2181: QP_PREQ_GRP.engine_debug('In limits_cur loop');
2182:
2183: QP_PREQ_GRP.engine_debug('list header id of previous limit ' || l_old_limit_rec.created_from_list_header_id);
2184: QP_PREQ_GRP.engine_debug('list header id of current limit ' || l_limit_rec.created_from_list_header_id);
2185: QP_PREQ_GRP.engine_debug('------------------------');
2186: QP_PREQ_GRP.engine_debug('list_line_id of previous limit ' || l_old_limit_rec.created_from_list_line_id);
2187: QP_PREQ_GRP.engine_debug('list_line_id of current limit ' || l_limit_rec.created_from_list_line_id);
2188: QP_PREQ_GRP.engine_debug('------------------------');

Line 2185: QP_PREQ_GRP.engine_debug('------------------------');

2181: QP_PREQ_GRP.engine_debug('In limits_cur loop');
2182:
2183: QP_PREQ_GRP.engine_debug('list header id of previous limit ' || l_old_limit_rec.created_from_list_header_id);
2184: QP_PREQ_GRP.engine_debug('list header id of current limit ' || l_limit_rec.created_from_list_header_id);
2185: QP_PREQ_GRP.engine_debug('------------------------');
2186: QP_PREQ_GRP.engine_debug('list_line_id of previous limit ' || l_old_limit_rec.created_from_list_line_id);
2187: QP_PREQ_GRP.engine_debug('list_line_id of current limit ' || l_limit_rec.created_from_list_line_id);
2188: QP_PREQ_GRP.engine_debug('------------------------');
2189: QP_PREQ_GRP.engine_debug('line_index of previous limit ' || l_old_limit_rec.line_index);

Line 2186: QP_PREQ_GRP.engine_debug('list_line_id of previous limit ' || l_old_limit_rec.created_from_list_line_id);

2182:
2183: QP_PREQ_GRP.engine_debug('list header id of previous limit ' || l_old_limit_rec.created_from_list_header_id);
2184: QP_PREQ_GRP.engine_debug('list header id of current limit ' || l_limit_rec.created_from_list_header_id);
2185: QP_PREQ_GRP.engine_debug('------------------------');
2186: QP_PREQ_GRP.engine_debug('list_line_id of previous limit ' || l_old_limit_rec.created_from_list_line_id);
2187: QP_PREQ_GRP.engine_debug('list_line_id of current limit ' || l_limit_rec.created_from_list_line_id);
2188: QP_PREQ_GRP.engine_debug('------------------------');
2189: QP_PREQ_GRP.engine_debug('line_index of previous limit ' || l_old_limit_rec.line_index);
2190: QP_PREQ_GRP.engine_debug('line_index of current limit ' || l_limit_rec.line_index);

Line 2187: QP_PREQ_GRP.engine_debug('list_line_id of current limit ' || l_limit_rec.created_from_list_line_id);

2183: QP_PREQ_GRP.engine_debug('list header id of previous limit ' || l_old_limit_rec.created_from_list_header_id);
2184: QP_PREQ_GRP.engine_debug('list header id of current limit ' || l_limit_rec.created_from_list_header_id);
2185: QP_PREQ_GRP.engine_debug('------------------------');
2186: QP_PREQ_GRP.engine_debug('list_line_id of previous limit ' || l_old_limit_rec.created_from_list_line_id);
2187: QP_PREQ_GRP.engine_debug('list_line_id of current limit ' || l_limit_rec.created_from_list_line_id);
2188: QP_PREQ_GRP.engine_debug('------------------------');
2189: QP_PREQ_GRP.engine_debug('line_index of previous limit ' || l_old_limit_rec.line_index);
2190: QP_PREQ_GRP.engine_debug('line_index of current limit ' || l_limit_rec.line_index);
2191: QP_PREQ_GRP.engine_debug('------------------------');

Line 2188: QP_PREQ_GRP.engine_debug('------------------------');

2184: QP_PREQ_GRP.engine_debug('list header id of current limit ' || l_limit_rec.created_from_list_header_id);
2185: QP_PREQ_GRP.engine_debug('------------------------');
2186: QP_PREQ_GRP.engine_debug('list_line_id of previous limit ' || l_old_limit_rec.created_from_list_line_id);
2187: QP_PREQ_GRP.engine_debug('list_line_id of current limit ' || l_limit_rec.created_from_list_line_id);
2188: QP_PREQ_GRP.engine_debug('------------------------');
2189: QP_PREQ_GRP.engine_debug('line_index of previous limit ' || l_old_limit_rec.line_index);
2190: QP_PREQ_GRP.engine_debug('line_index of current limit ' || l_limit_rec.line_index);
2191: QP_PREQ_GRP.engine_debug('------------------------');
2192:

Line 2189: QP_PREQ_GRP.engine_debug('line_index of previous limit ' || l_old_limit_rec.line_index);

2185: QP_PREQ_GRP.engine_debug('------------------------');
2186: QP_PREQ_GRP.engine_debug('list_line_id of previous limit ' || l_old_limit_rec.created_from_list_line_id);
2187: QP_PREQ_GRP.engine_debug('list_line_id of current limit ' || l_limit_rec.created_from_list_line_id);
2188: QP_PREQ_GRP.engine_debug('------------------------');
2189: QP_PREQ_GRP.engine_debug('line_index of previous limit ' || l_old_limit_rec.line_index);
2190: QP_PREQ_GRP.engine_debug('line_index of current limit ' || l_limit_rec.line_index);
2191: QP_PREQ_GRP.engine_debug('------------------------');
2192:
2193: END IF;

Line 2190: QP_PREQ_GRP.engine_debug('line_index of current limit ' || l_limit_rec.line_index);

2186: QP_PREQ_GRP.engine_debug('list_line_id of previous limit ' || l_old_limit_rec.created_from_list_line_id);
2187: QP_PREQ_GRP.engine_debug('list_line_id of current limit ' || l_limit_rec.created_from_list_line_id);
2188: QP_PREQ_GRP.engine_debug('------------------------');
2189: QP_PREQ_GRP.engine_debug('line_index of previous limit ' || l_old_limit_rec.line_index);
2190: QP_PREQ_GRP.engine_debug('line_index of current limit ' || l_limit_rec.line_index);
2191: QP_PREQ_GRP.engine_debug('------------------------');
2192:
2193: END IF;
2194: --If Skip_line flag is true then skip all limits until list_line_id changes

Line 2191: QP_PREQ_GRP.engine_debug('------------------------');

2187: QP_PREQ_GRP.engine_debug('list_line_id of current limit ' || l_limit_rec.created_from_list_line_id);
2188: QP_PREQ_GRP.engine_debug('------------------------');
2189: QP_PREQ_GRP.engine_debug('line_index of previous limit ' || l_old_limit_rec.line_index);
2190: QP_PREQ_GRP.engine_debug('line_index of current limit ' || l_limit_rec.line_index);
2191: QP_PREQ_GRP.engine_debug('------------------------');
2192:
2193: END IF;
2194: --If Skip_line flag is true then skip all limits until list_line_id changes
2195: --or until line_index changes.

Line 2203: QP_PREQ_GRP.engine_debug('skipping limit '|| l_limit_rec.limit_id ||

2199: l_limit_rec.line_index =
2200: l_old_limit_rec.line_index
2201: THEN
2202: IF l_debug = FND_API.G_TRUE THEN
2203: QP_PREQ_GRP.engine_debug('skipping limit '|| l_limit_rec.limit_id ||
2204: 'for line '||l_limit_rec.created_from_list_line_id);
2205:
2206: END IF;
2207: l_old_limit_rec := l_limit_rec;

Line 2220: QP_PREQ_GRP.engine_debug('skipping limit '|| l_limit_rec.limit_id ||

2216: l_limit_rec.line_index =
2217: l_old_limit_rec.line_index
2218: THEN
2219: IF l_debug = FND_API.G_TRUE THEN
2220: QP_PREQ_GRP.engine_debug('skipping limit '|| l_limit_rec.limit_id ||
2221: 'for header '||l_limit_rec.created_from_list_header_id);
2222:
2223: END IF;
2224: l_old_limit_rec := l_limit_rec;

Line 2248: QP_PREQ_GRP.engine_debug('Modifier Level '||l_modifier_level_code);

2244: --is applied only once for a group
2245: select MODIFIER_LEVEL_CODE into l_modifier_level_code
2246: from qp_list_lines where list_line_id = l_old_limit_rec.created_from_list_line_id;
2247: IF l_debug = FND_API.G_TRUE THEN
2248: QP_PREQ_GRP.engine_debug('Modifier Level '||l_modifier_level_code);
2249: END IF;
2250:
2251: IF l_modifier_level_code = 'LINEGROUP' AND l_processed_limits_tbl.COUNT > 0 AND l_limit_rec.basis = 'USAGE' --9645844
2252: THEN

Line 2266: QP_PREQ_GRP.engine_debug('Line Group Modifier with limit id '||l_old_limit_rec.limit_id||' already processed');

2262:
2263: IF l_modifier_level_code = 'LINEGROUP' AND l_processed AND l_limit_rec.basis = 'USAGE' --9645844
2264: THEN
2265: IF l_debug = FND_API.G_TRUE THEN
2266: QP_PREQ_GRP.engine_debug('Line Group Modifier with limit id '||l_old_limit_rec.limit_id||' already processed');
2267: END IF;
2268: --Clear the global plsql table storing limits info.
2269: g_limit_balance_line.DELETE;
2270:

Line 2279: QP_PREQ_GRP.engine_debug('Change in list_line_id or line_index. ' ||

2275: G_LOOP_COUNT := 0; --Initialize whenever line_index or list_line_id
2276: --changes, i.e., before each loop
2277: LOOP
2278: IF l_debug = FND_API.G_TRUE THEN
2279: QP_PREQ_GRP.engine_debug('Change in list_line_id or line_index. ' ||
2280: 'Update limit balance. Loop through ' ||
2281: 'Recheck_balance and Update_Balance, if ' ||
2282: 'necessary ');
2283:

Line 2325: QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED)

2321: FOR j IN g_limit_balance_line.FIRST..g_limit_balance_line.LAST
2322: LOOP
2323:
2324: IF (g_limit_balance_line(j).limit_code =
2325: QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED)
2326: OR
2327: (g_limit_balance_line(j).limit_code =
2328: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED AND
2329: l_limit_code IS NULL)

Line 2328: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED AND

2324: IF (g_limit_balance_line(j).limit_code =
2325: QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED)
2326: OR
2327: (g_limit_balance_line(j).limit_code =
2328: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED AND
2329: l_limit_code IS NULL)
2330: THEN
2331:
2332: l_limit_code := g_limit_balance_line(j).limit_code;

Line 2349: QP_PREQ_GRP.engine_debug('################# ' || l_limit_text);

2345: ,p_message_text => l_limit_text
2346: );
2347:
2348: IF l_debug = FND_API.G_TRUE THEN
2349: QP_PREQ_GRP.engine_debug('################# ' || l_limit_text);
2350:
2351: END IF;
2352: END IF;
2353:

Line 2356: (QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED,

2352: END IF;
2353:
2354: IF g_limit_balance_line(j).limit_hold_flag = 'Y' AND
2355: g_limit_balance_line(j).limit_code IN
2356: (QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED,
2357: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED)
2358: THEN
2359: l_hold_code := QP_PREQ_GRP.G_STATUS_LIMIT_HOLD;
2360: END IF;

Line 2357: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED)

2353:
2354: IF g_limit_balance_line(j).limit_hold_flag = 'Y' AND
2355: g_limit_balance_line(j).limit_code IN
2356: (QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED,
2357: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED)
2358: THEN
2359: l_hold_code := QP_PREQ_GRP.G_STATUS_LIMIT_HOLD;
2360: END IF;
2361:

Line 2359: l_hold_code := QP_PREQ_GRP.G_STATUS_LIMIT_HOLD;

2355: g_limit_balance_line(j).limit_code IN
2356: (QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED,
2357: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED)
2358: THEN
2359: l_hold_code := QP_PREQ_GRP.G_STATUS_LIMIT_HOLD;
2360: END IF;
2361:
2362: IF g_limit_balance_line(j).limit_hold_flag = 'N' AND
2363: g_limit_balance_line(j).limit_code IN

Line 2364: (QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED,

2360: END IF;
2361:
2362: IF g_limit_balance_line(j).limit_hold_flag = 'N' AND
2363: g_limit_balance_line(j).limit_code IN
2364: (QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED,
2365: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED)
2366: THEN
2367: l_hold_code := QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED;
2368: END IF;

Line 2365: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED)

2361:
2362: IF g_limit_balance_line(j).limit_hold_flag = 'N' AND
2363: g_limit_balance_line(j).limit_code IN
2364: (QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED,
2365: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED)
2366: THEN
2367: l_hold_code := QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED;
2368: END IF;
2369:

Line 2367: l_hold_code := QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED;

2363: g_limit_balance_line(j).limit_code IN
2364: (QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED,
2365: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED)
2366: THEN
2367: l_hold_code := QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED;
2368: END IF;
2369:
2370: IF l_debug = FND_API.G_TRUE THEN
2371: QP_PREQ_GRP.engine_debug('Hold Flag is ' || g_limit_balance_line(j).limit_hold_flag );

Line 2371: QP_PREQ_GRP.engine_debug('Hold Flag is ' || g_limit_balance_line(j).limit_hold_flag );

2367: l_hold_code := QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED;
2368: END IF;
2369:
2370: IF l_debug = FND_API.G_TRUE THEN
2371: QP_PREQ_GRP.engine_debug('Hold Flag is ' || g_limit_balance_line(j).limit_hold_flag );
2372: QP_PREQ_GRP.engine_debug('Hold Code is ' || l_hold_code);
2373:
2374: END IF;
2375: --Do the following update for all list line types

Line 2372: QP_PREQ_GRP.engine_debug('Hold Code is ' || l_hold_code);

2368: END IF;
2369:
2370: IF l_debug = FND_API.G_TRUE THEN
2371: QP_PREQ_GRP.engine_debug('Hold Flag is ' || g_limit_balance_line(j).limit_hold_flag );
2372: QP_PREQ_GRP.engine_debug('Hold Code is ' || l_hold_code);
2373:
2374: END IF;
2375: --Do the following update for all list line types
2376: /*

Line 2390: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;

2386: limit_text = l_limit_text
2387: WHERE line_index = g_limit_balance_line(j).line_index
2388: AND created_from_list_line_id =
2389: g_limit_balance_line(j).list_line_id
2390: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;
2391:
2392: --Update the Child Break Lines for 'PBH' lines
2393: IF g_limit_balance_line(j).created_from_list_line_type = 'PBH'
2394: THEN

Line 2428: AND a.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

2424:
2425: WHERE a.line_index = g_limit_balance_line(j).line_index
2426: AND a.created_from_list_line_id =
2427: g_limit_balance_line(j).list_line_id
2428: AND a.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2429: AND a.line_detail_index IN
2430: (SELECT b.related_line_detail_index
2431: FROM qp_npreq_rltd_lines_tmp b
2432: WHERE b.line_index = a.line_index

Line 2440: QP_PREQ_GRP.engine_debug('line_index '||

2436:
2437: END IF;--If created_from_list_line_type = 'PBH'
2438:
2439: IF l_debug = FND_API.G_TRUE THEN
2440: QP_PREQ_GRP.engine_debug('line_index '||
2441: g_limit_balance_line(j).line_index);
2442: QP_PREQ_GRP.engine_debug('limit_code '||
2443: g_limit_balance_line(j).limit_code);
2444: QP_PREQ_GRP.engine_debug('list_line_id '||

Line 2442: QP_PREQ_GRP.engine_debug('limit_code '||

2438:
2439: IF l_debug = FND_API.G_TRUE THEN
2440: QP_PREQ_GRP.engine_debug('line_index '||
2441: g_limit_balance_line(j).line_index);
2442: QP_PREQ_GRP.engine_debug('limit_code '||
2443: g_limit_balance_line(j).limit_code);
2444: QP_PREQ_GRP.engine_debug('list_line_id '||
2445: g_limit_balance_line(j).list_line_id);
2446: QP_PREQ_GRP.engine_debug('benefit_qty '||

Line 2444: QP_PREQ_GRP.engine_debug('list_line_id '||

2440: QP_PREQ_GRP.engine_debug('line_index '||
2441: g_limit_balance_line(j).line_index);
2442: QP_PREQ_GRP.engine_debug('limit_code '||
2443: g_limit_balance_line(j).limit_code);
2444: QP_PREQ_GRP.engine_debug('list_line_id '||
2445: g_limit_balance_line(j).list_line_id);
2446: QP_PREQ_GRP.engine_debug('benefit_qty '||
2447: g_limit_balance_line(j).benefit_qty);
2448: QP_PREQ_GRP.engine_debug('operand_value '||

Line 2446: QP_PREQ_GRP.engine_debug('benefit_qty '||

2442: QP_PREQ_GRP.engine_debug('limit_code '||
2443: g_limit_balance_line(j).limit_code);
2444: QP_PREQ_GRP.engine_debug('list_line_id '||
2445: g_limit_balance_line(j).list_line_id);
2446: QP_PREQ_GRP.engine_debug('benefit_qty '||
2447: g_limit_balance_line(j).benefit_qty);
2448: QP_PREQ_GRP.engine_debug('operand_value '||
2449: g_limit_balance_line(j).operand_value);
2450:

Line 2448: QP_PREQ_GRP.engine_debug('operand_value '||

2444: QP_PREQ_GRP.engine_debug('list_line_id '||
2445: g_limit_balance_line(j).list_line_id);
2446: QP_PREQ_GRP.engine_debug('benefit_qty '||
2447: g_limit_balance_line(j).benefit_qty);
2448: QP_PREQ_GRP.engine_debug('operand_value '||
2449: g_limit_balance_line(j).operand_value);
2450:
2451: END IF;
2452: --Update Hold_Code

Line 2458: SET hold_code = DECODE(hold_code, QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, l_hold_code)

2454: INDX,qp_limit_balance_check_pvt.process_limits.upd3,qp_npreq_lines_tmp_N1,LINE_INDEX,1
2455: */
2456: --sql statement upd3
2457: UPDATE qp_npreq_lines_tmp
2458: SET hold_code = DECODE(hold_code, QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, l_hold_code)
2459: WHERE line_index = g_limit_balance_line(j).line_index;
2460:
2461: IF l_debug = FND_API.G_TRUE THEN
2462: QP_PREQ_GRP.engine_debug('Hold Flag is Y');

Line 2462: QP_PREQ_GRP.engine_debug('Hold Flag is Y');

2458: SET hold_code = DECODE(hold_code, QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, l_hold_code)
2459: WHERE line_index = g_limit_balance_line(j).line_index;
2460:
2461: IF l_debug = FND_API.G_TRUE THEN
2462: QP_PREQ_GRP.engine_debug('Hold Flag is Y');
2463: QP_PREQ_GRP.engine_debug('Hold Code is '||QP_PREQ_GRP.G_STATUS_LIMIT_HOLD);
2464:
2465: END IF;
2466:

Line 2463: QP_PREQ_GRP.engine_debug('Hold Code is '||QP_PREQ_GRP.G_STATUS_LIMIT_HOLD);

2459: WHERE line_index = g_limit_balance_line(j).line_index;
2460:
2461: IF l_debug = FND_API.G_TRUE THEN
2462: QP_PREQ_GRP.engine_debug('Hold Flag is Y');
2463: QP_PREQ_GRP.engine_debug('Hold Code is '||QP_PREQ_GRP.G_STATUS_LIMIT_HOLD);
2464:
2465: END IF;
2466:
2467: IF g_limit_balance_line(j).transaction_amount is null THEN

Line 2525: QP_PREQ_GRP.engine_debug('Done Updating Balances when line changed');

2521:
2522: END IF; --g_limit_balance_line.COUNT > 0
2523:
2524: IF l_debug = FND_API.G_TRUE THEN
2525: QP_PREQ_GRP.engine_debug('Done Updating Balances when line changed');
2526:
2527: END IF;
2528: --Clear the global plsql table storing limits info.
2529: g_limit_balance_line.DELETE;

Line 2545: QP_PREQ_GRP.engine_debug('Limit not available - hard limit with 0 balance');

2541:
2542: IF NOT l_limit_available THEN
2543:
2544: IF l_debug = FND_API.G_TRUE THEN
2545: QP_PREQ_GRP.engine_debug('Limit not available - hard limit with 0 balance');
2546:
2547: END IF;
2548: --If Header-level limit, then skip all limits and go to the next
2549: --list_header limit. Elseif line_level go to the next line_level limit.

Line 2552: QP_PREQ_GRP.engine_debug('Header Level Limit '||

2548: --If Header-level limit, then skip all limits and go to the next
2549: --list_header limit. Elseif line_level go to the next line_level limit.
2550: IF l_limit_rec.limit_level = 'H' THEN
2551: IF l_debug = FND_API.G_TRUE THEN
2552: QP_PREQ_GRP.engine_debug('Header Level Limit '||
2553: l_limit_rec.limit_id ||' not available');
2554: END IF;
2555: /*
2556: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

Line 2562: SET pricing_status_code = QP_PREQ_GRP.G_STATUS_DELETED

2558: INDX,qp_limit_balance_check_pvt.process_limits.upd5,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_HEADER_ID,4
2559: */
2560: --sql statement upd5
2561: UPDATE qp_npreq_ldets_tmp
2562: SET pricing_status_code = QP_PREQ_GRP.G_STATUS_DELETED
2563: WHERE created_from_list_header_id =
2564: l_limit_rec.created_from_list_header_id
2565: AND line_index = l_limit_rec.line_index
2566: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;

Line 2566: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;

2562: SET pricing_status_code = QP_PREQ_GRP.G_STATUS_DELETED
2563: WHERE created_from_list_header_id =
2564: l_limit_rec.created_from_list_header_id
2565: AND line_index = l_limit_rec.line_index
2566: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;
2567:
2568: l_skip_header := TRUE;
2569:
2570: ELSIF l_limit_rec.limit_level = 'L' THEN

Line 2572: QP_PREQ_GRP.engine_debug('Line Level Limit '||

2568: l_skip_header := TRUE;
2569:
2570: ELSIF l_limit_rec.limit_level = 'L' THEN
2571: IF l_debug = FND_API.G_TRUE THEN
2572: QP_PREQ_GRP.engine_debug('Line Level Limit '||
2573: l_limit_rec.limit_id ||' not available');
2574: END IF;
2575: /*
2576: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,LINE_INDEX,1

Line 2582: SET pricing_status_code = QP_PREQ_GRP.G_STATUS_DELETED

2578: INDX,qp_limit_balance_check_pvt.process_limits.upd6,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
2579: */
2580: --sql statement upd6
2581: UPDATE qp_npreq_ldets_tmp
2582: SET pricing_status_code = QP_PREQ_GRP.G_STATUS_DELETED
2583: WHERE created_from_list_line_id =
2584: l_limit_rec.created_from_list_line_id
2585: AND line_index = l_limit_rec.line_index
2586: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;

Line 2586: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;

2582: SET pricing_status_code = QP_PREQ_GRP.G_STATUS_DELETED
2583: WHERE created_from_list_line_id =
2584: l_limit_rec.created_from_list_line_id
2585: AND line_index = l_limit_rec.line_index
2586: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;
2587:
2588: l_skip_line := TRUE;
2589:
2590: END IF;

Line 2595: QP_PREQ_GRP.engine_debug('limit ' || l_limit_rec.limit_id ||

2591:
2592: ELSIF l_limit_available AND l_skip_limit THEN
2593:
2594: IF l_debug = FND_API.G_TRUE THEN
2595: QP_PREQ_GRP.engine_debug('limit ' || l_limit_rec.limit_id ||
2596: ' available but' || 'skipped - does not qualify');
2597: END IF;
2598: l_skip_limit := FALSE;
2599: GOTO limits_loop; --to next record in limits_cur loop

Line 2606: QP_PREQ_GRP.engine_debug('Repeat limits_cur loop for next limit - if any');

2602:
2603: l_old_limit_rec := l_limit_rec;
2604:
2605: IF l_debug = FND_API.G_TRUE THEN
2606: QP_PREQ_GRP.engine_debug('Repeat limits_cur loop for next limit - if any');
2607: END IF;
2608: <>
2609: null;
2610: END LOOP; --loop over main limits_cur

Line 2623: QP_PREQ_GRP.engine_debug('Start Boundary condition processing');

2619: G_LOOP_COUNT := 0; --Initialize before boundary condition loop
2620:
2621: LOOP
2622: IF l_debug = FND_API.G_TRUE THEN
2623: QP_PREQ_GRP.engine_debug('***Start Boundary condition processing***');
2624: END IF;
2625:
2626: select MODIFIER_LEVEL_CODE into l_modifier_level_code
2627: from qp_list_lines where list_line_id = l_old_limit_rec.created_from_list_line_id;

Line 2629: QP_PREQ_GRP.engine_debug('Modifier Level '||l_modifier_level_code);

2625:
2626: select MODIFIER_LEVEL_CODE into l_modifier_level_code
2627: from qp_list_lines where list_line_id = l_old_limit_rec.created_from_list_line_id;
2628: IF l_debug = FND_API.G_TRUE THEN
2629: QP_PREQ_GRP.engine_debug('Modifier Level '||l_modifier_level_code);
2630: END IF;
2631:
2632: IF l_modifier_level_code = 'LINEGROUP' AND l_processed_limits_tbl.COUNT > 0 AND l_old_limit_rec.basis = 'USAGE' --9645844
2633: THEN

Line 2647: QP_PREQ_GRP.engine_debug('Boundary condition GroupOfLines Limit already processed');

2643:
2644: IF l_modifier_level_code = 'LINEGROUP' AND l_processed AND l_old_limit_rec.basis = 'USAGE' --9645844
2645: THEN
2646: IF l_debug = FND_API.G_TRUE THEN
2647: QP_PREQ_GRP.engine_debug('***Boundary condition GroupOfLines Limit already processed***');
2648: END IF;
2649: EXIT;
2650: END IF;
2651:

Line 2660: QP_PREQ_GRP.engine_debug('Update_Balance l_return_status ' ||l_return_status);

2656: l_processed_limit_count := l_processed_limit_count+1;
2657: END IF;
2658:
2659: IF l_debug = FND_API.G_TRUE THEN
2660: QP_PREQ_GRP.engine_debug('Update_Balance l_return_status ' ||l_return_status);
2661: END IF;
2662:
2663: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2664:

Line 2690: QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED

2686: FOR j IN g_limit_balance_line.FIRST..g_limit_balance_line.LAST
2687: LOOP
2688:
2689: IF g_limit_balance_line(j).limit_code =
2690: QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED
2691: OR
2692: (g_limit_balance_line(j).limit_code =
2693: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED AND
2694: l_limit_code IS NULL)

Line 2693: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED AND

2689: IF g_limit_balance_line(j).limit_code =
2690: QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED
2691: OR
2692: (g_limit_balance_line(j).limit_code =
2693: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED AND
2694: l_limit_code IS NULL)
2695: THEN
2696:
2697: l_limit_code := g_limit_balance_line(j).limit_code;

Line 2700: QP_PREQ_GRP.engine_debug('Before Buid_Message_Text');

2696:
2697: l_limit_code := g_limit_balance_line(j).limit_code;
2698:
2699: IF l_debug = FND_API.G_TRUE THEN
2700: QP_PREQ_GRP.engine_debug('Before Buid_Message_Text');
2701: END IF;
2702:
2703: Build_Message_Text(
2704: p_List_Header_Id => g_limit_balance_line(j).list_header_id

Line 2718: QP_PREQ_GRP.engine_debug('################# ' || l_limit_text);

2714: ,p_message_text => l_limit_text
2715: );
2716:
2717: IF l_debug = FND_API.G_TRUE THEN
2718: QP_PREQ_GRP.engine_debug('################# ' || l_limit_text);
2719:
2720: END IF;
2721: END IF;
2722:

Line 2725: (QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED,

2721: END IF;
2722:
2723: IF g_limit_balance_line(j).limit_hold_flag = 'Y' AND
2724: g_limit_balance_line(j).limit_code IN
2725: (QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED,
2726: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED)
2727: THEN
2728: IF l_debug = FND_API.G_TRUE THEN
2729: QP_PREQ_GRP.engine_debug('label 1');

Line 2726: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED)

2722:
2723: IF g_limit_balance_line(j).limit_hold_flag = 'Y' AND
2724: g_limit_balance_line(j).limit_code IN
2725: (QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED,
2726: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED)
2727: THEN
2728: IF l_debug = FND_API.G_TRUE THEN
2729: QP_PREQ_GRP.engine_debug('label 1');
2730: END IF;

Line 2729: QP_PREQ_GRP.engine_debug('label 1');

2725: (QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED,
2726: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED)
2727: THEN
2728: IF l_debug = FND_API.G_TRUE THEN
2729: QP_PREQ_GRP.engine_debug('label 1');
2730: END IF;
2731: l_hold_code := QP_PREQ_GRP.G_STATUS_LIMIT_HOLD;
2732: END IF;
2733:

Line 2731: l_hold_code := QP_PREQ_GRP.G_STATUS_LIMIT_HOLD;

2727: THEN
2728: IF l_debug = FND_API.G_TRUE THEN
2729: QP_PREQ_GRP.engine_debug('label 1');
2730: END IF;
2731: l_hold_code := QP_PREQ_GRP.G_STATUS_LIMIT_HOLD;
2732: END IF;
2733:
2734: IF g_limit_balance_line(j).limit_hold_flag = 'N' AND
2735: g_limit_balance_line(j).limit_code IN

Line 2736: (QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED,

2732: END IF;
2733:
2734: IF g_limit_balance_line(j).limit_hold_flag = 'N' AND
2735: g_limit_balance_line(j).limit_code IN
2736: (QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED,
2737: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED)
2738: THEN
2739: IF l_debug = FND_API.G_TRUE THEN
2740: QP_PREQ_GRP.engine_debug('label 2');

Line 2737: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED)

2733:
2734: IF g_limit_balance_line(j).limit_hold_flag = 'N' AND
2735: g_limit_balance_line(j).limit_code IN
2736: (QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED,
2737: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED)
2738: THEN
2739: IF l_debug = FND_API.G_TRUE THEN
2740: QP_PREQ_GRP.engine_debug('label 2');
2741: END IF;

Line 2740: QP_PREQ_GRP.engine_debug('label 2');

2736: (QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED,
2737: QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED)
2738: THEN
2739: IF l_debug = FND_API.G_TRUE THEN
2740: QP_PREQ_GRP.engine_debug('label 2');
2741: END IF;
2742: l_hold_code := QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED;
2743: END IF;
2744:

Line 2742: l_hold_code := QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED;

2738: THEN
2739: IF l_debug = FND_API.G_TRUE THEN
2740: QP_PREQ_GRP.engine_debug('label 2');
2741: END IF;
2742: l_hold_code := QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED;
2743: END IF;
2744:
2745: IF l_debug = FND_API.G_TRUE THEN
2746: QP_PREQ_GRP.engine_debug('Hold Flag is ' || g_limit_balance_line(j).limit_hold_flag );

Line 2746: QP_PREQ_GRP.engine_debug('Hold Flag is ' || g_limit_balance_line(j).limit_hold_flag );

2742: l_hold_code := QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED;
2743: END IF;
2744:
2745: IF l_debug = FND_API.G_TRUE THEN
2746: QP_PREQ_GRP.engine_debug('Hold Flag is ' || g_limit_balance_line(j).limit_hold_flag );
2747: QP_PREQ_GRP.engine_debug('Hold Code is ' || l_hold_code);
2748:
2749: END IF;
2750: --Do the following update for all list line types

Line 2747: QP_PREQ_GRP.engine_debug('Hold Code is ' || l_hold_code);

2743: END IF;
2744:
2745: IF l_debug = FND_API.G_TRUE THEN
2746: QP_PREQ_GRP.engine_debug('Hold Flag is ' || g_limit_balance_line(j).limit_hold_flag );
2747: QP_PREQ_GRP.engine_debug('Hold Code is ' || l_hold_code);
2748:
2749: END IF;
2750: --Do the following update for all list line types
2751: /*

Line 2765: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;

2761: limit_text = l_limit_text
2762: WHERE line_index = g_limit_balance_line(j).line_index
2763: AND created_from_list_line_id =
2764: g_limit_balance_line(j).list_line_id
2765: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;
2766:
2767: IF l_debug = FND_API.G_TRUE THEN
2768: QP_PREQ_GRP.engine_debug('label 3');
2769: END IF;

Line 2768: QP_PREQ_GRP.engine_debug('label 3');

2764: g_limit_balance_line(j).list_line_id
2765: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;
2766:
2767: IF l_debug = FND_API.G_TRUE THEN
2768: QP_PREQ_GRP.engine_debug('label 3');
2769: END IF;
2770:
2771: --Update the Child Break Lines for 'PBH' lines
2772: IF g_limit_balance_line(j).created_from_list_line_type = 'PBH' THEN

Line 2806: AND a.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

2802:
2803: WHERE a.line_index = g_limit_balance_line(j).line_index
2804: AND a.created_from_list_line_id =
2805: g_limit_balance_line(j).list_line_id
2806: AND a.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2807: AND a.line_detail_index IN
2808: (SELECT b.related_line_detail_index
2809: FROM qp_npreq_rltd_lines_tmp b
2810: WHERE b.line_index = a.line_index

Line 2816: QP_PREQ_GRP.engine_debug('label 4');

2812: AND b.line_detail_index =
2813: g_limit_balance_line(j).line_detail_index);
2814:
2815: IF l_debug = FND_API.G_TRUE THEN
2816: QP_PREQ_GRP.engine_debug('label 4');
2817: END IF;
2818: --bug#12916970
2819: QP_PREQ_GRP.engine_debug('operand_calculation_code-DK-'||g_limit_balance_line(j).operand_calculation_code);
2820: UPDATE qp_npreq_rltd_lines_tmp a

Line 2819: QP_PREQ_GRP.engine_debug('operand_calculation_code-DK-'||g_limit_balance_line(j).operand_calculation_code);

2815: IF l_debug = FND_API.G_TRUE THEN
2816: QP_PREQ_GRP.engine_debug('label 4');
2817: END IF;
2818: --bug#12916970
2819: QP_PREQ_GRP.engine_debug('operand_calculation_code-DK-'||g_limit_balance_line(j).operand_calculation_code);
2820: UPDATE qp_npreq_rltd_lines_tmp a
2821: SET a.operand = g_limit_balance_line(j).operand_value
2822: WHERE a.line_index = g_limit_balance_line(j).line_index
2823: AND a.list_line_id =

Line 2825: AND a.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

2821: SET a.operand = g_limit_balance_line(j).operand_value
2822: WHERE a.line_index = g_limit_balance_line(j).line_index
2823: AND a.list_line_id =
2824: g_limit_balance_line(j).list_line_id
2825: AND a.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2826: AND a.line_detail_index =
2827: g_limit_balance_line(j).line_detail_index;
2828:
2829: IF l_debug = FND_API.G_TRUE THEN

Line 2830: QP_PREQ_GRP.engine_debug('label 123-rows updated-'||sql%rowcount);

2826: AND a.line_detail_index =
2827: g_limit_balance_line(j).line_detail_index;
2828:
2829: IF l_debug = FND_API.G_TRUE THEN
2830: QP_PREQ_GRP.engine_debug('label 123-rows updated-'||sql%rowcount);
2831: END IF;
2832: --bug#12916970
2833: END IF;--If created_from_list_line_type = 'PBH'
2834:

Line 2836: QP_PREQ_GRP.engine_debug('line_index '||

2832: --bug#12916970
2833: END IF;--If created_from_list_line_type = 'PBH'
2834:
2835: IF l_debug = FND_API.G_TRUE THEN
2836: QP_PREQ_GRP.engine_debug('line_index '||
2837: g_limit_balance_line(j).line_index);
2838: QP_PREQ_GRP.engine_debug('limit_code '||
2839: g_limit_balance_line(j).limit_code);
2840: QP_PREQ_GRP.engine_debug('list_line_id '||

Line 2838: QP_PREQ_GRP.engine_debug('limit_code '||

2834:
2835: IF l_debug = FND_API.G_TRUE THEN
2836: QP_PREQ_GRP.engine_debug('line_index '||
2837: g_limit_balance_line(j).line_index);
2838: QP_PREQ_GRP.engine_debug('limit_code '||
2839: g_limit_balance_line(j).limit_code);
2840: QP_PREQ_GRP.engine_debug('list_line_id '||
2841: g_limit_balance_line(j).list_line_id);
2842: QP_PREQ_GRP.engine_debug('benefit_qty '||

Line 2840: QP_PREQ_GRP.engine_debug('list_line_id '||

2836: QP_PREQ_GRP.engine_debug('line_index '||
2837: g_limit_balance_line(j).line_index);
2838: QP_PREQ_GRP.engine_debug('limit_code '||
2839: g_limit_balance_line(j).limit_code);
2840: QP_PREQ_GRP.engine_debug('list_line_id '||
2841: g_limit_balance_line(j).list_line_id);
2842: QP_PREQ_GRP.engine_debug('benefit_qty '||
2843: g_limit_balance_line(j).benefit_qty);
2844: QP_PREQ_GRP.engine_debug('operand_value '||

Line 2842: QP_PREQ_GRP.engine_debug('benefit_qty '||

2838: QP_PREQ_GRP.engine_debug('limit_code '||
2839: g_limit_balance_line(j).limit_code);
2840: QP_PREQ_GRP.engine_debug('list_line_id '||
2841: g_limit_balance_line(j).list_line_id);
2842: QP_PREQ_GRP.engine_debug('benefit_qty '||
2843: g_limit_balance_line(j).benefit_qty);
2844: QP_PREQ_GRP.engine_debug('operand_value '||
2845: g_limit_balance_line(j).operand_value);
2846:

Line 2844: QP_PREQ_GRP.engine_debug('operand_value '||

2840: QP_PREQ_GRP.engine_debug('list_line_id '||
2841: g_limit_balance_line(j).list_line_id);
2842: QP_PREQ_GRP.engine_debug('benefit_qty '||
2843: g_limit_balance_line(j).benefit_qty);
2844: QP_PREQ_GRP.engine_debug('operand_value '||
2845: g_limit_balance_line(j).operand_value);
2846:
2847: END IF;
2848: /*

Line 2854: SET hold_code = DECODE(hold_code, QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, l_hold_code)

2850: */
2851: --sql statement upd9
2852:
2853: UPDATE qp_npreq_lines_tmp
2854: SET hold_code = DECODE(hold_code, QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, l_hold_code)
2855: WHERE line_index = g_limit_balance_line(j).line_index;
2856:
2857: IF g_limit_balance_line(j).transaction_amount is null THEN
2858:

Line 2860: QP_PREQ_GRP.engine_debug('transaction amount is null');

2856:
2857: IF g_limit_balance_line(j).transaction_amount is null THEN
2858:
2859: IF l_debug = FND_API.G_TRUE THEN
2860: QP_PREQ_GRP.engine_debug('transaction amount is null');
2861: END IF;
2862:
2863: IF l_debug = FND_API.G_TRUE THEN
2864: QP_PREQ_GRP.engine_debug('Inserting Into qp_limit_transactions');

Line 2864: QP_PREQ_GRP.engine_debug('Inserting Into qp_limit_transactions');

2860: QP_PREQ_GRP.engine_debug('transaction amount is null');
2861: END IF;
2862:
2863: IF l_debug = FND_API.G_TRUE THEN
2864: QP_PREQ_GRP.engine_debug('Inserting Into qp_limit_transactions');
2865: END IF;
2866:
2867: INSERT INTO qp_limit_transactions
2868: (

Line 2902: QP_PREQ_GRP.engine_debug('Updating qp_limit_transactions');

2898: ELSIF g_limit_balance_line(j).transaction_amount <>
2899: g_limit_balance_line(j).given_amount THEN
2900:
2901: IF l_debug = FND_API.G_TRUE THEN
2902: QP_PREQ_GRP.engine_debug('Updating qp_limit_transactions');
2903:
2904: END IF;
2905: /*
2906: INDX,qp_limit_balance_check_pvt.process_limits.upd10,QP_LIMIT_TRANSACTIONS_U1,PRICE_REQUEST_CODE,1

Line 2931: QP_PREQ_GRP.engine_debug('End Boundary condition processing');

2927:
2928: --Clear the global plsql table storing limits info.
2929: g_limit_balance_line.DELETE;
2930: IF l_debug = FND_API.G_TRUE THEN
2931: QP_PREQ_GRP.engine_debug('***End Boundary condition processing***');
2932: END IF;
2933: EXIT;
2934: END IF; --If Update_Balance returns Error
2935: END LOOP; --Boundary condition loop

Line 2940: QP_PREQ_GRP.engine_debug('End Process_Limits');

2936:
2937: END IF; --IF l_old_limit_rec.created_from_list_line_id >= 0
2938:
2939: IF l_debug = FND_API.G_TRUE THEN
2940: QP_PREQ_GRP.engine_debug('***End Process_Limits***');
2941:
2942: END IF;
2943: EXCEPTION
2944: WHEN FND_API.G_EXC_ERROR THEN

Line 2950: QP_PREQ_GRP.engine_debug('Expected Error in Process_Limits');

2946: x_return_status := FND_API.G_RET_STS_ERROR;
2947: --x_return_text is already set by Update_Balance
2948:
2949: IF l_debug = FND_API.G_TRUE THEN
2950: QP_PREQ_GRP.engine_debug('Expected Error in Process_Limits');
2951: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
2952:
2953: END IF;
2954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2951: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));

2947: --x_return_text is already set by Update_Balance
2948:
2949: IF l_debug = FND_API.G_TRUE THEN
2950: QP_PREQ_GRP.engine_debug('Expected Error in Process_Limits');
2951: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
2952:
2953: END IF;
2954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2955:

Line 2960: QP_PREQ_GRP.engine_debug('Unexpected Error in Process_Limits');

2956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2957: x_return_text := substr(sqlerrm, 1, 2000);
2958:
2959: IF l_debug = FND_API.G_TRUE THEN
2960: QP_PREQ_GRP.engine_debug('Unexpected Error in Process_Limits');
2961: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
2962:
2963: END IF;
2964: WHEN OTHERS THEN

Line 2961: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));

2957: x_return_text := substr(sqlerrm, 1, 2000);
2958:
2959: IF l_debug = FND_API.G_TRUE THEN
2960: QP_PREQ_GRP.engine_debug('Unexpected Error in Process_Limits');
2961: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
2962:
2963: END IF;
2964: WHEN OTHERS THEN
2965:

Line 2970: QP_PREQ_GRP.engine_debug('Other Error in Process_Limits');

2966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2967: x_return_text := substr(sqlerrm, 1, 2000);
2968:
2969: IF l_debug = FND_API.G_TRUE THEN
2970: QP_PREQ_GRP.engine_debug('Other Error in Process_Limits');
2971: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
2972:
2973: END IF;
2974: END Process_Limits;

Line 2971: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));

2967: x_return_text := substr(sqlerrm, 1, 2000);
2968:
2969: IF l_debug = FND_API.G_TRUE THEN
2970: QP_PREQ_GRP.engine_debug('Other Error in Process_Limits');
2971: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
2972:
2973: END IF;
2974: END Process_Limits;
2975: