486: to_char(sysdate,'HH:MI:SS') );
487:
488: execute immediate ('Truncate table ' || l_pa_schema || '.pa_txn_upgrade_temp');
489:
490: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling pa_uom.get_uom for updating UOM Meaning '|| to_char(sysdate,'HH:MI:SS') );
491:
492: l_get_uom := 'F';
493:
494: l_get_uom := pa_uom.get_uom(fnd_global.USER_ID);
490: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling pa_uom.get_uom for updating UOM Meaning '|| to_char(sysdate,'HH:MI:SS') );
491:
492: l_get_uom := 'F';
493:
494: l_get_uom := pa_uom.get_uom(fnd_global.USER_ID);
495:
496: IF (l_get_uom = 'S') THEN
497:
498: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Successfully Updated UOM Meanings in PA '|| to_char(sysdate,'HH:MI:SS'));