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 13: return the result in p_request_search_result which is set to FND_API.G_TRUE

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

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

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

Line 65: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 66: x_result := FND_API.G_FALSE;

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

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

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

Line 108: NVL(p_request_unique_key1, FND_API.G_MISS_CHAR)

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

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

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

Line 111: NVL(p_request_unique_key2, FND_API.G_MISS_CHAR)

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

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

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

Line 114: NVL(p_request_unique_key3, FND_API.G_MISS_CHAR)

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

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

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

Line 117: NVL(p_request_unique_key4, FND_API.G_MISS_CHAR)

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

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

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

Line 120: NVL(p_request_unique_key5, FND_API.G_MISS_CHAR)

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

Line 124: x_result := FND_API.G_TRUE;

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

Line 135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 161: ,p_delete IN Varchar2 default FND_API.G_FALSE

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

Line 219: x_return_status := FND_API.G_RET_STS_SUCCESS;

215: IF l_debug_level > 0 THEN
216: oe_debug_pub.add('Entering Procedure Process_Request_Pvt ',1);
217: oe_debug_pub.add('Request processed '||G_Delayed_Requests(p_request_ind).processed);
218: END IF;
219: x_return_status := FND_API.G_RET_STS_SUCCESS;
220:
221:
222: -- if request has already been processed ('Y') or if the request is
223: -- being processed ('I'): this would occur if request resulted in

Line 619: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

615:
616: ELSIF l_request_type = OE_GLOBALS.G_DROPSHIP_CMS THEN
617: RETURN;
618:
619: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
621: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
622: RAISE FND_API.G_EXC_ERROR;
623: END IF;

Line 620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

616: ELSIF l_request_type = OE_GLOBALS.G_DROPSHIP_CMS THEN
617: RETURN;
618:
619: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
621: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
622: RAISE FND_API.G_EXC_ERROR;
623: END IF;
624: ELSIF l_request_type = OE_GLOBALS.G_UPDATE_OPTION THEN

Line 621: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

617: RETURN;
618:
619: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
621: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
622: RAISE FND_API.G_EXC_ERROR;
623: END IF;
624: ELSIF l_request_type = OE_GLOBALS.G_UPDATE_OPTION THEN
625: IF l_debug_level > 0 THEN

Line 622: RAISE FND_API.G_EXC_ERROR;

618:
619: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
621: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
622: RAISE FND_API.G_EXC_ERROR;
623: END IF;
624: ELSIF l_request_type = OE_GLOBALS.G_UPDATE_OPTION THEN
625: IF l_debug_level > 0 THEN
626: oe_debug_pub.add('upd: processed with cfg val', 3);

Line 689: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

685: IF l_debug_level > 0 THEN
686: oe_debug_pub.add('ret sts: '|| x_return_status, 4);
687: END IF;
688:
689: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
690: oe_debug_pub.add('deleteing after success ', 3);
691: K := G_Delayed_Requests.FIRST;
692:
693: WHILE K is not null

Line 826: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

822: , p_split_tbl => l_cto_split_tbl
823: , p_decimal_tbl => l_cto_decimal_tbl
824: , x_return_status => l_return_status);
825:
826: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
827: IF l_debug_level > 0 THEN
828: oe_debug_pub.add('deleteing after success ', 3);
829: END IF;
830: K := G_Delayed_Requests.FIRST;

Line 871: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

867: OE_GROUP_SCH_UTIL.Group_Schedule_sets
868: ( p_sch_set_tbl => l_sch_set_tbl
869: , x_return_status => l_return_status);
870:
871: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
872:
873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
874:
875: END IF;

Line 873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

869: , x_return_status => l_return_status);
870:
871: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
872:
873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
874:
875: END IF;
876:
877: K := G_Delayed_Requests.FIRST;

Line 924: IF l_return_status <> FND_API.G_RET_STS_UNEXP_ERROR

920:
921: IF G_Delayed_Requests(K).request_type =
922: OE_GLOBALS.G_SPLIT_SCHEDULE
923: THEN
924: IF l_return_status <> FND_API.G_RET_STS_UNEXP_ERROR
925: THEN
926: g_delayed_requests(K).processed := 'Y';
927: ELSE
928: g_delayed_requests(K).processed := Null;

Line 1411: IF l_return_status <> FND_API.G_RET_STS_UNEXP_ERROR

1407: OE_GLOBALS.G_RESCHEDULE_LINE) AND
1408: G_Delayed_Requests(K).param1 = l_set
1409: THEN
1410: l_index := l_index + 1;
1411: IF l_return_status <> FND_API.G_RET_STS_UNEXP_ERROR
1412: THEN
1413: g_delayed_requests(K).processed := 'Y';
1414: ELSE
1415: g_delayed_requests(K).processed := Null;

Line 1660: p_delayed_request=> FND_API.G_TRUE,

1656: OE_PREPAYMENT_PVT.Process_Payments(
1657: p_header_id => l_request_rec.entity_id,
1658: p_calling_action => 'UPDATE',
1659: p_amount => null,
1660: p_delayed_request=> FND_API.G_TRUE,
1661: x_msg_data => l_msg_data,
1662: x_msg_count => l_msg_count,
1663: x_return_status => l_return_status);
1664: --bug3507871 end

Line 1679: p_delayed_request=> FND_API.G_TRUE,

1675: OE_PREPAYMENT_PVT.Process_Payments(
1676: p_header_id => l_request_rec.entity_id,
1677: p_calling_action => null,
1678: p_amount => null,
1679: p_delayed_request=> FND_API.G_TRUE,
1680: p_process_prepayment=>'N',
1681: p_process_authorization=>'N',
1682: x_msg_data => l_msg_data,
1683: x_msg_count => l_msg_count,

Line 1695: p_delayed_request=> FND_API.G_TRUE,

1691: p_header_id => l_request_rec.entity_id,
1692: p_line_id => l_request_rec.param1,
1693: p_calling_action => null,
1694: p_amount => null,
1695: p_delayed_request=> FND_API.G_TRUE,
1696: p_process_prepayment=>'N',
1697: p_process_authorization=>'N',
1698: x_msg_data => l_msg_data,
1699: x_msg_count => l_msg_count,

Line 1781: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1777: ELSE
1778: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_REQUEST');
1779: FND_MESSAGE.SET_TOKEN('ACTION',l_request_type);
1780: OE_MSG_PUB.Add;
1781: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1782:
1783: END IF;
1784:
1785: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1785: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1781: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1782:
1783: END IF;
1784:
1785: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1787: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1788: RAISE FND_API.G_EXC_ERROR;
1789: END IF;

Line 1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1782:
1783: END IF;
1784:
1785: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1787: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1788: RAISE FND_API.G_EXC_ERROR;
1789: END IF;
1790:

Line 1787: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1783: END IF;
1784:
1785: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1787: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1788: RAISE FND_API.G_EXC_ERROR;
1789: END IF;
1790:
1791: IF (p_delete = FND_API.G_TRUE) then

Line 1788: RAISE FND_API.G_EXC_ERROR;

1784:
1785: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1787: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1788: RAISE FND_API.G_EXC_ERROR;
1789: END IF;
1790:
1791: IF (p_delete = FND_API.G_TRUE) then
1792:

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

1787: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1788: RAISE FND_API.G_EXC_ERROR;
1789: END IF;
1790:
1791: IF (p_delete = FND_API.G_TRUE) then
1792:
1793: G_Delayed_Requests.Delete(p_request_ind);
1794:
1795: /*

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

1818: G_Delayed_Requests(p_request_ind).processed := 'Y';
1819:
1820: END IF;
1821:
1822: /* IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1824: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1825: RAISE FND_API.G_EXC_ERROR;
1826: END IF;*/

Line 1823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1819:
1820: END IF;
1821:
1822: /* IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1824: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1825: RAISE FND_API.G_EXC_ERROR;
1826: END IF;*/
1827: /* The request is not removed if return_status is error Rajeev*/

Line 1824: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1820: END IF;
1821:
1822: /* IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1824: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1825: RAISE FND_API.G_EXC_ERROR;
1826: END IF;*/
1827: /* The request is not removed if return_status is error Rajeev*/
1828: --IF (p_delete = FND_API.G_TRUE) then

Line 1825: RAISE FND_API.G_EXC_ERROR;

1821:
1822: /* IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1824: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1825: RAISE FND_API.G_EXC_ERROR;
1826: END IF;*/
1827: /* The request is not removed if return_status is error Rajeev*/
1828: --IF (p_delete = FND_API.G_TRUE) then
1829: -- G_Delayed_Requests.Delete(p_request_ind);

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

1824: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1825: RAISE FND_API.G_EXC_ERROR;
1826: END IF;*/
1827: /* The request is not removed if return_status is error Rajeev*/
1828: --IF (p_delete = FND_API.G_TRUE) then
1829: -- G_Delayed_Requests.Delete(p_request_ind);
1830: --ELSE
1831: -- G_Delayed_Requests(p_request_ind).processed := 'Y';
1832: --END IF;

Line 1838: WHEN FND_API.G_EXC_ERROR THEN

1834: oe_debug_pub.add('leaving Process_Request_Pvt', 1);
1835: END IF;
1836: EXCEPTION
1837:
1838: WHEN FND_API.G_EXC_ERROR THEN
1839: oe_debug_pub.add('exe error Process_Request_Pvt', 1);
1840: G_Delayed_Requests(p_request_ind).processed := 'N';
1841: oe_debug_pub.add
1842: ('1 type----- '|| G_Delayed_Requests(p_request_ind).request_type, 1);

Line 1845: x_return_status := FND_API.G_RET_STS_ERROR;

1841: oe_debug_pub.add
1842: ('1 type----- '|| G_Delayed_Requests(p_request_ind).request_type, 1);
1843: oe_debug_pub.add
1844: ('1 ind----- '|| p_request_ind, 1);
1845: x_return_status := FND_API.G_RET_STS_ERROR;
1846:
1847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1848: oe_debug_pub.add('unexp error Process_Request_Pvt', 1);
1849: oe_debug_pub.add('SQL ERROR MESSAGE:'||SQLERRM);

Line 1847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1843: oe_debug_pub.add
1844: ('1 ind----- '|| p_request_ind, 1);
1845: x_return_status := FND_API.G_RET_STS_ERROR;
1846:
1847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1848: oe_debug_pub.add('unexp error Process_Request_Pvt', 1);
1849: oe_debug_pub.add('SQL ERROR MESSAGE:'||SQLERRM);
1850: G_Delayed_Requests(p_request_ind).processed := 'N';
1851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1848: oe_debug_pub.add('unexp error Process_Request_Pvt', 1);
1849: oe_debug_pub.add('SQL ERROR MESSAGE:'||SQLERRM);
1850: G_Delayed_Requests(p_request_ind).processed := 'N';
1851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1852:
1853: WHEN NO_DATA_FOUND THEN
1854: oe_debug_pub.add('Exiting Process_Request_Pvt no_data_found exception ');
1855: G_Delayed_Requests(p_request_ind).processed := 'N';

Line 1856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1852:
1853: WHEN NO_DATA_FOUND THEN
1854: oe_debug_pub.add('Exiting Process_Request_Pvt no_data_found exception ');
1855: G_Delayed_Requests(p_request_ind).processed := 'N';
1856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1857:
1858:
1859: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1860: THEN

Line 1870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1866:
1867: WHEN OTHERS THEN
1868: G_Delayed_Requests(p_request_ind).processed := 'N';
1869: oe_debug_pub.add('SQL ERROR MESSAGE FOR WHEN OTHRES:'||SQLERRM);
1870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1871:
1872: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1873: THEN
1874: OE_MSG_PUB.Add_Exc_Msg

Line 1996: x_return_status := FND_API.G_RET_STS_SUCCESS;

1992: l_request.date_param8 := p_date_param8;
1993: l_request.long_param1 := p_long_param1;
1994:
1995: -- Initialize the return variable
1996: x_return_status := FND_API.G_RET_STS_SUCCESS;
1997:
1998: Check_For_Request(p_entity_code,
1999: p_entity_id,
2000: p_request_type,

Line 2010: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2006: l_request_ind,
2007: l_request_search_rslt,
2008: l_return_status);
2009:
2010: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2012: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2013: RAISE FND_API.G_EXC_ERROR;
2014: END IF;

Line 2011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2007: l_request_search_rslt,
2008: l_return_status);
2009:
2010: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2012: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2013: RAISE FND_API.G_EXC_ERROR;
2014: END IF;
2015:

Line 2012: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2008: l_return_status);
2009:
2010: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2012: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2013: RAISE FND_API.G_EXC_ERROR;
2014: END IF;
2015:
2016: l_request.processed := 'N';

Line 2013: RAISE FND_API.G_EXC_ERROR;

2009:
2010: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2012: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2013: RAISE FND_API.G_EXC_ERROR;
2014: END IF;
2015:
2016: l_request.processed := 'N';
2017:

Line 2031: AND l_request_search_rslt = FND_API.g_false THEN

2027: OR l_request.request_unique_key1 = 'ORDER,BOOK'
2028: AND nvl(l_request.request_unique_key2,'N') = 'N'
2029: OR l_request.request_unique_key1 = 'BATCH,BOOK'
2030: AND nvl(l_request.request_unique_key2,'N') = 'N')
2031: AND l_request_search_rslt = FND_API.g_false THEN
2032:
2033: IF l_debug_level > 0 THEN
2034: oe_debug_pub.add('In log_request, calling check_pricing_request.',3);
2035: oe_debug_pub.add('request_unique_key1 is: '||l_request.request_unique_key1,3);

Line 2067: AND l_request_search_rslt = FND_API.g_false THEN

2063: AND nvl(l_request.request_unique_key2,'N') = 'N'
2064: OR nvl(l_request.request_unique_key1,l_request.param2) = 'BATCH,BOOK'
2065: AND nvl(l_request.request_unique_key2,'N') = 'N')
2066: OR nvl(l_request.request_unique_key1, l_request.param2) = 'LINE'
2067: AND l_request_search_rslt = FND_API.g_false THEN
2068: Check_Pricing_Request
2069: ( p_request_ind => l_request_ind
2070: ,p_request_rec => l_request
2071: ,x_log_request => l_log_request);

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

2077: END IF;
2078:
2079: /* End of the code added to fix the fp bug 3498435 */
2080:
2081: IF l_request_search_rslt = FND_API.g_true -- replace the request
2082: THEN
2083: IF l_debug_level > 0 THEN
2084: OE_Debug_PUB.ADD('Request replaced');
2085: END IF;

Line 2323: if l_return_status = fnd_api.g_ret_sts_error then

2319: OE_Blkt_Release_Util.Cache_Order_Qty_Amt
2320: (p_request_rec => l_request
2321: ,x_return_status => l_return_status
2322: ) ;
2323: if l_return_status = fnd_api.g_ret_sts_error then
2324: raise fnd_api.g_exc_error;
2325: elsif l_return_status = fnd_api.g_ret_sts_error then
2326: raise fnd_api.g_exc_unexpected_error;
2327: end if;

Line 2324: raise fnd_api.g_exc_error;

2320: (p_request_rec => l_request
2321: ,x_return_status => l_return_status
2322: ) ;
2323: if l_return_status = fnd_api.g_ret_sts_error then
2324: raise fnd_api.g_exc_error;
2325: elsif l_return_status = fnd_api.g_ret_sts_error then
2326: raise fnd_api.g_exc_unexpected_error;
2327: end if;
2328: END IF;

Line 2325: elsif l_return_status = fnd_api.g_ret_sts_error then

2321: ,x_return_status => l_return_status
2322: ) ;
2323: if l_return_status = fnd_api.g_ret_sts_error then
2324: raise fnd_api.g_exc_error;
2325: elsif l_return_status = fnd_api.g_ret_sts_error then
2326: raise fnd_api.g_exc_unexpected_error;
2327: end if;
2328: END IF;
2329:

Line 2326: raise fnd_api.g_exc_unexpected_error;

