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

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

52: -- 10/26/1999 ptendulk Modified according to new standards
53: -- 22/04/03 cgoyal added ACTION_NOTIF_USER_ID column value insert, for 11.5.8 backport
54: -- End of Comments
55:
56: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
57: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
58: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
59:
60: PROCEDURE Create_thldact

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

53: -- 22/04/03 cgoyal added ACTION_NOTIF_USER_ID column value insert, for 11.5.8 backport
54: -- End of Comments
55:
56: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
57: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
58: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
59:
60: PROCEDURE Create_thldact
61: ( p_api_version IN NUMBER,

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

54: -- End of Comments
55:
56: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
57: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
58: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
59:
60: PROCEDURE Create_thldact
61: ( p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 := FND_API.G_False,

Line 104: FND_MSG_PUB.initialize;

100: --
101: -- Initialize message list IF p_init_msg_list is set to TRUE.
102: --
103: IF FND_API.to_Boolean( p_init_msg_list ) THEN
104: FND_MSG_PUB.initialize;
105: END IF;
106:
107: --
108: -- Standard call to check for call compatibility.

Line 313: FND_MSG_PUB.Count_AND_Get

309: END IF;
310: --
311: -- Standard call to get message count AND IF count is 1, get message info.
312: --
313: FND_MSG_PUB.Count_AND_Get
314: (
315: p_count => x_msg_count,
316: p_data => x_msg_data,
317: p_encoded => FND_API.G_FALSE

Line 329: FND_MSG_PUB.Count_AND_Get

325: WHEN FND_API.G_EXC_ERROR THEN
326: ROLLBACK TO Create_Thldact_PVT;
327: x_return_status := FND_API.G_RET_STS_ERROR ;
328:
329: FND_MSG_PUB.Count_AND_Get
330: ( p_count => x_msg_count,
331: p_data => x_msg_data,
332: p_encoded => FND_API.G_FALSE
333: );

Line 338: FND_MSG_PUB.Count_AND_Get

334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
335: ROLLBACK TO Create_Thldact_PVT;
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
337:
338: FND_MSG_PUB.Count_AND_Get
339: ( p_count => x_msg_count,
340: p_data => x_msg_data,
341: p_encoded => FND_API.G_FALSE
342: );

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

343: WHEN OTHERS THEN
344: ROLLBACK TO Create_Thldact_PVT;
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
346:
347: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
348: THEN
349: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
350: END IF;
351:

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

345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
346:
347: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
348: THEN
349: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
350: END IF;
351:
352: FND_MSG_PUB.Count_AND_Get
353: ( p_count => x_msg_count,

Line 352: FND_MSG_PUB.Count_AND_Get

348: THEN
349: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
350: END IF;
351:
352: FND_MSG_PUB.Count_AND_Get
353: ( p_count => x_msg_count,
354: p_data => x_msg_data,
355: p_encoded => FND_API.G_FALSE
356: );

Line 410: FND_MSG_PUB.initialize;

406: --
407: -- Initialize message list IF p_init_msg_list is set to TRUE.
408: --
409: IF FND_API.to_Boolean( p_init_msg_list ) THEN
410: FND_MSG_PUB.initialize;
411: END IF;
412:
413: --
414: -- Standard call to check for call compatibility.

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

448:
449: IF (SQL%NOTFOUND) THEN
450: -- Error, check the msg level and added an error message to the
451: -- API message list
452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
453: THEN -- MMSG
454: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
455: FND_MSG_PUB.Add;
456: END IF;

Line 455: FND_MSG_PUB.Add;

451: -- API message list
452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
453: THEN -- MMSG
454: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
455: FND_MSG_PUB.Add;
456: END IF;
457:
458: RAISE FND_API.G_EXC_ERROR;
459: END IF;

Line 475: FND_MSG_PUB.Count_AND_Get

471:
472: --
473: -- Standard call to get message count AND IF count is 1, get message info.
474: --
475: FND_MSG_PUB.Count_AND_Get
476: ( p_count => x_msg_count,
477: p_data => x_msg_data,
478: p_encoded => FND_API.G_FALSE
479: );

Line 487: FND_MSG_PUB.Count_AND_Get

483:
484: ROLLBACK TO Delete_Thldact_PVT;
485: x_return_status := FND_API.G_RET_STS_ERROR ;
486:
487: FND_MSG_PUB.Count_AND_Get
488: ( p_count => x_msg_count,
489: p_data => x_msg_data,
490: p_encoded => FND_API.G_FALSE
491: );

Line 497: FND_MSG_PUB.Count_AND_Get

493:
494: ROLLBACK TO Delete_Thldact_PVT;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
496:
497: FND_MSG_PUB.Count_AND_Get
498: ( p_count => x_msg_count,
499: p_data => x_msg_data,
500: p_encoded => FND_API.G_FALSE
501: );

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

503:
504: ROLLBACK TO Delete_Thldact_PVT;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
506:
507: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
508: THEN
509: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
510: END IF;
511:

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

505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
506:
507: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
508: THEN
509: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
510: END IF;
511:
512: FND_MSG_PUB.Count_AND_Get
513: ( p_count => x_msg_count,

Line 512: FND_MSG_PUB.Count_AND_Get

508: THEN
509: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
510: END IF;
511:
512: FND_MSG_PUB.Count_AND_Get
513: ( p_count => x_msg_count,
514: p_data => x_msg_data,
515: p_encoded => FND_API.G_FALSE
516: );

Line 575: FND_MSG_PUB.initialize;

571: --
572: -- Initialize message list if p_init_msg_list is set to TRUE.
573: --
574: IF FND_API.to_boolean(p_init_msg_list) THEN
575: FND_MSG_PUB.initialize;
576: END IF;
577:
578: --
579: -- Standard call to check for call compatibility.

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

607: IF (C_ams_trigger_actions%NOTFOUND) THEN
608: CLOSE C_ams_trigger_actions;
609: -- Error, check the msg level and added an error message to the
610: -- API message list
611: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
612: THEN -- MMSG
613: FND_MESSAGE.Set_Name('FND', 'AMS_API_RECORD_NOT_FOUND');
614: FND_MSG_PUB.Add;
615: END IF;

Line 614: FND_MSG_PUB.Add;

610: -- API message list
611: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
612: THEN -- MMSG
613: FND_MESSAGE.Set_Name('FND', 'AMS_API_RECORD_NOT_FOUND');
614: FND_MSG_PUB.Add;
615: END IF;
616:
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;

Line 629: FND_MSG_PUB.Count_AND_Get

625:
626: --
627: -- Standard call to get message count AND IF count is 1, get message info.
628: --
629: FND_MSG_PUB.Count_AND_Get
630: ( p_count => x_msg_count,
631: p_data => x_msg_data,
632: p_encoded => FND_API.G_FALSE
633: );

Line 646: FND_MSG_PUB.Count_AND_Get

642: EXCEPTION
643: WHEN FND_API.G_EXC_ERROR THEN
644: x_return_status := FND_API.G_RET_STS_ERROR ;
645:
646: FND_MSG_PUB.Count_AND_Get
647: ( p_count => x_msg_count,
648: p_data => x_msg_data,
649: p_encoded => FND_API.G_FALSE
650: );

Line 654: FND_MSG_PUB.Count_AND_Get

650: );
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
653:
654: FND_MSG_PUB.Count_AND_Get
655: ( p_count => x_msg_count,
656: p_data => x_msg_data,
657: p_encoded => FND_API.G_FALSE
658: );

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

658: );
659: WHEN AMS_UTILITY_PVT.RESOURCE_LOCKED THEN
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661:
662: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
663: THEN -- MMSG
664: FND_MESSAGE.SET_NAME('AMS','AMS_API_RESOURCE_LOCKED');
665: FND_MSG_PUB.Add;
666: END IF;

Line 665: FND_MSG_PUB.Add;

661:
662: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
663: THEN -- MMSG
664: FND_MESSAGE.SET_NAME('AMS','AMS_API_RESOURCE_LOCKED');
665: FND_MSG_PUB.Add;
666: END IF;
667:
668: FND_MSG_PUB.Count_AND_Get
669: ( p_count => x_msg_count,

Line 668: FND_MSG_PUB.Count_AND_Get

664: FND_MESSAGE.SET_NAME('AMS','AMS_API_RESOURCE_LOCKED');
665: FND_MSG_PUB.Add;
666: END IF;
667:
668: FND_MSG_PUB.Count_AND_Get
669: ( p_count => x_msg_count,
670: p_data => x_msg_data,
671: p_encoded => FND_API.G_FALSE
672: );

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

673:
674: WHEN OTHERS THEN
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
676:
677: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
678: THEN
679: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
680: END IF;
681:

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

675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
676:
677: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
678: THEN
679: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
680: END IF;
681:
682: FND_MSG_PUB.Count_AND_Get
683: ( p_count => x_msg_count,

Line 682: FND_MSG_PUB.Count_AND_Get

678: THEN
679: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
680: END IF;
681:
682: FND_MSG_PUB.Count_AND_Get
683: ( p_count => x_msg_count,
684: p_data => x_msg_data,
685: p_encoded => FND_API.G_FALSE
686: );

Line 746: FND_MSG_PUB.initialize;

742: --
743: -- Initialize message list IF p_init_msg_list is set to TRUE.
744: --
745: IF FND_API.to_Boolean( p_init_msg_list ) THEN
746: FND_MSG_PUB.initialize;
747: END IF;
748:
749: --
750: -- Standard call to check for call compatibility.

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

837:
838: IF (SQL%NOTFOUND) THEN
839: -- Error, check the msg level and added an error message to the
840: -- API message list
841: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
842: THEN -- MMSG
843:
844: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
845: FND_MSG_PUB.Add;

Line 845: FND_MSG_PUB.Add;

841: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
842: THEN -- MMSG
843:
844: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
845: FND_MSG_PUB.Add;
846: END IF;
847:
848: RAISE FND_API.G_EXC_ERROR;
849: END IF;

Line 864: FND_MSG_PUB.Count_AND_Get

860:
861: --
862: -- Standard call to get message count AND IF count is 1, get message info.
863: --
864: FND_MSG_PUB.Count_AND_Get
865: ( p_count => x_msg_count,
866: p_data => x_msg_data,
867: p_encoded => FND_API.G_FALSE
868: );

Line 884: FND_MSG_PUB.Count_AND_Get

880:
881: ROLLBACK TO Update_Thldact_PVT;
882: x_return_status := FND_API.G_RET_STS_ERROR ;
883:
884: FND_MSG_PUB.Count_AND_Get
885: ( p_count => x_msg_count,
886: p_data => x_msg_data,
887: p_encoded => FND_API.G_FALSE
888: );

Line 894: FND_MSG_PUB.Count_AND_Get

890:
891: ROLLBACK TO Update_Thldact_PVT;
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
893:
894: FND_MSG_PUB.Count_AND_Get
895: ( p_count => x_msg_count,
896: p_data => x_msg_data,
897: p_encoded => FND_API.G_FALSE
898: );

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

900:
901: ROLLBACK TO Update_Thldact_PVT;
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
903:
904: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
905: THEN
906: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
907: END IF;
908:

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

902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
903:
904: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
905: THEN
906: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
907: END IF;
908:
909: FND_MSG_PUB.Count_AND_Get
910: ( p_count => x_msg_count,

Line 909: FND_MSG_PUB.Count_AND_Get

905: THEN
906: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
907: END IF;
908:
909: FND_MSG_PUB.Count_AND_Get
910: ( p_count => x_msg_count,
911: p_data => x_msg_data,
912: p_encoded => FND_API.G_FALSE
913: );

Line 964: FND_MSG_PUB.initialize;

960: END IF;
961:
962: -- Initialize message list if p_init_msg_list is set to TRUE.
963: IF FND_API.to_Boolean( p_init_msg_list ) THEN
964: FND_MSG_PUB.initialize;
965: END IF;
966:
967: -- Standard call to check for call compatibility.
968: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 1024: FND_MSG_PUB.Count_AND_Get

1020:
1021: --
1022: -- Standard call to get message count AND IF count is 1, get message info.
1023: --
1024: FND_MSG_PUB.Count_AND_Get
1025: ( p_count => x_msg_count,
1026: p_data => x_msg_data,
1027: p_encoded => FND_API.G_FALSE
1028: );

Line 1046: FND_MSG_PUB.Count_AND_Get

1042: WHEN FND_API.G_EXC_ERROR THEN
1043:
1044: x_return_status := FND_API.G_RET_STS_ERROR ;
1045:
1046: FND_MSG_PUB.Count_AND_Get
1047: ( p_count => x_msg_count,
1048: p_data => x_msg_data,
1049: p_encoded => FND_API.G_FALSE
1050: );

Line 1057: FND_MSG_PUB.Count_AND_Get

1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054:
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1056:
1057: FND_MSG_PUB.Count_AND_Get
1058: ( p_count => x_msg_count,
1059: p_data => x_msg_data,
1060: p_encoded => FND_API.G_FALSE
1061: );

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

1064: WHEN OTHERS THEN
1065:
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1067:
1068: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1069: THEN
1070: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1071: END IF;
1072:

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

1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1067:
1068: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1069: THEN
1070: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1071: END IF;
1072:
1073: FND_MSG_PUB.Count_AND_Get
1074: ( p_count => x_msg_count,

Line 1073: FND_MSG_PUB.Count_AND_Get

1069: THEN
1070: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1071: END IF;
1072:
1073: FND_MSG_PUB.Count_AND_Get
1074: ( p_count => x_msg_count,
1075: p_data => x_msg_data,
1076: p_encoded => FND_API.G_FALSE
1077: );

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

1115: --
1116: IF p_thldact_rec.trigger_id IS NULL
1117: THEN
1118: -- missing required field
1119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1120: THEN -- MMSG
1121: --dbms_output.put_line('trigger_id is missing');
1122: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_TRIG_ID');
1123: FND_MSG_PUB.Add;

Line 1123: FND_MSG_PUB.Add;

1119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1120: THEN -- MMSG
1121: --dbms_output.put_line('trigger_id is missing');
1122: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_TRIG_ID');
1123: FND_MSG_PUB.Add;
1124: END IF;
1125: x_return_status := FND_API.G_RET_STS_ERROR;
1126: -- If any errors happen abort API/Procedure.
1127: return;

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

1171: 'ams_trigger_actions',
1172: 'trigger_action_id = ' || p_thldact_rec.trigger_action_id
1173: ) = FND_API.g_false
1174: THEN
1175: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1176: THEN
1177: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_DUPLICATE_ACTION');
1178: FND_MSG_PUB.add;
1179: END IF;

Line 1178: FND_MSG_PUB.add;

1174: THEN
1175: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1176: THEN
1177: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_DUPLICATE_ACTION');
1178: FND_MSG_PUB.add;
1179: END IF;
1180: x_return_status := FND_API.g_ret_sts_error;
1181: RETURN;
1182: END IF;

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

1201: p_table_name => 'ams_trigger_actions',
1202: p_where_clause => l_where_clause
1203: ) = FND_API.g_false
1204: THEN
1205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1206: THEN
1207: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_DUP_TRIG_ID');
1208: FND_MSG_PUB.add;
1209: END IF;

Line 1208: FND_MSG_PUB.add;

1204: THEN
1205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1206: THEN
1207: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_DUP_TRIG_ID');
1208: FND_MSG_PUB.add;
1209: END IF;
1210: x_return_status := FND_API.g_ret_sts_error;
1211: RETURN;
1212: END IF;

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

1267: ,p_pk_data_type => l_pk_data_type
1268: ,p_additional_where_clause => l_additional_where_clause
1269: ) = FND_API.G_FALSE THEN
1270: -- invalid item
1271: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1272: THEN -- MMSG
1273: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1274: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_TRIGGER_ID');
1275: FND_MSG_PUB.Add;

Line 1275: FND_MSG_PUB.Add;

1271: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1272: THEN -- MMSG
1273: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1274: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_TRIGGER_ID');
1275: FND_MSG_PUB.Add;
1276: END IF;
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278: -- If any errors happen abort API/Procedure.
1279: RETURN;

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

1308: ,p_pk_data_type => l_pk_data_type
1309: ,p_additional_where_clause => l_additional_where_clause
1310: ) = FND_API.G_FALSE THEN
1311: -- invalid item
1312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1313: THEN -- MMSG
1314: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1315: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_LIST');
1316: FND_MSG_PUB.Add;

Line 1316: FND_MSG_PUB.Add;

1312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1313: THEN -- MMSG
1314: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1315: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_LIST');
1316: FND_MSG_PUB.Add;
1317: END IF;
1318: x_return_status := FND_API.G_RET_STS_ERROR;
1319: -- If any errors happen abort API/Procedure.
1320: RETURN;

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

1347: ,p_additional_where_clause => l_additional_where_clause
1348: ) = FND_API.G_FALSE THEN
1349:
1350: -- invalid item
1351: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1352: THEN -- MMSG
1353: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1354: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_APPROVER');
1355: FND_MSG_PUB.Add;

Line 1355: FND_MSG_PUB.Add;

1351: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1352: THEN -- MMSG
1353: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1354: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_APPROVER');
1355: FND_MSG_PUB.Add;
1356: END IF;
1357: x_return_status := FND_API.G_RET_STS_ERROR;
1358: -- If any errors happen abort API/Procedure.
1359: RETURN;

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

1380: ,p_additional_where_clause => l_additional_where_clause
1381: ) = FND_API.G_FALSE THEN
1382:
1383: -- invalid item
1384: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1385: THEN -- MMSG
1386: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1387: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_DSCRIPT');
1388: FND_MSG_PUB.Add;

Line 1388: FND_MSG_PUB.Add;

1384: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1385: THEN -- MMSG
1386: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1387: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_DSCRIPT');
1388: FND_MSG_PUB.Add;
1389: END IF;
1390: x_return_status := FND_API.G_RET_STS_ERROR;
1391: -- If any errors happen abort API/Procedure.
1392: RETURN;

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

1413: ,p_additional_where_clause => l_additional_where_clause
1414: ) = FND_API.G_FALSE THEN
1415:
1416: -- invalid item
1417: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1418: THEN -- MMSG
1419: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1420: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_OFFER');
1421: FND_MSG_PUB.Add;

Line 1421: FND_MSG_PUB.Add;

1417: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1418: THEN -- MMSG
1419: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1420: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_OFFER');
1421: FND_MSG_PUB.Add;
1422: END IF;
1423: x_return_status := FND_API.G_RET_STS_ERROR;
1424: -- If any errors happen abort API/Procedure.
1425: RETURN;

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

1451: ,p_pk_data_type => l_pk_data_type
1452: ,p_additional_where_clause => l_additional_where_clause
1453: ) = FND_API.G_FALSE
1454: THEN
1455: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1456: FND_MESSAGE.Set_Name ('AMS', 'AMS_TRIG_INVALID_COVER_LETTER');
1457: FND_MSG_PUB.Add;
1458: END IF;
1459: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1457: FND_MSG_PUB.Add;

1453: ) = FND_API.G_FALSE
1454: THEN
1455: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1456: FND_MESSAGE.Set_Name ('AMS', 'AMS_TRIG_INVALID_COVER_LETTER');
1457: FND_MSG_PUB.Add;
1458: END IF;
1459: x_return_status := FND_API.G_RET_STS_ERROR;
1460: RETURN;
1461: END IF;

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

1505: ,p_lookup_type => 'AMS_TRIG_ACTION_TYPE'
1506: ,p_lookup_code => p_thldact_rec.execute_action_type
1507: ) = FND_API.G_FALSE then
1508: -- invalid item
1509: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1510: THEN -- MMSG
1511: -- DBMS_OUTPUT.Put_Line('Check1 Type is invalid');
1512: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_ACTION_TYPE');
1513: FND_MSG_PUB.Add;

