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_DELAYED_REQUESTS_UTIL dependencies on QP_DELAYED_REQUESTS_UTIL

Line 1: PACKAGE BODY QP_Delayed_Requests_UTIL AS

1: PACKAGE BODY QP_Delayed_Requests_UTIL AS
2: /* $Header: QPXUREQB.pls 120.14.12010000.2 2008/08/20 10:02:22 smuhamme ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Delayed_Requests_UTIL';

2: /* $Header: QPXUREQB.pls 120.14.12010000.2 2008/08/20 10:02:22 smuhamme ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Delayed_Requests_UTIL';
7:
8:
9: Procedure Check_For_Duplicate_Qualifiers
10: ( x_return_status OUT NOCOPY Varchar2

Line 27: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check dup');

23: and a.qualifier_id <> b.qualifier_id;
24:
25: BEGIN
26:
27: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check dup');
28: oe_debug_pub.add('passed rule id is'||p_qualifier_rule_id);
29: --dbms_output.put_line('Entering QP_DELAYED_REQUESTS_UTIL.check dup');
30: --dbms_output.put_line('passed rule id is'||p_qualifier_rule_id);
31:

Line 29: --dbms_output.put_line('Entering QP_DELAYED_REQUESTS_UTIL.check dup');

25: BEGIN
26:
27: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check dup');
28: oe_debug_pub.add('passed rule id is'||p_qualifier_rule_id);
29: --dbms_output.put_line('Entering QP_DELAYED_REQUESTS_UTIL.check dup');
30: --dbms_output.put_line('passed rule id is'||p_qualifier_rule_id);
31:
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33: open C_Qualifiers(p_qualifier_rule_id);

Line 53: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');

49: END IF;
50: RAISE DUPLICATE_DISCOUNT;
51: END IF;
52:
53: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
54: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
55:
56: EXCEPTION
57: WHEN DUPLICATE_DISCOUNT

Line 54: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');

50: RAISE DUPLICATE_DISCOUNT;
51: END IF;
52:
53: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
54: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
55:
56: EXCEPTION
57: WHEN DUPLICATE_DISCOUNT
58: THEN

Line 77: , 'QP_Delayed_Requests_Util'

73: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
74: THEN
75: OE_MSG_PUB.Add_Exc_Msg
76: ( G_PKG_NAME
77: , 'QP_Delayed_Requests_Util'
78: );
79: END IF;
80: END Check_For_Duplicate_Qualifiers;
81:

Line 185: , 'QP_Delayed_Requests_Util');

181: x_return_status := FND_API.G_RET_STS_ERROR;
182: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
183: OE_MSG_PUB.Add_Exc_Msg
184: ( G_PKG_NAME
185: , 'QP_Delayed_Requests_Util');
186: END IF;
187: END Update_Qualifier_Status;
188:
189: Procedure Create_Security_Privilege(p_list_header_id in NUMBER,

Line 223: , 'QP_Delayed_Requests_Util');

219: x_return_status := FND_API.G_RET_STS_ERROR;
220: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
221: OE_MSG_PUB.Add_Exc_Msg
222: ( G_PKG_NAME
223: , 'QP_Delayed_Requests_Util');
224: END IF;
225: END Create_Security_Privilege;
226:
227: Procedure Update_Attribute_Status(p_list_header_id in NUMBER,

Line 285: , 'QP_Delayed_Requests_Util');

281: x_return_status := FND_API.G_RET_STS_ERROR;
282: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
283: OE_MSG_PUB.Add_Exc_Msg
284: ( G_PKG_NAME
285: , 'QP_Delayed_Requests_Util');
286: END IF;
287: END Update_Attribute_Status;
288:
289:

Line 306: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check_duplicate_modifier_lines');

302: l_rows number := 0;
303: l_effdates boolean := FALSE;
304: BEGIN
305:
306: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check_duplicate_modifier_lines');
307:
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309:
310: l_status := QP_VALIDATE_PRICING_ATTR.Mod_Dup(p_Start_Date_Active,

Line 334: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.mod_dup');

330: END IF;
331:
332:
333:
334: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.mod_dup');
335:
336:
337: EXCEPTION
338:

Line 380: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check_duplicate_list_lines');

376: l_effdates boolean := FALSE;
377: l_blank_text VARCHAR2(2000);
378: BEGIN
379:
380: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check_duplicate_list_lines');
381:
382: x_return_status := FND_API.G_RET_STS_SUCCESS;
383:
384: l_status := QP_VALIDATE_PLL_PRICING_ATTR.Check_Dup_Pra(p_Start_Date_Active,

Line 446: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');

442: END IF;
443:
444: END IF;
445:
446: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
447:
448:
449: EXCEPTION
450:

Line 514: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');

510: l_parent varchar2(30);
511:
512: BEGIN
513:
514: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');
515: oe_debug_pub.add('passed rule id is'||p_list_line_id);
516:
517: --dbms_output.put_line('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');
518: --dbms_output.put_line('passed rule id is'||p_list_line_id);

Line 517: --dbms_output.put_line('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');

513:
514: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');
515: oe_debug_pub.add('passed rule id is'||p_list_line_id);
516:
517: --dbms_output.put_line('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');
518: --dbms_output.put_line('passed rule id is'||p_list_line_id);
519:
520:
521: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 573: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.validate pbh');

569: END IF;
570: RAISE NO_CHILD_EXCEPTION;
571: END IF;
572:
573: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.validate pbh');
574: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.validate pbh');
575: else
576:
577: null;

Line 574: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.validate pbh');

570: RAISE NO_CHILD_EXCEPTION;
571: END IF;
572:
573: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.validate pbh');
574: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.validate pbh');
575: else
576:
577: null;
578: oe_debug_pub.add('Exiting no parent found');

Line 606: , 'QP_Delayed_Requests_Util'

602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
603: THEN
604: OE_MSG_PUB.Add_Exc_Msg
605: ( G_PKG_NAME
606: , 'QP_Delayed_Requests_Util'
607: );
608: END IF;
609:
610: End Validate_Lines_For_Child;

Line 694: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.overlapping breaks');

690: END IF;
691: Raise OVERLAPPING_BREAKS_EXCEPTION;
692: END IF;
693:
694: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.overlapping breaks');
695: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.overlapping breaks');
696:
697: EXCEPTION
698: WHEN NO_DATA_FOUND THEN

Line 695: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.overlapping breaks');

691: Raise OVERLAPPING_BREAKS_EXCEPTION;
692: END IF;
693:
694: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.overlapping breaks');
695: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.overlapping breaks');
696:
697: EXCEPTION
698: WHEN NO_DATA_FOUND THEN
699: NULL;

Line 722: , 'QP_Delayed_Requests_Util'

718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
719: THEN
720: OE_MSG_PUB.Add_Exc_Msg
721: ( G_PKG_NAME
722: , 'QP_Delayed_Requests_Util'
723: );
724: END IF;
725: End Check_For_Overlapping_breaks;
726:

Line 812: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.Check_Continuous_Price_Breaks');

808: Raise CONTINUOUS_BREAKS_EXCEPTION;
809: END IF;
810: END IF;
811:
812: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.Check_Continuous_Price_Breaks');
813:
814: EXCEPTION
815: WHEN NO_DATA_FOUND THEN
816: NULL;

Line 839: , 'QP_Delayed_Requests_Util'

835: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
836: THEN
837: OE_MSG_PUB.Add_Exc_Msg
838: ( G_PKG_NAME
839: , 'QP_Delayed_Requests_Util'
840: );
841: END IF;
842: End Check_Continuous_Price_Breaks;
843:

Line 932: --oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.Upgrade_Price_Breaks');

928: raise UPGRADE_PRICE_BREAKS_EXCEPTION;
929: END;
930: END LOOP;
931:
932: --oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.Upgrade_Price_Breaks');
933:
934: EXCEPTION
935:
936: WHEN UPGRADE_PRICE_BREAKS_EXCEPTION

Line 957: , 'QP_Delayed_Requests_Util'

953: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
954: THEN
955: OE_MSG_PUB.Add_Exc_Msg
956: ( G_PKG_NAME
957: , 'QP_Delayed_Requests_Util'
958: );
959: END IF;
960:
961: END Upgrade_Price_Breaks;

Line 1155: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');

1151: END IF;
1152: RAISE MULTIPLE_PRICE_LIST_EXCEPTION;
1153: END IF;
1154:
1155: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
1156: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
1157:
1158: EXCEPTION
1159: WHEN MULTIPLE_PRICE_LIST_EXCEPTION

Line 1156: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');

1152: RAISE MULTIPLE_PRICE_LIST_EXCEPTION;
1153: END IF;
1154:
1155: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
1156: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
1157:
1158: EXCEPTION
1159: WHEN MULTIPLE_PRICE_LIST_EXCEPTION
1160: THEN

Line 1179: , 'QP_Delayed_Requests_Util'

1175: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1176: THEN
1177: OE_MSG_PUB.Add_Exc_Msg
1178: ( G_PKG_NAME
1179: , 'QP_Delayed_Requests_Util'
1180: );
1181: END IF;
1182:
1183: END Check_multiple_prl;

Line 2958: END QP_Delayed_Requests_UTIL;

2954: WHEN OTHERS THEN
2955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2956: END Check_Enabled_Func_Areas;
2957:
2958: END QP_Delayed_Requests_UTIL;