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.OE_ORDER_GRP dependencies on OE_GLOBALS

Line 11: , p_control_rec IN OE_GLOBALS.Control_Rec_Type

7:
8: -- Local procedure: Control_Rec_For_Service_Level
9: PROCEDURE Control_Rec_For_Service_Level
10: ( p_api_service_level IN VARCHAR2
11: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
12: , p_validation_level IN VARCHAR2
13: , x_control_rec OUT NOCOPY /* file.sql.39 change */ OE_GLOBALS.Control_Rec_Type
14: , x_validation_level OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15: )

Line 13: , x_control_rec OUT NOCOPY /* file.sql.39 change */ OE_GLOBALS.Control_Rec_Type

9: PROCEDURE Control_Rec_For_Service_Level
10: ( p_api_service_level IN VARCHAR2
11: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
12: , p_validation_level IN VARCHAR2
13: , x_control_rec OUT NOCOPY /* file.sql.39 change */ OE_GLOBALS.Control_Rec_Type
14: , x_validation_level OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15: )
16: IS
17: BEGIN

Line 23: IF p_api_service_level = OE_GLOBALS.G_CHECK_SECURITY_ONLY THEN

19: IF p_control_rec.controlled_operation THEN
20: x_control_rec.process_partial := p_control_rec.process_partial;
21: END IF;
22:
23: IF p_api_service_level = OE_GLOBALS.G_CHECK_SECURITY_ONLY THEN
24:
25: x_control_rec.controlled_operation := TRUE;
26: x_control_rec.check_security := TRUE;
27: -- Bug 2988993 => clear_dependents should also be FALSE

Line 38: ELSIF p_api_service_level = OE_GLOBALS.G_VALIDATION_ONLY THEN

34: x_control_rec.process := FALSE;
35:
36: x_validation_level := FND_API.G_VALID_LEVEL_NONE;
37:
38: ELSIF p_api_service_level = OE_GLOBALS.G_VALIDATION_ONLY THEN
39:
40: x_control_rec.controlled_operation := TRUE;
41: x_control_rec.check_security := TRUE;
42: x_control_rec.default_attributes := TRUE;

Line 154: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=

150: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
151: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
152: , p_commit IN VARCHAR2 := FND_API.G_FALSE
153: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
154: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
155: OE_GLOBALS.G_MISS_CONTROL_REC
156: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE
157: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 155: OE_GLOBALS.G_MISS_CONTROL_REC

151: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
152: , p_commit IN VARCHAR2 := FND_API.G_FALSE
153: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
154: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
155: OE_GLOBALS.G_MISS_CONTROL_REC
156: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE
157: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
159: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 156: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE

152: , p_commit IN VARCHAR2 := FND_API.G_FALSE
153: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
154: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
155: OE_GLOBALS.G_MISS_CONTROL_REC
156: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE
157: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
159: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
160: , p_header_rec IN OE_Order_Pub.Header_Rec_Type :=

Line 296: l_control_rec OE_GLOBALS.Control_Rec_Type;

292: IS
293: l_org_id NUMBER; -- MOAC
294: l_api_version_number CONSTANT NUMBER := 1.0;
295: l_api_name CONSTANT VARCHAR2(30):= 'Process_Order';
296: l_control_rec OE_GLOBALS.Control_Rec_Type;
297: l_validation_level VARCHAR2(30);
298: l_return_status VARCHAR2(1);
299: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
300: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 344: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

340: RAISE FND_API.G_EXC_ERROR;
341: END IF;
342:
343: -- Bug 4129234/ orig bug 3823649 ReSet the Audit Trail Global variables
344: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
345: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
346:
347:
348: -- Bug 3013210 => set a savepoint so that rollbacks can be done for

Line 345: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';

341: END IF;
342:
343: -- Bug 4129234/ orig bug 3823649 ReSet the Audit Trail Global variables
344: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
345: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
346:
347:
348: -- Bug 3013210 => set a savepoint so that rollbacks can be done for
349: -- validation only service level call

Line 386: OE_GLOBALS.G_DEFAULT_REASON := TRUE;

382: IF p_control_rec.require_reason THEN
383: -- We are calling from Order Import, don't do anything.
384: NULL;
385: ELSE
386: OE_GLOBALS.G_DEFAULT_REASON := TRUE;
387: END IF;
388:
389:
390: -- Initialize the control record based on the api_service_level

Line 574: AND NOT OE_GLOBALS.Equal(x_Header_Payment_tbl(I).trxn_extension_id,FND_API.G_MISS_NUM) THEN --bug 5020737

570:
571: WHILE I IS NOT NULL LOOP
572: IF x_Header_Payment_tbl(I).payment_type_code = 'CREDIT_CARD'
573: AND x_Header_Payment_tbl(I).trxn_extension_id IS NOT NULL
574: AND NOT OE_GLOBALS.Equal(x_Header_Payment_tbl(I).trxn_extension_id,FND_API.G_MISS_NUM) THEN --bug 5020737
575: x_header_rec.credit_card_number := null;
576: x_header_rec.credit_card_code := null;
577: x_header_rec.credit_card_holder_name := null;
578: x_header_rec.credit_card_expiration_date := null;

Line 586: OE_GLOBALS.g_validate_desc_flex := p_validate_desc_flex ;--bug4343612

582:
583: I := x_Header_Payment_tbl.NEXT(I);
584: END LOOP;
585:
586: OE_GLOBALS.g_validate_desc_flex := p_validate_desc_flex ;--bug4343612
587:
588: -- sol_ord_er #16014165 start
589: /* System Parameter "OM: Subscription Item Line Behavior" needs to be honored only from UI */
590: If x_line_tbl.count > 0 THEN

Line 593: If (x_line_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE

589: /* System Parameter "OM: Subscription Item Line Behavior" needs to be honored only from UI */
590: If x_line_tbl.count > 0 THEN
591: For i in x_line_tbl.first .. x_line_tbl.last
592: LOOP
593: If (x_line_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE
594: or x_line_tbl(i).operation = OE_GLOBALS.G_OPR_INSERT)
595: AND NVL(x_line_tbl(i).subscription_enable_flag,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
596: x_line_tbl(i).subscription_enable_flag := 'N';
597: End If;

Line 594: or x_line_tbl(i).operation = OE_GLOBALS.G_OPR_INSERT)

590: If x_line_tbl.count > 0 THEN
591: For i in x_line_tbl.first .. x_line_tbl.last
592: LOOP
593: If (x_line_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE
594: or x_line_tbl(i).operation = OE_GLOBALS.G_OPR_INSERT)
595: AND NVL(x_line_tbl(i).subscription_enable_flag,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
596: x_line_tbl(i).subscription_enable_flag := 'N';
597: End If;
598: End LOOP;

Line 694: IF p_api_service_level = OE_GLOBALS.G_VALIDATION_ONLY THEN

690:
691: -- Bug 3013210 => if service level is validation only, rollback any
692: -- DB writes and also clear delayed requests
693:
694: IF p_api_service_level = OE_GLOBALS.G_VALIDATION_ONLY THEN
695:
696: ROLLBACK TO SAVEPOINT Group_Process_Order;
697:
698: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);

Line 2137: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=

2133: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2134: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
2135: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2136: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2137: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
2138: OE_GLOBALS.G_MISS_CONTROL_REC
2139: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE
2140: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2141: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 2138: OE_GLOBALS.G_MISS_CONTROL_REC

2134: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
2135: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2136: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2137: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
2138: OE_GLOBALS.G_MISS_CONTROL_REC
2139: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE
2140: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2141: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2142: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 2139: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE

2135: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2136: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2137: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
2138: OE_GLOBALS.G_MISS_CONTROL_REC
2139: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE
2140: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2141: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2142: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2143: , p_header_rec IN OE_Order_Pub.Header_Rec_Type :=

Line 2258: l_control_rec OE_GLOBALS.Control_Rec_Type;

2254: )
2255: IS
2256: l_api_version_number CONSTANT NUMBER := 1.0;
2257: l_api_name CONSTANT VARCHAR2(30):= 'Process_Order';
2258: l_control_rec OE_GLOBALS.Control_Rec_Type;
2259: l_validation_level VARCHAR2(30);
2260: l_return_status VARCHAR2(1);
2261: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2262: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 2791: IF p_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND

2787: -- Retrieve the sold_to_org_id if not passed on the header record. This
2788: -- will be needed by the value_to_id functions for related fields.
2789: -- For e.g. oe_value_to_id.ship_to_org_id requires sold_to_org_id
2790:
2791: IF p_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
2792: p_header_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
2793:
2794: IF l_debug_level > 0 THEN
2795: oe_debug_pub.add('AAC: Selecting Customer Based on old sold_to_org_id');