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.

[Home] [Help]

APPS.ASO_PA_APR_PUB dependencies on FND_API

Line 9: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asoppapb.pls';
6:
7: PROCEDURE get_all_approvers (
8: p_api_version_number IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
10: p_commit IN VARCHAR2 := fnd_api.g_false,
11: p_object_id IN NUMBER,
12: p_object_type IN VARCHAR2,
13: p_application_id IN NUMBER,

Line 10: p_commit IN VARCHAR2 := fnd_api.g_false,

6:
7: PROCEDURE get_all_approvers (
8: p_api_version_number IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
10: p_commit IN VARCHAR2 := fnd_api.g_false,
11: p_object_id IN NUMBER,
12: p_object_type IN VARCHAR2,
13: p_application_id IN NUMBER,
14: p_object_approval_id IN NUMBER,

Line 15: p_clear_transaction_flag IN VARCHAR2 := fnd_api.g_false,

11: p_object_id IN NUMBER,
12: p_object_type IN VARCHAR2,
13: p_application_id IN NUMBER,
14: p_object_approval_id IN NUMBER,
15: p_clear_transaction_flag IN VARCHAR2 := fnd_api.g_false,
16: p_data_flag IN VARCHAR2 :='Y',
17: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
18: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
19: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 50: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

46: x_return_status => x_return_status,
47: x_msg_count => x_msg_count,
48: x_msg_data => x_msg_data );
49:
50: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
51: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
52: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
53: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.get_all_approvers_PRE', FALSE);
54: FND_MSG_PUB.ADD;

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

52: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
53: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.get_all_approvers_PRE', FALSE);
54: FND_MSG_PUB.ADD;
55: END IF;
56: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
58: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
59: RAISE FND_API.G_EXC_ERROR;
60: END IF;

Line 57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

53: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.get_all_approvers_PRE', FALSE);
54: FND_MSG_PUB.ADD;
55: END IF;
56: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
58: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
59: RAISE FND_API.G_EXC_ERROR;
60: END IF;
61: END IF;

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

54: FND_MSG_PUB.ADD;
55: END IF;
56: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
58: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
59: RAISE FND_API.G_EXC_ERROR;
60: END IF;
61: END IF;
62: END IF; -- customer hook

Line 59: RAISE FND_API.G_EXC_ERROR;

55: END IF;
56: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
58: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
59: RAISE FND_API.G_EXC_ERROR;
60: END IF;
61: END IF;
62: END IF; -- customer hook
63:

Line 75: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

71: x_return_status => x_return_status,
72: x_msg_count => x_msg_count,
73: x_msg_data => x_msg_data );
74:
75: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
76: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
77: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
78: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.get_all_approvers_PRE', FALSE);
79: FND_MSG_PUB.ADD;

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

77: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
78: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.get_all_approvers_PRE', FALSE);
79: FND_MSG_PUB.ADD;
80: END IF;
81: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
84: RAISE FND_API.G_EXC_ERROR;
85: END IF;

Line 82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

78: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.get_all_approvers_PRE', FALSE);
79: FND_MSG_PUB.ADD;
80: END IF;
81: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
84: RAISE FND_API.G_EXC_ERROR;
85: END IF;
86: END IF;

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

79: FND_MSG_PUB.ADD;
80: END IF;
81: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
84: RAISE FND_API.G_EXC_ERROR;
85: END IF;
86: END IF;
87: END IF; -- vertical hook

Line 84: RAISE FND_API.G_EXC_ERROR;

80: END IF;
81: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
84: RAISE FND_API.G_EXC_ERROR;
85: END IF;
86: END IF;
87: END IF; -- vertical hook
88:

Line 114: IF x_return_status = FND_API.G_RET_STS_ERROR then

110: );
111: END IF;
112:
113: -- Check return status from the above procedure call
114: IF x_return_status = FND_API.G_RET_STS_ERROR then
115: raise FND_API.G_EXC_ERROR;
116: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
117: raise FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;

Line 115: raise FND_API.G_EXC_ERROR;

111: END IF;
112:
113: -- Check return status from the above procedure call
114: IF x_return_status = FND_API.G_RET_STS_ERROR then
115: raise FND_API.G_EXC_ERROR;
116: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
117: raise FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:

Line 116: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

112:
113: -- Check return status from the above procedure call
114: IF x_return_status = FND_API.G_RET_STS_ERROR then
115: raise FND_API.G_EXC_ERROR;
116: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
117: raise FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:
120: -- Calling the POST hooks

Line 117: raise FND_API.G_EXC_UNEXPECTED_ERROR;

113: -- Check return status from the above procedure call
114: IF x_return_status = FND_API.G_RET_STS_ERROR then
115: raise FND_API.G_EXC_ERROR;
116: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
117: raise FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:
120: -- Calling the POST hooks
121:

Line 132: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

128: x_return_status => x_return_status,
129: x_msg_count => x_msg_count,
130: x_msg_data => x_msg_data );
131:
132: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
133: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
134: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
135: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.get_all_approvers_POST', FALSE);
136: FND_MSG_PUB.ADD;

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

134: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
135: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.get_all_approvers_POST', FALSE);
136: FND_MSG_PUB.ADD;
137: END IF;
138: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
141: RAISE FND_API.G_EXC_ERROR;
142: END IF;

Line 139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

135: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.get_all_approvers_POST', FALSE);
136: FND_MSG_PUB.ADD;
137: END IF;
138: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
141: RAISE FND_API.G_EXC_ERROR;
142: END IF;
143: END IF;

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

136: FND_MSG_PUB.ADD;
137: END IF;
138: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
141: RAISE FND_API.G_EXC_ERROR;
142: END IF;
143: END IF;
144: END IF; -- customer hook

Line 141: RAISE FND_API.G_EXC_ERROR;

137: END IF;
138: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
141: RAISE FND_API.G_EXC_ERROR;
142: END IF;
143: END IF;
144: END IF; -- customer hook
145:

Line 157: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

153: x_return_status => x_return_status,
154: x_msg_count => x_msg_count,
155: x_msg_data => x_msg_data );
156:
157: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
158: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
159: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
160: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.get_all_approvers_POST', FALSE);
161: FND_MSG_PUB.ADD;

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

159: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
160: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.get_all_approvers_POST', FALSE);
161: FND_MSG_PUB.ADD;
162: END IF;
163: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
166: RAISE FND_API.G_EXC_ERROR;
167: END IF;

Line 164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

160: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.get_all_approvers_POST', FALSE);
161: FND_MSG_PUB.ADD;
162: END IF;
163: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
166: RAISE FND_API.G_EXC_ERROR;
167: END IF;
168: END IF;

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

161: FND_MSG_PUB.ADD;
162: END IF;
163: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
166: RAISE FND_API.G_EXC_ERROR;
167: END IF;
168: END IF;
169: END IF; -- vertical hook

Line 166: RAISE FND_API.G_EXC_ERROR;

162: END IF;
163: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
166: RAISE FND_API.G_EXC_ERROR;
167: END IF;
168: END IF;
169: END IF; -- vertical hook
170:

Line 172: IF FND_API.to_Boolean( p_commit )

168: END IF;
169: END IF; -- vertical hook
170:
171: -- Standard check for p_commit
172: IF FND_API.to_Boolean( p_commit )
173: THEN
174: COMMIT WORK;
175: END IF;
176:

Line 192: WHEN FND_API.G_EXC_ERROR THEN

188: );
189: END IF;
190:
191: EXCEPTION
192: WHEN FND_API.G_EXC_ERROR THEN
193: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
194: P_API_NAME => L_API_NAME
195: ,P_PKG_NAME => G_PKG_NAME
196: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

198: ,X_MSG_COUNT => X_MSG_COUNT
199: ,X_MSG_DATA => X_MSG_DATA
200: ,X_RETURN_STATUS => X_RETURN_STATUS);
201:
202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
203: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
204: P_API_NAME => L_API_NAME
205: ,P_PKG_NAME => G_PKG_NAME
206: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 225: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

221: END get_all_approvers;
222:
223: PROCEDURE start_papproval_process (
224: p_api_version_number IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
226: p_commit IN VARCHAR2 := fnd_api.g_false,
227: p_object_id IN NUMBER,
228: p_object_type IN VARCHAR2,
229: p_application_id IN NUMBER,

Line 226: p_commit IN VARCHAR2 := fnd_api.g_false,

222:
223: PROCEDURE start_papproval_process (
224: p_api_version_number IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
226: p_commit IN VARCHAR2 := fnd_api.g_false,
227: p_object_id IN NUMBER,
228: p_object_type IN VARCHAR2,
229: p_application_id IN NUMBER,
230: --p_approver_sequence IN NUMBER := fnd_api.g_miss_num,

Line 230: --p_approver_sequence IN NUMBER := fnd_api.g_miss_num,

226: p_commit IN VARCHAR2 := fnd_api.g_false,
227: p_object_id IN NUMBER,
228: p_object_type IN VARCHAR2,
229: p_application_id IN NUMBER,
230: --p_approver_sequence IN NUMBER := fnd_api.g_miss_num,
231: p_requester_comments IN VARCHAR2,
232: p_del_appr_table IN approvers_list_tbl_type,
233: x_object_approval_id OUT NOCOPY NUMBER,
234: x_approval_instance_id OUT NOCOPY NUMBER,

Line 270: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

266: x_return_status => x_return_status,
267: x_msg_count => x_msg_count,
268: x_msg_data => x_msg_data);
269:
270: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
271: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
272: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
273: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.start_approval_process_PRE', FALSE);
274: FND_MSG_PUB.ADD;

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

272: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
273: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.start_approval_process_PRE', FALSE);
274: FND_MSG_PUB.ADD;
275: END IF;
276: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;

Line 277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

273: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.start_approval_process_PRE', FALSE);
274: FND_MSG_PUB.ADD;
275: END IF;
276: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281: END IF;

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

274: FND_MSG_PUB.ADD;
275: END IF;
276: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281: END IF;
282: END IF; -- customer hook

Line 279: RAISE FND_API.G_EXC_ERROR;

275: END IF;
276: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281: END IF;
282: END IF; -- customer hook
283:

Line 297: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

293: x_return_status => x_return_status,
294: x_msg_count => x_msg_count,
295: x_msg_data => x_msg_data);
296:
297: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
298: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
299: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
300: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.start_approval_process_PRE', FALSE);
301: FND_MSG_PUB.ADD;

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

299: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
300: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.start_approval_process_PRE', FALSE);
301: FND_MSG_PUB.ADD;
302: END IF;
303: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
306: RAISE FND_API.G_EXC_ERROR;
307: END IF;

Line 304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

300: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.start_approval_process_PRE', FALSE);
301: FND_MSG_PUB.ADD;
302: END IF;
303: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
306: RAISE FND_API.G_EXC_ERROR;
307: END IF;
308: END IF;

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

301: FND_MSG_PUB.ADD;
302: END IF;
303: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
306: RAISE FND_API.G_EXC_ERROR;
307: END IF;
308: END IF;
309: END IF; -- vertical hook

Line 306: RAISE FND_API.G_EXC_ERROR;

302: END IF;
303: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
306: RAISE FND_API.G_EXC_ERROR;
307: END IF;
308: END IF;
309: END IF; -- vertical hook
310:

Line 336: IF x_return_status = FND_API.G_RET_STS_ERROR then

332: END IF;
333:
334:
335: -- Check return status from the above procedure call
336: IF x_return_status = FND_API.G_RET_STS_ERROR then
337: raise FND_API.G_EXC_ERROR;
338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
339: raise FND_API.G_EXC_UNEXPECTED_ERROR;
340: END IF;

Line 337: raise FND_API.G_EXC_ERROR;

333:
334:
335: -- Check return status from the above procedure call
336: IF x_return_status = FND_API.G_RET_STS_ERROR then
337: raise FND_API.G_EXC_ERROR;
338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
339: raise FND_API.G_EXC_UNEXPECTED_ERROR;
340: END IF;
341:

Line 338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

334:
335: -- Check return status from the above procedure call
336: IF x_return_status = FND_API.G_RET_STS_ERROR then
337: raise FND_API.G_EXC_ERROR;
338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
339: raise FND_API.G_EXC_UNEXPECTED_ERROR;
340: END IF;
341:
342: -- Calling the POST hooks