Line 1513: FND_MSG_PUB.Add;

1509: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1510: THEN -- MMSG
1511: -- DBMS_OUTPUT.Put_Line('Check1 Type is invalid');
1512: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_ACTION_TYPE');
1513: FND_MSG_PUB.Add;
1514: END IF;
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: -- If any errors happen abort API/Procedure.
1517: RETURN;

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

1553: AND p_thldact_rec.notify_flag IS NOT NULL
1554: THEN
1555: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.notify_flag) = FND_API.g_false
1556: THEN
1557: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1558: THEN
1559: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_NOTIFY_FLAG');
1560: FND_MSG_PUB.add;
1561: END IF;

Line 1560: FND_MSG_PUB.add;

1556: THEN
1557: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1558: THEN
1559: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_NOTIFY_FLAG');
1560: FND_MSG_PUB.add;
1561: END IF;
1562:
1563: x_return_status := FND_API.g_ret_sts_error;
1564: RETURN;

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

1573: AND p_thldact_rec.generate_list_flag IS NOT NULL
1574: THEN
1575: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.generate_list_flag) = FND_API.g_false
1576: THEN
1577: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1578: THEN
1579: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_GEN_LIST_FLAG');
1580: FND_MSG_PUB.add;
1581: END IF;

Line 1580: FND_MSG_PUB.add;

