DBA Data[Home] [Help]

APPS.WSH_MDC_SRS dependencies on FND_CONCURRENT

Line 253: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');

249: IF p_batch_id IS NULL
250: THEN
251: WSH_UTIL_CORE.PrintMsg('Batch Id is null');
252: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_MDC_SRS.Schedule_Batch');
253: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
254: errbuf := 'Error occurred in WSH_MDC_SRS.Schedule_Batch';
255: retcode := '2';
256: raise FND_API.G_EXC_ERROR;
257: END IF;

Line 289: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');

285: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
286: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
287: THEN
288: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_MDC_SRS.Get_Batch_Parameters');
289: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
290: errbuf := 'Error occurred in WSH_MDC_SRS.Get_Batch_Parameters';
291: retcode := '2';
292: IF l_debug_on THEN
293: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in WSH_MDC_SRS.Get_Batch_Parameters');

Line 317: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','WSH_EXTERNAL_INTERFACE.SV.Get_Warehouse_type');

313: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
314: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
315: THEN
316: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_EXTERNAL_INTERFACE.SV.Get_Warehouse_type');
317: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','WSH_EXTERNAL_INTERFACE.SV.Get_Warehouse_type');
318: errbuf := 'Error occurred in WSH_EXTERNAL_INTERFACE.SV.Get_Warehouse_type';
319: retcode := '2';
320: IF l_debug_on THEN
321: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in WSH_EXTERNAL_INTERFACE.SV.Get_Warehouse_type');

Line 370: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');

366: END IF;
367: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
368: THEN
369: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_MDC_SRS.Get_Deliveries');
370: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
371: errbuf := 'Error occurred in WSH_MDC_SRS.Get_Deliveries';
372: retcode := '2';
373: raise FND_API.G_EXC_ERROR;
374: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

Line 377: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');

373: raise FND_API.G_EXC_ERROR;
374: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
375: THEN
376: WSH_UTIL_CORE.PrintMsg('No deliveries to consolidate');
377: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
378: errbuf := 'Error occurred in WSH_MDC_SRS.Get_Deliveries';
379: retcode := '2';
380: raise FND_API.G_EXC_ERROR;
381: END IF;

Line 628: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');

624: END IF;
625: END LOOP;
626:
627: fnd_msg_pub.delete_msg();
628: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
629: errbuf := 'Error occurred in WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy';
630: retcode := '2';
631:
632: raise FND_API.G_EXC_ERROR;

Line 708: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');

704: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
705: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
706: THEN
707: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_MDC_SRS.Get_Grouping_Attrs');
708: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
709: errbuf := 'Error occurred in WSH_MDC_SRS.Get_Grouping_Attrs';
710: retcode := '2';
711: raise FND_API.G_EXC_ERROR;
712: END IF;

Line 745: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');

741: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
742: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
743: THEN
744: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_MDC_SRS.Set_Intermediate_Location');
745: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
746: errbuf := 'Error occurred in WSH_MDC_SRS.Set_Intermediate_Location';
747: retcode := '2';
748: raise FND_API.G_EXC_ERROR;
749: END IF;

Line 802: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');

798: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
799: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
800: THEN
801: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_MDC_SRS.Get_Hash_Value');
802: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
803: errbuf := 'Error occurred in WSH_MDC_SRS.Get_Hash_Value';
804: retcode := '2';
805: raise FND_API.G_EXC_ERROR;
806: END IF;

Line 895: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');

891: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
892: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
893: THEN
894: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_MDC_SRS.Create_Consolidations');
895: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
896: errbuf := 'Error occurred in WSH_MDC_SRS.Create_Consolidations';
897: retcode := '2';
898: raise FND_API.G_EXC_ERROR;
899: END IF;

Line 1120: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');

1116: THEN
1117: ROLLBACK;
1118: WSH_UTIL_CORE.PrintMsg('SQLCODE: '||sqlcode||' SQLERRM: '||sqlerrm);
1119: WSH_UTIL_CORE.PrintMsg('Exception occurred in SCHEDULE_BATCH');
1120: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
1121: IF errbuf IS NULL
1122: THEN
1123: errbuf := 'Exception occurred in SCHEDULE_BATCH';
1124: END IF;

Line 1150: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');

1146: ROLLBACK;
1147: WSH_UTIL_CORE.PrintMsg('SQLCODE: '||sqlcode||' SQLERRM: '||sqlerrm);
1148: WSH_UTIL_CORE.PrintMsg('Exception occurred in SCHEDULE_BATCH');
1149:
1150: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
1151: errbuf := 'Exception occurred in SCHEDULE_BATCH';
1152: retcode := '2';
1153:
1154: