DBA Data[Home] [Help]

APPS.ASO_CREDIT_CHECK_PUB dependencies on FND_API

Line 17: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

13: --subha madapusi - quote credit check call.
14:
15: PROCEDURE CREDIT_CHECK(
16: P_API_VERSION IN NUMBER,
17: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
18: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
19: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
20: X_RESULT_OUT OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
21: X_CC_HOLD_COMMENT OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 18: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

14:
15: PROCEDURE CREDIT_CHECK(
16: P_API_VERSION IN NUMBER,
17: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
18: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
19: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
20: X_RESULT_OUT OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
21: X_CC_HOLD_COMMENT OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
22: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 36: IF NOT FND_API.Compatible_API_Call ( l_api_version,

32: -- Standard Start of API savepoint
33: SAVEPOINT Credit_Check_PUB;
34:
35: -- Standard call to check for call compatibility.
36: IF NOT FND_API.Compatible_API_Call ( l_api_version,
37: p_api_version,
38: l_api_name,
39: G_PKG_NAME)
40: THEN

Line 41: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

37: p_api_version,
38: l_api_name,
39: G_PKG_NAME)
40: THEN
41: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
42: END IF;
43:
44:
45: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 46: IF FND_API.to_Boolean( p_init_msg_list )

42: END IF;
43:
44:
45: -- Initialize message list if p_init_msg_list is set to TRUE.
46: IF FND_API.to_Boolean( p_init_msg_list )
47: THEN
48: FND_MSG_PUB.initialize;
49: END IF;
50:

Line 56: x_return_status := FND_API.G_RET_STS_SUCCESS;

52: -- Initializing Global Debug Variable.
53: aso_debug_pub.g_debug_flag := NVL(FND_PROFILE.VALUE('ASO_ENABLE_DEBUG'),'N');
54:
55: -- Initialize API return status to SUCCESS
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57:
58: --
59: -- API body
60: --

Line 73: P_INIT_MSG_LIST => FND_API.G_FALSE,

69:
70: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'B', 'C')) THEN
71: ASO_CREDIT_CHECK_CUHK.credit_check_PRE(
72: P_API_VERSION => 1.0,
73: P_INIT_MSG_LIST => FND_API.G_FALSE,
74: p_commit => FND_API.G_FALSE,
75: p_qte_header_rec => p_qte_header_rec,
76: X_RETURN_STATUS => x_return_status,
77: X_MSG_COUNT => x_msg_count,

Line 74: p_commit => FND_API.G_FALSE,

70: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'B', 'C')) THEN
71: ASO_CREDIT_CHECK_CUHK.credit_check_PRE(
72: P_API_VERSION => 1.0,
73: P_INIT_MSG_LIST => FND_API.G_FALSE,
74: p_commit => FND_API.G_FALSE,
75: p_qte_header_rec => p_qte_header_rec,
76: X_RETURN_STATUS => x_return_status,
77: X_MSG_COUNT => x_msg_count,
78: X_MSG_DATA => x_msg_data

Line 84: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

80: IF aso_debug_pub.g_debug_flag = 'Y' THEN
81: aso_debug_pub.add('Credit_Check_CUHK: after CREDIT_CHECK_CUHK Pre hook return_status: '||x_return_status, 1, 'Y');
82: END IF;
83:
84: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
85: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
86: FND_MESSAGE.Set_Name('ASO', 'ASO_ERROR_RETURNED');
87: FND_MESSAGE.Set_Token('PKG_NAME', 'ASO_CREDIT_CHECK_CUHK', FALSE);
88: FND_MESSAGE.Set_Token('API_NAME', 'Credit_Check_PRE', FALSE);

Line 91: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

87: FND_MESSAGE.Set_Token('PKG_NAME', 'ASO_CREDIT_CHECK_CUHK', FALSE);
88: FND_MESSAGE.Set_Token('API_NAME', 'Credit_Check_PRE', FALSE);
89: FND_MSG_PUB.ADD;
90: END IF;
91: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
94: RAISE FND_API.G_EXC_ERROR;
95: END IF;

Line 92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

88: FND_MESSAGE.Set_Token('API_NAME', 'Credit_Check_PRE', FALSE);
89: FND_MSG_PUB.ADD;
90: END IF;
91: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
94: RAISE FND_API.G_EXC_ERROR;
95: END IF;
96: END IF;

Line 93: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

89: FND_MSG_PUB.ADD;
90: END IF;
91: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
94: RAISE FND_API.G_EXC_ERROR;
95: END IF;
96: END IF;
97: END IF; -- customer hook

Line 94: RAISE FND_API.G_EXC_ERROR;

90: END IF;
91: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
94: RAISE FND_API.G_EXC_ERROR;
95: END IF;
96: END IF;
97: END IF; -- customer hook
98:

Line 107: P_INIT_MSG_LIST => FND_API.G_FALSE,

103:
104: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'B', 'V')) THEN
105: ASO_CREDIT_CHECK_VUHK.Credit_Check_PRE(
106: P_API_VERSION => 1.0,
107: P_INIT_MSG_LIST => FND_API.G_FALSE,
108: p_commit => FND_API.G_FALSE,
109: p_qte_header_rec => p_qte_header_rec,
110: X_RETURN_STATUS => x_return_status,
111: X_MSG_COUNT => x_msg_count,

Line 108: p_commit => FND_API.G_FALSE,

104: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'B', 'V')) THEN
105: ASO_CREDIT_CHECK_VUHK.Credit_Check_PRE(
106: P_API_VERSION => 1.0,
107: P_INIT_MSG_LIST => FND_API.G_FALSE,
108: p_commit => FND_API.G_FALSE,
109: p_qte_header_rec => p_qte_header_rec,
110: X_RETURN_STATUS => x_return_status,
111: X_MSG_COUNT => x_msg_count,
112: X_MSG_DATA => x_msg_data

Line 118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

114: IF aso_debug_pub.g_debug_flag = 'Y' THEN
115: aso_debug_pub.add('Credit_Check_VUHK: after CREDIT_CHECK_VUHK Pre hook return_status: '||x_return_status, 1, 'Y');
116: END IF;
117:
118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
120: FND_MESSAGE.Set_Name('ASO', 'ASO_ERROR_RETURNED');
121: FND_MESSAGE.Set_Token('PKG_NAME', 'ASO_CREDIT_CHECK_VUHK', FALSE);
122: FND_MESSAGE.Set_Token('API_NAME', 'Credit_Check_PRE', FALSE);

Line 125: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

121: FND_MESSAGE.Set_Token('PKG_NAME', 'ASO_CREDIT_CHECK_VUHK', FALSE);
122: FND_MESSAGE.Set_Token('API_NAME', 'Credit_Check_PRE', FALSE);
123: FND_MSG_PUB.ADD;
124: END IF;
125: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
128: RAISE FND_API.G_EXC_ERROR;
129: END IF;

Line 126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

122: FND_MESSAGE.Set_Token('API_NAME', 'Credit_Check_PRE', FALSE);
123: FND_MSG_PUB.ADD;
124: END IF;
125: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
128: RAISE FND_API.G_EXC_ERROR;
129: END IF;
130: END IF;

Line 127: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

123: FND_MSG_PUB.ADD;
124: END IF;
125: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
128: RAISE FND_API.G_EXC_ERROR;
129: END IF;
130: END IF;
131: END IF;

Line 128: RAISE FND_API.G_EXC_ERROR;

124: END IF;
125: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
128: RAISE FND_API.G_EXC_ERROR;
129: END IF;
130: END IF;
131: END IF;
132:

Line 140: P_INIT_MSG_LIST => FND_API.G_FALSE,

136: END IF;
137:
138: ASO_CREDIT_CHECK_PVT.CREDIT_CHECK(
139: P_API_VERSION => 1.0,
140: P_INIT_MSG_LIST => FND_API.G_FALSE,
141: p_commit => FND_API.G_FALSE,
142: p_qte_header_rec => p_qte_header_rec,
143: X_result_out => x_result_out,
144: X_cc_hold_comment => x_cc_hold_comment,

Line 141: p_commit => FND_API.G_FALSE,

137:
138: ASO_CREDIT_CHECK_PVT.CREDIT_CHECK(
139: P_API_VERSION => 1.0,
140: P_INIT_MSG_LIST => FND_API.G_FALSE,
141: p_commit => FND_API.G_FALSE,
142: p_qte_header_rec => p_qte_header_rec,
143: X_result_out => x_result_out,
144: X_cc_hold_comment => x_cc_hold_comment,
145: X_RETURN_STATUS => x_return_status,

Line 154: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

150: IF aso_debug_pub.g_debug_flag = 'Y' THEN
151: aso_debug_pub.add('Credit_Check_PUB: after CREDIT_CHECK return_status: '||x_return_status, 1, 'Y');
152: END IF;
153:
154: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;

Line 155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

151: aso_debug_pub.add('Credit_Check_PUB: after CREDIT_CHECK return_status: '||x_return_status, 1, 'Y');
152: END IF;
153:
154: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:

Line 156: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

152: END IF;
153:
154: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: -- call user hooks - Post Processing.

Line 157: RAISE FND_API.G_EXC_ERROR;

153:
154: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: -- call user hooks - Post Processing.
161:

Line 170: P_INIT_MSG_LIST => FND_API.G_FALSE,

166:
167: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C')) THEN
168: ASO_CREDIT_CHECK_CUHK.Credit_Check_POST(
169: P_API_VERSION => 1.0,
170: P_INIT_MSG_LIST => FND_API.G_FALSE,
171: p_commit => FND_API.G_FALSE,
172: p_qte_header_rec => p_qte_header_rec,
173: p_result_out => x_result_out,
174: p_cc_hold_comment => x_cc_hold_comment,

Line 171: p_commit => FND_API.G_FALSE,

167: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C')) THEN
168: ASO_CREDIT_CHECK_CUHK.Credit_Check_POST(
169: P_API_VERSION => 1.0,
170: P_INIT_MSG_LIST => FND_API.G_FALSE,
171: p_commit => FND_API.G_FALSE,
172: p_qte_header_rec => p_qte_header_rec,
173: p_result_out => x_result_out,
174: p_cc_hold_comment => x_cc_hold_comment,
175: X_RETURN_STATUS => x_return_status,

Line 183: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

179: IF aso_debug_pub.g_debug_flag = 'Y' THEN
180: aso_debug_pub.add('Credit_Check_CUHK: after CREDIT_CHECK_CUHK Post hook return_status: '||x_return_status, 1, 'Y');
181: END IF;
182:
183: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
184: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
185: FND_MESSAGE.Set_Name('ASO', 'ASO_ERROR_RETURNED');
186: FND_MESSAGE.Set_Token('PKG_NAME', 'ASO_CREDIT_CHECK_CUHK', FALSE);
187: FND_MESSAGE.Set_Token('API_NAME', 'Credit_Check_POST', FALSE);

Line 190: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

186: FND_MESSAGE.Set_Token('PKG_NAME', 'ASO_CREDIT_CHECK_CUHK', FALSE);
187: FND_MESSAGE.Set_Token('API_NAME', 'Credit_Check_POST', FALSE);
188: FND_MSG_PUB.ADD;
189: END IF;
190: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
193: RAISE FND_API.G_EXC_ERROR;
194: END IF;

Line 191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

187: FND_MESSAGE.Set_Token('API_NAME', 'Credit_Check_POST', FALSE);
188: FND_MSG_PUB.ADD;
189: END IF;
190: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
193: RAISE FND_API.G_EXC_ERROR;
194: END IF;
195: END IF;

Line 192: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

188: FND_MSG_PUB.ADD;
189: END IF;
190: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
193: RAISE FND_API.G_EXC_ERROR;
194: END IF;
195: END IF;
196: END IF; -- customer hook

Line 193: RAISE FND_API.G_EXC_ERROR;

189: END IF;
190: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
193: RAISE FND_API.G_EXC_ERROR;
194: END IF;
195: END IF;
196: END IF; -- customer hook
197:

Line 207: P_INIT_MSG_LIST => FND_API.G_FALSE,

203:
204: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
205: ASO_CREDIT_CHECK_VUHK.Credit_check_POST(
206: P_API_VERSION => 1.0,
207: P_INIT_MSG_LIST => FND_API.G_FALSE,
208: p_commit => FND_API.G_FALSE,
209: p_qte_header_rec => p_qte_header_rec,
210: p_result_out => x_result_out,
211: p_cc_hold_comment => x_cc_hold_comment,

Line 208: p_commit => FND_API.G_FALSE,

204: IF (JTF_USR_HKS.ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V')) THEN
205: ASO_CREDIT_CHECK_VUHK.Credit_check_POST(
206: P_API_VERSION => 1.0,
207: P_INIT_MSG_LIST => FND_API.G_FALSE,
208: p_commit => FND_API.G_FALSE,
209: p_qte_header_rec => p_qte_header_rec,
210: p_result_out => x_result_out,
211: p_cc_hold_comment => x_cc_hold_comment,
212: X_RETURN_STATUS => x_return_status,

Line 219: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

215: );
216: IF aso_debug_pub.g_debug_flag = 'Y' THEN
217: aso_debug_pub.add('Credit_Check_VUHK: after CREDIT_CHECK_VUHK Post hook return_status: '||x_return_status, 1, 'Y');
218: END IF;
219: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
220: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
221: FND_MESSAGE.Set_Name('ASO', 'ASO_ERROR_RETURNED');
222: FND_MESSAGE.Set_Token('PKG_NAME', 'ASO_CREDIT_CHECK_VUHK', FALSE);
223: FND_MESSAGE.Set_Token('API_NAME', 'Credit_check_POST', FALSE);

Line 226: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

222: FND_MESSAGE.Set_Token('PKG_NAME', 'ASO_CREDIT_CHECK_VUHK', FALSE);
223: FND_MESSAGE.Set_Token('API_NAME', 'Credit_check_POST', FALSE);
224: FND_MSG_PUB.ADD;
225: END IF;
226: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;

Line 227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

223: FND_MESSAGE.Set_Token('API_NAME', 'Credit_check_POST', FALSE);
224: FND_MSG_PUB.ADD;
225: END IF;
226: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;
231: END IF;

Line 228: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

224: FND_MSG_PUB.ADD;
225: END IF;
226: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;
231: END IF;
232: END IF; -- vertical hook

Line 229: RAISE FND_API.G_EXC_ERROR;

225: END IF;
226: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;
231: END IF;
232: END IF; -- vertical hook
233:

Line 238: IF FND_API.to_Boolean( p_commit )

234: -- End of API body.
235: --
236:
237: -- Standard check for p_commit
238: IF FND_API.to_Boolean( p_commit )
239: THEN
240: COMMIT WORK;
241: END IF;
242:

Line 253: WHEN FND_API.G_EXC_ERROR THEN

249: p_data => x_msg_data
250: );
251:
252: EXCEPTION
253: WHEN FND_API.G_EXC_ERROR THEN
254: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
255: P_API_NAME => L_API_NAME
256: ,P_PKG_NAME => G_PKG_NAME
257: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

261: ,X_MSG_COUNT => X_MSG_COUNT
262: ,X_MSG_DATA => X_MSG_DATA
263: ,X_RETURN_STATUS => X_RETURN_STATUS);
264:
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
267: P_API_NAME => L_API_NAME
268: ,P_PKG_NAME => G_PKG_NAME
269: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR