DBA Data[Home] [Help]

APPS.PO_VENDORS_GRP dependencies on FND_API

Line 36: -- FND_API.G_RET_STS_ERROR - for expected error

32: -- Message count
33: --x_msg_data
34: -- message data
35: --x_return_status
36: -- FND_API.G_RET_STS_ERROR - for expected error
37: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
38: -- FND_API.G_RET_STS_SUCCESS - for success
39: --x_external_user_tbl
40: -- PL/SQL table of supplier user names

Line 37: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

33: --x_msg_data
34: -- message data
35: --x_return_status
36: -- FND_API.G_RET_STS_ERROR - for expected error
37: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
38: -- FND_API.G_RET_STS_SUCCESS - for success
39: --x_external_user_tbl
40: -- PL/SQL table of supplier user names
41: --Notes:

Line 38: -- FND_API.G_RET_STS_SUCCESS - for success

34: -- message data
35: --x_return_status
36: -- FND_API.G_RET_STS_ERROR - for expected error
37: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
38: -- FND_API.G_RET_STS_SUCCESS - for success
39: --x_external_user_tbl
40: -- PL/SQL table of supplier user names
41: --Notes:
42: -- SAHEGDE 07/18/2003

Line 55: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

51: -------------------------------------------------------------------------------
52:
53: PROCEDURE get_external_userlist
54: (p_api_version IN NUMBER
55: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
56: ,p_document_id IN NUMBER
57: ,p_document_type IN VARCHAR2
58: ,p_external_contact_id IN NUMBER DEFAULT NULL
59: ,x_return_status OUT NOCOPY VARCHAR2

Line 78: IF NOT (FND_API.compatible_api_call(l_api_version

74:
75:
76: BEGIN
77:
78: IF NOT (FND_API.compatible_api_call(l_api_version
79: ,p_api_version
80: ,l_api_name
81: ,g_pkg_name)) THEN
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

78: IF NOT (FND_API.compatible_api_call(l_api_version
79: ,p_api_version
80: ,l_api_name
81: ,g_pkg_name)) THEN
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83: END IF;
84:
85: -- initialize API return status to success
86: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 86: x_return_status:= FND_API.G_RET_STS_SUCCESS;

82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83: END IF;
84:
85: -- initialize API return status to success
86: x_return_status:= FND_API.G_RET_STS_SUCCESS;
87:
88: -- initialize meesage list
89: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
90: FND_MSG_PUB.initialize;

Line 89: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

85: -- initialize API return status to success
86: x_return_status:= FND_API.G_RET_STS_SUCCESS;
87:
88: -- initialize meesage list
89: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
90: FND_MSG_PUB.initialize;
91: END IF;
92:
93:

Line 114: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

110: ,x_num_users => l_num_users
111: ,x_vendor_id => l_vendor_id);
112:
113:
114: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: END IF;
117:
118: -- populate the out parameter.

Line 115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

111: ,x_vendor_id => l_vendor_id);
112:
113:
114: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: END IF;
117:
118: -- populate the out parameter.
119: x_external_user_tbl := l_external_user_tbl;

Line 122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

118: -- populate the out parameter.
119: x_external_user_tbl := l_external_user_tbl;
120:
121: EXCEPTION
122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
125: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
126: IF (g_fnd_debug='Y') THEN

Line 123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

119: x_external_user_tbl := l_external_user_tbl;
120:
121: EXCEPTION
122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
125: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
126: IF (g_fnd_debug='Y') THEN
127: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 137: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

133: END IF;
134: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
135: ,p_data => x_msg_data);
136: WHEN OTHERS THEN
137: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
139: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
140: IF (g_fnd_debug='Y') THEN
141: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 185: -- FND_API.G_RET_STS_ERROR - for expected error

181: -- Message count
182: --x_msg_data
183: -- message data
184: --x_return_status
185: -- FND_API.G_RET_STS_ERROR - for expected error
186: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
187: -- FND_API.G_RET_STS_SUCCESS - for success
188: --x_external_user_tbl
189: -- PL/SQL table of supplier user names

Line 186: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

182: --x_msg_data
183: -- message data
184: --x_return_status
185: -- FND_API.G_RET_STS_ERROR - for expected error
186: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
187: -- FND_API.G_RET_STS_SUCCESS - for success
188: --x_external_user_tbl
189: -- PL/SQL table of supplier user names
190: --x_supplier_userlist

Line 187: -- FND_API.G_RET_STS_SUCCESS - for success

183: -- message data
184: --x_return_status
185: -- FND_API.G_RET_STS_ERROR - for expected error
186: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
187: -- FND_API.G_RET_STS_SUCCESS - for success
188: --x_external_user_tbl
189: -- PL/SQL table of supplier user names
190: --x_supplier_userlist
191: -- space delimited user list

Line 212: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

208: -------------------------------------------------------------------------------
209:
210: PROCEDURE get_external_userlist
211: (p_api_version IN NUMBER
212: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
213: ,p_document_id IN NUMBER
214: ,p_document_type IN VARCHAR2
215: ,p_external_contact_id IN NUMBER DEFAULT NULL
216: ,x_return_status OUT NOCOPY VARCHAR2

Line 239: IF NOT (FND_API.compatible_api_call(l_api_version

235:
236:
237: BEGIN
238:
239: IF NOT (FND_API.compatible_api_call(l_api_version
240: ,p_api_version
241: ,l_api_name
242: ,g_pkg_name)) THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

239: IF NOT (FND_API.compatible_api_call(l_api_version
240: ,p_api_version
241: ,l_api_name
242: ,g_pkg_name)) THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245:
246: -- initialize API return status to success
247: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 247: x_return_status:= FND_API.G_RET_STS_SUCCESS;

243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245:
246: -- initialize API return status to success
247: x_return_status:= FND_API.G_RET_STS_SUCCESS;
248:
249: -- initialize meesage list
250: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
251: FND_MSG_PUB.initialize;

Line 250: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

246: -- initialize API return status to success
247: x_return_status:= FND_API.G_RET_STS_SUCCESS;
248:
249: -- initialize meesage list
250: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
251: FND_MSG_PUB.initialize;
252: END IF;
253:
254: -- parse doc type if contracts document type

Line 274: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

270: ,x_num_users => l_num_users
271: ,x_vendor_id => l_vendor_id);
272:
273:
274: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277:
278: -- populate the out parameter.

Line 275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

271: ,x_vendor_id => l_vendor_id);
272:
273:
274: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277:
278: -- populate the out parameter.
279: x_external_user_tbl := l_external_user_tbl;

Line 286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

282: x_num_users := l_num_users;
283: x_vendor_id := l_vendor_id;
284:
285: EXCEPTION
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
289: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
290: IF (g_fnd_debug='Y') THEN

Line 287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

283: x_vendor_id := l_vendor_id;
284:
285: EXCEPTION
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
289: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
290: IF (g_fnd_debug='Y') THEN
291: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 301: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

297: END IF;
298: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count
299: ,p_data => x_msg_data);
300: WHEN OTHERS THEN
301: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
303: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
304: IF (g_fnd_debug='Y') THEN
305: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN