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_PVT dependencies on FND_MSG_PUB

Line 44: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

40:
41: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_ListHeader_PVT';
42: G_FILE_NAME CONSTANT VARCHAR2(12):='amsvlshb.pls';
43:
44: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
45: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
46: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
47:
48: -- Start of Comments

Line 45: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

41: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_ListHeader_PVT';
42: G_FILE_NAME CONSTANT VARCHAR2(12):='amsvlshb.pls';
43:
44: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
45: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
46: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
47:
48: -- Start of Comments
49: --

Line 46: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

42: G_FILE_NAME CONSTANT VARCHAR2(12):='amsvlshb.pls';
43:
44: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
45: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
46: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
47:
48: -- Start of Comments
49: --
50: -- NAME

Line 106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

102: ----------------------- ENABLE_LOG_FLAG ------------------------
103: IF p_listheader_rec.ENABLE_LOG_FLAG <> FND_API.g_miss_char
104: AND p_listheader_rec.ENABLE_LOG_FLAG IS NOT NULL THEN
105: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.ENABLE_LOG_FLAG) = FND_API.g_false THEN
106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
107: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_LOG_FLAG');
108: FND_MSG_PUB.add;
109: END IF;
110: x_return_status := FND_API.g_ret_sts_error;

Line 108: FND_MSG_PUB.add;

104: AND p_listheader_rec.ENABLE_LOG_FLAG IS NOT NULL THEN
105: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.ENABLE_LOG_FLAG) = FND_API.g_false THEN
106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
107: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_LOG_FLAG');
108: FND_MSG_PUB.add;
109: END IF;
110: x_return_status := FND_API.g_ret_sts_error;
111: RETURN;
112: END IF;

Line 119: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

115: ----------------------- ENABLE_WORD_REPLACEMENT_FLAG------------------------
116: IF p_listheader_rec.ENABLE_WORD_REPLACEMENT_FLAG <> FND_API.g_miss_char
117: AND p_listheader_rec.ENABLE_WORD_REPLACEMENT_FLAG IS NOT NULL THEN
118: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.ENABLE_WORD_REPLACEMENT_FLAG) = FND_API.g_false THEN
119: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
120: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_WORD_FLAG');
121: FND_MSG_PUB.add;
122: END IF;
123:

Line 121: FND_MSG_PUB.add;

117: AND p_listheader_rec.ENABLE_WORD_REPLACEMENT_FLAG IS NOT NULL THEN
118: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.ENABLE_WORD_REPLACEMENT_FLAG) = FND_API.g_false THEN
119: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
120: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_WORD_FLAG');
121: FND_MSG_PUB.add;
122: END IF;
123:
124: x_return_status := FND_API.g_ret_sts_error;
125: RETURN;

Line 133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

129: ----------------------- ENABLE_PARALLEL_DML_FLAG------------------------
130: IF p_listheader_rec.ENABLE_PARALLEL_DML_FLAG <> FND_API.g_miss_char
131: AND p_listheader_rec.ENABLE_PARALLEL_DML_FLAG IS NOT NULL THEN
132: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.ENABLE_PARALLEL_DML_FLAG) = FND_API.g_false THEN
133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
134: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_DML_FLAG');
135: FND_MSG_PUB.add;
136: END IF;
137:

Line 135: FND_MSG_PUB.add;

131: AND p_listheader_rec.ENABLE_PARALLEL_DML_FLAG IS NOT NULL THEN
132: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.ENABLE_PARALLEL_DML_FLAG) = FND_API.g_false THEN
133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
134: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_DML_FLAG');
135: FND_MSG_PUB.add;
136: END IF;
137:
138: x_return_status := FND_API.g_ret_sts_error;
139: RETURN;

Line 147: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

143: ----------------------- DEDUPE_DURING_GENERATION_FLAG ------------------------
144: IF p_listheader_rec.DEDUPE_DURING_GENERATION_FLAG <> FND_API.g_miss_char
145: AND p_listheader_rec.DEDUPE_DURING_GENERATION_FLAG IS NOT NULL THEN
146: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.DEDUPE_DURING_GENERATION_FLAG) = FND_API.g_false THEN
147: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
148: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_DEDUPE_FLAG');
149: FND_MSG_PUB.add;
150: END IF;
151:

Line 149: FND_MSG_PUB.add;

145: AND p_listheader_rec.DEDUPE_DURING_GENERATION_FLAG IS NOT NULL THEN
146: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.DEDUPE_DURING_GENERATION_FLAG) = FND_API.g_false THEN
147: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
148: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_DEDUPE_FLAG');
149: FND_MSG_PUB.add;
150: END IF;
151:
152: x_return_status := FND_API.g_ret_sts_error;
153: RETURN;

Line 162: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

158: IF p_listheader_rec.GENERATE_CONTROL_GROUP_FLAG <> FND_API.g_miss_char
159: AND p_listheader_rec.GENERATE_CONTROL_GROUP_FLAG IS NOT NULL THEN
160: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.GENERATE_CONTROL_GROUP_FLAG) = FND_API.g_false
161: THEN
162: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
163: THEN
164: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_CONTROL_FLAG');
165: FND_MSG_PUB.add;
166: END IF;

Line 165: FND_MSG_PUB.add;

161: THEN
162: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
163: THEN
164: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_CONTROL_FLAG');
165: FND_MSG_PUB.add;
166: END IF;
167:
168: x_return_status := FND_API.g_ret_sts_error;
169: RETURN;

Line 180: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

176: AND p_listheader_rec.LAST_GENERATION_SUCCESS_FLAG IS NOT NULL
177: THEN
178: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.LAST_GENERATION_SUCCESS_FLAG ) = FND_API.g_false
179: THEN
180: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
181: THEN
182: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_GEN_FLAG');
183: FND_MSG_PUB.add;
184: END IF;

Line 183: FND_MSG_PUB.add;

179: THEN
180: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
181: THEN
182: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_GEN_FLAG');
183: FND_MSG_PUB.add;
184: END IF;
185:
186: x_return_status := FND_API.g_ret_sts_error;
187: RETURN;

Line 199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

195: AND p_listheader_rec.ENABLED_FLAG IS NOT NULL
196: THEN
197: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.ENABLED_FLAG ) = FND_API.g_false
198: THEN
199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
200: THEN
201: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_ENABLED_FLAG');
202: FND_MSG_PUB.add;
203: END IF;

Line 202: FND_MSG_PUB.add;

198: THEN
199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
200: THEN
201: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_ENABLED_FLAG');
202: FND_MSG_PUB.add;
203: END IF;
204:
205: x_return_status := FND_API.g_ret_sts_error;
206: RETURN;

Line 218: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

214: AND p_listheader_rec.PURGE_FLAG IS NOT NULL
215: THEN
216: IF AMS_Utility_PVT.is_Y_or_N(p_listheader_rec.PURGE_FLAG ) = FND_API.g_false
217: THEN
218: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
219: THEN
220: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_PURGE_FLAG');
221: FND_MSG_PUB.add;
222: END IF;

Line 221: FND_MSG_PUB.add;

217: THEN
218: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
219: THEN
220: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_PURGE_FLAG');
221: FND_MSG_PUB.add;
222: END IF;
223:
224: x_return_status := FND_API.g_ret_sts_error;
225: RETURN;

Line 266: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

262: x_system_status_code => x_status_code,
263: x_return_status => x_return_status) ;
264:
265: if x_return_status = FND_API.g_ret_sts_error THEN
266: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
267: FND_MESSAGE.set_name('AMS', 'AMS_LIST_STATUS_INVALID');
268: FND_MSG_PUB.add;
269: END IF;
270: RETURN;

Line 268: FND_MSG_PUB.add;

264:
265: if x_return_status = FND_API.g_ret_sts_error THEN
266: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
267: FND_MESSAGE.set_name('AMS', 'AMS_LIST_STATUS_INVALID');
268: FND_MSG_PUB.add;
269: END IF;
270: RETURN;
271: end if;
272: END IF;

Line 282: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

278: IF AMS_Utility_PVT.check_lookup_exists(
279: p_lookup_type => 'AMS_LIST_STATUS',
280: p_lookup_code => p_listheader_rec.status_code
281: ) = FND_API.g_false THEN
282: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
283: FND_MESSAGE.set_name('AMS', 'AMS_LIST_STATUS_INVALID');
284: FND_MSG_PUB.add;
285: END IF;
286:

Line 284: FND_MSG_PUB.add;

280: p_lookup_code => p_listheader_rec.status_code
281: ) = FND_API.g_false THEN
282: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
283: FND_MESSAGE.set_name('AMS', 'AMS_LIST_STATUS_INVALID');
284: FND_MSG_PUB.add;
285: END IF;
286:
287: x_return_status := FND_API.g_ret_sts_error;
288: RETURN;

Line 300: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

296: IF AMS_Utility_PVT.check_lookup_exists(
297: p_lookup_type => 'AMS_LIST_GENERATION_TYPE',
298: p_lookup_code => p_listheader_rec.generation_type
299: ) = FND_API.g_false THEN
300: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
301: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_GEN_TYPE');
302: FND_MSG_PUB.add;
303: END IF;
304: x_return_status := FND_API.g_ret_sts_error;

Line 302: FND_MSG_PUB.add;

298: p_lookup_code => p_listheader_rec.generation_type
299: ) = FND_API.g_false THEN
300: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
301: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_GEN_TYPE');
302: FND_MSG_PUB.add;
303: END IF;
304: x_return_status := FND_API.g_ret_sts_error;
305: RETURN;
306: END IF;

Line 316: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

312: IF AMS_Utility_PVT.check_lookup_exists(
313: p_lookup_type => 'AMS_LIST_ROW_SELECT_TYPE',
314: p_lookup_code => p_listheader_rec.row_selection_type
315: ) = FND_API.g_false THEN
316: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
317: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_ROW_SELECT_TYPE');
318: FND_MSG_PUB.add;
319: END IF;
320: x_return_status := FND_API.g_ret_sts_error;

Line 318: FND_MSG_PUB.add;

314: p_lookup_code => p_listheader_rec.row_selection_type
315: ) = FND_API.g_false THEN
316: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
317: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_ROW_SELECT_TYPE');
318: FND_MSG_PUB.add;
319: END IF;
320: x_return_status := FND_API.g_ret_sts_error;
321: RETURN;
322: END IF;

Line 332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

328: IF AMS_Utility_PVT.check_lookup_exists(
329: p_lookup_type => 'AMS_LIST_TYPE',
330: p_lookup_code => p_listheader_rec.list_type
331: ) = FND_API.g_false THEN
332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
333: FND_MESSAGE.set_name('AMS', 'AMS_LIST_TYPE_INVALID');
334: FND_MSG_PUB.add;
335: END IF;
336:

Line 334: FND_MSG_PUB.add;

330: p_lookup_code => p_listheader_rec.list_type
331: ) = FND_API.g_false THEN
332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
333: FND_MESSAGE.set_name('AMS', 'AMS_LIST_TYPE_INVALID');
334: FND_MSG_PUB.add;
335: END IF;
336:
337: x_return_status := FND_API.g_ret_sts_error;
338: RETURN;

Line 352: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

348: open c_check_source_type(p_listheader_rec.list_source_type );
349: fetch c_check_source_type into l_valid_flag;
350: close c_check_source_type;
351: IF l_valid_flag = 'N' THEN
352: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
353: FND_MESSAGE.set_name('AMS', 'AMS_LIST_SOURCE_TYPE_INVALID');
354: FND_MSG_PUB.add;
355: END IF;
356:

Line 354: FND_MSG_PUB.add;

350: close c_check_source_type;
351: IF l_valid_flag = 'N' THEN
352: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
353: FND_MESSAGE.set_name('AMS', 'AMS_LIST_SOURCE_TYPE_INVALID');
354: FND_MSG_PUB.add;
355: END IF;
356:
357: x_return_status := FND_API.g_ret_sts_error;
358: RETURN;

Line 371: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

367: IF AMS_Utility_PVT.check_lookup_exists(
368: p_lookup_type => 'AMS_ACTIVITY_PURPOSES',
369: p_lookup_code => p_listheader_rec.purpose_code
370: ) = FND_API.g_false THEN
371: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
372: FND_MESSAGE.set_name('AMS', 'AMS_LIST_PURPOSE_INVALID');
373: FND_MSG_PUB.add;
374: END IF;
375:

Line 373: FND_MSG_PUB.add;

369: p_lookup_code => p_listheader_rec.purpose_code
370: ) = FND_API.g_false THEN
371: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
372: FND_MESSAGE.set_name('AMS', 'AMS_LIST_PURPOSE_INVALID');
373: FND_MSG_PUB.add;
374: END IF;
375:
376: x_return_status := FND_API.g_ret_sts_error;
377: RETURN;

Line 408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

404: 'fnd_timezones_b',
405: 'upgrade_tz_id',
406: p_listheader_rec.timezone_id
407: ) = FND_API.g_false THEN
408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
409: THEN
410: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_TIMEZONE_ID');
411: FND_MSG_PUB.add;
412: END IF;

Line 411: FND_MSG_PUB.add;

407: ) = FND_API.g_false THEN
408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
409: THEN
410: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_TIMEZONE_ID');
411: FND_MSG_PUB.add;
412: END IF;
413:
414: x_return_status := FND_API.g_ret_sts_error;
415: RETURN;

Line 520: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

516: 'ams_list_headers_all',
517: 'list_header_id = ' || p_listheader_rec.list_header_id
518: ) = FND_API.g_false
519: THEN
520: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
521: THEN
522: FND_MESSAGE.set_name('AMS', 'AMS_LIST_PK_EXISTS');
523: FND_MSG_PUB.add;
524: END IF;

Line 523: FND_MSG_PUB.add;

519: THEN
520: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
521: THEN
522: FND_MESSAGE.set_name('AMS', 'AMS_LIST_PK_EXISTS');
523: FND_MSG_PUB.add;
524: END IF;
525:
526: x_return_status := FND_API.g_ret_sts_error;
527: RETURN;

Line 559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

555: END IF;
556: END IF;
557:
558: IF l_valid_flag = FND_API.g_false THEN
559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
560: THEN
561: FND_MESSAGE.set_name('AMS', 'AMS_LIST_DUPLICATE_NAME');
562: FND_MSG_PUB.add;
563: END IF;

Line 562: FND_MSG_PUB.add;

558: IF l_valid_flag = FND_API.g_false THEN
559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
560: THEN
561: FND_MESSAGE.set_name('AMS', 'AMS_LIST_DUPLICATE_NAME');
562: FND_MSG_PUB.add;
563: END IF;
564: x_return_status := FND_API.g_ret_sts_error;
565: RETURN;
566: END IF;

Line 596: IF(FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR))THEN

592: -----------------------------------------------------------------------
593: --The List Name is Mandatory.
594: -----------------------------------------------------------------------
595: IF(p_listheader_rec.list_name IS NULL) THEN
596: IF(FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR))THEN
597: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_NAME_MISSING');
598: FND_MSG_PUB.Add;
599: END IF;
600: x_return_status := FND_API.G_RET_STS_ERROR;

Line 598: FND_MSG_PUB.Add;

594: -----------------------------------------------------------------------
595: IF(p_listheader_rec.list_name IS NULL) THEN
596: IF(FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR))THEN
597: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_NAME_MISSING');
598: FND_MSG_PUB.Add;
599: END IF;
600: x_return_status := FND_API.G_RET_STS_ERROR;
601: -- If any errors happen abort API/Procedure.
602: return;

Line 609: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

