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

Line 64: FND_MSG_PUB.initialize;

60: END IF;
61: -- Initialize message list IF p_init_msg_list is set to TRUE.
62: IF FND_API.to_Boolean( p_init_msg_list )
63: THEN
64: FND_MSG_PUB.initialize;
65: END IF;
66: -- Initialize API return status to success
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68: --

Line 82: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

78: ,x_msg_count => x_msg_count
79: ,x_msg_data => x_msg_data
80: ,p_act_DelvMethod_rec => l_act_DelvMethod_rec
81: );
82: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
83: THEN
84: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
85: FND_MSG_PUB.add;
86: END IF;

Line 85: FND_MSG_PUB.add;

81: );
82: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
83: THEN
84: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
85: FND_MSG_PUB.add;
86: END IF;
87: -- If any errors happen abort API.
88: IF l_return_status = FND_API.G_RET_STS_ERROR
89: THEN

Line 171: FND_MSG_PUB.Count_AND_Get

167: THEN
168: COMMIT WORK;
169: END IF;
170: -- Standard call to get message count AND IF count is 1, get message info.
171: FND_MSG_PUB.Count_AND_Get
172: ( p_count => x_msg_count,
173: p_data => x_msg_data,
174: p_encoded => FND_API.G_FALSE
175: );

Line 180: FND_MSG_PUB.Count_AND_Get

176: EXCEPTION
177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO Create_Act_DelvMethod_PVT;
179: x_return_status := FND_API.G_RET_STS_ERROR ;
180: FND_MSG_PUB.Count_AND_Get
181: ( p_count => x_msg_count,
182: p_data => x_msg_data,
183: p_encoded => FND_API.G_FALSE
184: );

Line 188: FND_MSG_PUB.Count_AND_Get

184: );
185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
186: ROLLBACK TO Create_Act_DelvMethod_PVT;
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
188: FND_MSG_PUB.Count_AND_Get
189: ( p_count => x_msg_count,
190: p_data => x_msg_data,
191: p_encoded => FND_API.G_FALSE
192: );

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

192: );
193: WHEN OTHERS THEN
194: ROLLBACK TO Create_Act_DelvMethod_PVT;
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
196: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
197: THEN
198: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
199: END IF;
200: FND_MSG_PUB.Count_AND_Get

Line 198: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

194: ROLLBACK TO Create_Act_DelvMethod_PVT;
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
196: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
197: THEN
198: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
199: END IF;
200: FND_MSG_PUB.Count_AND_Get
201: ( p_count => x_msg_count,
202: p_data => x_msg_data,

Line 200: FND_MSG_PUB.Count_AND_Get

196: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
197: THEN
198: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
199: END IF;
200: FND_MSG_PUB.Count_AND_Get
201: ( p_count => x_msg_count,
202: p_data => x_msg_data,
203: p_encoded => FND_API.G_FALSE
204: );

Line 247: FND_MSG_PUB.initialize;

243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245: -- Initialize message list IF p_init_msg_list is set to TRUE.
246: IF FND_API.to_Boolean( p_init_msg_list ) THEN
247: FND_MSG_PUB.initialize;
248: END IF;
249: -- Initialize API return status to success
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251: --

Line 312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

308: IF (SQL%NOTFOUND)
309: THEN
310: -- Error, check the msg level and added an error message to the
311: -- API message list
312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
313: THEN -- MMSG
314: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
315: FND_MSG_PUB.Add;
316: END IF;

Line 315: FND_MSG_PUB.Add;

311: -- API message list
312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
313: THEN -- MMSG
314: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
315: FND_MSG_PUB.Add;
316: END IF;
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: END IF;
319: --

Line 328: FND_MSG_PUB.Count_AND_Get

324: THEN
325: COMMIT WORK;
326: END IF;
327: -- Standard call to get message count AND IF count is 1, get message info.
328: FND_MSG_PUB.Count_AND_Get
329: ( p_count => x_msg_count,
330: p_data => x_msg_data,
331: p_encoded => FND_API.G_FALSE
332: );

Line 337: FND_MSG_PUB.Count_AND_Get

333: EXCEPTION
334: WHEN FND_API.G_EXC_ERROR THEN
335: ROLLBACK TO Update_Act_DelvMethod_PVT;
336: x_return_status := FND_API.G_RET_STS_ERROR ;
337: FND_MSG_PUB.Count_AND_Get
338: ( p_count => x_msg_count,
339: p_data => x_msg_data,
340: p_encoded => FND_API.G_FALSE
341: );

Line 345: FND_MSG_PUB.Count_AND_Get

341: );
342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
343: ROLLBACK TO Update_Act_DelvMethod_PVT;
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
345: FND_MSG_PUB.Count_AND_Get
346: ( p_count => x_msg_count,
347: p_data => x_msg_data,
348: p_encoded => FND_API.G_FALSE
349: );

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

349: );
350: WHEN OTHERS THEN
351: ROLLBACK TO Update_Act_DelvMethod_PVT;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
353: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
354: THEN
355: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
356: END IF;
357: FND_MSG_PUB.Count_AND_Get

Line 355: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

351: ROLLBACK TO Update_Act_DelvMethod_PVT;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
353: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
354: THEN
355: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
356: END IF;
357: FND_MSG_PUB.Count_AND_Get
358: ( p_count => x_msg_count,
359: p_data => x_msg_data,

Line 357: FND_MSG_PUB.Count_AND_Get

353: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
354: THEN
355: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
356: END IF;
357: FND_MSG_PUB.Count_AND_Get
358: ( p_count => x_msg_count,
359: p_data => x_msg_data,
360: p_encoded => FND_API.G_FALSE
361: );

Line 405: FND_MSG_PUB.initialize;

401: END IF;
402: -- Initialize message list IF p_init_msg_list is set to TRUE.
403: IF FND_API.to_Boolean( p_init_msg_list )
404: THEN
405: FND_MSG_PUB.initialize;
406: END IF;
407: -- Initialize API return status to success
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409: --

Line 421: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)

417: IF SQL%NOTFOUND THEN
418: --
419: -- Add error message to API message list.
420: --
421: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
422: THEN
423: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
424: FND_MSG_PUB.add;
425: END IF;

Line 424: FND_MSG_PUB.add;

420: --
421: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
422: THEN
423: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
424: FND_MSG_PUB.add;
425: END IF;
426: RAISE FND_API.G_EXC_ERROR;
427: END IF;
428: --

Line 437: FND_MSG_PUB.Count_AND_Get

433: THEN
434: COMMIT WORK;
435: END IF;
436: -- Standard call to get message count AND IF count is 1, get message info.
437: FND_MSG_PUB.Count_AND_Get
438: ( p_count => x_msg_count,
439: p_data => x_msg_data,
440: p_encoded => FND_API.G_FALSE
441: );

Line 446: FND_MSG_PUB.Count_AND_Get

442: EXCEPTION
443: WHEN FND_API.G_EXC_ERROR THEN
444: ROLLBACK TO Delete_Act_DelvMethod_PVT;
445: x_return_status := FND_API.G_RET_STS_ERROR ;
446: FND_MSG_PUB.Count_AND_Get
447: ( p_count => x_msg_count,
448: p_data => x_msg_data,
449: p_encoded => FND_API.G_FALSE
450: );

Line 454: FND_MSG_PUB.Count_AND_Get

450: );
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: ROLLBACK TO Delete_Act_DelvMethod_PVT;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
454: FND_MSG_PUB.Count_AND_Get
455: ( p_count => x_msg_count,
456: p_data => x_msg_data,
457: p_encoded => FND_API.G_FALSE
458: );

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

458: );
459: WHEN OTHERS THEN
460: ROLLBACK TO Delete_Act_DelvMethod_PVT;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
462: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
463: THEN
464: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
465: END IF;
466: FND_MSG_PUB.Count_AND_Get

Line 464: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

