DBA Data[Home] [Help]

APPS.JE_IT_TAX_EX_UPGRADE2 dependencies on FND_FILE

Line 26: fnd_file.put_line(fnd_file.log, 'Org id: '||l_org_id);

22: -- Get the profile org id.
23: l_org_id := FND_PROFILE.VALUE('ORG_ID');
24: IF l_org_id IS NOT NULL THEN
25:
26: fnd_file.put_line(fnd_file.log, 'Org id: '||l_org_id);
27:
28: --commented for bug 5408438
29: -- xle_upgrade_utils.get_default_legal_context(x_return_status => l_return_status,
30: -- x_msg_count => l_msg_count,

Line 46: fnd_file.put_line(fnd_file.log, 'Ret Status: '||l_return_status);

42: l_return_status := 'E';
43: l_msg_data := SQLERRM;
44: END;
45:
46: fnd_file.put_line(fnd_file.log, 'Ret Status: '||l_return_status);
47: fnd_file.put_line(fnd_file.log, 'Msg Data: '||l_msg_data);
48:
49: -- If the return status is not error, then continue with the process
50: IF l_return_status IS NULL THEN

Line 47: fnd_file.put_line(fnd_file.log, 'Msg Data: '||l_msg_data);

43: l_msg_data := SQLERRM;
44: END;
45:
46: fnd_file.put_line(fnd_file.log, 'Ret Status: '||l_return_status);
47: fnd_file.put_line(fnd_file.log, 'Msg Data: '||l_msg_data);
48:
49: -- If the return status is not error, then continue with the process
50: IF l_return_status IS NULL THEN
51:

Line 60: FND_FILE.PUT_LINE(FND_FILE.LOG,l_message);

56: WHERE legal_entity_id IS NULL;
57:
58: l_message := 'Updated '||SQL%ROWCOUNT||' records in je_it_exlet_seqs with legal entity id: '
59: ||l_legal_entity_id;
60: FND_FILE.PUT_LINE(FND_FILE.LOG,l_message);
61:
62: ELSE
63: -- IF legal entity id is null.
64: l_message := 'Unable to Update Legal Entities for the tables je_it_exlet_seqs

Line 66: FND_FILE.PUT_LINE( FND_FILE.LOG,l_message);

62: ELSE
63: -- IF legal entity id is null.
64: l_message := 'Unable to Update Legal Entities for the tables je_it_exlet_seqs
65: because no Legal Entity was found.';
66: FND_FILE.PUT_LINE( FND_FILE.LOG,l_message);
67: retcode := 2;
68: errbuf := l_message;
69: RETURN;
70: END IF;

Line 75: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);

71:
72: ELSE -- If return status is Error
73:
74: l_message := 'Error - Upgrade process could not complete: '||l_msg_data;
75: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
76: retcode := 2;
77: errbuf := l_message;
78: RETURN;
79: END IF;

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

80:
81: END IF;
82:
83: l_message := 'Upgrade completed successfully.';
84: fnd_file.put_line(fnd_file.log,l_message);
85:
86: COMMIT;
87:
88:

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

90: ROLLBACK;
91: l_message := 'Error - Upgrade process could not complete: '||sqlcode||': '||sqlerrm;
92: retcode := 2;
93: errbuf := l_message;
94: fnd_file.put_line(fnd_file.log, l_message);
95:
96: END upgrade_main;
97:
98: END je_it_tax_ex_upgrade2;