DBA Data[Home] [Help]

APPS.WSH_CAL_ASG_VALIDATIONS dependencies on FND_API

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

104:
105: --========================================================================
106: -- PROCEDURE : Get_Calendar PUBLIC
107: -- PARAMETERS: p_api_version_number known api versionerror buffer
108: -- p_init_msg_list FND_API.G_TRUE to reset list
109: -- x_return_status return status
110: -- x_msg_count number of messages in the list
111: -- x_msg_data text of messages
112: -- p_entity_type Entity - 'CUSTOMER','ORG','VENDOR'

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

121: --========================================================================
122:
123: PROCEDURE Get_Calendar
124: ( p_api_version_number IN NUMBER
125: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
126: , x_return_status OUT NOCOPY VARCHAR2
127: , x_msg_count OUT NOCOPY NUMBER
128: , x_msg_data OUT NOCOPY VARCHAR2
129: , p_entity_type IN VARCHAR2

Line 186: IF NOT FND_API.Compatible_API_Call

182: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
183: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
184: END IF;
185: --
186: IF NOT FND_API.Compatible_API_Call
187: ( l_api_version_number
188: , p_api_version_number
189: , l_api_name
190: , G_PKG_NAME

Line 193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

189: , l_api_name
190: , G_PKG_NAME
191: )
192: THEN
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195:
196: -- Initialize message stack if required
197: IF FND_API.to_Boolean(p_init_msg_list)

Line 197: IF FND_API.to_Boolean(p_init_msg_list)

193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195:
196: -- Initialize message stack if required
197: IF FND_API.to_Boolean(p_init_msg_list)
198: THEN
199: FND_MSG_PUB.initialize;
200: END IF;
201:

Line 216: x_return_status := FND_API.G_RET_STS_SUCCESS;

212: END IF;
213:
214: -- END PROCEDURE LOGIC
215: -- report success
216: x_return_status := FND_API.G_RET_STS_SUCCESS;
217: FND_MSG_PUB.Count_And_Get
218: ( p_count => x_msg_count
219: , p_data => x_msg_data
220: );

Line 229: WHEN FND_API.G_EXC_ERROR THEN

225: WSH_DEBUG_SV.pop(l_module_name);
226: END IF;
227: --
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: -- Get message count and data
232: FND_MSG_PUB.Count_And_Get
233: ( p_count => x_msg_count

Line 230: x_return_status := FND_API.G_RET_STS_ERROR;

226: END IF;
227: --
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: -- Get message count and data
232: FND_MSG_PUB.Count_And_Get
233: ( p_count => x_msg_count
234: , p_data => x_msg_data

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

237: --
238: -- Debug Statements
239: --
240: IF l_debug_on THEN
241: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
242: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
243: END IF;
244: --
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

238: -- Debug Statements
239: --
240: IF l_debug_on THEN
241: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
242: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
243: END IF;
244: --
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

241: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
242: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
243: END IF;
244: --
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
247: -- Get message count and data
248: FND_MSG_PUB.Count_And_Get
249: ( p_count => x_msg_count

Line 246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

242: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
243: END IF;
244: --
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
247: -- Get message count and data
248: FND_MSG_PUB.Count_And_Get
249: ( p_count => x_msg_count
250: , p_data => x_msg_data

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

253: --
254: -- Debug Statements
255: --
256: IF l_debug_on THEN
257: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
258: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
259: END IF;
260: --
261: WHEN OTHERS THEN

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

254: -- Debug Statements
255: --
256: IF l_debug_on THEN
257: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
258: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
259: END IF;
260: --
261: WHEN OTHERS THEN
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

258: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
259: END IF;
260: --
261: WHEN OTHERS THEN
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
263: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
264: THEN
265: FND_MSG_PUB.Add_Exc_Msg
266: ( G_PKG_NAME

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

284:
285: --========================================================================
286: -- PROCEDURE : Transport_Dates PUBLIC
287: -- PARAMETERS: p_api_version_number known api versionerror buffer
288: -- p_init_msg_list FND_API.G_TRUE to reset list
289: -- x_return_status return status
290: -- x_msg_count number of messages in the list
291: -- x_msg_data text of messages
292: -- p_priority 'SHIP' or 'RECEIVE': which is

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

342: -- a carrier calendar fails, return code 5 is generated
343: --========================================================================
344: PROCEDURE Transport_Dates
345: ( p_api_version_number IN NUMBER
346: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
347: , x_return_status OUT NOCOPY VARCHAR2
348: , x_msg_count OUT NOCOPY NUMBER
349: , x_msg_data OUT NOCOPY VARCHAR2
350: , p_priority IN VARCHAR2

Line 418: IF NOT FND_API.Compatible_API_Call

414: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_THRESHOLD',P_PRIMARY_THRESHOLD);
415: WSH_DEBUG_SV.log(l_module_name,'P_SECONDARY_THRESHOLD',P_SECONDARY_THRESHOLD);
416: END IF;
417: --
418: IF NOT FND_API.Compatible_API_Call
419: ( l_api_version_number
420: , p_api_version_number
421: , l_api_name
422: , G_PKG_NAME

Line 425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

421: , l_api_name
422: , G_PKG_NAME
423: )
424: THEN
425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END IF;
427:
428: -- Initialize message stack if required
429: IF FND_API.to_Boolean(p_init_msg_list)

Line 429: IF FND_API.to_Boolean(p_init_msg_list)

425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END IF;
427:
428: -- Initialize message stack if required
429: IF FND_API.to_Boolean(p_init_msg_list)
430: THEN
431: FND_MSG_PUB.initialize;
432: END IF;
433:

Line 437: x_return_status := FND_API.G_RET_STS_SUCCESS;

433:
434: -- BEGIN PROCEDURE LOGIC
435: x_suggest_ship_date := p_ship_date;
436: x_suggest_receive_date := p_receive_date;
437: x_return_status := FND_API.G_RET_STS_SUCCESS;
438:
439: IF p_ship_date IS NULL THEN
440: IF p_receive_date IS NULL THEN
441: -- no dates to validate

Line 806: x_return_status := FND_API.G_RET_STS_SUCCESS;

802: END IF;
803: END IF;
804: -- END PROCEDURE LOGIC
805: -- report success
806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807: FND_MSG_PUB.Count_And_Get
808: ( p_count => x_msg_count
809: , p_data => x_msg_data
810: );

Line 842: WHEN FND_API.G_EXC_ERROR THEN

838: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_BAD_PARAMETER exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
839: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_BAD_PARAMETER');
840: END IF;
841: --
842: WHEN FND_API.G_EXC_ERROR THEN
843: x_return_status := FND_API.G_RET_STS_ERROR;
844: -- Get message count and data
845: FND_MSG_PUB.Count_And_Get
846: ( p_count => x_msg_count

Line 843: x_return_status := FND_API.G_RET_STS_ERROR;

839: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_BAD_PARAMETER');
840: END IF;
841: --
842: WHEN FND_API.G_EXC_ERROR THEN
843: x_return_status := FND_API.G_RET_STS_ERROR;
844: -- Get message count and data
845: FND_MSG_PUB.Count_And_Get
846: ( p_count => x_msg_count
847: , p_data => x_msg_data

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

850: --
851: -- Debug Statements
852: --
853: IF l_debug_on THEN
854: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
855: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
856: END IF;
857: --
858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

851: -- Debug Statements
852: --
853: IF l_debug_on THEN
854: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
855: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
856: END IF;
857: --
858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

854: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
855: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
856: END IF;
857: --
858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
860: -- Get message count and data
861: FND_MSG_PUB.Count_And_Get
862: ( p_count => x_msg_count

Line 859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

855: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
856: END IF;
857: --
858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
860: -- Get message count and data
861: FND_MSG_PUB.Count_And_Get
862: ( p_count => x_msg_count
863: , p_data => x_msg_data

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

866: --
867: -- Debug Statements
868: --
869: IF l_debug_on THEN
870: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
871: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
872: END IF;
873: --
874: WHEN OTHERS THEN

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

867: -- Debug Statements
868: --
869: IF l_debug_on THEN
870: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
871: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
872: END IF;
873: --
874: WHEN OTHERS THEN
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

871: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
872: END IF;
873: --
874: WHEN OTHERS THEN
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
876: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
877: THEN
878: FND_MSG_PUB.Add_Exc_Msg
879: ( G_PKG_NAME