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_DELAYED_REQUESTS_PVT dependencies on FND_API

Line 14: return the result in p_request_search_result which is set to FND_API.G_TRUE

10: G_MAX_REQUESTS NUMBER := 10000;
11:
12: /* Local Procedures */
13: /* Local procedure to check if a request exists for a given entity, request
14: return the result in p_request_search_result which is set to FND_API.G_TRUE
15: if the request exists. The index of the request in request table is returned
16: in parameter x_request_ind
17:
18: BUG 1794544 -

Line 29: If the request does NOT exist, then x_result is set to FND_API.G_FALSE

25: generated sequentially). Therefore, this check would search only
26: through requests for the entity_id that resolves to the same
27: mod value.
28:
29: If the request does NOT exist, then x_result is set to FND_API.G_FALSE
30: and the parameter x_request_ind has the index value where this request
31: should be inserted.
32: */
33:

Line 66: x_return_status := FND_API.G_RET_STS_SUCCESS;

62: --
63: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
64: --
65: BEGIN
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67: x_result := FND_API.G_FALSE;
68: IF l_debug_level > 0 THEN
69: oe_debug_pub.add('Entering Procedure Check_for_Request in Package OE_Delayed_Requests_Pvt');
70: END IF;

Line 67: x_result := FND_API.G_FALSE;

63: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
64: --
65: BEGIN
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67: x_result := FND_API.G_FALSE;
68: IF l_debug_level > 0 THEN
69: oe_debug_pub.add('Entering Procedure Check_for_Request in Package OE_Delayed_Requests_Pvt');
70: END IF;
71: -- l_ind to l_max_ind is the range of index positions that can

Line 108: NVL(G_Delayed_Requests(l_ind).request_unique_key1, FND_API.G_MISS_CHAR) =

104: G_Delayed_Requests(l_ind).Entity_id = p_entity_id
105: AND
106: G_Delayed_Requests(l_ind).Request_Type = p_request_type
107: AND
108: NVL(G_Delayed_Requests(l_ind).request_unique_key1, FND_API.G_MISS_CHAR) =
109: NVL(p_request_unique_key1, FND_API.G_MISS_CHAR)
110: AND
111: NVL(G_Delayed_Requests(l_ind).request_unique_key2, FND_API.G_MISS_CHAR) =
112: NVL(p_request_unique_key2, FND_API.G_MISS_CHAR)

Line 109: NVL(p_request_unique_key1, FND_API.G_MISS_CHAR)

105: AND
106: G_Delayed_Requests(l_ind).Request_Type = p_request_type
107: AND
108: NVL(G_Delayed_Requests(l_ind).request_unique_key1, FND_API.G_MISS_CHAR) =
109: NVL(p_request_unique_key1, FND_API.G_MISS_CHAR)
110: AND
111: NVL(G_Delayed_Requests(l_ind).request_unique_key2, FND_API.G_MISS_CHAR) =
112: NVL(p_request_unique_key2, FND_API.G_MISS_CHAR)
113: AND

Line 111: NVL(G_Delayed_Requests(l_ind).request_unique_key2, FND_API.G_MISS_CHAR) =

107: AND
108: NVL(G_Delayed_Requests(l_ind).request_unique_key1, FND_API.G_MISS_CHAR) =
109: NVL(p_request_unique_key1, FND_API.G_MISS_CHAR)
110: AND
111: NVL(G_Delayed_Requests(l_ind).request_unique_key2, FND_API.G_MISS_CHAR) =
112: NVL(p_request_unique_key2, FND_API.G_MISS_CHAR)
113: AND
114: NVL(G_Delayed_Requests(l_ind).request_unique_key3, FND_API.G_MISS_CHAR) =
115: NVL(p_request_unique_key3, FND_API.G_MISS_CHAR)

Line 112: NVL(p_request_unique_key2, FND_API.G_MISS_CHAR)

108: NVL(G_Delayed_Requests(l_ind).request_unique_key1, FND_API.G_MISS_CHAR) =
109: NVL(p_request_unique_key1, FND_API.G_MISS_CHAR)
110: AND
111: NVL(G_Delayed_Requests(l_ind).request_unique_key2, FND_API.G_MISS_CHAR) =
112: NVL(p_request_unique_key2, FND_API.G_MISS_CHAR)
113: AND
114: NVL(G_Delayed_Requests(l_ind).request_unique_key3, FND_API.G_MISS_CHAR) =
115: NVL(p_request_unique_key3, FND_API.G_MISS_CHAR)
116: AND

Line 114: NVL(G_Delayed_Requests(l_ind).request_unique_key3, FND_API.G_MISS_CHAR) =

110: AND
111: NVL(G_Delayed_Requests(l_ind).request_unique_key2, FND_API.G_MISS_CHAR) =
112: NVL(p_request_unique_key2, FND_API.G_MISS_CHAR)
113: AND
114: NVL(G_Delayed_Requests(l_ind).request_unique_key3, FND_API.G_MISS_CHAR) =
115: NVL(p_request_unique_key3, FND_API.G_MISS_CHAR)
116: AND
117: NVL(G_Delayed_Requests(l_ind).request_unique_key4, FND_API.G_MISS_CHAR) =
118: NVL(p_request_unique_key4, FND_API.G_MISS_CHAR)

Line 115: NVL(p_request_unique_key3, FND_API.G_MISS_CHAR)

111: NVL(G_Delayed_Requests(l_ind).request_unique_key2, FND_API.G_MISS_CHAR) =
112: NVL(p_request_unique_key2, FND_API.G_MISS_CHAR)
113: AND
114: NVL(G_Delayed_Requests(l_ind).request_unique_key3, FND_API.G_MISS_CHAR) =
115: NVL(p_request_unique_key3, FND_API.G_MISS_CHAR)
116: AND
117: NVL(G_Delayed_Requests(l_ind).request_unique_key4, FND_API.G_MISS_CHAR) =
118: NVL(p_request_unique_key4, FND_API.G_MISS_CHAR)
119: AND

Line 117: NVL(G_Delayed_Requests(l_ind).request_unique_key4, FND_API.G_MISS_CHAR) =

113: AND
114: NVL(G_Delayed_Requests(l_ind).request_unique_key3, FND_API.G_MISS_CHAR) =
115: NVL(p_request_unique_key3, FND_API.G_MISS_CHAR)
116: AND
117: NVL(G_Delayed_Requests(l_ind).request_unique_key4, FND_API.G_MISS_CHAR) =
118: NVL(p_request_unique_key4, FND_API.G_MISS_CHAR)
119: AND
120: NVL(G_Delayed_Requests(l_ind).request_unique_key5, FND_API.G_MISS_CHAR) =
121: NVL(p_request_unique_key5, FND_API.G_MISS_CHAR)

Line 118: NVL(p_request_unique_key4, FND_API.G_MISS_CHAR)

114: NVL(G_Delayed_Requests(l_ind).request_unique_key3, FND_API.G_MISS_CHAR) =
115: NVL(p_request_unique_key3, FND_API.G_MISS_CHAR)
116: AND
117: NVL(G_Delayed_Requests(l_ind).request_unique_key4, FND_API.G_MISS_CHAR) =
118: NVL(p_request_unique_key4, FND_API.G_MISS_CHAR)
119: AND
120: NVL(G_Delayed_Requests(l_ind).request_unique_key5, FND_API.G_MISS_CHAR) =
121: NVL(p_request_unique_key5, FND_API.G_MISS_CHAR)
122: AND NVL(G_Delayed_Requests(l_ind).processed,'N') = 'N'

Line 120: NVL(G_Delayed_Requests(l_ind).request_unique_key5, FND_API.G_MISS_CHAR) =

116: AND
117: NVL(G_Delayed_Requests(l_ind).request_unique_key4, FND_API.G_MISS_CHAR) =
118: NVL(p_request_unique_key4, FND_API.G_MISS_CHAR)
119: AND
120: NVL(G_Delayed_Requests(l_ind).request_unique_key5, FND_API.G_MISS_CHAR) =
121: NVL(p_request_unique_key5, FND_API.G_MISS_CHAR)
122: AND NVL(G_Delayed_Requests(l_ind).processed,'N') = 'N'
123: THEN
124: x_request_ind := l_ind;

Line 121: NVL(p_request_unique_key5, FND_API.G_MISS_CHAR)

117: NVL(G_Delayed_Requests(l_ind).request_unique_key4, FND_API.G_MISS_CHAR) =
118: NVL(p_request_unique_key4, FND_API.G_MISS_CHAR)
119: AND
120: NVL(G_Delayed_Requests(l_ind).request_unique_key5, FND_API.G_MISS_CHAR) =
121: NVL(p_request_unique_key5, FND_API.G_MISS_CHAR)
122: AND NVL(G_Delayed_Requests(l_ind).processed,'N') = 'N'
123: THEN
124: x_request_ind := l_ind;
125: x_result := FND_API.G_TRUE;

Line 125: x_result := FND_API.G_TRUE;

121: NVL(p_request_unique_key5, FND_API.G_MISS_CHAR)
122: AND NVL(G_Delayed_Requests(l_ind).processed,'N') = 'N'
123: THEN
124: x_request_ind := l_ind;
125: x_result := FND_API.G_TRUE;
126: EXIT;
127: END IF;
128:
129: l_ind := G_Delayed_Requests.Next(l_ind);

Line 136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

132:
133: IF x_request_ind > l_max_ind THEN
134: FND_MESSAGE.SET_NAME('ONT','OE_MAX_REQUESTS_EXCEEDED');
135: OE_MSG_PUB.ADD;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137: END IF;
138:
139: EXCEPTION
140: WHEN OTHERS THEN

Line 147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

143: OE_MSG_PUB.Add_Exc_Msg
144: (G_PKG_NAME
145: ,'CheckForRequest');
146: END IF;
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148:
149: End Check_For_Request;
150:
151: FUNCTION Requests_Count

Line 162: ,p_delete IN Varchar2 default FND_API.G_FALSE

158: END Requests_Count;
159:
160: PROCEDURE Process_Request_Pvt
161: (p_request_ind IN Number
162: ,p_delete IN Varchar2 default FND_API.G_FALSE
163: ,x_return_status OUT NOCOPY VARCHAR2)
164:
165: IS
166: cursor included_lines_cur(p_header_id in number) is

Line 239: x_return_status := FND_API.G_RET_STS_SUCCESS;

235: oe_debug_pub.add( 'EXIT Procedure Process_Request_Pvt' , 1 ) ;
236: END IF;
237: RETURN;
238: END IF;
239: x_return_status := FND_API.G_RET_STS_SUCCESS;
240:
241:
242: -- if request has already been processed ('Y') or if the request is
243: -- being processed ('I'): this would occur if request resulted in

Line 364: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)

360: BEGIN
361:
362: IF OE_Order_Cache.g_header_rec.order_type_id is not null THEN
363:
364: IF (OE_Order_Cache.g_order_type_rec.order_type_id = FND_API.G_MISS_NUM)
365: OR (OE_Order_Cache.g_order_type_rec.order_type_id is null)
366: OR (OE_Order_Cache.g_order_type_rec.order_type_id <> OE_Order_Cache.g_header_rec.Order_Type_id)
367: THEN
368: OE_Order_Cache.Load_Order_type(OE_Order_CACHE.g_header_rec.Order_Type_id) ;

Line 801: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

797:
798: ELSIF l_request_type = OE_GLOBALS.G_DROPSHIP_CMS THEN
799: RETURN;
800:
801: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;

Line 802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

798: ELSIF l_request_type = OE_GLOBALS.G_DROPSHIP_CMS THEN
799: RETURN;
800:
801: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;
806: ELSIF l_request_type = OE_GLOBALS.G_UPDATE_OPTION THEN

Line 803: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

799: RETURN;
800:
801: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;
806: ELSIF l_request_type = OE_GLOBALS.G_UPDATE_OPTION THEN
807: IF l_debug_level > 0 THEN

Line 804: RAISE FND_API.G_EXC_ERROR;

800:
801: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;
806: ELSIF l_request_type = OE_GLOBALS.G_UPDATE_OPTION THEN
807: IF l_debug_level > 0 THEN
808: oe_debug_pub.add('upd: processed with cfg val', 3);

Line 871: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

867: IF l_debug_level > 0 THEN
868: oe_debug_pub.add('ret sts: '|| x_return_status, 4);
869: END IF;
870:
871: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
872: oe_debug_pub.add('deleteing after success ', 3);
873: K := G_Delayed_Requests.FIRST;
874:
875: WHILE K is not null

Line 1008: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1004: , p_split_tbl => l_cto_split_tbl
1005: , p_decimal_tbl => l_cto_decimal_tbl
1006: , x_return_status => l_return_status);
1007:
1008: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1009: IF l_debug_level > 0 THEN
1010: oe_debug_pub.add('deleteing after success ', 3);
1011: END IF;
1012: K := G_Delayed_Requests.FIRST;

Line 1053: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1049: OE_GROUP_SCH_UTIL.Group_Schedule_sets
1050: ( p_sch_set_tbl => l_sch_set_tbl
1051: , x_return_status => l_return_status);
1052:
1053: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1054:
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056:
1057: END IF;

Line 1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1051: , x_return_status => l_return_status);
1052:
1053: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1054:
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056:
1057: END IF;
1058:
1059: K := G_Delayed_Requests.FIRST;

Line 1106: IF l_return_status <> FND_API.G_RET_STS_UNEXP_ERROR

1102:
1103: IF G_Delayed_Requests(K).request_type =
1104: OE_GLOBALS.G_SPLIT_SCHEDULE
1105: THEN
1106: IF l_return_status <> FND_API.G_RET_STS_UNEXP_ERROR
1107: THEN
1108: g_delayed_requests(K).processed := 'Y';
1109: ELSE
1110: g_delayed_requests(K).processed := Null;

Line 1567: AND l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1563: oe_debug_pub.add('Group Schedule Return Status ' || l_return_status,1);
1564: END IF;
1565: --11825106
1566: IF nvl(oe_sys_parameters.Value('ONT_AUTO_SCH_SETS'),'Y') = 'N'
1567: AND l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1568: -- Ignore Scheduling Failure
1569: l_return_status := FND_API.G_RET_STS_SUCCESS;
1570: oe_schedule_util.OESCH_SET_SCHEDULING := 'N';
1571: ELSE

Line 1569: l_return_status := FND_API.G_RET_STS_SUCCESS;

1565: --11825106
1566: IF nvl(oe_sys_parameters.Value('ONT_AUTO_SCH_SETS'),'Y') = 'N'
1567: AND l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1568: -- Ignore Scheduling Failure
1569: l_return_status := FND_API.G_RET_STS_SUCCESS;
1570: oe_schedule_util.OESCH_SET_SCHEDULING := 'N';
1571: ELSE
1572: oe_schedule_util.OESCH_SET_SCHEDULING := 'Y';
1573: END IF;

Line 1655: IF l_return_status <> FND_API.G_RET_STS_UNEXP_ERROR

1651: OE_GLOBALS.G_RESCHEDULE_LINE) AND
1652: G_Delayed_Requests(K).param1 = l_set
1653: THEN
1654: l_index := l_index + 1;
1655: IF l_return_status <> FND_API.G_RET_STS_UNEXP_ERROR
1656: THEN
1657: g_delayed_requests(K).processed := 'Y';
1658: ELSE
1659: g_delayed_requests(K).processed := Null;

Line 1910: p_delayed_request=> FND_API.G_TRUE,

1906: OE_PREPAYMENT_PVT.Process_Payments(
1907: p_header_id => l_request_rec.entity_id,
1908: p_calling_action => 'UPDATE',
1909: p_amount => null,
1910: p_delayed_request=> FND_API.G_TRUE,
1911: x_msg_data => l_msg_data,
1912: x_msg_count => l_msg_count,
1913: x_return_status => l_return_status);
1914: --bug3507871 end

Line 1929: p_delayed_request=> FND_API.G_TRUE,

1925: OE_PREPAYMENT_PVT.Process_Payments(
1926: p_header_id => l_request_rec.entity_id,
1927: p_calling_action => null,
1928: p_amount => null,
1929: p_delayed_request=> FND_API.G_TRUE,
1930: p_process_prepayment=>'N',
1931: p_process_authorization=>'N',
1932: x_msg_data => l_msg_data,
1933: x_msg_count => l_msg_count,

Line 1945: p_delayed_request=> FND_API.G_TRUE,

1941: p_header_id => l_request_rec.entity_id,
1942: p_line_id => l_request_rec.param1,
1943: p_calling_action => null,
1944: p_amount => null,
1945: p_delayed_request=> FND_API.G_TRUE,
1946: p_process_prepayment=>'N',
1947: p_process_authorization=>'N',
1948: x_msg_data => l_msg_data,
1949: x_msg_count => l_msg_count,

Line 2059: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2055: ELSE
2056: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_REQUEST');
2057: FND_MESSAGE.SET_TOKEN('ACTION',l_request_type);
2058: OE_MSG_PUB.Add;
2059: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2060:
2061: END IF;
2062:
2063: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2063: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2059: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2060:
2061: END IF;
2062:
2063: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2065: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2066: RAISE FND_API.G_EXC_ERROR;
2067: END IF;

Line 2064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2060:
2061: END IF;
2062:
2063: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2065: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2066: RAISE FND_API.G_EXC_ERROR;
2067: END IF;
2068:

Line 2065: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2061: END IF;
2062:
2063: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2065: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2066: RAISE FND_API.G_EXC_ERROR;
2067: END IF;
2068:
2069: IF (p_delete = FND_API.G_TRUE) then

Line 2066: RAISE FND_API.G_EXC_ERROR;

2062:
2063: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2065: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2066: RAISE FND_API.G_EXC_ERROR;
2067: END IF;
2068:
2069: IF (p_delete = FND_API.G_TRUE) then
2070:

Line 2069: IF (p_delete = FND_API.G_TRUE) then

2065: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2066: RAISE FND_API.G_EXC_ERROR;
2067: END IF;
2068:
2069: IF (p_delete = FND_API.G_TRUE) then
2070:
2071: G_Delayed_Requests.Delete(p_request_ind);
2072:
2073: /*

Line 2100: /* IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2096: G_Delayed_Requests(p_request_ind).processed := 'Y';
2097:
2098: END IF;
2099:
2100: /* IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2102: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2103: RAISE FND_API.G_EXC_ERROR;
2104: END IF;*/

Line 2101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2097:
2098: END IF;
2099:
2100: /* IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2102: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2103: RAISE FND_API.G_EXC_ERROR;
2104: END IF;*/
2105: /* The request is not removed if return_status is error Rajeev*/

Line 2102: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2098: END IF;
2099:
2100: /* IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2102: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2103: RAISE FND_API.G_EXC_ERROR;
2104: END IF;*/
2105: /* The request is not removed if return_status is error Rajeev*/
2106: --IF (p_delete = FND_API.G_TRUE) then

Line 2103: RAISE FND_API.G_EXC_ERROR;

2099:
2100: /* IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2102: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2103: RAISE FND_API.G_EXC_ERROR;
2104: END IF;*/
2105: /* The request is not removed if return_status is error Rajeev*/
2106: --IF (p_delete = FND_API.G_TRUE) then
2107: -- G_Delayed_Requests.Delete(p_request_ind);

Line 2106: --IF (p_delete = FND_API.G_TRUE) then

2102: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2103: RAISE FND_API.G_EXC_ERROR;
2104: END IF;*/
2105: /* The request is not removed if return_status is error Rajeev*/
2106: --IF (p_delete = FND_API.G_TRUE) then
2107: -- G_Delayed_Requests.Delete(p_request_ind);
2108: --ELSE
2109: -- G_Delayed_Requests(p_request_ind).processed := 'Y';
2110: --END IF;

Line 2116: WHEN FND_API.G_EXC_ERROR THEN

2112: oe_debug_pub.add('leaving Process_Request_Pvt', 1);
2113: END IF;
2114: EXCEPTION
2115:
2116: WHEN FND_API.G_EXC_ERROR THEN
2117: oe_debug_pub.add('exe error Process_Request_Pvt', 1);
2118: /* commented the fowwoing 2 debug messages to fix the bug 13256519 */
2119: /*
2120: oe_debug_pub.add

Line 2125: IF (p_delete = FND_API.G_TRUE)

2121: ('1 type----- '|| G_Delayed_Requests(p_request_ind).request_type, 1);
2122: oe_debug_pub.add
2123: ('1 ind----- '|| p_request_ind, 1);
2124: */
2125: IF (p_delete = FND_API.G_TRUE)
2126: AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
2127: -- Bug 11811300 starts
2128: IF G_Delayed_Requests(p_request_ind).request_type IN
2129: (OE_GLOBALS.G_SCHEDULE_LINE,OE_GLOBALS.G_GROUP_SCHEDULE,OE_GLOBALS.G_SCHEDULE_ATO,OE_GLOBALS.G_SCHEDULE_SMC,OE_GLOBALS.G_SCHEDULE_NONSMC,OE_GLOBALS.G_DELAYED_SCHEDULE)

Line 2137: x_return_status := FND_API.G_RET_STS_ERROR;

2133: ELSE -- 9714072
2134: G_Delayed_Requests(p_request_ind).processed := 'N';
2135: END IF ; -- 9714072
2136: END IF;
2137: x_return_status := FND_API.G_RET_STS_ERROR;
2138:
2139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2140: oe_debug_pub.add('unexp error Process_Request_Pvt', 1);
2141: oe_debug_pub.add('SQL ERROR MESSAGE:'||SQLERRM);

Line 2139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2135: END IF ; -- 9714072
2136: END IF;
2137: x_return_status := FND_API.G_RET_STS_ERROR;
2138:
2139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2140: oe_debug_pub.add('unexp error Process_Request_Pvt', 1);
2141: oe_debug_pub.add('SQL ERROR MESSAGE:'||SQLERRM);
2142:
2143: IF (p_delete = FND_API.G_TRUE)

Line 2143: IF (p_delete = FND_API.G_TRUE)

2139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2140: oe_debug_pub.add('unexp error Process_Request_Pvt', 1);
2141: oe_debug_pub.add('SQL ERROR MESSAGE:'||SQLERRM);
2142:
2143: IF (p_delete = FND_API.G_TRUE)
2144: AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
2145: -- Bug 11811300 starts
2146: IF G_Delayed_Requests(p_request_ind).request_type IN
2147: (OE_GLOBALS.G_SCHEDULE_LINE,OE_GLOBALS.G_GROUP_SCHEDULE,OE_GLOBALS.G_SCHEDULE_ATO,OE_GLOBALS.G_SCHEDULE_SMC,OE_GLOBALS.G_SCHEDULE_NONSMC,OE_GLOBALS.G_DELAYED_SCHEDULE)

Line 2155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2151: ELSE -- 9714072
2152: G_Delayed_Requests(p_request_ind).processed := 'N';
2153: END IF ; -- 9714072
2154: END IF;
2155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2156:
2157: WHEN NO_DATA_FOUND THEN
2158: oe_debug_pub.add('Exiting Process_Request_Pvt no_data_found exception ');
2159: IF (p_delete = FND_API.G_TRUE)

Line 2159: IF (p_delete = FND_API.G_TRUE)

2155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2156:
2157: WHEN NO_DATA_FOUND THEN
2158: oe_debug_pub.add('Exiting Process_Request_Pvt no_data_found exception ');
2159: IF (p_delete = FND_API.G_TRUE)
2160: AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
2161: -- Bug 11811300 starts
2162: IF G_Delayed_Requests(p_request_ind).request_type IN
2163: (OE_GLOBALS.G_SCHEDULE_LINE,OE_GLOBALS.G_GROUP_SCHEDULE,OE_GLOBALS.G_SCHEDULE_ATO,OE_GLOBALS.G_SCHEDULE_SMC,OE_GLOBALS.G_SCHEDULE_NONSMC,OE_GLOBALS.G_DELAYED_SCHEDULE)

Line 2171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2167: ELSE -- 9714072
2168: G_Delayed_Requests(p_request_ind).processed := 'N';
2169: END IF ; -- 9714072
2170: END IF;
2171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2173: THEN
2174: OE_MSG_PUB.Add_Exc_Msg
2175: ( G_PKG_NAME

Line 2182: IF (p_delete = FND_API.G_TRUE)

2178: END IF;
2179:
2180: WHEN OTHERS THEN
2181: oe_debug_pub.add('SQL ERROR MESSAGE FOR WHEN OTHRES:'||SQLERRM);
2182: IF (p_delete = FND_API.G_TRUE)
2183: AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
2184: -- Bug 11811300 starts
2185: IF G_Delayed_Requests(p_request_ind).request_type IN
2186: (OE_GLOBALS.G_SCHEDULE_LINE,OE_GLOBALS.G_GROUP_SCHEDULE,OE_GLOBALS.G_SCHEDULE_ATO,OE_GLOBALS.G_SCHEDULE_SMC,OE_GLOBALS.G_SCHEDULE_NONSMC,OE_GLOBALS.G_DELAYED_SCHEDULE)

Line 2194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2190: ELSE -- 9714072
2191: G_Delayed_Requests(p_request_ind).processed := 'N';
2192: END IF ; -- 9714072
2193: END IF;
2194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2195:
2196: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2197: THEN
2198: OE_MSG_PUB.Add_Exc_Msg

Line 2320: x_return_status := FND_API.G_RET_STS_SUCCESS;

2316: l_request.date_param8 := p_date_param8;
2317: l_request.long_param1 := p_long_param1;
2318:
2319: -- Initialize the return variable
2320: x_return_status := FND_API.G_RET_STS_SUCCESS;
2321:
2322: Check_For_Request(p_entity_code,
2323: p_entity_id,
2324: p_request_type,

Line 2334: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2330: l_request_ind,
2331: l_request_search_rslt,
2332: l_return_status);
2333:
2334: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2336: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2337: RAISE FND_API.G_EXC_ERROR;
2338: END IF;

Line 2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2331: l_request_search_rslt,
2332: l_return_status);
2333:
2334: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2336: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2337: RAISE FND_API.G_EXC_ERROR;
2338: END IF;
2339:

Line 2336: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2332: l_return_status);
2333:
2334: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2336: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2337: RAISE FND_API.G_EXC_ERROR;
2338: END IF;
2339:
2340: l_request.processed := 'N';

Line 2337: RAISE FND_API.G_EXC_ERROR;

2333:
2334: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2336: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2337: RAISE FND_API.G_EXC_ERROR;
2338: END IF;
2339:
2340: l_request.processed := 'N';
2341:

Line 2367: AND l_request_search_rslt = FND_API.g_false THEN

2363: OR l_request.request_unique_key1 = 'ORDER,BOOK'
2364: AND nvl(l_request.request_unique_key2,'N') = 'N'
2365: OR l_request.request_unique_key1 = 'BATCH,BOOK'
2366: AND nvl(l_request.request_unique_key2,'N') = 'N')
2367: AND l_request_search_rslt = FND_API.g_false THEN
2368:
2369: IF l_debug_level > 0 THEN
2370: oe_debug_pub.add('In log_request, calling check_pricing_request.',3);
2371: oe_debug_pub.add('request_unique_key1 is: '||l_request.request_unique_key1,3);

Line 2403: AND l_request_search_rslt = FND_API.g_false THEN

2399: AND nvl(l_request.request_unique_key2,'N') = 'N'
2400: OR nvl(l_request.request_unique_key1,l_request.param2) = 'BATCH,BOOK'
2401: AND nvl(l_request.request_unique_key2,'N') = 'N')
2402: OR nvl(l_request.request_unique_key1, l_request.param2) = 'LINE'
2403: AND l_request_search_rslt = FND_API.g_false THEN
2404: Check_Pricing_Request
2405: ( p_request_ind => l_request_ind
2406: ,p_request_rec => l_request
2407: ,x_log_request => l_log_request);

Line 2417: IF l_request_search_rslt = FND_API.g_true -- replace the request

2413: END IF;
2414:
2415: /* End of the code added to fix the fp bug 3498435 */
2416:
2417: IF l_request_search_rslt = FND_API.g_true -- replace the request
2418: THEN
2419: IF l_debug_level > 0 THEN
2420: OE_Debug_PUB.ADD('Request replaced');
2421: END IF;

Line 2678: if l_return_status = fnd_api.g_ret_sts_error then

2674: OE_Blkt_Release_Util.Cache_Order_Qty_Amt
2675: (p_request_rec => l_request
2676: ,x_return_status => l_return_status
2677: ) ;
2678: if l_return_status = fnd_api.g_ret_sts_error then
2679: raise fnd_api.g_exc_error;
2680: elsif l_return_status = fnd_api.g_ret_sts_error then
2681: raise fnd_api.g_exc_unexpected_error;
2682: end if;

Line 2679: raise fnd_api.g_exc_error;

2675: (p_request_rec => l_request
2676: ,x_return_status => l_return_status
2677: ) ;
2678: if l_return_status = fnd_api.g_ret_sts_error then
2679: raise fnd_api.g_exc_error;
2680: elsif l_return_status = fnd_api.g_ret_sts_error then
2681: raise fnd_api.g_exc_unexpected_error;
2682: end if;
2683: END IF;

Line 2680: elsif l_return_status = fnd_api.g_ret_sts_error then

2676: ,x_return_status => l_return_status
2677: ) ;
2678: if l_return_status = fnd_api.g_ret_sts_error then
2679: raise fnd_api.g_exc_error;
2680: elsif l_return_status = fnd_api.g_ret_sts_error then
2681: raise fnd_api.g_exc_unexpected_error;
2682: end if;
2683: END IF;
2684:

Line 2681: raise fnd_api.g_exc_unexpected_error;

2677: ) ;
2678: if l_return_status = fnd_api.g_ret_sts_error then
2679: raise fnd_api.g_exc_error;
2680: elsif l_return_status = fnd_api.g_ret_sts_error then
2681: raise fnd_api.g_exc_unexpected_error;
2682: end if;
2683: END IF;
2684:
2685: g_delayed_requests(l_request_ind) := l_request;

Line 2703: WHEN FND_API.G_EXC_ERROR THEN

2699: oe_debug_pub.add('!!!!!!! index '|| l_request_ind, 5);
2700: END IF;
2701: EXCEPTION
2702:
2703: WHEN FND_API.G_EXC_ERROR THEN
2704:
2705: x_return_status := FND_API.G_RET_STS_ERROR;
2706:
2707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2705: x_return_status := FND_API.G_RET_STS_ERROR;

2701: EXCEPTION
2702:
2703: WHEN FND_API.G_EXC_ERROR THEN
2704:
2705: x_return_status := FND_API.G_RET_STS_ERROR;
2706:
2707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2708:
2709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2703: WHEN FND_API.G_EXC_ERROR THEN
2704:
2705: x_return_status := FND_API.G_RET_STS_ERROR;
2706:
2707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2708:
2709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2711:

Line 2709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2705: x_return_status := FND_API.G_RET_STS_ERROR;
2706:
2707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2708:
2709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2711:
2712: WHEN OTHERS THEN
2713: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2706:
2707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2708:
2709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2711:
2712: WHEN OTHERS THEN
2713: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2714: THEN

Line 2720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2716: (G_PKG_NAME
2717: ,'LOGREQUEST');
2718: END IF;
2719:
2720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2722:
2723: End Log_Request;
2724:

Line 2721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2717: ,'LOGREQUEST');
2718: END IF;
2719:
2720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2722:
2723: End Log_Request;
2724:
2725: Function Check_for_Request( p_entity_code IN VARCHAR2,

Line 2751: if x_result = FND_API.G_TRUE then

2747: ,x_request_ind => l_ind
2748: ,x_result => x_result
2749: ,x_return_status => x_return_status);
2750:
2751: if x_result = FND_API.G_TRUE then
2752: return(TRUE);
2753: else
2754: return(FALSE);
2755: end if;

Line 2781: x_return_status := FND_API.G_RET_STS_SUCCESS;

2777: BEGIN
2778: IF l_debug_level > 0 THEN
2779: oe_debug_pub.add('Entering Procedure Delete_Request in Package OE_Delayed_Requests_Pvt');
2780: END IF;
2781: x_return_status := FND_API.G_RET_STS_SUCCESS;
2782:
2783: Check_for_Request( p_entity_code => p_entity_code
2784: ,p_entity_id => p_entity_id
2785: ,p_request_type => p_request_type

Line 2796: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2792: ,x_result => l_request_search_rslt
2793: ,x_return_status => l_return_status);
2794:
2795:
2796: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2798: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2799: RAISE FND_API.G_EXC_ERROR;
2800: END IF;

Line 2797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2793: ,x_return_status => l_return_status);
2794:
2795:
2796: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2798: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2799: RAISE FND_API.G_EXC_ERROR;
2800: END IF;
2801:

Line 2798: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2794:
2795:
2796: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2798: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2799: RAISE FND_API.G_EXC_ERROR;
2800: END IF;
2801:
2802: if l_request_search_rslt = FND_API.G_TRUE -- delete the request

Line 2799: RAISE FND_API.G_EXC_ERROR;

2795:
2796: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2798: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2799: RAISE FND_API.G_EXC_ERROR;
2800: END IF;
2801:
2802: if l_request_search_rslt = FND_API.G_TRUE -- delete the request
2803: then

Line 2802: if l_request_search_rslt = FND_API.G_TRUE -- delete the request

2798: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2799: RAISE FND_API.G_EXC_ERROR;
2800: END IF;
2801:
2802: if l_request_search_rslt = FND_API.G_TRUE -- delete the request
2803: then
2804: G_Delayed_Requests.Delete(l_request_ind);
2805: /*
2806: BUG 1794544 - do not delete from req entities table

Line 2826: WHEN FND_API.G_EXC_ERROR THEN

2822: end if;
2823:
2824: EXCEPTION
2825:
2826: WHEN FND_API.G_EXC_ERROR THEN
2827:
2828: x_return_status := FND_API.G_RET_STS_ERROR;
2829:
2830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2828: x_return_status := FND_API.G_RET_STS_ERROR;

2824: EXCEPTION
2825:
2826: WHEN FND_API.G_EXC_ERROR THEN
2827:
2828: x_return_status := FND_API.G_RET_STS_ERROR;
2829:
2830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2831:
2832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2826: WHEN FND_API.G_EXC_ERROR THEN
2827:
2828: x_return_status := FND_API.G_RET_STS_ERROR;
2829:
2830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2831:
2832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2833:
2834: when others THEN

Line 2832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2828: x_return_status := FND_API.G_RET_STS_ERROR;
2829:
2830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2831:
2832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2833:
2834: when others THEN
2835:
2836: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2842: x_return_status := FND_API.G_RET_STS_ERROR;

2838: (G_PKG_NAME
2839: ,'DeleteRequest');
2840: END IF;
2841:
2842: x_return_status := FND_API.G_RET_STS_ERROR;
2843:
2844: End Delete_Request;
2845:
2846: Procedure Clear_Request( x_return_status OUT NOCOPY VARCHAR2)

Line 2857: x_return_status := FND_API.G_RET_STS_SUCCESS;

2853: IF l_debug_level > 0 THEN
2854: oe_debug_pub.add('Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt');
2855: END IF;
2856:
2857: x_return_status := FND_API.G_RET_STS_SUCCESS;
2858:
2859: G_Delayed_Requests.DELETE;
2860: g_requesting_entities.DELETE;
2861:

Line 2886: x_return_status := FND_API.G_RET_STS_ERROR;

2882: (G_PKG_NAME
2883: ,'Clear_Request');
2884: END IF;
2885:
2886: x_return_status := FND_API.G_RET_STS_ERROR;
2887:
2888: End Clear_Request;
2889:
2890: Procedure Process_Request( p_entity_code IN VARCHAR2

Line 2899: FND_API.G_TRUE

2895: ,p_request_unique_key3 IN VARCHAR2 := NULL
2896: ,p_request_unique_key4 IN VARCHAR2 := NULL
2897: ,p_request_unique_key5 IN VARCHAR2 := NULL
2898: ,p_delete IN Varchar2 Default
2899: FND_API.G_TRUE
2900: ,x_return_status OUT NOCOPY Varchar2)
2901:
2902: IS
2903: l_request_ind Number;

Line 2910: x_return_status := FND_API.G_RET_STS_SUCCESS;

2906: --
2907: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2908: --
2909: Begin
2910: x_return_status := FND_API.G_RET_STS_SUCCESS;
2911: IF l_debug_level > 0 THEN
2912: oe_debug_pub.add('Entering Procedure Process_Request in Package OE_Delayed_Requests_Pvt');
2913: END IF;
2914: Check_for_Request( p_entity_code => p_entity_code

Line 2926: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2922: ,x_request_ind => l_request_ind
2923: ,x_result => l_request_search_rslt
2924: ,x_return_status => l_return_status);
2925:
2926: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2928: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2929: RAISE FND_API.G_EXC_ERROR;
2930: END IF;

Line 2927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2923: ,x_result => l_request_search_rslt
2924: ,x_return_status => l_return_status);
2925:
2926: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2928: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2929: RAISE FND_API.G_EXC_ERROR;
2930: END IF;
2931:

Line 2928: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2924: ,x_return_status => l_return_status);
2925:
2926: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2928: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2929: RAISE FND_API.G_EXC_ERROR;
2930: END IF;
2931:
2932: if l_request_search_rslt = FND_API.G_TRUE then

Line 2929: RAISE FND_API.G_EXC_ERROR;

2925:
2926: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2928: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2929: RAISE FND_API.G_EXC_ERROR;
2930: END IF;
2931:
2932: if l_request_search_rslt = FND_API.G_TRUE then
2933: Process_Request_Pvt

Line 2932: if l_request_search_rslt = FND_API.G_TRUE then

2928: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2929: RAISE FND_API.G_EXC_ERROR;
2930: END IF;
2931:
2932: if l_request_search_rslt = FND_API.G_TRUE then
2933: Process_Request_Pvt
2934: (p_request_ind => l_request_ind
2935: ,p_delete => p_delete
2936: ,x_return_status => l_return_status

Line 2940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2936: ,x_return_status => l_return_status
2937: );
2938: end if;
2939:
2940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2943: RAISE FND_API.G_EXC_ERROR;
2944: END IF;

Line 2941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2937: );
2938: end if;
2939:
2940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2943: RAISE FND_API.G_EXC_ERROR;
2944: END IF;
2945:

Line 2942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2938: end if;
2939:
2940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2943: RAISE FND_API.G_EXC_ERROR;
2944: END IF;
2945:
2946: EXCEPTION

Line 2943: RAISE FND_API.G_EXC_ERROR;

2939:
2940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2943: RAISE FND_API.G_EXC_ERROR;
2944: END IF;
2945:
2946: EXCEPTION
2947:

Line 2948: WHEN FND_API.G_EXC_ERROR THEN

2944: END IF;
2945:
2946: EXCEPTION
2947:
2948: WHEN FND_API.G_EXC_ERROR THEN
2949:
2950: x_return_status := FND_API.G_RET_STS_ERROR;
2951:
2952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2950: x_return_status := FND_API.G_RET_STS_ERROR;

2946: EXCEPTION
2947:
2948: WHEN FND_API.G_EXC_ERROR THEN
2949:
2950: x_return_status := FND_API.G_RET_STS_ERROR;
2951:
2952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2953:
2954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2948: WHEN FND_API.G_EXC_ERROR THEN
2949:
2950: x_return_status := FND_API.G_RET_STS_ERROR;
2951:
2952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2953:
2954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2955:
2956: WHEN OTHERS THEN

Line 2954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2950: x_return_status := FND_API.G_RET_STS_ERROR;
2951:
2952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2953:
2954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2955:
2956: WHEN OTHERS THEN
2957:
2958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2955:
2956: WHEN OTHERS THEN
2957:
2958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2959:
2960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2961: THEN
2962: OE_MSG_PUB.Add_Exc_Msg

Line 2972: ,p_delete in Varchar2 Default FND_API.G_TRUE

2968: End Process_Request;
2969:
2970: Procedure Process_Request_for_Entity
2971: ( p_entity_code in Varchar2
2972: ,p_delete in Varchar2 Default FND_API.G_TRUE
2973: ,x_return_status OUT NOCOPY Varchar2) IS
2974:
2975: l_return_status Varchar2(30);
2976: l_ind Number;

Line 2981: x_return_status := FND_API.G_RET_STS_SUCCESS;

2977: --
2978: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2979: --
2980: Begin
2981: x_return_status := FND_API.G_RET_STS_SUCCESS;
2982: IF l_debug_level > 0 THEN
2983: oe_debug_pub.add('Enter OE_Delayed_Requests_Pvt.Process_Request_for_Entity',1);
2984: END IF;
2985: IF NOT oe_globals.g_call_process_req THEN --9354229

Line 3008: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3004: ,p_delete => p_delete
3005: ,x_return_status => l_return_status
3006: );
3007:
3008: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3010: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3011: IF l_debug_level > 0 THEN
3012: oe_debug_pub.add('Expected error in Process_Request_for_Entity ');

Line 3009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3005: ,x_return_status => l_return_status
3006: );
3007:
3008: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3010: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3011: IF l_debug_level > 0 THEN
3012: oe_debug_pub.add('Expected error in Process_Request_for_Entity ');
3013: /* Commented the following 2 debug messages to fix the bug 13513618 */