2322: ) ;
2323: if l_return_status = fnd_api.g_ret_sts_error then
2324: raise fnd_api.g_exc_error;
2325: elsif l_return_status = fnd_api.g_ret_sts_error then
2326: raise fnd_api.g_exc_unexpected_error;
2327: end if;
2328: END IF;
2329:
2330: g_delayed_requests(l_request_ind) := l_request;

Line 2348: WHEN FND_API.G_EXC_ERROR THEN

2344: oe_debug_pub.add('!!!!!!! index '|| l_request_ind, 5);
2345: END IF;
2346: EXCEPTION
2347:
2348: WHEN FND_API.G_EXC_ERROR THEN
2349:
2350: x_return_status := FND_API.G_RET_STS_ERROR;
2351:
2352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2350: x_return_status := FND_API.G_RET_STS_ERROR;

2346: EXCEPTION
2347:
2348: WHEN FND_API.G_EXC_ERROR THEN
2349:
2350: x_return_status := FND_API.G_RET_STS_ERROR;
2351:
2352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2353:
2354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2348: WHEN FND_API.G_EXC_ERROR THEN
2349:
2350: x_return_status := FND_API.G_RET_STS_ERROR;
2351:
2352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2353:
2354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2356:

Line 2354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2350: x_return_status := FND_API.G_RET_STS_ERROR;
2351:
2352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2353:
2354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2356:
2357: WHEN OTHERS THEN
2358: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2351:
2352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2353:
2354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2356:
2357: WHEN OTHERS THEN
2358: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2359: THEN

Line 2365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2361: (G_PKG_NAME
2362: ,'LOGREQUEST');
2363: END IF;
2364:
2365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2367:
2368: End Log_Request;
2369:

Line 2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2362: ,'LOGREQUEST');
2363: END IF;
2364:
2365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2367:
2368: End Log_Request;
2369:
2370: Function Check_for_Request( p_entity_code IN VARCHAR2,

Line 2396: if x_result = FND_API.G_TRUE then

2392: ,x_request_ind => l_ind
2393: ,x_result => x_result
2394: ,x_return_status => x_return_status);
2395:
2396: if x_result = FND_API.G_TRUE then
2397: return(TRUE);
2398: else
2399: return(FALSE);
2400: end if;

Line 2426: x_return_status := FND_API.G_RET_STS_SUCCESS;

2422: BEGIN
2423: IF l_debug_level > 0 THEN
2424: oe_debug_pub.add('Entering Procedure Delete_Request in Package OE_Delayed_Requests_Pvt');
2425: END IF;
2426: x_return_status := FND_API.G_RET_STS_SUCCESS;
2427:
2428: Check_for_Request( p_entity_code => p_entity_code
2429: ,p_entity_id => p_entity_id
2430: ,p_request_type => p_request_type

Line 2441: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2437: ,x_result => l_request_search_rslt
2438: ,x_return_status => l_return_status);
2439:
2440:
2441: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2443: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2444: RAISE FND_API.G_EXC_ERROR;
2445: END IF;

Line 2442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2438: ,x_return_status => l_return_status);
2439:
2440:
2441: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2443: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2444: RAISE FND_API.G_EXC_ERROR;
2445: END IF;
2446:

Line 2443: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2439:
2440:
2441: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2443: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2444: RAISE FND_API.G_EXC_ERROR;
2445: END IF;
2446:
2447: if l_request_search_rslt = FND_API.G_TRUE -- delete the request

Line 2444: RAISE FND_API.G_EXC_ERROR;

2440:
2441: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2443: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2444: RAISE FND_API.G_EXC_ERROR;
2445: END IF;
2446:
2447: if l_request_search_rslt = FND_API.G_TRUE -- delete the request
2448: then

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

2443: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2444: RAISE FND_API.G_EXC_ERROR;
2445: END IF;
2446:
2447: if l_request_search_rslt = FND_API.G_TRUE -- delete the request
2448: then
2449: G_Delayed_Requests.Delete(l_request_ind);
2450: /*
2451: BUG 1794544 - do not delete from req entities table

Line 2471: WHEN FND_API.G_EXC_ERROR THEN

2467: end if;
2468:
2469: EXCEPTION
2470:
2471: WHEN FND_API.G_EXC_ERROR THEN
2472:
2473: x_return_status := FND_API.G_RET_STS_ERROR;
2474:
2475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2473: x_return_status := FND_API.G_RET_STS_ERROR;

2469: EXCEPTION
2470:
2471: WHEN FND_API.G_EXC_ERROR THEN
2472:
2473: x_return_status := FND_API.G_RET_STS_ERROR;
2474:
2475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2476:
2477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2471: WHEN FND_API.G_EXC_ERROR THEN
2472:
2473: x_return_status := FND_API.G_RET_STS_ERROR;
2474:
2475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2476:
2477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2478:
2479: when others THEN

Line 2477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2473: x_return_status := FND_API.G_RET_STS_ERROR;
2474:
2475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2476:
2477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2478:
2479: when others THEN
2480:
2481: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2487: x_return_status := FND_API.G_RET_STS_ERROR;

2483: (G_PKG_NAME
2484: ,'DeleteRequest');
2485: END IF;
2486:
2487: x_return_status := FND_API.G_RET_STS_ERROR;
2488:
2489: End Delete_Request;
2490:
2491: Procedure Clear_Request( x_return_status OUT NOCOPY VARCHAR2)

Line 2502: x_return_status := FND_API.G_RET_STS_SUCCESS;

2498: IF l_debug_level > 0 THEN
2499: oe_debug_pub.add('Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt');
2500: END IF;
2501:
2502: x_return_status := FND_API.G_RET_STS_SUCCESS;
2503:
2504: G_Delayed_Requests.DELETE;
2505: g_requesting_entities.DELETE;
2506:

Line 2531: x_return_status := FND_API.G_RET_STS_ERROR;

2527: (G_PKG_NAME
2528: ,'Clear_Request');
2529: END IF;
2530:
2531: x_return_status := FND_API.G_RET_STS_ERROR;
2532:
2533: End Clear_Request;
2534:
2535: Procedure Process_Request( p_entity_code IN VARCHAR2

Line 2544: FND_API.G_TRUE

2540: ,p_request_unique_key3 IN VARCHAR2 := NULL
2541: ,p_request_unique_key4 IN VARCHAR2 := NULL
2542: ,p_request_unique_key5 IN VARCHAR2 := NULL
2543: ,p_delete IN Varchar2 Default
2544: FND_API.G_TRUE
2545: ,x_return_status OUT NOCOPY Varchar2)
2546:
2547: IS
2548: l_request_ind Number;

Line 2555: x_return_status := FND_API.G_RET_STS_SUCCESS;

2551: --
2552: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2553: --
2554: Begin
2555: x_return_status := FND_API.G_RET_STS_SUCCESS;
2556: IF l_debug_level > 0 THEN
2557: oe_debug_pub.add('Entering Procedure Process_Request in Package OE_Delayed_Requests_Pvt');
2558: END IF;
2559: Check_for_Request( p_entity_code => p_entity_code

Line 2571: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2567: ,x_request_ind => l_request_ind
2568: ,x_result => l_request_search_rslt
2569: ,x_return_status => l_return_status);
2570:
2571: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2573: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2574: RAISE FND_API.G_EXC_ERROR;
2575: END IF;

Line 2572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2568: ,x_result => l_request_search_rslt
2569: ,x_return_status => l_return_status);
2570:
2571: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2573: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2574: RAISE FND_API.G_EXC_ERROR;
2575: END IF;
2576:

Line 2573: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2569: ,x_return_status => l_return_status);
2570:
2571: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2573: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2574: RAISE FND_API.G_EXC_ERROR;
2575: END IF;
2576:
2577: if l_request_search_rslt = FND_API.G_TRUE then

Line 2574: RAISE FND_API.G_EXC_ERROR;

2570:
2571: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2573: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2574: RAISE FND_API.G_EXC_ERROR;
2575: END IF;
2576:
2577: if l_request_search_rslt = FND_API.G_TRUE then
2578: Process_Request_Pvt

Line 2577: if l_request_search_rslt = FND_API.G_TRUE then

2573: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2574: RAISE FND_API.G_EXC_ERROR;
2575: END IF;
2576:
2577: if l_request_search_rslt = FND_API.G_TRUE then
2578: Process_Request_Pvt
2579: (p_request_ind => l_request_ind
2580: ,p_delete => p_delete
2581: ,x_return_status => l_return_status

Line 2585: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2581: ,x_return_status => l_return_status
2582: );
2583: end if;
2584:
2585: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2587: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2588: RAISE FND_API.G_EXC_ERROR;
2589: END IF;

Line 2586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2582: );
2583: end if;
2584:
2585: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2587: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2588: RAISE FND_API.G_EXC_ERROR;
2589: END IF;
2590:

Line 2587: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2583: end if;
2584:
2585: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2587: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2588: RAISE FND_API.G_EXC_ERROR;
2589: END IF;
2590:
2591: EXCEPTION

Line 2588: RAISE FND_API.G_EXC_ERROR;

2584:
2585: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2587: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2588: RAISE FND_API.G_EXC_ERROR;
2589: END IF;
2590:
2591: EXCEPTION
2592:

Line 2593: WHEN FND_API.G_EXC_ERROR THEN

2589: END IF;
2590:
2591: EXCEPTION
2592:
2593: WHEN FND_API.G_EXC_ERROR THEN
2594:
2595: x_return_status := FND_API.G_RET_STS_ERROR;
2596:
2597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2595: x_return_status := FND_API.G_RET_STS_ERROR;

2591: EXCEPTION
2592:
2593: WHEN FND_API.G_EXC_ERROR THEN
2594:
2595: x_return_status := FND_API.G_RET_STS_ERROR;
2596:
2597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2598:
2599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2593: WHEN FND_API.G_EXC_ERROR THEN
2594:
2595: x_return_status := FND_API.G_RET_STS_ERROR;
2596:
2597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2598:
2599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2600:
2601: WHEN OTHERS THEN

Line 2599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2595: x_return_status := FND_API.G_RET_STS_ERROR;
2596:
2597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2598:
2599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2600:
2601: WHEN OTHERS THEN
2602:
2603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2600:
2601: WHEN OTHERS THEN
2602:
2603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2604:
2605: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2606: THEN
2607: OE_MSG_PUB.Add_Exc_Msg

Line 2617: ,p_delete in Varchar2 Default FND_API.G_TRUE

2613: End Process_Request;
2614:
2615: Procedure Process_Request_for_Entity
2616: ( p_entity_code in Varchar2
2617: ,p_delete in Varchar2 Default FND_API.G_TRUE
2618: ,x_return_status OUT NOCOPY Varchar2) IS
2619:
2620: l_return_status Varchar2(30);
2621: l_ind Number;

Line 2629: x_return_status := FND_API.G_RET_STS_SUCCESS;

2625: Begin
2626: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
2627: p_In_out => 1);
2628:
2629: x_return_status := FND_API.G_RET_STS_SUCCESS;
2630: IF l_debug_level > 0 THEN
2631: oe_debug_pub.add('Enter OE_Delayed_Requests_Pvt.Process_Request_for_Entity',1);
2632: END IF;
2633: IF oe_globals.g_recursion_mode = 'N' THEN

Line 2646: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2642: ,p_delete => p_delete
2643: ,x_return_status => l_return_status
2644: );
2645:
2646: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2648: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2649: IF l_debug_level > 0 THEN
2650: oe_debug_pub.add

Line 2647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2643: ,x_return_status => l_return_status
2644: );
2645:
2646: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2648: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2649: IF l_debug_level > 0 THEN
2650: oe_debug_pub.add
2651: ('2 type----- '|| G_Delayed_Requests(l_ind).request_type, 1);

Line 2648: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2644: );
2645:
2646: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2648: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2649: IF l_debug_level > 0 THEN
2650: oe_debug_pub.add
2651: ('2 type----- '|| G_Delayed_Requests(l_ind).request_type, 1);
2652: oe_debug_pub.add

Line 2655: RAISE FND_API.G_EXC_ERROR;

2651: ('2 type----- '|| G_Delayed_Requests(l_ind).request_type, 1);
2652: oe_debug_pub.add
2653: ('2 ind----- '|| l_ind, 1);
2654: END IF;
2655: RAISE FND_API.G_EXC_ERROR;
2656: END IF;
2657: END IF;
2658: l_ind := G_Delayed_Requests.Next(l_ind);
2659: END LOOP;

Line 2670: WHEN FND_API.G_EXC_ERROR THEN

2666: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
2667: p_In_out => 0);
2668: EXCEPTION
2669:
2670: WHEN FND_API.G_EXC_ERROR THEN
2671: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
2672: p_In_out => 0);
2673: x_return_status := FND_API.G_RET_STS_ERROR;
2674:

Line 2673: x_return_status := FND_API.G_RET_STS_ERROR;

2669:
2670: WHEN FND_API.G_EXC_ERROR THEN
2671: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
2672: p_In_out => 0);
2673: x_return_status := FND_API.G_RET_STS_ERROR;
2674:
2675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2676: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
2677: p_In_out => 0);

Line 2675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2671: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
2672: p_In_out => 0);
2673: x_return_status := FND_API.G_RET_STS_ERROR;
2674:
2675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2676: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
2677: p_In_out => 0);
2678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2679:

Line 2678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2674:
2675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2676: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
2677: p_In_out => 0);
2678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2679:
2680: WHEN OTHERS THEN
2681: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
2682: p_In_out => 0);

Line 2683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2679:
2680: WHEN OTHERS THEN
2681: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
2682: p_In_out => 0);
2683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2684:
2685: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2686: THEN
2687: OE_MSG_PUB.Add_Exc_Msg

Line 2701: ,p_delete in Varchar2 Default FND_API.G_TRUE

2697:
2698:
2699: Procedure Process_Request_for_ReqType
2700: ( p_request_type in Varchar2
2701: ,p_delete in Varchar2 Default FND_API.G_TRUE
2702: ,x_return_status OUT NOCOPY Varchar2
2703:
2704: ) IS
2705: l_return_status Varchar2(30);

Line 2715: x_return_status := FND_API.G_RET_STS_SUCCESS;

2711: --
2712: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2713: --
2714: BEGIN
2715: x_return_status := FND_API.G_RET_STS_SUCCESS;
2716: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
2717: p_In_out => 1);
2718: IF l_debug_level > 0 THEN
2719: oe_debug_pub.add('Entering Procedure Process_Request_for_ReqType in Package OE_Delayed_Requests_Pvt');

Line 2737: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2733: ,p_delete => p_delete
2734: ,x_return_status => l_return_status
2735: );
2736:
2737: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2739: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2740: RAISE FND_API.G_EXC_ERROR;
2741: END IF;

Line 2738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2734: ,x_return_status => l_return_status
2735: );
2736:
2737: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2739: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2740: RAISE FND_API.G_EXC_ERROR;
2741: END IF;
2742: END IF;

Line 2739: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2735: );
2736:
2737: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2739: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2740: RAISE FND_API.G_EXC_ERROR;
2741: END IF;
2742: END IF;
2743: END IF;

Line 2740: RAISE FND_API.G_EXC_ERROR;

2736:
2737: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2739: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2740: RAISE FND_API.G_EXC_ERROR;
2741: END IF;
2742: END IF;
2743: END IF;
2744: l_ind := G_Delayed_Requests.Next(l_ind);

Line 2752: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2748: (p_Entity_id_tbl => l_entity_id_tbl
2749: ,x_return_status => l_return_status
2750: );
2751:
2752: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2754: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2755: RAISE FND_API.G_EXC_ERROR;
2756: END IF;

Line 2753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2749: ,x_return_status => l_return_status
2750: );
2751:
2752: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2754: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2755: RAISE FND_API.G_EXC_ERROR;
2756: END IF;
2757: l_count := l_entity_id_tbl.FIRST;

Line 2754: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2750: );
2751:
2752: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2754: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2755: RAISE FND_API.G_EXC_ERROR;
2756: END IF;
2757: l_count := l_entity_id_tbl.FIRST;
2758: WHILE l_count IS NOT NULL LOOP -- Fixing 1888284

Line 2755: RAISE FND_API.G_EXC_ERROR;

2751:
2752: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2754: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2755: RAISE FND_API.G_EXC_ERROR;
2756: END IF;
2757: l_count := l_entity_id_tbl.FIRST;
2758: WHILE l_count IS NOT NULL LOOP -- Fixing 1888284
2759: G_Delayed_Requests.DELETE(l_entity_id_tbl(l_count).request_ind);

Line 2788: WHEN FND_API.G_EXC_ERROR THEN

2784: oe_debug_pub.add('leaving process_requenst_for_reqtype', 1);
2785: END IF;
2786: EXCEPTION
2787:
2788: WHEN FND_API.G_EXC_ERROR THEN
2789: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
2790: p_In_out => 0);
2791: oe_debug_pub.add('execution error', 1);
2792: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2792: x_return_status := FND_API.G_RET_STS_ERROR;

2788: WHEN FND_API.G_EXC_ERROR THEN
2789: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
2790: p_In_out => 0);
2791: oe_debug_pub.add('execution error', 1);
2792: x_return_status := FND_API.G_RET_STS_ERROR;
2793:
2794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2795: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
2796: p_In_out => 0);

Line 2794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2790: p_In_out => 0);
2791: oe_debug_pub.add('execution error', 1);
2792: x_return_status := FND_API.G_RET_STS_ERROR;
2793:
2794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2795: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
2796: p_In_out => 0);
2797: oe_debug_pub.add('unexp error', 1);
2798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2795: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
2796: p_In_out => 0);
2797: oe_debug_pub.add('unexp error', 1);
2798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2799:
2800: WHEN OTHERS THEN
2801: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
2802: p_In_out => 0);

Line 2804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2800: WHEN OTHERS THEN
2801: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
2802: p_In_out => 0);
2803: oe_debug_pub.add('others error', 1);
2804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2805:
2806: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2807: THEN
2808: OE_MSG_PUB.Add_Exc_Msg

Line 2839: ,p_delete => FND_API.G_TRUE

2835: IF oe_globals.g_recursion_mode = 'N' THEN
2836:
2837: Process_Request_for_ReqType
2838: (p_request_type => OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
2839: ,p_delete => FND_API.G_TRUE
2840: ,x_return_status => l_return_status
2841: );
2842: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2842: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2838: (p_request_type => OE_GLOBALS.G_DFLT_HSCREDIT_FOR_SREP
2839: ,p_delete => FND_API.G_TRUE
2840: ,x_return_status => l_return_status
2841: );
2842: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2844: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2845: RAISE FND_API.G_EXC_ERROR;
2846: END IF;

Line 2843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2839: ,p_delete => FND_API.G_TRUE
2840: ,x_return_status => l_return_status
2841: );
2842: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2844: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2845: RAISE FND_API.G_EXC_ERROR;
2846: END IF;
2847:

Line 2844: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2840: ,x_return_status => l_return_status
2841: );
2842: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2844: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2845: RAISE FND_API.G_EXC_ERROR;
2846: END IF;
2847:
2848: -- Process Header Sales Credits Delayed Requests

Line 2845: RAISE FND_API.G_EXC_ERROR;

2841: );
2842: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2844: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2845: RAISE FND_API.G_EXC_ERROR;
2846: END IF;
2847:
2848: -- Process Header Sales Credits Delayed Requests
2849: Process_Request_for_ReqType

Line 2851: ,p_delete => FND_API.G_TRUE

2847:
2848: -- Process Header Sales Credits Delayed Requests
2849: Process_Request_for_ReqType
2850: (p_request_type => OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
2851: ,p_delete => FND_API.G_TRUE
2852: ,x_return_status => l_return_status
2853: );
2854: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2854: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2850: (p_request_type => OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
2851: ,p_delete => FND_API.G_TRUE
2852: ,x_return_status => l_return_status
2853: );
2854: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2856: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2857: RAISE FND_API.G_EXC_ERROR;
2858: END IF;

Line 2855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2851: ,p_delete => FND_API.G_TRUE
2852: ,x_return_status => l_return_status
2853: );
2854: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2856: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2857: RAISE FND_API.G_EXC_ERROR;
2858: END IF;
2859:

Line 2856: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2852: ,x_return_status => l_return_status
2853: );
2854: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2856: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2857: RAISE FND_API.G_EXC_ERROR;
2858: END IF;
2859:
2860: -- Process Lines Sales Credits Delayed Requests

Line 2857: RAISE FND_API.G_EXC_ERROR;

2853: );
2854: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2856: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2857: RAISE FND_API.G_EXC_ERROR;
2858: END IF;
2859:
2860: -- Process Lines Sales Credits Delayed Requests
2861: Process_Request_for_ReqType

Line 2863: ,p_delete => FND_API.G_TRUE

2859:
2860: -- Process Lines Sales Credits Delayed Requests
2861: Process_Request_for_ReqType
2862: (p_request_type => OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL
2863: ,p_delete => FND_API.G_TRUE
2864: ,x_return_status => l_return_status
2865: );
2866: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2866: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2862: (p_request_type => OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL
2863: ,p_delete => FND_API.G_TRUE
2864: ,x_return_status => l_return_status
2865: );
2866: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2868: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2869: RAISE FND_API.G_EXC_ERROR;
2870: END IF;

Line 2867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2863: ,p_delete => FND_API.G_TRUE
2864: ,x_return_status => l_return_status
2865: );
2866: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2868: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2869: RAISE FND_API.G_EXC_ERROR;
2870: END IF;
2871:

Line 2868: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2864: ,x_return_status => l_return_status
2865: );
2866: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2868: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2869: RAISE FND_API.G_EXC_ERROR;
2870: END IF;
2871:
2872: -- Process CREATE_SETS Requests

Line 2869: RAISE FND_API.G_EXC_ERROR;

2865: );
2866: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2868: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2869: RAISE FND_API.G_EXC_ERROR;
2870: END IF;
2871:
2872: -- Process CREATE_SETS Requests
2873: Process_Request_for_ReqType

Line 2875: ,p_delete => FND_API.G_TRUE

2871:
2872: -- Process CREATE_SETS Requests
2873: Process_Request_for_ReqType
2874: (p_request_type => OE_GLOBALS.G_CREATE_SETS
2875: ,p_delete => FND_API.G_TRUE
2876: ,x_return_status => l_return_status
2877: );
2878: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2878: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2874: (p_request_type => OE_GLOBALS.G_CREATE_SETS
2875: ,p_delete => FND_API.G_TRUE
2876: ,x_return_status => l_return_status
2877: );
2878: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2880: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;

Line 2879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2875: ,p_delete => FND_API.G_TRUE
2876: ,x_return_status => l_return_status
2877: );
2878: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2880: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;
2883:

Line 2880: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2876: ,x_return_status => l_return_status
2877: );
2878: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2880: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;
2883:
2884:

Line 2881: RAISE FND_API.G_EXC_ERROR;

2877: );
2878: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2880: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;
2883:
2884:
2885:

Line 2889: ,p_delete => FND_API.G_TRUE

2885:
2886: -- Process CREATE_CONFIG_ITEM Requests
2887: Process_Request_for_ReqType
2888: (p_request_type => OE_GLOBALS.G_CREATE_CONFIG_ITEM
2889: ,p_delete => FND_API.G_TRUE
2890: ,x_return_status => l_return_status
2891: );
2892: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2892: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2888: (p_request_type => OE_GLOBALS.G_CREATE_CONFIG_ITEM
2889: ,p_delete => FND_API.G_TRUE
2890: ,x_return_status => l_return_status
2891: );
2892: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2894: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2895: RAISE FND_API.G_EXC_ERROR;
2896: END IF;

Line 2893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2889: ,p_delete => FND_API.G_TRUE
2890: ,x_return_status => l_return_status
2891: );
2892: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2894: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2895: RAISE FND_API.G_EXC_ERROR;
2896: END IF;
2897:

Line 2894: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2890: ,x_return_status => l_return_status
2891: );
2892: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2894: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2895: RAISE FND_API.G_EXC_ERROR;
2896: END IF;
2897:
2898: -- Process INSERT_INTO_SETS Requests

Line 2895: RAISE FND_API.G_EXC_ERROR;

2891: );
2892: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2894: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2895: RAISE FND_API.G_EXC_ERROR;
2896: END IF;
2897:
2898: -- Process INSERT_INTO_SETS Requests
2899: Process_Request_for_ReqType

Line 2901: ,p_delete => FND_API.G_TRUE

2897:
2898: -- Process INSERT_INTO_SETS Requests
2899: Process_Request_for_ReqType
2900: (p_request_type => OE_GLOBALS.G_INSERT_INTO_SETS
2901: ,p_delete => FND_API.G_TRUE
2902: ,x_return_status => l_return_status
2903: );
2904: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2904: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2900: (p_request_type => OE_GLOBALS.G_INSERT_INTO_SETS
2901: ,p_delete => FND_API.G_TRUE
2902: ,x_return_status => l_return_status
2903: );
2904: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2906: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2907: RAISE FND_API.G_EXC_ERROR;
2908: END IF;

Line 2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2901: ,p_delete => FND_API.G_TRUE
2902: ,x_return_status => l_return_status
2903: );
2904: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2906: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2907: RAISE FND_API.G_EXC_ERROR;
2908: END IF;
2909:

Line 2906: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2902: ,x_return_status => l_return_status
2903: );
2904: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2906: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2907: RAISE FND_API.G_EXC_ERROR;
2908: END IF;
2909:
2910: -- Process INS_INCLUDED_ITEM Requests

Line 2907: RAISE FND_API.G_EXC_ERROR;

2903: );
2904: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2906: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2907: RAISE FND_API.G_EXC_ERROR;
2908: END IF;
2909:
2910: -- Process INS_INCLUDED_ITEM Requests
2911: Process_Request_for_ReqType

Line 2913: ,p_delete => FND_API.G_TRUE

2909:
2910: -- Process INS_INCLUDED_ITEM Requests
2911: Process_Request_for_ReqType
2912: (p_request_type => OE_GLOBALS.G_INS_INCLUDED_ITEMS
2913: ,p_delete => FND_API.G_TRUE
2914: ,x_return_status => l_return_status
2915: );
2916: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2916: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2912: (p_request_type => OE_GLOBALS.G_INS_INCLUDED_ITEMS
2913: ,p_delete => FND_API.G_TRUE
2914: ,x_return_status => l_return_status
2915: );
2916: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2919: RAISE FND_API.G_EXC_ERROR;
2920: END IF;

Line 2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2913: ,p_delete => FND_API.G_TRUE
2914: ,x_return_status => l_return_status
2915: );
2916: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2919: RAISE FND_API.G_EXC_ERROR;
2920: END IF;
2921:

Line 2918: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2914: ,x_return_status => l_return_status
2915: );
2916: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2919: RAISE FND_API.G_EXC_ERROR;
2920: END IF;
2921:
2922:

Line 2919: RAISE FND_API.G_EXC_ERROR;

2915: );
2916: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2919: RAISE FND_API.G_EXC_ERROR;
2920: END IF;
2921:
2922:
2923:

Line 2927: ,p_delete => FND_API.G_TRUE

2923:
2924: -- Process requests for RMA
2925: Process_Request_for_ReqType
2926: (p_request_type => OE_GLOBALS.G_INSERT_RMA
2927: ,p_delete => FND_API.G_TRUE
2928: ,x_return_status => l_return_status
2929: );
2930: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2930: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2926: (p_request_type => OE_GLOBALS.G_INSERT_RMA
2927: ,p_delete => FND_API.G_TRUE
2928: ,x_return_status => l_return_status
2929: );
2930: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2932: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2933: RAISE FND_API.G_EXC_ERROR;
2934: END IF;

Line 2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2927: ,p_delete => FND_API.G_TRUE
2928: ,x_return_status => l_return_status
2929: );
2930: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2932: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2933: RAISE FND_API.G_EXC_ERROR;
2934: END IF;
2935:

Line 2932: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2928: ,x_return_status => l_return_status
2929: );
2930: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2932: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2933: RAISE FND_API.G_EXC_ERROR;
2934: END IF;
2935:
2936: -- Process requests for Split_hold

Line 2933: RAISE FND_API.G_EXC_ERROR;

2929: );
2930: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2932: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2933: RAISE FND_API.G_EXC_ERROR;
2934: END IF;
2935:
2936: -- Process requests for Split_hold
2937: Process_Request_for_ReqType

Line 2939: ,p_delete => FND_API.G_TRUE

2935:
2936: -- Process requests for Split_hold
2937: Process_Request_for_ReqType
2938: (p_request_type => OE_GLOBALS.G_SPLIT_HOLD
2939: ,p_delete => FND_API.G_TRUE
2940: ,x_return_status => l_return_status
2941: );
2942: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2942: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2938: (p_request_type => OE_GLOBALS.G_SPLIT_HOLD
2939: ,p_delete => FND_API.G_TRUE
2940: ,x_return_status => l_return_status
2941: );
2942: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2944: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2945: RAISE FND_API.G_EXC_ERROR;
2946: END IF;

Line 2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2939: ,p_delete => FND_API.G_TRUE
2940: ,x_return_status => l_return_status
2941: );
2942: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2944: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2945: RAISE FND_API.G_EXC_ERROR;
2946: END IF;
2947:

Line 2944: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2940: ,x_return_status => l_return_status
2941: );
2942: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2944: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2945: RAISE FND_API.G_EXC_ERROR;
2946: END IF;
2947:
2948: -- Process requests for Delayed Requests

Line 2945: RAISE FND_API.G_EXC_ERROR;

2941: );
2942: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2944: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2945: RAISE FND_API.G_EXC_ERROR;
2946: END IF;
2947:
2948: -- Process requests for Delayed Requests
2949: Process_Request_for_ReqType

Line 2951: ,p_delete => FND_API.G_TRUE

2947:
2948: -- Process requests for Delayed Requests
2949: Process_Request_for_ReqType
2950: (p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE
2951: ,p_delete => FND_API.G_TRUE
2952: ,x_return_status => l_return_status
2953: );
2954: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2954: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2950: (p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE
2951: ,p_delete => FND_API.G_TRUE
2952: ,x_return_status => l_return_status
2953: );
2954: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2956: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2957: RAISE FND_API.G_EXC_ERROR;
2958: END IF;

Line 2955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2951: ,p_delete => FND_API.G_TRUE
2952: ,x_return_status => l_return_status
2953: );
2954: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2956: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2957: RAISE FND_API.G_EXC_ERROR;
2958: END IF;
2959:

Line 2956: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2952: ,x_return_status => l_return_status
2953: );
2954: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2956: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2957: RAISE FND_API.G_EXC_ERROR;
2958: END IF;
2959:
2960: -- Process requests for Quantity Cascade

Line 2957: RAISE FND_API.G_EXC_ERROR;

2953: );
2954: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2956: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2957: RAISE FND_API.G_EXC_ERROR;
2958: END IF;
2959:
2960: -- Process requests for Quantity Cascade
2961: Process_Request_for_ReqType

Line 2963: ,p_delete => FND_API.G_TRUE

2959:
2960: -- Process requests for Quantity Cascade
2961: Process_Request_for_ReqType
2962: (p_request_type => OE_GLOBALS.G_CASCADE_QUANTITY
2963: ,p_delete => FND_API.G_TRUE
2964: ,x_return_status => l_return_status
2965: );
2966: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2966: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2962: (p_request_type => OE_GLOBALS.G_CASCADE_QUANTITY
2963: ,p_delete => FND_API.G_TRUE
2964: ,x_return_status => l_return_status
2965: );
2966: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2968: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2969: RAISE FND_API.G_EXC_ERROR;
2970: END IF;

Line 2967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2963: ,p_delete => FND_API.G_TRUE
2964: ,x_return_status => l_return_status
2965: );
2966: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2968: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2969: RAISE FND_API.G_EXC_ERROR;
2970: END IF;
2971:

Line 2968: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2964: ,x_return_status => l_return_status
2965: );
2966: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2968: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2969: RAISE FND_API.G_EXC_ERROR;
2970: END IF;
2971:
2972: /*** we do not need this, confirm with ashwin

Line 2969: RAISE FND_API.G_EXC_ERROR;

2965: );
2966: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2968: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2969: RAISE FND_API.G_EXC_ERROR;
2970: END IF;
2971:
2972: /*** we do not need this, confirm with ashwin
2973: -- Process requests for project Cascade

Line 2976: ,p_delete => FND_API.G_TRUE

2972: /*** we do not need this, confirm with ashwin
2973: -- Process requests for project Cascade
2974: Process_Request_for_ReqType
2975: (p_request_type => OE_GLOBALS.G_CASCADE_PROJECT
2976: ,p_delete => FND_API.G_TRUE
2977: ,x_return_status => l_return_status
2978: );
2979: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2979: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2975: (p_request_type => OE_GLOBALS.G_CASCADE_PROJECT
2976: ,p_delete => FND_API.G_TRUE
2977: ,x_return_status => l_return_status
2978: );
2979: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2981: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2982: RAISE FND_API.G_EXC_ERROR;
2983: END IF;

Line 2980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2976: ,p_delete => FND_API.G_TRUE
2977: ,x_return_status => l_return_status
2978: );
2979: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2981: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2982: RAISE FND_API.G_EXC_ERROR;
2983: END IF;
2984:

Line 2981: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2977: ,x_return_status => l_return_status
2978: );
2979: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2981: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2982: RAISE FND_API.G_EXC_ERROR;
2983: END IF;
2984:
2985: -- Process requests for task Cascade

Line 2982: RAISE FND_API.G_EXC_ERROR;

2978: );
2979: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2981: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2982: RAISE FND_API.G_EXC_ERROR;
2983: END IF;
2984:
2985: -- Process requests for task Cascade
2986: Process_Request_for_ReqType

Line 2988: ,p_delete => FND_API.G_TRUE

2984:
2985: -- Process requests for task Cascade
2986: Process_Request_for_ReqType
2987: (p_request_type => OE_GLOBALS.G_CASCADE_TASK
2988: ,p_delete => FND_API.G_TRUE
2989: ,x_return_status => l_return_status
2990: );
2991: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2991: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2987: (p_request_type => OE_GLOBALS.G_CASCADE_TASK
2988: ,p_delete => FND_API.G_TRUE
2989: ,x_return_status => l_return_status
2990: );
2991: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2993: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2994: RAISE FND_API.G_EXC_ERROR;
2995: END IF;

Line 2992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2988: ,p_delete => FND_API.G_TRUE
2989: ,x_return_status => l_return_status
2990: );
2991: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2993: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2994: RAISE FND_API.G_EXC_ERROR;
2995: END IF;
2996:

Line 2993: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2989: ,x_return_status => l_return_status
2990: );
2991: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2993: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2994: RAISE FND_API.G_EXC_ERROR;
2995: END IF;
2996:
2997: -- Process requests for task Cascade

Line 2994: RAISE FND_API.G_EXC_ERROR;

2990: );
2991: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2993: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2994: RAISE FND_API.G_EXC_ERROR;
2995: END IF;
2996:
2997: -- Process requests for task Cascade
2998: ***/

Line 3001: ,p_delete => FND_API.G_TRUE

2997: -- Process requests for task Cascade
2998: ***/
2999: Process_Request_for_ReqType
3000: (p_request_type => OE_GLOBALS.G_CASCADE_CHANGES
3001: ,p_delete => FND_API.G_TRUE
3002: ,x_return_status => l_return_status
3003: );
3004: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3004: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3000: (p_request_type => OE_GLOBALS.G_CASCADE_CHANGES
3001: ,p_delete => FND_API.G_TRUE
3002: ,x_return_status => l_return_status
3003: );
3004: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3006: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3007: RAISE FND_API.G_EXC_ERROR;
3008: END IF;

Line 3005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3001: ,p_delete => FND_API.G_TRUE
3002: ,x_return_status => l_return_status
3003: );
3004: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3006: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3007: RAISE FND_API.G_EXC_ERROR;
3008: END IF;
3009:

Line 3006: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3002: ,x_return_status => l_return_status
3003: );
3004: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3006: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3007: RAISE FND_API.G_EXC_ERROR;
3008: END IF;
3009:
3010: -- Process requests to Split Reservations

Line 3007: RAISE FND_API.G_EXC_ERROR;

3003: );
3004: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3006: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3007: RAISE FND_API.G_EXC_ERROR;
3008: END IF;
3009:
3010: -- Process requests to Split Reservations
3011: Process_Request_for_ReqType

Line 3013: ,p_delete => FND_API.G_TRUE

3009:
3010: -- Process requests to Split Reservations
3011: Process_Request_for_ReqType
3012: (p_request_type => OE_GLOBALS.G_CREATE_RESERVATIONS
3013: ,p_delete => FND_API.G_TRUE
3014: ,x_return_status => l_return_status
3015: );
3016: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3016: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3012: (p_request_type => OE_GLOBALS.G_CREATE_RESERVATIONS
3013: ,p_delete => FND_API.G_TRUE
3014: ,x_return_status => l_return_status
3015: );
3016: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3018: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3019: RAISE FND_API.G_EXC_ERROR;
3020: END IF;

Line 3017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3013: ,p_delete => FND_API.G_TRUE
3014: ,x_return_status => l_return_status
3015: );
3016: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3018: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3019: RAISE FND_API.G_EXC_ERROR;
3020: END IF;
3021:

Line 3018: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3014: ,x_return_status => l_return_status
3015: );
3016: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3018: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3019: RAISE FND_API.G_EXC_ERROR;
3020: END IF;
3021:
3022: -- Process requests to Complete Configuration

Line 3019: RAISE FND_API.G_EXC_ERROR;

3015: );
3016: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3018: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3019: RAISE FND_API.G_EXC_ERROR;
3020: END IF;
3021:
3022: -- Process requests to Complete Configuration
3023: Process_Request_for_ReqType

Line 3025: ,p_delete => FND_API.G_TRUE

3021:
3022: -- Process requests to Complete Configuration
3023: Process_Request_for_ReqType
3024: (p_request_type => OE_GLOBALS.G_COMPLETE_CONFIGURATION
3025: ,p_delete => FND_API.G_TRUE
3026: ,x_return_status => l_return_status
3027: );
3028: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3028: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3024: (p_request_type => OE_GLOBALS.G_COMPLETE_CONFIGURATION
3025: ,p_delete => FND_API.G_TRUE
3026: ,x_return_status => l_return_status
3027: );
3028: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3030: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3031: RAISE FND_API.G_EXC_ERROR;
3032: END IF;

Line 3029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3025: ,p_delete => FND_API.G_TRUE
3026: ,x_return_status => l_return_status
3027: );
3028: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3030: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3031: RAISE FND_API.G_EXC_ERROR;
3032: END IF;
3033:

Line 3030: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3026: ,x_return_status => l_return_status
3027: );
3028: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3030: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3031: RAISE FND_API.G_EXC_ERROR;
3032: END IF;
3033:
3034: -- Process requests for Validate Configuration

Line 3031: RAISE FND_API.G_EXC_ERROR;

3027: );
3028: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3030: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3031: RAISE FND_API.G_EXC_ERROR;
3032: END IF;
3033:
3034: -- Process requests for Validate Configuration
3035: Process_Request_for_ReqType

Line 3037: ,p_delete => FND_API.G_TRUE

3033:
3034: -- Process requests for Validate Configuration
3035: Process_Request_for_ReqType
3036: (p_request_type => OE_GLOBALS.G_VALIDATE_CONFIGURATION
3037: ,p_delete => FND_API.G_TRUE
3038: ,x_return_status => l_return_status
3039: );
3040: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3040: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3036: (p_request_type => OE_GLOBALS.G_VALIDATE_CONFIGURATION
3037: ,p_delete => FND_API.G_TRUE
3038: ,x_return_status => l_return_status
3039: );
3040: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3042: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3043: RAISE FND_API.G_EXC_ERROR;
3044: END IF;

Line 3041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3037: ,p_delete => FND_API.G_TRUE
3038: ,x_return_status => l_return_status
3039: );
3040: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3042: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3043: RAISE FND_API.G_EXC_ERROR;
3044: END IF;
3045:

Line 3042: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3038: ,x_return_status => l_return_status
3039: );
3040: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3042: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3043: RAISE FND_API.G_EXC_ERROR;
3044: END IF;
3045:
3046: -- Process requests for CTO Notification

Line 3043: RAISE FND_API.G_EXC_ERROR;

3039: );
3040: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3042: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3043: RAISE FND_API.G_EXC_ERROR;
3044: END IF;
3045:
3046: -- Process requests for CTO Notification
3047: Process_Request_for_ReqType

Line 3049: ,p_delete => FND_API.G_TRUE

3045:
3046: -- Process requests for CTO Notification
3047: Process_Request_for_ReqType
3048: (p_request_type => OE_GLOBALS.G_CTO_NOTIFICATION
3049: ,p_delete => FND_API.G_TRUE
3050: ,x_return_status => l_return_status
3051: );
3052: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3052: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3048: (p_request_type => OE_GLOBALS.G_CTO_NOTIFICATION
3049: ,p_delete => FND_API.G_TRUE
3050: ,x_return_status => l_return_status
3051: );
3052: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3054: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3055: RAISE FND_API.G_EXC_ERROR;
3056: END IF;

Line 3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3049: ,p_delete => FND_API.G_TRUE
3050: ,x_return_status => l_return_status
3051: );
3052: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3054: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3055: RAISE FND_API.G_EXC_ERROR;
3056: END IF;
3057:

Line 3054: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3050: ,x_return_status => l_return_status
3051: );
3052: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3054: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3055: RAISE FND_API.G_EXC_ERROR;
3056: END IF;
3057:
3058: -- Process requests for Service

Line 3055: RAISE FND_API.G_EXC_ERROR;

3051: );
3052: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3054: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3055: RAISE FND_API.G_EXC_ERROR;
3056: END IF;
3057:
3058: -- Process requests for Service
3059: Process_Request_for_ReqType

Line 3061: ,p_delete => FND_API.G_TRUE

3057:
3058: -- Process requests for Service
3059: Process_Request_for_ReqType
3060: (p_request_type => OE_GLOBALS.G_INSERT_SERVICE
3061: ,p_delete => FND_API.G_TRUE
3062: ,x_return_status => l_return_status
3063: );
3064: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3064: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3060: (p_request_type => OE_GLOBALS.G_INSERT_SERVICE
3061: ,p_delete => FND_API.G_TRUE
3062: ,x_return_status => l_return_status
3063: );
3064: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3066: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3067: RAISE FND_API.G_EXC_ERROR;
3068: END IF;

Line 3065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3061: ,p_delete => FND_API.G_TRUE
3062: ,x_return_status => l_return_status
3063: );
3064: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3066: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3067: RAISE FND_API.G_EXC_ERROR;
3068: END IF;
3069:

Line 3066: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3062: ,x_return_status => l_return_status
3063: );
3064: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3066: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3067: RAISE FND_API.G_EXC_ERROR;
3068: END IF;
3069:
3070: /* Added the below call for bug 5925600 */

Line 3067: RAISE FND_API.G_EXC_ERROR;

3063: );
3064: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3066: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3067: RAISE FND_API.G_EXC_ERROR;
3068: END IF;
3069:
3070: /* Added the below call for bug 5925600 */
3071: Process_Request_for_ReqType

Line 3073: ,p_delete => FND_API.G_TRUE

3069:
3070: /* Added the below call for bug 5925600 */
3071: Process_Request_for_ReqType
3072: (p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE
3073: ,p_delete => FND_API.G_TRUE
3074: ,x_return_status => l_return_status
3075: );
3076: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3076: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3072: (p_request_type => OE_GLOBALS.G_GROUP_SCHEDULE
3073: ,p_delete => FND_API.G_TRUE
3074: ,x_return_status => l_return_status
3075: );
3076: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3078: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3079: RAISE FND_API.G_EXC_ERROR;
3080: END IF;

Line 3077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3073: ,p_delete => FND_API.G_TRUE
3074: ,x_return_status => l_return_status
3075: );
3076: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3078: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3079: RAISE FND_API.G_EXC_ERROR;
3080: END IF;
3081:

Line 3078: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3074: ,x_return_status => l_return_status
3075: );
3076: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3078: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3079: RAISE FND_API.G_EXC_ERROR;
3080: END IF;
3081:
3082: Process_Request_for_ReqType

Line 3079: RAISE FND_API.G_EXC_ERROR;

3075: );
3076: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3078: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3079: RAISE FND_API.G_EXC_ERROR;
3080: END IF;
3081:
3082: Process_Request_for_ReqType
3083: (p_request_type => OE_GLOBALS.G_CASCADE_OPTIONS_SERVICE

Line 3084: ,p_delete => FND_API.G_TRUE

3080: END IF;
3081:
3082: Process_Request_for_ReqType
3083: (p_request_type => OE_GLOBALS.G_CASCADE_OPTIONS_SERVICE
3084: ,p_delete => FND_API.G_TRUE
3085: ,x_return_status => l_return_status
3086: );
3087: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3087: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3083: (p_request_type => OE_GLOBALS.G_CASCADE_OPTIONS_SERVICE
3084: ,p_delete => FND_API.G_TRUE
3085: ,x_return_status => l_return_status
3086: );
3087: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3089: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3090: RAISE FND_API.G_EXC_ERROR;
3091: END IF;

Line 3088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3084: ,p_delete => FND_API.G_TRUE
3085: ,x_return_status => l_return_status
3086: );
3087: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3089: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3090: RAISE FND_API.G_EXC_ERROR;
3091: END IF;
3092: /* End of changes done for bug 5925600 */

Line 3089: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3085: ,x_return_status => l_return_status
3086: );
3087: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3089: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3090: RAISE FND_API.G_EXC_ERROR;
3091: END IF;
3092: /* End of changes done for bug 5925600 */
3093:

Line 3090: RAISE FND_API.G_EXC_ERROR;

3086: );
3087: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3089: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3090: RAISE FND_API.G_EXC_ERROR;
3091: END IF;
3092: /* End of changes done for bug 5925600 */
3093:
3094: -- bug 5717671/5736696, need to execute copy header adj

Line 3097: ,p_delete => FND_API.G_TRUE

3093:
3094: -- bug 5717671/5736696, need to execute copy header adj
3095: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3096: (p_request_type =>OE_GLOBALS.G_COPY_HEADER_ADJUSTMENTS
3097: ,p_delete => FND_API.G_TRUE
3098: ,x_return_status => l_return_status
3099: );
3100: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3100: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3096: (p_request_type =>OE_GLOBALS.G_COPY_HEADER_ADJUSTMENTS
3097: ,p_delete => FND_API.G_TRUE
3098: ,x_return_status => l_return_status
3099: );
3100: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3102: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3103: RAISE FND_API.G_EXC_ERROR;
3104: END IF;

Line 3101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3097: ,p_delete => FND_API.G_TRUE
3098: ,x_return_status => l_return_status
3099: );
3100: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3102: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3103: RAISE FND_API.G_EXC_ERROR;
3104: END IF;
3105:

Line 3102: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3098: ,x_return_status => l_return_status
3099: );
3100: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3102: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3103: RAISE FND_API.G_EXC_ERROR;
3104: END IF;
3105:
3106:

Line 3103: RAISE FND_API.G_EXC_ERROR;

3099: );
3100: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3102: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3103: RAISE FND_API.G_EXC_ERROR;
3104: END IF;
3105:
3106:
3107: -- bug 1834260, moved this block of code from after processing

Line 3111: ,p_delete => FND_API.G_TRUE

3107: -- bug 1834260, moved this block of code from after processing
3108: -- for request type G_PRICE_LINE to before it.
3109: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3110: (p_request_type =>OE_GLOBALS.G_COPY_ADJUSTMENTS
3111: ,p_delete => FND_API.G_TRUE
3112: ,x_return_status => l_return_status
3113: );
3114: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3114: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3110: (p_request_type =>OE_GLOBALS.G_COPY_ADJUSTMENTS
3111: ,p_delete => FND_API.G_TRUE
3112: ,x_return_status => l_return_status
3113: );
3114: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3116: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3117: RAISE FND_API.G_EXC_ERROR;
3118: END IF;

Line 3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3111: ,p_delete => FND_API.G_TRUE
3112: ,x_return_status => l_return_status
3113: );
3114: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3116: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3117: RAISE FND_API.G_EXC_ERROR;
3118: END IF;
3119:

Line 3116: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3112: ,x_return_status => l_return_status
3113: );
3114: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3116: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3117: RAISE FND_API.G_EXC_ERROR;
3118: END IF;
3119:
3120: -- Process Requests for Freight Rating.

Line 3117: RAISE FND_API.G_EXC_ERROR;

3113: );
3114: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3116: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3117: RAISE FND_API.G_EXC_ERROR;
3118: END IF;
3119:
3120: -- Process Requests for Freight Rating.
3121: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 3123: ,p_delete => FND_API.G_TRUE

3119:
3120: -- Process Requests for Freight Rating.
3121: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3122: (p_request_type =>OE_GLOBALS.G_FREIGHT_RATING
3123: ,p_delete => FND_API.G_TRUE
3124: ,x_return_status => l_return_status
3125: );
3126: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3126: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3122: (p_request_type =>OE_GLOBALS.G_FREIGHT_RATING
3123: ,p_delete => FND_API.G_TRUE
3124: ,x_return_status => l_return_status
3125: );
3126: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3128: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3129: RAISE FND_API.G_EXC_ERROR;
3130: END IF;

Line 3127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3123: ,p_delete => FND_API.G_TRUE
3124: ,x_return_status => l_return_status
3125: );
3126: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3128: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3129: RAISE FND_API.G_EXC_ERROR;
3130: END IF;
3131:

Line 3128: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3124: ,x_return_status => l_return_status
3125: );
3126: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3128: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3129: RAISE FND_API.G_EXC_ERROR;
3130: END IF;
3131:
3132: /* Added for Bug # 1559906 */

Line 3129: RAISE FND_API.G_EXC_ERROR;

3125: );
3126: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3128: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3129: RAISE FND_API.G_EXC_ERROR;
3130: END IF;
3131:
3132: /* Added for Bug # 1559906 */
3133: /* Renga- copy_freight_charges delayed request should be executed

Line 3139: ,p_delete => FND_API.G_TRUE

3135: request in between copy_adjustments and copy_freight_charges */
3136:
3137: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3138: (p_request_type =>OE_GLOBALS.G_COPY_FREIGHT_CHARGES
3139: ,p_delete => FND_API.G_TRUE
3140: ,x_return_status => l_return_status
3141: );
3142: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3142: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3138: (p_request_type =>OE_GLOBALS.G_COPY_FREIGHT_CHARGES
3139: ,p_delete => FND_API.G_TRUE
3140: ,x_return_status => l_return_status
3141: );
3142: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3144: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3145: RAISE FND_API.G_EXC_ERROR;
3146: END IF;

Line 3143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3139: ,p_delete => FND_API.G_TRUE
3140: ,x_return_status => l_return_status
3141: );
3142: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3144: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3145: RAISE FND_API.G_EXC_ERROR;
3146: END IF;
3147:

Line 3144: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3140: ,x_return_status => l_return_status
3141: );
3142: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3144: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3145: RAISE FND_API.G_EXC_ERROR;
3146: END IF;
3147:
3148:

Line 3145: RAISE FND_API.G_EXC_ERROR;

3141: );
3142: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3144: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3145: RAISE FND_API.G_EXC_ERROR;
3146: END IF;
3147:
3148:
3149: -- Process Requests for Pricing

Line 3152: ,p_delete => FND_API.G_TRUE

3148:
3149: -- Process Requests for Pricing
3150: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3151: (p_request_type =>OE_GLOBALS.G_PRICE_LINE
3152: ,p_delete => FND_API.G_TRUE
3153: ,x_return_status => l_return_status
3154: );
3155: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3155: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3151: (p_request_type =>OE_GLOBALS.G_PRICE_LINE
3152: ,p_delete => FND_API.G_TRUE
3153: ,x_return_status => l_return_status
3154: );
3155: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3157: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3158: RAISE FND_API.G_EXC_ERROR;
3159: END IF;

Line 3156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3152: ,p_delete => FND_API.G_TRUE
3153: ,x_return_status => l_return_status
3154: );
3155: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3157: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3158: RAISE FND_API.G_EXC_ERROR;
3159: END IF;
3160:

Line 3157: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3153: ,x_return_status => l_return_status
3154: );
3155: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3157: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3158: RAISE FND_API.G_EXC_ERROR;
3159: END IF;
3160:
3161:

Line 3158: RAISE FND_API.G_EXC_ERROR;

3154: );
3155: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3157: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3158: RAISE FND_API.G_EXC_ERROR;
3159: END IF;
3160:
3161:
3162: -- Renga - added freight_for_included items call

Line 3166: ,p_delete => FND_API.G_TRUE

3162: -- Renga - added freight_for_included items call
3163: -- Process Requests for Freight For included items.
3164: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3165: (p_request_type =>OE_GLOBALS.G_FREIGHT_FOR_INCLUDED
3166: ,p_delete => FND_API.G_TRUE
3167: ,x_return_status => l_return_status
3168: );
3169: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3169: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3165: (p_request_type =>OE_GLOBALS.G_FREIGHT_FOR_INCLUDED
3166: ,p_delete => FND_API.G_TRUE
3167: ,x_return_status => l_return_status
3168: );
3169: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3171: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3172: RAISE FND_API.G_EXC_ERROR;
3173: END IF;

Line 3170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3166: ,p_delete => FND_API.G_TRUE
3167: ,x_return_status => l_return_status
3168: );
3169: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3171: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3172: RAISE FND_API.G_EXC_ERROR;
3173: END IF;
3174:

Line 3171: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3167: ,x_return_status => l_return_status
3168: );
3169: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3171: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3172: RAISE FND_API.G_EXC_ERROR;
3173: END IF;
3174:
3175: -- Renga - done for freight for included items.

Line 3172: RAISE FND_API.G_EXC_ERROR;

3168: );
3169: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3171: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3172: RAISE FND_API.G_EXC_ERROR;
3173: END IF;
3174:
3175: -- Renga - done for freight for included items.
3176:

Line 3180: ,p_delete => FND_API.G_TRUE

3176:
3177:
3178: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3179: (p_request_type =>OE_GLOBALS.G_PRICE_ORDER
3180: ,p_delete => FND_API.G_TRUE
3181: ,x_return_status => l_return_status
3182: );
3183: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3183: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3179: (p_request_type =>OE_GLOBALS.G_PRICE_ORDER
3180: ,p_delete => FND_API.G_TRUE
3181: ,x_return_status => l_return_status
3182: );
3183: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3185: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3186: RAISE FND_API.G_EXC_ERROR;
3187: END IF;

Line 3184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3180: ,p_delete => FND_API.G_TRUE
3181: ,x_return_status => l_return_status
3182: );
3183: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3185: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3186: RAISE FND_API.G_EXC_ERROR;
3187: END IF;
3188:

Line 3185: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3181: ,x_return_status => l_return_status
3182: );
3183: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3185: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3186: RAISE FND_API.G_EXC_ERROR;
3187: END IF;
3188:
3189: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 3186: RAISE FND_API.G_EXC_ERROR;

3182: );
3183: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3185: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3186: RAISE FND_API.G_EXC_ERROR;
3187: END IF;
3188:
3189: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3190: (p_request_type =>OE_GLOBALS.G_PRICE_ADJ

Line 3191: ,p_delete => FND_API.G_TRUE

3187: END IF;
3188:
3189: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3190: (p_request_type =>OE_GLOBALS.G_PRICE_ADJ
3191: ,p_delete => FND_API.G_TRUE
3192: ,x_return_status => l_return_status
3193: );
3194: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3194: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3190: (p_request_type =>OE_GLOBALS.G_PRICE_ADJ
3191: ,p_delete => FND_API.G_TRUE
3192: ,x_return_status => l_return_status
3193: );
3194: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3197: RAISE FND_API.G_EXC_ERROR;
3198: END IF;

Line 3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3191: ,p_delete => FND_API.G_TRUE
3192: ,x_return_status => l_return_status
3193: );
3194: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3197: RAISE FND_API.G_EXC_ERROR;
3198: END IF;
3199:

Line 3196: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3192: ,x_return_status => l_return_status
3193: );
3194: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3197: RAISE FND_API.G_EXC_ERROR;
3198: END IF;
3199:
3200: -- added by lkxu

Line 3197: RAISE FND_API.G_EXC_ERROR;

3193: );
3194: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3197: RAISE FND_API.G_EXC_ERROR;
3198: END IF;
3199:
3200: -- added by lkxu
3201: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 3203: ,p_delete => FND_API.G_TRUE

3199:
3200: -- added by lkxu
3201: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3202: (p_request_type =>OE_GLOBALS.G_COPY_PRICING_ATTRIBUTES
3203: ,p_delete => FND_API.G_TRUE
3204: ,x_return_status => l_return_status
3205: );
3206: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3206: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3202: (p_request_type =>OE_GLOBALS.G_COPY_PRICING_ATTRIBUTES
3203: ,p_delete => FND_API.G_TRUE
3204: ,x_return_status => l_return_status
3205: );
3206: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3208: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3209: RAISE FND_API.G_EXC_ERROR;
3210: END IF;

Line 3207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3203: ,p_delete => FND_API.G_TRUE
3204: ,x_return_status => l_return_status
3205: );
3206: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3208: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3209: RAISE FND_API.G_EXC_ERROR;
3210: END IF;
3211:

Line 3208: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3204: ,x_return_status => l_return_status
3205: );
3206: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3208: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3209: RAISE FND_API.G_EXC_ERROR;
3210: END IF;
3211:
3212: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 3209: RAISE FND_API.G_EXC_ERROR;

3205: );
3206: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3208: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3209: RAISE FND_API.G_EXC_ERROR;
3210: END IF;
3211:
3212: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3213: (p_request_type =>OE_GLOBALS.G_COPY_MODEL_PATTR

Line 3214: ,p_delete => FND_API.G_TRUE

3210: END IF;
3211:
3212: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3213: (p_request_type =>OE_GLOBALS.G_COPY_MODEL_PATTR
3214: ,p_delete => FND_API.G_TRUE
3215: ,x_return_status => l_return_status
3216: );
3217: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3217: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3213: (p_request_type =>OE_GLOBALS.G_COPY_MODEL_PATTR
3214: ,p_delete => FND_API.G_TRUE
3215: ,x_return_status => l_return_status
3216: );
3217: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3219: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3220: RAISE FND_API.G_EXC_ERROR;
3221: END IF;

Line 3218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3214: ,p_delete => FND_API.G_TRUE
3215: ,x_return_status => l_return_status
3216: );
3217: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3219: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3220: RAISE FND_API.G_EXC_ERROR;
3221: END IF;
3222:

Line 3219: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3215: ,x_return_status => l_return_status
3216: );
3217: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3219: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3220: RAISE FND_API.G_EXC_ERROR;
3221: END IF;
3222:
3223: -- Process Delete Charges Delayed Requests

Line 3220: RAISE FND_API.G_EXC_ERROR;

3216: );
3217: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3219: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3220: RAISE FND_API.G_EXC_ERROR;
3221: END IF;
3222:
3223: -- Process Delete Charges Delayed Requests
3224: Process_Request_for_ReqType

Line 3226: ,p_delete => FND_API.G_TRUE

3222:
3223: -- Process Delete Charges Delayed Requests
3224: Process_Request_for_ReqType
3225: (p_request_type => OE_GLOBALS.G_DELETE_CHARGES
3226: ,p_delete => FND_API.G_TRUE
3227: ,x_return_status => l_return_status
3228: );
3229: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3229: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3225: (p_request_type => OE_GLOBALS.G_DELETE_CHARGES
3226: ,p_delete => FND_API.G_TRUE
3227: ,x_return_status => l_return_status
3228: );
3229: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3232: RAISE FND_API.G_EXC_ERROR;
3233: END IF;

Line 3230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3226: ,p_delete => FND_API.G_TRUE
3227: ,x_return_status => l_return_status
3228: );
3229: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3232: RAISE FND_API.G_EXC_ERROR;
3233: END IF;
3234:

Line 3231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3227: ,x_return_status => l_return_status
3228: );
3229: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3232: RAISE FND_API.G_EXC_ERROR;
3233: END IF;
3234:
3235: -- Process Tax Delayed Requests

Line 3232: RAISE FND_API.G_EXC_ERROR;

3228: );
3229: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3232: RAISE FND_API.G_EXC_ERROR;
3233: END IF;
3234:
3235: -- Process Tax Delayed Requests
3236: Process_Request_for_ReqType

Line 3238: ,p_delete => FND_API.G_TRUE

3234:
3235: -- Process Tax Delayed Requests
3236: Process_Request_for_ReqType
3237: (p_request_type => OE_GLOBALS.G_TAX_LINE
3238: ,p_delete => FND_API.G_TRUE
3239: ,x_return_status => l_return_status
3240: );
3241: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3241: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3237: (p_request_type => OE_GLOBALS.G_TAX_LINE
3238: ,p_delete => FND_API.G_TRUE
3239: ,x_return_status => l_return_status
3240: );
3241: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3243: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3244: RAISE FND_API.G_EXC_ERROR;
3245: END IF;

Line 3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3238: ,p_delete => FND_API.G_TRUE
3239: ,x_return_status => l_return_status
3240: );
3241: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3243: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3244: RAISE FND_API.G_EXC_ERROR;
3245: END IF;
3246:

Line 3243: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3239: ,x_return_status => l_return_status
3240: );
3241: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3243: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3244: RAISE FND_API.G_EXC_ERROR;
3245: END IF;
3246:
3247:

Line 3244: RAISE FND_API.G_EXC_ERROR;

3240: );
3241: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3243: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3244: RAISE FND_API.G_EXC_ERROR;
3245: END IF;
3246:
3247:
3248: -- Process Commitment Delayed Requests

Line 3251: ,p_delete => FND_API.G_TRUE

3247:
3248: -- Process Commitment Delayed Requests
3249: Process_Request_for_ReqType
3250: (p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT
3251: ,p_delete => FND_API.G_TRUE
3252: ,x_return_status => l_return_status
3253: );
3254: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3254: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3250: (p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT
3251: ,p_delete => FND_API.G_TRUE
3252: ,x_return_status => l_return_status
3253: );
3254: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3256: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3257: RAISE FND_API.G_EXC_ERROR;
3258: END IF;

Line 3255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3251: ,p_delete => FND_API.G_TRUE
3252: ,x_return_status => l_return_status
3253: );
3254: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3256: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3257: RAISE FND_API.G_EXC_ERROR;
3258: END IF;
3259:

Line 3256: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3252: ,x_return_status => l_return_status
3253: );
3254: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3256: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3257: RAISE FND_API.G_EXC_ERROR;
3258: END IF;
3259:
3260: -- Process Commitment Delayed Requests

Line 3257: RAISE FND_API.G_EXC_ERROR;

3253: );
3254: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3256: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3257: RAISE FND_API.G_EXC_ERROR;
3258: END IF;
3259:
3260: -- Process Commitment Delayed Requests
3261: Process_Request_for_ReqType

Line 3263: ,p_delete => FND_API.G_TRUE

3259:
3260: -- Process Commitment Delayed Requests
3261: Process_Request_for_ReqType
3262: (p_request_type => OE_GLOBALS.G_UPDATE_COMMITMENT
3263: ,p_delete => FND_API.G_TRUE
3264: ,x_return_status => l_return_status
3265: );
3266: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3266: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3262: (p_request_type => OE_GLOBALS.G_UPDATE_COMMITMENT
3263: ,p_delete => FND_API.G_TRUE
3264: ,x_return_status => l_return_status
3265: );
3266: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3268: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3269: RAISE FND_API.G_EXC_ERROR;
3270: END IF;