1576: THEN
1577: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1578: THEN
1579: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_GEN_LIST_FLAG');
1580: FND_MSG_PUB.add;
1581: END IF;
1582:
1583: x_return_status := FND_API.g_ret_sts_error;
1584: RETURN;

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

1593: AND p_thldact_rec.action_need_approval_flag IS NOT NULL
1594: THEN
1595: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.action_need_approval_flag) = FND_API.g_false
1596: THEN
1597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1598: THEN
1599: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_APPR_FLAG');
1600: FND_MSG_PUB.add;
1601: END IF;

Line 1600: FND_MSG_PUB.add;

1596: THEN
1597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1598: THEN
1599: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_APPR_FLAG');
1600: FND_MSG_PUB.add;
1601: END IF;
1602:
1603: x_return_status := FND_API.g_ret_sts_error;
1604: RETURN;

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

1747: IF p_thldact_rec.generate_list_flag = 'Y' AND
1748: l_list_header_id IS NULL
1749: THEN
1750: -- missing required field
1751: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1752: THEN -- MMSG
1753: --dbms_output.put_line('list_use_this_source_code is missing');
1754: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_LIST');
1755: FND_MSG_PUB.Add;

Line 1755: FND_MSG_PUB.Add;

1751: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1752: THEN -- MMSG
1753: --dbms_output.put_line('list_use_this_source_code is missing');
1754: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_LIST');
1755: FND_MSG_PUB.Add;
1756: END IF;
1757: x_return_status := FND_API.G_RET_STS_ERROR;
1758: -- If any errors happen abort API/Procedure.
1759: RETURN;

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

