DBA Data[Home] [Help]

APPS.PON_VENDOR_PURGE_GRP dependencies on FND_API

Line 23: x_return_status := fnd_api.g_ret_sts_unexp_error;

19: l_vendor_refs NUMBER;
20:
21: BEGIN
22: -- initialize return for unexpected error
23: x_return_status := fnd_api.g_ret_sts_unexp_error;
24:
25: -- Standard call to check for call compatibility.
26: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
27: l_api_name, l_api_name) THEN

Line 26: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

22: -- initialize return for unexpected error
23: x_return_status := fnd_api.g_ret_sts_unexp_error;
24:
25: -- Standard call to check for call compatibility.
26: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
27: l_api_name, l_api_name) THEN
28: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
29: END IF;
30:

Line 28: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

24:
25: -- Standard call to check for call compatibility.
26: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
27: l_api_name, l_api_name) THEN
28: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
29: END IF;
30:
31: -- Initialize message list if p_init_msg_list is set to TRUE.
32: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 32: IF FND_API.to_boolean(p_init_msg_list) THEN

28: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
29: END IF;
30:
31: -- Initialize message list if p_init_msg_list is set to TRUE.
32: IF FND_API.to_boolean(p_init_msg_list) THEN
33: FND_MSG_PUB.initialize();
34: END IF;
35:
36: select count(*)

Line 48: x_return_status := fnd_api.g_ret_sts_success;

44: 'pon.vendor_purge',
45: 'validation failed in pon_bid_headers');
46: end if;
47:
48: x_return_status := fnd_api.g_ret_sts_success;
49: return 'N';
50: end if;
51:
52: -- don't bother to check in pon_bid_item_prices

Line 66: x_return_status := fnd_api.g_ret_sts_success;

62: into l_vendor_refs
63: from pon_bidding_parties
64: where trading_partner_id = l_vendor_tp_id;
65:
66: x_return_status := fnd_api.g_ret_sts_success;
67:
68: if (l_vendor_refs > 0) then
69: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
70: fnd_log.string(fnd_log.level_statement,

Line 101: x_return_status := fnd_api.g_ret_sts_unexp_error;

97: l_vendor_refs NUMBER;
98:
99: BEGIN
100: -- initialize return for unexpected error
101: x_return_status := fnd_api.g_ret_sts_unexp_error;
102:
103: -- Standard call to check for call compatibility.
104: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
105: l_api_name, l_api_name) THEN

Line 104: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

100: -- initialize return for unexpected error
101: x_return_status := fnd_api.g_ret_sts_unexp_error;
102:
103: -- Standard call to check for call compatibility.
104: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
105: l_api_name, l_api_name) THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:

Line 106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

102:
103: -- Standard call to check for call compatibility.
104: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
105: l_api_name, l_api_name) THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:
109: -- Initialize message list if p_init_msg_list is set to TRUE.
110: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 110: IF FND_API.to_boolean(p_init_msg_list) THEN

106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:
109: -- Initialize message list if p_init_msg_list is set to TRUE.
110: IF FND_API.to_boolean(p_init_msg_list) THEN
111: FND_MSG_PUB.initialize();
112: END IF;
113:
114: -- since we never validate a vendor purge with a reference in sourcing,

Line 117: x_return_status := fnd_api.g_ret_sts_success;

113:
114: -- since we never validate a vendor purge with a reference in sourcing,
115: -- there is nothing to do here
116:
117: x_return_status := fnd_api.g_ret_sts_success;
118:
119: if (p_commit = fnd_api.g_true) then
120: commit;
121: end if;

Line 119: if (p_commit = fnd_api.g_true) then

115: -- there is nothing to do here
116:
117: x_return_status := fnd_api.g_ret_sts_success;
118:
119: if (p_commit = fnd_api.g_true) then
120: commit;
121: end if;
122:
123: end vendor_purge;