Line 3010: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3006: );
3007:
3008: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3010: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3011: IF l_debug_level > 0 THEN
3012: oe_debug_pub.add('Expected error in Process_Request_for_Entity ');
3013: /* Commented the following 2 debug messages to fix the bug 13513618 */
3014: /*

Line 3022: RAISE FND_API.G_EXC_ERROR;

3018: oe_debug_pub.add
3019: ('2 ind----- '|| l_ind, 1);
3020: */
3021: END IF;
3022: RAISE FND_API.G_EXC_ERROR;
3023: END IF;
3024: END IF;
3025: l_ind := G_Delayed_Requests.Next(l_ind);
3026: END LOOP;

Line 3037: WHEN FND_API.G_EXC_ERROR THEN

3033: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3034: p_In_out => 0);
3035: EXCEPTION
3036:
3037: WHEN FND_API.G_EXC_ERROR THEN
3038: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3039: p_In_out => 0);
3040: x_return_status := FND_API.G_RET_STS_ERROR;
3041:

Line 3040: x_return_status := FND_API.G_RET_STS_ERROR;

3036:
3037: WHEN FND_API.G_EXC_ERROR THEN
3038: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3039: p_In_out => 0);
3040: x_return_status := FND_API.G_RET_STS_ERROR;
3041:
3042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3043: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3044: p_In_out => 0);

Line 3042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3038: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3039: p_In_out => 0);
3040: x_return_status := FND_API.G_RET_STS_ERROR;
3041:
3042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3043: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3044: p_In_out => 0);
3045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3046:

Line 3045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3041:
3042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3043: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3044: p_In_out => 0);
3045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3046:
3047: WHEN OTHERS THEN
3048: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3049: p_In_out => 0);

Line 3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3046:
3047: WHEN OTHERS THEN
3048: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3049: p_In_out => 0);
3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3051:
3052: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3053: THEN
3054: OE_MSG_PUB.Add_Exc_Msg

Line 3068: ,p_delete in Varchar2 Default FND_API.G_TRUE

3064:
3065:
3066: Procedure Process_Request_for_ReqType
3067: ( p_request_type in Varchar2
3068: ,p_delete in Varchar2 Default FND_API.G_TRUE
3069: ,x_return_status OUT NOCOPY Varchar2
3070:
3071: ) IS
3072: l_return_status Varchar2(30);

Line 3082: x_return_status := FND_API.G_RET_STS_SUCCESS;

3078: --
3079: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3080: --
3081: BEGIN
3082: x_return_status := FND_API.G_RET_STS_SUCCESS;
3083: IF l_debug_level > 0 THEN
3084: oe_debug_pub.add('Entering Procedure Process_Request_for_ReqType in Package OE_Delayed_Requests_Pvt');
3085: END IF;
3086:

Line 3121: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3117: ,p_delete => p_delete
3118: ,x_return_status => l_return_status
3119: );
3120:
3121: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3123: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3124: RAISE FND_API.G_EXC_ERROR;
3125: END IF;

Line 3122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3118: ,x_return_status => l_return_status
3119: );
3120:
3121: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3123: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3124: RAISE FND_API.G_EXC_ERROR;
3125: END IF;
3126: END IF;

Line 3123: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3119: );
3120:
3121: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3123: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3124: RAISE FND_API.G_EXC_ERROR;
3125: END IF;
3126: END IF;
3127: END IF;

Line 3124: RAISE FND_API.G_EXC_ERROR;

3120:
3121: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3123: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3124: RAISE FND_API.G_EXC_ERROR;
3125: END IF;
3126: END IF;
3127: END IF;
3128: l_ind := G_Delayed_Requests.Next(l_ind);

Line 3136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3132: (p_Entity_id_tbl => l_entity_id_tbl
3133: ,x_return_status => l_return_status
3134: );
3135:
3136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3139: RAISE FND_API.G_EXC_ERROR;
3140: END IF;

Line 3137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3133: ,x_return_status => l_return_status
3134: );
3135:
3136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3139: RAISE FND_API.G_EXC_ERROR;
3140: END IF;
3141: l_count := l_entity_id_tbl.FIRST;

Line 3138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3134: );
3135:
3136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3139: RAISE FND_API.G_EXC_ERROR;
3140: END IF;
3141: l_count := l_entity_id_tbl.FIRST;
3142: WHILE l_count IS NOT NULL LOOP -- Fixing 1888284

Line 3139: RAISE FND_API.G_EXC_ERROR;

3135:
3136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3139: RAISE FND_API.G_EXC_ERROR;
3140: END IF;
3141: l_count := l_entity_id_tbl.FIRST;
3142: WHILE l_count IS NOT NULL LOOP -- Fixing 1888284
3143: G_Delayed_Requests.DELETE(l_entity_id_tbl(l_count).request_ind);

Line 3172: WHEN FND_API.G_EXC_ERROR THEN

3168: oe_debug_pub.add('leaving process_requenst_for_reqtype', 1);
3169: END IF;
3170: EXCEPTION
3171:
3172: WHEN FND_API.G_EXC_ERROR THEN
3173: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3174: p_In_out => 0);
3175: oe_debug_pub.add('execution error', 1);
3176: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3176: x_return_status := FND_API.G_RET_STS_ERROR;

3172: WHEN FND_API.G_EXC_ERROR THEN
3173: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3174: p_In_out => 0);
3175: oe_debug_pub.add('execution error', 1);
3176: x_return_status := FND_API.G_RET_STS_ERROR;
3177:
3178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3179: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3180: p_In_out => 0);

Line 3178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3174: p_In_out => 0);
3175: oe_debug_pub.add('execution error', 1);
3176: x_return_status := FND_API.G_RET_STS_ERROR;
3177:
3178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3179: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3180: p_In_out => 0);
3181: oe_debug_pub.add('unexp error', 1);
3182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3179: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3180: p_In_out => 0);
3181: oe_debug_pub.add('unexp error', 1);
3182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3183:
3184: WHEN OTHERS THEN
3185: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3186: p_In_out => 0);

Line 3188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3184: WHEN OTHERS THEN
3185: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3186: p_In_out => 0);
3187: oe_debug_pub.add('others error', 1);
3188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3189:
3190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3191: THEN
3192: OE_MSG_PUB.Add_Exc_Msg

Line 3214: x_return_status := FND_API.G_RET_STS_SUCCESS;

3210: IF l_debug_level > 0 THEN
3211: oe_debug_pub.add('Enter OE_Delayed_Requests_Pvt.Process_Delayed_Requests');
3212: END IF;
3213:
3214: x_return_status := FND_API.G_RET_STS_SUCCESS;
3215:
3216: IF NOT oe_globals.g_call_process_req THEN --9354229
3217: IF l_debug_level > 0 THEN
3218: oe_debug_pub.add( 'EXIT OE_Delayed_Requests_Pvt.Process_Delayed_Requests' , 1 ) ;

Line 3232: ,p_delete => FND_API.G_TRUE

3228: IF oe_globals.g_recursion_mode = 'N' THEN
3229:
3230: Process_Request_for_ReqType
3231: (p_request_type => OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
3232: ,p_delete => FND_API.G_TRUE
3233: ,x_return_status => l_return_status
3234: );
3235: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3235: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3231: (p_request_type => OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
3232: ,p_delete => FND_API.G_TRUE
3233: ,x_return_status => l_return_status
3234: );
3235: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3237: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3238: RAISE FND_API.G_EXC_ERROR;
3239: END IF;

Line 3236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3232: ,p_delete => FND_API.G_TRUE
3233: ,x_return_status => l_return_status
3234: );
3235: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3237: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3238: RAISE FND_API.G_EXC_ERROR;
3239: END IF;
3240:

Line 3237: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3233: ,x_return_status => l_return_status
3234: );
3235: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3237: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3238: RAISE FND_API.G_EXC_ERROR;
3239: END IF;
3240:
3241: -- Process Header Sales Credits Delayed Requests

Line 3238: RAISE FND_API.G_EXC_ERROR;

3234: );
3235: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3237: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3238: RAISE FND_API.G_EXC_ERROR;
3239: END IF;
3240:
3241: -- Process Header Sales Credits Delayed Requests
3242: Process_Request_for_ReqType

Line 3244: ,p_delete => FND_API.G_TRUE

3240:
3241: -- Process Header Sales Credits Delayed Requests
3242: Process_Request_for_ReqType
3243: (p_request_type => OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
3244: ,p_delete => FND_API.G_TRUE
3245: ,x_return_status => l_return_status
3246: );
3247: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3247: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3243: (p_request_type => OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
3244: ,p_delete => FND_API.G_TRUE
3245: ,x_return_status => l_return_status
3246: );
3247: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3249: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3250: RAISE FND_API.G_EXC_ERROR;
3251: END IF;

Line 3248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3244: ,p_delete => FND_API.G_TRUE
3245: ,x_return_status => l_return_status
3246: );
3247: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3249: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3250: RAISE FND_API.G_EXC_ERROR;
3251: END IF;
3252:

Line 3249: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3245: ,x_return_status => l_return_status
3246: );
3247: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3249: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3250: RAISE FND_API.G_EXC_ERROR;
3251: END IF;
3252:
3253: -- Process Lines Sales Credits Delayed Requests

Line 3250: RAISE FND_API.G_EXC_ERROR;

3246: );
3247: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3249: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3250: RAISE FND_API.G_EXC_ERROR;
3251: END IF;
3252:
3253: -- Process Lines Sales Credits Delayed Requests
3254: Process_Request_for_ReqType

Line 3256: ,p_delete => FND_API.G_TRUE

3252:
3253: -- Process Lines Sales Credits Delayed Requests
3254: Process_Request_for_ReqType
3255: (p_request_type => OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL
3256: ,p_delete => FND_API.G_TRUE
3257: ,x_return_status => l_return_status
3258: );
3259: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3259: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3255: (p_request_type => OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL
3256: ,p_delete => FND_API.G_TRUE
3257: ,x_return_status => l_return_status
3258: );
3259: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3262: RAISE FND_API.G_EXC_ERROR;
3263: END IF;

Line 3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3256: ,p_delete => FND_API.G_TRUE
3257: ,x_return_status => l_return_status
3258: );
3259: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3262: RAISE FND_API.G_EXC_ERROR;
3263: END IF;
3264:

Line 3261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3257: ,x_return_status => l_return_status
3258: );
3259: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3262: RAISE FND_API.G_EXC_ERROR;
3263: END IF;
3264:
3265: /* Bug 12673852 */

Line 3262: RAISE FND_API.G_EXC_ERROR;

3258: );
3259: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3262: RAISE FND_API.G_EXC_ERROR;
3263: END IF;
3264:
3265: /* Bug 12673852 */
3266: Process_Request_for_ReqType

Line 3268: ,p_delete => FND_API.G_TRUE

3264:
3265: /* Bug 12673852 */
3266: Process_Request_for_ReqType
3267: (p_request_type => OE_GLOBALS.G_VERSION_AUDIT
3268: ,p_delete => FND_API.G_TRUE
3269: ,x_return_status => l_return_status
3270: );
3271: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3271: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3267: (p_request_type => OE_GLOBALS.G_VERSION_AUDIT
3268: ,p_delete => FND_API.G_TRUE
3269: ,x_return_status => l_return_status
3270: );
3271: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3273: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3274: RAISE FND_API.G_EXC_ERROR;
3275: END IF;

Line 3272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3268: ,p_delete => FND_API.G_TRUE
3269: ,x_return_status => l_return_status
3270: );
3271: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3273: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3274: RAISE FND_API.G_EXC_ERROR;
3275: END IF;
3276: /* End of Bug 12673852 */

Line 3273: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3269: ,x_return_status => l_return_status
3270: );
3271: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3273: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3274: RAISE FND_API.G_EXC_ERROR;
3275: END IF;
3276: /* End of Bug 12673852 */
3277:

Line 3274: RAISE FND_API.G_EXC_ERROR;

3270: );
3271: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3273: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3274: RAISE FND_API.G_EXC_ERROR;
3275: END IF;
3276: /* End of Bug 12673852 */
3277:
3278: -- Process CREATE_SETS Requests

Line 3281: ,p_delete => FND_API.G_TRUE

3277:
3278: -- Process CREATE_SETS Requests
3279: Process_Request_for_ReqType
3280: (p_request_type => OE_GLOBALS.G_CREATE_SETS
3281: ,p_delete => FND_API.G_TRUE
3282: ,x_return_status => l_return_status
3283: );
3284: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3284: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3280: (p_request_type => OE_GLOBALS.G_CREATE_SETS
3281: ,p_delete => FND_API.G_TRUE
3282: ,x_return_status => l_return_status
3283: );
3284: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3286: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3287: RAISE FND_API.G_EXC_ERROR;
3288: END IF;

Line 3285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3281: ,p_delete => FND_API.G_TRUE
3282: ,x_return_status => l_return_status
3283: );
3284: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3286: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3287: RAISE FND_API.G_EXC_ERROR;
3288: END IF;
3289:

Line 3286: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3282: ,x_return_status => l_return_status
3283: );
3284: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3286: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3287: RAISE FND_API.G_EXC_ERROR;
3288: END IF;
3289:
3290:

Line 3287: RAISE FND_API.G_EXC_ERROR;

3283: );
3284: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3286: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3287: RAISE FND_API.G_EXC_ERROR;
3288: END IF;
3289:
3290:
3291:

Line 3295: ,p_delete => FND_API.G_TRUE

3291:
3292: -- Process CREATE_CONFIG_ITEM Requests
3293: Process_Request_for_ReqType
3294: (p_request_type => OE_GLOBALS.G_CREATE_CONFIG_ITEM
3295: ,p_delete => FND_API.G_TRUE
3296: ,x_return_status => l_return_status
3297: );
3298: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3298: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3294: (p_request_type => OE_GLOBALS.G_CREATE_CONFIG_ITEM
3295: ,p_delete => FND_API.G_TRUE
3296: ,x_return_status => l_return_status
3297: );
3298: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3300: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3301: RAISE FND_API.G_EXC_ERROR;
3302: END IF;

Line 3299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3295: ,p_delete => FND_API.G_TRUE
3296: ,x_return_status => l_return_status
3297: );
3298: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3300: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3301: RAISE FND_API.G_EXC_ERROR;
3302: END IF;
3303:

Line 3300: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3296: ,x_return_status => l_return_status
3297: );
3298: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3300: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3301: RAISE FND_API.G_EXC_ERROR;
3302: END IF;
3303:
3304: -- Process INSERT_INTO_SETS Requests

Line 3301: RAISE FND_API.G_EXC_ERROR;

3297: );
3298: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3300: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3301: RAISE FND_API.G_EXC_ERROR;
3302: END IF;
3303:
3304: -- Process INSERT_INTO_SETS Requests
3305: Process_Request_for_ReqType

Line 3307: ,p_delete => FND_API.G_TRUE

3303:
3304: -- Process INSERT_INTO_SETS Requests
3305: Process_Request_for_ReqType
3306: (p_request_type => OE_GLOBALS.G_INSERT_INTO_SETS
3307: ,p_delete => FND_API.G_TRUE
3308: ,x_return_status => l_return_status
3309: );
3310: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3310: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3306: (p_request_type => OE_GLOBALS.G_INSERT_INTO_SETS
3307: ,p_delete => FND_API.G_TRUE
3308: ,x_return_status => l_return_status
3309: );
3310: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3313: RAISE FND_API.G_EXC_ERROR;
3314: END IF;

Line 3311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3307: ,p_delete => FND_API.G_TRUE
3308: ,x_return_status => l_return_status
3309: );
3310: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3313: RAISE FND_API.G_EXC_ERROR;
3314: END IF;
3315:

Line 3312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3308: ,x_return_status => l_return_status
3309: );
3310: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3313: RAISE FND_API.G_EXC_ERROR;
3314: END IF;
3315:
3316: /* Start DOO Pre Exploded Kit ER 9339742 */

Line 3313: RAISE FND_API.G_EXC_ERROR;

3309: );
3310: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3313: RAISE FND_API.G_EXC_ERROR;
3314: END IF;
3315:
3316: /* Start DOO Pre Exploded Kit ER 9339742 */
3317: Process_Request_for_Reqtype

Line 3319: , p_delete => FND_API.G_TRUE

3315:
3316: /* Start DOO Pre Exploded Kit ER 9339742 */
3317: Process_Request_for_Reqtype
3318: ( p_request_type => OE_GLOBALS.G_PRE_EXPLODED_KIT
3319: , p_delete => FND_API.G_TRUE
3320: , x_return_status => l_return_status );
3321:
3322: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3322: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3318: ( p_request_type => OE_GLOBALS.G_PRE_EXPLODED_KIT
3319: , p_delete => FND_API.G_TRUE
3320: , x_return_status => l_return_status );
3321:
3322: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3324: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3325: RAISE FND_API.G_EXC_ERROR;
3326: END IF;

Line 3323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3319: , p_delete => FND_API.G_TRUE
3320: , x_return_status => l_return_status );
3321:
3322: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3324: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3325: RAISE FND_API.G_EXC_ERROR;
3326: END IF;
3327: /* End DOO Pre Exploded Kit ER 9339742 */

Line 3324: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3320: , x_return_status => l_return_status );
3321:
3322: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3324: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3325: RAISE FND_API.G_EXC_ERROR;
3326: END IF;
3327: /* End DOO Pre Exploded Kit ER 9339742 */
3328:

Line 3325: RAISE FND_API.G_EXC_ERROR;

3321:
3322: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3324: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3325: RAISE FND_API.G_EXC_ERROR;
3326: END IF;
3327: /* End DOO Pre Exploded Kit ER 9339742 */
3328:
3329: -- Process INS_INCLUDED_ITEM Requests

Line 3332: ,p_delete => FND_API.G_TRUE

3328:
3329: -- Process INS_INCLUDED_ITEM Requests
3330: Process_Request_for_ReqType
3331: (p_request_type => OE_GLOBALS.G_INS_INCLUDED_ITEMS
3332: ,p_delete => FND_API.G_TRUE
3333: ,x_return_status => l_return_status
3334: );
3335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3331: (p_request_type => OE_GLOBALS.G_INS_INCLUDED_ITEMS
3332: ,p_delete => FND_API.G_TRUE
3333: ,x_return_status => l_return_status
3334: );
3335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3337: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3338: RAISE FND_API.G_EXC_ERROR;
3339: END IF;

Line 3336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3332: ,p_delete => FND_API.G_TRUE
3333: ,x_return_status => l_return_status
3334: );
3335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3337: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3338: RAISE FND_API.G_EXC_ERROR;
3339: END IF;
3340:

Line 3337: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3333: ,x_return_status => l_return_status
3334: );
3335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3337: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3338: RAISE FND_API.G_EXC_ERROR;
3339: END IF;
3340:
3341:

Line 3338: RAISE FND_API.G_EXC_ERROR;

3334: );
3335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3337: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3338: RAISE FND_API.G_EXC_ERROR;
3339: END IF;
3340:
3341:
3342:

Line 3346: ,p_delete => FND_API.G_TRUE

3342:
3343: -- Process requests for RMA
3344: Process_Request_for_ReqType
3345: (p_request_type => OE_GLOBALS.G_INSERT_RMA
3346: ,p_delete => FND_API.G_TRUE
3347: ,x_return_status => l_return_status
3348: );
3349: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3349: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3345: (p_request_type => OE_GLOBALS.G_INSERT_RMA
3346: ,p_delete => FND_API.G_TRUE
3347: ,x_return_status => l_return_status
3348: );
3349: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3351: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3352: RAISE FND_API.G_EXC_ERROR;
3353: END IF;

Line 3350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3346: ,p_delete => FND_API.G_TRUE
3347: ,x_return_status => l_return_status
3348: );
3349: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3351: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3352: RAISE FND_API.G_EXC_ERROR;
3353: END IF;
3354:

Line 3351: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3347: ,x_return_status => l_return_status
3348: );
3349: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3351: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3352: RAISE FND_API.G_EXC_ERROR;
3353: END IF;
3354:
3355: -- Process requests for Split_hold

Line 3352: RAISE FND_API.G_EXC_ERROR;

3348: );
3349: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3351: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3352: RAISE FND_API.G_EXC_ERROR;
3353: END IF;
3354:
3355: -- Process requests for Split_hold
3356: Process_Request_for_ReqType

Line 3358: ,p_delete => FND_API.G_TRUE

3354:
3355: -- Process requests for Split_hold
3356: Process_Request_for_ReqType
3357: (p_request_type => OE_GLOBALS.G_SPLIT_HOLD
3358: ,p_delete => FND_API.G_TRUE
3359: ,x_return_status => l_return_status
3360: );
3361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3357: (p_request_type => OE_GLOBALS.G_SPLIT_HOLD
3358: ,p_delete => FND_API.G_TRUE
3359: ,x_return_status => l_return_status
3360: );
3361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3364: RAISE FND_API.G_EXC_ERROR;
3365: END IF;

Line 3362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3358: ,p_delete => FND_API.G_TRUE
3359: ,x_return_status => l_return_status
3360: );
3361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3364: RAISE FND_API.G_EXC_ERROR;
3365: END IF;
3366:

Line 3363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3359: ,x_return_status => l_return_status
3360: );
3361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3364: RAISE FND_API.G_EXC_ERROR;
3365: END IF;
3366:
3367: -- Process requests for Delayed Requests

Line 3364: RAISE FND_API.G_EXC_ERROR;

3360: );
3361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3364: RAISE FND_API.G_EXC_ERROR;
3365: END IF;
3366:
3367: -- Process requests for Delayed Requests
3368: Process_Request_for_ReqType

Line 3370: ,p_delete => FND_API.G_TRUE

3366:
3367: -- Process requests for Delayed Requests
3368: Process_Request_for_ReqType
3369: (p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE
3370: ,p_delete => FND_API.G_TRUE
3371: ,x_return_status => l_return_status
3372: );
3373: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3373: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3369: (p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE
3370: ,p_delete => FND_API.G_TRUE
3371: ,x_return_status => l_return_status
3372: );
3373: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3375: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3376: RAISE FND_API.G_EXC_ERROR;
3377: END IF;

Line 3374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3370: ,p_delete => FND_API.G_TRUE
3371: ,x_return_status => l_return_status
3372: );
3373: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3375: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3376: RAISE FND_API.G_EXC_ERROR;
3377: END IF;
3378:

Line 3375: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3371: ,x_return_status => l_return_status
3372: );
3373: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3375: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3376: RAISE FND_API.G_EXC_ERROR;
3377: END IF;
3378:
3379: -- Process requests for Quantity Cascade

Line 3376: RAISE FND_API.G_EXC_ERROR;

3372: );
3373: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3375: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3376: RAISE FND_API.G_EXC_ERROR;
3377: END IF;
3378:
3379: -- Process requests for Quantity Cascade
3380: Process_Request_for_ReqType

Line 3382: ,p_delete => FND_API.G_TRUE

3378:
3379: -- Process requests for Quantity Cascade
3380: Process_Request_for_ReqType
3381: (p_request_type => OE_GLOBALS.G_CASCADE_QUANTITY
3382: ,p_delete => FND_API.G_TRUE
3383: ,x_return_status => l_return_status
3384: );
3385: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3385: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3381: (p_request_type => OE_GLOBALS.G_CASCADE_QUANTITY
3382: ,p_delete => FND_API.G_TRUE
3383: ,x_return_status => l_return_status
3384: );
3385: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3387: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3388: RAISE FND_API.G_EXC_ERROR;
3389: END IF;

Line 3386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3382: ,p_delete => FND_API.G_TRUE
3383: ,x_return_status => l_return_status
3384: );
3385: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3387: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3388: RAISE FND_API.G_EXC_ERROR;
3389: END IF;
3390:

Line 3387: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3383: ,x_return_status => l_return_status
3384: );
3385: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3387: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3388: RAISE FND_API.G_EXC_ERROR;
3389: END IF;
3390:
3391: /*** we do not need this, confirm with ashwin

Line 3388: RAISE FND_API.G_EXC_ERROR;

3384: );
3385: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3387: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3388: RAISE FND_API.G_EXC_ERROR;
3389: END IF;
3390:
3391: /*** we do not need this, confirm with ashwin
3392: -- Process requests for project Cascade

Line 3395: ,p_delete => FND_API.G_TRUE

3391: /*** we do not need this, confirm with ashwin
3392: -- Process requests for project Cascade
3393: Process_Request_for_ReqType
3394: (p_request_type => OE_GLOBALS.G_CASCADE_PROJECT
3395: ,p_delete => FND_API.G_TRUE
3396: ,x_return_status => l_return_status
3397: );
3398: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3398: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3394: (p_request_type => OE_GLOBALS.G_CASCADE_PROJECT
3395: ,p_delete => FND_API.G_TRUE
3396: ,x_return_status => l_return_status
3397: );
3398: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3400: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3401: RAISE FND_API.G_EXC_ERROR;
3402: END IF;

Line 3399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3395: ,p_delete => FND_API.G_TRUE
3396: ,x_return_status => l_return_status
3397: );
3398: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3400: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3401: RAISE FND_API.G_EXC_ERROR;
3402: END IF;
3403:

Line 3400: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3396: ,x_return_status => l_return_status
3397: );
3398: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3400: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3401: RAISE FND_API.G_EXC_ERROR;
3402: END IF;
3403:
3404: -- Process requests for task Cascade

Line 3401: RAISE FND_API.G_EXC_ERROR;

3397: );
3398: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3400: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3401: RAISE FND_API.G_EXC_ERROR;
3402: END IF;
3403:
3404: -- Process requests for task Cascade
3405: Process_Request_for_ReqType

Line 3407: ,p_delete => FND_API.G_TRUE

3403:
3404: -- Process requests for task Cascade
3405: Process_Request_for_ReqType
3406: (p_request_type => OE_GLOBALS.G_CASCADE_TASK
3407: ,p_delete => FND_API.G_TRUE
3408: ,x_return_status => l_return_status
3409: );
3410: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3410: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3406: (p_request_type => OE_GLOBALS.G_CASCADE_TASK
3407: ,p_delete => FND_API.G_TRUE
3408: ,x_return_status => l_return_status
3409: );
3410: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3412: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3413: RAISE FND_API.G_EXC_ERROR;
3414: END IF;

Line 3411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3407: ,p_delete => FND_API.G_TRUE
3408: ,x_return_status => l_return_status
3409: );
3410: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3412: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3413: RAISE FND_API.G_EXC_ERROR;
3414: END IF;
3415:

Line 3412: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3408: ,x_return_status => l_return_status
3409: );
3410: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3412: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3413: RAISE FND_API.G_EXC_ERROR;
3414: END IF;
3415:
3416: -- Process requests for task Cascade

Line 3413: RAISE FND_API.G_EXC_ERROR;

3409: );
3410: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3412: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3413: RAISE FND_API.G_EXC_ERROR;
3414: END IF;
3415:
3416: -- Process requests for task Cascade
3417: ***/

Line 3420: ,p_delete => FND_API.G_TRUE

3416: -- Process requests for task Cascade
3417: ***/
3418: Process_Request_for_ReqType
3419: (p_request_type => OE_GLOBALS.G_CASCADE_CHANGES
3420: ,p_delete => FND_API.G_TRUE
3421: ,x_return_status => l_return_status
3422: );
3423: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3423: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3419: (p_request_type => OE_GLOBALS.G_CASCADE_CHANGES
3420: ,p_delete => FND_API.G_TRUE
3421: ,x_return_status => l_return_status
3422: );
3423: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3426: RAISE FND_API.G_EXC_ERROR;
3427: END IF;

Line 3424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3420: ,p_delete => FND_API.G_TRUE
3421: ,x_return_status => l_return_status
3422: );
3423: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3426: RAISE FND_API.G_EXC_ERROR;
3427: END IF;
3428:

Line 3425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3421: ,x_return_status => l_return_status
3422: );
3423: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3426: RAISE FND_API.G_EXC_ERROR;
3427: END IF;
3428:
3429: -- Process requests to Split Reservations

Line 3426: RAISE FND_API.G_EXC_ERROR;

3422: );
3423: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3426: RAISE FND_API.G_EXC_ERROR;
3427: END IF;
3428:
3429: -- Process requests to Split Reservations
3430: Process_Request_for_ReqType

Line 3432: ,p_delete => FND_API.G_TRUE

3428:
3429: -- Process requests to Split Reservations
3430: Process_Request_for_ReqType
3431: (p_request_type => OE_GLOBALS.G_CREATE_RESERVATIONS
3432: ,p_delete => FND_API.G_TRUE
3433: ,x_return_status => l_return_status
3434: );
3435: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3435: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3431: (p_request_type => OE_GLOBALS.G_CREATE_RESERVATIONS
3432: ,p_delete => FND_API.G_TRUE
3433: ,x_return_status => l_return_status
3434: );
3435: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3437: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3438: RAISE FND_API.G_EXC_ERROR;
3439: END IF;

Line 3436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3432: ,p_delete => FND_API.G_TRUE
3433: ,x_return_status => l_return_status
3434: );
3435: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3437: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3438: RAISE FND_API.G_EXC_ERROR;
3439: END IF;
3440:

Line 3437: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3433: ,x_return_status => l_return_status
3434: );
3435: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3437: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3438: RAISE FND_API.G_EXC_ERROR;
3439: END IF;
3440:
3441: -- Process requests to Complete Configuration

Line 3438: RAISE FND_API.G_EXC_ERROR;

3434: );
3435: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3437: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3438: RAISE FND_API.G_EXC_ERROR;
3439: END IF;
3440:
3441: -- Process requests to Complete Configuration
3442: Process_Request_for_ReqType

Line 3444: ,p_delete => FND_API.G_TRUE

3440:
3441: -- Process requests to Complete Configuration
3442: Process_Request_for_ReqType
3443: (p_request_type => OE_GLOBALS.G_COMPLETE_CONFIGURATION
3444: ,p_delete => FND_API.G_TRUE
3445: ,x_return_status => l_return_status
3446: );
3447: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3447: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3443: (p_request_type => OE_GLOBALS.G_COMPLETE_CONFIGURATION
3444: ,p_delete => FND_API.G_TRUE
3445: ,x_return_status => l_return_status
3446: );
3447: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3449: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3450: RAISE FND_API.G_EXC_ERROR;
3451: END IF;

Line 3448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3444: ,p_delete => FND_API.G_TRUE
3445: ,x_return_status => l_return_status
3446: );
3447: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3449: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3450: RAISE FND_API.G_EXC_ERROR;
3451: END IF;
3452:

Line 3449: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3445: ,x_return_status => l_return_status
3446: );
3447: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3449: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3450: RAISE FND_API.G_EXC_ERROR;
3451: END IF;
3452:
3453: -- Process requests for Validate Configuration

Line 3450: RAISE FND_API.G_EXC_ERROR;

3446: );
3447: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3449: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3450: RAISE FND_API.G_EXC_ERROR;
3451: END IF;
3452:
3453: -- Process requests for Validate Configuration
3454: Process_Request_for_ReqType

Line 3456: ,p_delete => FND_API.G_TRUE

3452:
3453: -- Process requests for Validate Configuration
3454: Process_Request_for_ReqType
3455: (p_request_type => OE_GLOBALS.G_VALIDATE_CONFIGURATION
3456: ,p_delete => FND_API.G_TRUE
3457: ,x_return_status => l_return_status
3458: );
3459: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3459: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3455: (p_request_type => OE_GLOBALS.G_VALIDATE_CONFIGURATION
3456: ,p_delete => FND_API.G_TRUE
3457: ,x_return_status => l_return_status
3458: );
3459: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3461: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3462: RAISE FND_API.G_EXC_ERROR;
3463: END IF;

Line 3460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3456: ,p_delete => FND_API.G_TRUE
3457: ,x_return_status => l_return_status
3458: );
3459: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3461: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3462: RAISE FND_API.G_EXC_ERROR;
3463: END IF;
3464:

Line 3461: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3457: ,x_return_status => l_return_status
3458: );
3459: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3461: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3462: RAISE FND_API.G_EXC_ERROR;
3463: END IF;
3464:
3465: -- Process requests for CTO Notification

Line 3462: RAISE FND_API.G_EXC_ERROR;

3458: );
3459: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3461: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3462: RAISE FND_API.G_EXC_ERROR;
3463: END IF;
3464:
3465: -- Process requests for CTO Notification
3466: Process_Request_for_ReqType

Line 3468: ,p_delete => FND_API.G_TRUE

3464:
3465: -- Process requests for CTO Notification
3466: Process_Request_for_ReqType
3467: (p_request_type => OE_GLOBALS.G_CTO_NOTIFICATION
3468: ,p_delete => FND_API.G_TRUE
3469: ,x_return_status => l_return_status
3470: );
3471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3467: (p_request_type => OE_GLOBALS.G_CTO_NOTIFICATION
3468: ,p_delete => FND_API.G_TRUE
3469: ,x_return_status => l_return_status
3470: );
3471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3473: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3474: RAISE FND_API.G_EXC_ERROR;
3475: END IF;

Line 3472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3468: ,p_delete => FND_API.G_TRUE
3469: ,x_return_status => l_return_status
3470: );
3471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3473: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3474: RAISE FND_API.G_EXC_ERROR;
3475: END IF;
3476:

Line 3473: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3469: ,x_return_status => l_return_status
3470: );
3471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3473: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3474: RAISE FND_API.G_EXC_ERROR;
3475: END IF;
3476:
3477: -- Process requests for Service

Line 3474: RAISE FND_API.G_EXC_ERROR;

3470: );
3471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3473: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3474: RAISE FND_API.G_EXC_ERROR;
3475: END IF;
3476:
3477: -- Process requests for Service
3478: Process_Request_for_ReqType

Line 3480: ,p_delete => FND_API.G_TRUE

3476:
3477: -- Process requests for Service
3478: Process_Request_for_ReqType
3479: (p_request_type => OE_GLOBALS.G_INSERT_SERVICE
3480: ,p_delete => FND_API.G_TRUE
3481: ,x_return_status => l_return_status
3482: );
3483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3479: (p_request_type => OE_GLOBALS.G_INSERT_SERVICE
3480: ,p_delete => FND_API.G_TRUE
3481: ,x_return_status => l_return_status
3482: );
3483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3485: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3486: RAISE FND_API.G_EXC_ERROR;
3487: END IF;

Line 3484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3480: ,p_delete => FND_API.G_TRUE
3481: ,x_return_status => l_return_status
3482: );
3483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3485: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3486: RAISE FND_API.G_EXC_ERROR;
3487: END IF;
3488:

Line 3485: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3481: ,x_return_status => l_return_status
3482: );
3483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3485: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3486: RAISE FND_API.G_EXC_ERROR;
3487: END IF;
3488:
3489: /* Added the below call for bug 5925600 */

Line 3486: RAISE FND_API.G_EXC_ERROR;

3482: );
3483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3485: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3486: RAISE FND_API.G_EXC_ERROR;
3487: END IF;
3488:
3489: /* Added the below call for bug 5925600 */
3490: Process_Request_for_ReqType

Line 3492: ,p_delete => FND_API.G_TRUE

3488:
3489: /* Added the below call for bug 5925600 */
3490: Process_Request_for_ReqType
3491: (p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE
3492: ,p_delete => FND_API.G_TRUE
3493: ,x_return_status => l_return_status
3494: );
3495: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3495: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3491: (p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE
3492: ,p_delete => FND_API.G_TRUE
3493: ,x_return_status => l_return_status
3494: );
3495: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3497: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3498: RAISE FND_API.G_EXC_ERROR;
3499: END IF;

Line 3496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3492: ,p_delete => FND_API.G_TRUE
3493: ,x_return_status => l_return_status
3494: );
3495: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3497: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3498: RAISE FND_API.G_EXC_ERROR;
3499: END IF;
3500: /* Bug 9845427 */

Line 3497: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3493: ,x_return_status => l_return_status
3494: );
3495: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3497: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3498: RAISE FND_API.G_EXC_ERROR;
3499: END IF;
3500: /* Bug 9845427 */
3501: Process_Request_for_ReqType

Line 3498: RAISE FND_API.G_EXC_ERROR;

3494: );
3495: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3497: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3498: RAISE FND_API.G_EXC_ERROR;
3499: END IF;
3500: /* Bug 9845427 */
3501: Process_Request_for_ReqType
3502: (p_request_type => OE_GLOBALS.G_DELAYED_SCHEDULE

Line 3503: ,p_delete => FND_API.G_TRUE

3499: END IF;
3500: /* Bug 9845427 */
3501: Process_Request_for_ReqType
3502: (p_request_type => OE_GLOBALS.G_DELAYED_SCHEDULE
3503: ,p_delete => FND_API.G_TRUE
3504: ,x_return_status => l_return_status
3505: );
3506: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3506: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3502: (p_request_type => OE_GLOBALS.G_DELAYED_SCHEDULE
3503: ,p_delete => FND_API.G_TRUE
3504: ,x_return_status => l_return_status
3505: );
3506: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3508: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3509: RAISE FND_API.G_EXC_ERROR;
3510: END IF;

Line 3507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3503: ,p_delete => FND_API.G_TRUE
3504: ,x_return_status => l_return_status
3505: );
3506: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3508: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3509: RAISE FND_API.G_EXC_ERROR;
3510: END IF;
3511: /* End of Bug 9845427 */

Line 3508: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3504: ,x_return_status => l_return_status
3505: );
3506: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3508: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3509: RAISE FND_API.G_EXC_ERROR;
3510: END IF;
3511: /* End of Bug 9845427 */
3512:

Line 3509: RAISE FND_API.G_EXC_ERROR;

3505: );
3506: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3508: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3509: RAISE FND_API.G_EXC_ERROR;
3510: END IF;
3511: /* End of Bug 9845427 */
3512:
3513: Process_Request_for_ReqType

Line 3515: ,p_delete => FND_API.G_TRUE

3511: /* End of Bug 9845427 */
3512:
3513: Process_Request_for_ReqType
3514: (p_request_type => OE_GLOBALS.G_CASCADE_OPTIONS_SERVICE
3515: ,p_delete => FND_API.G_TRUE
3516: ,x_return_status => l_return_status
3517: );
3518: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3518: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3514: (p_request_type => OE_GLOBALS.G_CASCADE_OPTIONS_SERVICE
3515: ,p_delete => FND_API.G_TRUE
3516: ,x_return_status => l_return_status
3517: );
3518: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3520: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3521: RAISE FND_API.G_EXC_ERROR;
3522: END IF;

Line 3519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3515: ,p_delete => FND_API.G_TRUE
3516: ,x_return_status => l_return_status
3517: );
3518: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3520: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3521: RAISE FND_API.G_EXC_ERROR;
3522: END IF;
3523: /* End of changes done for bug 5925600 */

Line 3520: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3516: ,x_return_status => l_return_status
3517: );
3518: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3520: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3521: RAISE FND_API.G_EXC_ERROR;
3522: END IF;
3523: /* End of changes done for bug 5925600 */
3524:

Line 3521: RAISE FND_API.G_EXC_ERROR;

3517: );
3518: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3520: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3521: RAISE FND_API.G_EXC_ERROR;
3522: END IF;
3523: /* End of changes done for bug 5925600 */
3524:
3525: -- bug 5717671/5736696, need to execute copy header adj

Line 3528: ,p_delete => FND_API.G_TRUE

3524:
3525: -- bug 5717671/5736696, need to execute copy header adj
3526: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3527: (p_request_type =>OE_GLOBALS.G_COPY_HEADER_ADJUSTMENTS
3528: ,p_delete => FND_API.G_TRUE
3529: ,x_return_status => l_return_status
3530: );
3531: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3531: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3527: (p_request_type =>OE_GLOBALS.G_COPY_HEADER_ADJUSTMENTS
3528: ,p_delete => FND_API.G_TRUE
3529: ,x_return_status => l_return_status
3530: );
3531: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3534: RAISE FND_API.G_EXC_ERROR;
3535: END IF;

Line 3532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3528: ,p_delete => FND_API.G_TRUE
3529: ,x_return_status => l_return_status
3530: );
3531: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3534: RAISE FND_API.G_EXC_ERROR;
3535: END IF;
3536:

Line 3533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3529: ,x_return_status => l_return_status
3530: );
3531: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3534: RAISE FND_API.G_EXC_ERROR;
3535: END IF;
3536:
3537:

Line 3534: RAISE FND_API.G_EXC_ERROR;

3530: );
3531: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3534: RAISE FND_API.G_EXC_ERROR;
3535: END IF;
3536:
3537:
3538: -- bug 1834260, moved this block of code from after processing

Line 3542: ,p_delete => FND_API.G_TRUE

3538: -- bug 1834260, moved this block of code from after processing
3539: -- for request type G_PRICE_LINE to before it.
3540: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3541: (p_request_type =>OE_GLOBALS.G_COPY_ADJUSTMENTS
3542: ,p_delete => FND_API.G_TRUE
3543: ,x_return_status => l_return_status
3544: );
3545: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3545: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3541: (p_request_type =>OE_GLOBALS.G_COPY_ADJUSTMENTS
3542: ,p_delete => FND_API.G_TRUE
3543: ,x_return_status => l_return_status
3544: );
3545: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3547: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3548: RAISE FND_API.G_EXC_ERROR;
3549: END IF;

Line 3546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3542: ,p_delete => FND_API.G_TRUE
3543: ,x_return_status => l_return_status
3544: );
3545: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3547: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3548: RAISE FND_API.G_EXC_ERROR;
3549: END IF;
3550:

Line 3547: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3543: ,x_return_status => l_return_status
3544: );
3545: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3547: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3548: RAISE FND_API.G_EXC_ERROR;
3549: END IF;
3550:
3551: -- Process Requests for Freight Rating.

Line 3548: RAISE FND_API.G_EXC_ERROR;

3544: );
3545: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3547: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3548: RAISE FND_API.G_EXC_ERROR;
3549: END IF;
3550:
3551: -- Process Requests for Freight Rating.
3552: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 3554: ,p_delete => FND_API.G_TRUE

3550:
3551: -- Process Requests for Freight Rating.
3552: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3553: (p_request_type =>OE_GLOBALS.G_FREIGHT_RATING
3554: ,p_delete => FND_API.G_TRUE
3555: ,x_return_status => l_return_status
3556: );
3557: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3557: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3553: (p_request_type =>OE_GLOBALS.G_FREIGHT_RATING
3554: ,p_delete => FND_API.G_TRUE
3555: ,x_return_status => l_return_status
3556: );
3557: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3559: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3560: RAISE FND_API.G_EXC_ERROR;
3561: END IF;

Line 3558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3554: ,p_delete => FND_API.G_TRUE
3555: ,x_return_status => l_return_status
3556: );
3557: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3559: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3560: RAISE FND_API.G_EXC_ERROR;
3561: END IF;
3562:

Line 3559: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3555: ,x_return_status => l_return_status
3556: );
3557: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3559: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3560: RAISE FND_API.G_EXC_ERROR;
3561: END IF;
3562:
3563: /* Added for Bug # 1559906 */

Line 3560: RAISE FND_API.G_EXC_ERROR;

3556: );
3557: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3559: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3560: RAISE FND_API.G_EXC_ERROR;
3561: END IF;
3562:
3563: /* Added for Bug # 1559906 */
3564: /* Renga- copy_freight_charges delayed request should be executed

Line 3570: ,p_delete => FND_API.G_TRUE

3566: request in between copy_adjustments and copy_freight_charges */
3567:
3568: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3569: (p_request_type =>OE_GLOBALS.G_COPY_FREIGHT_CHARGES
3570: ,p_delete => FND_API.G_TRUE
3571: ,x_return_status => l_return_status
3572: );
3573: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3573: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3569: (p_request_type =>OE_GLOBALS.G_COPY_FREIGHT_CHARGES
3570: ,p_delete => FND_API.G_TRUE
3571: ,x_return_status => l_return_status
3572: );
3573: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3575: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3576: RAISE FND_API.G_EXC_ERROR;
3577: END IF;

Line 3574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3570: ,p_delete => FND_API.G_TRUE
3571: ,x_return_status => l_return_status
3572: );
3573: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3575: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3576: RAISE FND_API.G_EXC_ERROR;
3577: END IF;
3578:

Line 3575: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3571: ,x_return_status => l_return_status
3572: );
3573: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3575: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3576: RAISE FND_API.G_EXC_ERROR;
3577: END IF;
3578:
3579:

Line 3576: RAISE FND_API.G_EXC_ERROR;

3572: );
3573: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3575: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3576: RAISE FND_API.G_EXC_ERROR;
3577: END IF;
3578:
3579:
3580: -- Process Requests for Pricing

Line 3583: ,p_delete => FND_API.G_TRUE

3579:
3580: -- Process Requests for Pricing
3581: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3582: (p_request_type =>OE_GLOBALS.G_PRICE_LINE
3583: ,p_delete => FND_API.G_TRUE
3584: ,x_return_status => l_return_status
3585: );
3586: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3586: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3582: (p_request_type =>OE_GLOBALS.G_PRICE_LINE
3583: ,p_delete => FND_API.G_TRUE
3584: ,x_return_status => l_return_status
3585: );
3586: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3588: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3589: RAISE FND_API.G_EXC_ERROR;
3590: END IF;

Line 3587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3583: ,p_delete => FND_API.G_TRUE
3584: ,x_return_status => l_return_status
3585: );
3586: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3588: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3589: RAISE FND_API.G_EXC_ERROR;
3590: END IF;
3591:

Line 3588: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3584: ,x_return_status => l_return_status
3585: );
3586: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3588: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3589: RAISE FND_API.G_EXC_ERROR;
3590: END IF;
3591:
3592:

Line 3589: RAISE FND_API.G_EXC_ERROR;

3585: );
3586: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3588: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3589: RAISE FND_API.G_EXC_ERROR;
3590: END IF;
3591:
3592:
3593: -- Renga - added freight_for_included items call

Line 3597: ,p_delete => FND_API.G_TRUE

3593: -- Renga - added freight_for_included items call
3594: -- Process Requests for Freight For included items.
3595: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3596: (p_request_type =>OE_GLOBALS.G_FREIGHT_FOR_INCLUDED
3597: ,p_delete => FND_API.G_TRUE
3598: ,x_return_status => l_return_status
3599: );
3600: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3600: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3596: (p_request_type =>OE_GLOBALS.G_FREIGHT_FOR_INCLUDED
3597: ,p_delete => FND_API.G_TRUE
3598: ,x_return_status => l_return_status
3599: );
3600: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3602: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3603: RAISE FND_API.G_EXC_ERROR;
3604: END IF;

Line 3601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3597: ,p_delete => FND_API.G_TRUE
3598: ,x_return_status => l_return_status
3599: );
3600: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3602: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3603: RAISE FND_API.G_EXC_ERROR;
3604: END IF;
3605:

Line 3602: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3598: ,x_return_status => l_return_status
3599: );
3600: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3602: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3603: RAISE FND_API.G_EXC_ERROR;
3604: END IF;
3605:
3606: -- Renga - done for freight for included items.

Line 3603: RAISE FND_API.G_EXC_ERROR;

3599: );
3600: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3602: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3603: RAISE FND_API.G_EXC_ERROR;
3604: END IF;
3605:
3606: -- Renga - done for freight for included items.
3607:

Line 3611: ,p_delete => FND_API.G_TRUE

3607:
3608:
3609: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3610: (p_request_type =>OE_GLOBALS.G_PRICE_ORDER
3611: ,p_delete => FND_API.G_TRUE
3612: ,x_return_status => l_return_status
3613: );
3614: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3614: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3610: (p_request_type =>OE_GLOBALS.G_PRICE_ORDER
3611: ,p_delete => FND_API.G_TRUE
3612: ,x_return_status => l_return_status
3613: );
3614: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3616: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3617: RAISE FND_API.G_EXC_ERROR;
3618: END IF;

Line 3615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3611: ,p_delete => FND_API.G_TRUE
3612: ,x_return_status => l_return_status
3613: );
3614: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3616: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3617: RAISE FND_API.G_EXC_ERROR;
3618: END IF;
3619:

Line 3616: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3612: ,x_return_status => l_return_status
3613: );
3614: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3616: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3617: RAISE FND_API.G_EXC_ERROR;
3618: END IF;
3619:
3620: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 3617: RAISE FND_API.G_EXC_ERROR;

3613: );
3614: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3616: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3617: RAISE FND_API.G_EXC_ERROR;
3618: END IF;
3619:
3620: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3621: (p_request_type =>OE_GLOBALS.G_PRICE_ADJ

Line 3622: ,p_delete => FND_API.G_TRUE

3618: END IF;
3619:
3620: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3621: (p_request_type =>OE_GLOBALS.G_PRICE_ADJ
3622: ,p_delete => FND_API.G_TRUE
3623: ,x_return_status => l_return_status
3624: );
3625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3621: (p_request_type =>OE_GLOBALS.G_PRICE_ADJ
3622: ,p_delete => FND_API.G_TRUE
3623: ,x_return_status => l_return_status
3624: );
3625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3627: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3628: RAISE FND_API.G_EXC_ERROR;
3629: END IF;

Line 3626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3622: ,p_delete => FND_API.G_TRUE
3623: ,x_return_status => l_return_status
3624: );
3625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3627: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3628: RAISE FND_API.G_EXC_ERROR;
3629: END IF;
3630:

Line 3627: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3623: ,x_return_status => l_return_status
3624: );
3625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3627: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3628: RAISE FND_API.G_EXC_ERROR;
3629: END IF;
3630:
3631: -- added by lkxu

Line 3628: RAISE FND_API.G_EXC_ERROR;

3624: );
3625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3627: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3628: RAISE FND_API.G_EXC_ERROR;
3629: END IF;
3630:
3631: -- added by lkxu
3632: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 3634: ,p_delete => FND_API.G_TRUE

3630:
3631: -- added by lkxu
3632: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3633: (p_request_type =>OE_GLOBALS.G_COPY_PRICING_ATTRIBUTES
3634: ,p_delete => FND_API.G_TRUE
3635: ,x_return_status => l_return_status
3636: );
3637: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3637: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3633: (p_request_type =>OE_GLOBALS.G_COPY_PRICING_ATTRIBUTES
3634: ,p_delete => FND_API.G_TRUE
3635: ,x_return_status => l_return_status
3636: );
3637: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3640: RAISE FND_API.G_EXC_ERROR;
3641: END IF;

Line 3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3634: ,p_delete => FND_API.G_TRUE
3635: ,x_return_status => l_return_status
3636: );
3637: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3640: RAISE FND_API.G_EXC_ERROR;
3641: END IF;
3642:

Line 3639: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3635: ,x_return_status => l_return_status
3636: );
3637: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3640: RAISE FND_API.G_EXC_ERROR;
3641: END IF;
3642:
3643: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 3640: RAISE FND_API.G_EXC_ERROR;

3636: );
3637: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3640: RAISE FND_API.G_EXC_ERROR;
3641: END IF;
3642:
3643: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3644: (p_request_type =>OE_GLOBALS.G_COPY_MODEL_PATTR

Line 3645: ,p_delete => FND_API.G_TRUE

3641: END IF;
3642:
3643: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3644: (p_request_type =>OE_GLOBALS.G_COPY_MODEL_PATTR
3645: ,p_delete => FND_API.G_TRUE
3646: ,x_return_status => l_return_status
3647: );
3648: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3648: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3644: (p_request_type =>OE_GLOBALS.G_COPY_MODEL_PATTR
3645: ,p_delete => FND_API.G_TRUE
3646: ,x_return_status => l_return_status
3647: );
3648: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3650: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3651: RAISE FND_API.G_EXC_ERROR;
3652: END IF;

Line 3649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3645: ,p_delete => FND_API.G_TRUE
3646: ,x_return_status => l_return_status
3647: );
3648: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3650: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3651: RAISE FND_API.G_EXC_ERROR;
3652: END IF;
3653:

Line 3650: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3646: ,x_return_status => l_return_status
3647: );
3648: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3650: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3651: RAISE FND_API.G_EXC_ERROR;
3652: END IF;
3653:
3654: -- Process Delete Charges Delayed Requests

Line 3651: RAISE FND_API.G_EXC_ERROR;

3647: );
3648: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3650: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3651: RAISE FND_API.G_EXC_ERROR;
3652: END IF;
3653:
3654: -- Process Delete Charges Delayed Requests
3655: Process_Request_for_ReqType

Line 3657: ,p_delete => FND_API.G_TRUE

3653:
3654: -- Process Delete Charges Delayed Requests
3655: Process_Request_for_ReqType
3656: (p_request_type => OE_GLOBALS.G_DELETE_CHARGES
3657: ,p_delete => FND_API.G_TRUE
3658: ,x_return_status => l_return_status
3659: );
3660: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3660: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3656: (p_request_type => OE_GLOBALS.G_DELETE_CHARGES
3657: ,p_delete => FND_API.G_TRUE
3658: ,x_return_status => l_return_status
3659: );
3660: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3662: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3663: RAISE FND_API.G_EXC_ERROR;
3664: END IF;

Line 3661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3657: ,p_delete => FND_API.G_TRUE
3658: ,x_return_status => l_return_status
3659: );
3660: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3662: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3663: RAISE FND_API.G_EXC_ERROR;
3664: END IF;
3665:

Line 3662: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3658: ,x_return_status => l_return_status
3659: );
3660: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3662: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3663: RAISE FND_API.G_EXC_ERROR;
3664: END IF;
3665:
3666: -- Process Tax Delayed Requests

Line 3663: RAISE FND_API.G_EXC_ERROR;

3659: );
3660: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3662: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3663: RAISE FND_API.G_EXC_ERROR;
3664: END IF;
3665:
3666: -- Process Tax Delayed Requests
3667: Process_Request_for_ReqType

Line 3669: ,p_delete => FND_API.G_TRUE

3665:
3666: -- Process Tax Delayed Requests
3667: Process_Request_for_ReqType
3668: (p_request_type => OE_GLOBALS.G_TAX_LINE
3669: ,p_delete => FND_API.G_TRUE
3670: ,x_return_status => l_return_status
3671: );
3672: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3672: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3668: (p_request_type => OE_GLOBALS.G_TAX_LINE
3669: ,p_delete => FND_API.G_TRUE
3670: ,x_return_status => l_return_status
3671: );
3672: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3674: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3675: RAISE FND_API.G_EXC_ERROR;
3676: END IF;

Line 3673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3669: ,p_delete => FND_API.G_TRUE
3670: ,x_return_status => l_return_status
3671: );
3672: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3674: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3675: RAISE FND_API.G_EXC_ERROR;
3676: END IF;
3677:

Line 3674: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3670: ,x_return_status => l_return_status
3671: );
3672: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3674: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3675: RAISE FND_API.G_EXC_ERROR;
3676: END IF;
3677:
3678:

Line 3675: RAISE FND_API.G_EXC_ERROR;

3671: );
3672: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3674: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3675: RAISE FND_API.G_EXC_ERROR;
3676: END IF;
3677:
3678:
3679: -- Process Commitment Delayed Requests

Line 3682: ,p_delete => FND_API.G_TRUE

3678:
3679: -- Process Commitment Delayed Requests
3680: Process_Request_for_ReqType
3681: (p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT
3682: ,p_delete => FND_API.G_TRUE
3683: ,x_return_status => l_return_status
3684: );
3685: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3685: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3681: (p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT
3682: ,p_delete => FND_API.G_TRUE
3683: ,x_return_status => l_return_status
3684: );
3685: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3687: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3688: RAISE FND_API.G_EXC_ERROR;
3689: END IF;

Line 3686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3682: ,p_delete => FND_API.G_TRUE
3683: ,x_return_status => l_return_status
3684: );
3685: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3687: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3688: RAISE FND_API.G_EXC_ERROR;
3689: END IF;
3690:

Line 3687: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3683: ,x_return_status => l_return_status
3684: );
3685: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3687: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3688: RAISE FND_API.G_EXC_ERROR;
3689: END IF;
3690:
3691: -- Process Commitment Delayed Requests

Line 3688: RAISE FND_API.G_EXC_ERROR;

3684: );
3685: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3687: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3688: RAISE FND_API.G_EXC_ERROR;
3689: END IF;
3690:
3691: -- Process Commitment Delayed Requests
3692: Process_Request_for_ReqType

Line 3694: ,p_delete => FND_API.G_TRUE

3690:
3691: -- Process Commitment Delayed Requests
3692: Process_Request_for_ReqType
3693: (p_request_type => OE_GLOBALS.G_UPDATE_COMMITMENT
3694: ,p_delete => FND_API.G_TRUE
3695: ,x_return_status => l_return_status
3696: );
3697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3693: (p_request_type => OE_GLOBALS.G_UPDATE_COMMITMENT
3694: ,p_delete => FND_API.G_TRUE
3695: ,x_return_status => l_return_status
3696: );
3697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3700: RAISE FND_API.G_EXC_ERROR;
3701: END IF;

Line 3698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3694: ,p_delete => FND_API.G_TRUE
3695: ,x_return_status => l_return_status
3696: );
3697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3700: RAISE FND_API.G_EXC_ERROR;
3701: END IF;
3702:

Line 3699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3695: ,x_return_status => l_return_status
3696: );
3697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3700: RAISE FND_API.G_EXC_ERROR;
3701: END IF;
3702:
3703: -- for multiple payments

Line 3700: RAISE FND_API.G_EXC_ERROR;

3696: );
3697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3700: RAISE FND_API.G_EXC_ERROR;
3701: END IF;
3702:
3703: -- for multiple payments
3704: Process_Request_for_ReqType

Line 3706: ,p_delete => FND_API.G_TRUE

3702:
3703: -- for multiple payments
3704: Process_Request_for_ReqType
3705: (p_request_type => OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED
3706: ,p_delete => FND_API.G_TRUE
3707: ,x_return_status => l_return_status
3708: );
3709: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3709: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3705: (p_request_type => OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED
3706: ,p_delete => FND_API.G_TRUE
3707: ,x_return_status => l_return_status
3708: );
3709: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3711: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3712: RAISE FND_API.G_EXC_ERROR;
3713: END IF;

Line 3710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3706: ,p_delete => FND_API.G_TRUE
3707: ,x_return_status => l_return_status
3708: );
3709: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3711: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3712: RAISE FND_API.G_EXC_ERROR;
3713: END IF;
3714:

Line 3711: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3707: ,x_return_status => l_return_status
3708: );
3709: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3711: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3712: RAISE FND_API.G_EXC_ERROR;
3713: END IF;
3714:
3715: -- for multiple payments

Line 3712: RAISE FND_API.G_EXC_ERROR;

3708: );
3709: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3711: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3712: RAISE FND_API.G_EXC_ERROR;
3713: END IF;
3714:
3715: -- for multiple payments
3716: Process_Request_for_ReqType

Line 3718: ,p_delete => FND_API.G_TRUE

3714:
3715: -- for multiple payments
3716: Process_Request_for_ReqType
3717: (p_request_type => OE_GLOBALS.G_SPLIT_PAYMENT
3718: ,p_delete => FND_API.G_TRUE
3719: ,x_return_status => l_return_status
3720: );
3721: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3721: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3717: (p_request_type => OE_GLOBALS.G_SPLIT_PAYMENT
3718: ,p_delete => FND_API.G_TRUE
3719: ,x_return_status => l_return_status
3720: );
3721: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3723: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3724: RAISE FND_API.G_EXC_ERROR;
3725: END IF;

Line 3722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3718: ,p_delete => FND_API.G_TRUE
3719: ,x_return_status => l_return_status
3720: );
3721: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3723: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3724: RAISE FND_API.G_EXC_ERROR;
3725: END IF;
3726:

Line 3723: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3719: ,x_return_status => l_return_status
3720: );
3721: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3723: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3724: RAISE FND_API.G_EXC_ERROR;
3725: END IF;
3726:
3727: Process_Request_for_ReqType

Line 3724: RAISE FND_API.G_EXC_ERROR;

3720: );
3721: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3723: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3724: RAISE FND_API.G_EXC_ERROR;
3725: END IF;
3726:
3727: Process_Request_for_ReqType
3728: (p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT

Line 3729: ,p_delete => FND_API.G_TRUE

3725: END IF;
3726:
3727: Process_Request_for_ReqType
3728: (p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT
3729: ,p_delete => FND_API.G_TRUE
3730: ,x_return_status => l_return_status
3731: );
3732: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3732: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3728: (p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT
3729: ,p_delete => FND_API.G_TRUE
3730: ,x_return_status => l_return_status
3731: );
3732: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3734: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3735: RAISE FND_API.G_EXC_ERROR;
3736: END IF;

Line 3733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3729: ,p_delete => FND_API.G_TRUE
3730: ,x_return_status => l_return_status
3731: );
3732: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3734: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3735: RAISE FND_API.G_EXC_ERROR;
3736: END IF;
3737:

Line 3734: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3730: ,x_return_status => l_return_status
3731: );
3732: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3734: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3735: RAISE FND_API.G_EXC_ERROR;
3736: END IF;
3737:
3738: -- Process requests for Payment Verification

Line 3735: RAISE FND_API.G_EXC_ERROR;

3731: );
3732: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3734: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3735: RAISE FND_API.G_EXC_ERROR;
3736: END IF;
3737:
3738: -- Process requests for Payment Verification
3739: Process_Request_for_ReqType

Line 3741: ,p_delete => FND_API.G_TRUE

3737:
3738: -- Process requests for Payment Verification
3739: Process_Request_for_ReqType
3740: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
3741: ,p_delete => FND_API.G_TRUE
3742: ,x_return_status => l_return_status
3743: );
3744: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3744: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3740: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
3741: ,p_delete => FND_API.G_TRUE
3742: ,x_return_status => l_return_status
3743: );
3744: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3746: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3747: RAISE FND_API.G_EXC_ERROR;
3748: END IF;

Line 3745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3741: ,p_delete => FND_API.G_TRUE
3742: ,x_return_status => l_return_status
3743: );
3744: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3746: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3747: RAISE FND_API.G_EXC_ERROR;
3748: END IF;
3749:

Line 3746: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3742: ,x_return_status => l_return_status
3743: );
3744: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3746: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3747: RAISE FND_API.G_EXC_ERROR;
3748: END IF;
3749:
3750: Process_Request_for_ReqType

Line 3747: RAISE FND_API.G_EXC_ERROR;

3743: );
3744: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3746: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3747: RAISE FND_API.G_EXC_ERROR;
3748: END IF;
3749:
3750: Process_Request_for_ReqType
3751: (p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD

Line 3752: ,p_delete => FND_API.G_TRUE

3748: END IF;
3749:
3750: Process_Request_for_ReqType
3751: (p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD
3752: ,p_delete => FND_API.G_TRUE
3753: ,x_return_status => l_return_status
3754: );
3755: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3755: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3751: (p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD
3752: ,p_delete => FND_API.G_TRUE
3753: ,x_return_status => l_return_status
3754: );
3755: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3757: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3758: RAISE FND_API.G_EXC_ERROR;
3759: END IF;

Line 3756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3752: ,p_delete => FND_API.G_TRUE
3753: ,x_return_status => l_return_status
3754: );
3755: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3757: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3758: RAISE FND_API.G_EXC_ERROR;
3759: END IF;
3760:

Line 3757: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3753: ,x_return_status => l_return_status
3754: );
3755: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3757: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3758: RAISE FND_API.G_EXC_ERROR;
3759: END IF;
3760:
3761: -- Process Request to create automatic attachments

Line 3758: RAISE FND_API.G_EXC_ERROR;

3754: );
3755: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3757: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3758: RAISE FND_API.G_EXC_ERROR;
3759: END IF;
3760:
3761: -- Process Request to create automatic attachments
3762: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 3764: ,p_delete => FND_API.G_TRUE

3760:
3761: -- Process Request to create automatic attachments
3762: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3763: (p_request_type =>OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
3764: ,p_delete => FND_API.G_TRUE
3765: ,x_return_status => l_return_status
3766: );
3767: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3767: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3763: (p_request_type =>OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
3764: ,p_delete => FND_API.G_TRUE
3765: ,x_return_status => l_return_status
3766: );
3767: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3769: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3770: RAISE FND_API.G_EXC_ERROR;
3771: END IF;

Line 3768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3764: ,p_delete => FND_API.G_TRUE
3765: ,x_return_status => l_return_status
3766: );
3767: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3769: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3770: RAISE FND_API.G_EXC_ERROR;
3771: END IF;
3772:

Line 3769: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3765: ,x_return_status => l_return_status
3766: );
3767: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3769: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3770: RAISE FND_API.G_EXC_ERROR;
3771: END IF;
3772:
3773: -- Process Request to copy attachments

Line 3770: RAISE FND_API.G_EXC_ERROR;

3766: );
3767: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3769: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3770: RAISE FND_API.G_EXC_ERROR;
3771: END IF;
3772:
3773: -- Process Request to copy attachments
3774: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 3776: ,p_delete => FND_API.G_TRUE

3772:
3773: -- Process Request to copy attachments
3774: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3775: (p_request_type =>OE_GLOBALS.G_COPY_ATCHMT
3776: ,p_delete => FND_API.G_TRUE
3777: ,x_return_status => l_return_status
3778: );
3779: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3779: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3775: (p_request_type =>OE_GLOBALS.G_COPY_ATCHMT
3776: ,p_delete => FND_API.G_TRUE
3777: ,x_return_status => l_return_status
3778: );
3779: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3781: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3782: RAISE FND_API.G_EXC_ERROR;
3783: END IF;

Line 3780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3776: ,p_delete => FND_API.G_TRUE
3777: ,x_return_status => l_return_status
3778: );
3779: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3781: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3782: RAISE FND_API.G_EXC_ERROR;
3783: END IF;
3784:

Line 3781: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3777: ,x_return_status => l_return_status
3778: );
3779: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3781: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3782: RAISE FND_API.G_EXC_ERROR;
3783: END IF;
3784:
3785: --added by MShenoy for Spares Management ikon project - Create internal req.

Line 3782: RAISE FND_API.G_EXC_ERROR;

3778: );
3779: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3781: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3782: RAISE FND_API.G_EXC_ERROR;
3783: END IF;
3784:
3785: --added by MShenoy for Spares Management ikon project - Create internal req.
3786: IF l_debug_level > 0 THEN

Line 3792: ,p_delete => FND_API.G_TRUE

3788: END IF;
3789:
3790: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3791: (p_request_type =>OE_GLOBALS.G_CREATE_INTERNAL_REQ
3792: ,p_delete => FND_API.G_TRUE
3793: ,x_return_status => l_return_status);
3794: IF l_debug_level > 0 THEN
3795: oe_debug_pub.add(' leaving Procedure process_Delayed_Requests in Package
3796: OE_Delayed_Requests_Pvt ret status '||l_return_status);

Line 3798: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3794: IF l_debug_level > 0 THEN
3795: oe_debug_pub.add(' leaving Procedure process_Delayed_Requests in Package
3796: OE_Delayed_Requests_Pvt ret status '||l_return_status);
3797: END IF;
3798: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3800: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3801: RAISE FND_API.G_EXC_ERROR;
3802: END IF;

Line 3799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3795: oe_debug_pub.add(' leaving Procedure process_Delayed_Requests in Package
3796: OE_Delayed_Requests_Pvt ret status '||l_return_status);
3797: END IF;
3798: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3800: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3801: RAISE FND_API.G_EXC_ERROR;
3802: END IF;
3803:

Line 3800: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3796: OE_Delayed_Requests_Pvt ret status '||l_return_status);
3797: END IF;
3798: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3800: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3801: RAISE FND_API.G_EXC_ERROR;
3802: END IF;
3803:
3804: -- B2013611 reverse promotional limits

Line 3801: RAISE FND_API.G_EXC_ERROR;

3797: END IF;
3798: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3800: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3801: RAISE FND_API.G_EXC_ERROR;
3802: END IF;
3803:
3804: -- B2013611 reverse promotional limits
3805: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 3807: ,p_delete => FND_API.G_TRUE

3803:
3804: -- B2013611 reverse promotional limits
3805: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3806: (p_request_type =>OE_GLOBALS.G_REVERSE_LIMITS
3807: ,p_delete => FND_API.G_TRUE
3808: ,x_return_status => l_return_status
3809: );
3810: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3810: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3806: (p_request_type =>OE_GLOBALS.G_REVERSE_LIMITS
3807: ,p_delete => FND_API.G_TRUE
3808: ,x_return_status => l_return_status
3809: );
3810: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3812: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3813: RAISE FND_API.G_EXC_ERROR;
3814: END IF;

Line 3811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3807: ,p_delete => FND_API.G_TRUE
3808: ,x_return_status => l_return_status
3809: );
3810: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3812: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3813: RAISE FND_API.G_EXC_ERROR;
3814: END IF;
3815:

Line 3812: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3808: ,x_return_status => l_return_status
3809: );
3810: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3812: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3813: RAISE FND_API.G_EXC_ERROR;
3814: END IF;
3815:
3816: --MRG BGN

Line 3813: RAISE FND_API.G_EXC_ERROR;

3809: );
3810: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3812: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3813: RAISE FND_API.G_EXC_ERROR;
3814: END IF;
3815:
3816: --MRG BGN
3817: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 3819: ,p_delete => FND_API.G_TRUE

3815:
3816: --MRG BGN
3817: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3818: (p_request_type => OE_GLOBALS.G_MARGIN_HOLD
3819: ,p_delete => FND_API.G_TRUE
3820: ,x_return_status => l_return_status
3821: );
3822: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3822: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3818: (p_request_type => OE_GLOBALS.G_MARGIN_HOLD
3819: ,p_delete => FND_API.G_TRUE
3820: ,x_return_status => l_return_status
3821: );
3822: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3824: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3825: RAISE FND_API.G_EXC_ERROR;
3826: END IF;

Line 3823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3819: ,p_delete => FND_API.G_TRUE
3820: ,x_return_status => l_return_status
3821: );
3822: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3824: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3825: RAISE FND_API.G_EXC_ERROR;
3826: END IF;
3827: --MRG END

Line 3824: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3820: ,x_return_status => l_return_status
3821: );
3822: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3824: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3825: RAISE FND_API.G_EXC_ERROR;
3826: END IF;
3827: --MRG END
3828:

Line 3825: RAISE FND_API.G_EXC_ERROR;

3821: );
3822: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3824: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3825: RAISE FND_API.G_EXC_ERROR;
3826: END IF;
3827: --MRG END
3828:
3829:

Line 3840: ,p_delete => FND_API.G_TRUE

