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

Line 17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

13: )
14: IS
15: --Initialise return status to success.
16:
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18:
19: l_msg_count NUMBER := 0;
20: l_msg_data VARCHAR2(2000) := NULL;
21: l_api_version NUMBER := 1.0 ;

Line 69: l_return_status := FND_API.G_RET_STS_SUCCESS;

65: OPEN c_get_delete_criteria;
66: LOOP
67: FETCH c_get_delete_criteria INTO l_get_criteria_rec;
68: IF (c_get_delete_criteria%NOTFOUND) THEN
69: l_return_status := FND_API.G_RET_STS_SUCCESS;
70: --CLOSE c_get_delete_criteria;
71: l_get_criteria_rec := NULL;
72: EXIT;
73: ELSE

Line 80: , x_remove_only => FND_API.G_TRUE

76: , x_msg_count => l_msg_count
77: , x_msg_data => l_msg_data
78: , x_resource_id => p_resource_id
79: , x_criteria_rec => l_get_criteria_rec
80: , x_remove_only => FND_API.G_TRUE
81: );
82: END IF;
83: END LOOP;
84: CLOSE c_get_delete_criteria;

Line 90: l_return_status := FND_API.G_RET_STS_SUCCESS;

86: OPEN c_get_create_criteria;
87: LOOP
88: FETCH c_get_create_criteria INTO l_get_criteria_rec;
89: IF (c_get_create_criteria%NOTFOUND) THEN
90: l_return_status := FND_API.G_RET_STS_SUCCESS;
91: --CLOSE c_get_create_criteria;
92: l_get_criteria_rec := NULL;
93: EXIT;
94: ELSE

Line 109: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

105:
106: -- Write_log ;
107: Ams_Utility_Pvt.Write_Conc_log ;
108:
109: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
110: retcode :=0;
111: ELSE
112: retcode := 2;
113: errbuf := l_msg_data ;

Line 123: x_init_msg_list IN VARCHAR2 := FND_API.G_False,

119: PROCEDURE Sync_Cal_Items
120: (
121: x_full_mode IN VARCHAR2 := 'N',
122: x_api_version IN NUMBER := 1.0,
123: x_init_msg_list IN VARCHAR2 := FND_API.G_False,
124: x_commit IN VARCHAR2 := FND_API.G_False,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,

Line 124: x_commit IN VARCHAR2 := FND_API.G_False,

120: (
121: x_full_mode IN VARCHAR2 := 'N',
122: x_api_version IN NUMBER := 1.0,
123: x_init_msg_list IN VARCHAR2 := FND_API.G_False,
124: x_commit IN VARCHAR2 := FND_API.G_False,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: x_resource_id IN NUMBER,

Line 130: x_remove_only IN VARCHAR2 := FND_API.G_False

126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: x_resource_id IN NUMBER,
129: x_criteria_rec IN ams_criteria_rec,
130: x_remove_only IN VARCHAR2 := FND_API.G_False
131: )
132: IS
133: l_inc_mode_start_date FND_CONCURRENT_REQUESTS.ACTUAL_START_DATE%type;
134: l_cal_pvt_rec AMS_Sync_Calendar_PVT.cal_criteria_rec;

Line 148: IF FND_API.to_Boolean( x_init_msg_list ) THEN

144:
145: --
146: -- Initialize message list IF x_init_msg_list is set to TRUE.
147: --
148: IF FND_API.to_Boolean( x_init_msg_list ) THEN
149: FND_MSG_PUB.initialize;
150: END IF;
151:
152: --

Line 155: /* IF NOT FND_API.Compatible_API_Call ( 1.0,

151:
152: --
153: -- Standard call to check for call compatibility.
154: --
155: /* IF NOT FND_API.Compatible_API_Call ( 1.0,
156: x_api_version,
157: l_api_name,
158: G_PKG_NAME)
159: THEN

Line 160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

156: x_api_version,
157: l_api_name,
158: G_PKG_NAME)
159: THEN
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
161: END IF;
162: */
163: /* No Longer needed 3568819
164: BEGIN

Line 182: x_return_status := FND_API.G_RET_STS_SUCCESS;

178: */
179: --
180: -- Initialize API return status to success
181: --
182: x_return_status := FND_API.G_RET_STS_SUCCESS;
183:
184: l_cal_pvt_rec.OBJECT_TYPE := x_criteria_rec.OBJECT_TYPE_CODE;
185: l_cal_pvt_rec.RESOURCE_ID := x_resource_id;
186: -- Bug fix #3159119

Line 206: AMS_Sync_Calendar_PVT.Sync_Cal_Items( x_remove_only => FND_API.G_True

202: -- Commented for Bug Fix 3568819
203: /*
204: IF ((l_inc_mode_start_date is not NULL) AND (x_criteria_rec.LAST_UPDATE_DATE >= l_inc_mode_start_date)) THEN
205: IF (x_remove_only = 'Y') THEN
206: AMS_Sync_Calendar_PVT.Sync_Cal_Items( x_remove_only => FND_API.G_True
207: , x_return_status => x_return_status
208: , x_msg_count => x_msg_count
209: , x_msg_data => x_msg_data
210: , x_criteria_rec => l_cal_pvt_rec

Line 226: AMS_Sync_Calendar_PVT.Sync_Cal_Items( x_remove_only => FND_API.G_True

222: (l_inc_mode_start_date is NULL) OR
223: (x_full_mode = 'Y' AND x_criteria_rec.LAST_UPDATE_DATE < l_inc_mode_start_date)
224: ) THEN
225: IF (x_remove_only = 'Y') THEN
226: AMS_Sync_Calendar_PVT.Sync_Cal_Items( x_remove_only => FND_API.G_True
227: , x_return_status => x_return_status
228: , x_msg_count => x_msg_count
229: , x_msg_data => x_msg_data
230: , x_criteria_rec => l_cal_pvt_rec

Line 248: IF (x_remove_only = FND_API.G_TRUE) THEN

244: -- Bug Fix for 3568819. There is no sense in the Full Mode Logic as there is no dates to
245: -- compare in the ams_calendar_criteria. Using last_update_date is not correct. As of today
246: -- it will always be full mode. Also x_remove_only is T or F and not Y/N
247:
248: IF (x_remove_only = FND_API.G_TRUE) THEN
249: AMS_Sync_Calendar_PVT.Sync_Cal_Items( x_remove_only => FND_API.G_True
250: , x_return_status => x_return_status
251: , x_msg_count => x_msg_count
252: , x_msg_data => x_msg_data

Line 249: AMS_Sync_Calendar_PVT.Sync_Cal_Items( x_remove_only => FND_API.G_True

245: -- compare in the ams_calendar_criteria. Using last_update_date is not correct. As of today
246: -- it will always be full mode. Also x_remove_only is T or F and not Y/N
247:
248: IF (x_remove_only = FND_API.G_TRUE) THEN
249: AMS_Sync_Calendar_PVT.Sync_Cal_Items( x_remove_only => FND_API.G_True
250: , x_return_status => x_return_status
251: , x_msg_count => x_msg_count
252: , x_msg_data => x_msg_data
253: , x_criteria_rec => l_cal_pvt_rec

Line 265: WHEN FND_API.G_EXC_ERROR

261: );
262: END IF;
263:
264: EXCEPTION
265: WHEN FND_API.G_EXC_ERROR
266: THEN
267: -- ROLLBACK TO delete_item_pub;
268: x_return_status := FND_API.G_RET_STS_ERROR;
269: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 268: x_return_status := FND_API.G_RET_STS_ERROR;

264: EXCEPTION
265: WHEN FND_API.G_EXC_ERROR
266: THEN
267: -- ROLLBACK TO delete_item_pub;
268: x_return_status := FND_API.G_RET_STS_ERROR;
269: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
270: , p_data => x_msg_data
271: );
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

268: x_return_status := FND_API.G_RET_STS_ERROR;
269: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
270: , p_data => x_msg_data
271: );
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
273: THEN
274: -- ROLLBACK TO delete_item_pub;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

271: );
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
273: THEN
274: -- ROLLBACK TO delete_item_pub;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
277: , p_data => x_msg_data
278: );
279: WHEN OTHERS

Line 282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

278: );
279: WHEN OTHERS
280: THEN
281: -- ROLLBACK TO delete_item_pub;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
284: THEN
285: FND_MSG_PUB.Add_Exc_Msg('AMS_Sync_Calendar_PUB'
286: , 'Sync_Calendar_Items'