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.AS_SALES_LEAD_RANKS_PUB dependencies on FND_API

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

24: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
25: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
26:
27: PROCEDURE Create_Rank (p_api_version IN NUMBER := 2.0,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER :=
31: FND_API.G_VALID_LEVEL_FULL,
32: x_return_status OUT NOCOPY VARCHAR2,

Line 29: p_commit IN VARCHAR2 := FND_API.G_FALSE,

25: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
26:
27: PROCEDURE Create_Rank (p_api_version IN NUMBER := 2.0,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER :=
31: FND_API.G_VALID_LEVEL_FULL,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,

Line 31: FND_API.G_VALID_LEVEL_FULL,

27: PROCEDURE Create_Rank (p_api_version IN NUMBER := 2.0,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER :=
31: FND_API.G_VALID_LEVEL_FULL,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2,
35: p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type,

Line 55: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

51: -- Standard start of API savepoint
52: SAVEPOINT Create_Rank_PVT;
53:
54: -- Standard call to check for call compatibility
55: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE

Line 56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

52: SAVEPOINT Create_Rank_PVT;
53:
54: -- Standard call to check for call compatibility
55: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE
60: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 60: IF FND_API.To_Boolean(p_init_msg_list) THEN

56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE
60: IF FND_API.To_Boolean(p_init_msg_list) THEN
61: FND_MSG_PUB.initialize;
62: END IF;
63:
64: -- Initialize API return status to success

Line 65: x_return_status := FND_API.G_RET_STS_SUCCESS;

61: FND_MSG_PUB.initialize;
62: END IF;
63:
64: -- Initialize API return status to success
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: -- API body
68: l_sales_lead_rank_rec := p_sales_lead_rank_rec;
69: AS_SALES_LEAD_RANKS_PVT.Create_Rank (p_api_version => l_api_version,

Line 82: IF FND_API.To_Boolean(p_commit) THEN

78: --dbms_output.put_line('public API returns ' || l_return_status);
79: -- End of API body
80:
81: -- Standard check of p_commit
82: IF FND_API.To_Boolean(p_commit) THEN
83: COMMIT WORK;
84: END IF;
85:
86: -- Standard call to get message count and if count is 1, get message info

Line 90: WHEN FND_API.G_EXC_ERROR THEN

86: -- Standard call to get message count and if count is 1, get message info
87: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
88: EXCEPTION
89:
90: WHEN FND_API.G_EXC_ERROR THEN
91: ROLLBACK TO Create_Rank_PVT;
92: x_return_status := FND_API.G_RET_STS_ERROR;
93: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
94:

Line 92: x_return_status := FND_API.G_RET_STS_ERROR;

88: EXCEPTION
89:
90: WHEN FND_API.G_EXC_ERROR THEN
91: ROLLBACK TO Create_Rank_PVT;
92: x_return_status := FND_API.G_RET_STS_ERROR;
93: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
94:
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96: ROLLBACK TO Create_Rank_PVT;

Line 95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

91: ROLLBACK TO Create_Rank_PVT;
92: x_return_status := FND_API.G_RET_STS_ERROR;
93: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
94:
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96: ROLLBACK TO Create_Rank_PVT;
97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
98: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
99:

Line 97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

93: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
94:
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96: ROLLBACK TO Create_Rank_PVT;
97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
98: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
99:
100: WHEN OTHERS THEN
101: ROLLBACK TO Create_Rank_PVT;

Line 102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

98: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
99:
100: WHEN OTHERS THEN
101: ROLLBACK TO Create_Rank_PVT;
102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
103: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
104: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
105: END IF;
106: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

107:
108: END Create_Rank;
109:
110: PROCEDURE Update_Rank (p_api_version IN NUMBER := 2.0,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER :=
114: FND_API.G_VALID_LEVEL_FULL,
115: x_return_status OUT NOCOPY VARCHAR2,

Line 112: p_commit IN VARCHAR2 := FND_API.G_FALSE,

108: END Create_Rank;
109:
110: PROCEDURE Update_Rank (p_api_version IN NUMBER := 2.0,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER :=
114: FND_API.G_VALID_LEVEL_FULL,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,

Line 114: FND_API.G_VALID_LEVEL_FULL,

110: PROCEDURE Update_Rank (p_api_version IN NUMBER := 2.0,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER :=
114: FND_API.G_VALID_LEVEL_FULL,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type) IS

Line 136: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

132: -- Standard start of API savepoint
133: SAVEPOINT Update_Rank_PVT;
134:
135: -- Standard call to check for call compatibility
136: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
138: END IF;
139:
140: -- Initialize message list if p_init_msg_list is set to TRUE

Line 137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

133: SAVEPOINT Update_Rank_PVT;
134:
135: -- Standard call to check for call compatibility
136: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
138: END IF;
139:
140: -- Initialize message list if p_init_msg_list is set to TRUE
141: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 141: IF FND_API.To_Boolean(p_init_msg_list) THEN

137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
138: END IF;
139:
140: -- Initialize message list if p_init_msg_list is set to TRUE
141: IF FND_API.To_Boolean(p_init_msg_list) THEN
142: FND_MSG_PUB.initialize;
143: END IF;
144:
145: l_sales_lead_rank_rec := p_sales_lead_rank_rec;

Line 148: x_return_status := FND_API.G_RET_STS_SUCCESS;

144:
145: l_sales_lead_rank_rec := p_sales_lead_rank_rec;
146:
147: -- Initialize API return status to success
148: x_return_status := FND_API.G_RET_STS_SUCCESS;
149:
150: -- API body
151: AS_SALES_LEAD_RANKS_PVT.Update_Rank (p_api_version => l_api_version,
152: p_commit => p_commit,

Line 161: IF FND_API.To_Boolean(p_commit) THEN

157: x_return_status := l_return_status;
158: -- End of API body
159:
160: -- Standard check of p_commit
161: IF FND_API.To_Boolean(p_commit) THEN
162: COMMIT WORK;
163: END IF;
164:
165: -- Standard call to get message count and if count is 1, get message info

Line 168: WHEN FND_API.G_EXC_ERROR THEN

164:
165: -- Standard call to get message count and if count is 1, get message info
166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
167: EXCEPTION
168: WHEN FND_API.G_EXC_ERROR THEN
169: ROLLBACK TO Update_Rank_PVT;
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
172:

Line 170: x_return_status := FND_API.G_RET_STS_ERROR;

166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
167: EXCEPTION
168: WHEN FND_API.G_EXC_ERROR THEN
169: ROLLBACK TO Update_Rank_PVT;
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
172:
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: ROLLBACK TO Update_Rank_PVT;

Line 173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

169: ROLLBACK TO Update_Rank_PVT;
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
172:
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: ROLLBACK TO Update_Rank_PVT;
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
177:

Line 175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

171: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
172:
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: ROLLBACK TO Update_Rank_PVT;
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
177:
178: WHEN OTHERS THEN
179: ROLLBACK TO Update_Rank_PVT;

Line 180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

176: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
177:
178: WHEN OTHERS THEN
179: ROLLBACK TO Update_Rank_PVT;
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
182: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
183: END IF;
184: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

184: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
185: END Update_Rank;
186:
187: Procedure Delete_Rank (p_api_version IN NUMBER := 2.0,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE,
190: p_validation_level IN NUMBER :=
191: FND_API.G_VALID_LEVEL_FULL,
192: x_return_status OUT NOCOPY VARCHAR2,

Line 189: p_commit IN VARCHAR2 := FND_API.G_FALSE,

185: END Update_Rank;
186:
187: Procedure Delete_Rank (p_api_version IN NUMBER := 2.0,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE,
190: p_validation_level IN NUMBER :=
191: FND_API.G_VALID_LEVEL_FULL,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,

Line 191: FND_API.G_VALID_LEVEL_FULL,

187: Procedure Delete_Rank (p_api_version IN NUMBER := 2.0,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE,
190: p_validation_level IN NUMBER :=
191: FND_API.G_VALID_LEVEL_FULL,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_sales_lead_rank_id IN NUMBER) IS

Line 210: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

206: -- Standard start of API savepoint
207: SAVEPOINT Delete_Rank_PVT;
208:
209: -- Standard call to check for call compatibility
210: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:
214: -- Initialize message list if p_init_msg_list is set to TRUE

Line 211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

207: SAVEPOINT Delete_Rank_PVT;
208:
209: -- Standard call to check for call compatibility
210: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:
214: -- Initialize message list if p_init_msg_list is set to TRUE
215: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 215: IF FND_API.To_Boolean(p_init_msg_list) THEN

211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:
214: -- Initialize message list if p_init_msg_list is set to TRUE
215: IF FND_API.To_Boolean(p_init_msg_list) THEN
216: FND_MSG_PUB.initialize;
217: END IF;
218:
219: l_sales_lead_rank_id := p_sales_lead_rank_id;

Line 222: x_return_status := FND_API.G_RET_STS_SUCCESS;

218:
219: l_sales_lead_rank_id := p_sales_lead_rank_id;
220:
221: -- Initialize API return status to success
222: x_return_status := FND_API.G_RET_STS_SUCCESS;
223:
224: --dbms_output.put_line('before delete pvt');
225: -- API body
226: AS_SALES_LEAD_RANKS_PVT.Delete_Rank (p_api_version => 2.0,

Line 236: IF FND_API.To_Boolean(p_commit) THEN

232: x_return_status := l_return_status;
233: -- End of API body
234:
235: -- Standard check of p_commit
236: IF FND_API.To_Boolean(p_commit) THEN
237: COMMIT WORK;
238: --dbms_output.put_line('after delete pvt - commit');
239: END IF;
240:

Line 244: WHEN FND_API.G_EXC_ERROR THEN

240:
241: -- Standard call to get message count and if count is 1, get message info
242: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
243: EXCEPTION
244: WHEN FND_API.G_EXC_ERROR THEN
245: ROLLBACK TO Delete_Rank_PVT;
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
248:

Line 246: x_return_status := FND_API.G_RET_STS_ERROR;

242: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
243: EXCEPTION
244: WHEN FND_API.G_EXC_ERROR THEN
245: ROLLBACK TO Delete_Rank_PVT;
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: ROLLBACK TO Delete_Rank_PVT;

Line 249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

245: ROLLBACK TO Delete_Rank_PVT;
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: ROLLBACK TO Delete_Rank_PVT;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
253:

Line 251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

247: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: ROLLBACK TO Delete_Rank_PVT;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
253:
254: WHEN OTHERS THEN
255: ROLLBACK TO Delete_Rank_PVT;

Line 256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

252: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
253:
254: WHEN OTHERS THEN
255: ROLLBACK TO Delete_Rank_PVT;
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
258: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
259: END IF;
260: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);