3836: oe_debug_pub.add('before call to OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype in process_delayed_requests');
3837: END IF;
3838: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3839: (p_request_type => OE_GLOBALS.G_GET_COST
3840: ,p_delete => FND_API.G_TRUE
3841: ,x_return_status => l_return_status
3842: );
3843: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3843: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3839: (p_request_type => OE_GLOBALS.G_GET_COST
3840: ,p_delete => FND_API.G_TRUE
3841: ,x_return_status => l_return_status
3842: );
3843: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3845: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3846: RAISE FND_API.G_EXC_ERROR;
3847: END IF;

Line 3844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3840: ,p_delete => FND_API.G_TRUE
3841: ,x_return_status => l_return_status
3842: );
3843: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3845: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3846: RAISE FND_API.G_EXC_ERROR;
3847: END IF;
3848: --MRG END

Line 3845: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3841: ,x_return_status => l_return_status
3842: );
3843: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3845: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3846: RAISE FND_API.G_EXC_ERROR;
3847: END IF;
3848: --MRG END
3849:

Line 3846: RAISE FND_API.G_EXC_ERROR;

3842: );
3843: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3845: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3846: RAISE FND_API.G_EXC_ERROR;
3847: END IF;
3848: --MRG END
3849:
3850:

Line 3853: ,p_delete => FND_API.G_TRUE

3849:
3850:
3851: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3852: (p_request_type =>OE_GLOBALS.G_DEL_CHG_LINES
3853: ,p_delete => FND_API.G_TRUE
3854: ,x_return_status => l_return_status
3855: );
3856: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3856: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3852: (p_request_type =>OE_GLOBALS.G_DEL_CHG_LINES
3853: ,p_delete => FND_API.G_TRUE
3854: ,x_return_status => l_return_status
3855: );
3856: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3858: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3859: RAISE FND_API.G_EXC_ERROR;
3860: END IF;

Line 3857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3853: ,p_delete => FND_API.G_TRUE
3854: ,x_return_status => l_return_status
3855: );
3856: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3858: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3859: RAISE FND_API.G_EXC_ERROR;
3860: END IF;
3861:

Line 3858: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3854: ,x_return_status => l_return_status
3855: );
3856: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3858: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3859: RAISE FND_API.G_EXC_ERROR;
3860: END IF;
3861:
3862:

Line 3859: RAISE FND_API.G_EXC_ERROR;

3855: );
3856: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3858: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3859: RAISE FND_API.G_EXC_ERROR;
3860: END IF;
3861:
3862:
3863: --process delayed requests for xml generation

Line 3867: ,p_delete => FND_API.G_TRUE

3863: --process delayed requests for xml generation
3864:
3865: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3866: (p_request_type =>OE_GLOBALS.G_GENERATE_XML_REQ_HDR
3867: ,p_delete => FND_API.G_TRUE
3868: ,x_return_status => l_return_status
3869: );
3870: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3870: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3866: (p_request_type =>OE_GLOBALS.G_GENERATE_XML_REQ_HDR
3867: ,p_delete => FND_API.G_TRUE
3868: ,x_return_status => l_return_status
3869: );
3870: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3873: RAISE FND_API.G_EXC_ERROR;
3874: END IF;

Line 3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3867: ,p_delete => FND_API.G_TRUE
3868: ,x_return_status => l_return_status
3869: );
3870: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3873: RAISE FND_API.G_EXC_ERROR;
3874: END IF;
3875:

Line 3872: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3868: ,x_return_status => l_return_status
3869: );
3870: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3873: RAISE FND_API.G_EXC_ERROR;
3874: END IF;
3875:
3876:

Line 3873: RAISE FND_API.G_EXC_ERROR;

3869: );
3870: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3873: RAISE FND_API.G_EXC_ERROR;
3874: END IF;
3875:
3876:
3877: -- Please do not put any delayed requests that can update qty

Line 3888: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3884: -- and VALIDATE_RELEASE_SHIPMENTS.
3885: OE_Blkt_Release_Util.Process_Releases
3886: (p_request_tbl => G_Delayed_Requests
3887: ,x_return_status => l_return_status);
3888: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3890: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3891: RAISE FND_API.G_EXC_ERROR;
3892: END IF;

Line 3889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3885: OE_Blkt_Release_Util.Process_Releases
3886: (p_request_tbl => G_Delayed_Requests
3887: ,x_return_status => l_return_status);
3888: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3890: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3891: RAISE FND_API.G_EXC_ERROR;
3892: END IF;
3893:

Line 3890: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3886: (p_request_tbl => G_Delayed_Requests
3887: ,x_return_status => l_return_status);
3888: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3890: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3891: RAISE FND_API.G_EXC_ERROR;
3892: END IF;
3893:
3894: -- Changes for Enhanced Dropshipments

Line 3891: RAISE FND_API.G_EXC_ERROR;

3887: ,x_return_status => l_return_status);
3888: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3890: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3891: RAISE FND_API.G_EXC_ERROR;
3892: END IF;
3893:
3894: -- Changes for Enhanced Dropshipments
3895:

Line 3899: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3895:
3896: OE_Purchase_Release_PVT.Process_DropShip_CMS_Requests
3897: (p_request_tbl => G_Delayed_Requests
3898: ,x_return_status => l_return_status);
3899: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3901: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3902: RAISE FND_API.G_EXC_ERROR;
3903: END IF;

Line 3900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3896: OE_Purchase_Release_PVT.Process_DropShip_CMS_Requests
3897: (p_request_tbl => G_Delayed_Requests
3898: ,x_return_status => l_return_status);
3899: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3901: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3902: RAISE FND_API.G_EXC_ERROR;
3903: END IF;
3904:

Line 3901: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3897: (p_request_tbl => G_Delayed_Requests
3898: ,x_return_status => l_return_status);
3899: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3901: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3902: RAISE FND_API.G_EXC_ERROR;
3903: END IF;
3904:
3905:

Line 3902: RAISE FND_API.G_EXC_ERROR;

3898: ,x_return_status => l_return_status);
3899: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3901: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3902: RAISE FND_API.G_EXC_ERROR;
3903: END IF;
3904:
3905:
3906: /* 7576948: IR ISO Change Management project Start */

Line 3917: , p_delete => FND_API.G_TRUE

3913:
3914: -- Process Request to Update the Internal Requisition
3915: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3916: ( p_request_type => OE_GLOBALS.G_UPDATE_REQUISITION
3917: , p_delete => FND_API.G_TRUE
3918: , x_return_status => l_return_status
3919: );
3920:
3921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3917: , p_delete => FND_API.G_TRUE
3918: , x_return_status => l_return_status
3919: );
3920:
3921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3923: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3924: RAISE FND_API.G_EXC_ERROR;
3925: END IF;

Line 3922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3918: , x_return_status => l_return_status
3919: );
3920:
3921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3923: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3924: RAISE FND_API.G_EXC_ERROR;
3925: END IF;
3926:

Line 3923: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3919: );
3920:
3921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3923: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3924: RAISE FND_API.G_EXC_ERROR;
3925: END IF;
3926:
3927: /* ============================= */

Line 3924: RAISE FND_API.G_EXC_ERROR;

3920:
3921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3923: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3924: RAISE FND_API.G_EXC_ERROR;
3925: END IF;
3926:
3927: /* ============================= */
3928: /* IR ISO Change Management Ends */

Line 3935: ,p_delete => FND_API.G_TRUE

3931: --process delayed requests for cancel workflow
3932:
3933: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3934: (p_request_type =>OE_GLOBALS.G_CANCEL_WF
3935: ,p_delete => FND_API.G_TRUE
3936: ,x_return_status => l_return_status
3937: );
3938: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3938: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3934: (p_request_type =>OE_GLOBALS.G_CANCEL_WF
3935: ,p_delete => FND_API.G_TRUE
3936: ,x_return_status => l_return_status
3937: );
3938: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3940: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3941: RAISE FND_API.G_EXC_ERROR;
3942: END IF;

Line 3939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3935: ,p_delete => FND_API.G_TRUE
3936: ,x_return_status => l_return_status
3937: );
3938: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3940: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3941: RAISE FND_API.G_EXC_ERROR;
3942: END IF;
3943:

Line 3940: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3936: ,x_return_status => l_return_status
3937: );
3938: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3940: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3941: RAISE FND_API.G_EXC_ERROR;
3942: END IF;
3943:
3944:

Line 3941: RAISE FND_API.G_EXC_ERROR;

3937: );
3938: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3940: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3941: RAISE FND_API.G_EXC_ERROR;
3942: END IF;
3943:
3944:
3945: /* Please do not put execution of any delayed request beyond this point */

Line 3956: ,p_delete => FND_API.G_TRUE

3952:
3953: WHILE l_ind IS NOT NULL LOOP
3954: Process_Request_Pvt
3955: (p_request_ind => l_ind
3956: ,p_delete => FND_API.G_TRUE
3957: ,x_return_status => l_return_status
3958: );
3959:
3960: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3960: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3956: ,p_delete => FND_API.G_TRUE
3957: ,x_return_status => l_return_status
3958: );
3959:
3960: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3962: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3963: RAISE FND_API.G_EXC_ERROR;
3964: END IF;

Line 3961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3957: ,x_return_status => l_return_status
3958: );
3959:
3960: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3962: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3963: RAISE FND_API.G_EXC_ERROR;
3964: END IF;
3965: l_ind := G_Delayed_Requests.Next(l_ind);

Line 3962: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3958: );
3959:
3960: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3962: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3963: RAISE FND_API.G_EXC_ERROR;
3964: END IF;
3965: l_ind := G_Delayed_Requests.Next(l_ind);
3966: END LOOP;

Line 3963: RAISE FND_API.G_EXC_ERROR;

3959:
3960: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3962: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3963: RAISE FND_API.G_EXC_ERROR;
3964: END IF;
3965: l_ind := G_Delayed_Requests.Next(l_ind);
3966: END LOOP;
3967:

Line 3971: ,p_delete => FND_API.G_TRUE

3967:
3968: -- Process Request to Complete workflow activity
3969: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3970: (p_request_type =>OE_GLOBALS.G_COMPLETE_ACTIVITY
3971: ,p_delete => FND_API.G_TRUE
3972: ,x_return_status => l_return_status
3973: );
3974: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3974: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3970: (p_request_type =>OE_GLOBALS.G_COMPLETE_ACTIVITY
3971: ,p_delete => FND_API.G_TRUE
3972: ,x_return_status => l_return_status
3973: );
3974: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3976: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3977: RAISE FND_API.G_EXC_ERROR;
3978: END IF;

Line 3975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3971: ,p_delete => FND_API.G_TRUE
3972: ,x_return_status => l_return_status
3973: );
3974: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3976: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3977: RAISE FND_API.G_EXC_ERROR;
3978: END IF;
3979: IF l_debug_level > 0 THEN

Line 3976: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3972: ,x_return_status => l_return_status
3973: );
3974: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3976: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3977: RAISE FND_API.G_EXC_ERROR;
3978: END IF;
3979: IF l_debug_level > 0 THEN
3980: oe_debug_pub.add('Global Request count-PDR-AL'||G_Delayed_Requests.count,1);

Line 3977: RAISE FND_API.G_EXC_ERROR;

3973: );
3974: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3976: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3977: RAISE FND_API.G_EXC_ERROR;
3978: END IF;
3979: IF l_debug_level > 0 THEN
3980: oe_debug_pub.add('Global Request count-PDR-AL'||G_Delayed_Requests.count,1);
3981: END IF;

Line 3991: WHEN FND_API.G_EXC_ERROR THEN

3987: p_In_out => 0);
3988:
3989: EXCEPTION
3990:
3991: WHEN FND_API.G_EXC_ERROR THEN
3992: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3993: p_In_out => 0);
3994: x_return_status := FND_API.G_RET_STS_ERROR;
3995:

Line 3994: x_return_status := FND_API.G_RET_STS_ERROR;

3990:
3991: WHEN FND_API.G_EXC_ERROR THEN
3992: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3993: p_In_out => 0);
3994: x_return_status := FND_API.G_RET_STS_ERROR;
3995:
3996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3997: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3998: p_In_out => 0);

Line 3996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3992: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3993: p_In_out => 0);
3994: x_return_status := FND_API.G_RET_STS_ERROR;
3995:
3996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3997: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3998: p_In_out => 0);
3999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4000:

Line 3999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3995:
3996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3997: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3998: p_In_out => 0);
3999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4000:
4001: WHEN OTHERS THEN
4002: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
4003: p_In_out => 0);

Line 4004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4000:
4001: WHEN OTHERS THEN
4002: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
4003: p_In_out => 0);
4004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4005:
4006: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4007: THEN
4008: OE_MSG_PUB.Add_Exc_Msg

Line 4022: (p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4018: ** processed after the flow has started (book, LINK, match_and_reserve)
4019: **/
4020:
4021: PROCEDURE Process_Order_Actions
4022: (p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4023: p_x_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type,
4024: p_process_WF_requests IN boolean DEFAULT TRUE
4025: )
4026: IS

Line 4437: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4433:
4434: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_REQUEST');
4435: FND_MESSAGE.SET_TOKEN('ACTION',l_request_rec.request_type);
4436: OE_MSG_PUB.Add;
4437: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4438:
4439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4440: END IF;
4441:

Line 4439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4435: FND_MESSAGE.SET_TOKEN('ACTION',l_request_rec.request_type);
4436: OE_MSG_PUB.Add;
4437: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4438:
4439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4440: END IF;
4441:
4442: IF l_debug_level > 0 THEN
4443: oe_debug_pub.add('After Price Order, Status : ' || l_return_status, 5);

Line 4448: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4444: END IF;
4445:
4446: l_request_rec.processed := 'Y';
4447:
4448: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4450: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR THEN
4451: RAISE FND_API.G_EXC_ERROR;
4452: END IF;

Line 4449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4445:
4446: l_request_rec.processed := 'Y';
4447:
4448: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4450: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR THEN
4451: RAISE FND_API.G_EXC_ERROR;
4452: END IF;
4453:

Line 4450: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR THEN

4446: l_request_rec.processed := 'Y';
4447:
4448: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4450: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR THEN
4451: RAISE FND_API.G_EXC_ERROR;
4452: END IF;
4453:
4454: -- End of ER 7243028

Line 4451: RAISE FND_API.G_EXC_ERROR;

4447:
4448: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4450: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR THEN
4451: RAISE FND_API.G_EXC_ERROR;
4452: END IF;
4453:
4454: -- End of ER 7243028
4455:

Line 4543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4539: IF l_debug_level > 0 THEN
4540: oe_debug_pub.add('After call to Authorizat Payment return status : ' || l_return_status);
4541: END IF;
4542:
4543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4544: RAISE FND_API.G_EXC_ERROR;
4545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4547: END IF;

Line 4544: RAISE FND_API.G_EXC_ERROR;

4540: oe_debug_pub.add('After call to Authorizat Payment return status : ' || l_return_status);
4541: END IF;
4542:
4543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4544: RAISE FND_API.G_EXC_ERROR;
4545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4547: END IF;
4548:

Line 4545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4541: END IF;
4542:
4543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4544: RAISE FND_API.G_EXC_ERROR;
4545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4547: END IF;
4548:
4549: l_request_rec.processed := 'Y';

Line 4546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4542:
4543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4544: RAISE FND_API.G_EXC_ERROR;
4545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4547: END IF;
4548:
4549: l_request_rec.processed := 'Y';
4550: -- to ensure verify_payment not getting called again during book_order.

Line 4666: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4662: END IF;
4663: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_REQUEST');
4664: FND_MESSAGE.SET_TOKEN('ACTION',l_request_rec.request_type);
4665: OE_MSG_PUB.Add;
4666: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4667: END IF;
4668:
4669: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR
4670: THEN

Line 4669: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR

4665: OE_MSG_PUB.Add;
4666: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4667: END IF;
4668:
4669: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR
4670: THEN
4671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4672: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR
4673: THEN

Line 4671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4667: END IF;
4668:
4669: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR
4670: THEN
4671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4672: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR
4673: THEN
4674: RAISE FND_API.G_EXC_ERROR;
4675: END IF;

Line 4672: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR

4668:
4669: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR
4670: THEN
4671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4672: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR
4673: THEN
4674: RAISE FND_API.G_EXC_ERROR;
4675: END IF;
4676:

Line 4674: RAISE FND_API.G_EXC_ERROR;

4670: THEN
4671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4672: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR
4673: THEN
4674: RAISE FND_API.G_EXC_ERROR;
4675: END IF;
4676:
4677: IF ( l_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT OR
4678: l_request_rec.request_type = OE_GLOBALS.G_REJECT_FULFILLMENT) AND

Line 4690: WHEN FND_API.G_EXC_ERROR THEN

4686: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4687:
4688: EXCEPTION
4689:
4690: WHEN FND_API.G_EXC_ERROR THEN
4691: l_request_rec.return_status := FND_API.G_RET_STS_ERROR;
4692: l_request_rec.processed := 'Y';
4693: p_x_request_tbl(i):= l_request_rec;
4694: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);

Line 4691: l_request_rec.return_status := FND_API.G_RET_STS_ERROR;

4687:
4688: EXCEPTION
4689:
4690: WHEN FND_API.G_EXC_ERROR THEN
4691: l_request_rec.return_status := FND_API.G_RET_STS_ERROR;
4692: l_request_rec.processed := 'Y';
4693: p_x_request_tbl(i):= l_request_rec;
4694: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4695:

Line 4696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4692: l_request_rec.processed := 'Y';
4693: p_x_request_tbl(i):= l_request_rec;
4694: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4695:
4696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4697: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4698: l_request_rec.processed := 'Y';
4699: p_x_request_tbl(i):= l_request_rec;
4700: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);

Line 4697: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4693: p_x_request_tbl(i):= l_request_rec;
4694: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4695:
4696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4697: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4698: l_request_rec.processed := 'Y';
4699: p_x_request_tbl(i):= l_request_rec;
4700: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4697: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4698: l_request_rec.processed := 'Y';
4699: p_x_request_tbl(i):= l_request_rec;
4700: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4702:
4703:
4704: WHEN OTHERS THEN
4705: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4705: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4702:
4703:
4704: WHEN OTHERS THEN
4705: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4706: l_request_rec.processed := 'Y';
4707: p_x_request_tbl(i) := l_request_rec;
4708:
4709: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4714: );
4715: END IF;
4716:
4717: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4719:
4720: END;
4721: <> -- Label for requests that do not need to be processed
4722: null;

Line 4737: WHEN FND_API.G_EXC_ERROR THEN

4733: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4734:
4735: EXCEPTION
4736:
4737: WHEN FND_API.G_EXC_ERROR THEN
4738: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4739: RAISE;
4740:
4741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4737: WHEN FND_API.G_EXC_ERROR THEN
4738: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4739: RAISE;
4740:
4741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4742: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4743: RAISE;
4744:
4745: WHEN OTHERS THEN

Line 4756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4752: );
4753: END IF;
4754:
4755: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4757:
4758: END Process_Order_Actions;
4759:
4760: -- delete_against defaulting to TRUE to prevent delete

Line 4787: x_return_status := FND_API.G_RET_STS_SUCCESS;

4783: BEGIN
4784:
4785:
4786:
4787: x_return_status := FND_API.G_RET_STS_SUCCESS;
4788: IF l_debug_level > 0 THEN
4789: oe_debug_pub.add('In Delete_Reqs_for_Deleted_Entity');
4790: oe_debug_pub.add('p_entity_code/p_entity_id' ||
4791: p_entity_code || '/' || p_entity_id);

Line 4917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4913: IF l_debug_level > 0 THEN
4914: oe_debug_pub.add('reset versioning globals');
4915: END IF;
4916: IF (NOT OE_Versioning_Util.Reset_Globals) THEN
4917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4918: END IF;
4919: END IF;
4920: G_Delayed_Requests.Delete(req_ind);
4921: END IF;

Line 4932: WHEN FND_API.G_EXC_ERROR THEN

4928: END IF;
4929:
4930: EXCEPTION
4931:
4932: WHEN FND_API.G_EXC_ERROR THEN
4933:
4934: x_return_status := FND_API.G_RET_STS_ERROR;
4935:
4936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4934: x_return_status := FND_API.G_RET_STS_ERROR;

4930: EXCEPTION
4931:
4932: WHEN FND_API.G_EXC_ERROR THEN
4933:
4934: x_return_status := FND_API.G_RET_STS_ERROR;
4935:
4936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4937:
4938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4932: WHEN FND_API.G_EXC_ERROR THEN
4933:
4934: x_return_status := FND_API.G_RET_STS_ERROR;
4935:
4936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4937:
4938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4939:
4940: when others THEN

Line 4938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4934: x_return_status := FND_API.G_RET_STS_ERROR;
4935:
4936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4937:
4938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4939:
4940: when others THEN
4941:
4942: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 4948: x_return_status := FND_API.G_RET_STS_ERROR;

4944: (G_PKG_NAME
4945: ,'Delete_Reqs_for_Deleted_Entity');
4946: END IF;
4947:
4948: x_return_status := FND_API.G_RET_STS_ERROR;
4949:
4950: End Delete_Reqs_for_Deleted_Entity;
4951:
4952:

Line 4976: x_return_status := FND_API.G_RET_STS_SUCCESS;

4972: IF l_debug_level > 0 THEN
4973: oe_debug_pub.add('sch request '|| p_request_rec.request_type, 1);
4974: END IF;
4975:
4976: x_return_status := FND_API.G_RET_STS_SUCCESS;
4977:
4978: IF p_request_rec.request_type = OE_GLOBALS.G_SCHEDULE_ATO THEN
4979: IF l_debug_level > 0 THEN
4980: oe_debug_pub.add('.. schedule_ato '|| p_request_rec.entity_id, 1);

Line 5147: IF l_request_search_rslt1 = FND_API.G_TRUE THEN

5143: p_request_rec.request_unique_key5,
5144: l_request_ind,
5145: l_request_search_rslt1,
5146: l_return_status);
5147: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
5148: -- no need to log request with BATCH and Y if
5149: -- 'BATCH,BOOK' and N already exists.
5150: x_log_request := 'N';
5151: return;

Line 5180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5176: l_return_status);
5177:
5178: END IF;
5179:
5180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5183: RAISE FND_API.G_EXC_ERROR;
5184: END IF;

Line 5181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5177:
5178: END IF;
5179:
5180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5183: RAISE FND_API.G_EXC_ERROR;
5184: END IF;
5185:

Line 5182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5178: END IF;
5179:
5180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5183: RAISE FND_API.G_EXC_ERROR;
5184: END IF;
5185:
5186: IF l_request_search_rslt1 = FND_API.G_TRUE THEN

Line 5183: RAISE FND_API.G_EXC_ERROR;

5179:
5180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5183: RAISE FND_API.G_EXC_ERROR;
5184: END IF;
5185:
5186: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
5187: -- no need to log request with BATCH and Y if BATCH

Line 5186: IF l_request_search_rslt1 = FND_API.G_TRUE THEN

5182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5183: RAISE FND_API.G_EXC_ERROR;
5184: END IF;
5185:
5186: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
5187: -- no need to log request with BATCH and Y if BATCH
5188: -- and N already exists.
5189: IF l_debug_level > 0 THEN
5190: oe_debug_pub.add('there already exists BATCH + N so no need to log pricing request.', 3);

Line 5225: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5221:
5222: END IF;
5223:
5224:
5225: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5227: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5228: RAISE FND_API.G_EXC_ERROR;
5229: END IF;

Line 5226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5222: END IF;
5223:
5224:
5225: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5227: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5228: RAISE FND_API.G_EXC_ERROR;
5229: END IF;
5230:

Line 5227: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5223:
5224:
5225: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5227: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5228: RAISE FND_API.G_EXC_ERROR;
5229: END IF;
5230:
5231: IF l_request_search_rslt2 = FND_API.G_TRUE THEN

Line 5228: RAISE FND_API.G_EXC_ERROR;

5224:
5225: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5227: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5228: RAISE FND_API.G_EXC_ERROR;
5229: END IF;
5230:
5231: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
5232: -- check if there already exists request with

Line 5231: IF l_request_search_rslt2 = FND_API.G_TRUE THEN

5227: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5228: RAISE FND_API.G_EXC_ERROR;
5229: END IF;
5230:
5231: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
5232: -- check if there already exists request with
5233: -- pricing event 'LINE' with get_freight_flag = 'Y'.
5234: -- If exists, do nothing.
5235: IF l_debug_level > 0 THEN

Line 5249: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5245: p_request_rec.request_unique_key5,
5246: l_request_ind,
5247: l_request_search_rslt3,
5248: l_return_status);
5249: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5251: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5252: RAISE FND_API.G_EXC_ERROR;
5253: END IF;

Line 5250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5246: l_request_ind,
5247: l_request_search_rslt3,
5248: l_return_status);
5249: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5251: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5252: RAISE FND_API.G_EXC_ERROR;
5253: END IF;
5254:

Line 5251: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5247: l_request_search_rslt3,
5248: l_return_status);
5249: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5251: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5252: RAISE FND_API.G_EXC_ERROR;
5253: END IF;
5254:
5255: IF l_request_search_rslt3 = FND_API.G_TRUE THEN

Line 5252: RAISE FND_API.G_EXC_ERROR;

5248: l_return_status);
5249: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5251: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5252: RAISE FND_API.G_EXC_ERROR;
5253: END IF;
5254:
5255: IF l_request_search_rslt3 = FND_API.G_TRUE THEN
5256: -- If not exists, replace BATCH event with LINE event

Line 5255: IF l_request_search_rslt3 = FND_API.G_TRUE THEN

5251: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5252: RAISE FND_API.G_EXC_ERROR;
5253: END IF;
5254:
5255: IF l_request_search_rslt3 = FND_API.G_TRUE THEN
5256: -- If not exists, replace BATCH event with LINE event
5257: -- since request with 'ORDER' event already exists.
5258: IF l_debug_level > 0 THEN
5259: oe_debug_pub.add('there exists LINE + Y and ORDER + N so no need to log request for BATCH + Y.', 3);

Line 5263: -- if l_request_search_rslt3 = FND_API.G_FALSE THEN

5259: oe_debug_pub.add('there exists LINE + Y and ORDER + N so no need to log request for BATCH + Y.', 3);
5260: END IF;
5261: x_log_request := 'N';
5262: ELSE
5263: -- if l_request_search_rslt3 = FND_API.G_FALSE THEN
5264: -- check for LINE and N.
5265: Check_For_Request(p_request_rec.entity_code,
5266: p_request_rec.entity_id,
5267: p_request_rec.request_type,

Line 5276: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5272: p_request_rec.request_unique_key5,
5273: l_request_ind,
5274: l_request_search_rslt4,
5275: l_return_status);
5276: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5278: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5279: RAISE FND_API.G_EXC_ERROR;
5280: END IF;

Line 5277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5273: l_request_ind,
5274: l_request_search_rslt4,
5275: l_return_status);
5276: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5278: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5279: RAISE FND_API.G_EXC_ERROR;
5280: END IF;
5281:

Line 5278: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5274: l_request_search_rslt4,
5275: l_return_status);
5276: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5278: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5279: RAISE FND_API.G_EXC_ERROR;
5280: END IF;
5281:
5282:

Line 5279: RAISE FND_API.G_EXC_ERROR;

5275: l_return_status);
5276: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5278: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5279: RAISE FND_API.G_EXC_ERROR;
5280: END IF;
5281:
5282:
5283: IF l_request_search_rslt4 = FND_API.G_TRUE THEN

Line 5283: IF l_request_search_rslt4 = FND_API.G_TRUE THEN

5279: RAISE FND_API.G_EXC_ERROR;
5280: END IF;
5281:
5282:
5283: IF l_request_search_rslt4 = FND_API.G_TRUE THEN
5284: -- if already exists request with LINE and N.
5285: IF l_debug_level > 0 THEN
5286: oe_debug_pub.add('there exists LINE + N and ORDER + N so no need to log request for BATCH + Y.', 3);
5287: END IF;

Line 5320: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5316: l_request_ind,
5317: l_request_search_rslt1,
5318: l_return_status);
5319:
5320: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5322: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5323: RAISE FND_API.G_EXC_ERROR;
5324: END IF;

Line 5321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5317: l_request_search_rslt1,
5318: l_return_status);
5319:
5320: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5322: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5323: RAISE FND_API.G_EXC_ERROR;
5324: END IF;
5325:

Line 5322: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5318: l_return_status);
5319:
5320: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5322: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5323: RAISE FND_API.G_EXC_ERROR;
5324: END IF;
5325:
5326: IF l_request_search_rslt1 = FND_API.G_TRUE THEN

Line 5323: RAISE FND_API.G_EXC_ERROR;

5319:
5320: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5322: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5323: RAISE FND_API.G_EXC_ERROR;
5324: END IF;
5325:
5326: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
5327: -- if l_request_search_rslt1 = FND_API.G_TRUE

Line 5326: IF l_request_search_rslt1 = FND_API.G_TRUE THEN

5322: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5323: RAISE FND_API.G_EXC_ERROR;
5324: END IF;
5325:
5326: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
5327: -- if l_request_search_rslt1 = FND_API.G_TRUE
5328: -- request with event 'BATCH' and get_freight_flag ='N'
5329: -- exists, don't need to log request.
5330: IF l_debug_level > 0 THEN

Line 5327: -- if l_request_search_rslt1 = FND_API.G_TRUE

5323: RAISE FND_API.G_EXC_ERROR;
5324: END IF;
5325:
5326: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
5327: -- if l_request_search_rslt1 = FND_API.G_TRUE
5328: -- request with event 'BATCH' and get_freight_flag ='N'
5329: -- exists, don't need to log request.
5330: IF l_debug_level > 0 THEN
5331: oe_debug_pub.add('there exists BATCH + N so no need to log request.', 3);

Line 5335: -- if l_request_search_rslt1 = FND_API.G_FALSE

5331: oe_debug_pub.add('there exists BATCH + N so no need to log request.', 3);
5332: END IF;
5333: x_log_request := 'N';
5334: ELSE
5335: -- if l_request_search_rslt1 = FND_API.G_FALSE
5336: -- request with event 'BATCH' and get_freight_flag ='N'
5337: -- does not exist.
5338: Check_For_Request(p_request_rec.entity_code,
5339: p_request_rec.entity_id,

Line 5349: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5345: p_request_rec.request_unique_key5,
5346: l_request_ind,
5347: l_request_search_rslt2,
5348: l_return_status);
5349: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5351: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5352: RAISE FND_API.G_EXC_ERROR;
5353: END IF;

Line 5350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5346: l_request_ind,
5347: l_request_search_rslt2,
5348: l_return_status);
5349: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5351: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5352: RAISE FND_API.G_EXC_ERROR;
5353: END IF;
5354:

Line 5351: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5347: l_request_search_rslt2,
5348: l_return_status);
5349: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5351: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5352: RAISE FND_API.G_EXC_ERROR;
5353: END IF;
5354:
5355: IF l_request_search_rslt2 = FND_API.G_TRUE THEN

Line 5352: RAISE FND_API.G_EXC_ERROR;

5348: l_return_status);
5349: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5351: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5352: RAISE FND_API.G_EXC_ERROR;
5353: END IF;
5354:
5355: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
5356:

Line 5355: IF l_request_search_rslt2 = FND_API.G_TRUE THEN

5351: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5352: RAISE FND_API.G_EXC_ERROR;
5353: END IF;
5354:
5355: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
5356:
5357: -- there exists request with BATCH+Y already.
5358: -- need to delete BATCH+Y, log the current request which is
5359: -- ORDER+N and log an additional request LINE+Y.

Line 5431: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5427: l_request_ind,
5428: l_request_search_rslt1,
5429: l_return_status);
5430:
5431: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5433: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5434: RAISE FND_API.G_EXC_ERROR;
5435: END IF;

Line 5432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5428: l_request_search_rslt1,
5429: l_return_status);
5430:
5431: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5433: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5434: RAISE FND_API.G_EXC_ERROR;
5435: END IF;
5436:

Line 5433: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5429: l_return_status);
5430:
5431: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5433: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5434: RAISE FND_API.G_EXC_ERROR;
5435: END IF;
5436:
5437: IF l_request_search_rslt1 = FND_API.G_TRUE THEN

Line 5434: RAISE FND_API.G_EXC_ERROR;

5430:
5431: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5433: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5434: RAISE FND_API.G_EXC_ERROR;
5435: END IF;
5436:
5437: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
5438: -- request with event 'BATCH' and get_freight_flag ='N'

Line 5437: IF l_request_search_rslt1 = FND_API.G_TRUE THEN

5433: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5434: RAISE FND_API.G_EXC_ERROR;
5435: END IF;
5436:
5437: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
5438: -- request with event 'BATCH' and get_freight_flag ='N'
5439: -- already exists, no need to log request.
5440: IF l_debug_level > 0 THEN
5441: oe_debug_pub.add('there exists BATCH + N so no need to log request.', 3);

Line 5445: -- l_request_search_rslt1 = FND_API.G_FALSE

5441: oe_debug_pub.add('there exists BATCH + N so no need to log request.', 3);
5442: END IF;
5443: x_log_request := 'N';
5444: ELSE
5445: -- l_request_search_rslt1 = FND_API.G_FALSE
5446: -- request with event 'BATCH' and get_freight_flag ='N'
5447: -- does not exist.
5448: Check_For_Request(p_request_rec.entity_code,
5449: p_request_rec.entity_id,

Line 5459: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5455: p_request_rec.request_unique_key5,
5456: l_request_ind,
5457: l_request_search_rslt2,
5458: l_return_status);
5459: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5461: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5462: RAISE FND_API.G_EXC_ERROR;
5463: END IF;

Line 5460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5456: l_request_ind,
5457: l_request_search_rslt2,
5458: l_return_status);
5459: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5461: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5462: RAISE FND_API.G_EXC_ERROR;
5463: END IF;
5464:

Line 5461: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5457: l_request_search_rslt2,
5458: l_return_status);
5459: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5461: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5462: RAISE FND_API.G_EXC_ERROR;
5463: END IF;
5464:
5465: IF l_request_search_rslt2 = FND_API.G_TRUE THEN

Line 5462: RAISE FND_API.G_EXC_ERROR;

5458: l_return_status);
5459: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5461: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5462: RAISE FND_API.G_EXC_ERROR;
5463: END IF;
5464:
5465: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
5466:

Line 5465: IF l_request_search_rslt2 = FND_API.G_TRUE THEN

5461: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5462: RAISE FND_API.G_EXC_ERROR;
5463: END IF;
5464:
5465: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
5466:
5467: -- there exists request with BATCH,BOOK+Y already.
5468: -- need to delete BATCH,BOOK+Y, log the current request which is
5469: -- ORDER,BOOK+N and log an additional request LINE+Y.

Line 5514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5510: p_request_rec.request_unique_key5,
5511: l_request_ind,
5512: l_request_search_rslt1,
5513: l_return_status);
5514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5517: RAISE FND_API.G_EXC_ERROR;
5518: END IF;

Line 5515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5511: l_request_ind,
5512: l_request_search_rslt1,
5513: l_return_status);
5514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5517: RAISE FND_API.G_EXC_ERROR;
5518: END IF;
5519:

Line 5516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5512: l_request_search_rslt1,
5513: l_return_status);
5514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5517: RAISE FND_API.G_EXC_ERROR;
5518: END IF;
5519:
5520: IF l_request_search_rslt1 = FND_API.G_TRUE THEN

Line 5517: RAISE FND_API.G_EXC_ERROR;

5513: l_return_status);
5514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5517: RAISE FND_API.G_EXC_ERROR;
5518: END IF;
5519:
5520: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
5521: IF l_debug_level > 0 THEN

Line 5520: IF l_request_search_rslt1 = FND_API.G_TRUE THEN

5516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5517: RAISE FND_API.G_EXC_ERROR;
5518: END IF;
5519:
5520: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
5521: IF l_debug_level > 0 THEN
5522: oe_debug_pub.add('there exists BATCH + N so no need to log request.', 3);
5523: END IF;
5524: x_log_request := 'N';

Line 5540: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5536: p_request_rec.request_unique_key5,
5537: l_request_ind,
5538: l_request_search_rslt2,
5539: l_return_status);
5540: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5542: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5543: RAISE FND_API.G_EXC_ERROR;
5544: END IF;

Line 5541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5537: l_request_ind,
5538: l_request_search_rslt2,
5539: l_return_status);
5540: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5542: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5543: RAISE FND_API.G_EXC_ERROR;
5544: END IF;
5545: IF l_request_search_rslt2 = FND_API.G_TRUE THEN

Line 5542: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5538: l_request_search_rslt2,
5539: l_return_status);
5540: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5542: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5543: RAISE FND_API.G_EXC_ERROR;
5544: END IF;
5545: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
5546: IF l_debug_level > 0 THEN

Line 5543: RAISE FND_API.G_EXC_ERROR;

5539: l_return_status);
5540: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5542: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5543: RAISE FND_API.G_EXC_ERROR;
5544: END IF;
5545: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
5546: IF l_debug_level > 0 THEN
5547: oe_debug_pub.add('there exists BATCH,BOOK + N so no need to log request.', 3);

Line 5545: IF l_request_search_rslt2 = FND_API.G_TRUE THEN

5541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5542: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5543: RAISE FND_API.G_EXC_ERROR;
5544: END IF;
5545: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
5546: IF l_debug_level > 0 THEN
5547: oe_debug_pub.add('there exists BATCH,BOOK + N so no need to log request.', 3);
5548: END IF;
5549: x_log_request := 'N';