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

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

62: -- 13/jun/03 cgoyal modified create trigger method to create a row in the table
63: -- ams_trigger_actions for 11.5.8 backport
64: -- End of Comments
65:
66: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
67: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
68: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
69:
70: PROCEDURE Create_Trigger

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

63: -- ams_trigger_actions for 11.5.8 backport
64: -- End of Comments
65:
66: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
67: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
68: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
69:
70: PROCEDURE Create_Trigger
71: ( p_api_version IN NUMBER,

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

64: -- End of Comments
65:
66: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
67: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
68: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
69:
70: PROCEDURE Create_Trigger
71: ( p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 129: FND_MSG_PUB.initialize;

125:
126: END IF;
127:
128: IF FND_API.to_boolean(p_init_msg_list) THEN
129: FND_MSG_PUB.initialize;
130: END IF;
131:
132: --
133: -- Standard call to check for call compatibility.

Line 371: FND_MSG_PUB.Count_AND_Get

367:
368: --
369: -- Standard call to get message count AND IF count is 1, get message info.
370: --
371: FND_MSG_PUB.Count_AND_Get
372: ( p_count => x_msg_count,
373: p_data => x_msg_data,
374: p_encoded => FND_API.G_FALSE
375: );

Line 389: FND_MSG_PUB.Count_AND_Get

385: EXCEPTION
386: WHEN FND_API.G_EXC_ERROR THEN
387: ROLLBACK TO Create_Trig_PVT;
388: x_return_status := FND_API.G_RET_STS_ERROR ;
389: FND_MSG_PUB.Count_AND_Get
390: ( p_count => x_msg_count,
391: p_data => x_msg_data,
392: p_encoded => FND_API.G_FALSE
393: );

Line 398: FND_MSG_PUB.Count_AND_Get

394:
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: ROLLBACK TO Create_Trig_PVT;
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
398: FND_MSG_PUB.Count_AND_Get
399: ( p_count => x_msg_count,
400: p_data => x_msg_data,
401: p_encoded => FND_API.G_FALSE
402: );

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

403:
404: WHEN OTHERS THEN
405: ROLLBACK TO Create_Trig_PVT;
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
407: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
408: THEN
409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
410: END IF;
411:

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

405: ROLLBACK TO Create_Trig_PVT;
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
407: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
408: THEN
409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
410: END IF;
411:
412: FND_MSG_PUB.Count_AND_Get
413: ( p_count => x_msg_count,

Line 412: FND_MSG_PUB.Count_AND_Get

408: THEN
409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
410: END IF;
411:
412: FND_MSG_PUB.Count_AND_Get
413: ( p_count => x_msg_count,
414: p_data => x_msg_data,
415: p_encoded => FND_API.G_FALSE
416: );

Line 512: FND_MSG_PUB.initialize;

508: --
509: -- Initialize message list IF p_init_msg_list is set to TRUE.
510: --
511: IF FND_API.to_Boolean( p_init_msg_list ) THEN
512: FND_MSG_PUB.initialize;
513: END IF;
514:
515: --
516: -- Standard call to check for call compatibility.

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

650:
651: OPEN c_trig_actions_det(p_trig_rec.trigger_id);
652: FETCH c_trig_actions_det INTO l_notify_flag, l_execute_schedule_flag;
653: IF (c_trig_actions_det%NOTFOUND) THEN
654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
655: THEN -- MMSG
656: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
657: FND_MSG_PUB.Add;
658: END IF;

Line 657: FND_MSG_PUB.Add;

653: IF (c_trig_actions_det%NOTFOUND) THEN
654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
655: THEN -- MMSG
656: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
657: FND_MSG_PUB.Add;
658: END IF;
659: RAISE FND_API.G_EXC_ERROR;
660: END IF;
661: CLOSE c_trig_actions_det;

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

677:
678: OPEN c_actions_det(p_trig_rec.trigger_id, 'NOTIFY');
679: FETCH c_actions_det INTO l_trig_action_id, l_object_version_number;
680: IF (c_actions_det%NOTFOUND) THEN
681: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
682: THEN -- MMSG
683: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
684: FND_MSG_PUB.Add;
685: END IF;

Line 684: FND_MSG_PUB.Add;

680: IF (c_actions_det%NOTFOUND) THEN
681: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
682: THEN -- MMSG
683: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
684: FND_MSG_PUB.Add;
685: END IF;
686: RAISE FND_API.G_EXC_ERROR;
687: END IF;
688: CLOSE c_actions_det;

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

747: AMS_Utility_PVT.debug_message(l_full_name ||': Case 3');
748: OPEN c_actions_det(p_trig_rec.trigger_id, 'NOTIFY');
749: FETCH c_actions_det INTO l_trig_action_id, l_object_version_number;
750: IF (c_actions_det%NOTFOUND) THEN
751: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
752: THEN -- MMSG
753: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
754: FND_MSG_PUB.Add;
755: END IF;

Line 754: FND_MSG_PUB.Add;

750: IF (c_actions_det%NOTFOUND) THEN
751: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
752: THEN -- MMSG
753: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
754: FND_MSG_PUB.Add;
755: END IF;
756: RAISE FND_API.G_EXC_ERROR;
757: END IF;
758: CLOSE c_actions_det;

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

789: /*
790: OPEN c_actions_det(p_trig_rec.trigger_id, 'EXECUTE');
791: FETCH c_actions_det INTO l_trig_action_id, l_object_version_number;
792: IF (c_actions_det%NOTFOUND) THEN
793: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
794: THEN -- MMSG
795: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
796: FND_MSG_PUB.Add;
797: END IF;

Line 796: FND_MSG_PUB.Add;

792: IF (c_actions_det%NOTFOUND) THEN
793: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
794: THEN -- MMSG
795: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
796: FND_MSG_PUB.Add;
797: END IF;
798: RAISE FND_API.G_EXC_ERROR;
799: END IF;
800: CLOSE c_actions_det;

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

860: AMS_Utility_PVT.debug_message(l_full_name ||': Case 6');
861: OPEN c_actions_det(p_trig_rec.trigger_id, 'EXECUTE');
862: FETCH c_actions_det INTO l_trig_action_id, l_object_version_number;
863: IF (c_actions_det%NOTFOUND) THEN
864: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
865: THEN -- MMSG
866: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
867: FND_MSG_PUB.Add;
868: END IF;

Line 867: FND_MSG_PUB.Add;

863: IF (c_actions_det%NOTFOUND) THEN
864: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
865: THEN -- MMSG
866: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
867: FND_MSG_PUB.Add;
868: END IF;
869: RAISE FND_API.G_EXC_ERROR;
870: END IF;
871: CLOSE c_actions_det;

Line 951: FND_MSG_PUB.count_and_get(

947:
948: --
949: -- Get message count AND IF count is 1, get message info.
950: --
951: FND_MSG_PUB.count_and_get(
952: p_encoded => FND_API.g_false,
953: p_count => x_msg_count,
954: p_data => x_msg_data
955: );

Line 966: FND_MSG_PUB.Count_AND_Get

962: EXCEPTION
963: WHEN FND_API.G_EXC_ERROR THEN
964: ROLLBACK TO Update_Trig_PVT;
965: x_return_status := FND_API.G_RET_STS_ERROR ;
966: FND_MSG_PUB.Count_AND_Get
967: (p_count => x_msg_count,
968: p_data => x_msg_data,
969: p_encoded => FND_API.G_FALSE
970: );

Line 975: FND_MSG_PUB.Count_AND_Get

971:
972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
973: ROLLBACK TO Update_Trig_PVT;
974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
975: FND_MSG_PUB.Count_AND_Get
976: (p_count => x_msg_count,
977: p_data => x_msg_data,
978: p_encoded => FND_API.G_FALSE
979: );

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

980:
981: WHEN OTHERS THEN
982: ROLLBACK TO Update_Trig_PVT;
983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
984: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
985: THEN
986: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
987: END IF;
988: FND_MSG_PUB.Count_AND_Get

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

982: ROLLBACK TO Update_Trig_PVT;
983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
984: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
985: THEN
986: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
987: END IF;
988: FND_MSG_PUB.Count_AND_Get
989: (p_count => x_msg_count,
990: p_data => x_msg_data,

Line 988: FND_MSG_PUB.Count_AND_Get

984: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
985: THEN
986: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
987: END IF;
988: FND_MSG_PUB.Count_AND_Get
989: (p_count => x_msg_count,
990: p_data => x_msg_data,
991: p_encoded => FND_API.G_FALSE
992: );

Line 1054: FND_MSG_PUB.initialize;

1050: AMS_Utility_PVT.debug_message(l_full_name||': start');
1051: END IF;
1052:
1053: IF FND_API.to_boolean(p_init_msg_list) THEN
1054: FND_MSG_PUB.initialize;
1055: END IF;
1056:
1057: -- Standard call to check for call compatibility.
1058: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 1147: FND_MSG_PUB.Count_AND_Get

1143: COMMIT WORK;
1144: END IF;
1145:
1146: -- Standard call to get message count AND IF count is 1, get message info.
1147: FND_MSG_PUB.Count_AND_Get
1148: ( p_count => x_msg_count,
1149: p_data => x_msg_data,
1150: p_encoded => FND_API.G_FALSE
1151: );

Line 1161: FND_MSG_PUB.Count_AND_Get

1157: EXCEPTION
1158: WHEN FND_API.G_EXC_ERROR THEN
1159: ROLLBACK TO Activate_Trig_PVT;
1160: x_return_status := FND_API.G_RET_STS_ERROR ;
1161: FND_MSG_PUB.Count_AND_Get
1162: ( p_count => x_msg_count,
1163: p_data => x_msg_data,
1164: p_encoded => FND_API.G_FALSE
1165: );

Line 1170: FND_MSG_PUB.Count_AND_Get

1166:
1167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1168: ROLLBACK TO Activate_Trig_PVT;
1169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1170: FND_MSG_PUB.Count_AND_Get
1171: ( p_count => x_msg_count,
1172: p_data => x_msg_data,
1173: p_encoded => FND_API.G_FALSE
1174: );

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

1175:
1176: WHEN OTHERS THEN
1177: ROLLBACK TO Activate_Trig_PVT;
1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1179: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1180: THEN
1181: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1182: END IF;
1183:

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

1177: ROLLBACK TO Activate_Trig_PVT;
1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1179: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1180: THEN
1181: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1182: END IF;
1183:
1184: FND_MSG_PUB.Count_AND_Get
1185: ( p_count => x_msg_count,

Line 1184: FND_MSG_PUB.Count_AND_Get

1180: THEN
1181: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1182: END IF;
1183:
1184: FND_MSG_PUB.Count_AND_Get
1185: ( p_count => x_msg_count,
1186: p_data => x_msg_data,
1187: p_encoded => FND_API.G_FALSE
1188: );