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

Line 26: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.

22: -- the sequence.
23: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
24: -- Raise exception for invalid flag.
25: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
26: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
27: ---------------------------------------------------------------------
28: PROCEDURE Create_ListAction
29: ( p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

26: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
27: ---------------------------------------------------------------------
28: PROCEDURE Create_ListAction
29: ( p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE,
32: p_validation_level IN NUMBER
33: := FND_API.G_VALID_LEVEL_FULL,
34: x_return_status OUT NOCOPY VARCHAR2,

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

27: ---------------------------------------------------------------------
28: PROCEDURE Create_ListAction
29: ( p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE,
32: p_validation_level IN NUMBER
33: := FND_API.G_VALID_LEVEL_FULL,
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,

Line 33: := FND_API.G_VALID_LEVEL_FULL,

29: ( p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
31: p_commit IN VARCHAR2 := FND_API.G_FALSE,
32: p_validation_level IN NUMBER
33: := FND_API.G_VALID_LEVEL_FULL,
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2,
37:

Line 55: IF FND_API.to_boolean(p_init_msg_list) THEN

51: SAVEPOINT create_listaction_pub;
52:
53: -- initialize the message list;
54: -- won't do it again when calling private API
55: IF FND_API.to_boolean(p_init_msg_list) THEN
56: FND_MSG_PUB.initialize;
57: END IF;
58:
59: AMS_LISTACTION_PVT.Create_ListAction

Line 61: p_init_msg_list => FND_API.G_FALSE,

57: END IF;
58:
59: AMS_LISTACTION_PVT.Create_ListAction
60: ( p_api_version => p_api_version,
61: p_init_msg_list => FND_API.G_FALSE,
62: p_commit => FND_API.G_FALSE,
63: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
64: x_return_status => l_return_status,
65: x_msg_count => x_msg_count,

Line 62: p_commit => FND_API.G_FALSE,

58:
59: AMS_LISTACTION_PVT.Create_ListAction
60: ( p_api_version => p_api_version,
61: p_init_msg_list => FND_API.G_FALSE,
62: p_commit => FND_API.G_FALSE,
63: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
64: x_return_status => l_return_status,
65: x_msg_count => x_msg_count,
66: x_msg_data => x_msg_data,

Line 63: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

59: AMS_LISTACTION_PVT.Create_ListAction
60: ( p_api_version => p_api_version,
61: p_init_msg_list => FND_API.G_FALSE,
62: p_commit => FND_API.G_FALSE,
63: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
64: x_return_status => l_return_status,
65: x_msg_count => x_msg_count,
66: x_msg_data => x_msg_data,
67:

Line 72: IF l_return_status = FND_API.g_ret_sts_error THEN

68: p_action_rec => l_action_rec,
69: x_action_id => l_action_id);
70:
71:
72: IF l_return_status = FND_API.g_ret_sts_error THEN
73: RAISE FND_API.g_exc_error;
74: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
75: RAISE FND_API.g_exc_unexpected_error;
76: END IF;

Line 73: RAISE FND_API.g_exc_error;

69: x_action_id => l_action_id);
70:
71:
72: IF l_return_status = FND_API.g_ret_sts_error THEN
73: RAISE FND_API.g_exc_error;
74: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
75: RAISE FND_API.g_exc_unexpected_error;
76: END IF;
77:

Line 74: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

70:
71:
72: IF l_return_status = FND_API.g_ret_sts_error THEN
73: RAISE FND_API.g_exc_error;
74: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
75: RAISE FND_API.g_exc_unexpected_error;
76: END IF;
77:
78: IF FND_API.to_boolean(p_commit) THEN

Line 75: RAISE FND_API.g_exc_unexpected_error;

71:
72: IF l_return_status = FND_API.g_ret_sts_error THEN
73: RAISE FND_API.g_exc_error;
74: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
75: RAISE FND_API.g_exc_unexpected_error;
76: END IF;
77:
78: IF FND_API.to_boolean(p_commit) THEN
79: COMMIT;

Line 78: IF FND_API.to_boolean(p_commit) THEN

74: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
75: RAISE FND_API.g_exc_unexpected_error;
76: END IF;
77:
78: IF FND_API.to_boolean(p_commit) THEN
79: COMMIT;
80: END IF;
81:
82: x_return_status := FND_API.g_ret_sts_success;

Line 82: x_return_status := FND_API.g_ret_sts_success;

78: IF FND_API.to_boolean(p_commit) THEN
79: COMMIT;
80: END IF;
81:
82: x_return_status := FND_API.g_ret_sts_success;
83:
84: FND_MSG_PUB.count_and_get(
85: p_encoded => FND_API.g_false,
86: p_count => x_msg_count,

Line 85: p_encoded => FND_API.g_false,

81:
82: x_return_status := FND_API.g_ret_sts_success;
83:
84: FND_MSG_PUB.count_and_get(
85: p_encoded => FND_API.g_false,
86: p_count => x_msg_count,
87: p_data => x_msg_data
88: );
89:

Line 92: WHEN FND_API.g_exc_error THEN

88: );
89:
90: EXCEPTION
91:
92: WHEN FND_API.g_exc_error THEN
93: ROLLBACK TO create_ListAction_pub;
94: x_return_status := FND_API.g_ret_sts_error;
95: FND_MSG_PUB.count_and_get(
96: p_encoded => FND_API.g_false,

Line 94: x_return_status := FND_API.g_ret_sts_error;

90: EXCEPTION
91:
92: WHEN FND_API.g_exc_error THEN
93: ROLLBACK TO create_ListAction_pub;
94: x_return_status := FND_API.g_ret_sts_error;
95: FND_MSG_PUB.count_and_get(
96: p_encoded => FND_API.g_false,
97: p_count => x_msg_count,
98: p_data => x_msg_data

Line 96: p_encoded => FND_API.g_false,

92: WHEN FND_API.g_exc_error THEN
93: ROLLBACK TO create_ListAction_pub;
94: x_return_status := FND_API.g_ret_sts_error;
95: FND_MSG_PUB.count_and_get(
96: p_encoded => FND_API.g_false,
97: p_count => x_msg_count,
98: p_data => x_msg_data
99: );
100:

Line 101: WHEN FND_API.g_exc_unexpected_error THEN

97: p_count => x_msg_count,
98: p_data => x_msg_data
99: );
100:
101: WHEN FND_API.g_exc_unexpected_error THEN
102: ROLLBACK TO create_ListAction_pub;
103: x_return_status := FND_API.g_ret_sts_unexp_error ;
104: FND_MSG_PUB.count_and_get(
105: p_encoded => FND_API.g_false,

Line 103: x_return_status := FND_API.g_ret_sts_unexp_error ;

99: );
100:
101: WHEN FND_API.g_exc_unexpected_error THEN
102: ROLLBACK TO create_ListAction_pub;
103: x_return_status := FND_API.g_ret_sts_unexp_error ;
104: FND_MSG_PUB.count_and_get(
105: p_encoded => FND_API.g_false,
106: p_count => x_msg_count,
107: p_data => x_msg_data

Line 105: p_encoded => FND_API.g_false,

101: WHEN FND_API.g_exc_unexpected_error THEN
102: ROLLBACK TO create_ListAction_pub;
103: x_return_status := FND_API.g_ret_sts_unexp_error ;
104: FND_MSG_PUB.count_and_get(
105: p_encoded => FND_API.g_false,
106: p_count => x_msg_count,
107: p_data => x_msg_data
108: );
109:

Line 113: x_return_status := FND_API.g_ret_sts_unexp_error ;

109:
110:
111: WHEN OTHERS THEN
112: ROLLBACK TO create_ListAction_pub;
113: x_return_status := FND_API.g_ret_sts_unexp_error ;
114:
115: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
116: THEN
117: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 121: p_encoded => FND_API.g_false,

117: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
118: END IF;
119:
120: FND_MSG_PUB.count_and_get(
121: p_encoded => FND_API.g_false,
122: p_count => x_msg_count,
123: p_data => x_msg_data
124: );
125:

Line 141: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,

137: -- p_action_rec: the record with new items
138: --
139: -- NOTES
140: -- 1. Raise exception if the object_version_number doesn't match.
141: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
142: -- that column won't be updated.
143: ----------------------------------------------------------------------
144: -- End Of Comments
145: PROCEDURE Update_ListAction

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

143: ----------------------------------------------------------------------
144: -- End Of Comments
145: PROCEDURE Update_ListAction
146: ( p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER
150: := FND_API.G_VALID_LEVEL_FULL,
151: x_return_status OUT NOCOPY VARCHAR2,

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

144: -- End Of Comments
145: PROCEDURE Update_ListAction
146: ( p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER
150: := FND_API.G_VALID_LEVEL_FULL,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,

Line 150: := FND_API.G_VALID_LEVEL_FULL,

146: ( p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER
150: := FND_API.G_VALID_LEVEL_FULL,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154:

Line 171: IF FND_API.to_boolean(p_init_msg_list) THEN

167: SAVEPOINT update_listaction_pub;
168:
169: -- initialize the message list;
170: -- won't do it again when calling private API
171: IF FND_API.to_boolean(p_init_msg_list) THEN
172: FND_MSG_PUB.initialize;
173: END IF;
174:
175: AMS_LISTACTION_PVT.Update_ListAction

Line 177: p_init_msg_list => FND_API.G_FALSE,

173: END IF;
174:
175: AMS_LISTACTION_PVT.Update_ListAction
176: ( p_api_version => p_api_version,
177: p_init_msg_list => FND_API.G_FALSE,
178: p_commit => FND_API.G_FALSE,
179: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
180: x_return_status => l_return_status,
181: x_msg_count => x_msg_count,

Line 178: p_commit => FND_API.G_FALSE,

174:
175: AMS_LISTACTION_PVT.Update_ListAction
176: ( p_api_version => p_api_version,
177: p_init_msg_list => FND_API.G_FALSE,
178: p_commit => FND_API.G_FALSE,
179: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
180: x_return_status => l_return_status,
181: x_msg_count => x_msg_count,
182: x_msg_data => x_msg_data ,

Line 179: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

175: AMS_LISTACTION_PVT.Update_ListAction
176: ( p_api_version => p_api_version,
177: p_init_msg_list => FND_API.G_FALSE,
178: p_commit => FND_API.G_FALSE,
179: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
180: x_return_status => l_return_status,
181: x_msg_count => x_msg_count,
182: x_msg_data => x_msg_data ,
183:

Line 186: IF l_return_status = FND_API.g_ret_sts_error THEN

182: x_msg_data => x_msg_data ,
183:
184: p_action_rec => l_action_rec);
185:
186: IF l_return_status = FND_API.g_ret_sts_error THEN
187: RAISE FND_API.g_exc_error;
188: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
189: RAISE FND_API.g_exc_unexpected_error;
190: END IF;

Line 187: RAISE FND_API.g_exc_error;

183:
184: p_action_rec => l_action_rec);
185:
186: IF l_return_status = FND_API.g_ret_sts_error THEN
187: RAISE FND_API.g_exc_error;
188: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
189: RAISE FND_API.g_exc_unexpected_error;
190: END IF;
191:

Line 188: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

184: p_action_rec => l_action_rec);
185:
186: IF l_return_status = FND_API.g_ret_sts_error THEN
187: RAISE FND_API.g_exc_error;
188: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
189: RAISE FND_API.g_exc_unexpected_error;
190: END IF;
191:
192: IF FND_API.to_boolean(p_commit) THEN

Line 189: RAISE FND_API.g_exc_unexpected_error;

185:
186: IF l_return_status = FND_API.g_ret_sts_error THEN
187: RAISE FND_API.g_exc_error;
188: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
189: RAISE FND_API.g_exc_unexpected_error;
190: END IF;
191:
192: IF FND_API.to_boolean(p_commit) THEN
193: COMMIT;

Line 192: IF FND_API.to_boolean(p_commit) THEN

188: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
189: RAISE FND_API.g_exc_unexpected_error;
190: END IF;
191:
192: IF FND_API.to_boolean(p_commit) THEN
193: COMMIT;
194: END IF;
195: x_return_status := FND_API.g_ret_sts_success;
196: FND_MSG_PUB.count_and_get(

Line 195: x_return_status := FND_API.g_ret_sts_success;

191:
192: IF FND_API.to_boolean(p_commit) THEN
193: COMMIT;
194: END IF;
195: x_return_status := FND_API.g_ret_sts_success;
196: FND_MSG_PUB.count_and_get(
197: p_encoded => FND_API.g_false,
198: p_count => x_msg_count,
199: p_data => x_msg_data

Line 197: p_encoded => FND_API.g_false,

193: COMMIT;
194: END IF;
195: x_return_status := FND_API.g_ret_sts_success;
196: FND_MSG_PUB.count_and_get(
197: p_encoded => FND_API.g_false,
198: p_count => x_msg_count,
199: p_data => x_msg_data
200: );
201:

Line 204: WHEN FND_API.g_exc_error THEN

200: );
201:
202: EXCEPTION
203:
204: WHEN FND_API.g_exc_error THEN
205: ROLLBACK TO update_listaction_pub;
206: x_return_status := FND_API.g_ret_sts_error;
207: FND_MSG_PUB.count_and_get(
208: p_encoded => FND_API.g_false,

Line 206: x_return_status := FND_API.g_ret_sts_error;

202: EXCEPTION
203:
204: WHEN FND_API.g_exc_error THEN
205: ROLLBACK TO update_listaction_pub;
206: x_return_status := FND_API.g_ret_sts_error;
207: FND_MSG_PUB.count_and_get(
208: p_encoded => FND_API.g_false,
209: p_count => x_msg_count,
210: p_data => x_msg_data

Line 208: p_encoded => FND_API.g_false,

204: WHEN FND_API.g_exc_error THEN
205: ROLLBACK TO update_listaction_pub;
206: x_return_status := FND_API.g_ret_sts_error;
207: FND_MSG_PUB.count_and_get(
208: p_encoded => FND_API.g_false,
209: p_count => x_msg_count,
210: p_data => x_msg_data
211: );
212:

Line 213: WHEN FND_API.g_exc_unexpected_error THEN

209: p_count => x_msg_count,
210: p_data => x_msg_data
211: );
212:
213: WHEN FND_API.g_exc_unexpected_error THEN
214: ROLLBACK TO create_campaign_pub;
215: x_return_status := FND_API.g_ret_sts_unexp_error ;
216: FND_MSG_PUB.count_and_get(
217: p_encoded => FND_API.g_false,

Line 215: x_return_status := FND_API.g_ret_sts_unexp_error ;

211: );
212:
213: WHEN FND_API.g_exc_unexpected_error THEN
214: ROLLBACK TO create_campaign_pub;
215: x_return_status := FND_API.g_ret_sts_unexp_error ;
216: FND_MSG_PUB.count_and_get(
217: p_encoded => FND_API.g_false,
218: p_count => x_msg_count,
219: p_data => x_msg_data

Line 217: p_encoded => FND_API.g_false,

213: WHEN FND_API.g_exc_unexpected_error THEN
214: ROLLBACK TO create_campaign_pub;
215: x_return_status := FND_API.g_ret_sts_unexp_error ;
216: FND_MSG_PUB.count_and_get(
217: p_encoded => FND_API.g_false,
218: p_count => x_msg_count,
219: p_data => x_msg_data
220: );
221:

Line 225: x_return_status := FND_API.g_ret_sts_unexp_error ;

221:
222:
223: WHEN OTHERS THEN
224: ROLLBACK TO update_listaction_pub;
225: x_return_status := FND_API.g_ret_sts_unexp_error ;
226:
227: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
228: THEN
229: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 233: p_encoded => FND_API.g_false,

229: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
230: END IF;
231:
232: FND_MSG_PUB.count_and_get(
233: p_encoded => FND_API.g_false,
234: p_count => x_msg_count,
235: p_data => x_msg_data
236: );
237:

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

255: --------------------------------------------------------------------
256: -- End Of Comments
257: PROCEDURE Delete_ListAction
258: ( p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
260: p_commit IN VARCHAR2 := FND_API.G_FALSE,
261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262:
263: x_return_status OUT NOCOPY VARCHAR2,

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

256: -- End Of Comments
257: PROCEDURE Delete_ListAction
258: ( p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
260: p_commit IN VARCHAR2 := FND_API.G_FALSE,
261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262:
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,

Line 261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

257: PROCEDURE Delete_ListAction
258: ( p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
260: p_commit IN VARCHAR2 := FND_API.G_FALSE,
261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262:
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2,

Line 283: IF FND_API.to_boolean(p_init_msg_list) THEN

279: SAVEPOINT Delete_ListAction_pub;
280:
281: -- initialize the message list;
282: -- won't do it again when calling private API
283: IF FND_API.to_boolean(p_init_msg_list) THEN
284: FND_MSG_PUB.initialize;
285: END IF;
286:
287: Delete_ListAction

Line 289: p_init_msg_list => FND_API.G_FALSE,

285: END IF;
286:
287: Delete_ListAction
288: ( p_api_version => p_api_version,
289: p_init_msg_list => FND_API.G_FALSE,
290: p_commit => FND_API.G_FALSE,
291: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
292:
293: x_return_status => l_return_status,

Line 290: p_commit => FND_API.G_FALSE,

286:
287: Delete_ListAction
288: ( p_api_version => p_api_version,
289: p_init_msg_list => FND_API.G_FALSE,
290: p_commit => FND_API.G_FALSE,
291: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
292:
293: x_return_status => l_return_status,
294: x_msg_count => x_msg_count,

Line 291: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

287: Delete_ListAction
288: ( p_api_version => p_api_version,
289: p_init_msg_list => FND_API.G_FALSE,
290: p_commit => FND_API.G_FALSE,
291: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
292:
293: x_return_status => l_return_status,
294: x_msg_count => x_msg_count,
295: x_msg_data => x_msg_data,

Line 300: IF l_return_status = FND_API.g_ret_sts_error THEN

296:
297: p_action_id => l_action_id);
298:
299:
300: IF l_return_status = FND_API.g_ret_sts_error THEN
301: RAISE FND_API.g_exc_error;
302: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
303: RAISE FND_API.g_exc_unexpected_error;
304: END IF;

Line 301: RAISE FND_API.g_exc_error;

297: p_action_id => l_action_id);
298:
299:
300: IF l_return_status = FND_API.g_ret_sts_error THEN
301: RAISE FND_API.g_exc_error;
302: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
303: RAISE FND_API.g_exc_unexpected_error;
304: END IF;
305:

Line 302: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

298:
299:
300: IF l_return_status = FND_API.g_ret_sts_error THEN
301: RAISE FND_API.g_exc_error;
302: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
303: RAISE FND_API.g_exc_unexpected_error;
304: END IF;
305:
306: IF FND_API.to_boolean(p_commit) THEN

Line 303: RAISE FND_API.g_exc_unexpected_error;

299:
300: IF l_return_status = FND_API.g_ret_sts_error THEN
301: RAISE FND_API.g_exc_error;
302: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
303: RAISE FND_API.g_exc_unexpected_error;
304: END IF;
305:
306: IF FND_API.to_boolean(p_commit) THEN
307: COMMIT;

Line 306: IF FND_API.to_boolean(p_commit) THEN

302: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
303: RAISE FND_API.g_exc_unexpected_error;
304: END IF;
305:
306: IF FND_API.to_boolean(p_commit) THEN
307: COMMIT;
308: END IF;
309: x_return_status := FND_API.g_ret_sts_success;
310: FND_MSG_PUB.count_and_get(

Line 309: x_return_status := FND_API.g_ret_sts_success;

305:
306: IF FND_API.to_boolean(p_commit) THEN
307: COMMIT;
308: END IF;
309: x_return_status := FND_API.g_ret_sts_success;
310: FND_MSG_PUB.count_and_get(
311: p_encoded => FND_API.g_false,
312: p_count => x_msg_count,
313: p_data => x_msg_data

Line 311: p_encoded => FND_API.g_false,

307: COMMIT;
308: END IF;
309: x_return_status := FND_API.g_ret_sts_success;
310: FND_MSG_PUB.count_and_get(
311: p_encoded => FND_API.g_false,
312: p_count => x_msg_count,
313: p_data => x_msg_data
314: );
315:

Line 318: WHEN FND_API.g_exc_error THEN

314: );
315:
316: EXCEPTION
317:
318: WHEN FND_API.g_exc_error THEN
319: ROLLBACK TO Delete_ListAction_pub;
320: x_return_status := FND_API.g_ret_sts_error;
321: FND_MSG_PUB.count_and_get(
322: p_encoded => FND_API.g_false,

Line 320: x_return_status := FND_API.g_ret_sts_error;

316: EXCEPTION
317:
318: WHEN FND_API.g_exc_error THEN
319: ROLLBACK TO Delete_ListAction_pub;
320: x_return_status := FND_API.g_ret_sts_error;
321: FND_MSG_PUB.count_and_get(
322: p_encoded => FND_API.g_false,
323: p_count => x_msg_count,
324: p_data => x_msg_data

Line 322: p_encoded => FND_API.g_false,

318: WHEN FND_API.g_exc_error THEN
319: ROLLBACK TO Delete_ListAction_pub;
320: x_return_status := FND_API.g_ret_sts_error;
321: FND_MSG_PUB.count_and_get(
322: p_encoded => FND_API.g_false,
323: p_count => x_msg_count,
324: p_data => x_msg_data
325: );
326:

Line 327: WHEN FND_API.g_exc_unexpected_error THEN

323: p_count => x_msg_count,
324: p_data => x_msg_data
325: );
326:
327: WHEN FND_API.g_exc_unexpected_error THEN
328: ROLLBACK TO create_campaign_pub;
329: x_return_status := FND_API.g_ret_sts_unexp_error ;
330: FND_MSG_PUB.count_and_get(
331: p_encoded => FND_API.g_false,

Line 329: x_return_status := FND_API.g_ret_sts_unexp_error ;

325: );
326:
327: WHEN FND_API.g_exc_unexpected_error THEN
328: ROLLBACK TO create_campaign_pub;
329: x_return_status := FND_API.g_ret_sts_unexp_error ;
330: FND_MSG_PUB.count_and_get(
331: p_encoded => FND_API.g_false,
332: p_count => x_msg_count,
333: p_data => x_msg_data

Line 331: p_encoded => FND_API.g_false,

327: WHEN FND_API.g_exc_unexpected_error THEN
328: ROLLBACK TO create_campaign_pub;
329: x_return_status := FND_API.g_ret_sts_unexp_error ;
330: FND_MSG_PUB.count_and_get(
331: p_encoded => FND_API.g_false,
332: p_count => x_msg_count,
333: p_data => x_msg_data
334: );
335:

Line 339: x_return_status := FND_API.g_ret_sts_unexp_error ;

335:
336:
337: WHEN OTHERS THEN
338: ROLLBACK TO Delete_ListAction_pub;
339: x_return_status := FND_API.g_ret_sts_unexp_error ;
340:
341: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
342: THEN
343: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 347: p_encoded => FND_API.g_false,

343: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
344: END IF;
345:
346: FND_MSG_PUB.count_and_get(
347: p_encoded => FND_API.g_false,
348: p_count => x_msg_count,
349: p_data => x_msg_data
350: );
351: END Delete_ListAction;

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

368: --------------------------------------------------------------------
369: -- End Of Comments
370: PROCEDURE Lock_ListAction
371: ( p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
374:
375: x_return_status OUT NOCOPY VARCHAR2,
376: x_msg_count OUT NOCOPY NUMBER,

Line 373: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

369: -- End Of Comments
370: PROCEDURE Lock_ListAction
371: ( p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
374:
375: x_return_status OUT NOCOPY VARCHAR2,
376: x_msg_count OUT NOCOPY NUMBER,
377: x_msg_data OUT NOCOPY VARCHAR2,

Line 398: IF FND_API.to_boolean(p_init_msg_list) THEN

394: SAVEPOINT Lock_ListAction_pub;
395:
396: -- initialize the message list;
397: -- won't do it again when calling private API
398: IF FND_API.to_boolean(p_init_msg_list) THEN
399: FND_MSG_PUB.initialize;
400: END IF;
401:
402: AMS_LISTACTION_PVT.Lock_ListAction

Line 404: p_init_msg_list => FND_API.G_FALSE,

400: END IF;
401:
402: AMS_LISTACTION_PVT.Lock_ListAction
403: ( p_api_version => p_api_version,
404: p_init_msg_list => FND_API.G_FALSE,
405: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
406:
407: x_return_status => l_return_status,
408: x_msg_count => x_msg_count,

Line 405: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

401:
402: AMS_LISTACTION_PVT.Lock_ListAction
403: ( p_api_version => p_api_version,
404: p_init_msg_list => FND_API.G_FALSE,
405: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
406:
407: x_return_status => l_return_status,
408: x_msg_count => x_msg_count,
409: x_msg_data => x_msg_data,

Line 414: IF l_return_status = FND_API.g_ret_sts_error THEN

410:
411: p_action_id => l_action_id,
412: p_object_version => l_object_version_number );
413:
414: IF l_return_status = FND_API.g_ret_sts_error THEN
415: RAISE FND_API.g_exc_error;
416: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
417: RAISE FND_API.g_exc_unexpected_error;
418: END IF;

Line 415: RAISE FND_API.g_exc_error;

411: p_action_id => l_action_id,
412: p_object_version => l_object_version_number );
413:
414: IF l_return_status = FND_API.g_ret_sts_error THEN
415: RAISE FND_API.g_exc_error;
416: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
417: RAISE FND_API.g_exc_unexpected_error;
418: END IF;
419:

Line 416: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

412: p_object_version => l_object_version_number );
413:
414: IF l_return_status = FND_API.g_ret_sts_error THEN
415: RAISE FND_API.g_exc_error;
416: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
417: RAISE FND_API.g_exc_unexpected_error;
418: END IF;
419:
420: x_return_status := FND_API.g_ret_sts_success;

Line 417: RAISE FND_API.g_exc_unexpected_error;

413:
414: IF l_return_status = FND_API.g_ret_sts_error THEN
415: RAISE FND_API.g_exc_error;
416: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
417: RAISE FND_API.g_exc_unexpected_error;
418: END IF;
419:
420: x_return_status := FND_API.g_ret_sts_success;
421: FND_MSG_PUB.count_and_get(

Line 420: x_return_status := FND_API.g_ret_sts_success;

416: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
417: RAISE FND_API.g_exc_unexpected_error;
418: END IF;
419:
420: x_return_status := FND_API.g_ret_sts_success;
421: FND_MSG_PUB.count_and_get(
422: p_encoded => FND_API.g_false,
423: p_count => x_msg_count,
424: p_data => x_msg_data

Line 422: p_encoded => FND_API.g_false,

418: END IF;
419:
420: x_return_status := FND_API.g_ret_sts_success;
421: FND_MSG_PUB.count_and_get(
422: p_encoded => FND_API.g_false,
423: p_count => x_msg_count,
424: p_data => x_msg_data
425: );
426:

Line 429: WHEN FND_API.g_exc_error THEN

425: );
426:
427: EXCEPTION
428:
429: WHEN FND_API.g_exc_error THEN
430: ROLLBACK TO Lock_ListAction_pub;
431: x_return_status := FND_API.g_ret_sts_error;
432: FND_MSG_PUB.count_and_get(
433: p_encoded => FND_API.g_false,

Line 431: x_return_status := FND_API.g_ret_sts_error;

427: EXCEPTION
428:
429: WHEN FND_API.g_exc_error THEN
430: ROLLBACK TO Lock_ListAction_pub;
431: x_return_status := FND_API.g_ret_sts_error;
432: FND_MSG_PUB.count_and_get(
433: p_encoded => FND_API.g_false,
434: p_count => x_msg_count,
435: p_data => x_msg_data

Line 433: p_encoded => FND_API.g_false,

429: WHEN FND_API.g_exc_error THEN
430: ROLLBACK TO Lock_ListAction_pub;
431: x_return_status := FND_API.g_ret_sts_error;
432: FND_MSG_PUB.count_and_get(
433: p_encoded => FND_API.g_false,
434: p_count => x_msg_count,
435: p_data => x_msg_data
436: );
437:

Line 438: WHEN FND_API.g_exc_unexpected_error THEN

434: p_count => x_msg_count,
435: p_data => x_msg_data
436: );
437:
438: WHEN FND_API.g_exc_unexpected_error THEN
439: ROLLBACK TO Lock_ListAction_pub;
440: x_return_status := FND_API.g_ret_sts_unexp_error ;
441: FND_MSG_PUB.count_and_get(
442: p_encoded => FND_API.g_false,

Line 440: x_return_status := FND_API.g_ret_sts_unexp_error ;

436: );
437:
438: WHEN FND_API.g_exc_unexpected_error THEN
439: ROLLBACK TO Lock_ListAction_pub;
440: x_return_status := FND_API.g_ret_sts_unexp_error ;
441: FND_MSG_PUB.count_and_get(
442: p_encoded => FND_API.g_false,
443: p_count => x_msg_count,
444: p_data => x_msg_data

Line 442: p_encoded => FND_API.g_false,

438: WHEN FND_API.g_exc_unexpected_error THEN
439: ROLLBACK TO Lock_ListAction_pub;
440: x_return_status := FND_API.g_ret_sts_unexp_error ;
441: FND_MSG_PUB.count_and_get(
442: p_encoded => FND_API.g_false,
443: p_count => x_msg_count,
444: p_data => x_msg_data
445: );
446:

Line 450: x_return_status := FND_API.g_ret_sts_unexp_error ;

446:
447:
448: WHEN OTHERS THEN
449: ROLLBACK TO Lock_ListAction_pub;
450: x_return_status := FND_API.g_ret_sts_unexp_error ;
451:
452: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
453: THEN
454: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 458: p_encoded => FND_API.g_false,

454: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
455: END IF;
456:
457: FND_MSG_PUB.count_and_get(
458: p_encoded => FND_API.g_false,
459: p_count => x_msg_count,
460: p_data => x_msg_data
461: );
462: End Lock_ListAction;

Line 477: -- should not be any FND_API.g_miss_char/num/date in it.

473: -- p_action_rec: the list action record to be validated
474: --
475: -- NOTES
476: -- 1. p_action_rec should be the complete list action record. There
477: -- should not be any FND_API.g_miss_char/num/date in it.
478: ----------------------------------------------------------------------
479: -- End Of Comments
480: PROCEDURE Validate_ListAction
481: ( p_api_version IN NUMBER,

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

478: ----------------------------------------------------------------------
479: -- End Of Comments
480: PROCEDURE Validate_ListAction
481: ( p_api_version IN NUMBER,
482: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
483: p_validation_level IN NUMBER
484: := FND_API.G_VALID_LEVEL_FULL,
485: x_return_status OUT NOCOPY VARCHAR2,
486: x_msg_count OUT NOCOPY NUMBER,

Line 484: := FND_API.G_VALID_LEVEL_FULL,

480: PROCEDURE Validate_ListAction
481: ( p_api_version IN NUMBER,
482: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
483: p_validation_level IN NUMBER
484: := FND_API.G_VALID_LEVEL_FULL,
485: x_return_status OUT NOCOPY VARCHAR2,
486: x_msg_count OUT NOCOPY NUMBER,
487: x_msg_data OUT NOCOPY VARCHAR2,
488:

Line 505: IF FND_API.to_boolean(p_init_msg_list) THEN

501: SAVEPOINT Validate_ListAction_pub;
502:
503: -- initialize the message list;
504: -- won't do it again when calling private API
505: IF FND_API.to_boolean(p_init_msg_list) THEN
506: FND_MSG_PUB.initialize;
507: END IF;
508:
509: Validate_ListAction

Line 511: p_init_msg_list => FND_API.G_FALSE,

507: END IF;
508:
509: Validate_ListAction
510: ( p_api_version => p_api_version,
511: p_init_msg_list => FND_API.G_FALSE,
512: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
513: x_return_status => l_return_status,
514: x_msg_count => x_msg_count,
515: x_msg_data => x_msg_data ,

Line 512: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

508:
509: Validate_ListAction
510: ( p_api_version => p_api_version,
511: p_init_msg_list => FND_API.G_FALSE,
512: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
513: x_return_status => l_return_status,
514: x_msg_count => x_msg_count,
515: x_msg_data => x_msg_data ,
516:

Line 519: IF l_return_status = FND_API.g_ret_sts_error THEN

515: x_msg_data => x_msg_data ,
516:
517: p_action_rec => l_action_rec);
518:
519: IF l_return_status = FND_API.g_ret_sts_error THEN
520: RAISE FND_API.g_exc_error;
521: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
522: RAISE FND_API.g_exc_unexpected_error;
523: END IF;

Line 520: RAISE FND_API.g_exc_error;

516:
517: p_action_rec => l_action_rec);
518:
519: IF l_return_status = FND_API.g_ret_sts_error THEN
520: RAISE FND_API.g_exc_error;
521: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
522: RAISE FND_API.g_exc_unexpected_error;
523: END IF;
524:

Line 521: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

517: p_action_rec => l_action_rec);
518:
519: IF l_return_status = FND_API.g_ret_sts_error THEN
520: RAISE FND_API.g_exc_error;
521: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
522: RAISE FND_API.g_exc_unexpected_error;
523: END IF;
524:
525:

Line 522: RAISE FND_API.g_exc_unexpected_error;

518:
519: IF l_return_status = FND_API.g_ret_sts_error THEN
520: RAISE FND_API.g_exc_error;
521: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
522: RAISE FND_API.g_exc_unexpected_error;
523: END IF;
524:
525:
526: x_return_status := FND_API.g_ret_sts_success;

Line 526: x_return_status := FND_API.g_ret_sts_success;

522: RAISE FND_API.g_exc_unexpected_error;
523: END IF;
524:
525:
526: x_return_status := FND_API.g_ret_sts_success;
527: FND_MSG_PUB.count_and_get(
528: p_encoded => FND_API.g_false,
529: p_count => x_msg_count,
530: p_data => x_msg_data

Line 528: p_encoded => FND_API.g_false,

524:
525:
526: x_return_status := FND_API.g_ret_sts_success;
527: FND_MSG_PUB.count_and_get(
528: p_encoded => FND_API.g_false,
529: p_count => x_msg_count,
530: p_data => x_msg_data
531: );
532:

Line 535: WHEN FND_API.g_exc_error THEN

531: );
532:
533: EXCEPTION
534:
535: WHEN FND_API.g_exc_error THEN
536: ROLLBACK TO Validate_ListAction_pub;
537: x_return_status := FND_API.g_ret_sts_error;
538: FND_MSG_PUB.count_and_get(
539: p_encoded => FND_API.g_false,

Line 537: x_return_status := FND_API.g_ret_sts_error;

533: EXCEPTION
534:
535: WHEN FND_API.g_exc_error THEN
536: ROLLBACK TO Validate_ListAction_pub;
537: x_return_status := FND_API.g_ret_sts_error;
538: FND_MSG_PUB.count_and_get(
539: p_encoded => FND_API.g_false,
540: p_count => x_msg_count,
541: p_data => x_msg_data

Line 539: p_encoded => FND_API.g_false,

535: WHEN FND_API.g_exc_error THEN
536: ROLLBACK TO Validate_ListAction_pub;
537: x_return_status := FND_API.g_ret_sts_error;
538: FND_MSG_PUB.count_and_get(
539: p_encoded => FND_API.g_false,
540: p_count => x_msg_count,
541: p_data => x_msg_data
542: );
543:

Line 544: WHEN FND_API.g_exc_unexpected_error THEN

540: p_count => x_msg_count,
541: p_data => x_msg_data
542: );
543:
544: WHEN FND_API.g_exc_unexpected_error THEN
545: ROLLBACK TO Validate_ListAction_pub;
546: x_return_status := FND_API.g_ret_sts_unexp_error ;
547: FND_MSG_PUB.count_and_get(
548: p_encoded => FND_API.g_false,

Line 546: x_return_status := FND_API.g_ret_sts_unexp_error ;

542: );
543:
544: WHEN FND_API.g_exc_unexpected_error THEN
545: ROLLBACK TO Validate_ListAction_pub;
546: x_return_status := FND_API.g_ret_sts_unexp_error ;
547: FND_MSG_PUB.count_and_get(
548: p_encoded => FND_API.g_false,
549: p_count => x_msg_count,
550: p_data => x_msg_data

Line 548: p_encoded => FND_API.g_false,

544: WHEN FND_API.g_exc_unexpected_error THEN
545: ROLLBACK TO Validate_ListAction_pub;
546: x_return_status := FND_API.g_ret_sts_unexp_error ;
547: FND_MSG_PUB.count_and_get(
548: p_encoded => FND_API.g_false,
549: p_count => x_msg_count,
550: p_data => x_msg_data
551: );
552:

Line 556: x_return_status := FND_API.g_ret_sts_unexp_error ;

552:
553:
554: WHEN OTHERS THEN
555: ROLLBACK TO Validate_ListAction_pub;
556: x_return_status := FND_API.g_ret_sts_unexp_error ;
557:
558: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
559: THEN
560: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 564: p_encoded => FND_API.g_false,

560: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
561: END IF;
562:
563: FND_MSG_PUB.count_and_get(
564: p_encoded => FND_API.g_false,
565: p_count => x_msg_count,
566: p_data => x_msg_data
567: );
568: End Validate_ListAction;