APPS.WMS_LMS_EXPECTED_RES dependencies on FND_API

Line 66: x_return_status := fnd_api.g_ret_sts_success;

62: ALL_SQL_FAILED Exception;
63: g_total_sql NUMBER;
64:
65: BEGIN
66: x_return_status := fnd_api.g_ret_sts_success;
67: l_num_rows_inserted := 0;
68: l_num_sql_failed :=0;
69: g_total_sql :=11;
70:

Line 162: x_return_status := fnd_api.g_ret_sts_error;

158: WHEN OTHERS THEN
159: IF g_debug=1 THEN
160: debug('Exception in populating rows for inbound(PO,REQ,SHIPMENTS) ','POPULATE_EXPECTED_WORK');
161: END IF;
162: x_return_status := fnd_api.g_ret_sts_error;
163: l_num_sql_failed := l_num_sql_failed+1;
164: END;
165:
166:

Line 250: x_return_status := fnd_api.g_ret_sts_error;

246: IF g_debug=1 THEN
247: debug('Exception in populating rows for inbound(RMA) ','POPULATE_EXPECTED_WORK');
248: END IF;
249:
250: x_return_status := fnd_api.g_ret_sts_error;
251: l_num_sql_failed := l_num_sql_failed + 1;
252:
253: END;
254:

Line 323: x_return_status := fnd_api.g_ret_sts_error;

319: IF g_debug=1 THEN
320: debug('Exception in populating rows for inbound putaway PO','POPULATE_EXPECTED_WORK');
321: END IF;
322:
323: x_return_status := fnd_api.g_ret_sts_error;
324: l_num_sql_failed := l_num_sql_failed + 1;
325:
326: END;
327:

Line 396: x_return_status := fnd_api.g_ret_sts_error;

392: IF g_debug=1 THEN
393: debug('Exception in populating rows for inbound putaway RMA','POPULATE_EXPECTED_WORK');
394: END IF;
395:
396: x_return_status := fnd_api.g_ret_sts_error;
397: l_num_sql_failed := l_num_sql_failed + 1;
398:
399: END;
400:

Line 469: x_return_status := fnd_api.g_ret_sts_error;

465: IF g_debug=1 THEN
466: debug('Exception in populating rows for inbound putaway Intransit Shipment','POPULATE_EXPECTED_WORK');
467: END IF;
468:
469: x_return_status := fnd_api.g_ret_sts_error;
470: l_num_sql_failed := l_num_sql_failed + 1;
471:
472: END;
473:

Line 542: x_return_status := fnd_api.g_ret_sts_error;

538: IF g_debug=1 THEN
539: debug('Exception in populating rows for inbound putaway Intransit Shipment','POPULATE_EXPECTED_WORK');
540: END IF;
541:
542: x_return_status := fnd_api.g_ret_sts_error;
543: l_num_sql_failed := l_num_sql_failed + 1;
544:
545: END;
546:

Line 611: x_return_status := fnd_api.g_ret_sts_error;

607: IF g_debug=1 THEN
608: debug('Exception in populating rows for Manufacturing Putaway DROP','POPULATE_EXPECTED_WORK');
609: END IF;
610:
611: x_return_status := fnd_api.g_ret_sts_error;
612: l_num_sql_failed := l_num_sql_failed + 1;
613:
614: END;
615:

Line 686: x_return_status := fnd_api.g_ret_sts_error;

682: IF g_debug=1 THEN
683: debug('Exception in populating rows for Cycle Counting','POPULATE_EXPECTED_WORK');
684: END IF;
685:
686: x_return_status := fnd_api.g_ret_sts_error;
687: l_num_sql_failed := l_num_sql_failed + 1;
688:
689: END;
690:

Line 926: x_return_status := fnd_api.g_ret_sts_error;

922: IF g_debug=1 THEN
923: debug('Exception in populating rows for LOAD TASKS Outbound/Relenishment tasks(pending,unreleased)','POPULATE_EXPECTED_WORK');
924: END IF;
925:
926: x_return_status := fnd_api.g_ret_sts_error;
927: l_num_sql_failed := l_num_sql_failed + 1;
928:
929: END;
930:

Line 1168: x_return_status := fnd_api.g_ret_sts_error;

1164: IF g_debug=1 THEN
1165: debug('Exception in populating rows for LOAD TASKS Outbound/Relenishment tasks(queued,dispatched)','POPULATE_EXPECTED_WORK');
1166: END IF;
1167:
1168: x_return_status := fnd_api.g_ret_sts_error;
1169: l_num_sql_failed := l_num_sql_failed + 1;
1170:
1171: END;
1172:

Line 1379: x_return_status := fnd_api.g_ret_sts_error;

1375: IF g_debug=1 THEN
1376: debug('Exception in populating rows for DROP TASKS Outbound/Relenishment tasks(pending,unreleased)','POPULATE_EXPECTED_WORK');
1377: END IF;
1378:
1379: x_return_status := fnd_api.g_ret_sts_error;
1380: l_num_sql_failed := l_num_sql_failed + 1;
1381:
1382: END;
1383:

Line 1793: x_return_status := fnd_api.g_ret_sts_error;

1789: IF g_debug=1 THEN
1790: debug('Exception in populating rows for DROP TASKS Outbound/Relenishment tasks(queued,dispatched)','POPULATE_EXPECTED_WORK');
1791: END IF;
1792:
1793: x_return_status := fnd_api.g_ret_sts_error;
1794: l_num_sql_failed := l_num_sql_failed + 1;
1795:
1796: END;
1797:

Line 1890: x_return_status := fnd_api.g_ret_sts_error;

1886: IF g_debug=1 THEN
1887: debug('Exception in populating rows for Inventory Move DROP','POPULATE_EXPECTED_WORK');
1888: END IF;
1889:
1890: x_return_status := fnd_api.g_ret_sts_error;
1891: l_num_sql_failed := l_num_sql_failed + 1;
1892:
1893: END;
1894:

Line 1989: x_return_status := fnd_api.g_ret_sts_error;

1985: IF g_debug=1 THEN
1986: debug('Exception in populating rows for Staging Move DROP','POPULATE_EXPECTED_WORK');
1987: END IF;
1988:
1989: x_return_status := fnd_api.g_ret_sts_error;
1990: l_num_sql_failed := l_num_sql_failed + 1;
1991:
1992: END;
1993:

Line 2009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2005: IF g_debug=1 THEN
2006: debug('All SQLS failed','POPULATE_EXPECTED_WORK');
2007: END IF;
2008:
2009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2010:
2011: WHEN OTHERS THEN
2012:
2013: IF g_debug=1 THEN

Line 2017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2013: IF g_debug=1 THEN
2014: debug('Unexpected error occured','POPULATE_EXPECTED_WORK');
2015: END IF;
2016:
2017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2018:
2019: END POPULATE_EXPECTED_WORK;
2020:
2021:

Line 2178: IF(l_return_status = FND_API.g_ret_sts_error )THEN

2174: IF g_debug=1 THEN
2175: debug('The return status from Populate expected work is '|| l_return_status,'MATCH_RATE_EXP_RESOURCE');
2176: END IF;
2177:
2178: IF(l_return_status = FND_API.g_ret_sts_error )THEN
2179: -- Populate this status do that it can be used later for
2180: -- completeing the program with warning status
2181:
2182: l_populate_status := 1;

Line 2186: IF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )THEN

2182: l_populate_status := 1;
2183:
2184: END IF;
2185:
2186: IF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR )THEN
2187:
2188: --- Dont PROCEED;return error from here itself;
2189: ROLLBACK TO l_exp_work_populate;
2190: retcode := 2;