460: ROLLBACK TO Delete_Act_DelvMethod_PVT;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
462: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
463: THEN
464: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
465: END IF;
466: FND_MSG_PUB.Count_AND_Get
467: ( p_count => x_msg_count,
468: p_data => x_msg_data,

Line 466: FND_MSG_PUB.Count_AND_Get

462: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
463: THEN
464: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
465: END IF;
466: FND_MSG_PUB.Count_AND_Get
467: ( p_count => x_msg_count,
468: p_data => x_msg_data,
469: p_encoded => FND_API.G_FALSE
470: );

Line 518: FND_MSG_PUB.initialize;

514: END IF;
515: -- Initialize message list if p_init_msg_list is set to TRUE.
516: IF FND_API.to_Boolean( p_init_msg_list )
517: THEN
518: FND_MSG_PUB.initialize;
519: END IF;
520: -- Initialize API return status to success
521: x_return_status := FND_API.G_RET_STS_SUCCESS;
522: --

Line 532: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

528: IF (c_act_delivery_method%NOTFOUND) THEN
529: CLOSE c_act_delivery_method;
530: -- Error, check the msg level and added an error message to the
531: -- API message list
532: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
533: THEN -- MMSG
534: FND_MESSAGE.Set_Name('AMS', 'AMS_API_RECORD_NOT_FOUND');
535: FND_MSG_PUB.Add;
536: END IF;

Line 535: FND_MSG_PUB.Add;

531: -- API message list
532: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
533: THEN -- MMSG
534: FND_MESSAGE.Set_Name('AMS', 'AMS_API_RECORD_NOT_FOUND');
535: FND_MSG_PUB.Add;
536: END IF;
537: RAISE FND_API.G_EXC_ERROR;
538: END IF;
539: CLOSE c_act_delivery_method;

Line 544: FND_MSG_PUB.Count_AND_Get

540: --
541: -- END of API body.
542: --
543: -- Standard call to get message count AND IF count is 1, get message info.
544: FND_MSG_PUB.Count_AND_Get
545: ( p_count => x_msg_count,
546: p_data => x_msg_data,
547: p_encoded => FND_API.G_FALSE
548: );

Line 552: FND_MSG_PUB.Count_AND_Get

548: );
549: EXCEPTION
550: WHEN FND_API.G_EXC_ERROR THEN
551: x_return_status := FND_API.G_RET_STS_ERROR ;
552: FND_MSG_PUB.Count_AND_Get
553: ( p_count => x_msg_count,
554: p_data => x_msg_data,
555: p_encoded => FND_API.G_FALSE
556: );

Line 559: FND_MSG_PUB.Count_AND_Get

555: p_encoded => FND_API.G_FALSE
556: );
557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
559: FND_MSG_PUB.Count_AND_Get
560: ( p_count => x_msg_count,
561: p_data => x_msg_data,
562: p_encoded => FND_API.G_FALSE
563: );

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

562: p_encoded => FND_API.G_FALSE
563: );
564: WHEN AMS_Utility_PVT.resource_locked THEN
565: x_return_status := FND_API.g_ret_sts_error;
566: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
567: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
568: FND_MSG_PUB.add;
569: END IF;
570: FND_MSG_PUB.Count_AND_Get

Line 568: FND_MSG_PUB.add;

564: WHEN AMS_Utility_PVT.resource_locked THEN
565: x_return_status := FND_API.g_ret_sts_error;
566: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
567: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
568: FND_MSG_PUB.add;
569: END IF;
570: FND_MSG_PUB.Count_AND_Get
571: ( p_count => x_msg_count,
572: p_data => x_msg_data,

Line 570: FND_MSG_PUB.Count_AND_Get

566: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
567: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
568: FND_MSG_PUB.add;
569: END IF;
570: FND_MSG_PUB.Count_AND_Get
571: ( p_count => x_msg_count,
572: p_data => x_msg_data,
573: p_encoded => FND_API.G_FALSE
574: );

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

573: p_encoded => FND_API.G_FALSE
574: );
575: WHEN OTHERS THEN
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
577: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
578: THEN
579: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
580: END IF;
581: FND_MSG_PUB.Count_AND_Get

Line 579: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

575: WHEN OTHERS THEN
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
577: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
578: THEN
579: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
580: END IF;
581: FND_MSG_PUB.Count_AND_Get
582: ( p_count => x_msg_count,
583: p_data => x_msg_data,

Line 581: FND_MSG_PUB.Count_AND_Get

577: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
578: THEN
579: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
580: END IF;
581: FND_MSG_PUB.Count_AND_Get
582: ( p_count => x_msg_count,
583: p_data => x_msg_data,
584: p_encoded => FND_API.G_FALSE
585: );

Line 627: FND_MSG_PUB.initialize;

623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
624: END IF;
625: -- Initialize message list if p_init_msg_list is set to TRUE.
626: IF FND_API.to_Boolean( p_init_msg_list ) THEN
627: FND_MSG_PUB.initialize;
628: END IF;
629: -- Initialize API return status to success
630: x_return_status := FND_API.G_RET_STS_SUCCESS;
631: --

Line 671: FND_MSG_PUB.count_and_get(

667: --
668: -- END of API body.
669: --
670: -------------------- finish --------------------------
671: FND_MSG_PUB.count_and_get(
672: p_encoded => FND_API.g_false,
673: p_count => x_msg_count,
674: p_data => x_msg_data
675: );

Line 679: FND_MSG_PUB.Count_AND_Get

675: );
676: EXCEPTION
677: WHEN FND_API.G_EXC_ERROR THEN
678: x_return_status := FND_API.G_RET_STS_ERROR ;
679: FND_MSG_PUB.Count_AND_Get
680: ( p_count => x_msg_count,
681: p_data => x_msg_data,
682: p_encoded => FND_API.G_FALSE
683: );

Line 686: FND_MSG_PUB.Count_AND_Get

682: p_encoded => FND_API.G_FALSE
683: );
684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
686: FND_MSG_PUB.Count_AND_Get
687: ( p_count => x_msg_count,
688: p_data => x_msg_data,
689: p_encoded => FND_API.G_FALSE
690: );

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

689: p_encoded => FND_API.G_FALSE
690: );
691: WHEN OTHERS THEN
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
693: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
694: THEN
695: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
696: END IF;
697: FND_MSG_PUB.Count_AND_Get

Line 695: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

691: WHEN OTHERS THEN
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
693: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
694: THEN
695: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
696: END IF;
697: FND_MSG_PUB.Count_AND_Get
698: ( p_count => x_msg_count,
699: p_data => x_msg_data,

Line 697: FND_MSG_PUB.Count_AND_Get

693: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
694: THEN
695: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
696: END IF;
697: FND_MSG_PUB.Count_AND_Get
698: ( p_count => x_msg_count,
699: p_data => x_msg_data,
700: p_encoded => FND_API.G_FALSE
701: );

Line 728: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)

724: IF (p_act_DelvMethod_rec.ACT_DELIVERY_METHOD_USED_BY_ID = FND_API.G_MISS_NUM OR
725: p_act_DelvMethod_rec.ACT_DELIVERY_METHOD_USED_BY_ID IS NULL)
726: THEN
727: -- missing required fields
728: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
729: THEN -- MMSG
730: FND_MESSAGE.set_name('AMS', 'AMS_ACT_DLV_NO_USEDBYID');
731: FND_MSG_PUB.add;
732: END IF;

Line 731: FND_MSG_PUB.add;

727: -- missing required fields
728: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
729: THEN -- MMSG
730: FND_MESSAGE.set_name('AMS', 'AMS_ACT_DLV_NO_USEDBYID');
731: FND_MSG_PUB.add;
732: END IF;
733: x_return_status := FND_API.G_RET_STS_ERROR;
734: -- If any error happens abort API.
735: RETURN;

Line 742: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)

738: IF (p_act_DelvMethod_rec.ARC_ACT_DELIVERY_USED_BY = FND_API.G_MISS_CHAR OR
739: p_act_DelvMethod_rec.ARC_ACT_DELIVERY_USED_BY IS NULL)
740: THEN
741: -- missing required fields
742: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
743: THEN -- MMSG
744: FND_MESSAGE.set_name('AMS', 'AMS_ACT_DLV_NO_USEDBY');
745: FND_MSG_PUB.add;
746: END IF;

Line 745: FND_MSG_PUB.add;

741: -- missing required fields
742: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
743: THEN -- MMSG
744: FND_MESSAGE.set_name('AMS', 'AMS_ACT_DLV_NO_USEDBY');
745: FND_MSG_PUB.add;
746: END IF;
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: -- If any error happens abort API.
749: RETURN;

Line 755: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)

751: IF (p_act_DelvMethod_rec.delivery_media_type_code = FND_API.G_MISS_CHAR OR
752: p_act_DelvMethod_rec.delivery_media_type_code IS NULL)
753: THEN
754: -- missing required fields
755: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
756: THEN -- MMSG
757: FND_MESSAGE.set_name('AMS', 'AMS_ACT_DLV_NO_DELV_MEDIA');
758: FND_MSG_PUB.add;
759: END IF;

