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_LISTHEADER_PUB dependencies on FND_API

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

23: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
24:
25: PROCEDURE Create_ListHeader
26: ( p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,

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

24:
25: PROCEDURE Create_ListHeader
26: ( p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,
32: x_msg_data OUT NOCOPY VARCHAR2,

Line 29: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

25: PROCEDURE Create_ListHeader
26: ( p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,
32: x_msg_data OUT NOCOPY VARCHAR2,
33: p_listheader_rec IN AMS_LISTHEADER_PVT.list_header_rec_type,

Line 47: IF FND_API.to_boolean(p_init_msg_list) THEN

43:
44: SAVEPOINT create_listheader_pub;
45: -- initialize the message list;
46: -- won't do it again when calling private API
47: IF FND_API.to_boolean(p_init_msg_list) THEN
48: FND_MSG_PUB.initialize;
49: END IF;
50:
51: --call private API procedure.

Line 54: p_init_msg_list => FND_API.G_FALSE,

50:
51: --call private API procedure.
52: AMS_LISTHEADER_PVT.Create_ListHeader
53: ( p_api_version => p_api_version,
54: p_init_msg_list => FND_API.G_FALSE,
55: p_commit => FND_API.G_FALSE,
56: p_validation_level => FND_API.g_valid_level_full,
57: x_return_status => l_return_status,
58: x_msg_count => x_msg_count,

Line 55: p_commit => FND_API.G_FALSE,

51: --call private API procedure.
52: AMS_LISTHEADER_PVT.Create_ListHeader
53: ( p_api_version => p_api_version,
54: p_init_msg_list => FND_API.G_FALSE,
55: p_commit => FND_API.G_FALSE,
56: p_validation_level => FND_API.g_valid_level_full,
57: x_return_status => l_return_status,
58: x_msg_count => x_msg_count,
59: x_msg_data => x_msg_data,

Line 56: p_validation_level => FND_API.g_valid_level_full,

52: AMS_LISTHEADER_PVT.Create_ListHeader
53: ( p_api_version => p_api_version,
54: p_init_msg_list => FND_API.G_FALSE,
55: p_commit => FND_API.G_FALSE,
56: p_validation_level => FND_API.g_valid_level_full,
57: x_return_status => l_return_status,
58: x_msg_count => x_msg_count,
59: x_msg_data => x_msg_data,
60: p_listheader_rec => l_listheader_rec,

Line 64: IF l_return_status = FND_API.g_ret_sts_error THEN

60: p_listheader_rec => l_listheader_rec,
61: x_listheader_id => x_listheader_id);
62:
63:
64: IF l_return_status = FND_API.g_ret_sts_error THEN
65: RAISE FND_API.g_exc_error;
66: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
67: RAISE FND_API.g_exc_unexpected_error;
68: END IF;

Line 65: RAISE FND_API.g_exc_error;

61: x_listheader_id => x_listheader_id);
62:
63:
64: IF l_return_status = FND_API.g_ret_sts_error THEN
65: RAISE FND_API.g_exc_error;
66: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
67: RAISE FND_API.g_exc_unexpected_error;
68: END IF;
69:

Line 66: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

62:
63:
64: IF l_return_status = FND_API.g_ret_sts_error THEN
65: RAISE FND_API.g_exc_error;
66: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
67: RAISE FND_API.g_exc_unexpected_error;
68: END IF;
69:
70: IF FND_API.to_boolean(p_commit) THEN

Line 67: RAISE FND_API.g_exc_unexpected_error;

63:
64: IF l_return_status = FND_API.g_ret_sts_error THEN
65: RAISE FND_API.g_exc_error;
66: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
67: RAISE FND_API.g_exc_unexpected_error;
68: END IF;
69:
70: IF FND_API.to_boolean(p_commit) THEN
71: COMMIT;

Line 70: IF FND_API.to_boolean(p_commit) THEN

66: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
67: RAISE FND_API.g_exc_unexpected_error;
68: END IF;
69:
70: IF FND_API.to_boolean(p_commit) THEN
71: COMMIT;
72: END IF;
73: x_return_status := FND_API.g_ret_sts_success;
74: FND_MSG_PUB.count_and_get(

Line 73: x_return_status := FND_API.g_ret_sts_success;

69:
70: IF FND_API.to_boolean(p_commit) THEN
71: COMMIT;
72: END IF;
73: x_return_status := FND_API.g_ret_sts_success;
74: FND_MSG_PUB.count_and_get(
75: p_encoded => FND_API.g_false,
76: p_count => x_msg_count,
77: p_data => x_msg_data

Line 75: p_encoded => FND_API.g_false,

71: COMMIT;
72: END IF;
73: x_return_status := FND_API.g_ret_sts_success;
74: FND_MSG_PUB.count_and_get(
75: p_encoded => FND_API.g_false,
76: p_count => x_msg_count,
77: p_data => x_msg_data
78: );
79:

Line 82: WHEN FND_API.g_exc_error THEN

78: );
79:
80: EXCEPTION
81:
82: WHEN FND_API.g_exc_error THEN
83: ROLLBACK TO create_listheader_pub;
84: x_return_status := FND_API.g_ret_sts_error;
85: FND_MSG_PUB.count_and_get(
86: p_encoded => FND_API.g_false,

Line 84: x_return_status := FND_API.g_ret_sts_error;

80: EXCEPTION
81:
82: WHEN FND_API.g_exc_error THEN
83: ROLLBACK TO create_listheader_pub;
84: x_return_status := FND_API.g_ret_sts_error;
85: FND_MSG_PUB.count_and_get(
86: p_encoded => FND_API.g_false,
87: p_count => x_msg_count,
88: p_data => x_msg_data

Line 86: p_encoded => FND_API.g_false,

82: WHEN FND_API.g_exc_error THEN
83: ROLLBACK TO create_listheader_pub;
84: x_return_status := FND_API.g_ret_sts_error;
85: FND_MSG_PUB.count_and_get(
86: p_encoded => FND_API.g_false,
87: p_count => x_msg_count,
88: p_data => x_msg_data
89: );
90:

Line 91: WHEN FND_API.g_exc_unexpected_error THEN

87: p_count => x_msg_count,
88: p_data => x_msg_data
89: );
90:
91: WHEN FND_API.g_exc_unexpected_error THEN
92: ROLLBACK TO create_listheader_pub;
93: x_return_status := FND_API.g_ret_sts_unexp_error ;
94: FND_MSG_PUB.count_and_get(
95: p_encoded => FND_API.g_false,

Line 93: x_return_status := FND_API.g_ret_sts_unexp_error ;

89: );
90:
91: WHEN FND_API.g_exc_unexpected_error THEN
92: ROLLBACK TO create_listheader_pub;
93: x_return_status := FND_API.g_ret_sts_unexp_error ;
94: FND_MSG_PUB.count_and_get(
95: p_encoded => FND_API.g_false,
96: p_count => x_msg_count,
97: p_data => x_msg_data

Line 95: p_encoded => FND_API.g_false,

91: WHEN FND_API.g_exc_unexpected_error THEN
92: ROLLBACK TO create_listheader_pub;
93: x_return_status := FND_API.g_ret_sts_unexp_error ;
94: FND_MSG_PUB.count_and_get(
95: p_encoded => FND_API.g_false,
96: p_count => x_msg_count,
97: p_data => x_msg_data
98: );
99:

Line 103: x_return_status := FND_API.g_ret_sts_unexp_error ;

99:
100:
101: WHEN OTHERS THEN
102: ROLLBACK TO create_listheader_pub;
103: x_return_status := FND_API.g_ret_sts_unexp_error ;
104:
105: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
106: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
107: END IF;

Line 110: p_encoded => FND_API.g_false,

106: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
107: END IF;
108:
109: FND_MSG_PUB.count_and_get(
110: p_encoded => FND_API.g_false,
111: p_count => x_msg_count,
112: p_data => x_msg_data
113: );
114: End Create_ListHeader;

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

132: -- End of Comments
133:
134: PROCEDURE Update_ListHeader
135: ( p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137: p_commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,

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

133:
134: PROCEDURE Update_ListHeader
135: ( p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137: p_commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,

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

134: PROCEDURE Update_ListHeader
135: ( p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137: p_commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_listheader_rec IN AMS_LISTHEADER_PVT.list_header_rec_type

Line 157: IF FND_API.to_boolean(p_init_msg_list) THEN

153:
154: SAVEPOINT update_listheader_pub;
155: -- initialize the message list;
156: -- won't do it again when calling private API
157: IF FND_API.to_boolean(p_init_msg_list) THEN
158: FND_MSG_PUB.initialize;
159: END IF;
160:
161: AMS_LISTHEADER_PVT.Update_ListHeader

Line 163: p_init_msg_list => FND_API.G_FALSE,

159: END IF;
160:
161: AMS_LISTHEADER_PVT.Update_ListHeader
162: ( p_api_version => p_api_version ,
163: p_init_msg_list => FND_API.G_FALSE,
164: p_commit => FND_API.G_FALSE,
165: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
166: x_return_status => l_return_status,
167: x_msg_count => x_msg_count,

Line 164: p_commit => FND_API.G_FALSE,

160:
161: AMS_LISTHEADER_PVT.Update_ListHeader
162: ( p_api_version => p_api_version ,
163: p_init_msg_list => FND_API.G_FALSE,
164: p_commit => FND_API.G_FALSE,
165: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
166: x_return_status => l_return_status,
167: x_msg_count => x_msg_count,
168: x_msg_data => x_msg_data,

Line 165: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

161: AMS_LISTHEADER_PVT.Update_ListHeader
162: ( p_api_version => p_api_version ,
163: p_init_msg_list => FND_API.G_FALSE,
164: p_commit => FND_API.G_FALSE,
165: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
166: x_return_status => l_return_status,
167: x_msg_count => x_msg_count,
168: x_msg_data => x_msg_data,
169: p_listheader_rec => l_listheader_rec );

Line 172: IF l_return_status = FND_API.g_ret_sts_error THEN

168: x_msg_data => x_msg_data,
169: p_listheader_rec => l_listheader_rec );
170:
171:
172: IF l_return_status = FND_API.g_ret_sts_error THEN
173: RAISE FND_API.g_exc_error;
174: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
175: RAISE FND_API.g_exc_unexpected_error;
176: END IF;

Line 173: RAISE FND_API.g_exc_error;

169: p_listheader_rec => l_listheader_rec );
170:
171:
172: IF l_return_status = FND_API.g_ret_sts_error THEN
173: RAISE FND_API.g_exc_error;
174: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
175: RAISE FND_API.g_exc_unexpected_error;
176: END IF;
177:

Line 174: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

170:
171:
172: IF l_return_status = FND_API.g_ret_sts_error THEN
173: RAISE FND_API.g_exc_error;
174: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
175: RAISE FND_API.g_exc_unexpected_error;
176: END IF;
177:
178:

Line 175: RAISE FND_API.g_exc_unexpected_error;

171:
172: IF l_return_status = FND_API.g_ret_sts_error THEN
173: RAISE FND_API.g_exc_error;
174: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
175: RAISE FND_API.g_exc_unexpected_error;
176: END IF;
177:
178:
179: IF FND_API.to_boolean(p_commit) THEN

Line 179: IF FND_API.to_boolean(p_commit) THEN

175: RAISE FND_API.g_exc_unexpected_error;
176: END IF;
177:
178:
179: IF FND_API.to_boolean(p_commit) THEN
180: COMMIT;
181: END IF;
182:
183:

Line 184: x_return_status := FND_API.g_ret_sts_success;

180: COMMIT;
181: END IF;
182:
183:
184: x_return_status := FND_API.g_ret_sts_success;
185: FND_MSG_PUB.count_and_get(
186: p_encoded => FND_API.g_false,
187: p_count => x_msg_count,
188: p_data => x_msg_data

Line 186: p_encoded => FND_API.g_false,

182:
183:
184: x_return_status := FND_API.g_ret_sts_success;
185: FND_MSG_PUB.count_and_get(
186: p_encoded => FND_API.g_false,
187: p_count => x_msg_count,
188: p_data => x_msg_data
189: );
190:

Line 193: WHEN FND_API.g_exc_error THEN

189: );
190:
191: EXCEPTION
192:
193: WHEN FND_API.g_exc_error THEN
194: ROLLBACK TO update_listheader_pub;
195: x_return_status := FND_API.g_ret_sts_error;
196: FND_MSG_PUB.count_and_get
197: (

Line 195: x_return_status := FND_API.g_ret_sts_error;

191: EXCEPTION
192:
193: WHEN FND_API.g_exc_error THEN
194: ROLLBACK TO update_listheader_pub;
195: x_return_status := FND_API.g_ret_sts_error;
196: FND_MSG_PUB.count_and_get
197: (
198: p_encoded => FND_API.g_false,
199: p_count => x_msg_count,

Line 198: p_encoded => FND_API.g_false,

194: ROLLBACK TO update_listheader_pub;
195: x_return_status := FND_API.g_ret_sts_error;
196: FND_MSG_PUB.count_and_get
197: (
198: p_encoded => FND_API.g_false,
199: p_count => x_msg_count,
200: p_data => x_msg_data
201: );
202:

Line 203: WHEN FND_API.g_exc_unexpected_error THEN

199: p_count => x_msg_count,
200: p_data => x_msg_data
201: );
202:
203: WHEN FND_API.g_exc_unexpected_error THEN
204: ROLLBACK TO update_listheader_pub;
205: x_return_status := FND_API.g_ret_sts_unexp_error ;
206: FND_MSG_PUB.count_and_get(
207: p_encoded => FND_API.g_false,

Line 205: x_return_status := FND_API.g_ret_sts_unexp_error ;

201: );
202:
203: WHEN FND_API.g_exc_unexpected_error THEN
204: ROLLBACK TO update_listheader_pub;
205: x_return_status := FND_API.g_ret_sts_unexp_error ;
206: FND_MSG_PUB.count_and_get(
207: p_encoded => FND_API.g_false,
208: p_count => x_msg_count,
209: p_data => x_msg_data

Line 207: p_encoded => FND_API.g_false,

203: WHEN FND_API.g_exc_unexpected_error THEN
204: ROLLBACK TO update_listheader_pub;
205: x_return_status := FND_API.g_ret_sts_unexp_error ;
206: FND_MSG_PUB.count_and_get(
207: p_encoded => FND_API.g_false,
208: p_count => x_msg_count,
209: p_data => x_msg_data
210: );
211:

Line 215: x_return_status := FND_API.g_ret_sts_unexp_error ;

211:
212:
213: WHEN OTHERS THEN
214: ROLLBACK TO update_listheader_pub;
215: x_return_status := FND_API.g_ret_sts_unexp_error ;
216: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
217: THEN
218: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
219: END IF;

Line 222: p_encoded => FND_API.g_false,

218: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
219: END IF;
220:
221: FND_MSG_PUB.count_and_get(
222: p_encoded => FND_API.g_false,
223: p_count => x_msg_count,
224: p_data => x_msg_data
225: );
226: End Update_ListHeader;

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

244: -- 05/12/1999 tdonohoe created
245: -- End of Comments
246: PROCEDURE Delete_ListHeader
247: ( p_api_version IN NUMBER,
248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
249: p_commit IN VARCHAR2 := FND_API.G_FALSE,
250: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,

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

245: -- End of Comments
246: PROCEDURE Delete_ListHeader
247: ( p_api_version IN NUMBER,
248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
249: p_commit IN VARCHAR2 := FND_API.G_FALSE,
250: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2,

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

246: PROCEDURE Delete_ListHeader
247: ( p_api_version IN NUMBER,
248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
249: p_commit IN VARCHAR2 := FND_API.G_FALSE,
250: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2,
254: p_listheader_id IN number) IS

Line 270: IF FND_API.to_boolean(p_init_msg_list) THEN

266: SAVEPOINT delete_listheader_pub;
267:
268: -- initialize the message list;
269: -- won't do it again when calling private API
270: IF FND_API.to_boolean(p_init_msg_list) THEN
271: FND_MSG_PUB.initialize;
272: END IF;
273:
274: AMS_LISTHEADER_PVT.Delete_ListHeader

Line 276: p_init_msg_list => FND_API.G_FALSE,

272: END IF;
273:
274: AMS_LISTHEADER_PVT.Delete_ListHeader
275: ( p_api_version => p_api_version,
276: p_init_msg_list => FND_API.G_FALSE,
277: p_commit => FND_API.G_FALSE,
278: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
279: x_return_status => l_return_status,
280: x_msg_count => x_msg_count,

Line 277: p_commit => FND_API.G_FALSE,

273:
274: AMS_LISTHEADER_PVT.Delete_ListHeader
275: ( p_api_version => p_api_version,
276: p_init_msg_list => FND_API.G_FALSE,
277: p_commit => FND_API.G_FALSE,
278: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
279: x_return_status => l_return_status,
280: x_msg_count => x_msg_count,
281: x_msg_data => x_msg_data ,

Line 278: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

274: AMS_LISTHEADER_PVT.Delete_ListHeader
275: ( p_api_version => p_api_version,
276: p_init_msg_list => FND_API.G_FALSE,
277: p_commit => FND_API.G_FALSE,
278: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
279: x_return_status => l_return_status,
280: x_msg_count => x_msg_count,
281: x_msg_data => x_msg_data ,
282: p_listheader_id => l_listheader_id);

Line 284: IF l_return_status = FND_API.g_ret_sts_error THEN

280: x_msg_count => x_msg_count,
281: x_msg_data => x_msg_data ,
282: p_listheader_id => l_listheader_id);
283:
284: IF l_return_status = FND_API.g_ret_sts_error THEN
285: RAISE FND_API.g_exc_error;
286: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
287: RAISE FND_API.g_exc_unexpected_error;
288: END IF;

Line 285: RAISE FND_API.g_exc_error;

281: x_msg_data => x_msg_data ,
282: p_listheader_id => l_listheader_id);
283:
284: IF l_return_status = FND_API.g_ret_sts_error THEN
285: RAISE FND_API.g_exc_error;
286: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
287: RAISE FND_API.g_exc_unexpected_error;
288: END IF;
289:

Line 286: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

282: p_listheader_id => l_listheader_id);
283:
284: IF l_return_status = FND_API.g_ret_sts_error THEN
285: RAISE FND_API.g_exc_error;
286: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
287: RAISE FND_API.g_exc_unexpected_error;
288: END IF;
289:
290: IF FND_API.to_boolean(p_commit) THEN

Line 287: RAISE FND_API.g_exc_unexpected_error;

283:
284: IF l_return_status = FND_API.g_ret_sts_error THEN
285: RAISE FND_API.g_exc_error;
286: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
287: RAISE FND_API.g_exc_unexpected_error;
288: END IF;
289:
290: IF FND_API.to_boolean(p_commit) THEN
291: COMMIT;

Line 290: IF FND_API.to_boolean(p_commit) THEN

286: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
287: RAISE FND_API.g_exc_unexpected_error;
288: END IF;
289:
290: IF FND_API.to_boolean(p_commit) THEN
291: COMMIT;
292: END IF;
293:
294: x_return_status := FND_API.g_ret_sts_success;

Line 294: x_return_status := FND_API.g_ret_sts_success;

290: IF FND_API.to_boolean(p_commit) THEN
291: COMMIT;
292: END IF;
293:
294: x_return_status := FND_API.g_ret_sts_success;
295: FND_MSG_PUB.count_and_get(
296: p_encoded => FND_API.g_false,
297: p_count => x_msg_count,
298: p_data => x_msg_data);

Line 296: p_encoded => FND_API.g_false,

292: END IF;
293:
294: x_return_status := FND_API.g_ret_sts_success;
295: FND_MSG_PUB.count_and_get(
296: p_encoded => FND_API.g_false,
297: p_count => x_msg_count,
298: p_data => x_msg_data);
299:
300:

Line 303: WHEN FND_API.g_exc_error THEN

299:
300:
301: EXCEPTION
302:
303: WHEN FND_API.g_exc_error THEN
304: ROLLBACK TO delete_listheader_pub;
305: x_return_status := FND_API.g_ret_sts_error;
306: FND_MSG_PUB.count_and_get(
307: p_encoded => FND_API.g_false,

Line 305: x_return_status := FND_API.g_ret_sts_error;

301: EXCEPTION
302:
303: WHEN FND_API.g_exc_error THEN
304: ROLLBACK TO delete_listheader_pub;
305: x_return_status := FND_API.g_ret_sts_error;
306: FND_MSG_PUB.count_and_get(
307: p_encoded => FND_API.g_false,
308: p_count => x_msg_count,
309: p_data => x_msg_data

Line 307: p_encoded => FND_API.g_false,

303: WHEN FND_API.g_exc_error THEN
304: ROLLBACK TO delete_listheader_pub;
305: x_return_status := FND_API.g_ret_sts_error;
306: FND_MSG_PUB.count_and_get(
307: p_encoded => FND_API.g_false,
308: p_count => x_msg_count,
309: p_data => x_msg_data
310: );
311:

Line 312: WHEN FND_API.g_exc_unexpected_error THEN

308: p_count => x_msg_count,
309: p_data => x_msg_data
310: );
311:
312: WHEN FND_API.g_exc_unexpected_error THEN
313: ROLLBACK TO delete_listheader_pub;
314: x_return_status := FND_API.g_ret_sts_unexp_error ;
315: FND_MSG_PUB.count_and_get(
316: p_encoded => FND_API.g_false,

Line 314: x_return_status := FND_API.g_ret_sts_unexp_error ;

310: );
311:
312: WHEN FND_API.g_exc_unexpected_error THEN
313: ROLLBACK TO delete_listheader_pub;
314: x_return_status := FND_API.g_ret_sts_unexp_error ;
315: FND_MSG_PUB.count_and_get(
316: p_encoded => FND_API.g_false,
317: p_count => x_msg_count,
318: p_data => x_msg_data

Line 316: p_encoded => FND_API.g_false,

312: WHEN FND_API.g_exc_unexpected_error THEN
313: ROLLBACK TO delete_listheader_pub;
314: x_return_status := FND_API.g_ret_sts_unexp_error ;
315: FND_MSG_PUB.count_and_get(
316: p_encoded => FND_API.g_false,
317: p_count => x_msg_count,
318: p_data => x_msg_data
319: );
320:

Line 324: x_return_status := FND_API.g_ret_sts_unexp_error ;

320:
321:
322: WHEN OTHERS THEN
323: ROLLBACK TO delete_listheader_pub;
324: x_return_status := FND_API.g_ret_sts_unexp_error ;
325:
326: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
327: THEN
328: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 332: p_encoded => FND_API.g_false,

328: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
329: END IF;
330:
331: FND_MSG_PUB.count_and_get(
332: p_encoded => FND_API.g_false,
333: p_count => x_msg_count,
334: p_data => x_msg_data
335: );
336:

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

353:
354:
355: PROCEDURE Lock_ListHeader
356: ( p_api_version IN NUMBER,
357: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
358: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
359: x_return_status OUT NOCOPY VARCHAR2,
360: x_msg_count OUT NOCOPY NUMBER,
361: x_msg_data OUT NOCOPY VARCHAR2,

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

354:
355: PROCEDURE Lock_ListHeader
356: ( p_api_version IN NUMBER,
357: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
358: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
359: x_return_status OUT NOCOPY VARCHAR2,
360: x_msg_count OUT NOCOPY NUMBER,
361: x_msg_data OUT NOCOPY VARCHAR2,
362: p_listheader_id IN NUMBER,

Line 381: IF FND_API.to_boolean(p_init_msg_list) THEN

377: SAVEPOINT lock_listheader_pub;
378:
379: -- initialize the message list;
380: -- won't do it again when calling private API
381: IF FND_API.to_boolean(p_init_msg_list) THEN
382: FND_MSG_PUB.initialize;
383: END IF;
384:
385: AMS_LISTHEADER_PVT.Lock_ListHeader

Line 387: p_init_msg_list => FND_API.G_FALSE,

383: END IF;
384:
385: AMS_LISTHEADER_PVT.Lock_ListHeader
386: ( p_api_version => p_api_version,
387: p_init_msg_list => FND_API.G_FALSE,
388: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
389: x_return_status => l_return_status,
390: x_msg_count => x_msg_count ,
391: x_msg_data => x_msg_data,

Line 388: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

384:
385: AMS_LISTHEADER_PVT.Lock_ListHeader
386: ( p_api_version => p_api_version,
387: p_init_msg_list => FND_API.G_FALSE,
388: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
389: x_return_status => l_return_status,
390: x_msg_count => x_msg_count ,
391: x_msg_data => x_msg_data,
392: p_listheader_id => l_listheader_id ,

Line 395: IF l_return_status = FND_API.g_ret_sts_error THEN

391: x_msg_data => x_msg_data,
392: p_listheader_id => l_listheader_id ,
393: p_object_version => l_object_version);
394:
395: IF l_return_status = FND_API.g_ret_sts_error THEN
396: RAISE FND_API.g_exc_error;
397: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
398: RAISE FND_API.g_exc_unexpected_error;
399: END IF;

Line 396: RAISE FND_API.g_exc_error;

392: p_listheader_id => l_listheader_id ,
393: p_object_version => l_object_version);
394:
395: IF l_return_status = FND_API.g_ret_sts_error THEN
396: RAISE FND_API.g_exc_error;
397: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
398: RAISE FND_API.g_exc_unexpected_error;
399: END IF;
400:

Line 397: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

393: p_object_version => l_object_version);
394:
395: IF l_return_status = FND_API.g_ret_sts_error THEN
396: RAISE FND_API.g_exc_error;
397: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
398: RAISE FND_API.g_exc_unexpected_error;
399: END IF;
400:
401: x_return_status := FND_API.g_ret_sts_success;

Line 398: RAISE FND_API.g_exc_unexpected_error;

394:
395: IF l_return_status = FND_API.g_ret_sts_error THEN
396: RAISE FND_API.g_exc_error;
397: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
398: RAISE FND_API.g_exc_unexpected_error;
399: END IF;
400:
401: x_return_status := FND_API.g_ret_sts_success;
402: FND_MSG_PUB.count_and_get(

Line 401: x_return_status := FND_API.g_ret_sts_success;

397: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
398: RAISE FND_API.g_exc_unexpected_error;
399: END IF;
400:
401: x_return_status := FND_API.g_ret_sts_success;
402: FND_MSG_PUB.count_and_get(
403: p_encoded => FND_API.g_false,
404: p_count => x_msg_count,
405: p_data => x_msg_data

Line 403: p_encoded => FND_API.g_false,

399: END IF;
400:
401: x_return_status := FND_API.g_ret_sts_success;
402: FND_MSG_PUB.count_and_get(
403: p_encoded => FND_API.g_false,
404: p_count => x_msg_count,
405: p_data => x_msg_data
406: );
407:

Line 410: WHEN FND_API.g_exc_error THEN

406: );
407:
408: EXCEPTION
409:
410: WHEN FND_API.g_exc_error THEN
411: ROLLBACK TO lock_ListHeader_pub;
412: x_return_status := FND_API.g_ret_sts_error;
413: FND_MSG_PUB.count_and_get(
414: p_encoded => FND_API.g_false,

Line 412: x_return_status := FND_API.g_ret_sts_error;

408: EXCEPTION
409:
410: WHEN FND_API.g_exc_error THEN
411: ROLLBACK TO lock_ListHeader_pub;
412: x_return_status := FND_API.g_ret_sts_error;
413: FND_MSG_PUB.count_and_get(
414: p_encoded => FND_API.g_false,
415: p_count => x_msg_count,
416: p_data => x_msg_data

Line 414: p_encoded => FND_API.g_false,

410: WHEN FND_API.g_exc_error THEN
411: ROLLBACK TO lock_ListHeader_pub;
412: x_return_status := FND_API.g_ret_sts_error;
413: FND_MSG_PUB.count_and_get(
414: p_encoded => FND_API.g_false,
415: p_count => x_msg_count,
416: p_data => x_msg_data
417: );
418:

Line 419: WHEN FND_API.g_exc_unexpected_error THEN

415: p_count => x_msg_count,
416: p_data => x_msg_data
417: );
418:
419: WHEN FND_API.g_exc_unexpected_error THEN
420: ROLLBACK TO lock_ListHeader_pub;
421: x_return_status := FND_API.g_ret_sts_unexp_error ;
422: FND_MSG_PUB.count_and_get(
423: p_encoded => FND_API.g_false,

Line 421: x_return_status := FND_API.g_ret_sts_unexp_error ;

417: );
418:
419: WHEN FND_API.g_exc_unexpected_error THEN
420: ROLLBACK TO lock_ListHeader_pub;
421: x_return_status := FND_API.g_ret_sts_unexp_error ;
422: FND_MSG_PUB.count_and_get(
423: p_encoded => FND_API.g_false,
424: p_count => x_msg_count,
425: p_data => x_msg_data

Line 423: p_encoded => FND_API.g_false,

419: WHEN FND_API.g_exc_unexpected_error THEN
420: ROLLBACK TO lock_ListHeader_pub;
421: x_return_status := FND_API.g_ret_sts_unexp_error ;
422: FND_MSG_PUB.count_and_get(
423: p_encoded => FND_API.g_false,
424: p_count => x_msg_count,
425: p_data => x_msg_data
426: );
427:

Line 431: x_return_status := FND_API.g_ret_sts_unexp_error ;

427:
428:
429: WHEN OTHERS THEN
430: ROLLBACK TO lock_ListHeader_pub;
431: x_return_status := FND_API.g_ret_sts_unexp_error ;
432:
433: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
434: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
435: END IF;

Line 438: p_encoded => FND_API.g_false,

434: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
435: END IF;
436:
437: FND_MSG_PUB.count_and_get(
438: p_encoded => FND_API.g_false,
439: p_count => x_msg_count,
440: p_data => x_msg_data
441: );
442: End Lock_ListHeader;

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

453: -- p_listheader_rec: the list header record to be validated
454: --
455: -- NOTES
456: -- 1. p_listheader_rec_rec should be the complete list header record. There
457: -- should not be any FND_API.g_miss_char/num/date in it.
458: ----------------------------------------------------------------------
459: -- End Of Comments
460:
461:

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

460:
461:
462: PROCEDURE Validate_ListHeader
463: ( p_api_version IN NUMBER,
464: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
465: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
466: x_return_status OUT NOCOPY VARCHAR2,
467: x_msg_count OUT NOCOPY NUMBER,
468: x_msg_data OUT NOCOPY VARCHAR2,

Line 465: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

461:
462: PROCEDURE Validate_ListHeader
463: ( p_api_version IN NUMBER,
464: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
465: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
466: x_return_status OUT NOCOPY VARCHAR2,
467: x_msg_count OUT NOCOPY NUMBER,
468: x_msg_data OUT NOCOPY VARCHAR2,
469: p_listheader_rec IN ams_listheader_pvt.list_header_rec_type

Line 485: IF FND_API.to_boolean(p_init_msg_list) THEN

481: SAVEPOINT validate_listheader_pub;
482:
483: -- initialize the message list;
484: -- won't do it again when calling private API
485: IF FND_API.to_boolean(p_init_msg_list) THEN
486: FND_MSG_PUB.initialize;
487: END IF;
488:
489: AMS_LISTHEADER_PVT.Validate_ListHeader

Line 491: p_init_msg_list => FND_API.G_FALSE,

487: END IF;
488:
489: AMS_LISTHEADER_PVT.Validate_ListHeader
490: ( p_api_version => p_api_version,
491: p_init_msg_list => FND_API.G_FALSE,
492: p_validation_level => FND_API.g_valid_level_full,
493: x_return_status => l_return_status,
494: x_msg_count => x_msg_count,
495: x_msg_data => x_msg_data,

Line 492: p_validation_level => FND_API.g_valid_level_full,

488:
489: AMS_LISTHEADER_PVT.Validate_ListHeader
490: ( p_api_version => p_api_version,
491: p_init_msg_list => FND_API.G_FALSE,
492: p_validation_level => FND_API.g_valid_level_full,
493: x_return_status => l_return_status,
494: x_msg_count => x_msg_count,
495: x_msg_data => x_msg_data,
496: p_listheader_rec => l_listheader_rec);

Line 498: IF l_return_status = FND_API.g_ret_sts_error THEN

494: x_msg_count => x_msg_count,
495: x_msg_data => x_msg_data,
496: p_listheader_rec => l_listheader_rec);
497:
498: IF l_return_status = FND_API.g_ret_sts_error THEN
499: RAISE FND_API.g_exc_error;
500: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
501: RAISE FND_API.g_exc_unexpected_error;
502: END IF;

Line 499: RAISE FND_API.g_exc_error;

495: x_msg_data => x_msg_data,
496: p_listheader_rec => l_listheader_rec);
497:
498: IF l_return_status = FND_API.g_ret_sts_error THEN
499: RAISE FND_API.g_exc_error;
500: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
501: RAISE FND_API.g_exc_unexpected_error;
502: END IF;
503:

Line 500: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

496: p_listheader_rec => l_listheader_rec);
497:
498: IF l_return_status = FND_API.g_ret_sts_error THEN
499: RAISE FND_API.g_exc_error;
500: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
501: RAISE FND_API.g_exc_unexpected_error;
502: END IF;
503:
504: x_return_status := FND_API.g_ret_sts_success;

Line 501: RAISE FND_API.g_exc_unexpected_error;

497:
498: IF l_return_status = FND_API.g_ret_sts_error THEN
499: RAISE FND_API.g_exc_error;
500: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
501: RAISE FND_API.g_exc_unexpected_error;
502: END IF;
503:
504: x_return_status := FND_API.g_ret_sts_success;
505: FND_MSG_PUB.count_and_get(

Line 504: x_return_status := FND_API.g_ret_sts_success;

500: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
501: RAISE FND_API.g_exc_unexpected_error;
502: END IF;
503:
504: x_return_status := FND_API.g_ret_sts_success;
505: FND_MSG_PUB.count_and_get(
506: p_encoded => FND_API.g_false,
507: p_count => x_msg_count,
508: p_data => x_msg_data

Line 506: p_encoded => FND_API.g_false,

502: END IF;
503:
504: x_return_status := FND_API.g_ret_sts_success;
505: FND_MSG_PUB.count_and_get(
506: p_encoded => FND_API.g_false,
507: p_count => x_msg_count,
508: p_data => x_msg_data
509: );
510:

Line 513: WHEN FND_API.g_exc_error THEN

509: );
510:
511: EXCEPTION
512:
513: WHEN FND_API.g_exc_error THEN
514: ROLLBACK TO validate_listheader_pub;
515: x_return_status := FND_API.g_ret_sts_error;
516: FND_MSG_PUB.count_and_get(
517: p_encoded => FND_API.g_false,

Line 515: x_return_status := FND_API.g_ret_sts_error;

511: EXCEPTION
512:
513: WHEN FND_API.g_exc_error THEN
514: ROLLBACK TO validate_listheader_pub;
515: x_return_status := FND_API.g_ret_sts_error;
516: FND_MSG_PUB.count_and_get(
517: p_encoded => FND_API.g_false,
518: p_count => x_msg_count,
519: p_data => x_msg_data

Line 517: p_encoded => FND_API.g_false,

513: WHEN FND_API.g_exc_error THEN
514: ROLLBACK TO validate_listheader_pub;
515: x_return_status := FND_API.g_ret_sts_error;
516: FND_MSG_PUB.count_and_get(
517: p_encoded => FND_API.g_false,
518: p_count => x_msg_count,
519: p_data => x_msg_data
520: );
521:

Line 522: WHEN FND_API.g_exc_unexpected_error THEN

518: p_count => x_msg_count,
519: p_data => x_msg_data
520: );
521:
522: WHEN FND_API.g_exc_unexpected_error THEN
523: ROLLBACK TO validate_listheader_pub;
524: x_return_status := FND_API.g_ret_sts_unexp_error ;
525: FND_MSG_PUB.count_and_get(
526: p_encoded => FND_API.g_false,

Line 524: x_return_status := FND_API.g_ret_sts_unexp_error ;

520: );
521:
522: WHEN FND_API.g_exc_unexpected_error THEN
523: ROLLBACK TO validate_listheader_pub;
524: x_return_status := FND_API.g_ret_sts_unexp_error ;
525: FND_MSG_PUB.count_and_get(
526: p_encoded => FND_API.g_false,
527: p_count => x_msg_count,
528: p_data => x_msg_data

Line 526: p_encoded => FND_API.g_false,

522: WHEN FND_API.g_exc_unexpected_error THEN
523: ROLLBACK TO validate_listheader_pub;
524: x_return_status := FND_API.g_ret_sts_unexp_error ;
525: FND_MSG_PUB.count_and_get(
526: p_encoded => FND_API.g_false,
527: p_count => x_msg_count,
528: p_data => x_msg_data
529: );
530:

Line 534: x_return_status := FND_API.g_ret_sts_unexp_error ;

530:
531:
532: WHEN OTHERS THEN
533: ROLLBACK TO validate_listheader_pub;
534: x_return_status := FND_API.g_ret_sts_unexp_error ;
535:
536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
537: THEN
538: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 542: p_encoded => FND_API.g_false,

538: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
539: END IF;
540:
541: FND_MSG_PUB.count_and_get(
542: p_encoded => FND_API.g_false,
543: p_count => x_msg_count,
544: p_data => x_msg_data
545: );
546:

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

547: END validate_listheader;
548:
549: PROCEDURE Copy_List
550: ( p_api_version IN NUMBER,
551: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
552: p_commit IN VARCHAR2 := FND_API.G_FALSE,
553: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
554: x_return_status OUT NOCOPY VARCHAR2,
555: x_msg_count OUT NOCOPY NUMBER,

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

548:
549: PROCEDURE Copy_List
550: ( p_api_version IN NUMBER,
551: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
552: p_commit IN VARCHAR2 := FND_API.G_FALSE,
553: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
554: x_return_status OUT NOCOPY VARCHAR2,
555: x_msg_count OUT NOCOPY NUMBER,
556: x_msg_data OUT NOCOPY VARCHAR2,

Line 553: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

549: PROCEDURE Copy_List
550: ( p_api_version IN NUMBER,
551: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
552: p_commit IN VARCHAR2 := FND_API.G_FALSE,
553: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
554: x_return_status OUT NOCOPY VARCHAR2,
555: x_msg_count OUT NOCOPY NUMBER,
556: x_msg_data OUT NOCOPY VARCHAR2,
557: p_source_listheader_id IN NUMBER,

Line 576: IF FND_API.to_boolean(p_init_msg_list) THEN

572:
573: SAVEPOINT copy_list_pub;
574: -- initialize the message list;
575: -- won't do it again when calling private API
576: IF FND_API.to_boolean(p_init_msg_list) THEN
577: FND_MSG_PUB.initialize;
578: END IF;
579:
580: --call private API procedure.

Line 583: p_init_msg_list => FND_API.G_FALSE,

579:
580: --call private API procedure.
581: AMS_LISTHEADER_PVT.Copy_List
582: ( p_api_version => p_api_version,
583: p_init_msg_list => FND_API.G_FALSE,
584: p_commit => FND_API.G_FALSE,
585: p_validation_level => FND_API.g_valid_level_full,
586: x_return_status => l_return_status,
587: x_msg_count => x_msg_count,

Line 584: p_commit => FND_API.G_FALSE,

580: --call private API procedure.
581: AMS_LISTHEADER_PVT.Copy_List
582: ( p_api_version => p_api_version,
583: p_init_msg_list => FND_API.G_FALSE,
584: p_commit => FND_API.G_FALSE,
585: p_validation_level => FND_API.g_valid_level_full,
586: x_return_status => l_return_status,
587: x_msg_count => x_msg_count,
588: x_msg_data => x_msg_data,

Line 585: p_validation_level => FND_API.g_valid_level_full,

581: AMS_LISTHEADER_PVT.Copy_List
582: ( p_api_version => p_api_version,
583: p_init_msg_list => FND_API.G_FALSE,
584: p_commit => FND_API.G_FALSE,
585: p_validation_level => FND_API.g_valid_level_full,
586: x_return_status => l_return_status,
587: x_msg_count => x_msg_count,
588: x_msg_data => x_msg_data,
589: p_source_listheader_id =>p_source_listheader_id,

Line 597: IF l_return_status = FND_API.g_ret_sts_error THEN

593: p_copy_list_entries =>p_copy_list_entries,
594: x_listheader_id => x_listheader_id);
595:
596:
597: IF l_return_status = FND_API.g_ret_sts_error THEN
598: RAISE FND_API.g_exc_error;
599: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
600: RAISE FND_API.g_exc_unexpected_error;
601: END IF;

Line 598: RAISE FND_API.g_exc_error;

594: x_listheader_id => x_listheader_id);
595:
596:
597: IF l_return_status = FND_API.g_ret_sts_error THEN
598: RAISE FND_API.g_exc_error;
599: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
600: RAISE FND_API.g_exc_unexpected_error;
601: END IF;
602:

Line 599: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

595:
596:
597: IF l_return_status = FND_API.g_ret_sts_error THEN
598: RAISE FND_API.g_exc_error;
599: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
600: RAISE FND_API.g_exc_unexpected_error;
601: END IF;
602:
603: IF FND_API.to_boolean(p_commit) THEN

Line 600: RAISE FND_API.g_exc_unexpected_error;

596:
597: IF l_return_status = FND_API.g_ret_sts_error THEN
598: RAISE FND_API.g_exc_error;
599: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
600: RAISE FND_API.g_exc_unexpected_error;
601: END IF;
602:
603: IF FND_API.to_boolean(p_commit) THEN
604: COMMIT;

Line 603: IF FND_API.to_boolean(p_commit) THEN

599: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
600: RAISE FND_API.g_exc_unexpected_error;
601: END IF;
602:
603: IF FND_API.to_boolean(p_commit) THEN
604: COMMIT;
605: END IF;
606: x_return_status := FND_API.g_ret_sts_success;
607: FND_MSG_PUB.count_and_get(

Line 606: x_return_status := FND_API.g_ret_sts_success;

602:
603: IF FND_API.to_boolean(p_commit) THEN
604: COMMIT;
605: END IF;
606: x_return_status := FND_API.g_ret_sts_success;
607: FND_MSG_PUB.count_and_get(
608: p_encoded => FND_API.g_false,
609: p_count => x_msg_count,
610: p_data => x_msg_data

Line 608: p_encoded => FND_API.g_false,

604: COMMIT;
605: END IF;
606: x_return_status := FND_API.g_ret_sts_success;
607: FND_MSG_PUB.count_and_get(
608: p_encoded => FND_API.g_false,
609: p_count => x_msg_count,
610: p_data => x_msg_data
611: );
612:

Line 615: WHEN FND_API.g_exc_error THEN

611: );
612:
613: EXCEPTION
614:
615: WHEN FND_API.g_exc_error THEN
616: ROLLBACK TO copy_list_pub;
617: x_return_status := FND_API.g_ret_sts_error;
618: FND_MSG_PUB.count_and_get(
619: p_encoded => FND_API.g_false,

Line 617: x_return_status := FND_API.g_ret_sts_error;

613: EXCEPTION
614:
615: WHEN FND_API.g_exc_error THEN
616: ROLLBACK TO copy_list_pub;
617: x_return_status := FND_API.g_ret_sts_error;
618: FND_MSG_PUB.count_and_get(
619: p_encoded => FND_API.g_false,
620: p_count => x_msg_count,
621: p_data => x_msg_data

Line 619: p_encoded => FND_API.g_false,

615: WHEN FND_API.g_exc_error THEN
616: ROLLBACK TO copy_list_pub;
617: x_return_status := FND_API.g_ret_sts_error;
618: FND_MSG_PUB.count_and_get(
619: p_encoded => FND_API.g_false,
620: p_count => x_msg_count,
621: p_data => x_msg_data
622: );
623:

Line 624: WHEN FND_API.g_exc_unexpected_error THEN

620: p_count => x_msg_count,
621: p_data => x_msg_data
622: );
623:
624: WHEN FND_API.g_exc_unexpected_error THEN
625: ROLLBACK TO copy_list_pub;
626: x_return_status := FND_API.g_ret_sts_unexp_error ;
627: FND_MSG_PUB.count_and_get(
628: p_encoded => FND_API.g_false,

Line 626: x_return_status := FND_API.g_ret_sts_unexp_error ;

622: );
623:
624: WHEN FND_API.g_exc_unexpected_error THEN
625: ROLLBACK TO copy_list_pub;
626: x_return_status := FND_API.g_ret_sts_unexp_error ;
627: FND_MSG_PUB.count_and_get(
628: p_encoded => FND_API.g_false,
629: p_count => x_msg_count,
630: p_data => x_msg_data

Line 628: p_encoded => FND_API.g_false,

624: WHEN FND_API.g_exc_unexpected_error THEN
625: ROLLBACK TO copy_list_pub;
626: x_return_status := FND_API.g_ret_sts_unexp_error ;
627: FND_MSG_PUB.count_and_get(
628: p_encoded => FND_API.g_false,
629: p_count => x_msg_count,
630: p_data => x_msg_data
631: );
632:

Line 636: x_return_status := FND_API.g_ret_sts_unexp_error ;

632:
633:
634: WHEN OTHERS THEN
635: ROLLBACK TO copy_list_pub;
636: x_return_status := FND_API.g_ret_sts_unexp_error ;
637:
638: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
639: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
640: END IF;

Line 643: p_encoded => FND_API.g_false,

639: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
640: END IF;
641:
642: FND_MSG_PUB.count_and_get(
643: p_encoded => FND_API.g_false,
644: p_count => x_msg_count,
645: p_data => x_msg_data
646: );
647: End copy_list;