Line 3267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3263: ,p_delete => FND_API.G_TRUE
3264: ,x_return_status => l_return_status
3265: );
3266: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3268: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3269: RAISE FND_API.G_EXC_ERROR;
3270: END IF;
3271:

Line 3268: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3264: ,x_return_status => l_return_status
3265: );
3266: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3268: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3269: RAISE FND_API.G_EXC_ERROR;
3270: END IF;
3271:
3272: -- for multiple payments

Line 3269: RAISE FND_API.G_EXC_ERROR;

3265: );
3266: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3268: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3269: RAISE FND_API.G_EXC_ERROR;
3270: END IF;
3271:
3272: -- for multiple payments
3273: Process_Request_for_ReqType

Line 3275: ,p_delete => FND_API.G_TRUE

3271:
3272: -- for multiple payments
3273: Process_Request_for_ReqType
3274: (p_request_type => OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED
3275: ,p_delete => FND_API.G_TRUE
3276: ,x_return_status => l_return_status
3277: );
3278: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3278: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3274: (p_request_type => OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED
3275: ,p_delete => FND_API.G_TRUE
3276: ,x_return_status => l_return_status
3277: );
3278: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3280: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3281: RAISE FND_API.G_EXC_ERROR;
3282: END IF;

Line 3279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3275: ,p_delete => FND_API.G_TRUE
3276: ,x_return_status => l_return_status
3277: );
3278: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3280: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3281: RAISE FND_API.G_EXC_ERROR;
3282: END IF;
3283:

Line 3280: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3276: ,x_return_status => l_return_status
3277: );
3278: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3280: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3281: RAISE FND_API.G_EXC_ERROR;
3282: END IF;
3283:
3284: -- for multiple payments

Line 3281: RAISE FND_API.G_EXC_ERROR;

3277: );
3278: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3280: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3281: RAISE FND_API.G_EXC_ERROR;
3282: END IF;
3283:
3284: -- for multiple payments
3285: Process_Request_for_ReqType

Line 3287: ,p_delete => FND_API.G_TRUE

3283:
3284: -- for multiple payments
3285: Process_Request_for_ReqType
3286: (p_request_type => OE_GLOBALS.G_SPLIT_PAYMENT
3287: ,p_delete => FND_API.G_TRUE
3288: ,x_return_status => l_return_status
3289: );
3290: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3290: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3286: (p_request_type => OE_GLOBALS.G_SPLIT_PAYMENT
3287: ,p_delete => FND_API.G_TRUE
3288: ,x_return_status => l_return_status
3289: );
3290: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3292: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3293: RAISE FND_API.G_EXC_ERROR;
3294: END IF;

Line 3291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3287: ,p_delete => FND_API.G_TRUE
3288: ,x_return_status => l_return_status
3289: );
3290: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3292: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3293: RAISE FND_API.G_EXC_ERROR;
3294: END IF;
3295:

Line 3292: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3288: ,x_return_status => l_return_status
3289: );
3290: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3292: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3293: RAISE FND_API.G_EXC_ERROR;
3294: END IF;
3295:
3296: Process_Request_for_ReqType

Line 3293: RAISE FND_API.G_EXC_ERROR;

3289: );
3290: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3292: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3293: RAISE FND_API.G_EXC_ERROR;
3294: END IF;
3295:
3296: Process_Request_for_ReqType
3297: (p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT

Line 3298: ,p_delete => FND_API.G_TRUE

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

Line 3301: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3297: (p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT
3298: ,p_delete => FND_API.G_TRUE
3299: ,x_return_status => l_return_status
3300: );
3301: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3303: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3304: RAISE FND_API.G_EXC_ERROR;
3305: END IF;

Line 3302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3303: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3299: ,x_return_status => l_return_status
3300: );
3301: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3303: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3304: RAISE FND_API.G_EXC_ERROR;
3305: END IF;
3306:
3307: -- Process requests for Payment Verification

Line 3304: RAISE FND_API.G_EXC_ERROR;

3300: );
3301: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3303: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3304: RAISE FND_API.G_EXC_ERROR;
3305: END IF;
3306:
3307: -- Process requests for Payment Verification
3308: Process_Request_for_ReqType

Line 3310: ,p_delete => FND_API.G_TRUE

3306:
3307: -- Process requests for Payment Verification
3308: Process_Request_for_ReqType
3309: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
3310: ,p_delete => FND_API.G_TRUE
3311: ,x_return_status => l_return_status
3312: );
3313: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3313: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3309: (p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT
3310: ,p_delete => FND_API.G_TRUE
3311: ,x_return_status => l_return_status
3312: );
3313: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3316: RAISE FND_API.G_EXC_ERROR;
3317: END IF;

Line 3314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3311: ,x_return_status => l_return_status
3312: );
3313: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3316: RAISE FND_API.G_EXC_ERROR;
3317: END IF;
3318:
3319: Process_Request_for_ReqType

Line 3316: RAISE FND_API.G_EXC_ERROR;

3312: );
3313: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3316: RAISE FND_API.G_EXC_ERROR;
3317: END IF;
3318:
3319: Process_Request_for_ReqType
3320: (p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD

Line 3321: ,p_delete => FND_API.G_TRUE

3317: END IF;
3318:
3319: Process_Request_for_ReqType
3320: (p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD
3321: ,p_delete => FND_API.G_TRUE
3322: ,x_return_status => l_return_status
3323: );
3324: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3324: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3321: ,p_delete => FND_API.G_TRUE
3322: ,x_return_status => l_return_status
3323: );
3324: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3326: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3327: RAISE FND_API.G_EXC_ERROR;
3328: END IF;
3329:

Line 3326: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3322: ,x_return_status => l_return_status
3323: );
3324: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3326: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3327: RAISE FND_API.G_EXC_ERROR;
3328: END IF;
3329:
3330: -- Process Request to create automatic attachments

Line 3327: RAISE FND_API.G_EXC_ERROR;

3323: );
3324: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3326: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3327: RAISE FND_API.G_EXC_ERROR;
3328: END IF;
3329:
3330: -- Process Request to create automatic attachments
3331: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 3333: ,p_delete => FND_API.G_TRUE

3329:
3330: -- Process Request to create automatic attachments
3331: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3332: (p_request_type =>OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
3333: ,p_delete => FND_API.G_TRUE
3334: ,x_return_status => l_return_status
3335: );
3336: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3336: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3338: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3334: ,x_return_status => l_return_status
3335: );
3336: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3338: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3339: RAISE FND_API.G_EXC_ERROR;
3340: END IF;
3341:
3342: -- Process Request to copy attachments

Line 3339: RAISE FND_API.G_EXC_ERROR;

3335: );
3336: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3338: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3339: RAISE FND_API.G_EXC_ERROR;
3340: END IF;
3341:
3342: -- Process Request to copy attachments
3343: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 3345: ,p_delete => FND_API.G_TRUE

3341:
3342: -- Process Request to copy attachments
3343: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3344: (p_request_type =>OE_GLOBALS.G_COPY_ATCHMT
3345: ,p_delete => FND_API.G_TRUE
3346: ,x_return_status => l_return_status
3347: );
3348: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3348: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3350: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3346: ,x_return_status => l_return_status
3347: );
3348: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3350: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3351: RAISE FND_API.G_EXC_ERROR;
3352: END IF;
3353:
3354: --added by MShenoy for Spares Management ikon project - Create internal req.

Line 3351: RAISE FND_API.G_EXC_ERROR;

3347: );
3348: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3350: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3351: RAISE FND_API.G_EXC_ERROR;
3352: END IF;
3353:
3354: --added by MShenoy for Spares Management ikon project - Create internal req.
3355: IF l_debug_level > 0 THEN

Line 3361: ,p_delete => FND_API.G_TRUE

3357: END IF;
3358:
3359: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3360: (p_request_type =>OE_GLOBALS.G_CREATE_INTERNAL_REQ
3361: ,p_delete => FND_API.G_TRUE
3362: ,x_return_status => l_return_status);
3363: IF l_debug_level > 0 THEN
3364: oe_debug_pub.add(' leaving Procedure process_Delayed_Requests in Package
3365: OE_Delayed_Requests_Pvt ret status '||l_return_status);

Line 3367: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3363: IF l_debug_level > 0 THEN
3364: oe_debug_pub.add(' leaving Procedure process_Delayed_Requests in Package
3365: OE_Delayed_Requests_Pvt ret status '||l_return_status);
3366: END IF;
3367: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3369: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3370: RAISE FND_API.G_EXC_ERROR;
3371: END IF;

Line 3368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3364: oe_debug_pub.add(' leaving Procedure process_Delayed_Requests in Package
3365: OE_Delayed_Requests_Pvt ret status '||l_return_status);
3366: END IF;
3367: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3369: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3370: RAISE FND_API.G_EXC_ERROR;
3371: END IF;
3372:

Line 3369: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3365: OE_Delayed_Requests_Pvt ret status '||l_return_status);
3366: END IF;
3367: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3369: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3370: RAISE FND_API.G_EXC_ERROR;
3371: END IF;
3372:
3373: -- B2013611 reverse promotional limits

Line 3370: RAISE FND_API.G_EXC_ERROR;

3366: END IF;
3367: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3369: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3370: RAISE FND_API.G_EXC_ERROR;
3371: END IF;
3372:
3373: -- B2013611 reverse promotional limits
3374: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 3376: ,p_delete => FND_API.G_TRUE

3372:
3373: -- B2013611 reverse promotional limits
3374: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3375: (p_request_type =>OE_GLOBALS.G_REVERSE_LIMITS
3376: ,p_delete => FND_API.G_TRUE
3377: ,x_return_status => l_return_status
3378: );
3379: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3379: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3375: (p_request_type =>OE_GLOBALS.G_REVERSE_LIMITS
3376: ,p_delete => FND_API.G_TRUE
3377: ,x_return_status => l_return_status
3378: );
3379: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3381: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3382: RAISE FND_API.G_EXC_ERROR;
3383: END IF;

Line 3380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3376: ,p_delete => FND_API.G_TRUE
3377: ,x_return_status => l_return_status
3378: );
3379: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3381: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3382: RAISE FND_API.G_EXC_ERROR;
3383: END IF;
3384:

Line 3381: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3377: ,x_return_status => l_return_status
3378: );
3379: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3381: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3382: RAISE FND_API.G_EXC_ERROR;
3383: END IF;
3384:
3385: --MRG BGN

Line 3382: RAISE FND_API.G_EXC_ERROR;

3378: );
3379: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3381: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3382: RAISE FND_API.G_EXC_ERROR;
3383: END IF;
3384:
3385: --MRG BGN
3386: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 3388: ,p_delete => FND_API.G_TRUE

3384:
3385: --MRG BGN
3386: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3387: (p_request_type => OE_GLOBALS.G_MARGIN_HOLD
3388: ,p_delete => FND_API.G_TRUE
3389: ,x_return_status => l_return_status
3390: );
3391: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3391: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3387: (p_request_type => OE_GLOBALS.G_MARGIN_HOLD
3388: ,p_delete => FND_API.G_TRUE
3389: ,x_return_status => l_return_status
3390: );
3391: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3393: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3394: RAISE FND_API.G_EXC_ERROR;
3395: END IF;

Line 3392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3388: ,p_delete => FND_API.G_TRUE
3389: ,x_return_status => l_return_status
3390: );
3391: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3393: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3394: RAISE FND_API.G_EXC_ERROR;
3395: END IF;
3396: --MRG END

Line 3393: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3389: ,x_return_status => l_return_status
3390: );
3391: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3393: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3394: RAISE FND_API.G_EXC_ERROR;
3395: END IF;
3396: --MRG END
3397:

Line 3394: RAISE FND_API.G_EXC_ERROR;

3390: );
3391: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3393: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3394: RAISE FND_API.G_EXC_ERROR;
3395: END IF;
3396: --MRG END
3397:
3398:

Line 3409: ,p_delete => FND_API.G_TRUE

3405: oe_debug_pub.add('before call to OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype in process_delayed_requests');
3406: END IF;
3407: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3408: (p_request_type => OE_GLOBALS.G_GET_COST
3409: ,p_delete => FND_API.G_TRUE
3410: ,x_return_status => l_return_status
3411: );
3412: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3412: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3414: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3410: ,x_return_status => l_return_status
3411: );
3412: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3414: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3415: RAISE FND_API.G_EXC_ERROR;
3416: END IF;
3417: --MRG END
3418:

Line 3415: RAISE FND_API.G_EXC_ERROR;

3411: );
3412: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3414: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3415: RAISE FND_API.G_EXC_ERROR;
3416: END IF;
3417: --MRG END
3418:
3419:

Line 3422: ,p_delete => FND_API.G_TRUE

3418:
3419:
3420: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3421: (p_request_type =>OE_GLOBALS.G_DEL_CHG_LINES
3422: ,p_delete => FND_API.G_TRUE
3423: ,x_return_status => l_return_status
3424: );
3425: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3425: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3427: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3423: ,x_return_status => l_return_status
3424: );
3425: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3427: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3428: RAISE FND_API.G_EXC_ERROR;
3429: END IF;
3430:
3431:

Line 3428: RAISE FND_API.G_EXC_ERROR;

3424: );
3425: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3427: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3428: RAISE FND_API.G_EXC_ERROR;
3429: END IF;
3430:
3431:
3432: --process delayed requests for xml generation

Line 3436: ,p_delete => FND_API.G_TRUE

3432: --process delayed requests for xml generation
3433:
3434: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3435: (p_request_type =>OE_GLOBALS.G_GENERATE_XML_REQ_HDR
3436: ,p_delete => FND_API.G_TRUE
3437: ,x_return_status => l_return_status
3438: );
3439: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3439: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3435: (p_request_type =>OE_GLOBALS.G_GENERATE_XML_REQ_HDR
3436: ,p_delete => FND_API.G_TRUE
3437: ,x_return_status => l_return_status
3438: );
3439: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3441: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3442: RAISE FND_API.G_EXC_ERROR;
3443: END IF;

Line 3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3436: ,p_delete => FND_API.G_TRUE
3437: ,x_return_status => l_return_status
3438: );
3439: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3441: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3442: RAISE FND_API.G_EXC_ERROR;
3443: END IF;
3444:

Line 3441: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3437: ,x_return_status => l_return_status
3438: );
3439: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3441: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3442: RAISE FND_API.G_EXC_ERROR;
3443: END IF;
3444:
3445:

Line 3442: RAISE FND_API.G_EXC_ERROR;

3438: );
3439: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3441: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3442: RAISE FND_API.G_EXC_ERROR;
3443: END IF;
3444:
3445:
3446: -- Please do not put any delayed requests that can update qty

Line 3457: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3453: -- and VALIDATE_RELEASE_SHIPMENTS.
3454: OE_Blkt_Release_Util.Process_Releases
3455: (p_request_tbl => G_Delayed_Requests
3456: ,x_return_status => l_return_status);
3457: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3459: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3460: RAISE FND_API.G_EXC_ERROR;
3461: END IF;

Line 3458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3454: OE_Blkt_Release_Util.Process_Releases
3455: (p_request_tbl => G_Delayed_Requests
3456: ,x_return_status => l_return_status);
3457: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3459: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3460: RAISE FND_API.G_EXC_ERROR;
3461: END IF;
3462:

Line 3459: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3455: (p_request_tbl => G_Delayed_Requests
3456: ,x_return_status => l_return_status);
3457: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3459: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3460: RAISE FND_API.G_EXC_ERROR;
3461: END IF;
3462:
3463: -- Changes for Enhanced Dropshipments

Line 3460: RAISE FND_API.G_EXC_ERROR;

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

