eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.WIP_WS_TIME_ENTRY dependencies on FND_API

Line 114: if(x_return_status <> fnd_api.g_ret_sts_success) then

110:
111: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.record_insert',
112: p_params => l_params,
113: x_returnStatus => x_return_status);
114: if(x_return_status <> fnd_api.g_ret_sts_success) then
115: raise fnd_api.g_exc_unexpected_error;
116: end if;
117: end if;
118: l_status_type := 1; --pending

Line 115: raise fnd_api.g_exc_unexpected_error;

111: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.record_insert',
112: p_params => l_params,
113: x_returnStatus => x_return_status);
114: if(x_return_status <> fnd_api.g_ret_sts_success) then
115: raise fnd_api.g_exc_unexpected_error;
116: end if;
117: end if;
118: l_status_type := 1; --pending
119: l_process_status := 2; --inserted

Line 378: if(x_return_status <> fnd_api.g_ret_sts_success) then

374:
375: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.record_update',
376: p_params => l_params,
377: x_returnStatus => x_return_status);
378: if(x_return_status <> fnd_api.g_ret_sts_success) then
379: raise fnd_api.g_exc_unexpected_error;
380: end if;
381: end if;
382: l_object_version_num := p_object_version_num;

Line 379: raise fnd_api.g_exc_unexpected_error;

375: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.record_update',
376: p_params => l_params,
377: x_returnStatus => x_return_status);
378: if(x_return_status <> fnd_api.g_ret_sts_success) then
379: raise fnd_api.g_exc_unexpected_error;
380: end if;
381: end if;
382: l_object_version_num := p_object_version_num;
383: l_start_date := p_start_date;

Line 535: if(x_return_status <> fnd_api.g_ret_sts_success) then

531:
532: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.record_delete',
533: p_params => l_params,
534: x_returnStatus => x_return_status);
535: if(x_return_status <> fnd_api.g_ret_sts_success) then
536: raise fnd_api.g_exc_unexpected_error;
537: end if;
538: end if;
539: l_process_status := 4; --deleted

Line 536: raise fnd_api.g_exc_unexpected_error;

532: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.record_delete',
533: p_params => l_params,
534: x_returnStatus => x_return_status);
535: if(x_return_status <> fnd_api.g_ret_sts_success) then
536: raise fnd_api.g_exc_unexpected_error;
537: end if;
538: end if;
539: l_process_status := 4; --deleted
540: l_return_status := 'U';

Line 640: if(x_return_status <> fnd_api.g_ret_sts_success) then

636:
637: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.record_delete',
638: p_params => l_params,
639: x_returnStatus => x_return_status);
640: if(x_return_status <> fnd_api.g_ret_sts_success) then
641: raise fnd_api.g_exc_unexpected_error;
642: end if;
643: end if;
644: l_process_status := 4; --deleted

Line 641: raise fnd_api.g_exc_unexpected_error;

637: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.record_delete',
638: p_params => l_params,
639: x_returnStatus => x_return_status);
640: if(x_return_status <> fnd_api.g_ret_sts_success) then
641: raise fnd_api.g_exc_unexpected_error;
642: end if;
643: end if;
644: l_process_status := 4; --deleted
645: l_return_status := 'U';

Line 726: if(x_return_status <> fnd_api.g_ret_sts_success) then

722:
723: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.job_off_internal',
724: p_params => l_params,
725: x_returnStatus => x_return_status);
726: if(x_return_status <> fnd_api.g_ret_sts_success) then
727: raise fnd_api.g_exc_unexpected_error;
728: end if;
729: end if;
730: update wip_operations

Line 727: raise fnd_api.g_exc_unexpected_error;

723: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.job_off_internal',
724: p_params => l_params,
725: x_returnStatus => x_return_status);
726: if(x_return_status <> fnd_api.g_ret_sts_success) then
727: raise fnd_api.g_exc_unexpected_error;
728: end if;
729: end if;
730: update wip_operations
731: set employee_id = null

Line 763: if(x_return_status <> fnd_api.g_ret_sts_success) then