605: -----------------------------------------------------------------------
606: --The List Type is Mandatory.
607: -----------------------------------------------------------------------
608: IF (p_listheader_rec.list_type IS NULL) THEN
609: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
610: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_TYPE_MISSING');
611: FND_MSG_PUB.Add;
612: END IF;
613: x_return_status := FND_API.G_RET_STS_ERROR;

Line 611: FND_MSG_PUB.Add;

607: -----------------------------------------------------------------------
608: IF (p_listheader_rec.list_type IS NULL) THEN
609: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
610: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_TYPE_MISSING');
611: FND_MSG_PUB.Add;
612: END IF;
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: return;
615: END IF;

Line 621: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

617: -----------------------------------------------------------------------
618: --The List source Type is Mandatory.
619: -----------------------------------------------------------------------
620: IF (p_listheader_rec.list_source_type IS NULL) THEN
621: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
622: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_SOURCE_TYPE_MISSING');
623: FND_MSG_PUB.Add;
624: END IF;
625: x_return_status := FND_API.G_RET_STS_ERROR;

Line 623: FND_MSG_PUB.Add;

619: -----------------------------------------------------------------------
620: IF (p_listheader_rec.list_source_type IS NULL) THEN
621: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
622: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_SOURCE_TYPE_MISSING');
623: FND_MSG_PUB.Add;
624: END IF;
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: return;
627: END IF;

Line 633: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

629: -----------------------------------------------------------------------
630: --The List Owner User Id is Mandatory.
631: -----------------------------------------------------------------------
632: IF (p_listheader_rec.owner_user_id IS NULL) THEN
633: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
634: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_OWNER_MISSING');
635: FND_MSG_PUB.Add;
636: END IF;
637: x_return_status := FND_API.G_RET_STS_ERROR;

Line 635: FND_MSG_PUB.Add;

631: -----------------------------------------------------------------------
632: IF (p_listheader_rec.owner_user_id IS NULL) THEN
633: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
634: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_OWNER_MISSING');
635: FND_MSG_PUB.Add;
636: END IF;
637: x_return_status := FND_API.G_RET_STS_ERROR;
638: return;
639: END IF;

Line 650: IF(FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

646: THEN
647:
648: IF ((p_listheader_rec.MAIN_RANDOM_PCT_ROW_SELECTION < 0) OR
649: (p_listheader_rec.MAIN_RANDOM_PCT_ROW_SELECTION >= 100) )THEN
650: IF(FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
651: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RANDOM_PCT');
652: FND_MESSAGE.Set_Token('RAND_VALUE',p_listheader_rec.MAIN_RANDOM_PCT_ROW_SELECTION);
653: FND_MSG_PUB.Add;
654: END IF;

Line 653: FND_MSG_PUB.Add;

649: (p_listheader_rec.MAIN_RANDOM_PCT_ROW_SELECTION >= 100) )THEN
650: IF(FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
651: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RANDOM_PCT');
652: FND_MESSAGE.Set_Token('RAND_VALUE',p_listheader_rec.MAIN_RANDOM_PCT_ROW_SELECTION);
653: FND_MSG_PUB.Add;
654: END IF;
655: x_return_status := FND_API.G_RET_STS_ERROR;
656: RAISE FND_API.G_EXC_ERROR;
657: END IF;

Line 668: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

664: (p_listheader_rec.CTRL_RANDOM_PCT_ROW_SELECTION <> FND_API.G_MISS_NUM)
665: THEN
666: IF ((p_listheader_rec.CTRL_RANDOM_PCT_ROW_SELECTION < 0) OR
667: (p_listheader_rec.CTRL_RANDOM_PCT_ROW_SELECTION > 100) )THEN
668: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
669: FND_MESSAGE.set_name('AMS', 'AMS_LIST_CONTROL_PCT_INVALID');
670: FND_MSG_PUB.Add;
671: END IF;
672: x_return_status := FND_API.G_RET_STS_ERROR;

Line 670: FND_MSG_PUB.Add;

666: IF ((p_listheader_rec.CTRL_RANDOM_PCT_ROW_SELECTION < 0) OR
667: (p_listheader_rec.CTRL_RANDOM_PCT_ROW_SELECTION > 100) )THEN
668: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
669: FND_MESSAGE.set_name('AMS', 'AMS_LIST_CONTROL_PCT_INVALID');
670: FND_MSG_PUB.Add;
671: END IF;
672: x_return_status := FND_API.G_RET_STS_ERROR;
673: RAISE FND_API.G_EXC_ERROR;
674: END IF;

Line 683: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

679: WHEN FND_API.g_exc_unexpected_error THEN
680: x_return_status := FND_API.g_ret_sts_unexp_error ;
681: WHEN OTHERS THEN
682: x_return_status := FND_API.g_ret_sts_unexp_error ;
683: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
684: THEN
685: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
686: END IF;
687: END Check_List_Req_Items;

Line 685: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

681: WHEN OTHERS THEN
682: x_return_status := FND_API.g_ret_sts_unexp_error ;
683: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
684: THEN
685: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
686: END IF;
687: END Check_List_Req_Items;
688:
689:

Line 722: FND_MSG_PUB.Add;

718: -- Debug Message
719: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
720: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
721: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_List_Record: Start', TRUE);
722: FND_MSG_PUB.Add;
723: END IF; */
724:
725:
726: IF (AMS_DEBUG_HIGH_ON) THEN

Line 738: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

734:
735: IF (p_listheader_rec.forecasted_start_date <> FND_API.g_miss_date) OR
736: (p_listheader_rec.forecasted_end_date <> FND_API.g_miss_date) THEN
737: IF (l_listheader_rec.forecasted_start_date > l_listheader_rec.forecasted_end_date) THEN
738: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
739: FND_MESSAGE.set_name('AMS', 'AMS_LIST_FCAST_RANGE_INVALID');
740: FND_MSG_PUB.Add;
741: END IF;
742: x_return_status := FND_API.G_RET_STS_ERROR;

Line 740: FND_MSG_PUB.Add;

736: (p_listheader_rec.forecasted_end_date <> FND_API.g_miss_date) THEN
737: IF (l_listheader_rec.forecasted_start_date > l_listheader_rec.forecasted_end_date) THEN
738: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
739: FND_MESSAGE.set_name('AMS', 'AMS_LIST_FCAST_RANGE_INVALID');
740: FND_MSG_PUB.Add;
741: END IF;
742: x_return_status := FND_API.G_RET_STS_ERROR;
743: RAISE FND_API.G_EXC_ERROR;
744: END IF;

Line 755: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

751: (p_listheader_rec.main_gen_end_time <> FND_API.g_miss_date)
752: THEN
753:
754: IF (l_listheader_rec.main_gen_end_time > l_listheader_rec.sent_out_date) THEN
755: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
756: FND_MESSAGE.set_name('AMS', 'AMS_LIST_GEN_START_DATE');
757: FND_MSG_PUB.Add;
758: END IF;
759: x_return_status := FND_API.G_RET_STS_ERROR;

Line 757: FND_MSG_PUB.Add;

753:
754: IF (l_listheader_rec.main_gen_end_time > l_listheader_rec.sent_out_date) THEN
755: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
756: FND_MESSAGE.set_name('AMS', 'AMS_LIST_GEN_START_DATE');
757: FND_MSG_PUB.Add;
758: END IF;
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: -- If any errors happen abort API/Procedure.
761: RAISE FND_API.G_EXC_ERROR;

Line 772: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

768: (p_listheader_rec.no_of_rows_max_requested <> FND_API.g_miss_num)
769: THEN
770:
771: IF l_listheader_rec.no_of_rows_max_requested < 0 THEN
772: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
773: FND_MESSAGE.set_name('AMS', 'AMS_LIST_MIN_MAX_NEGATIVE');
774: FND_MSG_PUB.Add;
775: END IF;
776: x_return_status := FND_API.G_RET_STS_ERROR;

Line 774: FND_MSG_PUB.Add;

770:
771: IF l_listheader_rec.no_of_rows_max_requested < 0 THEN
772: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
773: FND_MESSAGE.set_name('AMS', 'AMS_LIST_MIN_MAX_NEGATIVE');
774: FND_MSG_PUB.Add;
775: END IF;
776: x_return_status := FND_API.G_RET_STS_ERROR;
777: RAISE FND_API.G_EXC_ERROR;
778: END IF;

Line 781: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

777: RAISE FND_API.G_EXC_ERROR;
778: END IF;
779:
780: IF l_listheader_rec.no_of_rows_min_requested < 0 THEN
781: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
782: FND_MESSAGE.set_name('AMS', 'AMS_LIST_MIN_MAX_NEGATIVE');
783: FND_MSG_PUB.Add;
784: END IF;
785: x_return_status := FND_API.G_RET_STS_ERROR;

Line 783: FND_MSG_PUB.Add;

779:
780: IF l_listheader_rec.no_of_rows_min_requested < 0 THEN
781: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
782: FND_MESSAGE.set_name('AMS', 'AMS_LIST_MIN_MAX_NEGATIVE');
783: FND_MSG_PUB.Add;
784: END IF;
785: x_return_status := FND_API.G_RET_STS_ERROR;
786: RAISE FND_API.G_EXC_ERROR;
787: END IF;

Line 790: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

786: RAISE FND_API.G_EXC_ERROR;
787: END IF;
788:
789: IF l_listheader_rec.no_of_rows_max_requested <= l_listheader_rec.no_of_rows_min_requested THEN
790: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
791: FND_MESSAGE.set_name('AMS', 'AMS_LIST_MIN_MAX_RANGE_INVALID');
792: FND_MSG_PUB.Add;
793: END IF;
794: x_return_status := FND_API.G_RET_STS_ERROR;

Line 792: FND_MSG_PUB.Add;

788:
789: IF l_listheader_rec.no_of_rows_max_requested <= l_listheader_rec.no_of_rows_min_requested THEN
790: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
791: FND_MESSAGE.set_name('AMS', 'AMS_LIST_MIN_MAX_RANGE_INVALID');
792: FND_MSG_PUB.Add;
793: END IF;
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: RAISE FND_API.G_EXC_ERROR;
796: END IF;

Line 812: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

808: x_pk_name => l_pk_name);
809:
810: IF((l_table_name is not null) and (l_pk_name is not null))THEN
811: IF(AMS_UTILITY_PVT.Check_FK_Exists(l_table_name,l_pk_name,p_listheader_rec.list_used_by_id) = FND_API.G_FALSE)THEN
812: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
813: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACTIVITY_INVALID');
814: FND_MESSAGE.Set_Token('LIST_ACTIVITY_CODE',p_listheader_rec.arc_list_used_by);
815: FND_MSG_PUB.Add;
816: END IF;

Line 815: FND_MSG_PUB.Add;

811: IF(AMS_UTILITY_PVT.Check_FK_Exists(l_table_name,l_pk_name,p_listheader_rec.list_used_by_id) = FND_API.G_FALSE)THEN
812: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
813: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACTIVITY_INVALID');
814: FND_MESSAGE.Set_Token('LIST_ACTIVITY_CODE',p_listheader_rec.arc_list_used_by);
815: FND_MSG_PUB.Add;
816: END IF;
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: -- If any errors happen abort API/Procedure.
819: RAISE FND_API.G_EXC_ERROR;

Line 824: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)THEN

