APPS.FEM_INTF_DIM_VALIDATION_PKG dependencies on FND_CONCURRENT

Line 144: v_req_id FND_CONCURRENT_REQUESTS.request_id%TYPE;

140: v_old NUMBER;
141: v_end NUMBER;
142: v_next_occurrence NUMBER;
143: v_dimension_name_part VARCHAR2(200);
144: v_req_id FND_CONCURRENT_REQUESTS.request_id%TYPE;
145: v_main_sql_stmt VARCHAR2(32767);
146: v_table_update_stmt VARCHAR2(32767);
147: v_table_select_stmt VARCHAR2(32767);
148: v_count NUMBER;

Line 716: v_dummy_boolean := FND_CONCURRENT.Set_Completion_Status

712: --
713: -- End the concurrent program with the 'WARNING' 'ERROR' or 'NORMAL' status
714: --
715: IF v_no_data_found THEN
716: v_dummy_boolean := FND_CONCURRENT.Set_Completion_Status
717: (status => 'WARNING', message => NULL);
718: ELSIF v_invalid_dims_found THEN
719: v_dummy_boolean := FND_CONCURRENT.Set_Completion_Status
720: (status => 'ERROR', message => NULL);

Line 719: v_dummy_boolean := FND_CONCURRENT.Set_Completion_Status

715: IF v_no_data_found THEN
716: v_dummy_boolean := FND_CONCURRENT.Set_Completion_Status
717: (status => 'WARNING', message => NULL);
718: ELSIF v_invalid_dims_found THEN
719: v_dummy_boolean := FND_CONCURRENT.Set_Completion_Status
720: (status => 'ERROR', message => NULL);
721: ELSE
722: v_dummy_boolean := FND_CONCURRENT.Set_Completion_Status
723: (status => 'NORMAL', message => NULL);

Line 722: v_dummy_boolean := FND_CONCURRENT.Set_Completion_Status

718: ELSIF v_invalid_dims_found THEN
719: v_dummy_boolean := FND_CONCURRENT.Set_Completion_Status
720: (status => 'ERROR', message => NULL);
721: ELSE
722: v_dummy_boolean := FND_CONCURRENT.Set_Completion_Status
723: (status => 'NORMAL', message => NULL);
724: END IF;
725: -- Bug 5398129 hkaniven end
726:

Line 743: v_dummy_boolean := FND_CONCURRENT.Set_Completion_Status

739: p_token2 => 'TIME',
740: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
741: END IF;
742:
743: v_dummy_boolean := FND_CONCURRENT.Set_Completion_Status
744: (status => 'ERROR', message => NULL);
745: WHEN OTHERS THEN
746: ROLLBACK;
747:

Line 776: v_dummy_boolean := FND_CONCURRENT.Set_Completion_Status

772: p_token2 => 'TIME',
773: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
774: END IF;
775:
776: v_dummy_boolean := FND_CONCURRENT.Set_Completion_Status
777: (status => 'ERROR', message => NULL);
778: END Main;
779:
780: -- ======================================================================