Line 3468: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3464:
3465: OE_Purchase_Release_PVT.Process_DropShip_CMS_Requests
3466: (p_request_tbl => G_Delayed_Requests
3467: ,x_return_status => l_return_status);
3468: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3470: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3471: RAISE FND_API.G_EXC_ERROR;
3472: END IF;

Line 3469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3465: OE_Purchase_Release_PVT.Process_DropShip_CMS_Requests
3466: (p_request_tbl => G_Delayed_Requests
3467: ,x_return_status => l_return_status);
3468: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3470: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3471: RAISE FND_API.G_EXC_ERROR;
3472: END IF;
3473:

Line 3470: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3466: (p_request_tbl => G_Delayed_Requests
3467: ,x_return_status => l_return_status);
3468: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3470: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3471: RAISE FND_API.G_EXC_ERROR;
3472: END IF;
3473:
3474:

Line 3471: RAISE FND_API.G_EXC_ERROR;

3467: ,x_return_status => l_return_status);
3468: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3470: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3471: RAISE FND_API.G_EXC_ERROR;
3472: END IF;
3473:
3474:
3475: /* 7576948: IR ISO Change Management project Start */

Line 3486: , p_delete => FND_API.G_TRUE

3482:
3483: -- Process Request to Update the Internal Requisition
3484: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3485: ( p_request_type => OE_GLOBALS.G_UPDATE_REQUISITION
3486: , p_delete => FND_API.G_TRUE
3487: , x_return_status => l_return_status
3488: );
3489:
3490: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3490: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3486: , p_delete => FND_API.G_TRUE
3487: , x_return_status => l_return_status
3488: );
3489:
3490: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3492: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3493: RAISE FND_API.G_EXC_ERROR;
3494: END IF;

Line 3491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3487: , x_return_status => l_return_status
3488: );
3489:
3490: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3492: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3493: RAISE FND_API.G_EXC_ERROR;
3494: END IF;
3495:

Line 3492: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3488: );
3489:
3490: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3492: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3493: RAISE FND_API.G_EXC_ERROR;
3494: END IF;
3495:
3496: /* ============================= */

Line 3493: RAISE FND_API.G_EXC_ERROR;

3489:
3490: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3492: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3493: RAISE FND_API.G_EXC_ERROR;
3494: END IF;
3495:
3496: /* ============================= */
3497: /* IR ISO Change Management Ends */

Line 3504: ,p_delete => FND_API.G_TRUE

3500: --process delayed requests for cancel workflow
3501:
3502: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3503: (p_request_type =>OE_GLOBALS.G_CANCEL_WF
3504: ,p_delete => FND_API.G_TRUE
3505: ,x_return_status => l_return_status
3506: );
3507: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3507: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3504: ,p_delete => FND_API.G_TRUE
3505: ,x_return_status => l_return_status
3506: );
3507: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3509: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3510: RAISE FND_API.G_EXC_ERROR;
3511: END IF;
3512:

Line 3509: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3505: ,x_return_status => l_return_status
3506: );
3507: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3509: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3510: RAISE FND_API.G_EXC_ERROR;
3511: END IF;
3512:
3513:

Line 3510: RAISE FND_API.G_EXC_ERROR;

3506: );
3507: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3509: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3510: RAISE FND_API.G_EXC_ERROR;
3511: END IF;
3512:
3513:
3514: /* Please do not put execution of any delayed request beyond this point */

Line 3525: ,p_delete => FND_API.G_TRUE

3521:
3522: WHILE l_ind IS NOT NULL LOOP
3523: Process_Request_Pvt
3524: (p_request_ind => l_ind
3525: ,p_delete => FND_API.G_TRUE
3526: ,x_return_status => l_return_status
3527: );
3528:
3529: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3529: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3526: ,x_return_status => l_return_status
3527: );
3528:
3529: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3531: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3532: RAISE FND_API.G_EXC_ERROR;
3533: END IF;
3534: l_ind := G_Delayed_Requests.Next(l_ind);

Line 3531: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3527: );
3528:
3529: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3531: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3532: RAISE FND_API.G_EXC_ERROR;
3533: END IF;
3534: l_ind := G_Delayed_Requests.Next(l_ind);
3535: END LOOP;

Line 3532: RAISE FND_API.G_EXC_ERROR;

3528:
3529: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3531: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3532: RAISE FND_API.G_EXC_ERROR;
3533: END IF;
3534: l_ind := G_Delayed_Requests.Next(l_ind);
3535: END LOOP;
3536:

Line 3540: ,p_delete => FND_API.G_TRUE

3536:
3537: -- Process Request to Complete workflow activity
3538: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3539: (p_request_type =>OE_GLOBALS.G_COMPLETE_ACTIVITY
3540: ,p_delete => FND_API.G_TRUE
3541: ,x_return_status => l_return_status
3542: );
3543: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3543: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 3544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3545: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3541: ,x_return_status => l_return_status
3542: );
3543: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3545: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3546: RAISE FND_API.G_EXC_ERROR;
3547: END IF;
3548: IF l_debug_level > 0 THEN
3549: oe_debug_pub.add('Global Request count-PDR-AL'||G_Delayed_Requests.count,1);

Line 3546: RAISE FND_API.G_EXC_ERROR;

3542: );
3543: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3545: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3546: RAISE FND_API.G_EXC_ERROR;
3547: END IF;
3548: IF l_debug_level > 0 THEN
3549: oe_debug_pub.add('Global Request count-PDR-AL'||G_Delayed_Requests.count,1);
3550: END IF;

Line 3560: WHEN FND_API.G_EXC_ERROR THEN

3556: p_In_out => 0);
3557:
3558: EXCEPTION
3559:
3560: WHEN FND_API.G_EXC_ERROR THEN
3561: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3562: p_In_out => 0);
3563: x_return_status := FND_API.G_RET_STS_ERROR;
3564:

Line 3563: x_return_status := FND_API.G_RET_STS_ERROR;

3559:
3560: WHEN FND_API.G_EXC_ERROR THEN
3561: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3562: p_In_out => 0);
3563: x_return_status := FND_API.G_RET_STS_ERROR;
3564:
3565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3566: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3567: p_In_out => 0);

Line 3565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3561: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3562: p_In_out => 0);
3563: x_return_status := FND_API.G_RET_STS_ERROR;
3564:
3565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3566: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3567: p_In_out => 0);
3568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3569:

Line 3568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3564:
3565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3566: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3567: p_In_out => 0);
3568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3569:
3570: WHEN OTHERS THEN
3571: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3572: p_In_out => 0);

Line 3573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3569:
3570: WHEN OTHERS THEN
3571: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3572: p_In_out => 0);
3573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3574:
3575: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3576: THEN
3577: OE_MSG_PUB.Add_Exc_Msg

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

3587: ** processed after the flow has started (book, LINK, match_and_reserve)
3588: **/
3589:
3590: PROCEDURE Process_Order_Actions
3591: (p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3592: p_x_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type,
3593: p_process_WF_requests IN boolean DEFAULT TRUE
3594: )
3595: IS

Line 3999: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3995:
3996: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_REQUEST');
3997: FND_MESSAGE.SET_TOKEN('ACTION',l_request_rec.request_type);
3998: OE_MSG_PUB.Add;
3999: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4000:
4001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4002: END IF;
4003:

Line 4001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3997: FND_MESSAGE.SET_TOKEN('ACTION',l_request_rec.request_type);
3998: OE_MSG_PUB.Add;
3999: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4000:
4001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4002: END IF;
4003:
4004: IF l_debug_level > 0 THEN
4005: oe_debug_pub.add('After Price Order, Status : ' || l_return_status, 5);

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

4006: END IF;
4007:
4008: l_request_rec.processed := 'Y';
4009:
4010: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4012: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR THEN
4013: RAISE FND_API.G_EXC_ERROR;
4014: END IF;

Line 4011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4007:
4008: l_request_rec.processed := 'Y';
4009:
4010: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4012: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR THEN
4013: RAISE FND_API.G_EXC_ERROR;
4014: END IF;
4015:

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

4008: l_request_rec.processed := 'Y';
4009:
4010: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4012: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR THEN
4013: RAISE FND_API.G_EXC_ERROR;
4014: END IF;
4015:
4016: -- End of ER 7243028

Line 4013: RAISE FND_API.G_EXC_ERROR;

4009:
4010: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4012: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR THEN
4013: RAISE FND_API.G_EXC_ERROR;
4014: END IF;
4015:
4016: -- End of ER 7243028
4017:

Line 4105: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4101: IF l_debug_level > 0 THEN
4102: oe_debug_pub.add('After call to Authorizat Payment return status : ' || l_return_status);
4103: END IF;
4104:
4105: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4106: RAISE FND_API.G_EXC_ERROR;
4107: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4109: END IF;

Line 4106: RAISE FND_API.G_EXC_ERROR;

4102: oe_debug_pub.add('After call to Authorizat Payment return status : ' || l_return_status);
4103: END IF;
4104:
4105: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4106: RAISE FND_API.G_EXC_ERROR;
4107: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4109: END IF;
4110:

Line 4107: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4103: END IF;
4104:
4105: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4106: RAISE FND_API.G_EXC_ERROR;
4107: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4109: END IF;
4110:
4111: l_request_rec.processed := 'Y';

Line 4108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4104:
4105: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4106: RAISE FND_API.G_EXC_ERROR;
4107: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4109: END IF;
4110:
4111: l_request_rec.processed := 'Y';
4112: -- to ensure verify_payment not getting called again during book_order.

Line 4228: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4224: END IF;
4225: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_REQUEST');
4226: FND_MESSAGE.SET_TOKEN('ACTION',l_request_rec.request_type);
4227: OE_MSG_PUB.Add;
4228: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4229: END IF;
4230:
4231: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR
4232: THEN

Line 4231: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR

4227: OE_MSG_PUB.Add;
4228: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4229: END IF;
4230:
4231: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR
4232: THEN
4233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4234: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR
4235: THEN

Line 4233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4229: END IF;
4230:
4231: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR
4232: THEN
4233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4234: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR
4235: THEN
4236: RAISE FND_API.G_EXC_ERROR;
4237: END IF;

Line 4234: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR

4230:
4231: IF l_request_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR
4232: THEN
4233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4234: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR
4235: THEN
4236: RAISE FND_API.G_EXC_ERROR;
4237: END IF;
4238:

Line 4236: RAISE FND_API.G_EXC_ERROR;

4232: THEN
4233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4234: ELSIF l_request_rec.return_status = FND_API.G_RET_STS_ERROR
4235: THEN
4236: RAISE FND_API.G_EXC_ERROR;
4237: END IF;
4238:
4239: IF ( l_request_rec.request_type = OE_GLOBALS.G_ACCEPT_FULFILLMENT OR
4240: l_request_rec.request_type = OE_GLOBALS.G_REJECT_FULFILLMENT) AND

Line 4252: WHEN FND_API.G_EXC_ERROR THEN

4248: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4249:
4250: EXCEPTION
4251:
4252: WHEN FND_API.G_EXC_ERROR THEN
4253: l_request_rec.return_status := FND_API.G_RET_STS_ERROR;
4254: l_request_rec.processed := 'Y';
4255: p_x_request_tbl(i):= l_request_rec;
4256: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);

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

4249:
4250: EXCEPTION
4251:
4252: WHEN FND_API.G_EXC_ERROR THEN
4253: l_request_rec.return_status := FND_API.G_RET_STS_ERROR;
4254: l_request_rec.processed := 'Y';
4255: p_x_request_tbl(i):= l_request_rec;
4256: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4257:

Line 4258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4254: l_request_rec.processed := 'Y';
4255: p_x_request_tbl(i):= l_request_rec;
4256: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4257:
4258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4259: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4260: l_request_rec.processed := 'Y';
4261: p_x_request_tbl(i):= l_request_rec;
4262: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);

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

4255: p_x_request_tbl(i):= l_request_rec;
4256: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4257:
4258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4259: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4260: l_request_rec.processed := 'Y';
4261: p_x_request_tbl(i):= l_request_rec;
4262: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4259: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4260: l_request_rec.processed := 'Y';
4261: p_x_request_tbl(i):= l_request_rec;
4262: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4264:
4265:
4266: WHEN OTHERS THEN
4267: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4264:
4265:
4266: WHEN OTHERS THEN
4267: l_request_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4268: l_request_rec.processed := 'Y';
4269: p_x_request_tbl(i) := l_request_rec;
4270:
4271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4276: );
4277: END IF;
4278:
4279: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4281:
4282: END;
4283: <> -- Label for requests that do not need to be processed
4284: null;

Line 4299: WHEN FND_API.G_EXC_ERROR THEN

4295: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4296:
4297: EXCEPTION
4298:
4299: WHEN FND_API.G_EXC_ERROR THEN
4300: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4301: RAISE;
4302:
4303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4299: WHEN FND_API.G_EXC_ERROR THEN
4300: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4301: RAISE;
4302:
4303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4304: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4305: RAISE;
4306:
4307: WHEN OTHERS THEN

Line 4318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4314: );
4315: END IF;
4316:
4317: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4319:
4320: END Process_Order_Actions;
4321:
4322: -- delete_against defaulting to TRUE to prevent delete

Line 4345: x_return_status := FND_API.G_RET_STS_SUCCESS;

4341: BEGIN
4342:
4343:
4344:
4345: x_return_status := FND_API.G_RET_STS_SUCCESS;
4346: IF l_debug_level > 0 THEN
4347: oe_debug_pub.add('In Delete_Reqs_for_Deleted_Entity');
4348: oe_debug_pub.add('p_entity_code/p_entity_id' ||
4349: p_entity_code || '/' || p_entity_id);

Line 4465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4461: IF l_debug_level > 0 THEN
4462: oe_debug_pub.add('reset versioning globals');
4463: END IF;
4464: IF (NOT OE_Versioning_Util.Reset_Globals) THEN
4465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4466: END IF;
4467: END IF;
4468: G_Delayed_Requests.Delete(req_ind);
4469: END IF;

Line 4480: WHEN FND_API.G_EXC_ERROR THEN

4476: END IF;
4477:
4478: EXCEPTION
4479:
4480: WHEN FND_API.G_EXC_ERROR THEN
4481:
4482: x_return_status := FND_API.G_RET_STS_ERROR;
4483:
4484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4482: x_return_status := FND_API.G_RET_STS_ERROR;

4478: EXCEPTION
4479:
4480: WHEN FND_API.G_EXC_ERROR THEN
4481:
4482: x_return_status := FND_API.G_RET_STS_ERROR;
4483:
4484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4485:
4486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4480: WHEN FND_API.G_EXC_ERROR THEN
4481:
4482: x_return_status := FND_API.G_RET_STS_ERROR;
4483:
4484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4485:
4486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4487:
4488: when others THEN

Line 4486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4482: x_return_status := FND_API.G_RET_STS_ERROR;
4483:
4484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4485:
4486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4487:
4488: when others THEN
4489:
4490: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 4496: x_return_status := FND_API.G_RET_STS_ERROR;

4492: (G_PKG_NAME
4493: ,'Delete_Reqs_for_Deleted_Entity');
4494: END IF;
4495:
4496: x_return_status := FND_API.G_RET_STS_ERROR;
4497:
4498: End Delete_Reqs_for_Deleted_Entity;
4499:
4500:

Line 4524: x_return_status := FND_API.G_RET_STS_SUCCESS;

4520: IF l_debug_level > 0 THEN
4521: oe_debug_pub.add('sch request '|| p_request_rec.request_type, 1);
4522: END IF;
4523:
4524: x_return_status := FND_API.G_RET_STS_SUCCESS;
4525:
4526: IF p_request_rec.request_type = OE_GLOBALS.G_SCHEDULE_ATO THEN
4527: IF l_debug_level > 0 THEN
4528: oe_debug_pub.add('.. schedule_ato '|| p_request_rec.entity_id, 1);

Line 4695: IF l_request_search_rslt1 = FND_API.G_TRUE THEN

