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 422: IF NOT FND_API.Compatible_API_Call

418: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_THRESHOLD',P_PRIMARY_THRESHOLD);
419: WSH_DEBUG_SV.log(l_module_name,'P_SECONDARY_THRESHOLD',P_SECONDARY_THRESHOLD);
420: END IF;
421: --
422: IF NOT FND_API.Compatible_API_Call
423: ( l_api_version_number
424: , p_api_version_number
425: , l_api_name
426: , G_PKG_NAME

Line 429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 433: IF FND_API.to_Boolean(p_init_msg_list)

429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: END IF;
431:
432: -- Initialize message stack if required
433: IF FND_API.to_Boolean(p_init_msg_list)
434: THEN
435: FND_MSG_PUB.initialize;
436: END IF;
437:

Line 441: x_return_status := FND_API.G_RET_STS_SUCCESS;

437:
438: -- BEGIN PROCEDURE LOGIC
439: x_suggest_ship_date := p_ship_date;
440: x_suggest_receive_date := p_receive_date;
441: x_return_status := FND_API.G_RET_STS_SUCCESS;
442:
443: IF p_ship_date IS NULL THEN
444: IF p_receive_date IS NULL THEN
445: -- no dates to validate

Line 985: x_return_status := FND_API.G_RET_STS_SUCCESS;

981: END IF;
982: END IF;
983: -- END PROCEDURE LOGIC
984: -- report success
985: x_return_status := FND_API.G_RET_STS_SUCCESS;
986: FND_MSG_PUB.Count_And_Get
987: ( p_count => x_msg_count
988: , p_data => x_msg_data
989: );

Line 1021: WHEN FND_API.G_EXC_ERROR THEN

1017: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_BAD_PARAMETER exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1018: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_BAD_PARAMETER');
1019: END IF;
1020: --
1021: WHEN FND_API.G_EXC_ERROR THEN
1022: x_return_status := FND_API.G_RET_STS_ERROR;
1023: -- Get message count and data
1024: FND_MSG_PUB.Count_And_Get
1025: ( p_count => x_msg_count

Line 1022: x_return_status := FND_API.G_RET_STS_ERROR;

1018: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_BAD_PARAMETER');
1019: END IF;
1020: --
1021: WHEN FND_API.G_EXC_ERROR THEN
1022: x_return_status := FND_API.G_RET_STS_ERROR;
1023: -- Get message count and data
1024: FND_MSG_PUB.Count_And_Get
1025: ( p_count => x_msg_count
1026: , p_data => x_msg_data

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

1029: --
1030: -- Debug Statements
1031: --
1032: IF l_debug_on THEN
1033: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1034: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1035: END IF;
1036: --
1037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1030: -- Debug Statements
1031: --
1032: IF l_debug_on THEN
1033: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1034: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1035: END IF;
1036: --
1037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1033: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1034: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1035: END IF;
1036: --
1037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1039: -- Get message count and data
1040: FND_MSG_PUB.Count_And_Get
1041: ( p_count => x_msg_count

Line 1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1034: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1035: END IF;
1036: --
1037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1039: -- Get message count and data
1040: FND_MSG_PUB.Count_And_Get
1041: ( p_count => x_msg_count
1042: , p_data => x_msg_data

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

1045: --
1046: -- Debug Statements
1047: --
1048: IF l_debug_on THEN
1049: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1050: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1051: END IF;
1052: --
1053: WHEN OTHERS THEN

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

1046: -- Debug Statements
1047: --
1048: IF l_debug_on THEN
1049: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1050: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1051: END IF;
1052: --
1053: WHEN OTHERS THEN
1054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1050: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1051: END IF;
1052: --
1053: WHEN OTHERS THEN
1054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1055: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1056: THEN
1057: FND_MSG_PUB.Add_Exc_Msg
1058: ( G_PKG_NAME