Line 339: raise FND_API.G_EXC_UNEXPECTED_ERROR;

335: -- Check return status from the above procedure call
336: IF x_return_status = FND_API.G_RET_STS_ERROR then
337: raise FND_API.G_EXC_ERROR;
338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
339: raise FND_API.G_EXC_UNEXPECTED_ERROR;
340: END IF;
341:
342: -- Calling the POST hooks
343:

Line 356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

352: x_return_status => x_return_status,
353: x_msg_count => x_msg_count,
354: x_msg_data => x_msg_data);
355:
356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
357: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
358: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
359: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.start_approval_process_POST', FALSE);
360: FND_MSG_PUB.ADD;

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

358: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
359: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.start_approval_process_POST', FALSE);
360: FND_MSG_PUB.ADD;
361: END IF;
362: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;

Line 363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

359: FND_MESSAGE.Set_Token('API', 'ASO_APR_CUHK.start_approval_process_POST', FALSE);
360: FND_MSG_PUB.ADD;
361: END IF;
362: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;
367: END IF;

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

360: FND_MSG_PUB.ADD;
361: END IF;
362: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;
367: END IF;
368: END IF; -- customer hook

Line 365: RAISE FND_API.G_EXC_ERROR;

361: END IF;
362: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;
367: END IF;
368: END IF; -- customer hook
369:

Line 383: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

379: x_return_status => x_return_status,
380: x_msg_count => x_msg_count,
381: x_msg_data => x_msg_data);
382:
383: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
384: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
385: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
386: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.start_approval_process_POST', FALSE);
387: FND_MSG_PUB.ADD;

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

385: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
386: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.start_approval_process_POST', FALSE);
387: FND_MSG_PUB.ADD;
388: END IF;
389: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
391: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
392: RAISE FND_API.G_EXC_ERROR;
393: END IF;

Line 390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

386: FND_MESSAGE.Set_Token('API', 'ASO_APR_VUHK.start_approval_process_POST', FALSE);
387: FND_MSG_PUB.ADD;
388: END IF;
389: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
391: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
392: RAISE FND_API.G_EXC_ERROR;
393: END IF;
394: END IF;

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

387: FND_MSG_PUB.ADD;
388: END IF;
389: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
391: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
392: RAISE FND_API.G_EXC_ERROR;
393: END IF;
394: END IF;
395: END IF; -- vertical hook

Line 392: RAISE FND_API.G_EXC_ERROR;

388: END IF;
389: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
391: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
392: RAISE FND_API.G_EXC_ERROR;
393: END IF;
394: END IF;
395: END IF; -- vertical hook
396:

Line 398: IF FND_API.to_Boolean( p_commit )

394: END IF;
395: END IF; -- vertical hook
396:
397: -- Standard check for p_commit
398: IF FND_API.to_Boolean( p_commit )
399: THEN
400: COMMIT WORK;
401: END IF;
402:

Line 419: WHEN FND_API.G_EXC_ERROR THEN

415: END IF;
416:
417:
418: EXCEPTION
419: WHEN FND_API.G_EXC_ERROR THEN
420: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
421: P_API_NAME => L_API_NAME
422: ,P_PKG_NAME => G_PKG_NAME
423: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

425: ,X_MSG_COUNT => X_MSG_COUNT
426: ,X_MSG_DATA => X_MSG_DATA
427: ,X_RETURN_STATUS => X_RETURN_STATUS);
428:
429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
430: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
431: P_API_NAME => L_API_NAME
432: ,P_PKG_NAME => G_PKG_NAME
433: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 501: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

497: END cancel_approval_process;
498:
499: PROCEDURE start_pa_approval_workflow (
500: p_api_version_number IN NUMBER,
501: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
502: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
503: p_object_approval_id IN NUMBER,
504: p_itemtype IN VARCHAR2,
505: p_sender_name IN VARCHAR2,

Line 502: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

498:
499: PROCEDURE start_pa_approval_workflow (
500: p_api_version_number IN NUMBER,
501: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
502: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
503: p_object_approval_id IN NUMBER,
504: p_itemtype IN VARCHAR2,
505: p_sender_name IN VARCHAR2,
506: x_return_status OUT NOCOPY VARCHAR2,