DBA Data[Home] [Help]

APPS.WSH_MDC_SRS dependencies on FND_API

Line 256: raise FND_API.G_EXC_ERROR;

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;
258:
259: IF l_debug_on THEN
260: WSH_DEBUG_SV.push(l_module_name);

Line 267: l_commit := FND_API.G_FALSE;

263: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
264: END IF;
265:
266:
267: l_commit := FND_API.G_FALSE;
268: l_completion_status := 'NORMAL';
269:
270: -- get delivery selection parameters for the batch
271: IF l_debug_on THEN

Line 295: raise FND_API.G_EXC_ERROR;

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');
294: END IF;
295: raise FND_API.G_EXC_ERROR;
296: END IF;
297:
298:
299: -- check if the organization is TPW org

Line 323: raise FND_API.G_EXC_ERROR;

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');
322: END IF;
323: raise FND_API.G_EXC_ERROR;
324: END IF;
325:
326: IF l_debug_on THEN
327: WSH_DEBUG_SV.logmsg(l_module_name, 'Organization type '||l_org_type);

Line 373: raise FND_API.G_EXC_ERROR;

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)
375: THEN
376: WSH_UTIL_CORE.PrintMsg('No deliveries to consolidate');
377: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');

Line 380: raise FND_API.G_EXC_ERROR;

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;
382:
383: IF l_delivery_tab.COUNT = 0
384: THEN

Line 632: raise FND_API.G_EXC_ERROR;

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;
633: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
634: THEN
635: IF l_debug_on THEN
636: WSH_DEBUG_SV.logmsg(l_module_name, 'validate constraints call successful with following warnings');

Line 711: raise FND_API.G_EXC_ERROR;

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;
713:
714:
715: -- set the intermediate location for the deliveries

Line 748: raise FND_API.G_EXC_ERROR;

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;
750:
751: IF l_delivery_tab.COUNT = 0
752: THEN

Line 805: raise FND_API.G_EXC_ERROR;

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;
807:
808:
809: l_delivery_addnl_attr_tab(i).hash_string := l_hash_string;

Line 898: raise FND_API.G_EXC_ERROR;

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;
900:
901:
902: -- create deconsolidation trips

Line 1115: WHEN FND_API.G_EXC_ERROR

1111: WSH_DEBUG_SV.pop(l_module_name);
1112: END IF;
1113:
1114: EXCEPTION
1115: WHEN FND_API.G_EXC_ERROR
1116: THEN
1117: ROLLBACK;
1118: WSH_UTIL_CORE.PrintMsg('SQLCODE: '||sqlcode||' SQLERRM: '||sqlerrm);
1119: WSH_UTIL_CORE.PrintMsg('Exception occurred in SCHEDULE_BATCH');

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

1124: END IF;
1125: retcode := '2';
1126:
1127: IF l_debug_on THEN
1128: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1129: END IF;
1130:
1131: WHEN l_exc_complete
1132: THEN

Line 1804: raise FND_API.G_EXC_ERROR;

1800: END LOOP;
1801:
1802: fnd_msg_pub.delete_msg();
1803:
1804: raise FND_API.G_EXC_ERROR;
1805: END IF;
1806:
1807:
1808: l_failed_index := x_failed_records.LAST;

Line 1886: WHEN FND_API.G_EXC_ERROR

1882: IF l_debug_on THEN
1883: WSH_DEBUG_SV.pop(l_module_name);
1884: END IF;
1885: EXCEPTION
1886: WHEN FND_API.G_EXC_ERROR
1887: THEN
1888: IF l_debug_on THEN
1889: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1890: END IF;

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

1885: EXCEPTION
1886: WHEN FND_API.G_EXC_ERROR
1887: THEN
1888: IF l_debug_on THEN
1889: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1890: END IF;
1891: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1892:
1893: WHEN OTHERS

Line 2285: l_commit := FND_API.g_false;

2281: WSH_DEBUG_SV.log(l_module_name,'trip name prefix',p_trip_name_prefix);
2282: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2283: END IF;
2284:
2285: l_commit := FND_API.g_false;
2286: IF (p_max_trip_weight IS NOT NULL AND p_max_weight_uom IS NOT NULL)
2287: THEN
2288: l_trip_weight_flag := TRUE;
2289: END IF;

Line 2386: raise FND_API.G_EXC_ERROR;

2382: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2383: THEN
2384: WSH_UTIL_CORE.PrintMsg('Could not add delivery for consolidation');
2385: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2386: raise FND_API.G_EXC_ERROR;
2387: END IF;
2388:
2389: x_delivery_addnl_attr_tab(l_d_id).consol_index := l_consol_index + l_consol_count;
2390:

Line 2424: raise FND_API.G_EXC_ERROR;

2420: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2421: THEN
2422: WSH_UTIL_CORE.PrintMsg('Could not add delivery for consolidation');
2423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2424: raise FND_API.G_EXC_ERROR;
2425: END IF;
2426:
2427: x_delivery_addnl_attr_tab(l_d_id).consol_index := l_consol_index + l_consol_count;
2428:

Line 2483: raise FND_API.G_EXC_ERROR;

2479: END LOOP;
2480:
2481: fnd_msg_pub.delete_msg();
2482: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2483: raise FND_API.G_EXC_ERROR;
2484: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
2485: THEN
2486: IF l_debug_on THEN
2487: WSH_DEBUG_SV.logmsg(l_module_name, 'Created consolidations with following warnings');

Line 2525: WHEN FND_API.G_EXC_ERROR

2521: IF l_debug_on THEN
2522: WSH_DEBUG_SV.pop(l_module_name);
2523: END IF;
2524: EXCEPTION
2525: WHEN FND_API.G_EXC_ERROR
2526: THEN
2527: WSH_UTIL_CORE.PrintMsg('Exception occurred in Create_Consolidation');
2528: IF l_debug_on THEN
2529: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

2525: WHEN FND_API.G_EXC_ERROR
2526: THEN
2527: WSH_UTIL_CORE.PrintMsg('Exception occurred in Create_Consolidation');
2528: IF l_debug_on THEN
2529: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2530: END IF;
2531: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2532: WHEN OTHERS
2533: THEN

Line 2662: l_commit := FND_API.g_false;

2658: l_trip_in_rec.action_code := 'CREATE';
2659:
2660: l_trip_info_tab.DELETE;
2661:
2662: l_commit := FND_API.g_false;
2663: IF l_debug_on THEN
2664: WSH_DEBUG_SV.logmsg(l_module_name,'Creating deconsol trip');
2665: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
2666: END IF;

Line 2698: raise FND_API.G_EXC_ERROR;

2694: WSH_DEBUG_SV.logmsg(l_module_name,l_message);
2695: END LOOP;
2696: END IF;
2697: fnd_msg_pub.delete_msg();
2698: raise FND_API.G_EXC_ERROR;
2699:
2700: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
2701: THEN
2702: IF l_debug_on THEN

Line 2766: raise FND_API.G_EXC_ERROR;

2762: WSH_DEBUG_SV.logmsg(l_module_name,l_message);
2763: END LOOP;
2764: END IF;
2765: fnd_msg_pub.delete_msg();
2766: raise FND_API.G_EXC_ERROR;
2767:
2768: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
2769: THEN
2770: IF l_debug_on THEN

Line 2834: raise FND_API.G_EXC_ERROR;

2830: WSH_DEBUG_SV.logmsg(l_module_name,l_message);
2831: END LOOP;
2832: END IF;
2833: fnd_msg_pub.delete_msg();
2834: raise FND_API.G_EXC_ERROR;
2835:
2836: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
2837: THEN
2838: IF l_debug_on THEN

Line 2898: raise FND_API.G_EXC_ERROR;

2894: WSH_DEBUG_SV.logmsg(l_module_name,l_message);
2895: END LOOP;
2896: END IF;
2897: fnd_msg_pub.delete_msg();
2898: raise FND_API.G_EXC_ERROR;
2899:
2900: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
2901: THEN
2902: IF l_debug_on THEN

Line 2956: raise FND_API.G_EXC_ERROR;

2952: WSH_DEBUG_SV.logmsg(l_module_name,l_message);
2953: END LOOP;
2954: END IF;
2955: fnd_msg_pub.delete_msg();
2956: raise FND_API.G_EXC_ERROR;
2957:
2958: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
2959: THEN
2960: IF l_debug_on THEN

Line 3047: raise FND_API.G_EXC_ERROR;

3043: WSH_DEBUG_SV.logmsg(l_module_name,l_message);
3044: END LOOP;
3045: END IF;
3046: fnd_msg_pub.delete_msg();
3047: raise FND_API.G_EXC_ERROR;
3048:
3049: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
3050: THEN
3051: IF l_debug_on THEN

Line 3069: WHEN FND_API.G_EXC_ERROR

3065:
3066: i := x_delivery_tab.NEXT(i);
3067:
3068: EXCEPTION
3069: WHEN FND_API.G_EXC_ERROR
3070: THEN
3071: ROLLBACK TO CREATE_TRIP;
3072: WSH_UTIL_CORE.PrintMsg('Exception occurred while creating deconsol trip for delivery '||l_del_id);
3073: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3101: WHEN FND_API.G_EXC_ERROR

3097: WSH_DEBUG_SV.pop(l_module_name);
3098: END IF;
3099:
3100: EXCEPTION
3101: WHEN FND_API.G_EXC_ERROR
3102: THEN
3103: WSH_UTIL_CORE.PrintMsg('Exception occurred in Create_Deconsol_Trip');
3104: IF l_debug_on THEN
3105: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

3101: WHEN FND_API.G_EXC_ERROR
3102: THEN
3103: WSH_UTIL_CORE.PrintMsg('Exception occurred in Create_Deconsol_Trip');
3104: IF l_debug_on THEN
3105: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3106: END IF;
3107: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3108: WHEN OTHERS
3109: THEN