APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on FND_API

Line 10951: IF x_return_status = fnd_api.g_ret_sts_success THEN

10947: , x_return_status => x_return_status
10948: , x_msg_data => x_msg_data
10949: , x_msg_count => x_msg_count
10950: );
10951: IF x_return_status = fnd_api.g_ret_sts_success THEN
10952: UPDATE wms_waveplan_tasks_temp
10953: SET RESULT = 'S',
10954: error = 'Task Cancelled',
10955: is_modified = 'N'

Line 11033: x_return_status := fnd_api.g_ret_sts_success;

11029: x_status_chart_data (l_loop_index).task_count := c1.task_count;
11030: END LOOP;
11031:
11032: x_status_data_count := l_loop_index;
11033: x_return_status := fnd_api.g_ret_sts_success;
11034: EXCEPTION
11035: WHEN OTHERS
11036: THEN
11037: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 11037: x_return_status := fnd_api.g_ret_sts_unexp_error;

11033: x_return_status := fnd_api.g_ret_sts_success;
11034: EXCEPTION
11035: WHEN OTHERS
11036: THEN
11037: x_return_status := fnd_api.g_ret_sts_unexp_error;
11038: DEBUG (SQLERRM, 'Task_planning.get_status_dist');
11039: END get_status_dist;
11040:
11041: -- This procedure will populate the required data for the performance chart

Line 11079: x_return_status := fnd_api.g_ret_sts_success;

11075: x_type_chart_data (l_loop_index).task_count := c1.task_count;
11076: END LOOP;
11077:
11078: x_type_data_count := l_loop_index;
11079: x_return_status := fnd_api.g_ret_sts_success;
11080: EXCEPTION
11081: WHEN OTHERS
11082: THEN
11083: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 11083: x_return_status := fnd_api.g_ret_sts_unexp_error;

11079: x_return_status := fnd_api.g_ret_sts_success;
11080: EXCEPTION
11081: WHEN OTHERS
11082: THEN
11083: x_return_status := fnd_api.g_ret_sts_unexp_error;
11084: DEBUG (SQLERRM, 'Task_planning.get_type_dist');
11085: END get_type_dist;
11086:
11087: PROCEDURE calculate_summary (

Line 11593: IF l_return_status = fnd_api.g_ret_sts_success

11589: if l_debug = 1 then
11590: DEBUG ('ret status from atf cancel ' || l_return_status);
11591: end if;
11592:
11593: IF l_return_status = fnd_api.g_ret_sts_success
11594: THEN
11595: x_ret_code (i) := fnd_api.g_ret_sts_success;
11596: if l_debug = 1 then
11597: DEBUG ('success for ' || i || ' ' || x_ret_code (i));

Line 11595: x_ret_code (i) := fnd_api.g_ret_sts_success;

11591: end if;
11592:
11593: IF l_return_status = fnd_api.g_ret_sts_success
11594: THEN
11595: x_ret_code (i) := fnd_api.g_ret_sts_success;
11596: if l_debug = 1 then
11597: DEBUG ('success for ' || i || ' ' || x_ret_code (i));
11598: end if;
11599: ELSE

Line 11619: AND x_ret_code (i) = fnd_api.g_ret_sts_success;

11615: SET is_modified = 'Y',
11616: status_id = 12,
11617: status = g_status_codes(12)
11618: WHERE transaction_temp_id = p_transaction_temp_table (i)
11619: AND x_ret_code (i) = fnd_api.g_ret_sts_success;
11620:
11621: if l_debug = 1 then
11622: DEBUG ('No of records updated are' || SQL%ROWCOUNT);
11623: end if;

Line 11629: AND x_ret_code (j) = fnd_api.g_ret_sts_success;

11625: FORALL j IN 1..p_transaction_temp_table.COUNT
11626: DELETE FROM wms_waveplan_tasks_temp
11627: WHERE parent_line_id = p_transaction_temp_table (j)
11628: AND status_id = 1
11629: AND x_ret_code (j) = fnd_api.g_ret_sts_success;
11630:
11631: if l_debug = 1 then
11632: DEBUG ('No of records deleted are' || SQL%ROWCOUNT);
11633: end if;

Line 11635: x_return_status := fnd_api.g_ret_sts_success;

11631: if l_debug = 1 then
11632: DEBUG ('No of records deleted are' || SQL%ROWCOUNT);
11633: end if;
11634:
11635: x_return_status := fnd_api.g_ret_sts_success;
11636: EXCEPTION
11637: WHEN OTHERS
11638: THEN
11639: DEBUG ('other exception in cancel_plans ' || SQLERRM);

Line 11640: x_return_status := fnd_api.g_ret_sts_unexp_error;

11636: EXCEPTION
11637: WHEN OTHERS
11638: THEN
11639: DEBUG ('other exception in cancel_plans ' || SQLERRM);
11640: x_return_status := fnd_api.g_ret_sts_unexp_error;
11641: END cancel_plans;
11642:
11643:
11644: FUNCTION get_final_query