APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on FND_API

Line 12094: IF x_return_status = fnd_api.g_ret_sts_success THEN

12090: , x_return_status => x_return_status
12091: , x_msg_data => x_msg_data
12092: , x_msg_count => x_msg_count
12093: );
12094: IF x_return_status = fnd_api.g_ret_sts_success THEN
12095: UPDATE wms_waveplan_tasks_temp
12096: SET RESULT = 'S',
12097: error = 'Task Cancelled',
12098: is_modified = 'N'

Line 12176: x_return_status := fnd_api.g_ret_sts_success;

12172: x_status_chart_data (l_loop_index).task_count := c1.task_count;
12173: END LOOP;
12174:
12175: x_status_data_count := l_loop_index;
12176: x_return_status := fnd_api.g_ret_sts_success;
12177: EXCEPTION
12178: WHEN OTHERS
12179: THEN
12180: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 12180: x_return_status := fnd_api.g_ret_sts_unexp_error;

12176: x_return_status := fnd_api.g_ret_sts_success;
12177: EXCEPTION
12178: WHEN OTHERS
12179: THEN
12180: x_return_status := fnd_api.g_ret_sts_unexp_error;
12181: DEBUG (SQLERRM, 'Task_planning.get_status_dist');
12182: END get_status_dist;
12183:
12184: -- This procedure will populate the required data for the performance chart

Line 12222: x_return_status := fnd_api.g_ret_sts_success;

12218: x_type_chart_data (l_loop_index).task_count := c1.task_count;
12219: END LOOP;
12220:
12221: x_type_data_count := l_loop_index;
12222: x_return_status := fnd_api.g_ret_sts_success;
12223: EXCEPTION
12224: WHEN OTHERS
12225: THEN
12226: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 12226: x_return_status := fnd_api.g_ret_sts_unexp_error;

12222: x_return_status := fnd_api.g_ret_sts_success;
12223: EXCEPTION
12224: WHEN OTHERS
12225: THEN
12226: x_return_status := fnd_api.g_ret_sts_unexp_error;
12227: DEBUG (SQLERRM, 'Task_planning.get_type_dist');
12228: END get_type_dist;
12229:
12230: PROCEDURE calculate_summary (

Line 12736: IF l_return_status = fnd_api.g_ret_sts_success

12732: if l_debug = 1 then
12733: DEBUG ('ret status from atf cancel ' || l_return_status);
12734: end if;
12735:
12736: IF l_return_status = fnd_api.g_ret_sts_success
12737: THEN
12738: x_ret_code (i) := fnd_api.g_ret_sts_success;
12739: if l_debug = 1 then
12740: DEBUG ('success for ' || i || ' ' || x_ret_code (i));

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

12734: end if;
12735:
12736: IF l_return_status = fnd_api.g_ret_sts_success
12737: THEN
12738: x_ret_code (i) := fnd_api.g_ret_sts_success;
12739: if l_debug = 1 then
12740: DEBUG ('success for ' || i || ' ' || x_ret_code (i));
12741: end if;
12742: ELSE

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

12758: SET is_modified = 'Y',
12759: status_id = 12,
12760: status = g_status_codes(12)
12761: WHERE transaction_temp_id = p_transaction_temp_table (i)
12762: AND x_ret_code (i) = fnd_api.g_ret_sts_success;
12763:
12764: if l_debug = 1 then
12765: DEBUG ('No of records updated are' || SQL%ROWCOUNT);
12766: end if;

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

12768: FORALL j IN 1..p_transaction_temp_table.COUNT
12769: DELETE FROM wms_waveplan_tasks_temp
12770: WHERE parent_line_id = p_transaction_temp_table (j)
12771: AND status_id = 1
12772: AND x_ret_code (j) = fnd_api.g_ret_sts_success;
12773:
12774: if l_debug = 1 then
12775: DEBUG ('No of records deleted are' || SQL%ROWCOUNT);
12776: end if;

Line 12778: x_return_status := fnd_api.g_ret_sts_success;

12774: if l_debug = 1 then
12775: DEBUG ('No of records deleted are' || SQL%ROWCOUNT);
12776: end if;
12777:
12778: x_return_status := fnd_api.g_ret_sts_success;
12779: EXCEPTION
12780: WHEN OTHERS
12781: THEN
12782: DEBUG ('other exception in cancel_plans ' || SQLERRM);

Line 12783: x_return_status := fnd_api.g_ret_sts_unexp_error;

12779: EXCEPTION
12780: WHEN OTHERS
12781: THEN
12782: DEBUG ('other exception in cancel_plans ' || SQLERRM);
12783: x_return_status := fnd_api.g_ret_sts_unexp_error;
12784: END cancel_plans;
12785:
12786:
12787: FUNCTION get_final_query