4691: p_request_rec.request_unique_key5,
4692: l_request_ind,
4693: l_request_search_rslt1,
4694: l_return_status);
4695: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
4696: -- no need to log request with BATCH and Y if
4697: -- 'BATCH,BOOK' and N already exists.
4698: x_log_request := 'N';
4699: return;

Line 4728: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4724: l_return_status);
4725:
4726: END IF;
4727:
4728: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4730: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4731: RAISE FND_API.G_EXC_ERROR;
4732: END IF;

Line 4729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4725:
4726: END IF;
4727:
4728: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4730: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4731: RAISE FND_API.G_EXC_ERROR;
4732: END IF;
4733:

Line 4730: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4726: END IF;
4727:
4728: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4730: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4731: RAISE FND_API.G_EXC_ERROR;
4732: END IF;
4733:
4734: IF l_request_search_rslt1 = FND_API.G_TRUE THEN

Line 4731: RAISE FND_API.G_EXC_ERROR;

4727:
4728: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4730: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4731: RAISE FND_API.G_EXC_ERROR;
4732: END IF;
4733:
4734: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
4735: -- no need to log request with BATCH and Y if BATCH

Line 4734: IF l_request_search_rslt1 = FND_API.G_TRUE THEN

4730: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4731: RAISE FND_API.G_EXC_ERROR;
4732: END IF;
4733:
4734: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
4735: -- no need to log request with BATCH and Y if BATCH
4736: -- and N already exists.
4737: IF l_debug_level > 0 THEN
4738: oe_debug_pub.add('there already exists BATCH + N so no need to log pricing request.', 3);

Line 4773: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4769:
4770: END IF;
4771:
4772:
4773: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4775: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4776: RAISE FND_API.G_EXC_ERROR;
4777: END IF;

Line 4774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4770: END IF;
4771:
4772:
4773: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4775: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4776: RAISE FND_API.G_EXC_ERROR;
4777: END IF;
4778:

Line 4775: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4771:
4772:
4773: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4775: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4776: RAISE FND_API.G_EXC_ERROR;
4777: END IF;
4778:
4779: IF l_request_search_rslt2 = FND_API.G_TRUE THEN

Line 4776: RAISE FND_API.G_EXC_ERROR;

4772:
4773: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4775: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4776: RAISE FND_API.G_EXC_ERROR;
4777: END IF;
4778:
4779: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
4780: -- check if there already exists request with

Line 4779: IF l_request_search_rslt2 = FND_API.G_TRUE THEN

4775: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4776: RAISE FND_API.G_EXC_ERROR;
4777: END IF;
4778:
4779: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
4780: -- check if there already exists request with
4781: -- pricing event 'LINE' with get_freight_flag = 'Y'.
4782: -- If exists, do nothing.
4783: IF l_debug_level > 0 THEN

Line 4797: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4793: p_request_rec.request_unique_key5,
4794: l_request_ind,
4795: l_request_search_rslt3,
4796: l_return_status);
4797: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4799: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4800: RAISE FND_API.G_EXC_ERROR;
4801: END IF;

Line 4798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4794: l_request_ind,
4795: l_request_search_rslt3,
4796: l_return_status);
4797: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4799: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4800: RAISE FND_API.G_EXC_ERROR;
4801: END IF;
4802:

Line 4799: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4795: l_request_search_rslt3,
4796: l_return_status);
4797: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4799: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4800: RAISE FND_API.G_EXC_ERROR;
4801: END IF;
4802:
4803: IF l_request_search_rslt3 = FND_API.G_TRUE THEN

Line 4800: RAISE FND_API.G_EXC_ERROR;

4796: l_return_status);
4797: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4799: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4800: RAISE FND_API.G_EXC_ERROR;
4801: END IF;
4802:
4803: IF l_request_search_rslt3 = FND_API.G_TRUE THEN
4804: -- If not exists, replace BATCH event with LINE event

Line 4803: IF l_request_search_rslt3 = FND_API.G_TRUE THEN

4799: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4800: RAISE FND_API.G_EXC_ERROR;
4801: END IF;
4802:
4803: IF l_request_search_rslt3 = FND_API.G_TRUE THEN
4804: -- If not exists, replace BATCH event with LINE event
4805: -- since request with 'ORDER' event already exists.
4806: IF l_debug_level > 0 THEN
4807: oe_debug_pub.add('there exists LINE + Y and ORDER + N so no need to log request for BATCH + Y.', 3);

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

4807: oe_debug_pub.add('there exists LINE + Y and ORDER + N so no need to log request for BATCH + Y.', 3);
4808: END IF;
4809: x_log_request := 'N';
4810: ELSE
4811: -- if l_request_search_rslt3 = FND_API.G_FALSE THEN
4812: -- check for LINE and N.
4813: Check_For_Request(p_request_rec.entity_code,
4814: p_request_rec.entity_id,
4815: p_request_rec.request_type,

Line 4824: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4820: p_request_rec.request_unique_key5,
4821: l_request_ind,
4822: l_request_search_rslt4,
4823: l_return_status);
4824: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4826: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4827: RAISE FND_API.G_EXC_ERROR;
4828: END IF;

Line 4825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4821: l_request_ind,
4822: l_request_search_rslt4,
4823: l_return_status);
4824: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4826: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4827: RAISE FND_API.G_EXC_ERROR;
4828: END IF;
4829:

Line 4826: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4822: l_request_search_rslt4,
4823: l_return_status);
4824: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4826: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4827: RAISE FND_API.G_EXC_ERROR;
4828: END IF;
4829:
4830:

Line 4827: RAISE FND_API.G_EXC_ERROR;

4823: l_return_status);
4824: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4826: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4827: RAISE FND_API.G_EXC_ERROR;
4828: END IF;
4829:
4830:
4831: IF l_request_search_rslt4 = FND_API.G_TRUE THEN

Line 4831: IF l_request_search_rslt4 = FND_API.G_TRUE THEN

4827: RAISE FND_API.G_EXC_ERROR;
4828: END IF;
4829:
4830:
4831: IF l_request_search_rslt4 = FND_API.G_TRUE THEN
4832: -- if already exists request with LINE and N.
4833: IF l_debug_level > 0 THEN
4834: oe_debug_pub.add('there exists LINE + N and ORDER + N so no need to log request for BATCH + Y.', 3);
4835: END IF;

Line 4868: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4864: l_request_ind,
4865: l_request_search_rslt1,
4866: l_return_status);
4867:
4868: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4870: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4871: RAISE FND_API.G_EXC_ERROR;
4872: END IF;

Line 4869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4865: l_request_search_rslt1,
4866: l_return_status);
4867:
4868: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4870: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4871: RAISE FND_API.G_EXC_ERROR;
4872: END IF;
4873:

Line 4870: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4866: l_return_status);
4867:
4868: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4870: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4871: RAISE FND_API.G_EXC_ERROR;
4872: END IF;
4873:
4874: IF l_request_search_rslt1 = FND_API.G_TRUE THEN

Line 4871: RAISE FND_API.G_EXC_ERROR;

4867:
4868: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4870: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4871: RAISE FND_API.G_EXC_ERROR;
4872: END IF;
4873:
4874: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
4875: -- if l_request_search_rslt1 = FND_API.G_TRUE

Line 4874: IF l_request_search_rslt1 = FND_API.G_TRUE THEN

4870: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4871: RAISE FND_API.G_EXC_ERROR;
4872: END IF;
4873:
4874: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
4875: -- if l_request_search_rslt1 = FND_API.G_TRUE
4876: -- request with event 'BATCH' and get_freight_flag ='N'
4877: -- exists, don't need to log request.
4878: IF l_debug_level > 0 THEN

Line 4875: -- if l_request_search_rslt1 = FND_API.G_TRUE

4871: RAISE FND_API.G_EXC_ERROR;
4872: END IF;
4873:
4874: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
4875: -- if l_request_search_rslt1 = FND_API.G_TRUE
4876: -- request with event 'BATCH' and get_freight_flag ='N'
4877: -- exists, don't need to log request.
4878: IF l_debug_level > 0 THEN
4879: oe_debug_pub.add('there exists BATCH + N so no need to log request.', 3);

Line 4883: -- if l_request_search_rslt1 = FND_API.G_FALSE

4879: oe_debug_pub.add('there exists BATCH + N so no need to log request.', 3);
4880: END IF;
4881: x_log_request := 'N';
4882: ELSE
4883: -- if l_request_search_rslt1 = FND_API.G_FALSE
4884: -- request with event 'BATCH' and get_freight_flag ='N'
4885: -- does not exist.
4886: Check_For_Request(p_request_rec.entity_code,
4887: p_request_rec.entity_id,

Line 4897: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4893: p_request_rec.request_unique_key5,
4894: l_request_ind,
4895: l_request_search_rslt2,
4896: l_return_status);
4897: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4899: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4900: RAISE FND_API.G_EXC_ERROR;
4901: END IF;

Line 4898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4894: l_request_ind,
4895: l_request_search_rslt2,
4896: l_return_status);
4897: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4899: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4900: RAISE FND_API.G_EXC_ERROR;
4901: END IF;
4902:

Line 4899: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4895: l_request_search_rslt2,
4896: l_return_status);
4897: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4899: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4900: RAISE FND_API.G_EXC_ERROR;
4901: END IF;
4902:
4903: IF l_request_search_rslt2 = FND_API.G_TRUE THEN

Line 4900: RAISE FND_API.G_EXC_ERROR;

4896: l_return_status);
4897: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4899: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4900: RAISE FND_API.G_EXC_ERROR;
4901: END IF;
4902:
4903: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
4904:

Line 4903: IF l_request_search_rslt2 = FND_API.G_TRUE THEN

4899: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4900: RAISE FND_API.G_EXC_ERROR;
4901: END IF;
4902:
4903: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
4904:
4905: -- there exists request with BATCH+Y already.
4906: -- need to delete BATCH+Y, log the current request which is
4907: -- ORDER+N and log an additional request LINE+Y.

Line 4979: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4975: l_request_ind,
4976: l_request_search_rslt1,
4977: l_return_status);
4978:
4979: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4981: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4982: RAISE FND_API.G_EXC_ERROR;
4983: END IF;

Line 4980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4976: l_request_search_rslt1,
4977: l_return_status);
4978:
4979: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4981: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4982: RAISE FND_API.G_EXC_ERROR;
4983: END IF;
4984:

Line 4981: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4977: l_return_status);
4978:
4979: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4981: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4982: RAISE FND_API.G_EXC_ERROR;
4983: END IF;
4984:
4985: IF l_request_search_rslt1 = FND_API.G_TRUE THEN

Line 4982: RAISE FND_API.G_EXC_ERROR;

4978:
4979: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4981: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4982: RAISE FND_API.G_EXC_ERROR;
4983: END IF;
4984:
4985: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
4986: -- request with event 'BATCH' and get_freight_flag ='N'

Line 4985: IF l_request_search_rslt1 = FND_API.G_TRUE THEN

4981: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4982: RAISE FND_API.G_EXC_ERROR;
4983: END IF;
4984:
4985: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
4986: -- request with event 'BATCH' and get_freight_flag ='N'
4987: -- already exists, no need to log request.
4988: IF l_debug_level > 0 THEN
4989: oe_debug_pub.add('there exists BATCH + N so no need to log request.', 3);

Line 4993: -- l_request_search_rslt1 = FND_API.G_FALSE

4989: oe_debug_pub.add('there exists BATCH + N so no need to log request.', 3);
4990: END IF;
4991: x_log_request := 'N';
4992: ELSE
4993: -- l_request_search_rslt1 = FND_API.G_FALSE
4994: -- request with event 'BATCH' and get_freight_flag ='N'
4995: -- does not exist.
4996: Check_For_Request(p_request_rec.entity_code,
4997: p_request_rec.entity_id,

Line 5007: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5003: p_request_rec.request_unique_key5,
5004: l_request_ind,
5005: l_request_search_rslt2,
5006: l_return_status);
5007: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5009: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5010: RAISE FND_API.G_EXC_ERROR;
5011: END IF;

Line 5008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5004: l_request_ind,
5005: l_request_search_rslt2,
5006: l_return_status);
5007: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5009: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5010: RAISE FND_API.G_EXC_ERROR;
5011: END IF;
5012:

Line 5009: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5005: l_request_search_rslt2,
5006: l_return_status);
5007: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5009: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5010: RAISE FND_API.G_EXC_ERROR;
5011: END IF;
5012:
5013: IF l_request_search_rslt2 = FND_API.G_TRUE THEN

Line 5010: RAISE FND_API.G_EXC_ERROR;

5006: l_return_status);
5007: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5009: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5010: RAISE FND_API.G_EXC_ERROR;
5011: END IF;
5012:
5013: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
5014:

Line 5013: IF l_request_search_rslt2 = FND_API.G_TRUE THEN

5009: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5010: RAISE FND_API.G_EXC_ERROR;
5011: END IF;
5012:
5013: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
5014:
5015: -- there exists request with BATCH,BOOK+Y already.
5016: -- need to delete BATCH,BOOK+Y, log the current request which is
5017: -- ORDER,BOOK+N and log an additional request LINE+Y.

Line 5062: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5058: p_request_rec.request_unique_key5,
5059: l_request_ind,
5060: l_request_search_rslt1,
5061: l_return_status);
5062: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5064: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5065: RAISE FND_API.G_EXC_ERROR;
5066: END IF;

Line 5063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5059: l_request_ind,
5060: l_request_search_rslt1,
5061: l_return_status);
5062: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5064: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5065: RAISE FND_API.G_EXC_ERROR;
5066: END IF;
5067:

Line 5064: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5060: l_request_search_rslt1,
5061: l_return_status);
5062: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5064: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5065: RAISE FND_API.G_EXC_ERROR;
5066: END IF;
5067:
5068: IF l_request_search_rslt1 = FND_API.G_TRUE THEN

Line 5065: RAISE FND_API.G_EXC_ERROR;

5061: l_return_status);
5062: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5064: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5065: RAISE FND_API.G_EXC_ERROR;
5066: END IF;
5067:
5068: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
5069: IF l_debug_level > 0 THEN

Line 5068: IF l_request_search_rslt1 = FND_API.G_TRUE THEN

5064: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5065: RAISE FND_API.G_EXC_ERROR;
5066: END IF;
5067:
5068: IF l_request_search_rslt1 = FND_API.G_TRUE THEN
5069: IF l_debug_level > 0 THEN
5070: oe_debug_pub.add('there exists BATCH + N so no need to log request.', 3);
5071: END IF;
5072: x_log_request := 'N';

Line 5088: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5084: p_request_rec.request_unique_key5,
5085: l_request_ind,
5086: l_request_search_rslt2,
5087: l_return_status);
5088: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5090: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5091: RAISE FND_API.G_EXC_ERROR;
5092: END IF;

Line 5089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5085: l_request_ind,
5086: l_request_search_rslt2,
5087: l_return_status);
5088: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5090: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5091: RAISE FND_API.G_EXC_ERROR;
5092: END IF;
5093: IF l_request_search_rslt2 = FND_API.G_TRUE THEN

Line 5090: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5086: l_request_search_rslt2,
5087: l_return_status);
5088: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5090: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5091: RAISE FND_API.G_EXC_ERROR;
5092: END IF;
5093: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
5094: IF l_debug_level > 0 THEN

Line 5091: RAISE FND_API.G_EXC_ERROR;

5087: l_return_status);
5088: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5090: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5091: RAISE FND_API.G_EXC_ERROR;
5092: END IF;
5093: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
5094: IF l_debug_level > 0 THEN
5095: oe_debug_pub.add('there exists BATCH,BOOK + N so no need to log request.', 3);

Line 5093: IF l_request_search_rslt2 = FND_API.G_TRUE THEN

5089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5090: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5091: RAISE FND_API.G_EXC_ERROR;
5092: END IF;
5093: IF l_request_search_rslt2 = FND_API.G_TRUE THEN
5094: IF l_debug_level > 0 THEN
5095: oe_debug_pub.add('there exists BATCH,BOOK + N so no need to log request.', 3);
5096: END IF;
5097: x_log_request := 'N';