APPS.JE_IT_TAX_EX_UPGRADE dependencies on FND_FILE

Line 14: fnd_file.put_line(fnd_file.log, 'Input parameters:');

10: l_row_count NUMBER := 0;
11:
12: BEGIN
13:
14: fnd_file.put_line(fnd_file.log, 'Input parameters:');
15: fnd_file.put_line(fnd_file.log, 'Set of Books ID: '||p_set_of_books_id );
16: fnd_file.put_line(fnd_file.log, 'Legal Entity ID: '||p_legal_entity_id);
17:
18: retcode := 0;

Line 15: fnd_file.put_line(fnd_file.log, 'Set of Books ID: '||p_set_of_books_id );

11:
12: BEGIN
13:
14: fnd_file.put_line(fnd_file.log, 'Input parameters:');
15: fnd_file.put_line(fnd_file.log, 'Set of Books ID: '||p_set_of_books_id );
16: fnd_file.put_line(fnd_file.log, 'Legal Entity ID: '||p_legal_entity_id);
17:
18: retcode := 0;
19: errbuf := NULL;

Line 16: fnd_file.put_line(fnd_file.log, 'Legal Entity ID: '||p_legal_entity_id);

12: BEGIN
13:
14: fnd_file.put_line(fnd_file.log, 'Input parameters:');
15: fnd_file.put_line(fnd_file.log, 'Set of Books ID: '||p_set_of_books_id );
16: fnd_file.put_line(fnd_file.log, 'Legal Entity ID: '||p_legal_entity_id);
17:
18: retcode := 0;
19: errbuf := NULL;
20:

Line 33: fnd_file.put_line(fnd_file.log,l_message);

29:
30: l_message := 'Updated '||SQL%ROWCOUNT||' rows in table je_it_year_ex_limit with
31: legal entity id: '||p_legal_entity_id||
32: ' for set of books id: '||p_set_of_books_id;
33: fnd_file.put_line(fnd_file.log,l_message);
34:
35: UPDATE je_it_exempt_letters
36: SET legal_entity_id = p_legal_entity_id
37: WHERE set_of_books_id = p_set_of_books_id

Line 43: fnd_file.put_line(fnd_file.log,l_message);

39:
40: l_message := 'Updated '||SQL%ROWCOUNT||' rows in table je_it_exempt_letters with
41: legal entity id: '||p_legal_entity_id||
42: ' for set of books id: '||p_set_of_books_id;
43: fnd_file.put_line(fnd_file.log,l_message);
44:
45: ELSE
46:
47: l_message := 'Legal Entity ID is not provided. Please provide Legal Entity ID for this upgrade.';

Line 48: fnd_file.put_line(fnd_file.log,l_message);

44:
45: ELSE
46:
47: l_message := 'Legal Entity ID is not provided. Please provide Legal Entity ID for this upgrade.';
48: fnd_file.put_line(fnd_file.log,l_message);
49:
50: ROLLBACK;
51: retcode := 2;
52: errbuf := l_message;

Line 57: fnd_file.put_line(fnd_file.log,l_message);

53: END IF;
54:
55: IF retcode = 0 THEN
56: l_message := 'Upgrade completed successfully.';
57: fnd_file.put_line(fnd_file.log,l_message);
58: COMMIT;
59: END IF;
60:
61: EXCEPTION WHEN OTHERS THEN

Line 66: fnd_file.put_line(fnd_file.log, l_message);

62: ROLLBACK;
63: l_message := sqlcode||': '||sqlerrm;
64: retcode := 2;
65: errbuf := l_message;
66: fnd_file.put_line(fnd_file.log, l_message);
67:
68: END upgrade_main;
69:
70: END je_it_tax_ex_upgrade;