APPS.JE_ES_MODELO_190_ALL_UPGRADE dependencies on FND_FILE

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

22: l_org_id := FND_PROFILE.VALUE('ORG_ID');
23:
24: IF l_org_id IS NOT NULL THEN
25:
26: fnd_file.put_line(fnd_file.log, 'Org id: '||l_org_id);
27: xle_upgrade_utils.get_default_legal_context(x_return_status => l_return_status,
28: x_msg_count => l_msg_count,
29: x_msg_data => l_msg_data,
30: p_org_id => l_org_id,

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

29: x_msg_data => l_msg_data,
30: p_org_id => l_org_id,
31: x_dlc => l_legal_entity_id);
32:
33: fnd_file.put_line(fnd_file.log, 'Ret Status: '||l_return_status);
34: fnd_file.put_line(fnd_file.log, 'Msg Data: '||l_msg_data);
35:
36: -- If the return status is not error, then continue with the process
37: IF l_return_status IS NULL THEN

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

30: p_org_id => l_org_id,
31: x_dlc => l_legal_entity_id);
32:
33: fnd_file.put_line(fnd_file.log, 'Ret Status: '||l_return_status);
34: fnd_file.put_line(fnd_file.log, 'Msg Data: '||l_msg_data);
35:
36: -- If the return status is not error, then continue with the process
37: IF l_return_status IS NULL THEN
38:

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

43: WHERE legal_entity_id IS NULL
44: AND org_id IS NULL;
45:
46: l_message := 'Updated '||SQL%ROWCOUNT||' rows in table JE_ES_MODELO_190_ALL with legal entity id: '||l_legal_entity_id;
47: fnd_file.put_line(fnd_file.log,l_message);
48:
49: ELSE
50: -- IF legal entity id is null.
51: l_message := 'Unable to Update Legal Entities for the table je_es_modelo_190_all

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

49: ELSE
50: -- IF legal entity id is null.
51: l_message := 'Unable to Update Legal Entities for the table je_es_modelo_190_all
52: because no Legal Entity was found.';
53: fnd_file.put_line(fnd_file.log,l_message);
54:
55: ROLLBACK;
56: retcode := 2;
57: errbuf := l_message;

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

60:
61: ELSE
62:
63: l_message := 'Error - Upgrade process could not complete: '||l_msg_data;
64: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
65: retcode := 2;
66: errbuf := l_message;
67: RETURN;
68:

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

70:
71: END IF;
72:
73: l_message := 'Upgrade completed successfully.';
74: fnd_file.put_line(fnd_file.log,l_message);
75: COMMIT;
76:
77: EXCEPTION WHEN OTHERS THEN
78: ROLLBACK;

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

78: ROLLBACK;
79: l_message := 'Error - Upgrade process could not complete: '||sqlcode||': '||sqlerrm;
80: retcode := 2;
81: errbuf := l_message;
82: fnd_file.put_line(fnd_file.log, l_message);
83:
84: END upgrade_main;
85:
86: END je_es_modelo_190_all_upgrade;