DBA Data[Home] [Help]

APPS.ITA_RECORD_CURR_STATUS_PKG dependencies on FND_CONCURRENT

Line 31: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Current State not fetched.');

27:
28: IF l_app_id = -1
29: THEN
30: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Table ' || p_table_name || ' does not exist in fnd_tables.');
31: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Current State not fetched.');
32: RETURN;
33: END IF;
34: l_ret_code := enable_tracking_for_table(l_app_id, p_table_name);
35: IF l_ret_code = 0

Line 37: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Current State not fetched.');

33: END IF;
34: l_ret_code := enable_tracking_for_table(l_app_id, p_table_name);
35: IF l_ret_code = 0
36: THEN
37: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Current State not fetched.');
38: ELSE
39: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', 'Current State fetched.');
40: END IF;
41: RETURN;

Line 39: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', 'Current State fetched.');

35: IF l_ret_code = 0
36: THEN
37: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Current State not fetched.');
38: ELSE
39: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', 'Current State fetched.');
40: END IF;
41: RETURN;
42: ELSE
43: FOR l_table IN c_all_tables

Line 137: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', errbuf);

133: -- Status - NORMAL, WARNING, ERROR
134: IF l_set_warn = TRUE
135: THEN
136: errbuf := 'Current state fetched for some of the tables.';
137: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', errbuf);
138: retcode := FND_API.G_RET_STS_SUCCESS;
139: ELSE
140: errbuf := 'Current state fetched.';
141: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', errbuf);

Line 141: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', errbuf);

137: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', errbuf);
138: retcode := FND_API.G_RET_STS_SUCCESS;
139: ELSE
140: errbuf := 'Current state fetched.';
141: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', errbuf);
142: retcode := FND_API.G_RET_STS_SUCCESS;
143: END IF;
144: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Finished fetching current configuration.');
145: EXCEPTION WHEN OTHERS

Line 147: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Current State not fetched.');

143: END IF;
144: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Finished fetching current configuration.');
145: EXCEPTION WHEN OTHERS
146: THEN
147: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Current State not fetched.');
148: errbuf := SQLERRM;
149: retcode := FND_API.G_RET_STS_UNEXP_ERROR;
150: END enable_tracking;
151:

Line 211: --l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Audit Start date not set for ' || p_table_name);

207: WHEN OTHERS
208: THEN
209: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
210: -- dbms_output.put_line(SUBSTR (SQLERRM, 1, 2000));
211: --l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Audit Start date not set for ' || p_table_name);
212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Audit Start Date not set for ' || p_table_name);
213: RETURN 0;
214: END set_audit_start_date;
215:

Line 350: --l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Shadow trigger not created for ' || p_table_name);

346: WHEN OTHERS
347: THEN
348: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
349: --dbms_output.put_line(SUBSTR (SQLERRM, 1, 2000));
350: --l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Shadow trigger not created for ' || p_table_name);
351: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Shadow trigger not created for ' || p_table_name);
352: RETURN 0;
353: END create_shadow_trigger;
354:

Line 603: --l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Current state not fetched for ' || p_table_name);

599: WHEN OTHERS
600: THEN
601: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
602: --dbms_output.put_line(SUBSTR (SQLERRM, 1, 2000));
603: --l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Current state not fetched for ' || p_table_name);
604: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current state not fetched for ' || p_table_name);
605: RETURN 0;
606: END record_current_state;
607:

Line 850: --l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Current state not fetched for ' || p_table_name);

846: WHEN OTHERS
847: THEN
848: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
849: --dbms_output.put_line(SUBSTR (SQLERRM, 1, 2000));
850: --l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Current state not fetched for ' || p_table_name);
851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current state not fetched for ' || p_table_name);
852: RETURN 0;
853: END record_profile_current_state;
854: