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.18.12020000.3 2012/08/28 09:08:01 dnema 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.18.12020000.3 2012/08/28 09:08:01 dnema 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 193: , 'QP_Delayed_Requests_Util');

189: x_return_status := FND_API.G_RET_STS_ERROR;
190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
191: OE_MSG_PUB.Add_Exc_Msg
192: ( G_PKG_NAME
193: , 'QP_Delayed_Requests_Util');
194: END IF;
195: END Update_Qualifier_Status;
196:
197: Procedure Create_Security_Privilege(p_list_header_id in NUMBER,

Line 231: , 'QP_Delayed_Requests_Util');

227: x_return_status := FND_API.G_RET_STS_ERROR;
228: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
229: OE_MSG_PUB.Add_Exc_Msg
230: ( G_PKG_NAME
231: , 'QP_Delayed_Requests_Util');
232: END IF;
233: END Create_Security_Privilege;
234:
235: Procedure Update_Attribute_Status(p_list_header_id in NUMBER,

Line 293: , 'QP_Delayed_Requests_Util');

289: x_return_status := FND_API.G_RET_STS_ERROR;
290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
291: OE_MSG_PUB.Add_Exc_Msg
292: ( G_PKG_NAME
293: , 'QP_Delayed_Requests_Util');
294: END IF;
295: END Update_Attribute_Status;
296:
297:

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

310: l_rows number := 0;
311: l_effdates boolean := FALSE;
312: BEGIN
313:
314: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check_duplicate_modifier_lines');
315:
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
317:
318: l_status := QP_VALIDATE_PRICING_ATTR.Mod_Dup(p_Start_Date_Active,

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

338: END IF;
339:
340:
341:
342: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.mod_dup');
343:
344:
345: EXCEPTION
346:

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

384: l_effdates boolean := FALSE;
385: l_blank_text VARCHAR2(2000);
386: BEGIN
387:
388: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.check_duplicate_list_lines');
389:
390: x_return_status := FND_API.G_RET_STS_SUCCESS;
391:
392: l_status := QP_VALIDATE_PLL_PRICING_ATTR.Check_Dup_Pra(p_Start_Date_Active,

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

450: END IF;
451:
452: END IF;
453:
454: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
455:
456:
457: EXCEPTION
458:

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

518: l_parent varchar2(30);
519:
520: BEGIN
521:
522: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');
523: oe_debug_pub.add('passed rule id is'||p_list_line_id);
524:
525: --dbms_output.put_line('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');
526: --dbms_output.put_line('passed rule id is'||p_list_line_id);

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

521:
522: oe_debug_pub.add('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');
523: oe_debug_pub.add('passed rule id is'||p_list_line_id);
524:
525: --dbms_output.put_line('Entering QP_DELAYED_REQUESTS_UTIL.validate_pbh_line');
526: --dbms_output.put_line('passed rule id is'||p_list_line_id);
527:
528:
529: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

577: END IF;
578: RAISE NO_CHILD_EXCEPTION;
579: END IF;
580:
581: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.validate pbh');
582: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.validate pbh');
583: else
584:
585: null;

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

578: RAISE NO_CHILD_EXCEPTION;
579: END IF;
580:
581: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.validate pbh');
582: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.validate pbh');
583: else
584:
585: null;
586: oe_debug_pub.add('Exiting no parent found');

Line 614: , 'QP_Delayed_Requests_Util'

610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
611: THEN
612: OE_MSG_PUB.Add_Exc_Msg
613: ( G_PKG_NAME
614: , 'QP_Delayed_Requests_Util'
615: );
616: END IF;
617:
618: End Validate_Lines_For_Child;

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

698: END IF;
699: Raise OVERLAPPING_BREAKS_EXCEPTION;
700: END IF;
701:
702: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.overlapping breaks');
703: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.overlapping breaks');
704:
705: EXCEPTION
706: WHEN NO_DATA_FOUND THEN

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

699: Raise OVERLAPPING_BREAKS_EXCEPTION;
700: END IF;
701:
702: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.overlapping breaks');
703: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.overlapping breaks');
704:
705: EXCEPTION
706: WHEN NO_DATA_FOUND THEN
707: NULL;

Line 730: , 'QP_Delayed_Requests_Util'

726: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
727: THEN
728: OE_MSG_PUB.Add_Exc_Msg
729: ( G_PKG_NAME
730: , 'QP_Delayed_Requests_Util'
731: );
732: END IF;
733: End Check_For_Overlapping_breaks;
734:

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

816: Raise CONTINUOUS_BREAKS_EXCEPTION;
817: END IF;
818: END IF;
819:
820: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.Check_Continuous_Price_Breaks');
821:
822: EXCEPTION
823: WHEN NO_DATA_FOUND THEN
824: NULL;

Line 847: , 'QP_Delayed_Requests_Util'

843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
844: THEN
845: OE_MSG_PUB.Add_Exc_Msg
846: ( G_PKG_NAME
847: , 'QP_Delayed_Requests_Util'
848: );
849: END IF;
850: End Check_Continuous_Price_Breaks;
851:

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

936: raise UPGRADE_PRICE_BREAKS_EXCEPTION;
937: END;
938: END LOOP;
939:
940: --oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.Upgrade_Price_Breaks');
941:
942: EXCEPTION
943:
944: WHEN UPGRADE_PRICE_BREAKS_EXCEPTION

Line 965: , 'QP_Delayed_Requests_Util'

961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
962: THEN
963: OE_MSG_PUB.Add_Exc_Msg
964: ( G_PKG_NAME
965: , 'QP_Delayed_Requests_Util'
966: );
967: END IF;
968:
969: END Upgrade_Price_Breaks;

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

1159: END IF;
1160: RAISE MULTIPLE_PRICE_LIST_EXCEPTION;
1161: END IF;
1162:
1163: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
1164: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
1165:
1166: EXCEPTION
1167: WHEN MULTIPLE_PRICE_LIST_EXCEPTION

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

1160: RAISE MULTIPLE_PRICE_LIST_EXCEPTION;
1161: END IF;
1162:
1163: oe_debug_pub.add('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
1164: --dbms_output.put_line('Exiting QP_DELAYED_REQUESTS_UTIL.checkdup');
1165:
1166: EXCEPTION
1167: WHEN MULTIPLE_PRICE_LIST_EXCEPTION
1168: THEN

Line 1187: , 'QP_Delayed_Requests_Util'

1183: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1184: THEN
1185: OE_MSG_PUB.Add_Exc_Msg
1186: ( G_PKG_NAME
1187: , 'QP_Delayed_Requests_Util'
1188: );
1189: END IF;
1190:
1191: END Check_multiple_prl;

Line 2993: END QP_Delayed_Requests_UTIL;

2989: WHEN OTHERS THEN
2990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2991: END Check_Enabled_Func_Areas;
2992:
2993: END QP_Delayed_Requests_UTIL;