DBA Data[Home] [Help]

APPS.JE_IT_TAX_EX_UPGRADE2 dependencies on JE_IT_EXLET_SEQS

Line 54: UPDATE je_it_exlet_seqs

50: IF l_return_status IS NULL THEN
51:
52: IF l_legal_entity_id IS NOT NULL THEN
53:
54: UPDATE je_it_exlet_seqs
55: SET legal_entity_id = l_legal_entity_id
56: WHERE legal_entity_id IS NULL;
57:
58: l_message := 'Updated '||SQL%ROWCOUNT||' records in je_it_exlet_seqs with legal entity id: '

Line 58: l_message := 'Updated '||SQL%ROWCOUNT||' records in je_it_exlet_seqs with legal entity id: '

54: UPDATE je_it_exlet_seqs
55: SET legal_entity_id = l_legal_entity_id
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

Line 64: l_message := 'Unable to Update Legal Entities for the tables je_it_exlet_seqs

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
65: because no Legal Entity was found.';
66: FND_FILE.PUT_LINE( FND_FILE.LOG,l_message);
67: retcode := 2;
68: errbuf := l_message;