Line 758: FND_MSG_PUB.add;

754: -- missing required fields
755: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
756: THEN -- MMSG
757: FND_MESSAGE.set_name('AMS', 'AMS_ACT_DLV_NO_DELV_MEDIA');
758: FND_MSG_PUB.add;
759: END IF;
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: -- If any error happens abort API.
762: RETURN;

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

769: 'ams_act_delivery_methods',
770: 'activity_delivery_method_id = ' || p_act_DelvMethod_rec.activity_delivery_method_id
771: ) = FND_API.g_false
772: THEN
773: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
774: THEN
775: FND_MESSAGE.set_name('AMS', 'AMS_ACT_DLV_DUPLICATE_ID');
776: FND_MSG_PUB.add;
777: END IF;

Line 776: FND_MSG_PUB.add;

772: THEN
773: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
774: THEN
775: FND_MESSAGE.set_name('AMS', 'AMS_ACT_DLV_DUPLICATE_ID');
776: FND_MSG_PUB.add;
777: END IF;
778: x_return_status := FND_API.g_ret_sts_error;
779: RETURN;
780: END IF;

Line 799: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)

795: ,p_pk_name => l_pk_name
796: ,p_pk_value => l_pk_value
797: ) = FND_API.G_FALSE
798: THEN
799: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
800: THEN
801: FND_MESSAGE.set_name('AMS', 'AMS_ACT_DLV_INVALID_REFERENCE');
802: FND_MSG_PUB.add;
803: END IF;

Line 802: FND_MSG_PUB.add;

798: THEN
799: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
800: THEN
801: FND_MESSAGE.set_name('AMS', 'AMS_ACT_DLV_INVALID_REFERENCE');
802: FND_MSG_PUB.add;
803: END IF;
804: x_return_status := FND_API.G_RET_STS_ERROR;
805: -- If any errors happen abort API/Procedure.
806: RETURN;

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

814: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
815: p_lookup_code => p_act_DelvMethod_rec.arc_act_delivery_used_by
816: ) = FND_API.g_false
817: THEN
818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
819: THEN
820: FND_MESSAGE.set_name('AMS', 'AMS_ACT_DLV_BAD_SYS_ARC');
821: FND_MSG_PUB.add;
822: END IF;

Line 821: FND_MSG_PUB.add;

817: THEN
818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
819: THEN
820: FND_MESSAGE.set_name('AMS', 'AMS_ACT_DLV_BAD_SYS_ARC');
821: FND_MSG_PUB.add;
822: END IF;
823: x_return_status := FND_API.g_ret_sts_error;
824: RETURN;
825: END IF;

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

829: p_lookup_type => 'AMS_DELIVERY_MEDIA_TYPE',
830: p_lookup_code => p_act_DelvMethod_rec.DELIVERY_MEDIA_TYPE_CODE
831: ) = FND_API.g_false
832: THEN
833: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
834: THEN
835: FND_MESSAGE.set_name('AMS', 'AMS_ACT_DLV_BAD_DELV_MEDIA');
836: FND_MSG_PUB.add;
837: END IF;

Line 836: FND_MSG_PUB.add;

832: THEN
833: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
834: THEN
835: FND_MESSAGE.set_name('AMS', 'AMS_ACT_DLV_BAD_DELV_MEDIA');
836: FND_MSG_PUB.add;
837: END IF;
838: x_return_status := FND_API.g_ret_sts_error;
839: RETURN;
840: END IF;

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

933: OPEN c_dlv;
934: FETCH c_dlv INTO l_act_DelvMethod_rec;
935: IF c_dlv%NOTFOUND THEN
936: CLOSE c_dlv;
937: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
938: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
939: FND_MSG_PUB.add;
940: END IF;
941: RAISE FND_API.g_exc_error;

Line 939: FND_MSG_PUB.add;

935: IF c_dlv%NOTFOUND THEN
936: CLOSE c_dlv;
937: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
938: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
939: FND_MSG_PUB.add;
940: END IF;
941: RAISE FND_API.g_exc_error;
942: END IF;
943: CLOSE c_dlv;