DBA Data[Home] [Help]

APPS.JL_ZZ_PO_LIBRARY_1_PKG dependencies on FND_FILE

Line 138: fnd_file.put_line( FND_FILE.LOG, 'Calling JL_ZZ_PO_LIBRARY_1_PKG.get_trx_reason1:Org_id: '||org_id );

134: row_number IN NUMBER,
135: Errcd IN OUT NOCOPY NUMBER) IS
136: BEGIN
137: Errcd := 0;
138: fnd_file.put_line( FND_FILE.LOG, 'Calling JL_ZZ_PO_LIBRARY_1_PKG.get_trx_reason1:Org_id: '||org_id );
139: SELECT global_attribute2, global_attribute1
140: INTO trx_reason, fcc
141: FROM mtl_system_items mtl
142: WHERE (mtl.organization_id = org_id OR (mtl.organization_id IN (SELECT ood.organization_id

Line 149: fnd_file.put_line( FND_FILE.LOG, 'In get_trx_reason1:Transaction Reason: '||trx_reason );

145: )
146: ))
147: AND mtl.inventory_item_id = item_id
148: AND rownum = row_number;
149: fnd_file.put_line( FND_FILE.LOG, 'In get_trx_reason1:Transaction Reason: '||trx_reason );
150: EXCEPTION
151: WHEN OTHERS THEN
152: Errcd := SQLCODE;
153: END get_trx_reason1;