1793: ,p_pk_data_type => l_pk_data_type
1794: ,p_additional_where_clause => l_additional_where_clause
1795: ) = FND_API.G_FALSE
1796: THEN
1797: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1798: FND_MESSAGE.Set_Name ('AMS', 'AMS_TRIG_INVALID_DELV_ID');
1799: FND_MSG_PUB.Add;
1800: END IF;
1801:

Line 1799: FND_MSG_PUB.Add;

1795: ) = FND_API.G_FALSE
1796: THEN
1797: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1798: FND_MESSAGE.Set_Name ('AMS', 'AMS_TRIG_INVALID_DELV_ID');
1799: FND_MSG_PUB.Add;
1800: END IF;
1801:
1802: x_return_status := FND_API.G_RET_STS_ERROR;
1803: RETURN;

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

1821:
1822: IF p_thldact_rec.cover_letter_id IS NULL
1823: THEN
1824: -- missing required field
1825: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1826: THEN -- MMSG
1827: --dbms_output.put_line('list_use_this_source_code is missing');
1828: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_COVER_LETTER');
1829: FND_MSG_PUB.Add;

Line 1829: FND_MSG_PUB.Add;

1825: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1826: THEN -- MMSG
1827: --dbms_output.put_line('list_use_this_source_code is missing');
1828: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_COVER_LETTER');
1829: FND_MSG_PUB.Add;
1830: END IF;
1831: x_return_status := FND_API.G_RET_STS_ERROR;
1832: -- If any errors happen abort API/Procedure.
1833: RETURN;

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

1839: --
1840: /*
1841: IF ((p_thldact_rec.ACTION_NOTIF_USER_ID IS NULL) OR (p_thldact_rec.ACTION_NOTIF_USER_ID = FND_API.G_MISS_NUM)) THEN
1842: IF p_thldact_rec.notify_flag = 'Y' THEN
1843: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1844: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_NOTIFY_USER');
1845: FND_MSG_PUB.Add;
1846: END IF;
1847: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1845: FND_MSG_PUB.Add;

1841: IF ((p_thldact_rec.ACTION_NOTIF_USER_ID IS NULL) OR (p_thldact_rec.ACTION_NOTIF_USER_ID = FND_API.G_MISS_NUM)) THEN
1842: IF p_thldact_rec.notify_flag = 'Y' THEN
1843: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1844: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_NOTIFY_USER');
1845: FND_MSG_PUB.Add;
1846: END IF;
1847: x_return_status := FND_API.G_RET_STS_ERROR;
1848: END IF;
1849: END IF;

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

1851:
1852: IF p_thldact_rec.execute_action_type = 'NOTIFY'
1853: AND ((p_thldact_rec.action_for_id IS NULL) OR (p_thldact_rec.action_for_id = FND_API.G_MISS_NUM))
1854: THEN
1855: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1856: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_NOTIFY_USER');
1857: FND_MSG_PUB.Add;
1858: END IF;
1859: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1857: FND_MSG_PUB.Add;

1853: AND ((p_thldact_rec.action_for_id IS NULL) OR (p_thldact_rec.action_for_id = FND_API.G_MISS_NUM))
1854: THEN
1855: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1856: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_NOTIFY_USER');
1857: FND_MSG_PUB.Add;
1858: END IF;
1859: x_return_status := FND_API.G_RET_STS_ERROR;
1860: END IF;
1861:

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

1952: OPEN c_thldact;
1953: FETCH c_thldact INTO l_thldact_rec;
1954: IF c_thldact%NOTFOUND THEN
1955: CLOSE c_thldact;
1956: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1957: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1958: FND_MSG_PUB.add;
1959: END IF;
1960: RAISE FND_API.g_exc_error;

Line 1958: FND_MSG_PUB.add;

1954: IF c_thldact%NOTFOUND THEN
1955: CLOSE c_thldact;
1956: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1957: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1958: FND_MSG_PUB.add;
1959: END IF;
1960: RAISE FND_API.g_exc_error;
1961: END IF;
1962: CLOSE c_thldact;