759:
760: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.clock_out_labors',
761: p_params => l_params,
762: x_returnStatus => x_return_status);
763: if(x_return_status <> fnd_api.g_ret_sts_success) then
764: raise fnd_api.g_exc_unexpected_error;
765: end if;
766: end if;
767: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');

Line 764: raise fnd_api.g_exc_unexpected_error;

760: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.clock_out_labors',
761: p_params => l_params,
762: x_returnStatus => x_return_status);
763: if(x_return_status <> fnd_api.g_ret_sts_success) then
764: raise fnd_api.g_exc_unexpected_error;
765: end if;
766: end if;
767: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
768: l_date := sysdate;

Line 863: if(x_return_status <> fnd_api.g_ret_sts_success) then

859:
860: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.clock_out_machines',
861: p_params => l_params,
862: x_returnStatus => x_return_status);
863: if(x_return_status <> fnd_api.g_ret_sts_success) then
864: raise fnd_api.g_exc_unexpected_error;
865: end if;
866: end if;
867: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');

Line 864: raise fnd_api.g_exc_unexpected_error;

860: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.clock_out_machines',
861: p_params => l_params,
862: x_returnStatus => x_return_status);
863: if(x_return_status <> fnd_api.g_ret_sts_success) then
864: raise fnd_api.g_exc_unexpected_error;
865: end if;
866: end if;
867: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
868:

Line 1336: if(l_return_status <> fnd_api.g_ret_sts_success) then

1332:
1333: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.process_time_records',
1334: p_params => l_params,
1335: x_returnStatus => l_return_status);
1336: if(l_return_status <> fnd_api.g_ret_sts_success) then
1337: raise fnd_api.g_exc_unexpected_error;
1338: end if;
1339: end if;
1340: l_completed_status_type := 2; --completed

Line 1337: raise fnd_api.g_exc_unexpected_error;

1333: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.process_time_records',
1334: p_params => l_params,
1335: x_returnStatus => l_return_status);
1336: if(l_return_status <> fnd_api.g_ret_sts_success) then
1337: raise fnd_api.g_exc_unexpected_error;
1338: end if;
1339: end if;
1340: l_completed_status_type := 2; --completed
1341: l_completed_process_status := 1; --completed

Line 1665: if(l_return_status <> fnd_api.g_ret_sts_success) then

1661:
1662: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.get_cost_flag',
1663: p_params => l_params,
1664: x_returnStatus => l_return_status);
1665: if(l_return_status <> fnd_api.g_ret_sts_success) then
1666: raise fnd_api.g_exc_unexpected_error;
1667: end if;
1668: end if;
1669: if (p_time_entry_source = 'move') then --time entry source is 'move'

Line 1666: raise fnd_api.g_exc_unexpected_error;

1662: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.get_cost_flag',
1663: p_params => l_params,
1664: x_returnStatus => l_return_status);
1665: if(l_return_status <> fnd_api.g_ret_sts_success) then
1666: raise fnd_api.g_exc_unexpected_error;
1667: end if;
1668: end if;
1669: if (p_time_entry_source = 'move') then --time entry source is 'move'
1670: l_cost_flag := 'Y';

Line 1820: if(l_return_status <> fnd_api.g_ret_sts_success) then

1816:
1817: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.update_actual_start_dates',
1818: p_params => l_params,
1819: x_returnStatus => l_return_status);
1820: if(l_return_status <> fnd_api.g_ret_sts_success) then
1821: raise fnd_api.g_exc_unexpected_error;
1822: end if;
1823: end if;
1824: l_min_start_date := null;

Line 1821: raise fnd_api.g_exc_unexpected_error;

1817: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.update_actual_start_dates',
1818: p_params => l_params,
1819: x_returnStatus => l_return_status);
1820: if(l_return_status <> fnd_api.g_ret_sts_success) then
1821: raise fnd_api.g_exc_unexpected_error;
1822: end if;
1823: end if;
1824: l_min_start_date := null;
1825: open min_start_date_wrat_cursor;

Line 1937: if(l_return_status <> fnd_api.g_ret_sts_success) then

1933:
1934: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.update_actual_completion_dates',
1935: p_params => l_params,
1936: x_returnStatus => l_return_status);
1937: if(l_return_status <> fnd_api.g_ret_sts_success) then
1938: raise fnd_api.g_exc_unexpected_error;
1939: end if;
1940: end if;
1941: open max_end_date_wrat_cursor;

Line 1938: raise fnd_api.g_exc_unexpected_error;

1934: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.update_actual_completion_dates',
1935: p_params => l_params,
1936: x_returnStatus => l_return_status);
1937: if(l_return_status <> fnd_api.g_ret_sts_success) then
1938: raise fnd_api.g_exc_unexpected_error;
1939: end if;
1940: end if;
1941: open max_end_date_wrat_cursor;
1942: fetch max_end_date_wrat_cursor into l_max_end_date;

Line 2008: if(l_return_status <> fnd_api.g_ret_sts_success) then

2004:
2005: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.update_proj_completion_dates',
2006: p_params => l_params,
2007: x_returnStatus => l_return_status);
2008: if(l_return_status <> fnd_api.g_ret_sts_success) then
2009: raise fnd_api.g_exc_unexpected_error;
2010: end if;
2011: end if;
2012: l_projected_completion_date := wip_ws_util.get_projected_completion_date(p_organization_id => p_organization_id,

Line 2009: raise fnd_api.g_exc_unexpected_error;

2005: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.update_proj_completion_dates',
2006: p_params => l_params,
2007: x_returnStatus => l_return_status);
2008: if(l_return_status <> fnd_api.g_ret_sts_success) then
2009: raise fnd_api.g_exc_unexpected_error;
2010: end if;
2011: end if;
2012: l_projected_completion_date := wip_ws_util.get_projected_completion_date(p_organization_id => p_organization_id,
2013: p_wip_entity_id => p_wip_entity_id,

Line 2124: if(l_status <> fnd_api.g_ret_sts_success) then

2120:
2121: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.job_on',
2122: p_params => l_params,
2123: x_returnStatus => l_status);
2124: if(l_status <> fnd_api.g_ret_sts_success) then
2125: raise fnd_api.g_exc_unexpected_error;
2126: end if;
2127: end if;
2128: l_status := 'U';

Line 2125: raise fnd_api.g_exc_unexpected_error;

2121: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.job_on',
2122: p_params => l_params,
2123: x_returnStatus => l_status);
2124: if(l_status <> fnd_api.g_ret_sts_success) then
2125: raise fnd_api.g_exc_unexpected_error;
2126: end if;
2127: end if;
2128: l_status := 'U';
2129: l_job_status := get_job_on_off_status(p_wip_entity_id => p_wip_entity_id,

Line 2178: if(l_status <> fnd_api.g_ret_sts_success) then

2174:
2175: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.job_off',
2176: p_params => l_params,
2177: x_returnStatus => l_status);
2178: if(l_status <> fnd_api.g_ret_sts_success) then
2179: raise fnd_api.g_exc_unexpected_error;
2180: end if;
2181: end if;
2182: l_status := 'U';

Line 2179: raise fnd_api.g_exc_unexpected_error;

2175: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.job_off',
2176: p_params => l_params,
2177: x_returnStatus => l_status);
2178: if(l_status <> fnd_api.g_ret_sts_success) then
2179: raise fnd_api.g_exc_unexpected_error;
2180: end if;
2181: end if;
2182: l_status := 'U';
2183: l_job_status := get_job_on_off_status(p_wip_entity_id => p_wip_entity_id,

Line 2306: if(x_status <> fnd_api.g_ret_sts_success) then

2302:
2303: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.shift_in',
2304: p_params => l_params,
2305: x_returnStatus => x_status);
2306: if(x_status <> fnd_api.g_ret_sts_success) then
2307: raise fnd_api.g_exc_unexpected_error;
2308: end if;
2309: end if;
2310: l_shift_status := 'U';

Line 2307: raise fnd_api.g_exc_unexpected_error;

2303: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.shift_in',
2304: p_params => l_params,
2305: x_returnStatus => x_status);
2306: if(x_status <> fnd_api.g_ret_sts_success) then
2307: raise fnd_api.g_exc_unexpected_error;
2308: end if;
2309: end if;
2310: l_shift_status := 'U';
2311:

Line 2403: if(x_status <> fnd_api.g_ret_sts_success) then

2399:
2400: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.shift_out',
2401: p_params => l_params,
2402: x_returnStatus => x_status);
2403: if(x_status <> fnd_api.g_ret_sts_success) then
2404: raise fnd_api.g_exc_unexpected_error;
2405: end if;
2406: end if;
2407: l_shift_status := 'U';

Line 2404: raise fnd_api.g_exc_unexpected_error;

2400: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.shift_out',
2401: p_params => l_params,
2402: x_returnStatus => x_status);
2403: if(x_status <> fnd_api.g_ret_sts_success) then
2404: raise fnd_api.g_exc_unexpected_error;
2405: end if;
2406: end if;
2407: l_shift_status := 'U';
2408:

Line 2478: if(x_status <> fnd_api.g_ret_sts_success) then

2474:
2475: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.undo_shift_in',
2476: p_params => l_params,
2477: x_returnStatus => x_status);
2478: if(x_status <> fnd_api.g_ret_sts_success) then
2479: raise fnd_api.g_exc_unexpected_error;
2480: end if;
2481: end if;
2482: l_shift_status := 'U';

Line 2479: raise fnd_api.g_exc_unexpected_error;

2475: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.undo_shift_in',
2476: p_params => l_params,
2477: x_returnStatus => x_status);
2478: if(x_status <> fnd_api.g_ret_sts_success) then
2479: raise fnd_api.g_exc_unexpected_error;
2480: end if;
2481: end if;
2482: l_shift_status := 'U';
2483:

Line 2548: if(x_status <> fnd_api.g_ret_sts_success) then

2544:
2545: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.shift_in_UM',
2546: p_params => l_params,
2547: x_returnStatus => x_status);
2548: if(x_status <> fnd_api.g_ret_sts_success) then
2549: raise fnd_api.g_exc_unexpected_error;
2550: end if;
2551: end if;
2552: l_shift_status := 'U';

Line 2549: raise fnd_api.g_exc_unexpected_error;

2545: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.shift_in_UM',
2546: p_params => l_params,
2547: x_returnStatus => x_status);
2548: if(x_status <> fnd_api.g_ret_sts_success) then
2549: raise fnd_api.g_exc_unexpected_error;
2550: end if;
2551: end if;
2552: l_shift_status := 'U';
2553:

Line 2634: if(x_status <> fnd_api.g_ret_sts_success) then

2630:
2631: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.shift_out_UM',
2632: p_params => l_params,
2633: x_returnStatus => x_status);
2634: if(x_status <> fnd_api.g_ret_sts_success) then
2635: raise fnd_api.g_exc_unexpected_error;
2636: end if;
2637: end if;
2638: l_shift_status := 'U';

Line 2635: raise fnd_api.g_exc_unexpected_error;

2631: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.shift_out_UM',
2632: p_params => l_params,
2633: x_returnStatus => x_status);
2634: if(x_status <> fnd_api.g_ret_sts_success) then
2635: raise fnd_api.g_exc_unexpected_error;
2636: end if;
2637: end if;
2638: l_shift_status := 'U';
2639:

Line 2705: if(x_status <> fnd_api.g_ret_sts_success) then

2701:
2702: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.undo_shift_in_UM',
2703: p_params => l_params,
2704: x_returnStatus => x_status);
2705: if(x_status <> fnd_api.g_ret_sts_success) then
2706: raise fnd_api.g_exc_unexpected_error;
2707: end if;
2708: end if;
2709: l_shift_status := 'U';

Line 2706: raise fnd_api.g_exc_unexpected_error;

2702: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.undo_shift_in_UM',
2703: p_params => l_params,
2704: x_returnStatus => x_status);
2705: if(x_status <> fnd_api.g_ret_sts_success) then
2706: raise fnd_api.g_exc_unexpected_error;
2707: end if;
2708: end if;
2709: l_shift_status := 'U';
2710:

Line 2855: if(x_status <> fnd_api.g_ret_sts_success) then

2851:
2852: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.clock_in',
2853: p_params => l_params,
2854: x_returnStatus => x_status);
2855: if(x_status <> fnd_api.g_ret_sts_success) then
2856: raise fnd_api.g_exc_unexpected_error;
2857: end if;
2858: end if;
2859: l_clock_status := 'U';

Line 2856: raise fnd_api.g_exc_unexpected_error;

2852: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.clock_in',
2853: p_params => l_params,
2854: x_returnStatus => x_status);
2855: if(x_status <> fnd_api.g_ret_sts_success) then
2856: raise fnd_api.g_exc_unexpected_error;
2857: end if;
2858: end if;
2859: l_clock_status := 'U';
2860:

Line 3087: if(x_status <> fnd_api.g_ret_sts_success) then

3083:
3084: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.clock_out',
3085: p_params => l_params,
3086: x_returnStatus => x_status);
3087: if(x_status <> fnd_api.g_ret_sts_success) then
3088: raise fnd_api.g_exc_unexpected_error;
3089: end if;
3090: end if;
3091: l_clock_status := 'U';

Line 3088: raise fnd_api.g_exc_unexpected_error;

3084: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.clock_out',
3085: p_params => l_params,
3086: x_returnStatus => x_status);
3087: if(x_status <> fnd_api.g_ret_sts_success) then
3088: raise fnd_api.g_exc_unexpected_error;
3089: end if;
3090: end if;
3091: l_clock_status := 'U';
3092: l_process_status := 3; --updated

Line 3193: if(x_status <> fnd_api.g_ret_sts_success) then

3189:
3190: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.undo_clock_in',
3191: p_params => l_params,
3192: x_returnStatus => x_status);
3193: if(x_status <> fnd_api.g_ret_sts_success) then
3194: raise fnd_api.g_exc_unexpected_error;
3195: end if;
3196: end if;
3197: l_clock_status := 'U';

Line 3194: raise fnd_api.g_exc_unexpected_error;

3190: wip_logger.entryPoint(p_procName => 'WIP_WS_TIME_ENTRY.undo_clock_in',
3191: p_params => l_params,
3192: x_returnStatus => x_status);
3193: if(x_status <> fnd_api.g_ret_sts_success) then
3194: raise fnd_api.g_exc_unexpected_error;
3195: end if;
3196: end if;
3197: l_clock_status := 'U';
3198: if(l_logLevel <= wip_constants.trace_logging) then

Line 3663: raise fnd_api.g_exc_unexpected_error;

3659: open_past_period => l_openPastPeriod);
3660:
3661: if(l_acctPeriodID is null or
3662: l_acctPeriodID <= 0) then
3663: raise fnd_api.g_exc_unexpected_error;
3664: end if;
3665:
3666: if (l_logLevel <= wip_constants.full_logging) then
3667: wip_logger.log('derive_insert_wcti Phase 80', l_retStatus);

Line 3901: x_return_status := fnd_api.g_ret_sts_success;

3897: -- We need to clear the group ID then only processor will process this record
3898: update wip_cost_txn_interface set group_id = NULL where group_id = x_group_id;
3899: -- Bug 13481688 @End
3900: end if;
3901: x_return_status := fnd_api.g_ret_sts_success;
3902: if (l_logLevel <= wip_constants.trace_logging) then
3903: wip_logger.exitPoint(p_procName => 'WIP_WS_TIME_ENTRY.derive_insert_wcti',
3904: p_procReturnStatus => x_return_status,
3905: p_msg => l_msg,

Line 3912: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

3908: end if;
3909:
3910: Exception
3911: when others then
3912: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
3913: l_msg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
3914: if (l_logLevel <= wip_constants.trace_logging) then
3915: wip_logger.exitPoint(p_procName => 'WIP_WS_TIME_ENTRY.derive_insert_wcti',
3916: p_procReturnStatus => x_return_status,

Line 4018: x_ret_status := fnd_api.G_RET_STS_UNEXP_ERROR;

4014: exception when others then
4015: x_entity_id := null;
4016: x_op_seq := null;
4017: x_start_date := null;
4018: x_ret_status := fnd_api.G_RET_STS_UNEXP_ERROR;
4019: END get_cur_clocked_job;
4020:
4021: END WIP_WS_TIME_ENTRY;