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.WSH_CAL_ASG_PKG dependencies on FND_API

Line 13: -- p_init_msg_list FND_API.G_TRUE to reset list

9:
10: --========================================================================
11: -- PROCEDURE : Create_Cal_Asg PUBLIC
12: -- PARAMETERS: p_api_version_number known api versionerror buffer
13: -- p_init_msg_list FND_API.G_TRUE to reset list
14: -- x_return_status return status
15: -- x_msg_count number of messages in the list
16: -- x_msg_data text of messages
17: -- VERSION : current version 1.0

Line 23: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

19: -- COMMENT : Sets up a transportation calendar
20: --========================================================================
21: PROCEDURE Create_Cal_Asg
22: ( p_api_version_number IN NUMBER
23: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
24: , p_cal_asg_info IN CalAsgRecType DEFAULT NULL
25: , x_return_status OUT NOCOPY VARCHAR2
26: , x_msg_count OUT NOCOPY NUMBER
27: , x_msg_data OUT NOCOPY VARCHAR2

Line 80: IF NOT FND_API.Compatible_API_Call

76: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CARRIER_ID',p_cal_asg_info.VENDOR_ID);
77: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CARRIER_SITE_ID',p_cal_asg_info.VENDOR_SITE_ID);
78: END IF;
79: --
80: IF NOT FND_API.Compatible_API_Call
81: ( l_api_version_number
82: , p_api_version_number
83: , l_api_name
84: , G_PKG_NAME

Line 87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

83: , l_api_name
84: , G_PKG_NAME
85: )
86: THEN
87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: END IF;
89:
90: -- Initialize message stack if required
91: IF FND_API.to_Boolean(p_init_msg_list)

Line 91: IF FND_API.to_Boolean(p_init_msg_list)

87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: END IF;
89:
90: -- Initialize message stack if required
91: IF FND_API.to_Boolean(p_init_msg_list)
92: THEN
93: FND_MSG_PUB.initialize;
94: END IF;
95:

Line 183: x_return_status := FND_API.G_RET_STS_SUCCESS;

179:
180: --
181: -- report success
182: -- commenting out as this value is set in above procedure
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184: FND_MSG_PUB.Count_And_Get
185: ( p_count => x_msg_count
186: , p_data => x_msg_data
187: );

Line 197: WHEN FND_API.G_EXC_ERROR THEN

193: END IF;
194: --
195: EXCEPTION
196:
197: WHEN FND_API.G_EXC_ERROR THEN
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: -- Get message count and data
200: FND_MSG_PUB.Count_And_Get
201: ( p_count => x_msg_count

Line 198: x_return_status := FND_API.G_RET_STS_ERROR;

194: --
195: EXCEPTION
196:
197: WHEN FND_API.G_EXC_ERROR THEN
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: -- Get message count and data
200: FND_MSG_PUB.Count_And_Get
201: ( p_count => x_msg_count
202: , p_data => x_msg_data

Line 209: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

205: --
206: -- Debug Statements
207: --
208: IF l_debug_on THEN
209: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
210: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
211: END IF;
212: --
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 210: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

206: -- Debug Statements
207: --
208: IF l_debug_on THEN
209: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
210: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
211: END IF;
212: --
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

209: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
210: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
211: END IF;
212: --
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
215: -- Get message count and data
216: FND_MSG_PUB.Count_And_Get
217: ( p_count => x_msg_count

Line 214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

210: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
211: END IF;
212: --
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
215: -- Get message count and data
216: FND_MSG_PUB.Count_And_Get
217: ( p_count => x_msg_count
218: , p_data => x_msg_data

Line 225: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

221: --
222: -- Debug Statements
223: --
224: IF l_debug_on THEN
225: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
226: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
227: END IF;
228: --
229: WHEN OTHERS THEN

Line 226: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

222: -- Debug Statements
223: --
224: IF l_debug_on THEN
225: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
226: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
227: END IF;
228: --
229: WHEN OTHERS THEN
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

226: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
227: END IF;
228: --
229: WHEN OTHERS THEN
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
231: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
232: THEN
233: FND_MSG_PUB.Add_Exc_Msg
234: ( G_PKG_NAME

Line 255: -- p_init_msg_list FND_API.G_TRUE to reset list

251: END Create_Cal_Asg;
252: --========================================================================
253: -- PROCEDURE : Update_Cal_Asg PUBLIC
254: -- PARAMETERS: p_api_version_number known api versionerror buffer
255: -- p_init_msg_list FND_API.G_TRUE to reset list
256: -- x_return_status return status
257: -- x_msg_count number of messages in the list
258: -- x_msg_data text of messages
259: -- p_calendar_assignment_id Primary Key

Line 268: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

264: -- COMMENT : Updates the calendar code for an association
265: --========================================================================
266: PROCEDURE Update_Cal_Asg
267: ( p_api_version_number IN NUMBER
268: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
269: , p_calendar_asgmt_id IN NUMBER
270: , p_cal_asg_info IN CalAsgRecType DEFAULT NULL
271: , x_return_status OUT NOCOPY VARCHAR2
272: , x_msg_count OUT NOCOPY NUMBER

Line 306: IF NOT FND_API.Compatible_API_Call

302: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.CALENDAR_CODE',p_cal_asg_info.CALENDAR_CODE);
303: WSH_DEBUG_SV.log(l_module_name,'p_cal_asg_info.ENABLED_FLAG',p_cal_asg_info.ENABLED_FLAG);
304: END IF;
305: --
306: IF NOT FND_API.Compatible_API_Call
307: ( l_api_version_number
308: , p_api_version_number
309: , l_api_name
310: , G_PKG_NAME

Line 313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

309: , l_api_name
310: , G_PKG_NAME
311: )
312: THEN
313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
314: END IF;
315: -- Initialize message stack if required
316: IF FND_API.to_Boolean(p_init_msg_list)
317: THEN

Line 316: IF FND_API.to_Boolean(p_init_msg_list)

312: THEN
313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
314: END IF;
315: -- Initialize message stack if required
316: IF FND_API.to_Boolean(p_init_msg_list)
317: THEN
318: FND_MSG_PUB.initialize;
319: END IF;
320:

Line 346: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

342: , LAST_UPDATED_BY = FND_GLOBAL.user_id
343: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
344: WHERE CALENDAR_ASSIGNMENT_ID = p_calendar_asgmt_id;
345:
346: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: END IF;
349:
350: --

Line 347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

343: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
344: WHERE CALENDAR_ASSIGNMENT_ID = p_calendar_asgmt_id;
345:
346: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: END IF;
349:
350: --
351: -- report success

Line 352: x_return_status := FND_API.G_RET_STS_SUCCESS;

348: END IF;
349:
350: --
351: -- report success
352: x_return_status := FND_API.G_RET_STS_SUCCESS;
353: FND_MSG_PUB.Count_And_Get
354: ( p_count => x_msg_count
355: , p_data => x_msg_data
356: );

Line 365: WHEN FND_API.G_EXC_ERROR THEN

361: WSH_DEBUG_SV.pop(l_module_name);
362: END IF;
363: --
364: EXCEPTION
365: WHEN FND_API.G_EXC_ERROR THEN
366: x_return_status := FND_API.G_RET_STS_ERROR;
367: -- Get message count and data
368: FND_MSG_PUB.Count_And_Get
369: ( p_count => x_msg_count

Line 366: x_return_status := FND_API.G_RET_STS_ERROR;

362: END IF;
363: --
364: EXCEPTION
365: WHEN FND_API.G_EXC_ERROR THEN
366: x_return_status := FND_API.G_RET_STS_ERROR;
367: -- Get message count and data
368: FND_MSG_PUB.Count_And_Get
369: ( p_count => x_msg_count
370: , p_data => x_msg_data

Line 376: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

372: --
373: -- Debug Statements
374: --
375: IF l_debug_on THEN
376: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
377: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
378: END IF;
379: --
380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 377: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

373: -- Debug Statements
374: --
375: IF l_debug_on THEN
376: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
377: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
378: END IF;
379: --
380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

376: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
377: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
378: END IF;
379: --
380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
382: -- Get message count and data
383: FND_MSG_PUB.Count_And_Get
384: ( p_count => x_msg_count

Line 381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

377: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
378: END IF;
379: --
380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
382: -- Get message count and data
383: FND_MSG_PUB.Count_And_Get
384: ( p_count => x_msg_count
385: , p_data => x_msg_data

Line 392: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

388: --
389: -- Debug Statements
390: --
391: IF l_debug_on THEN
392: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
394: END IF;
395: --
396: WHEN OTHERS THEN

Line 393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

389: -- Debug Statements
390: --
391: IF l_debug_on THEN
392: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
394: END IF;
395: --
396: WHEN OTHERS THEN
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
394: END IF;
395: --
396: WHEN OTHERS THEN
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
398: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
399: THEN
400: FND_MSG_PUB.Add_Exc_Msg
401: ( G_PKG_NAME

Line 566: -- p_init_msg_list FND_API.G_TRUE to reset list

562: END Lock_Cal_Asg;
563: --========================================================================
564: -- PROCEDURE : Delete_Cal_Asg PUBLIC
565: -- PARAMETERS: p_api_version_number known api versionerror buffer
566: -- p_init_msg_list FND_API.G_TRUE to reset list
567: -- x_return_status return status
568: -- x_msg_count number of messages in the list
569: -- x_msg_data text of messages
570: -- p_rowid Row ID to lock

Line 582: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

578: -- - p_calendar_assignment_id
579: --========================================================================
580: PROCEDURE Delete_Cal_Asg
581: ( p_api_version_number IN NUMBER
582: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
583: , x_return_status OUT NOCOPY VARCHAR2
584: , x_msg_count OUT NOCOPY NUMBER
585: , x_msg_data OUT NOCOPY VARCHAR2
586: , p_calendar_assignment_id IN NUMBER