820: END IF;
821: ELSE
822: -- Error, check the msg level and added an error message to the
823: -- API message list
824: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)THEN
825: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACTIVTY_INVALID');
826: FND_MESSAGE.Set_Token('LIST_ACTIVITY_CODE',p_listheader_rec.arc_list_used_by);
827: FND_MSG_PUB.Add;
828: END IF;

Line 827: FND_MSG_PUB.Add;

823: -- API message list
824: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)THEN
825: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACTIVTY_INVALID');
826: FND_MESSAGE.Set_Token('LIST_ACTIVITY_CODE',p_listheader_rec.arc_list_used_by);
827: FND_MSG_PUB.Add;
828: END IF;
829: x_return_status := FND_API.G_RET_STS_ERROR;
830: -- If any errors happen abort API/Procedure.
831: RAISE FND_API.G_EXC_ERROR;

Line 837: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

833: END IF;
834: END IF;--The List must be associcated to a valid Marketing Activity.
835:
836: -- Success Message
837: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
838: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
839: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_List_Record', TRUE);
840: FND_MSG_PUB.Add;
841: END IF;

Line 840: FND_MSG_PUB.Add;

836: -- Success Message
837: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
838: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
839: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_List_Record', TRUE);
840: FND_MSG_PUB.Add;
841: END IF;
842:
843:
844: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN

Line 847: FND_MSG_PUB.Add;

843:
844: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
845: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
846: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_List_Record: END', TRUE);
847: FND_MSG_PUB.Add;
848: END IF; */
849:
850: EXCEPTION
851: WHEN FND_API.G_EXC_ERROR THEN

Line 894: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

890: CLOSE C;
891: IF l_dummy >= 1 THEN
892: -- Error, check the msg level and added an error message to the
893: -- API message list
894: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
895: FND_MESSAGE.set_name('AMS', 'AMS_LIST_PK_EXISTS');
896: FND_MESSAGE.Set_Token('LIST_PK',p_listheader_rec.list_header_id, FALSE);
897: FND_MSG_PUB.Add;
898: END IF;

Line 897: FND_MSG_PUB.Add;

893: -- API message list
894: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
895: FND_MESSAGE.set_name('AMS', 'AMS_LIST_PK_EXISTS');
896: FND_MESSAGE.Set_Token('LIST_PK',p_listheader_rec.list_header_id, FALSE);
897: FND_MSG_PUB.Add;
898: END IF;
899: x_return_status := FND_API.G_RET_STS_ERROR;
900: ELSE
901: x_listheader_id := p_listheader_rec.list_header_id;

Line 1044: FND_MSG_PUB.initialize;

1040: END IF;
1041:
1042: -- Initialize message list if p_init_msg_list is set to TRUE.
1043: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1044: FND_MSG_PUB.initialize;
1045: END IF;
1046:
1047: -- Debug Message
1048: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN

Line 1051: FND_MSG_PUB.Add;

1047: -- Debug Message
1048: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
1049: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1050: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListHeader: Start', TRUE);
1051: FND_MSG_PUB.Add;
1052: END IF; */
1053:
1054: IF (AMS_DEBUG_HIGH_ON) THEN
1055: AMS_Utility_PVT.debug_message('AMS_ListHeaders_PVT.Validate_listheaders: Start');

Line 1109: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1105: --
1106:
1107: -- Success Message
1108: -- MMSG
1109: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1110: THEN
1111: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
1112: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListHeader', TRUE);
1113: FND_MSG_PUB.Add;

Line 1113: FND_MSG_PUB.Add;

1109: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1110: THEN
1111: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
1112: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListHeader', TRUE);
1113: FND_MSG_PUB.Add;
1114: END IF;
1115:
1116:
1117: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN

Line 1120: FND_MSG_PUB.Add;

1116:
1117: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
1118: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1119: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListHeader: END', TRUE);
1120: FND_MSG_PUB.Add;
1121: END IF; */
1122: -- Standard call to get message count AND IF count is 1, get message info.
1123: FND_MSG_PUB.Count_AND_Get
1124: ( p_count => x_msg_count,

Line 1123: FND_MSG_PUB.Count_AND_Get

1119: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeader_PVT.Validate_ListHeader: END', TRUE);
1120: FND_MSG_PUB.Add;
1121: END IF; */
1122: -- Standard call to get message count AND IF count is 1, get message info.
1123: FND_MSG_PUB.Count_AND_Get
1124: ( p_count => x_msg_count,
1125: p_data => x_msg_data,
1126: p_encoded => FND_API.G_FALSE
1127: );

Line 1133: FND_MSG_PUB.Count_AND_Get

1129: EXCEPTION
1130: WHEN FND_API.G_EXC_ERROR THEN
1131: x_return_status := FND_API.G_RET_STS_ERROR ;
1132:
1133: FND_MSG_PUB.Count_AND_Get
1134: ( p_count => x_msg_count,
1135: p_data => x_msg_data,
1136: p_encoded => FND_API.G_FALSE
1137: );

Line 1144: FND_MSG_PUB.Count_AND_Get

1140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1141:
1142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1143:
1144: FND_MSG_PUB.Count_AND_Get
1145: ( p_count => x_msg_count,
1146: p_data => x_msg_data,
1147: p_encoded => FND_API.G_FALSE
1148: );

Line 1152: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1148: );
1149: WHEN OTHERS THEN
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1151:
1152: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1153: THEN
1154: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1155: END IF;
1156:

Line 1154: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1151:
1152: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1153: THEN
1154: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1155: END IF;
1156:
1157: FND_MSG_PUB.Count_AND_Get
1158: ( p_count => x_msg_count,

Line 1157: FND_MSG_PUB.Count_AND_Get

1153: THEN
1154: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1155: END IF;
1156:
1157: FND_MSG_PUB.Count_AND_Get
1158: ( p_count => x_msg_count,
1159: p_data => x_msg_data,
1160: p_encoded => FND_API.G_FALSE
1161: );

Line 1254: FND_MSG_PUB.initialize;

1250:
1251:
1252: -- Initialize message list IF p_init_msg_list is set to TRUE.
1253: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1254: FND_MSG_PUB.initialize;
1255: END IF;
1256:
1257: -- Debug Message
1258: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN

Line 1261: FND_MSG_PUB.Add;

1257: -- Debug Message
1258: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
1259: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1260: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeaders_PVT.Create_listheaders: Start', TRUE);
1261: FND_MSG_PUB.Add;
1262: END IF; */
1263:
1264: IF (AMS_DEBUG_HIGH_ON) THEN
1265: AMS_Utility_PVT.debug_message('AMS_ListHeaders_PVT.Create_listheaders: Start');

Line 1622: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1618: COMMIT WORK;
1619: END IF;
1620:
1621: -- Success Message
1622: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1623: THEN
1624: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
1625: FND_MESSAGE.Set_Token('ROW', 'AMS_listheaders_PVT.Create_listheaders', TRUE);
1626: FND_MSG_PUB.Add;

Line 1626: FND_MSG_PUB.Add;

1622: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1623: THEN
1624: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
1625: FND_MESSAGE.Set_Token('ROW', 'AMS_listheaders_PVT.Create_listheaders', TRUE);
1626: FND_MSG_PUB.Add;
1627: END IF;
1628:
1629: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
1630: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

Line 1632: FND_MSG_PUB.Add;

1628:
1629: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
1630: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1631: FND_MESSAGE.Set_Token('ROW', 'AMS_listheaders_PVT.Create_listheaders: END', TRUE);
1632: FND_MSG_PUB.Add;
1633: END IF; */
1634:
1635:
1636: -- Standard call to get message count AND IF count is 1, get message info.

Line 1637: FND_MSG_PUB.Count_AND_Get

1633: END IF; */
1634:
1635:
1636: -- Standard call to get message count AND IF count is 1, get message info.
1637: FND_MSG_PUB.Count_AND_Get
1638: ( p_count => x_msg_count,
1639: p_data => x_msg_data,
1640: p_encoded => FND_API.G_FALSE
1641: );

Line 1648: FND_MSG_PUB.Count_AND_Get

1644: WHEN FND_API.G_EXC_ERROR THEN
1645: ROLLBACK TO Create_listheaders_PVT;
1646: x_return_status := FND_API.G_RET_STS_ERROR ;
1647:
1648: FND_MSG_PUB.Count_AND_Get
1649: ( p_count => x_msg_count,
1650: p_data => x_msg_data,
1651: p_encoded => FND_API.G_FALSE
1652: );

Line 1658: FND_MSG_PUB.Count_AND_Get

1654:
1655: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1656: ROLLBACK TO Create_listheaders_PVT;
1657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1658: FND_MSG_PUB.Count_AND_Get
1659: ( p_count => x_msg_count,
1660: p_data => x_msg_data,
1661: p_encoded => FND_API.G_FALSE
1662: );

Line 1667: FND_MSG_PUB.Add;

1663:
1664: WHEN OTHERS THEN
1665: ROLLBACK TO Create_listheaders_PVT;
1666: FND_MESSAGE.set_name('AMS','SQL ERROR ->' || sqlerrm );
1667: FND_MSG_PUB.Add;
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1669: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1670: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1671: END IF;

Line 1669: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1665: ROLLBACK TO Create_listheaders_PVT;
1666: FND_MESSAGE.set_name('AMS','SQL ERROR ->' || sqlerrm );
1667: FND_MSG_PUB.Add;
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1669: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1670: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1671: END IF;
1672:
1673: FND_MSG_PUB.Count_AND_Get

Line 1670: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1666: FND_MESSAGE.set_name('AMS','SQL ERROR ->' || sqlerrm );
1667: FND_MSG_PUB.Add;
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1669: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1670: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1671: END IF;
1672:
1673: FND_MSG_PUB.Count_AND_Get
1674: ( p_count => x_msg_count,

Line 1673: FND_MSG_PUB.Count_AND_Get

1669: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1670: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1671: END IF;
1672:
1673: FND_MSG_PUB.Count_AND_Get
1674: ( p_count => x_msg_count,
1675: p_data => x_msg_data,
1676: p_encoded => FND_API.G_FALSE
1677: );

Line 1742: FND_MSG_PUB.initialize;

1738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1739: END IF;
1740: -- Initialize message list IF p_init_msg_list is set to TRUE.
1741: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1742: FND_MSG_PUB.initialize;
1743: END IF;
1744: -- Debug Message
1745: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
1746: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

Line 1748: FND_MSG_PUB.Add;

1744: -- Debug Message
1745: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
1746: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1747: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders: Start', TRUE);
1748: FND_MSG_PUB.Add;
1749: END IF; */
1750:
1751: IF (AMS_DEBUG_HIGH_ON) THEN
1752: AMS_Utility_PVT.debug_message('AMS_ListHeaders_PVT.Update_listheaders: Start');

Line 1794: FND_MSG_PUB.Add;

1790: -- Debug Message
1791: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
1792: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1793: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders: Done Timezone', TRUE);
1794: FND_MSG_PUB.Add;
1795: END IF; */
1796:
1797: IF (AMS_DEBUG_HIGH_ON) THEN
1798: AMS_Utility_PVT.debug_message('AMS_ListHeaders_PVT.Update_listheaders: Done timezone');

Line 1822: FND_MSG_PUB.Add;

1818: -- Debug Message
1819: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
1820: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1821: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders: Item Level Validation', TRUE);
1822: FND_MSG_PUB.Add;
1823: END IF; */
1824:
1825: IF (AMS_DEBUG_HIGH_ON) THEN
1826: AMS_Utility_PVT.debug_message('AMS_ListHeaders_PVT.Update_listheaders: Item level validation');

Line 1848: FND_MSG_PUB.Add;

1844: -- Perform the database operation
1845: /* ckapoor IF (AMS_DEBUG_LOW_ON) THEN
1846: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
1847: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT - update ams_listheaders', TRUE);
1848: FND_MSG_PUB.Add;
1849: END IF; */
1850:
1851: IF (AMS_DEBUG_LOW_ON) THEN
1852: AMS_Utility_PVT.debug_message('AMS_ListHeaders_PVT.update ams_listheaders');

Line 2028: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2024: ------------------------------------------------------------------
2025: -- Error, check the msg level and added an error message to the --
2026: -- API message list. --
2027: ------------------------------------------------------------------
2028: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2029: FND_MESSAGE.set_name('AMS', 'API_UNEXP_ERROR_IN_PROCESSING');
2030: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders API', TRUE);
2031: FND_MSG_PUB.Add;
2032: END IF;

Line 2031: FND_MSG_PUB.Add;

2027: ------------------------------------------------------------------
2028: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2029: FND_MESSAGE.set_name('AMS', 'API_UNEXP_ERROR_IN_PROCESSING');
2030: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders API', TRUE);
2031: FND_MSG_PUB.Add;
2032: END IF;
2033: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2034: END IF;
2035:

Line 2051: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2047: ------------------------------------------------------------------
2048: -- Error, check the msg level and added an error message to the --
2049: -- API message list. --
2050: ------------------------------------------------------------------
2051: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2052: FND_MESSAGE.set_name('AMS', 'API_UNEXP_ERROR_IN_PROCESSING');
2053: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders API', TRUE);
2054: FND_MSG_PUB.Add;
2055: END IF;

Line 2054: FND_MSG_PUB.Add;

2050: ------------------------------------------------------------------
2051: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2052: FND_MESSAGE.set_name('AMS', 'API_UNEXP_ERROR_IN_PROCESSING');
2053: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders API', TRUE);
2054: FND_MSG_PUB.Add;
2055: END IF;
2056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2057: END IF;
2058:

Line 2083: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

2079: COMMIT WORK;
2080: END IF;
2081:
2082: -- Success Message
2083: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
2084: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
2085: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders', TRUE);
2086: FND_MSG_PUB.Add;
2087: END IF;

Line 2086: FND_MSG_PUB.Add;

2082: -- Success Message
2083: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
2084: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
2085: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders', TRUE);
2086: FND_MSG_PUB.Add;
2087: END IF;
2088:
2089: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
2090: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

Line 2092: FND_MSG_PUB.Add;

2088:
2089: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
2090: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
2091: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Update_listheaders: END', TRUE);
2092: FND_MSG_PUB.Add;
2093: END IF; */
2094:
2095: -- Standard call to get message count AND IF count is 1, get message info.
2096: FND_MSG_PUB.Count_AND_Get

Line 2096: FND_MSG_PUB.Count_AND_Get

2092: FND_MSG_PUB.Add;
2093: END IF; */
2094:
2095: -- Standard call to get message count AND IF count is 1, get message info.
2096: FND_MSG_PUB.Count_AND_Get
2097: ( p_count => x_msg_count,
2098: p_data => x_msg_data,
2099: p_encoded => FND_API.G_FALSE
2100: );

Line 2105: FND_MSG_PUB.Count_AND_Get

2101: EXCEPTION
2102: WHEN FND_API.G_EXC_ERROR THEN
2103: ROLLBACK TO Update_listheaders_PVT;
2104: x_return_status := FND_API.G_RET_STS_ERROR ;
2105: FND_MSG_PUB.Count_AND_Get
2106: ( p_count => x_msg_count,
2107: p_data => x_msg_data,
2108: p_encoded => FND_API.G_FALSE
2109: );

Line 2115: FND_MSG_PUB.Count_AND_Get

2111:
2112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2113: ROLLBACK TO Update_listheaders_PVT;
2114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2115: FND_MSG_PUB.Count_AND_Get
2116: ( p_count => x_msg_count,
2117: p_data => x_msg_data,
2118: p_encoded => FND_API.G_FALSE
2119: );

Line 2123: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

2119: );
2120: WHEN OTHERS THEN
2121: ROLLBACK TO Update_listheaders_PVT;
2122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2123: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2124: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2125: END IF;
2126:
2127: FND_MSG_PUB.Count_AND_Get

Line 2124: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2120: WHEN OTHERS THEN
2121: ROLLBACK TO Update_listheaders_PVT;
2122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2123: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2124: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2125: END IF;
2126:
2127: FND_MSG_PUB.Count_AND_Get
2128: ( p_count => x_msg_count,

Line 2127: FND_MSG_PUB.Count_AND_Get

2123: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2124: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2125: END IF;
2126:
2127: FND_MSG_PUB.Count_AND_Get
2128: ( p_count => x_msg_count,
2129: p_data => x_msg_data,
2130: p_encoded => FND_API.G_FALSE
2131: );

Line 2187: FND_MSG_PUB.initialize;

2183: END IF;
2184:
2185: -- Initialize message list IF p_init_msg_list is set to TRUE.
2186: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2187: FND_MSG_PUB.initialize;
2188: END IF;
2189:
2190: -- Debug Message
2191: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2194: FND_MSG_PUB.Add;

2190: -- Debug Message
2191: IF (AMS_DEBUG_HIGH_ON) THEN
2192: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
2193: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Delete_listheaders: Start', TRUE);
2194: FND_MSG_PUB.Add;
2195: END IF;
2196:
2197: -- Initialize API return status to success
2198: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2203: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

2199:
2200:
2201: -- Check required parameters
2202: IF (l_list_header_id = FND_API.G_MISS_NUM OR l_list_header_id IS NULL )THEN
2203: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2204: FND_MESSAGE.Set_Name('AMS', 'API_INCOMPLETE_INFO');
2205: FND_MESSAGE.Set_Token ('PARAM', 'listheader_id', FALSE);
2206: FND_MSG_PUB.Add;
2207: END IF;

Line 2206: FND_MSG_PUB.Add;

2202: IF (l_list_header_id = FND_API.G_MISS_NUM OR l_list_header_id IS NULL )THEN
2203: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2204: FND_MESSAGE.Set_Name('AMS', 'API_INCOMPLETE_INFO');
2205: FND_MESSAGE.Set_Token ('PARAM', 'listheader_id', FALSE);
2206: FND_MSG_PUB.Add;
2207: END IF;
2208: RAISE FND_API.G_EXC_ERROR;
2209: END IF;
2210:

Line 2239: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

2235: COMMIT WORK;
2236: END IF;
2237:
2238: -- Success Message
2239: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
2240: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
2241: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Delete_listheaders', TRUE);
2242: FND_MSG_PUB.Add;
2243: END IF;

Line 2242: FND_MSG_PUB.Add;

2238: -- Success Message
2239: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
2240: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
2241: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Delete_listheaders', TRUE);
2242: FND_MSG_PUB.Add;
2243: END IF;
2244:
2245:
2246: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2249: FND_MSG_PUB.Add;

2245:
2246: IF (AMS_DEBUG_HIGH_ON) THEN
2247: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
2248: FND_MESSAGE.Set_Token('ROW', 'AMS_listheader_PVT.Delete_listheader: END', TRUE);
2249: FND_MSG_PUB.Add;
2250: END IF;
2251:
2252:
2253: -- Standard call to get message count AND IF count is 1, get message info.

Line 2254: FND_MSG_PUB.Count_AND_Get

2250: END IF;
2251:
2252:
2253: -- Standard call to get message count AND IF count is 1, get message info.
2254: FND_MSG_PUB.Count_AND_Get
2255: ( p_count => x_msg_count,
2256: p_data => x_msg_data,
2257: p_encoded => FND_API.G_FALSE
2258: );

Line 2264: FND_MSG_PUB.Count_AND_Get

2260: WHEN FND_API.G_EXC_ERROR THEN
2261: ROLLBACK TO Delete_listheader_PVT;
2262: x_return_status := FND_API.G_RET_STS_ERROR ;
2263:
2264: FND_MSG_PUB.Count_AND_Get
2265: ( p_count => x_msg_count,
2266: p_data => x_msg_data,
2267: p_encoded => FND_API.G_FALSE
2268: );

Line 2274: FND_MSG_PUB.Count_AND_Get

2270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2271: ROLLBACK TO Delete_listheader_PVT;
2272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2273:
2274: FND_MSG_PUB.Count_AND_Get
2275: ( p_count => x_msg_count,
2276: p_data => x_msg_data,
2277: p_encoded => FND_API.G_FALSE
2278: );

Line 2284: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

2280:
2281: WHEN OTHERS THEN
2282: ROLLBACK TO Delete_listheader_PVT;
2283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2284: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2285: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2286: END IF;
2287:
2288: FND_MSG_PUB.Count_AND_Get

Line 2285: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2281: WHEN OTHERS THEN
2282: ROLLBACK TO Delete_listheader_PVT;
2283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2284: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2285: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2286: END IF;
2287:
2288: FND_MSG_PUB.Count_AND_Get
2289: ( p_count => x_msg_count,

Line 2288: FND_MSG_PUB.Count_AND_Get

2284: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2285: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2286: END IF;
2287:
2288: FND_MSG_PUB.Count_AND_Get
2289: ( p_count => x_msg_count,
2290: p_data => x_msg_data,
2291: p_encoded => FND_API.G_FALSE
2292: );

Line 2348: FND_MSG_PUB.initialize;

2344: AMS_Utility_PVT.debug_message(l_full_name||': start');
2345: END IF;
2346:
2347: IF FND_API.to_boolean(p_init_msg_list) THEN
2348: FND_MSG_PUB.initialize;
2349: END IF;
2350:
2351: IF NOT FND_API.compatible_api_call(
2352: l_api_version,

Line 2372: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2368: OPEN c_list_header_id;
2369: FETCH c_list_header_id INTO l_list_header_id;
2370: IF (c_list_header_id%NOTFOUND) THEN
2371: CLOSE c_list_header_id;
2372: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2373: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2374: FND_MSG_PUB.add;
2375: END IF;
2376: RAISE FND_API.g_exc_error;

Line 2374: FND_MSG_PUB.add;

2370: IF (c_list_header_id%NOTFOUND) THEN
2371: CLOSE c_list_header_id;
2372: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2373: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2374: FND_MSG_PUB.add;
2375: END IF;
2376: RAISE FND_API.g_exc_error;
2377: END IF;
2378: CLOSE c_list_header_id;

Line 2381: FND_MSG_PUB.count_and_get(

2377: END IF;
2378: CLOSE c_list_header_id;
2379:
2380: -------------------- finish --------------------------
2381: FND_MSG_PUB.count_and_get(
2382: p_encoded => FND_API.g_false,
2383: p_count => x_msg_count,
2384: p_data => x_msg_data
2385: );

Line 2399: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2395: EXCEPTION
2396:
2397: WHEN AMS_Utility_PVT.resource_locked THEN
2398: x_return_status := FND_API.g_ret_sts_error;
2399: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2400: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
2401: FND_MSG_PUB.add;
2402: END IF;
2403:

Line 2401: FND_MSG_PUB.add;

2397: WHEN AMS_Utility_PVT.resource_locked THEN
2398: x_return_status := FND_API.g_ret_sts_error;
2399: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2400: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
2401: FND_MSG_PUB.add;
2402: END IF;
2403:
2404: FND_MSG_PUB.count_and_get(
2405: p_encoded => FND_API.g_false,

Line 2404: FND_MSG_PUB.count_and_get(

2400: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
2401: FND_MSG_PUB.add;
2402: END IF;
2403:
2404: FND_MSG_PUB.count_and_get(
2405: p_encoded => FND_API.g_false,
2406: p_count => x_msg_count,
2407: p_data => x_msg_data
2408: );

Line 2412: FND_MSG_PUB.count_and_get(

2408: );
2409:
2410: WHEN FND_API.g_exc_error THEN
2411: x_return_status := FND_API.g_ret_sts_error;
2412: FND_MSG_PUB.count_and_get(
2413: p_encoded => FND_API.g_false,
2414: p_count => x_msg_count,
2415: p_data => x_msg_data
2416: );

Line 2420: FND_MSG_PUB.count_and_get(

2416: );
2417:
2418: WHEN FND_API.g_exc_unexpected_error THEN
2419: x_return_status := FND_API.g_ret_sts_unexp_error ;
2420: FND_MSG_PUB.count_and_get(
2421: p_encoded => FND_API.g_false,
2422: p_count => x_msg_count,
2423: p_data => x_msg_data
2424: );

Line 2428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

2424: );
2425:
2426: WHEN OTHERS THEN
2427: x_return_status := FND_API.g_ret_sts_unexp_error ;
2428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2429: THEN
2430: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2431: END IF;
2432:

Line 2430: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2426: WHEN OTHERS THEN
2427: x_return_status := FND_API.g_ret_sts_unexp_error ;
2428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2429: THEN
2430: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2431: END IF;
2432:
2433: FND_MSG_PUB.count_and_get(
2434: p_encoded => FND_API.g_false,

Line 2433: FND_MSG_PUB.count_and_get(

2429: THEN
2430: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2431: END IF;
2432:
2433: FND_MSG_PUB.count_and_get(
2434: p_encoded => FND_API.g_false,
2435: p_count => x_msg_count,
2436: p_data => x_msg_data
2437: );

Line 2603: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2599: OPEN c_listheader;
2600: FETCH c_listheader INTO l_listheader_rec;
2601: IF c_listheader%NOTFOUND THEN
2602: CLOSE c_listheader;
2603: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2604: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2605: FND_MSG_PUB.add;
2606: END IF;
2607: RAISE FND_API.g_exc_error;

Line 2605: FND_MSG_PUB.add;

2601: IF c_listheader%NOTFOUND THEN
2602: CLOSE c_listheader;
2603: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2604: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2605: FND_MSG_PUB.add;
2606: END IF;
2607: RAISE FND_API.g_exc_error;
2608: END IF;
2609: CLOSE c_listheader;

Line 3005: FND_MSG_PUB.initialize;

3001: l_new_status_id number;
3002: --l_no_of_rows_prev_contacted number;
3003: BEGIN
3004: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3005: FND_MSG_PUB.initialize;
3006: END IF;
3007:
3008: open c_count_list_entries(p_list_header_id);
3009: fetch c_count_list_entries

Line 3055: FND_MSG_PUB.Add;

3051:
3052: IF (AMS_DEBUG_HIGH_ON) THEN
3053: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
3054: FND_MESSAGE.Set_Token('ROW', 'AMS_LIST_HEADER_UPDATE: END');
3055: FND_MSG_PUB.Add;
3056: END IF;
3057:
3058:
3059: IF (AMS_DEBUG_HIGH_ON) THEN

Line 3064: FND_MSG_PUB.count_and_get(

3060: AMS_Utility_PVT.debug_message('AMS_LIST_HEADER_UPDATE: END');
3061: END IF;
3062:
3063:
3064: FND_MSG_PUB.count_and_get(
3065: p_encoded => FND_API.g_false,
3066: p_count => x_msg_count,
3067: p_data => x_msg_data
3068: );

Line 3074: FND_MSG_PUB.Add;

3070: EXCEPTION
3071: WHEN FND_API.G_EXC_ERROR THEN
3072: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
3073: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
3074: FND_MSG_PUB.Add;
3075: -- Check if reset of the status is required
3076: x_return_status := FND_API.G_RET_STS_ERROR ;
3077: FND_MSG_PUB.count_and_get(
3078: p_encoded => FND_API.g_false,

Line 3077: FND_MSG_PUB.count_and_get(

3073: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
3074: FND_MSG_PUB.Add;
3075: -- Check if reset of the status is required
3076: x_return_status := FND_API.G_RET_STS_ERROR ;
3077: FND_MSG_PUB.count_and_get(
3078: p_encoded => FND_API.g_false,
3079: p_count => x_msg_count,
3080: p_data => x_msg_data);
3081:

Line 3085: FND_MSG_PUB.Add;

3081:
3082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3083: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
3084: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
3085: FND_MSG_PUB.Add;
3086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3087: FND_MSG_PUB.count_and_get(
3088: p_encoded => FND_API.g_false,
3089: p_count => x_msg_count,

Line 3087: FND_MSG_PUB.count_and_get(

3083: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
3084: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
3085: FND_MSG_PUB.Add;
3086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3087: FND_MSG_PUB.count_and_get(
3088: p_encoded => FND_API.g_false,
3089: p_count => x_msg_count,
3090: p_data => x_msg_data);
3091:

Line 3095: FND_MSG_PUB.Add;

3091:
3092: WHEN OTHERS THEN
3093: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
3094: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
3095: FND_MSG_PUB.Add;
3096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3097: FND_MSG_PUB.count_and_get(
3098: p_encoded => FND_API.g_false,
3099: p_count => x_msg_count,

Line 3097: FND_MSG_PUB.count_and_get(

3093: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
3094: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
3095: FND_MSG_PUB.Add;
3096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3097: FND_MSG_PUB.count_and_get(
3098: p_encoded => FND_API.g_false,
3099: p_count => x_msg_count,
3100: p_data => x_msg_data);
3101:

Line 3159: FND_MSG_PUB.initialize;

3155: l_list_header_id number;
3156:
3157: BEGIN
3158: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3159: FND_MSG_PUB.initialize;
3160: END IF;
3161:
3162:
3163: open c_get_list_header_id(p_used_by,p_used_by_id);

Line 3199: FND_MSG_PUB.Add;

3195:
3196: IF (AMS_DEBUG_HIGH_ON) THEN
3197: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
3198: FND_MESSAGE.Set_Token('ROW', 'AMS_LIST_HEADER_UPDATE: END');
3199: FND_MSG_PUB.Add;
3200: END IF;
3201:
3202:
3203:

Line 3204: FND_MSG_PUB.count_and_get(

3200: END IF;
3201:
3202:
3203:
3204: FND_MSG_PUB.count_and_get(
3205: p_encoded => FND_API.g_false,
3206: p_count => x_msg_count,
3207: p_data => x_msg_data
3208: );

Line 3214: FND_MSG_PUB.Add;

3210: EXCEPTION
3211: WHEN FND_API.G_EXC_ERROR THEN
3212: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
3213: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
3214: FND_MSG_PUB.Add;
3215: -- Check if reset of the status is required
3216: x_return_status := FND_API.G_RET_STS_ERROR ;
3217: FND_MSG_PUB.count_and_get(
3218: p_encoded => FND_API.g_false,

Line 3217: FND_MSG_PUB.count_and_get(

3213: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
3214: FND_MSG_PUB.Add;
3215: -- Check if reset of the status is required
3216: x_return_status := FND_API.G_RET_STS_ERROR ;
3217: FND_MSG_PUB.count_and_get(
3218: p_encoded => FND_API.g_false,
3219: p_count => x_msg_count,
3220: p_data => x_msg_data);
3221:

Line 3225: FND_MSG_PUB.Add;

3221:
3222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3223: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
3224: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
3225: FND_MSG_PUB.Add;
3226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3227: FND_MSG_PUB.count_and_get(
3228: p_encoded => FND_API.g_false,
3229: p_count => x_msg_count,

Line 3227: FND_MSG_PUB.count_and_get(

3223: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
3224: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
3225: FND_MSG_PUB.Add;
3226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3227: FND_MSG_PUB.count_and_get(
3228: p_encoded => FND_API.g_false,
3229: p_count => x_msg_count,
3230: p_data => x_msg_data);
3231:

Line 3235: FND_MSG_PUB.Add;

3231:
3232: WHEN OTHERS THEN
3233: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
3234: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
3235: FND_MSG_PUB.Add;
3236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3237: FND_MSG_PUB.count_and_get(
3238: p_encoded => FND_API.g_false,
3239: p_count => x_msg_count,

Line 3237: FND_MSG_PUB.count_and_get(

3233: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
3234: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
3235: FND_MSG_PUB.Add;
3236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3237: FND_MSG_PUB.count_and_get(
3238: p_encoded => FND_API.g_false,
3239: p_count => x_msg_count,
3240: p_data => x_msg_data);
3241:

Line 3324: FND_MSG_PUB.initialize;

3320:
3321:
3322: -- Initialize message list IF p_init_msg_list is set to TRUE.
3323: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3324: FND_MSG_PUB.initialize;
3325: END IF;
3326:
3327: -- Debug Message
3328: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN

Line 3331: FND_MSG_PUB.Add;

3327: -- Debug Message
3328: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
3329: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
3330: FND_MESSAGE.Set_Token('ROW', 'AMS_ListHeaders_PVT.Copy_Lists: Start', TRUE);
3331: FND_MSG_PUB.Add;
3332: END IF; */
3333:
3334: IF (AMS_DEBUG_HIGH_ON) THEN
3335: AMS_Utility_PVT.debug_message('AMS_ListHeader_PVT.Copy_List: Start');

Line 3444: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3440: COMMIT WORK;
3441: END IF;
3442:
3443: -- Success Message
3444: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3445: THEN
3446: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
3447: FND_MESSAGE.Set_Token('ROW', 'AMS_listheaders_PVT.Copy_Lists', TRUE);
3448: FND_MSG_PUB.Add;

Line 3448: FND_MSG_PUB.Add;

3444: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3445: THEN
3446: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
3447: FND_MESSAGE.Set_Token('ROW', 'AMS_listheaders_PVT.Copy_Lists', TRUE);
3448: FND_MSG_PUB.Add;
3449: END IF;
3450:
3451: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
3452: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

Line 3454: FND_MSG_PUB.Add;

3450:
3451: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
3452: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
3453: FND_MESSAGE.Set_Token('ROW', 'AMS_listheaders_PVT.Copy_Lists: END', TRUE);
3454: FND_MSG_PUB.Add;
3455: END IF; */
3456:
3457:
3458: -- Standard call to get message count AND IF count is 1, get message info.

Line 3459: FND_MSG_PUB.Count_AND_Get

3455: END IF; */
3456:
3457:
3458: -- Standard call to get message count AND IF count is 1, get message info.
3459: FND_MSG_PUB.Count_AND_Get
3460: ( p_count => x_msg_count,
3461: p_data => x_msg_data,
3462: p_encoded => FND_API.G_FALSE
3463: );

Line 3470: FND_MSG_PUB.Count_AND_Get

3466: WHEN FND_API.G_EXC_ERROR THEN
3467: ROLLBACK TO Copy_Lists_PVT;
3468: x_return_status := FND_API.G_RET_STS_ERROR ;
3469:
3470: FND_MSG_PUB.Count_AND_Get
3471: ( p_count => x_msg_count,
3472: p_data => x_msg_data,
3473: p_encoded => FND_API.G_FALSE
3474: );

Line 3480: FND_MSG_PUB.Count_AND_Get

3476:
3477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3478: ROLLBACK TO Copy_Lists_PVT;
3479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3480: FND_MSG_PUB.Count_AND_Get
3481: ( p_count => x_msg_count,
3482: p_data => x_msg_data,
3483: p_encoded => FND_API.G_FALSE
3484: );

Line 3489: FND_MSG_PUB.Add;

3485:
3486: WHEN OTHERS THEN
3487: ROLLBACK TO Copy_Lists_PVT;
3488: FND_MESSAGE.set_name('AMS','SQL ERROR ->' || sqlerrm );
3489: FND_MSG_PUB.Add;
3490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3491: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3493: END IF;

Line 3491: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

3487: ROLLBACK TO Copy_Lists_PVT;
3488: FND_MESSAGE.set_name('AMS','SQL ERROR ->' || sqlerrm );
3489: FND_MSG_PUB.Add;
3490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3491: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3493: END IF;
3494:
3495: FND_MSG_PUB.Count_AND_Get

Line 3492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

3488: FND_MESSAGE.set_name('AMS','SQL ERROR ->' || sqlerrm );
3489: FND_MSG_PUB.Add;
3490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3491: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3493: END IF;
3494:
3495: FND_MSG_PUB.Count_AND_Get
3496: ( p_count => x_msg_count,

Line 3495: FND_MSG_PUB.Count_AND_Get

3491: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3493: END IF;
3494:
3495: FND_MSG_PUB.Count_AND_Get
3496: ( p_count => x_msg_count,
3497: p_data => x_msg_data,
3498: p_encoded => FND_API.G_FALSE
3499: );